eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.WMS_WMSCPTYR_XMLP_PKG

Source


1 PACKAGE WMS_WMSCPTYR_XMLP_PKG AS
2 /* $Header: WMSCPTYRS.pls 120.3 2007/12/25 07:59:05 nchinnam noship $ */
3   P_CONC_REQUEST_ID NUMBER;
4 
5   P_APPLICATION VARCHAR2(100);
6 
7   P_RESPONSIBILITY VARCHAR2(100);
8 
9   P_REQUEST_DATE DATE;
10 
11   P_ACTUAL_START_DATE DATE;
12 
13   P_REPORT_NAME VARCHAR2(1000);
14 
15   P_PRINTER VARCHAR2(100);
16 
17   P_SAVE_OUTPUT_FLAG VARCHAR2(32767);
18 
19   P_LOCATOR_FLEX_ALL VARCHAR2(100);
20 
21   LP_WHERE_CLAUSE VARCHAR2(1000);
22 
23   P_SUB_UNITS_UOM_CODE VARCHAR2(40);
24 
25   P_SUB_WT_UOM_CODE VARCHAR2(40);
26 
27   P_SUB_VOL_UOM_CODE VARCHAR2(40);
28 
29   P_ORG_CODE VARCHAR2(32767);
30 
31   P_ORG_ID NUMBER;
32 
33   P_ORG_NAME VARCHAR2(100);
34 
35   P_SUBINVENTORY VARCHAR2(100);
36 
37   P_LOCATOR_ID NUMBER;
38 
39   P_DETAIL_LEVEL NUMBER;
40 
41   P_UTIL_BY_WEIGHT NUMBER;
42 
43   P_WT_OPERATOR VARCHAR2(32767);
44 
45   P_UTIL_BY_VOLUME NUMBER;
46 
47   P_VOL_OPERATOR VARCHAR2(32767);
48 
49   P_UTIL_BY_UNIT NUMBER;
50 
51   P_UNITS_OPERATOR VARCHAR2(32767);
52 
53   P_ORDER_BY NUMBER;
54 
55   LP_ORDER_BY VARCHAR2(1000);
56 
57   P_ORDER_BY_MEANING VARCHAR2(200);
58 
59   P_DETAIL_MEANING VARCHAR2(200);
60 
61   P_NON_CONV_STK NUMBER;
62 
63   P_MESSAGE VARCHAR2(4000);
64 
65   P_VALUE_YES VARCHAR2(32767);
66 
67   P_VALUE_NO VARCHAR2(32767);
68 
69   P_VALUE_NA VARCHAR2(32767);
70 
71   P_NON_CONV_STOCK VARCHAR2(32767);
72   LP_NON_CONV_STOCK VARCHAR2(32767);
73 
74   CP_UNITS_PER NUMBER;
75 
76   CP_WEIGHT_PER VARCHAR2(20);
77 
78   CP_VOLUME_PER VARCHAR2(20);
79 
80   CP_COUNT NUMBER;
81 
82   CP_DISPLAY_SUB NUMBER;
83 
84   CP_SUB_LOOSE_QTY NUMBER;
85 
86   CP_SUB_PACKED_QTY NUMBER;
87 
88   CP_SUB_TOTAL_QTY NUMBER;
89 
90   CP_SUB_WEIGHT NUMBER;
91 
92   CP_SUB_VOLUME NUMBER;
93 
94   CP_SUB_WT NUMBER;
95 
96   CP_SUB_VOL NUMBER;
97 
98   CP_MAX_SUB_WT NUMBER;
99 
100   CP_MAX_SUB_VOL NUMBER;
101 
102   CP_WT_PER VARCHAR2(20);
103 
104   CP_VOL_PER VARCHAR2(20);
105 
106   CP_DISPLAY_LOC NUMBER;
107 
108   CP_LOC_LOOSE_QTY NUMBER;
109 
110   CP_LOC_PACKED_QTY NUMBER;
111 
112   CP_UNITS NUMBER;
113 
114   CP_MAX_SUB_UNITS NUMBER;
115 
116   CP_LOC_TOTAL_QTY NUMBER;
117 
118   CP_LOC_WT_PER NUMBER;
119 
120   CP_LOC_VOL_PER NUMBER;
121 
122   CP_LOC_UNITS_PER NUMBER;
123 
124   CP_AVG_LOOSE_QTY NUMBER;
125 
126   CP_AVG_PACKED_QTY NUMBER;
127 
128   CP_AVG_TOTAL_QTY NUMBER;
129 
130   CP_AVG_WEIGHT NUMBER;
131 
132   CP_AVG_VOLUME NUMBER;
133 
134   CP_WEIGHT_C NUMBER;
135 
136   CP_LOC_WEIGHT_C NUMBER;
137 
138   CP_VOLUME_C NUMBER;
139 
140   CP_LOC_LOOSE_QTY_C NUMBER;
141 
142   CP_PACKED_QTY_C NUMBER;
143 
144   CP_LOC_PACKED_QTY_C NUMBER;
145 
146   CP_LOC_VOLUME_C NUMBER;
147 
148   CP_TOTAL_QTY_C NUMBER;
149 
150   CP_LOOSE_QTY_C NUMBER;
151 
152   CP_LOC_TOTAL_QTY_C NUMBER;
153 
154   FUNCTION CF_LOC_FLEX_FIELDFORMULA(LOCATOR_ID IN NUMBER
155                                    ,ORGANIZATION_ID IN NUMBER) RETURN CHAR;
156 
157   FUNCTION BEFOREREPORT RETURN BOOLEAN;
158 
159   FUNCTION AFTERPFORM RETURN BOOLEAN;
160 
161   FUNCTION AFTERREPORT RETURN BOOLEAN;
162 
163   FUNCTION CF_LOC_CAPACITYFORMULA(ORGANIZATION_ID IN NUMBER
164                                  ,LOCATOR_ID IN NUMBER
165                                  ,LOOSE_QTY IN NUMBER
166                                  ,PACKED_QTY IN NUMBER
167                                  ,TOTAL_QTY IN NUMBER
168                                  ,SUBINVENTORY_CODE1 IN VARCHAR2) RETURN NUMBER;
169 
170   FUNCTION CHECK_WEIGHT_PERCENT(CS_WEIGHT IN NUMBER) RETURN BOOLEAN;
171 
172   FUNCTION CHECK_VOL_PERCENT(CS_VOLUME IN NUMBER) RETURN BOOLEAN;
173 
174   PROCEDURE INITIALIZE_VALUES;
175 
176   FUNCTION CHECK_UNITS_PERCENT(CS_UNITS IN NUMBER) RETURN BOOLEAN;
177 
178   FUNCTION CF_1FORMULA(LOC IN NUMBER
179                       ,ORG_ID IN NUMBER) RETURN CHAR;
180 
181   FUNCTION CF_CALC_COUNTERSFORMULA(CS_WEIGHT IN NUMBER
182                                   ,CS_VOLUME IN NUMBER
183                                   ,CS_UNITS IN NUMBER
184                                   ,CS_MAX_SUB_WT IN NUMBER
185                                   ,CS_SUB_WT_PER IN NUMBER
186                                   ,CS_MAX_SUB_VOL IN NUMBER
187                                   ,CS_SUB_VOL_PER IN NUMBER
188                                   ,CS_SUB_UNITS_PER IN NUMBER
189                                   ,CS_MAX_SUB_UNITS IN NUMBER
190                                   ,CS_LOOSE_QTY IN NUMBER
191                                   ,CS_PACKED_QTY IN NUMBER
192                                   ,CS_TOTAL_QTY IN NUMBER
193                                   ,CS_NUM_LOCS IN NUMBER) RETURN NUMBER;
194 
195   FUNCTION CF_CALC_AVGSFORMULA(CS_TOTAL_LOOSE_QTY IN NUMBER
196                               ,CS_TOTAL_PACKED_QTY IN NUMBER
197                               ,CS_TOTAL_TOTAL_QTY IN NUMBER
198                               ,CS_TOTAL_WEIGHT IN NUMBER
199                               ,CS_TOTAL_VOLUME IN NUMBER) RETURN NUMBER;
200 
201   FUNCTION CP_UNITS_PER_P RETURN NUMBER;
202 
203   FUNCTION CP_WEIGHT_PER_P RETURN VARCHAR2;
204 
205   FUNCTION CP_VOLUME_PER_P RETURN VARCHAR2;
206 
207   FUNCTION CP_COUNT_P RETURN NUMBER;
208 
209   FUNCTION CP_DISPLAY_SUB_P RETURN NUMBER;
210 
211   FUNCTION CP_SUB_LOOSE_QTY_P RETURN NUMBER;
212 
213   FUNCTION CP_SUB_PACKED_QTY_P RETURN NUMBER;
214 
215   FUNCTION CP_SUB_TOTAL_QTY_P RETURN NUMBER;
216 
217   FUNCTION CP_SUB_WEIGHT_P RETURN NUMBER;
218 
219   FUNCTION CP_SUB_VOLUME_P RETURN NUMBER;
220 
221   FUNCTION CP_SUB_WT_P RETURN NUMBER;
222 
223   FUNCTION CP_SUB_VOL_P RETURN NUMBER;
224 
225   FUNCTION CP_MAX_SUB_WT_P RETURN NUMBER;
226 
227   FUNCTION CP_MAX_SUB_VOL_P RETURN NUMBER;
228 
229   FUNCTION CP_WT_PER_P RETURN VARCHAR2;
230 
231   FUNCTION CP_VOL_PER_P RETURN VARCHAR2;
232 
233   FUNCTION CP_DISPLAY_LOC_P RETURN NUMBER;
234 
235   FUNCTION CP_LOC_LOOSE_QTY_P RETURN NUMBER;
236 
237   FUNCTION CP_LOC_PACKED_QTY_P RETURN NUMBER;
238 
239   FUNCTION CP_UNITS_P RETURN NUMBER;
240 
241   FUNCTION CP_MAX_SUB_UNITS_P RETURN NUMBER;
242 
243   FUNCTION CP_LOC_TOTAL_QTY_P RETURN NUMBER;
244 
245   FUNCTION CP_LOC_WT_PER_P RETURN NUMBER;
246 
247   FUNCTION CP_LOC_VOL_PER_P RETURN NUMBER;
248 
249   FUNCTION CP_LOC_UNITS_PER_P RETURN NUMBER;
250 
251   FUNCTION CP_AVG_LOOSE_QTY_P RETURN NUMBER;
252 
253   FUNCTION CP_AVG_PACKED_QTY_P RETURN NUMBER;
254 
255   FUNCTION CP_AVG_TOTAL_QTY_P RETURN NUMBER;
256 
257   FUNCTION CP_AVG_WEIGHT_P RETURN NUMBER;
258 
259   FUNCTION CP_AVG_VOLUME_P RETURN NUMBER;
260 
261   FUNCTION CP_WEIGHT_C_P RETURN NUMBER;
262 
263   FUNCTION CP_LOC_WEIGHT_C_P RETURN NUMBER;
264 
265   FUNCTION CP_VOLUME_C_P RETURN NUMBER;
266 
267   FUNCTION CP_LOC_LOOSE_QTY_C_P RETURN NUMBER;
268 
269   FUNCTION CP_PACKED_QTY_C_P RETURN NUMBER;
270 
271   FUNCTION CP_LOC_PACKED_QTY_C_P RETURN NUMBER;
272 
273   FUNCTION CP_LOC_VOLUME_C_P RETURN NUMBER;
274 
275   FUNCTION CP_TOTAL_QTY_C_P RETURN NUMBER;
276 
277   FUNCTION CP_LOOSE_QTY_C_P RETURN NUMBER;
278 
279   FUNCTION CP_LOC_TOTAL_QTY_C_P RETURN NUMBER;
280 
281 END WMS_WMSCPTYR_XMLP_PKG;
282