DBA Data[Home] [Help]

APPS.HXC_ULA_UPD dependencies on HXC_ULA_SHD

Line 56: (p_rec in out nocopy hxc_ula_shd.g_rec_type

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

Line 101: hxc_ula_shd.constraint_error

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

Line 106: hxc_ula_shd.constraint_error

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

Line 111: hxc_ula_shd.constraint_error

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

Line 151: (p_rec in hxc_ula_shd.g_rec_type

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

Line 198: (p_rec in hxc_ula_shd.g_rec_type

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

Line 229: => hxc_ula_shd.g_old_rec.layout_name

225: => p_rec.top_level_region_code
226: ,p_object_version_number
227: => p_rec.object_version_number
228: ,p_layout_name_o
229: => hxc_ula_shd.g_old_rec.layout_name
230: ,p_application_id_o
231: => hxc_ula_shd.g_old_rec.application_id
232: ,p_layout_type_o
233: => hxc_ula_shd.g_old_rec.layout_type

Line 231: => hxc_ula_shd.g_old_rec.application_id

227: => p_rec.object_version_number
228: ,p_layout_name_o
229: => hxc_ula_shd.g_old_rec.layout_name
230: ,p_application_id_o
231: => hxc_ula_shd.g_old_rec.application_id
232: ,p_layout_type_o
233: => hxc_ula_shd.g_old_rec.layout_type
234: ,p_modifier_level_o
235: => hxc_ula_shd.g_old_rec.modifier_level

Line 233: => hxc_ula_shd.g_old_rec.layout_type

229: => hxc_ula_shd.g_old_rec.layout_name
230: ,p_application_id_o
231: => hxc_ula_shd.g_old_rec.application_id
232: ,p_layout_type_o
233: => hxc_ula_shd.g_old_rec.layout_type
234: ,p_modifier_level_o
235: => hxc_ula_shd.g_old_rec.modifier_level
236: ,p_modifier_value_o
237: => hxc_ula_shd.g_old_rec.modifier_value

Line 235: => hxc_ula_shd.g_old_rec.modifier_level

231: => hxc_ula_shd.g_old_rec.application_id
232: ,p_layout_type_o
233: => hxc_ula_shd.g_old_rec.layout_type
234: ,p_modifier_level_o
235: => hxc_ula_shd.g_old_rec.modifier_level
236: ,p_modifier_value_o
237: => hxc_ula_shd.g_old_rec.modifier_value
238: ,p_top_level_region_code_o
239: => hxc_ula_shd.g_old_rec.top_level_region_code

Line 237: => hxc_ula_shd.g_old_rec.modifier_value

233: => hxc_ula_shd.g_old_rec.layout_type
234: ,p_modifier_level_o
235: => hxc_ula_shd.g_old_rec.modifier_level
236: ,p_modifier_value_o
237: => hxc_ula_shd.g_old_rec.modifier_value
238: ,p_top_level_region_code_o
239: => hxc_ula_shd.g_old_rec.top_level_region_code
240: ,p_object_version_number_o
241: => hxc_ula_shd.g_old_rec.object_version_number

Line 239: => hxc_ula_shd.g_old_rec.top_level_region_code

235: => hxc_ula_shd.g_old_rec.modifier_level
236: ,p_modifier_value_o
237: => hxc_ula_shd.g_old_rec.modifier_value
238: ,p_top_level_region_code_o
239: => hxc_ula_shd.g_old_rec.top_level_region_code
240: ,p_object_version_number_o
241: => hxc_ula_shd.g_old_rec.object_version_number
242: );
243: --

Line 241: => hxc_ula_shd.g_old_rec.object_version_number

237: => hxc_ula_shd.g_old_rec.modifier_value
238: ,p_top_level_region_code_o
239: => hxc_ula_shd.g_old_rec.top_level_region_code
240: ,p_object_version_number_o
241: => hxc_ula_shd.g_old_rec.object_version_number
242: );
243: --
244: exception
245: --

Line 303: (p_rec in out nocopy hxc_ula_shd.g_rec_type

299: --
300: -- {End Of Comments}
301: -- ----------------------------------------------------------------------------
302: Procedure convert_defs
303: (p_rec in out nocopy hxc_ula_shd.g_rec_type
304: ) is
305: --
306: Begin
307: --

Line 315: hxc_ula_shd.g_old_rec.layout_name;

311: -- is being used then we must set to the 'current' argument value.
312: --
313: If (p_rec.layout_name = hr_api.g_varchar2) then
314: p_rec.layout_name :=
315: hxc_ula_shd.g_old_rec.layout_name;
316: End If;
317: If (p_rec.application_id = hr_api.g_number) then
318: p_rec.application_id :=
319: hxc_ula_shd.g_old_rec.application_id;

Line 319: hxc_ula_shd.g_old_rec.application_id;

315: hxc_ula_shd.g_old_rec.layout_name;
316: End If;
317: If (p_rec.application_id = hr_api.g_number) then
318: p_rec.application_id :=
319: hxc_ula_shd.g_old_rec.application_id;
320: End If;
321: If (p_rec.layout_type = hr_api.g_varchar2) then
322: p_rec.layout_type :=
323: hxc_ula_shd.g_old_rec.layout_type;

Line 323: hxc_ula_shd.g_old_rec.layout_type;

319: hxc_ula_shd.g_old_rec.application_id;
320: End If;
321: If (p_rec.layout_type = hr_api.g_varchar2) then
322: p_rec.layout_type :=
323: hxc_ula_shd.g_old_rec.layout_type;
324: End If;
325: If (p_rec.modifier_level = hr_api.g_varchar2) then
326: p_rec.modifier_level :=
327: hxc_ula_shd.g_old_rec.modifier_level;

Line 327: hxc_ula_shd.g_old_rec.modifier_level;

323: hxc_ula_shd.g_old_rec.layout_type;
324: End If;
325: If (p_rec.modifier_level = hr_api.g_varchar2) then
326: p_rec.modifier_level :=
327: hxc_ula_shd.g_old_rec.modifier_level;
328: End If;
329: If (p_rec.modifier_value = hr_api.g_varchar2) then
330: p_rec.modifier_value :=
331: hxc_ula_shd.g_old_rec.modifier_value;

Line 331: hxc_ula_shd.g_old_rec.modifier_value;

327: hxc_ula_shd.g_old_rec.modifier_level;
328: End If;
329: If (p_rec.modifier_value = hr_api.g_varchar2) then
330: p_rec.modifier_value :=
331: hxc_ula_shd.g_old_rec.modifier_value;
332: End If;
333: If (p_rec.top_level_region_code = hr_api.g_varchar2) then
334: p_rec.top_level_region_code :=
335: hxc_ula_shd.g_old_rec.top_level_region_code;

Line 335: hxc_ula_shd.g_old_rec.top_level_region_code;

331: hxc_ula_shd.g_old_rec.modifier_value;
332: End If;
333: If (p_rec.top_level_region_code = hr_api.g_varchar2) then
334: p_rec.top_level_region_code :=
335: hxc_ula_shd.g_old_rec.top_level_region_code;
336: End If;
337: --
338: End convert_defs;
339: --

Line 344: (p_rec in out nocopy hxc_ula_shd.g_rec_type

340: -- ----------------------------------------------------------------------------
341: -- |---------------------------------< upd >----------------------------------|
342: -- ----------------------------------------------------------------------------
343: Procedure upd
344: (p_rec in out nocopy hxc_ula_shd.g_rec_type
345: ) is
346: --
347: l_proc varchar2(72) ;
348: --

Line 358: hxc_ula_shd.lck

354: end if;
355: --
356: -- We must lock the row which we need to update.
357: --
358: hxc_ula_shd.lck
359: (p_rec.layout_id
360: ,p_rec.object_version_number
361: );
362: --

Line 403: l_rec hxc_ula_shd.g_rec_type;

399: ,p_modifier_value in varchar2 default hr_api.g_varchar2
400: ,p_top_level_region_code in varchar2 default hr_api.g_varchar2
401: ) is
402: --
403: l_rec hxc_ula_shd.g_rec_type;
404: l_proc varchar2(72) ;
405: --
406: Begin
407: g_debug :=hr_utility.debug_enabled;

Line 417: hxc_ula_shd.convert_args

413: -- Call conversion function to turn arguments into the
414: -- l_rec structure.
415: --
416: l_rec :=
417: hxc_ula_shd.convert_args
418: (p_layout_id
419: ,p_layout_name
420: ,p_application_id
421: ,p_layout_type