APPS.WSMPCPDS dependencies on WSM_CO_PRODUCTS

Line 53: CURSOR C IS SELECT rowid FROM WSM_CO_PRODUCTS

49: X_Attribute14 VARCHAR2,
50: X_Attribute15 VARCHAR2,
51: X_basis_type NUMBER --LBM enh
52: ) IS
53: CURSOR C IS SELECT rowid FROM WSM_CO_PRODUCTS
54: WHERE component_id = X_component_id
55: AND organization_id = X_organization_id
56: AND co_product_group_id = X_co_product_group_id
57: AND ( co_product_id = x_co_product_id

Line 62: /* CURSOR S IS SELECT WSM_co_products_s.nextval FROM sys.dual;

58: OR ((co_product_id is NULL) AND
59: (x_co_product_id is NULL)));
60:
61: --commented out by abedajna for perf. tuning
62: /* CURSOR S IS SELECT WSM_co_products_s.nextval FROM sys.dual;
63: **
64: ** BEGIN
65: ** if (X_co_product_group_id is NULL) then
66: ** OPEN S;

Line 82: INSERT INTO WSM_CO_PRODUCTS (

78: end if; --LBM enh
79:
80: IF (x_co_product_id IS NOT NULL) THEN
81:
82: INSERT INTO WSM_CO_PRODUCTS (
83: CO_PRODUCT_GROUP_ID,
84: COMPONENT_ID,
85: ORGANIZATION_ID,
86: CREATION_DATE,

Line 123: decode(X_co_product_group_id, NULL, WSM_co_products_s.nextval, X_co_product_group_id),

119: ATTRIBUTE15,
120: BASIS_TYPE ---LBM enh
121: ) VALUES (
122: -- abedajna X_co_product_group_id,
123: decode(X_co_product_group_id, NULL, WSM_co_products_s.nextval, X_co_product_group_id),
124: X_component_id,
125: X_organization_id,
126: X_creation_date,
127: X_created_by,

Line 166: INSERT INTO WSM_CO_PRODUCTS (

162: returning CO_PRODUCT_GROUP_ID into X_co_product_group_id;
163:
164: ELSE
165:
166: INSERT INTO WSM_CO_PRODUCTS (
167: CO_PRODUCT_GROUP_ID,
168: COMPONENT_ID,
169: ORGANIZATION_ID,
170: CREATION_DATE,

Line 214: decode(X_co_product_group_id, NULL, WSM_co_products_s.nextval, X_co_product_group_id),

210: COMP_ATTRIBUTE15,
211: BASIS_TYPE --LBM enh
212: ) VALUES (
213: -- abedajna X_co_product_group_id,
214: decode(X_co_product_group_id, NULL, WSM_co_products_s.nextval, X_co_product_group_id),
215: X_component_id,
216: X_organization_id,
217: X_creation_date,
218: X_created_by,

Line 318: FROM WSM_CO_PRODUCTS

314: X_Basis_type NUMBER ---LBM enh
315: ) IS
316: CURSOR C IS
317: SELECT *
318: FROM WSM_CO_PRODUCTS
319: WHERE rowid = X_Rowid
320: FOR UPDATE of component_id NOWAIT;
321: Recinfo C%ROWTYPE;
322: BEGIN

Line 333: This call is used to lock records in WSM_co_products

329: end if;
330: CLOSE C;
331:
332: /*
333: This call is used to lock records in WSM_co_products
334: for both components as well as co-products.
335: While modifying a co-product relationship ensure
336: that the component record is locked before attempting
337: to modify the co-product records for that component.

Line 624: UPDATE WSM_CO_PRODUCTS

620: end if; --LBM enh
621:
622: IF (X_co_product_id is NOT NULL) THEN
623:
624: UPDATE WSM_CO_PRODUCTS
625: SET
626: co_product_group_id = X_co_product_group_id,
627: component_id = X_component_id,
628: organization_id = X_organization_id,

Line 665: UPDATE WSM_CO_PRODUCTS

661: WHERE rowid = X_rowid;
662:
663: ELSE
664:
665: UPDATE WSM_CO_PRODUCTS
666: SET
667: co_product_group_id = X_co_product_group_id,
668: component_id = X_component_id,
669: organization_id = X_organization_id,

Line 740: ** FROM WSM_co_products

736: /* SELECT 1 INTO dummy
737: ** FROM DUAL
738: ** WHERE NOT EXISTS
739: ** ( SELECT 1
740: ** FROM WSM_co_products
741: ** WHERE component_id = X_component_id
742: ** AND organization_id = X_organization_id
743: ** AND ((X_Rowid IS NULL) OR (ROWID <> X_ROWID)));
744: **

Line 758: FROM WSM_co_products

754:
755: x1_dummy := 0;
756:
757: SELECT 1 INTO x1_dummy
758: FROM WSM_co_products
759: WHERE component_id = X_component_id
760: AND organization_id = X_organization_id
761: AND ((X_Rowid IS NULL) OR (ROWID <> X_ROWID));
762:

Line 798: DELETE FROM WSM_CO_PRODUCTS

794:
795: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
796: BEGIN
797:
798: DELETE FROM WSM_CO_PRODUCTS
799: WHERE rowid = X_Rowid;
800:
801: if (SQL%NOTFOUND) then
802: Raise NO_DATA_FOUND;