APPS.OKL_CO_WF dependencies on FND_PROFILE

Line 51: l_report_after_days := fnd_profile.value('IEX_CB_NOTIFY_GRACE_DAYS');

47:
48: IF(itemtype = 'OKLCORCB') THEN
49: --get the number of days after which a notification is sent to get approval
50: --for reporting the customer to the credit bureau.
51: l_report_after_days := fnd_profile.value('IEX_CB_NOTIFY_GRACE_DAYS');
52: --l_report_after_days := 0.003;
53:
54: l_report_date := SYSDATE + l_report_after_days;
55:

Line 741: l_subject := fnd_profile.value('OKL_VND_APPROVAL_EMAIL_SUBJECT');

737: l_request_id NUMBER;
738: BEGIN
739: if (funcmode = 'RUN') then
740: --get subject
741: l_subject := fnd_profile.value('OKL_VND_APPROVAL_EMAIL_SUBJECT');
742:
743: --get content_id
744: l_content_id := to_number(fnd_profile.value('OKL_VND_APPROVAL_TEMPLATE'));
745:

Line 744: l_content_id := to_number(fnd_profile.value('OKL_VND_APPROVAL_TEMPLATE'));

740: --get subject
741: l_subject := fnd_profile.value('OKL_VND_APPROVAL_EMAIL_SUBJECT');
742:
743: --get content_id
744: l_content_id := to_number(fnd_profile.value('OKL_VND_APPROVAL_TEMPLATE'));
745:
746: --get approval_email_from
747: l_from := fnd_profile.value('OKL_VND_APPROVAL_EMAIL_FROM');
748:

Line 747: l_from := fnd_profile.value('OKL_VND_APPROVAL_EMAIL_FROM');

743: --get content_id
744: l_content_id := to_number(fnd_profile.value('OKL_VND_APPROVAL_TEMPLATE'));
745:
746: --get approval_email_from
747: l_from := fnd_profile.value('OKL_VND_APPROVAL_EMAIL_FROM');
748:
749: l_case_number := wf_engine.GetItemAttrText(itemtype => itemtype,
750: itemkey => itemkey,
751: aname => 'CASE_NUMBER');

Line 1143: l_subject := fnd_profile.value('OKL_VND_NOTIFY_EMAIL_SUBJECT');

1139:
1140: BEGIN
1141: if (funcmode = 'RUN') then
1142: --get subject
1143: l_subject := fnd_profile.value('OKL_VND_NOTIFY_EMAIL_SUBJECT');
1144:
1145: --get content_id
1146: l_content_id := to_number(fnd_profile.value('OKL_VND_NOTIFY_TEMPLATE'));
1147:

Line 1146: l_content_id := to_number(fnd_profile.value('OKL_VND_NOTIFY_TEMPLATE'));

1142: --get subject
1143: l_subject := fnd_profile.value('OKL_VND_NOTIFY_EMAIL_SUBJECT');
1144:
1145: --get content_id
1146: l_content_id := to_number(fnd_profile.value('OKL_VND_NOTIFY_TEMPLATE'));
1147:
1148: --get subject
1149: l_from := fnd_profile.value('OKL_VND_NOTIFY_EMAIL_FROM');
1150:

Line 1149: l_from := fnd_profile.value('OKL_VND_NOTIFY_EMAIL_FROM');

1145: --get content_id
1146: l_content_id := to_number(fnd_profile.value('OKL_VND_NOTIFY_TEMPLATE'));
1147:
1148: --get subject
1149: l_from := fnd_profile.value('OKL_VND_NOTIFY_EMAIL_FROM');
1150:
1151: l_case_number := wf_engine.GetItemAttrText(itemtype => itemtype,
1152: itemkey => itemkey,
1153: aname => 'CASE_NUMBER');