APPS.PSP_ENC_CREATE_LINES dependencies on PSP_REPORT_ERRORS

Line 7764: FROM psp_report_errors

7760: AND process_code = 'ST';
7761:
7762: CURSOR error_check_cur IS
7763: SELECT COUNT(1)
7764: FROM psp_report_errors
7765: WHERE payroll_action_id = p_payroll_action_id
7766: AND request_id >= l_request_id
7767: AND message_level = 'E';
7768:

Line 10142: DELETE psp_report_errors

10138: DELETE psp_enc_controls
10139: WHERE payroll_action_id = p_payroll_action_id;
10140: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
10141:
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

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

10140: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
10141:
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'

Line 10266: DELETE psp_report_errors

10262: WHERE payroll_action_id = p_payroll_action_id
10263: AND pel.enc_control_id = pec.enc_control_id);
10264: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
10265:
10266: DELETE psp_report_errors
10267: WHERE payroll_action_id = p_payroll_action_id
10268: AND source_id = l_assignments(recno);
10269: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
10270:

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

10265:
10266: DELETE psp_report_errors
10267: WHERE payroll_action_id = p_payroll_action_id
10268: AND source_id = l_assignments(recno);
10269: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
10270:
10271: UPDATE psp_enc_process_assignments
10272: SET assignment_status = 'B'
10273: WHERE payroll_action_id = p_payroll_action_id

Line 11862: DELETE psp_report_errors

11858: p_payroll_id IN NUMBER,
11859: p_payroll_action_id IN NUMBER) IS
11860: PRAGMA AUTONOMOUS_TRANSACTION;
11861: BEGIN
11862: DELETE psp_report_errors
11863: WHERE source_id = p_assignment_id
11864: AND value1 = p_payroll_id
11865: AND payroll_action_id = p_payroll_action_id;
11866: