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_BDI_UPD dependencies on BEN_BDI_SHD

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

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

Line 86: ben_bdi_shd.g_api_dml := false; -- Unset the api dml status

82: enrt_cvg_thru_dt = p_rec.enrt_cvg_thru_dt,
83: actn_cd = p_rec.actn_cd
84: where batch_dpnt_id = p_rec.batch_dpnt_id;
85: --
86: ben_bdi_shd.g_api_dml := false; -- Unset the api dml status
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: --
90: Exception

Line 93: ben_bdi_shd.g_api_dml := false; -- Unset the api dml status

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

Line 94: ben_bdi_shd.constraint_error

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

Line 98: ben_bdi_shd.g_api_dml := false; -- Unset the api dml status

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

Line 99: ben_bdi_shd.constraint_error

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

Line 103: ben_bdi_shd.g_api_dml := false; -- Unset the api dml status

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

Line 104: ben_bdi_shd.constraint_error

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

Line 107: ben_bdi_shd.g_api_dml := false; -- Unset the api dml status

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

Line 143: Procedure pre_update(p_rec in ben_bdi_shd.g_rec_type) is

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

Line 186: p_rec in ben_bdi_shd.g_rec_type) is

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

Line 213: ,p_benefit_action_id_o =>ben_bdi_shd.g_old_rec.benefit_action_id

209: ,p_enrt_cvg_strt_dt =>p_rec.enrt_cvg_strt_dt
210: ,p_enrt_cvg_thru_dt =>p_rec.enrt_cvg_thru_dt
211: ,p_actn_cd =>p_rec.actn_cd
212: ,p_effective_date =>p_effective_date
213: ,p_benefit_action_id_o =>ben_bdi_shd.g_old_rec.benefit_action_id
214: ,p_person_id_o =>ben_bdi_shd.g_old_rec.person_id
215: ,p_pgm_id_o =>ben_bdi_shd.g_old_rec.pgm_id
216: ,p_pl_id_o =>ben_bdi_shd.g_old_rec.pl_id
217: ,p_oipl_id_o =>ben_bdi_shd.g_old_rec.oipl_id

Line 214: ,p_person_id_o =>ben_bdi_shd.g_old_rec.person_id

210: ,p_enrt_cvg_thru_dt =>p_rec.enrt_cvg_thru_dt
211: ,p_actn_cd =>p_rec.actn_cd
212: ,p_effective_date =>p_effective_date
213: ,p_benefit_action_id_o =>ben_bdi_shd.g_old_rec.benefit_action_id
214: ,p_person_id_o =>ben_bdi_shd.g_old_rec.person_id
215: ,p_pgm_id_o =>ben_bdi_shd.g_old_rec.pgm_id
216: ,p_pl_id_o =>ben_bdi_shd.g_old_rec.pl_id
217: ,p_oipl_id_o =>ben_bdi_shd.g_old_rec.oipl_id
218: ,p_contact_typ_cd_o =>ben_bdi_shd.g_old_rec.contact_typ_cd

Line 215: ,p_pgm_id_o =>ben_bdi_shd.g_old_rec.pgm_id

211: ,p_actn_cd =>p_rec.actn_cd
212: ,p_effective_date =>p_effective_date
213: ,p_benefit_action_id_o =>ben_bdi_shd.g_old_rec.benefit_action_id
214: ,p_person_id_o =>ben_bdi_shd.g_old_rec.person_id
215: ,p_pgm_id_o =>ben_bdi_shd.g_old_rec.pgm_id
216: ,p_pl_id_o =>ben_bdi_shd.g_old_rec.pl_id
217: ,p_oipl_id_o =>ben_bdi_shd.g_old_rec.oipl_id
218: ,p_contact_typ_cd_o =>ben_bdi_shd.g_old_rec.contact_typ_cd
219: ,p_dpnt_person_id_o =>ben_bdi_shd.g_old_rec.dpnt_person_id

Line 216: ,p_pl_id_o =>ben_bdi_shd.g_old_rec.pl_id

212: ,p_effective_date =>p_effective_date
213: ,p_benefit_action_id_o =>ben_bdi_shd.g_old_rec.benefit_action_id
214: ,p_person_id_o =>ben_bdi_shd.g_old_rec.person_id
215: ,p_pgm_id_o =>ben_bdi_shd.g_old_rec.pgm_id
216: ,p_pl_id_o =>ben_bdi_shd.g_old_rec.pl_id
217: ,p_oipl_id_o =>ben_bdi_shd.g_old_rec.oipl_id
218: ,p_contact_typ_cd_o =>ben_bdi_shd.g_old_rec.contact_typ_cd
219: ,p_dpnt_person_id_o =>ben_bdi_shd.g_old_rec.dpnt_person_id
220: ,p_business_group_id_o =>ben_bdi_shd.g_old_rec.business_group_id

Line 217: ,p_oipl_id_o =>ben_bdi_shd.g_old_rec.oipl_id

213: ,p_benefit_action_id_o =>ben_bdi_shd.g_old_rec.benefit_action_id
214: ,p_person_id_o =>ben_bdi_shd.g_old_rec.person_id
215: ,p_pgm_id_o =>ben_bdi_shd.g_old_rec.pgm_id
216: ,p_pl_id_o =>ben_bdi_shd.g_old_rec.pl_id
217: ,p_oipl_id_o =>ben_bdi_shd.g_old_rec.oipl_id
218: ,p_contact_typ_cd_o =>ben_bdi_shd.g_old_rec.contact_typ_cd
219: ,p_dpnt_person_id_o =>ben_bdi_shd.g_old_rec.dpnt_person_id
220: ,p_business_group_id_o =>ben_bdi_shd.g_old_rec.business_group_id
221: ,p_object_version_number_o =>ben_bdi_shd.g_old_rec.object_version_number

Line 218: ,p_contact_typ_cd_o =>ben_bdi_shd.g_old_rec.contact_typ_cd

214: ,p_person_id_o =>ben_bdi_shd.g_old_rec.person_id
215: ,p_pgm_id_o =>ben_bdi_shd.g_old_rec.pgm_id
216: ,p_pl_id_o =>ben_bdi_shd.g_old_rec.pl_id
217: ,p_oipl_id_o =>ben_bdi_shd.g_old_rec.oipl_id
218: ,p_contact_typ_cd_o =>ben_bdi_shd.g_old_rec.contact_typ_cd
219: ,p_dpnt_person_id_o =>ben_bdi_shd.g_old_rec.dpnt_person_id
220: ,p_business_group_id_o =>ben_bdi_shd.g_old_rec.business_group_id
221: ,p_object_version_number_o =>ben_bdi_shd.g_old_rec.object_version_number
222: ,p_enrt_cvg_strt_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_strt_dt

Line 219: ,p_dpnt_person_id_o =>ben_bdi_shd.g_old_rec.dpnt_person_id

215: ,p_pgm_id_o =>ben_bdi_shd.g_old_rec.pgm_id
216: ,p_pl_id_o =>ben_bdi_shd.g_old_rec.pl_id
217: ,p_oipl_id_o =>ben_bdi_shd.g_old_rec.oipl_id
218: ,p_contact_typ_cd_o =>ben_bdi_shd.g_old_rec.contact_typ_cd
219: ,p_dpnt_person_id_o =>ben_bdi_shd.g_old_rec.dpnt_person_id
220: ,p_business_group_id_o =>ben_bdi_shd.g_old_rec.business_group_id
221: ,p_object_version_number_o =>ben_bdi_shd.g_old_rec.object_version_number
222: ,p_enrt_cvg_strt_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_strt_dt
223: ,p_enrt_cvg_thru_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_thru_dt

Line 220: ,p_business_group_id_o =>ben_bdi_shd.g_old_rec.business_group_id

216: ,p_pl_id_o =>ben_bdi_shd.g_old_rec.pl_id
217: ,p_oipl_id_o =>ben_bdi_shd.g_old_rec.oipl_id
218: ,p_contact_typ_cd_o =>ben_bdi_shd.g_old_rec.contact_typ_cd
219: ,p_dpnt_person_id_o =>ben_bdi_shd.g_old_rec.dpnt_person_id
220: ,p_business_group_id_o =>ben_bdi_shd.g_old_rec.business_group_id
221: ,p_object_version_number_o =>ben_bdi_shd.g_old_rec.object_version_number
222: ,p_enrt_cvg_strt_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_strt_dt
223: ,p_enrt_cvg_thru_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_thru_dt
224: ,p_actn_cd_o =>ben_bdi_shd.g_old_rec.actn_cd

Line 221: ,p_object_version_number_o =>ben_bdi_shd.g_old_rec.object_version_number

217: ,p_oipl_id_o =>ben_bdi_shd.g_old_rec.oipl_id
218: ,p_contact_typ_cd_o =>ben_bdi_shd.g_old_rec.contact_typ_cd
219: ,p_dpnt_person_id_o =>ben_bdi_shd.g_old_rec.dpnt_person_id
220: ,p_business_group_id_o =>ben_bdi_shd.g_old_rec.business_group_id
221: ,p_object_version_number_o =>ben_bdi_shd.g_old_rec.object_version_number
222: ,p_enrt_cvg_strt_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_strt_dt
223: ,p_enrt_cvg_thru_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_thru_dt
224: ,p_actn_cd_o =>ben_bdi_shd.g_old_rec.actn_cd
225: );

Line 222: ,p_enrt_cvg_strt_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_strt_dt

218: ,p_contact_typ_cd_o =>ben_bdi_shd.g_old_rec.contact_typ_cd
219: ,p_dpnt_person_id_o =>ben_bdi_shd.g_old_rec.dpnt_person_id
220: ,p_business_group_id_o =>ben_bdi_shd.g_old_rec.business_group_id
221: ,p_object_version_number_o =>ben_bdi_shd.g_old_rec.object_version_number
222: ,p_enrt_cvg_strt_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_strt_dt
223: ,p_enrt_cvg_thru_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_thru_dt
224: ,p_actn_cd_o =>ben_bdi_shd.g_old_rec.actn_cd
225: );
226: --

Line 223: ,p_enrt_cvg_thru_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_thru_dt

219: ,p_dpnt_person_id_o =>ben_bdi_shd.g_old_rec.dpnt_person_id
220: ,p_business_group_id_o =>ben_bdi_shd.g_old_rec.business_group_id
221: ,p_object_version_number_o =>ben_bdi_shd.g_old_rec.object_version_number
222: ,p_enrt_cvg_strt_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_strt_dt
223: ,p_enrt_cvg_thru_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_thru_dt
224: ,p_actn_cd_o =>ben_bdi_shd.g_old_rec.actn_cd
225: );
226: --
227: exception

Line 224: ,p_actn_cd_o =>ben_bdi_shd.g_old_rec.actn_cd

220: ,p_business_group_id_o =>ben_bdi_shd.g_old_rec.business_group_id
221: ,p_object_version_number_o =>ben_bdi_shd.g_old_rec.object_version_number
222: ,p_enrt_cvg_strt_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_strt_dt
223: ,p_enrt_cvg_thru_dt_o =>ben_bdi_shd.g_old_rec.enrt_cvg_thru_dt
224: ,p_actn_cd_o =>ben_bdi_shd.g_old_rec.actn_cd
225: );
226: --
227: exception
228: --

Line 286: Procedure convert_defs(p_rec in out nocopy ben_bdi_shd.g_rec_type) is

282: -- Internal Row Handler Use Only.
283: --
284: -- {End Of Comments}
285: -- ----------------------------------------------------------------------------
286: Procedure convert_defs(p_rec in out nocopy ben_bdi_shd.g_rec_type) is
287: --
288: l_proc varchar2(72) := g_package||'convert_defs';
289: --
290: Begin

Line 301: ben_bdi_shd.g_old_rec.benefit_action_id;

297: -- is being used then we must set to the 'current' argument value.
298: --
299: If (p_rec.benefit_action_id = hr_api.g_number) then
300: p_rec.benefit_action_id :=
301: ben_bdi_shd.g_old_rec.benefit_action_id;
302: End If;
303: If (p_rec.person_id = hr_api.g_number) then
304: p_rec.person_id :=
305: ben_bdi_shd.g_old_rec.person_id;

Line 305: ben_bdi_shd.g_old_rec.person_id;

301: ben_bdi_shd.g_old_rec.benefit_action_id;
302: End If;
303: If (p_rec.person_id = hr_api.g_number) then
304: p_rec.person_id :=
305: ben_bdi_shd.g_old_rec.person_id;
306: End If;
307: If (p_rec.pgm_id = hr_api.g_number) then
308: p_rec.pgm_id :=
309: ben_bdi_shd.g_old_rec.pgm_id;

Line 309: ben_bdi_shd.g_old_rec.pgm_id;

305: ben_bdi_shd.g_old_rec.person_id;
306: End If;
307: If (p_rec.pgm_id = hr_api.g_number) then
308: p_rec.pgm_id :=
309: ben_bdi_shd.g_old_rec.pgm_id;
310: End If;
311: If (p_rec.pl_id = hr_api.g_number) then
312: p_rec.pl_id :=
313: ben_bdi_shd.g_old_rec.pl_id;

Line 313: ben_bdi_shd.g_old_rec.pl_id;

309: ben_bdi_shd.g_old_rec.pgm_id;
310: End If;
311: If (p_rec.pl_id = hr_api.g_number) then
312: p_rec.pl_id :=
313: ben_bdi_shd.g_old_rec.pl_id;
314: End If;
315: If (p_rec.oipl_id = hr_api.g_number) then
316: p_rec.oipl_id :=
317: ben_bdi_shd.g_old_rec.oipl_id;

Line 317: ben_bdi_shd.g_old_rec.oipl_id;

313: ben_bdi_shd.g_old_rec.pl_id;
314: End If;
315: If (p_rec.oipl_id = hr_api.g_number) then
316: p_rec.oipl_id :=
317: ben_bdi_shd.g_old_rec.oipl_id;
318: End If;
319: If (p_rec.contact_typ_cd = hr_api.g_varchar2) then
320: p_rec.contact_typ_cd :=
321: ben_bdi_shd.g_old_rec.contact_typ_cd;

Line 321: ben_bdi_shd.g_old_rec.contact_typ_cd;

317: ben_bdi_shd.g_old_rec.oipl_id;
318: End If;
319: If (p_rec.contact_typ_cd = hr_api.g_varchar2) then
320: p_rec.contact_typ_cd :=
321: ben_bdi_shd.g_old_rec.contact_typ_cd;
322: End If;
323: If (p_rec.dpnt_person_id = hr_api.g_number) then
324: p_rec.dpnt_person_id :=
325: ben_bdi_shd.g_old_rec.dpnt_person_id;

Line 325: ben_bdi_shd.g_old_rec.dpnt_person_id;

321: ben_bdi_shd.g_old_rec.contact_typ_cd;
322: End If;
323: If (p_rec.dpnt_person_id = hr_api.g_number) then
324: p_rec.dpnt_person_id :=
325: ben_bdi_shd.g_old_rec.dpnt_person_id;
326: End If;
327: If (p_rec.business_group_id = hr_api.g_number) then
328: p_rec.business_group_id :=
329: ben_bdi_shd.g_old_rec.business_group_id;

Line 329: ben_bdi_shd.g_old_rec.business_group_id;

325: ben_bdi_shd.g_old_rec.dpnt_person_id;
326: End If;
327: If (p_rec.business_group_id = hr_api.g_number) then
328: p_rec.business_group_id :=
329: ben_bdi_shd.g_old_rec.business_group_id;
330: End If;
331: If (p_rec.enrt_cvg_strt_dt = hr_api.g_date) then
332: p_rec.enrt_cvg_strt_dt :=
333: ben_bdi_shd.g_old_rec.enrt_cvg_strt_dt;

Line 333: ben_bdi_shd.g_old_rec.enrt_cvg_strt_dt;

329: ben_bdi_shd.g_old_rec.business_group_id;
330: End If;
331: If (p_rec.enrt_cvg_strt_dt = hr_api.g_date) then
332: p_rec.enrt_cvg_strt_dt :=
333: ben_bdi_shd.g_old_rec.enrt_cvg_strt_dt;
334: End If;
335: If (p_rec.enrt_cvg_thru_dt = hr_api.g_date) then
336: p_rec.enrt_cvg_thru_dt :=
337: ben_bdi_shd.g_old_rec.enrt_cvg_thru_dt;

Line 337: ben_bdi_shd.g_old_rec.enrt_cvg_thru_dt;

333: ben_bdi_shd.g_old_rec.enrt_cvg_strt_dt;
334: End If;
335: If (p_rec.enrt_cvg_thru_dt = hr_api.g_date) then
336: p_rec.enrt_cvg_thru_dt :=
337: ben_bdi_shd.g_old_rec.enrt_cvg_thru_dt;
338: End If;
339: If (p_rec.actn_cd = hr_api.g_varchar2) then
340: p_rec.actn_cd :=
341: ben_bdi_shd.g_old_rec.actn_cd;

Line 341: ben_bdi_shd.g_old_rec.actn_cd;

337: ben_bdi_shd.g_old_rec.enrt_cvg_thru_dt;
338: End If;
339: If (p_rec.actn_cd = hr_api.g_varchar2) then
340: p_rec.actn_cd :=
341: ben_bdi_shd.g_old_rec.actn_cd;
342: End If;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 10);
345: --

Line 354: p_rec in out nocopy ben_bdi_shd.g_rec_type

350: -- ----------------------------------------------------------------------------
351: Procedure upd
352: (
353: p_effective_date in date,
354: p_rec in out nocopy ben_bdi_shd.g_rec_type
355: ) is
356: --
357: l_proc varchar2(72) := g_package||'upd';
358: --

Line 364: ben_bdi_shd.lck

360: hr_utility.set_location('Entering:'||l_proc, 5);
361: --
362: -- We must lock the row which we need to update.
363: --
364: ben_bdi_shd.lck
365: (
366: p_rec.batch_dpnt_id,
367: p_rec.object_version_number
368: );

Line 413: l_rec ben_bdi_shd.g_rec_type;

409: p_enrt_cvg_thru_dt in date default hr_api.g_date,
410: p_actn_cd in varchar2 default hr_api.g_varchar2
411: ) is
412: --
413: l_rec ben_bdi_shd.g_rec_type;
414: l_proc varchar2(72) := g_package||'upd';
415: --
416: Begin
417: hr_utility.set_location('Entering:'||l_proc, 5);

Line 423: ben_bdi_shd.convert_args

419: -- Call conversion function to turn arguments into the
420: -- l_rec structure.
421: --
422: l_rec :=
423: ben_bdi_shd.convert_args
424: (
425: p_batch_dpnt_id,
426: p_benefit_action_id,
427: p_person_id,