1 PACKAGE CSP_PC_FORM_MTLTXNS AUTHID CURRENT_USER AS
2 /* $Header: cspgtmxs.pls 120.0 2005/05/25 11:39:58 appldev noship $ */
3 -- Start of Comments
4 -- Package name : CSP_PC_FORM_MTLTXNS
5 -- Purpose : A wrapper to prepare data to call the update, delete and insert procedures of the
6 -- CSP_Material_Transaactions_PVT.
7 -- History :
8 -- 27-Dec-99, Add procedure csp_mo_lines_manual_receipts
9 -- 20-Dec-99, klou.
10 --
11 -- NOTE :
12 -- End of Comments
13
14 PROCEDURE Validate_And_Write (
15 P_Api_Version_Number IN NUMBER,
16 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
17 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
18 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19 p_action_code IN NUMBER,
20 p_TRANSACTION_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
21 px_TRANSACTION_TEMP_ID IN OUT NOCOPY NUMBER,
22 p_SOURCE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
23 p_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
24 p_TRANSACTION_MODE IN NUMBER := FND_API.G_MISS_NUM,
25 p_LOCK_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
26 p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
27 p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
28 p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
29 p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30 p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
31 p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
32 p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
33 p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
34 p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
35 p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
36 p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
37 p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
38 p_SUBINVENTORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
39 p_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
40 p_TRANSACTION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
41 p_PRIMARY_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
42 p_TRANSACTION_UOM IN VARCHAR2 := FND_API.G_MISS_CHAR,
43 p_TRANSACTION_COST IN NUMBER := FND_API.G_MISS_NUM,
44 p_TRANSACTION_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
45 p_TRANSACTION_ACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
46 p_TRANSACTION_SOURCE_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
47 p_TRANSACTION_SOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
48 p_TRANSACTION_SOURCE_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
49 p_TRANSACTION_DATE IN DATE := FND_API.G_MISS_DATE,
50 p_ACCT_PERIOD_ID IN NUMBER := FND_API.G_MISS_NUM,
51 p_DISTRIBUTION_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
52 p_TRANSACTION_REFERENCE IN VARCHAR2 := FND_API.G_MISS_CHAR,
53 p_REQUISITION_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
54 p_REQUISITION_DISTRIBUTION_ID IN NUMBER := FND_API.G_MISS_NUM,
55 p_REASON_ID IN NUMBER := FND_API.G_MISS_NUM,
56 p_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
57 p_LOT_EXPIRATION_DATE IN DATE := FND_API.G_MISS_DATE,
58 p_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
59 p_RECEIVING_DOCUMENT IN VARCHAR2 := FND_API.G_MISS_CHAR,
60 p_DEMAND_ID IN NUMBER := FND_API.G_MISS_NUM,
61 p_RCV_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
62 p_MOVE_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
63 p_COMPLETION_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
64 p_WIP_ENTITY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
65 p_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
66 p_REPETITIVE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
67 p_EMPLOYEE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
68 p_PRIMARY_SWITCH IN NUMBER := FND_API.G_MISS_NUM,
69 p_SCHEDULE_UPDATE_CODE IN NUMBER := FND_API.G_MISS_NUM,
70 p_SETUP_TEARDOWN_CODE IN NUMBER := FND_API.G_MISS_NUM,
71 p_ITEM_ORDERING IN NUMBER := FND_API.G_MISS_NUM,
72 p_NEGATIVE_REQ_FLAG IN NUMBER := FND_API.G_MISS_NUM,
73 p_OPERATION_SEQ_NUM IN NUMBER := FND_API.G_MISS_NUM,
74 p_PICKING_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
75 p_TRX_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
76 p_TRX_SOURCE_DELIVERY_ID IN NUMBER := FND_API.G_MISS_NUM,
77 p_PHYSICAL_ADJUSTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
78 p_CYCLE_COUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
79 p_RMA_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
80 p_CUSTOMER_SHIP_ID IN NUMBER := FND_API.G_MISS_NUM,
81 p_CURRENCY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
82 p_CURRENCY_CONVERSION_RATE IN NUMBER := FND_API.G_MISS_NUM,
83 p_CURRENCY_CONVERSION_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
84 p_CURRENCY_CONVERSION_DATE IN DATE := FND_API.G_MISS_DATE,
85 p_USSGL_TRANSACTION_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
86 p_VENDOR_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
87 p_ENCUMBRANCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
88 p_ENCUMBRANCE_AMOUNT IN NUMBER := FND_API.G_MISS_NUM,
89 p_SHIP_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
90 p_SHIPMENT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
91 p_TRANSFER_COST IN NUMBER := FND_API.G_MISS_NUM,
92 p_TRANSPORTATION_COST IN NUMBER := FND_API.G_MISS_NUM,
93 p_TRANSPORTATION_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
94 p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
95 p_CONTAINERS IN NUMBER := FND_API.G_MISS_NUM,
96 p_WAYBILL_AIRBILL IN VARCHAR2 := FND_API.G_MISS_CHAR,
97 p_EXPECTED_ARRIVAL_DATE IN DATE := FND_API.G_MISS_DATE,
98 p_TRANSFER_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
99 p_TRANSFER_ORGANIZATION IN NUMBER := FND_API.G_MISS_NUM,
100 p_TRANSFER_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
101 p_NEW_AVERAGE_COST IN NUMBER := FND_API.G_MISS_NUM,
102 p_VALUE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
103 p_PERCENTAGE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
104 p_MATERIAL_ALLOCATION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
105 p_DEMAND_SOURCE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
106 p_DEMAND_SOURCE_LINE IN VARCHAR2 := FND_API.G_MISS_CHAR,
107 p_DEMAND_SOURCE_DELIVERY IN VARCHAR2 := FND_API.G_MISS_CHAR,
108 p_ITEM_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
109 p_ITEM_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
110 p_ITEM_TRX_ENABLED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
111 p_ITEM_LOCATION_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
112 p_ITEM_RESTRICT_SUBINV_CODE IN NUMBER := FND_API.G_MISS_NUM,
113 p_ITEM_RESTRICT_LOCATORS_CODE IN NUMBER := FND_API.G_MISS_NUM,
114 p_ITEM_REV_QTY_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
115 p_ITEM_PRIMARY_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 p_ITEM_UOM_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 p_ITEM_SHELF_LIFE_CODE IN NUMBER := FND_API.G_MISS_NUM,
118 p_ITEM_SHELF_LIFE_DAYS IN NUMBER := FND_API.G_MISS_NUM,
119 p_ITEM_LOT_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
120 p_ITEM_SERIAL_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
121 p_ITEM_INVENTORY_ASSET_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_ALLOWED_UNITS_LOOKUP_CODE IN NUMBER := FND_API.G_MISS_NUM,
123 p_DEPARTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
124 p_DEPARTMENT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 p_WIP_SUPPLY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
126 p_SUPPLY_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
127 p_SUPPLY_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
128 p_VALID_SUBINVENTORY_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
129 p_VALID_LOCATOR_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
130 p_LOCATOR_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
131 p_CURRENT_LOCATOR_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
132 p_NUMBER_OF_LOTS_ENTERED IN NUMBER := FND_API.G_MISS_NUM,
133 p_WIP_COMMIT_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
134 p_NEXT_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
135 p_LOT_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
136 p_NEXT_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
137 p_SERIAL_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 p_SHIPPABLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
139 p_POSTING_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
140 p_REQUIRED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
141 p_PROCESS_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
142 p_ERROR_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
143 p_ERROR_EXPLANATION IN VARCHAR2 := FND_API.G_MISS_CHAR,
144 p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
145 p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146 p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147 p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148 p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149 p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150 p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151 p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152 p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153 p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
154 p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155 p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156 p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157 p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158 p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
159 p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
160 p_MOVEMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
161 p_RESERVATION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
162 p_SHIPPED_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
163 p_TRANSACTION_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
164 p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
165 p_TO_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
166 p_SOURCE_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
167 p_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
168 p_SOURCE_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
169 p_PA_EXPENDITURE_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
170 p_TO_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
171 p_EXPENDITURE_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
172 p_FINAL_COMPLETION_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
173 p_TRANSFER_PERCENTAGE IN NUMBER := FND_API.G_MISS_NUM,
174 p_TRANSACTION_SEQUENCE_ID IN NUMBER := FND_API.G_MISS_NUM,
175 p_MATERIAL_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
176 p_MATERIAL_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
177 p_RESOURCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
178 p_OUTSIDE_PROCESSING_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
179 p_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
180 p_FLOW_SCHEDULE IN VARCHAR2 := FND_API.G_MISS_CHAR,
181 p_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
182 p_DEMAND_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
183 p_QA_COLLECTION_ID IN NUMBER := FND_API.G_MISS_NUM,
184 p_KANBAN_CARD_ID IN NUMBER := FND_API.G_MISS_NUM,
185 p_OVERCOMPLETION_TXN_ID IN NUMBER := FND_API.G_MISS_NUM,
186 p_OVERCOMPLETION_PRIMARY_QTY IN NUMBER := FND_API.G_MISS_NUM,
187 p_OVERCOMPLETION_TXN_QTY IN NUMBER := FND_API.G_MISS_NUM,
188 -- p_PROCESS_TYPE IN NUMBER := FND_API.G_MISS_NUM,
189 p_END_ITEM_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
190 p_SCHEDULED_PAYBACK_DATE IN DATE := FND_API.G_MISS_DATE,
191 p_LINE_TYPE_CODE IN NUMBER := FND_API.G_MISS_NUM,
192 p_PARENT_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
193 p_PUT_AWAY_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
194 p_PUT_AWAY_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
195 p_PICK_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
196 p_PICK_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
197 p_COMMON_BOM_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
198 p_COMMON_ROUTING_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
199 p_COST_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
200 p_ORG_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
201 p_MOVE_ORDER_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
202 p_TASK_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
203 p_PICK_SLIP_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
204 p_RESERVATION_ID IN NUMBER := FND_API.G_MISS_NUM,
205 p_TRANSACTION_STATUS IN NUMBER := FND_API.G_MISS_NUM,
206 P_STANDARD_OPERATION_ID IN NUMBER := FND_API.G_MISS_NUM,
207 P_TASK_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
208 P_WMS_TASK_TYPE IN NUMBER := FND_API.G_MISS_NUM,
209 P_PARENT_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
210 --P_SOURCE_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
211 X_Return_Status OUT NOCOPY VARCHAR2,
212 X_Msg_Count OUT NOCOPY NUMBER,
213 X_Msg_Data OUT NOCOPY VARCHAR2
214 );
215
216
217 PROCEDURE CSP_MO_LINES_MANUAL_RECEIPT (
218 P_Api_Version_Number IN NUMBER,
219 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
220 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
221 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222 p_organization_id IN NUMBER,
223 p_transaction_temp_id IN NUMBER,
224 px_transaction_header_id IN OUT NOCOPY NUMBER,
225 p_process_flag IN VARCHAR2 := FND_API.G_FALSE,
226 X_Return_Status OUT NOCOPY VARCHAR2,
227 X_Msg_Count OUT NOCOPY NUMBER,
228 X_Msg_Data OUT NOCOPY VARCHAR2
229 );
230
231
232 PROCEDURE CSP_MO_Lines_Auto_Receipt (
233 P_Api_Version_Number IN NUMBER,
234 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
235 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
236 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
237 p_organization_id IN NUMBER,
238 p_transaction_temp_id IN NUMBER,
239 X_Return_Status OUT NOCOPY VARCHAR2,
240 X_Msg_Count OUT NOCOPY NUMBER,
241 X_Msg_Data OUT NOCOPY VARCHAR2
242 );
243
244 END CSP_PC_FORM_MTLTXNS;