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_OA_WF dependencies on OKC_K_HEADERS_B

Line 105: lv_agreement_number okc_k_headers_b.contract_number%TYPE;

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

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

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

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

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

Line 197: lv_agreement_id okc_k_headers_b.id%TYPE;

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

Line 213: ,p_chr_id IN okc_k_headers_b.id%TYPE

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

Line 215: CURSOR c_get_oa_num_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS

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

Line 218: FROM okc_k_headers_b

214: ) IS
215: CURSOR c_get_oa_num_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
216: SELECT id
217: ,contract_number
218: FROM okc_k_headers_b
219: WHERE id = cp_chr_id;
220: cv_get_oa_num c_get_oa_num_csr%ROWTYPE;
221: -- Get the valid application id from FND
222: CURSOR c_get_app_id_csr IS

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

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

Line 513: lv_agreement_id okc_k_headers_b.id%TYPE;

509: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.UPDATE_AGRMNT_STATUS';
510: l_debug_enabled VARCHAR2(10);
511: lv_approval_status VARCHAR2(10);
512: lv_approval_status_ame VARCHAR2(10);
513: lv_agreement_id okc_k_headers_b.id%TYPE;
514: BEGIN
515: l_debug_enabled := okl_debug_pub.check_log_enabled;
516: IF(l_debug_enabled='Y') THEN
517: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug update_agrmnt_status');

Line 605: lv_agreement_id okc_k_headers_b.id%TYPE;

601: ,resultout OUT NOCOPY VARCHAR2) IS
602: l_api_name CONSTANT VARCHAR2(200) DEFAULT 'process_oa_for_ame';
603: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.PROCESS_OA_FOR_AME';
604: l_debug_enabled VARCHAR2(10);
605: lv_agreement_id okc_k_headers_b.id%TYPE;
606: BEGIN
607: IF(funcmode = 'RUN')THEN
608: lv_agreement_id := wf_engine.GetItemAttrText(itemtype => itemtype
609: ,itemkey => itemkey