DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on FND_CONCURRENT

Line 6634: FROM fnd_concurrent_requests

6630:
6631: CURSOR action_parameters_cur IS
6632: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),
6633: argument12
6634: FROM fnd_concurrent_requests
6635: WHERE request_id = l_request_id;
6636:
6637: CURSOR enc_payrolls_cur IS
6638: SELECT pep.payroll_id

Line 6827: FROM fnd_concurrent_requests fcr,

6823:
6824: CURSOR payroll_id_cur IS
6825: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),
6826: argument12
6827: FROM fnd_concurrent_requests fcr,
6828: psp_enc_processes pep
6829: WHERE pep.payroll_action_id = p_payroll_action_id
6830: AND fcr.request_id = pep.request_id;
6831:

Line 7751: FROM fnd_concurrent_requests fcr,

7747: l_st_count NUMBER(15);
7748:
7749: CURSOR payroll_id_cur IS
7750: SELECT argument12
7751: FROM fnd_concurrent_requests fcr,
7752: psp_enc_processes pep
7753: WHERE pep.payroll_action_id = p_payroll_action_id
7754: AND fcr.request_id = pep.request_id;
7755:

Line 8004: call_status := fnd_concurrent.wait_for_request(l_request_id, 10, 0, rphase, rstatus, dphase, dstatus, message);

8000:
8001: COMMIT;
8002:
8003: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for Encumbrance Summarize and Transfer request to complete');
8004: call_status := fnd_concurrent.wait_for_request(l_request_id, 10, 0, rphase, rstatus, dphase, dstatus, message);
8005:
8006: IF call_status = FALSE THEN
8007: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer failed');
8008: fnd_message.set_name('PSP','PSP_ENC_STR_FAILED');

Line 8809: l_process_description fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE;

8805: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
8806: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
8807: l_full_name per_all_people_f.full_name%TYPE;
8808: l_organization_name hr_organization_units.name%TYPE;
8809: l_process_description fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE;
8810: l_process_mode VARCHAR2(15);
8811: l_person_id1 NUMBER(15);
8812: l_termination_date1 DATE;
8813: l_person_id2 NUMBER(15);

Line 8840: fnd_concurrent_requests fcr

8836: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8837: fnd_number.canonical_to_number(NVL(argument21, '-1')),
8838: fnd_date.canonical_to_date(NVL(argument22, fnd_date.date_to_canonical(TRUNC(SYSDATE))))
8839: FROM psp_enc_processes pep,
8840: fnd_concurrent_requests fcr
8841: WHERE pep.payroll_action_id = p_payroll_action_id
8842: AND fcr.request_id = pep.request_id;
8843:
8844: CURSOR enc_payroll_cur IS

Line 8903: fnd_concurrent_requests fcr,

8899:
8900: CURSOR process_descr_cur IS
8901: SELECT pep.request_id || ': ' || fcpt.user_concurrent_program_name
8902: FROM psp_enc_processes pep,
8903: fnd_concurrent_requests fcr,
8904: fnd_concurrent_programs_tl fcpt
8905: WHERE EXISTS (SELECT 1
8906: FROM psp_enc_summary_lines pesl
8907: WHERE pesl.payroll_action_id = pep.payroll_action_id

Line 8904: fnd_concurrent_programs_tl fcpt

8900: CURSOR process_descr_cur IS
8901: SELECT pep.request_id || ': ' || fcpt.user_concurrent_program_name
8902: FROM psp_enc_processes pep,
8903: fnd_concurrent_requests fcr,
8904: fnd_concurrent_programs_tl fcpt
8905: WHERE EXISTS (SELECT 1
8906: FROM psp_enc_summary_lines pesl
8907: WHERE pesl.payroll_action_id = pep.payroll_action_id
8908: AND pesl.payroll_action_id = l_payroll_action_id)