DBA Data[Home] [Help]

APPS.PQH_BUDGETS_API dependencies on HR_API

Line 96: when hr_api.cannot_find_prog_unit then

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

Line 97: hr_api.cannot_find_prog_unit_error

93: ,p_effective_date => trunc(p_effective_date)
94: );
95: exception
96: when hr_api.cannot_find_prog_unit then
97: hr_api.cannot_find_prog_unit_error
98: (
99: p_module_name => 'create_budget'
100: ,p_hook_type => 'BP'
101: );

Line 175: when hr_api.cannot_find_prog_unit then

171: ,p_dflt_budget_set_id => p_dflt_budget_set_id
172: ,p_effective_date => trunc(p_effective_date)
173: );
174: exception
175: when hr_api.cannot_find_prog_unit then
176: hr_api.cannot_find_prog_unit_error
177: (p_module_name => 'create_budget'
178: ,p_hook_type => 'AP'
179: );

Line 176: hr_api.cannot_find_prog_unit_error

172: ,p_effective_date => trunc(p_effective_date)
173: );
174: exception
175: when hr_api.cannot_find_prog_unit then
176: hr_api.cannot_find_prog_unit_error
177: (p_module_name => 'create_budget'
178: ,p_hook_type => 'AP'
179: );
180: --

Line 190: raise hr_api.validate_enabled;

186: --
187: -- When in validation only mode raise the Validate_Enabled exception
188: --
189: if p_validate then
190: raise hr_api.validate_enabled;
191: end if;
192: --
193: -- Set all output arguments
194: --

Line 202: when hr_api.validate_enabled then

198: hr_utility.set_location(' Leaving:'||l_proc, 70);
199: --
200: exception
201: --
202: when hr_api.validate_enabled then
203: --
204: -- As the Validate_Enabled exception has been raised
205: -- we must rollback to the savepoint
206: --

Line 234: ,p_business_group_id in number default hr_api.g_number

230: --
231: procedure update_budget
232: (p_validate in boolean default false
233: ,p_budget_id in number
234: ,p_business_group_id in number default hr_api.g_number
235: ,p_start_organization_id in number default hr_api.g_number
236: ,p_org_structure_version_id in number default hr_api.g_number
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2

Line 235: ,p_start_organization_id in number default hr_api.g_number

231: procedure update_budget
232: (p_validate in boolean default false
233: ,p_budget_id in number
234: ,p_business_group_id in number default hr_api.g_number
235: ,p_start_organization_id in number default hr_api.g_number
236: ,p_org_structure_version_id in number default hr_api.g_number
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2

Line 236: ,p_org_structure_version_id in number default hr_api.g_number

232: (p_validate in boolean default false
233: ,p_budget_id in number
234: ,p_business_group_id in number default hr_api.g_number
235: ,p_start_organization_id in number default hr_api.g_number
236: ,p_org_structure_version_id in number default hr_api.g_number
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2

Line 237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2

233: ,p_budget_id in number
234: ,p_business_group_id in number default hr_api.g_number
235: ,p_start_organization_id in number default hr_api.g_number
236: ,p_org_structure_version_id in number default hr_api.g_number
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date

Line 238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2

234: ,p_business_group_id in number default hr_api.g_number
235: ,p_start_organization_id in number default hr_api.g_number
236: ,p_org_structure_version_id in number default hr_api.g_number
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date

Line 239: ,p_budget_name in varchar2 default hr_api.g_varchar2

235: ,p_start_organization_id in number default hr_api.g_number
236: ,p_org_structure_version_id in number default hr_api.g_number
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2

Line 240: ,p_period_set_name in varchar2 default hr_api.g_varchar2

236: ,p_org_structure_version_id in number default hr_api.g_number
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2

Line 241: ,p_budget_start_date in date default hr_api.g_date

237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2

Line 242: ,p_budget_end_date in date default hr_api.g_date

238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2

Line 243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2

239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2

Line 244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2

240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number

Line 245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2

241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number
249: ,p_budget_unit1_id in number default hr_api.g_number

Line 246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2

242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number
249: ,p_budget_unit1_id in number default hr_api.g_number
250: ,p_budget_unit2_id in number default hr_api.g_number

Line 247: ,p_status in varchar2 default hr_api.g_varchar2

243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number
249: ,p_budget_unit1_id in number default hr_api.g_number
250: ,p_budget_unit2_id in number default hr_api.g_number
251: ,p_budget_unit3_id in number default hr_api.g_number

Line 249: ,p_budget_unit1_id in number default hr_api.g_number

245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number
249: ,p_budget_unit1_id in number default hr_api.g_number
250: ,p_budget_unit2_id in number default hr_api.g_number
251: ,p_budget_unit3_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2

Line 250: ,p_budget_unit2_id in number default hr_api.g_number

246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number
249: ,p_budget_unit1_id in number default hr_api.g_number
250: ,p_budget_unit2_id in number default hr_api.g_number
251: ,p_budget_unit3_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2

Line 251: ,p_budget_unit3_id in number default hr_api.g_number

247: ,p_status in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number
249: ,p_budget_unit1_id in number default hr_api.g_number
250: ,p_budget_unit2_id in number default hr_api.g_number
251: ,p_budget_unit3_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2

Line 252: ,p_gl_set_of_books_id in number default hr_api.g_number

248: ,p_object_version_number in out nocopy number
249: ,p_budget_unit1_id in number default hr_api.g_number
250: ,p_budget_unit2_id in number default hr_api.g_number
251: ,p_budget_unit3_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2

Line 253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2

249: ,p_budget_unit1_id in number default hr_api.g_number
250: ,p_budget_unit2_id in number default hr_api.g_number
251: ,p_budget_unit3_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2

Line 254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2

250: ,p_budget_unit2_id in number default hr_api.g_number
251: ,p_budget_unit3_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2
258: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2

251: ,p_budget_unit3_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2
258: ,p_currency_code in varchar2 default hr_api.g_varchar2
259: ,p_dflt_budget_set_id in number default hr_api.g_number

Line 256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2

252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2
258: ,p_currency_code in varchar2 default hr_api.g_varchar2
259: ,p_dflt_budget_set_id in number default hr_api.g_number
260: ,p_effective_date in date

Line 257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2

253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2
258: ,p_currency_code in varchar2 default hr_api.g_varchar2
259: ,p_dflt_budget_set_id in number default hr_api.g_number
260: ,p_effective_date in date
261: ) is

Line 258: ,p_currency_code in varchar2 default hr_api.g_varchar2

254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2
258: ,p_currency_code in varchar2 default hr_api.g_varchar2
259: ,p_dflt_budget_set_id in number default hr_api.g_number
260: ,p_effective_date in date
261: ) is
262: --

Line 259: ,p_dflt_budget_set_id in number default hr_api.g_number

255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2
258: ,p_currency_code in varchar2 default hr_api.g_varchar2
259: ,p_dflt_budget_set_id in number default hr_api.g_number
260: ,p_effective_date in date
261: ) is
262: --
263: -- Declare cursors and local variables

Line 318: when hr_api.cannot_find_prog_unit then

314: ,p_dflt_budget_set_id => p_dflt_budget_set_id
315: ,p_effective_date => trunc(p_effective_date)
316: );
317: exception
318: when hr_api.cannot_find_prog_unit then
319: hr_api.cannot_find_prog_unit_error
320: (p_module_name => 'update_budget'
321: ,p_hook_type => 'BP'
322: );

Line 319: hr_api.cannot_find_prog_unit_error

315: ,p_effective_date => trunc(p_effective_date)
316: );
317: exception
318: when hr_api.cannot_find_prog_unit then
319: hr_api.cannot_find_prog_unit_error
320: (p_module_name => 'update_budget'
321: ,p_hook_type => 'BP'
322: );
323: --

Line 396: when hr_api.cannot_find_prog_unit then

392: ,p_dflt_budget_set_id => p_dflt_budget_set_id
393: ,p_effective_date => trunc(p_effective_date)
394: );
395: exception
396: when hr_api.cannot_find_prog_unit then
397: hr_api.cannot_find_prog_unit_error
398: (p_module_name => 'update_budget'
399: ,p_hook_type => 'AP'
400: );

Line 397: hr_api.cannot_find_prog_unit_error

393: ,p_effective_date => trunc(p_effective_date)
394: );
395: exception
396: when hr_api.cannot_find_prog_unit then
397: hr_api.cannot_find_prog_unit_error
398: (p_module_name => 'update_budget'
399: ,p_hook_type => 'AP'
400: );
401: --

Line 411: raise hr_api.validate_enabled;

407: --
408: -- When in validation only mode raise the Validate_Enabled exception
409: --
410: if p_validate then
411: raise hr_api.validate_enabled;
412: end if;
413: --
414: -- Set all output arguments
415: --

Line 422: when hr_api.validate_enabled then

418: hr_utility.set_location(' Leaving:'||l_proc, 70);
419: --
420: exception
421: --
422: when hr_api.validate_enabled then
423: --
424: -- As the Validate_Enabled exception has been raised
425: -- we must rollback to the savepoint
426: --

Line 486: when hr_api.cannot_find_prog_unit then

482: ,p_object_version_number => p_object_version_number
483: ,p_effective_date => trunc(p_effective_date)
484: );
485: exception
486: when hr_api.cannot_find_prog_unit then
487: hr_api.cannot_find_prog_unit_error
488: (p_module_name => 'delete_budget'
489: ,p_hook_type => 'BP'
490: );

Line 487: hr_api.cannot_find_prog_unit_error

483: ,p_effective_date => trunc(p_effective_date)
484: );
485: exception
486: when hr_api.cannot_find_prog_unit then
487: hr_api.cannot_find_prog_unit_error
488: (p_module_name => 'delete_budget'
489: ,p_hook_type => 'BP'
490: );
491: --

Line 514: when hr_api.cannot_find_prog_unit then

510: ,p_object_version_number => l_object_version_number
511: ,p_effective_date => trunc(p_effective_date)
512: );
513: exception
514: when hr_api.cannot_find_prog_unit then
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'delete_budget'
517: ,p_hook_type => 'AP'
518: );

Line 515: hr_api.cannot_find_prog_unit_error

511: ,p_effective_date => trunc(p_effective_date)
512: );
513: exception
514: when hr_api.cannot_find_prog_unit then
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'delete_budget'
517: ,p_hook_type => 'AP'
518: );
519: --

Line 529: raise hr_api.validate_enabled;

525: --
526: -- When in validation only mode raise the Validate_Enabled exception
527: --
528: if p_validate then
529: raise hr_api.validate_enabled;
530: end if;
531: --
532: hr_utility.set_location(' Leaving:'||l_proc, 70);
533: --

Line 536: when hr_api.validate_enabled then

532: hr_utility.set_location(' Leaving:'||l_proc, 70);
533: --
534: exception
535: --
536: when hr_api.validate_enabled then
537: --
538: -- As the Validate_Enabled exception has been raised
539: -- we must rollback to the savepoint
540: --