DBA Data[Home] [Help]

APPS.HXC_ATC_UPD dependencies on HXC_ATC_SHD

Line 56: (p_rec in out nocopy hxc_atc_shd.g_rec_type

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

Line 98: hxc_atc_shd.constraint_error

94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: --
98: hxc_atc_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: --

Line 103: hxc_atc_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: --
103: hxc_atc_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: --

Line 108: hxc_atc_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: --
108: hxc_atc_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: --
112: Raise;

Line 148: (p_rec in hxc_atc_shd.g_rec_type

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

Line 195: (p_rec in hxc_atc_shd.g_rec_type

191: --
192: -- {End Of Comments}
193: -- ----------------------------------------------------------------------------
194: Procedure post_update
195: (p_rec in hxc_atc_shd.g_rec_type
196: ) is
197: --
198: l_proc varchar2(72);
199: --

Line 221: => hxc_atc_shd.g_old_rec.component_name

217: => p_rec.alias_type_id
218: ,p_object_version_number
219: => p_rec.object_version_number
220: ,p_component_name_o
221: => hxc_atc_shd.g_old_rec.component_name
222: ,p_component_type_o
223: => hxc_atc_shd.g_old_rec.component_type
224: ,p_mapping_component_id_o
225: => hxc_atc_shd.g_old_rec.mapping_component_id

Line 223: => hxc_atc_shd.g_old_rec.component_type

219: => p_rec.object_version_number
220: ,p_component_name_o
221: => hxc_atc_shd.g_old_rec.component_name
222: ,p_component_type_o
223: => hxc_atc_shd.g_old_rec.component_type
224: ,p_mapping_component_id_o
225: => hxc_atc_shd.g_old_rec.mapping_component_id
226: ,p_alias_type_id_o
227: => hxc_atc_shd.g_old_rec.alias_type_id

Line 225: => hxc_atc_shd.g_old_rec.mapping_component_id

221: => hxc_atc_shd.g_old_rec.component_name
222: ,p_component_type_o
223: => hxc_atc_shd.g_old_rec.component_type
224: ,p_mapping_component_id_o
225: => hxc_atc_shd.g_old_rec.mapping_component_id
226: ,p_alias_type_id_o
227: => hxc_atc_shd.g_old_rec.alias_type_id
228: ,p_object_version_number_o
229: => hxc_atc_shd.g_old_rec.object_version_number

Line 227: => hxc_atc_shd.g_old_rec.alias_type_id

223: => hxc_atc_shd.g_old_rec.component_type
224: ,p_mapping_component_id_o
225: => hxc_atc_shd.g_old_rec.mapping_component_id
226: ,p_alias_type_id_o
227: => hxc_atc_shd.g_old_rec.alias_type_id
228: ,p_object_version_number_o
229: => hxc_atc_shd.g_old_rec.object_version_number
230: );
231:

Line 229: => hxc_atc_shd.g_old_rec.object_version_number

225: => hxc_atc_shd.g_old_rec.mapping_component_id
226: ,p_alias_type_id_o
227: => hxc_atc_shd.g_old_rec.alias_type_id
228: ,p_object_version_number_o
229: => hxc_atc_shd.g_old_rec.object_version_number
230: );
231:
232: hxc_time_category_utils_pkg.alias_type_comp_ref_int_chk ( p_rec.alias_type_id );
233:

Line 293: (p_rec in out nocopy hxc_atc_shd.g_rec_type

289: --
290: -- {End Of Comments}
291: -- ----------------------------------------------------------------------------
292: Procedure convert_defs
293: (p_rec in out nocopy hxc_atc_shd.g_rec_type
294: ) is
295: --
296: Begin
297: --

Line 305: hxc_atc_shd.g_old_rec.component_name;

301: -- is being used then we must set to the 'current' argument value.
302: --
303: If (p_rec.component_name = hr_api.g_varchar2) then
304: p_rec.component_name :=
305: hxc_atc_shd.g_old_rec.component_name;
306: End If;
307: If (p_rec.component_type = hr_api.g_varchar2) then
308: p_rec.component_type :=
309: hxc_atc_shd.g_old_rec.component_type;

Line 309: hxc_atc_shd.g_old_rec.component_type;

305: hxc_atc_shd.g_old_rec.component_name;
306: End If;
307: If (p_rec.component_type = hr_api.g_varchar2) then
308: p_rec.component_type :=
309: hxc_atc_shd.g_old_rec.component_type;
310: End If;
311: If (p_rec.mapping_component_id = hr_api.g_number) then
312: p_rec.mapping_component_id :=
313: hxc_atc_shd.g_old_rec.mapping_component_id;

Line 313: hxc_atc_shd.g_old_rec.mapping_component_id;

309: hxc_atc_shd.g_old_rec.component_type;
310: End If;
311: If (p_rec.mapping_component_id = hr_api.g_number) then
312: p_rec.mapping_component_id :=
313: hxc_atc_shd.g_old_rec.mapping_component_id;
314: End If;
315: If (p_rec.alias_type_id = hr_api.g_number) then
316: p_rec.alias_type_id :=
317: hxc_atc_shd.g_old_rec.alias_type_id;

Line 317: hxc_atc_shd.g_old_rec.alias_type_id;

313: hxc_atc_shd.g_old_rec.mapping_component_id;
314: End If;
315: If (p_rec.alias_type_id = hr_api.g_number) then
316: p_rec.alias_type_id :=
317: hxc_atc_shd.g_old_rec.alias_type_id;
318: End If;
319: --
320: End convert_defs;
321: --

Line 326: (p_rec in out nocopy hxc_atc_shd.g_rec_type

322: -- ----------------------------------------------------------------------------
323: -- |---------------------------------< upd >----------------------------------|
324: -- ----------------------------------------------------------------------------
325: Procedure upd
326: (p_rec in out nocopy hxc_atc_shd.g_rec_type
327: ) is
328: --
329: l_proc varchar2(72);
330: --

Line 340: hxc_atc_shd.lck

336: end if;
337: --
338: -- We must lock the row which we need to update.
339: --
340: hxc_atc_shd.lck
341: (p_rec.alias_type_component_id
342: ,p_rec.object_version_number
343: );
344: --

Line 389: l_rec hxc_atc_shd.g_rec_type;

385: ,p_mapping_component_id in number default hr_api.g_number
386: ,p_alias_type_id in number default hr_api.g_number
387: ) is
388: --
389: l_rec hxc_atc_shd.g_rec_type;
390: l_proc varchar2(72);
391: --
392: Begin
393: g_debug:=hr_utility.debug_enabled;

Line 403: hxc_atc_shd.convert_args

399: -- Call conversion function to turn arguments into the
400: -- l_rec structure.
401: --
402: l_rec :=
403: hxc_atc_shd.convert_args
404: (p_alias_type_component_id
405: ,p_component_name
406: ,p_component_type
407: ,p_mapping_component_id