PACKAGE: APPS.WSH_WSHRDOPN_XMLP_PKG

Source

1 PACKAGE WSH_WSHRDOPN_XMLP_PKG AS
2 /* $Header: WSHRDOPNS.pls 120.2 2007/12/25 07:26:52 nchinnam noship $ */
3   P_ORGANIZATION_ID NUMBER;
4 
5   P_SHIP_TO VARCHAR2(32767);
6 
7   P_CUSTOMER_ID NUMBER;
8 
9   P_SHIP_METHOD_CODE VARCHAR2(80);
10 
11   P_ITEM_DISPLAY VARCHAR2(32767);
12 
13   P_ITEM_ID NUMBER;
14 
15   P_BATCH_NUMBER VARCHAR2(30);
16 
17   P_FROM_CREATION_DATE DATE;
18 
19   P_TO_CREATION_DATE DATE;
20 
21   F_WHERE VARCHAR2(2600):=' ';
22 
23   P_SORT_BY VARCHAR2(32767);
24 
25   F_SORT_SELECT VARCHAR2(200);
26 
27   F_SORT_ORDER VARCHAR2(200) := 'deliv2';
28 
29   P_CONC_REQUEST_ID NUMBER := 0;
30 
31   CP_WAREHOUSE_NAME VARCHAR2(3);
32 
33   CP_WHSE_LONGNAME VARCHAR2(240);
34 
35   CP_P_SHIPTO_LOCATION VARCHAR2(20);
36 
37   CP_P_CUSTOMER VARCHAR2(30);
38 
39   CP_TEMP VARCHAR2(4000);
40 
41   CP_P_SHIP_METHOD VARCHAR2(30);
42 
43   CP_P_ITEM_NO VARCHAR2(800);
44 
45   CP_P_BATCH_NO VARCHAR2(30);
46 
47   CP_P_FROM_CREATION_DATE DATE;
48 
49   CP_P_TO_CREATION_DATE DATE;
50 
51   CP_P_ITEM_DISPLAY VARCHAR2(80);
52 
53   CP_P_SORT_ORDER VARCHAR2(80);
54 
55   FUNCTION BEFOREREPORT RETURN BOOLEAN;
56 
57   FUNCTION AFTERPFORM RETURN BOOLEAN;
58 
59   FUNCTION BEFOREPFORM RETURN BOOLEAN;
60 
61   FUNCTION CF_SHIPMENT_PRIORITYFORMULA(SHIPPRI IN VARCHAR2) RETURN CHAR;
62 
63   FUNCTION CF_LPNFORMULA(CONTAINER_FLAG IN VARCHAR2) RETURN CHAR;
64 
65   FUNCTION AFTERREPORT RETURN BOOLEAN;
66 
67   FUNCTION CP_WAREHOUSE_NAME_P RETURN VARCHAR2;
68 
69   FUNCTION CP_WHSE_LONGNAME_P RETURN VARCHAR2;
70 
71   FUNCTION CP_P_SHIPTO_LOCATION_P RETURN VARCHAR2;
72 
73   FUNCTION CP_P_CUSTOMER_P RETURN VARCHAR2;
74 
75   FUNCTION CP_TEMP_P RETURN VARCHAR2;
76 
77   FUNCTION CP_P_SHIP_METHOD_P RETURN VARCHAR2;
78 
79   FUNCTION CP_P_ITEM_NO_P RETURN VARCHAR2;
80 
81   FUNCTION CP_P_BATCH_NO_P RETURN VARCHAR2;
82 
83   FUNCTION CP_P_FROM_CREATION_DATE_P RETURN DATE;
84 
85   FUNCTION CP_P_TO_CREATION_DATE_P RETURN DATE;
86 
87   FUNCTION CP_P_ITEM_DISPLAY_P RETURN VARCHAR2;
88 
89   FUNCTION CP_P_SORT_ORDER_P RETURN VARCHAR2;
90 
91 END WSH_WSHRDOPN_XMLP_PKG;
92