eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VP_PA_WF dependencies on OKC_K_HEADERS_B

Line 108: lv_agreement_number okc_k_headers_b.contract_number%TYPE;

104: ,itemkey IN VARCHAR2
105: ,message fnd_new_messages.message_name%TYPE
106: ,attrib wf_item_attributes.name%TYPE
107: ) IS
108: lv_agreement_number okc_k_headers_b.contract_number%TYPE;
109: BEGIN
110: -- construct message text for the purpose of subject line of the notification,
111: -- the token is set to AGR_NUMBER for both operating agreement and program agreement
112: lv_agreement_number := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 127: FUNCTION compile_message_body(p_chr_id IN okc_k_headers_b.id%TYPE) RETURN VARCHAR2 IS

123: );
124:
125: END set_attrib_message;
126:
127: FUNCTION compile_message_body(p_chr_id IN okc_k_headers_b.id%TYPE) RETURN VARCHAR2 IS
128: CURSOR c_get_agrmnt_details_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
129: SELECT agreement.contract_number agreement_number
130: ,subclass.meaning agreement_category
131: ,vendors.vendor_name vendor_name

Line 128: CURSOR c_get_agrmnt_details_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS

124:
125: END set_attrib_message;
126:
127: FUNCTION compile_message_body(p_chr_id IN okc_k_headers_b.id%TYPE) RETURN VARCHAR2 IS
128: CURSOR c_get_agrmnt_details_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
129: SELECT agreement.contract_number agreement_number
130: ,subclass.meaning agreement_category
131: ,vendors.vendor_name vendor_name
132: ,agreement.id agreement_id

Line 200: lv_agreement_id okc_k_headers_b.id%TYPE;

196: PROCEDURE get_msg_doc(document_id IN VARCHAR2,
197: display_type IN VARCHAR2,
198: document IN OUT nocopy VARCHAR2,
199: document_type IN OUT nocopy VARCHAR2) IS
200: lv_agreement_id okc_k_headers_b.id%TYPE;
201: BEGIN
202: lv_agreement_id := wf_engine.GetItemAttrText(itemtype => G_ITEM_TYPE_WF
203: ,itemkey => document_id
204: ,aname => G_WF_ITM_AGREEMENT_ID);

Line 215: ,p_chr_id IN okc_k_headers_b.id%TYPE

211: ,p_init_msg_list IN VARCHAR2
212: ,x_return_status OUT NOCOPY VARCHAR2
213: ,x_msg_count OUT NOCOPY NUMBER
214: ,x_msg_data OUT NOCOPY VARCHAR2
215: ,p_chr_id IN okc_k_headers_b.id%TYPE
216: ) IS
217: CURSOR c_get_pa_num_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
218: SELECT id
219: ,contract_number

Line 217: CURSOR c_get_pa_num_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS

213: ,x_msg_count OUT NOCOPY NUMBER
214: ,x_msg_data OUT NOCOPY VARCHAR2
215: ,p_chr_id IN okc_k_headers_b.id%TYPE
216: ) IS
217: CURSOR c_get_pa_num_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
218: SELECT id
219: ,contract_number
220: FROM okc_k_headers_b
221: WHERE id = cp_chr_id;

Line 220: FROM okc_k_headers_b

216: ) IS
217: CURSOR c_get_pa_num_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
218: SELECT id
219: ,contract_number
220: FROM okc_k_headers_b
221: WHERE id = cp_chr_id;
222: cv_get_pa_num c_get_pa_num_csr%ROWTYPE;
223:
224: -- Get the valid application id from FND

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

341:
342: wf_event.AddParameterToList(G_WF_ITM_REQUESTER, l_requester, l_parameter_list);
343: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,fnd_global.user_id,l_parameter_list);
344:
345: -- transaction id is the contract id (okc_k_headers_b.id) this parameter is required to write custom queries in AME
346: -- and use them in conditions and rules
347: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,cv_get_pa_num.id,l_parameter_list);
348: --added by akrangan
349: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);

Line 514: lv_agreement_id okc_k_headers_b.id%TYPE;

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;
515: BEGIN
516: l_debug_enabled := okl_debug_pub.check_log_enabled;
517: IF(l_debug_enabled='Y') THEN
518: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug update_agrmnt_status');

Line 606: lv_agreement_id okc_k_headers_b.id%TYPE;

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
609: lv_agreement_id := wf_engine.GetItemAttrText(itemtype => itemtype
610: ,itemkey => itemkey