[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ben_eiv_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: ben_eiv_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the ben_extra_input_values Row
69: --
70: update ben_extra_input_values
109: ,eiv_attribute30 = p_rec.eiv_attribute30
110: ,object_version_number = p_rec.object_version_number
111: where extra_input_value_id = p_rec.extra_input_value_id;
112: --
113: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: --
117: Exception
116: --
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
121: ben_eiv_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
121: ben_eiv_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
121: ben_eiv_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
126: ben_eiv_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
126: ben_eiv_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
126: ben_eiv_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
131: ben_eiv_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
131: ben_eiv_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
135: Raise;
130: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
131: ben_eiv_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
135: Raise;
136: End update_dml;
137: --
138: -- ----------------------------------------------------------------------------
168: -- {End Of Comments}
169: -- ----------------------------------------------------------------------------
170: Procedure pre_update
171: (p_effective_date in date
172: ,p_rec in ben_eiv_shd.g_rec_type
173: ) is
174: --
175: l_proc varchar2(72) := g_package||'pre_update';
176: --
213: -- {End Of Comments}
214: -- ----------------------------------------------------------------------------
215: Procedure post_update
216: (p_effective_date in date
217: ,p_rec in ben_eiv_shd.g_rec_type
218: ) is
219: --
220: l_proc varchar2(72) := g_package||'post_update';
221: --
304: => p_rec.object_version_number
305: ,p_effective_date
306: => p_effective_date
307: ,p_acty_base_rt_id_o
308: => ben_eiv_shd.g_old_rec.acty_base_rt_id
309: ,p_input_value_id_o
310: => ben_eiv_shd.g_old_rec.input_value_id
311: ,p_input_text_o
312: => ben_eiv_shd.g_old_rec.input_text
306: => p_effective_date
307: ,p_acty_base_rt_id_o
308: => ben_eiv_shd.g_old_rec.acty_base_rt_id
309: ,p_input_value_id_o
310: => ben_eiv_shd.g_old_rec.input_value_id
311: ,p_input_text_o
312: => ben_eiv_shd.g_old_rec.input_text
313: ,p_upd_when_ele_ended_cd_o
314: => ben_eiv_shd.g_old_rec.upd_when_ele_ended_cd
308: => ben_eiv_shd.g_old_rec.acty_base_rt_id
309: ,p_input_value_id_o
310: => ben_eiv_shd.g_old_rec.input_value_id
311: ,p_input_text_o
312: => ben_eiv_shd.g_old_rec.input_text
313: ,p_upd_when_ele_ended_cd_o
314: => ben_eiv_shd.g_old_rec.upd_when_ele_ended_cd
315: ,p_return_var_name_o
316: => ben_eiv_shd.g_old_rec.return_var_name
310: => ben_eiv_shd.g_old_rec.input_value_id
311: ,p_input_text_o
312: => ben_eiv_shd.g_old_rec.input_text
313: ,p_upd_when_ele_ended_cd_o
314: => ben_eiv_shd.g_old_rec.upd_when_ele_ended_cd
315: ,p_return_var_name_o
316: => ben_eiv_shd.g_old_rec.return_var_name
317: ,p_business_group_id_o
318: => ben_eiv_shd.g_old_rec.business_group_id
312: => ben_eiv_shd.g_old_rec.input_text
313: ,p_upd_when_ele_ended_cd_o
314: => ben_eiv_shd.g_old_rec.upd_when_ele_ended_cd
315: ,p_return_var_name_o
316: => ben_eiv_shd.g_old_rec.return_var_name
317: ,p_business_group_id_o
318: => ben_eiv_shd.g_old_rec.business_group_id
319: ,p_eiv_attribute_category_o
320: => ben_eiv_shd.g_old_rec.eiv_attribute_category
314: => ben_eiv_shd.g_old_rec.upd_when_ele_ended_cd
315: ,p_return_var_name_o
316: => ben_eiv_shd.g_old_rec.return_var_name
317: ,p_business_group_id_o
318: => ben_eiv_shd.g_old_rec.business_group_id
319: ,p_eiv_attribute_category_o
320: => ben_eiv_shd.g_old_rec.eiv_attribute_category
321: ,p_eiv_attribute1_o
322: => ben_eiv_shd.g_old_rec.eiv_attribute1
316: => ben_eiv_shd.g_old_rec.return_var_name
317: ,p_business_group_id_o
318: => ben_eiv_shd.g_old_rec.business_group_id
319: ,p_eiv_attribute_category_o
320: => ben_eiv_shd.g_old_rec.eiv_attribute_category
321: ,p_eiv_attribute1_o
322: => ben_eiv_shd.g_old_rec.eiv_attribute1
323: ,p_eiv_attribute2_o
324: => ben_eiv_shd.g_old_rec.eiv_attribute2
318: => ben_eiv_shd.g_old_rec.business_group_id
319: ,p_eiv_attribute_category_o
320: => ben_eiv_shd.g_old_rec.eiv_attribute_category
321: ,p_eiv_attribute1_o
322: => ben_eiv_shd.g_old_rec.eiv_attribute1
323: ,p_eiv_attribute2_o
324: => ben_eiv_shd.g_old_rec.eiv_attribute2
325: ,p_eiv_attribute3_o
326: => ben_eiv_shd.g_old_rec.eiv_attribute3
320: => ben_eiv_shd.g_old_rec.eiv_attribute_category
321: ,p_eiv_attribute1_o
322: => ben_eiv_shd.g_old_rec.eiv_attribute1
323: ,p_eiv_attribute2_o
324: => ben_eiv_shd.g_old_rec.eiv_attribute2
325: ,p_eiv_attribute3_o
326: => ben_eiv_shd.g_old_rec.eiv_attribute3
327: ,p_eiv_attribute4_o
328: => ben_eiv_shd.g_old_rec.eiv_attribute4
322: => ben_eiv_shd.g_old_rec.eiv_attribute1
323: ,p_eiv_attribute2_o
324: => ben_eiv_shd.g_old_rec.eiv_attribute2
325: ,p_eiv_attribute3_o
326: => ben_eiv_shd.g_old_rec.eiv_attribute3
327: ,p_eiv_attribute4_o
328: => ben_eiv_shd.g_old_rec.eiv_attribute4
329: ,p_eiv_attribute5_o
330: => ben_eiv_shd.g_old_rec.eiv_attribute5
324: => ben_eiv_shd.g_old_rec.eiv_attribute2
325: ,p_eiv_attribute3_o
326: => ben_eiv_shd.g_old_rec.eiv_attribute3
327: ,p_eiv_attribute4_o
328: => ben_eiv_shd.g_old_rec.eiv_attribute4
329: ,p_eiv_attribute5_o
330: => ben_eiv_shd.g_old_rec.eiv_attribute5
331: ,p_eiv_attribute6_o
332: => ben_eiv_shd.g_old_rec.eiv_attribute6
326: => ben_eiv_shd.g_old_rec.eiv_attribute3
327: ,p_eiv_attribute4_o
328: => ben_eiv_shd.g_old_rec.eiv_attribute4
329: ,p_eiv_attribute5_o
330: => ben_eiv_shd.g_old_rec.eiv_attribute5
331: ,p_eiv_attribute6_o
332: => ben_eiv_shd.g_old_rec.eiv_attribute6
333: ,p_eiv_attribute7_o
334: => ben_eiv_shd.g_old_rec.eiv_attribute7
328: => ben_eiv_shd.g_old_rec.eiv_attribute4
329: ,p_eiv_attribute5_o
330: => ben_eiv_shd.g_old_rec.eiv_attribute5
331: ,p_eiv_attribute6_o
332: => ben_eiv_shd.g_old_rec.eiv_attribute6
333: ,p_eiv_attribute7_o
334: => ben_eiv_shd.g_old_rec.eiv_attribute7
335: ,p_eiv_attribute8_o
336: => ben_eiv_shd.g_old_rec.eiv_attribute8
330: => ben_eiv_shd.g_old_rec.eiv_attribute5
331: ,p_eiv_attribute6_o
332: => ben_eiv_shd.g_old_rec.eiv_attribute6
333: ,p_eiv_attribute7_o
334: => ben_eiv_shd.g_old_rec.eiv_attribute7
335: ,p_eiv_attribute8_o
336: => ben_eiv_shd.g_old_rec.eiv_attribute8
337: ,p_eiv_attribute9_o
338: => ben_eiv_shd.g_old_rec.eiv_attribute9
332: => ben_eiv_shd.g_old_rec.eiv_attribute6
333: ,p_eiv_attribute7_o
334: => ben_eiv_shd.g_old_rec.eiv_attribute7
335: ,p_eiv_attribute8_o
336: => ben_eiv_shd.g_old_rec.eiv_attribute8
337: ,p_eiv_attribute9_o
338: => ben_eiv_shd.g_old_rec.eiv_attribute9
339: ,p_eiv_attribute10_o
340: => ben_eiv_shd.g_old_rec.eiv_attribute10
334: => ben_eiv_shd.g_old_rec.eiv_attribute7
335: ,p_eiv_attribute8_o
336: => ben_eiv_shd.g_old_rec.eiv_attribute8
337: ,p_eiv_attribute9_o
338: => ben_eiv_shd.g_old_rec.eiv_attribute9
339: ,p_eiv_attribute10_o
340: => ben_eiv_shd.g_old_rec.eiv_attribute10
341: ,p_eiv_attribute11_o
342: => ben_eiv_shd.g_old_rec.eiv_attribute11
336: => ben_eiv_shd.g_old_rec.eiv_attribute8
337: ,p_eiv_attribute9_o
338: => ben_eiv_shd.g_old_rec.eiv_attribute9
339: ,p_eiv_attribute10_o
340: => ben_eiv_shd.g_old_rec.eiv_attribute10
341: ,p_eiv_attribute11_o
342: => ben_eiv_shd.g_old_rec.eiv_attribute11
343: ,p_eiv_attribute12_o
344: => ben_eiv_shd.g_old_rec.eiv_attribute12
338: => ben_eiv_shd.g_old_rec.eiv_attribute9
339: ,p_eiv_attribute10_o
340: => ben_eiv_shd.g_old_rec.eiv_attribute10
341: ,p_eiv_attribute11_o
342: => ben_eiv_shd.g_old_rec.eiv_attribute11
343: ,p_eiv_attribute12_o
344: => ben_eiv_shd.g_old_rec.eiv_attribute12
345: ,p_eiv_attribute13_o
346: => ben_eiv_shd.g_old_rec.eiv_attribute13
340: => ben_eiv_shd.g_old_rec.eiv_attribute10
341: ,p_eiv_attribute11_o
342: => ben_eiv_shd.g_old_rec.eiv_attribute11
343: ,p_eiv_attribute12_o
344: => ben_eiv_shd.g_old_rec.eiv_attribute12
345: ,p_eiv_attribute13_o
346: => ben_eiv_shd.g_old_rec.eiv_attribute13
347: ,p_eiv_attribute14_o
348: => ben_eiv_shd.g_old_rec.eiv_attribute14
342: => ben_eiv_shd.g_old_rec.eiv_attribute11
343: ,p_eiv_attribute12_o
344: => ben_eiv_shd.g_old_rec.eiv_attribute12
345: ,p_eiv_attribute13_o
346: => ben_eiv_shd.g_old_rec.eiv_attribute13
347: ,p_eiv_attribute14_o
348: => ben_eiv_shd.g_old_rec.eiv_attribute14
349: ,p_eiv_attribute15_o
350: => ben_eiv_shd.g_old_rec.eiv_attribute15
344: => ben_eiv_shd.g_old_rec.eiv_attribute12
345: ,p_eiv_attribute13_o
346: => ben_eiv_shd.g_old_rec.eiv_attribute13
347: ,p_eiv_attribute14_o
348: => ben_eiv_shd.g_old_rec.eiv_attribute14
349: ,p_eiv_attribute15_o
350: => ben_eiv_shd.g_old_rec.eiv_attribute15
351: ,p_eiv_attribute16_o
352: => ben_eiv_shd.g_old_rec.eiv_attribute16
346: => ben_eiv_shd.g_old_rec.eiv_attribute13
347: ,p_eiv_attribute14_o
348: => ben_eiv_shd.g_old_rec.eiv_attribute14
349: ,p_eiv_attribute15_o
350: => ben_eiv_shd.g_old_rec.eiv_attribute15
351: ,p_eiv_attribute16_o
352: => ben_eiv_shd.g_old_rec.eiv_attribute16
353: ,p_eiv_attribute17_o
354: => ben_eiv_shd.g_old_rec.eiv_attribute17
348: => ben_eiv_shd.g_old_rec.eiv_attribute14
349: ,p_eiv_attribute15_o
350: => ben_eiv_shd.g_old_rec.eiv_attribute15
351: ,p_eiv_attribute16_o
352: => ben_eiv_shd.g_old_rec.eiv_attribute16
353: ,p_eiv_attribute17_o
354: => ben_eiv_shd.g_old_rec.eiv_attribute17
355: ,p_eiv_attribute18_o
356: => ben_eiv_shd.g_old_rec.eiv_attribute18
350: => ben_eiv_shd.g_old_rec.eiv_attribute15
351: ,p_eiv_attribute16_o
352: => ben_eiv_shd.g_old_rec.eiv_attribute16
353: ,p_eiv_attribute17_o
354: => ben_eiv_shd.g_old_rec.eiv_attribute17
355: ,p_eiv_attribute18_o
356: => ben_eiv_shd.g_old_rec.eiv_attribute18
357: ,p_eiv_attribute19_o
358: => ben_eiv_shd.g_old_rec.eiv_attribute19
352: => ben_eiv_shd.g_old_rec.eiv_attribute16
353: ,p_eiv_attribute17_o
354: => ben_eiv_shd.g_old_rec.eiv_attribute17
355: ,p_eiv_attribute18_o
356: => ben_eiv_shd.g_old_rec.eiv_attribute18
357: ,p_eiv_attribute19_o
358: => ben_eiv_shd.g_old_rec.eiv_attribute19
359: ,p_eiv_attribute20_o
360: => ben_eiv_shd.g_old_rec.eiv_attribute20
354: => ben_eiv_shd.g_old_rec.eiv_attribute17
355: ,p_eiv_attribute18_o
356: => ben_eiv_shd.g_old_rec.eiv_attribute18
357: ,p_eiv_attribute19_o
358: => ben_eiv_shd.g_old_rec.eiv_attribute19
359: ,p_eiv_attribute20_o
360: => ben_eiv_shd.g_old_rec.eiv_attribute20
361: ,p_eiv_attribute21_o
362: => ben_eiv_shd.g_old_rec.eiv_attribute21
356: => ben_eiv_shd.g_old_rec.eiv_attribute18
357: ,p_eiv_attribute19_o
358: => ben_eiv_shd.g_old_rec.eiv_attribute19
359: ,p_eiv_attribute20_o
360: => ben_eiv_shd.g_old_rec.eiv_attribute20
361: ,p_eiv_attribute21_o
362: => ben_eiv_shd.g_old_rec.eiv_attribute21
363: ,p_eiv_attribute22_o
364: => ben_eiv_shd.g_old_rec.eiv_attribute22
358: => ben_eiv_shd.g_old_rec.eiv_attribute19
359: ,p_eiv_attribute20_o
360: => ben_eiv_shd.g_old_rec.eiv_attribute20
361: ,p_eiv_attribute21_o
362: => ben_eiv_shd.g_old_rec.eiv_attribute21
363: ,p_eiv_attribute22_o
364: => ben_eiv_shd.g_old_rec.eiv_attribute22
365: ,p_eiv_attribute23_o
366: => ben_eiv_shd.g_old_rec.eiv_attribute23
360: => ben_eiv_shd.g_old_rec.eiv_attribute20
361: ,p_eiv_attribute21_o
362: => ben_eiv_shd.g_old_rec.eiv_attribute21
363: ,p_eiv_attribute22_o
364: => ben_eiv_shd.g_old_rec.eiv_attribute22
365: ,p_eiv_attribute23_o
366: => ben_eiv_shd.g_old_rec.eiv_attribute23
367: ,p_eiv_attribute24_o
368: => ben_eiv_shd.g_old_rec.eiv_attribute24
362: => ben_eiv_shd.g_old_rec.eiv_attribute21
363: ,p_eiv_attribute22_o
364: => ben_eiv_shd.g_old_rec.eiv_attribute22
365: ,p_eiv_attribute23_o
366: => ben_eiv_shd.g_old_rec.eiv_attribute23
367: ,p_eiv_attribute24_o
368: => ben_eiv_shd.g_old_rec.eiv_attribute24
369: ,p_eiv_attribute25_o
370: => ben_eiv_shd.g_old_rec.eiv_attribute25
364: => ben_eiv_shd.g_old_rec.eiv_attribute22
365: ,p_eiv_attribute23_o
366: => ben_eiv_shd.g_old_rec.eiv_attribute23
367: ,p_eiv_attribute24_o
368: => ben_eiv_shd.g_old_rec.eiv_attribute24
369: ,p_eiv_attribute25_o
370: => ben_eiv_shd.g_old_rec.eiv_attribute25
371: ,p_eiv_attribute26_o
372: => ben_eiv_shd.g_old_rec.eiv_attribute26
366: => ben_eiv_shd.g_old_rec.eiv_attribute23
367: ,p_eiv_attribute24_o
368: => ben_eiv_shd.g_old_rec.eiv_attribute24
369: ,p_eiv_attribute25_o
370: => ben_eiv_shd.g_old_rec.eiv_attribute25
371: ,p_eiv_attribute26_o
372: => ben_eiv_shd.g_old_rec.eiv_attribute26
373: ,p_eiv_attribute27_o
374: => ben_eiv_shd.g_old_rec.eiv_attribute27
368: => ben_eiv_shd.g_old_rec.eiv_attribute24
369: ,p_eiv_attribute25_o
370: => ben_eiv_shd.g_old_rec.eiv_attribute25
371: ,p_eiv_attribute26_o
372: => ben_eiv_shd.g_old_rec.eiv_attribute26
373: ,p_eiv_attribute27_o
374: => ben_eiv_shd.g_old_rec.eiv_attribute27
375: ,p_eiv_attribute28_o
376: => ben_eiv_shd.g_old_rec.eiv_attribute28
370: => ben_eiv_shd.g_old_rec.eiv_attribute25
371: ,p_eiv_attribute26_o
372: => ben_eiv_shd.g_old_rec.eiv_attribute26
373: ,p_eiv_attribute27_o
374: => ben_eiv_shd.g_old_rec.eiv_attribute27
375: ,p_eiv_attribute28_o
376: => ben_eiv_shd.g_old_rec.eiv_attribute28
377: ,p_eiv_attribute29_o
378: => ben_eiv_shd.g_old_rec.eiv_attribute29
372: => ben_eiv_shd.g_old_rec.eiv_attribute26
373: ,p_eiv_attribute27_o
374: => ben_eiv_shd.g_old_rec.eiv_attribute27
375: ,p_eiv_attribute28_o
376: => ben_eiv_shd.g_old_rec.eiv_attribute28
377: ,p_eiv_attribute29_o
378: => ben_eiv_shd.g_old_rec.eiv_attribute29
379: ,p_eiv_attribute30_o
380: => ben_eiv_shd.g_old_rec.eiv_attribute30
374: => ben_eiv_shd.g_old_rec.eiv_attribute27
375: ,p_eiv_attribute28_o
376: => ben_eiv_shd.g_old_rec.eiv_attribute28
377: ,p_eiv_attribute29_o
378: => ben_eiv_shd.g_old_rec.eiv_attribute29
379: ,p_eiv_attribute30_o
380: => ben_eiv_shd.g_old_rec.eiv_attribute30
381: ,p_object_version_number_o
382: => ben_eiv_shd.g_old_rec.object_version_number
376: => ben_eiv_shd.g_old_rec.eiv_attribute28
377: ,p_eiv_attribute29_o
378: => ben_eiv_shd.g_old_rec.eiv_attribute29
379: ,p_eiv_attribute30_o
380: => ben_eiv_shd.g_old_rec.eiv_attribute30
381: ,p_object_version_number_o
382: => ben_eiv_shd.g_old_rec.object_version_number
383: );
384: --
378: => ben_eiv_shd.g_old_rec.eiv_attribute29
379: ,p_eiv_attribute30_o
380: => ben_eiv_shd.g_old_rec.eiv_attribute30
381: ,p_object_version_number_o
382: => ben_eiv_shd.g_old_rec.object_version_number
383: );
384: --
385: exception
386: --
438: --
439: -- {End Of Comments}
440: -- ----------------------------------------------------------------------------
441: Procedure convert_defs
442: (p_rec in out nocopy ben_eiv_shd.g_rec_type
443: ) is
444: --
445: Begin
446: --
450: -- is being used then we must set to the 'current' argument value.
451: --
452: If (p_rec.acty_base_rt_id = hr_api.g_number) then
453: p_rec.acty_base_rt_id :=
454: ben_eiv_shd.g_old_rec.acty_base_rt_id;
455: End If;
456: If (p_rec.input_value_id = hr_api.g_number) then
457: p_rec.input_value_id :=
458: ben_eiv_shd.g_old_rec.input_value_id;
454: ben_eiv_shd.g_old_rec.acty_base_rt_id;
455: End If;
456: If (p_rec.input_value_id = hr_api.g_number) then
457: p_rec.input_value_id :=
458: ben_eiv_shd.g_old_rec.input_value_id;
459: End If;
460: If (p_rec.input_text = hr_api.g_varchar2) then
461: p_rec.input_text :=
462: ben_eiv_shd.g_old_rec.input_text;
458: ben_eiv_shd.g_old_rec.input_value_id;
459: End If;
460: If (p_rec.input_text = hr_api.g_varchar2) then
461: p_rec.input_text :=
462: ben_eiv_shd.g_old_rec.input_text;
463: End If;
464: If (p_rec.upd_when_ele_ended_cd = hr_api.g_varchar2) then
465: p_rec.upd_when_ele_ended_cd :=
466: ben_eiv_shd.g_old_rec.upd_when_ele_ended_cd;
462: ben_eiv_shd.g_old_rec.input_text;
463: End If;
464: If (p_rec.upd_when_ele_ended_cd = hr_api.g_varchar2) then
465: p_rec.upd_when_ele_ended_cd :=
466: ben_eiv_shd.g_old_rec.upd_when_ele_ended_cd;
467: End If;
468: If (p_rec.return_var_name = hr_api.g_varchar2) then
469: p_rec.return_var_name :=
470: ben_eiv_shd.g_old_rec.return_var_name;
466: ben_eiv_shd.g_old_rec.upd_when_ele_ended_cd;
467: End If;
468: If (p_rec.return_var_name = hr_api.g_varchar2) then
469: p_rec.return_var_name :=
470: ben_eiv_shd.g_old_rec.return_var_name;
471: End If;
472: If (p_rec.business_group_id = hr_api.g_number) then
473: p_rec.business_group_id :=
474: ben_eiv_shd.g_old_rec.business_group_id;
470: ben_eiv_shd.g_old_rec.return_var_name;
471: End If;
472: If (p_rec.business_group_id = hr_api.g_number) then
473: p_rec.business_group_id :=
474: ben_eiv_shd.g_old_rec.business_group_id;
475: End If;
476: If (p_rec.eiv_attribute_category = hr_api.g_varchar2) then
477: p_rec.eiv_attribute_category :=
478: ben_eiv_shd.g_old_rec.eiv_attribute_category;
474: ben_eiv_shd.g_old_rec.business_group_id;
475: End If;
476: If (p_rec.eiv_attribute_category = hr_api.g_varchar2) then
477: p_rec.eiv_attribute_category :=
478: ben_eiv_shd.g_old_rec.eiv_attribute_category;
479: End If;
480: If (p_rec.eiv_attribute1 = hr_api.g_varchar2) then
481: p_rec.eiv_attribute1 :=
482: ben_eiv_shd.g_old_rec.eiv_attribute1;
478: ben_eiv_shd.g_old_rec.eiv_attribute_category;
479: End If;
480: If (p_rec.eiv_attribute1 = hr_api.g_varchar2) then
481: p_rec.eiv_attribute1 :=
482: ben_eiv_shd.g_old_rec.eiv_attribute1;
483: End If;
484: If (p_rec.eiv_attribute2 = hr_api.g_varchar2) then
485: p_rec.eiv_attribute2 :=
486: ben_eiv_shd.g_old_rec.eiv_attribute2;
482: ben_eiv_shd.g_old_rec.eiv_attribute1;
483: End If;
484: If (p_rec.eiv_attribute2 = hr_api.g_varchar2) then
485: p_rec.eiv_attribute2 :=
486: ben_eiv_shd.g_old_rec.eiv_attribute2;
487: End If;
488: If (p_rec.eiv_attribute3 = hr_api.g_varchar2) then
489: p_rec.eiv_attribute3 :=
490: ben_eiv_shd.g_old_rec.eiv_attribute3;
486: ben_eiv_shd.g_old_rec.eiv_attribute2;
487: End If;
488: If (p_rec.eiv_attribute3 = hr_api.g_varchar2) then
489: p_rec.eiv_attribute3 :=
490: ben_eiv_shd.g_old_rec.eiv_attribute3;
491: End If;
492: If (p_rec.eiv_attribute4 = hr_api.g_varchar2) then
493: p_rec.eiv_attribute4 :=
494: ben_eiv_shd.g_old_rec.eiv_attribute4;
490: ben_eiv_shd.g_old_rec.eiv_attribute3;
491: End If;
492: If (p_rec.eiv_attribute4 = hr_api.g_varchar2) then
493: p_rec.eiv_attribute4 :=
494: ben_eiv_shd.g_old_rec.eiv_attribute4;
495: End If;
496: If (p_rec.eiv_attribute5 = hr_api.g_varchar2) then
497: p_rec.eiv_attribute5 :=
498: ben_eiv_shd.g_old_rec.eiv_attribute5;
494: ben_eiv_shd.g_old_rec.eiv_attribute4;
495: End If;
496: If (p_rec.eiv_attribute5 = hr_api.g_varchar2) then
497: p_rec.eiv_attribute5 :=
498: ben_eiv_shd.g_old_rec.eiv_attribute5;
499: End If;
500: If (p_rec.eiv_attribute6 = hr_api.g_varchar2) then
501: p_rec.eiv_attribute6 :=
502: ben_eiv_shd.g_old_rec.eiv_attribute6;
498: ben_eiv_shd.g_old_rec.eiv_attribute5;
499: End If;
500: If (p_rec.eiv_attribute6 = hr_api.g_varchar2) then
501: p_rec.eiv_attribute6 :=
502: ben_eiv_shd.g_old_rec.eiv_attribute6;
503: End If;
504: If (p_rec.eiv_attribute7 = hr_api.g_varchar2) then
505: p_rec.eiv_attribute7 :=
506: ben_eiv_shd.g_old_rec.eiv_attribute7;
502: ben_eiv_shd.g_old_rec.eiv_attribute6;
503: End If;
504: If (p_rec.eiv_attribute7 = hr_api.g_varchar2) then
505: p_rec.eiv_attribute7 :=
506: ben_eiv_shd.g_old_rec.eiv_attribute7;
507: End If;
508: If (p_rec.eiv_attribute8 = hr_api.g_varchar2) then
509: p_rec.eiv_attribute8 :=
510: ben_eiv_shd.g_old_rec.eiv_attribute8;
506: ben_eiv_shd.g_old_rec.eiv_attribute7;
507: End If;
508: If (p_rec.eiv_attribute8 = hr_api.g_varchar2) then
509: p_rec.eiv_attribute8 :=
510: ben_eiv_shd.g_old_rec.eiv_attribute8;
511: End If;
512: If (p_rec.eiv_attribute9 = hr_api.g_varchar2) then
513: p_rec.eiv_attribute9 :=
514: ben_eiv_shd.g_old_rec.eiv_attribute9;
510: ben_eiv_shd.g_old_rec.eiv_attribute8;
511: End If;
512: If (p_rec.eiv_attribute9 = hr_api.g_varchar2) then
513: p_rec.eiv_attribute9 :=
514: ben_eiv_shd.g_old_rec.eiv_attribute9;
515: End If;
516: If (p_rec.eiv_attribute10 = hr_api.g_varchar2) then
517: p_rec.eiv_attribute10 :=
518: ben_eiv_shd.g_old_rec.eiv_attribute10;
514: ben_eiv_shd.g_old_rec.eiv_attribute9;
515: End If;
516: If (p_rec.eiv_attribute10 = hr_api.g_varchar2) then
517: p_rec.eiv_attribute10 :=
518: ben_eiv_shd.g_old_rec.eiv_attribute10;
519: End If;
520: If (p_rec.eiv_attribute11 = hr_api.g_varchar2) then
521: p_rec.eiv_attribute11 :=
522: ben_eiv_shd.g_old_rec.eiv_attribute11;
518: ben_eiv_shd.g_old_rec.eiv_attribute10;
519: End If;
520: If (p_rec.eiv_attribute11 = hr_api.g_varchar2) then
521: p_rec.eiv_attribute11 :=
522: ben_eiv_shd.g_old_rec.eiv_attribute11;
523: End If;
524: If (p_rec.eiv_attribute12 = hr_api.g_varchar2) then
525: p_rec.eiv_attribute12 :=
526: ben_eiv_shd.g_old_rec.eiv_attribute12;
522: ben_eiv_shd.g_old_rec.eiv_attribute11;
523: End If;
524: If (p_rec.eiv_attribute12 = hr_api.g_varchar2) then
525: p_rec.eiv_attribute12 :=
526: ben_eiv_shd.g_old_rec.eiv_attribute12;
527: End If;
528: If (p_rec.eiv_attribute13 = hr_api.g_varchar2) then
529: p_rec.eiv_attribute13 :=
530: ben_eiv_shd.g_old_rec.eiv_attribute13;
526: ben_eiv_shd.g_old_rec.eiv_attribute12;
527: End If;
528: If (p_rec.eiv_attribute13 = hr_api.g_varchar2) then
529: p_rec.eiv_attribute13 :=
530: ben_eiv_shd.g_old_rec.eiv_attribute13;
531: End If;
532: If (p_rec.eiv_attribute14 = hr_api.g_varchar2) then
533: p_rec.eiv_attribute14 :=
534: ben_eiv_shd.g_old_rec.eiv_attribute14;
530: ben_eiv_shd.g_old_rec.eiv_attribute13;
531: End If;
532: If (p_rec.eiv_attribute14 = hr_api.g_varchar2) then
533: p_rec.eiv_attribute14 :=
534: ben_eiv_shd.g_old_rec.eiv_attribute14;
535: End If;
536: If (p_rec.eiv_attribute15 = hr_api.g_varchar2) then
537: p_rec.eiv_attribute15 :=
538: ben_eiv_shd.g_old_rec.eiv_attribute15;
534: ben_eiv_shd.g_old_rec.eiv_attribute14;
535: End If;
536: If (p_rec.eiv_attribute15 = hr_api.g_varchar2) then
537: p_rec.eiv_attribute15 :=
538: ben_eiv_shd.g_old_rec.eiv_attribute15;
539: End If;
540: If (p_rec.eiv_attribute16 = hr_api.g_varchar2) then
541: p_rec.eiv_attribute16 :=
542: ben_eiv_shd.g_old_rec.eiv_attribute16;
538: ben_eiv_shd.g_old_rec.eiv_attribute15;
539: End If;
540: If (p_rec.eiv_attribute16 = hr_api.g_varchar2) then
541: p_rec.eiv_attribute16 :=
542: ben_eiv_shd.g_old_rec.eiv_attribute16;
543: End If;
544: If (p_rec.eiv_attribute17 = hr_api.g_varchar2) then
545: p_rec.eiv_attribute17 :=
546: ben_eiv_shd.g_old_rec.eiv_attribute17;
542: ben_eiv_shd.g_old_rec.eiv_attribute16;
543: End If;
544: If (p_rec.eiv_attribute17 = hr_api.g_varchar2) then
545: p_rec.eiv_attribute17 :=
546: ben_eiv_shd.g_old_rec.eiv_attribute17;
547: End If;
548: If (p_rec.eiv_attribute18 = hr_api.g_varchar2) then
549: p_rec.eiv_attribute18 :=
550: ben_eiv_shd.g_old_rec.eiv_attribute18;
546: ben_eiv_shd.g_old_rec.eiv_attribute17;
547: End If;
548: If (p_rec.eiv_attribute18 = hr_api.g_varchar2) then
549: p_rec.eiv_attribute18 :=
550: ben_eiv_shd.g_old_rec.eiv_attribute18;
551: End If;
552: If (p_rec.eiv_attribute19 = hr_api.g_varchar2) then
553: p_rec.eiv_attribute19 :=
554: ben_eiv_shd.g_old_rec.eiv_attribute19;
550: ben_eiv_shd.g_old_rec.eiv_attribute18;
551: End If;
552: If (p_rec.eiv_attribute19 = hr_api.g_varchar2) then
553: p_rec.eiv_attribute19 :=
554: ben_eiv_shd.g_old_rec.eiv_attribute19;
555: End If;
556: If (p_rec.eiv_attribute20 = hr_api.g_varchar2) then
557: p_rec.eiv_attribute20 :=
558: ben_eiv_shd.g_old_rec.eiv_attribute20;
554: ben_eiv_shd.g_old_rec.eiv_attribute19;
555: End If;
556: If (p_rec.eiv_attribute20 = hr_api.g_varchar2) then
557: p_rec.eiv_attribute20 :=
558: ben_eiv_shd.g_old_rec.eiv_attribute20;
559: End If;
560: If (p_rec.eiv_attribute21 = hr_api.g_varchar2) then
561: p_rec.eiv_attribute21 :=
562: ben_eiv_shd.g_old_rec.eiv_attribute21;
558: ben_eiv_shd.g_old_rec.eiv_attribute20;
559: End If;
560: If (p_rec.eiv_attribute21 = hr_api.g_varchar2) then
561: p_rec.eiv_attribute21 :=
562: ben_eiv_shd.g_old_rec.eiv_attribute21;
563: End If;
564: If (p_rec.eiv_attribute22 = hr_api.g_varchar2) then
565: p_rec.eiv_attribute22 :=
566: ben_eiv_shd.g_old_rec.eiv_attribute22;
562: ben_eiv_shd.g_old_rec.eiv_attribute21;
563: End If;
564: If (p_rec.eiv_attribute22 = hr_api.g_varchar2) then
565: p_rec.eiv_attribute22 :=
566: ben_eiv_shd.g_old_rec.eiv_attribute22;
567: End If;
568: If (p_rec.eiv_attribute23 = hr_api.g_varchar2) then
569: p_rec.eiv_attribute23 :=
570: ben_eiv_shd.g_old_rec.eiv_attribute23;
566: ben_eiv_shd.g_old_rec.eiv_attribute22;
567: End If;
568: If (p_rec.eiv_attribute23 = hr_api.g_varchar2) then
569: p_rec.eiv_attribute23 :=
570: ben_eiv_shd.g_old_rec.eiv_attribute23;
571: End If;
572: If (p_rec.eiv_attribute24 = hr_api.g_varchar2) then
573: p_rec.eiv_attribute24 :=
574: ben_eiv_shd.g_old_rec.eiv_attribute24;
570: ben_eiv_shd.g_old_rec.eiv_attribute23;
571: End If;
572: If (p_rec.eiv_attribute24 = hr_api.g_varchar2) then
573: p_rec.eiv_attribute24 :=
574: ben_eiv_shd.g_old_rec.eiv_attribute24;
575: End If;
576: If (p_rec.eiv_attribute25 = hr_api.g_varchar2) then
577: p_rec.eiv_attribute25 :=
578: ben_eiv_shd.g_old_rec.eiv_attribute25;
574: ben_eiv_shd.g_old_rec.eiv_attribute24;
575: End If;
576: If (p_rec.eiv_attribute25 = hr_api.g_varchar2) then
577: p_rec.eiv_attribute25 :=
578: ben_eiv_shd.g_old_rec.eiv_attribute25;
579: End If;
580: If (p_rec.eiv_attribute26 = hr_api.g_varchar2) then
581: p_rec.eiv_attribute26 :=
582: ben_eiv_shd.g_old_rec.eiv_attribute26;
578: ben_eiv_shd.g_old_rec.eiv_attribute25;
579: End If;
580: If (p_rec.eiv_attribute26 = hr_api.g_varchar2) then
581: p_rec.eiv_attribute26 :=
582: ben_eiv_shd.g_old_rec.eiv_attribute26;
583: End If;
584: If (p_rec.eiv_attribute27 = hr_api.g_varchar2) then
585: p_rec.eiv_attribute27 :=
586: ben_eiv_shd.g_old_rec.eiv_attribute27;
582: ben_eiv_shd.g_old_rec.eiv_attribute26;
583: End If;
584: If (p_rec.eiv_attribute27 = hr_api.g_varchar2) then
585: p_rec.eiv_attribute27 :=
586: ben_eiv_shd.g_old_rec.eiv_attribute27;
587: End If;
588: If (p_rec.eiv_attribute28 = hr_api.g_varchar2) then
589: p_rec.eiv_attribute28 :=
590: ben_eiv_shd.g_old_rec.eiv_attribute28;
586: ben_eiv_shd.g_old_rec.eiv_attribute27;
587: End If;
588: If (p_rec.eiv_attribute28 = hr_api.g_varchar2) then
589: p_rec.eiv_attribute28 :=
590: ben_eiv_shd.g_old_rec.eiv_attribute28;
591: End If;
592: If (p_rec.eiv_attribute29 = hr_api.g_varchar2) then
593: p_rec.eiv_attribute29 :=
594: ben_eiv_shd.g_old_rec.eiv_attribute29;
590: ben_eiv_shd.g_old_rec.eiv_attribute28;
591: End If;
592: If (p_rec.eiv_attribute29 = hr_api.g_varchar2) then
593: p_rec.eiv_attribute29 :=
594: ben_eiv_shd.g_old_rec.eiv_attribute29;
595: End If;
596: If (p_rec.eiv_attribute30 = hr_api.g_varchar2) then
597: p_rec.eiv_attribute30 :=
598: ben_eiv_shd.g_old_rec.eiv_attribute30;
594: ben_eiv_shd.g_old_rec.eiv_attribute29;
595: End If;
596: If (p_rec.eiv_attribute30 = hr_api.g_varchar2) then
597: p_rec.eiv_attribute30 :=
598: ben_eiv_shd.g_old_rec.eiv_attribute30;
599: End If;
600: --
601: End convert_defs;
602: --
604: -- |---------------------------------< upd >----------------------------------|
605: -- ----------------------------------------------------------------------------
606: Procedure upd
607: (p_effective_date in date
608: ,p_rec in out nocopy ben_eiv_shd.g_rec_type
609: ) is
610: --
611: l_proc varchar2(72) := g_package||'upd';
612: --
614: hr_utility.set_location('Entering:'||l_proc, 5);
615: --
616: -- We must lock the row which we need to update.
617: --
618: ben_eiv_shd.lck
619: (p_rec.extra_input_value_id
620: ,p_rec.object_version_number
621: );
622: --
695: ,p_eiv_attribute29 in varchar2 default hr_api.g_varchar2
696: ,p_eiv_attribute30 in varchar2 default hr_api.g_varchar2
697: ) is
698: --
699: l_rec ben_eiv_shd.g_rec_type;
700: l_proc varchar2(72) := g_package||'upd';
701: --
702: Begin
703: hr_utility.set_location('Entering:'||l_proc, 5);
705: -- Call conversion function to turn arguments into the
706: -- l_rec structure.
707: --
708: l_rec :=
709: ben_eiv_shd.convert_args
710: (p_extra_input_value_id
711: ,p_acty_base_rt_id
712: ,p_input_value_id
713: ,p_input_text