APPS.OKL_VP_CR_WF dependencies on OKC_K_HEADERS_B

Line 111: lv_change_request_num okc_k_headers_b.contract_number%TYPE;

107: ,itemkey IN VARCHAR2
108: ,message fnd_new_messages.message_name%TYPE
109: ,attrib wf_item_attributes.name%TYPE
110: ) IS
111: lv_change_request_num okc_k_headers_b.contract_number%TYPE;
112: BEGIN
113: lv_change_request_num := wf_engine.GetItemAttrText(itemtype => itemtype,
114: itemkey => itemkey,
115: aname => G_WF_ITM_CHANGE_REQUEST_NUM);

Line 267: CURSOR c_get_cr_num_csr(cp_crq_id okc_k_headers_b.id%TYPE)IS

263: ,x_msg_count OUT NOCOPY NUMBER
264: ,x_msg_data OUT NOCOPY VARCHAR2
265: ,p_vp_crq_id IN okl_vp_change_requests.id%TYPE
266: ) IS
267: CURSOR c_get_cr_num_csr(cp_crq_id okc_k_headers_b.id%TYPE)IS
268: SELECT id
269: ,change_request_number
270: FROM okl_vp_change_requests
271: WHERE id = cp_crq_id;

Line 401: -- transaction id is the contract id (okc_k_headers_b.id) this parameter is required to write custom queries in AME

397:
398: wf_event.AddParameterToList(G_WF_ITM_REQUESTER, l_requester, l_parameter_list);
399: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,fnd_global.user_id,l_parameter_list);
400:
401: -- transaction id is the contract id (okc_k_headers_b.id) this parameter is required to write custom queries in AME
402: -- and use them in conditions and rules
403: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,cv_get_cr_num.id,l_parameter_list);
404: --added by akrangan
405: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);