eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_WORKSHEET_DETAILS_API dependencies on HR_API

Line 102: when hr_api.cannot_find_prog_unit then

98: ,p_propagation_method => p_propagation_method
99: ,p_effective_date => trunc(p_effective_date)
100: );
101: exception
102: when hr_api.cannot_find_prog_unit then
103: hr_api.cannot_find_prog_unit_error
104: (
105: p_module_name => 'CREATE_WORKSHEET_DETAIL'
106: ,p_hook_type => 'BP'

Line 103: hr_api.cannot_find_prog_unit_error

99: ,p_effective_date => trunc(p_effective_date)
100: );
101: exception
102: when hr_api.cannot_find_prog_unit then
103: hr_api.cannot_find_prog_unit_error
104: (
105: p_module_name => 'CREATE_WORKSHEET_DETAIL'
106: ,p_hook_type => 'BP'
107: );

Line 187: when hr_api.cannot_find_prog_unit then

183: ,p_propagation_method => p_propagation_method
184: ,p_effective_date => trunc(p_effective_date)
185: );
186: exception
187: when hr_api.cannot_find_prog_unit then
188: hr_api.cannot_find_prog_unit_error
189: (p_module_name => 'CREATE_WORKSHEET_DETAIL'
190: ,p_hook_type => 'AP'
191: );

Line 188: hr_api.cannot_find_prog_unit_error

184: ,p_effective_date => trunc(p_effective_date)
185: );
186: exception
187: when hr_api.cannot_find_prog_unit then
188: hr_api.cannot_find_prog_unit_error
189: (p_module_name => 'CREATE_WORKSHEET_DETAIL'
190: ,p_hook_type => 'AP'
191: );
192: --

Line 202: raise hr_api.validate_enabled;

198: --
199: -- When in validation only mode raise the Validate_Enabled exception
200: --
201: if p_validate then
202: raise hr_api.validate_enabled;
203: end if;
204: --
205: -- Set all output arguments
206: --

Line 214: when hr_api.validate_enabled then

210: hr_utility.set_location(' Leaving:'||l_proc, 70);
211: --
212: exception
213: --
214: when hr_api.validate_enabled then
215: --
216: -- As the Validate_Enabled exception has been raised
217: -- we must rollback to the savepoint
218: --

Line 388: ,p_worksheet_id in number default hr_api.g_number

384: --
385: procedure update_WORKSHEET_DETAIL
386: (p_validate in boolean default false
387: ,p_worksheet_detail_id in number
388: ,p_worksheet_id in number default hr_api.g_number
389: ,p_organization_id in number default hr_api.g_number
390: ,p_job_id in number default hr_api.g_number
391: ,p_position_id in number default hr_api.g_number
392: ,p_grade_id in number default hr_api.g_number

Line 389: ,p_organization_id in number default hr_api.g_number

385: procedure update_WORKSHEET_DETAIL
386: (p_validate in boolean default false
387: ,p_worksheet_detail_id in number
388: ,p_worksheet_id in number default hr_api.g_number
389: ,p_organization_id in number default hr_api.g_number
390: ,p_job_id in number default hr_api.g_number
391: ,p_position_id in number default hr_api.g_number
392: ,p_grade_id in number default hr_api.g_number
393: ,p_position_transaction_id in number default hr_api.g_number

Line 390: ,p_job_id in number default hr_api.g_number

386: (p_validate in boolean default false
387: ,p_worksheet_detail_id in number
388: ,p_worksheet_id in number default hr_api.g_number
389: ,p_organization_id in number default hr_api.g_number
390: ,p_job_id in number default hr_api.g_number
391: ,p_position_id in number default hr_api.g_number
392: ,p_grade_id in number default hr_api.g_number
393: ,p_position_transaction_id in number default hr_api.g_number
394: ,p_budget_detail_id in number default hr_api.g_number

Line 391: ,p_position_id in number default hr_api.g_number

387: ,p_worksheet_detail_id in number
388: ,p_worksheet_id in number default hr_api.g_number
389: ,p_organization_id in number default hr_api.g_number
390: ,p_job_id in number default hr_api.g_number
391: ,p_position_id in number default hr_api.g_number
392: ,p_grade_id in number default hr_api.g_number
393: ,p_position_transaction_id in number default hr_api.g_number
394: ,p_budget_detail_id in number default hr_api.g_number
395: ,p_parent_worksheet_detail_id in number default hr_api.g_number

Line 392: ,p_grade_id in number default hr_api.g_number

388: ,p_worksheet_id in number default hr_api.g_number
389: ,p_organization_id in number default hr_api.g_number
390: ,p_job_id in number default hr_api.g_number
391: ,p_position_id in number default hr_api.g_number
392: ,p_grade_id in number default hr_api.g_number
393: ,p_position_transaction_id in number default hr_api.g_number
394: ,p_budget_detail_id in number default hr_api.g_number
395: ,p_parent_worksheet_detail_id in number default hr_api.g_number
396: ,p_user_id in number default hr_api.g_number

Line 393: ,p_position_transaction_id in number default hr_api.g_number

389: ,p_organization_id in number default hr_api.g_number
390: ,p_job_id in number default hr_api.g_number
391: ,p_position_id in number default hr_api.g_number
392: ,p_grade_id in number default hr_api.g_number
393: ,p_position_transaction_id in number default hr_api.g_number
394: ,p_budget_detail_id in number default hr_api.g_number
395: ,p_parent_worksheet_detail_id in number default hr_api.g_number
396: ,p_user_id in number default hr_api.g_number
397: ,p_action_cd in varchar2 default hr_api.g_varchar2

Line 394: ,p_budget_detail_id in number default hr_api.g_number

390: ,p_job_id in number default hr_api.g_number
391: ,p_position_id in number default hr_api.g_number
392: ,p_grade_id in number default hr_api.g_number
393: ,p_position_transaction_id in number default hr_api.g_number
394: ,p_budget_detail_id in number default hr_api.g_number
395: ,p_parent_worksheet_detail_id in number default hr_api.g_number
396: ,p_user_id in number default hr_api.g_number
397: ,p_action_cd in varchar2 default hr_api.g_varchar2
398: ,p_budget_unit1_percent in number default hr_api.g_number

Line 395: ,p_parent_worksheet_detail_id in number default hr_api.g_number

391: ,p_position_id in number default hr_api.g_number
392: ,p_grade_id in number default hr_api.g_number
393: ,p_position_transaction_id in number default hr_api.g_number
394: ,p_budget_detail_id in number default hr_api.g_number
395: ,p_parent_worksheet_detail_id in number default hr_api.g_number
396: ,p_user_id in number default hr_api.g_number
397: ,p_action_cd in varchar2 default hr_api.g_varchar2
398: ,p_budget_unit1_percent in number default hr_api.g_number
399: ,p_budget_unit1_value in number default hr_api.g_number

Line 396: ,p_user_id in number default hr_api.g_number

392: ,p_grade_id in number default hr_api.g_number
393: ,p_position_transaction_id in number default hr_api.g_number
394: ,p_budget_detail_id in number default hr_api.g_number
395: ,p_parent_worksheet_detail_id in number default hr_api.g_number
396: ,p_user_id in number default hr_api.g_number
397: ,p_action_cd in varchar2 default hr_api.g_varchar2
398: ,p_budget_unit1_percent in number default hr_api.g_number
399: ,p_budget_unit1_value in number default hr_api.g_number
400: ,p_budget_unit2_percent in number default hr_api.g_number

Line 397: ,p_action_cd in varchar2 default hr_api.g_varchar2

393: ,p_position_transaction_id in number default hr_api.g_number
394: ,p_budget_detail_id in number default hr_api.g_number
395: ,p_parent_worksheet_detail_id in number default hr_api.g_number
396: ,p_user_id in number default hr_api.g_number
397: ,p_action_cd in varchar2 default hr_api.g_varchar2
398: ,p_budget_unit1_percent in number default hr_api.g_number
399: ,p_budget_unit1_value in number default hr_api.g_number
400: ,p_budget_unit2_percent in number default hr_api.g_number
401: ,p_budget_unit2_value in number default hr_api.g_number

Line 398: ,p_budget_unit1_percent in number default hr_api.g_number

394: ,p_budget_detail_id in number default hr_api.g_number
395: ,p_parent_worksheet_detail_id in number default hr_api.g_number
396: ,p_user_id in number default hr_api.g_number
397: ,p_action_cd in varchar2 default hr_api.g_varchar2
398: ,p_budget_unit1_percent in number default hr_api.g_number
399: ,p_budget_unit1_value in number default hr_api.g_number
400: ,p_budget_unit2_percent in number default hr_api.g_number
401: ,p_budget_unit2_value in number default hr_api.g_number
402: ,p_budget_unit3_percent in number default hr_api.g_number

Line 399: ,p_budget_unit1_value in number default hr_api.g_number

395: ,p_parent_worksheet_detail_id in number default hr_api.g_number
396: ,p_user_id in number default hr_api.g_number
397: ,p_action_cd in varchar2 default hr_api.g_varchar2
398: ,p_budget_unit1_percent in number default hr_api.g_number
399: ,p_budget_unit1_value in number default hr_api.g_number
400: ,p_budget_unit2_percent in number default hr_api.g_number
401: ,p_budget_unit2_value in number default hr_api.g_number
402: ,p_budget_unit3_percent in number default hr_api.g_number
403: ,p_budget_unit3_value in number default hr_api.g_number

Line 400: ,p_budget_unit2_percent in number default hr_api.g_number

396: ,p_user_id in number default hr_api.g_number
397: ,p_action_cd in varchar2 default hr_api.g_varchar2
398: ,p_budget_unit1_percent in number default hr_api.g_number
399: ,p_budget_unit1_value in number default hr_api.g_number
400: ,p_budget_unit2_percent in number default hr_api.g_number
401: ,p_budget_unit2_value in number default hr_api.g_number
402: ,p_budget_unit3_percent in number default hr_api.g_number
403: ,p_budget_unit3_value in number default hr_api.g_number
404: ,p_object_version_number in out nocopy number

Line 401: ,p_budget_unit2_value in number default hr_api.g_number

397: ,p_action_cd in varchar2 default hr_api.g_varchar2
398: ,p_budget_unit1_percent in number default hr_api.g_number
399: ,p_budget_unit1_value in number default hr_api.g_number
400: ,p_budget_unit2_percent in number default hr_api.g_number
401: ,p_budget_unit2_value in number default hr_api.g_number
402: ,p_budget_unit3_percent in number default hr_api.g_number
403: ,p_budget_unit3_value in number default hr_api.g_number
404: ,p_object_version_number in out nocopy number
405: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

Line 402: ,p_budget_unit3_percent in number default hr_api.g_number

398: ,p_budget_unit1_percent in number default hr_api.g_number
399: ,p_budget_unit1_value in number default hr_api.g_number
400: ,p_budget_unit2_percent in number default hr_api.g_number
401: ,p_budget_unit2_value in number default hr_api.g_number
402: ,p_budget_unit3_percent in number default hr_api.g_number
403: ,p_budget_unit3_value in number default hr_api.g_number
404: ,p_object_version_number in out nocopy number
405: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
406: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

Line 403: ,p_budget_unit3_value in number default hr_api.g_number

399: ,p_budget_unit1_value in number default hr_api.g_number
400: ,p_budget_unit2_percent in number default hr_api.g_number
401: ,p_budget_unit2_value in number default hr_api.g_number
402: ,p_budget_unit3_percent in number default hr_api.g_number
403: ,p_budget_unit3_value in number default hr_api.g_number
404: ,p_object_version_number in out nocopy number
405: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
406: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
407: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

Line 405: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

401: ,p_budget_unit2_value in number default hr_api.g_number
402: ,p_budget_unit3_percent in number default hr_api.g_number
403: ,p_budget_unit3_value in number default hr_api.g_number
404: ,p_object_version_number in out nocopy number
405: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
406: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
407: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
408: ,p_status in varchar2 default hr_api.g_varchar2
409: ,p_budget_unit1_available in number default hr_api.g_number

Line 406: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

402: ,p_budget_unit3_percent in number default hr_api.g_number
403: ,p_budget_unit3_value in number default hr_api.g_number
404: ,p_object_version_number in out nocopy number
405: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
406: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
407: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
408: ,p_status in varchar2 default hr_api.g_varchar2
409: ,p_budget_unit1_available in number default hr_api.g_number
410: ,p_budget_unit2_available in number default hr_api.g_number

Line 407: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

403: ,p_budget_unit3_value in number default hr_api.g_number
404: ,p_object_version_number in out nocopy number
405: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
406: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
407: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
408: ,p_status in varchar2 default hr_api.g_varchar2
409: ,p_budget_unit1_available in number default hr_api.g_number
410: ,p_budget_unit2_available in number default hr_api.g_number
411: ,p_budget_unit3_available in number default hr_api.g_number

Line 408: ,p_status in varchar2 default hr_api.g_varchar2

404: ,p_object_version_number in out nocopy number
405: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
406: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
407: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
408: ,p_status in varchar2 default hr_api.g_varchar2
409: ,p_budget_unit1_available in number default hr_api.g_number
410: ,p_budget_unit2_available in number default hr_api.g_number
411: ,p_budget_unit3_available in number default hr_api.g_number
412: ,p_old_unit1_value in number default hr_api.g_number

Line 409: ,p_budget_unit1_available in number default hr_api.g_number

405: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
406: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
407: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
408: ,p_status in varchar2 default hr_api.g_varchar2
409: ,p_budget_unit1_available in number default hr_api.g_number
410: ,p_budget_unit2_available in number default hr_api.g_number
411: ,p_budget_unit3_available in number default hr_api.g_number
412: ,p_old_unit1_value in number default hr_api.g_number
413: ,p_old_unit2_value in number default hr_api.g_number

Line 410: ,p_budget_unit2_available in number default hr_api.g_number

406: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
407: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
408: ,p_status in varchar2 default hr_api.g_varchar2
409: ,p_budget_unit1_available in number default hr_api.g_number
410: ,p_budget_unit2_available in number default hr_api.g_number
411: ,p_budget_unit3_available in number default hr_api.g_number
412: ,p_old_unit1_value in number default hr_api.g_number
413: ,p_old_unit2_value in number default hr_api.g_number
414: ,p_old_unit3_value in number default hr_api.g_number

Line 411: ,p_budget_unit3_available in number default hr_api.g_number

407: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
408: ,p_status in varchar2 default hr_api.g_varchar2
409: ,p_budget_unit1_available in number default hr_api.g_number
410: ,p_budget_unit2_available in number default hr_api.g_number
411: ,p_budget_unit3_available in number default hr_api.g_number
412: ,p_old_unit1_value in number default hr_api.g_number
413: ,p_old_unit2_value in number default hr_api.g_number
414: ,p_old_unit3_value in number default hr_api.g_number
415: ,p_defer_flag in varchar2 default hr_api.g_varchar2

Line 412: ,p_old_unit1_value in number default hr_api.g_number

408: ,p_status in varchar2 default hr_api.g_varchar2
409: ,p_budget_unit1_available in number default hr_api.g_number
410: ,p_budget_unit2_available in number default hr_api.g_number
411: ,p_budget_unit3_available in number default hr_api.g_number
412: ,p_old_unit1_value in number default hr_api.g_number
413: ,p_old_unit2_value in number default hr_api.g_number
414: ,p_old_unit3_value in number default hr_api.g_number
415: ,p_defer_flag in varchar2 default hr_api.g_varchar2
416: ,p_propagation_method in varchar2 default hr_api.g_varchar2

Line 413: ,p_old_unit2_value in number default hr_api.g_number

409: ,p_budget_unit1_available in number default hr_api.g_number
410: ,p_budget_unit2_available in number default hr_api.g_number
411: ,p_budget_unit3_available in number default hr_api.g_number
412: ,p_old_unit1_value in number default hr_api.g_number
413: ,p_old_unit2_value in number default hr_api.g_number
414: ,p_old_unit3_value in number default hr_api.g_number
415: ,p_defer_flag in varchar2 default hr_api.g_varchar2
416: ,p_propagation_method in varchar2 default hr_api.g_varchar2
417: ,p_effective_date in date

Line 414: ,p_old_unit3_value in number default hr_api.g_number

410: ,p_budget_unit2_available in number default hr_api.g_number
411: ,p_budget_unit3_available in number default hr_api.g_number
412: ,p_old_unit1_value in number default hr_api.g_number
413: ,p_old_unit2_value in number default hr_api.g_number
414: ,p_old_unit3_value in number default hr_api.g_number
415: ,p_defer_flag in varchar2 default hr_api.g_varchar2
416: ,p_propagation_method in varchar2 default hr_api.g_varchar2
417: ,p_effective_date in date
418: ) is

Line 415: ,p_defer_flag in varchar2 default hr_api.g_varchar2

411: ,p_budget_unit3_available in number default hr_api.g_number
412: ,p_old_unit1_value in number default hr_api.g_number
413: ,p_old_unit2_value in number default hr_api.g_number
414: ,p_old_unit3_value in number default hr_api.g_number
415: ,p_defer_flag in varchar2 default hr_api.g_varchar2
416: ,p_propagation_method in varchar2 default hr_api.g_varchar2
417: ,p_effective_date in date
418: ) is
419: --

Line 416: ,p_propagation_method in varchar2 default hr_api.g_varchar2

412: ,p_old_unit1_value in number default hr_api.g_number
413: ,p_old_unit2_value in number default hr_api.g_number
414: ,p_old_unit3_value in number default hr_api.g_number
415: ,p_defer_flag in varchar2 default hr_api.g_varchar2
416: ,p_propagation_method in varchar2 default hr_api.g_varchar2
417: ,p_effective_date in date
418: ) is
419: --
420: -- Declare cursors and local variables

Line 478: when hr_api.cannot_find_prog_unit then

474: ,p_propagation_method => p_propagation_method
475: ,p_effective_date => trunc(p_effective_date)
476: );
477: exception
478: when hr_api.cannot_find_prog_unit then
479: hr_api.cannot_find_prog_unit_error
480: (p_module_name => 'UPDATE_WORKSHEET_DETAIL'
481: ,p_hook_type => 'BP'
482: );

Line 479: hr_api.cannot_find_prog_unit_error

475: ,p_effective_date => trunc(p_effective_date)
476: );
477: exception
478: when hr_api.cannot_find_prog_unit then
479: hr_api.cannot_find_prog_unit_error
480: (p_module_name => 'UPDATE_WORKSHEET_DETAIL'
481: ,p_hook_type => 'BP'
482: );
483: --

Line 562: when hr_api.cannot_find_prog_unit then

558: ,p_propagation_method => p_propagation_method
559: ,p_effective_date => trunc(p_effective_date)
560: );
561: exception
562: when hr_api.cannot_find_prog_unit then
563: hr_api.cannot_find_prog_unit_error
564: (p_module_name => 'UPDATE_WORKSHEET_DETAIL'
565: ,p_hook_type => 'AP'
566: );

Line 563: hr_api.cannot_find_prog_unit_error

559: ,p_effective_date => trunc(p_effective_date)
560: );
561: exception
562: when hr_api.cannot_find_prog_unit then
563: hr_api.cannot_find_prog_unit_error
564: (p_module_name => 'UPDATE_WORKSHEET_DETAIL'
565: ,p_hook_type => 'AP'
566: );
567: --

Line 577: raise hr_api.validate_enabled;

573: --
574: -- When in validation only mode raise the Validate_Enabled exception
575: --
576: if p_validate then
577: raise hr_api.validate_enabled;
578: end if;
579: --
580: -- Set all output arguments
581: --

Line 588: when hr_api.validate_enabled then

584: hr_utility.set_location(' Leaving:'||l_proc, 70);
585: --
586: exception
587: --
588: when hr_api.validate_enabled then
589: --
590: -- As the Validate_Enabled exception has been raised
591: -- we must rollback to the savepoint
592: --

Line 652: when hr_api.cannot_find_prog_unit then

648: ,p_object_version_number => p_object_version_number
649: ,p_effective_date => trunc(p_effective_date)
650: );
651: exception
652: when hr_api.cannot_find_prog_unit then
653: hr_api.cannot_find_prog_unit_error
654: (p_module_name => 'DELETE_WORKSHEET_DETAIL'
655: ,p_hook_type => 'BP'
656: );

Line 653: hr_api.cannot_find_prog_unit_error

649: ,p_effective_date => trunc(p_effective_date)
650: );
651: exception
652: when hr_api.cannot_find_prog_unit then
653: hr_api.cannot_find_prog_unit_error
654: (p_module_name => 'DELETE_WORKSHEET_DETAIL'
655: ,p_hook_type => 'BP'
656: );
657: --

Line 680: when hr_api.cannot_find_prog_unit then

676: ,p_object_version_number => l_object_version_number
677: ,p_effective_date => trunc(p_effective_date)
678: );
679: exception
680: when hr_api.cannot_find_prog_unit then
681: hr_api.cannot_find_prog_unit_error
682: (p_module_name => 'DELETE_WORKSHEET_DETAIL'
683: ,p_hook_type => 'AP'
684: );

Line 681: hr_api.cannot_find_prog_unit_error

677: ,p_effective_date => trunc(p_effective_date)
678: );
679: exception
680: when hr_api.cannot_find_prog_unit then
681: hr_api.cannot_find_prog_unit_error
682: (p_module_name => 'DELETE_WORKSHEET_DETAIL'
683: ,p_hook_type => 'AP'
684: );
685: --

Line 695: raise hr_api.validate_enabled;

691: --
692: -- When in validation only mode raise the Validate_Enabled exception
693: --
694: if p_validate then
695: raise hr_api.validate_enabled;
696: end if;
697: --
698: hr_utility.set_location(' Leaving:'||l_proc, 70);
699: --

Line 702: when hr_api.validate_enabled then

698: hr_utility.set_location(' Leaving:'||l_proc, 70);
699: --
700: exception
701: --
702: when hr_api.validate_enabled then
703: --
704: -- As the Validate_Enabled exception has been raised
705: -- we must rollback to the savepoint
706: --