DBA Data[Home] [Help]

APPS.AMV_STOCK_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

PROCEDURE Update_Symbols
(
     p_user_id    		IN  NUMBER,
	p_symbols_array	IN amv_char_varray_type
);
Line: 51

PROCEDURE Delete_UserStocks
(
 p_tickerid_array  		IN  AMV_NUM_VARRAY_TYPE
);
Line: 74

PROCEDURE Update_Symbols
(
	p_user_id    		IN  NUMBER,
	p_symbols_array	IN amv_char_varray_type
)
IS
l_stock_id number;
Line: 86

select stock_id
from   amv_stocks
where  stock_symbol = l_symbol;
Line: 98

	 	UPDATE amv_user_ticker
	 	SET last_update_date = sysdate + i
	 	WHERE user_id = p_user_id
	 	AND   stock_id = l_stock_id;
Line: 105

END Update_Symbols;
Line: 135

select amut.user_ticker_id
,  	  amst.stock_symbol
,	  l_null
from	amv_user_ticker amut
,	amv_stocks amst
where	amut.user_id = p_user_id
and   	amut.stock_id = amst.stock_id;
Line: 184

select count(*)
from   fnd_user
where  user_id = p_user_id;
Line: 324

select stock_id
from	  amv_stocks
where  stock_symbol = l_symbol;
Line: 329

SELECT amv_user_ticker_s.nextval
FROM   dual;
Line: 341

	    -- insert stock ticker if stock id is not null
	    IF l_stock_id is not null THEN
	 		OPEN UserTicker_seq;
Line: 348

		  	  INSERT INTO amv_user_ticker
		  	  (
				user_ticker_id,
				object_version_number,
				last_update_date,
				last_updated_by,
				creation_date,
				created_by,
				last_update_login,
				user_id,
				stock_id
		  	  )
		  	  VALUES
		  	  (
				l_user_ticker_id,
				l_object_version_number,
				sysdate,
				l_user_id,
				sysdate,
				l_user_id,
				l_login_user_id,
				p_user_id,
				l_stock_id
		  	  );
Line: 402

PROCEDURE Delete_UserStocks
(
 p_tickerid_array  		IN  AMV_NUM_VARRAY_TYPE
)
IS
BEGIN
    --
    FOR i in 1..p_tickerid_array.count LOOP
		DELETE FROM amv_user_ticker
		where  user_ticker_id = p_tickerid_array(i);
Line: 414

END Delete_UserStocks;
Line: 434

select user_id
from   fnd_user
where  user_name = 'STANDALONE BATCH PROCESS';
Line: 502

l_last_update_date date;
Line: 509

l_select_stmt  varchar2(200);
Line: 518

select amst.stock_id
,  	  amst.stock_symbol
,      amst.stock_desc
,      amsp.stock_price
,      amsp.change
from   amv_stocks amst
,      amv_stock_price amsp
where  amst.stock_ric = amsp.stock_ric(+)
and    amst.stock_id = l_stock_id
order  by amsp.time_stamp desc;
Line: 530

select distinct amst.stock_symbol, amut.stock_id
from   amv_user_ticker amut
,	  amv_stocks amst
where  amut.user_id = p_user_id
and	  amut.stock_id = amst.stock_id
order by amst.stock_symbol ASC;
Line: 539

select amut.stock_id
from   amv_user_ticker amut
,	  amv_stocks amst
where  amut.user_id = p_user_id
and	  amut.stock_id = amst.stock_id
order by amst.stock_symbol ASC;
Line: 576

	l_select_stmt := 'SELECT amst.stock_symbol, amut.stock_id, amut.last_update_date ';
Line: 578

	l_select_stmt := 'SELECT distinct amst.stock_symbol, amut.stock_id, amut.last_update_date ';
Line: 588

	l_order_by := 'ORDER BY amut.last_update_date ASC';
Line: 593

    l_sql_statement := l_select_stmt || l_from_stmt || l_where_clause || l_order_by;
Line: 597

		FETCH l_cursor INTO  l_stock_symbol, l_stock_id, l_last_update_date;
Line: 761

select amst.stock_id
,	  amst.stock_symbol
,      amst.stock_desc
,      amsp.stock_price
,      amsp.change
from   amv_stocks amst
,      amv_stock_price amsp
where  amst.stock_symbol = l_stock_symbol
and    amst.stock_ric = amsp.stock_ric(+)
order  by amsp.time_stamp desc;
Line: 906

PROCEDURE Update_UserTicker
(     p_api_version     		IN  NUMBER,
      p_init_msg_list    	IN  VARCHAR2 := FND_API.G_FALSE,
      p_commit           	IN  VARCHAR2 := FND_API.G_FALSE,
      p_validation_level 	IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,
      x_return_status    	OUT NOCOPY  VARCHAR2,
      x_msg_count        	OUT NOCOPY  NUMBER,
      x_msg_data        	 	OUT NOCOPY  VARCHAR2,
      p_object_version_number IN  NUMBER,
      p_user_id          	IN  NUMBER,
      p_symbols      		IN  VARCHAR2
)
IS
l_api_name         	CONSTANT VARCHAR2(30) := 'Update_UserTicker';
Line: 941

    SAVEPOINT  Update_UserTicker;
Line: 1002

    	-- build the list of deleted symbols
    	FOR i in 1..l_user_symbols.count LOOP
		IF l_user_symbols(i).exchange is null THEN
				l_rec_num := l_rec_num + 1;
Line: 1019

		  Delete_UserStocks( p_tickerid_array => l_del_symbols );
Line: 1023

	Update_Symbols( p_user_id, l_symbols_array);
Line: 1061

       ROLLBACK TO  Update_UserTicker;
Line: 1070

       ROLLBACK TO  Update_UserTicker;
Line: 1079

       ROLLBACK TO  Update_UserTicker;
Line: 1092

END Update_UserTicker;
Line: 1153

select a.stock_id
from amv_stocks a
where a.stock_id > p_start_index
minus
select b.stock_id
from amv_vendor_keys b
where b.vendor_id = p_vendor_id
order by 1;
Line: 1163

select stock_id
,	stock_symbol
,	exchange
from	amv_stocks
where  stock_id = l_stock_id;
Line: 1296

PROCEDURE Insert_StockVendorKeys
(     p_api_version     	IN  NUMBER,
      p_init_msg_list    	IN  VARCHAR2 := FND_API.G_FALSE,
      p_commit           	IN  VARCHAR2 := FND_API.G_FALSE,
      p_validation_level 	IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,
      x_return_status    	OUT NOCOPY  VARCHAR2,
      x_msg_count        	OUT NOCOPY  NUMBER,
      x_msg_data        	OUT NOCOPY  VARCHAR2,
      p_vendor_id          	IN  NUMBER,
      p_ticker_rec      	IN  AMV_TKR_OBJ_TYPE
)
IS
l_api_name          	CONSTANT VARCHAR2(30) := 'Insert_StockVendorKeys';
Line: 1326

select amv_vendor_keys_s.nextval
from dual;
Line: 1331

    SAVEPOINT  Insert_StockVendorKeys;
Line: 1364

	   INSERT INTO amv_vendor_keys(
		vendor_key_id,
		object_version_number,
		last_update_date,
		last_updated_by,
		creation_date,
		created_by,
		last_update_login,
		vendor_id,
		vendor_key,
		stock_id,
		effective_start_date
	   )
	   VALUES (
		l_vendor_key_id,
		l_object_version_number,
		sysdate,
		l_user_id,
		sysdate,
		l_user_id,
		l_user_id,
		p_vendor_id,
		l_key_id,
		l_stock_id,
		sysdate
	   );
Line: 1426

       ROLLBACK TO  Insert_StockVendorKeys;
Line: 1435

       ROLLBACK TO  Insert_StockVendorKeys;
Line: 1444

       ROLLBACK TO  Insert_StockVendorKeys;
Line: 1457

END Insert_StockVendorKeys;
Line: 1485

PROCEDURE Get_UserSelectedKeys
(     p_api_version     	IN  NUMBER,
      p_init_msg_list    IN  VARCHAR2 := FND_API.G_FALSE,
      p_validation_level IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,
      x_return_status    OUT NOCOPY  VARCHAR2,
      x_msg_count        OUT NOCOPY  NUMBER,
      x_msg_data        	OUT NOCOPY  VARCHAR2,
      p_vendor_id        IN NUMBER,
	 p_all_keys		IN VARCHAR2 := FND_API.G_FALSE,
      x_keys_array      	OUT NOCOPY   AMV_CHAR_VARRAY_TYPE
)
IS
l_api_name          	CONSTANT VARCHAR2(30) := 'Get_UserSelectedKeys';
Line: 1515

select 	distinct amvk.vendor_key
from   	amv_vendor_keys amvk
,		amv_user_ticker amut
where	amut.stock_id = amvk.stock_id
and		amvk.vendor_id = p_vendor_id;
Line: 1522

select 	amvk.vendor_key
from   	amv_vendor_keys amvk
,		amv_stocks amst
where	amst.stock_symbol = l_stock_symbol
and		amst.stock_id = amvk.stock_id;
Line: 1529

select 	distinct amvk.vendor_key
from   	amv_vendor_keys amvk
where	amvk.vendor_id = p_vendor_id;
Line: 1535

    SAVEPOINT  Get_UserSelectedKeys;
Line: 1569

	-- get user selected keys
    	OPEN Get_UserKeys_csr;
Line: 1619

       ROLLBACK TO  Get_UserSelectedKeys;
Line: 1628

       ROLLBACK TO  Get_UserSelectedKeys;
Line: 1637

       ROLLBACK TO  Get_UserSelectedKeys;
Line: 1650

END Get_UserSelectedKeys;
Line: 1680

PROCEDURE Insert_VendorNews
(     p_api_version     		IN  NUMBER,
      p_init_msg_list    	IN  VARCHAR2 := FND_API.G_FALSE,
      p_commit           	IN  VARCHAR2 := FND_API.G_FALSE,
      p_validation_level 	IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,
      x_return_status    	OUT NOCOPY  VARCHAR2,
      x_msg_count        	OUT NOCOPY  NUMBER,
      x_msg_data         	OUT NOCOPY  VARCHAR2,
      p_vendor_id          	IN  NUMBER,
      p_news_rec      	IN  AMV_NEWS_OBJ_TYPE
)
IS
l_api_name          	CONSTANT VARCHAR2(30) := 'Insert_VendorNews';
Line: 1709

select	vendor_key_id
from	amv_vendor_keys
where	vendor_id = p_vendor_id
and	vendor_key = l_key_id;
Line: 1715

select amv_news_s.nextval
from dual;
Line: 1720

    SAVEPOINT  Insert_VendorNews;
Line: 1754

	  INSERT INTO amv_news (
		news_id,
		object_version_number,
		last_update_date,
		last_updated_by,
		creation_date,
		created_by,
		last_update_login,
		vendor_key_id,
		news_url,
		news_title,
		provider,
		date_time
	  )
	  VALUES (
		l_news_id,
		l_object_version_number,
		sysdate,
		l_user_id,
		sysdate,
		l_user_id,
		l_user_id,
		l_vendor_key_id,
		p_news_rec.news_url,
		p_news_rec.title,
		p_news_rec.provider,
		p_news_rec.date_time
	  );
Line: 1817

       ROLLBACK TO  Insert_VendorNews;
Line: 1826

       ROLLBACK TO  Insert_VendorNews;
Line: 1835

       ROLLBACK TO  Insert_VendorNews;
Line: 1848

END Insert_VendorNews;
Line: 1909

select	v.vendor_key
,		n.news_url
,		n.news_title
,		n.provider
,		n.date_time
from	 amv_news n
,	 amv_vendor_keys v
where v.stock_id = p_stock_id
and   v.vendor_key_id = n.vendor_key_id
order by n.date_time desc;