APPS.AHL_FMP_MR_HEADER_PVT dependencies on FND_PROFILE

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

1: PACKAGE BODY AHL_FMP_MR_HEADER_PVT AS
2: /* $Header: AHLVMRHB.pls 120.4.12010000.2 2008/12/29 01:01:46 sracha ship $ */
3:
4: G_PKG_NAME VARCHAR2(30):='AHL_FMP_MR_HEADER_PVT';
5: G_APPLN_USAGE VARCHAR2(30):=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
6: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
7:
8: PROCEDURE DEFAULT_MISSING_ATTRIBS
9: (p_x_mr_header_rec IN OUT NOCOPY AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC)

Line 1081: RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE')));

1077: qa.char_id(+) = 87 AND
1078: mtl.inventory_item_id(+) = mr.billing_item_id AND
1079: mtl.organization_id(+) = mr.billing_org_id AND
1080: mr.application_usg_code =
1081: RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE')));
1082:
1083: /*SELECT IMPLEMENT_STATUS_CODE,
1084: REPETITIVE_FLAG,
1085: SHOW_REPETITIVE_CODE,

Line 2269: application_usg_code = RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE'))) AND

2265: mr_status_code
2266: FROM
2267: ahl_mr_headers_b
2268: WHERE
2269: application_usg_code = RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE'))) AND
2270: mr_header_id=C_MR_HEADER_ID AND
2271: object_version_number=C_OBJECT_VERSION_NUMBER;
2272:
2273: /*SELECT MR_STATUS_CODE