[Home] [Help]
PACKAGE: APPS.OE_LINE_UTIL
Source
1 PACKAGE OE_Line_Util AS
2 /* $Header: OEXULINS.pls 120.5.12010000.1 2008/07/25 07:56:35 appldev ship $ */
3
4 -- Attributes global constants
5
6 G_ACCOUNTING_RULE CONSTANT NUMBER := 1;
7 G_ACTUAL_ARRIVAL_DATE CONSTANT NUMBER := 2;
8 G_ACTUAL_SHIPMENT_DATE CONSTANT NUMBER := 3;
9 G_AGREEMENT CONSTANT NUMBER := 4;
10 G_ATO_LINE CONSTANT NUMBER := 5;
11 G_ATTRIBUTE1 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE10 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE11 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE12 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE13 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE14 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE15 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE2 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE3 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE4 CONSTANT NUMBER := 15;
21 G_ATTRIBUTE5 CONSTANT NUMBER := 16;
22 G_ATTRIBUTE6 CONSTANT NUMBER := 17;
23 G_ATTRIBUTE7 CONSTANT NUMBER := 18;
24 G_ATTRIBUTE8 CONSTANT NUMBER := 19;
25 G_ATTRIBUTE9 CONSTANT NUMBER := 20;
26 G_AUTO_SELECTED_QUANTITY CONSTANT NUMBER := 21;
27 G_CANCELLED_QUANTITY CONSTANT NUMBER := 22;
28 G_COMPONENT CONSTANT NUMBER := 23;
29 G_COMPONENT_NUMBER CONSTANT NUMBER := 24;
30 G_COMPONENT_SEQUENCE CONSTANT NUMBER := 25;
31 G_CONFIG_DISPLAY_SEQUENCE CONSTANT NUMBER := 26;
32 G_CONFIGURATION CONSTANT NUMBER := 27;
33 G_CONTEXT CONSTANT NUMBER := 28;
34 G_CREATED_BY CONSTANT NUMBER := 31;
35 G_CREATION_DATE CONSTANT NUMBER := 32;
36 G_CUSTOMER_DOCK CONSTANT NUMBER := 33;
37 G_CUSTOMER_JOB CONSTANT NUMBER := 36;
38 G_CUSTOMER_PRODUCTION_LINE CONSTANT NUMBER := 37;
39 G_CUSTOMER_TRX_LINE CONSTANT NUMBER := 38;
40 G_CUST_MODEL_SERIAL_NUMBER CONSTANT NUMBER := 39;
41 G_CUST_PO_NUMBER CONSTANT NUMBER := 40;
42 G_DELIVERY_LEAD_TIME CONSTANT NUMBER := 41;
43 G_DELIVER_TO_CONTACT CONSTANT NUMBER := 42;
44 G_DELIVER_TO_ORG CONSTANT NUMBER := 43;
45 G_DEMAND_BUCKET_TYPE CONSTANT NUMBER := 44;
46 G_DEMAND_CLASS CONSTANT NUMBER := 45;
47 G_DEP_PLAN_REQUIRED CONSTANT NUMBER := 46;
48 G_EARLIEST_ACCEPTABLE_DATE CONSTANT NUMBER := 48;
49 G_EXPLOSION_DATE CONSTANT NUMBER := 49;
50 G_FOB_POINT CONSTANT NUMBER := 50;
51 G_FREIGHT_CARRIER CONSTANT NUMBER := 51;
52 G_FREIGHT_TERMS CONSTANT NUMBER := 52;
53 G_FULFILLED_QUANTITY CONSTANT NUMBER := 53;
54 G_GLOBAL_ATTRIBUTE1 CONSTANT NUMBER := 54;
55 G_GLOBAL_ATTRIBUTE10 CONSTANT NUMBER := 55;
56 G_GLOBAL_ATTRIBUTE11 CONSTANT NUMBER := 56;
57 G_GLOBAL_ATTRIBUTE12 CONSTANT NUMBER := 57;
58 G_GLOBAL_ATTRIBUTE13 CONSTANT NUMBER := 58;
59 G_GLOBAL_ATTRIBUTE14 CONSTANT NUMBER := 59;
60 G_GLOBAL_ATTRIBUTE15 CONSTANT NUMBER := 60;
61 G_GLOBAL_ATTRIBUTE16 CONSTANT NUMBER := 61;
62 G_GLOBAL_ATTRIBUTE17 CONSTANT NUMBER := 62;
63 G_GLOBAL_ATTRIBUTE18 CONSTANT NUMBER := 63;
64 G_GLOBAL_ATTRIBUTE19 CONSTANT NUMBER := 64;
65 G_GLOBAL_ATTRIBUTE2 CONSTANT NUMBER := 65;
66 G_GLOBAL_ATTRIBUTE20 CONSTANT NUMBER := 66;
67 G_GLOBAL_ATTRIBUTE3 CONSTANT NUMBER := 67;
68 G_GLOBAL_ATTRIBUTE4 CONSTANT NUMBER := 68;
69 G_GLOBAL_ATTRIBUTE5 CONSTANT NUMBER := 69;
70 G_GLOBAL_ATTRIBUTE6 CONSTANT NUMBER := 70;
71 G_GLOBAL_ATTRIBUTE7 CONSTANT NUMBER := 71;
72 G_GLOBAL_ATTRIBUTE8 CONSTANT NUMBER := 72;
73 G_GLOBAL_ATTRIBUTE9 CONSTANT NUMBER := 73;
74 G_GLOBAL_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 74;
75 G_HEADER CONSTANT NUMBER := 75;
76 G_INDUSTRY_ATTRIBUTE1 CONSTANT NUMBER := 76;
77 G_INDUSTRY_ATTRIBUTE10 CONSTANT NUMBER := 77;
78 G_INDUSTRY_ATTRIBUTE11 CONSTANT NUMBER := 78;
79 G_INDUSTRY_ATTRIBUTE12 CONSTANT NUMBER := 79;
80 G_INDUSTRY_ATTRIBUTE13 CONSTANT NUMBER := 80;
81 G_INDUSTRY_ATTRIBUTE14 CONSTANT NUMBER := 81;
82 G_INDUSTRY_ATTRIBUTE15 CONSTANT NUMBER := 82;
83 G_INDUSTRY_ATTRIBUTE2 CONSTANT NUMBER := 83;
84 G_INDUSTRY_ATTRIBUTE3 CONSTANT NUMBER := 84;
85 G_INDUSTRY_ATTRIBUTE4 CONSTANT NUMBER := 85;
86 G_INDUSTRY_ATTRIBUTE5 CONSTANT NUMBER := 86;
87 G_INDUSTRY_ATTRIBUTE6 CONSTANT NUMBER := 87;
88 G_INDUSTRY_ATTRIBUTE7 CONSTANT NUMBER := 88;
89 G_INDUSTRY_ATTRIBUTE8 CONSTANT NUMBER := 89;
90 G_INDUSTRY_ATTRIBUTE9 CONSTANT NUMBER := 90;
91 G_INDUSTRY_CONTEXT CONSTANT NUMBER := 91;
92 G_INTERMED_SHIP_TO_CONTACT CONSTANT NUMBER := 92;
93 G_INTERMED_SHIP_TO_ORG CONSTANT NUMBER := 93;
94 G_INVENTORY_ITEM CONSTANT NUMBER := 94;
95 G_INVOICE_INTERFACE_STATUS CONSTANT NUMBER := 95;
96 G_INVOICE_TO_CONTACT CONSTANT NUMBER := 100;
97 G_INVOICE_TO_ORG CONSTANT NUMBER := 101;
98 G_INVOICING_RULE CONSTANT NUMBER := 102;
99 G_ORDERED_ITEM CONSTANT NUMBER := 103;
100 G_ITEM_REVISION CONSTANT NUMBER := 104;
101 G_ITEM_TYPE CONSTANT NUMBER := 105;
102 G_LAST_UPDATED_BY CONSTANT NUMBER := 106;
103 G_LAST_UPDATE_DATE CONSTANT NUMBER := 107;
104 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 108;
105 G_LATEST_ACCEPTABLE_DATE CONSTANT NUMBER := 109;
106 G_LINE CONSTANT NUMBER := 110;
107 G_LINE_CATEGORY CONSTANT NUMBER := 111;
108 G_LINE_NUMBER CONSTANT NUMBER := 112;
109 G_LINE_TYPE CONSTANT NUMBER := 113;
110 G_LINK_TO_LINE CONSTANT NUMBER := 114;
111 G_MODEL_GROUP_NUMBER CONSTANT NUMBER := 118;
112 G_OPTION_FLAG CONSTANT NUMBER := 119;
113 G_OPTION_NUMBER CONSTANT NUMBER := 120;
114 G_ORDERED_QUANTITY CONSTANT NUMBER := 121;
115 G_ORDER_QUANTITY_UOM CONSTANT NUMBER := 122;
116 G_ORG CONSTANT NUMBER := 123;
117 G_ORIG_SYS_DOCUMENT_REF CONSTANT NUMBER := 124;
118 G_ORIG_SYS_LINE_REF CONSTANT NUMBER := 125;
119 G_PAYMENT_TERM CONSTANT NUMBER := 128;
120 G_PRICE_LIST CONSTANT NUMBER := 131;
121 G_PRICING_ATTRIBUTE1 CONSTANT NUMBER := 132;
122 G_PRICING_ATTRIBUTE10 CONSTANT NUMBER := 133;
123 G_PRICING_ATTRIBUTE2 CONSTANT NUMBER := 134;
124 G_PRICING_ATTRIBUTE3 CONSTANT NUMBER := 135;
125 G_PRICING_ATTRIBUTE4 CONSTANT NUMBER := 136;
126 G_PRICING_ATTRIBUTE5 CONSTANT NUMBER := 137;
127 G_PRICING_ATTRIBUTE6 CONSTANT NUMBER := 138;
128 G_PRICING_ATTRIBUTE7 CONSTANT NUMBER := 139;
129 G_PRICING_ATTRIBUTE8 CONSTANT NUMBER := 140;
130 G_PRICING_ATTRIBUTE9 CONSTANT NUMBER := 141;
131 G_PRICING_CONTEXT CONSTANT NUMBER := 142;
132 G_PRICING_DATE CONSTANT NUMBER := 143;
133 G_PRICING_QUANTITY CONSTANT NUMBER := 144;
134 G_PRICING_QUANTITY_UOM CONSTANT NUMBER := 145;
135 G_PROGRAM CONSTANT NUMBER := 146;
136 G_PROGRAM_APPLICATION CONSTANT NUMBER := 147;
137 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 148;
138 G_PROJECT CONSTANT NUMBER := 149;
139 G_PROMISE_DATE CONSTANT NUMBER := 150;
140 G_REFERENCE_HEADER CONSTANT NUMBER := 151;
141 G_REFERENCE_LINE CONSTANT NUMBER := 152;
142 G_REFERENCE_TYPE CONSTANT NUMBER := 153;
143 G_REQUEST CONSTANT NUMBER := 155;
144 G_REQUEST_DATE CONSTANT NUMBER := 156;
145 G_RESERVED_QUANTITY CONSTANT NUMBER := 157;
146 G_RETURN_ATTRIBUTE1 CONSTANT NUMBER := 159;
147 G_RETURN_ATTRIBUTE10 CONSTANT NUMBER := 160;
148 G_RETURN_ATTRIBUTE11 CONSTANT NUMBER := 161;
149 G_RETURN_ATTRIBUTE12 CONSTANT NUMBER := 162;
150 G_RETURN_ATTRIBUTE13 CONSTANT NUMBER := 163;
151 G_RETURN_ATTRIBUTE14 CONSTANT NUMBER := 164;
152 G_RETURN_ATTRIBUTE15 CONSTANT NUMBER := 165;
153 G_RETURN_ATTRIBUTE2 CONSTANT NUMBER := 166;
154 G_RETURN_ATTRIBUTE3 CONSTANT NUMBER := 167;
155 G_RETURN_ATTRIBUTE4 CONSTANT NUMBER := 168;
156 G_RETURN_ATTRIBUTE5 CONSTANT NUMBER := 169;
157 G_RETURN_ATTRIBUTE6 CONSTANT NUMBER := 170;
158 G_RETURN_ATTRIBUTE7 CONSTANT NUMBER := 171;
159 G_RETURN_ATTRIBUTE8 CONSTANT NUMBER := 172;
160 G_RETURN_ATTRIBUTE9 CONSTANT NUMBER := 173;
161 G_RETURN_CONTEXT CONSTANT NUMBER := 174;
162 G_RLA_SCHEDULE_TYPE CONSTANT NUMBER := 176;
163 G_SCHEDULE_ACTION CONSTANT NUMBER := 177;
164 G_SCHEDULE_ARRIVAL_DATE CONSTANT NUMBER := 178;
165 G_SCHEDULE_SHIP_DATE CONSTANT NUMBER := 179;
166 G_SCHEDULE_STATUS CONSTANT NUMBER := 180;
167 G_SHIPMENT_NUMBER CONSTANT NUMBER := 181;
168 G_SHIPMENT_PRIORITY CONSTANT NUMBER := 182;
169 G_SHIPPED_QUANTITY CONSTANT NUMBER := 183;
170 G_SHIPPING_METHOD CONSTANT NUMBER := 184;
171 G_SHIPPING_QUANTITY CONSTANT NUMBER := 185;
172 G_SHIPPING_QUANTITY_UOM CONSTANT NUMBER := 186;
173 G_SHIP_FROM_ORG CONSTANT NUMBER := 187;
174 G_SHIP_MODEL_COMPLETE_FLAG CONSTANT NUMBER := 188;
175 G_SHIP_TOLERANCE_ABOVE CONSTANT NUMBER := 189;
176 G_SHIP_TOLERANCE_BELOW CONSTANT NUMBER := 190;
177 G_SHIP_TO_CONTACT CONSTANT NUMBER := 191;
178 G_SHIP_TO_ORG CONSTANT NUMBER := 192;
179 G_SOLD_TO_ORG CONSTANT NUMBER := 194;
180 G_SORT_ORDER CONSTANT NUMBER := 195;
181 G_SOURCE_DOCUMENT CONSTANT NUMBER := 196;
182 G_SOURCE_DOCUMENT_LINE CONSTANT NUMBER := 197;
183 G_SOURCE_DOCUMENT_TYPE CONSTANT NUMBER := 198;
184 G_SOURCE_TYPE CONSTANT NUMBER := 199;
185 G_TASK CONSTANT NUMBER := 201;
186 G_TAX CONSTANT NUMBER := 202;
187 G_TAX_DATE CONSTANT NUMBER := 203;
188 G_TAX_EXEMPT CONSTANT NUMBER := 204;
189 G_TAX_EXEMPT_NUMBER CONSTANT NUMBER := 205;
190 G_TAX_EXEMPT_REASON CONSTANT NUMBER := 206;
191 G_TAX_POINT CONSTANT NUMBER := 207;
192 G_TAX_RATE CONSTANT NUMBER := 208;
193 G_TAX_VALUE CONSTANT NUMBER := 209;
194 G_UNIT_LIST_PRICE CONSTANT NUMBER := 210;
195 G_UNIT_SELLING_PRICE CONSTANT NUMBER := 211;
196 G_VISIBLE_DEMAND CONSTANT NUMBER := 212;
197 G_SPLIT_FROM_LINE CONSTANT NUMBER := 213;
198 G_CUST_PRODUCTION_SEQ_NUM CONSTANT NUMBER := 214;
199 G_VEH_CUS_ITEM_CUM_KEY CONSTANT NUMBER := 215;
200 G_INDUSTRY_ATTRIBUTE16 CONSTANT NUMBER := 216;
201 G_INDUSTRY_ATTRIBUTE17 CONSTANT NUMBER := 217;
202 G_INDUSTRY_ATTRIBUTE18 CONSTANT NUMBER := 218;
203 G_INDUSTRY_ATTRIBUTE19 CONSTANT NUMBER := 219;
204 G_INDUSTRY_ATTRIBUTE20 CONSTANT NUMBER := 220;
205 G_INDUSTRY_ATTRIBUTE21 CONSTANT NUMBER := 221;
206 G_INDUSTRY_ATTRIBUTE22 CONSTANT NUMBER := 222;
207 G_INDUSTRY_ATTRIBUTE23 CONSTANT NUMBER := 223;
208 G_INDUSTRY_ATTRIBUTE24 CONSTANT NUMBER := 224;
209 G_INDUSTRY_ATTRIBUTE25 CONSTANT NUMBER := 225;
210 G_INDUSTRY_ATTRIBUTE26 CONSTANT NUMBER := 226;
211 G_INDUSTRY_ATTRIBUTE27 CONSTANT NUMBER := 227;
212 G_INDUSTRY_ATTRIBUTE28 CONSTANT NUMBER := 228;
213 G_INDUSTRY_ATTRIBUTE29 CONSTANT NUMBER := 229;
214 G_INDUSTRY_ATTRIBUTE30 CONSTANT NUMBER := 230;
215 G_SALESREP CONSTANT NUMBER := 231;
216 G_RETURN_REASON CONSTANT NUMBER := 232;
217 G_ARRIVAL_SET CONSTANT NUMBER := 233;
218 G_SHIP_SET CONSTANT NUMBER := 234;
219 G_OVER_SHIP_REASON CONSTANT NUMBER := 235;
220 G_OVER_SHIP_RESOLVED CONSTANT NUMBER := 236;
221 G_AUTHORIZED_TO_SHIP CONSTANT NUMBER := 237;
222 G_ARRIVAL_SET_NAME CONSTANT NUMBER := 238;
223 G_SHIP_SET_NAME CONSTANT NUMBER := 239;
224 G_ORDER_SOURCE_ID CONSTANT NUMBER := 240;
225 G_ORIG_SYS_SHIPMENT_REF CONSTANT NUMBER := 241;
226 G_CHANGE_SEQUENCE_ID CONSTANT NUMBER := 242;
227 G_DROP_SHIP_FLAG CONSTANT NUMBER := 243;
228 G_CUSTOMER_LINE_NUMBER CONSTANT NUMBER := 244;
229 G_CUSTOMER_SHIPMENT_NUMBER CONSTANT NUMBER := 245;
230 G_CUSTOMER_ITEM_NET_PRICE CONSTANT NUMBER := 246;
231 G_CUSTOMER_PAYMENT_TERM_ID CONSTANT NUMBER := 247;
232 G_CUSTOMER_PAYMENT_TERM CONSTANT NUMBER := 248;
233 G_BOOKED CONSTANT NUMBER := 249;
234 G_CANCELLED CONSTANT NUMBER := 250;
235 G_OPEN CONSTANT NUMBER := 251;
236 G_ORDERED_ITEM_ID CONSTANT NUMBER := 252;
237 G_ITEM_IDENTIFIER_TYPE CONSTANT NUMBER := 253;
238 G_TOP_MODEL_LINE CONSTANT NUMBER := 254;
239 G_SHIPPING_INTERFACED CONSTANT NUMBER := 255;
240 G_FIRST_ACK CONSTANT NUMBER := 256;
241 G_FIRST_ACK_DATE CONSTANT NUMBER := 257;
242 G_LAST_ACK CONSTANT NUMBER := 258;
243 G_LAST_ACK_DATE CONSTANT NUMBER := 259;
244 G_CREDIT_INVOICE_LINE CONSTANT NUMBER := 260;
245 G_SOLD_FROM_ORG CONSTANT NUMBER := 261;
246 G_END_ITEM_UNIT_NUMBER CONSTANT NUMBER := 262;
247 G_CONFIG_HEADER CONSTANT NUMBER := 263;
248 G_CONFIG_REV_NBR CONSTANT NUMBER := 264;
249 G_MFG_COMPONENT_SEQUENCE CONSTANT NUMBER := 265;
250 G_PLANNING_PRIORITY CONSTANT NUMBER := 266;
251 G_SHIPPING_INSTRUCTIONS CONSTANT NUMBER := 267;
252 G_PACKING_INSTRUCTIONS CONSTANT NUMBER := 268;
253 G_INVOICED_QUANTITY CONSTANT NUMBER := 269;
254 G_REFERENCE_CUSTOMER_TRX_LINE CONSTANT NUMBER := 270;
255 G_SERVICE_TXN_REASON CONSTANT NUMBER := 271;
256 G_SERVICE_TXN_COMMENTS CONSTANT NUMBER := 272;
257 G_SERVICE_DURATION CONSTANT NUMBER := 273;
258 G_SERVICE_START_DATE CONSTANT NUMBER := 274;
259 G_SERVICE_END_DATE CONSTANT NUMBER := 275;
260 G_SERVICE_COTERMINATE_FLAG CONSTANT NUMBER := 276;
261 G_UNIT_LIST_PERCENT CONSTANT NUMBER := 277;
262 G_UNIT_SELLING_PERCENT CONSTANT NUMBER := 278;
263 G_UNIT_PERCENT_BASE_PRICE CONSTANT NUMBER := 279;
264 G_SERVICE_NUMBER CONSTANT NUMBER := 280;
265 G_SERVICE_REFERENCE_TYPE_CODE CONSTANT NUMBER := 281;
266 G_SERVICE_REFERENCE_LINE_ID CONSTANT NUMBER := 282;
267 G_SERVICE_REFERENCE_SYSTEM_ID CONSTANT NUMBER := 283;
268 -- there is gap because service_attribute are deleted (use it)
269 G_LINE_SET CONSTANT NUMBER := 298;
270 G_SPLIT_BY CONSTANT NUMBER := 299;
271 G_SHIPPABLE CONSTANT NUMBER := 300;
272 G_SERVICE_PERIOD CONSTANT NUMBER := 301;
273 G_RE_SOURCE_FLAG CONSTANT NUMBER := 302;
274 G_MODEL_REMNANT CONSTANT NUMBER := 303;
275 G_CHANGE_REASON CONSTANT NUMBER := 304;
276 G_CHANGE_COMMENTS CONSTANT NUMBER := 305;
277 G_TP_CONTEXT CONSTANT NUMBER :=306;
278 G_TP_ATTRIBUTE1 CONSTANT NUMBER :=307;
279 G_TP_ATTRIBUTE2 CONSTANT NUMBER :=308;
280 G_TP_ATTRIBUTE3 CONSTANT NUMBER :=309;
281 G_TP_ATTRIBUTE4 CONSTANT NUMBER :=310;
282 G_TP_ATTRIBUTE5 CONSTANT NUMBER :=311;
283 G_TP_ATTRIBUTE6 CONSTANT NUMBER :=312;
284 G_TP_ATTRIBUTE7 CONSTANT NUMBER :=313;
285 G_TP_ATTRIBUTE8 CONSTANT NUMBER :=314;
286 G_TP_ATTRIBUTE9 CONSTANT NUMBER :=315;
287 G_TP_ATTRIBUTE10 CONSTANT NUMBER :=316;
288 G_TP_ATTRIBUTE11 CONSTANT NUMBER :=317;
289 G_TP_ATTRIBUTE12 CONSTANT NUMBER :=318;
290 G_TP_ATTRIBUTE13 CONSTANT NUMBER :=319;
291 G_TP_ATTRIBUTE14 CONSTANT NUMBER :=320;
292 G_TP_ATTRIBUTE15 CONSTANT NUMBER :=321;
293 G_FLOW_STATUS CONSTANT NUMBER := 322;
294 G_FULFILLED CONSTANT NUMBER := 323;
295 G_FULFILLMENT_METHOD CONSTANT NUMBER := 324;
296 G_FULFILLMENT_SET CONSTANT NUMBER := 325;
297 G_FULFILLMENT_SET_NAME CONSTANT NUMBER := 326;
298 G_MARKETING_SOURCE_CODE_ID CONSTANT NUMBER := 327;
299 G_FULFILLMENT_DATE CONSTANT NUMBER := 328;
300 -- Added New Column
301 G_CALCULATE_PRICE_FLAG CONSTANT NUMBER := 329;
302 G_INVOICED_FLAG CONSTANT NUMBER := 330;
303 G_COMMITMENT CONSTANT NUMBER := 331;
304
305 -- OPM columns
306 G_ORDERED_QUANTITY2 CONSTANT NUMBER := 332;
307 G_ORDERED_QUANTITY_UOM2 CONSTANT NUMBER := 333;
308 G_PREFERRED_GRADE CONSTANT NUMBER := 334;
309 G_CANCELLED_QUANTITY2 CONSTANT NUMBER := 335;
310 G_FULFILLED_QUANTITY2 CONSTANT NUMBER := 336;
311 G_SHIPPED_QUANTITY2 CONSTANT NUMBER := 337;
312 G_SHIPPING_QUANTITY2 CONSTANT NUMBER := 338;
313 G_SHIPPING_QUANTITY_UOM2 CONSTANT NUMBER := 339;
314 G_UPGRADED CONSTANT NUMBER := 340;
315 G_SUBINVENTORY CONSTANT NUMBER := 341;
316 G_UNIT_LIST_PRICE_PER_PQTY CONSTANT NUMBER := 342;
317 G_UNIT_SELLING_PRICE_PER_PQTY CONSTANT NUMBER := 343;
318 G_PRICE_REQUEST_CODE CONSTANT NUMBER := 344; -- PROMOTIONS SEP/01
319 -- Item Substitution columns.
320 G_ORIGINAL_INVENTORY_ITEM CONSTANT NUMBER := 345;
321 G_ORIGINAL_ITEM_IDEN_TYPE CONSTANT NUMBER := 346;
322 G_ORIGINAL_ORDERED_ITEM_ID CONSTANT NUMBER := 347;
323 G_ORIGINAL_ORDERED_ITEM CONSTANT NUMBER := 348;
324 G_ITEM_SUBSTITUTION_TYPE CONSTANT NUMBER := 349;
325 G_DEMAND_LATENESS_PENALTY CONSTANT NUMBER := 350;
326 G_OVERRIDE_ATP_DATE CONSTANT NUMBER := 351;
327
328 G_ACCOUNTING_RULE_DURATION CONSTANT NUMBER := 352;
329 G_LATE_DEMAND_PENALTY_FACTOR CONSTANT NUMBER := 353;
330 G_UNIT_COST CONSTANT NUMBER := 354;
331 G_USER_ITEM_DESCRIPTION CONSTANT NUMBER := 355;
332 -- ER 2184255 additional DFF columns
333 G_ATTRIBUTE16 CONSTANT NUMBER := 356;
334 G_ATTRIBUTE17 CONSTANT NUMBER := 357;
335 G_ATTRIBUTE18 CONSTANT NUMBER := 358;
336 G_ATTRIBUTE19 CONSTANT NUMBER := 359;
337 G_ATTRIBUTE20 CONSTANT NUMBER := 360;
338 G_ITEM_RELATIONSHIP_TYPE CONSTANT NUMBER := 361;
339 -- Changes for Blanket Orders
340 G_BLANKET_NUMBER CONSTANT NUMBER := 362;
341 G_BLANKET_LINE_NUMBER CONSTANT NUMBER := 363;
342 G_BLANKET_VERSION_NUMBER CONSTANT NUMBER := 364;
343 G_FIRM_DEMAND CONSTANT NUMBER := 365;
344 G_EARLIEST_SHIP_DATE CONSTANT NUMBER := 366;
345 -- Changes for quoting
346 g_transaction_phase CONSTANT NUMBER := 367;
347 g_source_document_version CONSTANT NUMBER := 368;
348 G_MINISITE_ID CONSTANT NUMBER := 369;
349 G_IB_OWNER CONSTANT NUMBER := 370;
350 G_IB_INSTALLED_AT_LOCATION CONSTANT NUMBER := 371;
351 G_IB_CURRENT_LOCATION CONSTANT NUMBER := 372;
352 G_END_CUSTOMER CONSTANT NUMBER := 373;
353 G_END_CUSTOMER_CONTACT CONSTANT NUMBER := 374;
354 G_END_CUSTOMER_SITE_USE CONSTANT NUMBER := 375;
355 /*G_SUPPLIER_SIGNATURE CONSTANT NUMBER := 376;
356 G_SUPPLIER_SIGNATURE_DATE CONSTANT NUMBER := 377;
357 G_CUSTOMER_SIGNATURE CONSTANT NUMBER := 378;
358 G_CUSTOMER_SIGNATURE_DATE CONSTANT NUMBER := 379;
359 */
360 --retro{
361 G_RETROBILL_REQUEST CONSTANT NUMBER := 376;
362 --retro}
363 G_ORIGINAL_LIST_PRICE CONSTANT NUMBER := 377; -- Override List Price
364 G_COMMITMENT_APPLIED_AMOUNT CONSTANT NUMBER := 378;
365 -- key Transaction Dates
366 g_order_firmed_date CONSTANT NUMBER := 379;
367 g_actual_fulfillment_date CONSTANT NUMBER := 380;
368 --recurring charges
369 G_CHARGE_PERIODICITY CONSTANT NUMBER := 381;
370 G_RESERVED_QUANTITY2 CONSTANT NUMBER := 382; -- INVCONV
371 --Customer Acceptance
372 G_CONTINGENCY CONSTANT NUMBER := 383;
373 G_REVREC_EVENT CONSTANT NUMBER := 384;
374 G_REVREC_EXPIRATION_DAYS CONSTANT NUMBER := 385;
375 G_REVREC_SIGNATURE CONSTANT NUMBER := 386;
376 G_REVREC_SIGNATURE_DATE CONSTANT NUMBER := 387;
377 G_REVREC_COMMENTS CONSTANT NUMBER := 388;
378 G_REVREC_REFERENCE_DOCUMENT CONSTANT NUMBER := 389;
379 G_ACCEPTED_BY CONSTANT NUMBER := 390;
380 G_ACCEPTED_QUANTITY CONSTANT NUMBER := 391;
381 G_REVREC_IMPLICIT_FLAG CONSTANT NUMBER := 392;
382
383 G_MAX_ATTR_ID CONSTANT NUMBER := 393;
384
385
386 /* Fix for bug 2431953/2749740
387 G_ORDERED_QTY_CHANGE BOOLEAN:= FALSE;
388 Fix ends */
389
390 /* Bug # 5036404 Start */
391 -- retreive the profile value
392 G_FREEZE_METHOD VARCHAR2(30) := FND_PROFILE.VALUE('ONT_INCLUDED_ITEM_FREEZE_METHOD');
393 G_CHARGES_FOR_BACKORDERS VARCHAR2(1) := NVL(FND_PROFILE.VALUE('ONT_CHARGES_FOR_BACKORDERS'),'N');
394 G_CHARGES_FOR_INCLUD_ITM VARCHAR2(1) := NVL(FND_PROFILE.VALUE('ONT_CHARGES_FOR_INCLUDED_ITEM'),'N');
395 /* Bug # 5036404 End */
396 G_APPLY_AUTOMATIC_ATCHMT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('OE_APPLY_AUTOMATIC_ATCHMT'),'Y') ; --5893276
397 /* Temporarily moves to OEXULXTS.pls (OE_Line_Util_Ext)
398 -- Procedure Clear_Dependent_Attr
399
400 PROCEDURE Clear_Dependent_Attr
401 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
402 , p_line_rec IN OE_Order_PUB.Line_Rec_Type
403 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
404 OE_Order_PUB.G_MISS_LINE_REC
405 , x_line_rec OUT OE_Order_PUB.Line_Rec_Type
406 );
407 */
408
409 -- Procedure Apply_Attribute_Changes
410
411 PROCEDURE Apply_Attribute_Changes
412 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
413 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
414 OE_Order_PUB.G_MISS_LINE_REC
415 );
416
417 -- Procedure Complete_Record
418
419 PROCEDURE Complete_Record
420 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
421 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
422 ) ;
423
424 -- Procedure Convert_Miss_To_Null
425
426 PROCEDURE Convert_Miss_To_Null
427 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
428 ) ;
429
430 -- Procedure Update_Row
431
432 PROCEDURE Update_Row
433 ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
434 );
435
436 -- Procedure Insert_Row
437
438 PROCEDURE Insert_Row
439 ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
440 );
441
442 -- Procedure Delete_Row
443
444 PROCEDURE Delete_Row
445 ( p_line_id IN NUMBER :=
446 FND_API.G_MISS_NUM
447 , p_header_id IN NUMBER :=
448 FND_API.G_MISS_NUM
449 );
450
451 -- FUNCTION Query_Row
452 -- IMPORTANT: DO NOT CHANGE THE SPEC OF THIS FUNCTION
453 -- IT IS PUBLIC AND BEING CALLED BY OTHER PRODUCTS
454 -- Private OM callers should call the procedure query_row instead
455 -- as it has the nocopy option which would improve the performance
456
457 FUNCTION Query_Row
458 ( p_line_id IN NUMBER
459 ) RETURN OE_Order_PUB.Line_Rec_Type;
460
461 -- Procedure Query_Row
462
463 PROCEDURE Query_Row
464 ( p_line_id IN NUMBER
465 , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
466 );
467
468 -- Procedure Query_Rows
469
470 --
471
472 PROCEDURE Query_Rows
473 ( p_line_id IN NUMBER :=
474 FND_API.G_MISS_NUM
475 , p_header_id IN NUMBER :=
476 FND_API.G_MISS_NUM
477 , p_line_set_id IN NUMBER :=
478 FND_API.G_MISS_NUM
479 , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
480 );
481
482 -- Procedure lock_Row
483 PROCEDURE Lock_Row
484 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
485 , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
486 , p_line_id IN NUMBER
487 := FND_API.G_MISS_NUM
488 );
489
490 PROCEDURE Lock_Rows
491 ( p_line_id IN NUMBER :=
492 FND_API.G_MISS_NUM
493 , p_header_id IN NUMBER :=
494 FND_API.G_MISS_NUM
495 , x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
496 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
497 );
498
499 -- Function Get_Values
500
501 FUNCTION Get_Values
502 ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
503 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
504 OE_Order_PUB.G_MISS_LINE_REC
505 ) RETURN OE_Order_PUB.Line_Val_Rec_Type;
506
507
508 -- Procedure Get_Ids
509
510 PROCEDURE Get_Ids
511 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
512 , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type
513 ) ;
514
515 Procedure Query_Header
516 ( p_line_id IN NUMBER :=
517 FND_API.G_MISS_NUM
518 , x_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
519 );
520
521 -- INVCONV FOR SAO
522 PROCEDURE get_reserved_quantities
523 ( p_header_id IN NUMBER
524 ,p_line_id IN NUMBER
525 ,p_org_id IN NUMBER DEFAULT NULL
526 ,p_order_quantity_uom IN VARCHAR2 DEFAULT NULL --added for 3745318
527 ,p_inventory_item_id IN NUMBER DEFAULT NULL --added for 3745318
528 ,x_reserved_quantity OUT NOCOPY NUMBER
529 ,x_reserved_quantity2 OUT NOCOPY NUMBER );
530
531 FUNCTION Get_Reserved_Quantity
532 ( p_header_id IN NUMBER
533 ,p_line_id IN NUMBER
534 ,p_org_id IN NUMBER DEFAULT NULL
535 ,p_order_quantity_uom IN VARCHAR2 DEFAULT NULL --added for 3745318
536 ,p_inventory_item_id IN NUMBER DEFAULT NULL --added for 3745318
537 )RETURN NUMBER;
538
539
540 -- INVCONV Get_Reserved_Quantity2 merged into get_reserved_quantities not used by Process Manufacturing now but left in for
541 -- forward compatibility and in case other modules are using this.
542
543 FUNCTION Get_Reserved_Quantity2
544 ( p_header_id IN NUMBER
545 ,p_line_id IN NUMBER
546 ,p_org_id IN NUMBER DEFAULT NULL
547 )RETURN NUMBER;
548
549
550 FUNCTION Get_Open_Quantity(p_header_id IN NUMBER,
551 p_line_id IN NUMBER,
552 p_ordered_quantity IN NUMBER,
553 p_shipped_quantity IN NUMBER)
554 RETURN NUMBER;
555
556 FUNCTION Get_Primary_Uom_Quantity(p_ordered_quantity IN NUMBER,
557 p_order_quantity_uom IN VARCHAR2)
558 RETURN NUMBER;
559
560
561 FUNCTION Is_Over_Return(p_line_rec IN OE_ORDER_PUB.line_rec_type)
562 RETURN BOOLEAN;
563
564 PROCEDURE Pre_Write_Process
565 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
566 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
567 OE_Order_PUB.G_MISS_LINE_REC
568 );
569
570 PROCEDURE Version_Audit_Process
571 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
572 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
573 OE_Order_PUB.G_MISS_LINE_REC
574 , p_process_step IN NUMBER := 3
575 );
576
577 PROCEDURE Post_Write_Process
578 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
579 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
580 OE_Order_PUB.G_MISS_LINE_REC
581 );
582
583 PROCEDURE Post_Line_Process
584 ( p_control_rec IN OE_Globals.Control_Rec_Type
585 , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
586 );
587
588 Function Get_Return_Item_Type_Code
589 ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
590 ) RETURN varchar2;
591
592 -- OPM 02/JUN/00
593 -- =============
594 /*FUNCTION process_characteristics -- INVCONV OBSOLETE NEED TO TAKE OUT
595 (
596 p_inventory_item_id IN NUMBER
597 ,p_ship_from_org_id IN NUMBER
598 ,x_item_rec OUT NOCOPY OE_ORDER_CACHE.item_rec_type
599 )
600 RETURN BOOLEAN; */
601
602 FUNCTION dual_uom_control -- INVCONV
603 (
604 p_inventory_item_id IN NUMBER
605 ,p_ship_from_org_id IN NUMBER
606 ,x_item_rec OUT NOCOPY OE_ORDER_CACHE.item_rec_type
607 )
608 RETURN BOOLEAN;
609
610
611 /* FUNCTION Get_Dual_Uom -- INVCONV
612 (
613 p_line_rec OE_ORDER_PUB.Line_Rec_Type
614 )
615 RETURN VARCHAR2; */
616
617 /* FUNCTION Get_Preferred_Grade -- INVCONV
618 (
619 p_line_rec OE_ORDER_PUB.Line_Rec_Type,
620 p_old_line_rec OE_ORDER_PUB.Line_Rec_Type
621 )
622 RETURN VARCHAR2; */
623
624 PROCEDURE Sync_Dual_Qty
625 (
626 P_X_LINE_REC IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
627 ,P_OLD_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type
628 );
629
630 /* FUNCTION Calculate_Ordered_Quantity2 INVCONV removed
631 (
632 P_LINE_REC OE_ORDER_PUB.Line_Rec_Type
633 )
634 RETURN NUMBER; */
635 -- OPM 02/JUN/00 END
636 -- =================
637
638 /* OPM - NC 3/8/02 Bug#2046641 */
639 PROCEDURE calculate_dual_quantity
640 (
641 p_ordered_quantity IN OUT NOCOPY /* file.sql.39 change */ NUMBER
642 ,p_old_ordered_quantity IN NUMBER
643 ,p_ordered_quantity2 IN OUT NOCOPY /* file.sql.39 change */ NUMBER
644 ,p_old_ordered_quantity2 IN NUMBER
645 ,p_ordered_quantity_uom IN VARCHAR2
646 ,p_ordered_quantity_uom2 IN VARCHAR2
647 ,p_inventory_item_id IN NUMBER
648 ,p_ship_from_org_id IN NUMBER
649 ,x_ui_flag IN NUMBER
650 ,x_return_status OUT NOCOPY /* file.sql.39 change */ NUMBER
651 -- ,p_lot_id IN NUMBER DEFAULT 0 -- OPM 2380194 added for RMA quantity2 OM pack J project
652 ,p_lot_number IN VARCHAR2 DEFAULT NULL -- INVCONV orig for 2380194 added for RMA quantity2 OM pack J project
653 ) ;
654
655 Procedure Pre_Attribute_Security
656 ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
657 , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
658 , p_index IN NUMBER);
659
660 PROCEDURE Log_Scheduling_Requests
661 (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
662 ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
663 ,p_caller IN VARCHAR2
664 ,p_order_type_id IN NUMBER
665 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
666
667
668
669
670
671 PROCEDURE update_adjustment_flags
672 ( p_old_line_rec IN OE_Order_PUB.line_rec_type,
673 p_x_line_rec IN OE_Order_PUB.line_rec_type);
674
675
676 PROCEDURE GET_ITEM_INFO
677 ( x_return_status OUT NOCOPY VARCHAR2
678 , x_msg_count OUT NOCOPY NUMBER
679 , x_msg_data OUT NOCOPY VARCHAR2
680 , p_item_identifier_type IN VARCHAR2
681 , p_inventory_item_id IN Number
682 , p_ordered_item_id IN Number
683 , p_sold_to_org_id IN Number
684 , p_ordered_item IN VARCHAR2
685 , x_ordered_item OUT NOCOPY VARCHAR2
686 , x_ordered_item_desc OUT NOCOPY VARCHAR2
687 , x_inventory_item OUT NOCOPY VARCHAR2
688 , p_org_id IN Number DEFAULT NULL
689 );
690
691
692 END OE_Line_Util;