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.9.12020000.2 2012/12/13 05:03:22 shnatu 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 1211: RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE')));

1207: qa.char_id(+) = 87 AND
1208: mtl.inventory_item_id(+) = mr.billing_item_id AND
1209: mtl.organization_id(+) = mr.billing_org_id AND
1210: mr.application_usg_code =
1211: RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE')));
1212:
1213: /*SELECT IMPLEMENT_STATUS_CODE,
1214: REPETITIVE_FLAG,
1215: SHOW_REPETITIVE_CODE,

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

2609: mr_status_code
2610: FROM
2611: ahl_mr_headers_b
2612: WHERE
2613: application_usg_code = RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE'))) AND
2614: mr_header_id=C_MR_HEADER_ID AND
2615: object_version_number=C_OBJECT_VERSION_NUMBER;
2616:
2617: /*SELECT MR_STATUS_CODE