APPS.ASO_QUOTE_HEADERS_PVT SQL Statements

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

Line: 332

	SELECT ASO_QUOTE_NUMBER_S.nextval
	FROM dual;

Line: 336

	SELECT quote_version
	FROM ASO_QUOTE_HEADERS_ALL
	WHERE quote_number = X_qte_number;

Line: 341

	SELECT quote_status_id
	FROM ASO_QUOTE_STATUSES_VL
	WHERE status_code = c_status_code;

Line: 346

        SELECT price_list_id
        FROM OE_ORDER_TYPES_V
        WHERE order_type_id = c_order_type_id;

Line: 351

        SELECT currency_code
        FROM qp_price_lists_v
        WHERE price_list_id = c_price_list_id;

Line: 357

   	SELECT resource_id FROM JTF_RS_SRP_VL
   	WHERE person_id =  p_qte_header_rec.employee_person_id;

Line: 629

PROCEDURE Insert_Rows (
    P_qte_Header_Rec        IN       ASO_QUOTE_PUB.qte_header_rec_Type,
    p_Price_Attributes_Tbl  IN       ASO_QUOTE_PUB.Price_Attributes_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_Payment_Tbl		   IN       ASO_QUOTE_PUB.Payment_Tbl_Type,
    P_Shipment_Tbl		   IN       ASO_QUOTE_PUB.Shipment_Tbl_Type,
    P_Freight_Charge_Tbl	   IN       ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
    P_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_Sales_Credit_Tbl      IN       ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
    P_Quote_Party_Tbl       IN       ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
    P_Qte_Access_Tbl        IN       ASO_QUOTE_PUB.Qte_Access_Tbl_Type,
    X_qte_Header_Rec        OUT NOCOPY /* file.sql.39 change */      ASO_QUOTE_PUB.qte_header_rec_Type,
    X_Price_Attributes_Tbl  OUT NOCOPY /* file.sql.39 change */      ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
    X_Price_Adjustment_Tbl  OUT NOCOPY /* file.sql.39 change */      ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
    x_Price_Adj_Attr_Tbl	   OUT NOCOPY /* file.sql.39 change */      ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
    X_Payment_Tbl		   OUT NOCOPY /* file.sql.39 change */      ASO_QUOTE_PUB.Payment_Tbl_Type,
    X_Shipment_Rec		   OUT NOCOPY /* file.sql.39 change */      ASO_QUOTE_PUB.Shipment_Rec_Type,
    X_Freight_Charge_Tbl	   OUT NOCOPY /* file.sql.39 change */      ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
    X_Tax_Detail_Tbl        OUT NOCOPY /* file.sql.39 change */      ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
    X_hd_Attr_Ext_Tbl       OUT NOCOPY /* file.sql.39 change */      ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
    X_Sales_Credit_Tbl      OUT NOCOPY /* file.sql.39 change */      ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
    X_Quote_Party_Tbl       OUT NOCOPY /* file.sql.39 change */      ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
    X_Qte_Access_Tbl        OUT NOCOPY /* file.sql.39 change */      ASO_QUOTE_PUB.Qte_Access_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_price_adj_rec		ASO_QUOTE_PUB.Price_Adj_Rec_Type;

Line: 722

    aso_debug_pub.add('Begin Insert Rows', 1, 'Y');

Line: 725

    ASO_QUOTE_HEADERS_PKG.Insert_Row(
	  px_QUOTE_HEADER_ID  => lx_qte_header_id,
	  p_CREATION_DATE  => l_SYSDATE,
	  p_CREATED_BY	=> G_USER_ID,
	  p_LAST_UPDATE_DATE  => l_sysdate,
	  p_LAST_UPDATED_BY  => G_USER_ID,
	  p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	  p_REQUEST_ID	=> p_qte_header_rec.REQUEST_ID,
	  p_PROGRAM_APPLICATION_ID  => p_qte_header_rec.PROGRAM_APPLICATION_ID,
	  p_PROGRAM_ID	=> p_qte_header_rec.PROGRAM_ID,
	  p_PROGRAM_UPDATE_DATE  => p_qte_header_rec.PROGRAM_UPDATE_DATE,
	  p_ORG_ID  => l_org_id,
	  p_QUOTE_NAME	=> p_qte_header_rec.QUOTE_NAME,
	  p_QUOTE_NUMBER  => p_qte_header_rec.QUOTE_NUMBER,
	  p_QUOTE_VERSION  => p_qte_header_rec.QUOTE_VERSION,
	  p_QUOTE_STATUS_ID  => p_qte_header_rec.QUOTE_STATUS_ID,
	  p_QUOTE_SOURCE_CODE  => p_qte_header_rec.QUOTE_SOURCE_CODE,
	  p_QUOTE_EXPIRATION_DATE  => trunc(p_qte_header_rec.QUOTE_EXPIRATION_DATE),
	  p_PRICE_FROZEN_DATE  => p_qte_header_rec.PRICE_FROZEN_DATE,
	  p_QUOTE_PASSWORD  => p_qte_header_rec.QUOTE_PASSWORD,
	  p_ORIGINAL_SYSTEM_REFERENCE  => p_qte_header_rec.ORIGINAL_SYSTEM_REFERENCE,
	  p_PARTY_ID  => p_qte_header_rec.PARTY_ID,
	  p_CUST_ACCOUNT_ID  => p_qte_header_rec.CUST_ACCOUNT_ID,
	  p_ORG_CONTACT_ID  => p_qte_header_rec.ORG_CONTACT_ID,
	  p_PHONE_ID  => p_QTE_header_rec.PHONE_ID,
	  p_INVOICE_TO_PARTY_SITE_ID  => p_qte_header_rec.INVOICE_TO_PARTY_SITE_ID,
	  p_INVOICE_TO_PARTY_ID  => p_qte_header_rec.INVOICE_TO_PARTY_ID,
          p_Invoice_to_CUST_ACCOUNT_ID  => p_qte_header_rec.Invoice_to_CUST_ACCOUNT_ID,
	  p_ORIG_MKTG_SOURCE_CODE_ID  => p_qte_header_rec.ORIG_MKTG_SOURCE_CODE_ID,
	  p_MARKETING_SOURCE_CODE_ID  => p_qte_header_rec.MARKETING_SOURCE_CODE_ID,
	  p_ORDER_TYPE_ID  => p_qte_header_rec.ORDER_TYPE_ID,
	  p_QUOTE_CATEGORY_CODE  => p_qte_header_rec.QUOTE_CATEGORY_CODE,
	  p_ORDERED_DATE  => p_qte_header_rec.ORDERED_DATE,
	  p_ACCOUNTING_RULE_ID	=> p_qte_header_rec.ACCOUNTING_RULE_ID,
	  p_INVOICING_RULE_ID  => p_qte_header_rec.INVOICING_RULE_ID,
	  p_EMPLOYEE_PERSON_ID	=> p_qte_header_rec.EMPLOYEE_PERSON_ID,
	  p_PRICE_LIST_ID  => p_qte_header_rec.PRICE_LIST_ID,
	  p_CURRENCY_CODE  => p_qte_header_rec.CURRENCY_CODE,
	  p_TOTAL_LIST_PRICE  => p_qte_header_rec.TOTAL_LIST_PRICE,
	  p_TOTAL_ADJUSTED_AMOUNT  => p_qte_header_rec.TOTAL_ADJUSTED_AMOUNT,
	  p_TOTAL_ADJUSTED_PERCENT  => p_qte_header_rec.TOTAL_ADJUSTED_PERCENT,
	  p_TOTAL_TAX  => p_qte_header_rec.TOTAL_TAX,
	  p_TOTAL_SHIPPING_CHARGE  => p_qte_header_rec.TOTAL_SHIPPING_CHARGE,
	  p_SURCHARGE  => p_qte_header_rec.SURCHARGE,
	  p_TOTAL_QUOTE_PRICE  => p_qte_header_rec.TOTAL_QUOTE_PRICE,
	  p_PAYMENT_AMOUNT  => p_qte_header_rec.PAYMENT_AMOUNT,
	  p_EXCHANGE_RATE  => p_qte_header_rec.EXCHANGE_RATE,
	  p_EXCHANGE_TYPE_CODE	=> p_qte_header_rec.EXCHANGE_TYPE_CODE,
	  p_EXCHANGE_RATE_DATE	=> p_qte_header_rec.EXCHANGE_RATE_DATE,
	  p_CONTRACT_ID  => p_qte_header_rec.CONTRACT_ID,
	  p_SALES_CHANNEL_CODE	=> p_qte_header_rec.SALES_CHANNEL_CODE,
	  p_ORDER_ID  => p_QTE_header_rec.ORDER_ID,
	  p_RESOURCE_ID =>  p_qte_header_rec.RESOURCE_ID,
	  p_ATTRIBUTE_CATEGORY	=> p_qte_header_rec.ATTRIBUTE_CATEGORY,
	  p_ATTRIBUTE1	=> p_qte_header_rec.ATTRIBUTE1,
	  p_ATTRIBUTE2	=> p_qte_header_rec.ATTRIBUTE2,
	  p_ATTRIBUTE3	=> p_qte_header_rec.ATTRIBUTE3,
	  p_ATTRIBUTE4	=> p_qte_header_rec.ATTRIBUTE4,
	  p_ATTRIBUTE5	=> p_qte_header_rec.ATTRIBUTE5,
	  p_ATTRIBUTE6	=> p_qte_header_rec.ATTRIBUTE6,
	  p_ATTRIBUTE7	=> p_qte_header_rec.ATTRIBUTE7,
	  p_ATTRIBUTE8	=> p_qte_header_rec.ATTRIBUTE8,
	  p_ATTRIBUTE9	=> p_qte_header_rec.ATTRIBUTE9,
	  p_ATTRIBUTE10  => p_qte_header_rec.ATTRIBUTE10,
	  p_ATTRIBUTE11  => p_qte_header_rec.ATTRIBUTE11,
	  p_ATTRIBUTE12  => p_qte_header_rec.ATTRIBUTE12,
	  p_ATTRIBUTE13  => p_qte_header_rec.ATTRIBUTE13,
	  p_ATTRIBUTE14  => p_qte_header_rec.ATTRIBUTE14,
	  p_ATTRIBUTE15  => p_qte_header_rec.ATTRIBUTE15,
       p_ATTRIBUTE16  => p_qte_header_rec.ATTRIBUTE16,
       p_ATTRIBUTE17  => p_qte_header_rec.ATTRIBUTE17,
       p_ATTRIBUTE18  => p_qte_header_rec.ATTRIBUTE18,
       p_ATTRIBUTE19  => p_qte_header_rec.ATTRIBUTE19,
       p_ATTRIBUTE20  => p_qte_header_rec.ATTRIBUTE20,
-- hyang new okc
	  p_CONTRACT_TEMPLATE_ID  => FND_API.G_MISS_NUM,
	  p_CONTRACT_TEMPLATE_MAJOR_VER  => FND_API.G_MISS_NUM,
	  p_CONTRACT_REQUESTER_ID   => FND_API.G_MISS_NUM,
	  p_CONTRACT_APPROVAL_LEVEL => FND_API.G_MISS_CHAR,
-- end of hyang new okc
	  p_PUBLISH_FLAG            => p_qte_header_rec.PUBLISH_FLAG,
	  p_RESOURCE_GRP_ID         => p_qte_header_rec.RESOURCE_GRP_ID,
          p_SOLD_TO_PARTY_SITE_ID   => p_qte_header_rec.SOLD_TO_PARTY_SITE_ID,
          p_DISPLAY_ARITHMETIC_OPERATOR => p_qte_header_rec.DISPLAY_ARITHMETIC_OPERATOR,
          p_MAX_VERSION_FLAG        => p_qte_header_rec.max_version_flag,
          p_QUOTE_TYPE              => p_qte_header_rec.QUOTE_TYPE,
          p_QUOTE_DESCRIPTION       => p_qte_header_rec.QUOTE_DESCRIPTION,
          p_MINISITE_ID             => p_qte_header_rec.MINISITE_ID,
	  p_CUST_PARTY_ID          => p_qte_header_rec.CUST_PARTY_ID,
	  p_INVOICE_TO_CUST_PARTY_ID => p_qte_header_rec.INVOICE_TO_CUST_PARTY_ID,
	  p_Pricing_Status_indicator  	     =>  p_qte_header_rec.Pricing_Status_indicator,
	  p_Tax_status_Indicator	     =>  p_qte_header_rec.Tax_status_Indicator,
	  p_Price_updated_date	     	     =>  p_qte_header_rec.Price_updated_date,
	  p_Tax_updated_date		     =>  p_qte_header_rec.Tax_updated_date,
	  p_Recalculate_flag		     =>  p_qte_header_rec.Recalculate_flag,
	  p_price_request_id		     => p_qte_header_rec.price_request_id,
	  p_credit_update_date		     => p_qte_header_rec.credit_update_date,
-- hyang new okc
    P_Customer_Name_And_Title       =>  p_qte_header_rec.Customer_Name_And_Title,
    P_Customer_Signature_Date       =>  p_qte_header_rec.Customer_Signature_Date,
    P_Supplier_Name_And_Title       =>  p_qte_header_rec.Supplier_Name_And_Title,
    P_Supplier_Signature_Date       =>  p_qte_header_rec.Supplier_Signature_Date,
-- end of hyang new okc
    p_END_CUSTOMER_PARTY_ID         =>  p_qte_header_rec.END_CUSTOMER_PARTY_ID,
    p_END_CUSTOMER_CUST_PARTY_ID    =>  p_qte_header_rec.END_CUSTOMER_CUST_PARTY_ID,
    p_END_CUSTOMER_PARTY_SITE_ID    =>  p_qte_header_rec.END_CUSTOMER_PARTY_SITE_ID,
    p_END_CUSTOMER_CUST_ACCOUNT_ID  =>  p_qte_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID,
    P_OBJECT_VERSION_NUMBER         =>  p_qte_header_rec.OBJECT_VERSION_NUMBER,
    p_assistance_requested          =>  p_qte_header_rec.assistance_requested,
    p_assistance_reason_code        =>  p_qte_header_rec.assistance_reason_code,
    p_automatic_price_flag          =>  p_qte_header_rec.automatic_price_flag,
    p_automatic_tax_flag            =>  p_qte_header_rec.automatic_tax_flag,
    p_header_paynow_charges         =>  p_qte_header_rec.header_paynow_charges
);

Line: 841

    x_qte_header_rec.LAST_UPDATE_DATE := l_sysdate;

Line: 845

	aso_debug_pub.add('After quote headers.insert rows - Insert Rows', 1, 'Y');

Line: 855

	ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(
	    px_PRICE_ADJUSTMENT_ID  => x_price_adjustment_tbl(i).PRICE_ADJUSTMENT_ID,
	    p_CREATION_DATE  => SYSDATE,
	    p_CREATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_DATE	=> l_sysdate,
	    p_LAST_UPDATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	    p_PROGRAM_APPLICATION_ID  => l_price_adj_rec.PROGRAM_APPLICATION_ID,
	    p_PROGRAM_ID  => l_price_adj_rec.PROGRAM_ID,
	    p_PROGRAM_UPDATE_DATE  => l_price_adj_rec.PROGRAM_UPDATE_DATE,
	    p_REQUEST_ID  => l_price_adj_rec.REQUEST_ID,
	    p_QUOTE_HEADER_ID  => lx_QTE_HEADER_ID,
	    p_QUOTE_LINE_ID  => NULL,
	    p_MODIFIER_HEADER_ID  => l_price_adj_rec.MODIFIER_HEADER_ID,
	    p_MODIFIER_LINE_ID	=> l_price_adj_rec.MODIFIER_LINE_ID,
	    p_MODIFIER_LINE_TYPE_CODE  => l_price_adj_rec.MODIFIER_LINE_TYPE_CODE,
	    p_MODIFIER_MECHANISM_TYPE_CODE  => l_price_adj_rec.MODIFIER_MECHANISM_TYPE_CODE,
	    p_MODIFIED_FROM  => l_price_adj_rec.MODIFIED_FROM,
	    p_MODIFIED_TO  => l_price_adj_rec.MODIFIED_TO,
	    p_OPERAND  => l_price_adj_rec.OPERAND,
	    p_ARITHMETIC_OPERATOR  => l_price_adj_rec.ARITHMETIC_OPERATOR,
	    p_AUTOMATIC_FLAG  => l_price_adj_rec.AUTOMATIC_FLAG,
	    p_UPDATE_ALLOWABLE_FLAG  => l_price_adj_rec.UPDATE_ALLOWABLE_FLAG,
	    p_UPDATED_FLAG  => l_price_adj_rec.UPDATED_FLAG,
	    p_APPLIED_FLAG  => l_price_adj_rec.APPLIED_FLAG,
	    p_ON_INVOICE_FLAG  => l_price_adj_rec.ON_INVOICE_FLAG,
	    p_PRICING_PHASE_ID	=> l_price_adj_rec.PRICING_PHASE_ID,
	    p_ATTRIBUTE_CATEGORY  => l_price_adj_rec.ATTRIBUTE_CATEGORY,
	    p_ATTRIBUTE1  => l_price_adj_rec.ATTRIBUTE1,
	    p_ATTRIBUTE2  => l_price_adj_rec.ATTRIBUTE2,
	    p_ATTRIBUTE3  => l_price_adj_rec.ATTRIBUTE3,
	    p_ATTRIBUTE4  => l_price_adj_rec.ATTRIBUTE4,
	    p_ATTRIBUTE5  => l_price_adj_rec.ATTRIBUTE5,
	    p_ATTRIBUTE6  => l_price_adj_rec.ATTRIBUTE6,
	    p_ATTRIBUTE7  => l_price_adj_rec.ATTRIBUTE7,
	    p_ATTRIBUTE8  => l_price_adj_rec.ATTRIBUTE8,
	    p_ATTRIBUTE9  => l_price_adj_rec.ATTRIBUTE9,
	    p_ATTRIBUTE10  => l_price_adj_rec.ATTRIBUTE10,
	    p_ATTRIBUTE11  => l_price_adj_rec.ATTRIBUTE11,
	    p_ATTRIBUTE12  => l_price_adj_rec.ATTRIBUTE12,
	    p_ATTRIBUTE13  => l_price_adj_rec.ATTRIBUTE13,
	    p_ATTRIBUTE14  => l_price_adj_rec.ATTRIBUTE14,
	    p_ATTRIBUTE15  => l_price_adj_rec.ATTRIBUTE15,
         p_ATTRIBUTE16  => l_price_adj_rec.ATTRIBUTE16,
	    p_ATTRIBUTE17  => l_price_adj_rec.ATTRIBUTE17,
	    p_ATTRIBUTE18  => l_price_adj_rec.ATTRIBUTE18,
	    p_ATTRIBUTE19  => l_price_adj_rec.ATTRIBUTE19,
	    p_ATTRIBUTE20  => l_price_adj_rec.ATTRIBUTE20,
  p_ORIG_SYS_DISCOUNT_REF                    => l_price_adj_rec.ORIG_SYS_DISCOUNT_REF ,
          p_CHANGE_SEQUENCE                           => l_price_adj_rec.CHANGE_SEQUENCE ,
          -- p_LIST_HEADER_ID                            => l_price_adj_rec. ,
          -- p_LIST_LINE_ID                              => l_price_adj_rec. ,
          -- p_LIST_LINE_TYPE_CODE                       => l_price_adj_rec.,
          p_UPDATE_ALLOWED                            => l_price_adj_rec.UPDATE_ALLOWED,
          p_CHANGE_REASON_CODE                        => l_price_adj_rec.CHANGE_REASON_CODE,
          p_CHANGE_REASON_TEXT                        => l_price_adj_rec.CHANGE_REASON_TEXT,
          p_COST_ID                                   => l_price_adj_rec.COST_ID ,
          p_TAX_CODE                                  => l_price_adj_rec.TAX_CODE,
          p_TAX_EXEMPT_FLAG                           => l_price_adj_rec.TAX_EXEMPT_FLAG,
          p_TAX_EXEMPT_NUMBER                         => l_price_adj_rec.TAX_EXEMPT_NUMBER,
          p_TAX_EXEMPT_REASON_CODE                    => l_price_adj_rec.TAX_EXEMPT_REASON_CODE,
          p_PARENT_ADJUSTMENT_ID                      => l_price_adj_rec.PARENT_ADJUSTMENT_ID,
          p_INVOICED_FLAG                             => l_price_adj_rec.INVOICED_FLAG,
          p_ESTIMATED_FLAG                            => l_price_adj_rec.ESTIMATED_FLAG,
          p_INC_IN_SALES_PERFORMANCE                  => l_price_adj_rec.INC_IN_SALES_PERFORMANCE,
          p_SPLIT_ACTION_CODE                         => l_price_adj_rec.SPLIT_ACTION_CODE,
          p_ADJUSTED_AMOUNT                           => l_price_adj_rec.ADJUSTED_AMOUNT ,
          p_CHARGE_TYPE_CODE                          => l_price_adj_rec.CHARGE_TYPE_CODE,
          p_CHARGE_SUBTYPE_CODE                       => l_price_adj_rec.CHARGE_SUBTYPE_CODE,
          p_RANGE_BREAK_QUANTITY                      => l_price_adj_rec.RANGE_BREAK_QUANTITY,
          p_ACCRUAL_CONVERSION_RATE                   => l_price_adj_rec.ACCRUAL_CONVERSION_RATE ,
          p_PRICING_GROUP_SEQUENCE                    => l_price_adj_rec.PRICING_GROUP_SEQUENCE,
          p_ACCRUAL_FLAG                              => l_price_adj_rec.ACCRUAL_FLAG,
          p_LIST_LINE_NO                              => l_price_adj_rec.LIST_LINE_NO,
          p_SOURCE_SYSTEM_CODE                        => l_price_adj_rec.SOURCE_SYSTEM_CODE ,
          p_BENEFIT_QTY                               => l_price_adj_rec.BENEFIT_QTY,
          p_BENEFIT_UOM_CODE                          => l_price_adj_rec.BENEFIT_UOM_CODE,
          p_PRINT_ON_INVOICE_FLAG                     => l_price_adj_rec.PRINT_ON_INVOICE_FLAG,
          p_EXPIRATION_DATE                           => l_price_adj_rec.EXPIRATION_DATE,
          p_REBATE_TRANSACTION_TYPE_CODE              => l_price_adj_rec.REBATE_TRANSACTION_TYPE_CODE,
          p_REBATE_TRANSACTION_REFERENCE              => l_price_adj_rec.REBATE_TRANSACTION_REFERENCE,
          p_REBATE_PAYMENT_SYSTEM_CODE                => l_price_adj_rec.REBATE_PAYMENT_SYSTEM_CODE,
          p_REDEEMED_DATE                             => l_price_adj_rec.REDEEMED_DATE,
          p_REDEEMED_FLAG                             => l_price_adj_rec.REDEEMED_FLAG,
          p_MODIFIER_LEVEL_CODE                       => l_price_adj_rec.MODIFIER_LEVEL_CODE,
          p_PRICE_BREAK_TYPE_CODE                     => l_price_adj_rec.PRICE_BREAK_TYPE_CODE ,
          p_SUBSTITUTION_ATTRIBUTE                    => l_price_adj_rec.SUBSTITUTION_ATTRIBUTE,
          p_PRORATION_TYPE_CODE                       => l_price_adj_rec.PRORATION_TYPE_CODE ,
          p_INCLUDE_ON_RETURNS_FLAG                   => l_price_adj_rec.INCLUDE_ON_RETURNS_FLAG,
          p_CREDIT_OR_CHARGE_FLAG                     => l_price_adj_rec.CREDIT_OR_CHARGE_FLAG,
		p_quote_shipment_id                          => l_price_adj_rec.quote_shipment_id,
		p_OPERAND_PER_PQTY                          => l_price_adj_rec.OPERAND_PER_PQTY,
	     p_ADJUSTED_AMOUNT_PER_PQTY                  => l_price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY,
		P_OBJECT_VERSION_NUMBER                     => l_price_adj_rec.OBJECT_VERSION_NUMBER
        );

Line: 950

        x_price_adjustment_tbl(i).LAST_UPDATE_DATE := l_sysdate;

Line: 963

	ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row(
		px_PRICE_ADJ_ATTRIB_ID	 => x_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID,
		p_CREATION_DATE  => SYSDATE,
		p_CREATED_BY  => G_USER_ID,
		p_LAST_UPDATE_DATE  => l_sysdate,
		p_LAST_UPDATED_BY  => G_USER_ID,
		p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
		p_PROGRAM_APPLICATION_ID  =>l_price_adj_attr_tbl(i).PROGRAM_APPLICATION_ID,
		p_PROGRAM_ID  => l_price_adj_attr_tbl(i).PROGRAM_ID,
		p_PROGRAM_UPDATE_DATE  => l_price_adj_attr_tbl(i).PROGRAM_UPDATE_DATE,
		p_REQUEST_ID  => l_price_adj_attr_tbl(i).REQUEST_ID,
		p_PRICE_ADJUSTMENT_ID => l_price_adj_attr_tbl(i).PRICE_ADJUSTMENT_ID,
		p_PRICING_CONTEXT  => l_price_adj_attr_tbl(i).PRICING_CONTEXT,
		p_PRICING_ATTRIBUTE => l_price_adj_attr_tbl(i).PRICING_ATTRIBUTE,
		p_PRICING_ATTR_VALUE_FROM => l_price_adj_attr_tbl(i).PRICING_ATTR_VALUE_FROM,
		p_PRICING_ATTR_VALUE_TO  => l_price_adj_attr_tbl(i).PRICING_ATTR_VALUE_TO,
		p_COMPARISON_OPERATOR	=> l_price_adj_attr_tbl(i).COMPARISON_OPERATOR,
		p_FLEX_TITLE   => l_price_adj_attr_tbl(i).FLEX_TITLE,
		P_OBJECT_VERSION_NUMBER => l_price_adj_attr_tbl(i).OBJECT_VERSION_NUMBER);

Line: 982

        x_price_adj_attr_tbl(i).LAST_UPDATE_DATE := l_sysdate;

Line: 986

    aso_debug_pub.add('After Price_adj.insert_rows - Insert Rows', 1, 'Y');

Line: 997

       aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows p_payment_tbl(i).payment_term_id'||p_payment_tbl(i).payment_term_id, 1, 'Y');

Line: 998

       aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows l_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');

Line: 1012

               aso_debug_pub.add('Insert_Rows: Before  call to create_payment_row ', 1, 'Y');

Line: 1022

               aso_debug_pub.add('Insert_Rows: After call to create_payment_row: x_return_status: '||x_return_status, 1, 'Y');

Line: 1038

     x_payment_tbl(i).LAST_UPDATE_DATE := l_sysdate;

Line: 1043

    aso_debug_pub.add('After Payments.insert_rows - Insert Rows', 1, 'Y');

Line: 1055

      aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows - p_shipment_tbl(1).ship_method_code'||p_shipment_tbl(1).ship_method_code, 1, 'Y');

Line: 1056

      aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows - p_shipment_tbl(1).freight_terms_code'||p_shipment_tbl(1).freight_terms_code, 1, 'Y');

Line: 1063

	ASO_SHIPMENTS_PKG.Insert_Row(
	    px_SHIPMENT_ID  => lx_shipment_id,
	    p_CREATION_DATE  => SYSDATE,
	    p_CREATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_DATE	=> l_sysdate,
	    p_LAST_UPDATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	    p_REQUEST_ID  => x_shipment_rec.REQUEST_ID,
	    p_PROGRAM_APPLICATION_ID  => x_shipment_rec.PROGRAM_APPLICATION_ID,
	    p_PROGRAM_ID  => x_shipment_rec.PROGRAM_ID,
	    p_PROGRAM_UPDATE_DATE  => x_shipment_rec.PROGRAM_UPDATE_DATE,
	    p_QUOTE_HEADER_ID  => lx_Qte_HEADER_ID,
	    p_QUOTE_LINE_ID  => NULL,
	    p_PROMISE_DATE  => x_shipment_rec.PROMISE_DATE,
	    p_REQUEST_DATE  => x_shipment_rec.REQUEST_DATE,
	    p_SCHEDULE_SHIP_DATE  => x_shipment_rec.SCHEDULE_SHIP_DATE,
	    p_SHIP_TO_PARTY_SITE_ID  => x_shipment_rec.SHIP_TO_PARTY_SITE_ID,
	    p_SHIP_TO_PARTY_ID	=> x_shipment_rec.SHIP_TO_PARTY_ID,
         p_SHIP_TO_CUST_ACCOUNT_ID  => x_Shipment_rec.SHIP_TO_CUST_ACCOUNT_ID,
	    p_SHIP_PARTIAL_FLAG  => x_shipment_rec.SHIP_PARTIAL_FLAG,
	    p_SHIP_SET_ID  => x_shipment_rec.SHIP_SET_ID,
	    p_SHIP_METHOD_CODE	=> x_shipment_rec.SHIP_METHOD_CODE,
	    p_FREIGHT_TERMS_CODE  => x_shipment_rec.FREIGHT_TERMS_CODE,
	    p_FREIGHT_CARRIER_CODE  => x_shipment_rec.FREIGHT_CARRIER_CODE,
	    p_FOB_CODE	=> x_shipment_rec.FOB_CODE,
	    p_SHIPPING_INSTRUCTIONS  => x_shipment_rec.SHIPPING_INSTRUCTIONS,
	    p_PACKING_INSTRUCTIONS  => x_shipment_rec.PACKING_INSTRUCTIONS,
	    p_QUANTITY	=> x_shipment_rec.QUANTITY,
	    p_RESERVED_QUANTITY  => x_shipment_rec.RESERVED_QUANTITY,
	    p_RESERVATION_ID  => x_shipment_rec.RESERVATION_ID,
	    p_ORDER_LINE_ID  => x_shipment_rec.ORDER_LINE_ID,
	    p_ATTRIBUTE_CATEGORY  => x_SHIPMENT_rec.ATTRIBUTE_CATEGORY,
	    p_ATTRIBUTE1  => x_shipment_rec.ATTRIBUTE1,
	    p_ATTRIBUTE2  => x_shipment_rec.ATTRIBUTE2,
	    p_ATTRIBUTE3  => x_shipment_rec.ATTRIBUTE3,
	    p_ATTRIBUTE4  => x_shipment_rec.ATTRIBUTE4,
	    p_ATTRIBUTE5  => x_shipment_rec.ATTRIBUTE5,
	    p_ATTRIBUTE6  => x_shipment_rec.ATTRIBUTE6,
	    p_ATTRIBUTE7  => x_shipment_rec.ATTRIBUTE7,
	    p_ATTRIBUTE8  => x_shipment_rec.ATTRIBUTE8,
	    p_ATTRIBUTE9  => x_shipment_rec.ATTRIBUTE9,
	    p_ATTRIBUTE10  => x_shipment_rec.ATTRIBUTE10,
	    p_ATTRIBUTE11  => x_shipment_rec.ATTRIBUTE11,
	    p_ATTRIBUTE12  => x_shipment_rec.ATTRIBUTE12,
	    p_ATTRIBUTE13  => x_shipment_rec.ATTRIBUTE13,
	    p_ATTRIBUTE14  => x_shipment_rec.ATTRIBUTE14,
	    p_ATTRIBUTE15  => x_shipment_rec.ATTRIBUTE15,
         p_ATTRIBUTE16  => x_shipment_rec.ATTRIBUTE16,
	    p_ATTRIBUTE17  => x_shipment_rec.ATTRIBUTE17,
	    p_ATTRIBUTE18  => x_shipment_rec.ATTRIBUTE18,
	    p_ATTRIBUTE19  => x_shipment_rec.ATTRIBUTE19,
	    p_ATTRIBUTE20  => x_shipment_rec.ATTRIBUTE20,
	    p_SHIPMENT_PRIORITY_CODE => x_shipment_rec.SHIPMENT_PRIORITY_CODE,
         p_SHIP_QUOTE_PRICE => x_shipment_rec.SHIP_QUOTE_PRICE,
	    p_SHIP_FROM_ORG_ID => x_shipment_rec.SHIP_FROM_ORG_ID,
	    p_SHIP_TO_CUST_PARTY_ID => x_shipment_rec.SHIP_TO_CUST_PARTY_ID,
         p_SHIP_METHOD_CODE_FROM     => x_shipment_rec.SHIP_METHOD_CODE_FROM,
         p_FREIGHT_TERMS_CODE_FROM  => x_shipment_rec.FREIGHT_TERMS_CODE_FROM,
	    P_OBJECT_VERSION_NUMBER => x_shipment_rec.OBJECT_VERSION_NUMBER,
         p_REQUEST_DATE_TYPE => x_shipment_rec.REQUEST_DATE_TYPE,
	    p_demand_class_code => x_shipment_rec.demand_class_code
);

Line: 1126

        x_shipment_rec.LAST_UPDATE_DATE := l_sysdate;

Line: 1130

    aso_debug_pub.add('After shipments.insert_rows - Insert Rows', 1, 'Y');

Line: 1140

	ASO_FREIGHT_CHARGES_PKG.Insert_Row(
	    px_FREIGHT_CHARGE_ID  => x_FREIGHT_CHARGE_tbl(i).freight_charge_id,
	    p_CREATION_DATE  => SYSDATE,
	    p_CREATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_DATE	=> l_sysdate,
	    p_LAST_UPDATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	    p_REQUEST_ID  => l_freight_charge_rec.REQUEST_ID,
	    p_PROGRAM_APPLICATION_ID  => l_freight_charge_rec.PROGRAM_APPLICATION_ID,
	    p_PROGRAM_ID  => l_freight_charge_rec.PROGRAM_ID,
	    p_PROGRAM_UPDATE_DATE  => l_freight_charge_rec.PROGRAM_UPDATE_DATE,
	    p_QUOTE_SHIPMENT_ID  => lx_SHIPMENT_ID,
	    p_FREIGHT_CHARGE_TYPE_ID  => l_freight_charge_rec.FREIGHT_CHARGE_TYPE_ID,
	    p_CHARGE_AMOUNT  => l_freight_charge_rec.CHARGE_AMOUNT,
	    p_ATTRIBUTE_CATEGORY  => l_freight_charge_rec.ATTRIBUTE_CATEGORY,
	    p_ATTRIBUTE1  => l_freight_charge_rec.ATTRIBUTE1,
	    p_ATTRIBUTE2  => l_freight_charge_rec.ATTRIBUTE2,
	    p_ATTRIBUTE3  => l_freight_charge_rec.ATTRIBUTE3,
	    p_ATTRIBUTE4  => l_freight_charge_rec.ATTRIBUTE4,
	    p_ATTRIBUTE5  => l_freight_charge_rec.ATTRIBUTE5,
	    p_ATTRIBUTE6  => l_freight_charge_rec.ATTRIBUTE6,
	    p_ATTRIBUTE7  => l_freight_charge_rec.ATTRIBUTE7,
	    p_ATTRIBUTE8  => l_freight_charge_rec.ATTRIBUTE8,
	    p_ATTRIBUTE9  => l_freight_charge_rec.ATTRIBUTE9,
	    p_ATTRIBUTE10  => l_freight_charge_rec.ATTRIBUTE10,
	    p_ATTRIBUTE11  => l_freight_charge_rec.ATTRIBUTE11,
	    p_ATTRIBUTE12  => l_freight_charge_rec.ATTRIBUTE12,
	    p_ATTRIBUTE13  => l_freight_charge_rec.ATTRIBUTE13,
	    p_ATTRIBUTE14  => l_freight_charge_rec.ATTRIBUTE14,
	    p_ATTRIBUTE15  => l_freight_charge_rec.ATTRIBUTE15);

Line: 1171

    x_FREIGHT_CHARGE_tbl(i).LAST_UPDATE_DATE := l_sysdate;

Line: 1176

    aso_debug_pub.add('After Freight_charges.insert_rows - Insert Rows', 1, 'Y');

Line: 1181

    aso_debug_pub.add('Insert Rows - tax.count: '||to_char(P_tax_detail_Tbl.count), 1, 'N');

Line: 1189

	ASO_TAX_DETAILS_PKG.Insert_Row(
	    px_TAX_DETAIL_ID  => x_tax_detail_tbl(i).TAX_DETAIL_ID,
	    p_CREATION_DATE  => SYSDATE,
	    p_CREATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_DATE	=> l_sysdate,
	    p_LAST_UPDATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	    p_REQUEST_ID  => l_tax_detail_rec.REQUEST_ID,
	    p_PROGRAM_APPLICATION_ID  => l_tax_detail_rec.PROGRAM_APPLICATION_ID,
	    p_PROGRAM_ID  => l_tax_detail_rec.PROGRAM_ID,
	    p_PROGRAM_UPDATE_DATE  => l_tax_detail_rec.PROGRAM_UPDATE_DATE,
	    p_QUOTE_HEADER_ID  => lx_Qte_HEADER_ID,
	    p_QUOTE_LINE_ID  => NULL,
	    p_QUOTE_SHIPMENT_ID  => lx_SHIPMENT_ID,
	    p_ORIG_TAX_CODE  => l_tax_detail_rec.ORIG_TAX_CODE,
	    p_TAX_CODE	=> l_tax_detail_rec.TAX_CODE,
	    p_TAX_RATE	=> l_tax_detail_rec.TAX_RATE,
	    p_TAX_DATE	=> l_tax_detail_rec.TAX_DATE,
	    p_TAX_AMOUNT  => l_tax_detail_rec.TAX_AMOUNT,
	    p_TAX_EXEMPT_FLAG  => l_tax_detail_rec.TAX_EXEMPT_FLAG,
	    p_TAX_EXEMPT_NUMBER  => l_tax_detail_rec.TAX_EXEMPT_NUMBER,
	    p_TAX_EXEMPT_REASON_CODE  => l_tax_detail_rec.TAX_EXEMPT_REASON_CODE,
	    p_ATTRIBUTE_CATEGORY  => l_tax_detail_rec.ATTRIBUTE_CATEGORY,
	    p_ATTRIBUTE1  => l_tax_detail_rec.ATTRIBUTE1,
	    p_ATTRIBUTE2  => l_tax_detail_rec.ATTRIBUTE2,
	    p_ATTRIBUTE3  => l_tax_detail_rec.ATTRIBUTE3,
	    p_ATTRIBUTE4  => l_tax_detail_rec.ATTRIBUTE4,
	    p_ATTRIBUTE5  => l_tax_detail_rec.ATTRIBUTE5,
	    p_ATTRIBUTE6  => l_tax_detail_rec.ATTRIBUTE6,
	    p_ATTRIBUTE7  => l_tax_detail_rec.ATTRIBUTE7,
	    p_ATTRIBUTE8  => l_tax_detail_rec.ATTRIBUTE8,
	    p_ATTRIBUTE9  => l_tax_detail_rec.ATTRIBUTE9,
	    p_ATTRIBUTE10  => l_tax_detail_rec.ATTRIBUTE10,
	    p_ATTRIBUTE11  => l_tax_detail_rec.ATTRIBUTE11,
	    p_ATTRIBUTE12  => l_tax_detail_rec.ATTRIBUTE12,
	    p_ATTRIBUTE13  => l_tax_detail_rec.ATTRIBUTE13,
	    p_ATTRIBUTE14  => l_tax_detail_rec.ATTRIBUTE14,
	    p_ATTRIBUTE15  => l_tax_detail_rec.ATTRIBUTE15,
	    p_ATTRIBUTE16  => l_tax_detail_rec.ATTRIBUTE16,
	    p_ATTRIBUTE17  => l_tax_detail_rec.ATTRIBUTE17,
	    p_ATTRIBUTE18  => l_tax_detail_rec.ATTRIBUTE18,
	    p_ATTRIBUTE19  => l_tax_detail_rec.ATTRIBUTE19,
	    p_ATTRIBUTE20  => l_tax_detail_rec.ATTRIBUTE20,
	    p_TAX_INCLUSIVE_FLAG  => l_tax_detail_rec.TAX_INCLUSIVE_FLAG,
	    p_OBJECT_VERSION_NUMBER => l_tax_detail_rec.OBJECT_VERSION_NUMBER,
	    p_TAX_RATE_ID => l_tax_detail_rec.TAX_RATE_ID
	    );

Line: 1236

        x_tax_detail_tbl(i).LAST_UPDATE_DATE := l_sysdate;

Line: 1239

    aso_debug_pub.add('After tax_details.insert_rows - Insert Rows', 1, 'Y');

Line: 1249

       ASO_SALES_CREDITS_PKG.Insert_Row(
          p_CREATION_DATE  => SYSDATE,
          p_CREATED_BY  => G_USER_ID,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
          p_REQUEST_ID  => l_sales_CREDIT_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => l_sales_CREDIT_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => l_sales_CREDIT_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => l_sales_CREDIT_rec.PROGRAM_UPDATE_DATE,
          px_SALES_CREDIT_ID  => x_SALES_CREDIT_tbl(i).SALES_CREDIT_ID,
          p_QUOTE_HEADER_ID  => l_sales_CREDIT_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID  => l_sales_CREDIT_rec.QUOTE_LINE_ID,
          p_PERCENT  => l_sales_CREDIT_rec.PERCENT,
          p_RESOURCE_ID  => l_sales_CREDIT_rec.RESOURCE_ID,
          p_RESOURCE_GROUP_ID  => l_sales_CREDIT_rec.RESOURCE_GROUP_ID,
          p_EMPLOYEE_PERSON_ID  => l_sales_CREDIT_rec.EMPLOYEE_PERSON_ID,
          p_SALES_CREDIT_TYPE_ID  => l_sales_CREDIT_rec.SALES_CREDIT_TYPE_ID,
--          p_SECURITY_GROUP_ID  => l_sales_CREDIT_rec.SECURITY_GROUP_ID,
          p_ATTRIBUTE_CATEGORY_CODE  => l_sales_CREDIT_rec.ATTRIBUTE_CATEGORY_CODE,
          p_ATTRIBUTE1  => l_sales_CREDIT_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => l_sales_CREDIT_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => l_sales_CREDIT_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => l_sales_CREDIT_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => l_sales_CREDIT_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => l_sales_CREDIT_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => l_sales_CREDIT_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => l_sales_CREDIT_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => l_sales_CREDIT_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => l_sales_CREDIT_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => l_sales_CREDIT_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => l_sales_CREDIT_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => l_sales_CREDIT_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => l_sales_CREDIT_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => l_sales_CREDIT_rec.ATTRIBUTE15,
          p_ATTRIBUTE16  => l_sales_CREDIT_rec.ATTRIBUTE16,
		p_ATTRIBUTE17  => l_sales_CREDIT_rec.ATTRIBUTE17,
		p_ATTRIBUTE18  => l_sales_CREDIT_rec.ATTRIBUTE18,
		p_ATTRIBUTE19  => l_sales_CREDIT_rec.ATTRIBUTE19,
		p_ATTRIBUTE20  => l_sales_CREDIT_rec.ATTRIBUTE20,
		p_SYSTEM_ASSIGNED_FLAG  => 'N',
          p_CREDIT_RULE_ID  => l_sales_CREDIT_rec.CREDIT_RULE_ID,
          p_OBJECT_VERSION_NUMBER  => l_sales_CREDIT_rec.OBJECT_VERSION_NUMBER);

Line: 1298

 aso_debug_pub.add('Insert Rows - Quote_party.count: ' || p_quote_party_Tbl.count, 1, 'N');

Line: 1299

 aso_debug_pub.add('Insert Rows - Quote_party header: '|| x_qte_header_rec.quote_header_id, 1, 'N');

Line: 1310

           ASO_QUOTE_PARTIES_PKG.Insert_Row(
          px_QUOTE_PARTY_ID  => x_quote_party_tbl(i).QUOTE_PARTY_ID,
          p_CREATION_DATE  => SYSDATE,
          p_CREATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_REQUEST_ID  => l_QUOTE_PARTY_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  =>l_QUOTE_PARTY_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => l_QUOTE_PARTY_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => l_QUOTE_PARTY_rec.PROGRAM_UPDATE_DATE,
          p_QUOTE_HEADER_ID  => l_QUOTE_PARTY_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID  => l_QUOTE_PARTY_rec.QUOTE_LINE_ID,
          p_QUOTE_SHIPMENT_ID  => l_QUOTE_PARTY_rec.QUOTE_SHIPMENT_ID,
          p_PARTY_TYPE  => l_QUOTE_PARTY_rec.PARTY_TYPE,
          p_PARTY_ID  => l_QUOTE_PARTY_rec.PARTY_ID,
          p_PARTY_OBJECT_TYPE  => l_QUOTE_PARTY_rec.PARTY_OBJECT_TYPE,
          p_PARTY_OBJECT_ID  => l_QUOTE_PARTY_rec.PARTY_OBJECT_ID,
          p_ATTRIBUTE_CATEGORY  => l_QUOTE_PARTY_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => l_QUOTE_PARTY_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => l_QUOTE_PARTY_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => l_QUOTE_PARTY_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => l_QUOTE_PARTY_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => l_QUOTE_PARTY_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => l_QUOTE_PARTY_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => l_QUOTE_PARTY_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => l_QUOTE_PARTY_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => l_QUOTE_PARTY_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => l_QUOTE_PARTY_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => l_QUOTE_PARTY_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => l_QUOTE_PARTY_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => l_QUOTE_PARTY_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => l_QUOTE_PARTY_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => l_QUOTE_PARTY_rec.ATTRIBUTE15,
  --          p_SECURITY_GROUP_ID  => p_QUOTE_PARTY_rec.SECURITY_GROUP_ID);

Line: 1357

 ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Insert_Row(
          px_LINE_ATTRIBUTE_ID  => x_hd_Attr_Ext_Tbl(i).LINE_ATTRIBUTE_ID,
          p_CREATION_DATE          => SYSDATE,
          p_CREATED_BY             => G_USER_ID,
          p_LAST_UPDATE_DATE       => SYSDATE,
          p_LAST_UPDATED_BY        => G_USER_ID,
          p_LAST_UPDATE_LOGIN      => G_LOGIN_ID,
          p_REQUEST_ID             => l_LINE_ATTRIBS_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID =>l_LINE_ATTRIBS_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID             => l_LINE_ATTRIBS_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE    => l_LINE_ATTRIBS_rec.PROGRAM_UPDATE_DATE,
           p_APPLICATION_ID         => l_LINE_ATTRIBS_rec.APPLICATION_ID,
          p_STATUS                 => l_LINE_ATTRIBS_rec.STATUS,
          p_QUOTE_HEADER_ID        => l_LINE_ATTRIBS_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID          => l_LINE_ATTRIBS_rec.QUOTE_LINE_ID,
          p_QUOTE_SHIPMENT_ID      => l_LINE_ATTRIBS_rec.QUOTE_SHIPMENT_ID,
          p_ATTRIBUTE_TYPE_CODE    => l_LINE_ATTRIBS_rec.ATTRIBUTE_TYPE_CODE,
          p_NAME                   => l_LINE_ATTRIBS_rec.NAME,
          p_VALUE                  => l_LINE_ATTRIBS_rec.VALUE,
           p_VALUE_TYPE             => l_LINE_ATTRIBS_rec.VALUE_TYPE,
          p_START_DATE_ACTIVE      => l_LINE_ATTRIBS_rec.START_DATE_ACTIVE,
          p_END_DATE_ACTIVE        => l_LINE_ATTRIBS_rec.END_DATE_ACTIVE,
		p_OBJECT_VERSION_NUMBER  => l_LINE_ATTRIBS_rec.OBJECT_VERSION_NUMBER);

Line: 1428

ASO_PRICE_ATTRIBUTES_PKG.Insert_Row(
          px_PRICE_ATTRIBUTE_ID   => x_price_attributes_tbl(i).price_attribute_id,
          p_CREATION_DATE         => SYSDATE,
          p_CREATED_BY            => G_USER_ID,
          p_LAST_UPDATE_DATE      => SYSDATE,
          p_LAST_UPDATED_BY       => G_USER_ID,
          p_LAST_UPDATE_LOGIN     => G_LOGIN_ID,
          p_REQUEST_ID            => l_price_attributes_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => l_price_attributes_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID           => l_price_attributes_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => l_price_attributes_rec.PROGRAM_UPDATE_DATE,
          p_QUOTE_HEADER_ID      => l_price_attributes_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID        => l_price_attributes_rec.quote_line_id,
          p_FLEX_TITLE           => l_price_attributes_rec.flex_title,
          p_PRICING_CONTEXT      => l_price_attributes_rec.pricing_context,
          p_PRICING_ATTRIBUTE1    => l_price_attributes_rec.PRICING_ATTRIBUTE1,
          p_PRICING_ATTRIBUTE2    => l_price_attributes_rec.PRICING_ATTRIBUTE2,
          p_PRICING_ATTRIBUTE3    => l_price_attributes_rec.PRICING_ATTRIBUTE3,
          p_PRICING_ATTRIBUTE4    => l_price_attributes_rec.PRICING_ATTRIBUTE4,
          p_PRICING_ATTRIBUTE5    => l_price_attributes_rec.PRICING_ATTRIBUTE5,
          p_PRICING_ATTRIBUTE6    => l_price_attributes_rec.PRICING_ATTRIBUTE6,
          p_PRICING_ATTRIBUTE7    => l_price_attributes_rec.PRICING_ATTRIBUTE7,
          p_PRICING_ATTRIBUTE8    => l_price_attributes_rec.PRICING_ATTRIBUTE8,
          p_PRICING_ATTRIBUTE9    => l_price_attributes_rec.PRICING_ATTRIBUTE9,
        p_PRICING_ATTRIBUTE10    => l_price_attributes_rec.PRICING_ATTRIBUTE10,
        p_PRICING_ATTRIBUTE11    => l_price_attributes_rec.PRICING_ATTRIBUTE11,
        p_PRICING_ATTRIBUTE12    => l_price_attributes_rec.PRICING_ATTRIBUTE12,
        p_PRICING_ATTRIBUTE13    => l_price_attributes_rec.PRICING_ATTRIBUTE13,
        p_PRICING_ATTRIBUTE14    => l_price_attributes_rec.PRICING_ATTRIBUTE14,
        p_PRICING_ATTRIBUTE15    => l_price_attributes_rec.PRICING_ATTRIBUTE15,
        p_PRICING_ATTRIBUTE16    => l_price_attributes_rec.PRICING_ATTRIBUTE16,
        p_PRICING_ATTRIBUTE17    => l_price_attributes_rec.PRICING_ATTRIBUTE17,
        p_PRICING_ATTRIBUTE18    => l_price_attributes_rec.PRICING_ATTRIBUTE18,
        p_PRICING_ATTRIBUTE19    => l_price_attributes_rec.PRICING_ATTRIBUTE19,
        p_PRICING_ATTRIBUTE20    => l_price_attributes_rec.PRICING_ATTRIBUTE20,
        p_PRICING_ATTRIBUTE21    => l_price_attributes_rec.PRICING_ATTRIBUTE21,
        p_PRICING_ATTRIBUTE22    => l_price_attributes_rec.PRICING_ATTRIBUTE22,
        p_PRICING_ATTRIBUTE23    => l_price_attributes_rec.PRICING_ATTRIBUTE23,
        p_PRICING_ATTRIBUTE24    => l_price_attributes_rec.PRICING_ATTRIBUTE24,
        p_PRICING_ATTRIBUTE25    => l_price_attributes_rec.PRICING_ATTRIBUTE25,
        p_PRICING_ATTRIBUTE26    => l_price_attributes_rec.PRICING_ATTRIBUTE26,
        p_PRICING_ATTRIBUTE27    => l_price_attributes_rec.PRICING_ATTRIBUTE27,
        p_PRICING_ATTRIBUTE28    => l_price_attributes_rec.PRICING_ATTRIBUTE28,
        p_PRICING_ATTRIBUTE29    => l_price_attributes_rec.PRICING_ATTRIBUTE29,
        p_PRICING_ATTRIBUTE30    => l_price_attributes_rec.PRICING_ATTRIBUTE30,
        p_PRICING_ATTRIBUTE31    => l_price_attributes_rec.PRICING_ATTRIBUTE31,
        p_PRICING_ATTRIBUTE32    => l_price_attributes_rec.PRICING_ATTRIBUTE32,
        p_PRICING_ATTRIBUTE33    => l_price_attributes_rec.PRICING_ATTRIBUTE33,
        p_PRICING_ATTRIBUTE34    => l_price_attributes_rec.PRICING_ATTRIBUTE34,
        p_PRICING_ATTRIBUTE35    => l_price_attributes_rec.PRICING_ATTRIBUTE35,
        p_PRICING_ATTRIBUTE36    => l_price_attributes_rec.PRICING_ATTRIBUTE36,
        p_PRICING_ATTRIBUTE37    => l_price_attributes_rec.PRICING_ATTRIBUTE37,
        p_PRICING_ATTRIBUTE38    => l_price_attributes_rec.PRICING_ATTRIBUTE38,
        p_PRICING_ATTRIBUTE39    => l_price_attributes_rec.PRICING_ATTRIBUTE39,
        p_PRICING_ATTRIBUTE40    => l_price_attributes_rec.PRICING_ATTRIBUTE40,
        p_PRICING_ATTRIBUTE41    => l_price_attributes_rec.PRICING_ATTRIBUTE41,
        p_PRICING_ATTRIBUTE42    => l_price_attributes_rec.PRICING_ATTRIBUTE42,
        p_PRICING_ATTRIBUTE43    => l_price_attributes_rec.PRICING_ATTRIBUTE43,
        p_PRICING_ATTRIBUTE44    => l_price_attributes_rec.PRICING_ATTRIBUTE44,
        p_PRICING_ATTRIBUTE45    => l_price_attributes_rec.PRICING_ATTRIBUTE45,
        p_PRICING_ATTRIBUTE46    => l_price_attributes_rec.PRICING_ATTRIBUTE46,
        p_PRICING_ATTRIBUTE47    => l_price_attributes_rec.PRICING_ATTRIBUTE47,
        p_PRICING_ATTRIBUTE48    => l_price_attributes_rec.PRICING_ATTRIBUTE48,
        p_PRICING_ATTRIBUTE49    => l_price_attributes_rec.PRICING_ATTRIBUTE49,
        p_PRICING_ATTRIBUTE50    => l_price_attributes_rec.PRICING_ATTRIBUTE50,
        p_PRICING_ATTRIBUTE51    => l_price_attributes_rec.PRICING_ATTRIBUTE51,
        p_PRICING_ATTRIBUTE52    => l_price_attributes_rec.PRICING_ATTRIBUTE52,
        p_PRICING_ATTRIBUTE53    => l_price_attributes_rec.PRICING_ATTRIBUTE53,
        p_PRICING_ATTRIBUTE54    => l_price_attributes_rec.PRICING_ATTRIBUTE54,
        p_PRICING_ATTRIBUTE55    => l_price_attributes_rec.PRICING_ATTRIBUTE55,
        p_PRICING_ATTRIBUTE56    => l_price_attributes_rec.PRICING_ATTRIBUTE56,
        p_PRICING_ATTRIBUTE57    => l_price_attributes_rec.PRICING_ATTRIBUTE57,
        p_PRICING_ATTRIBUTE58    => l_price_attributes_rec.PRICING_ATTRIBUTE58,
        p_PRICING_ATTRIBUTE59    => l_price_attributes_rec.PRICING_ATTRIBUTE59,
        p_PRICING_ATTRIBUTE60    => l_price_attributes_rec.PRICING_ATTRIBUTE60,
        p_PRICING_ATTRIBUTE61    => l_price_attributes_rec.PRICING_ATTRIBUTE61,
        p_PRICING_ATTRIBUTE62    => l_price_attributes_rec.PRICING_ATTRIBUTE62,
        p_PRICING_ATTRIBUTE63    => l_price_attributes_rec.PRICING_ATTRIBUTE63,
        p_PRICING_ATTRIBUTE64    => l_price_attributes_rec.PRICING_ATTRIBUTE64,
        p_PRICING_ATTRIBUTE65    => l_price_attributes_rec.PRICING_ATTRIBUTE65,
        p_PRICING_ATTRIBUTE66    => l_price_attributes_rec.PRICING_ATTRIBUTE66,
        p_PRICING_ATTRIBUTE67    => l_price_attributes_rec.PRICING_ATTRIBUTE67,
        p_PRICING_ATTRIBUTE68    => l_price_attributes_rec.PRICING_ATTRIBUTE68,
        p_PRICING_ATTRIBUTE69    => l_price_attributes_rec.PRICING_ATTRIBUTE69,
        p_PRICING_ATTRIBUTE70    => l_price_attributes_rec.PRICING_ATTRIBUTE70,
        p_PRICING_ATTRIBUTE71    => l_price_attributes_rec.PRICING_ATTRIBUTE71,
        p_PRICING_ATTRIBUTE72    => l_price_attributes_rec.PRICING_ATTRIBUTE72,
        p_PRICING_ATTRIBUTE73    => l_price_attributes_rec.PRICING_ATTRIBUTE73,
        p_PRICING_ATTRIBUTE74    => l_price_attributes_rec.PRICING_ATTRIBUTE74,
        p_PRICING_ATTRIBUTE75    => l_price_attributes_rec.PRICING_ATTRIBUTE75,
        p_PRICING_ATTRIBUTE76    => l_price_attributes_rec.PRICING_ATTRIBUTE76,
        p_PRICING_ATTRIBUTE77    => l_price_attributes_rec.PRICING_ATTRIBUTE77,
        p_PRICING_ATTRIBUTE78    => l_price_attributes_rec.PRICING_ATTRIBUTE78,
        p_PRICING_ATTRIBUTE79    => l_price_attributes_rec.PRICING_ATTRIBUTE79,
        p_PRICING_ATTRIBUTE80    => l_price_attributes_rec.PRICING_ATTRIBUTE80,
        p_PRICING_ATTRIBUTE81    => l_price_attributes_rec.PRICING_ATTRIBUTE81,
        p_PRICING_ATTRIBUTE82    => l_price_attributes_rec.PRICING_ATTRIBUTE82,
        p_PRICING_ATTRIBUTE83    => l_price_attributes_rec.PRICING_ATTRIBUTE83,
        p_PRICING_ATTRIBUTE84    => l_price_attributes_rec.PRICING_ATTRIBUTE84,
        p_PRICING_ATTRIBUTE85    => l_price_attributes_rec.PRICING_ATTRIBUTE85,
        p_PRICING_ATTRIBUTE86    => l_price_attributes_rec.PRICING_ATTRIBUTE86,
        p_PRICING_ATTRIBUTE87    => l_price_attributes_rec.PRICING_ATTRIBUTE87,
        p_PRICING_ATTRIBUTE88    => l_price_attributes_rec.PRICING_ATTRIBUTE88,
        p_PRICING_ATTRIBUTE89    => l_price_attributes_rec.PRICING_ATTRIBUTE89,
        p_PRICING_ATTRIBUTE90    => l_price_attributes_rec.PRICING_ATTRIBUTE90,
        p_PRICING_ATTRIBUTE91    => l_price_attributes_rec.PRICING_ATTRIBUTE91,
        p_PRICING_ATTRIBUTE92    => l_price_attributes_rec.PRICING_ATTRIBUTE92,
        p_PRICING_ATTRIBUTE93    => l_price_attributes_rec.PRICING_ATTRIBUTE93,
        p_PRICING_ATTRIBUTE94    => l_price_attributes_rec.PRICING_ATTRIBUTE94,
        p_PRICING_ATTRIBUTE95    => l_price_attributes_rec.PRICING_ATTRIBUTE95,
        p_PRICING_ATTRIBUTE96    => l_price_attributes_rec.PRICING_ATTRIBUTE96,
        p_PRICING_ATTRIBUTE97    => l_price_attributes_rec.PRICING_ATTRIBUTE97,
        p_PRICING_ATTRIBUTE98    => l_price_attributes_rec.PRICING_ATTRIBUTE98,
        p_PRICING_ATTRIBUTE99    => l_price_attributes_rec.PRICING_ATTRIBUTE99,
        p_PRICING_ATTRIBUTE100  => l_price_attributes_rec.PRICING_ATTRIBUTE100,
          p_CONTEXT    => l_price_attributes_rec.CONTEXT,
          p_ATTRIBUTE1    => l_price_attributes_rec.ATTRIBUTE1,
          p_ATTRIBUTE2    => l_price_attributes_rec.ATTRIBUTE2,
          p_ATTRIBUTE3    => l_price_attributes_rec.ATTRIBUTE3,
          p_ATTRIBUTE4    => l_price_attributes_rec.ATTRIBUTE4,
          p_ATTRIBUTE5    => l_price_attributes_rec.ATTRIBUTE5,
          p_ATTRIBUTE6    => l_price_attributes_rec.ATTRIBUTE6,
          p_ATTRIBUTE7    => l_price_attributes_rec.ATTRIBUTE7,
          p_ATTRIBUTE8    => l_price_attributes_rec.ATTRIBUTE8,
          p_ATTRIBUTE9    => l_price_attributes_rec.ATTRIBUTE9,
          p_ATTRIBUTE10    => l_price_attributes_rec.ATTRIBUTE10,
          p_ATTRIBUTE11    => l_price_attributes_rec.ATTRIBUTE11,
          p_ATTRIBUTE12    => l_price_attributes_rec.ATTRIBUTE12,
          p_ATTRIBUTE13    => l_price_attributes_rec.ATTRIBUTE13,
          p_ATTRIBUTE14    => l_price_attributes_rec.ATTRIBUTE14,
          p_ATTRIBUTE15    => l_price_attributes_rec.ATTRIBUTE15,
	     p_ATTRIBUTE16    => l_price_attributes_rec.ATTRIBUTE16,
		p_ATTRIBUTE17    => l_price_attributes_rec.ATTRIBUTE17,
		p_ATTRIBUTE18    => l_price_attributes_rec.ATTRIBUTE18,
		p_ATTRIBUTE19    => l_price_attributes_rec.ATTRIBUTE19,
		p_ATTRIBUTE20    => l_price_attributes_rec.ATTRIBUTE20,
		p_OBJECT_VERSION_NUMBER => l_price_attributes_rec.OBJECT_VERSION_NUMBER
);

Line: 1570

           aso_debug_pub.add('Insert_Rows: l_qte_access_tbl.count: '||l_qte_access_tbl.count, 1, 'Y');

Line: 1579

           aso_debug_pub.add('Insert_Rows: Before call to Add_Resource', 1, 'Y');

Line: 1595

               aso_debug_pub.add('Insert_Rows: After call to Add_Resource: x_return_status: '||x_return_status, 1, 'Y');

Line: 1600

END Insert_Rows;

Line: 1603

PROCEDURE Update_Rows (
    P_qte_Header_Rec        IN   ASO_QUOTE_PUB.qte_header_rec_Type,
    p_Price_Attributes_Tbl  IN   ASO_QUOTE_PUB.Price_Attributes_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_Payment_Tbl           IN   ASO_QUOTE_PUB.Payment_Tbl_Type,
    P_Shipment_Tbl          IN   ASO_QUOTE_PUB.Shipment_Tbl_Type,
    P_Freight_Charge_Tbl    IN   ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
    P_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_Sales_Credit_Tbl      IN   ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
    P_Quote_Party_Tbl       IN   ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
    P_Qte_Access_Tbl        IN   ASO_QUOTE_PUB.Qte_Access_Tbl_Type,
    X_qte_Header_Rec        OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.qte_header_rec_Type,
    X_Price_Attributes_Tbl  OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
    X_Price_Adjustment_Tbl  OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
    x_Price_Adj_Attr_Tbl	   OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
    X_Payment_Tbl		   OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Payment_Tbl_Type,
    X_Shipment_Tbl		   OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Shipment_Tbl_Type,
    X_Freight_Charge_Tbl	   OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
    X_Tax_Detail_Tbl        OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
    X_hd_Attr_Ext_Tbl       OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
    X_Sales_Credit_Tbl      OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
    X_Quote_Party_Tbl       OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
    X_Qte_Access_Tbl        OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Qte_Access_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_price_adj_rec		   ASO_QUOTE_PUB.Price_Adj_Rec_Type;

Line: 1661

    SELECT payment_term_id_from,payment_term_id
    FROM   ASO_PAYMENTS
    WHERE  payment_id = p_payment_id;

Line: 1667

    SELECT ship_method_code_from,ship_method_code,
    Freight_terms_code_from,Freight_terms_code
    FROM   ASO_SHIPMENTS
    WHERE  shipment_id = p_shipment_id;

Line: 1673

    select quote_number from aso_quote_headers_all
    where quote_header_id = p_qte_header_rec.quote_header_id;

Line: 1677

    select payment_type_code
    from aso_payments
    where payment_id = l_payment_id;

Line: 1682

    select invoice_to_cust_party_id
    from aso_quote_headers_all
    where quote_header_id = l_qte_hdr_id;

Line: 1690

    x_qte_header_rec.last_update_date := l_sysdate;

Line: 1692

	 aso_debug_pub.add('Begin Update Rows', 1, 'Y');

Line: 1750

    ASO_QUOTE_HEADERS_PKG.Update_Row(
	  p_QUOTE_HEADER_ID  => p_qte_header_rec.QUOTE_HEADER_ID,
	  p_CREATION_DATE  => p_qte_header_rec.creation_date,
	  p_CREATED_BY	=> G_USER_ID,
	  p_LAST_UPDATE_DATE  => l_sysdate,
	  p_LAST_UPDATED_BY  => G_USER_ID,
	  p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	  p_REQUEST_ID	=> p_qte_header_rec.REQUEST_ID,
	  p_PROGRAM_APPLICATION_ID  => p_qte_header_rec.PROGRAM_APPLICATION_ID,
	  p_PROGRAM_ID	=> p_qte_header_rec.PROGRAM_ID,
	  p_PROGRAM_UPDATE_DATE  => p_qte_header_rec.PROGRAM_UPDATE_DATE,
	  p_ORG_ID  => p_qte_header_rec.ORG_ID,
	  p_QUOTE_NAME	=> p_qte_header_rec.QUOTE_NAME,
	  p_QUOTE_NUMBER  => p_qte_header_rec.QUOTE_NUMBER,
	  p_QUOTE_VERSION  => p_qte_header_rec.QUOTE_VERSION,
	  p_QUOTE_STATUS_ID  => p_qte_header_rec.QUOTE_STATUS_ID,
	  p_QUOTE_SOURCE_CODE  => p_qte_header_rec.QUOTE_SOURCE_CODE,
	  p_QUOTE_EXPIRATION_DATE  => trunc(p_qte_header_rec.QUOTE_EXPIRATION_DATE),
	  p_PRICE_FROZEN_DATE  => p_qte_header_rec.PRICE_FROZEN_DATE,
	  p_QUOTE_PASSWORD  => p_qte_header_rec.QUOTE_PASSWORD,
	  p_ORIGINAL_SYSTEM_REFERENCE  => p_qte_header_rec.ORIGINAL_SYSTEM_REFERENCE,
	  p_PARTY_ID  => p_qte_header_rec.PARTY_ID,
	  p_CUST_ACCOUNT_ID  => p_qte_header_rec.CUST_ACCOUNT_ID,
	  p_ORG_CONTACT_ID  => p_qte_header_rec.ORG_CONTACT_ID,
	  p_PHONE_ID  => p_QTE_header_rec.PHONE_ID,
	  p_INVOICE_TO_PARTY_SITE_ID  => p_qte_header_rec.INVOICE_TO_PARTY_SITE_ID,
	  p_INVOICE_TO_PARTY_ID  => p_qte_header_rec.INVOICE_TO_PARTY_ID,
       p_Invoice_to_CUST_ACCOUNT_ID  => p_qte_header_rec.Invoice_to_CUST_ACCOUNT_ID,
	  p_ORIG_MKTG_SOURCE_CODE_ID  => p_qte_header_rec.ORIG_MKTG_SOURCE_CODE_ID,
	  p_MARKETING_SOURCE_CODE_ID  => p_qte_header_rec.MARKETING_SOURCE_CODE_ID,
	  p_ORDER_TYPE_ID  => p_qte_header_rec.ORDER_TYPE_ID,
	  p_QUOTE_CATEGORY_CODE  => p_qte_header_rec.QUOTE_CATEGORY_CODE,
	  p_ORDERED_DATE  => p_qte_header_rec.ORDERED_DATE,
	  p_ACCOUNTING_RULE_ID	=> p_qte_header_rec.ACCOUNTING_RULE_ID,
	  p_INVOICING_RULE_ID  => p_qte_header_rec.INVOICING_RULE_ID,
	  p_EMPLOYEE_PERSON_ID	=> p_qte_header_rec.EMPLOYEE_PERSON_ID,
	  p_PRICE_LIST_ID  => p_qte_header_rec.PRICE_LIST_ID,
	  p_CURRENCY_CODE  => p_qte_header_rec.CURRENCY_CODE,
	  p_TOTAL_LIST_PRICE  => p_qte_header_rec.TOTAL_LIST_PRICE,
	  p_TOTAL_ADJUSTED_AMOUNT  => p_qte_header_rec.TOTAL_ADJUSTED_AMOUNT,
	  p_TOTAL_ADJUSTED_PERCENT  => p_qte_header_rec.TOTAL_ADJUSTED_PERCENT,
	  p_TOTAL_TAX  => p_qte_header_rec.TOTAL_TAX,
	  p_TOTAL_SHIPPING_CHARGE  => p_qte_header_rec.TOTAL_SHIPPING_CHARGE,
	  p_SURCHARGE  => p_qte_header_rec.SURCHARGE,
	  p_TOTAL_QUOTE_PRICE  => p_qte_header_rec.TOTAL_QUOTE_PRICE,
	  p_PAYMENT_AMOUNT  => p_qte_header_rec.PAYMENT_AMOUNT,
	  p_EXCHANGE_RATE  => p_qte_header_rec.EXCHANGE_RATE,
	  p_EXCHANGE_TYPE_CODE	=> p_qte_header_rec.EXCHANGE_TYPE_CODE,
	  p_EXCHANGE_RATE_DATE	=> p_qte_header_rec.EXCHANGE_RATE_DATE,
	  p_CONTRACT_ID  => p_qte_header_rec.CONTRACT_ID,
	  p_SALES_CHANNEL_CODE	=> p_qte_header_rec.SALES_CHANNEL_CODE,
	  p_ORDER_ID  => p_QTE_header_rec.ORDER_ID,
	  p_RESOURCE_ID => p_qte_header_rec.RESOURCE_ID,
	  p_ATTRIBUTE_CATEGORY	=> p_qte_header_rec.ATTRIBUTE_CATEGORY,
	  p_ATTRIBUTE1	=> p_qte_header_rec.ATTRIBUTE1,
	  p_ATTRIBUTE2	=> p_qte_header_rec.ATTRIBUTE2,
	  p_ATTRIBUTE3	=> p_qte_header_rec.ATTRIBUTE3,
	  p_ATTRIBUTE4	=> p_qte_header_rec.ATTRIBUTE4,
	  p_ATTRIBUTE5	=> p_qte_header_rec.ATTRIBUTE5,
	  p_ATTRIBUTE6	=> p_qte_header_rec.ATTRIBUTE6,
	  p_ATTRIBUTE7	=> p_qte_header_rec.ATTRIBUTE7,
	  p_ATTRIBUTE8	=> p_qte_header_rec.ATTRIBUTE8,
	  p_ATTRIBUTE9	=> p_qte_header_rec.ATTRIBUTE9,
	  p_ATTRIBUTE10  => p_qte_header_rec.ATTRIBUTE10,
	  p_ATTRIBUTE11  => p_qte_header_rec.ATTRIBUTE11,
	  p_ATTRIBUTE12  => p_qte_header_rec.ATTRIBUTE12,
	  p_ATTRIBUTE13  => p_qte_header_rec.ATTRIBUTE13,
	  p_ATTRIBUTE14  => p_qte_header_rec.ATTRIBUTE14,
	  p_ATTRIBUTE15  => p_qte_header_rec.ATTRIBUTE15,
       p_ATTRIBUTE16  => p_qte_header_rec.ATTRIBUTE16,
       p_ATTRIBUTE17  => p_qte_header_rec.ATTRIBUTE17,
       p_ATTRIBUTE18  => p_qte_header_rec.ATTRIBUTE18,
       p_ATTRIBUTE19  => p_qte_header_rec.ATTRIBUTE19,
       p_ATTRIBUTE20  => p_qte_header_rec.ATTRIBUTE20,
-- hyang new okc
	  p_CONTRACT_TEMPLATE_ID  => FND_API.G_MISS_NUM,
	  p_CONTRACT_TEMPLATE_MAJOR_VER  => FND_API.G_MISS_NUM,
	  p_CONTRACT_REQUESTER_ID   => FND_API.G_MISS_NUM,
	  p_CONTRACT_APPROVAL_LEVEL => FND_API.G_MISS_CHAR,
-- end of hyang new okc
	  p_PUBLISH_FLAG            => p_qte_header_rec.PUBLISH_FLAG,
	  p_RESOURCE_GRP_ID         => p_qte_header_rec.RESOURCE_GRP_ID,
       p_SOLD_TO_PARTY_SITE_ID   => p_qte_header_rec.SOLD_TO_PARTY_SITE_ID,
	  p_DISPLAY_ARITHMETIC_OPERATOR => p_qte_header_rec.DISPLAY_ARITHMETIC_OPERATOR,
	  p_MAX_VERSION_FLAG     => p_qte_header_rec.MAX_VERSION_FLAG,
	  p_QUOTE_TYPE           => p_qte_header_rec.QUOTE_TYPE,
	  p_QUOTE_DESCRIPTION    => p_qte_header_rec.QUOTE_DESCRIPTION,
	  p_MINISITE_ID          => p_qte_header_rec.MINISITE_ID,
	  p_CUST_PARTY_ID          => p_qte_header_rec.CUST_PARTY_ID,
	  p_INVOICE_TO_CUST_PARTY_ID => p_qte_header_rec.INVOICE_TO_CUST_PARTY_ID,
       p_Pricing_Status_indicator        =>  p_qte_header_rec.Pricing_Status_indicator,
       p_Tax_status_Indicator      =>  p_qte_header_rec.Tax_status_Indicator,
       p_Price_updated_date                  =>  p_qte_header_rec.Price_updated_date,
       p_Tax_updated_date               =>  p_qte_header_rec.Tax_updated_date,
       p_Recalculate_flag               =>  p_qte_header_rec.Recalculate_flag,
       p_price_request_id               => p_qte_header_rec.price_request_id,
       p_credit_update_date             => p_qte_header_rec.credit_update_date,
-- hyang new okc
    P_Customer_Name_And_Title       =>  p_qte_header_rec.Customer_Name_And_Title,
    P_Customer_Signature_Date       =>  p_qte_header_rec.Customer_Signature_Date,
    P_Supplier_Name_And_Title       =>  p_qte_header_rec.Supplier_Name_And_Title,
    P_Supplier_Signature_Date       =>  p_qte_header_rec.Supplier_Signature_Date,
-- end of hyang new okc
    p_END_CUSTOMER_PARTY_ID         =>  p_qte_header_rec.END_CUSTOMER_PARTY_ID,
    p_END_CUSTOMER_CUST_PARTY_ID    =>  p_qte_header_rec.END_CUSTOMER_CUST_PARTY_ID,
    p_END_CUSTOMER_PARTY_SITE_ID    =>  p_qte_header_rec.END_CUSTOMER_PARTY_SITE_ID,
    p_END_CUSTOMER_CUST_ACCOUNT_ID  =>  p_qte_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID,
    p_OBJECT_VERSION_NUMBER         =>  p_qte_header_rec.OBJECT_VERSION_NUMBER,
    p_assistance_requested          =>  p_qte_header_rec.assistance_requested,
    p_assistance_reason_code        =>  p_qte_header_rec.assistance_reason_code,
    p_automatic_price_flag          =>  p_qte_header_rec.automatic_price_flag,
    p_automatic_tax_flag            =>  p_qte_header_rec.automatic_tax_flag,
    p_header_paynow_charges         =>  p_qte_header_rec.header_paynow_charges
);

Line: 1867

	aso_debug_pub.add('Update Rows - price_adj.count: '||x_price_adjustment_tbl.counT, 1, 'N');

Line: 1874

     x_price_adjustment_tbl(i).last_update_date := l_sysdate;

Line: 1878

	aso_debug_pub.add('Before price_adj.update_rows - Update Rows', 1, 'Y');

Line: 1881

	ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(
	    px_PRICE_ADJUSTMENT_ID  => x_price_adjustment_tbl(i).PRICE_ADJUSTMENT_ID,
	    p_CREATION_DATE  => SYSDATE,
	    p_CREATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_DATE	=> l_sysdate,
	    p_LAST_UPDATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	    p_PROGRAM_APPLICATION_ID  => l_price_adj_rec.PROGRAM_APPLICATION_ID,
	    p_PROGRAM_ID  => l_price_adj_rec.PROGRAM_ID,
	    p_PROGRAM_UPDATE_DATE  => l_price_adj_rec.PROGRAM_UPDATE_DATE,
	    p_REQUEST_ID  => l_price_adj_rec.REQUEST_ID,
	    p_QUOTE_HEADER_ID  => l_qte_header_id,
	    p_QUOTE_LINE_ID  => NULL,
	    p_MODIFIER_HEADER_ID  => l_price_adj_rec.MODIFIER_HEADER_ID,
	    p_MODIFIER_LINE_ID	=> l_price_adj_rec.MODIFIER_LINE_ID,
	    p_MODIFIER_LINE_TYPE_CODE  => l_price_adj_rec.MODIFIER_LINE_TYPE_CODE,
	    p_MODIFIER_MECHANISM_TYPE_CODE  => l_price_adj_rec.MODIFIER_MECHANISM_TYPE_CODE,
	    p_MODIFIED_FROM  => l_price_adj_rec.MODIFIED_FROM,
	    p_MODIFIED_TO  => l_price_adj_rec.MODIFIED_TO,
	    p_OPERAND  => l_price_adj_rec.OPERAND,
	    p_ARITHMETIC_OPERATOR  => l_price_adj_rec.ARITHMETIC_OPERATOR,
	    p_AUTOMATIC_FLAG  => l_price_adj_rec.AUTOMATIC_FLAG,
	    p_UPDATE_ALLOWABLE_FLAG  => l_price_adj_rec.UPDATE_ALLOWABLE_FLAG,
	    p_UPDATED_FLAG  => l_price_adj_rec.UPDATED_FLAG,
	    p_APPLIED_FLAG  => l_price_adj_rec.APPLIED_FLAG,
	    p_ON_INVOICE_FLAG  => l_price_adj_rec.ON_INVOICE_FLAG,
	    p_PRICING_PHASE_ID	=> l_price_adj_rec.PRICING_PHASE_ID,
	    p_ATTRIBUTE_CATEGORY  => l_price_adj_rec.ATTRIBUTE_CATEGORY,
	    p_ATTRIBUTE1  => l_price_adj_rec.ATTRIBUTE1,
	    p_ATTRIBUTE2  => l_price_adj_rec.ATTRIBUTE2,
	    p_ATTRIBUTE3  => l_price_adj_rec.ATTRIBUTE3,
	    p_ATTRIBUTE4  => l_price_adj_rec.ATTRIBUTE4,
	    p_ATTRIBUTE5  => l_price_adj_rec.ATTRIBUTE5,
	    p_ATTRIBUTE6  => l_price_adj_rec.ATTRIBUTE6,
	    p_ATTRIBUTE7  => l_price_adj_rec.ATTRIBUTE7,
	    p_ATTRIBUTE8  => l_price_adj_rec.ATTRIBUTE8,
	    p_ATTRIBUTE9  => l_price_adj_rec.ATTRIBUTE9,
	    p_ATTRIBUTE10  => l_price_adj_rec.ATTRIBUTE10,
	    p_ATTRIBUTE11  => l_price_adj_rec.ATTRIBUTE11,
	    p_ATTRIBUTE12  => l_price_adj_rec.ATTRIBUTE12,
	    p_ATTRIBUTE13  => l_price_adj_rec.ATTRIBUTE13,
	    p_ATTRIBUTE14  => l_price_adj_rec.ATTRIBUTE14,
	    p_ATTRIBUTE15  => l_price_adj_rec.ATTRIBUTE15,
           p_ATTRIBUTE16  => l_price_adj_rec.ATTRIBUTE16,
          p_ATTRIBUTE17  => l_price_adj_rec.ATTRIBUTE17,
          p_ATTRIBUTE18  => l_price_adj_rec.ATTRIBUTE18,
          p_ATTRIBUTE19  => l_price_adj_rec.ATTRIBUTE19,
          p_ATTRIBUTE20  => l_price_adj_rec.ATTRIBUTE20,
          p_ORIG_SYS_DISCOUNT_REF                    => l_price_adj_rec.ORIG_SYS_DISCOUNT_REF ,
          p_CHANGE_SEQUENCE                           => l_price_adj_rec.CHANGE_SEQUENCE ,
          -- p_LIST_HEADER_ID                            => l_price_adj_rec. ,
          -- p_LIST_LINE_ID                              => l_price_adj_rec. ,
          -- p_LIST_LINE_TYPE_CODE                       => l_price_adj_rec.,
          p_UPDATE_ALLOWED                            => l_price_adj_rec.UPDATE_ALLOWED,
          p_CHANGE_REASON_CODE                        => l_price_adj_rec.CHANGE_REASON_CODE,
          p_CHANGE_REASON_TEXT                        => l_price_adj_rec.CHANGE_REASON_TEXT,
          p_COST_ID                                   => l_price_adj_rec.COST_ID ,
          p_TAX_CODE                                  => l_price_adj_rec.TAX_CODE,
          p_TAX_EXEMPT_FLAG                           => l_price_adj_rec.TAX_EXEMPT_FLAG,
          p_TAX_EXEMPT_NUMBER                         => l_price_adj_rec.TAX_EXEMPT_NUMBER,
          p_TAX_EXEMPT_REASON_CODE                    => l_price_adj_rec.TAX_EXEMPT_REASON_CODE,
          p_PARENT_ADJUSTMENT_ID                      => l_price_adj_rec.PARENT_ADJUSTMENT_ID,
          p_INVOICED_FLAG                             => l_price_adj_rec.INVOICED_FLAG,
          p_ESTIMATED_FLAG                            => l_price_adj_rec.ESTIMATED_FLAG,
          p_INC_IN_SALES_PERFORMANCE                  => l_price_adj_rec.INC_IN_SALES_PERFORMANCE,
          p_SPLIT_ACTION_CODE                         => l_price_adj_rec.SPLIT_ACTION_CODE,
          p_ADJUSTED_AMOUNT                           => l_price_adj_rec.ADJUSTED_AMOUNT ,
          p_CHARGE_TYPE_CODE                          => l_price_adj_rec.CHARGE_TYPE_CODE,
          p_CHARGE_SUBTYPE_CODE                       => l_price_adj_rec.CHARGE_SUBTYPE_CODE,
          p_RANGE_BREAK_QUANTITY                      => l_price_adj_rec.RANGE_BREAK_QUANTITY,
          p_ACCRUAL_CONVERSION_RATE                   => l_price_adj_rec.ACCRUAL_CONVERSION_RATE ,
          p_PRICING_GROUP_SEQUENCE                    => l_price_adj_rec.PRICING_GROUP_SEQUENCE,
          p_ACCRUAL_FLAG                              => l_price_adj_rec.ACCRUAL_FLAG,
          p_LIST_LINE_NO                              => l_price_adj_rec.LIST_LINE_NO,
          p_SOURCE_SYSTEM_CODE                        => l_price_adj_rec.SOURCE_SYSTEM_CODE ,
          p_BENEFIT_QTY                               => l_price_adj_rec.BENEFIT_QTY,
          p_BENEFIT_UOM_CODE                          => l_price_adj_rec.BENEFIT_UOM_CODE,
          p_PRINT_ON_INVOICE_FLAG                     => l_price_adj_rec.PRINT_ON_INVOICE_FLAG,
          p_EXPIRATION_DATE                           => l_price_adj_rec.EXPIRATION_DATE,
          p_REBATE_TRANSACTION_TYPE_CODE              => l_price_adj_rec.REBATE_TRANSACTION_TYPE_CODE,
          p_REBATE_TRANSACTION_REFERENCE              => l_price_adj_rec.REBATE_TRANSACTION_REFERENCE,
          p_REBATE_PAYMENT_SYSTEM_CODE                => l_price_adj_rec.REBATE_PAYMENT_SYSTEM_CODE,
          p_REDEEMED_DATE                             => l_price_adj_rec.REDEEMED_DATE,
          p_REDEEMED_FLAG                             => l_price_adj_rec.REDEEMED_FLAG,
          p_MODIFIER_LEVEL_CODE                       => l_price_adj_rec.MODIFIER_LEVEL_CODE,
          p_PRICE_BREAK_TYPE_CODE                     => l_price_adj_rec.PRICE_BREAK_TYPE_CODE ,
          p_SUBSTITUTION_ATTRIBUTE                    => l_price_adj_rec.SUBSTITUTION_ATTRIBUTE,
          p_PRORATION_TYPE_CODE                       => l_price_adj_rec.PRORATION_TYPE_CODE ,
          p_INCLUDE_ON_RETURNS_FLAG                   => l_price_adj_rec.INCLUDE_ON_RETURNS_FLAG,
          p_CREDIT_OR_CHARGE_FLAG                     => l_price_adj_rec.CREDIT_OR_CHARGE_FLAG,
		p_quote_shipment_id                          => l_price_adj_rec.quote_shipment_id,
		p_OPERAND_PER_PQTY                          => l_price_adj_rec.OPERAND_PER_PQTY,
		p_ADJUSTED_AMOUNT_PER_PQTY                  => l_price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY,
		p_OBJECT_VERSION_NUMBER                     => l_price_adj_rec.OBJECT_VERSION_NUMBER
        );

Line: 1981

      ELSIF P_Price_Adjustment_Tbl(i).operation_code = 'UPDATE' THEN

	l_price_adj_rec := p_price_adjustment_tbl(i);

Line: 1985

    x_price_adjustment_tbl(i).last_update_date := l_sysdate;

Line: 1986

	ASO_PRICE_ADJUSTMENTS_PKG.Update_Row(
	    p_PRICE_ADJUSTMENT_ID  => l_price_adj_rec.PRICE_ADJUSTMENT_ID,
	    p_CREATION_DATE  => l_price_adj_rec.creation_date,
	    p_CREATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_DATE	=> l_sysdate,
	    p_LAST_UPDATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	    p_PROGRAM_APPLICATION_ID  => l_price_adj_rec.PROGRAM_APPLICATION_ID,
	    p_PROGRAM_ID  => l_price_adj_rec.PROGRAM_ID,
	    p_PROGRAM_UPDATE_DATE  => l_price_adj_rec.PROGRAM_UPDATE_DATE,
	    p_REQUEST_ID  => l_price_adj_rec.REQUEST_ID,
	    p_QUOTE_HEADER_ID  => l_qte_header_id,
	    p_QUOTE_LINE_ID  => NULL,
	    p_MODIFIER_HEADER_ID  => l_price_adj_rec.MODIFIER_HEADER_ID,
	    p_MODIFIER_LINE_ID	=> l_price_adj_rec.MODIFIER_LINE_ID,
	    p_MODIFIER_LINE_TYPE_CODE  => l_price_adj_rec.MODIFIER_LINE_TYPE_CODE,
	    p_MODIFIER_MECHANISM_TYPE_CODE  => l_price_adj_rec.MODIFIER_MECHANISM_TYPE_CODE,
	    p_MODIFIED_FROM  => l_price_adj_rec.MODIFIED_FROM,
	    p_MODIFIED_TO  => l_price_adj_rec.MODIFIED_TO,
	    p_OPERAND  => l_price_adj_rec.OPERAND,
	    p_ARITHMETIC_OPERATOR  => l_price_adj_rec.ARITHMETIC_OPERATOR,
	    p_AUTOMATIC_FLAG  => l_price_adj_rec.AUTOMATIC_FLAG,
	    p_UPDATE_ALLOWABLE_FLAG  => l_price_adj_rec.UPDATE_ALLOWABLE_FLAG,
	    p_UPDATED_FLAG  => l_price_adj_rec.UPDATED_FLAG,
	    p_APPLIED_FLAG  => l_price_adj_rec.APPLIED_FLAG,
	    p_ON_INVOICE_FLAG  => l_price_adj_rec.ON_INVOICE_FLAG,
	    p_PRICING_PHASE_ID	=> l_price_adj_rec.PRICING_PHASE_ID,
	    p_ATTRIBUTE_CATEGORY  => l_price_adj_rec.ATTRIBUTE_CATEGORY,
	    p_ATTRIBUTE1  => l_price_adj_rec.ATTRIBUTE1,
	    p_ATTRIBUTE2  => l_price_adj_rec.ATTRIBUTE2,
	    p_ATTRIBUTE3  => l_price_adj_rec.ATTRIBUTE3,
	    p_ATTRIBUTE4  => l_price_adj_rec.ATTRIBUTE4,
	    p_ATTRIBUTE5  => l_price_adj_rec.ATTRIBUTE5,
	    p_ATTRIBUTE6  => l_price_adj_rec.ATTRIBUTE6,
	    p_ATTRIBUTE7  => l_price_adj_rec.ATTRIBUTE7,
	    p_ATTRIBUTE8  => l_price_adj_rec.ATTRIBUTE8,
	    p_ATTRIBUTE9  => l_price_adj_rec.ATTRIBUTE9,
	    p_ATTRIBUTE10  => l_price_adj_rec.ATTRIBUTE10,
	    p_ATTRIBUTE11  => l_price_adj_rec.ATTRIBUTE11,
	    p_ATTRIBUTE12  => l_price_adj_rec.ATTRIBUTE12,
	    p_ATTRIBUTE13  => l_price_adj_rec.ATTRIBUTE13,
	    p_ATTRIBUTE14  => l_price_adj_rec.ATTRIBUTE14,
	    p_ATTRIBUTE15  => l_price_adj_rec.ATTRIBUTE15,
          p_ATTRIBUTE16  => l_price_adj_rec.ATTRIBUTE16,
          p_ATTRIBUTE17  => l_price_adj_rec.ATTRIBUTE17,
          p_ATTRIBUTE18  => l_price_adj_rec.ATTRIBUTE18,
          p_ATTRIBUTE19  => l_price_adj_rec.ATTRIBUTE19,
          p_ATTRIBUTE20  => l_price_adj_rec.ATTRIBUTE20,
		   p_ORIG_SYS_DISCOUNT_REF                    => l_price_adj_rec.ORIG_SYS_DISCOUNT_REF ,
          p_CHANGE_SEQUENCE                           => l_price_adj_rec.CHANGE_SEQUENCE ,
          -- p_LIST_HEADER_ID                            => l_price_adj_rec. ,
          -- p_LIST_LINE_ID                              => l_price_adj_rec. ,
          -- p_LIST_LINE_TYPE_CODE                       => l_price_adj_rec.,
          p_UPDATE_ALLOWED                            => l_price_adj_rec.UPDATE_ALLOWED,
          p_CHANGE_REASON_CODE                        => l_price_adj_rec.CHANGE_REASON_CODE,
          p_CHANGE_REASON_TEXT                        => l_price_adj_rec.CHANGE_REASON_TEXT,
          p_COST_ID                                   => l_price_adj_rec.COST_ID ,
          p_TAX_CODE                                  => l_price_adj_rec.TAX_CODE,
          p_TAX_EXEMPT_FLAG                           => l_price_adj_rec.TAX_EXEMPT_FLAG,
          p_TAX_EXEMPT_NUMBER                         => l_price_adj_rec.TAX_EXEMPT_NUMBER,
          p_TAX_EXEMPT_REASON_CODE                    => l_price_adj_rec.TAX_EXEMPT_REASON_CODE,
          p_PARENT_ADJUSTMENT_ID                      => l_price_adj_rec.PARENT_ADJUSTMENT_ID,
          p_INVOICED_FLAG                             => l_price_adj_rec.INVOICED_FLAG,
          p_ESTIMATED_FLAG                            => l_price_adj_rec.ESTIMATED_FLAG,
          p_INC_IN_SALES_PERFORMANCE                  => l_price_adj_rec.INC_IN_SALES_PERFORMANCE,
          p_SPLIT_ACTION_CODE                         => l_price_adj_rec.SPLIT_ACTION_CODE,
          p_ADJUSTED_AMOUNT                           => l_price_adj_rec.ADJUSTED_AMOUNT ,
          p_CHARGE_TYPE_CODE                          => l_price_adj_rec.CHARGE_TYPE_CODE,
          p_CHARGE_SUBTYPE_CODE                       => l_price_adj_rec.CHARGE_SUBTYPE_CODE,
          p_RANGE_BREAK_QUANTITY                      => l_price_adj_rec.RANGE_BREAK_QUANTITY,
          p_ACCRUAL_CONVERSION_RATE                   => l_price_adj_rec.ACCRUAL_CONVERSION_RATE ,
          p_PRICING_GROUP_SEQUENCE                    => l_price_adj_rec.PRICING_GROUP_SEQUENCE,
          p_ACCRUAL_FLAG                              => l_price_adj_rec.ACCRUAL_FLAG,
          p_LIST_LINE_NO                              => l_price_adj_rec.LIST_LINE_NO,
          p_SOURCE_SYSTEM_CODE                        => l_price_adj_rec.SOURCE_SYSTEM_CODE ,
          p_BENEFIT_QTY                               => l_price_adj_rec.BENEFIT_QTY,
          p_BENEFIT_UOM_CODE                          => l_price_adj_rec.BENEFIT_UOM_CODE,
          p_PRINT_ON_INVOICE_FLAG                     => l_price_adj_rec.PRINT_ON_INVOICE_FLAG,
          p_EXPIRATION_DATE                           => l_price_adj_rec.EXPIRATION_DATE,
          p_REBATE_TRANSACTION_TYPE_CODE              => l_price_adj_rec.REBATE_TRANSACTION_TYPE_CODE,
          p_REBATE_TRANSACTION_REFERENCE              => l_price_adj_rec.REBATE_TRANSACTION_REFERENCE,
          p_REBATE_PAYMENT_SYSTEM_CODE                => l_price_adj_rec.REBATE_PAYMENT_SYSTEM_CODE,
          p_REDEEMED_DATE                             => l_price_adj_rec.REDEEMED_DATE,
          p_REDEEMED_FLAG                             => l_price_adj_rec.REDEEMED_FLAG,
          p_MODIFIER_LEVEL_CODE                       => l_price_adj_rec.MODIFIER_LEVEL_CODE,
          p_PRICE_BREAK_TYPE_CODE                     => l_price_adj_rec.PRICE_BREAK_TYPE_CODE ,
          p_SUBSTITUTION_ATTRIBUTE                    => l_price_adj_rec.SUBSTITUTION_ATTRIBUTE,
          p_PRORATION_TYPE_CODE                       => l_price_adj_rec.PRORATION_TYPE_CODE ,
          p_INCLUDE_ON_RETURNS_FLAG                   => l_price_adj_rec.INCLUDE_ON_RETURNS_FLAG,
          p_CREDIT_OR_CHARGE_FLAG                     => l_price_adj_rec.CREDIT_OR_CHARGE_FLAG,
		p_quote_shipment_id                          => l_price_adj_rec.quote_shipment_id,
		p_OPERAND_PER_PQTY                          => l_price_adj_rec.OPERAND_PER_PQTY,
		p_ADJUSTED_AMOUNT_PER_PQTY                  => l_price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY,
		p_OBJECT_VERSION_NUMBER                     => l_price_adj_rec.OBJECT_VERSION_NUMBER
        );

Line: 2081

      ELSIF P_Price_Adjustment_Tbl(i).operation_code = 'DELETE' THEN
	ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(
	    p_PRICE_ADJUSTMENT_ID  => p_price_adjustment_tbl(i).PRICE_ADJUSTMENT_ID);

Line: 2101

      x_price_adj_attr_tbl(i).LAST_UPDATE_DATE := l_sysdate;

Line: 2103

	ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row(
		px_PRICE_ADJ_ATTRIB_ID	 => x_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID,
		p_CREATION_DATE  => SYSDATE,
		p_CREATED_BY  => G_USER_ID,
		p_LAST_UPDATE_DATE  => l_sysdate,
		p_LAST_UPDATED_BY  => G_USER_ID,
		p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
		p_PROGRAM_APPLICATION_ID  =>l_price_adj_attr_tbl(i).PROGRAM_APPLICATION_ID,
		p_PROGRAM_ID  => l_price_adj_attr_tbl(i).PROGRAM_ID,
		p_PROGRAM_UPDATE_DATE  => l_price_adj_attr_tbl(i).PROGRAM_UPDATE_DATE,
		p_REQUEST_ID  => l_price_adj_attr_tbl(i).REQUEST_ID,
		p_PRICE_ADJUSTMENT_ID => l_price_adj_attr_tbl(i).PRICE_ADJUSTMENT_ID,
		p_PRICING_CONTEXT  => l_price_adj_attr_tbl(i).PRICING_CONTEXT,
		p_PRICING_ATTRIBUTE => l_price_adj_attr_tbl(i).PRICING_ATTRIBUTE,
		p_PRICING_ATTR_VALUE_FROM => l_price_adj_attr_tbl(i).PRICING_ATTR_VALUE_FROM,
		p_PRICING_ATTR_VALUE_TO  => l_price_adj_attr_tbl(i).PRICING_ATTR_VALUE_TO,
		p_COMPARISON_OPERATOR	=> l_price_adj_attr_tbl(i).COMPARISON_OPERATOR,
		p_FLEX_TITLE   => l_price_adj_attr_tbl(i).FLEX_TITLE,
		p_OBJECT_VERSION_NUMBER  => l_price_adj_attr_tbl(i).OBJECT_VERSION_NUMBER
		);

Line: 2124

      ELSIF l_Price_Adj_Attr_Tbl(i).operation_code = 'UPDATE' THEN

	 x_price_adj_attr_tbl(i) := l_price_adj_attr_tbl(i);

Line: 2128

      x_price_adj_attr_tbl(i).LAST_UPDATE_DATE := l_sysdate;

Line: 2130

	ASO_PRICE_ADJ_ATTRIBS_PKG.Update_Row(
		p_PRICE_ADJ_ATTRIB_ID	=> x_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID,
		p_CREATION_DATE  => l_price_adj_attr_tbl(i).creation_date,
		p_CREATED_BY  => G_USER_ID,
		p_LAST_UPDATE_DATE  => l_sysdate,
		p_LAST_UPDATED_BY  => G_USER_ID,
		p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
		p_PROGRAM_APPLICATION_ID  =>l_price_adj_attr_tbl(i).PROGRAM_APPLICATION_ID,
		p_PROGRAM_ID  => l_price_adj_attr_tbl(i).PROGRAM_ID,
		p_PROGRAM_UPDATE_DATE  => l_price_adj_attr_tbl(i).PROGRAM_UPDATE_DATE,
		p_REQUEST_ID  => l_price_adj_attr_tbl(i).REQUEST_ID,
		p_PRICE_ADJUSTMENT_ID => l_price_adj_attr_tbl(i).PRICE_ADJUSTMENT_ID,
		p_PRICING_CONTEXT  => l_price_adj_attr_tbl(i).PRICING_CONTEXT,
		p_PRICING_ATTRIBUTE => l_price_adj_attr_tbl(i).PRICING_ATTRIBUTE,
		p_PRICING_ATTR_VALUE_FROM => l_price_adj_attr_tbl(i).PRICING_ATTR_VALUE_FROM,
		p_PRICING_ATTR_VALUE_TO  => l_price_adj_attr_tbl(i).PRICING_ATTR_VALUE_TO,
		p_COMPARISON_OPERATOR	=> l_price_adj_attr_tbl(i).COMPARISON_OPERATOR,
		p_FLEX_TITLE   => l_price_adj_attr_tbl(i).FLEX_TITLE,
		p_OBJECT_VERSION_NUMBER  => l_price_adj_attr_tbl(i).OBJECT_VERSION_NUMBER);

Line: 2149

      ELSIF l_Price_Adj_Attr_Tbl(i).operation_code = 'DELETE' THEN
	ASO_PRICE_ADJ_ATTRIBS_PKG.Delete_Row(
	    p_PRICE_ADJ_ATTRIB_ID  => l_price_adj_attr_tbl(i).PRICE_ADJUSTMENT_ID);

Line: 2165

         aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows p_payment_tbl(i).payment_term_id'||p_payment_tbl(i).payment_term_id, 1, 'Y');

Line: 2166

        aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows l_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');

Line: 2170

           x_payment_tbl(i).LAST_UPDATE_DATE := l_sysdate;

Line: 2179

               aso_debug_pub.add('Update_Rows: Before  call to create_payment_row ', 1, 'Y');

Line: 2189

               aso_debug_pub.add('Update_Rows: After call to create_payment_row: x_return_status: '||x_return_status, 1, 'Y');

Line: 2202

           x_payment_tbl(i).LAST_UPDATE_DATE := l_sysdate;

Line: 2207

      ELSIF P_Payment_Tbl(i).operation_code = 'UPDATE' THEN

          l_payment_rec := p_payment_tbl(i);

Line: 2228

         aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.payment_term_id'||l_payment_rec.payment_term_id, 1, 'Y');

Line: 2229

        aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');

Line: 2232

        x_payment_tbl(i).last_update_date     := l_sysdate;

Line: 2240

               aso_debug_pub.add('Update_Rows: Before  call to update_payment_row ', 1, 'Y');

Line: 2243

         aso_payment_int.update_payment_row(p_payment_rec => l_payment_rec  ,
                                             x_payment_rec   => x_payment_tbl(i),
                                             x_return_status => x_return_status,
                                             x_msg_count     => x_msg_count,
                                             x_msg_data      => x_msg_data);

Line: 2250

               aso_debug_pub.add('Update_Rows: After call to update_payment_row: x_return_status: '||x_return_status, 1, 'Y');

Line: 2263

           x_payment_tbl(i).LAST_UPDATE_DATE := l_sysdate;

Line: 2268

      ELSIF P_Payment_Tbl(i).operation_code = 'DELETE' THEN

     -- Payments Changes
          l_payment_rec := P_Payment_Tbl(i);

Line: 2275

               aso_debug_pub.add('Update_Rows: Before  call to delete_payment_row ', 1, 'Y');

Line: 2278

         aso_payment_int.delete_payment_row(p_payment_rec => l_payment_rec  ,
                                             x_return_status => x_return_status,
                                             x_msg_count     => x_msg_count,
                                             x_msg_data      => x_msg_data);

Line: 2284

               aso_debug_pub.add('Update_Rows: After call to delete_payment_row: x_return_status: '||x_return_status, 1, 'Y');

Line: 2314

      aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows - p_shipment_tbl(1).ship_method_code'||p_shipment_tbl(1).ship_method_code, 1, 'Y');

Line: 2315

      aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows - p_shipment_tbl(1).freight_terms_code'||p_shipment_tbl(1).freight_terms_code, 1, 'Y');

Line: 2322

       x_shipment_tbl(i).last_update_date        := l_sysdate;

Line: 2326

	ASO_SHIPMENTS_PKG.Insert_Row(
	    px_SHIPMENT_ID  => x_shipment_tbl(i).SHIPMENT_ID,
	    p_CREATION_DATE  => SYSDATE,
	    p_CREATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_DATE	=> l_sysdate,
	    p_LAST_UPDATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	    p_REQUEST_ID  => l_shipment_rec.REQUEST_ID,
	    p_PROGRAM_APPLICATION_ID  => l_shipment_rec.PROGRAM_APPLICATION_ID,
	    p_PROGRAM_ID  => l_shipment_rec.PROGRAM_ID,
	    p_PROGRAM_UPDATE_DATE  => l_shipment_rec.PROGRAM_UPDATE_DATE,
	    p_QUOTE_HEADER_ID  => l_qte_HEADER_ID,
	    p_QUOTE_LINE_ID  => NULL,
	    p_PROMISE_DATE  => l_shipment_rec.PROMISE_DATE,
	    p_REQUEST_DATE  => l_shipment_rec.REQUEST_DATE,
	    p_SCHEDULE_SHIP_DATE  => l_shipment_rec.SCHEDULE_SHIP_DATE,
	    p_SHIP_TO_PARTY_SITE_ID  => l_shipment_rec.SHIP_TO_PARTY_SITE_ID,
	    p_SHIP_TO_PARTY_ID	=> l_shipment_rec.SHIP_TO_PARTY_ID,
            p_ship_to_CUST_ACCOUNT_ID  => l_shipment_rec.ship_to_CUST_ACCOUNT_ID,
	    p_SHIP_PARTIAL_FLAG  => l_shipment_rec.SHIP_PARTIAL_FLAG,
	    p_SHIP_SET_ID  => l_shipment_rec.SHIP_SET_ID,
	    p_SHIP_METHOD_CODE	=> l_shipment_rec.SHIP_METHOD_CODE,
	    p_FREIGHT_TERMS_CODE  => l_shipment_rec.FREIGHT_TERMS_CODE,
	    p_FREIGHT_CARRIER_CODE  => l_shipment_rec.FREIGHT_CARRIER_CODE,
	    p_FOB_CODE	=> l_shipment_rec.FOB_CODE,
	    p_SHIPPING_INSTRUCTIONS  => l_shipment_rec.SHIPPING_INSTRUCTIONS,
	    p_PACKING_INSTRUCTIONS  => l_shipment_rec.PACKING_INSTRUCTIONS,
	    p_QUANTITY	=> l_shipment_rec.QUANTITY,
	    p_RESERVED_QUANTITY  => l_shipment_rec.RESERVED_QUANTITY,
	    p_RESERVATION_ID  => l_shipment_rec.RESERVATION_ID,
	    p_ORDER_LINE_ID  => l_shipment_rec.ORDER_LINE_ID,
	    p_ATTRIBUTE_CATEGORY  => l_shipment_rec.ATTRIBUTE_CATEGORY,
	    p_ATTRIBUTE1  => l_shipment_rec.ATTRIBUTE1,
	    p_ATTRIBUTE2  => l_shipment_rec.ATTRIBUTE2,
	    p_ATTRIBUTE3  => l_shipment_rec.ATTRIBUTE3,
	    p_ATTRIBUTE4  => l_shipment_rec.ATTRIBUTE4,
	    p_ATTRIBUTE5  => l_shipment_rec.ATTRIBUTE5,
	    p_ATTRIBUTE6  => l_shipment_rec.ATTRIBUTE6,
	    p_ATTRIBUTE7  => l_shipment_rec.ATTRIBUTE7,
	    p_ATTRIBUTE8  => l_shipment_rec.ATTRIBUTE8,
	    p_ATTRIBUTE9  => l_shipment_rec.ATTRIBUTE9,
	    p_ATTRIBUTE10  => l_shipment_rec.ATTRIBUTE10,
	    p_ATTRIBUTE11  => l_shipment_rec.ATTRIBUTE11,
	    p_ATTRIBUTE12  => l_shipment_rec.ATTRIBUTE12,
	    p_ATTRIBUTE13  => l_shipment_rec.ATTRIBUTE13,
	    p_ATTRIBUTE14  => l_shipment_rec.ATTRIBUTE14,
	    p_ATTRIBUTE15  => l_shipment_rec.ATTRIBUTE15,
         p_ATTRIBUTE16  =>  l_shipment_rec.ATTRIBUTE16,
         p_ATTRIBUTE17  =>  l_shipment_rec.ATTRIBUTE17,
         p_ATTRIBUTE18  =>  l_shipment_rec.ATTRIBUTE18,
         p_ATTRIBUTE19  =>  l_shipment_rec.ATTRIBUTE19,
         p_ATTRIBUTE20  =>  l_shipment_rec.ATTRIBUTE20,
		p_SHIPMENT_PRIORITY_CODE => l_shipment_rec.SHIPMENT_PRIORITY_CODE,
          p_SHIP_QUOTE_PRICE => l_shipment_rec.SHIP_QUOTE_PRICE,
	    p_SHIP_FROM_ORG_ID => l_shipment_rec.SHIP_FROM_ORG_ID,
	    p_SHIP_TO_CUST_PARTY_ID => l_shipment_rec.SHIP_TO_CUST_PARTY_ID,
         p_SHIP_METHOD_CODE_FROM   => l_shipment_rec.SHIP_METHOD_CODE_FROM,
         p_FREIGHT_TERMS_CODE_FROM  => l_shipment_rec.FREIGHT_TERMS_CODE_FROM,
	    p_OBJECT_VERSION_NUMBER  => l_shipment_rec.OBJECT_VERSION_NUMBER,
	    p_REQUEST_DATE_TYPE => l_shipment_rec.REQUEST_DATE_TYPE,
         p_demand_class_code => l_shipment_rec.demand_class_code
	    );

Line: 2396

     ELSIF P_Shipment_Tbl(i).operation_code = 'UPDATE' THEN

          l_sysdate                          := sysdate;

Line: 2399

          x_shipment_tbl(i).last_update_date := l_sysdate;

Line: 2434

            aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.update_rows - l_shipment_rec.ship_method_code'||l_shipment_rec.ship_method_code, 1, 'Y');

Line: 2435

      aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.update_rows - l_shipment_rec.freight_terms_code'||l_shipment_rec.freight_terms_code, 1, 'Y');

Line: 2441

	ASO_SHIPMENTS_PKG.Update_Row(
	    p_SHIPMENT_ID  => l_shipment_rec.SHIPMENT_ID,
	    p_CREATION_DATE  => l_shipment_rec.creation_date,
	    p_CREATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_DATE	=> l_sysdate,
	    p_LAST_UPDATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	    p_REQUEST_ID  => l_shipment_rec.REQUEST_ID,
	    p_PROGRAM_APPLICATION_ID  => l_shipment_rec.PROGRAM_APPLICATION_ID,
	    p_PROGRAM_ID  => l_shipment_rec.PROGRAM_ID,
	    p_PROGRAM_UPDATE_DATE  => l_shipment_rec.PROGRAM_UPDATE_DATE,
	    p_QUOTE_HEADER_ID  => l_qte_HEADER_ID,
	    p_QUOTE_LINE_ID  => NULL,
	    p_PROMISE_DATE  => l_shipment_rec.PROMISE_DATE,
	    p_REQUEST_DATE  => l_shipment_rec.REQUEST_DATE,
	    p_SCHEDULE_SHIP_DATE  => l_shipment_rec.SCHEDULE_SHIP_DATE,
	    p_SHIP_TO_PARTY_SITE_ID  => l_shipment_rec.SHIP_TO_PARTY_SITE_ID,
	    p_SHIP_TO_PARTY_ID	=> l_shipment_rec.SHIP_TO_PARTY_ID,
            p_ship_to_CUST_ACCOUNT_ID  => l_shipment_rec.ship_to_CUST_ACCOUNT_ID,
	    p_SHIP_PARTIAL_FLAG  => l_shipment_rec.SHIP_PARTIAL_FLAG,
	    p_SHIP_SET_ID  => l_shipment_rec.SHIP_SET_ID,
	    p_SHIP_METHOD_CODE	=> l_shipment_rec.SHIP_METHOD_CODE,
	    p_FREIGHT_TERMS_CODE  => l_shipment_rec.FREIGHT_TERMS_CODE,
	    p_FREIGHT_CARRIER_CODE  => l_shipment_rec.FREIGHT_CARRIER_CODE,
	    p_FOB_CODE	=> l_shipment_rec.FOB_CODE,
	    p_SHIPPING_INSTRUCTIONS  => l_shipment_rec.SHIPPING_INSTRUCTIONS,
	    p_PACKING_INSTRUCTIONS  => l_shipment_rec.PACKING_INSTRUCTIONS,
	    p_QUANTITY	=> l_shipment_rec.QUANTITY,
	    p_RESERVED_QUANTITY  => l_shipment_rec.RESERVED_QUANTITY,
	    p_RESERVATION_ID  => l_shipment_rec.RESERVATION_ID,
	    p_ORDER_LINE_ID  => l_shipment_rec.ORDER_LINE_ID,
	    p_ATTRIBUTE_CATEGORY  => l_shipment_rec.ATTRIBUTE_CATEGORY,
	    p_ATTRIBUTE1  => l_shipment_rec.ATTRIBUTE1,
	    p_ATTRIBUTE2  => l_shipment_rec.ATTRIBUTE2,
	    p_ATTRIBUTE3  => l_shipment_rec.ATTRIBUTE3,
	    p_ATTRIBUTE4  => l_shipment_rec.ATTRIBUTE4,
	    p_ATTRIBUTE5  => l_shipment_rec.ATTRIBUTE5,
	    p_ATTRIBUTE6  => l_shipment_rec.ATTRIBUTE6,
	    p_ATTRIBUTE7  => l_shipment_rec.ATTRIBUTE7,
	    p_ATTRIBUTE8  => l_shipment_rec.ATTRIBUTE8,
	    p_ATTRIBUTE9  => l_shipment_rec.ATTRIBUTE9,
	    p_ATTRIBUTE10  => l_shipment_rec.ATTRIBUTE10,
	    p_ATTRIBUTE11  => l_shipment_rec.ATTRIBUTE11,
	    p_ATTRIBUTE12  => l_shipment_rec.ATTRIBUTE12,
	    p_ATTRIBUTE13  => l_shipment_rec.ATTRIBUTE13,
	    p_ATTRIBUTE14  => l_shipment_rec.ATTRIBUTE14,
	    p_ATTRIBUTE15  => l_shipment_rec.ATTRIBUTE15,
          p_ATTRIBUTE16  =>  l_shipment_rec.ATTRIBUTE16,
          p_ATTRIBUTE17  =>  l_shipment_rec.ATTRIBUTE17,
          p_ATTRIBUTE18  =>  l_shipment_rec.ATTRIBUTE18,
          p_ATTRIBUTE19  =>  l_shipment_rec.ATTRIBUTE19,
          p_ATTRIBUTE20  =>  l_shipment_rec.ATTRIBUTE20,
		p_SHIPMENT_PRIORITY_CODE => l_shipment_rec.SHIPMENT_PRIORITY_CODE,
          p_SHIP_QUOTE_PRICE => l_shipment_rec.SHIP_QUOTE_PRICE,
	    p_SHIP_FROM_ORG_ID => l_shipment_rec.SHIP_FROM_ORG_ID,
	    p_SHIP_TO_CUST_PARTY_ID => l_shipment_rec.SHIP_TO_CUST_PARTY_ID,
         p_SHIP_METHOD_CODE_FROM   => l_shipment_rec.SHIP_METHOD_CODE_FROM,
         p_FREIGHT_TERMS_CODE_FROM  => l_shipment_rec.FREIGHT_TERMS_CODE_FROM,
	    p_OBJECT_VERSION_NUMBER  => l_shipment_rec.OBJECT_VERSION_NUMBER,
         p_REQUEST_DATE_TYPE => l_shipment_rec.REQUEST_DATE_TYPE,
         p_demand_class_code => l_shipment_rec.demand_class_code
         );

Line: 2503

      ELSIF P_Shipment_Tbl(i).operation_code = 'DELETE' THEN
	ASO_SHIPMENTS_PKG.Delete_Row(
	    p_SHIPMENT_ID  => P_Shipment_Tbl(i).SHIPMENT_ID);

Line: 2514

        x_FREIGHT_CHARGE_tbl(i).last_update_date := l_sysdate;

Line: 2517

	    ASO_FREIGHT_CHARGES_PKG.Insert_Row(
		px_FREIGHT_CHARGE_ID  => x_FREIGHT_CHARGE_tbl(i).freight_charge_id,
		p_CREATION_DATE  => SYSDATE,
	    	p_CREATED_BY  => G_USER_ID,
	    	p_LAST_UPDATE_DATE  => l_sysdate,
	    	p_LAST_UPDATED_BY  => G_USER_ID,
	    	p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	    	p_REQUEST_ID  => l_freight_charge_rec.REQUEST_ID,
	    	p_PROGRAM_APPLICATION_ID  => l_freight_charge_rec.PROGRAM_APPLICATION_ID,
	    	p_PROGRAM_ID  => l_freight_charge_rec.PROGRAM_ID,
	    	p_PROGRAM_UPDATE_DATE  => l_freight_charge_rec.PROGRAM_UPDATE_DATE,
	    	p_QUOTE_SHIPMENT_ID  => l_freight_charge_rec.Quote_SHIPMENT_ID,
	    	p_FREIGHT_CHARGE_TYPE_ID  => l_freight_charge_rec.FREIGHT_CHARGE_TYPE_ID,
	    	p_CHARGE_AMOUNT  => l_freight_charge_rec.CHARGE_AMOUNT,
	    	p_ATTRIBUTE_CATEGORY  => l_freight_charge_rec.ATTRIBUTE_CATEGORY,
	    	p_ATTRIBUTE1  => l_freight_charge_rec.ATTRIBUTE1,
	    	p_ATTRIBUTE2  => l_freight_charge_rec.ATTRIBUTE2,
	    	p_ATTRIBUTE3  => l_freight_charge_rec.ATTRIBUTE3,
	    	p_ATTRIBUTE4  => l_freight_charge_rec.ATTRIBUTE4,
	    	p_ATTRIBUTE5  => l_freight_charge_rec.ATTRIBUTE5,
	    	p_ATTRIBUTE6  => l_freight_charge_rec.ATTRIBUTE6,
	    	p_ATTRIBUTE7  => l_freight_charge_rec.ATTRIBUTE7,
	    	p_ATTRIBUTE8  => l_freight_charge_rec.ATTRIBUTE8,
	    	p_ATTRIBUTE9  => l_freight_charge_rec.ATTRIBUTE9,
	    	p_ATTRIBUTE10  => l_freight_charge_rec.ATTRIBUTE10,
	    	p_ATTRIBUTE11  => l_freight_charge_rec.ATTRIBUTE11,
	    	p_ATTRIBUTE12  => l_freight_charge_rec.ATTRIBUTE12,
	    	p_ATTRIBUTE13  => l_freight_charge_rec.ATTRIBUTE13,
	    	p_ATTRIBUTE14  => l_freight_charge_rec.ATTRIBUTE14,
	    	p_ATTRIBUTE15  => l_freight_charge_rec.ATTRIBUTE15);

Line: 2547

	 ELSIF l_Freight_Charge_Tbl(i).operation_code = 'UPDATE' THEN
        l_sysdate := sysdate;

Line: 2550

        x_FREIGHT_CHARGE_tbl(i).last_update_date := l_sysdate;

Line: 2551

	    ASO_FREIGHT_CHARGES_PKG.Update_Row(
		p_FREIGHT_CHARGE_ID  => l_freight_charge_rec.freight_charge_id,
		p_CREATION_DATE  => l_freight_charge_rec.creation_date,
	    	p_CREATED_BY  => G_USER_ID,
	    	p_LAST_UPDATE_DATE  => l_sysdate,
	    	p_LAST_UPDATED_BY  => G_USER_ID,
	    	p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	    	p_REQUEST_ID  => l_freight_charge_rec.REQUEST_ID,
	    	p_PROGRAM_APPLICATION_ID  => l_freight_charge_rec.PROGRAM_APPLICATION_ID,
	    	p_PROGRAM_ID  => l_freight_charge_rec.PROGRAM_ID,
	    	p_PROGRAM_UPDATE_DATE  => l_freight_charge_rec.PROGRAM_UPDATE_DATE,
	    	p_QUOTE_SHIPMENT_ID  => l_freight_charge_rec.Quote_SHIPMENT_ID,
	    	p_FREIGHT_CHARGE_TYPE_ID  => l_freight_charge_rec.FREIGHT_CHARGE_TYPE_ID,
	    	p_CHARGE_AMOUNT  => l_freight_charge_rec.CHARGE_AMOUNT,
	    	p_ATTRIBUTE_CATEGORY  => l_freight_charge_rec.ATTRIBUTE_CATEGORY,
	    	p_ATTRIBUTE1  => l_freight_charge_rec.ATTRIBUTE1,
	    	p_ATTRIBUTE2  => l_freight_charge_rec.ATTRIBUTE2,
	    	p_ATTRIBUTE3  => l_freight_charge_rec.ATTRIBUTE3,
	    	p_ATTRIBUTE4  => l_freight_charge_rec.ATTRIBUTE4,
	    	p_ATTRIBUTE5  => l_freight_charge_rec.ATTRIBUTE5,
	    	p_ATTRIBUTE6  => l_freight_charge_rec.ATTRIBUTE6,
	    	p_ATTRIBUTE7  => l_freight_charge_rec.ATTRIBUTE7,
	    	p_ATTRIBUTE8  => l_freight_charge_rec.ATTRIBUTE8,
	    	p_ATTRIBUTE9  => l_freight_charge_rec.ATTRIBUTE9,
	    	p_ATTRIBUTE10  => l_freight_charge_rec.ATTRIBUTE10,
	    	p_ATTRIBUTE11  => l_freight_charge_rec.ATTRIBUTE11,
	    	p_ATTRIBUTE12  => l_freight_charge_rec.ATTRIBUTE12,
	    	p_ATTRIBUTE13  => l_freight_charge_rec.ATTRIBUTE13,
	    	p_ATTRIBUTE14  => l_freight_charge_rec.ATTRIBUTE14,
	    	p_ATTRIBUTE15  => l_freight_charge_rec.ATTRIBUTE15);

Line: 2581

	 ELSIF l_Freight_Charge_Tbl(i).operation_code = 'DELETE' THEN
	     ASO_FREIGHT_CHARGES_PKG.Delete_Row(
		p_FREIGHT_CHARGE_ID  => l_freight_charge_tbl(i).freight_charge_id);

Line: 2594

    x_tax_detail_tbl(i).LAST_UPDATE_DATE := l_sysdate;

Line: 2595

	ASO_TAX_DETAILS_PKG.Insert_Row(
	    px_TAX_DETAIL_ID  => x_tax_detail_tbl(i).TAX_DETAIL_ID,
	    p_CREATION_DATE  => SYSDATE,
	    p_CREATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_DATE	=> l_sysdate,
	    p_LAST_UPDATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	    p_REQUEST_ID  => l_tax_detail_rec.REQUEST_ID,
	    p_PROGRAM_APPLICATION_ID  => l_tax_detail_rec.PROGRAM_APPLICATION_ID,
	    p_PROGRAM_ID  => l_tax_detail_rec.PROGRAM_ID,
	    p_PROGRAM_UPDATE_DATE  => l_tax_detail_rec.PROGRAM_UPDATE_DATE,
	    p_QUOTE_HEADER_ID  => l_qte_HEADER_ID,
	    p_QUOTE_LINE_ID  => NULL,
	    p_QUOTE_SHIPMENT_ID  => l_tax_detail_rec.quote_shipment_id,
	    p_ORIG_TAX_CODE  => l_tax_detail_rec.ORIG_TAX_CODE,
	    p_TAX_CODE	=> l_tax_detail_rec.TAX_CODE,
	    p_TAX_RATE	=> l_tax_detail_rec.TAX_RATE,
	    p_TAX_DATE	=> l_tax_detail_rec.TAX_DATE,
	    p_TAX_AMOUNT  => l_tax_detail_rec.TAX_AMOUNT,
	    p_TAX_EXEMPT_FLAG  => l_tax_detail_rec.TAX_EXEMPT_FLAG,
	    p_TAX_EXEMPT_NUMBER  => l_tax_detail_rec.TAX_EXEMPT_NUMBER,
	    p_TAX_EXEMPT_REASON_CODE  => l_tax_detail_rec.TAX_EXEMPT_REASON_CODE,
	    p_ATTRIBUTE_CATEGORY  => l_tax_detail_rec.ATTRIBUTE_CATEGORY,
	    p_ATTRIBUTE1  => l_tax_detail_rec.ATTRIBUTE1,
	    p_ATTRIBUTE2  => l_tax_detail_rec.ATTRIBUTE2,
	    p_ATTRIBUTE3  => l_tax_detail_rec.ATTRIBUTE3,
	    p_ATTRIBUTE4  => l_tax_detail_rec.ATTRIBUTE4,
	    p_ATTRIBUTE5  => l_tax_detail_rec.ATTRIBUTE5,
	    p_ATTRIBUTE6  => l_tax_detail_rec.ATTRIBUTE6,
	    p_ATTRIBUTE7  => l_tax_detail_rec.ATTRIBUTE7,
	    p_ATTRIBUTE8  => l_tax_detail_rec.ATTRIBUTE8,
	    p_ATTRIBUTE9  => l_tax_detail_rec.ATTRIBUTE9,
	    p_ATTRIBUTE10  => l_tax_detail_rec.ATTRIBUTE10,
	    p_ATTRIBUTE11  => l_tax_detail_rec.ATTRIBUTE11,
	    p_ATTRIBUTE12  => l_tax_detail_rec.ATTRIBUTE12,
	    p_ATTRIBUTE13  => l_tax_detail_rec.ATTRIBUTE13,
	    p_ATTRIBUTE14  => l_tax_detail_rec.ATTRIBUTE14,
	    p_ATTRIBUTE15  => l_tax_detail_rec.ATTRIBUTE15,
	     p_ATTRIBUTE16  =>  l_tax_detail_rec.ATTRIBUTE16,
          p_ATTRIBUTE17  =>  l_tax_detail_rec.ATTRIBUTE17,
          p_ATTRIBUTE18  =>  l_tax_detail_rec.ATTRIBUTE18,
          p_ATTRIBUTE19  =>  l_tax_detail_rec.ATTRIBUTE19,
          p_ATTRIBUTE20  =>  l_tax_detail_rec.ATTRIBUTE20,
	    p_TAX_INCLUSIVE_FLAG  => l_tax_detail_rec.TAX_INCLUSIVE_FLAG,
	    p_OBJECT_VERSION_NUMBER  => l_tax_detail_rec.OBJECT_VERSION_NUMBER,
	    p_TAX_RATE_ID => l_tax_detail_rec.TAX_RATE_ID
	    );

Line: 2643

      ELSIF P_Tax_Detail_Tbl(i).operation_code = 'UPDATE' THEN
      l_sysdate := sysdate;

Line: 2646

    x_tax_detail_tbl(i).LAST_UPDATE_DATE := l_sysdate;

Line: 2647

	ASO_TAX_DETAILS_PKG.update_Row(
	    p_TAX_DETAIL_ID  => l_tax_detail_rec.TAX_DETAIL_ID,
	    p_CREATION_DATE  => l_tax_detail_rec.creation_date,
	    p_CREATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_DATE	=> l_sysdate,
	    p_LAST_UPDATED_BY  => G_USER_ID,
	    p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	    p_REQUEST_ID  => l_tax_detail_rec.REQUEST_ID,
	    p_PROGRAM_APPLICATION_ID  => l_tax_detail_rec.PROGRAM_APPLICATION_ID,
	    p_PROGRAM_ID  => l_tax_detail_rec.PROGRAM_ID,
	    p_PROGRAM_UPDATE_DATE  => l_tax_detail_rec.PROGRAM_UPDATE_DATE,
	    p_QUOTE_HEADER_ID  => l_Qte_HEADER_ID,
	    p_QUOTE_LINE_ID  => NULL,
	    p_QUOTE_SHIPMENT_ID  => l_tax_detail_rec.quote_shipment_id,
	    p_ORIG_TAX_CODE  => l_tax_detail_rec.ORIG_TAX_CODE,
	    p_TAX_CODE	=> l_tax_detail_rec.TAX_CODE,
	    p_TAX_RATE	=> l_tax_detail_rec.TAX_RATE,
	    p_TAX_DATE	=> l_tax_detail_rec.TAX_DATE,
	    p_TAX_AMOUNT  => l_tax_detail_rec.TAX_AMOUNT,
	    p_TAX_EXEMPT_FLAG  => l_tax_detail_rec.TAX_EXEMPT_FLAG,
	    p_TAX_EXEMPT_NUMBER  => l_tax_detail_rec.TAX_EXEMPT_NUMBER,
	    p_TAX_EXEMPT_REASON_CODE  => l_tax_detail_rec.TAX_EXEMPT_REASON_CODE,
	    p_ATTRIBUTE_CATEGORY  => l_tax_detail_rec.ATTRIBUTE_CATEGORY,
	    p_ATTRIBUTE1  => l_tax_detail_rec.ATTRIBUTE1,
	    p_ATTRIBUTE2  => l_tax_detail_rec.ATTRIBUTE2,
	    p_ATTRIBUTE3  => l_tax_detail_rec.ATTRIBUTE3,
	    p_ATTRIBUTE4  => l_tax_detail_rec.ATTRIBUTE4,
	    p_ATTRIBUTE5  => l_tax_detail_rec.ATTRIBUTE5,
	    p_ATTRIBUTE6  => l_tax_detail_rec.ATTRIBUTE6,
	    p_ATTRIBUTE7  => l_tax_detail_rec.ATTRIBUTE7,
	    p_ATTRIBUTE8  => l_tax_detail_rec.ATTRIBUTE8,
	    p_ATTRIBUTE9  => l_tax_detail_rec.ATTRIBUTE9,
	    p_ATTRIBUTE10  => l_tax_detail_rec.ATTRIBUTE10,
	    p_ATTRIBUTE11  => l_tax_detail_rec.ATTRIBUTE11,
	    p_ATTRIBUTE12  => l_tax_detail_rec.ATTRIBUTE12,
	    p_ATTRIBUTE13  => l_tax_detail_rec.ATTRIBUTE13,
	    p_ATTRIBUTE14  => l_tax_detail_rec.ATTRIBUTE14,
	    p_ATTRIBUTE15  => l_tax_detail_rec.ATTRIBUTE15,
          p_ATTRIBUTE16  => l_tax_detail_rec.ATTRIBUTE16,
          p_ATTRIBUTE17  => l_tax_detail_rec.ATTRIBUTE17,
          p_ATTRIBUTE18  => l_tax_detail_rec.ATTRIBUTE18,
          p_ATTRIBUTE19  => l_tax_detail_rec.ATTRIBUTE19,
          p_ATTRIBUTE20  => l_tax_detail_rec.ATTRIBUTE20,
	    p_TAX_INCLUSIVE_FLAG  => l_tax_detail_rec.TAX_INCLUSIVE_FLAG,
	    p_OBJECT_VERSION_NUMBER  => l_tax_detail_rec.OBJECT_VERSION_NUMBER,
	    p_TAX_RATE_ID => l_tax_detail_rec.TAX_RATE_ID
	    );

Line: 2694

      ELSIF P_Tax_Detail_Tbl(i).operation_code = 'DELETE' THEN
	ASO_TAX_DETAILS_PKG.Delete_Row(
	    p_TAX_DETAIL_ID  => P_Tax_Detail_Tbl(i).TAX_DETAIL_ID);

Line: 2751

   ASO_PRICE_ATTRIBUTES_PKG.Insert_Row(
          px_PRICE_ATTRIBUTE_ID   => x_price_attributes_tbl(i).price_attribute_id,
          p_CREATION_DATE  	=> SYSDATE,
          p_CREATED_BY  	=> G_USER_ID,
          p_LAST_UPDATE_DATE  	=> SYSDATE,
          p_LAST_UPDATED_BY  	=> G_USER_ID,
          p_LAST_UPDATE_LOGIN  	=> G_LOGIN_ID,
          p_REQUEST_ID  	=> l_price_attributes_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => l_price_attributes_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  	=> l_price_attributes_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => l_price_attributes_rec.PROGRAM_UPDATE_DATE,
          p_QUOTE_HEADER_ID      => l_price_attributes_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID        => null,
          p_FLEX_TITLE           => l_price_attributes_rec.flex_title,
          p_PRICING_CONTEXT      => l_price_attributes_rec.pricing_context,
          p_PRICING_ATTRIBUTE1    => l_price_attributes_rec.PRICING_ATTRIBUTE1,
          p_PRICING_ATTRIBUTE2    => l_price_attributes_rec.PRICING_ATTRIBUTE2,
          p_PRICING_ATTRIBUTE3    => l_price_attributes_rec.PRICING_ATTRIBUTE3,
          p_PRICING_ATTRIBUTE4    => l_price_attributes_rec.PRICING_ATTRIBUTE4,
          p_PRICING_ATTRIBUTE5    => l_price_attributes_rec.PRICING_ATTRIBUTE5,
          p_PRICING_ATTRIBUTE6    => l_price_attributes_rec.PRICING_ATTRIBUTE6,
          p_PRICING_ATTRIBUTE7    => l_price_attributes_rec.PRICING_ATTRIBUTE7,
          p_PRICING_ATTRIBUTE8    => l_price_attributes_rec.PRICING_ATTRIBUTE8,
          p_PRICING_ATTRIBUTE9    => l_price_attributes_rec.PRICING_ATTRIBUTE9,
        p_PRICING_ATTRIBUTE10    => l_price_attributes_rec.PRICING_ATTRIBUTE10,
        p_PRICING_ATTRIBUTE11    => l_price_attributes_rec.PRICING_ATTRIBUTE11,
        p_PRICING_ATTRIBUTE12    => l_price_attributes_rec.PRICING_ATTRIBUTE12,
        p_PRICING_ATTRIBUTE13    => l_price_attributes_rec.PRICING_ATTRIBUTE13,
        p_PRICING_ATTRIBUTE14    => l_price_attributes_rec.PRICING_ATTRIBUTE14,
        p_PRICING_ATTRIBUTE15    => l_price_attributes_rec.PRICING_ATTRIBUTE15,
        p_PRICING_ATTRIBUTE16    => l_price_attributes_rec.PRICING_ATTRIBUTE16,
        p_PRICING_ATTRIBUTE17    => l_price_attributes_rec.PRICING_ATTRIBUTE17,
        p_PRICING_ATTRIBUTE18    => l_price_attributes_rec.PRICING_ATTRIBUTE18,
        p_PRICING_ATTRIBUTE19    => l_price_attributes_rec.PRICING_ATTRIBUTE19,
        p_PRICING_ATTRIBUTE20    => l_price_attributes_rec.PRICING_ATTRIBUTE20,
        p_PRICING_ATTRIBUTE21    => l_price_attributes_rec.PRICING_ATTRIBUTE21,
        p_PRICING_ATTRIBUTE22    => l_price_attributes_rec.PRICING_ATTRIBUTE22,
        p_PRICING_ATTRIBUTE23    => l_price_attributes_rec.PRICING_ATTRIBUTE23,
        p_PRICING_ATTRIBUTE24    => l_price_attributes_rec.PRICING_ATTRIBUTE24,
        p_PRICING_ATTRIBUTE25    => l_price_attributes_rec.PRICING_ATTRIBUTE25,
        p_PRICING_ATTRIBUTE26    => l_price_attributes_rec.PRICING_ATTRIBUTE26,
        p_PRICING_ATTRIBUTE27    => l_price_attributes_rec.PRICING_ATTRIBUTE27,
        p_PRICING_ATTRIBUTE28    => l_price_attributes_rec.PRICING_ATTRIBUTE28,
        p_PRICING_ATTRIBUTE29    => l_price_attributes_rec.PRICING_ATTRIBUTE29,
        p_PRICING_ATTRIBUTE30    => l_price_attributes_rec.PRICING_ATTRIBUTE30,
        p_PRICING_ATTRIBUTE31    => l_price_attributes_rec.PRICING_ATTRIBUTE31,
        p_PRICING_ATTRIBUTE32    => l_price_attributes_rec.PRICING_ATTRIBUTE32,
        p_PRICING_ATTRIBUTE33    => l_price_attributes_rec.PRICING_ATTRIBUTE33,
        p_PRICING_ATTRIBUTE34    => l_price_attributes_rec.PRICING_ATTRIBUTE34,
        p_PRICING_ATTRIBUTE35    => l_price_attributes_rec.PRICING_ATTRIBUTE35,
        p_PRICING_ATTRIBUTE36    => l_price_attributes_rec.PRICING_ATTRIBUTE36,
        p_PRICING_ATTRIBUTE37    => l_price_attributes_rec.PRICING_ATTRIBUTE37,
        p_PRICING_ATTRIBUTE38    => l_price_attributes_rec.PRICING_ATTRIBUTE38,
        p_PRICING_ATTRIBUTE39    => l_price_attributes_rec.PRICING_ATTRIBUTE39,
        p_PRICING_ATTRIBUTE40    => l_price_attributes_rec.PRICING_ATTRIBUTE40,
        p_PRICING_ATTRIBUTE41    => l_price_attributes_rec.PRICING_ATTRIBUTE41,
        p_PRICING_ATTRIBUTE42    => l_price_attributes_rec.PRICING_ATTRIBUTE42,
        p_PRICING_ATTRIBUTE43    => l_price_attributes_rec.PRICING_ATTRIBUTE43,
        p_PRICING_ATTRIBUTE44    => l_price_attributes_rec.PRICING_ATTRIBUTE44,
        p_PRICING_ATTRIBUTE45    => l_price_attributes_rec.PRICING_ATTRIBUTE45,
        p_PRICING_ATTRIBUTE46    => l_price_attributes_rec.PRICING_ATTRIBUTE46,
        p_PRICING_ATTRIBUTE47    => l_price_attributes_rec.PRICING_ATTRIBUTE47,
        p_PRICING_ATTRIBUTE48    => l_price_attributes_rec.PRICING_ATTRIBUTE48,
        p_PRICING_ATTRIBUTE49    => l_price_attributes_rec.PRICING_ATTRIBUTE49,
        p_PRICING_ATTRIBUTE50    => l_price_attributes_rec.PRICING_ATTRIBUTE50,
        p_PRICING_ATTRIBUTE51    => l_price_attributes_rec.PRICING_ATTRIBUTE51,
        p_PRICING_ATTRIBUTE52    => l_price_attributes_rec.PRICING_ATTRIBUTE52,
        p_PRICING_ATTRIBUTE53    => l_price_attributes_rec.PRICING_ATTRIBUTE53,
        p_PRICING_ATTRIBUTE54    => l_price_attributes_rec.PRICING_ATTRIBUTE54,
        p_PRICING_ATTRIBUTE55    => l_price_attributes_rec.PRICING_ATTRIBUTE55,
        p_PRICING_ATTRIBUTE56    => l_price_attributes_rec.PRICING_ATTRIBUTE56,
        p_PRICING_ATTRIBUTE57    => l_price_attributes_rec.PRICING_ATTRIBUTE57,
        p_PRICING_ATTRIBUTE58    => l_price_attributes_rec.PRICING_ATTRIBUTE58,
        p_PRICING_ATTRIBUTE59    => l_price_attributes_rec.PRICING_ATTRIBUTE59,
        p_PRICING_ATTRIBUTE60    => l_price_attributes_rec.PRICING_ATTRIBUTE60,
        p_PRICING_ATTRIBUTE61    => l_price_attributes_rec.PRICING_ATTRIBUTE61,
        p_PRICING_ATTRIBUTE62    => l_price_attributes_rec.PRICING_ATTRIBUTE62,
        p_PRICING_ATTRIBUTE63    => l_price_attributes_rec.PRICING_ATTRIBUTE63,
        p_PRICING_ATTRIBUTE64    => l_price_attributes_rec.PRICING_ATTRIBUTE64,
        p_PRICING_ATTRIBUTE65    => l_price_attributes_rec.PRICING_ATTRIBUTE65,
        p_PRICING_ATTRIBUTE66    => l_price_attributes_rec.PRICING_ATTRIBUTE66,
        p_PRICING_ATTRIBUTE67    => l_price_attributes_rec.PRICING_ATTRIBUTE67,
        p_PRICING_ATTRIBUTE68    => l_price_attributes_rec.PRICING_ATTRIBUTE68,
        p_PRICING_ATTRIBUTE69    => l_price_attributes_rec.PRICING_ATTRIBUTE69,
        p_PRICING_ATTRIBUTE70    => l_price_attributes_rec.PRICING_ATTRIBUTE70,
        p_PRICING_ATTRIBUTE71    => l_price_attributes_rec.PRICING_ATTRIBUTE71,
        p_PRICING_ATTRIBUTE72    => l_price_attributes_rec.PRICING_ATTRIBUTE72,
        p_PRICING_ATTRIBUTE73    => l_price_attributes_rec.PRICING_ATTRIBUTE73,
        p_PRICING_ATTRIBUTE74    => l_price_attributes_rec.PRICING_ATTRIBUTE74,
        p_PRICING_ATTRIBUTE75    => l_price_attributes_rec.PRICING_ATTRIBUTE75,
        p_PRICING_ATTRIBUTE76    => l_price_attributes_rec.PRICING_ATTRIBUTE76,
        p_PRICING_ATTRIBUTE77    => l_price_attributes_rec.PRICING_ATTRIBUTE77,
        p_PRICING_ATTRIBUTE78    => l_price_attributes_rec.PRICING_ATTRIBUTE78,
        p_PRICING_ATTRIBUTE79    => l_price_attributes_rec.PRICING_ATTRIBUTE79,
        p_PRICING_ATTRIBUTE80    => l_price_attributes_rec.PRICING_ATTRIBUTE80,
        p_PRICING_ATTRIBUTE81    => l_price_attributes_rec.PRICING_ATTRIBUTE81,
        p_PRICING_ATTRIBUTE82    => l_price_attributes_rec.PRICING_ATTRIBUTE82,
        p_PRICING_ATTRIBUTE83    => l_price_attributes_rec.PRICING_ATTRIBUTE83,
        p_PRICING_ATTRIBUTE84    => l_price_attributes_rec.PRICING_ATTRIBUTE84,
        p_PRICING_ATTRIBUTE85    => l_price_attributes_rec.PRICING_ATTRIBUTE85,
        p_PRICING_ATTRIBUTE86    => l_price_attributes_rec.PRICING_ATTRIBUTE86,
        p_PRICING_ATTRIBUTE87    => l_price_attributes_rec.PRICING_ATTRIBUTE87,
        p_PRICING_ATTRIBUTE88    => l_price_attributes_rec.PRICING_ATTRIBUTE88,
        p_PRICING_ATTRIBUTE89    => l_price_attributes_rec.PRICING_ATTRIBUTE89,
        p_PRICING_ATTRIBUTE90    => l_price_attributes_rec.PRICING_ATTRIBUTE90,
        p_PRICING_ATTRIBUTE91    => l_price_attributes_rec.PRICING_ATTRIBUTE91,
        p_PRICING_ATTRIBUTE92    => l_price_attributes_rec.PRICING_ATTRIBUTE92,
        p_PRICING_ATTRIBUTE93    => l_price_attributes_rec.PRICING_ATTRIBUTE93,
        p_PRICING_ATTRIBUTE94    => l_price_attributes_rec.PRICING_ATTRIBUTE94,
        p_PRICING_ATTRIBUTE95    => l_price_attributes_rec.PRICING_ATTRIBUTE95,
        p_PRICING_ATTRIBUTE96    => l_price_attributes_rec.PRICING_ATTRIBUTE96,
        p_PRICING_ATTRIBUTE97    => l_price_attributes_rec.PRICING_ATTRIBUTE97,
        p_PRICING_ATTRIBUTE98    => l_price_attributes_rec.PRICING_ATTRIBUTE98,
        p_PRICING_ATTRIBUTE99    => l_price_attributes_rec.PRICING_ATTRIBUTE99,
        p_PRICING_ATTRIBUTE100  => l_price_attributes_rec.PRICING_ATTRIBUTE100,
          p_CONTEXT    => l_price_attributes_rec.CONTEXT,
          p_ATTRIBUTE1    => l_price_attributes_rec.ATTRIBUTE1,
          p_ATTRIBUTE2    => l_price_attributes_rec.ATTRIBUTE2,
          p_ATTRIBUTE3    => l_price_attributes_rec.ATTRIBUTE3,
          p_ATTRIBUTE4    => l_price_attributes_rec.ATTRIBUTE4,
          p_ATTRIBUTE5    => l_price_attributes_rec.ATTRIBUTE5,
          p_ATTRIBUTE6    => l_price_attributes_rec.ATTRIBUTE6,
          p_ATTRIBUTE7    => l_price_attributes_rec.ATTRIBUTE7,
          p_ATTRIBUTE8    => l_price_attributes_rec.ATTRIBUTE8,
          p_ATTRIBUTE9    => l_price_attributes_rec.ATTRIBUTE9,
          p_ATTRIBUTE10    => l_price_attributes_rec.ATTRIBUTE10,
          p_ATTRIBUTE11    => l_price_attributes_rec.ATTRIBUTE11,
          p_ATTRIBUTE12    => l_price_attributes_rec.ATTRIBUTE12,
          p_ATTRIBUTE13    => l_price_attributes_rec.ATTRIBUTE13,
          p_ATTRIBUTE14    => l_price_attributes_rec.ATTRIBUTE14,
          p_ATTRIBUTE15    => l_price_attributes_rec.ATTRIBUTE15,
	     p_ATTRIBUTE16    => l_price_attributes_rec.ATTRIBUTE16,
          p_ATTRIBUTE17    => l_price_attributes_rec.ATTRIBUTE17,
          p_ATTRIBUTE18    => l_price_attributes_rec.ATTRIBUTE18,
          p_ATTRIBUTE19    => l_price_attributes_rec.ATTRIBUTE19,
          p_ATTRIBUTE20    => l_price_attributes_rec.ATTRIBUTE20,
	    p_OBJECT_VERSION_NUMBER  => l_price_attributes_rec.OBJECT_VERSION_NUMBER
);

Line: 2891

   ELSIF l_price_attributes_rec.operation_code = 'UPDATE' THEN

ASO_PRICE_ATTRIBUTES_PKG.Update_Row(
          p_PRICE_ATTRIBUTE_ID  => l_price_attributes_rec.price_attribute_id,
          p_CREATION_DATE  	=> l_price_attributes_rec.creation_date,
          p_CREATED_BY  	=> G_USER_ID,
          p_LAST_UPDATE_DATE  	=> SYSDATE,
          p_LAST_UPDATED_BY  	=> G_USER_ID,
          p_LAST_UPDATE_LOGIN  	=> G_LOGIN_ID,
          p_REQUEST_ID  	=> l_price_attributes_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => l_price_attributes_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  	 => l_price_attributes_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => l_price_attributes_rec.PROGRAM_UPDATE_DATE,
          p_QUOTE_HEADER_ID      => l_price_attributes_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID        => l_price_attributes_rec.quote_line_id,
          p_FLEX_TITLE           => l_price_attributes_rec.flex_title,
          p_PRICING_CONTEXT      => l_price_attributes_rec.pricing_context,
          p_PRICING_ATTRIBUTE1    => l_price_attributes_rec.PRICING_ATTRIBUTE1,
          p_PRICING_ATTRIBUTE2    => l_price_attributes_rec.PRICING_ATTRIBUTE2,
          p_PRICING_ATTRIBUTE3    => l_price_attributes_rec.PRICING_ATTRIBUTE3,
          p_PRICING_ATTRIBUTE4    => l_price_attributes_rec.PRICING_ATTRIBUTE4,
          p_PRICING_ATTRIBUTE5    => l_price_attributes_rec.PRICING_ATTRIBUTE5,
          p_PRICING_ATTRIBUTE6    => l_price_attributes_rec.PRICING_ATTRIBUTE6,
          p_PRICING_ATTRIBUTE7    => l_price_attributes_rec.PRICING_ATTRIBUTE7,
          p_PRICING_ATTRIBUTE8    => l_price_attributes_rec.PRICING_ATTRIBUTE8,
          p_PRICING_ATTRIBUTE9    => l_price_attributes_rec.PRICING_ATTRIBUTE9,
        p_PRICING_ATTRIBUTE10    => l_price_attributes_rec.PRICING_ATTRIBUTE10,
        p_PRICING_ATTRIBUTE11    => l_price_attributes_rec.PRICING_ATTRIBUTE11,
        p_PRICING_ATTRIBUTE12    => l_price_attributes_rec.PRICING_ATTRIBUTE12,
        p_PRICING_ATTRIBUTE13    => l_price_attributes_rec.PRICING_ATTRIBUTE13,
        p_PRICING_ATTRIBUTE14    => l_price_attributes_rec.PRICING_ATTRIBUTE14,
        p_PRICING_ATTRIBUTE15    => l_price_attributes_rec.PRICING_ATTRIBUTE15,
        p_PRICING_ATTRIBUTE16    => l_price_attributes_rec.PRICING_ATTRIBUTE16,
        p_PRICING_ATTRIBUTE17    => l_price_attributes_rec.PRICING_ATTRIBUTE17,
        p_PRICING_ATTRIBUTE18    => l_price_attributes_rec.PRICING_ATTRIBUTE18,
        p_PRICING_ATTRIBUTE19    => l_price_attributes_rec.PRICING_ATTRIBUTE19,
        p_PRICING_ATTRIBUTE20    => l_price_attributes_rec.PRICING_ATTRIBUTE20,
        p_PRICING_ATTRIBUTE21    => l_price_attributes_rec.PRICING_ATTRIBUTE21,
        p_PRICING_ATTRIBUTE22    => l_price_attributes_rec.PRICING_ATTRIBUTE22,
        p_PRICING_ATTRIBUTE23    => l_price_attributes_rec.PRICING_ATTRIBUTE23,
        p_PRICING_ATTRIBUTE24    => l_price_attributes_rec.PRICING_ATTRIBUTE24,
        p_PRICING_ATTRIBUTE25    => l_price_attributes_rec.PRICING_ATTRIBUTE25,
        p_PRICING_ATTRIBUTE26    => l_price_attributes_rec.PRICING_ATTRIBUTE26,
        p_PRICING_ATTRIBUTE27    => l_price_attributes_rec.PRICING_ATTRIBUTE27,
        p_PRICING_ATTRIBUTE28    => l_price_attributes_rec.PRICING_ATTRIBUTE28,
        p_PRICING_ATTRIBUTE29    => l_price_attributes_rec.PRICING_ATTRIBUTE29,
        p_PRICING_ATTRIBUTE30    => l_price_attributes_rec.PRICING_ATTRIBUTE30,
        p_PRICING_ATTRIBUTE31    => l_price_attributes_rec.PRICING_ATTRIBUTE31,
        p_PRICING_ATTRIBUTE32    => l_price_attributes_rec.PRICING_ATTRIBUTE32,
        p_PRICING_ATTRIBUTE33    => l_price_attributes_rec.PRICING_ATTRIBUTE33,
        p_PRICING_ATTRIBUTE34    => l_price_attributes_rec.PRICING_ATTRIBUTE34,
        p_PRICING_ATTRIBUTE35    => l_price_attributes_rec.PRICING_ATTRIBUTE35,
        p_PRICING_ATTRIBUTE36    => l_price_attributes_rec.PRICING_ATTRIBUTE36,
        p_PRICING_ATTRIBUTE37    => l_price_attributes_rec.PRICING_ATTRIBUTE37,
        p_PRICING_ATTRIBUTE38    => l_price_attributes_rec.PRICING_ATTRIBUTE38,
        p_PRICING_ATTRIBUTE39    => l_price_attributes_rec.PRICING_ATTRIBUTE39,
        p_PRICING_ATTRIBUTE40    => l_price_attributes_rec.PRICING_ATTRIBUTE40,
        p_PRICING_ATTRIBUTE41    => l_price_attributes_rec.PRICING_ATTRIBUTE41,
        p_PRICING_ATTRIBUTE42    => l_price_attributes_rec.PRICING_ATTRIBUTE42,
        p_PRICING_ATTRIBUTE43    => l_price_attributes_rec.PRICING_ATTRIBUTE43,
        p_PRICING_ATTRIBUTE44    => l_price_attributes_rec.PRICING_ATTRIBUTE44,
        p_PRICING_ATTRIBUTE45    => l_price_attributes_rec.PRICING_ATTRIBUTE45,
        p_PRICING_ATTRIBUTE46    => l_price_attributes_rec.PRICING_ATTRIBUTE46,
        p_PRICING_ATTRIBUTE47    => l_price_attributes_rec.PRICING_ATTRIBUTE47,
        p_PRICING_ATTRIBUTE48    => l_price_attributes_rec.PRICING_ATTRIBUTE48,
        p_PRICING_ATTRIBUTE49    => l_price_attributes_rec.PRICING_ATTRIBUTE49,
        p_PRICING_ATTRIBUTE50    => l_price_attributes_rec.PRICING_ATTRIBUTE50,
        p_PRICING_ATTRIBUTE51    => l_price_attributes_rec.PRICING_ATTRIBUTE51,
        p_PRICING_ATTRIBUTE52    => l_price_attributes_rec.PRICING_ATTRIBUTE52,
        p_PRICING_ATTRIBUTE53    => l_price_attributes_rec.PRICING_ATTRIBUTE53,
        p_PRICING_ATTRIBUTE54    => l_price_attributes_rec.PRICING_ATTRIBUTE54,
        p_PRICING_ATTRIBUTE55    => l_price_attributes_rec.PRICING_ATTRIBUTE55,
        p_PRICING_ATTRIBUTE56    => l_price_attributes_rec.PRICING_ATTRIBUTE56,
        p_PRICING_ATTRIBUTE57    => l_price_attributes_rec.PRICING_ATTRIBUTE57,
        p_PRICING_ATTRIBUTE58    => l_price_attributes_rec.PRICING_ATTRIBUTE58,
        p_PRICING_ATTRIBUTE59    => l_price_attributes_rec.PRICING_ATTRIBUTE59,
        p_PRICING_ATTRIBUTE60    => l_price_attributes_rec.PRICING_ATTRIBUTE60,
        p_PRICING_ATTRIBUTE61    => l_price_attributes_rec.PRICING_ATTRIBUTE61,
        p_PRICING_ATTRIBUTE62    => l_price_attributes_rec.PRICING_ATTRIBUTE62,
        p_PRICING_ATTRIBUTE63    => l_price_attributes_rec.PRICING_ATTRIBUTE63,
        p_PRICING_ATTRIBUTE64    => l_price_attributes_rec.PRICING_ATTRIBUTE64,
        p_PRICING_ATTRIBUTE65    => l_price_attributes_rec.PRICING_ATTRIBUTE65,
        p_PRICING_ATTRIBUTE66    => l_price_attributes_rec.PRICING_ATTRIBUTE66,
        p_PRICING_ATTRIBUTE67    => l_price_attributes_rec.PRICING_ATTRIBUTE67,
        p_PRICING_ATTRIBUTE68    => l_price_attributes_rec.PRICING_ATTRIBUTE68,
        p_PRICING_ATTRIBUTE69    => l_price_attributes_rec.PRICING_ATTRIBUTE69,
        p_PRICING_ATTRIBUTE70    => l_price_attributes_rec.PRICING_ATTRIBUTE70,
        p_PRICING_ATTRIBUTE71    => l_price_attributes_rec.PRICING_ATTRIBUTE71,
        p_PRICING_ATTRIBUTE72    => l_price_attributes_rec.PRICING_ATTRIBUTE72,
        p_PRICING_ATTRIBUTE73    => l_price_attributes_rec.PRICING_ATTRIBUTE73,
        p_PRICING_ATTRIBUTE74    => l_price_attributes_rec.PRICING_ATTRIBUTE74,
        p_PRICING_ATTRIBUTE75    => l_price_attributes_rec.PRICING_ATTRIBUTE75,
        p_PRICING_ATTRIBUTE76    => l_price_attributes_rec.PRICING_ATTRIBUTE76,
        p_PRICING_ATTRIBUTE77    => l_price_attributes_rec.PRICING_ATTRIBUTE77,
        p_PRICING_ATTRIBUTE78    => l_price_attributes_rec.PRICING_ATTRIBUTE78,
        p_PRICING_ATTRIBUTE79    => l_price_attributes_rec.PRICING_ATTRIBUTE79,
        p_PRICING_ATTRIBUTE80    => l_price_attributes_rec.PRICING_ATTRIBUTE80,
        p_PRICING_ATTRIBUTE81    => l_price_attributes_rec.PRICING_ATTRIBUTE81,
        p_PRICING_ATTRIBUTE82    => l_price_attributes_rec.PRICING_ATTRIBUTE82,
        p_PRICING_ATTRIBUTE83    => l_price_attributes_rec.PRICING_ATTRIBUTE83,
        p_PRICING_ATTRIBUTE84    => l_price_attributes_rec.PRICING_ATTRIBUTE84,
        p_PRICING_ATTRIBUTE85    => l_price_attributes_rec.PRICING_ATTRIBUTE85,
        p_PRICING_ATTRIBUTE86    => l_price_attributes_rec.PRICING_ATTRIBUTE86,
        p_PRICING_ATTRIBUTE87    => l_price_attributes_rec.PRICING_ATTRIBUTE87,
        p_PRICING_ATTRIBUTE88    => l_price_attributes_rec.PRICING_ATTRIBUTE88,
        p_PRICING_ATTRIBUTE89    => l_price_attributes_rec.PRICING_ATTRIBUTE89,
        p_PRICING_ATTRIBUTE90    => l_price_attributes_rec.PRICING_ATTRIBUTE90,
        p_PRICING_ATTRIBUTE91    => l_price_attributes_rec.PRICING_ATTRIBUTE91,
        p_PRICING_ATTRIBUTE92    => l_price_attributes_rec.PRICING_ATTRIBUTE92,
        p_PRICING_ATTRIBUTE93    => l_price_attributes_rec.PRICING_ATTRIBUTE93,
        p_PRICING_ATTRIBUTE94    => l_price_attributes_rec.PRICING_ATTRIBUTE94,
        p_PRICING_ATTRIBUTE95    => l_price_attributes_rec.PRICING_ATTRIBUTE95,
        p_PRICING_ATTRIBUTE96    => l_price_attributes_rec.PRICING_ATTRIBUTE96,
        p_PRICING_ATTRIBUTE97    => l_price_attributes_rec.PRICING_ATTRIBUTE97,
        p_PRICING_ATTRIBUTE98    => l_price_attributes_rec.PRICING_ATTRIBUTE98,
        p_PRICING_ATTRIBUTE99    => l_price_attributes_rec.PRICING_ATTRIBUTE99,
        p_PRICING_ATTRIBUTE100  => l_price_attributes_rec.PRICING_ATTRIBUTE100,
          p_CONTEXT    => l_price_attributes_rec.CONTEXT,
          p_ATTRIBUTE1    => l_price_attributes_rec.ATTRIBUTE1,
          p_ATTRIBUTE2    => l_price_attributes_rec.ATTRIBUTE2,
          p_ATTRIBUTE3    => l_price_attributes_rec.ATTRIBUTE3,
          p_ATTRIBUTE4    => l_price_attributes_rec.ATTRIBUTE4,
          p_ATTRIBUTE5    => l_price_attributes_rec.ATTRIBUTE5,
          p_ATTRIBUTE6    => l_price_attributes_rec.ATTRIBUTE6,
          p_ATTRIBUTE7    => l_price_attributes_rec.ATTRIBUTE7,
          p_ATTRIBUTE8    => l_price_attributes_rec.ATTRIBUTE8,
          p_ATTRIBUTE9    => l_price_attributes_rec.ATTRIBUTE9,
          p_ATTRIBUTE10    => l_price_attributes_rec.ATTRIBUTE10,
          p_ATTRIBUTE11    => l_price_attributes_rec.ATTRIBUTE11,
          p_ATTRIBUTE12    => l_price_attributes_rec.ATTRIBUTE12,
          p_ATTRIBUTE13    => l_price_attributes_rec.ATTRIBUTE13,
          p_ATTRIBUTE14    => l_price_attributes_rec.ATTRIBUTE14,
          p_ATTRIBUTE15    => l_price_attributes_rec.ATTRIBUTE15,
	     p_ATTRIBUTE16    => l_price_attributes_rec.ATTRIBUTE16,
          p_ATTRIBUTE17    => l_price_attributes_rec.ATTRIBUTE17,
          p_ATTRIBUTE18    => l_price_attributes_rec.ATTRIBUTE18,
          p_ATTRIBUTE19    => l_price_attributes_rec.ATTRIBUTE19,
          p_ATTRIBUTE20    => l_price_attributes_rec.ATTRIBUTE20,
	    p_OBJECT_VERSION_NUMBER  => l_price_attributes_rec.OBJECT_VERSION_NUMBER
);

Line: 3032

/* Commented the following code to call new api aso_pricing_int.delete_promotion 07/22/02

  ELSIF l_price_attributes_rec.operation_code = 'DELETE' THEN
  ASO_PRICE_ATTRIBUTES_PKG.Delete_Row(
       p_PRICE_ATTRIBUTE_ID   => l_price_attributes_rec.price_attribute_id);

Line: 3047

   aso_debug_pub.add('Update_Rows: p_Price_Attributes_Tbl.count: '||p_Price_Attributes_Tbl.count,1, 'N');

Line: 3048

   aso_debug_pub.add('Update_Rows: Before call to aso_pricing_int.Delete_Promotion',1, 'N');

Line: 3053

        aso_pricing_int.Delete_Promotion (
                           P_Api_Version_Number =>  1.0,
                           P_Init_Msg_List      =>  FND_API.G_FALSE,
                           P_Commit             =>  FND_API.G_FALSE,
                           p_price_attr_tbl     =>  p_Price_Attributes_Tbl,
                           x_return_status      =>  x_return_status,
                           x_msg_count          =>  x_msg_count,
                           x_msg_data           =>  x_msg_data
                                   );

Line: 3064

	   aso_debug_pub.add('Update_Rows: After call to Delete_Promotion: x_return_status: '||x_return_status,1, 'N');

Line: 3082

       ASO_SALES_CREDITS_PKG.Insert_Row(
          p_CREATION_DATE  => SYSDATE,
          p_CREATED_BY  => G_USER_ID,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
          p_REQUEST_ID  => l_sales_CREDIT_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => l_sales_CREDIT_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => l_sales_CREDIT_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => l_sales_CREDIT_rec.PROGRAM_UPDATE_DATE,
          px_SALES_CREDIT_ID  => x_SALES_CREDIT_tbl(i).SALES_CREDIT_ID,
          p_QUOTE_HEADER_ID  => l_sales_CREDIT_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID  => l_sales_CREDIT_rec.QUOTE_LINE_ID,
          p_PERCENT  => l_sales_CREDIT_rec.PERCENT,
          p_RESOURCE_ID  => l_sales_CREDIT_rec.RESOURCE_ID,
          p_RESOURCE_GROUP_ID  => l_sales_CREDIT_rec.RESOURCE_GROUP_ID,
          p_EMPLOYEE_PERSON_ID  => l_sales_CREDIT_rec.EMPLOYEE_PERSON_ID,
          p_SALES_CREDIT_TYPE_ID  => l_sales_CREDIT_rec.SALES_CREDIT_TYPE_ID,
--          p_SECURITY_GROUP_ID  => l_sales_CREDIT_rec.SECURITY_GROUP_ID,
          p_ATTRIBUTE_CATEGORY_CODE  => l_sales_CREDIT_rec.ATTRIBUTE_CATEGORY_CODE,
          p_ATTRIBUTE1  => l_sales_CREDIT_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => l_sales_CREDIT_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => l_sales_CREDIT_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => l_sales_CREDIT_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => l_sales_CREDIT_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => l_sales_CREDIT_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => l_sales_CREDIT_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => l_sales_CREDIT_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => l_sales_CREDIT_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => l_sales_CREDIT_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => l_sales_CREDIT_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => l_sales_CREDIT_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => l_sales_CREDIT_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => l_sales_CREDIT_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => l_sales_CREDIT_rec.ATTRIBUTE15,
          p_ATTRIBUTE16  => l_sales_CREDIT_rec.ATTRIBUTE16,
          p_ATTRIBUTE17  => l_sales_CREDIT_rec.ATTRIBUTE17,
          p_ATTRIBUTE18  => l_sales_CREDIT_rec.ATTRIBUTE18,
          p_ATTRIBUTE19  => l_sales_CREDIT_rec.ATTRIBUTE19,
          p_ATTRIBUTE20  => l_sales_CREDIT_rec.ATTRIBUTE20,
		p_SYSTEM_ASSIGNED_FLAG  => 'N',
          p_CREDIT_RULE_ID  => l_sales_CREDIT_rec.CREDIT_RULE_ID,
          p_OBJECT_VERSION_NUMBER  => l_sales_CREDIT_rec.OBJECT_VERSION_NUMBER);

Line: 3126

        ELSIF l_sales_credit_rec.operation_code = 'UPDATE' THEN
               ASO_SALES_CREDITS_PKG.Update_Row(
          p_CREATION_DATE  => l_sales_CREDIT_rec.creation_date,
          p_CREATED_BY  => G_USER_ID,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
          p_REQUEST_ID  => l_sales_CREDIT_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID=> l_sales_CREDIT_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => l_sales_CREDIT_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => l_sales_CREDIT_rec.PROGRAM_UPDATE_DATE,
          p_SALES_CREDIT_ID  => l_SALES_CREDIT_rec.SALES_CREDIT_ID,
          p_QUOTE_HEADER_ID  => l_sales_CREDIT_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID  => l_sales_CREDIT_rec.QUOTE_LINE_ID,
          p_PERCENT  => l_sales_CREDIT_rec.PERCENT,
          p_RESOURCE_ID  => l_sales_CREDIT_rec.RESOURCE_ID,
          p_RESOURCE_GROUP_ID  => l_sales_CREDIT_rec.RESOURCE_GROUP_ID,
          p_EMPLOYEE_PERSON_ID  => l_sales_CREDIT_rec.EMPLOYEE_PERSON_ID,
          p_SALES_CREDIT_TYPE_ID  => l_sales_CREDIT_rec.SALES_CREDIT_TYPE_ID,
--          p_SECURITY_GROUP_ID  => l_sales_CREDIT_rec.SECURITY_GROUP_ID,
          p_ATTRIBUTE_CATEGORY_CODE  => l_sales_CREDIT_rec.ATTRIBUTE_CATEGORY_CODE,
          p_ATTRIBUTE1  => l_sales_CREDIT_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => l_sales_CREDIT_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => l_sales_CREDIT_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => l_sales_CREDIT_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => l_sales_CREDIT_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => l_sales_CREDIT_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => l_sales_CREDIT_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => l_sales_CREDIT_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => l_sales_CREDIT_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => l_sales_CREDIT_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => l_sales_CREDIT_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => l_sales_CREDIT_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => l_sales_CREDIT_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => l_sales_CREDIT_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => l_sales_CREDIT_rec.ATTRIBUTE15,
          p_ATTRIBUTE16  => l_sales_CREDIT_rec.ATTRIBUTE16,
          p_ATTRIBUTE17  => l_sales_CREDIT_rec.ATTRIBUTE17,
          p_ATTRIBUTE18  => l_sales_CREDIT_rec.ATTRIBUTE18,
          p_ATTRIBUTE19  => l_sales_CREDIT_rec.ATTRIBUTE19,
          p_ATTRIBUTE20  => l_sales_CREDIT_rec.ATTRIBUTE20,
		p_SYSTEM_ASSIGNED_FLAG  => 'N',
          p_CREDIT_RULE_ID  => l_sales_CREDIT_rec.CREDIT_RULE_ID,
          p_OBJECT_VERSION_NUMBER  => l_sales_CREDIT_rec.OBJECT_VERSION_NUMBER);

Line: 3170

         ELSIF l_sales_credit_rec.operation_code = 'DELETE' THEN
                 ASO_SALES_CREDITS_PKG.Delete_Row(
          p_SALES_CREDIT_ID  => l_SALES_CREDIT_rec.SALES_CREDIT_ID);

Line: 3186

           ASO_QUOTE_PARTIES_PKG.Insert_Row(
          px_QUOTE_PARTY_ID  => x_quote_party_tbl(i).QUOTE_PARTY_ID,
          p_CREATION_DATE  => SYSDATE,
          p_CREATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_REQUEST_ID  => l_QUOTE_PARTY_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  =>l_QUOTE_PARTY_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => l_QUOTE_PARTY_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => l_QUOTE_PARTY_rec.PROGRAM_UPDATE_DATE,
          p_QUOTE_HEADER_ID  => l_QUOTE_PARTY_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID  => l_QUOTE_PARTY_rec.QUOTE_LINE_ID,
          p_QUOTE_SHIPMENT_ID  => l_QUOTE_PARTY_rec.QUOTE_SHIPMENT_ID,
          p_PARTY_TYPE  => l_QUOTE_PARTY_rec.PARTY_TYPE,
          p_PARTY_ID  => l_QUOTE_PARTY_rec.PARTY_ID,
          p_PARTY_OBJECT_TYPE  => l_QUOTE_PARTY_rec.PARTY_OBJECT_TYPE,
          p_PARTY_OBJECT_ID  => l_QUOTE_PARTY_rec.PARTY_OBJECT_ID,
          p_ATTRIBUTE_CATEGORY  => l_QUOTE_PARTY_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => l_QUOTE_PARTY_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => l_QUOTE_PARTY_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => l_QUOTE_PARTY_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => l_QUOTE_PARTY_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => l_QUOTE_PARTY_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => l_QUOTE_PARTY_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => l_QUOTE_PARTY_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => l_QUOTE_PARTY_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => l_QUOTE_PARTY_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => l_QUOTE_PARTY_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => l_QUOTE_PARTY_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => l_QUOTE_PARTY_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => l_QUOTE_PARTY_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => l_QUOTE_PARTY_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => l_QUOTE_PARTY_rec.ATTRIBUTE15,
  --          p_SECURITY_GROUP_ID  => p_QUOTE_PARTY_rec.SECURITY_GROUP_ID);

Line: 3223

        ELSIF  l_quote_party_rec.operation_code = 'UPDATE' THEN
            ASO_QUOTE_PARTIES_PKG.Update_Row(
          p_QUOTE_PARTY_ID  => l_quote_party_rec.QUOTE_PARTY_ID,
          p_CREATION_DATE  => l_quote_party_rec.creation_date,
          p_CREATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_REQUEST_ID  => l_QUOTE_PARTY_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  =>l_QUOTE_PARTY_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => l_QUOTE_PARTY_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => l_QUOTE_PARTY_rec.PROGRAM_UPDATE_DATE,
          p_QUOTE_HEADER_ID  => l_QUOTE_PARTY_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID  => l_QUOTE_PARTY_rec.QUOTE_LINE_ID,
          p_QUOTE_SHIPMENT_ID  => l_QUOTE_PARTY_rec.QUOTE_SHIPMENT_ID,
          p_PARTY_TYPE  => l_QUOTE_PARTY_rec.PARTY_TYPE,
          p_PARTY_ID  => l_QUOTE_PARTY_rec.PARTY_ID,
          p_PARTY_OBJECT_TYPE  => l_QUOTE_PARTY_rec.PARTY_OBJECT_TYPE,
          p_PARTY_OBJECT_ID  => l_QUOTE_PARTY_rec.PARTY_OBJECT_ID,
          p_ATTRIBUTE_CATEGORY  => l_QUOTE_PARTY_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => l_QUOTE_PARTY_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => l_QUOTE_PARTY_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => l_QUOTE_PARTY_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => l_QUOTE_PARTY_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => l_QUOTE_PARTY_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => l_QUOTE_PARTY_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => l_QUOTE_PARTY_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => l_QUOTE_PARTY_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => l_QUOTE_PARTY_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => l_QUOTE_PARTY_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => l_QUOTE_PARTY_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => l_QUOTE_PARTY_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => l_QUOTE_PARTY_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => l_QUOTE_PARTY_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => l_QUOTE_PARTY_rec.ATTRIBUTE15,
        p_OBJECT_VERSION_NUMBER  => l_QUOTE_PARTY_rec.OBJECT_VERSION_NUMBER);

Line: 3260

        ELSIF  l_quote_party_rec.operation_code = 'DELETE' THEN
            ASO_QUOTE_PARTIES_PKG.Delete_Row(
          p_QUOTE_PARTY_ID  => l_QUOTE_PARTY_rec.QUOTE_PARTY_ID);

Line: 3275

 ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Insert_Row(
          px_LINE_ATTRIBUTE_ID  => x_hd_Attr_Ext_Tbl(i).LINE_ATTRIBUTE_ID,
          p_CREATION_DATE          => SYSDATE,
          p_CREATED_BY             => G_USER_ID,
          p_LAST_UPDATE_DATE       => SYSDATE,
          p_LAST_UPDATED_BY        => G_USER_ID,
          p_LAST_UPDATE_LOGIN      => G_LOGIN_ID,
          p_REQUEST_ID             => l_LINE_ATTRIBS_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID =>l_LINE_ATTRIBS_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID             => l_LINE_ATTRIBS_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE    => l_LINE_ATTRIBS_rec.PROGRAM_UPDATE_DATE,
           p_APPLICATION_ID         => l_LINE_ATTRIBS_rec.APPLICATION_ID,
           p_STATUS                 => l_LINE_ATTRIBS_rec.STATUS,
          p_QUOTE_HEADER_ID          => l_LINE_ATTRIBS_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID          => l_LINE_ATTRIBS_rec.QUOTE_LINE_ID,
          p_QUOTE_SHIPMENT_ID          => l_LINE_ATTRIBS_rec.QUOTE_SHIPMENT_ID,
          p_ATTRIBUTE_TYPE_CODE    => l_LINE_ATTRIBS_rec.ATTRIBUTE_TYPE_CODE,
          p_NAME                   => l_LINE_ATTRIBS_rec.NAME,
          p_VALUE                  => l_LINE_ATTRIBS_rec.VALUE,
           p_VALUE_TYPE             => l_LINE_ATTRIBS_rec.VALUE_TYPE,
          p_START_DATE_ACTIVE      => l_LINE_ATTRIBS_rec.START_DATE_ACTIVE,
          p_END_DATE_ACTIVE        => l_LINE_ATTRIBS_rec.END_DATE_ACTIVE,
        p_OBJECT_VERSION_NUMBER  => l_LINE_ATTRIBS_rec.OBJECT_VERSION_NUMBER);

Line: 3299

      ELSIF l_line_attribs_rec.operation_code = 'UPDATE' THEN
      ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Update_Row(
          p_LINE_ATTRIBUTE_ID  => l_LINE_ATTRIBS_REC.LINE_ATTRIBUTE_ID,
          p_CREATION_DATE          => l_LINE_ATTRIBS_REC.creation_date,
          p_CREATED_BY             => G_USER_ID,
          p_LAST_UPDATE_DATE       => SYSDATE,
          p_LAST_UPDATED_BY        => G_USER_ID,
          p_LAST_UPDATE_LOGIN      => G_LOGIN_ID,
          p_REQUEST_ID             => l_LINE_ATTRIBS_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID =>l_LINE_ATTRIBS_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID             => l_LINE_ATTRIBS_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE    => l_LINE_ATTRIBS_rec.PROGRAM_UPDATE_DATE,
           p_APPLICATION_ID         => l_LINE_ATTRIBS_rec.APPLICATION_ID,
          p_STATUS                 => l_LINE_ATTRIBS_rec.STATUS,
          p_QUOTE_HEADER_ID        => l_LINE_ATTRIBS_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID          => l_LINE_ATTRIBS_rec.QUOTE_LINE_ID,
          p_QUOTE_SHIPMENT_ID      => l_LINE_ATTRIBS_rec.QUOTE_SHIPMENT_ID,
          p_ATTRIBUTE_TYPE_CODE    => l_LINE_ATTRIBS_rec.ATTRIBUTE_TYPE_CODE,
          p_NAME                   => l_LINE_ATTRIBS_rec.NAME,
          p_VALUE                  => l_LINE_ATTRIBS_rec.VALUE,
          p_VALUE_TYPE             => l_LINE_ATTRIBS_rec.VALUE_TYPE,
          p_START_DATE_ACTIVE      => l_LINE_ATTRIBS_rec.START_DATE_ACTIVE,
          p_END_DATE_ACTIVE        => l_LINE_ATTRIBS_rec.END_DATE_ACTIVE,
        p_OBJECT_VERSION_NUMBER  => l_LINE_ATTRIBS_rec.OBJECT_VERSION_NUMBER);

Line: 3324

     ELSIF l_line_attribs_rec.operation_code = 'DELETE' THEN
     ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.delete_Row(
          p_LINE_ATTRIB_ID  => l_LINE_ATTRIBS_rec.LINE_ATTRIBUTE_ID);

Line: 3332

           aso_debug_pub.add('Update_Rows: l_qte_access_tbl.count: '||l_qte_access_tbl.count, 1, 'Y');

Line: 3351

                    aso_debug_pub.add('Update_Rows: Before call to Add_Resource', 1, 'Y');

Line: 3365

                    aso_debug_pub.add('Update_Rows: After call to Add_Resource: x_return_status: '|| x_return_status, 1, 'Y');

Line: 3366

                    aso_debug_pub.add('Update_Rows: lx_Qte_Access_tbl.count: '|| lx_Qte_Access_tbl.count, 1, 'Y');

Line: 3373

		 elsif p_qte_access_tbl(i).operation_code = 'UPDATE' then

			 l_qte_access_tbl(1)                  := p_qte_access_tbl(i);

Line: 3379

                    aso_debug_pub.add('Update_Rows: Before call to Add_Resource to update access', 1, 'Y');

Line: 3393

                    aso_debug_pub.add('Update_Rows: After call to Add_Resource: x_return_status: '||x_return_status, 1, 'Y');

Line: 3394

                    aso_debug_pub.add('Update_Rows: lx_Qte_Access_tbl.count: '|| lx_Qte_Access_tbl.count, 1, 'Y');

Line: 3401

		 elsif p_qte_access_tbl(i).operation_code = 'DELETE' then

			 l_qte_access_tbl(1)                  := p_qte_access_tbl(i);

Line: 3407

                    aso_debug_pub.add('Update_Rows: Before call to Add_Resource', 1, 'Y');

Line: 3410

                ASO_SECURITY_INT.Delete_Resource(
                     P_INIT_MSG_LIST              => FND_API.G_FALSE,
                     P_COMMIT                     => FND_API.G_FALSE,
                     P_Qte_Access_tbl             => l_qte_access_tbl,
                     X_RETURN_STATUS              => x_return_status,
                     X_msg_count                  => X_msg_count,
                     X_msg_data                   => X_msg_data );

Line: 3419

                    aso_debug_pub.add('Update_Rows: After call to Add_Resource: x_return_status: '||x_return_status, 1, 'Y');

Line: 3428

END Update_Rows;

Line: 3442

PROCEDURE Update_Quote_Total ( P_Qte_Header_id             IN   NUMBER,
                               P_Calculate_Tax             IN   VARCHAR2,
                               P_Calculate_Freight_Charge  IN   VARCHAR2,
                               P_Control_Rec               IN   ASO_QUOTE_PUB.CONTROL_REC_TYPE
                                                                :=  ASO_QUOTE_PUB.G_MISS_CONTROL_REC,
                               P_Call_Ar_Api_Flag          IN   VARCHAR2 := FND_API.G_FALSE,
                               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

   CURSOR c_qte_sum IS
   SELECT quote_line_id, line_category_code, nvl(line_list_price * quantity, 0) total_list_price,
          nvl(line_adjusted_amount * quantity,
              nvl(line_adjusted_percent * line_list_price * quantity, 0)) ln_total_discount
   FROM   ASO_QUOTE_LINES_ALL
   WHERE  quote_header_id = p_qte_header_id
   and    charge_periodicity_code is null; -- Recurring charges Change

Line: 3464

   SELECT nvl(sum(decode(tax_inclusive_flag, 'Y', 0,nvl(tax_amount,0))),0) tax_amt_for_qte_total,
		nvl(sum(nvl(tax_amount, 0)),0) tax_amount
   FROM   ASO_TAX_DETAILS
   WHERE  quote_header_id              =   p_qte_header_id
   and    quote_line_id                =   p_quote_line_id;

Line: 3471

   SELECT nvl(sum(nvl(tax_amount, 0)),0)
   FROM   ASO_TAX_DETAILS
   WHERE  quote_header_id = p_qte_header_id
   and    quote_line_id is null;

Line: 3477

   select count(tax_detail_id)
   from aso_tax_details
   where quote_header_id = p_qte_header_id
   and tax_amount is not null;

Line: 3484

   SELECT total_shipping_charge
   FROM   aso_quote_headers_all
   WHERE  quote_header_id = p_qte_header_id;

Line: 3490

   SELECT	total_adjusted_percent
   FROM   aso_quote_headers_all
   WHERE  quote_header_id = p_qte_header_id;

Line: 3496

  SELECT payment_term_id
  FROM aso_payments
  WHERE  quote_header_id = p_qte_header_id
  and    quote_line_id is null;

Line: 3502

  SELECT currency_code
  FROM aso_quote_headers_all
  WHERE  quote_header_id = p_qte_header_id;

Line: 3507

  Select org_id,quote_type
  from aso_quote_headers_all
  where quote_header_id = p_qte_header_id;

Line: 3512

  select sum(payment_amount)
  from aso_payments
  where quote_header_id = l_qte_hdr_id
  and quote_line_id is not null;

Line: 3548

	    aso_debug_pub.add('Begin update_quote_total procedure.', 1, 'Y');

Line: 3549

         aso_debug_pub.add('Update_quote_total: Input parameters value.');

Line: 3550

         aso_debug_pub.add('Update_quote_total: p_qte_header_id:            '|| p_qte_header_id);

Line: 3551

         aso_debug_pub.add('Update_quote_total: p_calculate_tax:            '|| p_calculate_tax);

Line: 3552

         aso_debug_pub.add('Update_quote_total: p_calculate_freight_charge: '|| p_calculate_freight_charge);

Line: 3562

	        aso_debug_pub.add('Update_quote_total: l_total_quote_price:        '|| l_total_quote_price);

Line: 3572

		        aso_debug_pub.add('Update_quote_total: l_total_list_price:  '|| l_total_list_price);

Line: 3573

                  aso_debug_pub.add('Update_quote_total: l_ln_total_discount: '|| l_ln_total_discount);

Line: 3584

		        aso_debug_pub.add('Update_quote_total: l_total_tax (-): '|| l_total_tax);

Line: 3593

			        aso_debug_pub.add('Update_quote_total: After call to get_line_freight_charges');

Line: 3611

		        aso_debug_pub.add('Update_quote_total: l_total_list_price:  '|| l_total_list_price);

Line: 3612

                  aso_debug_pub.add('Update_quote_total: l_ln_total_discount: '|| l_ln_total_discount);

Line: 3623

		        aso_debug_pub.add('Update_quote_total: l_total_tax (+): '|| l_total_tax);

Line: 3632

			        aso_debug_pub.add('Update_quote_total: After call to get_line_freight_charges');

Line: 3655

	    aso_debug_pub.add('Update_quote_total: l_header_tax: '|| l_header_tax);

Line: 3656

         aso_debug_pub.add('Update_Quote_Total: p_control_rec.price_mode: '|| p_control_rec.price_mode);

Line: 3671

             aso_debug_pub.add('Update_quote_total: l_count: '|| l_count);

Line: 3691

	    aso_debug_pub.add('Update_quote_total: l_total_tax:               '|| l_total_tax);

Line: 3692

	    aso_debug_pub.add('Update_quote_total: l_total_tax_for_qte_total: '|| l_total_tax_for_qte_total);

Line: 3701

	        aso_debug_pub.add('Update_quote_total: l_header_shipping_charge: '|| l_header_shipping_charge);

Line: 3707

	        aso_debug_pub.add('Update_quote_total: l_total_shipping_charge:  '|| l_total_shipping_charge);

Line: 3717

	        aso_debug_pub.add('Update_quote_total: l_total_shipping_charge:  '|| l_total_shipping_charge);

Line: 3727

	    aso_debug_pub.add('Update_quote_total: l_total_quote_price: '|| l_total_quote_price);

Line: 3759

          aso_debug_pub.add('Update_Quote_Total - Value of Installment Option Param: '||l_installment_option, 1, 'Y');

Line: 3781

          aso_debug_pub.add('Update_Quote_Total- Input to AR_VIEW_TERM_GRP.pay_now_amounts follows:  ', 1, 'Y');

Line: 3782

          aso_debug_pub.add('Update_Quote_Total- l_header_shipping_charge:    '||l_header_shipping_charge, 1, 'Y');

Line: 3783

          aso_debug_pub.add('Update_Quote_Total- l_hdr_currency_code:         '||l_hdr_currency_code, 1, 'Y');

Line: 3784

          aso_debug_pub.add('Update_Quote_Total- l_hdr_term_id:               '||l_hdr_term_id, 1, 'Y');

Line: 3785

		aso_debug_pub.add('Update_Quote_Total- P_Call_Ar_Api_Flag:          '||P_Call_Ar_Api_Flag,1,'Y');

Line: 3791

          aso_debug_pub.add('Update_Quote_Total: before call to AR_VIEW_TERM_GRP.pay_now_amounts', 1, 'Y');

Line: 3813

              aso_debug_pub.add('Update_Quote_Total: After call to AR_VIEW_TERM_GRP.pay_now_amounts: x_return_status: '
                                 || x_return_status, 1, 'Y');

Line: 3834

          aso_debug_pub.add('Update_Quote_Total- Output from AR_VIEW_TERM_GRP.pay_now_amounts follows: ', 1, 'Y');

Line: 3835

          aso_debug_pub.add('Update_Quote_Total- l_paynow_amount:     '||l_paynow_amount, 1, 'Y');

Line: 3836

          aso_debug_pub.add('Update_Quote_Total- l_paynow_charges:    '||l_paynow_charges, 1, 'Y');

Line: 3837

          aso_debug_pub.add('Update_Quote_Total- l_paynow_tax:        '||l_paynow_tax, 1, 'Y');

Line: 3838

          aso_debug_pub.add('Update_Quote_Total- l_paynow_total:      '||l_paynow_total, 1, 'Y');

Line: 3844

		/*update aso_quote_headers_all
          set header_paynow_charges    = l_paynow_charges,
              last_updated_by        =  fnd_global.user_id,
              last_update_login      =  fnd_global.conc_login_id
          where quote_header_id = P_Qte_Header_id; */

Line: 3857

     UPDATE ASO_QUOTE_HEADERS_ALL
     SET total_list_price       =  l_total_list_price,
         total_shipping_charge  =  l_total_shipping_charge,
         total_adjusted_amount  =  l_ln_total_discount,
         total_adjusted_percent =  decode( l_total_list_price, 0, NULL,
                                          (l_ln_total_discount/l_total_list_price) * 100 ),
         total_quote_price      =  l_total_quote_price,
         total_tax              =  l_total_tax,
	    header_paynow_charges  =  nvl(l_paynow_charges,header_paynow_charges),
         last_update_date       =  sysdate,
         last_updated_by        =  fnd_global.user_id,
         last_update_login      =  fnd_global.conc_login_id
     WHERE quote_header_id = p_qte_header_id;

Line: 3878

	    aso_debug_pub.add('Update_quote_total: l_total_quote_price: '|| l_total_quote_price);

Line: 3879

	    aso_debug_pub.add('End of Update_quote_total');

Line: 3882

END Update_Quote_Total;

Line: 4008

l_price_updated_date_flag  VARCHAR2(1) := fnd_api.g_false;

Line: 4010

cursor c_last_update_date( p_qte_hdr_id  number ) is
select last_update_date
from aso_quote_headers_all
where quote_header_id = p_qte_hdr_id;

Line: 4017

SELECT 'Y'
FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B
WHERE A.Quote_Header_Id = l_qte_hdr
AND A.Quote_Status_Id = B.Quote_Status_Id
AND B.Status_Code = 'STORE DRAFT';

Line: 4024

 SELECT Sales_Credit_Type_Id
 FROM OE_SALES_CREDIT_TYPES
 WHERE Quota_Flag = 'Y';

Line: 4029

Select object_id
from aso_quote_related_objects
where quote_object_id = p_qte_header_id
and quote_object_type_code = 'HEADER'
and relationship_type_code = 'OPP_QUOTE';

Line: 4036

select nvl(sum(nvl(tax_amount, 0)),0) tax_amount
FROM   ASO_TAX_DETAILS
WHERE  quote_header_id              =   p_qte_header_id
and    quote_line_id                =   p_quote_line_id;

Line: 4042

SELECT payment_term_id
FROM aso_payments
WHERE  quote_header_id              =   p_qte_header_id
and    quote_line_id                =   p_quote_line_id;

Line: 4048

SELECT payment_term_id
FROM aso_payments
WHERE  quote_header_id              =   p_qte_header_id
and    quote_line_id                IS NULL ;

Line: 4054

select line_quote_price,quantity
from   aso_quote_lines_all
where  quote_line_id = p_quote_line_id;

Line: 4059

select  master_organization_id
from    oe_system_parameters
where   org_id = l_main_org_id;

Line: 4480

                if (p_hd_sales_credit_tbl(i).operation_code = 'CREATE' or p_hd_sales_credit_tbl(i).operation_code = 'UPDATE') then

                    ASO_VALIDATE_PVT.Validate_Resource_id(
                              p_init_msg_list => FND_API.G_FALSE,
                              p_resource_id	 => p_hd_sales_credit_tbl(i).resource_id  ,
                              x_return_status => x_return_status,
                              x_msg_count     => x_msg_count,
                              x_msg_data      => x_msg_data);

Line: 5011

          aso_debug_pub.add('Create_Quote: Before call to insert_rows', 1, 'Y');

Line: 5014

      Insert_Rows (
			p_qte_header_rec        => l_qte_header_rec,
			p_Price_Attributes_Tbl  => p_hd_price_attributes_tbl,
			P_Price_Adjustment_Tbl  => l_price_adj_tbl,
			P_Price_Adj_Attr_Tbl    => l_price_adj_attr_tbl,
			P_Payment_Tbl	         => l_hd_payment_tbl,
			P_Shipment_tbl	         => l_hd_shipment_tbl,
			P_Freight_Charge_Tbl    => p_hd_freight_charge_tbl,
			P_Tax_Detail_Tbl        => l_hd_tax_detail_tbl,
               P_hd_Attr_Ext_Tbl       => P_hd_Attr_Ext_Tbl,
               P_sales_credit_tbl      => p_hd_sales_credit_tbl,
               P_quote_party_tbl       => p_hd_quote_party_tbl,
               P_Qte_Access_Tbl        => P_Qte_Access_Tbl,
			x_qte_header_rec        => x_qte_header_rec,
			x_Price_Attributes_Tbl  => x_hd_price_attributes_tbl,
			x_Price_Adjustment_Tbl  => l_price_adj_tbl_out,
			x_Price_Adj_Attr_Tbl    => l_price_adj_attr_tbl_out,
			x_Payment_Tbl           => x_hd_payment_tbl,
			x_Shipment_rec	         => x_hd_shipment_rec,
			x_Freight_Charge_Tbl    => x_hd_freight_charge_tbl,
			x_Tax_Detail_Tbl        => x_hd_tax_detail_tbl,
               x_hd_Attr_Ext_Tbl       => x_hd_Attr_Ext_Tbl,
               x_sales_credit_tbl      => x_hd_sales_credit_tbl,
               x_quote_party_tbl       => x_hd_quote_party_tbl,
               x_Qte_Access_Tbl        => x_Qte_Access_Tbl,
			X_Return_Status 	    => l_return_status,
			X_Msg_Count		    => x_msg_count,
			X_Msg_Data		    => x_msg_data);

Line: 5044

          aso_debug_pub.add('Create_Quote: After call to Insert_Rows: x_return_status: '||x_return_status, 1, 'N');

Line: 5075

                   p_update_flag        => 'N',
                   p_template_id_tbl    => l_template_tbl,
                   p_qte_header_rec     => x_qte_header_rec,
                   p_control_rec        => p_control_rec,
                   x_qte_line_tbl       => lx_qte_line_tbl,
                   x_qte_line_dtl_tbl   => x_qte_line_dtl_tbl,
                   x_return_status      => x_return_status,
                   x_msg_count          => x_msg_count,
                   x_msg_data           => x_msg_data
                   );

Line: 5280

	         open  c_last_update_date(x_qte_header_rec.quote_header_id);

Line: 5281

	         fetch c_last_update_date into x_qte_header_rec.last_update_date;

Line: 5282

	         close c_last_update_date;

Line: 5284

              l_control_rec.last_update_date  :=  x_qte_header_rec.last_update_date;

Line: 5288

                  aso_debug_pub.add('x_qte_header_rec.last_update_date: '|| x_qte_header_rec.last_update_date);

Line: 5289

                  aso_debug_pub.add('l_control_rec.last_update_date:    '|| l_control_rec.last_update_date);

Line: 5314

              ASO_SALES_CREDITS_PKG.Insert_Row(
                              p_CREATION_DATE            => SYSDATE,
                              p_CREATED_BY               => G_USER_ID,
                              p_LAST_UPDATED_BY          => G_USER_ID,
                              p_LAST_UPDATE_DATE         => SYSDATE,
                              p_LAST_UPDATE_LOGIN        => G_LOGIN_ID,
                              p_REQUEST_ID               => FND_API.G_MISS_NUM,
                              p_PROGRAM_APPLICATION_ID   => FND_API.G_MISS_NUM,
                              p_PROGRAM_ID               => FND_API.G_MISS_NUM,
                              p_PROGRAM_UPDATE_DATE      => FND_API.G_MISS_DATE,
                              px_SALES_CREDIT_ID         => x_hd_sales_credit_tbl(1).Sales_Credit_Id,
                              p_QUOTE_HEADER_ID          => lx_qte_header_rec.QUOTE_HEADER_ID,
                              p_QUOTE_LINE_ID            => FND_API.G_MISS_NUM,
                              p_PERCENT                  => 100,
                              p_RESOURCE_ID              => lx_qte_header_rec.RESOURCE_ID,
                              p_RESOURCE_GROUP_ID        => lx_qte_header_rec.RESOURCE_GRP_ID,
                              p_EMPLOYEE_PERSON_ID       => FND_API.G_MISS_NUM,
                              p_SALES_CREDIT_TYPE_ID     => l_quota_id,
                              p_ATTRIBUTE_CATEGORY_CODE  => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE1               => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE2               => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE3               => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE4               => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE5               => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE6               => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE7               => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE8               => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE9               => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE10              => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE11              => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE12              => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE13              => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE14              => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE15              => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE16              => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE17              => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE18              => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE19              => FND_API.G_MISS_CHAR,
                              p_ATTRIBUTE20              => FND_API.G_MISS_CHAR,
                              p_SYSTEM_ASSIGNED_FLAG     => 'N',
                              p_CREDIT_RULE_ID           => FND_API.G_MISS_NUM,
                              p_OBJECT_VERSION_NUMBER    => FND_API.G_MISS_NUM );

Line: 5358

                  aso_debug_pub.add('Create_Quote: After call to Insert_Row Sales_Credit_Id: '|| x_hd_sales_credit_tbl(1).Sales_Credit_Id);

Line: 5489

               FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER INSERT ROW', TRUE);

Line: 5720

          open  c_last_update_date(x_qte_header_rec.quote_header_id);

Line: 5721

          fetch c_last_update_date into l_control_rec.last_update_date;

Line: 5722

          close c_last_update_date;

Line: 5725

              aso_debug_pub.add('l_control_rec.last_update_date: '|| l_control_rec.last_update_date);

Line: 5733

                          p_update_header_flag   => FND_API.G_FALSE,
                          p_qte_header_rec       => p_qte_header_rec,
                          P_qte_Line_Rec	    => l_qte_line_rec,
                          P_qte_line_dtl_tbl     => l_qte_line_dtl_tbl,
                          P_Line_Attribs_Ext_Tbl => l_line_attr_Ext_Tbl,
                          P_price_attributes_tbl => l_price_attr_tbl,
                          P_Price_Adj_Tbl        => l_price_adj_tbl,
                          P_Price_Adj_Attr_Tbl   => l_Price_Adj_Attr_Tbl,
                          P_Payment_Tbl          => l_payment_tbl,
                          P_Shipment_Tbl         => l_ln_shipment_tbl,
                          P_Freight_Charge_Tbl   => l_freight_charge_tbl,
                          P_Tax_Detail_Tbl       => l_tax_detail_tbl,
                          P_quote_party_tbl      => l_quote_party_tbl ,
                          P_sales_Credit_tbl     => l_sales_Credit_tbl ,
                          x_qte_Line_Rec	    => l_qte_line_rec_out,
                          x_qte_line_dtl_tbl     => l_qte_line_dtl_tbl_out,
                          x_Line_Attribs_Ext_Tbl => l_line_attr_Ext_Tbl_out,
                          x_price_attributes_tbl => l_price_attr_tbl_out,
                          x_Price_Adj_Tbl        => l_price_adj_tbl_out,
                          x_Price_Adj_Attr_Tbl   => l_Price_Adj_Attr_Tbl_out,
                          x_Payment_Tbl          => l_payment_tbl_out,
                          x_Shipment_Tbl	    => l_ln_shipment_tbl_out,
                          x_Freight_Charge_Tbl   => l_freight_charge_tbl_out,
                          x_Tax_Detail_Tbl       => l_tax_detail_tbl_out,
                          X_quote_party_tbl      => l_quote_party_tbl_out ,
                          X_sales_Credit_tbl     => l_sales_Credit_tbl_out ,
                          X_Return_Status        => l_return_status,
                          X_Msg_Count            => x_msg_count,
                          X_Msg_Data             => x_msg_data );

Line: 5796

          open  c_last_update_date(x_qte_header_rec.quote_header_id);

Line: 5797

          fetch c_last_update_date into x_qte_header_rec.last_update_date;

Line: 5798

          close c_last_update_date;

Line: 5800

          l_control_rec.last_update_date  :=  x_qte_header_rec.last_update_date;

Line: 5804

              aso_debug_pub.add('x_qte_header_rec.last_update_date: '|| x_qte_header_rec.last_update_date);

Line: 5805

              aso_debug_pub.add('l_control_rec.last_update_date:    '|| l_control_rec.last_update_date);

Line: 5926

           ASO_PRICE_RLTSHIPS_PKG.Insert_Row(
                        px_ADJ_RELATIONSHIP_ID   => l_price_adj_rltship_rec.ADJ_RELATIONSHIP_ID,
                        p_creation_date          => sysdate,
                        p_CREATED_BY             => G_USER_ID,
                        p_LAST_UPDATE_DATE       => sysdate,
                        p_LAST_UPDATED_BY        => G_USER_ID,
                        p_LAST_UPDATE_LOGIN      => G_USER_ID,
                        p_PROGRAM_APPLICATION_ID => l_price_adj_rltship_rec.PROGRAM_APPLICATION_ID,
                        p_PROGRAM_ID             => l_price_adj_rltship_rec.PROGRAM_ID,
                        p_PROGRAM_UPDATE_DATE    => l_price_adj_rltship_rec.PROGRAM_UPDATE_DATE,
                        p_REQUEST_ID             => l_price_adj_rltship_rec.REQUEST_ID,
                        p_QUOTE_LINE_ID          => l_price_adj_rltship_rec.quote_line_id,
                        p_PRICE_ADJUSTMENT_ID    => l_price_adj_rltship_rec.price_adjustment_id,
                        p_RLTD_PRICE_ADJ_ID      => l_price_adj_rltship_rec.rltd_price_adj_id,
                        p_QUOTE_SHIPMENT_ID      => l_price_adj_rltship_rec.quote_shipment_id,
                        p_OBJECT_VERSION_NUMBER  => l_price_adj_rltship_rec.OBJECT_VERSION_NUMBER );

Line: 5963

           ASO_LINE_RELATIONSHIPS_PKG.Insert_Row(
                        px_LINE_RELATIONSHIP_ID   => l_line_rltship_rec.LINE_RELATIONSHIP_ID,
                        p_CREATION_DATE           => SYSDATE,
                        p_CREATED_BY              => G_USER_ID,
                        p_LAST_UPDATED_BY         => G_USER_ID,
                        p_LAST_UPDATE_DATE        => SYSDATE,
                        p_LAST_UPDATE_LOGIN       => G_LOGIN_ID,
                        p_REQUEST_ID              => l_line_rltship_rec.REQUEST_ID,
                        p_PROGRAM_APPLICATION_ID  => l_line_rltship_rec.PROGRAM_APPLICATION_ID,
                        p_PROGRAM_ID              => l_line_rltship_rec.PROGRAM_ID,
                        p_PROGRAM_UPDATE_DATE     => l_line_rltship_rec.PROGRAM_UPDATE_DATE,
                        p_QUOTE_LINE_ID           => l_line_rltship_rec.quote_line_id,
                        p_RELATED_QUOTE_LINE_ID   => l_line_rltship_rec.RELATED_QUOTE_LINE_ID,
                        p_RECIPROCAL_FLAG         => l_line_rltship_rec.RECIPROCAL_FLAG,
                        P_RELATIONSHIP_TYPE_CODE  => l_line_rltship_rec.RELATIONSHIP_TYPE_CODE,
                        p_OBJECT_VERSION_NUMBER   => l_price_adj_rltship_rec.OBJECT_VERSION_NUMBER);

Line: 5989

               update aso_quote_line_details
               set ref_type_code          =  'CONFIG',
                   ref_line_id            =  l_line_rltship_rec.quote_line_id,
                   last_update_date       =  sysdate,
                   last_updated_by        =  fnd_global.user_id,
                   last_update_login      =  fnd_global.conc_login_id
               where quote_line_id = l_line_rltship_rec.related_quote_line_id;

Line: 6005

      update aso_quote_line_details
      set ref_type_code     = 'CONFIG',
          last_update_date  = sysdate,
          last_updated_by   = fnd_global.user_id,
          last_update_login = fnd_global.conc_login_id
      where config_header_id is not null
      and config_revision_num is not null
      and ref_type_code is null
      and quote_line_id in (select quote_line_id from aso_quote_lines_all
                            where item_type_code = 'MDL'
                            and quote_header_id  = x_qte_header_rec.quote_header_id);

Line: 6100

      /*New Pricing Changes to update the date*/

	 IF p_control_rec.header_pricing_event ='BATCH' AND p_control_rec.price_mode='ENTIRE_QUOTE' THEN

	 	l_price_updated_date_flag := fnd_api.g_true;

Line: 6122

          l_tax_control_rec.update_DB := 'Y';*/

Line: 6172

      /*New Tax Changes to update the date*/

	 IF aso_debug_pub.g_debug_flag = 'Y' THEN

		aso_debug_pub.add('Create_Quote: control record parameter values');

Line: 6182

	     aso_debug_pub.add('l_price_updated_date_flag:                 ' || l_price_updated_date_flag);

Line: 6188

          IF l_price_updated_date_flag = fnd_api.g_true THEN

              update aso_quote_headers_all
              set tax_updated_date   = sysdate,
                  price_updated_date = sysdate
              where quote_header_id = x_qte_header_rec.quote_header_id;

Line: 6197

              update aso_quote_headers_all
              set tax_updated_date   = sysdate
              where quote_header_id = x_qte_header_rec.quote_header_id;

Line: 6203

      ELSIF l_price_updated_date_flag = fnd_api.g_true THEN

          update aso_quote_headers_all
          set price_updated_date = sysdate
          where quote_header_id = x_qte_header_rec.quote_header_id;

Line: 6260

                   if (l_qte_line_tbl(i).operation_code = 'CREATE' or l_qte_line_tbl(i).operation_code = 'UPDATE')  then
                    l_call_ar_api :=  fnd_api.g_true;

Line: 6382

          update aso_quote_lines_all
          set line_paynow_charges    = l_paynow_charges,
              line_paynow_tax        = l_paynow_tax,
              line_paynow_subtotal   = l_paynow_amount,
              last_update_date       =  sysdate,
              last_updated_by        =  fnd_global.user_id,
              last_update_login      =  fnd_global.conc_login_id
          where quote_line_id = X_Qte_Line_Tbl(i).quote_line_id;

Line: 6399

          aso_debug_pub.add('Create_Quote - before update_quote_total ', 1, 'Y');

Line: 6403

      Update_Quote_Total ( P_Qte_Header_id            => x_Qte_Header_rec.quote_header_id,
			            P_Calculate_Tax            => p_control_rec.calculate_tax_flag,
			            P_calculate_Freight_Charge => p_control_rec.calculate_freight_charge_flag,
                           p_control_rec              => p_control_rec,
			            P_Call_Ar_Api_Flag         => l_call_ar_api,
					  X_Return_Status            => x_return_status,
			            X_Msg_Count                => x_msg_count,
			            X_Msg_Data                 => x_msg_data);

Line: 6418

	          FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATETOTAL', TRUE);

Line: 6439

	           aso_debug_pub.add( 'Create_Quote - p_validation_string: ' || TO_CHAR(x_Qte_Header_rec.LAST_UPDATE_DATE), 1, 'Y');

Line: 6448

      	                                  p_validation_string      => TO_CHAR(x_Qte_Header_rec.LAST_UPDATE_DATE),
                                            X_Return_Status          => X_Return_Status,
                                            X_Msg_Count              => X_Msg_Count,
                                            X_Msg_Data               => X_Msg_Data );

Line: 6475

         aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT.CREATE_QUOTE : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || x_qte_header_rec.quote_number, 1, 'Y');

Line: 6480

      ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(x_qte_header_rec.quote_number);

Line: 6551

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   ASO_QUOTE_PUB.Control_Rec_Type           := ASO_QUOTE_PUB.G_Miss_Control_Rec,
    P_Qte_Header_Rec		 IN   ASO_QUOTE_PUB.Qte_Header_Rec_Type        := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
    P_hd_Price_Attributes_Tbl	 IN   ASO_QUOTE_PUB.Price_Attributes_Tbl_Type  := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
    P_hd_Payment_Tbl		 IN   ASO_QUOTE_PUB.Payment_Tbl_Type           := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
    P_hd_Shipment_Tbl		 IN   ASO_QUOTE_PUB.Shipment_Tbl_Type          := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
    P_hd_Freight_Charge_Tbl	 IN   ASO_QUOTE_PUB.Freight_Charge_Tbl_Type    := ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
    P_hd_Tax_Detail_Tbl		 IN   ASO_QUOTE_PUB.Tax_Detail_Tbl_Type        := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
    P_hd_Attr_Ext_Tbl		 IN   ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type  := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
    P_hd_Sales_Credit_Tbl      IN   ASO_QUOTE_PUB.Sales_Credit_Tbl_Type      := ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
    P_hd_Quote_Party_Tbl       IN   ASO_QUOTE_PUB.Quote_Party_Tbl_Type       := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
    P_Qte_Line_Tbl		      IN   ASO_QUOTE_PUB.Qte_Line_Tbl_Type          := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
    P_Qte_Line_Dtl_Tbl		 IN   ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type      := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
    P_Line_Attr_Ext_Tbl		 IN   ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type  := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
    P_line_rltship_tbl		 IN   ASO_QUOTE_PUB.Line_Rltship_Tbl_Type      := ASO_QUOTE_PUB.G_MISS_Line_Rltship_Tbl,
    P_Price_Adjustment_Tbl	 IN   ASO_QUOTE_PUB.Price_Adj_Tbl_Type         := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl,
    P_Price_Adj_Attr_Tbl	      IN   ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type    := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
    P_Price_Adj_Rltship_Tbl	 IN   ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl,
    P_ln_Price_Attributes_Tbl	 IN   ASO_QUOTE_PUB.Price_Attributes_Tbl_Type  := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
    P_ln_Payment_Tbl		 IN   ASO_QUOTE_PUB.Payment_Tbl_Type           := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
    P_ln_Shipment_Tbl		 IN   ASO_QUOTE_PUB.Shipment_Tbl_Type          := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
    P_ln_Freight_Charge_Tbl	 IN   ASO_QUOTE_PUB.Freight_Charge_Tbl_Type    := ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
    P_ln_Tax_Detail_Tbl		 IN   ASO_QUOTE_PUB.Tax_Detail_Tbl_Type        := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
    P_ln_Sales_Credit_Tbl      IN   ASO_QUOTE_PUB.Sales_Credit_Tbl_Type      := ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
    P_ln_Quote_Party_Tbl       IN   ASO_QUOTE_PUB.Quote_Party_Tbl_Type       := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
    P_Qte_Access_Tbl           IN   ASO_QUOTE_PUB.Qte_Access_Tbl_Type        := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL,
    P_Template_Tbl             IN   ASO_QUOTE_PUB.Template_Tbl_Type          := ASO_QUOTE_PUB.G_MISS_TEMPLATE_TBL,
    P_Related_Obj_Tbl          IN   ASO_QUOTE_PUB.Related_Obj_Tbl_Type       := ASO_QUOTE_PUB.G_MISS_RELATED_OBJ_TBL,
    x_Qte_Header_Rec		 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Qte_Header_Rec_Type,
    X_Qte_Line_Tbl		      OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
    X_Qte_Line_Dtl_Tbl		 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
    X_hd_Price_Attributes_Tbl	 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
    X_hd_Payment_Tbl		 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Payment_Tbl_Type,
    X_hd_Shipment_Tbl		 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Shipment_Tbl_Type,
    X_hd_Freight_Charge_Tbl	 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
    X_hd_Tax_Detail_Tbl		 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
    X_hd_Attr_Ext_Tbl		 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
    X_hd_Sales_Credit_Tbl      OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
    X_hd_Quote_Party_Tbl       OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
    x_Line_Attr_Ext_Tbl		 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
    X_line_rltship_tbl		 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
    X_Price_Adjustment_Tbl	 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
    X_Price_Adj_Attr_Tbl	      OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
    X_Price_Adj_Rltship_Tbl	 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
    X_ln_Price_Attributes_Tbl	 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
    X_ln_Payment_Tbl		 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Payment_Tbl_Type,
    X_ln_Shipment_Tbl		 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Shipment_Tbl_Type,
    X_ln_Freight_Charge_Tbl	 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
    X_ln_Tax_Detail_Tbl		 OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
    X_Ln_Sales_Credit_Tbl      OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
    X_Ln_Quote_Party_Tbl       OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
    X_Qte_Access_Tbl           OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Qte_Access_Tbl_Type,
    X_Template_Tbl             OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.Template_Tbl_Type,
    X_Related_Obj_Tbl          OUT NOCOPY /* file.sql.39 change */  ASO_QUOTE_PUB.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
    --ovn
    Cursor C_Get_quote(c_QUOTE_HEADER_ID Number) IS
    Select LAST_UPDATE_DATE, QUOTE_STATUS_ID, quote_number, party_id, cust_account_id,
           order_type_id, order_id, object_version_number, currency_code, price_list_id
    From  ASO_QUOTE_HEADERS_ALL
    Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;

Line: 6622

    SELECT  AUTO_VERSION_FLAG
    FROM    ASO_QUOTE_STATUSES_B
    WHERE   quote_status_id = c_qte_status_id;

Line: 6627

    SELECT max(quote_version)
    FROM ASO_QUOTE_HEADERS_ALL
    WHERE quote_number = X_qte_number;

Line: 6632

    SELECT payment_id, payment_option FROM ASO_PAYMENTS
    WHERE quote_header_id = P_Qte_Header_Rec.quote_header_id
    AND quote_line_id IS NULL;

Line: 6637

    SELECT shipment_id FROM ASO_SHIPMENTS
    WHERE quote_header_id = P_Qte_Header_Rec.quote_header_id
    AND quote_line_id IS NULL;

Line: 6642

    SELECT tax_detail_id FROM ASO_TAX_DETAILS
    WHERE quote_header_id = P_Qte_Header_Rec.quote_header_id
    AND quote_line_id IS NULL
    AND ORIG_TAX_CODE IS NOT NULL;

Line: 6648

    SELECT quote_line_id  FROM ASO_QUOTE_LINES_ALL
    where quote_line_id= l_d_qte_line;

Line: 6652

    cursor c_last_update_date( p_qte_hdr_id  number) is
    select last_update_date
    from aso_quote_headers_all
    where quote_header_id = p_qte_hdr_id;

Line: 6658

    select quote_line_id,order_line_type_id,line_category_code,price_list_id,line_quote_price,quantity
    from aso_quote_lines_all
    where quote_header_id = p_qte_hdr_id;

Line: 6663

    select related_object_id,last_update_date
    from aso_quote_related_objects
    where quote_object_id = p_qte_hdr_id
    and quote_object_type_code = 'HEADER'
    and relationship_type_code = 'OPP_QUOTE';

Line: 6670

    Select object_id
    from aso_quote_related_objects
    where quote_object_id = p_qte_header_id
    and quote_object_type_code = 'HEADER'
    and relationship_type_code = 'OPP_QUOTE';

Line: 6686

    l_last_update_date          DATE;

Line: 6690

    l_update_allowed		  VARCHAR2(1);

Line: 6694

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

Line: 6760

    l_delete_qte_line_tbl       aso_quote_pub.qte_line_tbl_type     := aso_quote_pub.g_miss_qte_line_tbl;

Line: 6780

    select quote_line_id from aso_quote_line_details
    where config_header_id = p_config_header_id
    and   config_revision_num = p_config_revision_num
    and   ref_type_code = 'CONFIG'
    and   ref_line_id is NULL;

Line: 6787

    select config_hdr_id
    from cz_config_details_v
    where config_hdr_id = p_config_hdr_id
    and config_rev_nbr = p_config_rev_nbr;

Line: 6806

    l_price_updated_date_flag  VARCHAR2(1) := fnd_api.g_false;

Line: 6818

    SELECT 'Y'
    FROM ASO_QUOTE_STATUSES_B A, ASO_QUOTE_STATUSES_B B
    WHERE A.Quote_Status_Id = l_old_stat
    AND A.Status_Code = 'STORE DRAFT'
    AND B.Quote_Status_Id = l_new_stat
    AND B.Status_Code = 'DRAFT';

Line: 6826

    SELECT Sales_Credit_Type_Id
    FROM OE_SALES_CREDIT_TYPES
    WHERE Quota_Flag = 'Y';

Line: 6831

    SELECT 'Y'
    FROM ASO_SALES_CREDITS
    WHERE quote_header_id = l_qte_hdr_id;

Line: 6836

    select nvl(sum(nvl(tax_amount, 0)),0) tax_amount
    FROM   ASO_TAX_DETAILS
    WHERE  quote_header_id              =   p_qte_header_id
    and    quote_line_id                =   p_quote_line_id;

Line: 6842

    SELECT payment_term_id
    FROM aso_payments
    WHERE  quote_header_id              =   p_qte_header_id
    and    quote_line_id                =   p_quote_line_id;

Line: 6848

    SELECT payment_term_id
    FROM aso_payments
    WHERE  quote_header_id              =   p_qte_header_id
    and    quote_line_id                IS NULL;

Line: 6854

    SELECT resource_id
    FROM Aso_Quote_Headers_All
    WHERE quote_header_id = lc_qte_header_id;

Line: 6859

    SELECT  master_organization_id
    FROM    oe_system_parameters
    WHERE   org_id = l_main_org_id;

Line: 6864

    SELECT  org_id
    FROM    aso_quote_headers_all
    WHERE   quote_header_id = p_qte_header_id;

Line: 6919

      SAVEPOINT UPDATE_quote_PVT;

Line: 6923

	     aso_debug_pub.add('Begin Update_Quote Procedure', 1, 'Y');

Line: 6941

	     aso_debug_pub.add('Update_Quote - Begin ', 1, 'Y');

Line: 6976

          aso_debug_pub.add('Update_Quote: Before call to aso_input_param_debug.print_quote_input procedure', 1, 'Y');

Line: 6995

          aso_debug_pub.add('Update_Quote: After call to aso_input_param_debug.print_quote_input procedure', 1, 'Y');

Line: 7001

      Fetch C_Get_quote into l_LAST_UPDATE_DATE, l_qte_status_id, l_qte_number,l_party_id, l_cust_account_id,
	                        l_order_type_id,l_order_id,l_object_version_number, l_currency_code, l_price_list_id;

Line: 7007

	         FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');

Line: 7017

          aso_debug_pub.add('Update_Quote: quote_header_id:         '|| p_qte_header_rec.quote_header_id, 1, 'Y');

Line: 7018

          aso_debug_pub.add('Update_Quote: l_LAST_UPDATE_DATE:      '|| l_LAST_UPDATE_DATE, 1, 'Y');

Line: 7019

          aso_debug_pub.add('Update_Quote: l_qte_status_id:         '|| l_qte_status_id, 1, 'Y');

Line: 7020

          aso_debug_pub.add('Update_Quote: l_qte_number:            '|| l_qte_number, 1, 'Y');

Line: 7021

          aso_debug_pub.add('Update_Quote: l_order_type_id:         '|| l_order_type_id, 1, 'Y');

Line: 7022

          aso_debug_pub.add('Update_Quote: l_order_id:              '|| l_order_id, 1, 'Y');

Line: 7023

		aso_debug_pub.add('Update_Quote: l_object_version_number: '|| l_object_version_number,1,'Y');

Line: 7024

		aso_debug_pub.add('Update_Quote: l_currency_code:         '|| l_currency_code,1,'Y');

Line: 7025

		aso_debug_pub.add('Update_Quote: l_price_list_id:         '|| l_price_list_id,1,'Y');

Line: 7028

      If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then

	     IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
	         FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');

Line: 7032

	         FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line: 7040

      If (l_last_update_date <> p_qte_header_rec.last_update_date) Then

	     IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
	         FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');

Line: 7056

             aso_debug_pub.add('Update_Quote - p_qte_header_rec.object_version_number:' ||p_qte_header_rec.object_version_number,1,'Y');

Line: 7092

              FND_MESSAGE.Set_Name('ASO', 'ASO_API_UPDATE_QUOTE_SUBMITTED');

Line: 7100

	     aso_debug_pub.add('Update_Quote - quote_number: '||to_char(l_qte_number), 1, 'N');

Line: 7108

	     aso_debug_pub.add('Update_Quote - auto_version: '||l_auto_version, 1, 'N');

Line: 7130

          aso_debug_pub.add('Update_Quote - before defaulting framework', 1, 'Y');

Line: 7131

          aso_debug_pub.add('Update_Quote - populate defaulting control record from the header control record', 1, 'Y');

Line: 7137

      l_def_control_rec.Defaulting_Flow_Code := 'UPDATE';

Line: 7138

      l_def_control_rec.Last_Update_Date := P_Qte_Header_Rec.Last_Update_Date;

Line: 7146

          aso_debug_pub.add('Last_Update_Date - '||l_def_control_rec.Last_Update_Date, 1, 'Y');

Line: 7162

          aso_debug_pub.add('Update_Quote - Pick '||l_db_object_name ||' based on calling application '||l_def_control_rec.application_type_code, 1, 'Y');

Line: 7182

/* Removing Call for defaulting from update_quote
      IF l_control_rec.defaulting_fwk_flag = 'Y' THEN

          IF aso_debug_pub.g_debug_flag = 'Y' THEN
              aso_debug_pub.add('Update_Quote - Calling default_entity', 1, 'Y');

Line: 7249

	         aso_debug_pub.add('Update_Quote - p_qte_header_rec.order_type_id '||p_qte_header_rec.order_type_id, 1, 'N');

Line: 7257

	       aso_debug_pub.add('Update_Quote - Value of Order Type Profile'||to_number(ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE)), 1, 'N');

Line: 7261

              aso_debug_pub.add('Update_Quote - order_type_id from database '||l_order_type_id, 1, 'N');

Line: 7283

          aso_debug_pub.add('Update_Quote - l_qte_header_rec.publish_flag '||l_qte_header_rec.publish_flag, 1, 'N');

Line: 7297

              aso_debug_pub.add('Update_Quote - chk_cust_accts: x_return_status: '||x_return_status, 1, 'N');

Line: 7314

              aso_debug_pub.add('Update_Quote - assign_cust_accts: x_return_status: '||x_return_status, 1, 'N');

Line: 7328

	           aso_debug_pub.add('Update_Quote - before validate_party: ', 1, 'N');

Line: 7508

                if (p_hd_sales_credit_tbl(i).operation_code = 'CREATE' or p_hd_sales_credit_tbl(i).operation_code = 'UPDATE') then

                    ASO_VALIDATE_PVT.Validate_Resource_id(
                                p_init_msg_list => FND_API.G_FALSE,
                                p_resource_id   => p_hd_sales_credit_tbl(i).resource_id  ,
                                x_return_status => x_return_status,
                                x_msg_count     => x_msg_count,
                                x_msg_data      => x_msg_data);

Line: 7614

                            p_operation_code   =>   'UPDATE',
                            p_application_type_code   =>   l_control_rec.application_type_code,
                            x_return_status	   => x_return_status,
                            x_msg_count		=> x_msg_count,
                            x_msg_data		=> 	x_msg_data);

Line: 7722

                           p_operation_code  => 'UPDATE',
                           p_application_type_code  => l_control_rec.application_type_code,
                           x_return_status	=> x_return_status,
                           x_msg_count		=> x_msg_count,
                           x_msg_data		=> x_msg_data);

Line: 7747

              ELSIF l_hd_payment_tbl(i).operation_code = 'UPDATE' THEN

                  IF l_hd_payment_tbl(i).payment_id <> FND_API.G_MISS_NUM AND
                      l_payment_db_tbl.exists(l_hd_payment_tbl(i).payment_id) AND
                      l_hd_payment_tbl(i).payment_option <> FND_API.G_MISS_CHAR THEN

                         l_payment_db_tbl(l_hd_payment_tbl(i).payment_id) := l_hd_payment_tbl(i).payment_option;

Line: 7756

              ELSIF l_hd_payment_tbl(i).operation_code = 'DELETE' THEN

                  IF l_hd_payment_tbl(i).payment_id <> FND_API.G_MISS_NUM AND
                      l_payment_db_tbl.exists(l_hd_payment_tbl(i).payment_id) THEN

                        l_payment_db_tbl.DELETE(l_hd_payment_tbl(i).payment_id);

Line: 7830

               ELSIF l_hd_shipment_tbl(i).operation_code = 'DELETE' THEN

                   IF l_hd_shipment_tbl(i).shipment_id <> FND_API.G_MISS_NUM AND
                      l_shipment_db_tbl.exists(l_hd_shipment_tbl(i).shipment_id) THEN

                       l_shipment_db_tbl.DELETE(l_hd_shipment_tbl(i).shipment_id);

Line: 7865

               ELSIF l_hd_tax_detail_tbl(i).operation_code ='DELETE' AND
                     l_hd_tax_detail_tbl(i).tax_detail_id <> FND_API.G_MISS_NUM AND
                     l_tax_db_tbl.exists(l_hd_tax_detail_tbl(i).tax_detail_id) THEN

                       l_tax_db_tbl.delete(l_hd_tax_detail_tbl(i).tax_detail_id);

Line: 7911

		      aso_debug_pub.add('Update_Quote: After copy_quote l_return_status: ' || l_return_status);

Line: 7912

                aso_debug_pub.add('Update_Quote: After copy_quote l_qte_header_id: ' || l_qte_header_id);

Line: 7913

                aso_debug_pub.add('Update_Quote: After copy_quote l_quote_number:  ' || l_quote_number);

Line: 7916

            update aso_quote_headers_all
            set quote_version      =  l_qte_header_rec.quote_version + 1,
                max_version_flag   =  'Y',
                creation_date      =  sysdate
            where quote_header_id = l_qte_header_rec.quote_header_id;

Line: 7922

            update aso_quote_headers_all
            set max_version_flag      =  'N',
                quote_version         =  l_old_header_rec.quote_version,
                quote_status_id       =  l_old_header_rec.quote_status_id,
                creation_date         =  l_old_header_rec.creation_date,
			 created_by            =  l_old_header_rec.created_by,
			 last_update_date      =  sysdate,
                last_updated_by       =  g_user_id,
                last_update_login     =  g_login_id
            where quote_header_id = l_qte_header_id;

Line: 7933

            update aso_quote_headers_all
            set quote_version         =  l_qte_header_rec.quote_version,
                last_update_date      =  sysdate,
			 created_by            =  g_user_id,
			 last_updated_by       =  g_user_id,
                last_update_login     =  g_login_id
            where quote_header_id = l_qte_header_rec.quote_header_id;

Line: 7941

            open  c_last_update_date(l_qte_header_rec.quote_header_id);

Line: 7942

            fetch c_last_update_date into l_qte_header_rec.last_update_date;

Line: 7943

            close c_last_update_date;

Line: 7945

            l_control_rec.last_update_date  :=  l_qte_header_rec.last_update_date;

Line: 7948

                aso_debug_pub.add('Update_Quote: After updating aso_quote_headers_all table for auto versioning.');

Line: 7949

                aso_debug_pub.add('l_qte_header_rec.last_update_date: '|| l_qte_header_rec.last_update_date);

Line: 7950

                aso_debug_pub.add('l_control_rec.last_update_date:    '|| l_control_rec.last_update_date);

Line: 8003

        	             p_operation_code  => 'UPDATE',
        	             p_application_type_code  => l_control_rec.application_type_code,
        	             x_return_status	 => x_return_status,
                       x_msg_count		 => x_msg_count,
                       x_msg_data		 => x_msg_data);

Line: 8014

       IF ((l_shipment_rec.ship_method_code is not null and l_shipment_rec.ship_method_code <> fnd_api.g_miss_char and l_shipment_rec.operation_code = 'UPDATE')
          or (P_Qte_Header_Rec.org_id is not null and P_Qte_Header_Rec.org_id <> fnd_api.g_miss_num)) THEN

          -- get the value from db if not passed in
         IF (P_Qte_Header_Rec.org_id is null or P_Qte_Header_Rec.org_id = fnd_api.g_miss_num ) THEN
          OPEN c_org_id(l_qte_header_rec.quote_header_id);

Line: 8032

           aso_debug_pub.add('Update_Quote - l_shipment_rec.ship_method_code:  '|| l_shipment_rec.ship_method_code, 1, 'N');

Line: 8033

           aso_debug_pub.add('Update_Quote - P_Qte_Header_Rec.org_id:   '|| P_Qte_Header_Rec.org_id, 1, 'N');

Line: 8034

           aso_debug_pub.add('Update_Quote - l_master_organization_id:  '|| l_master_organization_id, 1, 'N');

Line: 8035

           aso_debug_pub.add('Update_Quote - l_quote_org_id         :   '|| l_quote_org_id, 1, 'N');

Line: 8036

           aso_debug_pub.add('Update_Quote - before validate ship_method_code ', 1, 'N');

Line: 8051

           aso_debug_pub.add('Update_Quote - After validate ship_method_code ', 1, 'N');

Line: 8066

                   P_Operation_Code      => 'UPDATE',
                   p_application_type_code      => l_control_rec.application_type_code,
                   x_return_status       => x_return_status,
                   x_msg_count           => x_msg_count,
                   x_msg_data            => x_msg_data);

Line: 8077

          aso_debug_pub.add('Update_Quote - before Validate_Agreement:l_qte_header_rec.contract_id: '||l_qte_header_rec.contract_id, 1, 'N');

Line: 8091

               aso_debug_pub.add('Update_Quote - after Validate_Agreement:x_return_status: '||x_return_status, 1, 'N');

Line: 8101

	     aso_debug_pub.add('Update_Quote: l_qte_header_rec.minisite_id: '|| l_qte_header_rec.minisite_id);

Line: 8114

		     aso_debug_pub.add('Update_Quote: After call to ASO_VALIDATE_PVT.Validate_MiniSite');

Line: 8115

               aso_debug_pub.add('Update_Quote: x_return_status: '|| x_return_status);

Line: 8125

	     aso_debug_pub.add('Update_Quote: Before call to update_rows procedures', 1, 'Y');

Line: 8128

      Update_Rows (
			p_qte_header_rec	    => l_qte_header_rec,
			p_Price_Attributes_Tbl  => p_hd_price_attributes_tbl,
			P_Price_Adjustment_Tbl  => l_price_adj_tbl,
			P_Price_Adj_Attr_Tbl    => l_price_adj_attr_tbl,
			P_Payment_Tbl		    => l_hd_payment_tbl,
			P_Shipment_Tbl		    => l_hd_shipment_tbl,
			P_Freight_Charge_Tbl    => p_hd_freight_charge_tbl,
			P_Tax_Detail_Tbl	    => l_hd_tax_detail_tbl,
               P_hd_Attr_Ext_Tbl	    => P_hd_Attr_Ext_Tbl,
               P_sales_credit_tbl      => p_hd_sales_credit_tbl,
               P_quote_party_tbl       => p_hd_quote_party_tbl,
               P_Qte_Access_Tbl        => P_Qte_Access_Tbl,
			x_qte_header_rec        => x_qte_header_rec,
			x_Price_Attributes_Tbl  => x_hd_price_attributes_tbl,
			x_Price_Adjustment_Tbl  => l_price_adj_tbl_out,
			x_Price_Adj_Attr_Tbl    => l_price_adj_attr_tbl_out,
			x_Payment_Tbl		    => x_hd_payment_tbl,
			x_Shipment_Tbl		    => x_hd_shipment_tbl,
			x_Freight_Charge_Tbl    => x_hd_freight_charge_tbl,
			x_Tax_Detail_Tbl        => x_hd_tax_detail_tbl,
               x_hd_Attr_Ext_Tbl       => x_hd_Attr_Ext_Tbl,
               x_sales_credit_tbl      => x_hd_sales_credit_tbl,
               x_quote_party_tbl       => x_hd_quote_party_tbl,
               x_Qte_Access_Tbl        => x_Qte_Access_Tbl,
			X_Return_Status 	    => l_return_status,
			X_Msg_Count		    => x_msg_count,
			X_Msg_Data		    => x_msg_data);

Line: 8161

          aso_debug_pub.add('Update_Quote: After call to update_rows: l_return_status: ' || l_return_status, 1, 'Y');

Line: 8162

          aso_debug_pub.add('Update_Quote: value of ASO_API_ENABLE_SECURITY: ' || FND_PROFILE.value('ASO_API_ENABLE_SECURITY'), 1, 'Y');

Line: 8168

          aso_debug_pub.add('Update_Quote: p_template_tbl.count: ' || p_template_tbl.count, 1, 'Y');

Line: 8186

             aso_debug_pub.add('Update_Quote: l_template_tbl.count: ' || l_template_tbl.count, 1, 'Y');

Line: 8187

             aso_debug_pub.add('Update_Quote: Before call to aso_quote_templ_pvt.add_template_to_quote procedure', 1, 'Y');

Line: 8195

                   p_update_flag        => 'N',
                   p_template_id_tbl    => l_template_tbl,
                   p_qte_header_rec     => x_qte_header_rec,
                   p_control_rec        => p_control_rec,
                   x_qte_line_tbl       => lx_qte_line_tbl,
                   x_qte_line_dtl_tbl   => x_qte_line_dtl_tbl,
                   x_return_status      => x_return_status,
                   x_msg_count          => x_msg_count,
                   x_msg_data           => x_msg_data
                   );

Line: 8209

	        aso_debug_pub.add('Update_Quote: After call to aso_quote_templ_pvt.add_template_to_quote: x_return_status: '|| x_return_status, 1, 'Y');

Line: 8210

	        aso_debug_pub.add('Update_Quote: lx_qte_line_tbl.count:    ' || lx_qte_line_tbl.count, 1, 'Y');

Line: 8211

	        aso_debug_pub.add('Update_Quote: x_qte_line_dtl_tbl.count: ' || x_qte_line_dtl_tbl.count, 1, 'Y');

Line: 8214

	             aso_debug_pub.add('Update_Quote: lx_qte_line_tbl('||i||').inventory_item_id: '|| lx_qte_line_tbl(i).inventory_item_id, 1, 'N');

Line: 8215

	             aso_debug_pub.add('Update_Quote: lx_qte_line_tbl('||i||').uom_code:          '|| lx_qte_line_tbl(i).uom_code, 1, 'N');

Line: 8216

	             aso_debug_pub.add('Update_Quote: lx_qte_line_tbl('||i||').quantity:          '|| lx_qte_line_tbl(i).quantity, 1, 'N');

Line: 8221

	             aso_debug_pub.add('Update_Quote: x_qte_line_dtl_tbl('||i||').qte_line_index:             '|| x_qte_line_dtl_tbl(i).qte_line_index, 1, 'N');

Line: 8222

	             aso_debug_pub.add('Update_Quote: x_qte_line_dtl_tbl('||i||').ref_line_index:             '|| x_qte_line_dtl_tbl(i).ref_line_index, 1, 'N');

Line: 8223

	             aso_debug_pub.add('Update_Quote: x_qte_line_dtl_tbl('||i||').service_ref_qte_line_index: '|| x_qte_line_dtl_tbl(i).service_ref_qte_line_index, 1, 'N');

Line: 8224

	             aso_debug_pub.add('Update_Quote: x_qte_line_dtl_tbl('||i||').service_ref_line_id:        '|| x_qte_line_dtl_tbl(i).service_ref_line_id, 1, 'N');

Line: 8282

	     aso_debug_pub.add('Update_Quote: l_qte_line_tbl.count:      ' || l_qte_line_tbl.count, 1, 'Y');

Line: 8283

	     aso_debug_pub.add('Update_Quote: lx_qte_line_dtl_tbl.count: ' || lx_qte_line_dtl_tbl.count, 1, 'Y');

Line: 8286

	          aso_debug_pub.add('Update_Quote: l_qte_line_tbl('||i||').inventory_item_id: '|| l_qte_line_tbl(i).inventory_item_id, 1, 'N');

Line: 8287

	          aso_debug_pub.add('Update_Quote: l_qte_line_tbl('||i||').uom_code:          '|| l_qte_line_tbl(i).uom_code, 1, 'N');

Line: 8288

	          aso_debug_pub.add('Update_Quote: l_qte_line_tbl('||i||').quantity:          '|| l_qte_line_tbl(i).quantity, 1, 'N');

Line: 8293

	          aso_debug_pub.add('Update_Quote: lx_qte_line_dtl_tbl('||i||').qte_line_index:             '|| lx_qte_line_dtl_tbl(i).qte_line_index, 1, 'N');

Line: 8294

	          aso_debug_pub.add('Update_Quote: lx_qte_line_dtl_tbl('||i||').ref_line_index:             '|| lx_qte_line_dtl_tbl(i).ref_line_index, 1, 'N');

Line: 8295

	          aso_debug_pub.add('Update_Quote: lx_qte_line_dtl_tbl('||i||').service_ref_qte_line_index: '|| lx_qte_line_dtl_tbl(i).service_ref_qte_line_index, 1, 'N');

Line: 8296

	          aso_debug_pub.add('Update_Quote: lx_qte_line_dtl_tbl('||i||').service_ref_line_id:        '|| lx_qte_line_dtl_tbl(i).service_ref_line_id, 1, 'N');

Line: 8297

	          aso_debug_pub.add('Update_Quote: lx_qte_line_dtl_tbl('||i||').ato_line_index:             '|| lx_qte_line_dtl_tbl(i).ato_line_index, 1, 'N');

Line: 8298

	          aso_debug_pub.add('Update_Quote: lx_qte_line_dtl_tbl('||i||').ato_line_id:                '|| lx_qte_line_dtl_tbl(i).ato_line_id, 1, 'N');

Line: 8299

	          aso_debug_pub.add('Update_Quote: lx_qte_line_dtl_tbl('||i||').top_model_line_index:       '|| lx_qte_line_dtl_tbl(i).top_model_line_index, 1, 'N');

Line: 8300

	          aso_debug_pub.add('Update_Quote: lx_qte_line_dtl_tbl('||i||').top_model_line_id:          '|| lx_qte_line_dtl_tbl(i).top_model_line_id, 1, 'N');

Line: 8308

			 aso_debug_pub.add('Update_Quote: value of p_qte_header_rec.quote_type: ' || p_qte_header_rec.quote_type, 1, 'Y');

Line: 8309

			 aso_debug_pub.add('Update_Quote: value of l_qte_header_rec.resource_id: ' || l_qte_header_rec.resource_id, 1, 'Y');

Line: 8310

			 aso_debug_pub.add('Update_Quote: value of l_qte_header_rec.resource_grp_id: ' || l_qte_header_rec.resource_grp_id, 1, 'Y');

Line: 8333

                   aso_debug_pub.add('Update_Quote - before assign_sales_team l_store_trans: '||l_store_trans, 1, 'Y');

Line: 8334

                   aso_debug_pub.add('Update_Quote - before assign_sales_team l_sales_team_prof: '||l_sales_team_prof, 1, 'Y');

Line: 8345

                                  P_Operation        => 'UPDATE',
                                  x_Qte_Header_Rec   => lx_qte_header_rec,
                                  x_return_status    => x_return_status,
                                  x_msg_count        => x_msg_count,
                                  x_msg_data         => x_msg_data);

Line: 8368

                    l_qte_access_rec.LAST_UPDATED_BY          := G_USER_ID;

Line: 8369

                    l_qte_access_rec.LAST_UPDATE_LOGIN        := G_LOGIN_ID;

Line: 8370

                    l_qte_access_rec.LAST_UPDATE_DATE         := SYSDATE;

Line: 8374

                    l_qte_access_rec.PROGRAM_UPDATE_DATE      := l_qte_header_rec.program_update_date;

Line: 8381

                    l_qte_access_rec.UPDATE_ACCESS_FLAG       := 'Y';

Line: 8387

		              aso_debug_pub.add('Update_Quote: before Add_Resource: l_qte_header_rec.resource_id:    ' || l_qte_header_rec.resource_id, 1, 'Y');

Line: 8388

                        aso_debug_pub.add('Update_Quote: before Add_Resource', 1, 'Y');

Line: 8403

		              aso_debug_pub.add('Update_Quote: after Add_Resource: x_return_status: ' || x_return_status, 1, 'Y');

Line: 8410

                    open  c_last_update_date(x_qte_header_rec.quote_header_id);

Line: 8411

                    fetch c_last_update_date into x_qte_header_rec.last_update_date;

Line: 8412

                    close c_last_update_date;

Line: 8414

                    l_control_rec.last_update_date  :=  x_qte_header_rec.last_update_date;

Line: 8417

                        aso_debug_pub.add('Update_Quote: After call to Add_Resource.');

Line: 8418

                        aso_debug_pub.add('x_qte_header_rec.last_update_date: '|| x_qte_header_rec.last_update_date);

Line: 8419

                        aso_debug_pub.add('l_control_rec.last_update_date:    '|| l_control_rec.last_update_date);

Line: 8440

          ASO_SALES_CREDITS_PKG.Insert_Row(
          p_CREATION_DATE  => SYSDATE,
          p_CREATED_BY  => G_USER_ID,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
          p_REQUEST_ID  => FND_API.G_MISS_NUM,
          p_PROGRAM_APPLICATION_ID  => FND_API.G_MISS_NUM,
          p_PROGRAM_ID  => FND_API.G_MISS_NUM,
          p_PROGRAM_UPDATE_DATE  => FND_API.G_MISS_DATE,
          px_SALES_CREDIT_ID  => x_hd_sales_credit_tbl(1).Sales_Credit_Id,
          p_QUOTE_HEADER_ID  => l_qte_header_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID  => FND_API.G_MISS_NUM,
          p_PERCENT  => 100,
          p_RESOURCE_ID  => l_qte_header_rec.RESOURCE_ID,
          p_RESOURCE_GROUP_ID  => l_qte_header_rec.RESOURCE_GRP_ID,
          p_EMPLOYEE_PERSON_ID  => FND_API.G_MISS_NUM,
          p_SALES_CREDIT_TYPE_ID  => l_quota_id,
          p_ATTRIBUTE_CATEGORY_CODE  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE1  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE2  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE3  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE4  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE5  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE6  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE7  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE8  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE9  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE10  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE11  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE12  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE13  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE14  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE15  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE16  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE17  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE18  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE19  => FND_API.G_MISS_CHAR,
          p_ATTRIBUTE20  => FND_API.G_MISS_CHAR,
          p_SYSTEM_ASSIGNED_FLAG  => 'N',
          p_CREDIT_RULE_ID  => FND_API.G_MISS_NUM,
          p_OBJECT_VERSION_NUMBER  => FND_API.G_MISS_NUM);

Line: 8483

       aso_debug_pub.add('After Insert SCred ');

Line: 8520

                l_related_obj_rec.operation_code := 'UPDATE';

Line: 8524

                l_related_obj_rec.operation_code := 'DELETE';

Line: 8560

                 aso_debug_pub.add('Update_Quote: After call to Create_Object_Relationship: x_return_status: '||x_return_status, 1, 'N');

Line: 8569

        ELSIF l_related_obj_rec.operation_code = 'UPDATE' THEN

          IF ((l_related_obj_rec.related_object_id = NULL OR l_related_obj_rec.related_object_id = FND_API.G_MISS_NUM)
		   OR (l_related_obj_rec.last_update_date = null or l_related_obj_rec.last_update_date = FND_API.G_MISS_DATE))THEN
		   Open c_related_obj_id(l_qte_header_rec.quote_header_id);

Line: 8574

		   Fetch c_related_obj_id INTO l_related_obj_rec.related_object_id,l_related_obj_rec.last_update_date;

Line: 8580

            ASO_RLTSHIP_PUB.Update_Object_Relationship(
              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_RELATED_OBJ_Rec            => l_related_obj_rec,
              X_Return_Status              => X_Return_Status,
              X_Msg_Count                  => X_Msg_Count,
              X_Msg_Data                   => X_Msg_Data);

Line: 8591

                 aso_debug_pub.add('Update_Quote: After call to Update_Object_Relationship: x_return_status: '||x_return_status, 1, 'N');

Line: 8600

        ELSIF l_related_obj_rec.operation_code = 'DELETE' THEN

          IF l_related_obj_rec.related_object_id = NULL OR l_related_obj_rec.related_object_id = FND_API.G_MISS_NUM THEN
             Open c_related_obj_id(l_qte_header_rec.quote_header_id);

Line: 8604

             Fetch c_related_obj_id INTO l_related_obj_rec.related_object_id,l_related_obj_rec.last_update_date;

Line: 8609

            ASO_RLTSHIP_PUB.Delete_Object_Relationship(
              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_RELATED_OBJ_Rec            => l_related_obj_rec,
              X_Return_Status              => X_Return_Status,
              X_Msg_Count                  => X_Msg_Count,
              X_Msg_Data                   => X_Msg_Data);

Line: 8620

                 aso_debug_pub.add('Update_Quote: After call to Delete_Object_Relationship: x_return_status: '||x_return_status, 1, 'N');

Line: 8689

	      FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE ROW', TRUE);

Line: 8709

 aso_debug_pub.add('UPDATE_QUOTE: l_qte_header_rec.Call_batch_validation_flag: '|| l_qte_header_rec.Call_batch_validation_flag,1,'N');

Line: 8714

   IF l_qte_line_rec.operation_code IN ('UPDATE','DELETE') THEN

      OPEN c_qte_line(l_qte_line_rec.quote_line_id);

Line: 8740

                       IF (l_qte_line_rec.operation_code = 'UPDATE') AND
					 (l_qte_line_rec.quantity <> FND_API.G_MISS_NUM) AND
                          (l_batch_qte_line_rec.quantity <> l_qte_line_rec.quantity) THEN

                           IF l_search_qte_line_tbl.EXISTS(l_qte_line_rec.quote_line_id) THEN
                               IF aso_debug_pub.g_debug_flag = 'Y' THEN
						 aso_debug_pub.add('UPDATE_QUOTE: Model line exist in the l_search_qte_line_tbl, no need to add again',1,'N');

Line: 8752

						 aso_debug_pub.add('UPDATE_QUOTE: Model line does not exist in the l_search_qte_line_tbl, need to add into it',1,'N');

Line: 8760

						 aso_debug_pub.add('UPDATE_QUOTE: Model line does not exist: l_model_line_id: '|| l_model_line_id,1,'N');

Line: 8765

                       ELSIF l_qte_line_rec.operation_code = 'DELETE' THEN

                            l_delete_qte_line_tbl(l_qte_line_rec.quote_line_id).quote_line_id
                                                    := l_qte_line_rec.quote_line_id;

Line: 8773

			        if l_qte_line_rec.operation_code = 'DELETE'  and l_batch_qte_line_rec.config_model_type = 'N'
				      and  l_batch_qte_line_dtl_tbl(1).config_delta = 0 THEN

                           l_deactivate_counter := l_deactivate_counter + 1;

Line: 8789

				             aso_debug_pub.add('UPDATE_QUOTE: c_model_line: l_model_line_id: '||l_model_line_id,1,'N');

Line: 8794

                                IF (l_qte_line_rec.operation_code = 'UPDATE') AND
                                   (l_qte_line_rec.quantity <> FND_API.G_MISS_NUM) AND
                                   (l_batch_qte_line_rec.quantity <> l_qte_line_rec.quantity) THEN

                                   IF aso_debug_pub.g_debug_flag = 'Y' THEN
							     aso_debug_pub.add('UPDATE_QUOTE: Children line having operation_code = UPDATE',1,'N');

Line: 8804

							    aso_debug_pub.add('UPDATE_QUOTE: Model line exist in the l_model_qte_line_tbl, no need to add again',1,'N');

Line: 8808

							    aso_debug_pub.add('UPDATE_QUOTE: Model line does not exist in the l_model_qte_line_tbl, need to add again',1,'N');

Line: 8815

                                ELSIF l_qte_line_rec.operation_code = 'DELETE' THEN

                                   IF aso_debug_pub.g_debug_flag = 'Y' THEN
							aso_debug_pub.add('UPDATE_QUOTE: Children line having operation_code = DELETE',1,'N');

Line: 8825

							    aso_debug_pub.add('UPDATE_QUOTE: Model line exist in the l_model_qte_line_tbl, no need to add again',1,'N');

Line: 8830

							    aso_debug_pub.add('UPDATE_QUOTE: Model line does not exist in the l_model_qte_line_tbl, need to add into it',1,'N');

Line: 8840

					           aso_debug_pub.add('UPDATE_QUOTE: c_model_line: Model line does not exist for this config line',1,'N');

Line: 8845

				    end if; --l_qte_line_rec.operation_code = 'DELETE' and l_batch_qte_line_rec.config_model_type = 'N' and l_batch_qte_line_dtl_tbl(1).config_delta = 0 THEN

Line: 8850

			    aso_debug_pub.add('UPDATE_QUOTE: Before Adding line to l_model_qte_line_tbl',1,'N');

Line: 8851

                   aso_debug_pub.add('UPDATE_QUOTE: Before Adding line to l_model_qte_line_tbl: l_add_model_line: '||l_add_model_line,1,'N');

Line: 8858

				   aso_debug_pub.add('UPDATE_QUOTE: Inside IF l_add_model_line = FND_API.G_TRUE: l_model_index: '||l_model_index,1,'N');

Line: 8868

			    aso_debug_pub.add('UPDATE_QUOTE: Before Adding line to l_p_batch_qte_line_tbl',1,'N');

Line: 8869

                   aso_debug_pub.add('UPDATE_QUOTE: Before Adding line to l_p_batch_qte_line_tbl: l_add_line: '||l_add_line,1,'N');

Line: 8874

				   aso_debug_pub.add('UPDATE_QUOTE: Inside IF l_add_line = FND_API.G_TRUE: l_batch_index: '||l_batch_index,1,'N');

Line: 8891

    END IF;--l_qte_line_rec.operation_code IN ('UPDATE','DELETE')

Line: 9047

aso_debug_pub.add('Update_Quote (create_quote_lines) - before Validate_Commitment ', 1, 'N');

Line: 9057

aso_debug_pub.add('Update_Quote - after Validate_Commitment: l_return_status: '||l_return_status, 1, 'N');

Line: 9069

	   open  c_last_update_date(x_qte_header_rec.quote_header_id);

Line: 9070

	   fetch c_last_update_date into l_control_rec.last_update_date;

Line: 9071

	   close c_last_update_date;

Line: 9074

		  aso_debug_pub.add('Update_Quote: Before call to Create_Quote_Lines');

Line: 9075

            aso_debug_pub.add('l_control_rec.last_update_date:    '|| l_control_rec.last_update_date);

Line: 9083

			p_update_header_flag	=> FND_API.G_FALSE,
                  p_qte_header_rec        =>  l_qte_header_rec,
			P_qte_Line_Rec		=> l_qte_line_rec,
			P_qte_line_dtl_tbl	=> l_qte_line_dtl_tbl,
			P_Line_Attribs_Ext_Tbl	=> l_line_attr_Ext_Tbl,
			P_price_attributes_tbl	=> l_price_attr_tbl,
			P_Price_Adj_Tbl		=> l_price_adj_tbl,
			P_Price_Adj_Attr_Tbl	=> l_Price_Adj_Attr_Tbl,
			P_Payment_Tbl		=> l_payment_tbl,
			P_Shipment_Tbl		=> l_shipment_tbl,
			P_Freight_Charge_Tbl	=> l_freight_charge_tbl,
			P_Tax_Detail_Tbl	=> l_tax_detail_tbl,
            P_quote_party_tbl       => l_quote_party_tbl ,
            P_sales_Credit_tbl      => l_sales_Credit_tbl ,
			x_qte_Line_Rec		=> l_qte_line_rec_out,
			x_qte_line_dtl_tbl	=> l_qte_line_dtl_tbl_out,
			x_Line_Attribs_Ext_Tbl	=> l_line_attr_Ext_Tbl_out,
			x_price_attributes_tbl	=> l_price_attr_tbl_out,
			x_Price_Adj_Tbl		=> l_price_adj_tbl_out,
			x_Price_Adj_Attr_Tbl	=> l_Price_Adj_Attr_Tbl_out,
			x_Payment_Tbl		=> l_payment_tbl_out,
			x_Shipment_Tbl		=> l_shipment_tbl_out,
			x_Freight_Charge_Tbl	=> l_freight_charge_tbl_out,
			x_Tax_Detail_Tbl	=> l_tax_detail_tbl_out,
               X_quote_party_tbl       => l_quote_party_tbl_out ,
               X_sales_Credit_tbl      => l_sales_Credit_tbl_out ,
			X_Return_Status 	=> l_return_status,
			X_Msg_Count		=> x_msg_count,
			X_Msg_Data		=> x_msg_data);

Line: 9129

		   aso_debug_pub.add('Update_Quote - after create_quote_lines return_status: '||l_return_status, 1, 'Y');

Line: 9147

        open  c_last_update_date(x_qte_header_rec.quote_header_id);

Line: 9148

        fetch c_last_update_date into x_qte_header_rec.last_update_date;

Line: 9149

        close c_last_update_date;

Line: 9151

        l_control_rec.last_update_date  :=  x_qte_header_rec.last_update_date;

Line: 9154

            aso_debug_pub.add('Update_Quote: After call to Create_Quote_Lines');

Line: 9155

            aso_debug_pub.add('x_qte_header_rec.last_update_date: '|| x_qte_header_rec.last_update_date);

Line: 9156

            aso_debug_pub.add('l_control_rec.last_update_date:    '|| l_control_rec.last_update_date);

Line: 9251

	ELSIF l_qte_line_rec.operation_code = 'UPDATE' THEN


     IF aso_debug_pub.g_debug_flag = 'Y' THEN
	aso_debug_pub.add('Update_Quote - if operation_code is update ', 1, 'N');

Line: 9411

aso_debug_pub.add('Update_Quote (update_quote_lines) - before Validate_Commitment ', 1, 'N');

Line: 9421

aso_debug_pub.add('Update_Quote (upd_qte_ln)- after Validate_Commitment: l_return_status: '||l_return_status, 1, 'N');

Line: 9432

	  -- update quote line (need to do the following validation:
	  -- 1. each line has at least one shipment rec
	  -- 2. each line has only one tax_detail rec in which to set the tax
	  --	exempt info.

	   open  c_last_update_date(x_qte_header_rec.quote_header_id);

Line: 9438

	   fetch c_last_update_date into l_control_rec.last_update_date;

Line: 9439

	   close c_last_update_date;

Line: 9442

		  aso_debug_pub.add('Update_Quote: Before call to Update_Quote_Line');

Line: 9443

            aso_debug_pub.add('l_control_rec.last_update_date:    '|| l_control_rec.last_update_date);

Line: 9447

	   ASO_QUOTE_LINES_PVT.Update_Quote_Line (
			P_Api_Version_Number	=> 1.0,
			p_validation_level	=> p_validation_level,
			p_control_rec		=> l_control_rec,
			p_update_header_flag	=> FND_API.G_FALSE,
                  p_qte_header_rec        => l_qte_header_rec,
			P_qte_Line_Rec		=> l_qte_line_rec,
			P_qte_line_dtl_tbl	=> l_qte_line_dtl_tbl,
			P_Line_Attribs_Ext_Tbl	=> l_line_attr_Ext_Tbl,
			P_price_attributes_tbl	=> l_price_attr_tbl,
			P_Price_Adj_Tbl		=> l_price_adj_tbl,
			P_Price_Adj_Attr_Tbl	=> l_Price_Adj_Attr_Tbl,
			P_Payment_Tbl		=> l_payment_tbl,
			P_Shipment_Tbl		=> l_shipment_tbl,
			P_Freight_Charge_Tbl	=> l_freight_charge_tbl,
			P_Tax_Detail_Tbl	=> l_tax_detail_tbl,
            P_quote_party_tbl       => l_quote_party_tbl ,
            P_sales_Credit_tbl      => l_sales_Credit_tbl ,
			x_qte_Line_Rec		=> l_qte_line_rec_out,
			x_qte_line_dtl_tbl	=> l_qte_line_dtl_tbl_out,
			x_Line_Attribs_Ext_Tbl	=> l_line_attr_Ext_Tbl_out,
			x_price_attributes_tbl	=> l_price_attr_tbl_out,
			x_Price_Adj_Tbl		=> l_price_adj_tbl_out,
			x_Price_Adj_Attr_Tbl	=> l_Price_Adj_Attr_Tbl_out,
			x_Payment_Tbl		=> l_payment_tbl_out,
			x_Shipment_Tbl		=> l_shipment_tbl_out,
			x_Freight_Charge_Tbl	=> l_freight_charge_tbl_out,
			x_Tax_Detail_Tbl	=> l_tax_detail_tbl_out,
            X_quote_party_tbl       => l_quote_party_tbl_out ,
            X_sales_Credit_tbl      => l_sales_Credit_tbl_out ,
			X_Return_Status 	=> l_return_status,
			X_Msg_Count		=> x_msg_count,
			X_Msg_Data		=> x_msg_data);

Line: 9497

	        aso_debug_pub.add('Update_Quote: after update_quote_line: l_return_status: '||l_return_status);

Line: 9500

        open  c_last_update_date(x_qte_header_rec.quote_header_id);

Line: 9501

        fetch c_last_update_date into x_qte_header_rec.last_update_date;

Line: 9502

        close c_last_update_date;

Line: 9504

        l_control_rec.last_update_date  :=  x_qte_header_rec.last_update_date;

Line: 9507

            aso_debug_pub.add('Update_Quote: After call to Update_Quote_Line');

Line: 9508

            aso_debug_pub.add('x_qte_header_rec.last_update_date: '|| x_qte_header_rec.last_update_date);

Line: 9509

            aso_debug_pub.add('l_control_rec.last_update_date:    '|| l_control_rec.last_update_date);

Line: 9582

	      FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE  QLN', TRUE);

Line: 9592

	ELSIF l_qte_line_rec.operation_code = 'DELETE' THEN


            OPEN c_qte_line(l_qte_line_rec.quote_line_id);

Line: 9600

	          open  c_last_update_date(x_qte_header_rec.quote_header_id);

Line: 9601

	          fetch c_last_update_date into l_control_rec.last_update_date;

Line: 9602

	          close c_last_update_date;

Line: 9605

		         aso_debug_pub.add('Update_Quote: Before call to Delete_Quote_Line');

Line: 9606

                   aso_debug_pub.add('l_control_rec.last_update_date:    '|| l_control_rec.last_update_date);

Line: 9609

	          ASO_QUOTE_LINES_PVT.Delete_Quote_Line (
			P_Api_Version_Number	=> 1.0,
			p_control_rec		=> l_control_rec,
			p_update_header_flag	=> FND_API.G_FALSE,
			P_qte_Line_Rec		=> l_qte_line_rec,
			X_Return_Status 	=> l_return_status,
			X_Msg_Count		=> x_msg_count,
			X_Msg_Data		=> x_msg_data);

Line: 9623

	           aso_debug_pub.add('Update_Quote: after Delete_Quote_Line: l_return_status: '||l_return_status);

Line: 9632

	                 FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER DELETE QLN', TRUE);

Line: 9644

            open  c_last_update_date(x_qte_header_rec.quote_header_id);

Line: 9645

            fetch c_last_update_date into x_qte_header_rec.last_update_date;

Line: 9646

            close c_last_update_date;

Line: 9648

            l_control_rec.last_update_date  :=  x_qte_header_rec.last_update_date;

Line: 9651

                aso_debug_pub.add('Update_Quote: After call to Update_Quote_Line');

Line: 9652

                aso_debug_pub.add('x_qte_header_rec.last_update_date: '|| x_qte_header_rec.last_update_date);

Line: 9653

                aso_debug_pub.add('l_control_rec.last_update_date:    '|| l_control_rec.last_update_date);

Line: 9666

aso_debug_pub.add('UPDATE_QUOTE: l_qte_header_rec.Call_batch_validation_flag: '||l_qte_header_rec.Call_batch_validation_flag,1,'N');

Line: 9672

   aso_debug_pub.add('UPDATE_QUOTE: l_model_qte_line_tbl.count: '||l_model_qte_line_tbl.count,1,'N');

Line: 9673

   aso_debug_pub.add('UPDATE_QUOTE: l_p_batch_qte_line_tbl.count: '||l_p_batch_qte_line_tbl.count,1,'N');

Line: 9674

   aso_debug_pub.add('UPDATE_QUOTE: l_p_batch_qte_line_dtl_tbl.count: '||l_p_batch_qte_line_dtl_tbl.count,1,'N');

Line: 9680

	  aso_debug_pub.add('UPDATE_QUOTE: l_model_qte_line_tbl('||i||').quote_line_id: '||l_model_qte_line_tbl(i).quote_line_id,1,'N');

Line: 9681

       aso_debug_pub.add('UPDATE_QUOTE: l_model_qte_line_dtl_tbl('||i||').config_header_id: '||l_model_qte_line_dtl_tbl(i).config_header_id,1,'N');

Line: 9682

       aso_debug_pub.add('UPDATE_QUOTE: l_model_qte_line_dtl_tbl('||i||').config_revision_num: '||l_model_qte_line_dtl_tbl(i).config_revision_num,1,'N');

Line: 9689

       IF l_delete_qte_line_tbl.EXISTS(l_model_qte_line_tbl(i).quote_line_id) THEN

           IF aso_debug_pub.g_debug_flag = 'Y' THEN
		 aso_debug_pub.add('UPDATE_QUOTE: Model line exist in l_delete_qte_line_tbl so it is already deleted along with children lines');

Line: 9706

				 aso_debug_pub.add('UPDATE_QUOTE: l_p_batch_qte_line_tbl('||j||').quote_line_id: '||l_p_batch_qte_line_tbl(j).quote_line_id,1,'N');

Line: 9707

                     aso_debug_pub.add('UPDATE_QUOTE: l_p_batch_qte_line_tbl('||j||').quantity: '||l_p_batch_qte_line_tbl(j).quantity,1,'N');

Line: 9708

                     aso_debug_pub.add('UPDATE_QUOTE: l_p_batch_qte_line_dtl_tbl('||j||').component_code: '||l_p_batch_qte_line_dtl_tbl(j).component_code,1,'N');

Line: 9719

		 aso_debug_pub.add('UPDATE_QUOTE: Before call to Validate_Configuration',1,'N');

Line: 9740

		     aso_debug_pub.add('UPDATE_QUOTE: After call to Validate_Configuration: l_return_status: '||l_return_status,1,'Y');

Line: 9741

		     aso_debug_pub.add('UPDATE_QUOTE: l_config_header_id:            '|| l_config_header_id,1,'N');

Line: 9742

		     aso_debug_pub.add('UPDATE_QUOTE: l_config_revision_num:         '|| l_config_revision_num,1,'N');

Line: 9743

		     aso_debug_pub.add('UPDATE_QUOTE: l_valid_configuration_flag:    '|| l_valid_configuration_flag,1,'N');

Line: 9744

		     aso_debug_pub.add('UPDATE_QUOTE: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');

Line: 9757

                       aso_debug_pub.add('Update Quote: A higher version exist for this configuration so deleting it from CZ');

Line: 9760

                   ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER  => 1.0,
                                                          P_INIT_MSG_LIST       => FND_API.G_FALSE,
                                                          P_CONFIG_HDR_ID       => l_config_header_id,
                                                          P_CONFIG_REV_NBR      => l_config_revision_num,
                                                          X_RETURN_STATUS       => x_return_status,
                                                          X_MSG_COUNT           => x_msg_count,
                                                          X_MSG_DATA            => x_msg_data);

Line: 9769

                       aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION_AUTO: x_Return_Status: ' || x_Return_Status);

Line: 9775

                          FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

Line: 9798

       END IF; --l_delete_qte_line_tbl.EXISTS

Line: 9803

       aso_debug_pub.add('Update_Quote: l_deactivate_quote_line_tbl.count: ' || l_deactivate_quote_line_tbl.count);

Line: 9828

              p_delete_flag        => fnd_api.g_false,
              x_Qte_Header_Rec     => x_Qte_Header_Rec,
              x_return_status      => x_return_status,
              x_msg_count          => x_msg_count,
              x_msg_data           => x_msg_data);

Line: 9843

              p_delete_flag            => fnd_api.g_false,
              X_qte_header_rec        => x_Qte_Header_Rec,
              X_Return_Status           => X_Return_Status,
              X_Msg_Count              => X_Msg_Count,
              X_Msg_Data               => X_Msg_Data );

Line: 9886

	    ASO_PRICE_RLTSHIPS_PKG.Insert_Row(
		px_ADJ_RELATIONSHIP_ID	=> l_price_adj_rltship_rec.ADJ_RELATIONSHIP_ID,
		p_creation_date		=> sysdate,
		p_CREATED_BY		=> G_USER_ID,
		p_LAST_UPDATE_DATE	=> sysdate,
		p_LAST_UPDATED_BY	=> G_USER_ID,
		p_LAST_UPDATE_LOGIN	=> G_USER_ID,
		p_PROGRAM_APPLICATION_ID=> l_price_adj_rltship_rec.PROGRAM_APPLICATION_ID,
		p_PROGRAM_ID		=> l_price_adj_rltship_rec.PROGRAM_ID,
		p_PROGRAM_UPDATE_DATE	=> l_price_adj_rltship_rec.PROGRAM_UPDATE_DATE,
		p_REQUEST_ID		=> l_price_adj_rltship_rec.REQUEST_ID,
		p_QUOTE_LINE_ID		=> l_price_adj_rltship_rec.quote_line_id,
		p_PRICE_ADJUSTMENT_ID	=> l_price_adj_rltship_rec.price_adjustment_id,
		p_RLTD_PRICE_ADJ_ID	=> l_price_adj_rltship_rec.rltd_price_adj_id,
		p_QUOTE_SHIPMENT_ID	=> l_price_adj_rltship_rec.quote_shipment_id,
		p_OBJECT_VERSION_NUMBER => l_price_adj_rltship_rec.OBJECT_VERSION_NUMBER
		);

Line: 9903

	ELSIF l_price_adj_rltship_rec.operation_code = 'UPDATE' THEN
	    ASO_PRICE_RLTSHIPS_PKG.Update_Row(
		p_ADJ_RELATIONSHIP_ID  => l_price_adj_rltship_rec.ADJ_RELATIONSHIP_ID,
		p_creation_date		=> l_price_adj_rltship_rec.creation_date,
		p_CREATED_BY		=> G_USER_ID,
		p_LAST_UPDATE_DATE	=> sysdate,
		p_LAST_UPDATED_BY	=> G_USER_ID,
		p_LAST_UPDATE_LOGIN	=> G_USER_ID,
		p_PROGRAM_APPLICATION_ID=> l_price_adj_rltship_rec.PROGRAM_APPLICATION_ID,
		p_PROGRAM_ID		=> l_price_adj_rltship_rec.PROGRAM_ID,
		p_PROGRAM_UPDATE_DATE	=> l_price_adj_rltship_rec.PROGRAM_UPDATE_DATE,
		p_REQUEST_ID		=> l_price_adj_rltship_rec.REQUEST_ID,
		p_QUOTE_LINE_ID		=> l_price_adj_rltship_rec.quote_line_id,
		p_PRICE_ADJUSTMENT_ID	=> l_price_adj_rltship_rec.price_adjustment_id,
		p_RLTD_PRICE_ADJ_ID	=> l_price_adj_rltship_rec.rltd_price_adj_id,
		p_QUOTE_SHIPMENT_ID	=> l_price_adj_rltship_rec.quote_shipment_id,
		p_OBJECT_VERSION_NUMBER => l_price_adj_rltship_rec.OBJECT_VERSION_NUMBER
		);

Line: 9921

	ELSIF l_price_adj_rltship_rec.operation_code = 'DELETE' THEN
	    ASO_PRICE_RLTSHIPS_PKG.Delete_Row(
		p_ADJ_RELATIONSHIP_ID  => l_price_adj_rltship_rec.ADJ_RELATIONSHIP_ID);

Line: 9948

	    ASO_LINE_RELATIONSHIPS_PKG.Insert_Row(
		px_LINE_RELATIONSHIP_ID  => l_line_rltship_rec.LINE_RELATIONSHIP_ID,
		p_CREATION_DATE  => SYSDATE,
		p_CREATED_BY  => G_USER_ID,
		p_LAST_UPDATED_BY  => G_USER_ID,
		p_LAST_UPDATE_DATE  => SYSDATE,
		p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
		p_REQUEST_ID  => l_line_rltship_rec.REQUEST_ID,
		p_PROGRAM_APPLICATION_ID  => l_line_rltship_rec.PROGRAM_APPLICATION_ID,
		p_PROGRAM_ID  => l_line_rltship_rec.PROGRAM_ID,
		p_PROGRAM_UPDATE_DATE  =>l_line_rltship_rec.PROGRAM_UPDATE_DATE,
		p_QUOTE_LINE_ID  => l_line_rltship_rec.quote_line_id,
		p_RELATED_QUOTE_LINE_ID  => l_line_rltship_rec.RELATED_QUOTE_LINE_ID,
		p_RECIPROCAL_FLAG  => l_line_rltship_rec.RECIPROCAL_FLAG,
		P_RELATIONSHIP_TYPE_CODE =>l_line_rltship_rec.RELATIONSHIP_TYPE_CODE,
		p_OBJECT_VERSION_NUMBER => l_line_rltship_rec.OBJECT_VERSION_NUMBER
		);

Line: 9965

	ELSIF l_line_rltship_rec.operation_code = 'UPDATE' THEN
	    ASO_LINE_RELATIONSHIPS_PKG.Update_Row(
		p_LINE_RELATIONSHIP_ID	=> l_line_rltship_rec.LINE_RELATIONSHIP_ID,
		p_CREATION_DATE  => l_line_rltship_rec.creation_date,
		p_CREATED_BY  => G_USER_ID,
		p_LAST_UPDATED_BY  => G_USER_ID,
		p_LAST_UPDATE_DATE  => SYSDATE,
		p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
		p_REQUEST_ID  => l_line_rltship_rec.REQUEST_ID,
		p_PROGRAM_APPLICATION_ID  => l_line_rltship_rec.PROGRAM_APPLICATION_ID,
		p_PROGRAM_ID  => l_line_rltship_rec.PROGRAM_ID,
		p_PROGRAM_UPDATE_DATE  =>l_line_rltship_rec.PROGRAM_UPDATE_DATE,
		p_QUOTE_LINE_ID  => l_line_rltship_rec.quote_line_id,
		p_RELATED_QUOTE_LINE_ID  => l_line_rltship_rec.RELATED_QUOTE_LINE_ID,
		p_RECIPROCAL_FLAG  => l_line_rltship_rec.RECIPROCAL_FLAG,
		P_RELATIONSHIP_TYPE_CODE =>l_line_rltship_rec.RELATIONSHIP_TYPE_CODE,
		p_OBJECT_VERSION_NUMBER => l_line_rltship_rec.OBJECT_VERSION_NUMBER
		);

Line: 9983

	ELSIF l_line_rltship_rec.operation_code = 'DELETE' THEN
	    ASO_LINE_RELATIONSHIPS_PKG.delete_Row(
		p_LINE_RELATIONSHIP_ID	=> l_line_rltship_rec.LINE_RELATIONSHIP_ID);

Line: 9990

 	   aso_debug_pub.add('Update_Quote: l_line_rltship_rec.quote_line_id:         '||l_line_rltship_rec.quote_line_id);

Line: 9991

        aso_debug_pub.add('Update_Quote: l_line_rltship_rec.related_quote_line_id: '||l_line_rltship_rec.related_quote_line_id);

Line: 9996

         l_line_rltship_rec.operation_code = 'UPDATE') then

          update aso_quote_line_details
          set ref_type_code      =  'CONFIG',
              ref_line_id        =  l_line_rltship_rec.quote_line_id,
              last_update_date   =  sysdate,
              last_updated_by    =  g_user_id,
              last_update_login  =  g_login_id
          where quote_line_id = l_line_rltship_rec.related_quote_line_id;

Line: 10011

	   aso_debug_pub.add('Update_Quote: x_qte_header_rec.quote_header_id: '|| x_qte_header_rec.quote_header_id);

Line: 10014

     update aso_quote_line_details
     set ref_type_code      =  'CONFIG',
         last_update_date   =  sysdate,
         last_updated_by    =  g_user_id,
         last_update_login  =  g_login_id
     where config_header_id is not null
     and config_revision_num is not null
     and ref_type_code is null
     and quote_line_id in (select quote_line_id from aso_quote_lines_all
                           where item_type_code = 'MDL'
                           and quote_header_id  = x_qte_header_rec.quote_header_id);

Line: 10027

	   aso_debug_pub.add('Update_Quote: Validating line type if Order type has changed');

Line: 10028

       aso_debug_pub.add('Update_Quote: l_qte_header_rec.order_type_id: '||l_qte_header_rec.order_type_id);

Line: 10088

	     aso_debug_pub.add('Update_Quote - before header_pricing ', 1, 'N');

Line: 10095

	       aso_debug_pub.add('Update_Quote - in header_pricing ', 1, 'N');

Line: 10113

            aso_debug_pub.add('Update_Quote: Before call to ASO_PRICING_INT.Pricing_Order');

Line: 10114

            aso_debug_pub.add('Update_Quote: x_qte_line_tbl.count:  ' || x_qte_line_tbl.count);

Line: 10144

            aso_debug_pub.add('Update_Quote: After call to ASO_PRICING_INT.Pricing_Order');

Line: 10145

	       aso_debug_pub.add('Update_Quote: l_return_status:       ' || l_return_status);

Line: 10146

            aso_debug_pub.add('Update_Quote: lx_qte_line_tbl.count: ' || lx_qte_line_tbl.count);

Line: 10147

            aso_debug_pub.add('Update_Quote: x_qte_line_tbl.count:  ' || x_qte_line_tbl.count);

Line: 10174

     /*New Pricing Changes to update the date*/


     IF p_control_rec.header_pricing_event = 'BATCH' and
        p_control_rec.price_mode='ENTIRE_QUOTE' THEN

          l_price_updated_date_flag := fnd_api.g_true;

Line: 10192

		SELECT
			COUNT(QUOTE_HEADER_ID)
		INTO
			l_lines
		FROM
			ASO_QUOTE_LINES_ALL
		WHERE
			QUOTE_HEADER_ID=x_qte_header_rec.quote_header_id;

Line: 10204

         l_tax_control_rec.update_DB := 'Y';

Line: 10220

	    aso_debug_pub.add('Update_Quote: Before call to tax engine');

Line: 10231

	    aso_debug_pub.add('Update_Quote: After call to tax engine');

Line: 10235

		aso_debug_pub.add('Update_Quote: NO LINE RECORDS.SO TAX NOT CALCULATED : x_return_status: '|| x_return_status, 1, 'Y');

Line: 10257

      /*New Tax Changes to update the date*/

	 IF aso_debug_pub.g_debug_flag = 'Y' THEN

	    aso_debug_pub.add('Update_Quote: control record parameter values');

Line: 10265

	    aso_debug_pub.add('l_price_updated_date_flag:          ' || l_price_updated_date_flag);

Line: 10271

          IF l_price_updated_date_flag = fnd_api.g_true THEN

              update aso_quote_headers_all
              set tax_updated_date   = sysdate,
                  price_updated_date = sysdate,
			   recalculate_flag   = 'N'
              where quote_header_id = x_qte_header_rec.quote_header_id;

Line: 10281

              update aso_quote_headers_all
              set tax_updated_date   = sysdate
              where quote_header_id = x_qte_header_rec.quote_header_id;

Line: 10287

      ELSIF l_price_updated_date_flag = fnd_api.g_true THEN

          update aso_quote_headers_all
          set price_updated_date = sysdate,
		    recalculate_flag   = 'N'
          where quote_header_id = x_qte_header_rec.quote_header_id;

Line: 10325

          aso_debug_pub.add('Update_Quote - Value of Installment Option Param: '||l_installment_option, 1, 'Y');

Line: 10335

             aso_debug_pub.add('Update_Quote - p_control_rec.header_pricing_event: '||p_control_rec.header_pricing_event, 1, 'Y');

Line: 10336

             aso_debug_pub.add('Update_Quote - p_control_rec.price_mode          : '||p_control_rec.price_mode, 1, 'Y');

Line: 10337

             aso_debug_pub.add('Update_Quote - l_qte_line_tbl.count              : '||l_qte_line_tbl.count, 1, 'Y');

Line: 10345

			    if (l_qte_line_tbl(i).operation_code = 'CREATE' or l_qte_line_tbl(i).operation_code = 'UPDATE')  then
			     l_call_ar_api :=  fnd_api.g_true;

Line: 10356

              aso_debug_pub.add('Update_Quote - l_call_ar_api: '|| l_call_ar_api, 1, 'Y');

Line: 10391

		aso_debug_pub.add('Update_Quote - ********** Input to AR_VIEW_TERM_GRP.pay_now_amounts follows ********** ', 1, 'Y');

Line: 10392

		aso_debug_pub.add('Update_Quote - quote_lines_rec.quote_line_id: '||quote_lines_rec.quote_line_id, 1, 'Y');

Line: 10393

          aso_debug_pub.add('Update_Quote - l_line_amount:                 '||l_line_amount, 1, 'Y');

Line: 10394

          aso_debug_pub.add('Update_Quote - l_line_shipping_charge:        '||l_line_shipping_charge, 1, 'Y');

Line: 10395

          aso_debug_pub.add('Update_Quote - l_line_tax:                    '||l_line_tax, 1, 'Y');

Line: 10396

          aso_debug_pub.add('Update_Quote - l_line_term_id:                '||l_line_term_id, 1, 'Y');

Line: 10402

          aso_debug_pub.add('Update_Quote: before call to AR_VIEW_TERM_GRP.pay_now_amounts', 1, 'Y');

Line: 10424

		    aso_debug_pub.add('Update_Quote: After call to AR_VIEW_TERM_GRP.pay_now_amounts: x_return_status: '|| x_return_status, 1, 'Y');          END IF;

Line: 10443

        aso_debug_pub.add('Update_Quote - Output from AR_VIEW_TERM_GRP.pay_now_amounts follows:', 1, 'Y');

Line: 10444

        aso_debug_pub.add('Update_Quote - l_paynow_amount:         '||l_paynow_amount, 1, 'Y');

Line: 10445

        aso_debug_pub.add('Update_Quote - l_paynow_charges:        '||l_paynow_charges, 1, 'Y');

Line: 10446

        aso_debug_pub.add('Update_Quote - l_paynow_tax:            '||l_paynow_tax, 1, 'Y');

Line: 10447

        aso_debug_pub.add('Update_Quote - l_paynow_total:          '||l_paynow_total, 1, 'Y');

Line: 10448

        aso_debug_pub.add('Update_Quote - ************  End  PNPL Processing ************ ', 1, 'Y');

Line: 10453

          update aso_quote_lines_all
          set line_paynow_charges    = l_paynow_charges,
              line_paynow_tax        = l_paynow_tax,
              line_paynow_subtotal   = l_paynow_amount,
              last_update_date       =  sysdate,
              last_updated_by        =  fnd_global.user_id,
              last_update_login      =  fnd_global.conc_login_id
          where quote_line_id = quote_lines_rec.quote_line_id;

Line: 10470

      Update_Quote_Total (
			P_Qte_Header_id		  => x_Qte_Header_rec.quote_header_id,
			P_Calculate_Tax		  => p_control_rec.calculate_tax_flag,
			P_calculate_Freight_Charge => p_control_rec.calculate_freight_charge_flag,
               p_control_rec		       =>  p_control_rec,
               P_Call_Ar_Api_Flag         => l_call_ar_api,
			X_Return_Status 	       => x_return_status,
			X_Msg_Count		       => x_msg_count,
			X_Msg_Data		       => x_msg_data);

Line: 10509

		aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT.UPDATE_QUOTE : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || x_qte_header_rec.quote_number, 1, 'Y');

Line: 10513

      ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(x_qte_header_rec.quote_number);

Line: 10565

End Update_quote;

Line: 10570

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: 10585

	SELECT quote_line_id FROM ASO_QUOTE_LINES_ALL
	WHERE quote_header_id = p_qte_header_id;

Line: 10590

    SELECT quote_line_id  FROM ASO_QUOTE_LINES_ALL
    where quote_line_id= l_qte_line_rec.quote_line_id;

Line: 10594

      SAVEPOINT DELETE_quote_PVT;

Line: 10622

	 aso_debug_pub.add('Delete_Quote - Begin ', 1, 'Y');

Line: 10625

      ASO_QUOTE_HEADERS_PKG.Delete_Row(
	  p_QUOTE_HEADER_ID  => p_qte_header_id);

Line: 10631

	 aso_debug_pub.add('Delete_Quote - before delete_line- quote_line_id: '|| l_qte_line_rec.quote_line_id, 1, 'N');

Line: 10637

	  ASO_QUOTE_LINES_PVT.Delete_Quote_Line(
		P_Api_Version_Number	=> 1.0,
		P_qte_line_Rec		=> l_qte_line_rec,
		P_Update_Header_Flag	=> FND_API.G_FALSE,
		X_Return_Status 	=> X_Return_Status,
		X_Msg_Count		=> X_Msg_Count,
		X_Msg_Data		=> X_Msg_Data);

Line: 10655

	 aso_debug_pub.add('Delete_Quote: Before deleting ASO_PRICE_ADJUSTMENTS table data',1,'N');

Line: 10658

      DELETE FROM ASO_PRICE_ADJUSTMENTS
      WHERE QUOTE_HEADER_ID = p_qte_header_id;

Line: 10662

	 aso_debug_pub.add('Delete_Quote: Before deleting ASO_PRICE_ADJ_ATTRIBS table data',1,'N');

Line: 10665

      DELETE FROM aso_price_adj_attribs
      WHERE price_adjustment_id IN (select price_adjustment_id
                                   from aso_price_adjustments
                                   where quote_header_id = p_qte_header_id
                                   and quote_line_id is NULL);

Line: 10672

	 aso_debug_pub.add('Delete_Quote: Before deleting ASO_PRICE_ATTRIBUTES table data',1,'N');

Line: 10675

      DELETE FROM ASO_PRICE_ATTRIBUTES
      WHERE QUOTE_HEADER_ID = p_qte_header_id
            and quote_line_id is NULL;

Line: 10680

	 aso_debug_pub.add('Delete_Quote: After deleting ASO_PRICE_ATTRIBUTES table data',1,'N');

Line: 10687

      DELETE FROM ASO_PAYMENTS
	 WHERE QUOTE_HEADER_ID = p_qte_header_id;

Line: 10690

      DELETE FROM ASO_FREIGHT_CHARGES
	 WHERE quote_shipment_id in
		(select shipment_id from  ASO_SHIPMENTS
		  where QUOTE_HEADER_ID = p_qte_header_id);

Line: 10695

      DELETE FROM ASO_SHIPMENTS
	 WHERE QUOTE_HEADER_ID = p_qte_header_id;

Line: 10698

      DELETE FROM ASO_TAX_DETAILS
	 WHERE QUOTE_HEADER_ID = p_qte_header_id;

Line: 10701

      DELETE FROM ASO_SALES_CREDITS
	 WHERE QUOTE_HEADER_ID = p_qte_header_id;

Line: 10705

      DELETE FROM ASO_QUOTE_PARTIES
	 WHERE QUOTE_HEADER_ID = p_qte_header_id;

Line: 10708

      DELETE FROM ASO_QUOTE_LINE_ATTRIBS_EXT
    	 WHERE QUOTE_HEADER_ID = p_qte_header_id;

Line: 10764

End Delete_quote;

Line: 10784

    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
/*  -- original cpy_qte
    CURSOR C_Validate_Quote (x_qte_header_id NUMBER) IS
	SELECT 'X'
	FROM ASO_QUOTE_HEADERS_ALL
	WHERE quote_header_id = x_qte_header_id;

Line: 10803

	SELECT LINE_RELATIONSHIP_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
QUOTE_LINE_ID,
RELATED_QUOTE_LINE_ID,
RELATIONSHIP_TYPE_CODE,
RECIPROCAL_FLAG FROM ASO_LINE_RELATIONSHIPS
	WHERE quote_line_id IN
		(SELECT quote_line_id FROM aso_quote_lines_all
		 WHERE quote_header_id = x_quote_header_id)
	  AND related_quote_line_id IN
		(SELECT quote_line_id FROM aso_quote_lines_all
		 WHERE quote_header_id = x_quote_header_id);

Line: 10829

	SELECT LINE_RELATIONSHIP_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
QUOTE_LINE_ID,
RELATED_QUOTE_LINE_ID,
RELATIONSHIP_TYPE_CODE,
RECIPROCAL_FLAG FROM ASO_LINE_RELATIONSHIPS
	WHERE EXISTS
		(SELECT 'x' FROM aso_quote_lines_all aql
		 WHERE aql.quote_header_id = x_quote_header_id
                 AND aql.quote_line_id = aso_line_relationships.quote_line_id)
	  AND EXISTS
                (SELECT 'x' FROM aso_quote_lines_all aql
		 WHERE aql.quote_header_id = x_quote_header_id
                 AND aql.quote_line_id = aso_line_relationships.related_quote_line_id);

Line: 10858

	SELECT
    QUOTE_SHIPMENT_ID,
SECURITY_GROUP_ID,
OBJECT_VERSION_NUMBER,
ADJ_RELATIONSHIP_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
QUOTE_LINE_ID,
PRICE_ADJUSTMENT_ID,
RLTD_PRICE_ADJ_ID
 FROM ASO_PRICE_ADJ_RELATIONSHIPS
	WHERE price_adjustment_id IN
		(SELECT price_adjustment_id FROM aso_price_adjustments
		 WHERE quote_header_id = x_quote_header_id)
	  AND quote_line_id IN
		(SELECT quote_line_id FROM aso_quote_lines_all
		 WHERE quote_header_id = x_quote_header_id);

Line: 10885

        SELECT
apr.QUOTE_SHIPMENT_ID,
--apr.SECURITY_GROUP_ID,
apr.OBJECT_VERSION_NUMBER,
apr.ADJ_RELATIONSHIP_ID,
apr.CREATION_DATE,
apr.CREATED_BY,
apr.LAST_UPDATE_DATE,
apr.LAST_UPDATED_BY,
apr.LAST_UPDATE_LOGIN,
apr.PROGRAM_APPLICATION_ID,
apr.PROGRAM_ID,
apr.PROGRAM_UPDATE_DATE,
apr.REQUEST_ID,
apr.QUOTE_LINE_ID,
apr.PRICE_ADJUSTMENT_ID,
apr.RLTD_PRICE_ADJ_ID
FROM ASO_PRICE_ADJ_RELATIONSHIPS apr,
     ASO_PRICE_ADJUSTMENTS apa
WHERE apr.price_adjustment_id = apa.price_adjustment_id
AND apa.quote_header_id = x_quote_header_id
AND EXISTS (select 'x' from aso_quote_lines_all aql
            where aql.quote_header_id = x_quote_header_id
            and aql.quote_line_id = apr.quote_line_id);

Line: 10913

	SELECT ASO_QUOTE_NUMBER_S.nextval
	FROM sys.dual;

Line: 10917

	SELECT max(quote_version)
	FROM ASO_QUOTE_HEADERS_ALL
	WHERE quote_number = X_qte_number;

Line: 10922

	SELECT quote_status_id
	FROM ASO_QUOTE_STATUSES_B
	WHERE status_code = c_status_code;

Line: 10928

	SELECT enabled_flag
	FROM ASO_QUOTE_STATUS_TRANSITIONS
	WHERE from_status_id = from_id AND to_status_id = to_id;

Line: 10933

     SELECT quote_number
     FROM ASO_QUOTE_HEADERS_ALL
     WHERE quote_number = X_qte_number;

Line: 10950

     SELECT Quote_Expiration_Date, Resource_Id, Resource_Grp_Id
     FROM ASO_QUOTE_HEADERS_ALL
     WHERE Quote_Header_Id = qte_hdr_id;

Line: 11099

	aso_debug_pub.add('Copy_Quote - P_Last_Update_Date '||P_Last_Update_Date, 1, 'N');

Line: 11226

      ASO_HEADER_RELATIONSHIPS_PKG.Insert_Row(
	  px_HEADER_RELATIONSHIP_ID  => l_HEADER_RELATIONSHIP_ID,
	  p_CREATION_DATE  => SYSDATE,
	  p_CREATED_BY	=> G_USER_ID,
	  p_LAST_UPDATE_DATE  => SYSDATE,
	  p_LAST_UPDATED_BY  => G_USER_ID,
	  p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
	  p_REQUEST_ID	=> NULL,
	  p_PROGRAM_APPLICATION_ID  => NULL,
	  p_PROGRAM_ID	=> NULL,
	  p_PROGRAM_UPDATE_DATE  => NULL,
	  p_QUOTE_HEADER_ID  => p_qte_header_id,
	  p_RELATED_HEADER_ID  => x_qte_header_id,
	  p_RELATIONSHIP_TYPE_CODE  => 'COPY',
	  p_RECIPROCAL_FLAG  => NULL,
	  P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
	  );

Line: 11550

PROCEDURE Gen_Select(
    x_select_cl   OUT NOCOPY /* file.sql.39 change */    	VARCHAR2
)
IS
BEGIN

      x_select_cl := 'Select ' ||
		'ASO_QUOTE_HEADERS_V.ROW_ID,' ||
		'ASO_QUOTE_HEADERS_V.QUOTE_HEADER_ID,' ||
		'ASO_QUOTE_HEADERS_V.ORG_ID,' ||
		'ASO_QUOTE_HEADERS_V.LAST_UPDATE_DATE,' ||
		'ASO_QUOTE_HEADERS_V.LAST_UPDATED_BY,' ||
		'ASO_QUOTE_HEADERS_V.CREATION_DATE,' ||
		'ASO_QUOTE_HEADERS_V.CREATED_BY,' ||
		'ASO_QUOTE_HEADERS_V.LAST_UPDATE_LOGIN,' ||
		'ASO_QUOTE_HEADERS_V.REQUEST_ID,' ||
		'ASO_QUOTE_HEADERS_V.PROGRAM_APPLICATION_ID,' ||
		'ASO_QUOTE_HEADERS_V.PROGRAM_ID,' ||
		'ASO_QUOTE_HEADERS_V.PROGRAM_UPDATE_DATE,' ||
		'ASO_QUOTE_HEADERS_V.ORIGINAL_SYSTEM_REFERENCE,' ||
		'ASO_QUOTE_HEADERS_V.EMPLOYEE_PERSON_ID,' ||
		'ASO_QUOTE_HEADERS_V.SALESREP_FIRST_NAME,' ||
		'ASO_QUOTE_HEADERS_V.SALESREP_LAST_NAME,' ||
		'ASO_QUOTE_HEADERS_V.PRICE_LIST_ID,' ||
		'ASO_QUOTE_HEADERS_V.PRICE_LIST_NAME,' ||
		'ASO_QUOTE_HEADERS_V.QUOTE_STATUS_ID,' ||
		'ASO_QUOTE_HEADERS_V.QUOTE_STATUS_CODE,' ||
		'ASO_QUOTE_HEADERS_V.QUOTE_STATUS,' ||
		'ASO_QUOTE_HEADERS_V.UPDATE_ALLOWED_FLAG,' ||
		'ASO_QUOTE_HEADERS_V.AUTO_VERSION_FLAG,' ||
		'ASO_QUOTE_HEADERS_V.QUOTE_SOURCE_CODE,' ||
		'ASO_QUOTE_HEADERS_V.PARTY_ID,' ||
		'ASO_QUOTE_HEADERS_V.PARTY_NAME,' ||
		'ASO_QUOTE_HEADERS_V.PARTY_TYPE,' ||
		'ASO_QUOTE_HEADERS_V.PERSON_FIRST_NAME,' ||
		'ASO_QUOTE_HEADERS_V.PERSON_MIDDLE_NAME,' ||
		'ASO_QUOTE_HEADERS_V.PERSON_LAST_NAME,' ||
		'ASO_QUOTE_HEADERS_V.ORG_CONTACT_ID,' ||
		'ASO_QUOTE_HEADERS_V.CONTACT_FIRST_NAME,' ||
		'ASO_QUOTE_HEADERS_V.CONTACT_MIDDLE_NAME,' ||
		'ASO_QUOTE_HEADERS_V.CONTACT_LAST_NAME,' ||
		'ASO_QUOTE_HEADERS_V.QUOTE_NAME,' ||
		'ASO_QUOTE_HEADERS_V.QUOTE_NUMBER,' ||
		'ASO_QUOTE_HEADERS_V.QUOTE_VERSION,' ||
		'ASO_QUOTE_HEADERS_V.QUOTE_EXPIRATION_DATE,' ||
		'ASO_QUOTE_HEADERS_V.QUOTE_CATEGORY_CODE,' ||
		'ASO_QUOTE_HEADERS_V.CURRENCY_CODE,' ||
		'ASO_QUOTE_HEADERS_V.EXCHANGE_RATE,' ||
		'ASO_QUOTE_HEADERS_V.EXCHANGE_TYPE_CODE,' ||
		'ASO_QUOTE_HEADERS_V.EXCHANGE_RATE_DATE,' ||
		'ASO_QUOTE_HEADERS_V.SOURCE_CAMPAIGN_ID,' ||
		'ASO_QUOTE_HEADERS_V.CAMPAIGN_ID,' ||
		'ASO_QUOTE_HEADERS_V.CAMPAIGN_NAME,' ||
		'ASO_QUOTE_HEADERS_V.CAMPAIGN_SOURCE_CODE,' ||
		'ASO_QUOTE_HEADERS_V.ORDERED_DATE,' ||
		'ASO_QUOTE_HEADERS_V.ORDER_TYPE_ID,' ||
		'ASO_QUOTE_HEADERS_V.ORDER_TYPE_NAME,' ||
		'ASO_QUOTE_HEADERS_V.TAX_EXEMPT_NUMBER,' ||
		'ASO_QUOTE_HEADERS_V.TAX_EXEMPT_REASON_CODE,' ||
		'ASO_QUOTE_HEADERS_V.TAX_EXEMPT_FLAG,' ||
		'ASO_QUOTE_HEADERS_V.TOTAL_LIST_PRICE,' ||
		'ASO_QUOTE_HEADERS_V.TOTAL_ADJUSTED_AMOUNT,' ||
		'ASO_QUOTE_HEADERS_V.TOTAL_ADJUSTED_PERCENT,' ||
		'ASO_QUOTE_HEADERS_V.TOTAL_TAX,' ||
		'ASO_QUOTE_HEADERS_V.SURCHARGE,' ||
		'ASO_QUOTE_HEADERS_V.TOTAL_SHIPPING_CHARGE,' ||
		'ASO_QUOTE_HEADERS_V.TOTAL_QUOTE_PRICE,' ||
		'ASO_QUOTE_HEADERS_V.ACCOUNTING_RULE_ID,' ||
		'ASO_QUOTE_HEADERS_V.INVOICING_RULE_ID,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_METHOD_CODE,' ||
		'ASO_QUOTE_HEADERS_V.FREIGHT_TERMS_CODE,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_PARTY_ID,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_PARTY_SITE_ID,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_PARTY_NAME,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_CONTACT_FIRST_NAME,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_CONTACT_MIDDLE_NAME,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_CONTACT_LAST_NAME,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_ADDRESS1,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_ADDRESS2,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_ADDRESS3,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_ADDRESS4,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_COUNTRY_CODE,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_COUNTRY,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_CITY,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_POSTAL_CODE,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_STATE,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_PROVINCE,' ||
		'ASO_QUOTE_HEADERS_V.SHIP_TO_COUNTY,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_PARTY_ID,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_PARTY_SITE_ID,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_PARTY_NAME,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_CONTACT_FIRST_NAME,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_CONTACT_MIDDLE_NAME,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_CONTACT_LAST_NAME,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_ADDRESS1,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_ADDRESS2,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_ADDRESS3,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_ADDRESS4,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_COUNTRY_CODE,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_COUNTRY,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_CITY,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_POSTAL_CODE,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_STATE,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_PROVINCE,' ||
		'ASO_QUOTE_HEADERS_V.INVOICE_TO_COUNTY,' ||
		'ASO_QUOTE_HEADERS_V.SHIPPING_INSTRUCTIONS,' ||
		'ASO_QUOTE_HEADERS_V.PACKING_INSTRUCTIONS,' ||
		'ASO_QUOTE_HEADERS_V.CONTRACT_ID,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE_CATEGORY,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE1,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE2,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE3,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE4,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE5,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE6,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE7,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE8,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE9,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE10,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE11,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE12,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE13,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE14,' ||
		'ASO_QUOTE_HEADERS_V.ATTRIBUTE15,' ||
		'from ASO_QUOTE_HEADERS_V';

Line: 11676

END Gen_Select;

Line: 11687

    SELECT INSTR(p_rec_item, '%', 1, 1)
    FROM DUAL;

Line: 11690

    SELECT INSTR(p_rec_item, '_', 1, 1)
    FROM DUAL;

Line: 11832

l_select_cl		 VARCHAR2(2000) := '';

Line: 11880

      Gen_Select(l_select_cl);

Line: 11976

		  -- insert into resultant tables
		  X_Qte_Header_Tbl(l_returned_rec_count) := l_qte_header_rec;

Line: 12112

 SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
  FROM ASO_Quote_Line_Details, ASO_Quote_Lines_all
  WHERE ASO_Quote_Line_Details.config_header_id = p_old_config_header_id
  AND ASO_Quote_Line_Details.config_revision_num = p_old_config_revision_num
   AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
    AND ASO_Quote_Lines_all.item_type_code <> 'MDL'
    AND aso_quote_lines_all.quote_header_id = qte_header_id;

Line: 12165

     SELECT serviceable_product_flag FROM MTL_SYSTEM_ITEMS_VL
     WHERE inventory_item_id = l_inv_item_id
	 AND organization_id = l_organization_id;

Line: 12251

    ASO_QUOTE_LINES_PVT.Insert_Quote_Line_Rows (
              p_control_rec       => l_control_rec,
              P_qte_Line_Rec      => l_qte_line_rec,
              P_qte_line_dtl_tbl  => l_qte_line_dtl_tbl,
              P_Line_Attribs_Ext_Tbl   => l_line_attr_ext_tbl,
              P_price_attributes_tbl   => l_price_attr_tbl,
              P_Price_Adj_Tbl          => l_price_adj_tbl,
              P_Price_Adj_Attr_Tbl     => l_Price_Adj_Attr_Tbl,
              P_Payment_Tbl       => l_payment_tbl,
              P_Shipment_Tbl      => l_shipment_tbl,
              P_Freight_Charge_Tbl     => l_freight_charge_tbl,
              P_Tax_Detail_Tbl    => l_tax_detail_tbl,
              P_Sales_Credit_Tbl   => l_sales_credit_tbl,
              P_Quote_Party_Tbl   => l_quote_party_tbl,
              x_qte_Line_Rec      => lx_qte_line_rec,
              x_qte_line_dtl_tbl  => l_qte_line_dtl_tbl_out,
               x_Line_Attribs_Ext_Tbl   => l_line_attr_Ext_Tbl_out,
               x_price_attributes_tbl   => l_price_attr_tbl_out,
               x_Price_Adj_Tbl          => lx_ln_price_adj_tbl,
               x_Price_Adj_Attr_Tbl     => l_Price_Adj_Attr_Tbl_out,
               x_Payment_Tbl       => l_payment_tbl_out,
               x_Shipment_Tbl      => l_shipment_tbl_out,
               x_Freight_Charge_Tbl     => l_freight_charge_tbl_out,
               x_Tax_Detail_Tbl    => l_tax_detail_tbl_out,
               X_Sales_Credit_Tbl  => l_sales_credit_tbl_out,
               X_Quote_Party_Tbl   => l_quote_party_tbl_out,
               X_Return_Status     => l_return_status,
               X_Msg_Count         => x_msg_count,
               X_Msg_Data          => x_msg_data);

Line: 12401

 SELECT related_quote_line_id
  FROM aso_line_relationships
  WHERE quote_line_id = p_qte_line_id
  AND relationship_type_code = 'SERVICE';

Line: 12541

    ASO_QUOTE_LINES_PVT.Insert_Quote_Line_Rows (
              p_control_rec       => l_control_rec,
              P_qte_Line_Rec      => l_qte_line_rec,
              P_qte_line_dtl_tbl  => l_qte_line_dtl_tbl,
              P_Line_Attribs_Ext_Tbl   => l_line_attr_ext_tbl,
              P_price_attributes_tbl   => l_price_attr_tbl,
              P_Price_Adj_Tbl          => l_price_adj_tbl,
              P_Price_Adj_Attr_Tbl     => l_Price_Adj_Attr_Tbl,
              P_Payment_Tbl       => l_payment_tbl,
              P_Shipment_Tbl      => l_shipment_tbl,
              P_Freight_Charge_Tbl     => l_freight_charge_tbl,
              P_Tax_Detail_Tbl    => l_tax_detail_tbl,
              P_Sales_Credit_Tbl   => l_sales_credit_tbl,
              P_Quote_Party_Tbl   => l_quote_party_tbl,
              x_qte_Line_Rec      => lx_qte_line_rec,
              x_qte_line_dtl_tbl  => l_qte_line_dtl_tbl_out,
               x_Line_Attribs_Ext_Tbl   => l_line_attr_Ext_Tbl_out,
               x_price_attributes_tbl   => l_price_attr_tbl_out,
               x_Price_Adj_Tbl          => lx_ln_price_adj_tbl,
               x_Price_Adj_Attr_Tbl     => l_Price_Adj_Attr_Tbl_out,
               x_Payment_Tbl       => l_payment_tbl_out,
               x_Shipment_Tbl      => l_shipment_tbl_out,
               x_Freight_Charge_Tbl     => l_freight_charge_tbl_out,
               x_Tax_Detail_Tbl    => l_tax_detail_tbl_out,
               X_Sales_Credit_Tbl  => l_sales_credit_tbl_out,
               X_Quote_Party_Tbl   => l_quote_party_tbl_out,
               X_Return_Status     => l_return_status,
               X_Msg_Count         => x_msg_count,
               X_Msg_Data          => x_msg_data);

Line: 12664

    SELECT j.resource_id
    /* FROM jtf_rs_srp_vl srp, jtf_rs_resource_extns j  */  --Commented Code Yogeshwar (MOAC)
    FROM jtf_rs_salesreps_mo_v srp, jtf_rs_resource_extns j --New Code Yogeshwar (MOAC)
    WHERE j.user_id = X_User_Id
      AND j.resource_id = srp.resource_id
      AND srp.status = 'A'
      AND nvl(trunc(srp.start_date_active), trunc(sysdate)) <= trunc(sysdate)
      AND nvl(trunc(srp.end_date_active), trunc(sysdate)) >= trunc(sysdate);

Line: 12678

    SELECT role.role_type_code, role.manager_flag
    FROM JTF_RS_DEFRESROLES_VL role, JTF_RS_DEFRESOURCES_VL res
    WHERE role.role_resource_id = res.resource_id
      AND res.resource_id = X_resource_id
      AND nvl(trunc(role.res_rl_start_date), trunc(sysdate)) <= trunc(sysdate)
      AND nvl(trunc(role.res_rl_end_date), trunc(sysdate)) >= trunc(sysdate)
      AND role.ROLE_TYPE_CODE = X_profile_role_type
      AND role.delete_flag = 'N';