PACKAGE: APPS.GMI_RILOC_XMLP_PKG

Source

1 PACKAGE GMI_RILOC_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: RILOCS.pls 120.0 2007/12/24 13:26:50 nchinnam noship $ */
3   FROM_WHSE VARCHAR2(4);
4 
5   TO_WHSE VARCHAR2(4);
6 
7   FROM_LOCATION VARCHAR2(16);
8 
9   TO_LOCATION VARCHAR2(16);
10 
11   SORT_BY VARCHAR2(8);
12 
13   ORDER1 VARCHAR2(10);
14 
15   SELECT_CRITERIA VARCHAR2(40);
16 
17   P_ORGN VARCHAR2(4);
18 
19   USER_ID NUMBER;
20 
21   NONBLOCKSQL VARCHAR2(3);
22 
23   P_CONC_REQUEST_ID NUMBER;
24 
25   LEXPRMCP VARCHAR2(400) := 'whse_code >= ''0'' and whse_code <= ''zzzz''';
26 
27   FROM_LOCATIONCP VARCHAR2(16);
28 
29   TO_LOCATIONCP VARCHAR2(16);
30 
31   FROM_WHSECP VARCHAR2(4);
32 
33   TO_WHSECP VARCHAR2(4);
34 
35   FUNCTION LEXPRMCFFORMULA RETURN VARCHAR2;
36 
37   FUNCTION LEXORDCFFORMULA RETURN VARCHAR2;
38 
39   FUNCTION USERCFFORMULA RETURN VARCHAR2;
40 
41   FUNCTION RANGE1CFFORMULA RETURN VARCHAR2;
42 
43   FUNCTION FROM_LOCATIONCFFORMULA RETURN VARCHAR2;
44 
45   FUNCTION TO_LOCATIONCFFORMULA RETURN VARCHAR2;
46 
47   FUNCTION FROM_WHSECFFORMULA RETURN VARCHAR2;
48 
49   FUNCTION TO_WHSECFFORMULA RETURN VARCHAR2;
50 
51   FUNCTION BEFOREREPORT RETURN BOOLEAN;
52 
53   PROCEDURE HEADER;
54 
55   FUNCTION AFTERREPORT RETURN BOOLEAN;
56 
57   FUNCTION LEXPRMCP_P RETURN VARCHAR2;
58 
59   FUNCTION FROM_LOCATIONCP_P RETURN VARCHAR2;
60 
61   FUNCTION TO_LOCATIONCP_P RETURN VARCHAR2;
62 
63   FUNCTION FROM_WHSECP_P RETURN VARCHAR2;
64 
65   FUNCTION TO_WHSECP_P RETURN VARCHAR2;
66 
67 END GMI_RILOC_XMLP_PKG;
68