11: --
12: Procedure create_ame_item_class
13: (p_validate in boolean default false
14: ,p_language_code in varchar2 default
15: hr_api.userenv_lang
16: ,p_name in varchar2
17: ,p_user_item_class_name in varchar2
18: ,p_item_class_id out nocopy number
19: ,p_object_version_number out nocopy number
45: --(sri: change the signature to include language_code
46: ame_item_class_bk1.create_ame_item_class_b
47: (p_name => p_name);
48: exception
49: when hr_api.cannot_find_prog_unit then
50: hr_api.cannot_find_prog_unit_error
51: (p_module_name => 'create_ame_item_class'
52: ,p_hook_type => 'BP'
53: );
46: ame_item_class_bk1.create_ame_item_class_b
47: (p_name => p_name);
48: exception
49: when hr_api.cannot_find_prog_unit then
50: hr_api.cannot_find_prog_unit_error
51: (p_module_name => 'create_ame_item_class'
52: ,p_hook_type => 'BP'
53: );
54: end;
55: --
56: -- Validate the language provided
57: --
58: l_language_code := p_language_code;
59: hr_api.validate_language_code(p_language_code => l_language_code);
60: --
61: -- Process Logic
62: --
63: ame_itc_ins.ins (p_effective_date => sysdate
86: ,p_start_date => l_start_date
87: ,p_end_date => l_end_date
88: );
89: exception
90: when hr_api.cannot_find_prog_unit then
91: hr_api.cannot_find_prog_unit_error
92: (p_module_name => 'create_ame_item_class'
93: ,p_hook_type => 'AP'
94: );
87: ,p_end_date => l_end_date
88: );
89: exception
90: when hr_api.cannot_find_prog_unit then
91: hr_api.cannot_find_prog_unit_error
92: (p_module_name => 'create_ame_item_class'
93: ,p_hook_type => 'AP'
94: );
95: end;
96: --
97: -- When in validation only mode raise the Validate_Enabled exception
98: --
99: if p_validate then
100: raise hr_api.validate_enabled;
101: end if;
102: --
103: -- Set all IN OUT and OUT parameters with out values
104: --
108: p_end_date := l_end_date;
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 70);
111: exception
112: when hr_api.validate_enabled then
113: --
114: -- As the Validate_Enabled exception has been raised
115: -- we must rollback to the savepoint
116: --
148: -- ----------------------------------------------------------------------------
149: procedure update_ame_item_class
150: (p_validate in boolean default false
151: ,p_language_code in varchar2 default
152: hr_api.userenv_lang
153: ,p_item_class_id in number
154: ,p_user_item_class_name in varchar2 default hr_api.g_varchar2
155: ,p_object_version_number in out nocopy number
156: ,p_start_date out nocopy date
150: (p_validate in boolean default false
151: ,p_language_code in varchar2 default
152: hr_api.userenv_lang
153: ,p_item_class_id in number
154: ,p_user_item_class_name in varchar2 default hr_api.g_varchar2
155: ,p_object_version_number in out nocopy number
156: ,p_start_date out nocopy date
157: ,p_end_date out nocopy date
158: ) is
185: ,p_user_item_class_name => p_user_item_class_name
186: ,p_object_version_number => p_object_version_number
187: );
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (p_module_name => 'update_ame_item_class'
192: ,p_hook_type => 'BP'
193: );
186: ,p_object_version_number => p_object_version_number
187: );
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (p_module_name => 'update_ame_item_class'
192: ,p_hook_type => 'BP'
193: );
194: end;
193: );
194: end;
195: --validate the language provided
196: l_language_code := p_language_code;
197: hr_api.validate_language_code(p_language_code => l_language_code);
198: --
199: -- Process Logic
200: --
201: /* ame_itc_upd.upd
199: -- Process Logic
200: --
201: /* ame_itc_upd.upd
202: (p_effective_date => sysdate
203: ,p_datetrack_mode => hr_api.g_update
204: ,p_item_class_id => p_item_class_id
205: ,p_object_version_number => p_object_version_number
206: ,p_name => hr_api.g_varchar2
207: ,p_start_date => l_start_date
202: (p_effective_date => sysdate
203: ,p_datetrack_mode => hr_api.g_update
204: ,p_item_class_id => p_item_class_id
205: ,p_object_version_number => p_object_version_number
206: ,p_name => hr_api.g_varchar2
207: ,p_start_date => l_start_date
208: ,p_end_date => l_end_date
209: );
210: --*/
226: ,p_start_date => l_start_date
227: ,p_end_date => l_end_date
228: );
229: exception
230: when hr_api.cannot_find_prog_unit then
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'update_ame_item_class'
233: ,p_hook_type => 'AP'
234: );
227: ,p_end_date => l_end_date
228: );
229: exception
230: when hr_api.cannot_find_prog_unit then
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'update_ame_item_class'
233: ,p_hook_type => 'AP'
234: );
235: end;
236: --
237: -- When in validation only mode raise the Validate_Enabled exception
238: --
239: if p_validate then
240: raise hr_api.validate_enabled;
241: end if;
242: --
243: -- Set all OUT parameters with out values.
244: --
246: p_end_date := l_end_date;
247: --
248: hr_utility.set_location(' Leaving:'||l_proc, 70);
249: exception
250: when hr_api.validate_enabled then
251: --
252: -- As the Validate_Enabled exception has been raised
253: -- we must rollback to the savepoint
254: --
327: (p_item_class_id => p_item_class_id
328: ,p_object_version_number => p_object_version_number
329: );
330: exception
331: when hr_api.cannot_find_prog_unit then
332: hr_api.cannot_find_prog_unit_error
333: (p_module_name => 'delete_ame_item_class'
334: ,p_hook_type => 'BP'
335: );
328: ,p_object_version_number => p_object_version_number
329: );
330: exception
331: when hr_api.cannot_find_prog_unit then
332: hr_api.cannot_find_prog_unit_error
333: (p_module_name => 'delete_ame_item_class'
334: ,p_hook_type => 'BP'
335: );
336: end;
358: -- Remove the Item Class
359: --
360: ame_itc_del.del
361: (p_effective_date => sysdate
362: ,p_datetrack_mode => hr_api.g_delete
363: ,p_item_class_id => p_item_class_id
364: ,p_object_version_number => p_object_version_number
365: ,p_start_date => l_start_date
366: ,p_end_date => l_end_date
375: ,p_start_date => l_start_date
376: ,p_end_date => l_end_date
377: );
378: exception
379: when hr_api.cannot_find_prog_unit then
380: hr_api.cannot_find_prog_unit_error
381: (p_module_name => 'delete_ame_item_class'
382: ,p_hook_type => 'AP'
383: );
376: ,p_end_date => l_end_date
377: );
378: exception
379: when hr_api.cannot_find_prog_unit then
380: hr_api.cannot_find_prog_unit_error
381: (p_module_name => 'delete_ame_item_class'
382: ,p_hook_type => 'AP'
383: );
384: end;
385: --
386: -- When in validation only mode raise the Validate_Enabled exception
387: --
388: if p_validate then
389: raise hr_api.validate_enabled;
390: end if;
391: --
392: -- Set all IN OUT and OUT parameters with out values.
393: --
395: p_end_date := l_end_date;
396: --
397: hr_utility.set_location(' Leaving:'||l_proc, 70);
398: exception
399: when hr_api.validate_enabled then
400: --
401: -- As the Validate_Enabled exception has been raised
402: -- we must rollback to the savepoint
403: --
476: ,p_application_id => p_application_id
477: ,p_item_class_id => p_item_class_id
478: );
479: exception
480: when hr_api.cannot_find_prog_unit then
481: hr_api.cannot_find_prog_unit_error
482: (p_module_name => 'create_ame_item_class_usage'
483: ,p_hook_type => 'BP'
484: );
477: ,p_item_class_id => p_item_class_id
478: );
479: exception
480: when hr_api.cannot_find_prog_unit then
481: hr_api.cannot_find_prog_unit_error
482: (p_module_name => 'create_ame_item_class_usage'
483: ,p_hook_type => 'BP'
484: );
485: end;
513: ,p_start_date => l_start_date
514: ,p_end_date => l_end_date
515: );
516: exception
517: when hr_api.cannot_find_prog_unit then
518: hr_api.cannot_find_prog_unit_error
519: (p_module_name => 'create_ame_item_class_usage'
520: ,p_hook_type => 'AP'
521: );
514: ,p_end_date => l_end_date
515: );
516: exception
517: when hr_api.cannot_find_prog_unit then
518: hr_api.cannot_find_prog_unit_error
519: (p_module_name => 'create_ame_item_class_usage'
520: ,p_hook_type => 'AP'
521: );
522: end;
523: --
524: -- When in validation only mode raise the Validate_Enabled exception
525: --
526: if p_validate then
527: raise hr_api.validate_enabled;
528: end if;
529: --
530: -- Set all IN OUT and OUT parameters with out values
531: --
536: p_end_date := l_end_date;
537: --
538: hr_utility.set_location(' Leaving:'||l_proc, 70);
539: exception
540: when hr_api.validate_enabled then
541: --
542: -- As the Validate_Enabled exception has been raised
543: -- we must rollback to the savepoint
544: --
579: procedure update_ame_item_class_usage
580: (p_validate in boolean default false
581: ,p_application_id in number
582: ,p_item_class_id in number
583: ,p_item_id_query in varchar2 default hr_api.g_varchar2
584: ,p_item_class_order_number in number default hr_api.g_number
585: ,p_item_class_par_mode in varchar2 default hr_api.g_varchar2
586: ,p_item_class_sublist_mode in varchar2 default hr_api.g_varchar2
587: ,p_object_version_number in out nocopy number
580: (p_validate in boolean default false
581: ,p_application_id in number
582: ,p_item_class_id in number
583: ,p_item_id_query in varchar2 default hr_api.g_varchar2
584: ,p_item_class_order_number in number default hr_api.g_number
585: ,p_item_class_par_mode in varchar2 default hr_api.g_varchar2
586: ,p_item_class_sublist_mode in varchar2 default hr_api.g_varchar2
587: ,p_object_version_number in out nocopy number
588: ,p_start_date out nocopy date
581: ,p_application_id in number
582: ,p_item_class_id in number
583: ,p_item_id_query in varchar2 default hr_api.g_varchar2
584: ,p_item_class_order_number in number default hr_api.g_number
585: ,p_item_class_par_mode in varchar2 default hr_api.g_varchar2
586: ,p_item_class_sublist_mode in varchar2 default hr_api.g_varchar2
587: ,p_object_version_number in out nocopy number
588: ,p_start_date out nocopy date
589: ,p_end_date out nocopy date
582: ,p_item_class_id in number
583: ,p_item_id_query in varchar2 default hr_api.g_varchar2
584: ,p_item_class_order_number in number default hr_api.g_number
585: ,p_item_class_par_mode in varchar2 default hr_api.g_varchar2
586: ,p_item_class_sublist_mode in varchar2 default hr_api.g_varchar2
587: ,p_object_version_number in out nocopy number
588: ,p_start_date out nocopy date
589: ,p_end_date out nocopy date
590: ) is
619: ,p_item_class_par_mode => p_item_class_par_mode
620: ,p_item_class_sublist_mode => p_item_class_sublist_mode
621: );
622: exception
623: when hr_api.cannot_find_prog_unit then
624: hr_api.cannot_find_prog_unit_error
625: (p_module_name => 'update_ame_item_class_usage'
626: ,p_hook_type => 'BP'
627: );
620: ,p_item_class_sublist_mode => p_item_class_sublist_mode
621: );
622: exception
623: when hr_api.cannot_find_prog_unit then
624: hr_api.cannot_find_prog_unit_error
625: (p_module_name => 'update_ame_item_class_usage'
626: ,p_hook_type => 'BP'
627: );
628: end;
630: -- Process Logic
631: --
632: ame_itu_upd.upd
633: (p_effective_date => sysdate
634: ,p_datetrack_mode => hr_api.g_update
635: ,p_application_id => p_application_id
636: ,p_item_class_id => p_item_class_id
637: ,p_object_version_number => p_object_version_number
638: ,p_item_id_query => p_item_id_query
658: ,p_end_date => l_end_date
659: );
660:
661: exception
662: when hr_api.cannot_find_prog_unit then
663: hr_api.cannot_find_prog_unit_error
664: (p_module_name => 'update_ame_item_class_usage'
665: ,p_hook_type => 'AP'
666: );
659: );
660:
661: exception
662: when hr_api.cannot_find_prog_unit then
663: hr_api.cannot_find_prog_unit_error
664: (p_module_name => 'update_ame_item_class_usage'
665: ,p_hook_type => 'AP'
666: );
667: end;
668: --
669: -- When in validation only mode raise the Validate_Enabled exception
670: --
671: if p_validate then
672: raise hr_api.validate_enabled;
673: end if;
674: --
675: -- Set all OUT parameters with out values.
676: --
678: p_end_date := l_end_date;
679: --
680: hr_utility.set_location(' Leaving:'||l_proc, 70);
681: exception
682: when hr_api.validate_enabled then
683: --
684: -- As the Validate_Enabled exception has been raised
685: -- we must rollback to the savepoint
686: --
751: ,p_object_version_number => p_object_version_number
752: );
753:
754: exception
755: when hr_api.cannot_find_prog_unit then
756: hr_api.cannot_find_prog_unit_error
757: (p_module_name => 'delete_ame_item_class_usage'
758: ,p_hook_type => 'BP'
759: );
752: );
753:
754: exception
755: when hr_api.cannot_find_prog_unit then
756: hr_api.cannot_find_prog_unit_error
757: (p_module_name => 'delete_ame_item_class_usage'
758: ,p_hook_type => 'BP'
759: );
760: end;
762: -- Process Logic
763: --
764: ame_itu_del.del
765: (p_effective_date => sysdate
766: ,p_datetrack_mode => hr_api.g_delete
767: ,p_application_id => p_application_id
768: ,p_item_class_id => p_item_class_id
769: ,p_object_version_number => p_object_version_number
770: ,p_start_date => l_start_date
781: ,p_start_date => l_start_date
782: ,p_end_date => l_end_date
783: );
784: exception
785: when hr_api.cannot_find_prog_unit then
786: hr_api.cannot_find_prog_unit_error
787: (p_module_name => 'delete_ame_item_class_usage'
788: ,p_hook_type => 'AP'
789: );
782: ,p_end_date => l_end_date
783: );
784: exception
785: when hr_api.cannot_find_prog_unit then
786: hr_api.cannot_find_prog_unit_error
787: (p_module_name => 'delete_ame_item_class_usage'
788: ,p_hook_type => 'AP'
789: );
790: end;
791: --
792: -- When in validation only mode raise the Validate_Enabled exception
793: --
794: if p_validate then
795: raise hr_api.validate_enabled;
796: end if;
797: --
798: -- Set all IN OUT and OUT parameters with out values.
799: --
801: p_end_date := l_end_date;
802: --
803: hr_utility.set_location(' Leaving:'||l_proc, 70);
804: exception
805: when hr_api.validate_enabled then
806: --
807: -- As the Validate_Enabled exception has been raised
808: -- we must rollback to the savepoint
809: --