[Home] [Help]
PACKAGE: APPS.OE_LINE_UTIL
Source
1 PACKAGE OE_Line_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXULINS.pls 120.7.12020000.6 2013/02/27 18:40:08 cpati 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 -- sol_ord_er #16014165
384 G_SERVICE_BILL_PROFILE_ID CONSTANT NUMBER := 393;
385 G_SERVICE_COV_TEMPLATE_ID CONSTANT NUMBER := 394;
386 G_SERVICE_SUBS_TEMPLATE_ID CONSTANT NUMBER := 395;
387 G_SERVICE_BILL_OPTION_CODE CONSTANT NUMBER := 396;
388 G_SUBSCRIPTION_ENABLE_FLAG CONSTANT NUMBER := 397;
389
390 G_MAX_ATTR_ID CONSTANT NUMBER := 398;
391
392
393 /* Fix for bug 2431953/2749740
394 G_ORDERED_QTY_CHANGE BOOLEAN:= FALSE;
395 Fix ends */
396
397 /* Bug # 5036404 Start */
398 -- retreive the profile value
399 G_FREEZE_METHOD VARCHAR2(30) := FND_PROFILE.VALUE('ONT_INCLUDED_ITEM_FREEZE_METHOD');
400 G_CHARGES_FOR_BACKORDERS VARCHAR2(1) := NVL(FND_PROFILE.VALUE('ONT_CHARGES_FOR_BACKORDERS'),'N');
401 G_CHARGES_FOR_INCLUD_ITM VARCHAR2(1) := NVL(FND_PROFILE.VALUE('ONT_CHARGES_FOR_INCLUDED_ITEM'),'N');
402 /* Bug # 5036404 End */
403 G_APPLY_AUTOMATIC_ATCHMT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('OE_APPLY_AUTOMATIC_ATCHMT'),'Y') ; --5893276
404 /* Temporarily moves to OEXULXTS.pls (OE_Line_Util_Ext)
405 -- Procedure Clear_Dependent_Attr
406
407 PROCEDURE Clear_Dependent_Attr
408 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
409 , p_line_rec IN OE_Order_PUB.Line_Rec_Type
410 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
411 OE_Order_PUB.G_MISS_LINE_REC
412 , x_line_rec OUT OE_Order_PUB.Line_Rec_Type
413 );
414 */
415
416 -- Procedure Apply_Attribute_Changes
417
418 PROCEDURE Apply_Attribute_Changes
419 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
420 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
421 OE_Order_PUB.G_MISS_LINE_REC
422 );
423
424 -- Procedure Complete_Record
425
426 PROCEDURE Complete_Record
427 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
428 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
429 ) ;
430
431 -- Procedure Convert_Miss_To_Null
432
433 PROCEDURE Convert_Miss_To_Null
434 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
435 ) ;
436
437 -- Procedure Update_Row
438
439 PROCEDURE Update_Row
440 ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
441 );
442
443 -- Procedure Insert_Row
444
445 PROCEDURE Insert_Row
446 ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
447 );
448
449 -- Procedure Delete_Row
450
451 PROCEDURE Delete_Row
452 ( p_line_id IN NUMBER :=
453 FND_API.G_MISS_NUM
454 , p_header_id IN NUMBER :=
455 FND_API.G_MISS_NUM
456 );
457
458 -- FUNCTION Query_Row
459 -- IMPORTANT: DO NOT CHANGE THE SPEC OF THIS FUNCTION
460 -- IT IS PUBLIC AND BEING CALLED BY OTHER PRODUCTS
461 -- Private OM callers should call the procedure query_row instead
462 -- as it has the nocopy option which would improve the performance
463
464 FUNCTION Query_Row
465 ( p_line_id IN NUMBER
466 ) RETURN OE_Order_PUB.Line_Rec_Type;
467
468 -- Procedure Query_Row
469
470 PROCEDURE Query_Row
471 ( p_line_id IN NUMBER
472 , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
473 );
474
475 -- Procedure Query_Rows
476
477 --
478
479 PROCEDURE Query_Rows
480 ( p_line_id IN NUMBER :=
481 FND_API.G_MISS_NUM
482 , p_header_id IN NUMBER :=
483 FND_API.G_MISS_NUM
484 , p_line_set_id IN NUMBER :=
485 FND_API.G_MISS_NUM
486 , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
487 );
488
489 -- Procedure lock_Row
490 PROCEDURE Lock_Row
491 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
492 , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
493 , p_line_id IN NUMBER
494 := FND_API.G_MISS_NUM
495 );
496
497 PROCEDURE Lock_Rows
498 ( p_line_id IN NUMBER :=
499 FND_API.G_MISS_NUM
500 , p_header_id IN NUMBER :=
501 FND_API.G_MISS_NUM
502 , x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
503 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
504 );
505
506 -- Function Get_Values
507
508 FUNCTION Get_Values
509 ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
510 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
511 OE_Order_PUB.G_MISS_LINE_REC
512 ) RETURN OE_Order_PUB.Line_Val_Rec_Type;
513
514
515 -- Procedure Get_Ids
516
517 PROCEDURE Get_Ids
518 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
519 , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type
520 ) ;
521
522 Procedure Query_Header
523 ( p_line_id IN NUMBER :=
524 FND_API.G_MISS_NUM
525 , x_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
526 );
527
528 -- INVCONV FOR SAO
529 PROCEDURE get_reserved_quantities
530 ( p_header_id IN NUMBER
531 ,p_line_id IN NUMBER
532 ,p_org_id IN NUMBER DEFAULT NULL
533 ,p_order_quantity_uom IN VARCHAR2 DEFAULT NULL --added for 3745318
534 ,p_inventory_item_id IN NUMBER DEFAULT NULL --added for 3745318
535 ,x_reserved_quantity OUT NOCOPY NUMBER
536 ,x_reserved_quantity2 OUT NOCOPY NUMBER );
537
538 FUNCTION Get_Reserved_Quantity
539 ( p_header_id IN NUMBER
540 ,p_line_id IN NUMBER
541 ,p_org_id IN NUMBER DEFAULT NULL
542 ,p_order_quantity_uom IN VARCHAR2 DEFAULT NULL --added for 3745318
543 ,p_inventory_item_id IN NUMBER DEFAULT NULL --added for 3745318
544 )RETURN NUMBER;
545
546
547 -- INVCONV Get_Reserved_Quantity2 merged into get_reserved_quantities not used by Process Manufacturing now but left in for
548 -- forward compatibility and in case other modules are using this.
549
550 FUNCTION Get_Reserved_Quantity2
551 ( p_header_id IN NUMBER
552 ,p_line_id IN NUMBER
553 ,p_org_id IN NUMBER DEFAULT NULL
554 )RETURN NUMBER;
555
556
557 FUNCTION Get_Open_Quantity(p_header_id IN NUMBER,
558 p_line_id IN NUMBER,
559 p_ordered_quantity IN NUMBER,
560 p_shipped_quantity IN NUMBER)
561 RETURN NUMBER;
562
563 FUNCTION Get_Primary_Uom_Quantity(p_ordered_quantity IN NUMBER,
564 p_order_quantity_uom IN VARCHAR2)
565 RETURN NUMBER;
566
567
568 FUNCTION Is_Over_Return(p_line_rec IN OE_ORDER_PUB.line_rec_type)
569 RETURN BOOLEAN;
570
571 PROCEDURE Pre_Write_Process
572 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
573 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
574 OE_Order_PUB.G_MISS_LINE_REC
575 );
576
577 PROCEDURE Version_Audit_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 , p_process_step IN NUMBER := 3
582 );
583
584 PROCEDURE Post_Write_Process
585 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
586 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
587 OE_Order_PUB.G_MISS_LINE_REC
588 );
589
590 PROCEDURE Post_Line_Process
591 ( p_control_rec IN OE_Globals.Control_Rec_Type
592 , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
593 );
594
595 Function Get_Return_Item_Type_Code
596 ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
597 ) RETURN varchar2;
598
599 -- OPM 02/JUN/00
600 -- =============
601 /*FUNCTION process_characteristics -- INVCONV OBSOLETE NEED TO TAKE OUT
602 (
603 p_inventory_item_id IN NUMBER
604 ,p_ship_from_org_id IN NUMBER
605 ,x_item_rec OUT NOCOPY OE_ORDER_CACHE.item_rec_type
606 )
607 RETURN BOOLEAN; */
608
609 FUNCTION dual_uom_control -- INVCONV
610 (
611 p_inventory_item_id IN NUMBER
612 ,p_ship_from_org_id IN NUMBER
613 ,x_item_rec OUT NOCOPY OE_ORDER_CACHE.item_rec_type
614 )
615 RETURN BOOLEAN;
616
617
618 /* FUNCTION Get_Dual_Uom -- INVCONV
619 (
620 p_line_rec OE_ORDER_PUB.Line_Rec_Type
621 )
622 RETURN VARCHAR2; */
623
624 /* FUNCTION Get_Preferred_Grade -- INVCONV
625 (
626 p_line_rec OE_ORDER_PUB.Line_Rec_Type,
627 p_old_line_rec OE_ORDER_PUB.Line_Rec_Type
628 )
629 RETURN VARCHAR2; */
630
631 PROCEDURE Sync_Dual_Qty
632 (
633 P_X_LINE_REC IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
634 ,P_OLD_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type
635 );
636
637 /* FUNCTION Calculate_Ordered_Quantity2 INVCONV removed
638 (
639 P_LINE_REC OE_ORDER_PUB.Line_Rec_Type
640 )
641 RETURN NUMBER; */
642 -- OPM 02/JUN/00 END
643 -- =================
644
645 /* OPM - NC 3/8/02 Bug#2046641 */
646 PROCEDURE calculate_dual_quantity
647 (
648 p_ordered_quantity IN OUT NOCOPY /* file.sql.39 change */ NUMBER
649 ,p_old_ordered_quantity IN NUMBER
650 ,p_ordered_quantity2 IN OUT NOCOPY /* file.sql.39 change */ NUMBER
651 ,p_old_ordered_quantity2 IN NUMBER
652 ,p_ordered_quantity_uom IN VARCHAR2
653 ,p_ordered_quantity_uom2 IN VARCHAR2
654 ,p_inventory_item_id IN NUMBER
655 ,p_ship_from_org_id IN NUMBER
656 ,x_ui_flag IN NUMBER
657 ,x_return_status OUT NOCOPY /* file.sql.39 change */ NUMBER
658 -- ,p_lot_id IN NUMBER DEFAULT 0 -- OPM 2380194 added for RMA quantity2 OM pack J project
659 ,p_lot_number IN VARCHAR2 DEFAULT NULL -- INVCONV orig for 2380194 added for RMA quantity2 OM pack J project
660 ) ;
661
662 Procedure Pre_Attribute_Security
663 ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
664 , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
665 , p_index IN NUMBER);
666
667 PROCEDURE Log_Scheduling_Requests
668 (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
669 ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
670 ,p_caller IN VARCHAR2
671 ,p_order_type_id IN NUMBER
672 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
673
674
675
676
677
678 PROCEDURE update_adjustment_flags
679 ( p_old_line_rec IN OE_Order_PUB.line_rec_type,
680 p_x_line_rec IN OE_Order_PUB.line_rec_type);
681
682
683 PROCEDURE GET_ITEM_INFO
684 ( x_return_status OUT NOCOPY VARCHAR2
685 , x_msg_count OUT NOCOPY NUMBER
686 , x_msg_data OUT NOCOPY VARCHAR2
687 , p_item_identifier_type IN VARCHAR2
688 , p_inventory_item_id IN Number
689 , p_ordered_item_id IN Number
690 , p_sold_to_org_id IN Number
691 , p_ordered_item IN VARCHAR2
692 , x_ordered_item OUT NOCOPY VARCHAR2
693 , x_ordered_item_desc OUT NOCOPY VARCHAR2
694 , x_inventory_item OUT NOCOPY VARCHAR2
695 , p_org_id IN Number DEFAULT NULL
696 );
697
698 --ER7675548
699 Procedure Get_customer_info_ids
700 ( p_line_customer_info_tbl IN OUT NOCOPY OE_Order_Pub.CUSTOMER_INFO_TABLE_TYPE,
701 p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
702 x_return_status OUT NOCOPY VARCHAR2,
703 x_msg_count OUT NOCOPY NUMBER,
704 x_msg_data OUT NOCOPY VARCHAR2
705 );
706
707 --7688372 start
708 TYPE attachrule_count_line_tab IS TABLE OF NUMBER INDEX by oe_attachment_rule_elements.ATTRIBUTE_CODE%TYPE;
709 g_attachrule_count_line_tab attachrule_count_line_tab;
710 --7688372 end
711
712 -- sol_ord_er #16014165
713 Function Is_Subscription_Service_Line (p_line_id IN NUMBER)
714 RETURN BOOLEAN;
715
716 --bug 16317238
717 Procedure copy_assoc(p_line_id IN NUMBER,
718 px_org_pr_adjustment_id OUT NOCOPY NUMBER,
719 px_or_rltd_padj_id OUT NOCOPY NUMBER,
720 px_prg_list_line_id OUT NOCOPY NUMBER,
721 px_assoc_list_line_id OUT NOCOPY NUMBER,
722 px_prg_exist OUT NOCOPY VARCHAR2);
723
724 --16206165 CW Start
725 FUNCTION IS_CATCH_WEIGHT
726 (
727 p_Line_rec OE_Order_PUB.Line_Rec_Type
728 )
729 RETURN VARCHAR2;
730 --16206165 CW End
731
732 END OE_Line_Util;