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
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: --
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
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
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
275: ,p_document_type_id in number
276: ,p_date_from in date
277: ,p_date_to in 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
276: ,p_date_from in date
277: ,p_date_to in 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
277: ,p_date_to in 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
380: --
381: -- Convert constant values to their corresponding boolean value
382: --
383: l_validate :=
384: hr_api.constant_to_boolean
385: (p_constant_value => p_validate);
386: --
387: -- Register Surrogate ID or user key values
388: --
526: -- ----------------------------------------------------------------------------
527: -- |-------------------------< delete_doc_extra_info >------------------------|
528: -- ----------------------------------------------------------------------------
529: PROCEDURE delete_doc_extra_info
530: (p_validate in number default hr_api.g_false_num
531: ,p_document_extra_info_id in number
532: ,p_object_version_number in number
533: ,p_return_status out nocopy varchar2
534: ) is
556: --
557: -- Convert constant values to their corresponding boolean value
558: --
559: l_validate :=
560: hr_api.constant_to_boolean
561: (p_constant_value => p_validate);
562: --
563: -- Register Surrogate ID or user key values
564: --