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_QUOTE_VUHK SQL Statements

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

Line: 152


PROCEDURE Update_quote_PRE(
     P_Validation_Level 	IN OUT NOCOPY   NUMBER       ,
    P_Control_Rec		 IN OUT NOCOPY   ASO_QUOTE_PUB.Control_Rec_Type ,
    P_Qte_Header_Rec		 IN OUT NOCOPY    ASO_QUOTE_PUB.Qte_Header_Rec_Type  ,
    P_hd_Price_Attributes_Tbl	 IN OUT NOCOPY   ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
    P_hd_Payment_Tbl		 IN OUT NOCOPY   ASO_QUOTE_PUB.Payment_Tbl_Type,
    P_hd_Shipment_tbl		 IN OUT NOCOPY   ASO_QUOTE_PUB.Shipment_tbl_Type,
    P_hd_Freight_Charge_Tbl	 IN OUT NOCOPY   ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
    P_hd_Tax_Detail_Tbl		 IN OUT NOCOPY   ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
    P_hd_Attr_Ext_Tbl		 IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
    P_hd_Sales_Credit_Tbl        IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
    P_hd_Quote_Party_Tbl         IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
    P_Qte_Line_Tbl		 IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
    P_Qte_Line_Dtl_Tbl		 IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
    P_Line_Attr_Ext_Tbl		 IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
    P_line_rltship_tbl		 IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
    P_Price_Adjustment_Tbl	 IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
    P_Price_Adj_Attr_Tbl	 IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
    P_Price_Adj_Rltship_Tbl	 IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
    P_Ln_Price_Attributes_Tbl	 IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
    P_Ln_Payment_Tbl		 IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
    P_Ln_Shipment_Tbl		 IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
    P_Ln_Freight_Charge_Tbl	 IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
    P_Ln_Tax_Detail_Tbl		 IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
    P_ln_Sales_Credit_Tbl        IN OUT NOCOPY ASO_QUOTE_PUB.   Sales_Credit_Tbl_Type,
    P_ln_Quote_Party_Tbl         IN OUT NOCOPY ASO_QUOTE_PUB.   Quote_Party_Tbl_Type,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */     NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */     VARCHAR2
    )
IS
BEGIN
NULL;

Line: 189


PROCEDURE UPdate_quote_POST(
     P_Validation_Level 	IN    NUMBER       ,
    P_Control_Rec		 IN    ASO_QUOTE_PUB.Control_Rec_Type ,
    P_Qte_Header_Rec		 IN      ASO_QUOTE_PUB.Qte_Header_Rec_Type  ,
    P_hd_Price_Attributes_Tbl	 IN     ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
    P_hd_Payment_Tbl		 IN     ASO_QUOTE_PUB.Payment_Tbl_Type,
    P_hd_Shipment_tbl		 IN     ASO_QUOTE_PUB.Shipment_tbl_Type,
    P_hd_Freight_Charge_Tbl	 IN     ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
    P_hd_Tax_Detail_Tbl		 IN     ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
    P_hd_Attr_Ext_Tbl		 IN   ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
    P_hd_Sales_Credit_Tbl        IN   ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
    P_hd_Quote_Party_Tbl         IN   ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
    P_Qte_Line_Tbl		 IN   ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
    P_Qte_Line_Dtl_Tbl		 IN   ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
    P_Line_Attr_Ext_Tbl		 IN   ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
    P_line_rltship_tbl		 IN   ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
    P_Price_Adjustment_Tbl	 IN   ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
    P_Price_Adj_Attr_Tbl	 IN   ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
    P_Price_Adj_Rltship_Tbl	 IN   ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
    P_Ln_Price_Attributes_Tbl	 IN   ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
    P_Ln_Payment_Tbl		 IN   ASO_QUOTE_PUB.Payment_Tbl_Type ,
    P_Ln_Shipment_Tbl		 IN   ASO_QUOTE_PUB.Shipment_Tbl_Type,
    P_Ln_Freight_Charge_Tbl	 IN   ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
    P_Ln_Tax_Detail_Tbl		 IN   ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
    P_ln_Sales_Credit_Tbl        IN   ASO_QUOTE_PUB.   Sales_Credit_Tbl_Type,
    P_ln_Quote_Party_Tbl         IN   ASO_QUOTE_PUB.   Quote_Party_Tbl_Type,
    X_Return_Status                OUT NOCOPY /* file.sql.39 change */    VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */     NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */     VARCHAR2
    )
IS
BEGIN
NULL;

Line: 254


PROCEDURE Delete_quote_PRE(
    P_Qte_Header_Id		 IN OUT NOCOPY  NUMBER,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */    NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */    VARCHAR2
    )
IS
BEGIN
NULL;

Line: 266


PROCEDURE Delete_quote_POST(
    P_Qte_Header_Id		 IN   NUMBER,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */    VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */    NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */    VARCHAR2
    )
IS
BEGIN
NULL;

Line: 301


    P_Last_Update_Date		 IN OUT NOCOPY  DATE,
    P_Copy_Only_Header		 IN OUT NOCOPY  VARCHAR2,
    P_New_Version		 IN OUT NOCOPY  VARCHAR2,
    P_Qte_Status_Id		 IN OUT NOCOPY  NUMBER	,
    P_Qte_Number		 IN OUT NOCOPY  NUMBER	,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */    VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */    NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */    VARCHAR2
    )
IS
BEGIN
NULL;

Line: 318


    P_Last_Update_Date		 IN   DATE,
    P_Copy_Only_Header		 IN   VARCHAR2	 ,
    P_New_Version		 IN   VARCHAR2	 ,
    P_Qte_Status_Id		 IN   NUMBER	 ,
    P_Qte_Number		 IN   NUMBER	,
    P_NEW_Qte_Header_Id		 IN   NUMBER,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */    VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */    NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */    VARCHAR2
    )
IS
l_sql_stat                    VARCHAR2(3000);

Line: 447


    P_Update_Header_Flag    IN  OUT NOCOPY VARCHAR2,
    X_Return_Status         OUT NOCOPY /* file.sql.39 change */  VARCHAR2,
    X_Msg_Count             OUT NOCOPY /* file.sql.39 change */   NUMBER,
    X_Msg_Data              OUT NOCOPY /* file.sql.39 change */   VARCHAR2
)IS
BEGIN
NULL;

Line: 472


    P_Update_Header_Flag    IN   VARCHAR2  ,
    X_Return_Status         OUT NOCOPY /* file.sql.39 change */   VARCHAR2,
    X_Msg_Count             OUT NOCOPY /* file.sql.39 change */   NUMBER,
    X_Msg_Data              OUT NOCOPY /* file.sql.39 change */   VARCHAR2
)IS
BEGIN
NULL;

Line: 492


PROCEDURE Update_Quote_Line_PRE(
    P_Qte_Line_Rec         IN  OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
    P_Control_Rec          IN  OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
    P_Qte_Line_Dtl_Tbl    IN   OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
    P_Line_Attribs_Ext_Tbl IN   OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
    P_Payment_Tbl          IN   OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
    P_Price_Adj_Tbl        IN   OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
    P_Price_Attributes_Tbl IN   OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
    P_Price_Adj_Attr_Tbl    IN  OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
    P_Shipment_Tbl          IN  OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
    P_Tax_Detail_Tbl        IN  OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
    P_Freight_Charge_Tbl    IN  OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
    P_Sales_Credit_Tbl      IN  OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
    P_Quote_Party_Tbl       IN  OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
    P_Update_Header_Flag    IN  OUT NOCOPY VARCHAR2,
    X_Return_Status         OUT NOCOPY /* file.sql.39 change */   VARCHAR2,
    X_Msg_Count             OUT NOCOPY /* file.sql.39 change */   NUMBER,
    X_Msg_Data              OUT NOCOPY /* file.sql.39 change */   VARCHAR2
)IS
BEGIN
NULL;

Line: 517


PROCEDURE Update_Quote_Line_POST(
    P_Qte_Line_Rec         IN   ASO_QUOTE_PUB.Qte_Line_Rec_Type,
    P_Control_Rec          IN   ASO_QUOTE_PUB.Control_rec_Type,
    P_Qte_Line_Dtl_Tbl    IN    ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
    P_Line_Attribs_Ext_Tbl IN    ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
    P_Payment_Tbl          IN    ASO_QUOTE_PUB.Payment_Tbl_Type,
    P_Price_Adj_Tbl        IN    ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
    P_Price_Attributes_Tbl IN    ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
    P_Price_Adj_Attr_Tbl    IN   ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
    P_Shipment_Tbl          IN   ASO_QUOTE_PUB.Shipment_Tbl_Type,
    P_Tax_Detail_Tbl        IN   ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
    P_Freight_Charge_Tbl    IN   ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
    P_Sales_Credit_Tbl      IN   ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
    P_Quote_Party_Tbl       IN   ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
    P_Update_Header_Flag    IN   VARCHAR2  ,
    X_Return_Status         OUT NOCOPY /* file.sql.39 change */   VARCHAR2,
    X_Msg_Count             OUT NOCOPY /* file.sql.39 change */   NUMBER,
    X_Msg_Data              OUT NOCOPY /* file.sql.39 change */   VARCHAR2
)IS
BEGIN
NULL;

Line: 571


PROCEDURE Delete_Quote_Line_PRE(
    P_qte_line_Rec     IN  OUT NOCOPY   ASO_QUOTE_PUB.qte_line_Rec_Type,
    P_Control_Rec      IN  OUT NOCOPY   ASO_QUOTE_PUB.Control_rec_Type,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */    VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */    NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */    VARCHAR2
    )IS
BEGIN
NULL;

Line: 582


PROCEDURE Delete_Quote_Line_POST(
    P_qte_line_Rec     IN     ASO_QUOTE_PUB.qte_line_Rec_Type,
    P_Control_Rec      IN     ASO_QUOTE_PUB.Control_rec_Type,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */    VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */    NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */    VARCHAR2
    )
IS
BEGIN
NULL;