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

Line 387: ,OKC_K_HEADERS_B con

383: -- now resides in this table. changes made as part of OKLR12B disbursements project
384: CURSOR contract_num_csr (p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
385: SELECT con.contract_number,con.id
386: FROM OKL_TRX_AP_INVOICES_B ap_inv
387: ,OKC_K_HEADERS_B con
388: ,okl_txl_ap_inv_lns_all_b tpl
389: WHERE ap_inv.id = tpl.tap_id
390: AND tpl.khr_id = con.id
391: AND ap_inv.id = p_funding_id;

Line 393: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

389: WHERE ap_inv.id = tpl.tap_id
390: AND tpl.khr_id = con.id
391: AND ap_inv.id = p_funding_id;
392:
393: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
394: l_legal_entity_id NUMBER;
395: l_con_id NUMBER;
396:
397: -- Get the valid application id from FND

Line 736: l_creditline_id okc_k_headers_b.id%Type;

732: l_api_version NUMBER := 1;
733: l_init_msg_list VARCHAR2(3) := OKC_API.G_TRUE;
734: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
735:
736: l_creditline_id okc_k_headers_b.id%Type;
737: -- start: cklee 31-May-2005 okl.h Lease App IA Authoring
738: l_flag VARCHAR2(10);
739: l_message VARCHAR2(20000);
740: l_lease_app_found boolean;

Line 744: CURSOR c_creditline(p_creditline_id OKC_K_HEADERS_B.ID%TYPE)

740: l_lease_app_found boolean;
741: l_dummy number;
742: -- end: cklee 31-May-2005 okl.h Lease App IA Authoring
743:
744: CURSOR c_creditline(p_creditline_id OKC_K_HEADERS_B.ID%TYPE)
745: IS
746: SELECT chrb.id,
747: chrb.contract_number creditline,
748: chrb.currency_code

Line 749: FROM okc_k_headers_b chrb

745: IS
746: SELECT chrb.id,
747: chrb.contract_number creditline,
748: chrb.currency_code
749: FROM okc_k_headers_b chrb
750: WHERE chrb.id = p_creditline_id
751: ;
752:
753: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b

Line 809: CURSOR c_contract(p_contract_id OKC_K_HEADERS_B.ID%TYPE)

805: CHECKIST_RESULTS
806: FROM okl_funding_checklists_uv
807: WHERE FUND_REQ_ID = p_funding_id;
808:
809: CURSOR c_contract(p_contract_id OKC_K_HEADERS_B.ID%TYPE)
810: IS
811: select 1
812: from okc_k_headers_b
813: where ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'

Line 812: from okc_k_headers_b

808:
809: CURSOR c_contract(p_contract_id OKC_K_HEADERS_B.ID%TYPE)
810: IS
811: select 1
812: from okc_k_headers_b
813: where ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'
814: and id = p_contract_id;
815: -- end: cklee 31-May-2005 okl.h Lease App IA Authoring
816:

Line 1496: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;

1492: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1493: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1494:
1495: -- variables for bug 4900097 - Start
1496: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
1497: l_khr_id OKC_K_HEADERS_B.ID%TYPE;
1498: -- variables for bug 4900097 - End
1499:
1500: --For bug 8788410 - NIKSHAH: START

Line 1497: l_khr_id OKC_K_HEADERS_B.ID%TYPE;

1493: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1494:
1495: -- variables for bug 4900097 - Start
1496: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
1497: l_khr_id OKC_K_HEADERS_B.ID%TYPE;
1498: -- variables for bug 4900097 - End
1499:
1500: --For bug 8788410 - NIKSHAH: START
1501: l_orig_access_mode VARCHAR2(3) := MO_GLOBAL.GET_ACCESS_MODE;