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 497: when hr_api.cannot_find_prog_unit then

493: ,p_creator_id => p_creator_id
494: ,p_creator_type => p_creator_type
495: );
496: exception
497: when hr_api.cannot_find_prog_unit then
498: hr_api.cannot_find_prog_unit_error
499: (p_module_name => 'create_time_definition'
500: ,p_hook_type => 'BP'
501: );

Line 498: hr_api.cannot_find_prog_unit_error

494: ,p_creator_type => p_creator_type
495: );
496: exception
497: when hr_api.cannot_find_prog_unit then
498: hr_api.cannot_find_prog_unit_error
499: (p_module_name => 'create_time_definition'
500: ,p_hook_type => 'BP'
501: );
502: end;

Line 554: when hr_api.cannot_find_prog_unit then

550: ,p_time_definition_id => l_time_definition_id
551: ,p_object_version_number => l_object_version_number
552: );
553: exception
554: when hr_api.cannot_find_prog_unit then
555: hr_api.cannot_find_prog_unit_error
556: (p_module_name => 'create_time_definition'
557: ,p_hook_type => 'AP'
558: );

Line 555: hr_api.cannot_find_prog_unit_error

551: ,p_object_version_number => l_object_version_number
552: );
553: exception
554: when hr_api.cannot_find_prog_unit then
555: hr_api.cannot_find_prog_unit_error
556: (p_module_name => 'create_time_definition'
557: ,p_hook_type => 'AP'
558: );
559: end;

Line 564: raise hr_api.validate_enabled;

560: --
561: -- When in validation only mode raise the Validate_Enabled exception
562: --
563: if p_validate then
564: raise hr_api.validate_enabled;
565: end if;
566: --
567: -- Set all IN OUT and OUT parameters with out values
568: --

Line 575: when hr_api.validate_enabled then

571: --
572: hr_utility.set_location(' Leaving:'||l_proc, 70);
573:
574: exception
575: when hr_api.validate_enabled then
576: --
577: -- As the Validate_Enabled exception has been raised
578: -- we must rollback to the savepoint
579: --

Line 611: ,p_definition_name in varchar2 default hr_api.g_varchar2

607: procedure update_time_definition
608: (p_validate in boolean default false
609: ,p_effective_date in date
610: ,p_time_definition_id in number
611: ,p_definition_name in varchar2 default hr_api.g_varchar2
612: ,p_period_type in varchar2 default hr_api.g_varchar2
613: ,p_period_unit in varchar2 default hr_api.g_varchar2
614: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
615: ,p_dynamic_code in varchar2 default hr_api.g_varchar2

Line 612: ,p_period_type in varchar2 default hr_api.g_varchar2

608: (p_validate in boolean default false
609: ,p_effective_date in date
610: ,p_time_definition_id in number
611: ,p_definition_name in varchar2 default hr_api.g_varchar2
612: ,p_period_type in varchar2 default hr_api.g_varchar2
613: ,p_period_unit in varchar2 default hr_api.g_varchar2
614: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
615: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
616: ,p_number_of_years in number default hr_api.g_number

Line 613: ,p_period_unit in varchar2 default hr_api.g_varchar2

609: ,p_effective_date in date
610: ,p_time_definition_id in number
611: ,p_definition_name in varchar2 default hr_api.g_varchar2
612: ,p_period_type in varchar2 default hr_api.g_varchar2
613: ,p_period_unit in varchar2 default hr_api.g_varchar2
614: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
615: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
616: ,p_number_of_years in number default hr_api.g_number
617: ,p_start_date in date default hr_api.g_date

Line 614: ,p_day_adjustment in varchar2 default hr_api.g_varchar2

610: ,p_time_definition_id in number
611: ,p_definition_name in varchar2 default hr_api.g_varchar2
612: ,p_period_type in varchar2 default hr_api.g_varchar2
613: ,p_period_unit in varchar2 default hr_api.g_varchar2
614: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
615: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
616: ,p_number_of_years in number default hr_api.g_number
617: ,p_start_date in date default hr_api.g_date
618: ,p_period_time_definition_id in number default hr_api.g_number

Line 615: ,p_dynamic_code in varchar2 default hr_api.g_varchar2

611: ,p_definition_name in varchar2 default hr_api.g_varchar2
612: ,p_period_type in varchar2 default hr_api.g_varchar2
613: ,p_period_unit in varchar2 default hr_api.g_varchar2
614: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
615: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
616: ,p_number_of_years in number default hr_api.g_number
617: ,p_start_date in date default hr_api.g_date
618: ,p_period_time_definition_id in number default hr_api.g_number
619: ,p_creator_id in number default hr_api.g_number

Line 616: ,p_number_of_years in number default hr_api.g_number

612: ,p_period_type in varchar2 default hr_api.g_varchar2
613: ,p_period_unit in varchar2 default hr_api.g_varchar2
614: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
615: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
616: ,p_number_of_years in number default hr_api.g_number
617: ,p_start_date in date default hr_api.g_date
618: ,p_period_time_definition_id in number default hr_api.g_number
619: ,p_creator_id in number default hr_api.g_number
620: ,p_creator_type in varchar2 default hr_api.g_varchar2

Line 617: ,p_start_date in date default hr_api.g_date

613: ,p_period_unit in varchar2 default hr_api.g_varchar2
614: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
615: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
616: ,p_number_of_years in number default hr_api.g_number
617: ,p_start_date in date default hr_api.g_date
618: ,p_period_time_definition_id in number default hr_api.g_number
619: ,p_creator_id in number default hr_api.g_number
620: ,p_creator_type in varchar2 default hr_api.g_varchar2
621: ,p_object_version_number in out nocopy number

Line 618: ,p_period_time_definition_id in number default hr_api.g_number

614: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
615: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
616: ,p_number_of_years in number default hr_api.g_number
617: ,p_start_date in date default hr_api.g_date
618: ,p_period_time_definition_id in number default hr_api.g_number
619: ,p_creator_id in number default hr_api.g_number
620: ,p_creator_type in varchar2 default hr_api.g_varchar2
621: ,p_object_version_number in out nocopy number
622: ) is

Line 619: ,p_creator_id in number default hr_api.g_number

615: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
616: ,p_number_of_years in number default hr_api.g_number
617: ,p_start_date in date default hr_api.g_date
618: ,p_period_time_definition_id in number default hr_api.g_number
619: ,p_creator_id in number default hr_api.g_number
620: ,p_creator_type in varchar2 default hr_api.g_varchar2
621: ,p_object_version_number in out nocopy number
622: ) is
623: --

Line 620: ,p_creator_type in varchar2 default hr_api.g_varchar2

616: ,p_number_of_years in number default hr_api.g_number
617: ,p_start_date in date default hr_api.g_date
618: ,p_period_time_definition_id in number default hr_api.g_number
619: ,p_creator_id in number default hr_api.g_number
620: ,p_creator_type in varchar2 default hr_api.g_varchar2
621: ,p_object_version_number in out nocopy number
622: ) is
623: --
624: -- Declare cursors and local variables

Line 676: when hr_api.cannot_find_prog_unit then

672: ,p_creator_type => p_creator_type
673: ,p_object_version_number => l_object_version_number
674: );
675: exception
676: when hr_api.cannot_find_prog_unit then
677: hr_api.cannot_find_prog_unit_error
678: (p_module_name => 'update_time_definition'
679: ,p_hook_type => 'BP'
680: );

Line 677: hr_api.cannot_find_prog_unit_error

673: ,p_object_version_number => l_object_version_number
674: );
675: exception
676: when hr_api.cannot_find_prog_unit then
677: hr_api.cannot_find_prog_unit_error
678: (p_module_name => 'update_time_definition'
679: ,p_hook_type => 'BP'
680: );
681: end;

Line 748: when hr_api.cannot_find_prog_unit then

744: ,p_creator_type => p_creator_type
745: ,p_object_version_number => l_object_version_number
746: );
747: exception
748: when hr_api.cannot_find_prog_unit then
749: hr_api.cannot_find_prog_unit_error
750: (p_module_name => 'update_time_definition'
751: ,p_hook_type => 'AP'
752: );

Line 749: hr_api.cannot_find_prog_unit_error

745: ,p_object_version_number => l_object_version_number
746: );
747: exception
748: when hr_api.cannot_find_prog_unit then
749: hr_api.cannot_find_prog_unit_error
750: (p_module_name => 'update_time_definition'
751: ,p_hook_type => 'AP'
752: );
753: end;

Line 758: raise hr_api.validate_enabled;

754: --
755: -- When in validation only mode raise the Validate_Enabled exception
756: --
757: if p_validate then
758: raise hr_api.validate_enabled;
759: end if;
760: --
761: -- Set all IN OUT and OUT parameters with out values
762: --

Line 768: when hr_api.validate_enabled then

764: --
765: hr_utility.set_location(' Leaving:'||l_proc, 70);
766:
767: exception
768: when hr_api.validate_enabled then
769: --
770: -- As the Validate_Enabled exception has been raised
771: -- we must rollback to the savepoint
772: --

Line 834: when hr_api.cannot_find_prog_unit then

830: ,p_time_definition_id => p_time_definition_id
831: ,p_object_version_number => p_object_version_number
832: );
833: exception
834: when hr_api.cannot_find_prog_unit then
835: hr_api.cannot_find_prog_unit_error
836: (p_module_name => 'delete_time_definition'
837: ,p_hook_type => 'BP'
838: );

Line 835: hr_api.cannot_find_prog_unit_error

831: ,p_object_version_number => p_object_version_number
832: );
833: exception
834: when hr_api.cannot_find_prog_unit then
835: hr_api.cannot_find_prog_unit_error
836: (p_module_name => 'delete_time_definition'
837: ,p_hook_type => 'BP'
838: );
839: end;

Line 866: when hr_api.cannot_find_prog_unit then

862: ,p_time_definition_id => p_time_definition_id
863: ,p_object_version_number => p_object_version_number
864: );
865: exception
866: when hr_api.cannot_find_prog_unit then
867: hr_api.cannot_find_prog_unit_error
868: (p_module_name => 'delete_time_definition'
869: ,p_hook_type => 'AP'
870: );

Line 867: hr_api.cannot_find_prog_unit_error

863: ,p_object_version_number => p_object_version_number
864: );
865: exception
866: when hr_api.cannot_find_prog_unit then
867: hr_api.cannot_find_prog_unit_error
868: (p_module_name => 'delete_time_definition'
869: ,p_hook_type => 'AP'
870: );
871: end;

Line 876: raise hr_api.validate_enabled;

872: --
873: -- When in validation only mode raise the Validate_Enabled exception
874: --
875: if p_validate then
876: raise hr_api.validate_enabled;
877: end if;
878: --
879: hr_utility.set_location(' Leaving:'||l_proc, 70);
880: exception

Line 881: when hr_api.validate_enabled then

877: end if;
878: --
879: hr_utility.set_location(' Leaving:'||l_proc, 70);
880: exception
881: when hr_api.validate_enabled then
882: --
883: -- As the Validate_Enabled exception has been raised
884: -- we must rollback to the savepoint
885: --