[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy irc_ipd_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: irc_ipd_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: irc_ipd_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: irc_ipd_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: --
147: Raise;
179: --
180: -- {End Of Comments}
181: -- ----------------------------------------------------------------------------
182: Procedure pre_update
183: (p_rec in irc_ipd_shd.g_rec_type
184: ) is
185: --
186: l_proc varchar2(72) := g_package||'pre_update';
187: --
223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure post_update
227: (p_rec in irc_ipd_shd.g_rec_type
228: ) is
229: --
230: l_proc varchar2(72) := g_package||'post_update';
231: --
338: => p_rec.visitor_resp_appl_id
339: ,p_security_group_key
340: => p_rec.security_group_key
341: ,p_email_address_o
342: => irc_ipd_shd.g_old_rec.email_address
343: ,p_vacancy_id_o
344: => irc_ipd_shd.g_old_rec.vacancy_id
345: ,p_last_name_o
346: => irc_ipd_shd.g_old_rec.last_name
340: => p_rec.security_group_key
341: ,p_email_address_o
342: => irc_ipd_shd.g_old_rec.email_address
343: ,p_vacancy_id_o
344: => irc_ipd_shd.g_old_rec.vacancy_id
345: ,p_last_name_o
346: => irc_ipd_shd.g_old_rec.last_name
347: ,p_first_name_o
348: => irc_ipd_shd.g_old_rec.first_name
342: => irc_ipd_shd.g_old_rec.email_address
343: ,p_vacancy_id_o
344: => irc_ipd_shd.g_old_rec.vacancy_id
345: ,p_last_name_o
346: => irc_ipd_shd.g_old_rec.last_name
347: ,p_first_name_o
348: => irc_ipd_shd.g_old_rec.first_name
349: ,p_user_password_o
350: => irc_ipd_shd.g_old_rec.user_password
344: => irc_ipd_shd.g_old_rec.vacancy_id
345: ,p_last_name_o
346: => irc_ipd_shd.g_old_rec.last_name
347: ,p_first_name_o
348: => irc_ipd_shd.g_old_rec.first_name
349: ,p_user_password_o
350: => irc_ipd_shd.g_old_rec.user_password
351: ,p_resume_file_name_o
352: => irc_ipd_shd.g_old_rec.resume_file_name
346: => irc_ipd_shd.g_old_rec.last_name
347: ,p_first_name_o
348: => irc_ipd_shd.g_old_rec.first_name
349: ,p_user_password_o
350: => irc_ipd_shd.g_old_rec.user_password
351: ,p_resume_file_name_o
352: => irc_ipd_shd.g_old_rec.resume_file_name
353: ,p_resume_description_o
354: => irc_ipd_shd.g_old_rec.resume_description
348: => irc_ipd_shd.g_old_rec.first_name
349: ,p_user_password_o
350: => irc_ipd_shd.g_old_rec.user_password
351: ,p_resume_file_name_o
352: => irc_ipd_shd.g_old_rec.resume_file_name
353: ,p_resume_description_o
354: => irc_ipd_shd.g_old_rec.resume_description
355: ,p_resume_mime_type_o
356: => irc_ipd_shd.g_old_rec.resume_mime_type
350: => irc_ipd_shd.g_old_rec.user_password
351: ,p_resume_file_name_o
352: => irc_ipd_shd.g_old_rec.resume_file_name
353: ,p_resume_description_o
354: => irc_ipd_shd.g_old_rec.resume_description
355: ,p_resume_mime_type_o
356: => irc_ipd_shd.g_old_rec.resume_mime_type
357: ,p_source_type_o
358: => irc_ipd_shd.g_old_rec.source_type
352: => irc_ipd_shd.g_old_rec.resume_file_name
353: ,p_resume_description_o
354: => irc_ipd_shd.g_old_rec.resume_description
355: ,p_resume_mime_type_o
356: => irc_ipd_shd.g_old_rec.resume_mime_type
357: ,p_source_type_o
358: => irc_ipd_shd.g_old_rec.source_type
359: ,p_job_post_source_name_o
360: => irc_ipd_shd.g_old_rec.job_post_source_name
354: => irc_ipd_shd.g_old_rec.resume_description
355: ,p_resume_mime_type_o
356: => irc_ipd_shd.g_old_rec.resume_mime_type
357: ,p_source_type_o
358: => irc_ipd_shd.g_old_rec.source_type
359: ,p_job_post_source_name_o
360: => irc_ipd_shd.g_old_rec.job_post_source_name
361: ,p_posting_content_id_o
362: => irc_ipd_shd.g_old_rec.posting_content_id
356: => irc_ipd_shd.g_old_rec.resume_mime_type
357: ,p_source_type_o
358: => irc_ipd_shd.g_old_rec.source_type
359: ,p_job_post_source_name_o
360: => irc_ipd_shd.g_old_rec.job_post_source_name
361: ,p_posting_content_id_o
362: => irc_ipd_shd.g_old_rec.posting_content_id
363: ,p_person_id_o
364: => irc_ipd_shd.g_old_rec.person_id
358: => irc_ipd_shd.g_old_rec.source_type
359: ,p_job_post_source_name_o
360: => irc_ipd_shd.g_old_rec.job_post_source_name
361: ,p_posting_content_id_o
362: => irc_ipd_shd.g_old_rec.posting_content_id
363: ,p_person_id_o
364: => irc_ipd_shd.g_old_rec.person_id
365: ,p_processed_o
366: => irc_ipd_shd.g_old_rec.processed
360: => irc_ipd_shd.g_old_rec.job_post_source_name
361: ,p_posting_content_id_o
362: => irc_ipd_shd.g_old_rec.posting_content_id
363: ,p_person_id_o
364: => irc_ipd_shd.g_old_rec.person_id
365: ,p_processed_o
366: => irc_ipd_shd.g_old_rec.processed
367: ,p_sex_o
368: => irc_ipd_shd.g_old_rec.sex
362: => irc_ipd_shd.g_old_rec.posting_content_id
363: ,p_person_id_o
364: => irc_ipd_shd.g_old_rec.person_id
365: ,p_processed_o
366: => irc_ipd_shd.g_old_rec.processed
367: ,p_sex_o
368: => irc_ipd_shd.g_old_rec.sex
369: ,p_date_of_birth_o
370: => irc_ipd_shd.g_old_rec.date_of_birth
364: => irc_ipd_shd.g_old_rec.person_id
365: ,p_processed_o
366: => irc_ipd_shd.g_old_rec.processed
367: ,p_sex_o
368: => irc_ipd_shd.g_old_rec.sex
369: ,p_date_of_birth_o
370: => irc_ipd_shd.g_old_rec.date_of_birth
371: ,p_per_information_category_o
372: => irc_ipd_shd.g_old_rec.per_information_category
366: => irc_ipd_shd.g_old_rec.processed
367: ,p_sex_o
368: => irc_ipd_shd.g_old_rec.sex
369: ,p_date_of_birth_o
370: => irc_ipd_shd.g_old_rec.date_of_birth
371: ,p_per_information_category_o
372: => irc_ipd_shd.g_old_rec.per_information_category
373: ,p_per_information1_o
374: => irc_ipd_shd.g_old_rec.per_information1
368: => irc_ipd_shd.g_old_rec.sex
369: ,p_date_of_birth_o
370: => irc_ipd_shd.g_old_rec.date_of_birth
371: ,p_per_information_category_o
372: => irc_ipd_shd.g_old_rec.per_information_category
373: ,p_per_information1_o
374: => irc_ipd_shd.g_old_rec.per_information1
375: ,p_per_information2_o
376: => irc_ipd_shd.g_old_rec.per_information2
370: => irc_ipd_shd.g_old_rec.date_of_birth
371: ,p_per_information_category_o
372: => irc_ipd_shd.g_old_rec.per_information_category
373: ,p_per_information1_o
374: => irc_ipd_shd.g_old_rec.per_information1
375: ,p_per_information2_o
376: => irc_ipd_shd.g_old_rec.per_information2
377: ,p_per_information3_o
378: => irc_ipd_shd.g_old_rec.per_information3
372: => irc_ipd_shd.g_old_rec.per_information_category
373: ,p_per_information1_o
374: => irc_ipd_shd.g_old_rec.per_information1
375: ,p_per_information2_o
376: => irc_ipd_shd.g_old_rec.per_information2
377: ,p_per_information3_o
378: => irc_ipd_shd.g_old_rec.per_information3
379: ,p_per_information4_o
380: => irc_ipd_shd.g_old_rec.per_information4
374: => irc_ipd_shd.g_old_rec.per_information1
375: ,p_per_information2_o
376: => irc_ipd_shd.g_old_rec.per_information2
377: ,p_per_information3_o
378: => irc_ipd_shd.g_old_rec.per_information3
379: ,p_per_information4_o
380: => irc_ipd_shd.g_old_rec.per_information4
381: ,p_per_information5_o
382: => irc_ipd_shd.g_old_rec.per_information5
376: => irc_ipd_shd.g_old_rec.per_information2
377: ,p_per_information3_o
378: => irc_ipd_shd.g_old_rec.per_information3
379: ,p_per_information4_o
380: => irc_ipd_shd.g_old_rec.per_information4
381: ,p_per_information5_o
382: => irc_ipd_shd.g_old_rec.per_information5
383: ,p_per_information6_o
384: => irc_ipd_shd.g_old_rec.per_information6
378: => irc_ipd_shd.g_old_rec.per_information3
379: ,p_per_information4_o
380: => irc_ipd_shd.g_old_rec.per_information4
381: ,p_per_information5_o
382: => irc_ipd_shd.g_old_rec.per_information5
383: ,p_per_information6_o
384: => irc_ipd_shd.g_old_rec.per_information6
385: ,p_per_information7_o
386: => irc_ipd_shd.g_old_rec.per_information7
380: => irc_ipd_shd.g_old_rec.per_information4
381: ,p_per_information5_o
382: => irc_ipd_shd.g_old_rec.per_information5
383: ,p_per_information6_o
384: => irc_ipd_shd.g_old_rec.per_information6
385: ,p_per_information7_o
386: => irc_ipd_shd.g_old_rec.per_information7
387: ,p_per_information8_o
388: => irc_ipd_shd.g_old_rec.per_information8
382: => irc_ipd_shd.g_old_rec.per_information5
383: ,p_per_information6_o
384: => irc_ipd_shd.g_old_rec.per_information6
385: ,p_per_information7_o
386: => irc_ipd_shd.g_old_rec.per_information7
387: ,p_per_information8_o
388: => irc_ipd_shd.g_old_rec.per_information8
389: ,p_per_information9_o
390: => irc_ipd_shd.g_old_rec.per_information9
384: => irc_ipd_shd.g_old_rec.per_information6
385: ,p_per_information7_o
386: => irc_ipd_shd.g_old_rec.per_information7
387: ,p_per_information8_o
388: => irc_ipd_shd.g_old_rec.per_information8
389: ,p_per_information9_o
390: => irc_ipd_shd.g_old_rec.per_information9
391: ,p_per_information10_o
392: => irc_ipd_shd.g_old_rec.per_information10
386: => irc_ipd_shd.g_old_rec.per_information7
387: ,p_per_information8_o
388: => irc_ipd_shd.g_old_rec.per_information8
389: ,p_per_information9_o
390: => irc_ipd_shd.g_old_rec.per_information9
391: ,p_per_information10_o
392: => irc_ipd_shd.g_old_rec.per_information10
393: ,p_per_information11_o
394: => irc_ipd_shd.g_old_rec.per_information11
388: => irc_ipd_shd.g_old_rec.per_information8
389: ,p_per_information9_o
390: => irc_ipd_shd.g_old_rec.per_information9
391: ,p_per_information10_o
392: => irc_ipd_shd.g_old_rec.per_information10
393: ,p_per_information11_o
394: => irc_ipd_shd.g_old_rec.per_information11
395: ,p_per_information12_o
396: => irc_ipd_shd.g_old_rec.per_information12
390: => irc_ipd_shd.g_old_rec.per_information9
391: ,p_per_information10_o
392: => irc_ipd_shd.g_old_rec.per_information10
393: ,p_per_information11_o
394: => irc_ipd_shd.g_old_rec.per_information11
395: ,p_per_information12_o
396: => irc_ipd_shd.g_old_rec.per_information12
397: ,p_per_information13_o
398: => irc_ipd_shd.g_old_rec.per_information13
392: => irc_ipd_shd.g_old_rec.per_information10
393: ,p_per_information11_o
394: => irc_ipd_shd.g_old_rec.per_information11
395: ,p_per_information12_o
396: => irc_ipd_shd.g_old_rec.per_information12
397: ,p_per_information13_o
398: => irc_ipd_shd.g_old_rec.per_information13
399: ,p_per_information14_o
400: => irc_ipd_shd.g_old_rec.per_information14
394: => irc_ipd_shd.g_old_rec.per_information11
395: ,p_per_information12_o
396: => irc_ipd_shd.g_old_rec.per_information12
397: ,p_per_information13_o
398: => irc_ipd_shd.g_old_rec.per_information13
399: ,p_per_information14_o
400: => irc_ipd_shd.g_old_rec.per_information14
401: ,p_per_information15_o
402: => irc_ipd_shd.g_old_rec.per_information15
396: => irc_ipd_shd.g_old_rec.per_information12
397: ,p_per_information13_o
398: => irc_ipd_shd.g_old_rec.per_information13
399: ,p_per_information14_o
400: => irc_ipd_shd.g_old_rec.per_information14
401: ,p_per_information15_o
402: => irc_ipd_shd.g_old_rec.per_information15
403: ,p_per_information16_o
404: => irc_ipd_shd.g_old_rec.per_information16
398: => irc_ipd_shd.g_old_rec.per_information13
399: ,p_per_information14_o
400: => irc_ipd_shd.g_old_rec.per_information14
401: ,p_per_information15_o
402: => irc_ipd_shd.g_old_rec.per_information15
403: ,p_per_information16_o
404: => irc_ipd_shd.g_old_rec.per_information16
405: ,p_per_information17_o
406: => irc_ipd_shd.g_old_rec.per_information17
400: => irc_ipd_shd.g_old_rec.per_information14
401: ,p_per_information15_o
402: => irc_ipd_shd.g_old_rec.per_information15
403: ,p_per_information16_o
404: => irc_ipd_shd.g_old_rec.per_information16
405: ,p_per_information17_o
406: => irc_ipd_shd.g_old_rec.per_information17
407: ,p_per_information18_o
408: => irc_ipd_shd.g_old_rec.per_information18
402: => irc_ipd_shd.g_old_rec.per_information15
403: ,p_per_information16_o
404: => irc_ipd_shd.g_old_rec.per_information16
405: ,p_per_information17_o
406: => irc_ipd_shd.g_old_rec.per_information17
407: ,p_per_information18_o
408: => irc_ipd_shd.g_old_rec.per_information18
409: ,p_per_information19_o
410: => irc_ipd_shd.g_old_rec.per_information19
404: => irc_ipd_shd.g_old_rec.per_information16
405: ,p_per_information17_o
406: => irc_ipd_shd.g_old_rec.per_information17
407: ,p_per_information18_o
408: => irc_ipd_shd.g_old_rec.per_information18
409: ,p_per_information19_o
410: => irc_ipd_shd.g_old_rec.per_information19
411: ,p_per_information20_o
412: => irc_ipd_shd.g_old_rec.per_information20
406: => irc_ipd_shd.g_old_rec.per_information17
407: ,p_per_information18_o
408: => irc_ipd_shd.g_old_rec.per_information18
409: ,p_per_information19_o
410: => irc_ipd_shd.g_old_rec.per_information19
411: ,p_per_information20_o
412: => irc_ipd_shd.g_old_rec.per_information20
413: ,p_per_information21_o
414: => irc_ipd_shd.g_old_rec.per_information21
408: => irc_ipd_shd.g_old_rec.per_information18
409: ,p_per_information19_o
410: => irc_ipd_shd.g_old_rec.per_information19
411: ,p_per_information20_o
412: => irc_ipd_shd.g_old_rec.per_information20
413: ,p_per_information21_o
414: => irc_ipd_shd.g_old_rec.per_information21
415: ,p_per_information22_o
416: => irc_ipd_shd.g_old_rec.per_information22
410: => irc_ipd_shd.g_old_rec.per_information19
411: ,p_per_information20_o
412: => irc_ipd_shd.g_old_rec.per_information20
413: ,p_per_information21_o
414: => irc_ipd_shd.g_old_rec.per_information21
415: ,p_per_information22_o
416: => irc_ipd_shd.g_old_rec.per_information22
417: ,p_per_information23_o
418: => irc_ipd_shd.g_old_rec.per_information23
412: => irc_ipd_shd.g_old_rec.per_information20
413: ,p_per_information21_o
414: => irc_ipd_shd.g_old_rec.per_information21
415: ,p_per_information22_o
416: => irc_ipd_shd.g_old_rec.per_information22
417: ,p_per_information23_o
418: => irc_ipd_shd.g_old_rec.per_information23
419: ,p_per_information24_o
420: => irc_ipd_shd.g_old_rec.per_information24
414: => irc_ipd_shd.g_old_rec.per_information21
415: ,p_per_information22_o
416: => irc_ipd_shd.g_old_rec.per_information22
417: ,p_per_information23_o
418: => irc_ipd_shd.g_old_rec.per_information23
419: ,p_per_information24_o
420: => irc_ipd_shd.g_old_rec.per_information24
421: ,p_per_information25_o
422: => irc_ipd_shd.g_old_rec.per_information25
416: => irc_ipd_shd.g_old_rec.per_information22
417: ,p_per_information23_o
418: => irc_ipd_shd.g_old_rec.per_information23
419: ,p_per_information24_o
420: => irc_ipd_shd.g_old_rec.per_information24
421: ,p_per_information25_o
422: => irc_ipd_shd.g_old_rec.per_information25
423: ,p_per_information26_o
424: => irc_ipd_shd.g_old_rec.per_information26
418: => irc_ipd_shd.g_old_rec.per_information23
419: ,p_per_information24_o
420: => irc_ipd_shd.g_old_rec.per_information24
421: ,p_per_information25_o
422: => irc_ipd_shd.g_old_rec.per_information25
423: ,p_per_information26_o
424: => irc_ipd_shd.g_old_rec.per_information26
425: ,p_per_information27_o
426: => irc_ipd_shd.g_old_rec.per_information27
420: => irc_ipd_shd.g_old_rec.per_information24
421: ,p_per_information25_o
422: => irc_ipd_shd.g_old_rec.per_information25
423: ,p_per_information26_o
424: => irc_ipd_shd.g_old_rec.per_information26
425: ,p_per_information27_o
426: => irc_ipd_shd.g_old_rec.per_information27
427: ,p_per_information28_o
428: => irc_ipd_shd.g_old_rec.per_information28
422: => irc_ipd_shd.g_old_rec.per_information25
423: ,p_per_information26_o
424: => irc_ipd_shd.g_old_rec.per_information26
425: ,p_per_information27_o
426: => irc_ipd_shd.g_old_rec.per_information27
427: ,p_per_information28_o
428: => irc_ipd_shd.g_old_rec.per_information28
429: ,p_per_information29_o
430: => irc_ipd_shd.g_old_rec.per_information29
424: => irc_ipd_shd.g_old_rec.per_information26
425: ,p_per_information27_o
426: => irc_ipd_shd.g_old_rec.per_information27
427: ,p_per_information28_o
428: => irc_ipd_shd.g_old_rec.per_information28
429: ,p_per_information29_o
430: => irc_ipd_shd.g_old_rec.per_information29
431: ,p_per_information30_o
432: => irc_ipd_shd.g_old_rec.per_information30
426: => irc_ipd_shd.g_old_rec.per_information27
427: ,p_per_information28_o
428: => irc_ipd_shd.g_old_rec.per_information28
429: ,p_per_information29_o
430: => irc_ipd_shd.g_old_rec.per_information29
431: ,p_per_information30_o
432: => irc_ipd_shd.g_old_rec.per_information30
433: ,p_error_message_o
434: => irc_ipd_shd.g_old_rec.error_message
428: => irc_ipd_shd.g_old_rec.per_information28
429: ,p_per_information29_o
430: => irc_ipd_shd.g_old_rec.per_information29
431: ,p_per_information30_o
432: => irc_ipd_shd.g_old_rec.per_information30
433: ,p_error_message_o
434: => irc_ipd_shd.g_old_rec.error_message
435: ,p_creation_date_o
436: => irc_ipd_shd.g_old_rec.creation_date
430: => irc_ipd_shd.g_old_rec.per_information29
431: ,p_per_information30_o
432: => irc_ipd_shd.g_old_rec.per_information30
433: ,p_error_message_o
434: => irc_ipd_shd.g_old_rec.error_message
435: ,p_creation_date_o
436: => irc_ipd_shd.g_old_rec.creation_date
437: ,p_last_update_date_o
438: => irc_ipd_shd.g_old_rec.last_update_date
432: => irc_ipd_shd.g_old_rec.per_information30
433: ,p_error_message_o
434: => irc_ipd_shd.g_old_rec.error_message
435: ,p_creation_date_o
436: => irc_ipd_shd.g_old_rec.creation_date
437: ,p_last_update_date_o
438: => irc_ipd_shd.g_old_rec.last_update_date
439: ,p_allow_access_o
440: => irc_ipd_shd.g_old_rec.allow_access
434: => irc_ipd_shd.g_old_rec.error_message
435: ,p_creation_date_o
436: => irc_ipd_shd.g_old_rec.creation_date
437: ,p_last_update_date_o
438: => irc_ipd_shd.g_old_rec.last_update_date
439: ,p_allow_access_o
440: => irc_ipd_shd.g_old_rec.allow_access
441: ,p_visitor_resp_key_o
442: => irc_ipd_shd.g_old_rec.visitor_resp_key
436: => irc_ipd_shd.g_old_rec.creation_date
437: ,p_last_update_date_o
438: => irc_ipd_shd.g_old_rec.last_update_date
439: ,p_allow_access_o
440: => irc_ipd_shd.g_old_rec.allow_access
441: ,p_visitor_resp_key_o
442: => irc_ipd_shd.g_old_rec.visitor_resp_key
443: ,p_visitor_resp_appl_id_o
444: => irc_ipd_shd.g_old_rec.visitor_resp_appl_id
438: => irc_ipd_shd.g_old_rec.last_update_date
439: ,p_allow_access_o
440: => irc_ipd_shd.g_old_rec.allow_access
441: ,p_visitor_resp_key_o
442: => irc_ipd_shd.g_old_rec.visitor_resp_key
443: ,p_visitor_resp_appl_id_o
444: => irc_ipd_shd.g_old_rec.visitor_resp_appl_id
445: ,p_security_group_key_o
446: => irc_ipd_shd.g_old_rec.security_group_key
440: => irc_ipd_shd.g_old_rec.allow_access
441: ,p_visitor_resp_key_o
442: => irc_ipd_shd.g_old_rec.visitor_resp_key
443: ,p_visitor_resp_appl_id_o
444: => irc_ipd_shd.g_old_rec.visitor_resp_appl_id
445: ,p_security_group_key_o
446: => irc_ipd_shd.g_old_rec.security_group_key
447: );
448: --
442: => irc_ipd_shd.g_old_rec.visitor_resp_key
443: ,p_visitor_resp_appl_id_o
444: => irc_ipd_shd.g_old_rec.visitor_resp_appl_id
445: ,p_security_group_key_o
446: => irc_ipd_shd.g_old_rec.security_group_key
447: );
448: --
449: exception
450: --
502: --
503: -- {End Of Comments}
504: -- ----------------------------------------------------------------------------
505: Procedure convert_defs
506: (p_rec in out nocopy irc_ipd_shd.g_rec_type
507: ) is
508: --
509: Begin
510: --
514: -- is being used then we must set to the 'current' argument value.
515: --
516: If (p_rec.email_address = hr_api.g_varchar2) then
517: p_rec.email_address :=
518: irc_ipd_shd.g_old_rec.email_address;
519: End If;
520: If (p_rec.vacancy_id = hr_api.g_number) then
521: p_rec.vacancy_id :=
522: irc_ipd_shd.g_old_rec.vacancy_id;
518: irc_ipd_shd.g_old_rec.email_address;
519: End If;
520: If (p_rec.vacancy_id = hr_api.g_number) then
521: p_rec.vacancy_id :=
522: irc_ipd_shd.g_old_rec.vacancy_id;
523: End If;
524: If (p_rec.last_name = hr_api.g_varchar2) then
525: p_rec.last_name :=
526: irc_ipd_shd.g_old_rec.last_name;
522: irc_ipd_shd.g_old_rec.vacancy_id;
523: End If;
524: If (p_rec.last_name = hr_api.g_varchar2) then
525: p_rec.last_name :=
526: irc_ipd_shd.g_old_rec.last_name;
527: End If;
528: If (p_rec.first_name = hr_api.g_varchar2) then
529: p_rec.first_name :=
530: irc_ipd_shd.g_old_rec.first_name;
526: irc_ipd_shd.g_old_rec.last_name;
527: End If;
528: If (p_rec.first_name = hr_api.g_varchar2) then
529: p_rec.first_name :=
530: irc_ipd_shd.g_old_rec.first_name;
531: End If;
532: If (p_rec.user_password = hr_api.g_varchar2) then
533: p_rec.user_password :=
534: irc_ipd_shd.g_old_rec.user_password;
530: irc_ipd_shd.g_old_rec.first_name;
531: End If;
532: If (p_rec.user_password = hr_api.g_varchar2) then
533: p_rec.user_password :=
534: irc_ipd_shd.g_old_rec.user_password;
535: End If;
536: If (p_rec.resume_file_name = hr_api.g_varchar2) then
537: p_rec.resume_file_name :=
538: irc_ipd_shd.g_old_rec.resume_file_name;
534: irc_ipd_shd.g_old_rec.user_password;
535: End If;
536: If (p_rec.resume_file_name = hr_api.g_varchar2) then
537: p_rec.resume_file_name :=
538: irc_ipd_shd.g_old_rec.resume_file_name;
539: End If;
540: If (p_rec.resume_description = hr_api.g_varchar2) then
541: p_rec.resume_description :=
542: irc_ipd_shd.g_old_rec.resume_description;
538: irc_ipd_shd.g_old_rec.resume_file_name;
539: End If;
540: If (p_rec.resume_description = hr_api.g_varchar2) then
541: p_rec.resume_description :=
542: irc_ipd_shd.g_old_rec.resume_description;
543: End If;
544: If (p_rec.resume_mime_type = hr_api.g_varchar2) then
545: p_rec.resume_mime_type :=
546: irc_ipd_shd.g_old_rec.resume_mime_type;
542: irc_ipd_shd.g_old_rec.resume_description;
543: End If;
544: If (p_rec.resume_mime_type = hr_api.g_varchar2) then
545: p_rec.resume_mime_type :=
546: irc_ipd_shd.g_old_rec.resume_mime_type;
547: End If;
548: If (p_rec.source_type = hr_api.g_varchar2) then
549: p_rec.source_type :=
550: irc_ipd_shd.g_old_rec.source_type;
546: irc_ipd_shd.g_old_rec.resume_mime_type;
547: End If;
548: If (p_rec.source_type = hr_api.g_varchar2) then
549: p_rec.source_type :=
550: irc_ipd_shd.g_old_rec.source_type;
551: End If;
552: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
553: p_rec.job_post_source_name :=
554: irc_ipd_shd.g_old_rec.job_post_source_name;
550: irc_ipd_shd.g_old_rec.source_type;
551: End If;
552: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
553: p_rec.job_post_source_name :=
554: irc_ipd_shd.g_old_rec.job_post_source_name;
555: End If;
556: If (p_rec.posting_content_id = hr_api.g_number) then
557: p_rec.posting_content_id :=
558: irc_ipd_shd.g_old_rec.posting_content_id;
554: irc_ipd_shd.g_old_rec.job_post_source_name;
555: End If;
556: If (p_rec.posting_content_id = hr_api.g_number) then
557: p_rec.posting_content_id :=
558: irc_ipd_shd.g_old_rec.posting_content_id;
559: End If;
560: If (p_rec.person_id = hr_api.g_number) then
561: p_rec.person_id :=
562: irc_ipd_shd.g_old_rec.person_id;
558: irc_ipd_shd.g_old_rec.posting_content_id;
559: End If;
560: If (p_rec.person_id = hr_api.g_number) then
561: p_rec.person_id :=
562: irc_ipd_shd.g_old_rec.person_id;
563: End If;
564: If (p_rec.processed = hr_api.g_varchar2) then
565: p_rec.processed :=
566: irc_ipd_shd.g_old_rec.processed;
562: irc_ipd_shd.g_old_rec.person_id;
563: End If;
564: If (p_rec.processed = hr_api.g_varchar2) then
565: p_rec.processed :=
566: irc_ipd_shd.g_old_rec.processed;
567: End If;
568: If (p_rec.sex = hr_api.g_varchar2) then
569: p_rec.sex :=
570: irc_ipd_shd.g_old_rec.sex;
566: irc_ipd_shd.g_old_rec.processed;
567: End If;
568: If (p_rec.sex = hr_api.g_varchar2) then
569: p_rec.sex :=
570: irc_ipd_shd.g_old_rec.sex;
571: End If;
572: If (p_rec.date_of_birth = hr_api.g_date) then
573: p_rec.date_of_birth :=
574: irc_ipd_shd.g_old_rec.date_of_birth;
570: irc_ipd_shd.g_old_rec.sex;
571: End If;
572: If (p_rec.date_of_birth = hr_api.g_date) then
573: p_rec.date_of_birth :=
574: irc_ipd_shd.g_old_rec.date_of_birth;
575: End If;
576: If (p_rec.per_information_category = hr_api.g_varchar2) then
577: p_rec.per_information_category :=
578: irc_ipd_shd.g_old_rec.per_information_category;
574: irc_ipd_shd.g_old_rec.date_of_birth;
575: End If;
576: If (p_rec.per_information_category = hr_api.g_varchar2) then
577: p_rec.per_information_category :=
578: irc_ipd_shd.g_old_rec.per_information_category;
579: End If;
580: If (p_rec.per_information1 = hr_api.g_varchar2) then
581: p_rec.per_information1 :=
582: irc_ipd_shd.g_old_rec.per_information1;
578: irc_ipd_shd.g_old_rec.per_information_category;
579: End If;
580: If (p_rec.per_information1 = hr_api.g_varchar2) then
581: p_rec.per_information1 :=
582: irc_ipd_shd.g_old_rec.per_information1;
583: End If;
584: If (p_rec.per_information2 = hr_api.g_varchar2) then
585: p_rec.per_information2 :=
586: irc_ipd_shd.g_old_rec.per_information2;
582: irc_ipd_shd.g_old_rec.per_information1;
583: End If;
584: If (p_rec.per_information2 = hr_api.g_varchar2) then
585: p_rec.per_information2 :=
586: irc_ipd_shd.g_old_rec.per_information2;
587: End If;
588: If (p_rec.per_information3 = hr_api.g_varchar2) then
589: p_rec.per_information3 :=
590: irc_ipd_shd.g_old_rec.per_information3;
586: irc_ipd_shd.g_old_rec.per_information2;
587: End If;
588: If (p_rec.per_information3 = hr_api.g_varchar2) then
589: p_rec.per_information3 :=
590: irc_ipd_shd.g_old_rec.per_information3;
591: End If;
592: If (p_rec.per_information4 = hr_api.g_varchar2) then
593: p_rec.per_information4 :=
594: irc_ipd_shd.g_old_rec.per_information4;
590: irc_ipd_shd.g_old_rec.per_information3;
591: End If;
592: If (p_rec.per_information4 = hr_api.g_varchar2) then
593: p_rec.per_information4 :=
594: irc_ipd_shd.g_old_rec.per_information4;
595: End If;
596: If (p_rec.per_information5 = hr_api.g_varchar2) then
597: p_rec.per_information5 :=
598: irc_ipd_shd.g_old_rec.per_information5;
594: irc_ipd_shd.g_old_rec.per_information4;
595: End If;
596: If (p_rec.per_information5 = hr_api.g_varchar2) then
597: p_rec.per_information5 :=
598: irc_ipd_shd.g_old_rec.per_information5;
599: End If;
600: If (p_rec.per_information6 = hr_api.g_varchar2) then
601: p_rec.per_information6 :=
602: irc_ipd_shd.g_old_rec.per_information6;
598: irc_ipd_shd.g_old_rec.per_information5;
599: End If;
600: If (p_rec.per_information6 = hr_api.g_varchar2) then
601: p_rec.per_information6 :=
602: irc_ipd_shd.g_old_rec.per_information6;
603: End If;
604: If (p_rec.per_information7 = hr_api.g_varchar2) then
605: p_rec.per_information7 :=
606: irc_ipd_shd.g_old_rec.per_information7;
602: irc_ipd_shd.g_old_rec.per_information6;
603: End If;
604: If (p_rec.per_information7 = hr_api.g_varchar2) then
605: p_rec.per_information7 :=
606: irc_ipd_shd.g_old_rec.per_information7;
607: End If;
608: If (p_rec.per_information8 = hr_api.g_varchar2) then
609: p_rec.per_information8 :=
610: irc_ipd_shd.g_old_rec.per_information8;
606: irc_ipd_shd.g_old_rec.per_information7;
607: End If;
608: If (p_rec.per_information8 = hr_api.g_varchar2) then
609: p_rec.per_information8 :=
610: irc_ipd_shd.g_old_rec.per_information8;
611: End If;
612: If (p_rec.per_information9 = hr_api.g_varchar2) then
613: p_rec.per_information9 :=
614: irc_ipd_shd.g_old_rec.per_information9;
610: irc_ipd_shd.g_old_rec.per_information8;
611: End If;
612: If (p_rec.per_information9 = hr_api.g_varchar2) then
613: p_rec.per_information9 :=
614: irc_ipd_shd.g_old_rec.per_information9;
615: End If;
616: If (p_rec.per_information10 = hr_api.g_varchar2) then
617: p_rec.per_information10 :=
618: irc_ipd_shd.g_old_rec.per_information10;
614: irc_ipd_shd.g_old_rec.per_information9;
615: End If;
616: If (p_rec.per_information10 = hr_api.g_varchar2) then
617: p_rec.per_information10 :=
618: irc_ipd_shd.g_old_rec.per_information10;
619: End If;
620: If (p_rec.per_information11 = hr_api.g_varchar2) then
621: p_rec.per_information11 :=
622: irc_ipd_shd.g_old_rec.per_information11;
618: irc_ipd_shd.g_old_rec.per_information10;
619: End If;
620: If (p_rec.per_information11 = hr_api.g_varchar2) then
621: p_rec.per_information11 :=
622: irc_ipd_shd.g_old_rec.per_information11;
623: End If;
624: If (p_rec.per_information12 = hr_api.g_varchar2) then
625: p_rec.per_information12 :=
626: irc_ipd_shd.g_old_rec.per_information12;
622: irc_ipd_shd.g_old_rec.per_information11;
623: End If;
624: If (p_rec.per_information12 = hr_api.g_varchar2) then
625: p_rec.per_information12 :=
626: irc_ipd_shd.g_old_rec.per_information12;
627: End If;
628: If (p_rec.per_information13 = hr_api.g_varchar2) then
629: p_rec.per_information13 :=
630: irc_ipd_shd.g_old_rec.per_information13;
626: irc_ipd_shd.g_old_rec.per_information12;
627: End If;
628: If (p_rec.per_information13 = hr_api.g_varchar2) then
629: p_rec.per_information13 :=
630: irc_ipd_shd.g_old_rec.per_information13;
631: End If;
632: If (p_rec.per_information14 = hr_api.g_varchar2) then
633: p_rec.per_information14 :=
634: irc_ipd_shd.g_old_rec.per_information14;
630: irc_ipd_shd.g_old_rec.per_information13;
631: End If;
632: If (p_rec.per_information14 = hr_api.g_varchar2) then
633: p_rec.per_information14 :=
634: irc_ipd_shd.g_old_rec.per_information14;
635: End If;
636: If (p_rec.per_information15 = hr_api.g_varchar2) then
637: p_rec.per_information15 :=
638: irc_ipd_shd.g_old_rec.per_information15;
634: irc_ipd_shd.g_old_rec.per_information14;
635: End If;
636: If (p_rec.per_information15 = hr_api.g_varchar2) then
637: p_rec.per_information15 :=
638: irc_ipd_shd.g_old_rec.per_information15;
639: End If;
640: If (p_rec.per_information16 = hr_api.g_varchar2) then
641: p_rec.per_information16 :=
642: irc_ipd_shd.g_old_rec.per_information16;
638: irc_ipd_shd.g_old_rec.per_information15;
639: End If;
640: If (p_rec.per_information16 = hr_api.g_varchar2) then
641: p_rec.per_information16 :=
642: irc_ipd_shd.g_old_rec.per_information16;
643: End If;
644: If (p_rec.per_information17 = hr_api.g_varchar2) then
645: p_rec.per_information17 :=
646: irc_ipd_shd.g_old_rec.per_information17;
642: irc_ipd_shd.g_old_rec.per_information16;
643: End If;
644: If (p_rec.per_information17 = hr_api.g_varchar2) then
645: p_rec.per_information17 :=
646: irc_ipd_shd.g_old_rec.per_information17;
647: End If;
648: If (p_rec.per_information18 = hr_api.g_varchar2) then
649: p_rec.per_information18 :=
650: irc_ipd_shd.g_old_rec.per_information18;
646: irc_ipd_shd.g_old_rec.per_information17;
647: End If;
648: If (p_rec.per_information18 = hr_api.g_varchar2) then
649: p_rec.per_information18 :=
650: irc_ipd_shd.g_old_rec.per_information18;
651: End If;
652: If (p_rec.per_information19 = hr_api.g_varchar2) then
653: p_rec.per_information19 :=
654: irc_ipd_shd.g_old_rec.per_information19;
650: irc_ipd_shd.g_old_rec.per_information18;
651: End If;
652: If (p_rec.per_information19 = hr_api.g_varchar2) then
653: p_rec.per_information19 :=
654: irc_ipd_shd.g_old_rec.per_information19;
655: End If;
656: If (p_rec.per_information20 = hr_api.g_varchar2) then
657: p_rec.per_information20 :=
658: irc_ipd_shd.g_old_rec.per_information20;
654: irc_ipd_shd.g_old_rec.per_information19;
655: End If;
656: If (p_rec.per_information20 = hr_api.g_varchar2) then
657: p_rec.per_information20 :=
658: irc_ipd_shd.g_old_rec.per_information20;
659: End If;
660: If (p_rec.per_information21 = hr_api.g_varchar2) then
661: p_rec.per_information21 :=
662: irc_ipd_shd.g_old_rec.per_information21;
658: irc_ipd_shd.g_old_rec.per_information20;
659: End If;
660: If (p_rec.per_information21 = hr_api.g_varchar2) then
661: p_rec.per_information21 :=
662: irc_ipd_shd.g_old_rec.per_information21;
663: End If;
664: If (p_rec.per_information22 = hr_api.g_varchar2) then
665: p_rec.per_information22 :=
666: irc_ipd_shd.g_old_rec.per_information22;
662: irc_ipd_shd.g_old_rec.per_information21;
663: End If;
664: If (p_rec.per_information22 = hr_api.g_varchar2) then
665: p_rec.per_information22 :=
666: irc_ipd_shd.g_old_rec.per_information22;
667: End If;
668: If (p_rec.per_information23 = hr_api.g_varchar2) then
669: p_rec.per_information23 :=
670: irc_ipd_shd.g_old_rec.per_information23;
666: irc_ipd_shd.g_old_rec.per_information22;
667: End If;
668: If (p_rec.per_information23 = hr_api.g_varchar2) then
669: p_rec.per_information23 :=
670: irc_ipd_shd.g_old_rec.per_information23;
671: End If;
672: If (p_rec.per_information24 = hr_api.g_varchar2) then
673: p_rec.per_information24 :=
674: irc_ipd_shd.g_old_rec.per_information24;
670: irc_ipd_shd.g_old_rec.per_information23;
671: End If;
672: If (p_rec.per_information24 = hr_api.g_varchar2) then
673: p_rec.per_information24 :=
674: irc_ipd_shd.g_old_rec.per_information24;
675: End If;
676: If (p_rec.per_information25 = hr_api.g_varchar2) then
677: p_rec.per_information25 :=
678: irc_ipd_shd.g_old_rec.per_information25;
674: irc_ipd_shd.g_old_rec.per_information24;
675: End If;
676: If (p_rec.per_information25 = hr_api.g_varchar2) then
677: p_rec.per_information25 :=
678: irc_ipd_shd.g_old_rec.per_information25;
679: End If;
680: If (p_rec.per_information26 = hr_api.g_varchar2) then
681: p_rec.per_information26 :=
682: irc_ipd_shd.g_old_rec.per_information26;
678: irc_ipd_shd.g_old_rec.per_information25;
679: End If;
680: If (p_rec.per_information26 = hr_api.g_varchar2) then
681: p_rec.per_information26 :=
682: irc_ipd_shd.g_old_rec.per_information26;
683: End If;
684: If (p_rec.per_information27 = hr_api.g_varchar2) then
685: p_rec.per_information27 :=
686: irc_ipd_shd.g_old_rec.per_information27;
682: irc_ipd_shd.g_old_rec.per_information26;
683: End If;
684: If (p_rec.per_information27 = hr_api.g_varchar2) then
685: p_rec.per_information27 :=
686: irc_ipd_shd.g_old_rec.per_information27;
687: End If;
688: If (p_rec.per_information28 = hr_api.g_varchar2) then
689: p_rec.per_information28 :=
690: irc_ipd_shd.g_old_rec.per_information28;
686: irc_ipd_shd.g_old_rec.per_information27;
687: End If;
688: If (p_rec.per_information28 = hr_api.g_varchar2) then
689: p_rec.per_information28 :=
690: irc_ipd_shd.g_old_rec.per_information28;
691: End If;
692: If (p_rec.per_information29 = hr_api.g_varchar2) then
693: p_rec.per_information29 :=
694: irc_ipd_shd.g_old_rec.per_information29;
690: irc_ipd_shd.g_old_rec.per_information28;
691: End If;
692: If (p_rec.per_information29 = hr_api.g_varchar2) then
693: p_rec.per_information29 :=
694: irc_ipd_shd.g_old_rec.per_information29;
695: End If;
696: If (p_rec.per_information30 = hr_api.g_varchar2) then
697: p_rec.per_information30 :=
698: irc_ipd_shd.g_old_rec.per_information30;
694: irc_ipd_shd.g_old_rec.per_information29;
695: End If;
696: If (p_rec.per_information30 = hr_api.g_varchar2) then
697: p_rec.per_information30 :=
698: irc_ipd_shd.g_old_rec.per_information30;
699: End If;
700: If (p_rec.error_message = hr_api.g_varchar2) then
701: p_rec.error_message :=
702: irc_ipd_shd.g_old_rec.error_message;
698: irc_ipd_shd.g_old_rec.per_information30;
699: End If;
700: If (p_rec.error_message = hr_api.g_varchar2) then
701: p_rec.error_message :=
702: irc_ipd_shd.g_old_rec.error_message;
703: End If;
704: If (p_rec.creation_date= hr_api.g_date) then
705: p_rec.creation_date :=
706: irc_ipd_shd.g_old_rec.creation_date;
702: irc_ipd_shd.g_old_rec.error_message;
703: End If;
704: If (p_rec.creation_date= hr_api.g_date) then
705: p_rec.creation_date :=
706: irc_ipd_shd.g_old_rec.creation_date;
707: End If;
708: If (p_rec.last_update_date = hr_api.g_date) then
709: p_rec.last_update_date :=
710: irc_ipd_shd.g_old_rec.last_update_date;
706: irc_ipd_shd.g_old_rec.creation_date;
707: End If;
708: If (p_rec.last_update_date = hr_api.g_date) then
709: p_rec.last_update_date :=
710: irc_ipd_shd.g_old_rec.last_update_date;
711: End If;
712: If (p_rec.allow_access = hr_api.g_varchar2) then
713: p_rec.allow_access :=
714: irc_ipd_shd.g_old_rec.allow_access;
710: irc_ipd_shd.g_old_rec.last_update_date;
711: End If;
712: If (p_rec.allow_access = hr_api.g_varchar2) then
713: p_rec.allow_access :=
714: irc_ipd_shd.g_old_rec.allow_access;
715: End If;
716: -- don't handle USER_GUID as we don't have a default value for RAW
717: If (p_rec.visitor_resp_key = hr_api.g_varchar2) then
718: p_rec.visitor_resp_key :=
715: End If;
716: -- don't handle USER_GUID as we don't have a default value for RAW
717: If (p_rec.visitor_resp_key = hr_api.g_varchar2) then
718: p_rec.visitor_resp_key :=
719: irc_ipd_shd.g_old_rec.visitor_resp_key;
720: End If;
721: If (p_rec.visitor_resp_appl_id = hr_api.g_number) then
722: p_rec.visitor_resp_appl_id :=
723: irc_ipd_shd.g_old_rec.visitor_resp_appl_id;
719: irc_ipd_shd.g_old_rec.visitor_resp_key;
720: End If;
721: If (p_rec.visitor_resp_appl_id = hr_api.g_number) then
722: p_rec.visitor_resp_appl_id :=
723: irc_ipd_shd.g_old_rec.visitor_resp_appl_id;
724: End If;
725: If (p_rec.security_group_key = hr_api.g_varchar2) then
726: p_rec.security_group_key :=
727: irc_ipd_shd.g_old_rec.security_group_key;
723: irc_ipd_shd.g_old_rec.visitor_resp_appl_id;
724: End If;
725: If (p_rec.security_group_key = hr_api.g_varchar2) then
726: p_rec.security_group_key :=
727: irc_ipd_shd.g_old_rec.security_group_key;
728: End If;
729: --
730: End convert_defs;
731: --
732: -- ----------------------------------------------------------------------------
733: -- |---------------------------------< upd >----------------------------------|
734: -- ----------------------------------------------------------------------------
735: Procedure upd
736: (p_rec in out nocopy irc_ipd_shd.g_rec_type
737: ) is
738: --
739: l_proc varchar2(72) := g_package||'upd';
740: --
742: hr_utility.set_location('Entering:'||l_proc, 5);
743: --
744: -- We must lock the row which we need to update.
745: --
746: irc_ipd_shd.lck
747: (p_rec.pending_data_id
748: );
749: --
750: -- 1. During an update system defaults are used to determine if
837: ,p_visitor_resp_appl_id in number default hr_api.g_number
838: ,p_security_group_key in varchar2 default hr_api.g_varchar2
839: ) is
840: --
841: l_rec irc_ipd_shd.g_rec_type;
842: l_proc varchar2(72) := g_package||'upd';
843: --
844: Begin
845: hr_utility.set_location('Entering:'||l_proc, 5);
847: -- Call conversion function to turn arguments into the
848: -- l_rec structure.
849: --
850: l_rec :=
851: irc_ipd_shd.convert_args
852: (p_pending_data_id
853: ,p_email_address
854: ,hr_api.g_number
855: ,p_last_name