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
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: );
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:
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;
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
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 ,
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 ,
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 ,
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 ,