PACKAGE: APPS.GMI_RIWIN_XMLP_PKG

Source

1 PACKAGE GMI_RIWIN_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: RIWINS.pls 120.0 2007/12/24 13:29:34 nchinnam noship $ */
3   FROM_WHSE VARCHAR2(4);
4 
5   TO_WHSE VARCHAR2(4);
6 
7   FROM_ITEM VARCHAR2(40);
8 
9   TO_ITEM VARCHAR2(40);
10 
11   P_ORGN VARCHAR2(4);
12 
13   USER_ID NUMBER;
14 
15   NONBLOCKSQL VARCHAR2(3);
16 
17   P_CONC_REQUEST_ID NUMBER;
18 
19   FROM_ITEMCP VARCHAR2(32);
20 
21   TO_ITEMCP VARCHAR2(32);
22 
23   FROM_WHSECP VARCHAR2(4);
24 
25   TO_WHSECP VARCHAR2(4);
26 
27   FUNCTION WHSE_QTYFORMULA(WHSCODE IN VARCHAR2
28                           ,ITEM_ID IN NUMBER) RETURN NUMBER;
29 
30   FUNCTION TOTAL_QTYFORMULA(ITEM_ID IN NUMBER) RETURN NUMBER;
31 
32   FUNCTION WHSE_QTY2FORMULA(WHSCODE IN VARCHAR2
33                            ,ITEM_ID IN NUMBER) RETURN NUMBER;
34 
35   FUNCTION TOTAL_QTY2FORMULA(ITEM_ID IN NUMBER) RETURN NUMBER;
36 
37   FUNCTION CF_RANGEFORMULA RETURN VARCHAR2;
38 
39   FUNCTION USERCFFORMULA RETURN VARCHAR2;
40 
41   FUNCTION FROM_ITEMCFFORMULA RETURN VARCHAR2;
42 
43   FUNCTION TO_ITEMCFFORMULA RETURN VARCHAR2;
44 
45   FUNCTION TO_WHSECFFORMULA RETURN VARCHAR2;
46 
47   FUNCTION FROM_WHSECFFORMULA RETURN VARCHAR2;
48 
49   FUNCTION BEFOREREPORT RETURN BOOLEAN;
50 
51   PROCEDURE HEADER;
52 
53   FUNCTION AFTERREPORT RETURN BOOLEAN;
54 
55   FUNCTION FROM_ITEMCP_P RETURN VARCHAR2;
56 
57   FUNCTION TO_ITEMCP_P RETURN VARCHAR2;
58 
59   FUNCTION FROM_WHSECP_P RETURN VARCHAR2;
60 
61   FUNCTION TO_WHSECP_P RETURN VARCHAR2;
62 
63 END GMI_RIWIN_XMLP_PKG;
64