52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy per_raa_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72) := g_package||'update_dml';
60: l_recruiting_site_response clob;
141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: --
145: per_raa_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.parent_integrity_violated Then
148: -- Parent integrity has been violated
149: --
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.parent_integrity_violated Then
148: -- Parent integrity has been violated
149: --
150: per_raa_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When hr_api.unique_integrity_violated Then
153: -- Unique integrity has been violated
154: --
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When hr_api.unique_integrity_violated Then
153: -- Unique integrity has been violated
154: --
155: per_raa_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When Others Then
158: --
159: Raise;
191: --
192: -- {End Of Comments}
193: -- ----------------------------------------------------------------------------
194: Procedure pre_update
195: (p_rec in per_raa_shd.g_rec_type
196: ) is
197: --
198: l_proc varchar2(72) := g_package||'pre_update';
199: --
235: --
236: -- {End Of Comments}
237: -- ----------------------------------------------------------------------------
238: Procedure post_update
239: (p_rec in per_raa_shd.g_rec_type
240: ) is
241: --
242: l_proc varchar2(72) := g_package||'post_update';
243: --
342: => p_rec.status
343: ,p_object_version_number
344: => p_rec.object_version_number
345: ,p_business_group_id_o
346: => per_raa_shd.g_old_rec.business_group_id
347: ,p_authorising_person_id_o
348: => per_raa_shd.g_old_rec.authorising_person_id
349: ,p_run_by_organization_id_o
350: => per_raa_shd.g_old_rec.run_by_organization_id
344: => p_rec.object_version_number
345: ,p_business_group_id_o
346: => per_raa_shd.g_old_rec.business_group_id
347: ,p_authorising_person_id_o
348: => per_raa_shd.g_old_rec.authorising_person_id
349: ,p_run_by_organization_id_o
350: => per_raa_shd.g_old_rec.run_by_organization_id
351: ,p_internal_contact_person_id_o
352: => per_raa_shd.g_old_rec.internal_contact_person_id
346: => per_raa_shd.g_old_rec.business_group_id
347: ,p_authorising_person_id_o
348: => per_raa_shd.g_old_rec.authorising_person_id
349: ,p_run_by_organization_id_o
350: => per_raa_shd.g_old_rec.run_by_organization_id
351: ,p_internal_contact_person_id_o
352: => per_raa_shd.g_old_rec.internal_contact_person_id
353: ,p_parent_recruitment_activit_o
354: => per_raa_shd.g_old_rec.parent_recruitment_activity_id
348: => per_raa_shd.g_old_rec.authorising_person_id
349: ,p_run_by_organization_id_o
350: => per_raa_shd.g_old_rec.run_by_organization_id
351: ,p_internal_contact_person_id_o
352: => per_raa_shd.g_old_rec.internal_contact_person_id
353: ,p_parent_recruitment_activit_o
354: => per_raa_shd.g_old_rec.parent_recruitment_activity_id
355: ,p_currency_code_o
356: => per_raa_shd.g_old_rec.currency_code
350: => per_raa_shd.g_old_rec.run_by_organization_id
351: ,p_internal_contact_person_id_o
352: => per_raa_shd.g_old_rec.internal_contact_person_id
353: ,p_parent_recruitment_activit_o
354: => per_raa_shd.g_old_rec.parent_recruitment_activity_id
355: ,p_currency_code_o
356: => per_raa_shd.g_old_rec.currency_code
357: ,p_date_start_o
358: => per_raa_shd.g_old_rec.date_start
352: => per_raa_shd.g_old_rec.internal_contact_person_id
353: ,p_parent_recruitment_activit_o
354: => per_raa_shd.g_old_rec.parent_recruitment_activity_id
355: ,p_currency_code_o
356: => per_raa_shd.g_old_rec.currency_code
357: ,p_date_start_o
358: => per_raa_shd.g_old_rec.date_start
359: ,p_name_o
360: => per_raa_shd.g_old_rec.name
354: => per_raa_shd.g_old_rec.parent_recruitment_activity_id
355: ,p_currency_code_o
356: => per_raa_shd.g_old_rec.currency_code
357: ,p_date_start_o
358: => per_raa_shd.g_old_rec.date_start
359: ,p_name_o
360: => per_raa_shd.g_old_rec.name
361: ,p_actual_cost_o
362: => per_raa_shd.g_old_rec.actual_cost
356: => per_raa_shd.g_old_rec.currency_code
357: ,p_date_start_o
358: => per_raa_shd.g_old_rec.date_start
359: ,p_name_o
360: => per_raa_shd.g_old_rec.name
361: ,p_actual_cost_o
362: => per_raa_shd.g_old_rec.actual_cost
363: ,p_comments_o
364: => per_raa_shd.g_old_rec.comments
358: => per_raa_shd.g_old_rec.date_start
359: ,p_name_o
360: => per_raa_shd.g_old_rec.name
361: ,p_actual_cost_o
362: => per_raa_shd.g_old_rec.actual_cost
363: ,p_comments_o
364: => per_raa_shd.g_old_rec.comments
365: ,p_contact_telephone_number_o
366: => per_raa_shd.g_old_rec.contact_telephone_number
360: => per_raa_shd.g_old_rec.name
361: ,p_actual_cost_o
362: => per_raa_shd.g_old_rec.actual_cost
363: ,p_comments_o
364: => per_raa_shd.g_old_rec.comments
365: ,p_contact_telephone_number_o
366: => per_raa_shd.g_old_rec.contact_telephone_number
367: ,p_date_closing_o
368: => per_raa_shd.g_old_rec.date_closing
362: => per_raa_shd.g_old_rec.actual_cost
363: ,p_comments_o
364: => per_raa_shd.g_old_rec.comments
365: ,p_contact_telephone_number_o
366: => per_raa_shd.g_old_rec.contact_telephone_number
367: ,p_date_closing_o
368: => per_raa_shd.g_old_rec.date_closing
369: ,p_date_end_o
370: => per_raa_shd.g_old_rec.date_end
364: => per_raa_shd.g_old_rec.comments
365: ,p_contact_telephone_number_o
366: => per_raa_shd.g_old_rec.contact_telephone_number
367: ,p_date_closing_o
368: => per_raa_shd.g_old_rec.date_closing
369: ,p_date_end_o
370: => per_raa_shd.g_old_rec.date_end
371: ,p_external_contact_o
372: => per_raa_shd.g_old_rec.external_contact
366: => per_raa_shd.g_old_rec.contact_telephone_number
367: ,p_date_closing_o
368: => per_raa_shd.g_old_rec.date_closing
369: ,p_date_end_o
370: => per_raa_shd.g_old_rec.date_end
371: ,p_external_contact_o
372: => per_raa_shd.g_old_rec.external_contact
373: ,p_planned_cost_o
374: => per_raa_shd.g_old_rec.planned_cost
368: => per_raa_shd.g_old_rec.date_closing
369: ,p_date_end_o
370: => per_raa_shd.g_old_rec.date_end
371: ,p_external_contact_o
372: => per_raa_shd.g_old_rec.external_contact
373: ,p_planned_cost_o
374: => per_raa_shd.g_old_rec.planned_cost
375: ,p_recruiting_site_id_o
376: => per_raa_shd.g_old_rec.recruiting_site_id
370: => per_raa_shd.g_old_rec.date_end
371: ,p_external_contact_o
372: => per_raa_shd.g_old_rec.external_contact
373: ,p_planned_cost_o
374: => per_raa_shd.g_old_rec.planned_cost
375: ,p_recruiting_site_id_o
376: => per_raa_shd.g_old_rec.recruiting_site_id
377: ,p_recruiting_site_response_o
378: => per_raa_shd.g_old_rec.recruiting_site_response
372: => per_raa_shd.g_old_rec.external_contact
373: ,p_planned_cost_o
374: => per_raa_shd.g_old_rec.planned_cost
375: ,p_recruiting_site_id_o
376: => per_raa_shd.g_old_rec.recruiting_site_id
377: ,p_recruiting_site_response_o
378: => per_raa_shd.g_old_rec.recruiting_site_response
379: ,p_last_posted_date_o
380: => per_raa_shd.g_old_rec.last_posted_date
374: => per_raa_shd.g_old_rec.planned_cost
375: ,p_recruiting_site_id_o
376: => per_raa_shd.g_old_rec.recruiting_site_id
377: ,p_recruiting_site_response_o
378: => per_raa_shd.g_old_rec.recruiting_site_response
379: ,p_last_posted_date_o
380: => per_raa_shd.g_old_rec.last_posted_date
381: ,p_type_o
382: => per_raa_shd.g_old_rec.type
376: => per_raa_shd.g_old_rec.recruiting_site_id
377: ,p_recruiting_site_response_o
378: => per_raa_shd.g_old_rec.recruiting_site_response
379: ,p_last_posted_date_o
380: => per_raa_shd.g_old_rec.last_posted_date
381: ,p_type_o
382: => per_raa_shd.g_old_rec.type
383: ,p_request_id_o
384: => per_raa_shd.g_old_rec.request_id
378: => per_raa_shd.g_old_rec.recruiting_site_response
379: ,p_last_posted_date_o
380: => per_raa_shd.g_old_rec.last_posted_date
381: ,p_type_o
382: => per_raa_shd.g_old_rec.type
383: ,p_request_id_o
384: => per_raa_shd.g_old_rec.request_id
385: ,p_program_application_id_o
386: => per_raa_shd.g_old_rec.program_application_id
380: => per_raa_shd.g_old_rec.last_posted_date
381: ,p_type_o
382: => per_raa_shd.g_old_rec.type
383: ,p_request_id_o
384: => per_raa_shd.g_old_rec.request_id
385: ,p_program_application_id_o
386: => per_raa_shd.g_old_rec.program_application_id
387: ,p_program_id_o
388: => per_raa_shd.g_old_rec.program_id
382: => per_raa_shd.g_old_rec.type
383: ,p_request_id_o
384: => per_raa_shd.g_old_rec.request_id
385: ,p_program_application_id_o
386: => per_raa_shd.g_old_rec.program_application_id
387: ,p_program_id_o
388: => per_raa_shd.g_old_rec.program_id
389: ,p_program_update_date_o
390: => per_raa_shd.g_old_rec.program_update_date
384: => per_raa_shd.g_old_rec.request_id
385: ,p_program_application_id_o
386: => per_raa_shd.g_old_rec.program_application_id
387: ,p_program_id_o
388: => per_raa_shd.g_old_rec.program_id
389: ,p_program_update_date_o
390: => per_raa_shd.g_old_rec.program_update_date
391: ,p_attribute_category_o
392: => per_raa_shd.g_old_rec.attribute_category
386: => per_raa_shd.g_old_rec.program_application_id
387: ,p_program_id_o
388: => per_raa_shd.g_old_rec.program_id
389: ,p_program_update_date_o
390: => per_raa_shd.g_old_rec.program_update_date
391: ,p_attribute_category_o
392: => per_raa_shd.g_old_rec.attribute_category
393: ,p_attribute1_o
394: => per_raa_shd.g_old_rec.attribute1
388: => per_raa_shd.g_old_rec.program_id
389: ,p_program_update_date_o
390: => per_raa_shd.g_old_rec.program_update_date
391: ,p_attribute_category_o
392: => per_raa_shd.g_old_rec.attribute_category
393: ,p_attribute1_o
394: => per_raa_shd.g_old_rec.attribute1
395: ,p_attribute2_o
396: => per_raa_shd.g_old_rec.attribute2
390: => per_raa_shd.g_old_rec.program_update_date
391: ,p_attribute_category_o
392: => per_raa_shd.g_old_rec.attribute_category
393: ,p_attribute1_o
394: => per_raa_shd.g_old_rec.attribute1
395: ,p_attribute2_o
396: => per_raa_shd.g_old_rec.attribute2
397: ,p_attribute3_o
398: => per_raa_shd.g_old_rec.attribute3
392: => per_raa_shd.g_old_rec.attribute_category
393: ,p_attribute1_o
394: => per_raa_shd.g_old_rec.attribute1
395: ,p_attribute2_o
396: => per_raa_shd.g_old_rec.attribute2
397: ,p_attribute3_o
398: => per_raa_shd.g_old_rec.attribute3
399: ,p_attribute4_o
400: => per_raa_shd.g_old_rec.attribute4
394: => per_raa_shd.g_old_rec.attribute1
395: ,p_attribute2_o
396: => per_raa_shd.g_old_rec.attribute2
397: ,p_attribute3_o
398: => per_raa_shd.g_old_rec.attribute3
399: ,p_attribute4_o
400: => per_raa_shd.g_old_rec.attribute4
401: ,p_attribute5_o
402: => per_raa_shd.g_old_rec.attribute5
396: => per_raa_shd.g_old_rec.attribute2
397: ,p_attribute3_o
398: => per_raa_shd.g_old_rec.attribute3
399: ,p_attribute4_o
400: => per_raa_shd.g_old_rec.attribute4
401: ,p_attribute5_o
402: => per_raa_shd.g_old_rec.attribute5
403: ,p_attribute6_o
404: => per_raa_shd.g_old_rec.attribute6
398: => per_raa_shd.g_old_rec.attribute3
399: ,p_attribute4_o
400: => per_raa_shd.g_old_rec.attribute4
401: ,p_attribute5_o
402: => per_raa_shd.g_old_rec.attribute5
403: ,p_attribute6_o
404: => per_raa_shd.g_old_rec.attribute6
405: ,p_attribute7_o
406: => per_raa_shd.g_old_rec.attribute7
400: => per_raa_shd.g_old_rec.attribute4
401: ,p_attribute5_o
402: => per_raa_shd.g_old_rec.attribute5
403: ,p_attribute6_o
404: => per_raa_shd.g_old_rec.attribute6
405: ,p_attribute7_o
406: => per_raa_shd.g_old_rec.attribute7
407: ,p_attribute8_o
408: => per_raa_shd.g_old_rec.attribute8
402: => per_raa_shd.g_old_rec.attribute5
403: ,p_attribute6_o
404: => per_raa_shd.g_old_rec.attribute6
405: ,p_attribute7_o
406: => per_raa_shd.g_old_rec.attribute7
407: ,p_attribute8_o
408: => per_raa_shd.g_old_rec.attribute8
409: ,p_attribute9_o
410: => per_raa_shd.g_old_rec.attribute9
404: => per_raa_shd.g_old_rec.attribute6
405: ,p_attribute7_o
406: => per_raa_shd.g_old_rec.attribute7
407: ,p_attribute8_o
408: => per_raa_shd.g_old_rec.attribute8
409: ,p_attribute9_o
410: => per_raa_shd.g_old_rec.attribute9
411: ,p_attribute10_o
412: => per_raa_shd.g_old_rec.attribute10
406: => per_raa_shd.g_old_rec.attribute7
407: ,p_attribute8_o
408: => per_raa_shd.g_old_rec.attribute8
409: ,p_attribute9_o
410: => per_raa_shd.g_old_rec.attribute9
411: ,p_attribute10_o
412: => per_raa_shd.g_old_rec.attribute10
413: ,p_attribute11_o
414: => per_raa_shd.g_old_rec.attribute11
408: => per_raa_shd.g_old_rec.attribute8
409: ,p_attribute9_o
410: => per_raa_shd.g_old_rec.attribute9
411: ,p_attribute10_o
412: => per_raa_shd.g_old_rec.attribute10
413: ,p_attribute11_o
414: => per_raa_shd.g_old_rec.attribute11
415: ,p_attribute12_o
416: => per_raa_shd.g_old_rec.attribute12
410: => per_raa_shd.g_old_rec.attribute9
411: ,p_attribute10_o
412: => per_raa_shd.g_old_rec.attribute10
413: ,p_attribute11_o
414: => per_raa_shd.g_old_rec.attribute11
415: ,p_attribute12_o
416: => per_raa_shd.g_old_rec.attribute12
417: ,p_attribute13_o
418: => per_raa_shd.g_old_rec.attribute13
412: => per_raa_shd.g_old_rec.attribute10
413: ,p_attribute11_o
414: => per_raa_shd.g_old_rec.attribute11
415: ,p_attribute12_o
416: => per_raa_shd.g_old_rec.attribute12
417: ,p_attribute13_o
418: => per_raa_shd.g_old_rec.attribute13
419: ,p_attribute14_o
420: => per_raa_shd.g_old_rec.attribute14
414: => per_raa_shd.g_old_rec.attribute11
415: ,p_attribute12_o
416: => per_raa_shd.g_old_rec.attribute12
417: ,p_attribute13_o
418: => per_raa_shd.g_old_rec.attribute13
419: ,p_attribute14_o
420: => per_raa_shd.g_old_rec.attribute14
421: ,p_attribute15_o
422: => per_raa_shd.g_old_rec.attribute15
416: => per_raa_shd.g_old_rec.attribute12
417: ,p_attribute13_o
418: => per_raa_shd.g_old_rec.attribute13
419: ,p_attribute14_o
420: => per_raa_shd.g_old_rec.attribute14
421: ,p_attribute15_o
422: => per_raa_shd.g_old_rec.attribute15
423: ,p_attribute16_o
424: => per_raa_shd.g_old_rec.attribute16
418: => per_raa_shd.g_old_rec.attribute13
419: ,p_attribute14_o
420: => per_raa_shd.g_old_rec.attribute14
421: ,p_attribute15_o
422: => per_raa_shd.g_old_rec.attribute15
423: ,p_attribute16_o
424: => per_raa_shd.g_old_rec.attribute16
425: ,p_attribute17_o
426: => per_raa_shd.g_old_rec.attribute17
420: => per_raa_shd.g_old_rec.attribute14
421: ,p_attribute15_o
422: => per_raa_shd.g_old_rec.attribute15
423: ,p_attribute16_o
424: => per_raa_shd.g_old_rec.attribute16
425: ,p_attribute17_o
426: => per_raa_shd.g_old_rec.attribute17
427: ,p_attribute18_o
428: => per_raa_shd.g_old_rec.attribute18
422: => per_raa_shd.g_old_rec.attribute15
423: ,p_attribute16_o
424: => per_raa_shd.g_old_rec.attribute16
425: ,p_attribute17_o
426: => per_raa_shd.g_old_rec.attribute17
427: ,p_attribute18_o
428: => per_raa_shd.g_old_rec.attribute18
429: ,p_attribute19_o
430: => per_raa_shd.g_old_rec.attribute19
424: => per_raa_shd.g_old_rec.attribute16
425: ,p_attribute17_o
426: => per_raa_shd.g_old_rec.attribute17
427: ,p_attribute18_o
428: => per_raa_shd.g_old_rec.attribute18
429: ,p_attribute19_o
430: => per_raa_shd.g_old_rec.attribute19
431: ,p_attribute20_o
432: => per_raa_shd.g_old_rec.attribute20
426: => per_raa_shd.g_old_rec.attribute17
427: ,p_attribute18_o
428: => per_raa_shd.g_old_rec.attribute18
429: ,p_attribute19_o
430: => per_raa_shd.g_old_rec.attribute19
431: ,p_attribute20_o
432: => per_raa_shd.g_old_rec.attribute20
433: ,p_posting_content_id_o
434: => per_raa_shd.g_old_rec.posting_content_id
428: => per_raa_shd.g_old_rec.attribute18
429: ,p_attribute19_o
430: => per_raa_shd.g_old_rec.attribute19
431: ,p_attribute20_o
432: => per_raa_shd.g_old_rec.attribute20
433: ,p_posting_content_id_o
434: => per_raa_shd.g_old_rec.posting_content_id
435: ,p_status_o
436: => per_raa_shd.g_old_rec.status
430: => per_raa_shd.g_old_rec.attribute19
431: ,p_attribute20_o
432: => per_raa_shd.g_old_rec.attribute20
433: ,p_posting_content_id_o
434: => per_raa_shd.g_old_rec.posting_content_id
435: ,p_status_o
436: => per_raa_shd.g_old_rec.status
437: ,p_object_version_number_o
438: => per_raa_shd.g_old_rec.object_version_number
432: => per_raa_shd.g_old_rec.attribute20
433: ,p_posting_content_id_o
434: => per_raa_shd.g_old_rec.posting_content_id
435: ,p_status_o
436: => per_raa_shd.g_old_rec.status
437: ,p_object_version_number_o
438: => per_raa_shd.g_old_rec.object_version_number
439: );
440: --
434: => per_raa_shd.g_old_rec.posting_content_id
435: ,p_status_o
436: => per_raa_shd.g_old_rec.status
437: ,p_object_version_number_o
438: => per_raa_shd.g_old_rec.object_version_number
439: );
440: --
441: exception
442: --
494: --
495: -- {End Of Comments}
496: -- ----------------------------------------------------------------------------
497: Procedure convert_defs
498: (p_rec in out nocopy per_raa_shd.g_rec_type
499: ) is
500: --
501: Begin
502: --
506: -- is being used then we must set to the 'current' argument value.
507: --
508: If (p_rec.business_group_id = hr_api.g_number) then
509: p_rec.business_group_id :=
510: per_raa_shd.g_old_rec.business_group_id;
511: End If;
512: If (p_rec.authorising_person_id = hr_api.g_number) then
513: p_rec.authorising_person_id :=
514: per_raa_shd.g_old_rec.authorising_person_id;
510: per_raa_shd.g_old_rec.business_group_id;
511: End If;
512: If (p_rec.authorising_person_id = hr_api.g_number) then
513: p_rec.authorising_person_id :=
514: per_raa_shd.g_old_rec.authorising_person_id;
515: End If;
516: If (p_rec.run_by_organization_id = hr_api.g_number) then
517: p_rec.run_by_organization_id :=
518: per_raa_shd.g_old_rec.run_by_organization_id;
514: per_raa_shd.g_old_rec.authorising_person_id;
515: End If;
516: If (p_rec.run_by_organization_id = hr_api.g_number) then
517: p_rec.run_by_organization_id :=
518: per_raa_shd.g_old_rec.run_by_organization_id;
519: End If;
520: If (p_rec.internal_contact_person_id = hr_api.g_number) then
521: p_rec.internal_contact_person_id :=
522: per_raa_shd.g_old_rec.internal_contact_person_id;
518: per_raa_shd.g_old_rec.run_by_organization_id;
519: End If;
520: If (p_rec.internal_contact_person_id = hr_api.g_number) then
521: p_rec.internal_contact_person_id :=
522: per_raa_shd.g_old_rec.internal_contact_person_id;
523: End If;
524: If (p_rec.parent_recruitment_activity_id = hr_api.g_number) then
525: p_rec.parent_recruitment_activity_id :=
526: per_raa_shd.g_old_rec.parent_recruitment_activity_id;
522: per_raa_shd.g_old_rec.internal_contact_person_id;
523: End If;
524: If (p_rec.parent_recruitment_activity_id = hr_api.g_number) then
525: p_rec.parent_recruitment_activity_id :=
526: per_raa_shd.g_old_rec.parent_recruitment_activity_id;
527: End If;
528: If (p_rec.currency_code = hr_api.g_varchar2) then
529: p_rec.currency_code :=
530: per_raa_shd.g_old_rec.currency_code;
526: per_raa_shd.g_old_rec.parent_recruitment_activity_id;
527: End If;
528: If (p_rec.currency_code = hr_api.g_varchar2) then
529: p_rec.currency_code :=
530: per_raa_shd.g_old_rec.currency_code;
531: End If;
532: If (p_rec.date_start = hr_api.g_date) then
533: p_rec.date_start :=
534: per_raa_shd.g_old_rec.date_start;
530: per_raa_shd.g_old_rec.currency_code;
531: End If;
532: If (p_rec.date_start = hr_api.g_date) then
533: p_rec.date_start :=
534: per_raa_shd.g_old_rec.date_start;
535: End If;
536: If (p_rec.name = hr_api.g_varchar2) then
537: p_rec.name :=
538: per_raa_shd.g_old_rec.name;
534: per_raa_shd.g_old_rec.date_start;
535: End If;
536: If (p_rec.name = hr_api.g_varchar2) then
537: p_rec.name :=
538: per_raa_shd.g_old_rec.name;
539: End If;
540: If (p_rec.actual_cost = hr_api.g_varchar2) then
541: p_rec.actual_cost :=
542: per_raa_shd.g_old_rec.actual_cost;
538: per_raa_shd.g_old_rec.name;
539: End If;
540: If (p_rec.actual_cost = hr_api.g_varchar2) then
541: p_rec.actual_cost :=
542: per_raa_shd.g_old_rec.actual_cost;
543: End If;
544: If (p_rec.comments = hr_api.g_varchar2) then
545: p_rec.comments :=
546: per_raa_shd.g_old_rec.comments;
542: per_raa_shd.g_old_rec.actual_cost;
543: End If;
544: If (p_rec.comments = hr_api.g_varchar2) then
545: p_rec.comments :=
546: per_raa_shd.g_old_rec.comments;
547: End If;
548: If (p_rec.contact_telephone_number = hr_api.g_varchar2) then
549: p_rec.contact_telephone_number :=
550: per_raa_shd.g_old_rec.contact_telephone_number;
546: per_raa_shd.g_old_rec.comments;
547: End If;
548: If (p_rec.contact_telephone_number = hr_api.g_varchar2) then
549: p_rec.contact_telephone_number :=
550: per_raa_shd.g_old_rec.contact_telephone_number;
551: End If;
552: If (p_rec.date_closing = hr_api.g_date) then
553: p_rec.date_closing :=
554: per_raa_shd.g_old_rec.date_closing;
550: per_raa_shd.g_old_rec.contact_telephone_number;
551: End If;
552: If (p_rec.date_closing = hr_api.g_date) then
553: p_rec.date_closing :=
554: per_raa_shd.g_old_rec.date_closing;
555: End If;
556: If (p_rec.date_end = hr_api.g_date) then
557: p_rec.date_end :=
558: per_raa_shd.g_old_rec.date_end;
554: per_raa_shd.g_old_rec.date_closing;
555: End If;
556: If (p_rec.date_end = hr_api.g_date) then
557: p_rec.date_end :=
558: per_raa_shd.g_old_rec.date_end;
559: End If;
560: If (p_rec.external_contact = hr_api.g_varchar2) then
561: p_rec.external_contact :=
562: per_raa_shd.g_old_rec.external_contact;
558: per_raa_shd.g_old_rec.date_end;
559: End If;
560: If (p_rec.external_contact = hr_api.g_varchar2) then
561: p_rec.external_contact :=
562: per_raa_shd.g_old_rec.external_contact;
563: End If;
564: If (p_rec.planned_cost = hr_api.g_varchar2) then
565: p_rec.planned_cost :=
566: per_raa_shd.g_old_rec.planned_cost;
562: per_raa_shd.g_old_rec.external_contact;
563: End If;
564: If (p_rec.planned_cost = hr_api.g_varchar2) then
565: p_rec.planned_cost :=
566: per_raa_shd.g_old_rec.planned_cost;
567: End If;
568: If (p_rec.recruiting_site_id = hr_api.g_number) then
569: p_rec.recruiting_site_id :=
570: per_raa_shd.g_old_rec.recruiting_site_id;
566: per_raa_shd.g_old_rec.planned_cost;
567: End If;
568: If (p_rec.recruiting_site_id = hr_api.g_number) then
569: p_rec.recruiting_site_id :=
570: per_raa_shd.g_old_rec.recruiting_site_id;
571: End If;
572: If (p_rec.recruiting_site_response = hr_api.g_varchar2) then
573: p_rec.recruiting_site_response :=
574: per_raa_shd.g_old_rec.recruiting_site_response;
570: per_raa_shd.g_old_rec.recruiting_site_id;
571: End If;
572: If (p_rec.recruiting_site_response = hr_api.g_varchar2) then
573: p_rec.recruiting_site_response :=
574: per_raa_shd.g_old_rec.recruiting_site_response;
575: Else
576: g_recruiting_site_response:=true;
577: End If;
578: if (p_rec.last_posted_date=hr_api.g_date) then
576: g_recruiting_site_response:=true;
577: End If;
578: if (p_rec.last_posted_date=hr_api.g_date) then
579: p_rec.last_posted_date :=
580: per_raa_shd.g_old_rec.last_posted_date;
581: end if;
582: If (p_rec.type = hr_api.g_varchar2) then
583: p_rec.type :=
584: per_raa_shd.g_old_rec.type;
580: per_raa_shd.g_old_rec.last_posted_date;
581: end if;
582: If (p_rec.type = hr_api.g_varchar2) then
583: p_rec.type :=
584: per_raa_shd.g_old_rec.type;
585: End If;
586: If (p_rec.request_id = hr_api.g_number) then
587: p_rec.request_id :=
588: per_raa_shd.g_old_rec.request_id;
584: per_raa_shd.g_old_rec.type;
585: End If;
586: If (p_rec.request_id = hr_api.g_number) then
587: p_rec.request_id :=
588: per_raa_shd.g_old_rec.request_id;
589: End If;
590: If (p_rec.program_application_id = hr_api.g_number) then
591: p_rec.program_application_id :=
592: per_raa_shd.g_old_rec.program_application_id;
588: per_raa_shd.g_old_rec.request_id;
589: End If;
590: If (p_rec.program_application_id = hr_api.g_number) then
591: p_rec.program_application_id :=
592: per_raa_shd.g_old_rec.program_application_id;
593: End If;
594: If (p_rec.program_id = hr_api.g_number) then
595: p_rec.program_id :=
596: per_raa_shd.g_old_rec.program_id;
592: per_raa_shd.g_old_rec.program_application_id;
593: End If;
594: If (p_rec.program_id = hr_api.g_number) then
595: p_rec.program_id :=
596: per_raa_shd.g_old_rec.program_id;
597: End If;
598: If (p_rec.program_update_date = hr_api.g_date) then
599: p_rec.program_update_date :=
600: per_raa_shd.g_old_rec.program_update_date;
596: per_raa_shd.g_old_rec.program_id;
597: End If;
598: If (p_rec.program_update_date = hr_api.g_date) then
599: p_rec.program_update_date :=
600: per_raa_shd.g_old_rec.program_update_date;
601: End If;
602: If (p_rec.attribute_category = hr_api.g_varchar2) then
603: p_rec.attribute_category :=
604: per_raa_shd.g_old_rec.attribute_category;
600: per_raa_shd.g_old_rec.program_update_date;
601: End If;
602: If (p_rec.attribute_category = hr_api.g_varchar2) then
603: p_rec.attribute_category :=
604: per_raa_shd.g_old_rec.attribute_category;
605: End If;
606: If (p_rec.attribute1 = hr_api.g_varchar2) then
607: p_rec.attribute1 :=
608: per_raa_shd.g_old_rec.attribute1;
604: per_raa_shd.g_old_rec.attribute_category;
605: End If;
606: If (p_rec.attribute1 = hr_api.g_varchar2) then
607: p_rec.attribute1 :=
608: per_raa_shd.g_old_rec.attribute1;
609: End If;
610: If (p_rec.attribute2 = hr_api.g_varchar2) then
611: p_rec.attribute2 :=
612: per_raa_shd.g_old_rec.attribute2;
608: per_raa_shd.g_old_rec.attribute1;
609: End If;
610: If (p_rec.attribute2 = hr_api.g_varchar2) then
611: p_rec.attribute2 :=
612: per_raa_shd.g_old_rec.attribute2;
613: End If;
614: If (p_rec.attribute3 = hr_api.g_varchar2) then
615: p_rec.attribute3 :=
616: per_raa_shd.g_old_rec.attribute3;
612: per_raa_shd.g_old_rec.attribute2;
613: End If;
614: If (p_rec.attribute3 = hr_api.g_varchar2) then
615: p_rec.attribute3 :=
616: per_raa_shd.g_old_rec.attribute3;
617: End If;
618: If (p_rec.attribute4 = hr_api.g_varchar2) then
619: p_rec.attribute4 :=
620: per_raa_shd.g_old_rec.attribute4;
616: per_raa_shd.g_old_rec.attribute3;
617: End If;
618: If (p_rec.attribute4 = hr_api.g_varchar2) then
619: p_rec.attribute4 :=
620: per_raa_shd.g_old_rec.attribute4;
621: End If;
622: If (p_rec.attribute5 = hr_api.g_varchar2) then
623: p_rec.attribute5 :=
624: per_raa_shd.g_old_rec.attribute5;
620: per_raa_shd.g_old_rec.attribute4;
621: End If;
622: If (p_rec.attribute5 = hr_api.g_varchar2) then
623: p_rec.attribute5 :=
624: per_raa_shd.g_old_rec.attribute5;
625: End If;
626: If (p_rec.attribute6 = hr_api.g_varchar2) then
627: p_rec.attribute6 :=
628: per_raa_shd.g_old_rec.attribute6;
624: per_raa_shd.g_old_rec.attribute5;
625: End If;
626: If (p_rec.attribute6 = hr_api.g_varchar2) then
627: p_rec.attribute6 :=
628: per_raa_shd.g_old_rec.attribute6;
629: End If;
630: If (p_rec.attribute7 = hr_api.g_varchar2) then
631: p_rec.attribute7 :=
632: per_raa_shd.g_old_rec.attribute7;
628: per_raa_shd.g_old_rec.attribute6;
629: End If;
630: If (p_rec.attribute7 = hr_api.g_varchar2) then
631: p_rec.attribute7 :=
632: per_raa_shd.g_old_rec.attribute7;
633: End If;
634: If (p_rec.attribute8 = hr_api.g_varchar2) then
635: p_rec.attribute8 :=
636: per_raa_shd.g_old_rec.attribute8;
632: per_raa_shd.g_old_rec.attribute7;
633: End If;
634: If (p_rec.attribute8 = hr_api.g_varchar2) then
635: p_rec.attribute8 :=
636: per_raa_shd.g_old_rec.attribute8;
637: End If;
638: If (p_rec.attribute9 = hr_api.g_varchar2) then
639: p_rec.attribute9 :=
640: per_raa_shd.g_old_rec.attribute9;
636: per_raa_shd.g_old_rec.attribute8;
637: End If;
638: If (p_rec.attribute9 = hr_api.g_varchar2) then
639: p_rec.attribute9 :=
640: per_raa_shd.g_old_rec.attribute9;
641: End If;
642: If (p_rec.attribute10 = hr_api.g_varchar2) then
643: p_rec.attribute10 :=
644: per_raa_shd.g_old_rec.attribute10;
640: per_raa_shd.g_old_rec.attribute9;
641: End If;
642: If (p_rec.attribute10 = hr_api.g_varchar2) then
643: p_rec.attribute10 :=
644: per_raa_shd.g_old_rec.attribute10;
645: End If;
646: If (p_rec.attribute11 = hr_api.g_varchar2) then
647: p_rec.attribute11 :=
648: per_raa_shd.g_old_rec.attribute11;
644: per_raa_shd.g_old_rec.attribute10;
645: End If;
646: If (p_rec.attribute11 = hr_api.g_varchar2) then
647: p_rec.attribute11 :=
648: per_raa_shd.g_old_rec.attribute11;
649: End If;
650: If (p_rec.attribute12 = hr_api.g_varchar2) then
651: p_rec.attribute12 :=
652: per_raa_shd.g_old_rec.attribute12;
648: per_raa_shd.g_old_rec.attribute11;
649: End If;
650: If (p_rec.attribute12 = hr_api.g_varchar2) then
651: p_rec.attribute12 :=
652: per_raa_shd.g_old_rec.attribute12;
653: End If;
654: If (p_rec.attribute13 = hr_api.g_varchar2) then
655: p_rec.attribute13 :=
656: per_raa_shd.g_old_rec.attribute13;
652: per_raa_shd.g_old_rec.attribute12;
653: End If;
654: If (p_rec.attribute13 = hr_api.g_varchar2) then
655: p_rec.attribute13 :=
656: per_raa_shd.g_old_rec.attribute13;
657: End If;
658: If (p_rec.attribute14 = hr_api.g_varchar2) then
659: p_rec.attribute14 :=
660: per_raa_shd.g_old_rec.attribute14;
656: per_raa_shd.g_old_rec.attribute13;
657: End If;
658: If (p_rec.attribute14 = hr_api.g_varchar2) then
659: p_rec.attribute14 :=
660: per_raa_shd.g_old_rec.attribute14;
661: End If;
662: If (p_rec.attribute15 = hr_api.g_varchar2) then
663: p_rec.attribute15 :=
664: per_raa_shd.g_old_rec.attribute15;
660: per_raa_shd.g_old_rec.attribute14;
661: End If;
662: If (p_rec.attribute15 = hr_api.g_varchar2) then
663: p_rec.attribute15 :=
664: per_raa_shd.g_old_rec.attribute15;
665: End If;
666: If (p_rec.attribute16 = hr_api.g_varchar2) then
667: p_rec.attribute16 :=
668: per_raa_shd.g_old_rec.attribute16;
664: per_raa_shd.g_old_rec.attribute15;
665: End If;
666: If (p_rec.attribute16 = hr_api.g_varchar2) then
667: p_rec.attribute16 :=
668: per_raa_shd.g_old_rec.attribute16;
669: End If;
670: If (p_rec.attribute17 = hr_api.g_varchar2) then
671: p_rec.attribute17 :=
672: per_raa_shd.g_old_rec.attribute17;
668: per_raa_shd.g_old_rec.attribute16;
669: End If;
670: If (p_rec.attribute17 = hr_api.g_varchar2) then
671: p_rec.attribute17 :=
672: per_raa_shd.g_old_rec.attribute17;
673: End If;
674: If (p_rec.attribute18 = hr_api.g_varchar2) then
675: p_rec.attribute18 :=
676: per_raa_shd.g_old_rec.attribute18;
672: per_raa_shd.g_old_rec.attribute17;
673: End If;
674: If (p_rec.attribute18 = hr_api.g_varchar2) then
675: p_rec.attribute18 :=
676: per_raa_shd.g_old_rec.attribute18;
677: End If;
678: If (p_rec.attribute19 = hr_api.g_varchar2) then
679: p_rec.attribute19 :=
680: per_raa_shd.g_old_rec.attribute19;
676: per_raa_shd.g_old_rec.attribute18;
677: End If;
678: If (p_rec.attribute19 = hr_api.g_varchar2) then
679: p_rec.attribute19 :=
680: per_raa_shd.g_old_rec.attribute19;
681: End If;
682: If (p_rec.attribute20 = hr_api.g_varchar2) then
683: p_rec.attribute20 :=
684: per_raa_shd.g_old_rec.attribute20;
680: per_raa_shd.g_old_rec.attribute19;
681: End If;
682: If (p_rec.attribute20 = hr_api.g_varchar2) then
683: p_rec.attribute20 :=
684: per_raa_shd.g_old_rec.attribute20;
685: End If;
686: If (p_rec.posting_content_id = hr_api.g_number) then
687: p_rec.posting_content_id :=
688: per_raa_shd.g_old_rec.posting_content_id;
684: per_raa_shd.g_old_rec.attribute20;
685: End If;
686: If (p_rec.posting_content_id = hr_api.g_number) then
687: p_rec.posting_content_id :=
688: per_raa_shd.g_old_rec.posting_content_id;
689: End If;
690: If (p_rec.status = hr_api.g_varchar2) then
691: p_rec.status :=
692: per_raa_shd.g_old_rec.status;
688: per_raa_shd.g_old_rec.posting_content_id;
689: End If;
690: If (p_rec.status = hr_api.g_varchar2) then
691: p_rec.status :=
692: per_raa_shd.g_old_rec.status;
693: End If;
694: --
695: End convert_defs;
696: --
697: -- ----------------------------------------------------------------------------
698: -- |---------------------------------< upd >----------------------------------|
699: -- ----------------------------------------------------------------------------
700: Procedure upd
701: (p_rec in out nocopy per_raa_shd.g_rec_type
702: ) is
703: --
704: l_proc varchar2(72) := g_package||'upd';
705: --
707: hr_utility.set_location('Entering:'||l_proc, 5);
708: --
709: -- We must lock the row which we need to update.
710: --
711: per_raa_shd.lck
712: (p_rec.recruitment_activity_id
713: ,p_rec.object_version_number
714: );
715: --
798: ,p_posting_content_id in number default hr_api.g_number
799: ,p_status in varchar2 default hr_api.g_varchar2
800: ) is
801: --
802: l_rec per_raa_shd.g_rec_type;
803: l_proc varchar2(72) := g_package||'upd';
804: --
805: Begin
806: hr_utility.set_location('Entering:'||l_proc, 5);
808: -- Call conversion function to turn arguments into the
809: -- l_rec structure.
810: --
811: l_rec :=
812: per_raa_shd.convert_args
813: (p_recruitment_activity_id
814: ,p_business_group_id
815: ,p_authorising_person_id
816: ,p_run_by_organization_id