Tags

, ,

Code to submit Process Lockbox
================================================
================================================/* Formatted on 3/6/2013 2:32:19 PM (QP5 v5.215.12089.38647) */
DECLARE
l_req_id   NUMBER;
BEGIN
FND_GLOBAL.APPS_INITIALIZE (0, 50268, 222);
l_req_id :=
FND_REQUEST.submit_request (
application   => ‘AR’,
program       => ‘ARLPLB’,
description   => NULL,
start_time    => NULL,
argument1     => ‘Y’                             — CODE_NEW_TRANS_YN                             ,
argument2     => NULL                              — TRANSMISSION_ID                              ,
argument3     => NULL                      — TRANSMISSION_REQUEST_ID                              ,
argument4     => ‘AR01268073’                    — TRANSMISSION_NAME                                      ,
argument5     => ‘Y’                            — CODE_RUN_IMPORT_YN                             ,
argument6     => ‘/inbox/AR013118_268073.dat’            — FILE_NAME                                                      ,
argument7     => ‘phs_wf_lb’                          — CONTROL_FILE                                     ,
argument8     => 1000                       — TRANSMISSION_FORMAT_ID                              ,
argument9     => ‘Y’                        — CODE_RUN_VALIDATION_YN                             ,
argument10    => ‘N’                — CODE_PAY_UNRELATED_INVOICES_YN                             ,
argument11    => 1189                                   — LOCKBOX_ID                              ,
argument12    => TO_CHAR (SYSDATE, ‘YYYY/MM/DD HH24:MI:SS’) — GL_DATE                                                                    ,
argument13    => ‘A’                            — CODE_REPORT_FORMAT                             ,
argument14    => ‘N’                      — CODE_COMPLETE_BATCHES_YN                             ,
argument15    => ‘Y’ –‘Y’                    — CODE_RUN_APPL_YN(Post Quick Cash)                             ,
argument16    => ‘N’                        — IGNORE_INVALID_TXN_NUM                             ,
argument17    => ‘N’                        — USSGL_Transaction_code                             ,
argument18    => NULL,
argument19    => TO_CHAR (104)  ,                            — ORG_ID
argument20    => ‘L’,
argument21    => NULL);
COMMIT;
DBMS_OUTPUT.put_line (‘ERROR’ || l_req_id);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (‘ERROR’ || SQLERRM);
END;
Advertisements