1 PACKAGE pv_prgm_approval_pvt AUTHID CURRENT_USER AS
2 /* $Header: pvxvpaps.pls 120.1 2005/09/12 15:52:27 saarumug noship $*/
3
4 -- PROCEDURE
5 -- Notify_requestor_FYI
6 --
7 -- PURPOSE
8 -- Generate the Requisition Document for display in messages, either
9 -- text or html
10 -- IN
11 -- document_id - Item Key
12 -- display_type - either 'text/plain' or 'text/html'
13 -- document - document buffer
14 -- document_type - type of document buffer created, either 'text/plain'
15 -- or 'text/html'
16 -- OUT
17 -- USED BY
18 -- - Oracle MArketing Generic Apporval
19 -- HISTORY
20 -- 03/15/2002 pukken CREATION
21 -- 12/04/2002 SVEERAVE added Process_errored_requests that will
22 -- be called from conc. request.
23 -- NOTE :
24 -- Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA
25 -- All rights reserved.
26 -----------------------------------------------------------------
27 PROCEDURE notify_requestor_fyi(
28 document_id IN VARCHAR2
29 ,display_type IN VARCHAR2
30 ,document IN OUT NOCOPY VARCHAR2
31 ,document_type IN OUT NOCOPY VARCHAR2);
32
33 --------------------------------------------------------------------------
34 -- PROCEDURE
35 -- Notify_requestor_of Approval
36 --
37 -- PURPOSE
38 -- Generate the Approval Document for display in messages, either
39 -- text or html
40 -- IN
41 -- document_id - Item Key
42 -- display_type - either 'text/plain' or 'text/html'
43 -- document - document buffer
44 -- document_type - type of document buffer created, either 'text/plain'
45 -- or 'text/html'
46 -- OUT
47 -- USED BY
48 -- - Oracle MArketing Generic Apporval
49 -- HISTORY
50 -- 03/15/2002 pukken CREATION
51 ----------------------------------------------------------------------------
52
53 PROCEDURE notify_requestor_of_approval(
54 document_id IN VARCHAR2
55 ,display_type IN VARCHAR2
56 ,document IN OUT NOCOPY VARCHAR2
57 ,document_type IN OUT NOCOPY VARCHAR2);
58
59 --------------------------------------------------------------------------
60 -- PROCEDURE
61 -- Notify_requestor_of rejection
62 --
63 -- PURPOSE
64 -- Generate the Rejection Document for display in messages, either
65 -- text or html
66 -- IN
67 -- document_id - Item Key
68 -- display_type - either 'text/plain' or 'text/html'
69 -- document - document buffer
70 -- document_type - type of document buffer created, either 'text/plain'
71 -- or 'text/html'
72 -- OUT
73 -- USED BY
74 -- - Oracle MArketing Generic Apporval
75 -- HISTORY
76 -- 03/15/2002 pukken CREATION
77 -------------------------------------------------------------------------------
78
79 PROCEDURE notify_requestor_of_rejection(
80 document_id IN VARCHAR2
81 ,display_type IN VARCHAR2
82 ,document IN OUT NOCOPY VARCHAR2
83 ,document_type IN OUT NOCOPY VARCHAR2);
84
85 --------------------------------------------------------------------------
86 -- PROCEDURE
87 -- Notify_requestor_of rejection
88 --
89 -- PURPOSE
90 -- Generate the Rejection Document for display in messages, either
91 -- text or html
92 -- IN
93 -- document_id - Item Key
94 -- display_type - either 'text/plain' or 'text/html'
95 -- document - document buffer
96 -- document_type - type of document buffer created, either 'text/plain'
97 -- or 'text/html'
98 -- OUT
99 -- USED BY
100 -- - Oracle MArketing Generic Apporval
101 -- HISTORY
102 -- 03/15/2002 pukken CREATION
103
104
105 PROCEDURE notify_approval_required(
106 document_id IN VARCHAR2
107 ,display_type IN VARCHAR2
108 ,document IN OUT NOCOPY VARCHAR2
109 ,document_type IN OUT NOCOPY VARCHAR2);
110
111 --------------------------------------------------------------------------
112 -- PROCEDURE
113 -- notify_appr_req_reminder
114 --
115 -- PURPOSE
116 -- Generate the Rejection Document for display in messages, either
117 -- text or html
118 -- IN
119 -- document_id - Item Key
120 -- display_type - either 'text/plain' or 'text/html'
121 -- document - document buffer
122 -- document_type - type of document buffer created, either 'text/plain'
123 -- or 'text/html'
124 -- OUT
125 -- USED BY
126 -- - Oracle MArketing Generic Apporval
127 -- HISTORY
128 -- 03/15/2002 pukken CREATION
129
130
131 PROCEDURE notify_appr_req_reminder(
132 document_id IN VARCHAR2
133 ,display_type IN VARCHAR2
134 ,document IN OUT NOCOPY VARCHAR2
135 ,document_type IN OUT NOCOPY VARCHAR2);
136
137 ---------------------------------------------------------------------
138 -- PROCEDURE
139 -- set_parprgm_activity_details
140 --
141 --
142 -- PURPOSE
143 -- This Procedure will set all the item attribute details
144 --
145 --
146 -- IN
147 --
148 --
149 -- OUT
150 --
151 -- Used By Activities
152 --
153 -- NOTES
154 --
155 --
156 --
157 -- HISTORY
158 -- 02/20/2002 pukken CREATION
159 -- End of Comments
160 --------------------------------------------------------------------
161 PROCEDURE set_parprgm_activity_details(
162 itemtype IN VARCHAR2
163 ,itemkey IN VARCHAR2
164 ,actid IN NUMBER
165 ,funcmode IN VARCHAR2
166 ,resultout OUT NOCOPY VARCHAR2);
167
168 ---------------------------------------------------------------------
169 -- PROCEDURE
170 -- update_parprogram_status
171 --
172 --
173 -- PURPOSE
174 -- This Procedure will update the status
175 --
176 --
177 -- IN
178 --
179 --
180 -- OUT
181 --
182 -- Used By Activities
183 --
184 -- NOTES
185 --
186 --
187 --
188 -- HISTORY
189 -- 02/20/2002 pukken CREATION
190 -- End of Comments
191 --------------------------------------------------------------------
192 PROCEDURE update_parprogram_status(
193 itemtype IN VARCHAR2
194 ,itemkey IN VARCHAR2
195 ,actid IN NUMBER
196 ,funcmode IN VARCHAR2
197 ,resultout OUT NOCOPY VARCHAR2);
198
199
200 -- PROCEDURE
201 -- submit_enrollment_for_approval
202 --
203 --
204 -- PURPOSE
205 -- This Procedure will submit the enrollment to the approver by calling OAM API
206 -- and sends FYI notification to the approver
207 --
208 --
209 -- IN
210 --
211 --
212 -- OUT
213 --
214 --
215 --
216 -- NOTES
217 --
218 --
219 --
220 -- HISTORY
221 -- 09/16/2002 pukken CREATION
222 -- End of Comments
223
224
225 PROCEDURE submit_enrl_req_for_approval(
226 p_api_version_number IN NUMBER
227 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
228 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
229 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
230 ,enrl_request_id IN NUMBER
231 ,entity_code IN VARCHAR2
232 ,x_return_status OUT NOCOPY VARCHAR2
233 ,x_msg_count OUT NOCOPY NUMBER
234 ,x_msg_data OUT NOCOPY VARCHAR2
235 );
236
237
238 --------------------------------------------------------------------------
239 -- FUNCTION
240 -- isPartnerType
241 --
242 -- PURPOSE
243 -- Checks whether the partner is of partner type passed in
244 -- IN
245 -- enrollment_request_id NUMBER
246 -- partner_type VARCHAR
247 -- OUT
248 -- ame_util.booleanAttributeTrue if exists
249 -- ame_util.booleanAttributeFalse if not exists
250 -- USED BY
251 -- Program Approval API, and Activate API.
252 -- HISTORY
253 -- 12/13/2002 CREATION
254 --------------------------------------------------------------------------
255 FUNCTION isPartnerType(p_partner_id IN NUMBER,p_partner_type IN VARCHAR2)
256 RETURN VARCHAR2;
257
258
259 PROCEDURE update_enrl_req_status(
260 p_api_version_number IN NUMBER
261 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
262 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
263 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
264 ,enrl_request_id IN NUMBER
265 ,entity_code IN VARCHAR2
266 ,approvalStatus IN VARCHAR2
267 ,start_date IN DATE
268 ,end_date IN DATE
269 ,x_return_status OUT NOCOPY VARCHAR2
270 ,x_msg_count OUT NOCOPY NUMBER
271 ,x_msg_data OUT NOCOPY VARCHAR2);
272
273
274 PROCEDURE getstart_and_end_date(
275 p_api_version_number IN NUMBER
276 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
277 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
278 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
279 ,enrl_request_id IN NUMBER
280 ,x_start_date OUT NOCOPY DATE
281 ,x_end_date OUT NOCOPY DATE
282 ,x_return_status OUT NOCOPY VARCHAR2
283 ,x_msg_count OUT NOCOPY NUMBER
284 ,x_msg_data OUT NOCOPY VARCHAR2 );
285
286
287 PROCEDURE check_approved (
288 itemtype IN VARCHAR2
289 ,itemkey IN VARCHAR2
290 ,actid IN NUMBER
291 ,funcmode IN VARCHAR2
292 ,resultout OUT NOCOPY VARCHAR2
293 );
294
295 --------------------------------------------------------------------------
296 -- PROCEDURE
297 -- Process_errored_requests
298 --
299 -- PURPOSE
300 -- Process the enrollment requests which are errored while finding next
301 -- approver in OAM. This will be called by concurrent program.
302 -- IN
303 -- std. conc. request parameters.
304 -- ERRBUF
305 -- RETCODE
306 -- OUT
307 -- USED BY
308 -- Concurrent program
309 -- HISTORY
310 -- 12/04/2002 sveerave CREATION
311 --------------------------------------------------------------------------
312 PROCEDURE Process_errored_requests(
313 ERRBUF OUT NOCOPY VARCHAR2,
314 RETCODE OUT NOCOPY VARCHAR2 );
315
316 PROCEDURE terminate_downgrade_memb(
317 p_api_version_number IN NUMBER
318 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
319 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
320 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
321 ,p_membership_id IN NUMBER
322 ,p_event_code IN VARCHAR2-- pass 'TERMINATED' or 'DOWNGRADED' depending on the event
323 ,p_status_reason_code IN VARCHAR2
324 ,p_comments IN VARCHAR2 DEFAULT NULL
325 ,p_program_id_downgraded_to IN NUMBER --programid into which the partner is downgraded to.
326 ,p_requestor_resource_id IN NUMBER --resource_id of the user who's performing the action
327 ,p_new_memb_id OUT NOCOPY NUMBER
328 ,x_return_status OUT NOCOPY VARCHAR2
329 ,x_msg_count OUT NOCOPY NUMBER
330 ,x_msg_data OUT NOCOPY VARCHAR2
331 );
332
333 --------------------------------------------------------------------------
334 -- PROCEDURE
335 -- Create_Default_Membership
336 --
337 -- PURPOSE
338 -- Create membership into a default program . This is called when new partner is created
339 -- IN
340 -- p_partner_id - partner_id of the partner
341 -- p_requestor_resource_id- resource_id of the user who's performing the action
342 -- USED BY
343 -- User Management while creating new partner
344 -- HISTORY
345 -- 05-June-2003 pukken CREATION
346 --------------------------------------------------------------------------
347 PROCEDURE Create_Default_Membership (
348 p_api_version_number IN NUMBER
349 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
350 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
351 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
352 ,p_partner_id IN NUMBER
353 ,p_requestor_resource_id IN NUMBER --resource_id of the user who's performing the action
354 ,x_return_status OUT NOCOPY VARCHAR2
355 ,x_msg_count OUT NOCOPY NUMBER
356 ,x_msg_data OUT NOCOPY VARCHAR2
357 );
358
359 PROCEDURE send_notifications
360 (
361 p_api_version_number IN NUMBER
362 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
363 , p_commit IN VARCHAR2 := FND_API.G_FALSE
364 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
365 , p_partner_id IN NUMBER
366 , p_enrl_request_id IN NUMBER -- enrollment request id
367 , p_memb_type IN VARCHAR2 -- member type of the partner
368 , p_enrq_status IN VARCHAR2 -- enrollment_status pass 'AWAITING_APPROVAL' incase submitting for approval
369 , x_return_status OUT NOCOPY VARCHAR2
370 , x_msg_count OUT NOCOPY NUMBER
371 , x_msg_data OUT NOCOPY VARCHAR2
372 );
373
374 END pv_prgm_approval_pvt;