[Home] [Help]
52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy hxc_ulc_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72) ;
60: --
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: --
113: hxc_ulc_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
118: hxc_ulc_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
123: hxc_ulc_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: --
127: Raise;
159: --
160: -- {End Of Comments}
161: -- ----------------------------------------------------------------------------
162: Procedure pre_update
163: (p_rec in hxc_ulc_shd.g_rec_type
164: ) is
165: --
166: l_proc varchar2(72) ;
167: --
206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure post_update
210: (p_rec in hxc_ulc_shd.g_rec_type
211: ) is
212: --
213: l_proc varchar2(72) ;
214: --
261: => p_rec.attribute4
262: ,p_attribute5
263: => p_rec.attribute5
264: ,p_layout_id_o
265: => hxc_ulc_shd.g_old_rec.layout_id
266: ,p_parent_component_id_o
267: => hxc_ulc_shd.g_old_rec.parent_component_id
268: ,p_component_name_o
269: => hxc_ulc_shd.g_old_rec.component_name
263: => p_rec.attribute5
264: ,p_layout_id_o
265: => hxc_ulc_shd.g_old_rec.layout_id
266: ,p_parent_component_id_o
267: => hxc_ulc_shd.g_old_rec.parent_component_id
268: ,p_component_name_o
269: => hxc_ulc_shd.g_old_rec.component_name
270: ,p_component_value_o
271: => hxc_ulc_shd.g_old_rec.component_value
265: => hxc_ulc_shd.g_old_rec.layout_id
266: ,p_parent_component_id_o
267: => hxc_ulc_shd.g_old_rec.parent_component_id
268: ,p_component_name_o
269: => hxc_ulc_shd.g_old_rec.component_name
270: ,p_component_value_o
271: => hxc_ulc_shd.g_old_rec.component_value
272: ,p_sequence_o
273: => hxc_ulc_shd.g_old_rec.sequence
267: => hxc_ulc_shd.g_old_rec.parent_component_id
268: ,p_component_name_o
269: => hxc_ulc_shd.g_old_rec.component_name
270: ,p_component_value_o
271: => hxc_ulc_shd.g_old_rec.component_value
272: ,p_sequence_o
273: => hxc_ulc_shd.g_old_rec.sequence
274: ,p_name_value_string_o
275: => hxc_ulc_shd.g_old_rec.name_value_string
269: => hxc_ulc_shd.g_old_rec.component_name
270: ,p_component_value_o
271: => hxc_ulc_shd.g_old_rec.component_value
272: ,p_sequence_o
273: => hxc_ulc_shd.g_old_rec.sequence
274: ,p_name_value_string_o
275: => hxc_ulc_shd.g_old_rec.name_value_string
276: ,p_region_code_o
277: => hxc_ulc_shd.g_old_rec.region_code
271: => hxc_ulc_shd.g_old_rec.component_value
272: ,p_sequence_o
273: => hxc_ulc_shd.g_old_rec.sequence
274: ,p_name_value_string_o
275: => hxc_ulc_shd.g_old_rec.name_value_string
276: ,p_region_code_o
277: => hxc_ulc_shd.g_old_rec.region_code
278: ,p_region_code_app_id_o
279: => hxc_ulc_shd.g_old_rec.region_code_app_id
273: => hxc_ulc_shd.g_old_rec.sequence
274: ,p_name_value_string_o
275: => hxc_ulc_shd.g_old_rec.name_value_string
276: ,p_region_code_o
277: => hxc_ulc_shd.g_old_rec.region_code
278: ,p_region_code_app_id_o
279: => hxc_ulc_shd.g_old_rec.region_code_app_id
280: ,p_attribute_code_o
281: => hxc_ulc_shd.g_old_rec.attribute_code
275: => hxc_ulc_shd.g_old_rec.name_value_string
276: ,p_region_code_o
277: => hxc_ulc_shd.g_old_rec.region_code
278: ,p_region_code_app_id_o
279: => hxc_ulc_shd.g_old_rec.region_code_app_id
280: ,p_attribute_code_o
281: => hxc_ulc_shd.g_old_rec.attribute_code
282: ,p_attribute_code_app_id_o
283: => hxc_ulc_shd.g_old_rec.attribute_code_app_id
277: => hxc_ulc_shd.g_old_rec.region_code
278: ,p_region_code_app_id_o
279: => hxc_ulc_shd.g_old_rec.region_code_app_id
280: ,p_attribute_code_o
281: => hxc_ulc_shd.g_old_rec.attribute_code
282: ,p_attribute_code_app_id_o
283: => hxc_ulc_shd.g_old_rec.attribute_code_app_id
284: ,p_object_version_number_o
285: => hxc_ulc_shd.g_old_rec.object_version_number
279: => hxc_ulc_shd.g_old_rec.region_code_app_id
280: ,p_attribute_code_o
281: => hxc_ulc_shd.g_old_rec.attribute_code
282: ,p_attribute_code_app_id_o
283: => hxc_ulc_shd.g_old_rec.attribute_code_app_id
284: ,p_object_version_number_o
285: => hxc_ulc_shd.g_old_rec.object_version_number
286: ,p_layout_comp_definition_id_o
287: => hxc_ulc_shd.g_old_rec.layout_comp_definition_id
281: => hxc_ulc_shd.g_old_rec.attribute_code
282: ,p_attribute_code_app_id_o
283: => hxc_ulc_shd.g_old_rec.attribute_code_app_id
284: ,p_object_version_number_o
285: => hxc_ulc_shd.g_old_rec.object_version_number
286: ,p_layout_comp_definition_id_o
287: => hxc_ulc_shd.g_old_rec.layout_comp_definition_id
288: ,p_component_alias_o
289: => hxc_ulc_shd.g_old_rec.component_alias
283: => hxc_ulc_shd.g_old_rec.attribute_code_app_id
284: ,p_object_version_number_o
285: => hxc_ulc_shd.g_old_rec.object_version_number
286: ,p_layout_comp_definition_id_o
287: => hxc_ulc_shd.g_old_rec.layout_comp_definition_id
288: ,p_component_alias_o
289: => hxc_ulc_shd.g_old_rec.component_alias
290: ,p_parent_bean_o
291: => hxc_ulc_shd.g_old_rec.parent_bean
285: => hxc_ulc_shd.g_old_rec.object_version_number
286: ,p_layout_comp_definition_id_o
287: => hxc_ulc_shd.g_old_rec.layout_comp_definition_id
288: ,p_component_alias_o
289: => hxc_ulc_shd.g_old_rec.component_alias
290: ,p_parent_bean_o
291: => hxc_ulc_shd.g_old_rec.parent_bean
292: ,p_attribute1_o
293: => hxc_ulc_shd.g_old_rec.attribute1
287: => hxc_ulc_shd.g_old_rec.layout_comp_definition_id
288: ,p_component_alias_o
289: => hxc_ulc_shd.g_old_rec.component_alias
290: ,p_parent_bean_o
291: => hxc_ulc_shd.g_old_rec.parent_bean
292: ,p_attribute1_o
293: => hxc_ulc_shd.g_old_rec.attribute1
294: ,p_attribute2_o
295: => hxc_ulc_shd.g_old_rec.attribute2
289: => hxc_ulc_shd.g_old_rec.component_alias
290: ,p_parent_bean_o
291: => hxc_ulc_shd.g_old_rec.parent_bean
292: ,p_attribute1_o
293: => hxc_ulc_shd.g_old_rec.attribute1
294: ,p_attribute2_o
295: => hxc_ulc_shd.g_old_rec.attribute2
296: ,p_attribute3_o
297: => hxc_ulc_shd.g_old_rec.attribute3
291: => hxc_ulc_shd.g_old_rec.parent_bean
292: ,p_attribute1_o
293: => hxc_ulc_shd.g_old_rec.attribute1
294: ,p_attribute2_o
295: => hxc_ulc_shd.g_old_rec.attribute2
296: ,p_attribute3_o
297: => hxc_ulc_shd.g_old_rec.attribute3
298: ,p_attribute4_o
299: => hxc_ulc_shd.g_old_rec.attribute4
293: => hxc_ulc_shd.g_old_rec.attribute1
294: ,p_attribute2_o
295: => hxc_ulc_shd.g_old_rec.attribute2
296: ,p_attribute3_o
297: => hxc_ulc_shd.g_old_rec.attribute3
298: ,p_attribute4_o
299: => hxc_ulc_shd.g_old_rec.attribute4
300: ,p_attribute5_o
301: => hxc_ulc_shd.g_old_rec.attribute5
295: => hxc_ulc_shd.g_old_rec.attribute2
296: ,p_attribute3_o
297: => hxc_ulc_shd.g_old_rec.attribute3
298: ,p_attribute4_o
299: => hxc_ulc_shd.g_old_rec.attribute4
300: ,p_attribute5_o
301: => hxc_ulc_shd.g_old_rec.attribute5
302: );
303: --
297: => hxc_ulc_shd.g_old_rec.attribute3
298: ,p_attribute4_o
299: => hxc_ulc_shd.g_old_rec.attribute4
300: ,p_attribute5_o
301: => hxc_ulc_shd.g_old_rec.attribute5
302: );
303: --
304: exception
305: --
359: --
360: -- {End Of Comments}
361: -- ----------------------------------------------------------------------------
362: Procedure convert_defs
363: (p_rec in out nocopy hxc_ulc_shd.g_rec_type
364: ) is
365: --
366: Begin
367: --
371: -- is being used then we must set to the 'current' argument value.
372: --
373: If (p_rec.layout_id = hr_api.g_number) then
374: p_rec.layout_id :=
375: hxc_ulc_shd.g_old_rec.layout_id;
376: End If;
377: If (p_rec.layout_comp_definition_id = hr_api.g_number) then
378: p_rec.layout_comp_definition_id :=
379: hxc_ulc_shd.g_old_rec.layout_comp_definition_id;
375: hxc_ulc_shd.g_old_rec.layout_id;
376: End If;
377: If (p_rec.layout_comp_definition_id = hr_api.g_number) then
378: p_rec.layout_comp_definition_id :=
379: hxc_ulc_shd.g_old_rec.layout_comp_definition_id;
380: End If;
381: If (p_rec.parent_component_id = hr_api.g_number) then
382: p_rec.parent_component_id :=
383: hxc_ulc_shd.g_old_rec.parent_component_id;
379: hxc_ulc_shd.g_old_rec.layout_comp_definition_id;
380: End If;
381: If (p_rec.parent_component_id = hr_api.g_number) then
382: p_rec.parent_component_id :=
383: hxc_ulc_shd.g_old_rec.parent_component_id;
384: End If;
385: If (p_rec.component_name = hr_api.g_varchar2) then
386: p_rec.component_name :=
387: hxc_ulc_shd.g_old_rec.component_name;
383: hxc_ulc_shd.g_old_rec.parent_component_id;
384: End If;
385: If (p_rec.component_name = hr_api.g_varchar2) then
386: p_rec.component_name :=
387: hxc_ulc_shd.g_old_rec.component_name;
388: End If;
389: If (p_rec.component_value = hr_api.g_varchar2) then
390: p_rec.component_value :=
391: hxc_ulc_shd.g_old_rec.component_value;
387: hxc_ulc_shd.g_old_rec.component_name;
388: End If;
389: If (p_rec.component_value = hr_api.g_varchar2) then
390: p_rec.component_value :=
391: hxc_ulc_shd.g_old_rec.component_value;
392: End If;
393: If (p_rec.sequence = hr_api.g_number) then
394: p_rec.sequence :=
395: hxc_ulc_shd.g_old_rec.sequence;
391: hxc_ulc_shd.g_old_rec.component_value;
392: End If;
393: If (p_rec.sequence = hr_api.g_number) then
394: p_rec.sequence :=
395: hxc_ulc_shd.g_old_rec.sequence;
396: End If;
397: If (p_rec.name_value_string = hr_api.g_varchar2) then
398: p_rec.name_value_string :=
399: hxc_ulc_shd.g_old_rec.name_value_string;
395: hxc_ulc_shd.g_old_rec.sequence;
396: End If;
397: If (p_rec.name_value_string = hr_api.g_varchar2) then
398: p_rec.name_value_string :=
399: hxc_ulc_shd.g_old_rec.name_value_string;
400: End If;
401: If (p_rec.region_code = hr_api.g_varchar2) then
402: p_rec.region_code :=
403: hxc_ulc_shd.g_old_rec.region_code;
399: hxc_ulc_shd.g_old_rec.name_value_string;
400: End If;
401: If (p_rec.region_code = hr_api.g_varchar2) then
402: p_rec.region_code :=
403: hxc_ulc_shd.g_old_rec.region_code;
404: End If;
405: If (p_rec.region_code_app_id = hr_api.g_number) then
406: p_rec.region_code_app_id :=
407: hxc_ulc_shd.g_old_rec.region_code_app_id;
403: hxc_ulc_shd.g_old_rec.region_code;
404: End If;
405: If (p_rec.region_code_app_id = hr_api.g_number) then
406: p_rec.region_code_app_id :=
407: hxc_ulc_shd.g_old_rec.region_code_app_id;
408: End If;
409: If (p_rec.attribute_code = hr_api.g_varchar2) then
410: p_rec.attribute_code :=
411: hxc_ulc_shd.g_old_rec.attribute_code;
407: hxc_ulc_shd.g_old_rec.region_code_app_id;
408: End If;
409: If (p_rec.attribute_code = hr_api.g_varchar2) then
410: p_rec.attribute_code :=
411: hxc_ulc_shd.g_old_rec.attribute_code;
412: End If;
413: If (p_rec.attribute_code_app_id = hr_api.g_number) then
414: p_rec.attribute_code_app_id :=
415: hxc_ulc_shd.g_old_rec.attribute_code_app_id;
411: hxc_ulc_shd.g_old_rec.attribute_code;
412: End If;
413: If (p_rec.attribute_code_app_id = hr_api.g_number) then
414: p_rec.attribute_code_app_id :=
415: hxc_ulc_shd.g_old_rec.attribute_code_app_id;
416: End If;
417: If (p_rec.component_alias = hr_api.g_varchar2) then
418: p_rec.component_alias :=
419: hxc_ulc_shd.g_old_rec.component_alias;
415: hxc_ulc_shd.g_old_rec.attribute_code_app_id;
416: End If;
417: If (p_rec.component_alias = hr_api.g_varchar2) then
418: p_rec.component_alias :=
419: hxc_ulc_shd.g_old_rec.component_alias;
420: End If;
421: If (p_rec.parent_bean = hr_api.g_varchar2) then
422: p_rec.parent_bean :=
423: hxc_ulc_shd.g_old_rec.parent_bean;
419: hxc_ulc_shd.g_old_rec.component_alias;
420: End If;
421: If (p_rec.parent_bean = hr_api.g_varchar2) then
422: p_rec.parent_bean :=
423: hxc_ulc_shd.g_old_rec.parent_bean;
424: End If;
425: If (p_rec.attribute1 = hr_api.g_varchar2) then
426: p_rec.attribute1 :=
427: hxc_ulc_shd.g_old_rec.attribute1;
423: hxc_ulc_shd.g_old_rec.parent_bean;
424: End If;
425: If (p_rec.attribute1 = hr_api.g_varchar2) then
426: p_rec.attribute1 :=
427: hxc_ulc_shd.g_old_rec.attribute1;
428: End If;
429: If (p_rec.attribute2 = hr_api.g_varchar2) then
430: p_rec.attribute2 :=
431: hxc_ulc_shd.g_old_rec.attribute2;
427: hxc_ulc_shd.g_old_rec.attribute1;
428: End If;
429: If (p_rec.attribute2 = hr_api.g_varchar2) then
430: p_rec.attribute2 :=
431: hxc_ulc_shd.g_old_rec.attribute2;
432: End If;
433: If (p_rec.attribute3 = hr_api.g_varchar2) then
434: p_rec.attribute3 :=
435: hxc_ulc_shd.g_old_rec.attribute3;
431: hxc_ulc_shd.g_old_rec.attribute2;
432: End If;
433: If (p_rec.attribute3 = hr_api.g_varchar2) then
434: p_rec.attribute3 :=
435: hxc_ulc_shd.g_old_rec.attribute3;
436: End If;
437: If (p_rec.attribute4 = hr_api.g_varchar2) then
438: p_rec.attribute4 :=
439: hxc_ulc_shd.g_old_rec.attribute4;
435: hxc_ulc_shd.g_old_rec.attribute3;
436: End If;
437: If (p_rec.attribute4 = hr_api.g_varchar2) then
438: p_rec.attribute4 :=
439: hxc_ulc_shd.g_old_rec.attribute4;
440: End If;
441: If (p_rec.attribute5 = hr_api.g_varchar2) then
442: p_rec.attribute5 :=
443: hxc_ulc_shd.g_old_rec.attribute5;
439: hxc_ulc_shd.g_old_rec.attribute4;
440: End If;
441: If (p_rec.attribute5 = hr_api.g_varchar2) then
442: p_rec.attribute5 :=
443: hxc_ulc_shd.g_old_rec.attribute5;
444: End If;
445: --
446: End convert_defs;
447: --
448: -- ----------------------------------------------------------------------------
449: -- |---------------------------------< upd >----------------------------------|
450: -- ----------------------------------------------------------------------------
451: Procedure upd
452: (p_rec in out nocopy hxc_ulc_shd.g_rec_type
453: ) is
454: --
455: l_proc varchar2(72) ;
456: --
462: end if;
463: --
464: -- We must lock the row which we need to update.
465: --
466: hxc_ulc_shd.lck
467: (p_rec.layout_component_id
468: ,p_rec.object_version_number
469: );
470: --
519: ,p_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_attribute5 in varchar2 default hr_api.g_varchar2
521: ) is
522: --
523: l_rec hxc_ulc_shd.g_rec_type;
524: l_proc varchar2(72) ;
525: --
526: Begin
527: g_debug :=hr_utility.debug_enabled;
533: -- Call conversion function to turn arguments into the
534: -- l_rec structure.
535: --
536: l_rec :=
537: hxc_ulc_shd.convert_args
538: (p_layout_component_id
539: ,p_layout_id
540: ,p_parent_component_id
541: ,p_component_name