DBA Data[Home] [Help]

APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on FND_GLOBAL

Line 28: g_login_id NUMBER := fnd_global.conc_login_id;

24: no_trx EXCEPTION;
25: conc_fail EXCEPTION;
26: api_call_failed EXCEPTION;
27: g_cn_debug VARCHAR2(1) := fnd_profile.VALUE('CN_DEBUG');
28: g_login_id NUMBER := fnd_global.conc_login_id;
29: g_sysdate DATE := SYSDATE;
30: g_program_id NUMBER := fnd_global.conc_program_id;
31: g_user_id NUMBER := fnd_global.user_id;
32: g_request_id NUMBER := fnd_global.conc_request_id;

Line 30: g_program_id NUMBER := fnd_global.conc_program_id;

26: api_call_failed EXCEPTION;
27: g_cn_debug VARCHAR2(1) := fnd_profile.VALUE('CN_DEBUG');
28: g_login_id NUMBER := fnd_global.conc_login_id;
29: g_sysdate DATE := SYSDATE;
30: g_program_id NUMBER := fnd_global.conc_program_id;
31: g_user_id NUMBER := fnd_global.user_id;
32: g_request_id NUMBER := fnd_global.conc_request_id;
33: g_fetch_limit NUMBER := 10000;
34:

Line 31: g_user_id NUMBER := fnd_global.user_id;

27: g_cn_debug VARCHAR2(1) := fnd_profile.VALUE('CN_DEBUG');
28: g_login_id NUMBER := fnd_global.conc_login_id;
29: g_sysdate DATE := SYSDATE;
30: g_program_id NUMBER := fnd_global.conc_program_id;
31: g_user_id NUMBER := fnd_global.user_id;
32: g_request_id NUMBER := fnd_global.conc_request_id;
33: g_fetch_limit NUMBER := 10000;
34:
35:

Line 32: g_request_id NUMBER := fnd_global.conc_request_id;

28: g_login_id NUMBER := fnd_global.conc_login_id;
29: g_sysdate DATE := SYSDATE;
30: g_program_id NUMBER := fnd_global.conc_program_id;
31: g_user_id NUMBER := fnd_global.user_id;
32: g_request_id NUMBER := fnd_global.conc_request_id;
33: g_fetch_limit NUMBER := 10000;
34:
35:
36: TYPE g_rowid_tbl_type IS TABLE OF ROWID;

Line 221: l_user_id NUMBER(15) := fnd_global.user_id;

217: l_call_status BOOLEAN;
218: l_next_process VARCHAR2(30);
219: l_dummy VARCHAR2(500);
220: unfinished BOOLEAN := TRUE;
221: l_user_id NUMBER(15) := fnd_global.user_id;
222: l_resp_id NUMBER(15) := fnd_global.resp_id;
223: l_login_id NUMBER(15) := fnd_global.login_id;
224: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
225: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

Line 222: l_resp_id NUMBER(15) := fnd_global.resp_id;

218: l_next_process VARCHAR2(30);
219: l_dummy VARCHAR2(500);
220: unfinished BOOLEAN := TRUE;
221: l_user_id NUMBER(15) := fnd_global.user_id;
222: l_resp_id NUMBER(15) := fnd_global.resp_id;
223: l_login_id NUMBER(15) := fnd_global.login_id;
224: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
225: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
226: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

Line 223: l_login_id NUMBER(15) := fnd_global.login_id;

219: l_dummy VARCHAR2(500);
220: unfinished BOOLEAN := TRUE;
221: l_user_id NUMBER(15) := fnd_global.user_id;
222: l_resp_id NUMBER(15) := fnd_global.resp_id;
223: l_login_id NUMBER(15) := fnd_global.login_id;
224: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
225: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
226: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
227: x_debug NUMBER;

Line 224: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

220: unfinished BOOLEAN := TRUE;
221: l_user_id NUMBER(15) := fnd_global.user_id;
222: l_resp_id NUMBER(15) := fnd_global.resp_id;
223: l_login_id NUMBER(15) := fnd_global.login_id;
224: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
225: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
226: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
227: x_debug NUMBER;
228: debug_v NUMBER;

Line 225: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

221: l_user_id NUMBER(15) := fnd_global.user_id;
222: l_resp_id NUMBER(15) := fnd_global.resp_id;
223: l_login_id NUMBER(15) := fnd_global.login_id;
224: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
225: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
226: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
227: x_debug NUMBER;
228: debug_v NUMBER;
229: conc_status BOOLEAN;

Line 226: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

222: l_resp_id NUMBER(15) := fnd_global.resp_id;
223: l_login_id NUMBER(15) := fnd_global.login_id;
224: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
225: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
226: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
227: x_debug NUMBER;
228: debug_v NUMBER;
229: conc_status BOOLEAN;
230: l_sleep_time NUMBER := 180;

Line 409: l_user_id NUMBER(15) := fnd_global.user_id;

405: ();
406: loop_count NUMBER;
407: l_start_id cn_sca_process_batches.start_id%TYPE;
408: l_end_id cn_sca_process_batches.end_id%TYPE;
409: l_user_id NUMBER(15) := fnd_global.user_id;
410: l_login_id NUMBER(15) := fnd_global.login_id;
411: BEGIN
412: debugmsg('Allocation Process : Split Batches Start ');
413: debugmsg('Allocation Process : p_start_date = ' || p_start_date);

Line 410: l_login_id NUMBER(15) := fnd_global.login_id;

406: loop_count NUMBER;
407: l_start_id cn_sca_process_batches.start_id%TYPE;
408: l_end_id cn_sca_process_batches.end_id%TYPE;
409: l_user_id NUMBER(15) := fnd_global.user_id;
410: l_login_id NUMBER(15) := fnd_global.login_id;
411: BEGIN
412: debugmsg('Allocation Process : Split Batches Start ');
413: debugmsg('Allocation Process : p_start_date = ' || p_start_date);
414: debugmsg('Allocation Process : p_end_date = ' || p_end_date);

Line 738: , x_request_id => fnd_global.conc_request_id

734: cn_message_pkg.begin_batch(
735: x_process_type => 'ALLOCATION_PROCESS'
736: , x_parent_proc_audit_id => NULL
737: , x_process_audit_id => l_process_audit_id
738: , x_request_id => fnd_global.conc_request_id
739: , p_org_id => p_org_id
740: );
741: -- Convert the dates for the varchar2 parameters passed in from
742: -- concurrent program

Line 3162: , x_request_id => fnd_global.conc_request_id

3158: cn_message_pkg.begin_batch(
3159: x_process_type => 'SCATM'
3160: , x_parent_proc_audit_id => NULL
3161: , x_process_audit_id => l_process_audit_id
3162: , x_request_id => fnd_global.conc_request_id
3163: , p_org_id => p_org_id
3164: );
3165: debugmsg('SCA : Start of Credit Allocation using TM');
3166: debugmsg('SCA : process_audit_id is ' || l_process_audit_id);