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

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

Line: 41


	SELECT 'X'
	FROM ASO_QUOTE_HEADERS_ALL
	WHERE quote_header_id = x_qte_header_id;

Line: 46


	SELECT a.LINE_RELATIONSHIP_ID, a.QUOTE_LINE_ID, a.RELATED_QUOTE_LINE_ID,
		a.RELATIONSHIP_TYPE_CODE, a.RECIPROCAL_FLAG
	FROM ASO_LINE_RELATIONSHIPS a, aso_quote_lines_all b
	WHERE  a.quote_line_id = b.quote_line_id
	and b.quote_header_id = x_quote_header_id;

Line: 53


	SELECT quote_status_id
	FROM ASO_QUOTE_STATUSES_B
	WHERE status_code = c_status_code;

Line: 58


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

Line: 63


     SELECT payment_type_code
     FROM ASO_PAYMENTS
     WHERE quote_header_id = qte_hdr_id ;

Line: 68


     SELECT nvl(total_quote_price ,0)
     FROM ASO_QUOTE_HEADERS_ALL
     WHERE quote_header_id = qte_hdr_id ;

Line: 74


     SELECT complete_configuration_flag, valid_configuration_flag, instance_id
     FROM aso_quote_line_details
     WHERE quote_line_id = qte_line_id;

Line: 79


    CURSOR C_Get_Update_Date(qte_hdr_id NUMBER) IS
	SELECT Last_Update_Date
	FROM ASO_QUOTE_HEADERS_ALL
	WHERE Quote_Header_Id = qte_hdr_id;

Line: 170


     SELECT booked_flag
     FROM OE_ORDER_HEADERS_V
     WHERE  header_id = lx_order_header_rec.order_header_id;

Line: 190


    l_Update_Allowed_Flg    varchar2(1):='F';

Line: 196


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

Line: 262


     OPEN C_Get_Update_Date(P_Qte_Header_Rec.Quote_Header_Id);

Line: 263


	FETCH C_Get_Update_Date INTO l_last_upd_date;

Line: 267


     aso_debug_pub.add('Submit_Q: p_qte_header_rec.last_update_date: '||p_qte_header_rec.last_update_date, 1, 'N');

Line: 270


	IF (C_Get_Update_Date%NOTFOUND) OR
        (l_last_upd_date IS NULL OR l_last_upd_date = FND_API.G_MISS_DATE) THEN
	  IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
	      FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');

Line: 274


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

Line: 277


       CLOSE C_Get_Update_Date;

Line: 281


	CLOSE C_Get_Update_Date;

Line: 283


     IF (p_qte_header_rec.last_update_date IS NOT NULL AND
         p_qte_header_rec.last_update_date <> FND_API.G_MISS_DATE) AND
        (l_last_upd_date <> p_qte_header_rec.last_update_date) Then
	  IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
	      FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');

Line: 527


            select count(*) into l_mdl_count
	     from aso_Quote_lines_all
	     where quote_header_id=p_qte_header_rec.quote_header_id
	     and item_type_code='MDL';

Line: 538


			select decode(update_allowed_flag,'Y','T','F') into l_Update_Allowed_Flg
			from aso_quote_statuses_vl
			where QUOTE_STATUS_ID = l_qte_header_rec.quote_status_id;

Line: 542


			if l_Update_Allowed_Flg='F' then
				if NVL(FND_PROFILE.VALUE('ASO_STATUS_OVERRIDE'),'N') = 'Y' THEN
					l_Update_Allowed_Flg := 'T';

Line: 546


		      end if;-- l_update_allowed_flag

Line: 551


				aso_debug_pub.add('Submit_Quote - l_Update_Allowed_Flg:  '||l_Update_Allowed_Flg, 1, 'N');

Line: 560


			P_UPDATE_QUOTE        =>l_Update_Allowed_Flg,
			P_CONFIG_EFFECTIVE_DATE      => FND_API.G_MISS_DATE,
			P_CONFIG_model_lookup_DATE   => FND_API.G_MISS_DATE,
			X_Config_tbl          => lx_config_tbl,
			X_Return_Status       => x_return_status,
			X_Msg_Count           => x_msg_count,
			X_Msg_Data            => x_msg_data
                       );

Line: 590


			  if  l_Update_Allowed_Flg ='T' then
			       --commit work;

Line: 609


                        end if;  -- l_Update_Allowed_Flg

Line: 1011


aso_debug_pub.add('Submit_Quote - before ASO_EDUCATION_INT.Update_OTA_With_OrderLine ', 1, 'N');

Line: 1013


     ASO_EDUCATION_INT.Update_OTA_With_OrderLine(
          P_Init_Msg_List          => FND_API.G_FALSE,
          P_Commit                 => FND_API.G_FALSE,
          P_Order_Line_Tbl         => lx_order_line_tbl,
          X_Return_Status          => x_return_status,
          X_Msg_Count              => x_msg_count,
          X_Msg_Data               => x_msg_data);

Line: 1021


aso_debug_pub.add('Submit_Quote - after ASO_EDUCATION_INT.Update_OTA_With_OrderLine: '||x_return_status, 1, 'N');

Line: 1077


	-- update order line id for quote lines
-- hyang quote_status
    -- update quote_status to 'ORDER SUBMITTED'.
    OPEN c_qte_status_id ('ORDER SUBMITTED');

Line: 1085


	UPDATE ASO_QUOTE_HEADERS_ALL
	SET order_Id           =  x_order_header_rec.order_header_id,
         quote_status_id    =  l_qte_status_id,
         last_update_date   =  sysdate,
         last_updated_by    =  fnd_global.user_id,
         last_update_login  =  fnd_global.conc_login_id
	WHERE quote_header_id = p_qte_header_rec.quote_header_id;

Line: 1094


	-- update order line id for quote lines

	UPDATE ASO_SHIPMENTS
	SET order_line_id      =  lx_order_line_tbl(i).order_line_id,
         last_update_date   =  sysdate,
         last_updated_by    =  fnd_global.user_id,
         last_update_login  =  fnd_global.conc_login_id
	WHERE shipment_id = lx_order_line_tbl(i).quote_shipment_line_id;

Line: 1103


	-- update installment details
	-- hyang 1935614 csi integration
	  ASO_INSTBASE_INT.Update_Inst_Details_ORDER(
		P_Api_Version_Number	=> 1.0,
		P_Init_Msg_List 	=> FND_API.G_FALSE,
		P_Commit		=> FND_API.G_FALSE,
		P_Quote_Line_Shipment_id=> lx_order_line_tbl(i).quote_shipment_line_id,
		P_Order_Line_Id		=> lx_order_line_tbl(i).order_line_id,
		X_Return_Status 	=> x_Return_Status,
		X_Msg_Count		=> X_Msg_Count,
		X_Msg_Data		=> X_Msg_Data );

Line: 1115


aso_debug_pub.add('Submit_Q: After Update_Inst_Details x_return_status: '||x_return_status, 1, 'N');

Line: 1119


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

Line: 1226


                         UPDATE ASO_QUOTE_HEADERS_ALL
                         SET Order_Id           =  x_order_header_rec.order_header_id,
                             last_update_date   =  sysdate,
                             last_updated_by    =  fnd_global.user_id,
                             last_update_login  =  fnd_global.conc_login_id
                         WHERE quote_header_id = p_qte_header_rec.quote_header_id;

Line: 1380


    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,
	TAX_INCLUSIVE_FLAG,
	TAX_RATE_ID
  FROM ASO_TAX_DETAILS
  WHERE quote_header_id = p_qte_header_id
  AND quote_line_id IS NULL ;

Line: 1425


    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,
     TAX_INCLUSIVE_FLAG,
	TAX_RATE_ID
    FROM ASO_TAX_DETAILS
    WHERE quote_line_id = p_qte_line_id;

Line: 1490


	   lx_tax_detail_tbl(l_tax_det_count).LAST_UPDATE_DATE := tax_rec.LAST_UPDATE_DATE;

Line: 1491


	   lx_tax_detail_tbl(l_tax_det_count).LAST_UPDATED_BY := tax_rec.LAST_UPDATED_BY;

Line: 1492


	   lx_tax_detail_tbl(l_tax_det_count).LAST_UPDATE_LOGIN := tax_rec.LAST_UPDATE_LOGIN;

Line: 1496


	   lx_tax_detail_tbl(l_tax_det_count).PROGRAM_UPDATE_DATE := tax_rec.PROGRAM_UPDATE_DATE;

Line: 1536


	   lx_tax_detail_tbl(l_tax_det_count).LAST_UPDATE_DATE := tax_rec.LAST_UPDATE_DATE;

Line: 1537


	   lx_tax_detail_tbl(l_tax_det_count).LAST_UPDATED_BY := tax_rec.LAST_UPDATED_BY;

Line: 1538


	   lx_tax_detail_tbl(l_tax_det_count).LAST_UPDATE_LOGIN := tax_rec.LAST_UPDATE_LOGIN;

Line: 1542


	   lx_tax_detail_tbl(l_tax_det_count).PROGRAM_UPDATE_DATE := tax_rec.PROGRAM_UPDATE_DATE;

Line: 1592


	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,
           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: 1655


	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,
           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_line_id = p_qte_line_id;

Line: 1733


	   lx_shipment_tbl(l_ship_count).LAST_UPDATE_DATE := shipment_rec.LAST_UPDATE_DATE;

Line: 1734


	   lx_shipment_tbl(l_ship_count).LAST_UPDATED_BY := shipment_rec.LAST_UPDATED_BY;

Line: 1735


	   lx_shipment_tbl(l_ship_count).LAST_UPDATE_LOGIN := shipment_rec.LAST_UPDATE_LOGIN;

Line: 1739


	   lx_shipment_tbl(l_ship_count).PROGRAM_UPDATE_DATE := shipment_rec.PROGRAM_UPDATE_DATE;

Line: 1797


	   lx_shipment_tbl(l_ship_count).LAST_UPDATE_DATE := shipment_rec.LAST_UPDATE_DATE;

Line: 1798


	   lx_shipment_tbl(l_ship_count).LAST_UPDATED_BY := shipment_rec.LAST_UPDATED_BY;

Line: 1799


	   lx_shipment_tbl(l_ship_count).LAST_UPDATE_LOGIN := shipment_rec.LAST_UPDATE_LOGIN;

Line: 1803


	   lx_shipment_tbl(l_ship_count).PROGRAM_UPDATE_DATE := shipment_rec.PROGRAM_UPDATE_DATE;

Line: 1868


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


	   lx_freight_charge_tbl(l_frt_chrg_count).LAST_UPDATE_DATE := freight_charge_rec.LAST_UPDATE_DATE;

Line: 1918


	   lx_freight_charge_tbl(l_frt_chrg_count).LAST_UPDATED_BY := freight_charge_rec.LAST_UPDATED_BY;

Line: 1919


	   lx_freight_charge_tbl(l_frt_chrg_count).LAST_UPDATE_LOGIN := freight_charge_rec.LAST_UPDATE_LOGIN;

Line: 1923


	   lx_freight_charge_tbl(l_frt_chrg_count).PROGRAM_UPDATE_DATE := freight_charge_rec.PROGRAM_UPDATE_DATE;

Line: 1965


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,
OBJECT_VERSION_NUMBER
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: 2013


lx_sales_credit_tbl(l_sls_crdt_count).LAST_UPDATED_BY :=                sales_rec.LAST_UPDATED_BY;

Line: 2014


lx_sales_credit_tbl(l_sls_crdt_count).LAST_UPDATE_DATE :=               sales_rec.LAST_UPDATE_DATE;

Line: 2015


lx_sales_credit_tbl(l_sls_crdt_count).LAST_UPDATE_LOGIN :=              sales_rec.LAST_UPDATE_LOGIN;

Line: 2019


lx_sales_credit_tbl(l_sls_crdt_count).PROGRAM_UPDATE_DATE :=            sales_rec.PROGRAM_UPDATE_DATE;

Line: 2063


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


lx_quote_party_tbl(l_quote_party_count).LAST_UPDATE_DATE :=               qpt_rec.LAST_UPDATE_DATE;

Line: 2110


lx_quote_party_tbl(l_quote_party_count).LAST_UPDATE_LOGIN :=              qpt_rec.LAST_UPDATE_LOGIN;

Line: 2111


lx_quote_party_tbl(l_quote_party_count).LAST_UPDATED_BY :=                qpt_rec.LAST_UPDATED_BY;

Line: 2115


lx_quote_party_tbl(l_quote_party_count).PROGRAM_UPDATE_DATE :=            qpt_rec.PROGRAM_UPDATE_DATE;

Line: 2154


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

Line: 2242


	   lx_line_dtl_tbl(l_line_dtl_count).LAST_UPDATE_DATE := line_dtl_rec.LAST_UPDATE_DATE;

Line: 2243


	   lx_line_dtl_tbl(l_line_dtl_count).LAST_UPDATED_BY := line_dtl_rec.LAST_UPDATED_BY;

Line: 2244


	   lx_line_dtl_tbl(l_line_dtl_count).LAST_UPDATE_LOGIN := line_dtl_rec.LAST_UPDATE_LOGIN;

Line: 2248


	   lx_line_dtl_tbl(l_line_dtl_count).PROGRAM_UPDATE_DATE := line_dtl_rec.PROGRAM_UPDATE_DATE;

Line: 2328


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


	   lx_line_attr_ext_tbl(l_line_attr_ext_count).LAST_UPDATE_DATE := line_attr_ext_rec.LAST_UPDATE_DATE;

Line: 2368


	   lx_line_attr_ext_tbl(l_line_attr_ext_count).LAST_UPDATED_BY := line_attr_ext_rec.LAST_UPDATED_BY;

Line: 2369


	   lx_line_attr_ext_tbl(l_line_attr_ext_count).LAST_UPDATE_LOGIN := line_attr_ext_rec.LAST_UPDATE_LOGIN;

Line: 2373


	   lx_line_attr_ext_tbl(l_line_attr_ext_count).PROGRAM_UPDATE_DATE := line_attr_ext_rec.PROGRAM_UPDATE_DATE;

Line: 2402


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


	   lx_price_attr_tbl(l_price_attr_count).LAST_UPDATE_DATE := price_attr_rec.LAST_UPDATE_DATE;

Line: 2552


	   lx_price_attr_tbl(l_price_attr_count).LAST_UPDATED_BY := price_attr_rec.LAST_UPDATED_BY;

Line: 2553


	   lx_price_attr_tbl(l_price_attr_count).LAST_UPDATE_LOGIN := price_attr_rec.LAST_UPDATE_LOGIN;

Line: 2557


	   lx_price_attr_tbl(l_price_attr_count).PROGRAM_UPDATE_DATE := price_attr_rec.PROGRAM_UPDATE_DATE;

Line: 2695


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


lx_price_adj_rltd_tbl(l_price_adj_rltd_count).LAST_UPDATE_DATE := C_Price_Adj_Rltd_Rec.LAST_UPDATE_DATE;

Line: 2729


lx_price_adj_rltd_tbl(l_price_adj_rltd_count).LAST_UPDATED_BY := C_Price_Adj_Rltd_Rec.LAST_UPDATED_BY;

Line: 2730


lx_price_adj_rltd_tbl(l_price_adj_rltd_count).LAST_UPDATE_LOGIN := C_Price_Adj_Rltd_Rec.LAST_UPDATE_LOGIN;

Line: 2733


lx_price_adj_rltd_tbl(l_price_adj_rltd_count).PROGRAM_UPDATE_DATE := C_Price_Adj_Rltd_Rec.PROGRAM_UPDATE_DATE;

Line: 2762


   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,
	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
    FROM ASO_PRICE_ADJUSTMENTS
    WHERE quote_header_id = p_qte_header_id AND
	   quote_line_id is null AND
	   (applied_flag IS NOT NULL AND applied_flag = 'Y')
    UNION ALL
    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,
     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
    FROM ASO_PRICE_ADJUSTMENTS c
    WHERE quote_header_id = p_qte_header_id AND
          quote_line_id IS NULL AND
		 EXISTS
		   (select NULL
		    from aso_price_adjustments a, aso_price_adj_relationships b
			where a.price_adjustment_id = b.price_adjustment_id
			and c.price_adjustment_id = b.rltd_price_adj_id
                        and a.quote_header_id = p_qte_header_id
                        and a.quote_line_id IS NULL
			and a.modifier_line_type_code = 'PBH'
			and (a.applied_flag IS NOT NULL AND a.applied_flag = 'Y'));

Line: 2953


    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,
	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
    FROM ASO_PRICE_ADJUSTMENTS
    WHERE quote_header_id = p_qte_header_id AND
          quote_line_id = p_qte_line_rec.quote_line_id AND
          (applied_flag IS NOT NULL AND applied_flag = 'Y')
    UNION ALL
    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,
     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
    FROM ASO_PRICE_ADJUSTMENTS c
    WHERE quote_header_id = p_qte_header_id AND
          quote_line_id = p_qte_line_rec.quote_line_id AND
		 EXISTS
		   (select NULL
		    from aso_price_adjustments a, aso_price_adj_relationships b
			where a.price_adjustment_id = b.price_adjustment_id
			and c.price_adjustment_id = b.rltd_price_adj_id
                        and a.quote_header_id = p_qte_header_id
                        and a.quote_line_id = p_qte_line_rec.quote_line_id
			and a.modifier_line_type_code = 'PBH'
			and (a.applied_flag IS NOT NULL AND a.applied_flag = 'Y'));

Line: 3160


	  lx_price_adj_tbl(l_price_adj_count).LAST_UPDATE_DATE := price_adj_rec.LAST_UPDATE_DATE;

Line: 3161


	  lx_price_adj_tbl(l_price_adj_count).LAST_UPDATED_BY := price_adj_rec.LAST_UPDATED_BY;

Line: 3162


	  lx_price_adj_tbl(l_price_adj_count).LAST_UPDATE_LOGIN := price_adj_rec.LAST_UPDATE_LOGIN;

Line: 3166


	  lx_price_adj_tbl(l_price_adj_count).PROGRAM_UPDATE_DATE := price_adj_rec.PROGRAM_UPDATE_DATE;

Line: 3179


	  lx_price_adj_tbl(l_price_adj_count).UPDATE_ALLOWABLE_FLAG := price_adj_rec.UPDATE_ALLOWABLE_FLAG;

Line: 3180


	  lx_price_adj_tbl(l_price_adj_count).UPDATED_FLAG := price_adj_rec.UPDATED_FLAG;

Line: 3239


	lx_price_adj_tbl(l_price_adj_count).UPDATE_ALLOWED := price_adj_rec.UPDATE_ALLOWED;

Line: 3267


	  lx_price_adj_tbl(l_price_adj_count).LAST_UPDATE_DATE := price_adj_rec.LAST_UPDATE_DATE;

Line: 3268


	  lx_price_adj_tbl(l_price_adj_count).LAST_UPDATED_BY := price_adj_rec.LAST_UPDATED_BY;

Line: 3269


	  lx_price_adj_tbl(l_price_adj_count).LAST_UPDATE_LOGIN := price_adj_rec.LAST_UPDATE_LOGIN;

Line: 3273


	  lx_price_adj_tbl(l_price_adj_count).PROGRAM_UPDATE_DATE := price_adj_rec.PROGRAM_UPDATE_DATE;

Line: 3286


	  lx_price_adj_tbl(l_price_adj_count).UPDATE_ALLOWABLE_FLAG := price_adj_rec.UPDATE_ALLOWABLE_FLAG;

Line: 3287


	  lx_price_adj_tbl(l_price_adj_count).UPDATED_FLAG := price_adj_rec.UPDATED_FLAG;

Line: 3346


	lx_price_adj_tbl(l_price_adj_count).UPDATE_ALLOWED := price_adj_rec.UPDATE_ALLOWED;

Line: 3379


    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,
	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
    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
          (applied_flag IS NOT NULL AND applied_flag = 'Y');

Line: 3477


	   l_price_adj_rec.LAST_UPDATE_DATE := price_adj_rec.LAST_UPDATE_DATE;

Line: 3478


	   l_price_adj_rec.LAST_UPDATED_BY := price_adj_rec.LAST_UPDATED_BY;

Line: 3479


	   l_price_adj_rec.LAST_UPDATE_LOGIN := price_adj_rec.LAST_UPDATE_LOGIN;

Line: 3483


	   l_price_adj_rec.PROGRAM_UPDATE_DATE := price_adj_rec.PROGRAM_UPDATE_DATE;

Line: 3496


	  l_price_adj_rec.UPDATE_ALLOWABLE_FLAG := price_adj_rec.UPDATE_ALLOWABLE_FLAG;

Line: 3497


	  l_price_adj_rec.UPDATED_FLAG := price_adj_rec.UPDATED_FLAG;

Line: 3556


	l_price_adj_rec.UPDATE_ALLOWED := price_adj_rec.UPDATE_ALLOWED;