eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_MX_PAYROLL_ARCH dependencies on PAY_AC_ACTION_ARCH

Line 285: IF pay_ac_action_arch.lrr_act_tab.count <> 0 THEN

281:
282: ln_step := 6;
283: lv_rate_exists := 'N';
284:
285: IF pay_ac_action_arch.lrr_act_tab.count <> 0 THEN
286: FOR i IN pay_ac_action_arch.lrr_act_tab.first..
287: pay_ac_action_arch.lrr_act_tab.last
288: LOOP
289: IF ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =

Line 286: FOR i IN pay_ac_action_arch.lrr_act_tab.first..

282: ln_step := 6;
283: lv_rate_exists := 'N';
284:
285: IF pay_ac_action_arch.lrr_act_tab.count <> 0 THEN
286: FOR i IN pay_ac_action_arch.lrr_act_tab.first..
287: pay_ac_action_arch.lrr_act_tab.last
288: LOOP
289: IF ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
290: p_xfr_action_id ) AND

Line 287: pay_ac_action_arch.lrr_act_tab.last

283: lv_rate_exists := 'N';
284:
285: IF pay_ac_action_arch.lrr_act_tab.count <> 0 THEN
286: FOR i IN pay_ac_action_arch.lrr_act_tab.first..
287: pay_ac_action_arch.lrr_act_tab.last
288: LOOP
289: IF ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
290: p_xfr_action_id ) AND
291: ( pay_ac_action_arch.lrr_act_tab(i).act_info6 =

Line 289: IF ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =

285: IF pay_ac_action_arch.lrr_act_tab.count <> 0 THEN
286: FOR i IN pay_ac_action_arch.lrr_act_tab.first..
287: pay_ac_action_arch.lrr_act_tab.last
288: LOOP
289: IF ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
290: p_xfr_action_id ) AND
291: ( pay_ac_action_arch.lrr_act_tab(i).act_info6 =
292: p_primary_balance_id ) )
293: THEN

Line 291: ( pay_ac_action_arch.lrr_act_tab(i).act_info6 =

287: pay_ac_action_arch.lrr_act_tab.last
288: LOOP
289: IF ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
290: p_xfr_action_id ) AND
291: ( pay_ac_action_arch.lrr_act_tab(i).act_info6 =
292: p_primary_balance_id ) )
293: THEN
294: lv_rate_exists := 'Y';
295: EXIT;

Line 435: ln_index := pay_ac_action_arch.lrr_act_tab.count;

431: END IF; -- p_pymt_balcall_aaid is not NULL
432:
433: ln_step := 15;
434: IF NVL(ln_ytd_amount, 0) <> 0 OR NVL(ln_payments_amount, 0) <> 0 THEN
435: ln_index := pay_ac_action_arch.lrr_act_tab.count;
436:
437: IF p_attribute_name IN ('Employee Earnings', 'Hourly Earnings',
438: 'Taxable Benefits') THEN
439:

Line 442: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11

438: 'Taxable Benefits') THEN
439:
440: hr_utility.set_location(gv_package || lv_procedure_name, 125);
441: lv_action_category := 'AC EARNINGS';
442: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
443: := fnd_number.number_to_canonical(ln_current_hours);
444: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
445: := fnd_number.number_to_canonical(ln_ytd_hours);
446:

Line 444: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

440: hr_utility.set_location(gv_package || lv_procedure_name, 125);
441: lv_action_category := 'AC EARNINGS';
442: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
443: := fnd_number.number_to_canonical(ln_current_hours);
444: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
445: := fnd_number.number_to_canonical(ln_ytd_hours);
446:
447: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
448: := fnd_number.number_to_canonical(ln_current_days);

Line 447: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14

443: := fnd_number.number_to_canonical(ln_current_hours);
444: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
445: := fnd_number.number_to_canonical(ln_ytd_hours);
446:
447: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
448: := fnd_number.number_to_canonical(ln_current_days);
449: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
450: := fnd_number.number_to_canonical(ln_ytd_days);
451:

Line 449: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15

445: := fnd_number.number_to_canonical(ln_ytd_hours);
446:
447: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
448: := fnd_number.number_to_canonical(ln_current_days);
449: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
450: := fnd_number.number_to_canonical(ln_ytd_days);
451:
452: END IF;
453:

Line 457: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

453:
454: hr_utility.set_location(gv_package || lv_procedure_name, 130);
455: /* Insert this into the plsql table if Current or YTD
456: amount is not Zero */
457: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
458: := lv_action_category;
459: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
460: := p_jurisdiction_code;
461: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

Line 459: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

455: /* Insert this into the plsql table if Current or YTD
456: amount is not Zero */
457: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
458: := lv_action_category;
459: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
460: := p_jurisdiction_code;
461: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
462: := p_xfr_action_id;
463: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

Line 461: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

457: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
458: := lv_action_category;
459: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
460: := p_jurisdiction_code;
461: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
462: := p_xfr_action_id;
463: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
464: := p_primary_balance_id;
465: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

Line 463: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

459: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
460: := p_jurisdiction_code;
461: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
462: := p_xfr_action_id;
463: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
464: := p_primary_balance_id;
465: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
466: := fnd_number.number_to_canonical(ln_payments_amount);
467: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

Line 465: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

461: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
462: := p_xfr_action_id;
463: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
464: := p_primary_balance_id;
465: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
466: := fnd_number.number_to_canonical(ln_payments_amount);
467: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
468: := fnd_number.number_to_canonical(ln_ytd_amount);
469: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

Line 467: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

463: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
464: := p_primary_balance_id;
465: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
466: := fnd_number.number_to_canonical(ln_payments_amount);
467: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
468: := fnd_number.number_to_canonical(ln_ytd_amount);
469: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
470: := p_reporting_name;
471: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16

Line 469: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

465: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
466: := fnd_number.number_to_canonical(ln_payments_amount);
467: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
468: := fnd_number.number_to_canonical(ln_ytd_amount);
469: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
470: := p_reporting_name;
471: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
472: := p_attribute_name;
473:

Line 471: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16

467: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
468: := fnd_number.number_to_canonical(ln_ytd_amount);
469: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
470: := p_reporting_name;
471: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
472: := p_attribute_name;
473:
474: END IF;
475: END IF; -- lv_rate_exists = 'N'

Line 762: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN

758: ln_days_balance_id := NULL;
759: END IF;
760:
761: ln_step := 5;
762: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
763: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
764: pay_ac_action_arch.emp_elements_tab.last LOOP
765: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
766: = ln_primary_balance_id AND

Line 763: FOR i IN pay_ac_action_arch.emp_elements_tab.first..

759: END IF;
760:
761: ln_step := 5;
762: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
763: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
764: pay_ac_action_arch.emp_elements_tab.last LOOP
765: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
766: = ln_primary_balance_id AND
767: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,

Line 764: pay_ac_action_arch.emp_elements_tab.last LOOP

760:
761: ln_step := 5;
762: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
763: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
764: pay_ac_action_arch.emp_elements_tab.last LOOP
765: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
766: = ln_primary_balance_id AND
767: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,
768: -999) = NVL(lv_jurisdiction_code, -999) THEN

Line 765: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id

761: ln_step := 5;
762: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
763: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
764: pay_ac_action_arch.emp_elements_tab.last LOOP
765: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
766: = ln_primary_balance_id AND
767: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,
768: -999) = NVL(lv_jurisdiction_code, -999) THEN
769: lv_element_archived := 'Y';

Line 767: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,

763: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
764: pay_ac_action_arch.emp_elements_tab.last LOOP
765: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
766: = ln_primary_balance_id AND
767: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,
768: -999) = NVL(lv_jurisdiction_code, -999) THEN
769: lv_element_archived := 'Y';
770: EXIT;
771: END IF;

Line 778: ln_index := pay_ac_action_arch.emp_elements_tab.count;

774:
775: IF lv_element_archived = 'N' THEN
776: /* populate the extra element table */
777: ln_step := 10;
778: ln_index := pay_ac_action_arch.emp_elements_tab.count;
779: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
780: := ln_primary_balance_id;
781: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
782: := lv_reporting_name;

Line 779: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id

775: IF lv_element_archived = 'N' THEN
776: /* populate the extra element table */
777: ln_step := 10;
778: ln_index := pay_ac_action_arch.emp_elements_tab.count;
779: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
780: := ln_primary_balance_id;
781: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
782: := lv_reporting_name;
783: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id

Line 781: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name

777: ln_step := 10;
778: ln_index := pay_ac_action_arch.emp_elements_tab.count;
779: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
780: := ln_primary_balance_id;
781: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
782: := lv_reporting_name;
783: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
784: := ln_hours_balance_id;
785: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code

Line 783: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id

779: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
780: := ln_primary_balance_id;
781: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
782: := lv_reporting_name;
783: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
784: := ln_hours_balance_id;
785: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
786: := lv_jurisdiction_code;
787:

Line 785: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code

781: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
782: := lv_reporting_name;
783: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
784: := ln_hours_balance_id;
785: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
786: := lv_jurisdiction_code;
787:
788: IF lv_jurisdiction_code IS NOT NULL THEN
789: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);

Line 843: ln_index := pay_ac_action_arch.lrr_act_tab.count;

839: hr_utility.set_location(gv_package || lv_procedure_name, 100);
840:
841: IF NVL(ln_ytd_amount, 0) <> 0 OR NVL(ln_payments_amount, 0) <> 0 THEN
842:
843: ln_index := pay_ac_action_arch.lrr_act_tab.count;
844: hr_utility.trace('ln_index = ' || ln_index);
845:
846: IF lv_attribute_name IN ('Employee Earnings',
847: 'Hourly Earnings',

Line 851: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

847: 'Hourly Earnings',
848: 'Taxable Benefits') THEN
849:
850: lv_action_info_category := 'AC EARNINGS';
851: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
852: := fnd_number.number_to_canonical(ln_ytd_hours);
853: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
854: := fnd_number.number_to_canonical(ln_ytd_days);
855:

Line 853: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15

849:
850: lv_action_info_category := 'AC EARNINGS';
851: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
852: := fnd_number.number_to_canonical(ln_ytd_hours);
853: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
854: := fnd_number.number_to_canonical(ln_ytd_days);
855:
856: END IF;
857:

Line 859: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

855:
856: END IF;
857:
858: ln_step := 20;
859: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
860: := lv_action_info_category;
861: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
862: := lv_jurisdiction_code;
863: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

Line 861: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

857:
858: ln_step := 20;
859: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
860: := lv_action_info_category;
861: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
862: := lv_jurisdiction_code;
863: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
864: := p_xfr_action_id ;
865: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

Line 863: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

859: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
860: := lv_action_info_category;
861: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
862: := lv_jurisdiction_code;
863: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
864: := p_xfr_action_id ;
865: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
866: := ln_primary_balance_id;
867: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

Line 865: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

861: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
862: := lv_jurisdiction_code;
863: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
864: := p_xfr_action_id ;
865: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
866: := ln_primary_balance_id;
867: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
868: := fnd_number.number_to_canonical(ln_payments_amount);
869: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

Line 867: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

863: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
864: := p_xfr_action_id ;
865: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
866: := ln_primary_balance_id;
867: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
868: := fnd_number.number_to_canonical(ln_payments_amount);
869: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
870: := fnd_number.number_to_canonical(ln_ytd_amount);
871: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

Line 869: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

865: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
866: := ln_primary_balance_id;
867: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
868: := fnd_number.number_to_canonical(ln_payments_amount);
869: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
870: := fnd_number.number_to_canonical(ln_ytd_amount);
871: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
872: := lv_reporting_name;
873: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16

Line 871: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

867: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
868: := fnd_number.number_to_canonical(ln_payments_amount);
869: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
870: := fnd_number.number_to_canonical(ln_ytd_amount);
871: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
872: := lv_reporting_name;
873: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
874: := lv_attribute_name;
875:

Line 873: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16

869: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
870: := fnd_number.number_to_canonical(ln_ytd_amount);
871: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
872: := lv_reporting_name;
873: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
874: := lv_attribute_name;
875:
876: END IF;
877: END IF;

Line 1129: ln_index := pay_ac_action_arch.lrr_act_tab.count;

1125: hr_utility.trace('action_info_category = ' ||lv_act_info_category);
1126: hr_utility.trace('ln_primary_balance_id = '||ln_primary_balance_id);
1127: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
1128:
1129: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1130:
1131: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1132: := lv_act_info_category;
1133: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

Line 1131: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

1127: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
1128:
1129: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1130:
1131: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1132: := lv_act_info_category;
1133: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1134: := lv_jurisdiction_code;
1135: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

Line 1133: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

1129: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1130:
1131: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1132: := lv_act_info_category;
1133: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1134: := lv_jurisdiction_code;
1135: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1136: := p_xfr_action_id;
1137: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id

Line 1135: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

1131: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1132: := lv_act_info_category;
1133: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1134: := lv_jurisdiction_code;
1135: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1136: := p_xfr_action_id;
1137: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1138: := ln_assignment_id;
1139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

Line 1137: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id

1133: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1134: := lv_jurisdiction_code;
1135: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1136: := p_xfr_action_id;
1137: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1138: := ln_assignment_id;
1139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1140: := ln_primary_balance_id;
1141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

Line 1139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

1135: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1136: := p_xfr_action_id;
1137: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1138: := ln_assignment_id;
1139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1140: := ln_primary_balance_id;
1141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1142: := fnd_number.number_to_canonical(ln_ytd_amount);
1143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

Line 1141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

1137: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
1138: := ln_assignment_id;
1139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1140: := ln_primary_balance_id;
1141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1142: := fnd_number.number_to_canonical(ln_ytd_amount);
1143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1144: := lv_reporting_name;
1145: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16

Line 1143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

1139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1140: := ln_primary_balance_id;
1141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1142: := fnd_number.number_to_canonical(ln_ytd_amount);
1143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1144: := lv_reporting_name;
1145: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
1146: := lv_attribute_name;
1147:

Line 1145: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16

1141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1142: := fnd_number.number_to_canonical(ln_ytd_amount);
1143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1144: := lv_reporting_name;
1145: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
1146: := lv_attribute_name;
1147:
1148: IF lv_act_info_category = 'AC EARNINGS' THEN
1149: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

Line 1149: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

1145: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
1146: := lv_attribute_name;
1147:
1148: IF lv_act_info_category = 'AC EARNINGS' THEN
1149: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1150: := fnd_number.number_to_canonical(ln_ytd_hours);
1151: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
1152: := fnd_number.number_to_canonical(ln_ytd_days);
1153: END IF;

Line 1151: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15

1147:
1148: IF lv_act_info_category = 'AC EARNINGS' THEN
1149: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1150: := fnd_number.number_to_canonical(ln_ytd_hours);
1151: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
1152: := fnd_number.number_to_canonical(ln_ytd_days);
1153: END IF;
1154: END IF;
1155:

Line 1157: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN

1153: END IF;
1154: END IF;
1155:
1156: IF ln_assignment_id = p_assignment_id THEN
1157: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
1158: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
1159: pay_ac_action_arch.emp_elements_tab.last LOOP
1160: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
1161: = ln_primary_balance_id AND

Line 1158: FOR i IN pay_ac_action_arch.emp_elements_tab.first..

1154: END IF;
1155:
1156: IF ln_assignment_id = p_assignment_id THEN
1157: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
1158: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
1159: pay_ac_action_arch.emp_elements_tab.last LOOP
1160: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
1161: = ln_primary_balance_id AND
1162: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,

Line 1159: pay_ac_action_arch.emp_elements_tab.last LOOP

1155:
1156: IF ln_assignment_id = p_assignment_id THEN
1157: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
1158: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
1159: pay_ac_action_arch.emp_elements_tab.last LOOP
1160: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
1161: = ln_primary_balance_id AND
1162: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,
1163: -999) = NVL(lv_jurisdiction_code, -999) THEN

Line 1160: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id

1156: IF ln_assignment_id = p_assignment_id THEN
1157: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
1158: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
1159: pay_ac_action_arch.emp_elements_tab.last LOOP
1160: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
1161: = ln_primary_balance_id AND
1162: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,
1163: -999) = NVL(lv_jurisdiction_code, -999) THEN
1164: lv_element_archived := 'Y';

Line 1162: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,

1158: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
1159: pay_ac_action_arch.emp_elements_tab.last LOOP
1160: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
1161: = ln_primary_balance_id AND
1162: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,
1163: -999) = NVL(lv_jurisdiction_code, -999) THEN
1164: lv_element_archived := 'Y';
1165: EXIT;
1166: END IF;

Line 1204: ln_index := pay_ac_action_arch.emp_elements_tab.count;

1200:
1201:
1202: IF lv_element_archived = 'N' THEN
1203: /* populate the extra element table */
1204: ln_index := pay_ac_action_arch.emp_elements_tab.count;
1205: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
1206: := lv_jurisdiction_code;
1207: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
1208: := ln_primary_balance_id;

Line 1205: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code

1201:
1202: IF lv_element_archived = 'N' THEN
1203: /* populate the extra element table */
1204: ln_index := pay_ac_action_arch.emp_elements_tab.count;
1205: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
1206: := lv_jurisdiction_code;
1207: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
1208: := ln_primary_balance_id;
1209: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name

Line 1207: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id

1203: /* populate the extra element table */
1204: ln_index := pay_ac_action_arch.emp_elements_tab.count;
1205: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
1206: := lv_jurisdiction_code;
1207: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
1208: := ln_primary_balance_id;
1209: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
1210: := lv_reporting_name;
1211: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id

Line 1209: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name

1205: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
1206: := lv_jurisdiction_code;
1207: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
1208: := ln_primary_balance_id;
1209: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
1210: := lv_reporting_name;
1211: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
1212: := ln_hours_balance_id;
1213:

Line 1211: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id

1207: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
1208: := ln_primary_balance_id;
1209: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
1210: := lv_reporting_name;
1211: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
1212: := ln_hours_balance_id;
1213:
1214: IF lv_jurisdiction_code IS NOT NULL THEN
1215: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);

Line 1270: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) THEN

1266: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
1267: hr_utility.trace('ln_ytd_days = '||ln_ytd_days);
1268:
1269: IF (( NVL(ln_ytd_amount, 0) + NVL(ln_payments_amount, 0) <> 0 ) OR
1270: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) THEN
1271:
1272: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1273: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1274: hr_utility.trace('ln_index = ' || ln_index);

Line 1273: ln_index := pay_ac_action_arch.lrr_act_tab.count;

1269: IF (( NVL(ln_ytd_amount, 0) + NVL(ln_payments_amount, 0) <> 0 ) OR
1270: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) THEN
1271:
1272: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1273: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1274: hr_utility.trace('ln_index = ' || ln_index);
1275: ln_step := 20;
1276: IF lv_attribute_name IN ('Employee Earnings',
1277: 'Hourly Earnings',

Line 1280: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

1276: IF lv_attribute_name IN ('Employee Earnings',
1277: 'Hourly Earnings',
1278: 'Taxable Benefits') THEN
1279: lv_action_info_category := 'AC EARNINGS';
1280: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1281: := fnd_number.number_to_canonical(ln_ytd_hours);
1282: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
1283: := fnd_number.number_to_canonical(ln_ytd_days);
1284:

Line 1282: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15

1278: 'Taxable Benefits') THEN
1279: lv_action_info_category := 'AC EARNINGS';
1280: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1281: := fnd_number.number_to_canonical(ln_ytd_hours);
1282: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
1283: := fnd_number.number_to_canonical(ln_ytd_days);
1284:
1285: END IF;
1286:

Line 1287: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

1283: := fnd_number.number_to_canonical(ln_ytd_days);
1284:
1285: END IF;
1286:
1287: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1288: := lv_action_info_category;
1289: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1290: := lv_jurisdiction_code;
1291: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

Line 1289: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

1285: END IF;
1286:
1287: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1288: := lv_action_info_category;
1289: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1290: := lv_jurisdiction_code;
1291: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1292: := p_xfr_action_id;
1293: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

Line 1291: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

1287: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1288: := lv_action_info_category;
1289: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1290: := lv_jurisdiction_code;
1291: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1292: := p_xfr_action_id;
1293: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1294: := ln_primary_balance_id;
1295: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

Line 1293: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

1289: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1290: := lv_jurisdiction_code;
1291: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1292: := p_xfr_action_id;
1293: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1294: := ln_primary_balance_id;
1295: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1296: := fnd_number.number_to_canonical(ln_payments_amount);
1297: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

Line 1295: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

1291: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1292: := p_xfr_action_id;
1293: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1294: := ln_primary_balance_id;
1295: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1296: := fnd_number.number_to_canonical(ln_payments_amount);
1297: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1298: := fnd_number.number_to_canonical(ln_ytd_amount);
1299: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

Line 1297: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

1293: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1294: := ln_primary_balance_id;
1295: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1296: := fnd_number.number_to_canonical(ln_payments_amount);
1297: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1298: := fnd_number.number_to_canonical(ln_ytd_amount);
1299: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1300: := lv_reporting_name;
1301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16

Line 1299: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

1295: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1296: := fnd_number.number_to_canonical(ln_payments_amount);
1297: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1298: := fnd_number.number_to_canonical(ln_ytd_amount);
1299: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1300: := lv_reporting_name;
1301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
1302: := lv_attribute_name;
1303: END IF;

Line 1301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16

1297: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1298: := fnd_number.number_to_canonical(ln_ytd_amount);
1299: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1300: := lv_reporting_name;
1301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
1302: := lv_attribute_name;
1303: END IF;
1304: END IF;
1305:

Line 1759: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;

1755: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1756: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
1757:
1758: ln_step := 15;
1759: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
1760: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
1761: := ln_primary_balance_id;
1762: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
1763: := lv_reporting_name;

Line 1760: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

1756: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
1757:
1758: ln_step := 15;
1759: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
1760: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
1761: := ln_primary_balance_id;
1762: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
1763: := lv_reporting_name;
1764: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id

Line 1762: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name

1758: ln_step := 15;
1759: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
1760: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
1761: := ln_primary_balance_id;
1762: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
1763: := lv_reporting_name;
1764: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
1765: := ln_hours_balance_id;
1766:

Line 1764: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id

1760: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
1761: := ln_primary_balance_id;
1762: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
1763: := lv_reporting_name;
1764: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
1765: := ln_hours_balance_id;
1766:
1767: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1768: ln_step := 20;

Line 2087: FOR i IN pay_ac_action_arch.emp_elements_tab.first ..

2083: ** when archiving the Current Action. If it has been archived
2084: ** skip the element
2085: **********************************************************/
2086: ln_step := 15;
2087: FOR i IN pay_ac_action_arch.emp_elements_tab.first ..
2088: pay_ac_action_arch.emp_elements_tab.last LOOP
2089:
2090: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
2091: = ln_primary_balance_id AND

Line 2088: pay_ac_action_arch.emp_elements_tab.last LOOP

2084: ** skip the element
2085: **********************************************************/
2086: ln_step := 15;
2087: FOR i IN pay_ac_action_arch.emp_elements_tab.first ..
2088: pay_ac_action_arch.emp_elements_tab.last LOOP
2089:
2090: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
2091: = ln_primary_balance_id AND
2092: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,

Line 2090: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id

2086: ln_step := 15;
2087: FOR i IN pay_ac_action_arch.emp_elements_tab.first ..
2088: pay_ac_action_arch.emp_elements_tab.last LOOP
2089:
2090: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
2091: = ln_primary_balance_id AND
2092: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,
2093: -999) = NVL(lv_jurisdiction_code, -999) THEN
2094:

Line 2092: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,

2088: pay_ac_action_arch.emp_elements_tab.last LOOP
2089:
2090: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
2091: = ln_primary_balance_id AND
2092: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,
2093: -999) = NVL(lv_jurisdiction_code, -999) THEN
2094:
2095: hr_utility.set_location(gv_package || lv_procedure_name, 65);
2096: lv_element_archived := 'Y';

Line 2104: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;

2100:
2101: IF lv_element_archived = 'N' THEN
2102: ln_step := 20;
2103: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2104: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2105: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2106: := lv_reporting_name;
2107: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2108: := ln_primary_balance_id;

Line 2105: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name

2101: IF lv_element_archived = 'N' THEN
2102: ln_step := 20;
2103: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2104: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2105: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2106: := lv_reporting_name;
2107: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2108: := ln_primary_balance_id;
2109: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id

Line 2107: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

2103: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2104: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2105: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2106: := lv_reporting_name;
2107: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2108: := ln_primary_balance_id;
2109: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2110: := ln_hours_balance_id;
2111: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code

Line 2109: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id

2105: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2106: := lv_reporting_name;
2107: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2108: := ln_primary_balance_id;
2109: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2110: := ln_hours_balance_id;
2111: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2112: := lv_jurisdiction_code;
2113:

Line 2111: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code

2107: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2108: := ln_primary_balance_id;
2109: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2110: := ln_hours_balance_id;
2111: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2112: := lv_jurisdiction_code;
2113:
2114: /*****************************************************************
2115: ** The Payment Assignemnt Action is not passed to this procedure

Line 2155: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN

2151: hr_utility.set_location(gv_package || lv_procedure_name, 90);
2152:
2153:
2154: ln_step := 30;
2155: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
2156: FOR i IN pay_ac_action_arch.lrr_act_tab.first ..
2157: pay_ac_action_arch.lrr_act_tab.last LOOP
2158:
2159: hr_utility.trace('after populate_elements ftp' ||

Line 2156: FOR i IN pay_ac_action_arch.lrr_act_tab.first ..

2152:
2153:
2154: ln_step := 30;
2155: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
2156: FOR i IN pay_ac_action_arch.lrr_act_tab.first ..
2157: pay_ac_action_arch.lrr_act_tab.last LOOP
2158:
2159: hr_utility.trace('after populate_elements ftp' ||
2160: ' action_context_id IS ' ||

Line 2157: pay_ac_action_arch.lrr_act_tab.last LOOP

2153:
2154: ln_step := 30;
2155: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
2156: FOR i IN pay_ac_action_arch.lrr_act_tab.first ..
2157: pay_ac_action_arch.lrr_act_tab.last LOOP
2158:
2159: hr_utility.trace('after populate_elements ftp' ||
2160: ' action_context_id IS ' ||
2161: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));

Line 2161: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));

2157: pay_ac_action_arch.lrr_act_tab.last LOOP
2158:
2159: hr_utility.trace('after populate_elements ftp' ||
2160: ' action_context_id IS ' ||
2161: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
2162: hr_utility.trace('action_info_category ' ||
2163: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
2164: hr_utility.trace('act_info1 IS ' ||
2165: pay_ac_action_arch.lrr_act_tab(i).act_info1);

Line 2163: pay_ac_action_arch.lrr_act_tab(i).action_info_category);

2159: hr_utility.trace('after populate_elements ftp' ||
2160: ' action_context_id IS ' ||
2161: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
2162: hr_utility.trace('action_info_category ' ||
2163: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
2164: hr_utility.trace('act_info1 IS ' ||
2165: pay_ac_action_arch.lrr_act_tab(i).act_info1);
2166: hr_utility.trace('act_info10 ' ||
2167: pay_ac_action_arch.lrr_act_tab(i).act_info10);

Line 2165: pay_ac_action_arch.lrr_act_tab(i).act_info1);

2161: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
2162: hr_utility.trace('action_info_category ' ||
2163: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
2164: hr_utility.trace('act_info1 IS ' ||
2165: pay_ac_action_arch.lrr_act_tab(i).act_info1);
2166: hr_utility.trace('act_info10 ' ||
2167: pay_ac_action_arch.lrr_act_tab(i).act_info10);
2168: hr_utility.trace('act_info3 ' ||
2169: pay_ac_action_arch.lrr_act_tab(i).act_info3);

Line 2167: pay_ac_action_arch.lrr_act_tab(i).act_info10);

2163: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
2164: hr_utility.trace('act_info1 IS ' ||
2165: pay_ac_action_arch.lrr_act_tab(i).act_info1);
2166: hr_utility.trace('act_info10 ' ||
2167: pay_ac_action_arch.lrr_act_tab(i).act_info10);
2168: hr_utility.trace('act_info3 ' ||
2169: pay_ac_action_arch.lrr_act_tab(i).act_info3);
2170: hr_utility.trace('act_info4 ' ||
2171: pay_ac_action_arch.lrr_act_tab(i).act_info4);

Line 2169: pay_ac_action_arch.lrr_act_tab(i).act_info3);

2165: pay_ac_action_arch.lrr_act_tab(i).act_info1);
2166: hr_utility.trace('act_info10 ' ||
2167: pay_ac_action_arch.lrr_act_tab(i).act_info10);
2168: hr_utility.trace('act_info3 ' ||
2169: pay_ac_action_arch.lrr_act_tab(i).act_info3);
2170: hr_utility.trace('act_info4 ' ||
2171: pay_ac_action_arch.lrr_act_tab(i).act_info4);
2172: hr_utility.trace('act_info5 ' ||
2173: pay_ac_action_arch.lrr_act_tab(i).act_info5);

Line 2171: pay_ac_action_arch.lrr_act_tab(i).act_info4);

2167: pay_ac_action_arch.lrr_act_tab(i).act_info10);
2168: hr_utility.trace('act_info3 ' ||
2169: pay_ac_action_arch.lrr_act_tab(i).act_info3);
2170: hr_utility.trace('act_info4 ' ||
2171: pay_ac_action_arch.lrr_act_tab(i).act_info4);
2172: hr_utility.trace('act_info5 ' ||
2173: pay_ac_action_arch.lrr_act_tab(i).act_info5);
2174: hr_utility.trace('act_info6 ' ||
2175: pay_ac_action_arch.lrr_act_tab(i).act_info6);

Line 2173: pay_ac_action_arch.lrr_act_tab(i).act_info5);

2169: pay_ac_action_arch.lrr_act_tab(i).act_info3);
2170: hr_utility.trace('act_info4 ' ||
2171: pay_ac_action_arch.lrr_act_tab(i).act_info4);
2172: hr_utility.trace('act_info5 ' ||
2173: pay_ac_action_arch.lrr_act_tab(i).act_info5);
2174: hr_utility.trace('act_info6 ' ||
2175: pay_ac_action_arch.lrr_act_tab(i).act_info6);
2176: hr_utility.trace('act_info7 ' ||
2177: pay_ac_action_arch.lrr_act_tab(i).act_info7);

Line 2175: pay_ac_action_arch.lrr_act_tab(i).act_info6);

2171: pay_ac_action_arch.lrr_act_tab(i).act_info4);
2172: hr_utility.trace('act_info5 ' ||
2173: pay_ac_action_arch.lrr_act_tab(i).act_info5);
2174: hr_utility.trace('act_info6 ' ||
2175: pay_ac_action_arch.lrr_act_tab(i).act_info6);
2176: hr_utility.trace('act_info7 ' ||
2177: pay_ac_action_arch.lrr_act_tab(i).act_info7);
2178: hr_utility.trace('act_info8 ' ||
2179: pay_ac_action_arch.lrr_act_tab(i).act_info8);

Line 2177: pay_ac_action_arch.lrr_act_tab(i).act_info7);

2173: pay_ac_action_arch.lrr_act_tab(i).act_info5);
2174: hr_utility.trace('act_info6 ' ||
2175: pay_ac_action_arch.lrr_act_tab(i).act_info6);
2176: hr_utility.trace('act_info7 ' ||
2177: pay_ac_action_arch.lrr_act_tab(i).act_info7);
2178: hr_utility.trace('act_info8 ' ||
2179: pay_ac_action_arch.lrr_act_tab(i).act_info8);
2180:
2181: END LOOP;

Line 2179: pay_ac_action_arch.lrr_act_tab(i).act_info8);

2175: pay_ac_action_arch.lrr_act_tab(i).act_info6);
2176: hr_utility.trace('act_info7 ' ||
2177: pay_ac_action_arch.lrr_act_tab(i).act_info7);
2178: hr_utility.trace('act_info8 ' ||
2179: pay_ac_action_arch.lrr_act_tab(i).act_info8);
2180:
2181: END LOOP;
2182: END IF;
2183:

Line 2956: ln_index := pay_ac_action_arch.lrr_act_tab.count;

2952: hr_utility.trace('lv_reporting_name : '||lv_reporting_name);
2953: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2954:
2955: ln_step := 10;
2956: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2957:
2958: hr_utility.trace('ln_index IS '
2959: || pay_ac_action_arch.lrr_act_tab.count);
2960:

Line 2959: || pay_ac_action_arch.lrr_act_tab.count);

2955: ln_step := 10;
2956: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2957:
2958: hr_utility.trace('ln_index IS '
2959: || pay_ac_action_arch.lrr_act_tab.count);
2960:
2961: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2962: := dbt(i).act_info_category;
2963: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

Line 2961: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

2957:
2958: hr_utility.trace('ln_index IS '
2959: || pay_ac_action_arch.lrr_act_tab.count);
2960:
2961: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2962: := dbt(i).act_info_category;
2963: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2964: := dbt(i).jurisdiction_cd;
2965: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

Line 2963: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

2959: || pay_ac_action_arch.lrr_act_tab.count);
2960:
2961: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2962: := dbt(i).act_info_category;
2963: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2964: := dbt(i).jurisdiction_cd;
2965: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2966: := p_xfr_action_id;
2967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

Line 2965: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

2961: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2962: := dbt(i).act_info_category;
2963: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2964: := dbt(i).jurisdiction_cd;
2965: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2966: := p_xfr_action_id;
2967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2968: := dbt(i).bal_type_id;
2969: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

Line 2967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

2963: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2964: := dbt(i).jurisdiction_cd;
2965: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2966: := p_xfr_action_id;
2967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2968: := dbt(i).bal_type_id;
2969: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2970: := fnd_number.number_to_canonical(ln_pymt_amount);
2971: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

Line 2969: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

2965: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2966: := p_xfr_action_id;
2967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2968: := dbt(i).bal_type_id;
2969: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2970: := fnd_number.number_to_canonical(ln_pymt_amount);
2971: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2972: := fnd_number.number_to_canonical(ln_ytd_amount);
2973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

Line 2971: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

2967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2968: := dbt(i).bal_type_id;
2969: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2970: := fnd_number.number_to_canonical(ln_pymt_amount);
2971: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2972: := fnd_number.number_to_canonical(ln_ytd_amount);
2973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2974: := lv_reporting_name;
2975:

Line 2973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

2969: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2970: := fnd_number.number_to_canonical(ln_pymt_amount);
2971: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2972: := fnd_number.number_to_canonical(ln_ytd_amount);
2973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2974: := lv_reporting_name;
2975:
2976: IF dbt(i).act_info_category = 'AC DEDUCTIONS' THEN
2977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16

Line 2977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16

2973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2974: := lv_reporting_name;
2975:
2976: IF dbt(i).act_info_category = 'AC DEDUCTIONS' THEN
2977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
2978: := 'Employee Taxes';
2979:
2980: END IF;
2981:

Line 2986: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;

2982:
2983: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2984:
2985: ln_step := 11;
2986: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2987: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2988: := dbt(i).jurisdiction_cd;
2989: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2990: := dbt(i).bal_name;

Line 2987: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code

2983: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2984:
2985: ln_step := 11;
2986: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2987: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2988: := dbt(i).jurisdiction_cd;
2989: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2990: := dbt(i).bal_name;
2991: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

Line 2989: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name

2985: ln_step := 11;
2986: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2987: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2988: := dbt(i).jurisdiction_cd;
2989: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2990: := dbt(i).bal_name;
2991: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2992: := dbt(i).bal_type_id;
2993:

Line 2991: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

2987: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2988: := dbt(i).jurisdiction_cd;
2989: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2990: := dbt(i).bal_name;
2991: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2992: := dbt(i).bal_type_id;
2993:
2994: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2995:

Line 3003: ln_index := pay_ac_action_arch.lrr_act_tab.count;

2999: END LOOP;
3000:
3001: IF p_pymt_balcall_aaid <> -999 THEN
3002:
3003: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3004:
3005: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3006: := 'MX SUMMARY CURRENT';
3007: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

Line 3005: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

3001: IF p_pymt_balcall_aaid <> -999 THEN
3002:
3003: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3004:
3005: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3006: := 'MX SUMMARY CURRENT';
3007: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3008: := fnd_number.number_to_canonical(ln_gross_earnings);
3009: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

Line 3007: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

3003: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3004:
3005: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3006: := 'MX SUMMARY CURRENT';
3007: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3008: := fnd_number.number_to_canonical(ln_gross_earnings);
3009: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3010: := fnd_number.number_to_canonical(ln_tax_deductions);
3011: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3

Line 3009: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

3005: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3006: := 'MX SUMMARY CURRENT';
3007: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3008: := fnd_number.number_to_canonical(ln_gross_earnings);
3009: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3010: := fnd_number.number_to_canonical(ln_tax_deductions);
3011: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3012: := fnd_number.number_to_canonical(ln_deductions);
3013: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512

Line 3011: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3

3007: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3008: := fnd_number.number_to_canonical(ln_gross_earnings);
3009: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3010: := fnd_number.number_to_canonical(ln_tax_deductions);
3011: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3012: := fnd_number.number_to_canonical(ln_deductions);
3013: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3014: := fnd_number.number_to_canonical(ln_net_pay);
3015:

Line 3013: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512

3009: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3010: := fnd_number.number_to_canonical(ln_tax_deductions);
3011: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3012: := fnd_number.number_to_canonical(ln_deductions);
3013: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3014: := fnd_number.number_to_canonical(ln_net_pay);
3015:
3016: END IF;
3017:

Line 3020: ln_index := pay_ac_action_arch.lrr_act_tab.count;

3016: END IF;
3017:
3018: hr_utility.set_location(gv_package || lv_procedure_name, 75);
3019:
3020: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3021:
3022: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3023: := 'MX SUMMARY YTD';
3024: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

Line 3022: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

3018: hr_utility.set_location(gv_package || lv_procedure_name, 75);
3019:
3020: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3021:
3022: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3023: := 'MX SUMMARY YTD';
3024: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3025: := fnd_number.number_to_canonical(ln_ytd_gross_earnings);
3026: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

Line 3024: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

3020: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3021:
3022: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3023: := 'MX SUMMARY YTD';
3024: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3025: := fnd_number.number_to_canonical(ln_ytd_gross_earnings);
3026: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3027: := fnd_number.number_to_canonical(ln_ytd_tax_deductions);
3028: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3

Line 3026: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

3022: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3023: := 'MX SUMMARY YTD';
3024: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3025: := fnd_number.number_to_canonical(ln_ytd_gross_earnings);
3026: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3027: := fnd_number.number_to_canonical(ln_ytd_tax_deductions);
3028: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3029: := fnd_number.number_to_canonical(ln_ytd_deductions);
3030: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512

Line 3028: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3

3024: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3025: := fnd_number.number_to_canonical(ln_ytd_gross_earnings);
3026: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3027: := fnd_number.number_to_canonical(ln_ytd_tax_deductions);
3028: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3029: := fnd_number.number_to_canonical(ln_ytd_deductions);
3030: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3031: := fnd_number.number_to_canonical(ln_ytd_net_pay);
3032:

Line 3030: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512

3026: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3027: := fnd_number.number_to_canonical(ln_ytd_tax_deductions);
3028: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3029: := fnd_number.number_to_canonical(ln_ytd_deductions);
3030: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3031: := fnd_number.number_to_canonical(ln_ytd_net_pay);
3032:
3033:
3034: hr_utility.set_location(gv_package || lv_procedure_name, 80);

Line 3386: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN

3382: BEGIN
3383: lv_procedure_name := '.populate_summary';
3384: ln_step := 1;
3385: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3386: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
3387: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3388:
3389: ln_step := 2;
3390: FOR i IN pay_ac_action_arch.lrr_act_tab.first ..

Line 3390: FOR i IN pay_ac_action_arch.lrr_act_tab.first ..

3386: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
3387: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3388:
3389: ln_step := 2;
3390: FOR i IN pay_ac_action_arch.lrr_act_tab.first ..
3391: pay_ac_action_arch.lrr_act_tab.last LOOP
3392:
3393: IF pay_ac_action_arch.lrr_act_tab(i).action_context_id
3394: = p_xfr_action_id THEN

Line 3391: pay_ac_action_arch.lrr_act_tab.last LOOP

3387: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3388:
3389: ln_step := 2;
3390: FOR i IN pay_ac_action_arch.lrr_act_tab.first ..
3391: pay_ac_action_arch.lrr_act_tab.last LOOP
3392:
3393: IF pay_ac_action_arch.lrr_act_tab(i).action_context_id
3394: = p_xfr_action_id THEN
3395: IF pay_ac_action_arch.lrr_act_tab(i).action_info_category

Line 3393: IF pay_ac_action_arch.lrr_act_tab(i).action_context_id

3389: ln_step := 2;
3390: FOR i IN pay_ac_action_arch.lrr_act_tab.first ..
3391: pay_ac_action_arch.lrr_act_tab.last LOOP
3392:
3393: IF pay_ac_action_arch.lrr_act_tab(i).action_context_id
3394: = p_xfr_action_id THEN
3395: IF pay_ac_action_arch.lrr_act_tab(i).action_info_category
3396: IN ('AC EARNINGS', 'AC DEDUCTIONS') THEN
3397:

Line 3395: IF pay_ac_action_arch.lrr_act_tab(i).action_info_category

3391: pay_ac_action_arch.lrr_act_tab.last LOOP
3392:
3393: IF pay_ac_action_arch.lrr_act_tab(i).action_context_id
3394: = p_xfr_action_id THEN
3395: IF pay_ac_action_arch.lrr_act_tab(i).action_info_category
3396: IN ('AC EARNINGS', 'AC DEDUCTIONS') THEN
3397:
3398: IF pay_ac_action_arch.lrr_act_tab(i).act_info16
3399: IN ('Employee Earnings',

Line 3398: IF pay_ac_action_arch.lrr_act_tab(i).act_info16

3394: = p_xfr_action_id THEN
3395: IF pay_ac_action_arch.lrr_act_tab(i).action_info_category
3396: IN ('AC EARNINGS', 'AC DEDUCTIONS') THEN
3397:
3398: IF pay_ac_action_arch.lrr_act_tab(i).act_info16
3399: IN ('Employee Earnings',
3400: 'Hourly Earnings',
3401: 'Taxable Benefits') THEN
3402:

Line 3406: IF pay_ac_action_arch.lrr_act_tab(i).act_info16

3402:
3403: -- Bug 4168970 - Imputed Earnings summed up separately
3404: -- to be used in calculating Net Pay.
3405: --
3406: IF pay_ac_action_arch.lrr_act_tab(i).act_info16
3407: = 'Taxable Benefits' THEN
3408:
3409: hr_utility.set_location(gv_package || lv_procedure_name, 25);
3410: lv_imputed_earnings :=

Line 3412: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);

3408:
3409: hr_utility.set_location(gv_package || lv_procedure_name, 25);
3410: lv_imputed_earnings :=
3411: lv_imputed_earnings +
3412: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);
3413:
3414: lv_ytd_imputed_earnings :=
3415: lv_ytd_imputed_earnings +
3416: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);

Line 3416: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);

3412: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);
3413:
3414: lv_ytd_imputed_earnings :=
3415: lv_ytd_imputed_earnings +
3416: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);
3417:
3418: END IF;
3419:
3420: hr_utility.set_location(gv_package || lv_procedure_name, 30);

Line 3424: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);

3420: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3421: ln_step := 3;
3422: lv_gross_earnings
3423: := lv_gross_earnings +
3424: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);
3425: lv_ytd_gross_earnings
3426: := lv_ytd_gross_earnings +
3427: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);
3428: ELSIF pay_ac_action_arch.lrr_act_tab(i).act_info16

Line 3427: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);

3423: := lv_gross_earnings +
3424: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);
3425: lv_ytd_gross_earnings
3426: := lv_ytd_gross_earnings +
3427: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);
3428: ELSIF pay_ac_action_arch.lrr_act_tab(i).act_info16
3429: = 'Employee Taxes' THEN
3430: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3431: ln_step := 4;

Line 3428: ELSIF pay_ac_action_arch.lrr_act_tab(i).act_info16

3424: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);
3425: lv_ytd_gross_earnings
3426: := lv_ytd_gross_earnings +
3427: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);
3428: ELSIF pay_ac_action_arch.lrr_act_tab(i).act_info16
3429: = 'Employee Taxes' THEN
3430: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3431: ln_step := 4;
3432: lv_tax_deductions

Line 3434: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);

3430: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3431: ln_step := 4;
3432: lv_tax_deductions
3433: := lv_tax_deductions +
3434: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);
3435: lv_ytd_tax_deductions
3436: := lv_ytd_tax_deductions +
3437: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);
3438: ELSIF pay_ac_action_arch.lrr_act_tab(i).act_info16

Line 3437: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);

3433: := lv_tax_deductions +
3434: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);
3435: lv_ytd_tax_deductions
3436: := lv_ytd_tax_deductions +
3437: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);
3438: ELSIF pay_ac_action_arch.lrr_act_tab(i).act_info16
3439: = 'Deductions' THEN
3440: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3441: ln_step := 5;

Line 3438: ELSIF pay_ac_action_arch.lrr_act_tab(i).act_info16

3434: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);
3435: lv_ytd_tax_deductions
3436: := lv_ytd_tax_deductions +
3437: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);
3438: ELSIF pay_ac_action_arch.lrr_act_tab(i).act_info16
3439: = 'Deductions' THEN
3440: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3441: ln_step := 5;
3442: lv_deductions

Line 3444: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);

3440: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3441: ln_step := 5;
3442: lv_deductions
3443: := lv_deductions +
3444: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);
3445: lv_ytd_deductions
3446: := lv_ytd_deductions +
3447: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);
3448: END IF;

Line 3447: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);

3443: := lv_deductions +
3444: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);
3445: lv_ytd_deductions
3446: := lv_ytd_deductions +
3447: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);
3448: END IF;
3449:
3450: END IF;
3451: END IF;

Line 3457: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN

3453: END IF;
3454:
3455: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3456: -- Insert one row for CURRENT and one for YTD
3457: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
3458: ln_step := 6;
3459: -- CURRENT
3460: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3461: hr_utility.trace('ln_index = ' || ln_index);

Line 3460: ln_index := pay_ac_action_arch.lrr_act_tab.count;

3456: -- Insert one row for CURRENT and one for YTD
3457: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
3458: ln_step := 6;
3459: -- CURRENT
3460: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3461: hr_utility.trace('ln_index = ' || ln_index);
3462: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3463: := 'MX SUMMARY CURRENT';
3464: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

Line 3462: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

3458: ln_step := 6;
3459: -- CURRENT
3460: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3461: hr_utility.trace('ln_index = ' || ln_index);
3462: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3463: := 'MX SUMMARY CURRENT';
3464: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3465: := fnd_number.number_to_canonical(lv_gross_earnings);
3466: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

Line 3464: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

3460: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3461: hr_utility.trace('ln_index = ' || ln_index);
3462: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3463: := 'MX SUMMARY CURRENT';
3464: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3465: := fnd_number.number_to_canonical(lv_gross_earnings);
3466: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3467: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3468: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3

Line 3466: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

3462: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3463: := 'MX SUMMARY CURRENT';
3464: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3465: := fnd_number.number_to_canonical(lv_gross_earnings);
3466: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3467: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3468: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3469: := fnd_number.number_to_canonical(lv_deductions);
3470: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512

Line 3468: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3

3464: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3465: := fnd_number.number_to_canonical(lv_gross_earnings);
3466: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3467: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3468: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3469: := fnd_number.number_to_canonical(lv_deductions);
3470: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3471: := fnd_number.number_to_canonical(lv_gross_earnings -
3472: -- Bug 4168970

Line 3470: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512

3466: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3467: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3468: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3469: := fnd_number.number_to_canonical(lv_deductions);
3470: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3471: := fnd_number.number_to_canonical(lv_gross_earnings -
3472: -- Bug 4168970
3473: lv_imputed_earnings -
3474: lv_tax_deductions -

Line 3480: ln_index := pay_ac_action_arch.lrr_act_tab.count;

3476:
3477:
3478: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3479: -- YTD
3480: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3481: hr_utility.trace('ln_index = ' || ln_index);
3482: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3483: := 'MX SUMMARY YTD';
3484: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

Line 3482: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

3478: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3479: -- YTD
3480: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3481: hr_utility.trace('ln_index = ' || ln_index);
3482: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3483: := 'MX SUMMARY YTD';
3484: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3485: := fnd_number.number_to_canonical(lv_ytd_gross_earnings);
3486: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

Line 3484: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

3480: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3481: hr_utility.trace('ln_index = ' || ln_index);
3482: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3483: := 'MX SUMMARY YTD';
3484: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3485: := fnd_number.number_to_canonical(lv_ytd_gross_earnings);
3486: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3487: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3488: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3

Line 3486: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

3482: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3483: := 'MX SUMMARY YTD';
3484: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3485: := fnd_number.number_to_canonical(lv_ytd_gross_earnings);
3486: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3487: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3488: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3489: := fnd_number.number_to_canonical(lv_ytd_deductions);
3490: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512

Line 3488: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3

3484: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3485: := fnd_number.number_to_canonical(lv_ytd_gross_earnings);
3486: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3487: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3488: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3489: := fnd_number.number_to_canonical(lv_ytd_deductions);
3490: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3491: := fnd_number.number_to_canonical(lv_ytd_gross_earnings -
3492: -- Bug 4168970

Line 3490: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512

3486: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3487: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3488: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3489: := fnd_number.number_to_canonical(lv_ytd_deductions);
3490: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3491: := fnd_number.number_to_canonical(lv_ytd_gross_earnings -
3492: -- Bug 4168970
3493: lv_ytd_imputed_earnings -
3494: lv_ytd_tax_deductions -

Line 3636: pay_ac_action_arch.get_last_xfr_info(

3632: CLOSE c_time_period;
3633:
3634: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3635: ln_step := 4;
3636: pay_ac_action_arch.get_last_xfr_info(
3637: p_assignment_id => p_assignment_id
3638: ,p_curr_effective_date => p_xfr_end_date
3639: ,p_action_info_category => 'EMPLOYEE DETAILS'
3640: ,p_xfr_action_id => p_xfr_action_id

Line 3688: pay_ac_action_arch.initialization_process;

3684: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
3685: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
3686:
3687: ln_step := 6;
3688: pay_ac_action_arch.initialization_process;
3689:
3690: IF p_archive_balance_info = 'Y' THEN
3691: ln_step := 7;
3692: populate_tax_and_summary( p_xfr_action_id => p_xfr_action_id

Line 3729: pay_ac_action_arch.get_last_pymt_info(

3725: );
3726:
3727: ELSE
3728: ln_step := 9;
3729: pay_ac_action_arch.get_last_pymt_info(
3730: p_assignment_id => p_assignment_id
3731: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
3732: ,p_last_pymt_eff_date => ld_last_pymt_eff_date
3733: ,p_last_pymt_action_id => ln_last_pymt_action_id);

Line 3820: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab

3816: ,p_action_context_type=> 'AAP'
3817: ,p_assignment_id => p_assignment_id
3818: ,p_tax_unit_id => p_tax_unit_id
3819: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
3820: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
3821: );
3822:
3823: hr_utility.set_location(gv_package || lv_procedure_name, 220);
3824: ln_step := 17;

Line 4619: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;

4615:
4616:
4617: IF NVL(ln_ytd_amount, 0) <> 0 THEN
4618: ln_step := 100;
4619: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
4620:
4621: hr_utility.trace('ln_element_index = '||ln_element_index);
4622:
4623: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name

Line 4623: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name

4619: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
4620:
4621: hr_utility.trace('ln_element_index = '||ln_element_index);
4622:
4623: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
4624: := lv_reporting_name;
4625: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4626: := ln_primary_balance_id;
4627: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id

Line 4625: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

4621: hr_utility.trace('ln_element_index = '||ln_element_index);
4622:
4623: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
4624: := lv_reporting_name;
4625: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4626: := ln_primary_balance_id;
4627: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
4628: := ln_hours_balance_id;
4629: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code

Line 4627: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id

4623: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
4624: := lv_reporting_name;
4625: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4626: := ln_primary_balance_id;
4627: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
4628: := ln_hours_balance_id;
4629: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
4630: := lv_jurisdiction_code;
4631:

Line 4629: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code

4625: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4626: := ln_primary_balance_id;
4627: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
4628: := ln_hours_balance_id;
4629: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
4630: := lv_jurisdiction_code;
4631:
4632:
4633: ln_index := pay_ac_action_arch.lrr_act_tab.count;

Line 4633: ln_index := pay_ac_action_arch.lrr_act_tab.count;

4629: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
4630: := lv_jurisdiction_code;
4631:
4632:
4633: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4634: hr_utility.trace('ln_index = '||ln_index);
4635: IF lv_attribute_name IN ('Employee Earnings', 'Hourly Earnings',
4636: 'Taxable Benefits') THEN
4637: hr_utility.set_location(gv_package || lv_procedure_name, 140);

Line 4644: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11

4640: hr_utility.trace('ln_ytd_hours = ' ||ln_ytd_hours);
4641: hr_utility.trace('ln_current_days = ' ||ln_current_days);
4642: hr_utility.trace('ln_ytd_days = ' ||ln_ytd_days);
4643: ln_step := 120;
4644: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4645: := fnd_number.number_to_canonical(ln_current_hours);
4646: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4647: := fnd_number.number_to_canonical(ln_ytd_hours);
4648: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14

Line 4646: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

4642: hr_utility.trace('ln_ytd_days = ' ||ln_ytd_days);
4643: ln_step := 120;
4644: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4645: := fnd_number.number_to_canonical(ln_current_hours);
4646: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4647: := fnd_number.number_to_canonical(ln_ytd_hours);
4648: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4649: := fnd_number.number_to_canonical(ln_current_days);
4650: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15

Line 4648: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14

4644: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4645: := fnd_number.number_to_canonical(ln_current_hours);
4646: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4647: := fnd_number.number_to_canonical(ln_ytd_hours);
4648: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4649: := fnd_number.number_to_canonical(ln_current_days);
4650: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
4651: := fnd_number.number_to_canonical(ln_ytd_days);
4652: ELSE

Line 4650: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15

4646: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4647: := fnd_number.number_to_canonical(ln_ytd_hours);
4648: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4649: := fnd_number.number_to_canonical(ln_current_days);
4650: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
4651: := fnd_number.number_to_canonical(ln_ytd_days);
4652: ELSE
4653: lv_action_category := 'AC DEDUCTIONS';
4654: END IF;

Line 4662: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

4658: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4659: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4660: ln_step := 130;
4661:
4662: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4663: := lv_action_category;
4664: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4665: := lv_jurisdiction_code;
4666: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

Line 4664: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

4660: ln_step := 130;
4661:
4662: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4663: := lv_action_category;
4664: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4665: := lv_jurisdiction_code;
4666: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4667: := p_xfr_action_id;
4668: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

Line 4666: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

4662: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4663: := lv_action_category;
4664: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4665: := lv_jurisdiction_code;
4666: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4667: := p_xfr_action_id;
4668: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4669: := ln_primary_balance_id;
4670: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

Line 4668: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

4664: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4665: := lv_jurisdiction_code;
4666: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4667: := p_xfr_action_id;
4668: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4669: := ln_primary_balance_id;
4670: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4671: := fnd_number.number_to_canonical(ln_payments_amount);
4672: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

Line 4670: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

4666: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4667: := p_xfr_action_id;
4668: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4669: := ln_primary_balance_id;
4670: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4671: := fnd_number.number_to_canonical(ln_payments_amount);
4672: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4673: := fnd_number.number_to_canonical(ln_ytd_amount);
4674: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

Line 4672: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

4668: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4669: := ln_primary_balance_id;
4670: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4671: := fnd_number.number_to_canonical(ln_payments_amount);
4672: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4673: := fnd_number.number_to_canonical(ln_ytd_amount);
4674: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4675: := lv_reporting_name;
4676:

Line 4674: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

4670: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4671: := fnd_number.number_to_canonical(ln_payments_amount);
4672: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4673: := fnd_number.number_to_canonical(ln_ytd_amount);
4674: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4675: := lv_reporting_name;
4676:
4677: END IF;
4678: hr_utility.set_location(gv_package || lv_procedure_name, 160);

Line 4702: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;

4698: );
4699:
4700: ln_step := 150;
4701: hr_utility.trace('------------Looping to see pl/sql table --------');
4702: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4703: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4704:
4705: hr_utility.trace('ln_check_count = '||ln_check_count);
4706: hr_utility.trace('ln_check_count2 = '||ln_check_count2);

Line 4703: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;

4699:
4700: ln_step := 150;
4701: hr_utility.trace('------------Looping to see pl/sql table --------');
4702: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4703: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4704:
4705: hr_utility.trace('ln_check_count = '||ln_check_count);
4706: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4707: hr_utility.trace('============= End of Processing '||p_assignment_id||

Line 5236: hr_utility.trace('pay_ac_action_arch.g_xfr_run_exists = '||

5232: END LOOP; -- c_payment_info
5233:
5234: CLOSE c_payment_info;
5235:
5236: hr_utility.trace('pay_ac_action_arch.g_xfr_run_exists = '||
5237: pay_ac_action_arch.g_xfr_run_exists );
5238:
5239: /***
5240: ** Removed cursor c_get_term_asg as it gets executed when

Line 5237: pay_ac_action_arch.g_xfr_run_exists );

5233:
5234: CLOSE c_payment_info;
5235:
5236: hr_utility.trace('pay_ac_action_arch.g_xfr_run_exists = '||
5237: pay_ac_action_arch.g_xfr_run_exists );
5238:
5239: /***
5240: ** Removed cursor c_get_term_asg as it gets executed when
5241: ** Multiple Payment is enabled for the payroll and it is not

Line 5256: pay_ac_action_arch.initialization_process;

5252: ln_pymt_balcall_aaid := ln_asg_action_id ;
5253: hr_utility.trace('Reversal ln_pymt_balcall_aaid'
5254: ||to_char(ln_pymt_balcall_aaid));
5255: ln_step := 25;
5256: pay_ac_action_arch.initialization_process;
5257:
5258: hr_utility.trace('Populating Tax Balances FOR Reversals');
5259: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
5260: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));

Line 5299: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab

5295: ,p_action_context_type=> 'AAP'
5296: ,p_assignment_id => ln_assignment_id
5297: ,p_tax_unit_id => ln_tax_unit_id
5298: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
5299: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
5300: );
5301:
5302: END IF; -- lv_master_action_type = 'V'
5303:

Line 5311: pay_ac_action_arch.initialization_process;

5307: IF lv_master_action_type = 'B' THEN
5308: hr_utility.trace('Populating Current Elements FOR Balance Adjustments');
5309: /* ln_asg_action_id is nothing but Balance Adjustment run action id */
5310: ln_asg_action_id := -1;
5311: pay_ac_action_arch.initialization_process;
5312:
5313: OPEN c_get_emp_adjbal(p_xfr_action_id);
5314: LOOP
5315: FETCH c_get_emp_adjbal INTO ln_asg_action_id;

Line 5358: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab

5354: ,p_action_context_type=> 'AAP'
5355: ,p_assignment_id => ln_assignment_id
5356: ,p_tax_unit_id => ln_tax_unit_id
5357: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
5358: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
5359: );
5360:
5361: END IF; -- master_action_type = 'B'
5362: