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.4 2011/02/23 09:15:33 keyazawa ship $ */
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_employee_number             in varchar2 default null,
262   p_district_name               in varchar2 default null,
263   p_sec_sal_submit_flag         in varchar2 default null,
264   P_ACTION_INFORMATION_ID       out nocopy number,
265   P_OBJECT_VERSION_NUMBER       out nocopy number)
266 is
267 begin
268 --
269   pay_action_information_api.create_action_information(
270     P_VALIDATE                    => P_VALIDATE,
271     P_ACTION_CONTEXT_ID           => p_assignment_action_id,
272     P_ACTION_CONTEXT_TYPE         => 'AAP',
273     P_ACTION_INFORMATION_CATEGORY => 'JP_DEF_EMP',
274     P_EFFECTIVE_DATE              => p_effective_date,
275     P_ASSIGNMENT_ID               => p_assignment_id,
276     P_ACTION_INFORMATION1         => P_LAST_NAME_KANA,
277     P_ACTION_INFORMATION2         => P_FIRST_NAME_KANA,
278     P_ACTION_INFORMATION3         => P_LAST_NAME,
279     P_ACTION_INFORMATION4         => P_FIRST_NAME,
280     P_ACTION_INFORMATION5         => to_canonical(P_DATE_OF_BIRTH),
281     P_ACTION_INFORMATION6         => to_canonical(P_DATE_OF_DEATH),
282     P_ACTION_INFORMATION7         => P_SEX,
283     P_ACTION_INFORMATION8         => P_POSTAL_CODE,
284     P_ACTION_INFORMATION9         => P_ADDRESS,
285     P_ACTION_INFORMATION10        => to_canonical(P_HOUSEHOLD_HEAD_CTR_ID),
286     P_ACTION_INFORMATION11        => P_HOUSEHOLD_HEAD_FULL_NAME,
287     P_ACTION_INFORMATION12        => P_HOUSEHOLD_HEAD_CONTACT_TYPE,
288     P_ACTION_INFORMATION13        => P_MARRIED_FLAG,
289     P_ACTION_INFORMATION14        => to_canonical(P_CHANGE_DATE),
290     P_ACTION_INFORMATION15        => P_CHANGE_REASON,
291     P_ACTION_INFORMATION16        => P_DISABILITY_TYPE,
292     P_ACTION_INFORMATION17        => P_DISABILITY_DETAILS,
293     P_ACTION_INFORMATION18        => P_AGED_TYPE,
294     P_ACTION_INFORMATION19        => P_AGED_DETAILS,
295     P_ACTION_INFORMATION20        => P_WIDOW_TYPE,
296     P_ACTION_INFORMATION21        => P_WIDOW_DETAILS,
297     P_ACTION_INFORMATION22        => P_WORKING_STUDENT_TYPE,
298     P_ACTION_INFORMATION23        => P_WORKING_STUDENT_DETAILS,
299     P_ACTION_INFORMATION24        => p_employee_number,
300     P_ACTION_INFORMATION25        => p_district_name,
301     P_ACTION_INFORMATION26        => p_sec_sal_submit_flag,
302     P_ACTION_INFORMATION_ID       => p_action_information_id,
303     P_OBJECT_VERSION_NUMBER       => p_object_version_number);
304 --
305 end create_emp;
306 -- |---------------------------------------------------------------------------|
307 -- |------------------------------< update_emp >-------------------------------|
308 -- |---------------------------------------------------------------------------|
309 procedure update_emp(
310   P_VALIDATE                in number default hr_api.g_false_num,
311   P_ACTION_INFORMATION_ID   in number,
312   P_OBJECT_VERSION_NUMBER   in out nocopy number,
313   p_postal_code             in varchar2 default hr_api.g_varchar2,
314   p_address                 in varchar2 default hr_api.g_varchar2,
315   P_CHANGE_DATE             in date     default hr_api.g_date,
316   P_CHANGE_REASON           in varchar2 default hr_api.g_varchar2,
317   P_DISABILITY_TYPE         in varchar2 default hr_api.g_varchar2,
318   P_DISABILITY_DETAILS      in varchar2 default hr_api.g_varchar2,
319   P_AGED_TYPE               in varchar2 default hr_api.g_varchar2,
320   P_AGED_DETAILS            in varchar2 default hr_api.g_varchar2,
321   P_WIDOW_TYPE              in varchar2 default hr_api.g_varchar2,
322   P_WIDOW_DETAILS           in varchar2 default hr_api.g_varchar2,
323   P_WORKING_STUDENT_TYPE    in varchar2 default hr_api.g_varchar2,
324   P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
325   p_employee_number         in varchar2 default hr_api.g_varchar2,
326   p_district_name           in varchar2 default hr_api.g_varchar2,
327   p_sec_sal_submit_flag     in varchar2 default hr_api.g_varchar2,
328   p_return_status           out nocopy varchar2)
329 is
330 begin
331 --
332   pay_action_information_swi.update_action_information(
333     P_VALIDATE              => P_VALIDATE,
334     P_ACTION_INFORMATION_ID => p_action_information_id,
335     P_OBJECT_VERSION_NUMBER => p_object_version_number,
336     P_ACTION_INFORMATION8   => p_postal_code,
337     P_ACTION_INFORMATION9   => p_address,
338     P_ACTION_INFORMATION14  => to_canonical(P_CHANGE_DATE),
339     P_ACTION_INFORMATION15  => P_CHANGE_REASON,
340     P_ACTION_INFORMATION16  => P_DISABILITY_TYPE,
341     P_ACTION_INFORMATION17  => P_DISABILITY_DETAILS,
342     P_ACTION_INFORMATION18  => P_AGED_TYPE,
343     P_ACTION_INFORMATION19  => P_AGED_DETAILS,
344     P_ACTION_INFORMATION20  => P_WIDOW_TYPE,
345     P_ACTION_INFORMATION21  => P_WIDOW_DETAILS,
346     P_ACTION_INFORMATION22  => P_WORKING_STUDENT_TYPE,
347     P_ACTION_INFORMATION23  => P_WORKING_STUDENT_DETAILS,
348     P_ACTION_INFORMATION24  => p_employee_number,
349     P_ACTION_INFORMATION25  => p_district_name,
350     P_ACTION_INFORMATION26  => p_sec_sal_submit_flag,
351     p_return_status         => p_return_status);
352 --
353 end update_emp;
354 -- |---------------------------------------------------------------------------|
355 -- |-----------------------------< create_entry >------------------------------|
356 -- |---------------------------------------------------------------------------|
357 procedure create_entry(
358 	P_VALIDATE			in boolean	default false,
359 	P_ASSIGNMENT_ACTION_ID		in number,
360 	P_EFFECTIVE_DATE		in date,
361 	P_ASSIGNMENT_ID			in number,
362 	P_STATUS			in varchar2	default null,
363 	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
364 	P_ELEMENT_ENTRY_ID		in number	default null,
365 	P_EE_OBJECT_VERSION_NUMBER	in number	default null,
366 	P_DISABILITY_TYPE		in varchar2	default null,
367 	P_DISABILITY_TYPE_O		in varchar2	default null,
368 	P_AGED_TYPE			in varchar2	default null,
369 	P_AGED_TYPE_O			in varchar2	default null,
370 	P_WIDOW_TYPE			in varchar2	default null,
371 	P_WIDOW_TYPE_O			in varchar2	default null,
372 	P_WORKING_STUDENT_TYPE		in varchar2	default null,
373 	P_WORKING_STUDENT_TYPE_O	in varchar2	default null,
374 	P_SPOUSE_DEP_TYPE		in varchar2	default null,
375 	P_SPOUSE_DEP_TYPE_O		in varchar2	default null,
376 	P_SPOUSE_DISABILITY_TYPE	in varchar2	default null,
377 	P_SPOUSE_DISABILITY_TYPE_O	in varchar2	default null,
378 	P_NUM_DEPS			in number	default null,
379 	P_NUM_DEPS_O			in number	default null,
380 	P_NUM_AGEDS			in number	default null,
381 	P_NUM_AGEDS_O			in number	default null,
382 	P_NUM_AGED_PARENTS_LT		in number	default null,
383 	P_NUM_AGED_PARENTS_LT_O		in number	default null,
384 	P_NUM_SPECIFIEDS		in number	default null,
385 	P_NUM_SPECIFIEDS_O		in number	default null,
386 	P_NUM_DISABLEDS			in number	default null,
387 	P_NUM_DISABLEDS_O		in number	default null,
388 	P_NUM_SVR_DISABLEDS		in number	default null,
389 	P_NUM_SVR_DISABLEDS_O		in number	default null,
390 	P_NUM_SVR_DISABLEDS_LT		in number	default null,
391 	P_NUM_SVR_DISABLEDS_LT_O	in number	default null,
392 	P_ACTION_INFORMATION_ID		out nocopy number,
393 	P_OBJECT_VERSION_NUMBER		out nocopy number)
394 is
395 begin
396 	pay_action_information_api.create_action_information(
397 		P_VALIDATE			=> P_VALIDATE,
398 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
399 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
400 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_ENTRY',
401 		P_EFFECTIVE_DATE		=> p_effective_date,
402 		P_ASSIGNMENT_ID			=> p_assignment_id,
403 		P_ACTION_INFORMATION1		=> P_STATUS,
404 		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
405 		P_ACTION_INFORMATION3		=> to_canonical(P_ELEMENT_ENTRY_ID),
406 		P_ACTION_INFORMATION4		=> to_canonical(P_EE_OBJECT_VERSION_NUMBER),
407 		P_ACTION_INFORMATION5		=> P_DISABILITY_TYPE,
408 		P_ACTION_INFORMATION6		=> P_DISABILITY_TYPE_O,
409 		P_ACTION_INFORMATION7		=> P_AGED_TYPE,
410 		P_ACTION_INFORMATION8		=> P_AGED_TYPE_O,
411 		P_ACTION_INFORMATION9		=> P_WIDOW_TYPE,
412 		P_ACTION_INFORMATION10		=> P_WIDOW_TYPE_O,
413 		P_ACTION_INFORMATION11		=> P_WORKING_STUDENT_TYPE,
414 		P_ACTION_INFORMATION12		=> P_WORKING_STUDENT_TYPE_O,
415 		P_ACTION_INFORMATION13		=> P_SPOUSE_DEP_TYPE,
416 		P_ACTION_INFORMATION14		=> P_SPOUSE_DEP_TYPE_O,
417 		P_ACTION_INFORMATION15		=> P_SPOUSE_DISABILITY_TYPE,
418 		P_ACTION_INFORMATION16		=> P_SPOUSE_DISABILITY_TYPE_O,
419 		P_ACTION_INFORMATION17		=> to_canonical(P_NUM_DEPS),
420 		P_ACTION_INFORMATION18		=> to_canonical(P_NUM_DEPS_O),
421 		P_ACTION_INFORMATION19		=> to_canonical(P_NUM_AGEDS),
422 		P_ACTION_INFORMATION20		=> to_canonical(P_NUM_AGEDS_O),
423 		P_ACTION_INFORMATION21		=> to_canonical(P_NUM_AGED_PARENTS_LT),
424 		P_ACTION_INFORMATION22		=> to_canonical(P_NUM_AGED_PARENTS_LT_O),
425 		P_ACTION_INFORMATION23		=> to_canonical(P_NUM_SPECIFIEDS),
426 		P_ACTION_INFORMATION24		=> to_canonical(P_NUM_SPECIFIEDS_O),
427 		P_ACTION_INFORMATION25		=> to_canonical(P_NUM_DISABLEDS),
428 		P_ACTION_INFORMATION26		=> to_canonical(P_NUM_DISABLEDS_O),
429 		P_ACTION_INFORMATION27		=> to_canonical(P_NUM_SVR_DISABLEDS),
430 		P_ACTION_INFORMATION28		=> to_canonical(P_NUM_SVR_DISABLEDS_O),
431 		P_ACTION_INFORMATION29		=> to_canonical(P_NUM_SVR_DISABLEDS_LT),
432 		P_ACTION_INFORMATION30		=> to_canonical(P_NUM_SVR_DISABLEDS_LT_O),
433 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
434 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);
435 end create_entry;
436 -- |---------------------------------------------------------------------------|
437 -- |-----------------------------< update_entry >------------------------------|
438 -- |---------------------------------------------------------------------------|
439 procedure update_entry(
440 	P_VALIDATE			in boolean	default false,
441 	P_ACTION_INFORMATION_ID		in number,
442 	P_OBJECT_VERSION_NUMBER		in out nocopy number,
443 	P_STATUS			in varchar2	default hr_api.g_varchar2,
444 	P_ELEMENT_ENTRY_ID		in number	default hr_api.g_number,
445 	P_EE_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
446 	P_DISABILITY_TYPE		in varchar2	default hr_api.g_varchar2,
447 	P_AGED_TYPE			in varchar2	default hr_api.g_varchar2,
448 	P_WIDOW_TYPE			in varchar2	default hr_api.g_varchar2,
449 	P_WORKING_STUDENT_TYPE		in varchar2	default hr_api.g_varchar2,
450 	P_SPOUSE_DEP_TYPE		in varchar2	default hr_api.g_varchar2,
451 	P_SPOUSE_DISABILITY_TYPE	in varchar2	default hr_api.g_varchar2,
452 	P_NUM_DEPS			in number	default hr_api.g_number,
453 	P_NUM_AGEDS			in number	default hr_api.g_number,
454 	P_NUM_AGED_PARENTS_LT		in number	default hr_api.g_number,
455 	P_NUM_SPECIFIEDS		in number	default hr_api.g_number,
456 	P_NUM_DISABLEDS			in number	default hr_api.g_number,
457 	P_NUM_SVR_DISABLEDS		in number	default hr_api.g_number,
458 	P_NUM_SVR_DISABLEDS_LT		in number	default hr_api.g_number)
459 is
460 begin
461 	pay_action_information_api.update_action_information(
462 		P_VALIDATE			=> P_VALIDATE,
463 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
464 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
465 		P_ACTION_INFORMATION1		=> P_STATUS,
466 		P_ACTION_INFORMATION3		=> to_canonical(P_ELEMENT_ENTRY_ID),
467 		P_ACTION_INFORMATION4		=> to_canonical(P_EE_OBJECT_VERSION_NUMBER),
468 		P_ACTION_INFORMATION5		=> P_DISABILITY_TYPE,
469 		P_ACTION_INFORMATION7		=> P_AGED_TYPE,
470 		P_ACTION_INFORMATION9		=> P_WIDOW_TYPE,
471 		P_ACTION_INFORMATION11		=> P_WORKING_STUDENT_TYPE,
472 		P_ACTION_INFORMATION13		=> P_SPOUSE_DEP_TYPE,
473 		P_ACTION_INFORMATION15		=> P_SPOUSE_DISABILITY_TYPE,
474 		P_ACTION_INFORMATION17		=> to_canonical(P_NUM_DEPS),
475 		P_ACTION_INFORMATION19		=> to_canonical(P_NUM_AGEDS),
476 		P_ACTION_INFORMATION21		=> to_canonical(P_NUM_AGED_PARENTS_LT),
477 		P_ACTION_INFORMATION23		=> to_canonical(P_NUM_SPECIFIEDS),
478 		P_ACTION_INFORMATION25		=> to_canonical(P_NUM_DISABLEDS),
479 		P_ACTION_INFORMATION27		=> to_canonical(P_NUM_SVR_DISABLEDS),
480 		P_ACTION_INFORMATION29		=> to_canonical(P_NUM_SVR_DISABLEDS_LT));
481 end update_entry;
482 -- |---------------------------------------------------------------------------|
483 -- |------------------------------< create_dep >-------------------------------|
484 -- |---------------------------------------------------------------------------|
485 procedure create_dep(
486 	P_VALIDATE			in boolean	default false,
487 	P_ASSIGNMENT_ACTION_ID		in number,
488 	P_EFFECTIVE_DATE		in date,
489 	P_ASSIGNMENT_ID			in number,
490 	P_STATUS			in varchar2	default null,
491 	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
492 	P_DATETRACK_DELETE_MODE		in varchar2	default null,
493 	P_CONTACT_EXTRA_INFO_ID		in number	default null,
494 	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
495 	P_CONTACT_RELATIONSHIP_ID	in number	default null,
496 	P_LAST_NAME_KANA		in varchar2	default null,
497 	P_FIRST_NAME_KANA		in varchar2	default null,
498 	P_LAST_NAME			in varchar2	default null,
499 	P_FIRST_NAME			in varchar2	default null,
500 	P_CONTACT_TYPE			in varchar2	default null,
501 	P_DATE_OF_BIRTH			in date		default null,
502 	P_DATE_OF_DEATH			in date		default null,
503 	P_ADDRESS			in varchar2	default null,
504 	P_CHANGE_DATE			in date		default null,
505 	P_CHANGE_REASON			in varchar2	default null,
506 	P_DEP_TYPE			in varchar2	default null,
507 	P_DEP_TYPE_O			in varchar2	default null,
508 	P_OCCUPATION			in varchar2	default null,
509 	P_OCCUPATION_O			in varchar2	default null,
510 	P_ESTIMATED_ANNUAL_INCOME	in number	default null,
511 	P_ESTIMATED_ANNUAL_INCOME_O	in number	default null,
512 	P_DISABILITY_TYPE		in varchar2	default null,
513 	P_DISABILITY_TYPE_O		in varchar2	default null,
514 	P_DISABILITY_DETAILS		in varchar2	default null,
515 	P_DISABILITY_DETAILS_O		in varchar2	default null,
516 	P_ACTION_INFORMATION_ID		out nocopy number,
517 	P_OBJECT_VERSION_NUMBER		out nocopy number)
518 is
519 begin
520 	pay_action_information_api.create_action_information(
521 		P_VALIDATE			=> P_VALIDATE,
522 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
523 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
524 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP',
525 		P_EFFECTIVE_DATE		=> p_effective_date,
526 		P_ASSIGNMENT_ID			=> p_assignment_id,
527 		P_ACTION_INFORMATION1		=> P_STATUS,
528 		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
529 		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
530 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
531 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
532 		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
533 		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
534 		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
535 		P_ACTION_INFORMATION9		=> P_LAST_NAME,
536 		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
537 		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
538 		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
539 		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
540 		P_ACTION_INFORMATION14		=> P_ADDRESS,
541 		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
542 		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
543 		P_ACTION_INFORMATION17		=> P_DEP_TYPE,
544 		P_ACTION_INFORMATION18		=> P_DEP_TYPE_O,
545 		P_ACTION_INFORMATION19		=> P_OCCUPATION,
546 		P_ACTION_INFORMATION20		=> P_OCCUPATION_O,
547 		P_ACTION_INFORMATION21		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME),
548 		P_ACTION_INFORMATION22		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME_O),
549 		P_ACTION_INFORMATION23		=> P_DISABILITY_TYPE,
550 		P_ACTION_INFORMATION24		=> P_DISABILITY_TYPE_O,
551 		P_ACTION_INFORMATION25		=> P_DISABILITY_DETAILS,
552 		P_ACTION_INFORMATION26		=> P_DISABILITY_DETAILS_O,
553 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
554 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);
555 end create_dep;
556 --
557 procedure create_dep(
558 	P_VALIDATE			in number	default hr_api.g_false_num,
559 	P_ACTION_INFORMATION_ID		in number,
560 	P_ASSIGNMENT_ACTION_ID		in number,
561 	P_EFFECTIVE_DATE		in date,
562 	P_ASSIGNMENT_ID			in number,
563 	P_STATUS			in varchar2	default null,
564 	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
565 	P_DATETRACK_DELETE_MODE		in varchar2	default null,
566 	P_CONTACT_EXTRA_INFO_ID		in number	default null,
567 	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
568 	P_CONTACT_RELATIONSHIP_ID	in number	default null,
569 	P_LAST_NAME_KANA		in varchar2	default null,
570 	P_FIRST_NAME_KANA		in varchar2	default null,
571 	P_LAST_NAME			in varchar2	default null,
572 	P_FIRST_NAME			in varchar2	default null,
573 	P_CONTACT_TYPE			in varchar2	default null,
574 	P_DATE_OF_BIRTH			in date		default null,
575 	P_DATE_OF_DEATH			in date		default null,
576 	P_ADDRESS			in varchar2	default null,
577 	P_CHANGE_DATE			in date		default null,
578 	P_CHANGE_REASON			in varchar2	default null,
579 	P_DEP_TYPE			in varchar2	default null,
580 	P_DEP_TYPE_O			in varchar2	default null,
581 	P_OCCUPATION			in varchar2	default null,
582 	P_OCCUPATION_O			in varchar2	default null,
583 	P_ESTIMATED_ANNUAL_INCOME	in number	default null,
584 	P_ESTIMATED_ANNUAL_INCOME_O	in number	default null,
585 	P_DISABILITY_TYPE		in varchar2	default null,
586 	P_DISABILITY_TYPE_O		in varchar2	default null,
587 	P_DISABILITY_DETAILS		in varchar2	default null,
588 	P_DISABILITY_DETAILS_O		in varchar2	default null,
589 	P_OBJECT_VERSION_NUMBER		out nocopy number,
590 	p_return_status			out nocopy varchar2)
591 is
592 begin
593 	pay_action_information_swi.create_action_information(
594 		P_VALIDATE			=> P_VALIDATE,
595 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
596 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
597 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
598 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP',
599 		P_EFFECTIVE_DATE		=> p_effective_date,
600 		P_ASSIGNMENT_ID			=> p_assignment_id,
601 		P_ACTION_INFORMATION1		=> P_STATUS,
602 		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
603 		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
604 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
605 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
606 		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
607 		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
608 		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
609 		P_ACTION_INFORMATION9		=> P_LAST_NAME,
610 		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
611 		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
612 		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
613 		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
614 		P_ACTION_INFORMATION14		=> P_ADDRESS,
615 		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
616 		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
617 		P_ACTION_INFORMATION17		=> P_DEP_TYPE,
618 		P_ACTION_INFORMATION18		=> P_DEP_TYPE_O,
619 		P_ACTION_INFORMATION19		=> P_OCCUPATION,
620 		P_ACTION_INFORMATION20		=> P_OCCUPATION_O,
621 		P_ACTION_INFORMATION21		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME),
622 		P_ACTION_INFORMATION22		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME_O),
623 		P_ACTION_INFORMATION23		=> P_DISABILITY_TYPE,
624 		P_ACTION_INFORMATION24		=> P_DISABILITY_TYPE_O,
625 		P_ACTION_INFORMATION25		=> P_DISABILITY_DETAILS,
626 		P_ACTION_INFORMATION26		=> P_DISABILITY_DETAILS_O,
627 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
628 		p_return_status			=> p_return_status);
629 end create_dep;
630 -- |---------------------------------------------------------------------------|
631 -- |------------------------------< update_dep >-------------------------------|
632 -- |---------------------------------------------------------------------------|
633 procedure update_dep(
634   P_VALIDATE                  in boolean  default false,
635   P_ACTION_INFORMATION_ID     in number,
636   P_OBJECT_VERSION_NUMBER     in out nocopy number,
637   P_STATUS                    in varchar2 default hr_api.g_varchar2,
638   P_CONTACT_EXTRA_INFO_ID     in number default hr_api.g_number,
639   P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
640   P_CHANGE_DATE               in date   default hr_api.g_date,
641   P_CHANGE_REASON             in varchar2 default hr_api.g_varchar2,
642   P_DEP_TYPE                  in varchar2 default hr_api.g_varchar2,
643   P_OCCUPATION                in varchar2 default hr_api.g_varchar2,
644   P_ESTIMATED_ANNUAL_INCOME   in number default hr_api.g_number,
645   P_DISABILITY_TYPE           in varchar2 default hr_api.g_varchar2,
646   P_DISABILITY_DETAILS        in varchar2 default hr_api.g_varchar2,
647   p_address                   in varchar2 default hr_api.g_varchar2)
648 is
649 begin
650 --
651   pay_action_information_api.update_action_information(
652     P_VALIDATE              => P_VALIDATE,
653     P_ACTION_INFORMATION_ID => p_action_information_id,
654     P_OBJECT_VERSION_NUMBER => p_object_version_number,
655     P_ACTION_INFORMATION1   => P_STATUS,
656     P_ACTION_INFORMATION4   => to_canonical(P_CONTACT_EXTRA_INFO_ID),
657     P_ACTION_INFORMATION5   => to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
658     P_ACTION_INFORMATION15  => to_canonical(P_CHANGE_DATE),
659     P_ACTION_INFORMATION16  => P_CHANGE_REASON,
660     P_ACTION_INFORMATION17  => P_DEP_TYPE,
661     P_ACTION_INFORMATION19  => P_OCCUPATION,
662     P_ACTION_INFORMATION21  => to_canonical(P_ESTIMATED_ANNUAL_INCOME),
663     P_ACTION_INFORMATION23  => P_DISABILITY_TYPE,
664     P_ACTION_INFORMATION25  => P_DISABILITY_DETAILS,
665     p_action_information14  => p_address);
666 --
667 end update_dep;
668 --
669 procedure update_dep(
670   P_VALIDATE                  in number default hr_api.g_false_num,
671   P_ACTION_INFORMATION_ID     in number,
672   P_OBJECT_VERSION_NUMBER     in out nocopy number,
673   P_STATUS                    in varchar2 default hr_api.g_varchar2,
674   P_CONTACT_EXTRA_INFO_ID     in number default hr_api.g_number,
675   P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
676   P_CHANGE_DATE               in date   default hr_api.g_date,
677   P_CHANGE_REASON             in varchar2 default hr_api.g_varchar2,
678   P_DEP_TYPE                  in varchar2 default hr_api.g_varchar2,
679   P_OCCUPATION                in varchar2 default hr_api.g_varchar2,
680   P_ESTIMATED_ANNUAL_INCOME   in number default hr_api.g_number,
681   P_DISABILITY_TYPE           in varchar2 default hr_api.g_varchar2,
682   P_DISABILITY_DETAILS        in varchar2 default hr_api.g_varchar2,
683   p_address                   in varchar2 default hr_api.g_varchar2,
684   p_return_status             out nocopy varchar2)
685 is
686 begin
687 --
688   pay_action_information_swi.update_action_information(
689     P_VALIDATE              => P_VALIDATE,
690     P_ACTION_INFORMATION_ID => p_action_information_id,
691     P_OBJECT_VERSION_NUMBER => p_object_version_number,
692     P_ACTION_INFORMATION1   => P_STATUS,
693     P_ACTION_INFORMATION4   => to_canonical(P_CONTACT_EXTRA_INFO_ID),
694     P_ACTION_INFORMATION5   => to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
695     P_ACTION_INFORMATION15  => to_canonical(P_CHANGE_DATE),
696     P_ACTION_INFORMATION16  => P_CHANGE_REASON,
697     P_ACTION_INFORMATION17  => P_DEP_TYPE,
698     P_ACTION_INFORMATION19  => P_OCCUPATION,
699     P_ACTION_INFORMATION21  => to_canonical(P_ESTIMATED_ANNUAL_INCOME),
700     P_ACTION_INFORMATION23  => P_DISABILITY_TYPE,
701     P_ACTION_INFORMATION25  => P_DISABILITY_DETAILS,
702     p_action_information14  => p_address,
703     p_return_status         => p_return_status);
704 --
705 end update_dep;
706 -- |---------------------------------------------------------------------------|
707 -- |-----------------------------< create_dep_oe >-----------------------------|
708 -- |---------------------------------------------------------------------------|
709 procedure create_dep_oe(
710 	P_VALIDATE			in boolean	default false,
711 	P_ASSIGNMENT_ACTION_ID		in number,
712 	P_EFFECTIVE_DATE		in date,
713 	P_ASSIGNMENT_ID			in number,
714 	P_STATUS			in varchar2	default null,
715 	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
716 	P_DATETRACK_DELETE_MODE		in varchar2	default null,
717 	P_CONTACT_EXTRA_INFO_ID		in number	default null,
718 	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
719 	P_CONTACT_RELATIONSHIP_ID	in number	default null,
720 	P_LAST_NAME_KANA		in varchar2	default null,
721 	P_FIRST_NAME_KANA		in varchar2	default null,
722 	P_LAST_NAME			in varchar2	default null,
723 	P_FIRST_NAME			in varchar2	default null,
724 	P_CONTACT_TYPE			in varchar2	default null,
725 	P_DATE_OF_BIRTH			in date		default null,
726 	P_DATE_OF_DEATH			in date		default null,
727 	P_ADDRESS			in varchar2	default null,
728 	P_CHANGE_DATE			in date		default null,
729 	P_CHANGE_REASON			in varchar2	default null,
730 	P_OCCUPATION			in varchar2	default null,
731 	P_OCCUPATION_O			in varchar2	default null,
732 	P_OE_CONTACT_RELATIONSHIP_ID	in number	default null,
733 	P_OE_FULL_NAME			in varchar2	default null,
734 	P_OE_CONTACT_TYPE		in varchar2	default null,
735 	P_OE_ADDRESS			in varchar2	default null,
736 	P_OE_CONTACT_RELATIONSHIP_ID_O	in number	default null,
737 	P_ACTION_INFORMATION_ID		out nocopy number,
738 	P_OBJECT_VERSION_NUMBER		out nocopy number)
739 is
740 begin
741 	pay_action_information_api.create_action_information(
742 		P_VALIDATE			=> P_VALIDATE,
743 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
744 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
745 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP_OE',
746 		P_EFFECTIVE_DATE		=> p_effective_date,
747 		P_ASSIGNMENT_ID			=> p_assignment_id,
748 		P_ACTION_INFORMATION1		=> P_STATUS,
749 		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
750 		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
751 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
752 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
753 		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
754 		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
755 		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
756 		P_ACTION_INFORMATION9		=> P_LAST_NAME,
757 		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
758 		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
759 		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
760 		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
761 		P_ACTION_INFORMATION14		=> P_ADDRESS,
762 		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
763 		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
764 		P_ACTION_INFORMATION17		=> P_OCCUPATION,
765 		P_ACTION_INFORMATION18		=> P_OCCUPATION_O,
766 		P_ACTION_INFORMATION19		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID),
767 		P_ACTION_INFORMATION20		=> P_OE_FULL_NAME,
768 		P_ACTION_INFORMATION21		=> P_OE_CONTACT_TYPE,
769 		P_ACTION_INFORMATION22		=> P_OE_ADDRESS,
770 		P_ACTION_INFORMATION23		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID_O),
771 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
772 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);
773 end create_dep_oe;
774 --
775 procedure create_dep_oe(
776 	P_VALIDATE			in number	default hr_api.g_false_num,
777 	P_ACTION_INFORMATION_ID		in number,
778 	P_ASSIGNMENT_ACTION_ID		in number,
779 	P_EFFECTIVE_DATE		in date,
780 	P_ASSIGNMENT_ID			in number,
781 	P_STATUS			in varchar2	default null,
782 	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
783 	P_DATETRACK_DELETE_MODE		in varchar2	default null,
784 	P_CONTACT_EXTRA_INFO_ID		in number	default null,
785 	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
786 	P_CONTACT_RELATIONSHIP_ID	in number	default null,
787 	P_LAST_NAME_KANA		in varchar2	default null,
788 	P_FIRST_NAME_KANA		in varchar2	default null,
789 	P_LAST_NAME			in varchar2	default null,
790 	P_FIRST_NAME			in varchar2	default null,
791 	P_CONTACT_TYPE			in varchar2	default null,
792 	P_DATE_OF_BIRTH			in date		default null,
793 	P_DATE_OF_DEATH			in date		default null,
794 	P_ADDRESS			in varchar2	default null,
795 	P_CHANGE_DATE			in date		default null,
796 	P_CHANGE_REASON			in varchar2	default null,
797 	P_OCCUPATION			in varchar2	default null,
798 	P_OCCUPATION_O			in varchar2	default null,
799 	P_OE_CONTACT_RELATIONSHIP_ID	in number	default null,
800 	P_OE_FULL_NAME			in varchar2	default null,
801 	P_OE_CONTACT_TYPE		in varchar2	default null,
802 	P_OE_ADDRESS			in varchar2	default null,
803 	P_OE_CONTACT_RELATIONSHIP_ID_O	in number	default null,
804 	P_OBJECT_VERSION_NUMBER		out nocopy number,
805 	p_return_status			out nocopy varchar2)
806 is
807 begin
808 	pay_action_information_swi.create_action_information(
809 		P_VALIDATE			=> P_VALIDATE,
810 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
811 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
812 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
813 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP_OE',
814 		P_EFFECTIVE_DATE		=> p_effective_date,
815 		P_ASSIGNMENT_ID			=> p_assignment_id,
816 		P_ACTION_INFORMATION1		=> P_STATUS,
817 		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
818 		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
819 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
820 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
821 		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
822 		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
823 		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
824 		P_ACTION_INFORMATION9		=> P_LAST_NAME,
825 		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
826 		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
827 		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
828 		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
829 		P_ACTION_INFORMATION14		=> P_ADDRESS,
830 		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
831 		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
832 		P_ACTION_INFORMATION17		=> P_OCCUPATION,
833 		P_ACTION_INFORMATION18		=> P_OCCUPATION_O,
834 		P_ACTION_INFORMATION19		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID),
835 		P_ACTION_INFORMATION20		=> P_OE_FULL_NAME,
836 		P_ACTION_INFORMATION21		=> P_OE_CONTACT_TYPE,
837 		P_ACTION_INFORMATION22		=> P_OE_ADDRESS,
838 		P_ACTION_INFORMATION23		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID_O),
839 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
840 		p_return_status			=> p_return_status);
841 end create_dep_oe;
842 -- |---------------------------------------------------------------------------|
843 -- |-----------------------------< update_dep_oe >-----------------------------|
844 -- |---------------------------------------------------------------------------|
845 procedure update_dep_oe(
846   P_VALIDATE                   in boolean default false,
847   P_ACTION_INFORMATION_ID      in number,
848   P_OBJECT_VERSION_NUMBER      in out nocopy number,
849   P_STATUS                     in varchar2 default hr_api.g_varchar2,
850   P_CONTACT_EXTRA_INFO_ID      in number   default hr_api.g_number,
851   P_CEI_OBJECT_VERSION_NUMBER  in number   default hr_api.g_number,
852   P_CHANGE_DATE                in date     default hr_api.g_date,
853   P_CHANGE_REASON              in varchar2 default hr_api.g_varchar2,
854   P_OCCUPATION                 in varchar2 default hr_api.g_varchar2,
855   P_OE_CONTACT_RELATIONSHIP_ID in number   default hr_api.g_number,
856   P_OE_FULL_NAME               in varchar2 default hr_api.g_varchar2,
857   P_OE_CONTACT_TYPE            in varchar2 default hr_api.g_varchar2,
858   P_OE_ADDRESS                 in varchar2 default hr_api.g_varchar2,
859   p_address                    in varchar2 default hr_api.g_varchar2)
860 is
861 begin
862 --
863   pay_action_information_api.update_action_information(
864     P_VALIDATE              => P_VALIDATE,
865     P_ACTION_INFORMATION_ID => p_action_information_id,
866     P_OBJECT_VERSION_NUMBER => p_object_version_number,
867     P_ACTION_INFORMATION1   => P_STATUS,
868     P_ACTION_INFORMATION4   => to_canonical(P_CONTACT_EXTRA_INFO_ID),
869     P_ACTION_INFORMATION5   => to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
870     p_action_information14  => p_address,
871     P_ACTION_INFORMATION15  => to_canonical(P_CHANGE_DATE),
872     P_ACTION_INFORMATION16  => P_CHANGE_REASON,
873     P_ACTION_INFORMATION17  => P_OCCUPATION,
874     P_ACTION_INFORMATION19  => to_canonical(P_OE_CONTACT_RELATIONSHIP_ID),
875     P_ACTION_INFORMATION20  => P_OE_FULL_NAME,
876     P_ACTION_INFORMATION21  => P_OE_CONTACT_TYPE,
877     P_ACTION_INFORMATION22  => P_OE_ADDRESS);
878 --
879 end update_dep_oe;
880 --
881 procedure update_dep_oe(
882   P_VALIDATE                      in number default hr_api.g_false_num,
883   P_ACTION_INFORMATION_ID         in number,
884   P_OBJECT_VERSION_NUMBER         in out nocopy number,
885   P_STATUS                        in varchar2 default hr_api.g_varchar2,
886   P_CONTACT_EXTRA_INFO_ID         in number   default hr_api.g_number,
887   P_CEI_OBJECT_VERSION_NUMBER     in number   default hr_api.g_number,
888   P_CHANGE_DATE                   in date     default hr_api.g_date,
889   P_CHANGE_REASON                 in varchar2 default hr_api.g_varchar2,
890   P_OCCUPATION                    in varchar2 default hr_api.g_varchar2,
891   P_OE_CONTACT_RELATIONSHIP_ID    in number   default hr_api.g_number,
892   P_OE_FULL_NAME                  in varchar2 default hr_api.g_varchar2,
893   P_OE_CONTACT_TYPE               in varchar2 default hr_api.g_varchar2,
894   P_OE_ADDRESS                    in varchar2 default hr_api.g_varchar2,
895   p_address                       in varchar2 default hr_api.g_varchar2,
896   p_return_status                 out nocopy varchar2)
897 is
898 begin
899 --
900   pay_action_information_swi.update_action_information(
901     P_VALIDATE              => P_VALIDATE,
902     P_ACTION_INFORMATION_ID => p_action_information_id,
903     P_OBJECT_VERSION_NUMBER => p_object_version_number,
904     P_ACTION_INFORMATION1   => P_STATUS,
905     P_ACTION_INFORMATION4   => to_canonical(P_CONTACT_EXTRA_INFO_ID),
906     P_ACTION_INFORMATION5   => to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
907     p_action_information14  => p_address,
908     P_ACTION_INFORMATION15  => to_canonical(P_CHANGE_DATE),
909     P_ACTION_INFORMATION16  => P_CHANGE_REASON,
910     P_ACTION_INFORMATION17  => P_OCCUPATION,
911     P_ACTION_INFORMATION19  => to_canonical(P_OE_CONTACT_RELATIONSHIP_ID),
912     P_ACTION_INFORMATION20  => P_OE_FULL_NAME,
913     P_ACTION_INFORMATION21  => P_OE_CONTACT_TYPE,
914     P_ACTION_INFORMATION22  => P_OE_ADDRESS,
915     p_return_status         => p_return_status);
916 --
917 end update_dep_oe;
918 -- |---------------------------------------------------------------------------|
919 -- |-----------------------------< create_dep_os >-----------------------------|
920 -- |---------------------------------------------------------------------------|
921 procedure create_dep_os(
922 	P_VALIDATE			in boolean	default false,
923 	P_ASSIGNMENT_ACTION_ID		in number,
924 	P_EFFECTIVE_DATE		in date,
925 	P_ASSIGNMENT_ID			in number,
926 	P_STATUS			in varchar2	default null,
927 	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
928 	P_DATETRACK_DELETE_MODE		in varchar2	default null,
929 	P_CONTACT_EXTRA_INFO_ID		in number	default null,
930 	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
931 	P_CONTACT_RELATIONSHIP_ID	in number	default null,
932 	P_LAST_NAME_KANA		in varchar2	default null,
933 	P_FIRST_NAME_KANA		in varchar2	default null,
934 	P_LAST_NAME			in varchar2	default null,
935 	P_FIRST_NAME			in varchar2	default null,
936 	P_CONTACT_TYPE			in varchar2	default null,
937 	P_DATE_OF_BIRTH			in date		default null,
938 	P_DATE_OF_DEATH			in date		default null,
939 	P_OCCUPATION			in varchar2	default null,
940 	P_OCCUPATION_O			in varchar2	default null,
941 	P_OS_SALARY_PAYER_NAME		in varchar2	default null,
942 	P_OS_SALARY_PAYER_NAME_O	in varchar2	default null,
943 	P_OS_SALARY_PAYER_ADDRESS	in varchar2	default null,
944 	P_OS_SALARY_PAYER_ADDRESS_O	in varchar2	default null,
945 	P_ACTION_INFORMATION_ID		out nocopy number,
946 	P_OBJECT_VERSION_NUMBER		out nocopy number)
947 is
948 begin
949 	pay_action_information_api.create_action_information(
950 		P_VALIDATE			=> P_VALIDATE,
951 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
952 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
953 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP_OS',
954 		P_EFFECTIVE_DATE		=> p_effective_date,
955 		P_ASSIGNMENT_ID			=> p_assignment_id,
956 		P_ACTION_INFORMATION1		=> P_STATUS,
957 		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
958 		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
959 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
960 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
961 		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
962 		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
963 		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
964 		P_ACTION_INFORMATION9		=> P_LAST_NAME,
965 		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
966 		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
967 		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
968 		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
969 		P_ACTION_INFORMATION14		=> P_OCCUPATION,
970 		P_ACTION_INFORMATION15		=> P_OCCUPATION_O,
971 		P_ACTION_INFORMATION16		=> P_OS_SALARY_PAYER_NAME,
972 		P_ACTION_INFORMATION17		=> P_OS_SALARY_PAYER_NAME_O,
973 		P_ACTION_INFORMATION18		=> P_OS_SALARY_PAYER_ADDRESS,
974 		P_ACTION_INFORMATION19		=> P_OS_SALARY_PAYER_ADDRESS_O,
975 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
976 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);
977 end create_dep_os;
978 --
979 procedure create_dep_os(
980 	P_VALIDATE			in number	default hr_api.g_false_num,
981 	P_ACTION_INFORMATION_ID		in number,
982 	P_ASSIGNMENT_ACTION_ID		in number,
983 	P_EFFECTIVE_DATE		in date,
984 	P_ASSIGNMENT_ID			in number,
985 	P_STATUS			in varchar2	default null,
986 	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
987 	P_DATETRACK_DELETE_MODE		in varchar2	default null,
988 	P_CONTACT_EXTRA_INFO_ID		in number	default null,
989 	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
990 	P_CONTACT_RELATIONSHIP_ID	in number	default null,
991 	P_LAST_NAME_KANA		in varchar2	default null,
992 	P_FIRST_NAME_KANA		in varchar2	default null,
993 	P_LAST_NAME			in varchar2	default null,
994 	P_FIRST_NAME			in varchar2	default null,
995 	P_CONTACT_TYPE			in varchar2	default null,
996 	P_DATE_OF_BIRTH			in date		default null,
997 	P_DATE_OF_DEATH			in date		default null,
998 	P_OCCUPATION			in varchar2	default null,
999 	P_OCCUPATION_O			in varchar2	default null,
1000 	P_OS_SALARY_PAYER_NAME		in varchar2	default null,
1001 	P_OS_SALARY_PAYER_NAME_O	in varchar2	default null,
1002 	P_OS_SALARY_PAYER_ADDRESS	in varchar2	default null,
1003 	P_OS_SALARY_PAYER_ADDRESS_O	in varchar2	default null,
1004 	P_OBJECT_VERSION_NUMBER		out nocopy number,
1005 	p_return_status			out nocopy varchar2)
1006 is
1007 begin
1008 	pay_action_information_swi.create_action_information(
1009 		P_VALIDATE			=> P_VALIDATE,
1010 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
1011 		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
1012 		P_ACTION_CONTEXT_TYPE		=> 'AAP',
1013 		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP_OS',
1014 		P_EFFECTIVE_DATE		=> p_effective_date,
1015 		P_ASSIGNMENT_ID			=> p_assignment_id,
1016 		P_ACTION_INFORMATION1		=> P_STATUS,
1017 		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
1018 		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
1019 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
1020 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
1021 		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
1022 		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
1023 		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
1024 		P_ACTION_INFORMATION9		=> P_LAST_NAME,
1025 		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
1026 		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
1027 		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
1028 		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
1029 		P_ACTION_INFORMATION14		=> P_OCCUPATION,
1030 		P_ACTION_INFORMATION15		=> P_OCCUPATION_O,
1031 		P_ACTION_INFORMATION16		=> P_OS_SALARY_PAYER_NAME,
1032 		P_ACTION_INFORMATION17		=> P_OS_SALARY_PAYER_NAME_O,
1033 		P_ACTION_INFORMATION18		=> P_OS_SALARY_PAYER_ADDRESS,
1034 		P_ACTION_INFORMATION19		=> P_OS_SALARY_PAYER_ADDRESS_O,
1035 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
1036 		p_return_status			=> p_return_status);
1037 end create_dep_os;
1038 -- |---------------------------------------------------------------------------|
1039 -- |-----------------------------< update_dep_os >-----------------------------|
1040 -- |---------------------------------------------------------------------------|
1041 procedure update_dep_os(
1042 	P_VALIDATE			in boolean	default false,
1043 	P_ACTION_INFORMATION_ID		in number,
1044 	P_OBJECT_VERSION_NUMBER		in out nocopy number,
1045 	P_STATUS			in varchar2	default hr_api.g_varchar2,
1046 	P_CONTACT_EXTRA_INFO_ID		in number	default hr_api.g_number,
1047 	P_CEI_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
1048 	P_OCCUPATION			in varchar2	default hr_api.g_varchar2,
1049 	P_OS_SALARY_PAYER_NAME		in varchar2	default hr_api.g_varchar2,
1050 	P_OS_SALARY_PAYER_ADDRESS	in varchar2	default hr_api.g_varchar2)
1051 is
1052 begin
1053 	pay_action_information_api.update_action_information(
1054 		P_VALIDATE			=> P_VALIDATE,
1055 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
1056 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
1057 		P_ACTION_INFORMATION1		=> P_STATUS,
1058 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
1059 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
1060 		P_ACTION_INFORMATION14		=> P_OCCUPATION,
1061 		P_ACTION_INFORMATION16		=> P_OS_SALARY_PAYER_NAME,
1062 		P_ACTION_INFORMATION18		=> P_OS_SALARY_PAYER_ADDRESS);
1063 end update_dep_os;
1064 --
1065 procedure update_dep_os(
1066 	P_VALIDATE			in number	default hr_api.g_false_num,
1067 	P_ACTION_INFORMATION_ID		in number,
1068 	P_OBJECT_VERSION_NUMBER		in out nocopy number,
1069 	P_STATUS			in varchar2	default hr_api.g_varchar2,
1070 	P_CONTACT_EXTRA_INFO_ID		in number	default hr_api.g_number,
1071 	P_CEI_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
1072 	P_OCCUPATION			in varchar2	default hr_api.g_varchar2,
1073 	P_OS_SALARY_PAYER_NAME		in varchar2	default hr_api.g_varchar2,
1074 	P_OS_SALARY_PAYER_ADDRESS	in varchar2	default hr_api.g_varchar2,
1075 	p_return_status			out nocopy varchar2)
1076 is
1077 begin
1078 	pay_action_information_swi.update_action_information(
1079 		P_VALIDATE			=> P_VALIDATE,
1080 		P_ACTION_INFORMATION_ID		=> p_action_information_id,
1081 		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
1082 		P_ACTION_INFORMATION1		=> P_STATUS,
1083 		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
1084 		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
1085 		P_ACTION_INFORMATION14		=> P_OCCUPATION,
1086 		P_ACTION_INFORMATION16		=> P_OS_SALARY_PAYER_NAME,
1087 		P_ACTION_INFORMATION18		=> P_OS_SALARY_PAYER_ADDRESS,
1088 		p_return_status			=> p_return_status);
1089 end update_dep_os;
1090 --
1091 procedure create_entry_os(
1092   p_validate                 in boolean  default false,
1093   p_assignment_action_id     in number,
1094   p_effective_date           in date,
1095   p_assignment_id            in number,
1096   p_status                   in varchar2 default null,
1097   p_datetrack_update_mode    in varchar2 default null,
1098   p_element_entry_id         in number default null,
1099   p_ee_object_version_number in number default null,
1100   p_sec_sal_submit_flag      in varchar2 default null,
1101   p_sec_sal_submit_flag_o    in varchar2 default null,
1102   p_action_information_id    out nocopy number,
1103   p_object_version_number    out nocopy number)
1104 is
1105 begin
1106 --
1107   pay_action_information_api.create_action_information(
1108     p_validate                    => p_validate,
1109     p_action_context_id           => p_assignment_action_id,
1110     p_action_context_type         => 'AAP',
1111     p_action_information_category => 'JP_DEF_ENTRY_OS',
1112     p_effective_date              => p_effective_date,
1113     p_assignment_id               => p_assignment_id,
1114     p_action_information1         => p_status,
1115     p_action_information2         => p_datetrack_update_mode,
1116     p_action_information3         => to_canonical(p_element_entry_id),
1117     p_action_information4         => to_canonical(p_ee_object_version_number),
1118     p_action_information5         => p_sec_sal_submit_flag,
1119     p_action_information6         => p_sec_sal_submit_flag_o,
1120     p_action_information_id       => p_action_information_id,
1121     p_object_version_number       => p_object_version_number);
1122 --
1123 end create_entry_os;
1124 --
1125 procedure update_entry_os(
1126   p_validate                 in boolean  default false,
1127   p_action_information_id    in number,
1128   p_object_version_number    in out nocopy number,
1129   p_status                   in varchar2 default hr_api.g_varchar2,
1130   p_element_entry_id         in number default hr_api.g_number,
1131   p_ee_object_version_number in number default hr_api.g_number,
1132   p_sec_sal_submit_flag      in varchar2 default hr_api.g_varchar2)
1133 is
1134 begin
1135 --
1136   pay_action_information_api.update_action_information(
1137     p_validate              => p_validate,
1138     p_action_information_id => p_action_information_id,
1139     p_object_version_number => p_object_version_number,
1140     p_action_information1   => p_status,
1141     p_action_information3   => to_canonical(p_element_entry_id),
1142     p_action_information4   => to_canonical(p_ee_object_version_number),
1143     p_action_information5   => p_sec_sal_submit_flag);
1144 --
1145 end update_entry_os;
1146 --
1147 procedure create_entry_dep(
1148   p_validate                 in boolean  default false,
1149   p_assignment_action_id     in number,
1150   p_effective_date           in date,
1151   p_assignment_id            in number,
1152   p_num_junior_deps          in number default null,
1153   p_num_junior_deps_o        in number default null,
1154   p_action_information_id    out nocopy number,
1155   p_object_version_number    out nocopy number)
1156 is
1157 begin
1158 --
1159   pay_action_information_api.create_action_information(
1160     p_validate                    => p_validate,
1161     p_action_context_id           => p_assignment_action_id,
1162     p_action_context_type         => 'AAP',
1163     p_action_information_category => 'JP_DEF_ENTRY_DEP',
1164     p_effective_date              => p_effective_date,
1165     p_assignment_id               => p_assignment_id,
1166     p_action_information1         => to_canonical(p_num_junior_deps),
1167     p_action_information2         => to_canonical(p_num_junior_deps_o),
1168     p_action_information_id       => p_action_information_id,
1169     p_object_version_number       => p_object_version_number);
1170 --
1171 end create_entry_dep;
1172 --
1173 procedure update_entry_dep(
1174   p_validate                 in boolean  default false,
1175   p_action_information_id    in number,
1176   p_object_version_number    in out nocopy number,
1177   p_num_junior_deps          in number default hr_api.g_number)
1178 is
1179 begin
1180 --
1181   pay_action_information_api.update_action_information(
1182     p_validate              => p_validate,
1183     p_action_information_id => p_action_information_id,
1184     p_object_version_number => p_object_version_number,
1185     p_action_information1   => to_canonical(p_num_junior_deps));
1186 --
1187 end update_entry_dep;
1188 --
1189 end pay_jp_def_api;