DBA Data[Home] [Help]

APPS.OE_OEOL_SCH dependencies on OE_GLOBALS

Line 34: IF NOT OE_GLOBALS.Equal(p_line_id,

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

Line 93: IF NOT OE_GLOBALS.Equal(p_line_id,

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

Line 175: ( NOT OE_Globals.Equal(p_top_model_line_id,g_top_model_line_id)

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';

Line 282: l_selected_line_tbl OE_GLOBALS.Selected_Record_Tbl;

278: l_ship_set_id NUMBER ;
279: l_arrival_set_id NUMBER;
280:
281: --10143498
282: l_selected_line_tbl OE_GLOBALS.Selected_Record_Tbl;
283: l_line_count NUMBER;
284: l_subscription_enable_flag CHAR(1) := ''; --sol_ord_er #16014165
285: BEGIN
286: --

Line 487: * AND NOT OE_GLOBALS.Equal(l_top_model_line_id,

483: );
484: /* --
485: * -- To push child lines to Schedule_Eligible block if model is not scheduled
486: * IF NVL(l_ship_model_complete_flag,'N') = 'Y'
487: * AND NOT OE_GLOBALS.Equal(l_top_model_line_id,
488: * l_line_id)
489: * THEN -- SMC
490: *
491: * l_scheduled := Is_Line_Scheduled(l_top_model_line_id);

Line 506: * AND NOT OE_GLOBALS.Equal(l_ato_line_id,

502: * return;
503: * END IF;
504: *
505: * ELSIF l_ato_line_id is not null
506: * AND NOT OE_GLOBALS.Equal(l_ato_line_id,
507: * l_line_id)
508: * THEN -- ATO
509: * l_scheduled := Is_Line_Scheduled(l_ato_line_id);
510: * IF NOT l_scheduled

Line 542: IF (l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE) OR

538: * --
539: */
540:
541: -- Added external to if stmt to bypass scheduling.
542: IF (l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE) OR
543: (l_line_category_code = 'RETURN') OR
544: (l_source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL) OR
545: NVL(l_subscription_enable_flag,'N') = 'Y' --sol_ord_er #16014165
546: THEN

Line 544: (l_source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL) OR

540:
541: -- Added external to if stmt to bypass scheduling.
542: IF (l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE) OR
543: (l_line_category_code = 'RETURN') OR
544: (l_source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL) OR
545: NVL(l_subscription_enable_flag,'N') = 'Y' --sol_ord_er #16014165
546: THEN
547:
548: -- This is a service line or a return line. We will complete

Line 554: l_source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL AND

550:
551: ROLLBACK TO Before_Lock;
552:
553: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110508' AND
554: l_source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL AND
555: l_ato_line_id = l_line_id AND
556: l_sch_ship_date is NULL THEN
557:
558: BEGIN

Line 607: AND NOT OE_GLOBALS.Equal(l_top_model_line_id,

603: -- 3565621
604: IF NOT g_skip_check
605: THEN
606: IF NVL(l_ship_model_complete_flag,'N') = 'Y'
607: AND NOT OE_GLOBALS.Equal(l_top_model_line_id,
608: l_line_id)
609: THEN -- SMC
610: IF l_debug_level > 0 THEN
611: oe_debug_pub.add( '..SMC=Y, Line not Top Model..' , 3 ) ;

Line 649: AND NOT OE_GLOBALS.Equal(l_ato_line_id,

645: return;
646: END IF;
647:
648: ELSIF l_ato_line_id is not null
649: AND NOT OE_GLOBALS.Equal(l_ato_line_id,
650: l_line_id)
651: THEN -- ATO
652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add( '..ATO Line, Line not Top Model..' , 3 ) ;

Line 812: IF OE_GLOBALS.Equal(l_line_id,

808: OR l_ato_line_id = l_line_id
809: OR (NVL(l_ship_model_complete_flag,'N') = 'N'
810: AND l_item_type_code IN('MODEL','CLASS','KIT'))
811: THEN
812: IF OE_GLOBALS.Equal(l_line_id,
813: sch_cached_line_id)
814: THEN -- To refresh the cached values
815: sch_cached_line_id := NULL;
816: END IF;

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

948:
949: l_old_line_rec := l_line_rec;
950: -- l_line_rec.schedule_action_code := OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE;
951: l_line_rec.schedule_action_code := OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE;
952: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
953:
954: -- Added this savepoint logic to fix bug 2129583.
955: SAVEPOINT Schedule_line;
956: --10143498 : NON SMC model lines to be scheduled together while booking or progress.

Line 961: NOT OE_GLOBALS.Equal(l_ato_line_id,

957: IF NVL(l_ship_model_complete_flag,'N') = 'N' AND
958: l_schedule_status_code is null AND
959: l_ship_set_id IS NULL AND
960: l_Arrival_set_id IS NULL AND -- 11825106
961: NOT OE_GLOBALS.Equal(l_ato_line_id,
962: l_top_model_line_id) AND
963: ((l_top_model_line_id = l_line_rec.line_id
964: OR l_item_type_code IN('MODEL','CLASS','KIT'))
965: AND NVL(l_line_rec.subscription_enable_flag,'N')='N') THEN -- sol_ord_er #16014165

Line 1070: IF OE_GLOBALS.Equal(l_line_rec.line_id,

1066: OR (NVL(l_line_rec.ship_model_complete_flag,'N') = 'N'
1067: AND l_line_rec.item_type_code IN('MODEL','CLASS','KIT'))
1068: AND oe_schedule_util.OESCH_SET_SCHEDULING = 'Y' -- 11825106
1069: THEN
1070: IF OE_GLOBALS.Equal(l_line_rec.line_id,
1071: sch_cached_line_id)
1072: THEN -- To refresh the cached values
1073: sch_cached_line_id := NULL;
1074: END IF;

Line 1257: IF l_source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL AND

1253:
1254: if (funcmode = 'RUN') then
1255:
1256:
1257: IF l_source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL AND
1258: nvl(l_ato_line_id, -1) <> l_line_id
1259: THEN
1260: IF l_debug_level > 0 THEN
1261: oe_debug_pub.add( 'BRANCH: DROPSHIP '|| L_LINE_ID , 2 ) ;

Line 1268: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

1264: return;
1265:
1266: ELSIF l_ato_line_id = l_line_id THEN
1267:
1268: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1269: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS
1270: THEN
1271: IF l_debug_level > 0 THEN
1272: oe_debug_pub.add( 'BRANCH: BUILD '|| L_LINE_ID , 2 ) ;

Line 1269: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS

1265:
1266: ELSIF l_ato_line_id = l_line_id THEN
1267:
1268: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1269: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS
1270: THEN
1271: IF l_debug_level > 0 THEN
1272: oe_debug_pub.add( 'BRANCH: BUILD '|| L_LINE_ID , 2 ) ;
1273: END IF;

Line 1276: ELSIF (l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR

1272: oe_debug_pub.add( 'BRANCH: BUILD '|| L_LINE_ID , 2 ) ;
1273: END IF;
1274: resultout := 'COMPLETE:BUILD';
1275: return;
1276: ELSIF (l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1277: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1278: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED) --9775352
1279: THEN
1280: IF l_debug_level > 0 THEN

Line 1277: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

1273: END IF;
1274: resultout := 'COMPLETE:BUILD';
1275: return;
1276: ELSIF (l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1277: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1278: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED) --9775352
1279: THEN
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.add( 'BRANCH: ATO ITEM '|| L_LINE_ID , 2 ) ;

Line 1278: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED) --9775352

1274: resultout := 'COMPLETE:BUILD';
1275: return;
1276: ELSIF (l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1277: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1278: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED) --9775352
1279: THEN
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.add( 'BRANCH: ATO ITEM '|| L_LINE_ID , 2 ) ;
1282: END IF;

Line 1287: ELSIF l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG

1283: resultout := 'COMPLETE:ATO_ITEM';
1284: return;
1285: END IF;
1286:
1287: ELSIF l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG
1288: AND OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
1289: AND MSC_ATP_GLOBAL.GET_APS_VERSION = 10 THEN
1290: IF l_debug_level > 0 THEN
1291: oe_debug_pub.add( 'BRANCH: ATO ITEM '|| L_LINE_ID , 2 ) ;

Line 1692: IF (l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE) OR

1688: resultout := 'COMPLETE:COMPLETE';
1689: return;
1690: END IF;
1691:
1692: IF (l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE) OR
1693: (l_line_category_code = 'RETURN') OR
1694: NVL(l_subscription_enable_flag,'N') = 'Y' --sol_ord_er #16014165
1695: THEN
1696: