DBA Data[Home] [Help]

APPS.OKL_VP_PA_WF dependencies on OKL_VP_PA_WF

Line 1: PACKAGE BODY okl_vp_pa_wf AS

1: PACKAGE BODY okl_vp_pa_wf AS
2: /* $Header: OKLRPAWB.pls 120.1 2006/07/21 13:13:18 akrangan 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 251: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_PA_WF.RAISE_PA_EVENT_APPROVAL';

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

Line 448: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_PA_WF.GET_AGRMNT_APPROVER';

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

Line 476: avalue => 'plsql:okl_vp_pa_wf.get_msg_doc/'||itemkey

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

Line 510: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_PA_WF.UPDATE_AGRMNT_STATUS';

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

Line 604: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_PA_WF.PROCESS_PA_FOR_AME';

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

Line 667: avalue => 'plsql:okl_vp_pa_wf.get_msg_doc/'||itemkey

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

Line 690: END okl_vp_pa_wf;

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