APPS.OE_ADV_PRICE_PVT dependencies on OE_ORDER_LINES_ALL

Line 1002: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;

998: )
999: IS
1000: l_line_rec Oe_Order_Pub.line_rec_type := px_line_rec;
1001: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1002: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1003: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1004: l_pricing_event varchar2(30);
1005: l_return_status varchar2(1);
1006: --

Line 1003: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;

999: IS
1000: l_line_rec Oe_Order_Pub.line_rec_type := px_line_rec;
1001: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1002: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1003: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1004: l_pricing_event varchar2(30);
1005: l_return_status varchar2(1);
1006: --
1007: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1315: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;

1311: E_CLOSED_LINE Exception;
1312: --
1313: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1314: --
1315: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;
1316: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;
1317: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1318: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1319: Begin

Line 1316: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;

1312: --
1313: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1314: --
1315: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;
1316: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;
1317: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1318: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1319: Begin
1320: IF l_debug_level > 0 THEN

Line 1317: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;

1313: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1314: --
1315: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;
1316: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;
1317: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1318: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1319: Begin
1320: IF l_debug_level > 0 THEN
1321: oe_debug_pub.add( 'ENTERING PRG_LINES' ) ;

Line 1318: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;

1314: --
1315: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;
1316: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;
1317: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1318: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1319: Begin
1320: IF l_debug_level > 0 THEN
1321: oe_debug_pub.add( 'ENTERING PRG_LINES' ) ;
1322: END IF;

Line 1731: from oe_order_lines_all

1727: into l_order_source_id, l_orig_sys_document_ref,
1728: l_orig_sys_line_ref, l_orig_sys_shipment_ref,
1729: l_change_sequence, l_source_document_type_id,
1730: l_source_document_id, l_source_document_line_id
1731: from oe_order_lines_all
1732: where line_id = l_line_id;
1733: EXCEPTION
1734: WHEN NO_DATA_FOUND THEN
1735: IF l_debug_level > 0 THEN