[Home] [Help]
5434: )
5435: is
5436: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5437: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/
5438: l_org_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5439: l_ordered_item varchar2(300);
5440:
5441: begin
5442: adj_debug('Entering oe_order_Adj_pvt.set_item_for_iue');
5479:
5480: procedure Get_item_for_iue(px_line_rec in out nocopy OE_Order_PUB.line_rec_type)
5481: is
5482: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5483: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5484: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/
5485: l_ordered_item varchar2(300);
5486: cursor adj_cur is
5487: select modified_from from oe_price_adjustments
7304: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
7305: -- Including variables for bug 1820961 end
7306: l_found_discount_line boolean:=FALSE;
7307: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
7308: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
7309: E_CLOSED_PRG_LINE Exception;
7310: l_new_prg_created boolean := FALSE;
7311: Begin
7312: adj_debug('Entering oe_order_Adj_pvt.Process_Other_Item_Line',1);
7872: l_gsa_released varchar2(1):= 'N';
7873: --for bug 2028480 end
7874: l_operand number;
7875: l_msg_text Varchar2(200);
7876: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
7877:
7878: Cursor get_gsa_list_lines is
7879: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
7880: From
8189:
8190: adj_debug('Entering oe_order_Adj_pvt.Calculate_Price');
8191:
8192: --moac
8193: l_gsa_violation_action := oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION',p_header_rec.org_id);
8194:
8195: --OE_Order_Pub.G_HDR := p_header_rec;
8196:
8197: G_STMT_NO := 'Calculate_Price#05';