51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_grd_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_grd_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the per_grades Row
69: --
70: update per_grades
125: ,information20 = p_rec.information20
126: ,object_version_number = p_rec.object_version_number
127: where grade_id = p_rec.grade_id;
128: --
129: per_grd_shd.g_api_dml := false; -- Unset the api dml status
130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 10);
132: --
133: Exception
132: --
133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: per_grd_shd.g_api_dml := false; -- Unset the api dml status
137: per_grd_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: per_grd_shd.g_api_dml := false; -- Unset the api dml status
137: per_grd_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: per_grd_shd.g_api_dml := false; -- Unset the api dml status
137: per_grd_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: per_grd_shd.g_api_dml := false; -- Unset the api dml status
142: per_grd_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: per_grd_shd.g_api_dml := false; -- Unset the api dml status
142: per_grd_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: per_grd_shd.g_api_dml := false; -- Unset the api dml status
142: per_grd_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: per_grd_shd.g_api_dml := false; -- Unset the api dml status
147: per_grd_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When Others Then
150: per_grd_shd.g_api_dml := false; -- Unset the api dml status
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: per_grd_shd.g_api_dml := false; -- Unset the api dml status
147: per_grd_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When Others Then
150: per_grd_shd.g_api_dml := false; -- Unset the api dml status
151: Raise;
146: per_grd_shd.g_api_dml := false; -- Unset the api dml status
147: per_grd_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When Others Then
150: per_grd_shd.g_api_dml := false; -- Unset the api dml status
151: Raise;
152: End update_dml;
153: --
154: -- ----------------------------------------------------------------------------
183: --
184: -- {End Of Comments}
185: -- ----------------------------------------------------------------------------
186: Procedure pre_update
187: (p_rec in per_grd_shd.g_rec_type
188: ) is
189: --
190: l_proc varchar2(72) := g_package||'pre_update';
191: --
228: -- {End Of Comments}
229: -- ----------------------------------------------------------------------------
230: Procedure post_update
231: (p_effective_date in date
232: ,p_rec in per_grd_shd.g_rec_type
233: ) is
234: --
235: l_proc varchar2(72) := g_package||'post_update';
236: --
350: => p_rec.information20
351: ,p_object_version_number
352: => p_rec.object_version_number
353: ,p_business_group_id_o
354: => per_grd_shd.g_old_rec.business_group_id
355: ,p_grade_definition_id_o
356: => per_grd_shd.g_old_rec.grade_definition_id
357: ,p_date_from_o
358: => per_grd_shd.g_old_rec.date_from
352: => p_rec.object_version_number
353: ,p_business_group_id_o
354: => per_grd_shd.g_old_rec.business_group_id
355: ,p_grade_definition_id_o
356: => per_grd_shd.g_old_rec.grade_definition_id
357: ,p_date_from_o
358: => per_grd_shd.g_old_rec.date_from
359: ,p_sequence_o
360: => per_grd_shd.g_old_rec.sequence
354: => per_grd_shd.g_old_rec.business_group_id
355: ,p_grade_definition_id_o
356: => per_grd_shd.g_old_rec.grade_definition_id
357: ,p_date_from_o
358: => per_grd_shd.g_old_rec.date_from
359: ,p_sequence_o
360: => per_grd_shd.g_old_rec.sequence
361: ,p_date_to_o
362: => per_grd_shd.g_old_rec.date_to
356: => per_grd_shd.g_old_rec.grade_definition_id
357: ,p_date_from_o
358: => per_grd_shd.g_old_rec.date_from
359: ,p_sequence_o
360: => per_grd_shd.g_old_rec.sequence
361: ,p_date_to_o
362: => per_grd_shd.g_old_rec.date_to
363: ,p_name_o
364: => per_grd_shd.g_old_rec.name
358: => per_grd_shd.g_old_rec.date_from
359: ,p_sequence_o
360: => per_grd_shd.g_old_rec.sequence
361: ,p_date_to_o
362: => per_grd_shd.g_old_rec.date_to
363: ,p_name_o
364: => per_grd_shd.g_old_rec.name
365: ,p_short_name_o
366: => per_grd_shd.g_old_rec.short_name
360: => per_grd_shd.g_old_rec.sequence
361: ,p_date_to_o
362: => per_grd_shd.g_old_rec.date_to
363: ,p_name_o
364: => per_grd_shd.g_old_rec.name
365: ,p_short_name_o
366: => per_grd_shd.g_old_rec.short_name
367: ,p_request_id_o
368: => per_grd_shd.g_old_rec.request_id
362: => per_grd_shd.g_old_rec.date_to
363: ,p_name_o
364: => per_grd_shd.g_old_rec.name
365: ,p_short_name_o
366: => per_grd_shd.g_old_rec.short_name
367: ,p_request_id_o
368: => per_grd_shd.g_old_rec.request_id
369: ,p_program_application_id_o
370: => per_grd_shd.g_old_rec.program_application_id
364: => per_grd_shd.g_old_rec.name
365: ,p_short_name_o
366: => per_grd_shd.g_old_rec.short_name
367: ,p_request_id_o
368: => per_grd_shd.g_old_rec.request_id
369: ,p_program_application_id_o
370: => per_grd_shd.g_old_rec.program_application_id
371: ,p_program_id_o
372: => per_grd_shd.g_old_rec.program_id
366: => per_grd_shd.g_old_rec.short_name
367: ,p_request_id_o
368: => per_grd_shd.g_old_rec.request_id
369: ,p_program_application_id_o
370: => per_grd_shd.g_old_rec.program_application_id
371: ,p_program_id_o
372: => per_grd_shd.g_old_rec.program_id
373: ,p_program_update_date_o
374: => per_grd_shd.g_old_rec.program_update_date
368: => per_grd_shd.g_old_rec.request_id
369: ,p_program_application_id_o
370: => per_grd_shd.g_old_rec.program_application_id
371: ,p_program_id_o
372: => per_grd_shd.g_old_rec.program_id
373: ,p_program_update_date_o
374: => per_grd_shd.g_old_rec.program_update_date
375: ,p_attribute_category_o
376: => per_grd_shd.g_old_rec.attribute_category
370: => per_grd_shd.g_old_rec.program_application_id
371: ,p_program_id_o
372: => per_grd_shd.g_old_rec.program_id
373: ,p_program_update_date_o
374: => per_grd_shd.g_old_rec.program_update_date
375: ,p_attribute_category_o
376: => per_grd_shd.g_old_rec.attribute_category
377: ,p_attribute1_o
378: => per_grd_shd.g_old_rec.attribute1
372: => per_grd_shd.g_old_rec.program_id
373: ,p_program_update_date_o
374: => per_grd_shd.g_old_rec.program_update_date
375: ,p_attribute_category_o
376: => per_grd_shd.g_old_rec.attribute_category
377: ,p_attribute1_o
378: => per_grd_shd.g_old_rec.attribute1
379: ,p_attribute2_o
380: => per_grd_shd.g_old_rec.attribute2
374: => per_grd_shd.g_old_rec.program_update_date
375: ,p_attribute_category_o
376: => per_grd_shd.g_old_rec.attribute_category
377: ,p_attribute1_o
378: => per_grd_shd.g_old_rec.attribute1
379: ,p_attribute2_o
380: => per_grd_shd.g_old_rec.attribute2
381: ,p_attribute3_o
382: => per_grd_shd.g_old_rec.attribute3
376: => per_grd_shd.g_old_rec.attribute_category
377: ,p_attribute1_o
378: => per_grd_shd.g_old_rec.attribute1
379: ,p_attribute2_o
380: => per_grd_shd.g_old_rec.attribute2
381: ,p_attribute3_o
382: => per_grd_shd.g_old_rec.attribute3
383: ,p_attribute4_o
384: => per_grd_shd.g_old_rec.attribute4
378: => per_grd_shd.g_old_rec.attribute1
379: ,p_attribute2_o
380: => per_grd_shd.g_old_rec.attribute2
381: ,p_attribute3_o
382: => per_grd_shd.g_old_rec.attribute3
383: ,p_attribute4_o
384: => per_grd_shd.g_old_rec.attribute4
385: ,p_attribute5_o
386: => per_grd_shd.g_old_rec.attribute5
380: => per_grd_shd.g_old_rec.attribute2
381: ,p_attribute3_o
382: => per_grd_shd.g_old_rec.attribute3
383: ,p_attribute4_o
384: => per_grd_shd.g_old_rec.attribute4
385: ,p_attribute5_o
386: => per_grd_shd.g_old_rec.attribute5
387: ,p_attribute6_o
388: => per_grd_shd.g_old_rec.attribute6
382: => per_grd_shd.g_old_rec.attribute3
383: ,p_attribute4_o
384: => per_grd_shd.g_old_rec.attribute4
385: ,p_attribute5_o
386: => per_grd_shd.g_old_rec.attribute5
387: ,p_attribute6_o
388: => per_grd_shd.g_old_rec.attribute6
389: ,p_attribute7_o
390: => per_grd_shd.g_old_rec.attribute7
384: => per_grd_shd.g_old_rec.attribute4
385: ,p_attribute5_o
386: => per_grd_shd.g_old_rec.attribute5
387: ,p_attribute6_o
388: => per_grd_shd.g_old_rec.attribute6
389: ,p_attribute7_o
390: => per_grd_shd.g_old_rec.attribute7
391: ,p_attribute8_o
392: => per_grd_shd.g_old_rec.attribute8
386: => per_grd_shd.g_old_rec.attribute5
387: ,p_attribute6_o
388: => per_grd_shd.g_old_rec.attribute6
389: ,p_attribute7_o
390: => per_grd_shd.g_old_rec.attribute7
391: ,p_attribute8_o
392: => per_grd_shd.g_old_rec.attribute8
393: ,p_attribute9_o
394: => per_grd_shd.g_old_rec.attribute9
388: => per_grd_shd.g_old_rec.attribute6
389: ,p_attribute7_o
390: => per_grd_shd.g_old_rec.attribute7
391: ,p_attribute8_o
392: => per_grd_shd.g_old_rec.attribute8
393: ,p_attribute9_o
394: => per_grd_shd.g_old_rec.attribute9
395: ,p_attribute10_o
396: => per_grd_shd.g_old_rec.attribute10
390: => per_grd_shd.g_old_rec.attribute7
391: ,p_attribute8_o
392: => per_grd_shd.g_old_rec.attribute8
393: ,p_attribute9_o
394: => per_grd_shd.g_old_rec.attribute9
395: ,p_attribute10_o
396: => per_grd_shd.g_old_rec.attribute10
397: ,p_attribute11_o
398: => per_grd_shd.g_old_rec.attribute11
392: => per_grd_shd.g_old_rec.attribute8
393: ,p_attribute9_o
394: => per_grd_shd.g_old_rec.attribute9
395: ,p_attribute10_o
396: => per_grd_shd.g_old_rec.attribute10
397: ,p_attribute11_o
398: => per_grd_shd.g_old_rec.attribute11
399: ,p_attribute12_o
400: => per_grd_shd.g_old_rec.attribute12
394: => per_grd_shd.g_old_rec.attribute9
395: ,p_attribute10_o
396: => per_grd_shd.g_old_rec.attribute10
397: ,p_attribute11_o
398: => per_grd_shd.g_old_rec.attribute11
399: ,p_attribute12_o
400: => per_grd_shd.g_old_rec.attribute12
401: ,p_attribute13_o
402: => per_grd_shd.g_old_rec.attribute13
396: => per_grd_shd.g_old_rec.attribute10
397: ,p_attribute11_o
398: => per_grd_shd.g_old_rec.attribute11
399: ,p_attribute12_o
400: => per_grd_shd.g_old_rec.attribute12
401: ,p_attribute13_o
402: => per_grd_shd.g_old_rec.attribute13
403: ,p_attribute14_o
404: => per_grd_shd.g_old_rec.attribute14
398: => per_grd_shd.g_old_rec.attribute11
399: ,p_attribute12_o
400: => per_grd_shd.g_old_rec.attribute12
401: ,p_attribute13_o
402: => per_grd_shd.g_old_rec.attribute13
403: ,p_attribute14_o
404: => per_grd_shd.g_old_rec.attribute14
405: ,p_attribute15_o
406: => per_grd_shd.g_old_rec.attribute15
400: => per_grd_shd.g_old_rec.attribute12
401: ,p_attribute13_o
402: => per_grd_shd.g_old_rec.attribute13
403: ,p_attribute14_o
404: => per_grd_shd.g_old_rec.attribute14
405: ,p_attribute15_o
406: => per_grd_shd.g_old_rec.attribute15
407: ,p_attribute16_o
408: => per_grd_shd.g_old_rec.attribute16
402: => per_grd_shd.g_old_rec.attribute13
403: ,p_attribute14_o
404: => per_grd_shd.g_old_rec.attribute14
405: ,p_attribute15_o
406: => per_grd_shd.g_old_rec.attribute15
407: ,p_attribute16_o
408: => per_grd_shd.g_old_rec.attribute16
409: ,p_attribute17_o
410: => per_grd_shd.g_old_rec.attribute17
404: => per_grd_shd.g_old_rec.attribute14
405: ,p_attribute15_o
406: => per_grd_shd.g_old_rec.attribute15
407: ,p_attribute16_o
408: => per_grd_shd.g_old_rec.attribute16
409: ,p_attribute17_o
410: => per_grd_shd.g_old_rec.attribute17
411: ,p_attribute18_o
412: => per_grd_shd.g_old_rec.attribute18
406: => per_grd_shd.g_old_rec.attribute15
407: ,p_attribute16_o
408: => per_grd_shd.g_old_rec.attribute16
409: ,p_attribute17_o
410: => per_grd_shd.g_old_rec.attribute17
411: ,p_attribute18_o
412: => per_grd_shd.g_old_rec.attribute18
413: ,p_attribute19_o
414: => per_grd_shd.g_old_rec.attribute19
408: => per_grd_shd.g_old_rec.attribute16
409: ,p_attribute17_o
410: => per_grd_shd.g_old_rec.attribute17
411: ,p_attribute18_o
412: => per_grd_shd.g_old_rec.attribute18
413: ,p_attribute19_o
414: => per_grd_shd.g_old_rec.attribute19
415: ,p_attribute20_o
416: => per_grd_shd.g_old_rec.attribute20
410: => per_grd_shd.g_old_rec.attribute17
411: ,p_attribute18_o
412: => per_grd_shd.g_old_rec.attribute18
413: ,p_attribute19_o
414: => per_grd_shd.g_old_rec.attribute19
415: ,p_attribute20_o
416: => per_grd_shd.g_old_rec.attribute20
417: ,p_information_category_o
418: => per_grd_shd.g_old_rec.information_category
412: => per_grd_shd.g_old_rec.attribute18
413: ,p_attribute19_o
414: => per_grd_shd.g_old_rec.attribute19
415: ,p_attribute20_o
416: => per_grd_shd.g_old_rec.attribute20
417: ,p_information_category_o
418: => per_grd_shd.g_old_rec.information_category
419: ,p_information1_o
420: => per_grd_shd.g_old_rec.information1
414: => per_grd_shd.g_old_rec.attribute19
415: ,p_attribute20_o
416: => per_grd_shd.g_old_rec.attribute20
417: ,p_information_category_o
418: => per_grd_shd.g_old_rec.information_category
419: ,p_information1_o
420: => per_grd_shd.g_old_rec.information1
421: ,p_information2_o
422: => per_grd_shd.g_old_rec.information2
416: => per_grd_shd.g_old_rec.attribute20
417: ,p_information_category_o
418: => per_grd_shd.g_old_rec.information_category
419: ,p_information1_o
420: => per_grd_shd.g_old_rec.information1
421: ,p_information2_o
422: => per_grd_shd.g_old_rec.information2
423: ,p_information3_o
424: => per_grd_shd.g_old_rec.information3
418: => per_grd_shd.g_old_rec.information_category
419: ,p_information1_o
420: => per_grd_shd.g_old_rec.information1
421: ,p_information2_o
422: => per_grd_shd.g_old_rec.information2
423: ,p_information3_o
424: => per_grd_shd.g_old_rec.information3
425: ,p_information4_o
426: => per_grd_shd.g_old_rec.information4
420: => per_grd_shd.g_old_rec.information1
421: ,p_information2_o
422: => per_grd_shd.g_old_rec.information2
423: ,p_information3_o
424: => per_grd_shd.g_old_rec.information3
425: ,p_information4_o
426: => per_grd_shd.g_old_rec.information4
427: ,p_information5_o
428: => per_grd_shd.g_old_rec.information5
422: => per_grd_shd.g_old_rec.information2
423: ,p_information3_o
424: => per_grd_shd.g_old_rec.information3
425: ,p_information4_o
426: => per_grd_shd.g_old_rec.information4
427: ,p_information5_o
428: => per_grd_shd.g_old_rec.information5
429: ,p_information6_o
430: => per_grd_shd.g_old_rec.information6
424: => per_grd_shd.g_old_rec.information3
425: ,p_information4_o
426: => per_grd_shd.g_old_rec.information4
427: ,p_information5_o
428: => per_grd_shd.g_old_rec.information5
429: ,p_information6_o
430: => per_grd_shd.g_old_rec.information6
431: ,p_information7_o
432: => per_grd_shd.g_old_rec.information7
426: => per_grd_shd.g_old_rec.information4
427: ,p_information5_o
428: => per_grd_shd.g_old_rec.information5
429: ,p_information6_o
430: => per_grd_shd.g_old_rec.information6
431: ,p_information7_o
432: => per_grd_shd.g_old_rec.information7
433: ,p_information8_o
434: => per_grd_shd.g_old_rec.information8
428: => per_grd_shd.g_old_rec.information5
429: ,p_information6_o
430: => per_grd_shd.g_old_rec.information6
431: ,p_information7_o
432: => per_grd_shd.g_old_rec.information7
433: ,p_information8_o
434: => per_grd_shd.g_old_rec.information8
435: ,p_information9_o
436: => per_grd_shd.g_old_rec.information9
430: => per_grd_shd.g_old_rec.information6
431: ,p_information7_o
432: => per_grd_shd.g_old_rec.information7
433: ,p_information8_o
434: => per_grd_shd.g_old_rec.information8
435: ,p_information9_o
436: => per_grd_shd.g_old_rec.information9
437: ,p_information10_o
438: => per_grd_shd.g_old_rec.information10
432: => per_grd_shd.g_old_rec.information7
433: ,p_information8_o
434: => per_grd_shd.g_old_rec.information8
435: ,p_information9_o
436: => per_grd_shd.g_old_rec.information9
437: ,p_information10_o
438: => per_grd_shd.g_old_rec.information10
439: ,p_information11_o
440: => per_grd_shd.g_old_rec.information11
434: => per_grd_shd.g_old_rec.information8
435: ,p_information9_o
436: => per_grd_shd.g_old_rec.information9
437: ,p_information10_o
438: => per_grd_shd.g_old_rec.information10
439: ,p_information11_o
440: => per_grd_shd.g_old_rec.information11
441: ,p_information12_o
442: => per_grd_shd.g_old_rec.information12
436: => per_grd_shd.g_old_rec.information9
437: ,p_information10_o
438: => per_grd_shd.g_old_rec.information10
439: ,p_information11_o
440: => per_grd_shd.g_old_rec.information11
441: ,p_information12_o
442: => per_grd_shd.g_old_rec.information12
443: ,p_information13_o
444: => per_grd_shd.g_old_rec.information13
438: => per_grd_shd.g_old_rec.information10
439: ,p_information11_o
440: => per_grd_shd.g_old_rec.information11
441: ,p_information12_o
442: => per_grd_shd.g_old_rec.information12
443: ,p_information13_o
444: => per_grd_shd.g_old_rec.information13
445: ,p_information14_o
446: => per_grd_shd.g_old_rec.information14
440: => per_grd_shd.g_old_rec.information11
441: ,p_information12_o
442: => per_grd_shd.g_old_rec.information12
443: ,p_information13_o
444: => per_grd_shd.g_old_rec.information13
445: ,p_information14_o
446: => per_grd_shd.g_old_rec.information14
447: ,p_information15_o
448: => per_grd_shd.g_old_rec.information15
442: => per_grd_shd.g_old_rec.information12
443: ,p_information13_o
444: => per_grd_shd.g_old_rec.information13
445: ,p_information14_o
446: => per_grd_shd.g_old_rec.information14
447: ,p_information15_o
448: => per_grd_shd.g_old_rec.information15
449: ,p_information16_o
450: => per_grd_shd.g_old_rec.information16
444: => per_grd_shd.g_old_rec.information13
445: ,p_information14_o
446: => per_grd_shd.g_old_rec.information14
447: ,p_information15_o
448: => per_grd_shd.g_old_rec.information15
449: ,p_information16_o
450: => per_grd_shd.g_old_rec.information16
451: ,p_information17_o
452: => per_grd_shd.g_old_rec.information17
446: => per_grd_shd.g_old_rec.information14
447: ,p_information15_o
448: => per_grd_shd.g_old_rec.information15
449: ,p_information16_o
450: => per_grd_shd.g_old_rec.information16
451: ,p_information17_o
452: => per_grd_shd.g_old_rec.information17
453: ,p_information18_o
454: => per_grd_shd.g_old_rec.information18
448: => per_grd_shd.g_old_rec.information15
449: ,p_information16_o
450: => per_grd_shd.g_old_rec.information16
451: ,p_information17_o
452: => per_grd_shd.g_old_rec.information17
453: ,p_information18_o
454: => per_grd_shd.g_old_rec.information18
455: ,p_information19_o
456: => per_grd_shd.g_old_rec.information19
450: => per_grd_shd.g_old_rec.information16
451: ,p_information17_o
452: => per_grd_shd.g_old_rec.information17
453: ,p_information18_o
454: => per_grd_shd.g_old_rec.information18
455: ,p_information19_o
456: => per_grd_shd.g_old_rec.information19
457: ,p_information20_o
458: => per_grd_shd.g_old_rec.information20
452: => per_grd_shd.g_old_rec.information17
453: ,p_information18_o
454: => per_grd_shd.g_old_rec.information18
455: ,p_information19_o
456: => per_grd_shd.g_old_rec.information19
457: ,p_information20_o
458: => per_grd_shd.g_old_rec.information20
459: ,p_object_version_number_o
460: => per_grd_shd.g_old_rec.object_version_number
454: => per_grd_shd.g_old_rec.information18
455: ,p_information19_o
456: => per_grd_shd.g_old_rec.information19
457: ,p_information20_o
458: => per_grd_shd.g_old_rec.information20
459: ,p_object_version_number_o
460: => per_grd_shd.g_old_rec.object_version_number
461: );
462: --
456: => per_grd_shd.g_old_rec.information19
457: ,p_information20_o
458: => per_grd_shd.g_old_rec.information20
459: ,p_object_version_number_o
460: => per_grd_shd.g_old_rec.object_version_number
461: );
462: --
463: exception
464: --
516: --
517: -- {End Of Comments}
518: -- ----------------------------------------------------------------------------
519: Procedure convert_defs
520: (p_rec in out nocopy per_grd_shd.g_rec_type
521: ) is
522: --
523: Begin
524: --
528: -- is being used then we must set to the 'current' argument value.
529: --
530: If (p_rec.business_group_id = hr_api.g_number) then
531: p_rec.business_group_id :=
532: per_grd_shd.g_old_rec.business_group_id;
533: End If;
534: If (p_rec.grade_definition_id = hr_api.g_number) then
535: p_rec.grade_definition_id :=
536: per_grd_shd.g_old_rec.grade_definition_id;
532: per_grd_shd.g_old_rec.business_group_id;
533: End If;
534: If (p_rec.grade_definition_id = hr_api.g_number) then
535: p_rec.grade_definition_id :=
536: per_grd_shd.g_old_rec.grade_definition_id;
537: End If;
538: If (p_rec.date_from = hr_api.g_date) then
539: p_rec.date_from :=
540: per_grd_shd.g_old_rec.date_from;
536: per_grd_shd.g_old_rec.grade_definition_id;
537: End If;
538: If (p_rec.date_from = hr_api.g_date) then
539: p_rec.date_from :=
540: per_grd_shd.g_old_rec.date_from;
541: End If;
542: If (p_rec.sequence = hr_api.g_number) then
543: p_rec.sequence :=
544: per_grd_shd.g_old_rec.sequence;
540: per_grd_shd.g_old_rec.date_from;
541: End If;
542: If (p_rec.sequence = hr_api.g_number) then
543: p_rec.sequence :=
544: per_grd_shd.g_old_rec.sequence;
545: End If;
546: If (p_rec.date_to = hr_api.g_date) then
547: p_rec.date_to :=
548: per_grd_shd.g_old_rec.date_to;
544: per_grd_shd.g_old_rec.sequence;
545: End If;
546: If (p_rec.date_to = hr_api.g_date) then
547: p_rec.date_to :=
548: per_grd_shd.g_old_rec.date_to;
549: End If;
550: If (p_rec.name = hr_api.g_varchar2) then
551: p_rec.name :=
552: per_grd_shd.g_old_rec.name;
548: per_grd_shd.g_old_rec.date_to;
549: End If;
550: If (p_rec.name = hr_api.g_varchar2) then
551: p_rec.name :=
552: per_grd_shd.g_old_rec.name;
553: End If;
554: If (p_rec.short_name = hr_api.g_varchar2) then
555: p_rec.short_name :=
556: per_grd_shd.g_old_rec.short_name;
552: per_grd_shd.g_old_rec.name;
553: End If;
554: If (p_rec.short_name = hr_api.g_varchar2) then
555: p_rec.short_name :=
556: per_grd_shd.g_old_rec.short_name;
557: End If;
558: If (p_rec.request_id = hr_api.g_number) then
559: p_rec.request_id :=
560: per_grd_shd.g_old_rec.request_id;
556: per_grd_shd.g_old_rec.short_name;
557: End If;
558: If (p_rec.request_id = hr_api.g_number) then
559: p_rec.request_id :=
560: per_grd_shd.g_old_rec.request_id;
561: End If;
562: If (p_rec.program_application_id = hr_api.g_number) then
563: p_rec.program_application_id :=
564: per_grd_shd.g_old_rec.program_application_id;
560: per_grd_shd.g_old_rec.request_id;
561: End If;
562: If (p_rec.program_application_id = hr_api.g_number) then
563: p_rec.program_application_id :=
564: per_grd_shd.g_old_rec.program_application_id;
565: End If;
566: If (p_rec.program_id = hr_api.g_number) then
567: p_rec.program_id :=
568: per_grd_shd.g_old_rec.program_id;
564: per_grd_shd.g_old_rec.program_application_id;
565: End If;
566: If (p_rec.program_id = hr_api.g_number) then
567: p_rec.program_id :=
568: per_grd_shd.g_old_rec.program_id;
569: End If;
570: If (p_rec.program_update_date = hr_api.g_date) then
571: p_rec.program_update_date :=
572: per_grd_shd.g_old_rec.program_update_date;
568: per_grd_shd.g_old_rec.program_id;
569: End If;
570: If (p_rec.program_update_date = hr_api.g_date) then
571: p_rec.program_update_date :=
572: per_grd_shd.g_old_rec.program_update_date;
573: End If;
574: If (p_rec.attribute_category = hr_api.g_varchar2) then
575: p_rec.attribute_category :=
576: per_grd_shd.g_old_rec.attribute_category;
572: per_grd_shd.g_old_rec.program_update_date;
573: End If;
574: If (p_rec.attribute_category = hr_api.g_varchar2) then
575: p_rec.attribute_category :=
576: per_grd_shd.g_old_rec.attribute_category;
577: End If;
578: If (p_rec.attribute1 = hr_api.g_varchar2) then
579: p_rec.attribute1 :=
580: per_grd_shd.g_old_rec.attribute1;
576: per_grd_shd.g_old_rec.attribute_category;
577: End If;
578: If (p_rec.attribute1 = hr_api.g_varchar2) then
579: p_rec.attribute1 :=
580: per_grd_shd.g_old_rec.attribute1;
581: End If;
582: If (p_rec.attribute2 = hr_api.g_varchar2) then
583: p_rec.attribute2 :=
584: per_grd_shd.g_old_rec.attribute2;
580: per_grd_shd.g_old_rec.attribute1;
581: End If;
582: If (p_rec.attribute2 = hr_api.g_varchar2) then
583: p_rec.attribute2 :=
584: per_grd_shd.g_old_rec.attribute2;
585: End If;
586: If (p_rec.attribute3 = hr_api.g_varchar2) then
587: p_rec.attribute3 :=
588: per_grd_shd.g_old_rec.attribute3;
584: per_grd_shd.g_old_rec.attribute2;
585: End If;
586: If (p_rec.attribute3 = hr_api.g_varchar2) then
587: p_rec.attribute3 :=
588: per_grd_shd.g_old_rec.attribute3;
589: End If;
590: If (p_rec.attribute4 = hr_api.g_varchar2) then
591: p_rec.attribute4 :=
592: per_grd_shd.g_old_rec.attribute4;
588: per_grd_shd.g_old_rec.attribute3;
589: End If;
590: If (p_rec.attribute4 = hr_api.g_varchar2) then
591: p_rec.attribute4 :=
592: per_grd_shd.g_old_rec.attribute4;
593: End If;
594: If (p_rec.attribute5 = hr_api.g_varchar2) then
595: p_rec.attribute5 :=
596: per_grd_shd.g_old_rec.attribute5;
592: per_grd_shd.g_old_rec.attribute4;
593: End If;
594: If (p_rec.attribute5 = hr_api.g_varchar2) then
595: p_rec.attribute5 :=
596: per_grd_shd.g_old_rec.attribute5;
597: End If;
598: If (p_rec.attribute6 = hr_api.g_varchar2) then
599: p_rec.attribute6 :=
600: per_grd_shd.g_old_rec.attribute6;
596: per_grd_shd.g_old_rec.attribute5;
597: End If;
598: If (p_rec.attribute6 = hr_api.g_varchar2) then
599: p_rec.attribute6 :=
600: per_grd_shd.g_old_rec.attribute6;
601: End If;
602: If (p_rec.attribute7 = hr_api.g_varchar2) then
603: p_rec.attribute7 :=
604: per_grd_shd.g_old_rec.attribute7;
600: per_grd_shd.g_old_rec.attribute6;
601: End If;
602: If (p_rec.attribute7 = hr_api.g_varchar2) then
603: p_rec.attribute7 :=
604: per_grd_shd.g_old_rec.attribute7;
605: End If;
606: If (p_rec.attribute8 = hr_api.g_varchar2) then
607: p_rec.attribute8 :=
608: per_grd_shd.g_old_rec.attribute8;
604: per_grd_shd.g_old_rec.attribute7;
605: End If;
606: If (p_rec.attribute8 = hr_api.g_varchar2) then
607: p_rec.attribute8 :=
608: per_grd_shd.g_old_rec.attribute8;
609: End If;
610: If (p_rec.attribute9 = hr_api.g_varchar2) then
611: p_rec.attribute9 :=
612: per_grd_shd.g_old_rec.attribute9;
608: per_grd_shd.g_old_rec.attribute8;
609: End If;
610: If (p_rec.attribute9 = hr_api.g_varchar2) then
611: p_rec.attribute9 :=
612: per_grd_shd.g_old_rec.attribute9;
613: End If;
614: If (p_rec.attribute10 = hr_api.g_varchar2) then
615: p_rec.attribute10 :=
616: per_grd_shd.g_old_rec.attribute10;
612: per_grd_shd.g_old_rec.attribute9;
613: End If;
614: If (p_rec.attribute10 = hr_api.g_varchar2) then
615: p_rec.attribute10 :=
616: per_grd_shd.g_old_rec.attribute10;
617: End If;
618: If (p_rec.attribute11 = hr_api.g_varchar2) then
619: p_rec.attribute11 :=
620: per_grd_shd.g_old_rec.attribute11;
616: per_grd_shd.g_old_rec.attribute10;
617: End If;
618: If (p_rec.attribute11 = hr_api.g_varchar2) then
619: p_rec.attribute11 :=
620: per_grd_shd.g_old_rec.attribute11;
621: End If;
622: If (p_rec.attribute12 = hr_api.g_varchar2) then
623: p_rec.attribute12 :=
624: per_grd_shd.g_old_rec.attribute12;
620: per_grd_shd.g_old_rec.attribute11;
621: End If;
622: If (p_rec.attribute12 = hr_api.g_varchar2) then
623: p_rec.attribute12 :=
624: per_grd_shd.g_old_rec.attribute12;
625: End If;
626: If (p_rec.attribute13 = hr_api.g_varchar2) then
627: p_rec.attribute13 :=
628: per_grd_shd.g_old_rec.attribute13;
624: per_grd_shd.g_old_rec.attribute12;
625: End If;
626: If (p_rec.attribute13 = hr_api.g_varchar2) then
627: p_rec.attribute13 :=
628: per_grd_shd.g_old_rec.attribute13;
629: End If;
630: If (p_rec.attribute14 = hr_api.g_varchar2) then
631: p_rec.attribute14 :=
632: per_grd_shd.g_old_rec.attribute14;
628: per_grd_shd.g_old_rec.attribute13;
629: End If;
630: If (p_rec.attribute14 = hr_api.g_varchar2) then
631: p_rec.attribute14 :=
632: per_grd_shd.g_old_rec.attribute14;
633: End If;
634: If (p_rec.attribute15 = hr_api.g_varchar2) then
635: p_rec.attribute15 :=
636: per_grd_shd.g_old_rec.attribute15;
632: per_grd_shd.g_old_rec.attribute14;
633: End If;
634: If (p_rec.attribute15 = hr_api.g_varchar2) then
635: p_rec.attribute15 :=
636: per_grd_shd.g_old_rec.attribute15;
637: End If;
638: If (p_rec.attribute16 = hr_api.g_varchar2) then
639: p_rec.attribute16 :=
640: per_grd_shd.g_old_rec.attribute16;
636: per_grd_shd.g_old_rec.attribute15;
637: End If;
638: If (p_rec.attribute16 = hr_api.g_varchar2) then
639: p_rec.attribute16 :=
640: per_grd_shd.g_old_rec.attribute16;
641: End If;
642: If (p_rec.attribute17 = hr_api.g_varchar2) then
643: p_rec.attribute17 :=
644: per_grd_shd.g_old_rec.attribute17;
640: per_grd_shd.g_old_rec.attribute16;
641: End If;
642: If (p_rec.attribute17 = hr_api.g_varchar2) then
643: p_rec.attribute17 :=
644: per_grd_shd.g_old_rec.attribute17;
645: End If;
646: If (p_rec.attribute18 = hr_api.g_varchar2) then
647: p_rec.attribute18 :=
648: per_grd_shd.g_old_rec.attribute18;
644: per_grd_shd.g_old_rec.attribute17;
645: End If;
646: If (p_rec.attribute18 = hr_api.g_varchar2) then
647: p_rec.attribute18 :=
648: per_grd_shd.g_old_rec.attribute18;
649: End If;
650: If (p_rec.attribute19 = hr_api.g_varchar2) then
651: p_rec.attribute19 :=
652: per_grd_shd.g_old_rec.attribute19;
648: per_grd_shd.g_old_rec.attribute18;
649: End If;
650: If (p_rec.attribute19 = hr_api.g_varchar2) then
651: p_rec.attribute19 :=
652: per_grd_shd.g_old_rec.attribute19;
653: End If;
654: If (p_rec.attribute20 = hr_api.g_varchar2) then
655: p_rec.attribute20 :=
656: per_grd_shd.g_old_rec.attribute20;
652: per_grd_shd.g_old_rec.attribute19;
653: End If;
654: If (p_rec.attribute20 = hr_api.g_varchar2) then
655: p_rec.attribute20 :=
656: per_grd_shd.g_old_rec.attribute20;
657: End If;
658: If (p_rec.information_category = hr_api.g_varchar2) then
659: p_rec.information_category :=
660: per_grd_shd.g_old_rec.information_category;
656: per_grd_shd.g_old_rec.attribute20;
657: End If;
658: If (p_rec.information_category = hr_api.g_varchar2) then
659: p_rec.information_category :=
660: per_grd_shd.g_old_rec.information_category;
661: End If;
662: If (p_rec.information1 = hr_api.g_varchar2) then
663: p_rec.information1 :=
664: per_grd_shd.g_old_rec.information1;
660: per_grd_shd.g_old_rec.information_category;
661: End If;
662: If (p_rec.information1 = hr_api.g_varchar2) then
663: p_rec.information1 :=
664: per_grd_shd.g_old_rec.information1;
665: End If;
666: If (p_rec.information2 = hr_api.g_varchar2) then
667: p_rec.information2 :=
668: per_grd_shd.g_old_rec.information2;
664: per_grd_shd.g_old_rec.information1;
665: End If;
666: If (p_rec.information2 = hr_api.g_varchar2) then
667: p_rec.information2 :=
668: per_grd_shd.g_old_rec.information2;
669: End If;
670: If (p_rec.information3 = hr_api.g_varchar2) then
671: p_rec.information3 :=
672: per_grd_shd.g_old_rec.information3;
668: per_grd_shd.g_old_rec.information2;
669: End If;
670: If (p_rec.information3 = hr_api.g_varchar2) then
671: p_rec.information3 :=
672: per_grd_shd.g_old_rec.information3;
673: End If;
674: If (p_rec.information4 = hr_api.g_varchar2) then
675: p_rec.information4 :=
676: per_grd_shd.g_old_rec.information4;
672: per_grd_shd.g_old_rec.information3;
673: End If;
674: If (p_rec.information4 = hr_api.g_varchar2) then
675: p_rec.information4 :=
676: per_grd_shd.g_old_rec.information4;
677: End If;
678: If (p_rec.information5 = hr_api.g_varchar2) then
679: p_rec.information5 :=
680: per_grd_shd.g_old_rec.information5;
676: per_grd_shd.g_old_rec.information4;
677: End If;
678: If (p_rec.information5 = hr_api.g_varchar2) then
679: p_rec.information5 :=
680: per_grd_shd.g_old_rec.information5;
681: End If;
682: If (p_rec.information6 = hr_api.g_varchar2) then
683: p_rec.information6 :=
684: per_grd_shd.g_old_rec.information6;
680: per_grd_shd.g_old_rec.information5;
681: End If;
682: If (p_rec.information6 = hr_api.g_varchar2) then
683: p_rec.information6 :=
684: per_grd_shd.g_old_rec.information6;
685: End If;
686: If (p_rec.information7 = hr_api.g_varchar2) then
687: p_rec.information7 :=
688: per_grd_shd.g_old_rec.information7;
684: per_grd_shd.g_old_rec.information6;
685: End If;
686: If (p_rec.information7 = hr_api.g_varchar2) then
687: p_rec.information7 :=
688: per_grd_shd.g_old_rec.information7;
689: End If;
690: If (p_rec.information8 = hr_api.g_varchar2) then
691: p_rec.information8 :=
692: per_grd_shd.g_old_rec.information8;
688: per_grd_shd.g_old_rec.information7;
689: End If;
690: If (p_rec.information8 = hr_api.g_varchar2) then
691: p_rec.information8 :=
692: per_grd_shd.g_old_rec.information8;
693: End If;
694: If (p_rec.information9 = hr_api.g_varchar2) then
695: p_rec.information9 :=
696: per_grd_shd.g_old_rec.information9;
692: per_grd_shd.g_old_rec.information8;
693: End If;
694: If (p_rec.information9 = hr_api.g_varchar2) then
695: p_rec.information9 :=
696: per_grd_shd.g_old_rec.information9;
697: End If;
698: If (p_rec.information10 = hr_api.g_varchar2) then
699: p_rec.information10 :=
700: per_grd_shd.g_old_rec.information10;
696: per_grd_shd.g_old_rec.information9;
697: End If;
698: If (p_rec.information10 = hr_api.g_varchar2) then
699: p_rec.information10 :=
700: per_grd_shd.g_old_rec.information10;
701: End If;
702: If (p_rec.information11 = hr_api.g_varchar2) then
703: p_rec.information11 :=
704: per_grd_shd.g_old_rec.information11;
700: per_grd_shd.g_old_rec.information10;
701: End If;
702: If (p_rec.information11 = hr_api.g_varchar2) then
703: p_rec.information11 :=
704: per_grd_shd.g_old_rec.information11;
705: End If;
706: If (p_rec.information12 = hr_api.g_varchar2) then
707: p_rec.information12 :=
708: per_grd_shd.g_old_rec.information12;
704: per_grd_shd.g_old_rec.information11;
705: End If;
706: If (p_rec.information12 = hr_api.g_varchar2) then
707: p_rec.information12 :=
708: per_grd_shd.g_old_rec.information12;
709: End If;
710: If (p_rec.information13 = hr_api.g_varchar2) then
711: p_rec.information13 :=
712: per_grd_shd.g_old_rec.information13;
708: per_grd_shd.g_old_rec.information12;
709: End If;
710: If (p_rec.information13 = hr_api.g_varchar2) then
711: p_rec.information13 :=
712: per_grd_shd.g_old_rec.information13;
713: End If;
714: If (p_rec.information14 = hr_api.g_varchar2) then
715: p_rec.information14 :=
716: per_grd_shd.g_old_rec.information14;
712: per_grd_shd.g_old_rec.information13;
713: End If;
714: If (p_rec.information14 = hr_api.g_varchar2) then
715: p_rec.information14 :=
716: per_grd_shd.g_old_rec.information14;
717: End If;
718: If (p_rec.information15 = hr_api.g_varchar2) then
719: p_rec.information15 :=
720: per_grd_shd.g_old_rec.information15;
716: per_grd_shd.g_old_rec.information14;
717: End If;
718: If (p_rec.information15 = hr_api.g_varchar2) then
719: p_rec.information15 :=
720: per_grd_shd.g_old_rec.information15;
721: End If;
722: If (p_rec.information16 = hr_api.g_varchar2) then
723: p_rec.information16 :=
724: per_grd_shd.g_old_rec.information16;
720: per_grd_shd.g_old_rec.information15;
721: End If;
722: If (p_rec.information16 = hr_api.g_varchar2) then
723: p_rec.information16 :=
724: per_grd_shd.g_old_rec.information16;
725: End If;
726: If (p_rec.information17 = hr_api.g_varchar2) then
727: p_rec.information17 :=
728: per_grd_shd.g_old_rec.information17;
724: per_grd_shd.g_old_rec.information16;
725: End If;
726: If (p_rec.information17 = hr_api.g_varchar2) then
727: p_rec.information17 :=
728: per_grd_shd.g_old_rec.information17;
729: End If;
730: If (p_rec.information18 = hr_api.g_varchar2) then
731: p_rec.information18 :=
732: per_grd_shd.g_old_rec.information18;
728: per_grd_shd.g_old_rec.information17;
729: End If;
730: If (p_rec.information18 = hr_api.g_varchar2) then
731: p_rec.information18 :=
732: per_grd_shd.g_old_rec.information18;
733: End If;
734: If (p_rec.information19 = hr_api.g_varchar2) then
735: p_rec.information19 :=
736: per_grd_shd.g_old_rec.information19;
732: per_grd_shd.g_old_rec.information18;
733: End If;
734: If (p_rec.information19 = hr_api.g_varchar2) then
735: p_rec.information19 :=
736: per_grd_shd.g_old_rec.information19;
737: End If;
738: If (p_rec.information20 = hr_api.g_varchar2) then
739: p_rec.information20 :=
740: per_grd_shd.g_old_rec.information20;
736: per_grd_shd.g_old_rec.information19;
737: End If;
738: If (p_rec.information20 = hr_api.g_varchar2) then
739: p_rec.information20 :=
740: per_grd_shd.g_old_rec.information20;
741: End If;
742: --
743: End convert_defs;
744: --
746: -- |---------------------------------< upd >----------------------------------|
747: -- ----------------------------------------------------------------------------
748: Procedure upd
749: (p_effective_date in date
750: ,p_rec in out nocopy per_grd_shd.g_rec_type
751: ) is
752: --
753: l_proc varchar2(72) := g_package||'upd';
754: --
756: hr_utility.set_location('Entering:'||l_proc, 5);
757: --
758: -- We must lock the row which we need to update.
759: --
760: per_grd_shd.lck
761: (p_rec.grade_id
762: ,p_rec.object_version_number
763: );
764: --
857: ,p_information19 in varchar2 default hr_api.g_varchar2
858: ,p_information20 in varchar2 default hr_api.g_varchar2
859: ) is
860: --
861: l_rec per_grd_shd.g_rec_type;
862: l_proc varchar2(72) := g_package||'upd';
863: --
864: Begin
865: hr_utility.set_location('Entering:'||l_proc, 5);
867: -- Call conversion function to turn arguments into the
868: -- l_rec structure.
869: --
870: l_rec :=
871: per_grd_shd.convert_args
872: (p_grade_id
873: ,p_business_group_id
874: ,p_grade_definition_id
875: ,p_date_from