APPS.ASO_QUOTE_PUB SQL Statements

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

Line: 378

PROCEDURE Update_quote(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2                                := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2                                := FND_API.G_FALSE,
    P_Control_Rec		        IN   Control_Rec_Type                        := G_Miss_Control_Rec,
    P_Qte_Header_Rec		   IN   Qte_Header_Rec_Type                     := G_MISS_Qte_Header_Rec,
    P_hd_Price_Attributes_Tbl	   IN   ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
    P_hd_Payment_Tbl		   IN   ASO_QUOTE_PUB.Payment_Tbl_Type          := G_MISS_PAYMENT_TBL,
    P_hd_Shipment_Tbl		   IN   ASO_QUOTE_PUB.Shipment_Tbl_Type         := G_MISS_SHIPMENT_TBL,
    P_hd_Freight_Charge_Tbl	   IN   ASO_QUOTE_PUB.Freight_Charge_Tbl_Type   := G_Miss_Freight_Charge_Tbl,
    P_hd_Tax_Detail_Tbl		   IN   ASO_QUOTE_PUB.Tax_Detail_Tbl_Type       := G_Miss_Tax_Detail_Tbl,
    P_Qte_Line_Tbl		        IN   Qte_Line_Tbl_Type                       := G_MISS_QTE_LINE_TBL,
    P_Qte_Line_Dtl_Tbl		   IN   Qte_Line_Dtl_Tbl_Type                   := G_MISS_QTE_LINE_DTL_TBL,
    P_Line_Attr_Ext_Tbl		   IN   Line_Attribs_Ext_Tbl_Type               := G_MISS_Line_Attribs_Ext_TBL,
    P_line_rltship_tbl		   IN   Line_Rltship_Tbl_Type                   := G_MISS_Line_Rltship_Tbl,
    P_Price_Adjustment_Tbl	   IN   Price_Adj_Tbl_Type                      := G_Miss_Price_Adj_Tbl,
    P_Price_Adj_Attr_Tbl	        IN   Price_Adj_Attr_Tbl_Type                 := G_Miss_PRICE_ADJ_ATTR_Tbl,
    P_Price_Adj_Rltship_Tbl	   IN   Price_Adj_Rltship_Tbl_Type              := G_Miss_Price_Adj_Rltship_Tbl,
    P_Ln_Price_Attributes_Tbl	   IN   Price_Attributes_Tbl_Type               := G_Miss_Price_Attributes_Tbl,
    P_Ln_Payment_Tbl		   IN   Payment_Tbl_Type                        := G_MISS_PAYMENT_TBL,
    P_Ln_Shipment_Tbl		   IN   Shipment_Tbl_Type                       := G_MISS_SHIPMENT_TBL,
    P_Ln_Freight_Charge_Tbl	   IN   Freight_Charge_Tbl_Type                 := G_Miss_Freight_Charge_Tbl,
    P_Ln_Tax_Detail_Tbl		   IN   Tax_Detail_Tbl_Type                     := G_Miss_Tax_Detail_Tbl,
    x_Qte_Header_Rec		   OUT NOCOPY /* file.sql.39 change */  Qte_Header_Rec_Type,
    X_Qte_Line_Tbl		        OUT NOCOPY /* file.sql.39 change */  Qte_Line_Tbl_Type,
    X_Qte_Line_Dtl_Tbl		   OUT NOCOPY /* file.sql.39 change */  Qte_Line_Dtl_Tbl_Type,
    X_Hd_Price_Attributes_Tbl	   OUT NOCOPY /* file.sql.39 change */  Price_Attributes_Tbl_Type,
    X_Hd_Payment_Tbl		   OUT NOCOPY /* file.sql.39 change */  Payment_Tbl_Type,
    X_Hd_Shipment_Tbl		   OUT NOCOPY /* file.sql.39 change */  Shipment_Tbl_Type,
    X_Hd_Freight_Charge_Tbl	   OUT NOCOPY /* file.sql.39 change */  Freight_Charge_Tbl_Type,
    X_Hd_Tax_Detail_Tbl		   OUT NOCOPY /* file.sql.39 change */  Tax_Detail_Tbl_Type,
    x_Line_Attr_Ext_Tbl		   OUT NOCOPY /* file.sql.39 change */  Line_Attribs_Ext_Tbl_Type,
    X_line_rltship_tbl		   OUT NOCOPY /* file.sql.39 change */  Line_Rltship_Tbl_Type,
    X_Price_Adjustment_Tbl	   OUT NOCOPY /* file.sql.39 change */  Price_Adj_Tbl_Type,
    X_Price_Adj_Attr_Tbl	        OUT NOCOPY /* file.sql.39 change */  Price_Adj_Attr_Tbl_Type,
    X_Price_Adj_Rltship_Tbl	   OUT NOCOPY /* file.sql.39 change */  Price_Adj_Rltship_Tbl_Type,
    X_Ln_Price_Attributes_Tbl	   OUT NOCOPY /* file.sql.39 change */  Price_Attributes_Tbl_Type,
    X_Ln_Payment_Tbl		   OUT NOCOPY /* file.sql.39 change */  Payment_Tbl_Type,
    X_Ln_Shipment_Tbl		   OUT NOCOPY /* file.sql.39 change */  Shipment_Tbl_Type,
    X_Ln_Freight_Charge_Tbl	   OUT NOCOPY /* file.sql.39 change */  Freight_Charge_Tbl_Type,
    X_Ln_Tax_Detail_Tbl		   OUT NOCOPY /* file.sql.39 change */  Tax_Detail_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

 x_hd_Attr_Ext_Tbl		       Line_Attribs_Ext_Tbl_Type;

Line: 434

     Update_quote(
	    P_Api_Version_Number	      => 1.0,
	    P_Init_Msg_List		      => p_init_msg_list,
	    P_Commit			      => p_commit,
	    P_Control_Rec		      => p_control_rec,
	    P_qte_header_rec		 => p_qte_header_rec,
	    P_Hd_Price_Attributes_Tbl	 => p_Hd_Price_Attributes_Tbl,
	    P_Hd_Payment_Tbl		 => p_Hd_Payment_Tbl,
	    P_Hd_Shipment_Tbl		 => p_Hd_Shipment_Tbl,
	    P_Hd_Freight_Charge_Tbl	 => p_Hd_Freight_Charge_Tbl,
	    P_Hd_Tax_Detail_Tbl		 => p_Hd_Tax_Detail_Tbl,
	    P_Qte_Line_Tbl		      => p_Qte_Line_Tbl,
	    P_Qte_Line_Dtl_Tbl		 => p_Qte_Line_Dtl_Tbl,
	    P_Line_Attr_Ext_Tbl		 => P_Line_Attr_Ext_Tbl,
	    P_Line_rltship_tbl		 => p_Line_Rltship_Tbl,
	    P_Price_Adjustment_Tbl	 => p_Price_Adjustment_Tbl,
	    P_Price_Adj_Attr_Tbl	      => P_Price_Adj_Attr_Tbl,
	    P_Price_Adj_Rltship_Tbl	 => p_Price_Adj_Rltship_Tbl,
	    P_Ln_Price_Attributes_Tbl	 => p_Ln_Price_Attributes_Tbl,
	    P_Ln_Payment_Tbl		 => p_Ln_Payment_Tbl,
	    P_Ln_Shipment_Tbl		 => p_Ln_Shipment_Tbl,
	    P_Ln_Freight_Charge_Tbl	 => p_Ln_Freight_Charge_Tbl,
	    P_Ln_Tax_Detail_Tbl		 => p_Ln_Tax_Detail_Tbl,
	    x_qte_header_rec		 => x_qte_header_rec,
	    X_Hd_Price_Attributes_Tbl	 => x_Hd_Price_Attributes_Tbl,
	    X_Hd_Payment_Tbl		 => x_Hd_Payment_Tbl,
	    X_Hd_Shipment_tbl		 => x_Hd_Shipment_tbl,
	    X_Hd_Freight_Charge_Tbl	 => x_Hd_Freight_Charge_Tbl,
	    X_Hd_Tax_Detail_Tbl		 => x_Hd_Tax_Detail_Tbl,
         X_hd_Attr_Ext_Tbl		 => X_hd_Attr_Ext_Tbl,
         X_hd_Sales_Credit_Tbl      => X_hd_Sales_Credit_Tbl,
         X_hd_Quote_Party_Tbl       => X_hd_Quote_Party_Tbl,
	    X_Qte_Line_Tbl		      => x_Qte_Line_Tbl,
	    X_Qte_Line_Dtl_Tbl		 => x_Qte_Line_Dtl_Tbl,
	    x_Line_Attr_Ext_Tbl		 => x_Line_Attr_Ext_Tbl,
	    X_Line_rltship_tbl		 => x_Line_Rltship_Tbl,
	    X_Price_Adjustment_Tbl	 => x_Price_Adjustment_Tbl,
	    x_Price_Adj_Attr_Tbl	      => x_Price_Adj_Attr_Tbl,
	    X_Price_Adj_Rltship_Tbl	 => x_Price_Adj_Rltship_Tbl,
	    X_Ln_Price_Attributes_Tbl	 => x_Ln_Price_Attributes_Tbl,
	    X_Ln_Payment_Tbl		 => x_Ln_Payment_Tbl,
	    X_Ln_Shipment_Tbl		 => x_Ln_Shipment_Tbl,
	    X_Ln_Freight_Charge_Tbl	 => x_Ln_Freight_Charge_Tbl,
	    X_Ln_Tax_Detail_Tbl		 => x_Ln_Tax_Detail_Tbl,
         X_Ln_Sales_Credit_Tbl      => X_ln_Sales_Credit_Tbl,
         X_Ln_Quote_Party_Tbl       => X_ln_Quote_Party_Tbl,
	    X_Return_Status            => x_return_status,
	    X_Msg_Count                => x_msg_count,
	    X_Msg_Data                 => x_msg_data);

Line: 484

End Update_quote;

Line: 490

PROCEDURE Delete_quote(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    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
    l_api_name                CONSTANT VARCHAR2(30) := 'DELETE_QUOTE';

Line: 506

      SAVEPOINT DELETE_QUOTE_PUB;

Line: 535

          ASO_QUOTE_CUHK.Delete_quote_PRE( P_Qte_Header_Id   => l_qte_header_id,
                                           X_Return_Status   => x_return_status,
  	                                      X_Msg_Count       => x_msg_count ,
  	                                      X_Msg_Data        => x_msg_data );

Line: 544

		        FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_PRE', FALSE);

Line: 561

          ASO_QUOTE_VUHK.Delete_quote_PRE( P_Qte_Header_Id  => l_qte_header_id,
                                           X_Return_Status  => x_return_status,
  	                                      X_Msg_Count      => x_msg_count,
  	                                      x_Msg_Data       => x_msg_data );

Line: 570

		        FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_PRE', FALSE);

Line: 584

      ASO_QUOTE_HEADERS_PVT.Delete_quote( P_Api_Version_Number  => 1.0,
		                                P_Init_Msg_List       => FND_API.G_FALSE,
		                                P_Commit              => p_commit,
		                                P_Qte_Header_ID       => l_Qte_Header_Id,
		                                X_Return_Status       => x_return_status,
		                                X_Msg_Count           => x_msg_count,
		                                X_Msg_Data            => x_msg_data);

Line: 601

          ASO_QUOTE_CUHK.Delete_quote_POST( P_Qte_Header_Id		=> l_qte_header_id,
   	                                       X_Return_Status         => x_return_status,
		                                  X_Msg_Count             => x_msg_count,
		                                  X_Msg_Data              => x_msg_data );

Line: 610

		        FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_POST', FALSE);

Line: 627

          ASO_QUOTE_VUHK.Delete_quote_POST( P_Qte_Header_Id  => l_qte_header_id,
   	                                       X_Return_Status  => x_return_status,
		                                  X_Msg_Count      => x_msg_count,
		                                  X_Msg_Data       => x_msg_data );

Line: 636

		        FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_POST', FALSE);

Line: 697

End Delete_quote;

Line: 1022

	 l_qte_header_rec.last_update_date := FND_API.G_MISS_DATE;

Line: 1139

    P_Last_Update_Date		 IN   DATE,
    P_Copy_Only_Header		 IN   VARCHAR2	   := FND_API.G_FALSE,
    P_New_Version		 IN   VARCHAR2	   := FND_API.G_FALSE,
    P_Qte_Status_Id		 IN   NUMBER	   := NULL,
    P_Qte_Number		 IN   NUMBER	   := NULL,
    X_Qte_Header_Id		 OUT NOCOPY /* file.sql.39 change */  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_api_name                CONSTANT VARCHAR2(30) := 'COPY_QUOTE';

Line: 1153

    l_Last_Update_Date DATE;

Line: 1194

    l_Last_Update_Date := P_Last_Update_Date;

Line: 1203

    P_Last_Update_Date	  => l_Last_Update_Date,
    P_Copy_Only_Header		 => l_Copy_Only_Header,
    P_New_Version		 => l_New_Version,
    P_Qte_Status_Id		=> l_Qte_Status_Id	,
    P_Qte_Number		 => l_Qte_Number	,
    X_Return_Status      => X_Return_Status ,
    X_Msg_Count           =>     X_Msg_Count,
    X_Msg_Data            =>        X_Msg_Data
    );

Line: 1229

    P_Last_Update_Date	  => l_Last_Update_Date,
    P_Copy_Only_Header		 => l_Copy_Only_Header,
    P_New_Version		 => l_New_Version,
    P_Qte_Status_Id		=> l_Qte_Status_Id	,
    P_Qte_Number		 => l_Qte_Number	,
    X_Return_Status      => X_Return_Status ,
    X_Msg_Count           =>     X_Msg_Count,
    X_Msg_Data            =>        X_Msg_Data
    );

Line: 1259

		P_Last_Update_Date	=> p_last_update_date,
		P_Copy_Only_Header	=> p_copy_only_header,
		P_New_Version		=> p_new_version,
		P_Qte_Status_Id		=> p_qte_status_id,
		P_Qte_Number		=> p_qte_number,
		X_Qte_Header_Id		=> x_qte_header_id,
		X_Return_Status         => x_return_status,
		X_Msg_Count             => x_msg_count,
		X_Msg_Data              => x_msg_data);

Line: 1283

    P_Last_Update_Date	  => l_Last_Update_Date,
    P_Copy_Only_Header		 => l_Copy_Only_Header,
    P_New_Version		 => l_New_Version,
    P_Qte_Status_Id		=> l_Qte_Status_Id	,
    P_Qte_Number		 => l_Qte_Number	,
    P_NEW_Qte_Header_Id  => l_NEW_Qte_Header_Id,
    X_Return_Status      => X_Return_Status ,
    X_Msg_Count           =>     X_Msg_Count,
    X_Msg_Data            =>        X_Msg_Data
    );

Line: 1309

    P_Last_Update_Date	  => l_Last_Update_Date,
    P_Copy_Only_Header		 => l_Copy_Only_Header,
    P_New_Version		 => l_New_Version,
    P_Qte_Status_Id		=> l_Qte_Status_Id	,
    P_Qte_Number		 => l_Qte_Number	,
    P_NEW_Qte_Header_Id  => l_NEW_Qte_Header_Id,
    X_Return_Status      => X_Return_Status ,
    X_Msg_Count           =>     X_Msg_Count,
    X_Msg_Data            =>        X_Msg_Data
    );

Line: 1392

    P_Last_Update_Date         IN   DATE,
    P_Copy_Only_Header         IN   VARCHAR2    := FND_API.G_FALSE,
    P_New_Version         IN   VARCHAR2    := FND_API.G_FALSE,
    P_Qte_Status_Id       IN   NUMBER      := NULL,
    P_Qte_Number          IN   NUMBER      := NULL,
    X_Qte_Header_Id       OUT NOCOPY /* file.sql.39 change */  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_api_name                CONSTANT VARCHAR2(30) := 'COPY_QUOTE';

Line: 1407

    l_Last_Update_Date DATE;

Line: 1423

		P_Last_Update_Date	=> p_last_update_date,
		P_Copy_Only_Header	=> p_copy_only_header,
		P_New_Version		=> p_new_version,
		P_Qte_Status_Id		=> p_qte_status_id,
		P_Qte_Number		=> p_qte_number,
		X_Qte_Header_Id		=> x_qte_header_id,
		X_Return_Status         => x_return_status,
		X_Msg_Count             => x_msg_count,
		X_Msg_Data              => x_msg_data);

Line: 1491

    P_Update_Header_Flag    IN  VARCHAR2   := FND_API.G_TRUE,
    X_Qte_Line_Rec          OUT NOCOPY /* file.sql.39 change */  Qte_Line_Rec_Type,
    X_Qte_Line_Dtl_TBL      OUT NOCOPY /* file.sql.39 change */  Qte_Line_Dtl_TBL_Type,
    X_Line_Attribs_Ext_Tbl  OUT NOCOPY /* file.sql.39 change */  Line_Attribs_Ext_Tbl_type,
    X_Payment_Tbl           OUT NOCOPY /* file.sql.39 change */  Payment_Tbl_Type,
    X_Price_Adj_Tbl         OUT NOCOPY /* file.sql.39 change */  Price_Adj_Tbl_Type,
    X_Price_Attributes_Tbl  OUT NOCOPY /* file.sql.39 change */  Price_Attributes_Tbl_Type ,
    X_Price_Adj_Attr_Tbl    OUT NOCOPY /* file.sql.39 change */  Price_Adj_Attr_Tbl_Type,
    X_Shipment_Tbl          OUT NOCOPY /* file.sql.39 change */  Shipment_Tbl_Type,
    X_Tax_Detail_Tbl        OUT NOCOPY /* file.sql.39 change */  Tax_Detail_Tbl_Type,
    X_Freight_Charge_Tbl    OUT NOCOPY /* file.sql.39 change */  Freight_Charge_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
X_Sales_Credit_Tbl  Sales_Credit_Tbl_Type;

Line: 1528

    P_Update_Header_Flag    =>p_Update_Header_Flag ,
    X_qte_line_rec         => X_qte_line_rec,
    X_payment_tbl	   => x_payment_tbl,
    X_Price_Adj_Tbl        => x_price_adj_tbl,
    X_Qte_Line_Dtl_Tbl     => x_qte_line_dtl_tbl,
    X_Shipment_Tbl         => x_shipment_tbl,
    X_Tax_Detail_Tbl       => x_tax_detail_tbl,
    X_Freight_Charge_Tbl   => x_freight_charge_tbl,
    X_Price_Attributes_Tbl => x_price_attributes_tbl,
    X_Price_Adj_Attr_Tbl    => x_Price_Adj_Attr_Tbl,
    X_Line_Attribs_Ext_Tbl  => x_Line_Attribs_Ext_Tbl,
    X_Sales_Credit_Tbl      => X_Sales_Credit_Tbl ,
    X_Quote_Party_Tbl       => X_Quote_Party_Tbl,
    X_Return_Status        => x_return_status,
    X_Msg_Count            => x_msg_count,
    X_Msg_Data             => x_msg_data
    );

Line: 1588

PROCEDURE Update_Quote_Line(
    P_Api_Version_Number   IN   NUMBER,
    P_Init_Msg_List        IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit               IN   VARCHAR2     := FND_API.G_FALSE,
    P_Qte_Line_Rec         IN   Qte_Line_Rec_Type  := G_MISS_qte_line_REC,
    P_Control_Rec          IN   Control_rec_Type   := G_MISS_control_REC,
    P_Qte_Line_Dtl_Tbl     IN   Qte_Line_Dtl_Tbl_Type  := G_MISS_qte_line_dtl_TBL,
    P_Line_Attribs_Ext_Tbl IN   Line_Attribs_Ext_Tbl_type
                                        := G_Miss_Line_Attribs_Ext_Tbl,
    P_Payment_Tbl          IN   Payment_Tbl_Type   := G_MISS_Payment_TBL,
    P_Price_Adj_Tbl        IN   Price_Adj_Tbl_Type := G_MISS_Price_Adj_TBL,
    P_Price_Attributes_Tbl IN   Price_Attributes_Tbl_Type := G_MISS_Price_attributes_TBL,
    P_Price_Adj_Attr_Tbl    IN  Price_Adj_Attr_Tbl_Type
					:= G_Miss_PRICE_ADJ_ATTR_Tbl,
    P_Shipment_Tbl          IN  Shipment_Tbl_Type   := G_MISS_shipment_TBL,
    P_Tax_Detail_Tbl        IN  Tax_Detail_Tbl_Type:= G_MISS_tax_detail_TBL,
    P_Freight_Charge_Tbl    IN  Freight_Charge_Tbl_Type   := G_MISS_freight_charge_TBL,
    P_Update_Header_Flag    IN  VARCHAR2   := FND_API.G_TRUE,
    X_Qte_Line_Rec          OUT NOCOPY /* file.sql.39 change */  Qte_Line_Rec_Type,
    X_Qte_Line_Dtl_Tbl      OUT NOCOPY /* file.sql.39 change */  Qte_Line_Dtl_Tbl_Type,
    X_Line_Attribs_Ext_Tbl  OUT NOCOPY /* file.sql.39 change */  Line_Attribs_Ext_Tbl_type,
    X_Payment_Tbl           OUT NOCOPY /* file.sql.39 change */  Payment_Tbl_Type,
    X_Price_Adj_Tbl         OUT NOCOPY /* file.sql.39 change */  Price_Adj_Tbl_Type,
    X_Price_Attributes_Tbl  OUT NOCOPY /* file.sql.39 change */  Price_Attributes_Tbl_Type ,
    X_Price_Adj_Attr_Tbl    OUT NOCOPY /* file.sql.39 change */  Price_Adj_Attr_Tbl_Type,
    X_Shipment_Tbl          OUT NOCOPY /* file.sql.39 change */  Shipment_Tbl_Type,
    X_Tax_Detail_Tbl        OUT NOCOPY /* file.sql.39 change */  Tax_Detail_Tbl_Type,
    X_Freight_Charge_Tbl    OUT NOCOPY /* file.sql.39 change */  Freight_Charge_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

X_Sales_Credit_Tbl  Sales_Credit_Tbl_Type;

Line: 1628

Update_Quote_Line(
    P_Api_Version_Number  => 1.0,
    P_Init_Msg_List       => p_init_msg_list,
    P_Commit              => p_commit,
    P_Qte_Line_Rec        => p_qte_line_rec,
    P_Control_REC         => p_control_rec      ,
    P_Payment_Tbl         => p_payment_tbl      ,
    P_Price_Adj_Tbl       => p_price_adj_tbl ,
    P_Qte_Line_Dtl_TBL    => p_Qte_Line_Dtl_TBL ,
    P_Shipment_Tbl        => p_Shipment_Tbl ,
    P_Tax_Detail_Tbl      => p_Tax_Detail_Tbl ,
    P_Freight_Charge_Tbl  => p_Freight_Charge_Tbl,
    P_Price_Attributes_Tbl => p_Price_Attributes_Tbl,
    P_Price_Adj_Attr_Tbl    =>p_Price_Adj_Attr_Tbl,
    P_Line_Attribs_Ext_Tbl  =>p_Line_Attribs_Ext_Tbl,
    P_Update_Header_Flag    =>p_Update_Header_Flag ,
    X_qte_line_rec         => X_qte_line_rec,
    X_payment_tbl	   => x_payment_tbl,
    X_Price_Adj_Tbl        => x_price_adj_tbl,
    X_Qte_Line_Dtl_tbl     => x_qte_line_dtl_tbl,
    X_Shipment_Tbl         => x_shipment_tbl,
    X_Tax_Detail_Tbl       => x_tax_detail_tbl,
    X_Freight_Charge_Tbl   => x_freight_charge_tbl,
    X_Price_Attributes_Tbl => x_price_attributes_tbl,
    X_Price_Adj_Attr_Tbl    =>x_Price_Adj_Attr_Tbl,
    X_Line_Attribs_Ext_Tbl  =>x_Line_Attribs_Ext_Tbl,
    X_Sales_Credit_Tbl      => X_Sales_Credit_Tbl,
    X_Quote_Party_Tbl       => X_Quote_Party_Tbl,
    X_Return_Status        => x_return_status,
    X_Msg_Count            => x_msg_count,
    X_Msg_Data             => x_msg_data
    );

Line: 1661

END Update_Quote_Line;

Line: 1693

PROCEDURE Delete_Quote_Line(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    P_qte_line_Rec     IN qte_line_Rec_Type,
    P_Control_Rec      IN    Control_rec_Type   := G_MISS_control_REC,
    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
aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

Line: 1707

   Delete_Quote_Line(
    P_Api_Version_Number  => 1.0,
    P_Init_Msg_List       => P_Init_Msg_List  ,
    P_Commit              => p_commit,
    P_qte_line_Rec        => P_qte_line_Rec,
    P_Control_Rec         => p_control_rec,
    P_Update_Header_Flag  => 'N',
    X_Return_Status       => X_Return_Status,
    X_Msg_Count           => x_msg_count,
    X_Msg_Data            => x_msg_data
    );

Line: 1718

End Delete_quote_line;

Line: 1879

PROCEDURE Update_quote(
    P_Api_Version_Number         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,
    P_Control_Rec		        IN   Control_Rec_Type                        := G_Miss_Control_Rec,
    P_Qte_Header_Rec		   IN   Qte_Header_Rec_Type                     := G_MISS_Qte_Header_Rec,
    P_hd_Price_Attributes_Tbl	   IN   ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
    P_hd_Payment_Tbl		   IN   ASO_QUOTE_PUB.Payment_Tbl_Type          := G_MISS_PAYMENT_TBL,
    P_hd_Shipment_Tbl		   IN   ASO_QUOTE_PUB.Shipment_Tbl_Type         := G_MISS_SHIPMENT_TBL,
    P_hd_Freight_Charge_Tbl	   IN   ASO_QUOTE_PUB.Freight_Charge_Tbl_Type   := G_Miss_Freight_Charge_Tbl,
    P_hd_Tax_Detail_Tbl		   IN   ASO_QUOTE_PUB.Tax_Detail_Tbl_Type       := G_Miss_Tax_Detail_Tbl,
    P_hd_Attr_Ext_Tbl		   IN   Line_Attribs_Ext_Tbl_Type               := G_MISS_Line_Attribs_Ext_TBL,
    P_hd_Sales_Credit_Tbl        IN   Sales_Credit_Tbl_Type                   := G_MISS_Sales_Credit_Tbl,
    P_hd_Quote_Party_Tbl         IN   Quote_Party_Tbl_Type                    := G_MISS_Quote_Party_Tbl,
    P_Qte_Line_Tbl		        IN   Qte_Line_Tbl_Type                       := G_MISS_QTE_LINE_TBL,
    P_Qte_Line_Dtl_Tbl		   IN   Qte_Line_Dtl_Tbl_Type                   := G_MISS_QTE_LINE_DTL_TBL,
    P_Line_Attr_Ext_Tbl		   IN   Line_Attribs_Ext_Tbl_Type               := G_MISS_Line_Attribs_Ext_TBL,
    P_line_rltship_tbl		   IN   Line_Rltship_Tbl_Type                   := G_MISS_Line_Rltship_Tbl,
    P_Price_Adjustment_Tbl	   IN   Price_Adj_Tbl_Type                      := G_Miss_Price_Adj_Tbl,
    P_Price_Adj_Attr_Tbl	        IN   Price_Adj_Attr_Tbl_Type                 := G_Miss_PRICE_ADJ_ATTR_Tbl,
    P_Price_Adj_Rltship_Tbl	   IN   Price_Adj_Rltship_Tbl_Type              := G_Miss_Price_Adj_Rltship_Tbl,
    P_Ln_Price_Attributes_Tbl	   IN   Price_Attributes_Tbl_Type               := G_Miss_Price_Attributes_Tbl,
    P_Ln_Payment_Tbl		   IN   Payment_Tbl_Type                        := G_MISS_PAYMENT_TBL,
    P_Ln_Shipment_Tbl		   IN   Shipment_Tbl_Type                       := G_MISS_SHIPMENT_TBL,
    P_Ln_Freight_Charge_Tbl	   IN   Freight_Charge_Tbl_Type                 := G_Miss_Freight_Charge_Tbl,
    P_Ln_Tax_Detail_Tbl		   IN   Tax_Detail_Tbl_Type                     := G_Miss_Tax_Detail_Tbl,
    P_ln_Sales_Credit_Tbl        IN   Sales_Credit_Tbl_Type                   := G_MISS_Sales_Credit_Tbl,
    P_ln_Quote_Party_Tbl         IN   Quote_Party_Tbl_Type                    := G_MISS_Quote_Party_Tbl,
    x_Qte_Header_Rec		   OUT NOCOPY /* file.sql.39 change */  Qte_Header_Rec_Type,
    X_Qte_Line_Tbl		        OUT NOCOPY /* file.sql.39 change */  Qte_Line_Tbl_Type,
    X_Qte_Line_Dtl_Tbl		   OUT NOCOPY /* file.sql.39 change */  Qte_Line_Dtl_Tbl_Type,
    X_Hd_Price_Attributes_Tbl	   OUT NOCOPY /* file.sql.39 change */  Price_Attributes_Tbl_Type,
    X_Hd_Payment_Tbl		   OUT NOCOPY /* file.sql.39 change */  Payment_Tbl_Type,
    X_Hd_Shipment_Tbl		   OUT NOCOPY /* file.sql.39 change */  Shipment_Tbl_Type,
    X_Hd_Freight_Charge_Tbl	   OUT NOCOPY /* file.sql.39 change */  Freight_Charge_Tbl_Type,
    X_Hd_Tax_Detail_Tbl		   OUT NOCOPY /* file.sql.39 change */  Tax_Detail_Tbl_Type,
    X_hd_Attr_Ext_Tbl		   OUT NOCOPY /* file.sql.39 change */  Line_Attribs_Ext_Tbl_Type,
    X_hd_Sales_Credit_Tbl        OUT NOCOPY /* file.sql.39 change */  Sales_Credit_Tbl_Type,
    X_hd_Quote_Party_Tbl         OUT NOCOPY /* file.sql.39 change */  Quote_Party_Tbl_Type,
    x_Line_Attr_Ext_Tbl		   OUT NOCOPY /* file.sql.39 change */  Line_Attribs_Ext_Tbl_Type,
    X_line_rltship_tbl		   OUT NOCOPY /* file.sql.39 change */  Line_Rltship_Tbl_Type,
    X_Price_Adjustment_Tbl	   OUT NOCOPY /* file.sql.39 change */  Price_Adj_Tbl_Type,
    X_Price_Adj_Attr_Tbl	        OUT NOCOPY /* file.sql.39 change */  Price_Adj_Attr_Tbl_Type,
    X_Price_Adj_Rltship_Tbl	   OUT NOCOPY /* file.sql.39 change */  Price_Adj_Rltship_Tbl_Type,
    X_Ln_Price_Attributes_Tbl	   OUT NOCOPY /* file.sql.39 change */  Price_Attributes_Tbl_Type,
    X_Ln_Payment_Tbl		   OUT NOCOPY /* file.sql.39 change */  Payment_Tbl_Type,
    X_Ln_Shipment_Tbl		   OUT NOCOPY /* file.sql.39 change */  Shipment_Tbl_Type,
    X_Ln_Freight_Charge_Tbl	   OUT NOCOPY /* file.sql.39 change */  Freight_Charge_Tbl_Type,
    X_Ln_Tax_Detail_Tbl		   OUT NOCOPY /* file.sql.39 change */  Tax_Detail_Tbl_Type,
    X_Ln_Sales_Credit_Tbl        OUT NOCOPY /* file.sql.39 change */  Sales_Credit_Tbl_Type,
    X_Ln_Quote_Party_Tbl         OUT NOCOPY /* file.sql.39 change */  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
    x_Qte_Access_Tbl           Qte_Access_Tbl_Type;

Line: 1943

         aso_debug_pub.add('Before call to the second overloaded update_quote procedure.',1, 'Y');

Line: 1946

     Update_quote(
	    P_Api_Version_Number	      => 1.0,
	    P_Init_Msg_List		      => p_init_msg_list,
	    P_Commit			      => p_commit,
	    P_Control_Rec		      => p_control_rec,
	    P_qte_header_rec		 => p_qte_header_rec,
	    P_Hd_Price_Attributes_Tbl	 => p_Hd_Price_Attributes_Tbl,
	    P_Hd_Payment_Tbl		 => p_Hd_Payment_Tbl,
	    P_Hd_Shipment_Tbl		 => p_Hd_Shipment_Tbl,
	    P_hd_Sales_Credit_Tbl	 => P_hd_Sales_Credit_Tbl,   --Yogeshwar(# Added parameter to address sales credit allocation issue)
	    P_ln_Sales_Credit_Tbl	 => P_ln_Sales_Credit_Tbl,   --Yogeshwar(# Added parameter to address sales credit allocation issue)
	    P_Hd_Freight_Charge_Tbl	 => p_Hd_Freight_Charge_Tbl,
	    P_Hd_Tax_Detail_Tbl		 => p_Hd_Tax_Detail_Tbl,
	    P_Qte_Line_Tbl		      => p_Qte_Line_Tbl,
	    P_Qte_Line_Dtl_Tbl		 => p_Qte_Line_Dtl_Tbl,
	    P_Line_Attr_Ext_Tbl		 => P_Line_Attr_Ext_Tbl,
	    P_Line_rltship_tbl		 => p_Line_Rltship_Tbl,
	    P_Price_Adjustment_Tbl	 => p_Price_Adjustment_Tbl,
	    P_Price_Adj_Attr_Tbl	      => P_Price_Adj_Attr_Tbl,
	    P_Price_Adj_Rltship_Tbl	 => p_Price_Adj_Rltship_Tbl,
	    P_Ln_Price_Attributes_Tbl	 => p_Ln_Price_Attributes_Tbl,
	    P_Ln_Payment_Tbl		 => p_Ln_Payment_Tbl,
	    P_Ln_Shipment_Tbl		 => p_Ln_Shipment_Tbl,
	    P_Ln_Freight_Charge_Tbl	 => p_Ln_Freight_Charge_Tbl,
	    P_Ln_Tax_Detail_Tbl		 => p_Ln_Tax_Detail_Tbl,
	    x_qte_header_rec		 => x_qte_header_rec,
	    X_Hd_Price_Attributes_Tbl	 => x_Hd_Price_Attributes_Tbl,
	    X_Hd_Payment_Tbl		 => x_Hd_Payment_Tbl,
	    X_Hd_Shipment_tbl		 => x_Hd_Shipment_tbl,
	    X_Hd_Freight_Charge_Tbl	 => x_Hd_Freight_Charge_Tbl,
	    X_Hd_Tax_Detail_Tbl		 => x_Hd_Tax_Detail_Tbl,
         X_hd_Attr_Ext_Tbl		 => X_hd_Attr_Ext_Tbl,
         X_hd_Sales_Credit_Tbl      => X_hd_Sales_Credit_Tbl,
         X_hd_Quote_Party_Tbl       => X_hd_Quote_Party_Tbl,
	    X_Qte_Line_Tbl		      => x_Qte_Line_Tbl,
	    X_Qte_Line_Dtl_Tbl		 => x_Qte_Line_Dtl_Tbl,
	    x_Line_Attr_Ext_Tbl		 => x_Line_Attr_Ext_Tbl,
	    X_Line_rltship_tbl		 => x_Line_Rltship_Tbl,
	    X_Price_Adjustment_Tbl	 => x_Price_Adjustment_Tbl,
	    x_Price_Adj_Attr_Tbl	      => x_Price_Adj_Attr_Tbl,
	    X_Price_Adj_Rltship_Tbl	 => x_Price_Adj_Rltship_Tbl,
	    X_Ln_Price_Attributes_Tbl	 => x_Ln_Price_Attributes_Tbl,
	    X_Ln_Payment_Tbl		 => x_Ln_Payment_Tbl,
	    X_Ln_Shipment_Tbl		 => x_Ln_Shipment_Tbl,
	    X_Ln_Freight_Charge_Tbl	 => x_Ln_Freight_Charge_Tbl,
	    X_Ln_Tax_Detail_Tbl		 => x_Ln_Tax_Detail_Tbl,
         X_Ln_Sales_Credit_Tbl      => X_ln_Sales_Credit_Tbl,
         X_Ln_Quote_Party_Tbl       => X_ln_Quote_Party_Tbl,
         x_Qte_Access_Tbl           => x_Qte_Access_Tbl,
         x_Template_Tbl             => x_Template_Tbl,
	    X_Related_Obj_Tbl          => X_Related_Obj_Tbl,
	    X_Return_Status            => x_return_status,
	    X_Msg_Count                => x_msg_count,
	    X_Msg_Data                 => x_msg_data);

Line: 2002

       aso_debug_pub.add('After call to the second overloaded update_quote procedure: x_return_status: '|| x_return_status, 1, 'Y');

Line: 2005

End Update_quote;

Line: 2090

    P_Update_Header_Flag    IN  VARCHAR2   := FND_API.G_TRUE,
    X_Qte_Line_Rec          OUT NOCOPY /* file.sql.39 change */  Qte_Line_Rec_Type,
    X_Qte_Line_Dtl_TBL      OUT NOCOPY /* file.sql.39 change */  Qte_Line_Dtl_TBL_Type,
    X_Line_Attribs_Ext_Tbl  OUT NOCOPY /* file.sql.39 change */  Line_Attribs_Ext_Tbl_type,
    X_Payment_Tbl           OUT NOCOPY /* file.sql.39 change */  Payment_Tbl_Type,
    X_Price_Adj_Tbl         OUT NOCOPY /* file.sql.39 change */  Price_Adj_Tbl_Type,
    X_Price_Attributes_Tbl  OUT NOCOPY /* file.sql.39 change */  Price_Attributes_Tbl_Type ,
    X_Price_Adj_Attr_Tbl    OUT NOCOPY /* file.sql.39 change */  Price_Adj_Attr_Tbl_Type,
    X_Shipment_Tbl          OUT NOCOPY /* file.sql.39 change */  Shipment_Tbl_Type,
    X_Tax_Detail_Tbl        OUT NOCOPY /* file.sql.39 change */  Tax_Detail_Tbl_Type,
    X_Freight_Charge_Tbl    OUT NOCOPY /* file.sql.39 change */  Freight_Charge_Tbl_Type ,
    X_Sales_Credit_Tbl      OUT NOCOPY /* file.sql.39 change */  Sales_Credit_Tbl_Type,
    X_Quote_Party_Tbl       OUT NOCOPY /* file.sql.39 change */  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
    l_api_name                CONSTANT VARCHAR2(30) := 'CREATE_QUOTE_LINE';

Line: 2129

        l_update_header_flag    VARCHAR2(10);

Line: 2181

        l_update_header_flag    := p_update_header_flag   ;

Line: 2204

    	  P_Update_Header_Flag  => l_update_header_flag,
    	  X_Return_Status       => x_return_status ,
    	  X_Msg_Count           => x_msg_count     ,
          X_Msg_Data            => x_msg_data
          );

Line: 2241

    	  P_Update_Header_Flag  => l_update_header_flag,
    	  X_Return_Status       => x_return_status ,
    	  X_Msg_Count           => x_msg_count     ,
          X_Msg_Data            => x_msg_data
          );

Line: 2300

    P_Update_Header_Flag    =>l_Update_Header_Flag ,
    X_qte_line_rec         => X_qte_line_rec,
    X_payment_tbl	   => x_payment_tbl,
    X_Price_Adj_Tbl        => x_price_adj_tbl,
    X_Qte_Line_Dtl_Tbl     => x_qte_line_dtl_tbl,
    X_Shipment_Tbl         => x_shipment_tbl,
    X_Tax_Detail_Tbl       => x_tax_detail_tbl,
    X_Freight_Charge_Tbl   => x_freight_charge_tbl,
    X_Price_Attributes_Tbl => x_price_attributes_tbl,
    X_Price_Adj_Attr_Tbl    => x_Price_Adj_Attr_Tbl,
    X_Line_Attribs_Ext_Tbl  => x_Line_Attribs_Ext_Tbl,
    X_Sales_Credit_Tbl      => X_Sales_Credit_Tbl,
    X_Quote_Party_Tbl      => X_Quote_Party_Tbl,
    X_Return_Status        => x_return_status,
    X_Msg_Count            => x_msg_count,
    X_Msg_Data             => x_msg_data
    );

Line: 2354

    	  P_Update_Header_Flag  => l_update_header_flag,
    	  X_Return_Status       => x_return_status ,
    	  X_Msg_Count           => x_msg_count     ,
          X_Msg_Data            => x_msg_data
          );

Line: 2397

    	  P_Update_Header_Flag  => l_update_header_flag,
    	  X_Return_Status       => x_return_status ,
    	  X_Msg_Count           => x_msg_count     ,
          X_Msg_Data            => x_msg_data
          );

Line: 2488

PROCEDURE Update_Quote_Line(
    P_Api_Version_Number  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,
    P_Qte_Header_Rec           IN    Qte_Header_Rec_Type  := G_MISS_Qte_Header_Rec,
    P_Qte_Line_Rec        IN    Qte_Line_Rec_Type  := G_MISS_qte_line_REC,
    P_Control_Rec         IN    Control_rec_Type   := G_MISS_control_REC,
    P_Qte_Line_Dtl_TBL   IN    Qte_Line_Dtl_tbl_Type:= G_MISS_qte_line_dtl_TBL,
    P_Line_Attribs_Ext_Tbl  IN   Line_Attribs_Ext_Tbl_type
                                        := G_Miss_Line_Attribs_Ext_Tbl,
    P_Payment_Tbl           IN    Payment_Tbl_Type   := G_MISS_Payment_TBL,
    P_Price_Adj_Tbl         IN    Price_Adj_Tbl_Type := G_MISS_Price_Adj_TBL,
    P_Price_Attributes_Tbl  IN   Price_Attributes_Tbl_Type := G_MISS_Price_attributes_TBL,
    P_Price_Adj_Attr_Tbl    IN   Price_Adj_Attr_Tbl_Type
					:= G_Miss_PRICE_ADJ_ATTR_Tbl,
    P_Shipment_Tbl          IN    Shipment_Tbl_Type   := G_MISS_shipment_TBL,
    P_Tax_Detail_Tbl        IN    Tax_Detail_Tbl_Type:= G_MISS_tax_detail_TBL,
    P_Freight_Charge_Tbl    IN   Freight_Charge_Tbl_Type   := G_MISS_freight_charge_TBL,
    P_Sales_Credit_Tbl        IN   Sales_Credit_Tbl_Type
                                        := G_MISS_Sales_Credit_Tbl,
    P_Quote_Party_Tbl         IN   Quote_Party_Tbl_Type
                                        := G_MISS_Quote_Party_Tbl,
    P_Update_Header_Flag    IN   VARCHAR2   := FND_API.G_TRUE,
    X_Qte_Line_Rec          OUT NOCOPY /* file.sql.39 change */  Qte_Line_Rec_Type,
    X_Qte_Line_Dtl_TBL      OUT NOCOPY /* file.sql.39 change */  Qte_Line_Dtl_TBL_Type,
    X_Line_Attribs_Ext_Tbl  OUT NOCOPY /* file.sql.39 change */  Line_Attribs_Ext_Tbl_type,
    X_Payment_Tbl           OUT NOCOPY /* file.sql.39 change */  Payment_Tbl_Type,
    X_Price_Adj_Tbl         OUT NOCOPY /* file.sql.39 change */  Price_Adj_Tbl_Type,
    X_Price_Attributes_Tbl  OUT NOCOPY /* file.sql.39 change */  Price_Attributes_Tbl_Type ,
    X_Price_Adj_Attr_Tbl    OUT NOCOPY /* file.sql.39 change */  Price_Adj_Attr_Tbl_Type,
    X_Shipment_Tbl          OUT NOCOPY /* file.sql.39 change */  Shipment_Tbl_Type,
    X_Tax_Detail_Tbl        OUT NOCOPY /* file.sql.39 change */  Tax_Detail_Tbl_Type,
    X_Freight_Charge_Tbl    OUT NOCOPY /* file.sql.39 change */  Freight_Charge_Tbl_Type ,
    X_Sales_Credit_Tbl      OUT NOCOPY /* file.sql.39 change */  Sales_Credit_Tbl_Type,
    X_Quote_Party_Tbl       OUT NOCOPY /* file.sql.39 change */  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

     l_api_name                CONSTANT VARCHAR2(30) := 'UPDATE_QUOTE_LINE';

Line: 2549

        l_update_header_flag    VARCHAR2(10);

Line: 2556

      SAVEPOINT UPDATE_QUOTE_LINE_PUB;

Line: 2601

        l_update_header_flag    := p_update_header_flag   ;

Line: 2613

          ASO_QUOTE_CUHK.Update_Quote_Line_PRE(
    	  P_Qte_Line_Rec        => l_qte_line_rec      ,
    	  P_Control_Rec         => l_control_rec       ,
    	  P_Qte_Line_Dtl_Tbl    => l_qte_line_dtl_tbl  ,
    	  P_Line_Attribs_Ext_Tbl =>l_line_attribs_ext_tbl,
          P_Payment_Tbl         => l_payment_tbl,
    	  P_Price_Adj_Tbl       => l_price_adj_tbl,
    	  P_Price_Attributes_Tbl =>l_price_attributes_tbl,
    	  P_Price_Adj_Attr_Tbl  => l_price_adj_attr_tbl,
          P_Shipment_Tbl        => l_shipment_tbl      ,
    	  P_Tax_Detail_Tbl      => l_tax_detail_tbl    ,
    	  P_Freight_Charge_Tbl  => l_freight_charge_tbl,
           P_Sales_Credit_Tbl    => l_Sales_Credit_Tbl  ,
          P_Quote_Party_Tbl     => l_Quote_Party_Tbl,
    	  P_Update_Header_Flag  => l_update_header_flag,
    	  X_Return_Status       => x_return_status ,
    	  X_Msg_Count           => x_msg_count     ,
          X_Msg_Data            => x_msg_data
          );

Line: 2636

		  FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_Line_PRE', FALSE);

Line: 2650

          ASO_QUOTE_VUHK.Update_Quote_Line_PRE(
    	  P_Qte_Line_Rec        => l_qte_line_rec      ,
    	  P_Control_Rec         => l_control_rec       ,
    	  P_Qte_Line_Dtl_Tbl    => l_qte_line_dtl_tbl  ,
    	  P_Line_Attribs_Ext_Tbl =>l_line_attribs_ext_tbl,
          P_Payment_Tbl         => l_payment_tbl,
    	  P_Price_Adj_Tbl       => l_price_adj_tbl,
    	  P_Price_Attributes_Tbl =>l_price_attributes_tbl,
    	  P_Price_Adj_Attr_Tbl  => l_price_adj_attr_tbl,
          P_Shipment_Tbl        => l_shipment_tbl      ,
    	  P_Tax_Detail_Tbl      => l_tax_detail_tbl    ,
    	  P_Freight_Charge_Tbl  => l_freight_charge_tbl,
           P_Sales_Credit_Tbl    => l_Sales_Credit_Tbl  ,
          P_Quote_Party_Tbl     => l_Quote_Party_Tbl,
    	  P_Update_Header_Flag  => l_update_header_flag,
    	  X_Return_Status       => x_return_status ,
    	  X_Msg_Count           => x_msg_count     ,
          X_Msg_Data            => x_msg_data
          );

Line: 2673

		  FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_Line_PRE', FALSE);

Line: 2706

  ASO_QUOTE_LINES_PVT.Update_Quote_Line(
    P_Api_Version_Number  => 1.0,
    P_Init_Msg_List       => p_init_msg_list,
    P_Commit              => p_commit,
    P_Validation_Level    => p_validation_level,
    p_qte_header_rec      => p_qte_header_rec,
    P_Qte_Line_Rec        => l_qte_line_rec,
    P_Control_REC         => l_control_rec   ,
    P_Payment_Tbl         => l_payment_tbl   ,
    P_Price_Adj_Tbl       => l_price_adj_tbl ,
    P_Qte_Line_Dtl_TBL    => l_Qte_Line_Dtl_TBL ,
    P_Shipment_Tbl        => l_Shipment_Tbl ,
    P_Tax_Detail_Tbl      => l_Tax_Detail_Tbl ,
    P_Freight_Charge_Tbl  => l_Freight_Charge_Tbl,
    P_Price_Attributes_Tbl => l_Price_Attributes_Tbl,
    P_Price_Adj_Attr_Tbl    =>l_Price_Adj_Attr_Tbl,
    P_Line_Attribs_Ext_Tbl  =>l_Line_Attribs_Ext_Tbl,
    P_Sales_Credit_Tbl    => l_Sales_Credit_Tbl  ,
    P_Quote_Party_Tbl     => l_Quote_Party_Tbl,
    P_Update_Header_Flag    =>l_Update_Header_Flag ,
    X_qte_line_rec         => X_qte_line_rec,
    X_payment_tbl	   => x_payment_tbl,
    X_Price_Adj_Tbl        => x_price_adj_tbl,
    X_Qte_Line_Dtl_tbl     => x_qte_line_dtl_tbl,
    X_Shipment_Tbl         => x_shipment_tbl,
    X_Tax_Detail_Tbl       => x_tax_detail_tbl,
    X_Freight_Charge_Tbl   => x_freight_charge_tbl,
    X_Price_Attributes_Tbl => x_price_attributes_tbl,
    X_Price_Adj_Attr_Tbl    =>x_Price_Adj_Attr_Tbl,
    X_Line_Attribs_Ext_Tbl  =>x_Line_Attribs_Ext_Tbl,
    X_Sales_Credit_Tbl      => X_Sales_Credit_Tbl,
    X_Quote_Party_Tbl       => X_Quote_Party_Tbl,
    X_Return_Status        => x_return_status,
    X_Msg_Count            => x_msg_count,
    X_Msg_Data             => x_msg_data
    );

Line: 2762

          ASO_QUOTE_CUHK.Update_Quote_Line_POST(
    	  P_Qte_Line_Rec        => x_qte_line_rec      ,
    	  P_Control_Rec         => l_control_rec       ,
    	  P_Qte_Line_Dtl_Tbl    => x_qte_line_dtl_tbl  ,
    	  P_Line_Attribs_Ext_Tbl =>x_line_attribs_ext_tbl,
          P_Payment_Tbl         => x_payment_tbl,
    	  P_Price_Adj_Tbl       => x_price_adj_tbl,
    	  P_Price_Attributes_Tbl =>x_price_attributes_tbl,
    	  P_Price_Adj_Attr_Tbl  => x_price_adj_attr_tbl,
          P_Shipment_Tbl        => x_shipment_tbl      ,
    	  P_Tax_Detail_Tbl      => x_tax_detail_tbl    ,
    	  P_Freight_Charge_Tbl  => x_freight_charge_tbl,
           P_Sales_Credit_Tbl    => x_Sales_Credit_Tbl  ,
          P_Quote_Party_Tbl     => x_Quote_Party_Tbl,
    	  P_Update_Header_Flag  => l_update_header_flag,
    	  X_Return_Status       => x_return_status ,
    	  X_Msg_Count           => x_msg_count     ,
          X_Msg_Data            => x_msg_data
          );

Line: 2785

		  FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_Line_POST', FALSE);

Line: 2797

         aso_debug_pub.add('aso_quote_vuhk: before if update quote line post (1)'||x_return_status,1, 'N');

Line: 2803

         aso_debug_pub.add('aso_quote_vuhk: inside if update quote line post (1)'||x_return_status,1, 'N');

Line: 2805

          ASO_QUOTE_VUHK.Update_Quote_Line_POST(
    	  P_Qte_Line_Rec        => x_qte_line_rec      ,
    	  P_Control_Rec         => l_control_rec       ,
    	  P_Qte_Line_Dtl_Tbl    => x_qte_line_dtl_tbl  ,
    	  P_Line_Attribs_Ext_Tbl =>x_line_attribs_ext_tbl,
          P_Payment_Tbl         => x_payment_tbl,
    	  P_Price_Adj_Tbl       => x_price_adj_tbl,
    	  P_Price_Attributes_Tbl =>x_price_attributes_tbl,
    	  P_Price_Adj_Attr_Tbl  => x_price_adj_attr_tbl,
          P_Shipment_Tbl        => x_shipment_tbl      ,
    	  P_Tax_Detail_Tbl      => x_tax_detail_tbl    ,
    	  P_Freight_Charge_Tbl  => x_freight_charge_tbl,
           P_Sales_Credit_Tbl    => x_Sales_Credit_Tbl  ,
          P_Quote_Party_Tbl     => x_Quote_Party_Tbl,
    	  P_Update_Header_Flag  => l_update_header_flag,
    	  X_Return_Status       => x_return_status ,
    	  X_Msg_Count           => x_msg_count     ,
          X_Msg_Data            => x_msg_data
          );

Line: 2826

	    aso_debug_pub.add('aso_quote_vuhk: after if update quote line post (1)'||x_return_status,1, 'N');

Line: 2832

		  FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_Line_POST', FALSE);

Line: 2901

PROCEDURE Delete_Quote_Line(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    P_qte_line_Rec     IN    qte_line_Rec_Type,
    P_Control_REC      IN    Control_Rec_Type := G_MISS_Control_Rec,
    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
    l_api_name                CONSTANT VARCHAR2(30) := 'DELETE_QUOTE_LINE';

Line: 2921

      SAVEPOINT DELETE_QUOTE_LINE_PUB;

Line: 2959

          ASO_QUOTE_CUHK.Delete_Quote_Line_PRE(
  	  P_qte_line_Rec     => l_qte_line_rec,
  	  P_Control_Rec      => l_control_rec,
  	  X_Return_Status    => x_return_status,
  	  X_Msg_Count        => x_msg_count ,
  	  X_Msg_Data         => x_msg_data
   	 );

Line: 2970

		  FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_Line_PRE', FALSE);

Line: 2984

          ASO_QUOTE_VUHK.Delete_Quote_Line_PRE(
  	  P_qte_line_Rec     => l_qte_line_rec,
  	  P_Control_Rec      => l_control_rec,
  	  X_Return_Status    => x_return_status,
  	  X_Msg_Count        => x_msg_count ,
  	  X_Msg_Data         => x_msg_data
   	 );

Line: 2994

		  FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_Line_PRE', FALSE);

Line: 3008

     ASO_QUOTE_LINES_PVT.Delete_quote_line(
		P_Api_Version_Number	=> 1.0,
		P_Init_Msg_List		=> FND_API.G_FALSE,
		P_Commit		=> p_commit,
                P_qte_line_Rec          => l_qte_line_Rec,
    		P_Control_Rec           => l_Control_Rec  ,
                P_Update_Header_Flag    => P_Update_Header_Flag ,
		X_Return_Status         => x_return_status,
		X_Msg_Count             => x_msg_count,
		X_Msg_Data              => x_msg_data );

Line: 3038

          ASO_QUOTE_CUHK.Delete_Quote_Line_POST(
  	  P_qte_line_Rec     => l_qte_line_rec,
  	  P_Control_Rec      => l_control_rec,
  	  X_Return_Status    => x_return_status,
  	  X_Msg_Count        => x_msg_count ,
  	  X_Msg_Data         => x_msg_data
   	 );

Line: 3049

		  FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_Line_POST', FALSE);

Line: 3061

         aso_debug_pub.add('aso_quote_vuhk: before if delete quote line post (1)'||x_return_status,1, 'N');

Line: 3067

         aso_debug_pub.add('aso_quote_vuhk: inside if delete quote line post (1)'||x_return_status,1, 'N');

Line: 3069

          ASO_QUOTE_VUHK.Delete_Quote_Line_POST(
  	  P_qte_line_Rec     => l_qte_line_rec,
  	  P_Control_Rec      => l_control_rec,
  	  X_Return_Status    => x_return_status,
  	  X_Msg_Count        => x_msg_count ,
  	  X_Msg_Data         => x_msg_data
   	 );

Line: 3077

         aso_debug_pub.add('aso_quote_vuhk: after if delete quote line post (1)'||x_return_status,1, 'N');

Line: 3084

		  FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_Line_POST', FALSE);

Line: 3152

End Delete_quote_line;

Line: 3687

       l_list.DELETE;

Line: 3743

       l_list.DELETE;

Line: 4341

PROCEDURE Update_quote(
    P_Api_Version_Number         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,
    P_Control_Rec		        IN   Control_Rec_Type                        := G_Miss_Control_Rec,
    P_Qte_Header_Rec		   IN   Qte_Header_Rec_Type                     := G_MISS_Qte_Header_Rec,
    P_hd_Price_Attributes_Tbl	   IN   ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
    P_hd_Payment_Tbl		   IN   ASO_QUOTE_PUB.Payment_Tbl_Type          := G_MISS_PAYMENT_TBL,
    P_hd_Shipment_Tbl		   IN   ASO_QUOTE_PUB.Shipment_Tbl_Type         := G_MISS_SHIPMENT_TBL,
    P_hd_Freight_Charge_Tbl	   IN   ASO_QUOTE_PUB.Freight_Charge_Tbl_Type   := G_Miss_Freight_Charge_Tbl,
    P_hd_Tax_Detail_Tbl		   IN   ASO_QUOTE_PUB.Tax_Detail_Tbl_Type       := G_Miss_Tax_Detail_Tbl,
    P_hd_Attr_Ext_Tbl		   IN   Line_Attribs_Ext_Tbl_Type               := G_MISS_Line_Attribs_Ext_TBL,
    P_hd_Sales_Credit_Tbl        IN   Sales_Credit_Tbl_Type                   := G_MISS_Sales_Credit_Tbl,
    P_hd_Quote_Party_Tbl         IN   Quote_Party_Tbl_Type                    := G_MISS_Quote_Party_Tbl,
    P_Qte_Line_Tbl		        IN   Qte_Line_Tbl_Type                       := G_MISS_QTE_LINE_TBL,
    P_Qte_Line_Dtl_Tbl		   IN   Qte_Line_Dtl_Tbl_Type                   := G_MISS_QTE_LINE_DTL_TBL,
    P_Line_Attr_Ext_Tbl		   IN   Line_Attribs_Ext_Tbl_Type               := G_MISS_Line_Attribs_Ext_TBL,
    P_line_rltship_tbl		   IN   Line_Rltship_Tbl_Type                   := G_MISS_Line_Rltship_Tbl,
    P_Price_Adjustment_Tbl	   IN   Price_Adj_Tbl_Type                      := G_Miss_Price_Adj_Tbl,
    P_Price_Adj_Attr_Tbl	        IN   Price_Adj_Attr_Tbl_Type                 := G_Miss_PRICE_ADJ_ATTR_Tbl,
    P_Price_Adj_Rltship_Tbl	   IN   Price_Adj_Rltship_Tbl_Type              := G_Miss_Price_Adj_Rltship_Tbl,
    P_Ln_Price_Attributes_Tbl	   IN   Price_Attributes_Tbl_Type               := G_Miss_Price_Attributes_Tbl,
    P_Ln_Payment_Tbl		   IN   Payment_Tbl_Type                        := G_MISS_PAYMENT_TBL,
    P_Ln_Shipment_Tbl		   IN   Shipment_Tbl_Type                       := G_MISS_SHIPMENT_TBL,
    P_Ln_Freight_Charge_Tbl	   IN   Freight_Charge_Tbl_Type                 := G_Miss_Freight_Charge_Tbl,
    P_Ln_Tax_Detail_Tbl		   IN   Tax_Detail_Tbl_Type                     := G_Miss_Tax_Detail_Tbl,
    P_ln_Sales_Credit_Tbl        IN   Sales_Credit_Tbl_Type                   := G_MISS_Sales_Credit_Tbl,
    P_ln_Quote_Party_Tbl         IN   Quote_Party_Tbl_Type                    := G_MISS_Quote_Party_Tbl,
    P_Qte_Access_Tbl             IN   Qte_Access_Tbl_Type                     := G_MISS_QTE_ACCESS_TBL,
    P_Template_Tbl               IN   Template_Tbl_Type                       := G_MISS_TEMPLATE_TBL,
    P_Related_Obj_Tbl            IN   Related_Obj_Tbl_Type                    := G_MISS_RELATED_OBJ_TBL,
    x_Qte_Header_Rec		   OUT NOCOPY /* file.sql.39 change */  Qte_Header_Rec_Type,
    X_Qte_Line_Tbl		        OUT NOCOPY /* file.sql.39 change */  Qte_Line_Tbl_Type,
    X_Qte_Line_Dtl_Tbl		   OUT NOCOPY /* file.sql.39 change */  Qte_Line_Dtl_Tbl_Type,
    X_Hd_Price_Attributes_Tbl	   OUT NOCOPY /* file.sql.39 change */  Price_Attributes_Tbl_Type,
    X_Hd_Payment_Tbl		   OUT NOCOPY /* file.sql.39 change */  Payment_Tbl_Type,
    X_Hd_Shipment_Tbl		   OUT NOCOPY /* file.sql.39 change */  Shipment_Tbl_Type,
    X_Hd_Freight_Charge_Tbl	   OUT NOCOPY /* file.sql.39 change */  Freight_Charge_Tbl_Type,
    X_Hd_Tax_Detail_Tbl		   OUT NOCOPY /* file.sql.39 change */  Tax_Detail_Tbl_Type,
    X_hd_Attr_Ext_Tbl		   OUT NOCOPY /* file.sql.39 change */  Line_Attribs_Ext_Tbl_Type,
    X_hd_Sales_Credit_Tbl        OUT NOCOPY /* file.sql.39 change */  Sales_Credit_Tbl_Type,
    X_hd_Quote_Party_Tbl         OUT NOCOPY /* file.sql.39 change */  Quote_Party_Tbl_Type,
    x_Line_Attr_Ext_Tbl		   OUT NOCOPY /* file.sql.39 change */  Line_Attribs_Ext_Tbl_Type,
    X_line_rltship_tbl		   OUT NOCOPY /* file.sql.39 change */  Line_Rltship_Tbl_Type,
    X_Price_Adjustment_Tbl	   OUT NOCOPY /* file.sql.39 change */  Price_Adj_Tbl_Type,
    X_Price_Adj_Attr_Tbl	        OUT NOCOPY /* file.sql.39 change */  Price_Adj_Attr_Tbl_Type,
    X_Price_Adj_Rltship_Tbl	   OUT NOCOPY /* file.sql.39 change */  Price_Adj_Rltship_Tbl_Type,
    X_Ln_Price_Attributes_Tbl	   OUT NOCOPY /* file.sql.39 change */  Price_Attributes_Tbl_Type,
    X_Ln_Payment_Tbl		   OUT NOCOPY /* file.sql.39 change */  Payment_Tbl_Type,
    X_Ln_Shipment_Tbl		   OUT NOCOPY /* file.sql.39 change */  Shipment_Tbl_Type,
    X_Ln_Freight_Charge_Tbl	   OUT NOCOPY /* file.sql.39 change */  Freight_Charge_Tbl_Type,
    X_Ln_Tax_Detail_Tbl		   OUT NOCOPY /* file.sql.39 change */  Tax_Detail_Tbl_Type,
    X_Ln_Sales_Credit_Tbl        OUT NOCOPY /* file.sql.39 change */  Sales_Credit_Tbl_Type,
    X_Ln_Quote_Party_Tbl         OUT NOCOPY /* file.sql.39 change */  Quote_Party_Tbl_Type,
    X_Qte_Access_Tbl             OUT NOCOPY /* file.sql.39 change */  Qte_Access_Tbl_Type,
    X_Template_Tbl               OUT NOCOPY /* file.sql.39 change */  Template_Tbl_Type,
    X_Related_Obj_Tbl            OUT NOCOPY /* file.sql.39 change */  Related_Obj_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
    l_api_name                 CONSTANT VARCHAR2(30) := 'UPDATE_QUOTE';

Line: 4442

      SAVEPOINT UPDATE_QUOTE_PUB;

Line: 4501

          ASO_QUOTE_CUHK.update_quote_PRE(
                            P_Validation_Level 	    => l_validation_level ,
                            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_Attribs_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_Attribs_Ext_Tbl,
                            P_line_rltship_tbl        => l_Line_Rltship_Tbl,
                            P_Price_Adjustment_Tbl    => l_Price_Adj_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,
					   /*
                            P_Qte_Access_Tbl          => l_Qte_Access_Tbl,
                            P_Template_Tbl            => l_Template_Tbl,
                            p_Related_Obj_Tbl         => l_Related_Obj_Tbl,
					   */
                            X_Return_Status           => X_Return_Status,
                            X_Msg_Count               => X_Msg_Count,
                            X_Msg_Data                => X_Msg_Data
                            );

Line: 4541

		        FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.update_Quote_PRE', FALSE);

Line: 4558

           ASO_QUOTE_VUHK.update_quote_PRE(
                            P_Validation_Level 	    => l_validation_level ,
                            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_Attribs_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_Attribs_Ext_Tbl,
                            P_line_rltship_tbl        => l_Line_Rltship_Tbl,
                            P_Price_Adjustment_Tbl    => l_Price_Adj_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,
					   /*
                            P_Qte_Access_Tbl          => l_Qte_Access_Tbl,
                            P_Template_Tbl            => l_Template_Tbl,
					   p_Related_Obj_Tbl         => l_Related_Obj_Tbl,
					   */
                            X_Return_Status           => X_Return_Status,
                            X_Msg_Count               => X_Msg_Count,
                            X_Msg_Data                => X_Msg_Data
                            );

Line: 4598

		         FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_PRE', FALSE);

Line: 4646

      ASO_QUOTE_HEADERS_PVT.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		 => p_validation_level,
	                         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_Attribs_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_Attribs_Ext_Tbl,
	                         P_Line_rltship_tbl		 => l_Line_Rltship_Tbl,
	                         P_Price_Adjustment_Tbl	 => l_Price_Adj_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,
                              P_Qte_Access_Tbl          => l_Qte_Access_Tbl,
                              P_Template_Tbl            => l_Template_Tbl,
					     p_Related_Obj_Tbl         => l_Related_Obj_Tbl,
	                         x_qte_header_rec		 => x_qte_header_rec,
	                         X_Hd_Price_Attributes_Tbl => x_Hd_Price_Attributes_Tbl,
	                         X_Hd_Payment_Tbl		 => x_Hd_Payment_Tbl,
	                         X_hd_Shipment_Tbl		 => X_hd_Shipment_Tbl,
	                         X_Hd_Freight_Charge_Tbl	 => x_Hd_Freight_Charge_Tbl,
	                         X_Hd_Tax_Detail_Tbl		 => x_Hd_Tax_Detail_Tbl,
                              X_hd_Attr_Ext_Tbl         => X_hd_Attr_Ext_Tbl,
                              X_hd_Sales_Credit_Tbl     => X_hd_Sales_Credit_Tbl,
                              X_hd_Quote_Party_Tbl      => X_hd_Quote_Party_Tbl,
	                         X_Qte_Line_Tbl		      => x_Qte_Line_Tbl,
	                         X_Qte_Line_Dtl_Tbl		 => x_Qte_Line_Dtl_Tbl,
	                         x_Line_Attr_Ext_Tbl		 => x_Line_Attr_Ext_Tbl,
	                         X_Line_rltship_tbl		 => x_Line_Rltship_Tbl,
	                         X_Price_Adjustment_Tbl	 => x_Price_Adjustment_Tbl,
	                         x_Price_Adj_Attr_Tbl	 => x_Price_Adj_Attr_Tbl,
	                         X_Price_Adj_Rltship_Tbl	 => x_Price_Adj_Rltship_Tbl,
	                         X_Ln_Price_Attributes_Tbl => x_Ln_Price_Attributes_Tbl,
	                         X_Ln_Payment_Tbl		 => x_Ln_Payment_Tbl,
	                         X_Ln_Shipment_Tbl		 => x_Ln_Shipment_Tbl,
	                         X_Ln_Freight_Charge_Tbl	 => x_Ln_Freight_Charge_Tbl,
	                         X_Ln_Tax_Detail_Tbl		 => x_Ln_Tax_Detail_Tbl,
                              X_Ln_Sales_Credit_Tbl     => X_Ln_Sales_Credit_Tbl,
                              X_Ln_Quote_Party_Tbl      => X_Ln_Quote_Party_Tbl ,
                              X_Qte_Access_Tbl          => X_Qte_Access_Tbl,
                              X_Template_Tbl            => X_Template_Tbl,
					     X_Related_Obj_Tbl         => X_Related_Obj_Tbl,
	                         X_Return_Status           => x_return_status,
	                         X_Msg_Count               => x_msg_count,
	                         X_Msg_Data                => x_msg_data);

Line: 4709

          aso_debug_pub.add('update_quote_pub: after update quote, starting user hooks (1)'||x_return_status,1, 'N');

Line: 4721

           ASO_QUOTE_CUHK.Update_quote_POST(
                            P_Validation_Level        => l_validation_level ,
                            P_Control_Rec             => l_control_rec ,
                            P_Qte_Header_Rec	         => x_qte_header_rec  ,
                            P_hd_Price_Attributes_Tbl => x_hd_Price_Attributes_Tbl  ,
                            P_hd_Payment_Tbl	         => x_hd_Payment_Tbl ,
                            P_hd_Shipment_tbl         => x_hd_shipment_tbl,
                            P_hd_Freight_Charge_Tbl   => x_hd_Freight_Charge_Tbl,
                            P_hd_Tax_Detail_Tbl	    => x_hd_Tax_Detail_Tbl ,
                            P_hd_Attr_Ext_Tbl	    => x_hd_Attr_Ext_Tbl,
                            P_hd_Sales_Credit_Tbl     => x_hd_Sales_Credit_Tbl ,
                            P_hd_Quote_Party_Tbl      => x_hd_Quote_Party_Tbl   ,
                            P_Qte_Line_Tbl		    => x_Qte_Line_Tbl,
                            P_Qte_Line_Dtl_Tbl	    => x_Qte_Line_Dtl_tbl,
                            P_Line_Attr_Ext_Tbl	    => x_Line_Attr_Ext_Tbl,
                            P_line_rltship_tbl	    => x_Line_Rltship_Tbl,
                            P_Price_Adjustment_Tbl    => x_Price_Adjustment_Tbl ,
                            P_Price_Adj_Attr_Tbl	    => x_Price_Adj_Attr_Tbl    ,
                            P_Price_Adj_Rltship_Tbl   => x_Price_Adj_rltship_Tbl,
                            P_Ln_Price_Attributes_Tbl => x_ln_Price_Attributes_Tbl  ,
                            P_Ln_Payment_Tbl	         => x_ln_Payment_Tbl ,
                            P_Ln_Shipment_Tbl         => x_ln_shipment_tbl ,
                            P_Ln_Freight_Charge_Tbl   => x_ln_Freight_Charge_Tbl,
                            P_Ln_Tax_Detail_Tbl       => x_ln_Tax_Detail_Tbl,
                            P_ln_Sales_Credit_Tbl     => x_ln_Sales_Credit_Tbl    ,
                            P_ln_Quote_Party_Tbl      => x_ln_Quote_Party_Tbl,
					   /*
                            P_Qte_Access_Tbl          => x_Qte_Access_Tbl,
                            P_Template_Tbl            => x_Template_Tbl,
					   P_Related_Obj_Tbl         => x_Related_Obj_Tbl,
					   */
                            X_Return_Status           => X_Return_Status,
                            X_Msg_Count               => X_Msg_Count,
                            X_Msg_Data                => X_Msg_Data
                            );

Line: 4761

		         FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_POST', FALSE);

Line: 4776

	     aso_debug_pub.add('aso_quote_vuhk: before if update quote post (1)'||x_return_status,1, 'N');

Line: 4782

              aso_debug_pub.add('aso_quote_vuhk: inside if update quote post (1)'||x_return_status,1, 'N');

Line: 4785

          ASO_QUOTE_VUHK.Update_quote_POST(
                           P_Validation_Level        => l_validation_level ,
                           P_Control_Rec             => l_control_rec ,
                           P_Qte_Header_Rec	        => x_qte_header_rec  ,
                           P_hd_Price_Attributes_Tbl => x_hd_Price_Attributes_Tbl  ,
                           P_hd_Payment_Tbl	        => x_hd_Payment_Tbl ,
                           P_hd_Shipment_tbl         => x_hd_shipment_tbl,
                           P_hd_Freight_Charge_Tbl   => x_hd_Freight_Charge_Tbl,
                           P_hd_Tax_Detail_Tbl       => x_hd_Tax_Detail_Tbl ,
                           P_hd_Attr_Ext_Tbl	        => x_hd_Attr_Ext_Tbl,
                           P_hd_Sales_Credit_Tbl     => x_hd_Sales_Credit_Tbl ,
                           P_hd_Quote_Party_Tbl      => x_hd_Quote_Party_Tbl   ,
                           P_Qte_Line_Tbl            => x_Qte_Line_Tbl,
                           P_Qte_Line_Dtl_Tbl        => x_Qte_Line_Dtl_tbl,
                           P_Line_Attr_Ext_Tbl       => x_Line_Attr_Ext_Tbl,
                           P_line_rltship_tbl        => x_Line_Rltship_Tbl,
                           P_Price_Adjustment_Tbl	   => x_Price_Adjustment_Tbl ,
                           P_Price_Adj_Attr_Tbl	   => x_Price_Adj_Attr_Tbl    ,
                           P_Price_Adj_Rltship_Tbl   => x_Price_Adj_rltship_Tbl,
                           P_Ln_Price_Attributes_Tbl => x_ln_Price_Attributes_Tbl  ,
                           P_Ln_Payment_Tbl		   => x_ln_Payment_Tbl ,
                           P_Ln_Shipment_Tbl		   => x_ln_shipment_tbl ,
                           P_Ln_Freight_Charge_Tbl   => x_ln_Freight_Charge_Tbl,
                           P_Ln_Tax_Detail_Tbl       => x_ln_Tax_Detail_Tbl,
                           P_ln_Sales_Credit_Tbl     => x_ln_Sales_Credit_Tbl    ,
                           P_ln_Quote_Party_Tbl      => x_ln_Quote_Party_Tbl,
					  /*
                           P_Qte_Access_Tbl          => x_Qte_Access_Tbl,
                           P_Template_Tbl            => x_Template_Tbl,
					  P_Related_Obj_Tbl         => x_Related_Obj_Tbl,
					  */
                           X_Return_Status           => X_Return_Status,
                           X_Msg_Count               => X_Msg_Count,
                           X_Msg_Data                => X_Msg_Data
                           );

Line: 4822

              aso_debug_pub.add('update_quote_pub: after vertical hooks'||x_return_status,1, 'N');

Line: 4829

		        FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_POST', FALSE);