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_CREDIT_LINE_WF dependencies on OKC_K_HEADERS_V

Line 144: p_khr_status IN OKC_K_HEADERS_V.STS_CODE%TYPE,

140: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_khr_status IN OKC_K_HEADERS_V.STS_CODE%TYPE,
145: p_chr_id IN NUMBER) IS
146:
147: l_api_name CONSTANT VARCHAR2(30) := 'l_change_k_status';
148: lx_khr_status varchar2(30);

Line 276: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)

272: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE)
273: IS
274:
275: -- Get Contract Details
276: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)
277: IS
278: SELECT chrv.contract_number,
279: chrv.sts_code
280: FROM okc_k_headers_v chrv

Line 280: FROM okc_k_headers_v chrv

276: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)
277: IS
278: SELECT chrv.contract_number,
279: chrv.sts_code
280: FROM okc_k_headers_v chrv
281: WHERE chrv.id = p_contract_id;
282:
283: -- Get the valid application id from FND
284: CURSOR c_get_app_id_csr

Line 330: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

326: l_event_name VARCHAR2(240);
327: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
328: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
329: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
330: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
331: l_chrv_id OKC_K_HEADERS_V.ID%TYPE ;
332: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
333: l_requester VARCHAR2(200);
334: l_name VARCHAR2(200);

Line 331: l_chrv_id OKC_K_HEADERS_V.ID%TYPE ;

327: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
328: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
329: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
330: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
331: l_chrv_id OKC_K_HEADERS_V.ID%TYPE ;
332: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
333: l_requester VARCHAR2(200);
334: l_name VARCHAR2(200);
335: l_requester_id VARCHAR2(200);

Line 332: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;

328: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
329: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
330: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
331: l_chrv_id OKC_K_HEADERS_V.ID%TYPE ;
332: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
333: l_requester VARCHAR2(200);
334: l_name VARCHAR2(200);
335: l_requester_id VARCHAR2(200);
336: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

Line 420: p_token1_value => 'OKC_K_HEADERS_V.ID');

416: IF c_fetch_k_number%NOTFOUND THEN
417: OKL_API.set_message(p_app_name => G_APP_NAME,
418: p_msg_name => G_NO_MATCHING_RECORD,
419: p_token1 => G_COL_NAME_TOKEN,
420: p_token1_value => 'OKC_K_HEADERS_V.ID');
421: RAISE OKL_API.G_EXCEPTION_ERROR;
422: END IF;
423: CLOSE c_fetch_k_number;
424:

Line 594: CURSOR l_okl_crtline_csr(p_contract_id OKC_K_HEADERS_V.ID%TYPE)

590: FUNCTION compile_message(p_contract_id IN NUMBER)
591: RETURN VARCHAR2
592: IS
593:
594: CURSOR l_okl_crtline_csr(p_contract_id OKC_K_HEADERS_V.ID%TYPE)
595: IS
596: SELECT ID,
597: CONTRACT_NUMBER,
598: DESCRIPTION,

Line 609: CURSOR l_okl_crtline_contents_csr(p_contract_id OKC_K_HEADERS_V.ID%TYPE)

605: END_DATE
606: FROM okl_creditlines_uv
607: WHERE id = p_contract_id;
608:
609: CURSOR l_okl_crtline_contents_csr(p_contract_id OKC_K_HEADERS_V.ID%TYPE)
610: IS
611: SELECT KHR_ID,
612: TODO_ITEM_CODE,
613: TODO_ITEM_MEANING,

Line 913: l_contract_number OKC_K_HEADERS_V.contract_number%TYPE;

909: WHERE user_id = p_user_id;
910:
911: l_api_name CONSTANT VARCHAR2(200) := 'get_credit_line_approver';
912: l_user_id VARCHAR2(200);
913: l_contract_number OKC_K_HEADERS_V.contract_number%TYPE;
914: l_return_status VARCHAR2(1);
915:
916: BEGIN
917: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 996: l_contract_number okc_k_headers_v.contract_number%TYPE;

992: l_parent_key VARCHAR2(240);
993: l_parent_type VARCHAR2(240);
994: l_result VARCHAR2(30);
995: l_api_name CONSTANT VARCHAR2(30) := 'Set_Parent_Attributes';
996: l_contract_number okc_k_headers_v.contract_number%TYPE;
997:
998: BEGIN
999: SAVEPOINT set_atts;
1000: IF (funcmode = 'RUN') THEN

Line 1096: l_chrv_id OKC_K_HEADERS_V.ID%TYPE;

1092: l_msg_count NUMBER;
1093: l_init_msg_list VARCHAR2(10);
1094: l_msg_data VARCHAR2(2000);
1095: l_api_name CONSTANT VARCHAR2(30) := 'update_approval_status';
1096: l_chrv_id OKC_K_HEADERS_V.ID%TYPE;
1097: l_approved_yn VARCHAR2(30);
1098: l_trx_number VARCHAR2(100);
1099: lv_approval_status_ame VARCHAR2(10);
1100: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

Line 1402: l_contract_number okc_k_headers_v.contract_number%TYPE;

1398: l_key VARCHAR2(240);
1399: l_process VARCHAR2(30);
1400: l_item_type VARCHAR2(10) ;
1401: l_contract_id VARCHAR2(240);
1402: l_contract_number okc_k_headers_v.contract_number%TYPE;
1403: l_requester VARCHAR2(240);
1404: l_requester_id VARCHAR2(240);
1405: l_api_name CONSTANT VARCHAR2(30) := 'wf_Approval_Process';
1406: