DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on OE_SCHEDULE_UTIL

Line 4237: l_scheduling_level_code := Oe_Schedule_Util.Get_Scheduling_Level(p_line_rec.header_id,

4233: OR P_line_rec.arrival_set_id is not null) THEN -- 2527722
4234: IF l_debug_level > 0 then
4235: oe_debug_pub.add('Checking the level...',1);
4236: END IF;
4237: l_scheduling_level_code := Oe_Schedule_Util.Get_Scheduling_Level(p_line_rec.header_id,
4238: p_line_rec.line_type_id);
4239: l_line_type :=nvl(Oe_Schedule_Util.sch_cached_line_type ,'0');
4240: -- Any item other than Standard can not have level - four or five
4241: IF (l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR

Line 4239: l_line_type :=nvl(Oe_Schedule_Util.sch_cached_line_type ,'0');

4235: oe_debug_pub.add('Checking the level...',1);
4236: END IF;
4237: l_scheduling_level_code := Oe_Schedule_Util.Get_Scheduling_Level(p_line_rec.header_id,
4238: p_line_rec.line_type_id);
4239: l_line_type :=nvl(Oe_Schedule_Util.sch_cached_line_type ,'0');
4240: -- Any item other than Standard can not have level - four or five
4241: IF (l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR
4242: OR l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE) THEN
4243:

Line 4241: IF (l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR

4237: l_scheduling_level_code := Oe_Schedule_Util.Get_Scheduling_Level(p_line_rec.header_id,
4238: p_line_rec.line_type_id);
4239: l_line_type :=nvl(Oe_Schedule_Util.sch_cached_line_type ,'0');
4240: -- Any item other than Standard can not have level - four or five
4241: IF (l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR
4242: OR l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE) THEN
4243:
4244: -- Standalone
4245: -- Allow Inactive Demand lines with SCH level as 4 or 5 to a set

Line 4242: OR l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE) THEN

4238: p_line_rec.line_type_id);
4239: l_line_type :=nvl(Oe_Schedule_Util.sch_cached_line_type ,'0');
4240: -- Any item other than Standard can not have level - four or five
4241: IF (l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR
4242: OR l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE) THEN
4243:
4244: -- Standalone
4245: -- Allow Inactive Demand lines with SCH level as 4 or 5 to a set
4246: -- Active Demand lines with other sch levels will not be allowed to a Inactive Demand set and vice versa.

Line 5238: l_order_date_type_code := NVL(OE_SCHEDULE_UTIL.Get_Date_Type(

5234: END IF;
5235:
5236: -- Added Code for Enhanced Project Validation and Controls.
5237:
5238: l_order_date_type_code := NVL(OE_SCHEDULE_UTIL.Get_Date_Type(
5239: p_line_rec.header_id), 'SHIP');
5240:
5241:
5242: IF l_order_date_type_code = 'SHIP' THEN