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_GRP_SCH_UTIL dependencies on OE_GLOBALS

Line 121: IF NOT OE_GLOBALS.Equal(p_old_line_rec.reserved_quantity,

117:
118: -- Check to see if the reserved quantity is changed and is more
119: -- than the ordered quantity. This should not be allowed.
120:
121: IF NOT OE_GLOBALS.Equal(p_old_line_rec.reserved_quantity,
122: p_line_rec.reserved_quantity)
123: THEN
124: -- Reserved Quantity has changed
125: IF (p_line_rec.ordered_quantity < p_line_rec.reserved_quantity)

Line 158: IF NOT OE_GLOBALS.Equal(p_old_line_rec.ordered_quantity,

154: -- Check to see if the ordered quantity and reserved quantity
155: -- both have changed and if the ordered quantity is less than
156: -- the reserved quantity. This should not be allowed.
157:
158: IF NOT OE_GLOBALS.Equal(p_old_line_rec.ordered_quantity,
159: p_line_rec.ordered_quantity)
160: THEN
161: -- Ordered Quantity has changed
162: IF NOT OE_GLOBALS.Equal(p_old_line_rec.reserved_quantity,

Line 162: IF NOT OE_GLOBALS.Equal(p_old_line_rec.reserved_quantity,

158: IF NOT OE_GLOBALS.Equal(p_old_line_rec.ordered_quantity,
159: p_line_rec.ordered_quantity)
160: THEN
161: -- Ordered Quantity has changed
162: IF NOT OE_GLOBALS.Equal(p_old_line_rec.reserved_quantity,
163: p_line_rec.reserved_quantity)
164: THEN
165: IF (p_line_rec.ordered_quantity < p_line_rec.reserved_quantity)
166: THEN

Line 604: l_control_rec OE_GLOBALS.control_rec_type;

600: l_return_status VARCHAR2(1);
601: l_msg_count NUMBER;
602: l_msg_data VARCHAR2(2000);
603:
604: l_control_rec OE_GLOBALS.control_rec_type;
605: l_line_tbl OE_ORDER_PUB.line_tbl_type;
606: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
607: l_header_rec OE_Order_PUB.Header_Rec_Type;
608: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;

Line 686: AND item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED;

682: sold_to_org_id,
683: top_model_line_id
684: FROM oe_order_lines
685: WHERE header_id = p_header_id
686: AND item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED;
687:
688: --
689: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
690: --

Line 764: IF (l_line_tbl(line_index).item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

760: goto end_loop;
761:
762: END IF;
763:
764: IF (l_line_tbl(line_index).item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
765: l_line_tbl(line_index).item_type_code = OE_GLOBALS.G_ITEM_OPTION) AND
766: l_line_tbl(line_index).ato_line_id <>
767: l_line_tbl(line_index).line_id AND
768: (l_line_tbl(line_index).ship_model_complete_flag = 'Y' OR

Line 765: l_line_tbl(line_index).item_type_code = OE_GLOBALS.G_ITEM_OPTION) AND

761:
762: END IF;
763:
764: IF (l_line_tbl(line_index).item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
765: l_line_tbl(line_index).item_type_code = OE_GLOBALS.G_ITEM_OPTION) AND
766: l_line_tbl(line_index).ato_line_id <>
767: l_line_tbl(line_index).line_id AND
768: (l_line_tbl(line_index).ship_model_complete_flag = 'Y' OR
769: l_line_tbl(line_index).ato_line_id is not null) AND

Line 880: l_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD AND

876: IF (l_line_rec.ship_set_id is not null OR
877: l_line_rec.arrival_set_id is not null OR
878: l_line_rec.ship_model_complete_flag = 'Y' OR
879: (l_line_rec.ato_line_id = l_line_rec.line_id AND
880: l_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD AND
881: l_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_OPTION)) AND
882: (p_sch_action = OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE OR
883: p_sch_action = OE_ORDER_SCH_UTIL.OESCH_ACT_UNSCHEDULE OR
884: p_sch_action = OE_ORDER_SCH_UTIL.OESCH_ACT_ATP_CHECK OR

Line 881: l_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_OPTION)) AND

877: l_line_rec.arrival_set_id is not null OR
878: l_line_rec.ship_model_complete_flag = 'Y' OR
879: (l_line_rec.ato_line_id = l_line_rec.line_id AND
880: l_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD AND
881: l_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_OPTION)) AND
882: (p_sch_action = OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE OR
883: p_sch_action = OE_ORDER_SCH_UTIL.OESCH_ACT_UNSCHEDULE OR
884: p_sch_action = OE_ORDER_SCH_UTIL.OESCH_ACT_ATP_CHECK OR
885: (p_sch_action = OE_ORDER_SCH_UTIL.OESCH_ACT_RESERVE AND

Line 935: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

931:
932: ELSE
933:
934: l_line_rec.schedule_action_code := p_sch_action;
935: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
936:
937: IF l_debug_level > 0 THEN
938: oe_debug_pub.add( 'SCHEDULING LINE: ' || L_LINE_REC.LINE_ID , 1 ) ;
939: END IF;

Line 1132: l_control_rec OE_GLOBALS.control_rec_type;

1128: l_msg_count NUMBER;
1129: l_msg_data VARCHAR2(2000);
1130: l_action VARCHAR2(30) := NULL;
1131: -- For calling process order.
1132: l_control_rec OE_GLOBALS.control_rec_type;
1133: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1134: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1135: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
1136: l_header_rec OE_Order_PUB.Header_Rec_Type;

Line 1438: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

1434: IF (p_group_req_rec.schedule_arrival_date is not null) THEN
1435: l_line_rec.schedule_arrival_date := p_group_req_rec.schedule_arrival_date;
1436: END IF;
1437:
1438: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1439: l_line_tbl(I) := l_line_rec;
1440: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1441:
1442: END LOOP;

Line 1626: IF l_set_line_tbl(I).item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED THEN

1622: l_sales_order_id := OE_ORDER_SCH_UTIL.Get_mtl_sales_order_id
1623: (l_set_line_tbl(1).HEADER_ID);
1624: END IF;
1625:
1626: IF l_set_line_tbl(I).item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED THEN
1627: J := J + 1;
1628: x_line_tbl(J) := l_set_line_tbl(I);
1629:
1630: IF x_line_tbl(J).schedule_status_code is not null THEN

Line 1645: (x_line_tbl(J).item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

1641:
1642: -- Get the included items for every line which is a model, class, kit
1643:
1644: IF (x_line_tbl(J).ato_line_id is null) AND
1645: (x_line_tbl(J).item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1646: x_line_tbl(J).item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1647: x_line_tbl(J).item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN
1648:
1649: -- Calling Process_Included_Items. This procedure

Line 1646: x_line_tbl(J).item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

1642: -- Get the included items for every line which is a model, class, kit
1643:
1644: IF (x_line_tbl(J).ato_line_id is null) AND
1645: (x_line_tbl(J).item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1646: x_line_tbl(J).item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1647: x_line_tbl(J).item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN
1648:
1649: -- Calling Process_Included_Items. This procedure
1650: -- will take care of exploding and updating the picture

Line 1647: x_line_tbl(J).item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN

1643:
1644: IF (x_line_tbl(J).ato_line_id is null) AND
1645: (x_line_tbl(J).item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1646: x_line_tbl(J).item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1647: x_line_tbl(J).item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN
1648:
1649: -- Calling Process_Included_Items. This procedure
1650: -- will take care of exploding and updating the picture
1651: -- of included_items in the oe_order_lines table.

Line 1653: l_old_recursion_mode := OE_GLOBALS.G_RECURSION_MODE;

1649: -- Calling Process_Included_Items. This procedure
1650: -- will take care of exploding and updating the picture
1651: -- of included_items in the oe_order_lines table.
1652:
1653: l_old_recursion_mode := OE_GLOBALS.G_RECURSION_MODE;
1654: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
1655:
1656: IF l_debug_level > 0 THEN
1657: oe_debug_pub.add( 'CALLING PROCESS_INCLUDED_ITEMS FOR ITEM: ' || X_LINE_TBL ( J ) .INVENTORY_ITEM_ID ) ;

Line 1654: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';

1650: -- will take care of exploding and updating the picture
1651: -- of included_items in the oe_order_lines table.
1652:
1653: l_old_recursion_mode := OE_GLOBALS.G_RECURSION_MODE;
1654: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
1655:
1656: IF l_debug_level > 0 THEN
1657: oe_debug_pub.add( 'CALLING PROCESS_INCLUDED_ITEMS FOR ITEM: ' || X_LINE_TBL ( J ) .INVENTORY_ITEM_ID ) ;
1658: END IF;

Line 1664: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;

1660: l_return_status := OE_CONFIG_UTIL.Process_Included_Items
1661: (p_line_rec => x_line_tbl(J),
1662: p_freeze => FALSE);
1663:
1664: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
1665:
1666: IF l_debug_level > 0 THEN
1667: oe_debug_pub.add( 'AFTER CALLING PROCESS_INCLUDED_ITEMS ' , 1 ) ;
1668: END IF;

Line 1978: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

1974: l_line_rec.schedule_arrival_date :=
1975: p_group_req_rec.schedule_arrival_date;
1976: END IF;
1977:
1978: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1979: l_line_tbl(I) := l_line_rec;
1980:
1981: END LOOP;
1982: END IF; /* Ship Set */

Line 2014: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

2010: l_line_rec.schedule_arrival_date :=
2011: p_group_req_rec.schedule_arrival_date;
2012: END IF;
2013:
2014: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2015: l_line_tbl(I) := l_line_rec;
2016:
2017: END LOOP;
2018: END IF;

Line 2295: (p_x_line_tbl(1).item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR

2291: IF p_x_line_tbl(1).schedule_status_code IS NOT NULL AND
2292: NOT OE_ORDER_SCH_UTIL.Schedule_Attribute_Changed
2293: (p_line_rec => p_x_line_tbl(1),
2294: p_old_line_rec => p_old_line_tbl(1)) AND
2295: (p_x_line_tbl(1).item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
2296: nvl(p_x_line_tbl(1).model_remnant_flag,'N') = 'Y') THEN
2297:
2298: IF l_debug_level > 0 THEN
2299: oe_debug_pub.add( 'ARRIVAL_SET_ID : ' || P_X_LINE_TBL ( 1 ) .ARRIVAL_SET_ID || ':' || P_X_LINE_TBL ( 1 ) .SHIP_SET_ID , 2 ) ;

Line 2346: (p_x_line_tbl(I).item_type_code <> OE_GLOBALS.G_ITEM_STANDARD AND

2342: IF p_x_line_tbl(I).schedule_status_code IS NULL OR
2343: OE_ORDER_SCH_UTIL.Schedule_Attribute_Changed
2344: (p_line_rec => p_x_line_tbl(I),
2345: p_old_line_rec => p_old_line_tbl(I)) OR
2346: (p_x_line_tbl(I).item_type_code <> OE_GLOBALS.G_ITEM_STANDARD AND
2347: nvl(p_x_line_tbl(I).model_remnant_flag,'N') = 'N') THEN
2348:
2349: IF l_debug_level > 0 THEN
2350: oe_debug_pub.add( 'UNABLE TO BYPASS' , 2 ) ;

Line 2410: IF ((p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND

2406: p_x_line_tbl(I).arrival_set_id is not null) THEN
2407: OE_ORDER_SCH_UTIL.OESCH_PERFORM_GRP_SCHEDULING := 'N';
2408: l_log_msg := 'N';
2409: END IF;
2410: IF ((p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND
2411: nvl(p_x_line_tbl(I).model_remnant_flag,'N') = 'N') OR
2412: p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_SERVICE) THEN
2413:
2414: -- Service items cannot be scheduled, so we will skip them.

Line 2412: p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_SERVICE) THEN

2408: l_log_msg := 'N';
2409: END IF;
2410: IF ((p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND
2411: nvl(p_x_line_tbl(I).model_remnant_flag,'N') = 'N') OR
2412: p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_SERVICE) THEN
2413:
2414: -- Service items cannot be scheduled, so we will skip them.
2415: -- Included items will be picked up by their parent, so we will
2416: -- skip them.

Line 2444: (p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

2440: l_old_line_tbl(K) := p_old_line_tbl(I);
2441:
2442: IF (p_x_line_tbl(I).ato_line_id is null) AND
2443: nvl(p_x_line_tbl(I).model_remnant_flag,'N') <> 'Y' AND
2444: (p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
2445: p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2446: p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN
2447:
2448: -- Calling Process_Included_Items. This procedure

Line 2445: p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

2441:
2442: IF (p_x_line_tbl(I).ato_line_id is null) AND
2443: nvl(p_x_line_tbl(I).model_remnant_flag,'N') <> 'Y' AND
2444: (p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
2445: p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2446: p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN
2447:
2448: -- Calling Process_Included_Items. This procedure
2449: -- will take care of exploding and updating the picture

Line 2446: p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN

2442: IF (p_x_line_tbl(I).ato_line_id is null) AND
2443: nvl(p_x_line_tbl(I).model_remnant_flag,'N') <> 'Y' AND
2444: (p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
2445: p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2446: p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN
2447:
2448: -- Calling Process_Included_Items. This procedure
2449: -- will take care of exploding and updating the picture
2450: -- of included_items in the oe_order_lines table.

Line 2456: l_old_recursion_mode := OE_GLOBALS.G_RECURSION_MODE;

2452: IF l_debug_level > 0 THEN
2453: oe_debug_pub.add( 'CALLING PROCESS_INCLUDED_ITEMS ' , 1 ) ;
2454: END IF;
2455:
2456: l_old_recursion_mode := OE_GLOBALS.G_RECURSION_MODE;
2457: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
2458:
2459: -- Bug 2304287
2460: l_old_perform := OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING;

Line 2457: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';

2453: oe_debug_pub.add( 'CALLING PROCESS_INCLUDED_ITEMS ' , 1 ) ;
2454: END IF;
2455:
2456: l_old_recursion_mode := OE_GLOBALS.G_RECURSION_MODE;
2457: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
2458:
2459: -- Bug 2304287
2460: l_old_perform := OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING;
2461: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';

Line 2467: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;

2463: l_return_status := OE_CONFIG_UTIL.Process_Included_Items
2464: (p_line_rec => p_x_line_tbl(I),
2465: p_freeze => FALSE);
2466:
2467: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
2468: IF l_debug_level > 0 THEN
2469: oe_debug_pub.add( 'AFTER CALLING PROCESS_INCLUDED_ITEMS ' , 1 ) ;
2470: END IF;
2471:

Line 2493: l_line_tbl(k).operation := OE_GLOBALS.G_OPR_UPDATE;

2489: FOR J IN 1..l_ii_line_tbl.count LOOP
2490: K := K+1;
2491: l_line_tbl(k) := l_ii_line_tbl(J);
2492: l_old_line_tbl(K) := l_ii_line_tbl(J);
2493: l_line_tbl(k).operation := OE_GLOBALS.G_OPR_UPDATE;
2494: l_line_tbl(k).schedule_action_code :=
2495: OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE;
2496: l_line_tbl(k).ship_set :=
2497: p_x_line_tbl(I).ship_set;

Line 2672: l_line_tbl(J).operation := OE_GLOBALS.G_OPR_UPDATE;

2668: l_line_tbl(J) := l_grp_line_tbl(I);
2669: l_line_tbl(J).schedule_action_code :=
2670: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE;
2671:
2672: l_line_tbl(J).operation := OE_GLOBALS.G_OPR_UPDATE;
2673:
2674: l_old_line_tbl(J) := l_grp_line_tbl(I);
2675: END IF;
2676: END LOOP;

Line 2886: IF l_line_tbl(J).item_type_code <> OE_GLOBALS.G_ITEM_CONFIG AND

2882: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE THEN
2883: FOR J IN 1..l_line_tbl.count LOOP
2884:
2885: l_re_reserve_flag(j) := 'N';
2886: IF l_line_tbl(J).item_type_code <> OE_GLOBALS.G_ITEM_CONFIG AND
2887: nvl(l_line_tbl(J).shipping_interfaced_flag, 'N') = 'N' THEN
2888: -- We do not want to unreserve config item while rescheduling.
2889: -- Unreserve only if there is any change in the warehouse.
2890: -- Inventory changes are not allowed for model/option/classes.

Line 2893: IF NOT OE_GLOBALS.Equal(l_line_tbl(j).ship_from_org_id,

2889: -- Unreserve only if there is any change in the warehouse.
2890: -- Inventory changes are not allowed for model/option/classes.
2891: -- For subinventory changes system will not log group request
2892: -- Modified code to fix bug 1894284.
2893: IF NOT OE_GLOBALS.Equal(l_line_tbl(j).ship_from_org_id,
2894: l_old_line_tbl(j).ship_from_org_id) THEN
2895: IF l_old_line_tbl(J).reserved_quantity > 0 THEN
2896: /*OE_ORDER_SCH_UTIL.Unreserve_Line
2897: ( p_line_rec => l_old_line_tbl(J)

Line 3047: IF NOT OE_GLOBALS.Equal(l_schedule_action_code,

3043: oe_debug_pub.add( ' ' , 1 ) ;
3044: END IF;
3045:
3046:
3047: IF NOT OE_GLOBALS.Equal(l_schedule_action_code,
3048: OE_ORDER_SCH_UTIL.OESCH_ACT_ATP_CHECK) AND
3049: NOT OE_GLOBALS.Equal(l_schedule_action_code,
3050: OE_ORDER_SCH_UTIL.OESCH_ACT_UNRESERVE) AND
3051: p_write_to_db = FND_API.G_TRUE THEN

Line 3049: NOT OE_GLOBALS.Equal(l_schedule_action_code,

3045:
3046:
3047: IF NOT OE_GLOBALS.Equal(l_schedule_action_code,
3048: OE_ORDER_SCH_UTIL.OESCH_ACT_ATP_CHECK) AND
3049: NOT OE_GLOBALS.Equal(l_schedule_action_code,
3050: OE_ORDER_SCH_UTIL.OESCH_ACT_UNRESERVE) AND
3051: p_write_to_db = FND_API.G_TRUE THEN
3052:
3053: -- Turning off Perform Scheduling Flag Before calling

Line 3080: l_out_line_tbl1(K).operation := OE_GLOBALS.G_OPR_UPDATE;

3076:
3077: IF nvl(l_line_tbl(I).open_flag,'Y') = 'Y' THEN
3078:
3079: l_out_line_tbl1(K) := l_line_tbl(I);
3080: l_out_line_tbl1(K).operation := OE_GLOBALS.G_OPR_UPDATE;
3081: l_old_line_tbl1(K) := p_old_line_tbl(I);
3082:
3083: K := K + 1;
3084:

Line 3206: AND l_line_tbl(j).Item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN

3202: END IF;
3203:
3204: IF l_line_tbl(j).shippable_flag = 'Y'
3205: AND l_line_tbl(j).ordered_quantity > 0
3206: AND l_line_tbl(j).Item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
3207:
3208: SELECT RESERVABLE_TYPE
3209: INTO l_reservable_type
3210: FROM MTL_SYSTEM_ITEMS

Line 3369: AND NOT OE_GLOBALS.Equal(l_line_tbl(j).schedule_ship_date,

3365: -- Adding code to fix bug 2126165.
3366:
3367: IF l_line_tbl(j).schedule_action_code =
3368: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE
3369: AND NOT OE_GLOBALS.Equal(l_line_tbl(j).schedule_ship_date,
3370: l_old_line_tbl(j).schedule_ship_date)
3371: AND l_old_line_tbl(j).reserved_quantity > 0
3372: AND l_old_line_tbl(j).reserved_quantity <> FND_API.G_MISS_NUM
3373: AND Nvl(l_re_reserve_flag(j),'N') = 'N'

Line 3571: IF NOT OE_GLOBALS.Equal(l_schedule_action_code,

3567: /*
3568: oe_debug_pub.add('----- After Printing OUT Table -----',1);
3569: oe_debug_pub.add(' ',1);
3570:
3571: IF NOT OE_GLOBALS.Equal(l_schedule_action_code,
3572: OE_ORDER_SCH_UTIL.OESCH_ACT_ATP_CHECK) AND
3573: NOT OE_GLOBALS.Equal(l_schedule_action_code,
3574: OE_ORDER_SCH_UTIL.OESCH_ACT_UNRESERVE) AND
3575: p_write_to_db = FND_API.G_TRUE THEN

Line 3573: NOT OE_GLOBALS.Equal(l_schedule_action_code,

3569: oe_debug_pub.add(' ',1);
3570:
3571: IF NOT OE_GLOBALS.Equal(l_schedule_action_code,
3572: OE_ORDER_SCH_UTIL.OESCH_ACT_ATP_CHECK) AND
3573: NOT OE_GLOBALS.Equal(l_schedule_action_code,
3574: OE_ORDER_SCH_UTIL.OESCH_ACT_UNRESERVE) AND
3575: p_write_to_db = FND_API.G_TRUE THEN
3576:
3577: -- Turning off Perform Scheduling Flag Before calling

Line 3600: l_out_line_tbl1(K).operation := OE_GLOBALS.G_OPR_UPDATE;

3596:
3597: IF nvl(l_line_tbl(I).open_flag,'Y') = 'Y' THEN
3598:
3599: l_out_line_tbl1(K) := l_line_tbl(I);
3600: l_out_line_tbl1(K).operation := OE_GLOBALS.G_OPR_UPDATE;
3601: l_old_line_tbl1(K) := p_old_line_tbl(I);
3602:
3603: K := K + 1;
3604:

Line 3754: AND item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED

3750: SELECT LINE_ID
3751: FROM OE_ORDER_LINES_ALL
3752: WHERE
3753: HEADER_ID = p_header_id
3754: AND item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED
3755: ORDER BY arrival_set_id,ship_set_id,line_number,shipment_number,nvl(option_number,-1);
3756:
3757: -- Added nvl stmt to fix bug 1937881.
3758: --

Line 4040: IF l_line_tbl(line_count).item_type_code = OE_GLOBALS.G_ITEM_MODEL AND

4036: line_count := line_count + 1;
4037: l_line_tbl(line_count) := l_line_rec;
4038: END IF;
4039:
4040: IF l_line_tbl(line_count).item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
4041: l_line_tbl(line_count).ato_line_id is null AND
4042: nvl(l_line_tbl(line_count).ship_model_complete_flag,'N') = 'N' THEN
4043:
4044: l_top_model_line_id := l_line_tbl(line_count).top_model_line_id;

Line 4063: OE_GLOBALS.G_ITEM_INCLUDED THEN

4059: x_line_tbl => l_option_tbl);
4060:
4061: FOR option_count in 1..l_option_tbl.count LOOP
4062: IF l_option_tbl(option_count).item_type_code <>
4063: OE_GLOBALS.G_ITEM_INCLUDED THEN
4064: IF l_option_tbl(option_count).line_id <>
4065: l_top_model_line_id THEN
4066: -- Search for Option in the Line table, if the option does
4067: -- not Exist in the table then add it to the table.

Line 4218: l_line_rec.item_type_code IN( OE_GLOBALS.G_ITEM_STANDARD,

4214: l_line_rec.arrival_set_id is not null OR
4215: l_line_rec.ship_model_complete_flag = 'Y' OR
4216: (l_line_rec.ato_line_id is not null AND
4217: NOT (l_line_rec.line_id = l_line_rec.ato_line_id AND
4218: l_line_rec.item_type_code IN( OE_GLOBALS.G_ITEM_STANDARD,
4219: OE_GLOBALS.G_ITEM_OPTION)))) AND
4220: (p_action = OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE OR
4221: p_action = OE_ORDER_SCH_UTIL.OESCH_ACT_UNSCHEDULE OR
4222: p_action = OE_ORDER_SCH_UTIL.OESCH_ACT_ATP_CHECK OR

Line 4219: OE_GLOBALS.G_ITEM_OPTION)))) AND

4215: l_line_rec.ship_model_complete_flag = 'Y' OR
4216: (l_line_rec.ato_line_id is not null AND
4217: NOT (l_line_rec.line_id = l_line_rec.ato_line_id AND
4218: l_line_rec.item_type_code IN( OE_GLOBALS.G_ITEM_STANDARD,
4219: OE_GLOBALS.G_ITEM_OPTION)))) AND
4220: (p_action = OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE OR
4221: p_action = OE_ORDER_SCH_UTIL.OESCH_ACT_UNSCHEDULE OR
4222: p_action = OE_ORDER_SCH_UTIL.OESCH_ACT_ATP_CHECK OR
4223: ((p_action = OE_ORDER_SCH_UTIL.OESCH_ACT_UNRESERVE OR

Line 4296: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

4292: -- belong to any group, or if the action on it is RESERVE
4293: -- or UNRESERVE (and it does belong to a group).
4294:
4295: l_line_rec.schedule_action_code := p_action;
4296: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4297:
4298: IF l_debug_level > 0 THEN
4299: oe_debug_pub.add( 'SCHEDULING LINE: ' || L_LINE_REC.LINE_ID , 1 ) ;
4300: END IF;