APPS.FND_LOG_ADMIN dependencies on FND_CONCURRENT

Line 557: l_part2 := ' and not exists (select null from FND_CONCURRENT_REQUESTS fcr ';

553:
554:
555: if (pTrType = C_TR_REQUEST_TYPE) then
556: l_part1 := ' where fltc.TRANSACTION_TYPE = ''REQUEST'' ';
557: l_part2 := ' and not exists (select null from FND_CONCURRENT_REQUESTS fcr ';
558: l_part3 := ' where fcr.REQUEST_ID = fltc.TRANSACTION_ID and fcr.phase_code <> ''C'')';
559: elsif (pTrType = C_TR_SERVICE_TYPE) then
560: l_part1 := ' where fltc.TRANSACTION_TYPE = ''SERVICE'' ';
561: l_part2 := ' and not exists (select null from FND_CONCURRENT_PROCESSES fcp ';

Line 561: l_part2 := ' and not exists (select null from FND_CONCURRENT_PROCESSES fcp ';

557: l_part2 := ' and not exists (select null from FND_CONCURRENT_REQUESTS fcr ';
558: l_part3 := ' where fcr.REQUEST_ID = fltc.TRANSACTION_ID and fcr.phase_code <> ''C'')';
559: elsif (pTrType = C_TR_SERVICE_TYPE) then
560: l_part1 := ' where fltc.TRANSACTION_TYPE = ''SERVICE'' ';
561: l_part2 := ' and not exists (select null from FND_CONCURRENT_PROCESSES fcp ';
562: --5688407, added "U" below
563: l_part3 := ' where fcp.CONCURRENT_PROCESS_ID = fltc.TRANSACTION_ID and fcp.PROCESS_STATUS_CODE not in ( ''S'', ''K'', ''U'' ))';
564: elsif(pTrType = C_TR_FORM_TYPE) then
565: l_part1 := ' where fltc.TRANSACTION_TYPE = ''FORM'' ';

Line 1574: l_request_status_return := fnd_concurrent.get_request_status(

1570: l_cleanup_program := 'FNDLGPRG';
1571:
1572: -- see if the cleanup process is already there
1573:
1574: l_request_status_return := fnd_concurrent.get_request_status(
1575: request_id => l_request_id,
1576: appl_shortname => l_cleanup_app_short_name,
1577: program => l_cleanup_program,
1578: phase => l_phase,