APPS.OE_SPLIT_UTIL dependencies on OE_SCHEDULE_UTIL

Line 1474: l_order_date_type_code := NVL(oe_schedule_util.Get_Date_Type(l_option_line.header_id),'SHIP');

1470: IF l_option_line.schedule_ship_date IS NOT NULL
1471: --AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.request_date
1472: -- ,l_line_rec.request_date)
1473: AND NVL(OE_SYS_PARAMETERS.value('RESCHEDULE_REQUEST_DATE_FLAG'),'Y') = 'Y' THEN -- 12833832
1474: l_order_date_type_code := NVL(oe_schedule_util.Get_Date_Type(l_option_line.header_id),'SHIP');
1475: IF l_order_date_type_code = 'SHIP' THEN
1476: -- Its a scheduled line. Reschedule with new date
1477: l_option_line.schedule_ship_date := l_option_line.request_date;
1478: ELSE

Line 1772: l_order_date_type_code := NVL(oe_schedule_util.Get_Date_Type(l_line_rec.header_id),'SHIP');

1768: AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.request_date
1769: ,l_line_rec.request_date)
1770: bug 13954474*/
1771: AND NVL(OE_SYS_PARAMETERS.value('RESCHEDULE_REQUEST_DATE_FLAG'),'Y') = 'Y' THEN -- 12833832
1772: l_order_date_type_code := NVL(oe_schedule_util.Get_Date_Type(l_line_rec.header_id),'SHIP');
1773: IF l_order_date_type_code = 'SHIP' THEN
1774: -- Its a scheduled line. Reschedule with new date
1775: l_line_rec.schedule_ship_date := p_x_line_rec.request_date;
1776: ELSE

Line 2053: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(l_line_rec.HEADER_ID);

2049: -- Unreserve the line if warehouse being chabged and reservation is there.
2050: IF NOT OE_GLOBALS.EQUAL(l_line_rec.ship_from_org_id, l_line_tbl(I).ship_from_org_id) AND
2051: l_line_rec.schedule_ship_date is NOT NULL AND
2052: NVL(l_line_tbl(I).SPLIT_SHIP_FROM,'N') ='Y' THEN -- 10338643
2053: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(l_line_rec.HEADER_ID);
2054: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2055: ,p_line_id => l_line_rec.line_id
2056: ,p_org_id => l_line_rec.ship_from_org_id
2057: ,p_order_quantity_uom => l_line_rec.order_quantity_uom

Line 2063: OE_SCHEDULE_UTIL.Unreserve_Line

2059: ,x_reserved_quantity => l_line_rec.reserved_quantity
2060: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
2061: );
2062: IF l_line_rec.reserved_quantity is not null THEN
2063: OE_SCHEDULE_UTIL.Unreserve_Line
2064: (p_line_rec => l_line_rec,
2065: p_quantity_to_unreserve => l_line_rec.reserved_quantity,
2066: p_quantity2_to_unreserve => l_line_rec.reserved_quantity2 , -- INVCONV
2067: x_return_status => l_return_status);

Line 2068: oe_schedule_util.oe_split_rsv_tbl(MOD(l_line_rec.line_id,G_BINARY_LIMIT)).line_id :=l_line_rec.line_id;

2064: (p_line_rec => l_line_rec,
2065: p_quantity_to_unreserve => l_line_rec.reserved_quantity,
2066: p_quantity2_to_unreserve => l_line_rec.reserved_quantity2 , -- INVCONV
2067: x_return_status => l_return_status);
2068: oe_schedule_util.oe_split_rsv_tbl(MOD(l_line_rec.line_id,G_BINARY_LIMIT)).line_id :=l_line_rec.line_id;
2069: END IF;
2070:
2071: END IF;
2072: IF l_line_rec.schedule_ship_date is NOT NULL AND

Line 2076: l_order_date_type_code := NVL(oe_schedule_util.Get_Date_Type(l_line_rec.header_id),'SHIP');

2072: IF l_line_rec.schedule_ship_date is NOT NULL AND
2073: NOT OE_GLOBALS.EQUAL(l_line_rec.request_date, l_line_tbl(I).request_date) AND
2074: NVL(l_line_tbl(I).SPLIT_REQUEST_DATE,'N') ='Y' AND -- 10338643
2075: NVL(OE_SYS_PARAMETERS.value('RESCHEDULE_REQUEST_DATE_FLAG'),'Y') = 'Y' THEN -- 12833832
2076: l_order_date_type_code := NVL(oe_schedule_util.Get_Date_Type(l_line_rec.header_id),'SHIP');
2077: IF l_order_date_type_code = 'SHIP' THEN
2078: l_sch_tbl(l_sch_count).schedule_ship_date := l_line_tbl(I).request_date;
2079: ELSE
2080: l_sch_tbl(l_sch_count).schedule_arrival_date := l_line_tbl(I).request_date;