[Home] [Help]
PACKAGE: APPS.BEN_CWB_RSGN_EMP
Source
1 PACKAGE BEN_CWB_RSGN_EMP AUTHID CURRENT_USER as
2 /* $Header: bencwbre.pkh 120.0.12000000.1 2007/01/19 15:29:45 appldev noship $ */
3
4 /* ===========================================================================+
5 * Name
6 * Compensation workbench reassign employee
7 * Purpose
8 *
9 * Version Date Author Comment
10 * -------+-----------+---------+----------------------------------------------
11 * 115.0 01-July-2002 aupadhya created
12 * 115.1 07-Aug-2002 aupadhya No Change, just removed extra rem statement.
13 * 115.2 27-Aug-2002 aupadhya Remove unused method declaration.
14 * 115.3 16-Dec-2002 hnarayan Added NOCOPY hint
15 * 115.4 24-Dec-2002 aupadhya Modified for CWB Itemization.
16 * 115.5 24-Mar-2003 aupadhya Replaced p_emp_id by p_emp_num in store_emp_details
17 * *
18 * ==========================================================================+
19 * 115.6 01-Mar-2004 aupadhya Global Budgeting Changes.
20 * 115.7 20-Sep-2004 aupadhya Global Budgeting 11.5.10
21 * ==========================================================================+
22 */
23
24 -- ----------------------------------------------------------------------------
25 -- |-------------------------< check_approver >-------------------------|
26 -- ----------------------------------------------------------------------------
27
28 procedure check_approver(itemtype in varchar2
29 , itemkey in varchar2
30 , actid in number
31 , funcmode in varchar2
32 , result out nocopy varchar2);
33
34 -- ----------------------------------------------------------------------------
35 -- |-------------------------< store_approval_details >-------------------------|
36 -- ----------------------------------------------------------------------------
37
38 procedure store_approval_details(itemtype in varchar2
39 , itemkey in varchar2
40 , actid in number
41 , funcmode in varchar2
42 , result out nocopy varchar2);
43
44 -- ----------------------------------------------------------------------------
45 -- |-------------------------< curr_ws_mgr_check >---------------------|
46 -- ----------------------------------------------------------------------------
47
48 procedure curr_ws_mgr_check(itemtype in varchar2
49 , itemkey in varchar2
50 , actid in number
51 , funcmode in varchar2
52 , result out nocopy varchar2);
53
54 -- ----------------------------------------------------------------------------
55 -- |-------------------------< prop_ws_mgr_check >---------------------|
56 -- ----------------------------------------------------------------------------
57
58 procedure prop_ws_mgr_check(itemtype in varchar2
59 , itemkey in varchar2
60 , actid in number
61 , funcmode in varchar2
62 , result out nocopy varchar2);
63
64 -- ----------------------------------------------------------------------------
65 -- |-------------------------< which_message >---------------------|
66 -- ----------------------------------------------------------------------------
67
68 procedure which_message(itemtype in varchar2
69 , itemkey in varchar2
70 , actid in number
71 , funcmode in varchar2
72 , result out nocopy varchar2);
73
74 -- ----------------------------------------------------------------------------
75 -- |-------------------------< set_rejection >---------------------|
76 -- ----------------------------------------------------------------------------
77 procedure set_rejection(itemtype in varchar2
78 , itemkey in varchar2
79 , actid in number
80 , funcmode in varchar2
81 , result out nocopy varchar2);
82
83 -- ----------------------------------------------------------------------------
84 -- |-------------------------< set_approval >---------------------|
85 -- ----------------------------------------------------------------------------
86
87 procedure set_approval(itemtype in varchar2
88 , itemkey in varchar2
89 , actid in number
90 , funcmode in varchar2
91 , result out nocopy varchar2);
92
93 -- ----------------------------------------------------------------------------
94 -- |-------------------------< is_in_comp_manager_role >---------------------|
95 -- ----------------------------------------------------------------------------
96
97 function is_in_comp_manager_role(p_person_id in number) return varchar2;
98
99
100 -- ----------------------------------------------------------------------------
101 -- |-------------------------< store_emp_details >---------------------|
102 -- ----------------------------------------------------------------------------
103
104 procedure store_emp_details
105 (p_per_in_ler_id in number,
106 p_transaction_id in number,
107 p_emp_name in varchar2,
108 p_emp_num in varchar2,
109 p_curr_ws_mgr in varchar2,
110 p_curr_ws_mgr_id in number,
111 p_prop_ws_mgr in varchar2,
112 p_prop_ws_mgr_id in number,
113 p_requestor in varchar2,
114 p_requestor_id in number,
115 p_request_date in varchar2,
116 p_prop_ws_mgr_per_in_ler_id in number,
117 p_curr_ws_mgr_per_in_ler_id in number,
118 p_group_pl_id in number,
119 p_business_group in varchar2
120 );
121
122 -- ----------------------------------------------------------------------------
123 -- |-------------------------< remove_emp_details >---------------------|
124 -- ----------------------------------------------------------------------------
125
126 procedure remove_emp_details
127 (itemtype in varchar2
128 , itemkey in varchar2
129 , actid in number
130 , funcmode in varchar2
131 , result out nocopy varchar2);
132
133 -- ----------------------------------------------------------------------------
134 -- |-------------------------< start_workflow >---------------------|
135 -- ----------------------------------------------------------------------------
136 procedure start_workflow(p_requestor_id in number,
137 p_curr_ws_manager_id number,
138 p_prop_ws_manager_id number,
139 p_plan_name varchar2,
140 p_message varchar2,
141 p_transaction_id number,
142 p_request_date varchar2,
143 p_reccount number,
144 p_prop_ws_mgr_per_in_ler_id number,
145 p_plan_id number) ;
146
147 -- ----------------------------------------------------------------------------
148 -- |-------------------------< send_fyi_notifications >---------------------|
149 -- ----------------------------------------------------------------------------
150
151 procedure send_fyi_notifications(p_requestor_id in number,
152 p_curr_ws_manager_id number,
153 p_prop_ws_manager_id number,
154 p_plan_name varchar2,
155 p_message varchar2,
156 p_transaction_id number,
157 p_request_date varchar2,
158 p_reccount number,
159 p_prop_mgr_per_in_ler_id number);
160
161 -- ----------------------------------------------------------------------------
162 -- |-------------------------< generate_detail_html >---------------------|
163 -- ----------------------------------------------------------------------------
164
165 PROCEDURE generate_detail_html
166 (
167 document_id IN VARCHAR2,
168 display_type IN VARCHAR2,
169 document IN OUT NOCOPY VARCHAR2,
170 document_type IN OUT NOCOPY VARCHAR2
171 );
172
173 -- ----------------------------------------------------------------------------
174 -- |-------------------------< generate_employee_table_html >---------------------|
175 -- ----------------------------------------------------------------------------
176
177 procedure generate_employee_table_html
178 (
179 document_id IN VARCHAR2,
180 display_type IN VARCHAR2,
181 document IN OUT NOCOPY VARCHAR2,
182 document_type IN OUT NOCOPY VARCHAR2
183 ) ;
184
185 -- ----------------------------------------------------------------------------
186 -- |-------------------------< generate_approver_table_html >---------------------|
187 -- ----------------------------------------------------------------------------
188
189 PROCEDURE generate_approver_table_html
190 (
191 document_id IN VARCHAR2,
192 display_type IN VARCHAR2,
193 document IN OUT NOCOPY VARCHAR2,
194 document_type IN OUT NOCOPY VARCHAR2
195 );
196
197 -- ----------------------------------------------------------------------------
198 -- |-------------------------< generate_error_html >---------------------|
199 -- ----------------------------------------------------------------------------
200
201 PROCEDURE generate_error_html
202 (
203 document_id IN VARCHAR2,
204 display_type IN VARCHAR2,
205 document IN OUT NOCOPY VARCHAR2,
206 document_type IN OUT NOCOPY VARCHAR2
207 );
208
209 end BEN_CWB_RSGN_EMP;