400:
401: --
402: -- Check profile
403: --
404: l_stage_count := FND_PROFILE.value('AHL_NUMBER_OF_STAGES');
405: -- Modified by amagrawa as per review comments.
406: If l_stage_count is null
407: then
408: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_PROFILE_NOT_DEF');
1247: L_MIN_CHILD NUMBER;
1248: L_STAGE_NUM NUMBER;
1249: L_STAGE_ID NUMBER;
1250:
1251: l_max_stage_num number := FND_PROFILE.value('AHL_NUMBER_OF_STAGES');
1252:
1253: L_API_VERSION CONSTANT NUMBER := 1.0;
1254: L_API_NAME CONSTANT VARCHAR2(30) := 'Update Stages';
1255: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;