[Home] [Help]
320: RETURN (TRUE);
321: END BEFOREPFORM;
322:
323: FUNCTION CF_SHIPMENT_PRIORITYFORMULA(SHIPPRI IN VARCHAR2) RETURN CHAR IS
324: L_MEANING OE_LOOKUPS.MEANING%TYPE;
325: BEGIN
326: IF (SHIPPRI IS NOT NULL AND SHIPPRI <> 'Mixed') THEN
327: SELECT
328: MEANING
327: SELECT
328: MEANING
329: INTO L_MEANING
330: FROM
331: OE_LOOKUPS
332: WHERE LOOKUP_TYPE = 'SHIPMENT_PRIORITY'
333: AND LOOKUP_CODE = SHIPPRI;
334: RETURN L_MEANING;
335: ELSE