582: and lookup_code in ('CURRENT', 'YTD');
583:
584:
585: BEGIN
586: hr_utility.set_location(gv_package || lv_procedure_name, 10);
587: ln_step := 1;
588:
589: if pay_ac_action_arch.lrr_act_tab.count > 0 then
590: for i in pay_ac_action_arch.lrr_act_tab.first ..
651: pay_ac_action_arch.ltr_summary_labels(i).language := lbl.language;
652: pay_ac_action_arch.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
653: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
654:
655: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
656: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
657: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).meaning);
658:
659: i := i + 1;
652: pay_ac_action_arch.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
653: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
654:
655: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
656: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
657: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).meaning);
658:
659: i := i + 1;
660:
653: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
654:
655: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
656: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
657: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).meaning);
658:
659: i := i + 1;
660:
661: end loop;
661: end loop;
662:
663: end if;
664:
665: hr_utility.trace('pay_ac_action_arch.lrr_act_tab.count = ' ||
666: pay_ac_action_arch.lrr_act_tab.count);
667: hr_utility.set_location(gv_package || lv_procedure_name, 50);
668: ln_step := 10;
669:
663: end if;
664:
665: hr_utility.trace('pay_ac_action_arch.lrr_act_tab.count = ' ||
666: pay_ac_action_arch.lrr_act_tab.count);
667: hr_utility.set_location(gv_package || lv_procedure_name, 50);
668: ln_step := 10;
669:
670: EXCEPTION
671: when others then
671: when others then
672: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
673: gv_package || lv_procedure_name;
674:
675: hr_utility.trace(lv_error_message || '-' || sqlerrm);
676:
677: lv_error_message :=
678: pay_emp_action_arch.set_error_message(lv_error_message);
679:
676:
677: lv_error_message :=
678: pay_emp_action_arch.set_error_message(lv_error_message);
679:
680: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
681: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
682: hr_utility.raise_error;
683:
684: END initialization_process;
677: lv_error_message :=
678: pay_emp_action_arch.set_error_message(lv_error_message);
679:
680: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
681: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
682: hr_utility.raise_error;
683:
684: END initialization_process;
685:
678: pay_emp_action_arch.set_error_message(lv_error_message);
679:
680: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
681: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
682: hr_utility.raise_error;
683:
684: END initialization_process;
685:
686:
744: lv_error_message VARCHAR2(200);
745: ln_step NUMBER;
746:
747: BEGIN
748: hr_utility.set_location(gv_package || lv_procedure_name, 10);
749: ln_step := 1;
750: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' then
751: open c_multi_asg_prev_information(p_assignment_id,
752: p_action_info_category,
754: p_curr_effective_date);
755: fetch c_multi_asg_prev_information into ld_last_xfr_eff_date
756: ,ln_last_xfr_action_id;
757: if c_multi_asg_prev_information%notfound then
758: hr_utility.trace('This process has not been run earlier');
759: end if;
760: close c_multi_asg_prev_information;
761:
762: else
767: p_curr_effective_date);
768: fetch c_prev_run_information into ld_last_xfr_eff_date
769: ,ln_last_xfr_action_id;
770: if c_prev_run_information%notfound then
771: hr_utility.trace('This process has not been run earlier');
772: end if;
773: close c_prev_run_information ;
774: end if;
775:
780: ld_last_xfr_eff_date := null;
781: ln_last_xfr_action_id := null;
782: end if;
783: end if;
784: hr_utility.trace('ld_last_xfr_eff_date '||to_char(ld_last_xfr_eff_date));
785: hr_utility.trace('ln_last_xfr_action_id '|| ln_last_xfr_action_id);
786:
787: p_last_xfr_eff_date := ld_last_xfr_eff_date;
788: p_last_xfr_action_id := ln_last_xfr_action_id;
781: ln_last_xfr_action_id := null;
782: end if;
783: end if;
784: hr_utility.trace('ld_last_xfr_eff_date '||to_char(ld_last_xfr_eff_date));
785: hr_utility.trace('ln_last_xfr_action_id '|| ln_last_xfr_action_id);
786:
787: p_last_xfr_eff_date := ld_last_xfr_eff_date;
788: p_last_xfr_action_id := ln_last_xfr_action_id;
789:
786:
787: p_last_xfr_eff_date := ld_last_xfr_eff_date;
788: p_last_xfr_action_id := ln_last_xfr_action_id;
789:
790: hr_utility.set_location(gv_package || lv_procedure_name, 50);
791: ln_step := 10;
792:
793: EXCEPTION
794: when others then
794: when others then
795: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
796: gv_package || lv_procedure_name;
797:
798: hr_utility.trace(lv_error_message || '-' || sqlerrm);
799:
800: lv_error_message :=
801: pay_emp_action_arch.set_error_message(lv_error_message);
802:
799:
800: lv_error_message :=
801: pay_emp_action_arch.set_error_message(lv_error_message);
802:
803: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
804: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
805: hr_utility.raise_error;
806:
807: END get_last_xfr_info;
800: lv_error_message :=
801: pay_emp_action_arch.set_error_message(lv_error_message);
802:
803: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
804: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
805: hr_utility.raise_error;
806:
807: END get_last_xfr_info;
808:
801: pay_emp_action_arch.set_error_message(lv_error_message);
802:
803: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
804: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
805: hr_utility.raise_error;
806:
807: END get_last_xfr_info;
808:
809: /* Start : Bug 8688998 */
890: lv_error_message VARCHAR2(200);
891: ln_step NUMBER;
892:
893: BEGIN
894: hr_utility.set_location(gv_package || lv_procedure_name, 10);
895: ln_step := 1;
896:
897: open c_get_payroll_id(p_xfr_action_id); --added for the bug 14605761
898: fetch c_get_payroll_id into ln_payroll_id;
909: p_curr_effective_date);
910: fetch c_multi_asg_prev_information into ld_last_xfr_eff_date
911: ,ln_last_xfr_action_id;
912: if c_multi_asg_prev_information%notfound then
913: hr_utility.trace('This process has not been run earlier');
914: end if;
915: close c_multi_asg_prev_information;
916:
917: else
922: p_curr_effective_date);
923: fetch c_prev_run_information into ld_last_xfr_eff_date
924: ,ln_last_xfr_action_id;
925: if c_prev_run_information%notfound then
926: hr_utility.trace('This process has not been run earlier');
927: end if;
928: close c_prev_run_information ;
929: end if;
930:
938: p_curr_effective_date);
939: fetch c_multi_asg_prev_information into ld_last_xfr_eff_date
940: ,ln_last_xfr_action_id;
941: if c_multi_asg_prev_information%notfound then
942: hr_utility.trace('This process has not been run earlier');
943: end if;
944: close c_multi_asg_prev_information;
945:
946: else
951: p_curr_effective_date);
952: fetch c_prev_run_information into ld_last_xfr_eff_date
953: ,ln_last_xfr_action_id;
954: if c_prev_run_information%notfound then
955: hr_utility.trace('This process has not been run earlier');
956: end if;
957: close c_prev_run_information ;
958: end if;
959:
965: ld_last_xfr_eff_date := null;
966: ln_last_xfr_action_id := null;
967: end if;
968: end if;
969: hr_utility.trace('ld_last_xfr_eff_date '||to_char(ld_last_xfr_eff_date));
970: hr_utility.trace('ln_last_xfr_action_id '|| ln_last_xfr_action_id);
971:
972: p_last_xfr_eff_date := ld_last_xfr_eff_date;
973: p_last_xfr_action_id := ln_last_xfr_action_id;
966: ln_last_xfr_action_id := null;
967: end if;
968: end if;
969: hr_utility.trace('ld_last_xfr_eff_date '||to_char(ld_last_xfr_eff_date));
970: hr_utility.trace('ln_last_xfr_action_id '|| ln_last_xfr_action_id);
971:
972: p_last_xfr_eff_date := ld_last_xfr_eff_date;
973: p_last_xfr_action_id := ln_last_xfr_action_id;
974:
971:
972: p_last_xfr_eff_date := ld_last_xfr_eff_date;
973: p_last_xfr_action_id := ln_last_xfr_action_id;
974:
975: hr_utility.set_location(gv_package || lv_procedure_name, 50);
976: ln_step := 10;
977:
978: EXCEPTION
979: when others then
979: when others then
980: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
981: gv_package || lv_procedure_name;
982:
983: hr_utility.trace(lv_error_message || '-' || sqlerrm);
984:
985: lv_error_message :=
986: pay_emp_action_arch.set_error_message(lv_error_message);
987:
984:
985: lv_error_message :=
986: pay_emp_action_arch.set_error_message(lv_error_message);
987:
988: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
989: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
990: hr_utility.raise_error;
991:
992: END get_last_xfr_info;
985: lv_error_message :=
986: pay_emp_action_arch.set_error_message(lv_error_message);
987:
988: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
989: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
990: hr_utility.raise_error;
991:
992: END get_last_xfr_info;
993:
986: pay_emp_action_arch.set_error_message(lv_error_message);
987:
988: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
989: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
990: hr_utility.raise_error;
991:
992: END get_last_xfr_info;
993:
994: /* End : Bug 8688998 */
1031: lv_error_message VARCHAR2(200);
1032: ln_step NUMBER;
1033:
1034: BEGIN
1035: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1036: ln_step := 1;
1037: open c_last_payment_info(p_assignment_id,p_curr_pymt_eff_date);
1038: fetch c_last_payment_info into ld_last_pymt_eff_date,
1039: ln_last_pymt_action_id ;
1042: ln_step := 5;
1043: p_last_pymt_eff_date := ld_last_pymt_eff_date;
1044: p_last_pymt_action_id := ln_last_pymt_action_id;
1045:
1046: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1047: ln_step := 10;
1048:
1049: EXCEPTION
1050: when others then
1050: when others then
1051: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
1052: gv_package || lv_procedure_name;
1053:
1054: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1055:
1056: lv_error_message :=
1057: pay_emp_action_arch.set_error_message(lv_error_message);
1058:
1055:
1056: lv_error_message :=
1057: pay_emp_action_arch.set_error_message(lv_error_message);
1058:
1059: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1060: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1061: hr_utility.raise_error;
1062:
1063: END get_last_pymt_info;
1056: lv_error_message :=
1057: pay_emp_action_arch.set_error_message(lv_error_message);
1058:
1059: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1060: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1061: hr_utility.raise_error;
1062:
1063: END get_last_pymt_info;
1064:
1057: pay_emp_action_arch.set_error_message(lv_error_message);
1058:
1059: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1060: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1061: hr_utility.raise_error;
1062:
1063: END get_last_pymt_info;
1064:
1065:
1094: BEGIN
1095: ln_step := 1;
1096: p_rate_exists := 'N';
1097:
1098: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1099: if pay_ac_action_arch.lrr_act_tab.count > 0 then
1100: for i in pay_ac_action_arch.lrr_act_tab.first..
1101: pay_ac_action_arch.lrr_act_tab.last
1102: loop
1109: exit;
1110: end if;
1111: end loop;
1112: end if;
1113: hr_utility.trace('p_rate_exists = ' || p_rate_exists);
1114:
1115: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1116: ln_step := 10;
1117:
1111: end loop;
1112: end if;
1113: hr_utility.trace('p_rate_exists = ' || p_rate_exists);
1114:
1115: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1116: ln_step := 10;
1117:
1118: EXCEPTION
1119: when others then
1119: when others then
1120: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
1121: gv_package || lv_procedure_name;
1122:
1123: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1124:
1125: lv_error_message :=
1126: pay_emp_action_arch.set_error_message(lv_error_message);
1127:
1124:
1125: lv_error_message :=
1126: pay_emp_action_arch.set_error_message(lv_error_message);
1127:
1128: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1129: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1130: hr_utility.raise_error;
1131:
1132: END check_hours_by_rate;
1125: lv_error_message :=
1126: pay_emp_action_arch.set_error_message(lv_error_message);
1127:
1128: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1129: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1130: hr_utility.raise_error;
1131:
1132: END check_hours_by_rate;
1133:
1126: pay_emp_action_arch.set_error_message(lv_error_message);
1127:
1128: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1129: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1130: hr_utility.raise_error;
1131:
1132: END check_hours_by_rate;
1133:
1134:
1225: ln_step NUMBER;
1226:
1227: BEGIN
1228: ln_step := 1;
1229: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1230: hr_utility.trace('p_pymt_assignment_action_id '
1231: ||to_char(p_pymt_assignment_action_id));
1232: hr_utility.trace('p_pymt_eff_date ='||to_char(p_pymt_eff_date));
1233: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
1226:
1227: BEGIN
1228: ln_step := 1;
1229: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1230: hr_utility.trace('p_pymt_assignment_action_id '
1231: ||to_char(p_pymt_assignment_action_id));
1232: hr_utility.trace('p_pymt_eff_date ='||to_char(p_pymt_eff_date));
1233: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
1234: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
1228: ln_step := 1;
1229: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1230: hr_utility.trace('p_pymt_assignment_action_id '
1231: ||to_char(p_pymt_assignment_action_id));
1232: hr_utility.trace('p_pymt_eff_date ='||to_char(p_pymt_eff_date));
1233: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
1234: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
1235: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
1236: hr_utility.trace('p_reporting_name ='||p_reporting_name);
1229: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1230: hr_utility.trace('p_pymt_assignment_action_id '
1231: ||to_char(p_pymt_assignment_action_id));
1232: hr_utility.trace('p_pymt_eff_date ='||to_char(p_pymt_eff_date));
1233: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
1234: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
1235: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
1236: hr_utility.trace('p_reporting_name ='||p_reporting_name);
1237: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
1230: hr_utility.trace('p_pymt_assignment_action_id '
1231: ||to_char(p_pymt_assignment_action_id));
1232: hr_utility.trace('p_pymt_eff_date ='||to_char(p_pymt_eff_date));
1233: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
1234: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
1235: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
1236: hr_utility.trace('p_reporting_name ='||p_reporting_name);
1237: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
1238: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
1231: ||to_char(p_pymt_assignment_action_id));
1232: hr_utility.trace('p_pymt_eff_date ='||to_char(p_pymt_eff_date));
1233: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
1234: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
1235: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
1236: hr_utility.trace('p_reporting_name ='||p_reporting_name);
1237: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
1238: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
1239: hr_utility.trace('p_legislation_code ='||p_legislation_code);
1232: hr_utility.trace('p_pymt_eff_date ='||to_char(p_pymt_eff_date));
1233: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
1234: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
1235: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
1236: hr_utility.trace('p_reporting_name ='||p_reporting_name);
1237: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
1238: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
1239: hr_utility.trace('p_legislation_code ='||p_legislation_code);
1240: hr_utility.trace('p_hours_balance_id ='||to_char(p_hours_balance_id));
1233: hr_utility.trace('p_element_type_id ='||to_char(p_element_type_id));
1234: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
1235: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
1236: hr_utility.trace('p_reporting_name ='||p_reporting_name);
1237: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
1238: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
1239: hr_utility.trace('p_legislation_code ='||p_legislation_code);
1240: hr_utility.trace('p_hours_balance_id ='||to_char(p_hours_balance_id));
1241:
1234: hr_utility.trace('p_primary_balance_id ='||to_char(p_primary_balance_id));
1235: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
1236: hr_utility.trace('p_reporting_name ='||p_reporting_name);
1237: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
1238: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
1239: hr_utility.trace('p_legislation_code ='||p_legislation_code);
1240: hr_utility.trace('p_hours_balance_id ='||to_char(p_hours_balance_id));
1241:
1242: if pay_emp_action_arch.gv_multi_leg_rule is null then
1235: hr_utility.trace('p_processing_priority='||to_char(p_processing_priority));
1236: hr_utility.trace('p_reporting_name ='||p_reporting_name);
1237: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
1238: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
1239: hr_utility.trace('p_legislation_code ='||p_legislation_code);
1240: hr_utility.trace('p_hours_balance_id ='||to_char(p_hours_balance_id));
1241:
1242: if pay_emp_action_arch.gv_multi_leg_rule is null then
1243: pay_emp_action_arch.gv_multi_leg_rule
1236: hr_utility.trace('p_reporting_name ='||p_reporting_name);
1237: hr_utility.trace('p_ytd_balcall_aaid ='||to_char(p_ytd_balcall_aaid));
1238: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
1239: hr_utility.trace('p_legislation_code ='||p_legislation_code);
1240: hr_utility.trace('p_hours_balance_id ='||to_char(p_hours_balance_id));
1241:
1242: if pay_emp_action_arch.gv_multi_leg_rule is null then
1243: pay_emp_action_arch.gv_multi_leg_rule
1244: := pay_emp_action_arch.get_multi_legislative_rule(
1269: p_primary_balance_id,
1270: gv_ytd_balance_dimension,
1271: p_legislation_code);
1272:
1273: hr_utility.trace('ln_ytd_defined_balance_id = ' ||
1274: ln_ytd_defined_balance_id);
1275:
1276: ln_step := 4;
1277: if p_hours_balance_id is not null then
1274: ln_ytd_defined_balance_id);
1275:
1276: ln_step := 4;
1277: if p_hours_balance_id is not null then
1278: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1279: ln_ytd_hours_balance_id
1280: := pay_emp_action_arch.get_defined_balance_id(
1281: p_hours_balance_id,
1282: gv_ytd_balance_dimension,
1281: p_hours_balance_id,
1282: gv_ytd_balance_dimension,
1283: p_legislation_code);
1284:
1285: hr_utility.trace('ln_ytd_hours_balance_id = ' ||
1286: ln_ytd_hours_balance_id);
1287:
1288: end if;
1289:
1288: end if;
1289:
1290: ln_step := 5;
1291: if p_legislation_code <> 'US' then
1292: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1293: ln_step := 6;
1294: check_hours_by_rate(
1295: p_xfr_action_id => p_xfr_action_id
1296: ,p_puv_assignment_action_id => p_pymt_assignment_action_id
1307: ,p_rate_exists => lv_rate_exists
1308: );
1309: end if;
1310:
1311: hr_utility.trace('lv_rate_exists = ' || lv_rate_exists);
1312:
1313: if lv_rate_exists = 'N' then
1314: ln_step := 7;
1315: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1311: hr_utility.trace('lv_rate_exists = ' || lv_rate_exists);
1312:
1313: if lv_rate_exists = 'N' then
1314: ln_step := 7;
1315: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1316: if ln_ytd_defined_balance_id is not null then
1317: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
1318: ln_ytd_defined_balance_id,
1319: p_ytd_balcall_aaid),0);
1319: p_ytd_balcall_aaid),0);
1320: end if;
1321:
1322: if p_hours_balance_id is not null then
1323: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1324: if ln_ytd_hours_balance_id is not null then
1325: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
1326: ln_ytd_hours_balance_id,
1327: p_ytd_balcall_aaid),0);
1324: if ln_ytd_hours_balance_id is not null then
1325: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
1326: ln_ytd_hours_balance_id,
1327: p_ytd_balcall_aaid),0);
1328: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1329: end if;
1330: end if; --Hours
1331:
1332: ln_step := 8;
1355: p_legislation_code);
1356: end if;
1357: end if; -- p_action_type in ('B','V')
1358: /* end of addition for Reversals and bal adjustments */
1359: hr_utility.trace('ln_pymt_defined_balance_id ' ||
1360: ln_pymt_defined_balance_id);
1361:
1362: if ln_pymt_defined_balance_id is not null then
1363: ln_payments_amount := nvl(pay_balance_pkg.get_value(
1362: if ln_pymt_defined_balance_id is not null then
1363: ln_payments_amount := nvl(pay_balance_pkg.get_value(
1364: ln_pymt_defined_balance_id,
1365: p_pymt_balcall_aaid),0);
1366: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
1367: end if;
1368:
1369: if p_hours_balance_id is not null then
1370: /* Added dimension _ASG_GRE_RUN for reversals and Balance
1390: ,p_legislation_code);
1391: end if;
1392: end if; -- p_action_type in ('B','V')
1393: /* end of addition for reversals and bal adjustments */
1394: hr_utility.trace('ln_pymt_hours_balance_id ' ||
1395: ln_pymt_hours_balance_id);
1396:
1397: if ln_pymt_hours_balance_id is not null then
1398: ln_current_hours := nvl(pay_balance_pkg.get_value(
1398: ln_current_hours := nvl(pay_balance_pkg.get_value(
1399: ln_pymt_hours_balance_id,
1400: p_pymt_balcall_aaid),0);
1401: end if;
1402: hr_utility.set_location(gv_package || lv_procedure_name, 120);
1403: end if; --Hours
1404: end if; -- p_pymt_balcall_aaid is not null
1405:
1406: ln_step := 15;
1413: 'Taxable Benefits',
1414: 'Imputed Earnings',
1415: 'Non-payroll Payments',
1416: 'Alien/Expat Earnings') then
1417: hr_utility.set_location(gv_package || lv_procedure_name, 125);
1418: lv_action_category := 'AC EARNINGS';
1419: /* bug 6702864 We are not subtracting the Retro amount from the base element so added the if condition */
1420: /* pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1421: := fnd_number.number_to_canonical(ln_current_hours);
1432: /*12819017-Start*/
1433: open c_hbr(p_ytd_balcall_aaid,p_element_type_id);
1434: loop
1435: fetch c_hbr into ln_multiple,ln_rate;
1436: hr_utility.set_location(gv_package || lv_procedure_name, 1251);
1437: if c_hbr%notfound then
1438: hr_utility.set_location(gv_package || lv_procedure_name, 1252);
1439: exit;
1440: end if;
1434: loop
1435: fetch c_hbr into ln_multiple,ln_rate;
1436: hr_utility.set_location(gv_package || lv_procedure_name, 1251);
1437: if c_hbr%notfound then
1438: hr_utility.set_location(gv_package || lv_procedure_name, 1252);
1439: exit;
1440: end if;
1441: end loop;
1442: close c_hbr;
1446: --IF ln_multiple <> 1 OR ln_rate IS NULL THEN /*12819017-End*/
1447: IF round(ln_rate,5) <> round((ln_payments_amount/ln_current_hours),5) OR ln_rate IS NULL THEN /*14219126*/
1448: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22:=
1449: round((ln_payments_amount/ln_current_hours),5);/*Bug 3311866 -- 12819017*/
1450: hr_utility.trace('Rate derived as multiple is not one ' || round((ln_payments_amount/ln_current_hours),5));
1451: /*12819017-Start*/
1452: ELSE
1453: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22:=ln_rate;
1454: hr_utility.trace('Rate Not derived as multiple is one ' || ln_rate);
1450: hr_utility.trace('Rate derived as multiple is not one ' || round((ln_payments_amount/ln_current_hours),5));
1451: /*12819017-Start*/
1452: ELSE
1453: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22:=ln_rate;
1454: hr_utility.trace('Rate Not derived as multiple is one ' || ln_rate);
1455: END IF;/*12819017-End*/
1456:
1457: ELSE
1458: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := null;
1466: := fnd_number.number_to_canonical((ln_ytd_hours) - gv_ytd_hour);
1467: END IF;
1468: end if;
1469:
1470: hr_utility.set_location(gv_package || lv_procedure_name, 130);
1471: /* Insert this into the plsql table if Current or YTD
1472: amount is not Zero */
1473: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1474: := lv_action_category;
1496: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1497: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0) - gv_ytd_amount);
1498: END IF;
1499:
1500: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_payments_amount,0)));
1501:
1502: IF p_ytd_flag = 'N' then
1503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1504: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
1513: := p_reporting_name;
1514: END IF;
1515: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
1516: := p_original_date_earned;
1517: hr_utility.trace('p_original_date_earned :=' || p_original_date_earned );
1518: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
1519: := p_effective_start_date;
1520: hr_utility.trace('p_effective_start_date := ' || p_effective_start_date );
1521: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
1516: := p_original_date_earned;
1517: hr_utility.trace('p_original_date_earned :=' || p_original_date_earned );
1518: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
1519: := p_effective_start_date;
1520: hr_utility.trace('p_effective_start_date := ' || p_effective_start_date );
1521: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
1522: := p_effective_end_date ;
1523: hr_utility.trace('p_effective_end_date:= ' || p_effective_end_date );
1524: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
1519: := p_effective_start_date;
1520: hr_utility.trace('p_effective_start_date := ' || p_effective_start_date );
1521: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
1522: := p_effective_end_date ;
1523: hr_utility.trace('p_effective_end_date:= ' || p_effective_end_date );
1524: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
1525: := p_category;
1526: hr_utility.trace('p_category ' || p_category );
1527: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
1522: := p_effective_end_date ;
1523: hr_utility.trace('p_effective_end_date:= ' || p_effective_end_date );
1524: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
1525: := p_category;
1526: hr_utility.trace('p_category ' || p_category );
1527: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
1528: := p_el_jurisdiction_code;
1529:
1530: end if;
1532: end if; -- lv_rate_exists = 'N'
1533:
1534:
1535:
1536: hr_utility.set_location(gv_package || lv_procedure_name, 150);
1537: ln_step := 20;
1538:
1539: EXCEPTION
1540: when others then
1537: ln_step := 20;
1538:
1539: EXCEPTION
1540: when others then
1541: hr_utility.set_location(gv_package || lv_procedure_name, 200);
1542: lv_error_message := 'Error at step ' || ln_step ||
1543: ' in ' || gv_package || lv_procedure_name;
1544:
1545: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1541: hr_utility.set_location(gv_package || lv_procedure_name, 200);
1542: lv_error_message := 'Error at step ' || ln_step ||
1543: ' in ' || gv_package || lv_procedure_name;
1544:
1545: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1546:
1547: lv_error_message :=
1548: pay_emp_action_arch.set_error_message(lv_error_message);
1549:
1546:
1547: lv_error_message :=
1548: pay_emp_action_arch.set_error_message(lv_error_message);
1549:
1550: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1551: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1552: hr_utility.raise_error;
1553:
1554: END populate_elements;
1547: lv_error_message :=
1548: pay_emp_action_arch.set_error_message(lv_error_message);
1549:
1550: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1551: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1552: hr_utility.raise_error;
1553:
1554: END populate_elements;
1555:
1548: pay_emp_action_arch.set_error_message(lv_error_message);
1549:
1550: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1551: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1552: hr_utility.raise_error;
1553:
1554: END populate_elements;
1555:
1556: /******************************************************************
1699: BEGIN
1700:
1701:
1702: ln_step := 1;
1703: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1704: hr_utility.trace('HBR p_curr_pymt_action_id : ' || p_curr_pymt_action_id);
1705: hr_utility.trace('HBR p_assignment_id : ' || p_assignment_id);
1706:
1707: hbr.delete;
1700:
1701:
1702: ln_step := 1;
1703: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1704: hr_utility.trace('HBR p_curr_pymt_action_id : ' || p_curr_pymt_action_id);
1705: hr_utility.trace('HBR p_assignment_id : ' || p_assignment_id);
1706:
1707: hbr.delete;
1708: ln_tot_pymt_amt := 0;
1701:
1702: ln_step := 1;
1703: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1704: hr_utility.trace('HBR p_curr_pymt_action_id : ' || p_curr_pymt_action_id);
1705: hr_utility.trace('HBR p_assignment_id : ' || p_assignment_id);
1706:
1707: hbr.delete;
1708: ln_tot_pymt_amt := 0;
1709:
1712: fetch c_run_aa_id into ln_assignment_action_id
1713: ,ln_run_type_id;
1714: exit when c_run_aa_id%notfound;
1715:
1716: hr_utility.trace('HBR ln_assignment_action_id : ' ||
1717: ln_assignment_action_id);
1718:
1719: ln_step := 2;
1720:
1731: end loop;
1732: close c_run_aa_id;
1733:
1734: if hbr.count > 0 then
1735: hr_utility.trace(' I came in first if ');
1736:
1737: for j in hbr.first..hbr.last + 1
1738: loop
1739:
1737: for j in hbr.first..hbr.last + 1
1738: loop
1739:
1740: if ( j <> i ) then
1741: hr_utility.trace(' It came here one');
1742: ln_element_type_id := hbr(j).element_type_id;
1743: lv_element_name := hbr(j).element_name;
1744: ln_processing_priority := hbr(j).processing_priority;
1745: ln_rate := round(hbr(j).rate,5); --Bug 8544619
1745: ln_rate := round(hbr(j).rate,5); --Bug 8544619
1746: ln_multiple := hbr(j).multiple;
1747: ln_hours := hbr(j).hours;
1748: ln_amount := hbr(j).amount;
1749: hr_utility.trace('element_type_id'||hbr(j).element_type_id);
1750: hr_utility.trace('element_name'||hbr(j).element_name);
1751: hr_utility.trace('hbr(j).rate'||hbr(j).rate);
1752: end if;
1753:
1746: ln_multiple := hbr(j).multiple;
1747: ln_hours := hbr(j).hours;
1748: ln_amount := hbr(j).amount;
1749: hr_utility.trace('element_type_id'||hbr(j).element_type_id);
1750: hr_utility.trace('element_name'||hbr(j).element_name);
1751: hr_utility.trace('hbr(j).rate'||hbr(j).rate);
1752: end if;
1753:
1754: ln_step := 3;
1747: ln_hours := hbr(j).hours;
1748: ln_amount := hbr(j).amount;
1749: hr_utility.trace('element_type_id'||hbr(j).element_type_id);
1750: hr_utility.trace('element_name'||hbr(j).element_name);
1751: hr_utility.trace('hbr(j).rate'||hbr(j).rate);
1752: end if;
1753:
1754: ln_step := 3;
1755:
1757: prev_element_type_id <> -1 ) or
1758: ( j = i )
1759: ) then
1760:
1761: hr_utility.trace('I came here two');
1762:
1763: ln_step := 5;
1764: if gv_reporting_level = 'TAXGRP' then
1765: ln_tg_ytd_defined_bal_id
1805: p_ytd_balcall_aaid),0);
1806: end if;
1807: end if;
1808:
1809: hr_utility.trace('ytd balance = ' || ln_ytd_amount);
1810: hr_utility.trace('ytd hours = ' || ln_ytd_hours);
1811: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1812: := ln_ytd_amount;
1813: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1806: end if;
1807: end if;
1808:
1809: hr_utility.trace('ytd balance = ' || ln_ytd_amount);
1810: hr_utility.trace('ytd hours = ' || ln_ytd_hours);
1811: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1812: := ln_ytd_amount;
1813: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1814: := ln_ytd_hours;
1825: ln_pymt_bal_amt := nvl(pay_balance_pkg.get_value(
1826: ln_pymt_def_bal_id,
1827: p_pymt_balcall_aaid),0);
1828:
1829: hr_utility.trace('ln_pymt_bal_amt : '||ln_pymt_bal_amt);
1830: hr_utility.trace('ln_tot_pymt_amt : '||ln_tot_pymt_amt);
1831: hr_utility.trace('prev_element_type_id: '||prev_element_type_id);
1832: hr_utility.trace('prev_run_asg_act_id : '||prev_run_asg_act_id);
1833:
1826: ln_pymt_def_bal_id,
1827: p_pymt_balcall_aaid),0);
1828:
1829: hr_utility.trace('ln_pymt_bal_amt : '||ln_pymt_bal_amt);
1830: hr_utility.trace('ln_tot_pymt_amt : '||ln_tot_pymt_amt);
1831: hr_utility.trace('prev_element_type_id: '||prev_element_type_id);
1832: hr_utility.trace('prev_run_asg_act_id : '||prev_run_asg_act_id);
1833:
1834: IF ( ln_tot_pymt_amt <> ln_pymt_bal_amt ) THEN
1827: p_pymt_balcall_aaid),0);
1828:
1829: hr_utility.trace('ln_pymt_bal_amt : '||ln_pymt_bal_amt);
1830: hr_utility.trace('ln_tot_pymt_amt : '||ln_tot_pymt_amt);
1831: hr_utility.trace('prev_element_type_id: '||prev_element_type_id);
1832: hr_utility.trace('prev_run_asg_act_id : '||prev_run_asg_act_id);
1833:
1834: IF ( ln_tot_pymt_amt <> ln_pymt_bal_amt ) THEN
1835:
1828:
1829: hr_utility.trace('ln_pymt_bal_amt : '||ln_pymt_bal_amt);
1830: hr_utility.trace('ln_tot_pymt_amt : '||ln_tot_pymt_amt);
1831: hr_utility.trace('prev_element_type_id: '||prev_element_type_id);
1832: hr_utility.trace('prev_run_asg_act_id : '||prev_run_asg_act_id);
1833:
1834: IF ( ln_tot_pymt_amt <> ln_pymt_bal_amt ) THEN
1835:
1836: hr_utility.trace('i came here third');
1832: hr_utility.trace('prev_run_asg_act_id : '||prev_run_asg_act_id);
1833:
1834: IF ( ln_tot_pymt_amt <> ln_pymt_bal_amt ) THEN
1835:
1836: hr_utility.trace('i came here third');
1837:
1838: OPEN c_retro(prev_run_asg_act_id, prev_element_type_id,p_curr_pymt_eff_date); -- Bug# 16318258
1839: LOOP
1840: hr_utility.set_location(gv_package || lv_procedure_name,55);
1836: hr_utility.trace('i came here third');
1837:
1838: OPEN c_retro(prev_run_asg_act_id, prev_element_type_id,p_curr_pymt_eff_date); -- Bug# 16318258
1839: LOOP
1840: hr_utility.set_location(gv_package || lv_procedure_name,55);
1841: fetch c_retro into ln_retro_element_entry
1842: ,ln_retro_payvalue
1843: ,ln_retro_hours
1844: ,ln_retro_multiple
1846: if c_retro%notfound then
1847: exit;
1848: end if;
1849:
1850: hr_utility.trace('HBR Retro Values');
1851: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1852: hr_utility.trace('Hours ='|| ln_retro_hours);
1853: hr_utility.trace('Rate ='|| ln_retro_rate);
1854: hr_utility.trace('Multiple ='|| ln_retro_multiple);
1847: exit;
1848: end if;
1849:
1850: hr_utility.trace('HBR Retro Values');
1851: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1852: hr_utility.trace('Hours ='|| ln_retro_hours);
1853: hr_utility.trace('Rate ='|| ln_retro_rate);
1854: hr_utility.trace('Multiple ='|| ln_retro_multiple);
1855:
1848: end if;
1849:
1850: hr_utility.trace('HBR Retro Values');
1851: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1852: hr_utility.trace('Hours ='|| ln_retro_hours);
1853: hr_utility.trace('Rate ='|| ln_retro_rate);
1854: hr_utility.trace('Multiple ='|| ln_retro_multiple);
1855:
1856: IF nvl(ln_retro_multiple,0) = 0 THEN
1849:
1850: hr_utility.trace('HBR Retro Values');
1851: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1852: hr_utility.trace('Hours ='|| ln_retro_hours);
1853: hr_utility.trace('Rate ='|| ln_retro_rate);
1854: hr_utility.trace('Multiple ='|| ln_retro_multiple);
1855:
1856: IF nvl(ln_retro_multiple,0) = 0 THEN
1857: ln_retro_multiple := 1;
1850: hr_utility.trace('HBR Retro Values');
1851: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1852: hr_utility.trace('Hours ='|| ln_retro_hours);
1853: hr_utility.trace('Rate ='|| ln_retro_rate);
1854: hr_utility.trace('Multiple ='|| ln_retro_multiple);
1855:
1856: IF nvl(ln_retro_multiple,0) = 0 THEN
1857: ln_retro_multiple := 1;
1858: END IF;
1857: ln_retro_multiple := 1;
1858: END IF;
1859:
1860: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1861: hr_utility.trace('ln_index = ' || ln_index);
1862:
1863:
1864: ln_step := 20;
1865: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1868: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1869: := '00-000-0000';
1870: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1871: := lv_classification_name;
1872: hr_utility.trace('action_info_category' || lv_classification_name);
1873: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1874: := prev_element_type_id;
1875: hr_utility.trace('act_info2' || prev_element_type_id);
1876: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1871: := lv_classification_name;
1872: hr_utility.trace('action_info_category' || lv_classification_name);
1873: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1874: := prev_element_type_id;
1875: hr_utility.trace('act_info2' || prev_element_type_id);
1876: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1877: := ln_primary_balance_id;
1878: hr_utility.trace('act_info6' || ln_primary_balance_id);
1879: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1874: := prev_element_type_id;
1875: hr_utility.trace('act_info2' || prev_element_type_id);
1876: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1877: := ln_primary_balance_id;
1878: hr_utility.trace('act_info6' || ln_primary_balance_id);
1879: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1880: := ln_processing_priority;
1881: hr_utility.trace('act_info7' || ln_processing_priority);
1882: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1877: := ln_primary_balance_id;
1878: hr_utility.trace('act_info6' || ln_primary_balance_id);
1879: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1880: := ln_processing_priority;
1881: hr_utility.trace('act_info7' || ln_processing_priority);
1882: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1883: := fnd_number.number_to_canonical(ln_retro_payvalue);
1884: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));
1885: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1880: := ln_processing_priority;
1881: hr_utility.trace('act_info7' || ln_processing_priority);
1882: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1883: := fnd_number.number_to_canonical(ln_retro_payvalue);
1884: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));
1885: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1886: := 0;
1887: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1888: := lv_reporting_name;
1885: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1886: := 0;
1887: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1888: := lv_reporting_name;
1889: hr_utility.trace('act_info10' || lv_reporting_name);
1890: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1891: := fnd_number.number_to_canonical(ln_retro_hours);
1892: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));
1893: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1888: := lv_reporting_name;
1889: hr_utility.trace('act_info10' || lv_reporting_name);
1890: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1891: := fnd_number.number_to_canonical(ln_retro_hours);
1892: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));
1893: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1894: := p_xfr_action_id;
1895: hr_utility.trace('action_context_id' || p_xfr_action_id);
1896:
1891: := fnd_number.number_to_canonical(ln_retro_hours);
1892: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));
1893: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1894: := p_xfr_action_id;
1895: hr_utility.trace('action_context_id' || p_xfr_action_id);
1896:
1897: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1898: := fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple);
1899: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1897: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1898: := fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple);
1899: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1900: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1901: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1902: END LOOP;
1903: CLOSE c_retro;
1904: hr_utility.set_location(gv_package || lv_procedure_name, 77);
1905:
1900: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1901: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1902: END LOOP;
1903: CLOSE c_retro;
1904: hr_utility.set_location(gv_package || lv_procedure_name, 77);
1905:
1906: END IF;
1907:
1908: ln_tot_pymt_amt := 0;
1912: exit;
1913: end if;
1914: end if;
1915:
1916: hr_utility.trace('lv_element_name = ' || lv_element_name);
1917: hr_utility.trace('ln_rate = ' || ln_rate);
1918: hr_utility.trace('ln_amount = ' || ln_amount);
1919: hr_utility.trace('ln_multiple = ' || ln_multiple);
1920: hr_utility.trace('ln_hours = ' || ln_hours);
1913: end if;
1914: end if;
1915:
1916: hr_utility.trace('lv_element_name = ' || lv_element_name);
1917: hr_utility.trace('ln_rate = ' || ln_rate);
1918: hr_utility.trace('ln_amount = ' || ln_amount);
1919: hr_utility.trace('ln_multiple = ' || ln_multiple);
1920: hr_utility.trace('ln_hours = ' || ln_hours);
1921:
1914: end if;
1915:
1916: hr_utility.trace('lv_element_name = ' || lv_element_name);
1917: hr_utility.trace('ln_rate = ' || ln_rate);
1918: hr_utility.trace('ln_amount = ' || ln_amount);
1919: hr_utility.trace('ln_multiple = ' || ln_multiple);
1920: hr_utility.trace('ln_hours = ' || ln_hours);
1921:
1922: lv_reporting_name := lv_element_name;
1915:
1916: hr_utility.trace('lv_element_name = ' || lv_element_name);
1917: hr_utility.trace('ln_rate = ' || ln_rate);
1918: hr_utility.trace('ln_amount = ' || ln_amount);
1919: hr_utility.trace('ln_multiple = ' || ln_multiple);
1920: hr_utility.trace('ln_hours = ' || ln_hours);
1921:
1922: lv_reporting_name := lv_element_name;
1923:
1916: hr_utility.trace('lv_element_name = ' || lv_element_name);
1917: hr_utility.trace('ln_rate = ' || ln_rate);
1918: hr_utility.trace('ln_amount = ' || ln_amount);
1919: hr_utility.trace('ln_multiple = ' || ln_multiple);
1920: hr_utility.trace('ln_hours = ' || ln_hours);
1921:
1922: lv_reporting_name := lv_element_name;
1923:
1924: ln_step := 15;
1941: ln_tot_pymt_amt := ln_tot_pymt_amt + ln_payments_amount;
1942:
1943: /*Insert this into the plsql table */
1944:
1945: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1946: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1947: hr_utility.trace('ln_index = ' || ln_index);
1948:
1949:
1943: /*Insert this into the plsql table */
1944:
1945: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1946: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1947: hr_utility.trace('ln_index = ' || ln_index);
1948:
1949:
1950: ln_step := 20;
1951: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1953: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1954: := '00-000-0000';
1955: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1956: := lv_classification_name;
1957: hr_utility.trace('action_info_category2' || lv_classification_name);
1958: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1959: := ln_element_type_id;
1960: hr_utility.trace('act_info22' || prev_element_type_id);
1961: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1956: := lv_classification_name;
1957: hr_utility.trace('action_info_category2' || lv_classification_name);
1958: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1959: := ln_element_type_id;
1960: hr_utility.trace('act_info22' || prev_element_type_id);
1961: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1962: := ln_primary_balance_id;
1963: hr_utility.trace('act_info62' || ln_primary_balance_id);
1964: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1959: := ln_element_type_id;
1960: hr_utility.trace('act_info22' || prev_element_type_id);
1961: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1962: := ln_primary_balance_id;
1963: hr_utility.trace('act_info62' || ln_primary_balance_id);
1964: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1965: := ln_processing_priority;
1966: hr_utility.trace('act_info72' || ln_processing_priority);
1967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1962: := ln_primary_balance_id;
1963: hr_utility.trace('act_info62' || ln_primary_balance_id);
1964: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1965: := ln_processing_priority;
1966: hr_utility.trace('act_info72' || ln_processing_priority);
1967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1968: := fnd_number.number_to_canonical(ln_payments_amount);
1969: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1970: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1965: := ln_processing_priority;
1966: hr_utility.trace('act_info72' || ln_processing_priority);
1967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1968: := fnd_number.number_to_canonical(ln_payments_amount);
1969: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1970: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1971: := fnd_number.number_to_canonical(ln_ytd_amount);
1972:
1973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1971: := fnd_number.number_to_canonical(ln_ytd_amount);
1972:
1973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1974: := lv_reporting_name;
1975: hr_utility.trace('act_info102' || lv_reporting_name);
1976: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1977: := fnd_number.number_to_canonical(ln_hours);
1978: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1979: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1974: := lv_reporting_name;
1975: hr_utility.trace('act_info102' || lv_reporting_name);
1976: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1977: := fnd_number.number_to_canonical(ln_hours);
1978: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1979: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1980: := p_xfr_action_id;
1981: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1982: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1984: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1986: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1987: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1988: prev_element_type_id := ln_element_type_id;
1989: prev_run_asg_act_id := hbr(j).run_asg_act_id;
1990: end loop;
1991: end if;
1989: prev_run_asg_act_id := hbr(j).run_asg_act_id;
1990: end loop;
1991: end if;
1992:
1993: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1994: ln_step := 25;
1995: --hr_utility.trace_off;
1996:
1997: EXCEPTION
1991: end if;
1992:
1993: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1994: ln_step := 25;
1995: --hr_utility.trace_off;
1996:
1997: EXCEPTION
1998: when others then
1999: lv_error_message := 'Error at step ' || ln_step ||
1998: when others then
1999: lv_error_message := 'Error at step ' || ln_step ||
2000: ' in ' || gv_package || lv_procedure_name;
2001:
2002: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2003:
2004: lv_error_message :=
2005: pay_emp_action_arch.set_error_message(lv_error_message);
2006:
2003:
2004: lv_error_message :=
2005: pay_emp_action_arch.set_error_message(lv_error_message);
2006:
2007: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2008: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2009: hr_utility.raise_error;
2010:
2011: END populate_hours_x_rate;
2004: lv_error_message :=
2005: pay_emp_action_arch.set_error_message(lv_error_message);
2006:
2007: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2008: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2009: hr_utility.raise_error;
2010:
2011: END populate_hours_x_rate;
2012:
2005: pay_emp_action_arch.set_error_message(lv_error_message);
2006:
2007: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2008: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2009: hr_utility.raise_error;
2010:
2011: END populate_hours_x_rate;
2012:
2013:
2410:
2411: BEGIN
2412: ln_flag := 0;
2413: ln_step := 1;
2414: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2415: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
2416: hr_utility.trace('p_assignment_id ' || p_assignment_id);
2417: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2418: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2411: BEGIN
2412: ln_flag := 0;
2413: ln_step := 1;
2414: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2415: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
2416: hr_utility.trace('p_assignment_id ' || p_assignment_id);
2417: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2418: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2419: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2412: ln_flag := 0;
2413: ln_step := 1;
2414: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2415: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
2416: hr_utility.trace('p_assignment_id ' || p_assignment_id);
2417: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2418: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2419: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2420: hr_utility.trace('p_curr_pymt_action_id '
2413: ln_step := 1;
2414: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2415: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
2416: hr_utility.trace('p_assignment_id ' || p_assignment_id);
2417: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2418: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2419: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2420: hr_utility.trace('p_curr_pymt_action_id '
2421: ||to_char(p_curr_pymt_action_id ));
2414: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2415: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
2416: hr_utility.trace('p_assignment_id ' || p_assignment_id);
2417: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2418: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2419: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2420: hr_utility.trace('p_curr_pymt_action_id '
2421: ||to_char(p_curr_pymt_action_id ));
2422: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2415: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
2416: hr_utility.trace('p_assignment_id ' || p_assignment_id);
2417: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2418: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2419: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2420: hr_utility.trace('p_curr_pymt_action_id '
2421: ||to_char(p_curr_pymt_action_id ));
2422: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2423: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
2416: hr_utility.trace('p_assignment_id ' || p_assignment_id);
2417: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2418: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2419: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2420: hr_utility.trace('p_curr_pymt_action_id '
2421: ||to_char(p_curr_pymt_action_id ));
2422: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2423: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
2424: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
2418: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2419: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2420: hr_utility.trace('p_curr_pymt_action_id '
2421: ||to_char(p_curr_pymt_action_id ));
2422: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2423: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
2424: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
2425: hr_utility.trace('p_curr_pymt_eff_date '||TO_CHAR(p_curr_pymt_eff_date,'DD-MON-YYYY'));
2426:
2419: hr_utility.trace('p_legislation_code '|| p_legislation_code);
2420: hr_utility.trace('p_curr_pymt_action_id '
2421: ||to_char(p_curr_pymt_action_id ));
2422: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2423: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
2424: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
2425: hr_utility.trace('p_curr_pymt_eff_date '||TO_CHAR(p_curr_pymt_eff_date,'DD-MON-YYYY'));
2426:
2427: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2420: hr_utility.trace('p_curr_pymt_action_id '
2421: ||to_char(p_curr_pymt_action_id ));
2422: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2423: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
2424: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
2425: hr_utility.trace('p_curr_pymt_eff_date '||TO_CHAR(p_curr_pymt_eff_date,'DD-MON-YYYY'));
2426:
2427: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2428:
2421: ||to_char(p_curr_pymt_action_id ));
2422: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2423: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
2424: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
2425: hr_utility.trace('p_curr_pymt_eff_date '||TO_CHAR(p_curr_pymt_eff_date,'DD-MON-YYYY'));
2426:
2427: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2428:
2429: if p_legislation_code <> 'US' then
2423: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
2424: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
2425: hr_utility.trace('p_curr_pymt_eff_date '||TO_CHAR(p_curr_pymt_eff_date,'DD-MON-YYYY'));
2426:
2427: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2428:
2429: if p_legislation_code <> 'US' then
2430: ln_step := 5;
2431: populate_hours_x_rate(p_xfr_action_id => p_xfr_action_id
2476: AND fdv.descriptive_flex_context_code = 'US EARNINGS';
2477:
2478: EXCEPTION
2479: WHEN OTHERS THEN
2480: hr_utility.trace('Error occurred while preparing query for lv_sqlstr ');
2481: END;
2482:
2483: BEGIN
2484: SELECT 'select count(peef.'|| fdv.application_column_name || ') FROM pay_element_entries_f peef,
2497: AND fdv.descriptive_flex_context_code = 'US EARNINGS';
2498:
2499: EXCEPTION
2500: WHEN OTHERS THEN
2501: hr_utility.trace('Error occurred while preparing query for lv_sqlstr1 ');
2502: END;
2503:
2504: BEGIN
2505:
2518: AND fdv.descriptive_flex_context_code = 'US EARNINGS';
2519:
2520: EXCEPTION
2521: WHEN OTHERS THEN
2522: hr_utility.trace('Error occurred while preparing query for lv_sqlstr_final ');
2523: END;
2524:
2525: BEGIN
2526: SELECT 'select nvl('|| fdv.application_column_name || ',''AAA'')
2532: AND fdv.descriptive_flex_context_code = 'US EARNINGS';
2533:
2534: EXCEPTION
2535: WHEN OTHERS THEN
2536: hr_utility.trace('Error occurred while preparing query for lv_sqlstr_date ');
2537: END;
2538:
2539:
2540: -- Code added by sneelapa for bug 13905220 ends here.
2548: ln_primary_balance_id,
2549: ln_hours_balance_id,
2550: ln_processing_priority;
2551: if c_cur_sp_action_elements%notfound then
2552: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2553: exit;
2554: end if;
2555:
2556: elsif p_sepchk_flag = 'N' then
2562: ln_hours_balance_id,
2563: ln_processing_priority;
2564: --- here one thing can be added
2565: if c_cur_action_elements%notfound then
2566: hr_utility.set_location(gv_package || lv_procedure_name, 35);
2567: exit;
2568: end if;
2569:
2570: end if;
2570: end if;
2571: -- loop with the first coursor (if not found then exit )
2572: -- if the parameters from second cursor not null then exit loop else move in loop completly
2573:
2574: hr_utility.trace('Element_type_id in get_current_elements = ' || ln_element_type_id);
2575:
2576: if p_legislation_code <> 'US' then
2577: lv_retro_flag := 'N' ;
2578: lv_retro_parent_flag := 'N';
2626: ELSE
2627: ln_flag :=0; -- Addl Ele DFF Info Configured
2628: END IF;
2629:
2630: hr_utility.trace('Step 100: ln_flag before entering into Ele Entry LOOP : '||ln_flag);
2631:
2632: -- Following Code May Need revise
2633: -- Here we are NOT Looping Through the Ele Entries
2634: -- But Getting ele Entry ID so that we Can Check if Addl Ele Entry Configured
2642:
2643: FETCH get_element_entry_id INTO ln_element_entry_id;
2644: IF get_element_entry_id%found THEN
2645: CLOSE get_element_entry_id;
2646: hr_utility.trace('Ele Entry Found. ln_element_entry_id := '||ln_element_entry_id);
2647:
2648: IF ln_flag = 0 then -- Addl Ele DFF Info Configured
2649: hr_utility.trace('Addl Ele DFF Info Configured.');
2650:
2645: CLOSE get_element_entry_id;
2646: hr_utility.trace('Ele Entry Found. ln_element_entry_id := '||ln_element_entry_id);
2647:
2648: IF ln_flag = 0 then -- Addl Ele DFF Info Configured
2649: hr_utility.trace('Addl Ele DFF Info Configured.');
2650:
2651: SELECT TO_CHAR(TRUNC(fnd_date.canonical_to_date(fnd_date.date_to_canonical(p_curr_pymt_eff_date))),'DD-MON-YYYY')
2652: INTO lv_curr_pymt_eff_date
2653: FROM DUAL;
2655: OPEN get_payroll_date_earned (ln_run_assignment_action_id);
2656: FETCH get_payroll_date_earned INTO l_date_earned;
2657: CLOSE get_payroll_date_earned;
2658: --bug no 6950970 ends here
2659: hr_utility.trace('lv_curr_pymt_eff_date := '|| lv_curr_pymt_eff_date);
2660: hr_utility.trace('l_date_earned := '|| l_date_earned);
2661:
2662: /* Commented for bug 13905220
2663:
2656: FETCH get_payroll_date_earned INTO l_date_earned;
2657: CLOSE get_payroll_date_earned;
2658: --bug no 6950970 ends here
2659: hr_utility.trace('lv_curr_pymt_eff_date := '|| lv_curr_pymt_eff_date);
2660: hr_utility.trace('l_date_earned := '|| l_date_earned);
2661:
2662: /* Commented for bug 13905220
2663:
2664: lv_sqlstr := 'select nvl(' || lv_application_column_name ||
2673: ||' BETWEEN effective_start_date AND effective_end_date ';
2674:
2675: */
2676:
2677: hr_utility.trace('Query := '|| lv_sqlstr);
2678:
2679: --bug no 6950970 starts here
2680: begin
2681: --bug no 6950970 ends here
2689: EXECUTE IMMEDIATE lv_sqlstr INTO lv_original_date_paid
2690: USING ln_element_entry_id,
2691: l_date_earned ;
2692:
2693: hr_utility.trace('lv_original_date_earned := '||lv_original_date_earned);
2694:
2695: -- Possibility of Malformed SQL (Added Spaces between)
2696:
2697: /* Commented for bug 13905220 and redefined below
2707: || lv_application_column_name
2708: || ' is not null ' ;
2709:
2710: EXECUTE IMMEDIATE lv_sqlstr1 into ln_addnl_ele_num;
2711: hr_utility.trace('ln_addnl_ele_num' || ln_addnl_ele_num);
2712: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
2713: */
2714:
2715: EXECUTE IMMEDIATE lv_sqlstr1 INTO ln_addnl_ele_num
2708: || ' is not null ' ;
2709:
2710: EXECUTE IMMEDIATE lv_sqlstr1 into ln_addnl_ele_num;
2711: hr_utility.trace('ln_addnl_ele_num' || ln_addnl_ele_num);
2712: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
2713: */
2714:
2715: EXECUTE IMMEDIATE lv_sqlstr1 INTO ln_addnl_ele_num
2716: USING ln_run_assignment_action_id, p_assignment_id,
2731:
2732:
2733: IF (( lv_original_date_paid <> 'AAA' and ln_flag =0) OR (ln_addnl_ele_num > 0))THEN
2734:
2735: hr_utility.trace('(( lv_original_date_paid <> AAA and ln_flag =0) OR (ln_addnl_ele_num > 0)');
2736:
2737: IF ln_addnl_ele_num > 0 THEN
2738: hr_utility.trace('ln_addnl_ele_num > 0');
2739: Archive_addnl_elements(
2734:
2735: hr_utility.trace('(( lv_original_date_paid <> AAA and ln_flag =0) OR (ln_addnl_ele_num > 0)');
2736:
2737: IF ln_addnl_ele_num > 0 THEN
2738: hr_utility.trace('ln_addnl_ele_num > 0');
2739: Archive_addnl_elements(
2740: p_application_column_name => lv_application_column_name
2741: ,p_xfr_action_id => p_xfr_action_id
2742: ,p_assignment_id => p_assignment_id
2767: -- As Base + Addl Ele DFF Config Non-Retro Entry Both Handled above
2768: lv_retro_parent_flag := 'N';
2769: ELSE -- May Need to be Revised
2770:
2771: hr_utility.trace('ln_addnl_ele_num <= 0');
2772: open archive_non_retro_elements( ld_original_date_paid,
2773: ln_element_entry_id,
2774: ln_run_assignment_action_id ) ;
2775: fetch archive_non_retro_elements
2833: EXIT;
2834: */
2835: END IF; -- lv_original_date_paid <> 'AAA' and ln_flag =0
2836:
2837: hr_utility.trace('Before Checking Retro.');
2838:
2839: -- Start Handling Retro Cases
2840: -- Checking IF Retro
2841:
2898: CLOSE get_run_action_id;
2899: END IF;
2900: END IF; -- Legislation US
2901:
2902: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2903: hr_utility.trace('Ele type id = ' || ln_element_type_id);
2904: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2905: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
2906:
2899: END IF;
2900: END IF; -- Legislation US
2901:
2902: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2903: hr_utility.trace('Ele type id = ' || ln_element_type_id);
2904: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2905: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
2906:
2907: if lv_element_classification_name like '% Deductions' then
2900: END IF; -- Legislation US
2901:
2902: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2903: hr_utility.trace('Ele type id = ' || ln_element_type_id);
2904: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2905: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
2906:
2907: if lv_element_classification_name like '% Deductions' then
2908: ln_hours_balance_id := null;
2901:
2902: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2903: hr_utility.trace('Ele type id = ' || ln_element_type_id);
2904: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2905: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
2906:
2907: if lv_element_classification_name like '% Deductions' then
2908: ln_hours_balance_id := null;
2909: end if;
2923: := ln_hours_balance_id;
2924: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2925: := '00-000-0000';
2926:
2927: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2928: ln_step := 20;
2929: IF ((lv_retro_flag = 'N' ) OR (lv_retro_parent_flag = 'Y')) THEN
2930: IF lv_original_date_earned = 'AAA' THEN
2931: lv_original_date_earned := null;
2976: close c_cur_sp_action_elements;
2977: elsif p_sepchk_flag = 'N' then
2978: close c_cur_action_elements;
2979: end if;
2980: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2981: ln_step := 25;
2982:
2983: EXCEPTION
2984: when others then
2984: when others then
2985: lv_error_message := 'Error at step ' || ln_step ||
2986: ' in ' || gv_package || lv_procedure_name;
2987:
2988: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2989:
2990: lv_error_message :=
2991: pay_emp_action_arch.set_error_message(lv_error_message);
2992:
2989:
2990: lv_error_message :=
2991: pay_emp_action_arch.set_error_message(lv_error_message);
2992:
2993: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2994: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2995: hr_utility.raise_error;
2996:
2997: END get_current_elements;
2990: lv_error_message :=
2991: pay_emp_action_arch.set_error_message(lv_error_message);
2992:
2993: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2994: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2995: hr_utility.raise_error;
2996:
2997: END get_current_elements;
2998:
2991: pay_emp_action_arch.set_error_message(lv_error_message);
2992:
2993: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2994: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2995: hr_utility.raise_error;
2996:
2997: END get_current_elements;
2998:
2999: /******************************************************************
3090: lv_display_name VARCHAR2(100);
3091:
3092: BEGIN
3093: ln_step:= 1;
3094: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3095: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
3096: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
3097: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
3098: hr_utility.trace('gv_multi_payroll_pymt = '||
3091:
3092: BEGIN
3093: ln_step:= 1;
3094: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3095: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
3096: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
3097: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
3098: hr_utility.trace('gv_multi_payroll_pymt = '||
3099: pay_emp_action_arch.gv_multi_payroll_pymt);
3092: BEGIN
3093: ln_step:= 1;
3094: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3095: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
3096: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
3097: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
3098: hr_utility.trace('gv_multi_payroll_pymt = '||
3099: pay_emp_action_arch.gv_multi_payroll_pymt);
3100: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
3093: ln_step:= 1;
3094: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3095: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
3096: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
3097: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
3098: hr_utility.trace('gv_multi_payroll_pymt = '||
3099: pay_emp_action_arch.gv_multi_payroll_pymt);
3100: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
3101:
3094: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3095: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
3096: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
3097: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
3098: hr_utility.trace('gv_multi_payroll_pymt = '||
3099: pay_emp_action_arch.gv_multi_payroll_pymt);
3100: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
3101:
3102: open c_last_xfr_elements(p_last_xfr_action_id, p_legislation_code);
3096: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
3097: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
3098: hr_utility.trace('gv_multi_payroll_pymt = '||
3099: pay_emp_action_arch.gv_multi_payroll_pymt);
3100: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
3101:
3102: open c_last_xfr_elements(p_last_xfr_action_id, p_legislation_code);
3103: loop
3104: fetch c_last_xfr_elements into ln_assignment_id,
3113: ld_effective_date,
3114: ln_ytd_hours,
3115: lv_display_name;
3116:
3117: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3118: if c_last_xfr_elements%notfound then
3119: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3120: exit;
3121: end if;
3115: lv_display_name;
3116:
3117: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3118: if c_last_xfr_elements%notfound then
3119: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3120: exit;
3121: end if;
3122:
3123: ln_step := 5;
3139: close c_get_balance;
3140: ln_primary_balance_id := ln_t_primary_balance_id;
3141: end if;
3142:
3143: hr_utility.trace('Element type id =' || ln_element_type_id);
3144: hr_utility.trace('Reporting Name =' || lv_reporting_name);
3145: hr_utility.trace('JD Code =' || lv_jurisdiction_code);
3146: hr_utility.trace('Ele Class =' || lv_element_classfication_name);
3147:
3140: ln_primary_balance_id := ln_t_primary_balance_id;
3141: end if;
3142:
3143: hr_utility.trace('Element type id =' || ln_element_type_id);
3144: hr_utility.trace('Reporting Name =' || lv_reporting_name);
3145: hr_utility.trace('JD Code =' || lv_jurisdiction_code);
3146: hr_utility.trace('Ele Class =' || lv_element_classfication_name);
3147:
3148: ln_step := 6;
3141: end if;
3142:
3143: hr_utility.trace('Element type id =' || ln_element_type_id);
3144: hr_utility.trace('Reporting Name =' || lv_reporting_name);
3145: hr_utility.trace('JD Code =' || lv_jurisdiction_code);
3146: hr_utility.trace('Ele Class =' || lv_element_classfication_name);
3147:
3148: ln_step := 6;
3149:
3142:
3143: hr_utility.trace('Element type id =' || ln_element_type_id);
3144: hr_utility.trace('Reporting Name =' || lv_reporting_name);
3145: hr_utility.trace('JD Code =' || lv_jurisdiction_code);
3146: hr_utility.trace('Ele Class =' || lv_element_classfication_name);
3147:
3148: ln_step := 6;
3149:
3150: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);
3146: hr_utility.trace('Ele Class =' || lv_element_classfication_name);
3147:
3148: ln_step := 6;
3149:
3150: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);
3151: hr_utility.trace('ln_assignment_id (prev) = '||ln_assignment_id);
3152:
3153: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' and
3154: p_sepchk_flag = 'Y' and
3147:
3148: ln_step := 6;
3149:
3150: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);
3151: hr_utility.trace('ln_assignment_id (prev) = '||ln_assignment_id);
3152:
3153: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' and
3154: p_sepchk_flag = 'Y' and
3155: ln_assignment_id <> p_assignment_id then
3153: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' and
3154: p_sepchk_flag = 'Y' and
3155: ln_assignment_id <> p_assignment_id then
3156:
3157: hr_utility.trace('action_info_category = ' ||lv_action_info_category);
3158: hr_utility.trace('ln_element_type_id = ' ||ln_element_type_id);
3159: hr_utility.trace('ln_primary_balance_id = '||ln_primary_balance_id);
3160: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
3161:
3154: p_sepchk_flag = 'Y' and
3155: ln_assignment_id <> p_assignment_id then
3156:
3157: hr_utility.trace('action_info_category = ' ||lv_action_info_category);
3158: hr_utility.trace('ln_element_type_id = ' ||ln_element_type_id);
3159: hr_utility.trace('ln_primary_balance_id = '||ln_primary_balance_id);
3160: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
3161:
3162: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3155: ln_assignment_id <> p_assignment_id then
3156:
3157: hr_utility.trace('action_info_category = ' ||lv_action_info_category);
3158: hr_utility.trace('ln_element_type_id = ' ||ln_element_type_id);
3159: hr_utility.trace('ln_primary_balance_id = '||ln_primary_balance_id);
3160: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
3161:
3162: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3163:
3156:
3157: hr_utility.trace('action_info_category = ' ||lv_action_info_category);
3158: hr_utility.trace('ln_element_type_id = ' ||ln_element_type_id);
3159: hr_utility.trace('ln_primary_balance_id = '||ln_primary_balance_id);
3160: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
3161:
3162: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3163:
3164: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3209: end if;
3210:
3211: ln_step := 10;
3212: if lv_element_archived = 'N' then
3213: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3214: /**************************************************************
3215: ** Bug 3567107: Check to see if the element is still effective
3216: ** the primary balance is there before archiving
3217: ** the value when picking elements which have
3272: := pay_emp_action_arch.get_defined_balance_id
3273: (ln_primary_balance_id,
3274: gv_ytd_balance_dimension,
3275: p_legislation_code);
3276: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3277: if ln_ytd_defined_balance_id is not null then
3278: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
3279: ln_ytd_defined_balance_id,
3280: p_ytd_balcall_aaid),0);
3278: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
3279: ln_ytd_defined_balance_id,
3280: p_ytd_balcall_aaid),0);
3281: end if;
3282: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3283: if ln_hours_balance_id is not null then
3284: ln_ytd_hours_balance_id
3285: := pay_emp_action_arch.get_defined_balance_id
3286: (ln_hours_balance_id,
3285: := pay_emp_action_arch.get_defined_balance_id
3286: (ln_hours_balance_id,
3287: gv_ytd_balance_dimension,
3288: p_legislation_code);
3289: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3290: if ln_ytd_hours_balance_id is not null then
3291: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
3292: ln_ytd_hours_balance_id,
3293: p_ytd_balcall_aaid),0);
3290: if ln_ytd_hours_balance_id is not null then
3291: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
3292: ln_ytd_hours_balance_id,
3293: p_ytd_balcall_aaid),0);
3294: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3295: end if;
3296: end if;
3297:
3298: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
3294: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3295: end if;
3296: end if;
3297:
3298: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
3299: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
3300:
3301: if (( nvl(ln_ytd_amount, 0) + nvl(ln_payments_amount, 0) <> 0 ) or
3302: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) then
3295: end if;
3296: end if;
3297:
3298: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
3299: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
3300:
3301: if (( nvl(ln_ytd_amount, 0) + nvl(ln_payments_amount, 0) <> 0 ) or
3302: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) then
3303:
3300:
3301: if (( nvl(ln_ytd_amount, 0) + nvl(ln_payments_amount, 0) <> 0 ) or
3302: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) then
3303:
3304: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3305: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3306: hr_utility.trace('ln_index = ' || ln_index);
3307: ln_step := 20;
3308: if lv_element_classfication_name in ('Earnings',
3302: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) then
3303:
3304: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3305: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3306: hr_utility.trace('ln_index = ' || ln_index);
3307: ln_step := 20;
3308: if lv_element_classfication_name in ('Earnings',
3309: 'Alien/Expat Earnings',
3310: 'Supplemental Earnings',
3361: end if;
3362: end loop;
3363: close c_last_xfr_elements;
3364:
3365: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3366: ln_step := 25;
3367:
3368:
3369:
3371: when others then
3372: lv_error_message := 'Error at step ' || ln_step ||
3373: ' in ' || gv_package || lv_procedure_name;
3374:
3375: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3376:
3377: lv_error_message :=
3378: pay_emp_action_arch.set_error_message(lv_error_message);
3379:
3376:
3377: lv_error_message :=
3378: pay_emp_action_arch.set_error_message(lv_error_message);
3379:
3380: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3381: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3382: hr_utility.raise_error;
3383:
3384: END get_xfr_elements;
3377: lv_error_message :=
3378: pay_emp_action_arch.set_error_message(lv_error_message);
3379:
3380: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3381: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3382: hr_utility.raise_error;
3383:
3384: END get_xfr_elements;
3385:
3378: pay_emp_action_arch.set_error_message(lv_error_message);
3379:
3380: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3381: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3382: hr_utility.raise_error;
3383:
3384: END get_xfr_elements;
3385:
3386:
3498: ln_step NUMBER;
3499:
3500: BEGIN
3501: ln_step := 1;
3502: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3503: hr_utility.trace('p_xfr_action_id = '|| p_xfr_action_id);
3504: hr_utility.trace('p_tax_unit_id = '|| p_tax_unit_id);
3505: hr_utility.trace('p_last_pymt_action_id = '|| p_last_pymt_action_id );
3506: hr_utility.trace('p_last_pymt_eff_date = '|| p_last_pymt_eff_date);
3499:
3500: BEGIN
3501: ln_step := 1;
3502: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3503: hr_utility.trace('p_xfr_action_id = '|| p_xfr_action_id);
3504: hr_utility.trace('p_tax_unit_id = '|| p_tax_unit_id);
3505: hr_utility.trace('p_last_pymt_action_id = '|| p_last_pymt_action_id );
3506: hr_utility.trace('p_last_pymt_eff_date = '|| p_last_pymt_eff_date);
3507: hr_utility.trace('p_last_xfr_eff_date = '|| p_last_xfr_eff_date);
3500: BEGIN
3501: ln_step := 1;
3502: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3503: hr_utility.trace('p_xfr_action_id = '|| p_xfr_action_id);
3504: hr_utility.trace('p_tax_unit_id = '|| p_tax_unit_id);
3505: hr_utility.trace('p_last_pymt_action_id = '|| p_last_pymt_action_id );
3506: hr_utility.trace('p_last_pymt_eff_date = '|| p_last_pymt_eff_date);
3507: hr_utility.trace('p_last_xfr_eff_date = '|| p_last_xfr_eff_date);
3508: hr_utility.trace('p_pymt_eff_date = '|| p_pymt_eff_date);
3501: ln_step := 1;
3502: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3503: hr_utility.trace('p_xfr_action_id = '|| p_xfr_action_id);
3504: hr_utility.trace('p_tax_unit_id = '|| p_tax_unit_id);
3505: hr_utility.trace('p_last_pymt_action_id = '|| p_last_pymt_action_id );
3506: hr_utility.trace('p_last_pymt_eff_date = '|| p_last_pymt_eff_date);
3507: hr_utility.trace('p_last_xfr_eff_date = '|| p_last_xfr_eff_date);
3508: hr_utility.trace('p_pymt_eff_date = '|| p_pymt_eff_date);
3509:
3502: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3503: hr_utility.trace('p_xfr_action_id = '|| p_xfr_action_id);
3504: hr_utility.trace('p_tax_unit_id = '|| p_tax_unit_id);
3505: hr_utility.trace('p_last_pymt_action_id = '|| p_last_pymt_action_id );
3506: hr_utility.trace('p_last_pymt_eff_date = '|| p_last_pymt_eff_date);
3507: hr_utility.trace('p_last_xfr_eff_date = '|| p_last_xfr_eff_date);
3508: hr_utility.trace('p_pymt_eff_date = '|| p_pymt_eff_date);
3509:
3510: open c_prev_elements(p_assignment_id,
3503: hr_utility.trace('p_xfr_action_id = '|| p_xfr_action_id);
3504: hr_utility.trace('p_tax_unit_id = '|| p_tax_unit_id);
3505: hr_utility.trace('p_last_pymt_action_id = '|| p_last_pymt_action_id );
3506: hr_utility.trace('p_last_pymt_eff_date = '|| p_last_pymt_eff_date);
3507: hr_utility.trace('p_last_xfr_eff_date = '|| p_last_xfr_eff_date);
3508: hr_utility.trace('p_pymt_eff_date = '|| p_pymt_eff_date);
3509:
3510: open c_prev_elements(p_assignment_id,
3511: p_pymt_eff_date,
3504: hr_utility.trace('p_tax_unit_id = '|| p_tax_unit_id);
3505: hr_utility.trace('p_last_pymt_action_id = '|| p_last_pymt_action_id );
3506: hr_utility.trace('p_last_pymt_eff_date = '|| p_last_pymt_eff_date);
3507: hr_utility.trace('p_last_xfr_eff_date = '|| p_last_xfr_eff_date);
3508: hr_utility.trace('p_pymt_eff_date = '|| p_pymt_eff_date);
3509:
3510: open c_prev_elements(p_assignment_id,
3511: p_pymt_eff_date,
3512: p_last_xfr_eff_date);
3518: lv_jurisdiction_code,
3519: ln_primary_balance_id,
3520: ln_hours_balance_id;
3521: if c_prev_elements%notfound then
3522: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3523: exit;
3524: end if;
3525: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3526:
3521: if c_prev_elements%notfound then
3522: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3523: exit;
3524: end if;
3525: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3526:
3527: if lv_element_classfication_name like '% Deductions' then
3528: ln_hours_balance_id := null;
3529: end if;
3578: pay_emp_action_arch.get_defined_balance_id
3579: (ln_primary_balance_id,
3580: gv_ytd_balance_dimension,
3581: p_legislation_code);
3582: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3583: if ln_ytd_defined_balance_id is not null then
3584: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
3585: ln_ytd_defined_balance_id,
3586: p_ytd_balcall_aaid),0);
3583: if ln_ytd_defined_balance_id is not null then
3584: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
3585: ln_ytd_defined_balance_id,
3586: p_ytd_balcall_aaid),0);
3587: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3588: end if;
3589: if ln_hours_balance_id is not null then
3590: ln_ytd_hours_balance_id :=
3591: pay_emp_action_arch.get_defined_balance_id
3591: pay_emp_action_arch.get_defined_balance_id
3592: (ln_hours_balance_id,
3593: gv_ytd_balance_dimension,
3594: p_legislation_code);
3595: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3596: if ln_ytd_hours_balance_id is not null then
3597: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
3598: ln_ytd_hours_balance_id,
3599: p_ytd_balcall_aaid),0);
3596: if ln_ytd_hours_balance_id is not null then
3597: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
3598: ln_ytd_hours_balance_id,
3599: p_ytd_balcall_aaid),0);
3600: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3601: end if;
3602: end if;
3603:
3604: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3600: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3601: end if;
3602: end if;
3603:
3604: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3605: if nvl(ln_ytd_amount, 0) <> 0 or nvl(ln_payments_amount, 0) <> 0 then
3606: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3607: hr_utility.trace('ln_index = ' || ln_index);
3608: if lv_element_classfication_name in ('Earnings',
3603:
3604: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3605: if nvl(ln_ytd_amount, 0) <> 0 or nvl(ln_payments_amount, 0) <> 0 then
3606: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3607: hr_utility.trace('ln_index = ' || ln_index);
3608: if lv_element_classfication_name in ('Earnings',
3609: 'Alien/Expat Earnings',
3610: 'Supplemental Earnings',
3611: 'Taxable Benefits',
3653: lv_reporting_name := null;
3654: ln_hours_balance_id := null;
3655: end loop;
3656: close c_prev_elements;
3657: hr_utility.set_location(gv_package || lv_procedure_name, 150);
3658:
3659: ln_step := 30;
3660:
3661:
3664:
3665: lv_error_message := 'Error at step ' || ln_step ||
3666: ' in ' || gv_package || lv_procedure_name;
3667:
3668: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3669:
3670: lv_error_message :=
3671: pay_emp_action_arch.set_error_message(lv_error_message);
3672:
3669:
3670: lv_error_message :=
3671: pay_emp_action_arch.set_error_message(lv_error_message);
3672:
3673: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3674: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3675: hr_utility.raise_error;
3676:
3677: END get_missing_xfr_info;
3670: lv_error_message :=
3671: pay_emp_action_arch.set_error_message(lv_error_message);
3672:
3673: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3674: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3675: hr_utility.raise_error;
3676:
3677: END get_missing_xfr_info;
3678:
3671: pay_emp_action_arch.set_error_message(lv_error_message);
3672:
3673: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3674: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3675: hr_utility.raise_error;
3676:
3677: END get_missing_xfr_info;
3678:
3679:
3775: lv_run_bal_status := NULL;
3776: lv_element_archived := 'N';
3777: lv_procedure_name := '.get_prev_ytd_elements';
3778:
3779: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3780: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3781: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3782: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3783: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3776: lv_element_archived := 'N';
3777: lv_procedure_name := '.get_prev_ytd_elements';
3778:
3779: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3780: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3781: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3782: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3783: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3784: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3777: lv_procedure_name := '.get_prev_ytd_elements';
3778:
3779: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3780: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3781: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3782: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3783: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3784: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3785: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3778:
3779: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3780: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3781: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3782: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3783: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3784: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3785: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3786: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3779: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3780: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3781: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3782: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3783: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3784: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3785: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3786: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3787: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3780: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
3781: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3782: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3783: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3784: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3785: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3786: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3787: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3788: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3781: hr_utility.trace('p_assignment_id '|| p_assignment_id);
3782: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3783: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3784: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3785: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3786: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3787: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3788: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3789: hr_utility.trace('p_curr_pymt_action_id '
3782: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
3783: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3784: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3785: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3786: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3787: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3788: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3789: hr_utility.trace('p_curr_pymt_action_id '
3790: ||to_char(p_curr_pymt_action_id ));
3783: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
3784: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3785: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3786: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3787: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3788: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3789: hr_utility.trace('p_curr_pymt_action_id '
3790: ||to_char(p_curr_pymt_action_id ));
3791:
3784: hr_utility.trace('p_curr_pymt_eff_date '|| p_curr_pymt_eff_date);
3785: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3786: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3787: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3788: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3789: hr_utility.trace('p_curr_pymt_action_id '
3790: ||to_char(p_curr_pymt_action_id ));
3791:
3792:
3785: hr_utility.trace('p_start_eff_date '|| p_start_eff_date);
3786: hr_utility.trace('p_legislation_code ' || p_legislation_code);
3787: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
3788: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
3789: hr_utility.trace('p_curr_pymt_action_id '
3790: ||to_char(p_curr_pymt_action_id ));
3791:
3792:
3793: lv_run_bal_status := check_run_balance_status(
3819: lv_jurisdiction_code,
3820: ln_primary_balance_id,
3821: ln_hours_balance_id;
3822: if c_prev_ytd_action_elem_rbr%notfound then
3823: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3824: exit;
3825: end if;
3826: else
3827: fetch c_prev_ytd_action_elements into
3833: lv_jurisdiction_code,
3834: ln_primary_balance_id,
3835: ln_hours_balance_id;
3836: if c_prev_ytd_action_elements%notfound then
3837: hr_utility.set_location(gv_package || lv_procedure_name, 45);
3838: exit;
3839: end if;
3840: end if;
3841:
3838: exit;
3839: end if;
3840: end if;
3841:
3842: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3843: hr_utility.trace('Ele type id = ' || ln_element_type_id);
3844: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
3845: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
3846: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
3839: end if;
3840: end if;
3841:
3842: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3843: hr_utility.trace('Ele type id = ' || ln_element_type_id);
3844: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
3845: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
3846: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
3847: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
3840: end if;
3841:
3842: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3843: hr_utility.trace('Ele type id = ' || ln_element_type_id);
3844: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
3845: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
3846: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
3847: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
3848:
3841:
3842: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3843: hr_utility.trace('Ele type id = ' || ln_element_type_id);
3844: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
3845: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
3846: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
3847: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
3848:
3849: if lv_element_classification_name like '% Deductions' then
3842: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3843: hr_utility.trace('Ele type id = ' || ln_element_type_id);
3844: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
3845: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
3846: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
3847: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
3848:
3849: if lv_element_classification_name like '% Deductions' then
3850: ln_step := 10;
3843: hr_utility.trace('Ele type id = ' || ln_element_type_id);
3844: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
3845: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
3846: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
3847: hr_utility.trace('Ele Class = ' || lv_element_classification_name);
3848:
3849: if lv_element_classification_name like '% Deductions' then
3850: ln_step := 10;
3851: ln_hours_balance_id := null;
3865: = ln_primary_balance_id and
3866: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3867: = lv_jurisdiction_code then
3868:
3869: hr_utility.set_location(gv_package || lv_procedure_name, 65);
3870: lv_element_archived := 'Y';
3871: exit;
3872: end if;
3873: end loop;
3874: end if;
3875:
3876: if lv_element_archived = 'N' then
3877: ln_step := 20;
3878: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3879: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3880: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
3881: := ln_element_type_id;
3882: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3895: /*****************************************************************
3896: ** The Payment Assignemnt Action is not passed to this procedure
3897: ** as we do not want to call the Payment Balance.
3898: *****************************************************************/
3899: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3900:
3901: ln_step := 25;
3902: populate_elements(p_xfr_action_id => p_xfr_action_id
3903: ,p_pymt_assignment_action_id => p_curr_pymt_action_id
3940: else
3941: close c_prev_ytd_action_elements;
3942: end if;
3943:
3944: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3945:
3946:
3947: ln_step := 30;
3948: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3948: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3949: for i in pay_ac_action_arch.lrr_act_tab.first ..
3950: pay_ac_action_arch.lrr_act_tab.last loop
3951:
3952: hr_utility.trace('after populate_elements ftp' ||
3953: ' action_context_id is ' ||
3954: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
3955: hr_utility.trace('action_info_category ' ||
3956: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3951:
3952: hr_utility.trace('after populate_elements ftp' ||
3953: ' action_context_id is ' ||
3954: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
3955: hr_utility.trace('action_info_category ' ||
3956: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3957: hr_utility.trace('act_info1 is ' ||
3958: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3959: hr_utility.trace('act_info10 ' ||
3953: ' action_context_id is ' ||
3954: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
3955: hr_utility.trace('action_info_category ' ||
3956: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3957: hr_utility.trace('act_info1 is ' ||
3958: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3959: hr_utility.trace('act_info10 ' ||
3960: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3961: hr_utility.trace('act_info3 ' ||
3955: hr_utility.trace('action_info_category ' ||
3956: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3957: hr_utility.trace('act_info1 is ' ||
3958: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3959: hr_utility.trace('act_info10 ' ||
3960: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3961: hr_utility.trace('act_info3 ' ||
3962: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3963: hr_utility.trace('act_info4 ' ||
3957: hr_utility.trace('act_info1 is ' ||
3958: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3959: hr_utility.trace('act_info10 ' ||
3960: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3961: hr_utility.trace('act_info3 ' ||
3962: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3963: hr_utility.trace('act_info4 ' ||
3964: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3965: hr_utility.trace('act_info5 ' ||
3959: hr_utility.trace('act_info10 ' ||
3960: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3961: hr_utility.trace('act_info3 ' ||
3962: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3963: hr_utility.trace('act_info4 ' ||
3964: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3965: hr_utility.trace('act_info5 ' ||
3966: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3967: hr_utility.trace('act_info6 ' ||
3961: hr_utility.trace('act_info3 ' ||
3962: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3963: hr_utility.trace('act_info4 ' ||
3964: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3965: hr_utility.trace('act_info5 ' ||
3966: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3967: hr_utility.trace('act_info6 ' ||
3968: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3969: hr_utility.trace('act_info7 ' ||
3963: hr_utility.trace('act_info4 ' ||
3964: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3965: hr_utility.trace('act_info5 ' ||
3966: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3967: hr_utility.trace('act_info6 ' ||
3968: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3969: hr_utility.trace('act_info7 ' ||
3970: pay_ac_action_arch.lrr_act_tab(i).act_info7);
3971: hr_utility.trace('act_info8 ' ||
3965: hr_utility.trace('act_info5 ' ||
3966: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3967: hr_utility.trace('act_info6 ' ||
3968: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3969: hr_utility.trace('act_info7 ' ||
3970: pay_ac_action_arch.lrr_act_tab(i).act_info7);
3971: hr_utility.trace('act_info8 ' ||
3972: pay_ac_action_arch.lrr_act_tab(i).act_info8);
3973:
3967: hr_utility.trace('act_info6 ' ||
3968: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3969: hr_utility.trace('act_info7 ' ||
3970: pay_ac_action_arch.lrr_act_tab(i).act_info7);
3971: hr_utility.trace('act_info8 ' ||
3972: pay_ac_action_arch.lrr_act_tab(i).act_info8);
3973:
3974: end loop;
3975: end if;
3973:
3974: end loop;
3975: end if;
3976:
3977: hr_utility.set_location(gv_package || lv_procedure_name, 110);
3978:
3979: ln_step := 35;
3980: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3981: for j in pay_ac_action_arch.emp_elements_tab.first ..
3980: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3981: for j in pay_ac_action_arch.emp_elements_tab.first ..
3982: pay_ac_action_arch.emp_elements_tab.last loop
3983:
3984: hr_utility.trace('EMP_ELEMENTS_TAB.element_type ' ||
3985: to_char(pay_ac_action_arch.emp_elements_tab(j).element_type_id));
3986: end loop;
3987: end if;
3988:
3985: to_char(pay_ac_action_arch.emp_elements_tab(j).element_type_id));
3986: end loop;
3987: end if;
3988:
3989: hr_utility.set_location(gv_package || lv_procedure_name, 200);
3990:
3991: EXCEPTION
3992: when others then
3993:
3993:
3994: lv_error_message := 'Error at step ' || ln_step ||
3995: ' in ' || gv_package || lv_procedure_name;
3996:
3997: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3998:
3999: lv_error_message :=
4000: pay_emp_action_arch.set_error_message(lv_error_message);
4001:
3998:
3999: lv_error_message :=
4000: pay_emp_action_arch.set_error_message(lv_error_message);
4001:
4002: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4003: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4004: hr_utility.raise_error;
4005:
4006: END get_prev_ytd_elements;
3999: lv_error_message :=
4000: pay_emp_action_arch.set_error_message(lv_error_message);
4001:
4002: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4003: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4004: hr_utility.raise_error;
4005:
4006: END get_prev_ytd_elements;
4007:
4000: pay_emp_action_arch.set_error_message(lv_error_message);
4001:
4002: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4003: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4004: hr_utility.raise_error;
4005:
4006: END get_prev_ytd_elements;
4007:
4008:
4038: BEGIN
4039: ln_step := 1;
4040: lv_procedure_name := '.first_time_process';
4041:
4042: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4043: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
4044: hr_utility.trace('p_assignment_id '|| p_assignment_id);
4045: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
4046: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
4039: ln_step := 1;
4040: lv_procedure_name := '.first_time_process';
4041:
4042: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4043: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
4044: hr_utility.trace('p_assignment_id '|| p_assignment_id);
4045: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
4046: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
4047: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
4040: lv_procedure_name := '.first_time_process';
4041:
4042: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4043: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
4044: hr_utility.trace('p_assignment_id '|| p_assignment_id);
4045: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
4046: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
4047: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
4048: hr_utility.trace('p_legislation_code ' || p_legislation_code);
4041:
4042: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4043: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
4044: hr_utility.trace('p_assignment_id '|| p_assignment_id);
4045: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
4046: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
4047: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
4048: hr_utility.trace('p_legislation_code ' || p_legislation_code);
4049: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
4042: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4043: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
4044: hr_utility.trace('p_assignment_id '|| p_assignment_id);
4045: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
4046: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
4047: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
4048: hr_utility.trace('p_legislation_code ' || p_legislation_code);
4049: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
4050: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
4043: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
4044: hr_utility.trace('p_assignment_id '|| p_assignment_id);
4045: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
4046: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
4047: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
4048: hr_utility.trace('p_legislation_code ' || p_legislation_code);
4049: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
4050: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
4051: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
4044: hr_utility.trace('p_assignment_id '|| p_assignment_id);
4045: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
4046: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
4047: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
4048: hr_utility.trace('p_legislation_code ' || p_legislation_code);
4049: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
4050: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
4051: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
4052: hr_utility.trace('p_curr_pymt_action_id '
4045: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
4046: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
4047: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
4048: hr_utility.trace('p_legislation_code ' || p_legislation_code);
4049: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
4050: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
4051: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
4052: hr_utility.trace('p_curr_pymt_action_id '
4053: ||to_char(p_curr_pymt_action_id ));
4046: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
4047: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
4048: hr_utility.trace('p_legislation_code ' || p_legislation_code);
4049: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
4050: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
4051: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
4052: hr_utility.trace('p_curr_pymt_action_id '
4053: ||to_char(p_curr_pymt_action_id ));
4054:
4047: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
4048: hr_utility.trace('p_legislation_code ' || p_legislation_code);
4049: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
4050: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
4051: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
4052: hr_utility.trace('p_curr_pymt_action_id '
4053: ||to_char(p_curr_pymt_action_id ));
4054:
4055: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4048: hr_utility.trace('p_legislation_code ' || p_legislation_code);
4049: hr_utility.trace('p_sepchk_run_type_id '|| p_sepchk_run_type_id);
4050: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
4051: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
4052: hr_utility.trace('p_curr_pymt_action_id '
4053: ||to_char(p_curr_pymt_action_id ));
4054:
4055: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4056: ln_step := 10;
4051: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
4052: hr_utility.trace('p_curr_pymt_action_id '
4053: ||to_char(p_curr_pymt_action_id ));
4054:
4055: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4056: ln_step := 10;
4057: get_current_elements(p_xfr_action_id => p_xfr_action_id
4058: ,p_curr_pymt_action_id => p_curr_pymt_action_id
4059: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
4063: ,p_sepchk_flag => p_sepchk_flag
4064: ,p_pymt_balcall_aaid => p_pymt_balcall_aaid
4065: ,p_ytd_balcall_aaid => p_ytd_balcall_aaid
4066: ,p_legislation_code => p_legislation_code);
4067: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4068:
4069: ln_step := 20;
4070: get_prev_ytd_elements(p_assignment_id => p_assignment_id
4071: ,p_xfr_action_id => p_xfr_action_id
4081: ,p_action_type2 => 'Q'
4082: ,p_action_type3 => 'B');
4083:
4084: ln_step := 30;
4085: hr_utility.set_location(gv_package || lv_procedure_name, 200);
4086:
4087: EXCEPTION
4088: when others then
4089:
4089:
4090: lv_error_message := 'Error at step ' || ln_step ||
4091: ' in ' || gv_package || lv_procedure_name;
4092:
4093: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4094:
4095: lv_error_message :=
4096: pay_emp_action_arch.set_error_message(lv_error_message);
4097:
4094:
4095: lv_error_message :=
4096: pay_emp_action_arch.set_error_message(lv_error_message);
4097:
4098: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4099: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4100: hr_utility.raise_error;
4101:
4102: END first_time_process;
4095: lv_error_message :=
4096: pay_emp_action_arch.set_error_message(lv_error_message);
4097:
4098: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4099: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4100: hr_utility.raise_error;
4101:
4102: END first_time_process;
4103:
4096: pay_emp_action_arch.set_error_message(lv_error_message);
4097:
4098: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4099: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4100: hr_utility.raise_error;
4101:
4102: END first_time_process;
4103:
4104:
4144: j NUMBER := 0;
4145:
4146: BEGIN
4147: ln_step := 1;
4148: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4149: if pay_ac_action_arch.lrr_act_tab.count > 0 then
4150: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4151:
4152: ln_step := 2;
4146: BEGIN
4147: ln_step := 1;
4148: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4149: if pay_ac_action_arch.lrr_act_tab.count > 0 then
4150: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4151:
4152: ln_step := 2;
4153: for i in pay_ac_action_arch.lrr_act_tab.first ..
4154: pay_ac_action_arch.lrr_act_tab.last loop
4158: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
4159: = 'AC EARNINGS' then
4160: if pay_ac_action_arch.lrr_act_tab(i).act_info1
4161: = 'Earnings' then
4162: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4163: ln_step := 3;
4164: lv_earnings
4165: := lv_earnings +
4166: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4168: := lv_ytd_earnings +
4169: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4170: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4171: = 'Supplemental Earnings' then
4172: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4173: ln_step := 4;
4174: lv_supplemental_earnings
4175: := lv_supplemental_earnings +
4176: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4178: := lv_ytd_supplemental_earnings +
4179: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4180: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4181: = 'Imputed Earnings' then
4182: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4183: ln_step := 5;
4184: lv_imputed_earnings
4185: := lv_imputed_earnings +
4186: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4188: := lv_ytd_imputed_earnings +
4189: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4190: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4191: = 'Non-payroll Payments' then
4192: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4193: ln_step := 6;
4194: lv_non_payroll_payments
4195: := lv_non_payroll_payments +
4196: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4198: := lv_ytd_non_payroll_payments +
4199: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4200: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4201: = 'Taxable Benefits' then
4202: hr_utility.set_location(gv_package || lv_procedure_name, 55);
4203: ln_step := 7;
4204: lv_taxable_benefits
4205: := lv_taxable_benefits +
4206: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4208: := lv_ytd_taxable_benefits +
4209: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4210: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4211: = 'Alien/Expat Earnings' then
4212: hr_utility.set_location(gv_package || lv_procedure_name, 56);
4213: ln_step := 8;
4214: lv_alien_expat_earnings
4215: := lv_alien_expat_earnings +
4216: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4222: elsif pay_ac_action_arch.lrr_act_tab(i).action_info_category
4223: = 'AC DEDUCTIONS' then
4224: if pay_ac_action_arch.lrr_act_tab(i).act_info1
4225: = 'Pre-Tax Deductions' then
4226: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4227: ln_step := 15;
4228: lv_pre_tax_deductions
4229: := lv_pre_tax_deductions +
4230: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4232: := lv_ytd_pre_tax_deductions +
4233: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4234: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4235: = 'Involuntary Deductions' then
4236: hr_utility.set_location(gv_package || lv_procedure_name, 70);
4237: ln_step := 16;
4238: lv_involuntary_deductions
4239: := lv_involuntary_deductions +
4240: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4242: := lv_ytd_involuntary_deductions +
4243: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4244: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4245: = 'Voluntary Deductions' then
4246: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4247: ln_step := 17;
4248: lv_voluntary_deductions
4249: := lv_voluntary_deductions +
4250: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4252: := lv_ytd_voluntary_deductions +
4253: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4254: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4255: = 'Tax Deductions' then
4256: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4257: ln_step := 18;
4258: lv_tax_deductions
4259: := lv_tax_deductions +
4260: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4266: end if;
4267: end loop;
4268: end if;
4269:
4270: hr_utility.set_location(gv_package || lv_procedure_name, 95);
4271: ln_step := 24;
4272: j := 0;
4273: if pay_ac_action_arch.ltr_summary_labels.count > 0 then
4274: for j in pay_ac_action_arch.ltr_summary_labels.first..
4286: end if;
4287: end loop;
4288: end if;
4289:
4290: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4291: /* Insert one row for CURRENT and one for YTD */
4292: if pay_ac_action_arch.lrr_act_tab.count > 0 then
4293: ln_step := 25;
4294: -- CURRENT
4292: if pay_ac_action_arch.lrr_act_tab.count > 0 then
4293: ln_step := 25;
4294: -- CURRENT
4295: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4296: hr_utility.trace('ln_index = ' || ln_index);
4297: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4298: := 'AC SUMMARY CURRENT';
4299: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4300: := '00-000-0000';
4320: := fnd_number.number_to_canonical(lv_non_payroll_payments);
4321: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4322: := lv_current_label;
4323:
4324: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4325: -- YTD
4326: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4327: hr_utility.trace('ln_index = ' || ln_index);
4328: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4323:
4324: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4325: -- YTD
4326: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4327: hr_utility.trace('ln_index = ' || ln_index);
4328: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4329: := 'AC SUMMARY YTD';
4330: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4331: := '00-000-0000';
4352: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4353: := lv_ytd_label;
4354: end if;
4355:
4356: hr_utility.set_location(gv_package || lv_procedure_name, 200);
4357: ln_step := 15;
4358:
4359: EXCEPTION
4360: when others then
4361:
4362: lv_error_message := 'Error at step ' || ln_step ||
4363: ' in ' || gv_package || lv_procedure_name;
4364:
4365: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4366:
4367: lv_error_message :=
4368: pay_emp_action_arch.set_error_message(lv_error_message);
4369:
4366:
4367: lv_error_message :=
4368: pay_emp_action_arch.set_error_message(lv_error_message);
4369:
4370: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4371: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4372: hr_utility.raise_error;
4373:
4374: END populate_summary;
4367: lv_error_message :=
4368: pay_emp_action_arch.set_error_message(lv_error_message);
4369:
4370: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4371: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4372: hr_utility.raise_error;
4373:
4374: END populate_summary;
4375:
4368: pay_emp_action_arch.set_error_message(lv_error_message);
4369:
4370: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4371: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4372: hr_utility.raise_error;
4373:
4374: END populate_summary;
4375:
4376: /******************************************************************
4416: ln_step NUMBER;
4417: lv_error_message VARCHAR2(200);
4418:
4419: BEGIN
4420: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4421:
4422: ln_step := 10;
4423: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id); -- Bug 3639249
4424: OPEN c_prev_ytd_action_elements(p_assignment_id
4433: lv_jurisdiction_code,
4434: ln_primary_balance_id,
4435: ln_hours_balance_id;
4436: IF c_prev_ytd_action_elements%NOTFOUND then
4437: hr_utility.set_location(gv_package || lv_procedure_name, 15);
4438: exit;
4439: END IF;
4440:
4441: ln_step := 20;
4438: exit;
4439: END IF;
4440:
4441: ln_step := 20;
4442: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4443: hr_utility.trace('================= Fetched Element ==================');
4444: hr_utility.trace('ele classification = '||lv_element_classification_name);
4445: hr_utility.trace('ele type id = ' || ln_element_type_id);
4446: hr_utility.trace('reporting name = ' || lv_reporting_name);
4439: END IF;
4440:
4441: ln_step := 20;
4442: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4443: hr_utility.trace('================= Fetched Element ==================');
4444: hr_utility.trace('ele classification = '||lv_element_classification_name);
4445: hr_utility.trace('ele type id = ' || ln_element_type_id);
4446: hr_utility.trace('reporting name = ' || lv_reporting_name);
4447: hr_utility.trace('primary balance id = ' || ln_primary_balance_id);
4440:
4441: ln_step := 20;
4442: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4443: hr_utility.trace('================= Fetched Element ==================');
4444: hr_utility.trace('ele classification = '||lv_element_classification_name);
4445: hr_utility.trace('ele type id = ' || ln_element_type_id);
4446: hr_utility.trace('reporting name = ' || lv_reporting_name);
4447: hr_utility.trace('primary balance id = ' || ln_primary_balance_id);
4448: hr_utility.trace('hours balance id = ' || ln_hours_balance_id);
4441: ln_step := 20;
4442: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4443: hr_utility.trace('================= Fetched Element ==================');
4444: hr_utility.trace('ele classification = '||lv_element_classification_name);
4445: hr_utility.trace('ele type id = ' || ln_element_type_id);
4446: hr_utility.trace('reporting name = ' || lv_reporting_name);
4447: hr_utility.trace('primary balance id = ' || ln_primary_balance_id);
4448: hr_utility.trace('hours balance id = ' || ln_hours_balance_id);
4449:
4442: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4443: hr_utility.trace('================= Fetched Element ==================');
4444: hr_utility.trace('ele classification = '||lv_element_classification_name);
4445: hr_utility.trace('ele type id = ' || ln_element_type_id);
4446: hr_utility.trace('reporting name = ' || lv_reporting_name);
4447: hr_utility.trace('primary balance id = ' || ln_primary_balance_id);
4448: hr_utility.trace('hours balance id = ' || ln_hours_balance_id);
4449:
4450: if lv_jurisdiction_code <> '00-000-0000' then
4443: hr_utility.trace('================= Fetched Element ==================');
4444: hr_utility.trace('ele classification = '||lv_element_classification_name);
4445: hr_utility.trace('ele type id = ' || ln_element_type_id);
4446: hr_utility.trace('reporting name = ' || lv_reporting_name);
4447: hr_utility.trace('primary balance id = ' || ln_primary_balance_id);
4448: hr_utility.trace('hours balance id = ' || ln_hours_balance_id);
4449:
4450: if lv_jurisdiction_code <> '00-000-0000' then
4451: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
4444: hr_utility.trace('ele classification = '||lv_element_classification_name);
4445: hr_utility.trace('ele type id = ' || ln_element_type_id);
4446: hr_utility.trace('reporting name = ' || lv_reporting_name);
4447: hr_utility.trace('primary balance id = ' || ln_primary_balance_id);
4448: hr_utility.trace('hours balance id = ' || ln_hours_balance_id);
4449:
4450: if lv_jurisdiction_code <> '00-000-0000' then
4451: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
4452: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
4464: end if;
4465:
4466: if ln_hours_balance_id is not null then
4467: ln_step := 30;
4468: hr_utility.set_location(gv_package || lv_procedure_name, 22);
4469: ln_ytd_hours_balance_id
4470: := pay_emp_action_arch.get_defined_balance_id(
4471: ln_hours_balance_id,
4472: gv_ytd_balance_dimension,
4470: := pay_emp_action_arch.get_defined_balance_id(
4471: ln_hours_balance_id,
4472: gv_ytd_balance_dimension,
4473: p_legislation_code);
4474: hr_utility.trace('ln_ytd_hours_balance_id = '||
4475: ln_ytd_hours_balance_id);
4476: hr_utility.set_location(gv_package || lv_procedure_name, 24);
4477:
4478: ln_step := 40;
4472: gv_ytd_balance_dimension,
4473: p_legislation_code);
4474: hr_utility.trace('ln_ytd_hours_balance_id = '||
4475: ln_ytd_hours_balance_id);
4476: hr_utility.set_location(gv_package || lv_procedure_name, 24);
4477:
4478: ln_step := 40;
4479: if ln_ytd_hours_balance_id is not null then
4480: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
4479: if ln_ytd_hours_balance_id is not null then
4480: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
4481: ln_ytd_hours_balance_id,
4482: p_assignment_action_id),0);
4483: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4484: hr_utility.set_location(gv_package || lv_procedure_name, 26);
4485: end if;
4486: end if; --Hours
4487:
4480: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
4481: ln_ytd_hours_balance_id,
4482: p_assignment_action_id),0);
4483: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4484: hr_utility.set_location(gv_package || lv_procedure_name, 26);
4485: end if;
4486: end if; --Hours
4487:
4488: ln_step := 50;
4490: := pay_emp_action_arch.get_defined_balance_id
4491: (ln_primary_balance_id,
4492: gv_ytd_balance_dimension,
4493: p_legislation_code);
4494: hr_utility.trace('ln_ytd_defined_balance_id = '||
4495: ln_ytd_defined_balance_id);
4496: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4497: if ln_ytd_defined_balance_id is not null then
4498: ln_step := 60;
4492: gv_ytd_balance_dimension,
4493: p_legislation_code);
4494: hr_utility.trace('ln_ytd_defined_balance_id = '||
4495: ln_ytd_defined_balance_id);
4496: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4497: if ln_ytd_defined_balance_id is not null then
4498: ln_step := 60;
4499: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
4500: ln_ytd_defined_balance_id,
4498: ln_step := 60;
4499: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
4500: ln_ytd_defined_balance_id,
4501: p_assignment_action_id),0);
4502: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4503: end if;
4504: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4505:
4506:
4500: ln_ytd_defined_balance_id,
4501: p_assignment_action_id),0);
4502: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4503: end if;
4504: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4505:
4506:
4507: if nvl(ln_ytd_amount, 0) <> 0 then
4508: ln_step := 70;
4507: if nvl(ln_ytd_amount, 0) <> 0 then
4508: ln_step := 70;
4509: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
4510:
4511: hr_utility.trace('ln_element_index = '||ln_element_index);
4512:
4513: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
4514: := ln_element_type_id;
4515: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
4526: := lv_jurisdiction_code;
4527:
4528:
4529: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4530: hr_utility.trace('ln_index = '||ln_index);
4531: if lv_element_classification_name in ('Earnings',
4532: 'Supplemental Earnings',
4533: 'Taxable Benefits',
4534: 'Imputed Earnings',
4533: 'Taxable Benefits',
4534: 'Imputed Earnings',
4535: 'Non-payroll Payments',
4536: 'Alien/Expat Earnings') then
4537: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4538: lv_action_category := 'AC EARNINGS';
4539: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4540: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4541: ln_step := 80;
4535: 'Non-payroll Payments',
4536: 'Alien/Expat Earnings') then
4537: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4538: lv_action_category := 'AC EARNINGS';
4539: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4540: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4541: ln_step := 80;
4542: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4543: := fnd_number.number_to_canonical(ln_current_hours); /*Bug 3311866*/
4536: 'Alien/Expat Earnings') then
4537: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4538: lv_action_category := 'AC EARNINGS';
4539: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4540: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4541: ln_step := 80;
4542: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4543: := fnd_number.number_to_canonical(ln_current_hours); /*Bug 3311866*/
4544: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4545: := fnd_number.number_to_canonical(ln_ytd_hours);
4546: else
4547: lv_action_category := 'AC DEDUCTIONS';
4548: end if;
4549: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4550: hr_utility.trace('lv_action_category = '||lv_action_category);
4551: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4552: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4553: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4546: else
4547: lv_action_category := 'AC DEDUCTIONS';
4548: end if;
4549: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4550: hr_utility.trace('lv_action_category = '||lv_action_category);
4551: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4552: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4553: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4554: ln_step := 90;
4547: lv_action_category := 'AC DEDUCTIONS';
4548: end if;
4549: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4550: hr_utility.trace('lv_action_category = '||lv_action_category);
4551: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4552: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4553: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4554: ln_step := 90;
4555:
4548: end if;
4549: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4550: hr_utility.trace('lv_action_category = '||lv_action_category);
4551: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4552: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4553: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4554: ln_step := 90;
4555:
4556: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4549: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4550: hr_utility.trace('lv_action_category = '||lv_action_category);
4551: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4552: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4553: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4554: ln_step := 90;
4555:
4556: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4557: := lv_action_category;
4574: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4575: := lv_reporting_name;
4576:
4577: end if;
4578: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4579:
4580: END LOOP;
4581: CLOSE c_prev_ytd_action_elements;
4582:
4580: END LOOP;
4581: CLOSE c_prev_ytd_action_elements;
4582:
4583: ln_step := 110;
4584: hr_utility.trace('------------Looping to see pl/sql table --------');
4585: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4586: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4587:
4588: hr_utility.trace('ln_check_count = '||ln_check_count);
4584: hr_utility.trace('------------Looping to see pl/sql table --------');
4585: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4586: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4587:
4588: hr_utility.trace('ln_check_count = '||ln_check_count);
4589: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4590: hr_utility.trace('============= End of Processing '||p_assignment_id||
4591: '=============');
4592: hr_utility.set_location(gv_package || lv_procedure_name,150);
4585: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4586: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4587:
4588: hr_utility.trace('ln_check_count = '||ln_check_count);
4589: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4590: hr_utility.trace('============= End of Processing '||p_assignment_id||
4591: '=============');
4592: hr_utility.set_location(gv_package || lv_procedure_name,150);
4593:
4586: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4587:
4588: hr_utility.trace('ln_check_count = '||ln_check_count);
4589: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4590: hr_utility.trace('============= End of Processing '||p_assignment_id||
4591: '=============');
4592: hr_utility.set_location(gv_package || lv_procedure_name,150);
4593:
4594: EXCEPTION
4588: hr_utility.trace('ln_check_count = '||ln_check_count);
4589: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4590: hr_utility.trace('============= End of Processing '||p_assignment_id||
4591: '=============');
4592: hr_utility.set_location(gv_package || lv_procedure_name,150);
4593:
4594: EXCEPTION
4595: when others then
4596:
4596:
4597: lv_error_message := 'Error at step ' || ln_step ||
4598: ' in ' || gv_package || lv_procedure_name;
4599:
4600: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4601:
4602: lv_error_message :=
4603: pay_emp_action_arch.set_error_message(lv_error_message);
4604:
4601:
4602: lv_error_message :=
4603: pay_emp_action_arch.set_error_message(lv_error_message);
4604:
4605: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4606: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4607: hr_utility.raise_error;
4608:
4609: END process_additional_elements;
4602: lv_error_message :=
4603: pay_emp_action_arch.set_error_message(lv_error_message);
4604:
4605: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4606: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4607: hr_utility.raise_error;
4608:
4609: END process_additional_elements;
4610:
4603: pay_emp_action_arch.set_error_message(lv_error_message);
4604:
4605: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4606: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4607: hr_utility.raise_error;
4608:
4609: END process_additional_elements;
4610:
4611: /******************************************************************
4659:
4660: BEGIN
4661: ln_step := 1;
4662: lv_procedure_name := '.process_baladj_elements';
4663: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4664:
4665: open c_check_baladj(p_assignment_id
4666: ,p_last_xfr_action_id
4667: ,p_tax_unit_id
4668: ,p_payroll_id
4669: ,p_consolidation_set_id
4670: ,p_curr_pymt_eff_date);
4671: fetch c_check_baladj into ld_baladj_date;
4672: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4673: ln_step := 10;
4674: if c_check_baladj%found then
4675: -- There is atleast one balance adjustment done since the last archive
4676: -- run, so, need to find out the element and process it
4673: ln_step := 10;
4674: if c_check_baladj%found then
4675: -- There is atleast one balance adjustment done since the last archive
4676: -- run, so, need to find out the element and process it
4677: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4678: get_prev_ytd_elements(p_assignment_id => p_assignment_id
4679: ,p_xfr_action_id => p_xfr_action_id
4680: ,p_curr_pymt_action_id => p_curr_pymt_action_id
4681: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
4689: ,p_action_type2 => ''
4690: ,p_action_type3 => '');
4691: end if;
4692: close c_check_baladj;
4693: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4694: ln_step := 20;
4695:
4696: EXCEPTION
4697: when others then
4698:
4699: lv_error_message := 'Error at step ' || ln_step ||
4700: ' in ' || gv_package || lv_procedure_name;
4701:
4702: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4703:
4704: lv_error_message :=
4705: pay_emp_action_arch.set_error_message(lv_error_message);
4706:
4703:
4704: lv_error_message :=
4705: pay_emp_action_arch.set_error_message(lv_error_message);
4706:
4707: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4708: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4709: hr_utility.raise_error;
4710:
4711: END process_baladj_elements;
4704: lv_error_message :=
4705: pay_emp_action_arch.set_error_message(lv_error_message);
4706:
4707: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4708: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4709: hr_utility.raise_error;
4710:
4711: END process_baladj_elements;
4712:
4705: pay_emp_action_arch.set_error_message(lv_error_message);
4706:
4707: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4708: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4709: hr_utility.raise_error;
4710:
4711: END process_baladj_elements;
4712:
4713: Procedure Archive_retro_element (
4964: ln_hours_derv_flag boolean; -- 12548215
4965:
4966: BEGIN
4967:
4968: hr_utility.trace('Entering in package Archive_retro_element');
4969: hr_utility.trace('Run_assignment_action_id = ' || p_run_assignment_action_id) ;
4970: OPEN get_element_entry_id ( p_run_assignment_action_id,
4971: p_assignment_id,
4972: p_element_type_id);
4965:
4966: BEGIN
4967:
4968: hr_utility.trace('Entering in package Archive_retro_element');
4969: hr_utility.trace('Run_assignment_action_id = ' || p_run_assignment_action_id) ;
4970: OPEN get_element_entry_id ( p_run_assignment_action_id,
4971: p_assignment_id,
4972: p_element_type_id);
4973: ln_step := 50;
5001: IF get_element_entry_id%NOTFOUND THEN
5002: close get_element_entry_id;
5003: EXIT;
5004: END IF;
5005: hr_utility.trace('Step 50 : ln_element_entry_id := '||ln_element_entry_id);
5006: hr_utility.trace('Step 50 : lv_creator_type := '||lv_creator_type);
5007: hr_utility.trace('Step 50 : ld_source_start_date := '||ld_source_start_date);
5008:
5009: OPEN get_run_results (p_run_assignment_action_id
5002: close get_element_entry_id;
5003: EXIT;
5004: END IF;
5005: hr_utility.trace('Step 50 : ln_element_entry_id := '||ln_element_entry_id);
5006: hr_utility.trace('Step 50 : lv_creator_type := '||lv_creator_type);
5007: hr_utility.trace('Step 50 : ld_source_start_date := '||ld_source_start_date);
5008:
5009: OPEN get_run_results (p_run_assignment_action_id
5010: ,ln_element_entry_id,p_pymt_eff_date);
5003: EXIT;
5004: END IF;
5005: hr_utility.trace('Step 50 : ln_element_entry_id := '||ln_element_entry_id);
5006: hr_utility.trace('Step 50 : lv_creator_type := '||lv_creator_type);
5007: hr_utility.trace('Step 50 : ld_source_start_date := '||ld_source_start_date);
5008:
5009: OPEN get_run_results (p_run_assignment_action_id
5010: ,ln_element_entry_id,p_pymt_eff_date);
5011: LOOP
5015: IF get_run_results%FOUND THEN
5016: IF lv_pay_value_name = 'Hours' THEN
5017: ln_ytd_hours := ln_ytd_hours + nvl(ln_pay_value,0) ;
5018: ln_hours := nvl(ln_pay_value,0);
5019: hr_utility.trace('ln_hours := '||ln_hours);
5020: hr_utility.trace('ln_ytd_hours is '|| ln_ytd_hours );
5021:
5022: END IF ;
5023:
5016: IF lv_pay_value_name = 'Hours' THEN
5017: ln_ytd_hours := ln_ytd_hours + nvl(ln_pay_value,0) ;
5018: ln_hours := nvl(ln_pay_value,0);
5019: hr_utility.trace('ln_hours := '||ln_hours);
5020: hr_utility.trace('ln_ytd_hours is '|| ln_ytd_hours );
5021:
5022: END IF ;
5023:
5024: IF lv_pay_value_name = 'Pay Value' THEN
5023:
5024: IF lv_pay_value_name = 'Pay Value' THEN
5025: ln_ytd_amount := ln_ytd_amount + nvl(ln_pay_value,0) ;
5026: ln_amount := nvl(ln_pay_value,0) ;
5027: hr_utility.trace('ln_amount := '||ln_amount);
5028: hr_utility.trace('ln_ytd_amount is '|| ln_ytd_amount );
5029: END IF;
5030:
5031: IF lv_pay_value_name = 'Rate' THEN -- 12548215 added if
5024: IF lv_pay_value_name = 'Pay Value' THEN
5025: ln_ytd_amount := ln_ytd_amount + nvl(ln_pay_value,0) ;
5026: ln_amount := nvl(ln_pay_value,0) ;
5027: hr_utility.trace('ln_amount := '||ln_amount);
5028: hr_utility.trace('ln_ytd_amount is '|| ln_ytd_amount );
5029: END IF;
5030:
5031: IF lv_pay_value_name = 'Rate' THEN -- 12548215 added if
5032: ln_rate_disp := nvl(ln_pay_value,0) ;
5030:
5031: IF lv_pay_value_name = 'Rate' THEN -- 12548215 added if
5032: ln_rate_disp := nvl(ln_pay_value,0) ;
5033: ln_rate := ln_rate_disp;
5034: hr_utility.trace('ln_rate_disp := '||ln_rate_disp);
5035: END IF;
5036:
5037: ELSE
5038:
5080: ln_rate:=ln_amount/ln_hours;
5081: end if;
5082: END IF;
5083:
5084: hr_utility.trace('Before Opening Cursor archive_retro_elements');
5085: OPEN archive_retro_elements ( ln_element_entry_id ,
5086: p_run_assignment_action_id );
5087: FETCH archive_retro_elements INTO lv_original_date_earned
5088: ,lv_effective_start_date
5088: ,lv_effective_start_date
5089: ,lv_effective_end_date
5090: ,lv_category;
5091: CLOSE archive_retro_elements ;
5092: hr_utility.trace('After Closing Cursor archive_retro_elements');
5093: hr_utility.trace('lv_original_date_earned := '||lv_original_date_earned);
5094: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
5095: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
5096: hr_utility.trace('lv_category := '||lv_category);
5089: ,lv_effective_end_date
5090: ,lv_category;
5091: CLOSE archive_retro_elements ;
5092: hr_utility.trace('After Closing Cursor archive_retro_elements');
5093: hr_utility.trace('lv_original_date_earned := '||lv_original_date_earned);
5094: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
5095: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
5096: hr_utility.trace('lv_category := '||lv_category);
5097: -- Added For Work At Home Condition
5090: ,lv_category;
5091: CLOSE archive_retro_elements ;
5092: hr_utility.trace('After Closing Cursor archive_retro_elements');
5093: hr_utility.trace('lv_original_date_earned := '||lv_original_date_earned);
5094: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
5095: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
5096: hr_utility.trace('lv_category := '||lv_category);
5097: -- Added For Work At Home Condition
5098: OPEN c_cur_get_wrkathome(p_assignment_id,p_pymt_eff_date);
5091: CLOSE archive_retro_elements ;
5092: hr_utility.trace('After Closing Cursor archive_retro_elements');
5093: hr_utility.trace('lv_original_date_earned := '||lv_original_date_earned);
5094: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
5095: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
5096: hr_utility.trace('lv_category := '||lv_category);
5097: -- Added For Work At Home Condition
5098: OPEN c_cur_get_wrkathome(p_assignment_id,p_pymt_eff_date);
5099: FETCH c_cur_get_wrkathome INTO lv_wrk_at_home
5092: hr_utility.trace('After Closing Cursor archive_retro_elements');
5093: hr_utility.trace('lv_original_date_earned := '||lv_original_date_earned);
5094: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
5095: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
5096: hr_utility.trace('lv_category := '||lv_category);
5097: -- Added For Work At Home Condition
5098: OPEN c_cur_get_wrkathome(p_assignment_id,p_pymt_eff_date);
5099: FETCH c_cur_get_wrkathome INTO lv_wrk_at_home
5100: ,ln_person_id
5145: END IF; -- Work At Home 'N'
5146:
5147: -- populating temporary plsql table
5148: --
5149: hr_utility.trace('lv_jurisdiction_flag := '||lv_jurisdiction_flag);
5150: -- Comment Starts From Here
5151: -- Comment Till Here
5152:
5153: lv_action_category := 'AC DEDUCTIONS';
5171: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5172: := fnd_number.number_to_canonical(0);
5173: end if; -- Classification Earnings
5174:
5175: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5176: /* Insert this into the plsql table if Current or YTD
5177: amount is not Zero */
5178: ln_step :=21;
5179: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5195: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5196: := p_processing_priority;
5197: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5198: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5199: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5200: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5201: := p_reporting_name;
5202: IF lv_action_category = 'AC DEDUCTIONS' THEN
5203: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
5204: := p_reporting_name;
5205: END IF;
5206: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
5207: := lv_original_date_earned;
5208: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
5209: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
5210: := lv_effective_start_date;
5211: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5212: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5207: := lv_original_date_earned;
5208: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
5209: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
5210: := lv_effective_start_date;
5211: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5212: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5213: := lv_effective_end_date ;
5214: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5215: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5210: := lv_effective_start_date;
5211: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5212: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5213: := lv_effective_end_date ;
5214: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5215: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5216: := lv_category;
5217: hr_utility.trace('lv_category ' || lv_category );
5218: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5213: := lv_effective_end_date ;
5214: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5215: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5216: := lv_category;
5217: hr_utility.trace('lv_category ' || lv_category );
5218: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5219: := lv_jurisdiction_flag;
5220: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5221: := fnd_number.number_to_canonical(0);
5219: := lv_jurisdiction_flag;
5220: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5221: := fnd_number.number_to_canonical(0);
5222:
5223: hr_utility.set_location(gv_package || lv_procedure_name, 150);
5224:
5225: ln_step := 20;
5226:
5227:
5255: p_primary_balance_id,
5256: gv_ytd_balance_dimension,
5257: p_legislation_code);
5258:
5259: hr_utility.trace('ln_ytd_defined_balance_id = ' ||
5260: ln_ytd_defined_balance_id);
5261:
5262: if ln_ytd_defined_balance_id is not null then
5263: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
5264: ln_ytd_defined_balance_id,
5265: p_ytd_balcall_aaid),0);
5266: end if;
5267: if p_hours_balance_id is not null then
5268: hr_utility.set_location(gv_package || lv_procedure_name, 20);
5269: ln_ytd_hours_balance_id
5270: := pay_emp_action_arch.get_defined_balance_id(
5271: p_hours_balance_id,
5272: gv_ytd_balance_dimension,
5271: p_hours_balance_id,
5272: gv_ytd_balance_dimension,
5273: p_legislation_code);
5274:
5275: hr_utility.trace('ln_ytd_hours_balance_id = ' ||
5276: ln_ytd_hours_balance_id);
5277:
5278: if ln_ytd_hours_balance_id is not null then
5279: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
5278: if ln_ytd_hours_balance_id is not null then
5279: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
5280: ln_ytd_hours_balance_id,
5281: p_ytd_balcall_aaid),0);
5282: hr_utility.set_location(gv_package || lv_procedure_name, 60);
5283: end if;
5284: end if;
5285:
5286: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5284: end if;
5285:
5286: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5287: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5288: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5289:
5290: /*Bug# 13785386 - Start*/
5291: /* if ln_hours_derv_flag then --to pull YTD hours if hours is dervied.
5292: ln_ytd_hours := ln_ytd_hours + ln_hours; -- as YTD balance would be unaffected as the hours
5299: = 'AC EARNINGS' then
5300:
5301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5302: := fnd_number.number_to_canonical(ln_ytd_hours); -- Bug# 13877047
5303: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5304: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5305:
5306: end if;
5307: -- End Addition
5300:
5301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5302: := fnd_number.number_to_canonical(ln_ytd_hours); -- Bug# 13877047
5303: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5304: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5305:
5306: end if;
5307: -- End Addition
5308: ELSE
5310: -- That Can be Subtracted during Base Population
5311: --
5312: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5313: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5314: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5315: gv_ytd_amount := ln_ytd_amount ;
5316: /*gv_ytd_amount := nvl(gv_ytd_amount,0)+ln_ytd_amount ; --Bug# 13785386 */
5317:
5318: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5319: := fnd_number.number_to_canonical(ln_ytd_hours); -- Bug# 13877047
5320: gv_ytd_hour := ln_ytd_hours ;
5321: /*gv_ytd_hour := nvl(gv_ytd_hour,0)+ln_ytd_hours ; --Bug# 13785386 */
5322:
5323: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5324:
5325: END IF; -- p_retro_base 'Y'
5326: /*Bug# 13785386 - Start*/
5327: /*
5330: /*Bug# 13785386 - End*/
5331:
5332: EXCEPTION
5333: when others then
5334: hr_utility.trace(' Error In archive_retro_elements procedure');
5335: hr_utility.trace('error occured at step ' || ln_step );
5336:
5337: END Archive_retro_element;
5338: Procedure Archive_addnl_elements (p_application_column_name in varchar2
5331:
5332: EXCEPTION
5333: when others then
5334: hr_utility.trace(' Error In archive_retro_elements procedure');
5335: hr_utility.trace('error occured at step ' || ln_step );
5336:
5337: END Archive_retro_element;
5338: Procedure Archive_addnl_elements (p_application_column_name in varchar2
5339: ,p_xfr_action_id in number
5540: ln_bg_id per_people_f.business_group_id%TYPE;
5541:
5542: BEGIN
5543:
5544: hr_utility.trace('Entering in package Archive_addnl_elements');
5545: hr_utility.trace('Run_assignment_action_id = ' || p_run_assignment_action_id) ;
5546: hr_utility.trace('Element Type Id in Non retro Archiver ' || p_element_type_id);
5547: OPEN get_element_entry_id ( p_run_assignment_action_id,
5548: p_assignment_id,
5541:
5542: BEGIN
5543:
5544: hr_utility.trace('Entering in package Archive_addnl_elements');
5545: hr_utility.trace('Run_assignment_action_id = ' || p_run_assignment_action_id) ;
5546: hr_utility.trace('Element Type Id in Non retro Archiver ' || p_element_type_id);
5547: OPEN get_element_entry_id ( p_run_assignment_action_id,
5548: p_assignment_id,
5549: p_element_type_id);
5542: BEGIN
5543:
5544: hr_utility.trace('Entering in package Archive_addnl_elements');
5545: hr_utility.trace('Run_assignment_action_id = ' || p_run_assignment_action_id) ;
5546: hr_utility.trace('Element Type Id in Non retro Archiver ' || p_element_type_id);
5547: OPEN get_element_entry_id ( p_run_assignment_action_id,
5548: p_assignment_id,
5549: p_element_type_id);
5550: ln_step := 50;
5559: lv_sqlstr_final := lv_sqlstr1 || lv_sqlstr2 || lv_sqlstr3 || lv_sqlstr4 ;
5560:
5561: execute immediate lv_sqlstr_final into lv_check_date ;
5562: ln_step :=51;
5563: hr_utility.trace('lv_check_date == ' || lv_check_date);
5564: LOOP
5565:
5566: FETCH get_element_entry_id INTO ln_element_entry_id,
5567: lv_creator_type,
5584: END IF;
5585: lv_original_date_earned := nvl(lv_original_date_earned ,p_pymt_eff_date);
5586:
5587:
5588: hr_utility.trace('lv_original_date_earned in step 53 is' || lv_original_date_earned) ;
5589:
5590: ld_original_date_paid := fnd_date.canonical_to_date(lv_original_date_earned);
5591:
5592: ln_step :=54;
5602: lv_pay_value_name;
5603: IF get_run_results%FOUND THEN
5604: IF lv_pay_value_name = 'Hours' THEN
5605: ln_hours := ln_hours + ln_pay_value;
5606: hr_utility.trace('ln_ytd_hours is '|| ln_ytd_hours );
5607: END IF ;
5608:
5609: IF lv_pay_value_name = 'Pay Value' THEN
5610: ln_amount := ln_amount + ln_pay_value ;
5607: END IF ;
5608:
5609: IF lv_pay_value_name = 'Pay Value' THEN
5610: ln_amount := ln_amount + ln_pay_value ;
5611: hr_utility.trace('ln_ytd_amount is '|| ln_ytd_amount );
5612: END IF;
5613: ELSE
5614: EXIT;
5615: END IF;
5634: ELSE
5635: ln_rate := ln_amount/ln_hours;
5636: END IF;
5637:
5638: hr_utility.trace('ld_original_date_paid := '||ld_original_date_paid);
5639: hr_utility.trace('ln_element_entry_id := '||ln_element_entry_id);
5640: hr_utility.trace('p_run_assignment_action_id := '||p_run_assignment_action_id);
5641:
5642: OPEN archive_non_retro_elements ( ld_original_date_paid,
5635: ln_rate := ln_amount/ln_hours;
5636: END IF;
5637:
5638: hr_utility.trace('ld_original_date_paid := '||ld_original_date_paid);
5639: hr_utility.trace('ln_element_entry_id := '||ln_element_entry_id);
5640: hr_utility.trace('p_run_assignment_action_id := '||p_run_assignment_action_id);
5641:
5642: OPEN archive_non_retro_elements ( ld_original_date_paid,
5643: ln_element_entry_id ,
5636: END IF;
5637:
5638: hr_utility.trace('ld_original_date_paid := '||ld_original_date_paid);
5639: hr_utility.trace('ln_element_entry_id := '||ln_element_entry_id);
5640: hr_utility.trace('p_run_assignment_action_id := '||p_run_assignment_action_id);
5641:
5642: OPEN archive_non_retro_elements ( ld_original_date_paid,
5643: ln_element_entry_id ,
5644: p_run_assignment_action_id );
5645: FETCH archive_non_retro_elements INTO lv_effective_start_date
5646: ,lv_effective_end_date
5647: ,lv_category;
5648: CLOSE archive_non_retro_elements ;
5649: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
5650: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
5651: hr_utility.trace('lv_category := '||lv_category);
5652:
5653: -- Added For Work At Home Condition
5646: ,lv_effective_end_date
5647: ,lv_category;
5648: CLOSE archive_non_retro_elements ;
5649: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
5650: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
5651: hr_utility.trace('lv_category := '||lv_category);
5652:
5653: -- Added For Work At Home Condition
5654: OPEN c_cur_get_wrkathome(p_assignment_id,p_pymt_eff_date); -- Bug# 16318258
5647: ,lv_category;
5648: CLOSE archive_non_retro_elements ;
5649: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
5650: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
5651: hr_utility.trace('lv_category := '||lv_category);
5652:
5653: -- Added For Work At Home Condition
5654: OPEN c_cur_get_wrkathome(p_assignment_id,p_pymt_eff_date); -- Bug# 16318258
5655: FETCH c_cur_get_wrkathome INTO lv_wrk_at_home
5698: into lv_jurisdiction_flag
5699: from dual;
5700: END IF; -- Work at Home 'N'
5701:
5702: hr_utility.trace('lv_jurisdiction_flag := '||lv_jurisdiction_flag);
5703: lv_action_category := 'AC EARNINGS';
5704: ln_step := 15;
5705: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5706:
5705: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5706:
5707: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5708: := fnd_number.number_to_canonical(ln_hours);
5709: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
5710: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5711: /* Insert this into the plsql table if Current or YTD
5712: amount is not Zero */
5713: ln_step :=21;
5706:
5707: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5708: := fnd_number.number_to_canonical(ln_hours);
5709: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
5710: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5711: /* Insert this into the plsql table if Current or YTD
5712: amount is not Zero */
5713: ln_step :=21;
5714: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5733: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5734: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5735: := fnd_number.number_to_canonical(0);
5736:
5737: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5738: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5739: := p_reporting_name;
5740:
5741: IF lv_temp_AAA <> 'AAA' THEN
5740:
5741: IF lv_temp_AAA <> 'AAA' THEN
5742: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
5743: := lv_original_date_earned;
5744: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
5745:
5746: IF lv_check_date = nvl(lv_original_date_earned,p_pymt_eff_date) THEN
5747: count_j := ln_index;
5748: END IF;
5747: count_j := ln_index;
5748: END IF;
5749: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
5750: := lv_effective_start_date;
5751: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5752: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5753: := lv_effective_end_date ;
5754: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5755: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5750: := lv_effective_start_date;
5751: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5752: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5753: := lv_effective_end_date ;
5754: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5755: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5756: := lv_category;
5757: hr_utility.trace('lv_category ' || lv_category );
5758: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5753: := lv_effective_end_date ;
5754: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5755: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5756: := lv_category;
5757: hr_utility.trace('lv_category ' || lv_category );
5758: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5759: := lv_jurisdiction_flag;
5760: END IF;
5761:
5766: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := 'N/A';
5767: END IF;
5768: */
5769:
5770: hr_utility.set_location(gv_package || lv_procedure_name, 150);
5771: ln_step := 20;
5772: lv_temp_AAA := 'BBB' ;
5773: end loop;
5774:
5795: p_primary_balance_id,
5796: gv_ytd_balance_dimension,
5797: p_legislation_code);
5798:
5799: hr_utility.trace('ln_ytd_defined_balance_id = ' ||
5800: ln_ytd_defined_balance_id);
5801:
5802: ln_step := 4;
5803: if p_hours_balance_id is not null then
5800: ln_ytd_defined_balance_id);
5801:
5802: ln_step := 4;
5803: if p_hours_balance_id is not null then
5804: hr_utility.set_location(gv_package || lv_procedure_name, 20);
5805: ln_ytd_hours_balance_id
5806: := pay_emp_action_arch.get_defined_balance_id(
5807: p_hours_balance_id,
5808: gv_ytd_balance_dimension,
5807: p_hours_balance_id,
5808: gv_ytd_balance_dimension,
5809: p_legislation_code);
5810:
5811: hr_utility.trace('ln_ytd_hours_balance_id = ' ||
5812: ln_ytd_hours_balance_id);
5813:
5814: end if;
5815:
5813:
5814: end if;
5815:
5816: ln_step := 5;
5817: hr_utility.set_location(gv_package || lv_procedure_name, 40);
5818: if ln_ytd_defined_balance_id is not null then
5819: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
5820: ln_ytd_defined_balance_id,
5821: p_ytd_balcall_aaid),0);
5821: p_ytd_balcall_aaid),0);
5822: end if;
5823:
5824: if p_hours_balance_id is not null then
5825: hr_utility.set_location(gv_package || lv_procedure_name, 50);
5826: if ln_ytd_hours_balance_id is not null then
5827: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
5828: ln_ytd_hours_balance_id,
5829: p_ytd_balcall_aaid),0);
5826: if ln_ytd_hours_balance_id is not null then
5827: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
5828: ln_ytd_hours_balance_id,
5829: p_ytd_balcall_aaid),0);
5830: hr_utility.set_location(gv_package || lv_procedure_name, 60);
5831: end if;
5832: end if; --Hours
5833:
5834: ln_step := 8;
5857: p_legislation_code);
5858: end if;
5859: end if; -- p_action_type in ('B','V')
5860: /* end of addition for Reversals and bal adjustments */
5861: hr_utility.trace('ln_pymt_defined_balance_id ' ||
5862: ln_pymt_defined_balance_id);
5863:
5864: if ln_pymt_defined_balance_id is not null then
5865: ln_payments_amount := nvl(pay_balance_pkg.get_value(
5864: if ln_pymt_defined_balance_id is not null then
5865: ln_payments_amount := nvl(pay_balance_pkg.get_value(
5866: ln_pymt_defined_balance_id,
5867: p_pymt_balcall_aaid),0);
5868: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
5869: end if;
5870:
5871: if p_hours_balance_id is not null then
5872: /* Added dimension _ASG_GRE_RUN for reversals and Balance
5892: ,p_legislation_code);
5893: end if;
5894: end if; -- p_action_type in ('B','V')
5895: /* end of addition for reversals and bal adjustments */
5896: hr_utility.trace('ln_pymt_hours_balance_id ' ||
5897: ln_pymt_hours_balance_id);
5898:
5899: hr_utility.set_location(gv_package || lv_procedure_name, 120);
5900: end if; --Hours
5895: /* end of addition for reversals and bal adjustments */
5896: hr_utility.trace('ln_pymt_hours_balance_id ' ||
5897: ln_pymt_hours_balance_id);
5898:
5899: hr_utility.set_location(gv_package || lv_procedure_name, 120);
5900: end if; --Hours
5901: end if; -- p_pymt_balcall_aaid is not null
5902:
5903: ln_step := 15;
5903: ln_step := 15;
5904:
5905: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5906: := fnd_number.number_to_canonical(ln_ytd_amount);
5907: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
5908:
5909: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5910: := fnd_number.number_to_canonical(ln_ytd_hours);
5911: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5907: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
5908:
5909: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5910: := fnd_number.number_to_canonical(ln_ytd_hours);
5911: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5912:
5913: /* Following later to be re-valuated IF worth doing wrt Cost
5914:
5915: IF count_j is null THEN
5914:
5915: IF count_j is null THEN
5916: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5917: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5918: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5919: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5920: := fnd_number.number_to_canonical(ln_ytd_hours);
5921: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5922: END IF;
5917: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5918: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5919: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5920: := fnd_number.number_to_canonical(ln_ytd_hours);
5921: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5922: END IF;
5923: */
5924:
5925: EXCEPTION
5923: */
5924:
5925: EXCEPTION
5926: when others then
5927: hr_utility.trace(' Error In archive_addnl_elements procedure');
5928: hr_utility.trace('error occured at step ' || ln_step );
5929:
5930: END Archive_addnl_elements;
5931:
5924:
5925: EXCEPTION
5926: when others then
5927: hr_utility.trace(' Error In archive_addnl_elements procedure');
5928: hr_utility.trace('error occured at step ' || ln_step );
5929:
5930: END Archive_addnl_elements;
5931:
5932:
6141: ln_bg_id per_people_f.business_group_id%TYPE;
6142:
6143: BEGIN
6144:
6145: hr_utility.trace('Entering in package Archive_addnl_elements');
6146: hr_utility.trace('Run_assignment_action_id = ' || p_run_assignment_action_id) ;
6147: hr_utility.trace('Element Type Id in Non retro Archiver ' || p_element_type_id);
6148: hr_utility.trace('p_application_column_name = ' || p_application_column_name) ;
6149: hr_utility.trace('p_element_type_id = ' || p_element_type_id) ;
6142:
6143: BEGIN
6144:
6145: hr_utility.trace('Entering in package Archive_addnl_elements');
6146: hr_utility.trace('Run_assignment_action_id = ' || p_run_assignment_action_id) ;
6147: hr_utility.trace('Element Type Id in Non retro Archiver ' || p_element_type_id);
6148: hr_utility.trace('p_application_column_name = ' || p_application_column_name) ;
6149: hr_utility.trace('p_element_type_id = ' || p_element_type_id) ;
6150: hr_utility.trace('p_assignment_id = ' || p_assignment_id) ;
6143: BEGIN
6144:
6145: hr_utility.trace('Entering in package Archive_addnl_elements');
6146: hr_utility.trace('Run_assignment_action_id = ' || p_run_assignment_action_id) ;
6147: hr_utility.trace('Element Type Id in Non retro Archiver ' || p_element_type_id);
6148: hr_utility.trace('p_application_column_name = ' || p_application_column_name) ;
6149: hr_utility.trace('p_element_type_id = ' || p_element_type_id) ;
6150: hr_utility.trace('p_assignment_id = ' || p_assignment_id) ;
6151:
6144:
6145: hr_utility.trace('Entering in package Archive_addnl_elements');
6146: hr_utility.trace('Run_assignment_action_id = ' || p_run_assignment_action_id) ;
6147: hr_utility.trace('Element Type Id in Non retro Archiver ' || p_element_type_id);
6148: hr_utility.trace('p_application_column_name = ' || p_application_column_name) ;
6149: hr_utility.trace('p_element_type_id = ' || p_element_type_id) ;
6150: hr_utility.trace('p_assignment_id = ' || p_assignment_id) ;
6151:
6152: OPEN get_element_entry_id ( p_run_assignment_action_id,
6145: hr_utility.trace('Entering in package Archive_addnl_elements');
6146: hr_utility.trace('Run_assignment_action_id = ' || p_run_assignment_action_id) ;
6147: hr_utility.trace('Element Type Id in Non retro Archiver ' || p_element_type_id);
6148: hr_utility.trace('p_application_column_name = ' || p_application_column_name) ;
6149: hr_utility.trace('p_element_type_id = ' || p_element_type_id) ;
6150: hr_utility.trace('p_assignment_id = ' || p_assignment_id) ;
6151:
6152: OPEN get_element_entry_id ( p_run_assignment_action_id,
6153: p_assignment_id,
6146: hr_utility.trace('Run_assignment_action_id = ' || p_run_assignment_action_id) ;
6147: hr_utility.trace('Element Type Id in Non retro Archiver ' || p_element_type_id);
6148: hr_utility.trace('p_application_column_name = ' || p_application_column_name) ;
6149: hr_utility.trace('p_element_type_id = ' || p_element_type_id) ;
6150: hr_utility.trace('p_assignment_id = ' || p_assignment_id) ;
6151:
6152: OPEN get_element_entry_id ( p_run_assignment_action_id,
6153: p_assignment_id,
6154: p_element_type_id);
6163: USING
6164: p_run_assignment_action_id, p_assignment_id, p_element_type_id;
6165:
6166: ln_step :=51;
6167: hr_utility.trace('Srini lv_check_date == ' || lv_check_date);
6168:
6169: LOOP
6170:
6171: FETCH get_element_entry_id INTO ln_element_entry_id,
6178: EXIT;
6179: END IF;
6180: ln_step :=53;
6181:
6182: hr_utility.trace('p_application_column_name == ' || p_application_column_name);
6183: hr_utility.trace('ln_element_entry_id == ' || ln_element_entry_id);
6184:
6185: lv_sqlstr := p_sqlstr_date;
6186:
6179: END IF;
6180: ln_step :=53;
6181:
6182: hr_utility.trace('p_application_column_name == ' || p_application_column_name);
6183: hr_utility.trace('ln_element_entry_id == ' || ln_element_entry_id);
6184:
6185: lv_sqlstr := p_sqlstr_date;
6186:
6187: EXECUTE IMMEDIATE lv_sqlstr
6187: EXECUTE IMMEDIATE lv_sqlstr
6188: INTO lv_original_date_earned
6189: USING ln_element_entry_id;
6190:
6191: hr_utility.trace('Srini lv_original_date_earned == ' || lv_original_date_earned);
6192:
6193: IF lv_original_date_earned = 'AAA' THEN
6194: lv_original_date_earned := fnd_date.date_to_canonical( p_pymt_eff_date);
6195: lv_temp_AAA:= 'AAA' ;
6196: END IF;
6197: lv_original_date_earned := nvl(lv_original_date_earned ,p_pymt_eff_date);
6198:
6199:
6200: hr_utility.trace('lv_original_date_earned in step 53 is' || lv_original_date_earned) ;
6201:
6202: ld_original_date_paid := fnd_date.canonical_to_date(lv_original_date_earned);
6203:
6204: ln_step :=54;
6214: lv_pay_value_name;
6215: IF get_run_results%FOUND THEN
6216: IF lv_pay_value_name = 'Hours' THEN
6217: ln_hours := ln_hours + ln_pay_value;
6218: hr_utility.trace('ln_ytd_hours is '|| ln_ytd_hours );
6219: END IF ;
6220:
6221: IF lv_pay_value_name = 'Pay Value' THEN
6222: ln_amount := ln_amount + ln_pay_value ;
6219: END IF ;
6220:
6221: IF lv_pay_value_name = 'Pay Value' THEN
6222: ln_amount := ln_amount + ln_pay_value ;
6223: hr_utility.trace('ln_ytd_amount is '|| ln_ytd_amount );
6224: END IF;
6225: ELSE
6226: EXIT;
6227: END IF;
6246: ELSE
6247: ln_rate := ln_amount/ln_hours;
6248: END IF;
6249:
6250: hr_utility.trace('ld_original_date_paid := '||ld_original_date_paid);
6251: hr_utility.trace('ln_element_entry_id := '||ln_element_entry_id);
6252: hr_utility.trace('p_run_assignment_action_id := '||p_run_assignment_action_id);
6253:
6254: OPEN archive_non_retro_elements ( ld_original_date_paid,
6247: ln_rate := ln_amount/ln_hours;
6248: END IF;
6249:
6250: hr_utility.trace('ld_original_date_paid := '||ld_original_date_paid);
6251: hr_utility.trace('ln_element_entry_id := '||ln_element_entry_id);
6252: hr_utility.trace('p_run_assignment_action_id := '||p_run_assignment_action_id);
6253:
6254: OPEN archive_non_retro_elements ( ld_original_date_paid,
6255: ln_element_entry_id ,
6248: END IF;
6249:
6250: hr_utility.trace('ld_original_date_paid := '||ld_original_date_paid);
6251: hr_utility.trace('ln_element_entry_id := '||ln_element_entry_id);
6252: hr_utility.trace('p_run_assignment_action_id := '||p_run_assignment_action_id);
6253:
6254: OPEN archive_non_retro_elements ( ld_original_date_paid,
6255: ln_element_entry_id ,
6256: p_run_assignment_action_id );
6257: FETCH archive_non_retro_elements INTO lv_effective_start_date
6258: ,lv_effective_end_date
6259: ,lv_category;
6260: CLOSE archive_non_retro_elements ;
6261: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
6262: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
6263: hr_utility.trace('lv_category := '||lv_category);
6264:
6265: -- Added For Work At Home Condition
6258: ,lv_effective_end_date
6259: ,lv_category;
6260: CLOSE archive_non_retro_elements ;
6261: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
6262: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
6263: hr_utility.trace('lv_category := '||lv_category);
6264:
6265: -- Added For Work At Home Condition
6266: OPEN c_cur_get_wrkathome(p_assignment_id,p_pymt_eff_date); -- Bug# 16318258
6259: ,lv_category;
6260: CLOSE archive_non_retro_elements ;
6261: hr_utility.trace('lv_effective_start_date := '||lv_effective_start_date);
6262: hr_utility.trace('lv_effective_end_date := '||lv_effective_end_date);
6263: hr_utility.trace('lv_category := '||lv_category);
6264:
6265: -- Added For Work At Home Condition
6266: OPEN c_cur_get_wrkathome(p_assignment_id,p_pymt_eff_date); -- Bug# 16318258
6267: FETCH c_cur_get_wrkathome INTO lv_wrk_at_home
6310: into lv_jurisdiction_flag
6311: from dual;
6312: END IF; -- Work at Home 'N'
6313:
6314: hr_utility.trace('lv_jurisdiction_flag := '||lv_jurisdiction_flag);
6315: lv_action_category := 'AC EARNINGS';
6316: ln_step := 15;
6317: ln_index := pay_ac_action_arch.lrr_act_tab.count;
6318:
6317: ln_index := pay_ac_action_arch.lrr_act_tab.count;
6318:
6319: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
6320: := fnd_number.number_to_canonical(ln_hours);
6321: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
6322: hr_utility.set_location(gv_package || lv_procedure_name, 130);
6323: /* Insert this into the plsql table if Current or YTD
6324: amount is not Zero */
6325: ln_step :=21;
6318:
6319: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
6320: := fnd_number.number_to_canonical(ln_hours);
6321: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
6322: hr_utility.set_location(gv_package || lv_procedure_name, 130);
6323: /* Insert this into the plsql table if Current or YTD
6324: amount is not Zero */
6325: ln_step :=21;
6326: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
6345: := fnd_number.number_to_canonical(nvl(ln_amount,0));
6346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6347: := fnd_number.number_to_canonical(0);
6348:
6349: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
6350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
6351: := p_reporting_name;
6352:
6353: IF lv_temp_AAA <> 'AAA' THEN
6352:
6353: IF lv_temp_AAA <> 'AAA' THEN
6354: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
6355: := lv_original_date_earned;
6356: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
6357:
6358: IF lv_check_date = nvl(lv_original_date_earned,p_pymt_eff_date) THEN
6359: count_j := ln_index;
6360: END IF;
6359: count_j := ln_index;
6360: END IF;
6361: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
6362: := lv_effective_start_date;
6363: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
6364: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
6365: := lv_effective_end_date ;
6366: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
6367: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
6362: := lv_effective_start_date;
6363: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
6364: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
6365: := lv_effective_end_date ;
6366: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
6367: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
6368: := lv_category;
6369: hr_utility.trace('lv_category ' || lv_category );
6370: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
6365: := lv_effective_end_date ;
6366: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
6367: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
6368: := lv_category;
6369: hr_utility.trace('lv_category ' || lv_category );
6370: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
6371: := lv_jurisdiction_flag;
6372: END IF;
6373:
6378: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := 'N/A';
6379: END IF;
6380: */
6381:
6382: hr_utility.set_location(gv_package || lv_procedure_name, 150);
6383: ln_step := 20;
6384: lv_temp_AAA := 'BBB' ;
6385: end loop;
6386:
6407: p_primary_balance_id,
6408: gv_ytd_balance_dimension,
6409: p_legislation_code);
6410:
6411: hr_utility.trace('ln_ytd_defined_balance_id = ' ||
6412: ln_ytd_defined_balance_id);
6413:
6414: ln_step := 4;
6415: if p_hours_balance_id is not null then
6412: ln_ytd_defined_balance_id);
6413:
6414: ln_step := 4;
6415: if p_hours_balance_id is not null then
6416: hr_utility.set_location(gv_package || lv_procedure_name, 20);
6417: ln_ytd_hours_balance_id
6418: := pay_emp_action_arch.get_defined_balance_id(
6419: p_hours_balance_id,
6420: gv_ytd_balance_dimension,
6419: p_hours_balance_id,
6420: gv_ytd_balance_dimension,
6421: p_legislation_code);
6422:
6423: hr_utility.trace('ln_ytd_hours_balance_id = ' ||
6424: ln_ytd_hours_balance_id);
6425:
6426: end if;
6427:
6425:
6426: end if;
6427:
6428: ln_step := 5;
6429: hr_utility.set_location(gv_package || lv_procedure_name, 40);
6430: if ln_ytd_defined_balance_id is not null then
6431: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
6432: ln_ytd_defined_balance_id,
6433: p_ytd_balcall_aaid),0);
6433: p_ytd_balcall_aaid),0);
6434: end if;
6435:
6436: if p_hours_balance_id is not null then
6437: hr_utility.set_location(gv_package || lv_procedure_name, 50);
6438: if ln_ytd_hours_balance_id is not null then
6439: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
6440: ln_ytd_hours_balance_id,
6441: p_ytd_balcall_aaid),0);
6438: if ln_ytd_hours_balance_id is not null then
6439: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
6440: ln_ytd_hours_balance_id,
6441: p_ytd_balcall_aaid),0);
6442: hr_utility.set_location(gv_package || lv_procedure_name, 60);
6443: end if;
6444: end if; --Hours
6445:
6446: ln_step := 8;
6469: p_legislation_code);
6470: end if;
6471: end if; -- p_action_type in ('B','V')
6472: /* end of addition for Reversals and bal adjustments */
6473: hr_utility.trace('ln_pymt_defined_balance_id ' ||
6474: ln_pymt_defined_balance_id);
6475:
6476: if ln_pymt_defined_balance_id is not null then
6477: ln_payments_amount := nvl(pay_balance_pkg.get_value(
6476: if ln_pymt_defined_balance_id is not null then
6477: ln_payments_amount := nvl(pay_balance_pkg.get_value(
6478: ln_pymt_defined_balance_id,
6479: p_pymt_balcall_aaid),0);
6480: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
6481: end if;
6482:
6483: if p_hours_balance_id is not null then
6484: /* Added dimension _ASG_GRE_RUN for reversals and Balance
6504: ,p_legislation_code);
6505: end if;
6506: end if; -- p_action_type in ('B','V')
6507: /* end of addition for reversals and bal adjustments */
6508: hr_utility.trace('ln_pymt_hours_balance_id ' ||
6509: ln_pymt_hours_balance_id);
6510:
6511: hr_utility.set_location(gv_package || lv_procedure_name, 120);
6512: end if; --Hours
6507: /* end of addition for reversals and bal adjustments */
6508: hr_utility.trace('ln_pymt_hours_balance_id ' ||
6509: ln_pymt_hours_balance_id);
6510:
6511: hr_utility.set_location(gv_package || lv_procedure_name, 120);
6512: end if; --Hours
6513: end if; -- p_pymt_balcall_aaid is not null
6514:
6515: ln_step := 15;
6515: ln_step := 15;
6516:
6517: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6518: := fnd_number.number_to_canonical(ln_ytd_amount);
6519: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
6520:
6521: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
6522: := fnd_number.number_to_canonical(ln_ytd_hours);
6523: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
6519: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
6520:
6521: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
6522: := fnd_number.number_to_canonical(ln_ytd_hours);
6523: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
6524:
6525: /* Following later to be re-valuated IF worth doing wrt Cost
6526:
6527: IF count_j is null THEN
6526:
6527: IF count_j is null THEN
6528: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6529: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
6530: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
6531: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
6532: := fnd_number.number_to_canonical(ln_ytd_hours);
6533: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
6534: END IF;
6529: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
6530: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
6531: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
6532: := fnd_number.number_to_canonical(ln_ytd_hours);
6533: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
6534: END IF;
6535: */
6536:
6537: EXCEPTION
6535: */
6536:
6537: EXCEPTION
6538: when others then
6539: hr_utility.trace(' Error In archive_addnl_elements procedure');
6540: hr_utility.trace('error occured at step ' || ln_step );
6541:
6542: END Archive_addnl_elements;
6543:
6536:
6537: EXCEPTION
6538: when others then
6539: hr_utility.trace(' Error In archive_addnl_elements procedure');
6540: hr_utility.trace('error occured at step ' || ln_step );
6541:
6542: END Archive_addnl_elements;
6543:
6544: