1 PACKAGE RCV_ASN_INTERFACE_TRX_INS_PKG as
2 /* $Header: RCVTIR8S.pls 120.6.12010000.2 2008/10/09 17:30:52 vthevark ship $ */
3
4 PROCEDURE INSERT_ROW(
5 X_ROWID IN OUT NOCOPY VARCHAR2,
6 X_INTERFACE_TRANSACTION_ID IN OUT NOCOPY NUMBER,
7 X_GROUP_ID IN NUMBER DEFAULT NULL,
8 X_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
9 X_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
10 X_CREATION_DATE IN DATE DEFAULT NULL,
11 X_CREATED_BY IN NUMBER DEFAULT NULL,
12 X_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
13 X_REQUEST_ID IN NUMBER DEFAULT NULL,
14 X_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT NULL,
15 X_PROGRAM_ID IN NUMBER DEFAULT NULL,
16 X_PROGRAM_UPDATE_DATE IN DATE DEFAULT NULL,
17 X_TRANSACTION_TYPE IN VARCHAR2 DEFAULT NULL,
18 X_TRANSACTION_DATE IN DATE DEFAULT NULL,
19 X_PROCESSING_STATUS_CODE IN VARCHAR2 DEFAULT NULL,
20 X_PROCESSING_MODE_CODE IN VARCHAR2 DEFAULT NULL,
21 X_PROCESSING_REQUEST_ID IN NUMBER DEFAULT NULL,
22 X_TRANSACTION_STATUS_CODE IN VARCHAR2 DEFAULT NULL,
23 X_CATEGORY_ID IN NUMBER DEFAULT NULL,
24 X_QUANTITY IN NUMBER DEFAULT NULL,
25 X_UNIT_OF_MEASURE IN VARCHAR2 DEFAULT NULL,
26 X_INTERFACE_SOURCE_CODE IN VARCHAR2 DEFAULT NULL,
27 X_INTERFACE_SOURCE_LINE_ID IN NUMBER DEFAULT NULL,
28 X_INV_TRANSACTION_ID IN NUMBER DEFAULT NULL,
29 X_ITEM_ID IN NUMBER DEFAULT NULL,
30 X_ITEM_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
31 X_ITEM_REVISION IN VARCHAR2 DEFAULT NULL,
32 X_UOM_CODE IN VARCHAR2 DEFAULT NULL,
33 X_EMPLOYEE_ID IN NUMBER DEFAULT NULL,
34 X_AUTO_TRANSACT_CODE IN VARCHAR2 DEFAULT NULL,
35 X_SHIPMENT_HEADER_ID IN NUMBER DEFAULT NULL,
36 X_SHIPMENT_LINE_ID IN NUMBER DEFAULT NULL,
37 X_SHIP_TO_LOCATION_ID IN NUMBER DEFAULT NULL,
38 X_PRIMARY_QUANTITY IN NUMBER DEFAULT NULL,
39 X_PRIMARY_UNIT_OF_MEASURE IN VARCHAR2 DEFAULT NULL,
40 X_RECEIPT_SOURCE_CODE IN VARCHAR2 DEFAULT NULL,
41 X_VENDOR_ID IN NUMBER DEFAULT NULL,
42 X_VENDOR_SITE_ID IN NUMBER DEFAULT NULL,
43 X_FROM_ORGANIZATION_ID IN NUMBER DEFAULT NULL,
44 X_FROM_SUBINVENTORY IN VARCHAR2 DEFAULT NULL,
45 X_TO_ORGANIZATION_ID IN NUMBER DEFAULT NULL,
46 X_INTRANSIT_OWNING_ORG_ID IN NUMBER DEFAULT NULL,
47 X_ROUTING_HEADER_ID IN NUMBER DEFAULT NULL,
48 X_ROUTING_STEP_ID IN NUMBER DEFAULT NULL,
49 X_SOURCE_DOCUMENT_CODE IN VARCHAR2 DEFAULT NULL,
50 X_PARENT_TRANSACTION_ID IN NUMBER DEFAULT NULL,
51 X_PO_HEADER_ID IN NUMBER DEFAULT NULL,
52 X_PO_REVISION_NUM IN NUMBER DEFAULT NULL,
53 X_PO_RELEASE_ID IN NUMBER DEFAULT NULL,
54 X_PO_LINE_ID IN NUMBER DEFAULT NULL,
55 X_PO_LINE_LOCATION_ID IN NUMBER DEFAULT NULL,
56 X_PO_UNIT_PRICE IN NUMBER DEFAULT NULL,
57 X_CURRENCY_CODE IN VARCHAR2 DEFAULT NULL,
58 X_CURRENCY_CONVERSION_TYPE IN VARCHAR2 DEFAULT NULL,
59 X_CURRENCY_CONVERSION_RATE IN NUMBER DEFAULT NULL,
60 X_CURRENCY_CONVERSION_DATE IN DATE DEFAULT NULL,
61 X_PO_DISTRIBUTION_ID IN NUMBER DEFAULT NULL,
62 X_REQUISITION_LINE_ID IN NUMBER DEFAULT NULL,
63 X_REQ_DISTRIBUTION_ID IN NUMBER DEFAULT NULL,
64 X_CHARGE_ACCOUNT_ID IN NUMBER DEFAULT NULL,
65 X_SUBSTITUTE_UNORDERED_CODE IN VARCHAR2 DEFAULT NULL,
66 X_RECEIPT_EXCEPTION_FLAG IN VARCHAR2 DEFAULT NULL,
67 X_ACCRUAL_STATUS_CODE IN VARCHAR2 DEFAULT NULL,
68 X_INSPECTION_STATUS_CODE IN VARCHAR2 DEFAULT NULL,
69 X_INSPECTION_QUALITY_CODE IN VARCHAR2 DEFAULT NULL,
70 X_DESTINATION_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
71 X_DELIVER_TO_PERSON_ID IN NUMBER DEFAULT NULL,
72 X_LOCATION_ID IN NUMBER DEFAULT NULL,
73 X_DELIVER_TO_LOCATION_ID IN NUMBER DEFAULT NULL,
74 X_SUBINVENTORY IN VARCHAR2 DEFAULT NULL,
75 X_LOCATOR_ID IN NUMBER DEFAULT NULL,
76 X_WIP_ENTITY_ID IN NUMBER DEFAULT NULL,
77 X_WIP_LINE_ID IN NUMBER DEFAULT NULL,
78 X_DEPARTMENT_CODE IN VARCHAR2 DEFAULT NULL,
79 X_WIP_REPETITIVE_SCHEDULE_ID IN NUMBER DEFAULT NULL,
80 X_WIP_OPERATION_SEQ_NUM IN NUMBER DEFAULT NULL,
81 X_WIP_RESOURCE_SEQ_NUM IN NUMBER DEFAULT NULL,
82 X_BOM_RESOURCE_ID IN NUMBER DEFAULT NULL,
83 X_SHIPMENT_NUM IN VARCHAR2 DEFAULT NULL,
84 X_FREIGHT_CARRIER_CODE IN VARCHAR2 DEFAULT NULL,
85 X_BILL_OF_LADING IN VARCHAR2 DEFAULT NULL,
86 X_PACKING_SLIP IN VARCHAR2 DEFAULT NULL,
87 X_SHIPPED_DATE IN DATE DEFAULT NULL,
88 X_EXPECTED_RECEIPT_DATE IN DATE DEFAULT NULL,
89 X_ACTUAL_COST IN NUMBER DEFAULT NULL,
90 X_TRANSFER_COST IN NUMBER DEFAULT NULL,
91 X_TRANSPORTATION_COST IN NUMBER DEFAULT NULL,
92 X_TRANSPORTATION_ACCOUNT_ID IN NUMBER DEFAULT NULL,
93 X_NUM_OF_CONTAINERS IN NUMBER DEFAULT NULL,
94 X_WAYBILL_AIRBILL_NUM IN VARCHAR2 DEFAULT NULL,
95 X_VENDOR_ITEM_NUM IN VARCHAR2 DEFAULT NULL,
96 X_VENDOR_LOT_NUM IN VARCHAR2 DEFAULT NULL,
97 X_RMA_REFERENCE IN VARCHAR2 DEFAULT NULL,
98 X_COMMENTS IN VARCHAR2 DEFAULT NULL,
99 X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
100 X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
101 X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
102 X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
103 X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
104 X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
105 X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
106 X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
107 X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
108 X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
109 X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
110 X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
111 X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
112 X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
113 X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
114 X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
115 X_SHIP_HEAD_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
116 X_SHIP_HEAD_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
117 X_SHIP_HEAD_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
118 X_SHIP_HEAD_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
119 X_SHIP_HEAD_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
120 X_SHIP_HEAD_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
121 X_SHIP_HEAD_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
122 X_SHIP_HEAD_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
123 X_SHIP_HEAD_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
124 X_SHIP_HEAD_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
125 X_SHIP_HEAD_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
126 X_SHIP_HEAD_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
127 X_SHIP_HEAD_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
128 X_SHIP_HEAD_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
129 X_SHIP_HEAD_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
130 X_SHIP_HEAD_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
131 X_SHIP_LINE_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
132 X_SHIP_LINE_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
133 X_SHIP_LINE_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
134 X_SHIP_LINE_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
135 X_SHIP_LINE_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
136 X_SHIP_LINE_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
137 X_SHIP_LINE_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
138 X_SHIP_LINE_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
139 X_SHIP_LINE_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
140 X_SHIP_LINE_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
141 X_SHIP_LINE_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
142 X_SHIP_LINE_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
143 X_SHIP_LINE_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
144 X_SHIP_LINE_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
145 X_SHIP_LINE_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
146 X_SHIP_LINE_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
147 X_USSGL_TRANSACTION_CODE IN VARCHAR2 DEFAULT NULL,
148 X_GOVERNMENT_CONTEXT IN VARCHAR2 DEFAULT NULL,
149 X_REASON_ID IN NUMBER DEFAULT NULL,
150 X_DESTINATION_CONTEXT IN VARCHAR2 DEFAULT NULL,
151 X_SOURCE_DOC_QUANTITY IN NUMBER DEFAULT NULL,
152 X_SOURCE_DOC_UNIT_OF_MEASURE IN VARCHAR2 DEFAULT NULL,
153 X_MOVEMENT_ID IN NUMBER DEFAULT NULL,
154 X_HEADER_INTERFACE_ID IN NUMBER DEFAULT NULL,
155 X_VENDOR_CUM_SHIPPED_QTY IN NUMBER DEFAULT NULL,
156 X_ITEM_NUM IN VARCHAR2 DEFAULT NULL,
157 X_DOCUMENT_NUM IN VARCHAR2 DEFAULT NULL,
158 X_DOCUMENT_LINE_NUM IN NUMBER DEFAULT NULL,
159 X_TRUCK_NUM IN VARCHAR2 DEFAULT NULL,
160 X_SHIP_TO_LOCATION_CODE IN VARCHAR2 DEFAULT NULL,
161 X_CONTAINER_NUM IN VARCHAR2 DEFAULT NULL,
162 X_SUBSTITUTE_ITEM_NUM IN VARCHAR2 DEFAULT NULL,
163 X_NOTICE_UNIT_PRICE IN NUMBER DEFAULT NULL,
164 X_ITEM_CATEGORY IN VARCHAR2 DEFAULT NULL,
165 X_LOCATION_CODE IN VARCHAR2 DEFAULT NULL,
166 X_VENDOR_NAME IN VARCHAR2 DEFAULT NULL,
167 X_VENDOR_NUM IN VARCHAR2 DEFAULT NULL,
168 X_VENDOR_SITE_CODE IN VARCHAR2 DEFAULT NULL,
169 X_FROM_ORGANIZATION_CODE IN VARCHAR2 DEFAULT NULL,
170 X_TO_ORGANIZATION_CODE IN VARCHAR2 DEFAULT NULL,
171 X_INTRANSIT_OWNING_ORG_CODE IN VARCHAR2 DEFAULT NULL,
172 X_ROUTING_CODE IN VARCHAR2 DEFAULT NULL,
173 X_ROUTING_STEP IN VARCHAR2 DEFAULT NULL,
174 X_RELEASE_NUM IN NUMBER DEFAULT NULL,
175 X_DOCUMENT_SHIPMENT_LINE_NUM IN NUMBER DEFAULT NULL,
176 X_DOCUMENT_DISTRIBUTION_NUM IN NUMBER DEFAULT NULL,
177 X_DELIVER_TO_PERSON_NAME IN VARCHAR2 DEFAULT NULL,
178 X_DELIVER_TO_LOCATION_CODE IN VARCHAR2 DEFAULT NULL,
179 X_USE_MTL_LOT IN NUMBER DEFAULT NULL,
180 X_USE_MTL_SERIAL IN NUMBER DEFAULT NULL,
181 X_LOCATOR IN VARCHAR2 DEFAULT NULL,
182 X_REASON_NAME IN VARCHAR2 DEFAULT NULL,
183 X_VALIDATION_FLAG IN VARCHAR2 DEFAULT NULL,
184 X_SUBSTITUTE_ITEM_ID IN NUMBER DEFAULT NULL,
185 X_QUANTITY_SHIPPED IN NUMBER DEFAULT NULL,
186 X_QUANTITY_INVOICED IN NUMBER DEFAULT NULL,
187 X_TAX_NAME IN VARCHAR2 DEFAULT NULL,
188 X_TAX_AMOUNT IN NUMBER DEFAULT NULL,
189 X_REQ_NUM IN VARCHAR2 DEFAULT NULL,
190 X_REQ_LINE_NUM IN NUMBER DEFAULT NULL,
191 X_REQ_DISTRIBUTION_NUM IN NUMBER DEFAULT NULL,
192 X_WIP_ENTITY_NAME IN VARCHAR2 DEFAULT NULL,
193 X_WIP_LINE_CODE IN VARCHAR2 DEFAULT NULL,
194 X_RESOURCE_CODE IN VARCHAR2 DEFAULT NULL,
195 X_SHIPMENT_LINE_STATUS_CODE IN VARCHAR2 DEFAULT NULL,
196 X_BARCODE_LABEL IN VARCHAR2 DEFAULT NULL,
197 X_COUNTRY_OF_ORIGIN_CODE IN VARCHAR2 DEFAULT NULL,
198 X_FROM_LOCATOR_ID IN NUMBER DEFAULT NULL,
199 X_QA_COLLECTION_ID IN NUMBER DEFAULT NULL,
200 X_OE_ORDER_HEADER_ID IN NUMBER DEFAULT NULL,
201 X_OE_ORDER_LINE_ID IN NUMBER DEFAULT NULL,
202 X_CUSTOMER_ID IN NUMBER DEFAULT NULL,
203 X_CUSTOMER_SITE_ID IN NUMBER DEFAULT NULL,
204 X_CUSTOMER_ITEM_NUM IN VARCHAR2 DEFAULT NULL,
205 X_CREATE_DEBIT_MEMO_FLAG IN VARCHAR2 DEFAULT NULL,
206 X_PUT_AWAY_RULE_ID IN NUMBER DEFAULT NULL,
207 X_PUT_AWAY_STRATEGY_ID IN NUMBER DEFAULT NULL,
208 X_LPN_ID IN NUMBER DEFAULT NULL,
209 X_TRANSFER_LPN_ID IN NUMBER DEFAULT NULL,
210 X_COST_GROUP_ID IN NUMBER DEFAULT NULL,
211 X_MOBILE_TXN IN VARCHAR2 DEFAULT NULL,
212 X_MMTT_TEMP_ID IN NUMBER DEFAULT NULL,
213 X_TRANSFER_COST_GROUP_ID IN NUMBER DEFAULT NULL,
214 X_SECONDARY_QUANTITY IN NUMBER DEFAULT NULL,
215 X_SECONDARY_UNIT_OF_MEASURE IN VARCHAR2 DEFAULT NULL,
216 X_SECONDARY_UOM_CODE IN VARCHAR2 DEFAULT NULL,
217 X_QC_GRADE IN VARCHAR2 DEFAULT NULL,
218 X_OE_ORDER_NUM IN NUMBER DEFAULT NULL,
219 X_OE_ORDER_LINE_NUM IN NUMBER DEFAULT NULL,
220 X_CUSTOMER_ACCOUNT_NUMBER IN NUMBER DEFAULT NULL,
221 X_CUSTOMER_PARTY_NAME IN VARCHAR2 DEFAULT NULL,
222 X_SOURCE_TRANSACTION_NUM IN VARCHAR2 DEFAULT NULL,
223 X_PARENT_SOURCE_TXN_NUM IN VARCHAR2 DEFAULT NULL,
224 X_PARENT_INTERFACE_TXN_ID IN NUMBER DEFAULT NULL,
225 X_CUSTOMER_ITEM_ID IN NUMBER DEFAULT NULL,
226 X_INTERFACE_AVAIL_QTY IN NUMBER DEFAULT NULL,
227 X_INTERFACE_TRANS_QTY IN NUMBER DEFAULT NULL,
228 X_FROM_LOCATOR IN VARCHAR2 DEFAULT NULL,
229 X_LPN_GROUP_ID IN NUMBER DEFAULT NULL,
230 X_ORDER_TRANSACTION_ID IN NUMBER DEFAULT NULL,
231 X_LICENSE_PLATE_NUMBER IN VARCHAR2 DEFAULT NULL,
232 X_TFR_LICENSE_PLATE_NUMBER IN VARCHAR2 DEFAULT NULL,
233 X_AMOUNT IN NUMBER DEFAULT NULL,
234 X_JOB_ID IN NUMBER DEFAULT NULL,
235 X_PROJECT_ID IN NUMBER DEFAULT NULL,
236 X_TASK_ID IN NUMBER DEFAULT NULL,
237 X_ASN_ATTACH_ID IN NUMBER DEFAULT NULL,
238 X_TIMECARD_ID IN NUMBER DEFAULT NULL,
239 X_TIMECARD_OVN IN NUMBER DEFAULT NULL,
240 X_INTERFACE_AVAIL_AMT IN NUMBER DEFAULT NULL,
241 X_INTERFACE_TRANS_AMT IN NUMBER DEFAULT NULL,
242 P_ORG_ID IN MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE DEFAULT NULL, --<R12 MOAC>
243 P_MATCHING_BASIS IN VARCHAR2 DEFAULT NULL ,
244 P_AMOUNT_SHIPPED IN NUMBER DEFAULT NULL,
245 P_REQUESTED_AMOUNT IN NUMBER DEFAULT NULL,
246 P_MATERIAL_STORED_AMOUNT IN NUMBER DEFAULT NULL,
247 P_REPLENISH_ORDER_LINE_ID IN NUMBER DEFAULT NULL,
248 P_EXPRESS_TRANSACTION IN VARCHAR2 DEFAULT NULL, --Bug 5550783
249 X_LCM_SHIPMENT_LINE_ID IN NUMBER DEFAULT NULL, -- lcm changes
250 X_UNIT_LANDED_COST IN NUMBER DEFAULT NULL -- lcm changes
251 );
252
253 END RCV_ASN_INTERFACE_TRX_INS_PKG;