DBA Data[Home] [Help]

APPS.AME_ITEM_CLASS_API dependencies on HR_API

Line 15: hr_api.userenv_lang

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

Line 49: when hr_api.cannot_find_prog_unit then

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

Line 50: hr_api.cannot_find_prog_unit_error

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;

Line 59: hr_api.validate_language_code(p_language_code => l_language_code);

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

Line 90: when hr_api.cannot_find_prog_unit then

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

Line 91: hr_api.cannot_find_prog_unit_error

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;

Line 100: raise hr_api.validate_enabled;

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

Line 112: when hr_api.validate_enabled then

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

Line 152: hr_api.userenv_lang

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

Line 154: ,p_user_item_class_name in varchar2 default hr_api.g_varchar2

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

Line 189: when hr_api.cannot_find_prog_unit then

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

Line 190: hr_api.cannot_find_prog_unit_error

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;

Line 197: hr_api.validate_language_code(p_language_code => l_language_code);

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

Line 203: ,p_datetrack_mode => hr_api.g_update

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

Line 206: ,p_name => hr_api.g_varchar2

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: --*/

Line 230: when hr_api.cannot_find_prog_unit then

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

Line 231: hr_api.cannot_find_prog_unit_error

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;

Line 240: raise hr_api.validate_enabled;

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

Line 250: when hr_api.validate_enabled then

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

Line 331: when hr_api.cannot_find_prog_unit then

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

Line 332: hr_api.cannot_find_prog_unit_error

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;

Line 362: ,p_datetrack_mode => hr_api.g_delete

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

Line 379: when hr_api.cannot_find_prog_unit then

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

Line 380: hr_api.cannot_find_prog_unit_error

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;

Line 389: raise hr_api.validate_enabled;

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

Line 399: when hr_api.validate_enabled then

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

Line 480: when hr_api.cannot_find_prog_unit then

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

Line 481: hr_api.cannot_find_prog_unit_error

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;

Line 517: when hr_api.cannot_find_prog_unit then

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

Line 518: hr_api.cannot_find_prog_unit_error

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;

Line 527: raise hr_api.validate_enabled;

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

Line 540: when hr_api.validate_enabled then

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

Line 583: ,p_item_id_query in varchar2 default hr_api.g_varchar2

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

Line 584: ,p_item_class_order_number in number default hr_api.g_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

Line 585: ,p_item_class_par_mode in varchar2 default hr_api.g_varchar2

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

Line 586: ,p_item_class_sublist_mode in varchar2 default hr_api.g_varchar2

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

Line 623: when hr_api.cannot_find_prog_unit then

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

Line 624: hr_api.cannot_find_prog_unit_error

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;

Line 634: ,p_datetrack_mode => hr_api.g_update

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

Line 662: when hr_api.cannot_find_prog_unit then

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

Line 663: hr_api.cannot_find_prog_unit_error

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;

Line 672: raise hr_api.validate_enabled;

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

Line 682: when hr_api.validate_enabled then

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

Line 755: when hr_api.cannot_find_prog_unit then

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

Line 756: hr_api.cannot_find_prog_unit_error

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;

Line 766: ,p_datetrack_mode => hr_api.g_delete

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

Line 785: when hr_api.cannot_find_prog_unit then

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

Line 786: hr_api.cannot_find_prog_unit_error

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;

Line 795: raise hr_api.validate_enabled;

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

Line 805: when hr_api.validate_enabled then

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