APPS.OKL_VP_CR_WF dependencies on OKL_VP_CHANGE_REQUESTS

Line 128: FUNCTION compile_message_body(p_change_request_id IN okl_vp_change_requests.id%TYPE) RETURN VARCHAR2 IS

124: );
125:
126: END set_attrib_message;
127:
128: FUNCTION compile_message_body(p_change_request_id IN okl_vp_change_requests.id%TYPE) RETURN VARCHAR2 IS
129: -- cursor that picks up the agreement details
130: -- for an AGREEMENT type of change request, the copy agreement is displayed
131: -- for ASSOCIATION type of change requst, the original agreement is displayed
132: CURSOR c_get_creq_dtls_csr(cp_change_request_id okl_vp_change_requests.id%TYPE)IS

Line 132: CURSOR c_get_creq_dtls_csr(cp_change_request_id okl_vp_change_requests.id%TYPE)IS

128: FUNCTION compile_message_body(p_change_request_id IN okl_vp_change_requests.id%TYPE) RETURN VARCHAR2 IS
129: -- cursor that picks up the agreement details
130: -- for an AGREEMENT type of change request, the copy agreement is displayed
131: -- for ASSOCIATION type of change requst, the original agreement is displayed
132: CURSOR c_get_creq_dtls_csr(cp_change_request_id okl_vp_change_requests.id%TYPE)IS
133: -- this portion of select will work for AGREEMENT type of change requests
134: SELECT agreement.contract_number agreement_number
135: ,subclass.meaning agreement_category
136: ,vendors.vendor_name vendor_name

Line 146: ,okl_vp_change_requests change

142: FROM okc_k_headers_v agreement
143: ,okc_subclasses_v subclass
144: ,po_vendors vendors
145: ,okc_k_party_roles_b party_roles
146: ,okl_vp_change_requests change
147: ,fnd_lookups lookups
148: ,okl_k_headers khr
149: WHERE agreement.scs_code = subclass.code
150: AND party_roles.dnz_chr_id (+) = agreement.id

Line 173: ,okl_vp_change_requests change

169: FROM okc_k_headers_v agreement
170: ,okc_subclasses_v subclass
171: ,po_vendors vendors
172: ,okc_k_party_roles_b party_roles
173: ,okl_vp_change_requests change
174: ,fnd_lookups lookups
175: WHERE agreement.scs_code = subclass.code
176: AND party_roles.dnz_chr_id (+) = agreement.id
177: AND party_roles.rle_code (+) = 'OKL_VENDOR'

Line 202: ''|| Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_VP_CHANGE_REQUESTS'

198:
199: lv_message:= ''||
200: ''||
201: -- first row containing Change Request Number and Change Request Type
202: ''||''||
206: ''||''||
206: ''||
210: ''||

Line 249: lv_change_req_id okl_vp_change_requests.id%TYPE;

245: PROCEDURE get_msg_doc(document_id IN VARCHAR2,
246: display_type IN VARCHAR2,
247: document IN OUT nocopy VARCHAR2,
248: document_type IN OUT nocopy VARCHAR2) IS
249: lv_change_req_id okl_vp_change_requests.id%TYPE;
250: BEGIN
251: lv_change_req_id := wf_engine.GetItemAttrText(itemtype => G_ITEM_TYPE_WF
252: ,itemkey => document_id
253: ,aname => G_WF_ITM_CHANGE_REQUEST_ID);

Line 265: ,p_vp_crq_id IN okl_vp_change_requests.id%TYPE

261: ,p_init_msg_list IN VARCHAR2
262: ,x_return_status OUT NOCOPY VARCHAR2
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

Line 270: FROM okl_vp_change_requests

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;
272: cv_get_cr_num c_get_cr_num_csr%ROWTYPE;
273: -- Get the valid application id from FND
274: CURSOR c_get_app_id_csr IS

Line 560: CURSOR c_get_creq_chr_csr(cp_change_request_id okl_vp_change_requests.id%TYPE)IS

556: ,actid IN NUMBER
557: ,funcmode IN VARCHAR2
558: ,resultout OUT NOCOPY VARCHAR2) IS
559: -- cursor to get the agreement number that was created for the change request
560: CURSOR c_get_creq_chr_csr(cp_change_request_id okl_vp_change_requests.id%TYPE)IS
561: SELECT CASE WHEN (cr.change_type_code = 'AGREEMENT') THEN
562: (SELECT id FROM okl_k_headers WHERE crs_id = cr.id)
563: ELSE cr.chr_id END creq_chr_id
564: ,cr.change_type_code

Line 565: FROM okl_vp_change_requests cr

561: SELECT CASE WHEN (cr.change_type_code = 'AGREEMENT') THEN
562: (SELECT id FROM okl_k_headers WHERE crs_id = cr.id)
563: ELSE cr.chr_id END creq_chr_id
564: ,cr.change_type_code
565: FROM okl_vp_change_requests cr
566: WHERE cr.id = cp_change_request_id;
567: cv_get_creq_chr c_get_creq_chr_csr%ROWTYPE;
568:
569: x_return_status VARCHAR2(10);

Line 577: lv_change_req_id okl_vp_change_requests.id%TYPE;

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;
578: lv_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
579: x_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
580: BEGIN
581: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 709: lv_change_req_id okl_vp_change_requests.id%TYPE;

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
712: lv_change_req_id := wf_engine.GetItemAttrText(itemtype => itemtype
713: ,itemkey => itemkey

'||G_AMP_SIGN||'nbsp;
'|| Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_VP_CHANGE_REQUESTS' 203: ,p_attribute_code => 'CHANGEREQNUM') 204: ||'	'|| G_AMP_SIGN ||'nbsp;' || cv_get_creq_dtls.change_request_number 205: ||'	'||G_AMP_SIGN ||'nbsp;		'||G_AMP_SIGN ||'nbsp;	'|| Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_VP_CHANGE_REQUESTS' Line 206: '	'|| Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_VP_CHANGE_REQUESTS' 202: '
'|| Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_VP_CHANGE_REQUESTS' 203: ,p_attribute_code => 'CHANGEREQNUM') 204: ||'	'|| G_AMP_SIGN ||'nbsp;' || cv_get_creq_dtls.change_request_number 205: ||'	'||G_AMP_SIGN ||'nbsp;		'||G_AMP_SIGN ||'nbsp;	'|| Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_VP_CHANGE_REQUESTS' 207: ,p_attribute_code => 'CHANGEREQTYPE') 208: ||'	'|| G_AMP_SIGN ||'nbsp;' || cv_get_creq_dtls.change_request_type 209: ||'