APPS.OKC_XPRT_CUSTOM_PACKAGE SQL Statements

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

Line: 59

	   -- If you are reading data from multiple tables with multiple SELECT statements,
	   -- define all cursors here with appropriate names.
	   --
	   -- The following cursor is defined to retrieve values for the user defined variables
	   -- for a sales order (DOCUMENT_TYPE = 'O')
	   --
        Cursor l_oe_header_csr Is
	    SELECT BLANKET_NUMBER,
                   USER_STATUS_CODE,
                   CONTEXT
	    FROM OE_ORDER_HEADERS_ALL
	    WHERE HEADER_ID = p_doc_id;

Line: 186

    PROCEDURE GET_PRICE_UPDATE_TOLERANCE (
        P_DOC_TYPE		     IN VARCHAR2,
        P_DOC_ID		     IN NUMBER,
	    P_VARIABLE_CODE			IN VARCHAR2,
    	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
        X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
        X_MSG_COUNT		     OUT NOCOPY NUMBER,
        X_MSG_DATA		     OUT NOCOPY VARCHAR2
	)
    IS

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

Line: 199

	   l_price_update_tolerance	PO_HEADERS_ALL.PRICE_UPDATE_TOLERANCE%TYPE;

Line: 202

        Cursor l_price_update_csr Is
	   		select PRICE_UPDATE_TOLERANCE from PO_HEADERS_ALL
                                WHERE po_header_id = P_DOC_ID ;

Line: 218

	OPEN l_price_update_csr;

Line: 219

	      FETCH l_price_update_csr INTO l_price_update_tolerance;

Line: 220

	      dbms_output.put_line('l_price_update_tolerance IS '||l_price_update_tolerance);

Line: 221

	      l_price_update_tolerance := l_price_update_tolerance+10;

Line: 222

	CLOSE l_price_update_csr;

Line: 225

				  X_VARIABLE_VALUE_ID := l_price_update_tolerance;

Line: 250

            IF l_price_update_csr%ISOPEN THEN
                CLOSE l_price_update_csr;

Line: 266

            IF l_price_update_csr%ISOPEN THEN
                CLOSE l_price_update_csr;

Line: 279

            IF l_price_update_csr%ISOPEN THEN
                CLOSE l_price_update_csr;

Line: 286

    END GET_PRICE_UPDATE_TOLERANCE;

Line: 308

        SELECT TEMPLATE_INSTANCE_ID FROM ASO_SUP_tmpl_INSTANCE  where owner_table_id = P_DOC_ID;

Line: 312

        SELECT value FROM ASO_SUP_INSTANCE_VALUE
        WHERE template_instance_id = p_tmp_instace_id
        AND value is not null;

Line: 323

	        SELECT flex_value_id
	          FROM fnd_flex_values_vl
	         WHERE flex_value_set_id = (SELECT flex_value_set_id
	                                      FROM fnd_flex_value_sets
        			             -- Added the Flex vbalue set where condition again on 04162007
	                                     WHERE flex_value_set_name	= 'Industry Type') --1022577 -- Need to be known from setup for 'Industry Type'
	           AND flex_value =  (SELECT response_name
	                                FROM ASO_SUP_response_tl
	                               WHERE response_id IN (SELECT response_id
	                                                       FROM ASO_SUP_INSTANCE_VALUE
	                                                      WHERE template_instance_id = p_tmp_instace_id)
                                         AND language = USERENV('LANG'));

Line: 450

		SELECT SHIP_FROM_ORG_ID
                FROM OE_BLANKET_HEADERS_ALL
                WHERE HEADER_ID = P_DOC_ID;

Line: 549

            SELECT UOM
            FROM PON_BID_ITEM_PRICES
            WHERE BID_NUMBER = P_DOC_ID;

Line: 554

            SELECT UOM_CODE
            FROM PON_AUCTION_ITEM_PRICES_ALL
            WHERE BEST_BID_NUMBER = P_DOC_ID;

Line: 675

        SELECT UOM_CODE
	  FROM MTL_UNITS_OF_MEASURE
         WHERE UNIT_OF_MEASURE = (SELECT UNIT_MEAS_LOOKUP_CODE
                                    FROM PO_LINES_ALL
                                   WHERE PO_HEADER_ID = P_DOC_ID);

Line: 780

        SELECT NVL(MIN_RELEASE_AMOUNT,0)/NVL(AMOUNT_LIMIT, 1)
        FROM PO_HEADERS_ALL
        WHERE PO_HEADER_ID = P_DOC_ID;

Line: 879

        SELECT BLANKET_MAX_AMOUNT - BLANKET_MIN_AMOUNT
        FROM OE_BLANKET_HEADERS_EXT
        WHERE ORDER_NUMBER = (SELECT ORDER_NUMBER
                              FROM OE_BLANKET_HEADERS_ALL
                              WHERE HEADER_ID = P_DOC_ID);

Line: 980

        SELECT ATTRIBUTE4
        FROM PO_HEADERS_ALL
        WHERE PO_HEADER_ID = P_DOC_ID;

Line: 1079

        SELECT ATTRIBUTE4
        FROM OE_BLANKET_HEADERS_ALL
        WHERE HEADER_ID = P_DOC_ID;

Line: 1084

        SELECT flex_value_id
		FROM fnd_flex_values_vl ffvv,okc_bus_variables_b obvb
		WHERE ffvv.flex_value_set_id = obvb.VALUE_SET_ID and
		    	obvb.VARIABLE_CODE = p_variable_code and
				ffvv.FLEX_VALUE = p_flex_value;