DBA Data[Home] [Help]

APPS.OKL_VP_CR_WF dependencies on OKL_VP_CR_WF

Line 1: PACKAGE BODY okl_vp_cr_wf AS

1: PACKAGE BODY okl_vp_cr_wf AS
2: /* $Header: OKLRCRWB.pls 120.3 2006/09/22 13:45:35 varangan 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 307: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CR_WF.RAISE_CR_EVENT_APPROVAL';

303:
304: l_api_version CONSTANT NUMBER DEFAULT 1.0;
305: l_approval_process fnd_lookups.lookup_code%TYPE;
306: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_pa_FOR_APPROVAL';
307: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CR_WF.RAISE_CR_EVENT_APPROVAL';
308: l_debug_enabled VARCHAR2(10);
309:
310: BEGIN
311: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 501: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CR_WF.GET_AGRMNT_APPROVER';

497:
498: l_user_id VARCHAR2(200);
499: lv_requestor VARCHAR2(100);
500:
501: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CR_WF.GET_AGRMNT_APPROVER';
502: l_debug_enabled VARCHAR2(10);
503:
504: BEGIN
505: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 529: avalue => 'plsql:okl_vp_cr_wf.get_msg_doc/'||itemkey

525:
526: wf_engine.SetItemAttrText (itemtype => itemtype,
527: itemkey => itemkey,
528: aname => G_WF_ITM_MESSAGE_BODY,
529: avalue => 'plsql:okl_vp_cr_wf.get_msg_doc/'||itemkey
530: );
531: resultout := 'COMPLETE:Y';
532: END LOOP;
533: END IF; -- l_user_id

Line 573: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CR_WF.UPDATE_CR_STATUS';

569: x_return_status VARCHAR2(10);
570: x_msg_data VARCHAR2(1000);
571: x_msg_count NUMBER;
572: l_api_name CONSTANT VARCHAR2(200) DEFAULT 'update_cr_status';
573: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CR_WF.UPDATE_CR_STATUS';
574: l_debug_enabled VARCHAR2(10);
575: lv_approval_status VARCHAR2(10);
576: lv_approval_status_ame VARCHAR2(10);
577: lv_change_req_id okl_vp_change_requests.id%TYPE;

Line 707: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CR_WF.PROCESS_CR_FOR_AME';

703: ,actid IN NUMBER
704: ,funcmode IN VARCHAR2
705: ,resultout OUT NOCOPY VARCHAR2) IS
706: l_api_name CONSTANT VARCHAR2(200) DEFAULT 'process_cr_for_ame';
707: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CR_WF.PROCESS_CR_FOR_AME';
708: l_debug_enabled VARCHAR2(10);
709: lv_change_req_id okl_vp_change_requests.id%TYPE;
710: BEGIN
711: IF(funcmode = 'RUN')THEN

Line 770: avalue => 'plsql:okl_vp_cr_wf.get_msg_doc/'||itemkey

766: END IF;
767: wf_engine.SetItemAttrText (itemtype => itemtype,
768: itemkey => itemkey,
769: aname => G_WF_ITM_MESSAGE_BODY,
770: avalue => 'plsql:okl_vp_cr_wf.get_msg_doc/'||itemkey
771: );
772: resultout := 'COMPLETE:';
773: END IF; -- end of run mode
774:

Line 793: END okl_vp_cr_wf;

789: wf_core.context(G_PKG_NAME,l_api_name,itemtype,itemkey,TO_CHAR(actid),funcmode);
790: RAISE;
791: END set_msg_attributes;
792:
793: END okl_vp_cr_wf;