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_REPORT_ERRORS

Line 7452: FROM psp_report_errors

7448: AND process_code = 'ST';
7449:
7450: CURSOR error_check_cur IS
7451: SELECT COUNT(1)
7452: FROM psp_report_errors
7453: WHERE payroll_action_id = p_payroll_action_id
7454: AND request_id >= l_request_id
7455: AND message_level = 'E';
7456:

Line 9513: DELETE psp_report_errors

9509: DELETE psp_enc_controls
9510: WHERE payroll_action_id = p_payroll_action_id;
9511: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
9512:
9513: DELETE psp_report_errors
9514: WHERE payroll_action_id = p_payroll_action_id;
9515: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
9516:
9517: UPDATE psp_enc_processes

Line 9515: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');

9511: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
9512:
9513: DELETE psp_report_errors
9514: WHERE payroll_action_id = p_payroll_action_id;
9515: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
9516:
9517: UPDATE psp_enc_processes
9518: SET process_status = 'B',
9519: process_phase = 'rollback'

Line 9637: DELETE psp_report_errors

9633: WHERE payroll_action_id = p_payroll_action_id
9634: AND pel.enc_control_id = pec.enc_control_id);
9635: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
9636:
9637: DELETE psp_report_errors
9638: WHERE payroll_action_id = p_payroll_action_id
9639: AND source_id = l_assignments(recno);
9640: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
9641:

Line 9640: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');

9636:
9637: DELETE psp_report_errors
9638: WHERE payroll_action_id = p_payroll_action_id
9639: AND source_id = l_assignments(recno);
9640: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
9641:
9642: UPDATE psp_enc_process_assignments
9643: SET assignment_status = 'B'
9644: WHERE payroll_action_id = p_payroll_action_id

Line 11231: DELETE psp_report_errors

11227: p_payroll_id IN NUMBER,
11228: p_payroll_action_id IN NUMBER) IS
11229: PRAGMA AUTONOMOUS_TRANSACTION;
11230: BEGIN
11231: DELETE psp_report_errors
11232: WHERE source_id = p_assignment_id
11233: AND value1 = p_payroll_id
11234: AND payroll_action_id = p_payroll_action_id;
11235: