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 2006/02/02 23:29:59 amsriniv noship $ */
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 268: application_usg_code = RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE')));

264: UPPER(route_no)=UPPER(c_route_no) AND
265: revision_number=NVL(c_revision_number,revision_number) AND
266: TRUNC(NVL(end_date_active,SYSDATE+1))>TRUNC(SYSDATE) AND
267: revision_status_code='COMPLETE' AND
268: application_usg_code = RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE')));
269:
270: /*select ROUTE_ID,REVISION_STATUS_CODE
271: from AHL_ROUTES_V
272: where UPPER(ROUTE_NO)=upper(C_ROUTE_NO)

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

356: WHERE
357: route_no=p_mr_route_rec.route_number AND
358: revision_status_code='COMPLETE' AND
359: NVL(end_date_active,SYSDATE+1)>SYSDATE AND
360: application_usg_code = RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE')));
361:
362:
363: /*Select count(*) into l_counter
364: From ahl_routes_v

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

459: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_MR_ROUTE';
460: l_api_version CONSTANT NUMBER := 1.0;
461: l_msg_count NUMBER;
462: l_mr_route_rec MR_ROUTE_REC;
463: l_max_route_num NUMBER := NVL(FND_PROFILE.VALUE('AHL_NUMBER_OF_STAGES'), 1);
464: l_dummy_varchar VARCHAR2(1);
465:
466: CURSOR check_route_seq_exists
467: (