APPS.WSMPCPSB SQL Statements

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

Line: 18

/*  SELECT 1 INTO dummy
**  FROM   DUAL
**  WHERE NOT EXISTS
**    ( SELECT 1
**    FROM wsm_co_prod_substitutes
**    WHERE co_product_group_id         = X_co_product_group_id
**    AND   co_product_id               = X_co_product_id
**    AND   substitute_co_product_id    = X_substitute_coprod_id
**    AND  ((X_Rowid IS NULL) OR (ROWID <> X_ROWID)));

Line: 36

  SELECT 1 INTO x1_dummy
  FROM wsm_co_prod_substitutes
  WHERE co_product_group_id         = X_co_product_group_id
  AND   co_product_id               = X_co_product_id
  AND   substitute_co_product_id    = X_substitute_coprod_id
  AND  ((X_Rowid IS NULL) OR (ROWID <> X_ROWID));

Line: 70

PROCEDURE Delete_substitutes (x_co_product_group_id     IN  NUMBER,
                              x_co_product_id           IN  NUMBER) IS
BEGIN

    DELETE FROM WSM_CO_PROD_SUBSTITUTES
    WHERE  co_product_group_id      = x_co_product_group_id
    AND    substitute_co_product_id = x_co_product_id;

Line: 78

END Delete_Substitutes;