[Home] [Help]
52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy per_pac_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72) := g_package||'update_dml';
60: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: per_pac_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: per_pac_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: per_pac_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 per_pac_shd.g_rec_type
184: ) is
185: --
186: l_proc varchar2(72) := g_package||'pre_update';
187: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure post_update
227: (p_effective_date in date
228: ,p_rec in per_pac_shd.g_rec_type
229: ) is
230: --
231: l_proc varchar2(72) := g_package||'post_update';
232: --
336: => p_rec.information19
337: ,p_information20
338: => p_rec.information20
339: ,p_checklist_id_o
340: => per_pac_shd.g_old_rec.checklist_id
341: ,p_person_id_o
342: => per_pac_shd.g_old_rec.person_id
343: ,p_assignment_id_o
344: => per_pac_shd.g_old_rec.assignment_id
338: => p_rec.information20
339: ,p_checklist_id_o
340: => per_pac_shd.g_old_rec.checklist_id
341: ,p_person_id_o
342: => per_pac_shd.g_old_rec.person_id
343: ,p_assignment_id_o
344: => per_pac_shd.g_old_rec.assignment_id
345: ,p_checklist_name_o
346: => per_pac_shd.g_old_rec.checklist_name
340: => per_pac_shd.g_old_rec.checklist_id
341: ,p_person_id_o
342: => per_pac_shd.g_old_rec.person_id
343: ,p_assignment_id_o
344: => per_pac_shd.g_old_rec.assignment_id
345: ,p_checklist_name_o
346: => per_pac_shd.g_old_rec.checklist_name
347: ,p_description_o
348: => per_pac_shd.g_old_rec.description
342: => per_pac_shd.g_old_rec.person_id
343: ,p_assignment_id_o
344: => per_pac_shd.g_old_rec.assignment_id
345: ,p_checklist_name_o
346: => per_pac_shd.g_old_rec.checklist_name
347: ,p_description_o
348: => per_pac_shd.g_old_rec.description
349: ,p_checklist_category_o
350: => per_pac_shd.g_old_rec.checklist_category
344: => per_pac_shd.g_old_rec.assignment_id
345: ,p_checklist_name_o
346: => per_pac_shd.g_old_rec.checklist_name
347: ,p_description_o
348: => per_pac_shd.g_old_rec.description
349: ,p_checklist_category_o
350: => per_pac_shd.g_old_rec.checklist_category
351: ,p_object_version_number_o
352: => per_pac_shd.g_old_rec.object_version_number
346: => per_pac_shd.g_old_rec.checklist_name
347: ,p_description_o
348: => per_pac_shd.g_old_rec.description
349: ,p_checklist_category_o
350: => per_pac_shd.g_old_rec.checklist_category
351: ,p_object_version_number_o
352: => per_pac_shd.g_old_rec.object_version_number
353: ,p_attribute_category_o
354: => per_pac_shd.g_old_rec.attribute_category
348: => per_pac_shd.g_old_rec.description
349: ,p_checklist_category_o
350: => per_pac_shd.g_old_rec.checklist_category
351: ,p_object_version_number_o
352: => per_pac_shd.g_old_rec.object_version_number
353: ,p_attribute_category_o
354: => per_pac_shd.g_old_rec.attribute_category
355: ,p_attribute1_o
356: => per_pac_shd.g_old_rec.attribute1
350: => per_pac_shd.g_old_rec.checklist_category
351: ,p_object_version_number_o
352: => per_pac_shd.g_old_rec.object_version_number
353: ,p_attribute_category_o
354: => per_pac_shd.g_old_rec.attribute_category
355: ,p_attribute1_o
356: => per_pac_shd.g_old_rec.attribute1
357: ,p_attribute2_o
358: => per_pac_shd.g_old_rec.attribute2
352: => per_pac_shd.g_old_rec.object_version_number
353: ,p_attribute_category_o
354: => per_pac_shd.g_old_rec.attribute_category
355: ,p_attribute1_o
356: => per_pac_shd.g_old_rec.attribute1
357: ,p_attribute2_o
358: => per_pac_shd.g_old_rec.attribute2
359: ,p_attribute3_o
360: => per_pac_shd.g_old_rec.attribute3
354: => per_pac_shd.g_old_rec.attribute_category
355: ,p_attribute1_o
356: => per_pac_shd.g_old_rec.attribute1
357: ,p_attribute2_o
358: => per_pac_shd.g_old_rec.attribute2
359: ,p_attribute3_o
360: => per_pac_shd.g_old_rec.attribute3
361: ,p_attribute4_o
362: => per_pac_shd.g_old_rec.attribute4
356: => per_pac_shd.g_old_rec.attribute1
357: ,p_attribute2_o
358: => per_pac_shd.g_old_rec.attribute2
359: ,p_attribute3_o
360: => per_pac_shd.g_old_rec.attribute3
361: ,p_attribute4_o
362: => per_pac_shd.g_old_rec.attribute4
363: ,p_attribute5_o
364: => per_pac_shd.g_old_rec.attribute5
358: => per_pac_shd.g_old_rec.attribute2
359: ,p_attribute3_o
360: => per_pac_shd.g_old_rec.attribute3
361: ,p_attribute4_o
362: => per_pac_shd.g_old_rec.attribute4
363: ,p_attribute5_o
364: => per_pac_shd.g_old_rec.attribute5
365: ,p_attribute6_o
366: => per_pac_shd.g_old_rec.attribute6
360: => per_pac_shd.g_old_rec.attribute3
361: ,p_attribute4_o
362: => per_pac_shd.g_old_rec.attribute4
363: ,p_attribute5_o
364: => per_pac_shd.g_old_rec.attribute5
365: ,p_attribute6_o
366: => per_pac_shd.g_old_rec.attribute6
367: ,p_attribute7_o
368: => per_pac_shd.g_old_rec.attribute7
362: => per_pac_shd.g_old_rec.attribute4
363: ,p_attribute5_o
364: => per_pac_shd.g_old_rec.attribute5
365: ,p_attribute6_o
366: => per_pac_shd.g_old_rec.attribute6
367: ,p_attribute7_o
368: => per_pac_shd.g_old_rec.attribute7
369: ,p_attribute8_o
370: => per_pac_shd.g_old_rec.attribute8
364: => per_pac_shd.g_old_rec.attribute5
365: ,p_attribute6_o
366: => per_pac_shd.g_old_rec.attribute6
367: ,p_attribute7_o
368: => per_pac_shd.g_old_rec.attribute7
369: ,p_attribute8_o
370: => per_pac_shd.g_old_rec.attribute8
371: ,p_attribute9_o
372: => per_pac_shd.g_old_rec.attribute9
366: => per_pac_shd.g_old_rec.attribute6
367: ,p_attribute7_o
368: => per_pac_shd.g_old_rec.attribute7
369: ,p_attribute8_o
370: => per_pac_shd.g_old_rec.attribute8
371: ,p_attribute9_o
372: => per_pac_shd.g_old_rec.attribute9
373: ,p_attribute10_o
374: => per_pac_shd.g_old_rec.attribute10
368: => per_pac_shd.g_old_rec.attribute7
369: ,p_attribute8_o
370: => per_pac_shd.g_old_rec.attribute8
371: ,p_attribute9_o
372: => per_pac_shd.g_old_rec.attribute9
373: ,p_attribute10_o
374: => per_pac_shd.g_old_rec.attribute10
375: ,p_attribute11_o
376: => per_pac_shd.g_old_rec.attribute11
370: => per_pac_shd.g_old_rec.attribute8
371: ,p_attribute9_o
372: => per_pac_shd.g_old_rec.attribute9
373: ,p_attribute10_o
374: => per_pac_shd.g_old_rec.attribute10
375: ,p_attribute11_o
376: => per_pac_shd.g_old_rec.attribute11
377: ,p_attribute12_o
378: => per_pac_shd.g_old_rec.attribute12
372: => per_pac_shd.g_old_rec.attribute9
373: ,p_attribute10_o
374: => per_pac_shd.g_old_rec.attribute10
375: ,p_attribute11_o
376: => per_pac_shd.g_old_rec.attribute11
377: ,p_attribute12_o
378: => per_pac_shd.g_old_rec.attribute12
379: ,p_attribute13_o
380: => per_pac_shd.g_old_rec.attribute13
374: => per_pac_shd.g_old_rec.attribute10
375: ,p_attribute11_o
376: => per_pac_shd.g_old_rec.attribute11
377: ,p_attribute12_o
378: => per_pac_shd.g_old_rec.attribute12
379: ,p_attribute13_o
380: => per_pac_shd.g_old_rec.attribute13
381: ,p_attribute14_o
382: => per_pac_shd.g_old_rec.attribute14
376: => per_pac_shd.g_old_rec.attribute11
377: ,p_attribute12_o
378: => per_pac_shd.g_old_rec.attribute12
379: ,p_attribute13_o
380: => per_pac_shd.g_old_rec.attribute13
381: ,p_attribute14_o
382: => per_pac_shd.g_old_rec.attribute14
383: ,p_attribute15_o
384: => per_pac_shd.g_old_rec.attribute15
378: => per_pac_shd.g_old_rec.attribute12
379: ,p_attribute13_o
380: => per_pac_shd.g_old_rec.attribute13
381: ,p_attribute14_o
382: => per_pac_shd.g_old_rec.attribute14
383: ,p_attribute15_o
384: => per_pac_shd.g_old_rec.attribute15
385: ,p_attribute16_o
386: => per_pac_shd.g_old_rec.attribute16
380: => per_pac_shd.g_old_rec.attribute13
381: ,p_attribute14_o
382: => per_pac_shd.g_old_rec.attribute14
383: ,p_attribute15_o
384: => per_pac_shd.g_old_rec.attribute15
385: ,p_attribute16_o
386: => per_pac_shd.g_old_rec.attribute16
387: ,p_attribute17_o
388: => per_pac_shd.g_old_rec.attribute17
382: => per_pac_shd.g_old_rec.attribute14
383: ,p_attribute15_o
384: => per_pac_shd.g_old_rec.attribute15
385: ,p_attribute16_o
386: => per_pac_shd.g_old_rec.attribute16
387: ,p_attribute17_o
388: => per_pac_shd.g_old_rec.attribute17
389: ,p_attribute18_o
390: => per_pac_shd.g_old_rec.attribute18
384: => per_pac_shd.g_old_rec.attribute15
385: ,p_attribute16_o
386: => per_pac_shd.g_old_rec.attribute16
387: ,p_attribute17_o
388: => per_pac_shd.g_old_rec.attribute17
389: ,p_attribute18_o
390: => per_pac_shd.g_old_rec.attribute18
391: ,p_attribute19_o
392: => per_pac_shd.g_old_rec.attribute19
386: => per_pac_shd.g_old_rec.attribute16
387: ,p_attribute17_o
388: => per_pac_shd.g_old_rec.attribute17
389: ,p_attribute18_o
390: => per_pac_shd.g_old_rec.attribute18
391: ,p_attribute19_o
392: => per_pac_shd.g_old_rec.attribute19
393: ,p_attribute20_o
394: => per_pac_shd.g_old_rec.attribute20
388: => per_pac_shd.g_old_rec.attribute17
389: ,p_attribute18_o
390: => per_pac_shd.g_old_rec.attribute18
391: ,p_attribute19_o
392: => per_pac_shd.g_old_rec.attribute19
393: ,p_attribute20_o
394: => per_pac_shd.g_old_rec.attribute20
395: ,p_information_category_o
396: => per_pac_shd.g_old_rec.information_category
390: => per_pac_shd.g_old_rec.attribute18
391: ,p_attribute19_o
392: => per_pac_shd.g_old_rec.attribute19
393: ,p_attribute20_o
394: => per_pac_shd.g_old_rec.attribute20
395: ,p_information_category_o
396: => per_pac_shd.g_old_rec.information_category
397: ,p_information1_o
398: => per_pac_shd.g_old_rec.information1
392: => per_pac_shd.g_old_rec.attribute19
393: ,p_attribute20_o
394: => per_pac_shd.g_old_rec.attribute20
395: ,p_information_category_o
396: => per_pac_shd.g_old_rec.information_category
397: ,p_information1_o
398: => per_pac_shd.g_old_rec.information1
399: ,p_information2_o
400: => per_pac_shd.g_old_rec.information2
394: => per_pac_shd.g_old_rec.attribute20
395: ,p_information_category_o
396: => per_pac_shd.g_old_rec.information_category
397: ,p_information1_o
398: => per_pac_shd.g_old_rec.information1
399: ,p_information2_o
400: => per_pac_shd.g_old_rec.information2
401: ,p_information3_o
402: => per_pac_shd.g_old_rec.information3
396: => per_pac_shd.g_old_rec.information_category
397: ,p_information1_o
398: => per_pac_shd.g_old_rec.information1
399: ,p_information2_o
400: => per_pac_shd.g_old_rec.information2
401: ,p_information3_o
402: => per_pac_shd.g_old_rec.information3
403: ,p_information4_o
404: => per_pac_shd.g_old_rec.information4
398: => per_pac_shd.g_old_rec.information1
399: ,p_information2_o
400: => per_pac_shd.g_old_rec.information2
401: ,p_information3_o
402: => per_pac_shd.g_old_rec.information3
403: ,p_information4_o
404: => per_pac_shd.g_old_rec.information4
405: ,p_information5_o
406: => per_pac_shd.g_old_rec.information5
400: => per_pac_shd.g_old_rec.information2
401: ,p_information3_o
402: => per_pac_shd.g_old_rec.information3
403: ,p_information4_o
404: => per_pac_shd.g_old_rec.information4
405: ,p_information5_o
406: => per_pac_shd.g_old_rec.information5
407: ,p_information6_o
408: => per_pac_shd.g_old_rec.information6
402: => per_pac_shd.g_old_rec.information3
403: ,p_information4_o
404: => per_pac_shd.g_old_rec.information4
405: ,p_information5_o
406: => per_pac_shd.g_old_rec.information5
407: ,p_information6_o
408: => per_pac_shd.g_old_rec.information6
409: ,p_information7_o
410: => per_pac_shd.g_old_rec.information7
404: => per_pac_shd.g_old_rec.information4
405: ,p_information5_o
406: => per_pac_shd.g_old_rec.information5
407: ,p_information6_o
408: => per_pac_shd.g_old_rec.information6
409: ,p_information7_o
410: => per_pac_shd.g_old_rec.information7
411: ,p_information8_o
412: => per_pac_shd.g_old_rec.information8
406: => per_pac_shd.g_old_rec.information5
407: ,p_information6_o
408: => per_pac_shd.g_old_rec.information6
409: ,p_information7_o
410: => per_pac_shd.g_old_rec.information7
411: ,p_information8_o
412: => per_pac_shd.g_old_rec.information8
413: ,p_information9_o
414: => per_pac_shd.g_old_rec.information9
408: => per_pac_shd.g_old_rec.information6
409: ,p_information7_o
410: => per_pac_shd.g_old_rec.information7
411: ,p_information8_o
412: => per_pac_shd.g_old_rec.information8
413: ,p_information9_o
414: => per_pac_shd.g_old_rec.information9
415: ,p_information10_o
416: => per_pac_shd.g_old_rec.information10
410: => per_pac_shd.g_old_rec.information7
411: ,p_information8_o
412: => per_pac_shd.g_old_rec.information8
413: ,p_information9_o
414: => per_pac_shd.g_old_rec.information9
415: ,p_information10_o
416: => per_pac_shd.g_old_rec.information10
417: ,p_information11_o
418: => per_pac_shd.g_old_rec.information11
412: => per_pac_shd.g_old_rec.information8
413: ,p_information9_o
414: => per_pac_shd.g_old_rec.information9
415: ,p_information10_o
416: => per_pac_shd.g_old_rec.information10
417: ,p_information11_o
418: => per_pac_shd.g_old_rec.information11
419: ,p_information12_o
420: => per_pac_shd.g_old_rec.information12
414: => per_pac_shd.g_old_rec.information9
415: ,p_information10_o
416: => per_pac_shd.g_old_rec.information10
417: ,p_information11_o
418: => per_pac_shd.g_old_rec.information11
419: ,p_information12_o
420: => per_pac_shd.g_old_rec.information12
421: ,p_information13_o
422: => per_pac_shd.g_old_rec.information13
416: => per_pac_shd.g_old_rec.information10
417: ,p_information11_o
418: => per_pac_shd.g_old_rec.information11
419: ,p_information12_o
420: => per_pac_shd.g_old_rec.information12
421: ,p_information13_o
422: => per_pac_shd.g_old_rec.information13
423: ,p_information14_o
424: => per_pac_shd.g_old_rec.information14
418: => per_pac_shd.g_old_rec.information11
419: ,p_information12_o
420: => per_pac_shd.g_old_rec.information12
421: ,p_information13_o
422: => per_pac_shd.g_old_rec.information13
423: ,p_information14_o
424: => per_pac_shd.g_old_rec.information14
425: ,p_information15_o
426: => per_pac_shd.g_old_rec.information15
420: => per_pac_shd.g_old_rec.information12
421: ,p_information13_o
422: => per_pac_shd.g_old_rec.information13
423: ,p_information14_o
424: => per_pac_shd.g_old_rec.information14
425: ,p_information15_o
426: => per_pac_shd.g_old_rec.information15
427: ,p_information16_o
428: => per_pac_shd.g_old_rec.information16
422: => per_pac_shd.g_old_rec.information13
423: ,p_information14_o
424: => per_pac_shd.g_old_rec.information14
425: ,p_information15_o
426: => per_pac_shd.g_old_rec.information15
427: ,p_information16_o
428: => per_pac_shd.g_old_rec.information16
429: ,p_information17_o
430: => per_pac_shd.g_old_rec.information17
424: => per_pac_shd.g_old_rec.information14
425: ,p_information15_o
426: => per_pac_shd.g_old_rec.information15
427: ,p_information16_o
428: => per_pac_shd.g_old_rec.information16
429: ,p_information17_o
430: => per_pac_shd.g_old_rec.information17
431: ,p_information18_o
432: => per_pac_shd.g_old_rec.information18
426: => per_pac_shd.g_old_rec.information15
427: ,p_information16_o
428: => per_pac_shd.g_old_rec.information16
429: ,p_information17_o
430: => per_pac_shd.g_old_rec.information17
431: ,p_information18_o
432: => per_pac_shd.g_old_rec.information18
433: ,p_information19_o
434: => per_pac_shd.g_old_rec.information19
428: => per_pac_shd.g_old_rec.information16
429: ,p_information17_o
430: => per_pac_shd.g_old_rec.information17
431: ,p_information18_o
432: => per_pac_shd.g_old_rec.information18
433: ,p_information19_o
434: => per_pac_shd.g_old_rec.information19
435: ,p_information20_o
436: => per_pac_shd.g_old_rec.information20
430: => per_pac_shd.g_old_rec.information17
431: ,p_information18_o
432: => per_pac_shd.g_old_rec.information18
433: ,p_information19_o
434: => per_pac_shd.g_old_rec.information19
435: ,p_information20_o
436: => per_pac_shd.g_old_rec.information20
437: );
438: --
432: => per_pac_shd.g_old_rec.information18
433: ,p_information19_o
434: => per_pac_shd.g_old_rec.information19
435: ,p_information20_o
436: => per_pac_shd.g_old_rec.information20
437: );
438: --
439: exception
440: --
492: --
493: -- {End Of Comments}
494: -- ----------------------------------------------------------------------------
495: Procedure convert_defs
496: (p_rec in out nocopy per_pac_shd.g_rec_type
497: ) is
498: --
499: Begin
500: --
504: -- is being used then we must set to the 'current' argument value.
505: --
506: If (p_rec.checklist_id = hr_api.g_number) then
507: p_rec.checklist_id :=
508: per_pac_shd.g_old_rec.checklist_id;
509: End If;
510: If (p_rec.person_id = hr_api.g_number) then
511: p_rec.person_id :=
512: per_pac_shd.g_old_rec.person_id;
508: per_pac_shd.g_old_rec.checklist_id;
509: End If;
510: If (p_rec.person_id = hr_api.g_number) then
511: p_rec.person_id :=
512: per_pac_shd.g_old_rec.person_id;
513: End If;
514: If (p_rec.assignment_id = hr_api.g_number) then
515: p_rec.assignment_id :=
516: per_pac_shd.g_old_rec.assignment_id;
512: per_pac_shd.g_old_rec.person_id;
513: End If;
514: If (p_rec.assignment_id = hr_api.g_number) then
515: p_rec.assignment_id :=
516: per_pac_shd.g_old_rec.assignment_id;
517: End If;
518: If (p_rec.checklist_name = hr_api.g_varchar2) then
519: p_rec.checklist_name :=
520: per_pac_shd.g_old_rec.checklist_name;
516: per_pac_shd.g_old_rec.assignment_id;
517: End If;
518: If (p_rec.checklist_name = hr_api.g_varchar2) then
519: p_rec.checklist_name :=
520: per_pac_shd.g_old_rec.checklist_name;
521: End If;
522: If (p_rec.description = hr_api.g_varchar2) then
523: p_rec.description :=
524: per_pac_shd.g_old_rec.description;
520: per_pac_shd.g_old_rec.checklist_name;
521: End If;
522: If (p_rec.description = hr_api.g_varchar2) then
523: p_rec.description :=
524: per_pac_shd.g_old_rec.description;
525: End If;
526: If (p_rec.checklist_category = hr_api.g_varchar2) then
527: p_rec.checklist_category :=
528: per_pac_shd.g_old_rec.checklist_category;
524: per_pac_shd.g_old_rec.description;
525: End If;
526: If (p_rec.checklist_category = hr_api.g_varchar2) then
527: p_rec.checklist_category :=
528: per_pac_shd.g_old_rec.checklist_category;
529: End If;
530: If (p_rec.attribute_category = hr_api.g_varchar2) then
531: p_rec.attribute_category :=
532: per_pac_shd.g_old_rec.attribute_category;
528: per_pac_shd.g_old_rec.checklist_category;
529: End If;
530: If (p_rec.attribute_category = hr_api.g_varchar2) then
531: p_rec.attribute_category :=
532: per_pac_shd.g_old_rec.attribute_category;
533: End If;
534: If (p_rec.attribute1 = hr_api.g_varchar2) then
535: p_rec.attribute1 :=
536: per_pac_shd.g_old_rec.attribute1;
532: per_pac_shd.g_old_rec.attribute_category;
533: End If;
534: If (p_rec.attribute1 = hr_api.g_varchar2) then
535: p_rec.attribute1 :=
536: per_pac_shd.g_old_rec.attribute1;
537: End If;
538: If (p_rec.attribute2 = hr_api.g_varchar2) then
539: p_rec.attribute2 :=
540: per_pac_shd.g_old_rec.attribute2;
536: per_pac_shd.g_old_rec.attribute1;
537: End If;
538: If (p_rec.attribute2 = hr_api.g_varchar2) then
539: p_rec.attribute2 :=
540: per_pac_shd.g_old_rec.attribute2;
541: End If;
542: If (p_rec.attribute3 = hr_api.g_varchar2) then
543: p_rec.attribute3 :=
544: per_pac_shd.g_old_rec.attribute3;
540: per_pac_shd.g_old_rec.attribute2;
541: End If;
542: If (p_rec.attribute3 = hr_api.g_varchar2) then
543: p_rec.attribute3 :=
544: per_pac_shd.g_old_rec.attribute3;
545: End If;
546: If (p_rec.attribute4 = hr_api.g_varchar2) then
547: p_rec.attribute4 :=
548: per_pac_shd.g_old_rec.attribute4;
544: per_pac_shd.g_old_rec.attribute3;
545: End If;
546: If (p_rec.attribute4 = hr_api.g_varchar2) then
547: p_rec.attribute4 :=
548: per_pac_shd.g_old_rec.attribute4;
549: End If;
550: If (p_rec.attribute5 = hr_api.g_varchar2) then
551: p_rec.attribute5 :=
552: per_pac_shd.g_old_rec.attribute5;
548: per_pac_shd.g_old_rec.attribute4;
549: End If;
550: If (p_rec.attribute5 = hr_api.g_varchar2) then
551: p_rec.attribute5 :=
552: per_pac_shd.g_old_rec.attribute5;
553: End If;
554: If (p_rec.attribute6 = hr_api.g_varchar2) then
555: p_rec.attribute6 :=
556: per_pac_shd.g_old_rec.attribute6;
552: per_pac_shd.g_old_rec.attribute5;
553: End If;
554: If (p_rec.attribute6 = hr_api.g_varchar2) then
555: p_rec.attribute6 :=
556: per_pac_shd.g_old_rec.attribute6;
557: End If;
558: If (p_rec.attribute7 = hr_api.g_varchar2) then
559: p_rec.attribute7 :=
560: per_pac_shd.g_old_rec.attribute7;
556: per_pac_shd.g_old_rec.attribute6;
557: End If;
558: If (p_rec.attribute7 = hr_api.g_varchar2) then
559: p_rec.attribute7 :=
560: per_pac_shd.g_old_rec.attribute7;
561: End If;
562: If (p_rec.attribute8 = hr_api.g_varchar2) then
563: p_rec.attribute8 :=
564: per_pac_shd.g_old_rec.attribute8;
560: per_pac_shd.g_old_rec.attribute7;
561: End If;
562: If (p_rec.attribute8 = hr_api.g_varchar2) then
563: p_rec.attribute8 :=
564: per_pac_shd.g_old_rec.attribute8;
565: End If;
566: If (p_rec.attribute9 = hr_api.g_varchar2) then
567: p_rec.attribute9 :=
568: per_pac_shd.g_old_rec.attribute9;
564: per_pac_shd.g_old_rec.attribute8;
565: End If;
566: If (p_rec.attribute9 = hr_api.g_varchar2) then
567: p_rec.attribute9 :=
568: per_pac_shd.g_old_rec.attribute9;
569: End If;
570: If (p_rec.attribute10 = hr_api.g_varchar2) then
571: p_rec.attribute10 :=
572: per_pac_shd.g_old_rec.attribute10;
568: per_pac_shd.g_old_rec.attribute9;
569: End If;
570: If (p_rec.attribute10 = hr_api.g_varchar2) then
571: p_rec.attribute10 :=
572: per_pac_shd.g_old_rec.attribute10;
573: End If;
574: If (p_rec.attribute11 = hr_api.g_varchar2) then
575: p_rec.attribute11 :=
576: per_pac_shd.g_old_rec.attribute11;
572: per_pac_shd.g_old_rec.attribute10;
573: End If;
574: If (p_rec.attribute11 = hr_api.g_varchar2) then
575: p_rec.attribute11 :=
576: per_pac_shd.g_old_rec.attribute11;
577: End If;
578: If (p_rec.attribute12 = hr_api.g_varchar2) then
579: p_rec.attribute12 :=
580: per_pac_shd.g_old_rec.attribute12;
576: per_pac_shd.g_old_rec.attribute11;
577: End If;
578: If (p_rec.attribute12 = hr_api.g_varchar2) then
579: p_rec.attribute12 :=
580: per_pac_shd.g_old_rec.attribute12;
581: End If;
582: If (p_rec.attribute13 = hr_api.g_varchar2) then
583: p_rec.attribute13 :=
584: per_pac_shd.g_old_rec.attribute13;
580: per_pac_shd.g_old_rec.attribute12;
581: End If;
582: If (p_rec.attribute13 = hr_api.g_varchar2) then
583: p_rec.attribute13 :=
584: per_pac_shd.g_old_rec.attribute13;
585: End If;
586: If (p_rec.attribute14 = hr_api.g_varchar2) then
587: p_rec.attribute14 :=
588: per_pac_shd.g_old_rec.attribute14;
584: per_pac_shd.g_old_rec.attribute13;
585: End If;
586: If (p_rec.attribute14 = hr_api.g_varchar2) then
587: p_rec.attribute14 :=
588: per_pac_shd.g_old_rec.attribute14;
589: End If;
590: If (p_rec.attribute15 = hr_api.g_varchar2) then
591: p_rec.attribute15 :=
592: per_pac_shd.g_old_rec.attribute15;
588: per_pac_shd.g_old_rec.attribute14;
589: End If;
590: If (p_rec.attribute15 = hr_api.g_varchar2) then
591: p_rec.attribute15 :=
592: per_pac_shd.g_old_rec.attribute15;
593: End If;
594: If (p_rec.attribute16 = hr_api.g_varchar2) then
595: p_rec.attribute16 :=
596: per_pac_shd.g_old_rec.attribute16;
592: per_pac_shd.g_old_rec.attribute15;
593: End If;
594: If (p_rec.attribute16 = hr_api.g_varchar2) then
595: p_rec.attribute16 :=
596: per_pac_shd.g_old_rec.attribute16;
597: End If;
598: If (p_rec.attribute17 = hr_api.g_varchar2) then
599: p_rec.attribute17 :=
600: per_pac_shd.g_old_rec.attribute17;
596: per_pac_shd.g_old_rec.attribute16;
597: End If;
598: If (p_rec.attribute17 = hr_api.g_varchar2) then
599: p_rec.attribute17 :=
600: per_pac_shd.g_old_rec.attribute17;
601: End If;
602: If (p_rec.attribute18 = hr_api.g_varchar2) then
603: p_rec.attribute18 :=
604: per_pac_shd.g_old_rec.attribute18;
600: per_pac_shd.g_old_rec.attribute17;
601: End If;
602: If (p_rec.attribute18 = hr_api.g_varchar2) then
603: p_rec.attribute18 :=
604: per_pac_shd.g_old_rec.attribute18;
605: End If;
606: If (p_rec.attribute19 = hr_api.g_varchar2) then
607: p_rec.attribute19 :=
608: per_pac_shd.g_old_rec.attribute19;
604: per_pac_shd.g_old_rec.attribute18;
605: End If;
606: If (p_rec.attribute19 = hr_api.g_varchar2) then
607: p_rec.attribute19 :=
608: per_pac_shd.g_old_rec.attribute19;
609: End If;
610: If (p_rec.attribute20 = hr_api.g_varchar2) then
611: p_rec.attribute20 :=
612: per_pac_shd.g_old_rec.attribute20;
608: per_pac_shd.g_old_rec.attribute19;
609: End If;
610: If (p_rec.attribute20 = hr_api.g_varchar2) then
611: p_rec.attribute20 :=
612: per_pac_shd.g_old_rec.attribute20;
613: End If;
614: If (p_rec.information_category = hr_api.g_varchar2) then
615: p_rec.information_category :=
616: per_pac_shd.g_old_rec.information_category;
612: per_pac_shd.g_old_rec.attribute20;
613: End If;
614: If (p_rec.information_category = hr_api.g_varchar2) then
615: p_rec.information_category :=
616: per_pac_shd.g_old_rec.information_category;
617: End If;
618: If (p_rec.information1 = hr_api.g_varchar2) then
619: p_rec.information1 :=
620: per_pac_shd.g_old_rec.information1;
616: per_pac_shd.g_old_rec.information_category;
617: End If;
618: If (p_rec.information1 = hr_api.g_varchar2) then
619: p_rec.information1 :=
620: per_pac_shd.g_old_rec.information1;
621: End If;
622: If (p_rec.information2 = hr_api.g_varchar2) then
623: p_rec.information2 :=
624: per_pac_shd.g_old_rec.information2;
620: per_pac_shd.g_old_rec.information1;
621: End If;
622: If (p_rec.information2 = hr_api.g_varchar2) then
623: p_rec.information2 :=
624: per_pac_shd.g_old_rec.information2;
625: End If;
626: If (p_rec.information3 = hr_api.g_varchar2) then
627: p_rec.information3 :=
628: per_pac_shd.g_old_rec.information3;
624: per_pac_shd.g_old_rec.information2;
625: End If;
626: If (p_rec.information3 = hr_api.g_varchar2) then
627: p_rec.information3 :=
628: per_pac_shd.g_old_rec.information3;
629: End If;
630: If (p_rec.information4 = hr_api.g_varchar2) then
631: p_rec.information4 :=
632: per_pac_shd.g_old_rec.information4;
628: per_pac_shd.g_old_rec.information3;
629: End If;
630: If (p_rec.information4 = hr_api.g_varchar2) then
631: p_rec.information4 :=
632: per_pac_shd.g_old_rec.information4;
633: End If;
634: If (p_rec.information5 = hr_api.g_varchar2) then
635: p_rec.information5 :=
636: per_pac_shd.g_old_rec.information5;
632: per_pac_shd.g_old_rec.information4;
633: End If;
634: If (p_rec.information5 = hr_api.g_varchar2) then
635: p_rec.information5 :=
636: per_pac_shd.g_old_rec.information5;
637: End If;
638: If (p_rec.information6 = hr_api.g_varchar2) then
639: p_rec.information6 :=
640: per_pac_shd.g_old_rec.information6;
636: per_pac_shd.g_old_rec.information5;
637: End If;
638: If (p_rec.information6 = hr_api.g_varchar2) then
639: p_rec.information6 :=
640: per_pac_shd.g_old_rec.information6;
641: End If;
642: If (p_rec.information7 = hr_api.g_varchar2) then
643: p_rec.information7 :=
644: per_pac_shd.g_old_rec.information7;
640: per_pac_shd.g_old_rec.information6;
641: End If;
642: If (p_rec.information7 = hr_api.g_varchar2) then
643: p_rec.information7 :=
644: per_pac_shd.g_old_rec.information7;
645: End If;
646: If (p_rec.information8 = hr_api.g_varchar2) then
647: p_rec.information8 :=
648: per_pac_shd.g_old_rec.information8;
644: per_pac_shd.g_old_rec.information7;
645: End If;
646: If (p_rec.information8 = hr_api.g_varchar2) then
647: p_rec.information8 :=
648: per_pac_shd.g_old_rec.information8;
649: End If;
650: If (p_rec.information9 = hr_api.g_varchar2) then
651: p_rec.information9 :=
652: per_pac_shd.g_old_rec.information9;
648: per_pac_shd.g_old_rec.information8;
649: End If;
650: If (p_rec.information9 = hr_api.g_varchar2) then
651: p_rec.information9 :=
652: per_pac_shd.g_old_rec.information9;
653: End If;
654: If (p_rec.information10 = hr_api.g_varchar2) then
655: p_rec.information10 :=
656: per_pac_shd.g_old_rec.information10;
652: per_pac_shd.g_old_rec.information9;
653: End If;
654: If (p_rec.information10 = hr_api.g_varchar2) then
655: p_rec.information10 :=
656: per_pac_shd.g_old_rec.information10;
657: End If;
658: If (p_rec.information11 = hr_api.g_varchar2) then
659: p_rec.information11 :=
660: per_pac_shd.g_old_rec.information11;
656: per_pac_shd.g_old_rec.information10;
657: End If;
658: If (p_rec.information11 = hr_api.g_varchar2) then
659: p_rec.information11 :=
660: per_pac_shd.g_old_rec.information11;
661: End If;
662: If (p_rec.information12 = hr_api.g_varchar2) then
663: p_rec.information12 :=
664: per_pac_shd.g_old_rec.information12;
660: per_pac_shd.g_old_rec.information11;
661: End If;
662: If (p_rec.information12 = hr_api.g_varchar2) then
663: p_rec.information12 :=
664: per_pac_shd.g_old_rec.information12;
665: End If;
666: If (p_rec.information13 = hr_api.g_varchar2) then
667: p_rec.information13 :=
668: per_pac_shd.g_old_rec.information13;
664: per_pac_shd.g_old_rec.information12;
665: End If;
666: If (p_rec.information13 = hr_api.g_varchar2) then
667: p_rec.information13 :=
668: per_pac_shd.g_old_rec.information13;
669: End If;
670: If (p_rec.information14 = hr_api.g_varchar2) then
671: p_rec.information14 :=
672: per_pac_shd.g_old_rec.information14;
668: per_pac_shd.g_old_rec.information13;
669: End If;
670: If (p_rec.information14 = hr_api.g_varchar2) then
671: p_rec.information14 :=
672: per_pac_shd.g_old_rec.information14;
673: End If;
674: If (p_rec.information15 = hr_api.g_varchar2) then
675: p_rec.information15 :=
676: per_pac_shd.g_old_rec.information15;
672: per_pac_shd.g_old_rec.information14;
673: End If;
674: If (p_rec.information15 = hr_api.g_varchar2) then
675: p_rec.information15 :=
676: per_pac_shd.g_old_rec.information15;
677: End If;
678: If (p_rec.information16 = hr_api.g_varchar2) then
679: p_rec.information16 :=
680: per_pac_shd.g_old_rec.information16;
676: per_pac_shd.g_old_rec.information15;
677: End If;
678: If (p_rec.information16 = hr_api.g_varchar2) then
679: p_rec.information16 :=
680: per_pac_shd.g_old_rec.information16;
681: End If;
682: If (p_rec.information17 = hr_api.g_varchar2) then
683: p_rec.information17 :=
684: per_pac_shd.g_old_rec.information17;
680: per_pac_shd.g_old_rec.information16;
681: End If;
682: If (p_rec.information17 = hr_api.g_varchar2) then
683: p_rec.information17 :=
684: per_pac_shd.g_old_rec.information17;
685: End If;
686: If (p_rec.information18 = hr_api.g_varchar2) then
687: p_rec.information18 :=
688: per_pac_shd.g_old_rec.information18;
684: per_pac_shd.g_old_rec.information17;
685: End If;
686: If (p_rec.information18 = hr_api.g_varchar2) then
687: p_rec.information18 :=
688: per_pac_shd.g_old_rec.information18;
689: End If;
690: If (p_rec.information19 = hr_api.g_varchar2) then
691: p_rec.information19 :=
692: per_pac_shd.g_old_rec.information19;
688: per_pac_shd.g_old_rec.information18;
689: End If;
690: If (p_rec.information19 = hr_api.g_varchar2) then
691: p_rec.information19 :=
692: per_pac_shd.g_old_rec.information19;
693: End If;
694: If (p_rec.information20 = hr_api.g_varchar2) then
695: p_rec.information20 :=
696: per_pac_shd.g_old_rec.information20;
692: per_pac_shd.g_old_rec.information19;
693: End If;
694: If (p_rec.information20 = hr_api.g_varchar2) then
695: p_rec.information20 :=
696: per_pac_shd.g_old_rec.information20;
697: End If;
698: --
699: End convert_defs;
700: --
702: -- |---------------------------------< upd >----------------------------------|
703: -- ----------------------------------------------------------------------------
704: Procedure upd
705: (p_effective_date in date
706: ,p_rec in out nocopy per_pac_shd.g_rec_type
707: ) is
708: --
709: l_proc varchar2(72) := g_package||'upd';
710: --
712: hr_utility.set_location('Entering:'||l_proc, 5);
713: --
714: -- We must lock the row which we need to update.
715: --
716: per_pac_shd.lck
717: (p_rec.allocated_checklist_id
718: ,p_rec.object_version_number
719: );
720: --
808: ,p_information19 in varchar2 default hr_api.g_varchar2
809: ,p_information20 in varchar2 default hr_api.g_varchar2
810: ) is
811: --
812: l_rec per_pac_shd.g_rec_type;
813: l_proc varchar2(72) := g_package||'upd';
814: --
815: Begin
816: hr_utility.set_location('Entering:'||l_proc, 5);
818: -- Call conversion function to turn arguments into the
819: -- l_rec structure.
820: --
821: l_rec :=
822: per_pac_shd.convert_args
823: (p_allocated_checklist_id
824: ,p_checklist_id
825: ,p_person_id
826: ,p_assignment_id