DBA Data[Home] [Help]

APPS.OE_SCHEDULE_UTIL dependencies on OE_LINE_UTIL

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

333: AND MSC_ATP_GLOBAL.GET_APS_VERSION = 10 ) THEN
334:
335: SAVEPOINT insert_mand_comp;
336:
337: -- l_model_line_rec := OE_LINE_UTIL.Query_Row(p_ato_line_id);
338:
339: OE_Line_Util.Query_Row(p_line_id => p_ato_line_id,
340: x_line_rec => l_model_line_rec);
341:

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

335: SAVEPOINT insert_mand_comp;
336:
337: -- l_model_line_rec := OE_LINE_UTIL.Query_Row(p_ato_line_id);
338:
339: OE_Line_Util.Query_Row(p_line_id => p_ato_line_id,
340: x_line_rec => l_model_line_rec);
341:
342: l_st_atp_lead_time :=
343: Get_Lead_Time

Line 7465: ELSIF (OE_Line_Util.Process_Characteristics

7461: RAISE FND_API.G_EXC_ERROR;
7462: END IF;
7463:
7464: /* -- Begin Bug 2794760 -- INVCONV take out OPM code
7465: ELSIF (OE_Line_Util.Process_Characteristics
7466: (p_x_line_rec.inventory_item_id
7467: ,p_x_line_rec.ship_from_org_id
7468: ,l_item_rec) AND
7469: p_x_line_rec.ordered_quantity > p_old_line_rec.ordered_quantity AND

Line 8012: oe_line_util.pre_write

8008: /*----------------------------------------------------------------
8009: PROCEDURE Schedule_line
8010: Description:
8011: This procedure will be called from
8012: oe_line_util.pre_write
8013: **
8014: **
8015:
8016: Parameter:

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

8018:
8019: If the call is being made by process order then it is called as
8020: internal. In all other cases it is external.
8021:
8022: If the value is set to True that means (oe_line_util) it is a
8023: recursive call and pass appropriate value to process and notify.
8024:
8025: This will be set to external from workflow and grp call. If it is set
8026: external execute request then and there.

Line 8120: -- OE_LINE_UTIL.Get_Reserved_Quantity

8116: END IF;
8117: END IF;
8118:
8119: --l_old_line_rec.reserved_quantity :=
8120: -- OE_LINE_UTIL.Get_Reserved_Quantity
8121: -- (p_header_id => l_sales_order_id,
8122: -- p_line_id => p_x_line_rec.line_id,
8123: -- p_org_id => p_x_line_rec.ship_from_org_id);
8124:

Line 8138: -- OE_LINE_UTIL.Get_Reserved_Quantity2

8134: END IF;
8135: END IF;
8136:
8137: --l_old_line_rec.reserved_quantity2 :=
8138: -- OE_LINE_UTIL.Get_Reserved_Quantity2
8139: -- (p_header_id => l_sales_order_id,
8140: -- p_line_id => p_x_line_rec.line_id,
8141: -- p_org_id => p_x_line_rec.ship_from_org_id);
8142:

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

8139: -- (p_header_id => l_sales_order_id,
8140: -- p_line_id => p_x_line_rec.line_id,
8141: -- p_org_id => p_x_line_rec.ship_from_org_id);
8142:
8143: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
8144:
8145: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
8146: ,p_line_id => p_x_line_rec.line_id
8147: --Bug 6335352 ,p_org_id => p_x_line_rec.ship_from_org_id

Line 8145: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

8141: -- p_org_id => p_x_line_rec.ship_from_org_id);
8142:
8143: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
8144:
8145: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
8146: ,p_line_id => p_x_line_rec.line_id
8147: --Bug 6335352 ,p_org_id => p_x_line_rec.ship_from_org_id
8148: ,p_org_id => l_old_line_rec.ship_from_org_id
8149: ,p_order_quantity_uom => l_old_line_rec.order_quantity_uom

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

11657: END IF;
11658:
11659: ELSE /*pre pack H*/
11660: -- Do not process delayed requests if this was a recursive
11661: -- call (e.g. from oe_line_util.pre_write_process)
11662:
11663: IF p_caller = SCH_INTERNAL THEN
11664: l_process_requests := FALSE;
11665: ELSE

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

11937:
11938: IF l_debug_level > 0 THEN
11939: oe_debug_pub.add( 'SHIP_DATE HAS CHANGED ON THE LINE' , 1 ) ;
11940: END IF;
11941: l_src_attr_tbl(1) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;
11942:
11943: OE_Line_Util_Ext.Clear_Dep_And_Default
11944: ( p_src_attr_tbl => l_src_attr_tbl,
11945: p_x_line_rec => p_x_line_rec,

Line 11943: OE_Line_Util_Ext.Clear_Dep_And_Default

11939: oe_debug_pub.add( 'SHIP_DATE HAS CHANGED ON THE LINE' , 1 ) ;
11940: END IF;
11941: l_src_attr_tbl(1) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;
11942:
11943: OE_Line_Util_Ext.Clear_Dep_And_Default
11944: ( p_src_attr_tbl => l_src_attr_tbl,
11945: p_x_line_rec => p_x_line_rec,
11946: p_old_line_rec => p_old_line_rec);
11947: IF l_debug_level > 0 THEN

Line 12015: OE_LINE_UTIL.Log_Scheduling_Requests

12011: ,p_source_document_line_id => p_x_line_rec.source_document_line_id
12012: ,p_order_source_id => p_x_line_rec.order_source_id
12013: ,p_source_document_type_id => p_x_line_rec.source_document_type_id);
12014:
12015: OE_LINE_UTIL.Log_Scheduling_Requests
12016: (p_x_line_rec => p_x_line_rec
12017: ,p_old_line_rec => p_old_line_rec
12018: ,p_caller => p_caller
12019: ,p_order_type_id => l_order_type_id

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

12168: END IF;
12169: END IF; /*l_index is not null check*/
12170:
12171: -- Do not execute delayed request if it is a internal call.
12172: -- call (e.g. from oe_line_util.post_write_process)
12173:
12174: IF p_call_prn THEN
12175:
12176: IF p_caller = SCH_INTERNAL THEN

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

12208: END IF;
12209: ELSE /*pre pack H*/
12210:
12211: -- Do not execute delayed request if it is a internal call.
12212: -- call (e.g. from oe_line_util.post_write_process)
12213:
12214: IF p_call_prn THEN
12215:
12216: IF p_caller = SCH_INTERNAL THEN

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

12642:
12643: IF l_debug_level > 0 THEN
12644: oe_debug_pub.add( 'ENTERING OE_SCHEDULE_UTIL.DELETE_ROW' , 1 ) ;
12645: END IF;
12646: OE_Line_Util.Query_Row(p_line_id => p_line_id,
12647: x_line_rec => l_line_rec);
12648:
12649: /* Fix for bug 2643593, reservations to be removed only for
12650: shippable line */

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

12654: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
12655: (l_line_rec.HEADER_ID);
12656:
12657:
12658: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
12659:
12660: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
12661: ,p_line_id => l_line_rec.line_id
12662: ,p_org_id => l_line_rec.ship_from_org_id

Line 12660: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

12656:
12657:
12658: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
12659:
12660: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
12661: ,p_line_id => l_line_rec.line_id
12662: ,p_org_id => l_line_rec.ship_from_org_id
12663: ,x_reserved_quantity => l_line_rec.reserved_quantity
12664: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2

Line 12668: OE_LINE_UTIL.Get_Reserved_Quantity

12664: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
12665: );
12666:
12667: /*l_line_rec.reserved_quantity :=
12668: OE_LINE_UTIL.Get_Reserved_Quantity
12669: (p_header_id => l_sales_order_id,
12670: p_line_id => l_line_rec.line_id,
12671: p_org_id => l_line_rec.ship_from_org_id);
12672: l_line_rec.reserved_quantity2 := -- INVCONV

Line 12673: OE_LINE_UTIL.Get_Reserved_Quantity2

12669: (p_header_id => l_sales_order_id,
12670: p_line_id => l_line_rec.line_id,
12671: p_org_id => l_line_rec.ship_from_org_id);
12672: l_line_rec.reserved_quantity2 := -- INVCONV
12673: OE_LINE_UTIL.Get_Reserved_Quantity2
12674: (p_header_id => l_sales_order_id,
12675: p_line_id => l_line_rec.line_id,
12676: p_org_id => l_line_rec.ship_from_org_id); */
12677:

Line 13874: of oe_line_util to fix the bug 2913742.

13870: This procedure will be called from OEXVREQB.pls.This procedure will process
13871: the scheduling for the system split records.
13872:
13873: OM will log delayed request named split_schedule from post_line_process
13874: of oe_line_util to fix the bug 2913742.
13875:
13876: From now on split scheduling will not be used for system splits. This API will
13877: take care of scheduling the system split records.
13878:

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

13914: ELSE
13915: -- Standard or independent line.
13916: oe_debug_pub.add('Independent or remnant line',2);
13917:
13918: OE_Line_Util.Query_Row(p_line_id => p_sch_set_tbl(I).entity_id,
13919: x_line_rec => l_line_rec);
13920:
13921: l_line_tbl(I) := l_line_rec;
13922:

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

15771: IF l_debug_level > 0 THEN
15772: oe_debug_pub.add( 'ENTERING CALL MRP ROLLBACK' , 1 ) ;
15773: END IF;
15774:
15775: OE_Line_Util.Query_Row(p_line_id => p_line_id,
15776: x_line_rec => l_old_line_rec);
15777: l_old_line_rec.schedule_action_code := p_schedule_action_code ;
15778: -- l_old_line_rec.schedule_action_code := OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE;
15779: l_new_line_rec := l_old_line_rec;