[Home] [Help]
PACKAGE: APPS.WMS_CARTONIZATION_USER_PUB
Source
1 PACKAGE WMS_CARTONIZATION_USER_PUB AUTHID CURRENT_USER AS
2 /* $Header: WMSCRTUS.pls 120.1.12020000.2 2013/01/31 22:07:02 sahmahes ship $*/
3
4 TYPE task_rec_type
5 IS RECORD
6 (
7 TRANSACTION_HEADER_ID NUMBER
8 , TRANSACTION_TEMP_ID NUMBER
9 , SOURCE_CODE VARCHAR2(30)
10 , SOURCE_LINE_ID NUMBER
11 , TRANSACTION_MODE NUMBER
12 , LOCK_FLAG VARCHAR2(1)
13 , LAST_UPDATE_DATE DATE
14 , LAST_UPDATED_BY NUMBER
15 , CREATION_DATE DATE
16 , CREATED_BY NUMBER
17 , LAST_UPDATE_LOGIN NUMBER
18 , REQUEST_ID NUMBER
19 , PROGRAM_APPLICATION_ID NUMBER
20 , PROGRAM_ID NUMBER
21 , PROGRAM_UPDATE_DATE DATE
22 , INVENTORY_ITEM_ID NUMBER
23 , REVISION VARCHAR2(3)
24 , ORGANIZATION_ID NUMBER
25 , SUBINVENTORY_CODE VARCHAR2(10)
26 , LOCATOR_ID NUMBER
27 , TRANSACTION_QUANTITY NUMBER
28 , PRIMARY_QUANTITY NUMBER
29 , TRANSACTION_UOM VARCHAR2(3)
30 , TRANSACTION_COST NUMBER
31 , TRANSACTION_TYPE_ID NUMBER
32 , TRANSACTION_ACTION_ID NUMBER
33 , TRANSACTION_SOURCE_TYPE_ID NUMBER
34 , TRANSACTION_SOURCE_ID NUMBER
35 , TRANSACTION_SOURCE_NAME VARCHAR2(30)
36 , TRANSACTION_DATE DATE
37 , ACCT_PERIOD_ID NUMBER
38 , DISTRIBUTION_ACCOUNT_ID NUMBER
39 , TRANSACTION_REFERENCE VARCHAR2(240)
40 , REQUISITION_LINE_ID NUMBER
41 , REQUISITION_DISTRIBUTION_ID NUMBER
42 , REASON_ID NUMBER
43 , LOT_NUMBER VARCHAR2(80)
44 , LOT_EXPIRATION_DATE DATE
45 , SERIAL_NUMBER VARCHAR2(30)
46 , RECEIVING_DOCUMENT VARCHAR2(10)
47 , DEMAND_ID NUMBER
48 , RCV_TRANSACTION_ID NUMBER
49 , MOVE_TRANSACTION_ID NUMBER
50 , COMPLETION_TRANSACTION_ID NUMBER
51 , WIP_ENTITY_TYPE NUMBER
52 , SCHEDULE_ID NUMBER
53 , REPETITIVE_LINE_ID NUMBER
54 , EMPLOYEE_CODE VARCHAR2(10)
55 , PRIMARY_SWITCH NUMBER
56 , SCHEDULE_UPDATE_CODE NUMBER
57 , SETUP_TEARDOWN_CODE NUMBER
58 , ITEM_ORDERING NUMBER
59 , NEGATIVE_REQ_FLAG NUMBER
60 , OPERATION_SEQ_NUM NUMBER
61 , PICKING_LINE_ID NUMBER
62 , TRX_SOURCE_LINE_ID NUMBER
63 , TRX_SOURCE_DELIVERY_ID NUMBER
64 , PHYSICAL_ADJUSTMENT_ID NUMBER
65 , CYCLE_COUNT_ID NUMBER
66 , RMA_LINE_ID NUMBER
67 , CUSTOMER_SHIP_ID NUMBER
68 , CURRENCY_CODE VARCHAR2(10)
69 , CURRENCY_CONVERSION_RATE NUMBER
70 , CURRENCY_CONVERSION_TYPE VARCHAR2(30)
71 , CURRENCY_CONVERSION_DATE DATE
72 , USSGL_TRANSACTION_CODE VARCHAR2(30)
73 , VENDOR_LOT_NUMBER VARCHAR2(30)
74 , ENCUMBRANCE_ACCOUNT NUMBER
75 , ENCUMBRANCE_AMOUNT NUMBER
76 , SHIP_TO_LOCATION NUMBER
77 , SHIPMENT_NUMBER VARCHAR2(30)
78 , TRANSFER_COST NUMBER
79 , TRANSPORTATION_COST NUMBER
80 , TRANSPORTATION_ACCOUNT NUMBER
81 , FREIGHT_CODE VARCHAR2(30)
82 , CONTAINERS NUMBER
83 , WAYBILL_AIRBILL VARCHAR2(20)
84 , EXPECTED_ARRIVAL_DATE DATE
85 , TRANSFER_SUBINVENTORY VARCHAR2(10)
86 , TRANSFER_ORGANIZATION NUMBER
87 , TRANSFER_TO_LOCATION NUMBER
88 , NEW_AVERAGE_COST NUMBER
89 , VALUE_CHANGE NUMBER
90 , PERCENTAGE_CHANGE NUMBER
91 , MATERIAL_ALLOCATION_TEMP_ID NUMBER
92 , DEMAND_SOURCE_HEADER_ID NUMBER
93 , DEMAND_SOURCE_LINE VARCHAR2(30)
94 , DEMAND_SOURCE_DELIVERY VARCHAR2(30)
95 , ITEM_SEGMENTS VARCHAR2(240)
96 , ITEM_DESCRIPTION VARCHAR2(240)
97 , ITEM_TRX_ENABLED_FLAG VARCHAR2(1)
98 , ITEM_LOCATION_CONTROL_CODE NUMBER
99 , ITEM_RESTRICT_SUBINV_CODE NUMBER
100 , ITEM_RESTRICT_LOCATORS_CODE NUMBER
101 , ITEM_REVISION_QTY_CONTROL_CODE NUMBER
102 , ITEM_PRIMARY_UOM_CODE VARCHAR2(3)
103 , ITEM_UOM_CLASS VARCHAR2(10)
104 , ITEM_SHELF_LIFE_CODE NUMBER
105 , ITEM_SHELF_LIFE_DAYS NUMBER
106 , ITEM_LOT_CONTROL_CODE NUMBER
107 , ITEM_SERIAL_CONTROL_CODE NUMBER
108 , ITEM_INVENTORY_ASSET_FLAG VARCHAR2(1)
109 , ALLOWED_UNITS_LOOKUP_CODE NUMBER
110 , DEPARTMENT_ID NUMBER
111 , DEPARTMENT_CODE VARCHAR2(10)
112 , WIP_SUPPLY_TYPE NUMBER
113 , SUPPLY_SUBINVENTORY VARCHAR2(10)
114 , SUPPLY_LOCATOR_ID NUMBER
115 , VALID_SUBINVENTORY_FLAG VARCHAR2(1)
116 , VALID_LOCATOR_FLAG VARCHAR2(1)
117 , LOCATOR_SEGMENTS VARCHAR2(240)
118 , CURRENT_LOCATOR_CONTROL_CODE NUMBER
119 , NUMBER_OF_LOTS_ENTERED NUMBER
120 , WIP_COMMIT_FLAG VARCHAR2(1)
121 , NEXT_LOT_NUMBER VARCHAR2(80)
122 , LOT_ALPHA_PREFIX VARCHAR2(30)
123 , NEXT_SERIAL_NUMBER VARCHAR2(30)
124 , SERIAL_ALPHA_PREFIX VARCHAR2(30)
125 , SHIPPABLE_FLAG VARCHAR2(1)
126 , POSTING_FLAG VARCHAR2(1)
127 , REQUIRED_FLAG VARCHAR2(1)
128 , PROCESS_FLAG VARCHAR2(1)
129 , ERROR_CODE VARCHAR2(240)
130 , ERROR_EXPLANATION VARCHAR2(240)
131 , ATTRIBUTE_CATEGORY VARCHAR2(30)
132 , ATTRIBUTE1 VARCHAR2(150)
133 , ATTRIBUTE2 VARCHAR2(150)
134 , ATTRIBUTE3 VARCHAR2(150)
135 , ATTRIBUTE4 VARCHAR2(150)
136 , ATTRIBUTE5 VARCHAR2(150)
137 , ATTRIBUTE6 VARCHAR2(150)
138 , ATTRIBUTE7 VARCHAR2(150)
139 , ATTRIBUTE8 VARCHAR2(150)
140 , ATTRIBUTE9 VARCHAR2(150)
141 , ATTRIBUTE10 VARCHAR2(150)
142 , ATTRIBUTE11 VARCHAR2(150)
143 , ATTRIBUTE12 VARCHAR2(150)
144 , ATTRIBUTE13 VARCHAR2(150)
145 , ATTRIBUTE14 VARCHAR2(150)
146 , ATTRIBUTE15 VARCHAR2(150)
147 , MOVEMENT_ID NUMBER
148 , RESERVATION_QUANTITY NUMBER
149 , SHIPPED_QUANTITY NUMBER
150 , TRANSACTION_LINE_NUMBER NUMBER
151 , TASK_ID NUMBER(15)
152 , TO_TASK_ID NUMBER(15)
153 , SOURCE_TASK_ID NUMBER
154 , PROJECT_ID NUMBER(15)
155 , SOURCE_PROJECT_ID NUMBER
156 , PA_EXPENDITURE_ORG_ID NUMBER
157 , TO_PROJECT_ID NUMBER(15)
158 , EXPENDITURE_TYPE VARCHAR2(30)
159 , FINAL_COMPLETION_FLAG VARCHAR2(1)
160 , TRANSFER_PERCENTAGE NUMBER
161 , TRANSACTION_SEQUENCE_ID NUMBER
162 , MATERIAL_ACCOUNT NUMBER
163 , MATERIAL_OVERHEAD_ACCOUNT NUMBER
164 , RESOURCE_ACCOUNT NUMBER
165 , OUTSIDE_PROCESSING_ACCOUNT NUMBER
166 , OVERHEAD_ACCOUNT NUMBER
167 , FLOW_SCHEDULE VARCHAR2(1)
168 , COST_GROUP_ID NUMBER
169 , DEMAND_CLASS VARCHAR2(30)
170 , QA_COLLECTION_ID NUMBER
171 , KANBAN_CARD_ID NUMBER
172 , OVERCOMPLETION_TRANSACTION_QTY NUMBER
173 , OVERCOMPLETION_PRIMARY_QTY NUMBER
174 , OVERCOMPLETION_TRANSACTION_ID NUMBER
175 , END_ITEM_UNIT_NUMBER VARCHAR2(60)
176 , SCHEDULED_PAYBACK_DATE DATE
177 , LINE_TYPE_CODE NUMBER
178 , PARENT_TRANSACTION_TEMP_ID NUMBER
179 , PUT_AWAY_STRATEGY_ID NUMBER
180 , PUT_AWAY_RULE_ID NUMBER
181 , PICK_STRATEGY_ID NUMBER
182 , PICK_RULE_ID NUMBER
183 , MOVE_ORDER_LINE_ID NUMBER
184 , TASK_GROUP_ID NUMBER
185 , PICK_SLIP_NUMBER NUMBER
186 , RESERVATION_ID NUMBER
187 , COMMON_BOM_SEQ_ID NUMBER
188 , COMMON_ROUTING_SEQ_ID NUMBER
189 , ORG_COST_GROUP_ID NUMBER
190 , COST_TYPE_ID NUMBER
191 , TRANSACTION_STATUS NUMBER
192 , STANDARD_OPERATION_ID NUMBER
193 , TASK_PRIORITY NUMBER
194 , WMS_TASK_TYPE NUMBER
195 , PARENT_LINE_ID NUMBER
196 , SOURCE_LOT_NUMBER VARCHAR2(80)
197 , TRANSFER_COST_GROUP_ID NUMBER
198 , LPN_ID NUMBER
199 , TRANSFER_LPN_ID NUMBER
200 , WMS_TASK_STATUS NUMBER
201 , CONTENT_LPN_ID NUMBER
202 , CONTAINER_ITEM_ID NUMBER
203 , CARTONIZATION_ID NUMBER
204 , PICK_SLIP_DATE DATE
205 , REBUILD_ITEM_ID NUMBER
206 , REBUILD_SERIAL_NUMBER VARCHAR2(30)
207 , REBUILD_ACTIVITY_ID NUMBER
208 , REBUILD_JOB_NAME VARCHAR2(240)
209 , ORGANIZATION_TYPE NUMBER
210 , TRANSFER_ORGANIZATION_TYPE NUMBER
211 , OWNING_ORGANIZATION_ID NUMBER
212 , OWNING_TP_TYPE NUMBER
213 , XFR_OWNING_ORGANIZATION_ID NUMBER
214 , TRANSFER_OWNING_TP_TYPE NUMBER
215 , PLANNING_ORGANIZATION_ID NUMBER
216 , PLANNING_TP_TYPE NUMBER
217 , XFR_PLANNING_ORGANIZATION_ID NUMBER
218 , TRANSFER_PLANNING_TP_TYPE NUMBER
219 , SECONDARY_UOM_CODE VARCHAR2(240)
220 , SECONDARY_TRANSACTION_QUANTITY NUMBER
221 , ALLOCATED_LPN_ID NUMBER
222 , SCHEDULE_NUMBER VARCHAR2(60)
223 , SCHEDULED_FLAG NUMBER
224 , CLASS_CODE VARCHAR2(10)
225 , SCHEDULE_GROUP NUMBER
226 , BUILD_SEQUENCE NUMBER
227 , BOM_REVISION VARCHAR2(3)
228 , ROUTING_REVISION VARCHAR2(3)
229 , BOM_REVISION_DATE DATE
230 , ROUTING_REVISION_DATE DATE
231 , ALTERNATE_BOM_DESIGNATOR VARCHAR2(10)
232 , ALTERNATE_ROUTING_DESIGNATOR VARCHAR2(10)
233 , TRANSACTION_BATCH_ID NUMBER
234 , TRANSACTION_BATCH_SEQ NUMBER
235 , OPERATION_PLAN_ID NUMBER
236 , INTRANSIT_ACCOUNT NUMBER
237 , FOB_POINT NUMBER
238 , LOGICAL_TRX_TYPE_CODE NUMBER
239 , MOVE_ORDER_HEADER_ID NUMBER
240 , ORIGINAL_TRANSACTION_TEMP_ID NUMBER
241 , SERIAL_ALLOCATED_FLAG VARCHAR2(1)
242 , TRX_FLOW_HEADER_ID NUMBER
243 , FULFILLMENT_BASE VARCHAR2(1)
244 );
245
246 TYPE mmtt_type
247 IS TABLE OF task_rec_type INDEX BY binary_integer;
248
249 PROCEDURE cartonize
250 ( x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2,
253 x_task_table OUT NOCOPY mmtt_type,
254 p_organization_id IN NUMBER,
255 p_task_table IN mmtt_type
256 );
257
258 END WMS_CARTONIZATION_USER_PUB;