DBA Data[Home] [Help]

APPS.PQH_CRITERIA_RATE_ELEMENTS_API dependencies on HR_API

Line 74: when hr_api.cannot_find_prog_unit then

70: ,p_business_group_id => p_business_group_id
71: ,p_legislation_code => p_legislation_code
72: );
73: exception
74: when hr_api.cannot_find_prog_unit then
75: hr_api.cannot_find_prog_unit_error
76: (p_module_name => 'create_criteria_rate_element'
77: ,p_hook_type => 'BP'
78: );

Line 75: hr_api.cannot_find_prog_unit_error

71: ,p_legislation_code => p_legislation_code
72: );
73: exception
74: when hr_api.cannot_find_prog_unit then
75: hr_api.cannot_find_prog_unit_error
76: (p_module_name => 'create_criteria_rate_element'
77: ,p_hook_type => 'BP'
78: );
79: end;

Line 133: when hr_api.cannot_find_prog_unit then

129: ,p_criteria_rate_element_id => l_criteria_rate_element_id
130: ,p_object_version_number => l_object_version_number
131: );
132: exception
133: when hr_api.cannot_find_prog_unit then
134: hr_api.cannot_find_prog_unit_error
135: (p_module_name => 'create_criteria_rate_element'
136: ,p_hook_type => 'AP'
137: );

Line 134: hr_api.cannot_find_prog_unit_error

130: ,p_object_version_number => l_object_version_number
131: );
132: exception
133: when hr_api.cannot_find_prog_unit then
134: hr_api.cannot_find_prog_unit_error
135: (p_module_name => 'create_criteria_rate_element'
136: ,p_hook_type => 'AP'
137: );
138: end;

Line 143: raise hr_api.validate_enabled;

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

Line 153: when hr_api.validate_enabled then

149: p_object_version_number := l_object_version_number;
150: --
151: hr_utility.set_location(' Leaving:'||l_proc, 70);
152: exception
153: when hr_api.validate_enabled then
154: --
155: -- As the Validate_Enabled exception has been raised
156: -- we must rollback to the savepoint
157: --

Line 195: ,p_criteria_rate_defn_id in number default hr_api.g_number

191: procedure update_criteria_rate_element
192: (p_validate in boolean default false
193: ,p_effective_date in date
194: ,p_criteria_rate_element_id in number
195: ,p_criteria_rate_defn_id in number default hr_api.g_number
196: ,p_element_type_id in number default hr_api.g_number
197: ,p_input_value_id in number default hr_api.g_number
198: ,p_business_group_id in number default hr_api.g_number
199: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 196: ,p_element_type_id in number default hr_api.g_number

192: (p_validate in boolean default false
193: ,p_effective_date in date
194: ,p_criteria_rate_element_id in number
195: ,p_criteria_rate_defn_id in number default hr_api.g_number
196: ,p_element_type_id in number default hr_api.g_number
197: ,p_input_value_id in number default hr_api.g_number
198: ,p_business_group_id in number default hr_api.g_number
199: ,p_legislation_code in varchar2 default hr_api.g_varchar2
200: ,p_object_version_number in out nocopy number

Line 197: ,p_input_value_id in number default hr_api.g_number

193: ,p_effective_date in date
194: ,p_criteria_rate_element_id in number
195: ,p_criteria_rate_defn_id in number default hr_api.g_number
196: ,p_element_type_id in number default hr_api.g_number
197: ,p_input_value_id in number default hr_api.g_number
198: ,p_business_group_id in number default hr_api.g_number
199: ,p_legislation_code in varchar2 default hr_api.g_varchar2
200: ,p_object_version_number in out nocopy number
201: )is

Line 198: ,p_business_group_id in number default hr_api.g_number

194: ,p_criteria_rate_element_id in number
195: ,p_criteria_rate_defn_id in number default hr_api.g_number
196: ,p_element_type_id in number default hr_api.g_number
197: ,p_input_value_id in number default hr_api.g_number
198: ,p_business_group_id in number default hr_api.g_number
199: ,p_legislation_code in varchar2 default hr_api.g_varchar2
200: ,p_object_version_number in out nocopy number
201: )is
202: --

Line 199: ,p_legislation_code in varchar2 default hr_api.g_varchar2

195: ,p_criteria_rate_defn_id in number default hr_api.g_number
196: ,p_element_type_id in number default hr_api.g_number
197: ,p_input_value_id in number default hr_api.g_number
198: ,p_business_group_id in number default hr_api.g_number
199: ,p_legislation_code in varchar2 default hr_api.g_varchar2
200: ,p_object_version_number in out nocopy number
201: )is
202: --
203: -- Declare cursors and local variables

Line 254: when hr_api.cannot_find_prog_unit then

250: ,p_legislation_code => p_legislation_code
251: ,p_object_version_number => l_object_version_number
252: );
253: exception
254: when hr_api.cannot_find_prog_unit then
255: hr_api.cannot_find_prog_unit_error
256: (p_module_name => 'update_criteria_rate_element'
257: ,p_hook_type => 'BP'
258: );

Line 255: hr_api.cannot_find_prog_unit_error

251: ,p_object_version_number => l_object_version_number
252: );
253: exception
254: when hr_api.cannot_find_prog_unit then
255: hr_api.cannot_find_prog_unit_error
256: (p_module_name => 'update_criteria_rate_element'
257: ,p_hook_type => 'BP'
258: );
259: end;

Line 295: when hr_api.cannot_find_prog_unit then

291: ,p_legislation_code => p_legislation_code
292: ,p_object_version_number => l_object_version_number
293: );
294: exception
295: when hr_api.cannot_find_prog_unit then
296: hr_api.cannot_find_prog_unit_error
297: (p_module_name => 'update_criteria_rate_element'
298: ,p_hook_type => 'AP'
299: );

Line 296: hr_api.cannot_find_prog_unit_error

292: ,p_object_version_number => l_object_version_number
293: );
294: exception
295: when hr_api.cannot_find_prog_unit then
296: hr_api.cannot_find_prog_unit_error
297: (p_module_name => 'update_criteria_rate_element'
298: ,p_hook_type => 'AP'
299: );
300: end;

Line 305: raise hr_api.validate_enabled;

301: --
302: -- When in validation only mode raise the Validate_Enabled exception
303: --
304: if p_validate then
305: raise hr_api.validate_enabled;
306: end if;
307: --
308: -- Set all IN OUT and OUT parameters with out values
309: --

Line 314: when hr_api.validate_enabled then

310: p_object_version_number := l_object_version_number;
311: --
312: hr_utility.set_location(' Leaving:'||l_proc, 70);
313: exception
314: when hr_api.validate_enabled then
315: --
316: -- As the Validate_Enabled exception has been raised
317: -- we must rollback to the savepoint
318: --

Line 384: when hr_api.cannot_find_prog_unit then

380: ,p_criteria_rate_element_id => p_criteria_rate_element_id
381: ,p_object_version_number => p_object_version_number
382: );
383: exception
384: when hr_api.cannot_find_prog_unit then
385: hr_api.cannot_find_prog_unit_error
386: (p_module_name => 'delete_criteria_rate_element'
387: ,p_hook_type => 'BP'
388: );

Line 385: hr_api.cannot_find_prog_unit_error

381: ,p_object_version_number => p_object_version_number
382: );
383: exception
384: when hr_api.cannot_find_prog_unit then
385: hr_api.cannot_find_prog_unit_error
386: (p_module_name => 'delete_criteria_rate_element'
387: ,p_hook_type => 'BP'
388: );
389: end;

Line 416: when hr_api.cannot_find_prog_unit then

412: ,p_criteria_rate_element_id => p_criteria_rate_element_id
413: ,p_object_version_number => p_object_version_number
414: );
415: exception
416: when hr_api.cannot_find_prog_unit then
417: hr_api.cannot_find_prog_unit_error
418: (p_module_name => 'delete_criteria_rate_element'
419: ,p_hook_type => 'AP'
420: );

Line 417: hr_api.cannot_find_prog_unit_error

413: ,p_object_version_number => p_object_version_number
414: );
415: exception
416: when hr_api.cannot_find_prog_unit then
417: hr_api.cannot_find_prog_unit_error
418: (p_module_name => 'delete_criteria_rate_element'
419: ,p_hook_type => 'AP'
420: );
421: end;

Line 426: raise hr_api.validate_enabled;

422: --
423: -- When in validation only mode raise the Validate_Enabled exception
424: --
425: if p_validate then
426: raise hr_api.validate_enabled;
427: end if;
428: --
429: -- Set all IN OUT and OUT parameters with out values
430: --

Line 434: when hr_api.validate_enabled then

430: --
431: --
432: hr_utility.set_location(' Leaving:'||l_proc, 70);
433: exception
434: when hr_api.validate_enabled then
435: --
436: -- As the Validate_Enabled exception has been raised
437: -- we must rollback to the savepoint
438: --