APPS.BEN_XCL_UPD dependencies on HR_API

Line 95: When hr_api.check_integrity_violated Then

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

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

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

Line 100: When hr_api.parent_integrity_violated Then

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

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

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

Line 105: When hr_api.unique_integrity_violated Then

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

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

105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
108: ben_xcl_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_xcl_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;
113: 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_chg_evt_log'
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_chg_evt_log'
246: ,p_hook_type => 'AU');
247: --
248: end;

Line 312: If (p_rec.chg_evt_cd = hr_api.g_varchar2) 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.chg_evt_cd = hr_api.g_varchar2) then
313: p_rec.chg_evt_cd :=
314: ben_xcl_shd.g_old_rec.chg_evt_cd;
315: End If;
316: If (p_rec.chg_eff_dt = hr_api.g_date) then

Line 316: If (p_rec.chg_eff_dt = hr_api.g_date) then

312: If (p_rec.chg_evt_cd = hr_api.g_varchar2) then
313: p_rec.chg_evt_cd :=
314: ben_xcl_shd.g_old_rec.chg_evt_cd;
315: End If;
316: If (p_rec.chg_eff_dt = hr_api.g_date) then
317: p_rec.chg_eff_dt :=
318: ben_xcl_shd.g_old_rec.chg_eff_dt;
319: End If;
320: If (p_rec.chg_user_id = hr_api.g_number) then

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

316: If (p_rec.chg_eff_dt = hr_api.g_date) then
317: p_rec.chg_eff_dt :=
318: ben_xcl_shd.g_old_rec.chg_eff_dt;
319: End If;
320: If (p_rec.chg_user_id = hr_api.g_number) then
321: p_rec.chg_user_id :=
322: ben_xcl_shd.g_old_rec.chg_user_id;
323: End If;
324: If (p_rec.prmtr_01 = hr_api.g_varchar2) then

Line 324: If (p_rec.prmtr_01 = hr_api.g_varchar2) then

320: If (p_rec.chg_user_id = hr_api.g_number) then
321: p_rec.chg_user_id :=
322: ben_xcl_shd.g_old_rec.chg_user_id;
323: End If;
324: If (p_rec.prmtr_01 = hr_api.g_varchar2) then
325: p_rec.prmtr_01 :=
326: ben_xcl_shd.g_old_rec.prmtr_01;
327: End If;
328: If (p_rec.prmtr_02 = hr_api.g_varchar2) then

Line 328: If (p_rec.prmtr_02 = hr_api.g_varchar2) then

324: If (p_rec.prmtr_01 = hr_api.g_varchar2) then
325: p_rec.prmtr_01 :=
326: ben_xcl_shd.g_old_rec.prmtr_01;
327: End If;
328: If (p_rec.prmtr_02 = hr_api.g_varchar2) then
329: p_rec.prmtr_02 :=
330: ben_xcl_shd.g_old_rec.prmtr_02;
331: End If;
332: If (p_rec.prmtr_03 = hr_api.g_varchar2) then

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

328: If (p_rec.prmtr_02 = hr_api.g_varchar2) then
329: p_rec.prmtr_02 :=
330: ben_xcl_shd.g_old_rec.prmtr_02;
331: End If;
332: If (p_rec.prmtr_03 = hr_api.g_varchar2) then
333: p_rec.prmtr_03 :=
334: ben_xcl_shd.g_old_rec.prmtr_03;
335: End If;
336: If (p_rec.prmtr_04 = hr_api.g_varchar2) then

Line 336: If (p_rec.prmtr_04 = hr_api.g_varchar2) then

332: If (p_rec.prmtr_03 = hr_api.g_varchar2) then
333: p_rec.prmtr_03 :=
334: ben_xcl_shd.g_old_rec.prmtr_03;
335: End If;
336: If (p_rec.prmtr_04 = hr_api.g_varchar2) then
337: p_rec.prmtr_04 :=
338: ben_xcl_shd.g_old_rec.prmtr_04;
339: End If;
340: If (p_rec.prmtr_05 = hr_api.g_varchar2) then

Line 340: If (p_rec.prmtr_05 = hr_api.g_varchar2) then

336: If (p_rec.prmtr_04 = hr_api.g_varchar2) then
337: p_rec.prmtr_04 :=
338: ben_xcl_shd.g_old_rec.prmtr_04;
339: End If;
340: If (p_rec.prmtr_05 = hr_api.g_varchar2) then
341: p_rec.prmtr_05 :=
342: ben_xcl_shd.g_old_rec.prmtr_05;
343: End If;
344: If (p_rec.prmtr_06 = hr_api.g_varchar2) then

Line 344: If (p_rec.prmtr_06 = hr_api.g_varchar2) then

340: If (p_rec.prmtr_05 = hr_api.g_varchar2) then
341: p_rec.prmtr_05 :=
342: ben_xcl_shd.g_old_rec.prmtr_05;
343: End If;
344: If (p_rec.prmtr_06 = hr_api.g_varchar2) then
345: p_rec.prmtr_06 :=
346: ben_xcl_shd.g_old_rec.prmtr_06;
347: End If;
348: If (p_rec.prmtr_07 = hr_api.g_varchar2) then

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

344: If (p_rec.prmtr_06 = hr_api.g_varchar2) then
345: p_rec.prmtr_06 :=
346: ben_xcl_shd.g_old_rec.prmtr_06;
347: End If;
348: If (p_rec.prmtr_07 = hr_api.g_varchar2) then
349: p_rec.prmtr_07 :=
350: ben_xcl_shd.g_old_rec.prmtr_07;
351: End If;
352: If (p_rec.prmtr_08 = hr_api.g_varchar2) then

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

348: If (p_rec.prmtr_07 = hr_api.g_varchar2) then
349: p_rec.prmtr_07 :=
350: ben_xcl_shd.g_old_rec.prmtr_07;
351: End If;
352: If (p_rec.prmtr_08 = hr_api.g_varchar2) then
353: p_rec.prmtr_08 :=
354: ben_xcl_shd.g_old_rec.prmtr_08;
355: End If;
356: If (p_rec.prmtr_09 = hr_api.g_varchar2) then

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

352: If (p_rec.prmtr_08 = hr_api.g_varchar2) then
353: p_rec.prmtr_08 :=
354: ben_xcl_shd.g_old_rec.prmtr_08;
355: End If;
356: If (p_rec.prmtr_09 = hr_api.g_varchar2) then
357: p_rec.prmtr_09 :=
358: ben_xcl_shd.g_old_rec.prmtr_09;
359: End If;
360: If (p_rec.prmtr_10 = hr_api.g_varchar2) then

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

356: If (p_rec.prmtr_09 = hr_api.g_varchar2) then
357: p_rec.prmtr_09 :=
358: ben_xcl_shd.g_old_rec.prmtr_09;
359: End If;
360: If (p_rec.prmtr_10 = hr_api.g_varchar2) then
361: p_rec.prmtr_10 :=
362: ben_xcl_shd.g_old_rec.prmtr_10;
363: End If;
364: If (p_rec.person_id = hr_api.g_number) then

Line 364: If (p_rec.person_id = hr_api.g_number) then

360: If (p_rec.prmtr_10 = hr_api.g_varchar2) then
361: p_rec.prmtr_10 :=
362: ben_xcl_shd.g_old_rec.prmtr_10;
363: End If;
364: If (p_rec.person_id = hr_api.g_number) then
365: p_rec.person_id :=
366: ben_xcl_shd.g_old_rec.person_id;
367: End If;
368: If (p_rec.business_group_id = hr_api.g_number) then

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

364: If (p_rec.person_id = hr_api.g_number) then
365: p_rec.person_id :=
366: ben_xcl_shd.g_old_rec.person_id;
367: End If;
368: If (p_rec.business_group_id = hr_api.g_number) then
369: p_rec.business_group_id :=
370: ben_xcl_shd.g_old_rec.business_group_id;
371: End If;
372:

Line 431: p_chg_evt_cd in varchar2 default hr_api.g_varchar2,

427: Procedure upd
428: (
429: p_effective_date in date,
430: p_ext_chg_evt_log_id in number,
431: p_chg_evt_cd in varchar2 default hr_api.g_varchar2,
432: p_chg_eff_dt in date default hr_api.g_date,
433: p_chg_user_id in number default hr_api.g_number,
434: p_prmtr_01 in varchar2 default hr_api.g_varchar2,
435: p_prmtr_02 in varchar2 default hr_api.g_varchar2,

Line 432: p_chg_eff_dt in date default hr_api.g_date,

428: (
429: p_effective_date in date,
430: p_ext_chg_evt_log_id in number,
431: p_chg_evt_cd in varchar2 default hr_api.g_varchar2,
432: p_chg_eff_dt in date default hr_api.g_date,
433: p_chg_user_id in number default hr_api.g_number,
434: p_prmtr_01 in varchar2 default hr_api.g_varchar2,
435: p_prmtr_02 in varchar2 default hr_api.g_varchar2,
436: p_prmtr_03 in varchar2 default hr_api.g_varchar2,

Line 433: p_chg_user_id in number default hr_api.g_number,

429: p_effective_date in date,
430: p_ext_chg_evt_log_id in number,
431: p_chg_evt_cd in varchar2 default hr_api.g_varchar2,
432: p_chg_eff_dt in date default hr_api.g_date,
433: p_chg_user_id in number default hr_api.g_number,
434: p_prmtr_01 in varchar2 default hr_api.g_varchar2,
435: p_prmtr_02 in varchar2 default hr_api.g_varchar2,
436: p_prmtr_03 in varchar2 default hr_api.g_varchar2,
437: p_prmtr_04 in varchar2 default hr_api.g_varchar2,

Line 434: p_prmtr_01 in varchar2 default hr_api.g_varchar2,

430: p_ext_chg_evt_log_id in number,
431: p_chg_evt_cd in varchar2 default hr_api.g_varchar2,
432: p_chg_eff_dt in date default hr_api.g_date,
433: p_chg_user_id in number default hr_api.g_number,
434: p_prmtr_01 in varchar2 default hr_api.g_varchar2,
435: p_prmtr_02 in varchar2 default hr_api.g_varchar2,
436: p_prmtr_03 in varchar2 default hr_api.g_varchar2,
437: p_prmtr_04 in varchar2 default hr_api.g_varchar2,
438: p_prmtr_05 in varchar2 default hr_api.g_varchar2,

Line 435: p_prmtr_02 in varchar2 default hr_api.g_varchar2,

431: p_chg_evt_cd in varchar2 default hr_api.g_varchar2,
432: p_chg_eff_dt in date default hr_api.g_date,
433: p_chg_user_id in number default hr_api.g_number,
434: p_prmtr_01 in varchar2 default hr_api.g_varchar2,
435: p_prmtr_02 in varchar2 default hr_api.g_varchar2,
436: p_prmtr_03 in varchar2 default hr_api.g_varchar2,
437: p_prmtr_04 in varchar2 default hr_api.g_varchar2,
438: p_prmtr_05 in varchar2 default hr_api.g_varchar2,
439: p_prmtr_06 in varchar2 default hr_api.g_varchar2,

Line 436: p_prmtr_03 in varchar2 default hr_api.g_varchar2,

432: p_chg_eff_dt in date default hr_api.g_date,
433: p_chg_user_id in number default hr_api.g_number,
434: p_prmtr_01 in varchar2 default hr_api.g_varchar2,
435: p_prmtr_02 in varchar2 default hr_api.g_varchar2,
436: p_prmtr_03 in varchar2 default hr_api.g_varchar2,
437: p_prmtr_04 in varchar2 default hr_api.g_varchar2,
438: p_prmtr_05 in varchar2 default hr_api.g_varchar2,
439: p_prmtr_06 in varchar2 default hr_api.g_varchar2,
440: p_prmtr_07 in varchar2 default hr_api.g_varchar2,

Line 437: p_prmtr_04 in varchar2 default hr_api.g_varchar2,

433: p_chg_user_id in number default hr_api.g_number,
434: p_prmtr_01 in varchar2 default hr_api.g_varchar2,
435: p_prmtr_02 in varchar2 default hr_api.g_varchar2,
436: p_prmtr_03 in varchar2 default hr_api.g_varchar2,
437: p_prmtr_04 in varchar2 default hr_api.g_varchar2,
438: p_prmtr_05 in varchar2 default hr_api.g_varchar2,
439: p_prmtr_06 in varchar2 default hr_api.g_varchar2,
440: p_prmtr_07 in varchar2 default hr_api.g_varchar2,
441: p_prmtr_08 in varchar2 default hr_api.g_varchar2,

Line 438: p_prmtr_05 in varchar2 default hr_api.g_varchar2,

434: p_prmtr_01 in varchar2 default hr_api.g_varchar2,
435: p_prmtr_02 in varchar2 default hr_api.g_varchar2,
436: p_prmtr_03 in varchar2 default hr_api.g_varchar2,
437: p_prmtr_04 in varchar2 default hr_api.g_varchar2,
438: p_prmtr_05 in varchar2 default hr_api.g_varchar2,
439: p_prmtr_06 in varchar2 default hr_api.g_varchar2,
440: p_prmtr_07 in varchar2 default hr_api.g_varchar2,
441: p_prmtr_08 in varchar2 default hr_api.g_varchar2,
442: p_prmtr_09 in varchar2 default hr_api.g_varchar2,

Line 439: p_prmtr_06 in varchar2 default hr_api.g_varchar2,

435: p_prmtr_02 in varchar2 default hr_api.g_varchar2,
436: p_prmtr_03 in varchar2 default hr_api.g_varchar2,
437: p_prmtr_04 in varchar2 default hr_api.g_varchar2,
438: p_prmtr_05 in varchar2 default hr_api.g_varchar2,
439: p_prmtr_06 in varchar2 default hr_api.g_varchar2,
440: p_prmtr_07 in varchar2 default hr_api.g_varchar2,
441: p_prmtr_08 in varchar2 default hr_api.g_varchar2,
442: p_prmtr_09 in varchar2 default hr_api.g_varchar2,
443: p_prmtr_10 in varchar2 default hr_api.g_varchar2,

Line 440: p_prmtr_07 in varchar2 default hr_api.g_varchar2,

436: p_prmtr_03 in varchar2 default hr_api.g_varchar2,
437: p_prmtr_04 in varchar2 default hr_api.g_varchar2,
438: p_prmtr_05 in varchar2 default hr_api.g_varchar2,
439: p_prmtr_06 in varchar2 default hr_api.g_varchar2,
440: p_prmtr_07 in varchar2 default hr_api.g_varchar2,
441: p_prmtr_08 in varchar2 default hr_api.g_varchar2,
442: p_prmtr_09 in varchar2 default hr_api.g_varchar2,
443: p_prmtr_10 in varchar2 default hr_api.g_varchar2,
444: p_person_id in number default hr_api.g_number,

Line 441: p_prmtr_08 in varchar2 default hr_api.g_varchar2,

437: p_prmtr_04 in varchar2 default hr_api.g_varchar2,
438: p_prmtr_05 in varchar2 default hr_api.g_varchar2,
439: p_prmtr_06 in varchar2 default hr_api.g_varchar2,
440: p_prmtr_07 in varchar2 default hr_api.g_varchar2,
441: p_prmtr_08 in varchar2 default hr_api.g_varchar2,
442: p_prmtr_09 in varchar2 default hr_api.g_varchar2,
443: p_prmtr_10 in varchar2 default hr_api.g_varchar2,
444: p_person_id in number default hr_api.g_number,
445: p_business_group_id in number default hr_api.g_number,

Line 442: p_prmtr_09 in varchar2 default hr_api.g_varchar2,

438: p_prmtr_05 in varchar2 default hr_api.g_varchar2,
439: p_prmtr_06 in varchar2 default hr_api.g_varchar2,
440: p_prmtr_07 in varchar2 default hr_api.g_varchar2,
441: p_prmtr_08 in varchar2 default hr_api.g_varchar2,
442: p_prmtr_09 in varchar2 default hr_api.g_varchar2,
443: p_prmtr_10 in varchar2 default hr_api.g_varchar2,
444: p_person_id in number default hr_api.g_number,
445: p_business_group_id in number default hr_api.g_number,
446: p_object_version_number in out nocopy number

Line 443: p_prmtr_10 in varchar2 default hr_api.g_varchar2,

439: p_prmtr_06 in varchar2 default hr_api.g_varchar2,
440: p_prmtr_07 in varchar2 default hr_api.g_varchar2,
441: p_prmtr_08 in varchar2 default hr_api.g_varchar2,
442: p_prmtr_09 in varchar2 default hr_api.g_varchar2,
443: p_prmtr_10 in varchar2 default hr_api.g_varchar2,
444: p_person_id in number default hr_api.g_number,
445: p_business_group_id in number default hr_api.g_number,
446: p_object_version_number in out nocopy number
447: ) is

Line 444: p_person_id in number default hr_api.g_number,

440: p_prmtr_07 in varchar2 default hr_api.g_varchar2,
441: p_prmtr_08 in varchar2 default hr_api.g_varchar2,
442: p_prmtr_09 in varchar2 default hr_api.g_varchar2,
443: p_prmtr_10 in varchar2 default hr_api.g_varchar2,
444: p_person_id in number default hr_api.g_number,
445: p_business_group_id in number default hr_api.g_number,
446: p_object_version_number in out nocopy number
447: ) is
448: --

Line 445: p_business_group_id in number default hr_api.g_number,

441: p_prmtr_08 in varchar2 default hr_api.g_varchar2,
442: p_prmtr_09 in varchar2 default hr_api.g_varchar2,
443: p_prmtr_10 in varchar2 default hr_api.g_varchar2,
444: p_person_id in number default hr_api.g_number,
445: p_business_group_id in number default hr_api.g_number,
446: p_object_version_number in out nocopy number
447: ) is
448: --
449: l_rec ben_xcl_shd.g_rec_type;