[Home] [Help]
53: --
54: -- {End Of Comments}
55: -- ----------------------------------------------------------------------------
56: Procedure update_dml
57: (p_rec in out nocopy ota_off_shd.g_rec_type
58: ) is
59: --
60: l_proc varchar2(72) := g_package||'update_dml';
61: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: ota_off_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: ota_off_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: ota_off_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: --
147: Raise;
179: --
180: -- {End Of Comments}
181: -- ----------------------------------------------------------------------------
182: Procedure pre_update
183: (p_rec in ota_off_shd.g_rec_type
184: ) is
185: --
186: l_proc varchar2(72) := g_package||'pre_update';
187: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure post_update
227: (p_effective_date in date
228: ,p_rec in ota_off_shd.g_rec_type
229: ) is
230: --
231: l_proc varchar2(72) := g_package||'post_update';
232: l_activity_version_id_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.activity_version_id,
228: ,p_rec in ota_off_shd.g_rec_type
229: ) is
230: --
231: l_proc varchar2(72) := g_package||'post_update';
232: l_activity_version_id_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.activity_version_id,
233: p_rec.activity_version_id);
234: --
235: Begin
236: hr_utility.set_location('Entering:'||l_proc, 5);
336: ,p_vendor_id
337: => p_rec.vendor_id
338: ,p_competency_update_level => p_rec.competency_update_level
339: ,p_activity_version_id_o
340: => ota_off_shd.g_old_rec.activity_version_id
341: ,p_business_group_id_o
342: => ota_off_shd.g_old_rec.business_group_id
343: ,p_start_date_o
344: => ota_off_shd.g_old_rec.start_date
338: ,p_competency_update_level => p_rec.competency_update_level
339: ,p_activity_version_id_o
340: => ota_off_shd.g_old_rec.activity_version_id
341: ,p_business_group_id_o
342: => ota_off_shd.g_old_rec.business_group_id
343: ,p_start_date_o
344: => ota_off_shd.g_old_rec.start_date
345: ,p_end_date_o
346: => ota_off_shd.g_old_rec.end_date
340: => ota_off_shd.g_old_rec.activity_version_id
341: ,p_business_group_id_o
342: => ota_off_shd.g_old_rec.business_group_id
343: ,p_start_date_o
344: => ota_off_shd.g_old_rec.start_date
345: ,p_end_date_o
346: => ota_off_shd.g_old_rec.end_date
347: ,p_owner_id_o
348: => ota_off_shd.g_old_rec.owner_id
342: => ota_off_shd.g_old_rec.business_group_id
343: ,p_start_date_o
344: => ota_off_shd.g_old_rec.start_date
345: ,p_end_date_o
346: => ota_off_shd.g_old_rec.end_date
347: ,p_owner_id_o
348: => ota_off_shd.g_old_rec.owner_id
349: ,p_delivery_mode_id_o
350: => ota_off_shd.g_old_rec.delivery_mode_id
344: => ota_off_shd.g_old_rec.start_date
345: ,p_end_date_o
346: => ota_off_shd.g_old_rec.end_date
347: ,p_owner_id_o
348: => ota_off_shd.g_old_rec.owner_id
349: ,p_delivery_mode_id_o
350: => ota_off_shd.g_old_rec.delivery_mode_id
351: ,p_language_id_o
352: => ota_off_shd.g_old_rec.language_id
346: => ota_off_shd.g_old_rec.end_date
347: ,p_owner_id_o
348: => ota_off_shd.g_old_rec.owner_id
349: ,p_delivery_mode_id_o
350: => ota_off_shd.g_old_rec.delivery_mode_id
351: ,p_language_id_o
352: => ota_off_shd.g_old_rec.language_id
353: ,p_duration_o
354: => ota_off_shd.g_old_rec.duration
348: => ota_off_shd.g_old_rec.owner_id
349: ,p_delivery_mode_id_o
350: => ota_off_shd.g_old_rec.delivery_mode_id
351: ,p_language_id_o
352: => ota_off_shd.g_old_rec.language_id
353: ,p_duration_o
354: => ota_off_shd.g_old_rec.duration
355: ,p_duration_units_o
356: => ota_off_shd.g_old_rec.duration_units
350: => ota_off_shd.g_old_rec.delivery_mode_id
351: ,p_language_id_o
352: => ota_off_shd.g_old_rec.language_id
353: ,p_duration_o
354: => ota_off_shd.g_old_rec.duration
355: ,p_duration_units_o
356: => ota_off_shd.g_old_rec.duration_units
357: ,p_learning_object_id_o
358: => ota_off_shd.g_old_rec.learning_object_id
352: => ota_off_shd.g_old_rec.language_id
353: ,p_duration_o
354: => ota_off_shd.g_old_rec.duration
355: ,p_duration_units_o
356: => ota_off_shd.g_old_rec.duration_units
357: ,p_learning_object_id_o
358: => ota_off_shd.g_old_rec.learning_object_id
359: ,p_player_toolbar_flag_o
360: => ota_off_shd.g_old_rec.player_toolbar_flag
354: => ota_off_shd.g_old_rec.duration
355: ,p_duration_units_o
356: => ota_off_shd.g_old_rec.duration_units
357: ,p_learning_object_id_o
358: => ota_off_shd.g_old_rec.learning_object_id
359: ,p_player_toolbar_flag_o
360: => ota_off_shd.g_old_rec.player_toolbar_flag
361: ,p_player_toolbar_bitset_o
362: => ota_off_shd.g_old_rec.player_toolbar_bitset
356: => ota_off_shd.g_old_rec.duration_units
357: ,p_learning_object_id_o
358: => ota_off_shd.g_old_rec.learning_object_id
359: ,p_player_toolbar_flag_o
360: => ota_off_shd.g_old_rec.player_toolbar_flag
361: ,p_player_toolbar_bitset_o
362: => ota_off_shd.g_old_rec.player_toolbar_bitset
363: ,p_player_new_window_flag_o
364: => ota_off_shd.g_old_rec.player_new_window_flag
358: => ota_off_shd.g_old_rec.learning_object_id
359: ,p_player_toolbar_flag_o
360: => ota_off_shd.g_old_rec.player_toolbar_flag
361: ,p_player_toolbar_bitset_o
362: => ota_off_shd.g_old_rec.player_toolbar_bitset
363: ,p_player_new_window_flag_o
364: => ota_off_shd.g_old_rec.player_new_window_flag
365: ,p_maximum_attendees_o
366: => ota_off_shd.g_old_rec.maximum_attendees
360: => ota_off_shd.g_old_rec.player_toolbar_flag
361: ,p_player_toolbar_bitset_o
362: => ota_off_shd.g_old_rec.player_toolbar_bitset
363: ,p_player_new_window_flag_o
364: => ota_off_shd.g_old_rec.player_new_window_flag
365: ,p_maximum_attendees_o
366: => ota_off_shd.g_old_rec.maximum_attendees
367: ,p_maximum_internal_attendees_o
368: => ota_off_shd.g_old_rec.maximum_internal_attendees
362: => ota_off_shd.g_old_rec.player_toolbar_bitset
363: ,p_player_new_window_flag_o
364: => ota_off_shd.g_old_rec.player_new_window_flag
365: ,p_maximum_attendees_o
366: => ota_off_shd.g_old_rec.maximum_attendees
367: ,p_maximum_internal_attendees_o
368: => ota_off_shd.g_old_rec.maximum_internal_attendees
369: ,p_minimum_attendees_o
370: => ota_off_shd.g_old_rec.minimum_attendees
364: => ota_off_shd.g_old_rec.player_new_window_flag
365: ,p_maximum_attendees_o
366: => ota_off_shd.g_old_rec.maximum_attendees
367: ,p_maximum_internal_attendees_o
368: => ota_off_shd.g_old_rec.maximum_internal_attendees
369: ,p_minimum_attendees_o
370: => ota_off_shd.g_old_rec.minimum_attendees
371: ,p_actual_cost_o
372: => ota_off_shd.g_old_rec.actual_cost
366: => ota_off_shd.g_old_rec.maximum_attendees
367: ,p_maximum_internal_attendees_o
368: => ota_off_shd.g_old_rec.maximum_internal_attendees
369: ,p_minimum_attendees_o
370: => ota_off_shd.g_old_rec.minimum_attendees
371: ,p_actual_cost_o
372: => ota_off_shd.g_old_rec.actual_cost
373: ,p_budget_cost_o
374: => ota_off_shd.g_old_rec.budget_cost
368: => ota_off_shd.g_old_rec.maximum_internal_attendees
369: ,p_minimum_attendees_o
370: => ota_off_shd.g_old_rec.minimum_attendees
371: ,p_actual_cost_o
372: => ota_off_shd.g_old_rec.actual_cost
373: ,p_budget_cost_o
374: => ota_off_shd.g_old_rec.budget_cost
375: ,p_budget_currency_code_o
376: => ota_off_shd.g_old_rec.budget_currency_code
370: => ota_off_shd.g_old_rec.minimum_attendees
371: ,p_actual_cost_o
372: => ota_off_shd.g_old_rec.actual_cost
373: ,p_budget_cost_o
374: => ota_off_shd.g_old_rec.budget_cost
375: ,p_budget_currency_code_o
376: => ota_off_shd.g_old_rec.budget_currency_code
377: ,p_price_basis_o
378: => ota_off_shd.g_old_rec.price_basis
372: => ota_off_shd.g_old_rec.actual_cost
373: ,p_budget_cost_o
374: => ota_off_shd.g_old_rec.budget_cost
375: ,p_budget_currency_code_o
376: => ota_off_shd.g_old_rec.budget_currency_code
377: ,p_price_basis_o
378: => ota_off_shd.g_old_rec.price_basis
379: ,p_currency_code_o
380: => ota_off_shd.g_old_rec.currency_code
374: => ota_off_shd.g_old_rec.budget_cost
375: ,p_budget_currency_code_o
376: => ota_off_shd.g_old_rec.budget_currency_code
377: ,p_price_basis_o
378: => ota_off_shd.g_old_rec.price_basis
379: ,p_currency_code_o
380: => ota_off_shd.g_old_rec.currency_code
381: ,p_standard_price_o
382: => ota_off_shd.g_old_rec.standard_price
376: => ota_off_shd.g_old_rec.budget_currency_code
377: ,p_price_basis_o
378: => ota_off_shd.g_old_rec.price_basis
379: ,p_currency_code_o
380: => ota_off_shd.g_old_rec.currency_code
381: ,p_standard_price_o
382: => ota_off_shd.g_old_rec.standard_price
383: ,p_object_version_number_o
384: => ota_off_shd.g_old_rec.object_version_number
378: => ota_off_shd.g_old_rec.price_basis
379: ,p_currency_code_o
380: => ota_off_shd.g_old_rec.currency_code
381: ,p_standard_price_o
382: => ota_off_shd.g_old_rec.standard_price
383: ,p_object_version_number_o
384: => ota_off_shd.g_old_rec.object_version_number
385: ,p_attribute_category_o
386: => ota_off_shd.g_old_rec.attribute_category
380: => ota_off_shd.g_old_rec.currency_code
381: ,p_standard_price_o
382: => ota_off_shd.g_old_rec.standard_price
383: ,p_object_version_number_o
384: => ota_off_shd.g_old_rec.object_version_number
385: ,p_attribute_category_o
386: => ota_off_shd.g_old_rec.attribute_category
387: ,p_attribute1_o
388: => ota_off_shd.g_old_rec.attribute1
382: => ota_off_shd.g_old_rec.standard_price
383: ,p_object_version_number_o
384: => ota_off_shd.g_old_rec.object_version_number
385: ,p_attribute_category_o
386: => ota_off_shd.g_old_rec.attribute_category
387: ,p_attribute1_o
388: => ota_off_shd.g_old_rec.attribute1
389: ,p_attribute2_o
390: => ota_off_shd.g_old_rec.attribute2
384: => ota_off_shd.g_old_rec.object_version_number
385: ,p_attribute_category_o
386: => ota_off_shd.g_old_rec.attribute_category
387: ,p_attribute1_o
388: => ota_off_shd.g_old_rec.attribute1
389: ,p_attribute2_o
390: => ota_off_shd.g_old_rec.attribute2
391: ,p_attribute3_o
392: => ota_off_shd.g_old_rec.attribute3
386: => ota_off_shd.g_old_rec.attribute_category
387: ,p_attribute1_o
388: => ota_off_shd.g_old_rec.attribute1
389: ,p_attribute2_o
390: => ota_off_shd.g_old_rec.attribute2
391: ,p_attribute3_o
392: => ota_off_shd.g_old_rec.attribute3
393: ,p_attribute4_o
394: => ota_off_shd.g_old_rec.attribute4
388: => ota_off_shd.g_old_rec.attribute1
389: ,p_attribute2_o
390: => ota_off_shd.g_old_rec.attribute2
391: ,p_attribute3_o
392: => ota_off_shd.g_old_rec.attribute3
393: ,p_attribute4_o
394: => ota_off_shd.g_old_rec.attribute4
395: ,p_attribute5_o
396: => ota_off_shd.g_old_rec.attribute5
390: => ota_off_shd.g_old_rec.attribute2
391: ,p_attribute3_o
392: => ota_off_shd.g_old_rec.attribute3
393: ,p_attribute4_o
394: => ota_off_shd.g_old_rec.attribute4
395: ,p_attribute5_o
396: => ota_off_shd.g_old_rec.attribute5
397: ,p_attribute6_o
398: => ota_off_shd.g_old_rec.attribute6
392: => ota_off_shd.g_old_rec.attribute3
393: ,p_attribute4_o
394: => ota_off_shd.g_old_rec.attribute4
395: ,p_attribute5_o
396: => ota_off_shd.g_old_rec.attribute5
397: ,p_attribute6_o
398: => ota_off_shd.g_old_rec.attribute6
399: ,p_attribute7_o
400: => ota_off_shd.g_old_rec.attribute7
394: => ota_off_shd.g_old_rec.attribute4
395: ,p_attribute5_o
396: => ota_off_shd.g_old_rec.attribute5
397: ,p_attribute6_o
398: => ota_off_shd.g_old_rec.attribute6
399: ,p_attribute7_o
400: => ota_off_shd.g_old_rec.attribute7
401: ,p_attribute8_o
402: => ota_off_shd.g_old_rec.attribute8
396: => ota_off_shd.g_old_rec.attribute5
397: ,p_attribute6_o
398: => ota_off_shd.g_old_rec.attribute6
399: ,p_attribute7_o
400: => ota_off_shd.g_old_rec.attribute7
401: ,p_attribute8_o
402: => ota_off_shd.g_old_rec.attribute8
403: ,p_attribute9_o
404: => ota_off_shd.g_old_rec.attribute9
398: => ota_off_shd.g_old_rec.attribute6
399: ,p_attribute7_o
400: => ota_off_shd.g_old_rec.attribute7
401: ,p_attribute8_o
402: => ota_off_shd.g_old_rec.attribute8
403: ,p_attribute9_o
404: => ota_off_shd.g_old_rec.attribute9
405: ,p_attribute10_o
406: => ota_off_shd.g_old_rec.attribute10
400: => ota_off_shd.g_old_rec.attribute7
401: ,p_attribute8_o
402: => ota_off_shd.g_old_rec.attribute8
403: ,p_attribute9_o
404: => ota_off_shd.g_old_rec.attribute9
405: ,p_attribute10_o
406: => ota_off_shd.g_old_rec.attribute10
407: ,p_attribute11_o
408: => ota_off_shd.g_old_rec.attribute11
402: => ota_off_shd.g_old_rec.attribute8
403: ,p_attribute9_o
404: => ota_off_shd.g_old_rec.attribute9
405: ,p_attribute10_o
406: => ota_off_shd.g_old_rec.attribute10
407: ,p_attribute11_o
408: => ota_off_shd.g_old_rec.attribute11
409: ,p_attribute12_o
410: => ota_off_shd.g_old_rec.attribute12
404: => ota_off_shd.g_old_rec.attribute9
405: ,p_attribute10_o
406: => ota_off_shd.g_old_rec.attribute10
407: ,p_attribute11_o
408: => ota_off_shd.g_old_rec.attribute11
409: ,p_attribute12_o
410: => ota_off_shd.g_old_rec.attribute12
411: ,p_attribute13_o
412: => ota_off_shd.g_old_rec.attribute13
406: => ota_off_shd.g_old_rec.attribute10
407: ,p_attribute11_o
408: => ota_off_shd.g_old_rec.attribute11
409: ,p_attribute12_o
410: => ota_off_shd.g_old_rec.attribute12
411: ,p_attribute13_o
412: => ota_off_shd.g_old_rec.attribute13
413: ,p_attribute14_o
414: => ota_off_shd.g_old_rec.attribute14
408: => ota_off_shd.g_old_rec.attribute11
409: ,p_attribute12_o
410: => ota_off_shd.g_old_rec.attribute12
411: ,p_attribute13_o
412: => ota_off_shd.g_old_rec.attribute13
413: ,p_attribute14_o
414: => ota_off_shd.g_old_rec.attribute14
415: ,p_attribute15_o
416: => ota_off_shd.g_old_rec.attribute15
410: => ota_off_shd.g_old_rec.attribute12
411: ,p_attribute13_o
412: => ota_off_shd.g_old_rec.attribute13
413: ,p_attribute14_o
414: => ota_off_shd.g_old_rec.attribute14
415: ,p_attribute15_o
416: => ota_off_shd.g_old_rec.attribute15
417: ,p_attribute16_o
418: => ota_off_shd.g_old_rec.attribute16
412: => ota_off_shd.g_old_rec.attribute13
413: ,p_attribute14_o
414: => ota_off_shd.g_old_rec.attribute14
415: ,p_attribute15_o
416: => ota_off_shd.g_old_rec.attribute15
417: ,p_attribute16_o
418: => ota_off_shd.g_old_rec.attribute16
419: ,p_attribute17_o
420: => ota_off_shd.g_old_rec.attribute17
414: => ota_off_shd.g_old_rec.attribute14
415: ,p_attribute15_o
416: => ota_off_shd.g_old_rec.attribute15
417: ,p_attribute16_o
418: => ota_off_shd.g_old_rec.attribute16
419: ,p_attribute17_o
420: => ota_off_shd.g_old_rec.attribute17
421: ,p_attribute18_o
422: => ota_off_shd.g_old_rec.attribute18
416: => ota_off_shd.g_old_rec.attribute15
417: ,p_attribute16_o
418: => ota_off_shd.g_old_rec.attribute16
419: ,p_attribute17_o
420: => ota_off_shd.g_old_rec.attribute17
421: ,p_attribute18_o
422: => ota_off_shd.g_old_rec.attribute18
423: ,p_attribute19_o
424: => ota_off_shd.g_old_rec.attribute19
418: => ota_off_shd.g_old_rec.attribute16
419: ,p_attribute17_o
420: => ota_off_shd.g_old_rec.attribute17
421: ,p_attribute18_o
422: => ota_off_shd.g_old_rec.attribute18
423: ,p_attribute19_o
424: => ota_off_shd.g_old_rec.attribute19
425: ,p_attribute20_o
426: => ota_off_shd.g_old_rec.attribute20
420: => ota_off_shd.g_old_rec.attribute17
421: ,p_attribute18_o
422: => ota_off_shd.g_old_rec.attribute18
423: ,p_attribute19_o
424: => ota_off_shd.g_old_rec.attribute19
425: ,p_attribute20_o
426: => ota_off_shd.g_old_rec.attribute20
427: ,p_data_source_o
428: => ota_off_shd.g_old_rec.data_source
422: => ota_off_shd.g_old_rec.attribute18
423: ,p_attribute19_o
424: => ota_off_shd.g_old_rec.attribute19
425: ,p_attribute20_o
426: => ota_off_shd.g_old_rec.attribute20
427: ,p_data_source_o
428: => ota_off_shd.g_old_rec.data_source
429: ,p_vendor_id_o
430: => ota_off_shd.g_old_rec.vendor_id
424: => ota_off_shd.g_old_rec.attribute19
425: ,p_attribute20_o
426: => ota_off_shd.g_old_rec.attribute20
427: ,p_data_source_o
428: => ota_off_shd.g_old_rec.data_source
429: ,p_vendor_id_o
430: => ota_off_shd.g_old_rec.vendor_id
431: ,p_competency_update_level_o => ota_off_shd.g_old_rec.competency_update_level
432: ,p_language_code => ota_off_shd.g_old_rec.language_code -- 2733966
426: => ota_off_shd.g_old_rec.attribute20
427: ,p_data_source_o
428: => ota_off_shd.g_old_rec.data_source
429: ,p_vendor_id_o
430: => ota_off_shd.g_old_rec.vendor_id
431: ,p_competency_update_level_o => ota_off_shd.g_old_rec.competency_update_level
432: ,p_language_code => ota_off_shd.g_old_rec.language_code -- 2733966
433: );
434: null;
427: ,p_data_source_o
428: => ota_off_shd.g_old_rec.data_source
429: ,p_vendor_id_o
430: => ota_off_shd.g_old_rec.vendor_id
431: ,p_competency_update_level_o => ota_off_shd.g_old_rec.competency_update_level
432: ,p_language_code => ota_off_shd.g_old_rec.language_code -- 2733966
433: );
434: null;
435: --
428: => ota_off_shd.g_old_rec.data_source
429: ,p_vendor_id_o
430: => ota_off_shd.g_old_rec.vendor_id
431: ,p_competency_update_level_o => ota_off_shd.g_old_rec.competency_update_level
432: ,p_language_code => ota_off_shd.g_old_rec.language_code -- 2733966
433: );
434: null;
435: --
436: exception
489: --
490: -- {End Of Comments}
491: -- ----------------------------------------------------------------------------
492: Procedure convert_defs
493: (p_rec in out nocopy ota_off_shd.g_rec_type
494: ) is
495: --
496: Begin
497: --
501: -- is being used then we must set to the 'current' argument value.
502: --
503: If (p_rec.activity_version_id = hr_api.g_number) then
504: p_rec.activity_version_id :=
505: ota_off_shd.g_old_rec.activity_version_id;
506: End If;
507: If (p_rec.business_group_id = hr_api.g_number) then
508: p_rec.business_group_id :=
509: ota_off_shd.g_old_rec.business_group_id;
505: ota_off_shd.g_old_rec.activity_version_id;
506: End If;
507: If (p_rec.business_group_id = hr_api.g_number) then
508: p_rec.business_group_id :=
509: ota_off_shd.g_old_rec.business_group_id;
510: End If;
511: If (p_rec.start_date = hr_api.g_date) then
512: p_rec.start_date :=
513: ota_off_shd.g_old_rec.start_date;
509: ota_off_shd.g_old_rec.business_group_id;
510: End If;
511: If (p_rec.start_date = hr_api.g_date) then
512: p_rec.start_date :=
513: ota_off_shd.g_old_rec.start_date;
514: End If;
515: If (p_rec.end_date = hr_api.g_date) then
516: p_rec.end_date :=
517: ota_off_shd.g_old_rec.end_date;
513: ota_off_shd.g_old_rec.start_date;
514: End If;
515: If (p_rec.end_date = hr_api.g_date) then
516: p_rec.end_date :=
517: ota_off_shd.g_old_rec.end_date;
518: End If;
519: If (p_rec.owner_id = hr_api.g_number) then
520: p_rec.owner_id :=
521: ota_off_shd.g_old_rec.owner_id;
517: ota_off_shd.g_old_rec.end_date;
518: End If;
519: If (p_rec.owner_id = hr_api.g_number) then
520: p_rec.owner_id :=
521: ota_off_shd.g_old_rec.owner_id;
522: End If;
523: If (p_rec.delivery_mode_id = hr_api.g_number) then
524: p_rec.delivery_mode_id :=
525: ota_off_shd.g_old_rec.delivery_mode_id;
521: ota_off_shd.g_old_rec.owner_id;
522: End If;
523: If (p_rec.delivery_mode_id = hr_api.g_number) then
524: p_rec.delivery_mode_id :=
525: ota_off_shd.g_old_rec.delivery_mode_id;
526: End If;
527: If (p_rec.language_id = hr_api.g_number) then
528: p_rec.language_id :=
529: ota_off_shd.g_old_rec.language_id;
525: ota_off_shd.g_old_rec.delivery_mode_id;
526: End If;
527: If (p_rec.language_id = hr_api.g_number) then
528: p_rec.language_id :=
529: ota_off_shd.g_old_rec.language_id;
530: End If;
531: If (p_rec.duration = hr_api.g_number) then
532: p_rec.duration :=
533: ota_off_shd.g_old_rec.duration;
529: ota_off_shd.g_old_rec.language_id;
530: End If;
531: If (p_rec.duration = hr_api.g_number) then
532: p_rec.duration :=
533: ota_off_shd.g_old_rec.duration;
534: End If;
535: If (p_rec.duration_units = hr_api.g_varchar2) then
536: p_rec.duration_units :=
537: ota_off_shd.g_old_rec.duration_units;
533: ota_off_shd.g_old_rec.duration;
534: End If;
535: If (p_rec.duration_units = hr_api.g_varchar2) then
536: p_rec.duration_units :=
537: ota_off_shd.g_old_rec.duration_units;
538: End If;
539: If (p_rec.learning_object_id = hr_api.g_number) then
540: p_rec.learning_object_id :=
541: ota_off_shd.g_old_rec.learning_object_id;
537: ota_off_shd.g_old_rec.duration_units;
538: End If;
539: If (p_rec.learning_object_id = hr_api.g_number) then
540: p_rec.learning_object_id :=
541: ota_off_shd.g_old_rec.learning_object_id;
542: End If;
543: If (p_rec.player_toolbar_flag = hr_api.g_varchar2) then
544: p_rec.player_toolbar_flag :=
545: ota_off_shd.g_old_rec.player_toolbar_flag;
541: ota_off_shd.g_old_rec.learning_object_id;
542: End If;
543: If (p_rec.player_toolbar_flag = hr_api.g_varchar2) then
544: p_rec.player_toolbar_flag :=
545: ota_off_shd.g_old_rec.player_toolbar_flag;
546: End If;
547: If (p_rec.player_toolbar_bitset = hr_api.g_number) then
548: p_rec.player_toolbar_bitset :=
549: ota_off_shd.g_old_rec.player_toolbar_bitset;
545: ota_off_shd.g_old_rec.player_toolbar_flag;
546: End If;
547: If (p_rec.player_toolbar_bitset = hr_api.g_number) then
548: p_rec.player_toolbar_bitset :=
549: ota_off_shd.g_old_rec.player_toolbar_bitset;
550: End If;
551: If (p_rec.player_new_window_flag = hr_api.g_varchar2) then
552: p_rec.player_new_window_flag :=
553: ota_off_shd.g_old_rec.player_new_window_flag;
549: ota_off_shd.g_old_rec.player_toolbar_bitset;
550: End If;
551: If (p_rec.player_new_window_flag = hr_api.g_varchar2) then
552: p_rec.player_new_window_flag :=
553: ota_off_shd.g_old_rec.player_new_window_flag;
554: End If;
555: If (p_rec.maximum_attendees = hr_api.g_number) then
556: p_rec.maximum_attendees :=
557: ota_off_shd.g_old_rec.maximum_attendees;
553: ota_off_shd.g_old_rec.player_new_window_flag;
554: End If;
555: If (p_rec.maximum_attendees = hr_api.g_number) then
556: p_rec.maximum_attendees :=
557: ota_off_shd.g_old_rec.maximum_attendees;
558: End If;
559: If (p_rec.maximum_internal_attendees = hr_api.g_number) then
560: p_rec.maximum_internal_attendees :=
561: ota_off_shd.g_old_rec.maximum_internal_attendees;
557: ota_off_shd.g_old_rec.maximum_attendees;
558: End If;
559: If (p_rec.maximum_internal_attendees = hr_api.g_number) then
560: p_rec.maximum_internal_attendees :=
561: ota_off_shd.g_old_rec.maximum_internal_attendees;
562: End If;
563: If (p_rec.minimum_attendees = hr_api.g_number) then
564: p_rec.minimum_attendees :=
565: ota_off_shd.g_old_rec.minimum_attendees;
561: ota_off_shd.g_old_rec.maximum_internal_attendees;
562: End If;
563: If (p_rec.minimum_attendees = hr_api.g_number) then
564: p_rec.minimum_attendees :=
565: ota_off_shd.g_old_rec.minimum_attendees;
566: End If;
567: If (p_rec.actual_cost = hr_api.g_number) then
568: p_rec.actual_cost :=
569: ota_off_shd.g_old_rec.actual_cost;
565: ota_off_shd.g_old_rec.minimum_attendees;
566: End If;
567: If (p_rec.actual_cost = hr_api.g_number) then
568: p_rec.actual_cost :=
569: ota_off_shd.g_old_rec.actual_cost;
570: End If;
571: If (p_rec.budget_cost = hr_api.g_number) then
572: p_rec.budget_cost :=
573: ota_off_shd.g_old_rec.budget_cost;
569: ota_off_shd.g_old_rec.actual_cost;
570: End If;
571: If (p_rec.budget_cost = hr_api.g_number) then
572: p_rec.budget_cost :=
573: ota_off_shd.g_old_rec.budget_cost;
574: End If;
575: If (p_rec.budget_currency_code = hr_api.g_varchar2) then
576: p_rec.budget_currency_code :=
577: ota_off_shd.g_old_rec.budget_currency_code;
573: ota_off_shd.g_old_rec.budget_cost;
574: End If;
575: If (p_rec.budget_currency_code = hr_api.g_varchar2) then
576: p_rec.budget_currency_code :=
577: ota_off_shd.g_old_rec.budget_currency_code;
578: End If;
579: If (p_rec.price_basis = hr_api.g_varchar2) then
580: p_rec.price_basis :=
581: ota_off_shd.g_old_rec.price_basis;
577: ota_off_shd.g_old_rec.budget_currency_code;
578: End If;
579: If (p_rec.price_basis = hr_api.g_varchar2) then
580: p_rec.price_basis :=
581: ota_off_shd.g_old_rec.price_basis;
582: End If;
583: If (p_rec.currency_code = hr_api.g_varchar2) then
584: p_rec.currency_code :=
585: ota_off_shd.g_old_rec.currency_code;
581: ota_off_shd.g_old_rec.price_basis;
582: End If;
583: If (p_rec.currency_code = hr_api.g_varchar2) then
584: p_rec.currency_code :=
585: ota_off_shd.g_old_rec.currency_code;
586: End If;
587: If (p_rec.standard_price = hr_api.g_number) then
588: p_rec.standard_price :=
589: ota_off_shd.g_old_rec.standard_price;
585: ota_off_shd.g_old_rec.currency_code;
586: End If;
587: If (p_rec.standard_price = hr_api.g_number) then
588: p_rec.standard_price :=
589: ota_off_shd.g_old_rec.standard_price;
590: End If;
591: If (p_rec.attribute_category = hr_api.g_varchar2) then
592: p_rec.attribute_category :=
593: ota_off_shd.g_old_rec.attribute_category;
589: ota_off_shd.g_old_rec.standard_price;
590: End If;
591: If (p_rec.attribute_category = hr_api.g_varchar2) then
592: p_rec.attribute_category :=
593: ota_off_shd.g_old_rec.attribute_category;
594: End If;
595: If (p_rec.attribute1 = hr_api.g_varchar2) then
596: p_rec.attribute1 :=
597: ota_off_shd.g_old_rec.attribute1;
593: ota_off_shd.g_old_rec.attribute_category;
594: End If;
595: If (p_rec.attribute1 = hr_api.g_varchar2) then
596: p_rec.attribute1 :=
597: ota_off_shd.g_old_rec.attribute1;
598: End If;
599: If (p_rec.attribute2 = hr_api.g_varchar2) then
600: p_rec.attribute2 :=
601: ota_off_shd.g_old_rec.attribute2;
597: ota_off_shd.g_old_rec.attribute1;
598: End If;
599: If (p_rec.attribute2 = hr_api.g_varchar2) then
600: p_rec.attribute2 :=
601: ota_off_shd.g_old_rec.attribute2;
602: End If;
603: If (p_rec.attribute3 = hr_api.g_varchar2) then
604: p_rec.attribute3 :=
605: ota_off_shd.g_old_rec.attribute3;
601: ota_off_shd.g_old_rec.attribute2;
602: End If;
603: If (p_rec.attribute3 = hr_api.g_varchar2) then
604: p_rec.attribute3 :=
605: ota_off_shd.g_old_rec.attribute3;
606: End If;
607: If (p_rec.attribute4 = hr_api.g_varchar2) then
608: p_rec.attribute4 :=
609: ota_off_shd.g_old_rec.attribute4;
605: ota_off_shd.g_old_rec.attribute3;
606: End If;
607: If (p_rec.attribute4 = hr_api.g_varchar2) then
608: p_rec.attribute4 :=
609: ota_off_shd.g_old_rec.attribute4;
610: End If;
611: If (p_rec.attribute5 = hr_api.g_varchar2) then
612: p_rec.attribute5 :=
613: ota_off_shd.g_old_rec.attribute5;
609: ota_off_shd.g_old_rec.attribute4;
610: End If;
611: If (p_rec.attribute5 = hr_api.g_varchar2) then
612: p_rec.attribute5 :=
613: ota_off_shd.g_old_rec.attribute5;
614: End If;
615: If (p_rec.attribute6 = hr_api.g_varchar2) then
616: p_rec.attribute6 :=
617: ota_off_shd.g_old_rec.attribute6;
613: ota_off_shd.g_old_rec.attribute5;
614: End If;
615: If (p_rec.attribute6 = hr_api.g_varchar2) then
616: p_rec.attribute6 :=
617: ota_off_shd.g_old_rec.attribute6;
618: End If;
619: If (p_rec.attribute7 = hr_api.g_varchar2) then
620: p_rec.attribute7 :=
621: ota_off_shd.g_old_rec.attribute7;
617: ota_off_shd.g_old_rec.attribute6;
618: End If;
619: If (p_rec.attribute7 = hr_api.g_varchar2) then
620: p_rec.attribute7 :=
621: ota_off_shd.g_old_rec.attribute7;
622: End If;
623: If (p_rec.attribute8 = hr_api.g_varchar2) then
624: p_rec.attribute8 :=
625: ota_off_shd.g_old_rec.attribute8;
621: ota_off_shd.g_old_rec.attribute7;
622: End If;
623: If (p_rec.attribute8 = hr_api.g_varchar2) then
624: p_rec.attribute8 :=
625: ota_off_shd.g_old_rec.attribute8;
626: End If;
627: If (p_rec.attribute9 = hr_api.g_varchar2) then
628: p_rec.attribute9 :=
629: ota_off_shd.g_old_rec.attribute9;
625: ota_off_shd.g_old_rec.attribute8;
626: End If;
627: If (p_rec.attribute9 = hr_api.g_varchar2) then
628: p_rec.attribute9 :=
629: ota_off_shd.g_old_rec.attribute9;
630: End If;
631: If (p_rec.attribute10 = hr_api.g_varchar2) then
632: p_rec.attribute10 :=
633: ota_off_shd.g_old_rec.attribute10;
629: ota_off_shd.g_old_rec.attribute9;
630: End If;
631: If (p_rec.attribute10 = hr_api.g_varchar2) then
632: p_rec.attribute10 :=
633: ota_off_shd.g_old_rec.attribute10;
634: End If;
635: If (p_rec.attribute11 = hr_api.g_varchar2) then
636: p_rec.attribute11 :=
637: ota_off_shd.g_old_rec.attribute11;
633: ota_off_shd.g_old_rec.attribute10;
634: End If;
635: If (p_rec.attribute11 = hr_api.g_varchar2) then
636: p_rec.attribute11 :=
637: ota_off_shd.g_old_rec.attribute11;
638: End If;
639: If (p_rec.attribute12 = hr_api.g_varchar2) then
640: p_rec.attribute12 :=
641: ota_off_shd.g_old_rec.attribute12;
637: ota_off_shd.g_old_rec.attribute11;
638: End If;
639: If (p_rec.attribute12 = hr_api.g_varchar2) then
640: p_rec.attribute12 :=
641: ota_off_shd.g_old_rec.attribute12;
642: End If;
643: If (p_rec.attribute13 = hr_api.g_varchar2) then
644: p_rec.attribute13 :=
645: ota_off_shd.g_old_rec.attribute13;
641: ota_off_shd.g_old_rec.attribute12;
642: End If;
643: If (p_rec.attribute13 = hr_api.g_varchar2) then
644: p_rec.attribute13 :=
645: ota_off_shd.g_old_rec.attribute13;
646: End If;
647: If (p_rec.attribute14 = hr_api.g_varchar2) then
648: p_rec.attribute14 :=
649: ota_off_shd.g_old_rec.attribute14;
645: ota_off_shd.g_old_rec.attribute13;
646: End If;
647: If (p_rec.attribute14 = hr_api.g_varchar2) then
648: p_rec.attribute14 :=
649: ota_off_shd.g_old_rec.attribute14;
650: End If;
651: If (p_rec.attribute15 = hr_api.g_varchar2) then
652: p_rec.attribute15 :=
653: ota_off_shd.g_old_rec.attribute15;
649: ota_off_shd.g_old_rec.attribute14;
650: End If;
651: If (p_rec.attribute15 = hr_api.g_varchar2) then
652: p_rec.attribute15 :=
653: ota_off_shd.g_old_rec.attribute15;
654: End If;
655: If (p_rec.attribute16 = hr_api.g_varchar2) then
656: p_rec.attribute16 :=
657: ota_off_shd.g_old_rec.attribute16;
653: ota_off_shd.g_old_rec.attribute15;
654: End If;
655: If (p_rec.attribute16 = hr_api.g_varchar2) then
656: p_rec.attribute16 :=
657: ota_off_shd.g_old_rec.attribute16;
658: End If;
659: If (p_rec.attribute17 = hr_api.g_varchar2) then
660: p_rec.attribute17 :=
661: ota_off_shd.g_old_rec.attribute17;
657: ota_off_shd.g_old_rec.attribute16;
658: End If;
659: If (p_rec.attribute17 = hr_api.g_varchar2) then
660: p_rec.attribute17 :=
661: ota_off_shd.g_old_rec.attribute17;
662: End If;
663: If (p_rec.attribute18 = hr_api.g_varchar2) then
664: p_rec.attribute18 :=
665: ota_off_shd.g_old_rec.attribute18;
661: ota_off_shd.g_old_rec.attribute17;
662: End If;
663: If (p_rec.attribute18 = hr_api.g_varchar2) then
664: p_rec.attribute18 :=
665: ota_off_shd.g_old_rec.attribute18;
666: End If;
667: If (p_rec.attribute19 = hr_api.g_varchar2) then
668: p_rec.attribute19 :=
669: ota_off_shd.g_old_rec.attribute19;
665: ota_off_shd.g_old_rec.attribute18;
666: End If;
667: If (p_rec.attribute19 = hr_api.g_varchar2) then
668: p_rec.attribute19 :=
669: ota_off_shd.g_old_rec.attribute19;
670: End If;
671: If (p_rec.attribute20 = hr_api.g_varchar2) then
672: p_rec.attribute20 :=
673: ota_off_shd.g_old_rec.attribute20;
669: ota_off_shd.g_old_rec.attribute19;
670: End If;
671: If (p_rec.attribute20 = hr_api.g_varchar2) then
672: p_rec.attribute20 :=
673: ota_off_shd.g_old_rec.attribute20;
674: End If;
675: If (p_rec.data_source = hr_api.g_varchar2) then
676: p_rec.data_source :=
677: ota_off_shd.g_old_rec.data_source;
673: ota_off_shd.g_old_rec.attribute20;
674: End If;
675: If (p_rec.data_source = hr_api.g_varchar2) then
676: p_rec.data_source :=
677: ota_off_shd.g_old_rec.data_source;
678: End If;
679: If (p_rec.vendor_id = hr_api.g_number) then
680: p_rec.vendor_id :=
681: ota_off_shd.g_old_rec.vendor_id;
677: ota_off_shd.g_old_rec.data_source;
678: End If;
679: If (p_rec.vendor_id = hr_api.g_number) then
680: p_rec.vendor_id :=
681: ota_off_shd.g_old_rec.vendor_id;
682: End If;
683: If (p_rec.competency_update_level = hr_api.g_varchar2) then
684: p_rec.competency_update_level :=
685: ota_off_shd.g_old_rec.competency_update_level;
681: ota_off_shd.g_old_rec.vendor_id;
682: End If;
683: If (p_rec.competency_update_level = hr_api.g_varchar2) then
684: p_rec.competency_update_level :=
685: ota_off_shd.g_old_rec.competency_update_level;
686: End If;
687: If (p_rec.language_code = hr_api.g_varchar2) then -- 2733966
688: p_rec.language_code :=
689: ota_off_shd.g_old_rec.language_code;
685: ota_off_shd.g_old_rec.competency_update_level;
686: End If;
687: If (p_rec.language_code = hr_api.g_varchar2) then -- 2733966
688: p_rec.language_code :=
689: ota_off_shd.g_old_rec.language_code;
690: End If;
691: --
692: End convert_defs;
693: --
695: -- |---------------------------------< upd >----------------------------------|
696: -- ----------------------------------------------------------------------------
697: Procedure upd
698: (p_effective_date in date
699: ,p_rec in out nocopy ota_off_shd.g_rec_type
700: ,p_name in varchar2
701: ) is
702: --
703: l_proc varchar2(72) := g_package||'upd';
706: hr_utility.set_location('Entering:'||l_proc, 5);
707: --
708: -- We must lock the row which we need to update.
709: --
710: ota_off_shd.lck
711: (p_rec.offering_id
712: ,p_rec.object_version_number
713: );
714: --
803: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
804: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966
805: ) is
806: --
807: l_rec ota_off_shd.g_rec_type;
808: l_proc varchar2(72) := g_package||'upd';
809: --
810: Begin
811: hr_utility.set_location('Entering:'||l_proc, 5);
813: -- Call conversion function to turn arguments into the
814: -- l_rec structure.
815: --
816: l_rec :=
817: ota_off_shd.convert_args
818: (p_offering_id
819: ,p_activity_version_id
820: ,p_business_group_id
821: ,p_name