APPS.CST_REVENUECOGSMATCH_PVT dependencies on FND_GLOBAL

Line 143: l_request_id NUMBER; -- FND global settings

139:
140: program_exception EXCEPTION;
141: CONC_STATUS BOOLEAN; -- variable for concurrent request completion status
142:
143: l_request_id NUMBER; -- FND global settings
144: l_user_id NUMBER;
145: l_login_id NUMBER;
146: l_pgm_app_id NUMBER;
147: l_pgm_id NUMBER;

Line 194: l_request_id := FND_GLOBAL.conc_request_id;

190:
191: -- API Body
192:
193: -- Populate WHO column variables
194: l_request_id := FND_GLOBAL.conc_request_id;
195: l_user_id := FND_GLOBAL.user_id;
196: l_login_id := FND_GLOBAL.login_id;
197: l_pgm_app_id := FND_GLOBAL.PROG_APPL_ID;
198: l_pgm_id := FND_GLOBAL.CONC_PROGRAM_ID;

Line 195: l_user_id := FND_GLOBAL.user_id;

191: -- API Body
192:
193: -- Populate WHO column variables
194: l_request_id := FND_GLOBAL.conc_request_id;
195: l_user_id := FND_GLOBAL.user_id;
196: l_login_id := FND_GLOBAL.login_id;
197: l_pgm_app_id := FND_GLOBAL.PROG_APPL_ID;
198: l_pgm_id := FND_GLOBAL.CONC_PROGRAM_ID;
199:

Line 196: l_login_id := FND_GLOBAL.login_id;

192:
193: -- Populate WHO column variables
194: l_request_id := FND_GLOBAL.conc_request_id;
195: l_user_id := FND_GLOBAL.user_id;
196: l_login_id := FND_GLOBAL.login_id;
197: l_pgm_app_id := FND_GLOBAL.PROG_APPL_ID;
198: l_pgm_id := FND_GLOBAL.CONC_PROGRAM_ID;
199:
200:

Line 197: l_pgm_app_id := FND_GLOBAL.PROG_APPL_ID;

193: -- Populate WHO column variables
194: l_request_id := FND_GLOBAL.conc_request_id;
195: l_user_id := FND_GLOBAL.user_id;
196: l_login_id := FND_GLOBAL.login_id;
197: l_pgm_app_id := FND_GLOBAL.PROG_APPL_ID;
198: l_pgm_id := FND_GLOBAL.CONC_PROGRAM_ID;
199:
200:
201: -- Avoid multiple submission

Line 198: l_pgm_id := FND_GLOBAL.CONC_PROGRAM_ID;

194: l_request_id := FND_GLOBAL.conc_request_id;
195: l_user_id := FND_GLOBAL.user_id;
196: l_login_id := FND_GLOBAL.login_id;
197: l_pgm_app_id := FND_GLOBAL.PROG_APPL_ID;
198: l_pgm_id := FND_GLOBAL.CONC_PROGRAM_ID;
199:
200:
201: -- Avoid multiple submission
202: IF p_phase = 1 THEN l_prg_name := 'CSTRCMCR1';

Line 7373: AND FCR.request_id <> FND_GLOBAL.CONC_REQUEST_ID

7369: AND (FCR.argument3 = TO_CHAR(p_ledger_id) OR
7370: -- User submits a request for ledger A and CP for all ledger is running
7371: FCR.argument3 IS NULL)
7372: AND FCR.phase_code = 'R'
7373: AND FCR.request_id <> FND_GLOBAL.CONC_REQUEST_ID
7374: AND ROWNUM = 1;
7375:
7376: -- User submits CP for all ledgers and CP for ledger A is running
7377: CURSOR cu_exec_all(p_prg_id IN NUMBER) IS

Line 7383: AND FCR.request_id <> FND_GLOBAL.CONC_REQUEST_ID

7379: FROM fnd_concurrent_requests FCR
7380: WHERE FCR.program_application_id = 702
7381: AND FCR.concurrent_program_id = p_prg_id
7382: AND FCR.phase_code = 'R'
7383: AND FCR.request_id <> FND_GLOBAL.CONC_REQUEST_ID
7384: AND ROWNUM = 1; */
7385:
7386: CURSOR cu_exec IS
7387: SELECT FCP.user_concurrent_program_name

Line 7395: AND FCR.request_id <> FND_GLOBAL.CONC_REQUEST_ID

7391: AND (FCR.argument3 = TO_CHAR(p_ledger_id) OR
7392: -- User submits a request for ledger A and CP for all ledger is running
7393: FCR.argument3 IS NULL)
7394: AND FCR.phase_code = 'R'
7395: AND FCR.request_id <> FND_GLOBAL.CONC_REQUEST_ID
7396: AND FCR.concurrent_program_id = FCP.concurrent_program_id
7397: AND FCP.concurrent_program_name IN ('CSTRCMCR1','CSTRCMCR','CSTRCMCR3');
7398:
7399: CURSOR cu_exec_all IS

Line 7405: AND FCR.request_id <> FND_GLOBAL.CONC_REQUEST_ID

7401: FROM fnd_concurrent_requests FCR, fnd_concurrent_programs_vl FCP
7402: WHERE FCR.program_application_id = p_app_id
7403: AND FCP.application_id = p_app_id
7404: AND FCR.phase_code = 'R'
7405: AND FCR.request_id <> FND_GLOBAL.CONC_REQUEST_ID
7406: AND FCR.concurrent_program_id = FCP.concurrent_program_id
7407: AND FCP.concurrent_program_name IN ('CSTRCMCR1','CSTRCMCR','CSTRCMCR3');
7408:
7409: l_prg_id NUMBER;