50: -- Internal Row Handler Use Only.
51: --
52: -- ----------------------------------------------------------------------------
53: Procedure update_dml
54: (p_rec in out nocopy hxc_egc_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72);
58: --
64: --
65: -- Increment the object version
66: p_rec.object_version_number := p_rec.object_version_number + 1;
67: --
68: hxc_egc_shd.g_api_dml := true; -- Set the api dml status
69: --
70: -- Update the hxc_entity_group_comps Row
71: --
72: if g_debug then
115: ,last_update_login = fnd_global.login_id
116:
117: where entity_group_comp_id = p_rec.entity_group_comp_id;
118: --
119: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
120: --
121: if g_debug then
122: hr_utility.set_location(' Leaving:'||l_proc, 10);
123: end if;
124: --
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
129: hxc_egc_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
129: hxc_egc_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
129: hxc_egc_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
134: hxc_egc_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
134: hxc_egc_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
134: hxc_egc_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
139: hxc_egc_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
139: hxc_egc_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
143: Raise;
138: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
139: hxc_egc_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
143: Raise;
144: End update_dml;
145: --
146: -- ----------------------------------------------------------------------------
173: -- Internal Row Handler Use Only.
174: --
175: -- ----------------------------------------------------------------------------
176: Procedure pre_update
177: (p_rec in hxc_egc_shd.g_rec_type
178: ) is
179: --
180: l_proc varchar2(72);
181: --
219: --
220: -- ----------------------------------------------------------------------------
221: Procedure post_update
222: (p_effective_date in date
223: ,p_rec in hxc_egc_shd.g_rec_type
224: ) is
225: --
226: l_proc varchar2(72);
227: --
306: => p_rec.attribute30
307: ,p_object_version_number
308: => p_rec.object_version_number
309: ,p_entity_group_id_o
310: => hxc_egc_shd.g_old_rec.entity_group_id
311: ,p_entity_id_o
312: => hxc_egc_shd.g_old_rec.entity_id
313: ,p_entity_type_o
314: => hxc_egc_shd.g_old_rec.entity_type
308: => p_rec.object_version_number
309: ,p_entity_group_id_o
310: => hxc_egc_shd.g_old_rec.entity_group_id
311: ,p_entity_id_o
312: => hxc_egc_shd.g_old_rec.entity_id
313: ,p_entity_type_o
314: => hxc_egc_shd.g_old_rec.entity_type
315: ,p_attribute_category_o
316: => hxc_egc_shd.g_old_rec.attribute_category
310: => hxc_egc_shd.g_old_rec.entity_group_id
311: ,p_entity_id_o
312: => hxc_egc_shd.g_old_rec.entity_id
313: ,p_entity_type_o
314: => hxc_egc_shd.g_old_rec.entity_type
315: ,p_attribute_category_o
316: => hxc_egc_shd.g_old_rec.attribute_category
317: ,p_attribute1_o
318: => hxc_egc_shd.g_old_rec.attribute1
312: => hxc_egc_shd.g_old_rec.entity_id
313: ,p_entity_type_o
314: => hxc_egc_shd.g_old_rec.entity_type
315: ,p_attribute_category_o
316: => hxc_egc_shd.g_old_rec.attribute_category
317: ,p_attribute1_o
318: => hxc_egc_shd.g_old_rec.attribute1
319: ,p_attribute2_o
320: => hxc_egc_shd.g_old_rec.attribute2
314: => hxc_egc_shd.g_old_rec.entity_type
315: ,p_attribute_category_o
316: => hxc_egc_shd.g_old_rec.attribute_category
317: ,p_attribute1_o
318: => hxc_egc_shd.g_old_rec.attribute1
319: ,p_attribute2_o
320: => hxc_egc_shd.g_old_rec.attribute2
321: ,p_attribute3_o
322: => hxc_egc_shd.g_old_rec.attribute3
316: => hxc_egc_shd.g_old_rec.attribute_category
317: ,p_attribute1_o
318: => hxc_egc_shd.g_old_rec.attribute1
319: ,p_attribute2_o
320: => hxc_egc_shd.g_old_rec.attribute2
321: ,p_attribute3_o
322: => hxc_egc_shd.g_old_rec.attribute3
323: ,p_attribute4_o
324: => hxc_egc_shd.g_old_rec.attribute4
318: => hxc_egc_shd.g_old_rec.attribute1
319: ,p_attribute2_o
320: => hxc_egc_shd.g_old_rec.attribute2
321: ,p_attribute3_o
322: => hxc_egc_shd.g_old_rec.attribute3
323: ,p_attribute4_o
324: => hxc_egc_shd.g_old_rec.attribute4
325: ,p_attribute5_o
326: => hxc_egc_shd.g_old_rec.attribute5
320: => hxc_egc_shd.g_old_rec.attribute2
321: ,p_attribute3_o
322: => hxc_egc_shd.g_old_rec.attribute3
323: ,p_attribute4_o
324: => hxc_egc_shd.g_old_rec.attribute4
325: ,p_attribute5_o
326: => hxc_egc_shd.g_old_rec.attribute5
327: ,p_attribute6_o
328: => hxc_egc_shd.g_old_rec.attribute6
322: => hxc_egc_shd.g_old_rec.attribute3
323: ,p_attribute4_o
324: => hxc_egc_shd.g_old_rec.attribute4
325: ,p_attribute5_o
326: => hxc_egc_shd.g_old_rec.attribute5
327: ,p_attribute6_o
328: => hxc_egc_shd.g_old_rec.attribute6
329: ,p_attribute7_o
330: => hxc_egc_shd.g_old_rec.attribute7
324: => hxc_egc_shd.g_old_rec.attribute4
325: ,p_attribute5_o
326: => hxc_egc_shd.g_old_rec.attribute5
327: ,p_attribute6_o
328: => hxc_egc_shd.g_old_rec.attribute6
329: ,p_attribute7_o
330: => hxc_egc_shd.g_old_rec.attribute7
331: ,p_attribute8_o
332: => hxc_egc_shd.g_old_rec.attribute8
326: => hxc_egc_shd.g_old_rec.attribute5
327: ,p_attribute6_o
328: => hxc_egc_shd.g_old_rec.attribute6
329: ,p_attribute7_o
330: => hxc_egc_shd.g_old_rec.attribute7
331: ,p_attribute8_o
332: => hxc_egc_shd.g_old_rec.attribute8
333: ,p_attribute9_o
334: => hxc_egc_shd.g_old_rec.attribute9
328: => hxc_egc_shd.g_old_rec.attribute6
329: ,p_attribute7_o
330: => hxc_egc_shd.g_old_rec.attribute7
331: ,p_attribute8_o
332: => hxc_egc_shd.g_old_rec.attribute8
333: ,p_attribute9_o
334: => hxc_egc_shd.g_old_rec.attribute9
335: ,p_attribute10_o
336: => hxc_egc_shd.g_old_rec.attribute10
330: => hxc_egc_shd.g_old_rec.attribute7
331: ,p_attribute8_o
332: => hxc_egc_shd.g_old_rec.attribute8
333: ,p_attribute9_o
334: => hxc_egc_shd.g_old_rec.attribute9
335: ,p_attribute10_o
336: => hxc_egc_shd.g_old_rec.attribute10
337: ,p_attribute11_o
338: => hxc_egc_shd.g_old_rec.attribute11
332: => hxc_egc_shd.g_old_rec.attribute8
333: ,p_attribute9_o
334: => hxc_egc_shd.g_old_rec.attribute9
335: ,p_attribute10_o
336: => hxc_egc_shd.g_old_rec.attribute10
337: ,p_attribute11_o
338: => hxc_egc_shd.g_old_rec.attribute11
339: ,p_attribute12_o
340: => hxc_egc_shd.g_old_rec.attribute12
334: => hxc_egc_shd.g_old_rec.attribute9
335: ,p_attribute10_o
336: => hxc_egc_shd.g_old_rec.attribute10
337: ,p_attribute11_o
338: => hxc_egc_shd.g_old_rec.attribute11
339: ,p_attribute12_o
340: => hxc_egc_shd.g_old_rec.attribute12
341: ,p_attribute13_o
342: => hxc_egc_shd.g_old_rec.attribute13
336: => hxc_egc_shd.g_old_rec.attribute10
337: ,p_attribute11_o
338: => hxc_egc_shd.g_old_rec.attribute11
339: ,p_attribute12_o
340: => hxc_egc_shd.g_old_rec.attribute12
341: ,p_attribute13_o
342: => hxc_egc_shd.g_old_rec.attribute13
343: ,p_attribute14_o
344: => hxc_egc_shd.g_old_rec.attribute14
338: => hxc_egc_shd.g_old_rec.attribute11
339: ,p_attribute12_o
340: => hxc_egc_shd.g_old_rec.attribute12
341: ,p_attribute13_o
342: => hxc_egc_shd.g_old_rec.attribute13
343: ,p_attribute14_o
344: => hxc_egc_shd.g_old_rec.attribute14
345: ,p_attribute15_o
346: => hxc_egc_shd.g_old_rec.attribute15
340: => hxc_egc_shd.g_old_rec.attribute12
341: ,p_attribute13_o
342: => hxc_egc_shd.g_old_rec.attribute13
343: ,p_attribute14_o
344: => hxc_egc_shd.g_old_rec.attribute14
345: ,p_attribute15_o
346: => hxc_egc_shd.g_old_rec.attribute15
347: ,p_attribute16_o
348: => hxc_egc_shd.g_old_rec.attribute16
342: => hxc_egc_shd.g_old_rec.attribute13
343: ,p_attribute14_o
344: => hxc_egc_shd.g_old_rec.attribute14
345: ,p_attribute15_o
346: => hxc_egc_shd.g_old_rec.attribute15
347: ,p_attribute16_o
348: => hxc_egc_shd.g_old_rec.attribute16
349: ,p_attribute17_o
350: => hxc_egc_shd.g_old_rec.attribute17
344: => hxc_egc_shd.g_old_rec.attribute14
345: ,p_attribute15_o
346: => hxc_egc_shd.g_old_rec.attribute15
347: ,p_attribute16_o
348: => hxc_egc_shd.g_old_rec.attribute16
349: ,p_attribute17_o
350: => hxc_egc_shd.g_old_rec.attribute17
351: ,p_attribute18_o
352: => hxc_egc_shd.g_old_rec.attribute18
346: => hxc_egc_shd.g_old_rec.attribute15
347: ,p_attribute16_o
348: => hxc_egc_shd.g_old_rec.attribute16
349: ,p_attribute17_o
350: => hxc_egc_shd.g_old_rec.attribute17
351: ,p_attribute18_o
352: => hxc_egc_shd.g_old_rec.attribute18
353: ,p_attribute19_o
354: => hxc_egc_shd.g_old_rec.attribute19
348: => hxc_egc_shd.g_old_rec.attribute16
349: ,p_attribute17_o
350: => hxc_egc_shd.g_old_rec.attribute17
351: ,p_attribute18_o
352: => hxc_egc_shd.g_old_rec.attribute18
353: ,p_attribute19_o
354: => hxc_egc_shd.g_old_rec.attribute19
355: ,p_attribute20_o
356: => hxc_egc_shd.g_old_rec.attribute20
350: => hxc_egc_shd.g_old_rec.attribute17
351: ,p_attribute18_o
352: => hxc_egc_shd.g_old_rec.attribute18
353: ,p_attribute19_o
354: => hxc_egc_shd.g_old_rec.attribute19
355: ,p_attribute20_o
356: => hxc_egc_shd.g_old_rec.attribute20
357: ,p_attribute21_o
358: => hxc_egc_shd.g_old_rec.attribute21
352: => hxc_egc_shd.g_old_rec.attribute18
353: ,p_attribute19_o
354: => hxc_egc_shd.g_old_rec.attribute19
355: ,p_attribute20_o
356: => hxc_egc_shd.g_old_rec.attribute20
357: ,p_attribute21_o
358: => hxc_egc_shd.g_old_rec.attribute21
359: ,p_attribute22_o
360: => hxc_egc_shd.g_old_rec.attribute22
354: => hxc_egc_shd.g_old_rec.attribute19
355: ,p_attribute20_o
356: => hxc_egc_shd.g_old_rec.attribute20
357: ,p_attribute21_o
358: => hxc_egc_shd.g_old_rec.attribute21
359: ,p_attribute22_o
360: => hxc_egc_shd.g_old_rec.attribute22
361: ,p_attribute23_o
362: => hxc_egc_shd.g_old_rec.attribute23
356: => hxc_egc_shd.g_old_rec.attribute20
357: ,p_attribute21_o
358: => hxc_egc_shd.g_old_rec.attribute21
359: ,p_attribute22_o
360: => hxc_egc_shd.g_old_rec.attribute22
361: ,p_attribute23_o
362: => hxc_egc_shd.g_old_rec.attribute23
363: ,p_attribute24_o
364: => hxc_egc_shd.g_old_rec.attribute24
358: => hxc_egc_shd.g_old_rec.attribute21
359: ,p_attribute22_o
360: => hxc_egc_shd.g_old_rec.attribute22
361: ,p_attribute23_o
362: => hxc_egc_shd.g_old_rec.attribute23
363: ,p_attribute24_o
364: => hxc_egc_shd.g_old_rec.attribute24
365: ,p_attribute25_o
366: => hxc_egc_shd.g_old_rec.attribute25
360: => hxc_egc_shd.g_old_rec.attribute22
361: ,p_attribute23_o
362: => hxc_egc_shd.g_old_rec.attribute23
363: ,p_attribute24_o
364: => hxc_egc_shd.g_old_rec.attribute24
365: ,p_attribute25_o
366: => hxc_egc_shd.g_old_rec.attribute25
367: ,p_attribute26_o
368: => hxc_egc_shd.g_old_rec.attribute26
362: => hxc_egc_shd.g_old_rec.attribute23
363: ,p_attribute24_o
364: => hxc_egc_shd.g_old_rec.attribute24
365: ,p_attribute25_o
366: => hxc_egc_shd.g_old_rec.attribute25
367: ,p_attribute26_o
368: => hxc_egc_shd.g_old_rec.attribute26
369: ,p_attribute27_o
370: => hxc_egc_shd.g_old_rec.attribute27
364: => hxc_egc_shd.g_old_rec.attribute24
365: ,p_attribute25_o
366: => hxc_egc_shd.g_old_rec.attribute25
367: ,p_attribute26_o
368: => hxc_egc_shd.g_old_rec.attribute26
369: ,p_attribute27_o
370: => hxc_egc_shd.g_old_rec.attribute27
371: ,p_attribute28_o
372: => hxc_egc_shd.g_old_rec.attribute28
366: => hxc_egc_shd.g_old_rec.attribute25
367: ,p_attribute26_o
368: => hxc_egc_shd.g_old_rec.attribute26
369: ,p_attribute27_o
370: => hxc_egc_shd.g_old_rec.attribute27
371: ,p_attribute28_o
372: => hxc_egc_shd.g_old_rec.attribute28
373: ,p_attribute29_o
374: => hxc_egc_shd.g_old_rec.attribute29
368: => hxc_egc_shd.g_old_rec.attribute26
369: ,p_attribute27_o
370: => hxc_egc_shd.g_old_rec.attribute27
371: ,p_attribute28_o
372: => hxc_egc_shd.g_old_rec.attribute28
373: ,p_attribute29_o
374: => hxc_egc_shd.g_old_rec.attribute29
375: ,p_attribute30_o
376: => hxc_egc_shd.g_old_rec.attribute30
370: => hxc_egc_shd.g_old_rec.attribute27
371: ,p_attribute28_o
372: => hxc_egc_shd.g_old_rec.attribute28
373: ,p_attribute29_o
374: => hxc_egc_shd.g_old_rec.attribute29
375: ,p_attribute30_o
376: => hxc_egc_shd.g_old_rec.attribute30
377: ,p_object_version_number_o
378: => hxc_egc_shd.g_old_rec.object_version_number
372: => hxc_egc_shd.g_old_rec.attribute28
373: ,p_attribute29_o
374: => hxc_egc_shd.g_old_rec.attribute29
375: ,p_attribute30_o
376: => hxc_egc_shd.g_old_rec.attribute30
377: ,p_object_version_number_o
378: => hxc_egc_shd.g_old_rec.object_version_number
379: );
380: --
374: => hxc_egc_shd.g_old_rec.attribute29
375: ,p_attribute30_o
376: => hxc_egc_shd.g_old_rec.attribute30
377: ,p_object_version_number_o
378: => hxc_egc_shd.g_old_rec.object_version_number
379: );
380: --
381: exception
382: --
434: -- Internal Row Handler Use Only.
435: --
436: -- ----------------------------------------------------------------------------
437: Procedure convert_defs
438: (p_rec in out nocopy hxc_egc_shd.g_rec_type
439: ) is
440: --
441: Begin
442: --
446: -- is being used then we must set to the 'current' argument value.
447: --
448: If (p_rec.entity_group_id = hr_api.g_number) then
449: p_rec.entity_group_id :=
450: hxc_egc_shd.g_old_rec.entity_group_id;
451: End If;
452: If (p_rec.entity_id = hr_api.g_number) then
453: p_rec.entity_id :=
454: hxc_egc_shd.g_old_rec.entity_id;
450: hxc_egc_shd.g_old_rec.entity_group_id;
451: End If;
452: If (p_rec.entity_id = hr_api.g_number) then
453: p_rec.entity_id :=
454: hxc_egc_shd.g_old_rec.entity_id;
455: End If;
456: If (p_rec.entity_type = hr_api.g_varchar2) then
457: p_rec.entity_type :=
458: hxc_egc_shd.g_old_rec.entity_type;
454: hxc_egc_shd.g_old_rec.entity_id;
455: End If;
456: If (p_rec.entity_type = hr_api.g_varchar2) then
457: p_rec.entity_type :=
458: hxc_egc_shd.g_old_rec.entity_type;
459: End If;
460: If (p_rec.attribute_category = hr_api.g_varchar2) then
461: p_rec.attribute_category :=
462: hxc_egc_shd.g_old_rec.attribute_category;
458: hxc_egc_shd.g_old_rec.entity_type;
459: End If;
460: If (p_rec.attribute_category = hr_api.g_varchar2) then
461: p_rec.attribute_category :=
462: hxc_egc_shd.g_old_rec.attribute_category;
463: End If;
464: If (p_rec.attribute1 = hr_api.g_varchar2) then
465: p_rec.attribute1 :=
466: hxc_egc_shd.g_old_rec.attribute1;
462: hxc_egc_shd.g_old_rec.attribute_category;
463: End If;
464: If (p_rec.attribute1 = hr_api.g_varchar2) then
465: p_rec.attribute1 :=
466: hxc_egc_shd.g_old_rec.attribute1;
467: End If;
468: If (p_rec.attribute2 = hr_api.g_varchar2) then
469: p_rec.attribute2 :=
470: hxc_egc_shd.g_old_rec.attribute2;
466: hxc_egc_shd.g_old_rec.attribute1;
467: End If;
468: If (p_rec.attribute2 = hr_api.g_varchar2) then
469: p_rec.attribute2 :=
470: hxc_egc_shd.g_old_rec.attribute2;
471: End If;
472: If (p_rec.attribute3 = hr_api.g_varchar2) then
473: p_rec.attribute3 :=
474: hxc_egc_shd.g_old_rec.attribute3;
470: hxc_egc_shd.g_old_rec.attribute2;
471: End If;
472: If (p_rec.attribute3 = hr_api.g_varchar2) then
473: p_rec.attribute3 :=
474: hxc_egc_shd.g_old_rec.attribute3;
475: End If;
476: If (p_rec.attribute4 = hr_api.g_varchar2) then
477: p_rec.attribute4 :=
478: hxc_egc_shd.g_old_rec.attribute4;
474: hxc_egc_shd.g_old_rec.attribute3;
475: End If;
476: If (p_rec.attribute4 = hr_api.g_varchar2) then
477: p_rec.attribute4 :=
478: hxc_egc_shd.g_old_rec.attribute4;
479: End If;
480: If (p_rec.attribute5 = hr_api.g_varchar2) then
481: p_rec.attribute5 :=
482: hxc_egc_shd.g_old_rec.attribute5;
478: hxc_egc_shd.g_old_rec.attribute4;
479: End If;
480: If (p_rec.attribute5 = hr_api.g_varchar2) then
481: p_rec.attribute5 :=
482: hxc_egc_shd.g_old_rec.attribute5;
483: End If;
484: If (p_rec.attribute6 = hr_api.g_varchar2) then
485: p_rec.attribute6 :=
486: hxc_egc_shd.g_old_rec.attribute6;
482: hxc_egc_shd.g_old_rec.attribute5;
483: End If;
484: If (p_rec.attribute6 = hr_api.g_varchar2) then
485: p_rec.attribute6 :=
486: hxc_egc_shd.g_old_rec.attribute6;
487: End If;
488: If (p_rec.attribute7 = hr_api.g_varchar2) then
489: p_rec.attribute7 :=
490: hxc_egc_shd.g_old_rec.attribute7;
486: hxc_egc_shd.g_old_rec.attribute6;
487: End If;
488: If (p_rec.attribute7 = hr_api.g_varchar2) then
489: p_rec.attribute7 :=
490: hxc_egc_shd.g_old_rec.attribute7;
491: End If;
492: If (p_rec.attribute8 = hr_api.g_varchar2) then
493: p_rec.attribute8 :=
494: hxc_egc_shd.g_old_rec.attribute8;
490: hxc_egc_shd.g_old_rec.attribute7;
491: End If;
492: If (p_rec.attribute8 = hr_api.g_varchar2) then
493: p_rec.attribute8 :=
494: hxc_egc_shd.g_old_rec.attribute8;
495: End If;
496: If (p_rec.attribute9 = hr_api.g_varchar2) then
497: p_rec.attribute9 :=
498: hxc_egc_shd.g_old_rec.attribute9;
494: hxc_egc_shd.g_old_rec.attribute8;
495: End If;
496: If (p_rec.attribute9 = hr_api.g_varchar2) then
497: p_rec.attribute9 :=
498: hxc_egc_shd.g_old_rec.attribute9;
499: End If;
500: If (p_rec.attribute10 = hr_api.g_varchar2) then
501: p_rec.attribute10 :=
502: hxc_egc_shd.g_old_rec.attribute10;
498: hxc_egc_shd.g_old_rec.attribute9;
499: End If;
500: If (p_rec.attribute10 = hr_api.g_varchar2) then
501: p_rec.attribute10 :=
502: hxc_egc_shd.g_old_rec.attribute10;
503: End If;
504: If (p_rec.attribute11 = hr_api.g_varchar2) then
505: p_rec.attribute11 :=
506: hxc_egc_shd.g_old_rec.attribute11;
502: hxc_egc_shd.g_old_rec.attribute10;
503: End If;
504: If (p_rec.attribute11 = hr_api.g_varchar2) then
505: p_rec.attribute11 :=
506: hxc_egc_shd.g_old_rec.attribute11;
507: End If;
508: If (p_rec.attribute12 = hr_api.g_varchar2) then
509: p_rec.attribute12 :=
510: hxc_egc_shd.g_old_rec.attribute12;
506: hxc_egc_shd.g_old_rec.attribute11;
507: End If;
508: If (p_rec.attribute12 = hr_api.g_varchar2) then
509: p_rec.attribute12 :=
510: hxc_egc_shd.g_old_rec.attribute12;
511: End If;
512: If (p_rec.attribute13 = hr_api.g_varchar2) then
513: p_rec.attribute13 :=
514: hxc_egc_shd.g_old_rec.attribute13;
510: hxc_egc_shd.g_old_rec.attribute12;
511: End If;
512: If (p_rec.attribute13 = hr_api.g_varchar2) then
513: p_rec.attribute13 :=
514: hxc_egc_shd.g_old_rec.attribute13;
515: End If;
516: If (p_rec.attribute14 = hr_api.g_varchar2) then
517: p_rec.attribute14 :=
518: hxc_egc_shd.g_old_rec.attribute14;
514: hxc_egc_shd.g_old_rec.attribute13;
515: End If;
516: If (p_rec.attribute14 = hr_api.g_varchar2) then
517: p_rec.attribute14 :=
518: hxc_egc_shd.g_old_rec.attribute14;
519: End If;
520: If (p_rec.attribute15 = hr_api.g_varchar2) then
521: p_rec.attribute15 :=
522: hxc_egc_shd.g_old_rec.attribute15;
518: hxc_egc_shd.g_old_rec.attribute14;
519: End If;
520: If (p_rec.attribute15 = hr_api.g_varchar2) then
521: p_rec.attribute15 :=
522: hxc_egc_shd.g_old_rec.attribute15;
523: End If;
524: If (p_rec.attribute16 = hr_api.g_varchar2) then
525: p_rec.attribute16 :=
526: hxc_egc_shd.g_old_rec.attribute16;
522: hxc_egc_shd.g_old_rec.attribute15;
523: End If;
524: If (p_rec.attribute16 = hr_api.g_varchar2) then
525: p_rec.attribute16 :=
526: hxc_egc_shd.g_old_rec.attribute16;
527: End If;
528: If (p_rec.attribute17 = hr_api.g_varchar2) then
529: p_rec.attribute17 :=
530: hxc_egc_shd.g_old_rec.attribute17;
526: hxc_egc_shd.g_old_rec.attribute16;
527: End If;
528: If (p_rec.attribute17 = hr_api.g_varchar2) then
529: p_rec.attribute17 :=
530: hxc_egc_shd.g_old_rec.attribute17;
531: End If;
532: If (p_rec.attribute18 = hr_api.g_varchar2) then
533: p_rec.attribute18 :=
534: hxc_egc_shd.g_old_rec.attribute18;
530: hxc_egc_shd.g_old_rec.attribute17;
531: End If;
532: If (p_rec.attribute18 = hr_api.g_varchar2) then
533: p_rec.attribute18 :=
534: hxc_egc_shd.g_old_rec.attribute18;
535: End If;
536: If (p_rec.attribute19 = hr_api.g_varchar2) then
537: p_rec.attribute19 :=
538: hxc_egc_shd.g_old_rec.attribute19;
534: hxc_egc_shd.g_old_rec.attribute18;
535: End If;
536: If (p_rec.attribute19 = hr_api.g_varchar2) then
537: p_rec.attribute19 :=
538: hxc_egc_shd.g_old_rec.attribute19;
539: End If;
540: If (p_rec.attribute20 = hr_api.g_varchar2) then
541: p_rec.attribute20 :=
542: hxc_egc_shd.g_old_rec.attribute20;
538: hxc_egc_shd.g_old_rec.attribute19;
539: End If;
540: If (p_rec.attribute20 = hr_api.g_varchar2) then
541: p_rec.attribute20 :=
542: hxc_egc_shd.g_old_rec.attribute20;
543: End If;
544: If (p_rec.attribute21 = hr_api.g_varchar2) then
545: p_rec.attribute21 :=
546: hxc_egc_shd.g_old_rec.attribute21;
542: hxc_egc_shd.g_old_rec.attribute20;
543: End If;
544: If (p_rec.attribute21 = hr_api.g_varchar2) then
545: p_rec.attribute21 :=
546: hxc_egc_shd.g_old_rec.attribute21;
547: End If;
548: If (p_rec.attribute22 = hr_api.g_varchar2) then
549: p_rec.attribute22 :=
550: hxc_egc_shd.g_old_rec.attribute22;
546: hxc_egc_shd.g_old_rec.attribute21;
547: End If;
548: If (p_rec.attribute22 = hr_api.g_varchar2) then
549: p_rec.attribute22 :=
550: hxc_egc_shd.g_old_rec.attribute22;
551: End If;
552: If (p_rec.attribute23 = hr_api.g_varchar2) then
553: p_rec.attribute23 :=
554: hxc_egc_shd.g_old_rec.attribute23;
550: hxc_egc_shd.g_old_rec.attribute22;
551: End If;
552: If (p_rec.attribute23 = hr_api.g_varchar2) then
553: p_rec.attribute23 :=
554: hxc_egc_shd.g_old_rec.attribute23;
555: End If;
556: If (p_rec.attribute24 = hr_api.g_varchar2) then
557: p_rec.attribute24 :=
558: hxc_egc_shd.g_old_rec.attribute24;
554: hxc_egc_shd.g_old_rec.attribute23;
555: End If;
556: If (p_rec.attribute24 = hr_api.g_varchar2) then
557: p_rec.attribute24 :=
558: hxc_egc_shd.g_old_rec.attribute24;
559: End If;
560: If (p_rec.attribute25 = hr_api.g_varchar2) then
561: p_rec.attribute25 :=
562: hxc_egc_shd.g_old_rec.attribute25;
558: hxc_egc_shd.g_old_rec.attribute24;
559: End If;
560: If (p_rec.attribute25 = hr_api.g_varchar2) then
561: p_rec.attribute25 :=
562: hxc_egc_shd.g_old_rec.attribute25;
563: End If;
564: If (p_rec.attribute26 = hr_api.g_varchar2) then
565: p_rec.attribute26 :=
566: hxc_egc_shd.g_old_rec.attribute26;
562: hxc_egc_shd.g_old_rec.attribute25;
563: End If;
564: If (p_rec.attribute26 = hr_api.g_varchar2) then
565: p_rec.attribute26 :=
566: hxc_egc_shd.g_old_rec.attribute26;
567: End If;
568: If (p_rec.attribute27 = hr_api.g_varchar2) then
569: p_rec.attribute27 :=
570: hxc_egc_shd.g_old_rec.attribute27;
566: hxc_egc_shd.g_old_rec.attribute26;
567: End If;
568: If (p_rec.attribute27 = hr_api.g_varchar2) then
569: p_rec.attribute27 :=
570: hxc_egc_shd.g_old_rec.attribute27;
571: End If;
572: If (p_rec.attribute28 = hr_api.g_varchar2) then
573: p_rec.attribute28 :=
574: hxc_egc_shd.g_old_rec.attribute28;
570: hxc_egc_shd.g_old_rec.attribute27;
571: End If;
572: If (p_rec.attribute28 = hr_api.g_varchar2) then
573: p_rec.attribute28 :=
574: hxc_egc_shd.g_old_rec.attribute28;
575: End If;
576: If (p_rec.attribute29 = hr_api.g_varchar2) then
577: p_rec.attribute29 :=
578: hxc_egc_shd.g_old_rec.attribute29;
574: hxc_egc_shd.g_old_rec.attribute28;
575: End If;
576: If (p_rec.attribute29 = hr_api.g_varchar2) then
577: p_rec.attribute29 :=
578: hxc_egc_shd.g_old_rec.attribute29;
579: End If;
580: If (p_rec.attribute30 = hr_api.g_varchar2) then
581: p_rec.attribute30 :=
582: hxc_egc_shd.g_old_rec.attribute30;
578: hxc_egc_shd.g_old_rec.attribute29;
579: End If;
580: If (p_rec.attribute30 = hr_api.g_varchar2) then
581: p_rec.attribute30 :=
582: hxc_egc_shd.g_old_rec.attribute30;
583: End If;
584: --
585: End convert_defs;
586: --
588: -- |---------------------------------< upd >----------------------------------|
589: -- ----------------------------------------------------------------------------
590: Procedure upd
591: (p_effective_date in date
592: ,p_rec in out nocopy hxc_egc_shd.g_rec_type
593: ,p_called_from_form in varchar2
594: ) is
595: --
596: l_proc varchar2(72);
603: end if;
604: --
605: -- We must lock the row which we need to update.
606: --
607: hxc_egc_shd.lck
608: (p_rec.entity_group_comp_id
609: ,p_rec.object_version_number
610: );
611: --
688: ,p_attribute30 in varchar2 default hr_api.g_varchar2
689: ,p_called_from_form in varchar2
690: ) is
691: --
692: l_rec hxc_egc_shd.g_rec_type;
693: l_proc varchar2(72);
694: --
695: Begin
696: g_debug:=hr_utility.debug_enabled;
703: -- l_rec structure.
704: --
705:
706: l_rec :=
707: hxc_egc_shd.convert_args
708: (p_entity_group_comp_id
709: ,p_entity_group_id
710: ,p_entity_id
711: ,p_entity_type