APPS.OE_OE_PRICING_AVAILABILITY dependencies on FND_PROFILE

Line 1406: IF UPPER(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED')) NOT IN ('Y', 'YES') THEN

1402: in_out_default_rec.demand_class_code := l_out_rec.demand_class_code;
1403:
1404: ELSIF in_source = 'PRICE_LIST' then
1405:
1406: IF UPPER(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED')) NOT IN ('Y', 'YES') THEN
1407:
1408: l_record.org_id := in_out_default_rec.org_id;
1409: l_record.order_type_id := in_out_default_rec.order_type_id;
1410: l_record.sold_to_org_id := in_out_default_rec.sold_to_org_id;

Line 2079: fnd_profile.get('ONT_DISCOUNTING_PRIVILEGE', v_discounting_privilege);

2075: px_req_line_tbl(l_line_index).PRICE_FLAG := 'Y';
2076:
2077:
2078: -- Get Discounting Privilege Profile Option value
2079: fnd_profile.get('ONT_DISCOUNTING_PRIVILEGE', v_discounting_privilege);
2080:
2081: -- Execute the pricing phase if the list price is null
2082:
2083: IF p_pricing_event = 'PRICE' and

Line 5167: --l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');

5163:
5164: l_price_list varchar2(200);
5165: l_allow_negative_price varchar2(10):= nvl(OE_Sys_Parameters.VALUE('ONT_NEGATIVE_PRICING'),'N');
5166: --Bug 7409782
5167: --l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');
5168: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5169:
5170: --Bug 7409782
5171: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');

Line 5171: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');

5167: --l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');
5168: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5169:
5170: --Bug 7409782
5171: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
5172: l_gsa_violation_action Varchar2(30) := nvl(oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION'),'WARNING');
5173: Cursor get_gsa_list_lines is
5174: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
5175: From

Line 6393: -- l_mrp_atp_database_link := fnd_profile.value('MRP_ATP_DATABASE_LINK');

6389:
6390: x_return_status := 'S';
6391: -- No need to check profile.. Instead get the link from
6392: -- table mrp_ap_apps_instances 4113599
6393: -- l_mrp_atp_database_link := fnd_profile.value('MRP_ATP_DATABASE_LINK');
6394:
6395: --Bug 6716697: Wrong dblink name was selected. Corrcted as per ATP team
6396: select a2m_dblink
6397: into l_mrp_atp_database_link

Line 6467: /*fnd_profile.get('INV_CTP',l_inv_ctp);

6463: l_customer_site_id := null;
6464: END IF;
6465:
6466:
6467: /*fnd_profile.get('INV_CTP',l_inv_ctp);
6468: IF l_debug_level > 0 THEN
6469: oe_debug_pub.add(' Inventory Capable to Promise='||l_inv_ctp);
6470: END IF;
6471: