APPS.WSMPCPCS dependencies on WSM_CO_PROD_COMP_SUBSTITUTES

Line 35: CURSOR C IS SELECT rowid FROM WSM_CO_PROD_COMP_SUBSTITUTES

31: X_Program_Id NUMBER,
32: X_Program_Update_Date DATE,
33: X_basis_type NUMBER --LBM enh
34: ) IS
35: CURSOR C IS SELECT rowid FROM WSM_CO_PROD_COMP_SUBSTITUTES
36: WHERE co_product_group_id = X_co_product_group_id
37: AND substitute_component_id = X_Substitute_Component_Id;
38: l_basis_type number; --LBM enh
39:

Line 47: INSERT INTO WSM_CO_PROD_COMP_SUBSTITUTES (

43: else
44: l_basis_type := null;
45: end if; --LBM enh
46:
47: INSERT INTO WSM_CO_PROD_COMP_SUBSTITUTES (
48: CO_PRODUCT_GROUP_ID,
49: SUBSTITUTE_COMPONENT_ID,
50: CREATION_DATE,
51: CREATED_BY,

Line 159: UPDATE WSM_CO_PROD_COMP_SUBSTITUTES

155: else
156: l_basis_type := null;
157: end if; --LBM enh
158:
159: UPDATE WSM_CO_PROD_COMP_SUBSTITUTES
160: SET
161: co_product_group_id = x_co_product_group_id,
162: substitute_component_id = x_substitute_component_id,
163: last_update_login = x_last_update_login,

Line 219: FROM WSM_CO_PROD_COMP_SUBSTITUTES

215: X_basis_type NUMBER --LBM enh
216: ) IS
217: CURSOR C IS
218: SELECT *
219: FROM WSM_CO_PROD_COMP_SUBSTITUTES
220: WHERE rowid = X_Rowid
221: FOR UPDATE of substitute_component_id NOWAIT;
222: Recinfo C%ROWTYPE;
223:

Line 319: ** FROM wsm_co_prod_comp_substitutes

315: ** SELECT 1 INTO dummy
316: ** FROM DUAL
317: ** WHERE NOT EXISTS
318: ** ( SELECT 1
319: ** FROM wsm_co_prod_comp_substitutes
320: ** WHERE co_product_group_id = X_co_product_group_id
321: ** AND substitute_component_id = X_substitute_component_id
322: ** AND ((X_Rowid IS NULL) OR (ROWID <> X_ROWID)));
323: **

Line 335: FROM wsm_co_prod_comp_substitutes

331:
332: x1_dummy := 0;
333:
334: SELECT 1 INTO x1_dummy
335: FROM wsm_co_prod_comp_substitutes
336: WHERE co_product_group_id = X_co_product_group_id
337: AND substitute_component_id = X_substitute_component_id
338: AND ((X_Rowid IS NULL) OR (ROWID <> X_ROWID));
339:

Line 367: DELETE FROM WSM_CO_PROD_COMP_SUBSTITUTES

363:
364: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
365: BEGIN
366:
367: DELETE FROM WSM_CO_PROD_COMP_SUBSTITUTES
368: WHERE rowid = X_Rowid;
369:
370: if (SQL%NOTFOUND) then
371: Raise NO_DATA_FOUND;