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 435: l_chr_id okl_k_headers.id%type;

431: type rule_curs_type is REF CURSOR;
432: rule_curs rule_curs_type;
433:
434: row_count Number default 0;
435: l_chr_id okl_k_headers.id%type;
436: l_rdf_code okc_rules_v.rule_information_category%type;
437: l_rgd_code okc_rule_groups_v.rgd_code%type;
438:
439:

Line 901: l_chr_id okl_k_headers.id%type;

897: row_count Number default 0;
898:
899:
900:
901: l_chr_id okl_k_headers.id%type;
902: l_rdf_code okc_rules_v.rule_information_category%type;
903: l_rgd_code okc_rule_groups_v.rgd_code%type;
904:
905:

Line 1453: l_chr_id okl_k_headers.id%type;

1449: row_count Number default 0;
1450:
1451:
1452:
1453: l_chr_id okl_k_headers.id%type;
1454: l_rle_code okc_k_party_roles_v.rle_code%type;
1455: l_cle_id okl_k_lines.id%type;
1456: l_lty_code okc_line_styles_b.lty_code%type;
1457:

Line 1912: l_chr_id okl_k_headers.id%type;

1908: party_curs party_curs_type;
1909:
1910: row_count Number default 0;
1911:
1912: l_chr_id okl_k_headers.id%type;
1913: l_rle_code okc_k_party_roles_v.rle_code%type;
1914: l_cle_id okl_k_lines.id%type;
1915: l_lty_code okc_line_styles_b.lty_code%type;
1916:

Line 2377: l_chr_id okl_k_headers.id%type;

2373:
2374: row_count Number default 0;
2375:
2376:
2377: l_chr_id okl_k_headers.id%type;
2378: l_parent_cle_id okl_k_lines.id%type;
2379: l_cle_id okl_k_lines.id%type;
2380: l_lty_code okc_line_styles_b.lty_code%type;
2381:

Line 3455: l_chr_id okl_k_headers.id%type;

3451: row_count Number default 0;
3452:
3453:
3454:
3455: l_chr_id okl_k_headers.id%type;
3456: l_cle_id okl_k_lines.id%type;
3457: l_cle_id okl_k_lines.id%type;
3458: l_lty_code okc_line_styles_b.lty_code%type;
3459:

Line 5030: l_chr_id okl_k_headers.id%type;

5026:
5027: row_count Number default 0;
5028:
5029:
5030: l_chr_id okl_k_headers.id%type;
5031: l_cle_id okl_k_lines.id%type;
5032: l_cle_id okl_k_lines.id%type;
5033: l_lty_code okc_line_styles_b.lty_code%type;
5034:

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

6811: l_mla_no okc_k_headers_b.contract_number%type := null;
6812: l_fund_yn varchar2(1) := null;
6813: l_mla_cl_yn varchar2(1) := null;
6814: l_yes varchar2(1) := null;
6815: l_cl_rev_yn okl_k_headers.revolving_credit_yn%type := null;
6816: l_mla_cl_rev_yn okl_k_headers.revolving_credit_yn%type := null;
6817:
6818: cursor is_cl_exsts_csr is
6819: select cl.id, cl.contract_number

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

6812: l_fund_yn varchar2(1) := null;
6813: l_mla_cl_yn varchar2(1) := null;
6814: l_yes varchar2(1) := null;
6815: l_cl_rev_yn okl_k_headers.revolving_credit_yn%type := null;
6816: l_mla_cl_rev_yn okl_k_headers.revolving_credit_yn%type := null;
6817:
6818: cursor is_cl_exsts_csr is
6819: select cl.id, cl.contract_number
6820: from okc_governances gvr,

Line 6823: okl_k_headers khr

6819: select cl.id, cl.contract_number
6820: from okc_governances gvr,
6821: okc_k_headers_b chr,
6822: okc_k_headers_b cl,
6823: okl_k_headers khr
6824: where chr.id = gvr.chr_id
6825: and chr.id = gvr.dnz_chr_id
6826: and gvr.cle_id is null
6827: and gvr.chr_id_referred = cl.id

Line 6837: okl_k_headers khr

6833: select 'Y'
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 6853: * okl_k_headers khr

6849: * select cl.id, mla.contract_number, khr.revolving_credit_yn
6850: * from okc_governances gvr,
6851: * okc_k_headers_b mla,
6852: * okc_k_headers_b cl,
6853: * okl_k_headers khr
6854: * where mla.id = gvr.chr_id
6855: * and mla.id = gvr.dnz_chr_id
6856: * and gvr.cle_id is null
6857: * and gvr.chr_id_referred = cl.id

Line 6876: okl_k_headers khr,

6872: select cl.id, mla.contract_number, khr.revolving_credit_yn
6873: from okc_governances gvr,
6874: okc_k_headers_b mla,
6875: okc_k_headers_b cl,
6876: okl_k_headers khr,
6877: okc_governances mla_gvr
6878: where mla.id = gvr.chr_id
6879: and mla.id = gvr.dnz_chr_id
6880: and gvr.cle_id is null

Line 6899: okl_k_headers khr

6895:
6896: cursor is_cl_revlvng_csr(l_cl_no in varchar2) is
6897: select khr.revolving_credit_yn
6898: from okc_k_headers_b cl1,
6899: okl_k_headers khr
6900: where cl1.scs_code = 'CREDITLINE_CONTRACT'
6901: and khr.id = cl1.id
6902: and cl1.contract_number = l_cl_no;
6903:

Line 6909: okl_k_headers khr

6905: select khr.revolving_credit_yn
6906: from okc_governances gvr,
6907: okc_k_headers_b mla,
6908: okc_k_headers_b cl,
6909: okl_k_headers khr
6910: where mla.id = gvr.chr_id
6911: and mla.id = gvr.dnz_chr_id
6912: and gvr.cle_id is null
6913: and gvr.chr_id_referred = cl.id

Line 6920: from okl_k_headers_full_v

6916: and mla.contract_number = p_mla_no;
6917:
6918: cursor get_k_id_csr(p_k_no IN VARCHAR2) is
6919: select id
6920: from okl_k_headers_full_v
6921: where contract_number = p_k_no;
6922:
6923: BEGIN
6924:

Line 7217: l_chr_id okl_k_headers_full_v.id%type;

7213: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7214: l_object_code VARCHAR2(30) Default Null;
7215:
7216: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
7217: l_chr_id okl_k_headers_full_v.id%type;
7218: l_revolving_credit_yn okl_k_headers_full_v.revolving_credit_yn%type;
7219: l_row_count number;
7220: l_currency_code fnd_currencies_vl.currency_code%type := null;
7221:

Line 7218: l_revolving_credit_yn okl_k_headers_full_v.revolving_credit_yn%type;

7214: l_object_code VARCHAR2(30) Default Null;
7215:
7216: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
7217: l_chr_id okl_k_headers_full_v.id%type;
7218: l_revolving_credit_yn okl_k_headers_full_v.revolving_credit_yn%type;
7219: l_row_count number;
7220: l_currency_code fnd_currencies_vl.currency_code%type := null;
7221:
7222: cursor l_chk_cust_acc_csr(p_cust_acc_id1 VARCHAR2, p_name VARCHAR2) is

Line 7238: from OKL_k_headers_full_V

7234: and nvl(to_date,p_start_date+1) > p_start_date;
7235:
7236: cursor l_mla_csr is
7237: select id
7238: from OKL_k_headers_full_V
7239: where contract_number = p_mla_no
7240: and scs_code = 'MASTER_LEASE'
7241: and STS_CODE = 'ACTIVE'
7242: and TEMPLATE_YN = 'N'

Line 7247: from OKL_k_headers_full_V prg_hdr

7243: and BUY_OR_SELL = 'S';
7244:
7245: cursor l_program_csr is
7246: select id
7247: from OKL_k_headers_full_V prg_hdr
7248: where contract_number = p_program_no
7249: and scs_code = 'PROGRAM'
7250: and nvl(TEMPLATE_YN, 'N') = 'N'
7251: and sts_code = 'ACTIVE'

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

7294: and cle.dnz_chr_id = p_chr_id
7295: and cle.chr_id = p_chr_id
7296: and kle.fee_type = 'ROLLOVER';
7297:
7298: l_template_type_code OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE := NULL;
7299: CURSOR l_tmpl_type_code_csr IS
7300: SELECT chrb.template_yn,
7301: khr.template_type_code
7302: FROM okc_k_headers_b chrb,

Line 7303: okl_k_headers khr

7299: CURSOR l_tmpl_type_code_csr IS
7300: SELECT chrb.template_yn,
7301: khr.template_type_code
7302: FROM okc_k_headers_b chrb,
7303: okl_k_headers khr
7304: WHERE chrb.id = khr.id
7305: AND chrb.id = p_chr_id;
7306:
7307:

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

9588: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
9589: l_chr_id okc_k_headers_b.id%type := null;
9590: l_k_cl_no okc_k_headers_b.contract_number%type := null;
9591: l_mla_no okc_k_headers_b.contract_number%type := null;
9592: l_deal_type okl_k_headers.deal_type%type := null;
9593:
9594: cursor get_deal_type_csr is
9595: select chr.deal_type
9596: from okl_k_headers chr

Line 9596: from okl_k_headers chr

9592: l_deal_type okl_k_headers.deal_type%type := null;
9593:
9594: cursor get_deal_type_csr is
9595: select chr.deal_type
9596: from okl_k_headers chr
9597: where chr.id = p_chr_id;
9598:
9599: cursor is_cl_exsts_csr is
9600: select cl.contract_number