APPS.AHL_FMP_PVT dependencies on FND_PROFILE

Line 5: G_APPLN_USAGE VARCHAR2(30):=FND_PROFILE.VALUE('AHL_APPLN_USAGE');

1: PACKAGE BODY AHL_FMP_PVT AS
2: /* $Header: AHLVFMPB.pls 120.19.12020000.4 2013/05/10 20:50:45 sracha ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AHL_FMP_PVT';
5: G_APPLN_USAGE VARCHAR2(30):=FND_PROFILE.VALUE('AHL_APPLN_USAGE');
6: --Define Global Cursor: get item instance attributes from ahl_unit_installed_details_v.
7: --The last two attributes: manufacturer_id and counctry_code are not in the view definition.
8: CURSOR get_inst_attri(c_item_instance_id NUMBER) IS
9: /* perf fix for bug# 9620276

Line 3889: l_appln_code VARCHAR2(30):=FND_PROFILE.VALUE('AHL_APPLN_USAGE');

3885: l_return_status VARCHAR2(1);
3886: l_item_instance_id NUMBER;
3887: l_inventory_item_id NUMBER;
3888: l_pm_install VARCHAR2(1);
3889: l_appln_code VARCHAR2(30):=FND_PROFILE.VALUE('AHL_APPLN_USAGE');
3890: l_inp_rec OKS_PM_ENTITLEMENTS_PUB.get_pmcontin_rec;
3891: l_ent_contracts OKS_ENTITLEMENTS_PUB.get_contop_tbl;
3892: l_pm_activities OKS_PM_ENTITLEMENTS_PUB.get_activityop_tbl;
3893: l_prior_mr_header_id NUMBER;

Line 3970: l_appln_code:=nvl(FND_PROFILE.VALUE('AHL_APPLN_USAGE'),'x');

3966: THEN
3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3968: END IF;
3969:
3970: l_appln_code:=nvl(FND_PROFILE.VALUE('AHL_APPLN_USAGE'),'x');
3971: IF l_appln_code <> 'PM' THEN
3972: FND_MESSAGE.set_name('AHL', 'AHL_FMP_PM_NOT_INSTALLED');
3973: FND_MSG_PUB.add;
3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;