APPS.BEN_XRF_UPD dependencies on HR_API

Line 97: When hr_api.check_integrity_violated Then

93: --
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: --
96: Exception
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: ben_xrf_shd.g_api_dml := false; -- Unset the api dml status
100: ben_xrf_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.check_integrity_violated Then
98: -- A check constraint has been violated
99: ben_xrf_shd.g_api_dml := false; -- Unset the api dml status
100: ben_xrf_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: ben_xrf_shd.g_api_dml := false; -- Unset the api dml status
105: ben_xrf_shd.constraint_error

Line 102: When hr_api.parent_integrity_violated Then

98: -- A check constraint has been violated
99: ben_xrf_shd.g_api_dml := false; -- Unset the api dml status
100: ben_xrf_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: ben_xrf_shd.g_api_dml := false; -- Unset the api dml status
105: ben_xrf_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.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: ben_xrf_shd.g_api_dml := false; -- Unset the api dml status
105: ben_xrf_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: ben_xrf_shd.g_api_dml := false; -- Unset the api dml status
110: ben_xrf_shd.constraint_error

Line 107: When hr_api.unique_integrity_violated Then

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

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

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

Line 242: when hr_api.cannot_find_prog_unit then

238: );
239: --
240: exception
241: --
242: when hr_api.cannot_find_prog_unit then
243: --
244: hr_api.cannot_find_prog_unit_error
245: (p_module_name => 'ben_ext_rcd_in_file'
246: ,p_hook_type => 'AU');

Line 244: hr_api.cannot_find_prog_unit_error

240: exception
241: --
242: when hr_api.cannot_find_prog_unit then
243: --
244: hr_api.cannot_find_prog_unit_error
245: (p_module_name => 'ben_ext_rcd_in_file'
246: ,p_hook_type => 'AU');
247: --
248: end;

Line 312: If (p_rec.seq_num = hr_api.g_number) then

308: -- p_rec plsql record structure
309: -- to see if a system default is being used. If a system default
310: -- is being used then we must set to the 'current' argument value.
311: --
312: If (p_rec.seq_num = hr_api.g_number) then
313: p_rec.seq_num :=
314: ben_xrf_shd.g_old_rec.seq_num;
315: End If;
316: If (p_rec.sprs_cd = hr_api.g_varchar2) then

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

312: If (p_rec.seq_num = hr_api.g_number) then
313: p_rec.seq_num :=
314: ben_xrf_shd.g_old_rec.seq_num;
315: End If;
316: If (p_rec.sprs_cd = hr_api.g_varchar2) then
317: p_rec.sprs_cd :=
318: ben_xrf_shd.g_old_rec.sprs_cd;
319: End If;
320: If (p_rec.sort1_data_elmt_in_rcd_id = hr_api.g_number) then

Line 320: If (p_rec.sort1_data_elmt_in_rcd_id = hr_api.g_number) then

316: If (p_rec.sprs_cd = hr_api.g_varchar2) then
317: p_rec.sprs_cd :=
318: ben_xrf_shd.g_old_rec.sprs_cd;
319: End If;
320: If (p_rec.sort1_data_elmt_in_rcd_id = hr_api.g_number) then
321: p_rec.sort1_data_elmt_in_rcd_id :=
322: ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id;
323: End If;
324: If (p_rec.sort2_data_elmt_in_rcd_id = hr_api.g_number) then

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

320: If (p_rec.sort1_data_elmt_in_rcd_id = hr_api.g_number) then
321: p_rec.sort1_data_elmt_in_rcd_id :=
322: ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id;
323: End If;
324: If (p_rec.sort2_data_elmt_in_rcd_id = hr_api.g_number) then
325: p_rec.sort2_data_elmt_in_rcd_id :=
326: ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id;
327: End If;
328: If (p_rec.sort3_data_elmt_in_rcd_id = hr_api.g_number) then

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

324: If (p_rec.sort2_data_elmt_in_rcd_id = hr_api.g_number) then
325: p_rec.sort2_data_elmt_in_rcd_id :=
326: ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id;
327: End If;
328: If (p_rec.sort3_data_elmt_in_rcd_id = hr_api.g_number) then
329: p_rec.sort3_data_elmt_in_rcd_id :=
330: ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id;
331: End If;
332: If (p_rec.sort4_data_elmt_in_rcd_id = hr_api.g_number) then

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

328: If (p_rec.sort3_data_elmt_in_rcd_id = hr_api.g_number) then
329: p_rec.sort3_data_elmt_in_rcd_id :=
330: ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id;
331: End If;
332: If (p_rec.sort4_data_elmt_in_rcd_id = hr_api.g_number) then
333: p_rec.sort4_data_elmt_in_rcd_id :=
334: ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id;
335: End If;
336: If (p_rec.ext_rcd_id = hr_api.g_number) then

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

332: If (p_rec.sort4_data_elmt_in_rcd_id = hr_api.g_number) then
333: p_rec.sort4_data_elmt_in_rcd_id :=
334: ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id;
335: End If;
336: If (p_rec.ext_rcd_id = hr_api.g_number) then
337: p_rec.ext_rcd_id :=
338: ben_xrf_shd.g_old_rec.ext_rcd_id;
339: End If;
340: If (p_rec.ext_file_id = hr_api.g_number) then

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

336: If (p_rec.ext_rcd_id = hr_api.g_number) then
337: p_rec.ext_rcd_id :=
338: ben_xrf_shd.g_old_rec.ext_rcd_id;
339: End If;
340: If (p_rec.ext_file_id = hr_api.g_number) then
341: p_rec.ext_file_id :=
342: ben_xrf_shd.g_old_rec.ext_file_id;
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.ext_file_id = hr_api.g_number) then
341: p_rec.ext_file_id :=
342: ben_xrf_shd.g_old_rec.ext_file_id;
343: End If;
344: If (p_rec.business_group_id = hr_api.g_number) then
345: p_rec.business_group_id :=
346: ben_xrf_shd.g_old_rec.business_group_id;
347: End If;
348: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 348: If (p_rec.legislation_code = hr_api.g_varchar2) then

344: If (p_rec.business_group_id = hr_api.g_number) then
345: p_rec.business_group_id :=
346: ben_xrf_shd.g_old_rec.business_group_id;
347: End If;
348: If (p_rec.legislation_code = hr_api.g_varchar2) then
349: p_rec.legislation_code :=
350: ben_xrf_shd.g_old_rec.legislation_code;
351: End If;
352: If (p_rec.any_or_all_cd = hr_api.g_varchar2) then

Line 352: If (p_rec.any_or_all_cd = hr_api.g_varchar2) then

348: If (p_rec.legislation_code = hr_api.g_varchar2) then
349: p_rec.legislation_code :=
350: ben_xrf_shd.g_old_rec.legislation_code;
351: End If;
352: If (p_rec.any_or_all_cd = hr_api.g_varchar2) then
353: p_rec.any_or_all_cd :=
354: ben_xrf_shd.g_old_rec.any_or_all_cd;
355: End If;
356: If (p_rec.hide_flag = hr_api.g_varchar2) then

Line 356: If (p_rec.hide_flag = hr_api.g_varchar2) then

352: If (p_rec.any_or_all_cd = hr_api.g_varchar2) then
353: p_rec.any_or_all_cd :=
354: ben_xrf_shd.g_old_rec.any_or_all_cd;
355: End If;
356: If (p_rec.hide_flag = hr_api.g_varchar2) then
357: p_rec.hide_flag :=
358: ben_xrf_shd.g_old_rec.hide_flag;
359: End If;
360: If (p_rec.rqd_flag = hr_api.g_varchar2) then

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

356: If (p_rec.hide_flag = hr_api.g_varchar2) then
357: p_rec.hide_flag :=
358: ben_xrf_shd.g_old_rec.hide_flag;
359: End If;
360: If (p_rec.rqd_flag = hr_api.g_varchar2) then
361: p_rec.rqd_flag :=
362: ben_xrf_shd.g_old_rec.rqd_flag;
363: End If;
364: --

Line 365: If (p_rec.chg_rcd_upd_flag = hr_api.g_varchar2) then

361: p_rec.rqd_flag :=
362: ben_xrf_shd.g_old_rec.rqd_flag;
363: End If;
364: --
365: If (p_rec.chg_rcd_upd_flag = hr_api.g_varchar2) then
366: p_rec.chg_rcd_upd_flag :=
367: ben_xrf_shd.g_old_rec.chg_rcd_upd_flag;
368: End If;
369: --

Line 427: p_seq_num in number default hr_api.g_number,

423: Procedure upd
424: (
425: p_effective_date in date,
426: p_ext_rcd_in_file_id in number,
427: p_seq_num in number default hr_api.g_number,
428: p_sprs_cd in varchar2 default hr_api.g_varchar2,
429: p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number,
430: p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number,
431: p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number,

Line 428: p_sprs_cd in varchar2 default hr_api.g_varchar2,

424: (
425: p_effective_date in date,
426: p_ext_rcd_in_file_id in number,
427: p_seq_num in number default hr_api.g_number,
428: p_sprs_cd in varchar2 default hr_api.g_varchar2,
429: p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number,
430: p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number,
431: p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number,
432: p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number,

Line 429: p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number,

425: p_effective_date in date,
426: p_ext_rcd_in_file_id in number,
427: p_seq_num in number default hr_api.g_number,
428: p_sprs_cd in varchar2 default hr_api.g_varchar2,
429: p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number,
430: p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number,
431: p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number,
432: p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number,
433: p_ext_rcd_id in number default hr_api.g_number,

Line 430: p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number,

426: p_ext_rcd_in_file_id in number,
427: p_seq_num in number default hr_api.g_number,
428: p_sprs_cd in varchar2 default hr_api.g_varchar2,
429: p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number,
430: p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number,
431: p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number,
432: p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number,
433: p_ext_rcd_id in number default hr_api.g_number,
434: p_ext_file_id in number default hr_api.g_number,

Line 431: p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number,

427: p_seq_num in number default hr_api.g_number,
428: p_sprs_cd in varchar2 default hr_api.g_varchar2,
429: p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number,
430: p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number,
431: p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number,
432: p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number,
433: p_ext_rcd_id in number default hr_api.g_number,
434: p_ext_file_id in number default hr_api.g_number,
435: p_business_group_id in number default hr_api.g_number,

Line 432: p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number,

428: p_sprs_cd in varchar2 default hr_api.g_varchar2,
429: p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number,
430: p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number,
431: p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number,
432: p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number,
433: p_ext_rcd_id in number default hr_api.g_number,
434: p_ext_file_id in number default hr_api.g_number,
435: p_business_group_id in number default hr_api.g_number,
436: p_legislation_code in varchar2 default hr_api.g_varchar2,

Line 433: p_ext_rcd_id in number default hr_api.g_number,

429: p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number,
430: p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number,
431: p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number,
432: p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number,
433: p_ext_rcd_id in number default hr_api.g_number,
434: p_ext_file_id in number default hr_api.g_number,
435: p_business_group_id in number default hr_api.g_number,
436: p_legislation_code in varchar2 default hr_api.g_varchar2,
437: p_last_update_date in date default hr_api.g_date,

Line 434: p_ext_file_id in number default hr_api.g_number,

430: p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number,
431: p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number,
432: p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number,
433: p_ext_rcd_id in number default hr_api.g_number,
434: p_ext_file_id in number default hr_api.g_number,
435: p_business_group_id in number default hr_api.g_number,
436: p_legislation_code in varchar2 default hr_api.g_varchar2,
437: p_last_update_date in date default hr_api.g_date,
438: p_creation_date in date default hr_api.g_date,

Line 435: p_business_group_id in number default hr_api.g_number,

431: p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number,
432: p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number,
433: p_ext_rcd_id in number default hr_api.g_number,
434: p_ext_file_id in number default hr_api.g_number,
435: p_business_group_id in number default hr_api.g_number,
436: p_legislation_code in varchar2 default hr_api.g_varchar2,
437: p_last_update_date in date default hr_api.g_date,
438: p_creation_date in date default hr_api.g_date,
439: p_last_updated_by in number default hr_api.g_number,

Line 436: p_legislation_code in varchar2 default hr_api.g_varchar2,

432: p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number,
433: p_ext_rcd_id in number default hr_api.g_number,
434: p_ext_file_id in number default hr_api.g_number,
435: p_business_group_id in number default hr_api.g_number,
436: p_legislation_code in varchar2 default hr_api.g_varchar2,
437: p_last_update_date in date default hr_api.g_date,
438: p_creation_date in date default hr_api.g_date,
439: p_last_updated_by in number default hr_api.g_number,
440: p_last_update_login in number default hr_api.g_number,

Line 437: p_last_update_date in date default hr_api.g_date,

433: p_ext_rcd_id in number default hr_api.g_number,
434: p_ext_file_id in number default hr_api.g_number,
435: p_business_group_id in number default hr_api.g_number,
436: p_legislation_code in varchar2 default hr_api.g_varchar2,
437: p_last_update_date in date default hr_api.g_date,
438: p_creation_date in date default hr_api.g_date,
439: p_last_updated_by in number default hr_api.g_number,
440: p_last_update_login in number default hr_api.g_number,
441: p_created_by in number default hr_api.g_number,

Line 438: p_creation_date in date default hr_api.g_date,

434: p_ext_file_id in number default hr_api.g_number,
435: p_business_group_id in number default hr_api.g_number,
436: p_legislation_code in varchar2 default hr_api.g_varchar2,
437: p_last_update_date in date default hr_api.g_date,
438: p_creation_date in date default hr_api.g_date,
439: p_last_updated_by in number default hr_api.g_number,
440: p_last_update_login in number default hr_api.g_number,
441: p_created_by in number default hr_api.g_number,
442: p_object_version_number in out nocopy number,

Line 439: p_last_updated_by in number default hr_api.g_number,

435: p_business_group_id in number default hr_api.g_number,
436: p_legislation_code in varchar2 default hr_api.g_varchar2,
437: p_last_update_date in date default hr_api.g_date,
438: p_creation_date in date default hr_api.g_date,
439: p_last_updated_by in number default hr_api.g_number,
440: p_last_update_login in number default hr_api.g_number,
441: p_created_by in number default hr_api.g_number,
442: p_object_version_number in out nocopy number,
443: p_any_or_all_cd in varchar2 default hr_api.g_varchar2,

Line 440: p_last_update_login in number default hr_api.g_number,

436: p_legislation_code in varchar2 default hr_api.g_varchar2,
437: p_last_update_date in date default hr_api.g_date,
438: p_creation_date in date default hr_api.g_date,
439: p_last_updated_by in number default hr_api.g_number,
440: p_last_update_login in number default hr_api.g_number,
441: p_created_by in number default hr_api.g_number,
442: p_object_version_number in out nocopy number,
443: p_any_or_all_cd in varchar2 default hr_api.g_varchar2,
444: p_hide_flag in varchar2 default hr_api.g_varchar2,

Line 441: p_created_by in number default hr_api.g_number,

437: p_last_update_date in date default hr_api.g_date,
438: p_creation_date in date default hr_api.g_date,
439: p_last_updated_by in number default hr_api.g_number,
440: p_last_update_login in number default hr_api.g_number,
441: p_created_by in number default hr_api.g_number,
442: p_object_version_number in out nocopy number,
443: p_any_or_all_cd in varchar2 default hr_api.g_varchar2,
444: p_hide_flag in varchar2 default hr_api.g_varchar2,
445: p_rqd_flag in varchar2 default hr_api.g_varchar2,

Line 443: p_any_or_all_cd in varchar2 default hr_api.g_varchar2,

439: p_last_updated_by in number default hr_api.g_number,
440: p_last_update_login in number default hr_api.g_number,
441: p_created_by in number default hr_api.g_number,
442: p_object_version_number in out nocopy number,
443: p_any_or_all_cd in varchar2 default hr_api.g_varchar2,
444: p_hide_flag in varchar2 default hr_api.g_varchar2,
445: p_rqd_flag in varchar2 default hr_api.g_varchar2,
446: p_chg_rcd_upd_flag in varchar2 default hr_api.g_varchar2
447: ) is

Line 444: p_hide_flag in varchar2 default hr_api.g_varchar2,

440: p_last_update_login in number default hr_api.g_number,
441: p_created_by in number default hr_api.g_number,
442: p_object_version_number in out nocopy number,
443: p_any_or_all_cd in varchar2 default hr_api.g_varchar2,
444: p_hide_flag in varchar2 default hr_api.g_varchar2,
445: p_rqd_flag in varchar2 default hr_api.g_varchar2,
446: p_chg_rcd_upd_flag in varchar2 default hr_api.g_varchar2
447: ) is
448: --

Line 445: p_rqd_flag in varchar2 default hr_api.g_varchar2,

441: p_created_by in number default hr_api.g_number,
442: p_object_version_number in out nocopy number,
443: p_any_or_all_cd in varchar2 default hr_api.g_varchar2,
444: p_hide_flag in varchar2 default hr_api.g_varchar2,
445: p_rqd_flag in varchar2 default hr_api.g_varchar2,
446: p_chg_rcd_upd_flag in varchar2 default hr_api.g_varchar2
447: ) is
448: --
449: l_rec ben_xrf_shd.g_rec_type;

Line 446: p_chg_rcd_upd_flag in varchar2 default hr_api.g_varchar2

442: p_object_version_number in out nocopy number,
443: p_any_or_all_cd in varchar2 default hr_api.g_varchar2,
444: p_hide_flag in varchar2 default hr_api.g_varchar2,
445: p_rqd_flag in varchar2 default hr_api.g_varchar2,
446: p_chg_rcd_upd_flag in varchar2 default hr_api.g_varchar2
447: ) is
448: --
449: l_rec ben_xrf_shd.g_rec_type;
450: l_proc varchar2(72) := g_package||'upd';