APPS.CST_START_IMP_PROCESS dependencies on FND_GLOBAL

Line 41: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID

37: /*check first to see if there is another request running with similar parameters */
38:
39: select FCR.argument5 into l_req_arg
40: from FND_CONCURRENT_REQUESTS FCR
41: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
42: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
43: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
44:
45: select min(FCR.request_id) into l_min_reqid

Line 42: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID

38:
39: select FCR.argument5 into l_req_arg
40: from FND_CONCURRENT_REQUESTS FCR
41: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
42: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
43: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
44:
45: select min(FCR.request_id) into l_min_reqid
46: from FND_CONCURRENT_REQUESTS FCR

Line 43: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;

39: select FCR.argument5 into l_req_arg
40: from FND_CONCURRENT_REQUESTS FCR
41: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
42: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
43: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
44:
45: select min(FCR.request_id) into l_min_reqid
46: from FND_CONCURRENT_REQUESTS FCR
47: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID

Line 47: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID

43: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
44:
45: select min(FCR.request_id) into l_min_reqid
46: from FND_CONCURRENT_REQUESTS FCR
47: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
48: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
49: AND FCR.phase_code <> 'C'
50: AND ((NVL(FCR.argument5,'X') = NVL(l_req_arg,'X'))
51: OR (FCR.argument5 is null)

Line 48: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID

44:
45: select min(FCR.request_id) into l_min_reqid
46: from FND_CONCURRENT_REQUESTS FCR
47: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
48: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
49: AND FCR.phase_code <> 'C'
50: AND ((NVL(FCR.argument5,'X') = NVL(l_req_arg,'X'))
51: OR (FCR.argument5 is null)
52: OR (l_req_arg is null));

Line 54: if (NVL(l_min_reqid,FND_GLOBAL.CONC_REQUEST_ID) <> FND_GLOBAL.CONC_REQUEST_ID) then

50: AND ((NVL(FCR.argument5,'X') = NVL(l_req_arg,'X'))
51: OR (FCR.argument5 is null)
52: OR (l_req_arg is null));
53:
54: if (NVL(l_min_reqid,FND_GLOBAL.CONC_REQUEST_ID) <> FND_GLOBAL.CONC_REQUEST_ID) then
55: fnd_file.put_line(fnd_file.log,fnd_message.get_string('BOM','CST_REQ_ERROR'));
56: CONC_STATUS := fnd_concurrent.set_completion_status('ERROR',substr(fnd_message.get_string('BOM','CST_REQ_ERROR'),1,240));
57: return;
58: end if;