1 PACKAGE ghr_pdi_pkg AUTHID CURRENT_USER AS
2 /* $Header: ghrwspdi.pkh 120.0.12010000.3 2009/05/26 12:08:45 utokachi noship $ */
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 NOCOPY ghr_routing_lists.routing_list_id%TYPE
6 ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE
7 ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
8 ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE
9 ,p_next_groupbox_id OUT NOCOPY ghr_routing_list_members.groupbox_id%TYPE
10 ,p_broken IN OUT NOCOPY 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 NOCOPY varchar2
16 ,p_requester_flag in out NOCOPY varchar2
17 ,p_authorizer_flag in out NOCOPY varchar2
18 ,p_personnelist_flag in out NOCOPY varchar2
19 ,p_approver_flag in out NOCOPY varchar2
20 ,p_reviewer_flag in out NOCOPY varchar2);
21 END;