APPS.OKL_FUNDING_WF dependencies on FND_PROFILE

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

527: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
528: RAISE OKL_API.G_EXCEPTION_ERROR;
529: END IF;
530:
531: l_approval_option := fnd_profile.value('OKL_LEASE_FUNDING_APPROVAL_PROCESS');
532: IF l_approval_option = G_LEASE_FUNDING_APPROVAL_AME THEN
533:
534: -- Get the Application ID
535: OPEN c_get_app_id_csr;

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

966: p_attribute_code => 'OKL_DATE_DUE')
967: || '
968: '|| G_AMP_SIGN ||'nbsp;
969: '
970: || TO_CHAR(r_funding_req.fund_due_date,fnd_profile.value('ICX_DATE_FORMAT_MASK'))
971: || '
972: '|| G_AMP_SIGN ||'nbsp;
973: ';
974:

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

1265: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1266:
1267: -- "RUN"
1268: IF (funcmode = 'RUN') THEN
1269: --l_user_id := fnd_profile.value('OKL_LEASE_FUNDING_APPROVER');
1270: l_user_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1271: itemkey => itemkey,
1272: aname => G_WF_ITM_REQUESTER_ID);
1273:

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

1623: BEGIN
1624:
1625: IF (funcmode = 'RUN') THEN
1626:
1627: l_approval_option := fnd_profile.value('OKL_LEASE_FUNDING_APPROVAL_PROCESS');
1628: IF l_approval_option = G_LEASE_FUNDING_APPROVAL_AME THEN
1629:
1630: l_funding_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1631: itemkey => itemkey,