DBA Data[Home] [Help]

APPS.AMV_STOCK_PVT dependencies on FND_API

Line 67: -- Default = FND_API.G_FALSE

63: -- Function : Returns the list of tickers for an user
64: -- Parameters :
65: -- IN p_api_version IN NUMBER Required
66: -- p_init_msg_list IN VARCHAR2 Optional
67: -- Default = FND_API.G_FALSE
68: -- p_validation_level IN NUMBER Optional
69: -- Default = FND_API.G_VALID_LEVEL_FULL
70: -- p_user_id IN NUMBER Required
71: -- p_sort_order IN VARCHAR2 Optional

Line 69: -- Default = FND_API.G_VALID_LEVEL_FULL

65: -- IN p_api_version IN NUMBER Required
66: -- p_init_msg_list IN VARCHAR2 Optional
67: -- Default = FND_API.G_FALSE
68: -- p_validation_level IN NUMBER Optional
69: -- Default = FND_API.G_VALID_LEVEL_FULL
70: -- p_user_id IN NUMBER Required
71: -- p_sort_order IN VARCHAR2 Optional
72: -- OUT : x_return_status OUT VARCHAR2
73: -- x_msg_count OUT NUMBER

Line 85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

81: -- End of comments
82: --
83: PROCEDURE Get_UserTicker
84: ( p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,

Line 86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

82: --
83: PROCEDURE Get_UserTicker
84: ( p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,
90: p_user_id IN NUMBER,

Line 91: p_distinct_stocks IN VARCHAR2 := FND_API.G_FALSE,

87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,
90: p_user_id IN NUMBER,
91: p_distinct_stocks IN VARCHAR2 := FND_API.G_FALSE,
92: p_sort_order IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: x_stkpr_array OUT NOCOPY AMV_STK_VARRAY_TYPE
94: );
95: --------------------------------------------------------------------------------

Line 92: p_sort_order IN VARCHAR2 := FND_API.G_MISS_CHAR,

88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,
90: p_user_id IN NUMBER,
91: p_distinct_stocks IN VARCHAR2 := FND_API.G_FALSE,
92: p_sort_order IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: x_stkpr_array OUT NOCOPY AMV_STK_VARRAY_TYPE
94: );
95: --------------------------------------------------------------------------------
96: --------------------------------------------------------------------------------

Line 105: -- Default = FND_API.G_FALSE

101: -- Function : Returns the ticker details for list of stocks
102: -- Parameters :
103: -- IN p_api_version IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional
105: -- Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional
107: -- Default = FND_API.G_VALID_LEVEL_FULL
108: -- p_symbols IN VARCHAR2 Required
109: -- OUT : x_return_status OUT VARCHAR2

Line 107: -- Default = FND_API.G_VALID_LEVEL_FULL

103: -- IN p_api_version IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional
105: -- Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional
107: -- Default = FND_API.G_VALID_LEVEL_FULL
108: -- p_symbols IN VARCHAR2 Required
109: -- OUT : x_return_status OUT VARCHAR2
110: -- x_msg_count OUT NUMBER
111: -- x_msg_data OUT VARCHAR2

Line 122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

118: -- End of comments
119: --
120: PROCEDURE Get_StockDetails
121: ( p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,

Line 123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

119: --
120: PROCEDURE Get_StockDetails
121: ( p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_symbols IN VARCHAR2,

Line 140: -- Default = FND_API.G_FALSE

136: -- Function : Update the tickers for an user
137: -- Parameters :
138: -- IN p_api_version IN NUMBER Required
139: -- p_init_msg_list IN VARCHAR2 Optional
140: -- Default = FND_API.G_FALSE
141: -- p_commit IN VARCHAR2 Optional
142: -- Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional
144: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 142: -- Default = FND_API.G_FALSE

138: -- IN p_api_version IN NUMBER Required
139: -- p_init_msg_list IN VARCHAR2 Optional
140: -- Default = FND_API.G_FALSE
141: -- p_commit IN VARCHAR2 Optional
142: -- Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional
144: -- Default = FND_API.G_VALID_LEVEL_FULL
145: -- p_object_version_number IN NUMBER Required
146: -- object version number

Line 144: -- Default = FND_API.G_VALID_LEVEL_FULL

140: -- Default = FND_API.G_FALSE
141: -- p_commit IN VARCHAR2 Optional
142: -- Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional
144: -- Default = FND_API.G_VALID_LEVEL_FULL
145: -- p_object_version_number IN NUMBER Required
146: -- object version number
147: -- p_user_id IN NUMBER Required
148: -- user id.

Line 163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

159: -- End of comments
160: --
161: PROCEDURE Update_UserTicker
162: ( p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,

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

160: --
161: PROCEDURE Update_UserTicker
162: ( p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,

Line 165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

161: PROCEDURE Update_UserTicker
162: ( p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_object_version_number IN NUMBER,

Line 184: -- Default = FND_API.G_FALSE

180: -- been identified
181: -- Parameters :
182: -- IN p_api_version IN NUMBER Required
183: -- p_init_msg_list IN VARCHAR2 Optional
184: -- Default = FND_API.G_FALSE
185: -- p_validation_level IN NUMBER Optional
186: -- Default = FND_API.G_VALID_LEVEL_FULL
187: -- p_vendor_id IN NUMBER Required
188: -- vendor id.

Line 186: -- Default = FND_API.G_VALID_LEVEL_FULL

182: -- IN p_api_version IN NUMBER Required
183: -- p_init_msg_list IN VARCHAR2 Optional
184: -- Default = FND_API.G_FALSE
185: -- p_validation_level IN NUMBER Optional
186: -- Default = FND_API.G_VALID_LEVEL_FULL
187: -- p_vendor_id IN NUMBER Required
188: -- vendor id.
189: -- p_start_index IN NUMBER Optional
190: -- Default = 1

Line 192: -- Default = FND_API.G_MISS_NUM

188: -- vendor id.
189: -- p_start_index IN NUMBER Optional
190: -- Default = 1
191: -- p_batch_size IN NUMBER Optional
192: -- Default = FND_API.G_MISS_NUM
193: -- batch size of keys.
194: -- OUT : x_return_status OUT VARCHAR2
195: -- x_msg_count OUT NUMBER
196: -- x_msg_data OUT VARCHAR2

Line 208: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

204: -- End of comments
205: --
206: PROCEDURE Get_VendorMissedStocks
207: ( p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,

Line 209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

205: --
206: PROCEDURE Get_VendorMissedStocks
207: ( p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_vendor_id IN NUMBER,

Line 215: p_batch_size IN NUMBER := FND_API.G_MISS_NUM,

211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_vendor_id IN NUMBER,
214: p_start_index IN NUMBER := 1,
215: p_batch_size IN NUMBER := FND_API.G_MISS_NUM,
216: x_stocks_array OUT NOCOPY AMV_SYM_VARRAY_TYPE
217: );
218: --------------------------------------------------------------------------------
219: --------------------------------------------------------------------------------

Line 228: -- Default = FND_API.G_FALSE

224: -- Function : Inserts the Stock id and the vendor id and key id for vendor
225: -- Parameters :
226: -- IN p_api_version IN NUMBER Required
227: -- p_init_msg_list IN VARCHAR2 Optional
228: -- Default = FND_API.G_FALSE
229: -- p_commit IN VARCHAR2 Optional
230: -- Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional
232: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 230: -- Default = FND_API.G_FALSE

226: -- IN p_api_version IN NUMBER Required
227: -- p_init_msg_list IN VARCHAR2 Optional
228: -- Default = FND_API.G_FALSE
229: -- p_commit IN VARCHAR2 Optional
230: -- Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional
232: -- Default = FND_API.G_VALID_LEVEL_FULL
233: -- p_vendor_id IN NUMBER Required
234: -- vendor id.

Line 232: -- Default = FND_API.G_VALID_LEVEL_FULL

228: -- Default = FND_API.G_FALSE
229: -- p_commit IN VARCHAR2 Optional
230: -- Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional
232: -- Default = FND_API.G_VALID_LEVEL_FULL
233: -- p_vendor_id IN NUMBER Required
234: -- vendor id.
235: -- p_ticker_rec IN AMV_TKR_OBJ_TYPE Required
236: -- ticker array (ric and key id).

Line 249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

245: -- End of comments
246: --
247: PROCEDURE Insert_StockVendorKeys
248: ( p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,

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

246: --
247: PROCEDURE Insert_StockVendorKeys
248: ( p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,

Line 251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

247: PROCEDURE Insert_StockVendorKeys
248: ( p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_vendor_id IN NUMBER,

Line 268: -- Default = FND_API.G_FALSE

264: -- Function : Gives an array of all the stocks selected by all users
265: -- Parameters :
266: -- IN p_api_version IN NUMBER Required
267: -- p_init_msg_list IN VARCHAR2 Optional
268: -- Default = FND_API.G_FALSE
269: -- p_validation_level IN NUMBER Optional
270: -- Default = FND_API.G_VALID_LEVEL_FULL
271: -- p_vendor_id IN NUMBER Required
272: -- vendor id

Line 270: -- Default = FND_API.G_VALID_LEVEL_FULL

266: -- IN p_api_version IN NUMBER Required
267: -- p_init_msg_list IN VARCHAR2 Optional
268: -- Default = FND_API.G_FALSE
269: -- p_validation_level IN NUMBER Optional
270: -- Default = FND_API.G_VALID_LEVEL_FULL
271: -- p_vendor_id IN NUMBER Required
272: -- vendor id
273: -- OUT : x_return_status OUT VARCHAR2
274: -- x_msg_count OUT NUMBER

Line 287: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

283: -- End of comments
284: --
285: PROCEDURE Get_UserSelectedKeys
286: ( p_api_version IN NUMBER,
287: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
289: x_return_status OUT NOCOPY VARCHAR2,
290: x_msg_count OUT NOCOPY NUMBER,
291: x_msg_data OUT NOCOPY VARCHAR2,

Line 288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

284: --
285: PROCEDURE Get_UserSelectedKeys
286: ( p_api_version IN NUMBER,
287: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
289: x_return_status OUT NOCOPY VARCHAR2,
290: x_msg_count OUT NOCOPY NUMBER,
291: x_msg_data OUT NOCOPY VARCHAR2,
292: p_vendor_id IN NUMBER,

Line 293: p_all_keys IN VARCHAR2 := FND_API.G_FALSE,

289: x_return_status OUT NOCOPY VARCHAR2,
290: x_msg_count OUT NOCOPY NUMBER,
291: x_msg_data OUT NOCOPY VARCHAR2,
292: p_vendor_id IN NUMBER,
293: p_all_keys IN VARCHAR2 := FND_API.G_FALSE,
294: x_keys_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
295: );
296: --------------------------------------------------------------------------------
297: --------------------------------------------------------------------------------

Line 306: -- Default = FND_API.G_FALSE

302: -- Function : Inserts News in to the vendor news table
303: -- Parameters :
304: -- IN p_api_version IN NUMBER Required
305: -- p_init_msg_list IN VARCHAR2 Optional
306: -- Default = FND_API.G_FALSE
307: -- p_commit IN VARCHAR2 Optional
308: -- Default = FND_API.G_FALSE
309: -- p_validation_level IN NUMBER Optional
310: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 308: -- Default = FND_API.G_FALSE

304: -- IN p_api_version IN NUMBER Required
305: -- p_init_msg_list IN VARCHAR2 Optional
306: -- Default = FND_API.G_FALSE
307: -- p_commit IN VARCHAR2 Optional
308: -- Default = FND_API.G_FALSE
309: -- p_validation_level IN NUMBER Optional
310: -- Default = FND_API.G_VALID_LEVEL_FULL
311: -- p_vendor_id IN NUMBER Required
312: -- vendor id.

Line 310: -- Default = FND_API.G_VALID_LEVEL_FULL

306: -- Default = FND_API.G_FALSE
307: -- p_commit IN VARCHAR2 Optional
308: -- Default = FND_API.G_FALSE
309: -- p_validation_level IN NUMBER Optional
310: -- Default = FND_API.G_VALID_LEVEL_FULL
311: -- p_vendor_id IN NUMBER Required
312: -- vendor id.
313: -- p_news_rec IN AMV_NEWS_OBJ_TYPE Required
314: -- array of news objects.

Line 327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

323: -- End of comments
324: --
325: PROCEDURE Insert_VendorNews
326: ( p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,

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

324: --
325: PROCEDURE Insert_VendorNews
326: ( p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,
332: x_msg_data OUT NOCOPY VARCHAR2,

Line 329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

325: PROCEDURE Insert_VendorNews
326: ( p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,
332: x_msg_data OUT NOCOPY VARCHAR2,
333: p_vendor_id IN NUMBER,

Line 346: -- Default = FND_API.G_FALSE

342: -- Function : Inserts News in to the vendor news table
343: -- Parameters :
344: -- IN p_api_version IN NUMBER Required
345: -- p_init_msg_list IN VARCHAR2 Optional
346: -- Default = FND_API.G_FALSE
347: -- p_commit IN VARCHAR2 Optional
348: -- Default = FND_API.G_FALSE
349: -- p_validation_level IN NUMBER Optional
350: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 348: -- Default = FND_API.G_FALSE

344: -- IN p_api_version IN NUMBER Required
345: -- p_init_msg_list IN VARCHAR2 Optional
346: -- Default = FND_API.G_FALSE
347: -- p_commit IN VARCHAR2 Optional
348: -- Default = FND_API.G_FALSE
349: -- p_validation_level IN NUMBER Optional
350: -- Default = FND_API.G_VALID_LEVEL_FULL
351: -- p_vendor_id IN NUMBER Required
352: -- vendor id.

Line 350: -- Default = FND_API.G_VALID_LEVEL_FULL

346: -- Default = FND_API.G_FALSE
347: -- p_commit IN VARCHAR2 Optional
348: -- Default = FND_API.G_FALSE
349: -- p_validation_level IN NUMBER Optional
350: -- Default = FND_API.G_VALID_LEVEL_FULL
351: -- p_vendor_id IN NUMBER Required
352: -- vendor id.
353: -- OUT : x_return_status OUT VARCHAR2
354: -- x_msg_count OUT NUMBER

Line 367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

363: -- End of comments
364: --
365: PROCEDURE Get_CompanyNews
366: (p_api_version IN NUMBER,
367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
368: p_commit IN VARCHAR2 := FND_API.G_FALSE,
369: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_msg_count OUT NOCOPY NUMBER,

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

364: --
365: PROCEDURE Get_CompanyNews
366: (p_api_version IN NUMBER,
367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
368: p_commit IN VARCHAR2 := FND_API.G_FALSE,
369: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_msg_count OUT NOCOPY NUMBER,
372: x_msg_data OUT NOCOPY VARCHAR2,

Line 369: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

365: PROCEDURE Get_CompanyNews
366: (p_api_version IN NUMBER,
367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
368: p_commit IN VARCHAR2 := FND_API.G_FALSE,
369: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_msg_count OUT NOCOPY NUMBER,
372: x_msg_data OUT NOCOPY VARCHAR2,
373: p_stock_id IN NUMBER,