DBA Data[Home] [Help]

APPS.OE_OE_AVAILABILITY dependencies on FND_PROFILE

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

302: in_atp_rec.Message(I) := null;
303: in_atp_rec.atp_lead_time(I) := 0;
304:
305: --bug14222176
306: l_mrp_calc_sd := fnd_profile.value('MRP_ATP_CALC_SD');
307: IF nvl(l_mrp_calc_sd,'N') = 'Y' THEN
308: oe_debug_pub.add('in OEXFAVAB, MRP_ATP_CALC_SD profile set to yes ' );
309: in_atp_rec.Insert_Flag(I) := 1;
310: ELSE

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

1431: px_req_line_tbl(l_line_index).PRICE_FLAG := 'Y';
1432:
1433:
1434: -- Get Discounting Privilege Profile Option value
1435: fnd_profile.get('ONT_DISCOUNTING_PRIVILEGE', v_discounting_privilege);
1436:
1437: -- Execute the pricing phase if the list price is null
1438:
1439: IF p_pricing_event = 'PRICE' and

Line 1560: l_org_id Number := to_number( fnd_profile.value('ORG_ID'));

1556: )IS
1557:
1558: qp_attr_mapping_error exception;
1559: --l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1560: l_org_id Number := to_number( fnd_profile.value('ORG_ID'));
1561: l_master_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1562: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1563: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1564:

Line 1673: l_org_id Number := to_number( fnd_profile.value('ORG_ID'));

1669: )IS
1670:
1671: qp_attr_mapping_error exception;
1672: --l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1673: l_org_id Number := to_number( fnd_profile.value('ORG_ID'));
1674: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1675: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1676:
1677: --

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

3810: ) IS
3811:
3812: l_price_list varchar2(200);
3813: l_allow_negative_price varchar2(10):= nvl(OE_Sys_Parameters.VALUE('ONT_NEGATIVE_PRICING'),'N');
3814: l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');
3815: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
3816:
3817:
3818: Cursor get_gsa_list_lines is

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

4800: CLOSE c_instance_id;
4801:
4802:
4803: x_return_status := 'S';
4804: l_mrp_atp_database_link := fnd_profile.value('MRP_ATP_DATABASE_LINK');
4805:
4806: IF l_debug_level > 0 THEN
4807: oe_debug_pub.add( 'L_INSTANCE_ID='||L_INSTANCE_ID|| ' DB LINK='
4808: ||L_MRP_ATP_DATABASE_LINK ||' Ins Code='||l_instance_code) ;

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

4869: l_customer_site_id := null;
4870: END IF;
4871:
4872:
4873: /*fnd_profile.get('INV_CTP',l_inv_ctp);
4874: IF l_debug_level > 0 THEN
4875: oe_debug_pub.add(' Inventory Capable to Promise='||l_inv_ctp);
4876: END IF;
4877: