[Home] [Help]
PACKAGE: APPS.WSM_WIP_LOT_TXN_PVT
Source
1 package WSM_WIP_LOT_TXN_PVT as
2 /* $Header: WSMVWIPS.pls 120.4 2006/06/14 22:07:40 skaradib noship $ */
3
4 /* Record type for the transaction header */
5
6 type WLTX_TRANSACTIONS_REC_TYPE is record
7 (
8 /* Transaction info */
9 TRANSACTION_TYPE_ID WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_TYPE_ID%TYPE,
10 TRANSACTION_DATE WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_DATE%TYPE,
11 TRANSACTION_REFERENCE WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_REFERENCE%TYPE,
12 REASON_ID WSM_SPLIT_MERGE_TRANSACTIONS.REASON_ID%TYPE,
13 TRANSACTION_ID WSM_SPLIT_MERGE_TRANSACTIONS.TRANSACTION_ID%TYPE,
14
15 /*Added for MES*/
16 EMPLOYEE_ID WSM_SPLIT_MERGE_TRANSACTIONS.EMPLOYEE_ID%TYPE,
17
18 /* Org info */
19 ORGANIZATION_CODE org_organization_definitions.ORGANIZATION_CODE%TYPE,
20 ORGANIZATION_ID WSM_SPLIT_MERGE_TRANSACTIONS.ORGANIZATION_ID%TYPE,
21
22 ERROR_MESSAGE WSM_SPLIT_MERGE_TRANSACTIONS.ERROR_MESSAGE%TYPE,
23
24 ATTRIBUTE_CATEGORY WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
25 ATTRIBUTE1 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE1%TYPE,
26 ATTRIBUTE2 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE2%TYPE,
27 ATTRIBUTE3 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE3%TYPE,
28 ATTRIBUTE4 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE4%TYPE,
29 ATTRIBUTE5 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE5%TYPE,
30 ATTRIBUTE6 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE6%TYPE,
31 ATTRIBUTE7 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE7%TYPE,
32 ATTRIBUTE8 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE8%TYPE,
33 ATTRIBUTE9 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE9%TYPE,
34 ATTRIBUTE10 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE10%TYPE,
35 ATTRIBUTE11 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE11%TYPE,
36 ATTRIBUTE12 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE12%TYPE,
37 ATTRIBUTE13 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE13%TYPE,
38 ATTRIBUTE14 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE14%TYPE,
39 ATTRIBUTE15 WSM_SPLIT_MERGE_TRANSACTIONS.ATTRIBUTE15%TYPE
40
41 );
42
43 type WLTX_STARTING_JOBS_REC_TYPE is record
44 (
45 /* Job header kinda.....*/
46 WIP_ENTITY_ID WSM_SM_STARTING_JOBS.WIP_ENTITY_ID%TYPE,
47 WIP_ENTITY_NAME WSM_SM_STARTING_JOBS.WIP_ENTITY_NAME%TYPE,
48 JOB_TYPE NUMBER,
49 STATUS_TYPE WIP_DISCRETE_JOBS.status_type%type,
50 DESCRIPTION WIP_ENTITIES.DESCRIPTION%type,
51 REPRESENTATIVE_FLAG WSM_SM_STARTING_JOBS.REPRESENTATIVE_FLAG%TYPE,
52 SERIAL_TRACK_FLAG NUMBER, -- ST : Serial Support Project --
53
54 /* Primary info....*/
55 CLASS_CODE WIP_DISCRETE_JOBS.CLASS_CODE%type,
56 DEMAND_CLASS WIP_DISCRETE_JOBS.DEMAND_CLASS%type,
57 ORGANIZATION_CODE org_organization_definitions.ORGANIZATION_CODE%TYPE, /* Entry not in the base table */
58 PRIMARY_ITEM_ID WSM_SM_STARTING_JOBS.PRIMARY_ITEM_ID%TYPE,
59 ITEM_NAME mtl_system_items_b_kfv.concatenated_segments%type,
60 ORGANIZATION_ID WSM_SM_STARTING_JOBS.ORGANIZATION_ID%TYPE,
61
62 /* Current operation infor....*/
63 INTRAOPERATION_STEP WSM_SM_STARTING_JOBS.INTRAOPERATION_STEP%TYPE,
64 OPERATION_SEQ_NUM WIP_OPERATIONS.OPERATION_SEQ_NUM%TYPE,
65 OPERATION_CODE BOM_STANDARD_OPERATIONS.OPERATION_CODE%TYPE,
66 OPERATION_DESCRIPTION BOM_OPERATION_SEQUENCES.OPERATION_DESCRIPTION%TYPE,
67 OPERATION_SEQ_ID WIP_OPERATIONS.OPERATION_SEQUENCE_ID%TYPE,
68 STANDARD_OPERATION_ID WIP_OPERATIONS.STANDARD_OPERATION_ID%TYPE,
69 DEPARTMENT_ID WSM_SM_STARTING_JOBS.DEPARTMENT_ID%TYPE,
70 DEPARTMENT_CODE BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE,
71
72 /* Quantity info */
73 START_QUANTITY WSM_SM_STARTING_JOBS.job_START_QUANTITY%TYPE,
74 QUANTITY_AVAILABLE WSM_SM_STARTING_JOBS.AVAILABLE_QUANTITY%TYPE,
75 NET_QUANTITY WSM_SM_STARTING_JOBS.NET_QUANTITY%TYPE,
76
77 /* BOM and routing */
78 ROUTING_REFERENCE_ID WSM_SM_STARTING_JOBS.ROUTING_REFERENCE_ID%TYPE,
79 BOM_REFERENCE_ID WSM_SM_STARTING_JOBS.BOM_REFERENCE_ID%TYPE,
80 COMMON_BILL_SEQUENCE_ID WSM_SM_STARTING_JOBS.BILL_SEQUENCE_ID%TYPE,
81 BOM_REVISION WSM_SM_STARTING_JOBS.BOM_REVISION%TYPE,
82 BOM_REVISION_DATE WSM_SM_STARTING_JOBS.BOM_REVISION_DATE%TYPE,
83 ALTERNATE_BOM_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_BOM_DESIGNATOR%TYPE,
84 ALTERNATE_ROUTING_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_ROUTING_DESIGNATOR%TYPE,
85 COMMON_ROUTING_SEQUENCE_ID WSM_SM_STARTING_JOBS.ROUTING_SEQ_ID%TYPE,
86 ROUTING_REVISION WSM_SM_STARTING_JOBS.ROUTING_REVISION%TYPE,
87 ROUTING_REVISION_DATE WSM_SM_STARTING_JOBS.ROUTING_REVISION_DATE%TYPE,
88
89 /* Completion subinv info.... */
90 COMPLETION_SUBINVENTORY WSM_SM_STARTING_JOBS.COMPLETION_SUBINVENTORY%TYPE,
91 COMPLETION_LOCATOR_ID WSM_SM_STARTING_JOBS.COMPLETION_LOCATOR_ID%TYPE,
92 COMPLETION_LOCATOR mtl_item_locations_kfv.concatenated_segments%TYPE,
93
94 /* Dates info... */
95 DATE_RELEASED WIP_DISCRETE_JOBS.DATE_RELEASED%TYPE,
96 SCHEDULED_START_DATE WSM_SM_STARTING_JOBS.SCHEDULED_START_DATE%TYPE,
97 SCHEDULED_COMPLETION_DATE WSM_SM_STARTING_JOBS.SCHEDULED_COMPLETION_DATE%TYPE,
98
99 /* Parameters.... */
100 COPRODUCTS_SUPPLY WSM_SM_STARTING_JOBS.COPRODUCTS_SUPPLY%TYPE,
101 KANBAN_CARD_ID WIP_DISCRETE_JOBS.KANBAN_CARD_ID%TYPE,
102 WIP_SUPPLY_TYPE WIP_DISCRETE_JOBS.WIP_SUPPLY_TYPE%TYPE,
103 /* add wip_supply type..... */
104
105 ATTRIBUTE_CATEGORY WSM_SM_STARTING_JOBS.ATTRIBUTE_CATEGORY%TYPE,
106 ATTRIBUTE1 WSM_SM_STARTING_JOBS.ATTRIBUTE1%TYPE,
107 ATTRIBUTE2 WSM_SM_STARTING_JOBS.ATTRIBUTE2%TYPE,
108 ATTRIBUTE3 WSM_SM_STARTING_JOBS.ATTRIBUTE3%TYPE,
109 ATTRIBUTE4 WSM_SM_STARTING_JOBS.ATTRIBUTE4%TYPE,
110 ATTRIBUTE5 WSM_SM_STARTING_JOBS.ATTRIBUTE5%TYPE,
111 ATTRIBUTE6 WSM_SM_STARTING_JOBS.ATTRIBUTE6%TYPE,
112 ATTRIBUTE7 WSM_SM_STARTING_JOBS.ATTRIBUTE7%TYPE,
113 ATTRIBUTE8 WSM_SM_STARTING_JOBS.ATTRIBUTE8%TYPE,
114 ATTRIBUTE9 WSM_SM_STARTING_JOBS.ATTRIBUTE9%TYPE,
115 ATTRIBUTE10 WSM_SM_STARTING_JOBS.ATTRIBUTE10%TYPE,
116 ATTRIBUTE11 WSM_SM_STARTING_JOBS.ATTRIBUTE11%TYPE,
117 ATTRIBUTE12 WSM_SM_STARTING_JOBS.ATTRIBUTE12%TYPE,
118 ATTRIBUTE13 WSM_SM_STARTING_JOBS.ATTRIBUTE13%TYPE,
119 ATTRIBUTE14 WSM_SM_STARTING_JOBS.ATTRIBUTE14%TYPE,
120 ATTRIBUTE15 WSM_SM_STARTING_JOBS.ATTRIBUTE15%TYPE
121
122 );
123
124
125 type WLTX_RESULTING_JOBS_REC_TYPE is record
126 (
127 /* jOB HEADER */
128 WIP_ENTITY_NAME WSM_SM_RESULTING_JOBS.WIP_ENTITY_NAME%TYPE,
129 WIP_ENTITY_ID WSM_SM_RESULTING_JOBS.WIP_ENTITY_ID%TYPE,
130 DESCRIPTION WSM_SM_RESULTING_JOBS.DESCRIPTION%TYPE,
131 JOB_TYPE WSM_SM_RESULTING_JOBS.JOB_TYPE%TYPE,
132 STATUS_TYPE WIP_DISCRETE_JOBS.STATUS_TYPE%TYPE,
133 wip_supply_type WIP_DISCRETE_JOBS.wip_supply_type%TYPE,
134
135 /* Primary details */
136 ORGANIZATION_ID WSM_SM_RESULTING_JOBS.ORGANIZATION_ID%TYPE,
137 ORGANIZATION_CODE org_organization_definitions.ORGANIZATION_CODE%TYPE, /* Entry not in the base table */
138 ITEM_NAME MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS%TYPE,
139 PRIMARY_ITEM_ID WSM_SM_RESULTING_JOBS.PRIMARY_ITEM_ID%TYPE,
140 CLASS_CODE WSM_SM_RESULTING_JOBS.CLASS_CODE%TYPE,
141
142 /* Bom and Routing */
143 BOM_REFERENCE_ITEM MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS%TYPE,
144 BOM_REFERENCE_ID WSM_SM_RESULTING_JOBS.BOM_REFERENCE_ID%TYPE,
145
146 ROUTING_REFERENCE_ITEM MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS%TYPE,
147 ROUTING_REFERENCE_ID WSM_SM_RESULTING_JOBS.ROUTING_REFERENCE_ID%TYPE,
148 COMMON_BOM_SEQUENCE_ID WSM_SM_RESULTING_JOBS.COMMON_BOM_SEQUENCE_ID%TYPE,
149 COMMON_ROUTING_SEQUENCE_ID WSM_SM_RESULTING_JOBS.COMMON_ROUTING_SEQUENCE_ID%TYPE,
150 BOM_REVISION WSM_SM_RESULTING_JOBS.BOM_REVISION%TYPE,
151 ROUTING_REVISION WSM_SM_RESULTING_JOBS.ROUTING_REVISION%TYPE,
152 BOM_REVISION_DATE WSM_SM_RESULTING_JOBS.BOM_REVISION_DATE%TYPE,
153 ROUTING_REVISION_DATE WSM_SM_RESULTING_JOBS.ROUTING_REVISION_DATE%TYPE,
154 ALTERNATE_BOM_DESIGNATOR WSM_SM_RESULTING_JOBS.ALTERNATE_BOM_DESIGNATOR%TYPE,
155 ALTERNATE_ROUTING_DESIGNATOR WSM_SM_RESULTING_JOBS.ALTERNATE_ROUTING_DESIGNATOR%TYPE,
156
157 /* Quantity */
158 START_QUANTITY WSM_SM_RESULTING_JOBS.START_QUANTITY%TYPE,
159 NET_QUANTITY WSM_SM_RESULTING_JOBS.NET_QUANTITY%TYPE,
160
161 /* Starting operation */
162 STARTING_OPERATION_SEQ_NUM WSM_SM_RESULTING_JOBS.STARTING_OPERATION_SEQ_NUM%TYPE,
163 STARTING_INTRAOPERATION_STEP WSM_SM_RESULTING_JOBS.STARTING_INTRAOPERATION_STEP%TYPE,
164 STARTING_OPERATION_CODE WSM_SM_RESULTING_JOBS.STARTING_OPERATION_CODE%TYPE,
165 STARTING_OPERATION_SEQ_ID BOM_OPERATION_SEQUENCES.OPERATION_SEQUENCE_ID%TYPE,
166 STARTING_STD_OP_ID WSM_SM_RESULTING_JOBS.STARTING_STD_OP_ID%TYPE,
167 DEPARTMENT_ID BOM_DEPARTMENTS.DEPARTMENT_ID%TYPE,
168 DEPARTMENT_CODE BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE,
169 OPERATION_DESCRIPTION BOM_OPERATION_SEQUENCES.OPERATION_DESCRIPTION%TYPE,
170
171 JOB_OPERATION_SEQ_NUM WSM_SM_RESULTING_JOBS.JOB_OPERATION_SEQ_NUM%TYPE,
172
173 /* Specifi to split txn...*/
174 SPLIT_HAS_UPDATE_ASSY WSM_SM_RESULTING_JOBS.SPLIT_HAS_UPDATE_ASSY%TYPE,
175
176 /* Completion sub inv details...*/
177 COMPLETION_SUBINVENTORY WSM_SM_RESULTING_JOBS.COMPLETION_SUBINVENTORY%TYPE,
178 COMPLETION_LOCATOR_ID WSM_SM_RESULTING_JOBS.COMPLETION_LOCATOR_ID%TYPE,
179 COMPLETION_LOCATOR mtl_item_locations_kfv.concatenated_segments%TYPE,
180
181 /* Dates */
182 SCHEDULED_START_DATE WSM_SM_RESULTING_JOBS.SCHEDULED_START_DATE%TYPE,
183 SCHEDULED_COMPLETION_DATE WSM_SM_RESULTING_JOBS.SCHEDULED_COMPLETION_DATE%TYPE,
184
185 /* Other parameters */
186 BONUS_ACCT_ID WSM_SM_RESULTING_JOBS.BONUS_ACCT_ID%TYPE,
187 COPRODUCTS_SUPPLY WSM_SM_RESULTING_JOBS.COPRODUCTS_SUPPLY%TYPE,
188 KANBAN_CARD_ID WIP_DISCRETE_JOBS.KANBAN_CARD_ID%TYPE,
189
190 ATTRIBUTE_CATEGORY WSM_SM_RESULTING_JOBS.ATTRIBUTE_CATEGORY%TYPE,
191 ATTRIBUTE1 WSM_SM_RESULTING_JOBS.ATTRIBUTE1%TYPE,
192 ATTRIBUTE2 WSM_SM_RESULTING_JOBS.ATTRIBUTE2%TYPE,
193 ATTRIBUTE3 WSM_SM_RESULTING_JOBS.ATTRIBUTE3%TYPE,
194 ATTRIBUTE4 WSM_SM_RESULTING_JOBS.ATTRIBUTE4%TYPE,
195 ATTRIBUTE5 WSM_SM_RESULTING_JOBS.ATTRIBUTE5%TYPE,
196 ATTRIBUTE6 WSM_SM_RESULTING_JOBS.ATTRIBUTE6%TYPE,
197 ATTRIBUTE7 WSM_SM_RESULTING_JOBS.ATTRIBUTE7%TYPE,
198 ATTRIBUTE8 WSM_SM_RESULTING_JOBS.ATTRIBUTE8%TYPE,
199 ATTRIBUTE9 WSM_SM_RESULTING_JOBS.ATTRIBUTE9%TYPE,
200 ATTRIBUTE10 WSM_SM_RESULTING_JOBS.ATTRIBUTE10%TYPE,
201 ATTRIBUTE11 WSM_SM_RESULTING_JOBS.ATTRIBUTE11%TYPE,
202 ATTRIBUTE12 WSM_SM_RESULTING_JOBS.ATTRIBUTE12%TYPE,
203 ATTRIBUTE13 WSM_SM_RESULTING_JOBS.ATTRIBUTE13%TYPE,
204 ATTRIBUTE14 WSM_SM_RESULTING_JOBS.ATTRIBUTE14%TYPE,
205 ATTRIBUTE15 WSM_SM_RESULTING_JOBS.ATTRIBUTE15%TYPE --,
206
207 /* Request ID and other WHO columns will be obtained from the header record for every txn
208
209 REQUEST_ID WSM_SM_STARTING_JOBS.REQUEST_ID%TYPE,
210 PROGRAM_APPLICATION_ID WSM_SM_STARTING_JOBS.PROGRAM_APPLICATION_ID%TYPE,
211 PROGRAM_ID WSM_SM_STARTING_JOBS.PROGRAM_ID%TYPE,
212 PROGRAM_UPDATE_DATE WSM_SM_STARTING_JOBS.PROGRAM_UPDATE_DATE%TYPE,
213
214
215 LAST_UPDATE_DATE WSM_SM_STARTING_JOBS.LAST_UPDATE_DATE%TYPE,
216 LAST_UPDATED_BY WSM_SM_STARTING_JOBS.LAST_UPDATED_BY%TYPE,
217 CREATION_DATE WSM_SM_STARTING_JOBS.CREATION_DATE%TYPE,
218 CREATED_BY WSM_SM_STARTING_JOBS.CREATED_BY%TYPE,
219 LAST_UPDATE_LOGIN WSM_SM_STARTING_JOBS.LAST_UPDATE_LOGIN%TYPE */
220
221 );
222
223
224 TYPE WSM_JOB_SECONDARY_QTY_REC_TYPE IS RECORD
225 (
226 wip_entity_id wip_entities.wip_entity_id%type,
227 wip_entity_name wip_entities.wip_entity_name%type,
228 organization_id wsm_job_secondary_quantities.organization_id%type,
229 uom_code wsm_job_secondary_quantities.uom_code%type,
230 current_quantity wsm_job_secondary_quantities.current_quantity%type,
231 currently_active wsm_job_secondary_quantities.currently_active%type
232 );
233
234 type WSM_JOB_SECONDARY_QTY_TBL_TYPE is table of WSM_JOB_SECONDARY_QTY_REC_TYPE index by BINARY_INTEGER;
235
236 type WLTX_STARTING_JOBS_TBL_TYPE is table of WLTX_STARTING_JOBS_REC_TYPE index by BINARY_INTEGER;
237 type WLTX_RESULTING_JOBS_TBL_TYPE is table of WLTX_RESULTING_JOBS_REC_TYPE index by BINARY_INTEGER;
238
239 -- Public APIs
240 -- ST : Added for bug 5263262
241 -- OverLoaded procedure created for the bug...
242 PROCEDURE invoke_txn_API ( p_api_version IN NUMBER ,
243 p_commit IN VARCHAR2 ,
244 p_validation_level IN NUMBER ,
245 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
246 p_calling_mode IN NUMBER ,
247 p_txn_header_rec IN WLTX_TRANSACTIONS_REC_TYPE ,
248 p_starting_jobs_tbl IN WLTX_STARTING_JOBS_TBL_TYPE ,
249 p_resulting_jobs_tbl IN WLTX_RESULTING_JOBS_TBL_TYPE ,
250 P_wsm_serial_num_tbl IN WSM_SERIAL_SUPPORT_GRP.WSM_SERIAL_NUM_TBL ,
251 p_secondary_qty_tbl IN WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
252 -- ST : Added for bug 5263262 (Will have value 0 from interface and NULL from forms and MES) --
253 --bugs 5334285, 5334279 addition of the new optional parameter p_invoke_req_worker to procedure
254 --invoke_txn_API in package WSM_WIP_LOT_TXN_PVT caused WSMPLBMI to become invalid. Since notational
255 --parameters are used in WSMPLBMI and the new parameter is optional effectively there are signatures
256 --of invoke_txn_API matching this call. Hence making p_invoke_req_worker required without the default
257 --p_invoke_req_worker IN NUMBER DEFAULT NULL ,
258 p_invoke_req_worker IN NUMBER ,
259 x_return_status OUT NOCOPY VARCHAR2 ,
260 x_msg_count OUT NOCOPY NUMBER ,
261 x_error_msg OUT NOCOPY VARCHAR2
262 );
263
264
265 PROCEDURE invoke_txn_API ( p_api_version IN NUMBER ,
266 p_commit IN VARCHAR2 ,
267 p_validation_level IN NUMBER ,
268 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
269 p_calling_mode IN NUMBER ,
270 p_txn_header_rec IN WLTX_TRANSACTIONS_REC_TYPE ,
271 p_starting_jobs_tbl IN WLTX_STARTING_JOBS_TBL_TYPE ,
272 p_resulting_jobs_tbl IN WLTX_RESULTING_JOBS_TBL_TYPE ,
273 P_wsm_serial_num_tbl IN WSM_SERIAL_SUPPORT_GRP.WSM_SERIAL_NUM_TBL ,
274 p_secondary_qty_tbl IN WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
275 x_return_status OUT NOCOPY VARCHAR2 ,
276 x_msg_count OUT NOCOPY NUMBER ,
277 x_error_msg OUT NOCOPY VARCHAR2
278 );
279
280 -- API for Split transaction....
281 PROCEDURE SPLIT_TXN ( p_api_version IN NUMBER ,
282 p_commit IN VARCHAR2 DEFAULT NULL ,
283 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
284 p_validation_level IN NUMBER DEFAULT NULL ,
285 p_calling_mode IN NUMBER ,
286 p_wltx_header IN OUT NOCOPY WLTX_TRANSACTIONS_REC_TYPE ,
287 p_wltx_starting_job_rec IN OUT NOCOPY WLTX_STARTING_JOBS_REC_TYPE ,
288 p_wltx_resulting_jobs_tbl IN OUT NOCOPY WLTX_RESULTING_JOBS_TBL_TYPE ,
289 p_wltx_secondary_qty_tbl IN OUT NOCOPY WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
290 x_return_status OUT NOCOPY VARCHAR2 ,
291 x_msg_count OUT NOCOPY NUMBER ,
292 x_msg_data OUT NOCOPY VARCHAR2
293 );
294
295 /* API for Merge transaction.... */
296 PROCEDURE MERGE_TXN ( p_api_version IN NUMBER ,
297 p_commit IN VARCHAR2 DEFAULT NULL ,
298 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
299 p_validation_level IN NUMBER DEFAULT NULL ,
300 p_calling_mode IN NUMBER ,
301 p_wltx_header IN OUT NOCOPY WLTX_TRANSACTIONS_REC_TYPE ,
302 p_wltx_starting_jobs_tbl IN OUT NOCOPY WLTX_STARTING_JOBS_TBL_TYPE ,
303 p_wltx_resulting_job_rec IN OUT NOCOPY WLTX_RESULTING_JOBS_REC_TYPE ,
304 p_wltx_secondary_qty_tbl IN OUT NOCOPY WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
305 x_return_status OUT NOCOPY VARCHAR2 ,
306 x_msg_count OUT NOCOPY NUMBER ,
307 x_msg_data OUT NOCOPY VARCHAR2
308 );
309
310
311 /* API for Update Assembly transaction.... */
312 PROCEDURE UPDATE_ASSEMBLY_TXN ( p_api_version IN NUMBER,
313 p_commit IN VARCHAR2 DEFAULT NULL,
314 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
315 p_validation_level IN NUMBER DEFAULT NULL,
316 p_calling_mode IN NUMBER,
317 p_wltx_header IN OUT NOCOPY WLTX_TRANSACTIONS_REC_TYPE,
318 p_wltx_starting_job_rec IN OUT NOCOPY WLTX_STARTING_JOBS_REC_TYPE,
319 p_wltx_resulting_job_rec IN OUT NOCOPY WLTX_RESULTING_JOBS_REC_TYPE,
320 p_wltx_secondary_qty_tbl IN OUT NOCOPY WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
321 x_return_status OUT NOCOPY VARCHAR2,
322 x_msg_count OUT NOCOPY NUMBER,
323 x_msg_data OUT NOCOPY VARCHAR2
324 );
325
326 /* API for Update Routing transaction.... */
327 PROCEDURE UPDATE_ROUTING_TXN ( p_api_version IN NUMBER,
328 p_commit IN VARCHAR2 DEFAULT NULL,
329 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
330 p_validation_level IN NUMBER DEFAULT NULL,
331 p_calling_mode IN NUMBER,
332 p_wltx_header IN OUT NOCOPY WLTX_TRANSACTIONS_REC_TYPE,
333 p_wltx_starting_job_rec IN OUT NOCOPY WLTX_STARTING_JOBS_REC_TYPE,
334 p_wltx_resulting_job_rec IN OUT NOCOPY WLTX_RESULTING_JOBS_REC_TYPE,
335 p_wltx_secondary_qty_tbl IN OUT NOCOPY WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
336 x_return_status OUT NOCOPY VARCHAR2,
337 x_msg_count OUT NOCOPY NUMBER,
338 x_msg_data OUT NOCOPY VARCHAR2
339 );
340
341 /* API for Update Quantity transaction.... */
342 PROCEDURE UPDATE_QUANTITY_TXN ( p_api_version IN NUMBER,
343 p_commit IN VARCHAR2 DEFAULT NULL,
344 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
345 p_validation_level IN NUMBER DEFAULT NULL,
346 p_calling_mode IN NUMBER,
347 p_wltx_header IN OUT NOCOPY WLTX_TRANSACTIONS_REC_TYPE,
348 p_wltx_starting_job_rec IN OUT NOCOPY WLTX_STARTING_JOBS_REC_TYPE,
349 p_wltx_resulting_job_rec IN OUT NOCOPY WLTX_RESULTING_JOBS_REC_TYPE,
350 p_wltx_secondary_qty_tbl IN OUT NOCOPY WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
351 x_return_status OUT NOCOPY VARCHAR2,
352 x_msg_count OUT NOCOPY NUMBER,
353 x_msg_data OUT NOCOPY VARCHAR2
354 );
355
356 /* API for Update Lot name transaction.... */
357 PROCEDURE UPDATE_LOTNAME_TXN ( p_api_version IN NUMBER ,
358 p_commit IN VARCHAR2 DEFAULT NULL ,
359 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
360 p_validation_level IN NUMBER DEFAULT NULL ,
361 p_calling_mode IN NUMBER ,
362 p_wltx_header IN OUT NOCOPY WLTX_TRANSACTIONS_REC_TYPE ,
363 p_wltx_starting_job_rec IN OUT NOCOPY WLTX_STARTING_JOBS_REC_TYPE ,
364 p_wltx_resulting_job_rec IN OUT NOCOPY WLTX_RESULTING_JOBS_REC_TYPE ,
365 p_wltx_secondary_qty_tbl IN OUT NOCOPY WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
366 x_return_status OUT NOCOPY VARCHAR2 ,
367 x_msg_count OUT NOCOPY NUMBER ,
368 x_msg_data OUT NOCOPY VARCHAR2
369 );
370
371 Procedure BONUS_TXN ( p_api_version IN NUMBER ,
372 p_commit IN VARCHAR2 DEFAULT NULL ,
373 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
374 p_validation_level IN NUMBER DEFAULT NULL ,
375 p_calling_mode IN NUMBER ,
376 p_wltx_header IN OUT NOCOPY WLTX_TRANSACTIONS_REC_TYPE ,
377 p_wltx_resulting_job_rec IN OUT NOCOPY WLTX_RESULTING_JOBS_REC_TYPE ,
378 p_wltx_secondary_qty_tbl IN OUT NOCOPY WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
379 x_return_status OUT NOCOPY VARCHAR2 ,
380 x_msg_count OUT NOCOPY NUMBER ,
381 x_msg_data OUT NOCOPY VARCHAR2
382 );
383
384 /* APIs not coded.... start */
385 PROCEDURE UPDATE_BOM ( p_api_version IN VARCHAR2 ,
386 p_commit IN VARCHAR2 DEFAULT NULL ,
387 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
388 p_validation_level IN NUMBER DEFAULT NULL ,
389 p_wltx_header IN OUT NOCOPY WLTX_TRANSACTIONS_REC_TYPE ,
390 p_wltx_starting_job_rec IN OUT NOCOPY WLTX_STARTING_JOBS_REC_TYPE ,
391 p_wltx_resulting_job_rec IN OUT NOCOPY WLTX_RESULTING_JOBS_REC_TYPE ,
392 x_return_status OUT NOCOPY VARCHAR2 ,
393 x_msg_count OUT NOCOPY NUMBER ,
394 x_msg_data OUT NOCOPY VARCHAR2
395 );
396
397 PROCEDURE UPDATE_STATUS ( p_api_version IN VARCHAR2 ,
398 p_commit IN VARCHAR2 DEFAULT NULL ,
399 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
400 p_validation_level IN NUMBER DEFAULT NULL ,
401 p_wltx_header IN OUT NOCOPY WLTX_TRANSACTIONS_REC_TYPE ,
402 p_wltx_starting_job_rec IN OUT NOCOPY WLTX_STARTING_JOBS_REC_TYPE ,
403 p_wltx_resulting_job_rec IN OUT NOCOPY WLTX_RESULTING_JOBS_REC_TYPE ,
404 x_return_status OUT NOCOPY VARCHAR2 ,
405 x_msg_count OUT NOCOPY NUMBER ,
406 x_msg_data OUT NOCOPY VARCHAR2
407 );
408
409
410 PROCEDURE UPDATE_COMP_SUBINV_LOC( p_api_version IN VARCHAR2 ,
411 p_commit IN VARCHAR2 DEFAULT NULL ,
412 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
413 p_validation_level IN NUMBER DEFAULT NULL ,
414 p_wltx_header IN OUT NOCOPY WLTX_TRANSACTIONS_REC_TYPE ,
415 p_wltx_starting_job_rec IN OUT NOCOPY WLTX_STARTING_JOBS_REC_TYPE ,
416 p_wltx_resulting_job_rec IN OUT NOCOPY WLTX_RESULTING_JOBS_REC_TYPE ,
417 x_return_status OUT NOCOPY VARCHAR2 ,
418 x_msg_count OUT NOCOPY NUMBER ,
419 x_msg_data OUT NOCOPY VARCHAR2
420 );
421
422 -- This procedure is added to log the transaction related data..
423 Procedure Log_transaction_data ( p_txn_header_rec IN WLTX_TRANSACTIONS_REC_TYPE ,
424 p_starting_jobs_tbl IN WLTX_STARTING_JOBS_TBL_TYPE ,
425 p_resulting_jobs_tbl IN WLTX_RESULTING_JOBS_TBL_TYPE ,
426 p_secondary_qty_tbl IN WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
427 x_return_status OUT NOCOPY VARCHAR2 ,
428 x_msg_count OUT NOCOPY NUMBER ,
429 x_error_msg OUT NOCOPY VARCHAR2
430 );
431 /* APIs not coded.... end */
432 end WSM_WIP_LOT_TXN_PVT;