218: SELECT 1 INTO l_rout_exists
219: FROM dual
220: WHERE exists(
221: SELECT routing_sequence_id
222: FROM bom_operational_routings
223: WHERE assembly_item_id = g_RepSchedule_rec.primary_item_id
224: AND organization_id = g_RepSchedule_rec.organization_id);
225:
226: IF (l_rout_exists = 0) THEN
268: SELECT 1 INTO l_rout_exists
269: FROM dual
270: WHERE exists(
271: SELECT routing_sequence_id
272: FROM bom_operational_routings
273: WHERE assembly_item_id = g_RepSchedule_rec.primary_item_id
274: AND organization_id = g_RepSchedule_rec.organization_id);
275:
276: IF (l_rout_exists = 0) THEN
314: SELECT 1 INTO l_rout_exists
315: FROM dual
316: WHERE exists(
317: SELECT routing_sequence_id
318: FROM bom_operational_routings
319: WHERE assembly_item_id = g_RepSchedule_rec.primary_item_id
320: AND organization_id = g_RepSchedule_rec.organization_id);
321:
322: IF (l_rout_exists = 0) THEN
363: SELECT 1 INTO l_rout_exists
364: FROM dual
365: WHERE exists(
366: SELECT routing_sequence_id
367: FROM bom_operational_routings
368: WHERE assembly_item_id = g_RepSchedule_rec.primary_item_id
369: AND organization_id = g_RepSchedule_rec.organization_id);
370:
371: IF (l_rout_exists = 0) THEN