eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on HR_UTILITY

Line 67: hr_utility.set_location('Entering ' || c_proc, 10);

63: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
64: l_start_pos number;
65: l_end_pos number;
66: begin
67: hr_utility.set_location('Entering ' || c_proc, 10);
68: --
69: -- This global variables deriving routine is only kicked
70: -- when global variables are not set.
71: -- Once populated, the following code is skipped.

Line 103: hr_utility.trace('g_arch_payroll_action_id : ' || g_arch_payroll_action_id);

99: l_end_pos := instr(l_legislative_parameters, 'PAYMENT_DATE') - 2;
100: g_payslip_label := substr(l_legislative_parameters, l_start_pos, l_end_pos - l_start_pos + 1);
101: end if;
102: --
103: hr_utility.trace('g_arch_payroll_action_id : ' || g_arch_payroll_action_id);
104: hr_utility.trace('g_bg_id : ' || g_bg_id);
105: hr_utility.trace('g_effective_date : ' || g_effective_date);
106: hr_utility.trace('g_payroll_id : ' || g_payroll_id);
107: hr_utility.trace('g_consolidation_set_id : ' || g_consolidation_set_id);

Line 104: hr_utility.trace('g_bg_id : ' || g_bg_id);

100: g_payslip_label := substr(l_legislative_parameters, l_start_pos, l_end_pos - l_start_pos + 1);
101: end if;
102: --
103: hr_utility.trace('g_arch_payroll_action_id : ' || g_arch_payroll_action_id);
104: hr_utility.trace('g_bg_id : ' || g_bg_id);
105: hr_utility.trace('g_effective_date : ' || g_effective_date);
106: hr_utility.trace('g_payroll_id : ' || g_payroll_id);
107: hr_utility.trace('g_consolidation_set_id : ' || g_consolidation_set_id);
108: hr_utility.trace('g_payment_date : ' || g_payment_date);

Line 105: hr_utility.trace('g_effective_date : ' || g_effective_date);

101: end if;
102: --
103: hr_utility.trace('g_arch_payroll_action_id : ' || g_arch_payroll_action_id);
104: hr_utility.trace('g_bg_id : ' || g_bg_id);
105: hr_utility.trace('g_effective_date : ' || g_effective_date);
106: hr_utility.trace('g_payroll_id : ' || g_payroll_id);
107: hr_utility.trace('g_consolidation_set_id : ' || g_consolidation_set_id);
108: hr_utility.trace('g_payment_date : ' || g_payment_date);
109: hr_utility.trace('g_payslip_label : ' || g_payslip_label);

Line 106: hr_utility.trace('g_payroll_id : ' || g_payroll_id);

102: --
103: hr_utility.trace('g_arch_payroll_action_id : ' || g_arch_payroll_action_id);
104: hr_utility.trace('g_bg_id : ' || g_bg_id);
105: hr_utility.trace('g_effective_date : ' || g_effective_date);
106: hr_utility.trace('g_payroll_id : ' || g_payroll_id);
107: hr_utility.trace('g_consolidation_set_id : ' || g_consolidation_set_id);
108: hr_utility.trace('g_payment_date : ' || g_payment_date);
109: hr_utility.trace('g_payslip_label : ' || g_payslip_label);
110: end if;

Line 107: hr_utility.trace('g_consolidation_set_id : ' || g_consolidation_set_id);

103: hr_utility.trace('g_arch_payroll_action_id : ' || g_arch_payroll_action_id);
104: hr_utility.trace('g_bg_id : ' || g_bg_id);
105: hr_utility.trace('g_effective_date : ' || g_effective_date);
106: hr_utility.trace('g_payroll_id : ' || g_payroll_id);
107: hr_utility.trace('g_consolidation_set_id : ' || g_consolidation_set_id);
108: hr_utility.trace('g_payment_date : ' || g_payment_date);
109: hr_utility.trace('g_payslip_label : ' || g_payslip_label);
110: end if;
111: --

Line 108: hr_utility.trace('g_payment_date : ' || g_payment_date);

104: hr_utility.trace('g_bg_id : ' || g_bg_id);
105: hr_utility.trace('g_effective_date : ' || g_effective_date);
106: hr_utility.trace('g_payroll_id : ' || g_payroll_id);
107: hr_utility.trace('g_consolidation_set_id : ' || g_consolidation_set_id);
108: hr_utility.trace('g_payment_date : ' || g_payment_date);
109: hr_utility.trace('g_payslip_label : ' || g_payslip_label);
110: end if;
111: --
112: hr_utility.set_location('Leaving ' || c_proc, 20);

Line 109: hr_utility.trace('g_payslip_label : ' || g_payslip_label);

105: hr_utility.trace('g_effective_date : ' || g_effective_date);
106: hr_utility.trace('g_payroll_id : ' || g_payroll_id);
107: hr_utility.trace('g_consolidation_set_id : ' || g_consolidation_set_id);
108: hr_utility.trace('g_payment_date : ' || g_payment_date);
109: hr_utility.trace('g_payslip_label : ' || g_payslip_label);
110: end if;
111: --
112: hr_utility.set_location('Leaving ' || c_proc, 20);
113: end init_globals;

Line 112: hr_utility.set_location('Leaving ' || c_proc, 20);

108: hr_utility.trace('g_payment_date : ' || g_payment_date);
109: hr_utility.trace('g_payslip_label : ' || g_payslip_label);
110: end if;
111: --
112: hr_utility.set_location('Leaving ' || c_proc, 20);
113: end init_globals;
114: -- +--------------------------------------------------------------------------+
115: -- |-----------------------< setup_payment_information >----------------------|
116: -- +--------------------------------------------------------------------------+

Line 144: hr_utility.set_location('Entering ' || c_proc, 10);

140: -- AND rppa.action_type = 'R'
141: AND pes.element_set_id = rppa.element_set_id
142: ORDER BY rpaa.action_sequence desc;
143: BEGIN
144: hr_utility.set_location('Entering ' || c_proc, 10);
145: --
146: -- Better to store this with canonical format and apply the following conversion
147: -- in framework, but there're many limitations for current online payslip.
148: -- Future enhancement required.

Line 173: hr_utility.trace('pay_date_disp : ' || l_pay_date_disp);

169: -- 2) element_set is not set
170: --
171: l_payslip_name := trim(l_pay_date_disp || ' ' || l_payslip_name);
172: --
173: hr_utility.trace('pay_date_disp : ' || l_pay_date_disp);
174: hr_utility.trace('payslip_name : "' || l_payslip_name || '"');
175: --
176: -- Stack information into global variable
177: --

Line 174: hr_utility.trace('payslip_name : "' || l_payslip_name || '"');

170: --
171: l_payslip_name := trim(l_pay_date_disp || ' ' || l_payslip_name);
172: --
173: hr_utility.trace('pay_date_disp : ' || l_pay_date_disp);
174: hr_utility.trace('payslip_name : "' || l_payslip_name || '"');
175: --
176: -- Stack information into global variable
177: --
178: l_act_info_rec.action_info_category := c_action_information_category;

Line 184: hr_utility.set_location('Leaving ' || c_proc, 20);

180: l_act_info_rec.act_info2 := l_payslip_name;
181: -- Note the index starts from "0".
182: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;
183: --
184: hr_utility.set_location('Leaving ' || c_proc, 20);
185: END setup_payment_information;
186: -- +--------------------------------------------------------------------------+
187: -- |-----------------------< setup_element_information >----------------------|
188: -- +--------------------------------------------------------------------------+

Line 250: hr_utility.set_location('Entering ' || c_proc, 10);

246: and cp_run_effective_date
247: between sub.effective_start_date and sub.effective_end_date;
248: */
249: BEGIN
250: hr_utility.set_location('Entering ' || c_proc, 10);
251: --
252: FOR l_element_info_rec IN csr_element_info(p_arch_assignment_action_id) LOOP
253: /*
254: --

Line 313: hr_utility.trace('action_information_category : ' || c_action_information_category);

309: l_payment_type := 'O';
310: END IF;
311: */
312: --
313: hr_utility.trace('action_information_category : ' || c_action_information_category);
314: hr_utility.trace('element_type_id : ' || to_char(l_element_info_rec.element_type_id));
315: hr_utility.trace('input_value_id : ' || to_char(l_element_info_rec.input_value_id));
316: hr_utility.trace('reporting_name : ' || l_element_info_rec.reporting_name);
317: hr_utility.trace('payment_type : ' || l_element_info_rec.payment_type);

Line 314: hr_utility.trace('element_type_id : ' || to_char(l_element_info_rec.element_type_id));

310: END IF;
311: */
312: --
313: hr_utility.trace('action_information_category : ' || c_action_information_category);
314: hr_utility.trace('element_type_id : ' || to_char(l_element_info_rec.element_type_id));
315: hr_utility.trace('input_value_id : ' || to_char(l_element_info_rec.input_value_id));
316: hr_utility.trace('reporting_name : ' || l_element_info_rec.reporting_name);
317: hr_utility.trace('payment_type : ' || l_element_info_rec.payment_type);
318: hr_utility.trace('result_value : ' || l_element_info_rec.result_value);

Line 315: hr_utility.trace('input_value_id : ' || to_char(l_element_info_rec.input_value_id));

311: */
312: --
313: hr_utility.trace('action_information_category : ' || c_action_information_category);
314: hr_utility.trace('element_type_id : ' || to_char(l_element_info_rec.element_type_id));
315: hr_utility.trace('input_value_id : ' || to_char(l_element_info_rec.input_value_id));
316: hr_utility.trace('reporting_name : ' || l_element_info_rec.reporting_name);
317: hr_utility.trace('payment_type : ' || l_element_info_rec.payment_type);
318: hr_utility.trace('result_value : ' || l_element_info_rec.result_value);
319: --

Line 316: hr_utility.trace('reporting_name : ' || l_element_info_rec.reporting_name);

312: --
313: hr_utility.trace('action_information_category : ' || c_action_information_category);
314: hr_utility.trace('element_type_id : ' || to_char(l_element_info_rec.element_type_id));
315: hr_utility.trace('input_value_id : ' || to_char(l_element_info_rec.input_value_id));
316: hr_utility.trace('reporting_name : ' || l_element_info_rec.reporting_name);
317: hr_utility.trace('payment_type : ' || l_element_info_rec.payment_type);
318: hr_utility.trace('result_value : ' || l_element_info_rec.result_value);
319: --
320: -- Stack information into global variable

Line 317: hr_utility.trace('payment_type : ' || l_element_info_rec.payment_type);

313: hr_utility.trace('action_information_category : ' || c_action_information_category);
314: hr_utility.trace('element_type_id : ' || to_char(l_element_info_rec.element_type_id));
315: hr_utility.trace('input_value_id : ' || to_char(l_element_info_rec.input_value_id));
316: hr_utility.trace('reporting_name : ' || l_element_info_rec.reporting_name);
317: hr_utility.trace('payment_type : ' || l_element_info_rec.payment_type);
318: hr_utility.trace('result_value : ' || l_element_info_rec.result_value);
319: --
320: -- Stack information into global variable
321: --

Line 318: hr_utility.trace('result_value : ' || l_element_info_rec.result_value);

314: hr_utility.trace('element_type_id : ' || to_char(l_element_info_rec.element_type_id));
315: hr_utility.trace('input_value_id : ' || to_char(l_element_info_rec.input_value_id));
316: hr_utility.trace('reporting_name : ' || l_element_info_rec.reporting_name);
317: hr_utility.trace('payment_type : ' || l_element_info_rec.payment_type);
318: hr_utility.trace('result_value : ' || l_element_info_rec.result_value);
319: --
320: -- Stack information into global variable
321: --
322: l_act_info_rec.assignment_id := l_element_info_rec.assignment_id;

Line 334: hr_utility.set_location('Leaving ' || c_proc, 20);

330: -- Note the index starts from "0".
331: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;
332: END LOOP;
333: --
334: hr_utility.set_location('Leaving ' || c_proc, 20);
335: END setup_element_information;
336: -- +--------------------------------------------------------------------------+
337: -- |----------------------< setup_net_pay_distribution >----------------------|
338: -- +--------------------------------------------------------------------------+

Line 416: hr_utility.set_location('Entering ' || c_proc, 10);

412: and bnk.bank_code(+) = pea.segment1
413: and bch.bank_code(+) = pea.segment1
414: and bch.branch_code(+) = pea.segment4;
415: BEGIN
416: hr_utility.set_location('Entering ' || c_proc, 10);
417: --
418: for l_assact_rec in csr_assact(p_arch_assignment_action_id) loop
419: for l_rec in csr_payment(l_assact_rec.prepay_assignment_action_id, l_assact_rec.prepay_effective_date) loop
420: --

Line 447: hr_utility.set_location('Leaving ' || c_proc, 20);

443: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;
444: end loop;
445: end loop;
446: --
447: hr_utility.set_location('Leaving ' || c_proc, 20);
448: END setup_net_pay_distribution;
449: -- +--------------------------------------------------------------------------+
450: -- |---------------------------< setup_ytd_amount >---------------------------|
451: -- +--------------------------------------------------------------------------+

Line 471: hr_utility.set_location('Entering ' || c_proc, 10);

467: l_si_prem_ytd NUMBER;
468: l_itax_ytd NUMBER;
469: l_act_info_rec pay_emp_action_arch.act_info_rec;
470: BEGIN
471: hr_utility.set_location('Entering ' || c_proc, 10);
472: --
473: l_allowance_ytd := pay_balance_pkg.get_value(c_ytd_allowance_def_bal_id, p_run_assignment_action_id);
474: l_taxable_ytd := pay_balance_pkg.get_value(c_ytd_sal_taxable_def_bal_id, p_run_assignment_action_id)
475: + pay_balance_pkg.get_value(c_ytd_mat_taxable_def_bal_id, p_run_assignment_action_id);

Line 480: hr_utility.trace('action_information_category : ' || c_action_information_category);

476: l_si_prem_ytd := pay_balance_pkg.get_value(c_ytd_si_prem_def_bal_id, p_run_assignment_action_id);
477: l_itax_ytd := pay_balance_pkg.get_value(c_ytd_itax_def_bal_id, p_run_assignment_action_id)
478: + pay_balance_pkg.get_value(c_ytd_yea_itax_def_bal_id, p_run_assignment_action_id);
479: --
480: hr_utility.trace('action_information_category : ' || c_action_information_category);
481: hr_utility.trace('allowance_ytd : ' || to_char(l_allowance_ytd));
482: hr_utility.trace('taxable_ytd : ' || to_char(l_taxable_ytd));
483: hr_utility.trace('si_prem_ytd : ' || to_char(l_si_prem_ytd));
484: hr_utility.trace('itax_ytd : ' || to_char(l_itax_ytd));

Line 481: hr_utility.trace('allowance_ytd : ' || to_char(l_allowance_ytd));

477: l_itax_ytd := pay_balance_pkg.get_value(c_ytd_itax_def_bal_id, p_run_assignment_action_id)
478: + pay_balance_pkg.get_value(c_ytd_yea_itax_def_bal_id, p_run_assignment_action_id);
479: --
480: hr_utility.trace('action_information_category : ' || c_action_information_category);
481: hr_utility.trace('allowance_ytd : ' || to_char(l_allowance_ytd));
482: hr_utility.trace('taxable_ytd : ' || to_char(l_taxable_ytd));
483: hr_utility.trace('si_prem_ytd : ' || to_char(l_si_prem_ytd));
484: hr_utility.trace('itax_ytd : ' || to_char(l_itax_ytd));
485: hr_utility.trace('run_effective_date : ' || to_char(p_run_effective_date));

Line 482: hr_utility.trace('taxable_ytd : ' || to_char(l_taxable_ytd));

478: + pay_balance_pkg.get_value(c_ytd_yea_itax_def_bal_id, p_run_assignment_action_id);
479: --
480: hr_utility.trace('action_information_category : ' || c_action_information_category);
481: hr_utility.trace('allowance_ytd : ' || to_char(l_allowance_ytd));
482: hr_utility.trace('taxable_ytd : ' || to_char(l_taxable_ytd));
483: hr_utility.trace('si_prem_ytd : ' || to_char(l_si_prem_ytd));
484: hr_utility.trace('itax_ytd : ' || to_char(l_itax_ytd));
485: hr_utility.trace('run_effective_date : ' || to_char(p_run_effective_date));
486: --

Line 483: hr_utility.trace('si_prem_ytd : ' || to_char(l_si_prem_ytd));

479: --
480: hr_utility.trace('action_information_category : ' || c_action_information_category);
481: hr_utility.trace('allowance_ytd : ' || to_char(l_allowance_ytd));
482: hr_utility.trace('taxable_ytd : ' || to_char(l_taxable_ytd));
483: hr_utility.trace('si_prem_ytd : ' || to_char(l_si_prem_ytd));
484: hr_utility.trace('itax_ytd : ' || to_char(l_itax_ytd));
485: hr_utility.trace('run_effective_date : ' || to_char(p_run_effective_date));
486: --
487: -- Stack information into global variable

Line 484: hr_utility.trace('itax_ytd : ' || to_char(l_itax_ytd));

480: hr_utility.trace('action_information_category : ' || c_action_information_category);
481: hr_utility.trace('allowance_ytd : ' || to_char(l_allowance_ytd));
482: hr_utility.trace('taxable_ytd : ' || to_char(l_taxable_ytd));
483: hr_utility.trace('si_prem_ytd : ' || to_char(l_si_prem_ytd));
484: hr_utility.trace('itax_ytd : ' || to_char(l_itax_ytd));
485: hr_utility.trace('run_effective_date : ' || to_char(p_run_effective_date));
486: --
487: -- Stack information into global variable
488: --

Line 485: hr_utility.trace('run_effective_date : ' || to_char(p_run_effective_date));

481: hr_utility.trace('allowance_ytd : ' || to_char(l_allowance_ytd));
482: hr_utility.trace('taxable_ytd : ' || to_char(l_taxable_ytd));
483: hr_utility.trace('si_prem_ytd : ' || to_char(l_si_prem_ytd));
484: hr_utility.trace('itax_ytd : ' || to_char(l_itax_ytd));
485: hr_utility.trace('run_effective_date : ' || to_char(p_run_effective_date));
486: --
487: -- Stack information into global variable
488: --
489: l_act_info_rec.assignment_id := p_run_assignment_id;

Line 499: hr_utility.set_location('Leaving ' || c_proc, 20);

495: l_act_info_rec.act_info5 := fnd_date.date_to_canonical(p_run_effective_date); -- Not used
496: -- Note the index starts from "0".
497: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;
498: --
499: hr_utility.set_location('Leaving ' || c_proc, 20);
500: END setup_ytd_amount;
501: -- +--------------------------------------------------------------------------+
502: -- |--------------------------< setup_eit_element >---------------------------|
503: -- +--------------------------------------------------------------------------+

Line 578: hr_utility.set_location('Entering ' || c_proc, 10);

574: between piv.effective_start_date and piv.effective_end_date
575: AND prrv.input_value_id = piv.input_value_id
576: AND prrv.run_result_id = prr.run_result_id;
577: BEGIN
578: hr_utility.set_location('Entering ' || c_proc, 10);
579: --
580: -- Check whether "ELEMENT" org_information_type is set at HR organization level.
581: -- If exists, "ELEMENT" org_information_type at only HR organization level is used,
582: -- and "ELEMENT" org_information_type at BG level is ignored.

Line 596: hr_utility.trace('action_information_category : ' || c_action_information_category);

592: END IF;
593: CLOSE csr_organization_info;
594: --
595: FOR l_eit_element_rec IN csr_eit_element(p_arch_assignment_action_id, l_organization_id, l_org_information_context) LOOP
596: hr_utility.trace('action_information_category : ' || c_action_information_category);
597: hr_utility.trace('element_type_id : ' || l_eit_element_rec.element_type_id);
598: hr_utility.trace('input_value_id : ' || l_eit_element_rec.input_value_id);
599: hr_utility.trace('reporting_name : ' || l_eit_element_rec.reporting_name);
600: hr_utility.trace('payment_type : ' || c_payment_type);

Line 597: hr_utility.trace('element_type_id : ' || l_eit_element_rec.element_type_id);

593: CLOSE csr_organization_info;
594: --
595: FOR l_eit_element_rec IN csr_eit_element(p_arch_assignment_action_id, l_organization_id, l_org_information_context) LOOP
596: hr_utility.trace('action_information_category : ' || c_action_information_category);
597: hr_utility.trace('element_type_id : ' || l_eit_element_rec.element_type_id);
598: hr_utility.trace('input_value_id : ' || l_eit_element_rec.input_value_id);
599: hr_utility.trace('reporting_name : ' || l_eit_element_rec.reporting_name);
600: hr_utility.trace('payment_type : ' || c_payment_type);
601: hr_utility.trace('uom : ' || l_eit_element_rec.uom);

Line 598: hr_utility.trace('input_value_id : ' || l_eit_element_rec.input_value_id);

594: --
595: FOR l_eit_element_rec IN csr_eit_element(p_arch_assignment_action_id, l_organization_id, l_org_information_context) LOOP
596: hr_utility.trace('action_information_category : ' || c_action_information_category);
597: hr_utility.trace('element_type_id : ' || l_eit_element_rec.element_type_id);
598: hr_utility.trace('input_value_id : ' || l_eit_element_rec.input_value_id);
599: hr_utility.trace('reporting_name : ' || l_eit_element_rec.reporting_name);
600: hr_utility.trace('payment_type : ' || c_payment_type);
601: hr_utility.trace('uom : ' || l_eit_element_rec.uom);
602: hr_utility.trace('result_value : ' || l_eit_element_rec.result_value);

Line 599: hr_utility.trace('reporting_name : ' || l_eit_element_rec.reporting_name);

595: FOR l_eit_element_rec IN csr_eit_element(p_arch_assignment_action_id, l_organization_id, l_org_information_context) LOOP
596: hr_utility.trace('action_information_category : ' || c_action_information_category);
597: hr_utility.trace('element_type_id : ' || l_eit_element_rec.element_type_id);
598: hr_utility.trace('input_value_id : ' || l_eit_element_rec.input_value_id);
599: hr_utility.trace('reporting_name : ' || l_eit_element_rec.reporting_name);
600: hr_utility.trace('payment_type : ' || c_payment_type);
601: hr_utility.trace('uom : ' || l_eit_element_rec.uom);
602: hr_utility.trace('result_value : ' || l_eit_element_rec.result_value);
603: --

Line 600: hr_utility.trace('payment_type : ' || c_payment_type);

596: hr_utility.trace('action_information_category : ' || c_action_information_category);
597: hr_utility.trace('element_type_id : ' || l_eit_element_rec.element_type_id);
598: hr_utility.trace('input_value_id : ' || l_eit_element_rec.input_value_id);
599: hr_utility.trace('reporting_name : ' || l_eit_element_rec.reporting_name);
600: hr_utility.trace('payment_type : ' || c_payment_type);
601: hr_utility.trace('uom : ' || l_eit_element_rec.uom);
602: hr_utility.trace('result_value : ' || l_eit_element_rec.result_value);
603: --
604: -- If input value is either "LookupType" or "ValueSet",

Line 601: hr_utility.trace('uom : ' || l_eit_element_rec.uom);

597: hr_utility.trace('element_type_id : ' || l_eit_element_rec.element_type_id);
598: hr_utility.trace('input_value_id : ' || l_eit_element_rec.input_value_id);
599: hr_utility.trace('reporting_name : ' || l_eit_element_rec.reporting_name);
600: hr_utility.trace('payment_type : ' || c_payment_type);
601: hr_utility.trace('uom : ' || l_eit_element_rec.uom);
602: hr_utility.trace('result_value : ' || l_eit_element_rec.result_value);
603: --
604: -- If input value is either "LookupType" or "ValueSet",
605: -- decode the value to meaning.

Line 602: hr_utility.trace('result_value : ' || l_eit_element_rec.result_value);

598: hr_utility.trace('input_value_id : ' || l_eit_element_rec.input_value_id);
599: hr_utility.trace('reporting_name : ' || l_eit_element_rec.reporting_name);
600: hr_utility.trace('payment_type : ' || c_payment_type);
601: hr_utility.trace('uom : ' || l_eit_element_rec.uom);
602: hr_utility.trace('result_value : ' || l_eit_element_rec.result_value);
603: --
604: -- If input value is either "LookupType" or "ValueSet",
605: -- decode the value to meaning.
606: --

Line 635: hr_utility.set_location('Leaving ' || c_proc, 20);

631: -- Note the index starts from "0".
632: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;
633: END LOOP;
634: --
635: hr_utility.set_location('Leaving ' || c_proc, 20);
636: END setup_eit_element;
637: /*
638: -- +--------------------------------------------------------------------------+
639: -- |--------------------------< setup_eit_balance >---------------------------|

Line 665: hr_utility.set_location('Entering ' || c_proc, 10);

661: AND pai.action_context_type = 'AAP'
662: AND pai.action_information_category = 'EMPLOYEE OTHER INFORMATION'
663: AND pai.action_information2 = 'BALANCE';
664: BEGIN
665: hr_utility.set_location('Entering ' || c_proc, 10);
666: --
667: -- Delete balances which has archived in get_personal_information procedure
668: -- because balances archived are based on prepay assact, not run assact,
669: -- which means only balances with "_PAYMENTS" dimensions are archived.

Line 693: hr_utility.set_location('Leaving ' || c_proc, 20);

689: p_tax_unit_id => NULL,
690: p_curr_pymt_eff_date => g_payment_date,
691: p_tab_rec_data => pay_emp_action_arch.lrr_act_tab);
692: --
693: hr_utility.set_location('Leaving ' || c_proc, 20);
694: END setup_eit_balance;
695: */
696: -- +--------------------------------------------------------------------------+
697: -- |-----------------------------< range_cursor >-----------------------------|

Line 711: hr_utility.set_location('Entering ' || c_proc, 10);

707: p_sqlstr OUT NOCOPY VARCHAR2)
708: IS
709: c_proc CONSTANT VARCHAR2(61):= c_package || 'range_cursor';
710: BEGIN
711: hr_utility.set_location('Entering ' || c_proc, 10);
712: --
713: init_globals(p_payroll_action_id);
714: pay_emp_action_arch.arch_pay_action_level_data(
715: p_payroll_action_id => p_payroll_action_id,

Line 727: hr_utility.set_location('Leaving ' || c_proc, 20);

723: WHERE ppa.payroll_action_id = :payroll_action_id
724: AND ppa.business_group_id + 0 = per.business_group_id
725: ORDER BY per.person_id';
726: --
727: hr_utility.set_location('Leaving ' || c_proc, 20);
728: END range_cursor;
729: -- +--------------------------------------------------------------------------+
730: -- |---------------------------< action_creation >----------------------------|
731: -- +--------------------------------------------------------------------------+

Line 816: hr_utility.set_location('Entering ' || c_proc, 10);

812: AND vppa.action_type = 'V')
813: ORDER BY ppaa.assignment_id, ppaa.assignment_action_id
814: FOR UPDATE OF paaf.assignment_id;
815: BEGIN
816: hr_utility.set_location('Entering ' || c_proc, 10);
817: --
818: init_globals(p_payroll_action_id);
819: --
820: FOR l_asg_rec IN csr_asg(

Line 837: hr_utility.trace('inserting into PAY_ASSIGNMENT_ACTIONS');

833: FROM dual;
834: --
835: -- create an archive assignment action for the master assignment action
836: --
837: hr_utility.trace('inserting into PAY_ASSIGNMENT_ACTIONS');
838: hr_utility.trace('arch_assignmen_action_id : ' || to_char(l_arch_assignment_action_id));
839: hr_utility.trace('arch_assignment_id : ' || to_char(l_asg_rec.prepay_assignment_id));
840: --
841: hr_nonrun_asact.insact(l_arch_assignment_action_id, l_asg_rec.prepay_assignment_id, p_payroll_action_id, p_chunk, NULL);

Line 838: hr_utility.trace('arch_assignmen_action_id : ' || to_char(l_arch_assignment_action_id));

834: --
835: -- create an archive assignment action for the master assignment action
836: --
837: hr_utility.trace('inserting into PAY_ASSIGNMENT_ACTIONS');
838: hr_utility.trace('arch_assignmen_action_id : ' || to_char(l_arch_assignment_action_id));
839: hr_utility.trace('arch_assignment_id : ' || to_char(l_asg_rec.prepay_assignment_id));
840: --
841: hr_nonrun_asact.insact(l_arch_assignment_action_id, l_asg_rec.prepay_assignment_id, p_payroll_action_id, p_chunk, NULL);
842: END IF;

Line 839: hr_utility.trace('arch_assignment_id : ' || to_char(l_asg_rec.prepay_assignment_id));

835: -- create an archive assignment action for the master assignment action
836: --
837: hr_utility.trace('inserting into PAY_ASSIGNMENT_ACTIONS');
838: hr_utility.trace('arch_assignmen_action_id : ' || to_char(l_arch_assignment_action_id));
839: hr_utility.trace('arch_assignment_id : ' || to_char(l_asg_rec.prepay_assignment_id));
840: --
841: hr_nonrun_asact.insact(l_arch_assignment_action_id, l_asg_rec.prepay_assignment_id, p_payroll_action_id, p_chunk, NULL);
842: END IF;
843: --

Line 852: hr_utility.trace('inserting into PAY_ACTION_INTERLOCKS (PREPAY)');

848: --
849: -- create an archive to payroll master assignment action interlock and create an archive to
850: -- prepayment assignment action interlock
851: --
852: hr_utility.trace('inserting into PAY_ACTION_INTERLOCKS (PREPAY)');
853: hr_utility.trace('locking_action_id : ' || to_char(l_arch_assignment_action_id));
854: hr_utility.trace('locked_action_id : ' || to_char(l_asg_rec.prepay_assignment_action_id));
855: --
856: hr_nonrun_asact.insint(l_arch_assignment_action_id, l_asg_rec.prepay_assignment_action_id);

Line 853: hr_utility.trace('locking_action_id : ' || to_char(l_arch_assignment_action_id));

849: -- create an archive to payroll master assignment action interlock and create an archive to
850: -- prepayment assignment action interlock
851: --
852: hr_utility.trace('inserting into PAY_ACTION_INTERLOCKS (PREPAY)');
853: hr_utility.trace('locking_action_id : ' || to_char(l_arch_assignment_action_id));
854: hr_utility.trace('locked_action_id : ' || to_char(l_asg_rec.prepay_assignment_action_id));
855: --
856: hr_nonrun_asact.insint(l_arch_assignment_action_id, l_asg_rec.prepay_assignment_action_id);
857: END IF;

Line 854: hr_utility.trace('locked_action_id : ' || to_char(l_asg_rec.prepay_assignment_action_id));

850: -- prepayment assignment action interlock
851: --
852: hr_utility.trace('inserting into PAY_ACTION_INTERLOCKS (PREPAY)');
853: hr_utility.trace('locking_action_id : ' || to_char(l_arch_assignment_action_id));
854: hr_utility.trace('locked_action_id : ' || to_char(l_asg_rec.prepay_assignment_action_id));
855: --
856: hr_nonrun_asact.insint(l_arch_assignment_action_id, l_asg_rec.prepay_assignment_action_id);
857: END IF;
858: --

Line 859: hr_utility.trace('inserting into PAY_ACTION_INTERLOCKS (RUN)');

855: --
856: hr_nonrun_asact.insint(l_arch_assignment_action_id, l_asg_rec.prepay_assignment_action_id);
857: END IF;
858: --
859: hr_utility.trace('inserting into PAY_ACTION_INTERLOCKS (RUN)');
860: hr_utility.trace('locking_action_id : ' || to_char(l_arch_assignment_action_id));
861: hr_utility.trace('locked_action_id : ' || to_char(l_asg_rec.run_assignment_action_id));
862: --
863: hr_nonrun_asact.insint(l_arch_assignment_action_id, l_asg_rec.run_assignment_action_id);

Line 860: hr_utility.trace('locking_action_id : ' || to_char(l_arch_assignment_action_id));

856: hr_nonrun_asact.insint(l_arch_assignment_action_id, l_asg_rec.prepay_assignment_action_id);
857: END IF;
858: --
859: hr_utility.trace('inserting into PAY_ACTION_INTERLOCKS (RUN)');
860: hr_utility.trace('locking_action_id : ' || to_char(l_arch_assignment_action_id));
861: hr_utility.trace('locked_action_id : ' || to_char(l_asg_rec.run_assignment_action_id));
862: --
863: hr_nonrun_asact.insint(l_arch_assignment_action_id, l_asg_rec.run_assignment_action_id);
864: --

Line 861: hr_utility.trace('locked_action_id : ' || to_char(l_asg_rec.run_assignment_action_id));

857: END IF;
858: --
859: hr_utility.trace('inserting into PAY_ACTION_INTERLOCKS (RUN)');
860: hr_utility.trace('locking_action_id : ' || to_char(l_arch_assignment_action_id));
861: hr_utility.trace('locked_action_id : ' || to_char(l_asg_rec.run_assignment_action_id));
862: --
863: hr_nonrun_asact.insint(l_arch_assignment_action_id, l_asg_rec.run_assignment_action_id);
864: --
865: l_prepay_assignment_id := l_asg_rec.prepay_assignment_id;

Line 869: hr_utility.set_location('Leaving ' || c_proc, 20);

865: l_prepay_assignment_id := l_asg_rec.prepay_assignment_id;
866: l_prepay_assignment_action_id := l_asg_rec.prepay_assignment_action_id;
867: END LOOP;
868: --
869: hr_utility.set_location('Leaving ' || c_proc, 20);
870: END action_creation;
871: -- +--------------------------------------------------------------------------+
872: -- |------------------------------< arch_init >-------------------------------|
873: -- +--------------------------------------------------------------------------+

Line 881: hr_utility.set_location('Entering ' || c_proc, 10);

877: PROCEDURE archinit(p_payroll_action_id IN NUMBER)
878: IS
879: c_proc CONSTANT VARCHAR2(61):= c_package || 'archinit';
880: BEGIN
881: hr_utility.set_location('Entering ' || c_proc, 10);
882: --
883: init_globals(p_payroll_action_id);
884: --
885: hr_utility.set_location('Leaving ' || c_proc, 20);

Line 885: hr_utility.set_location('Leaving ' || c_proc, 20);

881: hr_utility.set_location('Entering ' || c_proc, 10);
882: --
883: init_globals(p_payroll_action_id);
884: --
885: hr_utility.set_location('Leaving ' || c_proc, 20);
886: END archinit;
887: -- +--------------------------------------------------------------------------+
888: -- |-----------------------------< archive_code >-----------------------------|
889: -- +--------------------------------------------------------------------------+

Line 905: hr_utility.set_location('Entering ' || c_proc, 10);

901: l_run_effective_date DATE;
902: l_time_period_id NUMBER;
903: l_organization_id NUMBER;
904: BEGIN
905: hr_utility.set_location('Entering ' || c_proc, 10);
906: --
907: -- Here derives the latest RUN assignment action information
908: -- locked by current archive assignment action.
909: --

Line 948: hr_utility.trace('run_assignment_action_id : ' || to_char(l_run_assignment_action_id));

944: and rpaa2.action_sequence > rpaa.action_sequence
945: and rppa2.payroll_action_id = rpaa2.payroll_action_id
946: and rppa2.action_type in ('R', 'Q', 'B'));
947: --
948: hr_utility.trace('run_assignment_action_id : ' || to_char(l_run_assignment_action_id));
949: hr_utility.trace('run_assignment_id : ' || to_char(l_run_assignment_id));
950: hr_utility.trace('run_effective_date : ' || to_char(l_run_effective_date));
951: hr_utility.trace('time_period_id : ' || to_char(l_time_period_id));
952: hr_utility.trace('organization_id : ' || to_char(l_organization_id));

Line 949: hr_utility.trace('run_assignment_id : ' || to_char(l_run_assignment_id));

945: and rppa2.payroll_action_id = rpaa2.payroll_action_id
946: and rppa2.action_type in ('R', 'Q', 'B'));
947: --
948: hr_utility.trace('run_assignment_action_id : ' || to_char(l_run_assignment_action_id));
949: hr_utility.trace('run_assignment_id : ' || to_char(l_run_assignment_id));
950: hr_utility.trace('run_effective_date : ' || to_char(l_run_effective_date));
951: hr_utility.trace('time_period_id : ' || to_char(l_time_period_id));
952: hr_utility.trace('organization_id : ' || to_char(l_organization_id));
953: --

Line 950: hr_utility.trace('run_effective_date : ' || to_char(l_run_effective_date));

946: and rppa2.action_type in ('R', 'Q', 'B'));
947: --
948: hr_utility.trace('run_assignment_action_id : ' || to_char(l_run_assignment_action_id));
949: hr_utility.trace('run_assignment_id : ' || to_char(l_run_assignment_id));
950: hr_utility.trace('run_effective_date : ' || to_char(l_run_effective_date));
951: hr_utility.trace('time_period_id : ' || to_char(l_time_period_id));
952: hr_utility.trace('organization_id : ' || to_char(l_organization_id));
953: --
954: -- call generic procedure to retrieve and archive all data for

Line 951: hr_utility.trace('time_period_id : ' || to_char(l_time_period_id));

947: --
948: hr_utility.trace('run_assignment_action_id : ' || to_char(l_run_assignment_action_id));
949: hr_utility.trace('run_assignment_id : ' || to_char(l_run_assignment_id));
950: hr_utility.trace('run_effective_date : ' || to_char(l_run_effective_date));
951: hr_utility.trace('time_period_id : ' || to_char(l_time_period_id));
952: hr_utility.trace('organization_id : ' || to_char(l_organization_id));
953: --
954: -- call generic procedure to retrieve and archive all data for
955: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE OTHER INFORMATION(only balances).

Line 952: hr_utility.trace('organization_id : ' || to_char(l_organization_id));

948: hr_utility.trace('run_assignment_action_id : ' || to_char(l_run_assignment_action_id));
949: hr_utility.trace('run_assignment_id : ' || to_char(l_run_assignment_id));
950: hr_utility.trace('run_effective_date : ' || to_char(l_run_effective_date));
951: hr_utility.trace('time_period_id : ' || to_char(l_time_period_id));
952: hr_utility.trace('organization_id : ' || to_char(l_organization_id));
953: --
954: -- call generic procedure to retrieve and archive all data for
955: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE OTHER INFORMATION(only balances).
956: -- Note EMPLOYEE NET PAY DISTRIBUTION needs to be populated without using US proc

Line 1012: hr_utility.set_location('Leaving ' || c_proc, 20);

1008: p_tax_unit_id => null,
1009: p_curr_pymt_eff_date => l_run_effective_date,
1010: p_tab_rec_data => pay_emp_action_arch.lrr_act_tab);
1011: --
1012: hr_utility.set_location('Leaving ' || c_proc, 20);
1013: END archive_code;
1014: --
1015: PROCEDURE deinitialization_code (p_payroll_action_id IN NUMBER)
1016: IS