eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_RESERVE_CONC dependencies on OE_GLOBALS

Line 354: IF NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).inventory_item_id, l_rsv_set_rec.inventory_item_id)

350: OPEN rsv_set_line(p_x_rsv_tbl(I).line_id);
351: FETCH rsv_set_line INTO l_rsv_set_rec;
352: CLOSE rsv_set_line;
353: -- comparing item information
354: IF NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).inventory_item_id, l_rsv_set_rec.inventory_item_id)
355: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ordered_qty, l_rsv_set_rec.ordered_qty)
356: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ship_from_org_id, l_rsv_set_rec.ship_from_org_id)
357: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).subinventory, l_rsv_set_rec.subinventory)
358: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ordered_qty2, l_rsv_set_rec.ordered_qty2) -- INVCONV from code review by AK

Line 355: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ordered_qty, l_rsv_set_rec.ordered_qty)

351: FETCH rsv_set_line INTO l_rsv_set_rec;
352: CLOSE rsv_set_line;
353: -- comparing item information
354: IF NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).inventory_item_id, l_rsv_set_rec.inventory_item_id)
355: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ordered_qty, l_rsv_set_rec.ordered_qty)
356: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ship_from_org_id, l_rsv_set_rec.ship_from_org_id)
357: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).subinventory, l_rsv_set_rec.subinventory)
358: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ordered_qty2, l_rsv_set_rec.ordered_qty2) -- INVCONV from code review by AK
359: OR nvl(p_x_rsv_tbl(I).shipped_quantity,0)> 0 THEN

Line 356: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ship_from_org_id, l_rsv_set_rec.ship_from_org_id)

352: CLOSE rsv_set_line;
353: -- comparing item information
354: IF NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).inventory_item_id, l_rsv_set_rec.inventory_item_id)
355: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ordered_qty, l_rsv_set_rec.ordered_qty)
356: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ship_from_org_id, l_rsv_set_rec.ship_from_org_id)
357: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).subinventory, l_rsv_set_rec.subinventory)
358: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ordered_qty2, l_rsv_set_rec.ordered_qty2) -- INVCONV from code review by AK
359: OR nvl(p_x_rsv_tbl(I).shipped_quantity,0)> 0 THEN
360: -- Save error message

Line 357: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).subinventory, l_rsv_set_rec.subinventory)

353: -- comparing item information
354: IF NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).inventory_item_id, l_rsv_set_rec.inventory_item_id)
355: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ordered_qty, l_rsv_set_rec.ordered_qty)
356: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ship_from_org_id, l_rsv_set_rec.ship_from_org_id)
357: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).subinventory, l_rsv_set_rec.subinventory)
358: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ordered_qty2, l_rsv_set_rec.ordered_qty2) -- INVCONV from code review by AK
359: OR nvl(p_x_rsv_tbl(I).shipped_quantity,0)> 0 THEN
360: -- Save error message
361: fnd_message.set_name('ONT', 'OE_SCH_ITEM_NOT_RESERVABLE');

Line 358: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ordered_qty2, l_rsv_set_rec.ordered_qty2) -- INVCONV from code review by AK

354: IF NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).inventory_item_id, l_rsv_set_rec.inventory_item_id)
355: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ordered_qty, l_rsv_set_rec.ordered_qty)
356: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ship_from_org_id, l_rsv_set_rec.ship_from_org_id)
357: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).subinventory, l_rsv_set_rec.subinventory)
358: OR NOT OE_GLOBALS.EQUAL(p_x_rsv_tbl(I).ordered_qty2, l_rsv_set_rec.ordered_qty2) -- INVCONV from code review by AK
359: OR nvl(p_x_rsv_tbl(I).shipped_quantity,0)> 0 THEN
360: -- Save error message
361: fnd_message.set_name('ONT', 'OE_SCH_ITEM_NOT_RESERVABLE');
362: OE_MSG_PUB.Add;

Line 669: IF NOT OE_GLOBALS.Equal(p_x_rsv_tbl(I).ordered_qty_UOM, l_primary_uom)

665: FOR I IN 1..p_x_rsv_tbl.COUNT
666: LOOP
667: -- 4695715 : Start
668: l_temp :=0;
669: IF NOT OE_GLOBALS.Equal(p_x_rsv_tbl(I).ordered_qty_UOM, l_primary_uom)
670: THEN
671: IF l_debug_level > 0 THEN
672: oe_debug_pub.add( 'Before UOM convertion :' || l_total_supply || '/' || l_primary_uom, 1 ) ;
673: END IF;

Line 715: IF OE_GLOBALS.Equal(l_primary_uom ,p_x_rsv_tbl(I).ordered_qty_uom) THEN

711: END IF;
712:
713: --l_total_supply := l_total_supply - p_x_rsv_tbl(I).derived_reserved_qty;
714: -- 4695715 : Start
715: IF OE_GLOBALS.Equal(l_primary_uom ,p_x_rsv_tbl(I).ordered_qty_uom) THEN
716: g_consumed_for_lot := g_consumed_for_lot + p_x_rsv_tbl(I).derived_reserved_qty;
717: l_total_supply := l_total_supply - p_x_rsv_tbl(I).derived_reserved_qty;
718: ELSE
719: l_temp := INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,

Line 799: IF OE_GLOBALS.Equal(l_primary_uom ,p_x_rsv_tbl(I).ordered_qty_uom) THEN

795:
796: --4695715 : Start
797: l_temp :=0;
798: --l_total_supply := l_total_supply - p_x_rsv_tbl(I).derived_reserved_qty;
799: IF OE_GLOBALS.Equal(l_primary_uom ,p_x_rsv_tbl(I).ordered_qty_uom) THEN
800: g_consumed_for_lot := g_consumed_for_lot + p_x_rsv_tbl(I).derived_reserved_qty;
801: l_total_supply := l_total_supply - p_x_rsv_tbl(I).derived_reserved_qty;
802: ELSE
803: l_temp := INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,

Line 1074: IF OE_GLOBALS.Equal(p_rsv_tbl(I).ordered_qty_uom, l_primary_uom)

1070: END IF;
1071: FOR I IN 1..p_rsv_tbl.COUNT
1072: LOOP
1073:
1074: IF OE_GLOBALS.Equal(p_rsv_tbl(I).ordered_qty_uom, l_primary_uom)
1075: THEN
1076: l_total_demand := l_total_demand + p_rsv_tbl(I).ordered_qty;
1077: ELSE
1078: l_converted_qty :=

Line 1189: IF NOT OE_GLOBALS.Equal(p_x_rsv_tbl(I).ordered_qty_UOM, l_primary_uom)

1185: FOR I in 1..p_x_rsv_tbl.COUNT
1186: LOOP
1187: -- 4695715 :Start
1188:
1189: IF NOT OE_GLOBALS.Equal(p_x_rsv_tbl(I).ordered_qty_UOM, l_primary_uom)
1190: AND NVL(p_reservation_mode,'*') ='PERCENT'
1191: THEN
1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add( 'Before UOM convertion :' || l_total_supply || '/' || l_primary_uom, 1 ) ;

Line 1281: IF OE_GLOBALS.Equal(l_primary_uom, p_x_rsv_tbl(I).ordered_qty_uom) THEN

1277: -- Keeping copy of derived quantity
1278: p_x_rsv_tbl(I).derived_reserved_qty_mir := p_x_rsv_tbl(I).derived_reserved_qty;
1279: p_x_rsv_tbl(I).reserved_qty_UOM := p_x_rsv_tbl(I).ordered_qty_UOM;
1280: -- 4695715 :Start
1281: IF OE_GLOBALS.Equal(l_primary_uom, p_x_rsv_tbl(I).ordered_qty_uom) THEN
1282: g_consumed_for_lot := g_consumed_for_lot + p_x_rsv_tbl(I).derived_reserved_qty;
1283: IF NVL(p_reservation_mode,'*') ='PERCENT' THEN
1284: l_total_supply := l_total_supply - p_x_rsv_tbl(I).derived_reserved_qty;
1285:

Line 2871: IF OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)

2867: l_old_warehouse := l_rsv_tbl(I).ship_from_org_id;
2868: l_old_subinventory := l_rsv_tbl(I).subinventory;
2869: l_old_org_id := l_rsv_tbl(I).org_id; -- 4759251
2870: END IF;
2871: IF OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)
2872: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)
2873: AND OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory)
2874: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) THEN --4759251
2875: -- 6814153

Line 2872: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)

2868: l_old_subinventory := l_rsv_tbl(I).subinventory;
2869: l_old_org_id := l_rsv_tbl(I).org_id; -- 4759251
2870: END IF;
2871: IF OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)
2872: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)
2873: AND OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory)
2874: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) THEN --4759251
2875: -- 6814153
2876: IF p_reservation_mode ='PARTIAL' THEN

Line 2873: AND OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory)

2869: l_old_org_id := l_rsv_tbl(I).org_id; -- 4759251
2870: END IF;
2871: IF OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)
2872: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)
2873: AND OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory)
2874: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) THEN --4759251
2875: -- 6814153
2876: IF p_reservation_mode ='PARTIAL' THEN
2877: l_sales_order_id :=

Line 2874: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) THEN --4759251

2870: END IF;
2871: IF OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)
2872: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)
2873: AND OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory)
2874: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) THEN --4759251
2875: -- 6814153
2876: IF p_reservation_mode ='PARTIAL' THEN
2877: l_sales_order_id :=
2878: Oe_Schedule_Util.Get_mtl_sales_order_id(l_rsv_tbl(I).HEADER_ID);

Line 2912: AND OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)

2908: p_reserve_run_type => p_reserve_run_type,
2909: p_reserve_set_name => p_reserve_set_name);
2910:
2911: IF p_reserve_run_type ='SIMULATE'
2912: AND OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)
2913: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)
2914: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) -- 4759251
2915: AND NOT OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory) THEN
2916: G_Total_Consumed := G_Total_Consumed + G_Consumed_for_Lot;

Line 2913: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)

2909: p_reserve_set_name => p_reserve_set_name);
2910:
2911: IF p_reserve_run_type ='SIMULATE'
2912: AND OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)
2913: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)
2914: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) -- 4759251
2915: AND NOT OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory) THEN
2916: G_Total_Consumed := G_Total_Consumed + G_Consumed_for_Lot;
2917: G_Consumed_for_Lot := 0;

Line 2914: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) -- 4759251

2910:
2911: IF p_reserve_run_type ='SIMULATE'
2912: AND OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)
2913: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)
2914: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) -- 4759251
2915: AND NOT OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory) THEN
2916: G_Total_Consumed := G_Total_Consumed + G_Consumed_for_Lot;
2917: G_Consumed_for_Lot := 0;
2918: G_Total_Consumed2 := G_Total_Consumed2 + G_Consumed_for_Lot2; -- INVCONV from code review by AK

Line 2915: AND NOT OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory) THEN

2911: IF p_reserve_run_type ='SIMULATE'
2912: AND OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)
2913: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)
2914: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) -- 4759251
2915: AND NOT OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory) THEN
2916: G_Total_Consumed := G_Total_Consumed + G_Consumed_for_Lot;
2917: G_Consumed_for_Lot := 0;
2918: G_Total_Consumed2 := G_Total_Consumed2 + G_Consumed_for_Lot2; -- INVCONV from code review by AK
2919: G_Consumed_for_Lot2 := 0;

Line 2936: AND OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)

2932: p_reserve_run_type => p_reserve_run_type,
2933: p_reserve_set_name => p_reserve_set_name);
2934:
2935: IF p_reserve_run_type ='SIMULATE'
2936: AND OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)
2937: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)
2938: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) -- 4759251
2939: AND NOT OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory) THEN
2940: G_Total_Consumed := G_Total_Consumed + G_Consumed_for_Lot;

Line 2937: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)

2933: p_reserve_set_name => p_reserve_set_name);
2934:
2935: IF p_reserve_run_type ='SIMULATE'
2936: AND OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)
2937: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)
2938: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) -- 4759251
2939: AND NOT OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory) THEN
2940: G_Total_Consumed := G_Total_Consumed + G_Consumed_for_Lot;
2941: G_Consumed_for_Lot := 0;

Line 2938: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) -- 4759251

2934:
2935: IF p_reserve_run_type ='SIMULATE'
2936: AND OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)
2937: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)
2938: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) -- 4759251
2939: AND NOT OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory) THEN
2940: G_Total_Consumed := G_Total_Consumed + G_Consumed_for_Lot;
2941: G_Consumed_for_Lot := 0;
2942: G_Total_Consumed2 := G_Total_Consumed2 + G_Consumed_for_Lot2; -- INVCONV from code review by AK

Line 2939: AND NOT OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory) THEN

2935: IF p_reserve_run_type ='SIMULATE'
2936: AND OE_GLOBALS.Equal(l_old_item_id, l_rsv_tbl(I).inventory_item_id)
2937: AND OE_GLOBALS.Equal(l_old_warehouse, l_rsv_tbl(I).ship_from_org_id)
2938: AND OE_GLOBALS.Equal(l_old_org_id,l_rsv_tbl(I).org_id) -- 4759251
2939: AND NOT OE_GLOBALS.Equal(l_old_subinventory, l_rsv_tbl(I).subinventory) THEN
2940: G_Total_Consumed := G_Total_Consumed + G_Consumed_for_Lot;
2941: G_Consumed_for_Lot := 0;
2942: G_Total_Consumed2 := G_Total_Consumed2 + G_Consumed_for_Lot2; -- INVCONV from code review by AK
2943: G_Consumed_for_Lot2 := 0;