PACKAGE: APPS.PAY_JP_ITWB_ARCHIVE_PKG

Source

1 package pay_jp_itwb_archive_pkg AUTHID CURRENT_USER as
2 /* $Header: pyjpiwbc.pkh 120.0 2011/04/08 10:10:57 keyazawa noship $ */
3 --
4 g_detail_debug   varchar2(1);
5 --
6 g_use_arch        varchar2(1);
7 g_arch_pact_exist varchar2(1);
8 g_upd_force       varchar2(1);
9 --
10 g_ass_set_formula_id number;
11 g_ass_set_amendment_type hr_assignment_set_amendments.include_or_exclude%type;
12 --
13 g_org_cust_proc     varchar2(150);
14 g_dpnt_ref_dec_flag varchar2(1);
15 --
16 g_payroll_action_id     number;
17 g_effective_date        date;
18 g_effective_soy         date;
19 g_effective_eoy         date;
20 g_effective_som         date;
21 g_effective_eom         date;
22 g_business_group_id     number;
23 g_legislation_code      per_business_groups.legislation_code%type;
24 g_arch_option           varchar2(30);
25 g_itax_organization_id  number;
26 g_payroll_id            number;
27 g_assignment_set_id     number;
28 g_payroll_action_id_o   number;
29 g_archive_sequence_o    number;
30 g_bg_itax_dpnt_ref_type varchar2(150);
31 --
32 g_commit_cnt number := 1000;
33 --
34 g_cust_assignment_id  number;
35 g_cust_effective_date date;
36 g_cust_date_earned    date;
37 --
38 g_cust_txt_information1  varchar2(240);
39 g_cust_txt_information2  varchar2(240);
40 g_cust_txt_information3  varchar2(240);
41 g_cust_txt_information4  varchar2(240);
42 g_cust_txt_information5  varchar2(240);
43 g_cust_txt_information6  varchar2(240);
44 g_cust_txt_information7  varchar2(240);
45 g_cust_txt_information8  varchar2(240);
46 g_cust_txt_information9  varchar2(240);
47 g_cust_txt_information10 varchar2(240);
48 g_cust_txt_information11 varchar2(240);
49 g_cust_txt_information12 varchar2(240);
50 g_cust_txt_information13 varchar2(240);
51 g_cust_txt_information14 varchar2(240);
52 g_cust_txt_information15 varchar2(240);
53 g_cust_txt_information16 varchar2(240);
54 g_cust_txt_information17 varchar2(240);
55 g_cust_txt_information18 varchar2(240);
56 g_cust_txt_information19 varchar2(240);
57 g_cust_txt_information20 varchar2(240);
58 g_cust_txt_information21 varchar2(240);
59 g_cust_txt_information22 varchar2(240);
60 g_cust_txt_information23 varchar2(240);
61 g_cust_txt_information24 varchar2(240);
62 g_cust_txt_information25 varchar2(240);
63 --
64 g_cust_date_information1  date;
65 g_cust_date_information2  date;
66 g_cust_date_information3  date;
67 g_cust_date_information4  date;
68 g_cust_date_information5  date;
69 g_cust_date_information6  date;
70 g_cust_date_information7  date;
71 g_cust_date_information8  date;
72 g_cust_date_information9  date;
73 g_cust_date_information10 date;
74 g_cust_date_information11 date;
75 g_cust_date_information12 date;
76 g_cust_date_information13 date;
77 g_cust_date_information14 date;
78 g_cust_date_information15 date;
79 g_cust_date_information16 date;
80 g_cust_date_information17 date;
81 g_cust_date_information18 date;
82 g_cust_date_information19 date;
83 g_cust_date_information20 date;
84 g_cust_date_information21 date;
85 g_cust_date_information22 date;
86 g_cust_date_information23 date;
87 g_cust_date_information24 date;
88 g_cust_date_information25 date;
89 --
90 g_cust_num_information1  number;
91 g_cust_num_information2  number;
92 g_cust_num_information3  number;
93 g_cust_num_information4  number;
94 g_cust_num_information5  number;
95 g_cust_num_information6  number;
96 g_cust_num_information7  number;
97 g_cust_num_information8  number;
98 g_cust_num_information9  number;
99 g_cust_num_information10 number;
100 g_cust_num_information11 number;
101 g_cust_num_information12 number;
102 g_cust_num_information13 number;
103 g_cust_num_information14 number;
104 g_cust_num_information15 number;
105 g_cust_num_information16 number;
106 g_cust_num_information17 number;
107 g_cust_num_information18 number;
108 g_cust_num_information19 number;
109 g_cust_num_information20 number;
110 g_cust_num_information21 number;
111 g_cust_num_information22 number;
112 g_cust_num_information23 number;
113 g_cust_num_information24 number;
114 g_cust_num_information25 number;
115 --
116 function get_fuzzy_proc_type(
117   p_assignment_action_id in number,
118   p_action_type          in varchar2)
119 return varchar2;
120 --
121 procedure range_cursor(
122   p_payroll_action_id in number,
123   p_sqlstr            out nocopy varchar2);
124 --
125 procedure assignment_action_creation(
126   p_payroll_action_id in number,
127   p_start_person_id   in number,
128   p_end_person_id     in number,
129   p_chunk_number      in number);
130 --
131 procedure archinit(
132   p_payroll_action_id in number);
133 --
134 procedure archive_data(
135   p_assignment_action_id in number,
136   p_effective_date       in date);
137 --
138 procedure deinitialize_code(
139   p_payroll_action_id in number);
140 --
141 -- init_pact,init_assact,ee_datetrack_update_mode,fetch_entry,archive_assact are called from pay_jp_isdf_ss_pkg
142 procedure init_pact(
143   p_payroll_action_id in number);
144 --
145 --procedure init_assact(
146 --  p_assignment_action_id in number,
147 --  p_assignment_id        in number);
148 --
149 procedure archive_assact(
150   p_assignment_action_id in number,
151   p_assignment_id        in number);
152 --
153 end pay_jp_itwb_archive_pkg;