APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_ROUTING_LIST_MEMBERS

Line 88: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE

84: --
85: PROCEDURE get_last_routing_list(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
86: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE
87: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE
88: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
89: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE
90: ,p_next_groupbox_id OUT NOCOPY ghr_routing_list_members.groupbox_id%TYPE
91: ,p_broken IN OUT NOCOPY BOOLEAN);
92: --

Line 89: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE

85: PROCEDURE get_last_routing_list(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
86: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE
87: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE
88: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
89: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE
90: ,p_next_groupbox_id OUT NOCOPY ghr_routing_list_members.groupbox_id%TYPE
91: ,p_broken IN OUT NOCOPY BOOLEAN);
92: --
93: PROCEDURE get_roles (p_pa_request_id in number

Line 90: ,p_next_groupbox_id OUT NOCOPY ghr_routing_list_members.groupbox_id%TYPE

86: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE
87: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE
88: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
89: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE
90: ,p_next_groupbox_id OUT NOCOPY ghr_routing_list_members.groupbox_id%TYPE
91: ,p_broken IN OUT NOCOPY BOOLEAN);
92: --
93: PROCEDURE get_roles (p_pa_request_id in number
94: ,p_routing_group_id in number