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_BMN_UPD dependencies on BEN_BMN_SHD

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

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

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

91: yr_num = p_rec.yr_num,
92: object_version_number = p_rec.object_version_number
93: where reporting_id = p_rec.reporting_id;
94: --
95: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
96: --
97: hr_utility.set_location(' Leaving:'||l_proc, 10);
98: --
99: Exception

Line 102: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status

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

Line 103: ben_bmn_shd.constraint_error

99: Exception
100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
102: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
103: ben_bmn_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.parent_integrity_violated Then
106: -- Parent integrity has been violated
107: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status

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

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

Line 108: ben_bmn_shd.constraint_error

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

Line 112: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status

108: ben_bmn_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
113: ben_bmn_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When Others Then
116: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status

Line 113: ben_bmn_shd.constraint_error

109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
113: ben_bmn_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When Others Then
116: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
117: Raise;

Line 116: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status

112: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
113: ben_bmn_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When Others Then
116: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
117: Raise;
118: End update_dml;
119: --
120: -- ----------------------------------------------------------------------------

Line 152: Procedure pre_update(p_rec in ben_bmn_shd.g_rec_type) is

148: -- Internal Row Handler Use Only.
149: --
150: -- {End Of Comments}
151: -- ----------------------------------------------------------------------------
152: Procedure pre_update(p_rec in ben_bmn_shd.g_rec_type) is
153: --
154: l_proc varchar2(72) := g_package||'pre_update';
155: --
156: Begin

Line 194: Procedure post_update(p_rec in ben_bmn_shd.g_rec_type) is

190: -- Internal Row Handler Use Only.
191: --
192: -- {End Of Comments}
193: -- ----------------------------------------------------------------------------
194: Procedure post_update(p_rec in ben_bmn_shd.g_rec_type) is
195: --
196: l_proc varchar2(72) := g_package||'post_update';
197: --
198: Begin

Line 247: Procedure convert_defs(p_rec in out nocopy ben_bmn_shd.g_rec_type) is

243: -- Internal Row Handler Use Only.
244: --
245: -- {End Of Comments}
246: -- ----------------------------------------------------------------------------
247: Procedure convert_defs(p_rec in out nocopy ben_bmn_shd.g_rec_type) is
248: --
249: l_proc varchar2(72) := g_package||'convert_defs';
250: --
251: Begin

Line 262: ben_bmn_shd.g_old_rec.benefit_action_id;

258: -- is being used then we must set to the 'current' argument value.
259: --
260: If (p_rec.benefit_action_id = hr_api.g_number) then
261: p_rec.benefit_action_id :=
262: ben_bmn_shd.g_old_rec.benefit_action_id;
263: End If;
264: If (p_rec.thread_id = hr_api.g_number) then
265: p_rec.thread_id :=
266: ben_bmn_shd.g_old_rec.thread_id;

Line 266: ben_bmn_shd.g_old_rec.thread_id;

262: ben_bmn_shd.g_old_rec.benefit_action_id;
263: End If;
264: If (p_rec.thread_id = hr_api.g_number) then
265: p_rec.thread_id :=
266: ben_bmn_shd.g_old_rec.thread_id;
267: End If;
268: If (p_rec.sequence = hr_api.g_number) then
269: p_rec.sequence :=
270: ben_bmn_shd.g_old_rec.sequence;

Line 270: ben_bmn_shd.g_old_rec.sequence;

266: ben_bmn_shd.g_old_rec.thread_id;
267: End If;
268: If (p_rec.sequence = hr_api.g_number) then
269: p_rec.sequence :=
270: ben_bmn_shd.g_old_rec.sequence;
271: End If;
272: If (p_rec.rep_typ_cd = hr_api.g_varchar2) then
273: p_rec.rep_typ_cd :=
274: ben_bmn_shd.g_old_rec.rep_typ_cd;

Line 274: ben_bmn_shd.g_old_rec.rep_typ_cd;

270: ben_bmn_shd.g_old_rec.sequence;
271: End If;
272: If (p_rec.rep_typ_cd = hr_api.g_varchar2) then
273: p_rec.rep_typ_cd :=
274: ben_bmn_shd.g_old_rec.rep_typ_cd;
275: End If;
276: If (p_rec.error_message_code = hr_api.g_varchar2) then
277: p_rec.error_message_code :=
278: ben_bmn_shd.g_old_rec.error_message_code;

Line 278: ben_bmn_shd.g_old_rec.error_message_code;

274: ben_bmn_shd.g_old_rec.rep_typ_cd;
275: End If;
276: If (p_rec.error_message_code = hr_api.g_varchar2) then
277: p_rec.error_message_code :=
278: ben_bmn_shd.g_old_rec.error_message_code;
279: End If;
280: If (p_rec.national_identifier = hr_api.g_varchar2) then
281: p_rec.national_identifier :=
282: ben_bmn_shd.g_old_rec.national_identifier;

Line 282: ben_bmn_shd.g_old_rec.national_identifier;

278: ben_bmn_shd.g_old_rec.error_message_code;
279: End If;
280: If (p_rec.national_identifier = hr_api.g_varchar2) then
281: p_rec.national_identifier :=
282: ben_bmn_shd.g_old_rec.national_identifier;
283: End If;
284: If (p_rec.related_person_ler_id = hr_api.g_number) then
285: p_rec.related_person_ler_id :=
286: ben_bmn_shd.g_old_rec.related_person_ler_id;

Line 286: ben_bmn_shd.g_old_rec.related_person_ler_id;

282: ben_bmn_shd.g_old_rec.national_identifier;
283: End If;
284: If (p_rec.related_person_ler_id = hr_api.g_number) then
285: p_rec.related_person_ler_id :=
286: ben_bmn_shd.g_old_rec.related_person_ler_id;
287: End If;
288: If (p_rec.temporal_ler_id = hr_api.g_number) then
289: p_rec.temporal_ler_id :=
290: ben_bmn_shd.g_old_rec.temporal_ler_id;

Line 290: ben_bmn_shd.g_old_rec.temporal_ler_id;

286: ben_bmn_shd.g_old_rec.related_person_ler_id;
287: End If;
288: If (p_rec.temporal_ler_id = hr_api.g_number) then
289: p_rec.temporal_ler_id :=
290: ben_bmn_shd.g_old_rec.temporal_ler_id;
291: End If;
292: If (p_rec.ler_id = hr_api.g_number) then
293: p_rec.ler_id :=
294: ben_bmn_shd.g_old_rec.ler_id;

Line 294: ben_bmn_shd.g_old_rec.ler_id;

290: ben_bmn_shd.g_old_rec.temporal_ler_id;
291: End If;
292: If (p_rec.ler_id = hr_api.g_number) then
293: p_rec.ler_id :=
294: ben_bmn_shd.g_old_rec.ler_id;
295: End If;
296: If (p_rec.person_id = hr_api.g_number) then
297: p_rec.person_id :=
298: ben_bmn_shd.g_old_rec.person_id;

Line 298: ben_bmn_shd.g_old_rec.person_id;

294: ben_bmn_shd.g_old_rec.ler_id;
295: End If;
296: If (p_rec.person_id = hr_api.g_number) then
297: p_rec.person_id :=
298: ben_bmn_shd.g_old_rec.person_id;
299: End If;
300: If (p_rec.pgm_id = hr_api.g_number) then
301: p_rec.pgm_id :=
302: ben_bmn_shd.g_old_rec.pgm_id;

Line 302: ben_bmn_shd.g_old_rec.pgm_id;

298: ben_bmn_shd.g_old_rec.person_id;
299: End If;
300: If (p_rec.pgm_id = hr_api.g_number) then
301: p_rec.pgm_id :=
302: ben_bmn_shd.g_old_rec.pgm_id;
303: End If;
304: If (p_rec.pl_id = hr_api.g_number) then
305: p_rec.pl_id :=
306: ben_bmn_shd.g_old_rec.pl_id;

Line 306: ben_bmn_shd.g_old_rec.pl_id;

302: ben_bmn_shd.g_old_rec.pgm_id;
303: End If;
304: If (p_rec.pl_id = hr_api.g_number) then
305: p_rec.pl_id :=
306: ben_bmn_shd.g_old_rec.pl_id;
307: End If;
308: If (p_rec.related_person_id = hr_api.g_number) then
309: p_rec.related_person_id :=
310: ben_bmn_shd.g_old_rec.related_person_id;

Line 310: ben_bmn_shd.g_old_rec.related_person_id;

306: ben_bmn_shd.g_old_rec.pl_id;
307: End If;
308: If (p_rec.related_person_id = hr_api.g_number) then
309: p_rec.related_person_id :=
310: ben_bmn_shd.g_old_rec.related_person_id;
311: End If;
312: If (p_rec.oipl_id = hr_api.g_number) then
313: p_rec.oipl_id :=
314: ben_bmn_shd.g_old_rec.oipl_id;

Line 314: ben_bmn_shd.g_old_rec.oipl_id;

310: ben_bmn_shd.g_old_rec.related_person_id;
311: End If;
312: If (p_rec.oipl_id = hr_api.g_number) then
313: p_rec.oipl_id :=
314: ben_bmn_shd.g_old_rec.oipl_id;
315: End If;
316: If (p_rec.pl_typ_id = hr_api.g_number) then
317: p_rec.pl_typ_id :=
318: ben_bmn_shd.g_old_rec.pl_typ_id;

Line 318: ben_bmn_shd.g_old_rec.pl_typ_id;

314: ben_bmn_shd.g_old_rec.oipl_id;
315: End If;
316: If (p_rec.pl_typ_id = hr_api.g_number) then
317: p_rec.pl_typ_id :=
318: ben_bmn_shd.g_old_rec.pl_typ_id;
319: End If;
320:
321: If (p_rec.actl_prem_id = hr_api.g_number) then
322: p_rec.actl_prem_id :=

Line 323: ben_bmn_shd.g_old_rec.actl_prem_id;

319: End If;
320:
321: If (p_rec.actl_prem_id = hr_api.g_number) then
322: p_rec.actl_prem_id :=
323: ben_bmn_shd.g_old_rec.actl_prem_id;
324: End If;
325: If (p_rec.val = hr_api.g_number) then
326: p_rec.val :=
327: ben_bmn_shd.g_old_rec.val;

Line 327: ben_bmn_shd.g_old_rec.val;

323: ben_bmn_shd.g_old_rec.actl_prem_id;
324: End If;
325: If (p_rec.val = hr_api.g_number) then
326: p_rec.val :=
327: ben_bmn_shd.g_old_rec.val;
328: End If;
329: If (p_rec.mo_num = hr_api.g_number) then
330: p_rec.mo_num :=
331: ben_bmn_shd.g_old_rec.mo_num;

Line 331: ben_bmn_shd.g_old_rec.mo_num;

327: ben_bmn_shd.g_old_rec.val;
328: End If;
329: If (p_rec.mo_num = hr_api.g_number) then
330: p_rec.mo_num :=
331: ben_bmn_shd.g_old_rec.mo_num;
332: End If;
333: If (p_rec.yr_num = hr_api.g_number) then
334: p_rec.yr_num :=
335: ben_bmn_shd.g_old_rec.yr_num;

Line 335: ben_bmn_shd.g_old_rec.yr_num;

331: ben_bmn_shd.g_old_rec.mo_num;
332: End If;
333: If (p_rec.yr_num = hr_api.g_number) then
334: p_rec.yr_num :=
335: ben_bmn_shd.g_old_rec.yr_num;
336: End If;
337:
338:
339: If (p_rec.text = hr_api.g_varchar2) then

Line 341: ben_bmn_shd.g_old_rec.text;

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

Line 354: p_rec in out nocopy ben_bmn_shd.g_rec_type

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

Line 364: ben_bmn_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_bmn_shd.lck
365: (
366: p_rec.reporting_id,
367: p_rec.object_version_number
368: );

Line 421: l_rec ben_bmn_shd.g_rec_type;

417: p_yr_num in number default hr_api.g_number,
418: p_object_version_number in out nocopy number
419: ) is
420: --
421: l_rec ben_bmn_shd.g_rec_type;
422: l_proc varchar2(72) := g_package||'upd';
423: --
424: Begin
425: hr_utility.set_location('Entering:'||l_proc, 5);

Line 431: ben_bmn_shd.convert_args

427: -- Call conversion function to turn arguments into the
428: -- l_rec structure.
429: --
430: l_rec :=
431: ben_bmn_shd.convert_args
432: (
433: p_reporting_id,
434: p_benefit_action_id,
435: p_thread_id,