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_vl 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 331: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;

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

Line 343: l_act_info_rec pay_emp_action_arch.act_info_rec;

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

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

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

Line 469: l_act_info_rec pay_emp_action_arch.act_info_rec;

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

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

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

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

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

Line 510: -- pay_emp_action_arch.get_employee_other_info.

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

Line 524: l_act_info_rec pay_emp_action_arch.act_info_rec;

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

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

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

Line 677: pay_emp_action_arch.initialization_process;

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

Line 678: pay_emp_action_arch.get_employee_other_info(

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

Line 685: pay_emp_action_arch.insert_rows_thro_api_process(

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

Line 691: p_tab_rec_data => pay_emp_action_arch.lrr_act_tab);

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

Line 714: pay_emp_action_arch.arch_pay_action_level_data(

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

Line 960: pay_emp_action_arch.get_personal_information(

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

Line 973: -- Clear pay_emp_action_arch.lrr_act_tab global variable

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

Line 975: pay_emp_action_arch.initialization_process;

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

Line 1004: pay_emp_action_arch.insert_rows_thro_api_process(

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

Line 1010: p_tab_rec_data => pay_emp_action_arch.lrr_act_tab);

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

Line 1043: pay_emp_action_arch.arch_pay_action_level_data(

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