APPS.PAY_ZA_TAX_YEAR_START_PKG dependencies on PAY_ZA_UPDATE_PKG

Line 63: l_tax_year_start := Pay_Za_Update_Pkg.get_tax_year_end(p_payroll, p_tax_year);

59: BEGIN
60:
61:
62: -- Get the tax year end and new start date --
63: l_tax_year_start := Pay_Za_Update_Pkg.get_tax_year_end(p_payroll, p_tax_year);
64:
65: l_tax_year_end := l_tax_year_start - 1;
66:
67: -- Get the tax year that the process must run for --

Line 102: IF Pay_Za_Update_Pkg.payroll_updateble(p_payroll, l_tax_year) THEN

98: AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;
99:
100:
101: -- Check if the payroll is updatable --
102: IF Pay_Za_Update_Pkg.payroll_updateble(p_payroll, l_tax_year) THEN
103:
104: FOR v_assignments IN c_assignments(p_payroll, l_tax_year_end)
105: LOOP
106:

Line 112: IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN

108: FETCH c_entry_details INTO l_one_record;
109:
110: IF l_one_record.screen_entry_value IN ('C','D') THEN
111:
112: IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN
113: l_new_value := 'Normal';
114:
115: Pay_Za_Update_Pkg.update_this_record
116: (

Line 115: Pay_Za_Update_Pkg.update_this_record

111:
112: IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN
113: l_new_value := 'Normal';
114:
115: Pay_Za_Update_Pkg.update_this_record
116: (
117: l_one_record,
118: l_new_value,
119: 'UPDATE_CHANGE_INSERT'

Line 127: IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN

123: END IF;
124:
125: IF l_one_record.screen_entry_value IN ('N','P') THEN
126:
127: IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN
128: l_new_value := 'Private Director';
129:
130: Pay_Za_Update_Pkg.update_this_record
131: (

Line 130: Pay_Za_Update_Pkg.update_this_record

126:
127: IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN
128: l_new_value := 'Private Director';
129:
130: Pay_Za_Update_Pkg.update_this_record
131: (
132: l_one_record,
133: l_new_value,
134: 'UPDATE_CHANGE_INSERT'

Line 147: IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN

143: FETCH c_entry_details INTO l_one_record;
144:
145: IF l_one_record.screen_entry_value IS NOT NULL THEN
146:
147: IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN
148: l_new_value := ' ';
149:
150: Pay_Za_Update_Pkg.update_this_record
151: (

Line 150: Pay_Za_Update_Pkg.update_this_record

146:
147: IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN
148: l_new_value := ' ';
149:
150: Pay_Za_Update_Pkg.update_this_record
151: (
152: l_one_record,
153: l_new_value,
154: 'UPDATE_CHANGE_INSERT'

Line 166: IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN

162: FETCH c_entry_details INTO l_one_record;
163:
164: IF l_one_record.screen_entry_value IS NOT NULL THEN
165:
166: IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN
167: -- l_new_value := ' ';
168: l_new_value := null;
169:
170: Pay_Za_Update_Pkg.update_this_record

Line 170: Pay_Za_Update_Pkg.update_this_record

166: IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN
167: -- l_new_value := ' ';
168: l_new_value := null;
169:
170: Pay_Za_Update_Pkg.update_this_record
171: (
172: l_one_record,
173: l_new_value,
174: 'UPDATE_CHANGE_INSERT'

Line 183: Pay_Za_Update_Pkg.update_tysp_table

179: CLOSE c_entry_details;
180: END LOOP;
181:
182: -- Update the TYS table --
183: Pay_Za_Update_Pkg.update_tysp_table
184: (
185: p_payroll,
186: l_tax_year
187: );

Line 217: l_tax_year_start := Pay_Za_Update_Pkg.get_tax_year_end(p_payroll, p_tax_year);

213:
214: BEGIN
215:
216: -- Get the tax year end date --
217: l_tax_year_start := Pay_Za_Update_Pkg.get_tax_year_end(p_payroll, p_tax_year);
218: l_tax_year_end := l_tax_year_start -1;
219:
220: -- Get the tax year that the process must run for --
221: l_tax_year := TO_NUMBER(SUBSTR(p_tax_year,-4));

Line 253: IF Pay_Za_Update_Pkg.payroll_rollbackable(p_payroll, l_tax_year) THEN

249: AND name = 'Tax Directive Value'
250: AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;
251:
252: -- Check if the payroll is updatable --
253: IF Pay_Za_Update_Pkg.payroll_rollbackable(p_payroll, l_tax_year) THEN
254:
255: FOR v_assignments IN c_assignments(p_payroll, l_tax_year_end)
256: LOOP
257:

Line 262: Pay_Za_Update_Pkg.rollback_this_record(l_one_record);

258: -- Check and update tax_status if tax_status in ('C','D','N','P') --
259: OPEN c_entry_details(l_element_type_id,tax_status_id,v_assignments.assignment_id,p_payroll,l_tax_year_end);
260: FETCH c_entry_details INTO l_one_record;
261:
262: Pay_Za_Update_Pkg.rollback_this_record(l_one_record);
263: CLOSE c_entry_details;
264:
265: OPEN c_entry_details(l_element_type_id,tax_directive_number_id,v_assignments.assignment_id,p_payroll,l_tax_year_end);
266: FETCH c_entry_details INTO l_one_record;

Line 268: Pay_Za_Update_Pkg.rollback_this_record(l_one_record);

264:
265: OPEN c_entry_details(l_element_type_id,tax_directive_number_id,v_assignments.assignment_id,p_payroll,l_tax_year_end);
266: FETCH c_entry_details INTO l_one_record;
267:
268: Pay_Za_Update_Pkg.rollback_this_record(l_one_record);
269: CLOSE c_entry_details;
270:
271: OPEN c_entry_details(l_element_type_id,tax_directive_value_id,v_assignments.assignment_id,p_payroll,l_tax_year_end);
272: FETCH c_entry_details INTO l_one_record;

Line 274: Pay_Za_Update_Pkg.rollback_this_record(l_one_record);

270:
271: OPEN c_entry_details(l_element_type_id,tax_directive_value_id,v_assignments.assignment_id,p_payroll,l_tax_year_end);
272: FETCH c_entry_details INTO l_one_record;
273:
274: Pay_Za_Update_Pkg.rollback_this_record(l_one_record);
275: CLOSE c_entry_details;
276: END LOOP;
277:
278: -- Update the TYS table --

Line 279: Pay_Za_Update_Pkg.delete_tysp_table

275: CLOSE c_entry_details;
276: END LOOP;
277:
278: -- Update the TYS table --
279: Pay_Za_Update_Pkg.delete_tysp_table
280: (
281: p_payroll,
282: l_tax_year
283: );