1 PACKAGE ben_cwb_emp_elig AUTHID CURRENT_USER AS
2 /* $Header: bencwbee.pkh 120.0.12000000.1 2007/01/19 15:24:44 appldev noship $ */
3 TYPE L_EMP_NUMBER is VARRAY(500) of NUMBER(15);
4
5 PROCEDURE isCompManagerRole
6 (
7 p_person_id IN NUMBER
8 ,retValue OUT NOCOPY VARCHAR2
9 );
10
11 -- Right now FYI notifications are not sent for the worksheet manager when the top person in the hierachy switches
12 -- manger and changes the eligibility. For the top person it should happen without any approval but notification has to
13 -- be sent to the worksheet manager informing him that the eligibility is changed. In June 3rd drop the notification
14 -- is not sent to the worksheet manager if top person changes the eligibility.
15 /*PROCEDURE fyiNotification
16 ( p_message_type IN VARCHAR2
17 ,p_person_id IN NUMBER
18 ,p_plan_name IN VARCHAR2
19 ,p_transaction_id IN NUMBER
20 );*/
21
22 PROCEDURE select_next_approver
23 ( itemtype IN VARCHAR2
24 , itemkey IN VARCHAR2
25 , actid IN NUMBER
26 , funcmode IN VARCHAR2
27 , result OUT NOCOPY VARCHAR2
28 );
29
30
31 PROCEDURE store_transaction
32 ( itemtype IN VARCHAR2
33 , itemkey IN VARCHAR2
34 , actid IN NUMBER
35 , funcmode IN VARCHAR2
36 , result OUT NOCOPY VARCHAR2
37 );
38
39
40 PROCEDURE store_rejection
41 ( itemtype IN VARCHAR2
42 , itemkey IN VARCHAR2
43 , actid IN NUMBER
44 , funcmode IN VARCHAR2
45 , result OUT NOCOPY VARCHAR2
46 );
47
48 PROCEDURE store_approval
49 ( itemtype IN VARCHAR2
50 , itemkey IN VARCHAR2
51 , actid IN NUMBER
52 , funcmode IN VARCHAR2
53 , result OUT NOCOPY VARCHAR2
54 );
55
56 PROCEDURE is_req_wsmgr_same
57 ( itemtype IN VARCHAR2
58 , itemkey IN VARCHAR2
59 , actid IN NUMBER
60 , funcmode IN VARCHAR2
61 , result OUT NOCOPY VARCHAR2
62 );
63
64
65 PROCEDURE remove_transaction
66 ( itemtype IN VARCHAR2
67 , itemkey IN VARCHAR2
68 , actid IN NUMBER
69 , funcmode IN VARCHAR2
70 , result OUT NOCOPY VARCHAR2
71 );
72
73 PROCEDURE cwb_emp_elig_appr_api
74 ( p_ws_person_id in number default null
75 , p_rcvr_person_id in number default null
76 , p_plan_name in varchar2
77 , p_relationship_id in number
78 , p_group_per_in_ler_id in number
79 );
80
81 END;