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: TYPE g_rowid_tbl_type IS TABLE OF ROWID;

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: TYPE g_rowid_tbl_type IS TABLE OF ROWID;
36:

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

139: l_call_status BOOLEAN;
140: l_next_process VARCHAR2(30);
141: l_dummy VARCHAR2(500);
142: unfinished BOOLEAN := TRUE;
143: l_user_id NUMBER(15) := fnd_global.user_id;
144: l_resp_id NUMBER(15) := fnd_global.resp_id;
145: l_login_id NUMBER(15) := fnd_global.login_id;
146: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
147: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

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

140: l_next_process VARCHAR2(30);
141: l_dummy VARCHAR2(500);
142: unfinished BOOLEAN := TRUE;
143: l_user_id NUMBER(15) := fnd_global.user_id;
144: l_resp_id NUMBER(15) := fnd_global.resp_id;
145: l_login_id NUMBER(15) := fnd_global.login_id;
146: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
147: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
148: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

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

141: l_dummy VARCHAR2(500);
142: unfinished BOOLEAN := TRUE;
143: l_user_id NUMBER(15) := fnd_global.user_id;
144: l_resp_id NUMBER(15) := fnd_global.resp_id;
145: l_login_id NUMBER(15) := fnd_global.login_id;
146: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
147: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
148: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
149: x_debug NUMBER;

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

142: unfinished BOOLEAN := TRUE;
143: l_user_id NUMBER(15) := fnd_global.user_id;
144: l_resp_id NUMBER(15) := fnd_global.resp_id;
145: l_login_id NUMBER(15) := fnd_global.login_id;
146: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
147: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
148: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
149: x_debug NUMBER;
150: debug_v NUMBER;

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

143: l_user_id NUMBER(15) := fnd_global.user_id;
144: l_resp_id NUMBER(15) := fnd_global.resp_id;
145: l_login_id NUMBER(15) := fnd_global.login_id;
146: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
147: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
148: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
149: x_debug NUMBER;
150: debug_v NUMBER;
151: conc_status BOOLEAN;

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

144: l_resp_id NUMBER(15) := fnd_global.resp_id;
145: l_login_id NUMBER(15) := fnd_global.login_id;
146: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
147: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
148: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
149: x_debug NUMBER;
150: debug_v NUMBER;
151: conc_status BOOLEAN;
152: l_sleep_time NUMBER := 180;

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

327: ();
328: loop_count NUMBER;
329: l_start_id cn_sca_process_batches.start_id%TYPE;
330: l_end_id cn_sca_process_batches.end_id%TYPE;
331: l_user_id NUMBER(15) := fnd_global.user_id;
332: l_login_id NUMBER(15) := fnd_global.login_id;
333: BEGIN
334: debugmsg('Allocation Process : Split Batches Start ');
335: debugmsg('Allocation Process : p_start_date = ' || p_start_date);

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

328: loop_count NUMBER;
329: l_start_id cn_sca_process_batches.start_id%TYPE;
330: l_end_id cn_sca_process_batches.end_id%TYPE;
331: l_user_id NUMBER(15) := fnd_global.user_id;
332: l_login_id NUMBER(15) := fnd_global.login_id;
333: BEGIN
334: debugmsg('Allocation Process : Split Batches Start ');
335: debugmsg('Allocation Process : p_start_date = ' || p_start_date);
336: debugmsg('Allocation Process : p_end_date = ' || p_end_date);

Line 660: , x_request_id => fnd_global.conc_request_id

656: cn_message_pkg.begin_batch(
657: x_process_type => 'ALLOCATION_PROCESS'
658: , x_parent_proc_audit_id => NULL
659: , x_process_audit_id => l_process_audit_id
660: , x_request_id => fnd_global.conc_request_id
661: , p_org_id => p_org_id
662: );
663: -- Convert the dates for the varchar2 parameters passed in from
664: -- concurrent program

Line 2701: , x_request_id => fnd_global.conc_request_id

2697: cn_message_pkg.begin_batch(
2698: x_process_type => 'SCATM'
2699: , x_parent_proc_audit_id => NULL
2700: , x_process_audit_id => l_process_audit_id
2701: , x_request_id => fnd_global.conc_request_id
2702: , p_org_id => p_org_id
2703: );
2704: debugmsg('SCA : Start of Credit Allocation using TM');
2705: debugmsg('SCA : process_audit_id is ' || l_process_audit_id);