[Home] [Help]
97: CLOSE csr_defined_balance_id ;
98: RETURN l_defined_balance_id;
99: EXCEPTION
100: WHEN NO_DATA_FOUND THEN
101: hr_utility.set_location('get_defined_balance_id NO_DATA_FOUND'||SQLCODE||SQLERRM,2511);
102: null;
103: --
104: END get_defined_balance_id;
105:
178: g_statutory_balance_table(l_index).balance_name := stat_bal_rec.bal_name;
179: g_statutory_balance_table(l_index).database_item_suffix :=
180: stat_bal_rec.bal_dimension;
181:
182: --hr_utility.set_location('setup_statutory_balance_table bal_name'||g_statutory_balance_table(l_index).balance_name,673);
183: --hr_utility.set_location('setup_statutory_balance_table bal_dimension'||g_statutory_balance_table(l_index).database_item_suffix,673);
184:
185: g_statutory_balance_table(l_index).defined_balance_id :=
186: get_defined_balance_id (stat_bal_rec.bal_name,stat_bal_rec.bal_dimension);
179: g_statutory_balance_table(l_index).database_item_suffix :=
180: stat_bal_rec.bal_dimension;
181:
182: --hr_utility.set_location('setup_statutory_balance_table bal_name'||g_statutory_balance_table(l_index).balance_name,673);
183: --hr_utility.set_location('setup_statutory_balance_table bal_dimension'||g_statutory_balance_table(l_index).database_item_suffix,673);
184:
185: g_statutory_balance_table(l_index).defined_balance_id :=
186: get_defined_balance_id (stat_bal_rec.bal_name,stat_bal_rec.bal_dimension);
187:
184:
185: g_statutory_balance_table(l_index).defined_balance_id :=
186: get_defined_balance_id (stat_bal_rec.bal_name,stat_bal_rec.bal_dimension);
187:
188: --hr_utility.set_location('setup_statutory_balance_table defined bal id'||g_statutory_balance_table(l_index).defined_balance_id,674);
189: l_index := l_index + 1;
190: --
191: END LOOP;
192: END IF;
201: g_statutory_balance_table(l_index).balance_name := stat_bal_rec.bal_name;
202: g_statutory_balance_table(l_index).database_item_suffix :=
203: stat_bal_rec.bal_dimension;
204:
205: --hr_utility.set_location('setup_statutory_balance_table bal_name'||g_statutory_balance_table(l_index).balance_name,673);
206: --hr_utility.set_location('setup_statutory_balance_table bal_dimension'||g_statutory_balance_table(l_index).database_item_suffix,673);
207:
208:
209: g_statutory_balance_table(l_index).defined_balance_id :=
202: g_statutory_balance_table(l_index).database_item_suffix :=
203: stat_bal_rec.bal_dimension;
204:
205: --hr_utility.set_location('setup_statutory_balance_table bal_name'||g_statutory_balance_table(l_index).balance_name,673);
206: --hr_utility.set_location('setup_statutory_balance_table bal_dimension'||g_statutory_balance_table(l_index).database_item_suffix,673);
207:
208:
209: g_statutory_balance_table(l_index).defined_balance_id :=
210: get_defined_balance_id (stat_bal_rec.bal_name,stat_bal_rec.bal_dimension);
208:
209: g_statutory_balance_table(l_index).defined_balance_id :=
210: get_defined_balance_id (stat_bal_rec.bal_name,stat_bal_rec.bal_dimension);
211:
212: --hr_utility.set_location('setup_statutory_balance_table defined bal id'||g_statutory_balance_table(l_index).defined_balance_id,674);
213:
214: l_index := l_index + 1;
215: --
216: /*END IF;*/
239: l_proc VARCHAR2(40):= g_package||' get parameter ';
240:
241: BEGIN
242: --
243: --hr_utility.set_location('Entering get_parameter',52);
244: --
245: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
246: --
247: IF l_start_pos = 0 THEN
264: - instr(l_parameter,':',1,p_segment_number));
265: END IF;
266: END IF;
267: --
268: --hr_utility.set_location('Leaving get_parameter',53);
269: --hr_utility.set_location('Entering get_parameter l_parameter--'||l_parameter||'--',54);
270: RETURN l_parameter;
271: END get_parameter;
272:
265: END IF;
266: END IF;
267: --
268: --hr_utility.set_location('Leaving get_parameter',53);
269: --hr_utility.set_location('Entering get_parameter l_parameter--'||l_parameter||'--',54);
270: RETURN l_parameter;
271: END get_parameter;
272:
273: /*-------------------------------------------------------------------------------
302: l_proc VARCHAR2(240):= g_package||' get_all_parameters ';
303: --
304: BEGIN
305: --
306: --hr_utility.set_location('Entering get_all_parameters',51);
307:
308: OPEN csr_parameter_info (p_payroll_action_id);
309: FETCH csr_parameter_info INTO p_payroll_id
310: ,p_consolidation_set
313: ,p_effective_date
314: ,p_business_group_id;
315: CLOSE csr_parameter_info;
316: --
317: --hr_utility.set_location('Leaving get_all_parameters',54);
318:
319: END;
320:
321:
405: l_char varchar2(10);
406: BEGIN
407: --
408: --
409: --hr_utility.set_location('Entering Get EIT Definitions',56);
410:
411: FOR csr_eit_rec IN csr_eit_values(p_business_group_id
412: ,p_eit_context) LOOP
413: --
411: FOR csr_eit_rec IN csr_eit_values(p_business_group_id
412: ,p_eit_context) LOOP
413: --
414:
415: --hr_utility.set_location('For Each EIT Record'||p_eit_context,57);
416: --
417:
418: IF p_eit_context = 'NL_PAYSLIP_BALANCES' THEN
419: --
452: g_user_balance_table(l_balance_index).legislation_code := v_csr_balance_name.legislation_code;
453: g_user_balance_table(l_balance_index).defined_balance_id := v_csr_balance_name.defined_balance_id;
454: END IF;
455: --
456: --hr_utility.set_location('For NL_PAYSLIP_BALANCES'||p_eit_context,58);
457: --
458: --
459: --
460: IF p_archive = 'Y' THEN
458: --
459: --
460: IF p_archive = 'Y' THEN
461: --
462: --hr_utility.set_location('For NL_PAYSLIP_BALANCES'||g_user_balance_table(l_balance_index).balance_name,59);
463: --
464: -- Archive EMEA BALANCE DEFINITION
465: pay_action_information_api.create_action_information (
466: p_action_information_id => l_action_info_id
495: csr_eit_rec.org_information4;
496:
497: --
498:
499: --hr_utility.set_location('For NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).element_type_id,59);
500: --
501: l_formula_id := NULL;
502: --Bug 3601121
503: --Fetch the iterative formula id defined for an element
502: --Bug 3601121
503: --Fetch the iterative formula id defined for an element
504:
505: g_element_table(l_element_index).formula_id := l_formula_id;
506: --hr_utility.set_location('For NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).formula_id,59);
507: --
508: OPEN csr_input_value_uom(csr_eit_rec.org_information2
509: ,p_effective_date);
510: FETCH csr_input_value_uom INTO l_uom;
509: ,p_effective_date);
510: FETCH csr_input_value_uom INTO l_uom;
511: CLOSE csr_input_value_uom;
512: --
513: --hr_utility.set_location('For NL_PAYSLIP_ELEMENTS'||l_uom,59);
514: IF p_archive = 'Y' THEN
515: --
516: -- Archive EMEA ELEMENT DEFINITION
517: --
514: IF p_archive = 'Y' THEN
515: --
516: -- Archive EMEA ELEMENT DEFINITION
517: --
518: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).element_type_id,59);
519: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).input_value_id,59);
520: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).element_narrative,59);
521: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).si_type,59);
522: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||l_uom,59);
515: --
516: -- Archive EMEA ELEMENT DEFINITION
517: --
518: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).element_type_id,59);
519: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).input_value_id,59);
520: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).element_narrative,59);
521: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).si_type,59);
522: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||l_uom,59);
523: --
516: -- Archive EMEA ELEMENT DEFINITION
517: --
518: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).element_type_id,59);
519: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).input_value_id,59);
520: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).element_narrative,59);
521: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).si_type,59);
522: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||l_uom,59);
523: --
524: pay_action_information_api.create_action_information (
517: --
518: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).element_type_id,59);
519: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).input_value_id,59);
520: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).element_narrative,59);
521: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).si_type,59);
522: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||l_uom,59);
523: --
524: pay_action_information_api.create_action_information (
525: p_action_information_id => l_action_info_id
518: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).element_type_id,59);
519: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).input_value_id,59);
520: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).element_narrative,59);
521: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||g_element_table(l_element_index).si_type,59);
522: --hr_utility.set_location('calling api for NL_PAYSLIP_ELEMENTS'||l_uom,59);
523: --
524: pay_action_information_api.create_action_information (
525: p_action_information_id => l_action_info_id
526: ,p_action_context_id => p_pactid
539: ,p_action_information7 => g_element_table(l_element_index).si_type);
540:
541:
542: --
543: --hr_utility.set_location('Leaving NL_PAYSLIP_ELEMENTS'||l_action_info_id,59);
544: --
545: END IF;
546: --
547: END IF;
653:
654: Begin
655:
656: --
657: --hr_utility.trace_on(NULL,'PSA');
658: --hr_utility.set_location('Entering Range Code',50);
659: --
660: pay_nl_payslip_archive.get_all_parameters(pactid
661: ,l_business_group_id
654: Begin
655:
656: --
657: --hr_utility.trace_on(NULL,'PSA');
658: --hr_utility.set_location('Entering Range Code',50);
659: --
660: pay_nl_payslip_archive.get_all_parameters(pactid
661: ,l_business_group_id
662: ,l_start_date
670:
671:
672: --
673: g_payroll_action_id:=pactid;
674: --hr_utility.set_location('g_payroll_action_id = ' || g_payroll_action_id,55);
675: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,55);
676: --hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,55);
677: --hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,55);
678: --hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,55);
671:
672: --
673: g_payroll_action_id:=pactid;
674: --hr_utility.set_location('g_payroll_action_id = ' || g_payroll_action_id,55);
675: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,55);
676: --hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,55);
677: --hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,55);
678: --hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,55);
679: --
672: --
673: g_payroll_action_id:=pactid;
674: --hr_utility.set_location('g_payroll_action_id = ' || g_payroll_action_id,55);
675: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,55);
676: --hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,55);
677: --hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,55);
678: --hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,55);
679: --
680: --
673: g_payroll_action_id:=pactid;
674: --hr_utility.set_location('g_payroll_action_id = ' || g_payroll_action_id,55);
675: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,55);
676: --hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,55);
677: --hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,55);
678: --hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,55);
679: --
680: --
681:
674: --hr_utility.set_location('g_payroll_action_id = ' || g_payroll_action_id,55);
675: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,55);
676: --hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,55);
677: --hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,55);
678: --hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,55);
679: --
680: --
681:
682: -- Setup statutory balances pl/sql table
696: , p_eit_context => 'NL_PAYSLIP_BALANCES'
697: , p_archive => 'Y');
698: --
699: --
700: --hr_utility.set_location('Inside Range Code',60);
701:
702: -- Populates the global PL/SQL Table with Element information and archives
703: -- EMEA ELEMENT DEFINITION Context
704: --
709: , p_effective_date => l_canonical_start_date
710: , p_eit_context => 'NL_PAYSLIP_ELEMENTS'
711: , p_archive => 'Y');
712:
713: --hr_utility.set_location('Inside Range Code',70);
714: --
715: FOR rec_payrolls in csr_payrolls(l_payroll_id
716: ,l_consolidation_set
717: ,l_canonical_end_date) LOOP
714: --
715: FOR rec_payrolls in csr_payrolls(l_payroll_id
716: ,l_consolidation_set
717: ,l_canonical_end_date) LOOP
718: --hr_utility.set_location('Inside csr_payrolls loop',75);
719:
720: pay_emp_action_arch.arch_pay_action_level_data (
721: p_payroll_action_id => pactid
722: ,p_payroll_id => rec_payrolls.payroll_id
724: null;
725: --
726: END LOOP;
727:
728: --hr_utility.set_location('Inside Range Code',80);
729:
730: FOR hr_org_info_rec in csr_hr_org_info (l_business_group_id
731: ,pactid)
732: LOOP
730: FOR hr_org_info_rec in csr_hr_org_info (l_business_group_id
731: ,pactid)
732: LOOP
733:
734: --hr_utility.set_location('Inside Range Code loop hr_org_info_rec.org_id'||hr_org_info_rec.org_id,90);
735: --
736: -- Archiving EMEA PAYROLL INFO context
737: --
738: pay_action_information_api.create_action_information (
752: , p_action_information6 => hr_org_info_rec.reg_no);
753:
754: END LOOP;
755:
756: --hr_utility.set_location('pactid'||pactid,100);
757:
758: FOR rec_payroll_msg in csr_payroll_mesg(l_payroll_id
759: ,l_canonical_start_date
760: ,l_canonical_end_date)
758: FOR rec_payroll_msg in csr_payroll_mesg(l_payroll_id
759: ,l_canonical_start_date
760: ,l_canonical_end_date)
761: LOOP
762: --hr_utility.set_location('coming inside loop'||rec_payroll_msg.payroll_action_id,200);
763: --
764: IF rec_payroll_msg.payroll_message IS NOT NULL THEN
765: --
766: pay_action_information_api.create_action_information (
782: null;
783: END IF;
784: --
785: END LOOP;
786: --hr_utility.set_location('outside loop',300);
787:
788: sqlstr := 'SELECT DISTINCT person_id
789: FROM per_people_f ppf
790: ,pay_payroll_actions ppa
791: WHERE ppa.payroll_action_id = :payroll_action_id
792: AND ppa.business_group_id = ppf.business_group_id
793: ORDER BY ppf.person_id';
794:
795: --hr_utility.set_location('Leaving Range Code',350);
796:
797: EXCEPTION
798:
799: WHEN OTHERS THEN
923: csr_rec csr_prepaid_assignments%ROWTYPE;
924:
925: BEGIN
926: --
927: --hr_utility.trace_on(NULL,'PSA');
928: --hr_utility.set_location('Entering Assignment Action Code',400);
929: --
930:
931:
924:
925: BEGIN
926: --
927: --hr_utility.trace_on(NULL,'PSA');
928: --hr_utility.set_location('Entering Assignment Action Code',400);
929: --
930:
931:
932: pay_nl_payslip_archive.get_all_parameters(p_payroll_action_id
939:
940:
941: l_prepay_action_id := 0;
942: --
943: --hr_utility.set_location('Archive p_payroll_action_id'||p_payroll_action_id,425);
944: --hr_utility.set_location('Archive p_start_person_id'||p_start_person_id,425);
945: --hr_utility.set_location('Archive p_end_person_id'||p_end_person_id,425);
946: --hr_utility.set_location('Archive l_payroll_id'||l_payroll_id,425);
947: --hr_utility.set_location('Archive l_consolidation_set'||l_consolidation_set,425);
940:
941: l_prepay_action_id := 0;
942: --
943: --hr_utility.set_location('Archive p_payroll_action_id'||p_payroll_action_id,425);
944: --hr_utility.set_location('Archive p_start_person_id'||p_start_person_id,425);
945: --hr_utility.set_location('Archive p_end_person_id'||p_end_person_id,425);
946: --hr_utility.set_location('Archive l_payroll_id'||l_payroll_id,425);
947: --hr_utility.set_location('Archive l_consolidation_set'||l_consolidation_set,425);
948: --hr_utility.set_location('Archive l_canonical_start_date'||l_canonical_start_date,425);
941: l_prepay_action_id := 0;
942: --
943: --hr_utility.set_location('Archive p_payroll_action_id'||p_payroll_action_id,425);
944: --hr_utility.set_location('Archive p_start_person_id'||p_start_person_id,425);
945: --hr_utility.set_location('Archive p_end_person_id'||p_end_person_id,425);
946: --hr_utility.set_location('Archive l_payroll_id'||l_payroll_id,425);
947: --hr_utility.set_location('Archive l_consolidation_set'||l_consolidation_set,425);
948: --hr_utility.set_location('Archive l_canonical_start_date'||l_canonical_start_date,425);
949: --hr_utility.set_location('Archive l_canonical_end_date'||l_canonical_end_date,425);
942: --
943: --hr_utility.set_location('Archive p_payroll_action_id'||p_payroll_action_id,425);
944: --hr_utility.set_location('Archive p_start_person_id'||p_start_person_id,425);
945: --hr_utility.set_location('Archive p_end_person_id'||p_end_person_id,425);
946: --hr_utility.set_location('Archive l_payroll_id'||l_payroll_id,425);
947: --hr_utility.set_location('Archive l_consolidation_set'||l_consolidation_set,425);
948: --hr_utility.set_location('Archive l_canonical_start_date'||l_canonical_start_date,425);
949: --hr_utility.set_location('Archive l_canonical_end_date'||l_canonical_end_date,425);
950:
943: --hr_utility.set_location('Archive p_payroll_action_id'||p_payroll_action_id,425);
944: --hr_utility.set_location('Archive p_start_person_id'||p_start_person_id,425);
945: --hr_utility.set_location('Archive p_end_person_id'||p_end_person_id,425);
946: --hr_utility.set_location('Archive l_payroll_id'||l_payroll_id,425);
947: --hr_utility.set_location('Archive l_consolidation_set'||l_consolidation_set,425);
948: --hr_utility.set_location('Archive l_canonical_start_date'||l_canonical_start_date,425);
949: --hr_utility.set_location('Archive l_canonical_end_date'||l_canonical_end_date,425);
950:
951: --
944: --hr_utility.set_location('Archive p_start_person_id'||p_start_person_id,425);
945: --hr_utility.set_location('Archive p_end_person_id'||p_end_person_id,425);
946: --hr_utility.set_location('Archive l_payroll_id'||l_payroll_id,425);
947: --hr_utility.set_location('Archive l_consolidation_set'||l_consolidation_set,425);
948: --hr_utility.set_location('Archive l_canonical_start_date'||l_canonical_start_date,425);
949: --hr_utility.set_location('Archive l_canonical_end_date'||l_canonical_end_date,425);
950:
951: --
952: OPEN csr_prepaid_assignments(p_payroll_action_id
945: --hr_utility.set_location('Archive p_end_person_id'||p_end_person_id,425);
946: --hr_utility.set_location('Archive l_payroll_id'||l_payroll_id,425);
947: --hr_utility.set_location('Archive l_consolidation_set'||l_consolidation_set,425);
948: --hr_utility.set_location('Archive l_canonical_start_date'||l_canonical_start_date,425);
949: --hr_utility.set_location('Archive l_canonical_end_date'||l_canonical_end_date,425);
950:
951: --
952: OPEN csr_prepaid_assignments(p_payroll_action_id
953: ,p_start_person_id,p_end_person_id,l_payroll_id,l_consolidation_set
971: OPEN get_prepayment_child_action(csr_rec.prepaid_action_id,csr_rec.assignment_id);
972: FETCH get_prepayment_child_action INTO l_child_action_id;
973: CLOSE get_prepayment_child_action;
974:
975: --hr_utility.set_location('Archive l_prepay_action_id'||l_prepay_action_id,425);
976: --hr_utility.set_location('Archive l_child_action_id'||l_child_action_id,425);
977:
978:
979: l_prepay_action_id := nvl(l_child_action_id,csr_rec.prepaid_action_id);
972: FETCH get_prepayment_child_action INTO l_child_action_id;
973: CLOSE get_prepayment_child_action;
974:
975: --hr_utility.set_location('Archive l_prepay_action_id'||l_prepay_action_id,425);
976: --hr_utility.set_location('Archive l_child_action_id'||l_child_action_id,425);
977:
978:
979: l_prepay_action_id := nvl(l_child_action_id,csr_rec.prepaid_action_id);
980:
977:
978:
979: l_prepay_action_id := nvl(l_child_action_id,csr_rec.prepaid_action_id);
980:
981: hr_utility.set_location('Archive l_prepay_action_id'||l_prepay_action_id,425);
982: hr_utility.set_location('Archive csr_rec.prepaid_action_id'||csr_rec.prepaid_action_id,425);
983:
984: hr_utility.set_location('Archive Assignment Action Id'||l_actid,450);
985:
978:
979: l_prepay_action_id := nvl(l_child_action_id,csr_rec.prepaid_action_id);
980:
981: hr_utility.set_location('Archive l_prepay_action_id'||l_prepay_action_id,425);
982: hr_utility.set_location('Archive csr_rec.prepaid_action_id'||csr_rec.prepaid_action_id,425);
983:
984: hr_utility.set_location('Archive Assignment Action Id'||l_actid,450);
985:
986: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,
980:
981: hr_utility.set_location('Archive l_prepay_action_id'||l_prepay_action_id,425);
982: hr_utility.set_location('Archive csr_rec.prepaid_action_id'||csr_rec.prepaid_action_id,425);
983:
984: hr_utility.set_location('Archive Assignment Action Id'||l_actid,450);
985:
986: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,
987: p_payroll_action_id,p_chunk,NULL);
988: --
985:
986: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,
987: p_payroll_action_id,p_chunk,NULL);
988: --
989: hr_utility.set_location('Archive Assignment Action Id'||l_actid,450);
990: hr_utility.set_location('Archive Assignment Id'||csr_rec.assignment_id,450);
991: hr_utility.set_location('Archive Payroll Action Id'||p_payroll_action_id,450);
992:
993: -- Create archive to prepayment assignment action interlock
986: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,
987: p_payroll_action_id,p_chunk,NULL);
988: --
989: hr_utility.set_location('Archive Assignment Action Id'||l_actid,450);
990: hr_utility.set_location('Archive Assignment Id'||csr_rec.assignment_id,450);
991: hr_utility.set_location('Archive Payroll Action Id'||p_payroll_action_id,450);
992:
993: -- Create archive to prepayment assignment action interlock
994: --
987: p_payroll_action_id,p_chunk,NULL);
988: --
989: hr_utility.set_location('Archive Assignment Action Id'||l_actid,450);
990: hr_utility.set_location('Archive Assignment Id'||csr_rec.assignment_id,450);
991: hr_utility.set_location('Archive Payroll Action Id'||p_payroll_action_id,450);
992:
993: -- Create archive to prepayment assignment action interlock
994: --
995: hr_nonrun_asact.insint(l_actid,l_prepay_action_id);
994: --
995: hr_nonrun_asact.insint(l_actid,l_prepay_action_id);
996: --
997: END IF;
998: hr_utility.set_location('Archive Assignment Action Id'||l_actid,475);
999: hr_utility.set_location('Archive Assignment run_action_id Id'||csr_rec.run_action_id,475);
1000: -- Create archive to payroll master action interlock
1001: hr_nonrun_asact.insint(l_actid,csr_rec.run_action_id);
1002: -- l_prepay_action_id := csr_rec.prepaid_action_id;
995: hr_nonrun_asact.insint(l_actid,l_prepay_action_id);
996: --
997: END IF;
998: hr_utility.set_location('Archive Assignment Action Id'||l_actid,475);
999: hr_utility.set_location('Archive Assignment run_action_id Id'||csr_rec.run_action_id,475);
1000: -- Create archive to payroll master action interlock
1001: hr_nonrun_asact.insint(l_actid,csr_rec.run_action_id);
1002: -- l_prepay_action_id := csr_rec.prepaid_action_id;
1003: --
1003: --
1004: END LOOP;
1005:
1006: --
1007: --hr_utility.set_location('Leaving Assignment Action Code',500);
1008: --
1009: END ASSIGNMENT_ACTION_CODE;
1010:
1011:
1337: l_consolidation_set NUMBER;
1338:
1339: BEGIN
1340: --
1341: --hr_utility.set_location('Entering Archive Init',600);
1342: --
1343: pay_nl_payslip_archive.get_all_parameters(p_payroll_action_id
1344: ,l_business_group_id
1345: ,l_start_date,l_end_date,l_effective_date
1348: l_canonical_start_date := TO_DATE(l_start_date,'YYYY/MM/DD');
1349: l_canonical_end_date := TO_DATE(l_end_date,'YYYY/MM/DD');
1350: --
1351:
1352: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,655);
1353: --hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,655);
1354: --hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,655);
1355: --hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,655);
1356: --
1349: l_canonical_end_date := TO_DATE(l_end_date,'YYYY/MM/DD');
1350: --
1351:
1352: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,655);
1353: --hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,655);
1354: --hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,655);
1355: --hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,655);
1356: --
1357: --
1350: --
1351:
1352: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,655);
1353: --hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,655);
1354: --hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,655);
1355: --hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,655);
1356: --
1357: --
1358:
1351:
1352: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,655);
1353: --hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,655);
1354: --hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,655);
1355: --hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,655);
1356: --
1357: --
1358:
1359: -- Setup statutory balances pl/sql table
1374: , p_eit_context => 'NL_PAYSLIP_BALANCES'
1375: , p_archive => 'N');
1376: --
1377: --
1378: --hr_utility.set_location('Inside Archive Init Code',660);
1379: END IF;
1380: -- Populates the global PL/SQL Table with Element information and archives
1381: -- EMEA ELEMENT DEFINITION Context
1382: --
1390: , p_archive => 'N');
1391: --
1392: END IF;
1393:
1394: --hr_utility.set_location('Inside Archive Init Code',670);
1395:
1396:
1397: --hr_utility.set_location('Inside Archive Init Code',675);
1398:
1393:
1394: --hr_utility.set_location('Inside Archive Init Code',670);
1395:
1396:
1397: --hr_utility.set_location('Inside Archive Init Code',675);
1398:
1399: -- Setup statutory element pl/sql table
1400: setup_element_table();
1401: --
1398:
1399: -- Setup statutory element pl/sql table
1400: setup_element_table();
1401: --
1402: --hr_utility.set_location('Inside Archive Init Code',680);
1403:
1404: --hr_utility.set_location('Leaving Archive Init',700);
1405: --
1406: END ARCHIVE_INIT;
1400: setup_element_table();
1401: --
1402: --hr_utility.set_location('Inside Archive Init Code',680);
1403:
1404: --hr_utility.set_location('Leaving Archive Init',700);
1405: --
1406: END ARCHIVE_INIT;
1407:
1408: /*-------------------------------------------------------------------------------
1692: l_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
1693: l_dummy NUMBER;
1694: --
1695: BEGIN
1696: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS',1400);
1697: OPEN csr_nl_employee_details;
1698: --
1699: FETCH csr_nl_employee_details INTO l_tax_code
1700: ,l_dummy
1702: ,l_labour_tax_reduction
1703: ,l_add_senior_tax_reduction
1704: ,l_individual_working_hours;
1705: --
1706: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_prev_year_sal'||l_prev_year_sal,1420);
1707:
1708: IF csr_nl_employee_details%FOUND THEN
1709:
1710: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_meaning'||l_meaning,1440);
1706: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_prev_year_sal'||l_prev_year_sal,1420);
1707:
1708: IF csr_nl_employee_details%FOUND THEN
1709:
1710: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_meaning'||l_meaning,1440);
1711: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_tax_code'||l_tax_code,1440);
1712: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS p_assignment_id'||p_assignment_id,1440);
1713:
1714: l_meaning:= hr_general.decode_lookup('NL_TAX_CODE'
1707:
1708: IF csr_nl_employee_details%FOUND THEN
1709:
1710: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_meaning'||l_meaning,1440);
1711: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_tax_code'||l_tax_code,1440);
1712: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS p_assignment_id'||p_assignment_id,1440);
1713:
1714: l_meaning:= hr_general.decode_lookup('NL_TAX_CODE'
1715: ,substr(l_tax_code,1,3));
1708: IF csr_nl_employee_details%FOUND THEN
1709:
1710: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_meaning'||l_meaning,1440);
1711: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_tax_code'||l_tax_code,1440);
1712: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS p_assignment_id'||p_assignment_id,1440);
1713:
1714: l_meaning:= hr_general.decode_lookup('NL_TAX_CODE'
1715: ,substr(l_tax_code,1,3));
1716:
1713:
1714: l_meaning:= hr_general.decode_lookup('NL_TAX_CODE'
1715: ,substr(l_tax_code,1,3));
1716:
1717: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_ni'||l_ni,1440);
1718:
1719: IF l_meaning is null THEN
1720: -- Split the tax code
1721: -- 1st Digit
1750: IF l_prev_year_sal IS NULL THEN
1751: l_prev_year_sal:='0.00';
1752: END IF;
1753:
1754: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_tax_code'||l_tax_code,1440);
1755: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_tax_reduction'||l_tax_reduction,1440);
1756:
1757: --Bug No.3380758
1758: --Moved initializing l_age before assigning the l_tax_reduction
1751: l_prev_year_sal:='0.00';
1752: END IF;
1753:
1754: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_tax_code'||l_tax_code,1440);
1755: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_tax_reduction'||l_tax_reduction,1440);
1756:
1757: --Bug No.3380758
1758: --Moved initializing l_age before assigning the l_tax_reduction
1759:
1762: ,p_date_earned);
1763:
1764: IF l_tax_reduction = 'Y' THEN
1765:
1766: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_age'||l_age,1440);
1767: IF l_age < 65 THEN
1768: l_tax_reduction :=hr_general.decode_lookup('HR_NL_REPORT_LABELS'
1769: ,'NL_GENERAL');
1770: ELSE
1771: l_tax_reduction:= hr_general.decode_lookup('HR_NL_REPORT_LABELS'
1772: ,'NL_SENIOR');
1773: END IF;
1774:
1775: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_tax_reduction'||l_tax_reduction,1440);
1776: END IF;
1777: --
1778: --
1779: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_tax_code'||l_tax_code,1440);
1775: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_tax_reduction'||l_tax_reduction,1440);
1776: END IF;
1777: --
1778: --
1779: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_tax_code'||l_tax_code,1440);
1780: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS p_assg_action_id'||p_assg_action_id,1400);
1781: -- Archive NL EMPLOYEE DETAILS
1782: --
1783: --pay_action_information_api.create_action_information ();
1776: END IF;
1777: --
1778: --
1779: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_tax_code'||l_tax_code,1440);
1780: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS p_assg_action_id'||p_assg_action_id,1400);
1781: -- Archive NL EMPLOYEE DETAILS
1782: --
1783: --pay_action_information_api.create_action_information ();
1784:
1799: ,p_action_information26 =>l_tax_reduction
1800: ,p_action_information27 =>l_labour_tax_reduction
1801: ,p_action_information28 =>l_add_senior_tax_reduction);
1802:
1803: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_action_info_id'||l_action_info_id,1400);
1804:
1805: OPEN csr_payroll_period;
1806: FETCH csr_payroll_period INTO l_period_type,l_bus_group_id;
1807: CLOSE csr_payroll_period;
1805: OPEN csr_payroll_period;
1806: FETCH csr_payroll_period INTO l_period_type,l_bus_group_id;
1807: CLOSE csr_payroll_period;
1808:
1809: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_period_type'||l_period_type,1400);
1810: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_bus_group_id'||l_bus_group_id,1400);
1811: --
1812: IF l_period_type = 'Calendar Month' THEN
1813: l_min_wage_type := 'Month';
1806: FETCH csr_payroll_period INTO l_period_type,l_bus_group_id;
1807: CLOSE csr_payroll_period;
1808:
1809: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_period_type'||l_period_type,1400);
1810: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_bus_group_id'||l_bus_group_id,1400);
1811: --
1812: IF l_period_type = 'Calendar Month' THEN
1813: l_min_wage_type := 'Month';
1814: l_min_wage_factor := 1;
1822: l_min_wage_type := 'Month';
1823: l_min_wage_factor := 3;
1824: END IF;
1825:
1826: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_min_wage_type'||l_min_wage_type,1420);
1827: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_min_wage_factor'||l_min_wage_factor,1420);
1828: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_age'||l_age,1420);
1829:
1830: IF l_age > 23 THEN
1823: l_min_wage_factor := 3;
1824: END IF;
1825:
1826: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_min_wage_type'||l_min_wage_type,1420);
1827: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_min_wage_factor'||l_min_wage_factor,1420);
1828: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_age'||l_age,1420);
1829:
1830: IF l_age > 23 THEN
1831: l_age:=23;
1824: END IF;
1825:
1826: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_min_wage_type'||l_min_wage_type,1420);
1827: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_min_wage_factor'||l_min_wage_factor,1420);
1828: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_age'||l_age,1420);
1829:
1830: IF l_age > 23 THEN
1831: l_age:=23;
1832: END IF;
1840: WHEN NO_DATA_FOUND THEN
1841: l_ret:='0';
1842: END;
1843: --
1844: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_ret'||l_ret,1425);
1845:
1846: OPEN csr_nl_emp_organization;
1847: FETCH csr_nl_emp_organization INTO l_organization_Id;
1848: CLOSE csr_nl_emp_organization;
1851: --
1852: l_struct_id := HR_NL_ORG_INFO.NAMED_HIERARCHY (l_bus_group_id);
1853: --
1854: --
1855: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_struct_id'||l_struct_id,1430);
1856:
1857: -- Derive the Org Structure Version Id
1858: --
1859: OPEN csr_get_org_struct_ver_id (l_struct_id,p_date_earned);
1860: FETCH csr_get_org_struct_ver_id INTO l_org_struct_ver_id;
1861: CLOSE csr_get_org_struct_ver_id;
1862: --
1863: --
1864: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_org_struct_ver_id'||l_org_struct_ver_id,1440);
1865:
1866: l_employer_id := HR_NL_ORG_INFO.GET_TAX_ORG_ID(l_org_struct_ver_id
1867: ,l_organization_Id);
1868: --
1865:
1866: l_employer_id := HR_NL_ORG_INFO.GET_TAX_ORG_ID(l_org_struct_ver_id
1867: ,l_organization_Id);
1868: --
1869: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_employer_id'||l_employer_id,1450);
1870: --Bug 3601121
1871: l_legal_min_payment := NVL(fnd_number.number_to_canonical((FND_NUMBER.CANONICAL_TO_NUMBER(l_ret) * l_min_wage_factor)),'');
1872:
1873: l_si_def_bal_id := get_defined_balance_id('Real Social Insurance Days'
1872:
1873: l_si_def_bal_id := get_defined_balance_id('Real Social Insurance Days'
1874: ,'_ASG_SIT_RUN');
1875:
1876: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_legal_min_payment'||l_legal_min_payment,1460);
1877: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_si_def_bal_id'||l_si_def_bal_id,1460);
1878:
1879: OPEN csr_get_context_id('SOURCE_TEXT',p_master_asg_act_id);
1880: FETCH csr_get_context_id INTO l_context_id,l_context_value,l_seq;
1873: l_si_def_bal_id := get_defined_balance_id('Real Social Insurance Days'
1874: ,'_ASG_SIT_RUN');
1875:
1876: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_legal_min_payment'||l_legal_min_payment,1460);
1877: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_si_def_bal_id'||l_si_def_bal_id,1460);
1878:
1879: OPEN csr_get_context_id('SOURCE_TEXT',p_master_asg_act_id);
1880: FETCH csr_get_context_id INTO l_context_id,l_context_value,l_seq;
1881: CLOSE csr_get_context_id;
1879: OPEN csr_get_context_id('SOURCE_TEXT',p_master_asg_act_id);
1880: FETCH csr_get_context_id INTO l_context_id,l_context_value,l_seq;
1881: CLOSE csr_get_context_id;
1882:
1883: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_context_id'||l_context_id,1470);
1884: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_context_value'||l_context_value,1470);
1885:
1886: BEGIN
1887: l_si_days:=0;
1880: FETCH csr_get_context_id INTO l_context_id,l_context_value,l_seq;
1881: CLOSE csr_get_context_id;
1882:
1883: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_context_id'||l_context_id,1470);
1884: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_context_value'||l_context_value,1470);
1885:
1886: BEGIN
1887: l_si_days:=0;
1888:
1901: WHEN OTHERS THEN
1902: l_si_days:=0;
1903: END;
1904:
1905: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_si_days'||l_si_days,1480);
1906: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_si_days'||' '||l_si_days);
1907: --
1908: -- Archive NL OTHER EMPLOYEE DETAILS
1909: --
1929: OPEN csr_get_hr_org_address(l_employer_id);
1930: FETCH csr_get_hr_org_address INTO csr_hr_org_address_rec;
1931: CLOSE csr_get_hr_org_address;
1932: --
1933: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_si_days'||l_si_days,1490);
1934:
1935: OPEN csr_get_regular_working_hrs( p_assignment_id);
1936: FETCH csr_get_regular_working_hrs INTO l_regular_working_hours;
1937: CLOSE csr_get_regular_working_hrs;
1935: OPEN csr_get_regular_working_hrs( p_assignment_id);
1936: FETCH csr_get_regular_working_hrs INTO l_regular_working_hours;
1937: CLOSE csr_get_regular_working_hrs;
1938:
1939: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_regular_working_hours'||l_regular_working_hours,1500);
1940: --
1941: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_regular_working_hours'||' '||l_regular_working_hours);
1942: -- Archive ADDL EMPLOYEE DETAILS
1943: --
1959: /*OPEN csr_get_territory_name(csr_hr_org_address_rec.country);
1960: FETCH csr_get_territory_name INTO l_country;
1961: CLOSE csr_get_territory_name;*/
1962:
1963: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS csr_hr_org_address_rec.name'||csr_hr_org_address_rec.name,1500);
1964: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS csr_hr_org_address_rec.city'||csr_hr_org_address_rec.city,1500);
1965:
1966: --pay_action_information_api.create_action_information (..);
1967: --
1960: FETCH csr_get_territory_name INTO l_country;
1961: CLOSE csr_get_territory_name;*/
1962:
1963: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS csr_hr_org_address_rec.name'||csr_hr_org_address_rec.name,1500);
1964: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS csr_hr_org_address_rec.city'||csr_hr_org_address_rec.city,1500);
1965:
1966: --pay_action_information_api.create_action_information (..);
1967: --
1968: pay_action_information_api.create_action_information (
2002: l_E9 := '';
2003: l_E10 := '';
2004: --
2005: --
2006: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_WAO'||l_WAO,1500);
2007:
2008: fnd_message.set_name('PAY','PAY_NL_SI_TYPE_NOT_DEFINED');
2009: l_not_defined := substr(fnd_message.get,1,254);
2010:
2007:
2008: fnd_message.set_name('PAY','PAY_NL_SI_TYPE_NOT_DEFINED');
2009: l_not_defined := substr(fnd_message.get,1,254);
2010:
2011: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_not_defined'||l_not_defined,1500);
2012:
2013: FOR si_type_rec IN csr_element_si_type_value(p_master_asg_act_id
2014: ,p_date_earned) LOOP
2015: --
2013: FOR si_type_rec IN csr_element_si_type_value(p_master_asg_act_id
2014: ,p_date_earned) LOOP
2015: --
2016:
2017: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS si_type_rec.si_type'||si_type_rec.si_type,1700);
2018: IF si_type_rec.si_type = 'WAOD' and l_not_defined <> si_type_rec.value THEN
2019: l_WAO := 'Y';
2020: ELSIF si_type_rec.si_type = 'WAOB' and l_not_defined <> si_type_rec.value THEN
2021: l_WAO := 'Y';
2086: ,p_action_information15 =>l_E8
2087: ,p_action_information16 =>l_E9
2088: ,p_action_information17 =>l_E10);
2089:
2090: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_regular_working_hours'||l_regular_working_hours,2000);
2091:
2092: END ARCHIVE_NL_EMPLOYEE_DETAILS;
2093: /*-------------------------------------------------------------------------------
2094: |Name : get_country_name |
2227: l_element_type_id := 0;
2228: l_main_sequence := 0;
2229: l_multi_sequence := NULL;
2230:
2231: --hr_utility.set_location('Inside f p_record_count'||p_record_count,1520);
2232:
2233: IF p_record_count = 0 THEN
2234: l_record_count := NULL;
2235: ELSE
2238: --
2239: FOR l_index IN 1 .. g_element_table.count
2240: LOOP
2241: --
2242: --hr_utility.set_location('Inside archive_user_element_info l_record_count'||l_record_count,1530);
2243:
2244: l_dummy := NULL;
2245: OPEN check_si_type(g_element_table(l_index).element_type_id ,p_effective_date);
2246: FETCH check_si_type INTO l_dummy;
2246: FETCH check_si_type INTO l_dummy;
2247: CLOSE check_si_type;
2248: -- If SI Type doesn't exist then normal processing
2249:
2250: --hr_utility.set_location('Inside archive_user_element_info l_dummy'||l_dummy,1530);
2251:
2252: IF l_dummy IS NULL THEN
2253: FOR rec_element_value IN csr_element_values
2254: (p_child_assignment_action,g_element_table(l_index).element_type_id
2259: l_main_sequence := l_main_sequence + 1;
2260: END IF;
2261: l_column_sequence := l_column_sequence + 1;
2262: --
2263: --hr_utility.set_location('Inside archive_user_element_info l_element_type_id'||l_element_type_id,1530);
2264: --hr_utility.set_location('Inside archive_user_element_info g_element_table(l_index).element_type_id'||g_element_table(l_index).element_type_id,1530);
2265: --hr_utility.set_location('Inside archive_user_element_info p_run_method'||p_run_method,1530);
2266:
2267: -- If the run method is P, Process Separate, then only archive the
2260: END IF;
2261: l_column_sequence := l_column_sequence + 1;
2262: --
2263: --hr_utility.set_location('Inside archive_user_element_info l_element_type_id'||l_element_type_id,1530);
2264: --hr_utility.set_location('Inside archive_user_element_info g_element_table(l_index).element_type_id'||g_element_table(l_index).element_type_id,1530);
2265: --hr_utility.set_location('Inside archive_user_element_info p_run_method'||p_run_method,1530);
2266:
2267: -- If the run method is P, Process Separate, then only archive the
2268: -- data if a skip rule (formula_id) has been set. If there is no
2261: l_column_sequence := l_column_sequence + 1;
2262: --
2263: --hr_utility.set_location('Inside archive_user_element_info l_element_type_id'||l_element_type_id,1530);
2264: --hr_utility.set_location('Inside archive_user_element_info g_element_table(l_index).element_type_id'||g_element_table(l_index).element_type_id,1530);
2265: --hr_utility.set_location('Inside archive_user_element_info p_run_method'||p_run_method,1530);
2266:
2267: -- If the run method is P, Process Separate, then only archive the
2268: -- data if a skip rule (formula_id) has been set. If there is no
2269: -- skip rule then the element info will be archived for the normal
2277: --ELSE
2278: --
2279: -- Archive EMEA ELEMENT INFO
2280: --
2281: --hr_utility.set_location('Inside archive_user_element_info p_run_method'||p_run_method,1530);
2282: pay_action_information_api.create_action_information (
2283: p_action_information_id => l_action_info_id
2284: ,p_action_context_id => p_action_context_id
2285: ,p_action_context_type => 'AAP'
2296: ,p_action_information5 => l_main_sequence
2297: ,p_action_information6 => l_multi_sequence
2298: ,p_action_information7 => l_column_sequence
2299: ,p_action_information8 => l_record_count);
2300: --hr_utility.set_location('Inside archive_user_element_info l_action_info_id'||l_action_info_id,1540);
2301: --END IF;
2302: --
2303: l_multi_sequence := NVL(l_multi_sequence,0) + 1;
2304: l_element_type_id := g_element_table(l_index).element_type_id;
2306: END LOOP;
2307: --
2308: ELSE -- If SI Type exist then archive by SI Type Values
2309: --
2310: --hr_utility.set_location('Inside archive_user_element_info si type'||g_element_table(l_index).si_type,1542);
2311: FOR rec_element_value IN csr_element_si_type_value (p_child_assignment_action
2312: ,g_element_table(l_index).element_type_id,g_element_table(l_index).input_value_id
2313: ,g_element_table(l_index).si_type,p_effective_date)
2314: LOOP
2312: ,g_element_table(l_index).element_type_id,g_element_table(l_index).input_value_id
2313: ,g_element_table(l_index).si_type,p_effective_date)
2314: LOOP
2315: --
2316: --hr_utility.set_location('Inside archive_user_element_info si type'||rec_element_value.si_type,1544);
2317: --hr_utility.set_location('Inside archive_user_element_info si type'||rec_element_value.value,1544);
2318:
2319: IF l_element_type_id <> g_element_table(l_index).element_type_id THEN
2320: l_main_sequence := l_main_sequence + 1;
2313: ,g_element_table(l_index).si_type,p_effective_date)
2314: LOOP
2315: --
2316: --hr_utility.set_location('Inside archive_user_element_info si type'||rec_element_value.si_type,1544);
2317: --hr_utility.set_location('Inside archive_user_element_info si type'||rec_element_value.value,1544);
2318:
2319: IF l_element_type_id <> g_element_table(l_index).element_type_id THEN
2320: l_main_sequence := l_main_sequence + 1;
2321: END IF;
2374: ,p_action_information6 => l_multi_sequence
2375: ,p_action_information7 => l_column_sequence
2376: ,p_action_information8 => l_record_count
2377: ,p_action_information9 => l_si_type_name);
2378: --hr_utility.set_location('Inside archive_user_element_info l_action_info_id'||l_action_info_id,1550);
2379: --END IF;
2380: --
2381: --
2382: l_multi_sequence := NVL(l_multi_sequence,0) + 1;
2385: END LOOP;
2386: END IF;
2387: l_multi_sequence := NULL;
2388: END LOOP;
2389: --hr_utility.set_location('Inside archive_user_element_info l_multi_sequence'||l_multi_sequence,1590);
2390: EXCEPTION
2391: WHEN NO_DATA_FOUND THEN
2392: NULL;
2393: END archive_user_element_info;
2482: l_record_count NUMBER;
2483: BEGIN
2484: --
2485:
2486: hr_utility.set_location('Inside process_balance p_action_context_id'||p_action_context_id,1820);
2487: hr_utility.set_location('Inside process_balance p_dimension'||p_dimension,1820);
2488:
2489: IF p_record_count = 0 THEN
2490: l_record_count := NULL;
2483: BEGIN
2484: --
2485:
2486: hr_utility.set_location('Inside process_balance p_action_context_id'||p_action_context_id,1820);
2487: hr_utility.set_location('Inside process_balance p_dimension'||p_dimension,1820);
2488:
2489: IF p_record_count = 0 THEN
2490: l_record_count := NULL;
2491: ELSE
2493: END IF;
2494:
2495: IF p_dimension LIKE '%SIT%' THEN
2496: --
2497: hr_utility.set_location('Inside process_balance p_si_type'||p_si_type,1840);
2498:
2499: IF p_si_type IS NULL THEN
2500: --
2501: -- Loop through pay_action_context table for all SI Type
2499: IF p_si_type IS NULL THEN
2500: --
2501: -- Loop through pay_action_context table for all SI Type
2502: --
2503: hr_utility.set_location('Inside process_balance p_source_id'||p_source_id,1860);
2504:
2505: FOR context_rec IN csr_get_si_types(p_source_id,'SOURCE_TEXT')
2506: LOOP
2507: --
2512: IF l_balance_value <> 0 THEN
2513: --
2514: -- Retreive SI Type Name from run results
2515: --
2516: hr_utility.set_location('Inside process_balance p_balance'||p_balance,1870);
2517: hr_utility.set_location('Inside process_balance p_source_id'||p_source_id,1870);
2518: hr_utility.set_location('Inside process_balance p_effective_date'||p_effective_date,1870);
2519: hr_utility.set_location('Inside process_balance context_rec.value'||context_rec.value,1870);
2520: BEGIN
2513: --
2514: -- Retreive SI Type Name from run results
2515: --
2516: hr_utility.set_location('Inside process_balance p_balance'||p_balance,1870);
2517: hr_utility.set_location('Inside process_balance p_source_id'||p_source_id,1870);
2518: hr_utility.set_location('Inside process_balance p_effective_date'||p_effective_date,1870);
2519: hr_utility.set_location('Inside process_balance context_rec.value'||context_rec.value,1870);
2520: BEGIN
2521: OPEN csr_get_sit_type_name(p_balance
2514: -- Retreive SI Type Name from run results
2515: --
2516: hr_utility.set_location('Inside process_balance p_balance'||p_balance,1870);
2517: hr_utility.set_location('Inside process_balance p_source_id'||p_source_id,1870);
2518: hr_utility.set_location('Inside process_balance p_effective_date'||p_effective_date,1870);
2519: hr_utility.set_location('Inside process_balance context_rec.value'||context_rec.value,1870);
2520: BEGIN
2521: OPEN csr_get_sit_type_name(p_balance
2522: ,p_source_id
2515: --
2516: hr_utility.set_location('Inside process_balance p_balance'||p_balance,1870);
2517: hr_utility.set_location('Inside process_balance p_source_id'||p_source_id,1870);
2518: hr_utility.set_location('Inside process_balance p_effective_date'||p_effective_date,1870);
2519: hr_utility.set_location('Inside process_balance context_rec.value'||context_rec.value,1870);
2520: BEGIN
2521: OPEN csr_get_sit_type_name(p_balance
2522: ,p_source_id
2523: ,p_effective_date
2525: FETCH csr_get_sit_type_name INTO l_si_type_name;
2526: CLOSE csr_get_sit_type_name;
2527: EXCEPTION
2528: WHEN OTHERS THEN
2529: hr_utility.set_location('Inside process_balance No Data Found',1870);
2530: null;
2531: END;
2532: --
2533: hr_utility.set_location('Inside process_balance l_balance_value'||l_balance_value,1880);
2529: hr_utility.set_location('Inside process_balance No Data Found',1870);
2530: null;
2531: END;
2532: --
2533: hr_utility.set_location('Inside process_balance l_balance_value'||l_balance_value,1880);
2534: hr_utility.set_location('Inside process_balance l_si_type_name'||l_si_type_name,1880);
2535:
2536: -- Archive EMEA BALANCE Context
2537: --
2530: null;
2531: END;
2532: --
2533: hr_utility.set_location('Inside process_balance l_balance_value'||l_balance_value,1880);
2534: hr_utility.set_location('Inside process_balance l_si_type_name'||l_si_type_name,1880);
2535:
2536: -- Archive EMEA BALANCE Context
2537: --
2538: --pay_action_information_api.create_action_information (..);
2554: ,p_action_information6 =>l_si_type_name);
2555:
2556: END IF;
2557: --
2558: --hr_utility.set_location('Inside process_balance l_action_info_id'||l_action_info_id,1900);
2559: END LOOP;
2560: --
2561: ELSE
2562: --
2565: FETCH csr_get_context_id INTO l_context_id;
2566: CLOSE csr_get_context_id;
2567: EXCEPTION
2568: WHEN OTHERS THEN
2569: hr_utility.set_location('Inside process_balance No Data Found',1820);
2570: null;
2571: END;
2572:
2573: hr_utility.set_location('Inside process_balance l_context_id'||l_context_id,1840);
2569: hr_utility.set_location('Inside process_balance No Data Found',1820);
2570: null;
2571: END;
2572:
2573: hr_utility.set_location('Inside process_balance l_context_id'||l_context_id,1840);
2574:
2575: l_balance_value := pay_balance_pkg.get_value(p_defined_bal_id,p_source_id
2576: ,null,null,l_context_id,p_si_type
2577: ,null,null);
2576: ,null,null,l_context_id,p_si_type
2577: ,null,null);
2578: --
2579:
2580: --hr_utility.set_location('Inside process_balance l_balance_value'||l_balance_value,1860);
2581:
2582: IF l_balance_value <> 0 THEN
2583: --
2584: -- Retreive SI Type Name from run results
2582: IF l_balance_value <> 0 THEN
2583: --
2584: -- Retreive SI Type Name from run results
2585: --
2586: hr_utility.set_location('Inside process_balance p_balance'||p_balance,1870);
2587: hr_utility.set_location('Inside process_balance p_source_id'||p_source_id,1870);
2588: hr_utility.set_location('Inside process_balance p_effective_date'||p_effective_date,1870);
2589: hr_utility.set_location('Inside process_balance p_si_type'||p_si_type,1870);
2590: BEGIN
2583: --
2584: -- Retreive SI Type Name from run results
2585: --
2586: hr_utility.set_location('Inside process_balance p_balance'||p_balance,1870);
2587: hr_utility.set_location('Inside process_balance p_source_id'||p_source_id,1870);
2588: hr_utility.set_location('Inside process_balance p_effective_date'||p_effective_date,1870);
2589: hr_utility.set_location('Inside process_balance p_si_type'||p_si_type,1870);
2590: BEGIN
2591: OPEN csr_get_sit_type_name(p_balance
2584: -- Retreive SI Type Name from run results
2585: --
2586: hr_utility.set_location('Inside process_balance p_balance'||p_balance,1870);
2587: hr_utility.set_location('Inside process_balance p_source_id'||p_source_id,1870);
2588: hr_utility.set_location('Inside process_balance p_effective_date'||p_effective_date,1870);
2589: hr_utility.set_location('Inside process_balance p_si_type'||p_si_type,1870);
2590: BEGIN
2591: OPEN csr_get_sit_type_name(p_balance
2592: ,p_source_id
2585: --
2586: hr_utility.set_location('Inside process_balance p_balance'||p_balance,1870);
2587: hr_utility.set_location('Inside process_balance p_source_id'||p_source_id,1870);
2588: hr_utility.set_location('Inside process_balance p_effective_date'||p_effective_date,1870);
2589: hr_utility.set_location('Inside process_balance p_si_type'||p_si_type,1870);
2590: BEGIN
2591: OPEN csr_get_sit_type_name(p_balance
2592: ,p_source_id
2593: ,p_effective_date
2595: FETCH csr_get_sit_type_name INTO l_si_type_name;
2596: CLOSE csr_get_sit_type_name;
2597: EXCEPTION
2598: WHEN OTHERS THEN
2599: hr_utility.set_location('Inside process_balance No Data Found',1875);
2600: null;
2601: END;
2602: --
2603:
2600: null;
2601: END;
2602: --
2603:
2604: hr_utility.set_location('Inside process_balance l_si_type_name'||l_si_type_name,1880);
2605: hr_utility.set_location('Inside process_balance l_balance_value'||l_balance_value,1880);
2606:
2607: -- Archive EMEA BALANCE Context
2608: --
2601: END;
2602: --
2603:
2604: hr_utility.set_location('Inside process_balance l_si_type_name'||l_si_type_name,1880);
2605: hr_utility.set_location('Inside process_balance l_balance_value'||l_balance_value,1880);
2606:
2607: -- Archive EMEA BALANCE Context
2608: --
2609: --pay_action_information_api.create_action_information (..);
2621: ,p_action_information2 =>p_si_type
2622: ,p_action_information4 =>fnd_number.number_to_canonical(l_balance_value)
2623: ,p_action_information5 =>l_record_count
2624: ,p_action_information6 =>l_si_type_name);
2625: hr_utility.set_location('Inside process_balance l_action_info_id'||l_action_info_id,1900);
2626: END IF;
2627: END IF;
2628: --
2629: ELSE
2627: END IF;
2628: --
2629: ELSE
2630:
2631: hr_utility.set_location('Inside process_balance coming in else',1850);
2632: --
2633: hr_utility.set_location('Inside process_balance p_balance'||p_balance,1850);
2634: hr_utility.set_location('Inside process_balance p_defined_bal_id'||p_defined_bal_id,1850);
2635: hr_utility.set_location('Inside process_balance p_source_id'||p_source_id,1850);
2629: ELSE
2630:
2631: hr_utility.set_location('Inside process_balance coming in else',1850);
2632: --
2633: hr_utility.set_location('Inside process_balance p_balance'||p_balance,1850);
2634: hr_utility.set_location('Inside process_balance p_defined_bal_id'||p_defined_bal_id,1850);
2635: hr_utility.set_location('Inside process_balance p_source_id'||p_source_id,1850);
2636: BEGIN
2637: l_balance_value := pay_balance_pkg.get_value(p_defined_bal_id
2630:
2631: hr_utility.set_location('Inside process_balance coming in else',1850);
2632: --
2633: hr_utility.set_location('Inside process_balance p_balance'||p_balance,1850);
2634: hr_utility.set_location('Inside process_balance p_defined_bal_id'||p_defined_bal_id,1850);
2635: hr_utility.set_location('Inside process_balance p_source_id'||p_source_id,1850);
2636: BEGIN
2637: l_balance_value := pay_balance_pkg.get_value(p_defined_bal_id
2638: ,p_source_id);
2631: hr_utility.set_location('Inside process_balance coming in else',1850);
2632: --
2633: hr_utility.set_location('Inside process_balance p_balance'||p_balance,1850);
2634: hr_utility.set_location('Inside process_balance p_defined_bal_id'||p_defined_bal_id,1850);
2635: hr_utility.set_location('Inside process_balance p_source_id'||p_source_id,1850);
2636: BEGIN
2637: l_balance_value := pay_balance_pkg.get_value(p_defined_bal_id
2638: ,p_source_id);
2639: EXCEPTION
2637: l_balance_value := pay_balance_pkg.get_value(p_defined_bal_id
2638: ,p_source_id);
2639: EXCEPTION
2640: WHEN OTHERS THEN
2641: hr_utility.set_location('Inside process_balance'||SQLCODE||SQLERRM,1849);
2642: null;
2643: END;
2644: hr_utility.set_location('Inside process_balance l_balance_value'||l_balance_value,1850);
2645:
2640: WHEN OTHERS THEN
2641: hr_utility.set_location('Inside process_balance'||SQLCODE||SQLERRM,1849);
2642: null;
2643: END;
2644: hr_utility.set_location('Inside process_balance l_balance_value'||l_balance_value,1850);
2645:
2646: IF l_balance_value <> 0 THEN
2647: --
2648: -- Archive EMEA BALANCE Context
2664: ,p_action_information4 =>fnd_number.number_to_canonical(l_balance_value)
2665: ,p_action_information5 =>l_record_count
2666: ,p_action_information6 =>l_si_type_name);
2667:
2668: hr_utility.set_location('Inside process_balance l_action_info_id'||l_action_info_id,1900);
2669: END IF;
2670: --
2671: END IF;
2672: EXCEPTION
2670: --
2671: END IF;
2672: EXCEPTION
2673: WHEN OTHERS THEN
2674: hr_utility.set_location('Inside process_balance No Data Found',1900);
2675: null;
2676: END process_balance;
2677: --
2678:
3096: l_temp_index := l_index;
3097: l_index := 29000;
3098: END IF;
3099:
3100: hr_utility.set_location('Inside archive_payslip_element_info1 element_name'||element_value_rec.element_name,2120);
3101: hr_utility.set_location('Inside archive_payslip_element_info1 l_defined_balance_id'||l_defined_balance_id,2120);
3102: hr_utility.set_location('Inside archive_payslip_element_info1 business_group_id'||element_value_rec.business_group_id,2120);
3103:
3104: IF l_travel_flag = 1 THEN
3097: l_index := 29000;
3098: END IF;
3099:
3100: hr_utility.set_location('Inside archive_payslip_element_info1 element_name'||element_value_rec.element_name,2120);
3101: hr_utility.set_location('Inside archive_payslip_element_info1 l_defined_balance_id'||l_defined_balance_id,2120);
3102: hr_utility.set_location('Inside archive_payslip_element_info1 business_group_id'||element_value_rec.business_group_id,2120);
3103:
3104: IF l_travel_flag = 1 THEN
3105: OPEN csr_defined_balance_id('Tax Travel Allowance','_ASG_YTD',0);
3098: END IF;
3099:
3100: hr_utility.set_location('Inside archive_payslip_element_info1 element_name'||element_value_rec.element_name,2120);
3101: hr_utility.set_location('Inside archive_payslip_element_info1 l_defined_balance_id'||l_defined_balance_id,2120);
3102: hr_utility.set_location('Inside archive_payslip_element_info1 business_group_id'||element_value_rec.business_group_id,2120);
3103:
3104: IF l_travel_flag = 1 THEN
3105: OPEN csr_defined_balance_id('Tax Travel Allowance','_ASG_YTD',0);
3106: FETCH csr_defined_balance_id INTO l_defined_balance_id;
3158: --7031784
3159: END IF;
3160: --5957039
3161:
3162: hr_utility.set_location('Inside archive_payslip_element_info1 l_rate'||l_rate,2121);
3163: hr_utility.set_location('Inside archive_payslip_element_info1 l_defined_balance_id'||l_defined_balance_id,2121);
3164: hr_utility.set_location('Inside archive_payslip_element_info1 p_run_assign_action_id'||p_run_assign_action_id,2121);
3165:
3166: IF l_defined_balance_id IS NOT NULL THEN
3159: END IF;
3160: --5957039
3161:
3162: hr_utility.set_location('Inside archive_payslip_element_info1 l_rate'||l_rate,2121);
3163: hr_utility.set_location('Inside archive_payslip_element_info1 l_defined_balance_id'||l_defined_balance_id,2121);
3164: hr_utility.set_location('Inside archive_payslip_element_info1 p_run_assign_action_id'||p_run_assign_action_id,2121);
3165:
3166: IF l_defined_balance_id IS NOT NULL THEN
3167: l_rate := pay_balance_pkg.get_value(l_defined_balance_id
3160: --5957039
3161:
3162: hr_utility.set_location('Inside archive_payslip_element_info1 l_rate'||l_rate,2121);
3163: hr_utility.set_location('Inside archive_payslip_element_info1 l_defined_balance_id'||l_defined_balance_id,2121);
3164: hr_utility.set_location('Inside archive_payslip_element_info1 p_run_assign_action_id'||p_run_assign_action_id,2121);
3165:
3166: IF l_defined_balance_id IS NOT NULL THEN
3167: l_rate := pay_balance_pkg.get_value(l_defined_balance_id
3168: ,p_run_assign_action_id);
3171: END IF;
3172:
3173: --
3174: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'archive_element_info l_rate'||' '||l_rate);
3175: hr_utility.set_location('Inside archive_payslip_element_info1 l_rate'||l_rate,2122);
3176: --
3177: -- Special Tax Deduction Elemetns requires Pay Value and Percentage
3178: -- Rate to be archived.
3179: IF p_element_name = 'Special Tax Deduction' THEN
3192: l_pecentage_rate:=l_pecentage_rate||'%';
3193: END IF;
3194: END IF;
3195: --
3196: hr_utility.set_location('Inside archive_payslip_element_info1 l_rate'||l_rate,2123);
3197: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_standard_rate) is not null
3198: OR FND_NUMBER.canonical_to_number(l_special_rate) is not null
3199: OR FND_NUMBER.canonical_to_number(l_payable) is not null
3200: OR l_rate is not null) THEN
3251:
3252: END IF;
3253: END LOOP;
3254: --
3255: hr_utility.set_location('Inside archive_payslip_element_info1 element_name'||p_element_name,2120);
3256:
3257: ELSIF p_element_name like 'Retro%' THEN
3258:
3259: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_element_name'||' '||p_element_name);
3260: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_child_count'||' '||p_child_count);
3261:
3262: IF p_child_count=0 THEN
3263:
3264: hr_utility.set_location('Retro Inside archive_payslip_element_info1 p_run_assign_action_id'||p_run_assign_action_id,2121);
3265: hr_utility.set_location('Retro Inside archive_payslip_element_info1 p_class_name'||p_class_name,2121);
3266: hr_utility.set_location('Retro Inside archive_payslip_element_info1 p_element_name'||p_element_name,2121);
3267:
3268: l_creator_type(0):='EE';
3261:
3262: IF p_child_count=0 THEN
3263:
3264: hr_utility.set_location('Retro Inside archive_payslip_element_info1 p_run_assign_action_id'||p_run_assign_action_id,2121);
3265: hr_utility.set_location('Retro Inside archive_payslip_element_info1 p_class_name'||p_class_name,2121);
3266: hr_utility.set_location('Retro Inside archive_payslip_element_info1 p_element_name'||p_element_name,2121);
3267:
3268: l_creator_type(0):='EE';
3269: l_creator_type(1):='RR';
3262: IF p_child_count=0 THEN
3263:
3264: hr_utility.set_location('Retro Inside archive_payslip_element_info1 p_run_assign_action_id'||p_run_assign_action_id,2121);
3265: hr_utility.set_location('Retro Inside archive_payslip_element_info1 p_class_name'||p_class_name,2121);
3266: hr_utility.set_location('Retro Inside archive_payslip_element_info1 p_element_name'||p_element_name,2121);
3267:
3268: l_creator_type(0):='EE';
3269: l_creator_type(1):='RR';
3270: l_creator_type(2):='PR';
3284: CLOSE csr_retro_element_periods;
3285:
3286: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'count'||' '||l_element_retro_entries.count);
3287:
3288: hr_utility.set_location('Retro Inside archive_payslip_element_info1 count'||l_element_retro_entries.count,2122);
3289:
3290: IF l_element_retro_entries.count > 0 THEN
3291: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'count'||' '||l_element_retro_entries.count);
3292:
3291: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'count'||' '||l_element_retro_entries.count);
3292:
3293: FOR i in l_element_retro_entries.first..l_element_retro_entries.last LOOP
3294:
3295: hr_utility.set_location('Retro Inside archive_payslip_element_info1 retro_date'||l_element_retro_entries(i),2123);
3296:
3297: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_element_retro_entries(i)'||' '||l_element_retro_entries(i));
3298: FOR j in l_creator_type.first..l_creator_type.last LOOP
3299: l_sum_standard_rate :='0';
3300: l_sum_special_rate :='0';
3301: l_sum_payable :='0';
3302: l_rate :=NULL;
3303:
3304: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_standard_rate'||l_sum_standard_rate,2124);
3305: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_special_rate'||l_sum_special_rate,2124);
3306: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_payable'||l_sum_payable,2124);
3307:
3308: FOR csr_np_rec IN csr_np_children(
3301: l_sum_payable :='0';
3302: l_rate :=NULL;
3303:
3304: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_standard_rate'||l_sum_standard_rate,2124);
3305: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_special_rate'||l_sum_special_rate,2124);
3306: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_payable'||l_sum_payable,2124);
3307:
3308: FOR csr_np_rec IN csr_np_children(
3309: p_master_assign_action_id,
3302: l_rate :=NULL;
3303:
3304: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_standard_rate'||l_sum_standard_rate,2124);
3305: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_special_rate'||l_sum_special_rate,2124);
3306: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_payable'||l_sum_payable,2124);
3307:
3308: FOR csr_np_rec IN csr_np_children(
3309: p_master_assign_action_id,
3310: p_payroll_action_id,
3310: p_payroll_action_id,
3311: p_assignment_id,
3312: p_effective_date) LOOP
3313:
3314: hr_utility.set_location('Retro Inside archive_payslip_element_info1 '||csr_np_rec.np_assignment_action_id,2124);
3315: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_payable'||l_sum_payable,2124);
3316: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'csr_np_rec.np_assignment_action_id'||' '||csr_np_rec.np_assignment_action_id);
3317:
3318: FOR retro_element_value_rec IN csr_retro_values(csr_np_rec.np_assignment_action_id
3311: p_assignment_id,
3312: p_effective_date) LOOP
3313:
3314: hr_utility.set_location('Retro Inside archive_payslip_element_info1 '||csr_np_rec.np_assignment_action_id,2124);
3315: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_payable'||l_sum_payable,2124);
3316: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'csr_np_rec.np_assignment_action_id'||' '||csr_np_rec.np_assignment_action_id);
3317:
3318: FOR retro_element_value_rec IN csr_retro_values(csr_np_rec.np_assignment_action_id
3319: ,p_class_name
3324: ,l_creator_type(j)) LOOP
3325:
3326: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'retro_element_value_rec.value'||' '||retro_element_value_rec.value);
3327:
3328: hr_utility.set_location('Retro Inside archive_payslip_element_info1 element_name'||retro_element_value_rec.value,2125);
3329: l_standard_rate:='0';
3330: l_special_rate:='0';
3331: l_payable:='0';
3332:
3330: l_special_rate:='0';
3331: l_payable:='0';
3332:
3333: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard'||' '||p_standard);
3334: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_payable'||l_sum_payable,2126);
3335: IF p_standard IS NOT NULL THEN
3336: OPEN csr_sec_classification(retro_element_value_rec.element_type_id
3337: ,p_standard
3338: ,p_date_earned);
3359: l_special_rate :=NULL;
3360: END IF;
3361: CLOSE csr_sec_classification;
3362: --
3363: hr_utility.set_location('Retro Inside archive_payslip_element_info1 l_sum_payable'||l_sum_payable,2126);
3364: END IF;
3365:
3366: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_payable_flag'||' '||p_payable_flag);
3367:
3364: END IF;
3365:
3366: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_payable_flag'||' '||p_payable_flag);
3367:
3368: hr_utility.set_location('Retro Inside archive_payslip_element_info2 p_payable_flag'||p_payable_flag,2120);
3369:
3370: IF p_payable_flag='Y' THEN
3371: l_payable := retro_element_value_rec.value;
3372: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_payable'||l_payable,2120);
3368: hr_utility.set_location('Retro Inside archive_payslip_element_info2 p_payable_flag'||p_payable_flag,2120);
3369:
3370: IF p_payable_flag='Y' THEN
3371: l_payable := retro_element_value_rec.value;
3372: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_payable'||l_payable,2120);
3373: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2120);
3374: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(l_payable));
3375: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2120);
3376: END IF;
3369:
3370: IF p_payable_flag='Y' THEN
3371: l_payable := retro_element_value_rec.value;
3372: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_payable'||l_payable,2120);
3373: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2120);
3374: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(l_payable));
3375: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2120);
3376: END IF;
3377:
3371: l_payable := retro_element_value_rec.value;
3372: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_payable'||l_payable,2120);
3373: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2120);
3374: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(l_payable));
3375: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2120);
3376: END IF;
3377:
3378:
3379: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
3405: l_rate :=NULL;
3406: END IF;
3407: --
3408: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'archive element info 1 l_rate'||' '||l_rate);
3409: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_rate'||l_rate,2122);
3410: --
3411: -- Special Tax Deduction Elemetns requires Pay Value and Percentage
3412: -- Rate to be archived.
3413: IF p_element_name = 'Retro Special Tax Deduction' THEN
3452:
3453: IF FND_NUMBER.canonical_to_number(l_sum_payable)=0 THEN
3454: l_sum_payable:=NULL;
3455: END IF;
3456: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_rate'||l_rate,2123);
3457: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2123);
3458:
3459: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) is not null
3460: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) is not null
3453: IF FND_NUMBER.canonical_to_number(l_sum_payable)=0 THEN
3454: l_sum_payable:=NULL;
3455: END IF;
3456: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_rate'||l_rate,2123);
3457: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2123);
3458:
3459: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) is not null
3460: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) is not null
3461: OR FND_NUMBER.canonical_to_number(l_sum_payable) is not null
3524: p_master_assign_action_id,
3525: p_payroll_action_id,
3526: p_assignment_id,
3527: p_effective_date) LOOP
3528: --hr_utility.set_location('Inside archive_payslip_element_info2 np_assignment_action_id'||csr_np_rec.np_assignment_action_id,2120);
3529: --hr_utility.set_location('Inside archive_payslip_element_info2 p_class_name'||p_class_name,2120);
3530: --hr_utility.set_location('Inside archive_payslip_element_info2 p_element_name'||p_element_name,2120);
3531: --hr_utility.set_location('Inside archive_payslip_element_info2 p_date_earned'||p_date_earned,2120);
3532:
3525: p_payroll_action_id,
3526: p_assignment_id,
3527: p_effective_date) LOOP
3528: --hr_utility.set_location('Inside archive_payslip_element_info2 np_assignment_action_id'||csr_np_rec.np_assignment_action_id,2120);
3529: --hr_utility.set_location('Inside archive_payslip_element_info2 p_class_name'||p_class_name,2120);
3530: --hr_utility.set_location('Inside archive_payslip_element_info2 p_element_name'||p_element_name,2120);
3531: --hr_utility.set_location('Inside archive_payslip_element_info2 p_date_earned'||p_date_earned,2120);
3532:
3533: FOR element_value_rec IN csr_element_values(csr_np_rec.np_assignment_action_id
3526: p_assignment_id,
3527: p_effective_date) LOOP
3528: --hr_utility.set_location('Inside archive_payslip_element_info2 np_assignment_action_id'||csr_np_rec.np_assignment_action_id,2120);
3529: --hr_utility.set_location('Inside archive_payslip_element_info2 p_class_name'||p_class_name,2120);
3530: --hr_utility.set_location('Inside archive_payslip_element_info2 p_element_name'||p_element_name,2120);
3531: --hr_utility.set_location('Inside archive_payslip_element_info2 p_date_earned'||p_date_earned,2120);
3532:
3533: FOR element_value_rec IN csr_element_values(csr_np_rec.np_assignment_action_id
3534: ,p_class_name
3527: p_effective_date) LOOP
3528: --hr_utility.set_location('Inside archive_payslip_element_info2 np_assignment_action_id'||csr_np_rec.np_assignment_action_id,2120);
3529: --hr_utility.set_location('Inside archive_payslip_element_info2 p_class_name'||p_class_name,2120);
3530: --hr_utility.set_location('Inside archive_payslip_element_info2 p_element_name'||p_element_name,2120);
3531: --hr_utility.set_location('Inside archive_payslip_element_info2 p_date_earned'||p_date_earned,2120);
3532:
3533: FOR element_value_rec IN csr_element_values(csr_np_rec.np_assignment_action_id
3534: ,p_class_name
3535: ,p_element_name
3564: END IF;
3565: CLOSE csr_sec_classification;
3566: --
3567: END IF;
3568: --hr_utility.set_location('Inside archive_payslip_element_info2 p_payable_flag'||p_payable_flag,2120);
3569:
3570: IF p_payable_flag='Y' THEN
3571: l_payable := element_value_rec.value;
3572: hr_utility.set_location('Inside archive_payslip_element_info2 l_payable'||l_payable,2120);
3568: --hr_utility.set_location('Inside archive_payslip_element_info2 p_payable_flag'||p_payable_flag,2120);
3569:
3570: IF p_payable_flag='Y' THEN
3571: l_payable := element_value_rec.value;
3572: hr_utility.set_location('Inside archive_payslip_element_info2 l_payable'||l_payable,2120);
3573: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(nvl(l_payable,'0')));
3574: hr_utility.set_location('Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2120);
3575: END IF;
3576:
3570: IF p_payable_flag='Y' THEN
3571: l_payable := element_value_rec.value;
3572: hr_utility.set_location('Inside archive_payslip_element_info2 l_payable'||l_payable,2120);
3573: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(nvl(l_payable,'0')));
3574: hr_utility.set_location('Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2120);
3575: END IF;
3576:
3577: --hr_utility.set_location('Inside archive_payslip_element_info2 element_name'||element_value_rec.element_name,2120);
3578: --hr_utility.set_location('Inside archive_payslip_element_info2 l_defined_balance_id'||l_defined_balance_id,2120);
3573: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(nvl(l_payable,'0')));
3574: hr_utility.set_location('Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2120);
3575: END IF;
3576:
3577: --hr_utility.set_location('Inside archive_payslip_element_info2 element_name'||element_value_rec.element_name,2120);
3578: --hr_utility.set_location('Inside archive_payslip_element_info2 l_defined_balance_id'||l_defined_balance_id,2120);
3579: --hr_utility.set_location('Inside archive_payslip_element_info2 business_group_id'||element_value_rec.business_group_id,2120);
3580:
3581: OPEN csr_defined_balance_id(element_value_rec.element_name,'_ASG_YTD',element_value_rec.business_group_id);
3574: hr_utility.set_location('Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2120);
3575: END IF;
3576:
3577: --hr_utility.set_location('Inside archive_payslip_element_info2 element_name'||element_value_rec.element_name,2120);
3578: --hr_utility.set_location('Inside archive_payslip_element_info2 l_defined_balance_id'||l_defined_balance_id,2120);
3579: --hr_utility.set_location('Inside archive_payslip_element_info2 business_group_id'||element_value_rec.business_group_id,2120);
3580:
3581: OPEN csr_defined_balance_id(element_value_rec.element_name,'_ASG_YTD',element_value_rec.business_group_id);
3582: FETCH csr_defined_balance_id INTO l_defined_balance_id;
3575: END IF;
3576:
3577: --hr_utility.set_location('Inside archive_payslip_element_info2 element_name'||element_value_rec.element_name,2120);
3578: --hr_utility.set_location('Inside archive_payslip_element_info2 l_defined_balance_id'||l_defined_balance_id,2120);
3579: --hr_utility.set_location('Inside archive_payslip_element_info2 business_group_id'||element_value_rec.business_group_id,2120);
3580:
3581: OPEN csr_defined_balance_id(element_value_rec.element_name,'_ASG_YTD',element_value_rec.business_group_id);
3582: FETCH csr_defined_balance_id INTO l_defined_balance_id;
3583: if csr_defined_balance_id%NOTFOUND then
3604: CLOSE csr_defined_balance_id;
3605: END IF;
3606: --5957039
3607:
3608: --hr_utility.set_location('Inside archive_payslip_element_info2 l_rate'||l_rate,2121);
3609: --hr_utility.set_location('Inside archive_payslip_element_info2 l_defined_balance_id'||l_defined_balance_id,2121);
3610: --hr_utility.set_location('Inside archive_payslip_element_info2 np_assignment_action_id'||csr_np_rec.np_assignment_action_id,2121);
3611:
3612: IF l_defined_balance_id IS NOT NULL THEN
3605: END IF;
3606: --5957039
3607:
3608: --hr_utility.set_location('Inside archive_payslip_element_info2 l_rate'||l_rate,2121);
3609: --hr_utility.set_location('Inside archive_payslip_element_info2 l_defined_balance_id'||l_defined_balance_id,2121);
3610: --hr_utility.set_location('Inside archive_payslip_element_info2 np_assignment_action_id'||csr_np_rec.np_assignment_action_id,2121);
3611:
3612: IF l_defined_balance_id IS NOT NULL THEN
3613: l_rate := pay_balance_pkg.get_value(l_defined_balance_id
3606: --5957039
3607:
3608: --hr_utility.set_location('Inside archive_payslip_element_info2 l_rate'||l_rate,2121);
3609: --hr_utility.set_location('Inside archive_payslip_element_info2 l_defined_balance_id'||l_defined_balance_id,2121);
3610: --hr_utility.set_location('Inside archive_payslip_element_info2 np_assignment_action_id'||csr_np_rec.np_assignment_action_id,2121);
3611:
3612: IF l_defined_balance_id IS NOT NULL THEN
3613: l_rate := pay_balance_pkg.get_value(l_defined_balance_id
3614: ,csr_np_rec.np_assignment_action_id);
3616: l_rate :=NULL;
3617: END IF;
3618: --
3619: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'archive_element_info 2 l_rate'||' '||l_rate);
3620: --hr_utility.set_location('Inside archive_payslip_element_info2 l_rate'||l_rate,2122);
3621: --
3622: -- Special Tax Deduction Elemetns requires Pay Value and Percentage
3623: -- Rate to be archived.
3624: IF p_element_name = 'Special Tax Deduction' THEN
3638: END IF;
3639: END IF;
3640: l_priority:=element_value_rec.priority;
3641: l_reporting_name:=element_value_rec.reporting_name;
3642: --hr_utility.set_location('Inside archive_payslip_element_info element_value_rec.RDate'||element_value_rec.RDate,2123);
3643: l_date:=element_value_rec.RDate;
3644: --hr_utility.set_location('Inside archive_payslip_element_info l_date'||l_date,2123);
3645: --
3646: END LOOP;
3640: l_priority:=element_value_rec.priority;
3641: l_reporting_name:=element_value_rec.reporting_name;
3642: --hr_utility.set_location('Inside archive_payslip_element_info element_value_rec.RDate'||element_value_rec.RDate,2123);
3643: l_date:=element_value_rec.RDate;
3644: --hr_utility.set_location('Inside archive_payslip_element_info l_date'||l_date,2123);
3645: --
3646: END LOOP;
3647: END LOOP;
3648: IF FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
3655:
3656: IF FND_NUMBER.canonical_to_number(l_sum_payable)=0 THEN
3657: l_sum_payable:=NULL;
3658: END IF;
3659: --hr_utility.set_location('Inside archive_payslip_element_info2 l_rate'||l_rate,2123);
3660: --hr_utility.set_location('Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2123);
3661:
3662: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) is not null
3663: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) is not null
3656: IF FND_NUMBER.canonical_to_number(l_sum_payable)=0 THEN
3657: l_sum_payable:=NULL;
3658: END IF;
3659: --hr_utility.set_location('Inside archive_payslip_element_info2 l_rate'||l_rate,2123);
3660: --hr_utility.set_location('Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2123);
3661:
3662: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) is not null
3663: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) is not null
3664: OR FND_NUMBER.canonical_to_number(l_sum_payable) is not null
3951: l_np_child_id NUMBER;
3952:
3953: BEGIN
3954: --
3955: --hr_utility.set_location('Inside p_dimension'||p_dimension,2110);
3956:
3957: l_index:=p_index;
3958:
3959: IF p_dimension = '_ASG_SIT_YTD' THEN
3962: p_assignment_id,p_effective_date);
3963: FETCH csr_np_children into l_np_child_id;
3964: CLOSE csr_np_children;
3965:
3966: hr_utility.set_location('Inside archive_balance_info1 p_balance_name'||p_balance_name,2222);
3967: hr_utility.set_location('Inside archive_balance_info1 l_count'||l_count,2222);
3968:
3969: IF l_np_child_id is not null THEN
3970:
3963: FETCH csr_np_children into l_np_child_id;
3964: CLOSE csr_np_children;
3965:
3966: hr_utility.set_location('Inside archive_balance_info1 p_balance_name'||p_balance_name,2222);
3967: hr_utility.set_location('Inside archive_balance_info1 l_count'||l_count,2222);
3968:
3969: IF l_np_child_id is not null THEN
3970:
3971: hr_utility.set_location('Inside archive_balance_info1 l_count'||l_count,2223);
3967: hr_utility.set_location('Inside archive_balance_info1 l_count'||l_count,2222);
3968:
3969: IF l_np_child_id is not null THEN
3970:
3971: hr_utility.set_location('Inside archive_balance_info1 l_count'||l_count,2223);
3972: hr_utility.set_location('Inside archive_balance_info1 np_assignment_action_id'||l_np_child_id,2223);
3973:
3974: -- Loop through pay_action_context table for all SI Type
3975: FOR context_rec IN csr_get_context_id(l_np_child_id,'SOURCE_TEXT')
3968:
3969: IF l_np_child_id is not null THEN
3970:
3971: hr_utility.set_location('Inside archive_balance_info1 l_count'||l_count,2223);
3972: hr_utility.set_location('Inside archive_balance_info1 np_assignment_action_id'||l_np_child_id,2223);
3973:
3974: -- Loop through pay_action_context table for all SI Type
3975: FOR context_rec IN csr_get_context_id(l_np_child_id,'SOURCE_TEXT')
3976: LOOP
3999: LOOP
4000: FETCH csr_np_children into csr_np_rec;
4001: EXIT when csr_np_children%NOTFOUND or csr_np_children%NOTFOUND IS NULL;
4002:
4003: --hr_utility.set_location('Inside archive_balance_info p_standard_bal_name'||p_standard_bal_name,2120);
4004:
4005: l_si_type := context_rec.value;
4006: l_standard_rate_run := 0;
4007: l_special_rate_run := 0;
4029: l_standard_rate_ytd := NVL(l_standard_rate_ytd,0) * p_multiply_factor;
4030: --
4031: END IF;
4032:
4033: --hr_utility.set_location('Inside archive_balance_info p_special_bal_name'||p_special_bal_name,2130);
4034:
4035: -- If Special Balance exist for this balance then retrive them
4036: IF p_special_bal_name IS NOT NULL THEN
4037: --
4051: l_special_rate_ytd := NVL(l_special_rate_ytd,0) * p_multiply_factor;
4052: --
4053: END IF;
4054:
4055: --hr_utility.set_location('Inside archive_balance_info p_non_tax_bal_name'||p_non_tax_bal_name,2140);
4056:
4057: -- If Non Taxable Balance exist for this balance then retrive them
4058: IF p_non_tax_bal_name IS NOT NULL THEN
4059: --
4075: --
4076:
4077: END IF;
4078:
4079: --hr_utility.set_location('Inside archive_balance_info p_standard_bal_name'||p_standard_bal_name,2150);
4080:
4081: --
4082: IF p_standard_bal_name IS NULL
4083: AND p_special_bal_name IS NULL
4131: IF p_payable_flag='N' AND l_sum_payable=0 THEN
4132: l_sum_payable:=NULL;
4133: END IF;
4134: --
4135: --hr_utility.set_location('Inside archive_balance_info p_standard_bal_name'||p_standard_bal_name,2160);
4136:
4137: -- Retreive SI Type Name from run results
4138: --
4139: p_balance_sit_name:=p_balance_name;
4146: ,csr_np_rec.np_assignment_action_id,p_date_earned,l_si_type);
4147: FETCH csr_get_sit_type_name INTO l_si_type_name;
4148: CLOSE csr_get_sit_type_name;
4149: --
4150: --hr_utility.set_location('Inside archive_balance_info p_standard_bal_name'||p_standard_bal_name,2170);
4151: --
4152: -- Get Balance Name to be reported in the Payslip
4153: --
4154: l_balance_name:=p_balance_name;
4164: CLOSE csr_np_children;
4165: END LOOP;--End of Cursor csr_assignment_actions Loop
4166: CLOSE csr_assignment_actions;
4167:
4168: hr_utility.set_location('Inside archive_balance_info1 l_sum_standard_rate_run'||l_sum_standard_rate_run,2229);
4169:
4170: IF l_si_type_name='ZVW' THEN
4171: IF p_balance_name = 'Employer SI Contribution' and l_index < 18700 THEN
4172: l_index := 18700;
4231: l_sum_special_rate_run :=0;
4232: l_sum_non_tax_rate_run :=0;
4233: l_sum_payable :=0;
4234: l_sum_year :=0;
4235: --hr_utility.set_location('Inside archive_balance_info p_standard_bal_name'||p_standard_bal_name,2180);
4236: /* FOR csr_np_rec IN csr_np_children(
4237: p_run_assign_action_id,
4238: p_payroll_action_id,
4239: p_assignment_id,
4272: --
4273:
4274: END IF;
4275:
4276: --hr_utility.set_location('Inside archive_balance_info p_special_bal_name'||p_special_bal_name,2190);
4277:
4278: -- If Special Balance exist for this balance then retrive them
4279: IF p_special_bal_name IS NOT NULL THEN
4280: --
4289: l_special_rate_ytd := NVL(l_special_rate_ytd,0) * p_multiply_factor;
4290: --
4291: END IF;
4292:
4293: --hr_utility.set_location('Inside archive_balance_info p_non_tax_bal_name'||p_non_tax_bal_name,2200);
4294:
4295: -- If Non Taxable Balance exist for this balance then retrive them
4296: IF p_non_tax_bal_name IS NOT NULL THEN
4297: --
4311: IF p_standard_bal_name IS NULL
4312: AND p_special_bal_name IS NULL
4313: AND p_non_tax_bal_name IS NULL THEN
4314:
4315: --hr_utility.set_location('Inside archive_balance_info p_balance_name'||p_balance_name,2150);
4316: --hr_utility.set_location('Inside archive_balance_info l_def_bal_id'||l_def_bal_id,2150);
4317: --hr_utility.set_location('Inside archive_balance_info p_run_assign_action_id'||p_run_assign_action_id,2150);
4318: --hr_utility.set_location('Inside archive_balance_info p_multiply_factor'||p_multiply_factor,2150);
4319: --
4312: AND p_special_bal_name IS NULL
4313: AND p_non_tax_bal_name IS NULL THEN
4314:
4315: --hr_utility.set_location('Inside archive_balance_info p_balance_name'||p_balance_name,2150);
4316: --hr_utility.set_location('Inside archive_balance_info l_def_bal_id'||l_def_bal_id,2150);
4317: --hr_utility.set_location('Inside archive_balance_info p_run_assign_action_id'||p_run_assign_action_id,2150);
4318: --hr_utility.set_location('Inside archive_balance_info p_multiply_factor'||p_multiply_factor,2150);
4319: --
4320: l_def_bal_id := get_defined_balance_id (p_balance_name,'_ASG_RUN');
4313: AND p_non_tax_bal_name IS NULL THEN
4314:
4315: --hr_utility.set_location('Inside archive_balance_info p_balance_name'||p_balance_name,2150);
4316: --hr_utility.set_location('Inside archive_balance_info l_def_bal_id'||l_def_bal_id,2150);
4317: --hr_utility.set_location('Inside archive_balance_info p_run_assign_action_id'||p_run_assign_action_id,2150);
4318: --hr_utility.set_location('Inside archive_balance_info p_multiply_factor'||p_multiply_factor,2150);
4319: --
4320: l_def_bal_id := get_defined_balance_id (p_balance_name,'_ASG_RUN');
4321: --hr_utility.set_location('Inside archive_balance_info l_def_bal_id'||l_def_bal_id,2152);
4314:
4315: --hr_utility.set_location('Inside archive_balance_info p_balance_name'||p_balance_name,2150);
4316: --hr_utility.set_location('Inside archive_balance_info l_def_bal_id'||l_def_bal_id,2150);
4317: --hr_utility.set_location('Inside archive_balance_info p_run_assign_action_id'||p_run_assign_action_id,2150);
4318: --hr_utility.set_location('Inside archive_balance_info p_multiply_factor'||p_multiply_factor,2150);
4319: --
4320: l_def_bal_id := get_defined_balance_id (p_balance_name,'_ASG_RUN');
4321: --hr_utility.set_location('Inside archive_balance_info l_def_bal_id'||l_def_bal_id,2152);
4322: IF p_payable_flag = 'Y' THEN
4317: --hr_utility.set_location('Inside archive_balance_info p_run_assign_action_id'||p_run_assign_action_id,2150);
4318: --hr_utility.set_location('Inside archive_balance_info p_multiply_factor'||p_multiply_factor,2150);
4319: --
4320: l_def_bal_id := get_defined_balance_id (p_balance_name,'_ASG_RUN');
4321: --hr_utility.set_location('Inside archive_balance_info l_def_bal_id'||l_def_bal_id,2152);
4322: IF p_payable_flag = 'Y' THEN
4323: l_payable := pay_balance_pkg.get_value(l_def_bal_id
4324: , csr_np_rec.np_assignment_action_id);
4325: IF p_balance_name = 'Gross Salary' THEN
4331: g_retro_travel_allowance);
4332: END IF;
4333: END IF;
4334:
4335: --hr_utility.set_location('Inside archive_balance_info l_payable'||l_payable,2152);
4336: --
4337: l_def_bal_id := get_defined_balance_id (p_balance_name,'_ASG_YTD');
4338: --hr_utility.set_location('Inside archive_balance_info l_def_bal_id'||l_def_bal_id,2153);
4339:
4334:
4335: --hr_utility.set_location('Inside archive_balance_info l_payable'||l_payable,2152);
4336: --
4337: l_def_bal_id := get_defined_balance_id (p_balance_name,'_ASG_YTD');
4338: --hr_utility.set_location('Inside archive_balance_info l_def_bal_id'||l_def_bal_id,2153);
4339:
4340: l_year := pay_balance_pkg.get_value(l_def_bal_id, csr_np_rec.np_assignment_action_id);
4341: IF p_balance_name = 'Gross Salary' THEN
4342: l_year := l_year - (g_zvw_er_cont_std_ytd +
4348: END IF;
4349:
4350: l_year := nvl(l_year,0) * p_multiply_factor;
4351:
4352: --hr_utility.set_location('Inside archive_balance_info l_payable'||l_payable,2153);
4353: --hr_utility.set_location('Inside archive_balance_info l_year'||l_year,2153);
4354: --
4355: ELSE
4356:
4349:
4350: l_year := nvl(l_year,0) * p_multiply_factor;
4351:
4352: --hr_utility.set_location('Inside archive_balance_info l_payable'||l_payable,2153);
4353: --hr_utility.set_location('Inside archive_balance_info l_year'||l_year,2153);
4354: --
4355: ELSE
4356:
4357: --
4386: IF p_payable_flag='N' AND l_sum_payable=0 THEN
4387: l_sum_payable:=NULL;
4388: END IF;
4389:
4390: --hr_utility.set_location('Inside archive_balance_info l_payable'||l_payable,2160);
4391: --
4392: /*IF p_payable_flag = 'N' THEN
4393: l_payable:=NULL;
4394: END IF;*/
4455: l_index:=l_index+1;
4456:
4457: END IF;
4458:
4459: --hr_utility.set_location('Inside archive_balance_info p_standard_bal_name'||p_standard_bal_name,2170);
4460: END IF;
4461:
4462: END archive_balance_info;
4463:
4719: FETCH csr_get_bal_init_class INTO l_bal_init_class_id;
4720: CLOSE csr_get_bal_init_class;
4721:
4722: l_index:=p_index;
4723: hr_utility.set_location('Inside archive_retro_balance_info l_index'||l_index,5000);
4724: hr_utility.set_location('Inside archive_retro_balance_info p_dimension'||p_dimension,5000);
4725:
4726: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_balance_name'||' '||p_balance_name);
4727: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dimension'||' '||p_dimension);
4720: CLOSE csr_get_bal_init_class;
4721:
4722: l_index:=p_index;
4723: hr_utility.set_location('Inside archive_retro_balance_info l_index'||l_index,5000);
4724: hr_utility.set_location('Inside archive_retro_balance_info p_dimension'||p_dimension,5000);
4725:
4726: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_balance_name'||' '||p_balance_name);
4727: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dimension'||' '||p_dimension);
4728:
4732: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_payroll_action_id'||' '||p_payroll_action_id);
4733: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_assignment_id'||' '||p_assignment_id);
4734: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_effective_date'||' '||p_effective_date);
4735:
4736: --hr_utility.set_location('Inside archive_retro_balance_info p_run_assign_action_id'||p_run_assign_action_id,5010);
4737: --hr_utility.set_location('Inside archive_retro_balance_info p_payroll_action_id'||p_payroll_action_id,5010);
4738: --hr_utility.set_location('Inside archive_retro_balance_info p_assignment_id'||p_assignment_id,5010);
4739: --hr_utility.set_location('Inside archive_retro_balance_info p_effective_date'||p_effective_date,5010);
4740: --Get the child action id with highest sequence
4733: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_assignment_id'||' '||p_assignment_id);
4734: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_effective_date'||' '||p_effective_date);
4735:
4736: --hr_utility.set_location('Inside archive_retro_balance_info p_run_assign_action_id'||p_run_assign_action_id,5010);
4737: --hr_utility.set_location('Inside archive_retro_balance_info p_payroll_action_id'||p_payroll_action_id,5010);
4738: --hr_utility.set_location('Inside archive_retro_balance_info p_assignment_id'||p_assignment_id,5010);
4739: --hr_utility.set_location('Inside archive_retro_balance_info p_effective_date'||p_effective_date,5010);
4740: --Get the child action id with highest sequence
4741:
4734: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_effective_date'||' '||p_effective_date);
4735:
4736: --hr_utility.set_location('Inside archive_retro_balance_info p_run_assign_action_id'||p_run_assign_action_id,5010);
4737: --hr_utility.set_location('Inside archive_retro_balance_info p_payroll_action_id'||p_payroll_action_id,5010);
4738: --hr_utility.set_location('Inside archive_retro_balance_info p_assignment_id'||p_assignment_id,5010);
4739: --hr_utility.set_location('Inside archive_retro_balance_info p_effective_date'||p_effective_date,5010);
4740: --Get the child action id with highest sequence
4741:
4742: l_creator_type(0):='EE';
4735:
4736: --hr_utility.set_location('Inside archive_retro_balance_info p_run_assign_action_id'||p_run_assign_action_id,5010);
4737: --hr_utility.set_location('Inside archive_retro_balance_info p_payroll_action_id'||p_payroll_action_id,5010);
4738: --hr_utility.set_location('Inside archive_retro_balance_info p_assignment_id'||p_assignment_id,5010);
4739: --hr_utility.set_location('Inside archive_retro_balance_info p_effective_date'||p_effective_date,5010);
4740: --Get the child action id with highest sequence
4741:
4742: l_creator_type(0):='EE';
4743: l_creator_type(1):='RR';
4748: p_assignment_id,p_effective_date);
4749: FETCH csr_np_children into l_np_child_id;
4750: CLOSE csr_np_children;
4751:
4752: --hr_utility.set_location('Inside archive_retro_balance_info l_np_child_id'||l_np_child_id,5020);
4753: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_np_child_id'||' '||l_np_child_id);
4754: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_balance_name'||' '||p_balance_name);
4755: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
4756: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_special_bal_name'||' '||p_special_bal_name);
4755: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
4756: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_special_bal_name'||' '||p_special_bal_name);
4757: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_date_earned'||' '||p_date_earned);
4758: --Get all the retro periods
4759: --hr_utility.set_location('Inside archive_retro_balance_info p_balance_name'||p_balance_name,5030);
4760: --hr_utility.set_location('Inside archive_retro_balance_info p_standard_bal_name'||p_standard_bal_name,5030);
4761: --hr_utility.set_location('Inside archive_retro_balance_info p_special_bal_name'||p_special_bal_name,5030);
4762: --hr_utility.set_location('Inside archive_retro_balance_info p_date_earned'||p_date_earned,5030);
4763:
4756: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_special_bal_name'||' '||p_special_bal_name);
4757: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_date_earned'||' '||p_date_earned);
4758: --Get all the retro periods
4759: --hr_utility.set_location('Inside archive_retro_balance_info p_balance_name'||p_balance_name,5030);
4760: --hr_utility.set_location('Inside archive_retro_balance_info p_standard_bal_name'||p_standard_bal_name,5030);
4761: --hr_utility.set_location('Inside archive_retro_balance_info p_special_bal_name'||p_special_bal_name,5030);
4762: --hr_utility.set_location('Inside archive_retro_balance_info p_date_earned'||p_date_earned,5030);
4763:
4764: OPEN csr_retro_element_periods(l_np_child_id,p_balance_name,p_standard_bal_name
4757: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_date_earned'||' '||p_date_earned);
4758: --Get all the retro periods
4759: --hr_utility.set_location('Inside archive_retro_balance_info p_balance_name'||p_balance_name,5030);
4760: --hr_utility.set_location('Inside archive_retro_balance_info p_standard_bal_name'||p_standard_bal_name,5030);
4761: --hr_utility.set_location('Inside archive_retro_balance_info p_special_bal_name'||p_special_bal_name,5030);
4762: --hr_utility.set_location('Inside archive_retro_balance_info p_date_earned'||p_date_earned,5030);
4763:
4764: OPEN csr_retro_element_periods(l_np_child_id,p_balance_name,p_standard_bal_name
4765: ,p_special_bal_name,p_date_earned,l_bal_init_class_id);
4758: --Get all the retro periods
4759: --hr_utility.set_location('Inside archive_retro_balance_info p_balance_name'||p_balance_name,5030);
4760: --hr_utility.set_location('Inside archive_retro_balance_info p_standard_bal_name'||p_standard_bal_name,5030);
4761: --hr_utility.set_location('Inside archive_retro_balance_info p_special_bal_name'||p_special_bal_name,5030);
4762: --hr_utility.set_location('Inside archive_retro_balance_info p_date_earned'||p_date_earned,5030);
4763:
4764: OPEN csr_retro_element_periods(l_np_child_id,p_balance_name,p_standard_bal_name
4765: ,p_special_bal_name,p_date_earned,l_bal_init_class_id);
4766: FETCH csr_retro_element_periods bulk collect into l_element_retro_entries;
4765: ,p_special_bal_name,p_date_earned,l_bal_init_class_id);
4766: FETCH csr_retro_element_periods bulk collect into l_element_retro_entries;
4767: CLOSE csr_retro_element_periods;
4768:
4769: --hr_utility.set_location('Inside archive_retro_balance_info p_date_earned'||p_date_earned,5040);
4770:
4771: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_element_retro_entries.count'||' '||l_element_retro_entries.count);
4772:
4773: -- Loop through pay_action_context table for all SI Type
4773: -- Loop through pay_action_context table for all SI Type
4774: FOR context_rec IN csr_get_context_id(l_np_child_id,'SOURCE_TEXT')
4775: LOOP
4776:
4777: --hr_utility.set_location('Inside archive_retro_balance_info l_element_retro_entries.count'||l_element_retro_entries.count,5050);
4778: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'context_rec'||' '||context_rec.value);
4779:
4780: IF l_element_retro_entries.count > 0 THEN
4781: FOR i in l_element_retro_entries.first..l_element_retro_entries.last LOOP
4779:
4780: IF l_element_retro_entries.count > 0 THEN
4781: FOR i in l_element_retro_entries.first..l_element_retro_entries.last LOOP
4782:
4783: --hr_utility.set_location('Inside archive_retro_balance_info l_element_retro_entries(i)'||l_element_retro_entries(i),5060);
4784: FOR j in l_creator_type.first..l_creator_type.last LOOP
4785: l_sum_standard_rate :='0';
4786: l_sum_special_rate :='0';
4787: l_sum_payable :='0';
4802: l_non_year :=0;
4803:
4804: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
4805:
4806: --hr_utility.set_location('Inside archive_retro_balance_info p_standard_bal_name'||p_standard_bal_name,5070);
4807: l_year_flag := 0;
4808: IF p_standard_bal_name IS NOT NULL THEN
4809:
4810: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'csr_np_rec'||' '||csr_np_rec.np_assignment_action_id);
4812: --FND_FILE.PUT_LINE(FND_FILE.LOG,' p_date_earned'||' '||p_date_earned);
4813: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_element_retro_entries(i)'||' '||l_element_retro_entries(i));
4814: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'context_rec.value'||' '||context_rec.value);
4815:
4816: --hr_utility.set_location('Inside archive_retro_balance_info np_assignment_action_id'||csr_np_rec.np_assignment_action_id,5080);
4817:
4818: OPEN csr_retro_values(csr_np_rec.np_assignment_action_id,p_standard_bal_name
4819: ,p_date_earned,l_element_retro_entries(i),context_rec.value,l_creator_type(j),l_bal_init_class_id);
4820: FETCH csr_retro_values INTO l_value,l_si_type_name,l_priority;
4818: OPEN csr_retro_values(csr_np_rec.np_assignment_action_id,p_standard_bal_name
4819: ,p_date_earned,l_element_retro_entries(i),context_rec.value,l_creator_type(j),l_bal_init_class_id);
4820: FETCH csr_retro_values INTO l_value,l_si_type_name,l_priority;
4821:
4822: --hr_utility.set_location('Inside archive_retro_balance_info l_value'||l_value,5090);
4823: --hr_utility.set_location('Inside archive_retro_balance_info l_si_type_name'||l_si_type_name,5090);
4824: --hr_utility.set_location('Inside archive_retro_balance_info l_priority'||l_priority,5090);
4825:
4826: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_value'||' '||l_value);
4819: ,p_date_earned,l_element_retro_entries(i),context_rec.value,l_creator_type(j),l_bal_init_class_id);
4820: FETCH csr_retro_values INTO l_value,l_si_type_name,l_priority;
4821:
4822: --hr_utility.set_location('Inside archive_retro_balance_info l_value'||l_value,5090);
4823: --hr_utility.set_location('Inside archive_retro_balance_info l_si_type_name'||l_si_type_name,5090);
4824: --hr_utility.set_location('Inside archive_retro_balance_info l_priority'||l_priority,5090);
4825:
4826: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_value'||' '||l_value);
4827:
4820: FETCH csr_retro_values INTO l_value,l_si_type_name,l_priority;
4821:
4822: --hr_utility.set_location('Inside archive_retro_balance_info l_value'||l_value,5090);
4823: --hr_utility.set_location('Inside archive_retro_balance_info l_si_type_name'||l_si_type_name,5090);
4824: --hr_utility.set_location('Inside archive_retro_balance_info l_priority'||l_priority,5090);
4825:
4826: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_value'||' '||l_value);
4827:
4828: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);
4853:
4854: END IF;
4855:
4856: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_special_bal_name'||' '||p_special_bal_name);
4857: --hr_utility.set_location('Inside archive_retro_balance_info p_special_bal_name'||p_special_bal_name,5100);
4858: IF csr_retro_values%ISOPEN THEN
4859: CLOSE csr_retro_values;
4860: END IF;
4861: IF p_special_bal_name IS NOT NULL THEN
4891: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_special_year'||' '||l_special_year);
4892: END IF;
4893: END IF;
4894:
4895: --hr_utility.set_location('Inside archive_retro_balance_info p_non_tax_bal_name'||p_non_tax_bal_name,5110);
4896:
4897:
4898: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_non_tax_bal_name'||' '||p_non_tax_bal_name);
4899:
4931: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_non_year'||' '||l_non_year);
4932: END IF;
4933: END IF;
4934:
4935: --hr_utility.set_location('Inside archive_retro_balance_info p_balance_name'||p_balance_name,5120);
4936:
4937: IF p_standard_bal_name IS NULL
4938: AND p_special_bal_name IS NULL
4939: AND p_non_tax_bal_name IS NULL THEN
4988: END IF;
4989: IF csr_retro_values%ISOPEN THEN
4990: CLOSE csr_retro_values;
4991: END IF;
4992: --hr_utility.set_location('Inside archive_retro_balance_info l_sum_year'||l_sum_year,5130);
4993: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_balance_name'||' '||l_balance_name);
4994: l_balance_name:=p_balance_name;
4995: --hr_utility.set_location('Inside archive_retro_balance_info l_balance_name'||l_balance_name,5140);
4996:
4991: END IF;
4992: --hr_utility.set_location('Inside archive_retro_balance_info l_sum_year'||l_sum_year,5130);
4993: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_balance_name'||' '||l_balance_name);
4994: l_balance_name:=p_balance_name;
4995: --hr_utility.set_location('Inside archive_retro_balance_info l_balance_name'||l_balance_name,5140);
4996:
4997: OPEN csr_get_translated_bal_name (p_balance_name);
4998: FETCH csr_get_translated_bal_name INTO l_balance_name;
4999: IF csr_get_translated_bal_name%NOTFOUND THEN
5000: l_balance_name :=hr_general.decode_lookup('HR_NL_REPORT_LABELS',UPPER(p_balance_name));
5001: END IF;
5002: CLOSE csr_get_translated_bal_name;
5003:
5004: --hr_utility.set_location('Inside archive_retro_balance_info l_balance_name'||l_balance_name,5150);
5005:
5006: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_balance_name'||' '||l_balance_name);
5007:
5008: l_date:=fnd_date.date_to_canonical(l_element_retro_entries(i));
5020: END IF;
5021: END IF;
5022: END LOOP;
5023:
5024: --hr_utility.set_location('Inside archive_retro_balance_info l_balance_name'||l_balance_name,5150);
5025:
5026:
5027: IF l_balance_name='Retro Net Employee SI Contribution' and
5028: FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
5047: IF p_balance_name = 'Retro Net Employee SI Contribution' and l_index < 18950 THEN
5048: l_index := 18950;
5049: END IF;
5050: END IF;
5051: --hr_utility.set_location('Inside archive_retro_balance_info l_rate'||l_sum_year,5123);
5052: --hr_utility.set_location('Inside archive_retro_balance_info l_sum_payable'||l_sum_payable,5123);
5053:
5054: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5055: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_special_rate'||' '||l_sum_special_rate);
5048: l_index := 18950;
5049: END IF;
5050: END IF;
5051: --hr_utility.set_location('Inside archive_retro_balance_info l_rate'||l_sum_year,5123);
5052: --hr_utility.set_location('Inside archive_retro_balance_info l_sum_payable'||l_sum_payable,5123);
5053:
5054: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5055: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_special_rate'||' '||l_sum_special_rate);
5056: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
5101: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_payroll_action_id'||' '||p_payroll_action_id);
5102: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_assignment_id'||' '||p_assignment_id);
5103: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_effective_date'||' '||p_effective_date);
5104:
5105: --hr_utility.set_location('Inside archive_retro_balance_info non context p_balance_name'||p_balance_name,6000);
5106: l_creator_type(0):='EE';
5107: l_creator_type(1):='RR';
5108: l_creator_type(2):='PR';
5109: l_creator_type(3):='NR';
5113: p_assignment_id,p_effective_date);
5114: FETCH csr_np_children into l_np_child_id;
5115: CLOSE csr_np_children;
5116:
5117: --hr_utility.set_location('Inside archive_retro_balance_info non context l_np_child_id'||l_np_child_id,6010);
5118:
5119: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_np_child_id'||' '||l_np_child_id);
5120: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_balance_name'||' '||p_balance_name);
5121: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_date_earned'||' '||p_date_earned);
5124: ,p_standard_bal_name,p_special_bal_name,p_date_earned,l_bal_init_class_id);
5125: FETCH csr_retro_element_periods bulk collect into l_element_retro_entries;
5126: CLOSE csr_retro_element_periods;
5127:
5128: --hr_utility.set_location('Inside archive_retro_balance_info non context l_element_retro_entries.count'||l_element_retro_entries.count,6120);
5129:
5130: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_element_retro_entries.count'||' '||l_element_retro_entries.count);
5131:
5132:
5132:
5133: IF l_element_retro_entries.count > 0 THEN
5134: FOR i in l_element_retro_entries.first..l_element_retro_entries.last
5135: LOOP
5136: --hr_utility.set_location('Inside archive_retro_balance_info non context p_balance_name'||p_balance_name,6120);
5137: FOR j in l_creator_type.first..l_creator_type.last
5138: LOOP
5139: l_sum_standard_rate :='0';
5140: l_sum_special_rate :='0';
5158: l_standard_ptd :=0;
5159: l_special_ptd :=0;
5160:
5161:
5162: --hr_utility.set_location('Inside archive_retro_balance_info non context csr_np_rec.np_assignment_action_id'||csr_np_rec.np_assignment_action_id,6130);
5163:
5164: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
5165:
5166: --hr_utility.set_location('Inside archive_retro_balance_info non context p_standard_bal_name'||p_standard_bal_name,6140);
5162: --hr_utility.set_location('Inside archive_retro_balance_info non context csr_np_rec.np_assignment_action_id'||csr_np_rec.np_assignment_action_id,6130);
5163:
5164: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
5165:
5166: --hr_utility.set_location('Inside archive_retro_balance_info non context p_standard_bal_name'||p_standard_bal_name,6140);
5167:
5168: IF p_standard_bal_name IS NOT NULL THEN
5169:
5170: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'csr_np_rec'||' '||csr_np_rec.np_assignment_action_id);
5171: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_standard_bal_name'||' '||p_standard_bal_name);
5172: --FND_FILE.PUT_LINE(FND_FILE.LOG,' p_date_earned'||' '||p_date_earned);
5173: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_element_retro_entries(i)'||' '||l_element_retro_entries(i));
5174:
5175: --hr_utility.set_location('Inside archive_retro_balance_info non context p_standard_bal_name'||p_standard_bal_name,6150);
5176:
5177: OPEN csr_retro_values_nc(csr_np_rec.np_assignment_action_id,p_standard_bal_name
5178: ,p_date_earned,l_element_retro_entries(i),l_creator_type(j),l_bal_init_class_id);
5179: FETCH csr_retro_values_nc INTO l_value,l_priority;
5214:
5215: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5216: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);
5217:
5218: --hr_utility.set_location('Inside archive_retro_balance_info non context p_standard_bal_name'||p_standard_bal_name,6160);
5219: END IF;
5220: --IF l_flag=1 THEN
5221: l_def_bal_id := get_defined_balance_id (p_standard_bal_name,'_ASG_YTD');
5222: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
5250:
5251: END IF;
5252: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_special_bal_name'||' '||p_special_bal_name);
5253:
5254: --hr_utility.set_location('Inside archive_retro_balance_info non context p_special_bal_name'||p_special_bal_name,6170);
5255: IF csr_retro_values_nc%ISOPEN THEN
5256: CLOSE csr_retro_values_nc;
5257: END IF;
5258:
5256: CLOSE csr_retro_values_nc;
5257: END IF;
5258:
5259: IF p_special_bal_name IS NOT NULL THEN
5260: --hr_utility.set_location('Inside archive_retro_balance_info non context p_special_bal_name'||p_special_bal_name,6180);
5261: OPEN csr_retro_values_nc(csr_np_rec.np_assignment_action_id,p_special_bal_name
5262: ,p_date_earned,l_element_retro_entries(i),l_creator_type(j),l_bal_init_class_id);
5263: FETCH csr_retro_values_nc INTO l_value,l_priority;
5264: --FND_FILE.PUT_LINE(FND_FILE.LOG,' l_value'||' '||l_value);
5277: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_special_rate'||' '||l_sum_special_rate);
5278: l_flag:=1;
5279: CLOSE csr_retro_values_nc;
5280: END IF;
5281: --hr_utility.set_location('Inside archive_retro_balance_info non context p_special_bal_name'||p_special_bal_name,6190);
5282:
5283: l_def_bal_id := get_defined_balance_id (p_special_bal_name,'_ASG_YTD');
5284: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
5285: IF l_def_bal_id IS NOT NULL THEN
5302: END IF;
5303: END IF;--End of IF p_special_bal_name IS NOT NULL THEN
5304:
5305:
5306: --hr_utility.set_location('Inside archive_retro_balance_info non context p_balance_name'||p_balance_name,6200);
5307:
5308: IF p_standard_bal_name IS NULL
5309: AND p_special_bal_name IS NULL
5310: AND p_non_tax_bal_name IS NULL THEN
5308: IF p_standard_bal_name IS NULL
5309: AND p_special_bal_name IS NULL
5310: AND p_non_tax_bal_name IS NULL THEN
5311:
5312: --hr_utility.set_location('Inside archive_retro_balance_info non context p_balance_name'||p_balance_name,6210);
5313:
5314: OPEN csr_retro_values_nc(csr_np_rec.np_assignment_action_id
5315: ,p_balance_name,p_date_earned,l_element_retro_entries(i),l_creator_type(j),l_bal_init_class_id);
5316: FETCH csr_retro_values_nc INTO l_value,l_priority;
5323: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(l_rate));
5324: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
5325:
5326: CLOSE csr_retro_values_nc;
5327: --hr_utility.set_location('Inside archive_retro_balance_info non context p_balance_name'||p_balance_name,6220);
5328:
5329: l_def_bal_id := get_defined_balance_id (p_balance_name,'_ASG_YTD');
5330: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_def_bal_id'||' '||l_def_bal_id);
5331:
5354:
5355: IF csr_retro_values_nc%ISOPEN THEN
5356: CLOSE csr_retro_values_nc;
5357: END IF;
5358: --hr_utility.set_location('Inside archive_retro_balance_info non context l_sum_year'||l_sum_year,6230);
5359:
5360: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_balance_name'||' '||l_balance_name);
5361: l_balance_name:=p_balance_name;
5362:
5359:
5360: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_balance_name'||' '||l_balance_name);
5361: l_balance_name:=p_balance_name;
5362:
5363: --hr_utility.set_location('Inside archive_retro_balance_info non context l_balance_name'||l_balance_name,6240);
5364:
5365: OPEN csr_get_translated_bal_name (p_balance_name);
5366: FETCH csr_get_translated_bal_name INTO l_balance_name;
5367: IF csr_get_translated_bal_name%NOTFOUND THEN
5367: IF csr_get_translated_bal_name%NOTFOUND THEN
5368: l_balance_name :=hr_general.decode_lookup('HR_NL_REPORT_LABELS',UPPER(p_balance_name));
5369: END IF;
5370: CLOSE csr_get_translated_bal_name;
5371: --hr_utility.set_location('Inside archive_retro_balance_info non context l_balance_name'||l_balance_name,6250);
5372:
5373: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_balance_name'||' '||l_balance_name);
5374:
5375: l_sum_ptd:=l_standard_ptd + l_special_ptd;
5385: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_date'||' '||l_date);
5386: --
5387: END LOOP;
5388:
5389: --hr_utility.set_location('Inside archive_retro_balance_info non context l_date'||l_date,6260);
5390:
5391:
5392:
5393:
5413: END IF;
5414:
5415:
5416:
5417: --hr_utility.set_location('Inside archive_retro_balance_info non context l_sum_standard_rate'||l_sum_standard_rate,6270);
5418: --hr_utility.set_location('Inside archive_retro_balance_info non context l_sum_year'||l_sum_year,6280);
5419: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5420: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_special_rate'||' '||l_sum_special_rate);
5421: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
5414:
5415:
5416:
5417: --hr_utility.set_location('Inside archive_retro_balance_info non context l_sum_standard_rate'||l_sum_standard_rate,6270);
5418: --hr_utility.set_location('Inside archive_retro_balance_info non context l_sum_year'||l_sum_year,6280);
5419: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5420: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_special_rate'||' '||l_sum_special_rate);
5421: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
5422: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_year'||' '||l_sum_year);
6198: l_dp_de varchar2(2);
6199:
6200: BEGIN
6201: --
6202: --hr_utility.trace_on(NULL,'PSA');
6203: --hr_utility.set_location('Entering Archive Code',800);
6204: --
6205: g_zvw_er_cont_std_run := 0;
6206: g_zvw_er_cont_spl_run := 0;
6199:
6200: BEGIN
6201: --
6202: --hr_utility.trace_on(NULL,'PSA');
6203: --hr_utility.set_location('Entering Archive Code',800);
6204: --
6205: g_zvw_er_cont_std_run := 0;
6206: g_zvw_er_cont_spl_run := 0;
6207: g_zvw_er_cont_std_ytd := 0;
6227: l_archive_user := 0;
6228: l_emp_archived := 0;
6229: l_nl_emp_archived := 0;
6230:
6231: --hr_utility.set_location('Inside Archive Code l_chunk_number'||l_chunk_number,850);
6232: --hr_utility.set_location('Inside Archive Code p_assignment_action_id'||p_assignment_action_id,850);
6233:
6234: OPEN csr_get_max_assignment_action(p_assignment_action_id);
6235: FETCH csr_get_max_assignment_action INTO v_csr_max_assact;
6228: l_emp_archived := 0;
6229: l_nl_emp_archived := 0;
6230:
6231: --hr_utility.set_location('Inside Archive Code l_chunk_number'||l_chunk_number,850);
6232: --hr_utility.set_location('Inside Archive Code p_assignment_action_id'||p_assignment_action_id,850);
6233:
6234: OPEN csr_get_max_assignment_action(p_assignment_action_id);
6235: FETCH csr_get_max_assignment_action INTO v_csr_max_assact;
6236: CLOSE csr_get_max_assignment_action;
6261: -- to the global package if there are multiple runs in a single
6262: -- pre payment.
6263: --
6264:
6265: hr_utility.set_location('Inside Archive Code csr_rec.pre_assignment_action_id'||csr_rec.pre_assignment_action_id ,900);
6266: hr_utility.set_location('Inside Archive Code csr_rec.assignment_id'||csr_rec.assignment_id ,900);
6267: hr_utility.set_location('Inside Archive Code csr_rec.master_assignment_action_id'||csr_rec.master_assignment_action_id ,900);
6268: hr_utility.set_location('Inside Archive Code g_payroll_action_id'||g_payroll_action_id,900);
6269:
6262: -- pre payment.
6263: --
6264:
6265: hr_utility.set_location('Inside Archive Code csr_rec.pre_assignment_action_id'||csr_rec.pre_assignment_action_id ,900);
6266: hr_utility.set_location('Inside Archive Code csr_rec.assignment_id'||csr_rec.assignment_id ,900);
6267: hr_utility.set_location('Inside Archive Code csr_rec.master_assignment_action_id'||csr_rec.master_assignment_action_id ,900);
6268: hr_utility.set_location('Inside Archive Code g_payroll_action_id'||g_payroll_action_id,900);
6269:
6270: If csr_assignment_actions%NOTFOUND THEN
6263: --
6264:
6265: hr_utility.set_location('Inside Archive Code csr_rec.pre_assignment_action_id'||csr_rec.pre_assignment_action_id ,900);
6266: hr_utility.set_location('Inside Archive Code csr_rec.assignment_id'||csr_rec.assignment_id ,900);
6267: hr_utility.set_location('Inside Archive Code csr_rec.master_assignment_action_id'||csr_rec.master_assignment_action_id ,900);
6268: hr_utility.set_location('Inside Archive Code g_payroll_action_id'||g_payroll_action_id,900);
6269:
6270: If csr_assignment_actions%NOTFOUND THEN
6271: --hr_utility.set_location('Inside Archive Code g_payroll_action_id'||g_payroll_action_id,950);
6264:
6265: hr_utility.set_location('Inside Archive Code csr_rec.pre_assignment_action_id'||csr_rec.pre_assignment_action_id ,900);
6266: hr_utility.set_location('Inside Archive Code csr_rec.assignment_id'||csr_rec.assignment_id ,900);
6267: hr_utility.set_location('Inside Archive Code csr_rec.master_assignment_action_id'||csr_rec.master_assignment_action_id ,900);
6268: hr_utility.set_location('Inside Archive Code g_payroll_action_id'||g_payroll_action_id,900);
6269:
6270: If csr_assignment_actions%NOTFOUND THEN
6271: --hr_utility.set_location('Inside Archive Code g_payroll_action_id'||g_payroll_action_id,950);
6272: -- IF csr_assignment_actions%ROWCOUNT > 0 then
6267: hr_utility.set_location('Inside Archive Code csr_rec.master_assignment_action_id'||csr_rec.master_assignment_action_id ,900);
6268: hr_utility.set_location('Inside Archive Code g_payroll_action_id'||g_payroll_action_id,900);
6269:
6270: If csr_assignment_actions%NOTFOUND THEN
6271: --hr_utility.set_location('Inside Archive Code g_payroll_action_id'||g_payroll_action_id,950);
6272: -- IF csr_assignment_actions%ROWCOUNT > 0 then
6273: --Bug No. 3199386
6274: --shveerab
6275:
6278: CLOSE csr_period_end_date;
6279: --
6280: -- Archive EMPLOYEE DETAILS Context
6281: --
6282: --hr_utility.set_location('Inside Archive Code g_payroll_action_id'||g_payroll_action_id,1000);
6283:
6284: --Added Additional Code (Bug:3869788) to Pick Up
6285: --Prepayment Master Assignment Action Id if Multiple Asg Payment Consoliation is enabled
6286: --Else Pick up the Prepayment Asg Action Id a before.
6315:
6316: /*FOR l_index IN 1 .. g_user_balance_table.count
6317: LOOP
6318:
6319: hr_utility.set_location('Inside Archive Code for NP run Type'||g_user_balance_table(l_index).balance_name,1260);
6320:
6321: pay_nl_payslip_archive.process_balance (
6322: p_action_context_id => p_assignment_action_id
6323: , p_assignment_id => csr_rec.assignment_id
6337: --
6338: /*FOR l_index IN 1 .. g_statutory_balance_table.count
6339: LOOP
6340:
6341: hr_utility.set_location('Inside Archive Code for NP run Type '||g_statutory_balance_table(l_index).balance_name,1270);
6342: pay_nl_payslip_archive.process_balance (
6343: p_action_context_id => p_assignment_action_id
6344: ,p_assignment_id => csr_rec.assignment_id
6345: ,p_source_id => l_latest_child_asg_action_id
6366: -- END IF;
6367: EXIT;
6368: END IF;
6369:
6370: --hr_utility.set_location('Inside Archive Code master_assignment_action_id'||csr_rec.master_assignment_action_id,1100);
6371: --
6372: -- If child actions exist for the given master action
6373: --
6374:
6379: csr_rec.effective_date)
6380:
6381: LOOP
6382:
6383: --hr_utility.set_location('Inside Archive Code pay_payroll_action_id'||csr_rec.pay_payroll_action_id,1200);
6384: -- create additional archive assignment actions and interlocks
6385:
6386: IF csr_child_rec.run_type = 'NP' THEN
6387: l_child_count := 0;
6431: CLOSE csr_period_end_date;
6432: --
6433: -- Archive EMPLOYEE DETAILS Context
6434: --
6435: --hr_utility.set_location('Inside Archive Code g_payroll_action_id'||g_payroll_action_id,1000);
6436:
6437: --Added Additional Code (Bug:3869788) to Pick Up
6438: --Prepayment Master Assignment Action Id if Multiple Asg Payment Consoliation is enabled
6439: --Else Pick up the Prepayment Asg Action Id a before.
6500: END IF;
6501: IF ((v_csr_max_assact.max_assact <> p_assignment_action_id AND (l_stat_not_ytd = 1))
6502: OR (v_csr_max_assact.max_assact = p_assignment_action_id AND csr_np_rec.np_assignment_action_id <> csr_child_rec.child_assignment_action_id AND (l_stat_not_ytd = 1))
6503: OR v_csr_max_assact.max_assact = p_assignment_action_id AND csr_np_rec.np_assignment_action_id = csr_child_rec.child_assignment_action_id AND (l_archive_stat = 0 OR (l_archive_stat = 1 AND l_stat_not_ytd = 1))) THEN
6504: hr_utility.set_location('Inside Archive Code for NP run Type '||g_statutory_balance_table(l_index).balance_name,1270);
6505: pay_nl_payslip_archive.process_balance (
6506: p_action_context_id => p_assignment_action_id
6507: ,p_assignment_id => csr_rec.assignment_id
6508: ,p_source_id => csr_np_rec.np_assignment_action_id
6527: END IF;
6528: IF ((v_csr_max_assact.max_assact <> p_assignment_action_id AND (l_user_not_ytd = 1))
6529: OR (v_csr_max_assact.max_assact = p_assignment_action_id AND csr_np_rec.np_assignment_action_id <> csr_child_rec.child_assignment_action_id AND (l_user_not_ytd = 1))
6530: OR v_csr_max_assact.max_assact = p_assignment_action_id AND csr_np_rec.np_assignment_action_id = csr_child_rec.child_assignment_action_id AND (l_archive_user = 0 OR (l_archive_user = 1 AND l_user_not_ytd = 1))) THEN
6531: hr_utility.set_location('Inside Archive Code for NP run Type'||g_user_balance_table(l_index).balance_name,1260);
6532: pay_nl_payslip_archive.process_balance (
6533: p_action_context_id => p_assignment_action_id
6534: , p_assignment_id => csr_rec.assignment_id
6535: , p_source_id => csr_np_rec.np_assignment_action_id
6552:
6553: END LOOP; -- child assignment actions
6554: --
6555:
6556: --hr_utility.set_location('Inside Archive Code l_record_count'||l_record_count,1300);
6557:
6558: --
6559: -- Archive for the main run
6560: --
6560: --
6561: -- This section of the code can be removed once iterative engine setup has
6562: -- been enabled for NL.i.e when rule type has been sedded for NL
6563: --
6564: --hr_utility.set_location('Inside Archive Code l_record_count'||l_record_count,1400);
6565: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||l_iterative_flag,1400);
6566:
6567: IF l_iterative_flag = 'N' THEN
6568: --
6561: -- This section of the code can be removed once iterative engine setup has
6562: -- been enabled for NL.i.e when rule type has been sedded for NL
6563: --
6564: --hr_utility.set_location('Inside Archive Code l_record_count'||l_record_count,1400);
6565: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||l_iterative_flag,1400);
6566:
6567: IF l_iterative_flag = 'N' THEN
6568: --
6569: -- Archive NL EMPLOYEE DETAILS,NL OTHER EMPLOYEE DETAILS
6586: --,p_date_earned => csr_rec.effective_date);
6587: ,p_date_earned => csr_rec.date_earned);
6588: END IF;
6589:
6590: --hr_utility.set_location('Inside Archive Code p_assignment_action_id'||p_assignment_action_id,1500);
6591:
6592: -- Archive User Element Information in EMEA ELEMENT INFO Context
6593: pay_nl_payslip_archive.archive_user_element_info (
6594: p_action_context_id => p_assignment_action_id
6598: , p_effective_date => csr_rec.date_earned
6599: , p_record_count => l_record_count
6600: , p_run_method => NULL);
6601:
6602: --hr_utility.set_location('Inside Archive Code csr_rec.master_assignment_action_id'||csr_rec.master_assignment_action_id,1600);
6603:
6604: -- Archive Statutory Element Information in NL CALCULATIONS Context
6605:
6606: pay_nl_payslip_archive.archive_payslip_element_info (
6614: , p_assignment_id => csr_rec.assignment_id
6615: , p_effective_date => csr_rec.effective_date
6616: , p_child_count =>l_child_count);
6617:
6618: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||l_iterative_flag,1700);
6619: --
6620: -- Archive User Balances
6621: --
6622: FOR l_index IN 1 .. g_user_balance_table.count
6620: -- Archive User Balances
6621: --
6622: FOR l_index IN 1 .. g_user_balance_table.count
6623: LOOP
6624: --hr_utility.set_location('Inside Archive Code balance_name'||g_user_balance_table(l_index).balance_name,1800);
6625: --hr_utility.set_location('Inside Archive Code database_item_suffix'||g_user_balance_table(l_index).database_item_suffix,1800);
6626: --hr_utility.set_location('Inside Archive Code defined_balance_id'||g_user_balance_table(l_index).defined_balance_id,1800);
6627: --hr_utility.set_location('Inside Archive Code si_type'||g_user_balance_table(l_index).si_type,1800);
6628: --hr_utility.set_location('Inside Archive Code l_index'||l_index,1800);
6621: --
6622: FOR l_index IN 1 .. g_user_balance_table.count
6623: LOOP
6624: --hr_utility.set_location('Inside Archive Code balance_name'||g_user_balance_table(l_index).balance_name,1800);
6625: --hr_utility.set_location('Inside Archive Code database_item_suffix'||g_user_balance_table(l_index).database_item_suffix,1800);
6626: --hr_utility.set_location('Inside Archive Code defined_balance_id'||g_user_balance_table(l_index).defined_balance_id,1800);
6627: --hr_utility.set_location('Inside Archive Code si_type'||g_user_balance_table(l_index).si_type,1800);
6628: --hr_utility.set_location('Inside Archive Code l_index'||l_index,1800);
6629: --hr_utility.set_location('Inside Archive Code g_user_balance_table.count '||g_user_balance_table.count ,1800);
6622: FOR l_index IN 1 .. g_user_balance_table.count
6623: LOOP
6624: --hr_utility.set_location('Inside Archive Code balance_name'||g_user_balance_table(l_index).balance_name,1800);
6625: --hr_utility.set_location('Inside Archive Code database_item_suffix'||g_user_balance_table(l_index).database_item_suffix,1800);
6626: --hr_utility.set_location('Inside Archive Code defined_balance_id'||g_user_balance_table(l_index).defined_balance_id,1800);
6627: --hr_utility.set_location('Inside Archive Code si_type'||g_user_balance_table(l_index).si_type,1800);
6628: --hr_utility.set_location('Inside Archive Code l_index'||l_index,1800);
6629: --hr_utility.set_location('Inside Archive Code g_user_balance_table.count '||g_user_balance_table.count ,1800);
6630: --hr_utility.set_location('Inside Archive Code master_assignment_action_id'||csr_rec.master_assignment_action_id,1800);
6623: LOOP
6624: --hr_utility.set_location('Inside Archive Code balance_name'||g_user_balance_table(l_index).balance_name,1800);
6625: --hr_utility.set_location('Inside Archive Code database_item_suffix'||g_user_balance_table(l_index).database_item_suffix,1800);
6626: --hr_utility.set_location('Inside Archive Code defined_balance_id'||g_user_balance_table(l_index).defined_balance_id,1800);
6627: --hr_utility.set_location('Inside Archive Code si_type'||g_user_balance_table(l_index).si_type,1800);
6628: --hr_utility.set_location('Inside Archive Code l_index'||l_index,1800);
6629: --hr_utility.set_location('Inside Archive Code g_user_balance_table.count '||g_user_balance_table.count ,1800);
6630: --hr_utility.set_location('Inside Archive Code master_assignment_action_id'||csr_rec.master_assignment_action_id,1800);
6631: --hr_utility.set_location('Inside Archive Code csr_rec.date_earned '||csr_rec.date_earned ,1800);
6624: --hr_utility.set_location('Inside Archive Code balance_name'||g_user_balance_table(l_index).balance_name,1800);
6625: --hr_utility.set_location('Inside Archive Code database_item_suffix'||g_user_balance_table(l_index).database_item_suffix,1800);
6626: --hr_utility.set_location('Inside Archive Code defined_balance_id'||g_user_balance_table(l_index).defined_balance_id,1800);
6627: --hr_utility.set_location('Inside Archive Code si_type'||g_user_balance_table(l_index).si_type,1800);
6628: --hr_utility.set_location('Inside Archive Code l_index'||l_index,1800);
6629: --hr_utility.set_location('Inside Archive Code g_user_balance_table.count '||g_user_balance_table.count ,1800);
6630: --hr_utility.set_location('Inside Archive Code master_assignment_action_id'||csr_rec.master_assignment_action_id,1800);
6631: --hr_utility.set_location('Inside Archive Code csr_rec.date_earned '||csr_rec.date_earned ,1800);
6632: --hr_utility.set_location('Inside Archive Code csr_rec.effective_date '||csr_rec.effective_date,1800);
6625: --hr_utility.set_location('Inside Archive Code database_item_suffix'||g_user_balance_table(l_index).database_item_suffix,1800);
6626: --hr_utility.set_location('Inside Archive Code defined_balance_id'||g_user_balance_table(l_index).defined_balance_id,1800);
6627: --hr_utility.set_location('Inside Archive Code si_type'||g_user_balance_table(l_index).si_type,1800);
6628: --hr_utility.set_location('Inside Archive Code l_index'||l_index,1800);
6629: --hr_utility.set_location('Inside Archive Code g_user_balance_table.count '||g_user_balance_table.count ,1800);
6630: --hr_utility.set_location('Inside Archive Code master_assignment_action_id'||csr_rec.master_assignment_action_id,1800);
6631: --hr_utility.set_location('Inside Archive Code csr_rec.date_earned '||csr_rec.date_earned ,1800);
6632: --hr_utility.set_location('Inside Archive Code csr_rec.effective_date '||csr_rec.effective_date,1800);
6633: --hr_utility.set_location('Inside Archive Code p_assignment_action_id '||p_assignment_action_id,1800);
6626: --hr_utility.set_location('Inside Archive Code defined_balance_id'||g_user_balance_table(l_index).defined_balance_id,1800);
6627: --hr_utility.set_location('Inside Archive Code si_type'||g_user_balance_table(l_index).si_type,1800);
6628: --hr_utility.set_location('Inside Archive Code l_index'||l_index,1800);
6629: --hr_utility.set_location('Inside Archive Code g_user_balance_table.count '||g_user_balance_table.count ,1800);
6630: --hr_utility.set_location('Inside Archive Code master_assignment_action_id'||csr_rec.master_assignment_action_id,1800);
6631: --hr_utility.set_location('Inside Archive Code csr_rec.date_earned '||csr_rec.date_earned ,1800);
6632: --hr_utility.set_location('Inside Archive Code csr_rec.effective_date '||csr_rec.effective_date,1800);
6633: --hr_utility.set_location('Inside Archive Code p_assignment_action_id '||p_assignment_action_id,1800);
6634: --hr_utility.set_location('Inside Archive Code l_record_count '||l_record_count,1800);
6627: --hr_utility.set_location('Inside Archive Code si_type'||g_user_balance_table(l_index).si_type,1800);
6628: --hr_utility.set_location('Inside Archive Code l_index'||l_index,1800);
6629: --hr_utility.set_location('Inside Archive Code g_user_balance_table.count '||g_user_balance_table.count ,1800);
6630: --hr_utility.set_location('Inside Archive Code master_assignment_action_id'||csr_rec.master_assignment_action_id,1800);
6631: --hr_utility.set_location('Inside Archive Code csr_rec.date_earned '||csr_rec.date_earned ,1800);
6632: --hr_utility.set_location('Inside Archive Code csr_rec.effective_date '||csr_rec.effective_date,1800);
6633: --hr_utility.set_location('Inside Archive Code p_assignment_action_id '||p_assignment_action_id,1800);
6634: --hr_utility.set_location('Inside Archive Code l_record_count '||l_record_count,1800);
6635: --hr_utility.set_location('Inside Archive Code csr_rec.assignment_id '||csr_rec.assignment_id,1800);
6628: --hr_utility.set_location('Inside Archive Code l_index'||l_index,1800);
6629: --hr_utility.set_location('Inside Archive Code g_user_balance_table.count '||g_user_balance_table.count ,1800);
6630: --hr_utility.set_location('Inside Archive Code master_assignment_action_id'||csr_rec.master_assignment_action_id,1800);
6631: --hr_utility.set_location('Inside Archive Code csr_rec.date_earned '||csr_rec.date_earned ,1800);
6632: --hr_utility.set_location('Inside Archive Code csr_rec.effective_date '||csr_rec.effective_date,1800);
6633: --hr_utility.set_location('Inside Archive Code p_assignment_action_id '||p_assignment_action_id,1800);
6634: --hr_utility.set_location('Inside Archive Code l_record_count '||l_record_count,1800);
6635: --hr_utility.set_location('Inside Archive Code csr_rec.assignment_id '||csr_rec.assignment_id,1800);
6636:
6629: --hr_utility.set_location('Inside Archive Code g_user_balance_table.count '||g_user_balance_table.count ,1800);
6630: --hr_utility.set_location('Inside Archive Code master_assignment_action_id'||csr_rec.master_assignment_action_id,1800);
6631: --hr_utility.set_location('Inside Archive Code csr_rec.date_earned '||csr_rec.date_earned ,1800);
6632: --hr_utility.set_location('Inside Archive Code csr_rec.effective_date '||csr_rec.effective_date,1800);
6633: --hr_utility.set_location('Inside Archive Code p_assignment_action_id '||p_assignment_action_id,1800);
6634: --hr_utility.set_location('Inside Archive Code l_record_count '||l_record_count,1800);
6635: --hr_utility.set_location('Inside Archive Code csr_rec.assignment_id '||csr_rec.assignment_id,1800);
6636:
6637: BEGIN
6630: --hr_utility.set_location('Inside Archive Code master_assignment_action_id'||csr_rec.master_assignment_action_id,1800);
6631: --hr_utility.set_location('Inside Archive Code csr_rec.date_earned '||csr_rec.date_earned ,1800);
6632: --hr_utility.set_location('Inside Archive Code csr_rec.effective_date '||csr_rec.effective_date,1800);
6633: --hr_utility.set_location('Inside Archive Code p_assignment_action_id '||p_assignment_action_id,1800);
6634: --hr_utility.set_location('Inside Archive Code l_record_count '||l_record_count,1800);
6635: --hr_utility.set_location('Inside Archive Code csr_rec.assignment_id '||csr_rec.assignment_id,1800);
6636:
6637: BEGIN
6638: pay_nl_payslip_archive.process_balance (
6631: --hr_utility.set_location('Inside Archive Code csr_rec.date_earned '||csr_rec.date_earned ,1800);
6632: --hr_utility.set_location('Inside Archive Code csr_rec.effective_date '||csr_rec.effective_date,1800);
6633: --hr_utility.set_location('Inside Archive Code p_assignment_action_id '||p_assignment_action_id,1800);
6634: --hr_utility.set_location('Inside Archive Code l_record_count '||l_record_count,1800);
6635: --hr_utility.set_location('Inside Archive Code csr_rec.assignment_id '||csr_rec.assignment_id,1800);
6636:
6637: BEGIN
6638: pay_nl_payslip_archive.process_balance (
6639: p_action_context_id => p_assignment_action_id
6652:
6653:
6654: EXCEPTION
6655: WHEN OTHERS THEN
6656: hr_utility.set_location('Inside Archive Code Exception'||SQLCODE||'sqlerr'||SQLERRM,1800);
6657: raise;
6658: END;
6659: END LOOP;
6660:
6657: raise;
6658: END;
6659: END LOOP;
6660:
6661: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||l_iterative_flag,1900);
6662: --
6663: -- Archive Statutory Balances
6664: --
6665: --hr_utility.set_location('Inside Archive Code l_count'||g_statutory_balance_table.count,2000);
6661: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||l_iterative_flag,1900);
6662: --
6663: -- Archive Statutory Balances
6664: --
6665: --hr_utility.set_location('Inside Archive Code l_count'||g_statutory_balance_table.count,2000);
6666:
6667: FOR l_index IN 1 .. g_statutory_balance_table.count LOOP
6668:
6669: --hr_utility.set_location('Inside Archive Code l_index'||l_index,2001);
6665: --hr_utility.set_location('Inside Archive Code l_count'||g_statutory_balance_table.count,2000);
6666:
6667: FOR l_index IN 1 .. g_statutory_balance_table.count LOOP
6668:
6669: --hr_utility.set_location('Inside Archive Code l_index'||l_index,2001);
6670: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).balance_name,2001);
6671: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).database_item_suffix,2001);
6672: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).defined_balance_id,2001);
6673: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).si_type,2001);
6666:
6667: FOR l_index IN 1 .. g_statutory_balance_table.count LOOP
6668:
6669: --hr_utility.set_location('Inside Archive Code l_index'||l_index,2001);
6670: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).balance_name,2001);
6671: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).database_item_suffix,2001);
6672: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).defined_balance_id,2001);
6673: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).si_type,2001);
6674: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||l_record_count,2001);
6667: FOR l_index IN 1 .. g_statutory_balance_table.count LOOP
6668:
6669: --hr_utility.set_location('Inside Archive Code l_index'||l_index,2001);
6670: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).balance_name,2001);
6671: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).database_item_suffix,2001);
6672: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).defined_balance_id,2001);
6673: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).si_type,2001);
6674: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||l_record_count,2001);
6675:
6668:
6669: --hr_utility.set_location('Inside Archive Code l_index'||l_index,2001);
6670: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).balance_name,2001);
6671: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).database_item_suffix,2001);
6672: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).defined_balance_id,2001);
6673: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).si_type,2001);
6674: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||l_record_count,2001);
6675:
6676: pay_nl_payslip_archive.process_balance (
6669: --hr_utility.set_location('Inside Archive Code l_index'||l_index,2001);
6670: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).balance_name,2001);
6671: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).database_item_suffix,2001);
6672: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).defined_balance_id,2001);
6673: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).si_type,2001);
6674: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||l_record_count,2001);
6675:
6676: pay_nl_payslip_archive.process_balance (
6677: p_action_context_id => p_assignment_action_id
6670: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).balance_name,2001);
6671: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).database_item_suffix,2001);
6672: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).defined_balance_id,2001);
6673: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).si_type,2001);
6674: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||l_record_count,2001);
6675:
6676: pay_nl_payslip_archive.process_balance (
6677: p_action_context_id => p_assignment_action_id
6678: ,p_assignment_id => csr_rec.assignment_id
6688: g_statutory_balance_table(l_index).si_type
6689: ,p_record_count => l_record_count);
6690: END LOOP;
6691:
6692: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||l_iterative_flag,2100);
6693: --
6694: -- Archive Payslip Balances(displayed in payments deductions
6695: -- section) in NL CALCULATIONS Context
6696: --
6693: --
6694: -- Archive Payslip Balances(displayed in payments deductions
6695: -- section) in NL CALCULATIONS Context
6696: --
6697: --hr_utility.set_location('Inside Archive Code p_assignment_action_id'||p_assignment_action_id,2100);
6698: --hr_utility.set_location('Inside Archive Code csr_rec.master_assignment_action_id'||csr_rec.master_assignment_action_id,2100);
6699: --hr_utility.set_location('Inside Archive Code csr_rec.date_earned'||csr_rec.date_earned,2100);
6700: --hr_utility.set_location('Inside Archive Code l_record_count'||l_record_count,2100);
6701: IF l_nl_emp_archived = 0 THEN
6694: -- Archive Payslip Balances(displayed in payments deductions
6695: -- section) in NL CALCULATIONS Context
6696: --
6697: --hr_utility.set_location('Inside Archive Code p_assignment_action_id'||p_assignment_action_id,2100);
6698: --hr_utility.set_location('Inside Archive Code csr_rec.master_assignment_action_id'||csr_rec.master_assignment_action_id,2100);
6699: --hr_utility.set_location('Inside Archive Code csr_rec.date_earned'||csr_rec.date_earned,2100);
6700: --hr_utility.set_location('Inside Archive Code l_record_count'||l_record_count,2100);
6701: IF l_nl_emp_archived = 0 THEN
6702: pay_nl_payslip_archive.archive_payslip_balance_info(
6695: -- section) in NL CALCULATIONS Context
6696: --
6697: --hr_utility.set_location('Inside Archive Code p_assignment_action_id'||p_assignment_action_id,2100);
6698: --hr_utility.set_location('Inside Archive Code csr_rec.master_assignment_action_id'||csr_rec.master_assignment_action_id,2100);
6699: --hr_utility.set_location('Inside Archive Code csr_rec.date_earned'||csr_rec.date_earned,2100);
6700: --hr_utility.set_location('Inside Archive Code l_record_count'||l_record_count,2100);
6701: IF l_nl_emp_archived = 0 THEN
6702: pay_nl_payslip_archive.archive_payslip_balance_info(
6703: p_arch_assign_action_id => p_assignment_action_id
6696: --
6697: --hr_utility.set_location('Inside Archive Code p_assignment_action_id'||p_assignment_action_id,2100);
6698: --hr_utility.set_location('Inside Archive Code csr_rec.master_assignment_action_id'||csr_rec.master_assignment_action_id,2100);
6699: --hr_utility.set_location('Inside Archive Code csr_rec.date_earned'||csr_rec.date_earned,2100);
6700: --hr_utility.set_location('Inside Archive Code l_record_count'||l_record_count,2100);
6701: IF l_nl_emp_archived = 0 THEN
6702: pay_nl_payslip_archive.archive_payslip_balance_info(
6703: p_arch_assign_action_id => p_assignment_action_id
6704: , p_run_assign_action_id =>
6710: ,p_effective_date =>csr_rec.effective_date);
6711: END IF;
6712: l_nl_emp_archived := 1;
6713:
6714: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||l_iterative_flag,2200);
6715: --
6716: END IF;
6717: l_record_count := l_record_count + 1;
6718: l_archive_stat := 1;
6721: close csr_assignment_actions;
6722:
6723:
6724:
6725: --hr_utility.set_location('Leaving Archive code',2300);
6726: --
6727: END ARCHIVE_CODE;
6728:
6729: END PAY_NL_PAYSLIP_ARCHIVE;