APPS.FTE_FPA_UTIL SQL Statements

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

Line: 19

	SELECT PV.PARTY_ID,PVS.PARTY_SITE_ID,
	       FH.SUPPLIER_SITE_ID,FH.ORG_ID,
	       NULL PAYMENT_METHOD_LOOKUP_CODE
	FROM   FTE_INVOICE_HEADERS FH,
	       PO_VENDORS PV,
	       PO_VENDOR_SITES_ALL PVS
	WHERE
	    FH.SUPPLIER_ID       = PV.VENDOR_ID
	AND PV.VENDOR_ID         = PVS.VENDOR_ID
	AND FH.SUPPLIER_SITE_ID  = PVS.VENDOR_SITE_ID
	AND FH.INVOICE_HEADER_ID = p_inv_head_id;

Line: 221

        SELECT nvl(APPROVED_AMOUNT,0),
	       CURRENCY_CODE
	FROM   FTE_INVOICE_HEADERS
	WHERE  BOL = p_bol_no;

Line: 230

        SELECT
	       nvl(WFC.TOTAL_AMOUNT,0),
	       WFC.CURRENCY_CODE
	FROM   WSH_FREIGHT_COSTS WFC,
	       WSH_FREIGHT_COST_TYPES CT
	WHERE
	        WFC.FREIGHT_COST_TYPE_ID = CT.FREIGHT_COST_TYPE_ID
	   AND  WFC.LINE_TYPE_CODE =  'SUMMARY'
	   AND  CT.NAME =  'SUMMARY'
	   AND  WFC.TRIP_ID = p_trip;

Line: 245

	SELECT   nvl(WFC.TOTAL_AMOUNT,0),
		 WFC.CURRENCY_CODE
	FROM
		WSH_DELIVERY_LEGS WDL ,
		WSH_TRIP_STOPS WT,
		WSH_FREIGHT_COSTS  WFC
	WHERE
		   WT.STOP_ID = WDL.PICK_UP_STOP_ID
	       AND WFC.DELIVERY_LEG_ID =  WDL.DELIVERY_LEG_ID
	       AND WT.TRIP_ID = p_trip
	       AND WFC.DELIVERY_DETAIL_ID IS NULL
	       AND WFC.LINE_TYPE_CODE = 'SUMMARY'
	       AND WFC.DELIVERY_LEG_ID = p_dleg_id;

Line: 263

	SELECT nvl(SUM(WSH_WV_UTILS.CONVERT_UOM(
			WEIGHT_UOM_CODE,
             		g_wt_uom,
			WDD.GROSS_WEIGHT,
       			WDD.INVENTORY_ITEM_ID)),0)
        FROM  WSH_DELIVERY_DETAILS WDD
	WHERE WDD.DELIVERY_DETAIL_ID
	   IN (
	        SELECT DELIVERY_DETAIL_ID
		FROM WSH_DELIVERY_ASSIGNMENTS
       	        START WITH DELIVERY_DETAIL_ID = p_detail_id
 	        CONNECT BY PRIOR PARENT_DELIVERY_DETAIL_ID= DELIVERY_DETAIL_ID
	       );

Line: 282

	SELECT DELIVERY_DETAIL_ID
	FROM
	    (SELECT
	          DELIVERY_DETAIL_ID,
		  LEVEL
		  FROM WSH_DELIVERY_ASSIGNMENTS
		  START WITH DELIVERY_DETAIL_ID = p_detail_id
                  CONNECT BY PRIOR PARENT_DELIVERY_DETAIL_ID = DELIVERY_DETAIL_ID ORDER BY LEVEL DESC
	     ) A
        WHERE ROWNUM = 1;

Line: 297

	SELECT
	      nvl(WFC.TOTAL_AMOUNT,0) ,
	      WFC.CURRENCY_CODE
	FROM
	      WSH_FREIGHT_COSTS  WFC
	WHERE
	      WFC.DELIVERY_LEG_ID = p_dleg_id
	  AND WFC.DELIVERY_DETAIL_ID = DECODE (p_cont_flag,'Y',p_container_detail_id,'N',p_detail_id)
	  AND WFC.LINE_TYPE_CODE = 'SUMMARY';

Line: 549

     SELECT
	  nvl( SUM(TOTAL_AMOUNT),0),
	  MAX(CURRENCY_CODE)
     FROM WSH_FREIGHT_COSTS
     WHERE
	     DELIVERY_LEG_ID = p_delivery_leg_id
	AND  LINE_TYPE_CODE = 'SUMMARY'
	AND  CHARGE_SOURCE_CODE= 'PRICING_ENGINE';

Line: 561

     SELECT
	  nvl( SUM(TOTAL_AMOUNT),0),
	  MAX(CURRENCY_CODE)
     FROM WSH_FREIGHT_COSTS
     WHERE
	     DELIVERY_LEG_ID = p_delivery_leg_id
	AND  LINE_TYPE_CODE = 'DISCOUNT'
	AND  CHARGE_SOURCE_CODE= 'PRICING_ENGINE';

Line: 573

     SELECT
	  nvl( SUM(TOTAL_AMOUNT),0),
	  MAX(CURRENCY_CODE)
     FROM WSH_FREIGHT_COSTS
     WHERE
	     DELIVERY_LEG_ID = p_delivery_leg_id
	AND  LINE_TYPE_CODE = 'CHARGE'
	AND  CHARGE_SOURCE_CODE= 'PRICING_ENGINE';

Line: 584

     SELECT
	  nvl( SUM(TOTAL_AMOUNT),0),
	  MAX(CURRENCY_CODE)
     FROM WSH_FREIGHT_COSTS
     WHERE
	     DELIVERY_LEG_ID = p_delivery_leg_id
	AND  LINE_TYPE_CODE = 'PRICE'
	AND  CHARGE_SOURCE_CODE= 'PRICING_ENGINE'
	AND  COMMODITY_CATEGORY_ID = p_commodity_category_id;

Line: 598

     SELECT
	    NVL( SUM(FL.APPROVED_AMOUNT),0 ),
            MAX(FH.CURRENCY_CODE)
     FROM   FTE_INVOICE_HEADERS FH,
            FTE_INVOICE_LINES FL,
	    MTL_CATEGORIES_KFV C,
	    MTL_CATEGORY_SETS S
     WHERE  FH.INVOICE_HEADER_ID  = FL.INVOICE_HEADER_ID
         AND  FH.BOL              = p_bol
	 AND  FL.FREIGHT_CLASS    = C.CONCATENATED_SEGMENTS
	 AND  FH.BILL_STATUS      <> 'OBSOLETE'
	 AND  S.STRUCTURE_ID      = C.STRUCTURE_ID
	 AND  S.CATEGORY_SET_NAME = 'WSH_COMMODITY_CODE'
	 AND  C.ENABLED_FLAG      = 'Y'
	 AND  C.CATEGORY_ID       = p_commodity_category_id
	 AND FL.INVOICE_LINE_TYPE = 'LINE';

Line: 618

     SELECT
	    NVL( SUM(FL.APPROVED_AMOUNT),0 ),
            MAX(FH.CURRENCY_CODE)
     FROM   FTE_INVOICE_HEADERS FH,
            FTE_INVOICE_LINES FL
     WHERE  FH.INVOICE_HEADER_ID  = FL.INVOICE_HEADER_ID
         AND  FH.BOL              = p_bol
	 AND  FH.BILL_STATUS      <> 'OBSOLETE'
	 AND FL.INVOICE_LINE_TYPE = 'DISCOUNT';

Line: 631

     SELECT
	    NVL( SUM(FL.APPROVED_AMOUNT),0 ),
            MAX(FH.CURRENCY_CODE)
     FROM   FTE_INVOICE_HEADERS FH,
            FTE_INVOICE_LINES FL
     WHERE  FH.INVOICE_HEADER_ID  = FL.INVOICE_HEADER_ID
         AND  FH.BOL              = p_bol
	 AND  FH.BILL_STATUS      <> 'OBSOLETE'
	 AND FL.INVOICE_LINE_TYPE = 'SURCHARGE';

Line: 644

     SELECT
     (SELECT SUM(TOTAL_AMOUNT) FROM WSH_FREIGHT_COSTS
      WHERE  DELIVERY_LEG_ID = p_dleg_id
        AND  LINE_TYPE_CODE = 'DISCOUNT'
        AND  CHARGE_SOURCE_CODE= 'PRICING_ENGINE'
	AND  COMMODITY_CATEGORY_ID = p_commodity_id
      )	/
      (SELECT SUM(TOTAL_AMOUNT)   FROM WSH_FREIGHT_COSTS
       WHERE DELIVERY_LEG_ID = p_dleg_id
	AND  LINE_TYPE_CODE = 'DISCOUNT'
	AND  CHARGE_SOURCE_CODE= 'PRICING_ENGINE'
      ) * FL.APPROVED_AMOUNT FROM FTE_INVOICE_LINES FL ,FTE_INVOICE_HEADERS FH
      WHERE     FL.INVOICE_LINE_TYPE  ='DISCOUNT'
            AND FH.INVOICE_HEADER_ID = FL.INVOICE_HEADER_ID
	    AND FH.BOL = p_bol_no;

Line: 663

     SELECT
     (SELECT SUM(TOTAL_AMOUNT) FROM WSH_FREIGHT_COSTS
      WHERE  DELIVERY_LEG_ID = p_dleg_id
        AND  LINE_TYPE_CODE = 'CHARGE'
        AND  CHARGE_SOURCE_CODE= 'PRICING_ENGINE'
	AND  COMMODITY_CATEGORY_ID = p_commodity_id
      )	/
      (SELECT SUM(TOTAL_AMOUNT)   FROM WSH_FREIGHT_COSTS
       WHERE DELIVERY_LEG_ID = p_dleg_id
	AND  LINE_TYPE_CODE = 'CHARGE'
	AND  CHARGE_SOURCE_CODE= 'PRICING_ENGINE'
      ) * FL.APPROVED_AMOUNT FROM FTE_INVOICE_LINES FL ,FTE_INVOICE_HEADERS FH
      WHERE     FL.INVOICE_LINE_TYPE  ='SURCHARGE'
            AND FH.INVOICE_HEADER_ID = FL.INVOICE_HEADER_ID
	    AND FH.BOL = p_bol_no;

Line: 684

	SELECT  nvl(total_amount,0),
	        currency_code
        FROM    wsh_freight_costs
        WHERE   DELIVERY_LEG_ID      = p_delivery_leg_id
           AND DELIVERY_DETAIL_ID    = p_delivery_detail_id
           AND LINE_TYPE_CODE        = 'PRICE'
	   AND CHARGE_SOURCE_CODE    = 'PRICING_ENGINE'
	   AND COMMODITY_CATEGORY_ID = p_commodity_category_id;

Line: 697

	SELECT  nvl(total_amount,0),
	        currency_code
        FROM    wsh_freight_costs
        WHERE   DELIVERY_LEG_ID      = p_delivery_leg_id
           AND DELIVERY_DETAIL_ID    = p_delivery_detail_id
           AND LINE_TYPE_CODE        = 'DISCOUNT'
	   AND CHARGE_SOURCE_CODE    = 'PRICING_ENGINE'
	   AND COMMODITY_CATEGORY_ID = p_commodity_category_id;

Line: 709

	SELECT  nvl(total_amount,0),
	        currency_code
        FROM    wsh_freight_costs
        WHERE   DELIVERY_LEG_ID      = p_delivery_leg_id
           AND DELIVERY_DETAIL_ID    = p_delivery_detail_id
           AND LINE_TYPE_CODE        = 'CHARGE'
	   AND CHARGE_SOURCE_CODE    = 'PRICING_ENGINE'
	   AND COMMODITY_CATEGORY_ID = p_commodity_category_id;

Line: 723

	SELECT nvl(freight_audit_line_level,'N'),FTE_INVOICE_HEADERS.APPROVED_AMOUNT
	FROM WSH_CARRIERS, FTE_INVOICE_HEADERS
	WHERE WSH_CARRIERS.CARRIER_ID =  FTE_INVOICE_HEADERS.CARRIER_ID
	AND FTE_INVOICE_HEADERS.INVOICE_HEADER_ID = p_invoice_header_id;

Line: 1195

  SELECT DISTINCT WDD.SOURCE_LINE_ID,
  		  WDD.CURRENCY_CODE,
		  WDD.WEIGHT_UOM_CODE,
		  WDD.RCV_SHIPMENT_LINE_ID
  FROM
	WSH_DELIVERY_DETAILS WDD,
	WSH_DELIVERY_ASSIGNMENTS WDA,
	WSH_DELIVERY_LEGS WDL,
	WSH_DOCUMENT_INSTANCES WDI
  WHERE
	    WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
	AND (WDA.DELIVERY_ID        = WDL.DELIVERY_ID OR WDA.PARENT_DELIVERY_ID = WDL.DELIVERY_ID)
	AND WDD.LINE_DIRECTION     = 'I'
	AND WDI.ENTITY_ID         =  WDL.DELIVERY_LEG_ID
	AND WDI.ENTITY_NAME        = 'WSH_DELIVERY_LEGS'
	AND WDI.DOCUMENT_TYPE      = 'BOL'
	AND WDI.SEQUENCE_NUMBER    = p_bol_no;

Line: 1215

      SELECT SUM(A.bol_flag) FROM (
	    SELECT distinct wdl.delivery_leg_id,
	       decode( (select distinct WDI.sequence_number from wsh_document_instances WDI,FTE_INVOICE_HEADERS FH
			where
				 WDI.ENTITY_ID    = DECODE(WT.MODE_OF_TRANSPORT,'LTL',WDL.DELIVERY_LEG_ID,'TRUCK',WT.TRIP_ID)
			     AND WDI.ENTITY_NAME  = DECODE(WT.MODE_OF_TRANSPORT,'LTL','WSH_DELIVERY_LEGS','TRUCK','WSH_TRIPS')
			     AND WDI.SEQUENCE_NUMBER = FH.BOL
			     AND FH.BILL_STATUS <> 'OBSOLETE'
			     AND FH.BILL_STATUS = decode(FH.BOL,p_bol,FH.BILL_STATUS,'APPROVED')
			),NULL,1,0)   bol_flag
	   FROM
		 WSH_DELIVERY_DETAILS WDD,
		  WSH_DELIVERY_ASSIGNMENTS WDA,
		  WSH_DELIVERY_LEGS WDL,
		  WSH_TRIP_STOPS WTS,
		  WSH_TRIPS WT
	  WHERE
	      WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
	  AND (WDA.DELIVERY_ID       = WDL.DELIVERY_ID  OR WDA.PARENT_DELIVERY_ID = WDL.DELIVERY_ID)
	  AND WDL.PARENT_DELIVERY_LEG_ID IS NULL
	  AND WDL.PICK_UP_STOP_ID    = WTS.STOP_ID
	  AND WT.TRIP_ID             = WTS.TRIP_ID
	  AND WDD.LINE_DIRECTION     = 'I'
	  AND WDD.SOURCE_LINE_ID     =  p_source_line_id
	 ) A;

Line: 1245

        SELECT
           DISTINCT WDL.DELIVERY_LEG_ID,
	           WDD.DELIVERY_DETAIL_ID,
		   WDD.INVENTORY_ITEM_ID,
                   WT.MODE_OF_TRANSPORT,
		   WT.TRIP_ID,
		   MIC.CATEGORY_ID AS COMMODITY_CATEGORY_ID,
		   DECODE(WDA.PARENT_DELIVERY_DETAIL_ID,NULL,'Y','N') AS CONTAINER_FLAG,
                   WDD.GROSS_WEIGHT,
		   WDD.WEIGHT_UOM_CODE,
		   WDD.CURRENCY_CODE,
		   (SELECT WDI.SEQUENCE_NUMBER FROM WSH_DOCUMENT_INSTANCES WDI
	  	    WHERE WDI.ENTITY_ID    = DECODE(WT.MODE_OF_TRANSPORT,'LTL',NVL(WDL.PARENT_DELIVERY_LEG_ID,WDL.DELIVERY_LEG_ID),'TRUCK',WT.TRIP_ID)
	              AND WDI.ENTITY_NAME  = DECODE(WT.MODE_OF_TRANSPORT,'LTL','WSH_DELIVERY_LEGS','TRUCK','WSH_TRIPS')
		   ) SEQUENCE_NUMBER
       FROM
	 WSH_DELIVERY_DETAILS WDD,
	 WSH_DELIVERY_ASSIGNMENTS WDA,
	 WSH_DELIVERY_LEGS WDL,
	 WSH_TRIP_STOPS WTS,
	 WSH_TRIPS WT,
	 MTL_ITEM_CATEGORIES MIC,
	 MTL_CATEGORIES_KFV C,
	 MTL_CATEGORY_SETS S
        WHERE
	       S.STRUCTURE_ID = C.STRUCTURE_ID
	  AND  S.CATEGORY_SET_NAME ='WSH_COMMODITY_CODE'
	  AND  C.ENABLED_FLAG ='Y'
	  AND  C.CATEGORY_ID        = MIC.CATEGORY_ID
          AND  MIC.INVENTORY_ITEM_ID = WDD.INVENTORY_ITEM_ID
          AND  MIC.ORGANIZATION_ID   = WDD.ORG_ID
          AND  WDD.DELIVERY_DETAIL_ID  = WDA.DELIVERY_DETAIL_ID
	  AND WDA.DELIVERY_ID        = WDL.DELIVERY_ID
	  AND WDA.DELIVERY_ID        = WDL.DELIVERY_ID
	  AND WDL.PICK_UP_STOP_ID     = WTS.STOP_ID
	  AND WT.TRIP_ID              = WTS.TRIP_ID
	  AND WDD.LINE_DIRECTION      = 'I'
	  AND WDD.SOURCE_LINE_ID      = p_source_line_id;

Line: 1285

	SELECT VENDOR_ID,SHIP_FROM_SITE_ID
	FROM WSH_DELIVERY_DETAILS
	WHERE SOURCE_LINE_ID = p_source_line_id
	AND ROWNUM <= 1;

Line: 1345

	SELECT BILL_STATUS INTO l_bill_status
	FROM FTE_INVOICE_HEADERS
	WHERE invoice_header_id = p_invoice_header_id;

Line: 1406

			SELECT BILL_TYPE, BOL INTO l_bill_type, l_inc_parent_bol
			FROM FTE_INVOICE_HEADERS
			WHERE INVOICE_HEADER_ID = p_invoice_header_id;

Line: 1554

	SELECT DISTINCT   WDD.SOURCE_LINE_ID,
			  WDD.CURRENCY_CODE,
			  WDD.WEIGHT_UOM_CODE
	FROM
		WSH_DELIVERY_DETAILS WDD,
		WSH_DELIVERY_ASSIGNMENTS WDA,
		WSH_DELIVERY_LEGS WDL,
		WSH_TRIP_STOPS WTS,
		WSH_TRIPS WT,
		WSH_DOCUMENT_INSTANCES WDI
	WHERE
		    WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
		AND WDD.LINE_DIRECTION     = 'I'
		AND WDA.DELIVERY_ID        = WDL.DELIVERY_ID
		AND WTS.STOP_ID            = WDL.PICK_UP_STOP_ID
		AND WT.TRIP_ID             = WTS.TRIP_ID
		AND WDI.ENTITY_ID          = WT.TRIP_ID
		AND WDI.ENTITY_NAME        = 'WSH_TRIPS'
		AND WDI.DOCUMENT_TYPE      = 'MBOL'
		AND WDI.SEQUENCE_NUMBER    = p_bol_no;

Line: 1578

	    SELECT SUM(A.bol_flag) FROM (
	    SELECT distinct wdl.delivery_leg_id,
               decode( (select WDI.sequence_number from wsh_document_instances WDI,FTE_INVOICE_HEADERS FH
			where
				 WDI.ENTITY_ID    = DECODE(WT.MODE_OF_TRANSPORT,'LTL',WDL.DELIVERY_LEG_ID,'TRUCK',WT.TRIP_ID)
	                     AND WDI.ENTITY_NAME  = DECODE(WT.MODE_OF_TRANSPORT,'LTL','WSH_DELIVERY_LEGS','TRUCK','WSH_TRIPS')
			     AND WDI.SEQUENCE_NUMBER = FH.BOL
			     AND FH.BILL_STATUS = decode(FH.BOL,p_bol,FH.BILL_STATUS,'APPROVED')
			),NULL,1,0)   bol_flag
	   FROM
		 WSH_DELIVERY_DETAILS WDD,
		  WSH_DELIVERY_ASSIGNMENTS WDA,
		  WSH_DELIVERY_LEGS WDL,
		  WSH_TRIP_STOPS WTS,
		  WSH_TRIPS WT
	  WHERE
              WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
	  AND (WDA.DELIVERY_ID       = WDL.DELIVERY_ID  OR WDA.PARENT_DELIVERY_ID = WDL.DELIVERY_ID)
	  AND WDL.PARENT_DELIVERY_LEG_ID IS NULL
	  AND WDL.PICK_UP_STOP_ID    = WTS.STOP_ID
	  AND WT.TRIP_ID             = WTS.TRIP_ID
	  AND WDD.LINE_DIRECTION     = 'I'
	  AND WDD.SOURCE_LINE_ID     =  p_source_line_id
         ) A;

Line: 1607

        SELECT
           DISTINCT WDL.DELIVERY_LEG_ID,
	           WDD.DELIVERY_DETAIL_ID,
		   WDD.INVENTORY_ITEM_ID,
                   WT.MODE_OF_TRANSPORT,
		   WT.TRIP_ID,
		   MIC.CATEGORY_ID AS COMMODITY_CATEGORY_ID,
		   DECODE(WDA.PARENT_DELIVERY_DETAIL_ID,NULL,'Y','N') AS CONTAINER_FLAG,
                   WDD.GROSS_WEIGHT,
		   WDD.WEIGHT_UOM_CODE,
		   WDD.CURRENCY_CODE,
		   (SELECT WDI.SEQUENCE_NUMBER FROM WSH_DOCUMENT_INSTANCES WDI
	  	    WHERE WDI.ENTITY_ID    = DECODE(WT.MODE_OF_TRANSPORT,'LTL',NVL(WDL.PARENT_DELIVERY_LEG_ID,WDL.DELIVERY_LEG_ID),'TRUCK',WT.TRIP_ID)
	              AND WDI.ENTITY_NAME  = DECODE(WT.MODE_OF_TRANSPORT,'LTL','WSH_DELIVERY_LEGS','TRUCK','WSH_TRIPS')
		   ) SEQUENCE_NUMBER
       FROM
	 WSH_DELIVERY_DETAILS WDD,
	 WSH_DELIVERY_ASSIGNMENTS WDA,
	 WSH_DELIVERY_LEGS WDL,
	 WSH_TRIP_STOPS WTS,
	 WSH_TRIPS WT,
	 MTL_ITEM_CATEGORIES MIC,
	 MTL_CATEGORIES_KFV C,
	 MTL_CATEGORY_SETS S
        WHERE
	       S.STRUCTURE_ID = C.STRUCTURE_ID
	  AND  S.CATEGORY_SET_NAME ='WSH_COMMODITY_CODE'
	  AND  C.ENABLED_FLAG ='Y'
	  AND  C.CATEGORY_ID        = MIC.CATEGORY_ID
          AND  MIC.INVENTORY_ITEM_ID = WDD.INVENTORY_ITEM_ID
          AND  MIC.ORGANIZATION_ID   = WDD.ORG_ID
          AND  WDD.DELIVERY_DETAIL_ID  = WDA.DELIVERY_DETAIL_ID
	  AND WDA.DELIVERY_ID        = WDL.DELIVERY_ID
	  AND WDA.DELIVERY_ID        = WDL.DELIVERY_ID
	  AND WDL.PICK_UP_STOP_ID     = WTS.STOP_ID
	  AND WT.TRIP_ID              = WTS.TRIP_ID
	  AND WDD.LINE_DIRECTION      = 'I'
	  AND WDD.SOURCE_LINE_ID      = p_source_line_id;

Line: 1648

	SELECT VENDOR_ID,SHIP_FROM_SITE_ID
	FROM WSH_DELIVERY_DETAILS
	WHERE SOURCE_LINE_ID = p_source_line_id
	AND ROWNUM <= 1;

Line: 1752

			SELECT BILL_TYPE, BOL INTO l_bill_type, l_inc_parent_bol
			FROM FTE_INVOICE_HEADERS
			WHERE INVOICE_HEADER_ID = p_invoice_header_id;

Line: 1947

     ISC_DBI_CHANGE_LOG_PKG.UPDATE_FTE_INVOICE_LOG(v_tab, p_dml_type, p_return_status);

Line: 2110

 PROCEDURE Update_Status(itemtype  IN         VARCHAR2,
                         itemkey   IN         VARCHAR2,
                         actid     IN         NUMBER,
                         funcmode  IN         VARCHAR2,
                         resultout OUT NOCOPY VARCHAR2) IS


	CURSOR C_INVOICE(p_check_id NUMBER)  IS
	SELECT
	INV.INVOICE_NUM,
	INV.PAYMENT_STATUS_FLAG
	FROM
	AP_INVOICES_ALL INV,
	AP_INVOICE_PAYMENTS_ALL PAY,
	AP_CHECKS_ALL CHK
	WHERE
	PAY.INVOICE_ID = INV.INVOICE_ID
	AND CHK.CHECK_ID = PAY.CHECK_ID
	AND PAY.CHECK_ID = p_check_id;

Line: 2138

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

Line: 2192

				SELECT invoice_header_id into l_invoice_id
				FROM fte_invoice_headers
				WHERE bill_number = l_invoice_number;

Line: 2197

					UPDATE FTE_INVOICE_HEADERS
					SET BILL_STATUS  = 'PAID'
					WHERE BILL_NUMBER = l_invoice_number;

Line: 2200

					callDBI(l_invoice_id, 'UPDATE', returnStatus);

Line: 2202

					UPDATE FTE_INVOICE_HEADERS
					SET BILL_STATUS  = 'PARTIAL_PAID'
					WHERE BILL_NUMBER = l_invoice_number;

Line: 2206

					callDBI(l_invoice_id, 'UPDATE', returnStatus);

Line: 2228

		   select invoice_header_id into l_invoice_id
		   from fte_invoice_headers
		   where bill_number = l_invoice_number;

Line: 2233

				UPDATE FTE_INVOICE_HEADERS
				SET BILL_STATUS  = 'PAID'
	     			WHERE BILL_NUMBER = l_invoice_number;

Line: 2237

				callDBI(l_invoice_id, 'UPDATE', returnStatus);

Line: 2240

		        	UPDATE FTE_INVOICE_HEADERS
				SET BILL_STATUS  = 'PARTIALLY PAID'
				WHERE BILL_NUMBER = l_invoice_number;

Line: 2244

		                callDBI(l_invoice_id, 'UPDATE', returnStatus);

Line: 2262

	                           'Update_Status',
	                           itemtype,
	                           itemkey,
	                           actid,
	                           funcmode);

Line: 2269

 END Update_Status;

Line: 2356

        SELECT GSOB.CHART_OF_ACCOUNTS_ID
        INTO    l_chart_of_accounts_id
        FROM
        HR_ORGANIZATION_INFORMATION HOI2,
        GL_SETS_OF_BOOKS GSOB
        WHERE HOI2.ORG_INFORMATION1 = TO_CHAR(GSOB.SET_OF_BOOKS_ID)
        AND   (HOI2.ORG_INFORMATION_CONTEXT || '') ='Accounting Information'
        AND   HOI2.ORGANIZATION_ID = p_ship_from_org_id;

Line: 2440

                    insert_if_new   => FALSE,
                    ccid            => lx_return_ccid,
                    concat_segs     => lx_concat_segs,
                    concat_ids      => lx_concat_ids,
                    concat_descrs   => lx_concat_descrs,
                    error_message   => l_errmsg,
                    new_combination => l_new_combination
                    );

Line: 2576

	SELECT FPA_DEFAULT_FREIGHT_ACCOUNT
	INTO l_ccid
	FROM wsh_shipping_parameters
	WHERE organization_id  = l_organization_id;

Line: 2655

	INSERT INTO FTE_FAILURE_REASONS
	 (INVOICE_REJECT_ID,
	  PARENT_NAME,
	  PARENT_ID,
	  BOL,
	  FAILURE_TYPE,
	  FAILURE_REASON,
	  CREATED_BY,
	  CREATION_DATE,
          LAST_UPDATED_BY,
	  LAST_UPDATE_DATE,
	  LAST_UPDATE_LOGIN)
	VALUES
	(FTE_FAILURE_REASONS_S.nextval,
	 p_parent_name,
	 p_parent_id,
	 NULL,
	 p_failure_type,
	 p_failure_reason,
	 FND_GLOBAL.USER_ID,
	 SYSDATE,
	 FND_GLOBAL.USER_ID,
	 SYSDATE,
	 FND_GLOBAL.USER_ID);