DBA Data[Home] [Help]

APPS.PQH_BUDGET_DETAILS_API dependencies on HR_API

Line 80: when hr_api.cannot_find_prog_unit then

76: ,p_budget_unit3_available => p_budget_unit3_available
77: ,p_gl_status => p_gl_status
78: );
79: exception
80: when hr_api.cannot_find_prog_unit then
81: hr_api.cannot_find_prog_unit_error
82: (
83: p_module_name => 'create_budget_detail'
84: ,p_hook_type => 'BP'

Line 81: hr_api.cannot_find_prog_unit_error

77: ,p_gl_status => p_gl_status
78: );
79: exception
80: when hr_api.cannot_find_prog_unit then
81: hr_api.cannot_find_prog_unit_error
82: (
83: p_module_name => 'create_budget_detail'
84: ,p_hook_type => 'BP'
85: );

Line 143: when hr_api.cannot_find_prog_unit then

139: ,p_gl_status => p_gl_status
140: ,p_object_version_number => l_object_version_number
141: );
142: exception
143: when hr_api.cannot_find_prog_unit then
144: hr_api.cannot_find_prog_unit_error
145: (p_module_name => 'create_budget_detail'
146: ,p_hook_type => 'AP'
147: );

Line 144: hr_api.cannot_find_prog_unit_error

140: ,p_object_version_number => l_object_version_number
141: );
142: exception
143: when hr_api.cannot_find_prog_unit then
144: hr_api.cannot_find_prog_unit_error
145: (p_module_name => 'create_budget_detail'
146: ,p_hook_type => 'AP'
147: );
148: --

Line 158: raise hr_api.validate_enabled;

154: --
155: -- When in validation only mode raise the Validate_Enabled exception
156: --
157: if p_validate then
158: raise hr_api.validate_enabled;
159: end if;
160: --
161: -- Set all output arguments
162: --

Line 170: when hr_api.validate_enabled then

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

Line 202: ,p_organization_id in number default hr_api.g_number

198: --
199: procedure update_budget_detail
200: (p_validate in boolean default false
201: ,p_budget_detail_id in number
202: ,p_organization_id in number default hr_api.g_number
203: ,p_job_id in number default hr_api.g_number
204: ,p_position_id in number default hr_api.g_number
205: ,p_grade_id in number default hr_api.g_number
206: ,p_budget_version_id in number default hr_api.g_number

Line 203: ,p_job_id in number default hr_api.g_number

199: procedure update_budget_detail
200: (p_validate in boolean default false
201: ,p_budget_detail_id in number
202: ,p_organization_id in number default hr_api.g_number
203: ,p_job_id in number default hr_api.g_number
204: ,p_position_id in number default hr_api.g_number
205: ,p_grade_id in number default hr_api.g_number
206: ,p_budget_version_id in number default hr_api.g_number
207: ,p_budget_unit1_percent in number default hr_api.g_number

Line 204: ,p_position_id in number default hr_api.g_number

200: (p_validate in boolean default false
201: ,p_budget_detail_id in number
202: ,p_organization_id in number default hr_api.g_number
203: ,p_job_id in number default hr_api.g_number
204: ,p_position_id in number default hr_api.g_number
205: ,p_grade_id in number default hr_api.g_number
206: ,p_budget_version_id in number default hr_api.g_number
207: ,p_budget_unit1_percent in number default hr_api.g_number
208: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

Line 205: ,p_grade_id in number default hr_api.g_number

201: ,p_budget_detail_id in number
202: ,p_organization_id in number default hr_api.g_number
203: ,p_job_id in number default hr_api.g_number
204: ,p_position_id in number default hr_api.g_number
205: ,p_grade_id in number default hr_api.g_number
206: ,p_budget_version_id in number default hr_api.g_number
207: ,p_budget_unit1_percent in number default hr_api.g_number
208: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
209: ,p_budget_unit1_value in number default hr_api.g_number

Line 206: ,p_budget_version_id in number default hr_api.g_number

202: ,p_organization_id in number default hr_api.g_number
203: ,p_job_id in number default hr_api.g_number
204: ,p_position_id in number default hr_api.g_number
205: ,p_grade_id in number default hr_api.g_number
206: ,p_budget_version_id in number default hr_api.g_number
207: ,p_budget_unit1_percent in number default hr_api.g_number
208: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
209: ,p_budget_unit1_value in number default hr_api.g_number
210: ,p_budget_unit1_available in number default hr_api.g_number

Line 207: ,p_budget_unit1_percent in number default hr_api.g_number

203: ,p_job_id in number default hr_api.g_number
204: ,p_position_id in number default hr_api.g_number
205: ,p_grade_id in number default hr_api.g_number
206: ,p_budget_version_id in number default hr_api.g_number
207: ,p_budget_unit1_percent in number default hr_api.g_number
208: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
209: ,p_budget_unit1_value in number default hr_api.g_number
210: ,p_budget_unit1_available in number default hr_api.g_number
211: ,p_budget_unit2_percent in number default hr_api.g_number

Line 208: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

204: ,p_position_id in number default hr_api.g_number
205: ,p_grade_id in number default hr_api.g_number
206: ,p_budget_version_id in number default hr_api.g_number
207: ,p_budget_unit1_percent in number default hr_api.g_number
208: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
209: ,p_budget_unit1_value in number default hr_api.g_number
210: ,p_budget_unit1_available in number default hr_api.g_number
211: ,p_budget_unit2_percent in number default hr_api.g_number
212: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

Line 209: ,p_budget_unit1_value in number default hr_api.g_number

205: ,p_grade_id in number default hr_api.g_number
206: ,p_budget_version_id in number default hr_api.g_number
207: ,p_budget_unit1_percent in number default hr_api.g_number
208: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
209: ,p_budget_unit1_value in number default hr_api.g_number
210: ,p_budget_unit1_available in number default hr_api.g_number
211: ,p_budget_unit2_percent in number default hr_api.g_number
212: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
213: ,p_budget_unit2_value in number default hr_api.g_number

Line 210: ,p_budget_unit1_available in number default hr_api.g_number

206: ,p_budget_version_id in number default hr_api.g_number
207: ,p_budget_unit1_percent in number default hr_api.g_number
208: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
209: ,p_budget_unit1_value in number default hr_api.g_number
210: ,p_budget_unit1_available in number default hr_api.g_number
211: ,p_budget_unit2_percent in number default hr_api.g_number
212: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
213: ,p_budget_unit2_value in number default hr_api.g_number
214: ,p_budget_unit2_available in number default hr_api.g_number

Line 211: ,p_budget_unit2_percent in number default hr_api.g_number

207: ,p_budget_unit1_percent in number default hr_api.g_number
208: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
209: ,p_budget_unit1_value in number default hr_api.g_number
210: ,p_budget_unit1_available in number default hr_api.g_number
211: ,p_budget_unit2_percent in number default hr_api.g_number
212: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
213: ,p_budget_unit2_value in number default hr_api.g_number
214: ,p_budget_unit2_available in number default hr_api.g_number
215: ,p_budget_unit3_percent in number default hr_api.g_number

Line 212: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

208: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
209: ,p_budget_unit1_value in number default hr_api.g_number
210: ,p_budget_unit1_available in number default hr_api.g_number
211: ,p_budget_unit2_percent in number default hr_api.g_number
212: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
213: ,p_budget_unit2_value in number default hr_api.g_number
214: ,p_budget_unit2_available in number default hr_api.g_number
215: ,p_budget_unit3_percent in number default hr_api.g_number
216: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

Line 213: ,p_budget_unit2_value in number default hr_api.g_number

209: ,p_budget_unit1_value in number default hr_api.g_number
210: ,p_budget_unit1_available in number default hr_api.g_number
211: ,p_budget_unit2_percent in number default hr_api.g_number
212: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
213: ,p_budget_unit2_value in number default hr_api.g_number
214: ,p_budget_unit2_available in number default hr_api.g_number
215: ,p_budget_unit3_percent in number default hr_api.g_number
216: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
217: ,p_budget_unit3_value in number default hr_api.g_number

Line 214: ,p_budget_unit2_available in number default hr_api.g_number

210: ,p_budget_unit1_available in number default hr_api.g_number
211: ,p_budget_unit2_percent in number default hr_api.g_number
212: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
213: ,p_budget_unit2_value in number default hr_api.g_number
214: ,p_budget_unit2_available in number default hr_api.g_number
215: ,p_budget_unit3_percent in number default hr_api.g_number
216: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
217: ,p_budget_unit3_value in number default hr_api.g_number
218: ,p_budget_unit3_available in number default hr_api.g_number

Line 215: ,p_budget_unit3_percent in number default hr_api.g_number

211: ,p_budget_unit2_percent in number default hr_api.g_number
212: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
213: ,p_budget_unit2_value in number default hr_api.g_number
214: ,p_budget_unit2_available in number default hr_api.g_number
215: ,p_budget_unit3_percent in number default hr_api.g_number
216: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
217: ,p_budget_unit3_value in number default hr_api.g_number
218: ,p_budget_unit3_available in number default hr_api.g_number
219: ,p_gl_status in varchar2 default hr_api.g_varchar2

Line 216: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

212: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
213: ,p_budget_unit2_value in number default hr_api.g_number
214: ,p_budget_unit2_available in number default hr_api.g_number
215: ,p_budget_unit3_percent in number default hr_api.g_number
216: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
217: ,p_budget_unit3_value in number default hr_api.g_number
218: ,p_budget_unit3_available in number default hr_api.g_number
219: ,p_gl_status in varchar2 default hr_api.g_varchar2
220: ,p_object_version_number in out nocopy number

Line 217: ,p_budget_unit3_value in number default hr_api.g_number

213: ,p_budget_unit2_value in number default hr_api.g_number
214: ,p_budget_unit2_available in number default hr_api.g_number
215: ,p_budget_unit3_percent in number default hr_api.g_number
216: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
217: ,p_budget_unit3_value in number default hr_api.g_number
218: ,p_budget_unit3_available in number default hr_api.g_number
219: ,p_gl_status in varchar2 default hr_api.g_varchar2
220: ,p_object_version_number in out nocopy number
221: ) is

Line 218: ,p_budget_unit3_available in number default hr_api.g_number

214: ,p_budget_unit2_available in number default hr_api.g_number
215: ,p_budget_unit3_percent in number default hr_api.g_number
216: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
217: ,p_budget_unit3_value in number default hr_api.g_number
218: ,p_budget_unit3_available in number default hr_api.g_number
219: ,p_gl_status in varchar2 default hr_api.g_varchar2
220: ,p_object_version_number in out nocopy number
221: ) is
222: --

Line 219: ,p_gl_status in varchar2 default hr_api.g_varchar2

215: ,p_budget_unit3_percent in number default hr_api.g_number
216: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
217: ,p_budget_unit3_value in number default hr_api.g_number
218: ,p_budget_unit3_available in number default hr_api.g_number
219: ,p_gl_status in varchar2 default hr_api.g_varchar2
220: ,p_object_version_number in out nocopy number
221: ) is
222: --
223: -- Declare cursors and local variables

Line 270: when hr_api.cannot_find_prog_unit then

266: ,p_gl_status => p_gl_status
267: ,p_object_version_number => p_object_version_number
268: );
269: exception
270: when hr_api.cannot_find_prog_unit then
271: hr_api.cannot_find_prog_unit_error
272: (p_module_name => 'update_budget_detail'
273: ,p_hook_type => 'BP'
274: );

Line 271: hr_api.cannot_find_prog_unit_error

267: ,p_object_version_number => p_object_version_number
268: );
269: exception
270: when hr_api.cannot_find_prog_unit then
271: hr_api.cannot_find_prog_unit_error
272: (p_module_name => 'update_budget_detail'
273: ,p_hook_type => 'BP'
274: );
275: --

Line 332: when hr_api.cannot_find_prog_unit then

328: ,p_gl_status => p_gl_status
329: ,p_object_version_number => l_object_version_number
330: );
331: exception
332: when hr_api.cannot_find_prog_unit then
333: hr_api.cannot_find_prog_unit_error
334: (p_module_name => 'update_budget_detail'
335: ,p_hook_type => 'AP'
336: );

Line 333: hr_api.cannot_find_prog_unit_error

329: ,p_object_version_number => l_object_version_number
330: );
331: exception
332: when hr_api.cannot_find_prog_unit then
333: hr_api.cannot_find_prog_unit_error
334: (p_module_name => 'update_budget_detail'
335: ,p_hook_type => 'AP'
336: );
337: --

Line 347: raise hr_api.validate_enabled;

343: --
344: -- When in validation only mode raise the Validate_Enabled exception
345: --
346: if p_validate then
347: raise hr_api.validate_enabled;
348: end if;
349: --
350: -- Set all output arguments
351: --

Line 358: when hr_api.validate_enabled then

354: hr_utility.set_location(' Leaving:'||l_proc, 70);
355: --
356: exception
357: --
358: when hr_api.validate_enabled then
359: --
360: -- As the Validate_Enabled exception has been raised
361: -- we must rollback to the savepoint
362: --

Line 420: when hr_api.cannot_find_prog_unit then

416: p_budget_detail_id => p_budget_detail_id
417: ,p_object_version_number => p_object_version_number
418: );
419: exception
420: when hr_api.cannot_find_prog_unit then
421: hr_api.cannot_find_prog_unit_error
422: (p_module_name => 'delete_budget_detail'
423: ,p_hook_type => 'BP'
424: );

Line 421: hr_api.cannot_find_prog_unit_error

417: ,p_object_version_number => p_object_version_number
418: );
419: exception
420: when hr_api.cannot_find_prog_unit then
421: hr_api.cannot_find_prog_unit_error
422: (p_module_name => 'delete_budget_detail'
423: ,p_hook_type => 'BP'
424: );
425: --

Line 446: when hr_api.cannot_find_prog_unit then

442: p_budget_detail_id => p_budget_detail_id
443: ,p_object_version_number => l_object_version_number
444: );
445: exception
446: when hr_api.cannot_find_prog_unit then
447: hr_api.cannot_find_prog_unit_error
448: (p_module_name => 'delete_budget_detail'
449: ,p_hook_type => 'AP'
450: );

Line 447: hr_api.cannot_find_prog_unit_error

443: ,p_object_version_number => l_object_version_number
444: );
445: exception
446: when hr_api.cannot_find_prog_unit then
447: hr_api.cannot_find_prog_unit_error
448: (p_module_name => 'delete_budget_detail'
449: ,p_hook_type => 'AP'
450: );
451: --

Line 461: raise hr_api.validate_enabled;

457: --
458: -- When in validation only mode raise the Validate_Enabled exception
459: --
460: if p_validate then
461: raise hr_api.validate_enabled;
462: end if;
463: --
464: hr_utility.set_location(' Leaving:'||l_proc, 70);
465: --

Line 468: when hr_api.validate_enabled then

464: hr_utility.set_location(' Leaving:'||l_proc, 70);
465: --
466: exception
467: --
468: when hr_api.validate_enabled then
469: --
470: -- As the Validate_Enabled exception has been raised
471: -- we must rollback to the savepoint
472: --