1 PACKAGE ibe_workflow_pvt AUTHID CURRENT_USER AS
2 /* $Header: IBEVWFS.pls 120.3 2005/11/14 03:10:59 knachiap noship $ */
3 /*==============================================================================
4 | NAME
5 | ibe_workflow_pvt
6 |
7 | MODIFICATION HISTORY
8 | 03/23/99 hjaganat Created
9 | 08/23/00 hjaganat Modifications for Order Status Alerts
10 | completed
11 | 09/06/00 hjaganat Modifications for Contracts completed
12 | 09/07/00 hjaganat Modifications for Sales Assistance
13 | completed
14 | 07/14/01 Dkhanna - Modified for Template Mapping FrameWork.
15 | 10/26/01 Ashukla - Modified for Quote Publish.
16 | 11/29/01 Ashukla - Modified for bug2104272
17 | 12/27/01 Ashukla - Modified for bug2077446
18 | 02/18/02 ljanakir - Modified for bug2223507
19 | Added p_salesrep_user_id parameter for the procedure
20 | NotifyForSalesAssistance
21 | 03/13/03 ljanakir - Modified for bug 2111316
22 | Added the procedure NotifyForgetLogin
23 | 09/27/02 batoleti - Added Notify_End_Working procedure.
24 | 10/01/02 batoleti - Added Notify_Finish_Sharing procedure.
25 | 10/04/02 batoleti - Added NotifyForSharedCart procedure.
26 | 10/07/02 batoleti - Added Notify_Access_Change procedure.
27 | 12/12/02 SCHAK Bug # 2691704 Modified for NOCOPY Changes.
28 | 07/22/03 batoleti Added Return Order Notification procedure.
29 / 08/26/03 abhandar changed getUserType(),Get_Name_Details() and NotifyRegistration()
30 / Added Generate_Approval_Msg()
31 | 01/May/05 Knachiap MACD Notification Change for Cart/Checkout
32 | 06/02/05 abairy Added Generate_Credential_Msg procedure
33 | 14/Nov/05 Knachiap Line Type for Quote
34 ===============================================================================
35 */
36
37 PROCEDURE NotifyForQuotePublish(
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40 p_Msite_Id IN NUMBER,
41 p_quote_id IN VARCHAR2,
42 p_Req_Name IN Varchar2,
43 p_Send_Name IN Varchar2,
44 p_Email_Address IN Varchar2,
45 p_url IN Varchar2,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2
49 );
50
51 PROCEDURE NotifyRegistration(
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54 p_first_name IN VARCHAR2,
55 p_last_name IN VARCHAR2,
56 p_login_name IN VARCHAR2,
57 p_password IN VARCHAR2,
58 p_usertype IN VARCHAR2,
59 p_email_address IN VARCHAR2,
60 p_event_type IN VARCHAR2,
61 p_language IN VARCHAR2,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2
65 );
66
67
68 PROCEDURE NotifyRegistration (
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71 p_Msite_Id IN NUMBER,
72 p_first_name IN VARCHAR2,
73 p_last_name IN VARCHAR2,
74 p_login_name IN VARCHAR2,
75 p_password IN VARCHAR2,
76 p_usertype IN VARCHAR2,
77 p_email_address IN VARCHAR2,
78 p_event_type IN VARCHAR2,
79 p_language IN VARCHAR2,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2
83 );
84
85
86
87 PROCEDURE NotifyForgetLogin(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90 p_Msite_Id IN NUMBER,
91 p_first_name IN VARCHAR2,
92 p_last_name IN VARCHAR2,
93 p_login_name IN VARCHAR2,
94 p_password IN VARCHAR2,
95 p_email_address IN VARCHAR2,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2
99 );
100
101
102 PROCEDURE NotifyOrderStatus(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105 p_quote_id IN NUMBER,
106 p_status IN VARCHAR2,
107 p_errmsg_count IN NUMBER,
108 p_errmsg_data IN VARCHAR2,
109 p_sharee_partyId IN NUMBER := NULL,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2
113 );
114
115 PROCEDURE NotifyOrderStatus(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118 p_msite_id IN NUMBER,
119 p_quote_id IN NUMBER,
120 p_status IN VARCHAR2,
121 p_errmsg_count IN NUMBER,
122 p_errmsg_data IN VARCHAR2,
123 p_sharee_partyId IN NUMBER,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2
127 );
128
129 PROCEDURE NotifyReturnOrderStatus(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
132 p_party_id IN NUMBER,
133 p_order_header_id IN NUMBER,
134 p_errmsg_count IN NUMBER,
135 p_errmsg_data IN VARCHAR2,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2
139 );
140
141 PROCEDURE get_contact_details_for_order(
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
144 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
145 p_order_id IN NUMBER,
146 x_contact_party_id OUT NOCOPY NUMBER,
147 x_contact_first_name OUT NOCOPY VARCHAR2,
148 x_contact_mid_name OUT NOCOPY VARCHAR2,
149 x_contact_last_name OUT NOCOPY VARCHAR2,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2
153 );
154
155 PROCEDURE Notify_cancel_order(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
158 p_order_id IN NUMBER,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2
162 );
163
164 PROCEDURE NotifyForContractsChange(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167 p_quote_id IN NUMBER,
168 p_contract_id IN NUMBER,
169 p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
170 p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_msg_data OUT NOCOPY VARCHAR2
174 );
175
176 PROCEDURE NotifyForContractsChange(
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179 p_msite_id IN NUMBER,
180 p_quote_id IN NUMBER,
181 p_contract_id IN NUMBER,
182 p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
183 p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2
187 );
188
189 APPROVED CONSTANT NUMBER := 0;
190 REJECTED CONSTANT NUMBER := 1;
191 CANCELLED CONSTANT NUMBER := 2;
192
193 PROCEDURE NotifyForContractsStatus(
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196 p_quote_id IN NUMBER,
197 p_contract_id IN NUMBER,
198 p_contract_status IN NUMBER,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2
202 );
203
204
205 PROCEDURE NotifyForSalesAssistance (
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
208 p_quote_id IN NUMBER,
209 p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
210 p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
211 p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
212 p_salesrep_user_id IN NUMBER := NULL,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2
216 );
217
218 PROCEDURE NotifyForSalesAssistance (
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
221 p_msite_id IN NUMBER,
222 p_quote_id IN NUMBER,
223 p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
224 p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
225 p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
226 p_salesrep_user_id IN NUMBER := NULL,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2
230 );
231
232
233 PROCEDURE Notifyforsharedcart (
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
236 p_Quote_Header_id IN NUMBER,
237 p_emailAddress IN VARCHAR2,
238 p_quoteShareeNum IN NUMBER,
239 p_privilegeType IN VARCHAR2,
240 p_url IN VARCHAR2,
241 p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2
245 );
246
247 PROCEDURE NotifyForSharedCart (
248 p_api_version IN NUMBER,
249 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250 p_Msite_id IN NUMBER,
251 p_Quote_Header_id IN NUMBER,
252 p_emailAddress IN VARCHAR2,
253 p_quoteShareeNum IN NUMBER,
254 p_privilegeType IN VARCHAR2,
255 p_url IN VARCHAR2,
256 p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
257 x_return_status OUT NOCOPY VARCHAR2,
258 x_msg_count OUT NOCOPY NUMBER,
259 x_msg_data OUT NOCOPY VARCHAR2
260 );
261
262 PROCEDURE Notify_End_working(
263 p_api_version IN NUMBER,
264 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
265 p_quote_header_id IN NUMBER,
266 p_party_id IN NUMBER,
267 p_cust_account_id IN NUMBER,
268 p_retrieval_number IN NUMBER,
269 p_minisite_id IN NUMBER,
270 p_url IN VARCHAR2,
271 p_notes IN VARCHAR2,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2
275 );
276
277 PROCEDURE Notify_Finish_Sharing(
278 p_api_version IN NUMBER,
279 p_init_msg_list IN VARCHAR2,
280 p_quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE,
281 p_minisite_id IN NUMBER,
282 p_url IN VARCHAR2,
283 p_context_code IN varchar2,
284 p_shared_by_partyid IN NUMBER := FND_API.G_MISS_NUM,
285 p_notes IN VARCHAR2,
286 x_return_status OUT NOCOPY VARCHAR2,
287 x_msg_count OUT NOCOPY NUMBER,
288 x_msg_data OUT NOCOPY VARCHAR2
289 );
290
291 PROCEDURE Notify_Shared_Cart (
292 p_api_version IN NUMBER,
293 p_init_msg_list IN VARCHAR2,
294 p_quote_access_rec IN Ibe_Quote_Saveshare_pvt.QUOTE_ACCESS_Rec_Type, --of the recepient
295 p_minisite_id IN NUMBER,
296 p_url IN VARCHAR2,
297 p_shared_by_party_id IN NUMBER := FND_API.G_MISS_NUM,
298 p_notes IN VARCHAR2,
299 x_return_status OUT NOCOPY VARCHAR2,
300 x_msg_count OUT NOCOPY NUMBER,
301 x_msg_data OUT NOCOPY VARCHAR2
302 );
303
304 PROCEDURE Notify_access_change(
305 p_api_version IN NUMBER,
306 p_init_msg_list IN VARCHAR2,
307 p_quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE, --of the recepient
308 p_minisite_id IN NUMBER,
309 p_url IN VARCHAR2,
310 p_old_accesslevel IN VARCHAR2,
311 p_shared_by_party_id IN NUMBER := FND_API.G_MISS_NUM,
312 p_notes IN VARCHAR2,
313 x_return_status OUT NOCOPY VARCHAR2,
314 x_msg_count OUT NOCOPY NUMBER,
315 x_msg_data OUT NOCOPY VARCHAR2
316 );
317
318 PROCEDURE Notify_view_shared_cart(
319 p_api_version IN NUMBER,
320 p_init_msg_list IN VARCHAR2,
321 p_quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE, --of the recepient
322 p_minisite_id IN NUMBER,
323 p_url IN VARCHAR2,
324 p_sent_by_party_id IN NUMBER ,
325 p_notes IN VARCHAR2,
326 p_owner_party_id IN NUMBER := FND_API.G_MISS_NUM,
327 x_return_status OUT NOCOPY VARCHAR2,
328 x_msg_count OUT NOCOPY NUMBER,
329 x_msg_data OUT NOCOPY VARCHAR2
330 );
331
332 PROCEDURE ParseThisString (
333 p_string_in IN VARCHAR2,
334 p_string_out OUT NOCOPY VARCHAR2,
335 p_string_left OUT NOCOPY VARCHAR2
336 );
337
338 PROCEDURE ParseThisString1 (
339 p_string_in IN VARCHAR2,
340 p_string_out OUT NOCOPY VARCHAR2,
341 p_string_left OUT NOCOPY VARCHAR2
342 );
343
344 FUNCTION AddSpaces (
345 p_num_in IN NUMBER
346 ) RETURN VARCHAR2;
347
348 PROCEDURE GenerateHeader(
349 document_id IN VARCHAR2,
350 display_type IN VARCHAR2,
351 document IN OUT NOCOPY VARCHAR2,
352 document_type IN OUT NOCOPY VARCHAR2
353 );
354
355 PROCEDURE GenerateDetail(
356 document_id IN VARCHAR2,
357 display_type IN VARCHAR2,
358 document IN OUT NOCOPY VARCHAR2,
359 document_type IN OUT NOCOPY VARCHAR2
360 );
361
362 PROCEDURE GenerateOrderDetailHeader(
363 document_id IN VARCHAR2,
364 display_type IN VARCHAR2,
365 document IN OUT NOCOPY VARCHAR2,
366 document_type IN OUT NOCOPY VARCHAR2
367 );
368
369 PROCEDURE GenerateReturnDetail(
370 P_item_key IN VARCHAR2,
371 p_tax_flag IN VARCHAR2,
372 x_document IN OUT NOCOPY VARCHAR2
373 );
374
375
376
377 --Quote_flag: To decide the context in which this API is called. If quote flag is true then the API will provide
378 --quote details else API will provide order details.
379 --Tax_Flag: If quote flag is true then the API will provide line details(of order or quote) with tax
380 --else API will provide line details without tax.
381 PROCEDURE Generate_Detail(
382 P_item_key IN VARCHAR2,
383 p_quote_flag IN VARCHAR2,
384 p_tax_flag IN VARCHAR2,
385 x_document OUT NOCOPY VARCHAR2
386 );
387 --Procedure to generate order line information in the notification with tax details.
388 --Document_type: HTML or Text.
389 --Document: the line detail text that is printed in the notification.
390 PROCEDURE Generate_order_Detail_wtax(
391 document_id IN VARCHAR2,
392 display_type IN VARCHAR2,
393 document IN OUT NOCOPY VARCHAR2,
394 document_type IN OUT NOCOPY VARCHAR2
395 );
396 --Procedure to generate order line information in the notification without tax details.
397 --Document_type: HTML or Text.
398 --Document: the line detail text that is printed in the notification.
399 PROCEDURE Generate_order_Detail_notax(
400 document_id IN VARCHAR2,
401 display_type IN VARCHAR2,
402 document IN OUT NOCOPY VARCHAR2,
403 document_type IN OUT NOCOPY VARCHAR2
404 );
405
406 --Procedure to generate quote line information in the notification with tax details.
407 --Document_type: HTML or Text.
408 --Document: the line detail text that is printed in the notification.
409
410 PROCEDURE Generate_quote_Detail_wtax(
411 document_id IN VARCHAR2,
412 display_type IN VARCHAR2,
413 document IN OUT NOCOPY VARCHAR2,
414 document_type IN OUT NOCOPY VARCHAR2
415 );
416
417 --Procedure to generate quote line information in the notification without tax details.
418 --Document_type: HTML or Text.
419 --Document: the line detail text that is printed in the notification.
420 PROCEDURE Generate_quote_Detail_notax(
421 document_id IN VARCHAR2,
422 display_type IN VARCHAR2,
423 document IN OUT NOCOPY VARCHAR2,
424 document_type IN OUT NOCOPY VARCHAR2
425 );
426
427 --Procedure to generate return order line information in the notification with tax details.
428 --Document_type: HTML or Text.
429 --Document: the return line detail text that is printed in the notification.
430
431 PROCEDURE Generate_rtn_ord_Detail_wtax(
432 document_id IN VARCHAR2,
433 display_type IN VARCHAR2,
434 document IN OUT NOCOPY VARCHAR2,
435 document_type IN OUT NOCOPY VARCHAR2
436 );
437
438 --Procedure to generate return order line information in the notification without tax details.
439 --Document_type: HTML or Text.
440 --Document: the return line detail text that is printed in the notification.
441
442 PROCEDURE Generate_rtn_ord_Detail_notax(
443 document_id IN VARCHAR2,
444 display_type IN VARCHAR2,
445 document IN OUT NOCOPY VARCHAR2,
446 document_type IN OUT NOCOPY VARCHAR2
447 );
448
449
450
451 PROCEDURE GenerateFooter(
452 document_id IN VARCHAR2,
453 display_type IN VARCHAR2,
454 document IN OUT NOCOPY VARCHAR2,
455 document_type IN OUT NOCOPY VARCHAR2
456 );
457
458 PROCEDURE GenerateQuoteHeader(
459 document_id IN VARCHAR2,
460 display_type IN VARCHAR2,
461 document IN OUT NOCOPY VARCHAR2,
462 document_type IN OUT NOCOPY VARCHAR2
463 );
464
465 PROCEDURE GenerateQuoteDetail(
466 document_id IN VARCHAR2,
467 display_type IN VARCHAR2,
468 document IN OUT NOCOPY VARCHAR2,
469 document_type IN OUT NOCOPY VARCHAR2
470 );
471
472 PROCEDURE GenerateQuoteFooter(
473 document_id IN VARCHAR2,
474 display_type IN VARCHAR2,
475 document IN OUT NOCOPY VARCHAR2,
476 document_type IN OUT NOCOPY VARCHAR2
477 );
478
479 PROCEDURE GenerateAssistHeader(
480 document_id IN VARCHAR2,
481 display_type IN VARCHAR2,
482 document IN OUT NOCOPY VARCHAR2,
483 document_type IN OUT NOCOPY VARCHAR2
484 );
485
486
487
488 PROCEDURE GetFirstName(
489 document_id IN VARCHAR2,
490 display_type IN VARCHAR2,
491 document IN OUT NOCOPY VARCHAR2,
492 document_type IN OUT NOCOPY VARCHAR2
493 );
494
495 PROCEDURE GetLastName(
496 document_id IN VARCHAR2,
497 display_type IN VARCHAR2,
498 document IN OUT NOCOPY VARCHAR2,
499 document_type IN OUT NOCOPY VARCHAR2
500 );
501
502
503 PROCEDURE GetTitle(
504 document_id IN VARCHAR2,
505 display_type IN VARCHAR2,
506 document IN OUT NOCOPY VARCHAR2,
507 document_type IN OUT NOCOPY VARCHAR2
508 );
509
510
511 PROCEDURE GetContractRef(
512 document_id IN VARCHAR2,
513 display_type IN VARCHAR2,
514 document IN OUT NOCOPY VARCHAR2,
515 document_type IN OUT NOCOPY VARCHAR2
516 );
517
518
519 PROCEDURE GetCartName(
520 document_id IN VARCHAR2,
521 display_type IN VARCHAR2,
522 document IN OUT NOCOPY VARCHAR2,
523 document_type IN OUT NOCOPY VARCHAR2
524 );
525
526
527
528 PROCEDURE Selector (
529 itemtype IN VARCHAR2,
530 itemkey IN VARCHAR2,
531 actid IN NUMBER,
532 funcmode IN VARCHAR2,
533 result OUT NOCOPY VARCHAR2
534 );
535
536
537 Procedure getUserType(
538 pPartyId IN NUMBER,
539 pUserType OUT NOCOPY Varchar2);
540
541 PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
542 p_user_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
543 p_sharee_number IN NUMBER := null ,
544 x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
545 x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
546 x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE);
547
548 --added by abhandar 08/26/2003:new procedure
549 PROCEDURE Generate_Approval_Msg(
550 document_id IN VARCHAR2,
551 display_type IN VARCHAR2,
552 document IN OUT NOCOPY VARCHAR2,
553 document_type IN OUT NOCOPY VARCHAR2
554 );
555
556 PROCEDURE Generate_Credential_Msg(
557 document_id IN VARCHAR2,
558 display_type IN VARCHAR2,
559 document IN OUT NOCOPY VARCHAR2,
560 document_type IN OUT NOCOPY VARCHAR2
561 );
562
563 PROCEDURE get_speciality_store_name(
564 document_id IN VARCHAR2,
565 display_type IN VARCHAR2,
566 document IN OUT NOCOPY VARCHAR2,
567 document_type IN OUT NOCOPY VARCHAR2
568 );
569
570 PROCEDURE get_fnd_lkpup_value(
571 document_id IN VARCHAR2,
572 display_type IN VARCHAR2,
573 document IN OUT NOCOPY VARCHAR2,
574 document_type IN OUT NOCOPY VARCHAR2
575 );
576
577 PROCEDURE get_FND_message(
578 document_id IN VARCHAR2,
579 display_type IN VARCHAR2,
580 document IN OUT NOCOPY VARCHAR2,
581 document_type IN OUT NOCOPY VARCHAR2
582 );
583
584 PROCEDURE get_date(
585 document_id IN VARCHAR2,
586 display_type IN VARCHAR2,
587 document IN OUT NOCOPY VARCHAR2,
588 document_type IN OUT NOCOPY VARCHAR2
589 );
590
591 PROCEDURE get_sales_assist_rsn_meaning(
592 document_id IN VARCHAR2,
593 display_type IN VARCHAR2,
594 document IN OUT NOCOPY VARCHAR2,
595 document_type IN OUT NOCOPY VARCHAR2
596 );
597
598 TYPE NotifLineType is Record
599 (
600 Action VARCHAR2(30),
601 Product VARCHAR2(495),
602 UOM VARCHAR2(25),
603 Quantity NUMBER,
604 Shippable VARCHAR2(1),
605 NetAmount NUMBER,
606 Periodicity VARCHAR2(37),
607 TaxAmount NUMBER,
608 LastItem VARCHAR2(1));
609 TYPE Notif_Line_Tbl_Type IS table OF NotifLineType INDEX BY BINARY_INTEGER;
610
611 FUNCTION buildDocument
612 (
613 notif_line_tbl IN Notif_Line_Tbl_Type,
614 view_net_price_flag VARCHAR2,
615 view_line_type_flag VARCHAR2,
616 tax_flag VARCHAR2
617 ) return VARCHAR2;
618
619 PROCEDURE ParseString (
620 p_string_in IN VARCHAR2,
621 p_string_len IN NUMBER := 12,
622 p_string_out OUT NOCOPY VARCHAR2,
623 p_string_left OUT NOCOPY VARCHAR2
624 );
625
626 END ibe_workflow_pvt;
[Home] [Help]