DBA Data[Home] [Help]

APPS.HXC_HRP_UPD dependencies on HXC_HRP_SHD

Line 56: (p_rec in out nocopy hxc_hrp_shd.g_rec_type

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

Line 99: hxc_hrp_shd.constraint_error

95: Exception
96: When hr_api.check_integrity_violated Then
97: -- A check constraint has been violated
98: --
99: hxc_hrp_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: --

Line 104: hxc_hrp_shd.constraint_error

100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: --
104: hxc_hrp_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: --

Line 109: hxc_hrp_shd.constraint_error

105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: --
109: hxc_hrp_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: --
113: Raise;

Line 149: (p_rec in hxc_hrp_shd.g_rec_type

145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_update
149: (p_rec in hxc_hrp_shd.g_rec_type
150: ) is
151: --
152: l_proc varchar2(72);
153: --

Line 197: ,p_rec in hxc_hrp_shd.g_rec_type

193: -- {End Of Comments}
194: -- ----------------------------------------------------------------------------
195: Procedure post_update
196: (p_effective_date in date
197: ,p_rec in hxc_hrp_shd.g_rec_type
198: ) is
199: --
200: l_proc varchar2(72);
201: --

Line 226: => hxc_hrp_shd.g_old_rec.name

222: => p_rec.duration_in_days
223: ,p_object_version_number
224: => p_rec.object_version_number
225: ,p_name_o
226: => hxc_hrp_shd.g_old_rec.name
227: ,p_start_date_o
228: => hxc_hrp_shd.g_old_rec.start_date
229: ,p_end_date_o
230: => hxc_hrp_shd.g_old_rec.end_date

Line 228: => hxc_hrp_shd.g_old_rec.start_date

224: => p_rec.object_version_number
225: ,p_name_o
226: => hxc_hrp_shd.g_old_rec.name
227: ,p_start_date_o
228: => hxc_hrp_shd.g_old_rec.start_date
229: ,p_end_date_o
230: => hxc_hrp_shd.g_old_rec.end_date
231: ,p_period_type_o
232: => hxc_hrp_shd.g_old_rec.period_type

Line 230: => hxc_hrp_shd.g_old_rec.end_date

226: => hxc_hrp_shd.g_old_rec.name
227: ,p_start_date_o
228: => hxc_hrp_shd.g_old_rec.start_date
229: ,p_end_date_o
230: => hxc_hrp_shd.g_old_rec.end_date
231: ,p_period_type_o
232: => hxc_hrp_shd.g_old_rec.period_type
233: ,p_duration_in_days_o
234: => hxc_hrp_shd.g_old_rec.duration_in_days

Line 232: => hxc_hrp_shd.g_old_rec.period_type

228: => hxc_hrp_shd.g_old_rec.start_date
229: ,p_end_date_o
230: => hxc_hrp_shd.g_old_rec.end_date
231: ,p_period_type_o
232: => hxc_hrp_shd.g_old_rec.period_type
233: ,p_duration_in_days_o
234: => hxc_hrp_shd.g_old_rec.duration_in_days
235: ,p_object_version_number_o
236: => hxc_hrp_shd.g_old_rec.object_version_number

Line 234: => hxc_hrp_shd.g_old_rec.duration_in_days

230: => hxc_hrp_shd.g_old_rec.end_date
231: ,p_period_type_o
232: => hxc_hrp_shd.g_old_rec.period_type
233: ,p_duration_in_days_o
234: => hxc_hrp_shd.g_old_rec.duration_in_days
235: ,p_object_version_number_o
236: => hxc_hrp_shd.g_old_rec.object_version_number
237: );
238: --

Line 236: => hxc_hrp_shd.g_old_rec.object_version_number

232: => hxc_hrp_shd.g_old_rec.period_type
233: ,p_duration_in_days_o
234: => hxc_hrp_shd.g_old_rec.duration_in_days
235: ,p_object_version_number_o
236: => hxc_hrp_shd.g_old_rec.object_version_number
237: );
238: --
239: exception
240: --

Line 298: (p_rec in out nocopy hxc_hrp_shd.g_rec_type

294: --
295: -- {End Of Comments}
296: -- ----------------------------------------------------------------------------
297: Procedure convert_defs
298: (p_rec in out nocopy hxc_hrp_shd.g_rec_type
299: ) is
300: --
301: Begin
302: --

Line 310: hxc_hrp_shd.g_old_rec.name;

306: -- is being used then we must set to the 'current' argument value.
307: --
308: If (p_rec.name = hr_api.g_varchar2) then
309: p_rec.name :=
310: hxc_hrp_shd.g_old_rec.name;
311: End If;
312: If (p_rec.start_date = hr_api.g_date) then
313: p_rec.start_date :=
314: hxc_hrp_shd.g_old_rec.start_date;

Line 314: hxc_hrp_shd.g_old_rec.start_date;

310: hxc_hrp_shd.g_old_rec.name;
311: End If;
312: If (p_rec.start_date = hr_api.g_date) then
313: p_rec.start_date :=
314: hxc_hrp_shd.g_old_rec.start_date;
315: End If;
316: If (p_rec.end_date = hr_api.g_date) then
317: p_rec.end_date :=
318: hxc_hrp_shd.g_old_rec.end_date;

Line 318: hxc_hrp_shd.g_old_rec.end_date;

314: hxc_hrp_shd.g_old_rec.start_date;
315: End If;
316: If (p_rec.end_date = hr_api.g_date) then
317: p_rec.end_date :=
318: hxc_hrp_shd.g_old_rec.end_date;
319: End If;
320: If (p_rec.period_type = hr_api.g_varchar2) then
321: p_rec.period_type :=
322: hxc_hrp_shd.g_old_rec.period_type;

Line 322: hxc_hrp_shd.g_old_rec.period_type;

318: hxc_hrp_shd.g_old_rec.end_date;
319: End If;
320: If (p_rec.period_type = hr_api.g_varchar2) then
321: p_rec.period_type :=
322: hxc_hrp_shd.g_old_rec.period_type;
323: End If;
324: If (p_rec.duration_in_days = hr_api.g_number) then
325: p_rec.duration_in_days :=
326: hxc_hrp_shd.g_old_rec.duration_in_days;

Line 326: hxc_hrp_shd.g_old_rec.duration_in_days;

322: hxc_hrp_shd.g_old_rec.period_type;
323: End If;
324: If (p_rec.duration_in_days = hr_api.g_number) then
325: p_rec.duration_in_days :=
326: hxc_hrp_shd.g_old_rec.duration_in_days;
327: End If;
328: --
329: End convert_defs;
330: --

Line 336: ,p_rec in out nocopy hxc_hrp_shd.g_rec_type

332: -- |---------------------------------< upd >----------------------------------|
333: -- ----------------------------------------------------------------------------
334: Procedure upd
335: (p_effective_date in date
336: ,p_rec in out nocopy hxc_hrp_shd.g_rec_type
337: ) is
338: --
339: l_proc varchar2(72);
340: --

Line 350: hxc_hrp_shd.lck

346: end if;
347: --
348: -- We must lock the row which we need to update.
349: --
350: hxc_hrp_shd.lck
351: (p_rec.recurring_period_id
352: ,p_rec.object_version_number
353: );
354: --

Line 397: l_rec hxc_hrp_shd.g_rec_type;

393: ,p_period_type in varchar2 default hr_api.g_varchar2
394: ,p_duration_in_days in number default hr_api.g_number
395: ) is
396: --
397: l_rec hxc_hrp_shd.g_rec_type;
398: l_proc varchar2(72);
399: --
400: Begin
401: g_debug:=hr_utility.debug_enabled;

Line 411: hxc_hrp_shd.convert_args

407: -- Call conversion function to turn arguments into the
408: -- l_rec structure.
409: --
410: l_rec :=
411: hxc_hrp_shd.convert_args
412: (p_recurring_period_id
413: ,p_name
414: ,p_start_date
415: ,p_end_date