APPS.OE_GRP_SCH_UTIL dependencies on STANDARD

Line 374: p_line_rec.item_type_code in ('STANDARD','OPTION') THEN

370: END IF;
371:
372: -- Added this part of validation to fix bug 2051855
373: IF p_line_rec.ato_line_id = p_line_rec.line_id AND
374: p_line_rec.item_type_code in ('STANDARD','OPTION') THEN
375:
376: l_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
377:
378: -- Added code to fix bug 2156268

Line 574: 1. Schedule standard lines and non smc PTO options

570: Procedure Schedule_Order
571: This procedure is responsible for scheduling the whole order.
572: An order can consists of many lines and each line can be within a group.
573: We plan to schedule in the following way:
574: 1. Schedule standard lines and non smc PTO options
575: (not in any set) independently.
576: 2. Schedule ATO (not in any other set) Options together.
577: 3. Schedule PTO-SMC (not in any other set) Options together.
578: 4. Schedule PTO-SMC (not in any other set) Options together.

Line 659: CURSOR standard_lines IS

655: pto_smc_count NUMBER := 0;
656: ato_count NUMBER := 0;
657:
658:
659: CURSOR standard_lines IS
660: SELECT arrival_set_id,
661: ato_line_id,
662: demand_class_code,
663: delivery_lead_time,

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 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 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 4291: -- The line will come here, if it is a standard line not

4287:
4288:
4289: ELSE
4290:
4291: -- The line will come here, if it is a standard line not
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;