[Home] [Help]
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_khr_id IN okc_k_headers_b.id%TYPE,
115: p_id IN OKL_TRX_AP_INVOICES_B.id%TYPE,
116: p_event_name IN wf_events.name%TYPE) IS
117:
118: l_parameter_list wf_parameter_list_t;
119: BEGIN
120: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_khr_id,l_parameter_list);
116: p_event_name IN wf_events.name%TYPE) IS
117:
118: l_parameter_list wf_parameter_list_t;
119: BEGIN
120: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_khr_id,l_parameter_list);
121: wf_event.AddParameterToList(G_WF_ITM_FUN_REQ_ID,p_id,l_parameter_list);
122:
123:
124: OKL_WF_PVT.raise_event (p_api_version => p_api_version,
117:
118: l_parameter_list wf_parameter_list_t;
119: BEGIN
120: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_khr_id,l_parameter_list);
121: wf_event.AddParameterToList(G_WF_ITM_FUN_REQ_ID,p_id,l_parameter_list);
122:
123:
124: OKL_WF_PVT.raise_event (p_api_version => p_api_version,
125: p_init_msg_list => p_init_msg_list,
5551: l_approval_option varchar2(10);
5552:
5553: -- vthiruva, 08/31/2004
5554: -- variables to raise business events
5555: l_event_name wf_events.name%TYPE := null;
5556: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
5557:
5558: cursor c_chklst_exists(p_fund_id varchar2) is
5559: --start modified abhsaxen for performance SQLID 20562448
5680: RAISE OKL_API.G_EXCEPTION_ERROR;
5681: END IF;
5682:
5683: -----------------------------------------------------------
5684: -- trigger WF event if l_tapv_rec.trx_status_code = 'SUBMITTED' and
5685: -- profile option is WF or AME
5686: -----------------------------------------------------------
5687: IF (l_tapv_rec.trx_status_code = 'SUBMITTED' AND
5688: l_approval_option in ('WF', 'AME')) THEN