APPS.PQH_RATE_ELEMENT_RELATIONS_API dependencies on HR_API

Line 78: when hr_api.cannot_find_prog_unit then

74: ,p_business_group_id => p_business_group_id
75: ,p_legislation_code => p_legislation_code
76: );
77: exception
78: when hr_api.cannot_find_prog_unit then
79: hr_api.cannot_find_prog_unit_error
80: (p_module_name => 'create_rate_element_relation'
81: ,p_hook_type => 'BP'
82: );

Line 79: hr_api.cannot_find_prog_unit_error

75: ,p_legislation_code => p_legislation_code
76: );
77: exception
78: when hr_api.cannot_find_prog_unit then
79: hr_api.cannot_find_prog_unit_error
80: (p_module_name => 'create_rate_element_relation'
81: ,p_hook_type => 'BP'
82: );
83: end;

Line 138: when hr_api.cannot_find_prog_unit then

134: ,p_rate_element_relation_id => l_rate_element_relation_id
135: ,p_object_version_number => l_object_version_number
136: );
137: exception
138: when hr_api.cannot_find_prog_unit then
139: hr_api.cannot_find_prog_unit_error
140: (p_module_name => 'create_rate_element_relation'
141: ,p_hook_type => 'AP'
142: );

Line 139: hr_api.cannot_find_prog_unit_error

135: ,p_object_version_number => l_object_version_number
136: );
137: exception
138: when hr_api.cannot_find_prog_unit then
139: hr_api.cannot_find_prog_unit_error
140: (p_module_name => 'create_rate_element_relation'
141: ,p_hook_type => 'AP'
142: );
143: end;

Line 148: raise hr_api.validate_enabled;

144: --
145: -- When in validation only mode raise the Validate_Enabled exception
146: --
147: if p_validate then
148: raise hr_api.validate_enabled;
149: end if;
150: --
151: -- Set all IN OUT and OUT parameters with out values
152: --

Line 158: when hr_api.validate_enabled then

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

Line 200: ,p_criteria_rate_element_id in number default hr_api.g_number

196: procedure update_rate_element_relation
197: (p_validate in boolean default false
198: ,p_effective_date in date
199: ,p_rate_element_relation_id in number
200: ,p_criteria_rate_element_id in number default hr_api.g_number
201: ,p_relation_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_rel_element_type_id in number default hr_api.g_number
203: ,p_rel_input_value_id in number default hr_api.g_number
204: ,p_business_group_id in number default hr_api.g_number

Line 201: ,p_relation_type_cd in varchar2 default hr_api.g_varchar2

197: (p_validate in boolean default false
198: ,p_effective_date in date
199: ,p_rate_element_relation_id in number
200: ,p_criteria_rate_element_id in number default hr_api.g_number
201: ,p_relation_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_rel_element_type_id in number default hr_api.g_number
203: ,p_rel_input_value_id in number default hr_api.g_number
204: ,p_business_group_id in number default hr_api.g_number
205: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 202: ,p_rel_element_type_id in number default hr_api.g_number

198: ,p_effective_date in date
199: ,p_rate_element_relation_id in number
200: ,p_criteria_rate_element_id in number default hr_api.g_number
201: ,p_relation_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_rel_element_type_id in number default hr_api.g_number
203: ,p_rel_input_value_id in number default hr_api.g_number
204: ,p_business_group_id in number default hr_api.g_number
205: ,p_legislation_code in varchar2 default hr_api.g_varchar2
206: ,p_object_version_number in out nocopy number

Line 203: ,p_rel_input_value_id in number default hr_api.g_number

199: ,p_rate_element_relation_id in number
200: ,p_criteria_rate_element_id in number default hr_api.g_number
201: ,p_relation_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_rel_element_type_id in number default hr_api.g_number
203: ,p_rel_input_value_id in number default hr_api.g_number
204: ,p_business_group_id in number default hr_api.g_number
205: ,p_legislation_code in varchar2 default hr_api.g_varchar2
206: ,p_object_version_number in out nocopy number
207: )is

Line 204: ,p_business_group_id in number default hr_api.g_number

200: ,p_criteria_rate_element_id in number default hr_api.g_number
201: ,p_relation_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_rel_element_type_id in number default hr_api.g_number
203: ,p_rel_input_value_id in number default hr_api.g_number
204: ,p_business_group_id in number default hr_api.g_number
205: ,p_legislation_code in varchar2 default hr_api.g_varchar2
206: ,p_object_version_number in out nocopy number
207: )is
208: --

Line 205: ,p_legislation_code in varchar2 default hr_api.g_varchar2

201: ,p_relation_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_rel_element_type_id in number default hr_api.g_number
203: ,p_rel_input_value_id in number default hr_api.g_number
204: ,p_business_group_id in number default hr_api.g_number
205: ,p_legislation_code in varchar2 default hr_api.g_varchar2
206: ,p_object_version_number in out nocopy number
207: )is
208: --
209: -- Declare cursors and local variables

Line 264: when hr_api.cannot_find_prog_unit then

260: ,p_rate_element_relation_id => p_rate_element_relation_id
261: ,p_object_version_number => l_object_version_number
262: );
263: exception
264: when hr_api.cannot_find_prog_unit then
265: hr_api.cannot_find_prog_unit_error
266: (p_module_name => 'update_rate_element_relation'
267: ,p_hook_type => 'BP'
268: );

Line 265: hr_api.cannot_find_prog_unit_error

261: ,p_object_version_number => l_object_version_number
262: );
263: exception
264: when hr_api.cannot_find_prog_unit then
265: hr_api.cannot_find_prog_unit_error
266: (p_module_name => 'update_rate_element_relation'
267: ,p_hook_type => 'BP'
268: );
269: end;

Line 308: when hr_api.cannot_find_prog_unit then

304: ,p_rate_element_relation_id => p_rate_element_relation_id
305: ,p_object_version_number => l_object_version_number
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'update_rate_element_relation'
311: ,p_hook_type => 'AP'
312: );

Line 309: hr_api.cannot_find_prog_unit_error

305: ,p_object_version_number => l_object_version_number
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'update_rate_element_relation'
311: ,p_hook_type => 'AP'
312: );
313: end;

Line 318: raise hr_api.validate_enabled;

314: --
315: -- When in validation only mode raise the Validate_Enabled exception
316: --
317: if p_validate then
318: raise hr_api.validate_enabled;
319: end if;
320: --
321: -- Set all IN OUT and OUT parameters with out values
322: --

Line 327: when hr_api.validate_enabled then

323: p_object_version_number := l_object_version_number;
324: --
325: hr_utility.set_location(' Leaving:'||l_proc, 70);
326: exception
327: when hr_api.validate_enabled then
328: --
329: -- As the Validate_Enabled exception has been raised
330: -- we must rollback to the savepoint
331: --

Line 397: when hr_api.cannot_find_prog_unit then

393: ,p_rate_element_relation_id => p_rate_element_relation_id
394: ,p_object_version_number => p_object_version_number
395: );
396: exception
397: when hr_api.cannot_find_prog_unit then
398: hr_api.cannot_find_prog_unit_error
399: (p_module_name => 'delete_rate_element_relation'
400: ,p_hook_type => 'BP'
401: );

Line 398: hr_api.cannot_find_prog_unit_error

394: ,p_object_version_number => p_object_version_number
395: );
396: exception
397: when hr_api.cannot_find_prog_unit then
398: hr_api.cannot_find_prog_unit_error
399: (p_module_name => 'delete_rate_element_relation'
400: ,p_hook_type => 'BP'
401: );
402: end;

Line 429: when hr_api.cannot_find_prog_unit then

425: ,p_rate_element_relation_id => p_rate_element_relation_id
426: ,p_object_version_number => p_object_version_number
427: );
428: exception
429: when hr_api.cannot_find_prog_unit then
430: hr_api.cannot_find_prog_unit_error
431: (p_module_name => 'delete_rate_element_relation'
432: ,p_hook_type => 'AP'
433: );

Line 430: hr_api.cannot_find_prog_unit_error

426: ,p_object_version_number => p_object_version_number
427: );
428: exception
429: when hr_api.cannot_find_prog_unit then
430: hr_api.cannot_find_prog_unit_error
431: (p_module_name => 'delete_rate_element_relation'
432: ,p_hook_type => 'AP'
433: );
434: end;

Line 439: raise hr_api.validate_enabled;

435: --
436: -- When in validation only mode raise the Validate_Enabled exception
437: --
438: if p_validate then
439: raise hr_api.validate_enabled;
440: end if;
441: --
442: -- Set all IN OUT and OUT parameters with out values
443: --

Line 447: when hr_api.validate_enabled then

443: --
444: --
445: hr_utility.set_location(' Leaving:'||l_proc, 70);
446: exception
447: when hr_api.validate_enabled then
448: --
449: -- As the Validate_Enabled exception has been raised
450: -- we must rollback to the savepoint
451: --