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 1376: * Purpose : updates op sequences to 1 in BOM_INVENTORY_COMPONENTS

1372: * FUNCTION : update_op_sequences
1373: * Parameters IN :tdelete_entity_type ,routing_seq_id
1374: * Parameters OUT: err_text
1375: * return : 0 -success , other - SQL Exception
1376: * Purpose : updates op sequences to 1 in BOM_INVENTORY_COMPONENTS
1377: ******************************************************************/
1378:
1379: FUNCTION update_op_sequences(delete_entity_type IN NUMBER,
1380: routing_seq_id IN NUMBER,

Line 1388: UPDATE BOM_INVENTORY_COMPONENTS

1384:
1385: BEGIN
1386: if (delete_entity_type = 3) THEN/* routing delete */
1387: stmt_num := 1;
1388: UPDATE BOM_INVENTORY_COMPONENTS
1389: SET OPERATION_SEQ_NUM = 1
1390: WHERE BILL_SEQUENCE_ID = (SELECT BILL_SEQUENCE_ID
1391: FROM BOM_BILL_OF_MATERIALS BOM,
1392: BOM_OPERATIONAL_ROUTINGS BOR

Line 1400: UPDATE BOM_INVENTORY_COMPONENTS BIC

1396: AND nvl(BOR.ALTERNATE_ROUTING_DESIGNATOR, 'NONE') =
1397: nvl(BOM.ALTERNATE_BOM_DESIGNATOR, 'NONE'));
1398: else /* operation delete */
1399: stmt_num := 2;
1400: UPDATE BOM_INVENTORY_COMPONENTS BIC
1401: SET OPERATION_SEQ_NUM = 1
1402: WHERE BILL_SEQUENCE_ID = (SELECT BILL_SEQUENCE_ID
1403: FROM BOM_BILL_OF_MATERIALS BOM,
1404: BOM_OPERATIONAL_ROUTINGS BOR