APPS.OE_OE_AVAILABILITY dependencies on FND_PROFILE

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

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

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

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

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

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

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

3793: ) IS
3794:
3795: l_price_list varchar2(200);
3796: l_allow_negative_price varchar2(10):= nvl(OE_Sys_Parameters.VALUE('ONT_NEGATIVE_PRICING'),'N');
3797: l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');
3798: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
3799:
3800:
3801: Cursor get_gsa_list_lines is

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

4783: CLOSE c_instance_id;
4784:
4785:
4786: x_return_status := 'S';
4787: l_mrp_atp_database_link := fnd_profile.value('MRP_ATP_DATABASE_LINK');
4788:
4789: IF l_debug_level > 0 THEN
4790: oe_debug_pub.add( 'L_INSTANCE_ID='||L_INSTANCE_ID|| ' DB LINK='
4791: ||L_MRP_ATP_DATABASE_LINK ||' Ins Code='||l_instance_code) ;

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

4852: l_customer_site_id := null;
4853: END IF;
4854:
4855:
4856: /*fnd_profile.get('INV_CTP',l_inv_ctp);
4857: IF l_debug_level > 0 THEN
4858: oe_debug_pub.add(' Inventory Capable to Promise='||l_inv_ctp);
4859: END IF;
4860: