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 360: ,OKC_K_HEADERS_B con

356: -- now resides in this table. changes made as part of OKLR12B disbursements project
357: CURSOR contract_num_csr (p_funding_id OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
358: SELECT con.contract_number,con.id
359: FROM OKL_TRX_AP_INVOICES_B ap_inv
360: ,OKC_K_HEADERS_B con
361: ,okl_txl_ap_inv_lns_all_b tpl
362: WHERE ap_inv.id = tpl.tap_id
363: AND tpl.khr_id = con.id
364: AND ap_inv.id = p_funding_id;

Line 366: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

362: WHERE ap_inv.id = tpl.tap_id
363: AND tpl.khr_id = con.id
364: AND ap_inv.id = p_funding_id;
365:
366: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
367: l_legal_entity_id NUMBER;
368: l_con_id NUMBER;
369:
370: -- Get the valid application id from FND

Line 694: l_creditline_id okc_k_headers_b.id%Type;

690: l_api_version NUMBER := 1;
691: l_init_msg_list VARCHAR2(3) := OKC_API.G_TRUE;
692: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
693:
694: l_creditline_id okc_k_headers_b.id%Type;
695: -- start: cklee 31-May-2005 okl.h Lease App IA Authoring
696: l_flag VARCHAR2(10);
697: l_message VARCHAR2(20000);
698: l_lease_app_found boolean;

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

698: l_lease_app_found boolean;
699: l_dummy number;
700: -- end: cklee 31-May-2005 okl.h Lease App IA Authoring
701:
702: CURSOR c_creditline(p_creditline_id OKC_K_HEADERS_B.ID%TYPE)
703: IS
704: SELECT chrb.id,
705: chrb.contract_number creditline,
706: chrb.currency_code

Line 707: FROM okc_k_headers_b chrb

703: IS
704: SELECT chrb.id,
705: chrb.contract_number creditline,
706: chrb.currency_code
707: FROM okc_k_headers_b chrb
708: WHERE chrb.id = p_creditline_id
709: ;
710:
711: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b

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

763: CHECKIST_RESULTS
764: FROM okl_funding_checklists_uv
765: WHERE FUND_REQ_ID = p_funding_id;
766:
767: CURSOR c_contract(p_contract_id OKC_K_HEADERS_B.ID%TYPE)
768: IS
769: select 1
770: from okc_k_headers_b
771: where ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'

Line 770: from okc_k_headers_b

766:
767: CURSOR c_contract(p_contract_id OKC_K_HEADERS_B.ID%TYPE)
768: IS
769: select 1
770: from okc_k_headers_b
771: where ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'
772: and id = p_contract_id;
773: -- end: cklee 31-May-2005 okl.h Lease App IA Authoring
774:

Line 1446: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;

1442: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1443: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1444:
1445: -- variables for bug 4900097 - Start
1446: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
1447: l_khr_id OKC_K_HEADERS_B.ID%TYPE;
1448: -- variables for bug 4900097 - End
1449:
1450:

Line 1447: l_khr_id OKC_K_HEADERS_B.ID%TYPE;

1443: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1444:
1445: -- variables for bug 4900097 - Start
1446: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
1447: l_khr_id OKC_K_HEADERS_B.ID%TYPE;
1448: -- variables for bug 4900097 - End
1449:
1450:
1451: BEGIN