94: 03-feb-2010 mikarthi 115.124 8688998 Adding two more parameters
95: 1. p_archive_balance_info
96: 2. p_legislation_code
97: while calling the procedure
98: pay_ac_action_arch.get_last_xfr_info
99: 28-Jan-2010 npannamp 115.123 8768738 Removed fix done in 8688998.
100: 28-Dec-2009 npannamp 115.122 8768738 Added code to update payroll_id column
101: in pay_payroll_actions table. Procedure
102: action_archinit modified.
103: 19-Oct-2009 kagangul 115.121 8688998 Adding two more parameters
104: 1. p_archive_balance_info
105: 2. p_legislation_code
106: while calling the procedure
107: pay_ac_action_arch.get_last_xfr_info
108: 24-AUG-2009 rnestor 115.120 8832183 Added Jurst check
109: 18-AUG-2009 rnestor 115.119 8804636 Added date check to c_emp_state_info
110: 04-MAY-2009 skpatil 115.118 8433161 To display FIt Exempt and SIT Exempt
111: status at Check writer XML
317: 2365908 deductions if location has changed.
318: 14-MAY-2002 ahanda 115.51 Moved procedures
319: - get_last_xfr_info
320: - get_last_pymt_info
321: to pay_ac_action_arch
322: 24-APR-2002 ahanda 115.50 Changed c_get_rr_jd for performance.
323: 18-MAR-2002 ahanda 115.49 2204512 Changed the way we populate NR/R.
324: Fixed archiving for Bal Adj for
325: which Pre Pay flag is checked.
357: priority to the archiver processing priority for Tax Deductions
358: **************************************************************************/
359: PROCEDURE change_processing_priority IS
360: BEGIN
361: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
362: for i in pay_ac_action_arch.lrr_act_tab.first ..
363: pay_ac_action_arch.lrr_act_tab.last loop
364: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
365: = 'AC DEDUCTIONS' then
358: **************************************************************************/
359: PROCEDURE change_processing_priority IS
360: BEGIN
361: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
362: for i in pay_ac_action_arch.lrr_act_tab.first ..
363: pay_ac_action_arch.lrr_act_tab.last loop
364: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
365: = 'AC DEDUCTIONS' then
366: if pay_ac_action_arch.lrr_act_tab(i).act_info10
359: PROCEDURE change_processing_priority IS
360: BEGIN
361: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
362: for i in pay_ac_action_arch.lrr_act_tab.first ..
363: pay_ac_action_arch.lrr_act_tab.last loop
364: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
365: = 'AC DEDUCTIONS' then
366: if pay_ac_action_arch.lrr_act_tab(i).act_info10
367: = 'FIT Withheld' then
360: BEGIN
361: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
362: for i in pay_ac_action_arch.lrr_act_tab.first ..
363: pay_ac_action_arch.lrr_act_tab.last loop
364: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
365: = 'AC DEDUCTIONS' then
366: if pay_ac_action_arch.lrr_act_tab(i).act_info10
367: = 'FIT Withheld' then
368: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '1';
362: for i in pay_ac_action_arch.lrr_act_tab.first ..
363: pay_ac_action_arch.lrr_act_tab.last loop
364: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
365: = 'AC DEDUCTIONS' then
366: if pay_ac_action_arch.lrr_act_tab(i).act_info10
367: = 'FIT Withheld' then
368: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '1';
369: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
370: = 'SS EE Withheld' then
364: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
365: = 'AC DEDUCTIONS' then
366: if pay_ac_action_arch.lrr_act_tab(i).act_info10
367: = 'FIT Withheld' then
368: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '1';
369: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
370: = 'SS EE Withheld' then
371: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
372: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
365: = 'AC DEDUCTIONS' then
366: if pay_ac_action_arch.lrr_act_tab(i).act_info10
367: = 'FIT Withheld' then
368: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '1';
369: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
370: = 'SS EE Withheld' then
371: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
372: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
373: = 'SS Withheld' then
367: = 'FIT Withheld' then
368: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '1';
369: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
370: = 'SS EE Withheld' then
371: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
372: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
373: = 'SS Withheld' then
374: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
375: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
368: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '1';
369: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
370: = 'SS EE Withheld' then
371: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
372: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
373: = 'SS Withheld' then
374: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
375: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
376: = 'Medicare EE Withheld' then
370: = 'SS EE Withheld' then
371: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
372: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
373: = 'SS Withheld' then
374: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
375: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
376: = 'Medicare EE Withheld' then
377: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '3';
378: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
371: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
372: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
373: = 'SS Withheld' then
374: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
375: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
376: = 'Medicare EE Withheld' then
377: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '3';
378: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
379: = 'EIC Advance' then
373: = 'SS Withheld' then
374: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
375: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
376: = 'Medicare EE Withheld' then
377: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '3';
378: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
379: = 'EIC Advance' then
380: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '4';
381: if pay_ac_action_arch.lrr_act_tab(i).act_info9 > 0 then
374: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '2';
375: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
376: = 'Medicare EE Withheld' then
377: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '3';
378: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
379: = 'EIC Advance' then
380: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '4';
381: if pay_ac_action_arch.lrr_act_tab(i).act_info9 > 0 then
382: pay_ac_action_arch.lrr_act_tab(i).act_info9 :=
376: = 'Medicare EE Withheld' then
377: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '3';
378: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
379: = 'EIC Advance' then
380: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '4';
381: if pay_ac_action_arch.lrr_act_tab(i).act_info9 > 0 then
382: pay_ac_action_arch.lrr_act_tab(i).act_info9 :=
383: (pay_ac_action_arch.lrr_act_tab(i).act_info9 * -1);
384: end if;
377: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '3';
378: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
379: = 'EIC Advance' then
380: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '4';
381: if pay_ac_action_arch.lrr_act_tab(i).act_info9 > 0 then
382: pay_ac_action_arch.lrr_act_tab(i).act_info9 :=
383: (pay_ac_action_arch.lrr_act_tab(i).act_info9 * -1);
384: end if;
385: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
378: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
379: = 'EIC Advance' then
380: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '4';
381: if pay_ac_action_arch.lrr_act_tab(i).act_info9 > 0 then
382: pay_ac_action_arch.lrr_act_tab(i).act_info9 :=
383: (pay_ac_action_arch.lrr_act_tab(i).act_info9 * -1);
384: end if;
385: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
386: = 'SIT Withheld' then
379: = 'EIC Advance' then
380: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '4';
381: if pay_ac_action_arch.lrr_act_tab(i).act_info9 > 0 then
382: pay_ac_action_arch.lrr_act_tab(i).act_info9 :=
383: (pay_ac_action_arch.lrr_act_tab(i).act_info9 * -1);
384: end if;
385: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
386: = 'SIT Withheld' then
387: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '5';
381: if pay_ac_action_arch.lrr_act_tab(i).act_info9 > 0 then
382: pay_ac_action_arch.lrr_act_tab(i).act_info9 :=
383: (pay_ac_action_arch.lrr_act_tab(i).act_info9 * -1);
384: end if;
385: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
386: = 'SIT Withheld' then
387: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '5';
388: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
389: = 'County Withheld' then
383: (pay_ac_action_arch.lrr_act_tab(i).act_info9 * -1);
384: end if;
385: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
386: = 'SIT Withheld' then
387: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '5';
388: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
389: = 'County Withheld' then
390: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '6';
391: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
384: end if;
385: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
386: = 'SIT Withheld' then
387: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '5';
388: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
389: = 'County Withheld' then
390: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '6';
391: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
392: = 'SDI Withheld' then
386: = 'SIT Withheld' then
387: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '5';
388: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
389: = 'County Withheld' then
390: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '6';
391: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
392: = 'SDI Withheld' then
393: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
394: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
387: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '5';
388: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
389: = 'County Withheld' then
390: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '6';
391: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
392: = 'SDI Withheld' then
393: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
394: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
395: = 'SDI EE Withheld' then
389: = 'County Withheld' then
390: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '6';
391: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
392: = 'SDI Withheld' then
393: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
394: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
395: = 'SDI EE Withheld' then
396: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
397: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI Withheld';
390: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '6';
391: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
392: = 'SDI Withheld' then
393: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
394: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
395: = 'SDI EE Withheld' then
396: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
397: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI Withheld';
398: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
392: = 'SDI Withheld' then
393: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
394: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
395: = 'SDI EE Withheld' then
396: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
397: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI Withheld';
398: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
399: = 'SDI1 Withheld' then
400: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
393: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
394: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
395: = 'SDI EE Withheld' then
396: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
397: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI Withheld';
398: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
399: = 'SDI1 Withheld' then
400: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
401: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
394: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
395: = 'SDI EE Withheld' then
396: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
397: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI Withheld';
398: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
399: = 'SDI1 Withheld' then
400: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
401: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
402: = 'SDI1 EE Withheld' then
396: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
397: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI Withheld';
398: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
399: = 'SDI1 Withheld' then
400: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
401: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
402: = 'SDI1 EE Withheld' then
403: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
404: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI1 Withheld';
397: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI Withheld';
398: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
399: = 'SDI1 Withheld' then
400: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
401: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
402: = 'SDI1 EE Withheld' then
403: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
404: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI1 Withheld';
405: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
399: = 'SDI1 Withheld' then
400: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
401: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
402: = 'SDI1 EE Withheld' then
403: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
404: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI1 Withheld';
405: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
406: = 'Non W2 FIT Withheld' then
407: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
400: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
401: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
402: = 'SDI1 EE Withheld' then
403: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
404: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI1 Withheld';
405: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
406: = 'Non W2 FIT Withheld' then
407: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
408: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
401: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
402: = 'SDI1 EE Withheld' then
403: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
404: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI1 Withheld';
405: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
406: = 'Non W2 FIT Withheld' then
407: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
408: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
409: = 'SUI Withheld' then
403: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
404: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI1 Withheld';
405: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
406: = 'Non W2 FIT Withheld' then
407: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
408: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
409: = 'SUI Withheld' then
410: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
411: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
404: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SDI1 Withheld';
405: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
406: = 'Non W2 FIT Withheld' then
407: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
408: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
409: = 'SUI Withheld' then
410: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
411: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
412: = 'SUI EE Withheld' then
406: = 'Non W2 FIT Withheld' then
407: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
408: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
409: = 'SUI Withheld' then
410: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
411: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
412: = 'SUI EE Withheld' then
413: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
414: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI Withheld';
407: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
408: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
409: = 'SUI Withheld' then
410: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
411: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
412: = 'SUI EE Withheld' then
413: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
414: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI Withheld';
415: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
409: = 'SUI Withheld' then
410: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
411: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
412: = 'SUI EE Withheld' then
413: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
414: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI Withheld';
415: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
416: = 'SUI1 Withheld' then
417: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
410: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
411: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
412: = 'SUI EE Withheld' then
413: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
414: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI Withheld';
415: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
416: = 'SUI1 Withheld' then
417: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
418: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
411: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
412: = 'SUI EE Withheld' then
413: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
414: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI Withheld';
415: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
416: = 'SUI1 Withheld' then
417: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
418: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
419: = 'SUI1 EE Withheld' then
413: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
414: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI Withheld';
415: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
416: = 'SUI1 Withheld' then
417: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
418: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
419: = 'SUI1 EE Withheld' then
420: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
421: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI1 Withheld';
414: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI Withheld';
415: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
416: = 'SUI1 Withheld' then
417: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
418: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
419: = 'SUI1 EE Withheld' then
420: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
421: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI1 Withheld';
422: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
416: = 'SUI1 Withheld' then
417: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
418: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
419: = 'SUI1 EE Withheld' then
420: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
421: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI1 Withheld';
422: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
423: = 'WC Withheld' then
424: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
417: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
418: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
419: = 'SUI1 EE Withheld' then
420: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
421: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI1 Withheld';
422: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
423: = 'WC Withheld' then
424: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
425: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
418: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
419: = 'SUI1 EE Withheld' then
420: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
421: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI1 Withheld';
422: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
423: = 'WC Withheld' then
424: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
425: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
426: = 'Workers Comp Withheld' then
420: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
421: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI1 Withheld';
422: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
423: = 'WC Withheld' then
424: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
425: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
426: = 'Workers Comp Withheld' then
427: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
428: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC Withheld';
421: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'SUI1 Withheld';
422: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
423: = 'WC Withheld' then
424: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
425: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
426: = 'Workers Comp Withheld' then
427: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
428: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC Withheld';
429: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
423: = 'WC Withheld' then
424: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
425: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
426: = 'Workers Comp Withheld' then
427: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
428: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC Withheld';
429: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
430: = 'WC2 Withheld' then
431: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
424: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
425: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
426: = 'Workers Comp Withheld' then
427: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
428: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC Withheld';
429: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
430: = 'WC2 Withheld' then
431: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
432: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
425: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
426: = 'Workers Comp Withheld' then
427: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
428: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC Withheld';
429: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
430: = 'WC2 Withheld' then
431: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
432: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
433: = 'Workers Comp2 Withheld' then
427: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
428: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC Withheld';
429: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
430: = 'WC2 Withheld' then
431: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
432: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
433: = 'Workers Comp2 Withheld' then
434: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
435: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC2 Withheld';
428: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC Withheld';
429: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
430: = 'WC2 Withheld' then
431: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
432: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
433: = 'Workers Comp2 Withheld' then
434: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
435: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC2 Withheld';
436: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
430: = 'WC2 Withheld' then
431: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
432: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
433: = 'Workers Comp2 Withheld' then
434: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
435: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC2 Withheld';
436: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
437: = 'STEIC Advance' then
438: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10'; /*Bug 3231253*/
431: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
432: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
433: = 'Workers Comp2 Withheld' then
434: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
435: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC2 Withheld';
436: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
437: = 'STEIC Advance' then
438: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10'; /*Bug 3231253*/
439: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
432: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
433: = 'Workers Comp2 Withheld' then
434: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
435: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC2 Withheld';
436: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
437: = 'STEIC Advance' then
438: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10'; /*Bug 3231253*/
439: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
440: = 'Head Tax Withheld' then
434: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
435: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC2 Withheld';
436: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
437: = 'STEIC Advance' then
438: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10'; /*Bug 3231253*/
439: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
440: = 'Head Tax Withheld' then
441: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
442: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
435: pay_ac_action_arch.lrr_act_tab(i).act_info10 := 'WC2 Withheld';
436: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
437: = 'STEIC Advance' then
438: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10'; /*Bug 3231253*/
439: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
440: = 'Head Tax Withheld' then
441: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
442: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
443: = 'City Withheld' then
437: = 'STEIC Advance' then
438: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10'; /*Bug 3231253*/
439: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
440: = 'Head Tax Withheld' then
441: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
442: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
443: = 'City Withheld' then
444: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
445: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
438: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10'; /*Bug 3231253*/
439: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
440: = 'Head Tax Withheld' then
441: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
442: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
443: = 'City Withheld' then
444: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
445: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
446: = 'School Withheld' then
440: = 'Head Tax Withheld' then
441: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
442: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
443: = 'City Withheld' then
444: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
445: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
446: = 'School Withheld' then
447: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
448: end if;
441: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
442: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
443: = 'City Withheld' then
444: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
445: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
446: = 'School Withheld' then
447: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
448: end if;
449: end if;
443: = 'City Withheld' then
444: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
445: elsif pay_ac_action_arch.lrr_act_tab(i).act_info10
446: = 'School Withheld' then
447: pay_ac_action_arch.lrr_act_tab(i).act_info7 := '10';
448: end if;
449: end if;
450: end loop;
451: end if;
1925: lv_procedure_name VARCHAR2(100);
1926: lv_error_message VARCHAR2(200);
1927:
1928: ln_hrs_index NUMBER;
1929: ltr_hours_x_rate pay_ac_action_arch.hbr_table;
1930:
1931: ln_retro_rate NUMBER(15,5);
1932: ln_retro_multiple NUMBER(15,5);
1933: ln_retro_hours NUMBER(15,5);
1962: end if;
1963:
1964: if c_hbr%found then
1965: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1966: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1967: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1968: := 'EMPLOYEE HOURS BY RATE';
1969: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1970: := '00-000-0000';
1963:
1964: if c_hbr%found then
1965: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1966: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1967: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1968: := 'EMPLOYEE HOURS BY RATE';
1969: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1970: := '00-000-0000';
1971: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1965: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1966: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1967: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1968: := 'EMPLOYEE HOURS BY RATE';
1969: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1970: := '00-000-0000';
1971: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1972: := p_action_context_id;
1973: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1967: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1968: := 'EMPLOYEE HOURS BY RATE';
1969: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1970: := '00-000-0000';
1971: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1972: := p_action_context_id;
1973: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1974: := p_assignment_id;
1975: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1969: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1970: := '00-000-0000';
1971: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1972: := p_action_context_id;
1973: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1974: := p_assignment_id;
1975: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1976: := ln_element_type_id;
1977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1971: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1972: := p_action_context_id;
1973: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1974: := p_assignment_id;
1975: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1976: := ln_element_type_id;
1977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1978: := lv_element_name;
1979: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1973: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1974: := p_assignment_id;
1975: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1976: := ln_element_type_id;
1977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1978: := lv_element_name;
1979: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1980: := fnd_number.number_to_canonical(ln_rate);
1981: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1975: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1976: := ln_element_type_id;
1977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1978: := lv_element_name;
1979: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1980: := fnd_number.number_to_canonical(ln_rate);
1981: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1982: := fnd_number.number_to_canonical(ln_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1978: := lv_element_name;
1979: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1980: := fnd_number.number_to_canonical(ln_rate);
1981: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1982: := fnd_number.number_to_canonical(ln_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1984: := lv_processing_priority;
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1979: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1980: := fnd_number.number_to_canonical(ln_rate);
1981: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1982: := fnd_number.number_to_canonical(ln_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1984: := lv_processing_priority;
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1986: := fnd_number.number_to_canonical(ln_multiple);
1987: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1981: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1982: := fnd_number.number_to_canonical(ln_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1984: := lv_processing_priority;
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1986: := fnd_number.number_to_canonical(ln_multiple);
1987: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1988: := fnd_number.number_to_canonical(ln_amount);
1989:
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1984: := lv_processing_priority;
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1986: := fnd_number.number_to_canonical(ln_multiple);
1987: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1988: := fnd_number.number_to_canonical(ln_amount);
1989:
1990: /******************************************************
1991: ** Insert into seperate table
2026: end if;
2027:
2028: if ltr_hours_x_rate.count > 0 then
2029: for z in ltr_hours_x_rate.first .. ltr_hours_x_rate.last loop
2030: if pay_ac_action_arch.lrr_act_tab.count > 0 then
2031: for i in pay_ac_action_arch.lrr_act_tab.first..
2032: pay_ac_action_arch.lrr_act_tab.last loop
2033: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
2034: = 'AC EARNINGS' and
2027:
2028: if ltr_hours_x_rate.count > 0 then
2029: for z in ltr_hours_x_rate.first .. ltr_hours_x_rate.last loop
2030: if pay_ac_action_arch.lrr_act_tab.count > 0 then
2031: for i in pay_ac_action_arch.lrr_act_tab.first..
2032: pay_ac_action_arch.lrr_act_tab.last loop
2033: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
2034: = 'AC EARNINGS' and
2035: pay_ac_action_arch.lrr_act_tab(i).action_context_id
2028: if ltr_hours_x_rate.count > 0 then
2029: for z in ltr_hours_x_rate.first .. ltr_hours_x_rate.last loop
2030: if pay_ac_action_arch.lrr_act_tab.count > 0 then
2031: for i in pay_ac_action_arch.lrr_act_tab.first..
2032: pay_ac_action_arch.lrr_act_tab.last loop
2033: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
2034: = 'AC EARNINGS' and
2035: pay_ac_action_arch.lrr_act_tab(i).action_context_id
2036: = p_action_context_id and
2029: for z in ltr_hours_x_rate.first .. ltr_hours_x_rate.last loop
2030: if pay_ac_action_arch.lrr_act_tab.count > 0 then
2031: for i in pay_ac_action_arch.lrr_act_tab.first..
2032: pay_ac_action_arch.lrr_act_tab.last loop
2033: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
2034: = 'AC EARNINGS' and
2035: pay_ac_action_arch.lrr_act_tab(i).action_context_id
2036: = p_action_context_id and
2037: pay_ac_action_arch.lrr_act_tab(i).act_info2
2031: for i in pay_ac_action_arch.lrr_act_tab.first..
2032: pay_ac_action_arch.lrr_act_tab.last loop
2033: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
2034: = 'AC EARNINGS' and
2035: pay_ac_action_arch.lrr_act_tab(i).action_context_id
2036: = p_action_context_id and
2037: pay_ac_action_arch.lrr_act_tab(i).act_info2
2038: = ltr_hours_x_rate(z).element_type_id then
2039: if ((ltr_hours_x_rate(z).hours <>
2033: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
2034: = 'AC EARNINGS' and
2035: pay_ac_action_arch.lrr_act_tab(i).action_context_id
2036: = p_action_context_id and
2037: pay_ac_action_arch.lrr_act_tab(i).act_info2
2038: = ltr_hours_x_rate(z).element_type_id then
2039: if ((ltr_hours_x_rate(z).hours <>
2040: pay_ac_action_arch.lrr_act_tab(i).act_info11) OR
2041: (ltr_hours_x_rate(z).amount <>
2036: = p_action_context_id and
2037: pay_ac_action_arch.lrr_act_tab(i).act_info2
2038: = ltr_hours_x_rate(z).element_type_id then
2039: if ((ltr_hours_x_rate(z).hours <>
2040: pay_ac_action_arch.lrr_act_tab(i).act_info11) OR
2041: (ltr_hours_x_rate(z).amount <>
2042: pay_ac_action_arch.lrr_act_tab(i).act_info8)) then
2043: --call function to get the retro data
2044: hr_utility.trace('HBR diff ' || ltr_hours_x_rate(z).element_name ||
2038: = ltr_hours_x_rate(z).element_type_id then
2039: if ((ltr_hours_x_rate(z).hours <>
2040: pay_ac_action_arch.lrr_act_tab(i).act_info11) OR
2041: (ltr_hours_x_rate(z).amount <>
2042: pay_ac_action_arch.lrr_act_tab(i).act_info8)) then
2043: --call function to get the retro data
2044: hr_utility.trace('HBR diff ' || ltr_hours_x_rate(z).element_name ||
2045: ' Element ID=' || ltr_hours_x_rate(z).element_type_id ||
2046: ' AC HBR=' ||
2043: --call function to get the retro data
2044: hr_utility.trace('HBR diff ' || ltr_hours_x_rate(z).element_name ||
2045: ' Element ID=' || ltr_hours_x_rate(z).element_type_id ||
2046: ' AC HBR=' ||
2047: pay_ac_action_arch.lrr_act_tab(i).act_info11 ||
2048: ' HBR Hours=' || ltr_hours_x_rate(z).hours ||
2049: ' p_run_action_id='||p_run_action_id);
2050:
2051: /*Bug# 16318258 - Start */
2078: if ln_retro_multiple = 0 then
2079: ln_retro_multiple := 1;
2080: end if;
2081:
2082: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2083: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2084: := 'EMPLOYEE HOURS BY RATE';
2085: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2086: := '00-000-0000';
2079: ln_retro_multiple := 1;
2080: end if;
2081:
2082: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2083: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2084: := 'EMPLOYEE HOURS BY RATE';
2085: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2086: := '00-000-0000';
2087: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2081:
2082: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2083: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2084: := 'EMPLOYEE HOURS BY RATE';
2085: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2086: := '00-000-0000';
2087: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2088: := p_action_context_id;
2089: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
2083: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2084: := 'EMPLOYEE HOURS BY RATE';
2085: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2086: := '00-000-0000';
2087: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2088: := p_action_context_id;
2089: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
2090: := p_assignment_id;
2091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2085: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2086: := '00-000-0000';
2087: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2088: := p_action_context_id;
2089: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
2090: := p_assignment_id;
2091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2092: := ltr_hours_x_rate(z).element_type_id;
2093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
2087: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2088: := p_action_context_id;
2089: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
2090: := p_assignment_id;
2091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2092: := ltr_hours_x_rate(z).element_type_id;
2093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
2094: := ltr_hours_x_rate(z).element_name;
2095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
2089: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
2090: := p_assignment_id;
2091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2092: := ltr_hours_x_rate(z).element_type_id;
2093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
2094: := ltr_hours_x_rate(z).element_name;
2095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
2096: := fnd_number.number_to_canonical(ln_retro_rate);
2097: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2092: := ltr_hours_x_rate(z).element_type_id;
2093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
2094: := ltr_hours_x_rate(z).element_name;
2095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
2096: := fnd_number.number_to_canonical(ln_retro_rate);
2097: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2098: := fnd_number.number_to_canonical(ln_retro_hours);
2099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
2094: := ltr_hours_x_rate(z).element_name;
2095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
2096: := fnd_number.number_to_canonical(ln_retro_rate);
2097: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2098: := fnd_number.number_to_canonical(ln_retro_hours);
2099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2100: := ltr_hours_x_rate(z).processing_priority;
2101: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
2096: := fnd_number.number_to_canonical(ln_retro_rate);
2097: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2098: := fnd_number.number_to_canonical(ln_retro_hours);
2099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2100: := ltr_hours_x_rate(z).processing_priority;
2101: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2102: := fnd_number.number_to_canonical(nvl(ln_retro_multiple,1));
2103: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2097: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2098: := fnd_number.number_to_canonical(ln_retro_hours);
2099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2100: := ltr_hours_x_rate(z).processing_priority;
2101: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2102: := fnd_number.number_to_canonical(nvl(ln_retro_multiple,1));
2103: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2104: := fnd_number.number_to_canonical(ln_retro_payvalue);
2105: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2100: := ltr_hours_x_rate(z).processing_priority;
2101: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2102: := fnd_number.number_to_canonical(nvl(ln_retro_multiple,1));
2103: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2104: := fnd_number.number_to_canonical(ln_retro_payvalue);
2105: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2106: end loop;
2107: close c_retro;
2151: lv_error_message VARCHAR2(200);
2152:
2153: BEGIN
2154: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2155: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2156: hr_utility.trace('p_balance = '|| p_balance);
2157: hr_utility.trace('ln_bal_value = ' || p_bal_value);
2158:
2159: pay_ac_action_arch.lrr_act_tab(p_index).action_info_category
2155: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2156: hr_utility.trace('p_balance = '|| p_balance);
2157: hr_utility.trace('ln_bal_value = ' || p_bal_value);
2158:
2159: pay_ac_action_arch.lrr_act_tab(p_index).action_info_category
2160: := p_category;
2161: pay_ac_action_arch.lrr_act_tab(p_index).jurisdiction_code
2162: := '00-000-0000';
2163:
2157: hr_utility.trace('ln_bal_value = ' || p_bal_value);
2158:
2159: pay_ac_action_arch.lrr_act_tab(p_index).action_info_category
2160: := p_category;
2161: pay_ac_action_arch.lrr_act_tab(p_index).jurisdiction_code
2162: := '00-000-0000';
2163:
2164: if p_balance = 'FIT Withheld' then
2165: pay_ac_action_arch.lrr_act_tab(p_index).act_info1 :=
2161: pay_ac_action_arch.lrr_act_tab(p_index).jurisdiction_code
2162: := '00-000-0000';
2163:
2164: if p_balance = 'FIT Withheld' then
2165: pay_ac_action_arch.lrr_act_tab(p_index).act_info1 :=
2166: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0)
2167: + p_bal_value ;
2168: elsif p_balance = 'Regular Earnings' then
2169: pay_ac_action_arch.lrr_act_tab(p_index).act_info2 :=
2162: := '00-000-0000';
2163:
2164: if p_balance = 'FIT Withheld' then
2165: pay_ac_action_arch.lrr_act_tab(p_index).act_info1 :=
2166: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0)
2167: + p_bal_value ;
2168: elsif p_balance = 'Regular Earnings' then
2169: pay_ac_action_arch.lrr_act_tab(p_index).act_info2 :=
2170: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0)
2165: pay_ac_action_arch.lrr_act_tab(p_index).act_info1 :=
2166: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0)
2167: + p_bal_value ;
2168: elsif p_balance = 'Regular Earnings' then
2169: pay_ac_action_arch.lrr_act_tab(p_index).act_info2 :=
2170: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0)
2171: + p_bal_value;
2172: elsif p_balance = 'Supplemental Earnings for FIT' then
2173: pay_ac_action_arch.lrr_act_tab(p_index).act_info3 :=
2166: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0)
2167: + p_bal_value ;
2168: elsif p_balance = 'Regular Earnings' then
2169: pay_ac_action_arch.lrr_act_tab(p_index).act_info2 :=
2170: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0)
2171: + p_bal_value;
2172: elsif p_balance = 'Supplemental Earnings for FIT' then
2173: pay_ac_action_arch.lrr_act_tab(p_index).act_info3 :=
2174: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0)
2169: pay_ac_action_arch.lrr_act_tab(p_index).act_info2 :=
2170: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0)
2171: + p_bal_value;
2172: elsif p_balance = 'Supplemental Earnings for FIT' then
2173: pay_ac_action_arch.lrr_act_tab(p_index).act_info3 :=
2174: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0)
2175: + p_bal_value;
2176: elsif p_balance = 'Supplemental Earnings for NWFIT' then
2177: pay_ac_action_arch.lrr_act_tab(p_index).act_info4 :=
2170: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0)
2171: + p_bal_value;
2172: elsif p_balance = 'Supplemental Earnings for FIT' then
2173: pay_ac_action_arch.lrr_act_tab(p_index).act_info3 :=
2174: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0)
2175: + p_bal_value;
2176: elsif p_balance = 'Supplemental Earnings for NWFIT' then
2177: pay_ac_action_arch.lrr_act_tab(p_index).act_info4 :=
2178: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0)
2173: pay_ac_action_arch.lrr_act_tab(p_index).act_info3 :=
2174: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0)
2175: + p_bal_value;
2176: elsif p_balance = 'Supplemental Earnings for NWFIT' then
2177: pay_ac_action_arch.lrr_act_tab(p_index).act_info4 :=
2178: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0)
2179: + p_bal_value;
2180: elsif p_balance = 'Pre Tax Deductions' then
2181: pay_ac_action_arch.lrr_act_tab(p_index).act_info5 :=
2174: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0)
2175: + p_bal_value;
2176: elsif p_balance = 'Supplemental Earnings for NWFIT' then
2177: pay_ac_action_arch.lrr_act_tab(p_index).act_info4 :=
2178: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0)
2179: + p_bal_value;
2180: elsif p_balance = 'Pre Tax Deductions' then
2181: pay_ac_action_arch.lrr_act_tab(p_index).act_info5 :=
2182: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0)
2177: pay_ac_action_arch.lrr_act_tab(p_index).act_info4 :=
2178: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0)
2179: + p_bal_value;
2180: elsif p_balance = 'Pre Tax Deductions' then
2181: pay_ac_action_arch.lrr_act_tab(p_index).act_info5 :=
2182: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0)
2183: + p_bal_value;
2184: elsif p_balance = 'Pre Tax Deductions for FIT' then
2185: pay_ac_action_arch.lrr_act_tab(p_index).act_info6 :=
2178: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0)
2179: + p_bal_value;
2180: elsif p_balance = 'Pre Tax Deductions' then
2181: pay_ac_action_arch.lrr_act_tab(p_index).act_info5 :=
2182: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0)
2183: + p_bal_value;
2184: elsif p_balance = 'Pre Tax Deductions for FIT' then
2185: pay_ac_action_arch.lrr_act_tab(p_index).act_info6 :=
2186: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0)
2181: pay_ac_action_arch.lrr_act_tab(p_index).act_info5 :=
2182: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0)
2183: + p_bal_value;
2184: elsif p_balance = 'Pre Tax Deductions for FIT' then
2185: pay_ac_action_arch.lrr_act_tab(p_index).act_info6 :=
2186: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0)
2187: + p_bal_value;
2188: elsif p_balance = 'SS EE Taxable' then
2189: pay_ac_action_arch.lrr_act_tab(p_index).act_info7 :=
2182: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0)
2183: + p_bal_value;
2184: elsif p_balance = 'Pre Tax Deductions for FIT' then
2185: pay_ac_action_arch.lrr_act_tab(p_index).act_info6 :=
2186: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0)
2187: + p_bal_value;
2188: elsif p_balance = 'SS EE Taxable' then
2189: pay_ac_action_arch.lrr_act_tab(p_index).act_info7 :=
2190: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0)
2185: pay_ac_action_arch.lrr_act_tab(p_index).act_info6 :=
2186: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0)
2187: + p_bal_value;
2188: elsif p_balance = 'SS EE Taxable' then
2189: pay_ac_action_arch.lrr_act_tab(p_index).act_info7 :=
2190: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0)
2191: + p_bal_value;
2192: elsif p_balance = 'SS EE Withheld' then
2193: pay_ac_action_arch.lrr_act_tab(p_index).act_info8 :=
2186: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0)
2187: + p_bal_value;
2188: elsif p_balance = 'SS EE Taxable' then
2189: pay_ac_action_arch.lrr_act_tab(p_index).act_info7 :=
2190: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0)
2191: + p_bal_value;
2192: elsif p_balance = 'SS EE Withheld' then
2193: pay_ac_action_arch.lrr_act_tab(p_index).act_info8 :=
2194: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0)
2189: pay_ac_action_arch.lrr_act_tab(p_index).act_info7 :=
2190: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0)
2191: + p_bal_value;
2192: elsif p_balance = 'SS EE Withheld' then
2193: pay_ac_action_arch.lrr_act_tab(p_index).act_info8 :=
2194: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0)
2195: + p_bal_value;
2196: elsif p_balance = 'SS ER Liability' then
2197: pay_ac_action_arch.lrr_act_tab(p_index).act_info9 :=
2190: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0)
2191: + p_bal_value;
2192: elsif p_balance = 'SS EE Withheld' then
2193: pay_ac_action_arch.lrr_act_tab(p_index).act_info8 :=
2194: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0)
2195: + p_bal_value;
2196: elsif p_balance = 'SS ER Liability' then
2197: pay_ac_action_arch.lrr_act_tab(p_index).act_info9 :=
2198: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0)
2193: pay_ac_action_arch.lrr_act_tab(p_index).act_info8 :=
2194: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0)
2195: + p_bal_value;
2196: elsif p_balance = 'SS ER Liability' then
2197: pay_ac_action_arch.lrr_act_tab(p_index).act_info9 :=
2198: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0)
2199: + p_bal_value ;
2200: elsif p_balance = 'SS ER Taxable' then
2201: pay_ac_action_arch.lrr_act_tab(p_index).act_info10 :=
2194: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0)
2195: + p_bal_value;
2196: elsif p_balance = 'SS ER Liability' then
2197: pay_ac_action_arch.lrr_act_tab(p_index).act_info9 :=
2198: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0)
2199: + p_bal_value ;
2200: elsif p_balance = 'SS ER Taxable' then
2201: pay_ac_action_arch.lrr_act_tab(p_index).act_info10 :=
2202: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0)
2197: pay_ac_action_arch.lrr_act_tab(p_index).act_info9 :=
2198: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0)
2199: + p_bal_value ;
2200: elsif p_balance = 'SS ER Taxable' then
2201: pay_ac_action_arch.lrr_act_tab(p_index).act_info10 :=
2202: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0)
2203: + p_bal_value ;
2204: elsif p_balance = 'Supplemental Earnings for SS' then
2205: pay_ac_action_arch.lrr_act_tab(p_index).act_info11 :=
2198: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0)
2199: + p_bal_value ;
2200: elsif p_balance = 'SS ER Taxable' then
2201: pay_ac_action_arch.lrr_act_tab(p_index).act_info10 :=
2202: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0)
2203: + p_bal_value ;
2204: elsif p_balance = 'Supplemental Earnings for SS' then
2205: pay_ac_action_arch.lrr_act_tab(p_index).act_info11 :=
2206: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0)
2201: pay_ac_action_arch.lrr_act_tab(p_index).act_info10 :=
2202: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0)
2203: + p_bal_value ;
2204: elsif p_balance = 'Supplemental Earnings for SS' then
2205: pay_ac_action_arch.lrr_act_tab(p_index).act_info11 :=
2206: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0)
2207: + p_bal_value;
2208: elsif p_balance = 'Pre Tax Deductions for SS' then
2209: pay_ac_action_arch.lrr_act_tab(p_index).act_info12 :=
2202: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0)
2203: + p_bal_value ;
2204: elsif p_balance = 'Supplemental Earnings for SS' then
2205: pay_ac_action_arch.lrr_act_tab(p_index).act_info11 :=
2206: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0)
2207: + p_bal_value;
2208: elsif p_balance = 'Pre Tax Deductions for SS' then
2209: pay_ac_action_arch.lrr_act_tab(p_index).act_info12 :=
2210: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0)
2205: pay_ac_action_arch.lrr_act_tab(p_index).act_info11 :=
2206: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0)
2207: + p_bal_value;
2208: elsif p_balance = 'Pre Tax Deductions for SS' then
2209: pay_ac_action_arch.lrr_act_tab(p_index).act_info12 :=
2210: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0)
2211: + p_bal_value;
2212: elsif p_balance = 'Medicare EE Taxable' then
2213: pay_ac_action_arch.lrr_act_tab(p_index).act_info13 :=
2206: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0)
2207: + p_bal_value;
2208: elsif p_balance = 'Pre Tax Deductions for SS' then
2209: pay_ac_action_arch.lrr_act_tab(p_index).act_info12 :=
2210: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0)
2211: + p_bal_value;
2212: elsif p_balance = 'Medicare EE Taxable' then
2213: pay_ac_action_arch.lrr_act_tab(p_index).act_info13 :=
2214: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0)
2209: pay_ac_action_arch.lrr_act_tab(p_index).act_info12 :=
2210: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0)
2211: + p_bal_value;
2212: elsif p_balance = 'Medicare EE Taxable' then
2213: pay_ac_action_arch.lrr_act_tab(p_index).act_info13 :=
2214: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0)
2215: + p_bal_value;
2216: elsif p_balance = 'Medicare EE Withheld' then
2217: pay_ac_action_arch.lrr_act_tab(p_index).act_info14 :=
2210: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0)
2211: + p_bal_value;
2212: elsif p_balance = 'Medicare EE Taxable' then
2213: pay_ac_action_arch.lrr_act_tab(p_index).act_info13 :=
2214: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0)
2215: + p_bal_value;
2216: elsif p_balance = 'Medicare EE Withheld' then
2217: pay_ac_action_arch.lrr_act_tab(p_index).act_info14 :=
2218: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0)
2213: pay_ac_action_arch.lrr_act_tab(p_index).act_info13 :=
2214: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0)
2215: + p_bal_value;
2216: elsif p_balance = 'Medicare EE Withheld' then
2217: pay_ac_action_arch.lrr_act_tab(p_index).act_info14 :=
2218: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0)
2219: + p_bal_value;
2220: elsif p_balance = 'Medicare ER Liability' then
2221: pay_ac_action_arch.lrr_act_tab(p_index).act_info15 :=
2214: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0)
2215: + p_bal_value;
2216: elsif p_balance = 'Medicare EE Withheld' then
2217: pay_ac_action_arch.lrr_act_tab(p_index).act_info14 :=
2218: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0)
2219: + p_bal_value;
2220: elsif p_balance = 'Medicare ER Liability' then
2221: pay_ac_action_arch.lrr_act_tab(p_index).act_info15 :=
2222: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0)
2217: pay_ac_action_arch.lrr_act_tab(p_index).act_info14 :=
2218: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0)
2219: + p_bal_value;
2220: elsif p_balance = 'Medicare ER Liability' then
2221: pay_ac_action_arch.lrr_act_tab(p_index).act_info15 :=
2222: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0)
2223: + p_bal_value ;
2224: elsif p_balance = 'Medicare ER Taxable' then
2225: pay_ac_action_arch.lrr_act_tab(p_index).act_info16 :=
2218: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0)
2219: + p_bal_value;
2220: elsif p_balance = 'Medicare ER Liability' then
2221: pay_ac_action_arch.lrr_act_tab(p_index).act_info15 :=
2222: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0)
2223: + p_bal_value ;
2224: elsif p_balance = 'Medicare ER Taxable' then
2225: pay_ac_action_arch.lrr_act_tab(p_index).act_info16 :=
2226: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0)
2221: pay_ac_action_arch.lrr_act_tab(p_index).act_info15 :=
2222: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0)
2223: + p_bal_value ;
2224: elsif p_balance = 'Medicare ER Taxable' then
2225: pay_ac_action_arch.lrr_act_tab(p_index).act_info16 :=
2226: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0)
2227: + p_bal_value;
2228: elsif p_balance = 'Supplemental Earnings for Medicare' then
2229: pay_ac_action_arch.lrr_act_tab(p_index).act_info17 :=
2222: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0)
2223: + p_bal_value ;
2224: elsif p_balance = 'Medicare ER Taxable' then
2225: pay_ac_action_arch.lrr_act_tab(p_index).act_info16 :=
2226: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0)
2227: + p_bal_value;
2228: elsif p_balance = 'Supplemental Earnings for Medicare' then
2229: pay_ac_action_arch.lrr_act_tab(p_index).act_info17 :=
2230: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0)
2225: pay_ac_action_arch.lrr_act_tab(p_index).act_info16 :=
2226: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0)
2227: + p_bal_value;
2228: elsif p_balance = 'Supplemental Earnings for Medicare' then
2229: pay_ac_action_arch.lrr_act_tab(p_index).act_info17 :=
2230: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0)
2231: + p_bal_value;
2232: elsif p_balance = 'Pre Tax Deductions for Medicare' then
2233: pay_ac_action_arch.lrr_act_tab(p_index).act_info18 :=
2226: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0)
2227: + p_bal_value;
2228: elsif p_balance = 'Supplemental Earnings for Medicare' then
2229: pay_ac_action_arch.lrr_act_tab(p_index).act_info17 :=
2230: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0)
2231: + p_bal_value;
2232: elsif p_balance = 'Pre Tax Deductions for Medicare' then
2233: pay_ac_action_arch.lrr_act_tab(p_index).act_info18 :=
2234: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
2229: pay_ac_action_arch.lrr_act_tab(p_index).act_info17 :=
2230: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0)
2231: + p_bal_value;
2232: elsif p_balance = 'Pre Tax Deductions for Medicare' then
2233: pay_ac_action_arch.lrr_act_tab(p_index).act_info18 :=
2234: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
2235: + p_bal_value;
2236: elsif p_balance = 'Supplemental Earnings for FUTA' then
2237: pay_ac_action_arch.lrr_act_tab(p_index).act_info19 :=
2230: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0)
2231: + p_bal_value;
2232: elsif p_balance = 'Pre Tax Deductions for Medicare' then
2233: pay_ac_action_arch.lrr_act_tab(p_index).act_info18 :=
2234: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
2235: + p_bal_value;
2236: elsif p_balance = 'Supplemental Earnings for FUTA' then
2237: pay_ac_action_arch.lrr_act_tab(p_index).act_info19 :=
2238: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2233: pay_ac_action_arch.lrr_act_tab(p_index).act_info18 :=
2234: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
2235: + p_bal_value;
2236: elsif p_balance = 'Supplemental Earnings for FUTA' then
2237: pay_ac_action_arch.lrr_act_tab(p_index).act_info19 :=
2238: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2239: + p_bal_value;
2240: elsif p_balance = 'Pre Tax Deductions for FUTA' then
2241: pay_ac_action_arch.lrr_act_tab(p_index).act_info20 :=
2234: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
2235: + p_bal_value;
2236: elsif p_balance = 'Supplemental Earnings for FUTA' then
2237: pay_ac_action_arch.lrr_act_tab(p_index).act_info19 :=
2238: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2239: + p_bal_value;
2240: elsif p_balance = 'Pre Tax Deductions for FUTA' then
2241: pay_ac_action_arch.lrr_act_tab(p_index).act_info20 :=
2242: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2237: pay_ac_action_arch.lrr_act_tab(p_index).act_info19 :=
2238: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2239: + p_bal_value;
2240: elsif p_balance = 'Pre Tax Deductions for FUTA' then
2241: pay_ac_action_arch.lrr_act_tab(p_index).act_info20 :=
2242: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2243: + p_bal_value;
2244: elsif p_balance = 'FUTA Taxable' then
2245: pay_ac_action_arch.lrr_act_tab(p_index).act_info21 :=
2238: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2239: + p_bal_value;
2240: elsif p_balance = 'Pre Tax Deductions for FUTA' then
2241: pay_ac_action_arch.lrr_act_tab(p_index).act_info20 :=
2242: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2243: + p_bal_value;
2244: elsif p_balance = 'FUTA Taxable' then
2245: pay_ac_action_arch.lrr_act_tab(p_index).act_info21 :=
2246: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2241: pay_ac_action_arch.lrr_act_tab(p_index).act_info20 :=
2242: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2243: + p_bal_value;
2244: elsif p_balance = 'FUTA Taxable' then
2245: pay_ac_action_arch.lrr_act_tab(p_index).act_info21 :=
2246: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2247: + p_bal_value;
2248: elsif p_balance = 'FUTA Liability' then
2249: pay_ac_action_arch.lrr_act_tab(p_index).act_info22 :=
2242: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2243: + p_bal_value;
2244: elsif p_balance = 'FUTA Taxable' then
2245: pay_ac_action_arch.lrr_act_tab(p_index).act_info21 :=
2246: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2247: + p_bal_value;
2248: elsif p_balance = 'FUTA Liability' then
2249: pay_ac_action_arch.lrr_act_tab(p_index).act_info22 :=
2250: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0)
2245: pay_ac_action_arch.lrr_act_tab(p_index).act_info21 :=
2246: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2247: + p_bal_value;
2248: elsif p_balance = 'FUTA Liability' then
2249: pay_ac_action_arch.lrr_act_tab(p_index).act_info22 :=
2250: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0)
2251: + p_bal_value;
2252: elsif p_balance = 'Gross Earnings' then
2253: pay_ac_action_arch.lrr_act_tab(p_index).act_info23 :=
2246: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2247: + p_bal_value;
2248: elsif p_balance = 'FUTA Liability' then
2249: pay_ac_action_arch.lrr_act_tab(p_index).act_info22 :=
2250: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0)
2251: + p_bal_value;
2252: elsif p_balance = 'Gross Earnings' then
2253: pay_ac_action_arch.lrr_act_tab(p_index).act_info23 :=
2254: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0)
2249: pay_ac_action_arch.lrr_act_tab(p_index).act_info22 :=
2250: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0)
2251: + p_bal_value;
2252: elsif p_balance = 'Gross Earnings' then
2253: pay_ac_action_arch.lrr_act_tab(p_index).act_info23 :=
2254: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0)
2255: + p_bal_value;
2256: elsif p_balance = 'Pre Tax Deductions for EIC' then
2257: pay_ac_action_arch.lrr_act_tab(p_index).act_info24 :=
2250: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0)
2251: + p_bal_value;
2252: elsif p_balance = 'Gross Earnings' then
2253: pay_ac_action_arch.lrr_act_tab(p_index).act_info23 :=
2254: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0)
2255: + p_bal_value;
2256: elsif p_balance = 'Pre Tax Deductions for EIC' then
2257: pay_ac_action_arch.lrr_act_tab(p_index).act_info24 :=
2258: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0)
2253: pay_ac_action_arch.lrr_act_tab(p_index).act_info23 :=
2254: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0)
2255: + p_bal_value;
2256: elsif p_balance = 'Pre Tax Deductions for EIC' then
2257: pay_ac_action_arch.lrr_act_tab(p_index).act_info24 :=
2258: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0)
2259: + p_bal_value;
2260: elsif p_balance = 'Supplemental Earnings for EIC' then
2261: pay_ac_action_arch.lrr_act_tab(p_index).act_info25 :=
2254: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0)
2255: + p_bal_value;
2256: elsif p_balance = 'Pre Tax Deductions for EIC' then
2257: pay_ac_action_arch.lrr_act_tab(p_index).act_info24 :=
2258: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0)
2259: + p_bal_value;
2260: elsif p_balance = 'Supplemental Earnings for EIC' then
2261: pay_ac_action_arch.lrr_act_tab(p_index).act_info25 :=
2262: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0)
2257: pay_ac_action_arch.lrr_act_tab(p_index).act_info24 :=
2258: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0)
2259: + p_bal_value;
2260: elsif p_balance = 'Supplemental Earnings for EIC' then
2261: pay_ac_action_arch.lrr_act_tab(p_index).act_info25 :=
2262: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0)
2263: + p_bal_value;
2264: elsif p_balance = 'EIC Advance' then
2265: pay_ac_action_arch.lrr_act_tab(p_index).act_info26 :=
2258: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0)
2259: + p_bal_value;
2260: elsif p_balance = 'Supplemental Earnings for EIC' then
2261: pay_ac_action_arch.lrr_act_tab(p_index).act_info25 :=
2262: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0)
2263: + p_bal_value;
2264: elsif p_balance = 'EIC Advance' then
2265: pay_ac_action_arch.lrr_act_tab(p_index).act_info26 :=
2266: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0)
2261: pay_ac_action_arch.lrr_act_tab(p_index).act_info25 :=
2262: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0)
2263: + p_bal_value;
2264: elsif p_balance = 'EIC Advance' then
2265: pay_ac_action_arch.lrr_act_tab(p_index).act_info26 :=
2266: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0)
2267: + p_bal_value;
2268: /* Added for Bug#14793173 */
2269: elsif p_balance = 'Medicare EE Taxable Over Limit' then
2262: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0)
2263: + p_bal_value;
2264: elsif p_balance = 'EIC Advance' then
2265: pay_ac_action_arch.lrr_act_tab(p_index).act_info26 :=
2266: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0)
2267: + p_bal_value;
2268: /* Added for Bug#14793173 */
2269: elsif p_balance = 'Medicare EE Taxable Over Limit' then
2270: pay_ac_action_arch.lrr_act_tab(p_index).act_info27 :=
2266: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0)
2267: + p_bal_value;
2268: /* Added for Bug#14793173 */
2269: elsif p_balance = 'Medicare EE Taxable Over Limit' then
2270: pay_ac_action_arch.lrr_act_tab(p_index).act_info27 :=
2271: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info27,0)
2272: + p_bal_value;
2273: end if;
2274:
2267: + p_bal_value;
2268: /* Added for Bug#14793173 */
2269: elsif p_balance = 'Medicare EE Taxable Over Limit' then
2270: pay_ac_action_arch.lrr_act_tab(p_index).act_info27 :=
2271: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info27,0)
2272: + p_bal_value;
2273: end if;
2274:
2275: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2307: lv_error_message VARCHAR2(200);
2308:
2309: BEGIN
2310: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2311: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2312: hr_utility.trace('p_balance = '|| p_balance);
2313: hr_utility.trace('p_bal_value = ' || p_bal_value);
2314:
2315: if p_balance = 'SIT Withheld' then
2312: hr_utility.trace('p_balance = '|| p_balance);
2313: hr_utility.trace('p_bal_value = ' || p_bal_value);
2314:
2315: if p_balance = 'SIT Withheld' then
2316: pay_ac_action_arch.lrr_act_tab(p_index).act_info1
2317: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2318: p_bal_value ;
2319: elsif p_balance = 'SIT Subj Whable' then
2320: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2313: hr_utility.trace('p_bal_value = ' || p_bal_value);
2314:
2315: if p_balance = 'SIT Withheld' then
2316: pay_ac_action_arch.lrr_act_tab(p_index).act_info1
2317: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2318: p_bal_value ;
2319: elsif p_balance = 'SIT Subj Whable' then
2320: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2321: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2316: pay_ac_action_arch.lrr_act_tab(p_index).act_info1
2317: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2318: p_bal_value ;
2319: elsif p_balance = 'SIT Subj Whable' then
2320: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2321: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2322: p_bal_value;
2323: elsif p_balance = 'SIT Subj NWhable' then
2324: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2317: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2318: p_bal_value ;
2319: elsif p_balance = 'SIT Subj Whable' then
2320: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2321: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2322: p_bal_value;
2323: elsif p_balance = 'SIT Subj NWhable' then
2324: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2325: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2320: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2321: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2322: p_bal_value;
2323: elsif p_balance = 'SIT Subj NWhable' then
2324: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2325: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2326: p_bal_value;
2327: elsif p_balance = 'SIT Pre Tax Redns' then
2328: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2321: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2322: p_bal_value;
2323: elsif p_balance = 'SIT Subj NWhable' then
2324: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2325: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2326: p_bal_value;
2327: elsif p_balance = 'SIT Pre Tax Redns' then
2328: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2329: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2324: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2325: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2326: p_bal_value;
2327: elsif p_balance = 'SIT Pre Tax Redns' then
2328: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2329: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2330: p_bal_value;
2331: elsif p_balance = 'SIT Gross' then
2332: pay_ac_action_arch.lrr_act_tab(p_index).act_info17
2325: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2326: p_bal_value;
2327: elsif p_balance = 'SIT Pre Tax Redns' then
2328: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2329: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2330: p_bal_value;
2331: elsif p_balance = 'SIT Gross' then
2332: pay_ac_action_arch.lrr_act_tab(p_index).act_info17
2333: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0) +
2328: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2329: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2330: p_bal_value;
2331: elsif p_balance = 'SIT Gross' then
2332: pay_ac_action_arch.lrr_act_tab(p_index).act_info17
2333: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0) +
2334: p_bal_value ;
2335: end if;
2336:
2329: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2330: p_bal_value;
2331: elsif p_balance = 'SIT Gross' then
2332: pay_ac_action_arch.lrr_act_tab(p_index).act_info17
2333: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0) +
2334: p_bal_value ;
2335: end if;
2336:
2337: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2369: lv_error_message VARCHAR2(200);
2370:
2371: BEGIN
2372: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2373: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2374: hr_utility.trace('p_balance = '|| p_balance);
2375: hr_utility.trace('p_bal_value = ' || p_bal_value);
2376:
2377: if p_balance = 'SDI EE Withheld' then
2374: hr_utility.trace('p_balance = '|| p_balance);
2375: hr_utility.trace('p_bal_value = ' || p_bal_value);
2376:
2377: if p_balance = 'SDI EE Withheld' then
2378: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2379: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2380: p_bal_value ;
2381: elsif p_balance = 'SDI EE Taxable' then
2382: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2375: hr_utility.trace('p_bal_value = ' || p_bal_value);
2376:
2377: if p_balance = 'SDI EE Withheld' then
2378: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2379: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2380: p_bal_value ;
2381: elsif p_balance = 'SDI EE Taxable' then
2382: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2383: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2378: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2379: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2380: p_bal_value ;
2381: elsif p_balance = 'SDI EE Taxable' then
2382: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2383: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2384: p_bal_value;
2385: elsif p_balance = 'SDI EE Subj Whable' then
2386: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2379: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2380: p_bal_value ;
2381: elsif p_balance = 'SDI EE Taxable' then
2382: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2383: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2384: p_bal_value;
2385: elsif p_balance = 'SDI EE Subj Whable' then
2386: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2387: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2382: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2383: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2384: p_bal_value;
2385: elsif p_balance = 'SDI EE Subj Whable' then
2386: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2387: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2388: p_bal_value;
2389: elsif p_balance = 'SDI EE Pre Tax Redns' then
2390: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
2383: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2384: p_bal_value;
2385: elsif p_balance = 'SDI EE Subj Whable' then
2386: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2387: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2388: p_bal_value;
2389: elsif p_balance = 'SDI EE Pre Tax Redns' then
2390: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
2391: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
2386: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2387: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2388: p_bal_value;
2389: elsif p_balance = 'SDI EE Pre Tax Redns' then
2390: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
2391: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
2392: p_bal_value;
2393: elsif p_balance = 'SDI EE Gross' then
2394: pay_ac_action_arch.lrr_act_tab(p_index).act_info26
2387: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2388: p_bal_value;
2389: elsif p_balance = 'SDI EE Pre Tax Redns' then
2390: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
2391: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
2392: p_bal_value;
2393: elsif p_balance = 'SDI EE Gross' then
2394: pay_ac_action_arch.lrr_act_tab(p_index).act_info26
2395: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0) +
2390: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
2391: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
2392: p_bal_value;
2393: elsif p_balance = 'SDI EE Gross' then
2394: pay_ac_action_arch.lrr_act_tab(p_index).act_info26
2395: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0) +
2396: p_bal_value ;
2397: end if;
2398:
2391: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
2392: p_bal_value;
2393: elsif p_balance = 'SDI EE Gross' then
2394: pay_ac_action_arch.lrr_act_tab(p_index).act_info26
2395: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0) +
2396: p_bal_value ;
2397: end if;
2398:
2399: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2433: lv_error_message VARCHAR2(200);
2434:
2435: BEGIN
2436: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2437: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2438: hr_utility.trace('p_balance = '|| p_balance);
2439: hr_utility.trace('p_bal_value = ' || p_bal_value);
2440:
2441: if p_balance = 'SDI ER Liability' then
2438: hr_utility.trace('p_balance = '|| p_balance);
2439: hr_utility.trace('p_bal_value = ' || p_bal_value);
2440:
2441: if p_balance = 'SDI ER Liability' then
2442: pay_ac_action_arch.lrr_act_tab(p_index).act_info9
2443: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0) +
2444: p_bal_value;
2445: elsif p_balance = 'SDI ER Taxable' then
2446: pay_ac_action_arch.lrr_act_tab(p_index).act_info10
2439: hr_utility.trace('p_bal_value = ' || p_bal_value);
2440:
2441: if p_balance = 'SDI ER Liability' then
2442: pay_ac_action_arch.lrr_act_tab(p_index).act_info9
2443: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0) +
2444: p_bal_value;
2445: elsif p_balance = 'SDI ER Taxable' then
2446: pay_ac_action_arch.lrr_act_tab(p_index).act_info10
2447: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0) +
2442: pay_ac_action_arch.lrr_act_tab(p_index).act_info9
2443: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0) +
2444: p_bal_value;
2445: elsif p_balance = 'SDI ER Taxable' then
2446: pay_ac_action_arch.lrr_act_tab(p_index).act_info10
2447: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0) +
2448: p_bal_value;
2449: elsif p_balance = 'SDI ER Subj Whable' then
2450: pay_ac_action_arch.lrr_act_tab(p_index).act_info11
2443: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0) +
2444: p_bal_value;
2445: elsif p_balance = 'SDI ER Taxable' then
2446: pay_ac_action_arch.lrr_act_tab(p_index).act_info10
2447: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0) +
2448: p_bal_value;
2449: elsif p_balance = 'SDI ER Subj Whable' then
2450: pay_ac_action_arch.lrr_act_tab(p_index).act_info11
2451: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0) +
2446: pay_ac_action_arch.lrr_act_tab(p_index).act_info10
2447: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0) +
2448: p_bal_value;
2449: elsif p_balance = 'SDI ER Subj Whable' then
2450: pay_ac_action_arch.lrr_act_tab(p_index).act_info11
2451: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0) +
2452: p_bal_value;
2453: elsif p_balance = 'SDI ER Pre Tax Redns' then
2454: pay_ac_action_arch.lrr_act_tab(p_index).act_info12
2447: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0) +
2448: p_bal_value;
2449: elsif p_balance = 'SDI ER Subj Whable' then
2450: pay_ac_action_arch.lrr_act_tab(p_index).act_info11
2451: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0) +
2452: p_bal_value;
2453: elsif p_balance = 'SDI ER Pre Tax Redns' then
2454: pay_ac_action_arch.lrr_act_tab(p_index).act_info12
2455: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0) +
2450: pay_ac_action_arch.lrr_act_tab(p_index).act_info11
2451: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0) +
2452: p_bal_value;
2453: elsif p_balance = 'SDI ER Pre Tax Redns' then
2454: pay_ac_action_arch.lrr_act_tab(p_index).act_info12
2455: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0) +
2456: p_bal_value ;
2457: elsif p_balance = 'SDI ER Gross' then
2458: pay_ac_action_arch.lrr_act_tab(p_index).act_info27
2451: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info11,0) +
2452: p_bal_value;
2453: elsif p_balance = 'SDI ER Pre Tax Redns' then
2454: pay_ac_action_arch.lrr_act_tab(p_index).act_info12
2455: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0) +
2456: p_bal_value ;
2457: elsif p_balance = 'SDI ER Gross' then
2458: pay_ac_action_arch.lrr_act_tab(p_index).act_info27
2459: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info27,0) +
2454: pay_ac_action_arch.lrr_act_tab(p_index).act_info12
2455: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0) +
2456: p_bal_value ;
2457: elsif p_balance = 'SDI ER Gross' then
2458: pay_ac_action_arch.lrr_act_tab(p_index).act_info27
2459: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info27,0) +
2460: p_bal_value;
2461: end if;
2462:
2455: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info12,0) +
2456: p_bal_value ;
2457: elsif p_balance = 'SDI ER Gross' then
2458: pay_ac_action_arch.lrr_act_tab(p_index).act_info27
2459: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info27,0) +
2460: p_bal_value;
2461: end if;
2462:
2463: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2495: lv_error_message VARCHAR2(200);
2496:
2497: BEGIN
2498: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2499: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2500: hr_utility.trace('p_balance = '|| p_balance);
2501: hr_utility.trace('p_bal_value = ' || p_bal_value);
2502:
2503: if p_balance = 'SUI EE Withheld' then
2500: hr_utility.trace('p_balance = '|| p_balance);
2501: hr_utility.trace('p_bal_value = ' || p_bal_value);
2502:
2503: if p_balance = 'SUI EE Withheld' then
2504: pay_ac_action_arch.lrr_act_tab(p_index).act_info13
2505: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0) +
2506: p_bal_value;
2507: elsif p_balance = 'SUI EE Taxable' then
2508: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2501: hr_utility.trace('p_bal_value = ' || p_bal_value);
2502:
2503: if p_balance = 'SUI EE Withheld' then
2504: pay_ac_action_arch.lrr_act_tab(p_index).act_info13
2505: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0) +
2506: p_bal_value;
2507: elsif p_balance = 'SUI EE Taxable' then
2508: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2509: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2504: pay_ac_action_arch.lrr_act_tab(p_index).act_info13
2505: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0) +
2506: p_bal_value;
2507: elsif p_balance = 'SUI EE Taxable' then
2508: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2509: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2510: p_bal_value;
2511: elsif p_balance = 'SUI EE Subj Whable' then
2512: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2505: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0) +
2506: p_bal_value;
2507: elsif p_balance = 'SUI EE Taxable' then
2508: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2509: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2510: p_bal_value;
2511: elsif p_balance = 'SUI EE Subj Whable' then
2512: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2513: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2508: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2509: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2510: p_bal_value;
2511: elsif p_balance = 'SUI EE Subj Whable' then
2512: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2513: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2514: p_bal_value;
2515: elsif p_balance = 'SUI EE Pre Tax Redns' then
2516: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2509: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2510: p_bal_value;
2511: elsif p_balance = 'SUI EE Subj Whable' then
2512: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2513: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2514: p_bal_value;
2515: elsif p_balance = 'SUI EE Pre Tax Redns' then
2516: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2517: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2512: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2513: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2514: p_bal_value;
2515: elsif p_balance = 'SUI EE Pre Tax Redns' then
2516: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2517: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2518: p_bal_value;
2519: elsif p_balance = 'SUI EE Gross' then
2520: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2513: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2514: p_bal_value;
2515: elsif p_balance = 'SUI EE Pre Tax Redns' then
2516: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2517: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2518: p_bal_value;
2519: elsif p_balance = 'SUI EE Gross' then
2520: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2521: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info28,0) +
2516: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2517: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2518: p_bal_value;
2519: elsif p_balance = 'SUI EE Gross' then
2520: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2521: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info28,0) +
2522: p_bal_value;
2523: end if;
2524: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2517: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2518: p_bal_value;
2519: elsif p_balance = 'SUI EE Gross' then
2520: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2521: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info28,0) +
2522: p_bal_value;
2523: end if;
2524: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2525:
2558: lv_error_message VARCHAR2(200);
2559:
2560: BEGIN
2561: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2562: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2563: hr_utility.trace('p_balance = '|| p_balance);
2564: hr_utility.trace('p_bal_value = ' || p_bal_value);
2565:
2566: if p_balance = 'SUI1 EE Withheld' then
2563: hr_utility.trace('p_balance = '|| p_balance);
2564: hr_utility.trace('p_bal_value = ' || p_bal_value);
2565:
2566: if p_balance = 'SUI1 EE Withheld' then
2567: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2568: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2569: p_bal_value;
2570:
2571: /* Not used as of 08-dec-08
2564: hr_utility.trace('p_bal_value = ' || p_bal_value);
2565:
2566: if p_balance = 'SUI1 EE Withheld' then
2567: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2568: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2569: p_bal_value;
2570:
2571: /* Not used as of 08-dec-08
2572:
2570:
2571: /* Not used as of 08-dec-08
2572:
2573: elsif p_balance = 'SUI1 EE Taxable' then
2574: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2575: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2576: p_bal_value;
2577: elsif p_balance = 'SUI1 EE Subj Whable' then
2578: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2571: /* Not used as of 08-dec-08
2572:
2573: elsif p_balance = 'SUI1 EE Taxable' then
2574: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2575: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2576: p_bal_value;
2577: elsif p_balance = 'SUI1 EE Subj Whable' then
2578: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2579: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2574: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2575: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2576: p_bal_value;
2577: elsif p_balance = 'SUI1 EE Subj Whable' then
2578: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2579: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2580: p_bal_value;
2581: elsif p_balance = 'SUI1 EE Pre Tax Redns' then
2582: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2575: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2576: p_bal_value;
2577: elsif p_balance = 'SUI1 EE Subj Whable' then
2578: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2579: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2580: p_bal_value;
2581: elsif p_balance = 'SUI1 EE Pre Tax Redns' then
2582: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2583: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2578: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2579: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2580: p_bal_value;
2581: elsif p_balance = 'SUI1 EE Pre Tax Redns' then
2582: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2583: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2584: p_bal_value;
2585: elsif p_balance = 'SUI1 EE Gross' then
2586: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2579: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2580: p_bal_value;
2581: elsif p_balance = 'SUI1 EE Pre Tax Redns' then
2582: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2583: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2584: p_bal_value;
2585: elsif p_balance = 'SUI1 EE Gross' then
2586: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2587: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info28,0) +
2582: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2583: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2584: p_bal_value;
2585: elsif p_balance = 'SUI1 EE Gross' then
2586: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2587: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info28,0) +
2588: p_bal_value;
2589: */
2590: end if;
2583: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2584: p_bal_value;
2585: elsif p_balance = 'SUI1 EE Gross' then
2586: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2587: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info28,0) +
2588: p_bal_value;
2589: */
2590: end if;
2591: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2623: lv_error_message VARCHAR2(200);
2624:
2625: BEGIN
2626: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2627: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2628: hr_utility.trace('p_balance = '|| p_balance);
2629: hr_utility.trace('p_bal_value = ' || p_bal_value);
2630:
2631: if p_balance = 'SDI1 EE Withheld' then
2628: hr_utility.trace('p_balance = '|| p_balance);
2629: hr_utility.trace('p_bal_value = ' || p_bal_value);
2630:
2631: if p_balance = 'SDI1 EE Withheld' then
2632: pay_ac_action_arch.lrr_act_tab(p_index).act_info1
2633: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2634: p_bal_value;
2635:
2636: /* Not used as of 08-dec-08
2629: hr_utility.trace('p_bal_value = ' || p_bal_value);
2630:
2631: if p_balance = 'SDI1 EE Withheld' then
2632: pay_ac_action_arch.lrr_act_tab(p_index).act_info1
2633: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2634: p_bal_value;
2635:
2636: /* Not used as of 08-dec-08
2637:
2635:
2636: /* Not used as of 08-dec-08
2637:
2638: elsif p_balance = 'SDI1 EE Taxable' then
2639: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2640: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2641: p_bal_value;
2642: elsif p_balance = 'SDI1 EE Subj Whable' then
2643: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2636: /* Not used as of 08-dec-08
2637:
2638: elsif p_balance = 'SDI1 EE Taxable' then
2639: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2640: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2641: p_bal_value;
2642: elsif p_balance = 'SDI1 EE Subj Whable' then
2643: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2644: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2639: pay_ac_action_arch.lrr_act_tab(p_index).act_info14
2640: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2641: p_bal_value;
2642: elsif p_balance = 'SDI1 EE Subj Whable' then
2643: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2644: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2645: p_bal_value;
2646: elsif p_balance = 'SDI1 EE Pre Tax Redns' then
2647: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2640: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info14,0) +
2641: p_bal_value;
2642: elsif p_balance = 'SDI1 EE Subj Whable' then
2643: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2644: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2645: p_bal_value;
2646: elsif p_balance = 'SDI1 EE Pre Tax Redns' then
2647: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2648: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2643: pay_ac_action_arch.lrr_act_tab(p_index).act_info15
2644: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2645: p_bal_value;
2646: elsif p_balance = 'SDI1 EE Pre Tax Redns' then
2647: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2648: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2649: p_bal_value;
2650: elsif p_balance = 'SDI1 EE Gross' then
2651: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2644: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info15,0) +
2645: p_bal_value;
2646: elsif p_balance = 'SDI1 EE Pre Tax Redns' then
2647: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2648: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2649: p_bal_value;
2650: elsif p_balance = 'SDI1 EE Gross' then
2651: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2652: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info28,0) +
2647: pay_ac_action_arch.lrr_act_tab(p_index).act_info16
2648: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2649: p_bal_value;
2650: elsif p_balance = 'SDI1 EE Gross' then
2651: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2652: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info28,0) +
2653: p_bal_value;
2654: */
2655: end if;
2648: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info16,0) +
2649: p_bal_value;
2650: elsif p_balance = 'SDI1 EE Gross' then
2651: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2652: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info28,0) +
2653: p_bal_value;
2654: */
2655: end if;
2656: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2689: lv_error_message VARCHAR2(200);
2690:
2691: BEGIN
2692: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2693: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2694: hr_utility.trace('p_balance = '|| p_balance);
2695: hr_utility.trace('p_bal_value = ' || p_bal_value);
2696:
2697: if p_balance = 'SUI ER Taxable' then
2694: hr_utility.trace('p_balance = '|| p_balance);
2695: hr_utility.trace('p_bal_value = ' || p_bal_value);
2696:
2697: if p_balance = 'SUI ER Taxable' then
2698: pay_ac_action_arch.lrr_act_tab(p_index).act_info18
2699: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
2700: + p_bal_value;
2701: elsif p_balance = 'SUI ER Subj Whable' then
2702: pay_ac_action_arch.lrr_act_tab(p_index).act_info19
2695: hr_utility.trace('p_bal_value = ' || p_bal_value);
2696:
2697: if p_balance = 'SUI ER Taxable' then
2698: pay_ac_action_arch.lrr_act_tab(p_index).act_info18
2699: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
2700: + p_bal_value;
2701: elsif p_balance = 'SUI ER Subj Whable' then
2702: pay_ac_action_arch.lrr_act_tab(p_index).act_info19
2703: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2698: pay_ac_action_arch.lrr_act_tab(p_index).act_info18
2699: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
2700: + p_bal_value;
2701: elsif p_balance = 'SUI ER Subj Whable' then
2702: pay_ac_action_arch.lrr_act_tab(p_index).act_info19
2703: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2704: + p_bal_value;
2705: elsif p_balance = 'SUI ER Pre Tax Redns' then
2706: pay_ac_action_arch.lrr_act_tab(p_index).act_info20
2699: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)
2700: + p_bal_value;
2701: elsif p_balance = 'SUI ER Subj Whable' then
2702: pay_ac_action_arch.lrr_act_tab(p_index).act_info19
2703: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2704: + p_bal_value;
2705: elsif p_balance = 'SUI ER Pre Tax Redns' then
2706: pay_ac_action_arch.lrr_act_tab(p_index).act_info20
2707: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2702: pay_ac_action_arch.lrr_act_tab(p_index).act_info19
2703: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2704: + p_bal_value;
2705: elsif p_balance = 'SUI ER Pre Tax Redns' then
2706: pay_ac_action_arch.lrr_act_tab(p_index).act_info20
2707: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2708: + p_bal_value;
2709: elsif p_balance = 'SUI ER Liability' then
2710: pay_ac_action_arch.lrr_act_tab(p_index).act_info21
2703: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info19,0)
2704: + p_bal_value;
2705: elsif p_balance = 'SUI ER Pre Tax Redns' then
2706: pay_ac_action_arch.lrr_act_tab(p_index).act_info20
2707: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2708: + p_bal_value;
2709: elsif p_balance = 'SUI ER Liability' then
2710: pay_ac_action_arch.lrr_act_tab(p_index).act_info21
2711: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2706: pay_ac_action_arch.lrr_act_tab(p_index).act_info20
2707: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2708: + p_bal_value;
2709: elsif p_balance = 'SUI ER Liability' then
2710: pay_ac_action_arch.lrr_act_tab(p_index).act_info21
2711: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2712: + p_bal_value;
2713: elsif p_balance = 'SUI ER Gross' then
2714: pay_ac_action_arch.lrr_act_tab(p_index).act_info29
2707: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info20,0)
2708: + p_bal_value;
2709: elsif p_balance = 'SUI ER Liability' then
2710: pay_ac_action_arch.lrr_act_tab(p_index).act_info21
2711: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2712: + p_bal_value;
2713: elsif p_balance = 'SUI ER Gross' then
2714: pay_ac_action_arch.lrr_act_tab(p_index).act_info29
2715: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info29,0)
2710: pay_ac_action_arch.lrr_act_tab(p_index).act_info21
2711: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2712: + p_bal_value;
2713: elsif p_balance = 'SUI ER Gross' then
2714: pay_ac_action_arch.lrr_act_tab(p_index).act_info29
2715: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info29,0)
2716: + p_bal_value;
2717: end if;
2718: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2711: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info21,0)
2712: + p_bal_value;
2713: elsif p_balance = 'SUI ER Gross' then
2714: pay_ac_action_arch.lrr_act_tab(p_index).act_info29
2715: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info29,0)
2716: + p_bal_value;
2717: end if;
2718: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2719:
2750: lv_error_message VARCHAR2(200);
2751:
2752: BEGIN
2753: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2754: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2755: hr_utility.trace('p_balance = '|| p_balance);
2756: hr_utility.trace('p_bal_value = ' || p_bal_value);
2757:
2758: if p_balance = 'Workers Comp Withheld' then
2755: hr_utility.trace('p_balance = '|| p_balance);
2756: hr_utility.trace('p_bal_value = ' || p_bal_value);
2757:
2758: if p_balance = 'Workers Comp Withheld' then
2759: pay_ac_action_arch.lrr_act_tab(p_index).act_info22
2760: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0) +
2761: p_bal_value ;
2762: elsif p_balance = 'Workers Comp2 Withheld' then
2763: pay_ac_action_arch.lrr_act_tab(p_index).act_info23
2756: hr_utility.trace('p_bal_value = ' || p_bal_value);
2757:
2758: if p_balance = 'Workers Comp Withheld' then
2759: pay_ac_action_arch.lrr_act_tab(p_index).act_info22
2760: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0) +
2761: p_bal_value ;
2762: elsif p_balance = 'Workers Comp2 Withheld' then
2763: pay_ac_action_arch.lrr_act_tab(p_index).act_info23
2764: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0) +
2759: pay_ac_action_arch.lrr_act_tab(p_index).act_info22
2760: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0) +
2761: p_bal_value ;
2762: elsif p_balance = 'Workers Comp2 Withheld' then
2763: pay_ac_action_arch.lrr_act_tab(p_index).act_info23
2764: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0) +
2765: p_bal_value;
2766: elsif p_balance = 'Workers Compensation2 ER' then
2767: pay_ac_action_arch.lrr_act_tab(p_index).act_info24
2760: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0) +
2761: p_bal_value ;
2762: elsif p_balance = 'Workers Comp2 Withheld' then
2763: pay_ac_action_arch.lrr_act_tab(p_index).act_info23
2764: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0) +
2765: p_bal_value;
2766: elsif p_balance = 'Workers Compensation2 ER' then
2767: pay_ac_action_arch.lrr_act_tab(p_index).act_info24
2768: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0) +
2763: pay_ac_action_arch.lrr_act_tab(p_index).act_info23
2764: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0) +
2765: p_bal_value;
2766: elsif p_balance = 'Workers Compensation2 ER' then
2767: pay_ac_action_arch.lrr_act_tab(p_index).act_info24
2768: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0) +
2769: p_bal_value;
2770: elsif p_balance = 'Workers Compensation3 ER' then
2771: pay_ac_action_arch.lrr_act_tab(p_index).act_info25
2764: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info23,0) +
2765: p_bal_value;
2766: elsif p_balance = 'Workers Compensation2 ER' then
2767: pay_ac_action_arch.lrr_act_tab(p_index).act_info24
2768: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0) +
2769: p_bal_value;
2770: elsif p_balance = 'Workers Compensation3 ER' then
2771: pay_ac_action_arch.lrr_act_tab(p_index).act_info25
2772: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0) +
2767: pay_ac_action_arch.lrr_act_tab(p_index).act_info24
2768: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0) +
2769: p_bal_value;
2770: elsif p_balance = 'Workers Compensation3 ER' then
2771: pay_ac_action_arch.lrr_act_tab(p_index).act_info25
2772: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0) +
2773: p_bal_value;
2774: end if;
2775: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2768: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info24,0) +
2769: p_bal_value;
2770: elsif p_balance = 'Workers Compensation3 ER' then
2771: pay_ac_action_arch.lrr_act_tab(p_index).act_info25
2772: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0) +
2773: p_bal_value;
2774: end if;
2775: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2776:
2807: lv_error_message VARCHAR2(200);
2808:
2809: BEGIN
2810: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2811: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2812: hr_utility.trace('p_balance = '|| p_balance);
2813: hr_utility.trace('p_bal_value = ' || p_bal_value);
2814:
2815: if p_balance = 'STEIC Advance' then
2812: hr_utility.trace('p_balance = '|| p_balance);
2813: hr_utility.trace('p_bal_value = ' || p_bal_value);
2814:
2815: if p_balance = 'STEIC Advance' then
2816: pay_ac_action_arch.lrr_act_tab(p_index).act_info30
2817: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info30,0) +
2818: p_bal_value ;
2819: end if;
2820:
2813: hr_utility.trace('p_bal_value = ' || p_bal_value);
2814:
2815: if p_balance = 'STEIC Advance' then
2816: pay_ac_action_arch.lrr_act_tab(p_index).act_info30
2817: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info30,0) +
2818: p_bal_value ;
2819: end if;
2820:
2821: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2853: lv_error_message VARCHAR2(200);
2854:
2855: BEGIN
2856: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2857: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2858: hr_utility.trace('p_balance = '|| p_balance);
2859: hr_utility.trace('p_bal_value = ' || p_bal_value);
2860:
2861: if p_balance = 'County Withheld' then
2858: hr_utility.trace('p_balance = '|| p_balance);
2859: hr_utility.trace('p_bal_value = ' || p_bal_value);
2860:
2861: if p_balance = 'County Withheld' then
2862: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2863: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2864: p_bal_value ;
2865: elsif p_balance = 'County Subj Whable' then
2866: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2859: hr_utility.trace('p_bal_value = ' || p_bal_value);
2860:
2861: if p_balance = 'County Withheld' then
2862: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2863: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2864: p_bal_value ;
2865: elsif p_balance = 'County Subj Whable' then
2866: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2867: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2862: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2863: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2864: p_bal_value ;
2865: elsif p_balance = 'County Subj Whable' then
2866: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2867: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2868: p_bal_value;
2869: elsif p_balance = 'County Subj NWhable' then
2870: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2863: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2864: p_bal_value ;
2865: elsif p_balance = 'County Subj Whable' then
2866: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2867: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2868: p_bal_value;
2869: elsif p_balance = 'County Subj NWhable' then
2870: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2871: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2866: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2867: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2868: p_bal_value;
2869: elsif p_balance = 'County Subj NWhable' then
2870: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2871: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2872: p_bal_value;
2873: elsif p_balance = 'County Pre Tax Redns' then
2874: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2867: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2868: p_bal_value;
2869: elsif p_balance = 'County Subj NWhable' then
2870: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2871: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2872: p_bal_value;
2873: elsif p_balance = 'County Pre Tax Redns' then
2874: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2875: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2870: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2871: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2872: p_bal_value;
2873: elsif p_balance = 'County Pre Tax Redns' then
2874: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2875: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2876: p_bal_value;
2877: elsif p_balance = 'County Gross' then
2878: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2871: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2872: p_bal_value;
2873: elsif p_balance = 'County Pre Tax Redns' then
2874: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2875: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2876: p_bal_value;
2877: elsif p_balance = 'County Gross' then
2878: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2879: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2874: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2875: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2876: p_bal_value;
2877: elsif p_balance = 'County Gross' then
2878: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2879: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2880: p_bal_value ;
2881: end if;
2882: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2875: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2876: p_bal_value;
2877: elsif p_balance = 'County Gross' then
2878: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2879: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2880: p_bal_value ;
2881: end if;
2882: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2883:
2914: lv_error_message VARCHAR2(200);
2915:
2916: BEGIN
2917: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2918: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2919: hr_utility.trace('p_balance = '|| p_balance);
2920: hr_utility.trace('p_bal_value = ' || p_bal_value);
2921:
2922: if p_balance = 'Head Tax Liability' then
2919: hr_utility.trace('p_balance = '|| p_balance);
2920: hr_utility.trace('p_bal_value = ' || p_bal_value);
2921:
2922: if p_balance = 'Head Tax Liability' then
2923: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2924: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2925: p_bal_value;
2926: elsif p_balance = 'Head Tax Withheld' then
2927: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2920: hr_utility.trace('p_bal_value = ' || p_bal_value);
2921:
2922: if p_balance = 'Head Tax Liability' then
2923: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2924: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2925: p_bal_value;
2926: elsif p_balance = 'Head Tax Withheld' then
2927: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2928: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2923: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2924: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2925: p_bal_value;
2926: elsif p_balance = 'Head Tax Withheld' then
2927: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2928: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2929: p_bal_value;
2930: end if;
2931: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2924: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2925: p_bal_value;
2926: elsif p_balance = 'Head Tax Withheld' then
2927: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2928: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2929: p_bal_value;
2930: end if;
2931: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2932:
2963: lv_error_message VARCHAR2(200);
2964:
2965: BEGIN
2966: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2967: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2968: hr_utility.trace('p_balance = '|| p_balance);
2969: hr_utility.trace('p_bal_value = ' || p_bal_value);
2970:
2971: if p_balance = 'City Withheld' then
2968: hr_utility.trace('p_balance = '|| p_balance);
2969: hr_utility.trace('p_bal_value = ' || p_bal_value);
2970:
2971: if p_balance = 'City Withheld' then
2972: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2973: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2974: p_bal_value;
2975: elsif p_balance = 'City Subj Whable' then
2976: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2969: hr_utility.trace('p_bal_value = ' || p_bal_value);
2970:
2971: if p_balance = 'City Withheld' then
2972: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2973: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2974: p_bal_value;
2975: elsif p_balance = 'City Subj Whable' then
2976: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2977: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2972: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2973: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2974: p_bal_value;
2975: elsif p_balance = 'City Subj Whable' then
2976: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2977: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2978: p_bal_value;
2979: elsif p_balance = 'City Subj NWhable' then
2980: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2973: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
2974: p_bal_value;
2975: elsif p_balance = 'City Subj Whable' then
2976: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2977: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2978: p_bal_value;
2979: elsif p_balance = 'City Subj NWhable' then
2980: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2981: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2976: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
2977: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2978: p_bal_value;
2979: elsif p_balance = 'City Subj NWhable' then
2980: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2981: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2982: p_bal_value;
2983: elsif p_balance = 'City Pre Tax Redns' then
2984: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2977: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
2978: p_bal_value;
2979: elsif p_balance = 'City Subj NWhable' then
2980: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2981: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2982: p_bal_value;
2983: elsif p_balance = 'City Pre Tax Redns' then
2984: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2985: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2980: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
2981: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2982: p_bal_value;
2983: elsif p_balance = 'City Pre Tax Redns' then
2984: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2985: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2986: p_bal_value;
2987: elsif p_balance = 'City Gross' then
2988: pay_ac_action_arch.lrr_act_tab(p_index ).act_info7
2981: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
2982: p_bal_value;
2983: elsif p_balance = 'City Pre Tax Redns' then
2984: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2985: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2986: p_bal_value;
2987: elsif p_balance = 'City Gross' then
2988: pay_ac_action_arch.lrr_act_tab(p_index ).act_info7
2989: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2984: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
2985: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2986: p_bal_value;
2987: elsif p_balance = 'City Gross' then
2988: pay_ac_action_arch.lrr_act_tab(p_index ).act_info7
2989: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2990: p_bal_value;
2991: end if;
2992: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2985: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
2986: p_bal_value;
2987: elsif p_balance = 'City Gross' then
2988: pay_ac_action_arch.lrr_act_tab(p_index ).act_info7
2989: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2990: p_bal_value;
2991: end if;
2992: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2993:
3024: lv_error_message VARCHAR2(200);
3025:
3026: BEGIN
3027: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3028: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
3029: hr_utility.trace('p_balance = '|| p_balance);
3030: hr_utility.trace('p_bal_value = ' || p_bal_value);
3031:
3032: if p_balance = 'Head Tax Liability' then
3029: hr_utility.trace('p_balance = '|| p_balance);
3030: hr_utility.trace('p_bal_value = ' || p_bal_value);
3031:
3032: if p_balance = 'Head Tax Liability' then
3033: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
3034: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
3035: p_bal_value;
3036: elsif p_balance = 'Head Tax Withheld' then
3037: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
3030: hr_utility.trace('p_bal_value = ' || p_bal_value);
3031:
3032: if p_balance = 'Head Tax Liability' then
3033: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
3034: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
3035: p_bal_value;
3036: elsif p_balance = 'Head Tax Withheld' then
3037: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
3038: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
3033: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
3034: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
3035: p_bal_value;
3036: elsif p_balance = 'Head Tax Withheld' then
3037: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
3038: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
3039: p_bal_value;
3040: end if;
3041: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3034: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
3035: p_bal_value;
3036: elsif p_balance = 'Head Tax Withheld' then
3037: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
3038: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
3039: p_bal_value;
3040: end if;
3041: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3042:
3074: lv_error_message VARCHAR2(200);
3075:
3076: BEGIN
3077: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3078: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
3079: hr_utility.trace('p_balance = '|| p_balance);
3080: hr_utility.trace('p_bal_value = ' || p_bal_value);
3081:
3082: if p_balance = 'PSD Withheld' then
3079: hr_utility.trace('p_balance = '|| p_balance);
3080: hr_utility.trace('p_bal_value = ' || p_bal_value);
3081:
3082: if p_balance = 'PSD Withheld' then
3083: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
3084: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
3085: p_bal_value;
3086: elsif p_balance = 'PSD Subj Whable' then
3087: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
3080: hr_utility.trace('p_bal_value = ' || p_bal_value);
3081:
3082: if p_balance = 'PSD Withheld' then
3083: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
3084: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
3085: p_bal_value;
3086: elsif p_balance = 'PSD Subj Whable' then
3087: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
3088: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
3083: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
3084: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
3085: p_bal_value;
3086: elsif p_balance = 'PSD Subj Whable' then
3087: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
3088: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
3089: p_bal_value;
3090: elsif p_balance = 'City PSD Withheld' then
3091: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
3084: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
3085: p_bal_value;
3086: elsif p_balance = 'PSD Subj Whable' then
3087: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
3088: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
3089: p_bal_value;
3090: elsif p_balance = 'City PSD Withheld' then
3091: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
3092: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
3087: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
3088: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
3089: p_bal_value;
3090: elsif p_balance = 'City PSD Withheld' then
3091: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
3092: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
3093: p_bal_value;
3094: elsif p_balance = 'City PSD Subj Whable' then
3095: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
3088: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
3089: p_bal_value;
3090: elsif p_balance = 'City PSD Withheld' then
3091: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
3092: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
3093: p_bal_value;
3094: elsif p_balance = 'City PSD Subj Whable' then
3095: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
3096: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
3091: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
3092: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
3093: p_bal_value;
3094: elsif p_balance = 'City PSD Subj Whable' then
3095: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
3096: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
3097: p_bal_value;
3098: elsif p_balance = 'School PSD Withheld' then
3099: pay_ac_action_arch.lrr_act_tab(p_index ).act_info5
3092: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
3093: p_bal_value;
3094: elsif p_balance = 'City PSD Subj Whable' then
3095: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
3096: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
3097: p_bal_value;
3098: elsif p_balance = 'School PSD Withheld' then
3099: pay_ac_action_arch.lrr_act_tab(p_index ).act_info5
3100: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
3095: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
3096: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
3097: p_bal_value;
3098: elsif p_balance = 'School PSD Withheld' then
3099: pay_ac_action_arch.lrr_act_tab(p_index ).act_info5
3100: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
3101: p_bal_value;
3102: elsif p_balance = 'PSD Withheld YTD' then
3103: pay_ac_action_arch.lrr_act_tab(p_index ).act_info6
3096: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
3097: p_bal_value;
3098: elsif p_balance = 'School PSD Withheld' then
3099: pay_ac_action_arch.lrr_act_tab(p_index ).act_info5
3100: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
3101: p_bal_value;
3102: elsif p_balance = 'PSD Withheld YTD' then
3103: pay_ac_action_arch.lrr_act_tab(p_index ).act_info6
3104: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
3099: pay_ac_action_arch.lrr_act_tab(p_index ).act_info5
3100: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
3101: p_bal_value;
3102: elsif p_balance = 'PSD Withheld YTD' then
3103: pay_ac_action_arch.lrr_act_tab(p_index ).act_info6
3104: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
3105: p_bal_value;
3106: elsif p_balance = 'PSD Subj Whable YTD' then
3107: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
3100: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
3101: p_bal_value;
3102: elsif p_balance = 'PSD Withheld YTD' then
3103: pay_ac_action_arch.lrr_act_tab(p_index ).act_info6
3104: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
3105: p_bal_value;
3106: elsif p_balance = 'PSD Subj Whable YTD' then
3107: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
3108: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
3103: pay_ac_action_arch.lrr_act_tab(p_index ).act_info6
3104: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
3105: p_bal_value;
3106: elsif p_balance = 'PSD Subj Whable YTD' then
3107: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
3108: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
3109: p_bal_value;
3110: elsif p_balance = 'City PSD Withheld YTD' then
3111: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
3104: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
3105: p_bal_value;
3106: elsif p_balance = 'PSD Subj Whable YTD' then
3107: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
3108: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
3109: p_bal_value;
3110: elsif p_balance = 'City PSD Withheld YTD' then
3111: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
3112: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
3107: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
3108: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
3109: p_bal_value;
3110: elsif p_balance = 'City PSD Withheld YTD' then
3111: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
3112: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
3113: p_bal_value;
3114: elsif p_balance = 'City PSD Subj Whable YTD' then
3115: pay_ac_action_arch.lrr_act_tab(p_index).act_info9
3108: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
3109: p_bal_value;
3110: elsif p_balance = 'City PSD Withheld YTD' then
3111: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
3112: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
3113: p_bal_value;
3114: elsif p_balance = 'City PSD Subj Whable YTD' then
3115: pay_ac_action_arch.lrr_act_tab(p_index).act_info9
3116: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0) +
3111: pay_ac_action_arch.lrr_act_tab(p_index).act_info8
3112: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
3113: p_bal_value;
3114: elsif p_balance = 'City PSD Subj Whable YTD' then
3115: pay_ac_action_arch.lrr_act_tab(p_index).act_info9
3116: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0) +
3117: p_bal_value;
3118: elsif p_balance = 'School PSD Withheld YTD' then
3119: pay_ac_action_arch.lrr_act_tab(p_index ).act_info10
3112: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info8,0) +
3113: p_bal_value;
3114: elsif p_balance = 'City PSD Subj Whable YTD' then
3115: pay_ac_action_arch.lrr_act_tab(p_index).act_info9
3116: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0) +
3117: p_bal_value;
3118: elsif p_balance = 'School PSD Withheld YTD' then
3119: pay_ac_action_arch.lrr_act_tab(p_index ).act_info10
3120: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0) +
3115: pay_ac_action_arch.lrr_act_tab(p_index).act_info9
3116: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0) +
3117: p_bal_value;
3118: elsif p_balance = 'School PSD Withheld YTD' then
3119: pay_ac_action_arch.lrr_act_tab(p_index ).act_info10
3120: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0) +
3121: p_bal_value;
3122: end if;
3123: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3116: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0) +
3117: p_bal_value;
3118: elsif p_balance = 'School PSD Withheld YTD' then
3119: pay_ac_action_arch.lrr_act_tab(p_index ).act_info10
3120: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info10,0) +
3121: p_bal_value;
3122: end if;
3123: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3124:
3156: lv_error_message VARCHAR2(200);
3157:
3158: BEGIN
3159: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3160: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
3161: hr_utility.trace('p_balance = '|| p_balance);
3162: hr_utility.trace('p_bal_value = ' || p_bal_value);
3163:
3164: if p_balance = 'School Withheld' then
3161: hr_utility.trace('p_balance = '|| p_balance);
3162: hr_utility.trace('p_bal_value = ' || p_bal_value);
3163:
3164: if p_balance = 'School Withheld' then
3165: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
3166: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
3167: p_bal_value ;
3168: elsif p_balance = 'School Subj Whable' then
3169: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
3162: hr_utility.trace('p_bal_value = ' || p_bal_value);
3163:
3164: if p_balance = 'School Withheld' then
3165: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
3166: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
3167: p_bal_value ;
3168: elsif p_balance = 'School Subj Whable' then
3169: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
3170: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
3165: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
3166: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
3167: p_bal_value ;
3168: elsif p_balance = 'School Subj Whable' then
3169: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
3170: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
3171: p_bal_value;
3172: elsif p_balance = 'School Subj NWhable' then
3173: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
3166: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +
3167: p_bal_value ;
3168: elsif p_balance = 'School Subj Whable' then
3169: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
3170: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
3171: p_bal_value;
3172: elsif p_balance = 'School Subj NWhable' then
3173: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
3174: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
3169: pay_ac_action_arch.lrr_act_tab(p_index).act_info2
3170: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
3171: p_bal_value;
3172: elsif p_balance = 'School Subj NWhable' then
3173: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
3174: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
3175: + p_bal_value;
3176: elsif p_balance = 'School Pre Tax Redns' then
3177: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
3170: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info2,0) +
3171: p_bal_value;
3172: elsif p_balance = 'School Subj NWhable' then
3173: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
3174: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
3175: + p_bal_value;
3176: elsif p_balance = 'School Pre Tax Redns' then
3177: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
3178: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
3173: pay_ac_action_arch.lrr_act_tab(p_index).act_info3
3174: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
3175: + p_bal_value;
3176: elsif p_balance = 'School Pre Tax Redns' then
3177: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
3178: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
3179: p_bal_value;
3180: elsif p_balance = 'School Gross' then
3181: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
3174: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info3,0) +
3175: + p_bal_value;
3176: elsif p_balance = 'School Pre Tax Redns' then
3177: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
3178: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
3179: p_bal_value;
3180: elsif p_balance = 'School Gross' then
3181: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
3182: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
3177: pay_ac_action_arch.lrr_act_tab(p_index).act_info4
3178: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
3179: p_bal_value;
3180: elsif p_balance = 'School Gross' then
3181: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
3182: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
3183: p_bal_value;
3184: end if;
3185: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3178: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info4,0) +
3179: p_bal_value;
3180: elsif p_balance = 'School Gross' then
3181: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
3182: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
3183: p_bal_value;
3184: end if;
3185: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3186:
3470: BEGIN
3471: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3472: if p_curr_withheld <> 0 or p_ytd_withheld <> 0 then -- Bug 3561821
3473:
3474: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3475: hr_utility.trace('ln_index = ' || ln_index);
3476:
3477: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3478: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3473:
3474: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3475: hr_utility.trace('ln_index = ' || ln_index);
3476:
3477: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3478: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3479: := 'Tax Deductions';
3480: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3481: := p_jurisdiction;
3474: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3475: hr_utility.trace('ln_index = ' || ln_index);
3476:
3477: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3478: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3479: := 'Tax Deductions';
3480: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3481: := p_jurisdiction;
3482: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3476:
3477: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3478: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3479: := 'Tax Deductions';
3480: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3481: := p_jurisdiction;
3482: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3483: := p_balance_name;
3484: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3478: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3479: := 'Tax Deductions';
3480: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3481: := p_jurisdiction;
3482: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3483: := p_balance_name;
3484: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3485: := p_balance_type_id;
3486: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
3480: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3481: := p_jurisdiction;
3482: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3483: := p_balance_name;
3484: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3485: := p_balance_type_id;
3486: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
3487: := p_processing_priority;
3488:
3482: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3483: := p_balance_name;
3484: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3485: := p_balance_type_id;
3486: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
3487: := p_processing_priority;
3488:
3489: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3490: := 'AC DEDUCTIONS';
3485: := p_balance_type_id;
3486: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
3487: := p_processing_priority;
3488:
3489: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3490: := 'AC DEDUCTIONS';
3491: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3492: := p_jurisdiction;
3493: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3487: := p_processing_priority;
3488:
3489: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3490: := 'AC DEDUCTIONS';
3491: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3492: := p_jurisdiction;
3493: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3494: := p_xfr_action_id;
3495: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3489: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3490: := 'AC DEDUCTIONS';
3491: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3492: := p_jurisdiction;
3493: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3494: := p_xfr_action_id;
3495: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3496: := 'Tax Deductions';
3497: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3491: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3492: := p_jurisdiction;
3493: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3494: := p_xfr_action_id;
3495: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3496: := 'Tax Deductions';
3497: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3498: := p_balance_type_id ;
3499: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3493: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3494: := p_xfr_action_id;
3495: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3496: := 'Tax Deductions';
3497: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3498: := p_balance_type_id ;
3499: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3500: := p_processing_priority;
3501: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3495: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3496: := 'Tax Deductions';
3497: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3498: := p_balance_type_id ;
3499: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3500: := p_processing_priority;
3501: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3502: := fnd_number.number_to_canonical(nvl(p_curr_withheld,0));
3503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3497: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3498: := p_balance_type_id ;
3499: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3500: := p_processing_priority;
3501: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3502: := fnd_number.number_to_canonical(nvl(p_curr_withheld,0));
3503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3504: := fnd_number.number_to_canonical(nvl(p_ytd_withheld,0));
3505: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3499: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3500: := p_processing_priority;
3501: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3502: := fnd_number.number_to_canonical(nvl(p_curr_withheld,0));
3503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3504: := fnd_number.number_to_canonical(nvl(p_ytd_withheld,0));
3505: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3506: := p_balance_name ;
3507: OPEN get_display_name( p_balance_name ,p_jurisdiction ) ;
3501: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3502: := fnd_number.number_to_canonical(nvl(p_curr_withheld,0));
3503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3504: := fnd_number.number_to_canonical(nvl(p_ytd_withheld,0));
3505: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3506: := p_balance_name ;
3507: OPEN get_display_name( p_balance_name ,p_jurisdiction ) ;
3508: FETCH get_display_name INTO lv_display_name ;
3509: IF get_display_name%FOUND THEN
3516: END IF;
3517: IF get_display_name%ISOPEN THEN
3518: close get_display_name;
3519: END IF;
3520: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
3521: := lv_display_name ;
3522: end if;
3523: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3524:
3556: ln_table_index NUMBER;
3557: lv_index_flag VARCHAR2(1) := 'N';
3558:
3559: BEGIN
3560: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3561: for j in pay_ac_action_arch.lrr_act_tab.first ..
3562: pay_ac_action_arch.lrr_act_tab.last loop
3563:
3564: if pay_ac_action_arch.lrr_act_tab(j).jurisdiction_code
3557: lv_index_flag VARCHAR2(1) := 'N';
3558:
3559: BEGIN
3560: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3561: for j in pay_ac_action_arch.lrr_act_tab.first ..
3562: pay_ac_action_arch.lrr_act_tab.last loop
3563:
3564: if pay_ac_action_arch.lrr_act_tab(j).jurisdiction_code
3565: = p_jurisdiction_code THEN
3558:
3559: BEGIN
3560: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3561: for j in pay_ac_action_arch.lrr_act_tab.first ..
3562: pay_ac_action_arch.lrr_act_tab.last loop
3563:
3564: if pay_ac_action_arch.lrr_act_tab(j).jurisdiction_code
3565: = p_jurisdiction_code THEN
3566:
3560: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3561: for j in pay_ac_action_arch.lrr_act_tab.first ..
3562: pay_ac_action_arch.lrr_act_tab.last loop
3563:
3564: if pay_ac_action_arch.lrr_act_tab(j).jurisdiction_code
3565: = p_jurisdiction_code THEN
3566:
3567: if p_action_info_category is null
3568: and pay_ac_action_arch.lrr_act_tab(j).action_info_category
3564: if pay_ac_action_arch.lrr_act_tab(j).jurisdiction_code
3565: = p_jurisdiction_code THEN
3566:
3567: if p_action_info_category is null
3568: and pay_ac_action_arch.lrr_act_tab(j).action_info_category
3569: in ('US FEDERAL',
3570: 'US COUNTY', 'US CITY',
3571: 'US SCHOOL DISTRICT') then
3572: ln_table_index := j;
3571: 'US SCHOOL DISTRICT') then
3572: ln_table_index := j;
3573: lv_index_flag := 'Y';
3574: exit;
3575: ELSE IF pay_ac_action_arch.lrr_act_tab(j).action_info_category
3576: in ('US STATE', 'US STATE2')
3577: AND pay_ac_action_arch.lrr_act_tab(j).action_info_category
3578: = p_action_info_category
3579: THEN
3573: lv_index_flag := 'Y';
3574: exit;
3575: ELSE IF pay_ac_action_arch.lrr_act_tab(j).action_info_category
3576: in ('US STATE', 'US STATE2')
3577: AND pay_ac_action_arch.lrr_act_tab(j).action_info_category
3578: = p_action_info_category
3579: THEN
3580: ln_table_index := j;
3581: lv_index_flag := 'Y';
3587: end loop;
3588: end if;
3589:
3590: if lv_index_flag <> 'Y' then
3591: ln_table_index := pay_ac_action_arch.lrr_act_tab.count;
3592: end if;
3593: hr_utility.trace('ln_table_index = '|| ln_table_index);
3594:
3595: return(ln_table_index);
3706: end if;
3707:
3708: -- elsif lv_balance_name = 'SS ER Taxable' then
3709: -- ln_bal_value
3710: -- := pay_ac_action_arch.lrr_act_tab(ln_index).act_info7;
3711: -- elsif lv_balance_name = 'SS ER Liability' then
3712: -- ln_bal_value
3713: -- := pay_ac_action_arch.lrr_act_tab(ln_index).act_info8;
3714: elsif lv_balance_name = 'Medicare ER Taxable' then
3709: -- ln_bal_value
3710: -- := pay_ac_action_arch.lrr_act_tab(ln_index).act_info7;
3711: -- elsif lv_balance_name = 'SS ER Liability' then
3712: -- ln_bal_value
3713: -- := pay_ac_action_arch.lrr_act_tab(ln_index).act_info8;
3714: elsif lv_balance_name = 'Medicare ER Taxable' then
3715: ln_bal_value
3716: := pay_ac_action_arch.lrr_act_tab(ln_index).act_info13;
3717: -- elsif lv_balance_name = 'Medicare ER Liability' then
3712: -- ln_bal_value
3713: -- := pay_ac_action_arch.lrr_act_tab(ln_index).act_info8;
3714: elsif lv_balance_name = 'Medicare ER Taxable' then
3715: ln_bal_value
3716: := pay_ac_action_arch.lrr_act_tab(ln_index).act_info13;
3717: -- elsif lv_balance_name = 'Medicare ER Liability' then
3718: -- ln_bal_value
3719: -- := pay_ac_action_arch.lrr_act_tab(ln_index).act_info14;
3720: end if;
3715: ln_bal_value
3716: := pay_ac_action_arch.lrr_act_tab(ln_index).act_info13;
3717: -- elsif lv_balance_name = 'Medicare ER Liability' then
3718: -- ln_bal_value
3719: -- := pay_ac_action_arch.lrr_act_tab(ln_index).act_info14;
3720: end if;
3721:
3722: else
3723: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3866: ,p_pymt_balcall_aaid in number default null
3867: ,p_ytd_balcall_aaid in number default null
3868: ,p_rqp_action_id in number
3869: ,p_action_type in varchar2
3870: ,p_jurisdiction_tab in pay_ac_action_arch.emp_jd_rec_table)
3871: IS
3872: ln_index NUMBER ;
3873: lv_balance_name VARCHAR2(80);
3874: ln_balance_type_id NUMBER;
3943: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd,
3944: 'US STATE');
3945: hr_utility.trace('ln_index for state is '||to_char(ln_index));
3946:
3947: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3948: := 'US STATE';
3949: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3950: := p_jurisdiction_tab(i).emp_jd;
3951:
3945: hr_utility.trace('ln_index for state is '||to_char(ln_index));
3946:
3947: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3948: := 'US STATE';
3949: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3950: := p_jurisdiction_tab(i).emp_jd;
3951:
3952: if pay_us_action_arch.ltr_state_tax_bal.count > 0 then
3953: --(
4257: 'US STATE2');
4258:
4259: hr_utility.trace('US STATE2 ln_index = '|| to_char(ln_index));
4260:
4261: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4262: := 'US STATE2';
4263: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4264: := p_jurisdiction_tab(i).emp_jd;
4265:
4259: hr_utility.trace('US STATE2 ln_index = '|| to_char(ln_index));
4260:
4261: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4262: := 'US STATE2';
4263: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4264: := p_jurisdiction_tab(i).emp_jd;
4265:
4266: if pay_us_action_arch.ltr_state2_tax_bal.count > 0 then
4267: --(
4452: ,p_action_type in varchar2
4453: ,p_resident_state in varchar2
4454: ,p_resident_county in varchar2
4455: ,p_resident_city in varchar2
4456: ,p_jurisdiction_tab in pay_ac_action_arch.emp_jd_rec_table)
4457: IS
4458: ln_index NUMBER ;
4459: lv_balance_name VARCHAR2(80);
4460: ln_balance_type_id NUMBER;
4515:
4516: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd,
4517: NULL);
4518:
4519: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4520: := p_jurisdiction_tab(i).emp_jd;
4521: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4522: := 'US COUNTY';
4523:
4517: NULL);
4518:
4519: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4520: := p_jurisdiction_tab(i).emp_jd;
4521: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4522: := 'US COUNTY';
4523:
4524: if p_jurisdiction_tab(i).emp_jd
4525: = p_resident_state||'-'||p_resident_county|| '-0000' then
4522: := 'US COUNTY';
4523:
4524: if p_jurisdiction_tab(i).emp_jd
4525: = p_resident_state||'-'||p_resident_county|| '-0000' then
4526: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'R';
4527: else
4528: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
4529: end if;
4530:
4524: if p_jurisdiction_tab(i).emp_jd
4525: = p_resident_state||'-'||p_resident_county|| '-0000' then
4526: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'R';
4527: else
4528: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
4529: end if;
4530:
4531: if pay_us_action_arch.ltr_county_tax_bal.count > 0 then
4532: for k in pay_us_action_arch.ltr_county_tax_bal.first..
4654: ,p_resident_state in varchar2
4655: ,p_resident_county in varchar2
4656: ,p_resident_city in varchar2
4657: ,p_effective_date in date
4658: ,p_jurisdiction_tab in pay_ac_action_arch.emp_jd_rec_table)
4659: IS
4660: ln_index NUMBER ;
4661: lv_balance_name VARCHAR2(80);
4662: ln_balance_type_id NUMBER;
4701: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd,
4702: NULL);
4703: hr_utility.trace('Index = '|| ln_index);
4704:
4705: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4706: := p_jurisdiction_tab(i).emp_jd;
4707: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4708: := 'US CITY';
4709:
4703: hr_utility.trace('Index = '|| ln_index);
4704:
4705: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4706: := p_jurisdiction_tab(i).emp_jd;
4707: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4708: := 'US CITY';
4709:
4710: /************************************************************
4711: ** When comparing the City Jurisdiction for
4717: || '-000-'
4718: || substr(p_jurisdiction_tab(i).emp_jd,8,4)
4719: = p_resident_state || '-000-'
4720: || p_resident_city then
4721: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'R';
4722: else
4723: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
4724: end if;
4725:
4719: = p_resident_state || '-000-'
4720: || p_resident_city then
4721: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'R';
4722: else
4723: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
4724: end if;
4725:
4726: if pay_us_action_arch.ltr_city_tax_bal.count > 0 then
4727: for k in pay_us_action_arch.ltr_city_tax_bal.first..
4857: ,p_resident_state in varchar2
4858: ,p_resident_county in varchar2
4859: ,p_resident_city in varchar2
4860: ,p_effective_date in date
4861: ,p_jurisdiction_tab in pay_ac_action_arch.emp_jd_rec_table)
4862: IS
4863: ln_index NUMBER ;
4864: lv_balance_name VARCHAR2(80);
4865: ln_balance_type_id NUMBER;
4895: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd,
4896: NULL);
4897: hr_utility.trace('Index = '|| ln_index);
4898:
4899: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4900: := p_jurisdiction_tab(i).emp_jd;
4901: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4902: := 'US PSD';
4903:
4897: hr_utility.trace('Index = '|| ln_index);
4898:
4899: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4900: := p_jurisdiction_tab(i).emp_jd;
4901: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4902: := 'US PSD';
4903:
4904: /************************************************************
4905: ** When comparing the City Jurisdiction for
4916: ,p_balcall_aaid => g_cty_wk_psd_wh_def_bal_id) = 0 then*/
4917: if get_balance_value(
4918: p_defined_balance_id => g_cty_wk_psd_wh_def_bal_id
4919: ,p_balcall_aaid => p_ytd_balcall_aaid) = 0 then
4920: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'R';
4921: else
4922: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
4923: end if;
4924:
4918: p_defined_balance_id => g_cty_wk_psd_wh_def_bal_id
4919: ,p_balcall_aaid => p_ytd_balcall_aaid) = 0 then
4920: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'R';
4921: else
4922: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
4923: end if;
4924:
4925:
4926: if pay_us_action_arch.ltr_psd_tax_bal.count > 0 then
5021: ,p_pymt_balcall_aaid in number default null
5022: ,p_ytd_balcall_aaid in number default null
5023: ,p_rqp_action_id in number
5024: ,p_action_type in varchar2
5025: ,p_jurisdiction_tab in pay_ac_action_arch.emp_rec_table)
5026: IS
5027: ln_index NUMBER ;
5028: lv_balance_name VARCHAR2(80);
5029: ln_balance_type_id NUMBER;
5058: lv_emp_school_jd := p_jurisdiction_tab(j).emp_jd;
5059: ln_index := get_table_index(p_jurisdiction_tab(j).emp_jd,
5060: NULL);
5061:
5062: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5063: := p_jurisdiction_tab(j).emp_jd;
5064: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5065: := 'US SCHOOL DISTRICT';
5066: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30
5060: NULL);
5061:
5062: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5063: := p_jurisdiction_tab(j).emp_jd;
5064: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5065: := 'US SCHOOL DISTRICT';
5066: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30
5067: := p_jurisdiction_tab(j).emp_parent_jd;
5068:
5062: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5063: := p_jurisdiction_tab(j).emp_jd;
5064: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5065: := 'US SCHOOL DISTRICT';
5066: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30
5067: := p_jurisdiction_tab(j).emp_parent_jd;
5068:
5069: if pay_us_action_arch.ltr_schdist_tax_bal.count > 0 then
5070: for k in pay_us_action_arch.ltr_schdist_tax_bal.first..
5426: -- a safety check. We don't care about Federal JD
5427: null;
5428: elsif length(lv_rr_jurisdiction_code) = 11 and
5429: substr(lv_rr_jurisdiction_code, 4) = '000-0000' then
5430: ln_index := pay_ac_action_arch.emp_state_jd.count;
5431: pay_ac_action_arch.emp_state_jd(ln_index).emp_jd
5432: := lv_rr_jurisdiction_code;
5433: /*************************************************************
5434: ** Populate the PLSQL table emp_county_jd with this jd
5427: null;
5428: elsif length(lv_rr_jurisdiction_code) = 11 and
5429: substr(lv_rr_jurisdiction_code, 4) = '000-0000' then
5430: ln_index := pay_ac_action_arch.emp_state_jd.count;
5431: pay_ac_action_arch.emp_state_jd(ln_index).emp_jd
5432: := lv_rr_jurisdiction_code;
5433: /*************************************************************
5434: ** Populate the PLSQL table emp_county_jd with this jd
5435: *************************************************************/
5435: *************************************************************/
5436: elsif length(lv_rr_jurisdiction_code) = 11 and
5437: substr(lv_rr_jurisdiction_code,8) = '0000' and
5438: substr(lv_rr_jurisdiction_code,4,3) <> '000' then
5439: ln_index := pay_ac_action_arch.emp_county_jd.count;
5440: pay_ac_action_arch.emp_county_jd(ln_index).emp_jd
5441: := lv_rr_jurisdiction_code;
5442: /*************************************************************
5443: ** Populate the PLSQL table emp_city_jd with this jd
5436: elsif length(lv_rr_jurisdiction_code) = 11 and
5437: substr(lv_rr_jurisdiction_code,8) = '0000' and
5438: substr(lv_rr_jurisdiction_code,4,3) <> '000' then
5439: ln_index := pay_ac_action_arch.emp_county_jd.count;
5440: pay_ac_action_arch.emp_county_jd(ln_index).emp_jd
5441: := lv_rr_jurisdiction_code;
5442: /*************************************************************
5443: ** Populate the PLSQL table emp_city_jd with this jd
5444: *************************************************************/
5443: ** Populate the PLSQL table emp_city_jd with this jd
5444: *************************************************************/
5445: elsif length(lv_rr_jurisdiction_code) = 11 and
5446: substr(lv_rr_jurisdiction_code,8) <> '0000' then
5447: ln_index := pay_ac_action_arch.emp_city_jd.count;
5448: pay_ac_action_arch.emp_city_jd(ln_index).emp_jd := lv_rr_jurisdiction_code;
5449: ---- PA32 Change begin
5450: /*************************************************************
5451: ** Populate the PLSQL table emp_psd_jd with this jd
5444: *************************************************************/
5445: elsif length(lv_rr_jurisdiction_code) = 11 and
5446: substr(lv_rr_jurisdiction_code,8) <> '0000' then
5447: ln_index := pay_ac_action_arch.emp_city_jd.count;
5448: pay_ac_action_arch.emp_city_jd(ln_index).emp_jd := lv_rr_jurisdiction_code;
5449: ---- PA32 Change begin
5450: /*************************************************************
5451: ** Populate the PLSQL table emp_psd_jd with this jd
5452: *************************************************************/
5451: ** Populate the PLSQL table emp_psd_jd with this jd
5452: *************************************************************/
5453: elsif length(lv_rr_jurisdiction_code) = 16 and
5454: substr(lv_rr_jurisdiction_code,1,2) = '39' then
5455: ln_index := pay_ac_action_arch.emp_psd_jd.count;
5456: pay_ac_action_arch.emp_psd_jd(ln_index).emp_jd := lv_rr_jurisdiction_code;
5457: ---- PA32 Change end
5458: /*************************************************************
5459: ** Populate the PLSQL table emp_school_jd with this jd
5452: *************************************************************/
5453: elsif length(lv_rr_jurisdiction_code) = 16 and
5454: substr(lv_rr_jurisdiction_code,1,2) = '39' then
5455: ln_index := pay_ac_action_arch.emp_psd_jd.count;
5456: pay_ac_action_arch.emp_psd_jd(ln_index).emp_jd := lv_rr_jurisdiction_code;
5457: ---- PA32 Change end
5458: /*************************************************************
5459: ** Populate the PLSQL table emp_school_jd with this jd
5460: *************************************************************/
5467: ,p_start_date => p_start_date
5468: ,p_end_date => p_end_date);
5469: end if;
5470:
5471: ln_index := pay_ac_action_arch.emp_school_jd.count;
5472: pay_ac_action_arch.emp_school_jd(ln_index).emp_jd
5473: := lv_rr_jurisdiction_code;
5474: pay_ac_action_arch.emp_school_jd(ln_index).emp_parent_jd
5475: := lv_rr_sd_parent_jd;
5468: ,p_end_date => p_end_date);
5469: end if;
5470:
5471: ln_index := pay_ac_action_arch.emp_school_jd.count;
5472: pay_ac_action_arch.emp_school_jd(ln_index).emp_jd
5473: := lv_rr_jurisdiction_code;
5474: pay_ac_action_arch.emp_school_jd(ln_index).emp_parent_jd
5475: := lv_rr_sd_parent_jd;
5476: end if;
5470:
5471: ln_index := pay_ac_action_arch.emp_school_jd.count;
5472: pay_ac_action_arch.emp_school_jd(ln_index).emp_jd
5473: := lv_rr_jurisdiction_code;
5474: pay_ac_action_arch.emp_school_jd(ln_index).emp_parent_jd
5475: := lv_rr_sd_parent_jd;
5476: end if;
5477: end if;
5478: end loop;
5512: ,p_pymt_balcall_aaid => p_pymt_balcall_aaid
5513: ,p_ytd_balcall_aaid => p_ytd_balcall_aaid
5514: ,p_rqp_action_id => p_rqp_action_id
5515: ,p_action_type => p_action_type
5516: ,p_jurisdiction_tab => pay_ac_action_arch.emp_state_jd);
5517: hr_utility.set_location(gv_package || lv_procedure_name, 70);
5518:
5519: /*****************************************************************
5520: ** County Information Archiving
5527: ,p_resident_state => lv_resident_state
5528: ,p_resident_county => lv_resident_county
5529: ,p_resident_city => lv_resident_city
5530: ,p_action_type => p_action_type
5531: ,p_jurisdiction_tab => pay_ac_action_arch.emp_county_jd);
5532:
5533: /*****************************************************************
5534: ** City Information Archiving
5535: *****************************************************************/
5542: ,p_resident_state => lv_resident_state
5543: ,p_resident_county => lv_resident_county
5544: ,p_resident_city => lv_resident_city
5545: ,p_effective_date => p_end_date
5546: ,p_jurisdiction_tab => pay_ac_action_arch.emp_city_jd);
5547:
5548: ---- PA32 Change begin
5549: /*****************************************************************
5550: ** PSD Information Archiving
5558: ,p_resident_state => lv_resident_state
5559: ,p_resident_county => lv_resident_county
5560: ,p_resident_city => lv_resident_city
5561: ,p_effective_date => p_end_date
5562: ,p_jurisdiction_tab => pay_ac_action_arch.emp_psd_jd);
5563: ---- PA32 Change end
5564:
5565: /*****************************************************************
5566: ** School District Information Archiving
5570: ,p_pymt_balcall_aaid => p_pymt_balcall_aaid
5571: ,p_ytd_balcall_aaid => p_ytd_balcall_aaid
5572: ,p_rqp_action_id => p_rqp_action_id
5573: ,p_action_type => p_action_type
5574: ,p_jurisdiction_tab => pay_ac_action_arch.emp_school_jd);
5575:
5576:
5577: EXCEPTION
5578: when others then
5667: ** Populate the PLSQL table emp_state_jd with this jd
5668: *************************************************************/
5669: if length(lv_baladj_jurisdiction_code) = 11 and
5670: substr(lv_baladj_jurisdiction_code, 4) = '000-0000' then
5671: ln_index := pay_ac_action_arch.emp_state_jd.count;
5672: pay_ac_action_arch.emp_state_jd(ln_index).emp_jd
5673: := lv_baladj_jurisdiction_code;
5674: /*************************************************************
5675: ** Populate the PLSQL table emp_county_jd with this jd
5668: *************************************************************/
5669: if length(lv_baladj_jurisdiction_code) = 11 and
5670: substr(lv_baladj_jurisdiction_code, 4) = '000-0000' then
5671: ln_index := pay_ac_action_arch.emp_state_jd.count;
5672: pay_ac_action_arch.emp_state_jd(ln_index).emp_jd
5673: := lv_baladj_jurisdiction_code;
5674: /*************************************************************
5675: ** Populate the PLSQL table emp_county_jd with this jd
5676: *************************************************************/
5676: *************************************************************/
5677: elsif length(lv_baladj_jurisdiction_code) = 11 and
5678: substr(lv_baladj_jurisdiction_code,8) = '0000' and
5679: substr(lv_baladj_jurisdiction_code,4,3) <> '000' then
5680: ln_index := pay_ac_action_arch.emp_county_jd.count;
5681: pay_ac_action_arch.emp_county_jd(ln_index).emp_jd
5682: := lv_baladj_jurisdiction_code;
5683: /*************************************************************
5684: ** Populate the PLSQL table emp_city_jd with this jd
5677: elsif length(lv_baladj_jurisdiction_code) = 11 and
5678: substr(lv_baladj_jurisdiction_code,8) = '0000' and
5679: substr(lv_baladj_jurisdiction_code,4,3) <> '000' then
5680: ln_index := pay_ac_action_arch.emp_county_jd.count;
5681: pay_ac_action_arch.emp_county_jd(ln_index).emp_jd
5682: := lv_baladj_jurisdiction_code;
5683: /*************************************************************
5684: ** Populate the PLSQL table emp_city_jd with this jd
5685: *************************************************************/
5684: ** Populate the PLSQL table emp_city_jd with this jd
5685: *************************************************************/
5686: elsif length(lv_baladj_jurisdiction_code) = 11 and
5687: substr(lv_baladj_jurisdiction_code,8) <> '0000' then
5688: ln_index := pay_ac_action_arch.emp_city_jd.count;
5689: pay_ac_action_arch.emp_city_jd(ln_index).emp_jd := lv_baladj_jurisdiction_code;
5690: ---- PA32 Change begin
5691: /*************************************************************
5692: ** Populate the PLSQL table emp_psd_jd with this jd
5685: *************************************************************/
5686: elsif length(lv_baladj_jurisdiction_code) = 11 and
5687: substr(lv_baladj_jurisdiction_code,8) <> '0000' then
5688: ln_index := pay_ac_action_arch.emp_city_jd.count;
5689: pay_ac_action_arch.emp_city_jd(ln_index).emp_jd := lv_baladj_jurisdiction_code;
5690: ---- PA32 Change begin
5691: /*************************************************************
5692: ** Populate the PLSQL table emp_psd_jd with this jd
5693: *************************************************************/
5692: ** Populate the PLSQL table emp_psd_jd with this jd
5693: *************************************************************/
5694: elsif length(lv_baladj_jurisdiction_code) = 16 and
5695: substr(lv_baladj_jurisdiction_code,1,2) = '39' then
5696: ln_index := pay_ac_action_arch.emp_psd_jd.count;
5697: pay_ac_action_arch.emp_psd_jd(ln_index).emp_jd := lv_baladj_jurisdiction_code;
5698: ---- PA32 Change end
5699: /*************************************************************
5700: ** Populate the PLSQL table emp_school_jd with this jd
5693: *************************************************************/
5694: elsif length(lv_baladj_jurisdiction_code) = 16 and
5695: substr(lv_baladj_jurisdiction_code,1,2) = '39' then
5696: ln_index := pay_ac_action_arch.emp_psd_jd.count;
5697: pay_ac_action_arch.emp_psd_jd(ln_index).emp_jd := lv_baladj_jurisdiction_code;
5698: ---- PA32 Change end
5699: /*************************************************************
5700: ** Populate the PLSQL table emp_school_jd with this jd
5701: *************************************************************/
5707: ,p_start_date => p_start_date
5708: ,p_end_date => p_end_date);
5709: end if;
5710:
5711: ln_index := pay_ac_action_arch.emp_school_jd.count;
5712: pay_ac_action_arch.emp_school_jd(ln_index).emp_jd := lv_baladj_jurisdiction_code;
5713: pay_ac_action_arch.emp_school_jd(ln_index).emp_parent_jd := lv_rr_sd_parent_jd;
5714: end if;
5715: end loop;
5708: ,p_end_date => p_end_date);
5709: end if;
5710:
5711: ln_index := pay_ac_action_arch.emp_school_jd.count;
5712: pay_ac_action_arch.emp_school_jd(ln_index).emp_jd := lv_baladj_jurisdiction_code;
5713: pay_ac_action_arch.emp_school_jd(ln_index).emp_parent_jd := lv_rr_sd_parent_jd;
5714: end if;
5715: end loop;
5716: close c_get_baladj_jd;
5709: end if;
5710:
5711: ln_index := pay_ac_action_arch.emp_school_jd.count;
5712: pay_ac_action_arch.emp_school_jd(ln_index).emp_jd := lv_baladj_jurisdiction_code;
5713: pay_ac_action_arch.emp_school_jd(ln_index).emp_parent_jd := lv_rr_sd_parent_jd;
5714: end if;
5715: end loop;
5716: close c_get_baladj_jd;
5717: hr_utility.set_location(gv_package || lv_procedure_name, 50);
5744: populate_state_tax_balances(
5745: p_xfr_action_id => p_xfr_action_id
5746: ,p_rqp_action_id => ln_baladj_action_id
5747: ,p_action_type => p_action_type
5748: ,p_jurisdiction_tab => pay_ac_action_arch.emp_state_jd);
5749: hr_utility.set_location(gv_package || lv_procedure_name, 80);
5750:
5751: /*****************************************************************
5752: ** County Information Archiving
5757: ,p_resident_state => lv_resident_state
5758: ,p_resident_county => lv_resident_county
5759: ,p_resident_city => lv_resident_city
5760: ,p_action_type => p_action_type
5761: ,p_jurisdiction_tab => pay_ac_action_arch.emp_county_jd);
5762: hr_utility.set_location(gv_package || lv_procedure_name, 90);
5763:
5764: /*****************************************************************
5765: ** City Information Archiving
5771: ,p_resident_state => lv_resident_state
5772: ,p_resident_county => lv_resident_county
5773: ,p_resident_city => lv_resident_city
5774: ,p_effective_date => p_end_date
5775: ,p_jurisdiction_tab => pay_ac_action_arch.emp_city_jd);
5776: hr_utility.set_location(gv_package || lv_procedure_name, 100);
5777:
5778: ---- PA32 Change begin
5779: /*****************************************************************
5786: ,p_resident_state => lv_resident_state
5787: ,p_resident_county => lv_resident_county
5788: ,p_resident_city => lv_resident_city
5789: ,p_effective_date => p_end_date
5790: ,p_jurisdiction_tab => pay_ac_action_arch.emp_psd_jd);
5791: hr_utility.set_location(gv_package || lv_procedure_name, 105);
5792: ---- PA32 Change end
5793:
5794: /*****************************************************************
5797: populate_school_tax_balances(
5798: p_xfr_action_id => p_xfr_action_id
5799: ,p_rqp_action_id => ln_baladj_action_id
5800: ,p_action_type => p_action_type
5801: ,p_jurisdiction_tab => pay_ac_action_arch.emp_school_jd);
5802: hr_utility.set_location(gv_package || lv_procedure_name, 110);
5803:
5804: /*****************************************************************
5805: ** Initialize the PL/SQL tables for State, County, City and School
5803:
5804: /*****************************************************************
5805: ** Initialize the PL/SQL tables for State, County, City and School
5806: *****************************************************************/
5807: pay_ac_action_arch.emp_state_jd.delete;
5808: pay_ac_action_arch.emp_city_jd.delete;
5809: pay_ac_action_arch.emp_county_jd.delete;
5810: pay_ac_action_arch.emp_school_jd.delete;
5811: hr_utility.set_location(gv_package || lv_procedure_name, 120);
5804: /*****************************************************************
5805: ** Initialize the PL/SQL tables for State, County, City and School
5806: *****************************************************************/
5807: pay_ac_action_arch.emp_state_jd.delete;
5808: pay_ac_action_arch.emp_city_jd.delete;
5809: pay_ac_action_arch.emp_county_jd.delete;
5810: pay_ac_action_arch.emp_school_jd.delete;
5811: hr_utility.set_location(gv_package || lv_procedure_name, 120);
5812:
5805: ** Initialize the PL/SQL tables for State, County, City and School
5806: *****************************************************************/
5807: pay_ac_action_arch.emp_state_jd.delete;
5808: pay_ac_action_arch.emp_city_jd.delete;
5809: pay_ac_action_arch.emp_county_jd.delete;
5810: pay_ac_action_arch.emp_school_jd.delete;
5811: hr_utility.set_location(gv_package || lv_procedure_name, 120);
5812:
5813: end loop;
5806: *****************************************************************/
5807: pay_ac_action_arch.emp_state_jd.delete;
5808: pay_ac_action_arch.emp_city_jd.delete;
5809: pay_ac_action_arch.emp_county_jd.delete;
5810: pay_ac_action_arch.emp_school_jd.delete;
5811: hr_utility.set_location(gv_package || lv_procedure_name, 120);
5812:
5813: end loop;
5814: close c_get_emp_adjbal;
6063: /*End Bug#9872952*/
6064:
6065: hr_utility.trace('Going to write get_withholding_info record for fed');
6066:
6067: ln_index := pay_ac_action_arch.lrr_act_tab.count;
6068:
6069: hr_utility.trace('ln_index in get_withholding_info proc is '
6070: || pay_ac_action_arch.lrr_act_tab.count);
6071:
6066:
6067: ln_index := pay_ac_action_arch.lrr_act_tab.count;
6068:
6069: hr_utility.trace('ln_index in get_withholding_info proc is '
6070: || pay_ac_action_arch.lrr_act_tab.count);
6071:
6072: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
6073: := 'US WITHHOLDINGS';
6074: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
6068:
6069: hr_utility.trace('ln_index in get_withholding_info proc is '
6070: || pay_ac_action_arch.lrr_act_tab.count);
6071:
6072: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
6073: := 'US WITHHOLDINGS';
6074: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
6075: := '00-000-0000';
6076: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
6070: || pay_ac_action_arch.lrr_act_tab.count);
6071:
6072: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
6073: := 'US WITHHOLDINGS';
6074: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
6075: := '00-000-0000';
6076: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
6077: := 'Federal';
6078: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
6072: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
6073: := 'US WITHHOLDINGS';
6074: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
6075: := '00-000-0000';
6076: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
6077: := 'Federal';
6078: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
6079: := lv_fit_filing_status;
6080: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
6074: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
6075: := '00-000-0000';
6076: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
6077: := 'Federal';
6078: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
6079: := lv_fit_filing_status;
6080: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
6081: := ln_fit_withholding_allowances;
6082: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6076: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
6077: := 'Federal';
6078: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
6079: := lv_fit_filing_status;
6080: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
6081: := ln_fit_withholding_allowances;
6082: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6083: := fnd_number.number_to_canonical(
6084: ln_fit_additional_wa_amount);
6078: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
6079: := lv_fit_filing_status;
6080: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
6081: := ln_fit_withholding_allowances;
6082: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6083: := fnd_number.number_to_canonical(
6084: ln_fit_additional_wa_amount);
6085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6086: := fnd_number.number_to_canonical(
6081: := ln_fit_withholding_allowances;
6082: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6083: := fnd_number.number_to_canonical(
6084: ln_fit_additional_wa_amount);
6085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6086: := fnd_number.number_to_canonical(
6087: ln_fit_override_amount);
6088: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6089: := ln_fit_override_rate;
6084: ln_fit_additional_wa_amount);
6085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6086: := fnd_number.number_to_canonical(
6087: ln_fit_override_amount);
6088: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6089: := ln_fit_override_rate;
6090:
6091: IF lv_wage_accumulation = 'Y' THEN
6092:
6089: := ln_fit_override_rate;
6090:
6091: IF lv_wage_accumulation = 'Y' THEN
6092:
6093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10/*Added for Bug#9872952*/
6094: := ln_wage_exempt;
6095:
6096: g_wage_exempt := ln_wage_exempt;
6097:
6152: if ((lv_time_in_state > 0) or
6153: (lv_time_in_state = 0 and
6154: substr(lv_jurisdiction_code, 1,2) = substr(p_resident_jurisdiction,1,2))) then
6155:
6156: ln_index := pay_ac_action_arch.lrr_act_tab.count;
6157: hr_utility.trace('ln_index = ' || ln_index);
6158:
6159: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
6160: := 'US WITHHOLDINGS';
6155:
6156: ln_index := pay_ac_action_arch.lrr_act_tab.count;
6157: hr_utility.trace('ln_index = ' || ln_index);
6158:
6159: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
6160: := 'US WITHHOLDINGS';
6161: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
6162: := lv_jurisdiction_code;
6163: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
6157: hr_utility.trace('ln_index = ' || ln_index);
6158:
6159: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
6160: := 'US WITHHOLDINGS';
6161: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
6162: := lv_jurisdiction_code;
6163: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
6164: := lv_state_name ;
6165: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
6159: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
6160: := 'US WITHHOLDINGS';
6161: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
6162: := lv_jurisdiction_code;
6163: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
6164: := lv_state_name ;
6165: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
6166: := lv_sit_filing_status;
6167: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
6161: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
6162: := lv_jurisdiction_code;
6163: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
6164: := lv_state_name ;
6165: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
6166: := lv_sit_filing_status;
6167: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
6168: := ln_sit_withholding_allowances;
6169: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6163: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
6164: := lv_state_name ;
6165: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
6166: := lv_sit_filing_status;
6167: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
6168: := ln_sit_withholding_allowances;
6169: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6170: := fnd_number.number_to_canonical(
6171: ln_sit_additional_wa_amount);
6165: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
6166: := lv_sit_filing_status;
6167: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
6168: := ln_sit_withholding_allowances;
6169: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6170: := fnd_number.number_to_canonical(
6171: ln_sit_additional_wa_amount);
6172: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6173: := fnd_number.number_to_canonical(ln_sit_override_amount);
6168: := ln_sit_withholding_allowances;
6169: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6170: := fnd_number.number_to_canonical(
6171: ln_sit_additional_wa_amount);
6172: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6173: := fnd_number.number_to_canonical(ln_sit_override_amount);
6174: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6175: := ln_sit_override_rate;
6176: end if;
6170: := fnd_number.number_to_canonical(
6171: ln_sit_additional_wa_amount);
6172: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6173: := fnd_number.number_to_canonical(ln_sit_override_amount);
6174: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6175: := ln_sit_override_rate;
6176: end if;
6177: end loop;
6178: close c_emp_state_info;
7057: );
7058:
7059: hr_utility.set_location(gv_package || lv_procedure_name, 80);
7060:
7061: ln_index := pay_ac_action_arch.lrr_act_tab.count;
7062:
7063: hr_utility.trace('ln_index in get_3rdparty_pay_distribution proc is '
7064: || pay_ac_action_arch.lrr_act_tab.count);
7065: hr_utility.trace('Attachment details ln_earned_date = '|| ln_earned_date);
7060:
7061: ln_index := pay_ac_action_arch.lrr_act_tab.count;
7062:
7063: hr_utility.trace('ln_index in get_3rdparty_pay_distribution proc is '
7064: || pay_ac_action_arch.lrr_act_tab.count);
7065: hr_utility.trace('Attachment details ln_earned_date = '|| ln_earned_date);
7066: hr_utility.trace('ln_fips_code = '|| ln_fips_code);
7067: hr_utility.trace('ln_third_party_note = '|| ln_third_party_note);
7068: hr_utility.trace('ln_medical_indicator = '|| ln_medical_indicator);
7070: hr_utility.trace('ln_print_ssn = '|| ln_print_ssn);
7071: hr_utility.trace('ln_wages = '|| ln_wages);
7072: hr_utility.trace('ln_cnty_name = '|| ln_cnty_name);
7073:
7074: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
7075: := 'US THIRD PARTY CHECKS';
7076: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
7077: := '00-000-0000';
7078: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
7072: hr_utility.trace('ln_cnty_name = '|| ln_cnty_name);
7073:
7074: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
7075: := 'US THIRD PARTY CHECKS';
7076: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
7077: := '00-000-0000';
7078: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
7079: := NULL;
7080: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
7074: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
7075: := 'US THIRD PARTY CHECKS';
7076: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
7077: := '00-000-0000';
7078: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
7079: := NULL;
7080: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
7081: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
7082: := ln_pre_payment_id;
7077: := '00-000-0000';
7078: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
7079: := NULL;
7080: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
7081: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
7082: := ln_pre_payment_id;
7083: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
7084: := fnd_number.number_to_canonical(ln_value);
7085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
7079: := NULL;
7080: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
7081: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
7082: := ln_pre_payment_id;
7083: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
7084: := fnd_number.number_to_canonical(ln_value);
7085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
7086: := ltt_actions(j);
7087: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
7081: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
7082: := ln_pre_payment_id;
7083: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
7084: := fnd_number.number_to_canonical(ln_value);
7085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
7086: := ltt_actions(j);
7087: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
7088: := ln_org_payment_method_id;
7089: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
7083: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
7084: := fnd_number.number_to_canonical(ln_value);
7085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
7086: := ltt_actions(j);
7087: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
7088: := ln_org_payment_method_id;
7089: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
7090: := lv_org_payment_method_name;
7091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
7085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
7086: := ltt_actions(j);
7087: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
7088: := ln_org_payment_method_id;
7089: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
7090: := lv_org_payment_method_name;
7091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
7092: := ln_emp_payment_method_id;
7093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
7087: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
7088: := ln_org_payment_method_id;
7089: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
7090: := lv_org_payment_method_name;
7091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
7092: := ln_emp_payment_method_id;
7093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
7094: := ln_payee_id;
7095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
7089: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
7090: := lv_org_payment_method_name;
7091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
7092: := ln_emp_payment_method_id;
7093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
7094: := ln_payee_id;
7095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
7096: := fnd_date.date_to_canonical(ln_earned_date);
7097: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
7091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
7092: := ln_emp_payment_method_id;
7093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
7094: := ln_payee_id;
7095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
7096: := fnd_date.date_to_canonical(ln_earned_date);
7097: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
7098: := fnd_date.date_to_canonical(ln_payment_date);
7099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
7093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
7094: := ln_payee_id;
7095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
7096: := fnd_date.date_to_canonical(ln_earned_date);
7097: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
7098: := fnd_date.date_to_canonical(ln_payment_date);
7099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
7100: := ln_payee_name ;
7101: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
7095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
7096: := fnd_date.date_to_canonical(ln_earned_date);
7097: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
7098: := fnd_date.date_to_canonical(ln_payment_date);
7099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
7100: := ln_payee_name ;
7101: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
7102: := ln_address_line1;
7103: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
7097: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
7098: := fnd_date.date_to_canonical(ln_payment_date);
7099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
7100: := ln_payee_name ;
7101: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
7102: := ln_address_line1;
7103: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
7104: := ln_address_line2;
7105: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
7099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
7100: := ln_payee_name ;
7101: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
7102: := ln_address_line1;
7103: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
7104: := ln_address_line2;
7105: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
7106: := ln_address_line3;
7107: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
7101: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
7102: := ln_address_line1;
7103: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
7104: := ln_address_line2;
7105: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
7106: := ln_address_line3;
7107: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
7108: := ln_town_or_city;
7109: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
7103: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
7104: := ln_address_line2;
7105: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
7106: := ln_address_line3;
7107: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
7108: := ln_town_or_city;
7109: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
7110: := ln_region2;
7111: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
7105: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
7106: := ln_address_line3;
7107: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
7108: := ln_town_or_city;
7109: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
7110: := ln_region2;
7111: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
7112: := ln_postal_code;
7113: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
7107: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
7108: := ln_town_or_city;
7109: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
7110: := ln_region2;
7111: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
7112: := ln_postal_code;
7113: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
7114: := ln_attachment_number;
7115: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
7109: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
7110: := ln_region2;
7111: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
7112: := ln_postal_code;
7113: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
7114: := ln_attachment_number;
7115: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
7116: := ln_jurisdiction;
7117: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
7111: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
7112: := ln_postal_code;
7113: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
7114: := ln_attachment_number;
7115: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
7116: := ln_jurisdiction;
7117: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
7118: := ln_print_ssn;
7119: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
7113: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
7114: := ln_attachment_number;
7115: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
7116: := ln_jurisdiction;
7117: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
7118: := ln_print_ssn;
7119: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
7120: := ln_fips_code;
7121: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
7115: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
7116: := ln_jurisdiction;
7117: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
7118: := ln_print_ssn;
7119: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
7120: := ln_fips_code;
7121: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
7122: := ln_third_party_note;
7123: pay_ac_action_arch.lrr_act_tab(ln_index).act_info23
7117: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
7118: := ln_print_ssn;
7119: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
7120: := ln_fips_code;
7121: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
7122: := ln_third_party_note;
7123: pay_ac_action_arch.lrr_act_tab(ln_index).act_info23
7124: := ln_wages;
7125: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
7119: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
7120: := ln_fips_code;
7121: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
7122: := ln_third_party_note;
7123: pay_ac_action_arch.lrr_act_tab(ln_index).act_info23
7124: := ln_wages;
7125: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
7126: := ln_cnty_name;
7127: pay_ac_action_arch.lrr_act_tab(ln_index).act_info25
7121: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
7122: := ln_third_party_note;
7123: pay_ac_action_arch.lrr_act_tab(ln_index).act_info23
7124: := ln_wages;
7125: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
7126: := ln_cnty_name;
7127: pay_ac_action_arch.lrr_act_tab(ln_index).act_info25
7128: := ln_medical_indicator;
7129:
7123: pay_ac_action_arch.lrr_act_tab(ln_index).act_info23
7124: := ln_wages;
7125: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
7126: := ln_cnty_name;
7127: pay_ac_action_arch.lrr_act_tab(ln_index).act_info25
7128: := ln_medical_indicator;
7129:
7130: end loop;
7131: close c_third_party_pay;
7287: ld_run_effective_date;
7288: close c_time_period;
7289:
7290: hr_utility.set_location(gv_package || lv_procedure_name, 70);
7291: pay_ac_action_arch.get_last_xfr_info(
7292: p_assignment_id => p_assignment_id
7293: ,p_curr_effective_date => p_xfr_end_date
7294: ,p_action_info_category => 'EMPLOYEE DETAILS'
7295: ,p_xfr_action_id => p_xfr_action_id
7345: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
7346: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
7347: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
7348:
7349: pay_ac_action_arch.initialization_process;
7350:
7351: /*********************************************************************
7352: ** If p_archive_balance_info is not Y then it mean that the assignment
7353: ** does not have any Gross or Payments in the Run. In this case, we
7383: ** same session the process will always go to the else statement
7384: ******************************************************************/
7385: if ld_last_xfr_eff_date is null then
7386: hr_utility.set_location(gv_package || lv_procedure_name, 100);
7387: pay_ac_action_arch.first_time_process(
7388: p_xfr_action_id => p_xfr_action_id
7389: ,p_assignment_id => p_assignment_id
7390: ,p_curr_pymt_action_id => p_rqp_action_id
7391: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
7399: );
7400:
7401: else
7402: hr_utility.set_location(gv_package || lv_procedure_name, 110);
7403: pay_ac_action_arch.get_current_elements(
7404: p_xfr_action_id => p_xfr_action_id
7405: ,p_curr_pymt_action_id => p_rqp_action_id
7406: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
7407: ,p_assignment_id => p_assignment_id
7438:
7439: end if; /* p_archive_balance_info = 'Y' */
7440:
7441: hr_utility.set_location(gv_package || lv_procedure_name, 135);
7442: pay_ac_action_arch.get_xfr_elements(
7443: p_xfr_action_id => p_xfr_action_id
7444: ,p_last_xfr_action_id => ln_last_xfr_action_id
7445: ,p_ytd_balcall_aaid => ln_ytd_balcall_aaid
7446: ,p_pymt_eff_date => p_curr_pymt_eff_date
7448: ,p_sepchk_flag => p_seperate_check_flag
7449: ,p_assignment_id => p_assignment_id);
7450:
7451: hr_utility.set_location(gv_package || lv_procedure_name, 140);
7452: pay_ac_action_arch.get_last_pymt_info(
7453: p_assignment_id => p_assignment_id
7454: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
7455: ,p_last_pymt_eff_date => ld_last_pymt_eff_date
7456: ,p_last_pymt_action_id => ln_last_pymt_action_id);
7456: ,p_last_pymt_action_id => ln_last_pymt_action_id);
7457:
7458: if ld_last_xfr_eff_date <> ld_last_pymt_eff_date then
7459: hr_utility.set_location(gv_package || lv_procedure_name, 145);
7460: pay_ac_action_arch.get_missing_xfr_info(
7461: p_xfr_action_id => p_xfr_action_id
7462: ,p_tax_unit_id => p_tax_unit_id
7463: ,p_assignment_id => p_assignment_id
7464: ,p_last_pymt_action_id => ln_last_pymt_action_id
7502: if g_wage_exempt = 'Y' then
7503:
7504: hr_utility.trace('Updating the Wage Exempt value');
7505:
7506: for t in pay_ac_action_arch.lrr_act_tab.first..
7507: pay_ac_action_arch.lrr_act_tab.last LOOP
7508:
7509: if pay_ac_action_arch.lrr_act_tab(t).action_info_category = 'US FEDERAL'
7510: then
7503:
7504: hr_utility.trace('Updating the Wage Exempt value');
7505:
7506: for t in pay_ac_action_arch.lrr_act_tab.first..
7507: pay_ac_action_arch.lrr_act_tab.last LOOP
7508:
7509: if pay_ac_action_arch.lrr_act_tab(t).action_info_category = 'US FEDERAL'
7510: then
7511: pay_ac_action_arch.lrr_act_tab(t).act_info27 := g_wage_exempt;
7505:
7506: for t in pay_ac_action_arch.lrr_act_tab.first..
7507: pay_ac_action_arch.lrr_act_tab.last LOOP
7508:
7509: if pay_ac_action_arch.lrr_act_tab(t).action_info_category = 'US FEDERAL'
7510: then
7511: pay_ac_action_arch.lrr_act_tab(t).act_info27 := g_wage_exempt;
7512: exit;
7513: end if;
7507: pay_ac_action_arch.lrr_act_tab.last LOOP
7508:
7509: if pay_ac_action_arch.lrr_act_tab(t).action_info_category = 'US FEDERAL'
7510: then
7511: pay_ac_action_arch.lrr_act_tab(t).act_info27 := g_wage_exempt;
7512: exit;
7513: end if;
7514:
7515: end loop;
7522: hr_utility.set_location(gv_package || lv_procedure_name, 170);
7523: -- Archive element processed in balance adjustment. This only
7524: -- needs to be done for master action as once the element is
7525: -- in archive, it will be carried forward.
7526: pay_ac_action_arch.process_baladj_elements(
7527: p_assignment_id => p_assignment_id
7528: ,p_xfr_action_id => p_xfr_action_id
7529: ,p_last_xfr_action_id => ln_last_xfr_action_id
7530: ,p_curr_pymt_action_id => p_rqp_action_id
7565: ,p_run_action_id => p_payment_action_id);
7566: end if;
7567:
7568: hr_utility.set_location(gv_package || lv_procedure_name, 205);
7569: pay_ac_action_arch.populate_summary(
7570: p_xfr_action_id => p_xfr_action_id);
7571: change_processing_priority;
7572:
7573: hr_utility.set_location(gv_package || lv_procedure_name, 210);
7595: ,p_action_context_type=> 'AAP'
7596: ,p_assignment_id => p_assignment_id
7597: ,p_tax_unit_id => p_tax_unit_id
7598: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
7599: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
7600: );
7601:
7602: hr_utility.set_location(gv_package || lv_procedure_name, 220);
7603:
8202:
8203: -- An assignment only needs to be processed once as that will
8204: -- move all elements.
8205: if ln_np_asg_id <> ln_np_prev_asg_id then
8206: pay_ac_action_arch.emp_elements_tab.delete;
8207: pay_ac_action_arch.lrr_act_tab.delete;
8208:
8209: -- Check if the date of assignment process is the same as
8210: -- last archive date. If they are the same, the element just
8203: -- An assignment only needs to be processed once as that will
8204: -- move all elements.
8205: if ln_np_asg_id <> ln_np_prev_asg_id then
8206: pay_ac_action_arch.emp_elements_tab.delete;
8207: pay_ac_action_arch.lrr_act_tab.delete;
8208:
8209: -- Check if the date of assignment process is the same as
8210: -- last archive date. If they are the same, the element just
8211: -- needs to be moved forward otherwise we need to get the
8225: hr_utility.trace('ld_last_xfr_eff_date ='||ld_last_xfr_eff_date);
8226:
8227: if ld_np_last_xfr_eff_date >= ld_last_xfr_eff_date then
8228: -- To be Changed
8229: pay_ac_action_arch.get_xfr_elements(
8230: p_xfr_action_id => ln_child_xfr_action_id
8231: ,p_last_xfr_action_id => ln_last_xfr_action_id
8232: ,p_ytd_balcall_aaid => ln_np_asg_action_id
8233: ,p_pymt_eff_date => ld_curr_pymt_eff_date
8234: ,p_legislation_code => lv_legislation_code
8235: ,p_sepchk_flag => lv_master_sepcheck_flag
8236: ,p_assignment_id => ln_np_asg_id);
8237: else
8238: pay_ac_action_arch.process_additional_elements
8239: (p_assignment_id => ln_np_asg_id,
8240: p_assignment_action_id => ln_np_asg_action_id,
8241: p_curr_eff_date => ld_curr_pymt_eff_date,
8242: p_xfr_action_id => ln_child_xfr_action_id,
8245:
8246: change_processing_priority;
8247: end if;
8248:
8249: pay_ac_action_arch.populate_summary(
8250: p_xfr_action_id => p_xfr_action_id);
8251:
8252: pay_emp_action_arch.insert_rows_thro_api_process(
8253: p_action_context_id => ln_child_xfr_action_id
8254: ,p_action_context_type=> 'AAP'
8255: ,p_assignment_id => ln_np_asg_id
8256: ,p_tax_unit_id => ln_tax_unit_id
8257: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
8258: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
8259: );
8260:
8261: end if;
8262: ln_np_prev_asg_id := ln_np_asg_id;
8279: ln_pymt_balcall_aaid := ln_asg_action_id ;
8280: hr_utility.trace('Reversal ln_pymt_balcall_aaid'
8281: ||to_char(ln_pymt_balcall_aaid));
8282: ln_step := 12;
8283: pay_ac_action_arch.initialization_process;
8284: ln_step := 13;
8285: populate_puv_tax_balances(
8286: p_xfr_action_id => p_xfr_action_id
8287: ,p_assignment_id => ln_xfr_assignment_id
8303: ,p_action_context_type=> 'AAP'
8304: ,p_assignment_id => ln_xfr_assignment_id
8305: ,p_tax_unit_id => ln_tax_unit_id
8306: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
8307: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
8308: );
8309:
8310: end if;
8311:
8312: ln_step := 15;
8313: if lv_master_action_type = 'B' then
8314: hr_utility.trace('Reversal ln_pymt_balcall_aaid'
8315: ||to_char(ln_pymt_balcall_aaid));
8316: pay_ac_action_arch.initialization_process;
8317: ln_step := 16;
8318: populate_adj_tax_balances(
8319: p_xfr_action_id => p_xfr_action_id
8320: ,p_assignment_id => ln_xfr_assignment_id
8332: ,p_action_context_type=> 'AAP'
8333: ,p_assignment_id => ln_xfr_assignment_id
8334: ,p_tax_unit_id => ln_tax_unit_id
8335: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
8336: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
8337: );
8338:
8339: end if;
8340: