DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on FND_CONCURRENT

Line 6378: FROM fnd_concurrent_requests

6374:
6375: CURSOR action_parameters_cur IS
6376: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),
6377: argument12
6378: FROM fnd_concurrent_requests
6379: WHERE request_id = l_request_id;
6380:
6381: CURSOR enc_payrolls_cur IS
6382: SELECT pep.payroll_id

Line 6570: FROM fnd_concurrent_requests fcr,

6566:
6567: CURSOR payroll_id_cur IS
6568: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),
6569: argument12
6570: FROM fnd_concurrent_requests fcr,
6571: psp_enc_processes pep
6572: WHERE pep.payroll_action_id = p_payroll_action_id
6573: AND fcr.request_id = pep.request_id;
6574:

Line 7439: FROM fnd_concurrent_requests fcr,

7435: l_st_count NUMBER(15);
7436:
7437: CURSOR payroll_id_cur IS
7438: SELECT argument12
7439: FROM fnd_concurrent_requests fcr,
7440: psp_enc_processes pep
7441: WHERE pep.payroll_action_id = p_payroll_action_id
7442: AND fcr.request_id = pep.request_id;
7443:

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

7680:
7681: COMMIT;
7682:
7683: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for Encumbrance Summarize and Transfer request to complete');
7684: call_status := fnd_concurrent.wait_for_request(l_request_id, 10, 0, rphase, rstatus, dphase, dstatus, message);
7685:
7686: IF call_status = FALSE THEN
7687: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer failed');
7688: fnd_message.set_name('PSP','PSP_ENC_STR_FAILED');

Line 8486: l_process_description fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE;

8482: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
8483: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
8484: l_full_name per_all_people_f.full_name%TYPE;
8485: l_organization_name hr_organization_units.name%TYPE;
8486: l_process_description fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE;
8487: l_process_mode VARCHAR2(15);
8488: l_person_id1 NUMBER(15);
8489: l_termination_date1 DATE;
8490: l_person_id2 NUMBER(15);

Line 8516: fnd_concurrent_requests fcr

8512: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8513: fnd_number.canonical_to_number(NVL(argument21, '-1')),
8514: fnd_date.canonical_to_date(NVL(argument22, fnd_date.date_to_canonical(TRUNC(SYSDATE))))
8515: FROM psp_enc_processes pep,
8516: fnd_concurrent_requests fcr
8517: WHERE pep.payroll_action_id = p_payroll_action_id
8518: AND fcr.request_id = pep.request_id;
8519:
8520: CURSOR enc_payroll_cur IS

Line 8579: fnd_concurrent_requests fcr,

8575:
8576: CURSOR process_descr_cur IS
8577: SELECT pep.request_id || ': ' || fcpt.user_concurrent_program_name
8578: FROM psp_enc_processes pep,
8579: fnd_concurrent_requests fcr,
8580: fnd_concurrent_programs_tl fcpt
8581: WHERE EXISTS (SELECT 1
8582: FROM psp_enc_summary_lines pesl
8583: WHERE pesl.payroll_action_id = pep.payroll_action_id

Line 8580: fnd_concurrent_programs_tl fcpt

8576: CURSOR process_descr_cur IS
8577: SELECT pep.request_id || ': ' || fcpt.user_concurrent_program_name
8578: FROM psp_enc_processes pep,
8579: fnd_concurrent_requests fcr,
8580: fnd_concurrent_programs_tl fcpt
8581: WHERE EXISTS (SELECT 1
8582: FROM psp_enc_summary_lines pesl
8583: WHERE pesl.payroll_action_id = pep.payroll_action_id
8584: AND pesl.payroll_action_id = l_payroll_action_id)