DBA Data[Home] [Help]

APPS.BOM_OP_SEQ_UTIL dependencies on BOM_SUB_OPERATION_RESOURCES

Line 1057: INSERT INTO BOM_SUB_OPERATION_RESOURCES

1053: --
1054: -- Copy alternate resources
1055: --
1056:
1057: INSERT INTO BOM_SUB_OPERATION_RESOURCES
1058: ( operation_sequence_id
1059: , substitute_group_num
1060: , resource_id
1061: , schedule_seq_num

Line 1309: INSERT INTO BOM_SUB_OPERATION_RESOURCES

1305: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1306: ('Debug2. . . ' ) ;
1307: END IF ;
1308:
1309: INSERT INTO BOM_SUB_OPERATION_RESOURCES
1310: ( operation_sequence_id
1311: , substitute_group_num
1312: , resource_id
1313: , replacement_group_num

Line 1400: FROM BOM_SUB_OPERATION_RESOURCES

1396: , p_eco_name -- change_notice
1397: , 3 -- acd_type : Disable
1398: -- , original_system_reference
1399: -- , setup_id
1400: FROM BOM_SUB_OPERATION_RESOURCES
1401: WHERE operation_sequence_id = p_old_operation_sequence_id ;
1402:
1403: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1404: ('Debug3. . . ' ) ;

Line 1971: DELETE FROM BOM_SUB_OPERATION_RESOURCES

1967: ) ;
1968: END IF;
1969:
1970:
1971: DELETE FROM BOM_SUB_OPERATION_RESOURCES
1972: WHERE OPERATION_SEQUENCE_ID = l_com_op_unexp_rec.operation_sequence_id ;
1973:
1974:
1975: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN

Line 2341: DELETE FROM BOM_SUB_OPERATION_RESOURCES

2337:
2338: --
2339: -- Delete child Sub Operation Resources
2340: --
2341: DELETE FROM BOM_SUB_OPERATION_RESOURCES
2342: WHERE operation_sequence_id = p_operation_sequence_id ;
2343:
2344: -- Return Token
2345: x_mesg_token_tbl := l_mesg_token_tbl ;