28: l_formula_id NUMBER;
29: l_routing_id NUMBER;
30: l_validity_rule_id NUMBER;
31: l_organization_id NUMBER;
32: l_routing_class gmd_routings_b.routing_class%TYPE;
33: expected_error EXCEPTION;
34:
35: CURSOR cur_get_info (v_batch_id NUMBER)
36: IS
67:
68: CURSOR routing_process_loss_cursor (v_routing_id NUMBER)
69: IS
70: SELECT routing_class, fixed_process_loss, fixed_process_loss_uom
71: FROM gmd_routings_b
72: WHERE routing_id = v_routing_id;
73:
74: CURSOR routing_cls_process_loss (v_routing_id NUMBER)
75: IS
73:
74: CURSOR routing_cls_process_loss (v_routing_id NUMBER)
75: IS
76: SELECT b.fixed_process_loss, b.routing_class_uom
77: FROM gmd_routings_b a, gmd_routing_class_b b
78: WHERE a.routing_id = v_routing_id
79: AND a.routing_class = b.routing_class (+);
80:
81: BEGIN