DBA Data[Home] [Help]

APPS.OE_SET_UTIL dependencies on OE_SCHEDULE_UTIL

Line 6733: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;

6729:
6730: FOR i in C8 loop
6731: l_child_line_rec:=OE_LINE_UTIL.QUERY_ROW(p_line_id => i.line_id);
6732: IF l_child_line_rec.schedule_status_code is not null THEN
6733: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
6734: ELSE
6735: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE;
6736: END IF;
6737:

Line 6735: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE;

6731: l_child_line_rec:=OE_LINE_UTIL.QUERY_ROW(p_line_id => i.line_id);
6732: IF l_child_line_rec.schedule_status_code is not null THEN
6733: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
6734: ELSE
6735: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE;
6736: END IF;
6737:
6738: IF OE_QUOTE_UTIL.G_COMPLETE_NEG='Y'
6739: THEN

Line 6748: l_entity_type := OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET;

6744:
6745: IF l_set_type='ARRIVAL_SET'
6746: AND i.arrival_set_id<>l_old_set_id THEN
6747:
6748: l_entity_type := OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET;
6749:
6750: IF l_debug_level > 0 THEN
6751: oe_debug_pub.add( 'new arrival set id id'||i.arrival_set_id);
6752: END IF;

Line 6791: l_entity_type := OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET;

6787: END IF;
6788: ELSIF l_set_type='SHIP_SET'
6789: AND i.ship_set_id<>l_old_set_id THEN
6790:
6791: l_entity_type := OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET;
6792:
6793: IF l_debug_level > 0 THEN
6794: oe_debug_pub.add( 'new ship set id id'||i.ship_set_id);
6795: END IF;

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

7242: oe_debug_pub.add( 'SET ID'||p_request_rec.param1 , 3 ) ;
7243: END IF;
7244: x_return_status := FND_API.G_RET_STS_SUCCESS;
7245: BEGIN
7246: IF p_request_rec.param3 = oe_schedule_util.OESCH_ENTITY_SHIP_SET THEN
7247: SELECT 1
7248: INTO l_dummy
7249: FROM oe_order_lines_all
7250: WHERE header_id=p_request_rec.param2

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

7253:
7254: IF l_debug_level > 0 THEN
7255: oe_debug_pub.add( 'LINE EXISTS WITH THE SHIP SET' , 3 ) ;
7256: END IF;
7257: ELSIF p_request_rec.param3 = oe_schedule_util.OESCH_ENTITY_ARRIVAL_SET THEN
7258: SELECT 1
7259: INTO l_dummy
7260: FROM oe_order_lines_all
7261: WHERE header_id=p_request_rec.param2