DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_ROUTING_LISTS

Line 134: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE

130: ,p_approver_flag IN OUT NOCOPY VARCHAR2
131: ,p_reviewer_flag IN OUT NOCOPY VARCHAR2);
132: --
133: PROCEDURE get_last_routing_list(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
134: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE
135: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE
136: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
137: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE
138: ,p_next_groupbox_id OUT NOCOPY ghr_routing_list_members.groupbox_id%TYPE

Line 135: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE

131: ,p_reviewer_flag IN OUT NOCOPY VARCHAR2);
132: --
133: PROCEDURE get_last_routing_list(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
134: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE
135: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE
136: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
137: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE
138: ,p_next_groupbox_id OUT NOCOPY ghr_routing_list_members.groupbox_id%TYPE
139: ,p_broken IN OUT NOCOPY BOOLEAN);