APPS.AMV_STOCK_PVT dependencies on AMV_USER_TICKER

Line 98: UPDATE amv_user_ticker

94: OPEN Get_StockId;
95: FETCH Get_StockId INTO l_stock_id;
96: CLOSE Get_StockId;
97:
98: UPDATE amv_user_ticker
99: SET last_update_date = sysdate + i
100: WHERE user_id = p_user_id
101: AND stock_id = l_stock_id;
102: --

Line 138: from amv_user_ticker amut

134: CURSOR Get_UserSymbols_csr IS
135: select amut.user_ticker_id
136: , amst.stock_symbol
137: , l_null
138: from amv_user_ticker amut
139: , amv_stocks amst
140: where amut.user_id = p_user_id
141: and amut.stock_id = amst.stock_id;
142:

Line 329: SELECT amv_user_ticker_s.nextval

325: from amv_stocks
326: where stock_symbol = l_symbol;
327:
328: CURSOR UserTicker_seq IS
329: SELECT amv_user_ticker_s.nextval
330: FROM dual;
331:
332: BEGIN
333: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 348: INSERT INTO amv_user_ticker

344: FETCH UserTicker_seq INTO l_user_ticker_id;
345: CLOSE UserTicker_seq;
346: --
347: BEGIN
348: INSERT INTO amv_user_ticker
349: (
350: user_ticker_id,
351: object_version_number,
352: last_update_date,

Line 410: DELETE FROM amv_user_ticker

406: IS
407: BEGIN
408: --
409: FOR i in 1..p_tickerid_array.count LOOP
410: DELETE FROM amv_user_ticker
411: where user_ticker_id = p_tickerid_array(i);
412: END LOOP;
413: --
414: END Delete_UserStocks;

Line 531: from amv_user_ticker amut

527: order by amsp.time_stamp desc;
528:
529: CURSOR Get_DistinctUserStocks_csr IS
530: select distinct amst.stock_symbol, amut.stock_id
531: from amv_user_ticker amut
532: , amv_stocks amst
533: where amut.user_id = p_user_id
534: and amut.stock_id = amst.stock_id
535: order by amst.stock_symbol ASC;

Line 540: from amv_user_ticker amut

536: --order by l_order_by;
537:
538: CURSOR Get_UserStocks_csr IS
539: select amut.stock_id
540: from amv_user_ticker amut
541: , amv_stocks amst
542: where amut.user_id = p_user_id
543: and amut.stock_id = amst.stock_id
544: order by amst.stock_symbol ASC;

Line 581: l_from_stmt := 'FROM amv_user_ticker amut, amv_stocks amst ';

577: ELSE
578: l_select_stmt := 'SELECT distinct amst.stock_symbol, amut.stock_id, amut.last_update_date ';
579: END IF;
580:
581: l_from_stmt := 'FROM amv_user_ticker amut, amv_stocks amst ';
582: l_where_clause := 'WHERE amut.user_id = :user_id ';
583: l_where_clause := l_where_clause || 'AND amut.stock_id = amst.stock_id ';
584:
585: IF p_sort_order = FND_API.G_MISS_CHAR OR

Line 1517: , amv_user_ticker amut

1513:
1514: CURSOR Get_UserKeys_csr IS
1515: select distinct amvk.vendor_key
1516: from amv_vendor_keys amvk
1517: , amv_user_ticker amut
1518: where amut.stock_id = amvk.stock_id
1519: and amvk.vendor_id = p_vendor_id;
1520:
1521: CURSOR Get_SymKeys_csr IS