151: FUNCTION OPRNTBLCFFORMULA RETURN VARCHAR2 IS
152: BEGIN
153: /*SRW.REFERENCE(OPRNTBLCP)*/NULL;
154: IF (FROM_OPERATION IS NOT NULL OR TO_OPERATION IS NOT NULL) THEN
155: OPRNTBLCP := (',gmd_operations_b fom ');
156: ELSE
157: --OPRNTBLCP := NULL;
158: OPRNTBLCP := ' ';
159: END IF;
511: SELECT
512: OPRN_NO
513: INTO OPERATION
514: FROM
515: GMD_OPERATIONS_B
516: WHERE OPRN_ID = OPRN_ID_V;
517: RETURN (OPERATION);
518: RETURN NULL;
519: EXCEPTION
893: SELECT
894: OPRN_VERS
895: INTO OPRN_VERS
896: FROM
897: GMD_OPERATIONS_B
898: WHERE OPRN_ID = OPRN_ID_V;
899: RETURN (OPRN_VERS);
900: RETURN NULL;
901: EXCEPTION