APPS.AHL_FMP_MR_ROUTE_PVT dependencies on FND_PROFILE

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

1: PACKAGE BODY AHL_FMP_MR_ROUTE_PVT AS
2: /* $Header: AHLVMRUB.pls 120.2.12020000.2 2012/12/13 05:08:56 shnatu ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) :='AHL_FMP_MR_ROUTE_PVT';
5: G_APPLN_USAGE VARCHAR2(30) :=FND_PROFILE.VALUE('AHL_APPLN_USAGE');
6: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
7: PROCEDURE DEFAULT_MISSING_ATTRIBS
8: (p_x_mr_route_tbl IN OUT NOCOPY AHL_FMP_MR_ROUTE_PVT.MR_ROUTE_tbl)
9: AS

Line 288: application_usg_code = RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE')));

284: UPPER(route_no)=UPPER(c_route_no) AND
285: revision_number=NVL(c_revision_number,revision_number) AND
286: TRUNC(NVL(end_date_active,SYSDATE+1))>TRUNC(SYSDATE) AND
287: revision_status_code='COMPLETE' AND
288: application_usg_code = RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE')));
289:
290: /*select ROUTE_ID,REVISION_STATUS_CODE
291: from AHL_ROUTES_V
292: where UPPER(ROUTE_NO)=upper(C_ROUTE_NO)

Line 385: application_usg_code = RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE')));

381: WHERE
382: route_no=p_x_mr_route_rec.route_number AND
383: revision_status_code='COMPLETE' AND
384: NVL(end_date_active,SYSDATE+1)>SYSDATE AND
385: application_usg_code = RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE')));
386:
387:
388: /*Select count(*) into l_counter
389: From ahl_routes_v

Line 541: l_max_route_num NUMBER := NVL(FND_PROFILE.VALUE('AHL_NUMBER_OF_STAGES'), 1);

537: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_MR_ROUTE';
538: l_api_version CONSTANT NUMBER := 1.0;
539: l_msg_count NUMBER;
540: l_mr_route_rec MR_ROUTE_REC;
541: l_max_route_num NUMBER := NVL(FND_PROFILE.VALUE('AHL_NUMBER_OF_STAGES'), 1);
542: l_dummy_varchar VARCHAR2(1);
543:
544: CURSOR check_route_seq_exists
545: (