DBA Data[Home] [Help]

APPS.FND_MLS_SUBMIT dependencies on FND_APPLICATION

Line 414: from fnd_concurrent_programs FCP, fnd_application FA

410:
411: begin
412:
413: select MLS_EXECUTABLE_ID, MLS_EXECUTABLE_APP_ID into mls_exe_id, mls_exe_app_id
414: from fnd_concurrent_programs FCP, fnd_application FA
415: where FCP.CONCURRENT_PROGRAM_NAME = UPPER(program) AND FA.APPLICATION_SHORT_NAME = UPPER(application)
416: AND FCP.APPLICATION_ID=FA.APPLICATION_ID;
417:
418: if(mls_exe_id is not null AND mls_exe_app_id is not null) then

Line 458: from fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt, fnd_application fa

454:
455: select fcpt.user_concurrent_program_name, fcp.concurrent_program_id, fa.application_id, DECODE(ops_req_mode,
456: 'EXPLICIT', NVL(P_OPS_ID,NVL(fcp.instance_id,fnd_conc_global.ops_inst_num)),
457: -1), Printer_Name into USER_PROG_NAME, CONC_PROG_ID, CONC_APP_ID, SUBMIT_OPS_ID, FCP_PRINTER
458: from fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt, fnd_application fa
459: where fcp.concurrent_program_id=fcpt.concurrent_program_id and fcp.application_id=fcpt.application_id
460: and fa.application_id=fcp.application_id and fcpt.language = userenv('LANG')
461: and fcp.concurrent_program_name= upper(program) and fa.application_short_name=UPPER(application);
462: