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_BPI_UPD dependencies on HR_API

Line 92: When hr_api.check_integrity_violated Then

88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 10);
90: --
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: ben_bpi_shd.g_api_dml := false; -- Unset the api dml status
95: ben_bpi_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

Line 97: When hr_api.parent_integrity_violated Then

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

Line 101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

Line 102: When hr_api.unique_integrity_violated Then

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

Line 106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

Line 230: when hr_api.cannot_find_prog_unit then

226: );
227: --
228: exception
229: --
230: when hr_api.cannot_find_prog_unit then
231: --
232: hr_api.cannot_find_prog_unit_error
233: (p_module_name => 'ben_batch_proc_info'
234: ,p_hook_type => 'AU');

Line 232: hr_api.cannot_find_prog_unit_error

228: exception
229: --
230: when hr_api.cannot_find_prog_unit then
231: --
232: hr_api.cannot_find_prog_unit_error
233: (p_module_name => 'ben_batch_proc_info'
234: ,p_hook_type => 'AU');
235: --
236: end;

Line 300: If (p_rec.benefit_action_id = hr_api.g_number) then

296: -- p_rec plsql record structure
297: -- to see if a system default is being used. If a system default
298: -- is being used then we must set to the 'current' argument value.
299: --
300: If (p_rec.benefit_action_id = hr_api.g_number) then
301: p_rec.benefit_action_id :=
302: ben_bpi_shd.g_old_rec.benefit_action_id;
303: End If;
304: If (p_rec.strt_dt = hr_api.g_date) then

Line 304: If (p_rec.strt_dt = hr_api.g_date) then

300: If (p_rec.benefit_action_id = hr_api.g_number) then
301: p_rec.benefit_action_id :=
302: ben_bpi_shd.g_old_rec.benefit_action_id;
303: End If;
304: If (p_rec.strt_dt = hr_api.g_date) then
305: p_rec.strt_dt :=
306: ben_bpi_shd.g_old_rec.strt_dt;
307: End If;
308: If (p_rec.end_dt = hr_api.g_date) then

Line 308: If (p_rec.end_dt = hr_api.g_date) then

304: If (p_rec.strt_dt = hr_api.g_date) then
305: p_rec.strt_dt :=
306: ben_bpi_shd.g_old_rec.strt_dt;
307: End If;
308: If (p_rec.end_dt = hr_api.g_date) then
309: p_rec.end_dt :=
310: ben_bpi_shd.g_old_rec.end_dt;
311: End If;
312: If (p_rec.strt_tm = hr_api.g_varchar2) then

Line 312: If (p_rec.strt_tm = hr_api.g_varchar2) then

308: If (p_rec.end_dt = hr_api.g_date) then
309: p_rec.end_dt :=
310: ben_bpi_shd.g_old_rec.end_dt;
311: End If;
312: If (p_rec.strt_tm = hr_api.g_varchar2) then
313: p_rec.strt_tm :=
314: ben_bpi_shd.g_old_rec.strt_tm;
315: End If;
316: If (p_rec.end_tm = hr_api.g_varchar2) then

Line 316: If (p_rec.end_tm = hr_api.g_varchar2) then

312: If (p_rec.strt_tm = hr_api.g_varchar2) then
313: p_rec.strt_tm :=
314: ben_bpi_shd.g_old_rec.strt_tm;
315: End If;
316: If (p_rec.end_tm = hr_api.g_varchar2) then
317: p_rec.end_tm :=
318: ben_bpi_shd.g_old_rec.end_tm;
319: End If;
320: If (p_rec.elpsd_tm = hr_api.g_varchar2) then

Line 320: If (p_rec.elpsd_tm = hr_api.g_varchar2) then

316: If (p_rec.end_tm = hr_api.g_varchar2) then
317: p_rec.end_tm :=
318: ben_bpi_shd.g_old_rec.end_tm;
319: End If;
320: If (p_rec.elpsd_tm = hr_api.g_varchar2) then
321: p_rec.elpsd_tm :=
322: ben_bpi_shd.g_old_rec.elpsd_tm;
323: End If;
324: If (p_rec.per_slctd = hr_api.g_number) then

Line 324: If (p_rec.per_slctd = hr_api.g_number) then

320: If (p_rec.elpsd_tm = hr_api.g_varchar2) then
321: p_rec.elpsd_tm :=
322: ben_bpi_shd.g_old_rec.elpsd_tm;
323: End If;
324: If (p_rec.per_slctd = hr_api.g_number) then
325: p_rec.per_slctd :=
326: ben_bpi_shd.g_old_rec.per_slctd;
327: End If;
328: If (p_rec.per_proc = hr_api.g_number) then

Line 328: If (p_rec.per_proc = hr_api.g_number) then

324: If (p_rec.per_slctd = hr_api.g_number) then
325: p_rec.per_slctd :=
326: ben_bpi_shd.g_old_rec.per_slctd;
327: End If;
328: If (p_rec.per_proc = hr_api.g_number) then
329: p_rec.per_proc :=
330: ben_bpi_shd.g_old_rec.per_proc;
331: End If;
332: If (p_rec.per_unproc = hr_api.g_number) then

Line 332: If (p_rec.per_unproc = hr_api.g_number) then

328: If (p_rec.per_proc = hr_api.g_number) then
329: p_rec.per_proc :=
330: ben_bpi_shd.g_old_rec.per_proc;
331: End If;
332: If (p_rec.per_unproc = hr_api.g_number) then
333: p_rec.per_unproc :=
334: ben_bpi_shd.g_old_rec.per_unproc;
335: End If;
336: If (p_rec.per_proc_succ = hr_api.g_number) then

Line 336: If (p_rec.per_proc_succ = hr_api.g_number) then

332: If (p_rec.per_unproc = hr_api.g_number) then
333: p_rec.per_unproc :=
334: ben_bpi_shd.g_old_rec.per_unproc;
335: End If;
336: If (p_rec.per_proc_succ = hr_api.g_number) then
337: p_rec.per_proc_succ :=
338: ben_bpi_shd.g_old_rec.per_proc_succ ;
339: End If;
340: If (p_rec.per_err = hr_api.g_number) then

Line 340: If (p_rec.per_err = hr_api.g_number) then

336: If (p_rec.per_proc_succ = hr_api.g_number) then
337: p_rec.per_proc_succ :=
338: ben_bpi_shd.g_old_rec.per_proc_succ ;
339: End If;
340: If (p_rec.per_err = hr_api.g_number) then
341: p_rec.per_err :=
342: ben_bpi_shd.g_old_rec.per_err;
343: End If;
344: If (p_rec.business_group_id = hr_api.g_number) then

Line 344: If (p_rec.business_group_id = hr_api.g_number) then

340: If (p_rec.per_err = hr_api.g_number) then
341: p_rec.per_err :=
342: ben_bpi_shd.g_old_rec.per_err;
343: End If;
344: If (p_rec.business_group_id = hr_api.g_number) then
345: p_rec.business_group_id :=
346: ben_bpi_shd.g_old_rec.business_group_id;
347: End If;
348:

Line 403: p_benefit_action_id in number default hr_api.g_number,

399: -- ----------------------------------------------------------------------------
400: Procedure upd
401: (
402: p_batch_proc_id in number,
403: p_benefit_action_id in number default hr_api.g_number,
404: p_strt_dt in date default hr_api.g_date,
405: p_end_dt in date default hr_api.g_date,
406: p_strt_tm in varchar2 default hr_api.g_varchar2,
407: p_end_tm in varchar2 default hr_api.g_varchar2,

Line 404: p_strt_dt in date default hr_api.g_date,

400: Procedure upd
401: (
402: p_batch_proc_id in number,
403: p_benefit_action_id in number default hr_api.g_number,
404: p_strt_dt in date default hr_api.g_date,
405: p_end_dt in date default hr_api.g_date,
406: p_strt_tm in varchar2 default hr_api.g_varchar2,
407: p_end_tm in varchar2 default hr_api.g_varchar2,
408: p_elpsd_tm in varchar2 default hr_api.g_varchar2,

Line 405: p_end_dt in date default hr_api.g_date,

401: (
402: p_batch_proc_id in number,
403: p_benefit_action_id in number default hr_api.g_number,
404: p_strt_dt in date default hr_api.g_date,
405: p_end_dt in date default hr_api.g_date,
406: p_strt_tm in varchar2 default hr_api.g_varchar2,
407: p_end_tm in varchar2 default hr_api.g_varchar2,
408: p_elpsd_tm in varchar2 default hr_api.g_varchar2,
409: p_per_slctd in number default hr_api.g_number,

Line 406: p_strt_tm in varchar2 default hr_api.g_varchar2,

402: p_batch_proc_id in number,
403: p_benefit_action_id in number default hr_api.g_number,
404: p_strt_dt in date default hr_api.g_date,
405: p_end_dt in date default hr_api.g_date,
406: p_strt_tm in varchar2 default hr_api.g_varchar2,
407: p_end_tm in varchar2 default hr_api.g_varchar2,
408: p_elpsd_tm in varchar2 default hr_api.g_varchar2,
409: p_per_slctd in number default hr_api.g_number,
410: p_per_proc in number default hr_api.g_number,

Line 407: p_end_tm in varchar2 default hr_api.g_varchar2,

403: p_benefit_action_id in number default hr_api.g_number,
404: p_strt_dt in date default hr_api.g_date,
405: p_end_dt in date default hr_api.g_date,
406: p_strt_tm in varchar2 default hr_api.g_varchar2,
407: p_end_tm in varchar2 default hr_api.g_varchar2,
408: p_elpsd_tm in varchar2 default hr_api.g_varchar2,
409: p_per_slctd in number default hr_api.g_number,
410: p_per_proc in number default hr_api.g_number,
411: p_per_unproc in number default hr_api.g_number,

Line 408: p_elpsd_tm in varchar2 default hr_api.g_varchar2,

404: p_strt_dt in date default hr_api.g_date,
405: p_end_dt in date default hr_api.g_date,
406: p_strt_tm in varchar2 default hr_api.g_varchar2,
407: p_end_tm in varchar2 default hr_api.g_varchar2,
408: p_elpsd_tm in varchar2 default hr_api.g_varchar2,
409: p_per_slctd in number default hr_api.g_number,
410: p_per_proc in number default hr_api.g_number,
411: p_per_unproc in number default hr_api.g_number,
412: p_per_proc_succ in number default hr_api.g_number,

Line 409: p_per_slctd in number default hr_api.g_number,

405: p_end_dt in date default hr_api.g_date,
406: p_strt_tm in varchar2 default hr_api.g_varchar2,
407: p_end_tm in varchar2 default hr_api.g_varchar2,
408: p_elpsd_tm in varchar2 default hr_api.g_varchar2,
409: p_per_slctd in number default hr_api.g_number,
410: p_per_proc in number default hr_api.g_number,
411: p_per_unproc in number default hr_api.g_number,
412: p_per_proc_succ in number default hr_api.g_number,
413: p_per_err in number default hr_api.g_number,

Line 410: p_per_proc in number default hr_api.g_number,

406: p_strt_tm in varchar2 default hr_api.g_varchar2,
407: p_end_tm in varchar2 default hr_api.g_varchar2,
408: p_elpsd_tm in varchar2 default hr_api.g_varchar2,
409: p_per_slctd in number default hr_api.g_number,
410: p_per_proc in number default hr_api.g_number,
411: p_per_unproc in number default hr_api.g_number,
412: p_per_proc_succ in number default hr_api.g_number,
413: p_per_err in number default hr_api.g_number,
414: p_business_group_id in number default hr_api.g_number,

Line 411: p_per_unproc in number default hr_api.g_number,

407: p_end_tm in varchar2 default hr_api.g_varchar2,
408: p_elpsd_tm in varchar2 default hr_api.g_varchar2,
409: p_per_slctd in number default hr_api.g_number,
410: p_per_proc in number default hr_api.g_number,
411: p_per_unproc in number default hr_api.g_number,
412: p_per_proc_succ in number default hr_api.g_number,
413: p_per_err in number default hr_api.g_number,
414: p_business_group_id in number default hr_api.g_number,
415: p_object_version_number in out nocopy number

Line 412: p_per_proc_succ in number default hr_api.g_number,

408: p_elpsd_tm in varchar2 default hr_api.g_varchar2,
409: p_per_slctd in number default hr_api.g_number,
410: p_per_proc in number default hr_api.g_number,
411: p_per_unproc in number default hr_api.g_number,
412: p_per_proc_succ in number default hr_api.g_number,
413: p_per_err in number default hr_api.g_number,
414: p_business_group_id in number default hr_api.g_number,
415: p_object_version_number in out nocopy number
416: ) is

Line 413: p_per_err in number default hr_api.g_number,

409: p_per_slctd in number default hr_api.g_number,
410: p_per_proc in number default hr_api.g_number,
411: p_per_unproc in number default hr_api.g_number,
412: p_per_proc_succ in number default hr_api.g_number,
413: p_per_err in number default hr_api.g_number,
414: p_business_group_id in number default hr_api.g_number,
415: p_object_version_number in out nocopy number
416: ) is
417: --

Line 414: p_business_group_id in number default hr_api.g_number,

410: p_per_proc in number default hr_api.g_number,
411: p_per_unproc in number default hr_api.g_number,
412: p_per_proc_succ in number default hr_api.g_number,
413: p_per_err in number default hr_api.g_number,
414: p_business_group_id in number default hr_api.g_number,
415: p_object_version_number in out nocopy number
416: ) is
417: --
418: l_rec ben_bpi_shd.g_rec_type;