DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PVT dependencies on OE_LINE_UTIL

Line 735: OE_Line_Util.Query_Rows

731: -- --------------------------------------------------------------------
732: */
733: l_booked_shipped := 'Y';
734: /*
735: OE_Line_Util.Query_Rows
736: ( p_header_id => l_header_rec.header_id
737: , x_line_tbl => l_line_tbl
738: );
739: */

Line 804: oe_line_util.Convert_Miss_To_Null(p_x_line_rec =>l_line_rec);

800:
801: While i is not null loop
802: /* Bug 2416561 : Calling the Convert_Miss_To_Null for the id records */
803: l_line_rec := l_line_tbl(I);
804: oe_line_util.Convert_Miss_To_Null(p_x_line_rec =>l_line_rec);
805: l_line_tbl(I) := l_line_rec;
806:
807: -- bug 3439319 added this block instead of NULLing out the resv_qty
808: Begin

Line 840: l_line_tbl(I).reserved_quantity := oe_line_util.Get_Reserved_Quantity (

836: IF l_debug_level > 0 THEN
837: oe_debug_pub.add('l_sales_order_id => ' || l_sales_order_id);
838: END IF;
839:
840: l_line_tbl(I).reserved_quantity := oe_line_util.Get_Reserved_Quantity (
841: p_header_id => l_sales_order_id,
842: p_line_id => p_line_tbl(I).line_id,
843: p_org_id => p_line_tbl(I).org_id);
844: IF l_debug_level > 0 THEN

Line 2247: oe_line_util.Convert_Miss_To_Null(p_x_line_rec =>l_line_rec);

2243: i := l_line_tbl.first;
2244:
2245: While i Is Not Null Loop
2246: l_line_rec := l_line_tbl(I);
2247: oe_line_util.Convert_Miss_To_Null(p_x_line_rec =>l_line_rec);
2248: l_line_tbl(I) := l_line_rec;
2249:
2250: -- bug 3439319 added this block instead of NULLing out the resv_qty
2251: Begin

Line 2264: l_line_tbl(I).reserved_quantity := oe_line_util.Get_Reserved_Quantity (

2260: IF l_debug_level > 0 THEN
2261: oe_debug_pub.add('l_sales_order_id => ' || l_sales_order_id);
2262: END IF;
2263:
2264: l_line_tbl(I).reserved_quantity := oe_line_util.Get_Reserved_Quantity (
2265: p_header_id => l_sales_order_id,
2266: p_line_id => p_line_tbl(I).line_id,
2267: p_org_id => p_line_tbl(I).org_id);
2268: IF l_debug_level > 0 THEN