DBA Data[Home] [Help]

APPS.GMO_DISPENSE_PVT dependencies on GMO_CONSTANTS_GRP

Line 221: P_SHOW_IN_TOLERANCE_DATA VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,

217: P_RESERVED_QUANTITY NUMBER,
218: P_PLAN_QUANTITY NUMBER,
219: P_PLAN_UOM VARCHAR2,
220: P_LOT_NUMBER VARCHAR2,
221: P_SHOW_IN_TOLERANCE_DATA VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,
222: X_DISPENSE_UOM OUT NOCOPY VARCHAR2,
223: X_DISPENSE_CONFIG_ID OUT NOCOPY NUMBER,
224: X_RESERVED_QUANTITY OUT NOCOPY NUMBER,
225: X_PENDING_DISPENSE_QUANTITY OUT NOCOPY NUMBER,

Line 340: IF ( P_SHOW_IN_TOLERANCE_DATA = GMO_CONSTANTS_GRP.NO) THEN

336: END IF;
337: X_MAX_ALLOWED_QUANTITY := greatest( least(X_MAX_ALLOWED_QUANTITY , (X_RESERVED_QUANTITY - L_NET_DISPENSED_QUANTITY)),0);
338: X_MIN_ALLOWED_QUANTITY := greatest(X_MIN_ALLOWED_QUANTITY, 0);
339: -- ER 4575836 : Starts
340: IF ( P_SHOW_IN_TOLERANCE_DATA = GMO_CONSTANTS_GRP.NO) THEN
341: IF (X_MIN_ALLOWED_QUANTITY = 0 OR X_PENDING_DISPENSE_QUANTITY < X_MIN_ALLOWED_QUANTITY) THEN
342: X_PENDING_DISPENSE_QUANTITY := 0;
343: END IF;
344: END IF;

Line 359: P_SHOW_IN_TOLERANCE_DATA VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES

355: P_RESERVATION_UOM VARCHAR2,
356: P_PLAN_QUANTITY NUMBER,
357: P_PLAN_UOM VARCHAR2,
358: P_LOT_NUMBER VARCHAR2,
359: P_SHOW_IN_TOLERANCE_DATA VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES
360: ) RETURN VARCHAR2
361: IS
362: l_DISPENSE_UOM VARCHAR2(10);
363: l_DISPENSE_CONFIG_ID NUMBER;