233: 2365908 deductions if location has changed.
234: 14-MAY-2002 ahanda 115.51 Moved procedures
235: - get_last_xfr_info
236: - get_last_pymt_info
237: to pay_ac_action_arch
238: 24-APR-2002 ahanda 115.50 Changed c_get_rr_jd for performance.
239: 18-MAR-2002 ahanda 115.49 2204512 Changed the way we populate NR/R.
240: Fixed archiving for Bal Adj for
241: which Pre Pay flag is checked.
272: priority to the archiver processing priority for Tax Deductions
273: **************************************************************************/
274: PROCEDURE change_processing_priority IS
275: BEGIN
276: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
277: for i in pay_ac_action_arch.lrr_act_tab.first ..
278: pay_ac_action_arch.lrr_act_tab.last loop
279: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
280: = 'AC DEDUCTIONS' then
273: **************************************************************************/
274: PROCEDURE change_processing_priority IS
275: BEGIN
276: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
277: for i in pay_ac_action_arch.lrr_act_tab.first ..
278: pay_ac_action_arch.lrr_act_tab.last loop
279: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
280: = 'AC DEDUCTIONS' then
281: if pay_ac_action_arch.lrr_act_tab(i).act_info10
274: PROCEDURE change_processing_priority IS
275: BEGIN
276: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
277: for i in pay_ac_action_arch.lrr_act_tab.first ..
278: pay_ac_action_arch.lrr_act_tab.last loop
279: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
280: = 'AC DEDUCTIONS' then
281: if pay_ac_action_arch.lrr_act_tab(i).act_info10
282: = 'FIT Withheld' then
275: BEGIN
276: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
277: for i in pay_ac_action_arch.lrr_act_tab.first ..
278: pay_ac_action_arch.lrr_act_tab.last loop
279: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
280: = 'AC DEDUCTIONS' then
281: if pay_ac_action_arch.lrr_act_tab(i).act_info10
282: = 'FIT Withheld' then
283: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '1';
277: for i in pay_ac_action_arch.lrr_act_tab.first ..
278: pay_ac_action_arch.lrr_act_tab.last loop
279: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
280: = 'AC DEDUCTIONS' then
281: if pay_ac_action_arch.lrr_act_tab(i).act_info10
282: = 'FIT Withheld' then
283: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '1';
284: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
285: = 'SS EE Withheld' then
279: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
280: = 'AC DEDUCTIONS' then
281: if pay_ac_action_arch.lrr_act_tab(i).act_info10
282: = 'FIT Withheld' then
283: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '1';
284: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
285: = 'SS EE Withheld' then
286: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
287: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
280: = 'AC DEDUCTIONS' then
281: if pay_ac_action_arch.lrr_act_tab(i).act_info10
282: = 'FIT Withheld' then
283: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '1';
284: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
285: = 'SS EE Withheld' then
286: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
287: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
288: = 'SS Withheld' then
282: = 'FIT Withheld' then
283: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '1';
284: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
285: = 'SS EE Withheld' then
286: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
287: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
288: = 'SS Withheld' then
289: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
290: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
283: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '1';
284: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
285: = 'SS EE Withheld' then
286: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
287: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
288: = 'SS Withheld' then
289: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
290: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
291: = 'Medicare EE Withheld' then
285: = 'SS EE Withheld' then
286: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
287: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
288: = 'SS Withheld' then
289: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
290: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
291: = 'Medicare EE Withheld' then
292: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '3';
293: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
286: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
287: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
288: = 'SS Withheld' then
289: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
290: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
291: = 'Medicare EE Withheld' then
292: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '3';
293: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
294: = 'EIC Advance' then
288: = 'SS Withheld' then
289: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
290: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
291: = 'Medicare EE Withheld' then
292: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '3';
293: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
294: = 'EIC Advance' then
295: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '4';
296: if pay_ac_action_arch.lrr_act_tab(i).act_info9 > 0 then
289: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
290: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
291: = 'Medicare EE Withheld' then
292: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '3';
293: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
294: = 'EIC Advance' then
295: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '4';
296: if pay_ac_action_arch.lrr_act_tab(i).act_info9 > 0 then
297: pay_ac_action_arch.lrr_act_tab(i).act_info9 :=
291: = 'Medicare EE Withheld' then
292: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '3';
293: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
294: = 'EIC Advance' then
295: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '4';
296: if pay_ac_action_arch.lrr_act_tab(i).act_info9 > 0 then
297: pay_ac_action_arch.lrr_act_tab(i).act_info9 :=
298: (pay_ac_action_arch.lrr_act_tab(i).act_info9 * -1);
299: end if;
292: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '3';
293: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
294: = 'EIC Advance' then
295: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '4';
296: if pay_ac_action_arch.lrr_act_tab(i).act_info9 > 0 then
297: pay_ac_action_arch.lrr_act_tab(i).act_info9 :=
298: (pay_ac_action_arch.lrr_act_tab(i).act_info9 * -1);
299: end if;
300: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
293: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
294: = 'EIC Advance' then
295: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '4';
296: if pay_ac_action_arch.lrr_act_tab(i).act_info9 > 0 then
297: pay_ac_action_arch.lrr_act_tab(i).act_info9 :=
298: (pay_ac_action_arch.lrr_act_tab(i).act_info9 * -1);
299: end if;
300: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
301: = 'SIT Withheld' then
294: = 'EIC Advance' then
295: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '4';
296: if pay_ac_action_arch.lrr_act_tab(i).act_info9 > 0 then
297: pay_ac_action_arch.lrr_act_tab(i).act_info9 :=
298: (pay_ac_action_arch.lrr_act_tab(i).act_info9 * -1);
299: end if;
300: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
301: = 'SIT Withheld' then
302: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '5';
296: if pay_ac_action_arch.lrr_act_tab(i).act_info9 > 0 then
297: pay_ac_action_arch.lrr_act_tab(i).act_info9 :=
298: (pay_ac_action_arch.lrr_act_tab(i).act_info9 * -1);
299: end if;
300: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
301: = 'SIT Withheld' then
302: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '5';
303: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
304: = 'County Withheld' then
298: (pay_ac_action_arch.lrr_act_tab(i).act_info9 * -1);
299: end if;
300: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
301: = 'SIT Withheld' then
302: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '5';
303: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
304: = 'County Withheld' then
305: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '6';
306: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
299: end if;
300: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
301: = 'SIT Withheld' then
302: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '5';
303: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
304: = 'County Withheld' then
305: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '6';
306: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
307: = 'SDI Withheld' then
301: = 'SIT Withheld' then
302: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '5';
303: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
304: = 'County Withheld' then
305: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '6';
306: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
307: = 'SDI Withheld' then
308: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
309: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
302: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '5';
303: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
304: = 'County Withheld' then
305: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '6';
306: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
307: = 'SDI Withheld' then
308: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
309: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
310: = 'SDI EE Withheld' then
304: = 'County Withheld' then
305: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '6';
306: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
307: = 'SDI Withheld' then
308: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
309: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
310: = 'SDI EE Withheld' then
311: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
312: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI Withheld';
305: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '6';
306: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
307: = 'SDI Withheld' then
308: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
309: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
310: = 'SDI EE Withheld' then
311: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
312: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI Withheld';
313: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
307: = 'SDI Withheld' then
308: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
309: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
310: = 'SDI EE Withheld' then
311: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
312: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI Withheld';
313: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
314: = 'Non W2 FIT Withheld' then
315: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
308: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
309: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
310: = 'SDI EE Withheld' then
311: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
312: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI Withheld';
313: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
314: = 'Non W2 FIT Withheld' then
315: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
316: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
309: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
310: = 'SDI EE Withheld' then
311: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
312: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI Withheld';
313: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
314: = 'Non W2 FIT Withheld' then
315: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
316: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
317: = 'SUI Withheld' then
311: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
312: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI Withheld';
313: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
314: = 'Non W2 FIT Withheld' then
315: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
316: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
317: = 'SUI Withheld' then
318: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
319: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
312: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI Withheld';
313: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
314: = 'Non W2 FIT Withheld' then
315: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
316: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
317: = 'SUI Withheld' then
318: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
319: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
320: = 'SUI EE Withheld' then
314: = 'Non W2 FIT Withheld' then
315: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
316: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
317: = 'SUI Withheld' then
318: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
319: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
320: = 'SUI EE Withheld' then
321: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
322: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI Withheld';
315: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
316: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
317: = 'SUI Withheld' then
318: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
319: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
320: = 'SUI EE Withheld' then
321: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
322: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI Withheld';
323: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
317: = 'SUI Withheld' then
318: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
319: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
320: = 'SUI EE Withheld' then
321: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
322: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI Withheld';
323: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
324: = 'WC Withheld' then
325: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
318: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
319: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
320: = 'SUI EE Withheld' then
321: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
322: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI Withheld';
323: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
324: = 'WC Withheld' then
325: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
326: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
319: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
320: = 'SUI EE Withheld' then
321: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
322: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI Withheld';
323: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
324: = 'WC Withheld' then
325: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
326: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
327: = 'Workers Comp Withheld' then
321: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
322: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI Withheld';
323: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
324: = 'WC Withheld' then
325: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
326: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
327: = 'Workers Comp Withheld' then
328: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
329: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC Withheld';
322: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI Withheld';
323: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
324: = 'WC Withheld' then
325: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
326: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
327: = 'Workers Comp Withheld' then
328: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
329: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC Withheld';
330: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
324: = 'WC Withheld' then
325: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
326: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
327: = 'Workers Comp Withheld' then
328: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
329: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC Withheld';
330: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
331: = 'WC2 Withheld' then
332: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
325: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
326: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
327: = 'Workers Comp Withheld' then
328: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
329: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC Withheld';
330: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
331: = 'WC2 Withheld' then
332: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
333: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
326: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
327: = 'Workers Comp Withheld' then
328: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
329: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC Withheld';
330: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
331: = 'WC2 Withheld' then
332: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
333: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
334: = 'Workers Comp2 Withheld' then
328: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
329: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC Withheld';
330: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
331: = 'WC2 Withheld' then
332: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
333: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
334: = 'Workers Comp2 Withheld' then
335: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
336: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC2 Withheld';
329: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC Withheld';
330: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
331: = 'WC2 Withheld' then
332: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
333: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
334: = 'Workers Comp2 Withheld' then
335: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
336: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC2 Withheld';
337: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
331: = 'WC2 Withheld' then
332: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
333: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
334: = 'Workers Comp2 Withheld' then
335: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
336: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC2 Withheld';
337: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
338: = 'STEIC Advance' then
339: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10'; /*Bug 3231253*/
332: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
333: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
334: = 'Workers Comp2 Withheld' then
335: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
336: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC2 Withheld';
337: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
338: = 'STEIC Advance' then
339: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10'; /*Bug 3231253*/
340: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
333: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
334: = 'Workers Comp2 Withheld' then
335: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
336: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC2 Withheld';
337: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
338: = 'STEIC Advance' then
339: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10'; /*Bug 3231253*/
340: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
341: = 'Head Tax Withheld' then
335: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
336: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC2 Withheld';
337: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
338: = 'STEIC Advance' then
339: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10'; /*Bug 3231253*/
340: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
341: = 'Head Tax Withheld' then
342: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
343: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
336: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC2 Withheld';
337: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
338: = 'STEIC Advance' then
339: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10'; /*Bug 3231253*/
340: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
341: = 'Head Tax Withheld' then
342: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
343: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
344: = 'City Withheld' then
338: = 'STEIC Advance' then
339: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10'; /*Bug 3231253*/
340: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
341: = 'Head Tax Withheld' then
342: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
343: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
344: = 'City Withheld' then
345: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
346: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
339: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10'; /*Bug 3231253*/
340: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
341: = 'Head Tax Withheld' then
342: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
343: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
344: = 'City Withheld' then
345: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
346: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
347: = 'School Withheld' then
341: = 'Head Tax Withheld' then
342: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
343: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
344: = 'City Withheld' then
345: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
346: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
347: = 'School Withheld' then
348: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
349: end if;
342: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
343: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
344: = 'City Withheld' then
345: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
346: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
347: = 'School Withheld' then
348: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
349: end if;
350: end if;
344: = 'City Withheld' then
345: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
346: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
347: = 'School Withheld' then
348: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
349: end if;
350: end if;
351: end loop;
352: end if;
1589: lv_procedure_name VARCHAR2(100);
1590: lv_error_message VARCHAR2(200);
1591:
1592: ln_hrs_index NUMBER;
1593: ltr_hours_x_rate pay_ac_action_arch.hbr_table;
1594:
1595: ln_retro_rate NUMBER(15,5);
1596: ln_retro_multiple NUMBER(15,5);
1597: ln_retro_hours NUMBER(15,5);
1622: end if;
1623:
1624: if c_hbr%found then
1625: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1626: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1627: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1628: := 'EMPLOYEE HOURS BY RATE';
1629: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1630: := '00-000-0000';
1623:
1624: if c_hbr%found then
1625: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1626: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1627: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1628: := 'EMPLOYEE HOURS BY RATE';
1629: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1630: := '00-000-0000';
1631: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1625: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1626: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1627: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1628: := 'EMPLOYEE HOURS BY RATE';
1629: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1630: := '00-000-0000';
1631: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1632: := p_action_context_id;
1633: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1627: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1628: := 'EMPLOYEE HOURS BY RATE';
1629: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1630: := '00-000-0000';
1631: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1632: := p_action_context_id;
1633: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1634: := p_assignment_id;
1635: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1629: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1630: := '00-000-0000';
1631: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1632: := p_action_context_id;
1633: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1634: := p_assignment_id;
1635: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1636: := ln_element_type_id;
1637: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1631: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1632: := p_action_context_id;
1633: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1634: := p_assignment_id;
1635: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1636: := ln_element_type_id;
1637: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1638: := lv_element_name;
1639: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1633: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1634: := p_assignment_id;
1635: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1636: := ln_element_type_id;
1637: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1638: := lv_element_name;
1639: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1640: := fnd_number.number_to_canonical(ln_rate);
1641: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1635: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1636: := ln_element_type_id;
1637: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1638: := lv_element_name;
1639: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1640: := fnd_number.number_to_canonical(ln_rate);
1641: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1642: := fnd_number.number_to_canonical(ln_hours);
1643: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1637: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1638: := lv_element_name;
1639: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1640: := fnd_number.number_to_canonical(ln_rate);
1641: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1642: := fnd_number.number_to_canonical(ln_hours);
1643: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1644: := lv_processing_priority;
1645: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1639: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1640: := fnd_number.number_to_canonical(ln_rate);
1641: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1642: := fnd_number.number_to_canonical(ln_hours);
1643: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1644: := lv_processing_priority;
1645: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1646: := fnd_number.number_to_canonical(ln_multiple);
1647: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1641: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1642: := fnd_number.number_to_canonical(ln_hours);
1643: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1644: := lv_processing_priority;
1645: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1646: := fnd_number.number_to_canonical(ln_multiple);
1647: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1648: := fnd_number.number_to_canonical(ln_amount);
1649:
1643: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1644: := lv_processing_priority;
1645: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1646: := fnd_number.number_to_canonical(ln_multiple);
1647: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1648: := fnd_number.number_to_canonical(ln_amount);
1649:
1650: /******************************************************
1651: ** Insert into seperate table
1686: end if;
1687:
1688: if ltr_hours_x_rate.count > 0 then
1689: for z in ltr_hours_x_rate.first .. ltr_hours_x_rate.last loop
1690: if pay_ac_action_arch.lrr_act_tab.count > 0 then
1691: for i in pay_ac_action_arch.lrr_act_tab.first..
1692: pay_ac_action_arch.lrr_act_tab.last loop
1693: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
1694: = 'AC EARNINGS' and
1687:
1688: if ltr_hours_x_rate.count > 0 then
1689: for z in ltr_hours_x_rate.first .. ltr_hours_x_rate.last loop
1690: if pay_ac_action_arch.lrr_act_tab.count > 0 then
1691: for i in pay_ac_action_arch.lrr_act_tab.first..
1692: pay_ac_action_arch.lrr_act_tab.last loop
1693: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
1694: = 'AC EARNINGS' and
1695: pay_ac_action_arch.lrr_act_tab(i).action_context_id
1688: if ltr_hours_x_rate.count > 0 then
1689: for z in ltr_hours_x_rate.first .. ltr_hours_x_rate.last loop
1690: if pay_ac_action_arch.lrr_act_tab.count > 0 then
1691: for i in pay_ac_action_arch.lrr_act_tab.first..
1692: pay_ac_action_arch.lrr_act_tab.last loop
1693: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
1694: = 'AC EARNINGS' and
1695: pay_ac_action_arch.lrr_act_tab(i).action_context_id
1696: = p_action_context_id and
1689: for z in ltr_hours_x_rate.first .. ltr_hours_x_rate.last loop
1690: if pay_ac_action_arch.lrr_act_tab.count > 0 then
1691: for i in pay_ac_action_arch.lrr_act_tab.first..
1692: pay_ac_action_arch.lrr_act_tab.last loop
1693: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
1694: = 'AC EARNINGS' and
1695: pay_ac_action_arch.lrr_act_tab(i).action_context_id
1696: = p_action_context_id and
1697: pay_ac_action_arch.lrr_act_tab(i).act_info2
1691: for i in pay_ac_action_arch.lrr_act_tab.first..
1692: pay_ac_action_arch.lrr_act_tab.last loop
1693: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
1694: = 'AC EARNINGS' and
1695: pay_ac_action_arch.lrr_act_tab(i).action_context_id
1696: = p_action_context_id and
1697: pay_ac_action_arch.lrr_act_tab(i).act_info2
1698: = ltr_hours_x_rate(z).element_type_id then
1699: if ((ltr_hours_x_rate(z).hours <>
1693: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
1694: = 'AC EARNINGS' and
1695: pay_ac_action_arch.lrr_act_tab(i).action_context_id
1696: = p_action_context_id and
1697: pay_ac_action_arch.lrr_act_tab(i).act_info2
1698: = ltr_hours_x_rate(z).element_type_id then
1699: if ((ltr_hours_x_rate(z).hours <>
1700: pay_ac_action_arch.lrr_act_tab(i).act_info11) OR
1701: (ltr_hours_x_rate(z).amount <>
1696: = p_action_context_id and
1697: pay_ac_action_arch.lrr_act_tab(i).act_info2
1698: = ltr_hours_x_rate(z).element_type_id then
1699: if ((ltr_hours_x_rate(z).hours <>
1700: pay_ac_action_arch.lrr_act_tab(i).act_info11) OR
1701: (ltr_hours_x_rate(z).amount <>
1702: pay_ac_action_arch.lrr_act_tab(i).act_info8)) then
1703: --call function to get the retro data
1704: hr_utility.trace('HBR diff ' || ltr_hours_x_rate(z).element_name ||
1698: = ltr_hours_x_rate(z).element_type_id then
1699: if ((ltr_hours_x_rate(z).hours <>
1700: pay_ac_action_arch.lrr_act_tab(i).act_info11) OR
1701: (ltr_hours_x_rate(z).amount <>
1702: pay_ac_action_arch.lrr_act_tab(i).act_info8)) then
1703: --call function to get the retro data
1704: hr_utility.trace('HBR diff ' || ltr_hours_x_rate(z).element_name ||
1705: ' Element ID=' || ltr_hours_x_rate(z).element_type_id ||
1706: ' AC HBR=' ||
1703: --call function to get the retro data
1704: hr_utility.trace('HBR diff ' || ltr_hours_x_rate(z).element_name ||
1705: ' Element ID=' || ltr_hours_x_rate(z).element_type_id ||
1706: ' AC HBR=' ||
1707: pay_ac_action_arch.lrr_act_tab(i).act_info11 ||
1708: ' HBR Hours=' || ltr_hours_x_rate(z).hours ||
1709: ' p_run_action_id='||p_run_action_id);
1710: open c_retro(p_run_action_id, ltr_hours_x_rate(z).element_type_id);
1711: loop
1727: if ln_retro_multiple = 0 then
1728: ln_retro_multiple := 1;
1729: end if;
1730:
1731: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1732: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1733: := 'EMPLOYEE HOURS BY RATE';
1734: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1735: := '00-000-0000';
1728: ln_retro_multiple := 1;
1729: end if;
1730:
1731: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1732: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1733: := 'EMPLOYEE HOURS BY RATE';
1734: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1735: := '00-000-0000';
1736: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1730:
1731: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1732: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1733: := 'EMPLOYEE HOURS BY RATE';
1734: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1735: := '00-000-0000';
1736: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1737: := p_action_context_id;
1738: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1732: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1733: := 'EMPLOYEE HOURS BY RATE';
1734: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1735: := '00-000-0000';
1736: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1737: := p_action_context_id;
1738: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1739: := p_assignment_id;
1740: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1734: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1735: := '00-000-0000';
1736: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1737: := p_action_context_id;
1738: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1739: := p_assignment_id;
1740: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1741: := ltr_hours_x_rate(z).element_type_id;
1742: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1736: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1737: := p_action_context_id;
1738: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1739: := p_assignment_id;
1740: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1741: := ltr_hours_x_rate(z).element_type_id;
1742: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1743: := ltr_hours_x_rate(z).element_name;
1744: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1738: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1739: := p_assignment_id;
1740: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1741: := ltr_hours_x_rate(z).element_type_id;
1742: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1743: := ltr_hours_x_rate(z).element_name;
1744: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1745: := fnd_number.number_to_canonical(ln_retro_rate);
1746: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1740: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1741: := ltr_hours_x_rate(z).element_type_id;
1742: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1743: := ltr_hours_x_rate(z).element_name;
1744: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1745: := fnd_number.number_to_canonical(ln_retro_rate);
1746: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1747: := fnd_number.number_to_canonical(ln_retro_hours);
1748: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1742: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1743: := ltr_hours_x_rate(z).element_name;
1744: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1745: := fnd_number.number_to_canonical(ln_retro_rate);
1746: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1747: := fnd_number.number_to_canonical(ln_retro_hours);
1748: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1749: := ltr_hours_x_rate(z).processing_priority;
1750: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1744: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1745: := fnd_number.number_to_canonical(ln_retro_rate);
1746: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1747: := fnd_number.number_to_canonical(ln_retro_hours);
1748: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1749: := ltr_hours_x_rate(z).processing_priority;
1750: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1751: := fnd_number.number_to_canonical(nvl(ln_retro_multiple,1));
1752: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1746: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1747: := fnd_number.number_to_canonical(ln_retro_hours);
1748: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1749: := ltr_hours_x_rate(z).processing_priority;
1750: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1751: := fnd_number.number_to_canonical(nvl(ln_retro_multiple,1));
1752: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1753: := fnd_number.number_to_canonical(ln_retro_payvalue);
1754: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1748: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1749: := ltr_hours_x_rate(z).processing_priority;
1750: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1751: := fnd_number.number_to_canonical(nvl(ln_retro_multiple,1));
1752: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1753: := fnd_number.number_to_canonical(ln_retro_payvalue);
1754: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1755: end loop;
1756: close c_retro;
1800: lv_error_message VARCHAR2(200);
1801:
1802: BEGIN
1803: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1804: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
1805: hr_utility.trace('p_balance = '|| p_balance);
1806: hr_utility.trace('ln_bal_value = ' || p_bal_value);
1807:
1808: pay_ac_action_arch.lrr_act_tab(p_index).action_info_category
1804: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
1805: hr_utility.trace('p_balance = '|| p_balance);
1806: hr_utility.trace('ln_bal_value = ' || p_bal_value);
1807:
1808: pay_ac_action_arch.lrr_act_tab(p_index).action_info_category
1809: := p_category;
1810: pay_ac_action_arch.lrr_act_tab(p_index).jurisdiction_code
1811: := '00-000-0000';
1812:
1806: hr_utility.trace('ln_bal_value = ' || p_bal_value);
1807:
1808: pay_ac_action_arch.lrr_act_tab(p_index).action_info_category
1809: := p_category;
1810: pay_ac_action_arch.lrr_act_tab(p_index).jurisdiction_code
1811: := '00-000-0000';
1812:
1813: if p_balance = 'FIT Withheld' then
1814: pay_ac_action_arch.lrr_act_tab(p_index).act_info1 :=
1810: pay_ac_action_arch.lrr_act_tab(p_index).jurisdiction_code
1811: := '00-000-0000';
1812:
1813: if p_balance = 'FIT Withheld' then
1814: pay_ac_action_arch.lrr_act_tab(p_index).act_info1 :=
1815: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0)
1816: + p_bal_value ;
1817: elsif p_balance = 'Regular Earnings' then
1818: pay_ac_action_arch.lrr_act_tab(p_index).act_info2 :=
1811: := '00-000-0000';
1812:
1813: if p_balance = 'FIT Withheld' then
1814: pay_ac_action_arch.lrr_act_tab(p_index).act_info1 :=
1815: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0)
1816: + p_bal_value ;
1817: elsif p_balance = 'Regular Earnings' then
1818: pay_ac_action_arch.lrr_act_tab(p_index).act_info2 :=
1819: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0)
1814: pay_ac_action_arch.lrr_act_tab(p_index).act_info1 :=
1815: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0)
1816: + p_bal_value ;
1817: elsif p_balance = 'Regular Earnings' then
1818: pay_ac_action_arch.lrr_act_tab(p_index).act_info2 :=
1819: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0)
1820: + p_bal_value;
1821: elsif p_balance = 'Supplemental Earnings for FIT' then
1822: pay_ac_action_arch.lrr_act_tab(p_index).act_info3 :=
1815: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0)
1816: + p_bal_value ;
1817: elsif p_balance = 'Regular Earnings' then
1818: pay_ac_action_arch.lrr_act_tab(p_index).act_info2 :=
1819: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0)
1820: + p_bal_value;
1821: elsif p_balance = 'Supplemental Earnings for FIT' then
1822: pay_ac_action_arch.lrr_act_tab(p_index).act_info3 :=
1823: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0)
1818: pay_ac_action_arch.lrr_act_tab(p_index).act_info2 :=
1819: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0)
1820: + p_bal_value;
1821: elsif p_balance = 'Supplemental Earnings for FIT' then
1822: pay_ac_action_arch.lrr_act_tab(p_index).act_info3 :=
1823: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0)
1824: + p_bal_value;
1825: elsif p_balance = 'Supplemental Earnings for NWFIT' then
1826: pay_ac_action_arch.lrr_act_tab(p_index).act_info4 :=
1819: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0)
1820: + p_bal_value;
1821: elsif p_balance = 'Supplemental Earnings for FIT' then
1822: pay_ac_action_arch.lrr_act_tab(p_index).act_info3 :=
1823: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0)
1824: + p_bal_value;
1825: elsif p_balance = 'Supplemental Earnings for NWFIT' then
1826: pay_ac_action_arch.lrr_act_tab(p_index).act_info4 :=
1827: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0)
1822: pay_ac_action_arch.lrr_act_tab(p_index).act_info3 :=
1823: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0)
1824: + p_bal_value;
1825: elsif p_balance = 'Supplemental Earnings for NWFIT' then
1826: pay_ac_action_arch.lrr_act_tab(p_index).act_info4 :=
1827: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0)
1828: + p_bal_value;
1829: elsif p_balance = 'Pre Tax Deductions' then
1830: pay_ac_action_arch.lrr_act_tab(p_index).act_info5 :=
1823: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0)
1824: + p_bal_value;
1825: elsif p_balance = 'Supplemental Earnings for NWFIT' then
1826: pay_ac_action_arch.lrr_act_tab(p_index).act_info4 :=
1827: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0)
1828: + p_bal_value;
1829: elsif p_balance = 'Pre Tax Deductions' then
1830: pay_ac_action_arch.lrr_act_tab(p_index).act_info5 :=
1831: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0)
1826: pay_ac_action_arch.lrr_act_tab(p_index).act_info4 :=
1827: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0)
1828: + p_bal_value;
1829: elsif p_balance = 'Pre Tax Deductions' then
1830: pay_ac_action_arch.lrr_act_tab(p_index).act_info5 :=
1831: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0)
1832: + p_bal_value;
1833: elsif p_balance = 'Pre Tax Deductions for FIT' then
1834: pay_ac_action_arch.lrr_act_tab(p_index).act_info6 :=
1827: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0)
1828: + p_bal_value;
1829: elsif p_balance = 'Pre Tax Deductions' then
1830: pay_ac_action_arch.lrr_act_tab(p_index).act_info5 :=
1831: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0)
1832: + p_bal_value;
1833: elsif p_balance = 'Pre Tax Deductions for FIT' then
1834: pay_ac_action_arch.lrr_act_tab(p_index).act_info6 :=
1835: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0)
1830: pay_ac_action_arch.lrr_act_tab(p_index).act_info5 :=
1831: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0)
1832: + p_bal_value;
1833: elsif p_balance = 'Pre Tax Deductions for FIT' then
1834: pay_ac_action_arch.lrr_act_tab(p_index).act_info6 :=
1835: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0)
1836: + p_bal_value;
1837: elsif p_balance = 'SS EE Taxable' then
1838: pay_ac_action_arch.lrr_act_tab(p_index).act_info7 :=
1831: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0)
1832: + p_bal_value;
1833: elsif p_balance = 'Pre Tax Deductions for FIT' then
1834: pay_ac_action_arch.lrr_act_tab(p_index).act_info6 :=
1835: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0)
1836: + p_bal_value;
1837: elsif p_balance = 'SS EE Taxable' then
1838: pay_ac_action_arch.lrr_act_tab(p_index).act_info7 :=
1839: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0)
1834: pay_ac_action_arch.lrr_act_tab(p_index).act_info6 :=
1835: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0)
1836: + p_bal_value;
1837: elsif p_balance = 'SS EE Taxable' then
1838: pay_ac_action_arch.lrr_act_tab(p_index).act_info7 :=
1839: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0)
1840: + p_bal_value;
1841: elsif p_balance = 'SS EE Withheld' then
1842: pay_ac_action_arch.lrr_act_tab(p_index).act_info8 :=
1835: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0)
1836: + p_bal_value;
1837: elsif p_balance = 'SS EE Taxable' then
1838: pay_ac_action_arch.lrr_act_tab(p_index).act_info7 :=
1839: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0)
1840: + p_bal_value;
1841: elsif p_balance = 'SS EE Withheld' then
1842: pay_ac_action_arch.lrr_act_tab(p_index).act_info8 :=
1843: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0)
1838: pay_ac_action_arch.lrr_act_tab(p_index).act_info7 :=
1839: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0)
1840: + p_bal_value;
1841: elsif p_balance = 'SS EE Withheld' then
1842: pay_ac_action_arch.lrr_act_tab(p_index).act_info8 :=
1843: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0)
1844: + p_bal_value;
1845: elsif p_balance = 'SS ER Liability' then
1846: pay_ac_action_arch.lrr_act_tab(p_index).act_info9 :=
1839: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0)
1840: + p_bal_value;
1841: elsif p_balance = 'SS EE Withheld' then
1842: pay_ac_action_arch.lrr_act_tab(p_index).act_info8 :=
1843: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0)
1844: + p_bal_value;
1845: elsif p_balance = 'SS ER Liability' then
1846: pay_ac_action_arch.lrr_act_tab(p_index).act_info9 :=
1847: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0)
1842: pay_ac_action_arch.lrr_act_tab(p_index).act_info8 :=
1843: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0)
1844: + p_bal_value;
1845: elsif p_balance = 'SS ER Liability' then
1846: pay_ac_action_arch.lrr_act_tab(p_index).act_info9 :=
1847: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0)
1848: + p_bal_value ;
1849: elsif p_balance = 'SS ER Taxable' then
1850: pay_ac_action_arch.lrr_act_tab(p_index).act_info10 :=
1843: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0)
1844: + p_bal_value;
1845: elsif p_balance = 'SS ER Liability' then
1846: pay_ac_action_arch.lrr_act_tab(p_index).act_info9 :=
1847: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0)
1848: + p_bal_value ;
1849: elsif p_balance = 'SS ER Taxable' then
1850: pay_ac_action_arch.lrr_act_tab(p_index).act_info10 :=
1851: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0)
1846: pay_ac_action_arch.lrr_act_tab(p_index).act_info9 :=
1847: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0)
1848: + p_bal_value ;
1849: elsif p_balance = 'SS ER Taxable' then
1850: pay_ac_action_arch.lrr_act_tab(p_index).act_info10 :=
1851: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0)
1852: + p_bal_value ;
1853: elsif p_balance = 'Supplemental Earnings for SS' then
1854: pay_ac_action_arch.lrr_act_tab(p_index).act_info11 :=
1847: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0)
1848: + p_bal_value ;
1849: elsif p_balance = 'SS ER Taxable' then
1850: pay_ac_action_arch.lrr_act_tab(p_index).act_info10 :=
1851: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0)
1852: + p_bal_value ;
1853: elsif p_balance = 'Supplemental Earnings for SS' then
1854: pay_ac_action_arch.lrr_act_tab(p_index).act_info11 :=
1855: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0)
1850: pay_ac_action_arch.lrr_act_tab(p_index).act_info10 :=
1851: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0)
1852: + p_bal_value ;
1853: elsif p_balance = 'Supplemental Earnings for SS' then
1854: pay_ac_action_arch.lrr_act_tab(p_index).act_info11 :=
1855: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0)
1856: + p_bal_value;
1857: elsif p_balance = 'Pre Tax Deductions for SS' then
1858: pay_ac_action_arch.lrr_act_tab(p_index).act_info12 :=
1851: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0)
1852: + p_bal_value ;
1853: elsif p_balance = 'Supplemental Earnings for SS' then
1854: pay_ac_action_arch.lrr_act_tab(p_index).act_info11 :=
1855: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0)
1856: + p_bal_value;
1857: elsif p_balance = 'Pre Tax Deductions for SS' then
1858: pay_ac_action_arch.lrr_act_tab(p_index).act_info12 :=
1859: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0)
1854: pay_ac_action_arch.lrr_act_tab(p_index).act_info11 :=
1855: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0)
1856: + p_bal_value;
1857: elsif p_balance = 'Pre Tax Deductions for SS' then
1858: pay_ac_action_arch.lrr_act_tab(p_index).act_info12 :=
1859: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0)
1860: + p_bal_value;
1861: elsif p_balance = 'Medicare EE Taxable' then
1862: pay_ac_action_arch.lrr_act_tab(p_index).act_info13 :=
1855: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0)
1856: + p_bal_value;
1857: elsif p_balance = 'Pre Tax Deductions for SS' then
1858: pay_ac_action_arch.lrr_act_tab(p_index).act_info12 :=
1859: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0)
1860: + p_bal_value;
1861: elsif p_balance = 'Medicare EE Taxable' then
1862: pay_ac_action_arch.lrr_act_tab(p_index).act_info13 :=
1863: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0)
1858: pay_ac_action_arch.lrr_act_tab(p_index).act_info12 :=
1859: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0)
1860: + p_bal_value;
1861: elsif p_balance = 'Medicare EE Taxable' then
1862: pay_ac_action_arch.lrr_act_tab(p_index).act_info13 :=
1863: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0)
1864: + p_bal_value;
1865: elsif p_balance = 'Medicare EE Withheld' then
1866: pay_ac_action_arch.lrr_act_tab(p_index).act_info14 :=
1859: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0)
1860: + p_bal_value;
1861: elsif p_balance = 'Medicare EE Taxable' then
1862: pay_ac_action_arch.lrr_act_tab(p_index).act_info13 :=
1863: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0)
1864: + p_bal_value;
1865: elsif p_balance = 'Medicare EE Withheld' then
1866: pay_ac_action_arch.lrr_act_tab(p_index).act_info14 :=
1867: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0)
1862: pay_ac_action_arch.lrr_act_tab(p_index).act_info13 :=
1863: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0)
1864: + p_bal_value;
1865: elsif p_balance = 'Medicare EE Withheld' then
1866: pay_ac_action_arch.lrr_act_tab(p_index).act_info14 :=
1867: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0)
1868: + p_bal_value;
1869: elsif p_balance = 'Medicare ER Liability' then
1870: pay_ac_action_arch.lrr_act_tab(p_index).act_info15 :=
1863: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0)
1864: + p_bal_value;
1865: elsif p_balance = 'Medicare EE Withheld' then
1866: pay_ac_action_arch.lrr_act_tab(p_index).act_info14 :=
1867: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0)
1868: + p_bal_value;
1869: elsif p_balance = 'Medicare ER Liability' then
1870: pay_ac_action_arch.lrr_act_tab(p_index).act_info15 :=
1871: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0)
1866: pay_ac_action_arch.lrr_act_tab(p_index).act_info14 :=
1867: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0)
1868: + p_bal_value;
1869: elsif p_balance = 'Medicare ER Liability' then
1870: pay_ac_action_arch.lrr_act_tab(p_index).act_info15 :=
1871: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0)
1872: + p_bal_value ;
1873: elsif p_balance = 'Medicare ER Taxable' then
1874: pay_ac_action_arch.lrr_act_tab(p_index).act_info16 :=
1867: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0)
1868: + p_bal_value;
1869: elsif p_balance = 'Medicare ER Liability' then
1870: pay_ac_action_arch.lrr_act_tab(p_index).act_info15 :=
1871: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0)
1872: + p_bal_value ;
1873: elsif p_balance = 'Medicare ER Taxable' then
1874: pay_ac_action_arch.lrr_act_tab(p_index).act_info16 :=
1875: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0)
1870: pay_ac_action_arch.lrr_act_tab(p_index).act_info15 :=
1871: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0)
1872: + p_bal_value ;
1873: elsif p_balance = 'Medicare ER Taxable' then
1874: pay_ac_action_arch.lrr_act_tab(p_index).act_info16 :=
1875: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0)
1876: + p_bal_value;
1877: elsif p_balance = 'Supplemental Earnings for Medicare' then
1878: pay_ac_action_arch.lrr_act_tab(p_index).act_info17 :=
1871: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0)
1872: + p_bal_value ;
1873: elsif p_balance = 'Medicare ER Taxable' then
1874: pay_ac_action_arch.lrr_act_tab(p_index).act_info16 :=
1875: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0)
1876: + p_bal_value;
1877: elsif p_balance = 'Supplemental Earnings for Medicare' then
1878: pay_ac_action_arch.lrr_act_tab(p_index).act_info17 :=
1879: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0)
1874: pay_ac_action_arch.lrr_act_tab(p_index).act_info16 :=
1875: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0)
1876: + p_bal_value;
1877: elsif p_balance = 'Supplemental Earnings for Medicare' then
1878: pay_ac_action_arch.lrr_act_tab(p_index).act_info17 :=
1879: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0)
1880: + p_bal_value;
1881: elsif p_balance = 'Pre Tax Deductions for Medicare' then
1882: pay_ac_action_arch.lrr_act_tab(p_index).act_info18 :=
1875: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0)
1876: + p_bal_value;
1877: elsif p_balance = 'Supplemental Earnings for Medicare' then
1878: pay_ac_action_arch.lrr_act_tab(p_index).act_info17 :=
1879: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0)
1880: + p_bal_value;
1881: elsif p_balance = 'Pre Tax Deductions for Medicare' then
1882: pay_ac_action_arch.lrr_act_tab(p_index).act_info18 :=
1883: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
1878: pay_ac_action_arch.lrr_act_tab(p_index).act_info17 :=
1879: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0)
1880: + p_bal_value;
1881: elsif p_balance = 'Pre Tax Deductions for Medicare' then
1882: pay_ac_action_arch.lrr_act_tab(p_index).act_info18 :=
1883: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
1884: + p_bal_value;
1885: elsif p_balance = 'Supplemental Earnings for FUTA' then
1886: pay_ac_action_arch.lrr_act_tab(p_index).act_info19 :=
1879: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0)
1880: + p_bal_value;
1881: elsif p_balance = 'Pre Tax Deductions for Medicare' then
1882: pay_ac_action_arch.lrr_act_tab(p_index).act_info18 :=
1883: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
1884: + p_bal_value;
1885: elsif p_balance = 'Supplemental Earnings for FUTA' then
1886: pay_ac_action_arch.lrr_act_tab(p_index).act_info19 :=
1887: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
1882: pay_ac_action_arch.lrr_act_tab(p_index).act_info18 :=
1883: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
1884: + p_bal_value;
1885: elsif p_balance = 'Supplemental Earnings for FUTA' then
1886: pay_ac_action_arch.lrr_act_tab(p_index).act_info19 :=
1887: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
1888: + p_bal_value;
1889: elsif p_balance = 'Pre Tax Deductions for FUTA' then
1890: pay_ac_action_arch.lrr_act_tab(p_index).act_info20 :=
1883: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
1884: + p_bal_value;
1885: elsif p_balance = 'Supplemental Earnings for FUTA' then
1886: pay_ac_action_arch.lrr_act_tab(p_index).act_info19 :=
1887: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
1888: + p_bal_value;
1889: elsif p_balance = 'Pre Tax Deductions for FUTA' then
1890: pay_ac_action_arch.lrr_act_tab(p_index).act_info20 :=
1891: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
1886: pay_ac_action_arch.lrr_act_tab(p_index).act_info19 :=
1887: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
1888: + p_bal_value;
1889: elsif p_balance = 'Pre Tax Deductions for FUTA' then
1890: pay_ac_action_arch.lrr_act_tab(p_index).act_info20 :=
1891: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
1892: + p_bal_value;
1893: elsif p_balance = 'FUTA Taxable' then
1894: pay_ac_action_arch.lrr_act_tab(p_index).act_info21 :=
1887: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
1888: + p_bal_value;
1889: elsif p_balance = 'Pre Tax Deductions for FUTA' then
1890: pay_ac_action_arch.lrr_act_tab(p_index).act_info20 :=
1891: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
1892: + p_bal_value;
1893: elsif p_balance = 'FUTA Taxable' then
1894: pay_ac_action_arch.lrr_act_tab(p_index).act_info21 :=
1895: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
1890: pay_ac_action_arch.lrr_act_tab(p_index).act_info20 :=
1891: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
1892: + p_bal_value;
1893: elsif p_balance = 'FUTA Taxable' then
1894: pay_ac_action_arch.lrr_act_tab(p_index).act_info21 :=
1895: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
1896: + p_bal_value;
1897: elsif p_balance = 'FUTA Liability' then
1898: pay_ac_action_arch.lrr_act_tab(p_index).act_info22 :=
1891: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
1892: + p_bal_value;
1893: elsif p_balance = 'FUTA Taxable' then
1894: pay_ac_action_arch.lrr_act_tab(p_index).act_info21 :=
1895: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
1896: + p_bal_value;
1897: elsif p_balance = 'FUTA Liability' then
1898: pay_ac_action_arch.lrr_act_tab(p_index).act_info22 :=
1899: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0)
1894: pay_ac_action_arch.lrr_act_tab(p_index).act_info21 :=
1895: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
1896: + p_bal_value;
1897: elsif p_balance = 'FUTA Liability' then
1898: pay_ac_action_arch.lrr_act_tab(p_index).act_info22 :=
1899: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0)
1900: + p_bal_value;
1901: elsif p_balance = 'Gross Earnings' then
1902: pay_ac_action_arch.lrr_act_tab(p_index).act_info23 :=
1895: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
1896: + p_bal_value;
1897: elsif p_balance = 'FUTA Liability' then
1898: pay_ac_action_arch.lrr_act_tab(p_index).act_info22 :=
1899: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0)
1900: + p_bal_value;
1901: elsif p_balance = 'Gross Earnings' then
1902: pay_ac_action_arch.lrr_act_tab(p_index).act_info23 :=
1903: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0)
1898: pay_ac_action_arch.lrr_act_tab(p_index).act_info22 :=
1899: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0)
1900: + p_bal_value;
1901: elsif p_balance = 'Gross Earnings' then
1902: pay_ac_action_arch.lrr_act_tab(p_index).act_info23 :=
1903: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0)
1904: + p_bal_value;
1905: elsif p_balance = 'Pre Tax Deductions for EIC' then
1906: pay_ac_action_arch.lrr_act_tab(p_index).act_info24 :=
1899: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0)
1900: + p_bal_value;
1901: elsif p_balance = 'Gross Earnings' then
1902: pay_ac_action_arch.lrr_act_tab(p_index).act_info23 :=
1903: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0)
1904: + p_bal_value;
1905: elsif p_balance = 'Pre Tax Deductions for EIC' then
1906: pay_ac_action_arch.lrr_act_tab(p_index).act_info24 :=
1907: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0)
1902: pay_ac_action_arch.lrr_act_tab(p_index).act_info23 :=
1903: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0)
1904: + p_bal_value;
1905: elsif p_balance = 'Pre Tax Deductions for EIC' then
1906: pay_ac_action_arch.lrr_act_tab(p_index).act_info24 :=
1907: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0)
1908: + p_bal_value;
1909: elsif p_balance = 'Supplemental Earnings for EIC' then
1910: pay_ac_action_arch.lrr_act_tab(p_index).act_info25 :=
1903: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0)
1904: + p_bal_value;
1905: elsif p_balance = 'Pre Tax Deductions for EIC' then
1906: pay_ac_action_arch.lrr_act_tab(p_index).act_info24 :=
1907: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0)
1908: + p_bal_value;
1909: elsif p_balance = 'Supplemental Earnings for EIC' then
1910: pay_ac_action_arch.lrr_act_tab(p_index).act_info25 :=
1911: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0)
1906: pay_ac_action_arch.lrr_act_tab(p_index).act_info24 :=
1907: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0)
1908: + p_bal_value;
1909: elsif p_balance = 'Supplemental Earnings for EIC' then
1910: pay_ac_action_arch.lrr_act_tab(p_index).act_info25 :=
1911: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0)
1912: + p_bal_value;
1913: elsif p_balance = 'EIC Advance' then
1914: pay_ac_action_arch.lrr_act_tab(p_index).act_info26 :=
1907: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0)
1908: + p_bal_value;
1909: elsif p_balance = 'Supplemental Earnings for EIC' then
1910: pay_ac_action_arch.lrr_act_tab(p_index).act_info25 :=
1911: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0)
1912: + p_bal_value;
1913: elsif p_balance = 'EIC Advance' then
1914: pay_ac_action_arch.lrr_act_tab(p_index).act_info26 :=
1915: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0)
1910: pay_ac_action_arch.lrr_act_tab(p_index).act_info25 :=
1911: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0)
1912: + p_bal_value;
1913: elsif p_balance = 'EIC Advance' then
1914: pay_ac_action_arch.lrr_act_tab(p_index).act_info26 :=
1915: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0)
1916: + p_bal_value;
1917: end if;
1918:
1911: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0)
1912: + p_bal_value;
1913: elsif p_balance = 'EIC Advance' then
1914: pay_ac_action_arch.lrr_act_tab(p_index).act_info26 :=
1915: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0)
1916: + p_bal_value;
1917: end if;
1918:
1919: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1951: lv_error_message VARCHAR2(200);
1952:
1953: BEGIN
1954: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1955: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
1956: hr_utility.trace('p_balance = '|| p_balance);
1957: hr_utility.trace('p_bal_value = ' || p_bal_value);
1958:
1959: if p_balance = 'SIT Withheld' then
1956: hr_utility.trace('p_balance = '|| p_balance);
1957: hr_utility.trace('p_bal_value = ' || p_bal_value);
1958:
1959: if p_balance = 'SIT Withheld' then
1960: pay_ac_action_arch.lrr_act_tab(p_index).act_info1
1961: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
1962: p_bal_value ;
1963: elsif p_balance = 'SIT Subj Whable' then
1964: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
1957: hr_utility.trace('p_bal_value = ' || p_bal_value);
1958:
1959: if p_balance = 'SIT Withheld' then
1960: pay_ac_action_arch.lrr_act_tab(p_index).act_info1
1961: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
1962: p_bal_value ;
1963: elsif p_balance = 'SIT Subj Whable' then
1964: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
1965: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
1960: pay_ac_action_arch.lrr_act_tab(p_index).act_info1
1961: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
1962: p_bal_value ;
1963: elsif p_balance = 'SIT Subj Whable' then
1964: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
1965: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
1966: p_bal_value;
1967: elsif p_balance = 'SIT Subj NWhable' then
1968: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
1961: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
1962: p_bal_value ;
1963: elsif p_balance = 'SIT Subj Whable' then
1964: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
1965: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
1966: p_bal_value;
1967: elsif p_balance = 'SIT Subj NWhable' then
1968: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
1969: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
1964: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
1965: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
1966: p_bal_value;
1967: elsif p_balance = 'SIT Subj NWhable' then
1968: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
1969: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
1970: p_bal_value;
1971: elsif p_balance = 'SIT Pre Tax Redns' then
1972: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
1965: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
1966: p_bal_value;
1967: elsif p_balance = 'SIT Subj NWhable' then
1968: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
1969: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
1970: p_bal_value;
1971: elsif p_balance = 'SIT Pre Tax Redns' then
1972: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
1973: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
1968: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
1969: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
1970: p_bal_value;
1971: elsif p_balance = 'SIT Pre Tax Redns' then
1972: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
1973: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
1974: p_bal_value;
1975: elsif p_balance = 'SIT Gross' then
1976: pay_ac_action_arch.lrr_act_tab(p_index).act_info17
1969: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
1970: p_bal_value;
1971: elsif p_balance = 'SIT Pre Tax Redns' then
1972: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
1973: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
1974: p_bal_value;
1975: elsif p_balance = 'SIT Gross' then
1976: pay_ac_action_arch.lrr_act_tab(p_index).act_info17
1977: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0) +
1972: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
1973: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
1974: p_bal_value;
1975: elsif p_balance = 'SIT Gross' then
1976: pay_ac_action_arch.lrr_act_tab(p_index).act_info17
1977: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0) +
1978: p_bal_value ;
1979: end if;
1980:
1973: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
1974: p_bal_value;
1975: elsif p_balance = 'SIT Gross' then
1976: pay_ac_action_arch.lrr_act_tab(p_index).act_info17
1977: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0) +
1978: p_bal_value ;
1979: end if;
1980:
1981: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2013: lv_error_message VARCHAR2(200);
2014:
2015: BEGIN
2016: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2017: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2018: hr_utility.trace('p_balance = '|| p_balance);
2019: hr_utility.trace('p_bal_value = ' || p_bal_value);
2020:
2021: if p_balance = 'SDI EE Withheld' then
2018: hr_utility.trace('p_balance = '|| p_balance);
2019: hr_utility.trace('p_bal_value = ' || p_bal_value);
2020:
2021: if p_balance = 'SDI EE Withheld' then
2022: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2023: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2024: p_bal_value ;
2025: elsif p_balance = 'SDI EE Taxable' then
2026: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2019: hr_utility.trace('p_bal_value = ' || p_bal_value);
2020:
2021: if p_balance = 'SDI EE Withheld' then
2022: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2023: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2024: p_bal_value ;
2025: elsif p_balance = 'SDI EE Taxable' then
2026: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2027: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2022: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2023: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2024: p_bal_value ;
2025: elsif p_balance = 'SDI EE Taxable' then
2026: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2027: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2028: p_bal_value;
2029: elsif p_balance = 'SDI EE Subj Whable' then
2030: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2023: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2024: p_bal_value ;
2025: elsif p_balance = 'SDI EE Taxable' then
2026: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2027: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2028: p_bal_value;
2029: elsif p_balance = 'SDI EE Subj Whable' then
2030: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2031: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2026: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2027: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2028: p_bal_value;
2029: elsif p_balance = 'SDI EE Subj Whable' then
2030: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2031: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2032: p_bal_value;
2033: elsif p_balance = 'SDI EE Pre Tax Redns' then
2034: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
2027: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2028: p_bal_value;
2029: elsif p_balance = 'SDI EE Subj Whable' then
2030: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2031: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2032: p_bal_value;
2033: elsif p_balance = 'SDI EE Pre Tax Redns' then
2034: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
2035: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
2030: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2031: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2032: p_bal_value;
2033: elsif p_balance = 'SDI EE Pre Tax Redns' then
2034: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
2035: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
2036: p_bal_value;
2037: elsif p_balance = 'SDI EE Gross' then
2038: pay_ac_action_arch.lrr_act_tab(p_index).act_info26
2031: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2032: p_bal_value;
2033: elsif p_balance = 'SDI EE Pre Tax Redns' then
2034: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
2035: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
2036: p_bal_value;
2037: elsif p_balance = 'SDI EE Gross' then
2038: pay_ac_action_arch.lrr_act_tab(p_index).act_info26
2039: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0) +
2034: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
2035: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
2036: p_bal_value;
2037: elsif p_balance = 'SDI EE Gross' then
2038: pay_ac_action_arch.lrr_act_tab(p_index).act_info26
2039: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0) +
2040: p_bal_value ;
2041: end if;
2042:
2035: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
2036: p_bal_value;
2037: elsif p_balance = 'SDI EE Gross' then
2038: pay_ac_action_arch.lrr_act_tab(p_index).act_info26
2039: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0) +
2040: p_bal_value ;
2041: end if;
2042:
2043: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2077: lv_error_message VARCHAR2(200);
2078:
2079: BEGIN
2080: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2081: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2082: hr_utility.trace('p_balance = '|| p_balance);
2083: hr_utility.trace('p_bal_value = ' || p_bal_value);
2084:
2085: if p_balance = 'SDI ER Liability' then
2082: hr_utility.trace('p_balance = '|| p_balance);
2083: hr_utility.trace('p_bal_value = ' || p_bal_value);
2084:
2085: if p_balance = 'SDI ER Liability' then
2086: pay_ac_action_arch.lrr_act_tab(p_index).act_info9
2087: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0) +
2088: p_bal_value;
2089: elsif p_balance = 'SDI ER Taxable' then
2090: pay_ac_action_arch.lrr_act_tab(p_index).act_info10
2083: hr_utility.trace('p_bal_value = ' || p_bal_value);
2084:
2085: if p_balance = 'SDI ER Liability' then
2086: pay_ac_action_arch.lrr_act_tab(p_index).act_info9
2087: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0) +
2088: p_bal_value;
2089: elsif p_balance = 'SDI ER Taxable' then
2090: pay_ac_action_arch.lrr_act_tab(p_index).act_info10
2091: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0) +
2086: pay_ac_action_arch.lrr_act_tab(p_index).act_info9
2087: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0) +
2088: p_bal_value;
2089: elsif p_balance = 'SDI ER Taxable' then
2090: pay_ac_action_arch.lrr_act_tab(p_index).act_info10
2091: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0) +
2092: p_bal_value;
2093: elsif p_balance = 'SDI ER Subj Whable' then
2094: pay_ac_action_arch.lrr_act_tab(p_index).act_info11
2087: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0) +
2088: p_bal_value;
2089: elsif p_balance = 'SDI ER Taxable' then
2090: pay_ac_action_arch.lrr_act_tab(p_index).act_info10
2091: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0) +
2092: p_bal_value;
2093: elsif p_balance = 'SDI ER Subj Whable' then
2094: pay_ac_action_arch.lrr_act_tab(p_index).act_info11
2095: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0) +
2090: pay_ac_action_arch.lrr_act_tab(p_index).act_info10
2091: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0) +
2092: p_bal_value;
2093: elsif p_balance = 'SDI ER Subj Whable' then
2094: pay_ac_action_arch.lrr_act_tab(p_index).act_info11
2095: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0) +
2096: p_bal_value;
2097: elsif p_balance = 'SDI ER Pre Tax Redns' then
2098: pay_ac_action_arch.lrr_act_tab(p_index).act_info12
2091: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0) +
2092: p_bal_value;
2093: elsif p_balance = 'SDI ER Subj Whable' then
2094: pay_ac_action_arch.lrr_act_tab(p_index).act_info11
2095: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0) +
2096: p_bal_value;
2097: elsif p_balance = 'SDI ER Pre Tax Redns' then
2098: pay_ac_action_arch.lrr_act_tab(p_index).act_info12
2099: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0) +
2094: pay_ac_action_arch.lrr_act_tab(p_index).act_info11
2095: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0) +
2096: p_bal_value;
2097: elsif p_balance = 'SDI ER Pre Tax Redns' then
2098: pay_ac_action_arch.lrr_act_tab(p_index).act_info12
2099: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0) +
2100: p_bal_value ;
2101: elsif p_balance = 'SDI ER Gross' then
2102: pay_ac_action_arch.lrr_act_tab(p_index).act_info27
2095: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0) +
2096: p_bal_value;
2097: elsif p_balance = 'SDI ER Pre Tax Redns' then
2098: pay_ac_action_arch.lrr_act_tab(p_index).act_info12
2099: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0) +
2100: p_bal_value ;
2101: elsif p_balance = 'SDI ER Gross' then
2102: pay_ac_action_arch.lrr_act_tab(p_index).act_info27
2103: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info27,0) +
2098: pay_ac_action_arch.lrr_act_tab(p_index).act_info12
2099: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0) +
2100: p_bal_value ;
2101: elsif p_balance = 'SDI ER Gross' then
2102: pay_ac_action_arch.lrr_act_tab(p_index).act_info27
2103: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info27,0) +
2104: p_bal_value;
2105: end if;
2106:
2099: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0) +
2100: p_bal_value ;
2101: elsif p_balance = 'SDI ER Gross' then
2102: pay_ac_action_arch.lrr_act_tab(p_index).act_info27
2103: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info27,0) +
2104: p_bal_value;
2105: end if;
2106:
2107: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2139: lv_error_message VARCHAR2(200);
2140:
2141: BEGIN
2142: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2143: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2144: hr_utility.trace('p_balance = '|| p_balance);
2145: hr_utility.trace('p_bal_value = ' || p_bal_value);
2146:
2147: if p_balance = 'SUI EE Withheld' then
2144: hr_utility.trace('p_balance = '|| p_balance);
2145: hr_utility.trace('p_bal_value = ' || p_bal_value);
2146:
2147: if p_balance = 'SUI EE Withheld' then
2148: pay_ac_action_arch.lrr_act_tab(p_index).act_info13
2149: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0) +
2150: p_bal_value;
2151: elsif p_balance = 'SUI EE Taxable' then
2152: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2145: hr_utility.trace('p_bal_value = ' || p_bal_value);
2146:
2147: if p_balance = 'SUI EE Withheld' then
2148: pay_ac_action_arch.lrr_act_tab(p_index).act_info13
2149: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0) +
2150: p_bal_value;
2151: elsif p_balance = 'SUI EE Taxable' then
2152: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2153: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2148: pay_ac_action_arch.lrr_act_tab(p_index).act_info13
2149: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0) +
2150: p_bal_value;
2151: elsif p_balance = 'SUI EE Taxable' then
2152: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2153: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2154: p_bal_value;
2155: elsif p_balance = 'SUI EE Subj Whable' then
2156: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2149: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0) +
2150: p_bal_value;
2151: elsif p_balance = 'SUI EE Taxable' then
2152: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2153: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2154: p_bal_value;
2155: elsif p_balance = 'SUI EE Subj Whable' then
2156: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2157: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2152: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2153: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2154: p_bal_value;
2155: elsif p_balance = 'SUI EE Subj Whable' then
2156: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2157: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2158: p_bal_value;
2159: elsif p_balance = 'SUI EE Pre Tax Redns' then
2160: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2153: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2154: p_bal_value;
2155: elsif p_balance = 'SUI EE Subj Whable' then
2156: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2157: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2158: p_bal_value;
2159: elsif p_balance = 'SUI EE Pre Tax Redns' then
2160: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2161: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2156: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2157: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2158: p_bal_value;
2159: elsif p_balance = 'SUI EE Pre Tax Redns' then
2160: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2161: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2162: p_bal_value;
2163: elsif p_balance = 'SUI EE Gross' then
2164: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2157: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2158: p_bal_value;
2159: elsif p_balance = 'SUI EE Pre Tax Redns' then
2160: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2161: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2162: p_bal_value;
2163: elsif p_balance = 'SUI EE Gross' then
2164: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2165: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info28,0) +
2160: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2161: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2162: p_bal_value;
2163: elsif p_balance = 'SUI EE Gross' then
2164: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2165: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info28,0) +
2166: p_bal_value;
2167: end if;
2168: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2161: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2162: p_bal_value;
2163: elsif p_balance = 'SUI EE Gross' then
2164: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2165: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info28,0) +
2166: p_bal_value;
2167: end if;
2168: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2169:
2200: lv_error_message VARCHAR2(200);
2201:
2202: BEGIN
2203: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2204: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2205: hr_utility.trace('p_balance = '|| p_balance);
2206: hr_utility.trace('p_bal_value = ' || p_bal_value);
2207:
2208: if p_balance = 'SUI ER Taxable' then
2205: hr_utility.trace('p_balance = '|| p_balance);
2206: hr_utility.trace('p_bal_value = ' || p_bal_value);
2207:
2208: if p_balance = 'SUI ER Taxable' then
2209: pay_ac_action_arch.lrr_act_tab(p_index).act_info18
2210: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
2211: + p_bal_value;
2212: elsif p_balance = 'SUI ER Subj Whable' then
2213: pay_ac_action_arch.lrr_act_tab(p_index).act_info19
2206: hr_utility.trace('p_bal_value = ' || p_bal_value);
2207:
2208: if p_balance = 'SUI ER Taxable' then
2209: pay_ac_action_arch.lrr_act_tab(p_index).act_info18
2210: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
2211: + p_bal_value;
2212: elsif p_balance = 'SUI ER Subj Whable' then
2213: pay_ac_action_arch.lrr_act_tab(p_index).act_info19
2214: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2209: pay_ac_action_arch.lrr_act_tab(p_index).act_info18
2210: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
2211: + p_bal_value;
2212: elsif p_balance = 'SUI ER Subj Whable' then
2213: pay_ac_action_arch.lrr_act_tab(p_index).act_info19
2214: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2215: + p_bal_value;
2216: elsif p_balance = 'SUI ER Pre Tax Redns' then
2217: pay_ac_action_arch.lrr_act_tab(p_index).act_info20
2210: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
2211: + p_bal_value;
2212: elsif p_balance = 'SUI ER Subj Whable' then
2213: pay_ac_action_arch.lrr_act_tab(p_index).act_info19
2214: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2215: + p_bal_value;
2216: elsif p_balance = 'SUI ER Pre Tax Redns' then
2217: pay_ac_action_arch.lrr_act_tab(p_index).act_info20
2218: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2213: pay_ac_action_arch.lrr_act_tab(p_index).act_info19
2214: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2215: + p_bal_value;
2216: elsif p_balance = 'SUI ER Pre Tax Redns' then
2217: pay_ac_action_arch.lrr_act_tab(p_index).act_info20
2218: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2219: + p_bal_value;
2220: elsif p_balance = 'SUI ER Liability' then
2221: pay_ac_action_arch.lrr_act_tab(p_index).act_info21
2214: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2215: + p_bal_value;
2216: elsif p_balance = 'SUI ER Pre Tax Redns' then
2217: pay_ac_action_arch.lrr_act_tab(p_index).act_info20
2218: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2219: + p_bal_value;
2220: elsif p_balance = 'SUI ER Liability' then
2221: pay_ac_action_arch.lrr_act_tab(p_index).act_info21
2222: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2217: pay_ac_action_arch.lrr_act_tab(p_index).act_info20
2218: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2219: + p_bal_value;
2220: elsif p_balance = 'SUI ER Liability' then
2221: pay_ac_action_arch.lrr_act_tab(p_index).act_info21
2222: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2223: + p_bal_value;
2224: elsif p_balance = 'SUI ER Gross' then
2225: pay_ac_action_arch.lrr_act_tab(p_index).act_info29
2218: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2219: + p_bal_value;
2220: elsif p_balance = 'SUI ER Liability' then
2221: pay_ac_action_arch.lrr_act_tab(p_index).act_info21
2222: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2223: + p_bal_value;
2224: elsif p_balance = 'SUI ER Gross' then
2225: pay_ac_action_arch.lrr_act_tab(p_index).act_info29
2226: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info29,0)
2221: pay_ac_action_arch.lrr_act_tab(p_index).act_info21
2222: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2223: + p_bal_value;
2224: elsif p_balance = 'SUI ER Gross' then
2225: pay_ac_action_arch.lrr_act_tab(p_index).act_info29
2226: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info29,0)
2227: + p_bal_value;
2228: end if;
2229: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2222: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2223: + p_bal_value;
2224: elsif p_balance = 'SUI ER Gross' then
2225: pay_ac_action_arch.lrr_act_tab(p_index).act_info29
2226: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info29,0)
2227: + p_bal_value;
2228: end if;
2229: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2230:
2261: lv_error_message VARCHAR2(200);
2262:
2263: BEGIN
2264: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2265: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2266: hr_utility.trace('p_balance = '|| p_balance);
2267: hr_utility.trace('p_bal_value = ' || p_bal_value);
2268:
2269: if p_balance = 'Workers Comp Withheld' then
2266: hr_utility.trace('p_balance = '|| p_balance);
2267: hr_utility.trace('p_bal_value = ' || p_bal_value);
2268:
2269: if p_balance = 'Workers Comp Withheld' then
2270: pay_ac_action_arch.lrr_act_tab(p_index).act_info22
2271: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0) +
2272: p_bal_value ;
2273: elsif p_balance = 'Workers Comp2 Withheld' then
2274: pay_ac_action_arch.lrr_act_tab(p_index).act_info23
2267: hr_utility.trace('p_bal_value = ' || p_bal_value);
2268:
2269: if p_balance = 'Workers Comp Withheld' then
2270: pay_ac_action_arch.lrr_act_tab(p_index).act_info22
2271: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0) +
2272: p_bal_value ;
2273: elsif p_balance = 'Workers Comp2 Withheld' then
2274: pay_ac_action_arch.lrr_act_tab(p_index).act_info23
2275: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0) +
2270: pay_ac_action_arch.lrr_act_tab(p_index).act_info22
2271: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0) +
2272: p_bal_value ;
2273: elsif p_balance = 'Workers Comp2 Withheld' then
2274: pay_ac_action_arch.lrr_act_tab(p_index).act_info23
2275: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0) +
2276: p_bal_value;
2277: elsif p_balance = 'Workers Compensation2 ER' then
2278: pay_ac_action_arch.lrr_act_tab(p_index).act_info24
2271: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0) +
2272: p_bal_value ;
2273: elsif p_balance = 'Workers Comp2 Withheld' then
2274: pay_ac_action_arch.lrr_act_tab(p_index).act_info23
2275: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0) +
2276: p_bal_value;
2277: elsif p_balance = 'Workers Compensation2 ER' then
2278: pay_ac_action_arch.lrr_act_tab(p_index).act_info24
2279: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0) +
2274: pay_ac_action_arch.lrr_act_tab(p_index).act_info23
2275: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0) +
2276: p_bal_value;
2277: elsif p_balance = 'Workers Compensation2 ER' then
2278: pay_ac_action_arch.lrr_act_tab(p_index).act_info24
2279: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0) +
2280: p_bal_value;
2281: elsif p_balance = 'Workers Compensation3 ER' then
2282: pay_ac_action_arch.lrr_act_tab(p_index).act_info25
2275: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0) +
2276: p_bal_value;
2277: elsif p_balance = 'Workers Compensation2 ER' then
2278: pay_ac_action_arch.lrr_act_tab(p_index).act_info24
2279: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0) +
2280: p_bal_value;
2281: elsif p_balance = 'Workers Compensation3 ER' then
2282: pay_ac_action_arch.lrr_act_tab(p_index).act_info25
2283: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0) +
2278: pay_ac_action_arch.lrr_act_tab(p_index).act_info24
2279: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0) +
2280: p_bal_value;
2281: elsif p_balance = 'Workers Compensation3 ER' then
2282: pay_ac_action_arch.lrr_act_tab(p_index).act_info25
2283: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0) +
2284: p_bal_value;
2285: end if;
2286: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2279: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0) +
2280: p_bal_value;
2281: elsif p_balance = 'Workers Compensation3 ER' then
2282: pay_ac_action_arch.lrr_act_tab(p_index).act_info25
2283: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0) +
2284: p_bal_value;
2285: end if;
2286: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2287:
2318: lv_error_message VARCHAR2(200);
2319:
2320: BEGIN
2321: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2322: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2323: hr_utility.trace('p_balance = '|| p_balance);
2324: hr_utility.trace('p_bal_value = ' || p_bal_value);
2325:
2326: if p_balance = 'STEIC Advance' then
2323: hr_utility.trace('p_balance = '|| p_balance);
2324: hr_utility.trace('p_bal_value = ' || p_bal_value);
2325:
2326: if p_balance = 'STEIC Advance' then
2327: pay_ac_action_arch.lrr_act_tab(p_index).act_info30
2328: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info30,0) +
2329: p_bal_value ;
2330: end if;
2331:
2324: hr_utility.trace('p_bal_value = ' || p_bal_value);
2325:
2326: if p_balance = 'STEIC Advance' then
2327: pay_ac_action_arch.lrr_act_tab(p_index).act_info30
2328: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info30,0) +
2329: p_bal_value ;
2330: end if;
2331:
2332: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2364: lv_error_message VARCHAR2(200);
2365:
2366: BEGIN
2367: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2368: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2369: hr_utility.trace('p_balance = '|| p_balance);
2370: hr_utility.trace('p_bal_value = ' || p_bal_value);
2371:
2372: if p_balance = 'County Withheld' then
2369: hr_utility.trace('p_balance = '|| p_balance);
2370: hr_utility.trace('p_bal_value = ' || p_bal_value);
2371:
2372: if p_balance = 'County Withheld' then
2373: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2374: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2375: p_bal_value ;
2376: elsif p_balance = 'County Subj Whable' then
2377: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2370: hr_utility.trace('p_bal_value = ' || p_bal_value);
2371:
2372: if p_balance = 'County Withheld' then
2373: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2374: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2375: p_bal_value ;
2376: elsif p_balance = 'County Subj Whable' then
2377: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2378: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2373: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2374: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2375: p_bal_value ;
2376: elsif p_balance = 'County Subj Whable' then
2377: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2378: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2379: p_bal_value;
2380: elsif p_balance = 'County Subj NWhable' then
2381: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2374: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2375: p_bal_value ;
2376: elsif p_balance = 'County Subj Whable' then
2377: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2378: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2379: p_bal_value;
2380: elsif p_balance = 'County Subj NWhable' then
2381: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2382: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2377: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2378: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2379: p_bal_value;
2380: elsif p_balance = 'County Subj NWhable' then
2381: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2382: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2383: p_bal_value;
2384: elsif p_balance = 'County Pre Tax Redns' then
2385: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2378: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2379: p_bal_value;
2380: elsif p_balance = 'County Subj NWhable' then
2381: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2382: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2383: p_bal_value;
2384: elsif p_balance = 'County Pre Tax Redns' then
2385: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2386: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2381: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2382: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2383: p_bal_value;
2384: elsif p_balance = 'County Pre Tax Redns' then
2385: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2386: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2387: p_bal_value;
2388: elsif p_balance = 'County Gross' then
2389: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2382: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2383: p_bal_value;
2384: elsif p_balance = 'County Pre Tax Redns' then
2385: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2386: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2387: p_bal_value;
2388: elsif p_balance = 'County Gross' then
2389: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2390: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2385: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2386: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2387: p_bal_value;
2388: elsif p_balance = 'County Gross' then
2389: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2390: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2391: p_bal_value ;
2392: end if;
2393: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2386: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2387: p_bal_value;
2388: elsif p_balance = 'County Gross' then
2389: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2390: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2391: p_bal_value ;
2392: end if;
2393: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2394:
2425: lv_error_message VARCHAR2(200);
2426:
2427: BEGIN
2428: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2429: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2430: hr_utility.trace('p_balance = '|| p_balance);
2431: hr_utility.trace('p_bal_value = ' || p_bal_value);
2432:
2433: if p_balance = 'Head Tax Liability' then
2430: hr_utility.trace('p_balance = '|| p_balance);
2431: hr_utility.trace('p_bal_value = ' || p_bal_value);
2432:
2433: if p_balance = 'Head Tax Liability' then
2434: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2435: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2436: p_bal_value;
2437: elsif p_balance = 'Head Tax Withheld' then
2438: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2431: hr_utility.trace('p_bal_value = ' || p_bal_value);
2432:
2433: if p_balance = 'Head Tax Liability' then
2434: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2435: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2436: p_bal_value;
2437: elsif p_balance = 'Head Tax Withheld' then
2438: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2439: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2434: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2435: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2436: p_bal_value;
2437: elsif p_balance = 'Head Tax Withheld' then
2438: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2439: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2440: p_bal_value;
2441: end if;
2442: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2435: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2436: p_bal_value;
2437: elsif p_balance = 'Head Tax Withheld' then
2438: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2439: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2440: p_bal_value;
2441: end if;
2442: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2443:
2474: lv_error_message VARCHAR2(200);
2475:
2476: BEGIN
2477: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2478: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2479: hr_utility.trace('p_balance = '|| p_balance);
2480: hr_utility.trace('p_bal_value = ' || p_bal_value);
2481:
2482: if p_balance = 'City Withheld' then
2479: hr_utility.trace('p_balance = '|| p_balance);
2480: hr_utility.trace('p_bal_value = ' || p_bal_value);
2481:
2482: if p_balance = 'City Withheld' then
2483: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2484: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2485: p_bal_value;
2486: elsif p_balance = 'City Subj Whable' then
2487: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2480: hr_utility.trace('p_bal_value = ' || p_bal_value);
2481:
2482: if p_balance = 'City Withheld' then
2483: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2484: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2485: p_bal_value;
2486: elsif p_balance = 'City Subj Whable' then
2487: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2488: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2483: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2484: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2485: p_bal_value;
2486: elsif p_balance = 'City Subj Whable' then
2487: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2488: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2489: p_bal_value;
2490: elsif p_balance = 'City Subj NWhable' then
2491: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2484: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2485: p_bal_value;
2486: elsif p_balance = 'City Subj Whable' then
2487: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2488: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2489: p_bal_value;
2490: elsif p_balance = 'City Subj NWhable' then
2491: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2492: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2487: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2488: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2489: p_bal_value;
2490: elsif p_balance = 'City Subj NWhable' then
2491: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2492: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2493: p_bal_value;
2494: elsif p_balance = 'City Pre Tax Redns' then
2495: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2488: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2489: p_bal_value;
2490: elsif p_balance = 'City Subj NWhable' then
2491: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2492: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2493: p_bal_value;
2494: elsif p_balance = 'City Pre Tax Redns' then
2495: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2496: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2491: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2492: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2493: p_bal_value;
2494: elsif p_balance = 'City Pre Tax Redns' then
2495: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2496: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2497: p_bal_value;
2498: elsif p_balance = 'City Gross' then
2499: pay_ac_action_arch.lrr_act_tab(p_index ).act_info7
2492: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2493: p_bal_value;
2494: elsif p_balance = 'City Pre Tax Redns' then
2495: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2496: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2497: p_bal_value;
2498: elsif p_balance = 'City Gross' then
2499: pay_ac_action_arch.lrr_act_tab(p_index ).act_info7
2500: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2495: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2496: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2497: p_bal_value;
2498: elsif p_balance = 'City Gross' then
2499: pay_ac_action_arch.lrr_act_tab(p_index ).act_info7
2500: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2501: p_bal_value;
2502: end if;
2503: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2496: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2497: p_bal_value;
2498: elsif p_balance = 'City Gross' then
2499: pay_ac_action_arch.lrr_act_tab(p_index ).act_info7
2500: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2501: p_bal_value;
2502: end if;
2503: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2504:
2535: lv_error_message VARCHAR2(200);
2536:
2537: BEGIN
2538: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2539: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2540: hr_utility.trace('p_balance = '|| p_balance);
2541: hr_utility.trace('p_bal_value = ' || p_bal_value);
2542:
2543: if p_balance = 'Head Tax Liability' then
2540: hr_utility.trace('p_balance = '|| p_balance);
2541: hr_utility.trace('p_bal_value = ' || p_bal_value);
2542:
2543: if p_balance = 'Head Tax Liability' then
2544: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2545: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2546: p_bal_value;
2547: elsif p_balance = 'Head Tax Withheld' then
2548: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2541: hr_utility.trace('p_bal_value = ' || p_bal_value);
2542:
2543: if p_balance = 'Head Tax Liability' then
2544: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2545: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2546: p_bal_value;
2547: elsif p_balance = 'Head Tax Withheld' then
2548: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2549: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2544: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2545: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2546: p_bal_value;
2547: elsif p_balance = 'Head Tax Withheld' then
2548: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2549: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2550: p_bal_value;
2551: end if;
2552: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2545: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2546: p_bal_value;
2547: elsif p_balance = 'Head Tax Withheld' then
2548: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2549: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2550: p_bal_value;
2551: end if;
2552: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2553:
2584: lv_error_message VARCHAR2(200);
2585:
2586: BEGIN
2587: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2588: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2589: hr_utility.trace('p_balance = '|| p_balance);
2590: hr_utility.trace('p_bal_value = ' || p_bal_value);
2591:
2592: if p_balance = 'School Withheld' then
2589: hr_utility.trace('p_balance = '|| p_balance);
2590: hr_utility.trace('p_bal_value = ' || p_bal_value);
2591:
2592: if p_balance = 'School Withheld' then
2593: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2594: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2595: p_bal_value ;
2596: elsif p_balance = 'School Subj Whable' then
2597: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2590: hr_utility.trace('p_bal_value = ' || p_bal_value);
2591:
2592: if p_balance = 'School Withheld' then
2593: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2594: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2595: p_bal_value ;
2596: elsif p_balance = 'School Subj Whable' then
2597: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2598: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2593: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2594: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2595: p_bal_value ;
2596: elsif p_balance = 'School Subj Whable' then
2597: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2598: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2599: p_bal_value;
2600: elsif p_balance = 'School Subj NWhable' then
2601: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2594: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2595: p_bal_value ;
2596: elsif p_balance = 'School Subj Whable' then
2597: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2598: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2599: p_bal_value;
2600: elsif p_balance = 'School Subj NWhable' then
2601: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2602: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2597: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2598: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2599: p_bal_value;
2600: elsif p_balance = 'School Subj NWhable' then
2601: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2602: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2603: + p_bal_value;
2604: elsif p_balance = 'School Pre Tax Redns' then
2605: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2598: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2599: p_bal_value;
2600: elsif p_balance = 'School Subj NWhable' then
2601: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2602: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2603: + p_bal_value;
2604: elsif p_balance = 'School Pre Tax Redns' then
2605: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2606: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2601: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2602: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2603: + p_bal_value;
2604: elsif p_balance = 'School Pre Tax Redns' then
2605: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2606: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2607: p_bal_value;
2608: elsif p_balance = 'School Gross' then
2609: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2602: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2603: + p_bal_value;
2604: elsif p_balance = 'School Pre Tax Redns' then
2605: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2606: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2607: p_bal_value;
2608: elsif p_balance = 'School Gross' then
2609: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2610: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2605: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2606: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2607: p_bal_value;
2608: elsif p_balance = 'School Gross' then
2609: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2610: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2611: p_bal_value;
2612: end if;
2613: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2606: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2607: p_bal_value;
2608: elsif p_balance = 'School Gross' then
2609: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2610: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2611: p_bal_value;
2612: end if;
2613: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2614:
2898: BEGIN
2899: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2900: if p_curr_withheld <> 0 or p_ytd_withheld <> 0 then -- Bug 3561821
2901:
2902: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2903: hr_utility.trace('ln_index = ' || ln_index);
2904:
2905: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2906: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2901:
2902: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2903: hr_utility.trace('ln_index = ' || ln_index);
2904:
2905: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2906: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2907: := 'Tax Deductions';
2908: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2909: := p_jurisdiction;
2902: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2903: hr_utility.trace('ln_index = ' || ln_index);
2904:
2905: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2906: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2907: := 'Tax Deductions';
2908: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2909: := p_jurisdiction;
2910: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2904:
2905: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2906: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2907: := 'Tax Deductions';
2908: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2909: := p_jurisdiction;
2910: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2911: := p_balance_name;
2912: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2906: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2907: := 'Tax Deductions';
2908: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2909: := p_jurisdiction;
2910: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2911: := p_balance_name;
2912: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2913: := p_balance_type_id;
2914: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
2908: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2909: := p_jurisdiction;
2910: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2911: := p_balance_name;
2912: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2913: := p_balance_type_id;
2914: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
2915: := p_processing_priority;
2916:
2910: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2911: := p_balance_name;
2912: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2913: := p_balance_type_id;
2914: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
2915: := p_processing_priority;
2916:
2917: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2918: := 'AC DEDUCTIONS';
2913: := p_balance_type_id;
2914: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
2915: := p_processing_priority;
2916:
2917: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2918: := 'AC DEDUCTIONS';
2919: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2920: := p_jurisdiction;
2921: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2915: := p_processing_priority;
2916:
2917: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2918: := 'AC DEDUCTIONS';
2919: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2920: := p_jurisdiction;
2921: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2922: := p_xfr_action_id;
2923: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2917: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2918: := 'AC DEDUCTIONS';
2919: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2920: := p_jurisdiction;
2921: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2922: := p_xfr_action_id;
2923: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2924: := 'Tax Deductions';
2925: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2919: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2920: := p_jurisdiction;
2921: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2922: := p_xfr_action_id;
2923: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2924: := 'Tax Deductions';
2925: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2926: := p_balance_type_id ;
2927: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2921: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2922: := p_xfr_action_id;
2923: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2924: := 'Tax Deductions';
2925: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2926: := p_balance_type_id ;
2927: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2928: := p_processing_priority;
2929: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2923: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2924: := 'Tax Deductions';
2925: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2926: := p_balance_type_id ;
2927: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2928: := p_processing_priority;
2929: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2930: := fnd_number.number_to_canonical(nvl(p_curr_withheld,0));
2931: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2925: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2926: := p_balance_type_id ;
2927: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2928: := p_processing_priority;
2929: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2930: := fnd_number.number_to_canonical(nvl(p_curr_withheld,0));
2931: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2932: := fnd_number.number_to_canonical(nvl(p_ytd_withheld,0));
2933: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2927: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2928: := p_processing_priority;
2929: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2930: := fnd_number.number_to_canonical(nvl(p_curr_withheld,0));
2931: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2932: := fnd_number.number_to_canonical(nvl(p_ytd_withheld,0));
2933: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2934: := p_balance_name ;
2935: OPEN get_display_name( p_balance_name ,p_jurisdiction ) ;
2929: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2930: := fnd_number.number_to_canonical(nvl(p_curr_withheld,0));
2931: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2932: := fnd_number.number_to_canonical(nvl(p_ytd_withheld,0));
2933: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2934: := p_balance_name ;
2935: OPEN get_display_name( p_balance_name ,p_jurisdiction ) ;
2936: FETCH get_display_name INTO lv_display_name ;
2937: IF get_display_name%FOUND THEN
2944: END IF;
2945: IF get_display_name%ISOPEN THEN
2946: close get_display_name;
2947: END IF;
2948: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
2949: := lv_display_name ;
2950: end if;
2951: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2952:
2983: ln_table_index NUMBER;
2984: lv_index_flag VARCHAR2(1) := 'N';
2985:
2986: BEGIN
2987: if pay_ac_action_arch.lrr_act_tab.count > 0 then
2988: for j in pay_ac_action_arch.lrr_act_tab.first ..
2989: pay_ac_action_arch.lrr_act_tab.last loop
2990:
2991: if pay_ac_action_arch.lrr_act_tab(j).jurisdiction_code
2984: lv_index_flag VARCHAR2(1) := 'N';
2985:
2986: BEGIN
2987: if pay_ac_action_arch.lrr_act_tab.count > 0 then
2988: for j in pay_ac_action_arch.lrr_act_tab.first ..
2989: pay_ac_action_arch.lrr_act_tab.last loop
2990:
2991: if pay_ac_action_arch.lrr_act_tab(j).jurisdiction_code
2992: = p_jurisdiction_code and
2985:
2986: BEGIN
2987: if pay_ac_action_arch.lrr_act_tab.count > 0 then
2988: for j in pay_ac_action_arch.lrr_act_tab.first ..
2989: pay_ac_action_arch.lrr_act_tab.last loop
2990:
2991: if pay_ac_action_arch.lrr_act_tab(j).jurisdiction_code
2992: = p_jurisdiction_code and
2993: pay_ac_action_arch.lrr_act_tab(j).action_info_category
2987: if pay_ac_action_arch.lrr_act_tab.count > 0 then
2988: for j in pay_ac_action_arch.lrr_act_tab.first ..
2989: pay_ac_action_arch.lrr_act_tab.last loop
2990:
2991: if pay_ac_action_arch.lrr_act_tab(j).jurisdiction_code
2992: = p_jurisdiction_code and
2993: pay_ac_action_arch.lrr_act_tab(j).action_info_category
2994: in ('US FEDERAL', 'US STATE',
2995: 'US COUNTY', 'US CITY',
2989: pay_ac_action_arch.lrr_act_tab.last loop
2990:
2991: if pay_ac_action_arch.lrr_act_tab(j).jurisdiction_code
2992: = p_jurisdiction_code and
2993: pay_ac_action_arch.lrr_act_tab(j).action_info_category
2994: in ('US FEDERAL', 'US STATE',
2995: 'US COUNTY', 'US CITY',
2996: 'US SCHOOL DISTRICT') then
2997: ln_table_index := j;
3001: end loop;
3002: end if;
3003:
3004: if lv_index_flag <> 'Y' then
3005: ln_table_index := pay_ac_action_arch.lrr_act_tab.count;
3006: end if;
3007: hr_utility.trace('ln_table_index = '|| ln_table_index);
3008:
3009: return(ln_table_index);
3119: end if;
3120:
3121: elsif lv_balance_name = 'SS ER Taxable' then
3122: ln_bal_value
3123: := pay_ac_action_arch.lrr_act_tab(ln_index).act_info7;
3124: -- elsif lv_balance_name = 'SS ER Liability' then
3125: -- ln_bal_value
3126: -- := pay_ac_action_arch.lrr_act_tab(ln_index).act_info8;
3127: elsif lv_balance_name = 'Medicare ER Taxable' then
3122: ln_bal_value
3123: := pay_ac_action_arch.lrr_act_tab(ln_index).act_info7;
3124: -- elsif lv_balance_name = 'SS ER Liability' then
3125: -- ln_bal_value
3126: -- := pay_ac_action_arch.lrr_act_tab(ln_index).act_info8;
3127: elsif lv_balance_name = 'Medicare ER Taxable' then
3128: ln_bal_value
3129: := pay_ac_action_arch.lrr_act_tab(ln_index).act_info13;
3130: -- elsif lv_balance_name = 'Medicare ER Liability' then
3125: -- ln_bal_value
3126: -- := pay_ac_action_arch.lrr_act_tab(ln_index).act_info8;
3127: elsif lv_balance_name = 'Medicare ER Taxable' then
3128: ln_bal_value
3129: := pay_ac_action_arch.lrr_act_tab(ln_index).act_info13;
3130: -- elsif lv_balance_name = 'Medicare ER Liability' then
3131: -- ln_bal_value
3132: -- := pay_ac_action_arch.lrr_act_tab(ln_index).act_info14;
3133: end if;
3128: ln_bal_value
3129: := pay_ac_action_arch.lrr_act_tab(ln_index).act_info13;
3130: -- elsif lv_balance_name = 'Medicare ER Liability' then
3131: -- ln_bal_value
3132: -- := pay_ac_action_arch.lrr_act_tab(ln_index).act_info14;
3133: end if;
3134:
3135: else
3136: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3279: ,p_pymt_balcall_aaid in number default null
3280: ,p_ytd_balcall_aaid in number default null
3281: ,p_rqp_action_id in number
3282: ,p_action_type in varchar2
3283: ,p_jurisdiction_tab in pay_ac_action_arch.emp_jd_rec_table)
3284: IS
3285: ln_index NUMBER ;
3286: lv_balance_name VARCHAR2(80);
3287: ln_balance_type_id NUMBER;
3355: ln_step := 2;
3356: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd);
3357: hr_utility.trace('ln_index for state is '||to_char(ln_index));
3358:
3359: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3360: := 'US STATE';
3361: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3362: := p_jurisdiction_tab(i).emp_jd;
3363:
3357: hr_utility.trace('ln_index for state is '||to_char(ln_index));
3358:
3359: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3360: := 'US STATE';
3361: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3362: := p_jurisdiction_tab(i).emp_jd;
3363:
3364: if pay_us_action_arch.ltr_state_tax_bal.count > 0 then
3365: --(
3686: ,p_action_type in varchar2
3687: ,p_resident_state in varchar2
3688: ,p_resident_county in varchar2
3689: ,p_resident_city in varchar2
3690: ,p_jurisdiction_tab in pay_ac_action_arch.emp_jd_rec_table)
3691: IS
3692: ln_index NUMBER ;
3693: lv_balance_name VARCHAR2(80);
3694: ln_balance_type_id NUMBER;
3748: p_jurisdiction_tab(i).emp_jd);
3749:
3750: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd);
3751:
3752: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3753: := p_jurisdiction_tab(i).emp_jd;
3754: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3755: := 'US COUNTY';
3756:
3750: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd);
3751:
3752: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3753: := p_jurisdiction_tab(i).emp_jd;
3754: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3755: := 'US COUNTY';
3756:
3757: if p_jurisdiction_tab(i).emp_jd
3758: = p_resident_state||'-'||p_resident_county|| '-0000' then
3755: := 'US COUNTY';
3756:
3757: if p_jurisdiction_tab(i).emp_jd
3758: = p_resident_state||'-'||p_resident_county|| '-0000' then
3759: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'R';
3760: else
3761: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
3762: end if;
3763:
3757: if p_jurisdiction_tab(i).emp_jd
3758: = p_resident_state||'-'||p_resident_county|| '-0000' then
3759: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'R';
3760: else
3761: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
3762: end if;
3763:
3764: if pay_us_action_arch.ltr_county_tax_bal.count > 0 then
3765: for k in pay_us_action_arch.ltr_county_tax_bal.first..
3887: ,p_resident_state in varchar2
3888: ,p_resident_county in varchar2
3889: ,p_resident_city in varchar2
3890: ,p_effective_date in date
3891: ,p_jurisdiction_tab in pay_ac_action_arch.emp_jd_rec_table)
3892: IS
3893: ln_index NUMBER ;
3894: lv_balance_name VARCHAR2(80);
3895: ln_balance_type_id NUMBER;
3933:
3934: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd);
3935: hr_utility.trace('Index = '|| ln_index);
3936:
3937: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3938: := p_jurisdiction_tab(i).emp_jd;
3939: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3940: := 'US CITY';
3941:
3935: hr_utility.trace('Index = '|| ln_index);
3936:
3937: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3938: := p_jurisdiction_tab(i).emp_jd;
3939: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3940: := 'US CITY';
3941:
3942: /************************************************************
3943: ** When comparing the City Jurisdiction for
3949: || '-000-'
3950: || substr(p_jurisdiction_tab(i).emp_jd,8,4)
3951: = p_resident_state || '-000-'
3952: || p_resident_city then
3953: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'R';
3954: else
3955: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
3956: end if;
3957:
3951: = p_resident_state || '-000-'
3952: || p_resident_city then
3953: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'R';
3954: else
3955: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
3956: end if;
3957:
3958: if pay_us_action_arch.ltr_city_tax_bal.count > 0 then
3959: for k in pay_us_action_arch.ltr_city_tax_bal.first..
4083: ,p_pymt_balcall_aaid in number default null
4084: ,p_ytd_balcall_aaid in number default null
4085: ,p_rqp_action_id in number
4086: ,p_action_type in varchar2
4087: ,p_jurisdiction_tab in pay_ac_action_arch.emp_rec_table)
4088: IS
4089: ln_index NUMBER ;
4090: lv_balance_name VARCHAR2(80);
4091: ln_balance_type_id NUMBER;
4119:
4120: lv_emp_school_jd := p_jurisdiction_tab(j).emp_jd;
4121: ln_index := get_table_index(p_jurisdiction_tab(j).emp_jd);
4122:
4123: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4124: := p_jurisdiction_tab(j).emp_jd;
4125: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4126: := 'US SCHOOL DISTRICT';
4127: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30
4121: ln_index := get_table_index(p_jurisdiction_tab(j).emp_jd);
4122:
4123: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4124: := p_jurisdiction_tab(j).emp_jd;
4125: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4126: := 'US SCHOOL DISTRICT';
4127: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30
4128: := p_jurisdiction_tab(j).emp_parent_jd;
4129:
4123: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4124: := p_jurisdiction_tab(j).emp_jd;
4125: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4126: := 'US SCHOOL DISTRICT';
4127: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30
4128: := p_jurisdiction_tab(j).emp_parent_jd;
4129:
4130: if pay_us_action_arch.ltr_schdist_tax_bal.count > 0 then
4131: for k in pay_us_action_arch.ltr_schdist_tax_bal.first..
4480: -- a safety check. We don't care about Federal JD
4481: null;
4482: elsif length(lv_rr_jurisdiction_code) = 11 and
4483: substr(lv_rr_jurisdiction_code, 4) = '000-0000' then
4484: ln_index := pay_ac_action_arch.emp_state_jd.count;
4485: pay_ac_action_arch.emp_state_jd(ln_index).emp_jd
4486: := lv_rr_jurisdiction_code;
4487: /*************************************************************
4488: ** Populate the PLSQL table emp_county_jd with this jd
4481: null;
4482: elsif length(lv_rr_jurisdiction_code) = 11 and
4483: substr(lv_rr_jurisdiction_code, 4) = '000-0000' then
4484: ln_index := pay_ac_action_arch.emp_state_jd.count;
4485: pay_ac_action_arch.emp_state_jd(ln_index).emp_jd
4486: := lv_rr_jurisdiction_code;
4487: /*************************************************************
4488: ** Populate the PLSQL table emp_county_jd with this jd
4489: *************************************************************/
4489: *************************************************************/
4490: elsif length(lv_rr_jurisdiction_code) = 11 and
4491: substr(lv_rr_jurisdiction_code,8) = '0000' and
4492: substr(lv_rr_jurisdiction_code,4,3) <> '000' then
4493: ln_index := pay_ac_action_arch.emp_county_jd.count;
4494: pay_ac_action_arch.emp_county_jd(ln_index).emp_jd
4495: := lv_rr_jurisdiction_code;
4496: /*************************************************************
4497: ** Populate the PLSQL table emp_city_jd with this jd
4490: elsif length(lv_rr_jurisdiction_code) = 11 and
4491: substr(lv_rr_jurisdiction_code,8) = '0000' and
4492: substr(lv_rr_jurisdiction_code,4,3) <> '000' then
4493: ln_index := pay_ac_action_arch.emp_county_jd.count;
4494: pay_ac_action_arch.emp_county_jd(ln_index).emp_jd
4495: := lv_rr_jurisdiction_code;
4496: /*************************************************************
4497: ** Populate the PLSQL table emp_city_jd with this jd
4498: *************************************************************/
4497: ** Populate the PLSQL table emp_city_jd with this jd
4498: *************************************************************/
4499: elsif length(lv_rr_jurisdiction_code) = 11 and
4500: substr(lv_rr_jurisdiction_code,8) <> '0000' then
4501: ln_index := pay_ac_action_arch.emp_city_jd.count;
4502: pay_ac_action_arch.emp_city_jd(ln_index).emp_jd := lv_rr_jurisdiction_code;
4503: /*************************************************************
4504: ** Populate the PLSQL table emp_school_jd with this jd
4505: *************************************************************/
4498: *************************************************************/
4499: elsif length(lv_rr_jurisdiction_code) = 11 and
4500: substr(lv_rr_jurisdiction_code,8) <> '0000' then
4501: ln_index := pay_ac_action_arch.emp_city_jd.count;
4502: pay_ac_action_arch.emp_city_jd(ln_index).emp_jd := lv_rr_jurisdiction_code;
4503: /*************************************************************
4504: ** Populate the PLSQL table emp_school_jd with this jd
4505: *************************************************************/
4506: elsif length(lv_rr_jurisdiction_code) = 8 then
4512: ,p_start_date => p_start_date
4513: ,p_end_date => p_end_date);
4514: end if;
4515:
4516: ln_index := pay_ac_action_arch.emp_school_jd.count;
4517: pay_ac_action_arch.emp_school_jd(ln_index).emp_jd
4518: := lv_rr_jurisdiction_code;
4519: pay_ac_action_arch.emp_school_jd(ln_index).emp_parent_jd
4520: := lv_rr_sd_parent_jd;
4513: ,p_end_date => p_end_date);
4514: end if;
4515:
4516: ln_index := pay_ac_action_arch.emp_school_jd.count;
4517: pay_ac_action_arch.emp_school_jd(ln_index).emp_jd
4518: := lv_rr_jurisdiction_code;
4519: pay_ac_action_arch.emp_school_jd(ln_index).emp_parent_jd
4520: := lv_rr_sd_parent_jd;
4521: end if;
4515:
4516: ln_index := pay_ac_action_arch.emp_school_jd.count;
4517: pay_ac_action_arch.emp_school_jd(ln_index).emp_jd
4518: := lv_rr_jurisdiction_code;
4519: pay_ac_action_arch.emp_school_jd(ln_index).emp_parent_jd
4520: := lv_rr_sd_parent_jd;
4521: end if;
4522: end if;
4523: end loop;
4557: ,p_pymt_balcall_aaid => p_pymt_balcall_aaid
4558: ,p_ytd_balcall_aaid => p_ytd_balcall_aaid
4559: ,p_rqp_action_id => p_rqp_action_id
4560: ,p_action_type => p_action_type
4561: ,p_jurisdiction_tab => pay_ac_action_arch.emp_state_jd);
4562: hr_utility.set_location(gv_package || lv_procedure_name, 70);
4563:
4564: /*****************************************************************
4565: ** County Information Archiving
4572: ,p_resident_state => lv_resident_state
4573: ,p_resident_county => lv_resident_county
4574: ,p_resident_city => lv_resident_city
4575: ,p_action_type => p_action_type
4576: ,p_jurisdiction_tab => pay_ac_action_arch.emp_county_jd);
4577:
4578: /*****************************************************************
4579: ** City Information Archiving
4580: *****************************************************************/
4587: ,p_resident_state => lv_resident_state
4588: ,p_resident_county => lv_resident_county
4589: ,p_resident_city => lv_resident_city
4590: ,p_effective_date => p_end_date
4591: ,p_jurisdiction_tab => pay_ac_action_arch.emp_city_jd);
4592:
4593: /*****************************************************************
4594: ** School District Information Archiving
4595: *****************************************************************/
4598: ,p_pymt_balcall_aaid => p_pymt_balcall_aaid
4599: ,p_ytd_balcall_aaid => p_ytd_balcall_aaid
4600: ,p_rqp_action_id => p_rqp_action_id
4601: ,p_action_type => p_action_type
4602: ,p_jurisdiction_tab => pay_ac_action_arch.emp_school_jd);
4603:
4604:
4605: EXCEPTION
4606: when others then
4695: ** Populate the PLSQL table emp_state_jd with this jd
4696: *************************************************************/
4697: if length(lv_baladj_jurisdiction_code) = 11 and
4698: substr(lv_baladj_jurisdiction_code, 4) = '000-0000' then
4699: ln_index := pay_ac_action_arch.emp_state_jd.count;
4700: pay_ac_action_arch.emp_state_jd(ln_index).emp_jd
4701: := lv_baladj_jurisdiction_code;
4702: /*************************************************************
4703: ** Populate the PLSQL table emp_county_jd with this jd
4696: *************************************************************/
4697: if length(lv_baladj_jurisdiction_code) = 11 and
4698: substr(lv_baladj_jurisdiction_code, 4) = '000-0000' then
4699: ln_index := pay_ac_action_arch.emp_state_jd.count;
4700: pay_ac_action_arch.emp_state_jd(ln_index).emp_jd
4701: := lv_baladj_jurisdiction_code;
4702: /*************************************************************
4703: ** Populate the PLSQL table emp_county_jd with this jd
4704: *************************************************************/
4704: *************************************************************/
4705: elsif length(lv_baladj_jurisdiction_code) = 11 and
4706: substr(lv_baladj_jurisdiction_code,8) = '0000' and
4707: substr(lv_baladj_jurisdiction_code,4,3) <> '000' then
4708: ln_index := pay_ac_action_arch.emp_county_jd.count;
4709: pay_ac_action_arch.emp_county_jd(ln_index).emp_jd
4710: := lv_baladj_jurisdiction_code;
4711: /*************************************************************
4712: ** Populate the PLSQL table emp_city_jd with this jd
4705: elsif length(lv_baladj_jurisdiction_code) = 11 and
4706: substr(lv_baladj_jurisdiction_code,8) = '0000' and
4707: substr(lv_baladj_jurisdiction_code,4,3) <> '000' then
4708: ln_index := pay_ac_action_arch.emp_county_jd.count;
4709: pay_ac_action_arch.emp_county_jd(ln_index).emp_jd
4710: := lv_baladj_jurisdiction_code;
4711: /*************************************************************
4712: ** Populate the PLSQL table emp_city_jd with this jd
4713: *************************************************************/
4712: ** Populate the PLSQL table emp_city_jd with this jd
4713: *************************************************************/
4714: elsif length(lv_baladj_jurisdiction_code) = 11 and
4715: substr(lv_baladj_jurisdiction_code,8) <> '0000' then
4716: ln_index := pay_ac_action_arch.emp_city_jd.count;
4717: pay_ac_action_arch.emp_city_jd(ln_index).emp_jd := lv_baladj_jurisdiction_code;
4718: /*************************************************************
4719: ** Populate the PLSQL table emp_school_jd with this jd
4720: *************************************************************/
4713: *************************************************************/
4714: elsif length(lv_baladj_jurisdiction_code) = 11 and
4715: substr(lv_baladj_jurisdiction_code,8) <> '0000' then
4716: ln_index := pay_ac_action_arch.emp_city_jd.count;
4717: pay_ac_action_arch.emp_city_jd(ln_index).emp_jd := lv_baladj_jurisdiction_code;
4718: /*************************************************************
4719: ** Populate the PLSQL table emp_school_jd with this jd
4720: *************************************************************/
4721: elsif length(lv_baladj_jurisdiction_code) = 8 then
4726: ,p_start_date => p_start_date
4727: ,p_end_date => p_end_date);
4728: end if;
4729:
4730: ln_index := pay_ac_action_arch.emp_school_jd.count;
4731: pay_ac_action_arch.emp_school_jd(ln_index).emp_jd := lv_baladj_jurisdiction_code;
4732: pay_ac_action_arch.emp_school_jd(ln_index).emp_parent_jd := lv_rr_sd_parent_jd;
4733: end if;
4734: end loop;
4727: ,p_end_date => p_end_date);
4728: end if;
4729:
4730: ln_index := pay_ac_action_arch.emp_school_jd.count;
4731: pay_ac_action_arch.emp_school_jd(ln_index).emp_jd := lv_baladj_jurisdiction_code;
4732: pay_ac_action_arch.emp_school_jd(ln_index).emp_parent_jd := lv_rr_sd_parent_jd;
4733: end if;
4734: end loop;
4735: close c_get_baladj_jd;
4728: end if;
4729:
4730: ln_index := pay_ac_action_arch.emp_school_jd.count;
4731: pay_ac_action_arch.emp_school_jd(ln_index).emp_jd := lv_baladj_jurisdiction_code;
4732: pay_ac_action_arch.emp_school_jd(ln_index).emp_parent_jd := lv_rr_sd_parent_jd;
4733: end if;
4734: end loop;
4735: close c_get_baladj_jd;
4736: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4763: populate_state_tax_balances(
4764: p_xfr_action_id => p_xfr_action_id
4765: ,p_rqp_action_id => ln_baladj_action_id
4766: ,p_action_type => p_action_type
4767: ,p_jurisdiction_tab => pay_ac_action_arch.emp_state_jd);
4768: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4769:
4770: /*****************************************************************
4771: ** County Information Archiving
4776: ,p_resident_state => lv_resident_state
4777: ,p_resident_county => lv_resident_county
4778: ,p_resident_city => lv_resident_city
4779: ,p_action_type => p_action_type
4780: ,p_jurisdiction_tab => pay_ac_action_arch.emp_county_jd);
4781: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4782:
4783: /*****************************************************************
4784: ** City Information Archiving
4790: ,p_resident_state => lv_resident_state
4791: ,p_resident_county => lv_resident_county
4792: ,p_resident_city => lv_resident_city
4793: ,p_effective_date => p_end_date
4794: ,p_jurisdiction_tab => pay_ac_action_arch.emp_city_jd);
4795: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4796:
4797: /*****************************************************************
4798: ** School District Information Archiving
4800: populate_school_tax_balances(
4801: p_xfr_action_id => p_xfr_action_id
4802: ,p_rqp_action_id => ln_baladj_action_id
4803: ,p_action_type => p_action_type
4804: ,p_jurisdiction_tab => pay_ac_action_arch.emp_school_jd);
4805: hr_utility.set_location(gv_package || lv_procedure_name, 110);
4806:
4807: /*****************************************************************
4808: ** Initialize the PL/SQL tables for State, County, City and School
4806:
4807: /*****************************************************************
4808: ** Initialize the PL/SQL tables for State, County, City and School
4809: *****************************************************************/
4810: pay_ac_action_arch.emp_state_jd.delete;
4811: pay_ac_action_arch.emp_city_jd.delete;
4812: pay_ac_action_arch.emp_county_jd.delete;
4813: pay_ac_action_arch.emp_school_jd.delete;
4814: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4807: /*****************************************************************
4808: ** Initialize the PL/SQL tables for State, County, City and School
4809: *****************************************************************/
4810: pay_ac_action_arch.emp_state_jd.delete;
4811: pay_ac_action_arch.emp_city_jd.delete;
4812: pay_ac_action_arch.emp_county_jd.delete;
4813: pay_ac_action_arch.emp_school_jd.delete;
4814: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4815:
4808: ** Initialize the PL/SQL tables for State, County, City and School
4809: *****************************************************************/
4810: pay_ac_action_arch.emp_state_jd.delete;
4811: pay_ac_action_arch.emp_city_jd.delete;
4812: pay_ac_action_arch.emp_county_jd.delete;
4813: pay_ac_action_arch.emp_school_jd.delete;
4814: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4815:
4816: end loop;
4809: *****************************************************************/
4810: pay_ac_action_arch.emp_state_jd.delete;
4811: pay_ac_action_arch.emp_city_jd.delete;
4812: pay_ac_action_arch.emp_county_jd.delete;
4813: pay_ac_action_arch.emp_school_jd.delete;
4814: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4815:
4816: end loop;
4817: close c_get_emp_adjbal;
5031: ln_fit_override_rate;
5032: if c_emp_fed_info%found then
5033: hr_utility.trace('Going to write get_withholding_info record for fed');
5034:
5035: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5036:
5037: hr_utility.trace('ln_index in get_withholding_info proc is '
5038: || pay_ac_action_arch.lrr_act_tab.count);
5039:
5034:
5035: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5036:
5037: hr_utility.trace('ln_index in get_withholding_info proc is '
5038: || pay_ac_action_arch.lrr_act_tab.count);
5039:
5040: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5041: := 'US WITHHOLDINGS';
5042: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5036:
5037: hr_utility.trace('ln_index in get_withholding_info proc is '
5038: || pay_ac_action_arch.lrr_act_tab.count);
5039:
5040: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5041: := 'US WITHHOLDINGS';
5042: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5043: := '00-000-0000';
5044: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
5038: || pay_ac_action_arch.lrr_act_tab.count);
5039:
5040: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5041: := 'US WITHHOLDINGS';
5042: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5043: := '00-000-0000';
5044: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
5045: := 'Federal';
5046: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
5040: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5041: := 'US WITHHOLDINGS';
5042: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5043: := '00-000-0000';
5044: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
5045: := 'Federal';
5046: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
5047: := lv_fit_filing_status;
5048: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5042: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5043: := '00-000-0000';
5044: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
5045: := 'Federal';
5046: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
5047: := lv_fit_filing_status;
5048: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5049: := ln_fit_withholding_allowances;
5050: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5044: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
5045: := 'Federal';
5046: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
5047: := lv_fit_filing_status;
5048: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5049: := ln_fit_withholding_allowances;
5050: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5051: := fnd_number.number_to_canonical(
5052: ln_fit_additional_wa_amount);
5046: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
5047: := lv_fit_filing_status;
5048: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5049: := ln_fit_withholding_allowances;
5050: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5051: := fnd_number.number_to_canonical(
5052: ln_fit_additional_wa_amount);
5053: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5054: := fnd_number.number_to_canonical(
5049: := ln_fit_withholding_allowances;
5050: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5051: := fnd_number.number_to_canonical(
5052: ln_fit_additional_wa_amount);
5053: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5054: := fnd_number.number_to_canonical(
5055: ln_fit_override_amount);
5056: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5057: := ln_fit_override_rate;
5052: ln_fit_additional_wa_amount);
5053: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5054: := fnd_number.number_to_canonical(
5055: ln_fit_override_amount);
5056: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5057: := ln_fit_override_rate;
5058: end if;
5059: close c_emp_fed_info;
5060: hr_utility.set_location(gv_package || lv_procedure_name, 30);
5107: if ((lv_time_in_state > 0) or
5108: (lv_time_in_state = 0 and
5109: substr(lv_jurisdiction_code, 1,2) = substr(p_resident_jurisdiction,1,2))) then
5110:
5111: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5112: hr_utility.trace('ln_index = ' || ln_index);
5113:
5114: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5115: := 'US WITHHOLDINGS';
5110:
5111: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5112: hr_utility.trace('ln_index = ' || ln_index);
5113:
5114: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5115: := 'US WITHHOLDINGS';
5116: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5117: := lv_jurisdiction_code;
5118: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
5112: hr_utility.trace('ln_index = ' || ln_index);
5113:
5114: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5115: := 'US WITHHOLDINGS';
5116: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5117: := lv_jurisdiction_code;
5118: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
5119: := lv_state_name ;
5120: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
5114: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5115: := 'US WITHHOLDINGS';
5116: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5117: := lv_jurisdiction_code;
5118: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
5119: := lv_state_name ;
5120: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
5121: := lv_sit_filing_status;
5122: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5116: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5117: := lv_jurisdiction_code;
5118: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
5119: := lv_state_name ;
5120: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
5121: := lv_sit_filing_status;
5122: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5123: := ln_sit_withholding_allowances;
5124: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5118: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
5119: := lv_state_name ;
5120: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
5121: := lv_sit_filing_status;
5122: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5123: := ln_sit_withholding_allowances;
5124: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5125: := fnd_number.number_to_canonical(
5126: ln_sit_additional_wa_amount);
5120: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
5121: := lv_sit_filing_status;
5122: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5123: := ln_sit_withholding_allowances;
5124: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5125: := fnd_number.number_to_canonical(
5126: ln_sit_additional_wa_amount);
5127: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5128: := fnd_number.number_to_canonical(ln_sit_override_amount);
5123: := ln_sit_withholding_allowances;
5124: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5125: := fnd_number.number_to_canonical(
5126: ln_sit_additional_wa_amount);
5127: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5128: := fnd_number.number_to_canonical(ln_sit_override_amount);
5129: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5130: := ln_sit_override_rate;
5131: end if;
5125: := fnd_number.number_to_canonical(
5126: ln_sit_additional_wa_amount);
5127: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5128: := fnd_number.number_to_canonical(ln_sit_override_amount);
5129: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5130: := ln_sit_override_rate;
5131: end if;
5132: end loop;
5133: close c_emp_state_info;
5276: ld_run_effective_date;
5277: close c_time_period;
5278:
5279: hr_utility.set_location(gv_package || lv_procedure_name, 70);
5280: pay_ac_action_arch.get_last_xfr_info(
5281: p_assignment_id => p_assignment_id
5282: ,p_curr_effective_date => p_xfr_end_date
5283: ,p_action_info_category => 'EMPLOYEE DETAILS'
5284: ,p_xfr_action_id => p_xfr_action_id
5332: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
5333: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
5334: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
5335:
5336: pay_ac_action_arch.initialization_process;
5337:
5338: /*********************************************************************
5339: ** If p_archive_balance_info is not Y then it mean that the assignment
5340: ** does not have any Gross or Payments in the Run. In this case, we
5370: ** same session the process will always go to the else statement
5371: ******************************************************************/
5372: if ld_last_xfr_eff_date is null then
5373: hr_utility.set_location(gv_package || lv_procedure_name, 100);
5374: pay_ac_action_arch.first_time_process(
5375: p_xfr_action_id => p_xfr_action_id
5376: ,p_assignment_id => p_assignment_id
5377: ,p_curr_pymt_action_id => p_rqp_action_id
5378: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
5386: );
5387:
5388: else
5389: hr_utility.set_location(gv_package || lv_procedure_name, 110);
5390: pay_ac_action_arch.get_current_elements(
5391: p_xfr_action_id => p_xfr_action_id
5392: ,p_curr_pymt_action_id => p_rqp_action_id
5393: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
5394: ,p_assignment_id => p_assignment_id
5425:
5426: end if; /* p_archive_balance_info = 'Y' */
5427:
5428: hr_utility.set_location(gv_package || lv_procedure_name, 135);
5429: pay_ac_action_arch.get_xfr_elements(
5430: p_xfr_action_id => p_xfr_action_id
5431: ,p_last_xfr_action_id => ln_last_xfr_action_id
5432: ,p_ytd_balcall_aaid => ln_ytd_balcall_aaid
5433: ,p_pymt_eff_date => p_curr_pymt_eff_date
5435: ,p_sepchk_flag => p_seperate_check_flag
5436: ,p_assignment_id => p_assignment_id);
5437:
5438: hr_utility.set_location(gv_package || lv_procedure_name, 140);
5439: pay_ac_action_arch.get_last_pymt_info(
5440: p_assignment_id => p_assignment_id
5441: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
5442: ,p_last_pymt_eff_date => ld_last_pymt_eff_date
5443: ,p_last_pymt_action_id => ln_last_pymt_action_id);
5443: ,p_last_pymt_action_id => ln_last_pymt_action_id);
5444:
5445: if ld_last_xfr_eff_date <> ld_last_pymt_eff_date then
5446: hr_utility.set_location(gv_package || lv_procedure_name, 145);
5447: pay_ac_action_arch.get_missing_xfr_info(
5448: p_xfr_action_id => p_xfr_action_id
5449: ,p_tax_unit_id => p_tax_unit_id
5450: ,p_assignment_id => p_assignment_id
5451: ,p_last_pymt_action_id => ln_last_pymt_action_id
5483: hr_utility.set_location(gv_package || lv_procedure_name, 170);
5484: -- Archive element processed in balance adjustment. This only
5485: -- needs to be done for master action as once the element is
5486: -- in archive, it will be carried forward.
5487: pay_ac_action_arch.process_baladj_elements(
5488: p_assignment_id => p_assignment_id
5489: ,p_xfr_action_id => p_xfr_action_id
5490: ,p_last_xfr_action_id => ln_last_xfr_action_id
5491: ,p_curr_pymt_action_id => p_rqp_action_id
5526: ,p_run_action_id => p_payment_action_id);
5527: end if;
5528:
5529: hr_utility.set_location(gv_package || lv_procedure_name, 205);
5530: pay_ac_action_arch.populate_summary(
5531: p_xfr_action_id => p_xfr_action_id);
5532: change_processing_priority;
5533:
5534: hr_utility.set_location(gv_package || lv_procedure_name, 210);
5537: ,p_action_context_type=> 'AAP'
5538: ,p_assignment_id => p_assignment_id
5539: ,p_tax_unit_id => p_tax_unit_id
5540: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
5541: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
5542: );
5543:
5544: hr_utility.set_location(gv_package || lv_procedure_name, 220);
5545: update_employee_information(
6141:
6142: -- An assignment only needs to be processed once as that will
6143: -- move all elements.
6144: if ln_np_asg_id <> ln_np_prev_asg_id then
6145: pay_ac_action_arch.emp_elements_tab.delete;
6146: pay_ac_action_arch.lrr_act_tab.delete;
6147:
6148: -- Check if the date of assignment process is the same as
6149: -- last archive date. If they are the same, the element just
6142: -- An assignment only needs to be processed once as that will
6143: -- move all elements.
6144: if ln_np_asg_id <> ln_np_prev_asg_id then
6145: pay_ac_action_arch.emp_elements_tab.delete;
6146: pay_ac_action_arch.lrr_act_tab.delete;
6147:
6148: -- Check if the date of assignment process is the same as
6149: -- last archive date. If they are the same, the element just
6150: -- needs to be moved forward otherwise we need to get the
6164: hr_utility.trace('ld_last_xfr_eff_date ='||ld_last_xfr_eff_date);
6165:
6166: if ld_np_last_xfr_eff_date >= ld_last_xfr_eff_date then
6167: -- To be Changed
6168: pay_ac_action_arch.get_xfr_elements(
6169: p_xfr_action_id => ln_child_xfr_action_id
6170: ,p_last_xfr_action_id => ln_last_xfr_action_id
6171: ,p_ytd_balcall_aaid => ln_np_asg_action_id
6172: ,p_pymt_eff_date => ld_curr_pymt_eff_date
6173: ,p_legislation_code => lv_legislation_code
6174: ,p_sepchk_flag => lv_master_sepcheck_flag
6175: ,p_assignment_id => ln_np_asg_id);
6176: else
6177: pay_ac_action_arch.process_additional_elements
6178: (p_assignment_id => ln_np_asg_id,
6179: p_assignment_action_id => ln_np_asg_action_id,
6180: p_curr_eff_date => ld_curr_pymt_eff_date,
6181: p_xfr_action_id => ln_child_xfr_action_id,
6184:
6185: change_processing_priority;
6186: end if;
6187:
6188: pay_ac_action_arch.populate_summary(
6189: p_xfr_action_id => p_xfr_action_id);
6190:
6191: pay_emp_action_arch.insert_rows_thro_api_process(
6192: p_action_context_id => ln_child_xfr_action_id
6193: ,p_action_context_type=> 'AAP'
6194: ,p_assignment_id => ln_np_asg_id
6195: ,p_tax_unit_id => ln_tax_unit_id
6196: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
6197: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
6198: );
6199:
6200: end if;
6201: ln_np_prev_asg_id := ln_np_asg_id;
6218: ln_pymt_balcall_aaid := ln_asg_action_id ;
6219: hr_utility.trace('Reversal ln_pymt_balcall_aaid'
6220: ||to_char(ln_pymt_balcall_aaid));
6221: ln_step := 12;
6222: pay_ac_action_arch.initialization_process;
6223: ln_step := 13;
6224: populate_puv_tax_balances(
6225: p_xfr_action_id => p_xfr_action_id
6226: ,p_assignment_id => ln_xfr_assignment_id
6242: ,p_action_context_type=> 'AAP'
6243: ,p_assignment_id => ln_xfr_assignment_id
6244: ,p_tax_unit_id => ln_tax_unit_id
6245: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
6246: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
6247: );
6248:
6249: end if;
6250:
6251: ln_step := 15;
6252: if lv_master_action_type = 'B' then
6253: hr_utility.trace('Reversal ln_pymt_balcall_aaid'
6254: ||to_char(ln_pymt_balcall_aaid));
6255: pay_ac_action_arch.initialization_process;
6256: ln_step := 16;
6257: populate_adj_tax_balances(
6258: p_xfr_action_id => p_xfr_action_id
6259: ,p_assignment_id => ln_xfr_assignment_id
6271: ,p_action_context_type=> 'AAP'
6272: ,p_assignment_id => ln_xfr_assignment_id
6273: ,p_tax_unit_id => ln_tax_unit_id
6274: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
6275: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
6276: );
6277:
6278: end if;
6279: