eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ADV_PRICE_PVT dependencies on OE_ORDER_LINES_ALL

Line 1289: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;

1285: )
1286: IS
1287: l_line_rec Oe_Order_Pub.line_rec_type := px_line_rec;
1288: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1289: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1290: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1291: l_pricing_event varchar2(30);
1292: l_return_status varchar2(1);
1293: --

Line 1290: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;

1286: IS
1287: l_line_rec Oe_Order_Pub.line_rec_type := px_line_rec;
1288: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1289: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1290: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1291: l_pricing_event varchar2(30);
1292: l_return_status varchar2(1);
1293: --
1294: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1654: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;

1650: E_CLOSED_LINE Exception;
1651: --
1652: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1653: --
1654: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;
1655: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;
1656: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1657: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1658: l_mod_line_id NUMBER;

Line 1655: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;

1651: --
1652: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1653: --
1654: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;
1655: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;
1656: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1657: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1658: l_mod_line_id NUMBER;
1659:

Line 1656: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;

1652: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1653: --
1654: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;
1655: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;
1656: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1657: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1658: l_mod_line_id NUMBER;
1659:
1660: --service er variable declarion start 16227925

Line 1657: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;

1653: --
1654: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;
1655: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;
1656: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1657: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1658: l_mod_line_id NUMBER;
1659:
1660: --service er variable declarion start 16227925
1661: l_inventory_item_id NUMBER;

Line 2158: from oe_order_lines_all

2154: into l_order_source_id, l_orig_sys_document_ref,
2155: l_orig_sys_line_ref, l_orig_sys_shipment_ref,
2156: l_change_sequence, l_source_document_type_id,
2157: l_source_document_id, l_source_document_line_id
2158: from oe_order_lines_all
2159: where line_id = l_line_id;
2160: EXCEPTION
2161: WHEN NO_DATA_FOUND THEN
2162: IF l_debug_level > 0 THEN