[Home] [Help]
498: and lookup_code in ('CURRENT', 'YTD');
499:
500:
501: BEGIN
502: hr_utility.set_location(gv_package || lv_procedure_name, 10);
503: ln_step := 1;
504:
505: if pay_ac_action_arch.lrr_act_tab.count > 0 then
506: for i in pay_ac_action_arch.lrr_act_tab.first ..
566: pay_ac_action_arch.ltr_summary_labels(i).language := lbl.language;
567: pay_ac_action_arch.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
568: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
569:
570: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
571: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
572: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).meaning);
573:
574: i := i + 1;
567: pay_ac_action_arch.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
568: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
569:
570: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
571: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
572: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).meaning);
573:
574: i := i + 1;
575:
568: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
569:
570: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
571: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
572: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).meaning);
573:
574: i := i + 1;
575:
576: end loop;
576: end loop;
577:
578: end if;
579:
580: hr_utility.trace('pay_ac_action_arch.lrr_act_tab.count = ' ||
581: pay_ac_action_arch.lrr_act_tab.count);
582: hr_utility.set_location(gv_package || lv_procedure_name, 50);
583: ln_step := 10;
584:
578: end if;
579:
580: hr_utility.trace('pay_ac_action_arch.lrr_act_tab.count = ' ||
581: pay_ac_action_arch.lrr_act_tab.count);
582: hr_utility.set_location(gv_package || lv_procedure_name, 50);
583: ln_step := 10;
584:
585: EXCEPTION
586: when others then
586: when others then
587: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
588: gv_package || lv_procedure_name;
589:
590: hr_utility.trace(lv_error_message || '-' || sqlerrm);
591:
592: lv_error_message :=
593: pay_emp_action_arch.set_error_message(lv_error_message);
594:
591:
592: lv_error_message :=
593: pay_emp_action_arch.set_error_message(lv_error_message);
594:
595: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
596: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
597: hr_utility.raise_error;
598:
599: END initialization_process;
592: lv_error_message :=
593: pay_emp_action_arch.set_error_message(lv_error_message);
594:
595: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
596: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
597: hr_utility.raise_error;
598:
599: END initialization_process;
600:
593: pay_emp_action_arch.set_error_message(lv_error_message);
594:
595: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
596: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
597: hr_utility.raise_error;
598:
599: END initialization_process;
600:
601:
659: lv_error_message VARCHAR2(200);
660: ln_step NUMBER;
661:
662: BEGIN
663: hr_utility.set_location(gv_package || lv_procedure_name, 10);
664: ln_step := 1;
665: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' then
666: open c_multi_asg_prev_information(p_assignment_id,
667: p_action_info_category,
669: p_curr_effective_date);
670: fetch c_multi_asg_prev_information into ld_last_xfr_eff_date
671: ,ln_last_xfr_action_id;
672: if c_multi_asg_prev_information%notfound then
673: hr_utility.trace('This process has not been run earlier');
674: end if;
675: close c_multi_asg_prev_information;
676:
677: else
682: p_curr_effective_date);
683: fetch c_prev_run_information into ld_last_xfr_eff_date
684: ,ln_last_xfr_action_id;
685: if c_prev_run_information%notfound then
686: hr_utility.trace('This process has not been run earlier');
687: end if;
688: close c_prev_run_information ;
689: end if;
690:
695: ld_last_xfr_eff_date := null;
696: ln_last_xfr_action_id := null;
697: end if;
698: end if;
699: hr_utility.trace('ld_last_xfr_eff_date '||to_char(ld_last_xfr_eff_date));
700: hr_utility.trace('ln_last_xfr_action_id '|| ln_last_xfr_action_id);
701:
702: p_last_xfr_eff_date := ld_last_xfr_eff_date;
703: p_last_xfr_action_id := ln_last_xfr_action_id;
696: ln_last_xfr_action_id := null;
697: end if;
698: end if;
699: hr_utility.trace('ld_last_xfr_eff_date '||to_char(ld_last_xfr_eff_date));
700: hr_utility.trace('ln_last_xfr_action_id '|| ln_last_xfr_action_id);
701:
702: p_last_xfr_eff_date := ld_last_xfr_eff_date;
703: p_last_xfr_action_id := ln_last_xfr_action_id;
704:
701:
702: p_last_xfr_eff_date := ld_last_xfr_eff_date;
703: p_last_xfr_action_id := ln_last_xfr_action_id;
704:
705: hr_utility.set_location(gv_package || lv_procedure_name, 50);
706: ln_step := 10;
707:
708: EXCEPTION
709: when others then
709: when others then
710: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
711: gv_package || lv_procedure_name;
712:
713: hr_utility.trace(lv_error_message || '-' || sqlerrm);
714:
715: lv_error_message :=
716: pay_emp_action_arch.set_error_message(lv_error_message);
717:
714:
715: lv_error_message :=
716: pay_emp_action_arch.set_error_message(lv_error_message);
717:
718: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
719: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
720: hr_utility.raise_error;
721:
722: END get_last_xfr_info;
715: lv_error_message :=
716: pay_emp_action_arch.set_error_message(lv_error_message);
717:
718: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
719: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
720: hr_utility.raise_error;
721:
722: END get_last_xfr_info;
723:
716: pay_emp_action_arch.set_error_message(lv_error_message);
717:
718: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
719: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
720: hr_utility.raise_error;
721:
722: END get_last_xfr_info;
723:
724:
760: lv_error_message VARCHAR2(200);
761: ln_step NUMBER;
762:
763: BEGIN
764: hr_utility.set_location(gv_package || lv_procedure_name, 10);
765: ln_step := 1;
766: open c_last_payment_info(p_assignment_id,p_curr_pymt_eff_date);
767: fetch c_last_payment_info into ld_last_pymt_eff_date,
768: ln_last_pymt_action_id ;
771: ln_step := 5;
772: p_last_pymt_eff_date := ld_last_pymt_eff_date;
773: p_last_pymt_action_id := ln_last_pymt_action_id;
774:
775: hr_utility.set_location(gv_package || lv_procedure_name, 100);
776: ln_step := 10;
777:
778: EXCEPTION
779: when others then
779: when others then
780: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
781: gv_package || lv_procedure_name;
782:
783: hr_utility.trace(lv_error_message || '-' || sqlerrm);
784:
785: lv_error_message :=
786: pay_emp_action_arch.set_error_message(lv_error_message);
787:
784:
785: lv_error_message :=
786: pay_emp_action_arch.set_error_message(lv_error_message);
787:
788: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
789: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
790: hr_utility.raise_error;
791:
792: END get_last_pymt_info;
785: lv_error_message :=
786: pay_emp_action_arch.set_error_message(lv_error_message);
787:
788: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
789: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
790: hr_utility.raise_error;
791:
792: END get_last_pymt_info;
793:
786: pay_emp_action_arch.set_error_message(lv_error_message);
787:
788: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
789: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
790: hr_utility.raise_error;
791:
792: END get_last_pymt_info;
793:
794:
823: BEGIN
824: ln_step := 1;
825: p_rate_exists := 'N';
826:
827: hr_utility.set_location(gv_package || lv_procedure_name, 10);
828: if pay_ac_action_arch.lrr_act_tab.count > 0 then
829: for i in pay_ac_action_arch.lrr_act_tab.first..
830: pay_ac_action_arch.lrr_act_tab.last
831: loop
838: exit;
839: end if;
840: end loop;
841: end if;
842: hr_utility.trace('p_rate_exists = ' || p_rate_exists);
843:
844: hr_utility.set_location(gv_package || lv_procedure_name, 20);
845: ln_step := 10;
846:
840: end loop;
841: end if;
842: hr_utility.trace('p_rate_exists = ' || p_rate_exists);
843:
844: hr_utility.set_location(gv_package || lv_procedure_name, 20);
845: ln_step := 10;
846:
847: EXCEPTION
848: when others then
848: when others then
849: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
850: gv_package || lv_procedure_name;
851:
852: hr_utility.trace(lv_error_message || '-' || sqlerrm);
853:
854: lv_error_message :=
855: pay_emp_action_arch.set_error_message(lv_error_message);
856:
853:
854: lv_error_message :=
855: pay_emp_action_arch.set_error_message(lv_error_message);
856:
857: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
858: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
859: hr_utility.raise_error;
860:
861: END check_hours_by_rate;
854: lv_error_message :=
855: pay_emp_action_arch.set_error_message(lv_error_message);
856:
857: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
858: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
859: hr_utility.raise_error;
860:
861: END check_hours_by_rate;
862:
855: pay_emp_action_arch.set_error_message(lv_error_message);
856:
857: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
858: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
859: hr_utility.raise_error;
860:
861: END check_hours_by_rate;
862:
863:
941: ln_step NUMBER;
942:
943: BEGIN
944: ln_step := 1;
945: hr_utility.set_location(gv_package || lv_procedure_name, 10);
946: hr_utility.trace('p_pymt_assignment_action_id '
947: ||to_char(p_pymt_assignment_action_id));
948: hr_utility.trace('p_pymt_eff_date ='||to_char(p_pymt_eff_date));
949: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
942:
943: BEGIN
944: ln_step := 1;
945: hr_utility.set_location(gv_package || lv_procedure_name, 10);
946: hr_utility.trace('p_pymt_assignment_action_id '
947: ||to_char(p_pymt_assignment_action_id));
948: hr_utility.trace('p_pymt_eff_date ='||to_char(p_pymt_eff_date));
949: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
950: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
944: ln_step := 1;
945: hr_utility.set_location(gv_package || lv_procedure_name, 10);
946: hr_utility.trace('p_pymt_assignment_action_id '
947: ||to_char(p_pymt_assignment_action_id));
948: hr_utility.trace('p_pymt_eff_date ='||to_char(p_pymt_eff_date));
949: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
950: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
951: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
952: hr_utility.trace('p_reporting_name ='||p_reporting_name);
945: hr_utility.set_location(gv_package || lv_procedure_name, 10);
946: hr_utility.trace('p_pymt_assignment_action_id '
947: ||to_char(p_pymt_assignment_action_id));
948: hr_utility.trace('p_pymt_eff_date ='||to_char(p_pymt_eff_date));
949: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
950: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
951: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
952: hr_utility.trace('p_reporting_name ='||p_reporting_name);
953: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
946: hr_utility.trace('p_pymt_assignment_action_id '
947: ||to_char(p_pymt_assignment_action_id));
948: hr_utility.trace('p_pymt_eff_date ='||to_char(p_pymt_eff_date));
949: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
950: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
951: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
952: hr_utility.trace('p_reporting_name ='||p_reporting_name);
953: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
954: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
947: ||to_char(p_pymt_assignment_action_id));
948: hr_utility.trace('p_pymt_eff_date ='||to_char(p_pymt_eff_date));
949: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
950: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
951: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
952: hr_utility.trace('p_reporting_name ='||p_reporting_name);
953: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
954: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
955: hr_utility.trace('p_legislation_code ='||p_legislation_code);
948: hr_utility.trace('p_pymt_eff_date ='||to_char(p_pymt_eff_date));
949: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
950: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
951: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
952: hr_utility.trace('p_reporting_name ='||p_reporting_name);
953: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
954: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
955: hr_utility.trace('p_legislation_code ='||p_legislation_code);
956: hr_utility.trace('p_hours_balance_id ='||to_char(p_hours_balance_id));
949: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
950: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
951: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
952: hr_utility.trace('p_reporting_name ='||p_reporting_name);
953: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
954: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
955: hr_utility.trace('p_legislation_code ='||p_legislation_code);
956: hr_utility.trace('p_hours_balance_id ='||to_char(p_hours_balance_id));
957:
950: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
951: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
952: hr_utility.trace('p_reporting_name ='||p_reporting_name);
953: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
954: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
955: hr_utility.trace('p_legislation_code ='||p_legislation_code);
956: hr_utility.trace('p_hours_balance_id ='||to_char(p_hours_balance_id));
957:
958: if pay_emp_action_arch.gv_multi_leg_rule is null then
951: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
952: hr_utility.trace('p_reporting_name ='||p_reporting_name);
953: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
954: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
955: hr_utility.trace('p_legislation_code ='||p_legislation_code);
956: hr_utility.trace('p_hours_balance_id ='||to_char(p_hours_balance_id));
957:
958: if pay_emp_action_arch.gv_multi_leg_rule is null then
959: pay_emp_action_arch.gv_multi_leg_rule
952: hr_utility.trace('p_reporting_name ='||p_reporting_name);
953: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
954: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
955: hr_utility.trace('p_legislation_code ='||p_legislation_code);
956: hr_utility.trace('p_hours_balance_id ='||to_char(p_hours_balance_id));
957:
958: if pay_emp_action_arch.gv_multi_leg_rule is null then
959: pay_emp_action_arch.gv_multi_leg_rule
960: := pay_emp_action_arch.get_multi_legislative_rule(
985: p_primary_balance_id,
986: gv_ytd_balance_dimension,
987: p_legislation_code);
988:
989: hr_utility.trace('ln_ytd_defined_balance_id = ' ||
990: ln_ytd_defined_balance_id);
991:
992: ln_step := 4;
993: if p_hours_balance_id is not null then
990: ln_ytd_defined_balance_id);
991:
992: ln_step := 4;
993: if p_hours_balance_id is not null then
994: hr_utility.set_location(gv_package || lv_procedure_name, 20);
995: ln_ytd_hours_balance_id
996: := pay_emp_action_arch.get_defined_balance_id(
997: p_hours_balance_id,
998: gv_ytd_balance_dimension,
997: p_hours_balance_id,
998: gv_ytd_balance_dimension,
999: p_legislation_code);
1000:
1001: hr_utility.trace('ln_ytd_hours_balance_id = ' ||
1002: ln_ytd_hours_balance_id);
1003:
1004: end if;
1005:
1004: end if;
1005:
1006: ln_step := 5;
1007: if p_legislation_code <> 'US' then
1008: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1009: ln_step := 6;
1010: check_hours_by_rate(
1011: p_xfr_action_id => p_xfr_action_id
1012: ,p_puv_assignment_action_id => p_pymt_assignment_action_id
1023: ,p_rate_exists => lv_rate_exists
1024: );
1025: end if;
1026:
1027: hr_utility.trace('lv_rate_exists = ' || lv_rate_exists);
1028:
1029: if lv_rate_exists = 'N' then
1030: ln_step := 7;
1031: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1027: hr_utility.trace('lv_rate_exists = ' || lv_rate_exists);
1028:
1029: if lv_rate_exists = 'N' then
1030: ln_step := 7;
1031: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1032: if ln_ytd_defined_balance_id is not null then
1033: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
1034: ln_ytd_defined_balance_id,
1035: p_ytd_balcall_aaid),0);
1035: p_ytd_balcall_aaid),0);
1036: end if;
1037:
1038: if p_hours_balance_id is not null then
1039: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1040: if ln_ytd_hours_balance_id is not null then
1041: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
1042: ln_ytd_hours_balance_id,
1043: p_ytd_balcall_aaid),0);
1040: if ln_ytd_hours_balance_id is not null then
1041: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
1042: ln_ytd_hours_balance_id,
1043: p_ytd_balcall_aaid),0);
1044: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1045: end if;
1046: end if; --Hours
1047:
1048: ln_step := 8;
1071: p_legislation_code);
1072: end if;
1073: end if; -- p_action_type in ('B','V')
1074: /* end of addition for Reversals and bal adjustments */
1075: hr_utility.trace('ln_pymt_defined_balance_id ' ||
1076: ln_pymt_defined_balance_id);
1077:
1078: if ln_pymt_defined_balance_id is not null then
1079: ln_payments_amount := nvl(pay_balance_pkg.get_value(
1078: if ln_pymt_defined_balance_id is not null then
1079: ln_payments_amount := nvl(pay_balance_pkg.get_value(
1080: ln_pymt_defined_balance_id,
1081: p_pymt_balcall_aaid),0);
1082: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
1083: end if;
1084:
1085: if p_hours_balance_id is not null then
1086: /* Added dimension _ASG_GRE_RUN for reversals and Balance
1106: ,p_legislation_code);
1107: end if;
1108: end if; -- p_action_type in ('B','V')
1109: /* end of addition for reversals and bal adjustments */
1110: hr_utility.trace('ln_pymt_hours_balance_id ' ||
1111: ln_pymt_hours_balance_id);
1112:
1113: if ln_pymt_hours_balance_id is not null then
1114: ln_current_hours := nvl(pay_balance_pkg.get_value(
1114: ln_current_hours := nvl(pay_balance_pkg.get_value(
1115: ln_pymt_hours_balance_id,
1116: p_pymt_balcall_aaid),0);
1117: end if;
1118: hr_utility.set_location(gv_package || lv_procedure_name, 120);
1119: end if; --Hours
1120: end if; -- p_pymt_balcall_aaid is not null
1121:
1122: ln_step := 15;
1127: 'Taxable Benefits',
1128: 'Imputed Earnings',
1129: 'Non-payroll Payments',
1130: 'Alien/Expat Earnings') then
1131: hr_utility.set_location(gv_package || lv_procedure_name, 125);
1132: lv_action_category := 'AC EARNINGS';
1133: /* bug 6702864 We are not subtracting the Retro amount from the base element so added the if condition */
1134: /* pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1135: := fnd_number.number_to_canonical(ln_current_hours);
1158: := fnd_number.number_to_canonical((ln_ytd_hours) - gv_ytd_hour);
1159: END IF;
1160: end if;
1161:
1162: hr_utility.set_location(gv_package || lv_procedure_name, 130);
1163: /* Insert this into the plsql table if Current or YTD
1164: amount is not Zero */
1165: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1166: := lv_action_category;
1188: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1189: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0) - gv_ytd_amount);
1190: END IF;
1191:
1192: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_payments_amount,0)));
1193:
1194: IF p_ytd_flag = 'N' then
1195: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1196: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
1205: := p_reporting_name;
1206: END IF;
1207: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
1208: := p_original_date_earned;
1209: hr_utility.trace('p_original_date_earned :=' || p_original_date_earned );
1210: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
1211: := p_effective_start_date;
1212: hr_utility.trace('p_effective_start_date := ' || p_effective_start_date );
1213: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
1208: := p_original_date_earned;
1209: hr_utility.trace('p_original_date_earned :=' || p_original_date_earned );
1210: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
1211: := p_effective_start_date;
1212: hr_utility.trace('p_effective_start_date := ' || p_effective_start_date );
1213: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
1214: := p_effective_end_date ;
1215: hr_utility.trace('p_effective_end_date:= ' || p_effective_end_date );
1216: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
1211: := p_effective_start_date;
1212: hr_utility.trace('p_effective_start_date := ' || p_effective_start_date );
1213: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
1214: := p_effective_end_date ;
1215: hr_utility.trace('p_effective_end_date:= ' || p_effective_end_date );
1216: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
1217: := p_category;
1218: hr_utility.trace('p_category ' || p_category );
1219: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
1214: := p_effective_end_date ;
1215: hr_utility.trace('p_effective_end_date:= ' || p_effective_end_date );
1216: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
1217: := p_category;
1218: hr_utility.trace('p_category ' || p_category );
1219: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
1220: := p_el_jurisdiction_code;
1221:
1222: end if;
1224: end if; -- lv_rate_exists = 'N'
1225:
1226:
1227:
1228: hr_utility.set_location(gv_package || lv_procedure_name, 150);
1229: ln_step := 20;
1230:
1231: EXCEPTION
1232: when others then
1229: ln_step := 20;
1230:
1231: EXCEPTION
1232: when others then
1233: hr_utility.set_location(gv_package || lv_procedure_name, 200);
1234: lv_error_message := 'Error at step ' || ln_step ||
1235: ' in ' || gv_package || lv_procedure_name;
1236:
1237: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1233: hr_utility.set_location(gv_package || lv_procedure_name, 200);
1234: lv_error_message := 'Error at step ' || ln_step ||
1235: ' in ' || gv_package || lv_procedure_name;
1236:
1237: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1238:
1239: lv_error_message :=
1240: pay_emp_action_arch.set_error_message(lv_error_message);
1241:
1238:
1239: lv_error_message :=
1240: pay_emp_action_arch.set_error_message(lv_error_message);
1241:
1242: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1243: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1244: hr_utility.raise_error;
1245:
1246: END populate_elements;
1239: lv_error_message :=
1240: pay_emp_action_arch.set_error_message(lv_error_message);
1241:
1242: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1243: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1244: hr_utility.raise_error;
1245:
1246: END populate_elements;
1247:
1240: pay_emp_action_arch.set_error_message(lv_error_message);
1241:
1242: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1243: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1244: hr_utility.raise_error;
1245:
1246: END populate_elements;
1247:
1248: /******************************************************************
1389: BEGIN
1390:
1391:
1392: ln_step := 1;
1393: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1394: hr_utility.trace('HBR p_curr_pymt_action_id : ' || p_curr_pymt_action_id);
1395: hr_utility.trace('HBR p_assignment_id : ' || p_assignment_id);
1396:
1397: hbr.delete;
1390:
1391:
1392: ln_step := 1;
1393: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1394: hr_utility.trace('HBR p_curr_pymt_action_id : ' || p_curr_pymt_action_id);
1395: hr_utility.trace('HBR p_assignment_id : ' || p_assignment_id);
1396:
1397: hbr.delete;
1398: ln_tot_pymt_amt := 0;
1391:
1392: ln_step := 1;
1393: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1394: hr_utility.trace('HBR p_curr_pymt_action_id : ' || p_curr_pymt_action_id);
1395: hr_utility.trace('HBR p_assignment_id : ' || p_assignment_id);
1396:
1397: hbr.delete;
1398: ln_tot_pymt_amt := 0;
1399:
1402: fetch c_run_aa_id into ln_assignment_action_id
1403: ,ln_run_type_id;
1404: exit when c_run_aa_id%notfound;
1405:
1406: hr_utility.trace('HBR ln_assignment_action_id : ' ||
1407: ln_assignment_action_id);
1408:
1409: ln_step := 2;
1410:
1421: end loop;
1422: close c_run_aa_id;
1423:
1424: if hbr.count > 0 then
1425: hr_utility.trace(' I came in first if ');
1426:
1427: for j in hbr.first..hbr.last + 1
1428: loop
1429:
1427: for j in hbr.first..hbr.last + 1
1428: loop
1429:
1430: if ( j <> i ) then
1431: hr_utility.trace(' It came here one');
1432: ln_element_type_id := hbr(j).element_type_id;
1433: lv_element_name := hbr(j).element_name;
1434: ln_processing_priority := hbr(j).processing_priority;
1435: ln_rate := hbr(j).rate;
1435: ln_rate := hbr(j).rate;
1436: ln_multiple := hbr(j).multiple;
1437: ln_hours := hbr(j).hours;
1438: ln_amount := hbr(j).amount;
1439: hr_utility.trace('element_type_id'||hbr(j).element_type_id);
1440: hr_utility.trace('element_name'||hbr(j).element_name);
1441: hr_utility.trace('hbr(j).rate'||hbr(j).rate);
1442: end if;
1443:
1436: ln_multiple := hbr(j).multiple;
1437: ln_hours := hbr(j).hours;
1438: ln_amount := hbr(j).amount;
1439: hr_utility.trace('element_type_id'||hbr(j).element_type_id);
1440: hr_utility.trace('element_name'||hbr(j).element_name);
1441: hr_utility.trace('hbr(j).rate'||hbr(j).rate);
1442: end if;
1443:
1444: ln_step := 3;
1437: ln_hours := hbr(j).hours;
1438: ln_amount := hbr(j).amount;
1439: hr_utility.trace('element_type_id'||hbr(j).element_type_id);
1440: hr_utility.trace('element_name'||hbr(j).element_name);
1441: hr_utility.trace('hbr(j).rate'||hbr(j).rate);
1442: end if;
1443:
1444: ln_step := 3;
1445:
1447: prev_element_type_id <> -1 ) or
1448: ( j = i )
1449: ) then
1450:
1451: hr_utility.trace('I came here two');
1452:
1453: ln_step := 5;
1454: if gv_reporting_level = 'TAXGRP' then
1455: ln_tg_ytd_defined_bal_id
1495: p_ytd_balcall_aaid),0);
1496: end if;
1497: end if;
1498:
1499: hr_utility.trace('ytd balance = ' || ln_ytd_amount);
1500: hr_utility.trace('ytd hours = ' || ln_ytd_hours);
1501: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1502: := ln_ytd_amount;
1503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1496: end if;
1497: end if;
1498:
1499: hr_utility.trace('ytd balance = ' || ln_ytd_amount);
1500: hr_utility.trace('ytd hours = ' || ln_ytd_hours);
1501: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1502: := ln_ytd_amount;
1503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1504: := ln_ytd_hours;
1515: ln_pymt_bal_amt := nvl(pay_balance_pkg.get_value(
1516: ln_pymt_def_bal_id,
1517: p_pymt_balcall_aaid),0);
1518:
1519: hr_utility.trace('ln_pymt_bal_amt : '||ln_pymt_bal_amt);
1520: hr_utility.trace('ln_tot_pymt_amt : '||ln_tot_pymt_amt);
1521: hr_utility.trace('prev_element_type_id: '||prev_element_type_id);
1522: hr_utility.trace('prev_run_asg_act_id : '||prev_run_asg_act_id);
1523:
1516: ln_pymt_def_bal_id,
1517: p_pymt_balcall_aaid),0);
1518:
1519: hr_utility.trace('ln_pymt_bal_amt : '||ln_pymt_bal_amt);
1520: hr_utility.trace('ln_tot_pymt_amt : '||ln_tot_pymt_amt);
1521: hr_utility.trace('prev_element_type_id: '||prev_element_type_id);
1522: hr_utility.trace('prev_run_asg_act_id : '||prev_run_asg_act_id);
1523:
1524: IF ( ln_tot_pymt_amt <> ln_pymt_bal_amt ) THEN
1517: p_pymt_balcall_aaid),0);
1518:
1519: hr_utility.trace('ln_pymt_bal_amt : '||ln_pymt_bal_amt);
1520: hr_utility.trace('ln_tot_pymt_amt : '||ln_tot_pymt_amt);
1521: hr_utility.trace('prev_element_type_id: '||prev_element_type_id);
1522: hr_utility.trace('prev_run_asg_act_id : '||prev_run_asg_act_id);
1523:
1524: IF ( ln_tot_pymt_amt <> ln_pymt_bal_amt ) THEN
1525:
1518:
1519: hr_utility.trace('ln_pymt_bal_amt : '||ln_pymt_bal_amt);
1520: hr_utility.trace('ln_tot_pymt_amt : '||ln_tot_pymt_amt);
1521: hr_utility.trace('prev_element_type_id: '||prev_element_type_id);
1522: hr_utility.trace('prev_run_asg_act_id : '||prev_run_asg_act_id);
1523:
1524: IF ( ln_tot_pymt_amt <> ln_pymt_bal_amt ) THEN
1525:
1526: hr_utility.trace('i came here third');
1522: hr_utility.trace('prev_run_asg_act_id : '||prev_run_asg_act_id);
1523:
1524: IF ( ln_tot_pymt_amt <> ln_pymt_bal_amt ) THEN
1525:
1526: hr_utility.trace('i came here third');
1527:
1528: OPEN c_retro(prev_run_asg_act_id, prev_element_type_id);
1529: LOOP
1530: hr_utility.set_location(gv_package || lv_procedure_name,55);
1526: hr_utility.trace('i came here third');
1527:
1528: OPEN c_retro(prev_run_asg_act_id, prev_element_type_id);
1529: LOOP
1530: hr_utility.set_location(gv_package || lv_procedure_name,55);
1531: fetch c_retro into ln_retro_element_entry
1532: ,ln_retro_payvalue
1533: ,ln_retro_hours
1534: ,ln_retro_multiple
1536: if c_retro%notfound then
1537: exit;
1538: end if;
1539:
1540: hr_utility.trace('HBR Retro Values');
1541: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1542: hr_utility.trace('Hours ='|| ln_retro_hours);
1543: hr_utility.trace('Rate ='|| ln_retro_rate);
1544: hr_utility.trace('Multiple ='|| ln_retro_multiple);
1537: exit;
1538: end if;
1539:
1540: hr_utility.trace('HBR Retro Values');
1541: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1542: hr_utility.trace('Hours ='|| ln_retro_hours);
1543: hr_utility.trace('Rate ='|| ln_retro_rate);
1544: hr_utility.trace('Multiple ='|| ln_retro_multiple);
1545:
1538: end if;
1539:
1540: hr_utility.trace('HBR Retro Values');
1541: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1542: hr_utility.trace('Hours ='|| ln_retro_hours);
1543: hr_utility.trace('Rate ='|| ln_retro_rate);
1544: hr_utility.trace('Multiple ='|| ln_retro_multiple);
1545:
1546: IF nvl(ln_retro_multiple,0) = 0 THEN
1539:
1540: hr_utility.trace('HBR Retro Values');
1541: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1542: hr_utility.trace('Hours ='|| ln_retro_hours);
1543: hr_utility.trace('Rate ='|| ln_retro_rate);
1544: hr_utility.trace('Multiple ='|| ln_retro_multiple);
1545:
1546: IF nvl(ln_retro_multiple,0) = 0 THEN
1547: ln_retro_multiple := 1;
1540: hr_utility.trace('HBR Retro Values');
1541: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1542: hr_utility.trace('Hours ='|| ln_retro_hours);
1543: hr_utility.trace('Rate ='|| ln_retro_rate);
1544: hr_utility.trace('Multiple ='|| ln_retro_multiple);
1545:
1546: IF nvl(ln_retro_multiple,0) = 0 THEN
1547: ln_retro_multiple := 1;
1548: END IF;
1547: ln_retro_multiple := 1;
1548: END IF;
1549:
1550: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1551: hr_utility.trace('ln_index = ' || ln_index);
1552:
1553:
1554: ln_step := 20;
1555: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1558: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1559: := '00-000-0000';
1560: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1561: := lv_classification_name;
1562: hr_utility.trace('action_info_category' || lv_classification_name);
1563: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1564: := prev_element_type_id;
1565: hr_utility.trace('act_info2' || prev_element_type_id);
1566: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1561: := lv_classification_name;
1562: hr_utility.trace('action_info_category' || lv_classification_name);
1563: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1564: := prev_element_type_id;
1565: hr_utility.trace('act_info2' || prev_element_type_id);
1566: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1567: := ln_primary_balance_id;
1568: hr_utility.trace('act_info6' || ln_primary_balance_id);
1569: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1564: := prev_element_type_id;
1565: hr_utility.trace('act_info2' || prev_element_type_id);
1566: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1567: := ln_primary_balance_id;
1568: hr_utility.trace('act_info6' || ln_primary_balance_id);
1569: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1570: := ln_processing_priority;
1571: hr_utility.trace('act_info7' || ln_processing_priority);
1572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1567: := ln_primary_balance_id;
1568: hr_utility.trace('act_info6' || ln_primary_balance_id);
1569: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1570: := ln_processing_priority;
1571: hr_utility.trace('act_info7' || ln_processing_priority);
1572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1573: := fnd_number.number_to_canonical(ln_retro_payvalue);
1574: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));
1575: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1570: := ln_processing_priority;
1571: hr_utility.trace('act_info7' || ln_processing_priority);
1572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1573: := fnd_number.number_to_canonical(ln_retro_payvalue);
1574: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));
1575: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1576: := 0;
1577: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1578: := lv_reporting_name;
1575: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1576: := 0;
1577: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1578: := lv_reporting_name;
1579: hr_utility.trace('act_info10' || lv_reporting_name);
1580: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1581: := fnd_number.number_to_canonical(ln_retro_hours);
1582: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));
1583: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1578: := lv_reporting_name;
1579: hr_utility.trace('act_info10' || lv_reporting_name);
1580: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1581: := fnd_number.number_to_canonical(ln_retro_hours);
1582: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));
1583: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1584: := p_xfr_action_id;
1585: hr_utility.trace('action_context_id' || p_xfr_action_id);
1586:
1581: := fnd_number.number_to_canonical(ln_retro_hours);
1582: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));
1583: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1584: := p_xfr_action_id;
1585: hr_utility.trace('action_context_id' || p_xfr_action_id);
1586:
1587: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1588: := fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple);
1589: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1585: hr_utility.trace('action_context_id' || p_xfr_action_id);
1586:
1587: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1588: := fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple);
1589: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1590: END LOOP;
1591: CLOSE c_retro;
1592: hr_utility.set_location(gv_package || lv_procedure_name, 77);
1593:
1588: := fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple);
1589: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1590: END LOOP;
1591: CLOSE c_retro;
1592: hr_utility.set_location(gv_package || lv_procedure_name, 77);
1593:
1594: END IF;
1595:
1596: ln_tot_pymt_amt := 0;
1600: exit;
1601: end if;
1602: end if;
1603:
1604: hr_utility.trace('lv_element_name = ' || lv_element_name);
1605: hr_utility.trace('ln_rate = ' || ln_rate);
1606: hr_utility.trace('ln_amount = ' || ln_amount);
1607: hr_utility.trace('ln_multiple = ' || ln_multiple);
1608: hr_utility.trace('ln_hours = ' || ln_hours);
1601: end if;
1602: end if;
1603:
1604: hr_utility.trace('lv_element_name = ' || lv_element_name);
1605: hr_utility.trace('ln_rate = ' || ln_rate);
1606: hr_utility.trace('ln_amount = ' || ln_amount);
1607: hr_utility.trace('ln_multiple = ' || ln_multiple);
1608: hr_utility.trace('ln_hours = ' || ln_hours);
1609:
1602: end if;
1603:
1604: hr_utility.trace('lv_element_name = ' || lv_element_name);
1605: hr_utility.trace('ln_rate = ' || ln_rate);
1606: hr_utility.trace('ln_amount = ' || ln_amount);
1607: hr_utility.trace('ln_multiple = ' || ln_multiple);
1608: hr_utility.trace('ln_hours = ' || ln_hours);
1609:
1610: lv_reporting_name := lv_element_name;
1603:
1604: hr_utility.trace('lv_element_name = ' || lv_element_name);
1605: hr_utility.trace('ln_rate = ' || ln_rate);
1606: hr_utility.trace('ln_amount = ' || ln_amount);
1607: hr_utility.trace('ln_multiple = ' || ln_multiple);
1608: hr_utility.trace('ln_hours = ' || ln_hours);
1609:
1610: lv_reporting_name := lv_element_name;
1611:
1604: hr_utility.trace('lv_element_name = ' || lv_element_name);
1605: hr_utility.trace('ln_rate = ' || ln_rate);
1606: hr_utility.trace('ln_amount = ' || ln_amount);
1607: hr_utility.trace('ln_multiple = ' || ln_multiple);
1608: hr_utility.trace('ln_hours = ' || ln_hours);
1609:
1610: lv_reporting_name := lv_element_name;
1611:
1612: ln_step := 15;
1629: ln_tot_pymt_amt := ln_tot_pymt_amt + ln_payments_amount;
1630:
1631: /*Insert this into the plsql table */
1632:
1633: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1634: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1635: hr_utility.trace('ln_index = ' || ln_index);
1636:
1637:
1631: /*Insert this into the plsql table */
1632:
1633: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1634: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1635: hr_utility.trace('ln_index = ' || ln_index);
1636:
1637:
1638: ln_step := 20;
1639: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1641: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1642: := '00-000-0000';
1643: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1644: := lv_classification_name;
1645: hr_utility.trace('action_info_category2' || lv_classification_name);
1646: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1647: := ln_element_type_id;
1648: hr_utility.trace('act_info22' || prev_element_type_id);
1649: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1644: := lv_classification_name;
1645: hr_utility.trace('action_info_category2' || lv_classification_name);
1646: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1647: := ln_element_type_id;
1648: hr_utility.trace('act_info22' || prev_element_type_id);
1649: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1650: := ln_primary_balance_id;
1651: hr_utility.trace('act_info62' || ln_primary_balance_id);
1652: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1647: := ln_element_type_id;
1648: hr_utility.trace('act_info22' || prev_element_type_id);
1649: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1650: := ln_primary_balance_id;
1651: hr_utility.trace('act_info62' || ln_primary_balance_id);
1652: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1653: := ln_processing_priority;
1654: hr_utility.trace('act_info72' || ln_processing_priority);
1655: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1650: := ln_primary_balance_id;
1651: hr_utility.trace('act_info62' || ln_primary_balance_id);
1652: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1653: := ln_processing_priority;
1654: hr_utility.trace('act_info72' || ln_processing_priority);
1655: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1656: := fnd_number.number_to_canonical(ln_payments_amount);
1657: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1658: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1653: := ln_processing_priority;
1654: hr_utility.trace('act_info72' || ln_processing_priority);
1655: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1656: := fnd_number.number_to_canonical(ln_payments_amount);
1657: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1658: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1659: := fnd_number.number_to_canonical(ln_ytd_amount);
1660:
1661: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1659: := fnd_number.number_to_canonical(ln_ytd_amount);
1660:
1661: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1662: := lv_reporting_name;
1663: hr_utility.trace('act_info102' || lv_reporting_name);
1664: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1665: := fnd_number.number_to_canonical(ln_hours);
1666: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1667: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1662: := lv_reporting_name;
1663: hr_utility.trace('act_info102' || lv_reporting_name);
1664: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1665: := fnd_number.number_to_canonical(ln_hours);
1666: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1667: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1668: := p_xfr_action_id;
1669: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1670: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1669: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1670: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1671: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1672: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1673: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1674: prev_element_type_id := ln_element_type_id;
1675: prev_run_asg_act_id := hbr(j).run_asg_act_id;
1676: end loop;
1677: end if;
1675: prev_run_asg_act_id := hbr(j).run_asg_act_id;
1676: end loop;
1677: end if;
1678:
1679: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1680: ln_step := 25;
1681: --hr_utility.trace_off;
1682:
1683: EXCEPTION
1677: end if;
1678:
1679: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1680: ln_step := 25;
1681: --hr_utility.trace_off;
1682:
1683: EXCEPTION
1684: when others then
1685: lv_error_message := 'Error at step ' || ln_step ||
1684: when others then
1685: lv_error_message := 'Error at step ' || ln_step ||
1686: ' in ' || gv_package || lv_procedure_name;
1687:
1688: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1689:
1690: lv_error_message :=
1691: pay_emp_action_arch.set_error_message(lv_error_message);
1692:
1689:
1690: lv_error_message :=
1691: pay_emp_action_arch.set_error_message(lv_error_message);
1692:
1693: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1694: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1695: hr_utility.raise_error;
1696:
1697: END populate_hours_x_rate;
1690: lv_error_message :=
1691: pay_emp_action_arch.set_error_message(lv_error_message);
1692:
1693: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1694: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1695: hr_utility.raise_error;
1696:
1697: END populate_hours_x_rate;
1698:
1691: pay_emp_action_arch.set_error_message(lv_error_message);
1692:
1693: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1694: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1695: hr_utility.raise_error;
1696:
1697: END populate_hours_x_rate;
1698:
1699:
2049:
2050: BEGIN
2051: ln_flag := 0;
2052: ln_step := 1;
2053: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2054: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
2055: hr_utility.trace('p_assignment_id ' || p_assignment_id);
2056: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2057: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2050: BEGIN
2051: ln_flag := 0;
2052: ln_step := 1;
2053: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2054: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
2055: hr_utility.trace('p_assignment_id ' || p_assignment_id);
2056: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2057: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2058: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2051: ln_flag := 0;
2052: ln_step := 1;
2053: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2054: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
2055: hr_utility.trace('p_assignment_id ' || p_assignment_id);
2056: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2057: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2058: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2059: hr_utility.trace('p_curr_pymt_action_id '
2052: ln_step := 1;
2053: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2054: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
2055: hr_utility.trace('p_assignment_id ' || p_assignment_id);
2056: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2057: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2058: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2059: hr_utility.trace('p_curr_pymt_action_id '
2060: ||to_char(p_curr_pymt_action_id ));
2053: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2054: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
2055: hr_utility.trace('p_assignment_id ' || p_assignment_id);
2056: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2057: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2058: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2059: hr_utility.trace('p_curr_pymt_action_id '
2060: ||to_char(p_curr_pymt_action_id ));
2061: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2054: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
2055: hr_utility.trace('p_assignment_id ' || p_assignment_id);
2056: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2057: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2058: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2059: hr_utility.trace('p_curr_pymt_action_id '
2060: ||to_char(p_curr_pymt_action_id ));
2061: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2062: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
2055: hr_utility.trace('p_assignment_id ' || p_assignment_id);
2056: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2057: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2058: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2059: hr_utility.trace('p_curr_pymt_action_id '
2060: ||to_char(p_curr_pymt_action_id ));
2061: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2062: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
2063: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
2057: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2058: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2059: hr_utility.trace('p_curr_pymt_action_id '
2060: ||to_char(p_curr_pymt_action_id ));
2061: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2062: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
2063: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
2064: hr_utility.trace('p_curr_pymt_eff_date '||TO_CHAR(p_curr_pymt_eff_date,'DD-MON-YYYY'));
2065:
2058: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2059: hr_utility.trace('p_curr_pymt_action_id '
2060: ||to_char(p_curr_pymt_action_id ));
2061: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2062: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
2063: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
2064: hr_utility.trace('p_curr_pymt_eff_date '||TO_CHAR(p_curr_pymt_eff_date,'DD-MON-YYYY'));
2065:
2066: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2059: hr_utility.trace('p_curr_pymt_action_id '
2060: ||to_char(p_curr_pymt_action_id ));
2061: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2062: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
2063: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
2064: hr_utility.trace('p_curr_pymt_eff_date '||TO_CHAR(p_curr_pymt_eff_date,'DD-MON-YYYY'));
2065:
2066: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2067:
2060: ||to_char(p_curr_pymt_action_id ));
2061: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2062: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
2063: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
2064: hr_utility.trace('p_curr_pymt_eff_date '||TO_CHAR(p_curr_pymt_eff_date,'DD-MON-YYYY'));
2065:
2066: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2067:
2068: if p_legislation_code <> 'US' then
2062: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
2063: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
2064: hr_utility.trace('p_curr_pymt_eff_date '||TO_CHAR(p_curr_pymt_eff_date,'DD-MON-YYYY'));
2065:
2066: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2067:
2068: if p_legislation_code <> 'US' then
2069: ln_step := 5;
2070: populate_hours_x_rate(p_xfr_action_id => p_xfr_action_id
2108: ln_primary_balance_id,
2109: ln_hours_balance_id,
2110: ln_processing_priority;
2111: if c_cur_sp_action_elements%notfound then
2112: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2113: exit;
2114: end if;
2115:
2116: elsif p_sepchk_flag = 'N' then
2122: ln_hours_balance_id,
2123: ln_processing_priority;
2124: --- here one thing can be added
2125: if c_cur_action_elements%notfound then
2126: hr_utility.set_location(gv_package || lv_procedure_name, 35);
2127: exit;
2128: end if;
2129:
2130: end if;
2130: end if;
2131: -- loop with the first coursor (if not found then exit )
2132: -- if the parameters from second cursor not null then exit loop else move in loop completly
2133:
2134: hr_utility.trace('Element_type_id in get_current_elements = ' || ln_element_type_id);
2135:
2136: if p_legislation_code <> 'US' then
2137: lv_retro_flag := 'N' ;
2138: lv_retro_parent_flag := 'N';
2175: ELSE
2176: ln_flag :=0; -- Addl Ele DFF Info Configured
2177: END IF;
2178:
2179: hr_utility.trace('Step 100: ln_flag before entering into Ele Entry LOOP : '||ln_flag);
2180:
2181: -- Following Code May Need revise
2182: -- Here we are NOT Looping Through the Ele Entries
2183: -- But Getting ele Entry ID so that we Can Check if Addl Ele Entry Configured
2191:
2192: FETCH get_element_entry_id INTO ln_element_entry_id;
2193: IF get_element_entry_id%found THEN
2194: CLOSE get_element_entry_id;
2195: hr_utility.trace('Ele Entry Found. ln_element_entry_id := '||ln_element_entry_id);
2196:
2197: IF ln_flag = 0 then -- Addl Ele DFF Info Configured
2198: hr_utility.trace('Addl Ele DFF Info Configured.');
2199:
2194: CLOSE get_element_entry_id;
2195: hr_utility.trace('Ele Entry Found. ln_element_entry_id := '||ln_element_entry_id);
2196:
2197: IF ln_flag = 0 then -- Addl Ele DFF Info Configured
2198: hr_utility.trace('Addl Ele DFF Info Configured.');
2199:
2200: SELECT TO_CHAR(TRUNC(fnd_date.canonical_to_date(fnd_date.date_to_canonical(p_curr_pymt_eff_date))),'DD-MON-YYYY')
2201: INTO lv_curr_pymt_eff_date
2202: FROM DUAL;
2204: OPEN get_payroll_date_earned (ln_run_assignment_action_id);
2205: FETCH get_payroll_date_earned INTO l_date_earned;
2206: CLOSE get_payroll_date_earned;
2207: --bug no 6950970 ends here
2208: hr_utility.trace('lv_curr_pymt_eff_date := '|| lv_curr_pymt_eff_date);
2209: hr_utility.trace('l_date_earned := '|| l_date_earned);
2210: lv_sqlstr := 'select nvl(' || lv_application_column_name ||
2211: ',''AAA'') from pay_element_entries_f where element_entry_id = ' || ln_element_entry_id
2212: ||' AND '
2205: FETCH get_payroll_date_earned INTO l_date_earned;
2206: CLOSE get_payroll_date_earned;
2207: --bug no 6950970 ends here
2208: hr_utility.trace('lv_curr_pymt_eff_date := '|| lv_curr_pymt_eff_date);
2209: hr_utility.trace('l_date_earned := '|| l_date_earned);
2210: lv_sqlstr := 'select nvl(' || lv_application_column_name ||
2211: ',''AAA'') from pay_element_entries_f where element_entry_id = ' || ln_element_entry_id
2212: ||' AND '
2213: ||' TO_DATE('''
2217: --bug no 6950970 ends here
2218: ||''', ''DD-MON-YYYY'') '
2219: ||' BETWEEN effective_start_date AND effective_end_date ';
2220:
2221: hr_utility.trace('Query := '|| lv_sqlstr);
2222: --bug no 6950970 starts here
2223: begin
2224: --bug no 6950970 ends here
2225: EXECUTE IMMEDIATE lv_sqlstr INTO lv_original_date_paid ;
2224: --bug no 6950970 ends here
2225: EXECUTE IMMEDIATE lv_sqlstr INTO lv_original_date_paid ;
2226: lv_original_date_earned := lv_original_date_paid ;
2227:
2228: hr_utility.trace('lv_original_date_earned := '||lv_original_date_earned);
2229:
2230: -- Possibility of Malformed SQL (Added Spaces between)
2231:
2232: lv_sqlstr1 := 'select count(peef.' || lv_application_column_name
2240: || lv_application_column_name
2241: || ' is not null ' ;
2242:
2243: EXECUTE IMMEDIATE lv_sqlstr1 into ln_addnl_ele_num;
2244: hr_utility.trace('ln_addnl_ele_num' || ln_addnl_ele_num);
2245: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
2246: --bug no 6950970 starts here
2247: exception
2248: when no_data_found then
2241: || ' is not null ' ;
2242:
2243: EXECUTE IMMEDIATE lv_sqlstr1 into ln_addnl_ele_num;
2244: hr_utility.trace('ln_addnl_ele_num' || ln_addnl_ele_num);
2245: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
2246: --bug no 6950970 starts here
2247: exception
2248: when no_data_found then
2249: ln_addnl_ele_num:=0;
2258:
2259:
2260: IF (( lv_original_date_paid <> 'AAA' and ln_flag =0) OR (ln_addnl_ele_num > 0))THEN
2261:
2262: hr_utility.trace('(( lv_original_date_paid <> AAA and ln_flag =0) OR (ln_addnl_ele_num > 0)');
2263:
2264: IF ln_addnl_ele_num > 0 THEN
2265: hr_utility.trace('ln_addnl_ele_num > 0');
2266: Archive_addnl_elements(
2261:
2262: hr_utility.trace('(( lv_original_date_paid <> AAA and ln_flag =0) OR (ln_addnl_ele_num > 0)');
2263:
2264: IF ln_addnl_ele_num > 0 THEN
2265: hr_utility.trace('ln_addnl_ele_num > 0');
2266: Archive_addnl_elements(
2267: p_application_column_name => lv_application_column_name
2268: ,p_xfr_action_id => p_xfr_action_id
2269: ,p_assignment_id => p_assignment_id
2289: -- As Base + Addl Ele DFF Config Non-Retro Entry Both Handled above
2290: lv_retro_parent_flag := 'N';
2291: ELSE -- May Need to be Revised
2292:
2293: hr_utility.trace('ln_addnl_ele_num <= 0');
2294: open archive_non_retro_elements( ld_original_date_paid,
2295: ln_element_entry_id,
2296: ln_run_assignment_action_id ) ;
2297: fetch archive_non_retro_elements
2351: END IF; -- ln_addnl_ele_num > 0
2352: EXIT;
2353: END IF; -- lv_original_date_paid <> 'AAA' and ln_flag =0
2354:
2355: hr_utility.trace('Before Checking Retro.');
2356:
2357: -- Start Handling Retro Cases
2358: -- Checking IF Retro
2359:
2415: CLOSE get_run_action_id;
2416: END IF;
2417: END IF; -- Legislation US
2418:
2419: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2420: hr_utility.trace('Ele type id = ' || ln_element_type_id);
2421: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2422: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
2423:
2416: END IF;
2417: END IF; -- Legislation US
2418:
2419: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2420: hr_utility.trace('Ele type id = ' || ln_element_type_id);
2421: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2422: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
2423:
2424: if lv_element_classification_name like '% Deductions' then
2417: END IF; -- Legislation US
2418:
2419: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2420: hr_utility.trace('Ele type id = ' || ln_element_type_id);
2421: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2422: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
2423:
2424: if lv_element_classification_name like '% Deductions' then
2425: ln_hours_balance_id := null;
2418:
2419: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2420: hr_utility.trace('Ele type id = ' || ln_element_type_id);
2421: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2422: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
2423:
2424: if lv_element_classification_name like '% Deductions' then
2425: ln_hours_balance_id := null;
2426: end if;
2440: := ln_hours_balance_id;
2441: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2442: := '00-000-0000';
2443:
2444: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2445: ln_step := 20;
2446: IF ((lv_retro_flag = 'N' ) OR (lv_retro_parent_flag = 'Y')) THEN
2447: IF lv_original_date_earned = 'AAA' THEN
2448: lv_original_date_earned := null;
2493: close c_cur_sp_action_elements;
2494: elsif p_sepchk_flag = 'N' then
2495: close c_cur_action_elements;
2496: end if;
2497: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2498: ln_step := 25;
2499:
2500: EXCEPTION
2501: when others then
2501: when others then
2502: lv_error_message := 'Error at step ' || ln_step ||
2503: ' in ' || gv_package || lv_procedure_name;
2504:
2505: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2506:
2507: lv_error_message :=
2508: pay_emp_action_arch.set_error_message(lv_error_message);
2509:
2506:
2507: lv_error_message :=
2508: pay_emp_action_arch.set_error_message(lv_error_message);
2509:
2510: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2511: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2512: hr_utility.raise_error;
2513:
2514: END get_current_elements;
2507: lv_error_message :=
2508: pay_emp_action_arch.set_error_message(lv_error_message);
2509:
2510: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2511: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2512: hr_utility.raise_error;
2513:
2514: END get_current_elements;
2515:
2508: pay_emp_action_arch.set_error_message(lv_error_message);
2509:
2510: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2511: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2512: hr_utility.raise_error;
2513:
2514: END get_current_elements;
2515:
2516: /******************************************************************
2604: ln_assignment_id NUMBER;
2605:
2606: BEGIN
2607: ln_step:= 1;
2608: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2609: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
2610: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
2611: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
2612: hr_utility.trace('gv_multi_payroll_pymt = '||
2605:
2606: BEGIN
2607: ln_step:= 1;
2608: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2609: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
2610: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
2611: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
2612: hr_utility.trace('gv_multi_payroll_pymt = '||
2613: pay_emp_action_arch.gv_multi_payroll_pymt);
2606: BEGIN
2607: ln_step:= 1;
2608: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2609: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
2610: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
2611: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
2612: hr_utility.trace('gv_multi_payroll_pymt = '||
2613: pay_emp_action_arch.gv_multi_payroll_pymt);
2614: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
2607: ln_step:= 1;
2608: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2609: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
2610: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
2611: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
2612: hr_utility.trace('gv_multi_payroll_pymt = '||
2613: pay_emp_action_arch.gv_multi_payroll_pymt);
2614: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
2615:
2608: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2609: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
2610: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
2611: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
2612: hr_utility.trace('gv_multi_payroll_pymt = '||
2613: pay_emp_action_arch.gv_multi_payroll_pymt);
2614: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
2615:
2616: open c_last_xfr_elements(p_last_xfr_action_id, p_legislation_code);
2610: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
2611: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
2612: hr_utility.trace('gv_multi_payroll_pymt = '||
2613: pay_emp_action_arch.gv_multi_payroll_pymt);
2614: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
2615:
2616: open c_last_xfr_elements(p_last_xfr_action_id, p_legislation_code);
2617: loop
2618: fetch c_last_xfr_elements into ln_assignment_id,
2626: lv_reporting_name,
2627: ld_effective_date,
2628: ln_ytd_hours;
2629:
2630: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2631: if c_last_xfr_elements%notfound then
2632: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2633: exit;
2634: end if;
2628: ln_ytd_hours;
2629:
2630: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2631: if c_last_xfr_elements%notfound then
2632: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2633: exit;
2634: end if;
2635:
2636: ln_step := 5;
2648: close c_get_balance;
2649: ln_primary_balance_id := ln_t_primary_balance_id;
2650: end if;
2651:
2652: hr_utility.trace('Element type id =' || ln_element_type_id);
2653: hr_utility.trace('Reporting Name =' || lv_reporting_name);
2654: hr_utility.trace('JD Code =' || lv_jurisdiction_code);
2655: hr_utility.trace('Ele Class =' || lv_element_classfication_name);
2656:
2649: ln_primary_balance_id := ln_t_primary_balance_id;
2650: end if;
2651:
2652: hr_utility.trace('Element type id =' || ln_element_type_id);
2653: hr_utility.trace('Reporting Name =' || lv_reporting_name);
2654: hr_utility.trace('JD Code =' || lv_jurisdiction_code);
2655: hr_utility.trace('Ele Class =' || lv_element_classfication_name);
2656:
2657: ln_step := 6;
2650: end if;
2651:
2652: hr_utility.trace('Element type id =' || ln_element_type_id);
2653: hr_utility.trace('Reporting Name =' || lv_reporting_name);
2654: hr_utility.trace('JD Code =' || lv_jurisdiction_code);
2655: hr_utility.trace('Ele Class =' || lv_element_classfication_name);
2656:
2657: ln_step := 6;
2658:
2651:
2652: hr_utility.trace('Element type id =' || ln_element_type_id);
2653: hr_utility.trace('Reporting Name =' || lv_reporting_name);
2654: hr_utility.trace('JD Code =' || lv_jurisdiction_code);
2655: hr_utility.trace('Ele Class =' || lv_element_classfication_name);
2656:
2657: ln_step := 6;
2658:
2659: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);
2655: hr_utility.trace('Ele Class =' || lv_element_classfication_name);
2656:
2657: ln_step := 6;
2658:
2659: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);
2660: hr_utility.trace('ln_assignment_id (prev) = '||ln_assignment_id);
2661:
2662: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' and
2663: p_sepchk_flag = 'Y' and
2656:
2657: ln_step := 6;
2658:
2659: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);
2660: hr_utility.trace('ln_assignment_id (prev) = '||ln_assignment_id);
2661:
2662: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' and
2663: p_sepchk_flag = 'Y' and
2664: ln_assignment_id <> p_assignment_id then
2662: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' and
2663: p_sepchk_flag = 'Y' and
2664: ln_assignment_id <> p_assignment_id then
2665:
2666: hr_utility.trace('action_info_category = ' ||lv_action_info_category);
2667: hr_utility.trace('ln_element_type_id = ' ||ln_element_type_id);
2668: hr_utility.trace('ln_primary_balance_id = '||ln_primary_balance_id);
2669: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
2670:
2663: p_sepchk_flag = 'Y' and
2664: ln_assignment_id <> p_assignment_id then
2665:
2666: hr_utility.trace('action_info_category = ' ||lv_action_info_category);
2667: hr_utility.trace('ln_element_type_id = ' ||ln_element_type_id);
2668: hr_utility.trace('ln_primary_balance_id = '||ln_primary_balance_id);
2669: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
2670:
2671: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2664: ln_assignment_id <> p_assignment_id then
2665:
2666: hr_utility.trace('action_info_category = ' ||lv_action_info_category);
2667: hr_utility.trace('ln_element_type_id = ' ||ln_element_type_id);
2668: hr_utility.trace('ln_primary_balance_id = '||ln_primary_balance_id);
2669: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
2670:
2671: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2672:
2665:
2666: hr_utility.trace('action_info_category = ' ||lv_action_info_category);
2667: hr_utility.trace('ln_element_type_id = ' ||ln_element_type_id);
2668: hr_utility.trace('ln_primary_balance_id = '||ln_primary_balance_id);
2669: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
2670:
2671: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2672:
2673: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2716: end if;
2717:
2718: ln_step := 10;
2719: if lv_element_archived = 'N' then
2720: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2721: /**************************************************************
2722: ** Bug 3567107: Check to see if the element is still effective
2723: ** the primary balance is there before archiving
2724: ** the value when picking elements which have
2779: := pay_emp_action_arch.get_defined_balance_id
2780: (ln_primary_balance_id,
2781: gv_ytd_balance_dimension,
2782: p_legislation_code);
2783: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2784: if ln_ytd_defined_balance_id is not null then
2785: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
2786: ln_ytd_defined_balance_id,
2787: p_ytd_balcall_aaid),0);
2785: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
2786: ln_ytd_defined_balance_id,
2787: p_ytd_balcall_aaid),0);
2788: end if;
2789: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2790: if ln_hours_balance_id is not null then
2791: ln_ytd_hours_balance_id
2792: := pay_emp_action_arch.get_defined_balance_id
2793: (ln_hours_balance_id,
2792: := pay_emp_action_arch.get_defined_balance_id
2793: (ln_hours_balance_id,
2794: gv_ytd_balance_dimension,
2795: p_legislation_code);
2796: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2797: if ln_ytd_hours_balance_id is not null then
2798: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
2799: ln_ytd_hours_balance_id,
2800: p_ytd_balcall_aaid),0);
2797: if ln_ytd_hours_balance_id is not null then
2798: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
2799: ln_ytd_hours_balance_id,
2800: p_ytd_balcall_aaid),0);
2801: hr_utility.set_location(gv_package || lv_procedure_name, 90);
2802: end if;
2803: end if;
2804:
2805: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
2801: hr_utility.set_location(gv_package || lv_procedure_name, 90);
2802: end if;
2803: end if;
2804:
2805: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
2806: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
2807:
2808: if (( nvl(ln_ytd_amount, 0) + nvl(ln_payments_amount, 0) <> 0 ) or
2809: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) then
2802: end if;
2803: end if;
2804:
2805: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
2806: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
2807:
2808: if (( nvl(ln_ytd_amount, 0) + nvl(ln_payments_amount, 0) <> 0 ) or
2809: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) then
2810:
2807:
2808: if (( nvl(ln_ytd_amount, 0) + nvl(ln_payments_amount, 0) <> 0 ) or
2809: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) then
2810:
2811: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2812: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2813: hr_utility.trace('ln_index = ' || ln_index);
2814: ln_step := 20;
2815: if lv_element_classfication_name in ('Earnings',
2809: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) then
2810:
2811: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2812: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2813: hr_utility.trace('ln_index = ' || ln_index);
2814: ln_step := 20;
2815: if lv_element_classfication_name in ('Earnings',
2816: 'Alien/Expat Earnings',
2817: 'Supplemental Earnings',
2866: end if;
2867: end loop;
2868: close c_last_xfr_elements;
2869:
2870: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2871: ln_step := 25;
2872:
2873:
2874:
2876: when others then
2877: lv_error_message := 'Error at step ' || ln_step ||
2878: ' in ' || gv_package || lv_procedure_name;
2879:
2880: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2881:
2882: lv_error_message :=
2883: pay_emp_action_arch.set_error_message(lv_error_message);
2884:
2881:
2882: lv_error_message :=
2883: pay_emp_action_arch.set_error_message(lv_error_message);
2884:
2885: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2886: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2887: hr_utility.raise_error;
2888:
2889: END get_xfr_elements;
2882: lv_error_message :=
2883: pay_emp_action_arch.set_error_message(lv_error_message);
2884:
2885: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2886: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2887: hr_utility.raise_error;
2888:
2889: END get_xfr_elements;
2890:
2883: pay_emp_action_arch.set_error_message(lv_error_message);
2884:
2885: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2886: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2887: hr_utility.raise_error;
2888:
2889: END get_xfr_elements;
2890:
2891:
3003: ln_step NUMBER;
3004:
3005: BEGIN
3006: ln_step := 1;
3007: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3008: hr_utility.trace('p_xfr_action_id = '|| p_xfr_action_id);
3009: hr_utility.trace('p_tax_unit_id = '|| p_tax_unit_id);
3010: hr_utility.trace('p_last_pymt_action_id = '|| p_last_pymt_action_id );
3011: hr_utility.trace('p_last_pymt_eff_date = '|| p_last_pymt_eff_date);
3004:
3005: BEGIN
3006: ln_step := 1;
3007: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3008: hr_utility.trace('p_xfr_action_id = '|| p_xfr_action_id);
3009: hr_utility.trace('p_tax_unit_id = '|| p_tax_unit_id);
3010: hr_utility.trace('p_last_pymt_action_id = '|| p_last_pymt_action_id );
3011: hr_utility.trace('p_last_pymt_eff_date = '|| p_last_pymt_eff_date);
3012: hr_utility.trace('p_last_xfr_eff_date = '|| p_last_xfr_eff_date);
3005: BEGIN
3006: ln_step := 1;
3007: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3008: hr_utility.trace('p_xfr_action_id = '|| p_xfr_action_id);
3009: hr_utility.trace('p_tax_unit_id = '|| p_tax_unit_id);
3010: hr_utility.trace('p_last_pymt_action_id = '|| p_last_pymt_action_id );
3011: hr_utility.trace('p_last_pymt_eff_date = '|| p_last_pymt_eff_date);
3012: hr_utility.trace('p_last_xfr_eff_date = '|| p_last_xfr_eff_date);
3013: hr_utility.trace('p_pymt_eff_date = '|| p_pymt_eff_date);
3006: ln_step := 1;
3007: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3008: hr_utility.trace('p_xfr_action_id = '|| p_xfr_action_id);
3009: hr_utility.trace('p_tax_unit_id = '|| p_tax_unit_id);
3010: hr_utility.trace('p_last_pymt_action_id = '|| p_last_pymt_action_id );
3011: hr_utility.trace('p_last_pymt_eff_date = '|| p_last_pymt_eff_date);
3012: hr_utility.trace('p_last_xfr_eff_date = '|| p_last_xfr_eff_date);
3013: hr_utility.trace('p_pymt_eff_date = '|| p_pymt_eff_date);
3014:
3007: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3008: hr_utility.trace('p_xfr_action_id = '|| p_xfr_action_id);
3009: hr_utility.trace('p_tax_unit_id = '|| p_tax_unit_id);
3010: hr_utility.trace('p_last_pymt_action_id = '|| p_last_pymt_action_id );
3011: hr_utility.trace('p_last_pymt_eff_date = '|| p_last_pymt_eff_date);
3012: hr_utility.trace('p_last_xfr_eff_date = '|| p_last_xfr_eff_date);
3013: hr_utility.trace('p_pymt_eff_date = '|| p_pymt_eff_date);
3014:
3015: open c_prev_elements(p_assignment_id,
3008: hr_utility.trace('p_xfr_action_id = '|| p_xfr_action_id);
3009: hr_utility.trace('p_tax_unit_id = '|| p_tax_unit_id);
3010: hr_utility.trace('p_last_pymt_action_id = '|| p_last_pymt_action_id );
3011: hr_utility.trace('p_last_pymt_eff_date = '|| p_last_pymt_eff_date);
3012: hr_utility.trace('p_last_xfr_eff_date = '|| p_last_xfr_eff_date);
3013: hr_utility.trace('p_pymt_eff_date = '|| p_pymt_eff_date);
3014:
3015: open c_prev_elements(p_assignment_id,
3016: p_pymt_eff_date,
3009: hr_utility.trace('p_tax_unit_id = '|| p_tax_unit_id);
3010: hr_utility.trace('p_last_pymt_action_id = '|| p_last_pymt_action_id );
3011: hr_utility.trace('p_last_pymt_eff_date = '|| p_last_pymt_eff_date);
3012: hr_utility.trace('p_last_xfr_eff_date = '|| p_last_xfr_eff_date);
3013: hr_utility.trace('p_pymt_eff_date = '|| p_pymt_eff_date);
3014:
3015: open c_prev_elements(p_assignment_id,
3016: p_pymt_eff_date,
3017: p_last_xfr_eff_date);
3023: lv_jurisdiction_code,
3024: ln_primary_balance_id,
3025: ln_hours_balance_id;
3026: if c_prev_elements%notfound then
3027: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3028: exit;
3029: end if;
3030: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3031:
3026: if c_prev_elements%notfound then
3027: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3028: exit;
3029: end if;
3030: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3031:
3032: if lv_element_classfication_name like '% Deductions' then
3033: ln_hours_balance_id := null;
3034: end if;
3083: pay_emp_action_arch.get_defined_balance_id
3084: (ln_primary_balance_id,
3085: gv_ytd_balance_dimension,
3086: p_legislation_code);
3087: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3088: if ln_ytd_defined_balance_id is not null then
3089: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
3090: ln_ytd_defined_balance_id,
3091: p_ytd_balcall_aaid),0);
3088: if ln_ytd_defined_balance_id is not null then
3089: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
3090: ln_ytd_defined_balance_id,
3091: p_ytd_balcall_aaid),0);
3092: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3093: end if;
3094: if ln_hours_balance_id is not null then
3095: ln_ytd_hours_balance_id :=
3096: pay_emp_action_arch.get_defined_balance_id
3096: pay_emp_action_arch.get_defined_balance_id
3097: (ln_hours_balance_id,
3098: gv_ytd_balance_dimension,
3099: p_legislation_code);
3100: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3101: if ln_ytd_hours_balance_id is not null then
3102: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
3103: ln_ytd_hours_balance_id,
3104: p_ytd_balcall_aaid),0);
3101: if ln_ytd_hours_balance_id is not null then
3102: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
3103: ln_ytd_hours_balance_id,
3104: p_ytd_balcall_aaid),0);
3105: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3106: end if;
3107: end if;
3108:
3109: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3105: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3106: end if;
3107: end if;
3108:
3109: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3110: if nvl(ln_ytd_amount, 0) <> 0 or nvl(ln_payments_amount, 0) <> 0 then
3111: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3112: hr_utility.trace('ln_index = ' || ln_index);
3113: if lv_element_classfication_name in ('Earnings',
3108:
3109: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3110: if nvl(ln_ytd_amount, 0) <> 0 or nvl(ln_payments_amount, 0) <> 0 then
3111: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3112: hr_utility.trace('ln_index = ' || ln_index);
3113: if lv_element_classfication_name in ('Earnings',
3114: 'Alien/Expat Earnings',
3115: 'Supplemental Earnings',
3116: 'Taxable Benefits',
3158: lv_reporting_name := null;
3159: ln_hours_balance_id := null;
3160: end loop;
3161: close c_prev_elements;
3162: hr_utility.set_location(gv_package || lv_procedure_name, 150);
3163:
3164: ln_step := 30;
3165:
3166:
3169:
3170: lv_error_message := 'Error at step ' || ln_step ||
3171: ' in ' || gv_package || lv_procedure_name;
3172:
3173: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3174:
3175: lv_error_message :=
3176: pay_emp_action_arch.set_error_message(lv_error_message);
3177:
3174:
3175: lv_error_message :=
3176: pay_emp_action_arch.set_error_message(lv_error_message);
3177:
3178: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3179: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3180: hr_utility.raise_error;
3181:
3182: END get_missing_xfr_info;
3175: lv_error_message :=
3176: pay_emp_action_arch.set_error_message(lv_error_message);
3177:
3178: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3179: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3180: hr_utility.raise_error;
3181:
3182: END get_missing_xfr_info;
3183:
3176: pay_emp_action_arch.set_error_message(lv_error_message);
3177:
3178: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3179: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3180: hr_utility.raise_error;
3181:
3182: END get_missing_xfr_info;
3183:
3184:
3280: lv_run_bal_status := NULL;
3281: lv_element_archived := 'N';
3282: lv_procedure_name := '.get_prev_ytd_elements';
3283:
3284: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3285: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3286: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3287: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3288: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3281: lv_element_archived := 'N';
3282: lv_procedure_name := '.get_prev_ytd_elements';
3283:
3284: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3285: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3286: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3287: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3288: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3289: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3282: lv_procedure_name := '.get_prev_ytd_elements';
3283:
3284: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3285: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3286: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3287: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3288: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3289: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3290: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3283:
3284: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3285: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3286: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3287: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3288: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3289: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3290: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3291: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3284: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3285: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3286: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3287: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3288: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3289: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3290: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3291: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3292: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3285: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3286: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3287: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3288: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3289: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3290: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3291: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3292: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3293: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3286: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3287: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3288: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3289: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3290: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3291: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3292: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3293: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3294: hr_utility.trace('p_curr_pymt_action_id '
3287: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3288: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3289: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3290: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3291: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3292: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3293: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3294: hr_utility.trace('p_curr_pymt_action_id '
3295: ||to_char(p_curr_pymt_action_id ));
3288: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3289: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3290: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3291: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3292: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3293: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3294: hr_utility.trace('p_curr_pymt_action_id '
3295: ||to_char(p_curr_pymt_action_id ));
3296:
3289: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3290: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3291: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3292: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3293: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3294: hr_utility.trace('p_curr_pymt_action_id '
3295: ||to_char(p_curr_pymt_action_id ));
3296:
3297:
3290: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3291: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3292: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3293: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3294: hr_utility.trace('p_curr_pymt_action_id '
3295: ||to_char(p_curr_pymt_action_id ));
3296:
3297:
3298: lv_run_bal_status := check_run_balance_status(
3324: lv_jurisdiction_code,
3325: ln_primary_balance_id,
3326: ln_hours_balance_id;
3327: if c_prev_ytd_action_elem_rbr%notfound then
3328: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3329: exit;
3330: end if;
3331: else
3332: fetch c_prev_ytd_action_elements into
3338: lv_jurisdiction_code,
3339: ln_primary_balance_id,
3340: ln_hours_balance_id;
3341: if c_prev_ytd_action_elements%notfound then
3342: hr_utility.set_location(gv_package || lv_procedure_name, 45);
3343: exit;
3344: end if;
3345: end if;
3346:
3343: exit;
3344: end if;
3345: end if;
3346:
3347: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3348: hr_utility.trace('Ele type id = ' || ln_element_type_id);
3349: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
3350: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
3351: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
3344: end if;
3345: end if;
3346:
3347: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3348: hr_utility.trace('Ele type id = ' || ln_element_type_id);
3349: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
3350: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
3351: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
3352: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
3345: end if;
3346:
3347: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3348: hr_utility.trace('Ele type id = ' || ln_element_type_id);
3349: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
3350: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
3351: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
3352: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
3353:
3346:
3347: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3348: hr_utility.trace('Ele type id = ' || ln_element_type_id);
3349: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
3350: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
3351: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
3352: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
3353:
3354: if lv_element_classification_name like '% Deductions' then
3347: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3348: hr_utility.trace('Ele type id = ' || ln_element_type_id);
3349: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
3350: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
3351: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
3352: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
3353:
3354: if lv_element_classification_name like '% Deductions' then
3355: ln_step := 10;
3348: hr_utility.trace('Ele type id = ' || ln_element_type_id);
3349: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
3350: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
3351: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
3352: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
3353:
3354: if lv_element_classification_name like '% Deductions' then
3355: ln_step := 10;
3356: ln_hours_balance_id := null;
3370: = ln_primary_balance_id and
3371: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3372: = lv_jurisdiction_code then
3373:
3374: hr_utility.set_location(gv_package || lv_procedure_name, 65);
3375: lv_element_archived := 'Y';
3376: exit;
3377: end if;
3378: end loop;
3379: end if;
3380:
3381: if lv_element_archived = 'N' then
3382: ln_step := 20;
3383: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3384: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3385: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
3386: := ln_element_type_id;
3387: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3400: /*****************************************************************
3401: ** The Payment Assignemnt Action is not passed to this procedure
3402: ** as we do not want to call the Payment Balance.
3403: *****************************************************************/
3404: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3405:
3406: ln_step := 25;
3407: populate_elements(p_xfr_action_id => p_xfr_action_id
3408: ,p_pymt_assignment_action_id => p_curr_pymt_action_id
3445: else
3446: close c_prev_ytd_action_elements;
3447: end if;
3448:
3449: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3450:
3451:
3452: ln_step := 30;
3453: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3453: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3454: for i in pay_ac_action_arch.lrr_act_tab.first ..
3455: pay_ac_action_arch.lrr_act_tab.last loop
3456:
3457: hr_utility.trace('after populate_elements ftp' ||
3458: ' action_context_id is ' ||
3459: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
3460: hr_utility.trace('action_info_category ' ||
3461: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3456:
3457: hr_utility.trace('after populate_elements ftp' ||
3458: ' action_context_id is ' ||
3459: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
3460: hr_utility.trace('action_info_category ' ||
3461: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3462: hr_utility.trace('act_info1 is ' ||
3463: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3464: hr_utility.trace('act_info10 ' ||
3458: ' action_context_id is ' ||
3459: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
3460: hr_utility.trace('action_info_category ' ||
3461: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3462: hr_utility.trace('act_info1 is ' ||
3463: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3464: hr_utility.trace('act_info10 ' ||
3465: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3466: hr_utility.trace('act_info3 ' ||
3460: hr_utility.trace('action_info_category ' ||
3461: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3462: hr_utility.trace('act_info1 is ' ||
3463: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3464: hr_utility.trace('act_info10 ' ||
3465: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3466: hr_utility.trace('act_info3 ' ||
3467: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3468: hr_utility.trace('act_info4 ' ||
3462: hr_utility.trace('act_info1 is ' ||
3463: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3464: hr_utility.trace('act_info10 ' ||
3465: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3466: hr_utility.trace('act_info3 ' ||
3467: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3468: hr_utility.trace('act_info4 ' ||
3469: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3470: hr_utility.trace('act_info5 ' ||
3464: hr_utility.trace('act_info10 ' ||
3465: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3466: hr_utility.trace('act_info3 ' ||
3467: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3468: hr_utility.trace('act_info4 ' ||
3469: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3470: hr_utility.trace('act_info5 ' ||
3471: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3472: hr_utility.trace('act_info6 ' ||
3466: hr_utility.trace('act_info3 ' ||
3467: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3468: hr_utility.trace('act_info4 ' ||
3469: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3470: hr_utility.trace('act_info5 ' ||
3471: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3472: hr_utility.trace('act_info6 ' ||
3473: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3474: hr_utility.trace('act_info7 ' ||
3468: hr_utility.trace('act_info4 ' ||
3469: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3470: hr_utility.trace('act_info5 ' ||
3471: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3472: hr_utility.trace('act_info6 ' ||
3473: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3474: hr_utility.trace('act_info7 ' ||
3475: pay_ac_action_arch.lrr_act_tab(i).act_info7);
3476: hr_utility.trace('act_info8 ' ||
3470: hr_utility.trace('act_info5 ' ||
3471: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3472: hr_utility.trace('act_info6 ' ||
3473: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3474: hr_utility.trace('act_info7 ' ||
3475: pay_ac_action_arch.lrr_act_tab(i).act_info7);
3476: hr_utility.trace('act_info8 ' ||
3477: pay_ac_action_arch.lrr_act_tab(i).act_info8);
3478:
3472: hr_utility.trace('act_info6 ' ||
3473: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3474: hr_utility.trace('act_info7 ' ||
3475: pay_ac_action_arch.lrr_act_tab(i).act_info7);
3476: hr_utility.trace('act_info8 ' ||
3477: pay_ac_action_arch.lrr_act_tab(i).act_info8);
3478:
3479: end loop;
3480: end if;
3478:
3479: end loop;
3480: end if;
3481:
3482: hr_utility.set_location(gv_package || lv_procedure_name, 110);
3483:
3484: ln_step := 35;
3485: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3486: for j in pay_ac_action_arch.emp_elements_tab.first ..
3485: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3486: for j in pay_ac_action_arch.emp_elements_tab.first ..
3487: pay_ac_action_arch.emp_elements_tab.last loop
3488:
3489: hr_utility.trace('EMP_ELEMENTS_TAB.element_type ' ||
3490: to_char(pay_ac_action_arch.emp_elements_tab(j).element_type_id));
3491: end loop;
3492: end if;
3493:
3490: to_char(pay_ac_action_arch.emp_elements_tab(j).element_type_id));
3491: end loop;
3492: end if;
3493:
3494: hr_utility.set_location(gv_package || lv_procedure_name, 200);
3495:
3496: EXCEPTION
3497: when others then
3498:
3498:
3499: lv_error_message := 'Error at step ' || ln_step ||
3500: ' in ' || gv_package || lv_procedure_name;
3501:
3502: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3503:
3504: lv_error_message :=
3505: pay_emp_action_arch.set_error_message(lv_error_message);
3506:
3503:
3504: lv_error_message :=
3505: pay_emp_action_arch.set_error_message(lv_error_message);
3506:
3507: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3508: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3509: hr_utility.raise_error;
3510:
3511: END get_prev_ytd_elements;
3504: lv_error_message :=
3505: pay_emp_action_arch.set_error_message(lv_error_message);
3506:
3507: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3508: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3509: hr_utility.raise_error;
3510:
3511: END get_prev_ytd_elements;
3512:
3505: pay_emp_action_arch.set_error_message(lv_error_message);
3506:
3507: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3508: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3509: hr_utility.raise_error;
3510:
3511: END get_prev_ytd_elements;
3512:
3513:
3543: BEGIN
3544: ln_step := 1;
3545: lv_procedure_name := '.first_time_process';
3546:
3547: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3548: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3549: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3550: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
3551: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3544: ln_step := 1;
3545: lv_procedure_name := '.first_time_process';
3546:
3547: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3548: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3549: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3550: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
3551: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3552: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3545: lv_procedure_name := '.first_time_process';
3546:
3547: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3548: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3549: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3550: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
3551: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3552: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3553: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3546:
3547: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3548: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3549: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3550: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
3551: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3552: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3553: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3554: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3547: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3548: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3549: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3550: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
3551: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3552: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3553: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3554: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3555: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3548: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3549: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3550: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
3551: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3552: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3553: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3554: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3555: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3556: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
3549: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3550: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
3551: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3552: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3553: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3554: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3555: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3556: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
3557: hr_utility.trace('p_curr_pymt_action_id '
3550: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
3551: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3552: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3553: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3554: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3555: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3556: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
3557: hr_utility.trace('p_curr_pymt_action_id '
3558: ||to_char(p_curr_pymt_action_id ));
3551: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3552: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3553: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3554: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3555: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3556: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
3557: hr_utility.trace('p_curr_pymt_action_id '
3558: ||to_char(p_curr_pymt_action_id ));
3559:
3552: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3553: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3554: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3555: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3556: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
3557: hr_utility.trace('p_curr_pymt_action_id '
3558: ||to_char(p_curr_pymt_action_id ));
3559:
3560: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3553: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3554: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3555: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3556: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
3557: hr_utility.trace('p_curr_pymt_action_id '
3558: ||to_char(p_curr_pymt_action_id ));
3559:
3560: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3561: ln_step := 10;
3556: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
3557: hr_utility.trace('p_curr_pymt_action_id '
3558: ||to_char(p_curr_pymt_action_id ));
3559:
3560: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3561: ln_step := 10;
3562: get_current_elements(p_xfr_action_id => p_xfr_action_id
3563: ,p_curr_pymt_action_id => p_curr_pymt_action_id
3564: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
3568: ,p_sepchk_flag => p_sepchk_flag
3569: ,p_pymt_balcall_aaid => p_pymt_balcall_aaid
3570: ,p_ytd_balcall_aaid => p_ytd_balcall_aaid
3571: ,p_legislation_code => p_legislation_code);
3572: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3573:
3574: ln_step := 20;
3575: get_prev_ytd_elements(p_assignment_id => p_assignment_id
3576: ,p_xfr_action_id => p_xfr_action_id
3586: ,p_action_type2 => 'Q'
3587: ,p_action_type3 => 'B');
3588:
3589: ln_step := 30;
3590: hr_utility.set_location(gv_package || lv_procedure_name, 200);
3591:
3592: EXCEPTION
3593: when others then
3594:
3594:
3595: lv_error_message := 'Error at step ' || ln_step ||
3596: ' in ' || gv_package || lv_procedure_name;
3597:
3598: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3599:
3600: lv_error_message :=
3601: pay_emp_action_arch.set_error_message(lv_error_message);
3602:
3599:
3600: lv_error_message :=
3601: pay_emp_action_arch.set_error_message(lv_error_message);
3602:
3603: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3604: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3605: hr_utility.raise_error;
3606:
3607: END first_time_process;
3600: lv_error_message :=
3601: pay_emp_action_arch.set_error_message(lv_error_message);
3602:
3603: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3604: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3605: hr_utility.raise_error;
3606:
3607: END first_time_process;
3608:
3601: pay_emp_action_arch.set_error_message(lv_error_message);
3602:
3603: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3604: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3605: hr_utility.raise_error;
3606:
3607: END first_time_process;
3608:
3609:
3649: j NUMBER := 0;
3650:
3651: BEGIN
3652: ln_step := 1;
3653: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3654: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3655: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3656:
3657: ln_step := 2;
3651: BEGIN
3652: ln_step := 1;
3653: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3654: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3655: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3656:
3657: ln_step := 2;
3658: for i in pay_ac_action_arch.lrr_act_tab.first ..
3659: pay_ac_action_arch.lrr_act_tab.last loop
3663: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
3664: = 'AC EARNINGS' then
3665: if pay_ac_action_arch.lrr_act_tab(i).act_info1
3666: = 'Earnings' then
3667: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3668: ln_step := 3;
3669: lv_earnings
3670: := lv_earnings +
3671: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3673: := lv_ytd_earnings +
3674: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3675: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3676: = 'Supplemental Earnings' then
3677: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3678: ln_step := 4;
3679: lv_supplemental_earnings
3680: := lv_supplemental_earnings +
3681: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3683: := lv_ytd_supplemental_earnings +
3684: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3685: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3686: = 'Imputed Earnings' then
3687: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3688: ln_step := 5;
3689: lv_imputed_earnings
3690: := lv_imputed_earnings +
3691: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3693: := lv_ytd_imputed_earnings +
3694: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3695: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3696: = 'Non-payroll Payments' then
3697: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3698: ln_step := 6;
3699: lv_non_payroll_payments
3700: := lv_non_payroll_payments +
3701: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3703: := lv_ytd_non_payroll_payments +
3704: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3705: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3706: = 'Taxable Benefits' then
3707: hr_utility.set_location(gv_package || lv_procedure_name, 55);
3708: ln_step := 7;
3709: lv_taxable_benefits
3710: := lv_taxable_benefits +
3711: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3713: := lv_ytd_taxable_benefits +
3714: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3715: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3716: = 'Alien/Expat Earnings' then
3717: hr_utility.set_location(gv_package || lv_procedure_name, 56);
3718: ln_step := 8;
3719: lv_alien_expat_earnings
3720: := lv_alien_expat_earnings +
3721: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3727: elsif pay_ac_action_arch.lrr_act_tab(i).action_info_category
3728: = 'AC DEDUCTIONS' then
3729: if pay_ac_action_arch.lrr_act_tab(i).act_info1
3730: = 'Pre-Tax Deductions' then
3731: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3732: ln_step := 15;
3733: lv_pre_tax_deductions
3734: := lv_pre_tax_deductions +
3735: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3737: := lv_ytd_pre_tax_deductions +
3738: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3739: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3740: = 'Involuntary Deductions' then
3741: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3742: ln_step := 16;
3743: lv_involuntary_deductions
3744: := lv_involuntary_deductions +
3745: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3747: := lv_ytd_involuntary_deductions +
3748: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3749: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3750: = 'Voluntary Deductions' then
3751: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3752: ln_step := 17;
3753: lv_voluntary_deductions
3754: := lv_voluntary_deductions +
3755: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3757: := lv_ytd_voluntary_deductions +
3758: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3759: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3760: = 'Tax Deductions' then
3761: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3762: ln_step := 18;
3763: lv_tax_deductions
3764: := lv_tax_deductions +
3765: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3771: end if;
3772: end loop;
3773: end if;
3774:
3775: hr_utility.set_location(gv_package || lv_procedure_name, 95);
3776: ln_step := 24;
3777: j := 0;
3778: if pay_ac_action_arch.ltr_summary_labels.count > 0 then
3779: for j in pay_ac_action_arch.ltr_summary_labels.first..
3791: end if;
3792: end loop;
3793: end if;
3794:
3795: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3796: /* Insert one row for CURRENT and one for YTD */
3797: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3798: ln_step := 25;
3799: -- CURRENT
3797: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3798: ln_step := 25;
3799: -- CURRENT
3800: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3801: hr_utility.trace('ln_index = ' || ln_index);
3802: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3803: := 'AC SUMMARY CURRENT';
3804: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3805: := '00-000-0000';
3825: := fnd_number.number_to_canonical(lv_non_payroll_payments);
3826: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
3827: := lv_current_label;
3828:
3829: hr_utility.set_location(gv_package || lv_procedure_name, 120);
3830: -- YTD
3831: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3832: hr_utility.trace('ln_index = ' || ln_index);
3833: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3828:
3829: hr_utility.set_location(gv_package || lv_procedure_name, 120);
3830: -- YTD
3831: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3832: hr_utility.trace('ln_index = ' || ln_index);
3833: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3834: := 'AC SUMMARY YTD';
3835: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3836: := '00-000-0000';
3857: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
3858: := lv_ytd_label;
3859: end if;
3860:
3861: hr_utility.set_location(gv_package || lv_procedure_name, 200);
3862: ln_step := 15;
3863:
3864: EXCEPTION
3865: when others then
3866:
3867: lv_error_message := 'Error at step ' || ln_step ||
3868: ' in ' || gv_package || lv_procedure_name;
3869:
3870: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3871:
3872: lv_error_message :=
3873: pay_emp_action_arch.set_error_message(lv_error_message);
3874:
3871:
3872: lv_error_message :=
3873: pay_emp_action_arch.set_error_message(lv_error_message);
3874:
3875: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3876: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3877: hr_utility.raise_error;
3878:
3879: END populate_summary;
3872: lv_error_message :=
3873: pay_emp_action_arch.set_error_message(lv_error_message);
3874:
3875: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3876: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3877: hr_utility.raise_error;
3878:
3879: END populate_summary;
3880:
3873: pay_emp_action_arch.set_error_message(lv_error_message);
3874:
3875: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3876: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3877: hr_utility.raise_error;
3878:
3879: END populate_summary;
3880:
3881: /******************************************************************
3921: ln_step NUMBER;
3922: lv_error_message VARCHAR2(200);
3923:
3924: BEGIN
3925: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3926:
3927: ln_step := 10;
3928: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id); -- Bug 3639249
3929: OPEN c_prev_ytd_action_elements(p_assignment_id
3938: lv_jurisdiction_code,
3939: ln_primary_balance_id,
3940: ln_hours_balance_id;
3941: IF c_prev_ytd_action_elements%NOTFOUND then
3942: hr_utility.set_location(gv_package || lv_procedure_name, 15);
3943: exit;
3944: END IF;
3945:
3946: ln_step := 20;
3943: exit;
3944: END IF;
3945:
3946: ln_step := 20;
3947: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3948: hr_utility.trace('================= Fetched Element ==================');
3949: hr_utility.trace('ele classification = '||lv_element_classification_name);
3950: hr_utility.trace('ele type id = ' || ln_element_type_id);
3951: hr_utility.trace('reporting name = ' || lv_reporting_name);
3944: END IF;
3945:
3946: ln_step := 20;
3947: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3948: hr_utility.trace('================= Fetched Element ==================');
3949: hr_utility.trace('ele classification = '||lv_element_classification_name);
3950: hr_utility.trace('ele type id = ' || ln_element_type_id);
3951: hr_utility.trace('reporting name = ' || lv_reporting_name);
3952: hr_utility.trace('primary balance id = ' || ln_primary_balance_id);
3945:
3946: ln_step := 20;
3947: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3948: hr_utility.trace('================= Fetched Element ==================');
3949: hr_utility.trace('ele classification = '||lv_element_classification_name);
3950: hr_utility.trace('ele type id = ' || ln_element_type_id);
3951: hr_utility.trace('reporting name = ' || lv_reporting_name);
3952: hr_utility.trace('primary balance id = ' || ln_primary_balance_id);
3953: hr_utility.trace('hours balance id = ' || ln_hours_balance_id);
3946: ln_step := 20;
3947: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3948: hr_utility.trace('================= Fetched Element ==================');
3949: hr_utility.trace('ele classification = '||lv_element_classification_name);
3950: hr_utility.trace('ele type id = ' || ln_element_type_id);
3951: hr_utility.trace('reporting name = ' || lv_reporting_name);
3952: hr_utility.trace('primary balance id = ' || ln_primary_balance_id);
3953: hr_utility.trace('hours balance id = ' || ln_hours_balance_id);
3954:
3947: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3948: hr_utility.trace('================= Fetched Element ==================');
3949: hr_utility.trace('ele classification = '||lv_element_classification_name);
3950: hr_utility.trace('ele type id = ' || ln_element_type_id);
3951: hr_utility.trace('reporting name = ' || lv_reporting_name);
3952: hr_utility.trace('primary balance id = ' || ln_primary_balance_id);
3953: hr_utility.trace('hours balance id = ' || ln_hours_balance_id);
3954:
3955: if lv_jurisdiction_code <> '00-000-0000' then
3948: hr_utility.trace('================= Fetched Element ==================');
3949: hr_utility.trace('ele classification = '||lv_element_classification_name);
3950: hr_utility.trace('ele type id = ' || ln_element_type_id);
3951: hr_utility.trace('reporting name = ' || lv_reporting_name);
3952: hr_utility.trace('primary balance id = ' || ln_primary_balance_id);
3953: hr_utility.trace('hours balance id = ' || ln_hours_balance_id);
3954:
3955: if lv_jurisdiction_code <> '00-000-0000' then
3956: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3949: hr_utility.trace('ele classification = '||lv_element_classification_name);
3950: hr_utility.trace('ele type id = ' || ln_element_type_id);
3951: hr_utility.trace('reporting name = ' || lv_reporting_name);
3952: hr_utility.trace('primary balance id = ' || ln_primary_balance_id);
3953: hr_utility.trace('hours balance id = ' || ln_hours_balance_id);
3954:
3955: if lv_jurisdiction_code <> '00-000-0000' then
3956: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3957: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
3969: end if;
3970:
3971: if ln_hours_balance_id is not null then
3972: ln_step := 30;
3973: hr_utility.set_location(gv_package || lv_procedure_name, 22);
3974: ln_ytd_hours_balance_id
3975: := pay_emp_action_arch.get_defined_balance_id(
3976: ln_hours_balance_id,
3977: gv_ytd_balance_dimension,
3975: := pay_emp_action_arch.get_defined_balance_id(
3976: ln_hours_balance_id,
3977: gv_ytd_balance_dimension,
3978: p_legislation_code);
3979: hr_utility.trace('ln_ytd_hours_balance_id = '||
3980: ln_ytd_hours_balance_id);
3981: hr_utility.set_location(gv_package || lv_procedure_name, 24);
3982:
3983: ln_step := 40;
3977: gv_ytd_balance_dimension,
3978: p_legislation_code);
3979: hr_utility.trace('ln_ytd_hours_balance_id = '||
3980: ln_ytd_hours_balance_id);
3981: hr_utility.set_location(gv_package || lv_procedure_name, 24);
3982:
3983: ln_step := 40;
3984: if ln_ytd_hours_balance_id is not null then
3985: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
3984: if ln_ytd_hours_balance_id is not null then
3985: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
3986: ln_ytd_hours_balance_id,
3987: p_assignment_action_id),0);
3988: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
3989: hr_utility.set_location(gv_package || lv_procedure_name, 26);
3990: end if;
3991: end if; --Hours
3992:
3985: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
3986: ln_ytd_hours_balance_id,
3987: p_assignment_action_id),0);
3988: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
3989: hr_utility.set_location(gv_package || lv_procedure_name, 26);
3990: end if;
3991: end if; --Hours
3992:
3993: ln_step := 50;
3995: := pay_emp_action_arch.get_defined_balance_id
3996: (ln_primary_balance_id,
3997: gv_ytd_balance_dimension,
3998: p_legislation_code);
3999: hr_utility.trace('ln_ytd_defined_balance_id = '||
4000: ln_ytd_defined_balance_id);
4001: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4002: if ln_ytd_defined_balance_id is not null then
4003: ln_step := 60;
3997: gv_ytd_balance_dimension,
3998: p_legislation_code);
3999: hr_utility.trace('ln_ytd_defined_balance_id = '||
4000: ln_ytd_defined_balance_id);
4001: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4002: if ln_ytd_defined_balance_id is not null then
4003: ln_step := 60;
4004: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
4005: ln_ytd_defined_balance_id,
4003: ln_step := 60;
4004: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
4005: ln_ytd_defined_balance_id,
4006: p_assignment_action_id),0);
4007: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4008: end if;
4009: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4010:
4011:
4005: ln_ytd_defined_balance_id,
4006: p_assignment_action_id),0);
4007: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4008: end if;
4009: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4010:
4011:
4012: if nvl(ln_ytd_amount, 0) <> 0 then
4013: ln_step := 70;
4012: if nvl(ln_ytd_amount, 0) <> 0 then
4013: ln_step := 70;
4014: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
4015:
4016: hr_utility.trace('ln_element_index = '||ln_element_index);
4017:
4018: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
4019: := ln_element_type_id;
4020: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
4031: := lv_jurisdiction_code;
4032:
4033:
4034: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4035: hr_utility.trace('ln_index = '||ln_index);
4036: if lv_element_classification_name in ('Earnings',
4037: 'Supplemental Earnings',
4038: 'Taxable Benefits',
4039: 'Imputed Earnings',
4038: 'Taxable Benefits',
4039: 'Imputed Earnings',
4040: 'Non-payroll Payments',
4041: 'Alien/Expat Earnings') then
4042: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4043: lv_action_category := 'AC EARNINGS';
4044: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4045: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4046: ln_step := 80;
4040: 'Non-payroll Payments',
4041: 'Alien/Expat Earnings') then
4042: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4043: lv_action_category := 'AC EARNINGS';
4044: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4045: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4046: ln_step := 80;
4047: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4048: := fnd_number.number_to_canonical(ln_current_hours); /*Bug 3311866*/
4041: 'Alien/Expat Earnings') then
4042: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4043: lv_action_category := 'AC EARNINGS';
4044: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4045: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4046: ln_step := 80;
4047: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4048: := fnd_number.number_to_canonical(ln_current_hours); /*Bug 3311866*/
4049: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4050: := fnd_number.number_to_canonical(ln_ytd_hours);
4051: else
4052: lv_action_category := 'AC DEDUCTIONS';
4053: end if;
4054: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4055: hr_utility.trace('lv_action_category = '||lv_action_category);
4056: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4057: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4058: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4051: else
4052: lv_action_category := 'AC DEDUCTIONS';
4053: end if;
4054: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4055: hr_utility.trace('lv_action_category = '||lv_action_category);
4056: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4057: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4058: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4059: ln_step := 90;
4052: lv_action_category := 'AC DEDUCTIONS';
4053: end if;
4054: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4055: hr_utility.trace('lv_action_category = '||lv_action_category);
4056: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4057: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4058: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4059: ln_step := 90;
4060:
4053: end if;
4054: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4055: hr_utility.trace('lv_action_category = '||lv_action_category);
4056: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4057: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4058: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4059: ln_step := 90;
4060:
4061: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4054: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4055: hr_utility.trace('lv_action_category = '||lv_action_category);
4056: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4057: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4058: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4059: ln_step := 90;
4060:
4061: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4062: := lv_action_category;
4079: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4080: := lv_reporting_name;
4081:
4082: end if;
4083: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4084:
4085: END LOOP;
4086: CLOSE c_prev_ytd_action_elements;
4087:
4085: END LOOP;
4086: CLOSE c_prev_ytd_action_elements;
4087:
4088: ln_step := 110;
4089: hr_utility.trace('------------Looping to see pl/sql table --------');
4090: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4091: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4092:
4093: hr_utility.trace('ln_check_count = '||ln_check_count);
4089: hr_utility.trace('------------Looping to see pl/sql table --------');
4090: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4091: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4092:
4093: hr_utility.trace('ln_check_count = '||ln_check_count);
4094: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4095: hr_utility.trace('============= End of Processing '||p_assignment_id||
4096: '=============');
4097: hr_utility.set_location(gv_package || lv_procedure_name,150);
4090: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4091: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4092:
4093: hr_utility.trace('ln_check_count = '||ln_check_count);
4094: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4095: hr_utility.trace('============= End of Processing '||p_assignment_id||
4096: '=============');
4097: hr_utility.set_location(gv_package || lv_procedure_name,150);
4098:
4091: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4092:
4093: hr_utility.trace('ln_check_count = '||ln_check_count);
4094: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4095: hr_utility.trace('============= End of Processing '||p_assignment_id||
4096: '=============');
4097: hr_utility.set_location(gv_package || lv_procedure_name,150);
4098:
4099: EXCEPTION
4093: hr_utility.trace('ln_check_count = '||ln_check_count);
4094: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4095: hr_utility.trace('============= End of Processing '||p_assignment_id||
4096: '=============');
4097: hr_utility.set_location(gv_package || lv_procedure_name,150);
4098:
4099: EXCEPTION
4100: when others then
4101:
4101:
4102: lv_error_message := 'Error at step ' || ln_step ||
4103: ' in ' || gv_package || lv_procedure_name;
4104:
4105: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4106:
4107: lv_error_message :=
4108: pay_emp_action_arch.set_error_message(lv_error_message);
4109:
4106:
4107: lv_error_message :=
4108: pay_emp_action_arch.set_error_message(lv_error_message);
4109:
4110: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4111: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4112: hr_utility.raise_error;
4113:
4114: END process_additional_elements;
4107: lv_error_message :=
4108: pay_emp_action_arch.set_error_message(lv_error_message);
4109:
4110: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4111: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4112: hr_utility.raise_error;
4113:
4114: END process_additional_elements;
4115:
4108: pay_emp_action_arch.set_error_message(lv_error_message);
4109:
4110: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4111: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4112: hr_utility.raise_error;
4113:
4114: END process_additional_elements;
4115:
4116: /******************************************************************
4165:
4166: BEGIN
4167: ln_step := 1;
4168: lv_procedure_name := '.process_baladj_elements';
4169: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4170:
4171: open c_check_baladj(p_assignment_id
4172: ,p_last_xfr_action_id
4173: ,p_tax_unit_id
4174: ,p_payroll_id
4175: ,p_consolidation_set_id
4176: ,p_curr_pymt_eff_date);
4177: fetch c_check_baladj into ld_baladj_date;
4178: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4179: ln_step := 10;
4180: if c_check_baladj%found then
4181: -- There is atleast one balance adjustment done since the last archive
4182: -- run, so, need to find out the element and process it
4179: ln_step := 10;
4180: if c_check_baladj%found then
4181: -- There is atleast one balance adjustment done since the last archive
4182: -- run, so, need to find out the element and process it
4183: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4184: get_prev_ytd_elements(p_assignment_id => p_assignment_id
4185: ,p_xfr_action_id => p_xfr_action_id
4186: ,p_curr_pymt_action_id => p_curr_pymt_action_id
4187: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
4195: ,p_action_type2 => ''
4196: ,p_action_type3 => '');
4197: end if;
4198: close c_check_baladj;
4199: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4200: ln_step := 20;
4201:
4202: EXCEPTION
4203: when others then
4204:
4205: lv_error_message := 'Error at step ' || ln_step ||
4206: ' in ' || gv_package || lv_procedure_name;
4207:
4208: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4209:
4210: lv_error_message :=
4211: pay_emp_action_arch.set_error_message(lv_error_message);
4212:
4209:
4210: lv_error_message :=
4211: pay_emp_action_arch.set_error_message(lv_error_message);
4212:
4213: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4214: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4215: hr_utility.raise_error;
4216:
4217: END process_baladj_elements;
4210: lv_error_message :=
4211: pay_emp_action_arch.set_error_message(lv_error_message);
4212:
4213: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4214: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4215: hr_utility.raise_error;
4216:
4217: END process_baladj_elements;
4218:
4211: pay_emp_action_arch.set_error_message(lv_error_message);
4212:
4213: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4214: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4215: hr_utility.raise_error;
4216:
4217: END process_baladj_elements;
4218:
4219: Procedure Archive_retro_element (
4409: ln_bg_id per_people_f.business_group_id%TYPE;
4410:
4411: BEGIN
4412:
4413: hr_utility.trace('Entering in package Archive_retro_element');
4414: hr_utility.trace('Run_assifnment_action_id = ' || p_run_assignment_action_id) ;
4415: OPEN get_element_entry_id ( p_run_assignment_action_id,
4416: p_assignment_id,
4417: p_element_type_id);
4410:
4411: BEGIN
4412:
4413: hr_utility.trace('Entering in package Archive_retro_element');
4414: hr_utility.trace('Run_assifnment_action_id = ' || p_run_assignment_action_id) ;
4415: OPEN get_element_entry_id ( p_run_assignment_action_id,
4416: p_assignment_id,
4417: p_element_type_id);
4418: ln_step := 50;
4431: IF get_element_entry_id%NOTFOUND THEN
4432: close get_element_entry_id;
4433: EXIT;
4434: END IF;
4435: hr_utility.trace('Step 50 : ln_element_entry_id := '||ln_element_entry_id);
4436: hr_utility.trace('Step 50 : lv_creator_type := '||lv_creator_type);
4437: hr_utility.trace('Step 50 : ld_source_start_date := '||ld_source_start_date);
4438:
4439: OPEN get_run_results ( ln_element_entry_id );
4432: close get_element_entry_id;
4433: EXIT;
4434: END IF;
4435: hr_utility.trace('Step 50 : ln_element_entry_id := '||ln_element_entry_id);
4436: hr_utility.trace('Step 50 : lv_creator_type := '||lv_creator_type);
4437: hr_utility.trace('Step 50 : ld_source_start_date := '||ld_source_start_date);
4438:
4439: OPEN get_run_results ( ln_element_entry_id );
4440: LOOP
4433: EXIT;
4434: END IF;
4435: hr_utility.trace('Step 50 : ln_element_entry_id := '||ln_element_entry_id);
4436: hr_utility.trace('Step 50 : lv_creator_type := '||lv_creator_type);
4437: hr_utility.trace('Step 50 : ld_source_start_date := '||ld_source_start_date);
4438:
4439: OPEN get_run_results ( ln_element_entry_id );
4440: LOOP
4441: ln_step := 49;
4444: IF get_run_results%FOUND THEN
4445: IF lv_pay_value_name = 'Hours' THEN
4446: ln_ytd_hours := ln_ytd_hours + nvl(ln_pay_value,0) ;
4447: ln_hours := nvl(ln_pay_value,0);
4448: hr_utility.trace('ln_hours := '||ln_hours);
4449: hr_utility.trace('ln_ytd_hours is '|| ln_ytd_hours );
4450:
4451: END IF ;
4452:
4445: IF lv_pay_value_name = 'Hours' THEN
4446: ln_ytd_hours := ln_ytd_hours + nvl(ln_pay_value,0) ;
4447: ln_hours := nvl(ln_pay_value,0);
4448: hr_utility.trace('ln_hours := '||ln_hours);
4449: hr_utility.trace('ln_ytd_hours is '|| ln_ytd_hours );
4450:
4451: END IF ;
4452:
4453: IF lv_pay_value_name = 'Pay Value' THEN
4452:
4453: IF lv_pay_value_name = 'Pay Value' THEN
4454: ln_ytd_amount := ln_ytd_amount + nvl(ln_pay_value,0) ;
4455: ln_amount := nvl(ln_pay_value,0) ;
4456: hr_utility.trace('ln_amount := '||ln_amount);
4457: hr_utility.trace('ln_ytd_amount is '|| ln_ytd_amount );
4458: END IF;
4459: ELSE
4460: EXIT;
4453: IF lv_pay_value_name = 'Pay Value' THEN
4454: ln_ytd_amount := ln_ytd_amount + nvl(ln_pay_value,0) ;
4455: ln_amount := nvl(ln_pay_value,0) ;
4456: hr_utility.trace('ln_amount := '||ln_amount);
4457: hr_utility.trace('ln_ytd_amount is '|| ln_ytd_amount );
4458: END IF;
4459: ELSE
4460: EXIT;
4461: END IF;
4478: ELSE
4479: ln_rate := ln_amount/ln_hours;
4480: END IF;
4481:
4482: hr_utility.trace('Before Opening Cursor archive_retro_elements');
4483: OPEN archive_retro_elements ( ln_element_entry_id ,
4484: p_run_assignment_action_id );
4485: FETCH archive_retro_elements INTO lv_original_date_earned
4486: ,lv_effective_start_date
4486: ,lv_effective_start_date
4487: ,lv_effective_end_date
4488: ,lv_category;
4489: CLOSE archive_retro_elements ;
4490: hr_utility.trace('After Closing Cursor archive_retro_elements');
4491: hr_utility.trace('lv_original_date_earned := '||lv_original_date_earned);
4492: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
4493: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
4494: hr_utility.trace('lv_category := '||lv_category);
4487: ,lv_effective_end_date
4488: ,lv_category;
4489: CLOSE archive_retro_elements ;
4490: hr_utility.trace('After Closing Cursor archive_retro_elements');
4491: hr_utility.trace('lv_original_date_earned := '||lv_original_date_earned);
4492: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
4493: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
4494: hr_utility.trace('lv_category := '||lv_category);
4495:
4488: ,lv_category;
4489: CLOSE archive_retro_elements ;
4490: hr_utility.trace('After Closing Cursor archive_retro_elements');
4491: hr_utility.trace('lv_original_date_earned := '||lv_original_date_earned);
4492: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
4493: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
4494: hr_utility.trace('lv_category := '||lv_category);
4495:
4496: -- Added For Work At Home Condition
4489: CLOSE archive_retro_elements ;
4490: hr_utility.trace('After Closing Cursor archive_retro_elements');
4491: hr_utility.trace('lv_original_date_earned := '||lv_original_date_earned);
4492: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
4493: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
4494: hr_utility.trace('lv_category := '||lv_category);
4495:
4496: -- Added For Work At Home Condition
4497: OPEN c_cur_get_wrkathome(p_assignment_id);
4490: hr_utility.trace('After Closing Cursor archive_retro_elements');
4491: hr_utility.trace('lv_original_date_earned := '||lv_original_date_earned);
4492: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
4493: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
4494: hr_utility.trace('lv_category := '||lv_category);
4495:
4496: -- Added For Work At Home Condition
4497: OPEN c_cur_get_wrkathome(p_assignment_id);
4498: FETCH c_cur_get_wrkathome INTO lv_wrk_at_home
4542: END IF; -- Work At Home 'N'
4543:
4544: -- populating temporary plsql table
4545: --
4546: hr_utility.trace('lv_jurisdiction_flag := '||lv_jurisdiction_flag);
4547: -- Comment Starts From Here
4548: -- Comment Till Here
4549:
4550: lv_action_category := 'AC DEDUCTIONS';
4573: := fnd_number.number_to_canonical(0);
4574:
4575: end if; -- Classification Earnings
4576:
4577: hr_utility.set_location(gv_package || lv_procedure_name, 130);
4578:
4579: /* Insert this into the plsql table if Current or YTD
4580: amount is not Zero */
4581:
4600: := p_processing_priority;
4601: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4602: := fnd_number.number_to_canonical(nvl(ln_amount,0));
4603:
4604: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
4605:
4606: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4607: := p_reporting_name;
4608: IF lv_action_category = 'AC DEDUCTIONS' THEN
4610: := p_reporting_name;
4611: END IF;
4612: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
4613: := lv_original_date_earned;
4614: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
4615: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
4616: := lv_effective_start_date;
4617: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
4618: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
4613: := lv_original_date_earned;
4614: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
4615: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
4616: := lv_effective_start_date;
4617: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
4618: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
4619: := lv_effective_end_date ;
4620: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
4621: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
4616: := lv_effective_start_date;
4617: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
4618: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
4619: := lv_effective_end_date ;
4620: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
4621: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
4622: := lv_category;
4623: hr_utility.trace('lv_category ' || lv_category );
4624: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
4619: := lv_effective_end_date ;
4620: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
4621: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
4622: := lv_category;
4623: hr_utility.trace('lv_category ' || lv_category );
4624: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
4625: := lv_jurisdiction_flag;
4626: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4627: := fnd_number.number_to_canonical(0);
4625: := lv_jurisdiction_flag;
4626: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4627: := fnd_number.number_to_canonical(0);
4628:
4629: hr_utility.set_location(gv_package || lv_procedure_name, 150);
4630:
4631: ln_step := 20;
4632: end loop;
4633: --
4660: p_primary_balance_id,
4661: gv_ytd_balance_dimension,
4662: p_legislation_code);
4663:
4664: hr_utility.trace('ln_ytd_defined_balance_id = ' ||
4665: ln_ytd_defined_balance_id);
4666:
4667: if ln_ytd_defined_balance_id is not null then
4668: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
4669: ln_ytd_defined_balance_id,
4670: p_ytd_balcall_aaid),0);
4671: end if;
4672: if p_hours_balance_id is not null then
4673: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4674: ln_ytd_hours_balance_id
4675: := pay_emp_action_arch.get_defined_balance_id(
4676: p_hours_balance_id,
4677: gv_ytd_balance_dimension,
4676: p_hours_balance_id,
4677: gv_ytd_balance_dimension,
4678: p_legislation_code);
4679:
4680: hr_utility.trace('ln_ytd_hours_balance_id = ' ||
4681: ln_ytd_hours_balance_id);
4682:
4683: if ln_ytd_hours_balance_id is not null then
4684: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
4683: if ln_ytd_hours_balance_id is not null then
4684: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
4685: ln_ytd_hours_balance_id,
4686: p_ytd_balcall_aaid),0);
4687: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4688: end if;
4689: end if;
4690:
4691: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4689: end if;
4690:
4691: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4692: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
4693: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
4694:
4695: if pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4696: = 'AC EARNINGS' then
4697:
4696: = 'AC EARNINGS' then
4697:
4698: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4699: := fnd_number.number_to_canonical(ln_ytd_hours);
4700: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
4701:
4702: end if;
4703: -- End Addition
4704: ELSE
4706: -- That Can be Subtracted during Base Population
4707: --
4708: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4709: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
4710: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
4711: gv_ytd_amount := ln_ytd_amount ;
4712:
4713: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4714: := fnd_number.number_to_canonical(ln_ytd_hours);
4713: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4714: := fnd_number.number_to_canonical(ln_ytd_hours);
4715: gv_ytd_hour := ln_ytd_hours ;
4716:
4717: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
4718:
4719: END IF; -- p_retro_base 'Y'
4720:
4721: EXCEPTION
4719: END IF; -- p_retro_base 'Y'
4720:
4721: EXCEPTION
4722: when others then
4723: hr_utility.trace(' Error In archive_retro_elements procedure');
4724: hr_utility.trace('error occured at step ' || ln_step );
4725:
4726: END Archive_retro_element;
4727:
4720:
4721: EXCEPTION
4722: when others then
4723: hr_utility.trace(' Error In archive_retro_elements procedure');
4724: hr_utility.trace('error occured at step ' || ln_step );
4725:
4726: END Archive_retro_element;
4727:
4728: Procedure Archive_addnl_elements (p_application_column_name in varchar2
4919: ln_bg_id per_people_f.business_group_id%TYPE;
4920:
4921: BEGIN
4922:
4923: hr_utility.trace('Entering in package Archive_addnl_elements');
4924: hr_utility.trace('Run_assifnment_action_id = ' || p_run_assignment_action_id) ;
4925: hr_utility.trace('Element Type Id in Non retro Archiver ' || p_element_type_id);
4926: OPEN get_element_entry_id ( p_run_assignment_action_id,
4927: p_assignment_id,
4920:
4921: BEGIN
4922:
4923: hr_utility.trace('Entering in package Archive_addnl_elements');
4924: hr_utility.trace('Run_assifnment_action_id = ' || p_run_assignment_action_id) ;
4925: hr_utility.trace('Element Type Id in Non retro Archiver ' || p_element_type_id);
4926: OPEN get_element_entry_id ( p_run_assignment_action_id,
4927: p_assignment_id,
4928: p_element_type_id);
4921: BEGIN
4922:
4923: hr_utility.trace('Entering in package Archive_addnl_elements');
4924: hr_utility.trace('Run_assifnment_action_id = ' || p_run_assignment_action_id) ;
4925: hr_utility.trace('Element Type Id in Non retro Archiver ' || p_element_type_id);
4926: OPEN get_element_entry_id ( p_run_assignment_action_id,
4927: p_assignment_id,
4928: p_element_type_id);
4929: ln_step := 50;
4938: lv_sqlstr_final := lv_sqlstr1 || lv_sqlstr2 || lv_sqlstr3 || lv_sqlstr4 ;
4939:
4940: execute immediate lv_sqlstr_final into lv_check_date ;
4941: ln_step :=51;
4942: hr_utility.trace('lv_check_date == ' || lv_check_date);
4943: LOOP
4944:
4945: FETCH get_element_entry_id INTO ln_element_entry_id,
4946: lv_creator_type,
4963: END IF;
4964: lv_original_date_earned := nvl(lv_original_date_earned ,p_pymt_eff_date);
4965:
4966:
4967: hr_utility.trace('lv_original_date_earned in step 53 is' || lv_original_date_earned) ;
4968:
4969: ld_original_date_paid := fnd_date.canonical_to_date(lv_original_date_earned);
4970:
4971: ln_step :=54;
4981: lv_pay_value_name;
4982: IF get_run_results%FOUND THEN
4983: IF lv_pay_value_name = 'Hours' THEN
4984: ln_hours := ln_hours + ln_pay_value;
4985: hr_utility.trace('ln_ytd_hours is '|| ln_ytd_hours );
4986: END IF ;
4987:
4988: IF lv_pay_value_name = 'Pay Value' THEN
4989: ln_amount := ln_amount + ln_pay_value ;
4986: END IF ;
4987:
4988: IF lv_pay_value_name = 'Pay Value' THEN
4989: ln_amount := ln_amount + ln_pay_value ;
4990: hr_utility.trace('ln_ytd_amount is '|| ln_ytd_amount );
4991: END IF;
4992: ELSE
4993: EXIT;
4994: END IF;
5013: ELSE
5014: ln_rate := ln_amount/ln_hours;
5015: END IF;
5016:
5017: hr_utility.trace('ld_original_date_paid := '||ld_original_date_paid);
5018: hr_utility.trace('ln_element_entry_id := '||ln_element_entry_id);
5019: hr_utility.trace('p_run_assignment_action_id := '||p_run_assignment_action_id);
5020:
5021: OPEN archive_non_retro_elements ( ld_original_date_paid,
5014: ln_rate := ln_amount/ln_hours;
5015: END IF;
5016:
5017: hr_utility.trace('ld_original_date_paid := '||ld_original_date_paid);
5018: hr_utility.trace('ln_element_entry_id := '||ln_element_entry_id);
5019: hr_utility.trace('p_run_assignment_action_id := '||p_run_assignment_action_id);
5020:
5021: OPEN archive_non_retro_elements ( ld_original_date_paid,
5022: ln_element_entry_id ,
5015: END IF;
5016:
5017: hr_utility.trace('ld_original_date_paid := '||ld_original_date_paid);
5018: hr_utility.trace('ln_element_entry_id := '||ln_element_entry_id);
5019: hr_utility.trace('p_run_assignment_action_id := '||p_run_assignment_action_id);
5020:
5021: OPEN archive_non_retro_elements ( ld_original_date_paid,
5022: ln_element_entry_id ,
5023: p_run_assignment_action_id );
5024: FETCH archive_non_retro_elements INTO lv_effective_start_date
5025: ,lv_effective_end_date
5026: ,lv_category;
5027: CLOSE archive_non_retro_elements ;
5028: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
5029: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
5030: hr_utility.trace('lv_category := '||lv_category);
5031:
5032: -- Added For Work At Home Condition
5025: ,lv_effective_end_date
5026: ,lv_category;
5027: CLOSE archive_non_retro_elements ;
5028: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
5029: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
5030: hr_utility.trace('lv_category := '||lv_category);
5031:
5032: -- Added For Work At Home Condition
5033: OPEN c_cur_get_wrkathome(p_assignment_id);
5026: ,lv_category;
5027: CLOSE archive_non_retro_elements ;
5028: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
5029: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
5030: hr_utility.trace('lv_category := '||lv_category);
5031:
5032: -- Added For Work At Home Condition
5033: OPEN c_cur_get_wrkathome(p_assignment_id);
5034: FETCH c_cur_get_wrkathome INTO lv_wrk_at_home
5075: into lv_jurisdiction_flag
5076: from dual;
5077: END IF; -- Work at Home 'N'
5078:
5079: hr_utility.trace('lv_jurisdiction_flag := '||lv_jurisdiction_flag);
5080: lv_action_category := 'AC EARNINGS';
5081: ln_step := 15;
5082: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5083:
5082: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5083:
5084: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5085: := fnd_number.number_to_canonical(ln_hours);
5086: 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*/
5087: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5088: /* Insert this into the plsql table if Current or YTD
5089: amount is not Zero */
5090: ln_step :=21;
5083:
5084: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5085: := fnd_number.number_to_canonical(ln_hours);
5086: 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*/
5087: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5088: /* Insert this into the plsql table if Current or YTD
5089: amount is not Zero */
5090: ln_step :=21;
5091: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5110: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5111: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5112: := fnd_number.number_to_canonical(0);
5113:
5114: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5115: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5116: := p_reporting_name;
5117:
5118: IF lv_temp_AAA <> 'AAA' THEN
5117:
5118: IF lv_temp_AAA <> 'AAA' THEN
5119: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
5120: := lv_original_date_earned;
5121: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
5122:
5123: IF lv_check_date = nvl(lv_original_date_earned,p_pymt_eff_date) THEN
5124: count_j := ln_index;
5125: END IF;
5124: count_j := ln_index;
5125: END IF;
5126: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
5127: := lv_effective_start_date;
5128: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5129: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5130: := lv_effective_end_date ;
5131: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5132: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5127: := lv_effective_start_date;
5128: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5129: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5130: := lv_effective_end_date ;
5131: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5132: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5133: := lv_category;
5134: hr_utility.trace('lv_category ' || lv_category );
5135: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5130: := lv_effective_end_date ;
5131: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5132: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5133: := lv_category;
5134: hr_utility.trace('lv_category ' || lv_category );
5135: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5136: := lv_jurisdiction_flag;
5137: END IF;
5138:
5143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := 'N/A';
5144: END IF;
5145: */
5146:
5147: hr_utility.set_location(gv_package || lv_procedure_name, 150);
5148: ln_step := 20;
5149: lv_temp_AAA := 'BBB' ;
5150: end loop;
5151:
5172: p_primary_balance_id,
5173: gv_ytd_balance_dimension,
5174: p_legislation_code);
5175:
5176: hr_utility.trace('ln_ytd_defined_balance_id = ' ||
5177: ln_ytd_defined_balance_id);
5178:
5179: ln_step := 4;
5180: if p_hours_balance_id is not null then
5177: ln_ytd_defined_balance_id);
5178:
5179: ln_step := 4;
5180: if p_hours_balance_id is not null then
5181: hr_utility.set_location(gv_package || lv_procedure_name, 20);
5182: ln_ytd_hours_balance_id
5183: := pay_emp_action_arch.get_defined_balance_id(
5184: p_hours_balance_id,
5185: gv_ytd_balance_dimension,
5184: p_hours_balance_id,
5185: gv_ytd_balance_dimension,
5186: p_legislation_code);
5187:
5188: hr_utility.trace('ln_ytd_hours_balance_id = ' ||
5189: ln_ytd_hours_balance_id);
5190:
5191: end if;
5192:
5190:
5191: end if;
5192:
5193: ln_step := 5;
5194: hr_utility.set_location(gv_package || lv_procedure_name, 40);
5195: if ln_ytd_defined_balance_id is not null then
5196: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
5197: ln_ytd_defined_balance_id,
5198: p_ytd_balcall_aaid),0);
5198: p_ytd_balcall_aaid),0);
5199: end if;
5200:
5201: if p_hours_balance_id is not null then
5202: hr_utility.set_location(gv_package || lv_procedure_name, 50);
5203: if ln_ytd_hours_balance_id is not null then
5204: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
5205: ln_ytd_hours_balance_id,
5206: p_ytd_balcall_aaid),0);
5203: if ln_ytd_hours_balance_id is not null then
5204: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
5205: ln_ytd_hours_balance_id,
5206: p_ytd_balcall_aaid),0);
5207: hr_utility.set_location(gv_package || lv_procedure_name, 60);
5208: end if;
5209: end if; --Hours
5210:
5211: ln_step := 8;
5234: p_legislation_code);
5235: end if;
5236: end if; -- p_action_type in ('B','V')
5237: /* end of addition for Reversals and bal adjustments */
5238: hr_utility.trace('ln_pymt_defined_balance_id ' ||
5239: ln_pymt_defined_balance_id);
5240:
5241: if ln_pymt_defined_balance_id is not null then
5242: ln_payments_amount := nvl(pay_balance_pkg.get_value(
5241: if ln_pymt_defined_balance_id is not null then
5242: ln_payments_amount := nvl(pay_balance_pkg.get_value(
5243: ln_pymt_defined_balance_id,
5244: p_pymt_balcall_aaid),0);
5245: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
5246: end if;
5247:
5248: if p_hours_balance_id is not null then
5249: /* Added dimension _ASG_GRE_RUN for reversals and Balance
5269: ,p_legislation_code);
5270: end if;
5271: end if; -- p_action_type in ('B','V')
5272: /* end of addition for reversals and bal adjustments */
5273: hr_utility.trace('ln_pymt_hours_balance_id ' ||
5274: ln_pymt_hours_balance_id);
5275:
5276: hr_utility.set_location(gv_package || lv_procedure_name, 120);
5277: end if; --Hours
5272: /* end of addition for reversals and bal adjustments */
5273: hr_utility.trace('ln_pymt_hours_balance_id ' ||
5274: ln_pymt_hours_balance_id);
5275:
5276: hr_utility.set_location(gv_package || lv_procedure_name, 120);
5277: end if; --Hours
5278: end if; -- p_pymt_balcall_aaid is not null
5279:
5280: ln_step := 15;
5280: ln_step := 15;
5281:
5282: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5283: := fnd_number.number_to_canonical(ln_ytd_amount);
5284: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
5285:
5286: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5287: := fnd_number.number_to_canonical(ln_ytd_hours);
5288: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5284: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
5285:
5286: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5287: := fnd_number.number_to_canonical(ln_ytd_hours);
5288: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5289:
5290: /* Following later to be re-valuated IF worth doing wrt Cost
5291:
5292: IF count_j is null THEN
5291:
5292: IF count_j is null THEN
5293: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5294: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5295: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5296: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5297: := fnd_number.number_to_canonical(ln_ytd_hours);
5298: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5299: END IF;
5294: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5295: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5296: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5297: := fnd_number.number_to_canonical(ln_ytd_hours);
5298: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5299: END IF;
5300: */
5301:
5302: EXCEPTION
5300: */
5301:
5302: EXCEPTION
5303: when others then
5304: hr_utility.trace(' Error In archive_addnl_elements procedure');
5305: hr_utility.trace('error occured at step ' || ln_step );
5306:
5307: END Archive_addnl_elements;
5308:
5301:
5302: EXCEPTION
5303: when others then
5304: hr_utility.trace(' Error In archive_addnl_elements procedure');
5305: hr_utility.trace('error occured at step ' || ln_step );
5306:
5307: END Archive_addnl_elements;
5308:
5309: END pay_ac_action_arch;