[Home] [Help]
52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy per_pat_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72) := g_package||'update_dml';
60: --
137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: --
141: per_pat_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.parent_integrity_violated Then
144: -- Parent integrity has been violated
145: --
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.parent_integrity_violated Then
144: -- Parent integrity has been violated
145: --
146: per_pat_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.unique_integrity_violated Then
149: -- Unique integrity has been violated
150: --
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.unique_integrity_violated Then
149: -- Unique integrity has been violated
150: --
151: per_pat_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When Others Then
154: --
155: Raise;
187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure pre_update
191: (p_rec in per_pat_shd.g_rec_type
192: ) is
193: --
194: l_proc varchar2(72) := g_package||'pre_update';
195: --
232: -- {End Of Comments}
233: -- ----------------------------------------------------------------------------
234: Procedure post_update
235: (p_effective_date in date
236: ,p_rec in per_pat_shd.g_rec_type
237: ) is
238: --
239: l_proc varchar2(72) := g_package||'post_update';
240: --
360: => p_rec.information19
361: ,p_information20
362: => p_rec.information20
363: ,p_allocated_checklist_id_o
364: => per_pat_shd.g_old_rec.allocated_checklist_id
365: ,p_task_name_o
366: => per_pat_shd.g_old_rec.task_name
367: ,p_description_o
368: => per_pat_shd.g_old_rec.description
362: => p_rec.information20
363: ,p_allocated_checklist_id_o
364: => per_pat_shd.g_old_rec.allocated_checklist_id
365: ,p_task_name_o
366: => per_pat_shd.g_old_rec.task_name
367: ,p_description_o
368: => per_pat_shd.g_old_rec.description
369: ,p_performer_orig_system_o
370: => per_pat_shd.g_old_rec.performer_orig_system
364: => per_pat_shd.g_old_rec.allocated_checklist_id
365: ,p_task_name_o
366: => per_pat_shd.g_old_rec.task_name
367: ,p_description_o
368: => per_pat_shd.g_old_rec.description
369: ,p_performer_orig_system_o
370: => per_pat_shd.g_old_rec.performer_orig_system
371: ,p_performer_orig_sys_id_o
372: => per_pat_shd.g_old_rec.performer_orig_sys_id
366: => per_pat_shd.g_old_rec.task_name
367: ,p_description_o
368: => per_pat_shd.g_old_rec.description
369: ,p_performer_orig_system_o
370: => per_pat_shd.g_old_rec.performer_orig_system
371: ,p_performer_orig_sys_id_o
372: => per_pat_shd.g_old_rec.performer_orig_sys_id
373: ,p_task_owner_person_id_o
374: => per_pat_shd.g_old_rec.task_owner_person_id
368: => per_pat_shd.g_old_rec.description
369: ,p_performer_orig_system_o
370: => per_pat_shd.g_old_rec.performer_orig_system
371: ,p_performer_orig_sys_id_o
372: => per_pat_shd.g_old_rec.performer_orig_sys_id
373: ,p_task_owner_person_id_o
374: => per_pat_shd.g_old_rec.task_owner_person_id
375: ,p_task_sequence_o
376: => per_pat_shd.g_old_rec.task_sequence
370: => per_pat_shd.g_old_rec.performer_orig_system
371: ,p_performer_orig_sys_id_o
372: => per_pat_shd.g_old_rec.performer_orig_sys_id
373: ,p_task_owner_person_id_o
374: => per_pat_shd.g_old_rec.task_owner_person_id
375: ,p_task_sequence_o
376: => per_pat_shd.g_old_rec.task_sequence
377: ,p_target_start_date_o
378: => per_pat_shd.g_old_rec.target_start_date
372: => per_pat_shd.g_old_rec.performer_orig_sys_id
373: ,p_task_owner_person_id_o
374: => per_pat_shd.g_old_rec.task_owner_person_id
375: ,p_task_sequence_o
376: => per_pat_shd.g_old_rec.task_sequence
377: ,p_target_start_date_o
378: => per_pat_shd.g_old_rec.target_start_date
379: ,p_target_end_date_o
380: => per_pat_shd.g_old_rec.target_end_date
374: => per_pat_shd.g_old_rec.task_owner_person_id
375: ,p_task_sequence_o
376: => per_pat_shd.g_old_rec.task_sequence
377: ,p_target_start_date_o
378: => per_pat_shd.g_old_rec.target_start_date
379: ,p_target_end_date_o
380: => per_pat_shd.g_old_rec.target_end_date
381: ,p_actual_start_date_o
382: => per_pat_shd.g_old_rec.actual_start_date
376: => per_pat_shd.g_old_rec.task_sequence
377: ,p_target_start_date_o
378: => per_pat_shd.g_old_rec.target_start_date
379: ,p_target_end_date_o
380: => per_pat_shd.g_old_rec.target_end_date
381: ,p_actual_start_date_o
382: => per_pat_shd.g_old_rec.actual_start_date
383: ,p_actual_end_date_o
384: => per_pat_shd.g_old_rec.actual_end_date
378: => per_pat_shd.g_old_rec.target_start_date
379: ,p_target_end_date_o
380: => per_pat_shd.g_old_rec.target_end_date
381: ,p_actual_start_date_o
382: => per_pat_shd.g_old_rec.actual_start_date
383: ,p_actual_end_date_o
384: => per_pat_shd.g_old_rec.actual_end_date
385: ,p_action_url_o
386: => per_pat_shd.g_old_rec.action_url
380: => per_pat_shd.g_old_rec.target_end_date
381: ,p_actual_start_date_o
382: => per_pat_shd.g_old_rec.actual_start_date
383: ,p_actual_end_date_o
384: => per_pat_shd.g_old_rec.actual_end_date
385: ,p_action_url_o
386: => per_pat_shd.g_old_rec.action_url
387: ,p_mandatory_flag_o
388: => per_pat_shd.g_old_rec.mandatory_flag
382: => per_pat_shd.g_old_rec.actual_start_date
383: ,p_actual_end_date_o
384: => per_pat_shd.g_old_rec.actual_end_date
385: ,p_action_url_o
386: => per_pat_shd.g_old_rec.action_url
387: ,p_mandatory_flag_o
388: => per_pat_shd.g_old_rec.mandatory_flag
389: ,p_status_o
390: => per_pat_shd.g_old_rec.status
384: => per_pat_shd.g_old_rec.actual_end_date
385: ,p_action_url_o
386: => per_pat_shd.g_old_rec.action_url
387: ,p_mandatory_flag_o
388: => per_pat_shd.g_old_rec.mandatory_flag
389: ,p_status_o
390: => per_pat_shd.g_old_rec.status
391: ,p_object_version_number_o
392: => per_pat_shd.g_old_rec.object_version_number
386: => per_pat_shd.g_old_rec.action_url
387: ,p_mandatory_flag_o
388: => per_pat_shd.g_old_rec.mandatory_flag
389: ,p_status_o
390: => per_pat_shd.g_old_rec.status
391: ,p_object_version_number_o
392: => per_pat_shd.g_old_rec.object_version_number
393: ,p_attribute_category_o
394: => per_pat_shd.g_old_rec.attribute_category
388: => per_pat_shd.g_old_rec.mandatory_flag
389: ,p_status_o
390: => per_pat_shd.g_old_rec.status
391: ,p_object_version_number_o
392: => per_pat_shd.g_old_rec.object_version_number
393: ,p_attribute_category_o
394: => per_pat_shd.g_old_rec.attribute_category
395: ,p_attribute1_o
396: => per_pat_shd.g_old_rec.attribute1
390: => per_pat_shd.g_old_rec.status
391: ,p_object_version_number_o
392: => per_pat_shd.g_old_rec.object_version_number
393: ,p_attribute_category_o
394: => per_pat_shd.g_old_rec.attribute_category
395: ,p_attribute1_o
396: => per_pat_shd.g_old_rec.attribute1
397: ,p_attribute2_o
398: => per_pat_shd.g_old_rec.attribute2
392: => per_pat_shd.g_old_rec.object_version_number
393: ,p_attribute_category_o
394: => per_pat_shd.g_old_rec.attribute_category
395: ,p_attribute1_o
396: => per_pat_shd.g_old_rec.attribute1
397: ,p_attribute2_o
398: => per_pat_shd.g_old_rec.attribute2
399: ,p_attribute3_o
400: => per_pat_shd.g_old_rec.attribute3
394: => per_pat_shd.g_old_rec.attribute_category
395: ,p_attribute1_o
396: => per_pat_shd.g_old_rec.attribute1
397: ,p_attribute2_o
398: => per_pat_shd.g_old_rec.attribute2
399: ,p_attribute3_o
400: => per_pat_shd.g_old_rec.attribute3
401: ,p_attribute4_o
402: => per_pat_shd.g_old_rec.attribute4
396: => per_pat_shd.g_old_rec.attribute1
397: ,p_attribute2_o
398: => per_pat_shd.g_old_rec.attribute2
399: ,p_attribute3_o
400: => per_pat_shd.g_old_rec.attribute3
401: ,p_attribute4_o
402: => per_pat_shd.g_old_rec.attribute4
403: ,p_attribute5_o
404: => per_pat_shd.g_old_rec.attribute5
398: => per_pat_shd.g_old_rec.attribute2
399: ,p_attribute3_o
400: => per_pat_shd.g_old_rec.attribute3
401: ,p_attribute4_o
402: => per_pat_shd.g_old_rec.attribute4
403: ,p_attribute5_o
404: => per_pat_shd.g_old_rec.attribute5
405: ,p_attribute6_o
406: => per_pat_shd.g_old_rec.attribute6
400: => per_pat_shd.g_old_rec.attribute3
401: ,p_attribute4_o
402: => per_pat_shd.g_old_rec.attribute4
403: ,p_attribute5_o
404: => per_pat_shd.g_old_rec.attribute5
405: ,p_attribute6_o
406: => per_pat_shd.g_old_rec.attribute6
407: ,p_attribute7_o
408: => per_pat_shd.g_old_rec.attribute7
402: => per_pat_shd.g_old_rec.attribute4
403: ,p_attribute5_o
404: => per_pat_shd.g_old_rec.attribute5
405: ,p_attribute6_o
406: => per_pat_shd.g_old_rec.attribute6
407: ,p_attribute7_o
408: => per_pat_shd.g_old_rec.attribute7
409: ,p_attribute8_o
410: => per_pat_shd.g_old_rec.attribute8
404: => per_pat_shd.g_old_rec.attribute5
405: ,p_attribute6_o
406: => per_pat_shd.g_old_rec.attribute6
407: ,p_attribute7_o
408: => per_pat_shd.g_old_rec.attribute7
409: ,p_attribute8_o
410: => per_pat_shd.g_old_rec.attribute8
411: ,p_attribute9_o
412: => per_pat_shd.g_old_rec.attribute9
406: => per_pat_shd.g_old_rec.attribute6
407: ,p_attribute7_o
408: => per_pat_shd.g_old_rec.attribute7
409: ,p_attribute8_o
410: => per_pat_shd.g_old_rec.attribute8
411: ,p_attribute9_o
412: => per_pat_shd.g_old_rec.attribute9
413: ,p_attribute10_o
414: => per_pat_shd.g_old_rec.attribute10
408: => per_pat_shd.g_old_rec.attribute7
409: ,p_attribute8_o
410: => per_pat_shd.g_old_rec.attribute8
411: ,p_attribute9_o
412: => per_pat_shd.g_old_rec.attribute9
413: ,p_attribute10_o
414: => per_pat_shd.g_old_rec.attribute10
415: ,p_attribute11_o
416: => per_pat_shd.g_old_rec.attribute11
410: => per_pat_shd.g_old_rec.attribute8
411: ,p_attribute9_o
412: => per_pat_shd.g_old_rec.attribute9
413: ,p_attribute10_o
414: => per_pat_shd.g_old_rec.attribute10
415: ,p_attribute11_o
416: => per_pat_shd.g_old_rec.attribute11
417: ,p_attribute12_o
418: => per_pat_shd.g_old_rec.attribute12
412: => per_pat_shd.g_old_rec.attribute9
413: ,p_attribute10_o
414: => per_pat_shd.g_old_rec.attribute10
415: ,p_attribute11_o
416: => per_pat_shd.g_old_rec.attribute11
417: ,p_attribute12_o
418: => per_pat_shd.g_old_rec.attribute12
419: ,p_attribute13_o
420: => per_pat_shd.g_old_rec.attribute13
414: => per_pat_shd.g_old_rec.attribute10
415: ,p_attribute11_o
416: => per_pat_shd.g_old_rec.attribute11
417: ,p_attribute12_o
418: => per_pat_shd.g_old_rec.attribute12
419: ,p_attribute13_o
420: => per_pat_shd.g_old_rec.attribute13
421: ,p_attribute14_o
422: => per_pat_shd.g_old_rec.attribute14
416: => per_pat_shd.g_old_rec.attribute11
417: ,p_attribute12_o
418: => per_pat_shd.g_old_rec.attribute12
419: ,p_attribute13_o
420: => per_pat_shd.g_old_rec.attribute13
421: ,p_attribute14_o
422: => per_pat_shd.g_old_rec.attribute14
423: ,p_attribute15_o
424: => per_pat_shd.g_old_rec.attribute15
418: => per_pat_shd.g_old_rec.attribute12
419: ,p_attribute13_o
420: => per_pat_shd.g_old_rec.attribute13
421: ,p_attribute14_o
422: => per_pat_shd.g_old_rec.attribute14
423: ,p_attribute15_o
424: => per_pat_shd.g_old_rec.attribute15
425: ,p_attribute16_o
426: => per_pat_shd.g_old_rec.attribute16
420: => per_pat_shd.g_old_rec.attribute13
421: ,p_attribute14_o
422: => per_pat_shd.g_old_rec.attribute14
423: ,p_attribute15_o
424: => per_pat_shd.g_old_rec.attribute15
425: ,p_attribute16_o
426: => per_pat_shd.g_old_rec.attribute16
427: ,p_attribute17_o
428: => per_pat_shd.g_old_rec.attribute17
422: => per_pat_shd.g_old_rec.attribute14
423: ,p_attribute15_o
424: => per_pat_shd.g_old_rec.attribute15
425: ,p_attribute16_o
426: => per_pat_shd.g_old_rec.attribute16
427: ,p_attribute17_o
428: => per_pat_shd.g_old_rec.attribute17
429: ,p_attribute18_o
430: => per_pat_shd.g_old_rec.attribute18
424: => per_pat_shd.g_old_rec.attribute15
425: ,p_attribute16_o
426: => per_pat_shd.g_old_rec.attribute16
427: ,p_attribute17_o
428: => per_pat_shd.g_old_rec.attribute17
429: ,p_attribute18_o
430: => per_pat_shd.g_old_rec.attribute18
431: ,p_attribute19_o
432: => per_pat_shd.g_old_rec.attribute19
426: => per_pat_shd.g_old_rec.attribute16
427: ,p_attribute17_o
428: => per_pat_shd.g_old_rec.attribute17
429: ,p_attribute18_o
430: => per_pat_shd.g_old_rec.attribute18
431: ,p_attribute19_o
432: => per_pat_shd.g_old_rec.attribute19
433: ,p_attribute20_o
434: => per_pat_shd.g_old_rec.attribute20
428: => per_pat_shd.g_old_rec.attribute17
429: ,p_attribute18_o
430: => per_pat_shd.g_old_rec.attribute18
431: ,p_attribute19_o
432: => per_pat_shd.g_old_rec.attribute19
433: ,p_attribute20_o
434: => per_pat_shd.g_old_rec.attribute20
435: ,p_information_category_o
436: => per_pat_shd.g_old_rec.information_category
430: => per_pat_shd.g_old_rec.attribute18
431: ,p_attribute19_o
432: => per_pat_shd.g_old_rec.attribute19
433: ,p_attribute20_o
434: => per_pat_shd.g_old_rec.attribute20
435: ,p_information_category_o
436: => per_pat_shd.g_old_rec.information_category
437: ,p_information1_o
438: => per_pat_shd.g_old_rec.information1
432: => per_pat_shd.g_old_rec.attribute19
433: ,p_attribute20_o
434: => per_pat_shd.g_old_rec.attribute20
435: ,p_information_category_o
436: => per_pat_shd.g_old_rec.information_category
437: ,p_information1_o
438: => per_pat_shd.g_old_rec.information1
439: ,p_information2_o
440: => per_pat_shd.g_old_rec.information2
434: => per_pat_shd.g_old_rec.attribute20
435: ,p_information_category_o
436: => per_pat_shd.g_old_rec.information_category
437: ,p_information1_o
438: => per_pat_shd.g_old_rec.information1
439: ,p_information2_o
440: => per_pat_shd.g_old_rec.information2
441: ,p_information3_o
442: => per_pat_shd.g_old_rec.information3
436: => per_pat_shd.g_old_rec.information_category
437: ,p_information1_o
438: => per_pat_shd.g_old_rec.information1
439: ,p_information2_o
440: => per_pat_shd.g_old_rec.information2
441: ,p_information3_o
442: => per_pat_shd.g_old_rec.information3
443: ,p_information4_o
444: => per_pat_shd.g_old_rec.information4
438: => per_pat_shd.g_old_rec.information1
439: ,p_information2_o
440: => per_pat_shd.g_old_rec.information2
441: ,p_information3_o
442: => per_pat_shd.g_old_rec.information3
443: ,p_information4_o
444: => per_pat_shd.g_old_rec.information4
445: ,p_information5_o
446: => per_pat_shd.g_old_rec.information5
440: => per_pat_shd.g_old_rec.information2
441: ,p_information3_o
442: => per_pat_shd.g_old_rec.information3
443: ,p_information4_o
444: => per_pat_shd.g_old_rec.information4
445: ,p_information5_o
446: => per_pat_shd.g_old_rec.information5
447: ,p_information6_o
448: => per_pat_shd.g_old_rec.information6
442: => per_pat_shd.g_old_rec.information3
443: ,p_information4_o
444: => per_pat_shd.g_old_rec.information4
445: ,p_information5_o
446: => per_pat_shd.g_old_rec.information5
447: ,p_information6_o
448: => per_pat_shd.g_old_rec.information6
449: ,p_information7_o
450: => per_pat_shd.g_old_rec.information7
444: => per_pat_shd.g_old_rec.information4
445: ,p_information5_o
446: => per_pat_shd.g_old_rec.information5
447: ,p_information6_o
448: => per_pat_shd.g_old_rec.information6
449: ,p_information7_o
450: => per_pat_shd.g_old_rec.information7
451: ,p_information8_o
452: => per_pat_shd.g_old_rec.information8
446: => per_pat_shd.g_old_rec.information5
447: ,p_information6_o
448: => per_pat_shd.g_old_rec.information6
449: ,p_information7_o
450: => per_pat_shd.g_old_rec.information7
451: ,p_information8_o
452: => per_pat_shd.g_old_rec.information8
453: ,p_information9_o
454: => per_pat_shd.g_old_rec.information9
448: => per_pat_shd.g_old_rec.information6
449: ,p_information7_o
450: => per_pat_shd.g_old_rec.information7
451: ,p_information8_o
452: => per_pat_shd.g_old_rec.information8
453: ,p_information9_o
454: => per_pat_shd.g_old_rec.information9
455: ,p_information10_o
456: => per_pat_shd.g_old_rec.information10
450: => per_pat_shd.g_old_rec.information7
451: ,p_information8_o
452: => per_pat_shd.g_old_rec.information8
453: ,p_information9_o
454: => per_pat_shd.g_old_rec.information9
455: ,p_information10_o
456: => per_pat_shd.g_old_rec.information10
457: ,p_information11_o
458: => per_pat_shd.g_old_rec.information11
452: => per_pat_shd.g_old_rec.information8
453: ,p_information9_o
454: => per_pat_shd.g_old_rec.information9
455: ,p_information10_o
456: => per_pat_shd.g_old_rec.information10
457: ,p_information11_o
458: => per_pat_shd.g_old_rec.information11
459: ,p_information12_o
460: => per_pat_shd.g_old_rec.information12
454: => per_pat_shd.g_old_rec.information9
455: ,p_information10_o
456: => per_pat_shd.g_old_rec.information10
457: ,p_information11_o
458: => per_pat_shd.g_old_rec.information11
459: ,p_information12_o
460: => per_pat_shd.g_old_rec.information12
461: ,p_information13_o
462: => per_pat_shd.g_old_rec.information13
456: => per_pat_shd.g_old_rec.information10
457: ,p_information11_o
458: => per_pat_shd.g_old_rec.information11
459: ,p_information12_o
460: => per_pat_shd.g_old_rec.information12
461: ,p_information13_o
462: => per_pat_shd.g_old_rec.information13
463: ,p_information14_o
464: => per_pat_shd.g_old_rec.information14
458: => per_pat_shd.g_old_rec.information11
459: ,p_information12_o
460: => per_pat_shd.g_old_rec.information12
461: ,p_information13_o
462: => per_pat_shd.g_old_rec.information13
463: ,p_information14_o
464: => per_pat_shd.g_old_rec.information14
465: ,p_information15_o
466: => per_pat_shd.g_old_rec.information15
460: => per_pat_shd.g_old_rec.information12
461: ,p_information13_o
462: => per_pat_shd.g_old_rec.information13
463: ,p_information14_o
464: => per_pat_shd.g_old_rec.information14
465: ,p_information15_o
466: => per_pat_shd.g_old_rec.information15
467: ,p_information16_o
468: => per_pat_shd.g_old_rec.information16
462: => per_pat_shd.g_old_rec.information13
463: ,p_information14_o
464: => per_pat_shd.g_old_rec.information14
465: ,p_information15_o
466: => per_pat_shd.g_old_rec.information15
467: ,p_information16_o
468: => per_pat_shd.g_old_rec.information16
469: ,p_information17_o
470: => per_pat_shd.g_old_rec.information17
464: => per_pat_shd.g_old_rec.information14
465: ,p_information15_o
466: => per_pat_shd.g_old_rec.information15
467: ,p_information16_o
468: => per_pat_shd.g_old_rec.information16
469: ,p_information17_o
470: => per_pat_shd.g_old_rec.information17
471: ,p_information18_o
472: => per_pat_shd.g_old_rec.information18
466: => per_pat_shd.g_old_rec.information15
467: ,p_information16_o
468: => per_pat_shd.g_old_rec.information16
469: ,p_information17_o
470: => per_pat_shd.g_old_rec.information17
471: ,p_information18_o
472: => per_pat_shd.g_old_rec.information18
473: ,p_information19_o
474: => per_pat_shd.g_old_rec.information19
468: => per_pat_shd.g_old_rec.information16
469: ,p_information17_o
470: => per_pat_shd.g_old_rec.information17
471: ,p_information18_o
472: => per_pat_shd.g_old_rec.information18
473: ,p_information19_o
474: => per_pat_shd.g_old_rec.information19
475: ,p_information20_o
476: => per_pat_shd.g_old_rec.information20
470: => per_pat_shd.g_old_rec.information17
471: ,p_information18_o
472: => per_pat_shd.g_old_rec.information18
473: ,p_information19_o
474: => per_pat_shd.g_old_rec.information19
475: ,p_information20_o
476: => per_pat_shd.g_old_rec.information20
477: );
478: --
472: => per_pat_shd.g_old_rec.information18
473: ,p_information19_o
474: => per_pat_shd.g_old_rec.information19
475: ,p_information20_o
476: => per_pat_shd.g_old_rec.information20
477: );
478: --
479: exception
480: --
532: --
533: -- {End Of Comments}
534: -- ----------------------------------------------------------------------------
535: Procedure convert_defs
536: (p_rec in out nocopy per_pat_shd.g_rec_type
537: ) is
538: --
539: Begin
540: --
544: -- is being used then we must set to the 'current' argument value.
545: --
546: If (p_rec.allocated_checklist_id = hr_api.g_number) then
547: p_rec.allocated_checklist_id :=
548: per_pat_shd.g_old_rec.allocated_checklist_id;
549: End If;
550: If (p_rec.task_name = hr_api.g_varchar2) then
551: p_rec.task_name :=
552: per_pat_shd.g_old_rec.task_name;
548: per_pat_shd.g_old_rec.allocated_checklist_id;
549: End If;
550: If (p_rec.task_name = hr_api.g_varchar2) then
551: p_rec.task_name :=
552: per_pat_shd.g_old_rec.task_name;
553: End If;
554: If (p_rec.description = hr_api.g_varchar2) then
555: p_rec.description :=
556: per_pat_shd.g_old_rec.description;
552: per_pat_shd.g_old_rec.task_name;
553: End If;
554: If (p_rec.description = hr_api.g_varchar2) then
555: p_rec.description :=
556: per_pat_shd.g_old_rec.description;
557: End If;
558: If (p_rec.performer_orig_system = hr_api.g_varchar2) then
559: p_rec.performer_orig_system :=
560: per_pat_shd.g_old_rec.performer_orig_system;
556: per_pat_shd.g_old_rec.description;
557: End If;
558: If (p_rec.performer_orig_system = hr_api.g_varchar2) then
559: p_rec.performer_orig_system :=
560: per_pat_shd.g_old_rec.performer_orig_system;
561: End If;
562: If (p_rec.performer_orig_sys_id = hr_api.g_number) then
563: p_rec.performer_orig_sys_id :=
564: per_pat_shd.g_old_rec.performer_orig_sys_id;
560: per_pat_shd.g_old_rec.performer_orig_system;
561: End If;
562: If (p_rec.performer_orig_sys_id = hr_api.g_number) then
563: p_rec.performer_orig_sys_id :=
564: per_pat_shd.g_old_rec.performer_orig_sys_id;
565: End If;
566: If (p_rec.task_owner_person_id = hr_api.g_number) then
567: p_rec.task_owner_person_id :=
568: per_pat_shd.g_old_rec.task_owner_person_id;
564: per_pat_shd.g_old_rec.performer_orig_sys_id;
565: End If;
566: If (p_rec.task_owner_person_id = hr_api.g_number) then
567: p_rec.task_owner_person_id :=
568: per_pat_shd.g_old_rec.task_owner_person_id;
569: End If;
570: If (p_rec.task_sequence = hr_api.g_number) then
571: p_rec.task_sequence :=
572: per_pat_shd.g_old_rec.task_sequence;
568: per_pat_shd.g_old_rec.task_owner_person_id;
569: End If;
570: If (p_rec.task_sequence = hr_api.g_number) then
571: p_rec.task_sequence :=
572: per_pat_shd.g_old_rec.task_sequence;
573: End If;
574: If (p_rec.target_start_date = hr_api.g_date) then
575: p_rec.target_start_date :=
576: per_pat_shd.g_old_rec.target_start_date;
572: per_pat_shd.g_old_rec.task_sequence;
573: End If;
574: If (p_rec.target_start_date = hr_api.g_date) then
575: p_rec.target_start_date :=
576: per_pat_shd.g_old_rec.target_start_date;
577: End If;
578: If (p_rec.target_end_date = hr_api.g_date) then
579: p_rec.target_end_date :=
580: per_pat_shd.g_old_rec.target_end_date;
576: per_pat_shd.g_old_rec.target_start_date;
577: End If;
578: If (p_rec.target_end_date = hr_api.g_date) then
579: p_rec.target_end_date :=
580: per_pat_shd.g_old_rec.target_end_date;
581: End If;
582: If (p_rec.actual_start_date = hr_api.g_date) then
583: p_rec.actual_start_date :=
584: per_pat_shd.g_old_rec.actual_start_date;
580: per_pat_shd.g_old_rec.target_end_date;
581: End If;
582: If (p_rec.actual_start_date = hr_api.g_date) then
583: p_rec.actual_start_date :=
584: per_pat_shd.g_old_rec.actual_start_date;
585: End If;
586: If (p_rec.actual_end_date = hr_api.g_date) then
587: p_rec.actual_end_date :=
588: per_pat_shd.g_old_rec.actual_end_date;
584: per_pat_shd.g_old_rec.actual_start_date;
585: End If;
586: If (p_rec.actual_end_date = hr_api.g_date) then
587: p_rec.actual_end_date :=
588: per_pat_shd.g_old_rec.actual_end_date;
589: End If;
590: If (p_rec.action_url = hr_api.g_varchar2) then
591: p_rec.action_url :=
592: per_pat_shd.g_old_rec.action_url;
588: per_pat_shd.g_old_rec.actual_end_date;
589: End If;
590: If (p_rec.action_url = hr_api.g_varchar2) then
591: p_rec.action_url :=
592: per_pat_shd.g_old_rec.action_url;
593: End If;
594: If (p_rec.mandatory_flag = hr_api.g_varchar2) then
595: p_rec.mandatory_flag :=
596: per_pat_shd.g_old_rec.mandatory_flag;
592: per_pat_shd.g_old_rec.action_url;
593: End If;
594: If (p_rec.mandatory_flag = hr_api.g_varchar2) then
595: p_rec.mandatory_flag :=
596: per_pat_shd.g_old_rec.mandatory_flag;
597: End If;
598: If (p_rec.status = hr_api.g_varchar2) then
599: p_rec.status :=
600: per_pat_shd.g_old_rec.status;
596: per_pat_shd.g_old_rec.mandatory_flag;
597: End If;
598: If (p_rec.status = hr_api.g_varchar2) then
599: p_rec.status :=
600: per_pat_shd.g_old_rec.status;
601: End If;
602: If (p_rec.attribute_category = hr_api.g_varchar2) then
603: p_rec.attribute_category :=
604: per_pat_shd.g_old_rec.attribute_category;
600: per_pat_shd.g_old_rec.status;
601: End If;
602: If (p_rec.attribute_category = hr_api.g_varchar2) then
603: p_rec.attribute_category :=
604: per_pat_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_pat_shd.g_old_rec.attribute1;
604: per_pat_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_pat_shd.g_old_rec.attribute1;
609: End If;
610: If (p_rec.attribute2 = hr_api.g_varchar2) then
611: p_rec.attribute2 :=
612: per_pat_shd.g_old_rec.attribute2;
608: per_pat_shd.g_old_rec.attribute1;
609: End If;
610: If (p_rec.attribute2 = hr_api.g_varchar2) then
611: p_rec.attribute2 :=
612: per_pat_shd.g_old_rec.attribute2;
613: End If;
614: If (p_rec.attribute3 = hr_api.g_varchar2) then
615: p_rec.attribute3 :=
616: per_pat_shd.g_old_rec.attribute3;
612: per_pat_shd.g_old_rec.attribute2;
613: End If;
614: If (p_rec.attribute3 = hr_api.g_varchar2) then
615: p_rec.attribute3 :=
616: per_pat_shd.g_old_rec.attribute3;
617: End If;
618: If (p_rec.attribute4 = hr_api.g_varchar2) then
619: p_rec.attribute4 :=
620: per_pat_shd.g_old_rec.attribute4;
616: per_pat_shd.g_old_rec.attribute3;
617: End If;
618: If (p_rec.attribute4 = hr_api.g_varchar2) then
619: p_rec.attribute4 :=
620: per_pat_shd.g_old_rec.attribute4;
621: End If;
622: If (p_rec.attribute5 = hr_api.g_varchar2) then
623: p_rec.attribute5 :=
624: per_pat_shd.g_old_rec.attribute5;
620: per_pat_shd.g_old_rec.attribute4;
621: End If;
622: If (p_rec.attribute5 = hr_api.g_varchar2) then
623: p_rec.attribute5 :=
624: per_pat_shd.g_old_rec.attribute5;
625: End If;
626: If (p_rec.attribute6 = hr_api.g_varchar2) then
627: p_rec.attribute6 :=
628: per_pat_shd.g_old_rec.attribute6;
624: per_pat_shd.g_old_rec.attribute5;
625: End If;
626: If (p_rec.attribute6 = hr_api.g_varchar2) then
627: p_rec.attribute6 :=
628: per_pat_shd.g_old_rec.attribute6;
629: End If;
630: If (p_rec.attribute7 = hr_api.g_varchar2) then
631: p_rec.attribute7 :=
632: per_pat_shd.g_old_rec.attribute7;
628: per_pat_shd.g_old_rec.attribute6;
629: End If;
630: If (p_rec.attribute7 = hr_api.g_varchar2) then
631: p_rec.attribute7 :=
632: per_pat_shd.g_old_rec.attribute7;
633: End If;
634: If (p_rec.attribute8 = hr_api.g_varchar2) then
635: p_rec.attribute8 :=
636: per_pat_shd.g_old_rec.attribute8;
632: per_pat_shd.g_old_rec.attribute7;
633: End If;
634: If (p_rec.attribute8 = hr_api.g_varchar2) then
635: p_rec.attribute8 :=
636: per_pat_shd.g_old_rec.attribute8;
637: End If;
638: If (p_rec.attribute9 = hr_api.g_varchar2) then
639: p_rec.attribute9 :=
640: per_pat_shd.g_old_rec.attribute9;
636: per_pat_shd.g_old_rec.attribute8;
637: End If;
638: If (p_rec.attribute9 = hr_api.g_varchar2) then
639: p_rec.attribute9 :=
640: per_pat_shd.g_old_rec.attribute9;
641: End If;
642: If (p_rec.attribute10 = hr_api.g_varchar2) then
643: p_rec.attribute10 :=
644: per_pat_shd.g_old_rec.attribute10;
640: per_pat_shd.g_old_rec.attribute9;
641: End If;
642: If (p_rec.attribute10 = hr_api.g_varchar2) then
643: p_rec.attribute10 :=
644: per_pat_shd.g_old_rec.attribute10;
645: End If;
646: If (p_rec.attribute11 = hr_api.g_varchar2) then
647: p_rec.attribute11 :=
648: per_pat_shd.g_old_rec.attribute11;
644: per_pat_shd.g_old_rec.attribute10;
645: End If;
646: If (p_rec.attribute11 = hr_api.g_varchar2) then
647: p_rec.attribute11 :=
648: per_pat_shd.g_old_rec.attribute11;
649: End If;
650: If (p_rec.attribute12 = hr_api.g_varchar2) then
651: p_rec.attribute12 :=
652: per_pat_shd.g_old_rec.attribute12;
648: per_pat_shd.g_old_rec.attribute11;
649: End If;
650: If (p_rec.attribute12 = hr_api.g_varchar2) then
651: p_rec.attribute12 :=
652: per_pat_shd.g_old_rec.attribute12;
653: End If;
654: If (p_rec.attribute13 = hr_api.g_varchar2) then
655: p_rec.attribute13 :=
656: per_pat_shd.g_old_rec.attribute13;
652: per_pat_shd.g_old_rec.attribute12;
653: End If;
654: If (p_rec.attribute13 = hr_api.g_varchar2) then
655: p_rec.attribute13 :=
656: per_pat_shd.g_old_rec.attribute13;
657: End If;
658: If (p_rec.attribute14 = hr_api.g_varchar2) then
659: p_rec.attribute14 :=
660: per_pat_shd.g_old_rec.attribute14;
656: per_pat_shd.g_old_rec.attribute13;
657: End If;
658: If (p_rec.attribute14 = hr_api.g_varchar2) then
659: p_rec.attribute14 :=
660: per_pat_shd.g_old_rec.attribute14;
661: End If;
662: If (p_rec.attribute15 = hr_api.g_varchar2) then
663: p_rec.attribute15 :=
664: per_pat_shd.g_old_rec.attribute15;
660: per_pat_shd.g_old_rec.attribute14;
661: End If;
662: If (p_rec.attribute15 = hr_api.g_varchar2) then
663: p_rec.attribute15 :=
664: per_pat_shd.g_old_rec.attribute15;
665: End If;
666: If (p_rec.attribute16 = hr_api.g_varchar2) then
667: p_rec.attribute16 :=
668: per_pat_shd.g_old_rec.attribute16;
664: per_pat_shd.g_old_rec.attribute15;
665: End If;
666: If (p_rec.attribute16 = hr_api.g_varchar2) then
667: p_rec.attribute16 :=
668: per_pat_shd.g_old_rec.attribute16;
669: End If;
670: If (p_rec.attribute17 = hr_api.g_varchar2) then
671: p_rec.attribute17 :=
672: per_pat_shd.g_old_rec.attribute17;
668: per_pat_shd.g_old_rec.attribute16;
669: End If;
670: If (p_rec.attribute17 = hr_api.g_varchar2) then
671: p_rec.attribute17 :=
672: per_pat_shd.g_old_rec.attribute17;
673: End If;
674: If (p_rec.attribute18 = hr_api.g_varchar2) then
675: p_rec.attribute18 :=
676: per_pat_shd.g_old_rec.attribute18;
672: per_pat_shd.g_old_rec.attribute17;
673: End If;
674: If (p_rec.attribute18 = hr_api.g_varchar2) then
675: p_rec.attribute18 :=
676: per_pat_shd.g_old_rec.attribute18;
677: End If;
678: If (p_rec.attribute19 = hr_api.g_varchar2) then
679: p_rec.attribute19 :=
680: per_pat_shd.g_old_rec.attribute19;
676: per_pat_shd.g_old_rec.attribute18;
677: End If;
678: If (p_rec.attribute19 = hr_api.g_varchar2) then
679: p_rec.attribute19 :=
680: per_pat_shd.g_old_rec.attribute19;
681: End If;
682: If (p_rec.attribute20 = hr_api.g_varchar2) then
683: p_rec.attribute20 :=
684: per_pat_shd.g_old_rec.attribute20;
680: per_pat_shd.g_old_rec.attribute19;
681: End If;
682: If (p_rec.attribute20 = hr_api.g_varchar2) then
683: p_rec.attribute20 :=
684: per_pat_shd.g_old_rec.attribute20;
685: End If;
686: If (p_rec.information_category = hr_api.g_varchar2) then
687: p_rec.information_category :=
688: per_pat_shd.g_old_rec.information_category;
684: per_pat_shd.g_old_rec.attribute20;
685: End If;
686: If (p_rec.information_category = hr_api.g_varchar2) then
687: p_rec.information_category :=
688: per_pat_shd.g_old_rec.information_category;
689: End If;
690: If (p_rec.information1 = hr_api.g_varchar2) then
691: p_rec.information1 :=
692: per_pat_shd.g_old_rec.information1;
688: per_pat_shd.g_old_rec.information_category;
689: End If;
690: If (p_rec.information1 = hr_api.g_varchar2) then
691: p_rec.information1 :=
692: per_pat_shd.g_old_rec.information1;
693: End If;
694: If (p_rec.information2 = hr_api.g_varchar2) then
695: p_rec.information2 :=
696: per_pat_shd.g_old_rec.information2;
692: per_pat_shd.g_old_rec.information1;
693: End If;
694: If (p_rec.information2 = hr_api.g_varchar2) then
695: p_rec.information2 :=
696: per_pat_shd.g_old_rec.information2;
697: End If;
698: If (p_rec.information3 = hr_api.g_varchar2) then
699: p_rec.information3 :=
700: per_pat_shd.g_old_rec.information3;
696: per_pat_shd.g_old_rec.information2;
697: End If;
698: If (p_rec.information3 = hr_api.g_varchar2) then
699: p_rec.information3 :=
700: per_pat_shd.g_old_rec.information3;
701: End If;
702: If (p_rec.information4 = hr_api.g_varchar2) then
703: p_rec.information4 :=
704: per_pat_shd.g_old_rec.information4;
700: per_pat_shd.g_old_rec.information3;
701: End If;
702: If (p_rec.information4 = hr_api.g_varchar2) then
703: p_rec.information4 :=
704: per_pat_shd.g_old_rec.information4;
705: End If;
706: If (p_rec.information5 = hr_api.g_varchar2) then
707: p_rec.information5 :=
708: per_pat_shd.g_old_rec.information5;
704: per_pat_shd.g_old_rec.information4;
705: End If;
706: If (p_rec.information5 = hr_api.g_varchar2) then
707: p_rec.information5 :=
708: per_pat_shd.g_old_rec.information5;
709: End If;
710: If (p_rec.information6 = hr_api.g_varchar2) then
711: p_rec.information6 :=
712: per_pat_shd.g_old_rec.information6;
708: per_pat_shd.g_old_rec.information5;
709: End If;
710: If (p_rec.information6 = hr_api.g_varchar2) then
711: p_rec.information6 :=
712: per_pat_shd.g_old_rec.information6;
713: End If;
714: If (p_rec.information7 = hr_api.g_varchar2) then
715: p_rec.information7 :=
716: per_pat_shd.g_old_rec.information7;
712: per_pat_shd.g_old_rec.information6;
713: End If;
714: If (p_rec.information7 = hr_api.g_varchar2) then
715: p_rec.information7 :=
716: per_pat_shd.g_old_rec.information7;
717: End If;
718: If (p_rec.information8 = hr_api.g_varchar2) then
719: p_rec.information8 :=
720: per_pat_shd.g_old_rec.information8;
716: per_pat_shd.g_old_rec.information7;
717: End If;
718: If (p_rec.information8 = hr_api.g_varchar2) then
719: p_rec.information8 :=
720: per_pat_shd.g_old_rec.information8;
721: End If;
722: If (p_rec.information9 = hr_api.g_varchar2) then
723: p_rec.information9 :=
724: per_pat_shd.g_old_rec.information9;
720: per_pat_shd.g_old_rec.information8;
721: End If;
722: If (p_rec.information9 = hr_api.g_varchar2) then
723: p_rec.information9 :=
724: per_pat_shd.g_old_rec.information9;
725: End If;
726: If (p_rec.information10 = hr_api.g_varchar2) then
727: p_rec.information10 :=
728: per_pat_shd.g_old_rec.information10;
724: per_pat_shd.g_old_rec.information9;
725: End If;
726: If (p_rec.information10 = hr_api.g_varchar2) then
727: p_rec.information10 :=
728: per_pat_shd.g_old_rec.information10;
729: End If;
730: If (p_rec.information11 = hr_api.g_varchar2) then
731: p_rec.information11 :=
732: per_pat_shd.g_old_rec.information11;
728: per_pat_shd.g_old_rec.information10;
729: End If;
730: If (p_rec.information11 = hr_api.g_varchar2) then
731: p_rec.information11 :=
732: per_pat_shd.g_old_rec.information11;
733: End If;
734: If (p_rec.information12 = hr_api.g_varchar2) then
735: p_rec.information12 :=
736: per_pat_shd.g_old_rec.information12;
732: per_pat_shd.g_old_rec.information11;
733: End If;
734: If (p_rec.information12 = hr_api.g_varchar2) then
735: p_rec.information12 :=
736: per_pat_shd.g_old_rec.information12;
737: End If;
738: If (p_rec.information13 = hr_api.g_varchar2) then
739: p_rec.information13 :=
740: per_pat_shd.g_old_rec.information13;
736: per_pat_shd.g_old_rec.information12;
737: End If;
738: If (p_rec.information13 = hr_api.g_varchar2) then
739: p_rec.information13 :=
740: per_pat_shd.g_old_rec.information13;
741: End If;
742: If (p_rec.information14 = hr_api.g_varchar2) then
743: p_rec.information14 :=
744: per_pat_shd.g_old_rec.information14;
740: per_pat_shd.g_old_rec.information13;
741: End If;
742: If (p_rec.information14 = hr_api.g_varchar2) then
743: p_rec.information14 :=
744: per_pat_shd.g_old_rec.information14;
745: End If;
746: If (p_rec.information15 = hr_api.g_varchar2) then
747: p_rec.information15 :=
748: per_pat_shd.g_old_rec.information15;
744: per_pat_shd.g_old_rec.information14;
745: End If;
746: If (p_rec.information15 = hr_api.g_varchar2) then
747: p_rec.information15 :=
748: per_pat_shd.g_old_rec.information15;
749: End If;
750: If (p_rec.information16 = hr_api.g_varchar2) then
751: p_rec.information16 :=
752: per_pat_shd.g_old_rec.information16;
748: per_pat_shd.g_old_rec.information15;
749: End If;
750: If (p_rec.information16 = hr_api.g_varchar2) then
751: p_rec.information16 :=
752: per_pat_shd.g_old_rec.information16;
753: End If;
754: If (p_rec.information17 = hr_api.g_varchar2) then
755: p_rec.information17 :=
756: per_pat_shd.g_old_rec.information17;
752: per_pat_shd.g_old_rec.information16;
753: End If;
754: If (p_rec.information17 = hr_api.g_varchar2) then
755: p_rec.information17 :=
756: per_pat_shd.g_old_rec.information17;
757: End If;
758: If (p_rec.information18 = hr_api.g_varchar2) then
759: p_rec.information18 :=
760: per_pat_shd.g_old_rec.information18;
756: per_pat_shd.g_old_rec.information17;
757: End If;
758: If (p_rec.information18 = hr_api.g_varchar2) then
759: p_rec.information18 :=
760: per_pat_shd.g_old_rec.information18;
761: End If;
762: If (p_rec.information19 = hr_api.g_varchar2) then
763: p_rec.information19 :=
764: per_pat_shd.g_old_rec.information19;
760: per_pat_shd.g_old_rec.information18;
761: End If;
762: If (p_rec.information19 = hr_api.g_varchar2) then
763: p_rec.information19 :=
764: per_pat_shd.g_old_rec.information19;
765: End If;
766: If (p_rec.information20 = hr_api.g_varchar2) then
767: p_rec.information20 :=
768: per_pat_shd.g_old_rec.information20;
764: per_pat_shd.g_old_rec.information19;
765: End If;
766: If (p_rec.information20 = hr_api.g_varchar2) then
767: p_rec.information20 :=
768: per_pat_shd.g_old_rec.information20;
769: End If;
770: --
771: End convert_defs;
772: --
774: -- |---------------------------------< upd >----------------------------------|
775: -- ----------------------------------------------------------------------------
776: Procedure upd
777: (p_effective_date in date
778: ,p_rec in out nocopy per_pat_shd.g_rec_type
779: ) is
780: --
781: l_proc varchar2(72) := g_package||'upd';
782: --
784: hr_utility.set_location('Entering:'||l_proc, 5);
785: --
786: -- We must lock the row which we need to update.
787: --
788: per_pat_shd.lck
789: (p_rec.allocated_task_id
790: ,p_rec.object_version_number
791: );
792: --
888: ,p_information19 in varchar2 default hr_api.g_varchar2
889: ,p_information20 in varchar2 default hr_api.g_varchar2
890: ) is
891: --
892: l_rec per_pat_shd.g_rec_type;
893: l_proc varchar2(72) := g_package||'upd';
894: --
895: Begin
896: hr_utility.set_location('Entering:'||l_proc, 5);
898: -- Call conversion function to turn arguments into the
899: -- l_rec structure.
900: --
901: l_rec :=
902: per_pat_shd.convert_args
903: (p_allocated_task_id
904: ,p_allocated_checklist_id
905: ,p_task_name
906: ,p_description