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_BAI_UPD dependencies on BEN_BAI_SHD

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

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

Line 83: ben_bai_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_actn_item_id = p_rec.batch_actn_item_id;
82: --
83: ben_bai_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_bai_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_bai_shd.g_api_dml := false; -- Unset the api dml status
91: ben_bai_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_bai_shd.constraint_error

87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: ben_bai_shd.g_api_dml := false; -- Unset the api dml status
91: ben_bai_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_bai_shd.g_api_dml := false; -- Unset the api dml status

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

91: ben_bai_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_bai_shd.g_api_dml := false; -- Unset the api dml status
96: ben_bai_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_bai_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_bai_shd.g_api_dml := false; -- Unset the api dml status
96: ben_bai_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_bai_shd.g_api_dml := false; -- Unset the api dml status

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

96: ben_bai_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_bai_shd.g_api_dml := false; -- Unset the api dml status
101: ben_bai_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: ben_bai_shd.g_api_dml := false; -- Unset the api dml status

Line 101: ben_bai_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_bai_shd.g_api_dml := false; -- Unset the api dml status
101: ben_bai_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: ben_bai_shd.g_api_dml := false; -- Unset the api dml status
105: Raise;

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

100: ben_bai_shd.g_api_dml := false; -- Unset the api dml status
101: ben_bai_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: ben_bai_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_bai_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_bai_shd.g_rec_type) is
141: --
142: l_proc varchar2(72) := g_package||'pre_update';
143: --
144: Begin

Line 183: p_effective_date in date,p_rec in ben_bai_shd.g_rec_type) is

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

Line 208: ,p_benefit_action_id_o =>ben_bai_shd.g_old_rec.benefit_action_id

204: ,p_actn_cd =>p_rec.actn_cd
205: ,p_business_group_id =>p_rec.business_group_id
206: ,p_object_version_number =>p_rec.object_version_number
207: ,p_effective_date =>p_effective_date
208: ,p_benefit_action_id_o =>ben_bai_shd.g_old_rec.benefit_action_id
209: ,p_person_id_o =>ben_bai_shd.g_old_rec.person_id
210: ,p_actn_typ_id_o =>ben_bai_shd.g_old_rec.actn_typ_id
211: ,p_cmpltd_dt_o =>ben_bai_shd.g_old_rec.cmpltd_dt
212: ,p_due_dt_o =>ben_bai_shd.g_old_rec.due_dt

Line 209: ,p_person_id_o =>ben_bai_shd.g_old_rec.person_id

205: ,p_business_group_id =>p_rec.business_group_id
206: ,p_object_version_number =>p_rec.object_version_number
207: ,p_effective_date =>p_effective_date
208: ,p_benefit_action_id_o =>ben_bai_shd.g_old_rec.benefit_action_id
209: ,p_person_id_o =>ben_bai_shd.g_old_rec.person_id
210: ,p_actn_typ_id_o =>ben_bai_shd.g_old_rec.actn_typ_id
211: ,p_cmpltd_dt_o =>ben_bai_shd.g_old_rec.cmpltd_dt
212: ,p_due_dt_o =>ben_bai_shd.g_old_rec.due_dt
213: ,p_rqd_flag_o =>ben_bai_shd.g_old_rec.rqd_flag

Line 210: ,p_actn_typ_id_o =>ben_bai_shd.g_old_rec.actn_typ_id

206: ,p_object_version_number =>p_rec.object_version_number
207: ,p_effective_date =>p_effective_date
208: ,p_benefit_action_id_o =>ben_bai_shd.g_old_rec.benefit_action_id
209: ,p_person_id_o =>ben_bai_shd.g_old_rec.person_id
210: ,p_actn_typ_id_o =>ben_bai_shd.g_old_rec.actn_typ_id
211: ,p_cmpltd_dt_o =>ben_bai_shd.g_old_rec.cmpltd_dt
212: ,p_due_dt_o =>ben_bai_shd.g_old_rec.due_dt
213: ,p_rqd_flag_o =>ben_bai_shd.g_old_rec.rqd_flag
214: ,p_actn_cd_o =>ben_bai_shd.g_old_rec.actn_cd

Line 211: ,p_cmpltd_dt_o =>ben_bai_shd.g_old_rec.cmpltd_dt

207: ,p_effective_date =>p_effective_date
208: ,p_benefit_action_id_o =>ben_bai_shd.g_old_rec.benefit_action_id
209: ,p_person_id_o =>ben_bai_shd.g_old_rec.person_id
210: ,p_actn_typ_id_o =>ben_bai_shd.g_old_rec.actn_typ_id
211: ,p_cmpltd_dt_o =>ben_bai_shd.g_old_rec.cmpltd_dt
212: ,p_due_dt_o =>ben_bai_shd.g_old_rec.due_dt
213: ,p_rqd_flag_o =>ben_bai_shd.g_old_rec.rqd_flag
214: ,p_actn_cd_o =>ben_bai_shd.g_old_rec.actn_cd
215: ,p_business_group_id_o =>ben_bai_shd.g_old_rec.business_group_id

Line 212: ,p_due_dt_o =>ben_bai_shd.g_old_rec.due_dt

208: ,p_benefit_action_id_o =>ben_bai_shd.g_old_rec.benefit_action_id
209: ,p_person_id_o =>ben_bai_shd.g_old_rec.person_id
210: ,p_actn_typ_id_o =>ben_bai_shd.g_old_rec.actn_typ_id
211: ,p_cmpltd_dt_o =>ben_bai_shd.g_old_rec.cmpltd_dt
212: ,p_due_dt_o =>ben_bai_shd.g_old_rec.due_dt
213: ,p_rqd_flag_o =>ben_bai_shd.g_old_rec.rqd_flag
214: ,p_actn_cd_o =>ben_bai_shd.g_old_rec.actn_cd
215: ,p_business_group_id_o =>ben_bai_shd.g_old_rec.business_group_id
216: ,p_object_version_number_o =>ben_bai_shd.g_old_rec.object_version_number

Line 213: ,p_rqd_flag_o =>ben_bai_shd.g_old_rec.rqd_flag

209: ,p_person_id_o =>ben_bai_shd.g_old_rec.person_id
210: ,p_actn_typ_id_o =>ben_bai_shd.g_old_rec.actn_typ_id
211: ,p_cmpltd_dt_o =>ben_bai_shd.g_old_rec.cmpltd_dt
212: ,p_due_dt_o =>ben_bai_shd.g_old_rec.due_dt
213: ,p_rqd_flag_o =>ben_bai_shd.g_old_rec.rqd_flag
214: ,p_actn_cd_o =>ben_bai_shd.g_old_rec.actn_cd
215: ,p_business_group_id_o =>ben_bai_shd.g_old_rec.business_group_id
216: ,p_object_version_number_o =>ben_bai_shd.g_old_rec.object_version_number
217: );

Line 214: ,p_actn_cd_o =>ben_bai_shd.g_old_rec.actn_cd

210: ,p_actn_typ_id_o =>ben_bai_shd.g_old_rec.actn_typ_id
211: ,p_cmpltd_dt_o =>ben_bai_shd.g_old_rec.cmpltd_dt
212: ,p_due_dt_o =>ben_bai_shd.g_old_rec.due_dt
213: ,p_rqd_flag_o =>ben_bai_shd.g_old_rec.rqd_flag
214: ,p_actn_cd_o =>ben_bai_shd.g_old_rec.actn_cd
215: ,p_business_group_id_o =>ben_bai_shd.g_old_rec.business_group_id
216: ,p_object_version_number_o =>ben_bai_shd.g_old_rec.object_version_number
217: );
218: --

Line 215: ,p_business_group_id_o =>ben_bai_shd.g_old_rec.business_group_id

211: ,p_cmpltd_dt_o =>ben_bai_shd.g_old_rec.cmpltd_dt
212: ,p_due_dt_o =>ben_bai_shd.g_old_rec.due_dt
213: ,p_rqd_flag_o =>ben_bai_shd.g_old_rec.rqd_flag
214: ,p_actn_cd_o =>ben_bai_shd.g_old_rec.actn_cd
215: ,p_business_group_id_o =>ben_bai_shd.g_old_rec.business_group_id
216: ,p_object_version_number_o =>ben_bai_shd.g_old_rec.object_version_number
217: );
218: --
219: exception

Line 216: ,p_object_version_number_o =>ben_bai_shd.g_old_rec.object_version_number

212: ,p_due_dt_o =>ben_bai_shd.g_old_rec.due_dt
213: ,p_rqd_flag_o =>ben_bai_shd.g_old_rec.rqd_flag
214: ,p_actn_cd_o =>ben_bai_shd.g_old_rec.actn_cd
215: ,p_business_group_id_o =>ben_bai_shd.g_old_rec.business_group_id
216: ,p_object_version_number_o =>ben_bai_shd.g_old_rec.object_version_number
217: );
218: --
219: exception
220: --

Line 278: Procedure convert_defs(p_rec in out nocopy ben_bai_shd.g_rec_type) is

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

Line 293: ben_bai_shd.g_old_rec.benefit_action_id;

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

Line 297: ben_bai_shd.g_old_rec.person_id;

293: ben_bai_shd.g_old_rec.benefit_action_id;
294: End If;
295: If (p_rec.person_id = hr_api.g_number) then
296: p_rec.person_id :=
297: ben_bai_shd.g_old_rec.person_id;
298: End If;
299: If (p_rec.actn_typ_id = hr_api.g_number) then
300: p_rec.actn_typ_id :=
301: ben_bai_shd.g_old_rec.actn_typ_id;

Line 301: ben_bai_shd.g_old_rec.actn_typ_id;

297: ben_bai_shd.g_old_rec.person_id;
298: End If;
299: If (p_rec.actn_typ_id = hr_api.g_number) then
300: p_rec.actn_typ_id :=
301: ben_bai_shd.g_old_rec.actn_typ_id;
302: End If;
303: If (p_rec.cmpltd_dt = hr_api.g_date) then
304: p_rec.cmpltd_dt :=
305: ben_bai_shd.g_old_rec.cmpltd_dt;

Line 305: ben_bai_shd.g_old_rec.cmpltd_dt;

301: ben_bai_shd.g_old_rec.actn_typ_id;
302: End If;
303: If (p_rec.cmpltd_dt = hr_api.g_date) then
304: p_rec.cmpltd_dt :=
305: ben_bai_shd.g_old_rec.cmpltd_dt;
306: End If;
307: If (p_rec.due_dt = hr_api.g_date) then
308: p_rec.due_dt :=
309: ben_bai_shd.g_old_rec.due_dt;

Line 309: ben_bai_shd.g_old_rec.due_dt;

305: ben_bai_shd.g_old_rec.cmpltd_dt;
306: End If;
307: If (p_rec.due_dt = hr_api.g_date) then
308: p_rec.due_dt :=
309: ben_bai_shd.g_old_rec.due_dt;
310: End If;
311: If (p_rec.rqd_flag = hr_api.g_varchar2) then
312: p_rec.rqd_flag :=
313: ben_bai_shd.g_old_rec.rqd_flag;

Line 313: ben_bai_shd.g_old_rec.rqd_flag;

309: ben_bai_shd.g_old_rec.due_dt;
310: End If;
311: If (p_rec.rqd_flag = hr_api.g_varchar2) then
312: p_rec.rqd_flag :=
313: ben_bai_shd.g_old_rec.rqd_flag;
314: End If;
315: If (p_rec.actn_cd = hr_api.g_varchar2) then
316: p_rec.actn_cd :=
317: ben_bai_shd.g_old_rec.actn_cd;

Line 317: ben_bai_shd.g_old_rec.actn_cd;

313: ben_bai_shd.g_old_rec.rqd_flag;
314: End If;
315: If (p_rec.actn_cd = hr_api.g_varchar2) then
316: p_rec.actn_cd :=
317: ben_bai_shd.g_old_rec.actn_cd;
318: End If;
319: If (p_rec.business_group_id = hr_api.g_number) then
320: p_rec.business_group_id :=
321: ben_bai_shd.g_old_rec.business_group_id;

Line 321: ben_bai_shd.g_old_rec.business_group_id;

317: ben_bai_shd.g_old_rec.actn_cd;
318: End If;
319: If (p_rec.business_group_id = hr_api.g_number) then
320: p_rec.business_group_id :=
321: ben_bai_shd.g_old_rec.business_group_id;
322: End If;
323:
324: --
325: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 335: p_rec in out nocopy ben_bai_shd.g_rec_type

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

Line 345: ben_bai_shd.lck

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

Line 393: l_rec ben_bai_shd.g_rec_type;

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

Line 403: ben_bai_shd.convert_args

399: -- Call conversion function to turn arguments into the
400: -- l_rec structure.
401: --
402: l_rec :=
403: ben_bai_shd.convert_args
404: (
405: p_batch_actn_item_id,
406: p_benefit_action_id,
407: p_person_id,