PACKAGE: APPS.WSH_WSHRDASP_XMLP_PKG

Source

1 PACKAGE WSH_WSHRDASP_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHRDASPS.pls 120.4 2010/08/30 12:12:07 anvarshn ship $ */
3   P_SHIP_TO VARCHAR2(32767);
4 
5   P_CUSTOMER_ID VARCHAR2(30); --RTV changes
6 
7   P_SHIP_METHOD_CODE VARCHAR2(80);
8 
9   P_BATCH_NUMBER VARCHAR2(30);
10 
11   P_PR_BATCH VARCHAR2(2000);
12 
13   P_SC_BATCH_ID VARCHAR2(40);
14 
15   P_AP_BATCH_ID VARCHAR2(40);
16 
17   P_DELIVERY_FROM VARCHAR2(40);
18 
19   P_DELIVERY_TO VARCHAR2(40);
20 
21   P_BOL_FROM VARCHAR2(40);
22 
23   P_BOL_TO VARCHAR2(40);
24 
25   P_SHIP_FROM VARCHAR2(40);
26 
27   P_PICKUP_DATE_FROM DATE;
28 
29   LP_PICKUP_DATE_FROM DATE;
30 
31   CP_PICKUP_DATE_FROM VARCHAR2(20);
32 
33   CP_PICKUP_DATE_TO VARCHAR2(20);
34 
35   P_PICKUP_DATE_TO DATE;
36 
37   LP_PICKUP_DATE_TO DATE;
38 
39   P_PR_BATCH_ID NUMBER;
40 
41   P_BATCH VARCHAR2(40);
42 
43   P_EXCEPTIONS VARCHAR2(200);
44 
45   P_ORG VARCHAR2(40);
46 
47   P_PLANNED_FLAG VARCHAR2(40);
48 
49   P_BATCH_TYPE VARCHAR2(32767);
50 
51   P_DROPOFF_DATE_FROM DATE;
52 
53   CP_DROPOFF_DATE_FROM VARCHAR2(20);
54 
55   P_DROPOFF_DATE_TO DATE;
56 
57   CP_DROPOFF_DATE_TO VARCHAR2(20);
58 
59   LP_DROPOFF_DATE_TO DATE;
60 
61   LP_DROPOFF_DATE_FROM DATE;
62 
63   P_EXCEPTIONS_ONLY VARCHAR2(32767);
64 
65   P_SC_RULE_ID VARCHAR2(40);
66 
67   LP_BOL_NUMBER VARCHAR2(200);
68 
69   P_AUTO_SC_MESSAGE VARCHAR2(2000);
70 
71   P_CONC_REQUEST_ID NUMBER := 0;
72 
73   CP_BATCH_NAME VARCHAR2(240);
74 
75   CP_CUSTOMER VARCHAR2(240);
76 
77   CP_SHIP_FROM VARCHAR2(240);
78 
79   CP_SHIP_TO VARCHAR2(240);
80 
81   CP_ORG VARCHAR2(240);
82 
83   CP_PR_BATCH VARCHAR2(80);
84 
85   CP_SHIP_METHOD VARCHAR2(80);
86 
87   CP_DELIVERY_FROM VARCHAR2(30);
88 
89   CP_DELIVERY_TO VARCHAR2(30);
90 
91   CP_TRIP_NAME VARCHAR2(92);
92 
93   CP_TRIP_ID NUMBER;
94 
95   CP_MESSAGE VARCHAR2(2000);
96 
97   CP_BATCH_ID NUMBER;
98 
99   CP_EXCEPTIONS_ONLY VARCHAR2(20);
100 
101   CP_AUTO_CONFIRM_RULE VARCHAR2(250);
102 
103   FUNCTION BEFOREREPORT RETURN BOOLEAN;
104 
105   FUNCTION AFTERPFORM RETURN BOOLEAN;
106 
107   FUNCTION BEFOREPFORM RETURN BOOLEAN;
108 
109   FUNCTION CF_1FORMULA(DELIVERY_ID IN NUMBER) RETURN VARCHAR2;
110 
111   FUNCTION CF_MESSAGE(EXCEPTION_ID IN NUMBER) RETURN VARCHAR2;
112 
113   FUNCTION AFTERREPORT RETURN BOOLEAN;
114 
115   FUNCTION CP_BATCH_NAME_P RETURN VARCHAR2;
116 
117   FUNCTION CP_CUSTOMER_P RETURN VARCHAR2;
118 
119   FUNCTION CP_SHIP_FROM_P RETURN VARCHAR2;
120 
121   FUNCTION CP_SHIP_TO_P RETURN VARCHAR2;
122 
123   FUNCTION CP_ORG_P RETURN VARCHAR2;
124 
125   FUNCTION CP_PR_BATCH_P RETURN VARCHAR2;
126 
127   FUNCTION CP_SHIP_METHOD_P RETURN VARCHAR2;
128 
129   FUNCTION CP_DELIVERY_FROM_P RETURN VARCHAR2;
130 
131   FUNCTION CP_DELIVERY_TO_P RETURN VARCHAR2;
132 
133   FUNCTION CP_TRIP_NAME_P RETURN VARCHAR2;
134 
135   FUNCTION CP_TRIP_ID_P RETURN NUMBER;
136 
137   FUNCTION CP_MESSAGE_P RETURN VARCHAR2;
138 
139   FUNCTION CP_BATCH_ID_P RETURN NUMBER;
140 
141   FUNCTION CP_EXCEPTIONS_ONLY_P RETURN VARCHAR2;
142 
143   FUNCTION CP_AUTO_CONFIRM_RULE_P RETURN VARCHAR2;
144 
145 END WSH_WSHRDASP_XMLP_PKG;
146 
147