APPS.BOM_VALIDATE_OP_SEQ dependencies on BOM_OPERATION_SEQUENCES

Line 573: FROM BOM_OPERATION_SEQUENCES

569: , p_operation_type NUMBER )
570: IS
571:
572: SELECT revised_item_sequence_id
573: FROM BOM_OPERATION_SEQUENCES
574: WHERE NVL(OPERATION_TYPE, 1) = NVL(p_operation_type , 1)
575: AND OPERATION_SEQ_NUM = p_operation_sequence_number
576: AND EFFECTIVITY_DATE = p_effectivity_date -- Changed for bug 2647027
577: -- AND TRUNC(EFFECTIVITY_DATE) = TRUNC(p_effectivity_date)

Line 2940: FROM BOM_OPERATION_SEQUENCES

2936:
2937: -- Check if Old Op Seq is not implemented
2938: CURSOR l_old_op_seq_csr (p_old_op_seq_id NUMBER) IS
2939: SELECT 'implemented'
2940: FROM BOM_OPERATION_SEQUENCES
2941: WHERE implementation_date IS NULL
2942: AND operation_sequence_id = p_old_op_seq_id
2943: ;
2944:

Line 2971: FROM BOM_OPERATION_SEQUENCES

2967: IS
2968: SELECT 'Duplicate Operation'
2969: FROM DUAL
2970: WHERE EXISTS (SELECT NULL
2971: FROM BOM_OPERATION_SEQUENCES
2972: WHERE ( ( effectivity_date = p_start_effective_date -- Changed for bug 2647027
2973: -- WHERE ( ( TRUNC(effectivity_date) = TRUNC(p_start_effective_date)
2974: AND operation_type = l_EVENT )
2975: OR p_op_type <> l_EVENT

Line 2999: FROM BOM_OPERATION_SEQUENCES

2995: IS
2996: SELECT 'Overlapping'
2997: FROM DUAL
2998: WHERE EXISTS (SELECT NULL
2999: FROM BOM_OPERATION_SEQUENCES
3000: WHERE NVL(operation_type, l_EVENT) = NVL(p_op_type, l_EVENT)
3001: AND ((effectivity_date <
3002: NVL(p_disable_date, p_start_effective_date + 1)
3003: AND NVL(disable_date, p_start_effective_date + 1)

Line 3037: FROM BOM_OPERATION_SEQUENCES

3033: IS
3034: SELECT 'Overlapping'
3035: FROM DUAL
3036: WHERE EXISTS (SELECT NULL
3037: FROM BOM_OPERATION_SEQUENCES
3038: WHERE NVL(operation_type, l_EVENT) = NVL(p_op_type, l_EVENT)
3039: AND ((effectivity_date <
3040: NVL(p_disable_date, p_start_effective_date + 1)
3041: AND NVL(disable_date, p_start_effective_date + 1)

Line 3101: FROM BOM_OPERATION_SEQUENCES bos

3097: IS
3098: SELECT 'Old Op Seq is invalid'
3099: FROM SYS.DUAL
3100: WHERE NOT EXISTS ( SELECT NULL
3101: FROM BOM_OPERATION_SEQUENCES bos
3102: WHERE routing_sequence_id =
3103: ( SELECT common_routing_sequence_id
3104: FROM bom_operational_routings bor
3105: WHERE routing_sequence_id = p_rtg_seq_id

Line 3126: FROM BOM_OPERATION_SEQUENCES bos2

3122: )
3123: AND NVL(bos.revised_item_sequence_id, -999)
3124: <> nvl(p_rev_item_seq_id, -100)
3125: AND NOT EXISTS (SELECT NULL
3126: FROM BOM_OPERATION_SEQUENCES bos2
3127: WHERE bos2.revised_item_sequence_id
3128: = NVL(p_rev_item_seq_id, -888)
3129: AND decode(bos2.implementation_date,
3130: null,

Line 4281: FROM BOM_OPERATION_SEQUENCES

4277:
4278:
4279: CURSOR c_CheckDisabled IS
4280: SELECT NULL
4281: FROM BOM_OPERATION_SEQUENCES
4282: WHERE NVL(operation_type, 1) = NVL(p_operation_type, 1)
4283: AND effectivity_date = p_effectivity_date -- Changed for bug 2647027
4284: -- AND TRUNC(effectivity_date) = TRUNC(p_effectivity_date)
4285: AND routing_sequence_id = p_routing_sequence_id