8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_notification_prefs >-----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_notification_prefs
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_address_id in number default null
15: ,p_matching_jobs in varchar2 default null
16: ,p_matching_job_freq in varchar2 default null
79: --
80: -- Convert constant values to their corresponding boolean value
81: --
82: l_validate :=
83: hr_api.constant_to_boolean
84: (p_constant_value => p_validate);
85: --
86: -- Register Surrogate ID or user key values
87: --
188: -- ----------------------------------------------------------------------------
189: -- |-----------------------< delete_notification_prefs >-----------------------|
190: -- ----------------------------------------------------------------------------
191: PROCEDURE delete_notification_prefs
192: (p_validate in number default hr_api.g_false_num
193: ,p_notification_preference_id in number
194: ,p_object_version_number in number
195: ,p_return_status out nocopy varchar2
196: ) is
218: --
219: -- Convert constant values to their corresponding boolean value
220: --
221: l_validate :=
222: hr_api.constant_to_boolean
223: (p_constant_value => p_validate);
224: --
225: -- Register Surrogate ID or user key values
226: --
282: -- ----------------------------------------------------------------------------
283: -- |-----------------------< update_notification_prefs >-----------------------|
284: -- ----------------------------------------------------------------------------
285: PROCEDURE update_notification_prefs
286: (p_validate in number default hr_api.g_false_num
287: ,p_party_id in number default hr_api.g_number
288: ,p_effective_date in date
289: ,p_matching_jobs in varchar2 default hr_api.g_varchar2
290: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
283: -- |-----------------------< update_notification_prefs >-----------------------|
284: -- ----------------------------------------------------------------------------
285: PROCEDURE update_notification_prefs
286: (p_validate in number default hr_api.g_false_num
287: ,p_party_id in number default hr_api.g_number
288: ,p_effective_date in date
289: ,p_matching_jobs in varchar2 default hr_api.g_varchar2
290: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
291: ,p_allow_access in varchar2 default hr_api.g_varchar2
285: PROCEDURE update_notification_prefs
286: (p_validate in number default hr_api.g_false_num
287: ,p_party_id in number default hr_api.g_number
288: ,p_effective_date in date
289: ,p_matching_jobs in varchar2 default hr_api.g_varchar2
290: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
291: ,p_allow_access in varchar2 default hr_api.g_varchar2
292: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
293: ,p_address_id in number default hr_api.g_number
286: (p_validate in number default hr_api.g_false_num
287: ,p_party_id in number default hr_api.g_number
288: ,p_effective_date in date
289: ,p_matching_jobs in varchar2 default hr_api.g_varchar2
290: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
291: ,p_allow_access in varchar2 default hr_api.g_varchar2
292: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
293: ,p_address_id in number default hr_api.g_number
294: ,p_attribute_category in varchar2 default hr_api.g_varchar2
287: ,p_party_id in number default hr_api.g_number
288: ,p_effective_date in date
289: ,p_matching_jobs in varchar2 default hr_api.g_varchar2
290: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
291: ,p_allow_access in varchar2 default hr_api.g_varchar2
292: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
293: ,p_address_id in number default hr_api.g_number
294: ,p_attribute_category in varchar2 default hr_api.g_varchar2
295: ,p_attribute1 in varchar2 default hr_api.g_varchar2
288: ,p_effective_date in date
289: ,p_matching_jobs in varchar2 default hr_api.g_varchar2
290: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
291: ,p_allow_access in varchar2 default hr_api.g_varchar2
292: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
293: ,p_address_id in number default hr_api.g_number
294: ,p_attribute_category in varchar2 default hr_api.g_varchar2
295: ,p_attribute1 in varchar2 default hr_api.g_varchar2
296: ,p_attribute2 in varchar2 default hr_api.g_varchar2
289: ,p_matching_jobs in varchar2 default hr_api.g_varchar2
290: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
291: ,p_allow_access in varchar2 default hr_api.g_varchar2
292: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
293: ,p_address_id in number default hr_api.g_number
294: ,p_attribute_category in varchar2 default hr_api.g_varchar2
295: ,p_attribute1 in varchar2 default hr_api.g_varchar2
296: ,p_attribute2 in varchar2 default hr_api.g_varchar2
297: ,p_attribute3 in varchar2 default hr_api.g_varchar2
290: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
291: ,p_allow_access in varchar2 default hr_api.g_varchar2
292: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
293: ,p_address_id in number default hr_api.g_number
294: ,p_attribute_category in varchar2 default hr_api.g_varchar2
295: ,p_attribute1 in varchar2 default hr_api.g_varchar2
296: ,p_attribute2 in varchar2 default hr_api.g_varchar2
297: ,p_attribute3 in varchar2 default hr_api.g_varchar2
298: ,p_attribute4 in varchar2 default hr_api.g_varchar2
291: ,p_allow_access in varchar2 default hr_api.g_varchar2
292: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
293: ,p_address_id in number default hr_api.g_number
294: ,p_attribute_category in varchar2 default hr_api.g_varchar2
295: ,p_attribute1 in varchar2 default hr_api.g_varchar2
296: ,p_attribute2 in varchar2 default hr_api.g_varchar2
297: ,p_attribute3 in varchar2 default hr_api.g_varchar2
298: ,p_attribute4 in varchar2 default hr_api.g_varchar2
299: ,p_attribute5 in varchar2 default hr_api.g_varchar2
292: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
293: ,p_address_id in number default hr_api.g_number
294: ,p_attribute_category in varchar2 default hr_api.g_varchar2
295: ,p_attribute1 in varchar2 default hr_api.g_varchar2
296: ,p_attribute2 in varchar2 default hr_api.g_varchar2
297: ,p_attribute3 in varchar2 default hr_api.g_varchar2
298: ,p_attribute4 in varchar2 default hr_api.g_varchar2
299: ,p_attribute5 in varchar2 default hr_api.g_varchar2
300: ,p_attribute6 in varchar2 default hr_api.g_varchar2
293: ,p_address_id in number default hr_api.g_number
294: ,p_attribute_category in varchar2 default hr_api.g_varchar2
295: ,p_attribute1 in varchar2 default hr_api.g_varchar2
296: ,p_attribute2 in varchar2 default hr_api.g_varchar2
297: ,p_attribute3 in varchar2 default hr_api.g_varchar2
298: ,p_attribute4 in varchar2 default hr_api.g_varchar2
299: ,p_attribute5 in varchar2 default hr_api.g_varchar2
300: ,p_attribute6 in varchar2 default hr_api.g_varchar2
301: ,p_attribute7 in varchar2 default hr_api.g_varchar2
294: ,p_attribute_category in varchar2 default hr_api.g_varchar2
295: ,p_attribute1 in varchar2 default hr_api.g_varchar2
296: ,p_attribute2 in varchar2 default hr_api.g_varchar2
297: ,p_attribute3 in varchar2 default hr_api.g_varchar2
298: ,p_attribute4 in varchar2 default hr_api.g_varchar2
299: ,p_attribute5 in varchar2 default hr_api.g_varchar2
300: ,p_attribute6 in varchar2 default hr_api.g_varchar2
301: ,p_attribute7 in varchar2 default hr_api.g_varchar2
302: ,p_attribute8 in varchar2 default hr_api.g_varchar2
295: ,p_attribute1 in varchar2 default hr_api.g_varchar2
296: ,p_attribute2 in varchar2 default hr_api.g_varchar2
297: ,p_attribute3 in varchar2 default hr_api.g_varchar2
298: ,p_attribute4 in varchar2 default hr_api.g_varchar2
299: ,p_attribute5 in varchar2 default hr_api.g_varchar2
300: ,p_attribute6 in varchar2 default hr_api.g_varchar2
301: ,p_attribute7 in varchar2 default hr_api.g_varchar2
302: ,p_attribute8 in varchar2 default hr_api.g_varchar2
303: ,p_attribute9 in varchar2 default hr_api.g_varchar2
296: ,p_attribute2 in varchar2 default hr_api.g_varchar2
297: ,p_attribute3 in varchar2 default hr_api.g_varchar2
298: ,p_attribute4 in varchar2 default hr_api.g_varchar2
299: ,p_attribute5 in varchar2 default hr_api.g_varchar2
300: ,p_attribute6 in varchar2 default hr_api.g_varchar2
301: ,p_attribute7 in varchar2 default hr_api.g_varchar2
302: ,p_attribute8 in varchar2 default hr_api.g_varchar2
303: ,p_attribute9 in varchar2 default hr_api.g_varchar2
304: ,p_attribute10 in varchar2 default hr_api.g_varchar2
297: ,p_attribute3 in varchar2 default hr_api.g_varchar2
298: ,p_attribute4 in varchar2 default hr_api.g_varchar2
299: ,p_attribute5 in varchar2 default hr_api.g_varchar2
300: ,p_attribute6 in varchar2 default hr_api.g_varchar2
301: ,p_attribute7 in varchar2 default hr_api.g_varchar2
302: ,p_attribute8 in varchar2 default hr_api.g_varchar2
303: ,p_attribute9 in varchar2 default hr_api.g_varchar2
304: ,p_attribute10 in varchar2 default hr_api.g_varchar2
305: ,p_attribute11 in varchar2 default hr_api.g_varchar2
298: ,p_attribute4 in varchar2 default hr_api.g_varchar2
299: ,p_attribute5 in varchar2 default hr_api.g_varchar2
300: ,p_attribute6 in varchar2 default hr_api.g_varchar2
301: ,p_attribute7 in varchar2 default hr_api.g_varchar2
302: ,p_attribute8 in varchar2 default hr_api.g_varchar2
303: ,p_attribute9 in varchar2 default hr_api.g_varchar2
304: ,p_attribute10 in varchar2 default hr_api.g_varchar2
305: ,p_attribute11 in varchar2 default hr_api.g_varchar2
306: ,p_attribute12 in varchar2 default hr_api.g_varchar2
299: ,p_attribute5 in varchar2 default hr_api.g_varchar2
300: ,p_attribute6 in varchar2 default hr_api.g_varchar2
301: ,p_attribute7 in varchar2 default hr_api.g_varchar2
302: ,p_attribute8 in varchar2 default hr_api.g_varchar2
303: ,p_attribute9 in varchar2 default hr_api.g_varchar2
304: ,p_attribute10 in varchar2 default hr_api.g_varchar2
305: ,p_attribute11 in varchar2 default hr_api.g_varchar2
306: ,p_attribute12 in varchar2 default hr_api.g_varchar2
307: ,p_attribute13 in varchar2 default hr_api.g_varchar2
300: ,p_attribute6 in varchar2 default hr_api.g_varchar2
301: ,p_attribute7 in varchar2 default hr_api.g_varchar2
302: ,p_attribute8 in varchar2 default hr_api.g_varchar2
303: ,p_attribute9 in varchar2 default hr_api.g_varchar2
304: ,p_attribute10 in varchar2 default hr_api.g_varchar2
305: ,p_attribute11 in varchar2 default hr_api.g_varchar2
306: ,p_attribute12 in varchar2 default hr_api.g_varchar2
307: ,p_attribute13 in varchar2 default hr_api.g_varchar2
308: ,p_attribute14 in varchar2 default hr_api.g_varchar2
301: ,p_attribute7 in varchar2 default hr_api.g_varchar2
302: ,p_attribute8 in varchar2 default hr_api.g_varchar2
303: ,p_attribute9 in varchar2 default hr_api.g_varchar2
304: ,p_attribute10 in varchar2 default hr_api.g_varchar2
305: ,p_attribute11 in varchar2 default hr_api.g_varchar2
306: ,p_attribute12 in varchar2 default hr_api.g_varchar2
307: ,p_attribute13 in varchar2 default hr_api.g_varchar2
308: ,p_attribute14 in varchar2 default hr_api.g_varchar2
309: ,p_attribute15 in varchar2 default hr_api.g_varchar2
302: ,p_attribute8 in varchar2 default hr_api.g_varchar2
303: ,p_attribute9 in varchar2 default hr_api.g_varchar2
304: ,p_attribute10 in varchar2 default hr_api.g_varchar2
305: ,p_attribute11 in varchar2 default hr_api.g_varchar2
306: ,p_attribute12 in varchar2 default hr_api.g_varchar2
307: ,p_attribute13 in varchar2 default hr_api.g_varchar2
308: ,p_attribute14 in varchar2 default hr_api.g_varchar2
309: ,p_attribute15 in varchar2 default hr_api.g_varchar2
310: ,p_attribute16 in varchar2 default hr_api.g_varchar2
303: ,p_attribute9 in varchar2 default hr_api.g_varchar2
304: ,p_attribute10 in varchar2 default hr_api.g_varchar2
305: ,p_attribute11 in varchar2 default hr_api.g_varchar2
306: ,p_attribute12 in varchar2 default hr_api.g_varchar2
307: ,p_attribute13 in varchar2 default hr_api.g_varchar2
308: ,p_attribute14 in varchar2 default hr_api.g_varchar2
309: ,p_attribute15 in varchar2 default hr_api.g_varchar2
310: ,p_attribute16 in varchar2 default hr_api.g_varchar2
311: ,p_attribute17 in varchar2 default hr_api.g_varchar2
304: ,p_attribute10 in varchar2 default hr_api.g_varchar2
305: ,p_attribute11 in varchar2 default hr_api.g_varchar2
306: ,p_attribute12 in varchar2 default hr_api.g_varchar2
307: ,p_attribute13 in varchar2 default hr_api.g_varchar2
308: ,p_attribute14 in varchar2 default hr_api.g_varchar2
309: ,p_attribute15 in varchar2 default hr_api.g_varchar2
310: ,p_attribute16 in varchar2 default hr_api.g_varchar2
311: ,p_attribute17 in varchar2 default hr_api.g_varchar2
312: ,p_attribute18 in varchar2 default hr_api.g_varchar2
305: ,p_attribute11 in varchar2 default hr_api.g_varchar2
306: ,p_attribute12 in varchar2 default hr_api.g_varchar2
307: ,p_attribute13 in varchar2 default hr_api.g_varchar2
308: ,p_attribute14 in varchar2 default hr_api.g_varchar2
309: ,p_attribute15 in varchar2 default hr_api.g_varchar2
310: ,p_attribute16 in varchar2 default hr_api.g_varchar2
311: ,p_attribute17 in varchar2 default hr_api.g_varchar2
312: ,p_attribute18 in varchar2 default hr_api.g_varchar2
313: ,p_attribute19 in varchar2 default hr_api.g_varchar2
306: ,p_attribute12 in varchar2 default hr_api.g_varchar2
307: ,p_attribute13 in varchar2 default hr_api.g_varchar2
308: ,p_attribute14 in varchar2 default hr_api.g_varchar2
309: ,p_attribute15 in varchar2 default hr_api.g_varchar2
310: ,p_attribute16 in varchar2 default hr_api.g_varchar2
311: ,p_attribute17 in varchar2 default hr_api.g_varchar2
312: ,p_attribute18 in varchar2 default hr_api.g_varchar2
313: ,p_attribute19 in varchar2 default hr_api.g_varchar2
314: ,p_attribute20 in varchar2 default hr_api.g_varchar2
307: ,p_attribute13 in varchar2 default hr_api.g_varchar2
308: ,p_attribute14 in varchar2 default hr_api.g_varchar2
309: ,p_attribute15 in varchar2 default hr_api.g_varchar2
310: ,p_attribute16 in varchar2 default hr_api.g_varchar2
311: ,p_attribute17 in varchar2 default hr_api.g_varchar2
312: ,p_attribute18 in varchar2 default hr_api.g_varchar2
313: ,p_attribute19 in varchar2 default hr_api.g_varchar2
314: ,p_attribute20 in varchar2 default hr_api.g_varchar2
315: ,p_attribute21 in varchar2 default hr_api.g_varchar2
308: ,p_attribute14 in varchar2 default hr_api.g_varchar2
309: ,p_attribute15 in varchar2 default hr_api.g_varchar2
310: ,p_attribute16 in varchar2 default hr_api.g_varchar2
311: ,p_attribute17 in varchar2 default hr_api.g_varchar2
312: ,p_attribute18 in varchar2 default hr_api.g_varchar2
313: ,p_attribute19 in varchar2 default hr_api.g_varchar2
314: ,p_attribute20 in varchar2 default hr_api.g_varchar2
315: ,p_attribute21 in varchar2 default hr_api.g_varchar2
316: ,p_attribute22 in varchar2 default hr_api.g_varchar2
309: ,p_attribute15 in varchar2 default hr_api.g_varchar2
310: ,p_attribute16 in varchar2 default hr_api.g_varchar2
311: ,p_attribute17 in varchar2 default hr_api.g_varchar2
312: ,p_attribute18 in varchar2 default hr_api.g_varchar2
313: ,p_attribute19 in varchar2 default hr_api.g_varchar2
314: ,p_attribute20 in varchar2 default hr_api.g_varchar2
315: ,p_attribute21 in varchar2 default hr_api.g_varchar2
316: ,p_attribute22 in varchar2 default hr_api.g_varchar2
317: ,p_attribute23 in varchar2 default hr_api.g_varchar2
310: ,p_attribute16 in varchar2 default hr_api.g_varchar2
311: ,p_attribute17 in varchar2 default hr_api.g_varchar2
312: ,p_attribute18 in varchar2 default hr_api.g_varchar2
313: ,p_attribute19 in varchar2 default hr_api.g_varchar2
314: ,p_attribute20 in varchar2 default hr_api.g_varchar2
315: ,p_attribute21 in varchar2 default hr_api.g_varchar2
316: ,p_attribute22 in varchar2 default hr_api.g_varchar2
317: ,p_attribute23 in varchar2 default hr_api.g_varchar2
318: ,p_attribute24 in varchar2 default hr_api.g_varchar2
311: ,p_attribute17 in varchar2 default hr_api.g_varchar2
312: ,p_attribute18 in varchar2 default hr_api.g_varchar2
313: ,p_attribute19 in varchar2 default hr_api.g_varchar2
314: ,p_attribute20 in varchar2 default hr_api.g_varchar2
315: ,p_attribute21 in varchar2 default hr_api.g_varchar2
316: ,p_attribute22 in varchar2 default hr_api.g_varchar2
317: ,p_attribute23 in varchar2 default hr_api.g_varchar2
318: ,p_attribute24 in varchar2 default hr_api.g_varchar2
319: ,p_attribute25 in varchar2 default hr_api.g_varchar2
312: ,p_attribute18 in varchar2 default hr_api.g_varchar2
313: ,p_attribute19 in varchar2 default hr_api.g_varchar2
314: ,p_attribute20 in varchar2 default hr_api.g_varchar2
315: ,p_attribute21 in varchar2 default hr_api.g_varchar2
316: ,p_attribute22 in varchar2 default hr_api.g_varchar2
317: ,p_attribute23 in varchar2 default hr_api.g_varchar2
318: ,p_attribute24 in varchar2 default hr_api.g_varchar2
319: ,p_attribute25 in varchar2 default hr_api.g_varchar2
320: ,p_attribute26 in varchar2 default hr_api.g_varchar2
313: ,p_attribute19 in varchar2 default hr_api.g_varchar2
314: ,p_attribute20 in varchar2 default hr_api.g_varchar2
315: ,p_attribute21 in varchar2 default hr_api.g_varchar2
316: ,p_attribute22 in varchar2 default hr_api.g_varchar2
317: ,p_attribute23 in varchar2 default hr_api.g_varchar2
318: ,p_attribute24 in varchar2 default hr_api.g_varchar2
319: ,p_attribute25 in varchar2 default hr_api.g_varchar2
320: ,p_attribute26 in varchar2 default hr_api.g_varchar2
321: ,p_attribute27 in varchar2 default hr_api.g_varchar2
314: ,p_attribute20 in varchar2 default hr_api.g_varchar2
315: ,p_attribute21 in varchar2 default hr_api.g_varchar2
316: ,p_attribute22 in varchar2 default hr_api.g_varchar2
317: ,p_attribute23 in varchar2 default hr_api.g_varchar2
318: ,p_attribute24 in varchar2 default hr_api.g_varchar2
319: ,p_attribute25 in varchar2 default hr_api.g_varchar2
320: ,p_attribute26 in varchar2 default hr_api.g_varchar2
321: ,p_attribute27 in varchar2 default hr_api.g_varchar2
322: ,p_attribute28 in varchar2 default hr_api.g_varchar2
315: ,p_attribute21 in varchar2 default hr_api.g_varchar2
316: ,p_attribute22 in varchar2 default hr_api.g_varchar2
317: ,p_attribute23 in varchar2 default hr_api.g_varchar2
318: ,p_attribute24 in varchar2 default hr_api.g_varchar2
319: ,p_attribute25 in varchar2 default hr_api.g_varchar2
320: ,p_attribute26 in varchar2 default hr_api.g_varchar2
321: ,p_attribute27 in varchar2 default hr_api.g_varchar2
322: ,p_attribute28 in varchar2 default hr_api.g_varchar2
323: ,p_attribute29 in varchar2 default hr_api.g_varchar2
316: ,p_attribute22 in varchar2 default hr_api.g_varchar2
317: ,p_attribute23 in varchar2 default hr_api.g_varchar2
318: ,p_attribute24 in varchar2 default hr_api.g_varchar2
319: ,p_attribute25 in varchar2 default hr_api.g_varchar2
320: ,p_attribute26 in varchar2 default hr_api.g_varchar2
321: ,p_attribute27 in varchar2 default hr_api.g_varchar2
322: ,p_attribute28 in varchar2 default hr_api.g_varchar2
323: ,p_attribute29 in varchar2 default hr_api.g_varchar2
324: ,p_attribute30 in varchar2 default hr_api.g_varchar2
317: ,p_attribute23 in varchar2 default hr_api.g_varchar2
318: ,p_attribute24 in varchar2 default hr_api.g_varchar2
319: ,p_attribute25 in varchar2 default hr_api.g_varchar2
320: ,p_attribute26 in varchar2 default hr_api.g_varchar2
321: ,p_attribute27 in varchar2 default hr_api.g_varchar2
322: ,p_attribute28 in varchar2 default hr_api.g_varchar2
323: ,p_attribute29 in varchar2 default hr_api.g_varchar2
324: ,p_attribute30 in varchar2 default hr_api.g_varchar2
325: ,p_person_id in number default hr_api.g_number
318: ,p_attribute24 in varchar2 default hr_api.g_varchar2
319: ,p_attribute25 in varchar2 default hr_api.g_varchar2
320: ,p_attribute26 in varchar2 default hr_api.g_varchar2
321: ,p_attribute27 in varchar2 default hr_api.g_varchar2
322: ,p_attribute28 in varchar2 default hr_api.g_varchar2
323: ,p_attribute29 in varchar2 default hr_api.g_varchar2
324: ,p_attribute30 in varchar2 default hr_api.g_varchar2
325: ,p_person_id in number default hr_api.g_number
326: ,p_notification_preference_id in number
319: ,p_attribute25 in varchar2 default hr_api.g_varchar2
320: ,p_attribute26 in varchar2 default hr_api.g_varchar2
321: ,p_attribute27 in varchar2 default hr_api.g_varchar2
322: ,p_attribute28 in varchar2 default hr_api.g_varchar2
323: ,p_attribute29 in varchar2 default hr_api.g_varchar2
324: ,p_attribute30 in varchar2 default hr_api.g_varchar2
325: ,p_person_id in number default hr_api.g_number
326: ,p_notification_preference_id in number
327: ,p_agency_id in number default hr_api.g_number
320: ,p_attribute26 in varchar2 default hr_api.g_varchar2
321: ,p_attribute27 in varchar2 default hr_api.g_varchar2
322: ,p_attribute28 in varchar2 default hr_api.g_varchar2
323: ,p_attribute29 in varchar2 default hr_api.g_varchar2
324: ,p_attribute30 in varchar2 default hr_api.g_varchar2
325: ,p_person_id in number default hr_api.g_number
326: ,p_notification_preference_id in number
327: ,p_agency_id in number default hr_api.g_number
328: ,p_attempt_id in number default hr_api.g_number
321: ,p_attribute27 in varchar2 default hr_api.g_varchar2
322: ,p_attribute28 in varchar2 default hr_api.g_varchar2
323: ,p_attribute29 in varchar2 default hr_api.g_varchar2
324: ,p_attribute30 in varchar2 default hr_api.g_varchar2
325: ,p_person_id in number default hr_api.g_number
326: ,p_notification_preference_id in number
327: ,p_agency_id in number default hr_api.g_number
328: ,p_attempt_id in number default hr_api.g_number
329: ,p_object_version_number in out nocopy number
323: ,p_attribute29 in varchar2 default hr_api.g_varchar2
324: ,p_attribute30 in varchar2 default hr_api.g_varchar2
325: ,p_person_id in number default hr_api.g_number
326: ,p_notification_preference_id in number
327: ,p_agency_id in number default hr_api.g_number
328: ,p_attempt_id in number default hr_api.g_number
329: ,p_object_version_number in out nocopy number
330: ,p_return_status out nocopy varchar2
331: ) is
324: ,p_attribute30 in varchar2 default hr_api.g_varchar2
325: ,p_person_id in number default hr_api.g_number
326: ,p_notification_preference_id in number
327: ,p_agency_id in number default hr_api.g_number
328: ,p_attempt_id in number default hr_api.g_number
329: ,p_object_version_number in out nocopy number
330: ,p_return_status out nocopy varchar2
331: ) is
332: --
355: --
356: -- Convert constant values to their corresponding boolean value
357: --
358: l_validate :=
359: hr_api.constant_to_boolean
360: (p_constant_value => p_validate);
361: --
362: -- Register Surrogate ID or user key values
363: --