[Home] [Help]
PACKAGE: APPS.MTL_TXNS_TEMP_PKG
Source
1 PACKAGE MTL_TXNS_TEMP_PKG as
2 /* $Header: INVTVTMS.pls 120.1.12000000.1 2007/01/17 16:32:57 appldev ship $ */
3 /* 31-May-2000 Added three columns transfer_cost_group_id,lpn_id and transfer_lpn_id
4 to take care of 11i related inventory enhancements */
5
6 PROCEDURE Lock_Row(
7 X_ROWID VARCHAR2,
8 X_TRANSACTION_HEADER_ID NUMBER,
9 X_TRANSACTION_TEMP_ID NUMBER,
10 X_SOURCE_CODE VARCHAR2,
11 X_SOURCE_LINE_ID NUMBER,
12 X_TRANSACTION_MODE NUMBER,
13 X_LOCK_FLAG VARCHAR2,
14 X_LAST_UPDATE_DATE DATE,
15 X_LAST_UPDATED_BY NUMBER,
16 X_CREATION_DATE DATE,
17 X_CREATED_BY NUMBER,
18 X_LAST_UPDATE_LOGIN NUMBER,
19 X_REQUEST_ID NUMBER,
20 X_PROGRAM_APPLICATION_ID NUMBER,
21 X_PROGRAM_ID NUMBER,
22 X_PROGRAM_UPDATE_DATE DATE,
23 X_INVENTORY_ITEM_ID NUMBER,
24 X_REVISION VARCHAR2,
25 X_ORGANIZATION_ID NUMBER,
26 X_SUBINVENTORY_CODE VARCHAR2,
27 X_LOCATOR_ID NUMBER,
28 X_TRANSACTION_QUANTITY NUMBER,
29 X_PRIMARY_QUANTITY NUMBER,
30 X_TRANSACTION_UOM VARCHAR2,
31 X_TRANSACTION_COST NUMBER,
32 X_COST_GROUP_ID NUMBER,
33 X_TRANSACTION_TYPE_ID NUMBER,
34 X_TRANSACTION_ACTION_ID NUMBER,
35 X_TRANSACTION_SOURCE_TYPE_ID NUMBER,
36 X_TRANSACTION_SOURCE_ID NUMBER,
37 X_TRANSACTION_SOURCE_NAME VARCHAR2,
38 X_TRANSACTION_DATE DATE,
39 X_ACCT_PERIOD_ID NUMBER,
40 X_DISTRIBUTION_ACCOUNT_ID NUMBER,
41 X_TRANSACTION_REFERENCE VARCHAR2,
42 X_REASON_ID NUMBER,
43 X_LOT_NUMBER VARCHAR2,
44 X_LOT_EXPIRATION_DATE DATE,
45 X_SERIAL_NUMBER VARCHAR2,
46 X_RECEIVING_DOCUMENT VARCHAR2,
47 X_RCV_TRANSACTION_ID NUMBER,
48 X_MOVE_TRANSACTION_ID NUMBER,
49 X_COMPLETION_TRANSACTION_ID NUMBER,
50 X_WIP_ENTITY_TYPE NUMBER,
51 X_SCHEDULE_ID NUMBER,
52 X_EMPLOYEE_CODE VARCHAR2,
53 X_SCHEDULE_UPDATE_CODE NUMBER,
54 X_SETUP_TEARDOWN_CODE NUMBER,
55 X_OPERATION_SEQ_NUM NUMBER,
56 X_PICKING_LINE_ID NUMBER,
57 X_TRX_SOURCE_LINE_ID NUMBER,
58 X_TRX_SOURCE_DELIVERY_ID NUMBER,
59 X_PHYSICAL_ADJUSTMENT_ID NUMBER,
60 X_CYCLE_COUNT_ID NUMBER,
61 X_RMA_LINE_ID NUMBER,
62 X_CUSTOMER_SHIP_ID NUMBER,
63 X_CURRENCY_CODE VARCHAR2,
64 X_CURRENCY_CONVERSION_RATE NUMBER,
65 X_CURRENCY_CONVERSION_TYPE VARCHAR2,
66 X_CURRENCY_CONVERSION_DATE DATE,
67 X_USSGL_TRANSACTION_CODE VARCHAR2,
68 X_VENDOR_LOT_NUMBER VARCHAR2,
69 X_ENCUMBRANCE_ACCOUNT NUMBER,
70 X_ENCUMBRANCE_AMOUNT NUMBER,
71 X_SHIPMENT_NUMBER VARCHAR2,
72 X_TRANSFER_COST NUMBER,
73 X_TRANSPORTATION_COST NUMBER,
74 X_TRANSPORTATION_ACCOUNT NUMBER,
75 X_FREIGHT_CODE VARCHAR2,
76 X_CONTAINERS NUMBER,
77 X_WAYBILL_AIRBILL VARCHAR2,
78 X_EXPECTED_ARRIVAL_DATE DATE,
79 X_TRANSFER_SUBINVENTORY VARCHAR2,
80 X_TRANSFER_ORGANIZATION NUMBER,
81 X_TRANSFER_TO_LOCATION NUMBER,
82 X_NEW_AVERAGE_COST NUMBER,
83 X_VALUE_CHANGE NUMBER,
84 X_PERCENTAGE_CHANGE NUMBER,
85 X_MATERIAL_ALLOCATION_TEMP_ID NUMBER,
86 X_DEMAND_SOURCE_HEADER_ID NUMBER,
87 X_DEMAND_SOURCE_LINE VARCHAR2,
88 X_DEMAND_SOURCE_DELIVERY VARCHAR2,
89 X_ITEM_DESCRIPTION VARCHAR2,
90 X_WIP_SUPPLY_TYPE NUMBER,
91 X_POSTING_FLAG VARCHAR2,
92 X_PROCESS_FLAG VARCHAR2,
93 X_ERROR_CODE VARCHAR2,
94 X_ATTRIBUTE_CATEGORY VARCHAR2,
95 X_ATTRIBUTE1 VARCHAR2,
96 X_ATTRIBUTE2 VARCHAR2,
97 X_ATTRIBUTE3 VARCHAR2,
98 X_ATTRIBUTE4 VARCHAR2,
99 X_ATTRIBUTE5 VARCHAR2,
100 X_ATTRIBUTE6 VARCHAR2,
101 X_ATTRIBUTE7 VARCHAR2,
102 X_ATTRIBUTE8 VARCHAR2,
103 X_ATTRIBUTE9 VARCHAR2,
104 X_ATTRIBUTE10 VARCHAR2,
105 X_ATTRIBUTE11 VARCHAR2,
106 X_ATTRIBUTE12 VARCHAR2,
107 X_ATTRIBUTE13 VARCHAR2,
108 X_ATTRIBUTE14 VARCHAR2,
109 X_ATTRIBUTE15 VARCHAR2,
110 X_PRIMARY_SWITCH NUMBER,
111 X_DEPARTMENT_CODE VARCHAR2,
112 X_ERROR_EXPLANATION VARCHAR2,
113 X_DEMAND_ID NUMBER,
114 X_REQUISITION_LINE_ID NUMBER,
115 X_REQUISITION_DISTRIBUTION_ID NUMBER,
116 X_MOVEMENT_ID NUMBER,
117 X_SOURCE_PROJECT_ID NUMBER,
118 X_SOURCE_TASK_ID NUMBER,
119 X_PROJECT_ID NUMBER,
120 X_TASK_ID NUMBER,
121 X_TO_PROJECT_ID NUMBER,
122 X_TO_TASK_ID NUMBER,
123 X_PA_EXPENDITURE_ORG_ID NUMBER,
124 X_EXPENDITURE_TYPE VARCHAR2,
125 X_LPN_ID NUMBER,
126 X_TRANSFER_LPN_ID NUMBER,
127 X_TRANSFER_COST_GROUP_ID NUMBER,
128 X_CONTENT_LPN_ID NUMBER
129 );
130
131 PROCEDURE Update_Row(
132 X_ROWID VARCHAR2,
133 X_TRANSACTION_HEADER_ID NUMBER,
134 X_TRANSACTION_TEMP_ID NUMBER,
135 X_SOURCE_CODE VARCHAR2,
136 X_SOURCE_LINE_ID NUMBER,
137 X_TRANSACTION_MODE NUMBER,
138 X_LOCK_FLAG VARCHAR2,
139 X_LAST_UPDATE_DATE DATE,
140 X_LAST_UPDATED_BY NUMBER,
141 X_CREATION_DATE DATE,
142 X_CREATED_BY NUMBER,
143 X_LAST_UPDATE_LOGIN NUMBER,
144 X_REQUEST_ID NUMBER,
145 X_PROGRAM_APPLICATION_ID NUMBER,
146 X_PROGRAM_ID NUMBER,
147 X_PROGRAM_UPDATE_DATE DATE,
148 X_INVENTORY_ITEM_ID NUMBER,
149 X_REVISION VARCHAR2,
150 X_ORGANIZATION_ID NUMBER,
151 X_SUBINVENTORY_CODE VARCHAR2,
152 X_LOCATOR_ID NUMBER,
153 X_TRANSACTION_QUANTITY NUMBER,
154 X_PRIMARY_QUANTITY NUMBER,
155 X_TRANSACTION_UOM VARCHAR2,
156 X_TRANSACTION_COST NUMBER,
157 X_COST_GROUP_ID NUMBER,
158 X_TRANSACTION_TYPE_ID NUMBER,
159 X_TRANSACTION_ACTION_ID NUMBER,
160 X_TRANSACTION_SOURCE_TYPE_ID NUMBER,
161 X_TRANSACTION_SOURCE_ID NUMBER,
162 X_TRANSACTION_SOURCE_NAME VARCHAR2,
163 X_TRANSACTION_DATE DATE,
164 X_ACCT_PERIOD_ID NUMBER,
165 X_DISTRIBUTION_ACCOUNT_ID NUMBER,
166 X_TRANSACTION_REFERENCE VARCHAR2,
167 X_REASON_ID NUMBER,
168 X_LOT_NUMBER VARCHAR2,
169 X_LOT_EXPIRATION_DATE DATE,
170 X_SERIAL_NUMBER VARCHAR2,
171 X_RECEIVING_DOCUMENT VARCHAR2,
172 X_RCV_TRANSACTION_ID NUMBER,
173 X_MOVE_TRANSACTION_ID NUMBER,
174 X_COMPLETION_TRANSACTION_ID NUMBER,
175 X_WIP_ENTITY_TYPE NUMBER,
176 X_SCHEDULE_ID NUMBER,
177 X_EMPLOYEE_CODE VARCHAR2,
178 X_SCHEDULE_UPDATE_CODE NUMBER,
179 X_SETUP_TEARDOWN_CODE NUMBER,
180 X_OPERATION_SEQ_NUM NUMBER,
181 X_PICKING_LINE_ID NUMBER,
182 X_TRX_SOURCE_LINE_ID NUMBER,
183 X_TRX_SOURCE_DELIVERY_ID NUMBER,
184 X_PHYSICAL_ADJUSTMENT_ID NUMBER,
185 X_CYCLE_COUNT_ID NUMBER,
186 X_RMA_LINE_ID NUMBER,
187 X_CUSTOMER_SHIP_ID NUMBER,
188 X_CURRENCY_CODE VARCHAR2,
189 X_CURRENCY_CONVERSION_RATE NUMBER,
190 X_CURRENCY_CONVERSION_TYPE VARCHAR2,
191 X_CURRENCY_CONVERSION_DATE DATE,
192 X_USSGL_TRANSACTION_CODE VARCHAR2,
193 X_VENDOR_LOT_NUMBER VARCHAR2,
194 X_ENCUMBRANCE_ACCOUNT NUMBER,
195 X_ENCUMBRANCE_AMOUNT NUMBER,
196 X_SHIPMENT_NUMBER VARCHAR2,
197 X_TRANSFER_COST NUMBER,
198 X_TRANSPORTATION_COST NUMBER,
199 X_TRANSPORTATION_ACCOUNT NUMBER,
200 X_FREIGHT_CODE VARCHAR2,
201 X_CONTAINERS NUMBER,
202 X_WAYBILL_AIRBILL VARCHAR2,
203 X_EXPECTED_ARRIVAL_DATE DATE,
204 X_TRANSFER_SUBINVENTORY VARCHAR2,
205 X_TRANSFER_ORGANIZATION NUMBER,
206 X_TRANSFER_TO_LOCATION NUMBER,
207 X_NEW_AVERAGE_COST NUMBER,
208 X_VALUE_CHANGE NUMBER,
209 X_PERCENTAGE_CHANGE NUMBER,
210 X_MATERIAL_ALLOCATION_TEMP_ID NUMBER,
211 X_DEMAND_SOURCE_HEADER_ID NUMBER,
212 X_DEMAND_SOURCE_LINE VARCHAR2,
213 X_DEMAND_SOURCE_DELIVERY VARCHAR2,
214 X_ITEM_DESCRIPTION VARCHAR2,
215 X_WIP_SUPPLY_TYPE NUMBER,
216 X_POSTING_FLAG VARCHAR2,
217 X_PROCESS_FLAG VARCHAR2,
218 X_ERROR_CODE VARCHAR2,
219 X_ATTRIBUTE_CATEGORY VARCHAR2,
220 X_ATTRIBUTE1 VARCHAR2,
221 X_ATTRIBUTE2 VARCHAR2,
222 X_ATTRIBUTE3 VARCHAR2,
223 X_ATTRIBUTE4 VARCHAR2,
224 X_ATTRIBUTE5 VARCHAR2,
225 X_ATTRIBUTE6 VARCHAR2,
226 X_ATTRIBUTE7 VARCHAR2,
227 X_ATTRIBUTE8 VARCHAR2,
228 X_ATTRIBUTE9 VARCHAR2,
229 X_ATTRIBUTE10 VARCHAR2,
230 X_ATTRIBUTE11 VARCHAR2,
231 X_ATTRIBUTE12 VARCHAR2,
232 X_ATTRIBUTE13 VARCHAR2,
233 X_ATTRIBUTE14 VARCHAR2,
234 X_ATTRIBUTE15 VARCHAR2,
238 X_DEMAND_ID NUMBER,
235 X_PRIMARY_SWITCH NUMBER,
236 X_DEPARTMENT_CODE VARCHAR2,
237 X_ERROR_EXPLANATION VARCHAR2,
239 X_REQUISITION_LINE_ID NUMBER,
240 X_REQUISITION_DISTRIBUTION_ID NUMBER,
241 X_MOVEMENT_ID NUMBER,
242 X_SOURCE_PROJECT_ID NUMBER,
243 X_SOURCE_TASK_ID NUMBER,
244 X_PROJECT_ID NUMBER,
245 X_TASK_ID NUMBER,
246 X_TO_PROJECT_ID NUMBER,
247 X_TO_TASK_ID NUMBER,
248 X_PA_EXPENDITURE_ORG_ID NUMBER,
249 X_EXPENDITURE_TYPE VARCHAR2,
250 X_LPN_ID NUMBER,
251 X_TRANSFER_LPN_ID NUMBER,
252 X_TRANSFER_COST_GROUP_ID NUMBER,
253 X_CONTENT_LPN_ID NUMBER
254 );
255
256 END MTL_TXNS_TEMP_PKG;