APPS.WSMPPCPD dependencies on WSM_CO_PROD_COMP_SUBSTITUTES

Line 584: FROM wsm_co_prod_comp_substitutes

580: e_proc_exception EXCEPTION;
581: x_rec bom_sub_comps_interface%ROWTYPE;
582:
583: CURSOR S IS SELECT *
584: FROM wsm_co_prod_comp_substitutes
585: WHERE co_product_group_id = x_co_product_group_id;
586:
587: BEGIN
588:

Line 715: FROM wsm_co_prod_comp_substitutes

711: x_sub_comp_record bom_substitute_components%ROWTYPE;
712: x_skip_sub_delete NUMBER := 0;
713:
714: CURSOR S IS SELECT *
715: FROM wsm_co_prod_comp_substitutes
716: WHERE co_product_group_id = x_co_product_group_id;
717:
718: CURSOR C (x_comp_seq_id NUMBER) IS SELECT rowid
719: FROM bom_substitute_components

Line 1199: FROM wsm_co_prod_comp_substitutes

1195: x_sub_comp_record bom_substitute_components%ROWTYPE;
1196: x_skip_sub_delete NUMBER := 0;
1197:
1198: CURSOR S IS SELECT *
1199: FROM wsm_co_prod_comp_substitutes
1200: WHERE co_product_group_id = x_co_product_group_id;
1201:
1202: CURSOR C (x_comp_seq_id NUMBER) IS SELECT rowid
1203: FROM bom_substitute_components

Line 1245: /* Insert into wsm_co_prod_comp_substitutes. */

1241: x_progress := '020';
1242:
1243: IF (x_co_prod_exists = 0) THEN
1244:
1245: /* Insert into wsm_co_prod_comp_substitutes. */
1246: WSMPCPCS.insert_row (
1247: x_rowid,
1248: x_co_product_group_id,
1249: x_substitute_component_id,

Line 1287: * have to be performed to both wsm_co_prod_comp_substitutes

1283:
1284: /*
1285: * A bill most likely exists for this
1286: * co-product relationship. Changes will
1287: * have to be performed to both wsm_co_prod_comp_substitutes
1288: * as well as bom_component_substitutes.
1289: */
1290:
1291: /*

Line 1389: by an insert into wsm_co_prod_comp_substitutes.

1385: END;
1386:
1387: /*
1388: Insert into bom_substitute_components followed
1389: by an insert into wsm_co_prod_comp_substitutes.
1390: */
1391: x_progress := '070';
1392: --LBM enh : Per Vani Hymavathi of BOM dev, we do not need to pass basis_type for processing substitute components
1393: -- as Substitute components shall automaticaly inherit the basis type.

Line 2898: FROM wsm_co_prod_comp_substitutes

2894: e_delete_component EXCEPTION;
2895:
2896: CURSOR C IS
2897: SELECT rowid
2898: FROM wsm_co_prod_comp_substitutes
2899: WHERE co_product_group_id = x_co_product_group_id;
2900:
2901: CURSOR S IS
2902: SELECT bcp.co_product_id