DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on FND_CONCURRENT

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

3153: --fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for psp_enc_summary_lines');
3154:
3155: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for Journal Import request to complete');
3156:
3157: call_status := fnd_concurrent.wait_for_request(req_id, 10, 0,
3158: rphase, rstatus, dphase, dstatus, message);
3159:
3160: IF call_status = FALSE then
3161: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import failed');

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

5883:
5884:
5885: -- insert into psp_Stout values(96, 'gms transfer started');
5886: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for comlpetion of Transaction Import for org_id: '||org_id_tab(I));
5887: call_status := fnd_concurrent.wait_for_request(req_id_tab(I), 10, 0,
5888: rphase, rstatus, dphase, dstatus, message);
5889:
5890: IF call_status = FALSE then
5891: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import failed');

Line 7303: FROM fnd_concurrent_requests fcr

7299:
7300: CURSOR term_employee_cur IS
7301: SELECT TO_NUMBER(argument3),
7302: fnd_date.canonical_to_date(fnd_date.date_to_canonical(argument4))
7303: FROM fnd_concurrent_requests fcr
7304: WHERE fcr.request_id = l_request_id;
7305:
7306: CURSOR enc_control_cur IS
7307: SELECT DISTINCT enc_control_id