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

APPS.ASO_UTILITY_PVT SQL Statements

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

Line: 457


        SELECT  application_id
        FROM    fnd_application_vl
        WHERE   application_short_name = x_short_name;

Line: 462


        SELECT  msg.message_number
        FROM    fnd_new_messages msg, fnd_languages_vl lng
        WHERE   msg.message_name = x_msg
          and   msg.application_id = x_id
          and   lng.LANGUAGE_CODE = msg.language_code
          and   lng.language_id = x_lang_id;

Line: 518


	Select
	   quote_header_id,
	   CREATION_DATE,
	   CREATED_BY,
	   LAST_UPDATE_DATE,
	   LAST_UPDATED_BY,
	   LAST_UPDATE_LOGIN,
	   REQUEST_ID,
	   PROGRAM_APPLICATION_ID,
	   PROGRAM_ID,
	   PROGRAM_UPDATE_DATE,
           ORG_ID,
           QUOTE_NAME,
           QUOTE_NUMBER,
           QUOTE_VERSION,
           QUOTE_STATUS_ID,
           QUOTE_SOURCE_CODE,
           QUOTE_EXPIRATION_DATE,
           PRICE_FROZEN_DATE,
           QUOTE_PASSWORD,
           ORIGINAL_SYSTEM_REFERENCE,
           PARTY_ID,
           CUST_ACCOUNT_ID,
           INVOICE_TO_CUST_ACCOUNT_ID,
           ORG_CONTACT_ID,
	   PHONE_ID,
           INVOICE_TO_PARTY_SITE_ID,
           INVOICE_TO_PARTY_ID,
           ORIG_MKTG_SOURCE_CODE_ID,
           MARKETING_SOURCE_CODE_ID,
           ORDER_TYPE_ID,
           QUOTE_CATEGORY_CODE,
           ORDERED_DATE,
           ACCOUNTING_RULE_ID,
           INVOICING_RULE_ID,
           EMPLOYEE_PERSON_ID,
           PRICE_LIST_ID,
           CURRENCY_CODE,
           TOTAL_LIST_PRICE,
           TOTAL_ADJUSTED_AMOUNT,
           TOTAL_ADJUSTED_PERCENT,
           TOTAL_TAX,
           TOTAL_SHIPPING_CHARGE,
           SURCHARGE,
           TOTAL_QUOTE_PRICE,
           PAYMENT_AMOUNT,
           EXCHANGE_RATE,
           EXCHANGE_TYPE_CODE,
           EXCHANGE_RATE_DATE,
           CONTRACT_ID,
           SALES_CHANNEL_CODE,
	   ORDER_ID,
           RESOURCE_ID,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           ATTRIBUTE16,
           ATTRIBUTE17,
           ATTRIBUTE18,
           ATTRIBUTE19,
		 ATTRIBUTE20,
           CONTRACT_TEMPLATE_ID,
           CONTRACT_TEMPLATE_MAJOR_VER,
           CONTRACT_REQUESTER_ID,
           CONTRACT_APPROVAL_LEVEL,
           PUBLISH_FLAG,
           RESOURCE_GRP_ID,
           SOLD_TO_PARTY_SITE_ID,
		 DISPLAY_ARITHMETIC_OPERATOR,
		 MAX_VERSION_FLAG,
		 QUOTE_TYPE,
		 QUOTE_DESCRIPTION,
		 MINISITE_ID,
		 CUST_PARTY_ID,
		 INVOICE_TO_CUST_PARTY_ID,
		 PRICING_STATUS_INDICATOR,
		 TAX_STATUS_INDICATOR,
		 PRICE_UPDATED_DATE,
		 TAX_UPDATED_DATE,
		 RECALCULATE_FLAG,
		 PRICE_REQUEST_ID,
		 CREDIT_UPDATE_DATE,
-- hyang new okc
    Customer_Name_And_Title,
    Customer_Signature_Date,
    Supplier_Name_And_Title,
    Supplier_Signature_Date,
-- end of hyang new okc
           END_CUSTOMER_PARTY_ID,
           END_CUSTOMER_PARTY_SITE_ID,
           END_CUSTOMER_CUST_ACCOUNT_ID,
           END_CUSTOMER_CUST_PARTY_ID,
		 AUTOMATIC_PRICE_FLAG,
		 AUTOMATIC_TAX_FLAG,
		 ASSISTANCE_REQUESTED,
		 ASSISTANCE_REASON_CODE,
           OBJECT_VERSION_NUMBER
	  /* ,
	    -- ER 12879412
/	   PRODUCT_FISC_CLASSIFICATION,
	   TRX_BUSINESS_CATEGORY
		*/
	INTO
	   l_qte_header_rec.quote_header_id,
	   l_qte_header_rec.CREATION_DATE,
	   l_qte_header_rec.CREATED_BY,
	   l_qte_header_rec.LAST_UPDATE_DATE,
	   l_qte_header_rec.LAST_UPDATED_BY,
	   l_qte_header_rec.LAST_UPDATE_LOGIN,
	   l_qte_header_rec.REQUEST_ID,
	   l_qte_header_rec.PROGRAM_APPLICATION_ID,
	   l_qte_header_rec.PROGRAM_ID,
	   l_qte_header_rec.PROGRAM_UPDATE_DATE,
           l_qte_header_rec.ORG_ID,
           l_qte_header_rec.QUOTE_NAME,
           l_qte_header_rec.QUOTE_NUMBER,
           l_qte_header_rec.QUOTE_VERSION,
           l_qte_header_rec.QUOTE_STATUS_ID,
           l_qte_header_rec.QUOTE_SOURCE_CODE,
           l_qte_header_rec.QUOTE_EXPIRATION_DATE,
           l_qte_header_rec.PRICE_FROZEN_DATE,
           l_qte_header_rec.QUOTE_PASSWORD,
           l_qte_header_rec.ORIGINAL_SYSTEM_REFERENCE,
           l_qte_header_rec.PARTY_ID,
           l_qte_header_rec.CUST_ACCOUNT_ID,
           l_qte_header_rec.INVOICE_TO_CUST_ACCOUNT_ID,
           l_qte_header_rec.ORG_CONTACT_ID,
           l_qte_header_rec.PHONE_ID,
           l_qte_header_rec.INVOICE_TO_PARTY_SITE_ID,
           l_qte_header_rec.INVOICE_TO_PARTY_ID,
           l_qte_header_rec.ORIG_MKTG_SOURCE_CODE_ID,
           l_qte_header_rec.MARKETING_SOURCE_CODE_ID,
           l_qte_header_rec.ORDER_TYPE_ID,
           l_qte_header_rec.QUOTE_CATEGORY_CODE,
           l_qte_header_rec.ORDERED_DATE,
           l_qte_header_rec.ACCOUNTING_RULE_ID,
           l_qte_header_rec.INVOICING_RULE_ID,
           l_qte_header_rec.EMPLOYEE_PERSON_ID,
           l_qte_header_rec.PRICE_LIST_ID,
           l_qte_header_rec.CURRENCY_CODE,
           l_qte_header_rec.TOTAL_LIST_PRICE,
           l_qte_header_rec.TOTAL_ADJUSTED_AMOUNT,
           l_qte_header_rec.TOTAL_ADJUSTED_PERCENT,
           l_qte_header_rec.TOTAL_TAX,
           l_qte_header_rec.TOTAL_SHIPPING_CHARGE,
           l_qte_header_rec.SURCHARGE,
           l_qte_header_rec.TOTAL_QUOTE_PRICE,
           l_qte_header_rec.PAYMENT_AMOUNT,
           l_qte_header_rec.EXCHANGE_RATE,
           l_qte_header_rec.EXCHANGE_TYPE_CODE,
           l_qte_header_rec.EXCHANGE_RATE_DATE,
           l_qte_header_rec.CONTRACT_ID,
           l_qte_header_rec.SALES_CHANNEL_CODE,
	   l_qte_header_rec.ORDER_ID,
           l_qte_header_rec.RESOURCE_ID,
           l_qte_header_rec.ATTRIBUTE_CATEGORY,
           l_qte_header_rec.ATTRIBUTE1,
           l_qte_header_rec.ATTRIBUTE2,
           l_qte_header_rec.ATTRIBUTE3,
           l_qte_header_rec.ATTRIBUTE4,
           l_qte_header_rec.ATTRIBUTE5,
           l_qte_header_rec.ATTRIBUTE6,
           l_qte_header_rec.ATTRIBUTE7,
           l_qte_header_rec.ATTRIBUTE8,
           l_qte_header_rec.ATTRIBUTE9,
           l_qte_header_rec.ATTRIBUTE10,
           l_qte_header_rec.ATTRIBUTE11,
           l_qte_header_rec.ATTRIBUTE12,
           l_qte_header_rec.ATTRIBUTE13,
           l_qte_header_rec.ATTRIBUTE14,
           l_qte_header_rec.ATTRIBUTE15,
           l_qte_header_rec.ATTRIBUTE16,
           l_qte_header_rec.ATTRIBUTE17,
           l_qte_header_rec.ATTRIBUTE18,
           l_qte_header_rec.ATTRIBUTE19,
           l_qte_header_rec.ATTRIBUTE20,
           l_qte_header_rec.CONTRACT_TEMPLATE_ID,
           l_qte_header_rec.CONTRACT_TEMPLATE_MAJOR_VER,
           l_qte_header_rec.CONTRACT_REQUESTER_ID,
           l_qte_header_rec.CONTRACT_APPROVAL_LEVEL,
           l_qte_header_rec.PUBLISH_FLAG,
           l_qte_header_rec.RESOURCE_GRP_ID,
           l_qte_header_rec.SOLD_TO_PARTY_SITE_ID,
		 l_qte_header_rec.DISPLAY_ARITHMETIC_OPERATOR,
		 l_qte_header_rec.MAX_VERSION_FLAG,
		 l_qte_header_rec.QUOTE_TYPE,
		 l_qte_header_rec.QUOTE_DESCRIPTION,
		 l_qte_header_rec.MINISITE_ID,
		 l_qte_header_rec.CUST_PARTY_ID,
		 l_qte_header_rec.INVOICE_TO_CUST_PARTY_ID,
		 l_qte_header_rec.PRICING_STATUS_INDICATOR,
		 l_qte_header_rec.TAX_STATUS_INDICATOR,
		 l_qte_header_rec.PRICE_UPDATED_DATE,
		 l_qte_header_rec.TAX_UPDATED_DATE,
		 l_qte_header_rec.RECALCULATE_FLAG,
		 l_qte_header_rec.PRICE_REQUEST_ID,
		 l_qte_header_rec.CREDIT_UPDATE_DATE,
-- hyang new okc
    l_qte_header_rec.Customer_Name_And_Title,
    l_qte_header_rec.Customer_Signature_Date,
    l_qte_header_rec.Supplier_Name_And_Title,
    l_qte_header_rec.Supplier_Signature_Date,
-- end of hyang new okc
           l_qte_header_rec.END_CUSTOMER_PARTY_ID,
           l_qte_header_rec.END_CUSTOMER_PARTY_SITE_ID,
           l_qte_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID,
           l_qte_header_rec.END_CUSTOMER_CUST_PARTY_ID,
		 l_qte_header_rec.AUTOMATIC_PRICE_FLAG,
           l_qte_header_rec.AUTOMATIC_TAX_FLAG,
           l_qte_header_rec.ASSISTANCE_REQUESTED,
		 l_qte_header_rec.ASSISTANCE_REASON_CODE,
		 l_qte_header_rec.OBJECT_VERSION_NUMBER
		/* ,
                  -- ER 12879412
	   l_qte_header_rec.PRODUCT_FISC_CLASSIFICATION,
	   l_qte_header_rec.TRX_BUSINESS_CATEGORY  */



	FROM ASO_QUOTE_HEADERS_ALL
	WHERE quote_header_id = p_qte_header_id;

Line: 771


	SELECT
        PRICE_ADJUSTMENT_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_HEADER_ID,
	   QUOTE_LINE_ID,
	   MODIFIER_HEADER_ID,
	   MODIFIER_LINE_ID,
	   MODIFIER_LINE_TYPE_CODE,
	   MODIFIER_MECHANISM_TYPE_CODE,
	   MODIFIED_FROM,
        MODIFIED_TO,
	   OPERAND,
	   ARITHMETIC_OPERATOR,
	   AUTOMATIC_FLAG,
	   UPDATE_ALLOWABLE_FLAG,
        UPDATED_FLAG,
	   APPLIED_FLAG,
	   ON_INVOICE_FLAG,
	   PRICING_PHASE_ID,
	   ATTRIBUTE_CATEGORY,
	   ATTRIBUTE1,
	   ATTRIBUTE2,
	   ATTRIBUTE3,
	   ATTRIBUTE4,
	   ATTRIBUTE5,
	   ATTRIBUTE6,
	   ATTRIBUTE7,
	   ATTRIBUTE8,
	   ATTRIBUTE9,
	   ATTRIBUTE10,
	   ATTRIBUTE11,
	   ATTRIBUTE12,
	   ATTRIBUTE13,
	   ATTRIBUTE14,
	   ATTRIBUTE15,
        ATTRIBUTE16,
        ATTRIBUTE17,
        ATTRIBUTE18,
        ATTRIBUTE19,
        ATTRIBUTE20,
	   TAX_CODE,
	   TAX_EXEMPT_FLAG,
	   TAX_EXEMPT_NUMBER,
	   TAX_EXEMPT_REASON_CODE,
	   PARENT_ADJUSTMENT_ID,
	   INVOICED_FLAG,
	   ESTIMATED_FLAG,
	   INC_IN_SALES_PERFORMANCE,
	   SPLIT_ACTION_CODE,
	   ADJUSTED_AMOUNT,
	   CHARGE_TYPE_CODE,
	   CHARGE_SUBTYPE_CODE,
	   RANGE_BREAK_QUANTITY,
	   ACCRUAL_CONVERSION_RATE,
	   PRICING_GROUP_SEQUENCE,
	   ACCRUAL_FLAG,
	   LIST_LINE_NO,
	   SOURCE_SYSTEM_CODE,
	   BENEFIT_QTY,
	   BENEFIT_UOM_CODE,
	   PRINT_ON_INVOICE_FLAG,
	   EXPIRATION_DATE,
	   REBATE_TRANSACTION_TYPE_CODE,
	   REBATE_TRANSACTION_REFERENCE,
	   REBATE_PAYMENT_SYSTEM_CODE,
	   REDEEMED_DATE,
	   REDEEMED_FLAG,
	   MODIFIER_LEVEL_CODE,
	   PRICE_BREAK_TYPE_CODE,
	   SUBSTITUTION_ATTRIBUTE,
	   PRORATION_TYPE_CODE,
	   INCLUDE_ON_RETURNS_FLAG,
	   CREDIT_OR_CHARGE_FLAG,
	   ORIG_SYS_DISCOUNT_REF,
	   CHANGE_REASON_CODE,
	   CHANGE_REASON_TEXT,
	   COST_ID,
	   LIST_LINE_TYPE_CODE,
	   UPDATE_ALLOWED,
	   CHANGE_SEQUENCE,
	   LIST_HEADER_ID,
	   LIST_LINE_ID,
	   QUOTE_SHIPMENT_ID,
	   OPERAND_PER_PQTY,
	   ADJUSTED_AMOUNT_PER_PQTY,
        OBJECT_VERSION_NUMBER
     FROM ASO_PRICE_ADJUSTMENTS
	WHERE quote_header_id = p_qte_header_id
	     AND quote_line_id IS NULL;

Line: 870


	SELECT
        PRICE_ADJUSTMENT_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_HEADER_ID,
	   QUOTE_LINE_ID,
	   MODIFIER_HEADER_ID,
	   MODIFIER_LINE_ID,
	   MODIFIER_LINE_TYPE_CODE,
	   MODIFIER_MECHANISM_TYPE_CODE,
	   MODIFIED_FROM,
        MODIFIED_TO,
	   OPERAND,
	   ARITHMETIC_OPERATOR,
	   AUTOMATIC_FLAG,
	   UPDATE_ALLOWABLE_FLAG,
        UPDATED_FLAG,
	   APPLIED_FLAG,
	   ON_INVOICE_FLAG,
	   PRICING_PHASE_ID,
	   ATTRIBUTE_CATEGORY,
	   ATTRIBUTE1,
	   ATTRIBUTE2,
	   ATTRIBUTE3,
	   ATTRIBUTE4,
	   ATTRIBUTE5,
	   ATTRIBUTE6,
	   ATTRIBUTE7,
	   ATTRIBUTE8,
	   ATTRIBUTE9,
	   ATTRIBUTE10,
	   ATTRIBUTE11,
	   ATTRIBUTE12,
	   ATTRIBUTE13,
	   ATTRIBUTE14,
	   ATTRIBUTE15,
        ATTRIBUTE16,
        ATTRIBUTE17,
        ATTRIBUTE18,
        ATTRIBUTE19,
        ATTRIBUTE20,
	   TAX_CODE,
	   TAX_EXEMPT_FLAG,
	   TAX_EXEMPT_NUMBER,
	   TAX_EXEMPT_REASON_CODE,
	   PARENT_ADJUSTMENT_ID,
	   INVOICED_FLAG,
	   ESTIMATED_FLAG,
	   INC_IN_SALES_PERFORMANCE,
	   SPLIT_ACTION_CODE,
	   ADJUSTED_AMOUNT,
	   CHARGE_TYPE_CODE,
	   CHARGE_SUBTYPE_CODE,
	   RANGE_BREAK_QUANTITY,
	   ACCRUAL_CONVERSION_RATE,
	   PRICING_GROUP_SEQUENCE,
	   ACCRUAL_FLAG,
	   LIST_LINE_NO,
	   SOURCE_SYSTEM_CODE,
	   BENEFIT_QTY,
	   BENEFIT_UOM_CODE,
	   PRINT_ON_INVOICE_FLAG,
	   EXPIRATION_DATE,
	   REBATE_TRANSACTION_TYPE_CODE,
	   REBATE_TRANSACTION_REFERENCE,
	   REBATE_PAYMENT_SYSTEM_CODE,
	   REDEEMED_DATE,
	   REDEEMED_FLAG,
	   MODIFIER_LEVEL_CODE,
	   PRICE_BREAK_TYPE_CODE,
	   SUBSTITUTION_ATTRIBUTE,
	   PRORATION_TYPE_CODE,
	   INCLUDE_ON_RETURNS_FLAG,
	   CREDIT_OR_CHARGE_FLAG,
	   ORIG_SYS_DISCOUNT_REF,
	   CHANGE_REASON_CODE,
	   CHANGE_REASON_TEXT,
	   COST_ID,
	   LIST_LINE_TYPE_CODE,
	   UPDATE_ALLOWED,
	   CHANGE_SEQUENCE,
	   LIST_HEADER_ID,
	   LIST_LINE_ID,
	   QUOTE_SHIPMENT_ID,
	   OPERAND_PER_PQTY,
	   ADJUSTED_AMOUNT_PER_PQTY,
        OBJECT_VERSION_NUMBER
     FROM ASO_PRICE_ADJUSTMENTS
	WHERE quote_header_id = p_qte_header_id
     AND quote_line_id IS NOT NULL
     AND quote_line_id = p_qte_line_id;

Line: 977


	   l_price_adj_rec.LAST_UPDATE_DATE := price_adj_rec.LAST_UPDATE_DATE;

Line: 978


	   l_price_adj_rec.LAST_UPDATED_BY := price_adj_rec.LAST_UPDATED_BY;

Line: 979


	   l_price_adj_rec.LAST_UPDATE_LOGIN := price_adj_rec.LAST_UPDATE_LOGIN;

Line: 983


	   l_price_adj_rec.PROGRAM_UPDATE_DATE := price_adj_rec.PROGRAM_UPDATE_DATE;

Line: 995


	   l_price_adj_rec.UPDATE_ALLOWABLE_FLAG := price_adj_rec.UPDATE_ALLOWABLE_FLAG;

Line: 996


	   l_price_adj_rec.UPDATED_FLAG := price_adj_rec.UPDATED_FLAG;

Line: 1060


	   l_price_adj_rec.UPDATE_ALLOWED := price_adj_rec.UPDATE_ALLOWED;

Line: 1073


	   l_price_adj_rec.LAST_UPDATE_DATE := price_adj_rec.LAST_UPDATE_DATE;

Line: 1074


	   l_price_adj_rec.LAST_UPDATED_BY := price_adj_rec.LAST_UPDATED_BY;

Line: 1075


	   l_price_adj_rec.LAST_UPDATE_LOGIN := price_adj_rec.LAST_UPDATE_LOGIN;

Line: 1079


	   l_price_adj_rec.PROGRAM_UPDATE_DATE := price_adj_rec.PROGRAM_UPDATE_DATE;

Line: 1091


	   l_price_adj_rec.UPDATE_ALLOWABLE_FLAG := price_adj_rec.UPDATE_ALLOWABLE_FLAG;

Line: 1092


	   l_price_adj_rec.UPDATED_FLAG := price_adj_rec.UPDATED_FLAG;

Line: 1156


	   l_price_adj_rec.UPDATE_ALLOWED := price_adj_rec.UPDATE_ALLOWED;

Line: 1175


	SELECT
        PRICE_ADJUSTMENT_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_HEADER_ID,
	   QUOTE_LINE_ID,
	   MODIFIER_HEADER_ID,
	   MODIFIER_LINE_ID,
	   MODIFIER_LINE_TYPE_CODE,
	   MODIFIER_MECHANISM_TYPE_CODE,
	   MODIFIED_FROM,
        MODIFIED_TO,
	   OPERAND,
	   ARITHMETIC_OPERATOR,
	   AUTOMATIC_FLAG,
	   UPDATE_ALLOWABLE_FLAG,
        UPDATED_FLAG,
	   APPLIED_FLAG,
	   ON_INVOICE_FLAG,
	   PRICING_PHASE_ID,
	   ATTRIBUTE_CATEGORY,
	   ATTRIBUTE1,
	   ATTRIBUTE2,
	   ATTRIBUTE3,
	   ATTRIBUTE4,
	   ATTRIBUTE5,
	   ATTRIBUTE6,
	   ATTRIBUTE7,
	   ATTRIBUTE8,
	   ATTRIBUTE9,
	   ATTRIBUTE10,
	   ATTRIBUTE11,
	   ATTRIBUTE12,
	   ATTRIBUTE13,
	   ATTRIBUTE14,
	   ATTRIBUTE15,
        ATTRIBUTE16,
        ATTRIBUTE17,
        ATTRIBUTE18,
        ATTRIBUTE19,
        ATTRIBUTE20,
	   TAX_CODE,
	   TAX_EXEMPT_FLAG,
	   TAX_EXEMPT_NUMBER,
	   TAX_EXEMPT_REASON_CODE,
	   PARENT_ADJUSTMENT_ID,
	   INVOICED_FLAG,
	   ESTIMATED_FLAG,
	   INC_IN_SALES_PERFORMANCE,
	   SPLIT_ACTION_CODE,
	   ADJUSTED_AMOUNT,
	   CHARGE_TYPE_CODE,
	   CHARGE_SUBTYPE_CODE,
	   RANGE_BREAK_QUANTITY,
	   ACCRUAL_CONVERSION_RATE,
	   PRICING_GROUP_SEQUENCE,
	   ACCRUAL_FLAG,
	   LIST_LINE_NO,
	   SOURCE_SYSTEM_CODE,
	   BENEFIT_QTY,
	   BENEFIT_UOM_CODE,
	   PRINT_ON_INVOICE_FLAG,
	   EXPIRATION_DATE,
	   REBATE_TRANSACTION_TYPE_CODE,
	   REBATE_TRANSACTION_REFERENCE,
	   REBATE_PAYMENT_SYSTEM_CODE,
	   REDEEMED_DATE,
	   REDEEMED_FLAG,
	   MODIFIER_LEVEL_CODE,
	   PRICE_BREAK_TYPE_CODE,
	   SUBSTITUTION_ATTRIBUTE,
	   PRORATION_TYPE_CODE,
	   INCLUDE_ON_RETURNS_FLAG,
	   CREDIT_OR_CHARGE_FLAG,
	   ORIG_SYS_DISCOUNT_REF,
	   CHANGE_REASON_CODE,
	   CHANGE_REASON_TEXT,
	   COST_ID,
	   LIST_LINE_TYPE_CODE,
	   UPDATE_ALLOWED,
	   CHANGE_SEQUENCE,
	   LIST_HEADER_ID,
	   LIST_LINE_ID,
	   QUOTE_SHIPMENT_ID,
	   OPERAND_PER_PQTY,
	   ADJUSTED_AMOUNT_PER_PQTY,
        OBJECT_VERSION_NUMBER
     FROM ASO_PRICE_ADJUSTMENTS
	WHERE quote_header_id = p_qte_header_id
	     AND quote_line_id IS NULL;

Line: 1274


	SELECT
        PRICE_ADJUSTMENT_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_HEADER_ID,
	   QUOTE_LINE_ID,
	   MODIFIER_HEADER_ID,
	   MODIFIER_LINE_ID,
	   MODIFIER_LINE_TYPE_CODE,
	   MODIFIER_MECHANISM_TYPE_CODE,
	   MODIFIED_FROM,
        MODIFIED_TO,
	   OPERAND,
	   ARITHMETIC_OPERATOR,
	   AUTOMATIC_FLAG,
	   UPDATE_ALLOWABLE_FLAG,
        UPDATED_FLAG,
	   APPLIED_FLAG,
	   ON_INVOICE_FLAG,
	   PRICING_PHASE_ID,
	   ATTRIBUTE_CATEGORY,
	   ATTRIBUTE1,
	   ATTRIBUTE2,
	   ATTRIBUTE3,
	   ATTRIBUTE4,
	   ATTRIBUTE5,
	   ATTRIBUTE6,
	   ATTRIBUTE7,
	   ATTRIBUTE8,
	   ATTRIBUTE9,
	   ATTRIBUTE10,
	   ATTRIBUTE11,
	   ATTRIBUTE12,
	   ATTRIBUTE13,
	   ATTRIBUTE14,
	   ATTRIBUTE15,
        ATTRIBUTE16,
        ATTRIBUTE17,
        ATTRIBUTE18,
        ATTRIBUTE19,
        ATTRIBUTE20,
	   TAX_CODE,
	   TAX_EXEMPT_FLAG,
	   TAX_EXEMPT_NUMBER,
	   TAX_EXEMPT_REASON_CODE,
	   PARENT_ADJUSTMENT_ID,
	   INVOICED_FLAG,
	   ESTIMATED_FLAG,
	   INC_IN_SALES_PERFORMANCE,
	   SPLIT_ACTION_CODE,
	   ADJUSTED_AMOUNT,
	   CHARGE_TYPE_CODE,
	   CHARGE_SUBTYPE_CODE,
	   RANGE_BREAK_QUANTITY,
	   ACCRUAL_CONVERSION_RATE,
	   PRICING_GROUP_SEQUENCE,
	   ACCRUAL_FLAG,
	   LIST_LINE_NO,
	   SOURCE_SYSTEM_CODE,
	   BENEFIT_QTY,
	   BENEFIT_UOM_CODE,
	   PRINT_ON_INVOICE_FLAG,
	   EXPIRATION_DATE,
	   REBATE_TRANSACTION_TYPE_CODE,
	   REBATE_TRANSACTION_REFERENCE,
	   REBATE_PAYMENT_SYSTEM_CODE,
	   REDEEMED_DATE,
	   REDEEMED_FLAG,
	   MODIFIER_LEVEL_CODE,
	   PRICE_BREAK_TYPE_CODE,
	   SUBSTITUTION_ATTRIBUTE,
	   PRORATION_TYPE_CODE,
	   INCLUDE_ON_RETURNS_FLAG,
	   CREDIT_OR_CHARGE_FLAG,
	   ORIG_SYS_DISCOUNT_REF,
	   CHANGE_REASON_CODE,
	   CHANGE_REASON_TEXT,
	   COST_ID,
	   LIST_LINE_TYPE_CODE,
	   UPDATE_ALLOWED,
	   CHANGE_SEQUENCE,
	   LIST_HEADER_ID,
	   LIST_LINE_ID,
	   QUOTE_SHIPMENT_ID,
	   OPERAND_PER_PQTY,
	   ADJUSTED_AMOUNT_PER_PQTY,
        OBJECT_VERSION_NUMBER
     FROM ASO_PRICE_ADJUSTMENTS
	WHERE quote_header_id = p_qte_header_id
     AND quote_line_id IS NOT NULL
     AND quote_line_id = p_qte_line_id
	AND modifier_line_type_code <> 'PRG';

Line: 1382


	   l_price_adj_rec.LAST_UPDATE_DATE := price_adj_rec.LAST_UPDATE_DATE;

Line: 1383


	   l_price_adj_rec.LAST_UPDATED_BY := price_adj_rec.LAST_UPDATED_BY;

Line: 1384


	   l_price_adj_rec.LAST_UPDATE_LOGIN := price_adj_rec.LAST_UPDATE_LOGIN;

Line: 1388


	   l_price_adj_rec.PROGRAM_UPDATE_DATE := price_adj_rec.PROGRAM_UPDATE_DATE;

Line: 1400


	   l_price_adj_rec.UPDATE_ALLOWABLE_FLAG := price_adj_rec.UPDATE_ALLOWABLE_FLAG;

Line: 1401


	   l_price_adj_rec.UPDATED_FLAG := price_adj_rec.UPDATED_FLAG;

Line: 1465


	   l_price_adj_rec.UPDATE_ALLOWED := price_adj_rec.UPDATE_ALLOWED;

Line: 1478


	   l_price_adj_rec.LAST_UPDATE_DATE := price_adj_rec.LAST_UPDATE_DATE;

Line: 1479


	   l_price_adj_rec.LAST_UPDATED_BY := price_adj_rec.LAST_UPDATED_BY;

Line: 1480


	   l_price_adj_rec.LAST_UPDATE_LOGIN := price_adj_rec.LAST_UPDATE_LOGIN;

Line: 1484


	   l_price_adj_rec.PROGRAM_UPDATE_DATE := price_adj_rec.PROGRAM_UPDATE_DATE;

Line: 1496


	   l_price_adj_rec.UPDATE_ALLOWABLE_FLAG := price_adj_rec.UPDATE_ALLOWABLE_FLAG;

Line: 1497


	   l_price_adj_rec.UPDATED_FLAG := price_adj_rec.UPDATED_FLAG;

Line: 1561


	   l_price_adj_rec.UPDATE_ALLOWED := price_adj_rec.UPDATE_ALLOWED;

Line: 1581


     SELECT
     PRICE_ADJUSTMENT_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_HEADER_ID,
     QUOTE_LINE_ID,
     MODIFIER_HEADER_ID,
     MODIFIER_LINE_ID,
     MODIFIER_LINE_TYPE_CODE,
     MODIFIER_MECHANISM_TYPE_CODE,
     MODIFIED_FROM,
     MODIFIED_TO,
     OPERAND,
     ARITHMETIC_OPERATOR,
     AUTOMATIC_FLAG,
     UPDATE_ALLOWABLE_FLAG,
     UPDATED_FLAG,
     APPLIED_FLAG,
     ON_INVOICE_FLAG,
     PRICING_PHASE_ID,
     ATTRIBUTE_CATEGORY,
     ATTRIBUTE1,
     ATTRIBUTE2,
     ATTRIBUTE3,
     ATTRIBUTE4,
     ATTRIBUTE5,
     ATTRIBUTE6,
     ATTRIBUTE7,
     ATTRIBUTE8,
     ATTRIBUTE9,
     ATTRIBUTE10,
     ATTRIBUTE11,
     ATTRIBUTE12,
     ATTRIBUTE13,
     ATTRIBUTE14,
     ATTRIBUTE15,
     ATTRIBUTE16,
     ATTRIBUTE17,
     ATTRIBUTE18,
     ATTRIBUTE19,
     ATTRIBUTE20,
     TAX_CODE,
     TAX_EXEMPT_FLAG,
     TAX_EXEMPT_NUMBER,
     TAX_EXEMPT_REASON_CODE,
     PARENT_ADJUSTMENT_ID,
     INVOICED_FLAG,
     ESTIMATED_FLAG,
     INC_IN_SALES_PERFORMANCE,
     SPLIT_ACTION_CODE,
     ADJUSTED_AMOUNT,
     CHARGE_TYPE_CODE,
     CHARGE_SUBTYPE_CODE,
     RANGE_BREAK_QUANTITY,
     ACCRUAL_CONVERSION_RATE,
     PRICING_GROUP_SEQUENCE,
     ACCRUAL_FLAG,
     LIST_LINE_NO,
     SOURCE_SYSTEM_CODE,
     BENEFIT_QTY,
     BENEFIT_UOM_CODE,
     PRINT_ON_INVOICE_FLAG,
     EXPIRATION_DATE,
     REBATE_TRANSACTION_TYPE_CODE,
     REBATE_TRANSACTION_REFERENCE,
     REBATE_PAYMENT_SYSTEM_CODE,
     REDEEMED_DATE,
     REDEEMED_FLAG,
     MODIFIER_LEVEL_CODE,
     PRICE_BREAK_TYPE_CODE,
     SUBSTITUTION_ATTRIBUTE,
     PRORATION_TYPE_CODE,
     INCLUDE_ON_RETURNS_FLAG,
     CREDIT_OR_CHARGE_FLAG,
     ORIG_SYS_DISCOUNT_REF,
     CHANGE_REASON_CODE,
     CHANGE_REASON_TEXT,
     COST_ID,
     LIST_LINE_TYPE_CODE,
     UPDATE_ALLOWED,
     CHANGE_SEQUENCE,
     LIST_HEADER_ID,
     LIST_LINE_ID,
     QUOTE_SHIPMENT_ID,
     OBJECT_VERSION_NUMBER
     FROM ASO_PRICE_ADJUSTMENTS
     WHERE quote_header_id = p_qte_header_id AND
         (quote_line_id = p_qte_line_id OR
          (quote_line_id IS NULL AND p_qte_line_id IS NULL))
         AND modifier_line_type_code <> 'PRG';

Line: 1687


        l_price_adj_rec.LAST_UPDATE_DATE := price_adj_rec.LAST_UPDATE_DATE;

Line: 1688


        l_price_adj_rec.LAST_UPDATED_BY := price_adj_rec.LAST_UPDATED_BY;

Line: 1689


        l_price_adj_rec.LAST_UPDATE_LOGIN := price_adj_rec.LAST_UPDATE_LOGIN;

Line: 1693


        l_price_adj_rec.PROGRAM_UPDATE_DATE := price_adj_rec.PROGRAM_UPDATE_DATE;

Line: 1706


       l_price_adj_rec.UPDATE_ALLOWABLE_FLAG := price_adj_rec.UPDATE_ALLOWABLE_FLAG;

Line: 1707


       l_price_adj_rec.UPDATED_FLAG := price_adj_rec.UPDATED_FLAG;

Line: 1770


     l_price_adj_rec.UPDATE_ALLOWED := price_adj_rec.UPDATE_ALLOWED;

Line: 1785


	SELECT
        PRICE_ADJ_ATTRIB_ID,
	CREATION_DATE,
	CREATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	PROGRAM_APPLICATION_ID,
	PROGRAM_ID,
	PROGRAM_UPDATE_DATE,
	REQUEST_ID,
	PRICE_ADJUSTMENT_ID,
	PRICING_CONTEXT,
	PRICING_ATTRIBUTE,
	PRICING_ATTR_VALUE_FROM,
	PRICING_ATTR_VALUE_TO,
	COMPARISON_OPERATOR,
	FLEX_TITLE,
     OBJECT_VERSION_NUMBER
 	FROM ASO_PRICE_ADJ_ATTRIBS
	WHERE PRICE_ADJUSTMENT_ID = c_price_adj_id;

Line: 1816


	   l_price_adj_attr_rec.LAST_UPDATE_DATE := price_adj_attr_rec.LAST_UPDATE_DATE;

Line: 1817


	   l_price_adj_attr_rec.LAST_UPDATED_BY := price_adj_attr_rec.LAST_UPDATED_BY;

Line: 1818


	   l_price_adj_attr_rec.LAST_UPDATE_LOGIN := price_adj_attr_rec.LAST_UPDATE_LOGIN;

Line: 1822


	   l_price_adj_attr_rec.PROGRAM_UPDATE_DATE := price_adj_attr_rec.PROGRAM_UPDATE_DATE;

Line: 1844


	SELECT
	PAYMENT_ID,
	CREATION_DATE,
	CREATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	REQUEST_ID,
	PROGRAM_APPLICATION_ID,
	PROGRAM_ID,
	PROGRAM_UPDATE_DATE,
	QUOTE_HEADER_ID,
	QUOTE_LINE_ID,
	PAYMENT_TYPE_CODE,
	PAYMENT_REF_NUMBER,
	PAYMENT_OPTION,
	PAYMENT_TERM_ID,
	CREDIT_CARD_CODE,
	CREDIT_CARD_HOLDER_NAME,
	CREDIT_CARD_EXPIRATION_DATE,
	CREDIT_CARD_APPROVAL_CODE,
	CREDIT_CARD_APPROVAL_DATE,
	PAYMENT_AMOUNT,
	QUOTE_SHIPMENT_ID,
	ATTRIBUTE_CATEGORY,
	ATTRIBUTE1,
	ATTRIBUTE2,
	ATTRIBUTE3,
	ATTRIBUTE4,
	ATTRIBUTE5,
	ATTRIBUTE6,
	ATTRIBUTE7,
	ATTRIBUTE8,
	ATTRIBUTE9,
	ATTRIBUTE10,
	ATTRIBUTE11,
	ATTRIBUTE12,
	ATTRIBUTE13,
	ATTRIBUTE14,
	ATTRIBUTE15,
     ATTRIBUTE16,
     ATTRIBUTE17,
     ATTRIBUTE18,
     ATTRIBUTE19,
     ATTRIBUTE20,
	CUST_PO_NUMBER,
     CUST_PO_LINE_NUMBER,
     OBJECT_VERSION_NUMBER,
	TRXN_EXTENSION_ID,
	PAYMENT_TERM_ID_FROM
 	FROM ASO_PAYMENTS
	WHERE quote_header_id = p_qte_header_id AND
	   (quote_line_id = p_qte_line_id OR
		(quote_line_id IS NULL AND p_qte_line_id IS NULL));

Line: 1905


	   l_payment_rec.LAST_UPDATE_DATE := payment_rec.LAST_UPDATE_DATE;

Line: 1906


	   l_payment_rec.LAST_UPDATED_BY := payment_rec.LAST_UPDATED_BY;

Line: 1907


	   l_payment_rec.LAST_UPDATE_LOGIN := payment_rec.LAST_UPDATE_LOGIN;

Line: 1911


	   l_payment_rec.PROGRAM_UPDATE_DATE := payment_rec.PROGRAM_UPDATE_DATE;

Line: 1969


	SELECT
	TAX_DETAIL_ID,
	CREATION_DATE,
	CREATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	REQUEST_ID,
	PROGRAM_APPLICATION_ID,
	PROGRAM_ID,
	PROGRAM_UPDATE_DATE,
	QUOTE_HEADER_ID,
	QUOTE_LINE_ID,
	QUOTE_SHIPMENT_ID,
	ORIG_TAX_CODE,
	TAX_CODE,
	TAX_RATE,
	TAX_DATE,
	TAX_AMOUNT,
	TAX_EXEMPT_FLAG,
	TAX_EXEMPT_NUMBER,
	TAX_EXEMPT_REASON_CODE,
	ATTRIBUTE_CATEGORY,
	ATTRIBUTE1,
	ATTRIBUTE2,
	ATTRIBUTE3,
	ATTRIBUTE4,
	ATTRIBUTE5,
	ATTRIBUTE6,
	ATTRIBUTE7,
	ATTRIBUTE8,
	ATTRIBUTE9,
	ATTRIBUTE10,
	ATTRIBUTE11,
	ATTRIBUTE12,
	ATTRIBUTE13,
	ATTRIBUTE14,
	ATTRIBUTE15,
     ATTRIBUTE16,
     ATTRIBUTE17,
     ATTRIBUTE18,
     ATTRIBUTE19,
     ATTRIBUTE20,
	TAX_INCLUSIVE_FLAG,
     OBJECT_VERSION_NUMBER,
     TAX_RATE_ID
  FROM ASO_TAX_DETAILS
  WHERE quote_header_id = p_qte_header_id
  AND quote_line_id IS NULL ;

Line: 2020


	SELECT
        TAX_DETAIL_ID,
	CREATION_DATE,
	CREATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	REQUEST_ID,
	PROGRAM_APPLICATION_ID,
	PROGRAM_ID,
	PROGRAM_UPDATE_DATE,
	QUOTE_HEADER_ID,
	QUOTE_LINE_ID,
	QUOTE_SHIPMENT_ID,
	ORIG_TAX_CODE,
	TAX_CODE,
	TAX_RATE,
	TAX_DATE,
	TAX_AMOUNT,
	TAX_EXEMPT_FLAG,
	TAX_EXEMPT_NUMBER,
	TAX_EXEMPT_REASON_CODE,
	ATTRIBUTE_CATEGORY,
	ATTRIBUTE1,
	ATTRIBUTE2,
	ATTRIBUTE3,
	ATTRIBUTE4,
	ATTRIBUTE5,
	ATTRIBUTE6,
	ATTRIBUTE7,
	ATTRIBUTE8,
	ATTRIBUTE9,
	ATTRIBUTE10,
	ATTRIBUTE11,
	ATTRIBUTE12,
	ATTRIBUTE13,
	ATTRIBUTE14,
	ATTRIBUTE15,
     ATTRIBUTE16,
     ATTRIBUTE17,
     ATTRIBUTE18,
     ATTRIBUTE19,
     ATTRIBUTE20,
     TAX_INCLUSIVE_FLAG,
     OBJECT_VERSION_NUMBER,
     TAX_RATE_ID
     FROM ASO_TAX_DETAILS
     WHERE quote_shipment_id = c_shipment_id
	and quote_header_id = p_qte_header_id
	and quote_line_id IS NOT NULL
	AND quote_line_id = p_qte_line_id;

Line: 2081


	   l_tax_detail_rec.LAST_UPDATE_DATE := tax_rec.LAST_UPDATE_DATE;

Line: 2082


	   l_tax_detail_rec.LAST_UPDATED_BY := tax_rec.LAST_UPDATED_BY;

Line: 2083


	   l_tax_detail_rec.LAST_UPDATE_LOGIN := tax_rec.LAST_UPDATE_LOGIN;

Line: 2087


	   l_tax_detail_rec.PROGRAM_UPDATE_DATE := tax_rec.PROGRAM_UPDATE_DATE;

Line: 2132


	   l_tax_detail_rec.LAST_UPDATE_DATE := tax_rec.LAST_UPDATE_DATE;

Line: 2133


	   l_tax_detail_rec.LAST_UPDATED_BY := tax_rec.LAST_UPDATED_BY;

Line: 2134


	   l_tax_detail_rec.LAST_UPDATE_LOGIN := tax_rec.LAST_UPDATE_LOGIN;

Line: 2138


	   l_tax_detail_rec.PROGRAM_UPDATE_DATE := tax_rec.PROGRAM_UPDATE_DATE;

Line: 2187


	Select
	   SHIPMENT_ID,
	   CREATION_DATE,
	   CREATED_BY,
	   LAST_UPDATE_DATE,
	   LAST_UPDATED_BY,
	   LAST_UPDATE_LOGIN,
	   REQUEST_ID,
	   PROGRAM_APPLICATION_ID,
	   PROGRAM_ID,
	   PROGRAM_UPDATE_DATE,
	   QUOTE_HEADER_ID,
	   QUOTE_LINE_ID,
	   PROMISE_DATE,
	   REQUEST_DATE,
	   SCHEDULE_SHIP_DATE,
	   SHIP_TO_PARTY_SITE_ID,
	   SHIP_TO_PARTY_ID,
           SHIP_TO_CUST_ACCOUNT_ID,
	   SHIP_PARTIAL_FLAG,
	   SHIP_SET_ID,
	   SHIP_METHOD_CODE,
	   FREIGHT_TERMS_CODE,
	   FREIGHT_CARRIER_CODE,
	   FOB_CODE,
	   SHIPPING_INSTRUCTIONS,
	   PACKING_INSTRUCTIONS,
	   QUANTITY,
	   RESERVED_QUANTITY,
	   RESERVATION_ID,
	   ORDER_LINE_ID,
	   SHIP_QUOTE_PRICE,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           ATTRIBUTE16,
           ATTRIBUTE17,
           ATTRIBUTE18,
           ATTRIBUTE19,
           ATTRIBUTE20,
		 SHIPMENT_PRIORITY_CODE,
		 SHIP_TO_CUST_PARTY_ID,
           REQUEST_DATE_TYPE,
           DEMAND_CLASS_CODE,
           OBJECT_VERSION_NUMBER,
		 SHIP_METHOD_CODE_FROM,
		 FREIGHT_TERMS_CODE_FROM
	INTO
	   l_shipment_rec.SHIPMENT_ID,
	   l_shipment_rec.CREATION_DATE,
	   l_shipment_rec.CREATED_BY,
	   l_shipment_rec.LAST_UPDATE_DATE,
	   l_shipment_rec.LAST_UPDATED_BY,
	   l_shipment_rec.LAST_UPDATE_LOGIN,
	   l_shipment_rec.REQUEST_ID,
	   l_shipment_rec.PROGRAM_APPLICATION_ID,
	   l_shipment_rec.PROGRAM_ID,
	   l_shipment_rec.PROGRAM_UPDATE_DATE,
	   l_shipment_rec.QUOTE_HEADER_ID,
	   l_shipment_rec.QUOTE_LINE_ID,
	   l_shipment_rec.PROMISE_DATE,
	   l_shipment_rec.REQUEST_DATE,
	   l_shipment_rec.SCHEDULE_SHIP_DATE,
	   l_shipment_rec.SHIP_TO_PARTY_SITE_ID,
	   l_shipment_rec.SHIP_TO_PARTY_ID,
           l_shipment_rec.SHIP_TO_CUST_ACCOUNT_ID,
	   l_shipment_rec.SHIP_PARTIAL_FLAG,
	   l_shipment_rec.SHIP_SET_ID,
	   l_shipment_rec.SHIP_METHOD_CODE,
	   l_shipment_rec.FREIGHT_TERMS_CODE,
	   l_shipment_rec.FREIGHT_CARRIER_CODE,
	   l_shipment_rec.FOB_CODE,
	   l_shipment_rec.SHIPPING_INSTRUCTIONS,
	   l_shipment_rec.PACKING_INSTRUCTIONS,
	   l_shipment_rec.QUANTITY,
	   l_shipment_rec.RESERVED_QUANTITY,
	   l_shipment_rec.RESERVATION_ID,
	   l_shipment_rec.ORDER_LINE_ID,
	   l_shipment_rec.SHIP_QUOTE_PRICE,
           l_shipment_rec.ATTRIBUTE_CATEGORY,
           l_shipment_rec.ATTRIBUTE1,
           l_shipment_rec.ATTRIBUTE2,
           l_shipment_rec.ATTRIBUTE3,
           l_shipment_rec.ATTRIBUTE4,
           l_shipment_rec.ATTRIBUTE5,
           l_shipment_rec.ATTRIBUTE6,
           l_shipment_rec.ATTRIBUTE7,
           l_shipment_rec.ATTRIBUTE8,
           l_shipment_rec.ATTRIBUTE9,
           l_shipment_rec.ATTRIBUTE10,
           l_shipment_rec.ATTRIBUTE11,
           l_shipment_rec.ATTRIBUTE12,
           l_shipment_rec.ATTRIBUTE13,
           l_shipment_rec.ATTRIBUTE14,
           l_shipment_rec.ATTRIBUTE15,
           l_shipment_rec.ATTRIBUTE16,
           l_shipment_rec.ATTRIBUTE17,
           l_shipment_rec.ATTRIBUTE18,
           l_shipment_rec.ATTRIBUTE19,
           l_shipment_rec.ATTRIBUTE20,
		 l_shipment_rec.SHIPMENT_PRIORITY_CODE,
		 l_shipment_rec.SHIP_TO_CUST_PARTY_ID,
		 l_shipment_rec.REQUEST_DATE_TYPE,
		 l_shipment_rec.DEMAND_CLASS_CODE,
		 l_shipment_rec.OBJECT_VERSION_NUMBER,
		 l_shipment_rec.SHIP_METHOD_CODE_FROM,
		 l_shipment_rec.FREIGHT_TERMS_CODE_FROM
	FROM ASO_SHIPMENTS
	WHERE shipment_id = p_shipment_id;

Line: 2327


	SELECT
        SHIPMENT_ID,
	   CREATION_DATE,
	   CREATED_BY,
	   LAST_UPDATE_DATE,
	   LAST_UPDATED_BY,
	   LAST_UPDATE_LOGIN,
	   REQUEST_ID,
	   PROGRAM_APPLICATION_ID,
	   PROGRAM_ID,
	   PROGRAM_UPDATE_DATE,
	   QUOTE_HEADER_ID,
	   QUOTE_LINE_ID,
	   PROMISE_DATE,
	   REQUEST_DATE,
	   SCHEDULE_SHIP_DATE,
	   SHIP_TO_PARTY_SITE_ID,
	   SHIP_TO_PARTY_ID,
        SHIP_TO_CUST_ACCOUNT_ID,
	   SHIP_PARTIAL_FLAG,
	   SHIP_SET_ID,
	   SHIP_METHOD_CODE,
	   FREIGHT_TERMS_CODE,
	   FREIGHT_CARRIER_CODE,
	   FOB_CODE,
	   SHIPPING_INSTRUCTIONS,
	   PACKING_INSTRUCTIONS,
	   QUANTITY,
	   RESERVED_QUANTITY,
	   RESERVATION_ID,
	   ORDER_LINE_ID,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        ATTRIBUTE16,
        ATTRIBUTE17,
        ATTRIBUTE18,
        ATTRIBUTE19,
        ATTRIBUTE20,
        SHIPMENT_PRIORITY_CODE,
        SHIP_QUOTE_PRICE,
        SHIP_FROM_ORG_ID,
  	   SHIP_TO_CUST_PARTY_ID,
        REQUEST_DATE_TYPE,
        DEMAND_CLASS_CODE,
        OBJECT_VERSION_NUMBER,
        SHIP_METHOD_CODE_FROM,
        FREIGHT_TERMS_CODE_FROM
     FROM ASO_SHIPMENTS
	WHERE quote_header_id = p_qte_header_id
	     AND quote_line_id IS NULL;

Line: 2393


	SELECT
        SHIPMENT_ID,
	   CREATION_DATE,
	   CREATED_BY,
	   LAST_UPDATE_DATE,
	   LAST_UPDATED_BY,
	   LAST_UPDATE_LOGIN,
	   REQUEST_ID,
	   PROGRAM_APPLICATION_ID,
	   PROGRAM_ID,
	   PROGRAM_UPDATE_DATE,
	   QUOTE_HEADER_ID,
	   QUOTE_LINE_ID,
	   PROMISE_DATE,
	   REQUEST_DATE,
	   SCHEDULE_SHIP_DATE,
	   SHIP_TO_PARTY_SITE_ID,
	   SHIP_TO_PARTY_ID,
        SHIP_TO_CUST_ACCOUNT_ID,
	   SHIP_PARTIAL_FLAG,
	   SHIP_SET_ID,
	   SHIP_METHOD_CODE,
	   FREIGHT_TERMS_CODE,
	   FREIGHT_CARRIER_CODE,
	   FOB_CODE,
	   SHIPPING_INSTRUCTIONS,
	   PACKING_INSTRUCTIONS,
	   QUANTITY,
	   RESERVED_QUANTITY,
	   RESERVATION_ID,
	   ORDER_LINE_ID,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        ATTRIBUTE16,
        ATTRIBUTE17,
        ATTRIBUTE18,
        ATTRIBUTE19,
        ATTRIBUTE20,
        SHIPMENT_PRIORITY_CODE,
        SHIP_QUOTE_PRICE,
        SHIP_FROM_ORG_ID,
  	   SHIP_TO_CUST_PARTY_ID,
        REQUEST_DATE_TYPE,
        DEMAND_CLASS_CODE,
        OBJECT_VERSION_NUMBER,
        SHIP_METHOD_CODE_FROM,
        FREIGHT_TERMS_CODE_FROM

     FROM ASO_SHIPMENTS
	WHERE quote_header_id = p_qte_header_id
	AND quote_line_id IS NOT NULL
	AND quote_line_id = p_qte_line_id;

Line: 2468


	   l_shipment_rec.LAST_UPDATE_DATE := shipment_rec.LAST_UPDATE_DATE;

Line: 2469


	   l_shipment_rec.LAST_UPDATED_BY := shipment_rec.LAST_UPDATED_BY;

Line: 2470


	   l_shipment_rec.LAST_UPDATE_LOGIN := shipment_rec.LAST_UPDATE_LOGIN;

Line: 2474


	   l_shipment_rec.PROGRAM_UPDATE_DATE := shipment_rec.PROGRAM_UPDATE_DATE;

Line: 2532


	   l_shipment_rec.LAST_UPDATE_DATE := shipment_rec.LAST_UPDATE_DATE;

Line: 2533


	   l_shipment_rec.LAST_UPDATED_BY := shipment_rec.LAST_UPDATED_BY;

Line: 2534


	   l_shipment_rec.LAST_UPDATE_LOGIN := shipment_rec.LAST_UPDATE_LOGIN;

Line: 2538


	   l_shipment_rec.PROGRAM_UPDATE_DATE := shipment_rec.PROGRAM_UPDATE_DATE;

Line: 2602


	SELECT
           SHIPMENT_ID,
	   CREATION_DATE,
	   CREATED_BY,
	   LAST_UPDATE_DATE,
	   LAST_UPDATED_BY,
	   LAST_UPDATE_LOGIN,
	   REQUEST_ID,
	   PROGRAM_APPLICATION_ID,
	   PROGRAM_ID,
	   PROGRAM_UPDATE_DATE,
	   QUOTE_HEADER_ID,
	   QUOTE_LINE_ID,
	   PROMISE_DATE,
	   REQUEST_DATE,
	   SCHEDULE_SHIP_DATE,
	   SHIP_TO_PARTY_SITE_ID,
	   SHIP_TO_PARTY_ID,
           SHIP_TO_CUST_ACCOUNT_ID,
	   SHIP_PARTIAL_FLAG,
	   SHIP_SET_ID,
	   SHIP_METHOD_CODE,
	   FREIGHT_TERMS_CODE,
	   FREIGHT_CARRIER_CODE,
	   FOB_CODE,
	   SHIPPING_INSTRUCTIONS,
	   PACKING_INSTRUCTIONS,
	   QUANTITY,
	   RESERVED_QUANTITY,
	   RESERVATION_ID,
	   ORDER_LINE_ID,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           ATTRIBUTE16,
           ATTRIBUTE17,
           ATTRIBUTE18,
           ATTRIBUTE19,
           ATTRIBUTE20,
           SHIPMENT_PRIORITY_CODE,
           SHIP_QUOTE_PRICE,
           SHIP_FROM_ORG_ID,
		 SHIP_TO_CUST_PARTY_ID,
           REQUEST_DATE_TYPE,
           DEMAND_CLASS_CODE,
           OBJECT_VERSION_NUMBER,
           SHIP_METHOD_CODE_FROM,
           FREIGHT_TERMS_CODE_FROM

        FROM ASO_SHIPMENTS
	WHERE quote_header_id = p_qte_header_id
	AND   quote_line_id = p_qte_line_id;

Line: 2676


	   l_shipment_rec.LAST_UPDATE_DATE := shipment_rec.LAST_UPDATE_DATE;

Line: 2677


	   l_shipment_rec.LAST_UPDATED_BY := shipment_rec.LAST_UPDATED_BY;

Line: 2678


	   l_shipment_rec.LAST_UPDATE_LOGIN := shipment_rec.LAST_UPDATE_LOGIN;

Line: 2682


	   l_shipment_rec.PROGRAM_UPDATE_DATE := shipment_rec.PROGRAM_UPDATE_DATE;

Line: 2744


	SELECT
        FREIGHT_CHARGE_ID,
	CREATION_DATE,
	CREATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	REQUEST_ID,
	PROGRAM_APPLICATION_ID,
	PROGRAM_ID,
	PROGRAM_UPDATE_DATE,
	QUOTE_SHIPMENT_ID,
	FREIGHT_CHARGE_TYPE_ID,
	CHARGE_AMOUNT,
	ATTRIBUTE_CATEGORY,
	ATTRIBUTE1,
	ATTRIBUTE2,
	ATTRIBUTE3,
	ATTRIBUTE4,
	ATTRIBUTE5,
	ATTRIBUTE6,
	ATTRIBUTE7,
	ATTRIBUTE8,
	ATTRIBUTE9,
	ATTRIBUTE10,
	ATTRIBUTE11,
	ATTRIBUTE12,
	ATTRIBUTE13,
	ATTRIBUTE14,
	ATTRIBUTE15
        FROM ASO_FREIGHT_CHARGES
	WHERE quote_shipment_id = c_shipment_id;

Line: 2786


	   l_freight_charge_rec.LAST_UPDATE_DATE := freight_charge_rec.LAST_UPDATE_DATE;

Line: 2787


	   l_freight_charge_rec.LAST_UPDATED_BY := freight_charge_rec.LAST_UPDATED_BY;

Line: 2788


	   l_freight_charge_rec.LAST_UPDATE_LOGIN := freight_charge_rec.LAST_UPDATE_LOGIN;

Line: 2792


	   l_freight_charge_rec.PROGRAM_UPDATE_DATE := freight_charge_rec.PROGRAM_UPDATE_DATE;

Line: 2828


SELECT
CREATION_DATE,
CREATED_BY,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
SALES_CREDIT_ID,
QUOTE_HEADER_ID,
QUOTE_LINE_ID,
PERCENT,
RESOURCE_ID,
RESOURCE_GROUP_ID,
EMPLOYEE_PERSON_ID,
SALES_CREDIT_TYPE_ID,
ATTRIBUTE_CATEGORY_CODE,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
OBJECT_VERSION_NUMBER,
SYSTEM_ASSIGNED_FLAG,
CREDIT_RULE_ID
FROM ASO_SALES_CREDITS
WHERE SALES_CREDIT_ID = P_Sales_Credit_Id;

Line: 2877


l_sales_credit_rec.LAST_UPDATED_BY :=                sales_rec.LAST_UPDATED_BY;

Line: 2878


l_sales_credit_rec.LAST_UPDATE_DATE :=               sales_rec.LAST_UPDATE_DATE;

Line: 2879


l_sales_credit_rec.LAST_UPDATE_LOGIN :=              sales_rec.LAST_UPDATE_LOGIN;

Line: 2883


l_sales_credit_rec.PROGRAM_UPDATE_DATE :=            sales_rec.PROGRAM_UPDATE_DATE;

Line: 2929


SELECT
CREATION_DATE,
CREATED_BY,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
SALES_CREDIT_ID,
QUOTE_HEADER_ID,
QUOTE_LINE_ID,
PERCENT,
RESOURCE_ID,
RESOURCE_GROUP_ID,
EMPLOYEE_PERSON_ID,
SALES_CREDIT_TYPE_ID,
ATTRIBUTE_CATEGORY_CODE,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
OBJECT_VERSION_NUMBER,
SYSTEM_ASSIGNED_FLAG,
CREDIT_RULE_ID
FROM ASO_SALES_CREDITS
WHERE  quote_header_id = p_qte_header_id AND
	   ((quote_line_id = p_qte_line_id) OR (quote_line_id IS NULL AND p_qte_line_id IS NULL));

Line: 2979


l_sales_credit_rec.LAST_UPDATED_BY :=                sales_rec.LAST_UPDATED_BY;

Line: 2980


l_sales_credit_rec.LAST_UPDATE_DATE :=               sales_rec.LAST_UPDATE_DATE;

Line: 2981


l_sales_credit_rec.LAST_UPDATE_LOGIN :=              sales_rec.LAST_UPDATE_LOGIN;

Line: 2985


l_sales_credit_rec.PROGRAM_UPDATE_DATE :=            sales_rec.PROGRAM_UPDATE_DATE;

Line: 3033


SELECT QUOTE_PARTY_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
LAST_UPDATED_BY,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
QUOTE_HEADER_ID,
QUOTE_LINE_ID,
QUOTE_SHIPMENT_ID,
PARTY_TYPE,
PARTY_ID,
PARTY_OBJECT_TYPE,
PARTY_OBJECT_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM ASO_QUOTE_PARTIES WHERE
QUOTE_PARTY_ID= P_Quote_Party_Id;

Line: 3074


l_quote_party_rec.LAST_UPDATE_DATE :=               qpt_rec.LAST_UPDATE_DATE;

Line: 3075


l_quote_party_rec.LAST_UPDATE_LOGIN :=              qpt_rec.LAST_UPDATE_LOGIN;

Line: 3076


l_quote_party_rec.LAST_UPDATED_BY :=                qpt_rec.LAST_UPDATED_BY;

Line: 3080


l_quote_party_rec.PROGRAM_UPDATE_DATE :=            qpt_rec.PROGRAM_UPDATE_DATE;

Line: 3119


SELECT QUOTE_PARTY_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
LAST_UPDATED_BY,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
QUOTE_HEADER_ID,
QUOTE_LINE_ID,
QUOTE_SHIPMENT_ID,
PARTY_TYPE,
PARTY_ID,
PARTY_OBJECT_TYPE,
PARTY_OBJECT_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM ASO_QUOTE_PARTIES WHERE quote_header_id = p_qte_header_id AND
	   ((quote_line_id = p_qte_line_id) OR (quote_line_id IS NULL AND p_qte_line_id IS NULL));

Line: 3160


l_quote_party_rec.LAST_UPDATE_DATE :=               qpt_rec.LAST_UPDATE_DATE;

Line: 3161


l_quote_party_rec.LAST_UPDATE_LOGIN :=              qpt_rec.LAST_UPDATE_LOGIN;

Line: 3162


l_quote_party_rec.LAST_UPDATED_BY :=                qpt_rec.LAST_UPDATED_BY;

Line: 3166


l_quote_party_rec.PROGRAM_UPDATE_DATE :=            qpt_rec.PROGRAM_UPDATE_DATE;

Line: 3205


	Select
	  QUOTE_LINE_ID,
	  CREATION_DATE,
	  CREATED_BY,
	  LAST_UPDATE_DATE,
	  LAST_UPDATED_BY,
	  LAST_UPDATE_LOGIN,
	  REQUEST_ID,
	  PROGRAM_APPLICATION_ID,
	  PROGRAM_ID,
	  PROGRAM_UPDATE_DATE,
	  QUOTE_HEADER_ID,
	  ORG_ID,
	  LINE_CATEGORY_CODE,
	  ITEM_TYPE_CODE,
	  LINE_NUMBER,
	  START_DATE_ACTIVE,
	  END_DATE_ACTIVE,
	  ORDER_LINE_TYPE_ID,
	  INVOICE_TO_PARTY_SITE_ID,
	  INVOICE_TO_PARTY_ID,
          INVOICE_TO_CUST_ACCOUNT_ID,
	  ORGANIZATION_ID,
	  INVENTORY_ITEM_ID,
	  QUANTITY,
	  UOM_CODE,
	  MARKETING_SOURCE_CODE_ID,
	  PRICE_LIST_ID,
	  PRICE_LIST_LINE_ID,
	  CURRENCY_CODE,
	  LINE_LIST_PRICE,
	  LINE_ADJUSTED_AMOUNT,
	  LINE_ADJUSTED_PERCENT,
	  LINE_QUOTE_PRICE,
	  RELATED_ITEM_ID,
	  ITEM_RELATIONSHIP_TYPE,
	  ACCOUNTING_RULE_ID,
	  INVOICING_RULE_ID,
	   SPLIT_SHIPMENT_FLAG,
	   BACKORDER_FLAG,
           MINISITE_ID,
           SECTION_ID,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           ATTRIBUTE16,
           ATTRIBUTE17,
           ATTRIBUTE18,
           ATTRIBUTE19,
           ATTRIBUTE20,
           PRICED_PRICE_LIST_ID,
           AGREEMENT_ID,
           COMMITMENT_ID,
		 DISPLAY_ARITHMETIC_OPERATOR,
		 SERVICE_ITEM_FLAG,
		 SERVICEABLE_PRODUCT_FLAG,
		 INVOICE_TO_CUST_PARTY_ID,
		 SELLING_PRICE_CHANGE,
		 RECALCULATE_FLAG,
		 PRICING_LINE_TYPE_INDICATOR,
           END_CUSTOMER_PARTY_ID,
           END_CUSTOMER_PARTY_SITE_ID,
           END_CUSTOMER_CUST_ACCOUNT_ID,
           END_CUSTOMER_CUST_PARTY_ID,
           SHIP_MODEL_COMPLETE_FLAG,
           CHARGE_PERIODICITY_CODE,
           OBJECT_VERSION_NUMBER,
		 PRICING_QUANTITY_UOM,
		 PRICING_QUANTITY,
		 CONFIG_MODEL_TYPE
		 /*,
		 -- ER 12879412
		 PRODUCT_FISC_CLASSIFICATION,
		 TRX_BUSINESS_CATEGORY*/
	INTO
	   l_qte_line_rec.QUOTE_LINE_ID,
	   l_qte_line_rec.CREATION_DATE,
	   l_qte_line_rec.CREATED_BY,
	   l_qte_line_rec.LAST_UPDATE_DATE,
	   l_qte_line_rec.LAST_UPDATED_BY,
	   l_qte_line_rec.LAST_UPDATE_LOGIN,
	   l_qte_line_rec.REQUEST_ID,
	   l_qte_line_rec.PROGRAM_APPLICATION_ID,
	   l_qte_line_rec.PROGRAM_ID,
	   l_qte_line_rec.PROGRAM_UPDATE_DATE,
	   l_qte_line_rec.QUOTE_HEADER_ID,
	   l_qte_line_rec.ORG_ID,
	   l_qte_line_rec.LINE_CATEGORY_CODE,
	   l_qte_line_rec.ITEM_TYPE_CODE,
	   l_qte_line_rec.LINE_NUMBER,
	   l_qte_line_rec.START_DATE_ACTIVE,
	   l_qte_line_rec.END_DATE_ACTIVE,
	   l_qte_line_rec.ORDER_LINE_TYPE_ID,
	   l_qte_line_rec.INVOICE_TO_PARTY_SITE_ID,
	   l_qte_line_rec.INVOICE_TO_PARTY_ID,
           l_qte_line_rec.INVOICE_TO_CUST_ACCOUNT_ID,
	   l_qte_line_rec.ORGANIZATION_ID,
	   l_qte_line_rec.INVENTORY_ITEM_ID,
	   l_qte_line_rec.QUANTITY,
	   l_qte_line_rec.UOM_CODE,
	   l_qte_line_rec.MARKETING_SOURCE_CODE_ID,
	   l_qte_line_rec.PRICE_LIST_ID,
	   l_qte_line_rec.PRICE_LIST_LINE_ID,
	   l_qte_line_rec.CURRENCY_CODE,
	   l_qte_line_rec.LINE_LIST_PRICE,
	   l_qte_line_rec.LINE_ADJUSTED_AMOUNT,
	   l_qte_line_rec.LINE_ADJUSTED_PERCENT,
	   l_qte_line_rec.LINE_QUOTE_PRICE,
	   l_qte_line_rec.RELATED_ITEM_ID,
	   l_qte_line_rec.ITEM_RELATIONSHIP_TYPE,
	   l_qte_line_rec.ACCOUNTING_RULE_ID,
	   l_qte_line_rec.INVOICING_RULE_ID,
	   l_qte_line_rec.SPLIT_SHIPMENT_FLAG,
	   l_qte_line_rec.BACKORDER_FLAG,
           l_qte_line_rec.MINISITE_ID,
           l_qte_line_rec.SECTION_ID,
           l_qte_line_rec.ATTRIBUTE_CATEGORY,
           l_qte_line_rec.ATTRIBUTE1,
           l_qte_line_rec.ATTRIBUTE2,
           l_qte_line_rec.ATTRIBUTE3,
           l_qte_line_rec.ATTRIBUTE4,
           l_qte_line_rec.ATTRIBUTE5,
           l_qte_line_rec.ATTRIBUTE6,
           l_qte_line_rec.ATTRIBUTE7,
           l_qte_line_rec.ATTRIBUTE8,
           l_qte_line_rec.ATTRIBUTE9,
           l_qte_line_rec.ATTRIBUTE10,
           l_qte_line_rec.ATTRIBUTE11,
           l_qte_line_rec.ATTRIBUTE12,
           l_qte_line_rec.ATTRIBUTE13,
           l_qte_line_rec.ATTRIBUTE14,
           l_qte_line_rec.ATTRIBUTE15,
           l_qte_line_rec.ATTRIBUTE16,
           l_qte_line_rec.ATTRIBUTE17,
           l_qte_line_rec.ATTRIBUTE18,
           l_qte_line_rec.ATTRIBUTE19,
           l_qte_line_rec.ATTRIBUTE20,
           l_qte_line_rec.PRICED_PRICE_LIST_ID,
           l_qte_line_rec.AGREEMENT_ID,
           l_qte_line_rec.COMMITMENT_ID,
		 l_qte_line_rec.DISPLAY_ARITHMETIC_OPERATOR,
		 l_qte_line_rec.service_item_flag,
		 l_qte_line_rec.serviceable_product_flag,
		 l_qte_line_rec.INVOICE_TO_CUST_PARTY_ID,
		 l_qte_line_rec.SELLING_PRICE_CHANGE,
		 l_qte_line_rec.RECALCULATE_FLAG,
		 l_qte_line_rec.PRICING_LINE_TYPE_INDICATOR,
           l_qte_line_rec.END_CUSTOMER_PARTY_ID,
           l_qte_line_rec.END_CUSTOMER_PARTY_SITE_ID,
           l_qte_line_rec.END_CUSTOMER_CUST_ACCOUNT_ID,
           l_qte_line_rec.END_CUSTOMER_CUST_PARTY_ID,
           l_qte_line_rec.SHIP_MODEL_COMPLETE_FLAG,
           l_qte_line_rec.CHARGE_PERIODICITY_CODE,
           l_qte_line_rec.OBJECT_VERSION_NUMBER,
		 l_qte_line_rec.PRICING_QUANTITY_UOM,
		 l_qte_line_rec.PRICING_QUANTITY,
		 l_qte_line_rec.CONFIG_MODEL_TYPE
		 /*,
		 -- ER 12879412
		 l_qte_line_rec.PRODUCT_FISC_CLASSIFICATION,
                 l_qte_line_rec.TRX_BUSINESS_CATEGORY*/

	FROM ASO_QUOTE_LINES_ALL
	WHERE quote_line_id = p_qte_line_id;

Line: 3400


	SELECT
           QUOTE_LINE_ID,
	  CREATION_DATE,
	  CREATED_BY,
	  LAST_UPDATE_DATE,
	  LAST_UPDATED_BY,
	  LAST_UPDATE_LOGIN,
	  REQUEST_ID,
	  PROGRAM_APPLICATION_ID,
	  PROGRAM_ID,
	  PROGRAM_UPDATE_DATE,
	  QUOTE_HEADER_ID,
	  ORG_ID,
	  LINE_CATEGORY_CODE,
	  ITEM_TYPE_CODE,
	  LINE_NUMBER,
	  START_DATE_ACTIVE,
	  END_DATE_ACTIVE,
	  ORDER_LINE_TYPE_ID,
	  INVOICE_TO_PARTY_SITE_ID,
	  INVOICE_TO_PARTY_ID,
          INVOICE_TO_CUST_ACCOUNT_ID,
	  ORGANIZATION_ID,
	  INVENTORY_ITEM_ID,
	  QUANTITY,
	  UOM_CODE,
	  MARKETING_SOURCE_CODE_ID,
	  PRICE_LIST_ID,
	  PRICE_LIST_LINE_ID,
	  CURRENCY_CODE,
	  LINE_LIST_PRICE,
	  LINE_ADJUSTED_AMOUNT,
	  LINE_ADJUSTED_PERCENT,
	  LINE_QUOTE_PRICE,
	  RELATED_ITEM_ID,
	  ITEM_RELATIONSHIP_TYPE,
	  ACCOUNTING_RULE_ID,
	  INVOICING_RULE_ID,
	   SPLIT_SHIPMENT_FLAG,
	   BACKORDER_FLAG,
           MINISITE_ID,
           SECTION_ID,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           ATTRIBUTE16,
           ATTRIBUTE17,
           ATTRIBUTE18,
           ATTRIBUTE19,
           ATTRIBUTE20,
           PRICED_PRICE_LIST_ID,
		 AGREEMENT_ID,
		 COMMITMENT_ID,
		 DISPLAY_ARITHMETIC_OPERATOR,
		 SERVICE_ITEM_FLAG,
		 SERVICEABLE_PRODUCT_FLAG,
		 INVOICE_TO_CUST_PARTY_ID,
		 SELLING_PRICE_CHANGE,
		 RECALCULATE_FLAG,
		 PRICING_LINE_TYPE_INDICATOR,
           END_CUSTOMER_PARTY_ID,
           END_CUSTOMER_PARTY_SITE_ID,
           END_CUSTOMER_CUST_ACCOUNT_ID,
           END_CUSTOMER_CUST_PARTY_ID,
           CHARGE_PERIODICITY_CODE ,
           SHIP_MODEL_COMPLETE_FLAG ,
           OBJECT_VERSION_NUMBER,
		 PRICING_QUANTITY_UOM,
		 PRICING_QUANTITY,
		 CONFIG_MODEL_TYPE
		 /*,
		 -- ER 12879412
		 PRODUCT_FISC_CLASSIFICATION,
                 TRX_BUSINESS_CATEGORY
               */

         FROM ASO_Quote_Lines_All
	WHERE quote_header_id = p_qte_header_id
	ORDER BY Line_Number;

Line: 3499


	   l_qte_line_rec.LAST_UPDATE_DATE := line_rec.LAST_UPDATE_DATE;

Line: 3500


	   l_qte_line_rec.LAST_UPDATED_BY := line_rec.LAST_UPDATED_BY;

Line: 3501


	   l_qte_line_rec.LAST_UPDATE_LOGIN := line_rec.LAST_UPDATE_LOGIN;

Line: 3505


	   l_qte_line_rec.PROGRAM_UPDATE_DATE := line_rec.PROGRAM_UPDATE_DATE;

Line: 3593


     SELECT
       QUOTE_LINE_ID,
       CREATION_DATE,
       CREATED_BY,
       LAST_UPDATE_DATE,
       LAST_UPDATED_BY,
       LAST_UPDATE_LOGIN,
       REQUEST_ID,
       PROGRAM_APPLICATION_ID,
       PROGRAM_ID,
       PROGRAM_UPDATE_DATE,
       QUOTE_HEADER_ID,
       ORG_ID,
       LINE_CATEGORY_CODE,
       ITEM_TYPE_CODE,
       UI_LINE_NUMBER,
       START_DATE_ACTIVE,
       END_DATE_ACTIVE,
       ORDER_LINE_TYPE_ID,
       INVOICE_TO_PARTY_SITE_ID,
       INVOICE_TO_PARTY_ID,
       INVOICE_TO_CUST_ACCOUNT_ID,
       ORGANIZATION_ID,
       INVENTORY_ITEM_ID,
       QUANTITY,
       UOM_CODE,
       MARKETING_SOURCE_CODE_ID,
       PRICE_LIST_ID,
       PRICE_LIST_LINE_ID,
       CURRENCY_CODE,
       LINE_LIST_PRICE,
       LINE_ADJUSTED_AMOUNT,
       LINE_ADJUSTED_PERCENT,
       LINE_QUOTE_PRICE,
       RELATED_ITEM_ID,
       ITEM_RELATIONSHIP_TYPE,
       ACCOUNTING_RULE_ID,
       INVOICING_RULE_ID,
       SPLIT_SHIPMENT_FLAG,
       BACKORDER_FLAG,
       MINISITE_ID,
       SECTION_ID,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
          ATTRIBUTE16,
         ATTRIBUTE17,
          ATTRIBUTE18,
          ATTRIBUTE19,
          ATTRIBUTE20,
           PRICED_PRICE_LIST_ID,
           AGREEMENT_ID,
           COMMITMENT_ID,
           DISPLAY_ARITHMETIC_OPERATOR,
           SERVICE_ITEM_FLAG,
           SERVICEABLE_PRODUCT_FLAG,
           INVOICE_TO_CUST_PARTY_ID,
           SELLING_PRICE_CHANGE,
           RECALCULATE_FLAG,
		 PRICING_LINE_TYPE_INDICATOR,
           END_CUSTOMER_PARTY_ID,
           END_CUSTOMER_PARTY_SITE_ID,
           END_CUSTOMER_CUST_ACCOUNT_ID,
           END_CUSTOMER_CUST_PARTY_ID,
           CHARGE_PERIODICITY_CODE,
           SHIP_MODEL_COMPLETE_FLAG ,
           OBJECT_VERSION_NUMBER
	   /*,
		 --CONFIG_MODEL_TYPE
		   -- ER 12879412
          PRODUCT_FISC_CLASSIFICATION,
          TRX_BUSINESS_CATEGORY
*/
         FROM ASO_Pvt_Quote_Lines_Bali_V
     WHERE quote_header_id = p_qte_header_id;

Line: 3689


        l_qte_line_rec.LAST_UPDATE_DATE := line_rec.LAST_UPDATE_DATE;

Line: 3690


        l_qte_line_rec.LAST_UPDATED_BY := line_rec.LAST_UPDATED_BY;

Line: 3691


        l_qte_line_rec.LAST_UPDATE_LOGIN := line_rec.LAST_UPDATE_LOGIN;

Line: 3695


        l_qte_line_rec.PROGRAM_UPDATE_DATE := line_rec.PROGRAM_UPDATE_DATE;

Line: 3780


	SELECT
    QUOTE_LINE_ID,
	  CREATION_DATE,
	  CREATED_BY,
	  LAST_UPDATE_DATE,
	  LAST_UPDATED_BY,
	  LAST_UPDATE_LOGIN,
	  REQUEST_ID,
	  PROGRAM_APPLICATION_ID,
	  PROGRAM_ID,
	  PROGRAM_UPDATE_DATE,
	  QUOTE_HEADER_ID,
	  ORG_ID,
	  LINE_CATEGORY_CODE,
	  ITEM_TYPE_CODE,
	  LINE_NUMBER,
	  START_DATE_ACTIVE,
	  END_DATE_ACTIVE,
	  ORDER_LINE_TYPE_ID,
	  INVOICE_TO_PARTY_SITE_ID,
	  INVOICE_TO_PARTY_ID,
    INVOICE_TO_CUST_ACCOUNT_ID,
	  ORGANIZATION_ID,
	  INVENTORY_ITEM_ID,
	  QUANTITY,
	  UOM_CODE,
	  MARKETING_SOURCE_CODE_ID,
	  PRICE_LIST_ID,
	  PRICE_LIST_LINE_ID,
	  CURRENCY_CODE,
	  LINE_LIST_PRICE,
	  LINE_ADJUSTED_AMOUNT,
	  LINE_ADJUSTED_PERCENT,
	  LINE_QUOTE_PRICE,
	  RELATED_ITEM_ID,
	  ITEM_RELATIONSHIP_TYPE,
	  ACCOUNTING_RULE_ID,
	  INVOICING_RULE_ID,
	   SPLIT_SHIPMENT_FLAG,
	   BACKORDER_FLAG,
           MINISITE_ID,
           SECTION_ID,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           --ATTRIBUTE16,
          -- ATTRIBUTE17,
         --  ATTRIBUTE18,
         --  ATTRIBUTE19,
          -- ATTRIBUTE20,
           PRICED_PRICE_LIST_ID,
		 AGREEMENT_ID,
		 COMMITMENT_ID,
		 DISPLAY_ARITHMETIC_OPERATOR,
		 SERVICE_ITEM_FLAG,
		 SERVICEABLE_PRODUCT_FLAG,
		 --SELLING_PRICE_CHANGE,
           --RECALCULATE_FLAG
		 PRICING_LINE_TYPE_INDICATOR,
           END_CUSTOMER_PARTY_ID,
           END_CUSTOMER_PARTY_SITE_ID,
           END_CUSTOMER_CUST_ACCOUNT_ID,
           END_CUSTOMER_CUST_PARTY_ID,
           --CHARGE_PERIODICITY_CODE,
           --SHIP_MODEL_COMPLETE_FLAG,
           OBJECT_VERSION_NUMBER
	   /*,
		 --CONFIG_MODEL_TYPE
           -- ER 12879412
           PRODUCT_FISC_CLASSIFICATION,
	   TRX_BUSINESS_CATEGORY*/
        FROM aso_pvt_quote_lines_sort_v
	WHERE quote_header_id = p_qte_header_id;

Line: 3875


	   l_qte_line_rec.LAST_UPDATE_DATE := line_rec.LAST_UPDATE_DATE;

Line: 3876


	   l_qte_line_rec.LAST_UPDATED_BY := line_rec.LAST_UPDATED_BY;

Line: 3877


	   l_qte_line_rec.LAST_UPDATE_LOGIN := line_rec.LAST_UPDATE_LOGIN;

Line: 3881


	   l_qte_line_rec.PROGRAM_UPDATE_DATE := line_rec.PROGRAM_UPDATE_DATE;

Line: 3968


	SELECT
           QUOTE_LINE_ID,
	  CREATION_DATE,
	  CREATED_BY,
	  LAST_UPDATE_DATE,
	  LAST_UPDATED_BY,
	  LAST_UPDATE_LOGIN,
	  REQUEST_ID,
	  PROGRAM_APPLICATION_ID,
	  PROGRAM_ID,
	  PROGRAM_UPDATE_DATE,
	  QUOTE_HEADER_ID,
	  ORG_ID,
	  LINE_CATEGORY_CODE,
	  ITEM_TYPE_CODE,
	  LINE_NUMBER,
	  START_DATE_ACTIVE,
	  END_DATE_ACTIVE,
	  ORDER_LINE_TYPE_ID,
	  INVOICE_TO_PARTY_SITE_ID,
	  INVOICE_TO_PARTY_ID,
          INVOICE_TO_CUST_ACCOUNT_ID,
	  ORGANIZATION_ID,
	  INVENTORY_ITEM_ID,
	  QUANTITY,
	  UOM_CODE,
	  MARKETING_SOURCE_CODE_ID,
	  PRICE_LIST_ID,
	  PRICE_LIST_LINE_ID,
	  CURRENCY_CODE,
	  LINE_LIST_PRICE,
	  LINE_ADJUSTED_AMOUNT,
	  LINE_ADJUSTED_PERCENT,
	  LINE_QUOTE_PRICE,
	  RELATED_ITEM_ID,
	  ITEM_RELATIONSHIP_TYPE,
	  ACCOUNTING_RULE_ID,
	  INVOICING_RULE_ID,
	   SPLIT_SHIPMENT_FLAG,
	   BACKORDER_FLAG,
           MINISITE_ID,
           SECTION_ID,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,/*
           ATTRIBUTE16,
           ATTRIBUTE17,
           ATTRIBUTE18,
           ATTRIBUTE19,
           ATTRIBUTE20,*/
           PRICED_PRICE_LIST_ID,
		 AGREEMENT_ID,
		 COMMITMENT_ID,
		 DISPLAY_ARITHMETIC_OPERATOR,
		 SERVICE_ITEM_FLAG,
		 SERVICEABLE_PRODUCT_FLAG,
		 INVOICE_TO_CUST_PARTY_ID,
		 SELLING_PRICE_CHANGE,
		 RECALCULATE_FLAG,
		 PRICING_LINE_TYPE_INDICATOR,
           END_CUSTOMER_PARTY_ID,
           END_CUSTOMER_PARTY_SITE_ID,
           END_CUSTOMER_CUST_ACCOUNT_ID,
           END_CUSTOMER_CUST_PARTY_ID,
           CHARGE_PERIODICITY_CODE ,
           SHIP_MODEL_COMPLETE_FLAG ,
           OBJECT_VERSION_NUMBER,
           UI_LINE_NUMBER
	   /*,
	    -- ER 12879412
PRODUCT_FISC_CLASSIFICATION,
TRX_BUSINESS_CATEGORY*/
		 --CONFIG_MODEL_TYPE
	    FROM ASO_PVT_QUOTE_LINES_BALI_V
	WHERE quote_header_id = p_qte_header_id;

Line: 4063


	   l_qte_line_rec.LAST_UPDATE_DATE := line_rec.LAST_UPDATE_DATE;

Line: 4064


	   l_qte_line_rec.LAST_UPDATED_BY := line_rec.LAST_UPDATED_BY;

Line: 4065


	   l_qte_line_rec.LAST_UPDATE_LOGIN := line_rec.LAST_UPDATE_LOGIN;

Line: 4069


	   l_qte_line_rec.PROGRAM_UPDATE_DATE := line_rec.PROGRAM_UPDATE_DATE;

Line: 4160


	SELECT
       QUOTE_LINE_ID,
	  CREATION_DATE,
	  CREATED_BY,
	  LAST_UPDATE_DATE,
	  LAST_UPDATED_BY,
	  LAST_UPDATE_LOGIN,
	  REQUEST_ID,
	  PROGRAM_APPLICATION_ID,
	  PROGRAM_ID,
	  PROGRAM_UPDATE_DATE,
	  QUOTE_HEADER_ID,
	  ORG_ID,
	  LINE_CATEGORY_CODE,
	  ITEM_TYPE_CODE,
	  LINE_NUMBER,
	  START_DATE_ACTIVE,
	  END_DATE_ACTIVE,
	  ORDER_LINE_TYPE_ID,
	  INVOICE_TO_PARTY_SITE_ID,
	  INVOICE_TO_PARTY_ID,
       INVOICE_TO_CUST_ACCOUNT_ID,
	  ORGANIZATION_ID,
	  INVENTORY_ITEM_ID,
	  QUANTITY,
	  UOM_CODE,
	  MARKETING_SOURCE_CODE_ID,
	  PRICE_LIST_ID,
	  PRICE_LIST_LINE_ID,
	  CURRENCY_CODE,
	  LINE_LIST_PRICE,
	  LINE_ADJUSTED_AMOUNT,
	  LINE_ADJUSTED_PERCENT,
	  LINE_QUOTE_PRICE,
	  RELATED_ITEM_ID,
	  ITEM_RELATIONSHIP_TYPE,
	  ACCOUNTING_RULE_ID,
	  INVOICING_RULE_ID,
	  SPLIT_SHIPMENT_FLAG,
	  BACKORDER_FLAG,
       MINISITE_ID,
       SECTION_ID,
	  INVOICE_TO_CUST_PARTY_ID,
	  RECALCULATE_FLAG,
	  SELLING_PRICE_CHANGE,
	  SERVICE_ITEM_FLAG,
       ATTRIBUTE_CATEGORY,
       ATTRIBUTE1,
       ATTRIBUTE2,
       ATTRIBUTE3,
       ATTRIBUTE4,
       ATTRIBUTE5,
       ATTRIBUTE6,
       ATTRIBUTE7,
       ATTRIBUTE8,
       ATTRIBUTE9,
       ATTRIBUTE10,
       ATTRIBUTE11,
       ATTRIBUTE12,
       ATTRIBUTE13,
       ATTRIBUTE14,
       ATTRIBUTE15,
       ATTRIBUTE16,
       ATTRIBUTE17,
       ATTRIBUTE18,
       ATTRIBUTE19,
       ATTRIBUTE20,
       PRICED_PRICE_LIST_ID,
	  AGREEMENT_ID,
	  COMMITMENT_ID,
	  DISPLAY_ARITHMETIC_OPERATOR,
       PRICING_LINE_TYPE_INDICATOR,
       END_CUSTOMER_PARTY_ID,
       END_CUSTOMER_PARTY_SITE_ID,
       END_CUSTOMER_CUST_ACCOUNT_ID,
       END_CUSTOMER_CUST_PARTY_ID,
	  SHIP_MODEL_COMPLETE_FLAG,
	  CHARGE_PERIODICITY_CODE,
	  PRICING_QUANTITY_UOM,
	  PRICING_QUANTITY,
	  OBJECT_VERSION_NUMBER
	  /*,
	    -- ER 12879412
         PRODUCT_FISC_CLASSIFICATION,
         TRX_BUSINESS_CATEGORY
*/
   FROM ASO_Quote_Lines_All
   WHERE quote_header_id = p_qte_header_id
   ORDER BY Line_Number;

Line: 4251


         SELECT service_ref_type_code , service_ref_line_id
	 FROM   ASO_QUOTE_LINE_DETAILS
	 WHERE  quote_line_id = p_qte_line_id;

Line: 4256


	 SELECT line_id, inventory_item_id, pricing_quantity, pricing_quantity_uom,
		unit_list_price, price_list_id, charge_periodicity_code
	 FROM OE_ORDER_LINES_ALL
	 WHERE line_id = p_order_line_id;

Line: 4264


	 SELECT cust_account_id
	 FROM ASO_QUOTE_HEADERS_ALL
	 WHERE quote_header_id = p_qte_header_id;

Line: 4269


      SELECT   original_order_line_id
      FROM     csi_instance_accts_rg_v
      WHERE    customer_product_id = p_instance_id
      AND      account_id          = p_cust_account_id;

Line: 4276


	 select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',nvl(END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id),cust_account_id) cust_account_id
         from ASO_QUOTE_HEADERS_ALL
         WHERE quote_header_id = p_qte_header_id;

Line: 4281


	 select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',END_CUSTOMER_CUST_ACCOUNT_ID)
         from ASO_QUOTE_LINES_ALL
         WHERE quote_line_id = p_qte_line_id;

Line: 4286


		select  price_list_id
		from    aso_quote_headers_all
		where   quote_header_id = p_qte_hdr_id;

Line: 4300


     SELECT si.concatenated_segments product, si.inventory_item_id, cii.quantity, cii.unit_of_measure
	FROM mtl_system_items_kfv si, csi_item_instances cii
	WHERE NVL(cii.active_end_date, (SYSDATE + 1)) > SYSDATE
	AND cii.inventory_item_id = si.inventory_item_id
	AND si.organization_id = cii.inv_master_organization_id
	AND cii.instance_id =p_instance_id;

Line: 4307


	/* SELECT   distinct a.product,b.inventory_item_id,a.quantity,a.unit_of_measure_code
	 FROM     csi_instance_accts_rg_v a ,mtl_system_items_vl  b
      where    a.product = b.concatenated_segments
	 AND      a.customer_product_id = p_instance_id;

Line: 4589


	     l_qte_line_rec.LAST_UPDATE_DATE := c_qte_line_rec.LAST_UPDATE_DATE;

Line: 4590


	     l_qte_line_rec.LAST_UPDATED_BY := c_qte_line_rec.LAST_UPDATED_BY;

Line: 4591


	     l_qte_line_rec.LAST_UPDATE_LOGIN := c_qte_line_rec.LAST_UPDATE_LOGIN;

Line: 4595


	     l_qte_line_rec.PROGRAM_UPDATE_DATE := c_qte_line_rec.PROGRAM_UPDATE_DATE;

Line: 4699


	SELECT
       QUOTE_LINE_ID,
	  CREATION_DATE,
	  CREATED_BY,
	  LAST_UPDATE_DATE,
	  LAST_UPDATED_BY,
	  LAST_UPDATE_LOGIN,
	  REQUEST_ID,
	  PROGRAM_APPLICATION_ID,
	  PROGRAM_ID,
	  PROGRAM_UPDATE_DATE,
	  QUOTE_HEADER_ID,
	  ORG_ID,
	  LINE_CATEGORY_CODE,
	  ITEM_TYPE_CODE,
	  LINE_NUMBER,
	  START_DATE_ACTIVE,
	  END_DATE_ACTIVE,
	  ORDER_LINE_TYPE_ID,
	  INVOICE_TO_PARTY_SITE_ID,
	  INVOICE_TO_PARTY_ID,
       INVOICE_TO_CUST_ACCOUNT_ID,
	  ORGANIZATION_ID,
	  INVENTORY_ITEM_ID,
	  QUANTITY,
	  UOM_CODE,
	  MARKETING_SOURCE_CODE_ID,
	  PRICE_LIST_ID,
	  PRICE_LIST_LINE_ID,
	  CURRENCY_CODE,
	  LINE_LIST_PRICE,
	  LINE_ADJUSTED_AMOUNT,
	  LINE_ADJUSTED_PERCENT,
	  LINE_QUOTE_PRICE,
	  RELATED_ITEM_ID,
	  ITEM_RELATIONSHIP_TYPE,
	  ACCOUNTING_RULE_ID,
	  INVOICING_RULE_ID,
	  SPLIT_SHIPMENT_FLAG,
	  BACKORDER_FLAG,
       MINISITE_ID,
       SECTION_ID,
	  INVOICE_TO_CUST_PARTY_ID,
	  RECALCULATE_FLAG,
	  SELLING_PRICE_CHANGE,
	  SERVICE_ITEM_FLAG,
       ATTRIBUTE_CATEGORY,
       ATTRIBUTE1,
       ATTRIBUTE2,
       ATTRIBUTE3,
       ATTRIBUTE4,
       ATTRIBUTE5,
       ATTRIBUTE6,
       ATTRIBUTE7,
       ATTRIBUTE8,
       ATTRIBUTE9,
       ATTRIBUTE10,
       ATTRIBUTE11,
       ATTRIBUTE12,
       ATTRIBUTE13,
       ATTRIBUTE14,
       ATTRIBUTE15,
       ATTRIBUTE16,
       ATTRIBUTE17,
       ATTRIBUTE18,
       ATTRIBUTE19,
       ATTRIBUTE20,
       PRICED_PRICE_LIST_ID,
	  AGREEMENT_ID,
	  COMMITMENT_ID,
	  DISPLAY_ARITHMETIC_OPERATOR,
	  PRICING_LINE_TYPE_INDICATOR,
       END_CUSTOMER_PARTY_ID,
       END_CUSTOMER_PARTY_SITE_ID,
       END_CUSTOMER_CUST_ACCOUNT_ID,
       END_CUSTOMER_CUST_PARTY_ID,
	  SHIP_MODEL_COMPLETE_FLAG,
	  CHARGE_PERIODICITY_CODE,
	  PRICING_QUANTITY_UOM,
	  PRICING_QUANTITY,
	  OBJECT_VERSION_NUMBER
	  /*,
	    -- ER 12879412
           PRODUCT_FISC_CLASSIFICATION,
           TRX_BUSINESS_CATEGORY
*/
     FROM ASO_Quote_Lines_All
	WHERE quote_header_id = p_qte_header_id
     AND   quote_line_id   = p_qte_line_id
	ORDER BY Line_Number;

Line: 4794


         SELECT mtl.service_item_flag
	 FROM   MTL_SYSTEM_ITEMS_B mtl
	 WHERE  mtl.inventory_item_id = p_inventory_item_id
	 AND    mtl.organization_id = p_organization_id;

Line: 4800


         SELECT service_ref_type_code , service_ref_line_id
	 FROM   ASO_QUOTE_LINE_DETAILS
	 WHERE  quote_line_id = p_qte_line_id;

Line: 4805


	 SELECT line_id, inventory_item_id, pricing_quantity, pricing_quantity_uom,
		unit_list_price, price_list_id, charge_periodicity_code
	 FROM OE_ORDER_LINES_ALL
	 WHERE line_id = p_order_line_id;

Line: 4814


	 select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',nvl(END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id),cust_account_id) cust_account_id
         from ASO_QUOTE_HEADERS_ALL
         WHERE quote_header_id = p_qte_header_id;

Line: 4819


	 select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',END_CUSTOMER_CUST_ACCOUNT_ID)
         from ASO_QUOTE_LINES_ALL
         WHERE quote_line_id = p_qte_line_id;

Line: 4824


		select  price_list_id
		from    aso_quote_headers_all
		where   quote_header_id = p_qte_hdr_id;

Line: 4832


      SELECT cust_account_id
      FROM ASO_QUOTE_HEADERS_ALL
      WHERE quote_header_id = p_qte_header_id;*/

Line: 4839


      SELECT   original_order_line_id
      FROM     csi_instance_accts_rg_v
      WHERE    customer_product_id = p_instance_id
      AND      account_id          = p_cust_account_id;

Line: 4849


     SELECT si.concatenated_segments product, si.inventory_item_id, cii.quantity, cii.unit_of_measure
    	FROM mtl_system_items_kfv si, csi_item_instances cii
	   WHERE NVL(cii.active_end_date, (SYSDATE + 1)) > SYSDATE
	   AND cii.inventory_item_id = si.inventory_item_id
	   AND si.organization_id = cii.inv_master_organization_id
	   AND cii.instance_id =p_instance_id;

Line: 4866


select inventory_item_id,quantity,line_list_price,PRICING_QUANTITY_UOM,PRICING_QUANTITY
from aso_quote_lines_all
where quote_line_id=p_quote_line_id;

Line: 5133


	         l_qte_line_rec.LAST_UPDATE_DATE := c_qte_line_rec.LAST_UPDATE_DATE;

Line: 5134


	         l_qte_line_rec.LAST_UPDATED_BY := c_qte_line_rec.LAST_UPDATED_BY;

Line: 5135


	         l_qte_line_rec.LAST_UPDATE_LOGIN := c_qte_line_rec.LAST_UPDATE_LOGIN;

Line: 5139


	         l_qte_line_rec.PROGRAM_UPDATE_DATE := c_qte_line_rec.PROGRAM_UPDATE_DATE;

Line: 5231


	SELECT
	QUOTE_LINE_DETAIL_ID,
	CREATION_DATE,
	CREATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	REQUEST_ID,
	PROGRAM_APPLICATION_ID,
	PROGRAM_ID,
	PROGRAM_UPDATE_DATE,
	QUOTE_LINE_ID,
	CONFIG_HEADER_ID,
	CONFIG_REVISION_NUM,
	CONFIG_ITEM_ID,
	COMPLETE_CONFIGURATION_FLAG,
	VALID_CONFIGURATION_FLAG,
	COMPONENT_CODE,
	SERVICE_COTERMINATE_FLAG,
	SERVICE_DURATION,
	SERVICE_PERIOD,
	SERVICE_UNIT_SELLING_PERCENT,
	SERVICE_UNIT_LIST_PERCENT,
	SERVICE_NUMBER,
	UNIT_PERCENT_BASE_PRICE,
	ATTRIBUTE_CATEGORY,
	ATTRIBUTE1,
	ATTRIBUTE2,
	ATTRIBUTE3,
        ATTRIBUTE4,
	ATTRIBUTE5,
	ATTRIBUTE6,
	ATTRIBUTE7,
	ATTRIBUTE8,
	ATTRIBUTE9,
	ATTRIBUTE10,
	ATTRIBUTE11,
	ATTRIBUTE12,
	ATTRIBUTE13,
	ATTRIBUTE14,
	ATTRIBUTE15,
	ATTRIBUTE16,
	ATTRIBUTE17,
	ATTRIBUTE18,
	ATTRIBUTE19,
	ATTRIBUTE20,
	SERVICE_REF_TYPE_CODE,
	SERVICE_REF_ORDER_NUMBER,
	SERVICE_REF_LINE_NUMBER,
	SERVICE_REF_LINE_ID,
	SERVICE_REF_SYSTEM_ID,
	SERVICE_REF_OPTION_NUMB,
	SERVICE_REF_SHIPMENT_NUMB,
	RETURN_REF_TYPE,
	RETURN_REF_HEADER_ID,
	RETURN_REF_LINE_ID,
	RETURN_REASON_CODE,
	RETURN_ATTRIBUTE1,
	RETURN_ATTRIBUTE2,
	RETURN_ATTRIBUTE3,
	RETURN_ATTRIBUTE4,
	RETURN_ATTRIBUTE5,
	RETURN_ATTRIBUTE6,
	RETURN_ATTRIBUTE7,
	RETURN_ATTRIBUTE8,
	RETURN_ATTRIBUTE9,
	RETURN_ATTRIBUTE10,
	RETURN_ATTRIBUTE11,
	RETURN_ATTRIBUTE12,
	RETURN_ATTRIBUTE13,
	RETURN_ATTRIBUTE14,
	RETURN_ATTRIBUTE15,
     REF_TYPE_CODE,
     REF_LINE_ID,
	INSTANCE_ID,
	BOM_SORT_ORDER,
	TOP_MODEL_LINE_ID,
	ATO_LINE_ID,
	COMPONENT_SEQUENCE_ID,
	OBJECT_VERSION_NUMBER,
	CONFIG_DELTA,
	CONFIG_INSTANCE_NAME
        FROM ASO_Quote_Line_Details
	WHERE quote_line_id = p_qte_line_id;

Line: 5323


	   l_line_dtl_rec.LAST_UPDATE_DATE := line_dtl_rec.LAST_UPDATE_DATE;

Line: 5324


	   l_line_dtl_rec.LAST_UPDATED_BY := line_dtl_rec.LAST_UPDATED_BY;

Line: 5325


	   l_line_dtl_rec.LAST_UPDATE_LOGIN := line_dtl_rec.LAST_UPDATE_LOGIN;

Line: 5329


	   l_line_dtl_rec.PROGRAM_UPDATE_DATE := line_dtl_rec.PROGRAM_UPDATE_DATE;

Line: 5417


	SELECT
        LINE_ATTRIBUTE_ID,
	CREATION_DATE,
	CREATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	REQUEST_ID,
	PROGRAM_APPLICATION_ID,
	PROGRAM_ID,
	PROGRAM_UPDATE_DATE,
	APPLICATION_ID,
	QUOTE_LINE_ID,
	ATTRIBUTE_TYPE_CODE,
	NAME,
	VALUE,
	VALUE_TYPE,
	STATUS,
	START_DATE_ACTIVE,
	END_DATE_ACTIVE,
	QUOTE_HEADER_ID,
	QUOTE_SHIPMENT_ID
        FROM ASO_QUOTE_LINE_ATTRIBS_EXT
	WHERE quote_header_id = p_qte_header_id AND
    quote_line_id  is null;

Line: 5450


	   l_line_attr_ext_rec.LAST_UPDATE_DATE := line_attr_ext_rec.LAST_UPDATE_DATE;

Line: 5451


	   l_line_attr_ext_rec.LAST_UPDATED_BY := line_attr_ext_rec.LAST_UPDATED_BY;

Line: 5452


	   l_line_attr_ext_rec.LAST_UPDATE_LOGIN := line_attr_ext_rec.LAST_UPDATE_LOGIN;

Line: 5456


	   l_line_attr_ext_rec.PROGRAM_UPDATE_DATE := line_attr_ext_rec.PROGRAM_UPDATE_DATE;

Line: 5478


	SELECT
        LINE_ATTRIBUTE_ID,
	CREATION_DATE,
	CREATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	REQUEST_ID,
	PROGRAM_APPLICATION_ID,
	PROGRAM_ID,
	PROGRAM_UPDATE_DATE,
	APPLICATION_ID,
	QUOTE_LINE_ID,
	ATTRIBUTE_TYPE_CODE,
	NAME,
	VALUE,
	VALUE_TYPE,
	STATUS,
	START_DATE_ACTIVE,
	END_DATE_ACTIVE,
	QUOTE_HEADER_ID,
	QUOTE_SHIPMENT_ID
        FROM ASO_QUOTE_LINE_ATTRIBS_EXT
	WHERE quote_line_id = p_qte_line_id;

Line: 5510


	   l_line_attr_ext_rec.LAST_UPDATE_DATE := line_attr_ext_rec.LAST_UPDATE_DATE;

Line: 5511


	   l_line_attr_ext_rec.LAST_UPDATED_BY := line_attr_ext_rec.LAST_UPDATED_BY;

Line: 5512


	   l_line_attr_ext_rec.LAST_UPDATE_LOGIN := line_attr_ext_rec.LAST_UPDATE_LOGIN;

Line: 5516


	   l_line_attr_ext_rec.PROGRAM_UPDATE_DATE := line_attr_ext_rec.PROGRAM_UPDATE_DATE;

Line: 5539


	SELECT
PRICE_ATTRIBUTE_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_HEADER_ID,
QUOTE_LINE_ID,
FLEX_TITLE,
PRICING_CONTEXT,
PRICING_ATTRIBUTE1,
PRICING_ATTRIBUTE2,
PRICING_ATTRIBUTE3,
PRICING_ATTRIBUTE4,
PRICING_ATTRIBUTE5,
PRICING_ATTRIBUTE6,
PRICING_ATTRIBUTE7,
PRICING_ATTRIBUTE8,
PRICING_ATTRIBUTE9,
PRICING_ATTRIBUTE10,
PRICING_ATTRIBUTE11,
PRICING_ATTRIBUTE12,
PRICING_ATTRIBUTE13,
PRICING_ATTRIBUTE14,
PRICING_ATTRIBUTE15,
PRICING_ATTRIBUTE16,
PRICING_ATTRIBUTE17,
PRICING_ATTRIBUTE18,
PRICING_ATTRIBUTE19,
PRICING_ATTRIBUTE20,
PRICING_ATTRIBUTE21,
PRICING_ATTRIBUTE22,
PRICING_ATTRIBUTE23,
PRICING_ATTRIBUTE24,
PRICING_ATTRIBUTE25,
PRICING_ATTRIBUTE26,
PRICING_ATTRIBUTE27,
PRICING_ATTRIBUTE28,
PRICING_ATTRIBUTE29,
PRICING_ATTRIBUTE30,
PRICING_ATTRIBUTE31,
PRICING_ATTRIBUTE32,
PRICING_ATTRIBUTE33,
PRICING_ATTRIBUTE34,
PRICING_ATTRIBUTE35,
PRICING_ATTRIBUTE36,
PRICING_ATTRIBUTE37,
PRICING_ATTRIBUTE38,
PRICING_ATTRIBUTE39,
PRICING_ATTRIBUTE40,
PRICING_ATTRIBUTE41,
PRICING_ATTRIBUTE42,
PRICING_ATTRIBUTE43,
PRICING_ATTRIBUTE44,
PRICING_ATTRIBUTE45,
PRICING_ATTRIBUTE46,
PRICING_ATTRIBUTE47,
PRICING_ATTRIBUTE48,
PRICING_ATTRIBUTE49,
PRICING_ATTRIBUTE50,
PRICING_ATTRIBUTE51,
PRICING_ATTRIBUTE52,
PRICING_ATTRIBUTE53,
PRICING_ATTRIBUTE54,
PRICING_ATTRIBUTE55,
PRICING_ATTRIBUTE56,
PRICING_ATTRIBUTE57,
PRICING_ATTRIBUTE58,
PRICING_ATTRIBUTE59,
PRICING_ATTRIBUTE60,
PRICING_ATTRIBUTE61,
PRICING_ATTRIBUTE62,
PRICING_ATTRIBUTE63,
PRICING_ATTRIBUTE64,
PRICING_ATTRIBUTE65,
PRICING_ATTRIBUTE66,
PRICING_ATTRIBUTE67,
PRICING_ATTRIBUTE68,
PRICING_ATTRIBUTE69,
PRICING_ATTRIBUTE70,
PRICING_ATTRIBUTE71,
PRICING_ATTRIBUTE72,
PRICING_ATTRIBUTE73,
PRICING_ATTRIBUTE74,
PRICING_ATTRIBUTE75,
PRICING_ATTRIBUTE76,
PRICING_ATTRIBUTE77,
PRICING_ATTRIBUTE78,
PRICING_ATTRIBUTE79,
PRICING_ATTRIBUTE80,
PRICING_ATTRIBUTE81,
PRICING_ATTRIBUTE82,
PRICING_ATTRIBUTE83,
PRICING_ATTRIBUTE84,
PRICING_ATTRIBUTE85,
PRICING_ATTRIBUTE86,
PRICING_ATTRIBUTE87,
PRICING_ATTRIBUTE88,
PRICING_ATTRIBUTE89,
PRICING_ATTRIBUTE90,
PRICING_ATTRIBUTE91,
PRICING_ATTRIBUTE92,
PRICING_ATTRIBUTE93,
PRICING_ATTRIBUTE94,
PRICING_ATTRIBUTE95,
PRICING_ATTRIBUTE96,
PRICING_ATTRIBUTE97,
PRICING_ATTRIBUTE98,
PRICING_ATTRIBUTE99,
PRICING_ATTRIBUTE100,
CONTEXT,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
OBJECT_VERSION_NUMBER
        FROM ASO_PRICE_ATTRIBUTES
	WHERE quote_header_id = p_qte_header_id AND
	   (quote_line_id = p_qte_line_id OR
		(quote_line_id IS NULL AND p_qte_line_id IS NULL));

Line: 5687


	   l_price_attr_rec.LAST_UPDATE_DATE := price_attr_rec.LAST_UPDATE_DATE;

Line: 5688


	   l_price_attr_rec.LAST_UPDATED_BY := price_attr_rec.LAST_UPDATED_BY;

Line: 5689


	   l_price_attr_rec.LAST_UPDATE_LOGIN := price_attr_rec.LAST_UPDATE_LOGIN;

Line: 5693


	   l_price_attr_rec.PROGRAM_UPDATE_DATE := price_attr_rec.PROGRAM_UPDATE_DATE;

Line: 5830


	SELECT
	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
	,QUOTE_SHIPMENT_ID
	,SECURITY_GROUP_ID
	,OBJECT_VERSION_NUMBER
	FROM aso_price_adj_relationships
	WHERE price_adjustment_id = P_Price_Adjustment_Id;

Line: 5858


l_price_adj_rltd_rec.LAST_UPDATE_DATE := C_Price_Adj_Rltd_Rec.LAST_UPDATE_DATE;

Line: 5859


l_price_adj_rltd_rec.LAST_UPDATED_BY := C_Price_Adj_Rltd_Rec.LAST_UPDATED_BY;

Line: 5860


l_price_adj_rltd_rec.LAST_UPDATE_LOGIN := C_Price_Adj_Rltd_Rec.LAST_UPDATE_LOGIN;

Line: 5863


l_price_adj_rltd_rec.PROGRAM_UPDATE_DATE := C_Price_Adj_Rltd_Rec.PROGRAM_UPDATE_DATE;

Line: 5880


     SELECT
     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
     ,QUOTE_SHIPMENT_ID
     ,SECURITY_GROUP_ID
     ,OBJECT_VERSION_NUMBER
     FROM aso_price_adj_relationships
     WHERE quote_line_id = P_Quote_Line_Id;

Line: 5908


l_price_adj_rltd_rec.LAST_UPDATE_DATE := C_Price_Adj_Rltd_Rec.LAST_UPDATE_DATE;

Line: 5909


l_price_adj_rltd_rec.LAST_UPDATED_BY := C_Price_Adj_Rltd_Rec.LAST_UPDATED_BY;

Line: 5910


l_price_adj_rltd_rec.LAST_UPDATE_LOGIN := C_Price_Adj_Rltd_Rec.LAST_UPDATE_LOGIN;

Line: 5913


l_price_adj_rltd_rec.PROGRAM_UPDATE_DATE := C_Price_Adj_Rltd_Rec.PROGRAM_UPDATE_DATE;

Line: 5934


select end_date_active
from fnd_profile_options
where profile_option_name = p_profile_name
and application_id = p_application_id
and trunc(start_date_active) <= trunc(sysdate)
and trunc(nvl(end_date_active, sysdate)) >= trunc(sysdate);

Line: 6342


	    SELECT ORG_INFORMATION1
	    INTO l_attribute_value
	    FROM hr_organization_information
	    WHERE org_information_context = 'ASO_ORG_INFO'
	    AND organization_id = p_organization_id ;

Line: 6353


	    SELECT ORG_INFORMATION2
	    INTO l_attribute_value
	    FROM hr_organization_information
	    WHERE org_information_context = 'ASO_ORG_INFO'
	    AND organization_id = p_organization_id ;

Line: 6364


	    SELECT ORG_INFORMATION3
	    INTO l_attribute_value
	    FROM hr_organization_information
	    WHERE org_information_context = 'ASO_ORG_INFO'
	    AND organization_id = p_organization_id ;

Line: 6375


	    SELECT ORG_INFORMATION4
	    INTO l_attribute_value
	    FROM hr_organization_information
	    WHERE org_information_context = 'ASO_ORG_INFO'
	    AND organization_id = p_organization_id ;

Line: 6386


	    SELECT ORG_INFORMATION5
	    INTO l_attribute_value
	    FROM hr_organization_information
	    WHERE org_information_context = 'ASO_ORG_INFO'
	    AND organization_id = p_organization_id ;

Line: 6466


PROCEDURE UPDATE_CHANGED_QUOTES (
	p_quote_number	ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE
)
IS

	l_module_name  VARCHAR2(30) := 'ASO';

Line: 6477


	l_to_insert		NUMBER ;

Line: 6484


	SELECT quote_number, conc_request_id
	FROM   aso_changed_quotes
	WHERE  quote_number = p_quote_number;

Line: 6489


	l_to_insert := 0;

Line: 6499


					aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : No record found for the quote number, inserting the new record.', 1, 'Y');

Line: 6501


				l_to_insert := 1;

Line: 6508


				-- Record exists but a conc request id is also present, hence insert the record
				IF aso_debug_pub.g_debug_flag = 'Y' THEN
					aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Found record with quote number passed but the conc request id is not null, hence inserting the new record.', 1, 'Y');

Line: 6512


				l_to_insert := 1;

Line: 6517


				-- Record exists with a null conc request id, hence we need not insert a new record
				IF aso_debug_pub.g_debug_flag = 'Y' THEN
					aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Found record with quote number and the conc request id is null, hence no need to insert the new record.', 1, 'Y');

Line: 6527


	-- TBD : If the cursor does not open, then insert the record or not?
	l_to_insert := 1;

Line: 6532


	l_to_insert := 0;

Line: 6536


IF (l_to_insert = 1) THEN

	IF aso_debug_pub.g_debug_flag = 'Y' THEN
		aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Before Inserting record in ASO_CHANGED_QUOTES', 1, 'Y');

Line: 6540


		aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Quote Number : ' || p_quote_number, 1, 'Y');

Line: 6543


	ASO_CHANGED_QUOTES_PKG.INSERT_ROW(
		P_QUOTE_NUMBER			=> p_quote_number,
		P_LAST_UPDATE_DATE		=> SYSDATE,
		P_LAST_UPDATED_BY		=> G_USER_ID,
		P_CREATION_DATE			=> SYSDATE,
		P_CREATED_BY			=> G_USER_ID,
		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,
		P_CONC_REQUEST_ID		=> FND_API.G_MISS_NUM
	);

Line: 6561


	l_error_text := 'Error in ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : ' || SQLERRM;

Line: 6568


END UPDATE_CHANGED_QUOTES;

Line: 6574


	cursor CUR_MO_GLOB is select
		ORGANIZATION_ID,
		ORGANIZATION_NAME
	FROM MO_GLOB_ORG_ACCESS_TMP;

Line: 6673


                  P_tax_rec.LAST_UPDATED_BY<> FND_API.G_MISS_NUM OR
                  P_tax_rec.LAST_UPDATE_DATE<> FND_API.G_MISS_DATE OR
                  P_tax_rec.LAST_UPDATE_LOGIN<> FND_API.G_MISS_NUM OR
                  P_tax_rec.ORIG_TAX_CODE<> FND_API.G_MISS_CHAR OR
                  P_tax_rec.PROGRAM_APPLICATION_ID<> FND_API.G_MISS_NUM OR
                  P_tax_rec.PROGRAM_ID<> FND_API.G_MISS_NUM OR
                  P_tax_rec.PROGRAM_UPDATE_DATE<> FND_API.G_MISS_DATE OR
                  P_tax_rec.QUOTE_HEADER_ID<> FND_API.G_MISS_NUM OR
                  P_tax_rec.QUOTE_LINE_ID<> FND_API.G_MISS_NUM OR
                  P_tax_rec.QUOTE_SHIPMENT_ID<> FND_API.G_MISS_NUM OR
                  P_tax_rec.REQUEST_ID<> FND_API.G_MISS_NUM OR
                  P_tax_rec.TAX_AMOUNT<> FND_API.G_MISS_NUM OR
                  P_tax_rec.TAX_CODE<> FND_API.G_MISS_CHAR OR
                  P_tax_rec.TAX_DATE<> FND_API.G_MISS_DATE OR
                  P_tax_rec.TAX_DETAIL_ID<> FND_API.G_MISS_NUM OR
                  P_tax_rec.TAX_EXEMPT_FLAG<> FND_API.G_MISS_CHAR OR
                  P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR
                  P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR
                  P_tax_rec.TAX_RATE<> FND_API.G_MISS_NUM ) THEN

              IF aso_debug_pub.g_debug_flag = 'Y' THEN
              aso_debug_pub.add('Tax_Rec_Exists function returning TRUE');