APPS.OE_HEADER_UTIL dependencies on OE_ORDER_LINES

Line 1789: select line_id from oe_order_lines_all

1785: and payment_type_code in ('CREDIT_CARD','ACH','DIRECT_DEBIT');
1786:
1787: --- added for bug# 10194125
1788: cursor lines_cur is
1789: select line_id from oe_order_lines_all
1790: where header_id = p_x_header_rec.header_id;
1791:
1792: l_payments_upd_flag VARCHAR2(1) := 'N';
1793: l_delete_payment_count NUMBER :=0;

Line 8170: select line_id from oe_order_lines_all

8166: l_apply_automatic_atchmt VARCHAR2(1) :=
8167: NVL(FND_PROFILE.VALUE('OE_APPLY_AUTOMATIC_ATCHMT'),'Y') ; --5893276
8168:
8169: cursor line_ids(p_header_id IN NUMBER) is
8170: select line_id from oe_order_lines_all
8171: where header_id = p_header_id;
8172: --bug 4190357
8173: -- R12 CC encryption
8174: l_changed_attribute VARCHAR2(200);

Line 9744: -- SELECT sum(ordered_quantity) into l_total_quantity from OE_ORDER_LINES where header_id = p_header_id; --commented for bug#9434723

9740:
9741: BEGIN
9742: oe_debug_pub.add(' Entering Cancel_Header_Charges() ');
9743:
9744: -- SELECT sum(ordered_quantity) into l_total_quantity from OE_ORDER_LINES where header_id = p_header_id; --commented for bug#9434723
9745: --bug#9434723: Outer NVL() if the it is last line to be deleted. Inner NVL() if line is in ENTERED status w/out qty.
9746: SELECT Nvl(sum( Nvl(ordered_quantity,0) ),0) into l_total_quantity FROM OE_ORDER_LINES where header_id = p_header_id; --bug#9434723
9747: oe_debug_pub.add(' l_total_quantity = ' ||l_total_quantity, 1 ) ;
9748:

Line 9746: SELECT Nvl(sum( Nvl(ordered_quantity,0) ),0) into l_total_quantity FROM OE_ORDER_LINES where header_id = p_header_id; --bug#9434723

9742: oe_debug_pub.add(' Entering Cancel_Header_Charges() ');
9743:
9744: -- SELECT sum(ordered_quantity) into l_total_quantity from OE_ORDER_LINES where header_id = p_header_id; --commented for bug#9434723
9745: --bug#9434723: Outer NVL() if the it is last line to be deleted. Inner NVL() if line is in ENTERED status w/out qty.
9746: SELECT Nvl(sum( Nvl(ordered_quantity,0) ),0) into l_total_quantity FROM OE_ORDER_LINES where header_id = p_header_id; --bug#9434723
9747: oe_debug_pub.add(' l_total_quantity = ' ||l_total_quantity, 1 ) ;
9748:
9749: IF l_total_quantity = 0 THEN
9750: OE_Header_Adj_Util.Delete_Header_Charges( p_header_id => p_header_id );

Line 9783: FROM OE_ORDER_LINES

9779: ,inventory_item_id
9780: ,unit_selling_price
9781: ,fulfilled_flag
9782: ,line_set_id
9783: FROM OE_ORDER_LINES
9784: WHERE HEADER_ID = p_header_rec.header_id
9785: AND BLANKET_NUMBER IS NOT NULL;
9786:
9787: l_return_status VARCHAR2(1);