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 1767: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

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

Line 1773: from OKL_K_HEADERS khr,

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

Line 1943: select 1 from OKL_K_HEADERS khr

1939: --END:bug#4882537
1940:
1941: CURSOR c_loan_revolving (p_contract_id NUMBER)
1942: IS
1943: select 1 from OKL_K_HEADERS khr
1944: where khr.id = p_contract_id
1945: and khr.deal_type = 'LOAN-REVOLVING';
1946:
1947: BEGIN

Line 2007: select 1 from OKL_K_HEADERS khr

2003: l_credit_id NUMBER;
2004:
2005: CURSOR c_loan_revolving (p_contract_id NUMBER)
2006: IS
2007: select 1 from OKL_K_HEADERS khr
2008: where khr.id = p_contract_id
2009: and khr.deal_type = 'LOAN-REVOLVING';
2010:
2011: BEGIN

Line 3415: select 1 from OKL_K_HEADERS khr

3411:
3412: -- bug 2604862
3413: CURSOR c_loan_revolving (p_contract_id NUMBER)
3414: IS
3415: select 1 from OKL_K_HEADERS khr
3416: where khr.id = p_contract_id
3417: and khr.deal_type = 'LOAN-REVOLVING';
3418:
3419: BEGIN

Line 3709: select 1 from OKL_K_HEADERS khr

3705: -- bug 2604862
3706: CURSOR c_loan_revolving (p_contract_id NUMBER)
3707:
3708: IS
3709: select 1 from OKL_K_HEADERS khr
3710: where khr.id = p_contract_id
3711: and khr.deal_type = 'LOAN-REVOLVING';
3712:
3713: BEGIN

Line 4007: l_REVOLVING_CREDIT_YN OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE;

4003: IS
4004:
4005: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4006:
4007: l_REVOLVING_CREDIT_YN OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE;
4008: l_END_DATE OKC_K_HEADERS_B.END_DATE%TYPE;
4009:
4010: l_DEAL_TYPE OKL_K_HEADERS.DEAL_TYPE%TYPE;
4011: l_creditline_row_found boolean := false;

Line 4010: l_DEAL_TYPE OKL_K_HEADERS.DEAL_TYPE%TYPE;

4006:
4007: l_REVOLVING_CREDIT_YN OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE;
4008: l_END_DATE OKC_K_HEADERS_B.END_DATE%TYPE;
4009:
4010: l_DEAL_TYPE OKL_K_HEADERS.DEAL_TYPE%TYPE;
4011: l_creditline_row_found boolean := false;
4012: l_credit_id okc_k_headers_b.id%TYPE;
4013:
4014: CURSOR c_contract (p_contract_id NUMBER)

Line 4017: from OKL_K_HEADERS a

4013:
4014: CURSOR c_contract (p_contract_id NUMBER)
4015: IS
4016: select a.DEAL_TYPE
4017: from OKL_K_HEADERS a
4018: where a.id = p_contract_id
4019: ;
4020:
4021: CURSOR c_credit (p_credit_id NUMBER)

Line 4025: from okl_k_headers khr,

4021: CURSOR c_credit (p_credit_id NUMBER)
4022: IS
4023: select khr.REVOLVING_CREDIT_YN,
4024: NVL(chr.END_DATE, SYSDATE)
4025: from okl_k_headers khr,
4026: okc_k_headers_b chr
4027: where khr.id = chr.id
4028: and chr.id = p_credit_id
4029: ;

Line 4183: from OKL_K_HEADERS khr

4179: l_lv_found boolean;
4180:
4181: cursor c_rl(p_khr_id number) is
4182: select 1
4183: from OKL_K_HEADERS khr
4184: where khr.id = p_khr_id
4185: and khr.deal_type = 'LOAN-REVOLVING';
4186:
4187: cursor c_lv(p_khr_id number) is

Line 4261: l_prefunding_eligible_yn okl_k_headers.PREFUNDING_ELIGIBLE_YN%type;

4257: IS
4258: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4259: l_loan_rev NUMBER := 0;
4260: l_loan_row_found boolean := false;
4261: l_prefunding_eligible_yn okl_k_headers.PREFUNDING_ELIGIBLE_YN%type;
4262: l_trx_status_code okl_trx_ap_invoices_b.trx_status_code%type;
4263: l_reverse_row_notfound boolean := false;
4264: l_dummy number;
4265:

Line 4269: from OKL_K_HEADERS khr

4265:
4266: CURSOR c_prefund (p_contract_id NUMBER)
4267: IS
4268: select nvl(khr.PREFUNDING_ELIGIBLE_YN, 'N')
4269: from OKL_K_HEADERS khr
4270: where khr.id = p_contract_id
4271: ;
4272:
4273: CURSOR c_curr_trx_sts (p_req_id NUMBER)

Line 4284: select 1 from OKL_K_HEADERS khr

4280:
4281: -- bug 2604862
4282: CURSOR c_loan_revolving (p_contract_id NUMBER)
4283: IS
4284: select 1 from OKL_K_HEADERS khr
4285: where khr.id = p_contract_id
4286: and khr.deal_type = 'LOAN-REVOLVING';
4287:
4288: -- cklee 09-24-03