[Home] [Help]
PACKAGE: APPS.CSP_MATERIAL_TRANSACTIONS_PVT
Source
1 PACKAGE CSP_MATERIAL_TRANSACTIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvmmts.pls 120.1 2006/07/20 06:07:03 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name : CSP_MATERIAL_TRANSACTIONS_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:CSP_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- TRANSACTION_HEADER_ID
19 -- TRANSACTION_TEMP_ID
20 -- SOURCE_CODE
21 -- SOURCE_LINE_ID
22 -- TRANSACTION_MODE
23 -- LOCK_FLAG
24 -- LAST_UPDATE_DATE
25 -- LAST_UPDATED_BY
26 -- CREATION_DATE
27 -- CREATED_BY
28 -- LAST_UPDATE_LOGIN
29 -- REQUEST_ID
30 -- PROGRAM_APPLICATION_ID
31 -- PROGRAM_ID
32 -- PROGRAM_UPDATE_DATE
33 -- INVENTORY_ITEM_ID
34 -- REVISION
35 -- ORGANIZATION_ID
36 -- SUBINVENTORY_CODE
37 -- LOCATOR_ID
38 -- TRANSACTION_QUANTITY
39 -- PRIMARY_QUANTITY
40 -- TRANSACTION_UOM
41 -- TRANSACTION_COST
42 -- TRANSACTION_TYPE_ID
43 -- TRANSACTION_ACTION_ID
44 -- TRANSACTION_SOURCE_TYPE_ID
45 -- TRANSACTION_SOURCE_ID
46 -- TRANSACTION_SOURCE_NAME
47 -- TRANSACTION_DATE
48 -- ACCT_PERIOD_ID
49 -- DISTRIBUTION_ACCOUNT_ID
50 -- TRANSACTION_REFERENCE
51 -- REQUISITION_LINE_ID
52 -- REQUISITION_DISTRIBUTION_ID
53 -- REASON_ID
54 -- LOT_NUMBER
55 -- LOT_EXPIRATION_DATE
56 -- SERIAL_NUMBER
57 -- RECEIVING_DOCUMENT
58 -- DEMAND_ID
59 -- RCV_TRANSACTION_ID
60 -- MOVE_TRANSACTION_ID
61 -- COMPLETION_TRANSACTION_ID
62 -- WIP_ENTITY_TYPE
63 -- SCHEDULE_ID
64 -- REPETITIVE_LINE_ID
65 -- EMPLOYEE_CODE
66 -- PRIMARY_SWITCH
67 -- SCHEDULE_UPDATE_CODE
68 -- SETUP_TEARDOWN_CODE
69 -- ITEM_ORDERING
70 -- NEGATIVE_REQ_FLAG
71 -- OPERATION_SEQ_NUM
72 -- PICKING_LINE_ID
73 -- TRX_SOURCE_LINE_ID
74 -- TRX_SOURCE_DELIVERY_ID
75 -- PHYSICAL_ADJUSTMENT_ID
76 -- CYCLE_COUNT_ID
77 -- RMA_LINE_ID
78 -- CUSTOMER_SHIP_ID
79 -- CURRENCY_CODE
80 -- CURRENCY_CONVERSION_RATE
81 -- CURRENCY_CONVERSION_TYPE
82 -- CURRENCY_CONVERSION_DATE
83 -- USSGL_TRANSACTION_CODE
84 -- VENDOR_LOT_NUMBER
85 -- ENCUMBRANCE_ACCOUNT
86 -- ENCUMBRANCE_AMOUNT
87 -- SHIP_TO_LOCATION
88 -- SHIPMENT_NUMBER
89 -- TRANSFER_COST
90 -- TRANSPORTATION_COST
91 -- TRANSPORTATION_ACCOUNT
92 -- FREIGHT_CODE
93 -- CONTAINERS
94 -- WAYBILL_AIRBILL
95 -- EXPECTED_ARRIVAL_DATE
96 -- TRANSFER_SUBINVENTORY
97 -- TRANSFER_ORGANIZATION
98 -- TRANSFER_TO_LOCATION
99 -- NEW_AVERAGE_COST
100 -- VALUE_CHANGE
101 -- PERCENTAGE_CHANGE
102 -- MATERIAL_ALLOCATION_TEMP_ID
103 -- DEMAND_SOURCE_HEADER_ID
104 -- DEMAND_SOURCE_LINE
105 -- DEMAND_SOURCE_DELIVERY
106 -- ITEM_SEGMENTS
107 -- ITEM_DESCRIPTION
108 -- ITEM_TRX_ENABLED_FLAG
109 -- ITEM_LOCATION_CONTROL_CODE
110 -- ITEM_RESTRICT_SUBINV_CODE
111 -- ITEM_RESTRICT_LOCATORS_CODE
112 -- ITEM_REVISION_QTY_CONTROL_CODE
113 -- ITEM_PRIMARY_UOM_CODE
114 -- ITEM_UOM_CLASS
115 -- ITEM_SHELF_LIFE_CODE
116 -- ITEM_SHELF_LIFE_DAYS
117 -- ITEM_LOT_CONTROL_CODE
118 -- ITEM_SERIAL_CONTROL_CODE
119 -- ITEM_INVENTORY_ASSET_FLAG
120 -- ALLOWED_UNITS_LOOKUP_CODE
121 -- DEPARTMENT_ID
122 -- DEPARTMENT_CODE
123 -- WIP_SUPPLY_TYPE
124 -- SUPPLY_SUBINVENTORY
125 -- SUPPLY_LOCATOR_ID
126 -- VALID_SUBINVENTORY_FLAG
127 -- VALID_LOCATOR_FLAG
128 -- LOCATOR_SEGMENTS
129 -- CURRENT_LOCATOR_CONTROL_CODE
130 -- NUMBER_OF_LOTS_ENTERED
131 -- WIP_COMMIT_FLAG
132 -- NEXT_LOT_NUMBER
133 -- LOT_ALPHA_PREFIX
134 -- NEXT_SERIAL_NUMBER
135 -- SERIAL_ALPHA_PREFIX
136 -- SHIPPABLE_FLAG
137 -- POSTING_FLAG
138 -- REQUIRED_FLAG
139 -- PROCESS_FLAG
140 -- ERROR_CODE
141 -- ERROR_EXPLANATION
142 -- ATTRIBUTE_CATEGORY
143 -- ATTRIBUTE1
144 -- ATTRIBUTE2
145 -- ATTRIBUTE3
146 -- ATTRIBUTE4
147 -- ATTRIBUTE5
148 -- ATTRIBUTE6
149 -- ATTRIBUTE7
150 -- ATTRIBUTE8
151 -- ATTRIBUTE9
152 -- ATTRIBUTE10
153 -- ATTRIBUTE11
154 -- ATTRIBUTE12
155 -- ATTRIBUTE13
156 -- ATTRIBUTE14
157 -- ATTRIBUTE15
158 -- MOVEMENT_ID
159 -- RESERVATION_QUANTITY
160 -- SHIPPED_QUANTITY
161 -- TRANSACTION_LINE_NUMBER
162 -- TASK_ID
163 -- TO_TASK_ID
164 -- SOURCE_TASK_ID
165 -- PROJECT_ID
166 -- SOURCE_PROJECT_ID
167 -- PA_EXPENDITURE_ORG_ID
168 -- TO_PROJECT_ID
169 -- EXPENDITURE_TYPE
170 -- FINAL_COMPLETION_FLAG
171 -- TRANSFER_PERCENTAGE
172 -- TRANSACTION_SEQUENCE_ID
173 -- MATERIAL_ACCOUNT
174 -- MATERIAL_OVERHEAD_ACCOUNT
175 -- RESOURCE_ACCOUNT
176 -- OUTSIDE_PROCESSING_ACCOUNT
177 -- OVERHEAD_ACCOUNT
178 -- FLOW_SCHEDULE
179 -- COST_GROUP_ID
180 -- DEMAND_CLASS
181 -- QA_COLLECTION_ID
182 -- KANBAN_CARD_ID
183 -- OVERCOMPLETION_TRANSACTION_ID
184 -- OVERCOMPLETION_PRIMARY_QTY
185 -- OVERCOMPLETION_TRANSACTION_QTY
186 -- END_ITEM_UNIT_NUMBER
187 -- SCHEDULED_PAYBACK_DATE
188 -- LINE_TYPE_CODE
189 -- PARENT_TRANSACTION_TEMP_ID
190 -- PUT_AWAY_STRATEGY_ID
191 -- PUT_AWAY_RULE_ID
192 -- PICK_STRATEGY_ID
193 -- PICK_RULE_ID
194 -- COMMON_BOM_SEQ_ID
195 -- COMMON_ROUTING_SEQ_ID
196 -- COST_TYPE_ID
197 -- ORG_COST_GROUP_ID
198 -- MOVE_ORDER_LINE_ID
199 -- TASK_GROUP_ID
200 -- PICK_SLIP_NUMBER
201 -- RESERVATION_ID
202 -- TRANSACTION_STATUS
203 -- STANDARD_OPERATIOND_ID
204 -- TASK_PRIORITY
205 --
206 -- Required:
207 -- Defaults:
208 -- Note: This is automatic generated record definition, it includes all columns
209 -- defined in the table, developer must manually add or delete some of the attributes.
210 --
211 -- End of Comments
212
213 -- phegde commented 02/21/00
214 --
215 TYPE CSP_Rec_Type IS RECORD
216 (
217 TRANSACTION_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
218 TRANSACTION_TEMP_ID NUMBER := FND_API.G_MISS_NUM,
219 SOURCE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
220 SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
221 TRANSACTION_MODE NUMBER := FND_API.G_MISS_NUM,
222 LOCK_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
223 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
224 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
225 CREATION_DATE DATE := FND_API.G_MISS_DATE,
226 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
227 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
228 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
229 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
230 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
231 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
232 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
233 REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
234 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
235 SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
236 LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
237 TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
238 PRIMARY_QUANTITY NUMBER := FND_API.G_MISS_NUM,
239 TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
240 TRANSACTION_COST NUMBER := FND_API.G_MISS_NUM,
241 TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
242 TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
243 TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
244 TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
245 TRANSACTION_SOURCE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
246 TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
247 ACCT_PERIOD_ID NUMBER := FND_API.G_MISS_NUM,
248 DISTRIBUTION_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
249 TRANSACTION_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
250 REQUISITION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
251 REQUISITION_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
252 REASON_ID NUMBER := FND_API.G_MISS_NUM,
253 LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
254 LOT_EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
255 SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
256 RECEIVING_DOCUMENT VARCHAR2(10) := FND_API.G_MISS_CHAR,
257 DEMAND_ID NUMBER := FND_API.G_MISS_NUM,
258 RCV_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
259 MOVE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
260 COMPLETION_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
261 WIP_ENTITY_TYPE NUMBER := FND_API.G_MISS_NUM,
262 SCHEDULE_ID NUMBER := FND_API.G_MISS_NUM,
263 REPETITIVE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
264 EMPLOYEE_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
265 PRIMARY_SWITCH NUMBER := FND_API.G_MISS_NUM,
266 SCHEDULE_UPDATE_CODE NUMBER := FND_API.G_MISS_NUM,
267 SETUP_TEARDOWN_CODE NUMBER := FND_API.G_MISS_NUM,
268 ITEM_ORDERING NUMBER := FND_API.G_MISS_NUM,
269 NEGATIVE_REQ_FLAG NUMBER := FND_API.G_MISS_NUM,
270 OPERATION_SEQ_NUM NUMBER := FND_API.G_MISS_NUM,
271 PICKING_LINE_ID NUMBER := FND_API.G_MISS_NUM,
272 TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
273 TRX_SOURCE_DELIVERY_ID NUMBER := FND_API.G_MISS_NUM,
274 PHYSICAL_ADJUSTMENT_ID NUMBER := FND_API.G_MISS_NUM,
275 CYCLE_COUNT_ID NUMBER := FND_API.G_MISS_NUM,
276 RMA_LINE_ID NUMBER := FND_API.G_MISS_NUM,
277 CUSTOMER_SHIP_ID NUMBER := FND_API.G_MISS_NUM,
278 CURRENCY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
279 CURRENCY_CONVERSION_RATE NUMBER := FND_API.G_MISS_NUM,
280 CURRENCY_CONVERSION_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
281 CURRENCY_CONVERSION_DATE DATE := FND_API.G_MISS_DATE,
282 USSGL_TRANSACTION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
283 VENDOR_LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
284 ENCUMBRANCE_ACCOUNT NUMBER := FND_API.G_MISS_NUM,
285 ENCUMBRANCE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
286 SHIP_TO_LOCATION NUMBER := FND_API.G_MISS_NUM,
287 SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
288 TRANSFER_COST NUMBER := FND_API.G_MISS_NUM,
289 TRANSPORTATION_COST NUMBER := FND_API.G_MISS_NUM,
290 TRANSPORTATION_ACCOUNT NUMBER := FND_API.G_MISS_NUM,
291 FREIGHT_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
292 CONTAINERS NUMBER := FND_API.G_MISS_NUM,
293 WAYBILL_AIRBILL VARCHAR2(20) := FND_API.G_MISS_CHAR,
294 EXPECTED_ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
295 TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
296 TRANSFER_ORGANIZATION NUMBER := FND_API.G_MISS_NUM,
297 TRANSFER_TO_LOCATION NUMBER := FND_API.G_MISS_NUM,
298 NEW_AVERAGE_COST NUMBER := FND_API.G_MISS_NUM,
299 VALUE_CHANGE NUMBER := FND_API.G_MISS_NUM,
300 PERCENTAGE_CHANGE NUMBER := FND_API.G_MISS_NUM,
301 MATERIAL_ALLOCATION_TEMP_ID NUMBER := FND_API.G_MISS_NUM,
302 DEMAND_SOURCE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
303 DEMAND_SOURCE_LINE VARCHAR2(30) := FND_API.G_MISS_CHAR,
304 DEMAND_SOURCE_DELIVERY VARCHAR2(30) := FND_API.G_MISS_CHAR,
305 ITEM_SEGMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
306 ITEM_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
307 ITEM_TRX_ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
308 ITEM_LOCATION_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
309 ITEM_RESTRICT_SUBINV_CODE NUMBER := FND_API.G_MISS_NUM,
310 ITEM_RESTRICT_LOCATORS_CODE NUMBER := FND_API.G_MISS_NUM,
311 ITEM_REVISION_QTY_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
312 ITEM_PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
313 ITEM_UOM_CLASS VARCHAR2(10) := FND_API.G_MISS_CHAR,
314 ITEM_SHELF_LIFE_CODE NUMBER := FND_API.G_MISS_NUM,
315 ITEM_SHELF_LIFE_DAYS NUMBER := FND_API.G_MISS_NUM,
316 ITEM_LOT_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
317 ITEM_SERIAL_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
318 ITEM_INVENTORY_ASSET_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
319 ALLOWED_UNITS_LOOKUP_CODE NUMBER := FND_API.G_MISS_NUM,
320 DEPARTMENT_ID NUMBER := FND_API.G_MISS_NUM,
321 DEPARTMENT_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
322 WIP_SUPPLY_TYPE NUMBER := FND_API.G_MISS_NUM,
323 SUPPLY_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
324 SUPPLY_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
325 VALID_SUBINVENTORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
326 VALID_LOCATOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
327 LOCATOR_SEGMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
328 CURRENT_LOCATOR_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
329 NUMBER_OF_LOTS_ENTERED NUMBER := FND_API.G_MISS_NUM,
330 WIP_COMMIT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
331 NEXT_LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
332 LOT_ALPHA_PREFIX VARCHAR2(30) := FND_API.G_MISS_CHAR,
333 NEXT_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
334 SERIAL_ALPHA_PREFIX VARCHAR2(30) := FND_API.G_MISS_CHAR,
335 SHIPPABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
336 POSTING_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
337 REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
338 PROCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
339 ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
340 ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
341 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
342 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358 RESERVATION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
355 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357 MOVEMENT_ID NUMBER := FND_API.G_MISS_NUM,
359 SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
360 TRANSACTION_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
361 TASK_ID NUMBER := FND_API.G_MISS_NUM,
362 TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
363 SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
364 PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
365 SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
366 PA_EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
367 TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
368 EXPENDITURE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
369 FINAL_COMPLETION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
370 TRANSFER_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
371 TRANSACTION_SEQUENCE_ID NUMBER := FND_API.G_MISS_NUM,
372 MATERIAL_ACCOUNT NUMBER := FND_API.G_MISS_NUM,
373 MATERIAL_OVERHEAD_ACCOUNT NUMBER := FND_API.G_MISS_NUM,
374 RESOURCE_ACCOUNT NUMBER := FND_API.G_MISS_NUM,
375 OUTSIDE_PROCESSING_ACCOUNT NUMBER := FND_API.G_MISS_NUM,
376 OVERHEAD_ACCOUNT NUMBER := FND_API.G_MISS_NUM,
377 FLOW_SCHEDULE VARCHAR2(1) := FND_API.G_MISS_CHAR,
378 COST_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
379 DEMAND_CLASS VARCHAR2(30) := FND_API.G_MISS_CHAR,
380 QA_COLLECTION_ID NUMBER := FND_API.G_MISS_NUM,
381 KANBAN_CARD_ID NUMBER := FND_API.G_MISS_NUM,
382 OVERCOMPLETION_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
383 OVERCOMPLETION_PRIMARY_QTY NUMBER := FND_API.G_MISS_NUM,
384 OVERCOMPLETION_TRANSACTION_QTY NUMBER := FND_API.G_MISS_NUM,
385 --PROCESS_TYPE NUMBER := FND_API.G_MISS_NUM, --removed 01/13/00. process_type does not exist in the mmtt table.
386 END_ITEM_UNIT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
387 SCHEDULED_PAYBACK_DATE DATE := FND_API.G_MISS_DATE,
388 LINE_TYPE_CODE NUMBER := FND_API.G_MISS_NUM,
389 PARENT_TRANSACTION_TEMP_ID NUMBER := FND_API.G_MISS_NUM,
390 PUT_AWAY_STRATEGY_ID NUMBER := FND_API.G_MISS_NUM,
391 PUT_AWAY_RULE_ID NUMBER := FND_API.G_MISS_NUM,
392 PICK_STRATEGY_ID NUMBER := FND_API.G_MISS_NUM,
393 PICK_RULE_ID NUMBER := FND_API.G_MISS_NUM,
394 COMMON_BOM_SEQ_ID NUMBER := FND_API.G_MISS_NUM,
395 COMMON_ROUTING_SEQ_ID NUMBER := FND_API.G_MISS_NUM,
396 COST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
397 ORG_COST_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
398 MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
399 TASK_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
400 PICK_SLIP_NUMBER NUMBER := FND_API.G_MISS_NUM,
401 RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
402 TRANSACTION_STATUS NUMBER := FND_API.G_MISS_NUM,
403 STANDARD_OPERATION_ID NUMBER := FND_API.G_MISS_NUM,
404 TASK_PRIORITY NUMBER := FND_API.G_MISS_NUM,
405 -- ADDED by phegde 02/23
406 WMS_TASK_TYPE NUMBER := FND_API.G_MISS_NUM,
407 PARENT_LINE_ID NUMBER := FND_API.G_MISS_NUM
408 -- SOURCE_LOT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR
409 );
410
411 G_MISS_CSP_REC CSP_Rec_Type;
412
413 TYPE CSP_Tbl_Type IS TABLE OF CSP_Rec_Type
414 INDEX BY BINARY_INTEGER;
415 G_MISS_CSP_TBL CSP_Tbl_Type;
416
417 -- *******************************************************
418 -- Start of Comments
419 -- *******************************************************
420 -- API Name: Create_material_transactions
421 -- Type : Private
422 -- Pre-Req :
423 -- Parameters:
424 -- IN
425 -- p_api_version_number IN NUMBER Required
426 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
427 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
428 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
429 -- P_CSP_Rec IN CSP_Rec_Type Required
430 --
431 -- OUT:
432 -- x_return_status OUT NOCOPY VARCHAR2
433 -- x_msg_count OUT NOCOPY NUMBER
434 -- x_msg_data OUT NOCOPY VARCHAR2
435 -- Version : Current version 2.0
436 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
437 -- and basic operation, developer must manually add parameters and business logic as necessary.
438 --
439 -- End of Comments
440 --
441 PROCEDURE Create_material_transactions(
442 P_Api_Version_Number IN NUMBER,
443 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
444 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
448 X_TRANSACTION_TEMP_ID OUT NOCOPY NUMBER,
445 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
446 P_CSP_Rec IN CSP_Rec_Type := G_MISS_CSP_REC,
447 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
449 X_Return_Status OUT NOCOPY VARCHAR2,
450 X_Msg_Count OUT NOCOPY NUMBER,
451 X_Msg_Data OUT NOCOPY VARCHAR2
452 );
453
454 -- *******************************************************
455 -- Start of Comments
456 -- *******************************************************
457 -- API Name: Update_material_transactions
458 -- Type : Private
459 -- Pre-Req :
460 -- Parameters:
461 -- IN
462 -- p_api_version_number IN NUMBER Required
463 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
464 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
465 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
466 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
467 -- P_CSP_Rec IN CSP_Rec_Type Required
468 --
469 -- OUT:
470 -- x_return_status OUT NOCOPY VARCHAR2
471 -- x_msg_count OUT NOCOPY NUMBER
472 -- x_msg_data OUT NOCOPY VARCHAR2
473 -- Version : Current version 2.0
474 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
475 -- and basic operation, developer must manually add parameters and business logic as necessary.
476 --
477 -- End of Comments
478 --
479 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
480 PROCEDURE Update_material_transactions(
481 P_Api_Version_Number IN NUMBER,
482 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
483 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
484 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
485 --P_Identity_Salesforce_Id IN NUMBER := NULL,
486 P_CSP_Rec IN CSP_Rec_Type,
487 X_Return_Status OUT NOCOPY VARCHAR2,
488 X_Msg_Count OUT NOCOPY NUMBER,
489 X_Msg_Data OUT NOCOPY VARCHAR2
490 );
491
492 -- *******************************************************
493 -- Start of Comments
494 -- *******************************************************
495 -- API Name: Delete_material_transactions
496 -- Type : Private
497 -- Pre-Req :
498 -- Parameters:
499 -- IN
500 -- p_api_version_number IN NUMBER Required
501 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
502 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
503 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
504 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
505 -- P_CSP_Rec IN CSP_Rec_Type Required
506 --
507 -- OUT:
508 -- x_return_status OUT NOCOPY VARCHAR2
509 -- x_msg_count OUT NOCOPY NUMBER
510 -- x_msg_data OUT NOCOPY VARCHAR2
511 -- Version : Current version 2.0
512 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
513 -- and basic operation, developer must manually add parameters and business logic as necessary.
514 --
515 -- End of Comments
516 --
517 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
518 -- The Master delete procedure may not be needed depends on different business requirements.
519 PROCEDURE Delete_material_transactions(
520 P_Api_Version_Number IN NUMBER,
521 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
522 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
523 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
524 --P_identity_salesforce_id IN NUMBER := NULL,
525 P_CSP_Rec IN CSP_Rec_Type,
526 X_Return_Status OUT NOCOPY VARCHAR2,
527 X_Msg_Count OUT NOCOPY NUMBER,
528 X_Msg_Data OUT NOCOPY VARCHAR2
529 );
530
531 End CSP_MATERIAL_TRANSACTIONS_PVT;