eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ENC_PROCESSES

Line 6667: INSERT INTO psp_enc_processes

6663: IF (l_process_mode = 'TERMINATE') THEN
6664: l_process_code := 'LET';
6665: END IF;
6666:
6667: INSERT INTO psp_enc_processes
6668: (request_id, process_code, payroll_action_id,
6669: process_status, process_phase, business_group_id,
6670: set_of_books_id, creation_date, created_by,
6671: last_update_date, last_updated_by, last_update_login)

Line 6828: psp_enc_processes pep

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:
6832: CURSOR get_asg_id_cur IS

Line 7752: psp_enc_processes pep

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:
7756: CURSOR process_phase_cur IS

Line 7758: FROM psp_enc_processes

7754: AND fcr.request_id = pep.request_id;
7755:
7756: CURSOR process_phase_cur IS
7757: SELECT process_phase
7758: FROM psp_enc_processes
7759: WHERE payroll_action_id = p_payroll_action_id
7760: AND process_code = 'ST';
7761:
7762: CURSOR error_check_cur IS

Line 7905: UPDATE psp_enc_processes

7901: DELETE psp_enc_changed_assignments peca
7902: WHERE peca.payroll_action_id = p_payroll_action_id;
7903: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted processed change assignment records in psp_enc_change_assignments');
7904:
7905: UPDATE psp_enc_processes
7906: SET process_status = 'P'
7907: WHERE payroll_action_id = p_payroll_action_id;
7908: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_status in psp_enc_processes');
7909:

Line 7908: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_status in psp_enc_processes');

7904:
7905: UPDATE psp_enc_processes
7906: SET process_status = 'P'
7907: WHERE payroll_action_id = p_payroll_action_id;
7908: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_status in psp_enc_processes');
7909:
7910: UPDATE psp_enc_processes
7911: SET process_status = 'B',
7912: process_phase = 'no_summarize_transfer'

Line 7910: UPDATE psp_enc_processes

7906: SET process_status = 'P'
7907: WHERE payroll_action_id = p_payroll_action_id;
7908: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_status in psp_enc_processes');
7909:
7910: UPDATE psp_enc_processes
7911: SET process_status = 'B',
7912: process_phase = 'no_summarize_transfer'
7913: WHERE payroll_action_id = p_payroll_action_id
7914: AND NOT EXISTS (SELECT 1

Line 7919: UPDATE psp_enc_processes

7915: FROM psp_enc_summary_lines pesl
7916: WHERE pesl.payroll_action_id = p_payroll_action_id
7917: AND pesl.status_code = 'N');
7918:
7919: UPDATE psp_enc_processes
7920: SET process_phase = 'summarize_transfer'
7921: WHERE payroll_action_id = p_payroll_action_id
7922: AND EXISTS (SELECT 1
7923: FROM psp_enc_summary_lines pesl

Line 7928: UPDATE psp_enc_processes

7924: WHERE pesl.payroll_action_id = p_payroll_action_id
7925: AND pesl.status_code = 'N'
7926: AND pesl.superceded_line_id IS NULL);
7927:
7928: UPDATE psp_enc_processes
7929: SET process_phase = 'liquidate'
7930: WHERE payroll_action_id = p_payroll_action_id
7931: AND EXISTS (SELECT 1
7932: FROM psp_enc_summary_lines pesl

Line 7936: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');

7932: FROM psp_enc_summary_lines pesl
7933: WHERE pesl.payroll_action_id = p_payroll_action_id
7934: AND pesl.status_code = 'N'
7935: AND pesl.superceded_line_id is NOT NULL);
7936: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');
7937: END IF;
7938:
7939: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7940: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');

Line 7995: UPDATE psp_enc_processes

7991: fnd_msg_pub.add;
7992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7993: END IF;
7994:
7995: UPDATE psp_enc_processes
7996: SET process_phase = 'deinit_st'
7997: WHERE payroll_action_id = p_payroll_action_id
7998: AND process_code = 'ST';
7999: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');

Line 7999: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');

7995: UPDATE psp_enc_processes
7996: SET process_phase = 'deinit_st'
7997: WHERE payroll_action_id = p_payroll_action_id
7998: AND process_code = 'ST';
7999: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');
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');

Line 8839: FROM psp_enc_processes pep,

8835: fnd_number.canonical_to_number(NVL(argument19, '-1')),
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:

Line 8902: FROM psp_enc_processes pep,

8898: WHERE organization_id = l_organization_id;
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

Line 10146: UPDATE psp_enc_processes

10142: DELETE psp_report_errors
10143: WHERE payroll_action_id = p_payroll_action_id;
10144: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
10145:
10146: UPDATE psp_enc_processes
10147: SET process_status = 'B',
10148: process_phase = 'rollback'
10149: WHERE payroll_action_id = p_payroll_action_id;
10150: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');

Line 10150: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');

10146: UPDATE psp_enc_processes
10147: SET process_status = 'B',
10148: process_phase = 'rollback'
10149: WHERE payroll_action_id = p_payroll_action_id;
10150: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');
10151:
10152: UPDATE psp_enc_process_assignments
10153: SET assignment_status = 'B'
10154: WHERE payroll_action_id = p_payroll_action_id;

Line 10300: UPDATE psp_enc_processes

10296: AND assignment_id = l_assignments(recno);
10297: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10298: END LOOP;
10299:
10300: UPDATE psp_enc_processes
10301: SET process_status = 'B',
10302: process_phase = 'rollback'
10303: WHERE payroll_action_id = p_payroll_action_id
10304: AND NOT EXISTS (SELECT 1

Line 10307: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');

10303: WHERE payroll_action_id = p_payroll_action_id
10304: AND NOT EXISTS (SELECT 1
10305: FROM psp_enc_summary_lines
10306: WHERE payroll_action_id = p_payroll_action_id);
10307: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');
10308: END IF;
10309:
10310: COMMIT;
10311: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);