[Home] [Help]
PACKAGE: APPS.PAY_JP_WIC_PKG
Source
1 package pay_jp_wic_pkg as
2 /* $Header: pyjpwic.pkh 120.4.12000000.3 2007/04/05 08:06:45 ttagawa noship $ */
3 --
4 g_valid_term_taxable_amt number;
5 --
6 type t_tax_info is record(
7 taxable_income number := 0,
8 mutual_aid_prem number,
9 si_prem number := 0,
10 itax number := 0,
11 itax_adjustment number := 0,
12 withholding_itax number := 0,
13 disaster_tax_reduction number);
14 type t_certificate_info is record(
15 tax_info t_tax_info,
16 net_taxable_income number,
17 spouse_sp_exempt number,
18 spouse_net_taxable_income number,
19 li_prem_exempt number,
20 pp_prem number,
21 ai_prem_exempt number,
22 long_ai_prem number,
23 total_income_exempt number,
24 housing_tax_reduction number,
25 housing_residence_date date,
26 unclaimed_housing_tax_reduct number,
27 fixed_rate_tax_reduction number,
28 national_pens_prem number,
29 dep_spouse_exists_kou varchar2(1) := 'N',
30 dep_spouse_not_exist_kou varchar2(1) := 'N',
31 dep_spouse_exists_otsu varchar2(1) := 'N',
32 dep_spouse_not_exist_otsu varchar2(1) := 'N',
33 aged_spouse_exists varchar2(1) := 'N',
34 num_specifieds_kou number,
35 num_specifieds_otsu number,
36 num_aged_parents_lt number,
37 num_ageds_kou number,
38 num_ageds_otsu number,
39 num_deps_kou number,
40 num_deps_otsu number,
41 num_svr_disableds_lt number,
42 num_svr_disableds number,
43 num_disableds number,
44 husband_exists varchar2(1) := 'N',
45 minor_flag varchar2(1) := 'N',
46 otsu_flag varchar2(1) := 'N',
47 svr_disabled_flag varchar2(1) := 'N',
48 disabled_flag varchar2(1) := 'N',
49 aged_flag varchar2(1) := 'N',
50 widow_flag varchar2(1) := 'N',
51 sp_widow_flag varchar2(1) := 'N',
52 widower_flag varchar2(1) := 'N',
53 working_student_flag varchar2(1) := 'N',
54 deceased_termination_flag varchar2(1) := 'N',
55 disastered_flag varchar2(1) := 'N',
56 foreigner_flag varchar2(1) := 'N',
57 description_kanji varchar2(32767),
58 description_kana varchar2(32767),
59 desc_line1_kanji varchar2(32767),
60 desc_line1_kana varchar2(32767));
61 --
62 type t_prev_job_info is record(
63 itax_organization_id number,
64 taxable_income number := 0,
65 mutual_aid_prem number,
66 si_prem number := 0,
67 itax number := 0,
68 foreign_address_flag varchar2(1) := 'N',
69 salary_payer_address_kanji varchar2(2000),
70 salary_payer_address_kana varchar2(2000),
71 salary_payer_name_kanji varchar2(2000),
72 salary_payer_name_kana varchar2(2000),
73 termination_date date);
74 type t_prev_jobs is table of t_prev_job_info index by binary_integer;
75 --
76 type t_dpnt_info is record(
77 contact_type_kanji hr_lookups.meaning%type,
78 contact_type_kana hr_lookups.meaning%type,
79 last_name_kanji per_all_people_f.per_information18%type,
80 last_name_kana per_all_people_f.last_name%type,
81 first_name_kanji per_all_people_f.per_information19%type,
82 first_name_kana per_all_people_f.first_name%type);
83 type t_dpnts is table of t_dpnt_info index by binary_integer;
84 --
85 type t_description_info is record(
86 description_type varchar2(30),
87 description_kanji varchar2(32767),
88 description_kana varchar2(32767));
89 type t_descriptions is table of t_description_info index by binary_integer;
90 -- |-------------------------------------------------------------------|
91 -- |----------------------< get_ee_description >-----------------------|
92 -- |-------------------------------------------------------------------|
93 procedure get_ee_description(
94 p_assignment_id in number,
95 p_business_group_id in number,
96 p_effective_date in date,
97 p_itw_override_flag out nocopy varchar2,
98 p_itw_description out nocopy varchar2,
99 p_wtm_override_flag out nocopy varchar2,
100 p_wtm_description out nocopy varchar2);
101 -- |-------------------------------------------------------------------|
102 -- |-----------------------< get_descriptions >------------------------|
103 -- |-------------------------------------------------------------------|
104 procedure get_descriptions(
105 p_assignment_id in number,
106 p_person_id in number,
107 p_effective_date in date,
108 p_itax_yea_category in varchar2,
109 p_certificate_info in t_certificate_info,
110 p_last_name_kanji in varchar2,
111 p_last_name_kana in varchar2,
112 p_dpnts in t_dpnts,
113 p_prev_jobs in t_prev_jobs,
114 p_report_type in varchar2, --> ITW/WTM
115 p_descriptions out nocopy t_descriptions);
116 -- |-------------------------------------------------------------------|
117 -- |---------------------< get_certificate_info >----------------------|
118 -- |-------------------------------------------------------------------|
119 -- Wrapper function for ITT
120 procedure get_certificate_info(
121 p_assignment_action_id in number,
122 p_assignment_id in number,
123 p_action_sequence in number,
124 p_effective_date in date,
125 p_itax_organization_id in number,
126 p_itax_category in varchar2,
127 p_itax_yea_category in varchar2,
128 p_employment_category in varchar2,
129 p_person_id in number,
130 p_business_group_id in number,
131 p_date_earned in date,
132 p_certificate_info out nocopy t_tax_info,
133 p_submission_required_flag out nocopy varchar2,
134 p_withholding_tax_info out nocopy t_tax_info);
135 --
136 -- Following is deprecated.
137 --
138 procedure get_certificate_info(
139 p_assignment_action_id in number,
140 p_assignment_id in number,
141 p_action_sequence in number,
142 p_effective_date in date,
143 p_itax_organization_id in number,
144 p_itax_category in varchar2,
145 p_itax_yea_category in varchar2,
146 p_employment_category in varchar2,
147 p_person_id in number,
148 p_business_group_id in number,
149 p_date_earned in date,
150 p_certificate_info out nocopy t_tax_info,
151 p_submission_required_flag out nocopy varchar2,
152 p_withholding_tax_info out nocopy t_tax_info,
153 p_prev_jobs out nocopy t_prev_jobs);
154 -- |-------------------------------------------------------------------|
155 -- |---------------------< get_certificate_info >----------------------|
156 -- |-------------------------------------------------------------------|
157 -- Wrapper function for WTM
158 procedure get_certificate_info(
159 p_assignment_action_id in number,
160 p_assignment_id in number,
161 p_action_sequence in number,
162 p_business_group_id in number,
163 p_effective_date in date,
164 p_date_earned in date,
165 p_itax_organization_id in number,
166 p_itax_category in varchar2,
167 p_itax_yea_category in varchar2,
168 p_dpnt_ref_type in varchar2,
169 p_dpnt_effective_date in date,
170 p_person_id in number,
171 p_sex in varchar2,
172 p_date_of_birth in date,
173 p_leaving_reason in varchar2,
174 p_last_name_kanji in varchar2,
175 p_last_name_kana in varchar2,
176 p_employment_category in varchar2,
177 p_magnetic_media_flag in varchar2 default 'N',
178 p_certificate_info out nocopy t_certificate_info,
179 p_submission_required_flag out nocopy varchar2,
180 p_prev_jobs out nocopy t_prev_jobs);
181 --
182 procedure get_certificate_info(
183 p_assignment_action_id in number,
184 p_assignment_id in number,
185 p_action_sequence in number,
186 p_business_group_id in number,
187 p_effective_date in date,
188 p_date_earned in date,
189 p_itax_organization_id in number,
190 p_itax_category in varchar2,
191 p_itax_yea_category in varchar2,
192 p_dpnt_ref_type in varchar2,
193 p_dpnt_effective_date in date,
194 p_person_id in number,
195 p_sex in varchar2,
196 p_date_of_birth in date,
197 p_leaving_reason in varchar2,
198 p_last_name_kanji in varchar2,
199 p_last_name_kana in varchar2,
200 p_employment_category in varchar2,
201 p_magnetic_media_flag in varchar2 default 'N',
202 p_certificate_info out nocopy t_certificate_info,
203 p_submission_required_flag out nocopy varchar2,
204 p_prev_job_info out nocopy t_prev_job_info);
205 -- |-------------------------------------------------------------------|
206 -- |---------------------< get_certificate_info >----------------------|
207 -- |-------------------------------------------------------------------|
208 -- Wrapper function for ITW
209 procedure get_certificate_info(
210 p_assignment_action_id in number,
211 p_assignment_id in number,
212 p_action_sequence in number,
213 p_business_group_id in number,
214 p_effective_date in date,
215 p_date_earned in date,
216 p_itax_organization_id in number,
217 p_itax_category in varchar2,
218 p_itax_yea_category in varchar2,
219 p_dpnt_ref_type in varchar2,
220 p_dpnt_effective_date in date,
221 p_person_id in number,
222 p_sex in varchar2,
223 p_date_of_birth in date,
224 p_leaving_reason in varchar2,
225 p_last_name_kanji in varchar2,
226 p_last_name_kana in varchar2,
227 p_employment_category in varchar2,
228 p_magnetic_media_flag in varchar2 default 'N',
229 p_certificate_info out nocopy t_certificate_info,
230 p_submission_required_flag out nocopy varchar2,
231 p_prev_jobs out nocopy t_prev_jobs,
232 p_withholding_tax_info out nocopy t_tax_info);
233 -- |-------------------------------------------------------------------|
234 -- |---------------------< get_certificate_info >----------------------|
235 -- |-------------------------------------------------------------------|
236 -- Wrapper function for Archive
237 procedure get_certificate_info(
238 p_assignment_action_id in number,
239 p_assignment_id in number,
240 p_action_sequence in number,
241 p_business_group_id in number,
242 p_effective_date in date,
243 p_date_earned in date,
244 p_itax_organization_id in number,
245 p_itax_category in varchar2,
246 p_itax_yea_category in varchar2,
247 p_dpnt_ref_type in varchar2,
248 p_dpnt_effective_date in date,
249 p_person_id in number,
250 p_sex in varchar2,
251 p_date_of_birth in date,
252 p_leaving_reason in varchar2,
253 p_last_name_kanji in varchar2,
254 p_last_name_kana in varchar2,
255 p_employment_category in varchar2,
256 p_certificate_info out nocopy t_certificate_info,
257 p_submission_required_flag out nocopy varchar2,
258 p_prev_job_info out nocopy t_prev_job_info,
259 p_withholding_tax_info out nocopy t_tax_info,
260 p_itw_description out nocopy varchar2,
261 p_itw_descriptions out nocopy t_descriptions,
262 p_wtm_description out nocopy varchar2,
263 p_wtm_descriptions out nocopy t_descriptions);
264 --
265 -- |-------------------------------------------------------------------|
266 -- |---------------------< set_valid_term_taxable_amt >----------------|
267 -- |-------------------------------------------------------------------|
268 procedure set_valid_term_taxable_amt(
269 p_valid_term_taxable_amt in number);
270 --
271 -- |-------------------------------------------------------------------|
272 -- |---------------------< spr_term_valid >----------------------------|
273 -- |-------------------------------------------------------------------|
274 -- Use in Summary Payment Report and ITW with Term Validation
275 function spr_term_valid(
276 p_assignment_action_id in number,
277 p_assignment_id in number,
278 p_action_sequence in number,
279 p_effective_date in date,
280 p_itax_organization_id in number,
281 p_itax_category in varchar2,
282 p_itax_yea_category in varchar2,
283 p_employment_category in varchar2,
284 p_termination_date in date,
285 p_certificate_info in t_certificate_info default null)
286 return number;
287 --
288 -- |-------------------------------------------------------------------|
289 -- |---------------------< get_certificate_info >----------------------|
290 -- |-------------------------------------------------------------------|
291 -- Wrapper for ITW with Term Validation
292 procedure get_certificate_info(
293 p_assignment_action_id in number,
294 p_assignment_id in number,
295 p_action_sequence in number,
296 p_business_group_id in number,
297 p_effective_date in date,
298 p_date_earned in date,
299 p_itax_organization_id in number,
300 p_itax_category in varchar2,
301 p_itax_yea_category in varchar2,
302 p_dpnt_ref_type in varchar2,
303 p_dpnt_effective_date in date,
304 p_person_id in number,
305 p_sex in varchar2,
306 p_date_of_birth in date,
307 p_leaving_reason in varchar2,
308 p_last_name_kanji in varchar2,
309 p_last_name_kana in varchar2,
310 p_employment_category in varchar2,
311 p_magnetic_media_flag in varchar2 default 'N',
312 p_termination_date in date,
313 p_certificate_info out nocopy t_certificate_info,
314 p_submission_required_flag out nocopy varchar2,
315 p_prev_jobs out nocopy t_prev_jobs,
316 p_withholding_tax_info out nocopy t_tax_info,
317 p_spr_term_valid out nocopy number);
318 --
319 -- |-------------------------------------------------------------------|
320 -- |---------------------< get_certificate_info >----------------------|
321 -- |-------------------------------------------------------------------|
322 -- For debugging purpose. NEVER USE THIS in your product code.
323 procedure get_certificate_info(
324 p_assignment_action_id in number,
325 p_magnetic_media_flag in varchar2 default 'N',
326 p_certificate_info out nocopy t_certificate_info,
327 p_submission_required_flag out nocopy varchar2,
328 p_prev_jobs out nocopy t_prev_jobs,
329 p_withholding_tax_info out nocopy t_tax_info);
330 --
331 -- Deprecated
332 --
333 FUNCTION ass_set_validation(
334 p_assignment_set_id in NUMBER,
335 p_assignment_id in NUMBER,
336 p_effective_date in DATE) RETURN NUMBER;
337 --
338 end pay_jp_wic_pkg;