DBA Data[Home] [Help]

APPS.AME_ATTRIBUTE_API dependencies on HR_API

Line 14: ,p_language_code in varchar2 default hr_api.userenv_lang

10: -- ----------------------------------------------------------------------------
11: --
12: procedure create_ame_attribute
13: (p_validate in boolean default false
14: ,p_language_code in varchar2 default hr_api.userenv_lang
15: ,p_name in varchar2
16: ,p_description in varchar2
17: ,p_attribute_type in varchar2
18: ,p_item_class_id in number

Line 69: when hr_api.cannot_find_prog_unit then

65: ,p_item_class_id => p_item_class_id
66: ,p_approver_type_id => p_approver_type_id
67: );
68: exception
69: when hr_api.cannot_find_prog_unit then
70: hr_api.cannot_find_prog_unit_error
71: (p_module_name => 'create_ame_attribute'
72: ,p_hook_type => 'BP'
73: );

Line 70: hr_api.cannot_find_prog_unit_error

66: ,p_approver_type_id => p_approver_type_id
67: );
68: exception
69: when hr_api.cannot_find_prog_unit then
70: hr_api.cannot_find_prog_unit_error
71: (p_module_name => 'create_ame_attribute'
72: ,p_hook_type => 'BP'
73: );
74: end;

Line 130: when hr_api.cannot_find_prog_unit then

126: ,p_atr_start_date => l_atr_start_date
127: ,p_atr_end_date => l_atr_end_date
128: );
129: exception
130: when hr_api.cannot_find_prog_unit then
131: hr_api.cannot_find_prog_unit_error
132: (p_module_name => 'create_ame_attribute'
133: ,p_hook_type => 'AP'
134: );

Line 131: hr_api.cannot_find_prog_unit_error

127: ,p_atr_end_date => l_atr_end_date
128: );
129: exception
130: when hr_api.cannot_find_prog_unit then
131: hr_api.cannot_find_prog_unit_error
132: (p_module_name => 'create_ame_attribute'
133: ,p_hook_type => 'AP'
134: );
135: end;

Line 140: raise hr_api.validate_enabled;

136: --
137: -- When in validation only mode raise the Validate_Enabled exception
138: --
139: if p_validate then
140: raise hr_api.validate_enabled;
141: end if;
142: --
143: -- Set all IN OUT and OUT parameters with out values
144: --

Line 157: when hr_api.validate_enabled then

153: end if;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 70);
156: exception
157: when hr_api.validate_enabled then
158: --
159: -- As the Validate_Enabled exception has been raised
160: -- we must rollback to the savepoint
161: --

Line 250: when hr_api.cannot_find_prog_unit then

246: ,p_user_editable => p_user_editable
247: ,p_value_set_id => p_value_set_id
248: );
249: exception
250: when hr_api.cannot_find_prog_unit then
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'create_ame_attribute_usage'
253: ,p_hook_type => 'BP'
254: );

Line 251: hr_api.cannot_find_prog_unit_error

247: ,p_value_set_id => p_value_set_id
248: );
249: exception
250: when hr_api.cannot_find_prog_unit then
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'create_ame_attribute_usage'
253: ,p_hook_type => 'BP'
254: );
255: end;

Line 290: when hr_api.cannot_find_prog_unit then

286: ,p_start_date => l_atu_start_date
287: ,p_end_date => l_atu_end_date
288: );
289: exception
290: when hr_api.cannot_find_prog_unit then
291: hr_api.cannot_find_prog_unit_error
292: (p_module_name => 'create_ame_attribute_usage'
293: ,p_hook_type => 'AP'
294: );

Line 291: hr_api.cannot_find_prog_unit_error

287: ,p_end_date => l_atu_end_date
288: );
289: exception
290: when hr_api.cannot_find_prog_unit then
291: hr_api.cannot_find_prog_unit_error
292: (p_module_name => 'create_ame_attribute_usage'
293: ,p_hook_type => 'AP'
294: );
295: end;

Line 300: raise hr_api.validate_enabled;

296: --
297: -- When in validation only mode raise the Validate_Enabled exception
298: --
299: if p_validate then
300: raise hr_api.validate_enabled;
301: end if;
302: --
303: -- Set all IN OUT and OUT parameters with out values
304: --

Line 311: when hr_api.validate_enabled then

307: p_end_date := l_atu_end_date;
308: --
309: hr_utility.set_location(' Leaving:'||l_proc, 70);
310: exception
311: when hr_api.validate_enabled then
312: --
313: -- As the Validate_Enabled exception has been raised
314: -- we must rollback to the savepoint
315: --

Line 349: ,p_language_code in varchar2 default hr_api.userenv_lang

345: -- ----------------------------------------------------------------------------
346: --
347: procedure update_ame_attribute
348: (p_validate in boolean default false
349: ,p_language_code in varchar2 default hr_api.userenv_lang
350: ,p_attribute_id in number
351: ,p_description in varchar2 default hr_api.g_varchar2
352: ,p_object_version_number in out nocopy number
353: ,p_start_date out nocopy date

Line 351: ,p_description in varchar2 default hr_api.g_varchar2

347: procedure update_ame_attribute
348: (p_validate in boolean default false
349: ,p_language_code in varchar2 default hr_api.userenv_lang
350: ,p_attribute_id in number
351: ,p_description in varchar2 default hr_api.g_varchar2
352: ,p_object_version_number in out nocopy number
353: ,p_start_date out nocopy date
354: ,p_end_date out nocopy date
355: ) is

Line 380: when hr_api.cannot_find_prog_unit then

376: ,p_description => p_description
377: ,p_object_version_number => p_object_version_number
378: );
379: exception
380: when hr_api.cannot_find_prog_unit then
381: hr_api.cannot_find_prog_unit_error
382: (p_module_name => 'update_ame_attribute'
383: ,p_hook_type => 'BP'
384: );

Line 381: hr_api.cannot_find_prog_unit_error

377: ,p_object_version_number => p_object_version_number
378: );
379: exception
380: when hr_api.cannot_find_prog_unit then
381: hr_api.cannot_find_prog_unit_error
382: (p_module_name => 'update_ame_attribute'
383: ,p_hook_type => 'BP'
384: );
385: end;

Line 421: when hr_api.cannot_find_prog_unit then

417: ,p_start_date => l_atr_start_date
418: ,p_end_date => l_atr_end_date
419: );
420: exception
421: when hr_api.cannot_find_prog_unit then
422: hr_api.cannot_find_prog_unit_error
423: (p_module_name => 'update_ame_attribute'
424: ,p_hook_type => 'AP'
425: );

Line 422: hr_api.cannot_find_prog_unit_error

418: ,p_end_date => l_atr_end_date
419: );
420: exception
421: when hr_api.cannot_find_prog_unit then
422: hr_api.cannot_find_prog_unit_error
423: (p_module_name => 'update_ame_attribute'
424: ,p_hook_type => 'AP'
425: );
426: end;

Line 431: raise hr_api.validate_enabled;

427: --
428: -- When in validation only mode raise the Validate_Enabled exception
429: --
430: if p_validate then
431: raise hr_api.validate_enabled;
432: end if;
433: --
434: -- Set all IN OUT and OUT parameters with out values
435: --

Line 442: when hr_api.validate_enabled then

438: p_end_date := l_atr_end_date;
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 70);
441: exception
442: when hr_api.validate_enabled then
443: --
444: -- As the Validate_Enabled exception has been raised
445: -- we must rollback to the savepoint
446: --

Line 514: when hr_api.cannot_find_prog_unit then

510: ,p_value_set_id => p_value_set_id
511: ,p_object_version_number => p_object_version_number
512: );
513: exception
514: when hr_api.cannot_find_prog_unit then
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'update_ame_attribute_usage'
517: ,p_hook_type => 'BP'
518: );

Line 515: hr_api.cannot_find_prog_unit_error

511: ,p_object_version_number => p_object_version_number
512: );
513: exception
514: when hr_api.cannot_find_prog_unit then
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'update_ame_attribute_usage'
517: ,p_hook_type => 'BP'
518: );
519: end;

Line 553: when hr_api.cannot_find_prog_unit then

549: ,p_start_date => l_atu_start_date
550: ,p_end_date => l_atu_end_date
551: );
552: exception
553: when hr_api.cannot_find_prog_unit then
554: hr_api.cannot_find_prog_unit_error
555: (p_module_name => 'update_ame_attribute_usage'
556: ,p_hook_type => 'AP'
557: );

Line 554: hr_api.cannot_find_prog_unit_error

550: ,p_end_date => l_atu_end_date
551: );
552: exception
553: when hr_api.cannot_find_prog_unit then
554: hr_api.cannot_find_prog_unit_error
555: (p_module_name => 'update_ame_attribute_usage'
556: ,p_hook_type => 'AP'
557: );
558: end;

Line 563: raise hr_api.validate_enabled;

559: --
560: -- When in validation only mode raise the Validate_Enabled exception
561: --
562: if p_validate then
563: raise hr_api.validate_enabled;
564: end if;
565: --
566: -- Set all IN OUT and OUT parameters with out values
567: --

Line 574: when hr_api.validate_enabled then

570: p_end_date := l_atu_end_date;
571: --
572: hr_utility.set_location(' Leaving:'||l_proc, 70);
573: exception
574: when hr_api.validate_enabled then
575: --
576: -- As the Validate_Enabled exception has been raised
577: -- we must rollback to the savepoint
578: --

Line 664: when hr_api.cannot_find_prog_unit then

660: ,p_application_id => p_application_id
661: ,p_object_version_number => p_object_version_number
662: );
663: exception
664: when hr_api.cannot_find_prog_unit then
665: hr_api.cannot_find_prog_unit_error
666: (p_module_name => 'delete_ame_attribute_usage'
667: ,p_hook_type => 'BP'
668: );

Line 665: hr_api.cannot_find_prog_unit_error

661: ,p_object_version_number => p_object_version_number
662: );
663: exception
664: when hr_api.cannot_find_prog_unit then
665: hr_api.cannot_find_prog_unit_error
666: (p_module_name => 'delete_ame_attribute_usage'
667: ,p_hook_type => 'BP'
668: );
669: end;

Line 748: when hr_api.cannot_find_prog_unit then

744: ,p_start_date => l_atu_start_date
745: ,p_end_date => l_atu_end_date
746: );
747: exception
748: when hr_api.cannot_find_prog_unit then
749: hr_api.cannot_find_prog_unit_error
750: (p_module_name => 'delete_ame_attribute_usage'
751: ,p_hook_type => 'AP'
752: );

Line 749: hr_api.cannot_find_prog_unit_error

745: ,p_end_date => l_atu_end_date
746: );
747: exception
748: when hr_api.cannot_find_prog_unit then
749: hr_api.cannot_find_prog_unit_error
750: (p_module_name => 'delete_ame_attribute_usage'
751: ,p_hook_type => 'AP'
752: );
753: end;

Line 758: raise hr_api.validate_enabled;

754: --
755: -- When in validation only mode raise the Validate_Enabled exception
756: --
757: if p_validate then
758: raise hr_api.validate_enabled;
759: end if;
760: --
761: -- Set all IN OUT and OUT parameters with out values
762: --

Line 769: when hr_api.validate_enabled then

765: p_end_date := l_atu_end_date;
766: --
767: hr_utility.set_location(' Leaving:'||l_proc, 70);
768: exception
769: when hr_api.validate_enabled then
770: --
771: -- As the Validate_Enabled exception has been raised
772: -- we must rollback to the savepoint
773: --

Line 885: ,p_datetrack_mode => hr_api.g_correction

881: l_atu_object_version_number := p_atu_object_version_number;
882: useCount := calculateUseCount(attributeIdIn => p_attribute_id
883: ,applicationIdIn => p_application_id);
884: ame_atu_upd.upd(p_attribute_id => p_attribute_id
885: ,p_datetrack_mode => hr_api.g_correction
886: ,p_application_id => p_application_id
887: ,p_use_count => useCount
888: ,p_effective_date => sysdate
889: ,p_object_version_number => l_atu_object_version_number