APPS.OKL_STRY_CALL_CO_PUB dependencies on FND_PROFILE

Line 283: l_agent_id NUMBER := to_number(fnd_profile.value('OKL_FULFILLMENT_USER'));

279:
280: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
281: l_subject VARCHAR2(2000);
282: l_from VARCHAR2(2000);
283: l_agent_id NUMBER := to_number(fnd_profile.value('OKL_FULFILLMENT_USER'));
284: l_request_id NUMBER;
285:
286: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE :=
287: to_number(fnd_profile.value('OKL_VND_APPROVAL_TEMPLATE'));

Line 287: to_number(fnd_profile.value('OKL_VND_APPROVAL_TEMPLATE'));

283: l_agent_id NUMBER := to_number(fnd_profile.value('OKL_FULFILLMENT_USER'));
284: l_request_id NUMBER;
285:
286: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE :=
287: to_number(fnd_profile.value('OKL_VND_APPROVAL_TEMPLATE'));
288: l_content_name JTF_FM_TEMPLATE_CONTENTS.content_name%TYPE;
289: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
290: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
291: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

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

351: --l_agent_id :=1001646;
352:
353:
354: -- populate from to
355: l_from := fnd_profile.value('OKL_VND_APPROVAL_EMAIL_FROM');
356:
357: If l_from is null THEN
358: result := wf_engine.eng_completed ||':'||wf_no;
359: return;

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

359: return;
360: end if;
361:
362: --populate l_subject
363: l_subject := fnd_profile.value('OKL_VND_APPROVAL_EMAIL_SUBJECT');
364: if l_subject is null THEN
365: l_subject := 'Vendor Approval needed for strategy '
366: ||l_strategy_id || ' and Work item '||l_work_item_id;
367: end if;

Line 404: l_content_id :=to_number(fnd_profile.value('OKL_WRITE_CUST_TEMPLATE'));

400: return;
401: end if;
402:
403: if itemtype ='OKLCOWRI' THEN
404: l_content_id :=to_number(fnd_profile.value('OKL_WRITE_CUST_TEMPLATE'));
405: end if;
406:
407: If l_content_id is null THEN
408: result := wf_engine.eng_completed ||':'||wf_no;