DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on OE_SYS_PARAMETERS

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

154: px_line_rec in out nocopy OE_Order_PUB.line_rec_type
155: ,p_related_item_id NUMBER
156: )
157: is
158: l_org_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
159: l_ordered_item varchar2(300);
160:
161: --
162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

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