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.

APPS.HR_DOCUMENT_EXTRA_INFO_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_doc_extra_info >------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_doc_extra_info
12: (p_validate in number default hr_api.g_false_num
13: ,p_person_id in number
14: ,p_document_type_id in number
15: ,p_date_from in date
16: ,p_date_to in date default null

Line 123: hr_api.constant_to_boolean

119: --
120: -- Convert constant values to their corresponding boolean value
121: --
122: l_validate :=
123: hr_api.constant_to_boolean
124: (p_constant_value => p_validate);
125: --
126: -- Register Surrogate ID or user key values
127: --

Line 272: (p_validate in number default hr_api.g_false_num

268: -- ----------------------------------------------------------------------------
269: -- |-------------------------< update_doc_extra_info >------------------------|
270: -- ----------------------------------------------------------------------------
271: PROCEDURE update_doc_extra_info
272: (p_validate in number default hr_api.g_false_num
273: ,p_document_extra_info_id in number
274: ,p_person_id in number
275: ,p_document_type_id in number
276: ,p_date_from in date

Line 277: ,p_date_to in date default hr_api.g_date

273: ,p_document_extra_info_id in number
274: ,p_person_id in number
275: ,p_document_type_id in number
276: ,p_date_from in date
277: ,p_date_to in date default hr_api.g_date
278: ,p_document_number in varchar2 default hr_api.g_varchar2
279: ,p_issued_by in varchar2 default hr_api.g_varchar2
280: ,p_issued_at in varchar2 default hr_api.g_varchar2
281: ,p_issued_date in date default hr_api.g_date

Line 278: ,p_document_number in varchar2 default hr_api.g_varchar2

274: ,p_person_id in number
275: ,p_document_type_id in number
276: ,p_date_from in date
277: ,p_date_to in date default hr_api.g_date
278: ,p_document_number in varchar2 default hr_api.g_varchar2
279: ,p_issued_by in varchar2 default hr_api.g_varchar2
280: ,p_issued_at in varchar2 default hr_api.g_varchar2
281: ,p_issued_date in date default hr_api.g_date
282: ,p_issuing_authority in varchar2 default hr_api.g_varchar2

Line 279: ,p_issued_by in varchar2 default hr_api.g_varchar2

275: ,p_document_type_id in number
276: ,p_date_from in date
277: ,p_date_to in date default hr_api.g_date
278: ,p_document_number in varchar2 default hr_api.g_varchar2
279: ,p_issued_by in varchar2 default hr_api.g_varchar2
280: ,p_issued_at in varchar2 default hr_api.g_varchar2
281: ,p_issued_date in date default hr_api.g_date
282: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
283: ,p_verified_by in number default hr_api.g_number

Line 280: ,p_issued_at in varchar2 default hr_api.g_varchar2

276: ,p_date_from in date
277: ,p_date_to in date default hr_api.g_date
278: ,p_document_number in varchar2 default hr_api.g_varchar2
279: ,p_issued_by in varchar2 default hr_api.g_varchar2
280: ,p_issued_at in varchar2 default hr_api.g_varchar2
281: ,p_issued_date in date default hr_api.g_date
282: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
283: ,p_verified_by in number default hr_api.g_number
284: ,p_verified_date in date default hr_api.g_date

Line 281: ,p_issued_date in date default hr_api.g_date

277: ,p_date_to in date default hr_api.g_date
278: ,p_document_number in varchar2 default hr_api.g_varchar2
279: ,p_issued_by in varchar2 default hr_api.g_varchar2
280: ,p_issued_at in varchar2 default hr_api.g_varchar2
281: ,p_issued_date in date default hr_api.g_date
282: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
283: ,p_verified_by in number default hr_api.g_number
284: ,p_verified_date in date default hr_api.g_date
285: ,p_related_object_name in varchar2 default hr_api.g_varchar2

Line 282: ,p_issuing_authority in varchar2 default hr_api.g_varchar2

278: ,p_document_number in varchar2 default hr_api.g_varchar2
279: ,p_issued_by in varchar2 default hr_api.g_varchar2
280: ,p_issued_at in varchar2 default hr_api.g_varchar2
281: ,p_issued_date in date default hr_api.g_date
282: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
283: ,p_verified_by in number default hr_api.g_number
284: ,p_verified_date in date default hr_api.g_date
285: ,p_related_object_name in varchar2 default hr_api.g_varchar2
286: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2

Line 283: ,p_verified_by in number default hr_api.g_number

279: ,p_issued_by in varchar2 default hr_api.g_varchar2
280: ,p_issued_at in varchar2 default hr_api.g_varchar2
281: ,p_issued_date in date default hr_api.g_date
282: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
283: ,p_verified_by in number default hr_api.g_number
284: ,p_verified_date in date default hr_api.g_date
285: ,p_related_object_name in varchar2 default hr_api.g_varchar2
286: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
287: ,p_related_object_id in number default hr_api.g_number

Line 284: ,p_verified_date in date default hr_api.g_date

280: ,p_issued_at in varchar2 default hr_api.g_varchar2
281: ,p_issued_date in date default hr_api.g_date
282: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
283: ,p_verified_by in number default hr_api.g_number
284: ,p_verified_date in date default hr_api.g_date
285: ,p_related_object_name in varchar2 default hr_api.g_varchar2
286: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
287: ,p_related_object_id in number default hr_api.g_number
288: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2

Line 285: ,p_related_object_name in varchar2 default hr_api.g_varchar2

281: ,p_issued_date in date default hr_api.g_date
282: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
283: ,p_verified_by in number default hr_api.g_number
284: ,p_verified_date in date default hr_api.g_date
285: ,p_related_object_name in varchar2 default hr_api.g_varchar2
286: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
287: ,p_related_object_id in number default hr_api.g_number
288: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
289: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2

Line 286: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2

282: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
283: ,p_verified_by in number default hr_api.g_number
284: ,p_verified_date in date default hr_api.g_date
285: ,p_related_object_name in varchar2 default hr_api.g_varchar2
286: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
287: ,p_related_object_id in number default hr_api.g_number
288: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
289: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
290: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2

Line 287: ,p_related_object_id in number default hr_api.g_number

283: ,p_verified_by in number default hr_api.g_number
284: ,p_verified_date in date default hr_api.g_date
285: ,p_related_object_name in varchar2 default hr_api.g_varchar2
286: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
287: ,p_related_object_id in number default hr_api.g_number
288: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
289: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
290: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
291: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2

Line 288: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2

284: ,p_verified_date in date default hr_api.g_date
285: ,p_related_object_name in varchar2 default hr_api.g_varchar2
286: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
287: ,p_related_object_id in number default hr_api.g_number
288: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
289: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
290: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
291: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
292: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2

Line 289: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2

285: ,p_related_object_name in varchar2 default hr_api.g_varchar2
286: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
287: ,p_related_object_id in number default hr_api.g_number
288: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
289: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
290: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
291: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
292: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
293: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2

Line 290: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2

286: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
287: ,p_related_object_id in number default hr_api.g_number
288: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
289: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
290: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
291: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
292: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
293: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
294: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2

Line 291: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2

287: ,p_related_object_id in number default hr_api.g_number
288: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
289: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
290: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
291: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
292: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
293: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
294: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
295: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2

Line 292: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2

288: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
289: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
290: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
291: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
292: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
293: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
294: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
295: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
296: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2

Line 293: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2

289: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
290: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
291: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
292: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
293: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
294: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
295: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
296: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
297: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2

Line 294: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2

290: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
291: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
292: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
293: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
294: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
295: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
296: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
297: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
298: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2

Line 295: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2

291: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
292: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
293: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
294: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
295: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
296: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
297: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
298: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
299: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2

Line 296: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2

292: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
293: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
294: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
295: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
296: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
297: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
298: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
299: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
300: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2

Line 297: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2

293: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
294: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
295: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
296: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
297: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
298: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
299: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
300: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
301: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2

Line 298: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2

294: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
295: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
296: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
297: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
298: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
299: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
300: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
301: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
302: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2

Line 299: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2

295: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
296: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
297: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
298: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
299: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
300: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
301: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
302: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
303: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2

Line 300: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2

296: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
297: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
298: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
299: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
300: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
301: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
302: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
303: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
304: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2

Line 301: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2

297: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
298: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
299: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
300: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
301: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
302: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
303: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
304: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
305: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2

Line 302: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2

298: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
299: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
300: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
301: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
302: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
303: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
304: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
305: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
306: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2

Line 303: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2

299: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
300: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
301: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
302: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
303: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
304: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
305: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
306: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
307: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2

Line 304: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2

300: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
301: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
302: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
303: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
304: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
305: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
306: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
307: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
308: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2

Line 305: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2

301: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
302: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
303: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
304: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
305: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
306: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
307: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
308: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
309: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2

Line 306: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2

302: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
303: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
304: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
305: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
306: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
307: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
308: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
309: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
310: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2

Line 307: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2

303: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
304: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
305: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
306: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
307: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
308: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
309: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
310: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
311: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2

Line 308: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2

304: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
305: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
306: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
307: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
308: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
309: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
310: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
311: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
312: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2

Line 309: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2

305: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
306: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
307: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
308: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
309: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
310: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
311: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
312: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
313: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2

Line 310: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2

306: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
307: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
308: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
309: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
310: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
311: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
312: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
313: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
314: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2

Line 311: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2

307: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
308: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
309: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
310: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
311: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
312: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
313: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
314: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
315: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2

Line 312: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2

308: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
309: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
310: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
311: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
312: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
313: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
314: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
315: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
316: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2

Line 313: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2

309: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
310: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
311: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
312: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
313: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
314: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
315: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
316: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
317: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2

Line 314: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2

310: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
311: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
312: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
313: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
314: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
315: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
316: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
317: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
318: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2

Line 315: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2

311: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
312: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
313: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
314: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
315: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
316: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
317: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
318: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
319: ,p_dei_information_category in varchar2 default hr_api.g_varchar2

Line 316: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2

312: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
313: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
314: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
315: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
316: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
317: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
318: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
319: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
320: ,p_dei_information1 in varchar2 default hr_api.g_varchar2

Line 317: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2

313: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
314: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
315: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
316: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
317: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
318: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
319: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
320: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
321: ,p_dei_information2 in varchar2 default hr_api.g_varchar2

Line 318: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2

314: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
315: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
316: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
317: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
318: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
319: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
320: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
321: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
322: ,p_dei_information3 in varchar2 default hr_api.g_varchar2

Line 319: ,p_dei_information_category in varchar2 default hr_api.g_varchar2

315: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
316: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
317: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
318: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
319: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
320: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
321: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
322: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
323: ,p_dei_information4 in varchar2 default hr_api.g_varchar2

Line 320: ,p_dei_information1 in varchar2 default hr_api.g_varchar2

316: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
317: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
318: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
319: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
320: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
321: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
322: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
323: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
324: ,p_dei_information5 in varchar2 default hr_api.g_varchar2

Line 321: ,p_dei_information2 in varchar2 default hr_api.g_varchar2

317: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
318: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
319: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
320: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
321: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
322: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
323: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
324: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
325: ,p_dei_information6 in varchar2 default hr_api.g_varchar2

Line 322: ,p_dei_information3 in varchar2 default hr_api.g_varchar2

318: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
319: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
320: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
321: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
322: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
323: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
324: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
325: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
326: ,p_dei_information7 in varchar2 default hr_api.g_varchar2

Line 323: ,p_dei_information4 in varchar2 default hr_api.g_varchar2

319: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
320: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
321: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
322: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
323: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
324: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
325: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
326: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
327: ,p_dei_information8 in varchar2 default hr_api.g_varchar2

Line 324: ,p_dei_information5 in varchar2 default hr_api.g_varchar2

320: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
321: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
322: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
323: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
324: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
325: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
326: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
327: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
328: ,p_dei_information9 in varchar2 default hr_api.g_varchar2

Line 325: ,p_dei_information6 in varchar2 default hr_api.g_varchar2

321: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
322: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
323: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
324: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
325: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
326: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
327: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
328: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
329: ,p_dei_information10 in varchar2 default hr_api.g_varchar2

Line 326: ,p_dei_information7 in varchar2 default hr_api.g_varchar2

322: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
323: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
324: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
325: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
326: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
327: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
328: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
329: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
330: ,p_dei_information11 in varchar2 default hr_api.g_varchar2

Line 327: ,p_dei_information8 in varchar2 default hr_api.g_varchar2

323: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
324: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
325: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
326: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
327: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
328: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
329: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
330: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
331: ,p_dei_information12 in varchar2 default hr_api.g_varchar2

Line 328: ,p_dei_information9 in varchar2 default hr_api.g_varchar2

324: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
325: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
326: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
327: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
328: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
329: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
330: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
331: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
332: ,p_dei_information13 in varchar2 default hr_api.g_varchar2

Line 329: ,p_dei_information10 in varchar2 default hr_api.g_varchar2

325: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
326: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
327: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
328: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
329: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
330: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
331: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
332: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
333: ,p_dei_information14 in varchar2 default hr_api.g_varchar2

Line 330: ,p_dei_information11 in varchar2 default hr_api.g_varchar2

326: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
327: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
328: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
329: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
330: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
331: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
332: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
333: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
334: ,p_dei_information15 in varchar2 default hr_api.g_varchar2

Line 331: ,p_dei_information12 in varchar2 default hr_api.g_varchar2

327: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
328: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
329: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
330: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
331: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
332: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
333: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
334: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
335: ,p_dei_information16 in varchar2 default hr_api.g_varchar2

Line 332: ,p_dei_information13 in varchar2 default hr_api.g_varchar2

328: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
329: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
330: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
331: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
332: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
333: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
334: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
335: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
336: ,p_dei_information17 in varchar2 default hr_api.g_varchar2

Line 333: ,p_dei_information14 in varchar2 default hr_api.g_varchar2

329: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
330: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
331: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
332: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
333: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
334: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
335: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
336: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
337: ,p_dei_information18 in varchar2 default hr_api.g_varchar2

Line 334: ,p_dei_information15 in varchar2 default hr_api.g_varchar2

330: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
331: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
332: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
333: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
334: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
335: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
336: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
337: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
338: ,p_dei_information19 in varchar2 default hr_api.g_varchar2

Line 335: ,p_dei_information16 in varchar2 default hr_api.g_varchar2

331: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
332: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
333: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
334: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
335: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
336: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
337: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
338: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
339: ,p_dei_information20 in varchar2 default hr_api.g_varchar2

Line 336: ,p_dei_information17 in varchar2 default hr_api.g_varchar2

332: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
333: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
334: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
335: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
336: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
337: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
338: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
339: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
340: ,p_dei_information21 in varchar2 default hr_api.g_varchar2

Line 337: ,p_dei_information18 in varchar2 default hr_api.g_varchar2

333: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
334: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
335: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
336: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
337: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
338: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
339: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
340: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
341: ,p_dei_information22 in varchar2 default hr_api.g_varchar2

Line 338: ,p_dei_information19 in varchar2 default hr_api.g_varchar2

334: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
335: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
336: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
337: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
338: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
339: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
340: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
341: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
342: ,p_dei_information23 in varchar2 default hr_api.g_varchar2

Line 339: ,p_dei_information20 in varchar2 default hr_api.g_varchar2

335: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
336: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
337: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
338: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
339: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
340: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
341: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
342: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
343: ,p_dei_information24 in varchar2 default hr_api.g_varchar2

Line 340: ,p_dei_information21 in varchar2 default hr_api.g_varchar2

336: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
337: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
338: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
339: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
340: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
341: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
342: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
343: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
344: ,p_dei_information25 in varchar2 default hr_api.g_varchar2

Line 341: ,p_dei_information22 in varchar2 default hr_api.g_varchar2

337: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
338: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
339: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
340: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
341: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
342: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
343: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
344: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
345: ,p_dei_information26 in varchar2 default hr_api.g_varchar2

Line 342: ,p_dei_information23 in varchar2 default hr_api.g_varchar2

338: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
339: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
340: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
341: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
342: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
343: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
344: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
345: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
346: ,p_dei_information27 in varchar2 default hr_api.g_varchar2

Line 343: ,p_dei_information24 in varchar2 default hr_api.g_varchar2

339: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
340: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
341: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
342: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
343: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
344: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
345: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
346: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
347: ,p_dei_information28 in varchar2 default hr_api.g_varchar2

Line 344: ,p_dei_information25 in varchar2 default hr_api.g_varchar2

340: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
341: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
342: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
343: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
344: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
345: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
346: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
347: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
348: ,p_dei_information29 in varchar2 default hr_api.g_varchar2

Line 345: ,p_dei_information26 in varchar2 default hr_api.g_varchar2

341: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
342: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
343: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
344: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
345: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
346: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
347: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
348: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
349: ,p_dei_information30 in varchar2 default hr_api.g_varchar2

Line 346: ,p_dei_information27 in varchar2 default hr_api.g_varchar2

342: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
343: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
344: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
345: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
346: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
347: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
348: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
349: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
350: ,p_request_id in number default hr_api.g_number

Line 347: ,p_dei_information28 in varchar2 default hr_api.g_varchar2

343: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
344: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
345: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
346: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
347: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
348: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
349: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
350: ,p_request_id in number default hr_api.g_number
351: ,p_program_application_id in number default hr_api.g_number

Line 348: ,p_dei_information29 in varchar2 default hr_api.g_varchar2

344: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
345: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
346: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
347: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
348: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
349: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
350: ,p_request_id in number default hr_api.g_number
351: ,p_program_application_id in number default hr_api.g_number
352: ,p_program_id in number default hr_api.g_number

Line 349: ,p_dei_information30 in varchar2 default hr_api.g_varchar2

345: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
346: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
347: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
348: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
349: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
350: ,p_request_id in number default hr_api.g_number
351: ,p_program_application_id in number default hr_api.g_number
352: ,p_program_id in number default hr_api.g_number
353: ,p_program_update_date in date default hr_api.g_date

Line 350: ,p_request_id in number default hr_api.g_number

346: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
347: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
348: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
349: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
350: ,p_request_id in number default hr_api.g_number
351: ,p_program_application_id in number default hr_api.g_number
352: ,p_program_id in number default hr_api.g_number
353: ,p_program_update_date in date default hr_api.g_date
354: ,p_object_version_number in out nocopy number

Line 351: ,p_program_application_id in number default hr_api.g_number

347: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
348: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
349: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
350: ,p_request_id in number default hr_api.g_number
351: ,p_program_application_id in number default hr_api.g_number
352: ,p_program_id in number default hr_api.g_number
353: ,p_program_update_date in date default hr_api.g_date
354: ,p_object_version_number in out nocopy number
355: ,p_return_status out nocopy varchar2

Line 352: ,p_program_id in number default hr_api.g_number

348: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
349: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
350: ,p_request_id in number default hr_api.g_number
351: ,p_program_application_id in number default hr_api.g_number
352: ,p_program_id in number default hr_api.g_number
353: ,p_program_update_date in date default hr_api.g_date
354: ,p_object_version_number in out nocopy number
355: ,p_return_status out nocopy varchar2
356: ) is

Line 353: ,p_program_update_date in date default hr_api.g_date

349: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
350: ,p_request_id in number default hr_api.g_number
351: ,p_program_application_id in number default hr_api.g_number
352: ,p_program_id in number default hr_api.g_number
353: ,p_program_update_date in date default hr_api.g_date
354: ,p_object_version_number in out nocopy number
355: ,p_return_status out nocopy varchar2
356: ) is
357: --

Line 385: hr_api.constant_to_boolean

381: --
382: -- Convert constant values to their corresponding boolean value
383: --
384: l_validate :=
385: hr_api.constant_to_boolean
386: (p_constant_value => p_validate);
387: --
388: -- Register Surrogate ID or user key values
389: --

Line 535: (p_validate in number default hr_api.g_false_num

531: -- ----------------------------------------------------------------------------
532: -- |-------------------------< delete_doc_extra_info >------------------------|
533: -- ----------------------------------------------------------------------------
534: PROCEDURE delete_doc_extra_info
535: (p_validate in number default hr_api.g_false_num
536: ,p_document_extra_info_id in number
537: ,p_object_version_number in number
538: ,p_return_status out nocopy varchar2
539: ) is

Line 565: hr_api.constant_to_boolean

561: --
562: -- Convert constant values to their corresponding boolean value
563: --
564: l_validate :=
565: hr_api.constant_to_boolean
566: (p_constant_value => p_validate);
567: --
568: -- Register Surrogate ID or user key values
569: --