[Home] [Help]
50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ota_nhs_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ota_nhs_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ota_notrng_histories Row
68: --
69: update ota_notrng_histories
110: customer_id = p_rec.customer_id,
111: organization_id = p_rec.organization_id
112: where nota_history_id = p_rec.nota_history_id;
113: --
114: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
115: --
116: hr_utility.set_location(' Leaving:'||l_proc, 10);
117: --
118: Exception
117: --
118: Exception
119: When hr_api.check_integrity_violated Then
120: -- A check constraint has been violated
121: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
122: ota_nhs_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
118: Exception
119: When hr_api.check_integrity_violated Then
120: -- A check constraint has been violated
121: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
122: ota_nhs_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
126: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
122: ota_nhs_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
126: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
127: ota_nhs_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.unique_integrity_violated Then
130: -- Unique integrity has been violated
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
126: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
127: ota_nhs_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.unique_integrity_violated Then
130: -- Unique integrity has been violated
131: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
127: ota_nhs_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.unique_integrity_violated Then
130: -- Unique integrity has been violated
131: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
132: ota_nhs_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When Others Then
135: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.unique_integrity_violated Then
130: -- Unique integrity has been violated
131: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
132: ota_nhs_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When Others Then
135: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
136: Raise;
131: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
132: ota_nhs_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When Others Then
135: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
136: Raise;
137: End update_dml;
138: --
139: -- ----------------------------------------------------------------------------
167: -- Internal Row Handler Use Only.
168: --
169: -- {End Of Comments}
170: -- ----------------------------------------------------------------------------
171: Procedure pre_update(p_rec in ota_nhs_shd.g_rec_type) is
172: --
173: l_proc varchar2(72) := g_package||'pre_update';
174: --
175: Begin
210: --
211: -- {End Of Comments}
212: -- ----------------------------------------------------------------------------
213: Procedure post_update(p_effective_date in date,
214: p_rec in ota_nhs_shd.g_rec_type) is
215: --
216: l_proc varchar2(72) := g_package||'post_update';
217: --
218: Begin
304: => p_rec.customer_id
305: ,p_organization_id
306: => p_rec.organization_id
307: ,p_person_id_o
308: => ota_nhs_shd.g_old_rec.person_id
309: ,p_contact_id_o
310: => ota_nhs_shd.g_old_rec.contact_id
311: ,p_trng_title_o
312: => ota_nhs_shd.g_old_rec.trng_title
306: => p_rec.organization_id
307: ,p_person_id_o
308: => ota_nhs_shd.g_old_rec.person_id
309: ,p_contact_id_o
310: => ota_nhs_shd.g_old_rec.contact_id
311: ,p_trng_title_o
312: => ota_nhs_shd.g_old_rec.trng_title
313: ,p_provider_o
314: => ota_nhs_shd.g_old_rec.provider
308: => ota_nhs_shd.g_old_rec.person_id
309: ,p_contact_id_o
310: => ota_nhs_shd.g_old_rec.contact_id
311: ,p_trng_title_o
312: => ota_nhs_shd.g_old_rec.trng_title
313: ,p_provider_o
314: => ota_nhs_shd.g_old_rec.provider
315: ,p_type_o
316: => ota_nhs_shd.g_old_rec.type
310: => ota_nhs_shd.g_old_rec.contact_id
311: ,p_trng_title_o
312: => ota_nhs_shd.g_old_rec.trng_title
313: ,p_provider_o
314: => ota_nhs_shd.g_old_rec.provider
315: ,p_type_o
316: => ota_nhs_shd.g_old_rec.type
317: ,p_centre_o
318: => ota_nhs_shd.g_old_rec.centre
312: => ota_nhs_shd.g_old_rec.trng_title
313: ,p_provider_o
314: => ota_nhs_shd.g_old_rec.provider
315: ,p_type_o
316: => ota_nhs_shd.g_old_rec.type
317: ,p_centre_o
318: => ota_nhs_shd.g_old_rec.centre
319: ,p_completion_date_o
320: => ota_nhs_shd.g_old_rec.completion_date
314: => ota_nhs_shd.g_old_rec.provider
315: ,p_type_o
316: => ota_nhs_shd.g_old_rec.type
317: ,p_centre_o
318: => ota_nhs_shd.g_old_rec.centre
319: ,p_completion_date_o
320: => ota_nhs_shd.g_old_rec.completion_date
321: ,p_award_o
322: => ota_nhs_shd.g_old_rec.award
316: => ota_nhs_shd.g_old_rec.type
317: ,p_centre_o
318: => ota_nhs_shd.g_old_rec.centre
319: ,p_completion_date_o
320: => ota_nhs_shd.g_old_rec.completion_date
321: ,p_award_o
322: => ota_nhs_shd.g_old_rec.award
323: ,p_rating_o
324: => ota_nhs_shd.g_old_rec.rating
318: => ota_nhs_shd.g_old_rec.centre
319: ,p_completion_date_o
320: => ota_nhs_shd.g_old_rec.completion_date
321: ,p_award_o
322: => ota_nhs_shd.g_old_rec.award
323: ,p_rating_o
324: => ota_nhs_shd.g_old_rec.rating
325: ,p_duration_o
326: => ota_nhs_shd.g_old_rec.duration
320: => ota_nhs_shd.g_old_rec.completion_date
321: ,p_award_o
322: => ota_nhs_shd.g_old_rec.award
323: ,p_rating_o
324: => ota_nhs_shd.g_old_rec.rating
325: ,p_duration_o
326: => ota_nhs_shd.g_old_rec.duration
327: ,p_duration_units_o
328: => ota_nhs_shd.g_old_rec.duration_units
322: => ota_nhs_shd.g_old_rec.award
323: ,p_rating_o
324: => ota_nhs_shd.g_old_rec.rating
325: ,p_duration_o
326: => ota_nhs_shd.g_old_rec.duration
327: ,p_duration_units_o
328: => ota_nhs_shd.g_old_rec.duration_units
329: ,p_activity_version_id_o
330: => ota_nhs_shd.g_old_rec.activity_version_id
324: => ota_nhs_shd.g_old_rec.rating
325: ,p_duration_o
326: => ota_nhs_shd.g_old_rec.duration
327: ,p_duration_units_o
328: => ota_nhs_shd.g_old_rec.duration_units
329: ,p_activity_version_id_o
330: => ota_nhs_shd.g_old_rec.activity_version_id
331: ,p_status_o
332: => ota_nhs_shd.g_old_rec.status
326: => ota_nhs_shd.g_old_rec.duration
327: ,p_duration_units_o
328: => ota_nhs_shd.g_old_rec.duration_units
329: ,p_activity_version_id_o
330: => ota_nhs_shd.g_old_rec.activity_version_id
331: ,p_status_o
332: => ota_nhs_shd.g_old_rec.status
333: ,p_verified_by_id_o
334: => ota_nhs_shd.g_old_rec.verified_by_id
328: => ota_nhs_shd.g_old_rec.duration_units
329: ,p_activity_version_id_o
330: => ota_nhs_shd.g_old_rec.activity_version_id
331: ,p_status_o
332: => ota_nhs_shd.g_old_rec.status
333: ,p_verified_by_id_o
334: => ota_nhs_shd.g_old_rec.verified_by_id
335: ,p_nth_information_category_o
336: => ota_nhs_shd.g_old_rec.nth_information_category
330: => ota_nhs_shd.g_old_rec.activity_version_id
331: ,p_status_o
332: => ota_nhs_shd.g_old_rec.status
333: ,p_verified_by_id_o
334: => ota_nhs_shd.g_old_rec.verified_by_id
335: ,p_nth_information_category_o
336: => ota_nhs_shd.g_old_rec.nth_information_category
337: ,p_nth_information1_o
338: => ota_nhs_shd.g_old_rec.nth_information1
332: => ota_nhs_shd.g_old_rec.status
333: ,p_verified_by_id_o
334: => ota_nhs_shd.g_old_rec.verified_by_id
335: ,p_nth_information_category_o
336: => ota_nhs_shd.g_old_rec.nth_information_category
337: ,p_nth_information1_o
338: => ota_nhs_shd.g_old_rec.nth_information1
339: ,p_nth_information2_o
340: => ota_nhs_shd.g_old_rec.nth_information2
334: => ota_nhs_shd.g_old_rec.verified_by_id
335: ,p_nth_information_category_o
336: => ota_nhs_shd.g_old_rec.nth_information_category
337: ,p_nth_information1_o
338: => ota_nhs_shd.g_old_rec.nth_information1
339: ,p_nth_information2_o
340: => ota_nhs_shd.g_old_rec.nth_information2
341: ,p_nth_information3_o
342: => ota_nhs_shd.g_old_rec.nth_information3
336: => ota_nhs_shd.g_old_rec.nth_information_category
337: ,p_nth_information1_o
338: => ota_nhs_shd.g_old_rec.nth_information1
339: ,p_nth_information2_o
340: => ota_nhs_shd.g_old_rec.nth_information2
341: ,p_nth_information3_o
342: => ota_nhs_shd.g_old_rec.nth_information3
343: ,p_nth_information4_o
344: => ota_nhs_shd.g_old_rec.nth_information4
338: => ota_nhs_shd.g_old_rec.nth_information1
339: ,p_nth_information2_o
340: => ota_nhs_shd.g_old_rec.nth_information2
341: ,p_nth_information3_o
342: => ota_nhs_shd.g_old_rec.nth_information3
343: ,p_nth_information4_o
344: => ota_nhs_shd.g_old_rec.nth_information4
345: ,p_nth_information5_o
346: => ota_nhs_shd.g_old_rec.nth_information5
340: => ota_nhs_shd.g_old_rec.nth_information2
341: ,p_nth_information3_o
342: => ota_nhs_shd.g_old_rec.nth_information3
343: ,p_nth_information4_o
344: => ota_nhs_shd.g_old_rec.nth_information4
345: ,p_nth_information5_o
346: => ota_nhs_shd.g_old_rec.nth_information5
347: ,p_nth_information6_o
348: => ota_nhs_shd.g_old_rec.nth_information6
342: => ota_nhs_shd.g_old_rec.nth_information3
343: ,p_nth_information4_o
344: => ota_nhs_shd.g_old_rec.nth_information4
345: ,p_nth_information5_o
346: => ota_nhs_shd.g_old_rec.nth_information5
347: ,p_nth_information6_o
348: => ota_nhs_shd.g_old_rec.nth_information6
349: ,p_nth_information7_o
350: => ota_nhs_shd.g_old_rec.nth_information7
344: => ota_nhs_shd.g_old_rec.nth_information4
345: ,p_nth_information5_o
346: => ota_nhs_shd.g_old_rec.nth_information5
347: ,p_nth_information6_o
348: => ota_nhs_shd.g_old_rec.nth_information6
349: ,p_nth_information7_o
350: => ota_nhs_shd.g_old_rec.nth_information7
351: ,p_nth_information8_o
352: => ota_nhs_shd.g_old_rec.nth_information8
346: => ota_nhs_shd.g_old_rec.nth_information5
347: ,p_nth_information6_o
348: => ota_nhs_shd.g_old_rec.nth_information6
349: ,p_nth_information7_o
350: => ota_nhs_shd.g_old_rec.nth_information7
351: ,p_nth_information8_o
352: => ota_nhs_shd.g_old_rec.nth_information8
353: ,p_nth_information9_o
354: => ota_nhs_shd.g_old_rec.nth_information9
348: => ota_nhs_shd.g_old_rec.nth_information6
349: ,p_nth_information7_o
350: => ota_nhs_shd.g_old_rec.nth_information7
351: ,p_nth_information8_o
352: => ota_nhs_shd.g_old_rec.nth_information8
353: ,p_nth_information9_o
354: => ota_nhs_shd.g_old_rec.nth_information9
355: ,p_nth_information10_o
356: => ota_nhs_shd.g_old_rec.nth_information10
350: => ota_nhs_shd.g_old_rec.nth_information7
351: ,p_nth_information8_o
352: => ota_nhs_shd.g_old_rec.nth_information8
353: ,p_nth_information9_o
354: => ota_nhs_shd.g_old_rec.nth_information9
355: ,p_nth_information10_o
356: => ota_nhs_shd.g_old_rec.nth_information10
357: ,p_nth_information11_o
358: => ota_nhs_shd.g_old_rec.nth_information11
352: => ota_nhs_shd.g_old_rec.nth_information8
353: ,p_nth_information9_o
354: => ota_nhs_shd.g_old_rec.nth_information9
355: ,p_nth_information10_o
356: => ota_nhs_shd.g_old_rec.nth_information10
357: ,p_nth_information11_o
358: => ota_nhs_shd.g_old_rec.nth_information11
359: ,p_nth_information12_o
360: => ota_nhs_shd.g_old_rec.nth_information12
354: => ota_nhs_shd.g_old_rec.nth_information9
355: ,p_nth_information10_o
356: => ota_nhs_shd.g_old_rec.nth_information10
357: ,p_nth_information11_o
358: => ota_nhs_shd.g_old_rec.nth_information11
359: ,p_nth_information12_o
360: => ota_nhs_shd.g_old_rec.nth_information12
361: ,p_nth_information13_o
362: => ota_nhs_shd.g_old_rec.nth_information13
356: => ota_nhs_shd.g_old_rec.nth_information10
357: ,p_nth_information11_o
358: => ota_nhs_shd.g_old_rec.nth_information11
359: ,p_nth_information12_o
360: => ota_nhs_shd.g_old_rec.nth_information12
361: ,p_nth_information13_o
362: => ota_nhs_shd.g_old_rec.nth_information13
363: ,p_nth_information15_o
364: => ota_nhs_shd.g_old_rec.nth_information15
358: => ota_nhs_shd.g_old_rec.nth_information11
359: ,p_nth_information12_o
360: => ota_nhs_shd.g_old_rec.nth_information12
361: ,p_nth_information13_o
362: => ota_nhs_shd.g_old_rec.nth_information13
363: ,p_nth_information15_o
364: => ota_nhs_shd.g_old_rec.nth_information15
365: ,p_nth_information16_o
366: => ota_nhs_shd.g_old_rec.nth_information16
360: => ota_nhs_shd.g_old_rec.nth_information12
361: ,p_nth_information13_o
362: => ota_nhs_shd.g_old_rec.nth_information13
363: ,p_nth_information15_o
364: => ota_nhs_shd.g_old_rec.nth_information15
365: ,p_nth_information16_o
366: => ota_nhs_shd.g_old_rec.nth_information16
367: ,p_nth_information17_o
368: => ota_nhs_shd.g_old_rec.nth_information17
362: => ota_nhs_shd.g_old_rec.nth_information13
363: ,p_nth_information15_o
364: => ota_nhs_shd.g_old_rec.nth_information15
365: ,p_nth_information16_o
366: => ota_nhs_shd.g_old_rec.nth_information16
367: ,p_nth_information17_o
368: => ota_nhs_shd.g_old_rec.nth_information17
369: ,p_nth_information18_o
370: => ota_nhs_shd.g_old_rec.nth_information18
364: => ota_nhs_shd.g_old_rec.nth_information15
365: ,p_nth_information16_o
366: => ota_nhs_shd.g_old_rec.nth_information16
367: ,p_nth_information17_o
368: => ota_nhs_shd.g_old_rec.nth_information17
369: ,p_nth_information18_o
370: => ota_nhs_shd.g_old_rec.nth_information18
371: ,p_nth_information19_o
372: => ota_nhs_shd.g_old_rec.nth_information19
366: => ota_nhs_shd.g_old_rec.nth_information16
367: ,p_nth_information17_o
368: => ota_nhs_shd.g_old_rec.nth_information17
369: ,p_nth_information18_o
370: => ota_nhs_shd.g_old_rec.nth_information18
371: ,p_nth_information19_o
372: => ota_nhs_shd.g_old_rec.nth_information19
373: ,p_nth_information20_o
374: => ota_nhs_shd.g_old_rec.nth_information20
368: => ota_nhs_shd.g_old_rec.nth_information17
369: ,p_nth_information18_o
370: => ota_nhs_shd.g_old_rec.nth_information18
371: ,p_nth_information19_o
372: => ota_nhs_shd.g_old_rec.nth_information19
373: ,p_nth_information20_o
374: => ota_nhs_shd.g_old_rec.nth_information20
375: ,p_org_id_o
376: => ota_nhs_shd.g_old_rec.org_id
370: => ota_nhs_shd.g_old_rec.nth_information18
371: ,p_nth_information19_o
372: => ota_nhs_shd.g_old_rec.nth_information19
373: ,p_nth_information20_o
374: => ota_nhs_shd.g_old_rec.nth_information20
375: ,p_org_id_o
376: => ota_nhs_shd.g_old_rec.org_id
377: ,p_object_version_number_o
378: => ota_nhs_shd.g_old_rec.object_version_number
372: => ota_nhs_shd.g_old_rec.nth_information19
373: ,p_nth_information20_o
374: => ota_nhs_shd.g_old_rec.nth_information20
375: ,p_org_id_o
376: => ota_nhs_shd.g_old_rec.org_id
377: ,p_object_version_number_o
378: => ota_nhs_shd.g_old_rec.object_version_number
379: ,p_business_group_id_o
380: => ota_nhs_shd.g_old_rec.business_group_id
374: => ota_nhs_shd.g_old_rec.nth_information20
375: ,p_org_id_o
376: => ota_nhs_shd.g_old_rec.org_id
377: ,p_object_version_number_o
378: => ota_nhs_shd.g_old_rec.object_version_number
379: ,p_business_group_id_o
380: => ota_nhs_shd.g_old_rec.business_group_id
381: ,p_nth_information14_o
382: => ota_nhs_shd.g_old_rec.nth_information14
376: => ota_nhs_shd.g_old_rec.org_id
377: ,p_object_version_number_o
378: => ota_nhs_shd.g_old_rec.object_version_number
379: ,p_business_group_id_o
380: => ota_nhs_shd.g_old_rec.business_group_id
381: ,p_nth_information14_o
382: => ota_nhs_shd.g_old_rec.nth_information14
383: ,p_customer_id_o
384: => ota_nhs_shd.g_old_rec.customer_id
378: => ota_nhs_shd.g_old_rec.object_version_number
379: ,p_business_group_id_o
380: => ota_nhs_shd.g_old_rec.business_group_id
381: ,p_nth_information14_o
382: => ota_nhs_shd.g_old_rec.nth_information14
383: ,p_customer_id_o
384: => ota_nhs_shd.g_old_rec.customer_id
385: ,p_organization_id_o
386: => ota_nhs_shd.g_old_rec.organization_id
380: => ota_nhs_shd.g_old_rec.business_group_id
381: ,p_nth_information14_o
382: => ota_nhs_shd.g_old_rec.nth_information14
383: ,p_customer_id_o
384: => ota_nhs_shd.g_old_rec.customer_id
385: ,p_organization_id_o
386: => ota_nhs_shd.g_old_rec.organization_id
387: );
388: --
382: => ota_nhs_shd.g_old_rec.nth_information14
383: ,p_customer_id_o
384: => ota_nhs_shd.g_old_rec.customer_id
385: ,p_organization_id_o
386: => ota_nhs_shd.g_old_rec.organization_id
387: );
388: --
389: exception
390: --
446: -- Internal Row Handler Use Only.
447: --
448: -- {End Of Comments}
449: -- ----------------------------------------------------------------------------
450: Procedure convert_defs(p_rec in out nocopy ota_nhs_shd.g_rec_type) is
451: --
452: l_proc varchar2(72) := g_package||'convert_defs';
453: --
454: Begin
461: -- is being used then we must set to the 'current' argument value.
462: --
463: If (p_rec.person_id = hr_api.g_number) then
464: p_rec.person_id :=
465: ota_nhs_shd.g_old_rec.person_id;
466: End If;
467: If (p_rec.contact_id = hr_api.g_number) then
468: p_rec.contact_id :=
469: ota_nhs_shd.g_old_rec.contact_id;
465: ota_nhs_shd.g_old_rec.person_id;
466: End If;
467: If (p_rec.contact_id = hr_api.g_number) then
468: p_rec.contact_id :=
469: ota_nhs_shd.g_old_rec.contact_id;
470: End If;
471: If (p_rec.trng_title = hr_api.g_varchar2) then
472: p_rec.trng_title :=
473: ota_nhs_shd.g_old_rec.trng_title;
469: ota_nhs_shd.g_old_rec.contact_id;
470: End If;
471: If (p_rec.trng_title = hr_api.g_varchar2) then
472: p_rec.trng_title :=
473: ota_nhs_shd.g_old_rec.trng_title;
474: End If;
475: If (p_rec.provider = hr_api.g_varchar2) then
476: p_rec.provider :=
477: ota_nhs_shd.g_old_rec.provider;
473: ota_nhs_shd.g_old_rec.trng_title;
474: End If;
475: If (p_rec.provider = hr_api.g_varchar2) then
476: p_rec.provider :=
477: ota_nhs_shd.g_old_rec.provider;
478: End If;
479: If (p_rec.type = hr_api.g_varchar2) then
480: p_rec.type :=
481: ota_nhs_shd.g_old_rec.type;
477: ota_nhs_shd.g_old_rec.provider;
478: End If;
479: If (p_rec.type = hr_api.g_varchar2) then
480: p_rec.type :=
481: ota_nhs_shd.g_old_rec.type;
482: End If;
483: If (p_rec.centre = hr_api.g_varchar2) then
484: p_rec.centre :=
485: ota_nhs_shd.g_old_rec.centre;
481: ota_nhs_shd.g_old_rec.type;
482: End If;
483: If (p_rec.centre = hr_api.g_varchar2) then
484: p_rec.centre :=
485: ota_nhs_shd.g_old_rec.centre;
486: End If;
487: If (p_rec.completion_date = hr_api.g_date) then
488: p_rec.completion_date :=
489: ota_nhs_shd.g_old_rec.completion_date;
485: ota_nhs_shd.g_old_rec.centre;
486: End If;
487: If (p_rec.completion_date = hr_api.g_date) then
488: p_rec.completion_date :=
489: ota_nhs_shd.g_old_rec.completion_date;
490: End If;
491: If (p_rec.award = hr_api.g_varchar2) then
492: p_rec.award :=
493: ota_nhs_shd.g_old_rec.award;
489: ota_nhs_shd.g_old_rec.completion_date;
490: End If;
491: If (p_rec.award = hr_api.g_varchar2) then
492: p_rec.award :=
493: ota_nhs_shd.g_old_rec.award;
494: End If;
495: If (p_rec.rating = hr_api.g_varchar2) then
496: p_rec.rating :=
497: ota_nhs_shd.g_old_rec.rating;
493: ota_nhs_shd.g_old_rec.award;
494: End If;
495: If (p_rec.rating = hr_api.g_varchar2) then
496: p_rec.rating :=
497: ota_nhs_shd.g_old_rec.rating;
498: End If;
499: If (p_rec.duration = hr_api.g_number) then
500: p_rec.duration :=
501: ota_nhs_shd.g_old_rec.duration;
497: ota_nhs_shd.g_old_rec.rating;
498: End If;
499: If (p_rec.duration = hr_api.g_number) then
500: p_rec.duration :=
501: ota_nhs_shd.g_old_rec.duration;
502: End If;
503: If (p_rec.duration_units = hr_api.g_varchar2) then
504: p_rec.duration_units :=
505: ota_nhs_shd.g_old_rec.duration_units;
501: ota_nhs_shd.g_old_rec.duration;
502: End If;
503: If (p_rec.duration_units = hr_api.g_varchar2) then
504: p_rec.duration_units :=
505: ota_nhs_shd.g_old_rec.duration_units;
506: End If;
507: If (p_rec.activity_version_id = hr_api.g_number) then
508: p_rec.activity_version_id :=
509: ota_nhs_shd.g_old_rec.activity_version_id;
505: ota_nhs_shd.g_old_rec.duration_units;
506: End If;
507: If (p_rec.activity_version_id = hr_api.g_number) then
508: p_rec.activity_version_id :=
509: ota_nhs_shd.g_old_rec.activity_version_id;
510: End If;
511: If (p_rec.status = hr_api.g_varchar2) then
512: p_rec.status :=
513: ota_nhs_shd.g_old_rec.status;
509: ota_nhs_shd.g_old_rec.activity_version_id;
510: End If;
511: If (p_rec.status = hr_api.g_varchar2) then
512: p_rec.status :=
513: ota_nhs_shd.g_old_rec.status;
514: End If;
515: If (p_rec.verified_by_id = hr_api.g_number) then
516: p_rec.verified_by_id :=
517: ota_nhs_shd.g_old_rec.verified_by_id;
513: ota_nhs_shd.g_old_rec.status;
514: End If;
515: If (p_rec.verified_by_id = hr_api.g_number) then
516: p_rec.verified_by_id :=
517: ota_nhs_shd.g_old_rec.verified_by_id;
518: End If;
519: If (p_rec.nth_information_category = hr_api.g_varchar2) then
520: p_rec.nth_information_category :=
521: ota_nhs_shd.g_old_rec.nth_information_category;
517: ota_nhs_shd.g_old_rec.verified_by_id;
518: End If;
519: If (p_rec.nth_information_category = hr_api.g_varchar2) then
520: p_rec.nth_information_category :=
521: ota_nhs_shd.g_old_rec.nth_information_category;
522: End If;
523: If (p_rec.nth_information1 = hr_api.g_varchar2) then
524: p_rec.nth_information1 :=
525: ota_nhs_shd.g_old_rec.nth_information1;
521: ota_nhs_shd.g_old_rec.nth_information_category;
522: End If;
523: If (p_rec.nth_information1 = hr_api.g_varchar2) then
524: p_rec.nth_information1 :=
525: ota_nhs_shd.g_old_rec.nth_information1;
526: End If;
527: If (p_rec.nth_information2 = hr_api.g_varchar2) then
528: p_rec.nth_information2 :=
529: ota_nhs_shd.g_old_rec.nth_information2;
525: ota_nhs_shd.g_old_rec.nth_information1;
526: End If;
527: If (p_rec.nth_information2 = hr_api.g_varchar2) then
528: p_rec.nth_information2 :=
529: ota_nhs_shd.g_old_rec.nth_information2;
530: End If;
531: If (p_rec.nth_information3 = hr_api.g_varchar2) then
532: p_rec.nth_information3 :=
533: ota_nhs_shd.g_old_rec.nth_information3;
529: ota_nhs_shd.g_old_rec.nth_information2;
530: End If;
531: If (p_rec.nth_information3 = hr_api.g_varchar2) then
532: p_rec.nth_information3 :=
533: ota_nhs_shd.g_old_rec.nth_information3;
534: End If;
535: If (p_rec.nth_information4 = hr_api.g_varchar2) then
536: p_rec.nth_information4 :=
537: ota_nhs_shd.g_old_rec.nth_information4;
533: ota_nhs_shd.g_old_rec.nth_information3;
534: End If;
535: If (p_rec.nth_information4 = hr_api.g_varchar2) then
536: p_rec.nth_information4 :=
537: ota_nhs_shd.g_old_rec.nth_information4;
538: End If;
539: If (p_rec.nth_information5 = hr_api.g_varchar2) then
540: p_rec.nth_information5 :=
541: ota_nhs_shd.g_old_rec.nth_information5;
537: ota_nhs_shd.g_old_rec.nth_information4;
538: End If;
539: If (p_rec.nth_information5 = hr_api.g_varchar2) then
540: p_rec.nth_information5 :=
541: ota_nhs_shd.g_old_rec.nth_information5;
542: End If;
543: If (p_rec.nth_information6 = hr_api.g_varchar2) then
544: p_rec.nth_information6 :=
545: ota_nhs_shd.g_old_rec.nth_information6;
541: ota_nhs_shd.g_old_rec.nth_information5;
542: End If;
543: If (p_rec.nth_information6 = hr_api.g_varchar2) then
544: p_rec.nth_information6 :=
545: ota_nhs_shd.g_old_rec.nth_information6;
546: End If;
547: If (p_rec.nth_information7 = hr_api.g_varchar2) then
548: p_rec.nth_information7 :=
549: ota_nhs_shd.g_old_rec.nth_information7;
545: ota_nhs_shd.g_old_rec.nth_information6;
546: End If;
547: If (p_rec.nth_information7 = hr_api.g_varchar2) then
548: p_rec.nth_information7 :=
549: ota_nhs_shd.g_old_rec.nth_information7;
550: End If;
551: If (p_rec.nth_information8 = hr_api.g_varchar2) then
552: p_rec.nth_information8 :=
553: ota_nhs_shd.g_old_rec.nth_information8;
549: ota_nhs_shd.g_old_rec.nth_information7;
550: End If;
551: If (p_rec.nth_information8 = hr_api.g_varchar2) then
552: p_rec.nth_information8 :=
553: ota_nhs_shd.g_old_rec.nth_information8;
554: End If;
555: If (p_rec.nth_information9 = hr_api.g_varchar2) then
556: p_rec.nth_information9 :=
557: ota_nhs_shd.g_old_rec.nth_information9;
553: ota_nhs_shd.g_old_rec.nth_information8;
554: End If;
555: If (p_rec.nth_information9 = hr_api.g_varchar2) then
556: p_rec.nth_information9 :=
557: ota_nhs_shd.g_old_rec.nth_information9;
558: End If;
559: If (p_rec.nth_information10 = hr_api.g_varchar2) then
560: p_rec.nth_information10 :=
561: ota_nhs_shd.g_old_rec.nth_information10;
557: ota_nhs_shd.g_old_rec.nth_information9;
558: End If;
559: If (p_rec.nth_information10 = hr_api.g_varchar2) then
560: p_rec.nth_information10 :=
561: ota_nhs_shd.g_old_rec.nth_information10;
562: End If;
563: If (p_rec.nth_information11 = hr_api.g_varchar2) then
564: p_rec.nth_information11 :=
565: ota_nhs_shd.g_old_rec.nth_information11;
561: ota_nhs_shd.g_old_rec.nth_information10;
562: End If;
563: If (p_rec.nth_information11 = hr_api.g_varchar2) then
564: p_rec.nth_information11 :=
565: ota_nhs_shd.g_old_rec.nth_information11;
566: End If;
567: If (p_rec.nth_information12 = hr_api.g_varchar2) then
568: p_rec.nth_information12 :=
569: ota_nhs_shd.g_old_rec.nth_information12;
565: ota_nhs_shd.g_old_rec.nth_information11;
566: End If;
567: If (p_rec.nth_information12 = hr_api.g_varchar2) then
568: p_rec.nth_information12 :=
569: ota_nhs_shd.g_old_rec.nth_information12;
570: End If;
571: If (p_rec.nth_information13 = hr_api.g_varchar2) then
572: p_rec.nth_information13 :=
573: ota_nhs_shd.g_old_rec.nth_information13;
569: ota_nhs_shd.g_old_rec.nth_information12;
570: End If;
571: If (p_rec.nth_information13 = hr_api.g_varchar2) then
572: p_rec.nth_information13 :=
573: ota_nhs_shd.g_old_rec.nth_information13;
574: End If;
575: If (p_rec.nth_information15 = hr_api.g_varchar2) then
576: p_rec.nth_information15 :=
577: ota_nhs_shd.g_old_rec.nth_information15;
573: ota_nhs_shd.g_old_rec.nth_information13;
574: End If;
575: If (p_rec.nth_information15 = hr_api.g_varchar2) then
576: p_rec.nth_information15 :=
577: ota_nhs_shd.g_old_rec.nth_information15;
578: End If;
579: If (p_rec.nth_information16 = hr_api.g_varchar2) then
580: p_rec.nth_information16 :=
581: ota_nhs_shd.g_old_rec.nth_information16;
577: ota_nhs_shd.g_old_rec.nth_information15;
578: End If;
579: If (p_rec.nth_information16 = hr_api.g_varchar2) then
580: p_rec.nth_information16 :=
581: ota_nhs_shd.g_old_rec.nth_information16;
582: End If;
583: If (p_rec.nth_information17 = hr_api.g_varchar2) then
584: p_rec.nth_information17 :=
585: ota_nhs_shd.g_old_rec.nth_information17;
581: ota_nhs_shd.g_old_rec.nth_information16;
582: End If;
583: If (p_rec.nth_information17 = hr_api.g_varchar2) then
584: p_rec.nth_information17 :=
585: ota_nhs_shd.g_old_rec.nth_information17;
586: End If;
587: If (p_rec.nth_information18 = hr_api.g_varchar2) then
588: p_rec.nth_information18 :=
589: ota_nhs_shd.g_old_rec.nth_information18;
585: ota_nhs_shd.g_old_rec.nth_information17;
586: End If;
587: If (p_rec.nth_information18 = hr_api.g_varchar2) then
588: p_rec.nth_information18 :=
589: ota_nhs_shd.g_old_rec.nth_information18;
590: End If;
591: If (p_rec.nth_information19 = hr_api.g_varchar2) then
592: p_rec.nth_information19 :=
593: ota_nhs_shd.g_old_rec.nth_information19;
589: ota_nhs_shd.g_old_rec.nth_information18;
590: End If;
591: If (p_rec.nth_information19 = hr_api.g_varchar2) then
592: p_rec.nth_information19 :=
593: ota_nhs_shd.g_old_rec.nth_information19;
594: End If;
595: If (p_rec.nth_information20 = hr_api.g_varchar2) then
596: p_rec.nth_information20 :=
597: ota_nhs_shd.g_old_rec.nth_information20;
593: ota_nhs_shd.g_old_rec.nth_information19;
594: End If;
595: If (p_rec.nth_information20 = hr_api.g_varchar2) then
596: p_rec.nth_information20 :=
597: ota_nhs_shd.g_old_rec.nth_information20;
598: End If;
599: If (p_rec.org_id = hr_api.g_number) then
600: p_rec.org_id :=
601: ota_nhs_shd.g_old_rec.org_id;
597: ota_nhs_shd.g_old_rec.nth_information20;
598: End If;
599: If (p_rec.org_id = hr_api.g_number) then
600: p_rec.org_id :=
601: ota_nhs_shd.g_old_rec.org_id;
602: End If;
603: If (p_rec.business_group_id = hr_api.g_number) then
604: p_rec.business_group_id :=
605: ota_nhs_shd.g_old_rec.business_group_id;
601: ota_nhs_shd.g_old_rec.org_id;
602: End If;
603: If (p_rec.business_group_id = hr_api.g_number) then
604: p_rec.business_group_id :=
605: ota_nhs_shd.g_old_rec.business_group_id;
606: End If;
607: If (p_rec.nth_information14 = hr_api.g_varchar2) then
608: p_rec.nth_information14 :=
609: ota_nhs_shd.g_old_rec.nth_information14;
605: ota_nhs_shd.g_old_rec.business_group_id;
606: End If;
607: If (p_rec.nth_information14 = hr_api.g_varchar2) then
608: p_rec.nth_information14 :=
609: ota_nhs_shd.g_old_rec.nth_information14;
610: End If;
611: If (p_rec.customer_id = hr_api.g_number) then
612: p_rec.customer_id :=
613: ota_nhs_shd.g_old_rec.customer_id;
609: ota_nhs_shd.g_old_rec.nth_information14;
610: End If;
611: If (p_rec.customer_id = hr_api.g_number) then
612: p_rec.customer_id :=
613: ota_nhs_shd.g_old_rec.customer_id;
614: End If;
615: If (p_rec.organization_id = hr_api.g_number) then
616: p_rec.organization_id :=
617: ota_nhs_shd.g_old_rec.organization_id;
613: ota_nhs_shd.g_old_rec.customer_id;
614: End If;
615: If (p_rec.organization_id = hr_api.g_number) then
616: p_rec.organization_id :=
617: ota_nhs_shd.g_old_rec.organization_id;
618: End If;
619: --
620: hr_utility.set_location(' Leaving:'||l_proc, 10);
621: --
625: -- |---------------------------------< upd >----------------------------------|
626: -- ----------------------------------------------------------------------------
627: Procedure upd
628: (p_effective_date in date ,
629: p_rec in out nocopy ota_nhs_shd.g_rec_type
630: ) is
631: --
632: l_proc varchar2(72) := g_package||'upd';
633: --
635: hr_utility.set_location('Entering:'||l_proc, 5);
636: --
637: -- We must lock the row which we need to update.
638: --
639: ota_nhs_shd.lck
640: (
641: p_rec.nota_history_id,
642: p_rec.object_version_number
643: );
716: p_customer_id in number default hr_api.g_number,
717: p_organization_id in number default hr_api.g_number
718: ) is
719: --
720: l_rec ota_nhs_shd.g_rec_type;
721: l_proc varchar2(72) := g_package||'upd';
722: --
723: Begin
724: hr_utility.set_location('Entering:'||l_proc, 5);
727: -- Call conversion function to turn arguments into the
728: -- l_rec structure.
729: --
730: l_rec :=
731: ota_nhs_shd.convert_args
732: (
733: p_nota_history_id,
734: p_person_id,
735: p_contact_id,