DBA Data[Home] [Help]

APPS.IBE_SHOP_LIST_MGMT_PVT dependencies on FND_API

Line 5: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

1: PACKAGE BODY IBE_Shop_List_MGMT_PVT AS
2: /* $Header: IBEVQOCSLB.pls 120.1 2010/11/19 08:41:05 amaheshw noship $ */
3: PROCEDURE Save_New_ShopList(
4: p_api_version IN NUMBER := 1 ,
5: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
6: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
7: x_return_status OUT NOCOPY VARCHAR2 ,
8: x_msg_count OUT NOCOPY NUMBER ,
9: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 6: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

2: /* $Header: IBEVQOCSLB.pls 120.1 2010/11/19 08:41:05 amaheshw noship $ */
3: PROCEDURE Save_New_ShopList(
4: p_api_version IN NUMBER := 1 ,
5: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
6: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
7: x_return_status OUT NOCOPY VARCHAR2 ,
8: x_msg_count OUT NOCOPY NUMBER ,
9: x_msg_data OUT NOCOPY VARCHAR2 ,
10: p_inventory_item_id IN JTF_Number_Table ,

Line 14: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,

10: p_inventory_item_id IN JTF_Number_Table ,
11: p_org_id IN NUMBER ,
12: p_qty IN NUMBER ,
13: p_uom IN JTF_Varchar2_Table_100 ,
14: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
15: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
16: p_mode IN VARCHAR2 := 'MERGE' ,
17: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: p_sl_header_rec IN IBE_Shop_List_PVT.SL_Header_Rec_Type ,

Line 15: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

11: p_org_id IN NUMBER ,
12: p_qty IN NUMBER ,
13: p_uom IN JTF_Varchar2_Table_100 ,
14: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
15: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
16: p_mode IN VARCHAR2 := 'MERGE' ,
17: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: p_sl_header_rec IN IBE_Shop_List_PVT.SL_Header_Rec_Type ,
19: x_sl_header_id OUT NOCOPY NUMBER ,

Line 17: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,

13: p_uom IN JTF_Varchar2_Table_100 ,
14: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
15: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
16: p_mode IN VARCHAR2 := 'MERGE' ,
17: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: p_sl_header_rec IN IBE_Shop_List_PVT.SL_Header_Rec_Type ,
19: x_sl_header_id OUT NOCOPY NUMBER ,
20: p_item_type_code IN JTF_Varchar2_Table_100
21: ) IS

Line 61: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

57:
58:
59: PROCEDURE Save_New_ShopList(
60: p_api_version IN NUMBER := 1 ,
61: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
62: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
63: x_return_status OUT NOCOPY VARCHAR2 ,
64: x_msg_count OUT NOCOPY NUMBER ,
65: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 62: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

58:
59: PROCEDURE Save_New_ShopList(
60: p_api_version IN NUMBER := 1 ,
61: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
62: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
63: x_return_status OUT NOCOPY VARCHAR2 ,
64: x_msg_count OUT NOCOPY NUMBER ,
65: x_msg_data OUT NOCOPY VARCHAR2 ,
66: p_inventory_item_id IN JTF_Number_Table ,

Line 70: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,

66: p_inventory_item_id IN JTF_Number_Table ,
67: p_org_id IN NUMBER ,
68: p_qty IN NUMBER ,
69: p_uom IN JTF_Varchar2_Table_100 ,
70: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
71: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
72: p_mode IN VARCHAR2 := 'MERGE' ,
73: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_party_id IN NUMBER ,

Line 71: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

67: p_org_id IN NUMBER ,
68: p_qty IN NUMBER ,
69: p_uom IN JTF_Varchar2_Table_100 ,
70: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
71: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
72: p_mode IN VARCHAR2 := 'MERGE' ,
73: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_party_id IN NUMBER ,
75: p_cust_account_id IN NUMBER ,

Line 73: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,

69: p_uom IN JTF_Varchar2_Table_100 ,
70: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
71: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
72: p_mode IN VARCHAR2 := 'MERGE' ,
73: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_party_id IN NUMBER ,
75: p_cust_account_id IN NUMBER ,
76: p_shopping_list_name IN VARCHAR2 ,
77: p_list_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 77: p_list_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

73: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_party_id IN NUMBER ,
75: p_cust_account_id IN NUMBER ,
76: p_shopping_list_name IN VARCHAR2 ,
77: p_list_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
78:
79: x_sl_header_id OUT NOCOPY NUMBER ,
80: p_item_type_code IN JTF_Varchar2_Table_100
81: ) IS

Line 117: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

113: end Save_New_ShopList;
114:
115: PROCEDURE Add_Item_to_ShopList(
116: p_api_version IN NUMBER := 1 ,
117: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
119: x_return_status OUT NOCOPY VARCHAR2 ,
120: x_msg_count OUT NOCOPY NUMBER ,
121: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 118: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

114:
115: PROCEDURE Add_Item_to_ShopList(
116: p_api_version IN NUMBER := 1 ,
117: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
119: x_return_status OUT NOCOPY VARCHAR2 ,
120: x_msg_count OUT NOCOPY NUMBER ,
121: x_msg_data OUT NOCOPY VARCHAR2 ,
122: p_inventory_item_id IN JTF_Number_Table ,

Line 126: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,

122: p_inventory_item_id IN JTF_Number_Table ,
123: p_org_id IN NUMBER ,
124: p_qty IN NUMBER ,
125: p_uom IN JTF_Varchar2_Table_100 ,
126: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
127: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
128: p_mode IN VARCHAR2 := 'MERGE' ,
129: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_party_id IN NUMBER ,

Line 127: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

123: p_org_id IN NUMBER ,
124: p_qty IN NUMBER ,
125: p_uom IN JTF_Varchar2_Table_100 ,
126: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
127: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
128: p_mode IN VARCHAR2 := 'MERGE' ,
129: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_party_id IN NUMBER ,
131: p_cust_account_id IN NUMBER ,

Line 129: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,

125: p_uom IN JTF_Varchar2_Table_100 ,
126: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
127: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
128: p_mode IN VARCHAR2 := 'MERGE' ,
129: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_party_id IN NUMBER ,
131: p_cust_account_id IN NUMBER ,
132: p_shopping_list_name IN VARCHAR2 ,
133: p_list_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 133: p_list_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

129: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_party_id IN NUMBER ,
131: p_cust_account_id IN NUMBER ,
132: p_shopping_list_name IN VARCHAR2 ,
133: p_list_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
134:
135: x_sl_header_id OUT NOCOPY NUMBER,
136: p_shp_list_id IN NUMBER ,
137: p_item_type_code IN JTF_Varchar2_Table_100