DBA Data[Home] [Help]

APPS.AHL_RM_APPROVAL_PVT dependencies on FND_PROFILE

Line 362: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'N');

358: x_return_status :=FND_API.G_RET_STS_SUCCESS;
359:
360: -- Get approval process setup.
361: IF (G_PM_INSTALL = 'Y') THEN
362: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'N');
363: ELSE
364: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'Y');
365: END IF;
366:

Line 364: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'Y');

360: -- Get approval process setup.
361: IF (G_PM_INSTALL = 'Y') THEN
362: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'N');
363: ELSE
364: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'Y');
365: END IF;
366:
367: -- Bug # 8639648 -- start
368: OPEN get_op_max_duration(p_source_operation_id);

Line 703: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'N');

699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700:
701: -- Set default for CMRO and PM modes.
702: IF (G_PM_INSTALL = 'Y') THEN
703: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'N');
704: ELSE
705: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'Y');
706: END IF;
707:

Line 705: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'Y');

701: -- Set default for CMRO and PM modes.
702: IF (G_PM_INSTALL = 'Y') THEN
703: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'N');
704: ELSE
705: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'Y');
706: END IF;
707:
708:
709: --Before calling ahl_utility_pvt.get_wf_process_name()

Line 860: b.application_usg_code = rtrim(ltrim(fnd_profile.value('AHL_APPLN_USAGE'))) and

856: from ahl_mr_routes a, ahl_mr_headers_b b
857: where
858: a.route_id = l_route_rec.route_id and
859: a.mr_header_id = b.mr_header_id and
860: b.application_usg_code = rtrim(ltrim(fnd_profile.value('AHL_APPLN_USAGE'))) and
861: trunc(nvl(b.effective_to,sysdate)) >= trunc(sysdate);
862: IF l_counter>0
863: THEN
864: FND_MESSAGE.SET_NAME('AHL','AHL_RM_MR_C_TERM');