eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_CONC_REQ_INT SQL Statements

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

Line: 287


 Update quote with Price_request_id
*******************************************************/

	l_qte_header_rec				:= p_qte_header_rec;

Line: 295


ASO_QUOTE_PUB.Update_Quote(
	p_api_version_number		=> 1.0,
	p_init_msg_list			=> FND_API.G_FALSE,
	p_commit			=> FND_API.G_FALSE,
    	P_Validation_Level		=> FND_API.G_VALID_LEVEL_FULL,
	p_control_rec			=> l_control_rec,
    	p_qte_header_rec		=> l_qte_header_rec,
	P_hd_Price_Attributes_Tbl 	=> l_hd_Price_Attributes_Tbl,
	P_hd_Payment_Tbl		=> l_hd_Payment_Tbl,
     P_hd_Shipment_Tbl		=> l_hd_Shipment_Tbl,
     P_hd_Freight_Charge_Tbl		=> l_hd_Freight_Charge_Tbl,
     P_hd_Tax_Detail_Tbl		=> l_hd_Tax_Detail_Tbl,
     P_hd_Attr_Ext_Tbl		=> l_hd_Attr_Ext_Tbl,
     P_hd_Sales_Credit_Tbl		=> l_hd_Sales_Credit_Tbl,
     P_hd_Quote_Party_Tbl		=> l_hd_Quote_Party_Tbl,
     P_Qte_Line_Tbl			=> l_Qte_Line_Tbl,
     P_Qte_Line_Dtl_Tbl		=> l_Qte_Line_Dtl_Tbl,
     P_Line_Attr_Ext_Tbl		=> l_Line_Attr_Ext_Tbl,
     P_line_rltship_tbl		=> l_line_rltship_tbl,
     P_Price_Adjustment_Tbl		=> l_Price_Adjustment_Tbl,
     P_Price_Adj_Attr_Tbl		=> l_Price_Adj_Attr_Tbl,
     P_Price_Adj_Rltship_Tbl		=> l_Price_Adj_Rltship_Tbl,
     P_Ln_Price_Attributes_Tbl	=> l_Ln_Price_Attributes_Tbl,
     P_Ln_Payment_Tbl		=> l_Ln_Payment_Tbl,
     P_Ln_Shipment_Tbl		=> l_Ln_Shipment_Tbl,
     P_Ln_Freight_Charge_Tbl		=> l_Ln_Freight_Charge_Tbl,
     P_Ln_Tax_Detail_Tbl		=> l_Ln_Tax_Detail_Tbl,
     P_ln_Sales_Credit_Tbl		=> l_ln_Sales_Credit_Tbl,
     P_ln_Quote_Party_Tbl		=> l_ln_Quote_Party_Tbl,
     X_Qte_Header_Rec		=> lx_qte_header_rec,
     X_Qte_Line_Tbl			=> lx_Qte_Line_Tbl,
     X_Qte_Line_Dtl_Tbl		=> lx_Qte_Line_Dtl_Tbl,
     X_hd_Price_Attributes_Tbl	=> lx_hd_Price_Attr_Tbl,
     X_hd_Payment_Tbl		=> lx_hd_Payment_Tbl,
     X_hd_Shipment_Tbl		=> lx_hd_Shipment_Tbl,
    	X_hd_Freight_Charge_Tbl		=> lx_hd_Freight_Charge_Tbl,
     X_hd_Tax_Detail_Tbl		=> lx_hd_Tax_Detail_Tbl,
     X_hd_Attr_Ext_Tbl        	=> lX_hd_Attr_Ext_Tbl,
     X_hd_Sales_Credit_Tbl    	=> lx_hd_Sales_Credit_Tbl,
     X_hd_Quote_Party_Tbl     	=> lx_Quote_Party_Tbl,
     X_Line_Attr_Ext_Tbl      	=> lx_Line_Attr_Ext_Tbl,
     X_line_rltship_tbl       	=> lx_line_rltship_tbl,
     X_Price_Adjustment_Tbl   	=> lx_Price_Adjustment_Tbl,
     X_Price_Adj_Attr_Tbl     	=> lx_Price_Adj_Attr_Tbl,
    	X_Price_Adj_Rltship_Tbl  	=> lx_Price_Adj_Rltship_Tbl,
     X_ln_Price_Attributes_Tbl	=> lx_ln_Price_Attr_Tbl,
     X_ln_Payment_Tbl         	=> lx_ln_Payment_Tbl,
     X_ln_Shipment_Tbl        	=> lx_ln_Shipment_Tbl,
     X_ln_Freight_Charge_Tbl  	=> lx_ln_Freight_Charge_Tbl,
     X_ln_Tax_Detail_Tbl      	=> lx_ln_Tax_Detail_Tbl,
     X_Ln_Sales_Credit_Tbl    	=> lX_Ln_Sales_Credit_Tbl,
     X_Ln_Quote_Party_Tbl     	=> lX_Ln_Quote_Party_Tbl,
     X_Return_Status          	=> x_Return_Status,
     X_Msg_Count              	=> x_Msg_Count,
     X_Msg_Data               	=> x_Msg_Data);

Line: 439


l_last_update_date	DATE;

Line: 476


 Call update quote with pricing parameters
********************************************************/
FND_FILE.PUT_LINE(FND_FILE.LOG,'Quote Header Id for Batch Pricing='||p_quote_header_id);

Line: 483


     SELECT a.quote_name ,a.price_request_id, a.org_id into l_quote_name ,l_request_id, l_org_id
     FROM ASO_QUOTE_HEADERS_ALL a
     WHERE a.quote_header_id = p_quote_header_id;

Line: 496


     SELECT a.last_update_date into l_last_update_date
     FROM ASO_QUOTE_HEADERS_ALL a
     WHERE a.quote_header_id = p_quote_header_id;

Line: 504


    l_qte_header_rec.last_update_date			:= l_last_update_date;

Line: 535


   FND_FILE.PUT_LINE(FND_FILE.LOG,'Before Update quote');

Line: 538


   ASO_QUOTE_PUB.Update_Quote(
          p_api_version_number     	=> 1.0,
          p_init_msg_list			=> FND_API.G_FALSE,
          p_commit                 	=> FND_API.G_false,
          p_control_rec            	=> l_control_rec,
          p_qte_header_rec         	=> l_qte_header_rec,
          X_Qte_Header_Rec         	=> lx_qte_header_rec,
          X_Qte_Line_Tbl           	=> lx_Qte_Line_Tbl,
          X_Qte_Line_Dtl_Tbl       	=> lx_Qte_Line_Dtl_Tbl,
          X_hd_Price_Attributes_Tbl 	=> lx_hd_Price_Attr_Tbl,
          X_hd_Payment_Tbl         	=> lx_hd_Payment_Tbl,
          X_hd_Shipment_Tbl        	=> lx_hd_Shipment_Tbl,
          X_hd_Freight_Charge_Tbl  	=> lx_hd_Freight_Charge_Tbl,
          X_hd_Tax_Detail_Tbl      	=> lx_hd_Tax_Detail_Tbl,
          X_hd_Attr_Ext_Tbl        	=> lX_hd_Attr_Ext_Tbl,
          X_hd_Sales_Credit_Tbl    	=> lx_hd_Sales_Credit_Tbl,
          X_hd_Quote_Party_Tbl     	=> lx_Quote_Party_Tbl,
          X_Line_Attr_Ext_Tbl      	=> lx_Line_Attr_Ext_Tbl,
          X_line_rltship_tbl       	=> lx_line_rltship_tbl,
          X_Price_Adjustment_Tbl   	=> lx_Price_Adjustment_Tbl,
          X_Price_Adj_Attr_Tbl     	=> lx_Price_Adj_Attr_Tbl,
          X_Price_Adj_Rltship_Tbl  	=> lx_Price_Adj_Rltship_Tbl,
          X_ln_Price_Attributes_Tbl	=> lx_ln_Price_Attr_Tbl,
          X_ln_Payment_Tbl         	=> lx_ln_Payment_Tbl,
          X_ln_Shipment_Tbl        	=> lx_ln_Shipment_Tbl,
          X_ln_Freight_Charge_Tbl  	=> lx_ln_Freight_Charge_Tbl,
          X_ln_Tax_Detail_Tbl      	=> lx_ln_Tax_Detail_Tbl,
          X_Ln_Sales_Credit_Tbl    	=> lX_Ln_Sales_Credit_Tbl,
          X_Ln_Quote_Party_Tbl     	=> lX_Ln_Quote_Party_Tbl,
          X_Return_Status          	=> x_Return_Status,
          X_Msg_Count              	=> x_Msg_Count,
          X_Msg_Data               	=> x_Msg_Data);

Line: 702


select a.quote_name,a.price_request_id from aso_quote_headers_all a
where  a.quote_header_id = p_quote_header_id;

Line: 837


select employee_id from fnd_user
where user_id = p_user_id;

Line: 873


 Update price_request_id in ASO_QUOTE_HEADERS_ALL
 ********************************************************/

procedure Update_price_req_id(p_quote_header_id   IN  Number) is

G_USER_ID                     NUMBER := FND_GLOBAL.USER_ID;

Line: 880


l_last_update_date            Date := SYSDATE;

Line: 884


Update ASO_QUOTE_HEADERS_ALL
set price_request_id = null,
last_update_date = l_last_update_date,
object_version_number = object_version_number + 1,
last_updated_by = G_USER_ID,
last_update_login = G_LOGIN_ID
where quote_header_id =p_quote_header_id;

Line: 892


end Update_price_req_id;

Line: 913


select quote_number
from aso_quote_headers_all
where quote_header_id = p_quote_header_id;

Line: 926


   select ASO_WFNOTIFICATION_S2.NEXTVAL into wf_itemkey_seq from dual;

Line: 988


   Update_price_req_id(p_quote_header_id     => p_quote_header_id);

Line: 1003


Select price_request_id into l_request_id   from aso_quote_headers_all
Where quote_header_id =p_quote_header_id;

Line: 1031


      SELECT qha.quote_number, hca.account_number,
      hp.party_type
      FROM aso_quote_headers_all qha,
      hz_parties hp,
      hz_cust_accounts hca
      WHERE qha.cust_account_id = hca.cust_account_id(+)
      AND hca.party_id = hp.party_id
      AND qha.party_id = hca.party_id
      AND qha.quote_header_id = p_quote_header_id;

Line: 1144


     SELECT qha.quote_number, hca.account_number,
     hp.party_type,qha.org_id
     FROM aso_quote_headers_all qha,
     hz_parties hp,
     hz_cust_accounts hca
     WHERE qha.cust_account_id = hca.cust_account_id(+)
     AND qha.cust_party_id = hp.party_id
     AND qha.quote_header_id =p_quote_header_id;