DBA Data[Home] [Help]

APPS.OE_LINE_FULLFILL dependencies on OE_LINE_UTIL

Line 879: OE_Line_Util.Lock_Rows

875: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
876: IF l_debug_level > 0 THEN
877: oe_debug_pub.add('mode is record',3) ;
878: END IF;
879: OE_Line_Util.Lock_Rows
880: (p_line_id => p_line_rec.line_id
881: ,x_line_tbl => l_old_line_tbl
882: ,x_return_status => l_return_status
883: );

Line 1121: OE_Line_Util.Lock_Rows

1117:
1118: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1119: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )THEN
1120:
1121: OE_Line_Util.Lock_Rows
1122: (p_line_id => p_line_tbl(l_index).line_id
1123: ,x_line_tbl => l_old_line_tbl
1124: ,x_return_status => l_return_status
1125: );

Line 2217: OE_Line_Util.Lock_Rows

2213: IF nvl(l_top_lines.fulfilled_flag,'N') = 'N' THEN
2214: IF l_debug_level > 0 THEN
2215: oe_debug_pub.add('line is not fulfilled '||l_top_lines.line_id,3) ;
2216: END IF;
2217: OE_Line_Util.Lock_Rows
2218: (p_line_id => l_top_lines.line_id
2219: ,x_line_tbl => l_old_line_tbl
2220: ,x_return_status => l_return_status
2221: );

Line 2746: If oe_line_util.Is_Subscription_Service_Line(l_fulfill_tbl(l_fulfill_index).line_id)

2742: l_fulfill_tbl(l_fulfill_index).actual_shipment_date := l_line_tbl(l_line_index).actual_shipment_date;
2743: l_fulfill_tbl(l_fulfill_index).order_firmed_date := l_line_tbl(l_line_index).order_firmed_date;
2744: -- end of changes for AFD
2745: -- sol_ord_er #16014165
2746: If oe_line_util.Is_Subscription_Service_Line(l_fulfill_tbl(l_fulfill_index).line_id)
2747: THEN
2748: l_fulfill_tbl(l_fulfill_index).subscription_enable_flag := 'Y';
2749: End If;
2750: -- sol_ord_er #16014165 end

Line 2803: If oe_line_util.Is_Subscription_Service_Line(l_fulfill_tbl(l_fulfill_index).line_id)

2799: l_fulfill_tbl(l_fulfill_index).actual_shipment_date := l_service_tbl(l_service_index).actual_shipment_date;
2800: l_fulfill_tbl(l_fulfill_index).order_firmed_date := l_service_tbl(l_service_index).order_firmed_date;
2801: -- end changes for AFD
2802: -- sol_ord_er #16014165
2803: If oe_line_util.Is_Subscription_Service_Line(l_fulfill_tbl(l_fulfill_index).line_id)
2804: THEN
2805: l_fulfill_tbl(l_fulfill_index).subscription_enable_flag := 'Y';
2806: End If;
2807: -- sol_ord_er #16014165 end

Line 3076: -- l_line_rec := OE_Line_Util.Query_Row(p_line_set_tbl(l_line_set_index).line_id);

3072:
3073: FOR l_line_set_index IN p_line_set_tbl.FIRST .. p_line_set_tbl.LAST
3074: LOOP
3075:
3076: -- l_line_rec := OE_Line_Util.Query_Row(p_line_set_tbl(l_line_set_index).line_id);
3077: OE_Line_Util.Query_Row(p_line_id => p_line_set_tbl(l_line_set_index).line_id,
3078: x_line_rec => l_line_rec);
3079: l_set_id_mod :=
3080: MOD(p_line_set_tbl(l_line_set_index).set_id,G_BINARY_LIMIT);--7827727

Line 3077: OE_Line_Util.Query_Row(p_line_id => p_line_set_tbl(l_line_set_index).line_id,

3073: FOR l_line_set_index IN p_line_set_tbl.FIRST .. p_line_set_tbl.LAST
3074: LOOP
3075:
3076: -- l_line_rec := OE_Line_Util.Query_Row(p_line_set_tbl(l_line_set_index).line_id);
3077: OE_Line_Util.Query_Row(p_line_id => p_line_set_tbl(l_line_set_index).line_id,
3078: x_line_rec => l_line_rec);
3079: l_set_id_mod :=
3080: MOD(p_line_set_tbl(l_line_set_index).set_id,G_BINARY_LIMIT);--7827727
3081:

Line 3153: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);

3149: IF l_debug_level > 0 THEN
3150: oe_debug_pub.add( 'IT IS A CONFIGURATION TOP MODEL ' , 3 ) ;
3151: END IF;
3152:
3153: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);
3154:
3155: SELECT TOP_MODEL_LINE_ID
3156: INTO l_top_model_line_id
3157: FROM OE_ORDER_LINES

Line 3458: -- l_line_rec := OE_Line_Util.Query_Row(l_line_tbl(l_line_tbl_index));

3454: IF l_debug_level > 0 THEN
3455: oe_debug_pub.add( 'CALLING FLOW STATUS API ' , 3 ) ;
3456: END IF;
3457:
3458: -- l_line_rec := OE_Line_Util.Query_Row(l_line_tbl(l_line_tbl_index));
3459:
3460: /*
3461: SELECT HEADER_ID
3462: INTO l_header_id

Line 3630: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);

3626: END IF;
3627:
3628:
3629:
3630: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);
3631: OE_Line_Util.Query_Row(p_line_id => p_line_id,
3632: x_line_rec => l_line_rec);
3633:
3634: OE_MSG_PUB.set_msg_context(

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

3627:
3628:
3629:
3630: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);
3631: OE_Line_Util.Query_Row(p_line_id => p_line_id,
3632: x_line_rec => l_line_rec);
3633:
3634: OE_MSG_PUB.set_msg_context(
3635: p_entity_code => 'LINE'

Line 5297: OE_Line_Util.Query_Row(p_line_id => l_ful_set_tbl(l_ful_set_index).line_id,

5293:
5294: l_fulfillment_type := G_FULFILL_NO_ACTIVITY;
5295: l_fulfillment_activity := 'NO_ACTIVITY';
5296:
5297: OE_Line_Util.Query_Row(p_line_id => l_ful_set_tbl(l_ful_set_index).line_id,
5298: x_line_rec => l_line_rec);
5299: Fulfill_Line
5300: (
5301: p_line_rec => l_line_rec,

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

5535:
5536: l_fulfillment_type := G_FULFILL_NO_ACTIVITY;
5537: l_fulfillment_activity := 'NO_ACTIVITY';
5538:
5539: OE_Line_Util.Query_Row(p_line_id => p_line_id,
5540: x_line_rec => l_line_rec);
5541:
5542: Fulfill_Line
5543: (

Line 5563: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);

5559: IF l_debug_level > 0 THEN
5560: oe_debug_pub.add( 'CALLING FLOW STATUS API ' , 3 ) ;
5561: END IF;
5562:
5563: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);
5564: /*
5565: SELECT HEADER_ID
5566: INTO l_header_id
5567: FROM OE_ORDER_LINES