[Home] [Help]
5517: )
5518: is
5519: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5520: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/
5521: l_org_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5522: l_ordered_item varchar2(300);
5523:
5524: begin
5525: adj_debug('Entering oe_order_Adj_pvt.set_item_for_iue');
5562:
5563: procedure Get_item_for_iue(px_line_rec in out nocopy OE_Order_PUB.line_rec_type)
5564: is
5565: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5566: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5567: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/
5568: l_ordered_item varchar2(300);
5569: cursor adj_cur is
5570: select modified_from from oe_price_adjustments
7396: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
7397: -- Including variables for bug 1820961 end
7398: l_found_discount_line boolean:=FALSE;
7399: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
7400: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
7401: E_CLOSED_PRG_LINE Exception;
7402: l_new_prg_created boolean := FALSE;
7403: Begin
7404: adj_debug('Entering oe_order_Adj_pvt.Process_Other_Item_Line',1);
7964: l_gsa_released varchar2(1):= 'N';
7965: --for bug 2028480 end
7966: l_operand number;
7967: l_msg_text Varchar2(200);
7968: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
7969:
7970: Cursor get_gsa_list_lines is
7971: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
7972: From
8281:
8282: adj_debug('Entering oe_order_Adj_pvt.Calculate_Price');
8283:
8284: --moac
8285: l_gsa_violation_action := oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION',p_header_rec.org_id);
8286:
8287: --OE_Order_Pub.G_HDR := p_header_rec;
8288:
8289: G_STMT_NO := 'Calculate_Price#05';