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