[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ota_tpm_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: l_boolean boolean := null;
126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: --
130: ota_tpm_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: --
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: --
135: ota_tpm_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: --
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: --
140: ota_tpm_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: --
144: Raise;
176: --
177: -- {End Of Comments}
178: -- ----------------------------------------------------------------------------
179: Procedure pre_update
180: (p_rec in ota_tpm_shd.g_rec_type
181: ) is
182: --
183: l_proc varchar2(72) := g_package||'pre_update';
184: --
221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure post_update
224: (p_effective_date in date
225: ,p_rec in ota_tpm_shd.g_rec_type
226: ) is
227: --
228: l_proc varchar2(72) := g_package||'post_update';
229: --
317: ,p_cancellation_reason => p_rec.cancellation_reason
318: ,p_earliest_start_date => p_rec.earliest_start_date
319: ,p_creator_person_id => p_rec.creator_person_id
320: ,p_training_plan_id_o
321: => ota_tpm_shd.g_old_rec.training_plan_id
322: ,p_activity_version_id_o
323: => ota_tpm_shd.g_old_rec.activity_version_id
324: ,p_activity_definition_id_o
325: => ota_tpm_shd.g_old_rec.activity_definition_id
319: ,p_creator_person_id => p_rec.creator_person_id
320: ,p_training_plan_id_o
321: => ota_tpm_shd.g_old_rec.training_plan_id
322: ,p_activity_version_id_o
323: => ota_tpm_shd.g_old_rec.activity_version_id
324: ,p_activity_definition_id_o
325: => ota_tpm_shd.g_old_rec.activity_definition_id
326: ,p_member_status_type_id_o
327: => ota_tpm_shd.g_old_rec.member_status_type_id
321: => ota_tpm_shd.g_old_rec.training_plan_id
322: ,p_activity_version_id_o
323: => ota_tpm_shd.g_old_rec.activity_version_id
324: ,p_activity_definition_id_o
325: => ota_tpm_shd.g_old_rec.activity_definition_id
326: ,p_member_status_type_id_o
327: => ota_tpm_shd.g_old_rec.member_status_type_id
328: ,p_target_completion_date_o
329: => ota_tpm_shd.g_old_rec.target_completion_date
323: => ota_tpm_shd.g_old_rec.activity_version_id
324: ,p_activity_definition_id_o
325: => ota_tpm_shd.g_old_rec.activity_definition_id
326: ,p_member_status_type_id_o
327: => ota_tpm_shd.g_old_rec.member_status_type_id
328: ,p_target_completion_date_o
329: => ota_tpm_shd.g_old_rec.target_completion_date
330: ,p_business_group_id_o
331: => ota_tpm_shd.g_old_rec.business_group_id
325: => ota_tpm_shd.g_old_rec.activity_definition_id
326: ,p_member_status_type_id_o
327: => ota_tpm_shd.g_old_rec.member_status_type_id
328: ,p_target_completion_date_o
329: => ota_tpm_shd.g_old_rec.target_completion_date
330: ,p_business_group_id_o
331: => ota_tpm_shd.g_old_rec.business_group_id
332: ,p_object_version_number_o
333: => ota_tpm_shd.g_old_rec.object_version_number
327: => ota_tpm_shd.g_old_rec.member_status_type_id
328: ,p_target_completion_date_o
329: => ota_tpm_shd.g_old_rec.target_completion_date
330: ,p_business_group_id_o
331: => ota_tpm_shd.g_old_rec.business_group_id
332: ,p_object_version_number_o
333: => ota_tpm_shd.g_old_rec.object_version_number
334: ,p_attribute_category_o
335: => ota_tpm_shd.g_old_rec.attribute_category
329: => ota_tpm_shd.g_old_rec.target_completion_date
330: ,p_business_group_id_o
331: => ota_tpm_shd.g_old_rec.business_group_id
332: ,p_object_version_number_o
333: => ota_tpm_shd.g_old_rec.object_version_number
334: ,p_attribute_category_o
335: => ota_tpm_shd.g_old_rec.attribute_category
336: ,p_attribute1_o
337: => ota_tpm_shd.g_old_rec.attribute1
331: => ota_tpm_shd.g_old_rec.business_group_id
332: ,p_object_version_number_o
333: => ota_tpm_shd.g_old_rec.object_version_number
334: ,p_attribute_category_o
335: => ota_tpm_shd.g_old_rec.attribute_category
336: ,p_attribute1_o
337: => ota_tpm_shd.g_old_rec.attribute1
338: ,p_attribute2_o
339: => ota_tpm_shd.g_old_rec.attribute2
333: => ota_tpm_shd.g_old_rec.object_version_number
334: ,p_attribute_category_o
335: => ota_tpm_shd.g_old_rec.attribute_category
336: ,p_attribute1_o
337: => ota_tpm_shd.g_old_rec.attribute1
338: ,p_attribute2_o
339: => ota_tpm_shd.g_old_rec.attribute2
340: ,p_attribute3_o
341: => ota_tpm_shd.g_old_rec.attribute3
335: => ota_tpm_shd.g_old_rec.attribute_category
336: ,p_attribute1_o
337: => ota_tpm_shd.g_old_rec.attribute1
338: ,p_attribute2_o
339: => ota_tpm_shd.g_old_rec.attribute2
340: ,p_attribute3_o
341: => ota_tpm_shd.g_old_rec.attribute3
342: ,p_attribute4_o
343: => ota_tpm_shd.g_old_rec.attribute4
337: => ota_tpm_shd.g_old_rec.attribute1
338: ,p_attribute2_o
339: => ota_tpm_shd.g_old_rec.attribute2
340: ,p_attribute3_o
341: => ota_tpm_shd.g_old_rec.attribute3
342: ,p_attribute4_o
343: => ota_tpm_shd.g_old_rec.attribute4
344: ,p_attribute5_o
345: => ota_tpm_shd.g_old_rec.attribute5
339: => ota_tpm_shd.g_old_rec.attribute2
340: ,p_attribute3_o
341: => ota_tpm_shd.g_old_rec.attribute3
342: ,p_attribute4_o
343: => ota_tpm_shd.g_old_rec.attribute4
344: ,p_attribute5_o
345: => ota_tpm_shd.g_old_rec.attribute5
346: ,p_attribute6_o
347: => ota_tpm_shd.g_old_rec.attribute6
341: => ota_tpm_shd.g_old_rec.attribute3
342: ,p_attribute4_o
343: => ota_tpm_shd.g_old_rec.attribute4
344: ,p_attribute5_o
345: => ota_tpm_shd.g_old_rec.attribute5
346: ,p_attribute6_o
347: => ota_tpm_shd.g_old_rec.attribute6
348: ,p_attribute7_o
349: => ota_tpm_shd.g_old_rec.attribute7
343: => ota_tpm_shd.g_old_rec.attribute4
344: ,p_attribute5_o
345: => ota_tpm_shd.g_old_rec.attribute5
346: ,p_attribute6_o
347: => ota_tpm_shd.g_old_rec.attribute6
348: ,p_attribute7_o
349: => ota_tpm_shd.g_old_rec.attribute7
350: ,p_attribute8_o
351: => ota_tpm_shd.g_old_rec.attribute8
345: => ota_tpm_shd.g_old_rec.attribute5
346: ,p_attribute6_o
347: => ota_tpm_shd.g_old_rec.attribute6
348: ,p_attribute7_o
349: => ota_tpm_shd.g_old_rec.attribute7
350: ,p_attribute8_o
351: => ota_tpm_shd.g_old_rec.attribute8
352: ,p_attribute9_o
353: => ota_tpm_shd.g_old_rec.attribute9
347: => ota_tpm_shd.g_old_rec.attribute6
348: ,p_attribute7_o
349: => ota_tpm_shd.g_old_rec.attribute7
350: ,p_attribute8_o
351: => ota_tpm_shd.g_old_rec.attribute8
352: ,p_attribute9_o
353: => ota_tpm_shd.g_old_rec.attribute9
354: ,p_attribute10_o
355: => ota_tpm_shd.g_old_rec.attribute10
349: => ota_tpm_shd.g_old_rec.attribute7
350: ,p_attribute8_o
351: => ota_tpm_shd.g_old_rec.attribute8
352: ,p_attribute9_o
353: => ota_tpm_shd.g_old_rec.attribute9
354: ,p_attribute10_o
355: => ota_tpm_shd.g_old_rec.attribute10
356: ,p_attribute11_o
357: => ota_tpm_shd.g_old_rec.attribute11
351: => ota_tpm_shd.g_old_rec.attribute8
352: ,p_attribute9_o
353: => ota_tpm_shd.g_old_rec.attribute9
354: ,p_attribute10_o
355: => ota_tpm_shd.g_old_rec.attribute10
356: ,p_attribute11_o
357: => ota_tpm_shd.g_old_rec.attribute11
358: ,p_attribute12_o
359: => ota_tpm_shd.g_old_rec.attribute12
353: => ota_tpm_shd.g_old_rec.attribute9
354: ,p_attribute10_o
355: => ota_tpm_shd.g_old_rec.attribute10
356: ,p_attribute11_o
357: => ota_tpm_shd.g_old_rec.attribute11
358: ,p_attribute12_o
359: => ota_tpm_shd.g_old_rec.attribute12
360: ,p_attribute13_o
361: => ota_tpm_shd.g_old_rec.attribute13
355: => ota_tpm_shd.g_old_rec.attribute10
356: ,p_attribute11_o
357: => ota_tpm_shd.g_old_rec.attribute11
358: ,p_attribute12_o
359: => ota_tpm_shd.g_old_rec.attribute12
360: ,p_attribute13_o
361: => ota_tpm_shd.g_old_rec.attribute13
362: ,p_attribute14_o
363: => ota_tpm_shd.g_old_rec.attribute14
357: => ota_tpm_shd.g_old_rec.attribute11
358: ,p_attribute12_o
359: => ota_tpm_shd.g_old_rec.attribute12
360: ,p_attribute13_o
361: => ota_tpm_shd.g_old_rec.attribute13
362: ,p_attribute14_o
363: => ota_tpm_shd.g_old_rec.attribute14
364: ,p_attribute15_o
365: => ota_tpm_shd.g_old_rec.attribute15
359: => ota_tpm_shd.g_old_rec.attribute12
360: ,p_attribute13_o
361: => ota_tpm_shd.g_old_rec.attribute13
362: ,p_attribute14_o
363: => ota_tpm_shd.g_old_rec.attribute14
364: ,p_attribute15_o
365: => ota_tpm_shd.g_old_rec.attribute15
366: ,p_attribute16_o
367: => ota_tpm_shd.g_old_rec.attribute16
361: => ota_tpm_shd.g_old_rec.attribute13
362: ,p_attribute14_o
363: => ota_tpm_shd.g_old_rec.attribute14
364: ,p_attribute15_o
365: => ota_tpm_shd.g_old_rec.attribute15
366: ,p_attribute16_o
367: => ota_tpm_shd.g_old_rec.attribute16
368: ,p_attribute17_o
369: => ota_tpm_shd.g_old_rec.attribute17
363: => ota_tpm_shd.g_old_rec.attribute14
364: ,p_attribute15_o
365: => ota_tpm_shd.g_old_rec.attribute15
366: ,p_attribute16_o
367: => ota_tpm_shd.g_old_rec.attribute16
368: ,p_attribute17_o
369: => ota_tpm_shd.g_old_rec.attribute17
370: ,p_attribute18_o
371: => ota_tpm_shd.g_old_rec.attribute18
365: => ota_tpm_shd.g_old_rec.attribute15
366: ,p_attribute16_o
367: => ota_tpm_shd.g_old_rec.attribute16
368: ,p_attribute17_o
369: => ota_tpm_shd.g_old_rec.attribute17
370: ,p_attribute18_o
371: => ota_tpm_shd.g_old_rec.attribute18
372: ,p_attribute19_o
373: => ota_tpm_shd.g_old_rec.attribute19
367: => ota_tpm_shd.g_old_rec.attribute16
368: ,p_attribute17_o
369: => ota_tpm_shd.g_old_rec.attribute17
370: ,p_attribute18_o
371: => ota_tpm_shd.g_old_rec.attribute18
372: ,p_attribute19_o
373: => ota_tpm_shd.g_old_rec.attribute19
374: ,p_attribute20_o
375: => ota_tpm_shd.g_old_rec.attribute20
369: => ota_tpm_shd.g_old_rec.attribute17
370: ,p_attribute18_o
371: => ota_tpm_shd.g_old_rec.attribute18
372: ,p_attribute19_o
373: => ota_tpm_shd.g_old_rec.attribute19
374: ,p_attribute20_o
375: => ota_tpm_shd.g_old_rec.attribute20
376: ,p_attribute21_o
377: => ota_tpm_shd.g_old_rec.attribute21
371: => ota_tpm_shd.g_old_rec.attribute18
372: ,p_attribute19_o
373: => ota_tpm_shd.g_old_rec.attribute19
374: ,p_attribute20_o
375: => ota_tpm_shd.g_old_rec.attribute20
376: ,p_attribute21_o
377: => ota_tpm_shd.g_old_rec.attribute21
378: ,p_attribute22_o
379: => ota_tpm_shd.g_old_rec.attribute22
373: => ota_tpm_shd.g_old_rec.attribute19
374: ,p_attribute20_o
375: => ota_tpm_shd.g_old_rec.attribute20
376: ,p_attribute21_o
377: => ota_tpm_shd.g_old_rec.attribute21
378: ,p_attribute22_o
379: => ota_tpm_shd.g_old_rec.attribute22
380: ,p_attribute23_o
381: => ota_tpm_shd.g_old_rec.attribute23
375: => ota_tpm_shd.g_old_rec.attribute20
376: ,p_attribute21_o
377: => ota_tpm_shd.g_old_rec.attribute21
378: ,p_attribute22_o
379: => ota_tpm_shd.g_old_rec.attribute22
380: ,p_attribute23_o
381: => ota_tpm_shd.g_old_rec.attribute23
382: ,p_attribute24_o
383: => ota_tpm_shd.g_old_rec.attribute24
377: => ota_tpm_shd.g_old_rec.attribute21
378: ,p_attribute22_o
379: => ota_tpm_shd.g_old_rec.attribute22
380: ,p_attribute23_o
381: => ota_tpm_shd.g_old_rec.attribute23
382: ,p_attribute24_o
383: => ota_tpm_shd.g_old_rec.attribute24
384: ,p_attribute25_o
385: => ota_tpm_shd.g_old_rec.attribute25
379: => ota_tpm_shd.g_old_rec.attribute22
380: ,p_attribute23_o
381: => ota_tpm_shd.g_old_rec.attribute23
382: ,p_attribute24_o
383: => ota_tpm_shd.g_old_rec.attribute24
384: ,p_attribute25_o
385: => ota_tpm_shd.g_old_rec.attribute25
386: ,p_attribute26_o
387: => ota_tpm_shd.g_old_rec.attribute26
381: => ota_tpm_shd.g_old_rec.attribute23
382: ,p_attribute24_o
383: => ota_tpm_shd.g_old_rec.attribute24
384: ,p_attribute25_o
385: => ota_tpm_shd.g_old_rec.attribute25
386: ,p_attribute26_o
387: => ota_tpm_shd.g_old_rec.attribute26
388: ,p_attribute27_o
389: => ota_tpm_shd.g_old_rec.attribute27
383: => ota_tpm_shd.g_old_rec.attribute24
384: ,p_attribute25_o
385: => ota_tpm_shd.g_old_rec.attribute25
386: ,p_attribute26_o
387: => ota_tpm_shd.g_old_rec.attribute26
388: ,p_attribute27_o
389: => ota_tpm_shd.g_old_rec.attribute27
390: ,p_attribute28_o
391: => ota_tpm_shd.g_old_rec.attribute28
385: => ota_tpm_shd.g_old_rec.attribute25
386: ,p_attribute26_o
387: => ota_tpm_shd.g_old_rec.attribute26
388: ,p_attribute27_o
389: => ota_tpm_shd.g_old_rec.attribute27
390: ,p_attribute28_o
391: => ota_tpm_shd.g_old_rec.attribute28
392: ,p_attribute29_o
393: => ota_tpm_shd.g_old_rec.attribute29
387: => ota_tpm_shd.g_old_rec.attribute26
388: ,p_attribute27_o
389: => ota_tpm_shd.g_old_rec.attribute27
390: ,p_attribute28_o
391: => ota_tpm_shd.g_old_rec.attribute28
392: ,p_attribute29_o
393: => ota_tpm_shd.g_old_rec.attribute29
394: ,p_attribute30_o
395: => ota_tpm_shd.g_old_rec.attribute30
389: => ota_tpm_shd.g_old_rec.attribute27
390: ,p_attribute28_o
391: => ota_tpm_shd.g_old_rec.attribute28
392: ,p_attribute29_o
393: => ota_tpm_shd.g_old_rec.attribute29
394: ,p_attribute30_o
395: => ota_tpm_shd.g_old_rec.attribute30
396: ,p_assignment_id_o => ota_tpm_shd.g_old_rec.assignment_id
397: ,p_source_id_o => ota_tpm_shd.g_old_rec.source_id
391: => ota_tpm_shd.g_old_rec.attribute28
392: ,p_attribute29_o
393: => ota_tpm_shd.g_old_rec.attribute29
394: ,p_attribute30_o
395: => ota_tpm_shd.g_old_rec.attribute30
396: ,p_assignment_id_o => ota_tpm_shd.g_old_rec.assignment_id
397: ,p_source_id_o => ota_tpm_shd.g_old_rec.source_id
398: ,p_source_function_o => ota_tpm_shd.g_old_rec.source_function
399: ,p_cancellation_reason_o => ota_tpm_shd.g_old_rec.cancellation_reason
392: ,p_attribute29_o
393: => ota_tpm_shd.g_old_rec.attribute29
394: ,p_attribute30_o
395: => ota_tpm_shd.g_old_rec.attribute30
396: ,p_assignment_id_o => ota_tpm_shd.g_old_rec.assignment_id
397: ,p_source_id_o => ota_tpm_shd.g_old_rec.source_id
398: ,p_source_function_o => ota_tpm_shd.g_old_rec.source_function
399: ,p_cancellation_reason_o => ota_tpm_shd.g_old_rec.cancellation_reason
400: ,p_earliest_start_date_o => ota_tpm_shd.g_old_rec.earliest_start_date
393: => ota_tpm_shd.g_old_rec.attribute29
394: ,p_attribute30_o
395: => ota_tpm_shd.g_old_rec.attribute30
396: ,p_assignment_id_o => ota_tpm_shd.g_old_rec.assignment_id
397: ,p_source_id_o => ota_tpm_shd.g_old_rec.source_id
398: ,p_source_function_o => ota_tpm_shd.g_old_rec.source_function
399: ,p_cancellation_reason_o => ota_tpm_shd.g_old_rec.cancellation_reason
400: ,p_earliest_start_date_o => ota_tpm_shd.g_old_rec.earliest_start_date
401: ,p_creator_person_id_o => ota_tpm_shd.g_old_rec.creator_person_id
394: ,p_attribute30_o
395: => ota_tpm_shd.g_old_rec.attribute30
396: ,p_assignment_id_o => ota_tpm_shd.g_old_rec.assignment_id
397: ,p_source_id_o => ota_tpm_shd.g_old_rec.source_id
398: ,p_source_function_o => ota_tpm_shd.g_old_rec.source_function
399: ,p_cancellation_reason_o => ota_tpm_shd.g_old_rec.cancellation_reason
400: ,p_earliest_start_date_o => ota_tpm_shd.g_old_rec.earliest_start_date
401: ,p_creator_person_id_o => ota_tpm_shd.g_old_rec.creator_person_id
402: );
395: => ota_tpm_shd.g_old_rec.attribute30
396: ,p_assignment_id_o => ota_tpm_shd.g_old_rec.assignment_id
397: ,p_source_id_o => ota_tpm_shd.g_old_rec.source_id
398: ,p_source_function_o => ota_tpm_shd.g_old_rec.source_function
399: ,p_cancellation_reason_o => ota_tpm_shd.g_old_rec.cancellation_reason
400: ,p_earliest_start_date_o => ota_tpm_shd.g_old_rec.earliest_start_date
401: ,p_creator_person_id_o => ota_tpm_shd.g_old_rec.creator_person_id
402: );
403: --
396: ,p_assignment_id_o => ota_tpm_shd.g_old_rec.assignment_id
397: ,p_source_id_o => ota_tpm_shd.g_old_rec.source_id
398: ,p_source_function_o => ota_tpm_shd.g_old_rec.source_function
399: ,p_cancellation_reason_o => ota_tpm_shd.g_old_rec.cancellation_reason
400: ,p_earliest_start_date_o => ota_tpm_shd.g_old_rec.earliest_start_date
401: ,p_creator_person_id_o => ota_tpm_shd.g_old_rec.creator_person_id
402: );
403: --
404: exception
397: ,p_source_id_o => ota_tpm_shd.g_old_rec.source_id
398: ,p_source_function_o => ota_tpm_shd.g_old_rec.source_function
399: ,p_cancellation_reason_o => ota_tpm_shd.g_old_rec.cancellation_reason
400: ,p_earliest_start_date_o => ota_tpm_shd.g_old_rec.earliest_start_date
401: ,p_creator_person_id_o => ota_tpm_shd.g_old_rec.creator_person_id
402: );
403: --
404: exception
405: --
457: --
458: -- {End Of Comments}
459: -- ----------------------------------------------------------------------------
460: Procedure convert_defs
461: (p_rec in out nocopy ota_tpm_shd.g_rec_type
462: ) is
463: --
464: Begin
465: --
469: -- is being used then we must set to the 'current' argument value.
470: --
471: If (p_rec.training_plan_id = hr_api.g_number) then
472: p_rec.training_plan_id :=
473: ota_tpm_shd.g_old_rec.training_plan_id;
474: End If;
475: If (p_rec.activity_version_id = hr_api.g_number) then
476: p_rec.activity_version_id :=
477: ota_tpm_shd.g_old_rec.activity_version_id;
473: ota_tpm_shd.g_old_rec.training_plan_id;
474: End If;
475: If (p_rec.activity_version_id = hr_api.g_number) then
476: p_rec.activity_version_id :=
477: ota_tpm_shd.g_old_rec.activity_version_id;
478: End If;
479: If (p_rec.activity_definition_id = hr_api.g_number) then
480: p_rec.activity_definition_id :=
481: ota_tpm_shd.g_old_rec.activity_definition_id;
477: ota_tpm_shd.g_old_rec.activity_version_id;
478: End If;
479: If (p_rec.activity_definition_id = hr_api.g_number) then
480: p_rec.activity_definition_id :=
481: ota_tpm_shd.g_old_rec.activity_definition_id;
482: End If;
483: If (p_rec.member_status_type_id = hr_api.g_varchar2) then
484: p_rec.member_status_type_id :=
485: ota_tpm_shd.g_old_rec.member_status_type_id;
481: ota_tpm_shd.g_old_rec.activity_definition_id;
482: End If;
483: If (p_rec.member_status_type_id = hr_api.g_varchar2) then
484: p_rec.member_status_type_id :=
485: ota_tpm_shd.g_old_rec.member_status_type_id;
486: End If;
487: If (p_rec.target_completion_date = hr_api.g_date) then
488: p_rec.target_completion_date :=
489: ota_tpm_shd.g_old_rec.target_completion_date;
485: ota_tpm_shd.g_old_rec.member_status_type_id;
486: End If;
487: If (p_rec.target_completion_date = hr_api.g_date) then
488: p_rec.target_completion_date :=
489: ota_tpm_shd.g_old_rec.target_completion_date;
490: End If;
491: If (p_rec.business_group_id = hr_api.g_number) then
492: p_rec.business_group_id :=
493: ota_tpm_shd.g_old_rec.business_group_id;
489: ota_tpm_shd.g_old_rec.target_completion_date;
490: End If;
491: If (p_rec.business_group_id = hr_api.g_number) then
492: p_rec.business_group_id :=
493: ota_tpm_shd.g_old_rec.business_group_id;
494: End If;
495: If (p_rec.attribute_category = hr_api.g_varchar2) then
496: p_rec.attribute_category :=
497: ota_tpm_shd.g_old_rec.attribute_category;
493: ota_tpm_shd.g_old_rec.business_group_id;
494: End If;
495: If (p_rec.attribute_category = hr_api.g_varchar2) then
496: p_rec.attribute_category :=
497: ota_tpm_shd.g_old_rec.attribute_category;
498: End If;
499: If (p_rec.attribute1 = hr_api.g_varchar2) then
500: p_rec.attribute1 :=
501: ota_tpm_shd.g_old_rec.attribute1;
497: ota_tpm_shd.g_old_rec.attribute_category;
498: End If;
499: If (p_rec.attribute1 = hr_api.g_varchar2) then
500: p_rec.attribute1 :=
501: ota_tpm_shd.g_old_rec.attribute1;
502: End If;
503: If (p_rec.attribute2 = hr_api.g_varchar2) then
504: p_rec.attribute2 :=
505: ota_tpm_shd.g_old_rec.attribute2;
501: ota_tpm_shd.g_old_rec.attribute1;
502: End If;
503: If (p_rec.attribute2 = hr_api.g_varchar2) then
504: p_rec.attribute2 :=
505: ota_tpm_shd.g_old_rec.attribute2;
506: End If;
507: If (p_rec.attribute3 = hr_api.g_varchar2) then
508: p_rec.attribute3 :=
509: ota_tpm_shd.g_old_rec.attribute3;
505: ota_tpm_shd.g_old_rec.attribute2;
506: End If;
507: If (p_rec.attribute3 = hr_api.g_varchar2) then
508: p_rec.attribute3 :=
509: ota_tpm_shd.g_old_rec.attribute3;
510: End If;
511: If (p_rec.attribute4 = hr_api.g_varchar2) then
512: p_rec.attribute4 :=
513: ota_tpm_shd.g_old_rec.attribute4;
509: ota_tpm_shd.g_old_rec.attribute3;
510: End If;
511: If (p_rec.attribute4 = hr_api.g_varchar2) then
512: p_rec.attribute4 :=
513: ota_tpm_shd.g_old_rec.attribute4;
514: End If;
515: If (p_rec.attribute5 = hr_api.g_varchar2) then
516: p_rec.attribute5 :=
517: ota_tpm_shd.g_old_rec.attribute5;
513: ota_tpm_shd.g_old_rec.attribute4;
514: End If;
515: If (p_rec.attribute5 = hr_api.g_varchar2) then
516: p_rec.attribute5 :=
517: ota_tpm_shd.g_old_rec.attribute5;
518: End If;
519: If (p_rec.attribute6 = hr_api.g_varchar2) then
520: p_rec.attribute6 :=
521: ota_tpm_shd.g_old_rec.attribute6;
517: ota_tpm_shd.g_old_rec.attribute5;
518: End If;
519: If (p_rec.attribute6 = hr_api.g_varchar2) then
520: p_rec.attribute6 :=
521: ota_tpm_shd.g_old_rec.attribute6;
522: End If;
523: If (p_rec.attribute7 = hr_api.g_varchar2) then
524: p_rec.attribute7 :=
525: ota_tpm_shd.g_old_rec.attribute7;
521: ota_tpm_shd.g_old_rec.attribute6;
522: End If;
523: If (p_rec.attribute7 = hr_api.g_varchar2) then
524: p_rec.attribute7 :=
525: ota_tpm_shd.g_old_rec.attribute7;
526: End If;
527: If (p_rec.attribute8 = hr_api.g_varchar2) then
528: p_rec.attribute8 :=
529: ota_tpm_shd.g_old_rec.attribute8;
525: ota_tpm_shd.g_old_rec.attribute7;
526: End If;
527: If (p_rec.attribute8 = hr_api.g_varchar2) then
528: p_rec.attribute8 :=
529: ota_tpm_shd.g_old_rec.attribute8;
530: End If;
531: If (p_rec.attribute9 = hr_api.g_varchar2) then
532: p_rec.attribute9 :=
533: ota_tpm_shd.g_old_rec.attribute9;
529: ota_tpm_shd.g_old_rec.attribute8;
530: End If;
531: If (p_rec.attribute9 = hr_api.g_varchar2) then
532: p_rec.attribute9 :=
533: ota_tpm_shd.g_old_rec.attribute9;
534: End If;
535: If (p_rec.attribute10 = hr_api.g_varchar2) then
536: p_rec.attribute10 :=
537: ota_tpm_shd.g_old_rec.attribute10;
533: ota_tpm_shd.g_old_rec.attribute9;
534: End If;
535: If (p_rec.attribute10 = hr_api.g_varchar2) then
536: p_rec.attribute10 :=
537: ota_tpm_shd.g_old_rec.attribute10;
538: End If;
539: If (p_rec.attribute11 = hr_api.g_varchar2) then
540: p_rec.attribute11 :=
541: ota_tpm_shd.g_old_rec.attribute11;
537: ota_tpm_shd.g_old_rec.attribute10;
538: End If;
539: If (p_rec.attribute11 = hr_api.g_varchar2) then
540: p_rec.attribute11 :=
541: ota_tpm_shd.g_old_rec.attribute11;
542: End If;
543: If (p_rec.attribute12 = hr_api.g_varchar2) then
544: p_rec.attribute12 :=
545: ota_tpm_shd.g_old_rec.attribute12;
541: ota_tpm_shd.g_old_rec.attribute11;
542: End If;
543: If (p_rec.attribute12 = hr_api.g_varchar2) then
544: p_rec.attribute12 :=
545: ota_tpm_shd.g_old_rec.attribute12;
546: End If;
547: If (p_rec.attribute13 = hr_api.g_varchar2) then
548: p_rec.attribute13 :=
549: ota_tpm_shd.g_old_rec.attribute13;
545: ota_tpm_shd.g_old_rec.attribute12;
546: End If;
547: If (p_rec.attribute13 = hr_api.g_varchar2) then
548: p_rec.attribute13 :=
549: ota_tpm_shd.g_old_rec.attribute13;
550: End If;
551: If (p_rec.attribute14 = hr_api.g_varchar2) then
552: p_rec.attribute14 :=
553: ota_tpm_shd.g_old_rec.attribute14;
549: ota_tpm_shd.g_old_rec.attribute13;
550: End If;
551: If (p_rec.attribute14 = hr_api.g_varchar2) then
552: p_rec.attribute14 :=
553: ota_tpm_shd.g_old_rec.attribute14;
554: End If;
555: If (p_rec.attribute15 = hr_api.g_varchar2) then
556: p_rec.attribute15 :=
557: ota_tpm_shd.g_old_rec.attribute15;
553: ota_tpm_shd.g_old_rec.attribute14;
554: End If;
555: If (p_rec.attribute15 = hr_api.g_varchar2) then
556: p_rec.attribute15 :=
557: ota_tpm_shd.g_old_rec.attribute15;
558: End If;
559: If (p_rec.attribute16 = hr_api.g_varchar2) then
560: p_rec.attribute16 :=
561: ota_tpm_shd.g_old_rec.attribute16;
557: ota_tpm_shd.g_old_rec.attribute15;
558: End If;
559: If (p_rec.attribute16 = hr_api.g_varchar2) then
560: p_rec.attribute16 :=
561: ota_tpm_shd.g_old_rec.attribute16;
562: End If;
563: If (p_rec.attribute17 = hr_api.g_varchar2) then
564: p_rec.attribute17 :=
565: ota_tpm_shd.g_old_rec.attribute17;
561: ota_tpm_shd.g_old_rec.attribute16;
562: End If;
563: If (p_rec.attribute17 = hr_api.g_varchar2) then
564: p_rec.attribute17 :=
565: ota_tpm_shd.g_old_rec.attribute17;
566: End If;
567: If (p_rec.attribute18 = hr_api.g_varchar2) then
568: p_rec.attribute18 :=
569: ota_tpm_shd.g_old_rec.attribute18;
565: ota_tpm_shd.g_old_rec.attribute17;
566: End If;
567: If (p_rec.attribute18 = hr_api.g_varchar2) then
568: p_rec.attribute18 :=
569: ota_tpm_shd.g_old_rec.attribute18;
570: End If;
571: If (p_rec.attribute19 = hr_api.g_varchar2) then
572: p_rec.attribute19 :=
573: ota_tpm_shd.g_old_rec.attribute19;
569: ota_tpm_shd.g_old_rec.attribute18;
570: End If;
571: If (p_rec.attribute19 = hr_api.g_varchar2) then
572: p_rec.attribute19 :=
573: ota_tpm_shd.g_old_rec.attribute19;
574: End If;
575: If (p_rec.attribute20 = hr_api.g_varchar2) then
576: p_rec.attribute20 :=
577: ota_tpm_shd.g_old_rec.attribute20;
573: ota_tpm_shd.g_old_rec.attribute19;
574: End If;
575: If (p_rec.attribute20 = hr_api.g_varchar2) then
576: p_rec.attribute20 :=
577: ota_tpm_shd.g_old_rec.attribute20;
578: End If;
579: If (p_rec.attribute21 = hr_api.g_varchar2) then
580: p_rec.attribute21 :=
581: ota_tpm_shd.g_old_rec.attribute21;
577: ota_tpm_shd.g_old_rec.attribute20;
578: End If;
579: If (p_rec.attribute21 = hr_api.g_varchar2) then
580: p_rec.attribute21 :=
581: ota_tpm_shd.g_old_rec.attribute21;
582: End If;
583: If (p_rec.attribute22 = hr_api.g_varchar2) then
584: p_rec.attribute22 :=
585: ota_tpm_shd.g_old_rec.attribute22;
581: ota_tpm_shd.g_old_rec.attribute21;
582: End If;
583: If (p_rec.attribute22 = hr_api.g_varchar2) then
584: p_rec.attribute22 :=
585: ota_tpm_shd.g_old_rec.attribute22;
586: End If;
587: If (p_rec.attribute23 = hr_api.g_varchar2) then
588: p_rec.attribute23 :=
589: ota_tpm_shd.g_old_rec.attribute23;
585: ota_tpm_shd.g_old_rec.attribute22;
586: End If;
587: If (p_rec.attribute23 = hr_api.g_varchar2) then
588: p_rec.attribute23 :=
589: ota_tpm_shd.g_old_rec.attribute23;
590: End If;
591: If (p_rec.attribute24 = hr_api.g_varchar2) then
592: p_rec.attribute24 :=
593: ota_tpm_shd.g_old_rec.attribute24;
589: ota_tpm_shd.g_old_rec.attribute23;
590: End If;
591: If (p_rec.attribute24 = hr_api.g_varchar2) then
592: p_rec.attribute24 :=
593: ota_tpm_shd.g_old_rec.attribute24;
594: End If;
595: If (p_rec.attribute25 = hr_api.g_varchar2) then
596: p_rec.attribute25 :=
597: ota_tpm_shd.g_old_rec.attribute25;
593: ota_tpm_shd.g_old_rec.attribute24;
594: End If;
595: If (p_rec.attribute25 = hr_api.g_varchar2) then
596: p_rec.attribute25 :=
597: ota_tpm_shd.g_old_rec.attribute25;
598: End If;
599: If (p_rec.attribute26 = hr_api.g_varchar2) then
600: p_rec.attribute26 :=
601: ota_tpm_shd.g_old_rec.attribute26;
597: ota_tpm_shd.g_old_rec.attribute25;
598: End If;
599: If (p_rec.attribute26 = hr_api.g_varchar2) then
600: p_rec.attribute26 :=
601: ota_tpm_shd.g_old_rec.attribute26;
602: End If;
603: If (p_rec.attribute27 = hr_api.g_varchar2) then
604: p_rec.attribute27 :=
605: ota_tpm_shd.g_old_rec.attribute27;
601: ota_tpm_shd.g_old_rec.attribute26;
602: End If;
603: If (p_rec.attribute27 = hr_api.g_varchar2) then
604: p_rec.attribute27 :=
605: ota_tpm_shd.g_old_rec.attribute27;
606: End If;
607: If (p_rec.attribute28 = hr_api.g_varchar2) then
608: p_rec.attribute28 :=
609: ota_tpm_shd.g_old_rec.attribute28;
605: ota_tpm_shd.g_old_rec.attribute27;
606: End If;
607: If (p_rec.attribute28 = hr_api.g_varchar2) then
608: p_rec.attribute28 :=
609: ota_tpm_shd.g_old_rec.attribute28;
610: End If;
611: If (p_rec.attribute29 = hr_api.g_varchar2) then
612: p_rec.attribute29 :=
613: ota_tpm_shd.g_old_rec.attribute29;
609: ota_tpm_shd.g_old_rec.attribute28;
610: End If;
611: If (p_rec.attribute29 = hr_api.g_varchar2) then
612: p_rec.attribute29 :=
613: ota_tpm_shd.g_old_rec.attribute29;
614: End If;
615: If (p_rec.attribute30 = hr_api.g_varchar2) then
616: p_rec.attribute30 :=
617: ota_tpm_shd.g_old_rec.attribute30;
613: ota_tpm_shd.g_old_rec.attribute29;
614: End If;
615: If (p_rec.attribute30 = hr_api.g_varchar2) then
616: p_rec.attribute30 :=
617: ota_tpm_shd.g_old_rec.attribute30;
618: End If;
619: If (p_rec.assignment_id = hr_api.g_number) then
620: p_rec.assignment_id :=
621: ota_tpm_shd.g_old_rec.assignment_id;
617: ota_tpm_shd.g_old_rec.attribute30;
618: End If;
619: If (p_rec.assignment_id = hr_api.g_number) then
620: p_rec.assignment_id :=
621: ota_tpm_shd.g_old_rec.assignment_id;
622: End If;
623: If (p_rec.source_id = hr_api.g_number) then
624: p_rec.source_id :=
625: ota_tpm_shd.g_old_rec.source_id;
621: ota_tpm_shd.g_old_rec.assignment_id;
622: End If;
623: If (p_rec.source_id = hr_api.g_number) then
624: p_rec.source_id :=
625: ota_tpm_shd.g_old_rec.source_id;
626: End If;
627: If (p_rec.source_function = hr_api.g_varchar2) then
628: p_rec.source_function :=
629: ota_tpm_shd.g_old_rec.source_function;
625: ota_tpm_shd.g_old_rec.source_id;
626: End If;
627: If (p_rec.source_function = hr_api.g_varchar2) then
628: p_rec.source_function :=
629: ota_tpm_shd.g_old_rec.source_function;
630: End If;
631: If (p_rec.cancellation_reason = hr_api.g_varchar2) then
632: p_rec.cancellation_reason :=
633: ota_tpm_shd.g_old_rec.cancellation_reason;
629: ota_tpm_shd.g_old_rec.source_function;
630: End If;
631: If (p_rec.cancellation_reason = hr_api.g_varchar2) then
632: p_rec.cancellation_reason :=
633: ota_tpm_shd.g_old_rec.cancellation_reason;
634: End If;
635: If (p_rec.earliest_start_date = hr_api.g_date) then
636: p_rec.earliest_start_date :=
637: ota_tpm_shd.g_old_rec.earliest_start_date;
633: ota_tpm_shd.g_old_rec.cancellation_reason;
634: End If;
635: If (p_rec.earliest_start_date = hr_api.g_date) then
636: p_rec.earliest_start_date :=
637: ota_tpm_shd.g_old_rec.earliest_start_date;
638: End If;
639: If (p_rec.creator_person_id = hr_api.g_number) then
640: p_rec.creator_person_id :=
641: ota_tpm_shd.g_old_rec.creator_person_id;
637: ota_tpm_shd.g_old_rec.earliest_start_date;
638: End If;
639: If (p_rec.creator_person_id = hr_api.g_number) then
640: p_rec.creator_person_id :=
641: ota_tpm_shd.g_old_rec.creator_person_id;
642: End If;
643: --
644: End convert_defs;
645: --
647: -- |---------------------------------< upd >----------------------------------|
648: -- ----------------------------------------------------------------------------
649: Procedure upd
650: (p_effective_date in date
651: ,p_rec in out nocopy ota_tpm_shd.g_rec_type
652: ) is
653: --
654: l_proc varchar2(72) := g_package||'upd';
655: --
657: hr_utility.set_location('Entering:'||l_proc, 5);
658: --
659: -- We must lock the row which we need to update.
660: --
661: ota_tpm_shd.lck
662: (p_rec.training_plan_member_id
663: ,p_rec.object_version_number
664: );
665: --
744: ,P_earliest_start_date in date default hr_api.g_date
745: ,p_creator_person_id in number default hr_api.g_number
746: ) is
747: --
748: l_rec ota_tpm_shd.g_rec_type;
749: l_proc varchar2(72) := g_package||'upd';
750: --
751: Begin
752: hr_utility.set_location('Entering:'||l_proc, 5);
754: -- Call conversion function to turn arguments into the
755: -- l_rec structure.
756: --
757: l_rec :=
758: ota_tpm_shd.convert_args
759: (p_training_plan_member_id
760: ,hr_api.g_number
761: ,p_activity_version_id
762: ,p_activity_definition_id