DBA Data[Home] [Help]

APPS.OE_ORDER_UTIL dependencies on OE_GLOBALS

Line 209: IF NOT (OE_GLOBALS.G_UI_FLAG ) THEN

205: /* The global entities will be populated for booked orders */
206: /* coming in via Process Order or for entered orders via the GUI */
207: /* or at 11.5.10 or higher (for versioning changes) */
208:
209: IF NOT (OE_GLOBALS.G_UI_FLAG ) THEN
210: IF l_debug_level > 0 THEN
211: oe_debug_pub.add( 'UI FLAG IS FALSE' , 1 ) ;
212: END IF;
213: end if;

Line 235: (OE_GLOBALS.G_UI_FLAG ) OR

231: IF l_debug_level > 0 THEN
232: oe_debug_pub.add( 'CACHED VALUE' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
233: END IF;
234: IF (oe_order_cache.g_header_rec.booked_flag = 'Y') OR
235: (OE_GLOBALS.G_UI_FLAG ) OR
236: OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
237:
238: -- If the order is booked, then do the logic for each entity as follows:
239: -- 1- search old table for this line

Line 257: p_header_Rec.operation = oe_globals.g_opr_create THEN

253: IF p_old_header_rec.header_id=FND_API.G_MISS_NUM OR
254: P_old_header_rec.header_id is NULL THEN
255:
256: IF p_header_Rec.header_id is not null and
257: p_header_Rec.operation = oe_globals.g_opr_create THEN
258: IF l_debug_level > 0 THEN
259:
260: oe_debug_pub.add( 'P_HEADER_REC.HEADER_ID=' || P_HEADER_REC.HEADER_ID , 1 ) ;
261: END IF;

Line 334: OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,

330: END IF;
331:
332: /* search the old global header sales credits table */
333: Return_Glb_Ent_Index(
334: OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,
335: p_hdr_scr_id,
336: l_ind,
337: l_result,
338: l_return_stat);

Line 352: p_hdr_scr_rec.operation = oe_globals.g_opr_create THEN

348: IF p_old_hdr_scr_rec.sales_credit_id = FND_API.G_MISS_NUM OR
349: p_old_hdr_scr_rec.sales_credit_id is NULL THEN
350:
351: IF p_hdr_scr_rec.sales_credit_id is not null and
352: p_hdr_scr_rec.operation = oe_globals.g_opr_create THEN
353: g_old_header_scredit_tbl(l_ind):= p_hdr_scr_rec;
354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'JPN: OLD HEADER SALES CREDITS GLOBAL PIC UPDATED' ) ;
356: END IF;

Line 416: OE_GLOBALS.G_ENTITY_HEADER_ADJ,

412: END IF;
413:
414: /* search the old global header adjustments table */
415: Return_Glb_Ent_Index(
416: OE_GLOBALS.G_ENTITY_HEADER_ADJ,
417: p_hdr_adj_id,
418: l_ind,
419: l_result,
420: l_return_stat);

Line 433: p_hdr_adj_rec.operation = oe_globals.g_opr_create THEN

429: IF p_old_hdr_adj_rec.price_adjustment_id = FND_API.G_MISS_NUM OR
430: p_old_hdr_adj_rec.price_adjustment_id is NULL THEN
431:
432: IF p_hdr_adj_rec.price_adjustment_id is not null and
433: p_hdr_adj_rec.operation = oe_globals.g_opr_create THEN
434: g_old_header_adj_tbl(l_ind):= p_hdr_adj_rec;
435: IF l_debug_level > 0 THEN
436: oe_debug_pub.add( 'JPN: OLD HEADER ADJ GLOBAL PIC UPDATED' ) ;
437: END IF;

Line 498: OE_GLOBALS.G_ENTITY_LINE,

494: END IF;
495:
496: /* search the old global line table */
497: Return_Glb_Ent_Index(
498: OE_GLOBALS.G_ENTITY_LINE,
499: p_line_id,
500: l_ind,
501: l_result,
502: l_return_stat);

Line 515: p_line_rec.operation = oe_globals.g_opr_create THEN

511: IF p_old_line_rec.line_id = FND_API.G_MISS_NUM OR
512: p_old_line_rec.line_id is NULL THEN
513:
514: IF p_line_rec.line_id is not null and
515: p_line_rec.operation = oe_globals.g_opr_create THEN
516: g_old_line_tbl(l_ind):= p_line_rec;
517: IF l_debug_level > 0 THEN
518: oe_debug_pub.add( 'JPN: OLD LINE GLOBAL PIC UPDATED' ) ;
519: END IF;

Line 579: OE_GLOBALS.G_ENTITY_LINE_SCREDIT,

575: END IF;
576:
577: /* search the old global line sales credits table */
578: Return_Glb_Ent_Index(
579: OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
580: p_line_scr_id,
581: l_ind,
582: l_result,
583: l_return_stat);

Line 596: p_line_scr_rec.operation = oe_globals.g_opr_create THEN

592: IF p_old_line_scr_rec.sales_credit_id = FND_API.G_MISS_NUM OR
593: p_old_line_scr_rec.sales_credit_id is NULL THEN
594:
595: IF p_line_scr_rec.sales_credit_id is not null and
596: p_line_scr_rec.operation = oe_globals.g_opr_create THEN
597: g_old_line_scredit_tbl(l_ind):= p_line_scr_rec;
598: IF l_debug_level > 0 THEN
599: oe_debug_pub.add( 'JPN: OLD LINE SALES CREDITS GLOBAL PIC UPDATED' ) ;
600: END IF;

Line 658: OE_GLOBALS.G_ENTITY_LINE_ADJ,

654: END IF;
655:
656: /* search the old global line adjustments table */
657: Return_Glb_Ent_Index(
658: OE_GLOBALS.G_ENTITY_LINE_ADJ,
659: p_line_adj_id,
660: l_ind,
661: l_result,
662: l_return_stat);

Line 676: p_line_adj_rec.operation = oe_globals.g_opr_create THEN

672: IF p_old_line_adj_rec.price_adjustment_id = FND_API.G_MISS_NUM OR
673: p_old_line_adj_rec.price_adjustment_id is NULL THEN
674:
675: IF p_line_adj_rec.price_adjustment_id is not null and
676: p_line_adj_rec.operation = oe_globals.g_opr_create THEN
677: g_old_line_adj_tbl(l_ind):= p_line_adj_rec;
678: IF l_debug_level > 0 THEN
679: oe_debug_pub.add( 'JPN: OLD LINE ADJ GLOBAL PIC UPDATED' ) ;
680: END IF;

Line 738: OE_GLOBALS.G_ENTITY_LOT_SERIAL,

734: END IF;
735:
736: /* search the old global lot serial table */
737: Return_Glb_Ent_Index(
738: OE_GLOBALS.G_ENTITY_LOT_SERIAL,
739: p_lot_serial_id,
740: l_ind,
741: l_result,
742: l_return_stat);

Line 755: p_lot_serial_rec.operation = oe_globals.g_opr_create THEN

751: IF p_old_lot_serial_rec.lot_serial_id = FND_API.G_MISS_NUM OR
752: p_old_lot_serial_rec.lot_serial_id is NULL THEN
753:
754: IF p_lot_serial_rec.lot_serial_id is not null and
755: p_lot_serial_rec.operation = oe_globals.g_opr_create THEN
756: g_old_lot_serial_tbl(l_ind):= p_lot_serial_rec;
757: IF l_debug_level > 0 THEN
758: oe_debug_pub.add( 'JPN: OLD LOT SERIAL GLOBAL PIC UPDATED' ) ;
759: END IF;

Line 844: IF p_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN

840: IF l_debug_level > 0 THEN
841: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.RETURN_GLB_ENT_INDEX' , 1 ) ;
842: END IF;
843:
844: IF p_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
845:
846: -- search until we find the first index position with a value
847: IF NOT g_old_line_tbl.Exists(l_ind) THEN
848: x_index := l_ind;

Line 869: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_SCREDIT THEN

865: l_ind := g_old_line_tbl.Next(l_ind);
866: END LOOP;
867: -- end entity is line
868:
869: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_SCREDIT THEN
870:
871: -- search until we find the first index position with a value
872: IF NOT g_old_header_scredit_tbl.Exists(l_ind) THEN
873: x_index := l_ind;

Line 895: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_SCREDIT THEN

891: l_ind := g_old_header_scredit_tbl.Next(l_ind);
892: END LOOP;
893: -- end entity is header sales credit
894:
895: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_SCREDIT THEN
896:
897: -- search until we find the first index position with a value
898: IF NOT g_old_line_scredit_tbl.Exists(l_ind) THEN
899: x_index := l_ind;

Line 922: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_ADJ THEN

918: END LOOP;
919: -- end entity is line sales credit
920:
921:
922: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_ADJ THEN
923:
924: -- search until we find the first index position with a value
925: IF NOT g_old_header_adj_tbl.Exists(l_ind) THEN
926: x_index := l_ind;

Line 949: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_ADJ THEN

945: END LOOP;
946: -- end entity is header adjustment
947:
948:
949: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_ADJ THEN
950:
951: -- search until we find the first index position with a value
952: IF NOT g_old_line_adj_tbl.Exists(l_ind) THEN
953: x_index := l_ind;

Line 974: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LOT_SERIAL THEN

970: END LOOP;
971: -- entity is line adjustment
972:
973:
974: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LOT_SERIAL THEN
975:
976: -- search until we find the first index position with a value
977: IF NOT g_old_lot_serial_tbl.Exists(l_ind) THEN
978: x_index := l_ind;

Line 1050: OE_GLOBALS.G_FTE_REINVOKE:=NULL;

1046: G_Line_Adj_tbl.DELETE;
1047: G_old_Lot_Serial_tbl.DELETE;
1048: G_Lot_Serial_tbl.DELETE;
1049: --Bug 4569284
1050: OE_GLOBALS.G_FTE_REINVOKE:=NULL;
1051: --Bug 4569284
1052: x_return_status := FND_API.G_RET_STS_SUCCESS;
1053:
1054: EXCEPTION

Line 1206: l_is_xdo_licensed := Oe_Globals.CHECK_PRODUCT_INSTALLED (p_application_id => 603); --Oracle XML Publisher

1202:
1203: IF FND_FUNCTION.TEST('ONT_PRINT') THEN
1204:
1205: --Add the preview print only if XDO is licensed
1206: l_is_xdo_licensed := Oe_Globals.CHECK_PRODUCT_INSTALLED (p_application_id => 603); --Oracle XML Publisher
1207: IF l_is_xdo_licensed = 'Y' THEN
1208: Add_Access('PREVIEW_AGREEMENT');
1209: END IF;
1210:

Line 1246: IF OE_GLOBALS.G_ACCESS_List.Count=0 THEN

1242: BEGIN
1243: IF l_debug_level > 0 THEN
1244: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.ADD_ACCESS' , 1 ) ;
1245: END IF;
1246: IF OE_GLOBALS.G_ACCESS_List.Count=0 THEN
1247: OE_GLOBALS.G_Access_List(1):=Function_Name;
1248: ELSIF OE_GLOBALS.G_ACCESS_List.Count>0 THEN
1249: i:=OE_GLOBALS.G_ACCESS_List.Last+1;
1250: OE_GLOBALS.G_ACCESS_List(i):=Function_Name;

Line 1247: OE_GLOBALS.G_Access_List(1):=Function_Name;

1243: IF l_debug_level > 0 THEN
1244: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.ADD_ACCESS' , 1 ) ;
1245: END IF;
1246: IF OE_GLOBALS.G_ACCESS_List.Count=0 THEN
1247: OE_GLOBALS.G_Access_List(1):=Function_Name;
1248: ELSIF OE_GLOBALS.G_ACCESS_List.Count>0 THEN
1249: i:=OE_GLOBALS.G_ACCESS_List.Last+1;
1250: OE_GLOBALS.G_ACCESS_List(i):=Function_Name;
1251: END IF;

Line 1248: ELSIF OE_GLOBALS.G_ACCESS_List.Count>0 THEN

1244: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.ADD_ACCESS' , 1 ) ;
1245: END IF;
1246: IF OE_GLOBALS.G_ACCESS_List.Count=0 THEN
1247: OE_GLOBALS.G_Access_List(1):=Function_Name;
1248: ELSIF OE_GLOBALS.G_ACCESS_List.Count>0 THEN
1249: i:=OE_GLOBALS.G_ACCESS_List.Last+1;
1250: OE_GLOBALS.G_ACCESS_List(i):=Function_Name;
1251: END IF;
1252: IF l_debug_level > 0 THEN

Line 1249: i:=OE_GLOBALS.G_ACCESS_List.Last+1;

1245: END IF;
1246: IF OE_GLOBALS.G_ACCESS_List.Count=0 THEN
1247: OE_GLOBALS.G_Access_List(1):=Function_Name;
1248: ELSIF OE_GLOBALS.G_ACCESS_List.Count>0 THEN
1249: i:=OE_GLOBALS.G_ACCESS_List.Last+1;
1250: OE_GLOBALS.G_ACCESS_List(i):=Function_Name;
1251: END IF;
1252: IF l_debug_level > 0 THEN
1253: oe_debug_pub.add( 'EXITING OE_ORDER_UTIL.ADD_ACCESS' , 1 ) ;

Line 1250: OE_GLOBALS.G_ACCESS_List(i):=Function_Name;

1246: IF OE_GLOBALS.G_ACCESS_List.Count=0 THEN
1247: OE_GLOBALS.G_Access_List(1):=Function_Name;
1248: ELSIF OE_GLOBALS.G_ACCESS_List.Count>0 THEN
1249: i:=OE_GLOBALS.G_ACCESS_List.Last+1;
1250: OE_GLOBALS.G_ACCESS_List(i):=Function_Name;
1251: END IF;
1252: IF l_debug_level > 0 THEN
1253: oe_debug_pub.add( 'EXITING OE_ORDER_UTIL.ADD_ACCESS' , 1 ) ;
1254: END IF;

Line 1287: rg_count:=OE_GLOBALS.G_ACCESS_List.Last;

1283: IF OE_ORDER_UTIL.G_Access_List_Initialized IS NULL THEN
1284: Initialize_Access_List;
1285: END IF;
1286:
1287: rg_count:=OE_GLOBALS.G_ACCESS_List.Last;
1288:
1289: IF rg_count=0 THEN
1290: Return FALSE ;
1291: ELSE

Line 1293: IF upper(OE_GLOBALS.G_Access_List(j))=upper(action_code) THEN

1289: IF rg_count=0 THEN
1290: Return FALSE ;
1291: ELSE
1292: For j in 1..rg_count LOOP
1293: IF upper(OE_GLOBALS.G_Access_List(j))=upper(action_code) THEN
1294: return TRUE;
1295: END IF;
1296: END LOOP;
1297: END IF;

Line 1323: p_Access_List OUT NOCOPY OE_GLOBALS.ACCESS_LIST)

1319: END IS_ACTION_IN_ACCESS_LIST;
1320:
1321: PROCEDURE Get_Access_List
1322: (
1323: p_Access_List OUT NOCOPY OE_GLOBALS.ACCESS_LIST)
1324:
1325: IS
1326:
1327: BEGIN

Line 1329: p_access_list:=OE_GLOBALS.G_ACCESS_LIST;

1325: IS
1326:
1327: BEGIN
1328: Initialize_Access_List;
1329: p_access_list:=OE_GLOBALS.G_ACCESS_LIST;
1330: END Get_Access_List;
1331:
1332: Function Get_Precision(
1333: p_currency_code IN Varchar2 Default Null,