DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PVT dependencies on OE_LINE_UTIL

Line 736: OE_Line_Util.Query_Rows

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

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

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

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

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

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

2273: i := l_line_tbl.first;
2274:
2275: While i Is Not Null Loop
2276: l_line_rec := l_line_tbl(I);
2277: oe_line_util.Convert_Miss_To_Null(p_x_line_rec =>l_line_rec);
2278: l_line_tbl(I) := l_line_rec;
2279:
2280: -- bug 3439319 added this block instead of NULLing out the resv_qty
2281: Begin

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

2290: IF l_debug_level > 0 THEN
2291: oe_debug_pub.add('l_sales_order_id => ' || l_sales_order_id);
2292: END IF;
2293:
2294: l_line_tbl(I).reserved_quantity := oe_line_util.Get_Reserved_Quantity (
2295: p_header_id => l_sales_order_id,
2296: p_line_id => p_line_tbl(I).line_id,
2297: p_org_id => p_line_tbl(I).org_id);
2298: IF l_debug_level > 0 THEN