1 PACKAGE wma_special_lovs AUTHID CURRENT_USER AS
2 /* $Header: wmaslovs.pls 115.4 2002/11/14 23:20:21 jyeung ship $ */
3
4 TYPE LovCurType is REF CURSOR;
5
6 /**
7 * This procedure is used by SubinvLovBean as the lov statement. The OUT param
8 * is a ref cursor which contains all the subinv that are valid for the given
9 * item.
10 */
11 PROCEDURE getSubinventories(
12 subinventories OUT NOCOPY LovCurType,
13 orgID IN NUMBER,
14 itemID IN NUMBER,
15 trxTypeID IN NUMBER,
16 invName IN VARCHAR2);
17
18 /**
19 * This function is used by the LocatorLovBean. It returns a interger with 1 being
20 * locator controlled and 2 as not. The ideal is to return a boolean instead of
21 * number. But it seems that Callable statment can't set the type to TYPE.BIT
22 */
23 FUNCTION locatorControl(
24 orgID IN NUMBER,
25 subinv IN VARCHAR2,
26 itemID IN NUMBER) RETURN NUMBER;
27
28 /**
29 * This procedure is used by the LocatorLovBean as the lov statement. The OUT param
30 * is a ref cursor which contains all the valid locators for the given item.
31 */
32 PROCEDURE getLocators(
33 locators OUT NOCOPY LovCurType,
34 orgID IN NUMBER,
35 subinv IN VARCHAR2,
36 itemID IN NUMBER,
37 trxTypeID IN NUMBER,
38 locName IN VARCHAR2);
39
40 END wma_special_lovs;