[Home] [Help]
PACKAGE: APPS.PAY_JP_ISDF_ARCHIVE_PKG
Source
1 package pay_jp_isdf_archive_pkg as
2 /* $Header: pyjpisfc.pkh 120.1.12000000.2 2007/09/20 02:34:16 keyazawa noship $ */
3 --
4 g_archive_default_flag varchar2(1);
5 g_copy_archive_pact_id number;
6 --
7 type t_li_info_rec is record(
8 assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,
9 aei_object_version_number per_assignment_extra_info.object_version_number%type,
10 info_type hr_organization_information.org_information_context%type,
11 ins_class per_assignment_extra_info.aei_information1%type,
12 ins_comp_code per_assignment_extra_info.aei_information2%type,
13 ins_comp_name hr_organization_information.org_information2%type,
14 calc_prem_ff hr_organization_information.org_information3%type,
15 lig_prem_bal hr_organization_information.org_information4%type,
16 lig_prem_mth_ele hr_organization_information.org_information5%type,
17 lig_prem_bon_ele hr_organization_information.org_information6%type,
18 lip_prem_bal hr_organization_information.org_information7%type,
19 lip_prem_mth_ele hr_organization_information.org_information8%type,
20 lip_prem_bon_ele hr_organization_information.org_information9%type,
21 start_date date,
22 end_date date,
23 ins_type per_assignment_extra_info.aei_information5%type,
24 ins_period_start_date date,
25 ins_period per_assignment_extra_info.aei_information6%type,
26 contractor_name per_assignment_extra_info.aei_information7%type,
27 beneficiary_name per_assignment_extra_info.aei_information8%type,
28 beneficiary_relship per_assignment_extra_info.aei_information9%type,
29 linc_prem number);
30 --
31 type t_ai_info_rec is record(
32 assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,
33 aei_object_version_number per_assignment_extra_info.object_version_number%type,
34 info_type hr_organization_information.org_information_context%type,
35 ins_class per_assignment_extra_info.aei_information13%type,
36 ins_term_type per_assignment_extra_info.aei_information1%type,
37 ins_comp_code per_assignment_extra_info.aei_information2%type,
38 ins_comp_name hr_organization_information.org_information2%type,
39 calc_prem_ff hr_organization_information.org_information3%type,
40 eqi_prem_bal hr_organization_information.org_information4%type,
41 eqi_prem_mth_ele hr_organization_information.org_information5%type,
42 eqi_prem_bon_ele hr_organization_information.org_information6%type,
43 ai_prem_bal hr_organization_information.org_information7%type,
44 ai_prem_mth_ele hr_organization_information.org_information8%type,
45 ai_prem_bon_ele hr_organization_information.org_information9%type,
46 start_date date,
47 end_date date,
48 ins_type per_assignment_extra_info.aei_information5%type,
49 ins_period per_assignment_extra_info.aei_information6%type,
50 contractor_name per_assignment_extra_info.aei_information7%type,
51 beneficiary_name per_assignment_extra_info.aei_information8%type,
52 beneficiary_relship per_assignment_extra_info.aei_information9%type,
53 maturity_repayment per_assignment_extra_info.aei_information10%type,
54 annual_prem number);
55 --
56 type t_spouse_rec is record(
57 spouse_type varchar2(60),
58 widow_type varchar2(60),
59 spouse_dct_exclude varchar2(60),
60 spouse_income_entry number);
61 --
62 type t_entry_rec is record(
63 ins_entry_cnt number,
64 ins_datetrack_update_mode varchar2(60),
65 ins_element_entry_id number,
66 ins_ee_object_version_number number,
67 life_gen_ins_prem number,
68 life_pens_ins_prem number,
69 nonlife_long_ins_prem number,
70 nonlife_short_ins_prem number,
71 earthquake_ins_prem number,
72 is_entry_cnt number,
73 is_datetrack_update_mode varchar2(60),
74 is_element_entry_id number,
75 is_ee_object_version_number number,
76 social_ins_prem number,
77 mutual_aid_prem number,
78 spouse_income number,
79 sp_dct_exclude varchar2(60),
80 national_pens_ins_prem number);
81 --
82 procedure range_cursor(
83 p_payroll_action_id in number,
84 p_sqlstr out nocopy varchar2);
85 --
86 procedure assignment_action_creation(
87 p_payroll_action_id in number,
88 p_start_person_id in number,
89 p_end_person_id in number,
90 p_chunk_number in number);
91 --
92 procedure archinit(
93 p_payroll_action_id in number);
94 --
95 procedure archive_data(
96 p_assignment_action_id in number,
97 p_effective_date in date);
98 --
99 procedure deinitialize_code(
100 p_payroll_action_id in number);
101 --
102 -- init_pact,init_assact,ee_datetrack_update_mode,fetch_entry,archive_assact are called from pay_jp_isdf_ss_pkg
103 procedure init_pact(
104 p_payroll_action_id in number);
105 --
106 procedure init_assact(
107 p_assignment_action_id in number,
108 p_assignment_id in number);
109 --
110 function ee_datetrack_update_mode(
111 p_element_entry_id in number,
112 p_effective_start_date in date,
113 p_effective_end_date in date,
114 p_effective_date in date)
115 return varchar2;
116 --
117 procedure fetch_entry(
118 p_assignment_id in number,
119 p_business_group_id in number,
120 p_effective_date in date,
121 p_entry_rec out nocopy t_entry_rec);
122 --
123 procedure archive_assact(
124 p_assignment_action_id in number,
125 p_assignment_id in number);
126 --
127 end pay_jp_isdf_archive_pkg;