50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_xcl_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: ben_xcl_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_ext_chg_evt_log Row
68: --
69: update ben_ext_chg_evt_log
86: business_group_id = p_rec.business_group_id,
87: object_version_number = p_rec.object_version_number
88: where ext_chg_evt_log_id = p_rec.ext_chg_evt_log_id;
89: --
90: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: --
94: Exception
93: --
94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
98: ben_xcl_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
98: ben_xcl_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
98: ben_xcl_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
103: ben_xcl_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
103: ben_xcl_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
103: ben_xcl_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
108: ben_xcl_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
108: ben_xcl_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;
107: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
108: ben_xcl_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;
113: End update_dml;
114: --
115: -- ----------------------------------------------------------------------------
143: -- Internal Row Handler Use Only.
144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure pre_update(p_rec in ben_xcl_shd.g_rec_type) is
148: --
149: l_proc varchar2(72) := g_package||'pre_update';
150: --
151: Begin
186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure post_update(
190: p_effective_date in date,p_rec in ben_xcl_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_update';
193: --
194: Begin
218: ,p_person_id =>p_rec.person_id
219: ,p_business_group_id =>p_rec.business_group_id
220: ,p_object_version_number =>p_rec.object_version_number
221: ,p_effective_date =>p_effective_date
222: ,p_chg_evt_cd_o =>ben_xcl_shd.g_old_rec.chg_evt_cd
223: ,p_chg_eff_dt_o =>ben_xcl_shd.g_old_rec.chg_eff_dt
224: ,p_chg_user_id_o =>ben_xcl_shd.g_old_rec.chg_user_id
225: ,p_prmtr_01_o =>ben_xcl_shd.g_old_rec.prmtr_01
226: ,p_prmtr_02_o =>ben_xcl_shd.g_old_rec.prmtr_02
219: ,p_business_group_id =>p_rec.business_group_id
220: ,p_object_version_number =>p_rec.object_version_number
221: ,p_effective_date =>p_effective_date
222: ,p_chg_evt_cd_o =>ben_xcl_shd.g_old_rec.chg_evt_cd
223: ,p_chg_eff_dt_o =>ben_xcl_shd.g_old_rec.chg_eff_dt
224: ,p_chg_user_id_o =>ben_xcl_shd.g_old_rec.chg_user_id
225: ,p_prmtr_01_o =>ben_xcl_shd.g_old_rec.prmtr_01
226: ,p_prmtr_02_o =>ben_xcl_shd.g_old_rec.prmtr_02
227: ,p_prmtr_03_o =>ben_xcl_shd.g_old_rec.prmtr_03
220: ,p_object_version_number =>p_rec.object_version_number
221: ,p_effective_date =>p_effective_date
222: ,p_chg_evt_cd_o =>ben_xcl_shd.g_old_rec.chg_evt_cd
223: ,p_chg_eff_dt_o =>ben_xcl_shd.g_old_rec.chg_eff_dt
224: ,p_chg_user_id_o =>ben_xcl_shd.g_old_rec.chg_user_id
225: ,p_prmtr_01_o =>ben_xcl_shd.g_old_rec.prmtr_01
226: ,p_prmtr_02_o =>ben_xcl_shd.g_old_rec.prmtr_02
227: ,p_prmtr_03_o =>ben_xcl_shd.g_old_rec.prmtr_03
228: ,p_prmtr_04_o =>ben_xcl_shd.g_old_rec.prmtr_04
221: ,p_effective_date =>p_effective_date
222: ,p_chg_evt_cd_o =>ben_xcl_shd.g_old_rec.chg_evt_cd
223: ,p_chg_eff_dt_o =>ben_xcl_shd.g_old_rec.chg_eff_dt
224: ,p_chg_user_id_o =>ben_xcl_shd.g_old_rec.chg_user_id
225: ,p_prmtr_01_o =>ben_xcl_shd.g_old_rec.prmtr_01
226: ,p_prmtr_02_o =>ben_xcl_shd.g_old_rec.prmtr_02
227: ,p_prmtr_03_o =>ben_xcl_shd.g_old_rec.prmtr_03
228: ,p_prmtr_04_o =>ben_xcl_shd.g_old_rec.prmtr_04
229: ,p_prmtr_05_o =>ben_xcl_shd.g_old_rec.prmtr_05
222: ,p_chg_evt_cd_o =>ben_xcl_shd.g_old_rec.chg_evt_cd
223: ,p_chg_eff_dt_o =>ben_xcl_shd.g_old_rec.chg_eff_dt
224: ,p_chg_user_id_o =>ben_xcl_shd.g_old_rec.chg_user_id
225: ,p_prmtr_01_o =>ben_xcl_shd.g_old_rec.prmtr_01
226: ,p_prmtr_02_o =>ben_xcl_shd.g_old_rec.prmtr_02
227: ,p_prmtr_03_o =>ben_xcl_shd.g_old_rec.prmtr_03
228: ,p_prmtr_04_o =>ben_xcl_shd.g_old_rec.prmtr_04
229: ,p_prmtr_05_o =>ben_xcl_shd.g_old_rec.prmtr_05
230: ,p_prmtr_06_o =>ben_xcl_shd.g_old_rec.prmtr_06
223: ,p_chg_eff_dt_o =>ben_xcl_shd.g_old_rec.chg_eff_dt
224: ,p_chg_user_id_o =>ben_xcl_shd.g_old_rec.chg_user_id
225: ,p_prmtr_01_o =>ben_xcl_shd.g_old_rec.prmtr_01
226: ,p_prmtr_02_o =>ben_xcl_shd.g_old_rec.prmtr_02
227: ,p_prmtr_03_o =>ben_xcl_shd.g_old_rec.prmtr_03
228: ,p_prmtr_04_o =>ben_xcl_shd.g_old_rec.prmtr_04
229: ,p_prmtr_05_o =>ben_xcl_shd.g_old_rec.prmtr_05
230: ,p_prmtr_06_o =>ben_xcl_shd.g_old_rec.prmtr_06
231: ,p_prmtr_07_o =>ben_xcl_shd.g_old_rec.prmtr_07
224: ,p_chg_user_id_o =>ben_xcl_shd.g_old_rec.chg_user_id
225: ,p_prmtr_01_o =>ben_xcl_shd.g_old_rec.prmtr_01
226: ,p_prmtr_02_o =>ben_xcl_shd.g_old_rec.prmtr_02
227: ,p_prmtr_03_o =>ben_xcl_shd.g_old_rec.prmtr_03
228: ,p_prmtr_04_o =>ben_xcl_shd.g_old_rec.prmtr_04
229: ,p_prmtr_05_o =>ben_xcl_shd.g_old_rec.prmtr_05
230: ,p_prmtr_06_o =>ben_xcl_shd.g_old_rec.prmtr_06
231: ,p_prmtr_07_o =>ben_xcl_shd.g_old_rec.prmtr_07
232: ,p_prmtr_08_o =>ben_xcl_shd.g_old_rec.prmtr_08
225: ,p_prmtr_01_o =>ben_xcl_shd.g_old_rec.prmtr_01
226: ,p_prmtr_02_o =>ben_xcl_shd.g_old_rec.prmtr_02
227: ,p_prmtr_03_o =>ben_xcl_shd.g_old_rec.prmtr_03
228: ,p_prmtr_04_o =>ben_xcl_shd.g_old_rec.prmtr_04
229: ,p_prmtr_05_o =>ben_xcl_shd.g_old_rec.prmtr_05
230: ,p_prmtr_06_o =>ben_xcl_shd.g_old_rec.prmtr_06
231: ,p_prmtr_07_o =>ben_xcl_shd.g_old_rec.prmtr_07
232: ,p_prmtr_08_o =>ben_xcl_shd.g_old_rec.prmtr_08
233: ,p_prmtr_09_o =>ben_xcl_shd.g_old_rec.prmtr_09
226: ,p_prmtr_02_o =>ben_xcl_shd.g_old_rec.prmtr_02
227: ,p_prmtr_03_o =>ben_xcl_shd.g_old_rec.prmtr_03
228: ,p_prmtr_04_o =>ben_xcl_shd.g_old_rec.prmtr_04
229: ,p_prmtr_05_o =>ben_xcl_shd.g_old_rec.prmtr_05
230: ,p_prmtr_06_o =>ben_xcl_shd.g_old_rec.prmtr_06
231: ,p_prmtr_07_o =>ben_xcl_shd.g_old_rec.prmtr_07
232: ,p_prmtr_08_o =>ben_xcl_shd.g_old_rec.prmtr_08
233: ,p_prmtr_09_o =>ben_xcl_shd.g_old_rec.prmtr_09
234: ,p_prmtr_10_o =>ben_xcl_shd.g_old_rec.prmtr_10
227: ,p_prmtr_03_o =>ben_xcl_shd.g_old_rec.prmtr_03
228: ,p_prmtr_04_o =>ben_xcl_shd.g_old_rec.prmtr_04
229: ,p_prmtr_05_o =>ben_xcl_shd.g_old_rec.prmtr_05
230: ,p_prmtr_06_o =>ben_xcl_shd.g_old_rec.prmtr_06
231: ,p_prmtr_07_o =>ben_xcl_shd.g_old_rec.prmtr_07
232: ,p_prmtr_08_o =>ben_xcl_shd.g_old_rec.prmtr_08
233: ,p_prmtr_09_o =>ben_xcl_shd.g_old_rec.prmtr_09
234: ,p_prmtr_10_o =>ben_xcl_shd.g_old_rec.prmtr_10
235: ,p_person_id_o =>ben_xcl_shd.g_old_rec.person_id
228: ,p_prmtr_04_o =>ben_xcl_shd.g_old_rec.prmtr_04
229: ,p_prmtr_05_o =>ben_xcl_shd.g_old_rec.prmtr_05
230: ,p_prmtr_06_o =>ben_xcl_shd.g_old_rec.prmtr_06
231: ,p_prmtr_07_o =>ben_xcl_shd.g_old_rec.prmtr_07
232: ,p_prmtr_08_o =>ben_xcl_shd.g_old_rec.prmtr_08
233: ,p_prmtr_09_o =>ben_xcl_shd.g_old_rec.prmtr_09
234: ,p_prmtr_10_o =>ben_xcl_shd.g_old_rec.prmtr_10
235: ,p_person_id_o =>ben_xcl_shd.g_old_rec.person_id
236: ,p_business_group_id_o =>ben_xcl_shd.g_old_rec.business_group_id
229: ,p_prmtr_05_o =>ben_xcl_shd.g_old_rec.prmtr_05
230: ,p_prmtr_06_o =>ben_xcl_shd.g_old_rec.prmtr_06
231: ,p_prmtr_07_o =>ben_xcl_shd.g_old_rec.prmtr_07
232: ,p_prmtr_08_o =>ben_xcl_shd.g_old_rec.prmtr_08
233: ,p_prmtr_09_o =>ben_xcl_shd.g_old_rec.prmtr_09
234: ,p_prmtr_10_o =>ben_xcl_shd.g_old_rec.prmtr_10
235: ,p_person_id_o =>ben_xcl_shd.g_old_rec.person_id
236: ,p_business_group_id_o =>ben_xcl_shd.g_old_rec.business_group_id
237: ,p_object_version_number_o =>ben_xcl_shd.g_old_rec.object_version_number
230: ,p_prmtr_06_o =>ben_xcl_shd.g_old_rec.prmtr_06
231: ,p_prmtr_07_o =>ben_xcl_shd.g_old_rec.prmtr_07
232: ,p_prmtr_08_o =>ben_xcl_shd.g_old_rec.prmtr_08
233: ,p_prmtr_09_o =>ben_xcl_shd.g_old_rec.prmtr_09
234: ,p_prmtr_10_o =>ben_xcl_shd.g_old_rec.prmtr_10
235: ,p_person_id_o =>ben_xcl_shd.g_old_rec.person_id
236: ,p_business_group_id_o =>ben_xcl_shd.g_old_rec.business_group_id
237: ,p_object_version_number_o =>ben_xcl_shd.g_old_rec.object_version_number
238: );
231: ,p_prmtr_07_o =>ben_xcl_shd.g_old_rec.prmtr_07
232: ,p_prmtr_08_o =>ben_xcl_shd.g_old_rec.prmtr_08
233: ,p_prmtr_09_o =>ben_xcl_shd.g_old_rec.prmtr_09
234: ,p_prmtr_10_o =>ben_xcl_shd.g_old_rec.prmtr_10
235: ,p_person_id_o =>ben_xcl_shd.g_old_rec.person_id
236: ,p_business_group_id_o =>ben_xcl_shd.g_old_rec.business_group_id
237: ,p_object_version_number_o =>ben_xcl_shd.g_old_rec.object_version_number
238: );
239: --
232: ,p_prmtr_08_o =>ben_xcl_shd.g_old_rec.prmtr_08
233: ,p_prmtr_09_o =>ben_xcl_shd.g_old_rec.prmtr_09
234: ,p_prmtr_10_o =>ben_xcl_shd.g_old_rec.prmtr_10
235: ,p_person_id_o =>ben_xcl_shd.g_old_rec.person_id
236: ,p_business_group_id_o =>ben_xcl_shd.g_old_rec.business_group_id
237: ,p_object_version_number_o =>ben_xcl_shd.g_old_rec.object_version_number
238: );
239: --
240: exception
233: ,p_prmtr_09_o =>ben_xcl_shd.g_old_rec.prmtr_09
234: ,p_prmtr_10_o =>ben_xcl_shd.g_old_rec.prmtr_10
235: ,p_person_id_o =>ben_xcl_shd.g_old_rec.person_id
236: ,p_business_group_id_o =>ben_xcl_shd.g_old_rec.business_group_id
237: ,p_object_version_number_o =>ben_xcl_shd.g_old_rec.object_version_number
238: );
239: --
240: exception
241: --
295: -- Internal Row Handler Use Only.
296: --
297: -- {End Of Comments}
298: -- ----------------------------------------------------------------------------
299: Procedure convert_defs(p_rec in out nocopy ben_xcl_shd.g_rec_type) is
300: --
301: l_proc varchar2(72) := g_package||'convert_defs';
302: --
303: Begin
310: -- is being used then we must set to the 'current' argument value.
311: --
312: If (p_rec.chg_evt_cd = hr_api.g_varchar2) then
313: p_rec.chg_evt_cd :=
314: ben_xcl_shd.g_old_rec.chg_evt_cd;
315: End If;
316: If (p_rec.chg_eff_dt = hr_api.g_date) then
317: p_rec.chg_eff_dt :=
318: ben_xcl_shd.g_old_rec.chg_eff_dt;
314: ben_xcl_shd.g_old_rec.chg_evt_cd;
315: End If;
316: If (p_rec.chg_eff_dt = hr_api.g_date) then
317: p_rec.chg_eff_dt :=
318: ben_xcl_shd.g_old_rec.chg_eff_dt;
319: End If;
320: If (p_rec.chg_user_id = hr_api.g_number) then
321: p_rec.chg_user_id :=
322: ben_xcl_shd.g_old_rec.chg_user_id;
318: ben_xcl_shd.g_old_rec.chg_eff_dt;
319: End If;
320: If (p_rec.chg_user_id = hr_api.g_number) then
321: p_rec.chg_user_id :=
322: ben_xcl_shd.g_old_rec.chg_user_id;
323: End If;
324: If (p_rec.prmtr_01 = hr_api.g_varchar2) then
325: p_rec.prmtr_01 :=
326: ben_xcl_shd.g_old_rec.prmtr_01;
322: ben_xcl_shd.g_old_rec.chg_user_id;
323: End If;
324: If (p_rec.prmtr_01 = hr_api.g_varchar2) then
325: p_rec.prmtr_01 :=
326: ben_xcl_shd.g_old_rec.prmtr_01;
327: End If;
328: If (p_rec.prmtr_02 = hr_api.g_varchar2) then
329: p_rec.prmtr_02 :=
330: ben_xcl_shd.g_old_rec.prmtr_02;
326: ben_xcl_shd.g_old_rec.prmtr_01;
327: End If;
328: If (p_rec.prmtr_02 = hr_api.g_varchar2) then
329: p_rec.prmtr_02 :=
330: ben_xcl_shd.g_old_rec.prmtr_02;
331: End If;
332: If (p_rec.prmtr_03 = hr_api.g_varchar2) then
333: p_rec.prmtr_03 :=
334: ben_xcl_shd.g_old_rec.prmtr_03;
330: ben_xcl_shd.g_old_rec.prmtr_02;
331: End If;
332: If (p_rec.prmtr_03 = hr_api.g_varchar2) then
333: p_rec.prmtr_03 :=
334: ben_xcl_shd.g_old_rec.prmtr_03;
335: End If;
336: If (p_rec.prmtr_04 = hr_api.g_varchar2) then
337: p_rec.prmtr_04 :=
338: ben_xcl_shd.g_old_rec.prmtr_04;
334: ben_xcl_shd.g_old_rec.prmtr_03;
335: End If;
336: If (p_rec.prmtr_04 = hr_api.g_varchar2) then
337: p_rec.prmtr_04 :=
338: ben_xcl_shd.g_old_rec.prmtr_04;
339: End If;
340: If (p_rec.prmtr_05 = hr_api.g_varchar2) then
341: p_rec.prmtr_05 :=
342: ben_xcl_shd.g_old_rec.prmtr_05;
338: ben_xcl_shd.g_old_rec.prmtr_04;
339: End If;
340: If (p_rec.prmtr_05 = hr_api.g_varchar2) then
341: p_rec.prmtr_05 :=
342: ben_xcl_shd.g_old_rec.prmtr_05;
343: End If;
344: If (p_rec.prmtr_06 = hr_api.g_varchar2) then
345: p_rec.prmtr_06 :=
346: ben_xcl_shd.g_old_rec.prmtr_06;
342: ben_xcl_shd.g_old_rec.prmtr_05;
343: End If;
344: If (p_rec.prmtr_06 = hr_api.g_varchar2) then
345: p_rec.prmtr_06 :=
346: ben_xcl_shd.g_old_rec.prmtr_06;
347: End If;
348: If (p_rec.prmtr_07 = hr_api.g_varchar2) then
349: p_rec.prmtr_07 :=
350: ben_xcl_shd.g_old_rec.prmtr_07;
346: ben_xcl_shd.g_old_rec.prmtr_06;
347: End If;
348: If (p_rec.prmtr_07 = hr_api.g_varchar2) then
349: p_rec.prmtr_07 :=
350: ben_xcl_shd.g_old_rec.prmtr_07;
351: End If;
352: If (p_rec.prmtr_08 = hr_api.g_varchar2) then
353: p_rec.prmtr_08 :=
354: ben_xcl_shd.g_old_rec.prmtr_08;
350: ben_xcl_shd.g_old_rec.prmtr_07;
351: End If;
352: If (p_rec.prmtr_08 = hr_api.g_varchar2) then
353: p_rec.prmtr_08 :=
354: ben_xcl_shd.g_old_rec.prmtr_08;
355: End If;
356: If (p_rec.prmtr_09 = hr_api.g_varchar2) then
357: p_rec.prmtr_09 :=
358: ben_xcl_shd.g_old_rec.prmtr_09;
354: ben_xcl_shd.g_old_rec.prmtr_08;
355: End If;
356: If (p_rec.prmtr_09 = hr_api.g_varchar2) then
357: p_rec.prmtr_09 :=
358: ben_xcl_shd.g_old_rec.prmtr_09;
359: End If;
360: If (p_rec.prmtr_10 = hr_api.g_varchar2) then
361: p_rec.prmtr_10 :=
362: ben_xcl_shd.g_old_rec.prmtr_10;
358: ben_xcl_shd.g_old_rec.prmtr_09;
359: End If;
360: If (p_rec.prmtr_10 = hr_api.g_varchar2) then
361: p_rec.prmtr_10 :=
362: ben_xcl_shd.g_old_rec.prmtr_10;
363: End If;
364: If (p_rec.person_id = hr_api.g_number) then
365: p_rec.person_id :=
366: ben_xcl_shd.g_old_rec.person_id;
362: ben_xcl_shd.g_old_rec.prmtr_10;
363: End If;
364: If (p_rec.person_id = hr_api.g_number) then
365: p_rec.person_id :=
366: ben_xcl_shd.g_old_rec.person_id;
367: End If;
368: If (p_rec.business_group_id = hr_api.g_number) then
369: p_rec.business_group_id :=
370: ben_xcl_shd.g_old_rec.business_group_id;
366: ben_xcl_shd.g_old_rec.person_id;
367: End If;
368: If (p_rec.business_group_id = hr_api.g_number) then
369: p_rec.business_group_id :=
370: ben_xcl_shd.g_old_rec.business_group_id;
371: End If;
372:
373: --
374: hr_utility.set_location(' Leaving:'||l_proc, 10);
380: -- ----------------------------------------------------------------------------
381: Procedure upd
382: (
383: p_effective_date in date,
384: p_rec in out nocopy ben_xcl_shd.g_rec_type
385: ) is
386: --
387: l_proc varchar2(72) := g_package||'upd';
388: --
390: hr_utility.set_location('Entering:'||l_proc, 5);
391: --
392: -- We must lock the row which we need to update.
393: --
394: ben_xcl_shd.lck
395: (
396: p_rec.ext_chg_evt_log_id,
397: p_rec.object_version_number
398: );
445: p_business_group_id in number default hr_api.g_number,
446: p_object_version_number in out nocopy number
447: ) is
448: --
449: l_rec ben_xcl_shd.g_rec_type;
450: l_proc varchar2(72) := g_package||'upd';
451: --
452: Begin
453: hr_utility.set_location('Entering:'||l_proc, 5);
455: -- Call conversion function to turn arguments into the
456: -- l_rec structure.
457: --
458: l_rec :=
459: ben_xcl_shd.convert_args
460: (
461: p_ext_chg_evt_log_id,
462: p_chg_evt_cd,
463: p_chg_eff_dt,