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.HXC_HRR_UPD dependencies on HR_API

Line 101: When hr_api.check_integrity_violated Then

97: hr_utility.set_location(' Leaving:'||l_proc, 10);
98: end if;
99: --
100: Exception
101: When hr_api.check_integrity_violated Then
102: -- A check constraint has been violated
103: --
104: hxc_hrr_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

101: When hr_api.check_integrity_violated Then
102: -- A check constraint has been violated
103: --
104: hxc_hrr_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: --
109: hxc_hrr_shd.constraint_error

Line 106: When hr_api.parent_integrity_violated Then

102: -- A check constraint has been violated
103: --
104: hxc_hrr_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: --
109: hxc_hrr_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: --
109: hxc_hrr_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.unique_integrity_violated Then
112: -- Unique integrity has been violated
113: --
114: hxc_hrr_shd.constraint_error

Line 111: When hr_api.unique_integrity_violated Then

107: -- Parent integrity has been violated
108: --
109: hxc_hrr_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.unique_integrity_violated Then
112: -- Unique integrity has been violated
113: --
114: hxc_hrr_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

111: When hr_api.unique_integrity_violated Then
112: -- Unique integrity has been violated
113: --
114: hxc_hrr_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When Others Then
117: --
118: Raise;
119: End update_dml;

Line 262: when hr_api.cannot_find_prog_unit then

258: );
259: --
260: exception
261: --
262: when hr_api.cannot_find_prog_unit then
263: --
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'HXC_RESOURCE_RULES'
266: ,p_hook_type => 'AU');

Line 264: hr_api.cannot_find_prog_unit_error

260: exception
261: --
262: when hr_api.cannot_find_prog_unit then
263: --
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'HXC_RESOURCE_RULES'
266: ,p_hook_type => 'AU');
267: --
268: end;

Line 329: If (p_rec.name = hr_api.g_varchar2) then

325: -- p_rec plsql record structure
326: -- to see if a system default is being used. If a system default
327: -- is being used then we must set to the 'current' argument value.
328: --
329: If (p_rec.name = hr_api.g_varchar2) then
330: p_rec.name :=
331: hxc_hrr_shd.g_old_rec.name;
332: End If;
333: If (p_rec.business_group_id = hr_api.g_number) then

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

329: If (p_rec.name = hr_api.g_varchar2) then
330: p_rec.name :=
331: hxc_hrr_shd.g_old_rec.name;
332: End If;
333: If (p_rec.business_group_id = hr_api.g_number) then
334: p_rec.business_group_id :=
335: hxc_ter_shd.g_old_rec.business_group_id;
336: End If;
337: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

333: If (p_rec.business_group_id = hr_api.g_number) then
334: p_rec.business_group_id :=
335: hxc_ter_shd.g_old_rec.business_group_id;
336: End If;
337: If (p_rec.legislation_code = hr_api.g_varchar2) then
338: p_rec.legislation_code :=
339: hxc_ter_shd.g_old_rec.legislation_code;
340: End If;
341: If (p_rec.eligibility_criteria_type = hr_api.g_varchar2) then

Line 341: If (p_rec.eligibility_criteria_type = hr_api.g_varchar2) then

337: If (p_rec.legislation_code = hr_api.g_varchar2) then
338: p_rec.legislation_code :=
339: hxc_ter_shd.g_old_rec.legislation_code;
340: End If;
341: If (p_rec.eligibility_criteria_type = hr_api.g_varchar2) then
342: p_rec.eligibility_criteria_type :=
343: hxc_hrr_shd.g_old_rec.eligibility_criteria_type;
344: End If;
345:

Line 347: -- hr_api.g_number -> hr_api.g_varchar2

343: hxc_hrr_shd.g_old_rec.eligibility_criteria_type;
344: End If;
345:
346: -- GPM 26-APR-01 115.8
347: -- hr_api.g_number -> hr_api.g_varchar2
348:
349: If (p_rec.eligibility_criteria_id = hr_api.g_varchar2) then
350: p_rec.eligibility_criteria_id :=
351: hxc_hrr_shd.g_old_rec.eligibility_criteria_id;

Line 349: If (p_rec.eligibility_criteria_id = hr_api.g_varchar2) then

345:
346: -- GPM 26-APR-01 115.8
347: -- hr_api.g_number -> hr_api.g_varchar2
348:
349: If (p_rec.eligibility_criteria_id = hr_api.g_varchar2) then
350: p_rec.eligibility_criteria_id :=
351: hxc_hrr_shd.g_old_rec.eligibility_criteria_id;
352: End If;
353: If (p_rec.pref_hierarchy_id = hr_api.g_number) then

Line 353: If (p_rec.pref_hierarchy_id = hr_api.g_number) then

349: If (p_rec.eligibility_criteria_id = hr_api.g_varchar2) then
350: p_rec.eligibility_criteria_id :=
351: hxc_hrr_shd.g_old_rec.eligibility_criteria_id;
352: End If;
353: If (p_rec.pref_hierarchy_id = hr_api.g_number) then
354: p_rec.pref_hierarchy_id :=
355: hxc_hrr_shd.g_old_rec.pref_hierarchy_id;
356: End If;
357: If (p_rec.rule_evaluation_order = hr_api.g_number) then

Line 357: If (p_rec.rule_evaluation_order = hr_api.g_number) then

353: If (p_rec.pref_hierarchy_id = hr_api.g_number) then
354: p_rec.pref_hierarchy_id :=
355: hxc_hrr_shd.g_old_rec.pref_hierarchy_id;
356: End If;
357: If (p_rec.rule_evaluation_order = hr_api.g_number) then
358: p_rec.rule_evaluation_order :=
359: hxc_hrr_shd.g_old_rec.rule_evaluation_order;
360: End If;
361: If (p_rec.resource_type = hr_api.g_varchar2) then

Line 361: If (p_rec.resource_type = hr_api.g_varchar2) then

357: If (p_rec.rule_evaluation_order = hr_api.g_number) then
358: p_rec.rule_evaluation_order :=
359: hxc_hrr_shd.g_old_rec.rule_evaluation_order;
360: End If;
361: If (p_rec.resource_type = hr_api.g_varchar2) then
362: p_rec.resource_type :=
363: hxc_hrr_shd.g_old_rec.resource_type;
364: End If;
365: If (p_rec.start_date = hr_api.g_date) then

Line 365: If (p_rec.start_date = hr_api.g_date) then

361: If (p_rec.resource_type = hr_api.g_varchar2) then
362: p_rec.resource_type :=
363: hxc_hrr_shd.g_old_rec.resource_type;
364: End If;
365: If (p_rec.start_date = hr_api.g_date) then
366: p_rec.start_date :=
367: hxc_hrr_shd.g_old_rec.start_date;
368: End If;
369: If (p_rec.end_date = hr_api.g_date) then

Line 369: If (p_rec.end_date = hr_api.g_date) then

365: If (p_rec.start_date = hr_api.g_date) then
366: p_rec.start_date :=
367: hxc_hrr_shd.g_old_rec.start_date;
368: End If;
369: If (p_rec.end_date = hr_api.g_date) then
370: p_rec.end_date :=
371: hxc_hrr_shd.g_old_rec.end_date;
372: End If;
373: --

Line 435: ,p_name in varchar2 default hr_api.g_varchar2

431: Procedure upd
432: (p_effective_date in date
433: ,p_resource_rule_id in number
434: ,p_object_version_number in out nocopy number
435: ,p_name in varchar2 default hr_api.g_varchar2
436: ,p_business_group_id in number default hr_api.g_number
437: ,p_legislation_code in varchar2 default hr_api.g_varchar2
438: ,p_eligibility_criteria_type in varchar2 default hr_api.g_varchar2
439: ,p_eligibility_criteria_id in varchar2 default hr_api.g_varchar2

Line 436: ,p_business_group_id in number default hr_api.g_number

432: (p_effective_date in date
433: ,p_resource_rule_id in number
434: ,p_object_version_number in out nocopy number
435: ,p_name in varchar2 default hr_api.g_varchar2
436: ,p_business_group_id in number default hr_api.g_number
437: ,p_legislation_code in varchar2 default hr_api.g_varchar2
438: ,p_eligibility_criteria_type in varchar2 default hr_api.g_varchar2
439: ,p_eligibility_criteria_id in varchar2 default hr_api.g_varchar2
440: ,p_pref_hierarchy_id in number default hr_api.g_number

Line 437: ,p_legislation_code in varchar2 default hr_api.g_varchar2

433: ,p_resource_rule_id in number
434: ,p_object_version_number in out nocopy number
435: ,p_name in varchar2 default hr_api.g_varchar2
436: ,p_business_group_id in number default hr_api.g_number
437: ,p_legislation_code in varchar2 default hr_api.g_varchar2
438: ,p_eligibility_criteria_type in varchar2 default hr_api.g_varchar2
439: ,p_eligibility_criteria_id in varchar2 default hr_api.g_varchar2
440: ,p_pref_hierarchy_id in number default hr_api.g_number
441: ,p_rule_evaluation_order in number default hr_api.g_number

Line 438: ,p_eligibility_criteria_type in varchar2 default hr_api.g_varchar2

434: ,p_object_version_number in out nocopy number
435: ,p_name in varchar2 default hr_api.g_varchar2
436: ,p_business_group_id in number default hr_api.g_number
437: ,p_legislation_code in varchar2 default hr_api.g_varchar2
438: ,p_eligibility_criteria_type in varchar2 default hr_api.g_varchar2
439: ,p_eligibility_criteria_id in varchar2 default hr_api.g_varchar2
440: ,p_pref_hierarchy_id in number default hr_api.g_number
441: ,p_rule_evaluation_order in number default hr_api.g_number
442: ,p_resource_type in varchar2 default hr_api.g_varchar2

Line 439: ,p_eligibility_criteria_id in varchar2 default hr_api.g_varchar2

435: ,p_name in varchar2 default hr_api.g_varchar2
436: ,p_business_group_id in number default hr_api.g_number
437: ,p_legislation_code in varchar2 default hr_api.g_varchar2
438: ,p_eligibility_criteria_type in varchar2 default hr_api.g_varchar2
439: ,p_eligibility_criteria_id in varchar2 default hr_api.g_varchar2
440: ,p_pref_hierarchy_id in number default hr_api.g_number
441: ,p_rule_evaluation_order in number default hr_api.g_number
442: ,p_resource_type in varchar2 default hr_api.g_varchar2
443: ,p_start_date in date default hr_api.g_date

Line 440: ,p_pref_hierarchy_id in number default hr_api.g_number

436: ,p_business_group_id in number default hr_api.g_number
437: ,p_legislation_code in varchar2 default hr_api.g_varchar2
438: ,p_eligibility_criteria_type in varchar2 default hr_api.g_varchar2
439: ,p_eligibility_criteria_id in varchar2 default hr_api.g_varchar2
440: ,p_pref_hierarchy_id in number default hr_api.g_number
441: ,p_rule_evaluation_order in number default hr_api.g_number
442: ,p_resource_type in varchar2 default hr_api.g_varchar2
443: ,p_start_date in date default hr_api.g_date
444: ,p_end_date in date default hr_api.g_date

Line 441: ,p_rule_evaluation_order in number default hr_api.g_number

437: ,p_legislation_code in varchar2 default hr_api.g_varchar2
438: ,p_eligibility_criteria_type in varchar2 default hr_api.g_varchar2
439: ,p_eligibility_criteria_id in varchar2 default hr_api.g_varchar2
440: ,p_pref_hierarchy_id in number default hr_api.g_number
441: ,p_rule_evaluation_order in number default hr_api.g_number
442: ,p_resource_type in varchar2 default hr_api.g_varchar2
443: ,p_start_date in date default hr_api.g_date
444: ,p_end_date in date default hr_api.g_date
445: ) is

Line 442: ,p_resource_type in varchar2 default hr_api.g_varchar2

438: ,p_eligibility_criteria_type in varchar2 default hr_api.g_varchar2
439: ,p_eligibility_criteria_id in varchar2 default hr_api.g_varchar2
440: ,p_pref_hierarchy_id in number default hr_api.g_number
441: ,p_rule_evaluation_order in number default hr_api.g_number
442: ,p_resource_type in varchar2 default hr_api.g_varchar2
443: ,p_start_date in date default hr_api.g_date
444: ,p_end_date in date default hr_api.g_date
445: ) is
446: --

Line 443: ,p_start_date in date default hr_api.g_date

439: ,p_eligibility_criteria_id in varchar2 default hr_api.g_varchar2
440: ,p_pref_hierarchy_id in number default hr_api.g_number
441: ,p_rule_evaluation_order in number default hr_api.g_number
442: ,p_resource_type in varchar2 default hr_api.g_varchar2
443: ,p_start_date in date default hr_api.g_date
444: ,p_end_date in date default hr_api.g_date
445: ) is
446: --
447: l_rec hxc_hrr_shd.g_rec_type;

Line 444: ,p_end_date in date default hr_api.g_date

440: ,p_pref_hierarchy_id in number default hr_api.g_number
441: ,p_rule_evaluation_order in number default hr_api.g_number
442: ,p_resource_type in varchar2 default hr_api.g_varchar2
443: ,p_start_date in date default hr_api.g_date
444: ,p_end_date in date default hr_api.g_date
445: ) is
446: --
447: l_rec hxc_hrr_shd.g_rec_type;
448: l_proc varchar2(72);