1 PACKAGE ghr_pdi_pkg AUTHID CURRENT_USER AS
2 /* $Header: ghrwspdi.pkh 115.2 99/10/14 12:12:42 porting ship $ */
3
4 PROCEDURE get_last_routing_list(p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE
5 ,p_routing_list_id OUT ghr_routing_lists.routing_list_id%TYPE
6 ,p_routing_list_name OUT ghr_routing_lists.name%TYPE
7 ,p_next_seq_number OUT ghr_routing_list_members.seq_number%TYPE
8 ,p_next_user_name OUT ghr_routing_list_members.user_name%TYPE
9 ,p_next_groupbox_id OUT ghr_routing_list_members.groupbox_id%TYPE
10 ,p_broken IN OUT BOOLEAN);
11
12 PROCEDURE get_roles (p_position_description_id in number
13 ,p_routing_group_id in number
14 ,p_user_name in varchar2 default null
15 ,p_initiator_flag in out varchar2
16 ,p_requester_flag in out varchar2
17 ,p_authorizer_flag in out varchar2
18 ,p_personnelist_flag in out varchar2
19 ,p_approver_flag in out varchar2
20 ,p_reviewer_flag in out varchar2);
21 END;