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 1211: INSERT INTO BOM_OPERATION_RESOURCES

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

Line 1302: FROM BOM_OPERATION_RESOURCES

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

Line 1944: DELETE FROM BOM_OPERATION_RESOURCES

1940: DELETE FROM BOM_OPERATION_SEQUENCES
1941: WHERE OPERATION_SEQUENCE_ID = l_com_op_unexp_rec.operation_sequence_id ;
1942:
1943:
1944: DELETE FROM BOM_OPERATION_RESOURCES
1945: WHERE OPERATION_SEQUENCE_ID = l_com_op_unexp_rec.operation_sequence_id ;
1946:
1947:
1948: /******************************************************************

Line 2313: DELETE FROM BOM_OPERATION_RESOURCES

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