DBA Data[Home] [Help]

APPS.HXC_ULP_UPD dependencies on HXC_ULP_SHD

Line 56: (p_rec in out nocopy hxc_ulp_shd.g_rec_type

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

Line 102: hxc_ulp_shd.constraint_error

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

Line 107: hxc_ulp_shd.constraint_error

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

Line 112: hxc_ulp_shd.constraint_error

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

Line 152: (p_rec in hxc_ulp_shd.g_rec_type

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

Line 199: (p_rec in hxc_ulp_shd.g_rec_type

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

Line 232: => hxc_ulp_shd.g_old_rec.layout_component_id

228: => p_rec.attribute_application_id
229: ,p_object_version_number
230: => p_rec.object_version_number
231: ,p_layout_component_id_o
232: => hxc_ulp_shd.g_old_rec.layout_component_id
233: ,p_prompt_alias_o
234: => hxc_ulp_shd.g_old_rec.prompt_alias
235: ,p_prompt_type_o
236: => hxc_ulp_shd.g_old_rec.prompt_type

Line 234: => hxc_ulp_shd.g_old_rec.prompt_alias

230: => p_rec.object_version_number
231: ,p_layout_component_id_o
232: => hxc_ulp_shd.g_old_rec.layout_component_id
233: ,p_prompt_alias_o
234: => hxc_ulp_shd.g_old_rec.prompt_alias
235: ,p_prompt_type_o
236: => hxc_ulp_shd.g_old_rec.prompt_type
237: ,p_region_code_o
238: => hxc_ulp_shd.g_old_rec.region_code

Line 236: => hxc_ulp_shd.g_old_rec.prompt_type

232: => hxc_ulp_shd.g_old_rec.layout_component_id
233: ,p_prompt_alias_o
234: => hxc_ulp_shd.g_old_rec.prompt_alias
235: ,p_prompt_type_o
236: => hxc_ulp_shd.g_old_rec.prompt_type
237: ,p_region_code_o
238: => hxc_ulp_shd.g_old_rec.region_code
239: ,p_region_application_id_o
240: => hxc_ulp_shd.g_old_rec.region_application_id

Line 238: => hxc_ulp_shd.g_old_rec.region_code

234: => hxc_ulp_shd.g_old_rec.prompt_alias
235: ,p_prompt_type_o
236: => hxc_ulp_shd.g_old_rec.prompt_type
237: ,p_region_code_o
238: => hxc_ulp_shd.g_old_rec.region_code
239: ,p_region_application_id_o
240: => hxc_ulp_shd.g_old_rec.region_application_id
241: ,p_attribute_code_o
242: => hxc_ulp_shd.g_old_rec.attribute_code

Line 240: => hxc_ulp_shd.g_old_rec.region_application_id

236: => hxc_ulp_shd.g_old_rec.prompt_type
237: ,p_region_code_o
238: => hxc_ulp_shd.g_old_rec.region_code
239: ,p_region_application_id_o
240: => hxc_ulp_shd.g_old_rec.region_application_id
241: ,p_attribute_code_o
242: => hxc_ulp_shd.g_old_rec.attribute_code
243: ,p_attribute_application_id_o
244: => hxc_ulp_shd.g_old_rec.attribute_application_id

Line 242: => hxc_ulp_shd.g_old_rec.attribute_code

238: => hxc_ulp_shd.g_old_rec.region_code
239: ,p_region_application_id_o
240: => hxc_ulp_shd.g_old_rec.region_application_id
241: ,p_attribute_code_o
242: => hxc_ulp_shd.g_old_rec.attribute_code
243: ,p_attribute_application_id_o
244: => hxc_ulp_shd.g_old_rec.attribute_application_id
245: ,p_object_version_number_o
246: => hxc_ulp_shd.g_old_rec.object_version_number

Line 244: => hxc_ulp_shd.g_old_rec.attribute_application_id

240: => hxc_ulp_shd.g_old_rec.region_application_id
241: ,p_attribute_code_o
242: => hxc_ulp_shd.g_old_rec.attribute_code
243: ,p_attribute_application_id_o
244: => hxc_ulp_shd.g_old_rec.attribute_application_id
245: ,p_object_version_number_o
246: => hxc_ulp_shd.g_old_rec.object_version_number
247: );
248: --

Line 246: => hxc_ulp_shd.g_old_rec.object_version_number

242: => hxc_ulp_shd.g_old_rec.attribute_code
243: ,p_attribute_application_id_o
244: => hxc_ulp_shd.g_old_rec.attribute_application_id
245: ,p_object_version_number_o
246: => hxc_ulp_shd.g_old_rec.object_version_number
247: );
248: --
249: exception
250: --

Line 308: (p_rec in out nocopy hxc_ulp_shd.g_rec_type

304: --
305: -- {End Of Comments}
306: -- ----------------------------------------------------------------------------
307: Procedure convert_defs
308: (p_rec in out nocopy hxc_ulp_shd.g_rec_type
309: ) is
310: --
311: Begin
312: --

Line 320: hxc_ulp_shd.g_old_rec.layout_component_id;

316: -- is being used then we must set to the 'current' argument value.
317: --
318: If (p_rec.layout_component_id = hr_api.g_number) then
319: p_rec.layout_component_id :=
320: hxc_ulp_shd.g_old_rec.layout_component_id;
321: End If;
322: If (p_rec.prompt_alias = hr_api.g_varchar2) then
323: p_rec.prompt_alias :=
324: hxc_ulp_shd.g_old_rec.prompt_alias;

Line 324: hxc_ulp_shd.g_old_rec.prompt_alias;

320: hxc_ulp_shd.g_old_rec.layout_component_id;
321: End If;
322: If (p_rec.prompt_alias = hr_api.g_varchar2) then
323: p_rec.prompt_alias :=
324: hxc_ulp_shd.g_old_rec.prompt_alias;
325: End If;
326: If (p_rec.prompt_type = hr_api.g_varchar2) then
327: p_rec.prompt_type :=
328: hxc_ulp_shd.g_old_rec.prompt_type;

Line 328: hxc_ulp_shd.g_old_rec.prompt_type;

324: hxc_ulp_shd.g_old_rec.prompt_alias;
325: End If;
326: If (p_rec.prompt_type = hr_api.g_varchar2) then
327: p_rec.prompt_type :=
328: hxc_ulp_shd.g_old_rec.prompt_type;
329: End If;
330: If (p_rec.region_code = hr_api.g_varchar2) then
331: p_rec.region_code :=
332: hxc_ulp_shd.g_old_rec.region_code;

Line 332: hxc_ulp_shd.g_old_rec.region_code;

328: hxc_ulp_shd.g_old_rec.prompt_type;
329: End If;
330: If (p_rec.region_code = hr_api.g_varchar2) then
331: p_rec.region_code :=
332: hxc_ulp_shd.g_old_rec.region_code;
333: End If;
334: If (p_rec.region_application_id = hr_api.g_number) then
335: p_rec.region_application_id :=
336: hxc_ulp_shd.g_old_rec.region_application_id;

Line 336: hxc_ulp_shd.g_old_rec.region_application_id;

332: hxc_ulp_shd.g_old_rec.region_code;
333: End If;
334: If (p_rec.region_application_id = hr_api.g_number) then
335: p_rec.region_application_id :=
336: hxc_ulp_shd.g_old_rec.region_application_id;
337: End If;
338: If (p_rec.attribute_code = hr_api.g_varchar2) then
339: p_rec.attribute_code :=
340: hxc_ulp_shd.g_old_rec.attribute_code;

Line 340: hxc_ulp_shd.g_old_rec.attribute_code;

336: hxc_ulp_shd.g_old_rec.region_application_id;
337: End If;
338: If (p_rec.attribute_code = hr_api.g_varchar2) then
339: p_rec.attribute_code :=
340: hxc_ulp_shd.g_old_rec.attribute_code;
341: End If;
342: If (p_rec.attribute_application_id = hr_api.g_number) then
343: p_rec.attribute_application_id :=
344: hxc_ulp_shd.g_old_rec.attribute_application_id;

Line 344: hxc_ulp_shd.g_old_rec.attribute_application_id;

340: hxc_ulp_shd.g_old_rec.attribute_code;
341: End If;
342: If (p_rec.attribute_application_id = hr_api.g_number) then
343: p_rec.attribute_application_id :=
344: hxc_ulp_shd.g_old_rec.attribute_application_id;
345: End If;
346: --
347: End convert_defs;
348: --

Line 353: (p_rec in out nocopy hxc_ulp_shd.g_rec_type

349: -- ----------------------------------------------------------------------------
350: -- |---------------------------------< upd >----------------------------------|
351: -- ----------------------------------------------------------------------------
352: Procedure upd
353: (p_rec in out nocopy hxc_ulp_shd.g_rec_type
354: ) is
355: --
356: l_proc varchar2(72) ;
357: --

Line 367: hxc_ulp_shd.lck

363: end if;
364: --
365: -- We must lock the row which we need to update.
366: --
367: hxc_ulp_shd.lck
368: (p_rec.layout_comp_prompt_id
369: ,p_rec.object_version_number
370: );
371: --

Line 413: l_rec hxc_ulp_shd.g_rec_type;

409: ,p_attribute_code in varchar2 default hr_api.g_varchar2
410: ,p_attribute_application_id in number default hr_api.g_number
411: ) is
412: --
413: l_rec hxc_ulp_shd.g_rec_type;
414: l_proc varchar2(72) ;
415: --
416: Begin
417: g_debug :=hr_utility.debug_enabled;

Line 427: hxc_ulp_shd.convert_args

423: -- Call conversion function to turn arguments into the
424: -- l_rec structure.
425: --
426: l_rec :=
427: hxc_ulp_shd.convert_args
428: (p_layout_comp_prompt_id
429: ,p_layout_component_id
430: ,p_prompt_alias
431: ,p_prompt_type