APPS.OE_SET_UTIL dependencies on OE_SCHEDULE_UTIL

Line 7213: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;

7209:
7210: FOR i in C8 loop
7211: l_child_line_rec:=OE_LINE_UTIL.QUERY_ROW(p_line_id => i.line_id);
7212: IF l_child_line_rec.schedule_status_code is not null THEN
7213: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
7214: ELSE
7215: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE;
7216: END IF;
7217:

Line 7215: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE;

7211: l_child_line_rec:=OE_LINE_UTIL.QUERY_ROW(p_line_id => i.line_id);
7212: IF l_child_line_rec.schedule_status_code is not null THEN
7213: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
7214: ELSE
7215: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE;
7216: END IF;
7217:
7218: IF OE_QUOTE_UTIL.G_COMPLETE_NEG='Y'
7219: THEN

Line 7228: l_entity_type := OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET;

7224:
7225: IF l_set_type='ARRIVAL_SET'
7226: AND i.arrival_set_id<>l_old_set_id THEN
7227:
7228: l_entity_type := OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET;
7229:
7230: IF l_debug_level > 0 THEN
7231: oe_debug_pub.add( 'new arrival set id id'||i.arrival_set_id);
7232: END IF;

Line 7271: l_entity_type := OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET;

7267: END IF;
7268: ELSIF l_set_type='SHIP_SET'
7269: AND i.ship_set_id<>l_old_set_id THEN
7270:
7271: l_entity_type := OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET;
7272:
7273: IF l_debug_level > 0 THEN
7274: oe_debug_pub.add( 'new ship set id id'||i.ship_set_id);
7275: END IF;

Line 7728: IF p_request_rec.param3 = oe_schedule_util.OESCH_ENTITY_SHIP_SET THEN

7724: oe_debug_pub.add( 'SET ID'||p_request_rec.param1 , 3 ) ;
7725: END IF;
7726: x_return_status := FND_API.G_RET_STS_SUCCESS;
7727: BEGIN
7728: IF p_request_rec.param3 = oe_schedule_util.OESCH_ENTITY_SHIP_SET THEN
7729: SELECT 1
7730: INTO l_dummy
7731: FROM oe_order_lines_all
7732: WHERE header_id=p_request_rec.param2

Line 7739: ELSIF p_request_rec.param3 = oe_schedule_util.OESCH_ENTITY_ARRIVAL_SET THEN

7735:
7736: IF l_debug_level > 0 THEN
7737: oe_debug_pub.add( 'LINE EXISTS WITH THE SHIP SET' , 3 ) ;
7738: END IF;
7739: ELSIF p_request_rec.param3 = oe_schedule_util.OESCH_ENTITY_ARRIVAL_SET THEN
7740: SELECT 1
7741: INTO l_dummy
7742: FROM oe_order_lines_all
7743: WHERE header_id=p_request_rec.param2

Line 7824: := Oe_Schedule_Util.Get_Scheduling_Level(p_header_id,

7820: AND ship_set_id = p_ship_set_id
7821: AND line_id <> p_line_id
7822: AND rownum=1;
7823: l_scheduling_level_code
7824: := Oe_Schedule_Util.Get_Scheduling_Level(p_header_id,
7825: l_line_type_id);
7826: -- Return True if sch level of new line is 4/5 and set line is also 4/5
7827: -- Also return true if line is a active demand line and set line is also
7828: -- an active demand line

Line 7829: IF l_scheduling_level_code= Oe_Schedule_Util.SCH_LEVEL_FOUR OR

7825: l_line_type_id);
7826: -- Return True if sch level of new line is 4/5 and set line is also 4/5
7827: -- Also return true if line is a active demand line and set line is also
7828: -- an active demand line
7829: IF l_scheduling_level_code= Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7830: l_scheduling_level_code = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7831: IF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7832: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7833:

Line 7830: l_scheduling_level_code = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN

7826: -- Return True if sch level of new line is 4/5 and set line is also 4/5
7827: -- Also return true if line is a active demand line and set line is also
7828: -- an active demand line
7829: IF l_scheduling_level_code= Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7830: l_scheduling_level_code = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7831: IF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7832: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7833:
7834: RETURN TRUE;

Line 7831: IF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR

7827: -- Also return true if line is a active demand line and set line is also
7828: -- an active demand line
7829: IF l_scheduling_level_code= Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7830: l_scheduling_level_code = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7831: IF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7832: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7833:
7834: RETURN TRUE;
7835: ELSE

Line 7832: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN

7828: -- an active demand line
7829: IF l_scheduling_level_code= Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7830: l_scheduling_level_code = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7831: IF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7832: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7833:
7834: RETURN TRUE;
7835: ELSE
7836: RETURN FALSE;

Line 7838: ELSIF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR

7834: RETURN TRUE;
7835: ELSE
7836: RETURN FALSE;
7837: END IF;
7838: ELSIF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7839: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7840: RETURN FALSE;
7841: ELSE
7842: RETURN TRUE;

Line 7839: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN

7835: ELSE
7836: RETURN FALSE;
7837: END IF;
7838: ELSIF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7839: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7840: RETURN FALSE;
7841: ELSE
7842: RETURN TRUE;
7843: END IF;

Line 7852: := Oe_Schedule_Util.Get_Scheduling_Level(p_header_id,

7848: AND arrival_set_id = p_arrival_set_id
7849: AND line_id <> p_line_id
7850: AND rownum=1;
7851: l_scheduling_level_code
7852: := Oe_Schedule_Util.Get_Scheduling_Level(p_header_id,
7853: l_line_type_id);
7854:
7855: IF l_scheduling_level_code= Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7856: l_scheduling_level_code = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN

Line 7855: IF l_scheduling_level_code= Oe_Schedule_Util.SCH_LEVEL_FOUR OR

7851: l_scheduling_level_code
7852: := Oe_Schedule_Util.Get_Scheduling_Level(p_header_id,
7853: l_line_type_id);
7854:
7855: IF l_scheduling_level_code= Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7856: l_scheduling_level_code = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7857: IF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7858: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7859:

Line 7856: l_scheduling_level_code = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN

7852: := Oe_Schedule_Util.Get_Scheduling_Level(p_header_id,
7853: l_line_type_id);
7854:
7855: IF l_scheduling_level_code= Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7856: l_scheduling_level_code = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7857: IF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7858: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7859:
7860: RETURN TRUE;

Line 7857: IF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR

7853: l_line_type_id);
7854:
7855: IF l_scheduling_level_code= Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7856: l_scheduling_level_code = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7857: IF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7858: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7859:
7860: RETURN TRUE;
7861: ELSE

Line 7858: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN

7854:
7855: IF l_scheduling_level_code= Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7856: l_scheduling_level_code = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7857: IF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7858: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7859:
7860: RETURN TRUE;
7861: ELSE
7862: RETURN FALSE;

Line 7864: ELSIF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR

7860: RETURN TRUE;
7861: ELSE
7862: RETURN FALSE;
7863: END IF;
7864: ELSIF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7865: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7866: RETURN FALSE;
7867: ELSE
7868: RETURN TRUE;

Line 7865: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN

7861: ELSE
7862: RETURN FALSE;
7863: END IF;
7864: ELSIF p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FOUR OR
7865: p_sch_level = Oe_Schedule_Util.SCH_LEVEL_FIVE THEN
7866: RETURN FALSE;
7867: ELSE
7868: RETURN TRUE;
7869: END IF;