1 PACKAGE BODY WSH_WSHRDSDL_XMLP_PKG AS
2 /* $Header: WSHRDSDLB.pls 120.2 2007/12/25 07:28:51 nchinnam noship $ */
3 FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4 BEGIN
5 BEGIN
6 P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
7 /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
8 EXCEPTION
9 WHEN /*SRW.USER_EXIT_FAILURE*/OTHERS THEN
10 /*SRW.MESSAGE(1
11 ,'Failed FND SRWINIT.')*/NULL;
12 /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
13 END;
14 BEGIN
15 DECLARE
16 L_REPORT_NAME CHAR(240);
17 BEGIN
18 SELECT
19 CP.USER_CONCURRENT_PROGRAM_NAME
20 INTO L_REPORT_NAME
21 FROM
22 FND_CONCURRENT_PROGRAMS_VL CP,
23 FND_CONCURRENT_REQUESTS CR
24 WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
25 AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
26 AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;
27 REPORT_NAME := L_REPORT_NAME;
28 EXCEPTION
29 WHEN NO_DATA_FOUND THEN
30 REPORT_NAME := 'Shipped Delivery Lines Report';
31 END;
32 IF (P_SHIP_FROM_ORG_ID IS NOT NULL) THEN
33 SELECT
34 ORGANIZATION_NAME
35 INTO REPORT_SHIP_FROM
36 FROM
37 ORG_ORGANIZATION_DEFINITIONS
38 WHERE ORGANIZATION_ID = P_SHIP_FROM_ORG_ID;
39 END IF;
40 IF (P_ORDER_TYPE IS NOT NULL) THEN
41 SELECT
42 SOURCE_TYPE_NAME
43 INTO REPORT_ORDER_TYPE
44 FROM
45 WSH_SOURCE_TYPES_V
46 WHERE SOURCE_TYPE_ID = P_ORDER_TYPE;
47 END IF;
48 IF (P_SHIP_METHOD IS NOT NULL) THEN
49 REPORT_SHIP_METHOD := P_SHIP_METHOD;
50 END IF;
51 IF (P_ITEM IS NOT NULL) THEN
52 REPORT_ITEM := WSH_UTIL_CORE.GET_ITEM_NAME(P_ITEM
53 ,P_SHIP_FROM_ORG_ID);
54 END IF;
55 IF (P_ITEM_DISPLAY IS NOT NULL) THEN
56 SELECT
57 MEANING
58 INTO REPORT_ITEM_DISPLAY
59 FROM
60 WSH_LOOKUPS
61 WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
62 AND LOOKUP_CODE = P_ITEM_DISPLAY;
63 END IF;
64 IF (P_SHIP_DATE_LOW IS NOT NULL) THEN
65 REPORT_SHIP_DATE_FROM := P_SHIP_DATE_LOW;
66 END IF;
67 IF (P_SHIP_DATE_HIGH IS NOT NULL) THEN
68 REPORT_SHIP_DATE_TO := P_SHIP_DATE_HIGH;
69 END IF;
70 IF (P_ORDER_NUMBER_LOW IS NOT NULL) THEN
71 REPORT_ORDER_NUMBER_FROM := P_ORDER_NUMBER_LOW;
72 END IF;
73 IF (P_ORDER_NUMBER_HIGH IS NOT NULL) THEN
74 REPORT_ORDER_NUMBER_TO := P_ORDER_NUMBER_HIGH;
75 END IF;
76 IF (P_DELIVERY_LOW IS NOT NULL) THEN
77 REPORT_DELIVERY_FROM := P_DELIVERY_LOW;
78 END IF;
79 IF (P_DELIVERY_HIGH IS NOT NULL) THEN
80 REPORT_DELIVERY_TO := P_DELIVERY_HIGH;
81 END IF;
82 IF (P_CUSTOMER_NAME_LOW IS NOT NULL) THEN
83 REPORT_CUSTOMER_FROM := P_CUSTOMER_NAME_LOW;
84 END IF;
85 IF (P_CUSTOMER_NAME_HIGH IS NOT NULL) THEN
86 REPORT_CUSTOMER_TO := P_CUSTOMER_NAME_HIGH;
87 END IF;
88 SELECT
89 MEANING
90 INTO REPORT_SORT_BY_1
91 FROM
92 WSH_LOOKUPS
93 WHERE LOOKUP_TYPE = 'WSH_ORDER_BY'
94 AND LOOKUP_CODE = P_ORDER_BY_1;
95 SELECT
96 MEANING
97 INTO REPORT_SORT_BY_2
98 FROM
99 WSH_LOOKUPS
100 WHERE LOOKUP_TYPE = 'WSH_ORDER_BY'
101 AND LOOKUP_CODE = P_ORDER_BY_2;
102 SELECT
103 MEANING
104 INTO REPORT_SORT_BY_3
105 FROM
106 WSH_LOOKUPS
107 WHERE LOOKUP_TYPE = 'WSH_ORDER_BY'
108 AND LOOKUP_CODE = P_ORDER_BY_3;
109 EXCEPTION
110 WHEN OTHERS THEN
111 /*SRW.MESSAGE(1
112 ,'Failed Placeholder Columns Initialization!')*/NULL;
113 /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
114 END;
115 RETURN (TRUE);
116 END BEFOREREPORT;
117 FUNCTION AFTERPFORM RETURN BOOLEAN IS
118 BEGIN
119 DECLARE
120 CURSOR STRUCT_NUM(FLEX_CODE IN VARCHAR2) IS
121 SELECT
122 ID_FLEX_NUM
123 FROM
124 FND_ID_FLEX_STRUCTURES
125 WHERE ID_FLEX_CODE = FLEX_CODE;
126 STRUCT_NUMBER NUMBER;
127 ORDER_BY_1 VARCHAR2(50);
128 ORDER_BY_2 VARCHAR2(50);
129 ORDER_BY_3 VARCHAR2(50);
130 CUSTOMER_LOW VARCHAR2(55);
131 CUSTOMER_HIGH VARCHAR2(55);
132 BEGIN
133 BEGIN
134 /*SRW.REFERENCE(P_DELIVERY_LOW)*/NULL;
135 /*SRW.REFERENCE(P_DELIVERY_HIGH)*/NULL;
136 /*SRW.REFERENCE(P_CUSTOMER_NAME_LOW)*/NULL;
137 /*SRW.REFERENCE(P_CUSTOMER_NAME_HIGH)*/NULL;
138 /*SRW.REFERENCE(P_ORDER_NUMBER_LOW)*/NULL;
139 /*SRW.REFERENCE(P_ORDER_NUMBER_HIGH)*/NULL;
140 /*SRW.REFERENCE(P_SHIP_DATE_LOW)*/NULL;
141 /*SRW.REFERENCE(P_SHIP_DATE_HIGH)*/NULL;
142 /*SRW.REFERENCE(P_ITEM_DISPLAY)*/NULL;
143 /*SRW.REFERENCE(P_ITEM)*/NULL;
144 /*SRW.REFERENCE(P_ORDER_TYPE)*/NULL;
145 /*SRW.REFERENCE(P_SHIP_METHOD)*/NULL;
146 /*SRW.REFERENCE(P_ORDER_BY_1)*/NULL;
147 /*SRW.REFERENCE(P_ORDER_BY_2)*/NULL;
148 /*SRW.REFERENCE(P_ORDER_BY_3)*/NULL;
149 /*SRW.REFERENCE(P_SHIP_FROM_ORG_ID)*/NULL;
150 IF (P_SHIP_FROM_ORG_ID IS NOT NULL) THEN
151 LP_SHIP_FROM_ORG_ID := ' AND WDD.ORGANIZATION_ID = :P_SHIP_FROM_ORG_ID ';
152 END IF;
153 IF (P_ORDER_TYPE IS NOT NULL) THEN
154 LP_ORDER_TYPE := ' AND WDD.SOURCE_HEADER_TYPE_ID = :P_ORDER_TYPE ';
155 END IF;
156 IF (P_SHIP_METHOD IS NOT NULL) THEN
157 LP_SHIP_METHOD := ' AND NVL(WT.SHIP_METHOD_CODE,WDD.SHIP_METHOD_CODE) = :P_SHIP_METHOD ';
158 END IF;
159 IF (P_ITEM IS NOT NULL) THEN
160 LP_ITEM := ' AND WDD.INVENTORY_ITEM_ID = :P_ITEM ';
161 END IF;
162 IF (P_SHIP_DATE_LOW IS NOT NULL AND P_SHIP_DATE_HIGH IS NOT NULL AND P_ORDER_NUMBER_LOW IS NULL AND P_CUSTOMER_NAME_LOW IS NULL) THEN
163 LP_TABLE_NAME := '( select /*+ leading(wts) cardinality(wts,3)*/ * from wsh_trip_stops wts ) WTS';
164 ELSE
165 LP_TABLE_NAME := 'WSH_TRIP_STOPS WTS';
166 END IF;
167 LP_WHERE_CLAUSE := ' AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID ';
168 LP_WHERE_CLAUSE := LP_WHERE_CLAUSE || ' AND WTS.TRIP_ID = WT.TRIP_ID ';
169 LP_WHERE_CLAUSE := LP_WHERE_CLAUSE || ' AND WTS.STOP_LOCATION_ID = WDD.SHIP_FROM_LOCATION_ID ';
170 IF ((P_SHIP_DATE_LOW IS NOT NULL) AND (P_SHIP_DATE_HIGH IS NOT NULL)) THEN
171 LP_SHIP_DATE := ' AND (WTS.ACTUAL_DEPARTURE_DATE BETWEEN FND_DATE.CANONICAL_TO_DATE(:P_SHIP_DATE_LOW) AND FND_DATE.CANONICAL_TO_DATE(:P_SHIP_DATE_HIGH)) ';
172 ELSIF (P_SHIP_DATE_LOW IS NOT NULL) THEN
173 LP_SHIP_DATE := ' AND WTS.ACTUAL_DEPARTURE_DATE >= FND_DATE.CANONICAL_TO_DATE(:P_SHIP_DATE_LOW) ';
174 ELSIF (P_SHIP_DATE_HIGH IS NOT NULL) THEN
175 LP_SHIP_DATE := ' AND WTS.ACTUAL_DEPARTURE_DATE <= FND_DATE.CANONICAL_TO_DATE(:P_SHIP_DATE_HIGH) ';
176 END IF;
177 IF ((P_ORDER_NUMBER_LOW IS NOT NULL) AND (P_ORDER_NUMBER_HIGH IS NOT NULL)) THEN
178 LP_ORDER_NUMBER := ' AND (WDD.SOURCE_HEADER_NUMBER BETWEEN :P_ORDER_NUMBER_LOW AND :P_ORDER_NUMBER_HIGH) ';
179 ELSIF (P_ORDER_NUMBER_LOW IS NOT NULL) THEN
180 LP_ORDER_NUMBER := ' AND WDD.SOURCE_HEADER_NUMBER >= :P_ORDER_NUMBER_LOW ';
181 ELSIF (P_ORDER_NUMBER_HIGH IS NOT NULL) THEN
182 LP_ORDER_NUMBER := ' AND WDD.SOURCE_HEADER_NUMBER <= :P_ORDER_NUMBER_HIGH ';
183 END IF;
184 IF ((P_DELIVERY_LOW IS NOT NULL) AND (P_DELIVERY_HIGH IS NOT NULL)) THEN
185 LP_DELIVERY := ' AND (WND.NAME BETWEEN :P_DELIVERY_LOW AND :P_DELIVERY_HIGH) ';
186 ELSIF (P_DELIVERY_LOW IS NOT NULL) THEN
187 LP_DELIVERY := ' AND WND.NAME >= :P_DELIVERY_LOW ';
188 ELSIF (P_DELIVERY_HIGH IS NOT NULL) THEN
189 LP_DELIVERY := ' AND WND.NAME <= :P_DELIVERY_HIGH ';
190 END IF;
191 IF (P_CUSTOMER_NAME_LOW IS NOT NULL) THEN
192 SELECT
193 SUBSTRB(PARTY.PARTY_NAME
194 ,1
195 ,50)
196 INTO CUSTOMER_LOW
197 FROM
198 HZ_PARTIES PARTY
199 WHERE PARTY.PARTY_ID = (
200 SELECT
201 CUST_ACCT.PARTY_ID
202 FROM
203 HZ_CUST_ACCOUNTS CUST_ACCT
204 WHERE CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER_NAME_LOW );
205 END IF;
206 IF (P_CUSTOMER_NAME_HIGH IS NOT NULL) THEN
207 SELECT
208 SUBSTRB(PARTY.PARTY_NAME
209 ,1
210 ,50)
211 INTO CUSTOMER_HIGH
212 FROM
213 HZ_PARTIES PARTY
214 WHERE PARTY.PARTY_ID = (
215 SELECT
216 CUST_ACCT.PARTY_ID
217 FROM
218 HZ_CUST_ACCOUNTS CUST_ACCT
219 WHERE CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER_NAME_HIGH );
220 END IF;
221 IF ((P_CUSTOMER_NAME_LOW IS NOT NULL) AND (P_CUSTOMER_NAME_HIGH IS NOT NULL)) THEN
222 IF (P_CUSTOMER_NAME_LOW = P_CUSTOMER_NAME_HIGH) THEN
223 LP_CUSTOMER_NAME := ' AND SUBSTRB(PARTY.PARTY_NAME,1,50) = ''' || CUSTOMER_LOW || ''' ';
224 ELSE
225 LP_CUSTOMER_NAME := ' AND (SUBSTRB(PARTY.PARTY_NAME,1,50) BETWEEN ''' || CUSTOMER_LOW || ''' AND ''' || CUSTOMER_HIGH || ''') ';
226 END IF;
227 ELSIF (P_CUSTOMER_NAME_LOW IS NOT NULL) THEN
228 LP_CUSTOMER_NAME := ' AND SUBSTRB(PARTY.PARTY_NAME,1,50) >= ''' || CUSTOMER_LOW || ''' ';
229 ELSIF (P_CUSTOMER_NAME_HIGH IS NOT NULL) THEN
230 LP_CUSTOMER_NAME := ' AND SUBSTRB(PARTY.PARTY_NAME,1,50) <= ''' || CUSTOMER_HIGH || ''' ';
231 END IF;
232 OPEN STRUCT_NUM(P_ITEM_FLEX_CODE);
233 FETCH STRUCT_NUM
234 INTO STRUCT_NUMBER;
235 CLOSE STRUCT_NUM;
236 LP_STRUCTURE_NUM := STRUCT_NUMBER;
237 IF P_ORDER_BY_1 = 'CUSTOMER' THEN
238 ORDER_BY_1 := ' SUBSTRB(PARTY.PARTY_NAME,1,50) ';
239 ELSIF P_ORDER_BY_1 = 'SHIP_METHOD' THEN
240 ORDER_BY_1 := 'SHIP_METHOD';
241 ELSIF P_ORDER_BY_1 = 'ITEM' THEN
242 IF P_ITEM_DISPLAY = 'D' THEN
243 ORDER_BY_1 := 'lower(WDD.ITEM_DESCRIPTION)';
244 ELSE
245 ORDER_BY_1 := 'lower(ITEM_SEG)';
246 END IF;
247 ELSIF P_ORDER_BY_1 = 'SHIP_DATE' THEN
248 ORDER_BY_1 := 'WTS.ACTUAL_DEPARTURE_DATE';
249 ELSIF P_ORDER_BY_1 = 'DELIVERY' THEN
250 ORDER_BY_1 := 'WND.NAME';
251 END IF;
252 IF P_ORDER_BY_2 = 'CUSTOMER' THEN
253 ORDER_BY_2 := ' SUBSTRB(PARTY.PARTY_NAME,1,50) ';
254 ELSIF P_ORDER_BY_2 = 'SHIP_METHOD' THEN
255 ORDER_BY_2 := 'SHIP_METHOD';
256 ELSIF P_ORDER_BY_2 = 'ITEM' THEN
257 IF P_ITEM_DISPLAY = 'D' THEN
258 ORDER_BY_2 := 'lower(WDD.ITEM_DESCRIPTION)';
259 ELSE
260 ORDER_BY_2 := 'lower(ITEM_SEG)';
261 END IF;
262 ELSIF P_ORDER_BY_2 = 'SHIP_DATE' THEN
263 ORDER_BY_2 := 'WTS.ACTUAL_DEPARTURE_DATE';
264 ELSIF P_ORDER_BY_2 = 'DELIVERY' THEN
265 ORDER_BY_2 := 'WND.NAME';
266 END IF;
267 IF P_ORDER_BY_3 = 'CUSTOMER' THEN
268 ORDER_BY_3 := ' SUBSTRB(PARTY.PARTY_NAME,1,50) ';
269 ELSIF P_ORDER_BY_3 = 'SHIP_METHOD' THEN
270 ORDER_BY_3 := 'SHIP_METHOD';
271 ELSIF P_ORDER_BY_3 = 'ITEM' THEN
272 IF P_ITEM_DISPLAY = 'D' THEN
273 ORDER_BY_3 := 'lower(WDD.ITEM_DESCRIPTION)';
274 ELSE
275 ORDER_BY_3 := 'lower(ITEM_SEG)';
276 END IF;
277 ELSIF P_ORDER_BY_3 = 'SHIP_DATE' THEN
278 ORDER_BY_3 := 'WTS.ACTUAL_DEPARTURE_DATE';
279 ELSIF P_ORDER_BY_3 = 'DELIVERY' THEN
280 ORDER_BY_3 := 'WND.NAME';
281 END IF;
282 LP_ORDER_BY := ORDER_BY_1 || ',' || ORDER_BY_2 || ',' || ORDER_BY_3;
283 EXCEPTION
284 WHEN /*SRW.USER_EXIT_FAILURE*/OTHERS THEN
285 /*SRW.MESSAGE(2000
286 ,'Failed in AFTER FORM trigger. FND FLEXSQL USER_EXIT')*/NULL;
287 /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
288 END;
289 END;
290 RETURN (TRUE);
291 END AFTERPFORM;
292 FUNCTION AFTERREPORT RETURN BOOLEAN IS
293 BEGIN
294 BEGIN
295 /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;
296 EXCEPTION
297 WHEN /*SRW.USER_EXIT_FAILURE*/OTHERS THEN
298 /*SRW.MESSAGE(1
299 ,'Failed in SRWEXIT')*/NULL;
300 RAISE;
301 END;
302 RETURN (TRUE);
303 END AFTERREPORT;
304 FUNCTION CF_RELEASED_QUANTITYFORMULA(DELIVERY_LINE IN NUMBER
305 ,SOURCE_HEADER_ID IN NUMBER) RETURN NUMBER IS
306 BEGIN
307 DECLARE
308 CURSOR C_REQUESTED_QTY(P_DETAIL_ID IN NUMBER,P_SOURCE_HEADER_ID IN NUMBER) IS
309 SELECT
310 SUM(NVL(PICKED_QUANTITY
311 ,0))
312 FROM
313 WSH_DELIVERY_DETAILS
314 START WITH DELIVERY_DETAIL_ID = P_DETAIL_ID
315 CONNECT BY prior DELIVERY_DETAIL_ID = SPLIT_FROM_DELIVERY_DETAIL_ID
316 AND SOURCE_HEADER_ID = P_SOURCE_HEADER_ID
317 AND RELEASED_STATUS = 'Y';
318 L_REQUESTED_QTY NUMBER := NULL;
319 BEGIN
320 OPEN C_REQUESTED_QTY(DELIVERY_LINE,SOURCE_HEADER_ID);
321 FETCH C_REQUESTED_QTY
322 INTO L_REQUESTED_QTY;
323 CLOSE C_REQUESTED_QTY;
324 RETURN L_REQUESTED_QTY;
325 END;
326 END CF_RELEASED_QUANTITYFORMULA;
327 FUNCTION CF_ITEM_DISPLAYFORMULA(INVENTORY_ITEM_ID IN NUMBER
328 ,SHIP_FROM_ORGANIZATION IN NUMBER) RETURN VARCHAR2 IS
329 BEGIN
330 DECLARE
331 CURSOR INVENTORY_LABEL(ID IN NUMBER,ORG_ID IN NUMBER) IS
332 SELECT
333 DESCRIPTION
334 FROM
335 MTL_SYSTEM_ITEMS_VL
336 WHERE INVENTORY_ITEM_ID = ID
337 AND ORGANIZATION_ID = ORG_ID;
338 NAME VARCHAR2(800);
339 BEGIN
340 IF P_ITEM_DISPLAY = 'D' THEN
341 OPEN INVENTORY_LABEL(INVENTORY_ITEM_ID,SHIP_FROM_ORGANIZATION);
342 FETCH INVENTORY_LABEL
343 INTO NAME;
344 CLOSE INVENTORY_LABEL;
345 ELSIF P_ITEM_DISPLAY = 'F' THEN
346 NAME := WSH_UTIL_CORE.GET_ITEM_NAME(INVENTORY_ITEM_ID
347 ,SHIP_FROM_ORGANIZATION
348 ,P_ITEM_FLEX_CODE
349 ,LP_STRUCTURE_NUM);
350 ELSE
351 OPEN INVENTORY_LABEL(INVENTORY_ITEM_ID,SHIP_FROM_ORGANIZATION);
352 FETCH INVENTORY_LABEL
353 INTO NAME;
354 CLOSE INVENTORY_LABEL;
355 NAME := WSH_UTIL_CORE.GET_ITEM_NAME(INVENTORY_ITEM_ID
356 ,SHIP_FROM_ORGANIZATION
357 ,P_ITEM_FLEX_CODE
358 ,LP_STRUCTURE_NUM) || ' ' || NAME;
359 END IF;
360 RETURN NAME;
361 END;
362 RETURN NULL;
363 END CF_ITEM_DISPLAYFORMULA;
364 FUNCTION CF_SHIP_FROM_ORGANIZATION_NAME(SHIP_FROM_ORGANIZATION IN NUMBER) RETURN CHAR IS
365 BEGIN
366 DECLARE
367 ORG_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
368 BEGIN
369 SELECT
370 ORGANIZATION_NAME
371 INTO ORG_NAME
372 FROM
373 ORG_ORGANIZATION_DEFINITIONS
374 WHERE ORGANIZATION_ID = SHIP_FROM_ORGANIZATION;
375 RETURN ORG_NAME;
376 EXCEPTION
377 WHEN OTHERS THEN
378 /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
379 END;
380 END CF_SHIP_FROM_ORGANIZATION_NAME;
381 FUNCTION CF_SHIP_DATEFORMULA(STOP_ID_1 IN NUMBER) RETURN VARCHAR2 IS
382 CURSOR C_DEP_DATE IS
383 SELECT
384 TO_CHAR(ACTUAL_DEPARTURE_DATE
385 ,'DD-MON-RRRR')
386 FROM
387 WSH_TRIP_STOPS WTS
388 WHERE WTS.STOP_ID = STOP_ID_1;
389 L_DEP_DATE VARCHAR2(20);
390 BEGIN
391 OPEN C_DEP_DATE;
392 FETCH C_DEP_DATE
393 INTO L_DEP_DATE;
394 CLOSE C_DEP_DATE;
395 RETURN L_DEP_DATE;
396 END CF_SHIP_DATEFORMULA;
397 FUNCTION REPORT_SORT_BY_1_P RETURN VARCHAR2 IS
398 BEGIN
399 RETURN REPORT_SORT_BY_1;
400 END REPORT_SORT_BY_1_P;
401 FUNCTION REPORT_SORT_BY_2_P RETURN VARCHAR2 IS
402 BEGIN
403 RETURN REPORT_SORT_BY_2;
404 END REPORT_SORT_BY_2_P;
405 FUNCTION REPORT_SORT_BY_3_P RETURN VARCHAR2 IS
406 BEGIN
407 RETURN REPORT_SORT_BY_3;
408 END REPORT_SORT_BY_3_P;
409 FUNCTION REPORT_SHIP_FROM_P RETURN VARCHAR2 IS
410 BEGIN
411 RETURN REPORT_SHIP_FROM;
412 END REPORT_SHIP_FROM_P;
413 FUNCTION REPORT_ITEM_DISPLAY_P RETURN VARCHAR2 IS
414 BEGIN
415 RETURN REPORT_ITEM_DISPLAY;
416 END REPORT_ITEM_DISPLAY_P;
417 FUNCTION REPORT_ITEM_P RETURN VARCHAR2 IS
418 BEGIN
419 RETURN REPORT_ITEM;
420 END REPORT_ITEM_P;
421 FUNCTION REPORT_SHIP_METHOD_P RETURN VARCHAR2 IS
422 BEGIN
423 RETURN REPORT_SHIP_METHOD;
424 END REPORT_SHIP_METHOD_P;
425 FUNCTION REPORT_ORDER_TYPE_P RETURN VARCHAR2 IS
426 BEGIN
427 RETURN REPORT_ORDER_TYPE;
428 END REPORT_ORDER_TYPE_P;
429 FUNCTION REPORT_DELIVERY_FROM_P RETURN VARCHAR2 IS
430 BEGIN
431 RETURN REPORT_DELIVERY_FROM;
432 END REPORT_DELIVERY_FROM_P;
433 FUNCTION REPORT_DELIVERY_TO_P RETURN VARCHAR2 IS
434 BEGIN
435 RETURN REPORT_DELIVERY_TO;
436 END REPORT_DELIVERY_TO_P;
437 FUNCTION REPORT_ORDER_NUMBER_FROM_P RETURN VARCHAR2 IS
438 BEGIN
439 RETURN REPORT_ORDER_NUMBER_FROM;
440 END REPORT_ORDER_NUMBER_FROM_P;
441 FUNCTION REPORT_ORDER_NUMBER_TO_P RETURN VARCHAR2 IS
442 BEGIN
443 RETURN REPORT_ORDER_NUMBER_TO;
444 END REPORT_ORDER_NUMBER_TO_P;
445 FUNCTION REPORT_CUSTOMER_FROM_P RETURN VARCHAR2 IS
446 BEGIN
447 RETURN REPORT_CUSTOMER_FROM;
448 END REPORT_CUSTOMER_FROM_P;
449 FUNCTION REPORT_CUSTOMER_TO_P RETURN VARCHAR2 IS
450 BEGIN
451 RETURN REPORT_CUSTOMER_TO;
452 END REPORT_CUSTOMER_TO_P;
453 FUNCTION REPORT_SHIP_DATE_FROM_P RETURN VARCHAR2 IS
454 BEGIN
455 RETURN REPORT_SHIP_DATE_FROM;
456 END REPORT_SHIP_DATE_FROM_P;
457 FUNCTION REPORT_SHIP_DATE_TO_P RETURN VARCHAR2 IS
458 BEGIN
459 RETURN REPORT_SHIP_DATE_TO;
460 END REPORT_SHIP_DATE_TO_P;
461 FUNCTION REPORT_NAME_P RETURN VARCHAR2 IS
462 BEGIN
463 RETURN REPORT_NAME;
464 END REPORT_NAME_P;
465 END WSH_WSHRDSDL_XMLP_PKG;
466