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

Line 419: l_chr_id okl_k_headers.id%type;

415: type rule_curs_type is REF CURSOR;
416: rule_curs rule_curs_type;
417:
418: row_count Number default 0;
419: l_chr_id okl_k_headers.id%type;
420: l_rdf_code okc_rules_v.rule_information_category%type;
421: l_rgd_code okc_rule_groups_v.rgd_code%type;
422:
423:

Line 885: l_chr_id okl_k_headers.id%type;

881: row_count Number default 0;
882:
883:
884:
885: l_chr_id okl_k_headers.id%type;
886: l_rdf_code okc_rules_v.rule_information_category%type;
887: l_rgd_code okc_rule_groups_v.rgd_code%type;
888:
889:

Line 1437: l_chr_id okl_k_headers.id%type;

1433: row_count Number default 0;
1434:
1435:
1436:
1437: l_chr_id okl_k_headers.id%type;
1438: l_rle_code okc_k_party_roles_v.rle_code%type;
1439: l_cle_id okl_k_lines.id%type;
1440: l_lty_code okc_line_styles_b.lty_code%type;
1441:

Line 1896: l_chr_id okl_k_headers.id%type;

1892: party_curs party_curs_type;
1893:
1894: row_count Number default 0;
1895:
1896: l_chr_id okl_k_headers.id%type;
1897: l_rle_code okc_k_party_roles_v.rle_code%type;
1898: l_cle_id okl_k_lines.id%type;
1899: l_lty_code okc_line_styles_b.lty_code%type;
1900:

Line 2361: l_chr_id okl_k_headers.id%type;

2357:
2358: row_count Number default 0;
2359:
2360:
2361: l_chr_id okl_k_headers.id%type;
2362: l_parent_cle_id okl_k_lines.id%type;
2363: l_cle_id okl_k_lines.id%type;
2364: l_lty_code okc_line_styles_b.lty_code%type;
2365:

Line 3439: l_chr_id okl_k_headers.id%type;

3435: row_count Number default 0;
3436:
3437:
3438:
3439: l_chr_id okl_k_headers.id%type;
3440: l_cle_id okl_k_lines.id%type;
3441: l_cle_id okl_k_lines.id%type;
3442: l_lty_code okc_line_styles_b.lty_code%type;
3443:

Line 5014: l_chr_id okl_k_headers.id%type;

5010:
5011: row_count Number default 0;
5012:
5013:
5014: l_chr_id okl_k_headers.id%type;
5015: l_cle_id okl_k_lines.id%type;
5016: l_cle_id okl_k_lines.id%type;
5017: l_lty_code okc_line_styles_b.lty_code%type;
5018:

Line 6799: l_cl_rev_yn okl_k_headers.revolving_credit_yn%type := null;

6795: l_mla_no okc_k_headers_b.contract_number%type := null;
6796: l_fund_yn varchar2(1) := null;
6797: l_mla_cl_yn varchar2(1) := null;
6798: l_yes varchar2(1) := null;
6799: l_cl_rev_yn okl_k_headers.revolving_credit_yn%type := null;
6800: l_mla_cl_rev_yn okl_k_headers.revolving_credit_yn%type := null;
6801:
6802: cursor is_cl_exsts_csr is
6803: select cl.id, cl.contract_number

Line 6800: l_mla_cl_rev_yn okl_k_headers.revolving_credit_yn%type := null;

6796: l_fund_yn varchar2(1) := null;
6797: l_mla_cl_yn varchar2(1) := null;
6798: l_yes varchar2(1) := null;
6799: l_cl_rev_yn okl_k_headers.revolving_credit_yn%type := null;
6800: l_mla_cl_rev_yn okl_k_headers.revolving_credit_yn%type := null;
6801:
6802: cursor is_cl_exsts_csr is
6803: select cl.id, cl.contract_number
6804: from okc_governances gvr,

Line 6807: okl_k_headers khr

6803: select cl.id, cl.contract_number
6804: from okc_governances gvr,
6805: okc_k_headers_b chr,
6806: okc_k_headers_b cl,
6807: okl_k_headers khr
6808: where chr.id = gvr.chr_id
6809: and chr.id = gvr.dnz_chr_id
6810: and gvr.cle_id is null
6811: and gvr.chr_id_referred = cl.id

Line 6821: okl_k_headers khr

6817: select 'Y'
6818: from okc_governances gvr,
6819: okc_k_headers_b mla,
6820: okc_k_headers_b cl,
6821: okl_k_headers khr
6822: where mla.id = gvr.chr_id
6823: and mla.id = gvr.dnz_chr_id
6824: and gvr.cle_id is null
6825: and gvr.chr_id_referred = cl.id

Line 6837: * okl_k_headers khr

6833: * select cl.id, mla.contract_number, khr.revolving_credit_yn
6834: * from okc_governances gvr,
6835: * okc_k_headers_b mla,
6836: * okc_k_headers_b cl,
6837: * okl_k_headers khr
6838: * where mla.id = gvr.chr_id
6839: * and mla.id = gvr.dnz_chr_id
6840: * and gvr.cle_id is null
6841: * and gvr.chr_id_referred = cl.id

Line 6860: okl_k_headers khr,

6856: select cl.id, mla.contract_number, khr.revolving_credit_yn
6857: from okc_governances gvr,
6858: okc_k_headers_b mla,
6859: okc_k_headers_b cl,
6860: okl_k_headers khr,
6861: okc_governances mla_gvr
6862: where mla.id = gvr.chr_id
6863: and mla.id = gvr.dnz_chr_id
6864: and gvr.cle_id is null

Line 6883: okl_k_headers khr

6879:
6880: cursor is_cl_revlvng_csr(l_cl_no in varchar2) is
6881: select khr.revolving_credit_yn
6882: from okc_k_headers_b cl1,
6883: okl_k_headers khr
6884: where cl1.scs_code = 'CREDITLINE_CONTRACT'
6885: and khr.id = cl1.id
6886: and cl1.contract_number = l_cl_no;
6887:

Line 6893: okl_k_headers khr

6889: select khr.revolving_credit_yn
6890: from okc_governances gvr,
6891: okc_k_headers_b mla,
6892: okc_k_headers_b cl,
6893: okl_k_headers khr
6894: where mla.id = gvr.chr_id
6895: and mla.id = gvr.dnz_chr_id
6896: and gvr.cle_id is null
6897: and gvr.chr_id_referred = cl.id

Line 6904: from okl_k_headers_full_v

6900: and mla.contract_number = p_mla_no;
6901:
6902: cursor get_k_id_csr(p_k_no IN VARCHAR2) is
6903: select id
6904: from okl_k_headers_full_v
6905: where contract_number = p_k_no;
6906:
6907: BEGIN
6908:

Line 7201: l_chr_id okl_k_headers_full_v.id%type;

7197: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7198: l_object_code VARCHAR2(30) Default Null;
7199:
7200: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
7201: l_chr_id okl_k_headers_full_v.id%type;
7202: l_revolving_credit_yn okl_k_headers_full_v.revolving_credit_yn%type;
7203: l_row_count number;
7204: l_currency_code fnd_currencies_vl.currency_code%type := null;
7205:

Line 7202: l_revolving_credit_yn okl_k_headers_full_v.revolving_credit_yn%type;

7198: l_object_code VARCHAR2(30) Default Null;
7199:
7200: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
7201: l_chr_id okl_k_headers_full_v.id%type;
7202: l_revolving_credit_yn okl_k_headers_full_v.revolving_credit_yn%type;
7203: l_row_count number;
7204: l_currency_code fnd_currencies_vl.currency_code%type := null;
7205:
7206: cursor l_chk_cust_acc_csr(p_cust_acc_id1 VARCHAR2, p_name VARCHAR2) is

Line 7222: from OKL_k_headers_full_V

7218: and nvl(to_date,p_start_date+1) > p_start_date;
7219:
7220: cursor l_mla_csr is
7221: select id
7222: from OKL_k_headers_full_V
7223: where contract_number = p_mla_no
7224: and scs_code = 'MASTER_LEASE'
7225: and STS_CODE = 'ACTIVE'
7226: and TEMPLATE_YN = 'N'

Line 7231: from OKL_k_headers_full_V prg_hdr

7227: and BUY_OR_SELL = 'S';
7228:
7229: cursor l_program_csr is
7230: select id
7231: from OKL_k_headers_full_V prg_hdr
7232: where contract_number = p_program_no
7233: and scs_code = 'PROGRAM'
7234: and nvl(TEMPLATE_YN, 'N') = 'N'
7235: and sts_code = 'ACTIVE'

Line 7282: l_template_type_code OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE := NULL;

7278: and cle.dnz_chr_id = p_chr_id
7279: and cle.chr_id = p_chr_id
7280: and kle.fee_type = 'ROLLOVER';
7281:
7282: l_template_type_code OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE := NULL;
7283: CURSOR l_tmpl_type_code_csr IS
7284: SELECT chrb.template_yn,
7285: khr.template_type_code
7286: FROM okc_k_headers_b chrb,

Line 7287: okl_k_headers khr

7283: CURSOR l_tmpl_type_code_csr IS
7284: SELECT chrb.template_yn,
7285: khr.template_type_code
7286: FROM okc_k_headers_b chrb,
7287: okl_k_headers khr
7288: WHERE chrb.id = khr.id
7289: AND chrb.id = p_chr_id;
7290:
7291:

Line 9530: l_deal_type okl_k_headers.deal_type%type := null;

9526: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
9527: l_chr_id okc_k_headers_b.id%type := null;
9528: l_k_cl_no okc_k_headers_b.contract_number%type := null;
9529: l_mla_no okc_k_headers_b.contract_number%type := null;
9530: l_deal_type okl_k_headers.deal_type%type := null;
9531:
9532: cursor get_deal_type_csr is
9533: select chr.deal_type
9534: from okl_k_headers chr

Line 9534: from okl_k_headers chr

9530: l_deal_type okl_k_headers.deal_type%type := null;
9531:
9532: cursor get_deal_type_csr is
9533: select chr.deal_type
9534: from okl_k_headers chr
9535: where chr.id = p_chr_id;
9536:
9537: cursor is_cl_exsts_csr is
9538: select cl.contract_number