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_PVT dependencies on OKL_K_HEADERS

Line 1246: l_pdt_id Okl_k_headers.pdt_id%type;

1242: l_fund_line_id NUMBER;
1243:
1244: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
1245: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_TBL_TYPE;
1246: l_pdt_id Okl_k_headers.pdt_id%type;
1247: l_ctxt_val_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
1248: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1249: l_template_tbl Okl_Account_Dist_Pvt.AVLV_OUT_TBL_TYPE;
1250: l_amount_tbl Okl_Account_Dist_Pvt.AMOUNT_OUT_TBL_TYPE;

Line 1279: FROM okl_k_headers_full_v chr

1275: IS
1276: SELECT pdt_id,
1277: --Bug# 4622198
1278: scs_code
1279: FROM okl_k_headers_full_v chr
1280: where chr.id = p_chr_id
1281: ;
1282:
1283: CURSOR trans_csr(p_trx_name VARCHAR2)

Line 1368: FROM okl_k_headers chr,

1364: SELECT khr.currency_code
1365: ,chr.currency_conversion_type
1366: ,chr.currency_conversion_rate
1367: ,chr.currency_conversion_date
1368: FROM okl_k_headers chr,
1369: okc_k_headers_b khr
1370: WHERE chr.id = khr.id
1371: AND khr.id = p_khr_id;
1372:

Line 1765: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

1761: IS
1762: l_row_notfound boolean := false;
1763: l_yn number := 0;
1764: l_sts_code OKC_K_HEADERS_B.sts_code%TYPE;
1765: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
1766:
1767: CURSOR c_deal_type(p_contract_id NUMBER)
1768: IS
1769: select chr.sts_code,

Line 1771: from OKL_K_HEADERS khr,

1767: CURSOR c_deal_type(p_contract_id NUMBER)
1768: IS
1769: select chr.sts_code,
1770: khr.deal_type
1771: from OKL_K_HEADERS khr,
1772: OKC_K_HEADERS_B chr
1773: where khr.id = chr.id
1774: and khr.id = p_contract_id
1775: ;

Line 1921: select 1 from OKL_K_HEADERS khr

1917: --END:bug#4882537
1918:
1919: CURSOR c_loan_revolving (p_contract_id NUMBER)
1920: IS
1921: select 1 from OKL_K_HEADERS khr
1922: where khr.id = p_contract_id
1923: and khr.deal_type = 'LOAN-REVOLVING';
1924:
1925: BEGIN

Line 1985: select 1 from OKL_K_HEADERS khr

1981: l_credit_id NUMBER;
1982:
1983: CURSOR c_loan_revolving (p_contract_id NUMBER)
1984: IS
1985: select 1 from OKL_K_HEADERS khr
1986: where khr.id = p_contract_id
1987: and khr.deal_type = 'LOAN-REVOLVING';
1988:
1989: BEGIN

Line 3285: select 1 from OKL_K_HEADERS khr

3281:
3282: -- bug 2604862
3283: CURSOR c_loan_revolving (p_contract_id NUMBER)
3284: IS
3285: select 1 from OKL_K_HEADERS khr
3286: where khr.id = p_contract_id
3287: and khr.deal_type = 'LOAN-REVOLVING';
3288:
3289: BEGIN

Line 3579: select 1 from OKL_K_HEADERS khr

3575: -- bug 2604862
3576: CURSOR c_loan_revolving (p_contract_id NUMBER)
3577:
3578: IS
3579: select 1 from OKL_K_HEADERS khr
3580: where khr.id = p_contract_id
3581: and khr.deal_type = 'LOAN-REVOLVING';
3582:
3583: BEGIN

Line 3874: l_REVOLVING_CREDIT_YN OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE;

3870: IS
3871:
3872: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3873:
3874: l_REVOLVING_CREDIT_YN OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE;
3875: l_END_DATE OKC_K_HEADERS_B.END_DATE%TYPE;
3876:
3877: l_DEAL_TYPE OKL_K_HEADERS.DEAL_TYPE%TYPE;
3878: l_creditline_row_found boolean := false;

Line 3877: l_DEAL_TYPE OKL_K_HEADERS.DEAL_TYPE%TYPE;

3873:
3874: l_REVOLVING_CREDIT_YN OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE;
3875: l_END_DATE OKC_K_HEADERS_B.END_DATE%TYPE;
3876:
3877: l_DEAL_TYPE OKL_K_HEADERS.DEAL_TYPE%TYPE;
3878: l_creditline_row_found boolean := false;
3879: l_credit_id okc_k_headers_b.id%TYPE;
3880:
3881: CURSOR c_contract (p_contract_id NUMBER)

Line 3884: from OKL_K_HEADERS a

3880:
3881: CURSOR c_contract (p_contract_id NUMBER)
3882: IS
3883: select a.DEAL_TYPE
3884: from OKL_K_HEADERS a
3885: where a.id = p_contract_id
3886: ;
3887:
3888: CURSOR c_credit (p_credit_id NUMBER)

Line 3892: from okl_k_headers khr,

3888: CURSOR c_credit (p_credit_id NUMBER)
3889: IS
3890: select khr.REVOLVING_CREDIT_YN,
3891: NVL(chr.END_DATE, SYSDATE)
3892: from okl_k_headers khr,
3893: okc_k_headers_b chr
3894: where khr.id = chr.id
3895: and chr.id = p_credit_id
3896: ;

Line 4047: from OKL_K_HEADERS khr

4043: l_lv_found boolean;
4044:
4045: cursor c_rl(p_khr_id number) is
4046: select 1
4047: from OKL_K_HEADERS khr
4048: where khr.id = p_khr_id
4049: and khr.deal_type = 'LOAN-REVOLVING';
4050:
4051: cursor c_lv(p_khr_id number) is

Line 4125: l_prefunding_eligible_yn okl_k_headers.PREFUNDING_ELIGIBLE_YN%type;

4121: IS
4122: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4123: l_loan_rev NUMBER := 0;
4124: l_loan_row_found boolean := false;
4125: l_prefunding_eligible_yn okl_k_headers.PREFUNDING_ELIGIBLE_YN%type;
4126: l_trx_status_code okl_trx_ap_invoices_b.trx_status_code%type;
4127: l_reverse_row_notfound boolean := false;
4128: l_dummy number;
4129:

Line 4133: from OKL_K_HEADERS khr

4129:
4130: CURSOR c_prefund (p_contract_id NUMBER)
4131: IS
4132: select nvl(khr.PREFUNDING_ELIGIBLE_YN, 'N')
4133: from OKL_K_HEADERS khr
4134: where khr.id = p_contract_id
4135: ;
4136:
4137: CURSOR c_curr_trx_sts (p_req_id NUMBER)

Line 4148: select 1 from OKL_K_HEADERS khr

4144:
4145: -- bug 2604862
4146: CURSOR c_loan_revolving (p_contract_id NUMBER)
4147: IS
4148: select 1 from OKL_K_HEADERS khr
4149: where khr.id = p_contract_id
4150: and khr.deal_type = 'LOAN-REVOLVING';
4151:
4152: -- cklee 09-24-03