DBA Data[Home] [Help]

APPS.OE_LINE_FULLFILL dependencies on OE_LINE_UTIL

Line 858: OE_Line_Util.Lock_Rows

854: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
855: IF l_debug_level > 0 THEN
856: oe_debug_pub.add('mode is record',3) ;
857: END IF;
858: OE_Line_Util.Lock_Rows
859: (p_line_id => p_line_rec.line_id
860: ,x_line_tbl => l_old_line_tbl
861: ,x_return_status => l_return_status
862: );

Line 1078: OE_Line_Util.Lock_Rows

1074:
1075: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1076: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )THEN
1077:
1078: OE_Line_Util.Lock_Rows
1079: (p_line_id => p_line_tbl(l_index).line_id
1080: ,x_line_tbl => l_old_line_tbl
1081: ,x_return_status => l_return_status
1082: );

Line 2124: OE_Line_Util.Lock_Rows

2120: IF nvl(l_top_lines.fulfilled_flag,'N') = 'N' THEN
2121: IF l_debug_level > 0 THEN
2122: oe_debug_pub.add('line is not fulfilled '||l_top_lines.line_id,3) ;
2123: END IF;
2124: OE_Line_Util.Lock_Rows
2125: (p_line_id => l_top_lines.line_id
2126: ,x_line_tbl => l_old_line_tbl
2127: ,x_return_status => l_return_status
2128: );

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

2918:
2919: FOR l_line_set_index IN p_line_set_tbl.FIRST .. p_line_set_tbl.LAST
2920: LOOP
2921:
2922: -- l_line_rec := OE_Line_Util.Query_Row(p_line_set_tbl(l_line_set_index).line_id);
2923: OE_Line_Util.Query_Row(p_line_id => p_line_set_tbl(l_line_set_index).line_id,
2924: x_line_rec => l_line_rec);
2925:
2926: IF NOT l_set_tbl.EXISTS(p_line_set_tbl(l_line_set_index).set_id) THEN

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

2919: FOR l_line_set_index IN p_line_set_tbl.FIRST .. p_line_set_tbl.LAST
2920: LOOP
2921:
2922: -- l_line_rec := OE_Line_Util.Query_Row(p_line_set_tbl(l_line_set_index).line_id);
2923: OE_Line_Util.Query_Row(p_line_id => p_line_set_tbl(l_line_set_index).line_id,
2924: x_line_rec => l_line_rec);
2925:
2926: IF NOT l_set_tbl.EXISTS(p_line_set_tbl(l_line_set_index).set_id) THEN
2927:

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

2985: IF l_debug_level > 0 THEN
2986: oe_debug_pub.add( 'IT IS A CONFIGURATION TOP MODEL ' , 3 ) ;
2987: END IF;
2988:
2989: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);
2990:
2991: SELECT TOP_MODEL_LINE_ID
2992: INTO l_top_model_line_id
2993: FROM OE_ORDER_LINES

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

3281: IF l_debug_level > 0 THEN
3282: oe_debug_pub.add( 'CALLING FLOW STATUS API ' , 3 ) ;
3283: END IF;
3284:
3285: -- l_line_rec := OE_Line_Util.Query_Row(l_line_tbl(l_line_tbl_index));
3286:
3287: /*
3288: SELECT HEADER_ID
3289: INTO l_header_id

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

3446: END IF;
3447:
3448:
3449:
3450: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);
3451: OE_Line_Util.Query_Row(p_line_id => p_line_id,
3452: x_line_rec => l_line_rec);
3453:
3454: OE_MSG_PUB.set_msg_context(

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

3447:
3448:
3449:
3450: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);
3451: OE_Line_Util.Query_Row(p_line_id => p_line_id,
3452: x_line_rec => l_line_rec);
3453:
3454: OE_MSG_PUB.set_msg_context(
3455: p_entity_code => 'LINE'

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

5058:
5059: l_fulfillment_type := G_FULFILL_NO_ACTIVITY;
5060: l_fulfillment_activity := 'NO_ACTIVITY';
5061:
5062: OE_Line_Util.Query_Row(p_line_id => l_ful_set_tbl(l_ful_set_index).line_id,
5063: x_line_rec => l_line_rec);
5064: Fulfill_Line
5065: (
5066: p_line_rec => l_line_rec,

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

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

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

5318: IF l_debug_level > 0 THEN
5319: oe_debug_pub.add( 'CALLING FLOW STATUS API ' , 3 ) ;
5320: END IF;
5321:
5322: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);
5323: /*
5324: SELECT HEADER_ID
5325: INTO l_header_id
5326: FROM OE_ORDER_LINES