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