APPS.OE_OE_PRICING_AVAILABILITY dependencies on FND_PROFILE

Line 523: l_mrp_calc_sd := fnd_profile.value('MRP_ATP_CALC_SD');

519: in_atp_rec.Message(I) := null;
520: in_atp_rec.atp_lead_time(I) := 0;
521:
522: --bug14222176
523: l_mrp_calc_sd := fnd_profile.value('MRP_ATP_CALC_SD');
524: IF nvl(l_mrp_calc_sd,'N') = 'Y' THEN
525: oe_debug_pub.add('in OEXFPRAB, MRP_ATP_CALC_SD profile set to yes ' );
526: in_atp_rec.Insert_Flag(I) := 1;
527: ELSE

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

1412: in_out_default_rec.demand_class_code := l_out_rec.demand_class_code;
1413:
1414: ELSIF in_source = 'PRICE_LIST' then
1415:
1416: IF UPPER(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED')) NOT IN ('Y', 'YES') THEN
1417:
1418: l_record.org_id := in_out_default_rec.org_id;
1419: l_record.order_type_id := in_out_default_rec.order_type_id;
1420: l_record.sold_to_org_id := in_out_default_rec.sold_to_org_id;

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

2085: px_req_line_tbl(l_line_index).PRICE_FLAG := 'Y';
2086:
2087:
2088: -- Get Discounting Privilege Profile Option value
2089: fnd_profile.get('ONT_DISCOUNTING_PRIVILEGE', v_discounting_privilege);
2090:
2091: -- Execute the pricing phase if the list price is null
2092:
2093: IF p_pricing_event = 'PRICE' and

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

5188:
5189: l_price_list varchar2(200);
5190: l_allow_negative_price varchar2(10):= nvl(OE_Sys_Parameters.VALUE('ONT_NEGATIVE_PRICING'),'N');
5191: --Bug 7409782
5192: --l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');
5193: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5194:
5195: --Bug 7409782
5196: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');

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

5192: --l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');
5193: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5194:
5195: --Bug 7409782
5196: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
5197: l_gsa_violation_action Varchar2(30) := nvl(oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION'),'WARNING');
5198: Cursor get_gsa_list_lines is
5199: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
5200: From

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

6414:
6415: x_return_status := 'S';
6416: -- No need to check profile.. Instead get the link from
6417: -- table mrp_ap_apps_instances 4113599
6418: -- l_mrp_atp_database_link := fnd_profile.value('MRP_ATP_DATABASE_LINK');
6419:
6420: --Bug 6716697: Wrong dblink name was selected. Corrcted as per ATP team
6421: select a2m_dblink
6422: into l_mrp_atp_database_link

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

6488: l_customer_site_id := null;
6489: END IF;
6490:
6491:
6492: /*fnd_profile.get('INV_CTP',l_inv_ctp);
6493: IF l_debug_level > 0 THEN
6494: oe_debug_pub.add(' Inventory Capable to Promise='||l_inv_ctp);
6495: END IF;
6496: