[Home] [Help]
595: l_action_info_id number (15);
596: l_ovn number (15);
597: l_archive_type varchar2(3) := 'AAP';
598: l_latest_process_type varchar2(30);
599: l_ee_info_id pay_action_information.action_information_id%TYPE;
600: l_term_reason fnd_lookup_values.meaning%TYPE;
601: l_term_pay_schedule fnd_lookup_values.lookup_code%TYPE;
602: l_term_atd date;
603: l_term_lwd date;
791: + nvl(l_net_payments, 0)
792: - nvl(l_total_ee_net_deductions,0)
793: - nvl(l_court_orders, 0);
794: --
795: pay_action_information_api.create_action_information (
796: p_action_information_id => l_action_info_id
797: , p_action_context_id => p_assactid
798: , p_action_context_type => l_archive_type
799: , p_object_version_number => l_ovn
830: AND nvl(l_term_atd, sysdate) <> nvl(l_term_lwd, sysdate)
831: AND g_param_effective_date > nvl(l_term_atd, g_param_effective_date)
832: AND g_param_effective_date < nvl(l_term_lwd, g_param_effective_date)
833: AND nvl(l_totals_c7_total_pay,0) = 0 THEN
834: pay_action_information_api.update_action_information (
835: p_action_information_id => l_ee_info_id
836: ,p_object_version_number => l_ovn
837: ,p_action_information16 => 'Y');
838: end if;
880: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c10_net_advice);
881: --
882: -- Archive the bolilerplate to the running totals
883: --
884: pay_action_information_api.create_action_information(
885: p_action_information_id => l_action_info_id
886: , p_action_context_id => p_action_id
887: , p_action_context_type => l_archive_type
888: , p_object_version_number => l_ovn
920: -- Archive the bolilerplate to the Balances
921: --
922: hr_utility.set_location('Entering ' || l_proc || 'archiving balance names', 30);
923: --
924: pay_action_information_api.create_action_information (
925: p_action_information_id => l_action_info_id
926: , p_action_context_id => p_action_id
927: , p_action_context_type => l_archive_type
928: , p_object_version_number => l_ovn
1040: substr(addr.region_2,1,150) region_2,
1041: substr(addr.region_3,1,150) region_3,
1042: addr.town_or_city,
1043: addr.postal_code
1044: from pay_action_information pai,
1045: hr_locations_all addr
1046: where addr.location_id = pai.ACTION_INFORMATION2
1047: and pai.action_context_type = 'PA'
1048: and pai.action_information_category in ('FR_SOE_COMPANY_DETAILS',
1062: --
1063: -- delete any previous rows previously created - only relevent
1064: -- in the case of a retry.
1065: --
1066: Delete from pay_action_information
1067: Where action_context_id = p_payroll_Action_id
1068: And action_context_type = 'PA'
1069: And action_information_category in ('FR_SOE_COMPANY_DETAILS'
1070: ,'FR_SOE_ESTAB_INFORMATION'
1107: hr_utility.trace('Fetched urssaf ' || rec_urssaf.urssaf_name);
1108: --
1109: -- Archive the Company details, using source_id to hold context of company id
1110: --
1111: pay_action_information_api.create_action_information (
1112: p_action_information_id => l_action_info_id
1113: , p_action_context_id => p_payroll_action_id
1114: , p_action_context_type => l_archive_type
1115: , p_object_version_number => l_ovn
1148: end if;
1149: --
1150: -- Archive the Establishment details, using source_id to hold context of establishment id
1151: --
1152: pay_action_information_api.create_action_information (
1153: p_action_information_id => l_action_info_id
1154: , p_action_context_id => p_payroll_action_id
1155: , p_action_context_type => l_archive_type
1156: , p_object_version_number => l_ovn
1177: EXIT WHEN csr_addresses%NOTFOUND;
1178: --
1179: -- Archive the Address details, using source_id to hold context of the address id
1180: --
1181: pay_action_information_api.create_action_information (
1182: p_action_information_id => l_action_info_id
1183: , p_action_context_id => p_payroll_action_id
1184: , p_action_context_type => l_archive_type
1185: , p_object_version_number => l_ovn
1535: --
1536: --
1537: -- Archive the employee dates details
1538: --
1539: pay_action_information_api.create_action_information (
1540: p_action_information_id => l_action_info_id
1541: , p_action_context_id => p_assignment_action_id
1542: , p_action_context_type => l_archive_type
1543: , p_object_version_number => l_ovn
1780: close csr_ee_address;
1781: --
1782: -- Archive the employee address details
1783: --
1784: pay_action_information_api.create_action_information (
1785: p_action_information_id => l_action_info_id
1786: , p_action_context_id => p_assignment_action_id
1787: , p_action_context_type => l_archive_type
1788: , p_object_version_number => l_ovn
1841: l_coefficient_name := rec_ee_cagr_details.seg_name;
1842: --
1843: end if;
1844: if rec_ee_cagr_details.qualifier = 'GRADE' then
1845: pay_action_information_api.create_action_information (
1846: p_action_information_id => l_action_info_id
1847: , p_action_context_id => p_assignment_action_id
1848: , p_action_context_type => l_archive_type
1849: , p_object_version_number => l_ovn
1857: close csr_ee_cagr_details;
1858: --
1859: -- Now archive the ee basic details with the collectiva agreement coefficient + desc
1860: --
1861: pay_action_information_api.create_action_information (
1862: p_action_information_id => l_action_info_id
1863: , p_action_context_id => p_assignment_action_id
1864: , p_action_context_type => l_archive_type
1865: , p_object_version_number => l_ovn
1987: hr_utility.set_location('Balance 110 is ' || to_char(l_balance_value11), 110);
1988: --
1989: -- Archive the employee balances
1990: --
1991: pay_action_information_api.create_action_information (
1992: p_action_information_id => l_action_info_id
1993: , p_action_context_id => p_archive_action_id
1994: , p_action_context_type => l_archive_type
1995: , p_object_version_number => l_ovn
2060: --
2061: BEGIN
2062: FOR i in 1 .. pay_fr_pto_pkg.g_fr_payslip_info.LAST LOOP
2063: hr_utility.set_location('I loop is ' || l_proc, i);
2064: pay_action_information_api.create_action_information (
2065: p_action_information_id => l_action_info_id
2066: , p_action_context_id => p_assignment_action_id
2067: , p_action_context_type => l_archive_type
2068: , p_object_version_number => l_ovn
2170: open csr_bank(rec_bank.external_account_id);
2171: fetch csr_bank into rec_acct;
2172: close csr_bank;
2173: end if;
2174: pay_action_information_api.create_action_information (
2175: p_action_information_id => l_action_info_id
2176: ,p_action_context_id => p_assignment_action_id
2177: ,p_action_context_type => l_archive_type
2178: ,p_object_version_number => l_ovn
2259: l_loop_counter := l_loop_counter + 1;
2260: --
2261: -- Archive the Message Details
2262: --
2263: pay_action_information_api.create_action_information (
2264: p_action_information_id => l_action_info_id
2265: , p_action_context_id => p_archive_assignment_action_id
2266: , p_action_context_type => l_archive_type
2267: , p_object_version_number => l_ovn
2284: --
2285: -- archive the termination message
2286: --
2287: hr_utility.set_location('Step ' || l_proc, 55);
2288: pay_action_information_api.create_action_information (
2289: p_action_information_id => l_action_info_id
2290: ,p_action_context_id => p_archive_assignment_action_id
2291: ,p_action_context_type => l_archive_type
2292: ,p_object_version_number => l_ovn
2745: -- and sum the pay_values until the end of fetch or a new rubric is fetched.
2746: --
2747: hr_utility.set_location('context='||l_context_prefix, 30);
2748: if l_loop <> 4 and rec_results.amount <> 0 then
2749: pay_action_information_api.create_action_information (
2750: p_action_information_id => l_action_info_id
2751: , p_action_context_id => p_archive_assignment_action_id
2752: , p_action_context_type => l_archive_type
2753: , p_object_version_number => l_ovn
2772: -- dont archive process type or dates, or base units
2773: --
2774: if l_loop = 4 and l_previous_rubric <> rec_results.rubric and l_previous_rubric <> ' '
2775: and l_total_loop_court_orders <> 0 THEN
2776: pay_action_information_api.create_action_information (
2777: p_action_information_id => l_action_info_id
2778: , p_action_context_id => p_archive_assignment_action_id
2779: , p_action_context_type => l_archive_type
2780: , p_object_version_number => l_ovn
2820: --
2821: -- Write any CO fetched on the very last fetch of loop = 4
2822: --
2823: if l_loop = 4 and l_total_loop_court_orders <> 0 then
2824: pay_action_information_api.create_action_information (
2825: p_action_information_id => l_action_info_id
2826: , p_action_context_id => p_archive_assignment_action_id
2827: , p_action_context_type => l_archive_type
2828: , p_object_version_number => l_ovn
2892: ,p_action_information13 in varchar2 default null ) is
2893: --
2894: cursor csr_find_row is
2895: select action_information_id, object_version_number
2896: from pay_action_information
2897: where action_context_id = p_action_context_id
2898: and action_context_type = p_action_context_type
2899: and action_information_category = p_action_information_category
2900: and action_information1 = p_context_prefix
2900: and action_information1 = p_context_prefix
2901: and action_information2 = p_rubric
2902: and action_information3 = to_char(p_rubric_sort);
2903:
2904: l_action_info_id pay_action_information.action_information_id%TYPE;
2905: l_ovn pay_action_information.object_version_number%TYPE;
2906: --
2907: l_proc VARCHAR2(60):= g_package||' Write Archive ';
2908: --
2901: and action_information2 = p_rubric
2902: and action_information3 = to_char(p_rubric_sort);
2903:
2904: l_action_info_id pay_action_information.action_information_id%TYPE;
2905: l_ovn pay_action_information.object_version_number%TYPE;
2906: --
2907: l_proc VARCHAR2(60):= g_package||' Write Archive ';
2908: --
2909: BEGIN
2910: hr_utility.set_location('Entering ' || l_proc, 10);
2911: open csr_find_row;
2912: fetch csr_find_row into l_action_info_id, l_ovn;
2913: if csr_find_row%NOTFOUND THEN
2914: pay_action_information_api.create_action_information (
2915: p_action_information_id => l_action_info_id
2916: , p_action_context_id => p_action_context_id
2917: , p_action_context_type => p_action_context_type
2918: , p_action_information1 => p_context_prefix
2931: , p_action_information11 => p_action_information11
2932: , p_action_information12 => p_action_information12
2933: , p_action_information13 => p_action_information13);
2934: else
2935: pay_action_information_api.update_action_information (
2936: p_action_information_id => l_action_info_id
2937: -- , p_action_context_id => p_action_context_id
2938: -- , p_action_context_type => p_action_context_type
2939: , p_object_version_number => l_ovn
3303: --
3304: cursor csr_check_archive_org_address (p_payroll_action_id number) is
3305: select action_information4 name
3306: ,ppa.payroll_id payroll_id
3307: from pay_action_information pai
3308: ,pay_payroll_actions ppa
3309: where pai.action_information_category in('FR_SOE_ESTAB_INFORMATION', 'FR_SOE_COMPANY_DETAILS')
3310: and pai.action_information2 is null /* address id */
3311: and pai.action_context_id = p_payroll_action_id
3416: l_total_ee_deductions number(15,2) := 0.00;
3417: l_total_er_deductions number(15,2) := 0.00;
3418: l_total_ee_csg number(15,2) := 0.00;
3419: l_context varchar2(20) := 'FR_SOE_ELEMENTS';
3420: l_action_info_id pay_action_information.action_information_id%TYPE;
3421: l_ovn pay_action_information.object_version_number%TYPE;
3422: l_archive_type varchar2(3) := 'AAP';
3423: l_group_code fnd_lookup_values.lookup_code%TYPE;
3424: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
3417: l_total_er_deductions number(15,2) := 0.00;
3418: l_total_ee_csg number(15,2) := 0.00;
3419: l_context varchar2(20) := 'FR_SOE_ELEMENTS';
3420: l_action_info_id pay_action_information.action_information_id%TYPE;
3421: l_ovn pay_action_information.object_version_number%TYPE;
3422: l_archive_type varchar2(3) := 'AAP';
3423: l_group_code fnd_lookup_values.lookup_code%TYPE;
3424: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
3425: l_rubric fnd_lookup_values.tag%TYPE;
3961: end if;
3962:
3963: -- Write this line to the archive
3964: --
3965: pay_action_information_api.create_action_information (
3966: p_action_information_id => l_action_info_id
3967: , p_action_context_id => p_archive_assignment_action_id
3968: , p_action_context_type => l_archive_type
3969: , p_action_information1 => tbl_cxt_prefix(l_grouped_rate_ptr)