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.

[Home] [Help]

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 249: hr_utility.set_location('Entering ' || c_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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