APPS.OE_ORDER_PRICE_PVT dependencies on OE_SYS_PARAMETERS

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

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

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

2609: PROCEDURE CHECK_GSA
2610: IS
2611: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
2612: --l_gsa_violation_action Varchar2(30) := nvl(fnd_profile.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING');
2613: l_gsa_violation_action Varchar2(30) := nvl(oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING'); --moac
2614: l_hold_source_rec OE_Holds_Pvt.hold_source_rec_type;
2615: l_hold_release_rec OE_Holds_Pvt.Hold_Release_REC_Type;
2616: l_return_status varchar2(30);
2617: l_x_msg_count number;

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

3268:
3269: --Bug 4332307 Logging Margin Hold delayed request
3270: IF update_line.booked_flag = 'Y' THEN
3271: IF OE_FEATURES_PVT.Is_Margin_Avail THEN
3272: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then
3273: l_log_mrg_hold_req := 'Y';
3274: l_header_id := update_line.header_id;
3275: END IF;
3276: END IF;

Line 8194: IF (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y') THEN

8190: raise fnd_api.g_exc_error;
8191: END IF;
8192:
8193: --TaxER start
8194: IF (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y') THEN
8195:
8196: /*12598464 start
8197: SELECT Count(1)
8198: INTO l_hdr_chg_count