APPS.BEN_XER_UPD dependencies on BEN_XER_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ben_xer_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_xer_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: ben_xer_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_xer_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_ext_data_elmt_in_rcd Row
68: --
69: update ben_ext_data_elmt_in_rcd

Line 89: ben_xer_shd.g_api_dml := false; -- Unset the api dml status

85: object_version_number = p_rec.object_version_number,
86: hide_flag = p_rec.hide_flag
87: where ext_data_elmt_in_rcd_id = p_rec.ext_data_elmt_in_rcd_id;
88: --
89: ben_xer_shd.g_api_dml := false; -- Unset the api dml status
90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: --
93: Exception

Line 96: ben_xer_shd.g_api_dml := false; -- Unset the api dml status

92: --
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: ben_xer_shd.g_api_dml := false; -- Unset the api dml status
97: ben_xer_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated

Line 97: ben_xer_shd.constraint_error

93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: ben_xer_shd.g_api_dml := false; -- Unset the api dml status
97: ben_xer_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: ben_xer_shd.g_api_dml := false; -- Unset the api dml status

Line 101: ben_xer_shd.g_api_dml := false; -- Unset the api dml status

97: ben_xer_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: ben_xer_shd.g_api_dml := false; -- Unset the api dml status
102: ben_xer_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated

Line 102: ben_xer_shd.constraint_error

98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: ben_xer_shd.g_api_dml := false; -- Unset the api dml status
102: ben_xer_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: ben_xer_shd.g_api_dml := false; -- Unset the api dml status

Line 106: ben_xer_shd.g_api_dml := false; -- Unset the api dml status

102: ben_xer_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: ben_xer_shd.g_api_dml := false; -- Unset the api dml status
107: ben_xer_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: ben_xer_shd.g_api_dml := false; -- Unset the api dml status

Line 107: ben_xer_shd.constraint_error

103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: ben_xer_shd.g_api_dml := false; -- Unset the api dml status
107: ben_xer_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: ben_xer_shd.g_api_dml := false; -- Unset the api dml status
111: Raise;

Line 110: ben_xer_shd.g_api_dml := false; -- Unset the api dml status

106: ben_xer_shd.g_api_dml := false; -- Unset the api dml status
107: ben_xer_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: ben_xer_shd.g_api_dml := false; -- Unset the api dml status
111: Raise;
112: End update_dml;
113: --
114: -- ----------------------------------------------------------------------------

Line 146: Procedure pre_update(p_rec in ben_xer_shd.g_rec_type) is

142: -- Internal Row Handler Use Only.
143: --
144: -- {End Of Comments}
145: -- ----------------------------------------------------------------------------
146: Procedure pre_update(p_rec in ben_xer_shd.g_rec_type) is
147: --
148: l_proc varchar2(72) := g_package||'pre_update';
149: --
150: Begin

Line 189: p_effective_date in date,p_rec in ben_xer_shd.g_rec_type) is

185: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure post_update(
189: p_effective_date in date,p_rec in ben_xer_shd.g_rec_type) is
190: --
191: l_proc varchar2(72) := g_package||'post_update';
192: --
193: Begin

Line 217: ,p_seq_num_o =>ben_xer_shd.g_old_rec.seq_num

213: ,p_legislation_code =>p_rec.legislation_code
214: ,p_object_version_number =>p_rec.object_version_number
215: ,p_hide_flag =>p_rec.hide_flag
216: ,p_effective_date =>p_effective_date
217: ,p_seq_num_o =>ben_xer_shd.g_old_rec.seq_num
218: ,p_strt_pos_o =>ben_xer_shd.g_old_rec.strt_pos
219: ,p_dlmtr_val_o =>ben_xer_shd.g_old_rec.dlmtr_val
220: ,p_rqd_flag_o =>ben_xer_shd.g_old_rec.rqd_flag
221: ,p_sprs_cd_o =>ben_xer_shd.g_old_rec.sprs_cd

Line 218: ,p_strt_pos_o =>ben_xer_shd.g_old_rec.strt_pos

214: ,p_object_version_number =>p_rec.object_version_number
215: ,p_hide_flag =>p_rec.hide_flag
216: ,p_effective_date =>p_effective_date
217: ,p_seq_num_o =>ben_xer_shd.g_old_rec.seq_num
218: ,p_strt_pos_o =>ben_xer_shd.g_old_rec.strt_pos
219: ,p_dlmtr_val_o =>ben_xer_shd.g_old_rec.dlmtr_val
220: ,p_rqd_flag_o =>ben_xer_shd.g_old_rec.rqd_flag
221: ,p_sprs_cd_o =>ben_xer_shd.g_old_rec.sprs_cd
222: ,p_any_or_all_cd_o =>ben_xer_shd.g_old_rec.any_or_all_cd

Line 219: ,p_dlmtr_val_o =>ben_xer_shd.g_old_rec.dlmtr_val

215: ,p_hide_flag =>p_rec.hide_flag
216: ,p_effective_date =>p_effective_date
217: ,p_seq_num_o =>ben_xer_shd.g_old_rec.seq_num
218: ,p_strt_pos_o =>ben_xer_shd.g_old_rec.strt_pos
219: ,p_dlmtr_val_o =>ben_xer_shd.g_old_rec.dlmtr_val
220: ,p_rqd_flag_o =>ben_xer_shd.g_old_rec.rqd_flag
221: ,p_sprs_cd_o =>ben_xer_shd.g_old_rec.sprs_cd
222: ,p_any_or_all_cd_o =>ben_xer_shd.g_old_rec.any_or_all_cd
223: ,p_ext_data_elmt_id_o =>ben_xer_shd.g_old_rec.ext_data_elmt_id

Line 220: ,p_rqd_flag_o =>ben_xer_shd.g_old_rec.rqd_flag

216: ,p_effective_date =>p_effective_date
217: ,p_seq_num_o =>ben_xer_shd.g_old_rec.seq_num
218: ,p_strt_pos_o =>ben_xer_shd.g_old_rec.strt_pos
219: ,p_dlmtr_val_o =>ben_xer_shd.g_old_rec.dlmtr_val
220: ,p_rqd_flag_o =>ben_xer_shd.g_old_rec.rqd_flag
221: ,p_sprs_cd_o =>ben_xer_shd.g_old_rec.sprs_cd
222: ,p_any_or_all_cd_o =>ben_xer_shd.g_old_rec.any_or_all_cd
223: ,p_ext_data_elmt_id_o =>ben_xer_shd.g_old_rec.ext_data_elmt_id
224: ,p_ext_rcd_id_o =>ben_xer_shd.g_old_rec.ext_rcd_id

Line 221: ,p_sprs_cd_o =>ben_xer_shd.g_old_rec.sprs_cd

217: ,p_seq_num_o =>ben_xer_shd.g_old_rec.seq_num
218: ,p_strt_pos_o =>ben_xer_shd.g_old_rec.strt_pos
219: ,p_dlmtr_val_o =>ben_xer_shd.g_old_rec.dlmtr_val
220: ,p_rqd_flag_o =>ben_xer_shd.g_old_rec.rqd_flag
221: ,p_sprs_cd_o =>ben_xer_shd.g_old_rec.sprs_cd
222: ,p_any_or_all_cd_o =>ben_xer_shd.g_old_rec.any_or_all_cd
223: ,p_ext_data_elmt_id_o =>ben_xer_shd.g_old_rec.ext_data_elmt_id
224: ,p_ext_rcd_id_o =>ben_xer_shd.g_old_rec.ext_rcd_id
225: ,p_business_group_id_o =>ben_xer_shd.g_old_rec.business_group_id

Line 222: ,p_any_or_all_cd_o =>ben_xer_shd.g_old_rec.any_or_all_cd

218: ,p_strt_pos_o =>ben_xer_shd.g_old_rec.strt_pos
219: ,p_dlmtr_val_o =>ben_xer_shd.g_old_rec.dlmtr_val
220: ,p_rqd_flag_o =>ben_xer_shd.g_old_rec.rqd_flag
221: ,p_sprs_cd_o =>ben_xer_shd.g_old_rec.sprs_cd
222: ,p_any_or_all_cd_o =>ben_xer_shd.g_old_rec.any_or_all_cd
223: ,p_ext_data_elmt_id_o =>ben_xer_shd.g_old_rec.ext_data_elmt_id
224: ,p_ext_rcd_id_o =>ben_xer_shd.g_old_rec.ext_rcd_id
225: ,p_business_group_id_o =>ben_xer_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xer_shd.g_old_rec.legislation_code

Line 223: ,p_ext_data_elmt_id_o =>ben_xer_shd.g_old_rec.ext_data_elmt_id

219: ,p_dlmtr_val_o =>ben_xer_shd.g_old_rec.dlmtr_val
220: ,p_rqd_flag_o =>ben_xer_shd.g_old_rec.rqd_flag
221: ,p_sprs_cd_o =>ben_xer_shd.g_old_rec.sprs_cd
222: ,p_any_or_all_cd_o =>ben_xer_shd.g_old_rec.any_or_all_cd
223: ,p_ext_data_elmt_id_o =>ben_xer_shd.g_old_rec.ext_data_elmt_id
224: ,p_ext_rcd_id_o =>ben_xer_shd.g_old_rec.ext_rcd_id
225: ,p_business_group_id_o =>ben_xer_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xer_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o =>ben_xer_shd.g_old_rec.object_version_number

Line 224: ,p_ext_rcd_id_o =>ben_xer_shd.g_old_rec.ext_rcd_id

220: ,p_rqd_flag_o =>ben_xer_shd.g_old_rec.rqd_flag
221: ,p_sprs_cd_o =>ben_xer_shd.g_old_rec.sprs_cd
222: ,p_any_or_all_cd_o =>ben_xer_shd.g_old_rec.any_or_all_cd
223: ,p_ext_data_elmt_id_o =>ben_xer_shd.g_old_rec.ext_data_elmt_id
224: ,p_ext_rcd_id_o =>ben_xer_shd.g_old_rec.ext_rcd_id
225: ,p_business_group_id_o =>ben_xer_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xer_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o =>ben_xer_shd.g_old_rec.object_version_number
228: ,p_hide_flag_o =>ben_xer_shd.g_old_rec.hide_flag

Line 225: ,p_business_group_id_o =>ben_xer_shd.g_old_rec.business_group_id

221: ,p_sprs_cd_o =>ben_xer_shd.g_old_rec.sprs_cd
222: ,p_any_or_all_cd_o =>ben_xer_shd.g_old_rec.any_or_all_cd
223: ,p_ext_data_elmt_id_o =>ben_xer_shd.g_old_rec.ext_data_elmt_id
224: ,p_ext_rcd_id_o =>ben_xer_shd.g_old_rec.ext_rcd_id
225: ,p_business_group_id_o =>ben_xer_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xer_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o =>ben_xer_shd.g_old_rec.object_version_number
228: ,p_hide_flag_o =>ben_xer_shd.g_old_rec.hide_flag
229: );

Line 226: ,p_legislation_code_o =>ben_xer_shd.g_old_rec.legislation_code

222: ,p_any_or_all_cd_o =>ben_xer_shd.g_old_rec.any_or_all_cd
223: ,p_ext_data_elmt_id_o =>ben_xer_shd.g_old_rec.ext_data_elmt_id
224: ,p_ext_rcd_id_o =>ben_xer_shd.g_old_rec.ext_rcd_id
225: ,p_business_group_id_o =>ben_xer_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xer_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o =>ben_xer_shd.g_old_rec.object_version_number
228: ,p_hide_flag_o =>ben_xer_shd.g_old_rec.hide_flag
229: );
230: --

Line 227: ,p_object_version_number_o =>ben_xer_shd.g_old_rec.object_version_number

223: ,p_ext_data_elmt_id_o =>ben_xer_shd.g_old_rec.ext_data_elmt_id
224: ,p_ext_rcd_id_o =>ben_xer_shd.g_old_rec.ext_rcd_id
225: ,p_business_group_id_o =>ben_xer_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xer_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o =>ben_xer_shd.g_old_rec.object_version_number
228: ,p_hide_flag_o =>ben_xer_shd.g_old_rec.hide_flag
229: );
230: --
231: exception

Line 228: ,p_hide_flag_o =>ben_xer_shd.g_old_rec.hide_flag

224: ,p_ext_rcd_id_o =>ben_xer_shd.g_old_rec.ext_rcd_id
225: ,p_business_group_id_o =>ben_xer_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xer_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o =>ben_xer_shd.g_old_rec.object_version_number
228: ,p_hide_flag_o =>ben_xer_shd.g_old_rec.hide_flag
229: );
230: --
231: exception
232: --

Line 290: Procedure convert_defs(p_rec in out nocopy ben_xer_shd.g_rec_type) is

286: -- Internal Row Handler Use Only.
287: --
288: -- {End Of Comments}
289: -- ----------------------------------------------------------------------------
290: Procedure convert_defs(p_rec in out nocopy ben_xer_shd.g_rec_type) is
291: --
292: l_proc varchar2(72) := g_package||'convert_defs';
293: --
294: Begin

Line 305: ben_xer_shd.g_old_rec.seq_num;

301: -- is being used then we must set to the 'current' argument value.
302: --
303: If (p_rec.seq_num = hr_api.g_number) then
304: p_rec.seq_num :=
305: ben_xer_shd.g_old_rec.seq_num;
306: End If;
307: If (p_rec.strt_pos = hr_api.g_number) then
308: p_rec.strt_pos :=
309: ben_xer_shd.g_old_rec.strt_pos;

Line 309: ben_xer_shd.g_old_rec.strt_pos;

305: ben_xer_shd.g_old_rec.seq_num;
306: End If;
307: If (p_rec.strt_pos = hr_api.g_number) then
308: p_rec.strt_pos :=
309: ben_xer_shd.g_old_rec.strt_pos;
310: End If;
311: If (p_rec.dlmtr_val = hr_api.g_varchar2) then
312: p_rec.dlmtr_val :=
313: ben_xer_shd.g_old_rec.dlmtr_val;

Line 313: ben_xer_shd.g_old_rec.dlmtr_val;

309: ben_xer_shd.g_old_rec.strt_pos;
310: End If;
311: If (p_rec.dlmtr_val = hr_api.g_varchar2) then
312: p_rec.dlmtr_val :=
313: ben_xer_shd.g_old_rec.dlmtr_val;
314: End If;
315: If (p_rec.rqd_flag = hr_api.g_varchar2) then
316: p_rec.rqd_flag :=
317: ben_xer_shd.g_old_rec.rqd_flag;

Line 317: ben_xer_shd.g_old_rec.rqd_flag;

313: ben_xer_shd.g_old_rec.dlmtr_val;
314: End If;
315: If (p_rec.rqd_flag = hr_api.g_varchar2) then
316: p_rec.rqd_flag :=
317: ben_xer_shd.g_old_rec.rqd_flag;
318: End If;
319: If (p_rec.sprs_cd = hr_api.g_varchar2) then
320: p_rec.sprs_cd :=
321: ben_xer_shd.g_old_rec.sprs_cd;

Line 321: ben_xer_shd.g_old_rec.sprs_cd;

317: ben_xer_shd.g_old_rec.rqd_flag;
318: End If;
319: If (p_rec.sprs_cd = hr_api.g_varchar2) then
320: p_rec.sprs_cd :=
321: ben_xer_shd.g_old_rec.sprs_cd;
322: End If;
323: If (p_rec.any_or_all_cd = hr_api.g_varchar2) then
324: p_rec.any_or_all_cd :=
325: ben_xer_shd.g_old_rec.any_or_all_cd;

Line 325: ben_xer_shd.g_old_rec.any_or_all_cd;

321: ben_xer_shd.g_old_rec.sprs_cd;
322: End If;
323: If (p_rec.any_or_all_cd = hr_api.g_varchar2) then
324: p_rec.any_or_all_cd :=
325: ben_xer_shd.g_old_rec.any_or_all_cd;
326: End If;
327: If (p_rec.ext_data_elmt_id = hr_api.g_number) then
328: p_rec.ext_data_elmt_id :=
329: ben_xer_shd.g_old_rec.ext_data_elmt_id;

Line 329: ben_xer_shd.g_old_rec.ext_data_elmt_id;

325: ben_xer_shd.g_old_rec.any_or_all_cd;
326: End If;
327: If (p_rec.ext_data_elmt_id = hr_api.g_number) then
328: p_rec.ext_data_elmt_id :=
329: ben_xer_shd.g_old_rec.ext_data_elmt_id;
330: End If;
331: If (p_rec.ext_rcd_id = hr_api.g_number) then
332: p_rec.ext_rcd_id :=
333: ben_xer_shd.g_old_rec.ext_rcd_id;

Line 333: ben_xer_shd.g_old_rec.ext_rcd_id;

329: ben_xer_shd.g_old_rec.ext_data_elmt_id;
330: End If;
331: If (p_rec.ext_rcd_id = hr_api.g_number) then
332: p_rec.ext_rcd_id :=
333: ben_xer_shd.g_old_rec.ext_rcd_id;
334: End If;
335: If (p_rec.business_group_id = hr_api.g_number) then
336: p_rec.business_group_id :=
337: ben_xer_shd.g_old_rec.business_group_id;

Line 337: ben_xer_shd.g_old_rec.business_group_id;

333: ben_xer_shd.g_old_rec.ext_rcd_id;
334: End If;
335: If (p_rec.business_group_id = hr_api.g_number) then
336: p_rec.business_group_id :=
337: ben_xer_shd.g_old_rec.business_group_id;
338: End If;
339: If (p_rec.legislation_code = hr_api.g_varchar2) then
340: p_rec.legislation_code :=
341: ben_xer_shd.g_old_rec.legislation_code;

Line 341: ben_xer_shd.g_old_rec.legislation_code;

337: ben_xer_shd.g_old_rec.business_group_id;
338: End If;
339: If (p_rec.legislation_code = hr_api.g_varchar2) then
340: p_rec.legislation_code :=
341: ben_xer_shd.g_old_rec.legislation_code;
342: End If;
343:
344: If (p_rec.hide_flag = hr_api.g_varchar2) then
345: p_rec.hide_flag :=

Line 346: ben_xer_shd.g_old_rec.hide_flag;

342: End If;
343:
344: If (p_rec.hide_flag = hr_api.g_varchar2) then
345: p_rec.hide_flag :=
346: ben_xer_shd.g_old_rec.hide_flag;
347: End If;
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 10);
350: --

Line 359: p_rec in out nocopy ben_xer_shd.g_rec_type

355: -- ----------------------------------------------------------------------------
356: Procedure upd
357: (
358: p_effective_date in date,
359: p_rec in out nocopy ben_xer_shd.g_rec_type
360: ) is
361: --
362: l_proc varchar2(72) := g_package||'upd';
363: --

Line 369: ben_xer_shd.lck

365: hr_utility.set_location('Entering:'||l_proc, 5);
366: --
367: -- We must lock the row which we need to update.
368: --
369: ben_xer_shd.lck
370: (
371: p_rec.ext_data_elmt_in_rcd_id,
372: p_rec.object_version_number
373: );

Line 425: l_rec ben_xer_shd.g_rec_type;

421: p_object_version_number in out nocopy number,
422: p_hide_flag in varchar2 default hr_api.g_varchar2
423: ) is
424: --
425: l_rec ben_xer_shd.g_rec_type;
426: l_proc varchar2(72) := g_package||'upd';
427: --
428: Begin
429: hr_utility.set_location('Entering:'||l_proc, 5);

Line 435: ben_xer_shd.convert_args

431: -- Call conversion function to turn arguments into the
432: -- l_rec structure.
433: --
434: l_rec :=
435: ben_xer_shd.convert_args
436: (
437: p_ext_data_elmt_in_rcd_id,
438: p_seq_num,
439: p_strt_pos,