APPS.OE_ID_TO_VALUE dependencies on OE_SYS_PARAMETERS

Line 2322: l_validation_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

2318: --Kris make a global variable for validation org so we don't have to get it all the time
2319:
2320: /*l_validation_org_id := fnd_profile.value('OE_ORGANIZATION_ID');*/
2321: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
2322: l_validation_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2323:
2324: SELECT DESCRIPTION
2325: INTO l_inventory_item
2326: FROM MTL_SYSTEM_ITEMS

Line 6781: --l_profile_value VARCHAR2(80) :=Oe_Sys_Parameters.Value('UOM_CLASS_CHARGE_PERIODICITY');

6777: ( p_charge_periodicity_code IN VARCHAR2
6778: ) RETURN VARCHAR2
6779: IS
6780: l_charge_periodicity_dsp VARCHAR2(60) := NULL;
6781: --l_profile_value VARCHAR2(80) :=Oe_Sys_Parameters.Value('UOM_CLASS_CHARGE_PERIODICITY');
6782: l_profile_value VARCHAR2(80) :=fnd_profile.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY');
6783: --
6784: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6785: --

Line 6849: AND organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

6845: SELECT service_item_flag
6846: INTO l_temp
6847: FROM MTL_SYSTEM_ITEMS_B
6848: WHERE inventory_item_id = p_inventory_item_id
6849: AND organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
6850:
6851: --OE_MSG_PUB.ADD_TEXT('l_temp' || l_temp);
6852: IF l_temp = 'Y' THEN
6853: --webroot bug 6826344 end

Line 6860: and organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

6856: INTO l_service_period_dsp
6857: FROM mtl_item_uoms_view
6858: WHERE uom_code =p_service_period
6859: and inventory_item_id = p_inventory_item_id
6860: and organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
6861: END IF;
6862:
6863: --OE_MSG_PUB.ADD_TEXT('l_service_period_dsp'|| l_service_period_dsp);
6864: END IF;