2: /* $Header: pynopaccr.pkb 120.5.12000000.3 2007/07/05 10:07:34 kseth noship $ */
3:
4: --Global parameters
5: g_package CONSTANT varchar2(33) := 'PAY_NO_PACCR_PKG.';
6: g_debug BOOLEAN := hr_utility.debug_enabled;
7: g_err_num NUMBER;
8:
9:
10:
21: l_delimiter VARCHAR2(1):=' ';
22:
23: BEGIN
24: IF g_debug THEN
25: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
26: END IF;
27:
28: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
29:
47: END IF;
48:
49: RETURN l_parameter;
50: IF g_debug THEN
51: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
52: END IF;
53:
54: END GET_PARAMETER;
55:
92: --
93: BEGIN
94:
95: IF g_debug THEN
96: hr_utility.set_location(' Entering procedure '||l_proc,10);
97: END IF;
98:
99: OPEN csr_parameter_info (p_payroll_action_id);
100:
112: ,p_business_group_id;
113: CLOSE csr_parameter_info;
114: --
115: IF g_debug THEN
116: hr_utility.set_location(' Leaving procedure '||l_proc,20);
117: END IF;
118: END GET_ALL_PARAMETERS;
119:
120: --------------------------------------------------------------------------------------
208:
209: BEGIN
210:
211: IF g_debug THEN
212: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);
213: END IF;
214:
215:
216: -- The sql string to return
319: END IF;
320: END IF;
321: --
322: IF g_debug THEN
323: hr_utility.set_location(' Leaving Procedure RANGE_CODE',20);
324: END IF;
325: --
326: END RANGE_CODE;
327: --------------------------------------------------------------------------------------
520:
521:
522:
523: BEGIN
524: --Hr_utility.trace_on(null,'PRR');
525: Hr_utility.trace('#-ASSIGNMENT_ACTION_CODE ');
526: IF g_debug THEN
527: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);
528: END IF;
521:
522:
523: BEGIN
524: --Hr_utility.trace_on(null,'PRR');
525: Hr_utility.trace('#-ASSIGNMENT_ACTION_CODE ');
526: IF g_debug THEN
527: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);
528: END IF;
529: Hr_utility.trace('#-Before fetching csr header details ');
523: BEGIN
524: --Hr_utility.trace_on(null,'PRR');
525: Hr_utility.trace('#-ASSIGNMENT_ACTION_CODE ');
526: IF g_debug THEN
527: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);
528: END IF;
529: Hr_utility.trace('#-Before fetching csr header details ');
530: Hr_utility.trace('#-p_payroll_action_id '|| p_payroll_action_id);
531: -- Fetch Header details
525: Hr_utility.trace('#-ASSIGNMENT_ACTION_CODE ');
526: IF g_debug THEN
527: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);
528: END IF;
529: Hr_utility.trace('#-Before fetching csr header details ');
530: Hr_utility.trace('#-p_payroll_action_id '|| p_payroll_action_id);
531: -- Fetch Header details
532: OPEN csr_get_hdr_info(p_payroll_action_id);
533: FETCH csr_get_hdr_info INTO rec_hdr_info;
526: IF g_debug THEN
527: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);
528: END IF;
529: Hr_utility.trace('#-Before fetching csr header details ');
530: Hr_utility.trace('#-p_payroll_action_id '|| p_payroll_action_id);
531: -- Fetch Header details
532: OPEN csr_get_hdr_info(p_payroll_action_id);
533: FETCH csr_get_hdr_info INTO rec_hdr_info;
534: CLOSE csr_get_hdr_info;
531: -- Fetch Header details
532: OPEN csr_get_hdr_info(p_payroll_action_id);
533: FETCH csr_get_hdr_info INTO rec_hdr_info;
534: CLOSE csr_get_hdr_info;
535: Hr_utility.trace('#-rec_hdr_info.effective_date '|| rec_hdr_info.effective_date);
536: l_effective_date := rec_hdr_info.effective_date;
537: Hr_utility.trace('#-l_effective_date '|| l_effective_date);
538: --
539: Hr_utility.trace('#-rec_hdr_info.business_group_id '|| rec_hdr_info.business_group_id);
533: FETCH csr_get_hdr_info INTO rec_hdr_info;
534: CLOSE csr_get_hdr_info;
535: Hr_utility.trace('#-rec_hdr_info.effective_date '|| rec_hdr_info.effective_date);
536: l_effective_date := rec_hdr_info.effective_date;
537: Hr_utility.trace('#-l_effective_date '|| l_effective_date);
538: --
539: Hr_utility.trace('#-rec_hdr_info.business_group_id '|| rec_hdr_info.business_group_id);
540: l_bg_id := rec_hdr_info.business_group_id;
541: Hr_utility.trace('#-l_bg_id '|| l_bg_id);
535: Hr_utility.trace('#-rec_hdr_info.effective_date '|| rec_hdr_info.effective_date);
536: l_effective_date := rec_hdr_info.effective_date;
537: Hr_utility.trace('#-l_effective_date '|| l_effective_date);
538: --
539: Hr_utility.trace('#-rec_hdr_info.business_group_id '|| rec_hdr_info.business_group_id);
540: l_bg_id := rec_hdr_info.business_group_id;
541: Hr_utility.trace('#-l_bg_id '|| l_bg_id);
542: --
543: Hr_utility.trace('#-rec_hdr_info.tax_unit_id '|| rec_hdr_info.tax_unit_id);
537: Hr_utility.trace('#-l_effective_date '|| l_effective_date);
538: --
539: Hr_utility.trace('#-rec_hdr_info.business_group_id '|| rec_hdr_info.business_group_id);
540: l_bg_id := rec_hdr_info.business_group_id;
541: Hr_utility.trace('#-l_bg_id '|| l_bg_id);
542: --
543: Hr_utility.trace('#-rec_hdr_info.tax_unit_id '|| rec_hdr_info.tax_unit_id);
544: l_le_id := rec_hdr_info.tax_unit_id;
545: Hr_utility.trace('#-l_le_id '|| l_le_id);
539: Hr_utility.trace('#-rec_hdr_info.business_group_id '|| rec_hdr_info.business_group_id);
540: l_bg_id := rec_hdr_info.business_group_id;
541: Hr_utility.trace('#-l_bg_id '|| l_bg_id);
542: --
543: Hr_utility.trace('#-rec_hdr_info.tax_unit_id '|| rec_hdr_info.tax_unit_id);
544: l_le_id := rec_hdr_info.tax_unit_id;
545: Hr_utility.trace('#-l_le_id '|| l_le_id);
546: --
547: Hr_utility.trace('#-rec_hdr_info.from_date '|| rec_hdr_info.from_date);
541: Hr_utility.trace('#-l_bg_id '|| l_bg_id);
542: --
543: Hr_utility.trace('#-rec_hdr_info.tax_unit_id '|| rec_hdr_info.tax_unit_id);
544: l_le_id := rec_hdr_info.tax_unit_id;
545: Hr_utility.trace('#-l_le_id '|| l_le_id);
546: --
547: Hr_utility.trace('#-rec_hdr_info.from_date '|| rec_hdr_info.from_date);
548: l_date_from := rec_hdr_info.from_date;
549: Hr_utility.trace('#-l_date_from '|| l_date_from);
543: Hr_utility.trace('#-rec_hdr_info.tax_unit_id '|| rec_hdr_info.tax_unit_id);
544: l_le_id := rec_hdr_info.tax_unit_id;
545: Hr_utility.trace('#-l_le_id '|| l_le_id);
546: --
547: Hr_utility.trace('#-rec_hdr_info.from_date '|| rec_hdr_info.from_date);
548: l_date_from := rec_hdr_info.from_date;
549: Hr_utility.trace('#-l_date_from '|| l_date_from);
550: --
551: Hr_utility.trace('#-rec_hdr_info.to_date '|| rec_hdr_info.to_date);
545: Hr_utility.trace('#-l_le_id '|| l_le_id);
546: --
547: Hr_utility.trace('#-rec_hdr_info.from_date '|| rec_hdr_info.from_date);
548: l_date_from := rec_hdr_info.from_date;
549: Hr_utility.trace('#-l_date_from '|| l_date_from);
550: --
551: Hr_utility.trace('#-rec_hdr_info.to_date '|| rec_hdr_info.to_date);
552: l_date_to := rec_hdr_info.to_date;
553: Hr_utility.trace('#-l_date_to '|| l_date_to);
547: Hr_utility.trace('#-rec_hdr_info.from_date '|| rec_hdr_info.from_date);
548: l_date_from := rec_hdr_info.from_date;
549: Hr_utility.trace('#-l_date_from '|| l_date_from);
550: --
551: Hr_utility.trace('#-rec_hdr_info.to_date '|| rec_hdr_info.to_date);
552: l_date_to := rec_hdr_info.to_date;
553: Hr_utility.trace('#-l_date_to '|| l_date_to);
554: --
555: Hr_utility.trace('#-rec_hdr_info.payroll_id '|| rec_hdr_info.payroll_id);
549: Hr_utility.trace('#-l_date_from '|| l_date_from);
550: --
551: Hr_utility.trace('#-rec_hdr_info.to_date '|| rec_hdr_info.to_date);
552: l_date_to := rec_hdr_info.to_date;
553: Hr_utility.trace('#-l_date_to '|| l_date_to);
554: --
555: Hr_utility.trace('#-rec_hdr_info.payroll_id '|| rec_hdr_info.payroll_id);
556: l_payroll_id := rec_hdr_info.payroll_id;
557: Hr_utility.trace('#-l_payroll_id '|| l_payroll_id);
551: Hr_utility.trace('#-rec_hdr_info.to_date '|| rec_hdr_info.to_date);
552: l_date_to := rec_hdr_info.to_date;
553: Hr_utility.trace('#-l_date_to '|| l_date_to);
554: --
555: Hr_utility.trace('#-rec_hdr_info.payroll_id '|| rec_hdr_info.payroll_id);
556: l_payroll_id := rec_hdr_info.payroll_id;
557: Hr_utility.trace('#-l_payroll_id '|| l_payroll_id);
558: --
559: Hr_utility.trace('#-rec_hdr_info.restr_econtr '|| rec_hdr_info.restr_econtr);
553: Hr_utility.trace('#-l_date_to '|| l_date_to);
554: --
555: Hr_utility.trace('#-rec_hdr_info.payroll_id '|| rec_hdr_info.payroll_id);
556: l_payroll_id := rec_hdr_info.payroll_id;
557: Hr_utility.trace('#-l_payroll_id '|| l_payroll_id);
558: --
559: Hr_utility.trace('#-rec_hdr_info.restr_econtr '|| rec_hdr_info.restr_econtr);
560: l_restr_econtr := rec_hdr_info.restr_econtr;
561: Hr_utility.trace('#-l_restr_econtr '|| l_restr_econtr);
555: Hr_utility.trace('#-rec_hdr_info.payroll_id '|| rec_hdr_info.payroll_id);
556: l_payroll_id := rec_hdr_info.payroll_id;
557: Hr_utility.trace('#-l_payroll_id '|| l_payroll_id);
558: --
559: Hr_utility.trace('#-rec_hdr_info.restr_econtr '|| rec_hdr_info.restr_econtr);
560: l_restr_econtr := rec_hdr_info.restr_econtr;
561: Hr_utility.trace('#-l_restr_econtr '|| l_restr_econtr);
562: --
563: Hr_utility.trace('#-rec_hdr_info.cost_seg '|| rec_hdr_info.cost_seg);
557: Hr_utility.trace('#-l_payroll_id '|| l_payroll_id);
558: --
559: Hr_utility.trace('#-rec_hdr_info.restr_econtr '|| rec_hdr_info.restr_econtr);
560: l_restr_econtr := rec_hdr_info.restr_econtr;
561: Hr_utility.trace('#-l_restr_econtr '|| l_restr_econtr);
562: --
563: Hr_utility.trace('#-rec_hdr_info.cost_seg '|| rec_hdr_info.cost_seg);
564: l_cost_seg := rec_hdr_info.cost_seg;
565: Hr_utility.trace('#-l_cost_seg '|| l_cost_seg);
559: Hr_utility.trace('#-rec_hdr_info.restr_econtr '|| rec_hdr_info.restr_econtr);
560: l_restr_econtr := rec_hdr_info.restr_econtr;
561: Hr_utility.trace('#-l_restr_econtr '|| l_restr_econtr);
562: --
563: Hr_utility.trace('#-rec_hdr_info.cost_seg '|| rec_hdr_info.cost_seg);
564: l_cost_seg := rec_hdr_info.cost_seg;
565: Hr_utility.trace('#-l_cost_seg '|| l_cost_seg);
566: --
567: Hr_utility.trace('#-rec_hdr_info.ele_type_id '|| rec_hdr_info.ele_type_id);
561: Hr_utility.trace('#-l_restr_econtr '|| l_restr_econtr);
562: --
563: Hr_utility.trace('#-rec_hdr_info.cost_seg '|| rec_hdr_info.cost_seg);
564: l_cost_seg := rec_hdr_info.cost_seg;
565: Hr_utility.trace('#-l_cost_seg '|| l_cost_seg);
566: --
567: Hr_utility.trace('#-rec_hdr_info.ele_type_id '|| rec_hdr_info.ele_type_id);
568: l_ele_type_id := rec_hdr_info.ele_type_id;
569: Hr_utility.trace('#-l_ele_type_id '|| l_ele_type_id);
563: Hr_utility.trace('#-rec_hdr_info.cost_seg '|| rec_hdr_info.cost_seg);
564: l_cost_seg := rec_hdr_info.cost_seg;
565: Hr_utility.trace('#-l_cost_seg '|| l_cost_seg);
566: --
567: Hr_utility.trace('#-rec_hdr_info.ele_type_id '|| rec_hdr_info.ele_type_id);
568: l_ele_type_id := rec_hdr_info.ele_type_id;
569: Hr_utility.trace('#-l_ele_type_id '|| l_ele_type_id);
570: --
571: Hr_utility.trace('#-rec_hdr_info.eoy_code '|| rec_hdr_info.eoy_code);
565: Hr_utility.trace('#-l_cost_seg '|| l_cost_seg);
566: --
567: Hr_utility.trace('#-rec_hdr_info.ele_type_id '|| rec_hdr_info.ele_type_id);
568: l_ele_type_id := rec_hdr_info.ele_type_id;
569: Hr_utility.trace('#-l_ele_type_id '|| l_ele_type_id);
570: --
571: Hr_utility.trace('#-rec_hdr_info.eoy_code '|| rec_hdr_info.eoy_code);
572: l_eoy_code := rec_hdr_info.eoy_code;
573: Hr_utility.trace('#-l_eoy_code '|| l_eoy_code);
567: Hr_utility.trace('#-rec_hdr_info.ele_type_id '|| rec_hdr_info.ele_type_id);
568: l_ele_type_id := rec_hdr_info.ele_type_id;
569: Hr_utility.trace('#-l_ele_type_id '|| l_ele_type_id);
570: --
571: Hr_utility.trace('#-rec_hdr_info.eoy_code '|| rec_hdr_info.eoy_code);
572: l_eoy_code := rec_hdr_info.eoy_code;
573: Hr_utility.trace('#-l_eoy_code '|| l_eoy_code);
574: --
575: Hr_utility.trace('#-Before fetching csr csr_get_lu_le ');
569: Hr_utility.trace('#-l_ele_type_id '|| l_ele_type_id);
570: --
571: Hr_utility.trace('#-rec_hdr_info.eoy_code '|| rec_hdr_info.eoy_code);
572: l_eoy_code := rec_hdr_info.eoy_code;
573: Hr_utility.trace('#-l_eoy_code '|| l_eoy_code);
574: --
575: Hr_utility.trace('#-Before fetching csr csr_get_lu_le ');
576: Hr_utility.trace('#-with l_le_id '||l_le_id);
577: Hr_utility.trace('#-with l_bg_id '||l_bg_id);
571: Hr_utility.trace('#-rec_hdr_info.eoy_code '|| rec_hdr_info.eoy_code);
572: l_eoy_code := rec_hdr_info.eoy_code;
573: Hr_utility.trace('#-l_eoy_code '|| l_eoy_code);
574: --
575: Hr_utility.trace('#-Before fetching csr csr_get_lu_le ');
576: Hr_utility.trace('#-with l_le_id '||l_le_id);
577: Hr_utility.trace('#-with l_bg_id '||l_bg_id);
578: --
579: /* To fetch all Local Units belonging to the Legal Employer */
572: l_eoy_code := rec_hdr_info.eoy_code;
573: Hr_utility.trace('#-l_eoy_code '|| l_eoy_code);
574: --
575: Hr_utility.trace('#-Before fetching csr csr_get_lu_le ');
576: Hr_utility.trace('#-with l_le_id '||l_le_id);
577: Hr_utility.trace('#-with l_bg_id '||l_bg_id);
578: --
579: /* To fetch all Local Units belonging to the Legal Employer */
580: FOR rec_get_lu_le IN csr_get_lu_le(l_le_id,l_bg_id)
573: Hr_utility.trace('#-l_eoy_code '|| l_eoy_code);
574: --
575: Hr_utility.trace('#-Before fetching csr csr_get_lu_le ');
576: Hr_utility.trace('#-with l_le_id '||l_le_id);
577: Hr_utility.trace('#-with l_bg_id '||l_bg_id);
578: --
579: /* To fetch all Local Units belonging to the Legal Employer */
580: FOR rec_get_lu_le IN csr_get_lu_le(l_le_id,l_bg_id)
581:
580: FOR rec_get_lu_le IN csr_get_lu_le(l_le_id,l_bg_id)
581:
582: -- Fetch all Local Units belonging to the Legal Employer
583: LOOP
584: Hr_utility.trace('#-Rec found in csr_get_lu_le');
585: Hr_utility.trace('#-rec_get_lu_le.lu_id '||rec_get_lu_le.lu_id);
586: l_local_unit_id := rec_get_lu_le.lu_id;
587: Hr_utility.trace('#-l_local_unit_id '||l_local_unit_id);
588:
581:
582: -- Fetch all Local Units belonging to the Legal Employer
583: LOOP
584: Hr_utility.trace('#-Rec found in csr_get_lu_le');
585: Hr_utility.trace('#-rec_get_lu_le.lu_id '||rec_get_lu_le.lu_id);
586: l_local_unit_id := rec_get_lu_le.lu_id;
587: Hr_utility.trace('#-l_local_unit_id '||l_local_unit_id);
588:
589: -- Fetch Assignment's details for Detailed Report
583: LOOP
584: Hr_utility.trace('#-Rec found in csr_get_lu_le');
585: Hr_utility.trace('#-rec_get_lu_le.lu_id '||rec_get_lu_le.lu_id);
586: l_local_unit_id := rec_get_lu_le.lu_id;
587: Hr_utility.trace('#-l_local_unit_id '||l_local_unit_id);
588:
589: -- Fetch Assignment's details for Detailed Report
590: Hr_utility.trace('#-Before fetching csr csr_assignments ');
591: Hr_utility.trace('#-with p_pay roll_action_id '||p_payroll_action_id);
586: l_local_unit_id := rec_get_lu_le.lu_id;
587: Hr_utility.trace('#-l_local_unit_id '||l_local_unit_id);
588:
589: -- Fetch Assignment's details for Detailed Report
590: Hr_utility.trace('#-Before fetching csr csr_assignments ');
591: Hr_utility.trace('#-with p_pay roll_action_id '||p_payroll_action_id);
592: Hr_utility.trace('#-with l_payroll_id '||l_payroll_id);
593: Hr_utility.trace('#-with p_start_person '||p_start_person);
594: Hr_utility.trace('#-with p_end_person '||p_end_person);
587: Hr_utility.trace('#-l_local_unit_id '||l_local_unit_id);
588:
589: -- Fetch Assignment's details for Detailed Report
590: Hr_utility.trace('#-Before fetching csr csr_assignments ');
591: Hr_utility.trace('#-with p_pay roll_action_id '||p_payroll_action_id);
592: Hr_utility.trace('#-with l_payroll_id '||l_payroll_id);
593: Hr_utility.trace('#-with p_start_person '||p_start_person);
594: Hr_utility.trace('#-with p_end_person '||p_end_person);
595: Hr_utility.trace('#-with l_restr_econtr '||l_restr_econtr);
588:
589: -- Fetch Assignment's details for Detailed Report
590: Hr_utility.trace('#-Before fetching csr csr_assignments ');
591: Hr_utility.trace('#-with p_pay roll_action_id '||p_payroll_action_id);
592: Hr_utility.trace('#-with l_payroll_id '||l_payroll_id);
593: Hr_utility.trace('#-with p_start_person '||p_start_person);
594: Hr_utility.trace('#-with p_end_person '||p_end_person);
595: Hr_utility.trace('#-with l_restr_econtr '||l_restr_econtr);
596: Hr_utility.trace('#-with l_cost_seg '||l_cost_seg);
589: -- Fetch Assignment's details for Detailed Report
590: Hr_utility.trace('#-Before fetching csr csr_assignments ');
591: Hr_utility.trace('#-with p_pay roll_action_id '||p_payroll_action_id);
592: Hr_utility.trace('#-with l_payroll_id '||l_payroll_id);
593: Hr_utility.trace('#-with p_start_person '||p_start_person);
594: Hr_utility.trace('#-with p_end_person '||p_end_person);
595: Hr_utility.trace('#-with l_restr_econtr '||l_restr_econtr);
596: Hr_utility.trace('#-with l_cost_seg '||l_cost_seg);
597: Hr_utility.trace('#-with l_ele_type_id '||l_ele_type_id);
590: Hr_utility.trace('#-Before fetching csr csr_assignments ');
591: Hr_utility.trace('#-with p_pay roll_action_id '||p_payroll_action_id);
592: Hr_utility.trace('#-with l_payroll_id '||l_payroll_id);
593: Hr_utility.trace('#-with p_start_person '||p_start_person);
594: Hr_utility.trace('#-with p_end_person '||p_end_person);
595: Hr_utility.trace('#-with l_restr_econtr '||l_restr_econtr);
596: Hr_utility.trace('#-with l_cost_seg '||l_cost_seg);
597: Hr_utility.trace('#-with l_ele_type_id '||l_ele_type_id);
598: Hr_utility.trace('#-with l_eoy_code '||l_eoy_code);
591: Hr_utility.trace('#-with p_pay roll_action_id '||p_payroll_action_id);
592: Hr_utility.trace('#-with l_payroll_id '||l_payroll_id);
593: Hr_utility.trace('#-with p_start_person '||p_start_person);
594: Hr_utility.trace('#-with p_end_person '||p_end_person);
595: Hr_utility.trace('#-with l_restr_econtr '||l_restr_econtr);
596: Hr_utility.trace('#-with l_cost_seg '||l_cost_seg);
597: Hr_utility.trace('#-with l_ele_type_id '||l_ele_type_id);
598: Hr_utility.trace('#-with l_eoy_code '||l_eoy_code);
599: Hr_utility.trace('#-with l_bg_id '||l_bg_id);
592: Hr_utility.trace('#-with l_payroll_id '||l_payroll_id);
593: Hr_utility.trace('#-with p_start_person '||p_start_person);
594: Hr_utility.trace('#-with p_end_person '||p_end_person);
595: Hr_utility.trace('#-with l_restr_econtr '||l_restr_econtr);
596: Hr_utility.trace('#-with l_cost_seg '||l_cost_seg);
597: Hr_utility.trace('#-with l_ele_type_id '||l_ele_type_id);
598: Hr_utility.trace('#-with l_eoy_code '||l_eoy_code);
599: Hr_utility.trace('#-with l_bg_id '||l_bg_id);
600: Hr_utility.trace('#-with l_date_from '||l_date_from);
593: Hr_utility.trace('#-with p_start_person '||p_start_person);
594: Hr_utility.trace('#-with p_end_person '||p_end_person);
595: Hr_utility.trace('#-with l_restr_econtr '||l_restr_econtr);
596: Hr_utility.trace('#-with l_cost_seg '||l_cost_seg);
597: Hr_utility.trace('#-with l_ele_type_id '||l_ele_type_id);
598: Hr_utility.trace('#-with l_eoy_code '||l_eoy_code);
599: Hr_utility.trace('#-with l_bg_id '||l_bg_id);
600: Hr_utility.trace('#-with l_date_from '||l_date_from);
601: Hr_utility.trace('#-with l_date_to '||l_date_to);
594: Hr_utility.trace('#-with p_end_person '||p_end_person);
595: Hr_utility.trace('#-with l_restr_econtr '||l_restr_econtr);
596: Hr_utility.trace('#-with l_cost_seg '||l_cost_seg);
597: Hr_utility.trace('#-with l_ele_type_id '||l_ele_type_id);
598: Hr_utility.trace('#-with l_eoy_code '||l_eoy_code);
599: Hr_utility.trace('#-with l_bg_id '||l_bg_id);
600: Hr_utility.trace('#-with l_date_from '||l_date_from);
601: Hr_utility.trace('#-with l_date_to '||l_date_to);
602: Hr_utility.trace('#-with l_local_unit_id '||l_local_unit_id);
595: Hr_utility.trace('#-with l_restr_econtr '||l_restr_econtr);
596: Hr_utility.trace('#-with l_cost_seg '||l_cost_seg);
597: Hr_utility.trace('#-with l_ele_type_id '||l_ele_type_id);
598: Hr_utility.trace('#-with l_eoy_code '||l_eoy_code);
599: Hr_utility.trace('#-with l_bg_id '||l_bg_id);
600: Hr_utility.trace('#-with l_date_from '||l_date_from);
601: Hr_utility.trace('#-with l_date_to '||l_date_to);
602: Hr_utility.trace('#-with l_local_unit_id '||l_local_unit_id);
603: Hr_utility.trace('#-with l_effective_date '||l_effective_date);
596: Hr_utility.trace('#-with l_cost_seg '||l_cost_seg);
597: Hr_utility.trace('#-with l_ele_type_id '||l_ele_type_id);
598: Hr_utility.trace('#-with l_eoy_code '||l_eoy_code);
599: Hr_utility.trace('#-with l_bg_id '||l_bg_id);
600: Hr_utility.trace('#-with l_date_from '||l_date_from);
601: Hr_utility.trace('#-with l_date_to '||l_date_to);
602: Hr_utility.trace('#-with l_local_unit_id '||l_local_unit_id);
603: Hr_utility.trace('#-with l_effective_date '||l_effective_date);
604:
597: Hr_utility.trace('#-with l_ele_type_id '||l_ele_type_id);
598: Hr_utility.trace('#-with l_eoy_code '||l_eoy_code);
599: Hr_utility.trace('#-with l_bg_id '||l_bg_id);
600: Hr_utility.trace('#-with l_date_from '||l_date_from);
601: Hr_utility.trace('#-with l_date_to '||l_date_to);
602: Hr_utility.trace('#-with l_local_unit_id '||l_local_unit_id);
603: Hr_utility.trace('#-with l_effective_date '||l_effective_date);
604:
605: FOR csr_rec IN csr_assignments( p_payroll_action_id
598: Hr_utility.trace('#-with l_eoy_code '||l_eoy_code);
599: Hr_utility.trace('#-with l_bg_id '||l_bg_id);
600: Hr_utility.trace('#-with l_date_from '||l_date_from);
601: Hr_utility.trace('#-with l_date_to '||l_date_to);
602: Hr_utility.trace('#-with l_local_unit_id '||l_local_unit_id);
603: Hr_utility.trace('#-with l_effective_date '||l_effective_date);
604:
605: FOR csr_rec IN csr_assignments( p_payroll_action_id
606: ,l_payroll_id
599: Hr_utility.trace('#-with l_bg_id '||l_bg_id);
600: Hr_utility.trace('#-with l_date_from '||l_date_from);
601: Hr_utility.trace('#-with l_date_to '||l_date_to);
602: Hr_utility.trace('#-with l_local_unit_id '||l_local_unit_id);
603: Hr_utility.trace('#-with l_effective_date '||l_effective_date);
604:
605: FOR csr_rec IN csr_assignments( p_payroll_action_id
606: ,l_payroll_id
607: ,p_start_person
615: ,l_date_to
616: ,l_local_unit_id
617: ,l_effective_date )
618: LOOP
619: Hr_utility.trace('#-record found in csr csr_assignments ');
620: Hr_utility.trace('#-p_pay roll_action_id '||p_payroll_action_id);
621: Hr_utility.trace('#-l_payroll_id '||l_payroll_id);
622: Hr_utility.trace('#-p_start_person '||p_start_person);
623: Hr_utility.trace('#-p_end_person '||p_end_person);
616: ,l_local_unit_id
617: ,l_effective_date )
618: LOOP
619: Hr_utility.trace('#-record found in csr csr_assignments ');
620: Hr_utility.trace('#-p_pay roll_action_id '||p_payroll_action_id);
621: Hr_utility.trace('#-l_payroll_id '||l_payroll_id);
622: Hr_utility.trace('#-p_start_person '||p_start_person);
623: Hr_utility.trace('#-p_end_person '||p_end_person);
624: Hr_utility.trace('#-l_restr_econtr '||l_restr_econtr);
617: ,l_effective_date )
618: LOOP
619: Hr_utility.trace('#-record found in csr csr_assignments ');
620: Hr_utility.trace('#-p_pay roll_action_id '||p_payroll_action_id);
621: Hr_utility.trace('#-l_payroll_id '||l_payroll_id);
622: Hr_utility.trace('#-p_start_person '||p_start_person);
623: Hr_utility.trace('#-p_end_person '||p_end_person);
624: Hr_utility.trace('#-l_restr_econtr '||l_restr_econtr);
625: Hr_utility.trace('#-l_cost_seg '||l_cost_seg);
618: LOOP
619: Hr_utility.trace('#-record found in csr csr_assignments ');
620: Hr_utility.trace('#-p_pay roll_action_id '||p_payroll_action_id);
621: Hr_utility.trace('#-l_payroll_id '||l_payroll_id);
622: Hr_utility.trace('#-p_start_person '||p_start_person);
623: Hr_utility.trace('#-p_end_person '||p_end_person);
624: Hr_utility.trace('#-l_restr_econtr '||l_restr_econtr);
625: Hr_utility.trace('#-l_cost_seg '||l_cost_seg);
626: Hr_utility.trace('#-l_ele_type_id '||l_ele_type_id);
619: Hr_utility.trace('#-record found in csr csr_assignments ');
620: Hr_utility.trace('#-p_pay roll_action_id '||p_payroll_action_id);
621: Hr_utility.trace('#-l_payroll_id '||l_payroll_id);
622: Hr_utility.trace('#-p_start_person '||p_start_person);
623: Hr_utility.trace('#-p_end_person '||p_end_person);
624: Hr_utility.trace('#-l_restr_econtr '||l_restr_econtr);
625: Hr_utility.trace('#-l_cost_seg '||l_cost_seg);
626: Hr_utility.trace('#-l_ele_type_id '||l_ele_type_id);
627: Hr_utility.trace('#-l_eoy_code '||l_eoy_code);
620: Hr_utility.trace('#-p_pay roll_action_id '||p_payroll_action_id);
621: Hr_utility.trace('#-l_payroll_id '||l_payroll_id);
622: Hr_utility.trace('#-p_start_person '||p_start_person);
623: Hr_utility.trace('#-p_end_person '||p_end_person);
624: Hr_utility.trace('#-l_restr_econtr '||l_restr_econtr);
625: Hr_utility.trace('#-l_cost_seg '||l_cost_seg);
626: Hr_utility.trace('#-l_ele_type_id '||l_ele_type_id);
627: Hr_utility.trace('#-l_eoy_code '||l_eoy_code);
628: Hr_utility.trace('#-l_bg_id '||l_bg_id);
621: Hr_utility.trace('#-l_payroll_id '||l_payroll_id);
622: Hr_utility.trace('#-p_start_person '||p_start_person);
623: Hr_utility.trace('#-p_end_person '||p_end_person);
624: Hr_utility.trace('#-l_restr_econtr '||l_restr_econtr);
625: Hr_utility.trace('#-l_cost_seg '||l_cost_seg);
626: Hr_utility.trace('#-l_ele_type_id '||l_ele_type_id);
627: Hr_utility.trace('#-l_eoy_code '||l_eoy_code);
628: Hr_utility.trace('#-l_bg_id '||l_bg_id);
629: Hr_utility.trace('#-l_date_from '||l_date_from);
622: Hr_utility.trace('#-p_start_person '||p_start_person);
623: Hr_utility.trace('#-p_end_person '||p_end_person);
624: Hr_utility.trace('#-l_restr_econtr '||l_restr_econtr);
625: Hr_utility.trace('#-l_cost_seg '||l_cost_seg);
626: Hr_utility.trace('#-l_ele_type_id '||l_ele_type_id);
627: Hr_utility.trace('#-l_eoy_code '||l_eoy_code);
628: Hr_utility.trace('#-l_bg_id '||l_bg_id);
629: Hr_utility.trace('#-l_date_from '||l_date_from);
630: Hr_utility.trace('#-l_date_to '||l_date_to);
623: Hr_utility.trace('#-p_end_person '||p_end_person);
624: Hr_utility.trace('#-l_restr_econtr '||l_restr_econtr);
625: Hr_utility.trace('#-l_cost_seg '||l_cost_seg);
626: Hr_utility.trace('#-l_ele_type_id '||l_ele_type_id);
627: Hr_utility.trace('#-l_eoy_code '||l_eoy_code);
628: Hr_utility.trace('#-l_bg_id '||l_bg_id);
629: Hr_utility.trace('#-l_date_from '||l_date_from);
630: Hr_utility.trace('#-l_date_to '||l_date_to);
631: Hr_utility.trace('#-l_local_unit_id '||l_local_unit_id);
624: Hr_utility.trace('#-l_restr_econtr '||l_restr_econtr);
625: Hr_utility.trace('#-l_cost_seg '||l_cost_seg);
626: Hr_utility.trace('#-l_ele_type_id '||l_ele_type_id);
627: Hr_utility.trace('#-l_eoy_code '||l_eoy_code);
628: Hr_utility.trace('#-l_bg_id '||l_bg_id);
629: Hr_utility.trace('#-l_date_from '||l_date_from);
630: Hr_utility.trace('#-l_date_to '||l_date_to);
631: Hr_utility.trace('#-l_local_unit_id '||l_local_unit_id);
632: Hr_utility.trace('#-l_effective_date '||l_effective_date);
625: Hr_utility.trace('#-l_cost_seg '||l_cost_seg);
626: Hr_utility.trace('#-l_ele_type_id '||l_ele_type_id);
627: Hr_utility.trace('#-l_eoy_code '||l_eoy_code);
628: Hr_utility.trace('#-l_bg_id '||l_bg_id);
629: Hr_utility.trace('#-l_date_from '||l_date_from);
630: Hr_utility.trace('#-l_date_to '||l_date_to);
631: Hr_utility.trace('#-l_local_unit_id '||l_local_unit_id);
632: Hr_utility.trace('#-l_effective_date '||l_effective_date);
633:
626: Hr_utility.trace('#-l_ele_type_id '||l_ele_type_id);
627: Hr_utility.trace('#-l_eoy_code '||l_eoy_code);
628: Hr_utility.trace('#-l_bg_id '||l_bg_id);
629: Hr_utility.trace('#-l_date_from '||l_date_from);
630: Hr_utility.trace('#-l_date_to '||l_date_to);
631: Hr_utility.trace('#-l_local_unit_id '||l_local_unit_id);
632: Hr_utility.trace('#-l_effective_date '||l_effective_date);
633:
634: /*Check for Change of Assignment ID to Create New Assignment Action ID
627: Hr_utility.trace('#-l_eoy_code '||l_eoy_code);
628: Hr_utility.trace('#-l_bg_id '||l_bg_id);
629: Hr_utility.trace('#-l_date_from '||l_date_from);
630: Hr_utility.trace('#-l_date_to '||l_date_to);
631: Hr_utility.trace('#-l_local_unit_id '||l_local_unit_id);
632: Hr_utility.trace('#-l_effective_date '||l_effective_date);
633:
634: /*Check for Change of Assignment ID to Create New Assignment Action ID
635: and for Archiving the data */
628: Hr_utility.trace('#-l_bg_id '||l_bg_id);
629: Hr_utility.trace('#-l_date_from '||l_date_from);
630: Hr_utility.trace('#-l_date_to '||l_date_to);
631: Hr_utility.trace('#-l_local_unit_id '||l_local_unit_id);
632: Hr_utility.trace('#-l_effective_date '||l_effective_date);
633:
634: /*Check for Change of Assignment ID to Create New Assignment Action ID
635: and for Archiving the data */
636: Hr_utility.trace('#- get the next seq val');
632: Hr_utility.trace('#-l_effective_date '||l_effective_date);
633:
634: /*Check for Change of Assignment ID to Create New Assignment Action ID
635: and for Archiving the data */
636: Hr_utility.trace('#- get the next seq val');
637: BEGIN
638: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;
639: EXCEPTION
640: WHEN OTHERS THEN
639: EXCEPTION
640: WHEN OTHERS THEN
641: NULL ;
642: END ;
643: Hr_utility.trace('#- l_actid '||l_actid);
644:
645: -- Create the archive assignment action
646: Hr_utility.trace('#- create asg act code');
647: Hr_utility.trace('#- l_actid '||l_actid);
642: END ;
643: Hr_utility.trace('#- l_actid '||l_actid);
644:
645: -- Create the archive assignment action
646: Hr_utility.trace('#- create asg act code');
647: Hr_utility.trace('#- l_actid '||l_actid);
648: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
649: Hr_utility.trace('#- p_payroll_action_id '||p_payroll_action_id);
650: Hr_utility.trace('#- p_chunk '||p_chunk);
643: Hr_utility.trace('#- l_actid '||l_actid);
644:
645: -- Create the archive assignment action
646: Hr_utility.trace('#- create asg act code');
647: Hr_utility.trace('#- l_actid '||l_actid);
648: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
649: Hr_utility.trace('#- p_payroll_action_id '||p_payroll_action_id);
650: Hr_utility.trace('#- p_chunk '||p_chunk);
651: hr_nonrun_asact.insact(l_actid ,csr_rec.asg_id ,p_payroll_action_id ,p_chunk,null);
644:
645: -- Create the archive assignment action
646: Hr_utility.trace('#- create asg act code');
647: Hr_utility.trace('#- l_actid '||l_actid);
648: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
649: Hr_utility.trace('#- p_payroll_action_id '||p_payroll_action_id);
650: Hr_utility.trace('#- p_chunk '||p_chunk);
651: hr_nonrun_asact.insact(l_actid ,csr_rec.asg_id ,p_payroll_action_id ,p_chunk,null);
652: Hr_utility.trace('#- done with create asg act code');
645: -- Create the archive assignment action
646: Hr_utility.trace('#- create asg act code');
647: Hr_utility.trace('#- l_actid '||l_actid);
648: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
649: Hr_utility.trace('#- p_payroll_action_id '||p_payroll_action_id);
650: Hr_utility.trace('#- p_chunk '||p_chunk);
651: hr_nonrun_asact.insact(l_actid ,csr_rec.asg_id ,p_payroll_action_id ,p_chunk,null);
652: Hr_utility.trace('#- done with create asg act code');
653: Hr_utility.trace('#- l_actid '||l_actid);
646: Hr_utility.trace('#- create asg act code');
647: Hr_utility.trace('#- l_actid '||l_actid);
648: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
649: Hr_utility.trace('#- p_payroll_action_id '||p_payroll_action_id);
650: Hr_utility.trace('#- p_chunk '||p_chunk);
651: hr_nonrun_asact.insact(l_actid ,csr_rec.asg_id ,p_payroll_action_id ,p_chunk,null);
652: Hr_utility.trace('#- done with create asg act code');
653: Hr_utility.trace('#- l_actid '||l_actid);
654: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
648: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
649: Hr_utility.trace('#- p_payroll_action_id '||p_payroll_action_id);
650: Hr_utility.trace('#- p_chunk '||p_chunk);
651: hr_nonrun_asact.insact(l_actid ,csr_rec.asg_id ,p_payroll_action_id ,p_chunk,null);
652: Hr_utility.trace('#- done with create asg act code');
653: Hr_utility.trace('#- l_actid '||l_actid);
654: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
655: Hr_utility.trace('#- p_payroll_action_id '||p_payroll_action_id);
656: Hr_utility.trace('#- p_chunk '||p_chunk);
649: Hr_utility.trace('#- p_payroll_action_id '||p_payroll_action_id);
650: Hr_utility.trace('#- p_chunk '||p_chunk);
651: hr_nonrun_asact.insact(l_actid ,csr_rec.asg_id ,p_payroll_action_id ,p_chunk,null);
652: Hr_utility.trace('#- done with create asg act code');
653: Hr_utility.trace('#- l_actid '||l_actid);
654: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
655: Hr_utility.trace('#- p_payroll_action_id '||p_payroll_action_id);
656: Hr_utility.trace('#- p_chunk '||p_chunk);
657: --
650: Hr_utility.trace('#- p_chunk '||p_chunk);
651: hr_nonrun_asact.insact(l_actid ,csr_rec.asg_id ,p_payroll_action_id ,p_chunk,null);
652: Hr_utility.trace('#- done with create asg act code');
653: Hr_utility.trace('#- l_actid '||l_actid);
654: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
655: Hr_utility.trace('#- p_payroll_action_id '||p_payroll_action_id);
656: Hr_utility.trace('#- p_chunk '||p_chunk);
657: --
658: Hr_utility.trace('#- going to fetch from csr csr_ele_code ');
651: hr_nonrun_asact.insact(l_actid ,csr_rec.asg_id ,p_payroll_action_id ,p_chunk,null);
652: Hr_utility.trace('#- done with create asg act code');
653: Hr_utility.trace('#- l_actid '||l_actid);
654: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
655: Hr_utility.trace('#- p_payroll_action_id '||p_payroll_action_id);
656: Hr_utility.trace('#- p_chunk '||p_chunk);
657: --
658: Hr_utility.trace('#- going to fetch from csr csr_ele_code ');
659: Hr_utility.trace('#- with csr_rec.ele_type_id' || csr_rec.ele_type_id );
652: Hr_utility.trace('#- done with create asg act code');
653: Hr_utility.trace('#- l_actid '||l_actid);
654: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
655: Hr_utility.trace('#- p_payroll_action_id '||p_payroll_action_id);
656: Hr_utility.trace('#- p_chunk '||p_chunk);
657: --
658: Hr_utility.trace('#- going to fetch from csr csr_ele_code ');
659: Hr_utility.trace('#- with csr_rec.ele_type_id' || csr_rec.ele_type_id );
660: Hr_utility.trace('#- with l_le_id ' || l_le_id );
654: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
655: Hr_utility.trace('#- p_payroll_action_id '||p_payroll_action_id);
656: Hr_utility.trace('#- p_chunk '||p_chunk);
657: --
658: Hr_utility.trace('#- going to fetch from csr csr_ele_code ');
659: Hr_utility.trace('#- with csr_rec.ele_type_id' || csr_rec.ele_type_id );
660: Hr_utility.trace('#- with l_le_id ' || l_le_id );
661: OPEN csr_ele_code(csr_rec.ele_type_id,l_le_id);
662: FETCH csr_ele_code INTO rec_ele_code;
655: Hr_utility.trace('#- p_payroll_action_id '||p_payroll_action_id);
656: Hr_utility.trace('#- p_chunk '||p_chunk);
657: --
658: Hr_utility.trace('#- going to fetch from csr csr_ele_code ');
659: Hr_utility.trace('#- with csr_rec.ele_type_id' || csr_rec.ele_type_id );
660: Hr_utility.trace('#- with l_le_id ' || l_le_id );
661: OPEN csr_ele_code(csr_rec.ele_type_id,l_le_id);
662: FETCH csr_ele_code INTO rec_ele_code;
663: CLOSE csr_ele_code;
656: Hr_utility.trace('#- p_chunk '||p_chunk);
657: --
658: Hr_utility.trace('#- going to fetch from csr csr_ele_code ');
659: Hr_utility.trace('#- with csr_rec.ele_type_id' || csr_rec.ele_type_id );
660: Hr_utility.trace('#- with l_le_id ' || l_le_id );
661: OPEN csr_ele_code(csr_rec.ele_type_id,l_le_id);
662: FETCH csr_ele_code INTO rec_ele_code;
663: CLOSE csr_ele_code;
664: Hr_utility.trace('#- record found in csr csr_ele_code ');
660: Hr_utility.trace('#- with l_le_id ' || l_le_id );
661: OPEN csr_ele_code(csr_rec.ele_type_id,l_le_id);
662: FETCH csr_ele_code INTO rec_ele_code;
663: CLOSE csr_ele_code;
664: Hr_utility.trace('#- record found in csr csr_ele_code ');
665: --
666: Hr_utility.trace('#- rec_ele_code.ele_code '||rec_ele_code.ele_code);
667: l_ele_code := rec_ele_code.ele_code;
668: Hr_utility.trace('#- l_ele_code '||l_ele_code);
662: FETCH csr_ele_code INTO rec_ele_code;
663: CLOSE csr_ele_code;
664: Hr_utility.trace('#- record found in csr csr_ele_code ');
665: --
666: Hr_utility.trace('#- rec_ele_code.ele_code '||rec_ele_code.ele_code);
667: l_ele_code := rec_ele_code.ele_code;
668: Hr_utility.trace('#- l_ele_code '||l_ele_code);
669: --
670: Hr_utility.trace('#- csr_rec.costed_value '||csr_rec.costed_value);
664: Hr_utility.trace('#- record found in csr csr_ele_code ');
665: --
666: Hr_utility.trace('#- rec_ele_code.ele_code '||rec_ele_code.ele_code);
667: l_ele_code := rec_ele_code.ele_code;
668: Hr_utility.trace('#- l_ele_code '||l_ele_code);
669: --
670: Hr_utility.trace('#- csr_rec.costed_value '||csr_rec.costed_value);
671: Hr_utility.trace('#- FND_NUMBER.NUMBER_TO_CANONICAL..csr_rec.costed_value '||FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value));
672: -- Uncommenting this part for bug fix 6069852
666: Hr_utility.trace('#- rec_ele_code.ele_code '||rec_ele_code.ele_code);
667: l_ele_code := rec_ele_code.ele_code;
668: Hr_utility.trace('#- l_ele_code '||l_ele_code);
669: --
670: Hr_utility.trace('#- csr_rec.costed_value '||csr_rec.costed_value);
671: Hr_utility.trace('#- FND_NUMBER.NUMBER_TO_CANONICAL..csr_rec.costed_value '||FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value));
672: -- Uncommenting this part for bug fix 6069852
673: --l_cost_value := FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value);
674: Hr_utility.trace('#- l_ele_code '||l_ele_code);
667: l_ele_code := rec_ele_code.ele_code;
668: Hr_utility.trace('#- l_ele_code '||l_ele_code);
669: --
670: Hr_utility.trace('#- csr_rec.costed_value '||csr_rec.costed_value);
671: Hr_utility.trace('#- FND_NUMBER.NUMBER_TO_CANONICAL..csr_rec.costed_value '||FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value));
672: -- Uncommenting this part for bug fix 6069852
673: --l_cost_value := FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value);
674: Hr_utility.trace('#- l_ele_code '||l_ele_code);
675: --
670: Hr_utility.trace('#- csr_rec.costed_value '||csr_rec.costed_value);
671: Hr_utility.trace('#- FND_NUMBER.NUMBER_TO_CANONICAL..csr_rec.costed_value '||FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value));
672: -- Uncommenting this part for bug fix 6069852
673: --l_cost_value := FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value);
674: Hr_utility.trace('#- l_ele_code '||l_ele_code);
675: --
676: Hr_utility.trace('#- l_eoy_code '||l_eoy_code);
677: Hr_utility.trace('#- csr_rec.ele_type_id '||csr_rec.ele_type_id);
678: Hr_utility.trace('#- csr_rec.effective_date '||csr_rec.effective_date);
672: -- Uncommenting this part for bug fix 6069852
673: --l_cost_value := FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value);
674: Hr_utility.trace('#- l_ele_code '||l_ele_code);
675: --
676: Hr_utility.trace('#- l_eoy_code '||l_eoy_code);
677: Hr_utility.trace('#- csr_rec.ele_type_id '||csr_rec.ele_type_id);
678: Hr_utility.trace('#- csr_rec.effective_date '||csr_rec.effective_date);
679: Hr_utility.trace('#- get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date) '||get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date));
680: Hr_utility.trace('#- going to call if 1 ');
673: --l_cost_value := FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value);
674: Hr_utility.trace('#- l_ele_code '||l_ele_code);
675: --
676: Hr_utility.trace('#- l_eoy_code '||l_eoy_code);
677: Hr_utility.trace('#- csr_rec.ele_type_id '||csr_rec.ele_type_id);
678: Hr_utility.trace('#- csr_rec.effective_date '||csr_rec.effective_date);
679: Hr_utility.trace('#- get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date) '||get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date));
680: Hr_utility.trace('#- going to call if 1 ');
681: IF (l_eoy_code IS NULL) OR
674: Hr_utility.trace('#- l_ele_code '||l_ele_code);
675: --
676: Hr_utility.trace('#- l_eoy_code '||l_eoy_code);
677: Hr_utility.trace('#- csr_rec.ele_type_id '||csr_rec.ele_type_id);
678: Hr_utility.trace('#- csr_rec.effective_date '||csr_rec.effective_date);
679: Hr_utility.trace('#- get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date) '||get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date));
680: Hr_utility.trace('#- going to call if 1 ');
681: IF (l_eoy_code IS NULL) OR
682: (l_eoy_code = get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date)) THEN
675: --
676: Hr_utility.trace('#- l_eoy_code '||l_eoy_code);
677: Hr_utility.trace('#- csr_rec.ele_type_id '||csr_rec.ele_type_id);
678: Hr_utility.trace('#- csr_rec.effective_date '||csr_rec.effective_date);
679: Hr_utility.trace('#- get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date) '||get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date));
680: Hr_utility.trace('#- going to call if 1 ');
681: IF (l_eoy_code IS NULL) OR
682: (l_eoy_code = get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date)) THEN
683: -- Creating Initial Archive Entries
676: Hr_utility.trace('#- l_eoy_code '||l_eoy_code);
677: Hr_utility.trace('#- csr_rec.ele_type_id '||csr_rec.ele_type_id);
678: Hr_utility.trace('#- csr_rec.effective_date '||csr_rec.effective_date);
679: Hr_utility.trace('#- get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date) '||get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date));
680: Hr_utility.trace('#- going to call if 1 ');
681: IF (l_eoy_code IS NULL) OR
682: (l_eoy_code = get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date)) THEN
683: -- Creating Initial Archive Entries
684: Hr_utility.trace('#- qualified in if 1 ');
680: Hr_utility.trace('#- going to call if 1 ');
681: IF (l_eoy_code IS NULL) OR
682: (l_eoy_code = get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date)) THEN
683: -- Creating Initial Archive Entries
684: Hr_utility.trace('#- qualified in if 1 ');
685: Hr_utility.trace('#- archiving DETL ');
686: --
687: Hr_utility.set_location('#- l_action_info_id '|| l_action_info_id,21 );
688: Hr_utility.set_location('#- l_ovn '|| l_ovn ,22);
681: IF (l_eoy_code IS NULL) OR
682: (l_eoy_code = get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date)) THEN
683: -- Creating Initial Archive Entries
684: Hr_utility.trace('#- qualified in if 1 ');
685: Hr_utility.trace('#- archiving DETL ');
686: --
687: Hr_utility.set_location('#- l_action_info_id '|| l_action_info_id,21 );
688: Hr_utility.set_location('#- l_ovn '|| l_ovn ,22);
689: Hr_utility.set_location('#- l_actid '|| l_actid,23 );
683: -- Creating Initial Archive Entries
684: Hr_utility.trace('#- qualified in if 1 ');
685: Hr_utility.trace('#- archiving DETL ');
686: --
687: Hr_utility.set_location('#- l_action_info_id '|| l_action_info_id,21 );
688: Hr_utility.set_location('#- l_ovn '|| l_ovn ,22);
689: Hr_utility.set_location('#- l_actid '|| l_actid,23 );
690: Hr_utility.set_location('#- l_effective_date '|| l_effective_date,24 );
691: Hr_utility.set_location('#- csr_rec.asg_id '|| csr_rec.asg_id,25 );
684: Hr_utility.trace('#- qualified in if 1 ');
685: Hr_utility.trace('#- archiving DETL ');
686: --
687: Hr_utility.set_location('#- l_action_info_id '|| l_action_info_id,21 );
688: Hr_utility.set_location('#- l_ovn '|| l_ovn ,22);
689: Hr_utility.set_location('#- l_actid '|| l_actid,23 );
690: Hr_utility.set_location('#- l_effective_date '|| l_effective_date,24 );
691: Hr_utility.set_location('#- csr_rec.asg_id '|| csr_rec.asg_id,25 );
692: Hr_utility.set_location('#- l_le_id '|| l_le_id ,26);
685: Hr_utility.trace('#- archiving DETL ');
686: --
687: Hr_utility.set_location('#- l_action_info_id '|| l_action_info_id,21 );
688: Hr_utility.set_location('#- l_ovn '|| l_ovn ,22);
689: Hr_utility.set_location('#- l_actid '|| l_actid,23 );
690: Hr_utility.set_location('#- l_effective_date '|| l_effective_date,24 );
691: Hr_utility.set_location('#- csr_rec.asg_id '|| csr_rec.asg_id,25 );
692: Hr_utility.set_location('#- l_le_id '|| l_le_id ,26);
693: Hr_utility.set_location('#- csr_rec.payroll_name '|| csr_rec.payroll_name,27 );
686: --
687: Hr_utility.set_location('#- l_action_info_id '|| l_action_info_id,21 );
688: Hr_utility.set_location('#- l_ovn '|| l_ovn ,22);
689: Hr_utility.set_location('#- l_actid '|| l_actid,23 );
690: Hr_utility.set_location('#- l_effective_date '|| l_effective_date,24 );
691: Hr_utility.set_location('#- csr_rec.asg_id '|| csr_rec.asg_id,25 );
692: Hr_utility.set_location('#- l_le_id '|| l_le_id ,26);
693: Hr_utility.set_location('#- csr_rec.payroll_name '|| csr_rec.payroll_name,27 );
694: Hr_utility.set_location('#- p_payroll_action_id '|| p_payroll_action_id,28 );
687: Hr_utility.set_location('#- l_action_info_id '|| l_action_info_id,21 );
688: Hr_utility.set_location('#- l_ovn '|| l_ovn ,22);
689: Hr_utility.set_location('#- l_actid '|| l_actid,23 );
690: Hr_utility.set_location('#- l_effective_date '|| l_effective_date,24 );
691: Hr_utility.set_location('#- csr_rec.asg_id '|| csr_rec.asg_id,25 );
692: Hr_utility.set_location('#- l_le_id '|| l_le_id ,26);
693: Hr_utility.set_location('#- csr_rec.payroll_name '|| csr_rec.payroll_name,27 );
694: Hr_utility.set_location('#- p_payroll_action_id '|| p_payroll_action_id,28 );
695: Hr_utility.set_location('#- csr_rec.assignment_number '|| csr_rec.assignment_number,29 );
688: Hr_utility.set_location('#- l_ovn '|| l_ovn ,22);
689: Hr_utility.set_location('#- l_actid '|| l_actid,23 );
690: Hr_utility.set_location('#- l_effective_date '|| l_effective_date,24 );
691: Hr_utility.set_location('#- csr_rec.asg_id '|| csr_rec.asg_id,25 );
692: Hr_utility.set_location('#- l_le_id '|| l_le_id ,26);
693: Hr_utility.set_location('#- csr_rec.payroll_name '|| csr_rec.payroll_name,27 );
694: Hr_utility.set_location('#- p_payroll_action_id '|| p_payroll_action_id,28 );
695: Hr_utility.set_location('#- csr_rec.assignment_number '|| csr_rec.assignment_number,29 );
696: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,30 );
689: Hr_utility.set_location('#- l_actid '|| l_actid,23 );
690: Hr_utility.set_location('#- l_effective_date '|| l_effective_date,24 );
691: Hr_utility.set_location('#- csr_rec.asg_id '|| csr_rec.asg_id,25 );
692: Hr_utility.set_location('#- l_le_id '|| l_le_id ,26);
693: Hr_utility.set_location('#- csr_rec.payroll_name '|| csr_rec.payroll_name,27 );
694: Hr_utility.set_location('#- p_payroll_action_id '|| p_payroll_action_id,28 );
695: Hr_utility.set_location('#- csr_rec.assignment_number '|| csr_rec.assignment_number,29 );
696: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,30 );
697: Hr_utility.set_location('#- csr_rec.ele_type_id '|| csr_rec.ele_type_id,31 );
690: Hr_utility.set_location('#- l_effective_date '|| l_effective_date,24 );
691: Hr_utility.set_location('#- csr_rec.asg_id '|| csr_rec.asg_id,25 );
692: Hr_utility.set_location('#- l_le_id '|| l_le_id ,26);
693: Hr_utility.set_location('#- csr_rec.payroll_name '|| csr_rec.payroll_name,27 );
694: Hr_utility.set_location('#- p_payroll_action_id '|| p_payroll_action_id,28 );
695: Hr_utility.set_location('#- csr_rec.assignment_number '|| csr_rec.assignment_number,29 );
696: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,30 );
697: Hr_utility.set_location('#- csr_rec.ele_type_id '|| csr_rec.ele_type_id,31 );
698: Hr_utility.set_location('#- csr_rec.ele_name '|| csr_rec.ele_name,32 );
691: Hr_utility.set_location('#- csr_rec.asg_id '|| csr_rec.asg_id,25 );
692: Hr_utility.set_location('#- l_le_id '|| l_le_id ,26);
693: Hr_utility.set_location('#- csr_rec.payroll_name '|| csr_rec.payroll_name,27 );
694: Hr_utility.set_location('#- p_payroll_action_id '|| p_payroll_action_id,28 );
695: Hr_utility.set_location('#- csr_rec.assignment_number '|| csr_rec.assignment_number,29 );
696: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,30 );
697: Hr_utility.set_location('#- csr_rec.ele_type_id '|| csr_rec.ele_type_id,31 );
698: Hr_utility.set_location('#- csr_rec.ele_name '|| csr_rec.ele_name,32 );
699: Hr_utility.set_location('#- int l_eoy_code '|| l_eoy_code,33 );
692: Hr_utility.set_location('#- l_le_id '|| l_le_id ,26);
693: Hr_utility.set_location('#- csr_rec.payroll_name '|| csr_rec.payroll_name,27 );
694: Hr_utility.set_location('#- p_payroll_action_id '|| p_payroll_action_id,28 );
695: Hr_utility.set_location('#- csr_rec.assignment_number '|| csr_rec.assignment_number,29 );
696: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,30 );
697: Hr_utility.set_location('#- csr_rec.ele_type_id '|| csr_rec.ele_type_id,31 );
698: Hr_utility.set_location('#- csr_rec.ele_name '|| csr_rec.ele_name,32 );
699: Hr_utility.set_location('#- int l_eoy_code '|| l_eoy_code,33 );
700: Hr_utility.set_location('#- int csr_rec.ele_type_id '|| csr_rec.ele_type_id,34 );
693: Hr_utility.set_location('#- csr_rec.payroll_name '|| csr_rec.payroll_name,27 );
694: Hr_utility.set_location('#- p_payroll_action_id '|| p_payroll_action_id,28 );
695: Hr_utility.set_location('#- csr_rec.assignment_number '|| csr_rec.assignment_number,29 );
696: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,30 );
697: Hr_utility.set_location('#- csr_rec.ele_type_id '|| csr_rec.ele_type_id,31 );
698: Hr_utility.set_location('#- csr_rec.ele_name '|| csr_rec.ele_name,32 );
699: Hr_utility.set_location('#- int l_eoy_code '|| l_eoy_code,33 );
700: Hr_utility.set_location('#- int csr_rec.ele_type_id '|| csr_rec.ele_type_id,34 );
701: Hr_utility.set_location('#- int csr_rec.effective_date '|| csr_rec.effective_date,35 );
694: Hr_utility.set_location('#- p_payroll_action_id '|| p_payroll_action_id,28 );
695: Hr_utility.set_location('#- csr_rec.assignment_number '|| csr_rec.assignment_number,29 );
696: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,30 );
697: Hr_utility.set_location('#- csr_rec.ele_type_id '|| csr_rec.ele_type_id,31 );
698: Hr_utility.set_location('#- csr_rec.ele_name '|| csr_rec.ele_name,32 );
699: Hr_utility.set_location('#- int l_eoy_code '|| l_eoy_code,33 );
700: Hr_utility.set_location('#- int csr_rec.ele_type_id '|| csr_rec.ele_type_id,34 );
701: Hr_utility.set_location('#- int csr_rec.effective_date '|| csr_rec.effective_date,35 );
702: -- Hr_utility.trace('#- int csr_rec.effective_date '|| csr_rec.effective_date );
695: Hr_utility.set_location('#- csr_rec.assignment_number '|| csr_rec.assignment_number,29 );
696: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,30 );
697: Hr_utility.set_location('#- csr_rec.ele_type_id '|| csr_rec.ele_type_id,31 );
698: Hr_utility.set_location('#- csr_rec.ele_name '|| csr_rec.ele_name,32 );
699: Hr_utility.set_location('#- int l_eoy_code '|| l_eoy_code,33 );
700: Hr_utility.set_location('#- int csr_rec.ele_type_id '|| csr_rec.ele_type_id,34 );
701: Hr_utility.set_location('#- int csr_rec.effective_date '|| csr_rec.effective_date,35 );
702: -- Hr_utility.trace('#- int csr_rec.effective_date '|| csr_rec.effective_date );
703: Hr_utility.set_location('#- get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date )) '|| get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date ),36 );
696: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,30 );
697: Hr_utility.set_location('#- csr_rec.ele_type_id '|| csr_rec.ele_type_id,31 );
698: Hr_utility.set_location('#- csr_rec.ele_name '|| csr_rec.ele_name,32 );
699: Hr_utility.set_location('#- int l_eoy_code '|| l_eoy_code,33 );
700: Hr_utility.set_location('#- int csr_rec.ele_type_id '|| csr_rec.ele_type_id,34 );
701: Hr_utility.set_location('#- int csr_rec.effective_date '|| csr_rec.effective_date,35 );
702: -- Hr_utility.trace('#- int csr_rec.effective_date '|| csr_rec.effective_date );
703: Hr_utility.set_location('#- get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date )) '|| get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date ),36 );
704: Hr_utility.set_location('#- csr_rec.ele_cost_seg '|| csr_rec.ele_cost_seg,37 );
697: Hr_utility.set_location('#- csr_rec.ele_type_id '|| csr_rec.ele_type_id,31 );
698: Hr_utility.set_location('#- csr_rec.ele_name '|| csr_rec.ele_name,32 );
699: Hr_utility.set_location('#- int l_eoy_code '|| l_eoy_code,33 );
700: Hr_utility.set_location('#- int csr_rec.ele_type_id '|| csr_rec.ele_type_id,34 );
701: Hr_utility.set_location('#- int csr_rec.effective_date '|| csr_rec.effective_date,35 );
702: -- Hr_utility.trace('#- int csr_rec.effective_date '|| csr_rec.effective_date );
703: Hr_utility.set_location('#- get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date )) '|| get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date ),36 );
704: Hr_utility.set_location('#- csr_rec.ele_cost_seg '|| csr_rec.ele_cost_seg,37 );
705: Hr_utility.set_location('#- csr_rec.cost_flex_id '|| csr_rec.cost_flex_id,38 );
698: Hr_utility.set_location('#- csr_rec.ele_name '|| csr_rec.ele_name,32 );
699: Hr_utility.set_location('#- int l_eoy_code '|| l_eoy_code,33 );
700: Hr_utility.set_location('#- int csr_rec.ele_type_id '|| csr_rec.ele_type_id,34 );
701: Hr_utility.set_location('#- int csr_rec.effective_date '|| csr_rec.effective_date,35 );
702: -- Hr_utility.trace('#- int csr_rec.effective_date '|| csr_rec.effective_date );
703: Hr_utility.set_location('#- get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date )) '|| get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date ),36 );
704: Hr_utility.set_location('#- csr_rec.ele_cost_seg '|| csr_rec.ele_cost_seg,37 );
705: Hr_utility.set_location('#- csr_rec.cost_flex_id '|| csr_rec.cost_flex_id,38 );
706: Hr_utility.set_location('#- csr_rec.debit_credit '|| csr_rec.debit_credit,39 );
699: Hr_utility.set_location('#- int l_eoy_code '|| l_eoy_code,33 );
700: Hr_utility.set_location('#- int csr_rec.ele_type_id '|| csr_rec.ele_type_id,34 );
701: Hr_utility.set_location('#- int csr_rec.effective_date '|| csr_rec.effective_date,35 );
702: -- Hr_utility.trace('#- int csr_rec.effective_date '|| csr_rec.effective_date );
703: Hr_utility.set_location('#- get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date )) '|| get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date ),36 );
704: Hr_utility.set_location('#- csr_rec.ele_cost_seg '|| csr_rec.ele_cost_seg,37 );
705: Hr_utility.set_location('#- csr_rec.cost_flex_id '|| csr_rec.cost_flex_id,38 );
706: Hr_utility.set_location('#- csr_rec.debit_credit '|| csr_rec.debit_credit,39 );
707: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,40 );
700: Hr_utility.set_location('#- int csr_rec.ele_type_id '|| csr_rec.ele_type_id,34 );
701: Hr_utility.set_location('#- int csr_rec.effective_date '|| csr_rec.effective_date,35 );
702: -- Hr_utility.trace('#- int csr_rec.effective_date '|| csr_rec.effective_date );
703: Hr_utility.set_location('#- get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date )) '|| get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date ),36 );
704: Hr_utility.set_location('#- csr_rec.ele_cost_seg '|| csr_rec.ele_cost_seg,37 );
705: Hr_utility.set_location('#- csr_rec.cost_flex_id '|| csr_rec.cost_flex_id,38 );
706: Hr_utility.set_location('#- csr_rec.debit_credit '|| csr_rec.debit_credit,39 );
707: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,40 );
708: Hr_utility.set_location('#- csr_rec.costed_value '|| csr_rec.costed_value,41 );
701: Hr_utility.set_location('#- int csr_rec.effective_date '|| csr_rec.effective_date,35 );
702: -- Hr_utility.trace('#- int csr_rec.effective_date '|| csr_rec.effective_date );
703: Hr_utility.set_location('#- get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date )) '|| get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date ),36 );
704: Hr_utility.set_location('#- csr_rec.ele_cost_seg '|| csr_rec.ele_cost_seg,37 );
705: Hr_utility.set_location('#- csr_rec.cost_flex_id '|| csr_rec.cost_flex_id,38 );
706: Hr_utility.set_location('#- csr_rec.debit_credit '|| csr_rec.debit_credit,39 );
707: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,40 );
708: Hr_utility.set_location('#- csr_rec.costed_value '|| csr_rec.costed_value,41 );
709: Hr_utility.set_location('#- csr_rec.cost_or_bal '|| csr_rec.cost_or_bal,42 );
702: -- Hr_utility.trace('#- int csr_rec.effective_date '|| csr_rec.effective_date );
703: Hr_utility.set_location('#- get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date )) '|| get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date ),36 );
704: Hr_utility.set_location('#- csr_rec.ele_cost_seg '|| csr_rec.ele_cost_seg,37 );
705: Hr_utility.set_location('#- csr_rec.cost_flex_id '|| csr_rec.cost_flex_id,38 );
706: Hr_utility.set_location('#- csr_rec.debit_credit '|| csr_rec.debit_credit,39 );
707: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,40 );
708: Hr_utility.set_location('#- csr_rec.costed_value '|| csr_rec.costed_value,41 );
709: Hr_utility.set_location('#- csr_rec.cost_or_bal '|| csr_rec.cost_or_bal,42 );
710: Hr_utility.set_location('#- csr_rec.effective_date '|| csr_rec.effective_date,43 );
703: Hr_utility.set_location('#- get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date )) '|| get_ele_code(csr_rec.ele_type_id, csr_rec.effective_date ),36 );
704: Hr_utility.set_location('#- csr_rec.ele_cost_seg '|| csr_rec.ele_cost_seg,37 );
705: Hr_utility.set_location('#- csr_rec.cost_flex_id '|| csr_rec.cost_flex_id,38 );
706: Hr_utility.set_location('#- csr_rec.debit_credit '|| csr_rec.debit_credit,39 );
707: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,40 );
708: Hr_utility.set_location('#- csr_rec.costed_value '|| csr_rec.costed_value,41 );
709: Hr_utility.set_location('#- csr_rec.cost_or_bal '|| csr_rec.cost_or_bal,42 );
710: Hr_utility.set_location('#- csr_rec.effective_date '|| csr_rec.effective_date,43 );
711: Hr_utility.set_location('#- csr_rec.emp_name '|| csr_rec.emp_name,44 );
704: Hr_utility.set_location('#- csr_rec.ele_cost_seg '|| csr_rec.ele_cost_seg,37 );
705: Hr_utility.set_location('#- csr_rec.cost_flex_id '|| csr_rec.cost_flex_id,38 );
706: Hr_utility.set_location('#- csr_rec.debit_credit '|| csr_rec.debit_credit,39 );
707: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,40 );
708: Hr_utility.set_location('#- csr_rec.costed_value '|| csr_rec.costed_value,41 );
709: Hr_utility.set_location('#- csr_rec.cost_or_bal '|| csr_rec.cost_or_bal,42 );
710: Hr_utility.set_location('#- csr_rec.effective_date '|| csr_rec.effective_date,43 );
711: Hr_utility.set_location('#- csr_rec.emp_name '|| csr_rec.emp_name,44 );
712: --
705: Hr_utility.set_location('#- csr_rec.cost_flex_id '|| csr_rec.cost_flex_id,38 );
706: Hr_utility.set_location('#- csr_rec.debit_credit '|| csr_rec.debit_credit,39 );
707: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,40 );
708: Hr_utility.set_location('#- csr_rec.costed_value '|| csr_rec.costed_value,41 );
709: Hr_utility.set_location('#- csr_rec.cost_or_bal '|| csr_rec.cost_or_bal,42 );
710: Hr_utility.set_location('#- csr_rec.effective_date '|| csr_rec.effective_date,43 );
711: Hr_utility.set_location('#- csr_rec.emp_name '|| csr_rec.emp_name,44 );
712: --
713: pay_action_information_api.create_action_information
706: Hr_utility.set_location('#- csr_rec.debit_credit '|| csr_rec.debit_credit,39 );
707: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,40 );
708: Hr_utility.set_location('#- csr_rec.costed_value '|| csr_rec.costed_value,41 );
709: Hr_utility.set_location('#- csr_rec.cost_or_bal '|| csr_rec.cost_or_bal,42 );
710: Hr_utility.set_location('#- csr_rec.effective_date '|| csr_rec.effective_date,43 );
711: Hr_utility.set_location('#- csr_rec.emp_name '|| csr_rec.emp_name,44 );
712: --
713: pay_action_information_api.create_action_information
714: (p_action_information_id => l_action_info_id -- OUT parameter
707: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,40 );
708: Hr_utility.set_location('#- csr_rec.costed_value '|| csr_rec.costed_value,41 );
709: Hr_utility.set_location('#- csr_rec.cost_or_bal '|| csr_rec.cost_or_bal,42 );
710: Hr_utility.set_location('#- csr_rec.effective_date '|| csr_rec.effective_date,43 );
711: Hr_utility.set_location('#- csr_rec.emp_name '|| csr_rec.emp_name,44 );
712: --
713: pay_action_information_api.create_action_information
714: (p_action_information_id => l_action_info_id -- OUT parameter
715: ,p_object_version_number => l_ovn -- OUT parameter
738: ,p_action_information15 => csr_rec.cost_or_bal -- Cost or Balance Flag
739: ,p_action_information16 => csr_rec.effective_date -- Costing Effective Date
740: ,p_action_information17 => csr_rec.emp_name -- Employee Name
741: );
742: Hr_utility.trace('#- archived DETL successfully');
743: END IF;
744: Hr_utility.trace('#- qualified in end if 1 ');
745: --
746: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
740: ,p_action_information17 => csr_rec.emp_name -- Employee Name
741: );
742: Hr_utility.trace('#- archived DETL successfully');
743: END IF;
744: Hr_utility.trace('#- qualified in end if 1 ');
745: --
746: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
747: l_asgid := csr_rec.asg_id;
748: Hr_utility.trace('#- l_asgid '||l_asgid);
742: Hr_utility.trace('#- archived DETL successfully');
743: END IF;
744: Hr_utility.trace('#- qualified in end if 1 ');
745: --
746: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
747: l_asgid := csr_rec.asg_id;
748: Hr_utility.trace('#- l_asgid '||l_asgid);
749:
750: END LOOP; -- csr_assignments
744: Hr_utility.trace('#- qualified in end if 1 ');
745: --
746: Hr_utility.trace('#- csr_rec.asg_id '||csr_rec.asg_id);
747: l_asgid := csr_rec.asg_id;
748: Hr_utility.trace('#- l_asgid '||l_asgid);
749:
750: END LOOP; -- csr_assignments
751: Hr_utility.trace('#- end of loop csr_assignments ');
752:
747: l_asgid := csr_rec.asg_id;
748: Hr_utility.trace('#- l_asgid '||l_asgid);
749:
750: END LOOP; -- csr_assignments
751: Hr_utility.trace('#- end of loop csr_assignments ');
752:
753: END LOOP; -- csr_get_lu_le
754: Hr_utility.trace('#- end of loop csr_get_lu_le ');
755:
750: END LOOP; -- csr_assignments
751: Hr_utility.trace('#- end of loop csr_assignments ');
752:
753: END LOOP; -- csr_get_lu_le
754: Hr_utility.trace('#- end of loop csr_get_lu_le ');
755:
756: IF g_debug THEN
757: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',20);
758: END IF;
753: END LOOP; -- csr_get_lu_le
754: Hr_utility.trace('#- end of loop csr_get_lu_le ');
755:
756: IF g_debug THEN
757: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',20);
758: END IF;
759: Hr_utility.trace('#- end of ASSIGNMENT_ACTION_CODE');
760: END ASSIGNMENT_ACTION_CODE;
761:
755:
756: IF g_debug THEN
757: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',20);
758: END IF;
759: Hr_utility.trace('#- end of ASSIGNMENT_ACTION_CODE');
760: END ASSIGNMENT_ACTION_CODE;
761:
762:
763: PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER)
768:
769: NULL;
770:
771: IF g_debug THEN
772: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',10);
773: END IF;
774:
775: IF g_debug THEN
776: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',20);
772: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',10);
773: END IF;
774:
775: IF g_debug THEN
776: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',20);
777: END IF;
778:
779: EXCEPTION WHEN OTHERS THEN
780: g_err_num := SQLCODE;
779: EXCEPTION WHEN OTHERS THEN
780: g_err_num := SQLCODE;
781:
782: IF g_debug THEN
783: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',30);
784: END IF;
785:
786: END INITIALIZATION_CODE;
787:
791: IS
792:
793: BEGIN
794: IF g_debug THEN
795: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',10);
796: END IF;
797:
798: IF g_debug THEN
799: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',20);
795: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',10);
796: END IF;
797:
798: IF g_debug THEN
799: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',20);
800: END IF;
801:
802: END ARCHIVE_CODE;
803:
876: rec_ele_code csr_ele_code%ROWTYPE;
877: BEGIN
878:
879: IF g_debug THEN
880: hr_utility.set_location(' Entering Procedure DEINITIALIZATION_CODE',10);
881: END IF;
882:
883: -- Fetch Summary of Detailed Costing Information
884: FOR rec_costing_summary IN csr_costing_summary(p_payroll_action_id)
922: ,p_action_information12 => l_ele_code -- Element Code
923: ,p_action_information13 => l_sum_cost_value -- Total Costing Value
924: ,p_action_information14 => l_cost_or_bal -- Cost or Balance Flag
925: );
926: Hr_utility.set_location('#- l_business_group_id '|| l_business_group_id,45 );
927: Hr_utility.set_location('#- l_payroll_id '|| l_payroll_id,46 );
928: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,47 );
929: Hr_utility.set_location('#- l_ele_type_id '|| l_ele_type_id,48 );
930: Hr_utility.set_location('#- l_ele_name '|| l_ele_name,49 );
923: ,p_action_information13 => l_sum_cost_value -- Total Costing Value
924: ,p_action_information14 => l_cost_or_bal -- Cost or Balance Flag
925: );
926: Hr_utility.set_location('#- l_business_group_id '|| l_business_group_id,45 );
927: Hr_utility.set_location('#- l_payroll_id '|| l_payroll_id,46 );
928: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,47 );
929: Hr_utility.set_location('#- l_ele_type_id '|| l_ele_type_id,48 );
930: Hr_utility.set_location('#- l_ele_name '|| l_ele_name,49 );
931: Hr_utility.set_location('#- l_ele_eoy_code '|| l_ele_eoy_code,50 );
924: ,p_action_information14 => l_cost_or_bal -- Cost or Balance Flag
925: );
926: Hr_utility.set_location('#- l_business_group_id '|| l_business_group_id,45 );
927: Hr_utility.set_location('#- l_payroll_id '|| l_payroll_id,46 );
928: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,47 );
929: Hr_utility.set_location('#- l_ele_type_id '|| l_ele_type_id,48 );
930: Hr_utility.set_location('#- l_ele_name '|| l_ele_name,49 );
931: Hr_utility.set_location('#- l_ele_eoy_code '|| l_ele_eoy_code,50 );
932: Hr_utility.set_location('#- l_ele_cost_seg '|| l_ele_cost_seg,51 );
925: );
926: Hr_utility.set_location('#- l_business_group_id '|| l_business_group_id,45 );
927: Hr_utility.set_location('#- l_payroll_id '|| l_payroll_id,46 );
928: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,47 );
929: Hr_utility.set_location('#- l_ele_type_id '|| l_ele_type_id,48 );
930: Hr_utility.set_location('#- l_ele_name '|| l_ele_name,49 );
931: Hr_utility.set_location('#- l_ele_eoy_code '|| l_ele_eoy_code,50 );
932: Hr_utility.set_location('#- l_ele_cost_seg '|| l_ele_cost_seg,51 );
933: Hr_utility.set_location('#- l_cost_flex_id '|| l_cost_flex_id,52 );
926: Hr_utility.set_location('#- l_business_group_id '|| l_business_group_id,45 );
927: Hr_utility.set_location('#- l_payroll_id '|| l_payroll_id,46 );
928: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,47 );
929: Hr_utility.set_location('#- l_ele_type_id '|| l_ele_type_id,48 );
930: Hr_utility.set_location('#- l_ele_name '|| l_ele_name,49 );
931: Hr_utility.set_location('#- l_ele_eoy_code '|| l_ele_eoy_code,50 );
932: Hr_utility.set_location('#- l_ele_cost_seg '|| l_ele_cost_seg,51 );
933: Hr_utility.set_location('#- l_cost_flex_id '|| l_cost_flex_id,52 );
934: Hr_utility.set_location('#- l_debit_credit '|| l_debit_credit,53 );
927: Hr_utility.set_location('#- l_payroll_id '|| l_payroll_id,46 );
928: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,47 );
929: Hr_utility.set_location('#- l_ele_type_id '|| l_ele_type_id,48 );
930: Hr_utility.set_location('#- l_ele_name '|| l_ele_name,49 );
931: Hr_utility.set_location('#- l_ele_eoy_code '|| l_ele_eoy_code,50 );
932: Hr_utility.set_location('#- l_ele_cost_seg '|| l_ele_cost_seg,51 );
933: Hr_utility.set_location('#- l_cost_flex_id '|| l_cost_flex_id,52 );
934: Hr_utility.set_location('#- l_debit_credit '|| l_debit_credit,53 );
935: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,54 );
928: Hr_utility.set_location('#- l_local_unit_id '|| l_local_unit_id,47 );
929: Hr_utility.set_location('#- l_ele_type_id '|| l_ele_type_id,48 );
930: Hr_utility.set_location('#- l_ele_name '|| l_ele_name,49 );
931: Hr_utility.set_location('#- l_ele_eoy_code '|| l_ele_eoy_code,50 );
932: Hr_utility.set_location('#- l_ele_cost_seg '|| l_ele_cost_seg,51 );
933: Hr_utility.set_location('#- l_cost_flex_id '|| l_cost_flex_id,52 );
934: Hr_utility.set_location('#- l_debit_credit '|| l_debit_credit,53 );
935: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,54 );
936: Hr_utility.set_location('#- l_sum_cost_value '|| l_sum_cost_value,55 );
929: Hr_utility.set_location('#- l_ele_type_id '|| l_ele_type_id,48 );
930: Hr_utility.set_location('#- l_ele_name '|| l_ele_name,49 );
931: Hr_utility.set_location('#- l_ele_eoy_code '|| l_ele_eoy_code,50 );
932: Hr_utility.set_location('#- l_ele_cost_seg '|| l_ele_cost_seg,51 );
933: Hr_utility.set_location('#- l_cost_flex_id '|| l_cost_flex_id,52 );
934: Hr_utility.set_location('#- l_debit_credit '|| l_debit_credit,53 );
935: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,54 );
936: Hr_utility.set_location('#- l_sum_cost_value '|| l_sum_cost_value,55 );
937: Hr_utility.set_location('#- l_cost_or_bal '|| l_cost_or_bal,56 );
930: Hr_utility.set_location('#- l_ele_name '|| l_ele_name,49 );
931: Hr_utility.set_location('#- l_ele_eoy_code '|| l_ele_eoy_code,50 );
932: Hr_utility.set_location('#- l_ele_cost_seg '|| l_ele_cost_seg,51 );
933: Hr_utility.set_location('#- l_cost_flex_id '|| l_cost_flex_id,52 );
934: Hr_utility.set_location('#- l_debit_credit '|| l_debit_credit,53 );
935: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,54 );
936: Hr_utility.set_location('#- l_sum_cost_value '|| l_sum_cost_value,55 );
937: Hr_utility.set_location('#- l_cost_or_bal '|| l_cost_or_bal,56 );
938:
931: Hr_utility.set_location('#- l_ele_eoy_code '|| l_ele_eoy_code,50 );
932: Hr_utility.set_location('#- l_ele_cost_seg '|| l_ele_cost_seg,51 );
933: Hr_utility.set_location('#- l_cost_flex_id '|| l_cost_flex_id,52 );
934: Hr_utility.set_location('#- l_debit_credit '|| l_debit_credit,53 );
935: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,54 );
936: Hr_utility.set_location('#- l_sum_cost_value '|| l_sum_cost_value,55 );
937: Hr_utility.set_location('#- l_cost_or_bal '|| l_cost_or_bal,56 );
938:
939: END LOOP; --csr_costing_summary
932: Hr_utility.set_location('#- l_ele_cost_seg '|| l_ele_cost_seg,51 );
933: Hr_utility.set_location('#- l_cost_flex_id '|| l_cost_flex_id,52 );
934: Hr_utility.set_location('#- l_debit_credit '|| l_debit_credit,53 );
935: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,54 );
936: Hr_utility.set_location('#- l_sum_cost_value '|| l_sum_cost_value,55 );
937: Hr_utility.set_location('#- l_cost_or_bal '|| l_cost_or_bal,56 );
938:
939: END LOOP; --csr_costing_summary
940:
933: Hr_utility.set_location('#- l_cost_flex_id '|| l_cost_flex_id,52 );
934: Hr_utility.set_location('#- l_debit_credit '|| l_debit_credit,53 );
935: Hr_utility.set_location('#- l_ele_code '|| l_ele_code,54 );
936: Hr_utility.set_location('#- l_sum_cost_value '|| l_sum_cost_value,55 );
937: Hr_utility.set_location('#- l_cost_or_bal '|| l_cost_or_bal,56 );
938:
939: END LOOP; --csr_costing_summary
940:
941: IF g_debug THEN
938:
939: END LOOP; --csr_costing_summary
940:
941: IF g_debug THEN
942: hr_utility.set_location(' Leaving Procedure DEINITIALIZATION_CODE',20);
943: END IF;
944:
945: EXCEPTION WHEN OTHERS THEN
946: g_err_num := SQLCODE;
945: EXCEPTION WHEN OTHERS THEN
946: g_err_num := SQLCODE;
947:
948: IF g_debug THEN
949: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In DEINITIALIZATION_CODE',30);
950: END IF;
951:
952: END DEINITIALIZATION_CODE;
953:
1024: ELSE
1025: l_payroll_action_id := p_payroll_action_id;
1026: END IF;
1027: --
1028: hr_utility.set_location('Entered Procedure GETDATA',10);
1029: --
1030: /* Get the File Header Information */
1031: OPEN csr_get_hdr_info(l_payroll_action_id);
1032: FETCH csr_get_hdr_info INTO rec_get_hdr_info;
1031: OPEN csr_get_hdr_info(l_payroll_action_id);
1032: FETCH csr_get_hdr_info INTO rec_get_hdr_info;
1033: CLOSE csr_get_hdr_info;
1034: --
1035: hr_utility.set_location('Before populating pl/sql table',20);
1036: --
1037: xml_tab(l_counter).TagName :='FILE_HEADER_START';
1038: xml_tab(l_counter).TagValue :='FILE_HEADER_START';
1039: l_counter := l_counter + 1;
1037: xml_tab(l_counter).TagName :='FILE_HEADER_START';
1038: xml_tab(l_counter).TagValue :='FILE_HEADER_START';
1039: l_counter := l_counter + 1;
1040: --
1041: hr_utility.set_location('LE_NAME'||rec_get_hdr_info.action_information7,21);
1042: xml_tab(l_counter).TagName :='LE_NAME';
1043: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information7;
1044: l_counter := l_counter + 1;
1045: --
1042: xml_tab(l_counter).TagName :='LE_NAME';
1043: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information7;
1044: l_counter := l_counter + 1;
1045: --
1046: hr_utility.set_location('LE_ORG_NO'||rec_get_hdr_info.action_information8,22);
1047: xml_tab(l_counter).TagName :='LE_ORG_NO';
1048: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information8;
1049: l_counter := l_counter + 1;
1050: --
1047: xml_tab(l_counter).TagName :='LE_ORG_NO';
1048: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information8;
1049: l_counter := l_counter + 1;
1050: --
1051: hr_utility.set_location('REPORT_START_DATE'||rec_get_hdr_info.action_information12,23);
1052: xml_tab(l_counter).TagName :='REPORT_START_DATE';
1053: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information12;
1054: l_counter := l_counter + 1;
1055: --
1052: xml_tab(l_counter).TagName :='REPORT_START_DATE';
1053: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information12;
1054: l_counter := l_counter + 1;
1055: --
1056: hr_utility.set_location('REPORT_END_DATE'||rec_get_hdr_info.action_information13,24);
1057: xml_tab(l_counter).TagName :='REPORT_END_DATE';
1058: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information13;
1059: l_counter := l_counter + 1;
1060: --
1057: xml_tab(l_counter).TagName :='REPORT_END_DATE';
1058: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information13;
1059: l_counter := l_counter + 1;
1060: --
1061: hr_utility.set_location('PARAM_COST_SEG'||rec_get_hdr_info.action_information9,25);
1062: xml_tab(l_counter).TagName :='PARAM_COST_SEG';
1063: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information9;
1064: l_counter := l_counter + 1;
1065: --
1062: xml_tab(l_counter).TagName :='PARAM_COST_SEG';
1063: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information9;
1064: l_counter := l_counter + 1;
1065: --
1066: hr_utility.set_location('PARAM_EOY_CODE'||rec_get_hdr_info.action_information10,26);
1067: xml_tab(l_counter).TagName :='PARAM_EOY_CODE';
1068: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information10;
1069: l_counter := l_counter + 1;
1070: --
1067: xml_tab(l_counter).TagName :='PARAM_EOY_CODE';
1068: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information10;
1069: l_counter := l_counter + 1;
1070: --
1071: hr_utility.set_location('PARAM_RESTR_ECONTR'||rec_get_hdr_info.action_information14,27);
1072: xml_tab(l_counter).TagName :='PARAM_RESTR_ECONTR';
1073: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information14;
1074: l_counter := l_counter + 1;
1075: --
1072: xml_tab(l_counter).TagName :='PARAM_RESTR_ECONTR';
1073: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information14;
1074: l_counter := l_counter + 1;
1075: --
1076: hr_utility.set_location('PARAM_PAYROLL_NAME'||rec_get_hdr_info.action_information15,28);
1077: xml_tab(l_counter).TagName :='PARAM_PAYROLL_NAME';
1078: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information15;
1079: l_counter := l_counter + 1;
1080: --
1077: xml_tab(l_counter).TagName :='PARAM_PAYROLL_NAME';
1078: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information15;
1079: l_counter := l_counter + 1;
1080: --
1081: hr_utility.set_location('PARAM_ELE_NAME'||rec_get_hdr_info.action_information16,29);
1082: xml_tab(l_counter).TagName :='PARAM_ELE_NAME';
1083: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information16;
1084: l_counter := l_counter + 1;
1085: --
1086: xml_tab(l_counter).TagName :='COST_RECO_START';
1087: xml_tab(l_counter).TagValue :='COST_RECO_START';
1088: l_counter := l_counter + 1;
1089: --
1090: hr_utility.set_location('FOR LOOP STARTING csr_get_summ_info',31);
1091: FOR rec_get_summ_info IN csr_get_summ_info(l_payroll_action_id,rec_get_hdr_info.tax_unit_id)
1092: LOOP
1093: /* Counter to count records fetched */
1094: l_count := l_count + 1 ;
1092: LOOP
1093: /* Counter to count records fetched */
1094: l_count := l_count + 1 ;
1095: /*Check cost_seg for grouping */
1096: hr_utility.set_location('Record found',32);
1097: hr_utility.set_location('l_count'||l_count,32);
1098: hr_utility.set_location('l_prev_cost_seg'||l_prev_cost_seg,33);
1099: hr_utility.set_location('rec_get_summ_info.action_information9'||rec_get_summ_info.action_information9,34);
1100: --
1093: /* Counter to count records fetched */
1094: l_count := l_count + 1 ;
1095: /*Check cost_seg for grouping */
1096: hr_utility.set_location('Record found',32);
1097: hr_utility.set_location('l_count'||l_count,32);
1098: hr_utility.set_location('l_prev_cost_seg'||l_prev_cost_seg,33);
1099: hr_utility.set_location('rec_get_summ_info.action_information9'||rec_get_summ_info.action_information9,34);
1100: --
1101: IF(l_count = 1 OR rec_get_summ_info.action_information9 <> l_prev_cost_seg ) THEN
1094: l_count := l_count + 1 ;
1095: /*Check cost_seg for grouping */
1096: hr_utility.set_location('Record found',32);
1097: hr_utility.set_location('l_count'||l_count,32);
1098: hr_utility.set_location('l_prev_cost_seg'||l_prev_cost_seg,33);
1099: hr_utility.set_location('rec_get_summ_info.action_information9'||rec_get_summ_info.action_information9,34);
1100: --
1101: IF(l_count = 1 OR rec_get_summ_info.action_information9 <> l_prev_cost_seg ) THEN
1102: IF(l_count <> 1) THEN
1095: /*Check cost_seg for grouping */
1096: hr_utility.set_location('Record found',32);
1097: hr_utility.set_location('l_count'||l_count,32);
1098: hr_utility.set_location('l_prev_cost_seg'||l_prev_cost_seg,33);
1099: hr_utility.set_location('rec_get_summ_info.action_information9'||rec_get_summ_info.action_information9,34);
1100: --
1101: IF(l_count = 1 OR rec_get_summ_info.action_information9 <> l_prev_cost_seg ) THEN
1102: IF(l_count <> 1) THEN
1103: xml_tab(l_counter).TagName :='EOY_CODE_GRP_START';
1103: xml_tab(l_counter).TagName :='EOY_CODE_GRP_START';
1104: xml_tab(l_counter).TagValue :='EOY_CODE_GRP_END';
1105: l_counter := l_counter + 1;
1106: --
1107: hr_utility.set_location('l_total_cost_credit'||l_total_cost_credit,34);
1108: hr_utility.set_location('l_total_cost_credit'||l_total_cost_credit,35);
1109: --
1110: IF( l_total_cost_credit <> 0 ) THEN
1111: xml_tab(l_counter).TagName :='COST_SEG_GRP_TOT_CREDIT';
1104: xml_tab(l_counter).TagValue :='EOY_CODE_GRP_END';
1105: l_counter := l_counter + 1;
1106: --
1107: hr_utility.set_location('l_total_cost_credit'||l_total_cost_credit,34);
1108: hr_utility.set_location('l_total_cost_credit'||l_total_cost_credit,35);
1109: --
1110: IF( l_total_cost_credit <> 0 ) THEN
1111: xml_tab(l_counter).TagName :='COST_SEG_GRP_TOT_CREDIT';
1112: xml_tab(l_counter).TagValue := l_total_cost_credit;
1121:
1122: -- Added for bug fix 5244886
1123: l_total_net_credit := GREATEST(l_total_cost_credit - l_total_cost_debit,0);
1124: l_total_net_debit := GREATEST(l_total_cost_debit - l_total_cost_credit,0);
1125: hr_utility.set_location('l_total_net_credit'||l_total_net_credit,35);
1126: IF( l_total_net_credit <> 0 ) THEN
1127: xml_tab(l_counter).TagName :='COST_SEG_NET_TOT_CREDIT';
1128: xml_tab(l_counter).TagValue := l_total_net_credit;
1129: l_counter := l_counter + 1;
1127: xml_tab(l_counter).TagName :='COST_SEG_NET_TOT_CREDIT';
1128: xml_tab(l_counter).TagValue := l_total_net_credit;
1129: l_counter := l_counter + 1;
1130: END IF;
1131: hr_utility.set_location('l_total_net_debit'||l_total_net_debit,35);
1132: IF( l_total_net_debit <> 0 ) THEN
1133: xml_tab(l_counter).TagName :='COST_SEG_NET_TOT_DEBIT';
1134: xml_tab(l_counter).TagValue := l_total_net_debit;
1135: l_counter := l_counter + 1;
1155: l_counter := l_counter + 1;
1156: --
1157: /*Check eoy_code for grouping if no change in cost segments */
1158: ELSIF( l_count = 1 OR rec_get_summ_info.action_information8 <> l_prev_eoy_code ) THEN
1159: hr_utility.set_location('ELSIF',36);
1160: hr_utility.set_location('l_count'||l_count,37);
1161: IF(l_count <> 1) THEN
1162: xml_tab(l_counter).TagName :='EOY_CODE_GRP_START';
1163: xml_tab(l_counter).TagValue :='EOY_CODE_GRP_END';
1156: --
1157: /*Check eoy_code for grouping if no change in cost segments */
1158: ELSIF( l_count = 1 OR rec_get_summ_info.action_information8 <> l_prev_eoy_code ) THEN
1159: hr_utility.set_location('ELSIF',36);
1160: hr_utility.set_location('l_count'||l_count,37);
1161: IF(l_count <> 1) THEN
1162: xml_tab(l_counter).TagName :='EOY_CODE_GRP_START';
1163: xml_tab(l_counter).TagValue :='EOY_CODE_GRP_END';
1164: l_counter := l_counter + 1;
1172: xml_tab(l_counter).TagValue :='COSTING_START';
1173: l_counter := l_counter + 1;
1174:
1175: -- Suppress same Cost Flexfield value appearing in a group
1176: hr_utility.set_location('l_count'||l_count,38);
1177: hr_utility.set_location('rec_get_summ_info.action_information9'||rec_get_summ_info.action_information9,39);
1178: hr_utility.set_location('l_prev_cost_seg'||l_prev_cost_seg,40);
1179: IF( l_count = 1 OR rec_get_summ_info.action_information9 <> l_prev_cost_seg ) THEN
1180: xml_tab(l_counter).TagName :='COST_SEG';
1173: l_counter := l_counter + 1;
1174:
1175: -- Suppress same Cost Flexfield value appearing in a group
1176: hr_utility.set_location('l_count'||l_count,38);
1177: hr_utility.set_location('rec_get_summ_info.action_information9'||rec_get_summ_info.action_information9,39);
1178: hr_utility.set_location('l_prev_cost_seg'||l_prev_cost_seg,40);
1179: IF( l_count = 1 OR rec_get_summ_info.action_information9 <> l_prev_cost_seg ) THEN
1180: xml_tab(l_counter).TagName :='COST_SEG';
1181: xml_tab(l_counter).TagValue := rec_get_summ_info.action_information9;
1174:
1175: -- Suppress same Cost Flexfield value appearing in a group
1176: hr_utility.set_location('l_count'||l_count,38);
1177: hr_utility.set_location('rec_get_summ_info.action_information9'||rec_get_summ_info.action_information9,39);
1178: hr_utility.set_location('l_prev_cost_seg'||l_prev_cost_seg,40);
1179: IF( l_count = 1 OR rec_get_summ_info.action_information9 <> l_prev_cost_seg ) THEN
1180: xml_tab(l_counter).TagName :='COST_SEG';
1181: xml_tab(l_counter).TagValue := rec_get_summ_info.action_information9;
1182: l_counter := l_counter + 1;
1181: xml_tab(l_counter).TagValue := rec_get_summ_info.action_information9;
1182: l_counter := l_counter + 1;
1183: END IF;
1184: --
1185: hr_utility.set_location('EOY_CODE'||rec_get_summ_info.action_information8,41);
1186: xml_tab(l_counter).TagName :='EOY_CODE';
1187: xml_tab(l_counter).TagValue := rec_get_summ_info.action_information8;
1188: l_counter := l_counter + 1;
1189: --
1186: xml_tab(l_counter).TagName :='EOY_CODE';
1187: xml_tab(l_counter).TagValue := rec_get_summ_info.action_information8;
1188: l_counter := l_counter + 1;
1189: --
1190: hr_utility.set_location('ELE_CODE'||rec_get_summ_info.action_information12,42);
1191: xml_tab(l_counter).TagName :='ELE_CODE';
1192: xml_tab(l_counter).TagValue := rec_get_summ_info.action_information12;
1193: --
1194: IF( rec_get_summ_info.action_information12 IS NOT NULL) THEN
1195: xml_tab(l_counter).TagValue := ' ,' ||xml_tab(l_counter).TagValue;
1196: END IF;
1197: l_counter := l_counter + 1;
1198: --
1199: hr_utility.set_location('ELE_NAME'||rec_get_summ_info.action_information7,43);
1200: xml_tab(l_counter).TagName :='ELE_NAME';
1201: xml_tab(l_counter).TagValue := rec_get_summ_info.action_information7;
1202: l_counter := l_counter + 1;
1203: --
1200: xml_tab(l_counter).TagName :='ELE_NAME';
1201: xml_tab(l_counter).TagValue := rec_get_summ_info.action_information7;
1202: l_counter := l_counter + 1;
1203: --
1204: hr_utility.set_location('COST_OR_BAL'||rec_get_summ_info.action_information14,44);
1205: xml_tab(l_counter).TagName :='COST_OR_BAL';
1206: xml_tab(l_counter).TagValue :=rec_get_summ_info.action_information14;
1207: l_counter := l_counter + 1;
1208: --
1205: xml_tab(l_counter).TagName :='COST_OR_BAL';
1206: xml_tab(l_counter).TagValue :=rec_get_summ_info.action_information14;
1207: l_counter := l_counter + 1;
1208: --
1209: hr_utility.set_location('COST_DEBIT/COST_CREDIT'||fnd_number.canonical_to_number(rec_get_summ_info.action_information13),45);
1210: hr_utility.set_location('C/D'||rec_get_summ_info.action_information11,46);
1211: IF( rec_get_summ_info.action_information11 = 'D') THEN
1212: xml_tab(l_counter).TagName :='COST_DEBIT';
1213: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_summ_info.action_information13);
1206: xml_tab(l_counter).TagValue :=rec_get_summ_info.action_information14;
1207: l_counter := l_counter + 1;
1208: --
1209: hr_utility.set_location('COST_DEBIT/COST_CREDIT'||fnd_number.canonical_to_number(rec_get_summ_info.action_information13),45);
1210: hr_utility.set_location('C/D'||rec_get_summ_info.action_information11,46);
1211: IF( rec_get_summ_info.action_information11 = 'D') THEN
1212: xml_tab(l_counter).TagName :='COST_DEBIT';
1213: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_summ_info.action_information13);
1214: l_counter := l_counter + 1;
1227: l_prev_eoy_code := rec_get_summ_info.action_information8;
1228: l_prev_cost_seg := rec_get_summ_info.action_information9;
1229: --
1230: END LOOP;
1231: hr_utility.set_location('END LOOP',47);
1232: hr_utility.set_location('l_count'||l_count,48);
1233: IF(l_count = 0) THEN
1234: xml_tab(l_counter).TagName :='COST_SEG_GRP_START';
1235: xml_tab(l_counter).TagValue :='COST_SEG_GRP_START';
1228: l_prev_cost_seg := rec_get_summ_info.action_information9;
1229: --
1230: END LOOP;
1231: hr_utility.set_location('END LOOP',47);
1232: hr_utility.set_location('l_count'||l_count,48);
1233: IF(l_count = 0) THEN
1234: xml_tab(l_counter).TagName :='COST_SEG_GRP_START';
1235: xml_tab(l_counter).TagValue :='COST_SEG_GRP_START';
1236: l_counter := l_counter + 1;
1243: --
1244: xml_tab(l_counter).TagName :='EOY_CODE_GRP_START';
1245: xml_tab(l_counter).TagValue :='EOY_CODE_GRP_END';
1246: l_counter := l_counter + 1;
1247: hr_utility.set_location('l_total_cost_credit'||l_total_cost_credit,49);
1248: IF ( l_total_cost_credit <> 0 ) THEN
1249: xml_tab(l_counter).TagName :='COST_SEG_GRP_TOT_CREDIT';
1250: xml_tab(l_counter).TagValue := l_total_cost_credit;
1251: l_counter := l_counter + 1;
1249: xml_tab(l_counter).TagName :='COST_SEG_GRP_TOT_CREDIT';
1250: xml_tab(l_counter).TagValue := l_total_cost_credit;
1251: l_counter := l_counter + 1;
1252: END IF;
1253: hr_utility.set_location('l_total_cost_debit'||l_total_cost_debit,51);
1254: IF ( l_total_cost_debit <> 0 ) THEN
1255: xml_tab(l_counter).TagName :='COST_SEG_GRP_TOT_DEBIT';
1256: xml_tab(l_counter).TagValue := l_total_cost_debit;
1257: l_counter := l_counter + 1;
1259:
1260: -- Added for bug fix 5244886
1261: l_total_net_credit := GREATEST(l_total_cost_credit - l_total_cost_debit,0);
1262: l_total_net_debit := GREATEST(l_total_cost_debit - l_total_cost_credit,0);
1263: hr_utility.set_location('l_total_cost_debit'||l_total_cost_debit,51);
1264: IF( l_total_net_credit <> 0 ) THEN
1265: xml_tab(l_counter).TagName :='COST_SEG_NET_TOT_CREDIT';
1266: xml_tab(l_counter).TagValue := l_total_net_credit;
1267: l_counter := l_counter + 1;
1265: xml_tab(l_counter).TagName :='COST_SEG_NET_TOT_CREDIT';
1266: xml_tab(l_counter).TagValue := l_total_net_credit;
1267: l_counter := l_counter + 1;
1268: END IF;
1269: hr_utility.set_location('l_total_net_debit'||l_total_net_debit,52);
1270: IF( l_total_net_debit <> 0 ) THEN
1271: xml_tab(l_counter).TagName :='COST_SEG_NET_TOT_DEBIT';
1272: xml_tab(l_counter).TagValue := l_total_net_debit;
1273: l_counter := l_counter + 1;
1284: xml_tab(l_counter).TagName :='FILE_HEADER_START';
1285: xml_tab(l_counter).TagValue :='FILE_HEADER_END';
1286: l_counter := l_counter + 1;
1287:
1288: hr_utility.set_location('After populating pl/sql table',30);
1289: hr_utility.set_location('Entered Procedure GETDATA',10);
1290:
1291: WritetoCLOB (p_xml );
1292:
1285: xml_tab(l_counter).TagValue :='FILE_HEADER_END';
1286: l_counter := l_counter + 1;
1287:
1288: hr_utility.set_location('After populating pl/sql table',30);
1289: hr_utility.set_location('Entered Procedure GETDATA',10);
1290:
1291: WritetoCLOB (p_xml );
1292:
1293: END POPULATE_DATA_SUMMARY;
1382: --
1383: ELSE
1384: l_payroll_action_id := p_payroll_action_id;
1385: END IF;
1386: hr_utility.set_location('Entered Procedure GETDATA',10);
1387: --
1388: /* Get the File Header Information */
1389: OPEN csr_get_hdr_info(l_payroll_action_id);
1390: FETCH csr_get_hdr_info INTO rec_get_hdr_info;
1389: OPEN csr_get_hdr_info(l_payroll_action_id);
1390: FETCH csr_get_hdr_info INTO rec_get_hdr_info;
1391: CLOSE csr_get_hdr_info;
1392: --
1393: hr_utility.set_location('Before populating pl/sql table',20);
1394: --
1395: xml_tab(l_counter).TagName :='FILE_HEADER_START';
1396: xml_tab(l_counter).TagValue :='FILE_HEADER_START';
1397: l_counter := l_counter + 1;
1395: xml_tab(l_counter).TagName :='FILE_HEADER_START';
1396: xml_tab(l_counter).TagValue :='FILE_HEADER_START';
1397: l_counter := l_counter + 1;
1398: --
1399: hr_utility.set_location('LE_NAME'||rec_get_hdr_info.action_information7,53);
1400: xml_tab(l_counter).TagName :='LE_NAME';
1401: xml_tab(l_counter).TagValue := rec_get_hdr_info.action_information7;
1402: l_counter := l_counter + 1;
1403: --
1435: --
1436: xml_tab(l_counter).TagName :='COST_RECO_START';
1437: xml_tab(l_counter).TagValue :='COST_RECO_START';
1438: l_counter := l_counter + 1;
1439: hr_utility.set_location('HEADER INFO DONE',54);
1440: --
1441: hr_utility.set_location('CSR csr_get_det_info',55);
1442: FOR rec_get_det_info IN csr_get_det_info(l_payroll_action_id,rec_get_hdr_info.tax_unit_id)
1443: LOOP
1437: xml_tab(l_counter).TagValue :='COST_RECO_START';
1438: l_counter := l_counter + 1;
1439: hr_utility.set_location('HEADER INFO DONE',54);
1440: --
1441: hr_utility.set_location('CSR csr_get_det_info',55);
1442: FOR rec_get_det_info IN csr_get_det_info(l_payroll_action_id,rec_get_hdr_info.tax_unit_id)
1443: LOOP
1444: --
1445: /* Counter to count records fetched */
1442: FOR rec_get_det_info IN csr_get_det_info(l_payroll_action_id,rec_get_hdr_info.tax_unit_id)
1443: LOOP
1444: --
1445: /* Counter to count records fetched */
1446: hr_utility.set_location('record found csr_get_det_info',56);
1447: hr_utility.set_location('l_count'||l_count,57);
1448: l_count := l_count + 1 ;
1449: /*Check cost_seg for grouping */
1450: hr_utility.set_location('rec_get_det_info.action_information10'||rec_get_det_info.action_information10,58);
1443: LOOP
1444: --
1445: /* Counter to count records fetched */
1446: hr_utility.set_location('record found csr_get_det_info',56);
1447: hr_utility.set_location('l_count'||l_count,57);
1448: l_count := l_count + 1 ;
1449: /*Check cost_seg for grouping */
1450: hr_utility.set_location('rec_get_det_info.action_information10'||rec_get_det_info.action_information10,58);
1451: hr_utility.set_location('l_prev_cost_seg'||l_prev_cost_seg,59);
1446: hr_utility.set_location('record found csr_get_det_info',56);
1447: hr_utility.set_location('l_count'||l_count,57);
1448: l_count := l_count + 1 ;
1449: /*Check cost_seg for grouping */
1450: hr_utility.set_location('rec_get_det_info.action_information10'||rec_get_det_info.action_information10,58);
1451: hr_utility.set_location('l_prev_cost_seg'||l_prev_cost_seg,59);
1452: IF(l_count = 1 OR rec_get_det_info.action_information10 <> l_prev_cost_seg ) THEN
1453: --
1454: IF(l_count <> 1) THEN
1447: hr_utility.set_location('l_count'||l_count,57);
1448: l_count := l_count + 1 ;
1449: /*Check cost_seg for grouping */
1450: hr_utility.set_location('rec_get_det_info.action_information10'||rec_get_det_info.action_information10,58);
1451: hr_utility.set_location('l_prev_cost_seg'||l_prev_cost_seg,59);
1452: IF(l_count = 1 OR rec_get_det_info.action_information10 <> l_prev_cost_seg ) THEN
1453: --
1454: IF(l_count <> 1) THEN
1455: xml_tab(l_counter).TagName :='EOY_CODE_GRP_START';
1455: xml_tab(l_counter).TagName :='EOY_CODE_GRP_START';
1456: xml_tab(l_counter).TagValue :='EOY_CODE_GRP_END';
1457: l_counter := l_counter + 1;
1458: --
1459: hr_utility.set_location('l_total_cost_credit'||l_total_cost_credit,61);
1460: IF( l_total_cost_credit <> 0 ) THEN
1461: xml_tab(l_counter).TagName :='COST_SEG_GRP_TOT_CREDIT';
1462: xml_tab(l_counter).TagValue := l_total_cost_credit;
1463: l_counter := l_counter + 1;
1462: xml_tab(l_counter).TagValue := l_total_cost_credit;
1463: l_counter := l_counter + 1;
1464: END IF;
1465: --
1466: hr_utility.set_location('l_total_cost_debit'||l_total_cost_debit,62);
1467: IF( l_total_cost_debit <> 0 ) THEN
1468: xml_tab(l_counter).TagName :='COST_SEG_GRP_TOT_DEBIT';
1469: xml_tab(l_counter).TagValue := l_total_cost_debit;
1470: l_counter := l_counter + 1;
1487: l_counter := l_counter + 1;
1488: /*Check eoy_code for grouping if no change in cost segments */
1489: ELSIF( l_count = 1 OR rec_get_det_info.action_information9 <> l_prev_eoy_code ) THEN
1490: --
1491: hr_utility.set_location('ELSIF',63);
1492: hr_utility.set_location('l_count'||l_count,64);
1493: IF(l_count <> 1) THEN
1494: xml_tab(l_counter).TagName :='EOY_CODE_GRP_START';
1495: xml_tab(l_counter).TagValue :='EOY_CODE_GRP_END';
1488: /*Check eoy_code for grouping if no change in cost segments */
1489: ELSIF( l_count = 1 OR rec_get_det_info.action_information9 <> l_prev_eoy_code ) THEN
1490: --
1491: hr_utility.set_location('ELSIF',63);
1492: hr_utility.set_location('l_count'||l_count,64);
1493: IF(l_count <> 1) THEN
1494: xml_tab(l_counter).TagName :='EOY_CODE_GRP_START';
1495: xml_tab(l_counter).TagValue :='EOY_CODE_GRP_END';
1496: l_counter := l_counter + 1;
1505: xml_tab(l_counter).TagName :='COSTING_START';
1506: xml_tab(l_counter).TagValue :='COSTING_START';
1507: l_counter := l_counter + 1;
1508: -- Suppress same Cost Flexfield value appearing in a group
1509: hr_utility.set_location('l_count'||l_count,65);
1510: hr_utility.set_location('rec_get_det_info.action_information10'||rec_get_det_info.action_information10,66);
1511: hr_utility.set_location('l_prev_cost_seg'||l_prev_cost_seg,67);
1512: IF( l_count = 1 OR rec_get_det_info.action_information10 <> l_prev_cost_seg ) THEN
1513: xml_tab(l_counter).TagName :='COST_SEG';
1506: xml_tab(l_counter).TagValue :='COSTING_START';
1507: l_counter := l_counter + 1;
1508: -- Suppress same Cost Flexfield value appearing in a group
1509: hr_utility.set_location('l_count'||l_count,65);
1510: hr_utility.set_location('rec_get_det_info.action_information10'||rec_get_det_info.action_information10,66);
1511: hr_utility.set_location('l_prev_cost_seg'||l_prev_cost_seg,67);
1512: IF( l_count = 1 OR rec_get_det_info.action_information10 <> l_prev_cost_seg ) THEN
1513: xml_tab(l_counter).TagName :='COST_SEG';
1514: xml_tab(l_counter).TagValue := rec_get_det_info.action_information10;
1507: l_counter := l_counter + 1;
1508: -- Suppress same Cost Flexfield value appearing in a group
1509: hr_utility.set_location('l_count'||l_count,65);
1510: hr_utility.set_location('rec_get_det_info.action_information10'||rec_get_det_info.action_information10,66);
1511: hr_utility.set_location('l_prev_cost_seg'||l_prev_cost_seg,67);
1512: IF( l_count = 1 OR rec_get_det_info.action_information10 <> l_prev_cost_seg ) THEN
1513: xml_tab(l_counter).TagName :='COST_SEG';
1514: xml_tab(l_counter).TagValue := rec_get_det_info.action_information10;
1515: l_counter := l_counter + 1;
1514: xml_tab(l_counter).TagValue := rec_get_det_info.action_information10;
1515: l_counter := l_counter + 1;
1516: END IF;
1517: --
1518: hr_utility.set_location('EOY_CODE'||rec_get_det_info.action_information9,68);
1519: xml_tab(l_counter).TagName :='EOY_CODE';
1520: xml_tab(l_counter).TagValue := rec_get_det_info.action_information9;
1521: l_counter := l_counter + 1;
1522: --
1519: xml_tab(l_counter).TagName :='EOY_CODE';
1520: xml_tab(l_counter).TagValue := rec_get_det_info.action_information9;
1521: l_counter := l_counter + 1;
1522: --
1523: hr_utility.set_location('ELE_CODE'||rec_get_det_info.action_information13,69);
1524: xml_tab(l_counter).TagName :='ELE_CODE';
1525: xml_tab(l_counter).TagValue := rec_get_det_info.action_information13;
1526: --
1527: hr_utility.set_location('rec_get_det_info.action_information13'||rec_get_det_info.action_information13,71);
1523: hr_utility.set_location('ELE_CODE'||rec_get_det_info.action_information13,69);
1524: xml_tab(l_counter).TagName :='ELE_CODE';
1525: xml_tab(l_counter).TagValue := rec_get_det_info.action_information13;
1526: --
1527: hr_utility.set_location('rec_get_det_info.action_information13'||rec_get_det_info.action_information13,71);
1528: IF( rec_get_det_info.action_information13 IS NOT NULL) THEN
1529: xml_tab(l_counter).TagValue := ' ,' ||xml_tab(l_counter).TagValue;
1530: END IF;
1531: l_counter := l_counter + 1;
1529: xml_tab(l_counter).TagValue := ' ,' ||xml_tab(l_counter).TagValue;
1530: END IF;
1531: l_counter := l_counter + 1;
1532: --
1533: hr_utility.set_location('ELE_NAME'||rec_get_det_info.action_information8,72);
1534: xml_tab(l_counter).TagName :='ELE_NAME';
1535: xml_tab(l_counter).TagValue := rec_get_det_info.action_information8;
1536: l_counter := l_counter + 1;
1537: --
1534: xml_tab(l_counter).TagName :='ELE_NAME';
1535: xml_tab(l_counter).TagValue := rec_get_det_info.action_information8;
1536: l_counter := l_counter + 1;
1537: --
1538: hr_utility.set_location('ASSG_NO'||rec_get_det_info.action_information5,73);
1539: xml_tab(l_counter).TagName :='ASSG_NO';
1540: xml_tab(l_counter).TagValue := rec_get_det_info.action_information5;
1541: l_counter := l_counter + 1;
1542: --
1539: xml_tab(l_counter).TagName :='ASSG_NO';
1540: xml_tab(l_counter).TagValue := rec_get_det_info.action_information5;
1541: l_counter := l_counter + 1;
1542: --
1543: hr_utility.set_location('EMP_NAME'||rec_get_det_info.action_information17,74);
1544: xml_tab(l_counter).TagName :='EMP_NAME';
1545: xml_tab(l_counter).TagValue := rec_get_det_info.action_information17;
1546: l_counter := l_counter + 1;
1547: --
1544: xml_tab(l_counter).TagName :='EMP_NAME';
1545: xml_tab(l_counter).TagValue := rec_get_det_info.action_information17;
1546: l_counter := l_counter + 1;
1547: --
1548: hr_utility.set_location('COST_OR_BAL'||rec_get_det_info.action_information15,75);
1549: xml_tab(l_counter).TagName :='COST_OR_BAL';
1550: xml_tab(l_counter).TagValue := rec_get_det_info.action_information15;
1551: l_counter := l_counter + 1;
1552: --
1549: xml_tab(l_counter).TagName :='COST_OR_BAL';
1550: xml_tab(l_counter).TagValue := rec_get_det_info.action_information15;
1551: l_counter := l_counter + 1;
1552: --
1553: hr_utility.set_location('COST_DEBIT/COST_CREDIT'||fnd_number.canonical_to_number(rec_get_det_info.action_information14),76);
1554: hr_utility.set_location('C/D'||rec_get_det_info.action_information12,77);
1555: IF( rec_get_det_info.action_information12 = 'D') THEN
1556: xml_tab(l_counter).TagName :='COST_DEBIT';
1557: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1550: xml_tab(l_counter).TagValue := rec_get_det_info.action_information15;
1551: l_counter := l_counter + 1;
1552: --
1553: hr_utility.set_location('COST_DEBIT/COST_CREDIT'||fnd_number.canonical_to_number(rec_get_det_info.action_information14),76);
1554: hr_utility.set_location('C/D'||rec_get_det_info.action_information12,77);
1555: IF( rec_get_det_info.action_information12 = 'D') THEN
1556: xml_tab(l_counter).TagName :='COST_DEBIT';
1557: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1558: l_counter := l_counter + 1;
1562: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1563: l_counter := l_counter + 1;
1564: l_total_cost_credit := l_total_cost_credit + fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1565: END IF;
1566: hr_utility.set_location('l_total_cost_debit'||l_total_cost_debit,78);
1567: hr_utility.set_location('l_total_cost_credit'||l_total_cost_credit,79);
1568: --
1569: hr_utility.set_location('COST_EFF_DATE'||rec_get_det_info.action_information16,81);
1570: xml_tab(l_counter).TagName :='COST_EFF_DATE';
1563: l_counter := l_counter + 1;
1564: l_total_cost_credit := l_total_cost_credit + fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1565: END IF;
1566: hr_utility.set_location('l_total_cost_debit'||l_total_cost_debit,78);
1567: hr_utility.set_location('l_total_cost_credit'||l_total_cost_credit,79);
1568: --
1569: hr_utility.set_location('COST_EFF_DATE'||rec_get_det_info.action_information16,81);
1570: xml_tab(l_counter).TagName :='COST_EFF_DATE';
1571: xml_tab(l_counter).TagValue := rec_get_det_info.action_information16;
1565: END IF;
1566: hr_utility.set_location('l_total_cost_debit'||l_total_cost_debit,78);
1567: hr_utility.set_location('l_total_cost_credit'||l_total_cost_credit,79);
1568: --
1569: hr_utility.set_location('COST_EFF_DATE'||rec_get_det_info.action_information16,81);
1570: xml_tab(l_counter).TagName :='COST_EFF_DATE';
1571: xml_tab(l_counter).TagValue := rec_get_det_info.action_information16;
1572: l_counter := l_counter + 1;
1573: --
1577: --
1578: l_prev_eoy_code := rec_get_det_info.action_information9;
1579: l_prev_cost_seg := rec_get_det_info.action_information10;
1580: END LOOP;
1581: hr_utility.set_location('END LOOP',82);
1582: hr_utility.set_location('l_count'||l_count,83);
1583: --
1584: IF(l_count = 0) THEN
1585: xml_tab(l_counter).TagName :='COST_SEG_GRP_START';
1578: l_prev_eoy_code := rec_get_det_info.action_information9;
1579: l_prev_cost_seg := rec_get_det_info.action_information10;
1580: END LOOP;
1581: hr_utility.set_location('END LOOP',82);
1582: hr_utility.set_location('l_count'||l_count,83);
1583: --
1584: IF(l_count = 0) THEN
1585: xml_tab(l_counter).TagName :='COST_SEG_GRP_START';
1586: xml_tab(l_counter).TagValue :='COST_SEG_GRP_START';
1594: xml_tab(l_counter).TagName :='EOY_CODE_GRP_START';
1595: xml_tab(l_counter).TagValue :='EOY_CODE_GRP_END';
1596: l_counter := l_counter + 1;
1597: --
1598: hr_utility.set_location('l_total_cost_credit'||l_total_cost_credit,84);
1599: IF( l_total_cost_credit <> 0 ) THEN
1600: xml_tab(l_counter).TagName :='COST_SEG_GRP_TOT_CREDIT';
1601: xml_tab(l_counter).TagValue := l_total_cost_credit;
1602: l_counter := l_counter + 1;
1601: xml_tab(l_counter).TagValue := l_total_cost_credit;
1602: l_counter := l_counter + 1;
1603: END IF;
1604: --
1605: hr_utility.set_location('l_total_cost_debit'||l_total_cost_debit,85);
1606: IF( l_total_cost_debit <> 0 ) THEN
1607: xml_tab(l_counter).TagName :='COST_SEG_GRP_TOT_DEBIT';
1608: xml_tab(l_counter).TagValue := l_total_cost_debit;
1609: l_counter := l_counter + 1;
1620: xml_tab(l_counter).TagName :='FILE_HEADER_START';
1621: xml_tab(l_counter).TagValue :='FILE_HEADER_END';
1622: l_counter := l_counter + 1;
1623: --
1624: hr_utility.set_location('After populating pl/sql table',30);
1625: hr_utility.set_location('Entered Procedure GETDATA',10);
1626: --
1627: WritetoCLOB (p_xml );
1628: --
1621: xml_tab(l_counter).TagValue :='FILE_HEADER_END';
1622: l_counter := l_counter + 1;
1623: --
1624: hr_utility.set_location('After populating pl/sql table',30);
1625: hr_utility.set_location('Entered Procedure GETDATA',10);
1626: --
1627: WritetoCLOB (p_xml );
1628: --
1629: END POPULATE_DATA_DETAIL;
1648: current_index pls_integer;
1649:
1650: BEGIN
1651:
1652: hr_utility.set_location('Entering WritetoCLOB ',10);
1653:
1654:
1655: l_IANA_charset := HR_NO_UTILITY.get_IANA_charset ;
1656: l_str1 := '
1725: END IF;
1726:
1727: p_xfdf_clob := l_xfdf_string;
1728:
1729: hr_utility.set_location('Leaving WritetoCLOB ',20);
1730:
1731: EXCEPTION
1732: WHEN OTHERS then
1733: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
1729: hr_utility.set_location('Leaving WritetoCLOB ',20);
1730:
1731: EXCEPTION
1732: WHEN OTHERS then
1733: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
1734: HR_UTILITY.RAISE_ERROR;
1735: END WritetoCLOB;
1736:
1737:
1730:
1731: EXCEPTION
1732: WHEN OTHERS then
1733: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
1734: HR_UTILITY.RAISE_ERROR;
1735: END WritetoCLOB;
1736:
1737:
1738: END PAY_NO_PACCR_PKG;