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

	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


	FROM ASO_QUOTE_HEADERS_ALL
	WHERE quote_header_id = p_qte_header_id;

Line: 762


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


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


	   l_price_adj_rec.LAST_UPDATE_DATE := price_adj_rec.LAST_UPDATE_DATE;

Line: 969


	   l_price_adj_rec.LAST_UPDATED_BY := price_adj_rec.LAST_UPDATED_BY;

Line: 970


	   l_price_adj_rec.LAST_UPDATE_LOGIN := price_adj_rec.LAST_UPDATE_LOGIN;

Line: 974


	   l_price_adj_rec.PROGRAM_UPDATE_DATE := price_adj_rec.PROGRAM_UPDATE_DATE;

Line: 986


	   l_price_adj_rec.UPDATE_ALLOWABLE_FLAG := price_adj_rec.UPDATE_ALLOWABLE_FLAG;

Line: 987


	   l_price_adj_rec.UPDATED_FLAG := price_adj_rec.UPDATED_FLAG;

Line: 1051


	   l_price_adj_rec.UPDATE_ALLOWED := price_adj_rec.UPDATE_ALLOWED;

Line: 1064


	   l_price_adj_rec.LAST_UPDATE_DATE := price_adj_rec.LAST_UPDATE_DATE;

Line: 1065


	   l_price_adj_rec.LAST_UPDATED_BY := price_adj_rec.LAST_UPDATED_BY;

Line: 1066


	   l_price_adj_rec.LAST_UPDATE_LOGIN := price_adj_rec.LAST_UPDATE_LOGIN;

Line: 1070


	   l_price_adj_rec.PROGRAM_UPDATE_DATE := price_adj_rec.PROGRAM_UPDATE_DATE;

Line: 1082


	   l_price_adj_rec.UPDATE_ALLOWABLE_FLAG := price_adj_rec.UPDATE_ALLOWABLE_FLAG;

Line: 1083


	   l_price_adj_rec.UPDATED_FLAG := price_adj_rec.UPDATED_FLAG;

Line: 1147


	   l_price_adj_rec.UPDATE_ALLOWED := price_adj_rec.UPDATE_ALLOWED;

Line: 1166


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


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


	   l_price_adj_rec.LAST_UPDATE_DATE := price_adj_rec.LAST_UPDATE_DATE;

Line: 1374


	   l_price_adj_rec.LAST_UPDATED_BY := price_adj_rec.LAST_UPDATED_BY;

Line: 1375


	   l_price_adj_rec.LAST_UPDATE_LOGIN := price_adj_rec.LAST_UPDATE_LOGIN;

Line: 1379


	   l_price_adj_rec.PROGRAM_UPDATE_DATE := price_adj_rec.PROGRAM_UPDATE_DATE;

Line: 1391


	   l_price_adj_rec.UPDATE_ALLOWABLE_FLAG := price_adj_rec.UPDATE_ALLOWABLE_FLAG;

Line: 1392


	   l_price_adj_rec.UPDATED_FLAG := price_adj_rec.UPDATED_FLAG;

Line: 1456


	   l_price_adj_rec.UPDATE_ALLOWED := price_adj_rec.UPDATE_ALLOWED;

Line: 1469


	   l_price_adj_rec.LAST_UPDATE_DATE := price_adj_rec.LAST_UPDATE_DATE;

Line: 1470


	   l_price_adj_rec.LAST_UPDATED_BY := price_adj_rec.LAST_UPDATED_BY;

Line: 1471


	   l_price_adj_rec.LAST_UPDATE_LOGIN := price_adj_rec.LAST_UPDATE_LOGIN;

Line: 1475


	   l_price_adj_rec.PROGRAM_UPDATE_DATE := price_adj_rec.PROGRAM_UPDATE_DATE;

Line: 1487


	   l_price_adj_rec.UPDATE_ALLOWABLE_FLAG := price_adj_rec.UPDATE_ALLOWABLE_FLAG;

Line: 1488


	   l_price_adj_rec.UPDATED_FLAG := price_adj_rec.UPDATED_FLAG;

Line: 1552


	   l_price_adj_rec.UPDATE_ALLOWED := price_adj_rec.UPDATE_ALLOWED;

Line: 1572


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


        l_price_adj_rec.LAST_UPDATE_DATE := price_adj_rec.LAST_UPDATE_DATE;

Line: 1679


        l_price_adj_rec.LAST_UPDATED_BY := price_adj_rec.LAST_UPDATED_BY;

Line: 1680


        l_price_adj_rec.LAST_UPDATE_LOGIN := price_adj_rec.LAST_UPDATE_LOGIN;

Line: 1684


        l_price_adj_rec.PROGRAM_UPDATE_DATE := price_adj_rec.PROGRAM_UPDATE_DATE;

Line: 1697


       l_price_adj_rec.UPDATE_ALLOWABLE_FLAG := price_adj_rec.UPDATE_ALLOWABLE_FLAG;

Line: 1698


       l_price_adj_rec.UPDATED_FLAG := price_adj_rec.UPDATED_FLAG;

Line: 1761


     l_price_adj_rec.UPDATE_ALLOWED := price_adj_rec.UPDATE_ALLOWED;

Line: 1776


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


	   l_price_adj_attr_rec.LAST_UPDATE_DATE := price_adj_attr_rec.LAST_UPDATE_DATE;

Line: 1808


	   l_price_adj_attr_rec.LAST_UPDATED_BY := price_adj_attr_rec.LAST_UPDATED_BY;

Line: 1809


	   l_price_adj_attr_rec.LAST_UPDATE_LOGIN := price_adj_attr_rec.LAST_UPDATE_LOGIN;

Line: 1813


	   l_price_adj_attr_rec.PROGRAM_UPDATE_DATE := price_adj_attr_rec.PROGRAM_UPDATE_DATE;

Line: 1835


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


	   l_payment_rec.LAST_UPDATE_DATE := payment_rec.LAST_UPDATE_DATE;

Line: 1897


	   l_payment_rec.LAST_UPDATED_BY := payment_rec.LAST_UPDATED_BY;

Line: 1898


	   l_payment_rec.LAST_UPDATE_LOGIN := payment_rec.LAST_UPDATE_LOGIN;

Line: 1902


	   l_payment_rec.PROGRAM_UPDATE_DATE := payment_rec.PROGRAM_UPDATE_DATE;

Line: 1960


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


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


	   l_tax_detail_rec.LAST_UPDATE_DATE := tax_rec.LAST_UPDATE_DATE;

Line: 2073


	   l_tax_detail_rec.LAST_UPDATED_BY := tax_rec.LAST_UPDATED_BY;

Line: 2074


	   l_tax_detail_rec.LAST_UPDATE_LOGIN := tax_rec.LAST_UPDATE_LOGIN;

Line: 2078


	   l_tax_detail_rec.PROGRAM_UPDATE_DATE := tax_rec.PROGRAM_UPDATE_DATE;

Line: 2123


	   l_tax_detail_rec.LAST_UPDATE_DATE := tax_rec.LAST_UPDATE_DATE;

Line: 2124


	   l_tax_detail_rec.LAST_UPDATED_BY := tax_rec.LAST_UPDATED_BY;

Line: 2125


	   l_tax_detail_rec.LAST_UPDATE_LOGIN := tax_rec.LAST_UPDATE_LOGIN;

Line: 2129


	   l_tax_detail_rec.PROGRAM_UPDATE_DATE := tax_rec.PROGRAM_UPDATE_DATE;

Line: 2178


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


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


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


	   l_shipment_rec.LAST_UPDATE_DATE := shipment_rec.LAST_UPDATE_DATE;

Line: 2460


	   l_shipment_rec.LAST_UPDATED_BY := shipment_rec.LAST_UPDATED_BY;

Line: 2461


	   l_shipment_rec.LAST_UPDATE_LOGIN := shipment_rec.LAST_UPDATE_LOGIN;

Line: 2465


	   l_shipment_rec.PROGRAM_UPDATE_DATE := shipment_rec.PROGRAM_UPDATE_DATE;

Line: 2523


	   l_shipment_rec.LAST_UPDATE_DATE := shipment_rec.LAST_UPDATE_DATE;

Line: 2524


	   l_shipment_rec.LAST_UPDATED_BY := shipment_rec.LAST_UPDATED_BY;

Line: 2525


	   l_shipment_rec.LAST_UPDATE_LOGIN := shipment_rec.LAST_UPDATE_LOGIN;

Line: 2529


	   l_shipment_rec.PROGRAM_UPDATE_DATE := shipment_rec.PROGRAM_UPDATE_DATE;

Line: 2593


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


	   l_shipment_rec.LAST_UPDATE_DATE := shipment_rec.LAST_UPDATE_DATE;

Line: 2668


	   l_shipment_rec.LAST_UPDATED_BY := shipment_rec.LAST_UPDATED_BY;

Line: 2669


	   l_shipment_rec.LAST_UPDATE_LOGIN := shipment_rec.LAST_UPDATE_LOGIN;

Line: 2673


	   l_shipment_rec.PROGRAM_UPDATE_DATE := shipment_rec.PROGRAM_UPDATE_DATE;

Line: 2735


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


	   l_freight_charge_rec.LAST_UPDATE_DATE := freight_charge_rec.LAST_UPDATE_DATE;

Line: 2778


	   l_freight_charge_rec.LAST_UPDATED_BY := freight_charge_rec.LAST_UPDATED_BY;

Line: 2779


	   l_freight_charge_rec.LAST_UPDATE_LOGIN := freight_charge_rec.LAST_UPDATE_LOGIN;

Line: 2783


	   l_freight_charge_rec.PROGRAM_UPDATE_DATE := freight_charge_rec.PROGRAM_UPDATE_DATE;

Line: 2819


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


l_sales_credit_rec.LAST_UPDATED_BY :=                sales_rec.LAST_UPDATED_BY;

Line: 2869


l_sales_credit_rec.LAST_UPDATE_DATE :=               sales_rec.LAST_UPDATE_DATE;

Line: 2870


l_sales_credit_rec.LAST_UPDATE_LOGIN :=              sales_rec.LAST_UPDATE_LOGIN;

Line: 2874


l_sales_credit_rec.PROGRAM_UPDATE_DATE :=            sales_rec.PROGRAM_UPDATE_DATE;

Line: 2920


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


l_sales_credit_rec.LAST_UPDATED_BY :=                sales_rec.LAST_UPDATED_BY;

Line: 2971


l_sales_credit_rec.LAST_UPDATE_DATE :=               sales_rec.LAST_UPDATE_DATE;

Line: 2972


l_sales_credit_rec.LAST_UPDATE_LOGIN :=              sales_rec.LAST_UPDATE_LOGIN;

Line: 2976


l_sales_credit_rec.PROGRAM_UPDATE_DATE :=            sales_rec.PROGRAM_UPDATE_DATE;

Line: 3024


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


l_quote_party_rec.LAST_UPDATE_DATE :=               qpt_rec.LAST_UPDATE_DATE;

Line: 3066


l_quote_party_rec.LAST_UPDATE_LOGIN :=              qpt_rec.LAST_UPDATE_LOGIN;

Line: 3067


l_quote_party_rec.LAST_UPDATED_BY :=                qpt_rec.LAST_UPDATED_BY;

Line: 3071


l_quote_party_rec.PROGRAM_UPDATE_DATE :=            qpt_rec.PROGRAM_UPDATE_DATE;

Line: 3110


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


l_quote_party_rec.LAST_UPDATE_DATE :=               qpt_rec.LAST_UPDATE_DATE;

Line: 3152


l_quote_party_rec.LAST_UPDATE_LOGIN :=              qpt_rec.LAST_UPDATE_LOGIN;

Line: 3153


l_quote_party_rec.LAST_UPDATED_BY :=                qpt_rec.LAST_UPDATED_BY;

Line: 3157


l_quote_party_rec.PROGRAM_UPDATE_DATE :=            qpt_rec.PROGRAM_UPDATE_DATE;

Line: 3196


	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
	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
	FROM ASO_QUOTE_LINES_ALL
	WHERE quote_line_id = p_qte_line_id;

Line: 3382


	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

         FROM ASO_Quote_Lines_All
	WHERE quote_header_id = p_qte_header_id
	ORDER BY Line_Number;

Line: 3476


	   l_qte_line_rec.LAST_UPDATE_DATE := line_rec.LAST_UPDATE_DATE;

Line: 3477


	   l_qte_line_rec.LAST_UPDATED_BY := line_rec.LAST_UPDATED_BY;

Line: 3478


	   l_qte_line_rec.LAST_UPDATE_LOGIN := line_rec.LAST_UPDATE_LOGIN;

Line: 3482


	   l_qte_line_rec.PROGRAM_UPDATE_DATE := line_rec.PROGRAM_UPDATE_DATE;

Line: 3566


     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
         FROM ASO_Pvt_Quote_Lines_Bali_V
     WHERE quote_header_id = p_qte_header_id;

Line: 3657


        l_qte_line_rec.LAST_UPDATE_DATE := line_rec.LAST_UPDATE_DATE;

Line: 3658


        l_qte_line_rec.LAST_UPDATED_BY := line_rec.LAST_UPDATED_BY;

Line: 3659


        l_qte_line_rec.LAST_UPDATE_LOGIN := line_rec.LAST_UPDATE_LOGIN;

Line: 3663


        l_qte_line_rec.PROGRAM_UPDATE_DATE := line_rec.PROGRAM_UPDATE_DATE;

Line: 3745


	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
        FROM aso_pvt_quote_lines_sort_v
	WHERE quote_header_id = p_qte_header_id;

Line: 3836


	   l_qte_line_rec.LAST_UPDATE_DATE := line_rec.LAST_UPDATE_DATE;

Line: 3837


	   l_qte_line_rec.LAST_UPDATED_BY := line_rec.LAST_UPDATED_BY;

Line: 3838


	   l_qte_line_rec.LAST_UPDATE_LOGIN := line_rec.LAST_UPDATE_LOGIN;

Line: 3842


	   l_qte_line_rec.PROGRAM_UPDATE_DATE := line_rec.PROGRAM_UPDATE_DATE;

Line: 3926


	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
		 --CONFIG_MODEL_TYPE
	    FROM ASO_PVT_QUOTE_LINES_BALI_V
	WHERE quote_header_id = p_qte_header_id;

Line: 4017


	   l_qte_line_rec.LAST_UPDATE_DATE := line_rec.LAST_UPDATE_DATE;

Line: 4018


	   l_qte_line_rec.LAST_UPDATED_BY := line_rec.LAST_UPDATED_BY;

Line: 4019


	   l_qte_line_rec.LAST_UPDATE_LOGIN := line_rec.LAST_UPDATE_LOGIN;

Line: 4023


	   l_qte_line_rec.PROGRAM_UPDATE_DATE := line_rec.PROGRAM_UPDATE_DATE;

Line: 4110


	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
   FROM ASO_Quote_Lines_All
   WHERE quote_header_id = p_qte_header_id
   ORDER BY Line_Number;

Line: 4196


         SELECT service_ref_type_code , service_ref_line_id
	 FROM   ASO_QUOTE_LINE_DETAILS
	 WHERE  quote_line_id = p_qte_line_id;

Line: 4201


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


	 SELECT cust_account_id
	 FROM ASO_QUOTE_HEADERS_ALL
	 WHERE quote_header_id = p_qte_header_id;

Line: 4213


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


	     l_qte_line_rec.LAST_UPDATE_DATE := c_qte_line_rec.LAST_UPDATE_DATE;

Line: 4353


	     l_qte_line_rec.LAST_UPDATED_BY := c_qte_line_rec.LAST_UPDATED_BY;

Line: 4354


	     l_qte_line_rec.LAST_UPDATE_LOGIN := c_qte_line_rec.LAST_UPDATE_LOGIN;

Line: 4358


	     l_qte_line_rec.PROGRAM_UPDATE_DATE := c_qte_line_rec.PROGRAM_UPDATE_DATE;

Line: 4458


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


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


         SELECT service_ref_type_code , service_ref_line_id
	 FROM   ASO_QUOTE_LINE_DETAILS
	 WHERE  quote_line_id = p_qte_line_id;

Line: 4559


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


      SELECT cust_account_id
      FROM ASO_QUOTE_HEADERS_ALL
      WHERE quote_header_id = p_qte_header_id;

Line: 4571


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


	         l_qte_line_rec.LAST_UPDATE_DATE := c_qte_line_rec.LAST_UPDATE_DATE;

Line: 4687


	         l_qte_line_rec.LAST_UPDATED_BY := c_qte_line_rec.LAST_UPDATED_BY;

Line: 4688


	         l_qte_line_rec.LAST_UPDATE_LOGIN := c_qte_line_rec.LAST_UPDATE_LOGIN;

Line: 4692


	         l_qte_line_rec.PROGRAM_UPDATE_DATE := c_qte_line_rec.PROGRAM_UPDATE_DATE;

Line: 4780


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


	   l_line_dtl_rec.LAST_UPDATE_DATE := line_dtl_rec.LAST_UPDATE_DATE;

Line: 4873


	   l_line_dtl_rec.LAST_UPDATED_BY := line_dtl_rec.LAST_UPDATED_BY;

Line: 4874


	   l_line_dtl_rec.LAST_UPDATE_LOGIN := line_dtl_rec.LAST_UPDATE_LOGIN;

Line: 4878


	   l_line_dtl_rec.PROGRAM_UPDATE_DATE := line_dtl_rec.PROGRAM_UPDATE_DATE;

Line: 4966


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


	   l_line_attr_ext_rec.LAST_UPDATE_DATE := line_attr_ext_rec.LAST_UPDATE_DATE;

Line: 5000


	   l_line_attr_ext_rec.LAST_UPDATED_BY := line_attr_ext_rec.LAST_UPDATED_BY;

Line: 5001


	   l_line_attr_ext_rec.LAST_UPDATE_LOGIN := line_attr_ext_rec.LAST_UPDATE_LOGIN;

Line: 5005


	   l_line_attr_ext_rec.PROGRAM_UPDATE_DATE := line_attr_ext_rec.PROGRAM_UPDATE_DATE;

Line: 5027


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


	   l_line_attr_ext_rec.LAST_UPDATE_DATE := line_attr_ext_rec.LAST_UPDATE_DATE;

Line: 5060


	   l_line_attr_ext_rec.LAST_UPDATED_BY := line_attr_ext_rec.LAST_UPDATED_BY;

Line: 5061


	   l_line_attr_ext_rec.LAST_UPDATE_LOGIN := line_attr_ext_rec.LAST_UPDATE_LOGIN;

Line: 5065


	   l_line_attr_ext_rec.PROGRAM_UPDATE_DATE := line_attr_ext_rec.PROGRAM_UPDATE_DATE;

Line: 5088


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


	   l_price_attr_rec.LAST_UPDATE_DATE := price_attr_rec.LAST_UPDATE_DATE;

Line: 5237


	   l_price_attr_rec.LAST_UPDATED_BY := price_attr_rec.LAST_UPDATED_BY;

Line: 5238


	   l_price_attr_rec.LAST_UPDATE_LOGIN := price_attr_rec.LAST_UPDATE_LOGIN;

Line: 5242


	   l_price_attr_rec.PROGRAM_UPDATE_DATE := price_attr_rec.PROGRAM_UPDATE_DATE;

Line: 5379


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


l_price_adj_rltd_rec.LAST_UPDATE_DATE := C_Price_Adj_Rltd_Rec.LAST_UPDATE_DATE;

Line: 5408


l_price_adj_rltd_rec.LAST_UPDATED_BY := C_Price_Adj_Rltd_Rec.LAST_UPDATED_BY;

Line: 5409


l_price_adj_rltd_rec.LAST_UPDATE_LOGIN := C_Price_Adj_Rltd_Rec.LAST_UPDATE_LOGIN;

Line: 5412


l_price_adj_rltd_rec.PROGRAM_UPDATE_DATE := C_Price_Adj_Rltd_Rec.PROGRAM_UPDATE_DATE;

Line: 5429


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


l_price_adj_rltd_rec.LAST_UPDATE_DATE := C_Price_Adj_Rltd_Rec.LAST_UPDATE_DATE;

Line: 5458


l_price_adj_rltd_rec.LAST_UPDATED_BY := C_Price_Adj_Rltd_Rec.LAST_UPDATED_BY;

Line: 5459


l_price_adj_rltd_rec.LAST_UPDATE_LOGIN := C_Price_Adj_Rltd_Rec.LAST_UPDATE_LOGIN;

Line: 5462


l_price_adj_rltd_rec.PROGRAM_UPDATE_DATE := C_Price_Adj_Rltd_Rec.PROGRAM_UPDATE_DATE;

Line: 5483


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


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


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


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


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


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


PROCEDURE UPDATE_CHANGED_QUOTES (
	p_quote_number	ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE
)
IS

	l_module_name  VARCHAR2(30) := 'ASO';

Line: 6026


	l_to_insert		NUMBER ;

Line: 6033


	SELECT quote_number, conc_request_id
	FROM   aso_changed_quotes
	WHERE  quote_number = p_quote_number;

Line: 6038


	l_to_insert := 0;

Line: 6048


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

Line: 6050


				l_to_insert := 1;

Line: 6057


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


				l_to_insert := 1;

Line: 6066


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


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

Line: 6081


	l_to_insert := 0;

Line: 6085


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


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

Line: 6092


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


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

Line: 6117


END UPDATE_CHANGED_QUOTES;

Line: 6123


	cursor CUR_MO_GLOB is select
		ORGANIZATION_ID,
		ORGANIZATION_NAME
	FROM MO_GLOB_ORG_ACCESS_TMP;

Line: 6222


                  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');