eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.PAY_JP_DEF_API

Source


1 package body pay_jp_def_api as
2 /* $Header: pyjpdefa.pkb 120.0.12000000.3 2007/05/10 03:18:53 ttagawa noship $ */
3 --
4 -- Constants
5 --
6 c_package		constant varchar2(31) := 'pay_jp_def_api.';
7 --
8 -- Private Functions/Procedures
9 --
10 -- |---------------------------------------------------------------------------|
11 -- |-----------------------------< to_canonical >------------------------------|
12 -- |---------------------------------------------------------------------------|
13 function to_canonical(p_number in number) return varchar2
14 is
15 begin
16 	if p_number is not null then
17 		if p_number = hr_api.g_number then
18 			return hr_api.g_varchar2;
19 		else
20 			return fnd_number.number_to_canonical(p_number);
21 		end if;
22 	end if;
23 	--
24 	return null;
25 end to_canonical;
26 --
27 function to_canonical(p_date in date) return varchar2
28 is
29 begin
30 	if p_date is not null then
31 		if p_date = hr_api.g_date then
32 			return hr_api.g_varchar2;
33 		else
34 			return fnd_date.date_to_canonical(p_date);
35 		end if;
36 	end if;
37 	--
38 	return null;
39 end to_canonical;
40 -- |---------------------------------------------------------------------------|
41 -- |------------------------------< create_pact >------------------------------|
42 -- |---------------------------------------------------------------------------|
43 procedure create_pact(
44 	P_VALIDATE			in boolean	default null,
45 	P_PAYROLL_ACTION_ID		in number,
46 	P_EFFECTIVE_DATE		in date,
47 	P_PAYROLL_ID			in number	default null,
48 	P_ORGANIZATION_ID		in number	default null,
49 	P_SUBMISSION_PERIOD_STATUS	in varchar2	default null,
50 	P_SUBMISSION_START_DATE		in date		default null,
51 	P_SUBMISSION_END_DATE		in date		default null,
52 	P_TAX_OFFICE_NAME		in varchar2	default null,
53 	P_SALARY_PAYER_NAME		in varchar2	default null,
54 	P_SALARY_PAYER_ADDRESS		in varchar2	default null,
55 	P_ACTION_INFORMATION_ID		out nocopy number,
56 	P_OBJECT_VERSION_NUMBER		out nocopy number)
57 is
58 begin
59 	pay_action_information_api.create_action_information(
60 		P_VALIDATE			=> P_VALIDATE,
61 		P_ACTION_CONTEXT_ID		=> p_payroll_action_id,
62 		P_ACTION_CONTEXT_TYPE		=> 'PA',
63 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_PACT',
64 		P_EFFECTIVE_DATE		=> p_effective_date,
65 		P_ACTION_INFORMATION1		=> to_canonical(P_PAYROLL_ID),
66 		P_ACTION_INFORMATION2		=> to_canonical(P_ORGANIZATION_ID),
67 		P_ACTION_INFORMATION3		=> P_SUBMISSION_PERIOD_STATUS,
68 		P_ACTION_INFORMATION4		=> to_canonical(P_SUBMISSION_START_DATE),
69 		P_ACTION_INFORMATION5		=> to_canonical(P_SUBMISSION_END_DATE),
70 		P_ACTION_INFORMATION6		=> P_TAX_OFFICE_NAME,
71 		P_ACTION_INFORMATION7		=> P_SALARY_PAYER_NAME,
72 		P_ACTION_INFORMATION8		=> P_SALARY_PAYER_ADDRESS,
73 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
74 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);
75 end create_pact;
76 -- |---------------------------------------------------------------------------|
77 -- |------------------------------< update_pact >------------------------------|
78 -- |---------------------------------------------------------------------------|
79 procedure update_pact(
80 	P_VALIDATE			in number	default hr_api.g_false_num,
81 	P_ACTION_INFORMATION_ID		in number,
82 	P_OBJECT_VERSION_NUMBER		in out nocopy number,
83 	P_SUBMISSION_PERIOD_STATUS	in varchar2	default hr_api.g_varchar2,
84 	P_SUBMISSION_START_DATE		in date		default hr_api.g_date,
85 	P_SUBMISSION_END_DATE		in date		default hr_api.g_date,
86 	P_TAX_OFFICE_NAME		in varchar2	default hr_api.g_varchar2,
87 	P_SALARY_PAYER_NAME		in varchar2	default hr_api.g_varchar2,
88 	P_SALARY_PAYER_ADDRESS		in varchar2	default hr_api.g_varchar2,
89 	p_return_status			out nocopy varchar2)
90 is
91 	l_rec		pay_jp_def_pact_v%rowtype;
92 begin
93 	pay_action_information_swi.update_action_information(
94 		P_VALIDATE			=> P_VALIDATE,
95 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
96 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
97 		P_ACTION_INFORMATION3		=> P_SUBMISSION_PERIOD_STATUS,
98 		P_ACTION_INFORMATION4		=> to_canonical(P_SUBMISSION_START_DATE),
99 		P_ACTION_INFORMATION5		=> to_canonical(P_SUBMISSION_END_DATE),
100 		P_ACTION_INFORMATION6		=> P_TAX_OFFICE_NAME,
101 		P_ACTION_INFORMATION7		=> P_SALARY_PAYER_NAME,
102 		P_ACTION_INFORMATION8		=> P_SALARY_PAYER_ADDRESS,
103 		p_return_status			=> p_return_status);
104 end update_pact;
105 -- |---------------------------------------------------------------------------|
106 -- |-----------------------------< create_assact >-----------------------------|
107 -- |---------------------------------------------------------------------------|
108 procedure create_assact(
109 	P_VALIDATE			in boolean	default false,
110 	P_ASSIGNMENT_ACTION_ID		in number,
111 	P_EFFECTIVE_DATE		in date,
112 	P_ASSIGNMENT_ID			in number,
113 	P_TAX_TYPE			in varchar2	default null,
114 	P_TRANSACTION_STATUS		in varchar2	default null,
115 	P_FINALIZED_DATE		in date		default null,
116 	P_FINALIZED_BY			in number	default null,
117 	P_USER_COMMENTS			in varchar2	default null,
118 	P_ADMIN_COMMENTS		in varchar2	default null,
119 	P_TRANSFER_STATUS		in varchar2	default null,
120 	P_EXPIRY_DATE			in date		default null,
121 	P_ACTION_INFORMATION_ID		out nocopy number,
122 	P_OBJECT_VERSION_NUMBER		out nocopy number)
123 is
124 begin
125 	pay_action_information_api.create_action_information(
126 		P_VALIDATE			=> P_VALIDATE,
127 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
128 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
129 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_ASSACT',
130 		P_EFFECTIVE_DATE		=> p_effective_date,
131 		P_ASSIGNMENT_ID			=> p_assignment_id,
132 		P_ACTION_INFORMATION1		=> P_TAX_TYPE,
133 		P_ACTION_INFORMATION2		=> P_TRANSACTION_STATUS,
134 		P_ACTION_INFORMATION3		=> to_canonical(P_FINALIZED_DATE),
135 		P_ACTION_INFORMATION4		=> to_canonical(P_FINALIZED_BY),
136 		P_ACTION_INFORMATION5		=> P_USER_COMMENTS,
137 		P_ACTION_INFORMATION6		=> P_ADMIN_COMMENTS,
138 		P_ACTION_INFORMATION7		=> P_TRANSFER_STATUS,
139 		P_ACTION_INFORMATION8		=> to_canonical(P_EXPIRY_DATE),
140 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
141 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);
142 end create_assact;
143 -- |---------------------------------------------------------------------------|
144 -- |-----------------------------< update_assact >-----------------------------|
145 -- |---------------------------------------------------------------------------|
146 procedure update_assact(
147 	P_VALIDATE			in boolean	default false,
148 	P_ACTION_INFORMATION_ID		in number,
149 	P_OBJECT_VERSION_NUMBER		in out nocopy number,
150 	P_TRANSACTION_STATUS		in varchar2	default hr_api.g_varchar2,
151 	P_FINALIZED_DATE		in date		default hr_api.g_date,
152 	P_FINALIZED_BY			in number	default hr_api.g_number,
153 	P_USER_COMMENTS			in varchar2	default hr_api.g_varchar2,
154 	P_ADMIN_COMMENTS		in varchar2	default hr_api.g_varchar2,
155 	P_TRANSFER_STATUS		in varchar2	default hr_api.g_varchar2,
156 	P_EXPIRY_DATE			in date		default hr_api.g_date)
157 is
158 begin
159 	pay_action_information_api.update_action_information(
160 		P_VALIDATE			=> P_VALIDATE,
161 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
162 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
163 		P_ACTION_INFORMATION2		=> P_TRANSACTION_STATUS,
164 		P_ACTION_INFORMATION3		=> to_canonical(P_FINALIZED_DATE),
165 		P_ACTION_INFORMATION4		=> to_canonical(P_FINALIZED_BY),
166 		P_ACTION_INFORMATION5		=> P_USER_COMMENTS,
167 		P_ACTION_INFORMATION6		=> P_ADMIN_COMMENTS,
168 		P_ACTION_INFORMATION7		=> P_TRANSFER_STATUS,
169 		P_ACTION_INFORMATION8		=> to_canonical(P_EXPIRY_DATE));
170 end update_assact;
171 --
172 -- When detail entities in composite association is changed,
173 -- parent entity (assact in this case) is also updated.
174 -- When trying to save detail entities, parent entity "assact"
175 -- is updated at first. So "check_submission_period" procedure
176 -- is implemented for this "Save" case at the moment.
177 --
178 procedure update_assact(
179 	P_VALIDATE			in number	default hr_api.g_false_num,
180 	P_ACTION_INFORMATION_ID		in number,
181 	P_OBJECT_VERSION_NUMBER		in out nocopy number,
182 	P_TRANSACTION_STATUS		in varchar2	default hr_api.g_varchar2,
183 	P_FINALIZED_DATE		in date		default hr_api.g_date,
184 	P_FINALIZED_BY			in number	default hr_api.g_number,
185 	P_USER_COMMENTS			in varchar2	default hr_api.g_varchar2,
186 	P_ADMIN_COMMENTS		in varchar2	default hr_api.g_varchar2,
187 	P_TRANSFER_STATUS		in varchar2	default hr_api.g_varchar2,
188 	P_EXPIRY_DATE			in date		default hr_api.g_date,
189 	p_return_status			out nocopy varchar2)
190 is
191 	l_api_updating		boolean;
192 	l_transaction_status	varchar2(30) := p_transaction_status;
193 begin
194 	if l_transaction_status = hr_api.g_varchar2 then
195 		l_api_updating := pay_aif_shd.api_updating(
196 					p_action_information_id		=> p_action_information_id,
197 					p_object_version_number		=> p_object_version_number);
198 		--
199 		if not l_api_updating then
200 			hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
201 			hr_utility.raise_error;
202 		else
203 			l_transaction_status := pay_aif_shd.g_old_rec.action_information2;
204 		end if;
205 	end if;
206 	--
207 	-- Currently, update operation against assact is not allowed
208 	-- except for "Save" case.
209 	--
210 	if l_transaction_status <> 'N' then
211 		fnd_message.set_encoded('This operation is not supported at the moment.');
212 		fnd_message.raise_error;
213 	else
214 		pay_jp_def_ss.check_submission_period(p_action_information_id);
215 	end if;
216 	--
217 	pay_action_information_swi.update_action_information(
218 		P_VALIDATE			=> P_VALIDATE,
219 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
220 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
221 		P_ACTION_INFORMATION2		=> P_TRANSACTION_STATUS,
222 		P_ACTION_INFORMATION3		=> to_canonical(P_FINALIZED_DATE),
223 		P_ACTION_INFORMATION4		=> to_canonical(P_FINALIZED_BY),
224 		P_ACTION_INFORMATION5		=> P_USER_COMMENTS,
225 		P_ACTION_INFORMATION6		=> P_ADMIN_COMMENTS,
226 		P_ACTION_INFORMATION7		=> P_TRANSFER_STATUS,
227 		P_ACTION_INFORMATION8		=> to_canonical(P_EXPIRY_DATE),
228 		p_return_status			=> p_return_status);
229 end update_assact;
230 -- |---------------------------------------------------------------------------|
231 -- |------------------------------< create_emp >-------------------------------|
232 -- |---------------------------------------------------------------------------|
233 procedure create_emp(
234 	P_VALIDATE			in boolean	default false,
235 	P_ASSIGNMENT_ACTION_ID		in number,
236 	P_EFFECTIVE_DATE		in date,
237 	P_ASSIGNMENT_ID			in number,
238 	P_LAST_NAME_KANA		in varchar2	default null,
239 	P_FIRST_NAME_KANA		in varchar2	default null,
240 	P_LAST_NAME			in varchar2	default null,
241 	P_FIRST_NAME			in varchar2	default null,
242 	P_DATE_OF_BIRTH			in date		default null,
243 	P_DATE_OF_DEATH			in date		default null,
244 	P_SEX				in varchar2	default null,
245 	P_POSTAL_CODE			in varchar2	default null,
246 	P_ADDRESS			in varchar2	default null,
247 	P_HOUSEHOLD_HEAD_CTR_ID		in number	default null,
248 	P_HOUSEHOLD_HEAD_FULL_NAME	in varchar2	default null,
249 	P_HOUSEHOLD_HEAD_CONTACT_TYPE	in varchar2	default null,
250 	P_MARRIED_FLAG			in varchar2	default null,
251 	P_CHANGE_DATE			in date		default null,
252 	P_CHANGE_REASON			in varchar2	default null,
253 	P_DISABILITY_TYPE		in varchar2	default null,
254 	P_DISABILITY_DETAILS		in varchar2	default null,
255 	P_AGED_TYPE			in varchar2	default null,
256 	P_AGED_DETAILS			in varchar2	default null,
257 	P_WIDOW_TYPE			in varchar2	default null,
258 	P_WIDOW_DETAILS			in varchar2	default null,
259 	P_WORKING_STUDENT_TYPE		in varchar2	default null,
260 	P_WORKING_STUDENT_DETAILS	in varchar2	default null,
261 	P_ACTION_INFORMATION_ID		out nocopy number,
262 	P_OBJECT_VERSION_NUMBER		out nocopy number)
263 is
264 begin
265 	pay_action_information_api.create_action_information(
266 		P_VALIDATE			=> P_VALIDATE,
267 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
268 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
269 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_EMP',
270 		P_EFFECTIVE_DATE		=> p_effective_date,
271 		P_ASSIGNMENT_ID			=> p_assignment_id,
272 		P_ACTION_INFORMATION1		=> P_LAST_NAME_KANA,
273 		P_ACTION_INFORMATION2		=> P_FIRST_NAME_KANA,
274 		P_ACTION_INFORMATION3		=> P_LAST_NAME,
275 		P_ACTION_INFORMATION4		=> P_FIRST_NAME,
276 		P_ACTION_INFORMATION5		=> to_canonical(P_DATE_OF_BIRTH),
277 		P_ACTION_INFORMATION6		=> to_canonical(P_DATE_OF_DEATH),
278 		P_ACTION_INFORMATION7		=> P_SEX,
279 		P_ACTION_INFORMATION8		=> P_POSTAL_CODE,
280 		P_ACTION_INFORMATION9		=> P_ADDRESS,
281 		P_ACTION_INFORMATION10		=> to_canonical(P_HOUSEHOLD_HEAD_CTR_ID),
282 		P_ACTION_INFORMATION11		=> P_HOUSEHOLD_HEAD_FULL_NAME,
283 		P_ACTION_INFORMATION12		=> P_HOUSEHOLD_HEAD_CONTACT_TYPE,
284 		P_ACTION_INFORMATION13		=> P_MARRIED_FLAG,
285 		P_ACTION_INFORMATION14		=> to_canonical(P_CHANGE_DATE),
286 		P_ACTION_INFORMATION15		=> P_CHANGE_REASON,
287 		P_ACTION_INFORMATION16		=> P_DISABILITY_TYPE,
288 		P_ACTION_INFORMATION17		=> P_DISABILITY_DETAILS,
289 		P_ACTION_INFORMATION18		=> P_AGED_TYPE,
290 		P_ACTION_INFORMATION19		=> P_AGED_DETAILS,
291 		P_ACTION_INFORMATION20		=> P_WIDOW_TYPE,
292 		P_ACTION_INFORMATION21		=> P_WIDOW_DETAILS,
293 		P_ACTION_INFORMATION22		=> P_WORKING_STUDENT_TYPE,
294 		P_ACTION_INFORMATION23		=> P_WORKING_STUDENT_DETAILS,
295 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
296 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);
297 end create_emp;
298 -- |---------------------------------------------------------------------------|
299 -- |------------------------------< update_emp >-------------------------------|
300 -- |---------------------------------------------------------------------------|
301 procedure update_emp(
302 	P_VALIDATE			in number	default hr_api.g_false_num,
303 	P_ACTION_INFORMATION_ID		in number,
304 	P_OBJECT_VERSION_NUMBER		in out nocopy number,
305 	P_CHANGE_DATE			in date		default hr_api.g_date,
306 	P_CHANGE_REASON			in varchar2	default hr_api.g_varchar2,
307 	P_DISABILITY_TYPE		in varchar2	default hr_api.g_varchar2,
308 	P_DISABILITY_DETAILS		in varchar2	default hr_api.g_varchar2,
309 	P_AGED_TYPE			in varchar2	default hr_api.g_varchar2,
310 	P_AGED_DETAILS			in varchar2	default hr_api.g_varchar2,
311 	P_WIDOW_TYPE			in varchar2	default hr_api.g_varchar2,
312 	P_WIDOW_DETAILS			in varchar2	default hr_api.g_varchar2,
313 	P_WORKING_STUDENT_TYPE		in varchar2	default hr_api.g_varchar2,
314 	P_WORKING_STUDENT_DETAILS	in varchar2	default hr_api.g_varchar2,
315 	p_return_status			out nocopy varchar2)
316 is
317 begin
318 	pay_action_information_swi.update_action_information(
319 		P_VALIDATE			=> P_VALIDATE,
320 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
321 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
322 		P_ACTION_INFORMATION14		=> to_canonical(P_CHANGE_DATE),
323 		P_ACTION_INFORMATION15		=> P_CHANGE_REASON,
324 		P_ACTION_INFORMATION16		=> P_DISABILITY_TYPE,
325 		P_ACTION_INFORMATION17		=> P_DISABILITY_DETAILS,
326 		P_ACTION_INFORMATION18		=> P_AGED_TYPE,
327 		P_ACTION_INFORMATION19		=> P_AGED_DETAILS,
328 		P_ACTION_INFORMATION20		=> P_WIDOW_TYPE,
329 		P_ACTION_INFORMATION21		=> P_WIDOW_DETAILS,
330 		P_ACTION_INFORMATION22		=> P_WORKING_STUDENT_TYPE,
331 		P_ACTION_INFORMATION23		=> P_WORKING_STUDENT_DETAILS,
332 		p_return_status			=> p_return_status);
333 end update_emp;
334 -- |---------------------------------------------------------------------------|
335 -- |-----------------------------< create_entry >------------------------------|
336 -- |---------------------------------------------------------------------------|
337 procedure create_entry(
338 	P_VALIDATE			in boolean	default false,
339 	P_ASSIGNMENT_ACTION_ID		in number,
340 	P_EFFECTIVE_DATE		in date,
341 	P_ASSIGNMENT_ID			in number,
342 	P_STATUS			in varchar2	default null,
343 	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
344 	P_ELEMENT_ENTRY_ID		in number	default null,
345 	P_EE_OBJECT_VERSION_NUMBER	in number	default null,
346 	P_DISABILITY_TYPE		in varchar2	default null,
347 	P_DISABILITY_TYPE_O		in varchar2	default null,
348 	P_AGED_TYPE			in varchar2	default null,
349 	P_AGED_TYPE_O			in varchar2	default null,
350 	P_WIDOW_TYPE			in varchar2	default null,
351 	P_WIDOW_TYPE_O			in varchar2	default null,
352 	P_WORKING_STUDENT_TYPE		in varchar2	default null,
353 	P_WORKING_STUDENT_TYPE_O	in varchar2	default null,
354 	P_SPOUSE_DEP_TYPE		in varchar2	default null,
355 	P_SPOUSE_DEP_TYPE_O		in varchar2	default null,
356 	P_SPOUSE_DISABILITY_TYPE	in varchar2	default null,
357 	P_SPOUSE_DISABILITY_TYPE_O	in varchar2	default null,
358 	P_NUM_DEPS			in number	default null,
359 	P_NUM_DEPS_O			in number	default null,
360 	P_NUM_AGEDS			in number	default null,
361 	P_NUM_AGEDS_O			in number	default null,
362 	P_NUM_AGED_PARENTS_LT		in number	default null,
363 	P_NUM_AGED_PARENTS_LT_O		in number	default null,
364 	P_NUM_SPECIFIEDS		in number	default null,
365 	P_NUM_SPECIFIEDS_O		in number	default null,
366 	P_NUM_DISABLEDS			in number	default null,
367 	P_NUM_DISABLEDS_O		in number	default null,
368 	P_NUM_SVR_DISABLEDS		in number	default null,
369 	P_NUM_SVR_DISABLEDS_O		in number	default null,
370 	P_NUM_SVR_DISABLEDS_LT		in number	default null,
371 	P_NUM_SVR_DISABLEDS_LT_O	in number	default null,
372 	P_ACTION_INFORMATION_ID		out nocopy number,
373 	P_OBJECT_VERSION_NUMBER		out nocopy number)
374 is
375 begin
376 	pay_action_information_api.create_action_information(
377 		P_VALIDATE			=> P_VALIDATE,
378 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
379 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
380 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_ENTRY',
381 		P_EFFECTIVE_DATE		=> p_effective_date,
382 		P_ASSIGNMENT_ID			=> p_assignment_id,
383 		P_ACTION_INFORMATION1		=> P_STATUS,
384 		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
385 		P_ACTION_INFORMATION3		=> to_canonical(P_ELEMENT_ENTRY_ID),
386 		P_ACTION_INFORMATION4		=> to_canonical(P_EE_OBJECT_VERSION_NUMBER),
387 		P_ACTION_INFORMATION5		=> P_DISABILITY_TYPE,
388 		P_ACTION_INFORMATION6		=> P_DISABILITY_TYPE_O,
389 		P_ACTION_INFORMATION7		=> P_AGED_TYPE,
390 		P_ACTION_INFORMATION8		=> P_AGED_TYPE_O,
391 		P_ACTION_INFORMATION9		=> P_WIDOW_TYPE,
392 		P_ACTION_INFORMATION10		=> P_WIDOW_TYPE_O,
393 		P_ACTION_INFORMATION11		=> P_WORKING_STUDENT_TYPE,
394 		P_ACTION_INFORMATION12		=> P_WORKING_STUDENT_TYPE_O,
395 		P_ACTION_INFORMATION13		=> P_SPOUSE_DEP_TYPE,
396 		P_ACTION_INFORMATION14		=> P_SPOUSE_DEP_TYPE_O,
397 		P_ACTION_INFORMATION15		=> P_SPOUSE_DISABILITY_TYPE,
398 		P_ACTION_INFORMATION16		=> P_SPOUSE_DISABILITY_TYPE_O,
399 		P_ACTION_INFORMATION17		=> to_canonical(P_NUM_DEPS),
400 		P_ACTION_INFORMATION18		=> to_canonical(P_NUM_DEPS_O),
401 		P_ACTION_INFORMATION19		=> to_canonical(P_NUM_AGEDS),
402 		P_ACTION_INFORMATION20		=> to_canonical(P_NUM_AGEDS_O),
403 		P_ACTION_INFORMATION21		=> to_canonical(P_NUM_AGED_PARENTS_LT),
404 		P_ACTION_INFORMATION22		=> to_canonical(P_NUM_AGED_PARENTS_LT_O),
405 		P_ACTION_INFORMATION23		=> to_canonical(P_NUM_SPECIFIEDS),
406 		P_ACTION_INFORMATION24		=> to_canonical(P_NUM_SPECIFIEDS_O),
407 		P_ACTION_INFORMATION25		=> to_canonical(P_NUM_DISABLEDS),
408 		P_ACTION_INFORMATION26		=> to_canonical(P_NUM_DISABLEDS_O),
409 		P_ACTION_INFORMATION27		=> to_canonical(P_NUM_SVR_DISABLEDS),
410 		P_ACTION_INFORMATION28		=> to_canonical(P_NUM_SVR_DISABLEDS_O),
411 		P_ACTION_INFORMATION29		=> to_canonical(P_NUM_SVR_DISABLEDS_LT),
412 		P_ACTION_INFORMATION30		=> to_canonical(P_NUM_SVR_DISABLEDS_LT_O),
413 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
414 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);
415 end create_entry;
416 -- |---------------------------------------------------------------------------|
417 -- |-----------------------------< update_entry >------------------------------|
418 -- |---------------------------------------------------------------------------|
419 procedure update_entry(
420 	P_VALIDATE			in boolean	default false,
421 	P_ACTION_INFORMATION_ID		in number,
422 	P_OBJECT_VERSION_NUMBER		in out nocopy number,
423 	P_STATUS			in varchar2	default hr_api.g_varchar2,
424 	P_ELEMENT_ENTRY_ID		in number	default hr_api.g_number,
425 	P_EE_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
426 	P_DISABILITY_TYPE		in varchar2	default hr_api.g_varchar2,
427 	P_AGED_TYPE			in varchar2	default hr_api.g_varchar2,
428 	P_WIDOW_TYPE			in varchar2	default hr_api.g_varchar2,
429 	P_WORKING_STUDENT_TYPE		in varchar2	default hr_api.g_varchar2,
430 	P_SPOUSE_DEP_TYPE		in varchar2	default hr_api.g_varchar2,
431 	P_SPOUSE_DISABILITY_TYPE	in varchar2	default hr_api.g_varchar2,
432 	P_NUM_DEPS			in number	default hr_api.g_number,
433 	P_NUM_AGEDS			in number	default hr_api.g_number,
434 	P_NUM_AGED_PARENTS_LT		in number	default hr_api.g_number,
435 	P_NUM_SPECIFIEDS		in number	default hr_api.g_number,
436 	P_NUM_DISABLEDS			in number	default hr_api.g_number,
437 	P_NUM_SVR_DISABLEDS		in number	default hr_api.g_number,
438 	P_NUM_SVR_DISABLEDS_LT		in number	default hr_api.g_number)
439 is
440 begin
441 	pay_action_information_api.update_action_information(
442 		P_VALIDATE			=> P_VALIDATE,
443 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
444 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
445 		P_ACTION_INFORMATION1		=> P_STATUS,
446 		P_ACTION_INFORMATION3		=> to_canonical(P_ELEMENT_ENTRY_ID),
447 		P_ACTION_INFORMATION4		=> to_canonical(P_EE_OBJECT_VERSION_NUMBER),
448 		P_ACTION_INFORMATION5		=> P_DISABILITY_TYPE,
449 		P_ACTION_INFORMATION7		=> P_AGED_TYPE,
450 		P_ACTION_INFORMATION9		=> P_WIDOW_TYPE,
451 		P_ACTION_INFORMATION11		=> P_WORKING_STUDENT_TYPE,
452 		P_ACTION_INFORMATION13		=> P_SPOUSE_DEP_TYPE,
453 		P_ACTION_INFORMATION15		=> P_SPOUSE_DISABILITY_TYPE,
454 		P_ACTION_INFORMATION17		=> to_canonical(P_NUM_DEPS),
455 		P_ACTION_INFORMATION19		=> to_canonical(P_NUM_AGEDS),
456 		P_ACTION_INFORMATION21		=> to_canonical(P_NUM_AGED_PARENTS_LT),
457 		P_ACTION_INFORMATION23		=> to_canonical(P_NUM_SPECIFIEDS),
458 		P_ACTION_INFORMATION25		=> to_canonical(P_NUM_DISABLEDS),
459 		P_ACTION_INFORMATION27		=> to_canonical(P_NUM_SVR_DISABLEDS),
460 		P_ACTION_INFORMATION29		=> to_canonical(P_NUM_SVR_DISABLEDS_LT));
461 end update_entry;
462 -- |---------------------------------------------------------------------------|
463 -- |------------------------------< create_dep >-------------------------------|
464 -- |---------------------------------------------------------------------------|
465 procedure create_dep(
466 	P_VALIDATE			in boolean	default false,
467 	P_ASSIGNMENT_ACTION_ID		in number,
468 	P_EFFECTIVE_DATE		in date,
469 	P_ASSIGNMENT_ID			in number,
470 	P_STATUS			in varchar2	default null,
471 	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
472 	P_DATETRACK_DELETE_MODE		in varchar2	default null,
473 	P_CONTACT_EXTRA_INFO_ID		in number	default null,
474 	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
475 	P_CONTACT_RELATIONSHIP_ID	in number	default null,
476 	P_LAST_NAME_KANA		in varchar2	default null,
477 	P_FIRST_NAME_KANA		in varchar2	default null,
478 	P_LAST_NAME			in varchar2	default null,
479 	P_FIRST_NAME			in varchar2	default null,
480 	P_CONTACT_TYPE			in varchar2	default null,
481 	P_DATE_OF_BIRTH			in date		default null,
482 	P_DATE_OF_DEATH			in date		default null,
483 	P_ADDRESS			in varchar2	default null,
484 	P_CHANGE_DATE			in date		default null,
485 	P_CHANGE_REASON			in varchar2	default null,
486 	P_DEP_TYPE			in varchar2	default null,
487 	P_DEP_TYPE_O			in varchar2	default null,
488 	P_OCCUPATION			in varchar2	default null,
489 	P_OCCUPATION_O			in varchar2	default null,
490 	P_ESTIMATED_ANNUAL_INCOME	in number	default null,
491 	P_ESTIMATED_ANNUAL_INCOME_O	in number	default null,
492 	P_DISABILITY_TYPE		in varchar2	default null,
493 	P_DISABILITY_TYPE_O		in varchar2	default null,
494 	P_DISABILITY_DETAILS		in varchar2	default null,
495 	P_DISABILITY_DETAILS_O		in varchar2	default null,
496 	P_ACTION_INFORMATION_ID		out nocopy number,
497 	P_OBJECT_VERSION_NUMBER		out nocopy number)
498 is
499 begin
500 	pay_action_information_api.create_action_information(
501 		P_VALIDATE			=> P_VALIDATE,
502 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
503 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
504 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP',
505 		P_EFFECTIVE_DATE		=> p_effective_date,
506 		P_ASSIGNMENT_ID			=> p_assignment_id,
507 		P_ACTION_INFORMATION1		=> P_STATUS,
508 		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
509 		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
510 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
511 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
512 		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
513 		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
514 		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
515 		P_ACTION_INFORMATION9		=> P_LAST_NAME,
516 		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
517 		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
518 		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
519 		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
520 		P_ACTION_INFORMATION14		=> P_ADDRESS,
521 		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
522 		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
523 		P_ACTION_INFORMATION17		=> P_DEP_TYPE,
524 		P_ACTION_INFORMATION18		=> P_DEP_TYPE_O,
525 		P_ACTION_INFORMATION19		=> P_OCCUPATION,
526 		P_ACTION_INFORMATION20		=> P_OCCUPATION_O,
527 		P_ACTION_INFORMATION21		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME),
528 		P_ACTION_INFORMATION22		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME_O),
529 		P_ACTION_INFORMATION23		=> P_DISABILITY_TYPE,
530 		P_ACTION_INFORMATION24		=> P_DISABILITY_TYPE_O,
531 		P_ACTION_INFORMATION25		=> P_DISABILITY_DETAILS,
532 		P_ACTION_INFORMATION26		=> P_DISABILITY_DETAILS_O,
533 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
534 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);
535 end create_dep;
536 --
537 procedure create_dep(
538 	P_VALIDATE			in number	default hr_api.g_false_num,
539 	P_ACTION_INFORMATION_ID		in number,
540 	P_ASSIGNMENT_ACTION_ID		in number,
541 	P_EFFECTIVE_DATE		in date,
542 	P_ASSIGNMENT_ID			in number,
543 	P_STATUS			in varchar2	default null,
544 	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
545 	P_DATETRACK_DELETE_MODE		in varchar2	default null,
546 	P_CONTACT_EXTRA_INFO_ID		in number	default null,
547 	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
548 	P_CONTACT_RELATIONSHIP_ID	in number	default null,
549 	P_LAST_NAME_KANA		in varchar2	default null,
550 	P_FIRST_NAME_KANA		in varchar2	default null,
551 	P_LAST_NAME			in varchar2	default null,
552 	P_FIRST_NAME			in varchar2	default null,
553 	P_CONTACT_TYPE			in varchar2	default null,
554 	P_DATE_OF_BIRTH			in date		default null,
555 	P_DATE_OF_DEATH			in date		default null,
556 	P_ADDRESS			in varchar2	default null,
557 	P_CHANGE_DATE			in date		default null,
558 	P_CHANGE_REASON			in varchar2	default null,
559 	P_DEP_TYPE			in varchar2	default null,
560 	P_DEP_TYPE_O			in varchar2	default null,
561 	P_OCCUPATION			in varchar2	default null,
562 	P_OCCUPATION_O			in varchar2	default null,
563 	P_ESTIMATED_ANNUAL_INCOME	in number	default null,
564 	P_ESTIMATED_ANNUAL_INCOME_O	in number	default null,
565 	P_DISABILITY_TYPE		in varchar2	default null,
566 	P_DISABILITY_TYPE_O		in varchar2	default null,
567 	P_DISABILITY_DETAILS		in varchar2	default null,
568 	P_DISABILITY_DETAILS_O		in varchar2	default null,
569 	P_OBJECT_VERSION_NUMBER		out nocopy number,
570 	p_return_status			out nocopy varchar2)
571 is
572 begin
573 	pay_action_information_swi.create_action_information(
574 		P_VALIDATE			=> P_VALIDATE,
575 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
576 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
577 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
578 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP',
579 		P_EFFECTIVE_DATE		=> p_effective_date,
580 		P_ASSIGNMENT_ID			=> p_assignment_id,
581 		P_ACTION_INFORMATION1		=> P_STATUS,
582 		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
583 		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
584 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
585 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
586 		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
587 		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
588 		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
589 		P_ACTION_INFORMATION9		=> P_LAST_NAME,
590 		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
591 		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
592 		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
593 		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
594 		P_ACTION_INFORMATION14		=> P_ADDRESS,
595 		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
596 		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
597 		P_ACTION_INFORMATION17		=> P_DEP_TYPE,
598 		P_ACTION_INFORMATION18		=> P_DEP_TYPE_O,
599 		P_ACTION_INFORMATION19		=> P_OCCUPATION,
600 		P_ACTION_INFORMATION20		=> P_OCCUPATION_O,
601 		P_ACTION_INFORMATION21		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME),
602 		P_ACTION_INFORMATION22		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME_O),
603 		P_ACTION_INFORMATION23		=> P_DISABILITY_TYPE,
604 		P_ACTION_INFORMATION24		=> P_DISABILITY_TYPE_O,
605 		P_ACTION_INFORMATION25		=> P_DISABILITY_DETAILS,
606 		P_ACTION_INFORMATION26		=> P_DISABILITY_DETAILS_O,
607 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
608 		p_return_status			=> p_return_status);
609 end create_dep;
610 -- |---------------------------------------------------------------------------|
611 -- |------------------------------< update_dep >-------------------------------|
612 -- |---------------------------------------------------------------------------|
613 procedure update_dep(
614 	P_VALIDATE			in boolean	default false,
615 	P_ACTION_INFORMATION_ID		in number,
616 	P_OBJECT_VERSION_NUMBER		in out nocopy number,
617 	P_STATUS			in varchar2	default hr_api.g_varchar2,
618 	P_CONTACT_EXTRA_INFO_ID		in number	default hr_api.g_number,
619 	P_CEI_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
620 	P_CHANGE_DATE			in date		default hr_api.g_date,
621 	P_CHANGE_REASON			in varchar2	default hr_api.g_varchar2,
622 	P_DEP_TYPE			in varchar2	default hr_api.g_varchar2,
623 	P_OCCUPATION			in varchar2	default hr_api.g_varchar2,
624 	P_ESTIMATED_ANNUAL_INCOME	in number	default hr_api.g_number,
625 	P_DISABILITY_TYPE		in varchar2	default hr_api.g_varchar2,
626 	P_DISABILITY_DETAILS		in varchar2	default hr_api.g_varchar2)
627 is
628 begin
629 	pay_action_information_api.update_action_information(
630 		P_VALIDATE			=> P_VALIDATE,
631 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
632 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
633 		P_ACTION_INFORMATION1		=> P_STATUS,
634 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
635 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
636 		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
637 		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
638 		P_ACTION_INFORMATION17		=> P_DEP_TYPE,
639 		P_ACTION_INFORMATION19		=> P_OCCUPATION,
640 		P_ACTION_INFORMATION21		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME),
641 		P_ACTION_INFORMATION23		=> P_DISABILITY_TYPE,
642 		P_ACTION_INFORMATION25		=> P_DISABILITY_DETAILS);
643 end update_dep;
644 --
645 procedure update_dep(
646 	P_VALIDATE			in number	default hr_api.g_false_num,
647 	P_ACTION_INFORMATION_ID		in number,
648 	P_OBJECT_VERSION_NUMBER		in out nocopy number,
649 	P_STATUS			in varchar2	default hr_api.g_varchar2,
650 	P_CONTACT_EXTRA_INFO_ID		in number	default hr_api.g_number,
651 	P_CEI_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
652 	P_CHANGE_DATE			in date		default hr_api.g_date,
653 	P_CHANGE_REASON			in varchar2	default hr_api.g_varchar2,
654 	P_DEP_TYPE			in varchar2	default hr_api.g_varchar2,
655 	P_OCCUPATION			in varchar2	default hr_api.g_varchar2,
656 	P_ESTIMATED_ANNUAL_INCOME	in number	default hr_api.g_number,
657 	P_DISABILITY_TYPE		in varchar2	default hr_api.g_varchar2,
658 	P_DISABILITY_DETAILS		in varchar2	default hr_api.g_varchar2,
659 	p_return_status			out nocopy varchar2)
660 is
661 begin
662 	pay_action_information_swi.update_action_information(
663 		P_VALIDATE			=> P_VALIDATE,
664 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
665 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
666 		P_ACTION_INFORMATION1		=> P_STATUS,
667 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
668 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
669 		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
670 		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
671 		P_ACTION_INFORMATION17		=> P_DEP_TYPE,
672 		P_ACTION_INFORMATION19		=> P_OCCUPATION,
673 		P_ACTION_INFORMATION21		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME),
674 		P_ACTION_INFORMATION23		=> P_DISABILITY_TYPE,
675 		P_ACTION_INFORMATION25		=> P_DISABILITY_DETAILS,
676 		p_return_status			=> p_return_status);
677 end update_dep;
678 -- |---------------------------------------------------------------------------|
679 -- |-----------------------------< create_dep_oe >-----------------------------|
680 -- |---------------------------------------------------------------------------|
681 procedure create_dep_oe(
682 	P_VALIDATE			in boolean	default false,
683 	P_ASSIGNMENT_ACTION_ID		in number,
684 	P_EFFECTIVE_DATE		in date,
685 	P_ASSIGNMENT_ID			in number,
686 	P_STATUS			in varchar2	default null,
687 	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
688 	P_DATETRACK_DELETE_MODE		in varchar2	default null,
689 	P_CONTACT_EXTRA_INFO_ID		in number	default null,
690 	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
691 	P_CONTACT_RELATIONSHIP_ID	in number	default null,
692 	P_LAST_NAME_KANA		in varchar2	default null,
693 	P_FIRST_NAME_KANA		in varchar2	default null,
694 	P_LAST_NAME			in varchar2	default null,
695 	P_FIRST_NAME			in varchar2	default null,
696 	P_CONTACT_TYPE			in varchar2	default null,
697 	P_DATE_OF_BIRTH			in date		default null,
698 	P_DATE_OF_DEATH			in date		default null,
699 	P_ADDRESS			in varchar2	default null,
700 	P_CHANGE_DATE			in date		default null,
701 	P_CHANGE_REASON			in varchar2	default null,
702 	P_OCCUPATION			in varchar2	default null,
703 	P_OCCUPATION_O			in varchar2	default null,
704 	P_OE_CONTACT_RELATIONSHIP_ID	in number	default null,
705 	P_OE_FULL_NAME			in varchar2	default null,
706 	P_OE_CONTACT_TYPE		in varchar2	default null,
707 	P_OE_ADDRESS			in varchar2	default null,
708 	P_OE_CONTACT_RELATIONSHIP_ID_O	in number	default null,
709 	P_ACTION_INFORMATION_ID		out nocopy number,
710 	P_OBJECT_VERSION_NUMBER		out nocopy number)
711 is
712 begin
713 	pay_action_information_api.create_action_information(
714 		P_VALIDATE			=> P_VALIDATE,
715 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
716 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
717 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP_OE',
718 		P_EFFECTIVE_DATE		=> p_effective_date,
719 		P_ASSIGNMENT_ID			=> p_assignment_id,
720 		P_ACTION_INFORMATION1		=> P_STATUS,
721 		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
722 		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
723 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
724 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
725 		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
726 		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
727 		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
728 		P_ACTION_INFORMATION9		=> P_LAST_NAME,
729 		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
730 		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
731 		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
732 		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
733 		P_ACTION_INFORMATION14		=> P_ADDRESS,
734 		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
735 		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
736 		P_ACTION_INFORMATION17		=> P_OCCUPATION,
737 		P_ACTION_INFORMATION18		=> P_OCCUPATION_O,
738 		P_ACTION_INFORMATION19		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID),
739 		P_ACTION_INFORMATION20		=> P_OE_FULL_NAME,
740 		P_ACTION_INFORMATION21		=> P_OE_CONTACT_TYPE,
741 		P_ACTION_INFORMATION22		=> P_OE_ADDRESS,
742 		P_ACTION_INFORMATION23		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID_O),
743 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
744 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);
745 end create_dep_oe;
746 --
747 procedure create_dep_oe(
748 	P_VALIDATE			in number	default hr_api.g_false_num,
749 	P_ACTION_INFORMATION_ID		in number,
750 	P_ASSIGNMENT_ACTION_ID		in number,
751 	P_EFFECTIVE_DATE		in date,
752 	P_ASSIGNMENT_ID			in number,
753 	P_STATUS			in varchar2	default null,
754 	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
755 	P_DATETRACK_DELETE_MODE		in varchar2	default null,
756 	P_CONTACT_EXTRA_INFO_ID		in number	default null,
757 	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
758 	P_CONTACT_RELATIONSHIP_ID	in number	default null,
759 	P_LAST_NAME_KANA		in varchar2	default null,
760 	P_FIRST_NAME_KANA		in varchar2	default null,
761 	P_LAST_NAME			in varchar2	default null,
762 	P_FIRST_NAME			in varchar2	default null,
763 	P_CONTACT_TYPE			in varchar2	default null,
764 	P_DATE_OF_BIRTH			in date		default null,
765 	P_DATE_OF_DEATH			in date		default null,
766 	P_ADDRESS			in varchar2	default null,
767 	P_CHANGE_DATE			in date		default null,
768 	P_CHANGE_REASON			in varchar2	default null,
769 	P_OCCUPATION			in varchar2	default null,
770 	P_OCCUPATION_O			in varchar2	default null,
771 	P_OE_CONTACT_RELATIONSHIP_ID	in number	default null,
772 	P_OE_FULL_NAME			in varchar2	default null,
773 	P_OE_CONTACT_TYPE		in varchar2	default null,
774 	P_OE_ADDRESS			in varchar2	default null,
775 	P_OE_CONTACT_RELATIONSHIP_ID_O	in number	default null,
776 	P_OBJECT_VERSION_NUMBER		out nocopy number,
777 	p_return_status			out nocopy varchar2)
778 is
779 begin
780 	pay_action_information_swi.create_action_information(
781 		P_VALIDATE			=> P_VALIDATE,
782 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
783 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
784 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
785 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP_OE',
786 		P_EFFECTIVE_DATE		=> p_effective_date,
787 		P_ASSIGNMENT_ID			=> p_assignment_id,
788 		P_ACTION_INFORMATION1		=> P_STATUS,
789 		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
790 		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
791 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
792 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
793 		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
794 		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
795 		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
796 		P_ACTION_INFORMATION9		=> P_LAST_NAME,
797 		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
798 		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
799 		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
800 		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
801 		P_ACTION_INFORMATION14		=> P_ADDRESS,
802 		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
803 		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
804 		P_ACTION_INFORMATION17		=> P_OCCUPATION,
805 		P_ACTION_INFORMATION18		=> P_OCCUPATION_O,
806 		P_ACTION_INFORMATION19		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID),
807 		P_ACTION_INFORMATION20		=> P_OE_FULL_NAME,
808 		P_ACTION_INFORMATION21		=> P_OE_CONTACT_TYPE,
809 		P_ACTION_INFORMATION22		=> P_OE_ADDRESS,
810 		P_ACTION_INFORMATION23		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID_O),
811 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
812 		p_return_status			=> p_return_status);
813 end create_dep_oe;
814 -- |---------------------------------------------------------------------------|
815 -- |-----------------------------< update_dep_oe >-----------------------------|
816 -- |---------------------------------------------------------------------------|
817 procedure update_dep_oe(
818 	P_VALIDATE			in boolean	default false,
819 	P_ACTION_INFORMATION_ID		in number,
820 	P_OBJECT_VERSION_NUMBER		in out nocopy number,
821 	P_STATUS			in varchar2	default hr_api.g_varchar2,
822 	P_CONTACT_EXTRA_INFO_ID		in number	default hr_api.g_number,
823 	P_CEI_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
824 	P_CHANGE_DATE			in date		default hr_api.g_date,
825 	P_CHANGE_REASON			in varchar2	default hr_api.g_varchar2,
826 	P_OCCUPATION			in varchar2	default hr_api.g_varchar2,
827 	P_OE_CONTACT_RELATIONSHIP_ID	in number	default hr_api.g_number,
828 	P_OE_FULL_NAME			in varchar2	default hr_api.g_varchar2,
829 	P_OE_CONTACT_TYPE		in varchar2	default hr_api.g_varchar2,
830 	P_OE_ADDRESS			in varchar2	default hr_api.g_varchar2)
831 is
832 begin
833 	pay_action_information_api.update_action_information(
834 		P_VALIDATE			=> P_VALIDATE,
835 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
836 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
837 		P_ACTION_INFORMATION1		=> P_STATUS,
838 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
839 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
840 		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
841 		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
842 		P_ACTION_INFORMATION17		=> P_OCCUPATION,
843 		P_ACTION_INFORMATION19		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID),
844 		P_ACTION_INFORMATION20		=> P_OE_FULL_NAME,
845 		P_ACTION_INFORMATION21		=> P_OE_CONTACT_TYPE,
846 		P_ACTION_INFORMATION22		=> P_OE_ADDRESS);
847 end update_dep_oe;
848 --
849 procedure update_dep_oe(
850 	P_VALIDATE			in number	default hr_api.g_false_num,
851 	P_ACTION_INFORMATION_ID		in number,
852 	P_OBJECT_VERSION_NUMBER		in out nocopy number,
853 	P_STATUS			in varchar2	default hr_api.g_varchar2,
854 	P_CONTACT_EXTRA_INFO_ID		in number	default hr_api.g_number,
855 	P_CEI_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
856 	P_CHANGE_DATE			in date		default hr_api.g_date,
857 	P_CHANGE_REASON			in varchar2	default hr_api.g_varchar2,
858 	P_OCCUPATION			in varchar2	default hr_api.g_varchar2,
859 	P_OE_CONTACT_RELATIONSHIP_ID	in number	default hr_api.g_number,
860 	P_OE_FULL_NAME			in varchar2	default hr_api.g_varchar2,
861 	P_OE_CONTACT_TYPE		in varchar2	default hr_api.g_varchar2,
862 	P_OE_ADDRESS			in varchar2	default hr_api.g_varchar2,
863 	p_return_status			out nocopy varchar2)
864 is
865 begin
866 	pay_action_information_swi.update_action_information(
867 		P_VALIDATE			=> P_VALIDATE,
868 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
869 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
870 		P_ACTION_INFORMATION1		=> P_STATUS,
871 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
872 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
873 		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
874 		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
875 		P_ACTION_INFORMATION17		=> P_OCCUPATION,
876 		P_ACTION_INFORMATION19		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID),
877 		P_ACTION_INFORMATION20		=> P_OE_FULL_NAME,
878 		P_ACTION_INFORMATION21		=> P_OE_CONTACT_TYPE,
879 		P_ACTION_INFORMATION22		=> P_OE_ADDRESS,
880 		p_return_status			=> p_return_status);
881 end update_dep_oe;
882 -- |---------------------------------------------------------------------------|
883 -- |-----------------------------< create_dep_os >-----------------------------|
884 -- |---------------------------------------------------------------------------|
885 procedure create_dep_os(
886 	P_VALIDATE			in boolean	default false,
887 	P_ASSIGNMENT_ACTION_ID		in number,
888 	P_EFFECTIVE_DATE		in date,
889 	P_ASSIGNMENT_ID			in number,
890 	P_STATUS			in varchar2	default null,
891 	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
892 	P_DATETRACK_DELETE_MODE		in varchar2	default null,
893 	P_CONTACT_EXTRA_INFO_ID		in number	default null,
894 	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
895 	P_CONTACT_RELATIONSHIP_ID	in number	default null,
896 	P_LAST_NAME_KANA		in varchar2	default null,
897 	P_FIRST_NAME_KANA		in varchar2	default null,
898 	P_LAST_NAME			in varchar2	default null,
899 	P_FIRST_NAME			in varchar2	default null,
900 	P_CONTACT_TYPE			in varchar2	default null,
901 	P_DATE_OF_BIRTH			in date		default null,
902 	P_DATE_OF_DEATH			in date		default null,
903 	P_OCCUPATION			in varchar2	default null,
904 	P_OCCUPATION_O			in varchar2	default null,
905 	P_OS_SALARY_PAYER_NAME		in varchar2	default null,
906 	P_OS_SALARY_PAYER_NAME_O	in varchar2	default null,
907 	P_OS_SALARY_PAYER_ADDRESS	in varchar2	default null,
908 	P_OS_SALARY_PAYER_ADDRESS_O	in varchar2	default null,
909 	P_ACTION_INFORMATION_ID		out nocopy number,
910 	P_OBJECT_VERSION_NUMBER		out nocopy number)
911 is
912 begin
913 	pay_action_information_api.create_action_information(
914 		P_VALIDATE			=> P_VALIDATE,
915 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
916 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
917 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP_OS',
918 		P_EFFECTIVE_DATE		=> p_effective_date,
919 		P_ASSIGNMENT_ID			=> p_assignment_id,
920 		P_ACTION_INFORMATION1		=> P_STATUS,
921 		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
922 		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
923 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
924 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
925 		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
926 		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
927 		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
928 		P_ACTION_INFORMATION9		=> P_LAST_NAME,
929 		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
930 		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
931 		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
932 		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
933 		P_ACTION_INFORMATION14		=> P_OCCUPATION,
934 		P_ACTION_INFORMATION15		=> P_OCCUPATION_O,
935 		P_ACTION_INFORMATION16		=> P_OS_SALARY_PAYER_NAME,
936 		P_ACTION_INFORMATION17		=> P_OS_SALARY_PAYER_NAME_O,
937 		P_ACTION_INFORMATION18		=> P_OS_SALARY_PAYER_ADDRESS,
938 		P_ACTION_INFORMATION19		=> P_OS_SALARY_PAYER_ADDRESS_O,
939 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
940 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);
941 end create_dep_os;
942 --
943 procedure create_dep_os(
944 	P_VALIDATE			in number	default hr_api.g_false_num,
945 	P_ACTION_INFORMATION_ID		in number,
946 	P_ASSIGNMENT_ACTION_ID		in number,
947 	P_EFFECTIVE_DATE		in date,
948 	P_ASSIGNMENT_ID			in number,
949 	P_STATUS			in varchar2	default null,
950 	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
951 	P_DATETRACK_DELETE_MODE		in varchar2	default null,
952 	P_CONTACT_EXTRA_INFO_ID		in number	default null,
953 	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
954 	P_CONTACT_RELATIONSHIP_ID	in number	default null,
955 	P_LAST_NAME_KANA		in varchar2	default null,
956 	P_FIRST_NAME_KANA		in varchar2	default null,
957 	P_LAST_NAME			in varchar2	default null,
958 	P_FIRST_NAME			in varchar2	default null,
959 	P_CONTACT_TYPE			in varchar2	default null,
960 	P_DATE_OF_BIRTH			in date		default null,
961 	P_DATE_OF_DEATH			in date		default null,
962 	P_OCCUPATION			in varchar2	default null,
963 	P_OCCUPATION_O			in varchar2	default null,
964 	P_OS_SALARY_PAYER_NAME		in varchar2	default null,
965 	P_OS_SALARY_PAYER_NAME_O	in varchar2	default null,
966 	P_OS_SALARY_PAYER_ADDRESS	in varchar2	default null,
967 	P_OS_SALARY_PAYER_ADDRESS_O	in varchar2	default null,
968 	P_OBJECT_VERSION_NUMBER		out nocopy number,
969 	p_return_status			out nocopy varchar2)
970 is
971 begin
972 	pay_action_information_swi.create_action_information(
973 		P_VALIDATE			=> P_VALIDATE,
974 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
975 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
976 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
977 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP_OS',
978 		P_EFFECTIVE_DATE		=> p_effective_date,
979 		P_ASSIGNMENT_ID			=> p_assignment_id,
980 		P_ACTION_INFORMATION1		=> P_STATUS,
981 		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
982 		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
983 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
984 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
985 		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
986 		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
987 		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
988 		P_ACTION_INFORMATION9		=> P_LAST_NAME,
989 		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
990 		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
991 		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
992 		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
993 		P_ACTION_INFORMATION14		=> P_OCCUPATION,
994 		P_ACTION_INFORMATION15		=> P_OCCUPATION_O,
995 		P_ACTION_INFORMATION16		=> P_OS_SALARY_PAYER_NAME,
996 		P_ACTION_INFORMATION17		=> P_OS_SALARY_PAYER_NAME_O,
997 		P_ACTION_INFORMATION18		=> P_OS_SALARY_PAYER_ADDRESS,
998 		P_ACTION_INFORMATION19		=> P_OS_SALARY_PAYER_ADDRESS_O,
999 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
1000 		p_return_status			=> p_return_status);
1001 end create_dep_os;
1002 -- |---------------------------------------------------------------------------|
1003 -- |-----------------------------< update_dep_os >-----------------------------|
1004 -- |---------------------------------------------------------------------------|
1005 procedure update_dep_os(
1006 	P_VALIDATE			in boolean	default false,
1007 	P_ACTION_INFORMATION_ID		in number,
1008 	P_OBJECT_VERSION_NUMBER		in out nocopy number,
1009 	P_STATUS			in varchar2	default hr_api.g_varchar2,
1010 	P_CONTACT_EXTRA_INFO_ID		in number	default hr_api.g_number,
1011 	P_CEI_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
1012 	P_OCCUPATION			in varchar2	default hr_api.g_varchar2,
1013 	P_OS_SALARY_PAYER_NAME		in varchar2	default hr_api.g_varchar2,
1014 	P_OS_SALARY_PAYER_ADDRESS	in varchar2	default hr_api.g_varchar2)
1015 is
1016 begin
1017 	pay_action_information_api.update_action_information(
1018 		P_VALIDATE			=> P_VALIDATE,
1019 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
1020 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
1021 		P_ACTION_INFORMATION1		=> P_STATUS,
1022 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
1023 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
1024 		P_ACTION_INFORMATION14		=> P_OCCUPATION,
1025 		P_ACTION_INFORMATION16		=> P_OS_SALARY_PAYER_NAME,
1026 		P_ACTION_INFORMATION18		=> P_OS_SALARY_PAYER_ADDRESS);
1027 end update_dep_os;
1028 --
1029 procedure update_dep_os(
1030 	P_VALIDATE			in number	default hr_api.g_false_num,
1031 	P_ACTION_INFORMATION_ID		in number,
1032 	P_OBJECT_VERSION_NUMBER		in out nocopy number,
1033 	P_STATUS			in varchar2	default hr_api.g_varchar2,
1034 	P_CONTACT_EXTRA_INFO_ID		in number	default hr_api.g_number,
1035 	P_CEI_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
1036 	P_OCCUPATION			in varchar2	default hr_api.g_varchar2,
1037 	P_OS_SALARY_PAYER_NAME		in varchar2	default hr_api.g_varchar2,
1038 	P_OS_SALARY_PAYER_ADDRESS	in varchar2	default hr_api.g_varchar2,
1039 	p_return_status			out nocopy varchar2)
1040 is
1041 begin
1042 	pay_action_information_swi.update_action_information(
1043 		P_VALIDATE			=> P_VALIDATE,
1044 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
1045 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
1046 		P_ACTION_INFORMATION1		=> P_STATUS,
1047 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
1048 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
1049 		P_ACTION_INFORMATION14		=> P_OCCUPATION,
1050 		P_ACTION_INFORMATION16		=> P_OS_SALARY_PAYER_NAME,
1051 		P_ACTION_INFORMATION18		=> P_OS_SALARY_PAYER_ADDRESS,
1052 		p_return_status			=> p_return_status);
1053 end update_dep_os;
1054 --
1055 end pay_jp_def_api;