The following lines contain the word 'select', 'insert', 'update' or 'delete':
-- 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;
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';
l_price_update_tolerance PO_HEADERS_ALL.PRICE_UPDATE_TOLERANCE%TYPE;
Cursor l_price_update_csr Is
select PRICE_UPDATE_TOLERANCE from PO_HEADERS_ALL
WHERE po_header_id = P_DOC_ID ;
OPEN l_price_update_csr;
FETCH l_price_update_csr INTO l_price_update_tolerance;
dbms_output.put_line('l_price_update_tolerance IS '||l_price_update_tolerance);
l_price_update_tolerance := l_price_update_tolerance+10;
CLOSE l_price_update_csr;
X_VARIABLE_VALUE_ID := l_price_update_tolerance;
IF l_price_update_csr%ISOPEN THEN
CLOSE l_price_update_csr;
IF l_price_update_csr%ISOPEN THEN
CLOSE l_price_update_csr;
IF l_price_update_csr%ISOPEN THEN
CLOSE l_price_update_csr;
END GET_PRICE_UPDATE_TOLERANCE;
SELECT TEMPLATE_INSTANCE_ID FROM ASO_SUP_tmpl_INSTANCE where owner_table_id = P_DOC_ID;
SELECT value FROM ASO_SUP_INSTANCE_VALUE
WHERE template_instance_id = p_tmp_instace_id
AND value is not null;
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'));
SELECT SHIP_FROM_ORG_ID
FROM OE_BLANKET_HEADERS_ALL
WHERE HEADER_ID = P_DOC_ID;
SELECT UOM
FROM PON_BID_ITEM_PRICES
WHERE BID_NUMBER = P_DOC_ID;
SELECT UOM_CODE
FROM PON_AUCTION_ITEM_PRICES_ALL
WHERE BEST_BID_NUMBER = P_DOC_ID;
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);
SELECT NVL(MIN_RELEASE_AMOUNT,0)/NVL(AMOUNT_LIMIT, 1)
FROM PO_HEADERS_ALL
WHERE PO_HEADER_ID = P_DOC_ID;
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);
SELECT ATTRIBUTE4
FROM PO_HEADERS_ALL
WHERE PO_HEADER_ID = P_DOC_ID;
SELECT ATTRIBUTE4
FROM OE_BLANKET_HEADERS_ALL
WHERE HEADER_ID = P_DOC_ID;
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;