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: --
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: --
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: --
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;
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: --
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: --
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
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
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
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
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
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
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: --
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: --
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: --
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;
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;
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;
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;
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;
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;
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: --
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: --
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: --
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;
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