APPS.CST_PL_IMPORT dependencies on FND_GLOBAL

Line 208: where FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID

204: l_stmt_num := 15;
205:
206: Select FCR.argument18 into l_req_groupid
207: from FND_CONCURRENT_REQUESTS FCR
208: where FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
209: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
210: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
211:
212: Select min(FCR.request_id) into l_min_reqid

Line 209: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID

205:
206: Select FCR.argument18 into l_req_groupid
207: from FND_CONCURRENT_REQUESTS FCR
208: where FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
209: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
210: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
211:
212: Select min(FCR.request_id) into l_min_reqid
213: from FND_CONCURRENT_REQUESTS FCR

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

206: Select FCR.argument18 into l_req_groupid
207: from FND_CONCURRENT_REQUESTS FCR
208: where FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
209: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
210: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
211:
212: Select min(FCR.request_id) into l_min_reqid
213: from FND_CONCURRENT_REQUESTS FCR
214: where FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID

Line 214: where FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID

210: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
211:
212: Select min(FCR.request_id) into l_min_reqid
213: from FND_CONCURRENT_REQUESTS FCR
214: where FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
215: AND FCR.program_application_id = FND_GLOBAL.prog_appl_id
216: AND FCR.phase_code <> 'C'
217: AND FCR.argument14 = l_req_groupid;
218:

Line 215: AND FCR.program_application_id = FND_GLOBAL.prog_appl_id

211:
212: Select min(FCR.request_id) into l_min_reqid
213: from FND_CONCURRENT_REQUESTS FCR
214: where FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
215: AND FCR.program_application_id = FND_GLOBAL.prog_appl_id
216: AND FCR.phase_code <> 'C'
217: AND FCR.argument14 = l_req_groupid;
218:
219: l_base_count := 0;

Line 224: If ((NVL(l_min_reqid,FND_GLOBAL.CONC_REQUEST_ID) <> FND_GLOBAL.CONC_REQUEST_ID)OR (l_base_count <> 0)) then

220: select count(*) into l_base_count
221: from CST_ITEM_CST_DTLS_INTERFACE CICDI
222: where CICDI.group_id = l_req_groupid;
223:
224: If ((NVL(l_min_reqid,FND_GLOBAL.CONC_REQUEST_ID) <> FND_GLOBAL.CONC_REQUEST_ID)OR (l_base_count <> 0)) then
225: fnd_file.put_line(fnd_file.log,fnd_message.get_string('BOM','CST_REQ_ERROR'));
226: Conc_request := fnd_concurrent.set_completion_status('ERROR',fnd_message.get_string('BOM','CST_REQ_ERROR'));
227: return;
228: end If;

Line 471: FND_GLOBAL.user_id,

467: (
468: l_item ,
469: p_organization_id,
470: sysdate ,
471: FND_GLOBAL.user_id,
472: sysdate ,
473: FND_GLOBAL.user_id,
474: FND_GLOBAL.user_id,
475: FND_GLOBAL.conc_program_id,

Line 473: FND_GLOBAL.user_id,

469: p_organization_id,
470: sysdate ,
471: FND_GLOBAL.user_id,
472: sysdate ,
473: FND_GLOBAL.user_id,
474: FND_GLOBAL.user_id,
475: FND_GLOBAL.conc_program_id,
476: '1', -- This Level
477: '1', -- Material

Line 474: FND_GLOBAL.user_id,

470: sysdate ,
471: FND_GLOBAL.user_id,
472: sysdate ,
473: FND_GLOBAL.user_id,
474: FND_GLOBAL.user_id,
475: FND_GLOBAL.conc_program_id,
476: '1', -- This Level
477: '1', -- Material
478: p_def_mtl_subelement ,

Line 475: FND_GLOBAL.conc_program_id,

471: FND_GLOBAL.user_id,
472: sysdate ,
473: FND_GLOBAL.user_id,
474: FND_GLOBAL.user_id,
475: FND_GLOBAL.conc_program_id,
476: '1', -- This Level
477: '1', -- Material
478: p_def_mtl_subelement ,
479: '1', -- user defined

Line 486: l_price_list_name || ':'|| FND_GLOBAL.user_name

482: l_item_cost * nvl(l_conversion_rate, 1),
483: '1' ,
484: l_based_on_rollup,
485: p_group_id ,
486: l_price_list_name || ':'|| FND_GLOBAL.user_name
487: || ':' || to_char(sysdate , 'DD-MON-RR' ) ,
488: 1
489: ) ;
490: