DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_WF dependencies on FND_PROFILE

Line 418: l_approval_option := fnd_profile.value('OKL_SUBSIDY_POOL_APPROVAL_PROCESS');

414: l_approval_option VARCHAR2(10);
415: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'check_approval_process';
416: BEGIN
417: IF(funcmode = 'RUN')THEN
418: l_approval_option := fnd_profile.value('OKL_SUBSIDY_POOL_APPROVAL_PROCESS');
419: IF l_approval_option = G_SUBSIDY_POOL_APPROVAL_AME THEN
420: resultout := 'COMPLETE:AME';
421: ELSIF l_approval_option = G_SUBSIDY_POOL_APPROVAL_WF THEN
422: resultout := 'COMPLETE:WF';

Line 1375: l_approval_option := fnd_profile.value('OKL_SUBSIDY_POOL_APPROVAL_PROCESS');

1371: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1372: RAISE OKL_API.G_EXCEPTION_ERROR;
1373: END IF;
1374:
1375: l_approval_option := fnd_profile.value('OKL_SUBSIDY_POOL_APPROVAL_PROCESS');
1376: IF(l_approval_option = G_SUBSIDY_POOL_APPROVAL_AME)THEN
1377: -- Get the Application ID
1378: OPEN c_get_app_id_csr;
1379: FETCH c_get_app_id_csr INTO l_application_id;

Line 1583: l_approval_option := fnd_profile.value('OKL_SUBSIDY_POOL_APPROVAL_PROCESS');

1579: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1580: RAISE OKL_API.G_EXCEPTION_ERROR;
1581: END IF;
1582:
1583: l_approval_option := fnd_profile.value('OKL_SUBSIDY_POOL_APPROVAL_PROCESS');
1584: IF(l_approval_option = G_SUBSIDY_POOL_APPROVAL_AME)THEN
1585: -- Get the Application ID
1586: OPEN c_get_app_id_csr;
1587: FETCH c_get_app_id_csr INTO l_application_id;