APPS.BOM_DELETE_GROUPS_API dependencies on BOM_INVENTORY_COMPONENTS

Line 134: * Purpose : updates op sequences to 1 in BOM_INVENTORY_COMPONENTS

130: * FUNCTION : update_op_sequences
131: * Parameters IN :tdelete_entity_type ,routing_seq_id
132: * Parameters OUT: err_text
133: * return : 0 -success , other - SQL Exception
134: * Purpose : updates op sequences to 1 in BOM_INVENTORY_COMPONENTS
135: ******************************************************************/
136:
137: FUNCTION update_op_sequences(delete_entity_type IN NUMBER,
138: routing_seq_id IN NUMBER,

Line 1381: * Purpose : updates op sequences to 1 in BOM_INVENTORY_COMPONENTS

1377: * FUNCTION : update_op_sequences
1378: * Parameters IN :tdelete_entity_type ,routing_seq_id
1379: * Parameters OUT: err_text
1380: * return : 0 -success , other - SQL Exception
1381: * Purpose : updates op sequences to 1 in BOM_INVENTORY_COMPONENTS
1382: ******************************************************************/
1383:
1384: FUNCTION update_op_sequences(delete_entity_type IN NUMBER,
1385: routing_seq_id IN NUMBER,

Line 1393: UPDATE BOM_INVENTORY_COMPONENTS

1389:
1390: BEGIN
1391: if (delete_entity_type = 3) THEN/* routing delete */
1392: stmt_num := 1;
1393: UPDATE BOM_INVENTORY_COMPONENTS
1394: SET OPERATION_SEQ_NUM = 1
1395: WHERE BILL_SEQUENCE_ID = (SELECT BILL_SEQUENCE_ID
1396: FROM BOM_BILL_OF_MATERIALS BOM,
1397: BOM_OPERATIONAL_ROUTINGS BOR

Line 1405: UPDATE BOM_INVENTORY_COMPONENTS BIC

1401: AND nvl(BOR.ALTERNATE_ROUTING_DESIGNATOR, 'NONE') =
1402: nvl(BOM.ALTERNATE_BOM_DESIGNATOR, 'NONE'));
1403: else /* operation delete */
1404: stmt_num := 2;
1405: UPDATE BOM_INVENTORY_COMPONENTS BIC
1406: SET OPERATION_SEQ_NUM = 1
1407: WHERE BILL_SEQUENCE_ID = (SELECT BILL_SEQUENCE_ID
1408: FROM BOM_BILL_OF_MATERIALS BOM,
1409: BOM_OPERATIONAL_ROUTINGS BOR