APPS.PO_VAL_PRICE_DIFFS2 SQL Statements

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

Line: 46

      INSERT INTO po_validation_results_gt
                  (result_set_id,
                   result_type,
                   entity_type,
                   entity_id,
                   message_name,
                   column_name,
                   column_val,
                   token1_name,
                   token1_value,
			 validation_id)
        SELECT x_result_set_id,
               po_validations.c_result_type_failure,
               c_entity_type_price_diff,
               p_id_tbl(i),
               DECODE(p_price_type_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_SVC_INVALID_PRICE_TYPE'),
               'PRICE_TYPE',
               p_price_type_tbl(i),
               'PRICE_TYPE',
               p_price_type_tbl(i),
               DECODE(p_price_type_tbl(i), NULL, PO_VAL_CONSTANTS.c_price_type_not_null,
                      PO_VAL_CONSTANTS.c_price_type_valid)
          FROM DUAL
         WHERE p_price_type_tbl(i) IS NULL
               OR(p_price_type_tbl(i) IS NOT NULL AND
               NOT EXISTS(SELECT 1
                          FROM po_price_diff_lookups_v
                          WHERE price_differential_type = p_price_type_tbl(i)));

Line: 124

      INSERT INTO po_session_gt
                  (key,
                   num1,
                   index_num1,
                   char1,
                   char2)
      SELECT l_gt_key,
             p_id_tbl(i),
             p_entity_id_tbl(i),
             p_entity_type_tbl(i),
             p_price_type_tbl(i)
      FROM   DUAL;

Line: 141

      INSERT INTO po_validation_results_gt
                  (result_set_id,
                   result_type,
                   entity_type,
                   entity_id,
                   message_name,
                   column_name,
                   column_val,
                   token1_name,
                   token1_value,
		       validation_id)
        SELECT x_result_set_id,
               po_validations.c_result_type_failure,
               c_entity_type_price_diff,
               p_id_tbl(i),
               'PO_PDOI_SVC_NO_MULTI_DIFF',
               'PRICE_TYPE',
               p_price_type_tbl(i),
               NULL,
               NULL,
               PO_VAL_CONSTANTS.c_multiple_price_diff
          FROM DUAL
         WHERE p_price_type_tbl(i) IS NOT NULL
           AND p_entity_type_tbl(i) IS NOT NULL
           AND p_entity_id_tbl(i) IS NOT NULL
           AND (EXISTS(SELECT 1
                       FROM po_price_differentials
                       WHERE entity_id = p_entity_id_tbl(i)
                         AND entity_type = p_entity_type_tbl(i)
                         AND price_type = p_price_type_tbl(i))
                OR
                EXISTS(SELECT 1
                       FROM po_price_diff_draft
                      WHERE entity_id = p_entity_id_tbl(i)
                        AND entity_type = p_entity_type_tbl(i)
                        AND price_type = p_price_type_tbl(i))
                OR
                EXISTS(SELECT 1
                       FROM po_session_gt
                      WHERE key = l_gt_key
                        AND num1 < p_id_tbl(i)
                        AND index_num1 = p_entity_id_tbl(i)
                        AND char1 = p_entity_type_tbl(i)
                        AND char2 = p_price_type_tbl(i)));

Line: 187

    DELETE FROM po_session_gt
    WHERE key = l_gt_key;

Line: 462

         INSERT INTO po_validation_results_gt
                     (result_set_id,
                      result_type,
                      entity_type,
                      entity_id,
                      message_name,
                      column_name,
                      column_val,
                      token1_name,
                      token1_value,
			    validation_id)
            SELECT x_result_set_id,
                   po_validations.c_result_type_failure,
                   c_entity_type_price_diff,
                   p_id_tbl(i),
                   'PO_PDOI_PRICE_DIFF_STYLE',
                   'STYLE_ID',
                   p_style_id_tbl(i),
                   'STYLE_ID',
                   p_style_id_tbl(i),
                   PO_VAL_CONSTANTS.c_price_diff_style_info
              FROM DUAL
             WHERE EXISTS(SELECT 1
                          FROM  po_doc_style_headers pdsh
                          WHERE pdsh.style_id = p_style_id_tbl(i) AND
                                NVL(pdsh.price_differentials_flag, 'N') = 'N');