APPS.PSP_NON_ORCL_RLBK_PKG dependencies on PSP_PAYROLL_INTERFACE

Line 76: -- The Procedure to Delete the records from the Psp_payroll_controls table and to update the psp_payroll_interface table -- if the dist_dr_amount and the dist_cr_amount is NULL for the particular batch_name

72: return;
73:
74: END check_rollback;
75:
76: -- The Procedure to Delete the records from the Psp_payroll_controls table and to update the psp_payroll_interface table -- if the dist_dr_amount and the dist_cr_amount is NULL for the particular batch_name
77:
78: PROCEDURE change_records(c_batch_name IN Varchar2,c_payroll_control_id IN NUMBER,
79: c_business_group_id IN NUMBER,c_set_of_bks_id IN NUMBER) IS
80:

Line 116: UPDATE psp_payroll_interface SET status_code = 'N'

112: AND set_of_books_id = c_set_of_bks_id;
113:
114: --dbms_output.put_line('successful deletion of psp_payroll_controls ......');
115:
116: UPDATE psp_payroll_interface SET status_code = 'N'
117: WHERE batch_name = c_batch_name
118: AND business_group_id = c_business_group_id
119: AND set_of_books_id = c_set_of_bks_id;
120:

Line 121: --dbms_output.put_line('Successful Updation of psp_payroll_interface..... last step');

117: WHERE batch_name = c_batch_name
118: AND business_group_id = c_business_group_id
119: AND set_of_books_id = c_set_of_bks_id;
120:
121: --dbms_output.put_line('Successful Updation of psp_payroll_interface..... last step');
122:
123: commit;
124:
125: --dbms_output.put_line('successful completion of delete and update on psp_payroll_controls and payroll_interface');