[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ota_tpc_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
144: Exception
145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
147: --
148: ota_tpc_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: --
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: --
153: ota_tpc_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: --
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: --
158: ota_tpc_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When Others Then
161: --
162: Raise;
194: --
195: -- {End Of Comments}
196: -- ----------------------------------------------------------------------------
197: Procedure pre_update
198: (p_rec in ota_tpc_shd.g_rec_type
199: ) is
200: --
201: l_proc varchar2(72) := g_package||'pre_update';
202: --
239: -- {End Of Comments}
240: -- ----------------------------------------------------------------------------
241: Procedure post_update
242: (p_effective_date in date
243: ,p_rec in ota_tpc_shd.g_rec_type
244: ) is
245: --
246: l_proc varchar2(72) := g_package||'post_update';
247: --
393: => p_rec.tp_cost_information29
394: ,p_tp_cost_information30
395: => p_rec.tp_cost_information30
396: ,p_tp_measurement_type_id_o
397: => ota_tpc_shd.g_old_rec.tp_measurement_type_id
398: ,p_training_plan_id_o
399: => ota_tpc_shd.g_old_rec.training_plan_id
400: ,p_booking_id_o
401: => ota_tpc_shd.g_old_rec.booking_id
395: => p_rec.tp_cost_information30
396: ,p_tp_measurement_type_id_o
397: => ota_tpc_shd.g_old_rec.tp_measurement_type_id
398: ,p_training_plan_id_o
399: => ota_tpc_shd.g_old_rec.training_plan_id
400: ,p_booking_id_o
401: => ota_tpc_shd.g_old_rec.booking_id
402: ,p_event_id_o
403: => ota_tpc_shd.g_old_rec.event_id
397: => ota_tpc_shd.g_old_rec.tp_measurement_type_id
398: ,p_training_plan_id_o
399: => ota_tpc_shd.g_old_rec.training_plan_id
400: ,p_booking_id_o
401: => ota_tpc_shd.g_old_rec.booking_id
402: ,p_event_id_o
403: => ota_tpc_shd.g_old_rec.event_id
404: ,p_amount_o
405: => ota_tpc_shd.g_old_rec.amount
399: => ota_tpc_shd.g_old_rec.training_plan_id
400: ,p_booking_id_o
401: => ota_tpc_shd.g_old_rec.booking_id
402: ,p_event_id_o
403: => ota_tpc_shd.g_old_rec.event_id
404: ,p_amount_o
405: => ota_tpc_shd.g_old_rec.amount
406: ,p_currency_code_o
407: => ota_tpc_shd.g_old_rec.currency_code
401: => ota_tpc_shd.g_old_rec.booking_id
402: ,p_event_id_o
403: => ota_tpc_shd.g_old_rec.event_id
404: ,p_amount_o
405: => ota_tpc_shd.g_old_rec.amount
406: ,p_currency_code_o
407: => ota_tpc_shd.g_old_rec.currency_code
408: ,p_business_group_id_o
409: => ota_tpc_shd.g_old_rec.business_group_id
403: => ota_tpc_shd.g_old_rec.event_id
404: ,p_amount_o
405: => ota_tpc_shd.g_old_rec.amount
406: ,p_currency_code_o
407: => ota_tpc_shd.g_old_rec.currency_code
408: ,p_business_group_id_o
409: => ota_tpc_shd.g_old_rec.business_group_id
410: ,p_object_version_number_o
411: => ota_tpc_shd.g_old_rec.object_version_number
405: => ota_tpc_shd.g_old_rec.amount
406: ,p_currency_code_o
407: => ota_tpc_shd.g_old_rec.currency_code
408: ,p_business_group_id_o
409: => ota_tpc_shd.g_old_rec.business_group_id
410: ,p_object_version_number_o
411: => ota_tpc_shd.g_old_rec.object_version_number
412: ,p_attribute_category_o
413: => ota_tpc_shd.g_old_rec.attribute_category
407: => ota_tpc_shd.g_old_rec.currency_code
408: ,p_business_group_id_o
409: => ota_tpc_shd.g_old_rec.business_group_id
410: ,p_object_version_number_o
411: => ota_tpc_shd.g_old_rec.object_version_number
412: ,p_attribute_category_o
413: => ota_tpc_shd.g_old_rec.attribute_category
414: ,p_attribute1_o
415: => ota_tpc_shd.g_old_rec.attribute1
409: => ota_tpc_shd.g_old_rec.business_group_id
410: ,p_object_version_number_o
411: => ota_tpc_shd.g_old_rec.object_version_number
412: ,p_attribute_category_o
413: => ota_tpc_shd.g_old_rec.attribute_category
414: ,p_attribute1_o
415: => ota_tpc_shd.g_old_rec.attribute1
416: ,p_attribute2_o
417: => ota_tpc_shd.g_old_rec.attribute2
411: => ota_tpc_shd.g_old_rec.object_version_number
412: ,p_attribute_category_o
413: => ota_tpc_shd.g_old_rec.attribute_category
414: ,p_attribute1_o
415: => ota_tpc_shd.g_old_rec.attribute1
416: ,p_attribute2_o
417: => ota_tpc_shd.g_old_rec.attribute2
418: ,p_attribute3_o
419: => ota_tpc_shd.g_old_rec.attribute3
413: => ota_tpc_shd.g_old_rec.attribute_category
414: ,p_attribute1_o
415: => ota_tpc_shd.g_old_rec.attribute1
416: ,p_attribute2_o
417: => ota_tpc_shd.g_old_rec.attribute2
418: ,p_attribute3_o
419: => ota_tpc_shd.g_old_rec.attribute3
420: ,p_attribute4_o
421: => ota_tpc_shd.g_old_rec.attribute4
415: => ota_tpc_shd.g_old_rec.attribute1
416: ,p_attribute2_o
417: => ota_tpc_shd.g_old_rec.attribute2
418: ,p_attribute3_o
419: => ota_tpc_shd.g_old_rec.attribute3
420: ,p_attribute4_o
421: => ota_tpc_shd.g_old_rec.attribute4
422: ,p_attribute5_o
423: => ota_tpc_shd.g_old_rec.attribute5
417: => ota_tpc_shd.g_old_rec.attribute2
418: ,p_attribute3_o
419: => ota_tpc_shd.g_old_rec.attribute3
420: ,p_attribute4_o
421: => ota_tpc_shd.g_old_rec.attribute4
422: ,p_attribute5_o
423: => ota_tpc_shd.g_old_rec.attribute5
424: ,p_attribute6_o
425: => ota_tpc_shd.g_old_rec.attribute6
419: => ota_tpc_shd.g_old_rec.attribute3
420: ,p_attribute4_o
421: => ota_tpc_shd.g_old_rec.attribute4
422: ,p_attribute5_o
423: => ota_tpc_shd.g_old_rec.attribute5
424: ,p_attribute6_o
425: => ota_tpc_shd.g_old_rec.attribute6
426: ,p_attribute7_o
427: => ota_tpc_shd.g_old_rec.attribute7
421: => ota_tpc_shd.g_old_rec.attribute4
422: ,p_attribute5_o
423: => ota_tpc_shd.g_old_rec.attribute5
424: ,p_attribute6_o
425: => ota_tpc_shd.g_old_rec.attribute6
426: ,p_attribute7_o
427: => ota_tpc_shd.g_old_rec.attribute7
428: ,p_attribute8_o
429: => ota_tpc_shd.g_old_rec.attribute8
423: => ota_tpc_shd.g_old_rec.attribute5
424: ,p_attribute6_o
425: => ota_tpc_shd.g_old_rec.attribute6
426: ,p_attribute7_o
427: => ota_tpc_shd.g_old_rec.attribute7
428: ,p_attribute8_o
429: => ota_tpc_shd.g_old_rec.attribute8
430: ,p_attribute9_o
431: => ota_tpc_shd.g_old_rec.attribute9
425: => ota_tpc_shd.g_old_rec.attribute6
426: ,p_attribute7_o
427: => ota_tpc_shd.g_old_rec.attribute7
428: ,p_attribute8_o
429: => ota_tpc_shd.g_old_rec.attribute8
430: ,p_attribute9_o
431: => ota_tpc_shd.g_old_rec.attribute9
432: ,p_attribute10_o
433: => ota_tpc_shd.g_old_rec.attribute10
427: => ota_tpc_shd.g_old_rec.attribute7
428: ,p_attribute8_o
429: => ota_tpc_shd.g_old_rec.attribute8
430: ,p_attribute9_o
431: => ota_tpc_shd.g_old_rec.attribute9
432: ,p_attribute10_o
433: => ota_tpc_shd.g_old_rec.attribute10
434: ,p_attribute11_o
435: => ota_tpc_shd.g_old_rec.attribute11
429: => ota_tpc_shd.g_old_rec.attribute8
430: ,p_attribute9_o
431: => ota_tpc_shd.g_old_rec.attribute9
432: ,p_attribute10_o
433: => ota_tpc_shd.g_old_rec.attribute10
434: ,p_attribute11_o
435: => ota_tpc_shd.g_old_rec.attribute11
436: ,p_attribute12_o
437: => ota_tpc_shd.g_old_rec.attribute12
431: => ota_tpc_shd.g_old_rec.attribute9
432: ,p_attribute10_o
433: => ota_tpc_shd.g_old_rec.attribute10
434: ,p_attribute11_o
435: => ota_tpc_shd.g_old_rec.attribute11
436: ,p_attribute12_o
437: => ota_tpc_shd.g_old_rec.attribute12
438: ,p_attribute13_o
439: => ota_tpc_shd.g_old_rec.attribute13
433: => ota_tpc_shd.g_old_rec.attribute10
434: ,p_attribute11_o
435: => ota_tpc_shd.g_old_rec.attribute11
436: ,p_attribute12_o
437: => ota_tpc_shd.g_old_rec.attribute12
438: ,p_attribute13_o
439: => ota_tpc_shd.g_old_rec.attribute13
440: ,p_attribute14_o
441: => ota_tpc_shd.g_old_rec.attribute14
435: => ota_tpc_shd.g_old_rec.attribute11
436: ,p_attribute12_o
437: => ota_tpc_shd.g_old_rec.attribute12
438: ,p_attribute13_o
439: => ota_tpc_shd.g_old_rec.attribute13
440: ,p_attribute14_o
441: => ota_tpc_shd.g_old_rec.attribute14
442: ,p_attribute15_o
443: => ota_tpc_shd.g_old_rec.attribute15
437: => ota_tpc_shd.g_old_rec.attribute12
438: ,p_attribute13_o
439: => ota_tpc_shd.g_old_rec.attribute13
440: ,p_attribute14_o
441: => ota_tpc_shd.g_old_rec.attribute14
442: ,p_attribute15_o
443: => ota_tpc_shd.g_old_rec.attribute15
444: ,p_attribute16_o
445: => ota_tpc_shd.g_old_rec.attribute16
439: => ota_tpc_shd.g_old_rec.attribute13
440: ,p_attribute14_o
441: => ota_tpc_shd.g_old_rec.attribute14
442: ,p_attribute15_o
443: => ota_tpc_shd.g_old_rec.attribute15
444: ,p_attribute16_o
445: => ota_tpc_shd.g_old_rec.attribute16
446: ,p_attribute17_o
447: => ota_tpc_shd.g_old_rec.attribute17
441: => ota_tpc_shd.g_old_rec.attribute14
442: ,p_attribute15_o
443: => ota_tpc_shd.g_old_rec.attribute15
444: ,p_attribute16_o
445: => ota_tpc_shd.g_old_rec.attribute16
446: ,p_attribute17_o
447: => ota_tpc_shd.g_old_rec.attribute17
448: ,p_attribute18_o
449: => ota_tpc_shd.g_old_rec.attribute18
443: => ota_tpc_shd.g_old_rec.attribute15
444: ,p_attribute16_o
445: => ota_tpc_shd.g_old_rec.attribute16
446: ,p_attribute17_o
447: => ota_tpc_shd.g_old_rec.attribute17
448: ,p_attribute18_o
449: => ota_tpc_shd.g_old_rec.attribute18
450: ,p_attribute19_o
451: => ota_tpc_shd.g_old_rec.attribute19
445: => ota_tpc_shd.g_old_rec.attribute16
446: ,p_attribute17_o
447: => ota_tpc_shd.g_old_rec.attribute17
448: ,p_attribute18_o
449: => ota_tpc_shd.g_old_rec.attribute18
450: ,p_attribute19_o
451: => ota_tpc_shd.g_old_rec.attribute19
452: ,p_attribute20_o
453: => ota_tpc_shd.g_old_rec.attribute20
447: => ota_tpc_shd.g_old_rec.attribute17
448: ,p_attribute18_o
449: => ota_tpc_shd.g_old_rec.attribute18
450: ,p_attribute19_o
451: => ota_tpc_shd.g_old_rec.attribute19
452: ,p_attribute20_o
453: => ota_tpc_shd.g_old_rec.attribute20
454: ,p_attribute21_o
455: => ota_tpc_shd.g_old_rec.attribute21
449: => ota_tpc_shd.g_old_rec.attribute18
450: ,p_attribute19_o
451: => ota_tpc_shd.g_old_rec.attribute19
452: ,p_attribute20_o
453: => ota_tpc_shd.g_old_rec.attribute20
454: ,p_attribute21_o
455: => ota_tpc_shd.g_old_rec.attribute21
456: ,p_attribute22_o
457: => ota_tpc_shd.g_old_rec.attribute22
451: => ota_tpc_shd.g_old_rec.attribute19
452: ,p_attribute20_o
453: => ota_tpc_shd.g_old_rec.attribute20
454: ,p_attribute21_o
455: => ota_tpc_shd.g_old_rec.attribute21
456: ,p_attribute22_o
457: => ota_tpc_shd.g_old_rec.attribute22
458: ,p_attribute23_o
459: => ota_tpc_shd.g_old_rec.attribute23
453: => ota_tpc_shd.g_old_rec.attribute20
454: ,p_attribute21_o
455: => ota_tpc_shd.g_old_rec.attribute21
456: ,p_attribute22_o
457: => ota_tpc_shd.g_old_rec.attribute22
458: ,p_attribute23_o
459: => ota_tpc_shd.g_old_rec.attribute23
460: ,p_attribute24_o
461: => ota_tpc_shd.g_old_rec.attribute24
455: => ota_tpc_shd.g_old_rec.attribute21
456: ,p_attribute22_o
457: => ota_tpc_shd.g_old_rec.attribute22
458: ,p_attribute23_o
459: => ota_tpc_shd.g_old_rec.attribute23
460: ,p_attribute24_o
461: => ota_tpc_shd.g_old_rec.attribute24
462: ,p_attribute25_o
463: => ota_tpc_shd.g_old_rec.attribute25
457: => ota_tpc_shd.g_old_rec.attribute22
458: ,p_attribute23_o
459: => ota_tpc_shd.g_old_rec.attribute23
460: ,p_attribute24_o
461: => ota_tpc_shd.g_old_rec.attribute24
462: ,p_attribute25_o
463: => ota_tpc_shd.g_old_rec.attribute25
464: ,p_attribute26_o
465: => ota_tpc_shd.g_old_rec.attribute26
459: => ota_tpc_shd.g_old_rec.attribute23
460: ,p_attribute24_o
461: => ota_tpc_shd.g_old_rec.attribute24
462: ,p_attribute25_o
463: => ota_tpc_shd.g_old_rec.attribute25
464: ,p_attribute26_o
465: => ota_tpc_shd.g_old_rec.attribute26
466: ,p_attribute27_o
467: => ota_tpc_shd.g_old_rec.attribute27
461: => ota_tpc_shd.g_old_rec.attribute24
462: ,p_attribute25_o
463: => ota_tpc_shd.g_old_rec.attribute25
464: ,p_attribute26_o
465: => ota_tpc_shd.g_old_rec.attribute26
466: ,p_attribute27_o
467: => ota_tpc_shd.g_old_rec.attribute27
468: ,p_attribute28_o
469: => ota_tpc_shd.g_old_rec.attribute28
463: => ota_tpc_shd.g_old_rec.attribute25
464: ,p_attribute26_o
465: => ota_tpc_shd.g_old_rec.attribute26
466: ,p_attribute27_o
467: => ota_tpc_shd.g_old_rec.attribute27
468: ,p_attribute28_o
469: => ota_tpc_shd.g_old_rec.attribute28
470: ,p_attribute29_o
471: => ota_tpc_shd.g_old_rec.attribute29
465: => ota_tpc_shd.g_old_rec.attribute26
466: ,p_attribute27_o
467: => ota_tpc_shd.g_old_rec.attribute27
468: ,p_attribute28_o
469: => ota_tpc_shd.g_old_rec.attribute28
470: ,p_attribute29_o
471: => ota_tpc_shd.g_old_rec.attribute29
472: ,p_attribute30_o
473: => ota_tpc_shd.g_old_rec.attribute30
467: => ota_tpc_shd.g_old_rec.attribute27
468: ,p_attribute28_o
469: => ota_tpc_shd.g_old_rec.attribute28
470: ,p_attribute29_o
471: => ota_tpc_shd.g_old_rec.attribute29
472: ,p_attribute30_o
473: => ota_tpc_shd.g_old_rec.attribute30
474: ,p_information_category_o
475: => ota_tpc_shd.g_old_rec.information_category
469: => ota_tpc_shd.g_old_rec.attribute28
470: ,p_attribute29_o
471: => ota_tpc_shd.g_old_rec.attribute29
472: ,p_attribute30_o
473: => ota_tpc_shd.g_old_rec.attribute30
474: ,p_information_category_o
475: => ota_tpc_shd.g_old_rec.information_category
476: ,p_tp_cost_information1_o
477: => ota_tpc_shd.g_old_rec.tp_cost_information1
471: => ota_tpc_shd.g_old_rec.attribute29
472: ,p_attribute30_o
473: => ota_tpc_shd.g_old_rec.attribute30
474: ,p_information_category_o
475: => ota_tpc_shd.g_old_rec.information_category
476: ,p_tp_cost_information1_o
477: => ota_tpc_shd.g_old_rec.tp_cost_information1
478: ,p_tp_cost_information2_o
479: => ota_tpc_shd.g_old_rec.tp_cost_information2
473: => ota_tpc_shd.g_old_rec.attribute30
474: ,p_information_category_o
475: => ota_tpc_shd.g_old_rec.information_category
476: ,p_tp_cost_information1_o
477: => ota_tpc_shd.g_old_rec.tp_cost_information1
478: ,p_tp_cost_information2_o
479: => ota_tpc_shd.g_old_rec.tp_cost_information2
480: ,p_tp_cost_information3_o
481: => ota_tpc_shd.g_old_rec.tp_cost_information3
475: => ota_tpc_shd.g_old_rec.information_category
476: ,p_tp_cost_information1_o
477: => ota_tpc_shd.g_old_rec.tp_cost_information1
478: ,p_tp_cost_information2_o
479: => ota_tpc_shd.g_old_rec.tp_cost_information2
480: ,p_tp_cost_information3_o
481: => ota_tpc_shd.g_old_rec.tp_cost_information3
482: ,p_tp_cost_information4_o
483: => ota_tpc_shd.g_old_rec.tp_cost_information4
477: => ota_tpc_shd.g_old_rec.tp_cost_information1
478: ,p_tp_cost_information2_o
479: => ota_tpc_shd.g_old_rec.tp_cost_information2
480: ,p_tp_cost_information3_o
481: => ota_tpc_shd.g_old_rec.tp_cost_information3
482: ,p_tp_cost_information4_o
483: => ota_tpc_shd.g_old_rec.tp_cost_information4
484: ,p_tp_cost_information5_o
485: => ota_tpc_shd.g_old_rec.tp_cost_information5
479: => ota_tpc_shd.g_old_rec.tp_cost_information2
480: ,p_tp_cost_information3_o
481: => ota_tpc_shd.g_old_rec.tp_cost_information3
482: ,p_tp_cost_information4_o
483: => ota_tpc_shd.g_old_rec.tp_cost_information4
484: ,p_tp_cost_information5_o
485: => ota_tpc_shd.g_old_rec.tp_cost_information5
486: ,p_tp_cost_information6_o
487: => ota_tpc_shd.g_old_rec.tp_cost_information6
481: => ota_tpc_shd.g_old_rec.tp_cost_information3
482: ,p_tp_cost_information4_o
483: => ota_tpc_shd.g_old_rec.tp_cost_information4
484: ,p_tp_cost_information5_o
485: => ota_tpc_shd.g_old_rec.tp_cost_information5
486: ,p_tp_cost_information6_o
487: => ota_tpc_shd.g_old_rec.tp_cost_information6
488: ,p_tp_cost_information7_o
489: => ota_tpc_shd.g_old_rec.tp_cost_information7
483: => ota_tpc_shd.g_old_rec.tp_cost_information4
484: ,p_tp_cost_information5_o
485: => ota_tpc_shd.g_old_rec.tp_cost_information5
486: ,p_tp_cost_information6_o
487: => ota_tpc_shd.g_old_rec.tp_cost_information6
488: ,p_tp_cost_information7_o
489: => ota_tpc_shd.g_old_rec.tp_cost_information7
490: ,p_tp_cost_information8_o
491: => ota_tpc_shd.g_old_rec.tp_cost_information8
485: => ota_tpc_shd.g_old_rec.tp_cost_information5
486: ,p_tp_cost_information6_o
487: => ota_tpc_shd.g_old_rec.tp_cost_information6
488: ,p_tp_cost_information7_o
489: => ota_tpc_shd.g_old_rec.tp_cost_information7
490: ,p_tp_cost_information8_o
491: => ota_tpc_shd.g_old_rec.tp_cost_information8
492: ,p_tp_cost_information9_o
493: => ota_tpc_shd.g_old_rec.tp_cost_information9
487: => ota_tpc_shd.g_old_rec.tp_cost_information6
488: ,p_tp_cost_information7_o
489: => ota_tpc_shd.g_old_rec.tp_cost_information7
490: ,p_tp_cost_information8_o
491: => ota_tpc_shd.g_old_rec.tp_cost_information8
492: ,p_tp_cost_information9_o
493: => ota_tpc_shd.g_old_rec.tp_cost_information9
494: ,p_tp_cost_information10_o
495: => ota_tpc_shd.g_old_rec.tp_cost_information10
489: => ota_tpc_shd.g_old_rec.tp_cost_information7
490: ,p_tp_cost_information8_o
491: => ota_tpc_shd.g_old_rec.tp_cost_information8
492: ,p_tp_cost_information9_o
493: => ota_tpc_shd.g_old_rec.tp_cost_information9
494: ,p_tp_cost_information10_o
495: => ota_tpc_shd.g_old_rec.tp_cost_information10
496: ,p_tp_cost_information11_o
497: => ota_tpc_shd.g_old_rec.tp_cost_information11
491: => ota_tpc_shd.g_old_rec.tp_cost_information8
492: ,p_tp_cost_information9_o
493: => ota_tpc_shd.g_old_rec.tp_cost_information9
494: ,p_tp_cost_information10_o
495: => ota_tpc_shd.g_old_rec.tp_cost_information10
496: ,p_tp_cost_information11_o
497: => ota_tpc_shd.g_old_rec.tp_cost_information11
498: ,p_tp_cost_information12_o
499: => ota_tpc_shd.g_old_rec.tp_cost_information12
493: => ota_tpc_shd.g_old_rec.tp_cost_information9
494: ,p_tp_cost_information10_o
495: => ota_tpc_shd.g_old_rec.tp_cost_information10
496: ,p_tp_cost_information11_o
497: => ota_tpc_shd.g_old_rec.tp_cost_information11
498: ,p_tp_cost_information12_o
499: => ota_tpc_shd.g_old_rec.tp_cost_information12
500: ,p_tp_cost_information13_o
501: => ota_tpc_shd.g_old_rec.tp_cost_information13
495: => ota_tpc_shd.g_old_rec.tp_cost_information10
496: ,p_tp_cost_information11_o
497: => ota_tpc_shd.g_old_rec.tp_cost_information11
498: ,p_tp_cost_information12_o
499: => ota_tpc_shd.g_old_rec.tp_cost_information12
500: ,p_tp_cost_information13_o
501: => ota_tpc_shd.g_old_rec.tp_cost_information13
502: ,p_tp_cost_information14_o
503: => ota_tpc_shd.g_old_rec.tp_cost_information14
497: => ota_tpc_shd.g_old_rec.tp_cost_information11
498: ,p_tp_cost_information12_o
499: => ota_tpc_shd.g_old_rec.tp_cost_information12
500: ,p_tp_cost_information13_o
501: => ota_tpc_shd.g_old_rec.tp_cost_information13
502: ,p_tp_cost_information14_o
503: => ota_tpc_shd.g_old_rec.tp_cost_information14
504: ,p_tp_cost_information15_o
505: => ota_tpc_shd.g_old_rec.tp_cost_information15
499: => ota_tpc_shd.g_old_rec.tp_cost_information12
500: ,p_tp_cost_information13_o
501: => ota_tpc_shd.g_old_rec.tp_cost_information13
502: ,p_tp_cost_information14_o
503: => ota_tpc_shd.g_old_rec.tp_cost_information14
504: ,p_tp_cost_information15_o
505: => ota_tpc_shd.g_old_rec.tp_cost_information15
506: ,p_tp_cost_information16_o
507: => ota_tpc_shd.g_old_rec.tp_cost_information16
501: => ota_tpc_shd.g_old_rec.tp_cost_information13
502: ,p_tp_cost_information14_o
503: => ota_tpc_shd.g_old_rec.tp_cost_information14
504: ,p_tp_cost_information15_o
505: => ota_tpc_shd.g_old_rec.tp_cost_information15
506: ,p_tp_cost_information16_o
507: => ota_tpc_shd.g_old_rec.tp_cost_information16
508: ,p_tp_cost_information17_o
509: => ota_tpc_shd.g_old_rec.tp_cost_information17
503: => ota_tpc_shd.g_old_rec.tp_cost_information14
504: ,p_tp_cost_information15_o
505: => ota_tpc_shd.g_old_rec.tp_cost_information15
506: ,p_tp_cost_information16_o
507: => ota_tpc_shd.g_old_rec.tp_cost_information16
508: ,p_tp_cost_information17_o
509: => ota_tpc_shd.g_old_rec.tp_cost_information17
510: ,p_tp_cost_information18_o
511: => ota_tpc_shd.g_old_rec.tp_cost_information18
505: => ota_tpc_shd.g_old_rec.tp_cost_information15
506: ,p_tp_cost_information16_o
507: => ota_tpc_shd.g_old_rec.tp_cost_information16
508: ,p_tp_cost_information17_o
509: => ota_tpc_shd.g_old_rec.tp_cost_information17
510: ,p_tp_cost_information18_o
511: => ota_tpc_shd.g_old_rec.tp_cost_information18
512: ,p_tp_cost_information19_o
513: => ota_tpc_shd.g_old_rec.tp_cost_information19
507: => ota_tpc_shd.g_old_rec.tp_cost_information16
508: ,p_tp_cost_information17_o
509: => ota_tpc_shd.g_old_rec.tp_cost_information17
510: ,p_tp_cost_information18_o
511: => ota_tpc_shd.g_old_rec.tp_cost_information18
512: ,p_tp_cost_information19_o
513: => ota_tpc_shd.g_old_rec.tp_cost_information19
514: ,p_tp_cost_information20_o
515: => ota_tpc_shd.g_old_rec.tp_cost_information20
509: => ota_tpc_shd.g_old_rec.tp_cost_information17
510: ,p_tp_cost_information18_o
511: => ota_tpc_shd.g_old_rec.tp_cost_information18
512: ,p_tp_cost_information19_o
513: => ota_tpc_shd.g_old_rec.tp_cost_information19
514: ,p_tp_cost_information20_o
515: => ota_tpc_shd.g_old_rec.tp_cost_information20
516: ,p_tp_cost_information21_o
517: => ota_tpc_shd.g_old_rec.tp_cost_information21
511: => ota_tpc_shd.g_old_rec.tp_cost_information18
512: ,p_tp_cost_information19_o
513: => ota_tpc_shd.g_old_rec.tp_cost_information19
514: ,p_tp_cost_information20_o
515: => ota_tpc_shd.g_old_rec.tp_cost_information20
516: ,p_tp_cost_information21_o
517: => ota_tpc_shd.g_old_rec.tp_cost_information21
518: ,p_tp_cost_information22_o
519: => ota_tpc_shd.g_old_rec.tp_cost_information22
513: => ota_tpc_shd.g_old_rec.tp_cost_information19
514: ,p_tp_cost_information20_o
515: => ota_tpc_shd.g_old_rec.tp_cost_information20
516: ,p_tp_cost_information21_o
517: => ota_tpc_shd.g_old_rec.tp_cost_information21
518: ,p_tp_cost_information22_o
519: => ota_tpc_shd.g_old_rec.tp_cost_information22
520: ,p_tp_cost_information23_o
521: => ota_tpc_shd.g_old_rec.tp_cost_information23
515: => ota_tpc_shd.g_old_rec.tp_cost_information20
516: ,p_tp_cost_information21_o
517: => ota_tpc_shd.g_old_rec.tp_cost_information21
518: ,p_tp_cost_information22_o
519: => ota_tpc_shd.g_old_rec.tp_cost_information22
520: ,p_tp_cost_information23_o
521: => ota_tpc_shd.g_old_rec.tp_cost_information23
522: ,p_tp_cost_information24_o
523: => ota_tpc_shd.g_old_rec.tp_cost_information24
517: => ota_tpc_shd.g_old_rec.tp_cost_information21
518: ,p_tp_cost_information22_o
519: => ota_tpc_shd.g_old_rec.tp_cost_information22
520: ,p_tp_cost_information23_o
521: => ota_tpc_shd.g_old_rec.tp_cost_information23
522: ,p_tp_cost_information24_o
523: => ota_tpc_shd.g_old_rec.tp_cost_information24
524: ,p_tp_cost_information25_o
525: => ota_tpc_shd.g_old_rec.tp_cost_information25
519: => ota_tpc_shd.g_old_rec.tp_cost_information22
520: ,p_tp_cost_information23_o
521: => ota_tpc_shd.g_old_rec.tp_cost_information23
522: ,p_tp_cost_information24_o
523: => ota_tpc_shd.g_old_rec.tp_cost_information24
524: ,p_tp_cost_information25_o
525: => ota_tpc_shd.g_old_rec.tp_cost_information25
526: ,p_tp_cost_information26_o
527: => ota_tpc_shd.g_old_rec.tp_cost_information26
521: => ota_tpc_shd.g_old_rec.tp_cost_information23
522: ,p_tp_cost_information24_o
523: => ota_tpc_shd.g_old_rec.tp_cost_information24
524: ,p_tp_cost_information25_o
525: => ota_tpc_shd.g_old_rec.tp_cost_information25
526: ,p_tp_cost_information26_o
527: => ota_tpc_shd.g_old_rec.tp_cost_information26
528: ,p_tp_cost_information27_o
529: => ota_tpc_shd.g_old_rec.tp_cost_information27
523: => ota_tpc_shd.g_old_rec.tp_cost_information24
524: ,p_tp_cost_information25_o
525: => ota_tpc_shd.g_old_rec.tp_cost_information25
526: ,p_tp_cost_information26_o
527: => ota_tpc_shd.g_old_rec.tp_cost_information26
528: ,p_tp_cost_information27_o
529: => ota_tpc_shd.g_old_rec.tp_cost_information27
530: ,p_tp_cost_information28_o
531: => ota_tpc_shd.g_old_rec.tp_cost_information28
525: => ota_tpc_shd.g_old_rec.tp_cost_information25
526: ,p_tp_cost_information26_o
527: => ota_tpc_shd.g_old_rec.tp_cost_information26
528: ,p_tp_cost_information27_o
529: => ota_tpc_shd.g_old_rec.tp_cost_information27
530: ,p_tp_cost_information28_o
531: => ota_tpc_shd.g_old_rec.tp_cost_information28
532: ,p_tp_cost_information29_o
533: => ota_tpc_shd.g_old_rec.tp_cost_information29
527: => ota_tpc_shd.g_old_rec.tp_cost_information26
528: ,p_tp_cost_information27_o
529: => ota_tpc_shd.g_old_rec.tp_cost_information27
530: ,p_tp_cost_information28_o
531: => ota_tpc_shd.g_old_rec.tp_cost_information28
532: ,p_tp_cost_information29_o
533: => ota_tpc_shd.g_old_rec.tp_cost_information29
534: ,p_tp_cost_information30_o
535: => ota_tpc_shd.g_old_rec.tp_cost_information30
529: => ota_tpc_shd.g_old_rec.tp_cost_information27
530: ,p_tp_cost_information28_o
531: => ota_tpc_shd.g_old_rec.tp_cost_information28
532: ,p_tp_cost_information29_o
533: => ota_tpc_shd.g_old_rec.tp_cost_information29
534: ,p_tp_cost_information30_o
535: => ota_tpc_shd.g_old_rec.tp_cost_information30
536: );
537: --
531: => ota_tpc_shd.g_old_rec.tp_cost_information28
532: ,p_tp_cost_information29_o
533: => ota_tpc_shd.g_old_rec.tp_cost_information29
534: ,p_tp_cost_information30_o
535: => ota_tpc_shd.g_old_rec.tp_cost_information30
536: );
537: --
538: exception
539: --
591: --
592: -- {End Of Comments}
593: -- ----------------------------------------------------------------------------
594: Procedure convert_defs
595: (p_rec in out nocopy ota_tpc_shd.g_rec_type
596: ) is
597: --
598: Begin
599: --
603: -- is being used then we must set to the 'current' argument value.
604: --
605: If (p_rec.tp_measurement_type_id = hr_api.g_number) then
606: p_rec.tp_measurement_type_id :=
607: ota_tpc_shd.g_old_rec.tp_measurement_type_id;
608: End If;
609: If (p_rec.training_plan_id = hr_api.g_number) then
610: p_rec.training_plan_id :=
611: ota_tpc_shd.g_old_rec.training_plan_id;
607: ota_tpc_shd.g_old_rec.tp_measurement_type_id;
608: End If;
609: If (p_rec.training_plan_id = hr_api.g_number) then
610: p_rec.training_plan_id :=
611: ota_tpc_shd.g_old_rec.training_plan_id;
612: End If;
613: If (p_rec.booking_id = hr_api.g_number) then
614: p_rec.booking_id :=
615: ota_tpc_shd.g_old_rec.booking_id;
611: ota_tpc_shd.g_old_rec.training_plan_id;
612: End If;
613: If (p_rec.booking_id = hr_api.g_number) then
614: p_rec.booking_id :=
615: ota_tpc_shd.g_old_rec.booking_id;
616: End If;
617: If (p_rec.event_id = hr_api.g_number) then
618: p_rec.event_id :=
619: ota_tpc_shd.g_old_rec.event_id;
615: ota_tpc_shd.g_old_rec.booking_id;
616: End If;
617: If (p_rec.event_id = hr_api.g_number) then
618: p_rec.event_id :=
619: ota_tpc_shd.g_old_rec.event_id;
620: End If;
621: If (p_rec.amount = hr_api.g_number) then
622: p_rec.amount :=
623: ota_tpc_shd.g_old_rec.amount;
619: ota_tpc_shd.g_old_rec.event_id;
620: End If;
621: If (p_rec.amount = hr_api.g_number) then
622: p_rec.amount :=
623: ota_tpc_shd.g_old_rec.amount;
624: End If;
625: If (p_rec.currency_code = hr_api.g_varchar2) then
626: p_rec.currency_code :=
627: ota_tpc_shd.g_old_rec.currency_code;
623: ota_tpc_shd.g_old_rec.amount;
624: End If;
625: If (p_rec.currency_code = hr_api.g_varchar2) then
626: p_rec.currency_code :=
627: ota_tpc_shd.g_old_rec.currency_code;
628: End If;
629: If (p_rec.business_group_id = hr_api.g_number) then
630: p_rec.business_group_id :=
631: ota_tpc_shd.g_old_rec.business_group_id;
627: ota_tpc_shd.g_old_rec.currency_code;
628: End If;
629: If (p_rec.business_group_id = hr_api.g_number) then
630: p_rec.business_group_id :=
631: ota_tpc_shd.g_old_rec.business_group_id;
632: End If;
633: If (p_rec.attribute_category = hr_api.g_varchar2) then
634: p_rec.attribute_category :=
635: ota_tpc_shd.g_old_rec.attribute_category;
631: ota_tpc_shd.g_old_rec.business_group_id;
632: End If;
633: If (p_rec.attribute_category = hr_api.g_varchar2) then
634: p_rec.attribute_category :=
635: ota_tpc_shd.g_old_rec.attribute_category;
636: End If;
637: If (p_rec.attribute1 = hr_api.g_varchar2) then
638: p_rec.attribute1 :=
639: ota_tpc_shd.g_old_rec.attribute1;
635: ota_tpc_shd.g_old_rec.attribute_category;
636: End If;
637: If (p_rec.attribute1 = hr_api.g_varchar2) then
638: p_rec.attribute1 :=
639: ota_tpc_shd.g_old_rec.attribute1;
640: End If;
641: If (p_rec.attribute2 = hr_api.g_varchar2) then
642: p_rec.attribute2 :=
643: ota_tpc_shd.g_old_rec.attribute2;
639: ota_tpc_shd.g_old_rec.attribute1;
640: End If;
641: If (p_rec.attribute2 = hr_api.g_varchar2) then
642: p_rec.attribute2 :=
643: ota_tpc_shd.g_old_rec.attribute2;
644: End If;
645: If (p_rec.attribute3 = hr_api.g_varchar2) then
646: p_rec.attribute3 :=
647: ota_tpc_shd.g_old_rec.attribute3;
643: ota_tpc_shd.g_old_rec.attribute2;
644: End If;
645: If (p_rec.attribute3 = hr_api.g_varchar2) then
646: p_rec.attribute3 :=
647: ota_tpc_shd.g_old_rec.attribute3;
648: End If;
649: If (p_rec.attribute4 = hr_api.g_varchar2) then
650: p_rec.attribute4 :=
651: ota_tpc_shd.g_old_rec.attribute4;
647: ota_tpc_shd.g_old_rec.attribute3;
648: End If;
649: If (p_rec.attribute4 = hr_api.g_varchar2) then
650: p_rec.attribute4 :=
651: ota_tpc_shd.g_old_rec.attribute4;
652: End If;
653: If (p_rec.attribute5 = hr_api.g_varchar2) then
654: p_rec.attribute5 :=
655: ota_tpc_shd.g_old_rec.attribute5;
651: ota_tpc_shd.g_old_rec.attribute4;
652: End If;
653: If (p_rec.attribute5 = hr_api.g_varchar2) then
654: p_rec.attribute5 :=
655: ota_tpc_shd.g_old_rec.attribute5;
656: End If;
657: If (p_rec.attribute6 = hr_api.g_varchar2) then
658: p_rec.attribute6 :=
659: ota_tpc_shd.g_old_rec.attribute6;
655: ota_tpc_shd.g_old_rec.attribute5;
656: End If;
657: If (p_rec.attribute6 = hr_api.g_varchar2) then
658: p_rec.attribute6 :=
659: ota_tpc_shd.g_old_rec.attribute6;
660: End If;
661: If (p_rec.attribute7 = hr_api.g_varchar2) then
662: p_rec.attribute7 :=
663: ota_tpc_shd.g_old_rec.attribute7;
659: ota_tpc_shd.g_old_rec.attribute6;
660: End If;
661: If (p_rec.attribute7 = hr_api.g_varchar2) then
662: p_rec.attribute7 :=
663: ota_tpc_shd.g_old_rec.attribute7;
664: End If;
665: If (p_rec.attribute8 = hr_api.g_varchar2) then
666: p_rec.attribute8 :=
667: ota_tpc_shd.g_old_rec.attribute8;
663: ota_tpc_shd.g_old_rec.attribute7;
664: End If;
665: If (p_rec.attribute8 = hr_api.g_varchar2) then
666: p_rec.attribute8 :=
667: ota_tpc_shd.g_old_rec.attribute8;
668: End If;
669: If (p_rec.attribute9 = hr_api.g_varchar2) then
670: p_rec.attribute9 :=
671: ota_tpc_shd.g_old_rec.attribute9;
667: ota_tpc_shd.g_old_rec.attribute8;
668: End If;
669: If (p_rec.attribute9 = hr_api.g_varchar2) then
670: p_rec.attribute9 :=
671: ota_tpc_shd.g_old_rec.attribute9;
672: End If;
673: If (p_rec.attribute10 = hr_api.g_varchar2) then
674: p_rec.attribute10 :=
675: ota_tpc_shd.g_old_rec.attribute10;
671: ota_tpc_shd.g_old_rec.attribute9;
672: End If;
673: If (p_rec.attribute10 = hr_api.g_varchar2) then
674: p_rec.attribute10 :=
675: ota_tpc_shd.g_old_rec.attribute10;
676: End If;
677: If (p_rec.attribute11 = hr_api.g_varchar2) then
678: p_rec.attribute11 :=
679: ota_tpc_shd.g_old_rec.attribute11;
675: ota_tpc_shd.g_old_rec.attribute10;
676: End If;
677: If (p_rec.attribute11 = hr_api.g_varchar2) then
678: p_rec.attribute11 :=
679: ota_tpc_shd.g_old_rec.attribute11;
680: End If;
681: If (p_rec.attribute12 = hr_api.g_varchar2) then
682: p_rec.attribute12 :=
683: ota_tpc_shd.g_old_rec.attribute12;
679: ota_tpc_shd.g_old_rec.attribute11;
680: End If;
681: If (p_rec.attribute12 = hr_api.g_varchar2) then
682: p_rec.attribute12 :=
683: ota_tpc_shd.g_old_rec.attribute12;
684: End If;
685: If (p_rec.attribute13 = hr_api.g_varchar2) then
686: p_rec.attribute13 :=
687: ota_tpc_shd.g_old_rec.attribute13;
683: ota_tpc_shd.g_old_rec.attribute12;
684: End If;
685: If (p_rec.attribute13 = hr_api.g_varchar2) then
686: p_rec.attribute13 :=
687: ota_tpc_shd.g_old_rec.attribute13;
688: End If;
689: If (p_rec.attribute14 = hr_api.g_varchar2) then
690: p_rec.attribute14 :=
691: ota_tpc_shd.g_old_rec.attribute14;
687: ota_tpc_shd.g_old_rec.attribute13;
688: End If;
689: If (p_rec.attribute14 = hr_api.g_varchar2) then
690: p_rec.attribute14 :=
691: ota_tpc_shd.g_old_rec.attribute14;
692: End If;
693: If (p_rec.attribute15 = hr_api.g_varchar2) then
694: p_rec.attribute15 :=
695: ota_tpc_shd.g_old_rec.attribute15;
691: ota_tpc_shd.g_old_rec.attribute14;
692: End If;
693: If (p_rec.attribute15 = hr_api.g_varchar2) then
694: p_rec.attribute15 :=
695: ota_tpc_shd.g_old_rec.attribute15;
696: End If;
697: If (p_rec.attribute16 = hr_api.g_varchar2) then
698: p_rec.attribute16 :=
699: ota_tpc_shd.g_old_rec.attribute16;
695: ota_tpc_shd.g_old_rec.attribute15;
696: End If;
697: If (p_rec.attribute16 = hr_api.g_varchar2) then
698: p_rec.attribute16 :=
699: ota_tpc_shd.g_old_rec.attribute16;
700: End If;
701: If (p_rec.attribute17 = hr_api.g_varchar2) then
702: p_rec.attribute17 :=
703: ota_tpc_shd.g_old_rec.attribute17;
699: ota_tpc_shd.g_old_rec.attribute16;
700: End If;
701: If (p_rec.attribute17 = hr_api.g_varchar2) then
702: p_rec.attribute17 :=
703: ota_tpc_shd.g_old_rec.attribute17;
704: End If;
705: If (p_rec.attribute18 = hr_api.g_varchar2) then
706: p_rec.attribute18 :=
707: ota_tpc_shd.g_old_rec.attribute18;
703: ota_tpc_shd.g_old_rec.attribute17;
704: End If;
705: If (p_rec.attribute18 = hr_api.g_varchar2) then
706: p_rec.attribute18 :=
707: ota_tpc_shd.g_old_rec.attribute18;
708: End If;
709: If (p_rec.attribute19 = hr_api.g_varchar2) then
710: p_rec.attribute19 :=
711: ota_tpc_shd.g_old_rec.attribute19;
707: ota_tpc_shd.g_old_rec.attribute18;
708: End If;
709: If (p_rec.attribute19 = hr_api.g_varchar2) then
710: p_rec.attribute19 :=
711: ota_tpc_shd.g_old_rec.attribute19;
712: End If;
713: If (p_rec.attribute20 = hr_api.g_varchar2) then
714: p_rec.attribute20 :=
715: ota_tpc_shd.g_old_rec.attribute20;
711: ota_tpc_shd.g_old_rec.attribute19;
712: End If;
713: If (p_rec.attribute20 = hr_api.g_varchar2) then
714: p_rec.attribute20 :=
715: ota_tpc_shd.g_old_rec.attribute20;
716: End If;
717: If (p_rec.attribute21 = hr_api.g_varchar2) then
718: p_rec.attribute21 :=
719: ota_tpc_shd.g_old_rec.attribute21;
715: ota_tpc_shd.g_old_rec.attribute20;
716: End If;
717: If (p_rec.attribute21 = hr_api.g_varchar2) then
718: p_rec.attribute21 :=
719: ota_tpc_shd.g_old_rec.attribute21;
720: End If;
721: If (p_rec.attribute22 = hr_api.g_varchar2) then
722: p_rec.attribute22 :=
723: ota_tpc_shd.g_old_rec.attribute22;
719: ota_tpc_shd.g_old_rec.attribute21;
720: End If;
721: If (p_rec.attribute22 = hr_api.g_varchar2) then
722: p_rec.attribute22 :=
723: ota_tpc_shd.g_old_rec.attribute22;
724: End If;
725: If (p_rec.attribute23 = hr_api.g_varchar2) then
726: p_rec.attribute23 :=
727: ota_tpc_shd.g_old_rec.attribute23;
723: ota_tpc_shd.g_old_rec.attribute22;
724: End If;
725: If (p_rec.attribute23 = hr_api.g_varchar2) then
726: p_rec.attribute23 :=
727: ota_tpc_shd.g_old_rec.attribute23;
728: End If;
729: If (p_rec.attribute24 = hr_api.g_varchar2) then
730: p_rec.attribute24 :=
731: ota_tpc_shd.g_old_rec.attribute24;
727: ota_tpc_shd.g_old_rec.attribute23;
728: End If;
729: If (p_rec.attribute24 = hr_api.g_varchar2) then
730: p_rec.attribute24 :=
731: ota_tpc_shd.g_old_rec.attribute24;
732: End If;
733: If (p_rec.attribute25 = hr_api.g_varchar2) then
734: p_rec.attribute25 :=
735: ota_tpc_shd.g_old_rec.attribute25;
731: ota_tpc_shd.g_old_rec.attribute24;
732: End If;
733: If (p_rec.attribute25 = hr_api.g_varchar2) then
734: p_rec.attribute25 :=
735: ota_tpc_shd.g_old_rec.attribute25;
736: End If;
737: If (p_rec.attribute26 = hr_api.g_varchar2) then
738: p_rec.attribute26 :=
739: ota_tpc_shd.g_old_rec.attribute26;
735: ota_tpc_shd.g_old_rec.attribute25;
736: End If;
737: If (p_rec.attribute26 = hr_api.g_varchar2) then
738: p_rec.attribute26 :=
739: ota_tpc_shd.g_old_rec.attribute26;
740: End If;
741: If (p_rec.attribute27 = hr_api.g_varchar2) then
742: p_rec.attribute27 :=
743: ota_tpc_shd.g_old_rec.attribute27;
739: ota_tpc_shd.g_old_rec.attribute26;
740: End If;
741: If (p_rec.attribute27 = hr_api.g_varchar2) then
742: p_rec.attribute27 :=
743: ota_tpc_shd.g_old_rec.attribute27;
744: End If;
745: If (p_rec.attribute28 = hr_api.g_varchar2) then
746: p_rec.attribute28 :=
747: ota_tpc_shd.g_old_rec.attribute28;
743: ota_tpc_shd.g_old_rec.attribute27;
744: End If;
745: If (p_rec.attribute28 = hr_api.g_varchar2) then
746: p_rec.attribute28 :=
747: ota_tpc_shd.g_old_rec.attribute28;
748: End If;
749: If (p_rec.attribute29 = hr_api.g_varchar2) then
750: p_rec.attribute29 :=
751: ota_tpc_shd.g_old_rec.attribute29;
747: ota_tpc_shd.g_old_rec.attribute28;
748: End If;
749: If (p_rec.attribute29 = hr_api.g_varchar2) then
750: p_rec.attribute29 :=
751: ota_tpc_shd.g_old_rec.attribute29;
752: End If;
753: If (p_rec.attribute30 = hr_api.g_varchar2) then
754: p_rec.attribute30 :=
755: ota_tpc_shd.g_old_rec.attribute30;
751: ota_tpc_shd.g_old_rec.attribute29;
752: End If;
753: If (p_rec.attribute30 = hr_api.g_varchar2) then
754: p_rec.attribute30 :=
755: ota_tpc_shd.g_old_rec.attribute30;
756: End If;
757: If (p_rec.information_category = hr_api.g_varchar2) then
758: p_rec.information_category :=
759: ota_tpc_shd.g_old_rec.information_category;
755: ota_tpc_shd.g_old_rec.attribute30;
756: End If;
757: If (p_rec.information_category = hr_api.g_varchar2) then
758: p_rec.information_category :=
759: ota_tpc_shd.g_old_rec.information_category;
760: End If;
761: If (p_rec.tp_cost_information1 = hr_api.g_varchar2) then
762: p_rec.tp_cost_information1 :=
763: ota_tpc_shd.g_old_rec.tp_cost_information1;
759: ota_tpc_shd.g_old_rec.information_category;
760: End If;
761: If (p_rec.tp_cost_information1 = hr_api.g_varchar2) then
762: p_rec.tp_cost_information1 :=
763: ota_tpc_shd.g_old_rec.tp_cost_information1;
764: End If;
765: If (p_rec.tp_cost_information2 = hr_api.g_varchar2) then
766: p_rec.tp_cost_information2 :=
767: ota_tpc_shd.g_old_rec.tp_cost_information2;
763: ota_tpc_shd.g_old_rec.tp_cost_information1;
764: End If;
765: If (p_rec.tp_cost_information2 = hr_api.g_varchar2) then
766: p_rec.tp_cost_information2 :=
767: ota_tpc_shd.g_old_rec.tp_cost_information2;
768: End If;
769: If (p_rec.tp_cost_information3 = hr_api.g_varchar2) then
770: p_rec.tp_cost_information3 :=
771: ota_tpc_shd.g_old_rec.tp_cost_information3;
767: ota_tpc_shd.g_old_rec.tp_cost_information2;
768: End If;
769: If (p_rec.tp_cost_information3 = hr_api.g_varchar2) then
770: p_rec.tp_cost_information3 :=
771: ota_tpc_shd.g_old_rec.tp_cost_information3;
772: End If;
773: If (p_rec.tp_cost_information4 = hr_api.g_varchar2) then
774: p_rec.tp_cost_information4 :=
775: ota_tpc_shd.g_old_rec.tp_cost_information4;
771: ota_tpc_shd.g_old_rec.tp_cost_information3;
772: End If;
773: If (p_rec.tp_cost_information4 = hr_api.g_varchar2) then
774: p_rec.tp_cost_information4 :=
775: ota_tpc_shd.g_old_rec.tp_cost_information4;
776: End If;
777: If (p_rec.tp_cost_information5 = hr_api.g_varchar2) then
778: p_rec.tp_cost_information5 :=
779: ota_tpc_shd.g_old_rec.tp_cost_information5;
775: ota_tpc_shd.g_old_rec.tp_cost_information4;
776: End If;
777: If (p_rec.tp_cost_information5 = hr_api.g_varchar2) then
778: p_rec.tp_cost_information5 :=
779: ota_tpc_shd.g_old_rec.tp_cost_information5;
780: End If;
781: If (p_rec.tp_cost_information6 = hr_api.g_varchar2) then
782: p_rec.tp_cost_information6 :=
783: ota_tpc_shd.g_old_rec.tp_cost_information6;
779: ota_tpc_shd.g_old_rec.tp_cost_information5;
780: End If;
781: If (p_rec.tp_cost_information6 = hr_api.g_varchar2) then
782: p_rec.tp_cost_information6 :=
783: ota_tpc_shd.g_old_rec.tp_cost_information6;
784: End If;
785: If (p_rec.tp_cost_information7 = hr_api.g_varchar2) then
786: p_rec.tp_cost_information7 :=
787: ota_tpc_shd.g_old_rec.tp_cost_information7;
783: ota_tpc_shd.g_old_rec.tp_cost_information6;
784: End If;
785: If (p_rec.tp_cost_information7 = hr_api.g_varchar2) then
786: p_rec.tp_cost_information7 :=
787: ota_tpc_shd.g_old_rec.tp_cost_information7;
788: End If;
789: If (p_rec.tp_cost_information8 = hr_api.g_varchar2) then
790: p_rec.tp_cost_information8 :=
791: ota_tpc_shd.g_old_rec.tp_cost_information8;
787: ota_tpc_shd.g_old_rec.tp_cost_information7;
788: End If;
789: If (p_rec.tp_cost_information8 = hr_api.g_varchar2) then
790: p_rec.tp_cost_information8 :=
791: ota_tpc_shd.g_old_rec.tp_cost_information8;
792: End If;
793: If (p_rec.tp_cost_information9 = hr_api.g_varchar2) then
794: p_rec.tp_cost_information9 :=
795: ota_tpc_shd.g_old_rec.tp_cost_information9;
791: ota_tpc_shd.g_old_rec.tp_cost_information8;
792: End If;
793: If (p_rec.tp_cost_information9 = hr_api.g_varchar2) then
794: p_rec.tp_cost_information9 :=
795: ota_tpc_shd.g_old_rec.tp_cost_information9;
796: End If;
797: If (p_rec.tp_cost_information10 = hr_api.g_varchar2) then
798: p_rec.tp_cost_information10 :=
799: ota_tpc_shd.g_old_rec.tp_cost_information10;
795: ota_tpc_shd.g_old_rec.tp_cost_information9;
796: End If;
797: If (p_rec.tp_cost_information10 = hr_api.g_varchar2) then
798: p_rec.tp_cost_information10 :=
799: ota_tpc_shd.g_old_rec.tp_cost_information10;
800: End If;
801: If (p_rec.tp_cost_information11 = hr_api.g_varchar2) then
802: p_rec.tp_cost_information11 :=
803: ota_tpc_shd.g_old_rec.tp_cost_information11;
799: ota_tpc_shd.g_old_rec.tp_cost_information10;
800: End If;
801: If (p_rec.tp_cost_information11 = hr_api.g_varchar2) then
802: p_rec.tp_cost_information11 :=
803: ota_tpc_shd.g_old_rec.tp_cost_information11;
804: End If;
805: If (p_rec.tp_cost_information12 = hr_api.g_varchar2) then
806: p_rec.tp_cost_information12 :=
807: ota_tpc_shd.g_old_rec.tp_cost_information12;
803: ota_tpc_shd.g_old_rec.tp_cost_information11;
804: End If;
805: If (p_rec.tp_cost_information12 = hr_api.g_varchar2) then
806: p_rec.tp_cost_information12 :=
807: ota_tpc_shd.g_old_rec.tp_cost_information12;
808: End If;
809: If (p_rec.tp_cost_information13 = hr_api.g_varchar2) then
810: p_rec.tp_cost_information13 :=
811: ota_tpc_shd.g_old_rec.tp_cost_information13;
807: ota_tpc_shd.g_old_rec.tp_cost_information12;
808: End If;
809: If (p_rec.tp_cost_information13 = hr_api.g_varchar2) then
810: p_rec.tp_cost_information13 :=
811: ota_tpc_shd.g_old_rec.tp_cost_information13;
812: End If;
813: If (p_rec.tp_cost_information14 = hr_api.g_varchar2) then
814: p_rec.tp_cost_information14 :=
815: ota_tpc_shd.g_old_rec.tp_cost_information14;
811: ota_tpc_shd.g_old_rec.tp_cost_information13;
812: End If;
813: If (p_rec.tp_cost_information14 = hr_api.g_varchar2) then
814: p_rec.tp_cost_information14 :=
815: ota_tpc_shd.g_old_rec.tp_cost_information14;
816: End If;
817: If (p_rec.tp_cost_information15 = hr_api.g_varchar2) then
818: p_rec.tp_cost_information15 :=
819: ota_tpc_shd.g_old_rec.tp_cost_information15;
815: ota_tpc_shd.g_old_rec.tp_cost_information14;
816: End If;
817: If (p_rec.tp_cost_information15 = hr_api.g_varchar2) then
818: p_rec.tp_cost_information15 :=
819: ota_tpc_shd.g_old_rec.tp_cost_information15;
820: End If;
821: If (p_rec.tp_cost_information16 = hr_api.g_varchar2) then
822: p_rec.tp_cost_information16 :=
823: ota_tpc_shd.g_old_rec.tp_cost_information16;
819: ota_tpc_shd.g_old_rec.tp_cost_information15;
820: End If;
821: If (p_rec.tp_cost_information16 = hr_api.g_varchar2) then
822: p_rec.tp_cost_information16 :=
823: ota_tpc_shd.g_old_rec.tp_cost_information16;
824: End If;
825: If (p_rec.tp_cost_information17 = hr_api.g_varchar2) then
826: p_rec.tp_cost_information17 :=
827: ota_tpc_shd.g_old_rec.tp_cost_information17;
823: ota_tpc_shd.g_old_rec.tp_cost_information16;
824: End If;
825: If (p_rec.tp_cost_information17 = hr_api.g_varchar2) then
826: p_rec.tp_cost_information17 :=
827: ota_tpc_shd.g_old_rec.tp_cost_information17;
828: End If;
829: If (p_rec.tp_cost_information18 = hr_api.g_varchar2) then
830: p_rec.tp_cost_information18 :=
831: ota_tpc_shd.g_old_rec.tp_cost_information18;
827: ota_tpc_shd.g_old_rec.tp_cost_information17;
828: End If;
829: If (p_rec.tp_cost_information18 = hr_api.g_varchar2) then
830: p_rec.tp_cost_information18 :=
831: ota_tpc_shd.g_old_rec.tp_cost_information18;
832: End If;
833: If (p_rec.tp_cost_information19 = hr_api.g_varchar2) then
834: p_rec.tp_cost_information19 :=
835: ota_tpc_shd.g_old_rec.tp_cost_information19;
831: ota_tpc_shd.g_old_rec.tp_cost_information18;
832: End If;
833: If (p_rec.tp_cost_information19 = hr_api.g_varchar2) then
834: p_rec.tp_cost_information19 :=
835: ota_tpc_shd.g_old_rec.tp_cost_information19;
836: End If;
837: If (p_rec.tp_cost_information20 = hr_api.g_varchar2) then
838: p_rec.tp_cost_information20 :=
839: ota_tpc_shd.g_old_rec.tp_cost_information20;
835: ota_tpc_shd.g_old_rec.tp_cost_information19;
836: End If;
837: If (p_rec.tp_cost_information20 = hr_api.g_varchar2) then
838: p_rec.tp_cost_information20 :=
839: ota_tpc_shd.g_old_rec.tp_cost_information20;
840: End If;
841: If (p_rec.tp_cost_information21 = hr_api.g_varchar2) then
842: p_rec.tp_cost_information21 :=
843: ota_tpc_shd.g_old_rec.tp_cost_information21;
839: ota_tpc_shd.g_old_rec.tp_cost_information20;
840: End If;
841: If (p_rec.tp_cost_information21 = hr_api.g_varchar2) then
842: p_rec.tp_cost_information21 :=
843: ota_tpc_shd.g_old_rec.tp_cost_information21;
844: End If;
845: If (p_rec.tp_cost_information22 = hr_api.g_varchar2) then
846: p_rec.tp_cost_information22 :=
847: ota_tpc_shd.g_old_rec.tp_cost_information22;
843: ota_tpc_shd.g_old_rec.tp_cost_information21;
844: End If;
845: If (p_rec.tp_cost_information22 = hr_api.g_varchar2) then
846: p_rec.tp_cost_information22 :=
847: ota_tpc_shd.g_old_rec.tp_cost_information22;
848: End If;
849: If (p_rec.tp_cost_information23 = hr_api.g_varchar2) then
850: p_rec.tp_cost_information23 :=
851: ota_tpc_shd.g_old_rec.tp_cost_information23;
847: ota_tpc_shd.g_old_rec.tp_cost_information22;
848: End If;
849: If (p_rec.tp_cost_information23 = hr_api.g_varchar2) then
850: p_rec.tp_cost_information23 :=
851: ota_tpc_shd.g_old_rec.tp_cost_information23;
852: End If;
853: If (p_rec.tp_cost_information24 = hr_api.g_varchar2) then
854: p_rec.tp_cost_information24 :=
855: ota_tpc_shd.g_old_rec.tp_cost_information24;
851: ota_tpc_shd.g_old_rec.tp_cost_information23;
852: End If;
853: If (p_rec.tp_cost_information24 = hr_api.g_varchar2) then
854: p_rec.tp_cost_information24 :=
855: ota_tpc_shd.g_old_rec.tp_cost_information24;
856: End If;
857: If (p_rec.tp_cost_information25 = hr_api.g_varchar2) then
858: p_rec.tp_cost_information25 :=
859: ota_tpc_shd.g_old_rec.tp_cost_information25;
855: ota_tpc_shd.g_old_rec.tp_cost_information24;
856: End If;
857: If (p_rec.tp_cost_information25 = hr_api.g_varchar2) then
858: p_rec.tp_cost_information25 :=
859: ota_tpc_shd.g_old_rec.tp_cost_information25;
860: End If;
861: If (p_rec.tp_cost_information26 = hr_api.g_varchar2) then
862: p_rec.tp_cost_information26 :=
863: ota_tpc_shd.g_old_rec.tp_cost_information26;
859: ota_tpc_shd.g_old_rec.tp_cost_information25;
860: End If;
861: If (p_rec.tp_cost_information26 = hr_api.g_varchar2) then
862: p_rec.tp_cost_information26 :=
863: ota_tpc_shd.g_old_rec.tp_cost_information26;
864: End If;
865: If (p_rec.tp_cost_information27 = hr_api.g_varchar2) then
866: p_rec.tp_cost_information27 :=
867: ota_tpc_shd.g_old_rec.tp_cost_information27;
863: ota_tpc_shd.g_old_rec.tp_cost_information26;
864: End If;
865: If (p_rec.tp_cost_information27 = hr_api.g_varchar2) then
866: p_rec.tp_cost_information27 :=
867: ota_tpc_shd.g_old_rec.tp_cost_information27;
868: End If;
869: If (p_rec.tp_cost_information28 = hr_api.g_varchar2) then
870: p_rec.tp_cost_information28 :=
871: ota_tpc_shd.g_old_rec.tp_cost_information28;
867: ota_tpc_shd.g_old_rec.tp_cost_information27;
868: End If;
869: If (p_rec.tp_cost_information28 = hr_api.g_varchar2) then
870: p_rec.tp_cost_information28 :=
871: ota_tpc_shd.g_old_rec.tp_cost_information28;
872: End If;
873: If (p_rec.tp_cost_information29 = hr_api.g_varchar2) then
874: p_rec.tp_cost_information29 :=
875: ota_tpc_shd.g_old_rec.tp_cost_information29;
871: ota_tpc_shd.g_old_rec.tp_cost_information28;
872: End If;
873: If (p_rec.tp_cost_information29 = hr_api.g_varchar2) then
874: p_rec.tp_cost_information29 :=
875: ota_tpc_shd.g_old_rec.tp_cost_information29;
876: End If;
877: If (p_rec.tp_cost_information30 = hr_api.g_varchar2) then
878: p_rec.tp_cost_information30 :=
879: ota_tpc_shd.g_old_rec.tp_cost_information30;
875: ota_tpc_shd.g_old_rec.tp_cost_information29;
876: End If;
877: If (p_rec.tp_cost_information30 = hr_api.g_varchar2) then
878: p_rec.tp_cost_information30 :=
879: ota_tpc_shd.g_old_rec.tp_cost_information30;
880: End If;
881: --
882: End convert_defs;
883: --
885: -- |---------------------------------< upd >----------------------------------|
886: -- ----------------------------------------------------------------------------
887: Procedure upd
888: (p_effective_date in date
889: ,p_rec in out nocopy ota_tpc_shd.g_rec_type
890: ) is
891: --
892: l_proc varchar2(72) := g_package||'upd';
893: --
895: hr_utility.set_location('Entering:'||l_proc, 5);
896: --
897: -- We must lock the row which we need to update.
898: --
899: ota_tpc_shd.lck
900: (p_rec.training_plan_cost_id
901: ,p_rec.object_version_number
902: );
903: --
1001: ,p_tp_cost_information29 in varchar2 default hr_api.g_varchar2
1002: ,p_tp_cost_information30 in varchar2 default hr_api.g_varchar2
1003: ) is
1004: --
1005: l_rec ota_tpc_shd.g_rec_type;
1006: l_proc varchar2(72) := g_package||'upd';
1007: --
1008: Begin
1009: hr_utility.set_location('Entering:'||l_proc, 5);
1011: -- Call conversion function to turn arguments into the
1012: -- l_rec structure.
1013: --
1014: l_rec :=
1015: ota_tpc_shd.convert_args
1016: (p_training_plan_cost_id
1017: ,hr_api.g_number
1018: ,hr_api.g_number
1019: ,hr_api.g_number