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
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
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,
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,
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: --------------------------------------------------------------------------------
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: --------------------------------------------------------------------------------
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
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
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,
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,
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
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
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.
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,
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,
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,
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.
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
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
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,
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,
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: --------------------------------------------------------------------------------
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
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.
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).
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,
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,
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,
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
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
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,
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,
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: --------------------------------------------------------------------------------
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
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.
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.
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,
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,
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,
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
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.
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
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,
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,
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,