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 3038: FROM BOM_OPERATION_SEQUENCES

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

Line 3102: FROM BOM_OPERATION_SEQUENCES bos

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

Line 3127: FROM BOM_OPERATION_SEQUENCES bos2

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

Line 4282: FROM BOM_OPERATION_SEQUENCES

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