APPS.IBE_CART_NOTIFY_UTIL dependencies on IBE_CART_NOTIFY_UTIL

Line 1: PACKAGE BODY IBE_CART_NOTIFY_UTIL AS

1: PACKAGE BODY IBE_CART_NOTIFY_UTIL AS
2: /* $Header: IBEVCNUB.pls 120.3 2005/12/15 00:55:31 banatara ship $ */
3: -- Start of Comments
4: -- Package name : IBE_Cart_Notify_Util
5: -- Purpose :

Line 4: -- Package name : IBE_Cart_Notify_Util

1: PACKAGE BODY IBE_CART_NOTIFY_UTIL AS
2: /* $Header: IBEVCNUB.pls 120.3 2005/12/15 00:55:31 banatara ship $ */
3: -- Start of Comments
4: -- Package name : IBE_Cart_Notify_Util
5: -- Purpose :
6: -- NOTE :
7: -- End of Comments
8:

Line 9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_CART_NOTIFY_UTIL';

5: -- Purpose :
6: -- NOTE :
7: -- End of Comments
8:
9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_CART_NOTIFY_UTIL';
10: G_FILE_NAME CONSTANT VARCHAR2(12) := 'IBEVCNUB.pls';
11:
12: PROCEDURE Get_sales_assist_hdr_tokens(
13: p_api_version IN NUMBER := 1.0 ,

Line 113: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_CART_NOTIFY_UTIL';

109: and fnd.customer_id = ap.party_id
110: and h.status = 'A';
111:
112:
113: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_CART_NOTIFY_UTIL';
114: l_api_name CONSTANT VARCHAR2(50) := 'Get_sales_assist_tokens_pvt';
115: l_api_version number := 1.0;
116:
117: l_ship_to_cust_name varchar2(360);

Line 262: x_notify_line_tokens OUT NOCOPY IBE_CART_NOTIFY_UTIL.notify_line_tokens_tab_type) is

258: x_return_status OUT NOCOPY VARCHAR2 ,
259: x_msg_count OUT NOCOPY NUMBER ,
260: x_msg_data OUT NOCOPY VARCHAR2 ,
261: P_quote_header_id IN NUMBER ,
262: x_notify_line_tokens OUT NOCOPY IBE_CART_NOTIFY_UTIL.notify_line_tokens_tab_type) is
263:
264: CURSOR c_get_notify_line_tokens(p_quote_header_id number) is
265: SELECT qh.quote_header_id,
266: ql.quote_line_id,

Line 281: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_CART_NOTIFY_UTIL';

277: and ql.inventory_item_id = m.inventory_item_id
278: and ql.organization_id = m.organization_id
279: and qh.quote_header_id = p_quote_header_id;
280:
281: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_CART_NOTIFY_UTIL';
282: l_api_name CONSTANT VARCHAR2(100) := 'Get_sales_assist_line_tokens';
283: l_api_version number := 1.0;
284: loop_counter number := 1;
285: l_notify_line_tokens IBE_CART_NOTIFY_UTIL.notify_line_tokens_tab_type;

Line 285: l_notify_line_tokens IBE_CART_NOTIFY_UTIL.notify_line_tokens_tab_type;

281: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_CART_NOTIFY_UTIL';
282: l_api_name CONSTANT VARCHAR2(100) := 'Get_sales_assist_line_tokens';
283: l_api_version number := 1.0;
284: loop_counter number := 1;
285: l_notify_line_tokens IBE_CART_NOTIFY_UTIL.notify_line_tokens_tab_type;
286:
287: BEGIN
288:
289: -- Standard Start of API savepoint

Line 356: END IBE_CART_NOTIFY_UTIL;

352: p_count => x_msg_count ,
353: p_data => x_msg_data);
354:
355: END Get_sales_assist_line_tokens;
356: END IBE_CART_NOTIFY_UTIL;
357: