PACKAGE: APPS.GMI_RIWHM_XMLP_PKG

Source

1 PACKAGE GMI_RIWHM_XMLP_PKG AS
2 /* $Header: RIWHMS.pls 120.0 2007/12/24 13:28:45 nchinnam noship $ */
3   SORT_BY VARCHAR2(12);
4 
5   FROM_WHSE VARCHAR2(4);
6 
7   TO_WHSE VARCHAR2(4);
8 
9   FROM_DESCRIPTION VARCHAR2(40);
10 
11   TO_DESCRIPTION VARCHAR2(40);
12 
13   ORDER1 VARCHAR2(12);
14 
15   P_ORGN VARCHAR2(4);
16 
17   USER_ID NUMBER;
18 
19   NONBLOCKSQL VARCHAR2(3);
20 
21   FROM_CLASS VARCHAR2(8);
22 
23   TO_CLASS VARCHAR2(8);
24 
25   FROM_REGION VARCHAR2(8);
26 
27   TO_REGION VARCHAR2(8);
28 
29   P_CONC_REQUEST_ID NUMBER;
30 
31   LEXPRMCP VARCHAR2(400) := 'whse_code = whse_code';
32 
33   FROM_WHSECP VARCHAR2(4);
34 
35   FROM_DESCRIPTIONCP VARCHAR2(40);
36 
37   TO_WHSECP VARCHAR2(4);
38 
39   TO_DESCRIPTIONCP VARCHAR2(40);
40 
41   FROM_REGIONCP VARCHAR2(8);
42 
43   TO_REGIONCP VARCHAR2(8);
44 
45   FROM_CLASSCP VARCHAR2(8);
46 
47   TO_CLASSCP VARCHAR2(8);
48 
49   FUNCTION LEXPRMCFFORMULA RETURN VARCHAR2;
50 
51   FUNCTION RANGE1FORMULA RETURN VARCHAR2;
52 
53   FUNCTION SORTCFFORMULA RETURN VARCHAR2;
54 
55   FUNCTION LEX_ORDCFFORMULA RETURN VARCHAR2;
56 
57   FUNCTION USERCFFORMULA RETURN VARCHAR2;
58 
59   FUNCTION FROM_WHSECFFORMULA RETURN VARCHAR2;
60 
61   FUNCTION FROM_DESCRIPTIONCFFORMULA RETURN VARCHAR2;
62 
63   FUNCTION TO_WHSECFFORMULA RETURN VARCHAR2;
64 
65   FUNCTION TO_DESCRIPTIONCFFORMULA RETURN VARCHAR2;
66 
67   FUNCTION BEFOREREPORT RETURN BOOLEAN;
68 
69   FUNCTION FROM_REGIONCFFORMULA RETURN CHAR;
70 
71   FUNCTION TO_REGIONCFFORMULA RETURN CHAR;
72 
73   FUNCTION FROM_CLASSCFFORMULA RETURN CHAR;
74 
75   FUNCTION TO_CLASSCFFORMULA RETURN CHAR;
76 
77   FUNCTION AFTERREPORT RETURN BOOLEAN;
78 
79   FUNCTION LEXPRMCP_P RETURN VARCHAR2;
80 
81   FUNCTION FROM_WHSECP_P RETURN VARCHAR2;
82 
83   FUNCTION FROM_DESCRIPTIONCP_P RETURN VARCHAR2;
84 
85   FUNCTION TO_WHSECP_P RETURN VARCHAR2;
86 
87   FUNCTION TO_DESCRIPTIONCP_P RETURN VARCHAR2;
88 
89   FUNCTION FROM_REGIONCP_P RETURN VARCHAR2;
90 
91   FUNCTION TO_REGIONCP_P RETURN VARCHAR2;
92 
93   FUNCTION FROM_CLASSCP_P RETURN VARCHAR2;
94 
95   FUNCTION TO_CLASSCP_P RETURN VARCHAR2;
96 
97 END GMI_RIWHM_XMLP_PKG;
98