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_IP_PAYROLL_ARCH dependencies on PAY_AC_ACTION_ARCH

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

480: hr_utility.set_location(gv_package || lv_procedure_name, 30);
481: lv_is_element_archived := 'N';
482:
483: /*Checking whether the element is archived already*/
484: IF pay_ac_action_arch.lrr_act_tab.count <> 0 THEN
485: FOR i IN pay_ac_action_arch.lrr_act_tab.first..
486: pay_ac_action_arch.lrr_act_tab.last
487: LOOP
488: IF ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =

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

481: lv_is_element_archived := 'N';
482:
483: /*Checking whether the element is archived already*/
484: IF pay_ac_action_arch.lrr_act_tab.count <> 0 THEN
485: FOR i IN pay_ac_action_arch.lrr_act_tab.first..
486: pay_ac_action_arch.lrr_act_tab.last
487: LOOP
488: IF ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
489: p_xfr_action_id ) AND

Line 486: pay_ac_action_arch.lrr_act_tab.last

482:
483: /*Checking whether the element is archived already*/
484: IF pay_ac_action_arch.lrr_act_tab.count <> 0 THEN
485: FOR i IN pay_ac_action_arch.lrr_act_tab.first..
486: pay_ac_action_arch.lrr_act_tab.last
487: LOOP
488: IF ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
489: p_xfr_action_id ) AND
490: ( pay_ac_action_arch.lrr_act_tab(i).act_info6 =

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

484: IF pay_ac_action_arch.lrr_act_tab.count <> 0 THEN
485: FOR i IN pay_ac_action_arch.lrr_act_tab.first..
486: pay_ac_action_arch.lrr_act_tab.last
487: LOOP
488: IF ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
489: p_xfr_action_id ) AND
490: ( pay_ac_action_arch.lrr_act_tab(i).act_info6 =
491: p_primary_balance_id ) )
492: THEN

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

486: pay_ac_action_arch.lrr_act_tab.last
487: LOOP
488: IF ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
489: p_xfr_action_id ) AND
490: ( pay_ac_action_arch.lrr_act_tab(i).act_info6 =
491: p_primary_balance_id ) )
492: THEN
493: lv_is_element_archived := 'Y';
494: EXIT;

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

637: END IF; -- p_pymt_balcall_aaid is not NULL --if 5
638:
639: ln_step := 11;
640: IF NVL(ln_ytd_amount, 0) <> 0 OR NVL(ln_payments_amount, 0) <> 0 THEN --if 13
641: ln_index := pay_ac_action_arch.lrr_act_tab.count;
642:
643: IF p_element_classification IN ('Earnings',
644: 'Supplemental Earnings',
645: 'Taxable Benefits',

Line 650: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11

646: 'Employer Charges',
647: 'Direct Payment') THEN --if 14
648: hr_utility.set_location(gv_package || lv_procedure_name, 125);
649: lv_action_category := 'IP EARNINGS';
650: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
651: := fnd_number.number_to_canonical(ln_current_hours);
652: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
653: := fnd_number.number_to_canonical(ln_ytd_hours);
654: END IF; --if 14

Line 652: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

648: hr_utility.set_location(gv_package || lv_procedure_name, 125);
649: lv_action_category := 'IP EARNINGS';
650: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
651: := fnd_number.number_to_canonical(ln_current_hours);
652: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
653: := fnd_number.number_to_canonical(ln_ytd_hours);
654: END IF; --if 14
655:
656: hr_utility.set_location(gv_package || lv_procedure_name, 130);

Line 659: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

655:
656: hr_utility.set_location(gv_package || lv_procedure_name, 130);
657: /* Insert this into the plsql table if Current or YTD
658: amount is not Zero */
659: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
660: := lv_action_category;
661: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
662: := p_jurisdiction_code;
663: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

Line 661: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

657: /* Insert this into the plsql table if Current or YTD
658: amount is not Zero */
659: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
660: := lv_action_category;
661: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
662: := p_jurisdiction_code;
663: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
664: := p_xfr_action_id;
665: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

Line 663: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

659: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
660: := lv_action_category;
661: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
662: := p_jurisdiction_code;
663: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
664: := p_xfr_action_id;
665: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
666: := p_element_classification;
667: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

Line 665: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

661: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
662: := p_jurisdiction_code;
663: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
664: := p_xfr_action_id;
665: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
666: := p_element_classification;
667: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
668: := p_element_type_id;
669: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

Line 667: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

663: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
664: := p_xfr_action_id;
665: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
666: := p_element_classification;
667: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
668: := p_element_type_id;
669: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
670: := p_primary_balance_id;
671: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7

Line 669: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

665: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
666: := p_element_classification;
667: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
668: := p_element_type_id;
669: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
670: := p_primary_balance_id;
671: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
672: := p_processing_priority;
673: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

Line 671: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7

667: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
668: := p_element_type_id;
669: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
670: := p_primary_balance_id;
671: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
672: := p_processing_priority;
673: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
674: := fnd_number.number_to_canonical(ln_payments_amount);
675: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

Line 673: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

669: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
670: := p_primary_balance_id;
671: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
672: := p_processing_priority;
673: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
674: := fnd_number.number_to_canonical(ln_payments_amount);
675: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
676: := fnd_number.number_to_canonical(ln_ytd_amount);
677: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

Line 675: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

671: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
672: := p_processing_priority;
673: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
674: := fnd_number.number_to_canonical(ln_payments_amount);
675: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
676: := fnd_number.number_to_canonical(ln_ytd_amount);
677: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
678: := p_reporting_name;
679:

Line 677: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

673: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
674: := fnd_number.number_to_canonical(ln_payments_amount);
675: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
676: := fnd_number.number_to_canonical(ln_ytd_amount);
677: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
678: := p_reporting_name;
679:
680: END IF; --if 13
681: END IF; -- lv_is_element_archived = 'N' --if 1

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

855:
856: ln_step := 4;
857: hr_utility.trace('Missing ln_primary_balance_id '||ln_primary_balance_id);
858: /*Checking whether element is present in current run*/
859: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
860: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
861: pay_ac_action_arch.emp_elements_tab.last LOOP
862: IF pay_ac_action_arch.emp_elements_tab(i).element_type_id
863: = ln_element_type_id THEN

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

856: ln_step := 4;
857: hr_utility.trace('Missing ln_primary_balance_id '||ln_primary_balance_id);
858: /*Checking whether element is present in current run*/
859: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
860: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
861: pay_ac_action_arch.emp_elements_tab.last LOOP
862: IF pay_ac_action_arch.emp_elements_tab(i).element_type_id
863: = ln_element_type_id THEN
864: lv_is_element_archived := 'Y';

Line 861: pay_ac_action_arch.emp_elements_tab.last LOOP

857: hr_utility.trace('Missing ln_primary_balance_id '||ln_primary_balance_id);
858: /*Checking whether element is present in current run*/
859: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
860: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
861: pay_ac_action_arch.emp_elements_tab.last LOOP
862: IF pay_ac_action_arch.emp_elements_tab(i).element_type_id
863: = ln_element_type_id THEN
864: lv_is_element_archived := 'Y';
865: hr_utility.set_location(gv_package || lv_procedure_name, 30);

Line 862: IF pay_ac_action_arch.emp_elements_tab(i).element_type_id

858: /*Checking whether element is present in current run*/
859: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
860: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
861: pay_ac_action_arch.emp_elements_tab.last LOOP
862: IF pay_ac_action_arch.emp_elements_tab(i).element_type_id
863: = ln_element_type_id THEN
864: lv_is_element_archived := 'Y';
865: hr_utility.set_location(gv_package || lv_procedure_name, 30);
866: hr_utility.trace('lv_is_element_archived YES '||lv_is_element_archived);

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

873: IF lv_is_element_archived = 'N' THEN
874: hr_utility.trace('lv_is_element_archived NO '||lv_is_element_archived);
875: /* populate the extra element table */
876: ln_step := 6;
877: ln_index := pay_ac_action_arch.emp_elements_tab.count;
878: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
879: := ln_primary_balance_id;
880: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
881: := lv_reporting_name;

Line 878: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id

874: hr_utility.trace('lv_is_element_archived NO '||lv_is_element_archived);
875: /* populate the extra element table */
876: ln_step := 6;
877: ln_index := pay_ac_action_arch.emp_elements_tab.count;
878: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
879: := ln_primary_balance_id;
880: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
881: := lv_reporting_name;
882: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id

Line 880: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name

876: ln_step := 6;
877: ln_index := pay_ac_action_arch.emp_elements_tab.count;
878: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
879: := ln_primary_balance_id;
880: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
881: := lv_reporting_name;
882: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
883: := ln_hours_balance_id;
884: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id

Line 882: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id

878: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
879: := ln_primary_balance_id;
880: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
881: := lv_reporting_name;
882: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
883: := ln_hours_balance_id;
884: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
885: := ln_element_type_id;
886: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code

Line 884: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id

880: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
881: := lv_reporting_name;
882: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
883: := ln_hours_balance_id;
884: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
885: := ln_element_type_id;
886: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
887: := lv_jurisdiction_code;
888:

Line 886: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code

882: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
883: := ln_hours_balance_id;
884: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
885: := ln_element_type_id;
886: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
887: := lv_jurisdiction_code;
888:
889: ln_step := 7;
890: ln_ytd_defined_balance_id :=

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

940: hr_utility.set_location(gv_package || lv_procedure_name, 100);
941: ln_step := 9;
942: IF NVL(ln_ytd_amount, 0) <> 0 OR NVL(ln_payments_amount, 0) <> 0 THEN
943:
944: ln_index := pay_ac_action_arch.lrr_act_tab.count;
945: hr_utility.trace('ln_index = ' || ln_index);
946:
947: IF lv_element_classification_name IN ('Earnings','Supplemental Earnings','Direct Payment',
948: 'Taxable Benefits','Employer Charges') THEN

Line 951: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

947: IF lv_element_classification_name IN ('Earnings','Supplemental Earnings','Direct Payment',
948: 'Taxable Benefits','Employer Charges') THEN
949:
950: lv_action_info_category := 'IP EARNINGS';
951: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
952: := fnd_number.number_to_canonical(ln_ytd_hours);
953: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
954: :='0'; /*Current Hours will always be zero as we only archive YTD amounts of missing elements*/
955:

Line 953: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11

949:
950: lv_action_info_category := 'IP EARNINGS';
951: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
952: := fnd_number.number_to_canonical(ln_ytd_hours);
953: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
954: :='0'; /*Current Hours will always be zero as we only archive YTD amounts of missing elements*/
955:
956: END IF;
957:

Line 959: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

955:
956: END IF;
957:
958: ln_step := 10;
959: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
960: := lv_action_info_category;
961: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
962: := lv_jurisdiction_code;
963: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

Line 961: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

957:
958: ln_step := 10;
959: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
960: := lv_action_info_category;
961: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
962: := lv_jurisdiction_code;
963: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
964: := p_xfr_action_id ;
965: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

Line 963: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

959: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
960: := lv_action_info_category;
961: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
962: := lv_jurisdiction_code;
963: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
964: := p_xfr_action_id ;
965: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
966: := lv_element_classification_name;
967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

Line 965: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

961: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
962: := lv_jurisdiction_code;
963: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
964: := p_xfr_action_id ;
965: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
966: := lv_element_classification_name;
967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
968: := ln_element_type_id;
969: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

Line 967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

963: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
964: := p_xfr_action_id ;
965: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
966: := lv_element_classification_name;
967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
968: := ln_element_type_id;
969: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
970: := ln_primary_balance_id;
971: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7

Line 969: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

965: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
966: := lv_element_classification_name;
967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
968: := ln_element_type_id;
969: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
970: := ln_primary_balance_id;
971: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
972: := ln_processing_priority;
973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

Line 971: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7

967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
968: := ln_element_type_id;
969: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
970: := ln_primary_balance_id;
971: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
972: := ln_processing_priority;
973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
974: := fnd_number.number_to_canonical(ln_payments_amount);
975: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

Line 973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

969: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
970: := ln_primary_balance_id;
971: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
972: := ln_processing_priority;
973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
974: := fnd_number.number_to_canonical(ln_payments_amount);
975: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
976: := fnd_number.number_to_canonical(ln_ytd_amount);
977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

Line 975: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

971: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
972: := ln_processing_priority;
973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
974: := fnd_number.number_to_canonical(ln_payments_amount);
975: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
976: := fnd_number.number_to_canonical(ln_ytd_amount);
977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
978: := lv_reporting_name;
979:

Line 977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
974: := fnd_number.number_to_canonical(ln_payments_amount);
975: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
976: := fnd_number.number_to_canonical(ln_ytd_amount);
977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
978: := lv_reporting_name;
979:
980: END IF;
981: END IF;

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

1200: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);
1201: hr_utility.trace('ln_assignment_id (prev) = '||ln_assignment_id);
1202:
1203: IF ln_assignment_id = p_assignment_id THEN
1204: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
1205: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
1206: pay_ac_action_arch.emp_elements_tab.last LOOP
1207: IF pay_ac_action_arch.emp_elements_tab(i).element_type_id
1208: = ln_element_type_id THEN

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

1201: hr_utility.trace('ln_assignment_id (prev) = '||ln_assignment_id);
1202:
1203: IF ln_assignment_id = p_assignment_id THEN
1204: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
1205: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
1206: pay_ac_action_arch.emp_elements_tab.last LOOP
1207: IF pay_ac_action_arch.emp_elements_tab(i).element_type_id
1208: = ln_element_type_id THEN
1209: lv_is_element_archived := 'Y';

Line 1206: pay_ac_action_arch.emp_elements_tab.last LOOP

1202:
1203: IF ln_assignment_id = p_assignment_id THEN
1204: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
1205: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
1206: pay_ac_action_arch.emp_elements_tab.last LOOP
1207: IF pay_ac_action_arch.emp_elements_tab(i).element_type_id
1208: = ln_element_type_id THEN
1209: lv_is_element_archived := 'Y';
1210: EXIT;

Line 1207: IF pay_ac_action_arch.emp_elements_tab(i).element_type_id

1203: IF ln_assignment_id = p_assignment_id THEN
1204: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
1205: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
1206: pay_ac_action_arch.emp_elements_tab.last LOOP
1207: IF pay_ac_action_arch.emp_elements_tab(i).element_type_id
1208: = ln_element_type_id THEN
1209: lv_is_element_archived := 'Y';
1210: EXIT;
1211: END IF;

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

1249:
1250: ln_step := 7;
1251: IF lv_is_element_archived = 'N' THEN
1252: /* populate the extra element table */
1253: ln_index := pay_ac_action_arch.emp_elements_tab.count;
1254: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
1255: := lv_jurisdiction_code;
1256: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
1257: := ln_primary_balance_id;

Line 1254: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code

1250: ln_step := 7;
1251: IF lv_is_element_archived = 'N' THEN
1252: /* populate the extra element table */
1253: ln_index := pay_ac_action_arch.emp_elements_tab.count;
1254: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
1255: := lv_jurisdiction_code;
1256: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
1257: := ln_primary_balance_id;
1258: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name

Line 1256: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id

1252: /* populate the extra element table */
1253: ln_index := pay_ac_action_arch.emp_elements_tab.count;
1254: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
1255: := lv_jurisdiction_code;
1256: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
1257: := ln_primary_balance_id;
1258: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
1259: := lv_reporting_name;
1260: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id

Line 1258: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name

1254: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
1255: := lv_jurisdiction_code;
1256: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
1257: := ln_primary_balance_id;
1258: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
1259: := lv_reporting_name;
1260: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
1261: := ln_hours_balance_id;
1262: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id

Line 1260: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id

1256: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
1257: := ln_primary_balance_id;
1258: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
1259: := lv_reporting_name;
1260: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
1261: := ln_hours_balance_id;
1262: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
1263: := ln_element_type_id;
1264:

Line 1262: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id

1258: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
1259: := lv_reporting_name;
1260: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
1261: := ln_hours_balance_id;
1262: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
1263: := ln_element_type_id;
1264:
1265: ln_step := 8;
1266: ln_ytd_defined_balance_id

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

1316:
1317: IF NVL(ln_ytd_amount, 0) >0 OR NVL(ln_payments_amount, 0) >0 THEN
1318:
1319: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1320: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1321: hr_utility.trace('ln_index = ' || ln_index);
1322: ln_step := 11;
1323: IF lv_element_classification_name IN ('Earnings',
1324: 'Supplemental Earnings','Direct Payment',

Line 1327: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

1323: IF lv_element_classification_name IN ('Earnings',
1324: 'Supplemental Earnings','Direct Payment',
1325: 'Taxable Benefits','Employer Charges') THEN
1326: lv_action_info_category := 'IP EARNINGS';
1327: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1328: := fnd_number.number_to_canonical(ln_ytd_hours);
1329: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1330: := fnd_number.number_to_canonical(0);
1331:

Line 1329: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11

1325: 'Taxable Benefits','Employer Charges') THEN
1326: lv_action_info_category := 'IP EARNINGS';
1327: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1328: := fnd_number.number_to_canonical(ln_ytd_hours);
1329: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1330: := fnd_number.number_to_canonical(0);
1331:
1332: END IF;
1333:

Line 1334: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

1330: := fnd_number.number_to_canonical(0);
1331:
1332: END IF;
1333:
1334: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1335: := lv_action_info_category;
1336: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1337: := lv_jurisdiction_code;
1338: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

Line 1336: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

1332: END IF;
1333:
1334: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1335: := lv_action_info_category;
1336: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1337: := lv_jurisdiction_code;
1338: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1339: := p_xfr_action_id;
1340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

Line 1338: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

1334: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1335: := lv_action_info_category;
1336: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1337: := lv_jurisdiction_code;
1338: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1339: := p_xfr_action_id;
1340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1341: := lv_element_classification_name;
1342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

Line 1340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

1336: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1337: := lv_jurisdiction_code;
1338: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1339: := p_xfr_action_id;
1340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1341: := lv_element_classification_name;
1342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1343: := ln_element_type_id;
1344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

Line 1342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

1338: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1339: := p_xfr_action_id;
1340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1341: := lv_element_classification_name;
1342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1343: := ln_element_type_id;
1344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1345: := ln_primary_balance_id;
1346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7

Line 1344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

1340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1341: := lv_element_classification_name;
1342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1343: := ln_element_type_id;
1344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1345: := ln_primary_balance_id;
1346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1347: := ln_processing_priority;
1348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

Line 1346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7

1342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1343: := ln_element_type_id;
1344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1345: := ln_primary_balance_id;
1346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1347: := ln_processing_priority;
1348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1349: := fnd_number.number_to_canonical(ln_payments_amount);
1350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

Line 1348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

1344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1345: := ln_primary_balance_id;
1346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1347: := ln_processing_priority;
1348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1349: := fnd_number.number_to_canonical(ln_payments_amount);
1350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1351: := fnd_number.number_to_canonical(ln_ytd_amount);
1352: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

Line 1350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

1346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1347: := ln_processing_priority;
1348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1349: := fnd_number.number_to_canonical(ln_payments_amount);
1350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1351: := fnd_number.number_to_canonical(ln_ytd_amount);
1352: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1353: := lv_reporting_name;
1354: END IF;

Line 1352: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

1348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1349: := fnd_number.number_to_canonical(ln_payments_amount);
1350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1351: := fnd_number.number_to_canonical(ln_ytd_amount);
1352: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1353: := lv_reporting_name;
1354: END IF;
1355: END IF;
1356: ln_step := 12;

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

1615: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1616: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
1617:
1618: ln_step := 6;
1619: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
1620: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
1621: := ln_primary_balance_id;
1622: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
1623: := lv_reporting_name;

Line 1620: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

1616: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
1617:
1618: ln_step := 6;
1619: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
1620: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
1621: := ln_primary_balance_id;
1622: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
1623: := lv_reporting_name;
1624: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id

Line 1622: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name

1618: ln_step := 6;
1619: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
1620: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
1621: := ln_primary_balance_id;
1622: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
1623: := lv_reporting_name;
1624: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
1625: := ln_hours_balance_id;
1626: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id

Line 1624: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id

1620: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
1621: := ln_primary_balance_id;
1622: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
1623: := lv_reporting_name;
1624: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
1625: := ln_hours_balance_id;
1626: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
1627: := ln_element_type_id;
1628:

Line 1626: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id

1622: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
1623: := lv_reporting_name;
1624: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
1625: := ln_hours_balance_id;
1626: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
1627: := ln_element_type_id;
1628:
1629: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1630: ln_step := 7;

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

2172: ** check whether the element has already been archived in this run itself
2173: **. If it has been archived,skip the element
2174: **********************************************************/
2175: ln_step := 4;
2176: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
2177: FOR i IN pay_ac_action_arch.emp_elements_tab.first ..
2178: pay_ac_action_arch.emp_elements_tab.last LOOP
2179:
2180: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id

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

2173: **. If it has been archived,skip the element
2174: **********************************************************/
2175: ln_step := 4;
2176: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
2177: FOR i IN pay_ac_action_arch.emp_elements_tab.first ..
2178: pay_ac_action_arch.emp_elements_tab.last LOOP
2179:
2180: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
2181: = ln_primary_balance_id THEN

Line 2178: pay_ac_action_arch.emp_elements_tab.last LOOP

2174: **********************************************************/
2175: ln_step := 4;
2176: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
2177: FOR i IN pay_ac_action_arch.emp_elements_tab.first ..
2178: pay_ac_action_arch.emp_elements_tab.last LOOP
2179:
2180: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
2181: = ln_primary_balance_id THEN
2182:

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

2176: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
2177: FOR i IN pay_ac_action_arch.emp_elements_tab.first ..
2178: pay_ac_action_arch.emp_elements_tab.last LOOP
2179:
2180: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
2181: = ln_primary_balance_id THEN
2182:
2183: hr_utility.set_location(gv_package || lv_procedure_name, 65);
2184: lv_is_element_archived := 'Y';

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

2189:
2190: IF lv_is_element_archived = 'N' THEN
2191: ln_step := 5;
2192: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2193: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2194: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2195: := lv_reporting_name;
2196: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2197: := ln_primary_balance_id;

Line 2194: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name

2190: IF lv_is_element_archived = 'N' THEN
2191: ln_step := 5;
2192: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2193: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2194: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2195: := lv_reporting_name;
2196: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2197: := ln_primary_balance_id;
2198: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id

Line 2196: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

2192: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2193: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2194: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2195: := lv_reporting_name;
2196: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2197: := ln_primary_balance_id;
2198: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2199: := ln_hours_balance_id;
2200: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id

Line 2198: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id

2194: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2195: := lv_reporting_name;
2196: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2197: := ln_primary_balance_id;
2198: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2199: := ln_hours_balance_id;
2200: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
2201: := ln_element_type_id;
2202: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code

Line 2200: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id

2196: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2197: := ln_primary_balance_id;
2198: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2199: := ln_hours_balance_id;
2200: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
2201: := ln_element_type_id;
2202: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2203: := lv_jurisdiction_code;
2204:

Line 2202: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code

2198: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2199: := ln_hours_balance_id;
2200: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
2201: := ln_element_type_id;
2202: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2203: := lv_jurisdiction_code;
2204:
2205: /*****************************************************************
2206: ** The Payment Assignemnt Action is not passed to this procedure

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

2987: hr_utility.trace('lv_reporting_name : '||lv_reporting_name);
2988: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2989:
2990: ln_step := 5;
2991: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2992:
2993: hr_utility.trace('ln_index IS '
2994: || pay_ac_action_arch.lrr_act_tab.count);
2995:

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

2990: ln_step := 5;
2991: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2992:
2993: hr_utility.trace('ln_index IS '
2994: || pay_ac_action_arch.lrr_act_tab.count);
2995:
2996: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2997: := dbt(i).act_info_category;
2998: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

Line 2996: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

2992:
2993: hr_utility.trace('ln_index IS '
2994: || pay_ac_action_arch.lrr_act_tab.count);
2995:
2996: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2997: := dbt(i).act_info_category;
2998: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2999: := NULL;
3000: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

Line 2998: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

2994: || pay_ac_action_arch.lrr_act_tab.count);
2995:
2996: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2997: := dbt(i).act_info_category;
2998: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2999: := NULL;
3000: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3001: := p_xfr_action_id;
3002: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

Line 3000: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

2996: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2997: := dbt(i).act_info_category;
2998: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2999: := NULL;
3000: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3001: := p_xfr_action_id;
3002: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3003: := dbt(i).bal_type_id;
3004: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

Line 3002: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

2998: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2999: := NULL;
3000: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3001: := p_xfr_action_id;
3002: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3003: := dbt(i).bal_type_id;
3004: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3005: := dbt(i).def_bal_id;
3006: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4

Line 3004: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

3000: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3001: := p_xfr_action_id;
3002: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3003: := dbt(i).bal_type_id;
3004: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3005: := dbt(i).def_bal_id;
3006: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3007: := dbt(i).dimension;
3008: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5

Line 3006: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4

3002: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3003: := dbt(i).bal_type_id;
3004: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3005: := dbt(i).def_bal_id;
3006: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3007: := dbt(i).dimension;
3008: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3009: := fnd_number.number_to_canonical(ln_amount);
3010: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7

Line 3008: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5

3004: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3005: := dbt(i).def_bal_id;
3006: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3007: := dbt(i).dimension;
3008: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3009: := fnd_number.number_to_canonical(ln_amount);
3010: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3011: := lv_reporting_name;
3012: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16

Line 3010: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7

3006: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3007: := dbt(i).dimension;
3008: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3009: := fnd_number.number_to_canonical(ln_amount);
3010: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3011: := lv_reporting_name;
3012: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
3013: := dbt(i).attribute_name;
3014:

Line 3012: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16

3008: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3009: := fnd_number.number_to_canonical(ln_amount);
3010: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3011: := lv_reporting_name;
3012: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
3013: := dbt(i).attribute_name;
3014:
3015: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3016:

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

3014:
3015: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3016:
3017: ln_step := 6;
3018: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3019: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3020: := NULL;
3021: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3022: := dbt(i).bal_name;

Line 3019: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code

3015: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3016:
3017: ln_step := 6;
3018: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3019: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3020: := NULL;
3021: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3022: := dbt(i).bal_name;
3023: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

Line 3021: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name

3017: ln_step := 6;
3018: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3019: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3020: := NULL;
3021: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3022: := dbt(i).bal_name;
3023: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3024: := dbt(i).bal_type_id;
3025:

Line 3023: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

3019: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3020: := NULL;
3021: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3022: := dbt(i).bal_name;
3023: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3024: := dbt(i).bal_type_id;
3025:
3026: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3027:

Line 3811: pay_ac_action_arch.get_last_xfr_info(

3807: ln_step := 4;
3808: /* Get last archiver assignment ation and last archiver effective date
3809: If Archiver is running for the first time then ld_last_xfr_eff_date and ln_last_xfr_action_id are null */
3810:
3811: pay_ac_action_arch.get_last_xfr_info(
3812: p_assignment_id => p_assignment_id
3813: ,p_curr_effective_date => p_xfr_end_date
3814: ,p_action_info_category => 'EMPLOYEE DETAILS'
3815: ,p_xfr_action_id => p_xfr_action_id

Line 3868: pay_ac_action_arch.initialization_process;

3864: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
3865: hr_utility.trace('p_business_grp_id = ' || p_business_grp_id);
3866:
3867: ln_step := 6;
3868: pay_ac_action_arch.initialization_process;
3869:
3870: OPEN c_time_period(p_payment_action_id);
3871:
3872: IF p_archive_balance_info = 'Y' THEN

Line 3960: pay_ac_action_arch.get_last_pymt_info(

3956:
3957: ELSE
3958: ln_step := 9;
3959: hr_utility.trace('Step 9:p_curr_pymt_eff_date ='||p_curr_pymt_eff_date);
3960: pay_ac_action_arch.get_last_pymt_info(
3961: p_assignment_id => p_assignment_id
3962: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
3963: ,p_last_pymt_eff_date => ld_last_pymt_eff_date
3964: ,p_last_pymt_action_id => ln_last_pymt_action_id);

Line 4073: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab

4069: ,p_action_context_type=> 'AAP'
4070: ,p_assignment_id => p_assignment_id
4071: ,p_tax_unit_id => p_tax_unit_id
4072: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
4073: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
4074: );
4075:
4076: hr_utility.set_location(gv_package || lv_procedure_name, 220);
4077: ln_step := 17;

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

4632: END LOOP; -- c_payment_info
4633:
4634: CLOSE c_payment_info;
4635:
4636: hr_utility.trace('pay_ac_action_arch.g_xfr_run_exists = '||
4637: pay_ac_action_arch.g_xfr_run_exists );
4638: hr_utility.set_location(gv_package || lv_procedure_name, 110);
4639:
4640: END IF; /* P,U */

Line 4637: pay_ac_action_arch.g_xfr_run_exists );

4633:
4634: CLOSE c_payment_info;
4635:
4636: hr_utility.trace('pay_ac_action_arch.g_xfr_run_exists = '||
4637: pay_ac_action_arch.g_xfr_run_exists );
4638: hr_utility.set_location(gv_package || lv_procedure_name, 110);
4639:
4640: END IF; /* P,U */
4641:

Line 4649: pay_ac_action_arch.initialization_process;

4645: hr_utility.trace('Populating Current Elements FOR Balance Adjustments');
4646: /* ln_asg_action_id is nothing but Balance Adjustment run action id */
4647: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4648: ln_asg_action_id := -1;
4649: pay_ac_action_arch.initialization_process;
4650:
4651: OPEN c_get_emp_adjbal(p_xfr_action_id);
4652: LOOP
4653: FETCH c_get_emp_adjbal INTO ln_asg_action_id;

Line 4697: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab

4693: ,p_action_context_type=> 'AAP'
4694: ,p_assignment_id => ln_assignment_id
4695: ,p_tax_unit_id => ln_tax_unit_id
4696: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
4697: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
4698: );
4699:
4700: END IF; -- master_action_type = 'B'
4701: