eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_SCHEDULE_UTIL dependencies on OE_LINE_UTIL

Line 362: -- l_model_line_rec := OE_LINE_UTIL.Query_Row(p_ato_line_id);

358: AND MSC_ATP_GLOBAL.GET_APS_VERSION = 10 ) THEN
359:
360: SAVEPOINT insert_mand_comp;
361:
362: -- l_model_line_rec := OE_LINE_UTIL.Query_Row(p_ato_line_id);
363:
364: OE_Line_Util.Query_Row(p_line_id => p_ato_line_id,
365: x_line_rec => l_model_line_rec);
366:

Line 364: OE_Line_Util.Query_Row(p_line_id => p_ato_line_id,

360: SAVEPOINT insert_mand_comp;
361:
362: -- l_model_line_rec := OE_LINE_UTIL.Query_Row(p_ato_line_id);
363:
364: OE_Line_Util.Query_Row(p_line_id => p_ato_line_id,
365: x_line_rec => l_model_line_rec);
366:
367: l_st_atp_lead_time :=
368: Get_Lead_Time

Line 2931: oe_line_util.query_row

2927: END IF;
2928: */
2929:
2930: --query the row again
2931: oe_line_util.query_row
2932: (p_line_id => l_split_line_tbl(1).line_id
2933: ,x_line_rec => l_split_line_tbl(1)
2934: );
2935:

Line 9354: oe_line_util.pre_write

9350: /*----------------------------------------------------------------
9351: PROCEDURE Schedule_line
9352: Description:
9353: This procedure will be called from
9354: oe_line_util.pre_write
9355: **
9356: **
9357:
9358: Parameter:

Line 9364: If the value is set to True that means (oe_line_util) it is a

9360:
9361: If the call is being made by process order then it is called as
9362: internal. In all other cases it is external.
9363:
9364: If the value is set to True that means (oe_line_util) it is a
9365: recursive call and pass appropriate value to process and notify.
9366:
9367: This will be set to external from workflow and grp call. If it is set
9368: external execute request then and there.

Line 9467: -- OE_LINE_UTIL.Get_Reserved_Quantity

9463: END IF;
9464: END IF;
9465:
9466: --l_old_line_rec.reserved_quantity :=
9467: -- OE_LINE_UTIL.Get_Reserved_Quantity
9468: -- (p_header_id => l_sales_order_id,
9469: -- p_line_id => p_x_line_rec.line_id,
9470: -- p_org_id => p_x_line_rec.ship_from_org_id);
9471:

Line 9485: -- OE_LINE_UTIL.Get_Reserved_Quantity2

9481: END IF;
9482: END IF;
9483:
9484: --l_old_line_rec.reserved_quantity2 :=
9485: -- OE_LINE_UTIL.Get_Reserved_Quantity2
9486: -- (p_header_id => l_sales_order_id,
9487: -- p_line_id => p_x_line_rec.line_id,
9488: -- p_org_id => p_x_line_rec.ship_from_org_id);
9489:

Line 9490: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

9486: -- (p_header_id => l_sales_order_id,
9487: -- p_line_id => p_x_line_rec.line_id,
9488: -- p_org_id => p_x_line_rec.ship_from_org_id);
9489:
9490: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
9491:
9492: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
9493: ,p_line_id => p_x_line_rec.line_id
9494: --Bug 6335352 ,p_org_id => p_x_line_rec.ship_from_org_id

Line 9492: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

9488: -- p_org_id => p_x_line_rec.ship_from_org_id);
9489:
9490: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
9491:
9492: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
9493: ,p_line_id => p_x_line_rec.line_id
9494: --Bug 6335352 ,p_org_id => p_x_line_rec.ship_from_org_id
9495: ,p_org_id => l_old_line_rec.ship_from_org_id
9496: ,p_order_quantity_uom => l_old_line_rec.order_quantity_uom

Line 13268: -- call (e.g. from oe_line_util.pre_write_process)

13264: END IF;
13265:
13266: ELSE /*pre pack H*/
13267: -- Do not process delayed requests if this was a recursive
13268: -- call (e.g. from oe_line_util.pre_write_process)
13269:
13270: IF p_caller = SCH_INTERNAL THEN
13271: l_process_requests := FALSE;
13272: ELSE

Line 13548: l_src_attr_tbl(1) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;

13544:
13545: IF l_debug_level > 0 THEN
13546: oe_debug_pub.add( 'SHIP_DATE HAS CHANGED ON THE LINE' , 1 ) ;
13547: END IF;
13548: l_src_attr_tbl(1) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;
13549:
13550: OE_Line_Util_Ext.Clear_Dep_And_Default
13551: ( p_src_attr_tbl => l_src_attr_tbl,
13552: p_x_line_rec => p_x_line_rec,

Line 13550: OE_Line_Util_Ext.Clear_Dep_And_Default

13546: oe_debug_pub.add( 'SHIP_DATE HAS CHANGED ON THE LINE' , 1 ) ;
13547: END IF;
13548: l_src_attr_tbl(1) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;
13549:
13550: OE_Line_Util_Ext.Clear_Dep_And_Default
13551: ( p_src_attr_tbl => l_src_attr_tbl,
13552: p_x_line_rec => p_x_line_rec,
13553: p_old_line_rec => p_old_line_rec);
13554: IF l_debug_level > 0 THEN

Line 13622: OE_LINE_UTIL.Log_Scheduling_Requests

13618: ,p_source_document_line_id => p_x_line_rec.source_document_line_id
13619: ,p_order_source_id => p_x_line_rec.order_source_id
13620: ,p_source_document_type_id => p_x_line_rec.source_document_type_id);
13621:
13622: OE_LINE_UTIL.Log_Scheduling_Requests
13623: (p_x_line_rec => p_x_line_rec
13624: ,p_old_line_rec => p_old_line_rec
13625: ,p_caller => p_caller
13626: ,p_order_type_id => l_order_type_id

Line 13779: -- call (e.g. from oe_line_util.post_write_process)

13775: END IF;
13776: END IF; /*l_index is not null check*/
13777:
13778: -- Do not execute delayed request if it is a internal call.
13779: -- call (e.g. from oe_line_util.post_write_process)
13780:
13781: IF p_call_prn THEN
13782:
13783: IF p_caller = SCH_INTERNAL THEN

Line 13819: -- call (e.g. from oe_line_util.post_write_process)

13815: END IF;
13816: ELSE /*pre pack H*/
13817:
13818: -- Do not execute delayed request if it is a internal call.
13819: -- call (e.g. from oe_line_util.post_write_process)
13820:
13821: IF p_call_prn THEN
13822:
13823: IF p_caller = SCH_INTERNAL THEN

Line 14489: OE_Line_Util.Query_Row(p_line_id => p_line_id,

14485:
14486: IF l_debug_level > 0 THEN
14487: oe_debug_pub.add( 'ENTERING OE_SCHEDULE_UTIL.DELETE_ROW' , 1 ) ;
14488: END IF;
14489: OE_Line_Util.Query_Row(p_line_id => p_line_id,
14490: x_line_rec => l_line_rec);
14491:
14492: /* Fix for bug 2643593, reservations to be removed only for
14493: shippable line */

Line 14501: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

14497: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
14498: (l_line_rec.HEADER_ID);
14499:
14500:
14501: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
14502:
14503: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
14504: ,p_line_id => l_line_rec.line_id
14505: ,p_org_id => l_line_rec.ship_from_org_id

Line 14503: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

14499:
14500:
14501: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
14502:
14503: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
14504: ,p_line_id => l_line_rec.line_id
14505: ,p_org_id => l_line_rec.ship_from_org_id
14506: ,x_reserved_quantity => l_line_rec.reserved_quantity
14507: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2

Line 14511: OE_LINE_UTIL.Get_Reserved_Quantity

14507: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
14508: );
14509:
14510: /*l_line_rec.reserved_quantity :=
14511: OE_LINE_UTIL.Get_Reserved_Quantity
14512: (p_header_id => l_sales_order_id,
14513: p_line_id => l_line_rec.line_id,
14514: p_org_id => l_line_rec.ship_from_org_id);
14515: l_line_rec.reserved_quantity2 := -- INVCONV

Line 14516: OE_LINE_UTIL.Get_Reserved_Quantity2

14512: (p_header_id => l_sales_order_id,
14513: p_line_id => l_line_rec.line_id,
14514: p_org_id => l_line_rec.ship_from_org_id);
14515: l_line_rec.reserved_quantity2 := -- INVCONV
14516: OE_LINE_UTIL.Get_Reserved_Quantity2
14517: (p_header_id => l_sales_order_id,
14518: p_line_id => l_line_rec.line_id,
14519: p_org_id => l_line_rec.ship_from_org_id); */
14520:

Line 14965: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

14961: ,l_line_tbl(K).ship_from_org_id) AND
14962: NVL(p_x_line_tbl(I).SPLIT_SHIP_FROM,'N') = 'Y' THEN -- 10278858
14963: -- Unreserve the line as warehouse being chabged and reservation is there.
14964: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(l_line_tbl(K).HEADER_ID);
14965: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
14966: ,p_line_id => l_line_tbl(K).line_id
14967: ,p_org_id => l_line_tbl(K).ship_from_org_id
14968: ,p_order_quantity_uom => l_line_tbl(K).order_quantity_uom
14969: ,p_inventory_item_id => l_line_tbl(K).inventory_item_id --bug 16434168

Line 15041: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

15037: ,l_line_tbl(K).ship_from_org_id) AND
15038: NVL(p_x_line_tbl(I).SPLIT_SHIP_FROM,'N') = 'Y' THEN -- 10278858
15039: -- Unreserve the line as warehouse being chabged and reservation is there.
15040: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(l_line_tbl(K).HEADER_ID);
15041: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
15042: ,p_line_id => l_line_tbl(K).line_id
15043: ,p_org_id => l_line_tbl(K).ship_from_org_id
15044: ,p_order_quantity_uom => l_line_tbl(K).order_quantity_uom
15045: ,p_inventory_item_id => l_line_tbl(K).inventory_item_id --bug 16434168

Line 15113: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

15109: NOT OE_GLOBALS.EQUAL(p_x_line_tbl(I).ship_from_org_id
15110: ,l_line_tbl(K).ship_from_org_id)THEN
15111: -- Unreserve the line as warehouse being chabged and reservation is there.
15112: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(l_line_tbl(K).HEADER_ID);
15113: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
15114: ,p_line_id => l_line_tbl(K).line_id
15115: ,p_org_id => l_line_tbl(K).ship_from_org_id
15116: ,p_order_quantity_uom => l_line_tbl(K).order_quantity_uom
15117: ,x_reserved_quantity => l_line_tbl(K).reserved_quantity

Line 15197: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

15193: NOT OE_GLOBALS.EQUAL(p_x_line_tbl(I).ship_from_org_id
15194: ,l_line_tbl(K).ship_from_org_id)THEN
15195: -- Unreserve the line as warehouse being chabged and reservation is there.
15196: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(l_line_tbl(K).HEADER_ID);
15197: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
15198: ,p_line_id => l_line_tbl(K).line_id
15199: ,p_org_id => l_line_tbl(K).ship_from_org_id
15200: ,p_order_quantity_uom => l_line_tbl(K).order_quantity_uom
15201: ,x_reserved_quantity => l_line_tbl(K).reserved_quantity

Line 15305: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

15301: IF l_line_tbl(J).schedule_ship_date is NOT NULL then --9662817
15302: -- AND l_line_tbl(J).operation = oe_globals.g_opr_update THEN
15303: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(l_line_tbl(J).HEADER_ID);
15304: BEGIN
15305: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
15306: ,p_line_id => l_line_tbl(J).line_id
15307: ,p_org_id => l_line_tbl(J).ship_from_org_id
15308: ,p_order_quantity_uom => l_line_tbl(J).order_quantity_uom
15309: ,p_inventory_item_id => l_line_tbl(J).inventory_item_id --bug 16434168

Line 16347: of oe_line_util to fix the bug 2913742.

16343: This procedure will be called from OEXVREQB.pls.This procedure will process
16344: the scheduling for the system split records.
16345:
16346: OM will log delayed request named split_schedule from post_line_process
16347: of oe_line_util to fix the bug 2913742.
16348:
16349: From now on split scheduling will not be used for system splits. This API will
16350: take care of scheduling the system split records.
16351:

Line 16393: OE_Line_Util.Query_Row(p_line_id => p_sch_set_tbl(I).entity_id,

16389: ELSE
16390: -- Standard or independent line.
16391: oe_debug_pub.add('Independent or remnant line',2);
16392:
16393: OE_Line_Util.Query_Row(p_line_id => p_sch_set_tbl(I).entity_id,
16394: x_line_rec => l_line_rec);
16395:
16396: l_line_tbl(I) := l_line_rec;
16397:

Line 17205: Becasue if we send 0.83333 DZ, then reserved qty displayed in sales order form will be 9.99996 Ea.(refer oe_line_util.get_reserved_qtys)

17201: This will avoid rounding off issue. for example <>..
17202: suppose secondary_reservation_quantity/secondary_uom_code is 10/EA
17203: and reservation_uom_code is DZ.
17204: So instead of converting 10 Ez to 0.83333 DZ , we will send Reservation Qty as 10 Ea.
17205: Becasue if we send 0.83333 DZ, then reserved qty displayed in sales order form will be 9.99996 Ea.(refer oe_line_util.get_reserved_qtys)
17206: So by sending Reservation Qty as 10 Ea., reserved qty seen in sales order will be 10 Ea.
17207: */
17208: --Ignore above note., check issue 3 on bug 16434168
17209: --start changes for bug 16434168

Line 18324: OE_Line_Util.Query_Row(p_line_id => p_line_id,

18320: IF l_debug_level > 0 THEN
18321: oe_debug_pub.add( 'ENTERING CALL MRP ROLLBACK' , 1 ) ;
18322: END IF;
18323:
18324: OE_Line_Util.Query_Row(p_line_id => p_line_id,
18325: x_line_rec => l_old_line_rec);
18326: l_old_line_rec.schedule_action_code := p_schedule_action_code ;
18327: -- l_old_line_rec.schedule_action_code := OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE;
18328: l_old_line_rec.inventory_item_id := p_item_id;

Line 18439: OE_Line_Util.Query_Row(p_line_id => p_line_id,

18435: IF l_debug_level > 0 THEN
18436: oe_debug_pub.add( 'ENTERING CALL MRP ROLLBACK' , 1 ) ;
18437: END IF;
18438:
18439: OE_Line_Util.Query_Row(p_line_id => p_line_id,
18440: x_line_rec => l_old_line_rec);
18441: l_old_line_rec.schedule_action_code := p_schedule_action_code ;
18442: -- l_old_line_rec.schedule_action_code := OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE;
18443: l_new_line_rec := l_old_line_rec;

Line 18586: --using OE_LINE_UTIL.QUERY_ROW instead of following.

18582: BEGIN
18583: oe_debug_pub.add( '6663462 : in schedule_delayed_lines ');
18584:
18585: --Bug 8652339 : Initialize l_line_tbl from OE_ORDER_LINES_ALL table
18586: --using OE_LINE_UTIL.QUERY_ROW instead of following.
18587: --l_line_tbl := OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl;
18588: for j in 1..OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl.count loop
18589:
18590: BEGIN

Line 18592: oe_line_util.query_row(p_line_id => OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl(j).line_id

18588: for j in 1..OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl.count loop
18589:
18590: BEGIN
18591:
18592: oe_line_util.query_row(p_line_id => OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl(j).line_id
18593: ,x_line_rec => l_line_rec
18594: );
18595: i := i + 1 ;
18596: l_line_tbl(i) := l_line_rec;