eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_XCL_UPD dependencies on BEN_XCL_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ben_xcl_shd.g_rec_type) is

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

Line 65: ben_xcl_shd.g_api_dml := true; -- Set the api dml status

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

Line 90: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status

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

Line 97: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status

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

Line 98: ben_xcl_shd.constraint_error

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

Line 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

Line 103: 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
107: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status

Line 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

Line 108: 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
112: Raise;

Line 111: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status

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: -- ----------------------------------------------------------------------------

Line 147: Procedure pre_update(p_rec in ben_xcl_shd.g_rec_type) is

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

Line 190: p_effective_date in date,p_rec in ben_xcl_shd.g_rec_type) is

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

Line 222: ,p_chg_evt_cd_o =>ben_xcl_shd.g_old_rec.chg_evt_cd

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

Line 223: ,p_chg_eff_dt_o =>ben_xcl_shd.g_old_rec.chg_eff_dt

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

Line 224: ,p_chg_user_id_o =>ben_xcl_shd.g_old_rec.chg_user_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
228: ,p_prmtr_04_o =>ben_xcl_shd.g_old_rec.prmtr_04

Line 225: ,p_prmtr_01_o =>ben_xcl_shd.g_old_rec.prmtr_01

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

Line 226: ,p_prmtr_02_o =>ben_xcl_shd.g_old_rec.prmtr_02

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

Line 227: ,p_prmtr_03_o =>ben_xcl_shd.g_old_rec.prmtr_03

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

Line 228: ,p_prmtr_04_o =>ben_xcl_shd.g_old_rec.prmtr_04

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

Line 229: ,p_prmtr_05_o =>ben_xcl_shd.g_old_rec.prmtr_05

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

Line 230: ,p_prmtr_06_o =>ben_xcl_shd.g_old_rec.prmtr_06

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

Line 231: ,p_prmtr_07_o =>ben_xcl_shd.g_old_rec.prmtr_07

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

Line 232: ,p_prmtr_08_o =>ben_xcl_shd.g_old_rec.prmtr_08

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

Line 233: ,p_prmtr_09_o =>ben_xcl_shd.g_old_rec.prmtr_09

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

Line 234: ,p_prmtr_10_o =>ben_xcl_shd.g_old_rec.prmtr_10

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: );

Line 235: ,p_person_id_o =>ben_xcl_shd.g_old_rec.person_id

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: --

Line 236: ,p_business_group_id_o =>ben_xcl_shd.g_old_rec.business_group_id

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

Line 237: ,p_object_version_number_o =>ben_xcl_shd.g_old_rec.object_version_number

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: --

Line 299: Procedure convert_defs(p_rec in out nocopy ben_xcl_shd.g_rec_type) is

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

Line 314: ben_xcl_shd.g_old_rec.chg_evt_cd;

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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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);

Line 384: p_rec in out nocopy ben_xcl_shd.g_rec_type

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: --

Line 394: ben_xcl_shd.lck

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: );

Line 449: l_rec ben_xcl_shd.g_rec_type;

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);

Line 459: ben_xcl_shd.convert_args

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,