APPS.PO_VAL_PRICE_DIFFS SQL Statements

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

Line: 294

INSERT INTO PO_VALIDATION_RESULTS_GT
( result_set_id
, entity_type
, entity_id
, column_name
, column_val
, message_name
)
SELECT
  x_result_set_id
, c_entity_type_PRICE_DIFF
, p_price_differential_id_tbl(i)
, c_PRICE_TYPE
, p_price_type_tbl(i)
, PO_MESSAGE_S.PO_SVC_PRC_TYPE_NOT_ON_SRC_DOC
FROM DUAL
WHERE
    p_entity_type_tbl(i) = c_PO_LINE
AND EXISTS
( SELECT null
  FROM
    PO_PRICE_DIFFERENTIALS SRC_PRICE_DIFF
  WHERE
      SRC_PRICE_DIFF.entity_id =
        NVL(p_from_line_location_id_tbl(i),p_from_line_id_tbl(i))
  AND SRC_PRICE_DIFF.entity_type =
        NVL2(p_from_line_location_id_tbl(i),c_PRICE_BREAK,c_BLANKET_LINE)
  AND SRC_PRICE_DIFF.enabled_flag = 'N'
  AND SRC_PRICE_DIFF.price_type = p_price_type_tbl(i)
)
;

Line: 381

INSERT INTO PO_VALIDATION_RESULTS_GT
( result_set_id
, entity_type
, entity_id
, column_name
, column_val
, message_name
-- TOKENS IN PRICE DIFFERNTIAL VALIDATION MESSAGE ARE NOT REPLACED
, token1_name
, token1_value
, token2_name
, token2_value
--
)
SELECT
  x_result_set_id
, c_entity_type_PRICE_DIFF
, p_price_differential_id_tbl(i)
, c_MULTIPLIER
, p_multiplier_tbl(i)
, PO_MESSAGE_S.PO_SVC_MULTIPLIER_BTWN_MIN_MAX
-- Removed the EXISTS statement from the WHERE clause
, c_MIN
, SRC_PRICE_DIFF.min_multiplier
, c_MAX
, SRC_PRICE_DIFF.max_multiplier
FROM PO_PRICE_DIFFERENTIALS SRC_PRICE_DIFF
WHERE
    p_entity_type_tbl(i) = c_PO_LINE
AND
    SRC_PRICE_DIFF.entity_id =
        NVL(p_from_line_location_id_tbl(i),p_from_line_id_tbl(i))
AND SRC_PRICE_DIFF.entity_type =
        NVL2(p_from_line_location_id_tbl(i),c_PRICE_BREAK,c_BLANKET_LINE)
--Bug 5415284 - Added this filter to insure we retreive a unique price differential.
AND SRC_PRICE_DIFF.price_type = p_price_type_tbl(i)
AND SRC_PRICE_DIFF.max_multiplier IS NOT NULL
AND ( p_multiplier_tbl(i) < SRC_PRICE_DIFF.min_multiplier
    OR  p_multiplier_tbl(i) > SRC_PRICE_DIFF.max_multiplier
    );

Line: 478

INSERT INTO PO_VALIDATION_RESULTS_GT
( result_set_id
, entity_type
, entity_id
, column_name
, column_val
, message_name
-- TOKENS IN PRICE DIFFERNTIAL VALIDATION MESSAGE ARE NOT REPLACED
, token1_name
, token1_value
--
)
SELECT
  x_result_set_id
, c_entity_type_PRICE_DIFF
, p_price_differential_id_tbl(i)
, c_MULTIPLIER
, p_multiplier_tbl(i)
, PO_MESSAGE_S.PO_SVC_MULTIPLIER_GT_MIN
-- Removed the EXISTS statement from the WHERE clause
, c_MIN
, SRC_PRICE_DIFF.min_multiplier
FROM PO_PRICE_DIFFERENTIALS SRC_PRICE_DIFF
WHERE
    p_entity_type_tbl(i) = c_PO_LINE
AND SRC_PRICE_DIFF.entity_id =
      NVL(p_from_line_location_id_tbl(i),p_from_line_id_tbl(i))
AND SRC_PRICE_DIFF.entity_type =
      NVL2(p_from_line_location_id_tbl(i),c_PRICE_BREAK,c_BLANKET_LINE)
--Bug 5415284 - Added this filter to insure we retreive a unique price differential.
AND SRC_PRICE_DIFF.price_type = p_price_type_tbl(i)
AND SRC_PRICE_DIFF.max_multiplier IS NULL
AND p_multiplier_tbl(i) < SRC_PRICE_DIFF.min_multiplier;