[Home] [Help]
PACKAGE: APPS.OZF_APPROVAL_PVT
Source
1 PACKAGE OZF_APPROVAL_PVT AS
2 /* $Header: ozfvapps.pls 120.1 2007/12/24 06:46:00 ateotia ship $ */
3
4 TYPE approval_rec_type IS RECORD (
5 OBJECT_TYPE VARCHAR2(30)
6 ,OBJECT_ID NUMBER
7 ,STATUS_CODE VARCHAR2(30)
8 ,ACTION_CODE VARCHAR2(30)
9 ,ACTION_PERFORMED_BY NUMBER -- fnd user_id
10 );
11
12 TYPE action_tbl_type is TABLE OF approval_rec_type;
13
14 TYPE approvers_rec_type IS RECORD (
15 APPROVER_TYPE VARCHAR2(30) -- USER
16 ,APPROVER_ID NUMBER -- fnd user_id
17 ,APPROVER_LEVEL NUMBER
18 );
19
20 TYPE approvers_tbl_type is TABLE OF approvers_rec_type;
21
22 -- 'R12.1 Enhancement: Ship & Debit Request' by ateotia(+)
23 TYPE sd_access_rec_type IS RECORD (
24 REQUEST_HEADER_ID NUMBER,
25 USER_ID NUMBER,
26 RESOURCE_ID NUMBER,
27 PERSON_ID NUMBER,
28 OWNER_FLAG VARCHAR2(1),
29 APPROVER_FLAG VARCHAR2(1),
30 ENABLED_FLAG VARCHAR2(1)
31 );
32 -- 'R12.1 Enhancement: Ship & Debit Request' by ateotia(-)
33
34 ---------------------------------------------------------------------
35 -- PROCEDURE
36 -- Update_User_Action
37 --
38 -- PURPOSE
39 -- PARAMETERS
40 -- NOTES
41 ---------------------------------------------------------------------
42 PROCEDURE Update_User_Action(
43 p_api_version IN NUMBER
44 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
45 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
46
47 ,x_return_status OUT NOCOPY VARCHAR2
48 ,x_msg_data OUT NOCOPY VARCHAR2
49 ,x_msg_count OUT NOCOPY NUMBER
50
51 ,p_approval_rec IN approval_rec_type
52 );
53 ---------------------------------------------------------------------
54 -- PROCEDURE
55 -- Get_Approvers
56 --
57 -- PURPOSE
58 -- PARAMETERS
59 -- NOTES
60 ---------------------------------------------------------------------
61 PROCEDURE Get_Approvers(
62 p_api_version IN NUMBER
63 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
64 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
65
66 ,x_return_status OUT NOCOPY VARCHAR2
67 ,x_msg_data OUT NOCOPY VARCHAR2
68 ,x_msg_count OUT NOCOPY NUMBER
69
70 ,p_approval_rec IN approval_rec_type
71 ,x_approvers OUT NOCOPY approvers_tbl_type
72 ,x_final_approval_flag OUT NOCOPY VARCHAR2
73 );
74 ---------------------------------------------------------------------
75 -- PROCEDURE
76 -- Add_Access
77 --
78 -- PURPOSE
79 -- adds approvers access to table
80 --
81 -- PARAMETERS
82 -- NOTES
83 ---------------------------------------------------------------------
84 PROCEDURE Add_Access(
85 p_api_version IN NUMBER
86 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
87 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
88 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
89
90 ,x_msg_data OUT NOCOPY VARCHAR2
91 ,x_msg_count OUT NOCOPY NUMBER
92 ,x_return_status OUT NOCOPY VARCHAR2
93
94 ,p_approval_rec IN approval_rec_type
95 ,p_approvers IN approvers_tbl_type );
96 ---------------------------------------------------------------------
97 -- PROCEDURE
98 -- Revoke_Access
99 --
100 -- PURPOSE
101 -- Revokes access to current approvers
102 --
103 -- PARAMETERS
104 --
105 -- NOTES
106 ---------------------------------------------------------------------
107 PROCEDURE Revoke_Access (
108 p_api_version IN NUMBER
109 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
110 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
112
113 ,x_return_status OUT NOCOPY VARCHAR2
114 ,x_msg_data OUT NOCOPY VARCHAR2
115 ,x_msg_count OUT NOCOPY NUMBER
116
117 ,p_object_type IN VARCHAR2
118 ,p_object_id IN NUMBER
119 );
120 ---------------------------------------------------------------------
121 -- PROCEDURE
122 -- Raise_Event
123 --
124 -- PURPOSE
125 -- Raise business event
126 --
127 -- PARAMETERS
128 --
129 -- NOTES
130 ---------------------------------------------------------------------
131 PROCEDURE Raise_Event (
132 x_return_status OUT NOCOPY VARCHAR2
133 ,x_msg_data OUT NOCOPY VARCHAR2
134 ,x_msg_count OUT NOCOPY NUMBER
135 ,p_event_name IN VARCHAR2
136 ,p_event_key IN VARCHAR2
137 --,p_data IN CLOB DEFAULT NULL
138 ,p_approval_rec IN approval_rec_type);
139 ---------------------------------------------------------------------
140 -- PROCEDURE
141 -- Send_Notification
142 --
143 -- PURPOSE
144 -- Sends notifications to approvers
145 --
146 -- PARAMETERS
147 --
148 -- NOTES
149 ---------------------------------------------------------------------
150 PROCEDURE Send_Notification (
151 p_api_version IN NUMBER
152 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
153 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
154 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
155
156 ,x_return_status OUT NOCOPY VARCHAR2
157 ,x_msg_data OUT NOCOPY VARCHAR2
158 ,x_msg_count OUT NOCOPY NUMBER
159
160 ,p_benefit_id IN NUMBER
161 ,p_partner_id IN NUMBER
162 ,p_msg_callback_api IN VARCHAR2
163 ,p_user_callback_api IN VARCHAR2
164 ,p_approval_rec IN approval_rec_type
165 );
166 ---------------------------------------------------------------------
167 -- PROCEDURE
168 -- Process_User_Action
169
170 --
171 -- PURPOSE
172 -- Handles the approvals and rejections of objects
173 --
174 -- PARAMETERS
175 --
176 -- NOTES
177 -- 1. object_version_number will be set to 1.
178 ---------------------------------------------------------------------
179 PROCEDURE Process_User_Action (
180 p_api_version IN NUMBER
181 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
182 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
183 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
184
185 ,x_return_status OUT NOCOPY VARCHAR2
186 ,x_msg_data OUT NOCOPY VARCHAR2
187 ,x_msg_count OUT NOCOPY NUMBER
188
189 ,p_approval_rec IN approval_rec_type
190 ,p_approver_id IN NUMBER
191 ,x_final_approval_flag OUT NOCOPY VARCHAR2
192 );
193
194 -- 'R12.1 Enhancement: Ship & Debit Request' by ateotia(+)
195 ---------------------------------------------------------------------
196 -- PROCEDURE
197 -- Process_SD_Approval
198 --
199 -- PURPOSE
200 -- This procedure has been created for Ship & Debit Request.
201 -- This procedure Handles the approval of Ship & Debit Objects.
202 --
203 -- PARAMETERS
204 --
205 -- NOTES
206 ---------------------------------------------------------------------
207 PROCEDURE Process_SD_Approval (
208 p_api_version IN NUMBER
209 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
210 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
211 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
212 ,p_object_id IN NUMBER
213 ,p_action_code IN VARCHAR2
214 ,x_return_status OUT NOCOPY VARCHAR2
215 ,x_msg_count OUT NOCOPY NUMBER
216 ,x_msg_data OUT NOCOPY VARCHAR2
217 );
218
219 ---------------------------------------------------------------------
220 -- PROCEDURE
221 -- Get_All_Approvers
222 --
223 -- PURPOSE
224 -- This procedure has been created for Ship & Debit Request.
225 -- This procedure calls ame_api2.getAllApprovers7 to get
226 -- Approver list from AME Setup.
227 --
228 -- PARAMETERS
229 --
230 -- NOTES
231 ---------------------------------------------------------------------
232 PROCEDURE Get_All_Approvers(
233 p_api_version IN NUMBER
234 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
235 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
236 ,p_transaction_id IN VARCHAR2
237 ,p_transaction_type_key IN VARCHAR2
238 ,x_approvers OUT NOCOPY ame_util.approversTable2
239 ,x_approval_flag OUT NOCOPY VARCHAR2
240 ,x_return_status OUT NOCOPY VARCHAR2
241 ,x_msg_data OUT NOCOPY VARCHAR2
242 ,x_msg_count OUT NOCOPY NUMBER);
243
244 ---------------------------------------------------------------------
245 -- PROCEDURE
246 -- Add_SD_Access
247 --
248 -- PURPOSE
249 -- This procedure has been created for Ship & Debit Request.
250 -- This procedure performs the required validation and invokes the
251 -- overloaded procedure which finally adds the record into
252 -- OZF_SD_REQUEST_ACCESS table.
253 --
254 -- PARAMETERS
255 --
256 -- NOTES
257 ---------------------------------------------------------------------
258 PROCEDURE Add_SD_Access(
259 p_api_version IN NUMBER
260 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
261 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
262 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
263 ,p_request_header_id IN NUMBER
264 ,p_user_id IN NUMBER
265 ,p_resource_id IN NUMBER
266 ,p_person_id IN NUMBER DEFAULT NULL
267 ,p_owner_flag IN VARCHAR2
268 ,p_approver_flag IN VARCHAR2
269 ,p_enabled_flag IN VARCHAR2 DEFAULT 'Y'
270 ,x_return_status OUT NOCOPY VARCHAR2
271 ,x_msg_count OUT NOCOPY NUMBER
272 ,x_msg_data OUT NOCOPY VARCHAR2);
273
274 ---------------------------------------------------------------------
275 -- PROCEDURE
276 -- Add_SD_Access
277 --
278 -- PURPOSE
279 -- This procedure has been created for Ship & Debit Request.
280 -- This procedure performs the required business logic and adds
281 -- the record into OZF_SD_REQUEST_ACCESS table.
282 --
283 -- PARAMETERS
284 --
285 -- NOTES
286 ---------------------------------------------------------------------
287 PROCEDURE Add_SD_Access(
288 p_api_version IN NUMBER
289 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
290 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
291 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
292 ,p_access_rec IN sd_access_rec_type
293 ,x_return_status OUT NOCOPY VARCHAR2
294 ,x_msg_count OUT NOCOPY NUMBER
295 ,x_msg_data OUT NOCOPY VARCHAR2);
296
297 ---------------------------------------------------------------------
298 -- PROCEDURE
299 -- Raise_SD_Event
300 --
301 -- PURPOSE
302 -- This procedure has been created for Ship & Debit Request.
303 -- This procedure raises a business event to send different
304 -- notifications for Ship & Debit request.
305 --
306 -- PARAMETERS
307 --
308 -- NOTES
309 ---------------------------------------------------------------------
310 PROCEDURE Raise_SD_Event (
311 p_event_key IN VARCHAR2
312 ,p_object_id IN NUMBER
313 ,p_action_code IN VARCHAR2
314 ,x_return_status OUT NOCOPY VARCHAR2
315 ,x_msg_data OUT NOCOPY VARCHAR2
316 ,x_msg_count OUT NOCOPY NUMBER);
317
318 ---------------------------------------------------------------------
319 -- PROCEDURE
320 -- Send_Notification
321 --
322 -- PURPOSE
323 -- This procedure has been created for Ship & Debit Request.
324 -- This procedure sends the notifications based on p_action_code.
325 --
326 -- PARAMETERS
327 --
328 -- NOTES
329 ---------------------------------------------------------------------
330 PROCEDURE Send_SD_Notification (
331 p_api_version IN NUMBER
332 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
333 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
334 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
335 ,p_object_id IN NUMBER
336 ,p_action_code IN VARCHAR2
337 ,x_return_status OUT NOCOPY VARCHAR2
338 ,x_msg_data OUT NOCOPY VARCHAR2
339 ,x_msg_count OUT NOCOPY NUMBER);
340
341 -- 'R12.1 Enhancement: Ship & Debit Request' by ateotia(-)
342
343
344 END OZF_APPROVAL_PVT;