222: END IF;
223: -- copy this value back to the out parameter once pending for approval is set successfully
224: x_pool_status := G_PENDING_STATUS_CODE;
225: -- read the profile OKL: Subsidy Pool Approval Process Access
226: l_approval_process := fnd_profile.value('OKL_SUBSIDY_POOL_APPROVAL_PROCESS');
227:
228: IF(NVL(l_approval_process,'NONE')='NONE')THEN
229: -- since no approval process is selected in the profile, approve the pool by default
230: l_pool_status := G_ACTIVE_STATUS_CODE;
534: END IF; -- end of cv_get_pool_info.budget_type_code = 'REDUCTION'
535:
536: x_pool_budget_status := G_PENDING_STATUS_CODE;
537: -- read the profile OKL: Subsidy Pool Approval Process Access
538: l_approval_process := fnd_profile.value('OKL_SUBSIDY_POOL_APPROVAL_PROCESS');
539:
540: IF(NVL(l_approval_process,'NONE')='NONE')THEN
541: -- since no approval process is selected in the profile, approve the pool budget line by default
542: l_budget_status := G_ACTIVE_STATUS_CODE;