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博客 ” ，链接：https://blog.itpub.net/45788/viewspace-1009664/ ，如需转载，请注明出处，否则将追究法律责任。
