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.PAY_RETRO_STATUS_LOAD dependencies on HR_API

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

98: and paf.business_group_id+0 = p_business_group_id
99: and ppf.person_id = paf.person_id
100: and paf.effective_start_date between ppf.effective_start_date
101: and ppf.effective_end_date
102: and nvl(ppf.full_name, hr_api.g_varchar2)
103: = nvl(p_full_name, nvl(ppf.full_name, hr_api.g_varchar2))
104: ;
105: exception
106: when no_data_found then

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

99: and ppf.person_id = paf.person_id
100: and paf.effective_start_date between ppf.effective_start_date
101: and ppf.effective_end_date
102: and nvl(ppf.full_name, hr_api.g_varchar2)
103: = nvl(p_full_name, nvl(ppf.full_name, hr_api.g_varchar2))
104: ;
105: exception
106: when no_data_found then
107: --

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 880: hr_api.mandatory_arg_error

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

Line 886: hr_api.mandatory_arg_error

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

Line 895: hr_api.validate_bus_grp_id

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

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

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

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

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

Line 965: hr_api.mandatory_arg_error

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

Line 972: hr_api.mandatory_arg_error

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

Line 978: hr_api.mandatory_arg_error

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

Line 988: hr_api.validate_bus_grp_id

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