APPS.PAY_RETRO_STATUS_LOAD dependencies on HR_API

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

99: and ppf.person_id = paf.person_id
100: and paf.effective_start_date = (select max(effective_start_date)
101: from per_all_assignments_f
102: where assignment_id = paf.assignment_id)
103: and nvl(ppf.full_name, hr_api.g_varchar2)
104: = nvl(p_full_name, nvl(ppf.full_name, hr_api.g_varchar2));
105: exception
106: when no_data_found then
107: --

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

100: and paf.effective_start_date = (select max(effective_start_date)
101: from per_all_assignments_f
102: where assignment_id = paf.assignment_id)
103: and nvl(ppf.full_name, hr_api.g_varchar2)
104: = nvl(p_full_name, nvl(ppf.full_name, hr_api.g_varchar2));
105: exception
106: when no_data_found then
107: --
108: -- No assignment found for this assignment number (and full name).

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

160: hr_utility.set_location(l_proc, 30);
161: --
162: -- Identify element entry id.
163: --
164: l_leg_code := hr_api.return_legislation_code(p_business_group_id);
165:
166: if p_element_entry_id is not null then
167: l_element_entry_id := p_element_entry_id;
168: else

Line 728: hr_api.mandatory_arg_error

724: hr_utility.set_location('Entering:'|| l_proc, 10);
725: --
726: -- Check mandatory parameters have been set
727: --
728: hr_api.mandatory_arg_error
729: (p_api_name => l_proc
730: ,p_argument => 'business_group_id'
731: ,p_argument_value => p_business_group_id
732: );

Line 734: hr_api.mandatory_arg_error

730: ,p_argument => 'business_group_id'
731: ,p_argument_value => p_business_group_id
732: );
733:
734: hr_api.mandatory_arg_error
735: (p_api_name => l_proc
736: ,p_argument => 'assignment_number'
737: ,p_argument_value => p_assignment_number
738: );

Line 743: hr_api.validate_bus_grp_id

739:
740: --
741: -- Validate business group.
742: --
743: hr_api.validate_bus_grp_id
744: (p_business_group_id => p_business_group_id
745: );
746: --
747: -- Get assignment id.

Line 881: hr_api.mandatory_arg_error

877: --
878: --
879: -- Check mandatory parameters have been set
880: --
881: hr_api.mandatory_arg_error
882: (p_api_name => l_proc
883: ,p_argument => 'business_group_id'
884: ,p_argument_value => p_business_group_id
885: );

Line 887: hr_api.mandatory_arg_error

883: ,p_argument => 'business_group_id'
884: ,p_argument_value => p_business_group_id
885: );
886:
887: hr_api.mandatory_arg_error
888: (p_api_name => l_proc
889: ,p_argument => 'assignment_number'
890: ,p_argument_value => p_assignment_number
891: );

Line 896: hr_api.validate_bus_grp_id

892:
893: --
894: -- Validate business group.
895: --
896: hr_api.validate_bus_grp_id
897: (p_business_group_id => p_business_group_id
898: );
899: --
900: -- Get assignment id.

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

920: if p_update_or_delete_mode = g_update_mode then
921: --
922: pay_retro_status_internal.update_retro_asg
923: (p_retro_assignment_id => l_retro_assignment_id
924: ,p_reprocess_date => nvl(p_reprocess_date, hr_api.g_date)
925: ,p_approval_status => nvl(p_approval_status, hr_api.g_varchar2)
926: ,p_owner_type => pay_retro_status_internal.g_user
927: );
928: --

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

921: --
922: pay_retro_status_internal.update_retro_asg
923: (p_retro_assignment_id => l_retro_assignment_id
924: ,p_reprocess_date => nvl(p_reprocess_date, hr_api.g_date)
925: ,p_approval_status => nvl(p_approval_status, hr_api.g_varchar2)
926: ,p_owner_type => pay_retro_status_internal.g_user
927: );
928: --
929: elsif p_update_or_delete_mode = g_delete_mode then

Line 967: hr_api.mandatory_arg_error

963: --
964: -- Check mandatory parameters have been set
965: --
966: hr_utility.set_location('Checking mandatory argument business_group_id : '|| l_proc, 15);
967: hr_api.mandatory_arg_error
968: (p_api_name => l_proc
969: ,p_argument => 'business_group_id'
970: ,p_argument_value => p_business_group_id
971: );

Line 974: hr_api.mandatory_arg_error

970: ,p_argument_value => p_business_group_id
971: );
972:
973: hr_utility.set_location('Checking mandatory argument assignment_number : '|| l_proc, 20);
974: hr_api.mandatory_arg_error
975: (p_api_name => l_proc
976: ,p_argument => 'assignment_number'
977: ,p_argument_value => p_assignment_number
978: );

Line 980: hr_api.mandatory_arg_error

976: ,p_argument => 'assignment_number'
977: ,p_argument_value => p_assignment_number
978: );
979: hr_utility.set_location('Checking mandatory argument reprocess_date : '|| l_proc, 30);
980: hr_api.mandatory_arg_error
981: (p_api_name => l_proc
982: ,p_argument => 'reprocess_date'
983: ,p_argument_value => p_reprocess_date
984: );

Line 990: hr_api.validate_bus_grp_id

986: --
987: -- Validate business group.
988: --
989: hr_utility.set_location('Validating business group : '|| l_proc, 40);
990: hr_api.validate_bus_grp_id
991: (p_business_group_id => p_business_group_id
992: );
993: --
994: -- Get assignment id.