[Home] [Help]
267: IS
268: SELECT 'Already exists'
269: FROM SYS.DUAL
270: WHERE EXISTS( SELECT NULL
271: FROM BOM_SUB_OPERATION_RESOURCES
272: WHERE schedule_flag = p_schedule_flag
273: AND resource_id <> p_resource_id
274: AND substitute_group_num = p_sub_group_num
275: AND operation_sequence_id = p_op_seq_id
334: IS
335: SELECT 'Already exists'
336: FROM SYS.DUAL
337: WHERE EXISTS( SELECT NULL
338: FROM BOM_SUB_OPERATION_RESOURCES
339: WHERE autocharge_type = l_PO_MOVE
340: AND resource_id <> p_resource_id
341: AND substitute_group_num = p_sub_group_num
342: AND operation_sequence_id = p_op_seq_id
408: IS
409: SELECT 'Already exists'
410: FROM SYS.DUAL
411: WHERE EXISTS( SELECT NULL
412: FROM BOM_SUB_OPERATION_RESOURCES
413: WHERE principle_flag = 1 -- Yes
414: AND NVL(acd_type, l_ACD_ADD) <> l_ACD_DISABLE
415: AND (
416: ( resource_id <> p_res_id )
474: AND rownum=1;
475:
476: CURSOR l_sch_sub_res_cur IS
477: SELECT resource_id
478: FROM bom_sub_operation_resources
479: WHERE operation_sequence_id = p_op_seq_id
480: AND schedule_seq_num = p_sch_seq_num
481: AND schedule_flag not in (p_sch_flag,l_NO_SCHEDULE)
482: AND (
1357: SELECT 'Rev Sub Op Resource Not Exists'
1358: FROM DUAL
1359: WHERE NOT EXISTS (SELECT NULL
1360: FROM BOM_OPERATION_SEQUENCES bos
1361: , BOM_SUB_OPERATION_RESOURCES bsor
1362: WHERE bsor.substitute_group_num = p_sub_group_num
1363: AND bsor.resource_id = p_resource_id
1364: AND bsor.operation_sequence_id = bos.operation_sequence_id
1365: AND bos.operation_sequence_id = p_op_seq_id
1376: IS
1377: SELECT 'Sub Res Duplicate'
1378: FROM DUAL
1379: WHERE EXISTS ( SELECT NULL
1380: FROM BOM_SUB_OPERATION_RESOURCES
1381: WHERE NVL(ACD_TYPE, 1) = NVL(p_acd_type, 1)
1382: AND BASIS_TYPE = p_basis_type
1383: AND RESOURCE_ID = p_resource_id
1384: AND SUBSTITUTE_GROUP_NUM = p_substitute_group_number