APPS.OKL_FUNDING_WF dependencies on FND_PROFILE

Line 562: l_approval_option := fnd_profile.value('OKL_LEASE_FUNDING_APPROVAL_PROCESS');

558: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
559: RAISE OKL_API.G_EXCEPTION_ERROR;
560: END IF;
561:
562: l_approval_option := fnd_profile.value('OKL_LEASE_FUNDING_APPROVAL_PROCESS');
563: IF l_approval_option = G_LEASE_FUNDING_APPROVAL_AME THEN
564:
565: -- Get the Application ID
566: OPEN c_get_app_id_csr;

Line 630: --wf_event.AddParameterToList('ORG_ID',NVL(fnd_profile.value('ORG_ID'),-99),l_parameter_list);

626:
627: --Added by sechawla for bug 7594853
628: -- Set the User ID, Responsibility Id and Application Id as workflow attributes
629: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
630: --wf_event.AddParameterToList('ORG_ID',NVL(fnd_profile.value('ORG_ID'),-99),l_parameter_list);
631: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
632: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
633: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
634: --end sechawla for bug 7594853

Line 1012: || TO_CHAR(r_funding_req.fund_due_date,fnd_profile.value('ICX_DATE_FORMAT_MASK'))

1008: p_attribute_code => 'OKL_DATE_DUE')
1009: || '
1010: '|| G_AMP_SIGN ||'nbsp;
1011: '
1012: || TO_CHAR(r_funding_req.fund_due_date,fnd_profile.value('ICX_DATE_FORMAT_MASK'))
1013: || '
1014: '|| G_AMP_SIGN ||'nbsp;
1015: ';
1016:

Line 1311: --l_user_id := fnd_profile.value('OKL_LEASE_FUNDING_APPROVER');

1307: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1308:
1309: -- "RUN"
1310: IF (funcmode = 'RUN') THEN
1311: --l_user_id := fnd_profile.value('OKL_LEASE_FUNDING_APPROVER');
1312: l_user_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1313: itemkey => itemkey,
1314: aname => G_WF_ITM_REQUESTER_ID);
1315:

Line 1699: l_approval_option := fnd_profile.value('OKL_LEASE_FUNDING_APPROVAL_PROCESS');

1695: BEGIN
1696:
1697: IF (funcmode = 'RUN') THEN
1698:
1699: l_approval_option := fnd_profile.value('OKL_LEASE_FUNDING_APPROVAL_PROCESS');
1700: IF l_approval_option = G_LEASE_FUNDING_APPROVAL_AME THEN
1701:
1702: l_funding_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1703: itemkey => itemkey,