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_BCI_UPD dependencies on BEN_BCI_SHD

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

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

Line 80: ben_bci_shd.g_api_dml := false; -- Unset the api dml status

76: enrt_ctfn_recd_dt = p_rec.enrt_ctfn_recd_dt,
77: object_version_number = p_rec.object_version_number
78: where batch_benft_cert_id = p_rec.batch_benft_cert_id;
79: --
80: ben_bci_shd.g_api_dml := false; -- Unset the api dml status
81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: --
84: Exception

Line 87: ben_bci_shd.g_api_dml := false; -- Unset the api dml status

83: --
84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: ben_bci_shd.g_api_dml := false; -- Unset the api dml status
88: ben_bci_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated

Line 88: ben_bci_shd.constraint_error

84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: ben_bci_shd.g_api_dml := false; -- Unset the api dml status
88: ben_bci_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: ben_bci_shd.g_api_dml := false; -- Unset the api dml status

Line 92: ben_bci_shd.g_api_dml := false; -- Unset the api dml status

88: ben_bci_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: ben_bci_shd.g_api_dml := false; -- Unset the api dml status
93: ben_bci_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated

Line 93: ben_bci_shd.constraint_error

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

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

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

Line 98: ben_bci_shd.constraint_error

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

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

97: ben_bci_shd.g_api_dml := false; -- Unset the api dml status
98: ben_bci_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: ben_bci_shd.g_api_dml := false; -- Unset the api dml status
102: Raise;
103: End update_dml;
104: --
105: -- ----------------------------------------------------------------------------

Line 137: Procedure pre_update(p_rec in ben_bci_shd.g_rec_type) is

133: -- Internal Row Handler Use Only.
134: --
135: -- {End Of Comments}
136: -- ----------------------------------------------------------------------------
137: Procedure pre_update(p_rec in ben_bci_shd.g_rec_type) is
138: --
139: l_proc varchar2(72) := g_package||'pre_update';
140: --
141: Begin

Line 180: p_effective_date in date,p_rec in ben_bci_shd.g_rec_type) is

176: --
177: -- {End Of Comments}
178: -- ----------------------------------------------------------------------------
179: Procedure post_update(
180: p_effective_date in date,p_rec in ben_bci_shd.g_rec_type) is
181: --
182: l_proc varchar2(72) := g_package||'post_update';
183: --
184: Begin

Line 202: ,p_benefit_action_id_o =>ben_bci_shd.g_old_rec.benefit_action_id

198: ,p_typ_cd =>p_rec.typ_cd
199: ,p_enrt_ctfn_recd_dt =>p_rec.enrt_ctfn_recd_dt
200: ,p_object_version_number =>p_rec.object_version_number
201: ,p_effective_date =>p_effective_date
202: ,p_benefit_action_id_o =>ben_bci_shd.g_old_rec.benefit_action_id
203: ,p_person_id_o =>ben_bci_shd.g_old_rec.person_id
204: ,p_actn_typ_id_o =>ben_bci_shd.g_old_rec.actn_typ_id
205: ,p_typ_cd_o =>ben_bci_shd.g_old_rec.typ_cd
206: ,p_enrt_ctfn_recd_dt_o =>ben_bci_shd.g_old_rec.enrt_ctfn_recd_dt

Line 203: ,p_person_id_o =>ben_bci_shd.g_old_rec.person_id

199: ,p_enrt_ctfn_recd_dt =>p_rec.enrt_ctfn_recd_dt
200: ,p_object_version_number =>p_rec.object_version_number
201: ,p_effective_date =>p_effective_date
202: ,p_benefit_action_id_o =>ben_bci_shd.g_old_rec.benefit_action_id
203: ,p_person_id_o =>ben_bci_shd.g_old_rec.person_id
204: ,p_actn_typ_id_o =>ben_bci_shd.g_old_rec.actn_typ_id
205: ,p_typ_cd_o =>ben_bci_shd.g_old_rec.typ_cd
206: ,p_enrt_ctfn_recd_dt_o =>ben_bci_shd.g_old_rec.enrt_ctfn_recd_dt
207: ,p_object_version_number_o =>ben_bci_shd.g_old_rec.object_version_number

Line 204: ,p_actn_typ_id_o =>ben_bci_shd.g_old_rec.actn_typ_id

200: ,p_object_version_number =>p_rec.object_version_number
201: ,p_effective_date =>p_effective_date
202: ,p_benefit_action_id_o =>ben_bci_shd.g_old_rec.benefit_action_id
203: ,p_person_id_o =>ben_bci_shd.g_old_rec.person_id
204: ,p_actn_typ_id_o =>ben_bci_shd.g_old_rec.actn_typ_id
205: ,p_typ_cd_o =>ben_bci_shd.g_old_rec.typ_cd
206: ,p_enrt_ctfn_recd_dt_o =>ben_bci_shd.g_old_rec.enrt_ctfn_recd_dt
207: ,p_object_version_number_o =>ben_bci_shd.g_old_rec.object_version_number
208: );

Line 205: ,p_typ_cd_o =>ben_bci_shd.g_old_rec.typ_cd

201: ,p_effective_date =>p_effective_date
202: ,p_benefit_action_id_o =>ben_bci_shd.g_old_rec.benefit_action_id
203: ,p_person_id_o =>ben_bci_shd.g_old_rec.person_id
204: ,p_actn_typ_id_o =>ben_bci_shd.g_old_rec.actn_typ_id
205: ,p_typ_cd_o =>ben_bci_shd.g_old_rec.typ_cd
206: ,p_enrt_ctfn_recd_dt_o =>ben_bci_shd.g_old_rec.enrt_ctfn_recd_dt
207: ,p_object_version_number_o =>ben_bci_shd.g_old_rec.object_version_number
208: );
209: --

Line 206: ,p_enrt_ctfn_recd_dt_o =>ben_bci_shd.g_old_rec.enrt_ctfn_recd_dt

202: ,p_benefit_action_id_o =>ben_bci_shd.g_old_rec.benefit_action_id
203: ,p_person_id_o =>ben_bci_shd.g_old_rec.person_id
204: ,p_actn_typ_id_o =>ben_bci_shd.g_old_rec.actn_typ_id
205: ,p_typ_cd_o =>ben_bci_shd.g_old_rec.typ_cd
206: ,p_enrt_ctfn_recd_dt_o =>ben_bci_shd.g_old_rec.enrt_ctfn_recd_dt
207: ,p_object_version_number_o =>ben_bci_shd.g_old_rec.object_version_number
208: );
209: --
210: exception

Line 207: ,p_object_version_number_o =>ben_bci_shd.g_old_rec.object_version_number

203: ,p_person_id_o =>ben_bci_shd.g_old_rec.person_id
204: ,p_actn_typ_id_o =>ben_bci_shd.g_old_rec.actn_typ_id
205: ,p_typ_cd_o =>ben_bci_shd.g_old_rec.typ_cd
206: ,p_enrt_ctfn_recd_dt_o =>ben_bci_shd.g_old_rec.enrt_ctfn_recd_dt
207: ,p_object_version_number_o =>ben_bci_shd.g_old_rec.object_version_number
208: );
209: --
210: exception
211: --

Line 269: Procedure convert_defs(p_rec in out nocopy ben_bci_shd.g_rec_type) is

265: -- Internal Row Handler Use Only.
266: --
267: -- {End Of Comments}
268: -- ----------------------------------------------------------------------------
269: Procedure convert_defs(p_rec in out nocopy ben_bci_shd.g_rec_type) is
270: --
271: l_proc varchar2(72) := g_package||'convert_defs';
272: --
273: Begin

Line 284: ben_bci_shd.g_old_rec.benefit_action_id;

280: -- is being used then we must set to the 'current' argument value.
281: --
282: If (p_rec.benefit_action_id = hr_api.g_number) then
283: p_rec.benefit_action_id :=
284: ben_bci_shd.g_old_rec.benefit_action_id;
285: End If;
286: If (p_rec.person_id = hr_api.g_number) then
287: p_rec.person_id :=
288: ben_bci_shd.g_old_rec.person_id;

Line 288: ben_bci_shd.g_old_rec.person_id;

284: ben_bci_shd.g_old_rec.benefit_action_id;
285: End If;
286: If (p_rec.person_id = hr_api.g_number) then
287: p_rec.person_id :=
288: ben_bci_shd.g_old_rec.person_id;
289: End If;
290: If (p_rec.actn_typ_id = hr_api.g_number) then
291: p_rec.actn_typ_id :=
292: ben_bci_shd.g_old_rec.actn_typ_id;

Line 292: ben_bci_shd.g_old_rec.actn_typ_id;

288: ben_bci_shd.g_old_rec.person_id;
289: End If;
290: If (p_rec.actn_typ_id = hr_api.g_number) then
291: p_rec.actn_typ_id :=
292: ben_bci_shd.g_old_rec.actn_typ_id;
293: End If;
294: If (p_rec.typ_cd = hr_api.g_varchar2) then
295: p_rec.typ_cd :=
296: ben_bci_shd.g_old_rec.typ_cd;

Line 296: ben_bci_shd.g_old_rec.typ_cd;

292: ben_bci_shd.g_old_rec.actn_typ_id;
293: End If;
294: If (p_rec.typ_cd = hr_api.g_varchar2) then
295: p_rec.typ_cd :=
296: ben_bci_shd.g_old_rec.typ_cd;
297: End If;
298: If (p_rec.enrt_ctfn_recd_dt = hr_api.g_date) then
299: p_rec.enrt_ctfn_recd_dt :=
300: ben_bci_shd.g_old_rec.enrt_ctfn_recd_dt;

Line 300: ben_bci_shd.g_old_rec.enrt_ctfn_recd_dt;

296: ben_bci_shd.g_old_rec.typ_cd;
297: End If;
298: If (p_rec.enrt_ctfn_recd_dt = hr_api.g_date) then
299: p_rec.enrt_ctfn_recd_dt :=
300: ben_bci_shd.g_old_rec.enrt_ctfn_recd_dt;
301: End If;
302:
303: --
304: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 314: p_rec in out nocopy ben_bci_shd.g_rec_type

310: -- ----------------------------------------------------------------------------
311: Procedure upd
312: (
313: p_effective_date in date,
314: p_rec in out nocopy ben_bci_shd.g_rec_type
315: ) is
316: --
317: l_proc varchar2(72) := g_package||'upd';
318: --

Line 324: ben_bci_shd.lck

320: hr_utility.set_location('Entering:'||l_proc, 5);
321: --
322: -- We must lock the row which we need to update.
323: --
324: ben_bci_shd.lck
325: (
326: p_rec.batch_benft_cert_id,
327: p_rec.object_version_number
328: );

Line 369: l_rec ben_bci_shd.g_rec_type;

365: p_enrt_ctfn_recd_dt in date default hr_api.g_date,
366: p_object_version_number in out nocopy number
367: ) is
368: --
369: l_rec ben_bci_shd.g_rec_type;
370: l_proc varchar2(72) := g_package||'upd';
371: --
372: Begin
373: hr_utility.set_location('Entering:'||l_proc, 5);

Line 379: ben_bci_shd.convert_args

375: -- Call conversion function to turn arguments into the
376: -- l_rec structure.
377: --
378: l_rec :=
379: ben_bci_shd.convert_args
380: (
381: p_batch_benft_cert_id,
382: p_benefit_action_id,
383: p_person_id,