[Home] [Help]
92: )
93:
94: IS
95: SELECT 'Rev Comp referencing Seq Num exists'
96: FROM SYS.DUAL
97: WHERE EXISTS (SELECT NULL
98: FROM BOM_INVENTORY_COMPONENTS bic
99: , ENG_REVISED_ITEMS eri
100: WHERE TRUNC(bic.effectivity_date) >= TRUNC(p_start_effective_date)
150: , p_rev_item_id NUMBER
151: )
152: IS
153: SELECT 'Op Seq does not exist'
154: FROM SYS.DUAL
155: WHERE EXISTS (SELECT NULL
156: FROM WIP_DISCRETE_JOBS wdj
157: WHERE (wdj.status_type <> 1
158: OR
171: , p_operation_seq_num NUMBER
172: , p_organization_id NUMBER )
173: IS
174: SELECT 'Op Seq does not exist'
175: FROM SYS.DUAL
176: WHERE EXISTS (SELECT NULL
177: FROM WIP_DISCRETE_JOBS wdj
178: , WIP_ENTITIES we
179: , WIP_ENTITIES we1
196: CURSOR l_check_cum_csr ( p_from_wip_entity_id NUMBER
197: , p_operation_seq_num NUMBER)
198: IS
199: SELECT 'Op Seq does not exist'
200: FROM SYS.DUAL
201: WHERE EXISTS (SELECT NULL
202: FROM WIP_DISCRETE_JOBS wdj
203: WHERE (wdj.status_type <> 1
204: OR
305: -- Check if the operatin already has resources
306: CURSOR l_exist_res_cur (x_op_seq_id NUMBER)
307: IS
308: SELECT 'Resource Exist'
309: FROM DUAL
310: WHERE EXISTS ( SELECT NULL
311: FROM BOM_OPERATION_RESOURCES
312: WHERE operation_sequence_id = p_op_seq_id
313: ) ;
2350: -- Check if the operatin already has resources
2351: CURSOR l_exist_res_cur (p_op_seq_id NUMBER)
2352: IS
2353: SELECT 'Resource Exist'
2354: FROM DUAL
2355: WHERE EXISTS ( SELECT NULL
2356: FROM BOM_OPERATION_RESOURCES
2357: WHERE operation_sequence_id = p_op_seq_id
2358: ) ;
2359:
2360: CURSOR c_std_sub_res (p_std_op_id NUMBER)
2361: IS
2362: SELECT 'Sub Resources Exist'
2363: FROM DUAL
2364: WHERE EXISTS (SELECT NULL
2365: FROM BOM_STD_SUB_OP_RESOURCES
2366: WHERE standard_operation_id = p_std_op_id
2367: AND Schedule_Seq_Num IS NULL); -- Bug 7370692
2375: , p_rit_seq_id NUMBER
2376: )
2377: IS
2378: SELECT 'Std Op Invalid'
2379: FROM DUAL
2380: WHERE NOT EXISTS (SELECT NULL
2381: FROM BOM_STANDARD_OPERATIONS bso
2382: , bom_operational_routings bor
2383: WHERE NVL(bso.operation_type,1 )
2944:
2945: -- Check if Rtg is referencing another a rtg as a common
2946: CURSOR l_rtg_cur (p_rtg_seq_id NUMBER) IS
2947: SELECT 'implemented'
2948: FROM DUAL
2949: WHERE EXISTS ( SELECT NULL
2950: FROM bom_operational_routings
2951: WHERE common_routing_sequence_id <> p_rtg_seq_id
2952: ) ;
2965: , p_op_type NUMBER
2966: , p_start_effective_date DATE )
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)
2993: , p_start_effective_date DATE
2994: , p_disable_date DATE )
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 <
3032: , p_start_effective_date DATE
3033: , p_disable_date DATE )
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 <
3072: , p_start_effective_date DATE
3073: )
3074: IS
3075: SELECT 'Dept is invalid'
3076: FROM DUAL
3077: WHERE NOT EXISTS (SELECT NULL
3078: FROM BOM_DEPARTMENTS bd
3079: WHERE NVL(TRUNC(bd.disable_date) , TRUNC(p_start_effective_date) + 1)
3080: > TRUNC(p_start_effective_date)
3096: p_old_op_seq_id NUMBER ,
3097: p_eco_for_production NUMBER )
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