ITPub博客

首页 > 应用开发 > IT综合 > 开发程序调用 导入日记账(Journal Import) 请求注意点

开发程序调用 导入日记账(Journal Import) 请求注意点

原创 IT综合 作者:huak 时间:2008-08-27 18:51:40 0 删除 编辑

Calling Journal Import program from plsql procedure

Pass source name and the SOB ID to get group_id and the interface_run_id

[@more@]

gl_journal_import_pkg.populate_interface_control
(user_je_source_name => lv_source_name,
GROUP_ID => lv_group_id,
set_of_books_id => lv_sob_id,
interface_run_id => lv_iface_run_id
);

Note: Make sure you are inserting the group_id generated while populating the GL_INTERFACE table.

Use this to submit the Import Program.
lv_glint_conc_output :=
fnd_request.submit_request (

application => 'SQLGL',
program => 'GLLEZL', -- "Journal Import Program"
description => NULL,
start_time => ,to_char(SYSDATE,'YYYY/MM/DD HH24:MI:SS'),
sub_request => FALSE,
argument1 => TO_CHAR(lv_iface_run_id),
argument2 => lv_sob_id,
argument3 => 'N',
argument4 => NULL,
argument5 => NULL,
argument6 => 'N',
argument7 => 'O,

argument8 => chr(0)
);

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/45788/viewspace-1009664/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-01-07

  • 博文量
    67
  • 访问量
    511033