APPS.WSMPPCPD dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 711: x_sub_comp_record bom_substitute_components%ROWTYPE;

707: x_comp_exists NUMBER := NULL;
708: x_component_sequence_id NUMBER := NULL;
709: x_bill_sequence_id NUMBER := NULL;
710: x_sub_rowid VARCHAR2(30):= NULL;
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

Line 719: FROM bom_substitute_components

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
720: WHERE component_sequence_id = x_comp_seq_id
721: AND substitute_component_id = x_substitute_comp_id_old
722: FOR UPDATE OF substitute_component_id NOWAIT;
723:

Line 839: FROM bom_substitute_components

835: x_dummy := 0;
836:
837: SELECT 1
838: INTO x_dummy
839: FROM bom_substitute_components
840: WHERE nvl(acd_type, 1) = 1
841: AND substitute_component_id = x_substitute_component_id
842: AND component_sequence_id = x_component_sequence_id;
843:

Line 970: FROM bom_substitute_components

966: x_dummy := 0;
967:
968: SELECT 1
969: INTO x_dummy
970: FROM bom_substitute_components
971: WHERE nvl(acd_type, 1) = 1
972: AND substitute_component_id = x_substitute_component_id
973: AND component_sequence_id = x_component_sequence_id;
974:

Line 1195: x_sub_comp_record bom_substitute_components%ROWTYPE;

1191: x_comp_exists NUMBER := NULL;
1192: x_component_sequence_id NUMBER := NULL;
1193: x_bill_sequence_id NUMBER := NULL;
1194: x_sub_rowid VARCHAR2(30):= NULL;
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

Line 1203: FROM bom_substitute_components

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
1204: WHERE component_sequence_id = x_comp_seq_id
1205: AND substitute_component_id = x_substitute_comp_id_old
1206: FOR UPDATE OF substitute_component_id NOWAIT;
1207:

Line 1333: FROM bom_substitute_components

1329: x_dummy := 0;
1330:
1331: SELECT 1
1332: INTO x_dummy
1333: FROM bom_substitute_components
1334: WHERE nvl(acd_type, 1) = 1
1335: AND substitute_component_id = x_substitute_component_id
1336: AND component_sequence_id = rec.component_sequence_id;
1337:

Line 1388: Insert into bom_substitute_components followed

1384: null;
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

Line 1437: FROM bom_substitute_components

1433: x_dummy := 0;
1434:
1435: SELECT 1
1436: INTO x_dummy
1437: FROM bom_substitute_components
1438: WHERE nvl(acd_type, 1) = 1
1439: AND substitute_component_id = x_substitute_component_id
1440: AND component_sequence_id =rec.component_sequence_id;
1441:

Line 1494: * Lock record in bom_substitute_components

1490: END;
1491: END IF;
1492:
1493: /*
1494: * Lock record in bom_substitute_components
1495: * and perform the update.
1496: */
1497:
1498: OPEN C (rec.component_sequence_id);

Line 1537: /* Lock record in bom_substitute_components. */

1533:
1534:
1535: ELSIF (x_process_code = 3) THEN /* Delete */
1536:
1537: /* Lock record in bom_substitute_components. */
1538: x_progress := '120';
1539:
1540: OPEN C (rec.component_sequence_id);
1541: FETCH C INTO x_sub_rowid;

Line 3134: delete bom_substitute_components

3130:
3131: BEGIN
3132: x_progress := '034';
3133:
3134: delete bom_substitute_components
3135: Where component_sequence_id = x_component_sequence_id;
3136:
3137: EXCEPTION
3138: WHEN NO_DATA_FOUND THEN