DBA Data[Home] [Help]

APPS.AHL_RM_APPROVAL_PVT dependencies on FND_PROFILE

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

319: x_return_status :=FND_API.G_RET_STS_SUCCESS;
320:
321: -- Get approval process setup.
322: IF (G_PM_INSTALL = 'Y') THEN
323: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'N');
324: ELSE
325: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'Y');
326: END IF;
327:

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

321: -- Get approval process setup.
322: IF (G_PM_INSTALL = 'Y') THEN
323: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'N');
324: ELSE
325: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'Y');
326: END IF;
327:
328: -- Start work Flow Process
329: IF l_OPER_APPR_ENABLED = 'Y'

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

642: x_return_status := FND_API.G_RET_STS_SUCCESS;
643:
644: -- Set default for CMRO and PM modes.
645: IF (G_PM_INSTALL = 'Y') THEN
646: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'N');
647: ELSE
648: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'Y');
649: END IF;
650:

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

644: -- Set default for CMRO and PM modes.
645: IF (G_PM_INSTALL = 'Y') THEN
646: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'N');
647: ELSE
648: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'Y');
649: END IF;
650:
651:
652: --Before calling ahl_utility_pvt.get_wf_process_name()

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

798: from ahl_mr_routes a, ahl_mr_headers_b b
799: where
800: a.route_id = l_route_rec.route_id and
801: a.mr_header_id = b.mr_header_id and
802: b.application_usg_code = rtrim(ltrim(fnd_profile.value('AHL_APPLN_USAGE'))) and
803: trunc(nvl(b.effective_to,sysdate)) >= trunc(sysdate);
804: IF l_counter>0
805: THEN
806: FND_MESSAGE.SET_NAME('AHL','AHL_RM_MR_C_TERM');