APPS.PQH_TEMPLATE_ATTRIBUTES_API dependencies on HR_API

Line 56: when hr_api.cannot_find_prog_unit then

52: ,p_template_id => p_template_id
53: ,p_effective_date => trunc(p_effective_date)
54: );
55: exception
56: when hr_api.cannot_find_prog_unit then
57: hr_api.cannot_find_prog_unit_error
58: (
59: p_module_name => 'CREATE_TEMPLATE_ATTRIBUTE'
60: ,p_hook_type => 'BP'

Line 57: hr_api.cannot_find_prog_unit_error

53: ,p_effective_date => trunc(p_effective_date)
54: );
55: exception
56: when hr_api.cannot_find_prog_unit then
57: hr_api.cannot_find_prog_unit_error
58: (
59: p_module_name => 'CREATE_TEMPLATE_ATTRIBUTE'
60: ,p_hook_type => 'BP'
61: );

Line 95: when hr_api.cannot_find_prog_unit then

91: ,p_object_version_number => l_object_version_number
92: ,p_effective_date => trunc(p_effective_date)
93: );
94: exception
95: when hr_api.cannot_find_prog_unit then
96: hr_api.cannot_find_prog_unit_error
97: (p_module_name => 'CREATE_TEMPLATE_ATTRIBUTE'
98: ,p_hook_type => 'AP'
99: );

Line 96: hr_api.cannot_find_prog_unit_error

92: ,p_effective_date => trunc(p_effective_date)
93: );
94: exception
95: when hr_api.cannot_find_prog_unit then
96: hr_api.cannot_find_prog_unit_error
97: (p_module_name => 'CREATE_TEMPLATE_ATTRIBUTE'
98: ,p_hook_type => 'AP'
99: );
100: --

Line 110: raise hr_api.validate_enabled;

106: --
107: -- When in validation only mode raise the Validate_Enabled exception
108: --
109: if p_validate then
110: raise hr_api.validate_enabled;
111: end if;
112: --
113: -- Set all output arguments
114: --

Line 122: when hr_api.validate_enabled then

118: hr_utility.set_location(' Leaving:'||l_proc, 70);
119: --
120: exception
121: --
122: when hr_api.validate_enabled then
123: --
124: -- As the Validate_Enabled exception has been raised
125: -- we must rollback to the savepoint
126: --

Line 151: ,p_required_flag in varchar2 default hr_api.g_varchar2

147: -- ----------------------------------------------------------------------------
148: --
149: procedure update_TEMPLATE_ATTRIBUTE
150: (p_validate in boolean default false
151: ,p_required_flag in varchar2 default hr_api.g_varchar2
152: ,p_view_flag in varchar2 default hr_api.g_varchar2
153: ,p_edit_flag in varchar2 default hr_api.g_varchar2
154: ,p_template_attribute_id in number
155: ,p_attribute_id in number default hr_api.g_number

Line 152: ,p_view_flag in varchar2 default hr_api.g_varchar2

148: --
149: procedure update_TEMPLATE_ATTRIBUTE
150: (p_validate in boolean default false
151: ,p_required_flag in varchar2 default hr_api.g_varchar2
152: ,p_view_flag in varchar2 default hr_api.g_varchar2
153: ,p_edit_flag in varchar2 default hr_api.g_varchar2
154: ,p_template_attribute_id in number
155: ,p_attribute_id in number default hr_api.g_number
156: ,p_template_id in number default hr_api.g_number

Line 153: ,p_edit_flag in varchar2 default hr_api.g_varchar2

149: procedure update_TEMPLATE_ATTRIBUTE
150: (p_validate in boolean default false
151: ,p_required_flag in varchar2 default hr_api.g_varchar2
152: ,p_view_flag in varchar2 default hr_api.g_varchar2
153: ,p_edit_flag in varchar2 default hr_api.g_varchar2
154: ,p_template_attribute_id in number
155: ,p_attribute_id in number default hr_api.g_number
156: ,p_template_id in number default hr_api.g_number
157: ,p_object_version_number in out nocopy number

Line 155: ,p_attribute_id in number default hr_api.g_number

151: ,p_required_flag in varchar2 default hr_api.g_varchar2
152: ,p_view_flag in varchar2 default hr_api.g_varchar2
153: ,p_edit_flag in varchar2 default hr_api.g_varchar2
154: ,p_template_attribute_id in number
155: ,p_attribute_id in number default hr_api.g_number
156: ,p_template_id in number default hr_api.g_number
157: ,p_object_version_number in out nocopy number
158: ,p_effective_date in date
159: ) is

Line 156: ,p_template_id in number default hr_api.g_number

152: ,p_view_flag in varchar2 default hr_api.g_varchar2
153: ,p_edit_flag in varchar2 default hr_api.g_varchar2
154: ,p_template_attribute_id in number
155: ,p_attribute_id in number default hr_api.g_number
156: ,p_template_id in number default hr_api.g_number
157: ,p_object_version_number in out nocopy number
158: ,p_effective_date in date
159: ) is
160: --

Line 196: when hr_api.cannot_find_prog_unit then

192: ,p_object_version_number => p_object_version_number
193: ,p_effective_date => trunc(p_effective_date)
194: );
195: exception
196: when hr_api.cannot_find_prog_unit then
197: hr_api.cannot_find_prog_unit_error
198: (p_module_name => 'UPDATE_TEMPLATE_ATTRIBUTE'
199: ,p_hook_type => 'BP'
200: );

Line 197: hr_api.cannot_find_prog_unit_error

193: ,p_effective_date => trunc(p_effective_date)
194: );
195: exception
196: when hr_api.cannot_find_prog_unit then
197: hr_api.cannot_find_prog_unit_error
198: (p_module_name => 'UPDATE_TEMPLATE_ATTRIBUTE'
199: ,p_hook_type => 'BP'
200: );
201: --

Line 234: when hr_api.cannot_find_prog_unit then

230: ,p_object_version_number => l_object_version_number
231: ,p_effective_date => trunc(p_effective_date)
232: );
233: exception
234: when hr_api.cannot_find_prog_unit then
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'UPDATE_TEMPLATE_ATTRIBUTE'
237: ,p_hook_type => 'AP'
238: );

Line 235: hr_api.cannot_find_prog_unit_error

231: ,p_effective_date => trunc(p_effective_date)
232: );
233: exception
234: when hr_api.cannot_find_prog_unit then
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'UPDATE_TEMPLATE_ATTRIBUTE'
237: ,p_hook_type => 'AP'
238: );
239: --

Line 249: raise hr_api.validate_enabled;

245: --
246: -- When in validation only mode raise the Validate_Enabled exception
247: --
248: if p_validate then
249: raise hr_api.validate_enabled;
250: end if;
251: --
252: -- Set all output arguments
253: --

Line 260: when hr_api.validate_enabled then

256: hr_utility.set_location(' Leaving:'||l_proc, 70);
257: --
258: exception
259: --
260: when hr_api.validate_enabled then
261: --
262: -- As the Validate_Enabled exception has been raised
263: -- we must rollback to the savepoint
264: --

Line 323: when hr_api.cannot_find_prog_unit then

319: ,p_object_version_number => p_object_version_number
320: ,p_effective_date => trunc(p_effective_date)
321: );
322: exception
323: when hr_api.cannot_find_prog_unit then
324: hr_api.cannot_find_prog_unit_error
325: (p_module_name => 'DELETE_TEMPLATE_ATTRIBUTE'
326: ,p_hook_type => 'BP'
327: );

Line 324: hr_api.cannot_find_prog_unit_error

320: ,p_effective_date => trunc(p_effective_date)
321: );
322: exception
323: when hr_api.cannot_find_prog_unit then
324: hr_api.cannot_find_prog_unit_error
325: (p_module_name => 'DELETE_TEMPLATE_ATTRIBUTE'
326: ,p_hook_type => 'BP'
327: );
328: --

Line 351: when hr_api.cannot_find_prog_unit then

347: ,p_object_version_number => l_object_version_number
348: ,p_effective_date => trunc(p_effective_date)
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'DELETE_TEMPLATE_ATTRIBUTE'
354: ,p_hook_type => 'AP'
355: );

Line 352: hr_api.cannot_find_prog_unit_error

348: ,p_effective_date => trunc(p_effective_date)
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'DELETE_TEMPLATE_ATTRIBUTE'
354: ,p_hook_type => 'AP'
355: );
356: --

Line 366: raise hr_api.validate_enabled;

362: --
363: -- When in validation only mode raise the Validate_Enabled exception
364: --
365: if p_validate then
366: raise hr_api.validate_enabled;
367: end if;
368: --
369: hr_utility.set_location(' Leaving:'||l_proc, 70);
370: --

Line 373: when hr_api.validate_enabled then

369: hr_utility.set_location(' Leaving:'||l_proc, 70);
370: --
371: exception
372: --
373: when hr_api.validate_enabled then
374: --
375: -- As the Validate_Enabled exception has been raised
376: -- we must rollback to the savepoint
377: --