[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
410: IS
411: SELECT 'Already exists'
412: FROM SYS.DUAL
413: WHERE EXISTS( SELECT NULL
414: FROM BOM_SUB_OPERATION_RESOURCES
415: WHERE principle_flag = 1 -- Yes
416: AND NVL(acd_type, l_ACD_ADD) <> l_ACD_DISABLE
417: AND (
418: ( resource_id <> p_res_id )
479: AND rownum=1;
480:
481: CURSOR l_sch_sub_res_cur IS
482: SELECT resource_id
483: FROM bom_sub_operation_resources
484: WHERE operation_sequence_id = p_op_seq_id
485: AND schedule_seq_num = p_sch_seq_num
486: AND schedule_flag not in (p_sch_flag,l_NO_SCHEDULE)
487: AND (
1387: SELECT 'Rev Sub Op Resource Not Exists'
1388: FROM DUAL
1389: WHERE NOT EXISTS (SELECT NULL
1390: FROM BOM_OPERATION_SEQUENCES bos
1391: , BOM_SUB_OPERATION_RESOURCES bsor
1392: WHERE bsor.substitute_group_num = p_sub_group_num
1393: AND bsor.resource_id = p_resource_id
1394: AND bsor.operation_sequence_id = bos.operation_sequence_id
1395: AND bos.operation_sequence_id = p_op_seq_id
1407: IS
1408: SELECT 'Sub Res Duplicate'
1409: FROM DUAL
1410: WHERE EXISTS ( SELECT NULL
1411: FROM BOM_SUB_OPERATION_RESOURCES
1412: WHERE NVL(ACD_TYPE, 1) = NVL(p_acd_type, 1)
1413: AND BASIS_TYPE = p_basis_type
1414: AND RESOURCE_ID = p_resource_id
1415: AND SUBSTITUTE_GROUP_NUM = p_substitute_group_number