[Home] [Help]
PACKAGE: APPS.WSH_WSHRDPIK_XMLP_PKG
Source
1 PACKAGE WSH_WSHRDPIK_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHRDPIKS.pls 120.3.12010000.2 2010/04/19 09:44:11 anvarshn ship $ */
3
4 P_ORGANIZATION_ID NUMBER;
5
6 P_ITEM_DISPLAY VARCHAR2(32767);
7
8 LP_PICK_STATUS VARCHAR2(200) := ' ';
9
10 LP_DETAIL_DATE_HIGH DATE;
11
12 LP_ITEM_DISPLAY_VALUE VARCHAR2(200) := 'msitl.description';
13
14 LP_YES VARCHAR2(200);
15
16 LP_NO VARCHAR2(200);
17
18 LP_WAREHOUSE_NAME VARCHAR2(240);
19
20 LP_WAREHOUSE_CODE VARCHAR2(3);
21
22 P_ITEM_FLEX_CODE VARCHAR2(32767);
23
24 P_LOCATOR_FLEX_CODE VARCHAR2(32767);
25
26 LP_STRUCTURE_NUM NUMBER := 101;
27
28 P_CONC_REQUEST_ID NUMBER := 0;
29
30 LP_PICK_SLIP_NUM VARCHAR2(200) := ' ';
31
32 LP_ORDER_NUM VARCHAR2(200) := ' ';
33
34 LP_CUSTOMER_ID VARCHAR2(40) := ' ';
35
36 LP_SHIP_METHOD_CODE VARCHAR2(60) := ' ';
37
38 P_PICK_SLIP_NUM_LOW NUMBER;
39
40 P_PICK_SLIP_NUM_HIGH NUMBER;
41
42 P_HEADER_ID_HIGH NUMBER;
43
44 P_HEADER_ID_LOW NUMBER;
45
46 P_CUSTOMER_ID NUMBER;
47
48 P_FREIGHT_CODE VARCHAR2(60);
49
50 P_MOVE_ORDER_LOW VARCHAR2(30);
51
52 P_MOVE_ORDER_HIGH VARCHAR2(30);
53
54 LP_MO_CLAUSE VARCHAR2(400) := ' ';
55
56 P_DETAIL_DATE_LOW DATE;
57
58 P_DETAIL_DATE_HIGH DATE;
59
60 LP_WAREHOUSE_CLAUSE VARCHAR2(400) := ' ';
61
62 P_PICK_STATUS VARCHAR2(2);
63
64 P_ORDER_NUM_HIGH VARCHAR2(150);
65
66 P_ORDER_NUM_LOW VARCHAR2(150);
67
68 P_ORDER_TYPE_ID NUMBER;
69
70 LP_ORDER_TYPE VARCHAR2(200) := ' ';
71
72 LP_PRINTER_NAME VARCHAR2(3000) := ' ';
73
74 P_PRINTER_NAME VARCHAR2(200);
75
76 P_PICK_STATUS_VALUE VARCHAR2(10) := 'A';
77
78 P_FUNCTION_NAME VARCHAR2(32767);
79
80 P_ENTITY_HEADERS VARCHAR2(32767);
81
82 P_ENTITY_LINES VARCHAR2(32767);
83
84 P_LEVEL_TYPE_ID1 VARCHAR2(32767);
85
86 P_LEVEL_TYPE_ID2 VARCHAR2(32767);
87
88 P_CONCURRENT_PROGRAM_NAME VARCHAR2(32767);
89
90 P_ENABLED_FLAG VARCHAR2(32767);
91
92 P_APPLICATION_ID NUMBER;
93
94 LP_PICK_STATUS_UNPICK VARCHAR2(200);
95
96 LP_DETAIL_DATE_UNPICK VARCHAR2(200) := ' ';
97
98 LP_DETAIL_DATE_MMT VARCHAR2(200) := ' ';
99
100 LP_PICK_SLIP_NUM_MMT VARCHAR2(200) := ' ';
101
102 LP_DETAIL_DATE_MTRL VARCHAR2(200) := ' ';
103
104 LP_PICK_SLIP_NUM_MTRL VARCHAR2(200) := ' ';
105
106 CP_WAREHOUSE_CODE VARCHAR2(3);
107
108 CP_WAREHOUSE_NAME VARCHAR2(240);
109
110 ST_ADDR1 VARCHAR2(240);
111
112 TS_ADDR3 VARCHAR2(240);
113
114 TS_ADDR4 VARCHAR2(240);
115
116 TS_ADDR5 VARCHAR2(300);
117
118 TS_ADDR1 VARCHAR2(240);
119
120 TS_ADDR2 VARCHAR2(240);
121
122 ST_ADDR4 VARCHAR2(240);
123
124 ST_ADDR5 VARCHAR2(300);
125
126 ST_ADDR2 VARCHAR2(240);
127
128 ST_ADDR3 VARCHAR2(240);
129
130 CP_TRIP_NAME VARCHAR2(30);
131
132 CP_CACHE_DELIVERY_ID NUMBER := -99;
133
134 CP_CACHE_TRIP_NAME VARCHAR2(30);
135
136 CP_CACHE_TRIP_ID NUMBER;
137
138 FUNCTION AFTERPFORM RETURN BOOLEAN;
139
140 FUNCTION AFTERREPORT RETURN BOOLEAN;
141
142 FUNCTION BEFOREPFORM RETURN BOOLEAN;
143
144 FUNCTION BEFOREREPORT RETURN BOOLEAN;
145
146 FUNCTION F_LOT_QUANTITYFORMULA(DELIVERY_DETAIL_ID3 IN NUMBER
147 ,LOT_TXN_ID IN NUMBER
148 ,LOT_NUMBER1 IN VARCHAR2) RETURN NUMBER;
149
150 FUNCTION G_TRANSACTION_TEMP_IDGROUPFILT(ORGANIZATION_ID IN NUMBER) RETURN BOOLEAN;
151
152 FUNCTION F_FROM_LOCATIONFORMULA(FROM_LOCATOR_ID IN NUMBER
153 ,ORGANIZATION_ID IN NUMBER) RETURN CHAR;
154
155 FUNCTION F_ITEM_DESCRIPTIONFORMULA(ITEM_INFO IN VARCHAR2
156 ,INVENTORY_ITEM_ID IN NUMBER
157 ,ORGANIZATION_ID IN NUMBER
158 ,ITEM_DESCRIPTION IN VARCHAR2) RETURN CHAR;
159
160 FUNCTION F_REQUESTED_QUANTITYFORMULA(SOURCE_HEADER_ID1 IN NUMBER
161 ,SOURCE_LINE_ID1 IN NUMBER
162 ,MOVE_ORDER_LINE_ID1 IN NUMBER) RETURN NUMBER;
163
164 FUNCTION F_SHIPPED_QUANTITYFORMULA RETURN NUMBER;
165
166 FUNCTION F_TO_LOCATIONFORMULA(TO_LOCATOR_ID IN NUMBER
167 ,ORGANIZATION_ID IN NUMBER) RETURN CHAR;
168
169 FUNCTION CF_REVISIONFORMULA(TRANSACTION_ID1 IN NUMBER) RETURN CHAR;
170
171 FUNCTION CF_TRIP_IDFORMULA(DELIVERY_ID1 IN NUMBER
172 ,INITIAL_PICKUP_LOCATION_ID IN NUMBER) RETURN NUMBER;
173
174 FUNCTION CF_CUSTOMER_NAMEFORMULA(CUSTOMER_FLAG IN VARCHAR2
175 ,SOURCE_HEADER_ID IN NUMBER) RETURN CHAR;
176
177 FUNCTION CF_CUSTOMERFORMULA(CUSTOMER_FLAG IN VARCHAR2
178 ,SOURCE_HEADER_ID IN NUMBER) RETURN CHAR;
179
180 FUNCTION CF_ORDER_NUMBERFORMULA(ORDER_NUMBER_FLAG IN VARCHAR2
181 ,SOURCE_HEADER_NUMBER IN VARCHAR2) RETURN NUMBER;
182
183 FUNCTION CF_TRIP_STOP_ADDRESS1FORMULA(TRIP_STOP_FLAG IN VARCHAR2
184 ,DELIVERY_FLAG IN VARCHAR2
185 ,CF_DELIVERY_ID IN NUMBER
186 ,PICK_SLIP_NUMBER IN NUMBER) RETURN CHAR;
187
188 FUNCTION CF_DELIVERYFORMULA(DELIVERY_FLAG IN VARCHAR2
189 ,DELIVERY_NAME IN VARCHAR2) RETURN CHAR;
190
191 FUNCTION CF_REQUISITION_NUMBERFORMULA(SOURCE_HEADER_ID IN NUMBER) RETURN CHAR;
192
193 FUNCTION CF_SUBINVENTORYFORMULA(SUBINVENTORY_FLAG IN VARCHAR2
194 ,FROM_SUBINVENTORY IN VARCHAR2) RETURN CHAR;
195
196 FUNCTION CF_SHIPMENT_PRIORITYFORMULA(SHIPMENT_PRIORITY_FLAG IN VARCHAR2
197 ,PRIORITY IN VARCHAR2) RETURN CHAR;
198
199 FUNCTION CF_SHIP_TO_ADDRESSFORMULA(SHIP_TO_FLAG IN VARCHAR2
200 ,PICK_SLIP_NUMBER IN NUMBER) RETURN CHAR;
201
202 FUNCTION CF_CARRIERFORMULA(CARRIER_FLAG IN VARCHAR2
203 ,CARRIER IN VARCHAR2) RETURN CHAR;
204
205 FUNCTION CF_TEMPFORMULA(SHIPMENT_PRIORITY_FLAG IN VARCHAR2
206 ,PRIORITY IN VARCHAR2) RETURN CHAR;
207
208 FUNCTION CF_DELIVERY_IDFORMULA(DELIVERY_FLAG IN VARCHAR2
209 ,DELIVERY_ID IN NUMBER) RETURN NUMBER;
210
211 FUNCTION CF_WAREHOUSEFORMULA(ORGANIZATION_ID1 IN NUMBER) RETURN CHAR;
212
213 FUNCTION CF_TRIP_CHRFORMULA(CF_TRIP_ID IN NUMBER) RETURN CHAR;
214
215 FUNCTION CF_FREIGHT_TERMS_NAMEFORMULA(FREIGHT_TERMS IN VARCHAR2
216 ,SOURCE_CODE IN VARCHAR2) RETURN CHAR;
217
218 FUNCTION CP_WAREHOUSE_CODE_P RETURN VARCHAR2;
219
220 FUNCTION CP_WAREHOUSE_NAME_P RETURN VARCHAR2;
221
222 FUNCTION ST_ADDR1_P RETURN VARCHAR2;
223
224 FUNCTION TS_ADDR3_P RETURN VARCHAR2;
225
226 FUNCTION TS_ADDR4_P RETURN VARCHAR2;
227
228 FUNCTION TS_ADDR5_P RETURN VARCHAR2;
229
230 FUNCTION TS_ADDR1_P RETURN VARCHAR2;
231
232 FUNCTION TS_ADDR2_P RETURN VARCHAR2;
233
234 FUNCTION ST_ADDR4_P RETURN VARCHAR2;
235
236 FUNCTION ST_ADDR5_P RETURN VARCHAR2;
237
238 FUNCTION ST_ADDR2_P RETURN VARCHAR2;
239
240 FUNCTION ST_ADDR3_P RETURN VARCHAR2;
241
242 FUNCTION CP_TRIP_NAME_P RETURN VARCHAR2;
243
244 FUNCTION CP_CACHE_DELIVERY_ID_P RETURN NUMBER;
245
246 FUNCTION CP_CACHE_TRIP_NAME_P RETURN VARCHAR2;
247
248 FUNCTION CP_CACHE_TRIP_ID_P RETURN NUMBER;
249
250 FUNCTION GET_DELIMITER(APPLICATION_SHORT_NAME IN VARCHAR2
251 ,KEY_FLEX_CODE IN VARCHAR2
252 ,STRUCTURE_NUMBER IN NUMBER) RETURN VARCHAR2;
253
254 FUNCTION GET_CCID(APPLICATION_SHORT_NAME IN VARCHAR2
255 ,KEY_FLEX_CODE IN VARCHAR2
256 ,STRUCTURE_NUMBER IN NUMBER
257 ,VALIDATION_DATE IN VARCHAR2
258 ,CONCATENATED_SEGMENTS IN VARCHAR2) RETURN NUMBER;
259
260 FUNCTION GET_SEGS(APPLICATION_SHORT_NAME IN VARCHAR2
261 ,KEY_FLEX_CODE IN VARCHAR2
262 ,STRUCTURE_NUMBER IN NUMBER
263 ,COMBINATION_ID IN NUMBER) RETURN VARCHAR2;
264 function B_task_idFt(organization_id varchar2) return varchar2;
265
266 END WSH_WSHRDPIK_XMLP_PKG;
267