[Home] [Help]
1056: --
1057: -- Copy alternate resources
1058: --
1059:
1060: INSERT INTO BOM_SUB_OPERATION_RESOURCES
1061: ( operation_sequence_id
1062: , substitute_group_num
1063: , resource_id
1064: , schedule_seq_num
1308: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1309: ('Debug2. . . ' ) ;
1310: END IF ;
1311:
1312: INSERT INTO BOM_SUB_OPERATION_RESOURCES
1313: ( operation_sequence_id
1314: , substitute_group_num
1315: , resource_id
1316: , replacement_group_num
1399: , p_eco_name -- change_notice
1400: , 3 -- acd_type : Disable
1401: -- , original_system_reference
1402: -- , setup_id
1403: FROM BOM_SUB_OPERATION_RESOURCES
1404: WHERE operation_sequence_id = p_old_operation_sequence_id ;
1405:
1406: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1407: ('Debug3. . . ' ) ;
1970: ) ;
1971: END IF;
1972:
1973:
1974: DELETE FROM BOM_SUB_OPERATION_RESOURCES
1975: WHERE OPERATION_SEQUENCE_ID = l_com_op_unexp_rec.operation_sequence_id ;
1976:
1977:
1978: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
2340:
2341: --
2342: -- Delete child Sub Operation Resources
2343: --
2344: DELETE FROM BOM_SUB_OPERATION_RESOURCES
2345: WHERE operation_sequence_id = p_operation_sequence_id ;
2346:
2347: -- Return Token
2348: x_mesg_token_tbl := l_mesg_token_tbl ;