[Home] [Help]
30: BEGIN
31: IF l_debug_level > 0 THEN
32: oe_debug_pub.add( 'ENTERING IS_SCHEDULING_ELIGIBLE: ' || P_LINE_ID , 1 ) ;
33: END IF;
34: IF NOT OE_GLOBALS.Equal(p_line_id,
35: sch_elg_cached_line_id)
36: THEN
37: SELECT ACTIVITY_STATUS
38: INTO l_activity_status
89:
90: IF l_debug_level > 0 THEN
91: oe_debug_pub.add( 'ENTERING IS_LINE_SCHEDULED: ' || P_LINE_ID , 1 ) ;
92: END IF;
93: IF NOT OE_GLOBALS.Equal(p_line_id,
94: sch_cached_line_id)
95: THEN
96:
97: -- Added source_type_code in the below query for bug 5880264
171: ELSIF p_ato_line_id IS NOT NULL
172: AND p_ato_line_id = p_line_id
173: -- fix for 3565621
174: AND ( g_top_model_line_id IS NULL OR
175: ( NOT OE_Globals.Equal(p_top_model_line_id,g_top_model_line_id)
176: )
177: )
178: THEN
179: l_where_clause :=' WHERE ola.ato_line_id = :P1';
444: );
445: /* --
446: * -- To push child lines to Schedule_Eligible block if model is not scheduled
447: * IF NVL(l_ship_model_complete_flag,'N') = 'Y'
448: * AND NOT OE_GLOBALS.Equal(l_top_model_line_id,
449: * l_line_id)
450: * THEN -- SMC
451: *
452: * l_scheduled := Is_Line_Scheduled(l_top_model_line_id);
463: * return;
464: * END IF;
465: *
466: * ELSIF l_ato_line_id is not null
467: * AND NOT OE_GLOBALS.Equal(l_ato_line_id,
468: * l_line_id)
469: * THEN -- ATO
470: * l_scheduled := Is_Line_Scheduled(l_ato_line_id);
471: * IF NOT l_scheduled
499: * --
500: */
501:
502: -- Added external to if stmt to bypass scheduling.
503: IF (l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE) OR
504: (l_line_category_code = 'RETURN') OR
505: (l_source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL) THEN
506:
507: -- This is a service line or a return line. We will complete
501:
502: -- Added external to if stmt to bypass scheduling.
503: IF (l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE) OR
504: (l_line_category_code = 'RETURN') OR
505: (l_source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL) THEN
506:
507: -- This is a service line or a return line. We will complete
508: -- this activity with not eligible for these lines.
509:
509:
510: ROLLBACK TO Before_Lock;
511:
512: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110508' AND
513: l_source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL AND
514: l_ato_line_id = l_line_id AND
515: l_sch_ship_date is NULL THEN
516:
517: BEGIN
562: -- 3565621
563: IF NOT g_skip_check
564: THEN
565: IF NVL(l_ship_model_complete_flag,'N') = 'Y'
566: AND NOT OE_GLOBALS.Equal(l_top_model_line_id,
567: l_line_id)
568: THEN -- SMC
569:
570: l_scheduled := Is_Line_Scheduled(l_top_model_line_id);
601: return;
602: END IF;
603:
604: ELSIF l_ato_line_id is not null
605: AND NOT OE_GLOBALS.Equal(l_ato_line_id,
606: l_line_id)
607: THEN -- ATO
608: l_scheduled := Is_Line_Scheduled(l_ato_line_id);
609: IF NOT l_scheduled
751: OR l_ato_line_id = l_line_id
752: OR (NVL(l_ship_model_complete_flag,'N') = 'N'
753: AND l_item_type_code IN('MODEL','CLASS','KIT'))
754: THEN
755: IF OE_GLOBALS.Equal(l_line_id,
756: sch_cached_line_id)
757: THEN -- To refresh the cached values
758: sch_cached_line_id := NULL;
759: END IF;
891:
892: l_old_line_rec := l_line_rec;
893: -- l_line_rec.schedule_action_code := OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE;
894: l_line_rec.schedule_action_code := OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE;
895: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
896:
897: -- Added this savepoint logic to fix bug 2129583.
898: SAVEPOINT Schedule_line;
899:
960: OR l_line_rec.ato_line_id = l_line_rec.line_id
961: OR (NVL(l_line_rec.ship_model_complete_flag,'N') = 'N'
962: AND l_line_rec.item_type_code IN('MODEL','CLASS','KIT'))
963: THEN
964: IF OE_GLOBALS.Equal(l_line_rec.line_id,
965: sch_cached_line_id)
966: THEN -- To refresh the cached values
967: sch_cached_line_id := NULL;
968: END IF;
1133:
1134: if (funcmode = 'RUN') then
1135:
1136:
1137: IF l_source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL AND
1138: nvl(l_ato_line_id, -1) <> l_line_id
1139: THEN
1140: IF l_debug_level > 0 THEN
1141: oe_debug_pub.add( 'BRANCH: DROPSHIP '|| L_LINE_ID , 2 ) ;
1144: return;
1145:
1146: ELSIF l_ato_line_id = l_line_id THEN
1147:
1148: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1149: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS
1150: THEN
1151: IF l_debug_level > 0 THEN
1152: oe_debug_pub.add( 'BRANCH: BUILD '|| L_LINE_ID , 2 ) ;
1145:
1146: ELSIF l_ato_line_id = l_line_id THEN
1147:
1148: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1149: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS
1150: THEN
1151: IF l_debug_level > 0 THEN
1152: oe_debug_pub.add( 'BRANCH: BUILD '|| L_LINE_ID , 2 ) ;
1153: END IF;
1152: oe_debug_pub.add( 'BRANCH: BUILD '|| L_LINE_ID , 2 ) ;
1153: END IF;
1154: resultout := 'COMPLETE:BUILD';
1155: return;
1156: ELSIF (l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1157: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION)
1158: THEN
1159: IF l_debug_level > 0 THEN
1160: oe_debug_pub.add( 'BRANCH: ATO ITEM '|| L_LINE_ID , 2 ) ;
1153: END IF;
1154: resultout := 'COMPLETE:BUILD';
1155: return;
1156: ELSIF (l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1157: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION)
1158: THEN
1159: IF l_debug_level > 0 THEN
1160: oe_debug_pub.add( 'BRANCH: ATO ITEM '|| L_LINE_ID , 2 ) ;
1161: END IF;
1162: resultout := 'COMPLETE:ATO_ITEM';
1163: return;
1164: END IF;
1165:
1166: ELSIF l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG
1167: AND OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
1168: AND MSC_ATP_GLOBAL.GET_APS_VERSION = 10 THEN
1169: IF l_debug_level > 0 THEN
1170: oe_debug_pub.add( 'BRANCH: ATO ITEM '|| L_LINE_ID , 2 ) ;
1564: resultout := 'COMPLETE:COMPLETE';
1565: return;
1566: END IF;
1567:
1568: IF (l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE) OR
1569: (l_line_category_code = 'RETURN') THEN
1570:
1571: -- This is a service line or a return line. We will complete
1572: -- this activity with 'NOT_ELIGIBLE'