APPS.OE_ORDER_PRICE_PVT dependencies on OE_SYS_PARAMETERS

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

2072:
2073: procedure Get_item_for_iue(px_line_rec in out nocopy OE_Order_PUB.line_rec_type)
2074: is
2075: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
2076: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2077: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/
2078: l_ordered_item varchar2(300);
2079: cursor adj_cur is
2080: select modified_from from oe_price_adjustments

Line 2606: l_gsa_violation_action Varchar2(30) := nvl(oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING'); --moac

2602: PROCEDURE CHECK_GSA
2603: IS
2604: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
2605: --l_gsa_violation_action Varchar2(30) := nvl(fnd_profile.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING');
2606: l_gsa_violation_action Varchar2(30) := nvl(oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING'); --moac
2607: l_hold_source_rec OE_Holds_Pvt.hold_source_rec_type;
2608: l_hold_release_rec OE_Holds_Pvt.Hold_Release_REC_Type;
2609: l_return_status varchar2(30);
2610: l_x_msg_count number;

Line 3250: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then

3246:
3247: --Bug 4332307 Logging Margin Hold delayed request
3248: IF update_line.booked_flag = 'Y' THEN
3249: IF OE_FEATURES_PVT.Is_Margin_Avail THEN
3250: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then
3251: l_log_mrg_hold_req := 'Y';
3252: l_header_id := update_line.header_id;
3253: END IF;
3254: END IF;