APPS.PSP_NON_ORCL_RLBK_PKG dependencies on PSP_PAYROLL_CONTROLS

Line 16: FROM psp_payroll_controls a

12: l_payroll_control_id NUMBER;
13:
14: CURSOR cursor_batch IS
15: SELECT dist_dr_amount,dist_cr_amount,payroll_control_id
16: FROM psp_payroll_controls a
17: WHERE a.batch_name = p_batch_name
18: AND a.status_code = 'N'
19: AND a.business_group_id = p_business_group_id
20: AND a.set_of_books_id = p_set_of_bks_id;

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 109: DELETE FROM psp_payroll_controls

105:
106: DELETE FROM psp_payroll_lines
107: WHERE payroll_control_id = c_payroll_control_id;
108:
109: DELETE FROM psp_payroll_controls
110: WHERE batch_name = c_batch_name
111: AND business_group_id = c_business_group_id
112: AND set_of_books_id = c_set_of_bks_id;
113:

Line 114: --dbms_output.put_line('successful deletion of psp_payroll_controls ......');

110: WHERE batch_name = c_batch_name
111: AND business_group_id = c_business_group_id
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

Line 125: --dbms_output.put_line('successful completion of delete and update on psp_payroll_controls and payroll_interface');

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');
126: END change_records;
127:
128: END PSP_NON_ORCL_RLBK_PKG;