[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ota_aci_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: ota_aci_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the ota_act_cat_inclusions Row
69: --
70: update ota_act_cat_inclusions
101: ,category_usage_id = p_rec.category_usage_id
102: where activity_version_id = p_rec.activity_version_id
103: and category_usage_id = p_rec.category_usage_id;
104: --
105: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: --
109: Exception
108: --
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
113: ota_aci_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
113: ota_aci_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
113: ota_aci_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
118: ota_aci_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
118: ota_aci_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
118: ota_aci_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
123: ota_aci_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
123: ota_aci_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
127: Raise;
122: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
123: ota_aci_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
127: Raise;
128: End update_dml;
129: --
130: -- ----------------------------------------------------------------------------
159: --
160: -- {End Of Comments}
161: -- ----------------------------------------------------------------------------
162: Procedure pre_update
163: (p_rec in ota_aci_shd.g_rec_type
164: ) is
165: --
166: l_proc varchar2(72) := g_package||'pre_update';
167: --
204: -- {End Of Comments}
205: -- ----------------------------------------------------------------------------
206: Procedure post_update
207: (p_effective_date in date
208: ,p_rec in ota_aci_shd.g_rec_type
209: ) is
210: --
211: l_proc varchar2(72) := g_package||'post_update';
212: --
276: => p_rec.primary_flag
277: ,p_category_usage_id
278: => p_rec.category_usage_id
279: ,p_activity_category_o
280: => ota_aci_shd.g_old_rec.activity_category
281: ,p_object_version_number_o
282: => ota_aci_shd.g_old_rec.object_version_number
283: ,p_event_id_o
284: => ota_aci_shd.g_old_rec.event_id
278: => p_rec.category_usage_id
279: ,p_activity_category_o
280: => ota_aci_shd.g_old_rec.activity_category
281: ,p_object_version_number_o
282: => ota_aci_shd.g_old_rec.object_version_number
283: ,p_event_id_o
284: => ota_aci_shd.g_old_rec.event_id
285: ,p_comments_o
286: => ota_aci_shd.g_old_rec.comments
280: => ota_aci_shd.g_old_rec.activity_category
281: ,p_object_version_number_o
282: => ota_aci_shd.g_old_rec.object_version_number
283: ,p_event_id_o
284: => ota_aci_shd.g_old_rec.event_id
285: ,p_comments_o
286: => ota_aci_shd.g_old_rec.comments
287: ,p_aci_information_category_o
288: => ota_aci_shd.g_old_rec.aci_information_category
282: => ota_aci_shd.g_old_rec.object_version_number
283: ,p_event_id_o
284: => ota_aci_shd.g_old_rec.event_id
285: ,p_comments_o
286: => ota_aci_shd.g_old_rec.comments
287: ,p_aci_information_category_o
288: => ota_aci_shd.g_old_rec.aci_information_category
289: ,p_aci_information1_o
290: => ota_aci_shd.g_old_rec.aci_information1
284: => ota_aci_shd.g_old_rec.event_id
285: ,p_comments_o
286: => ota_aci_shd.g_old_rec.comments
287: ,p_aci_information_category_o
288: => ota_aci_shd.g_old_rec.aci_information_category
289: ,p_aci_information1_o
290: => ota_aci_shd.g_old_rec.aci_information1
291: ,p_aci_information2_o
292: => ota_aci_shd.g_old_rec.aci_information2
286: => ota_aci_shd.g_old_rec.comments
287: ,p_aci_information_category_o
288: => ota_aci_shd.g_old_rec.aci_information_category
289: ,p_aci_information1_o
290: => ota_aci_shd.g_old_rec.aci_information1
291: ,p_aci_information2_o
292: => ota_aci_shd.g_old_rec.aci_information2
293: ,p_aci_information3_o
294: => ota_aci_shd.g_old_rec.aci_information3
288: => ota_aci_shd.g_old_rec.aci_information_category
289: ,p_aci_information1_o
290: => ota_aci_shd.g_old_rec.aci_information1
291: ,p_aci_information2_o
292: => ota_aci_shd.g_old_rec.aci_information2
293: ,p_aci_information3_o
294: => ota_aci_shd.g_old_rec.aci_information3
295: ,p_aci_information4_o
296: => ota_aci_shd.g_old_rec.aci_information4
290: => ota_aci_shd.g_old_rec.aci_information1
291: ,p_aci_information2_o
292: => ota_aci_shd.g_old_rec.aci_information2
293: ,p_aci_information3_o
294: => ota_aci_shd.g_old_rec.aci_information3
295: ,p_aci_information4_o
296: => ota_aci_shd.g_old_rec.aci_information4
297: ,p_aci_information5_o
298: => ota_aci_shd.g_old_rec.aci_information5
292: => ota_aci_shd.g_old_rec.aci_information2
293: ,p_aci_information3_o
294: => ota_aci_shd.g_old_rec.aci_information3
295: ,p_aci_information4_o
296: => ota_aci_shd.g_old_rec.aci_information4
297: ,p_aci_information5_o
298: => ota_aci_shd.g_old_rec.aci_information5
299: ,p_aci_information6_o
300: => ota_aci_shd.g_old_rec.aci_information6
294: => ota_aci_shd.g_old_rec.aci_information3
295: ,p_aci_information4_o
296: => ota_aci_shd.g_old_rec.aci_information4
297: ,p_aci_information5_o
298: => ota_aci_shd.g_old_rec.aci_information5
299: ,p_aci_information6_o
300: => ota_aci_shd.g_old_rec.aci_information6
301: ,p_aci_information7_o
302: => ota_aci_shd.g_old_rec.aci_information7
296: => ota_aci_shd.g_old_rec.aci_information4
297: ,p_aci_information5_o
298: => ota_aci_shd.g_old_rec.aci_information5
299: ,p_aci_information6_o
300: => ota_aci_shd.g_old_rec.aci_information6
301: ,p_aci_information7_o
302: => ota_aci_shd.g_old_rec.aci_information7
303: ,p_aci_information8_o
304: => ota_aci_shd.g_old_rec.aci_information8
298: => ota_aci_shd.g_old_rec.aci_information5
299: ,p_aci_information6_o
300: => ota_aci_shd.g_old_rec.aci_information6
301: ,p_aci_information7_o
302: => ota_aci_shd.g_old_rec.aci_information7
303: ,p_aci_information8_o
304: => ota_aci_shd.g_old_rec.aci_information8
305: ,p_aci_information9_o
306: => ota_aci_shd.g_old_rec.aci_information9
300: => ota_aci_shd.g_old_rec.aci_information6
301: ,p_aci_information7_o
302: => ota_aci_shd.g_old_rec.aci_information7
303: ,p_aci_information8_o
304: => ota_aci_shd.g_old_rec.aci_information8
305: ,p_aci_information9_o
306: => ota_aci_shd.g_old_rec.aci_information9
307: ,p_aci_information10_o
308: => ota_aci_shd.g_old_rec.aci_information10
302: => ota_aci_shd.g_old_rec.aci_information7
303: ,p_aci_information8_o
304: => ota_aci_shd.g_old_rec.aci_information8
305: ,p_aci_information9_o
306: => ota_aci_shd.g_old_rec.aci_information9
307: ,p_aci_information10_o
308: => ota_aci_shd.g_old_rec.aci_information10
309: ,p_aci_information11_o
310: => ota_aci_shd.g_old_rec.aci_information11
304: => ota_aci_shd.g_old_rec.aci_information8
305: ,p_aci_information9_o
306: => ota_aci_shd.g_old_rec.aci_information9
307: ,p_aci_information10_o
308: => ota_aci_shd.g_old_rec.aci_information10
309: ,p_aci_information11_o
310: => ota_aci_shd.g_old_rec.aci_information11
311: ,p_aci_information12_o
312: => ota_aci_shd.g_old_rec.aci_information12
306: => ota_aci_shd.g_old_rec.aci_information9
307: ,p_aci_information10_o
308: => ota_aci_shd.g_old_rec.aci_information10
309: ,p_aci_information11_o
310: => ota_aci_shd.g_old_rec.aci_information11
311: ,p_aci_information12_o
312: => ota_aci_shd.g_old_rec.aci_information12
313: ,p_aci_information13_o
314: => ota_aci_shd.g_old_rec.aci_information13
308: => ota_aci_shd.g_old_rec.aci_information10
309: ,p_aci_information11_o
310: => ota_aci_shd.g_old_rec.aci_information11
311: ,p_aci_information12_o
312: => ota_aci_shd.g_old_rec.aci_information12
313: ,p_aci_information13_o
314: => ota_aci_shd.g_old_rec.aci_information13
315: ,p_aci_information14_o
316: => ota_aci_shd.g_old_rec.aci_information14
310: => ota_aci_shd.g_old_rec.aci_information11
311: ,p_aci_information12_o
312: => ota_aci_shd.g_old_rec.aci_information12
313: ,p_aci_information13_o
314: => ota_aci_shd.g_old_rec.aci_information13
315: ,p_aci_information14_o
316: => ota_aci_shd.g_old_rec.aci_information14
317: ,p_aci_information15_o
318: => ota_aci_shd.g_old_rec.aci_information15
312: => ota_aci_shd.g_old_rec.aci_information12
313: ,p_aci_information13_o
314: => ota_aci_shd.g_old_rec.aci_information13
315: ,p_aci_information14_o
316: => ota_aci_shd.g_old_rec.aci_information14
317: ,p_aci_information15_o
318: => ota_aci_shd.g_old_rec.aci_information15
319: ,p_aci_information16_o
320: => ota_aci_shd.g_old_rec.aci_information16
314: => ota_aci_shd.g_old_rec.aci_information13
315: ,p_aci_information14_o
316: => ota_aci_shd.g_old_rec.aci_information14
317: ,p_aci_information15_o
318: => ota_aci_shd.g_old_rec.aci_information15
319: ,p_aci_information16_o
320: => ota_aci_shd.g_old_rec.aci_information16
321: ,p_aci_information17_o
322: => ota_aci_shd.g_old_rec.aci_information17
316: => ota_aci_shd.g_old_rec.aci_information14
317: ,p_aci_information15_o
318: => ota_aci_shd.g_old_rec.aci_information15
319: ,p_aci_information16_o
320: => ota_aci_shd.g_old_rec.aci_information16
321: ,p_aci_information17_o
322: => ota_aci_shd.g_old_rec.aci_information17
323: ,p_aci_information18_o
324: => ota_aci_shd.g_old_rec.aci_information18
318: => ota_aci_shd.g_old_rec.aci_information15
319: ,p_aci_information16_o
320: => ota_aci_shd.g_old_rec.aci_information16
321: ,p_aci_information17_o
322: => ota_aci_shd.g_old_rec.aci_information17
323: ,p_aci_information18_o
324: => ota_aci_shd.g_old_rec.aci_information18
325: ,p_aci_information19_o
326: => ota_aci_shd.g_old_rec.aci_information19
320: => ota_aci_shd.g_old_rec.aci_information16
321: ,p_aci_information17_o
322: => ota_aci_shd.g_old_rec.aci_information17
323: ,p_aci_information18_o
324: => ota_aci_shd.g_old_rec.aci_information18
325: ,p_aci_information19_o
326: => ota_aci_shd.g_old_rec.aci_information19
327: ,p_aci_information20_o
328: => ota_aci_shd.g_old_rec.aci_information20
322: => ota_aci_shd.g_old_rec.aci_information17
323: ,p_aci_information18_o
324: => ota_aci_shd.g_old_rec.aci_information18
325: ,p_aci_information19_o
326: => ota_aci_shd.g_old_rec.aci_information19
327: ,p_aci_information20_o
328: => ota_aci_shd.g_old_rec.aci_information20
329: ,p_start_date_active_o
330: => ota_aci_shd.g_old_rec.start_date_active
324: => ota_aci_shd.g_old_rec.aci_information18
325: ,p_aci_information19_o
326: => ota_aci_shd.g_old_rec.aci_information19
327: ,p_aci_information20_o
328: => ota_aci_shd.g_old_rec.aci_information20
329: ,p_start_date_active_o
330: => ota_aci_shd.g_old_rec.start_date_active
331: ,p_end_date_active_o
332: => ota_aci_shd.g_old_rec.end_date_active
326: => ota_aci_shd.g_old_rec.aci_information19
327: ,p_aci_information20_o
328: => ota_aci_shd.g_old_rec.aci_information20
329: ,p_start_date_active_o
330: => ota_aci_shd.g_old_rec.start_date_active
331: ,p_end_date_active_o
332: => ota_aci_shd.g_old_rec.end_date_active
333: ,p_primary_flag_o
334: => ota_aci_shd.g_old_rec.primary_flag
328: => ota_aci_shd.g_old_rec.aci_information20
329: ,p_start_date_active_o
330: => ota_aci_shd.g_old_rec.start_date_active
331: ,p_end_date_active_o
332: => ota_aci_shd.g_old_rec.end_date_active
333: ,p_primary_flag_o
334: => ota_aci_shd.g_old_rec.primary_flag
335: );
336: --
330: => ota_aci_shd.g_old_rec.start_date_active
331: ,p_end_date_active_o
332: => ota_aci_shd.g_old_rec.end_date_active
333: ,p_primary_flag_o
334: => ota_aci_shd.g_old_rec.primary_flag
335: );
336: --
337: exception
338: --
390: --
391: -- {End Of Comments}
392: -- ----------------------------------------------------------------------------
393: Procedure convert_defs
394: (p_rec in out nocopy ota_aci_shd.g_rec_type
395: ) is
396: --
397: Begin
398: --
402: -- is being used then we must set to the 'current' argument value.
403: --
404: If (p_rec.activity_category = hr_api.g_varchar2) then
405: p_rec.activity_category :=
406: ota_aci_shd.g_old_rec.activity_category;
407: End If;
408: If (p_rec.event_id = hr_api.g_number) then
409: p_rec.event_id :=
410: ota_aci_shd.g_old_rec.event_id;
406: ota_aci_shd.g_old_rec.activity_category;
407: End If;
408: If (p_rec.event_id = hr_api.g_number) then
409: p_rec.event_id :=
410: ota_aci_shd.g_old_rec.event_id;
411: End If;
412: If (p_rec.comments = hr_api.g_varchar2) then
413: p_rec.comments :=
414: ota_aci_shd.g_old_rec.comments;
410: ota_aci_shd.g_old_rec.event_id;
411: End If;
412: If (p_rec.comments = hr_api.g_varchar2) then
413: p_rec.comments :=
414: ota_aci_shd.g_old_rec.comments;
415: End If;
416: If (p_rec.aci_information_category = hr_api.g_varchar2) then
417: p_rec.aci_information_category :=
418: ota_aci_shd.g_old_rec.aci_information_category;
414: ota_aci_shd.g_old_rec.comments;
415: End If;
416: If (p_rec.aci_information_category = hr_api.g_varchar2) then
417: p_rec.aci_information_category :=
418: ota_aci_shd.g_old_rec.aci_information_category;
419: End If;
420: If (p_rec.aci_information1 = hr_api.g_varchar2) then
421: p_rec.aci_information1 :=
422: ota_aci_shd.g_old_rec.aci_information1;
418: ota_aci_shd.g_old_rec.aci_information_category;
419: End If;
420: If (p_rec.aci_information1 = hr_api.g_varchar2) then
421: p_rec.aci_information1 :=
422: ota_aci_shd.g_old_rec.aci_information1;
423: End If;
424: If (p_rec.aci_information2 = hr_api.g_varchar2) then
425: p_rec.aci_information2 :=
426: ota_aci_shd.g_old_rec.aci_information2;
422: ota_aci_shd.g_old_rec.aci_information1;
423: End If;
424: If (p_rec.aci_information2 = hr_api.g_varchar2) then
425: p_rec.aci_information2 :=
426: ota_aci_shd.g_old_rec.aci_information2;
427: End If;
428: If (p_rec.aci_information3 = hr_api.g_varchar2) then
429: p_rec.aci_information3 :=
430: ota_aci_shd.g_old_rec.aci_information3;
426: ota_aci_shd.g_old_rec.aci_information2;
427: End If;
428: If (p_rec.aci_information3 = hr_api.g_varchar2) then
429: p_rec.aci_information3 :=
430: ota_aci_shd.g_old_rec.aci_information3;
431: End If;
432: If (p_rec.aci_information4 = hr_api.g_varchar2) then
433: p_rec.aci_information4 :=
434: ota_aci_shd.g_old_rec.aci_information4;
430: ota_aci_shd.g_old_rec.aci_information3;
431: End If;
432: If (p_rec.aci_information4 = hr_api.g_varchar2) then
433: p_rec.aci_information4 :=
434: ota_aci_shd.g_old_rec.aci_information4;
435: End If;
436: If (p_rec.aci_information5 = hr_api.g_varchar2) then
437: p_rec.aci_information5 :=
438: ota_aci_shd.g_old_rec.aci_information5;
434: ota_aci_shd.g_old_rec.aci_information4;
435: End If;
436: If (p_rec.aci_information5 = hr_api.g_varchar2) then
437: p_rec.aci_information5 :=
438: ota_aci_shd.g_old_rec.aci_information5;
439: End If;
440: If (p_rec.aci_information6 = hr_api.g_varchar2) then
441: p_rec.aci_information6 :=
442: ota_aci_shd.g_old_rec.aci_information6;
438: ota_aci_shd.g_old_rec.aci_information5;
439: End If;
440: If (p_rec.aci_information6 = hr_api.g_varchar2) then
441: p_rec.aci_information6 :=
442: ota_aci_shd.g_old_rec.aci_information6;
443: End If;
444: If (p_rec.aci_information7 = hr_api.g_varchar2) then
445: p_rec.aci_information7 :=
446: ota_aci_shd.g_old_rec.aci_information7;
442: ota_aci_shd.g_old_rec.aci_information6;
443: End If;
444: If (p_rec.aci_information7 = hr_api.g_varchar2) then
445: p_rec.aci_information7 :=
446: ota_aci_shd.g_old_rec.aci_information7;
447: End If;
448: If (p_rec.aci_information8 = hr_api.g_varchar2) then
449: p_rec.aci_information8 :=
450: ota_aci_shd.g_old_rec.aci_information8;
446: ota_aci_shd.g_old_rec.aci_information7;
447: End If;
448: If (p_rec.aci_information8 = hr_api.g_varchar2) then
449: p_rec.aci_information8 :=
450: ota_aci_shd.g_old_rec.aci_information8;
451: End If;
452: If (p_rec.aci_information9 = hr_api.g_varchar2) then
453: p_rec.aci_information9 :=
454: ota_aci_shd.g_old_rec.aci_information9;
450: ota_aci_shd.g_old_rec.aci_information8;
451: End If;
452: If (p_rec.aci_information9 = hr_api.g_varchar2) then
453: p_rec.aci_information9 :=
454: ota_aci_shd.g_old_rec.aci_information9;
455: End If;
456: If (p_rec.aci_information10 = hr_api.g_varchar2) then
457: p_rec.aci_information10 :=
458: ota_aci_shd.g_old_rec.aci_information10;
454: ota_aci_shd.g_old_rec.aci_information9;
455: End If;
456: If (p_rec.aci_information10 = hr_api.g_varchar2) then
457: p_rec.aci_information10 :=
458: ota_aci_shd.g_old_rec.aci_information10;
459: End If;
460: If (p_rec.aci_information11 = hr_api.g_varchar2) then
461: p_rec.aci_information11 :=
462: ota_aci_shd.g_old_rec.aci_information11;
458: ota_aci_shd.g_old_rec.aci_information10;
459: End If;
460: If (p_rec.aci_information11 = hr_api.g_varchar2) then
461: p_rec.aci_information11 :=
462: ota_aci_shd.g_old_rec.aci_information11;
463: End If;
464: If (p_rec.aci_information12 = hr_api.g_varchar2) then
465: p_rec.aci_information12 :=
466: ota_aci_shd.g_old_rec.aci_information12;
462: ota_aci_shd.g_old_rec.aci_information11;
463: End If;
464: If (p_rec.aci_information12 = hr_api.g_varchar2) then
465: p_rec.aci_information12 :=
466: ota_aci_shd.g_old_rec.aci_information12;
467: End If;
468: If (p_rec.aci_information13 = hr_api.g_varchar2) then
469: p_rec.aci_information13 :=
470: ota_aci_shd.g_old_rec.aci_information13;
466: ota_aci_shd.g_old_rec.aci_information12;
467: End If;
468: If (p_rec.aci_information13 = hr_api.g_varchar2) then
469: p_rec.aci_information13 :=
470: ota_aci_shd.g_old_rec.aci_information13;
471: End If;
472: If (p_rec.aci_information14 = hr_api.g_varchar2) then
473: p_rec.aci_information14 :=
474: ota_aci_shd.g_old_rec.aci_information14;
470: ota_aci_shd.g_old_rec.aci_information13;
471: End If;
472: If (p_rec.aci_information14 = hr_api.g_varchar2) then
473: p_rec.aci_information14 :=
474: ota_aci_shd.g_old_rec.aci_information14;
475: End If;
476: If (p_rec.aci_information15 = hr_api.g_varchar2) then
477: p_rec.aci_information15 :=
478: ota_aci_shd.g_old_rec.aci_information15;
474: ota_aci_shd.g_old_rec.aci_information14;
475: End If;
476: If (p_rec.aci_information15 = hr_api.g_varchar2) then
477: p_rec.aci_information15 :=
478: ota_aci_shd.g_old_rec.aci_information15;
479: End If;
480: If (p_rec.aci_information16 = hr_api.g_varchar2) then
481: p_rec.aci_information16 :=
482: ota_aci_shd.g_old_rec.aci_information16;
478: ota_aci_shd.g_old_rec.aci_information15;
479: End If;
480: If (p_rec.aci_information16 = hr_api.g_varchar2) then
481: p_rec.aci_information16 :=
482: ota_aci_shd.g_old_rec.aci_information16;
483: End If;
484: If (p_rec.aci_information17 = hr_api.g_varchar2) then
485: p_rec.aci_information17 :=
486: ota_aci_shd.g_old_rec.aci_information17;
482: ota_aci_shd.g_old_rec.aci_information16;
483: End If;
484: If (p_rec.aci_information17 = hr_api.g_varchar2) then
485: p_rec.aci_information17 :=
486: ota_aci_shd.g_old_rec.aci_information17;
487: End If;
488: If (p_rec.aci_information18 = hr_api.g_varchar2) then
489: p_rec.aci_information18 :=
490: ota_aci_shd.g_old_rec.aci_information18;
486: ota_aci_shd.g_old_rec.aci_information17;
487: End If;
488: If (p_rec.aci_information18 = hr_api.g_varchar2) then
489: p_rec.aci_information18 :=
490: ota_aci_shd.g_old_rec.aci_information18;
491: End If;
492: If (p_rec.aci_information19 = hr_api.g_varchar2) then
493: p_rec.aci_information19 :=
494: ota_aci_shd.g_old_rec.aci_information19;
490: ota_aci_shd.g_old_rec.aci_information18;
491: End If;
492: If (p_rec.aci_information19 = hr_api.g_varchar2) then
493: p_rec.aci_information19 :=
494: ota_aci_shd.g_old_rec.aci_information19;
495: End If;
496: If (p_rec.aci_information20 = hr_api.g_varchar2) then
497: p_rec.aci_information20 :=
498: ota_aci_shd.g_old_rec.aci_information20;
494: ota_aci_shd.g_old_rec.aci_information19;
495: End If;
496: If (p_rec.aci_information20 = hr_api.g_varchar2) then
497: p_rec.aci_information20 :=
498: ota_aci_shd.g_old_rec.aci_information20;
499: End If;
500: If (p_rec.start_date_active = hr_api.g_date) then
501: p_rec.start_date_active :=
502: ota_aci_shd.g_old_rec.start_date_active;
498: ota_aci_shd.g_old_rec.aci_information20;
499: End If;
500: If (p_rec.start_date_active = hr_api.g_date) then
501: p_rec.start_date_active :=
502: ota_aci_shd.g_old_rec.start_date_active;
503: End If;
504: If (p_rec.end_date_active = hr_api.g_date) then
505: p_rec.end_date_active :=
506: ota_aci_shd.g_old_rec.end_date_active;
502: ota_aci_shd.g_old_rec.start_date_active;
503: End If;
504: If (p_rec.end_date_active = hr_api.g_date) then
505: p_rec.end_date_active :=
506: ota_aci_shd.g_old_rec.end_date_active;
507: End If;
508: If (p_rec.primary_flag = hr_api.g_varchar2) then
509: p_rec.primary_flag :=
510: ota_aci_shd.g_old_rec.primary_flag;
506: ota_aci_shd.g_old_rec.end_date_active;
507: End If;
508: If (p_rec.primary_flag = hr_api.g_varchar2) then
509: p_rec.primary_flag :=
510: ota_aci_shd.g_old_rec.primary_flag;
511: End If;
512: --
513: End convert_defs;
514: --
516: -- |---------------------------------< upd >----------------------------------|
517: -- ----------------------------------------------------------------------------
518: Procedure upd
519: (p_effective_date in date
520: ,p_rec in out nocopy ota_aci_shd.g_rec_type
521: ) is
522: --
523: l_proc varchar2(72) := g_package||'upd';
524: --
526: hr_utility.set_location('Entering:'||l_proc, 5);
527: --
528: -- We must lock the row which we need to update.
529: --
530: ota_aci_shd.lck
531: (p_rec.activity_version_id
532: ,p_rec.category_usage_id
533: ,p_rec.object_version_number
534: );
603: ,p_end_date_active in date default hr_api.g_date
604: ,p_primary_flag in varchar2 default hr_api.g_varchar2
605: ) is
606: --
607: l_rec ota_aci_shd.g_rec_type;
608: l_proc varchar2(72) := g_package||'upd';
609: --
610: Begin
611: hr_utility.set_location('Entering:'||l_proc, 5);
613: -- Call conversion function to turn arguments into the
614: -- l_rec structure.
615: --
616: l_rec :=
617: ota_aci_shd.convert_args
618: (p_activity_version_id
619: ,p_activity_category
620: ,p_object_version_number
621: ,p_event_id