DBA Data[Home] [Help]

APPS.PQH_RATE_FACTOR_ON_ELMNTS_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_factor_on_elmnt'
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_factor_on_elmnt'
81: ,p_hook_type => 'BP'
82: );
83: end;

Line 149: when hr_api.cannot_find_prog_unit then

145: ,p_rate_factor_on_elmnt_id => l_rate_factor_on_elmnt_id
146: ,p_object_version_number => l_object_version_number
147: );
148: exception
149: when hr_api.cannot_find_prog_unit then
150: hr_api.cannot_find_prog_unit_error
151: (p_module_name => 'create_rate_factor_on_elmnt'
152: ,p_hook_type => 'AP'
153: );

Line 150: hr_api.cannot_find_prog_unit_error

146: ,p_object_version_number => l_object_version_number
147: );
148: exception
149: when hr_api.cannot_find_prog_unit then
150: hr_api.cannot_find_prog_unit_error
151: (p_module_name => 'create_rate_factor_on_elmnt'
152: ,p_hook_type => 'AP'
153: );
154: end;

Line 159: raise hr_api.validate_enabled;

155: --
156: -- When in validation only mode raise the Validate_Enabled exception
157: --
158: if p_validate then
159: raise hr_api.validate_enabled;
160: end if;
161: --
162: -- Set all IN OUT and OUT parameters with out values
163: --

Line 169: when hr_api.validate_enabled then

165: p_object_version_number := l_object_version_number;
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 70);
168: exception
169: when hr_api.validate_enabled then
170: --
171: -- As the Validate_Enabled exception has been raised
172: -- we must rollback to the savepoint
173: --

Line 211: ,p_criteria_rate_element_id in number default hr_api.g_number

207: procedure update_rate_factor_on_elmnt
208: (p_validate in boolean default false
209: ,p_effective_date in date
210: ,p_rate_factor_on_elmnt_id in number
211: ,p_criteria_rate_element_id in number default hr_api.g_number
212: ,p_criteria_rate_factor_id in number default hr_api.g_number
213: ,p_rate_factor_val_record_tbl in varchar2 default hr_api.g_varchar2
214: ,p_rate_factor_val_record_col in varchar2 default hr_api.g_varchar2
215: ,p_business_group_id in number default hr_api.g_number

Line 212: ,p_criteria_rate_factor_id in number default hr_api.g_number

208: (p_validate in boolean default false
209: ,p_effective_date in date
210: ,p_rate_factor_on_elmnt_id in number
211: ,p_criteria_rate_element_id in number default hr_api.g_number
212: ,p_criteria_rate_factor_id in number default hr_api.g_number
213: ,p_rate_factor_val_record_tbl in varchar2 default hr_api.g_varchar2
214: ,p_rate_factor_val_record_col in varchar2 default hr_api.g_varchar2
215: ,p_business_group_id in number default hr_api.g_number
216: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 213: ,p_rate_factor_val_record_tbl in varchar2 default hr_api.g_varchar2

209: ,p_effective_date in date
210: ,p_rate_factor_on_elmnt_id in number
211: ,p_criteria_rate_element_id in number default hr_api.g_number
212: ,p_criteria_rate_factor_id in number default hr_api.g_number
213: ,p_rate_factor_val_record_tbl in varchar2 default hr_api.g_varchar2
214: ,p_rate_factor_val_record_col in varchar2 default hr_api.g_varchar2
215: ,p_business_group_id in number default hr_api.g_number
216: ,p_legislation_code in varchar2 default hr_api.g_varchar2
217: ,p_object_version_number in out nocopy number

Line 214: ,p_rate_factor_val_record_col in varchar2 default hr_api.g_varchar2

210: ,p_rate_factor_on_elmnt_id in number
211: ,p_criteria_rate_element_id in number default hr_api.g_number
212: ,p_criteria_rate_factor_id in number default hr_api.g_number
213: ,p_rate_factor_val_record_tbl in varchar2 default hr_api.g_varchar2
214: ,p_rate_factor_val_record_col in varchar2 default hr_api.g_varchar2
215: ,p_business_group_id in number default hr_api.g_number
216: ,p_legislation_code in varchar2 default hr_api.g_varchar2
217: ,p_object_version_number in out nocopy number
218: )is

Line 215: ,p_business_group_id in number default hr_api.g_number

211: ,p_criteria_rate_element_id in number default hr_api.g_number
212: ,p_criteria_rate_factor_id in number default hr_api.g_number
213: ,p_rate_factor_val_record_tbl in varchar2 default hr_api.g_varchar2
214: ,p_rate_factor_val_record_col in varchar2 default hr_api.g_varchar2
215: ,p_business_group_id in number default hr_api.g_number
216: ,p_legislation_code in varchar2 default hr_api.g_varchar2
217: ,p_object_version_number in out nocopy number
218: )is
219: --

Line 216: ,p_legislation_code in varchar2 default hr_api.g_varchar2

212: ,p_criteria_rate_factor_id in number default hr_api.g_number
213: ,p_rate_factor_val_record_tbl in varchar2 default hr_api.g_varchar2
214: ,p_rate_factor_val_record_col in varchar2 default hr_api.g_varchar2
215: ,p_business_group_id in number default hr_api.g_number
216: ,p_legislation_code in varchar2 default hr_api.g_varchar2
217: ,p_object_version_number in out nocopy number
218: )is
219: --
220: -- Declare cursors and local variables

Line 273: when hr_api.cannot_find_prog_unit then

269: ,p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id
270: ,p_object_version_number => l_object_version_number
271: );
272: exception
273: when hr_api.cannot_find_prog_unit then
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'update_rate_factor_on_elmnt'
276: ,p_hook_type => 'BP'
277: );

Line 274: hr_api.cannot_find_prog_unit_error

270: ,p_object_version_number => l_object_version_number
271: );
272: exception
273: when hr_api.cannot_find_prog_unit then
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'update_rate_factor_on_elmnt'
276: ,p_hook_type => 'BP'
277: );
278: end;

Line 316: when hr_api.cannot_find_prog_unit then

312: ,p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id
313: ,p_object_version_number => l_object_version_number
314: );
315: exception
316: when hr_api.cannot_find_prog_unit then
317: hr_api.cannot_find_prog_unit_error
318: (p_module_name => 'update_rate_factor_on_elmnt'
319: ,p_hook_type => 'AP'
320: );

Line 317: hr_api.cannot_find_prog_unit_error

313: ,p_object_version_number => l_object_version_number
314: );
315: exception
316: when hr_api.cannot_find_prog_unit then
317: hr_api.cannot_find_prog_unit_error
318: (p_module_name => 'update_rate_factor_on_elmnt'
319: ,p_hook_type => 'AP'
320: );
321: end;

Line 326: raise hr_api.validate_enabled;

322: --
323: -- When in validation only mode raise the Validate_Enabled exception
324: --
325: if p_validate then
326: raise hr_api.validate_enabled;
327: end if;
328: --
329: -- Set all IN OUT and OUT parameters with out values
330: --

Line 335: when hr_api.validate_enabled then

331: p_object_version_number := l_object_version_number;
332: --
333: hr_utility.set_location(' Leaving:'||l_proc, 70);
334: exception
335: when hr_api.validate_enabled then
336: --
337: -- As the Validate_Enabled exception has been raised
338: -- we must rollback to the savepoint
339: --

Line 405: when hr_api.cannot_find_prog_unit then

401: ,p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id
402: ,p_object_version_number => p_object_version_number
403: );
404: exception
405: when hr_api.cannot_find_prog_unit then
406: hr_api.cannot_find_prog_unit_error
407: (p_module_name => 'delete_rate_factor_on_elmnt'
408: ,p_hook_type => 'BP'
409: );

Line 406: hr_api.cannot_find_prog_unit_error

402: ,p_object_version_number => p_object_version_number
403: );
404: exception
405: when hr_api.cannot_find_prog_unit then
406: hr_api.cannot_find_prog_unit_error
407: (p_module_name => 'delete_rate_factor_on_elmnt'
408: ,p_hook_type => 'BP'
409: );
410: end;

Line 437: when hr_api.cannot_find_prog_unit then

433: ,p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id
434: ,p_object_version_number => p_object_version_number
435: );
436: exception
437: when hr_api.cannot_find_prog_unit then
438: hr_api.cannot_find_prog_unit_error
439: (p_module_name => 'delete_rate_factor_on_elmnt'
440: ,p_hook_type => 'AP'
441: );

Line 438: hr_api.cannot_find_prog_unit_error

434: ,p_object_version_number => p_object_version_number
435: );
436: exception
437: when hr_api.cannot_find_prog_unit then
438: hr_api.cannot_find_prog_unit_error
439: (p_module_name => 'delete_rate_factor_on_elmnt'
440: ,p_hook_type => 'AP'
441: );
442: end;

Line 447: raise hr_api.validate_enabled;

443: --
444: -- When in validation only mode raise the Validate_Enabled exception
445: --
446: if p_validate then
447: raise hr_api.validate_enabled;
448: end if;
449: --
450: -- Set all IN OUT and OUT parameters with out values
451: --

Line 455: when hr_api.validate_enabled then

451: --
452: --
453: hr_utility.set_location(' Leaving:'||l_proc, 70);
454: exception
455: when hr_api.validate_enabled then
456: --
457: -- As the Validate_Enabled exception has been raised
458: -- we must rollback to the savepoint
459: --