51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_pps_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: per_pps_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the per_parent_spines Row
69: --
70: update per_parent_spines
134: ,information30 = p_rec.information30
135: ,object_version_number = p_rec.object_version_number
136: where parent_spine_id = p_rec.parent_spine_id;
137: --
138: per_pps_shd.g_api_dml := false; -- Unset the api dml status
139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: --
142: Exception
141: --
142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: per_pps_shd.g_api_dml := false; -- Unset the api dml status
146: per_pps_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: per_pps_shd.g_api_dml := false; -- Unset the api dml status
146: per_pps_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: per_pps_shd.g_api_dml := false; -- Unset the api dml status
146: per_pps_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: per_pps_shd.g_api_dml := false; -- Unset the api dml status
151: per_pps_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: per_pps_shd.g_api_dml := false; -- Unset the api dml status
151: per_pps_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: per_pps_shd.g_api_dml := false; -- Unset the api dml status
151: per_pps_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: per_pps_shd.g_api_dml := false; -- Unset the api dml status
156: per_pps_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When Others Then
159: per_pps_shd.g_api_dml := false; -- Unset the api dml status
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: per_pps_shd.g_api_dml := false; -- Unset the api dml status
156: per_pps_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When Others Then
159: per_pps_shd.g_api_dml := false; -- Unset the api dml status
160: Raise;
155: per_pps_shd.g_api_dml := false; -- Unset the api dml status
156: per_pps_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When Others Then
159: per_pps_shd.g_api_dml := false; -- Unset the api dml status
160: Raise;
161: End update_dml;
162: --
163: -- ----------------------------------------------------------------------------
192: --
193: -- {End Of Comments}
194: -- ----------------------------------------------------------------------------
195: Procedure pre_update
196: (p_rec in per_pps_shd.g_rec_type
197: ) is
198: --
199: l_proc varchar2(72) := g_package||'pre_update';
200: --
237: -- {End Of Comments}
238: -- ----------------------------------------------------------------------------
239: Procedure post_update
240: (p_effective_date in date
241: ,p_rec in per_pps_shd.g_rec_type
242: ) is
243: --
244: l_proc varchar2(72) := g_package||'post_update';
245: --
377: => p_rec.information30
378: ,p_object_version_number
379: => p_rec.object_version_number
380: ,p_business_group_id_o
381: => per_pps_shd.g_old_rec.business_group_id
382: ,p_name_o
383: => per_pps_shd.g_old_rec.name
384: ,p_comments_o
385: => per_pps_shd.g_old_rec.comments
379: => p_rec.object_version_number
380: ,p_business_group_id_o
381: => per_pps_shd.g_old_rec.business_group_id
382: ,p_name_o
383: => per_pps_shd.g_old_rec.name
384: ,p_comments_o
385: => per_pps_shd.g_old_rec.comments
386: ,p_increment_frequency_o
387: => per_pps_shd.g_old_rec.increment_frequency
381: => per_pps_shd.g_old_rec.business_group_id
382: ,p_name_o
383: => per_pps_shd.g_old_rec.name
384: ,p_comments_o
385: => per_pps_shd.g_old_rec.comments
386: ,p_increment_frequency_o
387: => per_pps_shd.g_old_rec.increment_frequency
388: ,p_increment_period_o
389: => per_pps_shd.g_old_rec.increment_period
383: => per_pps_shd.g_old_rec.name
384: ,p_comments_o
385: => per_pps_shd.g_old_rec.comments
386: ,p_increment_frequency_o
387: => per_pps_shd.g_old_rec.increment_frequency
388: ,p_increment_period_o
389: => per_pps_shd.g_old_rec.increment_period
390: ,p_last_automatic_increment_d_o
391: => per_pps_shd.g_old_rec.last_automatic_increment_date
385: => per_pps_shd.g_old_rec.comments
386: ,p_increment_frequency_o
387: => per_pps_shd.g_old_rec.increment_frequency
388: ,p_increment_period_o
389: => per_pps_shd.g_old_rec.increment_period
390: ,p_last_automatic_increment_d_o
391: => per_pps_shd.g_old_rec.last_automatic_increment_date
392: ,p_request_id_o
393: => per_pps_shd.g_old_rec.request_id
387: => per_pps_shd.g_old_rec.increment_frequency
388: ,p_increment_period_o
389: => per_pps_shd.g_old_rec.increment_period
390: ,p_last_automatic_increment_d_o
391: => per_pps_shd.g_old_rec.last_automatic_increment_date
392: ,p_request_id_o
393: => per_pps_shd.g_old_rec.request_id
394: ,p_program_application_id_o
395: => per_pps_shd.g_old_rec.program_application_id
389: => per_pps_shd.g_old_rec.increment_period
390: ,p_last_automatic_increment_d_o
391: => per_pps_shd.g_old_rec.last_automatic_increment_date
392: ,p_request_id_o
393: => per_pps_shd.g_old_rec.request_id
394: ,p_program_application_id_o
395: => per_pps_shd.g_old_rec.program_application_id
396: ,p_program_id_o
397: => per_pps_shd.g_old_rec.program_id
391: => per_pps_shd.g_old_rec.last_automatic_increment_date
392: ,p_request_id_o
393: => per_pps_shd.g_old_rec.request_id
394: ,p_program_application_id_o
395: => per_pps_shd.g_old_rec.program_application_id
396: ,p_program_id_o
397: => per_pps_shd.g_old_rec.program_id
398: ,p_program_update_date_o
399: => per_pps_shd.g_old_rec.program_update_date
393: => per_pps_shd.g_old_rec.request_id
394: ,p_program_application_id_o
395: => per_pps_shd.g_old_rec.program_application_id
396: ,p_program_id_o
397: => per_pps_shd.g_old_rec.program_id
398: ,p_program_update_date_o
399: => per_pps_shd.g_old_rec.program_update_date
400: ,p_attribute_category_o
401: => per_pps_shd.g_old_rec.attribute_category
395: => per_pps_shd.g_old_rec.program_application_id
396: ,p_program_id_o
397: => per_pps_shd.g_old_rec.program_id
398: ,p_program_update_date_o
399: => per_pps_shd.g_old_rec.program_update_date
400: ,p_attribute_category_o
401: => per_pps_shd.g_old_rec.attribute_category
402: ,p_attribute1_o
403: => per_pps_shd.g_old_rec.attribute1
397: => per_pps_shd.g_old_rec.program_id
398: ,p_program_update_date_o
399: => per_pps_shd.g_old_rec.program_update_date
400: ,p_attribute_category_o
401: => per_pps_shd.g_old_rec.attribute_category
402: ,p_attribute1_o
403: => per_pps_shd.g_old_rec.attribute1
404: ,p_attribute2_o
405: => per_pps_shd.g_old_rec.attribute2
399: => per_pps_shd.g_old_rec.program_update_date
400: ,p_attribute_category_o
401: => per_pps_shd.g_old_rec.attribute_category
402: ,p_attribute1_o
403: => per_pps_shd.g_old_rec.attribute1
404: ,p_attribute2_o
405: => per_pps_shd.g_old_rec.attribute2
406: ,p_attribute3_o
407: => per_pps_shd.g_old_rec.attribute3
401: => per_pps_shd.g_old_rec.attribute_category
402: ,p_attribute1_o
403: => per_pps_shd.g_old_rec.attribute1
404: ,p_attribute2_o
405: => per_pps_shd.g_old_rec.attribute2
406: ,p_attribute3_o
407: => per_pps_shd.g_old_rec.attribute3
408: ,p_attribute4_o
409: => per_pps_shd.g_old_rec.attribute4
403: => per_pps_shd.g_old_rec.attribute1
404: ,p_attribute2_o
405: => per_pps_shd.g_old_rec.attribute2
406: ,p_attribute3_o
407: => per_pps_shd.g_old_rec.attribute3
408: ,p_attribute4_o
409: => per_pps_shd.g_old_rec.attribute4
410: ,p_attribute5_o
411: => per_pps_shd.g_old_rec.attribute5
405: => per_pps_shd.g_old_rec.attribute2
406: ,p_attribute3_o
407: => per_pps_shd.g_old_rec.attribute3
408: ,p_attribute4_o
409: => per_pps_shd.g_old_rec.attribute4
410: ,p_attribute5_o
411: => per_pps_shd.g_old_rec.attribute5
412: ,p_attribute6_o
413: => per_pps_shd.g_old_rec.attribute6
407: => per_pps_shd.g_old_rec.attribute3
408: ,p_attribute4_o
409: => per_pps_shd.g_old_rec.attribute4
410: ,p_attribute5_o
411: => per_pps_shd.g_old_rec.attribute5
412: ,p_attribute6_o
413: => per_pps_shd.g_old_rec.attribute6
414: ,p_attribute7_o
415: => per_pps_shd.g_old_rec.attribute7
409: => per_pps_shd.g_old_rec.attribute4
410: ,p_attribute5_o
411: => per_pps_shd.g_old_rec.attribute5
412: ,p_attribute6_o
413: => per_pps_shd.g_old_rec.attribute6
414: ,p_attribute7_o
415: => per_pps_shd.g_old_rec.attribute7
416: ,p_attribute8_o
417: => per_pps_shd.g_old_rec.attribute8
411: => per_pps_shd.g_old_rec.attribute5
412: ,p_attribute6_o
413: => per_pps_shd.g_old_rec.attribute6
414: ,p_attribute7_o
415: => per_pps_shd.g_old_rec.attribute7
416: ,p_attribute8_o
417: => per_pps_shd.g_old_rec.attribute8
418: ,p_attribute9_o
419: => per_pps_shd.g_old_rec.attribute9
413: => per_pps_shd.g_old_rec.attribute6
414: ,p_attribute7_o
415: => per_pps_shd.g_old_rec.attribute7
416: ,p_attribute8_o
417: => per_pps_shd.g_old_rec.attribute8
418: ,p_attribute9_o
419: => per_pps_shd.g_old_rec.attribute9
420: ,p_attribute10_o
421: => per_pps_shd.g_old_rec.attribute10
415: => per_pps_shd.g_old_rec.attribute7
416: ,p_attribute8_o
417: => per_pps_shd.g_old_rec.attribute8
418: ,p_attribute9_o
419: => per_pps_shd.g_old_rec.attribute9
420: ,p_attribute10_o
421: => per_pps_shd.g_old_rec.attribute10
422: ,p_attribute11_o
423: => per_pps_shd.g_old_rec.attribute11
417: => per_pps_shd.g_old_rec.attribute8
418: ,p_attribute9_o
419: => per_pps_shd.g_old_rec.attribute9
420: ,p_attribute10_o
421: => per_pps_shd.g_old_rec.attribute10
422: ,p_attribute11_o
423: => per_pps_shd.g_old_rec.attribute11
424: ,p_attribute12_o
425: => per_pps_shd.g_old_rec.attribute12
419: => per_pps_shd.g_old_rec.attribute9
420: ,p_attribute10_o
421: => per_pps_shd.g_old_rec.attribute10
422: ,p_attribute11_o
423: => per_pps_shd.g_old_rec.attribute11
424: ,p_attribute12_o
425: => per_pps_shd.g_old_rec.attribute12
426: ,p_attribute13_o
427: => per_pps_shd.g_old_rec.attribute13
421: => per_pps_shd.g_old_rec.attribute10
422: ,p_attribute11_o
423: => per_pps_shd.g_old_rec.attribute11
424: ,p_attribute12_o
425: => per_pps_shd.g_old_rec.attribute12
426: ,p_attribute13_o
427: => per_pps_shd.g_old_rec.attribute13
428: ,p_attribute14_o
429: => per_pps_shd.g_old_rec.attribute14
423: => per_pps_shd.g_old_rec.attribute11
424: ,p_attribute12_o
425: => per_pps_shd.g_old_rec.attribute12
426: ,p_attribute13_o
427: => per_pps_shd.g_old_rec.attribute13
428: ,p_attribute14_o
429: => per_pps_shd.g_old_rec.attribute14
430: ,p_attribute15_o
431: => per_pps_shd.g_old_rec.attribute15
425: => per_pps_shd.g_old_rec.attribute12
426: ,p_attribute13_o
427: => per_pps_shd.g_old_rec.attribute13
428: ,p_attribute14_o
429: => per_pps_shd.g_old_rec.attribute14
430: ,p_attribute15_o
431: => per_pps_shd.g_old_rec.attribute15
432: ,p_attribute16_o
433: => per_pps_shd.g_old_rec.attribute16
427: => per_pps_shd.g_old_rec.attribute13
428: ,p_attribute14_o
429: => per_pps_shd.g_old_rec.attribute14
430: ,p_attribute15_o
431: => per_pps_shd.g_old_rec.attribute15
432: ,p_attribute16_o
433: => per_pps_shd.g_old_rec.attribute16
434: ,p_attribute17_o
435: => per_pps_shd.g_old_rec.attribute17
429: => per_pps_shd.g_old_rec.attribute14
430: ,p_attribute15_o
431: => per_pps_shd.g_old_rec.attribute15
432: ,p_attribute16_o
433: => per_pps_shd.g_old_rec.attribute16
434: ,p_attribute17_o
435: => per_pps_shd.g_old_rec.attribute17
436: ,p_attribute18_o
437: => per_pps_shd.g_old_rec.attribute18
431: => per_pps_shd.g_old_rec.attribute15
432: ,p_attribute16_o
433: => per_pps_shd.g_old_rec.attribute16
434: ,p_attribute17_o
435: => per_pps_shd.g_old_rec.attribute17
436: ,p_attribute18_o
437: => per_pps_shd.g_old_rec.attribute18
438: ,p_attribute19_o
439: => per_pps_shd.g_old_rec.attribute19
433: => per_pps_shd.g_old_rec.attribute16
434: ,p_attribute17_o
435: => per_pps_shd.g_old_rec.attribute17
436: ,p_attribute18_o
437: => per_pps_shd.g_old_rec.attribute18
438: ,p_attribute19_o
439: => per_pps_shd.g_old_rec.attribute19
440: ,p_attribute20_o
441: => per_pps_shd.g_old_rec.attribute20
435: => per_pps_shd.g_old_rec.attribute17
436: ,p_attribute18_o
437: => per_pps_shd.g_old_rec.attribute18
438: ,p_attribute19_o
439: => per_pps_shd.g_old_rec.attribute19
440: ,p_attribute20_o
441: => per_pps_shd.g_old_rec.attribute20
442: ,p_information_category_o
443: => per_pps_shd.g_old_rec.information_category
437: => per_pps_shd.g_old_rec.attribute18
438: ,p_attribute19_o
439: => per_pps_shd.g_old_rec.attribute19
440: ,p_attribute20_o
441: => per_pps_shd.g_old_rec.attribute20
442: ,p_information_category_o
443: => per_pps_shd.g_old_rec.information_category
444: ,p_information1_o
445: => per_pps_shd.g_old_rec.information1
439: => per_pps_shd.g_old_rec.attribute19
440: ,p_attribute20_o
441: => per_pps_shd.g_old_rec.attribute20
442: ,p_information_category_o
443: => per_pps_shd.g_old_rec.information_category
444: ,p_information1_o
445: => per_pps_shd.g_old_rec.information1
446: ,p_information2_o
447: => per_pps_shd.g_old_rec.information2
441: => per_pps_shd.g_old_rec.attribute20
442: ,p_information_category_o
443: => per_pps_shd.g_old_rec.information_category
444: ,p_information1_o
445: => per_pps_shd.g_old_rec.information1
446: ,p_information2_o
447: => per_pps_shd.g_old_rec.information2
448: ,p_information3_o
449: => per_pps_shd.g_old_rec.information3
443: => per_pps_shd.g_old_rec.information_category
444: ,p_information1_o
445: => per_pps_shd.g_old_rec.information1
446: ,p_information2_o
447: => per_pps_shd.g_old_rec.information2
448: ,p_information3_o
449: => per_pps_shd.g_old_rec.information3
450: ,p_information4_o
451: => per_pps_shd.g_old_rec.information4
445: => per_pps_shd.g_old_rec.information1
446: ,p_information2_o
447: => per_pps_shd.g_old_rec.information2
448: ,p_information3_o
449: => per_pps_shd.g_old_rec.information3
450: ,p_information4_o
451: => per_pps_shd.g_old_rec.information4
452: ,p_information5_o
453: => per_pps_shd.g_old_rec.information5
447: => per_pps_shd.g_old_rec.information2
448: ,p_information3_o
449: => per_pps_shd.g_old_rec.information3
450: ,p_information4_o
451: => per_pps_shd.g_old_rec.information4
452: ,p_information5_o
453: => per_pps_shd.g_old_rec.information5
454: ,p_information6_o
455: => per_pps_shd.g_old_rec.information6
449: => per_pps_shd.g_old_rec.information3
450: ,p_information4_o
451: => per_pps_shd.g_old_rec.information4
452: ,p_information5_o
453: => per_pps_shd.g_old_rec.information5
454: ,p_information6_o
455: => per_pps_shd.g_old_rec.information6
456: ,p_information7_o
457: => per_pps_shd.g_old_rec.information7
451: => per_pps_shd.g_old_rec.information4
452: ,p_information5_o
453: => per_pps_shd.g_old_rec.information5
454: ,p_information6_o
455: => per_pps_shd.g_old_rec.information6
456: ,p_information7_o
457: => per_pps_shd.g_old_rec.information7
458: ,p_information8_o
459: => per_pps_shd.g_old_rec.information8
453: => per_pps_shd.g_old_rec.information5
454: ,p_information6_o
455: => per_pps_shd.g_old_rec.information6
456: ,p_information7_o
457: => per_pps_shd.g_old_rec.information7
458: ,p_information8_o
459: => per_pps_shd.g_old_rec.information8
460: ,p_information9_o
461: => per_pps_shd.g_old_rec.information9
455: => per_pps_shd.g_old_rec.information6
456: ,p_information7_o
457: => per_pps_shd.g_old_rec.information7
458: ,p_information8_o
459: => per_pps_shd.g_old_rec.information8
460: ,p_information9_o
461: => per_pps_shd.g_old_rec.information9
462: ,p_information10_o
463: => per_pps_shd.g_old_rec.information10
457: => per_pps_shd.g_old_rec.information7
458: ,p_information8_o
459: => per_pps_shd.g_old_rec.information8
460: ,p_information9_o
461: => per_pps_shd.g_old_rec.information9
462: ,p_information10_o
463: => per_pps_shd.g_old_rec.information10
464: ,p_information11_o
465: => per_pps_shd.g_old_rec.information11
459: => per_pps_shd.g_old_rec.information8
460: ,p_information9_o
461: => per_pps_shd.g_old_rec.information9
462: ,p_information10_o
463: => per_pps_shd.g_old_rec.information10
464: ,p_information11_o
465: => per_pps_shd.g_old_rec.information11
466: ,p_information12_o
467: => per_pps_shd.g_old_rec.information12
461: => per_pps_shd.g_old_rec.information9
462: ,p_information10_o
463: => per_pps_shd.g_old_rec.information10
464: ,p_information11_o
465: => per_pps_shd.g_old_rec.information11
466: ,p_information12_o
467: => per_pps_shd.g_old_rec.information12
468: ,p_information13_o
469: => per_pps_shd.g_old_rec.information13
463: => per_pps_shd.g_old_rec.information10
464: ,p_information11_o
465: => per_pps_shd.g_old_rec.information11
466: ,p_information12_o
467: => per_pps_shd.g_old_rec.information12
468: ,p_information13_o
469: => per_pps_shd.g_old_rec.information13
470: ,p_information14_o
471: => per_pps_shd.g_old_rec.information14
465: => per_pps_shd.g_old_rec.information11
466: ,p_information12_o
467: => per_pps_shd.g_old_rec.information12
468: ,p_information13_o
469: => per_pps_shd.g_old_rec.information13
470: ,p_information14_o
471: => per_pps_shd.g_old_rec.information14
472: ,p_information15_o
473: => per_pps_shd.g_old_rec.information15
467: => per_pps_shd.g_old_rec.information12
468: ,p_information13_o
469: => per_pps_shd.g_old_rec.information13
470: ,p_information14_o
471: => per_pps_shd.g_old_rec.information14
472: ,p_information15_o
473: => per_pps_shd.g_old_rec.information15
474: ,p_information16_o
475: => per_pps_shd.g_old_rec.information16
469: => per_pps_shd.g_old_rec.information13
470: ,p_information14_o
471: => per_pps_shd.g_old_rec.information14
472: ,p_information15_o
473: => per_pps_shd.g_old_rec.information15
474: ,p_information16_o
475: => per_pps_shd.g_old_rec.information16
476: ,p_information17_o
477: => per_pps_shd.g_old_rec.information17
471: => per_pps_shd.g_old_rec.information14
472: ,p_information15_o
473: => per_pps_shd.g_old_rec.information15
474: ,p_information16_o
475: => per_pps_shd.g_old_rec.information16
476: ,p_information17_o
477: => per_pps_shd.g_old_rec.information17
478: ,p_information18_o
479: => per_pps_shd.g_old_rec.information18
473: => per_pps_shd.g_old_rec.information15
474: ,p_information16_o
475: => per_pps_shd.g_old_rec.information16
476: ,p_information17_o
477: => per_pps_shd.g_old_rec.information17
478: ,p_information18_o
479: => per_pps_shd.g_old_rec.information18
480: ,p_information19_o
481: => per_pps_shd.g_old_rec.information19
475: => per_pps_shd.g_old_rec.information16
476: ,p_information17_o
477: => per_pps_shd.g_old_rec.information17
478: ,p_information18_o
479: => per_pps_shd.g_old_rec.information18
480: ,p_information19_o
481: => per_pps_shd.g_old_rec.information19
482: ,p_information20_o
483: => per_pps_shd.g_old_rec.information20
477: => per_pps_shd.g_old_rec.information17
478: ,p_information18_o
479: => per_pps_shd.g_old_rec.information18
480: ,p_information19_o
481: => per_pps_shd.g_old_rec.information19
482: ,p_information20_o
483: => per_pps_shd.g_old_rec.information20
484: ,p_information21_o
485: => per_pps_shd.g_old_rec.information21
479: => per_pps_shd.g_old_rec.information18
480: ,p_information19_o
481: => per_pps_shd.g_old_rec.information19
482: ,p_information20_o
483: => per_pps_shd.g_old_rec.information20
484: ,p_information21_o
485: => per_pps_shd.g_old_rec.information21
486: ,p_information22_o
487: => per_pps_shd.g_old_rec.information22
481: => per_pps_shd.g_old_rec.information19
482: ,p_information20_o
483: => per_pps_shd.g_old_rec.information20
484: ,p_information21_o
485: => per_pps_shd.g_old_rec.information21
486: ,p_information22_o
487: => per_pps_shd.g_old_rec.information22
488: ,p_information23_o
489: => per_pps_shd.g_old_rec.information23
483: => per_pps_shd.g_old_rec.information20
484: ,p_information21_o
485: => per_pps_shd.g_old_rec.information21
486: ,p_information22_o
487: => per_pps_shd.g_old_rec.information22
488: ,p_information23_o
489: => per_pps_shd.g_old_rec.information23
490: ,p_information24_o
491: => per_pps_shd.g_old_rec.information24
485: => per_pps_shd.g_old_rec.information21
486: ,p_information22_o
487: => per_pps_shd.g_old_rec.information22
488: ,p_information23_o
489: => per_pps_shd.g_old_rec.information23
490: ,p_information24_o
491: => per_pps_shd.g_old_rec.information24
492: ,p_information25_o
493: => per_pps_shd.g_old_rec.information25
487: => per_pps_shd.g_old_rec.information22
488: ,p_information23_o
489: => per_pps_shd.g_old_rec.information23
490: ,p_information24_o
491: => per_pps_shd.g_old_rec.information24
492: ,p_information25_o
493: => per_pps_shd.g_old_rec.information25
494: ,p_information26_o
495: => per_pps_shd.g_old_rec.information26
489: => per_pps_shd.g_old_rec.information23
490: ,p_information24_o
491: => per_pps_shd.g_old_rec.information24
492: ,p_information25_o
493: => per_pps_shd.g_old_rec.information25
494: ,p_information26_o
495: => per_pps_shd.g_old_rec.information26
496: ,p_information27_o
497: => per_pps_shd.g_old_rec.information27
491: => per_pps_shd.g_old_rec.information24
492: ,p_information25_o
493: => per_pps_shd.g_old_rec.information25
494: ,p_information26_o
495: => per_pps_shd.g_old_rec.information26
496: ,p_information27_o
497: => per_pps_shd.g_old_rec.information27
498: ,p_information28_o
499: => per_pps_shd.g_old_rec.information28
493: => per_pps_shd.g_old_rec.information25
494: ,p_information26_o
495: => per_pps_shd.g_old_rec.information26
496: ,p_information27_o
497: => per_pps_shd.g_old_rec.information27
498: ,p_information28_o
499: => per_pps_shd.g_old_rec.information28
500: ,p_information29_o
501: => per_pps_shd.g_old_rec.information29
495: => per_pps_shd.g_old_rec.information26
496: ,p_information27_o
497: => per_pps_shd.g_old_rec.information27
498: ,p_information28_o
499: => per_pps_shd.g_old_rec.information28
500: ,p_information29_o
501: => per_pps_shd.g_old_rec.information29
502: ,p_information30_o
503: => per_pps_shd.g_old_rec.information30
497: => per_pps_shd.g_old_rec.information27
498: ,p_information28_o
499: => per_pps_shd.g_old_rec.information28
500: ,p_information29_o
501: => per_pps_shd.g_old_rec.information29
502: ,p_information30_o
503: => per_pps_shd.g_old_rec.information30
504: ,p_object_version_number_o
505: => per_pps_shd.g_old_rec.object_version_number
499: => per_pps_shd.g_old_rec.information28
500: ,p_information29_o
501: => per_pps_shd.g_old_rec.information29
502: ,p_information30_o
503: => per_pps_shd.g_old_rec.information30
504: ,p_object_version_number_o
505: => per_pps_shd.g_old_rec.object_version_number
506: );
507: --
501: => per_pps_shd.g_old_rec.information29
502: ,p_information30_o
503: => per_pps_shd.g_old_rec.information30
504: ,p_object_version_number_o
505: => per_pps_shd.g_old_rec.object_version_number
506: );
507: --
508: exception
509: --
561: --
562: -- {End Of Comments}
563: -- ----------------------------------------------------------------------------
564: Procedure convert_defs
565: (p_rec in out nocopy per_pps_shd.g_rec_type
566: ) is
567: --
568: Begin
569: --
573: -- is being used then we must set to the 'current' argument value.
574: --
575: If (p_rec.business_group_id = hr_api.g_number) then
576: p_rec.business_group_id :=
577: per_pps_shd.g_old_rec.business_group_id;
578: End If;
579: If (p_rec.name = hr_api.g_varchar2) then
580: p_rec.name :=
581: per_pps_shd.g_old_rec.name;
577: per_pps_shd.g_old_rec.business_group_id;
578: End If;
579: If (p_rec.name = hr_api.g_varchar2) then
580: p_rec.name :=
581: per_pps_shd.g_old_rec.name;
582: End If;
583: If (p_rec.comments = hr_api.g_varchar2) then
584: p_rec.comments :=
585: per_pps_shd.g_old_rec.comments;
581: per_pps_shd.g_old_rec.name;
582: End If;
583: If (p_rec.comments = hr_api.g_varchar2) then
584: p_rec.comments :=
585: per_pps_shd.g_old_rec.comments;
586: End If;
587: If (p_rec.increment_frequency = hr_api.g_number) then
588: p_rec.increment_frequency :=
589: per_pps_shd.g_old_rec.increment_frequency;
585: per_pps_shd.g_old_rec.comments;
586: End If;
587: If (p_rec.increment_frequency = hr_api.g_number) then
588: p_rec.increment_frequency :=
589: per_pps_shd.g_old_rec.increment_frequency;
590: End If;
591: If (p_rec.increment_period = hr_api.g_varchar2) then
592: p_rec.increment_period :=
593: per_pps_shd.g_old_rec.increment_period;
589: per_pps_shd.g_old_rec.increment_frequency;
590: End If;
591: If (p_rec.increment_period = hr_api.g_varchar2) then
592: p_rec.increment_period :=
593: per_pps_shd.g_old_rec.increment_period;
594: End If;
595: If (p_rec.last_automatic_increment_date = hr_api.g_date) then
596: p_rec.last_automatic_increment_date :=
597: per_pps_shd.g_old_rec.last_automatic_increment_date;
593: per_pps_shd.g_old_rec.increment_period;
594: End If;
595: If (p_rec.last_automatic_increment_date = hr_api.g_date) then
596: p_rec.last_automatic_increment_date :=
597: per_pps_shd.g_old_rec.last_automatic_increment_date;
598: End If;
599: If (p_rec.request_id = hr_api.g_number) then
600: p_rec.request_id :=
601: per_pps_shd.g_old_rec.request_id;
597: per_pps_shd.g_old_rec.last_automatic_increment_date;
598: End If;
599: If (p_rec.request_id = hr_api.g_number) then
600: p_rec.request_id :=
601: per_pps_shd.g_old_rec.request_id;
602: End If;
603: If (p_rec.program_application_id = hr_api.g_number) then
604: p_rec.program_application_id :=
605: per_pps_shd.g_old_rec.program_application_id;
601: per_pps_shd.g_old_rec.request_id;
602: End If;
603: If (p_rec.program_application_id = hr_api.g_number) then
604: p_rec.program_application_id :=
605: per_pps_shd.g_old_rec.program_application_id;
606: End If;
607: If (p_rec.program_id = hr_api.g_number) then
608: p_rec.program_id :=
609: per_pps_shd.g_old_rec.program_id;
605: per_pps_shd.g_old_rec.program_application_id;
606: End If;
607: If (p_rec.program_id = hr_api.g_number) then
608: p_rec.program_id :=
609: per_pps_shd.g_old_rec.program_id;
610: End If;
611: If (p_rec.program_update_date = hr_api.g_date) then
612: p_rec.program_update_date :=
613: per_pps_shd.g_old_rec.program_update_date;
609: per_pps_shd.g_old_rec.program_id;
610: End If;
611: If (p_rec.program_update_date = hr_api.g_date) then
612: p_rec.program_update_date :=
613: per_pps_shd.g_old_rec.program_update_date;
614: End If;
615: If (p_rec.attribute_category = hr_api.g_varchar2) then
616: p_rec.attribute_category :=
617: per_pps_shd.g_old_rec.attribute_category;
613: per_pps_shd.g_old_rec.program_update_date;
614: End If;
615: If (p_rec.attribute_category = hr_api.g_varchar2) then
616: p_rec.attribute_category :=
617: per_pps_shd.g_old_rec.attribute_category;
618: End If;
619: If (p_rec.attribute1 = hr_api.g_varchar2) then
620: p_rec.attribute1 :=
621: per_pps_shd.g_old_rec.attribute1;
617: per_pps_shd.g_old_rec.attribute_category;
618: End If;
619: If (p_rec.attribute1 = hr_api.g_varchar2) then
620: p_rec.attribute1 :=
621: per_pps_shd.g_old_rec.attribute1;
622: End If;
623: If (p_rec.attribute2 = hr_api.g_varchar2) then
624: p_rec.attribute2 :=
625: per_pps_shd.g_old_rec.attribute2;
621: per_pps_shd.g_old_rec.attribute1;
622: End If;
623: If (p_rec.attribute2 = hr_api.g_varchar2) then
624: p_rec.attribute2 :=
625: per_pps_shd.g_old_rec.attribute2;
626: End If;
627: If (p_rec.attribute3 = hr_api.g_varchar2) then
628: p_rec.attribute3 :=
629: per_pps_shd.g_old_rec.attribute3;
625: per_pps_shd.g_old_rec.attribute2;
626: End If;
627: If (p_rec.attribute3 = hr_api.g_varchar2) then
628: p_rec.attribute3 :=
629: per_pps_shd.g_old_rec.attribute3;
630: End If;
631: If (p_rec.attribute4 = hr_api.g_varchar2) then
632: p_rec.attribute4 :=
633: per_pps_shd.g_old_rec.attribute4;
629: per_pps_shd.g_old_rec.attribute3;
630: End If;
631: If (p_rec.attribute4 = hr_api.g_varchar2) then
632: p_rec.attribute4 :=
633: per_pps_shd.g_old_rec.attribute4;
634: End If;
635: If (p_rec.attribute5 = hr_api.g_varchar2) then
636: p_rec.attribute5 :=
637: per_pps_shd.g_old_rec.attribute5;
633: per_pps_shd.g_old_rec.attribute4;
634: End If;
635: If (p_rec.attribute5 = hr_api.g_varchar2) then
636: p_rec.attribute5 :=
637: per_pps_shd.g_old_rec.attribute5;
638: End If;
639: If (p_rec.attribute6 = hr_api.g_varchar2) then
640: p_rec.attribute6 :=
641: per_pps_shd.g_old_rec.attribute6;
637: per_pps_shd.g_old_rec.attribute5;
638: End If;
639: If (p_rec.attribute6 = hr_api.g_varchar2) then
640: p_rec.attribute6 :=
641: per_pps_shd.g_old_rec.attribute6;
642: End If;
643: If (p_rec.attribute7 = hr_api.g_varchar2) then
644: p_rec.attribute7 :=
645: per_pps_shd.g_old_rec.attribute7;
641: per_pps_shd.g_old_rec.attribute6;
642: End If;
643: If (p_rec.attribute7 = hr_api.g_varchar2) then
644: p_rec.attribute7 :=
645: per_pps_shd.g_old_rec.attribute7;
646: End If;
647: If (p_rec.attribute8 = hr_api.g_varchar2) then
648: p_rec.attribute8 :=
649: per_pps_shd.g_old_rec.attribute8;
645: per_pps_shd.g_old_rec.attribute7;
646: End If;
647: If (p_rec.attribute8 = hr_api.g_varchar2) then
648: p_rec.attribute8 :=
649: per_pps_shd.g_old_rec.attribute8;
650: End If;
651: If (p_rec.attribute9 = hr_api.g_varchar2) then
652: p_rec.attribute9 :=
653: per_pps_shd.g_old_rec.attribute9;
649: per_pps_shd.g_old_rec.attribute8;
650: End If;
651: If (p_rec.attribute9 = hr_api.g_varchar2) then
652: p_rec.attribute9 :=
653: per_pps_shd.g_old_rec.attribute9;
654: End If;
655: If (p_rec.attribute10 = hr_api.g_varchar2) then
656: p_rec.attribute10 :=
657: per_pps_shd.g_old_rec.attribute10;
653: per_pps_shd.g_old_rec.attribute9;
654: End If;
655: If (p_rec.attribute10 = hr_api.g_varchar2) then
656: p_rec.attribute10 :=
657: per_pps_shd.g_old_rec.attribute10;
658: End If;
659: If (p_rec.attribute11 = hr_api.g_varchar2) then
660: p_rec.attribute11 :=
661: per_pps_shd.g_old_rec.attribute11;
657: per_pps_shd.g_old_rec.attribute10;
658: End If;
659: If (p_rec.attribute11 = hr_api.g_varchar2) then
660: p_rec.attribute11 :=
661: per_pps_shd.g_old_rec.attribute11;
662: End If;
663: If (p_rec.attribute12 = hr_api.g_varchar2) then
664: p_rec.attribute12 :=
665: per_pps_shd.g_old_rec.attribute12;
661: per_pps_shd.g_old_rec.attribute11;
662: End If;
663: If (p_rec.attribute12 = hr_api.g_varchar2) then
664: p_rec.attribute12 :=
665: per_pps_shd.g_old_rec.attribute12;
666: End If;
667: If (p_rec.attribute13 = hr_api.g_varchar2) then
668: p_rec.attribute13 :=
669: per_pps_shd.g_old_rec.attribute13;
665: per_pps_shd.g_old_rec.attribute12;
666: End If;
667: If (p_rec.attribute13 = hr_api.g_varchar2) then
668: p_rec.attribute13 :=
669: per_pps_shd.g_old_rec.attribute13;
670: End If;
671: If (p_rec.attribute14 = hr_api.g_varchar2) then
672: p_rec.attribute14 :=
673: per_pps_shd.g_old_rec.attribute14;
669: per_pps_shd.g_old_rec.attribute13;
670: End If;
671: If (p_rec.attribute14 = hr_api.g_varchar2) then
672: p_rec.attribute14 :=
673: per_pps_shd.g_old_rec.attribute14;
674: End If;
675: If (p_rec.attribute15 = hr_api.g_varchar2) then
676: p_rec.attribute15 :=
677: per_pps_shd.g_old_rec.attribute15;
673: per_pps_shd.g_old_rec.attribute14;
674: End If;
675: If (p_rec.attribute15 = hr_api.g_varchar2) then
676: p_rec.attribute15 :=
677: per_pps_shd.g_old_rec.attribute15;
678: End If;
679: If (p_rec.attribute16 = hr_api.g_varchar2) then
680: p_rec.attribute16 :=
681: per_pps_shd.g_old_rec.attribute16;
677: per_pps_shd.g_old_rec.attribute15;
678: End If;
679: If (p_rec.attribute16 = hr_api.g_varchar2) then
680: p_rec.attribute16 :=
681: per_pps_shd.g_old_rec.attribute16;
682: End If;
683: If (p_rec.attribute17 = hr_api.g_varchar2) then
684: p_rec.attribute17 :=
685: per_pps_shd.g_old_rec.attribute17;
681: per_pps_shd.g_old_rec.attribute16;
682: End If;
683: If (p_rec.attribute17 = hr_api.g_varchar2) then
684: p_rec.attribute17 :=
685: per_pps_shd.g_old_rec.attribute17;
686: End If;
687: If (p_rec.attribute18 = hr_api.g_varchar2) then
688: p_rec.attribute18 :=
689: per_pps_shd.g_old_rec.attribute18;
685: per_pps_shd.g_old_rec.attribute17;
686: End If;
687: If (p_rec.attribute18 = hr_api.g_varchar2) then
688: p_rec.attribute18 :=
689: per_pps_shd.g_old_rec.attribute18;
690: End If;
691: If (p_rec.attribute19 = hr_api.g_varchar2) then
692: p_rec.attribute19 :=
693: per_pps_shd.g_old_rec.attribute19;
689: per_pps_shd.g_old_rec.attribute18;
690: End If;
691: If (p_rec.attribute19 = hr_api.g_varchar2) then
692: p_rec.attribute19 :=
693: per_pps_shd.g_old_rec.attribute19;
694: End If;
695: If (p_rec.attribute20 = hr_api.g_varchar2) then
696: p_rec.attribute20 :=
697: per_pps_shd.g_old_rec.attribute20;
693: per_pps_shd.g_old_rec.attribute19;
694: End If;
695: If (p_rec.attribute20 = hr_api.g_varchar2) then
696: p_rec.attribute20 :=
697: per_pps_shd.g_old_rec.attribute20;
698: End If;
699: --
700: If (p_rec.information_category = hr_api.g_varchar2) then
701: p_rec.information_category :=
698: End If;
699: --
700: If (p_rec.information_category = hr_api.g_varchar2) then
701: p_rec.information_category :=
702: per_pps_shd.g_old_rec.information_category;
703: End If;
704: If (p_rec.information1 = hr_api.g_varchar2) then
705: p_rec.information1 :=
706: per_pps_shd.g_old_rec.information1;
702: per_pps_shd.g_old_rec.information_category;
703: End If;
704: If (p_rec.information1 = hr_api.g_varchar2) then
705: p_rec.information1 :=
706: per_pps_shd.g_old_rec.information1;
707: End If;
708: If (p_rec.information2 = hr_api.g_varchar2) then
709: p_rec.information2 :=
710: per_pps_shd.g_old_rec.information2;
706: per_pps_shd.g_old_rec.information1;
707: End If;
708: If (p_rec.information2 = hr_api.g_varchar2) then
709: p_rec.information2 :=
710: per_pps_shd.g_old_rec.information2;
711: End If;
712: If (p_rec.information3 = hr_api.g_varchar2) then
713: p_rec.information3 :=
714: per_pps_shd.g_old_rec.information3;
710: per_pps_shd.g_old_rec.information2;
711: End If;
712: If (p_rec.information3 = hr_api.g_varchar2) then
713: p_rec.information3 :=
714: per_pps_shd.g_old_rec.information3;
715: End If;
716: If (p_rec.information4 = hr_api.g_varchar2) then
717: p_rec.information4 :=
718: per_pps_shd.g_old_rec.information4;
714: per_pps_shd.g_old_rec.information3;
715: End If;
716: If (p_rec.information4 = hr_api.g_varchar2) then
717: p_rec.information4 :=
718: per_pps_shd.g_old_rec.information4;
719: End If;
720: If (p_rec.information5 = hr_api.g_varchar2) then
721: p_rec.information5 :=
722: per_pps_shd.g_old_rec.information5;
718: per_pps_shd.g_old_rec.information4;
719: End If;
720: If (p_rec.information5 = hr_api.g_varchar2) then
721: p_rec.information5 :=
722: per_pps_shd.g_old_rec.information5;
723: End If;
724: If (p_rec.information6 = hr_api.g_varchar2) then
725: p_rec.information6 :=
726: per_pps_shd.g_old_rec.information6;
722: per_pps_shd.g_old_rec.information5;
723: End If;
724: If (p_rec.information6 = hr_api.g_varchar2) then
725: p_rec.information6 :=
726: per_pps_shd.g_old_rec.information6;
727: End If;
728: If (p_rec.information7 = hr_api.g_varchar2) then
729: p_rec.information7 :=
730: per_pps_shd.g_old_rec.information7;
726: per_pps_shd.g_old_rec.information6;
727: End If;
728: If (p_rec.information7 = hr_api.g_varchar2) then
729: p_rec.information7 :=
730: per_pps_shd.g_old_rec.information7;
731: End If;
732: If (p_rec.information8 = hr_api.g_varchar2) then
733: p_rec.information8 :=
734: per_pps_shd.g_old_rec.information8;
730: per_pps_shd.g_old_rec.information7;
731: End If;
732: If (p_rec.information8 = hr_api.g_varchar2) then
733: p_rec.information8 :=
734: per_pps_shd.g_old_rec.information8;
735: End If;
736: If (p_rec.information9 = hr_api.g_varchar2) then
737: p_rec.information9 :=
738: per_pps_shd.g_old_rec.information9;
734: per_pps_shd.g_old_rec.information8;
735: End If;
736: If (p_rec.information9 = hr_api.g_varchar2) then
737: p_rec.information9 :=
738: per_pps_shd.g_old_rec.information9;
739: End If;
740: If (p_rec.information10 = hr_api.g_varchar2) then
741: p_rec.information10 :=
742: per_pps_shd.g_old_rec.information10;
738: per_pps_shd.g_old_rec.information9;
739: End If;
740: If (p_rec.information10 = hr_api.g_varchar2) then
741: p_rec.information10 :=
742: per_pps_shd.g_old_rec.information10;
743: End If;
744: If (p_rec.information11 = hr_api.g_varchar2) then
745: p_rec.information11 :=
746: per_pps_shd.g_old_rec.information11;
742: per_pps_shd.g_old_rec.information10;
743: End If;
744: If (p_rec.information11 = hr_api.g_varchar2) then
745: p_rec.information11 :=
746: per_pps_shd.g_old_rec.information11;
747: End If;
748: If (p_rec.information12 = hr_api.g_varchar2) then
749: p_rec.information12 :=
750: per_pps_shd.g_old_rec.information12;
746: per_pps_shd.g_old_rec.information11;
747: End If;
748: If (p_rec.information12 = hr_api.g_varchar2) then
749: p_rec.information12 :=
750: per_pps_shd.g_old_rec.information12;
751: End If;
752: If (p_rec.information13 = hr_api.g_varchar2) then
753: p_rec.information13 :=
754: per_pps_shd.g_old_rec.information13;
750: per_pps_shd.g_old_rec.information12;
751: End If;
752: If (p_rec.information13 = hr_api.g_varchar2) then
753: p_rec.information13 :=
754: per_pps_shd.g_old_rec.information13;
755: End If;
756: If (p_rec.information14 = hr_api.g_varchar2) then
757: p_rec.information14 :=
758: per_pps_shd.g_old_rec.information14;
754: per_pps_shd.g_old_rec.information13;
755: End If;
756: If (p_rec.information14 = hr_api.g_varchar2) then
757: p_rec.information14 :=
758: per_pps_shd.g_old_rec.information14;
759: End If;
760: If (p_rec.information15 = hr_api.g_varchar2) then
761: p_rec.information15 :=
762: per_pps_shd.g_old_rec.information15;
758: per_pps_shd.g_old_rec.information14;
759: End If;
760: If (p_rec.information15 = hr_api.g_varchar2) then
761: p_rec.information15 :=
762: per_pps_shd.g_old_rec.information15;
763: End If;
764: If (p_rec.information16 = hr_api.g_varchar2) then
765: p_rec.information16 :=
766: per_pps_shd.g_old_rec.information16;
762: per_pps_shd.g_old_rec.information15;
763: End If;
764: If (p_rec.information16 = hr_api.g_varchar2) then
765: p_rec.information16 :=
766: per_pps_shd.g_old_rec.information16;
767: End If;
768: If (p_rec.information17 = hr_api.g_varchar2) then
769: p_rec.information17 :=
770: per_pps_shd.g_old_rec.information17;
766: per_pps_shd.g_old_rec.information16;
767: End If;
768: If (p_rec.information17 = hr_api.g_varchar2) then
769: p_rec.information17 :=
770: per_pps_shd.g_old_rec.information17;
771: End If;
772: If (p_rec.information18 = hr_api.g_varchar2) then
773: p_rec.information18 :=
774: per_pps_shd.g_old_rec.information18;
770: per_pps_shd.g_old_rec.information17;
771: End If;
772: If (p_rec.information18 = hr_api.g_varchar2) then
773: p_rec.information18 :=
774: per_pps_shd.g_old_rec.information18;
775: End If;
776: If (p_rec.information19 = hr_api.g_varchar2) then
777: p_rec.information19 :=
778: per_pps_shd.g_old_rec.information19;
774: per_pps_shd.g_old_rec.information18;
775: End If;
776: If (p_rec.information19 = hr_api.g_varchar2) then
777: p_rec.information19 :=
778: per_pps_shd.g_old_rec.information19;
779: End If;
780: If (p_rec.information20 = hr_api.g_varchar2) then
781: p_rec.information20 :=
782: per_pps_shd.g_old_rec.information20;
778: per_pps_shd.g_old_rec.information19;
779: End If;
780: If (p_rec.information20 = hr_api.g_varchar2) then
781: p_rec.information20 :=
782: per_pps_shd.g_old_rec.information20;
783: End If;
784: If (p_rec.information21 = hr_api.g_varchar2) then
785: p_rec.information21 :=
786: per_pps_shd.g_old_rec.information21;
782: per_pps_shd.g_old_rec.information20;
783: End If;
784: If (p_rec.information21 = hr_api.g_varchar2) then
785: p_rec.information21 :=
786: per_pps_shd.g_old_rec.information21;
787: End If;
788: If (p_rec.information22 = hr_api.g_varchar2) then
789: p_rec.information22 :=
790: per_pps_shd.g_old_rec.information22;
786: per_pps_shd.g_old_rec.information21;
787: End If;
788: If (p_rec.information22 = hr_api.g_varchar2) then
789: p_rec.information22 :=
790: per_pps_shd.g_old_rec.information22;
791: End If;
792: If (p_rec.information23 = hr_api.g_varchar2) then
793: p_rec.information23 :=
794: per_pps_shd.g_old_rec.information23;
790: per_pps_shd.g_old_rec.information22;
791: End If;
792: If (p_rec.information23 = hr_api.g_varchar2) then
793: p_rec.information23 :=
794: per_pps_shd.g_old_rec.information23;
795: End If;
796: If (p_rec.information24 = hr_api.g_varchar2) then
797: p_rec.information24 :=
798: per_pps_shd.g_old_rec.information24;
794: per_pps_shd.g_old_rec.information23;
795: End If;
796: If (p_rec.information24 = hr_api.g_varchar2) then
797: p_rec.information24 :=
798: per_pps_shd.g_old_rec.information24;
799: End If;
800: If (p_rec.information25 = hr_api.g_varchar2) then
801: p_rec.information25 :=
802: per_pps_shd.g_old_rec.information25;
798: per_pps_shd.g_old_rec.information24;
799: End If;
800: If (p_rec.information25 = hr_api.g_varchar2) then
801: p_rec.information25 :=
802: per_pps_shd.g_old_rec.information25;
803: End If;
804: If (p_rec.information26 = hr_api.g_varchar2) then
805: p_rec.information26 :=
806: per_pps_shd.g_old_rec.information26;
802: per_pps_shd.g_old_rec.information25;
803: End If;
804: If (p_rec.information26 = hr_api.g_varchar2) then
805: p_rec.information26 :=
806: per_pps_shd.g_old_rec.information26;
807: End If;
808: If (p_rec.information27 = hr_api.g_varchar2) then
809: p_rec.information27 :=
810: per_pps_shd.g_old_rec.information27;
806: per_pps_shd.g_old_rec.information26;
807: End If;
808: If (p_rec.information27 = hr_api.g_varchar2) then
809: p_rec.information27 :=
810: per_pps_shd.g_old_rec.information27;
811: End If;
812: If (p_rec.information28 = hr_api.g_varchar2) then
813: p_rec.information28 :=
814: per_pps_shd.g_old_rec.information28;
810: per_pps_shd.g_old_rec.information27;
811: End If;
812: If (p_rec.information28 = hr_api.g_varchar2) then
813: p_rec.information28 :=
814: per_pps_shd.g_old_rec.information28;
815: End If;
816: If (p_rec.information29 = hr_api.g_varchar2) then
817: p_rec.information29 :=
818: per_pps_shd.g_old_rec.information29;
814: per_pps_shd.g_old_rec.information28;
815: End If;
816: If (p_rec.information29 = hr_api.g_varchar2) then
817: p_rec.information29 :=
818: per_pps_shd.g_old_rec.information29;
819: End If;
820: If (p_rec.information30 = hr_api.g_varchar2) then
821: p_rec.information30 :=
822: per_pps_shd.g_old_rec.information30;
818: per_pps_shd.g_old_rec.information29;
819: End If;
820: If (p_rec.information30 = hr_api.g_varchar2) then
821: p_rec.information30 :=
822: per_pps_shd.g_old_rec.information30;
823: End If;
824: --
825: End convert_defs;
826: --
828: -- |---------------------------------< upd >----------------------------------|
829: -- ----------------------------------------------------------------------------
830: Procedure upd
831: (p_effective_date in date
832: ,p_rec in out nocopy per_pps_shd.g_rec_type
833: ) is
834: --
835: l_proc varchar2(72) := g_package||'upd';
836: --
838: hr_utility.set_location('Entering:'||l_proc, 5);
839: --
840: -- We must lock the row which we need to update.
841: --
842: per_pps_shd.lck
843: (p_rec.parent_spine_id
844: ,p_rec.object_version_number
845: );
846: --
948: ,p_information29 in varchar2 default hr_api.g_varchar2
949: ,p_information30 in varchar2 default hr_api.g_varchar2
950: ) is
951: --
952: l_rec per_pps_shd.g_rec_type;
953: l_proc varchar2(72) := g_package||'upd';
954: --
955: Begin
956: hr_utility.set_location('Entering:'||l_proc, 5);
958: -- Call conversion function to turn arguments into the
959: -- l_rec structure.
960: --
961: l_rec :=
962: per_pps_shd.convert_args
963: (p_parent_spine_id
964: ,p_business_group_id
965: ,p_name
966: ,p_comments