APPS.OE_ADV_PRICE_PVT dependencies on OE_SYS_PARAMETERS

Line 179: l_org_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

175: px_line_rec in out nocopy OE_Order_PUB.line_rec_type
176: ,p_related_item_id NUMBER
177: )
178: is
179: l_org_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
180: l_ordered_item varchar2(300);
181:
182: --
183: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1288: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

1284: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%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);

Line 1662: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

1658: l_mod_line_id NUMBER;
1659:
1660: --service er variable declarion start 16227925
1661: l_inventory_item_id NUMBER;
1662: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1663: l_contract_item_type_code VARCHAR2(100);
1664: l_service_item_flag VARCHAR2(1);
1665: --service er variable declarion end 16227925
1666: