DBA Data[Home] [Help]

APPS.PAY_TIME_DEFINITION_API dependencies on HR_API

Line 137: hr_api.return_legislation_code(p_business_group_id) );

133: into l_leg_start_date
134: from pay_legislation_rules plr
135: where plr.rule_type = 'L'
136: and plr.legislation_code = nvl(p_legislation_code,
137: hr_api.return_legislation_code(p_business_group_id) );
138: exception
139: when NO_DATA_FOUND then
140: l_leg_start_date := to_date('01/01/' ||
141: to_char(p_first_period_end_date, 'YYYY'), 'DD/MM/YYYY');

Line 481: when hr_api.cannot_find_prog_unit then

477: ,p_creator_id => p_creator_id
478: ,p_creator_type => p_creator_type
479: );
480: exception
481: when hr_api.cannot_find_prog_unit then
482: hr_api.cannot_find_prog_unit_error
483: (p_module_name => 'create_time_definition'
484: ,p_hook_type => 'BP'
485: );

Line 482: hr_api.cannot_find_prog_unit_error

478: ,p_creator_type => p_creator_type
479: );
480: exception
481: when hr_api.cannot_find_prog_unit then
482: hr_api.cannot_find_prog_unit_error
483: (p_module_name => 'create_time_definition'
484: ,p_hook_type => 'BP'
485: );
486: end;

Line 538: when hr_api.cannot_find_prog_unit then

534: ,p_time_definition_id => l_time_definition_id
535: ,p_object_version_number => l_object_version_number
536: );
537: exception
538: when hr_api.cannot_find_prog_unit then
539: hr_api.cannot_find_prog_unit_error
540: (p_module_name => 'create_time_definition'
541: ,p_hook_type => 'AP'
542: );

Line 539: hr_api.cannot_find_prog_unit_error

535: ,p_object_version_number => l_object_version_number
536: );
537: exception
538: when hr_api.cannot_find_prog_unit then
539: hr_api.cannot_find_prog_unit_error
540: (p_module_name => 'create_time_definition'
541: ,p_hook_type => 'AP'
542: );
543: end;

Line 548: raise hr_api.validate_enabled;

544: --
545: -- When in validation only mode raise the Validate_Enabled exception
546: --
547: if p_validate then
548: raise hr_api.validate_enabled;
549: end if;
550: --
551: -- Set all IN OUT and OUT parameters with out values
552: --

Line 559: when hr_api.validate_enabled then

555: --
556: hr_utility.set_location(' Leaving:'||l_proc, 70);
557:
558: exception
559: when hr_api.validate_enabled then
560: --
561: -- As the Validate_Enabled exception has been raised
562: -- we must rollback to the savepoint
563: --

Line 595: ,p_definition_name in varchar2 default hr_api.g_varchar2

591: procedure update_time_definition
592: (p_validate in boolean default false
593: ,p_effective_date in date
594: ,p_time_definition_id in number
595: ,p_definition_name in varchar2 default hr_api.g_varchar2
596: ,p_period_type in varchar2 default hr_api.g_varchar2
597: ,p_period_unit in varchar2 default hr_api.g_varchar2
598: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
599: ,p_dynamic_code in varchar2 default hr_api.g_varchar2

Line 596: ,p_period_type in varchar2 default hr_api.g_varchar2

592: (p_validate in boolean default false
593: ,p_effective_date in date
594: ,p_time_definition_id in number
595: ,p_definition_name in varchar2 default hr_api.g_varchar2
596: ,p_period_type in varchar2 default hr_api.g_varchar2
597: ,p_period_unit in varchar2 default hr_api.g_varchar2
598: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
599: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
600: ,p_number_of_years in number default hr_api.g_number

Line 597: ,p_period_unit in varchar2 default hr_api.g_varchar2

593: ,p_effective_date in date
594: ,p_time_definition_id in number
595: ,p_definition_name in varchar2 default hr_api.g_varchar2
596: ,p_period_type in varchar2 default hr_api.g_varchar2
597: ,p_period_unit in varchar2 default hr_api.g_varchar2
598: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
599: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
600: ,p_number_of_years in number default hr_api.g_number
601: ,p_start_date in date default hr_api.g_date

Line 598: ,p_day_adjustment in varchar2 default hr_api.g_varchar2

594: ,p_time_definition_id in number
595: ,p_definition_name in varchar2 default hr_api.g_varchar2
596: ,p_period_type in varchar2 default hr_api.g_varchar2
597: ,p_period_unit in varchar2 default hr_api.g_varchar2
598: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
599: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
600: ,p_number_of_years in number default hr_api.g_number
601: ,p_start_date in date default hr_api.g_date
602: ,p_period_time_definition_id in number default hr_api.g_number

Line 599: ,p_dynamic_code in varchar2 default hr_api.g_varchar2

595: ,p_definition_name in varchar2 default hr_api.g_varchar2
596: ,p_period_type in varchar2 default hr_api.g_varchar2
597: ,p_period_unit in varchar2 default hr_api.g_varchar2
598: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
599: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
600: ,p_number_of_years in number default hr_api.g_number
601: ,p_start_date in date default hr_api.g_date
602: ,p_period_time_definition_id in number default hr_api.g_number
603: ,p_creator_id in number default hr_api.g_number

Line 600: ,p_number_of_years in number default hr_api.g_number

596: ,p_period_type in varchar2 default hr_api.g_varchar2
597: ,p_period_unit in varchar2 default hr_api.g_varchar2
598: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
599: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
600: ,p_number_of_years in number default hr_api.g_number
601: ,p_start_date in date default hr_api.g_date
602: ,p_period_time_definition_id in number default hr_api.g_number
603: ,p_creator_id in number default hr_api.g_number
604: ,p_creator_type in varchar2 default hr_api.g_varchar2

Line 601: ,p_start_date in date default hr_api.g_date

597: ,p_period_unit in varchar2 default hr_api.g_varchar2
598: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
599: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
600: ,p_number_of_years in number default hr_api.g_number
601: ,p_start_date in date default hr_api.g_date
602: ,p_period_time_definition_id in number default hr_api.g_number
603: ,p_creator_id in number default hr_api.g_number
604: ,p_creator_type in varchar2 default hr_api.g_varchar2
605: ,p_object_version_number in out nocopy number

Line 602: ,p_period_time_definition_id in number default hr_api.g_number

598: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
599: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
600: ,p_number_of_years in number default hr_api.g_number
601: ,p_start_date in date default hr_api.g_date
602: ,p_period_time_definition_id in number default hr_api.g_number
603: ,p_creator_id in number default hr_api.g_number
604: ,p_creator_type in varchar2 default hr_api.g_varchar2
605: ,p_object_version_number in out nocopy number
606: ) is

Line 603: ,p_creator_id in number default hr_api.g_number

599: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
600: ,p_number_of_years in number default hr_api.g_number
601: ,p_start_date in date default hr_api.g_date
602: ,p_period_time_definition_id in number default hr_api.g_number
603: ,p_creator_id in number default hr_api.g_number
604: ,p_creator_type in varchar2 default hr_api.g_varchar2
605: ,p_object_version_number in out nocopy number
606: ) is
607: --

Line 604: ,p_creator_type in varchar2 default hr_api.g_varchar2

600: ,p_number_of_years in number default hr_api.g_number
601: ,p_start_date in date default hr_api.g_date
602: ,p_period_time_definition_id in number default hr_api.g_number
603: ,p_creator_id in number default hr_api.g_number
604: ,p_creator_type in varchar2 default hr_api.g_varchar2
605: ,p_object_version_number in out nocopy number
606: ) is
607: --
608: -- Declare cursors and local variables

Line 660: when hr_api.cannot_find_prog_unit then

656: ,p_creator_type => p_creator_type
657: ,p_object_version_number => l_object_version_number
658: );
659: exception
660: when hr_api.cannot_find_prog_unit then
661: hr_api.cannot_find_prog_unit_error
662: (p_module_name => 'update_time_definition'
663: ,p_hook_type => 'BP'
664: );

Line 661: hr_api.cannot_find_prog_unit_error

657: ,p_object_version_number => l_object_version_number
658: );
659: exception
660: when hr_api.cannot_find_prog_unit then
661: hr_api.cannot_find_prog_unit_error
662: (p_module_name => 'update_time_definition'
663: ,p_hook_type => 'BP'
664: );
665: end;

Line 732: when hr_api.cannot_find_prog_unit then

728: ,p_creator_type => p_creator_type
729: ,p_object_version_number => l_object_version_number
730: );
731: exception
732: when hr_api.cannot_find_prog_unit then
733: hr_api.cannot_find_prog_unit_error
734: (p_module_name => 'update_time_definition'
735: ,p_hook_type => 'AP'
736: );

Line 733: hr_api.cannot_find_prog_unit_error

729: ,p_object_version_number => l_object_version_number
730: );
731: exception
732: when hr_api.cannot_find_prog_unit then
733: hr_api.cannot_find_prog_unit_error
734: (p_module_name => 'update_time_definition'
735: ,p_hook_type => 'AP'
736: );
737: end;

Line 742: raise hr_api.validate_enabled;

738: --
739: -- When in validation only mode raise the Validate_Enabled exception
740: --
741: if p_validate then
742: raise hr_api.validate_enabled;
743: end if;
744: --
745: -- Set all IN OUT and OUT parameters with out values
746: --

Line 752: when hr_api.validate_enabled then

748: --
749: hr_utility.set_location(' Leaving:'||l_proc, 70);
750:
751: exception
752: when hr_api.validate_enabled then
753: --
754: -- As the Validate_Enabled exception has been raised
755: -- we must rollback to the savepoint
756: --

Line 818: when hr_api.cannot_find_prog_unit then

814: ,p_time_definition_id => p_time_definition_id
815: ,p_object_version_number => p_object_version_number
816: );
817: exception
818: when hr_api.cannot_find_prog_unit then
819: hr_api.cannot_find_prog_unit_error
820: (p_module_name => 'delete_time_definition'
821: ,p_hook_type => 'BP'
822: );

Line 819: hr_api.cannot_find_prog_unit_error

815: ,p_object_version_number => p_object_version_number
816: );
817: exception
818: when hr_api.cannot_find_prog_unit then
819: hr_api.cannot_find_prog_unit_error
820: (p_module_name => 'delete_time_definition'
821: ,p_hook_type => 'BP'
822: );
823: end;

Line 850: when hr_api.cannot_find_prog_unit then

846: ,p_time_definition_id => p_time_definition_id
847: ,p_object_version_number => p_object_version_number
848: );
849: exception
850: when hr_api.cannot_find_prog_unit then
851: hr_api.cannot_find_prog_unit_error
852: (p_module_name => 'delete_time_definition'
853: ,p_hook_type => 'AP'
854: );

Line 851: hr_api.cannot_find_prog_unit_error

847: ,p_object_version_number => p_object_version_number
848: );
849: exception
850: when hr_api.cannot_find_prog_unit then
851: hr_api.cannot_find_prog_unit_error
852: (p_module_name => 'delete_time_definition'
853: ,p_hook_type => 'AP'
854: );
855: end;

Line 860: raise hr_api.validate_enabled;

856: --
857: -- When in validation only mode raise the Validate_Enabled exception
858: --
859: if p_validate then
860: raise hr_api.validate_enabled;
861: end if;
862: --
863: hr_utility.set_location(' Leaving:'||l_proc, 70);
864: exception

Line 865: when hr_api.validate_enabled then

861: end if;
862: --
863: hr_utility.set_location(' Leaving:'||l_proc, 70);
864: exception
865: when hr_api.validate_enabled then
866: --
867: -- As the Validate_Enabled exception has been raised
868: -- we must rollback to the savepoint
869: --