DBA Data[Home] [Help]

APPS.OKL_VP_OA_WF dependencies on OKL_VP_OA_WF

Line 1: PACKAGE BODY okl_vp_oa_wf AS

1: PACKAGE BODY okl_vp_oa_wf AS
2: /* $Header: OKLROAWB.pls 120.2 2006/09/29 12:13:15 ssdeshpa noship $ */
3:
4: G_NO_MATCHING_RECORD CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_LLA_NO_MATCHING_RECORD';
5: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

Line 249: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.RAISE_OA_EVENT_APPROVAL';

245:
246: l_api_version CONSTANT NUMBER DEFAULT 1.0;
247: l_approval_process fnd_lookups.lookup_code%TYPE;
248: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_pa_FOR_APPROVAL';
249: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.RAISE_OA_EVENT_APPROVAL';
250: l_debug_enabled VARCHAR2(10);
251:
252: BEGIN
253: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 447: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.GET_AGRMNT_APPROVER';

443:
444: l_user_id VARCHAR2(200);
445: lv_requestor VARCHAR2(100);
446:
447: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.GET_AGRMNT_APPROVER';
448: l_debug_enabled VARCHAR2(10);
449:
450: BEGIN
451: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 475: avalue => 'plsql:okl_vp_oa_wf.get_msg_doc/'||itemkey

471:
472: wf_engine.SetItemAttrText (itemtype => itemtype,
473: itemkey => itemkey,
474: aname => G_WF_ITM_MESSAGE_BODY,
475: avalue => 'plsql:okl_vp_oa_wf.get_msg_doc/'||itemkey
476: );
477: resultout := 'COMPLETE:Y';
478: END LOOP;
479: END IF; -- l_user_id

Line 509: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.UPDATE_AGRMNT_STATUS';

505: x_return_status VARCHAR2(10);
506: x_msg_data VARCHAR2(1000);
507: x_msg_count NUMBER;
508: l_api_name CONSTANT VARCHAR2(200) DEFAULT 'update_agrmnt_status';
509: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.UPDATE_AGRMNT_STATUS';
510: l_debug_enabled VARCHAR2(10);
511: lv_approval_status VARCHAR2(10);
512: lv_approval_status_ame VARCHAR2(10);
513: lv_agreement_id okc_k_headers_b.id%TYPE;

Line 603: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.PROCESS_OA_FOR_AME';

599: ,actid IN NUMBER
600: ,funcmode IN VARCHAR2
601: ,resultout OUT NOCOPY VARCHAR2) IS
602: l_api_name CONSTANT VARCHAR2(200) DEFAULT 'process_oa_for_ame';
603: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.PROCESS_OA_FOR_AME';
604: l_debug_enabled VARCHAR2(10);
605: lv_agreement_id okc_k_headers_b.id%TYPE;
606: BEGIN
607: IF(funcmode = 'RUN')THEN

Line 666: avalue => 'plsql:okl_vp_oa_wf.get_msg_doc/'||itemkey

662: END IF;
663: wf_engine.SetItemAttrText (itemtype => itemtype,
664: itemkey => itemkey,
665: aname => G_WF_ITM_MESSAGE_BODY,
666: avalue => 'plsql:okl_vp_oa_wf.get_msg_doc/'||itemkey
667: );
668: resultout := 'COMPLETE:';
669: END IF; -- end of run mode
670:

Line 689: END okl_vp_oa_wf;

685: wf_core.context(G_PKG_NAME,l_api_name,itemtype,itemkey,TO_CHAR(actid),funcmode);
686: RAISE;
687: END set_msg_attributes;
688:
689: END okl_vp_oa_wf;