APPS.OE_ADV_PRICE_PVT dependencies on OE_ORDER_LINES

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 1053: from oe_order_lines

1049: IF (l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1050: begin
1051: select nvl(sum(ordered_quantity),0),nvl(sum(pricing_quantity),0)
1052: into l_tot_qty,l_tot_price_qty
1053: from oe_order_lines
1054: where split_from_line_id = l_line_rec.line_id
1055: and header_id = l_line_rec.header_id;
1056: exception
1057: when others then

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 1346: from oe_order_lines

1342:
1343: begin
1344: select nvl(sum(ordered_quantity + nvl(cancelled_quantity,0)),0),nvl(sum(pricing_quantity + nvl(cancelled_quantity,0)),0)
1345: into l_tot_qty,l_tot_price_qty
1346: from oe_order_lines
1347: where split_from_line_id = l_line_rec.line_id
1348: and header_id = l_line_rec.header_id;
1349: exception
1350: when others then

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

Line 2088: ,OE_ORDER_LINES l

2084: lines.PRICE_LIST_HEADER_ID,
2085: l.price_list_id
2086: FROM
2087: QP_PREQ_LINES_TMP lines
2088: ,OE_ORDER_LINES l
2089: WHERE lines.pricing_status_code IN
2090: ( QP_PREQ_GRP.G_STATUS_UPDATED
2091: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2092: AND lines.process_status <> 'NOT_VALID'