1 PACKAGE IBE_Shop_List_MGMT_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVQOCSLS.pls 120.1 2010/11/19 08:39:17 amaheshw noship $ */
3
4 PROCEDURE Save_New_ShopList(
5 p_api_version IN NUMBER := 1 ,
6 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
7 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
8 x_return_status OUT NOCOPY VARCHAR2 ,
9 x_msg_count OUT NOCOPY NUMBER ,
10 x_msg_data OUT NOCOPY VARCHAR2 ,
11 p_inventory_item_id IN JTF_Number_Table ,
12 p_org_id IN NUMBER ,
13 p_qty IN NUMBER ,
14 p_uom IN JTF_Varchar2_Table_100 ,
15 p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
16 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
17 p_mode IN VARCHAR2 := 'MERGE' ,
18 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
19 p_sl_header_rec IN IBE_Shop_List_PVT.SL_Header_Rec_Type ,
20 x_sl_header_id OUT NOCOPY NUMBER ,
21 p_item_type_code IN JTF_Varchar2_Table_100
22 );
23
24 PROCEDURE Save_New_ShopList(
25 p_api_version IN NUMBER := 1 ,
26 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
27 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
28 x_return_status OUT NOCOPY VARCHAR2 ,
29 x_msg_count OUT NOCOPY NUMBER ,
30 x_msg_data OUT NOCOPY VARCHAR2 ,
31 p_inventory_item_id IN JTF_Number_Table ,
32 p_org_id IN NUMBER ,
33 p_qty IN NUMBER ,
34 p_uom IN JTF_Varchar2_Table_100 ,
35 p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
36 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
37 p_mode IN VARCHAR2 := 'MERGE' ,
38 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
39 p_party_id IN NUMBER ,
40 p_cust_account_id IN NUMBER ,
41 p_shopping_list_name IN VARCHAR2 ,
42 p_list_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
43
44 x_sl_header_id OUT NOCOPY NUMBER ,
45 p_item_type_code IN JTF_Varchar2_Table_100
46 );
47
48 PROCEDURE Add_Item_to_ShopList(
49 p_api_version IN NUMBER := 1 ,
50 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
51 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
52 x_return_status OUT NOCOPY VARCHAR2 ,
53 x_msg_count OUT NOCOPY NUMBER ,
54 x_msg_data OUT NOCOPY VARCHAR2 ,
55 p_inventory_item_id IN JTF_Number_Table ,
56 p_org_id IN NUMBER ,
57 p_qty IN NUMBER ,
58 p_uom IN JTF_Varchar2_Table_100 ,
59 p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
60 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
61 p_mode IN VARCHAR2 := 'MERGE' ,
62 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
63 p_party_id IN NUMBER ,
64 p_cust_account_id IN NUMBER ,
65 p_shopping_list_name IN VARCHAR2 ,
66 p_list_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
67
68 x_sl_header_id OUT NOCOPY NUMBER ,
69 p_shp_list_id IN NUMBER ,
70 p_item_type_code IN JTF_Varchar2_Table_100
71 );
72
73 END IBE_Shop_List_MGMT_PVT;
74