DBA Data[Home] [Help]

APPS.OKL_VP_PA_WF dependencies on FND_PROFILE

Line 292: l_approval_process := fnd_profile.value('OKL_VP_PA_APPROVAL_PROCESS');

288: );
289: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
290:
291: -- read the profile OKL: Program Agreement Approval Process
292: l_approval_process := fnd_profile.value('OKL_VP_PA_APPROVAL_PROCESS');
293: IF(NVL(l_approval_process,'NONE') = G_AGRMNT_APPROVAL_AME)THEN
294: -- for AME approvals, put the application_id and transaction_type_id as event parameters
295: -- Get the Application ID
296: OPEN c_get_app_id_csr;

Line 405: l_approval_option := fnd_profile.value('OKL_VP_PA_APPROVAL_PROCESS');

401: l_approval_option VARCHAR2(10);
402: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'check_approval_process';
403: BEGIN
404: IF(funcmode = 'RUN')THEN
405: l_approval_option := fnd_profile.value('OKL_VP_PA_APPROVAL_PROCESS');
406: IF l_approval_option = 'AME' THEN
407: resultout := 'COMPLETE:AME';
408: ELSIF l_approval_option = 'WF' THEN
409: resultout := 'COMPLETE:WF';