[Home] [Help]
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
6751: ( p_charge_periodicity_code IN VARCHAR2
6752: ) RETURN VARCHAR2
6753: IS
6754: l_charge_periodicity_dsp VARCHAR2(60) := NULL;
6755: --l_profile_value VARCHAR2(80) :=Oe_Sys_Parameters.Value('UOM_CLASS_CHARGE_PERIODICITY');
6756: l_profile_value VARCHAR2(80) :=fnd_profile.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY');
6757: --
6758: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6759: --
6819: SELECT service_item_flag
6820: INTO l_temp
6821: FROM MTL_SYSTEM_ITEMS_B
6822: WHERE inventory_item_id = p_inventory_item_id
6823: AND organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
6824:
6825: --OE_MSG_PUB.ADD_TEXT('l_temp' || l_temp);
6826: IF l_temp = 'Y' THEN
6827: --webroot bug 6826344 end
6830: INTO l_service_period_dsp
6831: FROM mtl_item_uoms_view
6832: WHERE uom_code =p_service_period
6833: and inventory_item_id = p_inventory_item_id
6834: and organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
6835: END IF;
6836:
6837: --OE_MSG_PUB.ADD_TEXT('l_service_period_dsp'|| l_service_period_dsp);
6838: END IF;