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

Line 99: When hr_api.check_integrity_violated Then

95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 10);
97: --
98: Exception
99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: ben_xrs_shd.g_api_dml := false; -- Unset the api dml status
102: ben_xrs_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 104: When hr_api.parent_integrity_violated Then

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

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

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

Line 109: When hr_api.unique_integrity_violated Then

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

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

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

Line 254: when hr_api.cannot_find_prog_unit then

250: );
251: --
252: exception
253: --
254: when hr_api.cannot_find_prog_unit then
255: --
256: hr_api.cannot_find_prog_unit_error
257: (p_module_name => 'ben_ext_rslt'
258: ,p_hook_type => 'AU');

Line 256: hr_api.cannot_find_prog_unit_error

252: exception
253: --
254: when hr_api.cannot_find_prog_unit then
255: --
256: hr_api.cannot_find_prog_unit_error
257: (p_module_name => 'ben_ext_rslt'
258: ,p_hook_type => 'AU');
259: --
260: end;

Line 324: If (p_rec.run_strt_dt = hr_api.g_date) then

320: -- p_rec plsql record structure
321: -- to see if a system default is being used. If a system default
322: -- is being used then we must set to the 'current' argument value.
323: --
324: If (p_rec.run_strt_dt = hr_api.g_date) then
325: p_rec.run_strt_dt :=
326: ben_xrs_shd.g_old_rec.run_strt_dt;
327: End If;
328: If (p_rec.run_end_dt = hr_api.g_date) then

Line 328: If (p_rec.run_end_dt = hr_api.g_date) then

324: If (p_rec.run_strt_dt = hr_api.g_date) then
325: p_rec.run_strt_dt :=
326: ben_xrs_shd.g_old_rec.run_strt_dt;
327: End If;
328: If (p_rec.run_end_dt = hr_api.g_date) then
329: p_rec.run_end_dt :=
330: ben_xrs_shd.g_old_rec.run_end_dt;
331: End If;
332: If (p_rec.ext_stat_cd = hr_api.g_varchar2) then

Line 332: If (p_rec.ext_stat_cd = hr_api.g_varchar2) then

328: If (p_rec.run_end_dt = hr_api.g_date) then
329: p_rec.run_end_dt :=
330: ben_xrs_shd.g_old_rec.run_end_dt;
331: End If;
332: If (p_rec.ext_stat_cd = hr_api.g_varchar2) then
333: p_rec.ext_stat_cd :=
334: ben_xrs_shd.g_old_rec.ext_stat_cd;
335: End If;
336: If (p_rec.tot_rec_num = hr_api.g_number) then

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

332: If (p_rec.ext_stat_cd = hr_api.g_varchar2) then
333: p_rec.ext_stat_cd :=
334: ben_xrs_shd.g_old_rec.ext_stat_cd;
335: End If;
336: If (p_rec.tot_rec_num = hr_api.g_number) then
337: p_rec.tot_rec_num :=
338: ben_xrs_shd.g_old_rec.tot_rec_num;
339: End If;
340: If (p_rec.tot_per_num = hr_api.g_number) then

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

336: If (p_rec.tot_rec_num = hr_api.g_number) then
337: p_rec.tot_rec_num :=
338: ben_xrs_shd.g_old_rec.tot_rec_num;
339: End If;
340: If (p_rec.tot_per_num = hr_api.g_number) then
341: p_rec.tot_per_num :=
342: ben_xrs_shd.g_old_rec.tot_per_num;
343: End If;
344: If (p_rec.tot_err_num = hr_api.g_number) then

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

340: If (p_rec.tot_per_num = hr_api.g_number) then
341: p_rec.tot_per_num :=
342: ben_xrs_shd.g_old_rec.tot_per_num;
343: End If;
344: If (p_rec.tot_err_num = hr_api.g_number) then
345: p_rec.tot_err_num :=
346: ben_xrs_shd.g_old_rec.tot_err_num;
347: End If;
348: If (p_rec.eff_dt = hr_api.g_date) then

Line 348: If (p_rec.eff_dt = hr_api.g_date) then

344: If (p_rec.tot_err_num = hr_api.g_number) then
345: p_rec.tot_err_num :=
346: ben_xrs_shd.g_old_rec.tot_err_num;
347: End If;
348: If (p_rec.eff_dt = hr_api.g_date) then
349: p_rec.eff_dt :=
350: ben_xrs_shd.g_old_rec.eff_dt;
351: End If;
352: If (p_rec.ext_strt_dt = hr_api.g_date) then

Line 352: If (p_rec.ext_strt_dt = hr_api.g_date) then

348: If (p_rec.eff_dt = hr_api.g_date) then
349: p_rec.eff_dt :=
350: ben_xrs_shd.g_old_rec.eff_dt;
351: End If;
352: If (p_rec.ext_strt_dt = hr_api.g_date) then
353: p_rec.ext_strt_dt :=
354: ben_xrs_shd.g_old_rec.ext_strt_dt;
355: End If;
356: If (p_rec.ext_end_dt = hr_api.g_date) then

Line 356: If (p_rec.ext_end_dt = hr_api.g_date) then

352: If (p_rec.ext_strt_dt = hr_api.g_date) then
353: p_rec.ext_strt_dt :=
354: ben_xrs_shd.g_old_rec.ext_strt_dt;
355: End If;
356: If (p_rec.ext_end_dt = hr_api.g_date) then
357: p_rec.ext_end_dt :=
358: ben_xrs_shd.g_old_rec.ext_end_dt;
359: End If;
360: If (p_rec.output_name = hr_api.g_varchar2) then

Line 360: If (p_rec.output_name = hr_api.g_varchar2) then

356: If (p_rec.ext_end_dt = hr_api.g_date) then
357: p_rec.ext_end_dt :=
358: ben_xrs_shd.g_old_rec.ext_end_dt;
359: End If;
360: If (p_rec.output_name = hr_api.g_varchar2) then
361: p_rec.output_name :=
362: ben_xrs_shd.g_old_rec.output_name;
363: End If;
364: If (p_rec.drctry_name = hr_api.g_varchar2) then

Line 364: If (p_rec.drctry_name = hr_api.g_varchar2) then

360: If (p_rec.output_name = hr_api.g_varchar2) then
361: p_rec.output_name :=
362: ben_xrs_shd.g_old_rec.output_name;
363: End If;
364: If (p_rec.drctry_name = hr_api.g_varchar2) then
365: p_rec.drctry_name :=
366: ben_xrs_shd.g_old_rec.drctry_name;
367: End If;
368: If (p_rec.ext_dfn_id = hr_api.g_number) then

Line 368: If (p_rec.ext_dfn_id = hr_api.g_number) then

364: If (p_rec.drctry_name = hr_api.g_varchar2) then
365: p_rec.drctry_name :=
366: ben_xrs_shd.g_old_rec.drctry_name;
367: End If;
368: If (p_rec.ext_dfn_id = hr_api.g_number) then
369: p_rec.ext_dfn_id :=
370: ben_xrs_shd.g_old_rec.ext_dfn_id;
371: End If;
372: If (p_rec.business_group_id = hr_api.g_number) then

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

368: If (p_rec.ext_dfn_id = hr_api.g_number) then
369: p_rec.ext_dfn_id :=
370: ben_xrs_shd.g_old_rec.ext_dfn_id;
371: End If;
372: If (p_rec.business_group_id = hr_api.g_number) then
373: p_rec.business_group_id :=
374: ben_xrs_shd.g_old_rec.business_group_id;
375: End If;
376: If (p_rec.program_application_id = hr_api.g_number) then

Line 376: If (p_rec.program_application_id = hr_api.g_number) then

372: If (p_rec.business_group_id = hr_api.g_number) then
373: p_rec.business_group_id :=
374: ben_xrs_shd.g_old_rec.business_group_id;
375: End If;
376: If (p_rec.program_application_id = hr_api.g_number) then
377: p_rec.program_application_id :=
378: ben_xrs_shd.g_old_rec.program_application_id;
379: End If;
380: If (p_rec.program_id = hr_api.g_number) then

Line 380: If (p_rec.program_id = hr_api.g_number) then

376: If (p_rec.program_application_id = hr_api.g_number) then
377: p_rec.program_application_id :=
378: ben_xrs_shd.g_old_rec.program_application_id;
379: End If;
380: If (p_rec.program_id = hr_api.g_number) then
381: p_rec.program_id :=
382: ben_xrs_shd.g_old_rec.program_id;
383: End If;
384: If (p_rec.program_update_date = hr_api.g_date) then

Line 384: If (p_rec.program_update_date = hr_api.g_date) then

380: If (p_rec.program_id = hr_api.g_number) then
381: p_rec.program_id :=
382: ben_xrs_shd.g_old_rec.program_id;
383: End If;
384: If (p_rec.program_update_date = hr_api.g_date) then
385: p_rec.program_update_date :=
386: ben_xrs_shd.g_old_rec.program_update_date;
387: End If;
388: If (p_rec.request_id = hr_api.g_number) then

Line 388: If (p_rec.request_id = hr_api.g_number) then

384: If (p_rec.program_update_date = hr_api.g_date) then
385: p_rec.program_update_date :=
386: ben_xrs_shd.g_old_rec.program_update_date;
387: End If;
388: If (p_rec.request_id = hr_api.g_number) then
389: p_rec.request_id :=
390: ben_xrs_shd.g_old_rec.request_id;
391: End If;
392:

Line 393: If (p_rec.output_type = hr_api.g_varchar2) then

389: p_rec.request_id :=
390: ben_xrs_shd.g_old_rec.request_id;
391: End If;
392:
393: If (p_rec.output_type = hr_api.g_varchar2) then
394: p_rec.output_type :=
395: ben_xrs_shd.g_old_rec.output_type;
396: End If;
397:

Line 399: if (p_rec.xdo_template_id = hr_api.g_number) then

395: ben_xrs_shd.g_old_rec.output_type;
396: End If;
397:
398:
399: if (p_rec.xdo_template_id = hr_api.g_number) then
400: p_rec.xdo_template_id :=
401: ben_xrs_shd.g_old_rec.xdo_template_id;
402: End If;
403: --

Line 461: p_run_strt_dt in date default hr_api.g_date,

457: Procedure upd
458: (
459: p_effective_date in date,
460: p_ext_rslt_id in number,
461: p_run_strt_dt in date default hr_api.g_date,
462: p_run_end_dt in date default hr_api.g_date,
463: p_ext_stat_cd in varchar2 default hr_api.g_varchar2,
464: p_tot_rec_num in number default hr_api.g_number,
465: p_tot_per_num in number default hr_api.g_number,

Line 462: p_run_end_dt in date default hr_api.g_date,

458: (
459: p_effective_date in date,
460: p_ext_rslt_id in number,
461: p_run_strt_dt in date default hr_api.g_date,
462: p_run_end_dt in date default hr_api.g_date,
463: p_ext_stat_cd in varchar2 default hr_api.g_varchar2,
464: p_tot_rec_num in number default hr_api.g_number,
465: p_tot_per_num in number default hr_api.g_number,
466: p_tot_err_num in number default hr_api.g_number,

Line 463: p_ext_stat_cd in varchar2 default hr_api.g_varchar2,

459: p_effective_date in date,
460: p_ext_rslt_id in number,
461: p_run_strt_dt in date default hr_api.g_date,
462: p_run_end_dt in date default hr_api.g_date,
463: p_ext_stat_cd in varchar2 default hr_api.g_varchar2,
464: p_tot_rec_num in number default hr_api.g_number,
465: p_tot_per_num in number default hr_api.g_number,
466: p_tot_err_num in number default hr_api.g_number,
467: p_eff_dt in date default hr_api.g_date,

Line 464: p_tot_rec_num in number default hr_api.g_number,

460: p_ext_rslt_id in number,
461: p_run_strt_dt in date default hr_api.g_date,
462: p_run_end_dt in date default hr_api.g_date,
463: p_ext_stat_cd in varchar2 default hr_api.g_varchar2,
464: p_tot_rec_num in number default hr_api.g_number,
465: p_tot_per_num in number default hr_api.g_number,
466: p_tot_err_num in number default hr_api.g_number,
467: p_eff_dt in date default hr_api.g_date,
468: p_ext_strt_dt in date default hr_api.g_date,

Line 465: p_tot_per_num in number default hr_api.g_number,

461: p_run_strt_dt in date default hr_api.g_date,
462: p_run_end_dt in date default hr_api.g_date,
463: p_ext_stat_cd in varchar2 default hr_api.g_varchar2,
464: p_tot_rec_num in number default hr_api.g_number,
465: p_tot_per_num in number default hr_api.g_number,
466: p_tot_err_num in number default hr_api.g_number,
467: p_eff_dt in date default hr_api.g_date,
468: p_ext_strt_dt in date default hr_api.g_date,
469: p_ext_end_dt in date default hr_api.g_date,

Line 466: p_tot_err_num in number default hr_api.g_number,

462: p_run_end_dt in date default hr_api.g_date,
463: p_ext_stat_cd in varchar2 default hr_api.g_varchar2,
464: p_tot_rec_num in number default hr_api.g_number,
465: p_tot_per_num in number default hr_api.g_number,
466: p_tot_err_num in number default hr_api.g_number,
467: p_eff_dt in date default hr_api.g_date,
468: p_ext_strt_dt in date default hr_api.g_date,
469: p_ext_end_dt in date default hr_api.g_date,
470: p_output_name in varchar2 default hr_api.g_varchar2,

Line 467: p_eff_dt in date default hr_api.g_date,

463: p_ext_stat_cd in varchar2 default hr_api.g_varchar2,
464: p_tot_rec_num in number default hr_api.g_number,
465: p_tot_per_num in number default hr_api.g_number,
466: p_tot_err_num in number default hr_api.g_number,
467: p_eff_dt in date default hr_api.g_date,
468: p_ext_strt_dt in date default hr_api.g_date,
469: p_ext_end_dt in date default hr_api.g_date,
470: p_output_name in varchar2 default hr_api.g_varchar2,
471: p_drctry_name in varchar2 default hr_api.g_varchar2,

Line 468: p_ext_strt_dt in date default hr_api.g_date,

464: p_tot_rec_num in number default hr_api.g_number,
465: p_tot_per_num in number default hr_api.g_number,
466: p_tot_err_num in number default hr_api.g_number,
467: p_eff_dt in date default hr_api.g_date,
468: p_ext_strt_dt in date default hr_api.g_date,
469: p_ext_end_dt in date default hr_api.g_date,
470: p_output_name in varchar2 default hr_api.g_varchar2,
471: p_drctry_name in varchar2 default hr_api.g_varchar2,
472: p_ext_dfn_id in number default hr_api.g_number,

Line 469: p_ext_end_dt in date default hr_api.g_date,

465: p_tot_per_num in number default hr_api.g_number,
466: p_tot_err_num in number default hr_api.g_number,
467: p_eff_dt in date default hr_api.g_date,
468: p_ext_strt_dt in date default hr_api.g_date,
469: p_ext_end_dt in date default hr_api.g_date,
470: p_output_name in varchar2 default hr_api.g_varchar2,
471: p_drctry_name in varchar2 default hr_api.g_varchar2,
472: p_ext_dfn_id in number default hr_api.g_number,
473: p_business_group_id in number default hr_api.g_number,

Line 470: p_output_name in varchar2 default hr_api.g_varchar2,

466: p_tot_err_num in number default hr_api.g_number,
467: p_eff_dt in date default hr_api.g_date,
468: p_ext_strt_dt in date default hr_api.g_date,
469: p_ext_end_dt in date default hr_api.g_date,
470: p_output_name in varchar2 default hr_api.g_varchar2,
471: p_drctry_name in varchar2 default hr_api.g_varchar2,
472: p_ext_dfn_id in number default hr_api.g_number,
473: p_business_group_id in number default hr_api.g_number,
474: p_program_application_id in number default hr_api.g_number,

Line 471: p_drctry_name in varchar2 default hr_api.g_varchar2,

467: p_eff_dt in date default hr_api.g_date,
468: p_ext_strt_dt in date default hr_api.g_date,
469: p_ext_end_dt in date default hr_api.g_date,
470: p_output_name in varchar2 default hr_api.g_varchar2,
471: p_drctry_name in varchar2 default hr_api.g_varchar2,
472: p_ext_dfn_id in number default hr_api.g_number,
473: p_business_group_id in number default hr_api.g_number,
474: p_program_application_id in number default hr_api.g_number,
475: p_program_id in number default hr_api.g_number,

Line 472: p_ext_dfn_id in number default hr_api.g_number,

468: p_ext_strt_dt in date default hr_api.g_date,
469: p_ext_end_dt in date default hr_api.g_date,
470: p_output_name in varchar2 default hr_api.g_varchar2,
471: p_drctry_name in varchar2 default hr_api.g_varchar2,
472: p_ext_dfn_id in number default hr_api.g_number,
473: p_business_group_id in number default hr_api.g_number,
474: p_program_application_id in number default hr_api.g_number,
475: p_program_id in number default hr_api.g_number,
476: p_program_update_date in date default hr_api.g_date,

Line 473: p_business_group_id in number default hr_api.g_number,

469: p_ext_end_dt in date default hr_api.g_date,
470: p_output_name in varchar2 default hr_api.g_varchar2,
471: p_drctry_name in varchar2 default hr_api.g_varchar2,
472: p_ext_dfn_id in number default hr_api.g_number,
473: p_business_group_id in number default hr_api.g_number,
474: p_program_application_id in number default hr_api.g_number,
475: p_program_id in number default hr_api.g_number,
476: p_program_update_date in date default hr_api.g_date,
477: p_request_id in number default hr_api.g_number,

Line 474: p_program_application_id in number default hr_api.g_number,

470: p_output_name in varchar2 default hr_api.g_varchar2,
471: p_drctry_name in varchar2 default hr_api.g_varchar2,
472: p_ext_dfn_id in number default hr_api.g_number,
473: p_business_group_id in number default hr_api.g_number,
474: p_program_application_id in number default hr_api.g_number,
475: p_program_id in number default hr_api.g_number,
476: p_program_update_date in date default hr_api.g_date,
477: p_request_id in number default hr_api.g_number,
478: p_output_type in varchar2 default hr_api.g_varchar2,

Line 475: p_program_id in number default hr_api.g_number,

471: p_drctry_name in varchar2 default hr_api.g_varchar2,
472: p_ext_dfn_id in number default hr_api.g_number,
473: p_business_group_id in number default hr_api.g_number,
474: p_program_application_id in number default hr_api.g_number,
475: p_program_id in number default hr_api.g_number,
476: p_program_update_date in date default hr_api.g_date,
477: p_request_id in number default hr_api.g_number,
478: p_output_type in varchar2 default hr_api.g_varchar2,
479: p_xdo_template_id in number default hr_api.g_number,

Line 476: p_program_update_date in date default hr_api.g_date,

472: p_ext_dfn_id in number default hr_api.g_number,
473: p_business_group_id in number default hr_api.g_number,
474: p_program_application_id in number default hr_api.g_number,
475: p_program_id in number default hr_api.g_number,
476: p_program_update_date in date default hr_api.g_date,
477: p_request_id in number default hr_api.g_number,
478: p_output_type in varchar2 default hr_api.g_varchar2,
479: p_xdo_template_id in number default hr_api.g_number,
480: p_object_version_number in out nocopy number

Line 477: p_request_id in number default hr_api.g_number,

473: p_business_group_id in number default hr_api.g_number,
474: p_program_application_id in number default hr_api.g_number,
475: p_program_id in number default hr_api.g_number,
476: p_program_update_date in date default hr_api.g_date,
477: p_request_id in number default hr_api.g_number,
478: p_output_type in varchar2 default hr_api.g_varchar2,
479: p_xdo_template_id in number default hr_api.g_number,
480: p_object_version_number in out nocopy number
481: ) is

Line 478: p_output_type in varchar2 default hr_api.g_varchar2,

474: p_program_application_id in number default hr_api.g_number,
475: p_program_id in number default hr_api.g_number,
476: p_program_update_date in date default hr_api.g_date,
477: p_request_id in number default hr_api.g_number,
478: p_output_type in varchar2 default hr_api.g_varchar2,
479: p_xdo_template_id in number default hr_api.g_number,
480: p_object_version_number in out nocopy number
481: ) is
482: --

Line 479: p_xdo_template_id in number default hr_api.g_number,

475: p_program_id in number default hr_api.g_number,
476: p_program_update_date in date default hr_api.g_date,
477: p_request_id in number default hr_api.g_number,
478: p_output_type in varchar2 default hr_api.g_varchar2,
479: p_xdo_template_id in number default hr_api.g_number,
480: p_object_version_number in out nocopy number
481: ) is
482: --
483: l_rec ben_xrs_shd.g_rec_type;