[Home] [Help]
1: PACKAGE BODY PAY_AC_ACTION_ARCH AS
2: /* $Header: pyacxfrp.pkb 120.62.12020000.18 2013/05/03 09:09:02 pkoduri ship $ */
3: /*
4: ******************************************************************
5: * *
16: * 500 Oracle Parkway, Redwood City, US, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_ac_action_arch
21:
22: Change List
23: -----------
24: Date Name Vers Bug No Description
410:
411: /******************************************************************
412: ** Package Local Variables
413: ******************************************************************/
414: gv_package VARCHAR2(100) := 'pay_ac_action_arch';
415:
416: gv_dim_asg_tg_ytd VARCHAR2(100) := '_ASG_TG_YTD';
417: gv_dim_asg_gre_ytd VARCHAR2(100) := '_ASG_GRE_YTD';
418: gv_dim_asg_jd_gre_ytd VARCHAR2(100) := '_ASG_JD_GRE_YTD';
562:
563: /******************************************************************
564: Name : initialization_process
565: Purpose : The procedure initializes the PL/SQL table -
566: pay_ac_action_arch.lrr_act_tab
567: Arguments :
568: Notes :
569: ******************************************************************/
570: PROCEDURE initialization_process
585: BEGIN
586: hr_utility.set_location(gv_package || lv_procedure_name, 10);
587: ln_step := 1;
588:
589: if pay_ac_action_arch.lrr_act_tab.count > 0 then
590: for i in pay_ac_action_arch.lrr_act_tab.first ..
591: pay_ac_action_arch.lrr_act_tab.last loop
592: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
593: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
586: hr_utility.set_location(gv_package || lv_procedure_name, 10);
587: ln_step := 1;
588:
589: if pay_ac_action_arch.lrr_act_tab.count > 0 then
590: for i in pay_ac_action_arch.lrr_act_tab.first ..
591: pay_ac_action_arch.lrr_act_tab.last loop
592: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
593: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
594: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
587: ln_step := 1;
588:
589: if pay_ac_action_arch.lrr_act_tab.count > 0 then
590: for i in pay_ac_action_arch.lrr_act_tab.first ..
591: pay_ac_action_arch.lrr_act_tab.last loop
592: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
593: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
594: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
595: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
588:
589: if pay_ac_action_arch.lrr_act_tab.count > 0 then
590: for i in pay_ac_action_arch.lrr_act_tab.first ..
591: pay_ac_action_arch.lrr_act_tab.last loop
592: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
593: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
594: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
595: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
596: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
589: if pay_ac_action_arch.lrr_act_tab.count > 0 then
590: for i in pay_ac_action_arch.lrr_act_tab.first ..
591: pay_ac_action_arch.lrr_act_tab.last loop
592: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
593: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
594: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
595: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
596: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
597: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
590: for i in pay_ac_action_arch.lrr_act_tab.first ..
591: pay_ac_action_arch.lrr_act_tab.last loop
592: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
593: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
594: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
595: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
596: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
597: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
598: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
591: pay_ac_action_arch.lrr_act_tab.last loop
592: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
593: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
594: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
595: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
596: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
597: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
598: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
599: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
592: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
593: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
594: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
595: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
596: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
597: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
598: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
599: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
600: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
593: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
594: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
595: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
596: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
597: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
598: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
599: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
600: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
601: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
594: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
595: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
596: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
597: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
598: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
599: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
600: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
601: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
602: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
595: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
596: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
597: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
598: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
599: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
600: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
601: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
602: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
603: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
596: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
597: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
598: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
599: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
600: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
601: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
602: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
603: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
604: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
597: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
598: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
599: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
600: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
601: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
602: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
603: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
604: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
605: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
598: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
599: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
600: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
601: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
602: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
603: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
604: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
605: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
606: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
599: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
600: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
601: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
602: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
603: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
604: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
605: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
606: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
607: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
600: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
601: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
602: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
603: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
604: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
605: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
606: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
607: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
608: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
601: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
602: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
603: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
604: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
605: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
606: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
607: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
608: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
609: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
602: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
603: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
604: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
605: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
606: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
607: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
608: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
609: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
610: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
603: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
604: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
605: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
606: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
607: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
608: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
609: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
610: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
611: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
604: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
605: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
606: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
607: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
608: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
609: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
610: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
611: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
612: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
605: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
606: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
607: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
608: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
609: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
610: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
611: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
612: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
613: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
606: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
607: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
608: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
609: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
610: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
611: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
612: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
613: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
614: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
607: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
608: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
609: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
610: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
611: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
612: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
613: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
614: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
615: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
608: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
609: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
610: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
611: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
612: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
613: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
614: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
615: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
616: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
609: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
610: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
611: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
612: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
613: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
614: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
615: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
616: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
617: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
610: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
611: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
612: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
613: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
614: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
615: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
616: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
617: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
618: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
611: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
612: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
613: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
614: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
615: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
616: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
617: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
618: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
619: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
612: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
613: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
614: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
615: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
616: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
617: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
618: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
619: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
620: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
613: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
614: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
615: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
616: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
617: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
618: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
619: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
620: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
621: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
614: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
615: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
616: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
617: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
618: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
619: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
620: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
621: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
622: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
615: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
616: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
617: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
618: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
619: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
620: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
621: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
622: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
623: pay_ac_action_arch.lrr_act_tab(i).act_info28 := null;
616: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
617: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
618: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
619: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
620: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
621: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
622: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
623: pay_ac_action_arch.lrr_act_tab(i).act_info28 := null;
624: pay_ac_action_arch.lrr_act_tab(i).act_info29 := null;
617: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
618: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
619: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
620: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
621: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
622: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
623: pay_ac_action_arch.lrr_act_tab(i).act_info28 := null;
624: pay_ac_action_arch.lrr_act_tab(i).act_info29 := null;
625: pay_ac_action_arch.lrr_act_tab(i).act_info30 := null;
618: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
619: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
620: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
621: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
622: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
623: pay_ac_action_arch.lrr_act_tab(i).act_info28 := null;
624: pay_ac_action_arch.lrr_act_tab(i).act_info29 := null;
625: pay_ac_action_arch.lrr_act_tab(i).act_info30 := null;
626: end loop;
619: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
620: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
621: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
622: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
623: pay_ac_action_arch.lrr_act_tab(i).act_info28 := null;
624: pay_ac_action_arch.lrr_act_tab(i).act_info29 := null;
625: pay_ac_action_arch.lrr_act_tab(i).act_info30 := null;
626: end loop;
627: end if;
620: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
621: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
622: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
623: pay_ac_action_arch.lrr_act_tab(i).act_info28 := null;
624: pay_ac_action_arch.lrr_act_tab(i).act_info29 := null;
625: pay_ac_action_arch.lrr_act_tab(i).act_info30 := null;
626: end loop;
627: end if;
628:
621: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
622: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
623: pay_ac_action_arch.lrr_act_tab(i).act_info28 := null;
624: pay_ac_action_arch.lrr_act_tab(i).act_info29 := null;
625: pay_ac_action_arch.lrr_act_tab(i).act_info30 := null;
626: end loop;
627: end if;
628:
629: ln_step := 5;
626: end loop;
627: end if;
628:
629: ln_step := 5;
630: pay_ac_action_arch.lrr_act_tab.delete;
631: pay_ac_action_arch.emp_state_jd.delete;
632: pay_ac_action_arch.emp_city_jd.delete;
633: pay_ac_action_arch.emp_psd_jd.delete;
634: pay_ac_action_arch.emp_county_jd.delete;
627: end if;
628:
629: ln_step := 5;
630: pay_ac_action_arch.lrr_act_tab.delete;
631: pay_ac_action_arch.emp_state_jd.delete;
632: pay_ac_action_arch.emp_city_jd.delete;
633: pay_ac_action_arch.emp_psd_jd.delete;
634: pay_ac_action_arch.emp_county_jd.delete;
635: pay_ac_action_arch.emp_school_jd.delete;
628:
629: ln_step := 5;
630: pay_ac_action_arch.lrr_act_tab.delete;
631: pay_ac_action_arch.emp_state_jd.delete;
632: pay_ac_action_arch.emp_city_jd.delete;
633: pay_ac_action_arch.emp_psd_jd.delete;
634: pay_ac_action_arch.emp_county_jd.delete;
635: pay_ac_action_arch.emp_school_jd.delete;
636: pay_ac_action_arch.emp_elements_tab.delete;
629: ln_step := 5;
630: pay_ac_action_arch.lrr_act_tab.delete;
631: pay_ac_action_arch.emp_state_jd.delete;
632: pay_ac_action_arch.emp_city_jd.delete;
633: pay_ac_action_arch.emp_psd_jd.delete;
634: pay_ac_action_arch.emp_county_jd.delete;
635: pay_ac_action_arch.emp_school_jd.delete;
636: pay_ac_action_arch.emp_elements_tab.delete;
637: pay_ac_action_arch.lrr_act_tab.delete;
630: pay_ac_action_arch.lrr_act_tab.delete;
631: pay_ac_action_arch.emp_state_jd.delete;
632: pay_ac_action_arch.emp_city_jd.delete;
633: pay_ac_action_arch.emp_psd_jd.delete;
634: pay_ac_action_arch.emp_county_jd.delete;
635: pay_ac_action_arch.emp_school_jd.delete;
636: pay_ac_action_arch.emp_elements_tab.delete;
637: pay_ac_action_arch.lrr_act_tab.delete;
638:
631: pay_ac_action_arch.emp_state_jd.delete;
632: pay_ac_action_arch.emp_city_jd.delete;
633: pay_ac_action_arch.emp_psd_jd.delete;
634: pay_ac_action_arch.emp_county_jd.delete;
635: pay_ac_action_arch.emp_school_jd.delete;
636: pay_ac_action_arch.emp_elements_tab.delete;
637: pay_ac_action_arch.lrr_act_tab.delete;
638:
639: if gv_reporting_level = 'TAXGRP' then
632: pay_ac_action_arch.emp_city_jd.delete;
633: pay_ac_action_arch.emp_psd_jd.delete;
634: pay_ac_action_arch.emp_county_jd.delete;
635: pay_ac_action_arch.emp_school_jd.delete;
636: pay_ac_action_arch.emp_elements_tab.delete;
637: pay_ac_action_arch.lrr_act_tab.delete;
638:
639: if gv_reporting_level = 'TAXGRP' then
640: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
633: pay_ac_action_arch.emp_psd_jd.delete;
634: pay_ac_action_arch.emp_county_jd.delete;
635: pay_ac_action_arch.emp_school_jd.delete;
636: pay_ac_action_arch.emp_elements_tab.delete;
637: pay_ac_action_arch.lrr_act_tab.delete;
638:
639: if gv_reporting_level = 'TAXGRP' then
640: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
641: else
641: else
642: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;
643: end if;
644:
645: if pay_ac_action_arch.ltr_summary_labels.count = 0 then
646:
647: i := 0;
648:
649: for lbl in c_arch_labels loop
647: i := 0;
648:
649: for lbl in c_arch_labels loop
650:
651: pay_ac_action_arch.ltr_summary_labels(i).language := lbl.language;
652: pay_ac_action_arch.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
653: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
654:
655: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
648:
649: for lbl in c_arch_labels loop
650:
651: pay_ac_action_arch.ltr_summary_labels(i).language := lbl.language;
652: pay_ac_action_arch.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
653: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
654:
655: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
656: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
649: for lbl in c_arch_labels loop
650:
651: pay_ac_action_arch.ltr_summary_labels(i).language := lbl.language;
652: pay_ac_action_arch.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
653: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
654:
655: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
656: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
657: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).meaning);
651: pay_ac_action_arch.ltr_summary_labels(i).language := lbl.language;
652: pay_ac_action_arch.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
653: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
654:
655: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
656: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
657: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).meaning);
658:
659: i := i + 1;
652: pay_ac_action_arch.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
653: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
654:
655: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
656: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
657: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).meaning);
658:
659: i := i + 1;
660:
653: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
654:
655: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
656: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
657: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).meaning);
658:
659: i := i + 1;
660:
661: end loop;
661: end loop;
662:
663: end if;
664:
665: hr_utility.trace('pay_ac_action_arch.lrr_act_tab.count = ' ||
666: pay_ac_action_arch.lrr_act_tab.count);
667: hr_utility.set_location(gv_package || lv_procedure_name, 50);
668: ln_step := 10;
669:
662:
663: end if;
664:
665: hr_utility.trace('pay_ac_action_arch.lrr_act_tab.count = ' ||
666: pay_ac_action_arch.lrr_act_tab.count);
667: hr_utility.set_location(gv_package || lv_procedure_name, 50);
668: ln_step := 10;
669:
670: EXCEPTION
1095: ln_step := 1;
1096: p_rate_exists := 'N';
1097:
1098: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1099: if pay_ac_action_arch.lrr_act_tab.count > 0 then
1100: for i in pay_ac_action_arch.lrr_act_tab.first..
1101: pay_ac_action_arch.lrr_act_tab.last
1102: loop
1103: if ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
1096: p_rate_exists := 'N';
1097:
1098: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1099: if pay_ac_action_arch.lrr_act_tab.count > 0 then
1100: for i in pay_ac_action_arch.lrr_act_tab.first..
1101: pay_ac_action_arch.lrr_act_tab.last
1102: loop
1103: if ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
1104: p_xfr_action_id ) and
1097:
1098: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1099: if pay_ac_action_arch.lrr_act_tab.count > 0 then
1100: for i in pay_ac_action_arch.lrr_act_tab.first..
1101: pay_ac_action_arch.lrr_act_tab.last
1102: loop
1103: if ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
1104: p_xfr_action_id ) and
1105: ( pay_ac_action_arch.lrr_act_tab(i).act_info2 =
1099: if pay_ac_action_arch.lrr_act_tab.count > 0 then
1100: for i in pay_ac_action_arch.lrr_act_tab.first..
1101: pay_ac_action_arch.lrr_act_tab.last
1102: loop
1103: if ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
1104: p_xfr_action_id ) and
1105: ( pay_ac_action_arch.lrr_act_tab(i).act_info2 =
1106: p_element_type_id ) )
1107: then
1101: pay_ac_action_arch.lrr_act_tab.last
1102: loop
1103: if ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
1104: p_xfr_action_id ) and
1105: ( pay_ac_action_arch.lrr_act_tab(i).act_info2 =
1106: p_element_type_id ) )
1107: then
1108: p_rate_exists := 'Y';
1109: exit;
1406: ln_step := 15;
1407: if nvl(ln_ytd_amount, 0) <> 0 or nvl(ln_payments_amount, 0) <> 0 or (gv_ytd_amount <> ln_payments_amount and p_ytd_flag = 'Y')
1408: or nvl(ln_ytd_hours,0) <> 0
1409: then -- bug 15976832, added ln_ytd_hours to the above if condition
1410: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1411: if p_element_classification_name in ('Earnings',
1412: 'Supplemental Earnings',
1413: 'Taxable Benefits',
1414: 'Imputed Earnings',
1416: 'Alien/Expat Earnings') then
1417: hr_utility.set_location(gv_package || lv_procedure_name, 125);
1418: lv_action_category := 'AC EARNINGS';
1419: /* bug 6702864 We are not subtracting the Retro amount from the base element so added the if condition */
1420: /* pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1421: := fnd_number.number_to_canonical(ln_current_hours);
1422: */
1423: IF p_ytd_flag = 'N' then
1424: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1420: /* pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1421: := fnd_number.number_to_canonical(ln_current_hours);
1422: */
1423: IF p_ytd_flag = 'N' then
1424: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1425: := fnd_number.number_to_canonical(ln_current_hours);
1426: ELSE
1427: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1428: := fnd_number.number_to_canonical((ln_current_hours) - gv_ytd_hour);
1423: IF p_ytd_flag = 'N' then
1424: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1425: := fnd_number.number_to_canonical(ln_current_hours);
1426: ELSE
1427: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1428: := fnd_number.number_to_canonical((ln_current_hours) - gv_ytd_hour);
1429: END IF;
1430:
1431: IF ln_current_hours <> 0 AND ln_payments_amount <> 0 THEN
1444: --In that case we dont need to derive rate (however a Hours By Rate entry will not be created for that TEW)
1445:
1446: --IF ln_multiple <> 1 OR ln_rate IS NULL THEN /*12819017-End*/
1447: IF round(ln_rate,5) <> round((ln_payments_amount/ln_current_hours),5) OR ln_rate IS NULL THEN /*14219126*/
1448: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22:=
1449: round((ln_payments_amount/ln_current_hours),5);/*Bug 3311866 -- 12819017*/
1450: hr_utility.trace('Rate derived as multiple is not one ' || round((ln_payments_amount/ln_current_hours),5));
1451: /*12819017-Start*/
1452: ELSE
1449: round((ln_payments_amount/ln_current_hours),5);/*Bug 3311866 -- 12819017*/
1450: hr_utility.trace('Rate derived as multiple is not one ' || round((ln_payments_amount/ln_current_hours),5));
1451: /*12819017-Start*/
1452: ELSE
1453: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22:=ln_rate;
1454: hr_utility.trace('Rate Not derived as multiple is one ' || ln_rate);
1455: END IF;/*12819017-End*/
1456:
1457: ELSE
1454: hr_utility.trace('Rate Not derived as multiple is one ' || ln_rate);
1455: END IF;/*12819017-End*/
1456:
1457: ELSE
1458: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := null;
1459: END IF;
1460:
1461: IF p_ytd_flag = 'N' then
1462: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1458: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := null;
1459: END IF;
1460:
1461: IF p_ytd_flag = 'N' then
1462: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1463: := fnd_number.number_to_canonical(ln_ytd_hours);
1464: ELSE
1465: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1466: := fnd_number.number_to_canonical((ln_ytd_hours) - gv_ytd_hour);
1461: IF p_ytd_flag = 'N' then
1462: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1463: := fnd_number.number_to_canonical(ln_ytd_hours);
1464: ELSE
1465: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1466: := fnd_number.number_to_canonical((ln_ytd_hours) - gv_ytd_hour);
1467: END IF;
1468: end if;
1469:
1469:
1470: hr_utility.set_location(gv_package || lv_procedure_name, 130);
1471: /* Insert this into the plsql table if Current or YTD
1472: amount is not Zero */
1473: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1474: := lv_action_category;
1475: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1476: := nvl(p_jurisdiction_code, '00-000-0000');
1477: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1471: /* Insert this into the plsql table if Current or YTD
1472: amount is not Zero */
1473: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1474: := lv_action_category;
1475: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1476: := nvl(p_jurisdiction_code, '00-000-0000');
1477: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1478: := p_xfr_action_id;
1479: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1473: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1474: := lv_action_category;
1475: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1476: := nvl(p_jurisdiction_code, '00-000-0000');
1477: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1478: := p_xfr_action_id;
1479: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1480: := p_element_classification_name;
1481: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1475: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1476: := nvl(p_jurisdiction_code, '00-000-0000');
1477: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1478: := p_xfr_action_id;
1479: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1480: := p_element_classification_name;
1481: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1482: := p_element_type_id;
1483: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1477: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1478: := p_xfr_action_id;
1479: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1480: := p_element_classification_name;
1481: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1482: := p_element_type_id;
1483: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1484: := p_primary_balance_id;
1485: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1479: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1480: := p_element_classification_name;
1481: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1482: := p_element_type_id;
1483: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1484: := p_primary_balance_id;
1485: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1486: := p_processing_priority;
1487: /* bug 6702864 We are not subtracting the Retro amount from the base element so added the if condition */
1481: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1482: := p_element_type_id;
1483: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1484: := p_primary_balance_id;
1485: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1486: := p_processing_priority;
1487: /* bug 6702864 We are not subtracting the Retro amount from the base element so added the if condition */
1488: /* pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1489: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1484: := p_primary_balance_id;
1485: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1486: := p_processing_priority;
1487: /* bug 6702864 We are not subtracting the Retro amount from the base element so added the if condition */
1488: /* pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1489: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1490: */
1491:
1492: IF p_ytd_flag = 'N' then
1489: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1490: */
1491:
1492: IF p_ytd_flag = 'N' then
1493: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1494: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1495: ELSE
1496: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1497: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0) - gv_ytd_amount);
1492: IF p_ytd_flag = 'N' then
1493: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1494: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1495: ELSE
1496: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1497: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0) - gv_ytd_amount);
1498: END IF;
1499:
1500: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_payments_amount,0)));
1499:
1500: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_payments_amount,0)));
1501:
1502: IF p_ytd_flag = 'N' then
1503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1504: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
1505: ELSE
1506: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1507: := fnd_number.number_to_canonical((ln_ytd_amount) - gv_ytd_amount);
1502: IF p_ytd_flag = 'N' then
1503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1504: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
1505: ELSE
1506: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1507: := fnd_number.number_to_canonical((ln_ytd_amount) - gv_ytd_amount);
1508: END IF;
1509: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1510: := p_reporting_name;
1505: ELSE
1506: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1507: := fnd_number.number_to_canonical((ln_ytd_amount) - gv_ytd_amount);
1508: END IF;
1509: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1510: := p_reporting_name;
1511: IF lv_action_category = 'AC DEDUCTIONS' THEN
1512: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
1513: := p_reporting_name;
1508: END IF;
1509: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1510: := p_reporting_name;
1511: IF lv_action_category = 'AC DEDUCTIONS' THEN
1512: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
1513: := p_reporting_name;
1514: END IF;
1515: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
1516: := p_original_date_earned;
1511: IF lv_action_category = 'AC DEDUCTIONS' THEN
1512: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
1513: := p_reporting_name;
1514: END IF;
1515: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
1516: := p_original_date_earned;
1517: hr_utility.trace('p_original_date_earned :=' || p_original_date_earned );
1518: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
1519: := p_effective_start_date;
1514: END IF;
1515: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
1516: := p_original_date_earned;
1517: hr_utility.trace('p_original_date_earned :=' || p_original_date_earned );
1518: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
1519: := p_effective_start_date;
1520: hr_utility.trace('p_effective_start_date := ' || p_effective_start_date );
1521: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
1522: := p_effective_end_date ;
1517: hr_utility.trace('p_original_date_earned :=' || p_original_date_earned );
1518: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
1519: := p_effective_start_date;
1520: hr_utility.trace('p_effective_start_date := ' || p_effective_start_date );
1521: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
1522: := p_effective_end_date ;
1523: hr_utility.trace('p_effective_end_date:= ' || p_effective_end_date );
1524: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
1525: := p_category;
1520: hr_utility.trace('p_effective_start_date := ' || p_effective_start_date );
1521: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
1522: := p_effective_end_date ;
1523: hr_utility.trace('p_effective_end_date:= ' || p_effective_end_date );
1524: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
1525: := p_category;
1526: hr_utility.trace('p_category ' || p_category );
1527: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
1528: := p_el_jurisdiction_code;
1523: hr_utility.trace('p_effective_end_date:= ' || p_effective_end_date );
1524: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
1525: := p_category;
1526: hr_utility.trace('p_category ' || p_category );
1527: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
1528: := p_el_jurisdiction_code;
1529:
1530: end if;
1531:
1693: ln_retro_element_entry NUMBER;
1694:
1695: i NUMBER := 0;
1696:
1697: hbr pay_ac_action_arch.hbr_table;
1698:
1699: BEGIN
1700:
1701:
1807: end if;
1808:
1809: hr_utility.trace('ytd balance = ' || ln_ytd_amount);
1810: hr_utility.trace('ytd hours = ' || ln_ytd_hours);
1811: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1812: := ln_ytd_amount;
1813: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1814: := ln_ytd_hours;
1815:
1809: hr_utility.trace('ytd balance = ' || ln_ytd_amount);
1810: hr_utility.trace('ytd hours = ' || ln_ytd_hours);
1811: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1812: := ln_ytd_amount;
1813: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1814: := ln_ytd_hours;
1815:
1816: ln_ytd_amount := 0;
1817: ln_ytd_hours := 0;
1856: IF nvl(ln_retro_multiple,0) = 0 THEN
1857: ln_retro_multiple := 1;
1858: END IF;
1859:
1860: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1861: hr_utility.trace('ln_index = ' || ln_index);
1862:
1863:
1864: ln_step := 20;
1861: hr_utility.trace('ln_index = ' || ln_index);
1862:
1863:
1864: ln_step := 20;
1865: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1866: := 'AC EARNINGS';
1867:
1868: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1869: := '00-000-0000';
1864: ln_step := 20;
1865: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1866: := 'AC EARNINGS';
1867:
1868: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1869: := '00-000-0000';
1870: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1871: := lv_classification_name;
1872: hr_utility.trace('action_info_category' || lv_classification_name);
1866: := 'AC EARNINGS';
1867:
1868: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1869: := '00-000-0000';
1870: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1871: := lv_classification_name;
1872: hr_utility.trace('action_info_category' || lv_classification_name);
1873: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1874: := prev_element_type_id;
1869: := '00-000-0000';
1870: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1871: := lv_classification_name;
1872: hr_utility.trace('action_info_category' || lv_classification_name);
1873: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1874: := prev_element_type_id;
1875: hr_utility.trace('act_info2' || prev_element_type_id);
1876: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1877: := ln_primary_balance_id;
1872: hr_utility.trace('action_info_category' || lv_classification_name);
1873: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1874: := prev_element_type_id;
1875: hr_utility.trace('act_info2' || prev_element_type_id);
1876: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1877: := ln_primary_balance_id;
1878: hr_utility.trace('act_info6' || ln_primary_balance_id);
1879: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1880: := ln_processing_priority;
1875: hr_utility.trace('act_info2' || prev_element_type_id);
1876: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1877: := ln_primary_balance_id;
1878: hr_utility.trace('act_info6' || ln_primary_balance_id);
1879: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1880: := ln_processing_priority;
1881: hr_utility.trace('act_info7' || ln_processing_priority);
1882: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1883: := fnd_number.number_to_canonical(ln_retro_payvalue);
1878: hr_utility.trace('act_info6' || ln_primary_balance_id);
1879: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1880: := ln_processing_priority;
1881: hr_utility.trace('act_info7' || ln_processing_priority);
1882: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1883: := fnd_number.number_to_canonical(ln_retro_payvalue);
1884: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));
1885: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1886: := 0;
1881: hr_utility.trace('act_info7' || ln_processing_priority);
1882: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1883: := fnd_number.number_to_canonical(ln_retro_payvalue);
1884: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));
1885: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1886: := 0;
1887: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1888: := lv_reporting_name;
1889: hr_utility.trace('act_info10' || lv_reporting_name);
1883: := fnd_number.number_to_canonical(ln_retro_payvalue);
1884: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));
1885: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1886: := 0;
1887: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1888: := lv_reporting_name;
1889: hr_utility.trace('act_info10' || lv_reporting_name);
1890: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1891: := fnd_number.number_to_canonical(ln_retro_hours);
1886: := 0;
1887: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1888: := lv_reporting_name;
1889: hr_utility.trace('act_info10' || lv_reporting_name);
1890: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1891: := fnd_number.number_to_canonical(ln_retro_hours);
1892: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));
1893: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1894: := p_xfr_action_id;
1889: hr_utility.trace('act_info10' || lv_reporting_name);
1890: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1891: := fnd_number.number_to_canonical(ln_retro_hours);
1892: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));
1893: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1894: := p_xfr_action_id;
1895: hr_utility.trace('action_context_id' || p_xfr_action_id);
1896:
1897: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1893: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1894: := p_xfr_action_id;
1895: hr_utility.trace('action_context_id' || p_xfr_action_id);
1896:
1897: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1898: := fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple);
1899: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1900: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1901: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1895: hr_utility.trace('action_context_id' || p_xfr_action_id);
1896:
1897: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1898: := fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple);
1899: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1900: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1901: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1902: END LOOP;
1903: CLOSE c_retro;
1942:
1943: /*Insert this into the plsql table */
1944:
1945: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1946: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1947: hr_utility.trace('ln_index = ' || ln_index);
1948:
1949:
1950: ln_step := 20;
1947: hr_utility.trace('ln_index = ' || ln_index);
1948:
1949:
1950: ln_step := 20;
1951: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1952: := 'AC EARNINGS';
1953: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1954: := '00-000-0000';
1955: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1949:
1950: ln_step := 20;
1951: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1952: := 'AC EARNINGS';
1953: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1954: := '00-000-0000';
1955: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1956: := lv_classification_name;
1957: hr_utility.trace('action_info_category2' || lv_classification_name);
1951: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1952: := 'AC EARNINGS';
1953: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1954: := '00-000-0000';
1955: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1956: := lv_classification_name;
1957: hr_utility.trace('action_info_category2' || lv_classification_name);
1958: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1959: := ln_element_type_id;
1954: := '00-000-0000';
1955: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1956: := lv_classification_name;
1957: hr_utility.trace('action_info_category2' || lv_classification_name);
1958: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1959: := ln_element_type_id;
1960: hr_utility.trace('act_info22' || prev_element_type_id);
1961: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1962: := ln_primary_balance_id;
1957: hr_utility.trace('action_info_category2' || lv_classification_name);
1958: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1959: := ln_element_type_id;
1960: hr_utility.trace('act_info22' || prev_element_type_id);
1961: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1962: := ln_primary_balance_id;
1963: hr_utility.trace('act_info62' || ln_primary_balance_id);
1964: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1965: := ln_processing_priority;
1960: hr_utility.trace('act_info22' || prev_element_type_id);
1961: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1962: := ln_primary_balance_id;
1963: hr_utility.trace('act_info62' || ln_primary_balance_id);
1964: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1965: := ln_processing_priority;
1966: hr_utility.trace('act_info72' || ln_processing_priority);
1967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1968: := fnd_number.number_to_canonical(ln_payments_amount);
1963: hr_utility.trace('act_info62' || ln_primary_balance_id);
1964: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1965: := ln_processing_priority;
1966: hr_utility.trace('act_info72' || ln_processing_priority);
1967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1968: := fnd_number.number_to_canonical(ln_payments_amount);
1969: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1970: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1971: := fnd_number.number_to_canonical(ln_ytd_amount);
1966: hr_utility.trace('act_info72' || ln_processing_priority);
1967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1968: := fnd_number.number_to_canonical(ln_payments_amount);
1969: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1970: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1971: := fnd_number.number_to_canonical(ln_ytd_amount);
1972:
1973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1974: := lv_reporting_name;
1969: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1970: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1971: := fnd_number.number_to_canonical(ln_ytd_amount);
1972:
1973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1974: := lv_reporting_name;
1975: hr_utility.trace('act_info102' || lv_reporting_name);
1976: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1977: := fnd_number.number_to_canonical(ln_hours);
1972:
1973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1974: := lv_reporting_name;
1975: hr_utility.trace('act_info102' || lv_reporting_name);
1976: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1977: := fnd_number.number_to_canonical(ln_hours);
1978: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1979: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1980: := p_xfr_action_id;
1975: hr_utility.trace('act_info102' || lv_reporting_name);
1976: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1977: := fnd_number.number_to_canonical(ln_hours);
1978: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1979: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1980: := p_xfr_action_id;
1981: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1982: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1977: := fnd_number.number_to_canonical(ln_hours);
1978: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1979: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1980: := p_xfr_action_id;
1981: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1982: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1984: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1979: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1980: := p_xfr_action_id;
1981: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1982: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1984: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1986: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1987: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1981: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1982: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1984: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1986: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1987: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1988: prev_element_type_id := ln_element_type_id;
1989: prev_run_asg_act_id := hbr(j).run_asg_act_id;
2907: if lv_element_classification_name like '% Deductions' then
2908: ln_hours_balance_id := null;
2909: end if;
2910: ln_step := 15;
2911: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2912: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
2913: := ln_element_type_id;
2914: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2915: := lv_element_classification_name;
2908: ln_hours_balance_id := null;
2909: end if;
2910: ln_step := 15;
2911: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2912: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
2913: := ln_element_type_id;
2914: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2915: := lv_element_classification_name;
2916: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2910: ln_step := 15;
2911: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2912: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
2913: := ln_element_type_id;
2914: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2915: := lv_element_classification_name;
2916: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2917: := ln_primary_balance_id;
2918: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
2912: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
2913: := ln_element_type_id;
2914: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2915: := lv_element_classification_name;
2916: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2917: := ln_primary_balance_id;
2918: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
2919: := ln_processing_priority;
2920: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2914: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2915: := lv_element_classification_name;
2916: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2917: := ln_primary_balance_id;
2918: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
2919: := ln_processing_priority;
2920: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2921: := lv_reporting_name;
2922: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2916: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2917: := ln_primary_balance_id;
2918: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
2919: := ln_processing_priority;
2920: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2921: := lv_reporting_name;
2922: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2923: := ln_hours_balance_id;
2924: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2918: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
2919: := ln_processing_priority;
2920: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2921: := lv_reporting_name;
2922: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2923: := ln_hours_balance_id;
2924: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2925: := '00-000-0000';
2926:
2920: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2921: := lv_reporting_name;
2922: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2923: := ln_hours_balance_id;
2924: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2925: := '00-000-0000';
2926:
2927: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2928: ln_step := 20;
3158: hr_utility.trace('ln_element_type_id = ' ||ln_element_type_id);
3159: hr_utility.trace('ln_primary_balance_id = '||ln_primary_balance_id);
3160: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
3161:
3162: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3163:
3164: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3165: := lv_action_info_category;
3166: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3160: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
3161:
3162: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3163:
3164: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3165: := lv_action_info_category;
3166: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3167: := lv_jurisdiction_code;
3168: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3162: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3163:
3164: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3165: := lv_action_info_category;
3166: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3167: := lv_jurisdiction_code;
3168: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3169: := p_xfr_action_id;
3170: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
3164: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3165: := lv_action_info_category;
3166: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3167: := lv_jurisdiction_code;
3168: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3169: := p_xfr_action_id;
3170: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
3171: := ln_assignment_id;
3172: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3166: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3167: := lv_jurisdiction_code;
3168: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3169: := p_xfr_action_id;
3170: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
3171: := ln_assignment_id;
3172: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3173: := lv_element_classfication_name;
3174: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3168: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3169: := p_xfr_action_id;
3170: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
3171: := ln_assignment_id;
3172: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3173: := lv_element_classfication_name;
3174: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3175: := ln_element_type_id;
3176: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3170: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
3171: := ln_assignment_id;
3172: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3173: := lv_element_classfication_name;
3174: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3175: := ln_element_type_id;
3176: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3177: := ln_primary_balance_id;
3178: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3172: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3173: := lv_element_classfication_name;
3174: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3175: := ln_element_type_id;
3176: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3177: := ln_primary_balance_id;
3178: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3179: := ln_processing_priority;
3180: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3174: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3175: := ln_element_type_id;
3176: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3177: := ln_primary_balance_id;
3178: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3179: := ln_processing_priority;
3180: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3181: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3182: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3176: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3177: := ln_primary_balance_id;
3178: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3179: := ln_processing_priority;
3180: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3181: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3182: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3183: := lv_reporting_name;
3184: if lv_action_info_category = 'AC EARNINGS' then
3178: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3179: := ln_processing_priority;
3180: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3181: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3182: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3183: := lv_reporting_name;
3184: if lv_action_info_category = 'AC EARNINGS' then
3185: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3186: := fnd_number.number_to_canonical(ln_ytd_hours);
3181: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3182: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3183: := lv_reporting_name;
3184: if lv_action_info_category = 'AC EARNINGS' then
3185: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3186: := fnd_number.number_to_canonical(ln_ytd_hours);
3187: end if;
3188:
3189: -- Added for Bug# 7348767, Bug# 7348838
3188:
3189: -- Added for Bug# 7348767, Bug# 7348838
3190: if lv_action_info_category = 'AC DEDUCTIONS' THEN
3191: --Bug 8688998
3192: --pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_reporting_name;
3193: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_display_name;
3194: end if;
3195: end if;
3196:
3189: -- Added for Bug# 7348767, Bug# 7348838
3190: if lv_action_info_category = 'AC DEDUCTIONS' THEN
3191: --Bug 8688998
3192: --pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_reporting_name;
3193: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_display_name;
3194: end if;
3195: end if;
3196:
3197: if ln_assignment_id = p_assignment_id then
3194: end if;
3195: end if;
3196:
3197: if ln_assignment_id = p_assignment_id then
3198: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3199: for i in pay_ac_action_arch.emp_elements_tab.first..
3200: pay_ac_action_arch.emp_elements_tab.last LOOP
3201: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3202: = ln_primary_balance_id and
3195: end if;
3196:
3197: if ln_assignment_id = p_assignment_id then
3198: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3199: for i in pay_ac_action_arch.emp_elements_tab.first..
3200: pay_ac_action_arch.emp_elements_tab.last LOOP
3201: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3202: = ln_primary_balance_id and
3203: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3196:
3197: if ln_assignment_id = p_assignment_id then
3198: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3199: for i in pay_ac_action_arch.emp_elements_tab.first..
3200: pay_ac_action_arch.emp_elements_tab.last LOOP
3201: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3202: = ln_primary_balance_id and
3203: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3204: = lv_jurisdiction_code then
3197: if ln_assignment_id = p_assignment_id then
3198: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3199: for i in pay_ac_action_arch.emp_elements_tab.first..
3200: pay_ac_action_arch.emp_elements_tab.last LOOP
3201: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3202: = ln_primary_balance_id and
3203: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3204: = lv_jurisdiction_code then
3205: lv_element_archived := 'Y';
3199: for i in pay_ac_action_arch.emp_elements_tab.first..
3200: pay_ac_action_arch.emp_elements_tab.last LOOP
3201: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3202: = ln_primary_balance_id and
3203: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3204: = lv_jurisdiction_code then
3205: lv_element_archived := 'Y';
3206: exit;
3207: end if;
3238: end if;
3239:
3240: if lv_element_archived = 'N' then
3241: /* populate the extra element table */
3242: ln_index := pay_ac_action_arch.emp_elements_tab.count;
3243: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
3244: := ln_element_type_id;
3245: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3246: := lv_element_classfication_name;
3239:
3240: if lv_element_archived = 'N' then
3241: /* populate the extra element table */
3242: ln_index := pay_ac_action_arch.emp_elements_tab.count;
3243: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
3244: := ln_element_type_id;
3245: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3246: := lv_element_classfication_name;
3247: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
3241: /* populate the extra element table */
3242: ln_index := pay_ac_action_arch.emp_elements_tab.count;
3243: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
3244: := ln_element_type_id;
3245: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3246: := lv_element_classfication_name;
3247: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
3248: := lv_jurisdiction_code;
3249: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3243: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
3244: := ln_element_type_id;
3245: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3246: := lv_element_classfication_name;
3247: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
3248: := lv_jurisdiction_code;
3249: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3250: := ln_primary_balance_id;
3251: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3245: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3246: := lv_element_classfication_name;
3247: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
3248: := lv_jurisdiction_code;
3249: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3250: := ln_primary_balance_id;
3251: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3252: := ln_processing_priority;
3253: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
3247: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
3248: := lv_jurisdiction_code;
3249: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3250: := ln_primary_balance_id;
3251: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3252: := ln_processing_priority;
3253: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
3254: := lv_reporting_name;
3255: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
3249: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3250: := ln_primary_balance_id;
3251: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3252: := ln_processing_priority;
3253: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
3254: := lv_reporting_name;
3255: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
3256: := ln_hours_balance_id;
3257:
3251: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3252: := ln_processing_priority;
3253: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
3254: := lv_reporting_name;
3255: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
3256: := ln_hours_balance_id;
3257:
3258: if lv_jurisdiction_code <> '00-000-0000' then
3259: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3298: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
3299: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
3300:
3301: if (( nvl(ln_ytd_amount, 0) + nvl(ln_payments_amount, 0) <> 0 ) or
3302: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) then
3303:
3304: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3305: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3306: hr_utility.trace('ln_index = ' || ln_index);
3301: if (( nvl(ln_ytd_amount, 0) + nvl(ln_payments_amount, 0) <> 0 ) or
3302: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) then
3303:
3304: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3305: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3306: hr_utility.trace('ln_index = ' || ln_index);
3307: ln_step := 20;
3308: if lv_element_classfication_name in ('Earnings',
3309: 'Alien/Expat Earnings',
3311: 'Taxable Benefits',
3312: 'Imputed Earnings',
3313: 'Non-payroll Payments') then
3314: lv_action_info_category := 'AC EARNINGS';
3315: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3316: := fnd_number.number_to_canonical(ln_ytd_hours);
3317: end if;
3318:
3319: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3315: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3316: := fnd_number.number_to_canonical(ln_ytd_hours);
3317: end if;
3318:
3319: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3320: := lv_action_info_category;
3321: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3322: := lv_jurisdiction_code;
3323: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3317: end if;
3318:
3319: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3320: := lv_action_info_category;
3321: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3322: := lv_jurisdiction_code;
3323: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3324: := p_xfr_action_id;
3325: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3319: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3320: := lv_action_info_category;
3321: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3322: := lv_jurisdiction_code;
3323: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3324: := p_xfr_action_id;
3325: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3326: := lv_element_classfication_name;
3327: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3321: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3322: := lv_jurisdiction_code;
3323: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3324: := p_xfr_action_id;
3325: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3326: := lv_element_classfication_name;
3327: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3328: := ln_element_type_id;
3329: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3323: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3324: := p_xfr_action_id;
3325: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3326: := lv_element_classfication_name;
3327: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3328: := ln_element_type_id;
3329: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3330: := ln_primary_balance_id;
3331: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3325: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3326: := lv_element_classfication_name;
3327: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3328: := ln_element_type_id;
3329: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3330: := ln_primary_balance_id;
3331: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3332: := ln_processing_priority;
3333: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3327: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3328: := ln_element_type_id;
3329: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3330: := ln_primary_balance_id;
3331: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3332: := ln_processing_priority;
3333: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3334: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3335: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3329: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3330: := ln_primary_balance_id;
3331: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3332: := ln_processing_priority;
3333: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3334: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3335: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3336: := fnd_number.number_to_canonical(ln_ytd_amount);
3337: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3331: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3332: := ln_processing_priority;
3333: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3334: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3335: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3336: := fnd_number.number_to_canonical(ln_ytd_amount);
3337: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3338: := lv_reporting_name;
3339: -- Added for Bug# 7348767, Bug# 7348838
3333: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3334: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3335: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3336: := fnd_number.number_to_canonical(ln_ytd_amount);
3337: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3338: := lv_reporting_name;
3339: -- Added for Bug# 7348767, Bug# 7348838
3340: if lv_action_info_category = 'AC DEDUCTIONS' THEN
3341: --Bug 8688998
3338: := lv_reporting_name;
3339: -- Added for Bug# 7348767, Bug# 7348838
3340: if lv_action_info_category = 'AC DEDUCTIONS' THEN
3341: --Bug 8688998
3342: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_reporting_name;
3343: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_display_name;
3344: end if;
3345:
3346: end if;
3339: -- Added for Bug# 7348767, Bug# 7348838
3340: if lv_action_info_category = 'AC DEDUCTIONS' THEN
3341: --Bug 8688998
3342: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_reporting_name;
3343: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_display_name;
3344: end if;
3345:
3346: end if;
3347: end if;
3528: ln_hours_balance_id := null;
3529: end if;
3530:
3531: ln_step := 5;
3532: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3533: for i in pay_ac_action_arch.emp_elements_tab.first..
3534: pay_ac_action_arch.emp_elements_tab.last LOOP
3535: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3536: = ln_primary_balance_id and
3529: end if;
3530:
3531: ln_step := 5;
3532: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3533: for i in pay_ac_action_arch.emp_elements_tab.first..
3534: pay_ac_action_arch.emp_elements_tab.last LOOP
3535: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3536: = ln_primary_balance_id and
3537: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3530:
3531: ln_step := 5;
3532: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3533: for i in pay_ac_action_arch.emp_elements_tab.first..
3534: pay_ac_action_arch.emp_elements_tab.last LOOP
3535: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3536: = ln_primary_balance_id and
3537: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3538: = lv_jurisdiction_code then
3531: ln_step := 5;
3532: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3533: for i in pay_ac_action_arch.emp_elements_tab.first..
3534: pay_ac_action_arch.emp_elements_tab.last LOOP
3535: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3536: = ln_primary_balance_id and
3537: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3538: = lv_jurisdiction_code then
3539: lv_element_archived := 'Y';
3533: for i in pay_ac_action_arch.emp_elements_tab.first..
3534: pay_ac_action_arch.emp_elements_tab.last LOOP
3535: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3536: = ln_primary_balance_id and
3537: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3538: = lv_jurisdiction_code then
3539: lv_element_archived := 'Y';
3540: exit;
3541: end if;
3544:
3545: if lv_element_archived = 'N' then
3546: /* populate the extra element table */
3547: ln_step := 10;
3548: ln_index := pay_ac_action_arch.emp_elements_tab.count;
3549: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
3550: := ln_element_type_id;
3551: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3552: := lv_element_classfication_name;
3545: if lv_element_archived = 'N' then
3546: /* populate the extra element table */
3547: ln_step := 10;
3548: ln_index := pay_ac_action_arch.emp_elements_tab.count;
3549: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
3550: := ln_element_type_id;
3551: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3552: := lv_element_classfication_name;
3553: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3547: ln_step := 10;
3548: ln_index := pay_ac_action_arch.emp_elements_tab.count;
3549: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
3550: := ln_element_type_id;
3551: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3552: := lv_element_classfication_name;
3553: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3554: := ln_primary_balance_id;
3555: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3549: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
3550: := ln_element_type_id;
3551: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3552: := lv_element_classfication_name;
3553: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3554: := ln_primary_balance_id;
3555: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3556: := ln_processing_priority;
3557: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
3551: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3552: := lv_element_classfication_name;
3553: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3554: := ln_primary_balance_id;
3555: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3556: := ln_processing_priority;
3557: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
3558: := lv_reporting_name;
3559: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
3553: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3554: := ln_primary_balance_id;
3555: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3556: := ln_processing_priority;
3557: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
3558: := lv_reporting_name;
3559: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
3560: := ln_hours_balance_id;
3561: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
3555: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3556: := ln_processing_priority;
3557: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
3558: := lv_reporting_name;
3559: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
3560: := ln_hours_balance_id;
3561: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
3562: := lv_jurisdiction_code;
3563:
3557: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
3558: := lv_reporting_name;
3559: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
3560: := ln_hours_balance_id;
3561: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
3562: := lv_jurisdiction_code;
3563:
3564: if lv_jurisdiction_code <> '00-000-0000' then
3565: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3602: end if;
3603:
3604: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3605: if nvl(ln_ytd_amount, 0) <> 0 or nvl(ln_payments_amount, 0) <> 0 then
3606: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3607: hr_utility.trace('ln_index = ' || ln_index);
3608: if lv_element_classfication_name in ('Earnings',
3609: 'Alien/Expat Earnings',
3610: 'Supplemental Earnings',
3611: 'Taxable Benefits',
3612: 'Imputed Earnings',
3613: 'Non-payroll Payments') then
3614: lv_action_info_category := 'AC EARNINGS';
3615: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3616: := fnd_number.number_to_canonical(ln_ytd_hours); /* Bug 3311866*/
3617: end if;
3618:
3619: ln_step := 20;
3616: := fnd_number.number_to_canonical(ln_ytd_hours); /* Bug 3311866*/
3617: end if;
3618:
3619: ln_step := 20;
3620: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3621: := lv_action_info_category;
3622: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3623: := lv_jurisdiction_code;
3624: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3618:
3619: ln_step := 20;
3620: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3621: := lv_action_info_category;
3622: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3623: := lv_jurisdiction_code;
3624: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3625: := p_xfr_action_id ;
3626: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3620: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3621: := lv_action_info_category;
3622: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3623: := lv_jurisdiction_code;
3624: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3625: := p_xfr_action_id ;
3626: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3627: := lv_element_classfication_name;
3628: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3622: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3623: := lv_jurisdiction_code;
3624: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3625: := p_xfr_action_id ;
3626: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3627: := lv_element_classfication_name;
3628: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3629: := ln_element_type_id;
3630: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3624: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3625: := p_xfr_action_id ;
3626: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3627: := lv_element_classfication_name;
3628: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3629: := ln_element_type_id;
3630: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3631: := ln_primary_balance_id;
3632: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3626: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3627: := lv_element_classfication_name;
3628: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3629: := ln_element_type_id;
3630: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3631: := ln_primary_balance_id;
3632: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3633: := ln_processing_priority;
3634: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3628: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3629: := ln_element_type_id;
3630: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3631: := ln_primary_balance_id;
3632: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3633: := ln_processing_priority;
3634: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3635: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3636: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3630: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3631: := ln_primary_balance_id;
3632: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3633: := ln_processing_priority;
3634: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3635: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3636: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3637: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3638: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3632: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3633: := ln_processing_priority;
3634: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3635: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3636: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3637: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3638: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3639: := lv_reporting_name;
3640: -- Added for Bug# 7348767, Bug# 7348838
3634: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3635: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3636: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3637: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3638: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3639: := lv_reporting_name;
3640: -- Added for Bug# 7348767, Bug# 7348838
3641: if lv_action_info_category = 'AC DEDUCTIONS' THEN
3642: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_reporting_name;
3638: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3639: := lv_reporting_name;
3640: -- Added for Bug# 7348767, Bug# 7348838
3641: if lv_action_info_category = 'AC DEDUCTIONS' THEN
3642: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_reporting_name;
3643: end if;
3644: end if;
3645: end if;
3646: lv_element_archived := 'N';
3856: ** when archiving the Current Action. If it has been archived
3857: ** skip the element
3858: **********************************************************/
3859: ln_step := 15;
3860: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3861: for i in pay_ac_action_arch.emp_elements_tab.first ..
3862: pay_ac_action_arch.emp_elements_tab.last loop
3863:
3864: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3857: ** skip the element
3858: **********************************************************/
3859: ln_step := 15;
3860: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3861: for i in pay_ac_action_arch.emp_elements_tab.first ..
3862: pay_ac_action_arch.emp_elements_tab.last loop
3863:
3864: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3865: = ln_primary_balance_id and
3858: **********************************************************/
3859: ln_step := 15;
3860: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3861: for i in pay_ac_action_arch.emp_elements_tab.first ..
3862: pay_ac_action_arch.emp_elements_tab.last loop
3863:
3864: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3865: = ln_primary_balance_id and
3866: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3860: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3861: for i in pay_ac_action_arch.emp_elements_tab.first ..
3862: pay_ac_action_arch.emp_elements_tab.last loop
3863:
3864: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3865: = ln_primary_balance_id and
3866: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3867: = lv_jurisdiction_code then
3868:
3862: pay_ac_action_arch.emp_elements_tab.last loop
3863:
3864: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3865: = ln_primary_balance_id and
3866: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3867: = lv_jurisdiction_code then
3868:
3869: hr_utility.set_location(gv_package || lv_procedure_name, 65);
3870: lv_element_archived := 'Y';
3875:
3876: if lv_element_archived = 'N' then
3877: ln_step := 20;
3878: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3879: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3880: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
3881: := ln_element_type_id;
3882: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3883: := lv_element_classification_name;
3876: if lv_element_archived = 'N' then
3877: ln_step := 20;
3878: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3879: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3880: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
3881: := ln_element_type_id;
3882: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3883: := lv_element_classification_name;
3884: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3878: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3879: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3880: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
3881: := ln_element_type_id;
3882: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3883: := lv_element_classification_name;
3884: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3885: := lv_reporting_name;
3886: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3880: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
3881: := ln_element_type_id;
3882: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3883: := lv_element_classification_name;
3884: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3885: := lv_reporting_name;
3886: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3887: := ln_primary_balance_id;
3888: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
3882: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3883: := lv_element_classification_name;
3884: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3885: := lv_reporting_name;
3886: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3887: := ln_primary_balance_id;
3888: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
3889: := ln_processing_priority;
3890: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
3884: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3885: := lv_reporting_name;
3886: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3887: := ln_primary_balance_id;
3888: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
3889: := ln_processing_priority;
3890: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
3891: := ln_hours_balance_id;
3892: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3886: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3887: := ln_primary_balance_id;
3888: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
3889: := ln_processing_priority;
3890: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
3891: := ln_hours_balance_id;
3892: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3893: := lv_jurisdiction_code;
3894:
3888: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
3889: := ln_processing_priority;
3890: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
3891: := ln_hours_balance_id;
3892: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3893: := lv_jurisdiction_code;
3894:
3895: /*****************************************************************
3896: ** The Payment Assignemnt Action is not passed to this procedure
3944: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3945:
3946:
3947: ln_step := 30;
3948: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3949: for i in pay_ac_action_arch.lrr_act_tab.first ..
3950: pay_ac_action_arch.lrr_act_tab.last loop
3951:
3952: hr_utility.trace('after populate_elements ftp' ||
3945:
3946:
3947: ln_step := 30;
3948: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3949: for i in pay_ac_action_arch.lrr_act_tab.first ..
3950: pay_ac_action_arch.lrr_act_tab.last loop
3951:
3952: hr_utility.trace('after populate_elements ftp' ||
3953: ' action_context_id is ' ||
3946:
3947: ln_step := 30;
3948: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3949: for i in pay_ac_action_arch.lrr_act_tab.first ..
3950: pay_ac_action_arch.lrr_act_tab.last loop
3951:
3952: hr_utility.trace('after populate_elements ftp' ||
3953: ' action_context_id is ' ||
3954: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
3950: pay_ac_action_arch.lrr_act_tab.last loop
3951:
3952: hr_utility.trace('after populate_elements ftp' ||
3953: ' action_context_id is ' ||
3954: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
3955: hr_utility.trace('action_info_category ' ||
3956: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3957: hr_utility.trace('act_info1 is ' ||
3958: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3952: hr_utility.trace('after populate_elements ftp' ||
3953: ' action_context_id is ' ||
3954: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
3955: hr_utility.trace('action_info_category ' ||
3956: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3957: hr_utility.trace('act_info1 is ' ||
3958: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3959: hr_utility.trace('act_info10 ' ||
3960: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3954: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
3955: hr_utility.trace('action_info_category ' ||
3956: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3957: hr_utility.trace('act_info1 is ' ||
3958: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3959: hr_utility.trace('act_info10 ' ||
3960: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3961: hr_utility.trace('act_info3 ' ||
3962: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3956: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3957: hr_utility.trace('act_info1 is ' ||
3958: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3959: hr_utility.trace('act_info10 ' ||
3960: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3961: hr_utility.trace('act_info3 ' ||
3962: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3963: hr_utility.trace('act_info4 ' ||
3964: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3958: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3959: hr_utility.trace('act_info10 ' ||
3960: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3961: hr_utility.trace('act_info3 ' ||
3962: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3963: hr_utility.trace('act_info4 ' ||
3964: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3965: hr_utility.trace('act_info5 ' ||
3966: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3960: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3961: hr_utility.trace('act_info3 ' ||
3962: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3963: hr_utility.trace('act_info4 ' ||
3964: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3965: hr_utility.trace('act_info5 ' ||
3966: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3967: hr_utility.trace('act_info6 ' ||
3968: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3962: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3963: hr_utility.trace('act_info4 ' ||
3964: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3965: hr_utility.trace('act_info5 ' ||
3966: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3967: hr_utility.trace('act_info6 ' ||
3968: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3969: hr_utility.trace('act_info7 ' ||
3970: pay_ac_action_arch.lrr_act_tab(i).act_info7);
3964: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3965: hr_utility.trace('act_info5 ' ||
3966: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3967: hr_utility.trace('act_info6 ' ||
3968: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3969: hr_utility.trace('act_info7 ' ||
3970: pay_ac_action_arch.lrr_act_tab(i).act_info7);
3971: hr_utility.trace('act_info8 ' ||
3972: pay_ac_action_arch.lrr_act_tab(i).act_info8);
3966: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3967: hr_utility.trace('act_info6 ' ||
3968: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3969: hr_utility.trace('act_info7 ' ||
3970: pay_ac_action_arch.lrr_act_tab(i).act_info7);
3971: hr_utility.trace('act_info8 ' ||
3972: pay_ac_action_arch.lrr_act_tab(i).act_info8);
3973:
3974: end loop;
3968: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3969: hr_utility.trace('act_info7 ' ||
3970: pay_ac_action_arch.lrr_act_tab(i).act_info7);
3971: hr_utility.trace('act_info8 ' ||
3972: pay_ac_action_arch.lrr_act_tab(i).act_info8);
3973:
3974: end loop;
3975: end if;
3976:
3976:
3977: hr_utility.set_location(gv_package || lv_procedure_name, 110);
3978:
3979: ln_step := 35;
3980: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3981: for j in pay_ac_action_arch.emp_elements_tab.first ..
3982: pay_ac_action_arch.emp_elements_tab.last loop
3983:
3984: hr_utility.trace('EMP_ELEMENTS_TAB.element_type ' ||
3977: hr_utility.set_location(gv_package || lv_procedure_name, 110);
3978:
3979: ln_step := 35;
3980: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3981: for j in pay_ac_action_arch.emp_elements_tab.first ..
3982: pay_ac_action_arch.emp_elements_tab.last loop
3983:
3984: hr_utility.trace('EMP_ELEMENTS_TAB.element_type ' ||
3985: to_char(pay_ac_action_arch.emp_elements_tab(j).element_type_id));
3978:
3979: ln_step := 35;
3980: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3981: for j in pay_ac_action_arch.emp_elements_tab.first ..
3982: pay_ac_action_arch.emp_elements_tab.last loop
3983:
3984: hr_utility.trace('EMP_ELEMENTS_TAB.element_type ' ||
3985: to_char(pay_ac_action_arch.emp_elements_tab(j).element_type_id));
3986: end loop;
3981: for j in pay_ac_action_arch.emp_elements_tab.first ..
3982: pay_ac_action_arch.emp_elements_tab.last loop
3983:
3984: hr_utility.trace('EMP_ELEMENTS_TAB.element_type ' ||
3985: to_char(pay_ac_action_arch.emp_elements_tab(j).element_type_id));
3986: end loop;
3987: end if;
3988:
3989: hr_utility.set_location(gv_package || lv_procedure_name, 200);
4145:
4146: BEGIN
4147: ln_step := 1;
4148: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4149: if pay_ac_action_arch.lrr_act_tab.count > 0 then
4150: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4151:
4152: ln_step := 2;
4153: for i in pay_ac_action_arch.lrr_act_tab.first ..
4149: if pay_ac_action_arch.lrr_act_tab.count > 0 then
4150: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4151:
4152: ln_step := 2;
4153: for i in pay_ac_action_arch.lrr_act_tab.first ..
4154: pay_ac_action_arch.lrr_act_tab.last loop
4155:
4156: if pay_ac_action_arch.lrr_act_tab(i).action_context_id
4157: = p_xfr_action_id then
4150: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4151:
4152: ln_step := 2;
4153: for i in pay_ac_action_arch.lrr_act_tab.first ..
4154: pay_ac_action_arch.lrr_act_tab.last loop
4155:
4156: if pay_ac_action_arch.lrr_act_tab(i).action_context_id
4157: = p_xfr_action_id then
4158: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
4152: ln_step := 2;
4153: for i in pay_ac_action_arch.lrr_act_tab.first ..
4154: pay_ac_action_arch.lrr_act_tab.last loop
4155:
4156: if pay_ac_action_arch.lrr_act_tab(i).action_context_id
4157: = p_xfr_action_id then
4158: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
4159: = 'AC EARNINGS' then
4160: if pay_ac_action_arch.lrr_act_tab(i).act_info1
4154: pay_ac_action_arch.lrr_act_tab.last loop
4155:
4156: if pay_ac_action_arch.lrr_act_tab(i).action_context_id
4157: = p_xfr_action_id then
4158: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
4159: = 'AC EARNINGS' then
4160: if pay_ac_action_arch.lrr_act_tab(i).act_info1
4161: = 'Earnings' then
4162: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4156: if pay_ac_action_arch.lrr_act_tab(i).action_context_id
4157: = p_xfr_action_id then
4158: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
4159: = 'AC EARNINGS' then
4160: if pay_ac_action_arch.lrr_act_tab(i).act_info1
4161: = 'Earnings' then
4162: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4163: ln_step := 3;
4164: lv_earnings
4162: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4163: ln_step := 3;
4164: lv_earnings
4165: := lv_earnings +
4166: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4167: lv_ytd_earnings
4168: := lv_ytd_earnings +
4169: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4170: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4165: := lv_earnings +
4166: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4167: lv_ytd_earnings
4168: := lv_ytd_earnings +
4169: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4170: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4171: = 'Supplemental Earnings' then
4172: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4173: ln_step := 4;
4166: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4167: lv_ytd_earnings
4168: := lv_ytd_earnings +
4169: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4170: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4171: = 'Supplemental Earnings' then
4172: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4173: ln_step := 4;
4174: lv_supplemental_earnings
4172: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4173: ln_step := 4;
4174: lv_supplemental_earnings
4175: := lv_supplemental_earnings +
4176: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4177: lv_ytd_supplemental_earnings
4178: := lv_ytd_supplemental_earnings +
4179: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4180: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4175: := lv_supplemental_earnings +
4176: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4177: lv_ytd_supplemental_earnings
4178: := lv_ytd_supplemental_earnings +
4179: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4180: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4181: = 'Imputed Earnings' then
4182: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4183: ln_step := 5;
4176: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4177: lv_ytd_supplemental_earnings
4178: := lv_ytd_supplemental_earnings +
4179: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4180: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4181: = 'Imputed Earnings' then
4182: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4183: ln_step := 5;
4184: lv_imputed_earnings
4182: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4183: ln_step := 5;
4184: lv_imputed_earnings
4185: := lv_imputed_earnings +
4186: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4187: lv_ytd_imputed_earnings
4188: := lv_ytd_imputed_earnings +
4189: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4190: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4185: := lv_imputed_earnings +
4186: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4187: lv_ytd_imputed_earnings
4188: := lv_ytd_imputed_earnings +
4189: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4190: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4191: = 'Non-payroll Payments' then
4192: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4193: ln_step := 6;
4186: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4187: lv_ytd_imputed_earnings
4188: := lv_ytd_imputed_earnings +
4189: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4190: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4191: = 'Non-payroll Payments' then
4192: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4193: ln_step := 6;
4194: lv_non_payroll_payments
4192: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4193: ln_step := 6;
4194: lv_non_payroll_payments
4195: := lv_non_payroll_payments +
4196: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4197: lv_ytd_non_payroll_payments
4198: := lv_ytd_non_payroll_payments +
4199: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4200: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4195: := lv_non_payroll_payments +
4196: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4197: lv_ytd_non_payroll_payments
4198: := lv_ytd_non_payroll_payments +
4199: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4200: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4201: = 'Taxable Benefits' then
4202: hr_utility.set_location(gv_package || lv_procedure_name, 55);
4203: ln_step := 7;
4196: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4197: lv_ytd_non_payroll_payments
4198: := lv_ytd_non_payroll_payments +
4199: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4200: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4201: = 'Taxable Benefits' then
4202: hr_utility.set_location(gv_package || lv_procedure_name, 55);
4203: ln_step := 7;
4204: lv_taxable_benefits
4202: hr_utility.set_location(gv_package || lv_procedure_name, 55);
4203: ln_step := 7;
4204: lv_taxable_benefits
4205: := lv_taxable_benefits +
4206: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4207: lv_ytd_taxable_benefits
4208: := lv_ytd_taxable_benefits +
4209: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4210: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4205: := lv_taxable_benefits +
4206: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4207: lv_ytd_taxable_benefits
4208: := lv_ytd_taxable_benefits +
4209: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4210: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4211: = 'Alien/Expat Earnings' then
4212: hr_utility.set_location(gv_package || lv_procedure_name, 56);
4213: ln_step := 8;
4206: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4207: lv_ytd_taxable_benefits
4208: := lv_ytd_taxable_benefits +
4209: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4210: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4211: = 'Alien/Expat Earnings' then
4212: hr_utility.set_location(gv_package || lv_procedure_name, 56);
4213: ln_step := 8;
4214: lv_alien_expat_earnings
4212: hr_utility.set_location(gv_package || lv_procedure_name, 56);
4213: ln_step := 8;
4214: lv_alien_expat_earnings
4215: := lv_alien_expat_earnings +
4216: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4217: lv_ytd_alien_expat_earnings
4218: := lv_ytd_alien_expat_earnings +
4219: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4220: end if;
4215: := lv_alien_expat_earnings +
4216: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4217: lv_ytd_alien_expat_earnings
4218: := lv_ytd_alien_expat_earnings +
4219: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4220: end if;
4221:
4222: elsif pay_ac_action_arch.lrr_act_tab(i).action_info_category
4223: = 'AC DEDUCTIONS' then
4218: := lv_ytd_alien_expat_earnings +
4219: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4220: end if;
4221:
4222: elsif pay_ac_action_arch.lrr_act_tab(i).action_info_category
4223: = 'AC DEDUCTIONS' then
4224: if pay_ac_action_arch.lrr_act_tab(i).act_info1
4225: = 'Pre-Tax Deductions' then
4226: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4220: end if;
4221:
4222: elsif pay_ac_action_arch.lrr_act_tab(i).action_info_category
4223: = 'AC DEDUCTIONS' then
4224: if pay_ac_action_arch.lrr_act_tab(i).act_info1
4225: = 'Pre-Tax Deductions' then
4226: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4227: ln_step := 15;
4228: lv_pre_tax_deductions
4226: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4227: ln_step := 15;
4228: lv_pre_tax_deductions
4229: := lv_pre_tax_deductions +
4230: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4231: lv_ytd_pre_tax_deductions
4232: := lv_ytd_pre_tax_deductions +
4233: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4234: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4229: := lv_pre_tax_deductions +
4230: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4231: lv_ytd_pre_tax_deductions
4232: := lv_ytd_pre_tax_deductions +
4233: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4234: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4235: = 'Involuntary Deductions' then
4236: hr_utility.set_location(gv_package || lv_procedure_name, 70);
4237: ln_step := 16;
4230: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4231: lv_ytd_pre_tax_deductions
4232: := lv_ytd_pre_tax_deductions +
4233: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4234: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4235: = 'Involuntary Deductions' then
4236: hr_utility.set_location(gv_package || lv_procedure_name, 70);
4237: ln_step := 16;
4238: lv_involuntary_deductions
4236: hr_utility.set_location(gv_package || lv_procedure_name, 70);
4237: ln_step := 16;
4238: lv_involuntary_deductions
4239: := lv_involuntary_deductions +
4240: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4241: lv_ytd_involuntary_deductions
4242: := lv_ytd_involuntary_deductions +
4243: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4244: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4239: := lv_involuntary_deductions +
4240: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4241: lv_ytd_involuntary_deductions
4242: := lv_ytd_involuntary_deductions +
4243: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4244: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4245: = 'Voluntary Deductions' then
4246: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4247: ln_step := 17;
4240: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4241: lv_ytd_involuntary_deductions
4242: := lv_ytd_involuntary_deductions +
4243: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4244: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4245: = 'Voluntary Deductions' then
4246: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4247: ln_step := 17;
4248: lv_voluntary_deductions
4246: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4247: ln_step := 17;
4248: lv_voluntary_deductions
4249: := lv_voluntary_deductions +
4250: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4251: lv_ytd_voluntary_deductions
4252: := lv_ytd_voluntary_deductions +
4253: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4254: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4249: := lv_voluntary_deductions +
4250: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4251: lv_ytd_voluntary_deductions
4252: := lv_ytd_voluntary_deductions +
4253: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4254: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4255: = 'Tax Deductions' then
4256: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4257: ln_step := 18;
4250: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4251: lv_ytd_voluntary_deductions
4252: := lv_ytd_voluntary_deductions +
4253: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4254: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4255: = 'Tax Deductions' then
4256: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4257: ln_step := 18;
4258: lv_tax_deductions
4256: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4257: ln_step := 18;
4258: lv_tax_deductions
4259: := lv_tax_deductions +
4260: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4261: lv_ytd_tax_deductions
4262: := lv_ytd_tax_deductions +
4263: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4264: end if;
4259: := lv_tax_deductions +
4260: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4261: lv_ytd_tax_deductions
4262: := lv_ytd_tax_deductions +
4263: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4264: end if;
4265: end if;
4266: end if;
4267: end loop;
4269:
4270: hr_utility.set_location(gv_package || lv_procedure_name, 95);
4271: ln_step := 24;
4272: j := 0;
4273: if pay_ac_action_arch.ltr_summary_labels.count > 0 then
4274: for j in pay_ac_action_arch.ltr_summary_labels.first..
4275: pay_ac_action_arch.ltr_summary_labels.last loop
4276: if pay_ac_action_arch.ltr_summary_labels(j).language
4277: = pay_ac_action_arch.gv_person_lang and
4270: hr_utility.set_location(gv_package || lv_procedure_name, 95);
4271: ln_step := 24;
4272: j := 0;
4273: if pay_ac_action_arch.ltr_summary_labels.count > 0 then
4274: for j in pay_ac_action_arch.ltr_summary_labels.first..
4275: pay_ac_action_arch.ltr_summary_labels.last loop
4276: if pay_ac_action_arch.ltr_summary_labels(j).language
4277: = pay_ac_action_arch.gv_person_lang and
4278: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'CURRENT' then
4271: ln_step := 24;
4272: j := 0;
4273: if pay_ac_action_arch.ltr_summary_labels.count > 0 then
4274: for j in pay_ac_action_arch.ltr_summary_labels.first..
4275: pay_ac_action_arch.ltr_summary_labels.last loop
4276: if pay_ac_action_arch.ltr_summary_labels(j).language
4277: = pay_ac_action_arch.gv_person_lang and
4278: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'CURRENT' then
4279: lv_current_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
4272: j := 0;
4273: if pay_ac_action_arch.ltr_summary_labels.count > 0 then
4274: for j in pay_ac_action_arch.ltr_summary_labels.first..
4275: pay_ac_action_arch.ltr_summary_labels.last loop
4276: if pay_ac_action_arch.ltr_summary_labels(j).language
4277: = pay_ac_action_arch.gv_person_lang and
4278: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'CURRENT' then
4279: lv_current_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
4280: end if;
4273: if pay_ac_action_arch.ltr_summary_labels.count > 0 then
4274: for j in pay_ac_action_arch.ltr_summary_labels.first..
4275: pay_ac_action_arch.ltr_summary_labels.last loop
4276: if pay_ac_action_arch.ltr_summary_labels(j).language
4277: = pay_ac_action_arch.gv_person_lang and
4278: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'CURRENT' then
4279: lv_current_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
4280: end if;
4281:
4274: for j in pay_ac_action_arch.ltr_summary_labels.first..
4275: pay_ac_action_arch.ltr_summary_labels.last loop
4276: if pay_ac_action_arch.ltr_summary_labels(j).language
4277: = pay_ac_action_arch.gv_person_lang and
4278: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'CURRENT' then
4279: lv_current_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
4280: end if;
4281:
4282: if pay_ac_action_arch.ltr_summary_labels(j).language
4275: pay_ac_action_arch.ltr_summary_labels.last loop
4276: if pay_ac_action_arch.ltr_summary_labels(j).language
4277: = pay_ac_action_arch.gv_person_lang and
4278: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'CURRENT' then
4279: lv_current_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
4280: end if;
4281:
4282: if pay_ac_action_arch.ltr_summary_labels(j).language
4283: = pay_ac_action_arch.gv_person_lang and
4278: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'CURRENT' then
4279: lv_current_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
4280: end if;
4281:
4282: if pay_ac_action_arch.ltr_summary_labels(j).language
4283: = pay_ac_action_arch.gv_person_lang and
4284: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'YTD' then
4285: lv_ytd_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
4286: end if;
4279: lv_current_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
4280: end if;
4281:
4282: if pay_ac_action_arch.ltr_summary_labels(j).language
4283: = pay_ac_action_arch.gv_person_lang and
4284: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'YTD' then
4285: lv_ytd_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
4286: end if;
4287: end loop;
4280: end if;
4281:
4282: if pay_ac_action_arch.ltr_summary_labels(j).language
4283: = pay_ac_action_arch.gv_person_lang and
4284: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'YTD' then
4285: lv_ytd_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
4286: end if;
4287: end loop;
4288: end if;
4281:
4282: if pay_ac_action_arch.ltr_summary_labels(j).language
4283: = pay_ac_action_arch.gv_person_lang and
4284: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'YTD' then
4285: lv_ytd_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
4286: end if;
4287: end loop;
4288: end if;
4289:
4288: end if;
4289:
4290: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4291: /* Insert one row for CURRENT and one for YTD */
4292: if pay_ac_action_arch.lrr_act_tab.count > 0 then
4293: ln_step := 25;
4294: -- CURRENT
4295: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4296: hr_utility.trace('ln_index = ' || ln_index);
4291: /* Insert one row for CURRENT and one for YTD */
4292: if pay_ac_action_arch.lrr_act_tab.count > 0 then
4293: ln_step := 25;
4294: -- CURRENT
4295: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4296: hr_utility.trace('ln_index = ' || ln_index);
4297: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4298: := 'AC SUMMARY CURRENT';
4299: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4293: ln_step := 25;
4294: -- CURRENT
4295: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4296: hr_utility.trace('ln_index = ' || ln_index);
4297: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4298: := 'AC SUMMARY CURRENT';
4299: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4300: := '00-000-0000';
4301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
4295: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4296: hr_utility.trace('ln_index = ' || ln_index);
4297: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4298: := 'AC SUMMARY CURRENT';
4299: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4300: := '00-000-0000';
4301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
4302: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
4303: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4297: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4298: := 'AC SUMMARY CURRENT';
4299: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4300: := '00-000-0000';
4301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
4302: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
4303: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4304: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
4305: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4299: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4300: := '00-000-0000';
4301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
4302: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
4303: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4304: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
4305: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4306: := fnd_number.number_to_canonical(lv_imputed_earnings);
4307: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
4302: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
4303: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4304: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
4305: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4306: := fnd_number.number_to_canonical(lv_imputed_earnings);
4307: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4308: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
4309: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4303: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4304: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
4305: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4306: := fnd_number.number_to_canonical(lv_imputed_earnings);
4307: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4308: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
4309: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4310: := fnd_number.number_to_canonical(lv_involuntary_deductions);
4311: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4305: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4306: := fnd_number.number_to_canonical(lv_imputed_earnings);
4307: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4308: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
4309: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4310: := fnd_number.number_to_canonical(lv_involuntary_deductions);
4311: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4312: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
4313: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4307: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4308: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
4309: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4310: := fnd_number.number_to_canonical(lv_involuntary_deductions);
4311: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4312: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
4313: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4314: := fnd_number.number_to_canonical(lv_tax_deductions) ;
4315: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4309: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4310: := fnd_number.number_to_canonical(lv_involuntary_deductions);
4311: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4312: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
4313: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4314: := fnd_number.number_to_canonical(lv_tax_deductions) ;
4315: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4316: := fnd_number.number_to_canonical(lv_taxable_benefits);
4317: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4311: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4312: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
4313: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4314: := fnd_number.number_to_canonical(lv_tax_deductions) ;
4315: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4316: := fnd_number.number_to_canonical(lv_taxable_benefits);
4317: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4318: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
4319: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
4313: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4314: := fnd_number.number_to_canonical(lv_tax_deductions) ;
4315: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4316: := fnd_number.number_to_canonical(lv_taxable_benefits);
4317: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4318: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
4319: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
4320: := fnd_number.number_to_canonical(lv_non_payroll_payments);
4321: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4315: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4316: := fnd_number.number_to_canonical(lv_taxable_benefits);
4317: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4318: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
4319: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
4320: := fnd_number.number_to_canonical(lv_non_payroll_payments);
4321: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4322: := lv_current_label;
4323:
4317: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4318: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
4319: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
4320: := fnd_number.number_to_canonical(lv_non_payroll_payments);
4321: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4322: := lv_current_label;
4323:
4324: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4325: -- YTD
4322: := lv_current_label;
4323:
4324: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4325: -- YTD
4326: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4327: hr_utility.trace('ln_index = ' || ln_index);
4328: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4329: := 'AC SUMMARY YTD';
4330: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4324: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4325: -- YTD
4326: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4327: hr_utility.trace('ln_index = ' || ln_index);
4328: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4329: := 'AC SUMMARY YTD';
4330: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4331: := '00-000-0000';
4332: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
4326: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4327: hr_utility.trace('ln_index = ' || ln_index);
4328: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4329: := 'AC SUMMARY YTD';
4330: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4331: := '00-000-0000';
4332: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
4333: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
4334: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4328: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4329: := 'AC SUMMARY YTD';
4330: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4331: := '00-000-0000';
4332: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
4333: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
4334: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4335: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
4336: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4330: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4331: := '00-000-0000';
4332: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
4333: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
4334: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4335: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
4336: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4337: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
4338: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4332: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
4333: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
4334: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4335: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
4336: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4337: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
4338: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4339: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
4340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4334: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4335: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
4336: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4337: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
4338: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4339: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
4340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4341: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
4342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4336: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4337: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
4338: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4339: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
4340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4341: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
4342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4343: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
4344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4338: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4339: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
4340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4341: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
4342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4343: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
4344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4345: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
4346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4341: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
4342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4343: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
4344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4345: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
4346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4347: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
4348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4343: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
4344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4345: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
4346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4347: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
4348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4349: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
4350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
4344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4345: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
4346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4347: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
4348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4349: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
4350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
4351: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
4352: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4347: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
4348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4349: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
4350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
4351: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
4352: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4353: := lv_ytd_label;
4354: end if;
4348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4349: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
4350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
4351: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
4352: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4353: := lv_ytd_label;
4354: end if;
4355:
4356: hr_utility.set_location(gv_package || lv_procedure_name, 200);
4505:
4506:
4507: if nvl(ln_ytd_amount, 0) <> 0 then
4508: ln_step := 70;
4509: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
4510:
4511: hr_utility.trace('ln_element_index = '||ln_element_index);
4512:
4513: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
4509: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
4510:
4511: hr_utility.trace('ln_element_index = '||ln_element_index);
4512:
4513: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
4514: := ln_element_type_id;
4515: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
4516: := lv_element_classification_name;
4517: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
4511: hr_utility.trace('ln_element_index = '||ln_element_index);
4512:
4513: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
4514: := ln_element_type_id;
4515: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
4516: := lv_element_classification_name;
4517: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
4518: := lv_reporting_name;
4519: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4513: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
4514: := ln_element_type_id;
4515: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
4516: := lv_element_classification_name;
4517: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
4518: := lv_reporting_name;
4519: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4520: := ln_primary_balance_id;
4521: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
4515: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
4516: := lv_element_classification_name;
4517: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
4518: := lv_reporting_name;
4519: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4520: := ln_primary_balance_id;
4521: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
4522: := ln_processing_priority;
4523: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
4517: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
4518: := lv_reporting_name;
4519: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4520: := ln_primary_balance_id;
4521: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
4522: := ln_processing_priority;
4523: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
4524: := ln_hours_balance_id;
4525: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
4519: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4520: := ln_primary_balance_id;
4521: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
4522: := ln_processing_priority;
4523: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
4524: := ln_hours_balance_id;
4525: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
4526: := lv_jurisdiction_code;
4527:
4521: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
4522: := ln_processing_priority;
4523: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
4524: := ln_hours_balance_id;
4525: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
4526: := lv_jurisdiction_code;
4527:
4528:
4529: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4525: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
4526: := lv_jurisdiction_code;
4527:
4528:
4529: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4530: hr_utility.trace('ln_index = '||ln_index);
4531: if lv_element_classification_name in ('Earnings',
4532: 'Supplemental Earnings',
4533: 'Taxable Benefits',
4538: lv_action_category := 'AC EARNINGS';
4539: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4540: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4541: ln_step := 80;
4542: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4543: := fnd_number.number_to_canonical(ln_current_hours); /*Bug 3311866*/
4544: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4545: := fnd_number.number_to_canonical(ln_ytd_hours);
4546: else
4540: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4541: ln_step := 80;
4542: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4543: := fnd_number.number_to_canonical(ln_current_hours); /*Bug 3311866*/
4544: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4545: := fnd_number.number_to_canonical(ln_ytd_hours);
4546: else
4547: lv_action_category := 'AC DEDUCTIONS';
4548: end if;
4552: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4553: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4554: ln_step := 90;
4555:
4556: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4557: := lv_action_category;
4558: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4559: := nvl(lv_jurisdiction_code, '00-000-0000');
4560: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4554: ln_step := 90;
4555:
4556: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4557: := lv_action_category;
4558: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4559: := nvl(lv_jurisdiction_code, '00-000-0000');
4560: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4561: := p_xfr_action_id;
4562: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
4556: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4557: := lv_action_category;
4558: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4559: := nvl(lv_jurisdiction_code, '00-000-0000');
4560: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4561: := p_xfr_action_id;
4562: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
4563: := lv_element_classification_name;
4564: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
4558: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4559: := nvl(lv_jurisdiction_code, '00-000-0000');
4560: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4561: := p_xfr_action_id;
4562: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
4563: := lv_element_classification_name;
4564: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
4565: := ln_element_type_id;
4566: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4560: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4561: := p_xfr_action_id;
4562: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
4563: := lv_element_classification_name;
4564: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
4565: := ln_element_type_id;
4566: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4567: := ln_primary_balance_id;
4568: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4562: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
4563: := lv_element_classification_name;
4564: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
4565: := ln_element_type_id;
4566: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4567: := ln_primary_balance_id;
4568: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4569: := ln_processing_priority;
4570: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4564: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
4565: := ln_element_type_id;
4566: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4567: := ln_primary_balance_id;
4568: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4569: := ln_processing_priority;
4570: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4571: := fnd_number.number_to_canonical(ln_payments_amount); /*Bug 3311866*/
4572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4566: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4567: := ln_primary_balance_id;
4568: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4569: := ln_processing_priority;
4570: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4571: := fnd_number.number_to_canonical(ln_payments_amount); /*Bug 3311866*/
4572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4573: := fnd_number.number_to_canonical(ln_ytd_amount);
4574: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4568: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4569: := ln_processing_priority;
4570: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4571: := fnd_number.number_to_canonical(ln_payments_amount); /*Bug 3311866*/
4572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4573: := fnd_number.number_to_canonical(ln_ytd_amount);
4574: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4575: := lv_reporting_name;
4576:
4570: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4571: := fnd_number.number_to_canonical(ln_payments_amount); /*Bug 3311866*/
4572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4573: := fnd_number.number_to_canonical(ln_ytd_amount);
4574: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4575: := lv_reporting_name;
4576:
4577: end if;
4578: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4581: CLOSE c_prev_ytd_action_elements;
4582:
4583: ln_step := 110;
4584: hr_utility.trace('------------Looping to see pl/sql table --------');
4585: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4586: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4587:
4588: hr_utility.trace('ln_check_count = '||ln_check_count);
4589: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4582:
4583: ln_step := 110;
4584: hr_utility.trace('------------Looping to see pl/sql table --------');
4585: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4586: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4587:
4588: hr_utility.trace('ln_check_count = '||ln_check_count);
4589: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4590: hr_utility.trace('============= End of Processing '||p_assignment_id||
5152:
5153: lv_action_category := 'AC DEDUCTIONS';
5154:
5155: ln_step := 15;
5156: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5157: if p_element_classification_name in ('Earnings',
5158: 'Supplemental Earnings',
5159: 'Taxable Benefits',
5160: 'Imputed Earnings',
5161: 'Non-payroll Payments',
5162: 'Alien/Expat Earnings') then
5163: lv_action_category := 'AC EARNINGS';
5164:
5165: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5166: := fnd_number.number_to_canonical(ln_hours);
5167: -- YTD Hours
5168: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
5169: := round(ln_rate,2);
5164:
5165: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5166: := fnd_number.number_to_canonical(ln_hours);
5167: -- YTD Hours
5168: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
5169: := round(ln_rate,2);
5170:
5171: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5172: := fnd_number.number_to_canonical(0);
5167: -- YTD Hours
5168: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
5169: := round(ln_rate,2);
5170:
5171: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5172: := fnd_number.number_to_canonical(0);
5173: end if; -- Classification Earnings
5174:
5175: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5175: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5176: /* Insert this into the plsql table if Current or YTD
5177: amount is not Zero */
5178: ln_step :=21;
5179: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5180: := lv_action_category;
5181: ln_step :=22;
5182: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5183: := '00-000-0000' ;
5178: ln_step :=21;
5179: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5180: := lv_action_category;
5181: ln_step :=22;
5182: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5183: := '00-000-0000' ;
5184: ln_step :=23;
5185: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
5186: := p_xfr_action_id;
5181: ln_step :=22;
5182: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5183: := '00-000-0000' ;
5184: ln_step :=23;
5185: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
5186: := p_xfr_action_id;
5187: ln_step :=24;
5188: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
5189: := p_element_classification_name;
5184: ln_step :=23;
5185: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
5186: := p_xfr_action_id;
5187: ln_step :=24;
5188: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
5189: := p_element_classification_name;
5190: ln_step :=25;
5191: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
5192: := p_element_type_id;
5187: ln_step :=24;
5188: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
5189: := p_element_classification_name;
5190: ln_step :=25;
5191: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
5192: := p_element_type_id;
5193: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5194: := p_primary_balance_id;
5195: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5189: := p_element_classification_name;
5190: ln_step :=25;
5191: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
5192: := p_element_type_id;
5193: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5194: := p_primary_balance_id;
5195: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5196: := p_processing_priority;
5197: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5191: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
5192: := p_element_type_id;
5193: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5194: := p_primary_balance_id;
5195: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5196: := p_processing_priority;
5197: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5198: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5199: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5193: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5194: := p_primary_balance_id;
5195: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5196: := p_processing_priority;
5197: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5198: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5199: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5200: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5201: := p_reporting_name;
5196: := p_processing_priority;
5197: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5198: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5199: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5200: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5201: := p_reporting_name;
5202: IF lv_action_category = 'AC DEDUCTIONS' THEN
5203: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
5204: := p_reporting_name;
5199: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5200: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5201: := p_reporting_name;
5202: IF lv_action_category = 'AC DEDUCTIONS' THEN
5203: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
5204: := p_reporting_name;
5205: END IF;
5206: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
5207: := lv_original_date_earned;
5202: IF lv_action_category = 'AC DEDUCTIONS' THEN
5203: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
5204: := p_reporting_name;
5205: END IF;
5206: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
5207: := lv_original_date_earned;
5208: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
5209: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
5210: := lv_effective_start_date;
5205: END IF;
5206: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
5207: := lv_original_date_earned;
5208: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
5209: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
5210: := lv_effective_start_date;
5211: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5212: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5213: := lv_effective_end_date ;
5208: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
5209: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
5210: := lv_effective_start_date;
5211: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5212: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5213: := lv_effective_end_date ;
5214: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5215: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5216: := lv_category;
5211: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5212: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5213: := lv_effective_end_date ;
5214: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5215: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5216: := lv_category;
5217: hr_utility.trace('lv_category ' || lv_category );
5218: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5219: := lv_jurisdiction_flag;
5214: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5215: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5216: := lv_category;
5217: hr_utility.trace('lv_category ' || lv_category );
5218: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5219: := lv_jurisdiction_flag;
5220: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5221: := fnd_number.number_to_canonical(0);
5222:
5216: := lv_category;
5217: hr_utility.trace('lv_category ' || lv_category );
5218: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5219: := lv_jurisdiction_flag;
5220: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5221: := fnd_number.number_to_canonical(0);
5222:
5223: hr_utility.set_location(gv_package || lv_procedure_name, 150);
5224:
5282: hr_utility.set_location(gv_package || lv_procedure_name, 60);
5283: end if;
5284: end if;
5285:
5286: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5287: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5288: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5289:
5290: /*Bug# 13785386 - Start*/
5294: end if;
5295: */
5296: /*Bug# 13785386 - End*/
5297:
5298: if pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5299: = 'AC EARNINGS' then
5300:
5301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5302: := fnd_number.number_to_canonical(ln_ytd_hours); -- Bug# 13877047
5297:
5298: if pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5299: = 'AC EARNINGS' then
5300:
5301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5302: := fnd_number.number_to_canonical(ln_ytd_hours); -- Bug# 13877047
5303: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5304: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5305:
5308: ELSE
5309: -- Global Variable Setting Needed Here
5310: -- That Can be Subtracted during Base Population
5311: --
5312: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5313: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5314: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5315: gv_ytd_amount := ln_ytd_amount ;
5316: /*gv_ytd_amount := nvl(gv_ytd_amount,0)+ln_ytd_amount ; --Bug# 13785386 */
5314: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5315: gv_ytd_amount := ln_ytd_amount ;
5316: /*gv_ytd_amount := nvl(gv_ytd_amount,0)+ln_ytd_amount ; --Bug# 13785386 */
5317:
5318: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5319: := fnd_number.number_to_canonical(ln_ytd_hours); -- Bug# 13877047
5320: gv_ytd_hour := ln_ytd_hours ;
5321: /*gv_ytd_hour := nvl(gv_ytd_hour,0)+ln_ytd_hours ; --Bug# 13785386 */
5322:
5701:
5702: hr_utility.trace('lv_jurisdiction_flag := '||lv_jurisdiction_flag);
5703: lv_action_category := 'AC EARNINGS';
5704: ln_step := 15;
5705: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5706:
5707: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5708: := fnd_number.number_to_canonical(ln_hours);
5709: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
5703: lv_action_category := 'AC EARNINGS';
5704: ln_step := 15;
5705: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5706:
5707: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5708: := fnd_number.number_to_canonical(ln_hours);
5709: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
5710: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5711: /* Insert this into the plsql table if Current or YTD
5705: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5706:
5707: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5708: := fnd_number.number_to_canonical(ln_hours);
5709: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
5710: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5711: /* Insert this into the plsql table if Current or YTD
5712: amount is not Zero */
5713: ln_step :=21;
5710: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5711: /* Insert this into the plsql table if Current or YTD
5712: amount is not Zero */
5713: ln_step :=21;
5714: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5715: := lv_action_category;
5716: ln_step :=22;
5717: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5718: := '00-000-0000' ;
5713: ln_step :=21;
5714: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5715: := lv_action_category;
5716: ln_step :=22;
5717: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5718: := '00-000-0000' ;
5719: ln_step :=23;
5720: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
5721: := p_xfr_action_id;
5716: ln_step :=22;
5717: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5718: := '00-000-0000' ;
5719: ln_step :=23;
5720: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
5721: := p_xfr_action_id;
5722: ln_step :=24;
5723: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
5724: := p_element_classification_name;
5719: ln_step :=23;
5720: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
5721: := p_xfr_action_id;
5722: ln_step :=24;
5723: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
5724: := p_element_classification_name;
5725: ln_step :=25;
5726: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
5727: := p_element_type_id;
5722: ln_step :=24;
5723: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
5724: := p_element_classification_name;
5725: ln_step :=25;
5726: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
5727: := p_element_type_id;
5728: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5729: := p_primary_balance_id;
5730: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5724: := p_element_classification_name;
5725: ln_step :=25;
5726: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
5727: := p_element_type_id;
5728: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5729: := p_primary_balance_id;
5730: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5731: := p_processing_priority;
5732: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5726: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
5727: := p_element_type_id;
5728: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5729: := p_primary_balance_id;
5730: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5731: := p_processing_priority;
5732: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5733: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5734: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5728: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5729: := p_primary_balance_id;
5730: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5731: := p_processing_priority;
5732: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5733: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5734: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5735: := fnd_number.number_to_canonical(0);
5736:
5730: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5731: := p_processing_priority;
5732: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5733: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5734: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5735: := fnd_number.number_to_canonical(0);
5736:
5737: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5738: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5734: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5735: := fnd_number.number_to_canonical(0);
5736:
5737: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5738: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5739: := p_reporting_name;
5740:
5741: IF lv_temp_AAA <> 'AAA' THEN
5742: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
5738: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5739: := p_reporting_name;
5740:
5741: IF lv_temp_AAA <> 'AAA' THEN
5742: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
5743: := lv_original_date_earned;
5744: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
5745:
5746: IF lv_check_date = nvl(lv_original_date_earned,p_pymt_eff_date) THEN
5745:
5746: IF lv_check_date = nvl(lv_original_date_earned,p_pymt_eff_date) THEN
5747: count_j := ln_index;
5748: END IF;
5749: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
5750: := lv_effective_start_date;
5751: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5752: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5753: := lv_effective_end_date ;
5748: END IF;
5749: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
5750: := lv_effective_start_date;
5751: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5752: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5753: := lv_effective_end_date ;
5754: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5755: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5756: := lv_category;
5751: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5752: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5753: := lv_effective_end_date ;
5754: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5755: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5756: := lv_category;
5757: hr_utility.trace('lv_category ' || lv_category );
5758: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5759: := lv_jurisdiction_flag;
5754: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5755: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5756: := lv_category;
5757: hr_utility.trace('lv_category ' || lv_category );
5758: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5759: := lv_jurisdiction_flag;
5760: END IF;
5761:
5762: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
5758: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5759: := lv_jurisdiction_flag;
5760: END IF;
5761:
5762: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
5763: := round(ln_rate,2);
5764: /*
5765: IF pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 IS NULL THEN
5766: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := 'N/A';
5761:
5762: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
5763: := round(ln_rate,2);
5764: /*
5765: IF pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 IS NULL THEN
5766: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := 'N/A';
5767: END IF;
5768: */
5769:
5762: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
5763: := round(ln_rate,2);
5764: /*
5765: IF pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 IS NULL THEN
5766: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := 'N/A';
5767: END IF;
5768: */
5769:
5770: hr_utility.set_location(gv_package || lv_procedure_name, 150);
5901: end if; -- p_pymt_balcall_aaid is not null
5902:
5903: ln_step := 15;
5904:
5905: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5906: := fnd_number.number_to_canonical(ln_ytd_amount);
5907: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
5908:
5909: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5905: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5906: := fnd_number.number_to_canonical(ln_ytd_amount);
5907: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
5908:
5909: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5910: := fnd_number.number_to_canonical(ln_ytd_hours);
5911: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5912:
5913: /* Following later to be re-valuated IF worth doing wrt Cost
5912:
5913: /* Following later to be re-valuated IF worth doing wrt Cost
5914:
5915: IF count_j is null THEN
5916: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5917: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5918: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5919: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5920: := fnd_number.number_to_canonical(ln_ytd_hours);
5915: IF count_j is null THEN
5916: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5917: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5918: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5919: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5920: := fnd_number.number_to_canonical(ln_ytd_hours);
5921: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5922: END IF;
5923: */
6313:
6314: hr_utility.trace('lv_jurisdiction_flag := '||lv_jurisdiction_flag);
6315: lv_action_category := 'AC EARNINGS';
6316: ln_step := 15;
6317: ln_index := pay_ac_action_arch.lrr_act_tab.count;
6318:
6319: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
6320: := fnd_number.number_to_canonical(ln_hours);
6321: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
6315: lv_action_category := 'AC EARNINGS';
6316: ln_step := 15;
6317: ln_index := pay_ac_action_arch.lrr_act_tab.count;
6318:
6319: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
6320: := fnd_number.number_to_canonical(ln_hours);
6321: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
6322: hr_utility.set_location(gv_package || lv_procedure_name, 130);
6323: /* Insert this into the plsql table if Current or YTD
6317: ln_index := pay_ac_action_arch.lrr_act_tab.count;
6318:
6319: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
6320: := fnd_number.number_to_canonical(ln_hours);
6321: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
6322: hr_utility.set_location(gv_package || lv_procedure_name, 130);
6323: /* Insert this into the plsql table if Current or YTD
6324: amount is not Zero */
6325: ln_step :=21;
6322: hr_utility.set_location(gv_package || lv_procedure_name, 130);
6323: /* Insert this into the plsql table if Current or YTD
6324: amount is not Zero */
6325: ln_step :=21;
6326: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
6327: := lv_action_category;
6328: ln_step :=22;
6329: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
6330: := '00-000-0000' ;
6325: ln_step :=21;
6326: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
6327: := lv_action_category;
6328: ln_step :=22;
6329: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
6330: := '00-000-0000' ;
6331: ln_step :=23;
6332: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
6333: := p_xfr_action_id;
6328: ln_step :=22;
6329: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
6330: := '00-000-0000' ;
6331: ln_step :=23;
6332: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
6333: := p_xfr_action_id;
6334: ln_step :=24;
6335: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
6336: := p_element_classification_name;
6331: ln_step :=23;
6332: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
6333: := p_xfr_action_id;
6334: ln_step :=24;
6335: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
6336: := p_element_classification_name;
6337: ln_step :=25;
6338: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
6339: := p_element_type_id;
6334: ln_step :=24;
6335: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
6336: := p_element_classification_name;
6337: ln_step :=25;
6338: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
6339: := p_element_type_id;
6340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
6341: := p_primary_balance_id;
6342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6336: := p_element_classification_name;
6337: ln_step :=25;
6338: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
6339: := p_element_type_id;
6340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
6341: := p_primary_balance_id;
6342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6343: := p_processing_priority;
6344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6338: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
6339: := p_element_type_id;
6340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
6341: := p_primary_balance_id;
6342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6343: := p_processing_priority;
6344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6345: := fnd_number.number_to_canonical(nvl(ln_amount,0));
6346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
6341: := p_primary_balance_id;
6342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6343: := p_processing_priority;
6344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6345: := fnd_number.number_to_canonical(nvl(ln_amount,0));
6346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6347: := fnd_number.number_to_canonical(0);
6348:
6342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6343: := p_processing_priority;
6344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6345: := fnd_number.number_to_canonical(nvl(ln_amount,0));
6346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6347: := fnd_number.number_to_canonical(0);
6348:
6349: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
6350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
6346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6347: := fnd_number.number_to_canonical(0);
6348:
6349: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
6350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
6351: := p_reporting_name;
6352:
6353: IF lv_temp_AAA <> 'AAA' THEN
6354: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
6350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
6351: := p_reporting_name;
6352:
6353: IF lv_temp_AAA <> 'AAA' THEN
6354: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
6355: := lv_original_date_earned;
6356: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
6357:
6358: IF lv_check_date = nvl(lv_original_date_earned,p_pymt_eff_date) THEN
6357:
6358: IF lv_check_date = nvl(lv_original_date_earned,p_pymt_eff_date) THEN
6359: count_j := ln_index;
6360: END IF;
6361: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
6362: := lv_effective_start_date;
6363: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
6364: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
6365: := lv_effective_end_date ;
6360: END IF;
6361: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
6362: := lv_effective_start_date;
6363: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
6364: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
6365: := lv_effective_end_date ;
6366: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
6367: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
6368: := lv_category;
6363: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
6364: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
6365: := lv_effective_end_date ;
6366: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
6367: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
6368: := lv_category;
6369: hr_utility.trace('lv_category ' || lv_category );
6370: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
6371: := lv_jurisdiction_flag;
6366: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
6367: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
6368: := lv_category;
6369: hr_utility.trace('lv_category ' || lv_category );
6370: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
6371: := lv_jurisdiction_flag;
6372: END IF;
6373:
6374: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
6370: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
6371: := lv_jurisdiction_flag;
6372: END IF;
6373:
6374: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
6375: := round(ln_rate,2);
6376: /*
6377: IF pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 IS NULL THEN
6378: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := 'N/A';
6373:
6374: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
6375: := round(ln_rate,2);
6376: /*
6377: IF pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 IS NULL THEN
6378: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := 'N/A';
6379: END IF;
6380: */
6381:
6374: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
6375: := round(ln_rate,2);
6376: /*
6377: IF pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 IS NULL THEN
6378: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := 'N/A';
6379: END IF;
6380: */
6381:
6382: hr_utility.set_location(gv_package || lv_procedure_name, 150);
6513: end if; -- p_pymt_balcall_aaid is not null
6514:
6515: ln_step := 15;
6516:
6517: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6518: := fnd_number.number_to_canonical(ln_ytd_amount);
6519: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
6520:
6521: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
6517: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6518: := fnd_number.number_to_canonical(ln_ytd_amount);
6519: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
6520:
6521: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
6522: := fnd_number.number_to_canonical(ln_ytd_hours);
6523: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
6524:
6525: /* Following later to be re-valuated IF worth doing wrt Cost
6524:
6525: /* Following later to be re-valuated IF worth doing wrt Cost
6526:
6527: IF count_j is null THEN
6528: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6529: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
6530: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
6531: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
6532: := fnd_number.number_to_canonical(ln_ytd_hours);
6527: IF count_j is null THEN
6528: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6529: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
6530: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
6531: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
6532: := fnd_number.number_to_canonical(ln_ytd_hours);
6533: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
6534: END IF;
6535: */
6542: END Archive_addnl_elements;
6543:
6544:
6545:
6546: END pay_ac_action_arch;