DBA Data[Home] [Help]

APPS.IBE_SHOP_LIST_MGMT_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 13: p_uom IN JTF_Varchar2_Table_100 ,

9: x_msg_data OUT NOCOPY VARCHAR2 ,
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,

Line 20: p_item_type_code IN JTF_Varchar2_Table_100

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
22:
23: l_sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type
24: := IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;

Line 69: p_uom IN JTF_Varchar2_Table_100 ,

65: x_msg_data OUT NOCOPY VARCHAR2 ,
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,

Line 80: p_item_type_code IN JTF_Varchar2_Table_100

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
82: p_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type := IBE_Shop_List_PVT.G_MISS_SL_HEADER_REC;
83:
84:

Line 125: p_uom IN JTF_Varchar2_Table_100 ,

121: x_msg_data OUT NOCOPY VARCHAR2 ,
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,

Line 137: p_item_type_code IN JTF_Varchar2_Table_100

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
138:
139: ) IS
140: p_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type := IBE_Shop_List_PVT.G_MISS_SL_HEADER_REC;
141: