[Home] [Help]
PACKAGE: APPS.OE_INVOICE_PUB
Source
1 PACKAGE OE_Invoice_PUB AUTHID CURRENT_USER AS
2 /* $Header: OEXPINVS.pls 120.9.12020000.3 2013/04/12 05:27:49 sujithku ship $ */
3
4 -- Start of Comments
5 -- API name OE_Invoice_PUB
6 -- Type Public
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19 -- Order line Workflow AutoInvoice Interface function
20 -- Ra Interface Lines record type
21
22 TYPE RA_Interface_Lines_Rec_Type IS RECORD
23 ( CREATED_BY NUMBER(15) :=NULL
24 , CREATION_DATE DATE :=NULL
25 , LAST_UPDATED_BY NUMBER(15) :=NULL
26 , LAST_UPDATE_DATE DATE :=NULL
27 , INTERFACE_LINE_ATTRIBUTE1 VARCHAR2(30) :=NULL
28 , INTERFACE_LINE_ATTRIBUTE2 VARCHAR2(30) :=NULL
29 , INTERFACE_LINE_ATTRIBUTE3 VARCHAR2(30) :=NULL
30 , INTERFACE_LINE_ATTRIBUTE4 VARCHAR2(30) :=NULL
31 , INTERFACE_LINE_ATTRIBUTE5 VARCHAR2(30) :=NULL
32 , INTERFACE_LINE_ATTRIBUTE6 VARCHAR2(30) :=NULL
33 , INTERFACE_LINE_ATTRIBUTE7 VARCHAR2(30) :=NULL
34 , INTERFACE_LINE_ATTRIBUTE8 VARCHAR2(30) :=NULL
35 , INTERFACE_LINE_ATTRIBUTE9 VARCHAR2(30) :=NULL
36 , INTERFACE_LINE_ATTRIBUTE10 VARCHAR2(30) :=NULL
37 , INTERFACE_LINE_ATTRIBUTE11 VARCHAR2(30) :=NULL
38 , INTERFACE_LINE_ATTRIBUTE12 VARCHAR2(30) :=NULL
39 , INTERFACE_LINE_ATTRIBUTE13 VARCHAR2(30) :=NULL
40 , INTERFACE_LINE_ATTRIBUTE14 VARCHAR2(30) :=NULL
41 , INTERFACE_LINE_ATTRIBUTE15 VARCHAR2(30) :=NULL
42 , INTERFACE_LINE_ID NUMBER(15) :=NULL
43 , INTERFACE_LINE_CONTEXT VARCHAR2(30) :=NULL
44 , WAREHOUSE_ID NUMBER(15) :=NULL
45 , BATCH_SOURCE_NAME VARCHAR2(50) :=NULL
46 , SET_OF_BOOKS_ID NUMBER(15) :=NULL
47 , LINE_TYPE VARCHAR2(20) :=NULL
48 , DESCRIPTION VARCHAR2(240) :=NULL
49 , CURRENCY_CODE VARCHAR2(15) :=NULL
50 , AMOUNT NUMBER :=NULL
51 , CONVERSION_TYPE VARCHAR2(30) :=NULL
52 , CONVERSION_DATE DATE :=NULL
53 , CONVERSION_RATE NUMBER :=NULL
54 , CUST_TRX_TYPE_NAME VARCHAR2(20) :=NULL
55 , CUST_TRX_TYPE_ID NUMBER(15) :=NULL
56 , TERM_NAME VARCHAR2(15) :=NULL
57 , TERM_ID NUMBER(15) :=NULL
58 , ORIG_SYSTEM_BILL_CUSTOMER_REF VARCHAR2(240) :=NULL
59 , ORIG_SYSTEM_BILL_CUSTOMER_ID NUMBER(15) :=NULL
60 , ORIG_SYSTEM_BILL_ADDRESS_REF VARCHAR2(240) :=NULL
61 , ORIG_SYSTEM_BILL_ADDRESS_ID NUMBER(15) :=NULL
62 , ORIG_SYSTEM_BILL_CONTACT_REF VARCHAR2(240) :=NULL
63 , ORIG_SYSTEM_BILL_CONTACT_ID NUMBER(15) :=NULL
64 , ORIG_SYSTEM_SHIP_CUSTOMER_REF VARCHAR2(240) :=NULL
65 , ORIG_SYSTEM_SHIP_CUSTOMER_ID NUMBER(15) :=NULL
66 , ORIG_SYSTEM_SHIP_ADDRESS_REF VARCHAR2(240) :=NULL
67 , ORIG_SYSTEM_SHIP_ADDRESS_ID NUMBER(15) :=NULL
68 , ORIG_SYSTEM_SHIP_CONTACT_REF VARCHAR2(240) :=NULL
69 , ORIG_SYSTEM_SHIP_CONTACT_ID NUMBER(15) :=NULL
70 , ORIG_SYSTEM_SOLD_CUSTOMER_REF VARCHAR2(240) :=NULL
71 , ORIG_SYSTEM_SOLD_CUSTOMER_ID NUMBER(15) :=NULL
72 , LINK_TO_LINE_ID NUMBER(15) :=NULL
73 , LINK_TO_LINE_CONTEXT VARCHAR2(30) :=NULL
74 , LINK_TO_LINE_ATTRIBUTE1 VARCHAR2(30) :=NULL
75 , LINK_TO_LINE_ATTRIBUTE2 VARCHAR2(30) :=NULL
76 , LINK_TO_LINE_ATTRIBUTE3 VARCHAR2(30) :=NULL
77 , LINK_TO_LINE_ATTRIBUTE4 VARCHAR2(30) :=NULL
78 , LINK_TO_LINE_ATTRIBUTE5 VARCHAR2(30) :=NULL
79 , LINK_TO_LINE_ATTRIBUTE6 VARCHAR2(30) :=NULL
80 , LINK_TO_LINE_ATTRIBUTE7 VARCHAR2(30) :=NULL
81 , LINK_TO_LINE_ATTRIBUTE8 VARCHAR2(30) :=NULL
82 , LINK_TO_LINE_ATTRIBUTE9 VARCHAR2(30) :=NULL
83 , LINK_TO_LINE_ATTRIBUTE10 VARCHAR2(30) :=NULL
84 , LINK_TO_LINE_ATTRIBUTE11 VARCHAR2(30) :=NULL
85 , LINK_TO_LINE_ATTRIBUTE12 VARCHAR2(30) :=NULL
86 , LINK_TO_LINE_ATTRIBUTE13 VARCHAR2(30) :=NULL
87 , LINK_TO_LINE_ATTRIBUTE14 VARCHAR2(30) :=NULL
88 , LINK_TO_LINE_ATTRIBUTE15 VARCHAR2(30) :=NULL
89 , RECEIPT_METHOD_NAME VARCHAR2(30) :=NULL
90 , RECEIPT_METHOD_ID NUMBER(15) :=NULL
91 , CUSTOMER_TRX_ID NUMBER(15) :=NULL
92 , TRX_DATE DATE :=NULL
93 , GL_DATE DATE :=NULL
94 , DOCUMENT_NUMBER NUMBER(15) :=NULL
95 , DOCUMENT_NUMBER_SEQUENCE_ID NUMBER(15) :=NULL
96 , TRX_NUMBER VARCHAR2(20) :=NULL
97 , QUANTITY NUMBER :=NULL
98 , QUANTITY_ORDERED NUMBER :=NULL
99 , UNIT_SELLING_PRICE NUMBER :=NULL
100 , UNIT_STANDARD_PRICE NUMBER :=NULL
101 , UOM_CODE VARCHAR2(3) :=NULL
102 , UOM_NAME VARCHAR2(25) :=NULL
103 , PRINTING_OPTION VARCHAR2(20) :=NULL
104 , INTERFACE_STATUS VARCHAR2(1) :=NULL
105 , REQUEST_ID NUMBER(15) :=NULL
106 , RELATED_BATCH_SOURCE_NAME VARCHAR2(50) :=NULL
107 , RELATED_TRX_NUMBER VARCHAR2(20) :=NULL
108 , RELATED_CUSTOMER_TRX_ID NUMBER(15) :=NULL
109 , PREVIOUS_CUSTOMER_TRX_ID NUMBER(15) :=NULL
110 , INITIAL_CUSTOMER_TRX_ID NUMBER(15) :=NULL
111 , CREDIT_METHOD_FOR_ACCT_RULE VARCHAR2(30) :=NULL
115 , TAX_RATE NUMBER :=NULL
112 , CREDIT_METHOD_FOR_INSTALLMENTS VARCHAR2(30) :=NULL
113 , REASON_CODE_MEANING VARCHAR2(80) :=NULL
114 , REASON_CODE VARCHAR2(30) :=NULL
116 , TAX_CODE VARCHAR2(50) :=NULL
117 , TAX_PRECEDENCE NUMBER :=NULL
118 , TAX_EXEMPT_FLAG VARCHAR2(1) :=NULL
119 , TAX_EXEMPT_NUMBER VARCHAR2(80) :=NULL
120 , TAX_EXEMPT_REASON_CODE VARCHAR2(30) :=NULL
121 , EXCEPTION_ID NUMBER(15) :=NULL
122 , EXEMPTION_ID NUMBER(15) :=NULL
123 , SHIP_DATE_ACTUAL DATE :=NULL
124 , FOB_POINT VARCHAR2(30) :=NULL
125 , SHIP_VIA VARCHAR2(25) :=NULL
126 , WAYBILL_NUMBER VARCHAR2(50) :=NULL
127 , INVOICING_RULE_NAME VARCHAR2(30) :=NULL
128 , INVOICING_RULE_ID NUMBER(15) :=NULL
129 , ACCOUNTING_RULE_NAME VARCHAR2(30) :=NULL
130 , ACCOUNTING_RULE_ID NUMBER(15) :=NULL
131 , ACCOUNTING_RULE_DURATION NUMBER(15) :=NULL
132 , RULE_START_DATE DATE :=NULL
133 , RULE_END_DATE DATE :=NULL --ER 4893057
134 , PRIMARY_SALESREP_NUMBER VARCHAR2(30) :=NULL
135 , PRIMARY_SALESREP_ID NUMBER(15) :=NULL
136 , SALES_ORDER VARCHAR2(50) :=NULL
137 , SALES_ORDER_LINE VARCHAR2(30) :=NULL
138 , SALES_ORDER_DATE DATE :=NULL
139 , SALES_ORDER_SOURCE VARCHAR2(50) :=NULL
140 , SALES_ORDER_REVISION NUMBER :=NULL
141 , PURCHASE_ORDER VARCHAR2(50) :=NULL
142 , PURCHASE_ORDER_REVISION VARCHAR2(50) :=NULL
143 , PURCHASE_ORDER_DATE DATE :=NULL
144 , AGREEMENT_NAME VARCHAR2(30) :=NULL
145 , AGREEMENT_ID NUMBER(15) :=NULL
146 , MEMO_LINE_NAME VARCHAR2(50) :=NULL
147 , MEMO_LINE_ID NUMBER(15) :=NULL
148 , INVENTORY_ITEM_ID NUMBER(15) :=NULL
149 , MTL_SYSTEM_ITEMS_SEG1 VARCHAR2(30) :=NULL
150 , MTL_SYSTEM_ITEMS_SEG2 VARCHAR2(30) :=NULL
151 , MTL_SYSTEM_ITEMS_SEG3 VARCHAR2(30) :=NULL
152 , MTL_SYSTEM_ITEMS_SEG4 VARCHAR2(30) :=NULL
153 , MTL_SYSTEM_ITEMS_SEG5 VARCHAR2(30) :=NULL
154 , MTL_SYSTEM_ITEMS_SEG6 VARCHAR2(30) :=NULL
155 , MTL_SYSTEM_ITEMS_SEG7 VARCHAR2(30) :=NULL
156 , MTL_SYSTEM_ITEMS_SEG8 VARCHAR2(30) :=NULL
157 , MTL_SYSTEM_ITEMS_SEG9 VARCHAR2(30) :=NULL
158 , MTL_SYSTEM_ITEMS_SEG10 VARCHAR2(30) :=NULL
159 , MTL_SYSTEM_ITEMS_SEG11 VARCHAR2(30) :=NULL
160 , MTL_SYSTEM_ITEMS_SEG12 VARCHAR2(30) :=NULL
161 , MTL_SYSTEM_ITEMS_SEG13 VARCHAR2(30) :=NULL
162 , MTL_SYSTEM_ITEMS_SEG14 VARCHAR2(30) :=NULL
163 , MTL_SYSTEM_ITEMS_SEG15 VARCHAR2(30) :=NULL
164 , MTL_SYSTEM_ITEMS_SEG16 VARCHAR2(30) :=NULL
165 , MTL_SYSTEM_ITEMS_SEG17 VARCHAR2(30) :=NULL
166 , MTL_SYSTEM_ITEMS_SEG18 VARCHAR2(30) :=NULL
167 , MTL_SYSTEM_ITEMS_SEG19 VARCHAR2(30) :=NULL
168 , MTL_SYSTEM_ITEMS_SEG20 VARCHAR2(30) :=NULL
169 , REFERENCE_LINE_ID NUMBER(15) :=NULL
170 , REFERENCE_LINE_CONTEXT VARCHAR2(30) :=NULL
171 , REFERENCE_LINE_ATTRIBUTE1 VARCHAR2(30) :=NULL
172 , REFERENCE_LINE_ATTRIBUTE2 VARCHAR2(30) :=NULL
173 , REFERENCE_LINE_ATTRIBUTE3 VARCHAR2(30) :=NULL
174 , REFERENCE_LINE_ATTRIBUTE4 VARCHAR2(30) :=NULL
175 , REFERENCE_LINE_ATTRIBUTE5 VARCHAR2(30) :=NULL
179 , REFERENCE_LINE_ATTRIBUTE9 VARCHAR2(30) :=NULL
176 , REFERENCE_LINE_ATTRIBUTE6 VARCHAR2(30) :=NULL
177 , REFERENCE_LINE_ATTRIBUTE7 VARCHAR2(30) :=NULL
178 , REFERENCE_LINE_ATTRIBUTE8 VARCHAR2(30) :=NULL
180 , REFERENCE_LINE_ATTRIBUTE10 VARCHAR2(30) :=NULL
181 , REFERENCE_LINE_ATTRIBUTE11 VARCHAR2(30) :=NULL
182 , REFERENCE_LINE_ATTRIBUTE12 VARCHAR2(30) :=NULL
183 , REFERENCE_LINE_ATTRIBUTE13 VARCHAR2(30) :=NULL
184 , REFERENCE_LINE_ATTRIBUTE14 VARCHAR2(30) :=NULL
185 , REFERENCE_LINE_ATTRIBUTE15 VARCHAR2(30) :=NULL
186 , TERRITORY_ID NUMBER(15) :=NULL
187 , TERRITORY_SEGMENT1 VARCHAR2(25) :=NULL
188 , TERRITORY_SEGMENT2 VARCHAR2(25) :=NULL
189 , TERRITORY_SEGMENT3 VARCHAR2(25) :=NULL
190 , TERRITORY_SEGMENT4 VARCHAR2(25) :=NULL
191 , TERRITORY_SEGMENT5 VARCHAR2(25) :=NULL
192 , TERRITORY_SEGMENT6 VARCHAR2(25) :=NULL
193 , TERRITORY_SEGMENT7 VARCHAR2(25) :=NULL
194 , TERRITORY_SEGMENT8 VARCHAR2(25) :=NULL
195 , TERRITORY_SEGMENT9 VARCHAR2(25) :=NULL
196 , TERRITORY_SEGMENT10 VARCHAR2(25) :=NULL
197 , TERRITORY_SEGMENT11 VARCHAR2(25) :=NULL
198 , TERRITORY_SEGMENT12 VARCHAR2(25) :=NULL
199 , TERRITORY_SEGMENT13 VARCHAR2(25) :=NULL
200 , TERRITORY_SEGMENT14 VARCHAR2(25) :=NULL
201 , TERRITORY_SEGMENT15 VARCHAR2(25) :=NULL
202 , TERRITORY_SEGMENT16 VARCHAR2(25) :=NULL
203 , TERRITORY_SEGMENT17 VARCHAR2(25) :=NULL
204 , TERRITORY_SEGMENT18 VARCHAR2(25) :=NULL
205 , TERRITORY_SEGMENT19 VARCHAR2(25) :=NULL
206 , TERRITORY_SEGMENT20 VARCHAR2(25) :=NULL
207 , ATTRIBUTE_CATEGORY VARCHAR2(30) :=NULL
208 , ATTRIBUTE1 VARCHAR2(150) :=NULL
209 , ATTRIBUTE2 VARCHAR2(150) :=NULL
210 , ATTRIBUTE3 VARCHAR2(150) :=NULL
211 , ATTRIBUTE4 VARCHAR2(150) :=NULL
212 , ATTRIBUTE5 VARCHAR2(150) :=NULL
213 , ATTRIBUTE6 VARCHAR2(150) :=NULL
214 , ATTRIBUTE7 VARCHAR2(150) :=NULL
215 , ATTRIBUTE8 VARCHAR2(150) :=NULL
216 , ATTRIBUTE9 VARCHAR2(150) :=NULL
217 , ATTRIBUTE10 VARCHAR2(150) :=NULL
218 , ATTRIBUTE11 VARCHAR2(150) :=NULL
219 , ATTRIBUTE12 VARCHAR2(150) :=NULL
220 , ATTRIBUTE13 VARCHAR2(150) :=NULL
221 , ATTRIBUTE14 VARCHAR2(150) :=NULL
222 , ATTRIBUTE15 VARCHAR2(150) :=NULL
223 , HEADER_ATTRIBUTE_CATEGORY VARCHAR2(30) :=NULL
224 , HEADER_ATTRIBUTE1 VARCHAR2(150) :=NULL
225 , HEADER_ATTRIBUTE2 VARCHAR2(150) :=NULL
226 , HEADER_ATTRIBUTE3 VARCHAR2(150) :=NULL
227 , HEADER_ATTRIBUTE4 VARCHAR2(150) :=NULL
228 , HEADER_ATTRIBUTE5 VARCHAR2(150) :=NULL
229 , HEADER_ATTRIBUTE6 VARCHAR2(150) :=NULL
230 , HEADER_ATTRIBUTE7 VARCHAR2(150) :=NULL
231 , HEADER_ATTRIBUTE8 VARCHAR2(150) :=NULL
232 , HEADER_ATTRIBUTE9 VARCHAR2(150) :=NULL
233 , HEADER_ATTRIBUTE10 VARCHAR2(150) :=NULL
234 , HEADER_ATTRIBUTE11 VARCHAR2(150) :=NULL
235 , HEADER_ATTRIBUTE12 VARCHAR2(150) :=NULL
236 , HEADER_ATTRIBUTE13 VARCHAR2(150) :=NULL
237 , HEADER_ATTRIBUTE14 VARCHAR2(150) :=NULL
238 , HEADER_ATTRIBUTE15 VARCHAR2(150) :=NULL
239 , COMMENTS VARCHAR2(240) :=NULL
240 , INTERNAL_NOTES VARCHAR2(240) :=NULL
241 , MOVEMENT_ID NUMBER(15) :=NULL
242 , ORG_ID NUMBER(15) :=NULL
243 , CUSTOMER_BANK_ACCOUNT_ID NUMBER(15) :=NULL
244 , CUSTOMER_BANK_ACCOUNT_NAME VARCHAR2(80) :=NULL
245 , APPROVAL_CODE VARCHAR2(80) :=NULL
246 , PAYMENT_SERVER_ORDER_NUM VARCHAR2(80) :=NULL
247 , LINE_GDF_ATTR_CATEGORY VARCHAR2(30) :=NULL
248 , LINE_GDF_ATTRIBUTE1 VARCHAR2(150) :=NULL
249 , LINE_GDF_ATTRIBUTE2 VARCHAR2(150) :=NULL
250 , LINE_GDF_ATTRIBUTE3 VARCHAR2(150) :=NULL
251 , LINE_GDF_ATTRIBUTE4 VARCHAR2(150) :=NULL
252 , LINE_GDF_ATTRIBUTE5 VARCHAR2(150) :=NULL
253 , LINE_GDF_ATTRIBUTE6 VARCHAR2(150) :=NULL
254 , LINE_GDF_ATTRIBUTE7 VARCHAR2(150) :=NULL
255 , LINE_GDF_ATTRIBUTE8 VARCHAR2(150) :=NULL
256 , LINE_GDF_ATTRIBUTE9 VARCHAR2(150) :=NULL
257 , LINE_GDF_ATTRIBUTE10 VARCHAR2(150) :=NULL
258 , LINE_GDF_ATTRIBUTE11 VARCHAR2(150) :=NULL
259 , LINE_GDF_ATTRIBUTE12 VARCHAR2(150) :=NULL
260 , LINE_GDF_ATTRIBUTE13 VARCHAR2(150) :=NULL
261 , LINE_GDF_ATTRIBUTE14 VARCHAR2(150) :=NULL
262 , LINE_GDF_ATTRIBUTE15 VARCHAR2(150) :=NULL
263 , LINE_GDF_ATTRIBUTE16 VARCHAR2(150) :=NULL
264 , LINE_GDF_ATTRIBUTE17 VARCHAR2(150) :=NULL
265 , LINE_GDF_ATTRIBUTE18 VARCHAR2(150) :=NULL
266 , LINE_GDF_ATTRIBUTE19 VARCHAR2(150) :=NULL
267 , LINE_GDF_ATTRIBUTE20 VARCHAR2(150) :=NULL
268 , HEADER_GDF_ATTR_CATEGORY VARCHAR2(30) :=NULL
269 , HEADER_GDF_ATTRIBUTE1 VARCHAR2(150) :=NULL
270 , HEADER_GDF_ATTRIBUTE2 VARCHAR2(150) :=NULL
271 , HEADER_GDF_ATTRIBUTE3 VARCHAR2(150) :=NULL
272 , HEADER_GDF_ATTRIBUTE4 VARCHAR2(150) :=NULL
273 , HEADER_GDF_ATTRIBUTE5 VARCHAR2(150) :=NULL
274 , HEADER_GDF_ATTRIBUTE6 VARCHAR2(150) :=NULL
275 , HEADER_GDF_ATTRIBUTE7 VARCHAR2(150) :=NULL
276 , HEADER_GDF_ATTRIBUTE8 VARCHAR2(150) :=NULL
280 , HEADER_GDF_ATTRIBUTE12 VARCHAR2(150) :=NULL
277 , HEADER_GDF_ATTRIBUTE9 VARCHAR2(150) :=NULL
278 , HEADER_GDF_ATTRIBUTE10 VARCHAR2(150) :=NULL
279 , HEADER_GDF_ATTRIBUTE11 VARCHAR2(150) :=NULL
281 , HEADER_GDF_ATTRIBUTE13 VARCHAR2(150) :=NULL
282 , HEADER_GDF_ATTRIBUTE14 VARCHAR2(150) :=NULL
283 , HEADER_GDF_ATTRIBUTE15 VARCHAR2(150) :=NULL
284 , HEADER_GDF_ATTRIBUTE16 VARCHAR2(150) :=NULL
285 , HEADER_GDF_ATTRIBUTE17 VARCHAR2(150) :=NULL
286 , HEADER_GDF_ATTRIBUTE18 VARCHAR2(150) :=NULL
287 , HEADER_GDF_ATTRIBUTE19 VARCHAR2(150) :=NULL
288 , HEADER_GDF_ATTRIBUTE20 VARCHAR2(150) :=NULL
289 , HEADER_GDF_ATTRIBUTE21 VARCHAR2(150) :=NULL
290 , HEADER_GDF_ATTRIBUTE22 VARCHAR2(150) :=NULL
291 , HEADER_GDF_ATTRIBUTE23 VARCHAR2(150) :=NULL
292 , HEADER_GDF_ATTRIBUTE24 VARCHAR2(150) :=NULL
293 , HEADER_GDF_ATTRIBUTE25 VARCHAR2(150) :=NULL
294 , HEADER_GDF_ATTRIBUTE26 VARCHAR2(150) :=NULL
295 , HEADER_GDF_ATTRIBUTE27 VARCHAR2(150) :=NULL
296 , HEADER_GDF_ATTRIBUTE28 VARCHAR2(150) :=NULL
297 , HEADER_GDF_ATTRIBUTE29 VARCHAR2(150) :=NULL
298 , HEADER_GDF_ATTRIBUTE30 VARCHAR2(150) :=NULL
299 , PROMISED_COMMITMENT_AMOUNT NUMBER :=NULL
300 /* START PREPAYMENT */
301 , PAYMENT_SET_ID NUMBER(15) :=NULL
302 /* END PREPAYMENT */
303 , TRANSLATED_DESCRIPTION VARCHAR2(1000) :=NULL
304 --Customer Acceptance
305 , PARENT_LINE_ID NUMBER(15) :=NULL
306 , DEFERRAL_EXCLUSION_FLAG VARCHAR2(1) :=NULL
307 , PAYMENT_TRXN_EXTENSION_ID NUMBER(15) := NULL
308 , PAYMENT_TYPE_CODE VARCHAR2(30) := NULL --8427382
309 );
310
311 TYPE RA_Interface_Lines_Tbl_Type IS TABLE OF RA_Interface_Lines_Rec_Type
312 INDEX BY BINARY_INTEGER;
313
314 --Customer Acceptance
315 TYPE RA_Interface_Conts_Rec_Type IS RECORD
316 (
317 INTERFACE_CONTINGENCY_ID NUMBER :=NULL
318 ,CONTINGENCY_ID NUMBER :=NULL
319 ,COMPLETED_FLAG VARCHAR(1) :=NULL
320 ,EXPIRATION_EVENT_DATE DATE :=NULL
321 ,EXPIRATION_DATE DATE :=NULL
322 ,EXPIRATION_DAYS NUMBER :=NULL
323 ,COMPLETED_BY NUMBER := NULL
324 ,INTERFACE_LINE_ID NUMBER :=NULL
325 ,INTERFACE_LINE_CONTEXT VARCHAR2(30) :=NULL
326 ,INTERFACE_LINE_ATTRIBUTE1 VARCHAR2(30) :=NULL
327 ,INTERFACE_LINE_ATTRIBUTE2 VARCHAR2(30) :=NULL
328 ,INTERFACE_LINE_ATTRIBUTE3 VARCHAR2(30) :=NULL
329 ,INTERFACE_LINE_ATTRIBUTE4 VARCHAR2(30) :=NULL
330 ,INTERFACE_LINE_ATTRIBUTE5 VARCHAR2(30) :=NULL
331 , INTERFACE_LINE_ATTRIBUTE6 VARCHAR2(30) :=NULL
332 , INTERFACE_LINE_ATTRIBUTE7 VARCHAR2(30) :=NULL
333 , INTERFACE_LINE_ATTRIBUTE8 VARCHAR2(30) :=NULL
334 , INTERFACE_LINE_ATTRIBUTE9 VARCHAR2(30) :=NULL
335 , INTERFACE_LINE_ATTRIBUTE10 VARCHAR2(30) :=NULL
336 , INTERFACE_LINE_ATTRIBUTE11 VARCHAR2(30) :=NULL
337 , INTERFACE_LINE_ATTRIBUTE12 VARCHAR2(30) :=NULL
338 , INTERFACE_LINE_ATTRIBUTE13 VARCHAR2(30) :=NULL
339 , INTERFACE_LINE_ATTRIBUTE14 VARCHAR2(30) :=NULL
340 , INTERFACE_LINE_ATTRIBUTE15 VARCHAR2(30) :=NULL
341 , INTERFACE_STATUS VARCHAR2(1) :=NULL
342 , ATTRIBUTE_CATEGORY VARCHAR2(30) :=NULL
343 , ATTRIBUTE1 VARCHAR2(30) :=NULL
344 , ATTRIBUTE2 VARCHAR2(30) :=NULL
345 , ATTRIBUTE3 VARCHAR2(30) :=NULL
346 , ATTRIBUTE4 VARCHAR2(30) :=NULL
347 , ATTRIBUTE5 VARCHAR2(30) :=NULL
348 , ATTRIBUTE6 VARCHAR2(30) :=NULL
349 , ATTRIBUTE7 VARCHAR2(30) :=NULL
350 , ATTRIBUTE8 VARCHAR2(30) :=NULL
351 , ATTRIBUTE9 VARCHAR2(30) :=NULL
352 , ATTRIBUTE10 VARCHAR2(30) :=NULL
353 , ATTRIBUTE11 VARCHAR2(30) :=NULL
354 , ATTRIBUTE12 VARCHAR2(30) :=NULL
355 , ATTRIBUTE13 VARCHAR2(30) :=NULL
356 , ATTRIBUTE14 VARCHAR2(30) :=NULL
357 , ATTRIBUTE15 VARCHAR2(30) :=NULL
358 , ORG_ID NUMBER :=NULL
359 , REQUEST_ID NUMBER :=NULL
360 , CREATED_BY NUMBER :=NULL
361 , CREATION_DATE DATE :=NULL
362 , LAST_UPDATED_BY NUMBER :=NULL
363 , LAST_UPDATE_DATE DATE :=NULL
364 , LAST_UPDATE_LOGIN NUMBER :=NULL
365 );
366
367 TYPE RA_Interface_Conts_Tbl_Type IS TABLE OF RA_Interface_Conts_Rec_Type
368 INDEX BY BINARY_INTEGER;
369 --Customer Acceptance
370
371
372 TYPE Id_Tbl_Type IS TABLE OF NUMBER
373 INDEX BY BINARY_INTEGER;
374
375
376 -- JG flexfield record type
377 TYPE OE_GDF_Rec_Type IS RECORD
378 ( INVENTORY_ITEM_ID NUMBER(15) :=NULL
379 , LINE_TYPE VARCHAR2(20) :=NULL
380 , INTERFACE_LINE_ATTRIBUTE3 VARCHAR2(30) :=NULL
381 , INTERFACE_LINE_ATTRIBUTE6 VARCHAR2(30) :=NULL
382 , LINE_GDF_ATTR_CATEGORY VARCHAR2(30) :=NULL
383 , LINE_GDF_ATTRIBUTE1 VARCHAR2(150) :=NULL
384 , LINE_GDF_ATTRIBUTE2 VARCHAR2(150) :=NULL
385 , LINE_GDF_ATTRIBUTE3 VARCHAR2(150) :=NULL
386 , LINE_GDF_ATTRIBUTE4 VARCHAR2(150) :=NULL
387 , LINE_GDF_ATTRIBUTE5 VARCHAR2(150) :=NULL
391 , LINE_GDF_ATTRIBUTE9 VARCHAR2(150) :=NULL
388 , LINE_GDF_ATTRIBUTE6 VARCHAR2(150) :=NULL
389 , LINE_GDF_ATTRIBUTE7 VARCHAR2(150) :=NULL
390 , LINE_GDF_ATTRIBUTE8 VARCHAR2(150) :=NULL
392 , LINE_GDF_ATTRIBUTE10 VARCHAR2(150) :=NULL
393 , LINE_GDF_ATTRIBUTE11 VARCHAR2(150) :=NULL
394 , LINE_GDF_ATTRIBUTE12 VARCHAR2(150) :=NULL
395 , LINE_GDF_ATTRIBUTE13 VARCHAR2(150) :=NULL
396 , LINE_GDF_ATTRIBUTE14 VARCHAR2(150) :=NULL
397 , LINE_GDF_ATTRIBUTE15 VARCHAR2(150) :=NULL
398 , LINE_GDF_ATTRIBUTE16 VARCHAR2(150) :=NULL
399 , LINE_GDF_ATTRIBUTE17 VARCHAR2(150) :=NULL
400 , LINE_GDF_ATTRIBUTE18 VARCHAR2(150) :=NULL
401 , LINE_GDF_ATTRIBUTE19 VARCHAR2(150) :=NULL
402 , LINE_GDF_ATTRIBUTE20 VARCHAR2(150) :=NULL
403 , HEADER_GDF_ATTR_CATEGORY VARCHAR2(30) :=NULL
404 , HEADER_GDF_ATTRIBUTE1 VARCHAR2(150) :=NULL
405 , HEADER_GDF_ATTRIBUTE2 VARCHAR2(150) :=NULL
406 , HEADER_GDF_ATTRIBUTE3 VARCHAR2(150) :=NULL
407 , HEADER_GDF_ATTRIBUTE4 VARCHAR2(150) :=NULL
408 , HEADER_GDF_ATTRIBUTE5 VARCHAR2(150) :=NULL
409 , HEADER_GDF_ATTRIBUTE6 VARCHAR2(150) :=NULL
410 , HEADER_GDF_ATTRIBUTE7 VARCHAR2(150) :=NULL
411 , HEADER_GDF_ATTRIBUTE8 VARCHAR2(150) :=NULL
412 , HEADER_GDF_ATTRIBUTE9 VARCHAR2(150) :=NULL
413 , HEADER_GDF_ATTRIBUTE10 VARCHAR2(150) :=NULL
414 , HEADER_GDF_ATTRIBUTE11 VARCHAR2(150) :=NULL
415 , HEADER_GDF_ATTRIBUTE12 VARCHAR2(150) :=NULL
416 , HEADER_GDF_ATTRIBUTE13 VARCHAR2(150) :=NULL
417 , HEADER_GDF_ATTRIBUTE14 VARCHAR2(150) :=NULL
418 , HEADER_GDF_ATTRIBUTE15 VARCHAR2(150) :=NULL
419 , HEADER_GDF_ATTRIBUTE16 VARCHAR2(150) :=NULL
420 , HEADER_GDF_ATTRIBUTE17 VARCHAR2(150) :=NULL
421 , HEADER_GDF_ATTRIBUTE18 VARCHAR2(150) :=NULL
422 , HEADER_GDF_ATTRIBUTE19 VARCHAR2(150) :=NULL
423 , HEADER_GDF_ATTRIBUTE20 VARCHAR2(150) :=NULL
424 , HEADER_GDF_ATTRIBUTE21 VARCHAR2(150) :=NULL
425 , HEADER_GDF_ATTRIBUTE22 VARCHAR2(150) :=NULL
426 , HEADER_GDF_ATTRIBUTE23 VARCHAR2(150) :=NULL
427 , HEADER_GDF_ATTRIBUTE24 VARCHAR2(150) :=NULL
428 , HEADER_GDF_ATTRIBUTE25 VARCHAR2(150) :=NULL
429 , HEADER_GDF_ATTRIBUTE26 VARCHAR2(150) :=NULL
430 , HEADER_GDF_ATTRIBUTE27 VARCHAR2(150) :=NULL
431 , HEADER_GDF_ATTRIBUTE28 VARCHAR2(150) :=NULL
432 , HEADER_GDF_ATTRIBUTE29 VARCHAR2(150) :=NULL
433 , HEADER_GDF_ATTRIBUTE30 VARCHAR2(150) :=NULL
434 );
435
436 -- Ra Interface Salescredits record type
437
438 TYPE RA_Interface_Scredits_Rec_Type IS RECORD
439 ( CREATED_BY NUMBER(15) :=NULL
440 , CREATION_DATE DATE :=NULL
441 , LAST_UPDATED_BY NUMBER(15) :=NULL
442 , LAST_UPDATE_DATE DATE :=NULL
443 , INTERFACE_SALESCREDIT_ID NUMBER(15) :=NULL
444 , INTERFACE_LINE_ID NUMBER(15) :=NULL
445 , INTERFACE_LINE_CONTEXT VARCHAR2(30) :=NULL
446 , INTERFACE_LINE_ATTRIBUTE1 VARCHAR2(30) :=NULL
447 , INTERFACE_LINE_ATTRIBUTE2 VARCHAR2(30) :=NULL
448 , INTERFACE_LINE_ATTRIBUTE3 VARCHAR2(30) :=NULL
449 , INTERFACE_LINE_ATTRIBUTE4 VARCHAR2(30) :=NULL
450 , INTERFACE_LINE_ATTRIBUTE5 VARCHAR2(30) :=NULL
451 , INTERFACE_LINE_ATTRIBUTE6 VARCHAR2(30) :=NULL
452 , INTERFACE_LINE_ATTRIBUTE7 VARCHAR2(30) :=NULL
453 , INTERFACE_LINE_ATTRIBUTE8 VARCHAR2(30) :=NULL
454 , INTERFACE_LINE_ATTRIBUTE9 VARCHAR2(30) :=NULL
455 , INTERFACE_LINE_ATTRIBUTE10 VARCHAR2(30) :=NULL
456 , INTERFACE_LINE_ATTRIBUTE11 VARCHAR2(30) :=NULL
457 , INTERFACE_LINE_ATTRIBUTE12 VARCHAR2(30) :=NULL
458 , INTERFACE_LINE_ATTRIBUTE13 VARCHAR2(30) :=NULL
459 , INTERFACE_LINE_ATTRIBUTE14 VARCHAR2(30) :=NULL
460 , INTERFACE_LINE_ATTRIBUTE15 VARCHAR2(30) :=NULL
461 , SALESREP_NUMBER VARCHAR2(30) :=NULL
462 , SALESREP_ID NUMBER(15) :=NULL
463 , SALES_CREDIT_TYPE_NAME VARCHAR2(30) :=NULL
464 , SALES_CREDIT_TYPE_ID NUMBER(15) :=NULL
465 , SALES_CREDIT_AMOUNT_SPLIT NUMBER :=NULL
466 , SALES_CREDIT_PERCENT_SPLIT NUMBER :=NULL
467 , INTERFACE_STATUS VARCHAR2(1) :=NULL
468 , REQUEST_ID NUMBER(15) :=NULL
469 , ATTRIBUTE_CATEGORY VARCHAR2(30) :=NULL
470 , ATTRIBUTE1 VARCHAR2(150) :=NULL
471 , ATTRIBUTE2 VARCHAR2(150) :=NULL
472 , ATTRIBUTE3 VARCHAR2(150) :=NULL
473 , ATTRIBUTE4 VARCHAR2(150) :=NULL
474 , ATTRIBUTE5 VARCHAR2(150) :=NULL
475 , ATTRIBUTE6 VARCHAR2(150) :=NULL
476 , ATTRIBUTE7 VARCHAR2(150) :=NULL
477 , ATTRIBUTE8 VARCHAR2(150) :=NULL
478 , ATTRIBUTE9 VARCHAR2(150) :=NULL
479 , ATTRIBUTE10 VARCHAR2(150) :=NULL
480 , ATTRIBUTE11 VARCHAR2(150) :=NULL
481 , ATTRIBUTE12 VARCHAR2(150) :=NULL
482 , ATTRIBUTE13 VARCHAR2(150) :=NULL
483 , ATTRIBUTE14 VARCHAR2(150) :=NULL
484 , ATTRIBUTE15 VARCHAR2(150) :=NULL
485 , ORG_ID NUMBER(15) :=NULL
486 --SG{
487 , SALES_GROUP_ID NUMBER :=NULL
488 --SG}
489 );
490
491 TYPE RA_Interface_Scredits_Tbl_Type IS TABLE OF RA_Interface_Scredits_Rec_Type
492 INDEX BY BINARY_INTEGER;
493
494 PROCEDURE Interface_Line
495 ( p_line_id IN NUMBER
496 , p_itemtype IN VARCHAR2
497 , x_result_out OUT NOCOPY VARCHAR2
498 , x_return_status OUT NOCOPY VARCHAR2
499 );
500
501 PROCEDURE Interface_Header
502 ( p_header_id IN NUMBER
503 , p_itemtype IN VARCHAR2
504 , x_result_out OUT NOCOPY VARCHAR2
505 , x_return_status OUT NOCOPY VARCHAR2
506 );
507
508 FUNCTION Invoice_Balance
509 ( p_customer_trx_id IN NUMBER
510 ) RETURN NUMBER;
511
512 Procedure Any_Line_ARInterfaced( p_application_id IN NUMBER,
513 p_entity_short_name in VARCHAR2,
514 p_validation_entity_short_name in VARCHAR2,
515 p_validation_tmplt_short_name in VARCHAR2,
516 p_record_set_tmplt_short_name in VARCHAR2,
517 p_scope in VARCHAR2,
518 p_result OUT NOCOPY NUMBER );
519
520 Procedure All_Lines_ARInterfaced( p_application_id IN NUMBER,
521 p_entity_short_name in VARCHAR2,
522 p_validation_entity_short_name in VARCHAR2,
523 p_validation_tmplt_short_name in VARCHAR2,
524 p_record_set_tmplt_short_name in VARCHAR2,
525 p_scope in VARCHAR2,
526 p_result OUT NOCOPY NUMBER );
527
528 FUNCTION Get_Customer_Transaction_Type
529 ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
530 ) RETURN NUMBER;
531
532 FUNCTION Get_Customer_Transaction_Type
533 ( p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
534 ) RETURN NUMBER;
535
536
537 Procedure This_Line_ARInterfaced( p_application_id IN NUMBER,
538 p_entity_short_name in VARCHAR2,
539 p_validation_entity_short_name in VARCHAR2,
540 p_validation_tmplt_short_name in VARCHAR2,
541 p_record_set_tmplt_short_name in VARCHAR2,
542 p_scope in VARCHAR2,
543 p_result OUT NOCOPY NUMBER );
544
545 --retro{Made the procedure public
546 PROCEDURE Interface_Single_Line
547 ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
548 , p_header_rec IN OE_Order_PUB.Header_Rec_Type
549 , p_x_interface_line_rec IN OUT NOCOPY RA_Interface_Lines_Rec_Type
550 , x_return_status OUT NOCOPY VARCHAR2
551 , x_result_out OUT NOCOPY VARCHAR2
552 );
553 --retro}
554
555 --Customer Acceptance (Made the function public)
556 FUNCTION Shipping_info_Available
557 ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
558 )
559 RETURN BOOLEAN;
560
561 --SG{
562 G_AR_SALES_GROUP_ENABLED VARCHAR2(1):=NULL;
563 --SG}
564
565 -- Bug # 4454055
566 -- The function signature is brought to the API specification, as this same function
567 -- would be reused by other API's too.
568 -- This is done as a part of Deferred Revenue Project (Bug # 4454055).
569 --
570
571 FUNCTION Line_Invoiceable
572 ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
573 )
574 RETURN BOOLEAN ;
575
576
577
578 -- BUG# 7431368 : Performance fix : Start
579 G_INVOICE_HEADER_ID NUMBER;
580 G_INVOICE_LINE_ID NUMBER;
581 G_ORDER_TYPE VARCHAR2(30); -- Added for bug 10030712
582 G_ORDER_NUMBER NUMBER;
583
584 Procedure set_header_id ( p_header_id IN NUMBER);
585 Procedure set_line_id ( p_line_id IN NUMBER);
586 Procedure set_order_type ( p_order_type IN VARCHAR2 ); -- Added for bug 10030712
587 Procedure set_order_number ( p_order_number IN NUMBER ); -- Added for bug 10030712
588
589 Function get_header_id return NUMBER;
590 Function get_line_id return NUMBER;
591 Function get_order_type return VARCHAR2; -- Added for bug 10030712
592 Function get_order_number return VARCHAR2; -- Added for bug 10030712
593
594 -- BUG# 7431368 : Performance fix : End
595
596
597
598 END OE_Invoice_PUB;