52: OPEN WAREHOUSE_NAME;
53: FETCH WAREHOUSE_NAME
54: INTO CP_WAREHOUSE_NAME;
55: CLOSE WAREHOUSE_NAME;
56: CP_EXCEPTION_LOCATION_NAME := WSH_UTIL_CORE.GET_LOCATION_DESCRIPTION(P_EXCEPTION_LOCATION_ID
57: ,'NEW UI CODE');
58: CP_SHIP_FROM_LOCATION_NAME := WSH_UTIL_CORE.GET_LOCATION_DESCRIPTION(P_LOGGED_LOCATION_ID
59: ,'NEW UI CODE');
60: END;
54: INTO CP_WAREHOUSE_NAME;
55: CLOSE WAREHOUSE_NAME;
56: CP_EXCEPTION_LOCATION_NAME := WSH_UTIL_CORE.GET_LOCATION_DESCRIPTION(P_EXCEPTION_LOCATION_ID
57: ,'NEW UI CODE');
58: CP_SHIP_FROM_LOCATION_NAME := WSH_UTIL_CORE.GET_LOCATION_DESCRIPTION(P_LOGGED_LOCATION_ID
59: ,'NEW UI CODE');
60: END;
61: RETURN (TRUE);
62: END BEFOREREPORT;
331: FUNCTION C_LOGGED_LOCATIONFORMULA(LOGGED_AT_LOCATION_ID IN NUMBER) RETURN CHAR IS
332: L_LOGGED_LOCATION VARCHAR2(121);
333: BEGIN
334: IF LOGGED_AT_LOCATION_ID IS NOT NULL THEN
335: L_LOGGED_LOCATION := WSH_UTIL_CORE.GET_LOCATION_DESCRIPTION(LOGGED_AT_LOCATION_ID
336: ,'NEW UI CODE');
337: RETURN (L_LOGGED_LOCATION);
338: ELSE
339: RETURN (NULL);
343: FUNCTION C_EXCEPTION_LOCATIONFORMULA(EXCEPTION_LOCATION_ID IN NUMBER) RETURN CHAR IS
344: L_EXCEPTION_LOCATION VARCHAR2(121);
345: BEGIN
346: IF EXCEPTION_LOCATION_ID IS NOT NULL THEN
347: L_EXCEPTION_LOCATION := WSH_UTIL_CORE.GET_LOCATION_DESCRIPTION(EXCEPTION_LOCATION_ID
348: ,'NEW UI CODE');
349: RETURN (L_EXCEPTION_LOCATION);
350: ELSE
351: RETURN (NULL);