DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on FND_CONCURRENT

Line 3104: call_status := fnd_concurrent.wait_for_request(req_id, 10, 0,

3100: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for psp_enc_summary_lines');
3101:
3102: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for Journal Import request to complete');
3103:
3104: call_status := fnd_concurrent.wait_for_request(req_id, 10, 0,
3105: rphase, rstatus, dphase, dstatus, message);
3106:
3107: IF call_status = FALSE then
3108: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import failed');

Line 5782: call_status := fnd_concurrent.wait_for_request(req_id_tab(I), 10, 0,

5778: FOR I IN 1..org_id_tab.count
5779: LOOP
5780: -- insert into psp_Stout values(96, 'gms transfer started');
5781: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for comlpetion of Transaction Import');
5782: call_status := fnd_concurrent.wait_for_request(req_id_tab(I), 10, 0,
5783: rphase, rstatus, dphase, dstatus, message);
5784:
5785: IF call_status = FALSE then
5786: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import failed');

Line 7065: FROM fnd_concurrent_requests fcr

7061:
7062: CURSOR term_employee_cur IS
7063: SELECT TO_NUMBER(argument3),
7064: fnd_date.canonical_to_date(fnd_date.date_to_canonical(argument4))
7065: FROM fnd_concurrent_requests fcr
7066: WHERE fcr.request_id = l_request_id;
7067:
7068: CURSOR enc_control_cur IS
7069: SELECT DISTINCT enc_control_id