DBA Data[Home] [Help]

APPS.PQH_BUDGET dependencies on HR_API

Line 328: p_worksheet_id in number default hr_api.g_number,

324: Procedure update_worksheet_detail
325: (
326: p_effective_date in date,
327: p_worksheet_detail_id in number,
328: p_worksheet_id in number default hr_api.g_number,
329: p_organization_id in number default hr_api.g_number,
330: p_job_id in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,

Line 329: p_organization_id in number default hr_api.g_number,

325: (
326: p_effective_date in date,
327: p_worksheet_detail_id in number,
328: p_worksheet_id in number default hr_api.g_number,
329: p_organization_id in number default hr_api.g_number,
330: p_job_id in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,

Line 330: p_job_id in number default hr_api.g_number,

326: p_effective_date in date,
327: p_worksheet_detail_id in number,
328: p_worksheet_id in number default hr_api.g_number,
329: p_organization_id in number default hr_api.g_number,
330: p_job_id in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,

Line 331: p_position_id in number default hr_api.g_number,

327: p_worksheet_detail_id in number,
328: p_worksheet_id in number default hr_api.g_number,
329: p_organization_id in number default hr_api.g_number,
330: p_job_id in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,

Line 332: p_grade_id in number default hr_api.g_number,

328: p_worksheet_id in number default hr_api.g_number,
329: p_organization_id in number default hr_api.g_number,
330: p_job_id in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,

Line 333: p_position_transaction_id in number default hr_api.g_number,

329: p_organization_id in number default hr_api.g_number,
330: p_job_id in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,

Line 334: p_budget_detail_id in number default hr_api.g_number,

330: p_job_id in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,

Line 335: p_parent_worksheet_detail_id in number default hr_api.g_number,

331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,

Line 336: p_user_id in number default hr_api.g_number,

332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,

Line 337: p_action_cd in varchar2 default hr_api.g_varchar2,

333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
341: p_budget_unit2_value in number default hr_api.g_number,

Line 338: p_budget_unit1_percent in number default hr_api.g_number,

334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
341: p_budget_unit2_value in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,

Line 339: p_budget_unit1_value in number default hr_api.g_number,

335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
341: p_budget_unit2_value in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,

Line 340: p_budget_unit2_percent in number default hr_api.g_number,

336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
341: p_budget_unit2_value in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,

Line 341: p_budget_unit2_value in number default hr_api.g_number,

337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
341: p_budget_unit2_value in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 342: p_budget_unit3_percent in number default hr_api.g_number,

338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
341: p_budget_unit2_value in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 343: p_budget_unit3_value in number default hr_api.g_number,

339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
341: p_budget_unit2_value in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,

341: p_budget_unit2_value in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,

Line 346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,

342: p_budget_unit3_percent in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,

Line 347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,

343: p_budget_unit3_value in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,

Line 348: p_status in varchar2 default hr_api.g_varchar2,

344: p_object_version_number in out nocopy number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,

Line 349: p_budget_unit1_available in number default hr_api.g_number,

345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,

Line 350: p_budget_unit2_available in number default hr_api.g_number,

346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
354: p_old_unit3_value in number default hr_api.g_number,

Line 351: p_budget_unit3_available in number default hr_api.g_number,

347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
354: p_old_unit3_value in number default hr_api.g_number,
355: p_defer_flag in varchar2 default hr_api.g_varchar2,

Line 352: p_old_unit1_value in number default hr_api.g_number,

348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
354: p_old_unit3_value in number default hr_api.g_number,
355: p_defer_flag in varchar2 default hr_api.g_varchar2,
356: p_propagation_method in varchar2 default hr_api.g_varchar2

Line 353: p_old_unit2_value in number default hr_api.g_number,

349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
354: p_old_unit3_value in number default hr_api.g_number,
355: p_defer_flag in varchar2 default hr_api.g_varchar2,
356: p_propagation_method in varchar2 default hr_api.g_varchar2
357: ) ;

Line 354: p_old_unit3_value in number default hr_api.g_number,

350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
354: p_old_unit3_value in number default hr_api.g_number,
355: p_defer_flag in varchar2 default hr_api.g_varchar2,
356: p_propagation_method in varchar2 default hr_api.g_varchar2
357: ) ;
358: procedure copy_budget_periods(p_budget_detail_id in number,

Line 355: p_defer_flag in varchar2 default hr_api.g_varchar2,

351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
354: p_old_unit3_value in number default hr_api.g_number,
355: p_defer_flag in varchar2 default hr_api.g_varchar2,
356: p_propagation_method in varchar2 default hr_api.g_varchar2
357: ) ;
358: procedure copy_budget_periods(p_budget_detail_id in number,
359: p_worksheet_detail_id in number,

Line 356: p_propagation_method in varchar2 default hr_api.g_varchar2

352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
354: p_old_unit3_value in number default hr_api.g_number,
355: p_defer_flag in varchar2 default hr_api.g_varchar2,
356: p_propagation_method in varchar2 default hr_api.g_varchar2
357: ) ;
358: procedure copy_budget_periods(p_budget_detail_id in number,
359: p_worksheet_detail_id in number,
360: p_copy_budget_periods in varchar2,