487:
488: -- Kapil LCF-GMO ME : Bug#5458666
489: CURSOR Cur_get_routing_status(V_routing_id NUMBER) IS
490: SELECT ROUTING_STATUS
491: FROM GMD_ROUTINGS_B
492: WHERE routing_id = V_routing_id;
493: l_routing_status gmd_api_grp.status_rec_type;
494:
495: CURSOR Cur_get_routing_details(V_routing_id NUMBER) IS
493: l_routing_status gmd_api_grp.status_rec_type;
494:
495: CURSOR Cur_get_routing_details(V_routing_id NUMBER) IS
496: SELECT ROUTING_NO, ROUTING_VERS
497: FROM GMD_ROUTINGS_B
498: WHERE routing_id = V_routing_id;
499: l_routing_no VARCHAR2(32);
500: l_routing_vers NUMBER;
501: