DBA Data[Home] [Help]

APPS.PAY_RETRO_STATUS_LOAD_API dependencies on HR_API

Line 117: and nvl(ppf.full_name, hr_api.g_varchar2)

113: and paf.business_group_id+0 = p_business_group_id
114: and ppf.person_id = paf.person_id
115: and paf.effective_start_date between ppf.effective_start_date
116: and ppf.effective_end_date
117: and nvl(ppf.full_name, hr_api.g_varchar2)
118: = nvl(p_full_name, nvl(ppf.full_name, hr_api.g_varchar2))
119: ;
120: exception
121: when no_data_found then

Line 118: = nvl(p_full_name, nvl(ppf.full_name, hr_api.g_varchar2))

114: and ppf.person_id = paf.person_id
115: and paf.effective_start_date between ppf.effective_start_date
116: and ppf.effective_end_date
117: and nvl(ppf.full_name, hr_api.g_varchar2)
118: = nvl(p_full_name, nvl(ppf.full_name, hr_api.g_varchar2))
119: ;
120: exception
121: when no_data_found then
122: --

Line 179: l_leg_code := hr_api.return_legislation_code(p_business_group_id);

175: hr_utility.set_location(l_proc, 30);
176: --
177: -- Identify element entry id.
178: --
179: l_leg_code := hr_api.return_legislation_code(p_business_group_id);
180:
181: if p_element_entry_id is not null then
182: l_element_entry_id := p_element_entry_id;
183: else

Line 743: hr_api.mandatory_arg_error

739: hr_utility.set_location('Entering:'|| l_proc, 10);
740: --
741: -- Check mandatory parameters have been set
742: --
743: hr_api.mandatory_arg_error
744: (p_api_name => l_proc
745: ,p_argument => 'business_group_id'
746: ,p_argument_value => p_business_group_id
747: );

Line 749: hr_api.mandatory_arg_error

745: ,p_argument => 'business_group_id'
746: ,p_argument_value => p_business_group_id
747: );
748:
749: hr_api.mandatory_arg_error
750: (p_api_name => l_proc
751: ,p_argument => 'assignment_number'
752: ,p_argument_value => p_assignment_number
753: );

Line 758: hr_api.validate_bus_grp_id

754:
755: --
756: -- Validate business group.
757: --
758: hr_api.validate_bus_grp_id
759: (p_business_group_id => p_business_group_id
760: );
761: --
762: -- Get assignment id.

Line 895: hr_api.mandatory_arg_error

891: --
892: --
893: -- Check mandatory parameters have been set
894: --
895: hr_api.mandatory_arg_error
896: (p_api_name => l_proc
897: ,p_argument => 'business_group_id'
898: ,p_argument_value => p_business_group_id
899: );

Line 901: hr_api.mandatory_arg_error

897: ,p_argument => 'business_group_id'
898: ,p_argument_value => p_business_group_id
899: );
900:
901: hr_api.mandatory_arg_error
902: (p_api_name => l_proc
903: ,p_argument => 'assignment_number'
904: ,p_argument_value => p_assignment_number
905: );

Line 910: hr_api.validate_bus_grp_id

906:
907: --
908: -- Validate business group.
909: --
910: hr_api.validate_bus_grp_id
911: (p_business_group_id => p_business_group_id
912: );
913: --
914: -- Get assignment id.

Line 938: ,p_reprocess_date => nvl(p_reprocess_date, hr_api.g_date)

934: if p_update_or_delete_mode = g_update_mode then
935: --
936: pay_retro_status_internal.update_retro_asg
937: (p_retro_assignment_id => l_retro_assignment_id
938: ,p_reprocess_date => nvl(p_reprocess_date, hr_api.g_date)
939: ,p_approval_status => nvl(p_approval_status, hr_api.g_varchar2)
940: ,p_owner_type => pay_retro_status_internal.g_user
941: );
942: --

Line 939: ,p_approval_status => nvl(p_approval_status, hr_api.g_varchar2)

935: --
936: pay_retro_status_internal.update_retro_asg
937: (p_retro_assignment_id => l_retro_assignment_id
938: ,p_reprocess_date => nvl(p_reprocess_date, hr_api.g_date)
939: ,p_approval_status => nvl(p_approval_status, hr_api.g_varchar2)
940: ,p_owner_type => pay_retro_status_internal.g_user
941: );
942: --
943: elsif p_update_or_delete_mode = g_delete_mode then

Line 980: hr_api.mandatory_arg_error

976: --
977: -- Check mandatory parameters have been set
978: --
979: hr_utility.set_location('Checking mandatory argument business_group_id : '|| l_proc, 15);
980: hr_api.mandatory_arg_error
981: (p_api_name => l_proc
982: ,p_argument => 'business_group_id'
983: ,p_argument_value => p_business_group_id
984: );

Line 987: hr_api.mandatory_arg_error

983: ,p_argument_value => p_business_group_id
984: );
985:
986: hr_utility.set_location('Checking mandatory argument assignment_number : '|| l_proc, 20);
987: hr_api.mandatory_arg_error
988: (p_api_name => l_proc
989: ,p_argument => 'assignment_number'
990: ,p_argument_value => p_assignment_number
991: );

Line 993: hr_api.mandatory_arg_error

989: ,p_argument => 'assignment_number'
990: ,p_argument_value => p_assignment_number
991: );
992: hr_utility.set_location('Checking mandatory argument reprocess_date : '|| l_proc, 30);
993: hr_api.mandatory_arg_error
994: (p_api_name => l_proc
995: ,p_argument => 'reprocess_date'
996: ,p_argument_value => p_reprocess_date
997: );

Line 1003: hr_api.validate_bus_grp_id

999: --
1000: -- Validate business group.
1001: --
1002: hr_utility.set_location('Validating business group : '|| l_proc, 40);
1003: hr_api.validate_bus_grp_id
1004: (p_business_group_id => p_business_group_id
1005: );
1006: --
1007: -- Get assignment id.