1 PACKAGE ghr_wf_pd_pkg AUTHID CURRENT_USER AS
2 /* $Header: ghwfpd.pkh 115.4 2003/12/19 05:24:32 vnarasim ship $ */
3 --
4 --
5 --
6 procedure StartPDProcess
7 (
8 p_position_description_id in number,
9 p_item_key in varchar2,
10 p_forward_to_name in varchar2
11 );
12 --
13 --
14 PROCEDURE UpdateRHistoryProcess( itemtype in varchar2,
15 itemkey in varchar2,
16 actid in number,
17 funcmode in varchar2,
18 result in OUT NOCOPY varchar2);
19 --
20 --
21 procedure FindDestination( itemtype in varchar2,
22 itemkey in varchar2,
23 actid in number,
24 funcmode in varchar2,
25 result in OUT NOCOPY varchar2);
26 --
27 --
28 PROCEDURE GetDestinationDetails (
29 p_position_description_id in NUMBER,
30 p_action_taken OUT NOCOPY varchar2,
31 p_user_name OUT NOCOPY varchar2,
32 p_groupbox_name OUT NOCOPY varchar2
33 );
34 --
35 --
36 PROCEDURE SetDestinationDetails (
37 p_position_description_id in NUMBER,
38 p_from_name OUT NOCOPY VARCHAR2,
39 p_category OUT NOCOPY varchar2,
40 p_occupational_code OUT NOCOPY varchar2,
41 p_grade_level OUT NOCOPY varchar2,
42 p_official_title OUT NOCOPY varchar2,
43 p_current_status OUT NOCOPY varchar2,
44 p_pay_plan OUT NOCOPY varchar2,
45 p_routing_group OUT NOCOPY varchar2,
46 p_date_inititated OUT NOCOPY varchar2,
47 p_date_received OUT NOCOPY varchar2
48 );
49 --
50 procedure CompleteBlockingOfPD ( p_position_description_id in Number);
51 --
52 --
53 PROCEDURE get_routing_group_details (
54 p_user_name IN fnd_user.user_name%TYPE
55 ,p_position_description_id IN
56 ghr_position_descriptions.position_description_id%TYPE
57 ,p_routing_group_id IN OUT NOCOPY NUMBER
58 ,p_initiator_flag IN OUT NOCOPY VARCHAR2
59 ,p_requester_flag IN OUT NOCOPY VARCHAR2
60 ,p_authorizer_flag IN OUT NOCOPY VARCHAR2
61 ,p_personnelist_flag IN OUT NOCOPY VARCHAR2
62 ,p_approver_flag IN OUT NOCOPY VARCHAR2
63 ,p_reviewer_flag IN OUT NOCOPY VARCHAR2);
64 --
65 --
66 function item_attribute_exists
67 (p_item_type in wf_items.item_type%type
68 ,p_item_key in wf_items.item_key%type
69 ,p_name in wf_item_attributes_tl.name%type)
70 return boolean;
71 --
72 --
73 PROCEDURE CheckIfPDWfEnd ( itemtype in varchar2,
74 itemkey in varchar2,
75 actid in number,
76 funcmode in varchar2,
77 result in OUT NOCOPY varchar2);
78 --
79 PROCEDURE EndPDProcess( itemtype in varchar2,
80 itemkey in varchar2,
81 actid in number,
82 funcmode in varchar2,
83 result in OUT NOCOPY varchar2);
84 --
85 end ghr_wf_pd_pkg;
86
[Home] [Help]