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_WP_WAVE_HEADERS_PKG

Source


1 package wms_wp_wave_headers_pkg AUTHID CURRENT_USER as
2 /* $Header: WMSWPTHS.pls 120.1.12010000.2 2009/08/03 08:18:25 ssrikaku noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_WAVE_HEADER_ID in NUMBER,
6   X_ATTRIBUTE15 in VARCHAR2,
7   X_WAVE_SOURCE in VARCHAR2,
8   X_WAVE_STATUS in VARCHAR2,
9   X_START_TIME in DATE,
10   X_TYPE_ID in VARCHAR2,
11   X_BATCH_ID in NUMBER,
12   X_SHIP_TO_LOCATION_ID in NUMBER,
13   X_CUSTOMER_CLASS_ID in VARCHAR2,
14   X_PULL_REPLENISHMENT_FLAG in VARCHAR2,
15   X_INITIATE_WAVE_PLANNING in VARCHAR2,
16   X_RELEASE_IMMEDIATELY in VARCHAR2,
17   X_TABLE_NAME in VARCHAR2,
18   X_ADVANCED_CRITERIA in VARCHAR2,
19   X_ORGANIZATION_ID in NUMBER,
20   X_PICK_SEQ_RULE_ID in NUMBER,
21   X_PICK_GROUPING_RULE_ID in NUMBER,
22   X_TRIP_ID in NUMBER,
23   X_TRIP_STOP_ID in NUMBER,
24   X_SHIP_METHOD_CODE in VARCHAR2,
25   X_SHIPMENT_PRIORITY_CODE in VARCHAR2,
26   X_CARRIER_ID in NUMBER,
27   X_DELIVERY_ID in NUMBER,
28   X_FROM_ORDER_HEADER_ID in NUMBER,
29   X_ORDER_TYPE_ID in NUMBER,
30   X_CUSTOMER_ID in NUMBER,
31   X_TASK_ID in NUMBER,
32   X_PROJECT_ID in NUMBER,
33   X_CATEGORY_SET_ID in NUMBER,
34   X_CATEGORY_ID in NUMBER,
35   X_INVENTORY_ITEM_ID in NUMBER,
36   X_BACKORDERS_FLAG in VARCHAR2,
37   X_INCLUDE_PLANNED_LINES in VARCHAR2,
38   X_TASK_PLANNING_FLAG in VARCHAR2,
39   X_APPEND_DELIVERIES in VARCHAR2,
40   X_AUTO_CREATE_DELIVERY in VARCHAR2,
41   X_AUTO_CREATE_DELIVERY_CRITERI in VARCHAR2,
42   X_TASK_PRIORITY in NUMBER,
43   X_DEFAULT_STAGE_SUBINVENTORY in VARCHAR2,
44   X_DEFAULT_STAGE_LOCATOR_ID in NUMBER,
45   X_DEFAULT_ALLOCATION_METHOD in VARCHAR2,
46   X_WAVE_FIRMED_FLAG in VARCHAR2,
47   X_WAVE_COMPLETION_TIME in DATE,
48   X_ORDER_NAME in VARCHAR2,
49   X_CUSTOMER in VARCHAR2,
50   X_ORDER_TYPE in VARCHAR2,
51   X_CUSTOMER_CLASS in VARCHAR2,
52   X_SHIP_METHOD in VARCHAR2,
53   X_CARRIER in VARCHAR2,
54   X_SHIP_PRIORITY in VARCHAR2,
55   X_DELIVERY in VARCHAR2,
56   X_TRIP in VARCHAR2,
57   X_TRIP_STOP in VARCHAR2,
58   X_ITEM in VARCHAR2,
59   X_ITEM_CATEGORY in VARCHAR2,
60   X_PROJECT_NAME in VARCHAR2,
61   X_TASK_NAME in VARCHAR2,
62   X_SCHEDULED_DAYS in NUMBER,
63   X_SCHEDULED_HRS in NUMBER,
64   X_DOCK_APPOINTMENT_DAYS in NUMBER,
65   X_DOCK_APPOINTMENT_HOURS in NUMBER,
66   X_PICK_SLIP_GROUP in VARCHAR2,
67   X_RELEASE_SEQ_RULE in VARCHAR2,
68   X_STAGING_SUBINVENTORY in VARCHAR2,
69   X_STAGING_LOCATOR in VARCHAR2,
70   X_CROSS_DOCK_CRITERIA in VARCHAR2,
71   X_PICK_SUBINVENTORY in VARCHAR2,
72   X_PLANNING_CRITERIA in VARCHAR2,
73   X_PLANNING_CRITERIA_ID in NUMBER,
74   X_REQUEST_ID in NUMBER,
75   X_ATTRIBUTE_CATEGORY in VARCHAR2,
76   X_ATTRIBUTE1 in VARCHAR2,
77   X_ATTRIBUTE2 in VARCHAR2,
78   X_ATTRIBUTE3 in VARCHAR2,
79   X_ATTRIBUTE4 in VARCHAR2,
80   X_ATTRIBUTE5 in VARCHAR2,
81   X_ATTRIBUTE6 in VARCHAR2,
82   X_ATTRIBUTE7 in VARCHAR2,
83   X_ATTRIBUTE8 in VARCHAR2,
84   X_ATTRIBUTE9 in VARCHAR2,
85   X_ATTRIBUTE10 in VARCHAR2,
86   X_ATTRIBUTE11 in VARCHAR2,
87   X_ATTRIBUTE12 in VARCHAR2,
88   X_ATTRIBUTE13 in VARCHAR2,
89   X_ATTRIBUTE14 in VARCHAR2,
90   X_WAVE_NAME in VARCHAR2,
91   X_WAVE_DESCRIPTION in VARCHAR2,
92   X_CREATION_DATE in DATE,
93   X_CREATED_BY in NUMBER,
94   X_LAST_UPDATE_DATE in DATE,
95   X_LAST_UPDATED_BY in NUMBER,
96   X_LAST_UPDATE_LOGIN in NUMBER);
97 procedure LOCK_ROW (
98   X_WAVE_HEADER_ID in NUMBER,
99   X_ATTRIBUTE15 in VARCHAR2,
100   X_WAVE_SOURCE in VARCHAR2,
101   X_WAVE_STATUS in VARCHAR2,
102   X_START_TIME in DATE,
103   X_TYPE_ID in VARCHAR2,
104   X_BATCH_ID in NUMBER,
105   X_SHIP_TO_LOCATION_ID in NUMBER,
106   X_CUSTOMER_CLASS_ID in VARCHAR2,
107   X_PULL_REPLENISHMENT_FLAG in VARCHAR2,
108   X_INITIATE_WAVE_PLANNING in VARCHAR2,
109   X_RELEASE_IMMEDIATELY in VARCHAR2,
110   X_TABLE_NAME in VARCHAR2,
111   X_ADVANCED_CRITERIA in VARCHAR2,
112   X_ORGANIZATION_ID in NUMBER,
113   X_PICK_SEQ_RULE_ID in NUMBER,
114   X_PICK_GROUPING_RULE_ID in NUMBER,
115   X_TRIP_ID in NUMBER,
116   X_TRIP_STOP_ID in NUMBER,
117   X_SHIP_METHOD_CODE in VARCHAR2,
118   X_SHIPMENT_PRIORITY_CODE in VARCHAR2,
119   X_CARRIER_ID in NUMBER,
120   X_DELIVERY_ID in NUMBER,
121   X_FROM_ORDER_HEADER_ID in NUMBER,
122   X_ORDER_TYPE_ID in NUMBER,
123   X_CUSTOMER_ID in NUMBER,
124   X_TASK_ID in NUMBER,
125   X_PROJECT_ID in NUMBER,
126   X_CATEGORY_SET_ID in NUMBER,
127   X_CATEGORY_ID in NUMBER,
128   X_INVENTORY_ITEM_ID in NUMBER,
129   X_BACKORDERS_FLAG in VARCHAR2,
130   X_INCLUDE_PLANNED_LINES in VARCHAR2,
131   X_TASK_PLANNING_FLAG in VARCHAR2,
132   X_APPEND_DELIVERIES in VARCHAR2,
133   X_AUTO_CREATE_DELIVERY in VARCHAR2,
134   X_AUTO_CREATE_DELIVERY_CRITERI in VARCHAR2,
135   X_TASK_PRIORITY in NUMBER,
136   X_DEFAULT_STAGE_SUBINVENTORY in VARCHAR2,
137   X_DEFAULT_STAGE_LOCATOR_ID in NUMBER,
138   X_DEFAULT_ALLOCATION_METHOD in VARCHAR2,
139   X_WAVE_FIRMED_FLAG in VARCHAR2,
140   X_WAVE_COMPLETION_TIME in DATE,
141   X_ORDER_NAME in VARCHAR2,
142   X_CUSTOMER in VARCHAR2,
143   X_ORDER_TYPE in VARCHAR2,
144   X_CUSTOMER_CLASS in VARCHAR2,
145   X_SHIP_METHOD in VARCHAR2,
146   X_CARRIER in VARCHAR2,
147   X_SHIP_PRIORITY in VARCHAR2,
148   X_DELIVERY in VARCHAR2,
149   X_TRIP in VARCHAR2,
150   X_TRIP_STOP in VARCHAR2,
151   X_ITEM in VARCHAR2,
152   X_ITEM_CATEGORY in VARCHAR2,
153   X_PROJECT_NAME in VARCHAR2,
154   X_TASK_NAME in VARCHAR2,
155   X_SCHEDULED_DAYS in NUMBER,
156   X_SCHEDULED_HRS in NUMBER,
157   X_DOCK_APPOINTMENT_DAYS in NUMBER,
158   X_DOCK_APPOINTMENT_HOURS in NUMBER,
159   X_PICK_SLIP_GROUP in VARCHAR2,
160   X_RELEASE_SEQ_RULE in VARCHAR2,
161   X_STAGING_SUBINVENTORY in VARCHAR2,
162   X_STAGING_LOCATOR in VARCHAR2,
163   X_CROSS_DOCK_CRITERIA in VARCHAR2,
164   X_PICK_SUBINVENTORY in VARCHAR2,
165   X_PLANNING_CRITERIA in VARCHAR2,
166   X_PLANNING_CRITERIA_ID in NUMBER,
167   X_REQUEST_ID in NUMBER,
168   X_ATTRIBUTE_CATEGORY in VARCHAR2,
169   X_ATTRIBUTE1 in VARCHAR2,
170   X_ATTRIBUTE2 in VARCHAR2,
171   X_ATTRIBUTE3 in VARCHAR2,
172   X_ATTRIBUTE4 in VARCHAR2,
173   X_ATTRIBUTE5 in VARCHAR2,
174   X_ATTRIBUTE6 in VARCHAR2,
175   X_ATTRIBUTE7 in VARCHAR2,
176   X_ATTRIBUTE8 in VARCHAR2,
177   X_ATTRIBUTE9 in VARCHAR2,
178   X_ATTRIBUTE10 in VARCHAR2,
179   X_ATTRIBUTE11 in VARCHAR2,
180   X_ATTRIBUTE12 in VARCHAR2,
181   X_ATTRIBUTE13 in VARCHAR2,
182   X_ATTRIBUTE14 in VARCHAR2,
183   X_WAVE_NAME in VARCHAR2,
184   X_WAVE_DESCRIPTION in VARCHAR2
185 );
186 procedure UPDATE_ROW (
187   X_WAVE_HEADER_ID in NUMBER,
188   X_ATTRIBUTE15 in VARCHAR2,
189   X_WAVE_SOURCE in VARCHAR2,
190   X_WAVE_STATUS in VARCHAR2,
191   X_START_TIME in DATE,
192   X_TYPE_ID in VARCHAR2,
193   X_BATCH_ID in NUMBER,
194   X_SHIP_TO_LOCATION_ID in NUMBER,
195   X_CUSTOMER_CLASS_ID in VARCHAR2,
196   X_PULL_REPLENISHMENT_FLAG in VARCHAR2,
197   X_INITIATE_WAVE_PLANNING in VARCHAR2,
198   X_RELEASE_IMMEDIATELY in VARCHAR2,
199   X_TABLE_NAME in VARCHAR2,
200   X_ADVANCED_CRITERIA in VARCHAR2,
201   X_ORGANIZATION_ID in NUMBER,
202   X_PICK_SEQ_RULE_ID in NUMBER,
203   X_PICK_GROUPING_RULE_ID in NUMBER,
204   X_TRIP_ID in NUMBER,
205   X_TRIP_STOP_ID in NUMBER,
206   X_SHIP_METHOD_CODE in VARCHAR2,
207   X_SHIPMENT_PRIORITY_CODE in VARCHAR2,
208   X_CARRIER_ID in NUMBER,
209   X_DELIVERY_ID in NUMBER,
210   X_FROM_ORDER_HEADER_ID in NUMBER,
211   X_ORDER_TYPE_ID in NUMBER,
212   X_CUSTOMER_ID in NUMBER,
213   X_TASK_ID in NUMBER,
214   X_PROJECT_ID in NUMBER,
215   X_CATEGORY_SET_ID in NUMBER,
216   X_CATEGORY_ID in NUMBER,
217   X_INVENTORY_ITEM_ID in NUMBER,
218   X_BACKORDERS_FLAG in VARCHAR2,
219   X_INCLUDE_PLANNED_LINES in VARCHAR2,
220   X_TASK_PLANNING_FLAG in VARCHAR2,
221   X_APPEND_DELIVERIES in VARCHAR2,
222   X_AUTO_CREATE_DELIVERY in VARCHAR2,
223   X_AUTO_CREATE_DELIVERY_CRITERI in VARCHAR2,
224   X_TASK_PRIORITY in NUMBER,
225   X_DEFAULT_STAGE_SUBINVENTORY in VARCHAR2,
226   X_DEFAULT_STAGE_LOCATOR_ID in NUMBER,
227   X_DEFAULT_ALLOCATION_METHOD in VARCHAR2,
228   X_WAVE_FIRMED_FLAG in VARCHAR2,
229   X_WAVE_COMPLETION_TIME in DATE,
230   X_ORDER_NAME in VARCHAR2,
231   X_CUSTOMER in VARCHAR2,
232   X_ORDER_TYPE in VARCHAR2,
233   X_CUSTOMER_CLASS in VARCHAR2,
234   X_SHIP_METHOD in VARCHAR2,
235   X_CARRIER in VARCHAR2,
236   X_SHIP_PRIORITY in VARCHAR2,
237   X_DELIVERY in VARCHAR2,
238   X_TRIP in VARCHAR2,
239   X_TRIP_STOP in VARCHAR2,
240   X_ITEM in VARCHAR2,
241   X_ITEM_CATEGORY in VARCHAR2,
242   X_PROJECT_NAME in VARCHAR2,
243   X_TASK_NAME in VARCHAR2,
244   X_SCHEDULED_DAYS in NUMBER,
245   X_SCHEDULED_HRS in NUMBER,
246   X_DOCK_APPOINTMENT_DAYS in NUMBER,
247   X_DOCK_APPOINTMENT_HOURS in NUMBER,
248   X_PICK_SLIP_GROUP in VARCHAR2,
249   X_RELEASE_SEQ_RULE in VARCHAR2,
250   X_STAGING_SUBINVENTORY in VARCHAR2,
251   X_STAGING_LOCATOR in VARCHAR2,
252   X_CROSS_DOCK_CRITERIA in VARCHAR2,
253   X_PICK_SUBINVENTORY in VARCHAR2,
254   X_PLANNING_CRITERIA in VARCHAR2,
255   X_PLANNING_CRITERIA_ID in NUMBER,
256   X_REQUEST_ID in NUMBER,
257   X_ATTRIBUTE_CATEGORY in VARCHAR2,
258   X_ATTRIBUTE1 in VARCHAR2,
259   X_ATTRIBUTE2 in VARCHAR2,
260   X_ATTRIBUTE3 in VARCHAR2,
261   X_ATTRIBUTE4 in VARCHAR2,
262   X_ATTRIBUTE5 in VARCHAR2,
263   X_ATTRIBUTE6 in VARCHAR2,
264   X_ATTRIBUTE7 in VARCHAR2,
265   X_ATTRIBUTE8 in VARCHAR2,
266   X_ATTRIBUTE9 in VARCHAR2,
267   X_ATTRIBUTE10 in VARCHAR2,
268   X_ATTRIBUTE11 in VARCHAR2,
269   X_ATTRIBUTE12 in VARCHAR2,
270   X_ATTRIBUTE13 in VARCHAR2,
271   X_ATTRIBUTE14 in VARCHAR2,
272   X_WAVE_NAME in VARCHAR2,
273   X_WAVE_DESCRIPTION in VARCHAR2,
274   X_LAST_UPDATE_DATE in DATE,
275   X_LAST_UPDATED_BY in NUMBER,
276   X_LAST_UPDATE_LOGIN in NUMBER
277 );
278 procedure DELETE_ROW (
279   X_WAVE_HEADER_ID in NUMBER
280 );
281 procedure ADD_LANGUAGE;
282 end WMS_WP_WAVE_HEADERS_PKG;