[Home] [Help]
PACKAGE: APPS.IBE_CART_NOTIFY_UTIL
Source
1 PACKAGE IBE_CART_NOTIFY_UTIL AUTHID CURRENT_USER AS
2 /* $Header: IBEVCNUS.pls 115.3 2002/12/13 02:52:28 mannamra ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_CART_NOTIFY_UTIL';
5
6 TYPE notify_line_tokens_rec_type IS RECORD
7 (
8 Quote_line_id NUMBER := FND_API.G_MISS_NUM,
9 Item_name VARCHAR2(240):= FND_API.G_MISS_CHAR,
10 Item_Quantity NUMBER := FND_API.G_MISS_NUM,
11 Shippable_flag VARCHAR2(10) := FND_API.G_MISS_CHAR,
12 Line_quote_price NUMBER := FND_API.G_MISS_NUM
13 );
14
15 G_MISS_notify_line_tokens_rec notify_line_tokens_rec_type;
16 TYPE notify_line_tokens_tab_type IS TABLE OF notify_line_tokens_rec_type
17 INDEX BY BINARY_INTEGER;
18 G_MISS_notify_line_tokens_tab notify_line_tokens_tab_type;
19
20 PROCEDURE Get_sales_assist_hdr_tokens(
21 p_api_version IN NUMBER := 1.0 ,
22 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
23 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
24 x_return_status OUT NOCOPY VARCHAR2 ,
25 x_msg_count OUT NOCOPY NUMBER ,
26 x_msg_data OUT NOCOPY VARCHAR2 ,
27 p_quote_header_id IN NUMBER ,
28 p_minisite_id IN NUMBER ,
29 x_Contact_Name OUT NOCOPY VARCHAR2 ,
30 x_Contact_phone OUT NOCOPY VARCHAR2 ,
31 x_email OUT NOCOPY VARCHAR2 ,
32 x_first_name OUT NOCOPY VARCHAR2 ,
33 X_last_name OUT NOCOPY VARCHAR2 ,
34 x_Cart_name OUT NOCOPY VARCHAR2 ,
35 X_cart_date OUT NOCOPY VARCHAR2 ,
36 x_Ship_to_name OUT NOCOPY VARCHAR2 ,
37 x_ship_to_address1 OUT NOCOPY VARCHAR2 ,
38 x_ship_to_address2 OUT NOCOPY VARCHAR2 ,
39 x_ship_to_address3 OUT NOCOPY VARCHAR2 ,
40 x_ship_to_address4 OUT NOCOPY VARCHAR2 ,
41 x_country OUT NOCOPY VARCHAR2 ,
42 X_CITY OUT NOCOPY VARCHAR2 ,
43 X_POSTAL_CODE OUT NOCOPY VARCHAR2 ,
44 X_SHIP_TO_STATE OUT NOCOPY VARCHAR2 ,
45 X_SHIP_TO_PROVINCE OUT NOCOPY VARCHAR2 ,
46 X_SHIP_TO_COUNTY OUT NOCOPY VARCHAR2 ,
47 x_shipping_method OUT NOCOPY VARCHAR2 ,
48 x_minisite_name OUT NOCOPY VARCHAR2 ,
49 x_ship_and_hand OUT NOCOPY NUMBER ,
50 x_tax OUT NOCOPY NUMBER ,
51 x_total OUT NOCOPY NUMBER );
52
53 PROCEDURE Get_sales_assist_line_tokens(
54 p_api_version IN NUMBER := 1.0 ,
55 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
56 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
57 x_return_status OUT NOCOPY VARCHAR2 ,
58 x_msg_count OUT NOCOPY NUMBER ,
59 x_msg_data OUT NOCOPY VARCHAR2 ,
60 P_quote_header_id IN NUMBER ,
61 x_notify_line_tokens OUT NOCOPY IBE_CART_NOTIFY_UTIL.notify_line_tokens_tab_type);
62
63 END IBE_CART_NOTIFY_UTIL;