APPS.AHL_FMP_MR_ROUTE_SEQNCE_PVT dependencies on FND_PROFILE

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

2: /* $Header: AHLVMRSB.pls 120.0 2005/05/26 00:59:55 appldev noship $ */
3:
4: G_PKG_NAME VARCHAR2(30):='AHL_FMP_MR_ROUTE_SEQNCE_PVT';
5: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
6: G_APPLN_USAGE VARCHAR2(30):=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
7: -- TAMAL
8: -- Procedure to check for correct route sequence w.r.t stage information for given mr_route...
9: -- Pass p_route_stage_upd = true for calling from AHL_FMP_MR_ROUTE_PVT, and false otherwise...
10: PROCEDURE VALIDATE_ROUTE_STAGE_SEQ

Line 16: l_max_stage_num NUMBER := FND_PROFILE.VALUE('AHL_NUMBER_OF_STAGES');

12: p_mr_route_id in number,
13: p_route_stage_upd in boolean
14: )
15: IS
16: l_max_stage_num NUMBER := FND_PROFILE.VALUE('AHL_NUMBER_OF_STAGES');
17: l_min_stage NUMBER;
18: l_max_stage NUMBER;
19: l_route_num VARCHAR2(30);
20: l_route_stage NUMBER;