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_BEI_UPD dependencies on BEN_BEI_SHD

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

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

Line 83: ben_bei_shd.g_api_dml := false; -- Unset the api dml status

79: business_group_id = p_rec.business_group_id,
80: object_version_number = p_rec.object_version_number
81: where batch_elig_id = p_rec.batch_elig_id;
82: --
83: ben_bei_shd.g_api_dml := false; -- Unset the api dml status
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: --
87: Exception

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

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

Line 91: ben_bei_shd.constraint_error

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

Line 95: ben_bei_shd.g_api_dml := false; -- Unset the api dml status

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

Line 96: ben_bei_shd.constraint_error

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

Line 100: ben_bei_shd.g_api_dml := false; -- Unset the api dml status

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

Line 101: ben_bei_shd.constraint_error

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

Line 104: ben_bei_shd.g_api_dml := false; -- Unset the api dml status

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

Line 140: Procedure pre_update(p_rec in ben_bei_shd.g_rec_type) is

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

Line 183: p_rec in ben_bei_shd.g_rec_type) is

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

Line 207: ,p_benefit_action_id_o =>ben_bei_shd.g_old_rec.benefit_action_id

203: ,p_inelig_text =>p_rec.inelig_text
204: ,p_business_group_id =>p_rec.business_group_id
205: ,p_object_version_number =>p_rec.object_version_number
206: ,p_effective_date =>p_effective_date
207: ,p_benefit_action_id_o =>ben_bei_shd.g_old_rec.benefit_action_id
208: ,p_person_id_o =>ben_bei_shd.g_old_rec.person_id
209: ,p_pgm_id_o =>ben_bei_shd.g_old_rec.pgm_id
210: ,p_pl_id_o =>ben_bei_shd.g_old_rec.pl_id
211: ,p_oipl_id_o =>ben_bei_shd.g_old_rec.oipl_id

Line 208: ,p_person_id_o =>ben_bei_shd.g_old_rec.person_id

204: ,p_business_group_id =>p_rec.business_group_id
205: ,p_object_version_number =>p_rec.object_version_number
206: ,p_effective_date =>p_effective_date
207: ,p_benefit_action_id_o =>ben_bei_shd.g_old_rec.benefit_action_id
208: ,p_person_id_o =>ben_bei_shd.g_old_rec.person_id
209: ,p_pgm_id_o =>ben_bei_shd.g_old_rec.pgm_id
210: ,p_pl_id_o =>ben_bei_shd.g_old_rec.pl_id
211: ,p_oipl_id_o =>ben_bei_shd.g_old_rec.oipl_id
212: ,p_elig_flag_o =>ben_bei_shd.g_old_rec.elig_flag

Line 209: ,p_pgm_id_o =>ben_bei_shd.g_old_rec.pgm_id

205: ,p_object_version_number =>p_rec.object_version_number
206: ,p_effective_date =>p_effective_date
207: ,p_benefit_action_id_o =>ben_bei_shd.g_old_rec.benefit_action_id
208: ,p_person_id_o =>ben_bei_shd.g_old_rec.person_id
209: ,p_pgm_id_o =>ben_bei_shd.g_old_rec.pgm_id
210: ,p_pl_id_o =>ben_bei_shd.g_old_rec.pl_id
211: ,p_oipl_id_o =>ben_bei_shd.g_old_rec.oipl_id
212: ,p_elig_flag_o =>ben_bei_shd.g_old_rec.elig_flag
213: ,p_inelig_text_o =>ben_bei_shd.g_old_rec.inelig_text

Line 210: ,p_pl_id_o =>ben_bei_shd.g_old_rec.pl_id

206: ,p_effective_date =>p_effective_date
207: ,p_benefit_action_id_o =>ben_bei_shd.g_old_rec.benefit_action_id
208: ,p_person_id_o =>ben_bei_shd.g_old_rec.person_id
209: ,p_pgm_id_o =>ben_bei_shd.g_old_rec.pgm_id
210: ,p_pl_id_o =>ben_bei_shd.g_old_rec.pl_id
211: ,p_oipl_id_o =>ben_bei_shd.g_old_rec.oipl_id
212: ,p_elig_flag_o =>ben_bei_shd.g_old_rec.elig_flag
213: ,p_inelig_text_o =>ben_bei_shd.g_old_rec.inelig_text
214: ,p_business_group_id_o =>ben_bei_shd.g_old_rec.business_group_id

Line 211: ,p_oipl_id_o =>ben_bei_shd.g_old_rec.oipl_id

207: ,p_benefit_action_id_o =>ben_bei_shd.g_old_rec.benefit_action_id
208: ,p_person_id_o =>ben_bei_shd.g_old_rec.person_id
209: ,p_pgm_id_o =>ben_bei_shd.g_old_rec.pgm_id
210: ,p_pl_id_o =>ben_bei_shd.g_old_rec.pl_id
211: ,p_oipl_id_o =>ben_bei_shd.g_old_rec.oipl_id
212: ,p_elig_flag_o =>ben_bei_shd.g_old_rec.elig_flag
213: ,p_inelig_text_o =>ben_bei_shd.g_old_rec.inelig_text
214: ,p_business_group_id_o =>ben_bei_shd.g_old_rec.business_group_id
215: ,p_object_version_number_o=>ben_bei_shd.g_old_rec.object_version_number);

Line 212: ,p_elig_flag_o =>ben_bei_shd.g_old_rec.elig_flag

208: ,p_person_id_o =>ben_bei_shd.g_old_rec.person_id
209: ,p_pgm_id_o =>ben_bei_shd.g_old_rec.pgm_id
210: ,p_pl_id_o =>ben_bei_shd.g_old_rec.pl_id
211: ,p_oipl_id_o =>ben_bei_shd.g_old_rec.oipl_id
212: ,p_elig_flag_o =>ben_bei_shd.g_old_rec.elig_flag
213: ,p_inelig_text_o =>ben_bei_shd.g_old_rec.inelig_text
214: ,p_business_group_id_o =>ben_bei_shd.g_old_rec.business_group_id
215: ,p_object_version_number_o=>ben_bei_shd.g_old_rec.object_version_number);
216: --

Line 213: ,p_inelig_text_o =>ben_bei_shd.g_old_rec.inelig_text

209: ,p_pgm_id_o =>ben_bei_shd.g_old_rec.pgm_id
210: ,p_pl_id_o =>ben_bei_shd.g_old_rec.pl_id
211: ,p_oipl_id_o =>ben_bei_shd.g_old_rec.oipl_id
212: ,p_elig_flag_o =>ben_bei_shd.g_old_rec.elig_flag
213: ,p_inelig_text_o =>ben_bei_shd.g_old_rec.inelig_text
214: ,p_business_group_id_o =>ben_bei_shd.g_old_rec.business_group_id
215: ,p_object_version_number_o=>ben_bei_shd.g_old_rec.object_version_number);
216: --
217: exception

Line 214: ,p_business_group_id_o =>ben_bei_shd.g_old_rec.business_group_id

210: ,p_pl_id_o =>ben_bei_shd.g_old_rec.pl_id
211: ,p_oipl_id_o =>ben_bei_shd.g_old_rec.oipl_id
212: ,p_elig_flag_o =>ben_bei_shd.g_old_rec.elig_flag
213: ,p_inelig_text_o =>ben_bei_shd.g_old_rec.inelig_text
214: ,p_business_group_id_o =>ben_bei_shd.g_old_rec.business_group_id
215: ,p_object_version_number_o=>ben_bei_shd.g_old_rec.object_version_number);
216: --
217: exception
218: --

Line 215: ,p_object_version_number_o=>ben_bei_shd.g_old_rec.object_version_number);

211: ,p_oipl_id_o =>ben_bei_shd.g_old_rec.oipl_id
212: ,p_elig_flag_o =>ben_bei_shd.g_old_rec.elig_flag
213: ,p_inelig_text_o =>ben_bei_shd.g_old_rec.inelig_text
214: ,p_business_group_id_o =>ben_bei_shd.g_old_rec.business_group_id
215: ,p_object_version_number_o=>ben_bei_shd.g_old_rec.object_version_number);
216: --
217: exception
218: --
219: when hr_api.cannot_find_prog_unit then

Line 276: Procedure convert_defs(p_rec in out nocopy ben_bei_shd.g_rec_type) is

272: -- Internal Row Handler Use Only.
273: --
274: -- {End Of Comments}
275: -- ----------------------------------------------------------------------------
276: Procedure convert_defs(p_rec in out nocopy ben_bei_shd.g_rec_type) is
277: --
278: l_proc varchar2(72) := g_package||'convert_defs';
279: --
280: Begin

Line 291: ben_bei_shd.g_old_rec.benefit_action_id;

287: -- is being used then we must set to the 'current' argument value.
288: --
289: If (p_rec.benefit_action_id = hr_api.g_number) then
290: p_rec.benefit_action_id :=
291: ben_bei_shd.g_old_rec.benefit_action_id;
292: End If;
293: If (p_rec.person_id = hr_api.g_number) then
294: p_rec.person_id :=
295: ben_bei_shd.g_old_rec.person_id;

Line 295: ben_bei_shd.g_old_rec.person_id;

291: ben_bei_shd.g_old_rec.benefit_action_id;
292: End If;
293: If (p_rec.person_id = hr_api.g_number) then
294: p_rec.person_id :=
295: ben_bei_shd.g_old_rec.person_id;
296: End If;
297: If (p_rec.pgm_id = hr_api.g_number) then
298: p_rec.pgm_id :=
299: ben_bei_shd.g_old_rec.pgm_id;

Line 299: ben_bei_shd.g_old_rec.pgm_id;

295: ben_bei_shd.g_old_rec.person_id;
296: End If;
297: If (p_rec.pgm_id = hr_api.g_number) then
298: p_rec.pgm_id :=
299: ben_bei_shd.g_old_rec.pgm_id;
300: End If;
301: If (p_rec.pl_id = hr_api.g_number) then
302: p_rec.pl_id :=
303: ben_bei_shd.g_old_rec.pl_id;

Line 303: ben_bei_shd.g_old_rec.pl_id;

299: ben_bei_shd.g_old_rec.pgm_id;
300: End If;
301: If (p_rec.pl_id = hr_api.g_number) then
302: p_rec.pl_id :=
303: ben_bei_shd.g_old_rec.pl_id;
304: End If;
305: If (p_rec.oipl_id = hr_api.g_number) then
306: p_rec.oipl_id :=
307: ben_bei_shd.g_old_rec.oipl_id;

Line 307: ben_bei_shd.g_old_rec.oipl_id;

303: ben_bei_shd.g_old_rec.pl_id;
304: End If;
305: If (p_rec.oipl_id = hr_api.g_number) then
306: p_rec.oipl_id :=
307: ben_bei_shd.g_old_rec.oipl_id;
308: End If;
309: If (p_rec.elig_flag = hr_api.g_varchar2) then
310: p_rec.elig_flag :=
311: ben_bei_shd.g_old_rec.elig_flag;

Line 311: ben_bei_shd.g_old_rec.elig_flag;

307: ben_bei_shd.g_old_rec.oipl_id;
308: End If;
309: If (p_rec.elig_flag = hr_api.g_varchar2) then
310: p_rec.elig_flag :=
311: ben_bei_shd.g_old_rec.elig_flag;
312: End If;
313: If (p_rec.inelig_text = hr_api.g_varchar2) then
314: p_rec.inelig_text :=
315: ben_bei_shd.g_old_rec.inelig_text;

Line 315: ben_bei_shd.g_old_rec.inelig_text;

311: ben_bei_shd.g_old_rec.elig_flag;
312: End If;
313: If (p_rec.inelig_text = hr_api.g_varchar2) then
314: p_rec.inelig_text :=
315: ben_bei_shd.g_old_rec.inelig_text;
316: End If;
317: If (p_rec.business_group_id = hr_api.g_number) then
318: p_rec.business_group_id :=
319: ben_bei_shd.g_old_rec.business_group_id;

Line 319: ben_bei_shd.g_old_rec.business_group_id;

315: ben_bei_shd.g_old_rec.inelig_text;
316: End If;
317: If (p_rec.business_group_id = hr_api.g_number) then
318: p_rec.business_group_id :=
319: ben_bei_shd.g_old_rec.business_group_id;
320: End If;
321:
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 333: p_rec in out nocopy ben_bei_shd.g_rec_type

329: -- ----------------------------------------------------------------------------
330: Procedure upd
331: (
332: p_effective_date in date,
333: p_rec in out nocopy ben_bei_shd.g_rec_type
334: ) is
335: --
336: l_proc varchar2(72) := g_package||'upd';
337: --

Line 343: ben_bei_shd.lck

339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: -- We must lock the row which we need to update.
342: --
343: ben_bei_shd.lck
344: (
345: p_rec.batch_elig_id,
346: p_rec.object_version_number
347: );

Line 390: l_rec ben_bei_shd.g_rec_type;

386: p_business_group_id in number default hr_api.g_number,
387: p_object_version_number in out nocopy number
388: ) is
389: --
390: l_rec ben_bei_shd.g_rec_type;
391: l_proc varchar2(72) := g_package||'upd';
392: --
393: Begin
394: hr_utility.set_location('Entering:'||l_proc, 5);

Line 400: ben_bei_shd.convert_args

396: -- Call conversion function to turn arguments into the
397: -- l_rec structure.
398: --
399: l_rec :=
400: ben_bei_shd.convert_args
401: (
402: p_batch_elig_id,
403: p_benefit_action_id,
404: p_person_id,