DBA Data[Home] [Help]

APPS.HXC_HRR_UPD dependencies on HXC_HRR_SHD

Line 56: (p_rec in out nocopy hxc_hrr_shd.g_rec_type

52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy hxc_hrr_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72);
60: --

Line 104: hxc_hrr_shd.constraint_error

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));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: --

Line 109: 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));
111: When hr_api.unique_integrity_violated Then
112: -- Unique integrity has been violated
113: --

Line 114: 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));
116: When Others Then
117: --
118: Raise;

Line 154: (p_rec in hxc_hrr_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure pre_update
154: (p_rec in hxc_hrr_shd.g_rec_type
155: ) is
156: --
157: l_proc varchar2(72);
158: --

Line 202: ,p_rec in hxc_hrr_shd.g_rec_type

198: -- {End Of Comments}
199: -- ----------------------------------------------------------------------------
200: Procedure post_update
201: (p_effective_date in date
202: ,p_rec in hxc_hrr_shd.g_rec_type
203: ) is
204: --
205: l_proc varchar2(72);
206: --

Line 239: => hxc_hrr_shd.g_old_rec.name

235: => p_rec.end_date
236: ,p_object_version_number
237: => p_rec.object_version_number
238: ,p_name_o
239: => hxc_hrr_shd.g_old_rec.name
240: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
241: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
242: ,p_eligibility_criteria_type_o
243: => hxc_hrr_shd.g_old_rec.eligibility_criteria_type

Line 243: => hxc_hrr_shd.g_old_rec.eligibility_criteria_type

239: => hxc_hrr_shd.g_old_rec.name
240: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
241: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
242: ,p_eligibility_criteria_type_o
243: => hxc_hrr_shd.g_old_rec.eligibility_criteria_type
244: ,p_eligibility_criteria_id_o
245: => hxc_hrr_shd.g_old_rec.eligibility_criteria_id
246: ,p_pref_hierarchy_id_o
247: => hxc_hrr_shd.g_old_rec.pref_hierarchy_id

Line 245: => hxc_hrr_shd.g_old_rec.eligibility_criteria_id

241: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
242: ,p_eligibility_criteria_type_o
243: => hxc_hrr_shd.g_old_rec.eligibility_criteria_type
244: ,p_eligibility_criteria_id_o
245: => hxc_hrr_shd.g_old_rec.eligibility_criteria_id
246: ,p_pref_hierarchy_id_o
247: => hxc_hrr_shd.g_old_rec.pref_hierarchy_id
248: ,p_rule_evaluation_order_o
249: => hxc_hrr_shd.g_old_rec.rule_evaluation_order

Line 247: => hxc_hrr_shd.g_old_rec.pref_hierarchy_id

243: => hxc_hrr_shd.g_old_rec.eligibility_criteria_type
244: ,p_eligibility_criteria_id_o
245: => hxc_hrr_shd.g_old_rec.eligibility_criteria_id
246: ,p_pref_hierarchy_id_o
247: => hxc_hrr_shd.g_old_rec.pref_hierarchy_id
248: ,p_rule_evaluation_order_o
249: => hxc_hrr_shd.g_old_rec.rule_evaluation_order
250: ,p_resource_type_o
251: => hxc_hrr_shd.g_old_rec.resource_type

Line 249: => hxc_hrr_shd.g_old_rec.rule_evaluation_order

245: => hxc_hrr_shd.g_old_rec.eligibility_criteria_id
246: ,p_pref_hierarchy_id_o
247: => hxc_hrr_shd.g_old_rec.pref_hierarchy_id
248: ,p_rule_evaluation_order_o
249: => hxc_hrr_shd.g_old_rec.rule_evaluation_order
250: ,p_resource_type_o
251: => hxc_hrr_shd.g_old_rec.resource_type
252: ,p_start_date_o
253: => hxc_hrr_shd.g_old_rec.start_date

Line 251: => hxc_hrr_shd.g_old_rec.resource_type

247: => hxc_hrr_shd.g_old_rec.pref_hierarchy_id
248: ,p_rule_evaluation_order_o
249: => hxc_hrr_shd.g_old_rec.rule_evaluation_order
250: ,p_resource_type_o
251: => hxc_hrr_shd.g_old_rec.resource_type
252: ,p_start_date_o
253: => hxc_hrr_shd.g_old_rec.start_date
254: ,p_end_date_o
255: => hxc_hrr_shd.g_old_rec.end_date

Line 253: => hxc_hrr_shd.g_old_rec.start_date

249: => hxc_hrr_shd.g_old_rec.rule_evaluation_order
250: ,p_resource_type_o
251: => hxc_hrr_shd.g_old_rec.resource_type
252: ,p_start_date_o
253: => hxc_hrr_shd.g_old_rec.start_date
254: ,p_end_date_o
255: => hxc_hrr_shd.g_old_rec.end_date
256: ,p_object_version_number_o
257: => hxc_hrr_shd.g_old_rec.object_version_number

Line 255: => hxc_hrr_shd.g_old_rec.end_date

251: => hxc_hrr_shd.g_old_rec.resource_type
252: ,p_start_date_o
253: => hxc_hrr_shd.g_old_rec.start_date
254: ,p_end_date_o
255: => hxc_hrr_shd.g_old_rec.end_date
256: ,p_object_version_number_o
257: => hxc_hrr_shd.g_old_rec.object_version_number
258: );
259: --

Line 257: => hxc_hrr_shd.g_old_rec.object_version_number

253: => hxc_hrr_shd.g_old_rec.start_date
254: ,p_end_date_o
255: => hxc_hrr_shd.g_old_rec.end_date
256: ,p_object_version_number_o
257: => hxc_hrr_shd.g_old_rec.object_version_number
258: );
259: --
260: exception
261: --

Line 319: (p_rec in out nocopy hxc_hrr_shd.g_rec_type

315: --
316: -- {End Of Comments}
317: -- ----------------------------------------------------------------------------
318: Procedure convert_defs
319: (p_rec in out nocopy hxc_hrr_shd.g_rec_type
320: ) is
321: --
322: Begin
323: --

Line 331: hxc_hrr_shd.g_old_rec.name;

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
334: p_rec.business_group_id :=
335: hxc_ter_shd.g_old_rec.business_group_id;

Line 343: hxc_hrr_shd.g_old_rec.eligibility_criteria_type;

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:
346: -- GPM 26-APR-01 115.8
347: -- hr_api.g_number -> hr_api.g_varchar2

Line 351: hxc_hrr_shd.g_old_rec.eligibility_criteria_id;

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
354: p_rec.pref_hierarchy_id :=
355: hxc_hrr_shd.g_old_rec.pref_hierarchy_id;

Line 355: hxc_hrr_shd.g_old_rec.pref_hierarchy_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
358: p_rec.rule_evaluation_order :=
359: hxc_hrr_shd.g_old_rec.rule_evaluation_order;

Line 359: hxc_hrr_shd.g_old_rec.rule_evaluation_order;

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
362: p_rec.resource_type :=
363: hxc_hrr_shd.g_old_rec.resource_type;

Line 363: hxc_hrr_shd.g_old_rec.resource_type;

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
366: p_rec.start_date :=
367: hxc_hrr_shd.g_old_rec.start_date;

Line 367: hxc_hrr_shd.g_old_rec.start_date;

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
370: p_rec.end_date :=
371: hxc_hrr_shd.g_old_rec.end_date;

Line 371: hxc_hrr_shd.g_old_rec.end_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: --
374: End convert_defs;
375: --

Line 381: ,p_rec in out nocopy hxc_hrr_shd.g_rec_type

377: -- |---------------------------------< upd >----------------------------------|
378: -- ----------------------------------------------------------------------------
379: Procedure upd
380: (p_effective_date in date
381: ,p_rec in out nocopy hxc_hrr_shd.g_rec_type
382: ) is
383: --
384: l_proc varchar2(72);
385: --

Line 395: hxc_hrr_shd.lck

391: end if;
392: --
393: -- We must lock the row which we need to update.
394: --
395: hxc_hrr_shd.lck
396: (p_rec.resource_rule_id
397: ,p_rec.object_version_number
398: );
399: --

Line 447: l_rec hxc_hrr_shd.g_rec_type;

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);
449: --
450: Begin
451: g_debug:=hr_utility.debug_enabled;

Line 461: hxc_hrr_shd.convert_args

457: -- Call conversion function to turn arguments into the
458: -- l_rec structure.
459: --
460: l_rec :=
461: hxc_hrr_shd.convert_args
462: (p_resource_rule_id
463: ,p_name
464: ,p_business_group_id
465: ,p_legislation_code