APPS.WSMPCPSB dependencies on WSM_CO_PROD_SUBSTITUTES

Line 22: ** FROM wsm_co_prod_substitutes

18: /* SELECT 1 INTO dummy
19: ** FROM DUAL
20: ** WHERE NOT EXISTS
21: ** ( SELECT 1
22: ** FROM wsm_co_prod_substitutes
23: ** WHERE co_product_group_id = X_co_product_group_id
24: ** AND co_product_id = X_co_product_id
25: ** AND substitute_co_product_id = X_substitute_coprod_id
26: ** AND ((X_Rowid IS NULL) OR (ROWID <> X_ROWID)));

Line 37: FROM wsm_co_prod_substitutes

33:
34: -- modification begin for perf. tuning.. abedajna 10/12/00
35:
36: SELECT 1 INTO x1_dummy
37: FROM wsm_co_prod_substitutes
38: WHERE co_product_group_id = X_co_product_group_id
39: AND co_product_id = X_co_product_id
40: AND substitute_co_product_id = X_substitute_coprod_id
41: AND ((X_Rowid IS NULL) OR (ROWID <> X_ROWID));

Line 74: DELETE FROM WSM_CO_PROD_SUBSTITUTES

70: PROCEDURE Delete_substitutes (x_co_product_group_id IN NUMBER,
71: x_co_product_id IN NUMBER) IS
72: BEGIN
73:
74: DELETE FROM WSM_CO_PROD_SUBSTITUTES
75: WHERE co_product_group_id = x_co_product_group_id
76: AND substitute_co_product_id = x_co_product_id;
77:
78: END Delete_Substitutes;