DBA Data[Home] [Help]

APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on PAY_EMP_ACTION_ARCH

Line 127: l_act_info_rec pay_emp_action_arch.act_info_rec;

123: c_proc CONSTANT VARCHAR2(61) := c_package || 'setup_payment_information';
124: c_action_information_category constant pay_action_information.action_information_category%type := 'EMPLOYEE PAYMENT INFORMATION';
125: l_pay_date_disp pay_action_information.action_information1%type;
126: l_payslip_name pay_action_information.action_information1%type;
127: l_act_info_rec pay_emp_action_arch.act_info_rec;
128: --
129: CURSOR csr_element_set_name(cp_arch_assignment_action_id NUMBER) IS
130: SELECT pes.element_set_name
131: FROM pay_element_sets pes,

Line 182: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;

178: l_act_info_rec.action_info_category := c_action_information_category;
179: l_act_info_rec.act_info1 := l_pay_date_disp;
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: -- +--------------------------------------------------------------------------+

Line 199: l_act_info_rec pay_emp_action_arch.act_info_rec;

195: c_proc CONSTANT VARCHAR2(61) := c_package || 'setup_element_information';
196: c_action_information_category constant pay_action_information.action_information_category%type := 'JP ELEMENT INFORMATION';
197: -- l_exists VARCHAR2(1);
198: -- l_payment_type hr_lookups.lookup_code%type;
199: l_act_info_rec pay_emp_action_arch.act_info_rec;
200: --
201: -- Seems to be better to store "MEANING" information
202: -- for the input_values with LOOKUP_TYPE.
203: --

Line 330: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;

326: l_act_info_rec.act_info4 := l_element_info_rec.payment_type;
327: l_act_info_rec.act_info5 := 'M';
328: l_act_info_rec.act_info6 := l_element_info_rec.result_value;
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;

Line 342: l_act_info_rec pay_emp_action_arch.act_info_rec;

338: PROCEDURE setup_net_pay_distribution(p_arch_assignment_action_id IN NUMBER)
339: IS
340: c_proc CONSTANT VARCHAR2(61) := c_package || 'setup_net_pay_distribution';
341: c_action_information_category constant pay_action_information.action_information_category%type := 'EMPLOYEE NET PAY DISTRIBUTION';
342: l_act_info_rec pay_emp_action_arch.act_info_rec;
343: --
344: cursor csr_assact(cp_arch_assignment_action_id number) is
345: select /*+ ORDERED */
346: ppaa.assignment_action_id prepay_assignment_action_id,

Line 442: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;

438: l_act_info_rec.act_info16 := fnd_number.number_to_canonical(l_rec.value);
439: -- l_act_info_rec.act_info17 := fnd_number.number_to_canonical(l_assact_rec.prepay_assignment_action_id);
440: l_act_info_rec.act_info18 := l_rec.org_payment_method_name;
441: -- Note the index starts from "0".
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);

Line 468: l_act_info_rec pay_emp_action_arch.act_info_rec;

464: l_allowance_ytd NUMBER;
465: l_taxable_ytd NUMBER;
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);

Line 496: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;

492: l_act_info_rec.act_info3 := fnd_number.number_to_canonical(l_si_prem_ytd);
493: l_act_info_rec.act_info4 := fnd_number.number_to_canonical(l_itax_ytd);
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: -- +--------------------------------------------------------------------------+

Line 506: -- pay_emp_action_arch.get_employee_other_info archives from PAY_ELEMENT_ENTRY_VALUES_F.

502: -- +--------------------------------------------------------------------------+
503: --
504: -- This procedure is to archive element which is defined at Organization EIT.
505: -- This procedure archives from PAY_RUN_RESULT_VALUES while core procedure
506: -- pay_emp_action_arch.get_employee_other_info archives from PAY_ELEMENT_ENTRY_VALUES_F.
507: -- These archived data is displayed on Further Information region.
508: -- Note: The condition to get archive data is the same as global package,
509: -- pay_emp_action_arch.get_employee_other_info.
510: --

Line 509: -- pay_emp_action_arch.get_employee_other_info.

505: -- This procedure archives from PAY_RUN_RESULT_VALUES while core procedure
506: -- pay_emp_action_arch.get_employee_other_info archives from PAY_ELEMENT_ENTRY_VALUES_F.
507: -- These archived data is displayed on Further Information region.
508: -- Note: The condition to get archive data is the same as global package,
509: -- pay_emp_action_arch.get_employee_other_info.
510: --
511: PROCEDURE setup_eit_element(
512: p_arch_assignment_action_id IN NUMBER,
513: p_organization_id IN NUMBER)

Line 523: l_act_info_rec pay_emp_action_arch.act_info_rec;

519: c_payment_type constant hr_lookups.lookup_code%type := 'F';
520: l_exists VARCHAR2(1);
521: l_organization_id number;
522: l_org_information_context hr_organization_information.org_information_context%type;
523: l_act_info_rec pay_emp_action_arch.act_info_rec;
524: l_result_value varchar2(255);
525: --
526: CURSOR csr_organization_info(
527: cp_organization_id NUMBER,

Line 631: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;

627: l_act_info_rec.act_info4 := c_payment_type;
628: l_act_info_rec.act_info5 := l_eit_element_rec.uom;
629: l_act_info_rec.act_info6 := l_eit_element_rec.result_value;
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;

Line 676: pay_emp_action_arch.initialization_process;

672: p_action_information_id => l_emp_other_info_bal_rec.action_information_id,
673: p_object_version_number => l_emp_other_info_bal_rec.object_version_number);
674: END LOOP;
675: --
676: pay_emp_action_arch.initialization_process;
677: pay_emp_action_arch.get_employee_other_info(
678: p_run_action_id => p_run_assignment_action_id,
679: p_assignment_id => null, -- used to derive element entry values
680: p_organization_id => p_organization_id,

Line 677: pay_emp_action_arch.get_employee_other_info(

673: p_object_version_number => l_emp_other_info_bal_rec.object_version_number);
674: END LOOP;
675: --
676: pay_emp_action_arch.initialization_process;
677: pay_emp_action_arch.get_employee_other_info(
678: p_run_action_id => p_run_assignment_action_id,
679: p_assignment_id => null, -- used to derive element entry values
680: p_organization_id => p_organization_id,
681: p_business_group_id => g_bg_id,

Line 684: pay_emp_action_arch.insert_rows_thro_api_process(

680: p_organization_id => p_organization_id,
681: p_business_group_id => g_bg_id,
682: p_curr_pymt_eff_date => NULL, -- used to derive element entry values
683: p_tax_unit_id => NULL); -- not used by JP legislation
684: pay_emp_action_arch.insert_rows_thro_api_process(
685: p_action_context_id => p_arch_assignment_action_id,
686: p_action_context_type => 'AAP',
687: p_assignment_id => p_arch_assignment_id,
688: p_tax_unit_id => NULL,

Line 690: p_tab_rec_data => pay_emp_action_arch.lrr_act_tab);

686: p_action_context_type => 'AAP',
687: p_assignment_id => p_arch_assignment_id,
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: */

Line 713: pay_emp_action_arch.arch_pay_action_level_data(

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,
715: p_payroll_id => g_payroll_id,
716: p_effective_date => g_payment_date);
717: --

Line 959: pay_emp_action_arch.get_personal_information(

955: -- Note EMPLOYEE NET PAY DISTRIBUTION needs to be populated without using US proc
956: -- because JP locks multiple prepayment assignment actions by 1 archive assignment action.
957: -- This is not supported by US procedure now.
958: --
959: pay_emp_action_arch.get_personal_information(
960: p_payroll_action_id => g_arch_payroll_action_id, -- archive pact (not used)
961: p_assactid => p_assignment_action_id, -- pay_action_information.action_context_id
962: p_assignment_id => l_arch_assignment_id, -- Used to archive assignment info
963: p_curr_pymt_ass_act_id => null, -- N/A (used for net pay)

Line 972: -- Clear pay_emp_action_arch.lrr_act_tab global variable

968: p_time_period_id => l_time_period_id, -- run Time Period Id
969: p_ppp_source_action_id => null, -- netpay distribution (for Separate Payment)
970: p_ytd_balcall_aaid => l_run_assignment_action_id); -- Used to archive balance. PAYMENTS dimension is not supported in JP.
971: --
972: -- Clear pay_emp_action_arch.lrr_act_tab global variable
973: --
974: pay_emp_action_arch.initialization_process;
975: --
976: -- Archive EMPLOYEE PAYMENT INFORMATION(Payslip Assignment Action Information) into global variable

Line 974: pay_emp_action_arch.initialization_process;

970: p_ytd_balcall_aaid => l_run_assignment_action_id); -- Used to archive balance. PAYMENTS dimension is not supported in JP.
971: --
972: -- Clear pay_emp_action_arch.lrr_act_tab global variable
973: --
974: pay_emp_action_arch.initialization_process;
975: --
976: -- Archive EMPLOYEE PAYMENT INFORMATION(Payslip Assignment Action Information) into global variable
977: --
978: setup_payment_information(p_arch_assignment_action_id => p_assignment_action_id);

Line 1003: pay_emp_action_arch.insert_rows_thro_api_process(

999: p_organization_id => l_organization_id);
1000: --
1001: -- Upload global variable lrr_act_tab into PAY_ACTION_INFORMATION
1002: --
1003: pay_emp_action_arch.insert_rows_thro_api_process(
1004: p_action_context_id => p_assignment_action_id,
1005: p_action_context_type => 'AAP',
1006: p_assignment_id => l_arch_assignment_id,
1007: p_tax_unit_id => null,

Line 1009: p_tab_rec_data => pay_emp_action_arch.lrr_act_tab);

1005: p_action_context_type => 'AAP',
1006: p_assignment_id => l_arch_assignment_id,
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: --

Line 1042: pay_emp_action_arch.arch_pay_action_level_data(

1038: -- initialization_code is not called. So init_globals needs to be called here also
1039: -- to guarantee that all globals are set.
1040: --
1041: init_globals(p_payroll_action_id);
1042: pay_emp_action_arch.arch_pay_action_level_data(
1043: p_payroll_action_id => p_payroll_action_id,
1044: p_payroll_id => g_payroll_id,
1045: p_effective_date => g_payment_date);
1046: end if;