APPS.BOM_OP_SEQ_UTIL dependencies on BOM_OPERATION_RESOURCES

Line 966: INSERT INTO BOM_OPERATION_RESOURCES

962: )
963: IS
964: BEGIN
965:
966: INSERT INTO BOM_OPERATION_RESOURCES
967: ( operation_sequence_id
968: , resource_seq_num
969: , resource_id
970: , acd_type

Line 1214: INSERT INTO BOM_OPERATION_RESOURCES

1210: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1211: ('Debug1. . . ' ) ;
1212: END IF ;
1213:
1214: INSERT INTO BOM_OPERATION_RESOURCES
1215: ( operation_sequence_id
1216: , resource_seq_num
1217: , resource_id
1218: , activity_id

Line 1305: FROM BOM_OPERATION_RESOURCES

1301: , p_eco_name -- change_notice
1302: , 3 -- acd_type : Disable
1303: -- , original_system_reference
1304: -- , setup_id
1305: FROM BOM_OPERATION_RESOURCES
1306: WHERE operation_sequence_id = p_old_operation_sequence_id ;
1307:
1308: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1309: ('Debug2. . . ' ) ;

Line 1947: DELETE FROM BOM_OPERATION_RESOURCES

1943: DELETE FROM BOM_OPERATION_SEQUENCES
1944: WHERE OPERATION_SEQUENCE_ID = l_com_op_unexp_rec.operation_sequence_id ;
1945:
1946:
1947: DELETE FROM BOM_OPERATION_RESOURCES
1948: WHERE OPERATION_SEQUENCE_ID = l_com_op_unexp_rec.operation_sequence_id ;
1949:
1950:
1951: /******************************************************************

Line 2316: DELETE FROM BOM_OPERATION_RESOURCES

2312:
2313: --
2314: -- Delete child Operation Resources
2315: --
2316: DELETE FROM BOM_OPERATION_RESOURCES
2317: WHERE operation_sequence_id = p_operation_sequence_id ;
2318:
2319:
2320: IF SQL%FOUND THEN