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

Line 482: From okl_k_headers khr,

478: chr.scs_code,
479: khr.term_duration,
480: chr.start_date,
481: chr.end_date
482: From okl_k_headers khr,
483: okc_k_headers_b chr
484: Where khr.id = chr.id
485: And chr.id = p_chr_id;
486:

Line 489: l_term_duration okl_k_headers.term_duration%TYPE;

485: And chr.id = p_chr_id;
486:
487: l_sts_code okc_k_headers_b.sts_code%TYPE;
488: l_scs_code okc_k_headers_b.scs_code%TYPE;
489: l_term_duration okl_k_headers.term_duration%TYPE;
490: l_start_date okc_k_headers_b.start_date%TYPE;
491: l_end_date okc_k_headers_b.end_date%TYPE;
492:
493:

Line 528: okl_k_headers khr

524: Cursor pdt_dts_csr(p_chr_id IN NUMBER) IS
525: Select pdt.from_date,
526: pdt.to_date
527: From okl_products pdt,
528: okl_k_headers khr
529: where pdt.id = khr.pdt_id
530: and khr.id = p_chr_id;
531:
532: l_pdt_to_date okl_products.to_date%TYPE;

Line 557: from okl_k_headers orig_k,

553: Cursor orig_date_csr(rbk_chr_id IN NUMBER) is
554: Select orig.start_date,
555: orig.end_date,
556: orig_k.term_duration
557: from okl_k_headers orig_k,
558: okc_k_headers_b orig,
559: okc_k_headers_b rbk
560: where orig_k.id = orig.id
561: and orig.id = rbk.orig_system_id1

Line 566: l_orig_term_duration okl_k_headers.term_duration%TYPE;

562: and rbk.id = rbk_chr_id;
563:
564: l_orig_start_date okc_k_headers_b.start_date%TYPE;
565: l_orig_end_date okc_k_headers_b.end_date%TYPE;
566: l_orig_term_duration okl_k_headers.term_duration%TYPE;
567:
568:
569: Begin
570:

Line 1511: from okl_k_headers_full_v khr,

1507: Select khr.currency_code,
1508: khr.currency_conversion_type,
1509: khr.currency_conversion_date,
1510: khr.currency_conversion_rate
1511: from okl_k_headers_full_v khr,
1512: okc_k_headers_b rbk_chr
1513: where khr.id = rbk_chr.orig_system_id1
1514: and rbk_chr.id = p_rbk_chr_id;
1515:

Line 1516: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;

1512: okc_k_headers_b rbk_chr
1513: where khr.id = rbk_chr.orig_system_id1
1514: and rbk_chr.id = p_rbk_chr_id;
1515:
1516: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1517: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1518: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1519: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1520: --Bug# : 11.5.9 Rebooks - currency can not be modified

Line 1517: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;

1513: where khr.id = rbk_chr.orig_system_id1
1514: and rbk_chr.id = p_rbk_chr_id;
1515:
1516: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1517: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1518: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1519: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1520: --Bug# : 11.5.9 Rebooks - currency can not be modified
1521:

Line 1518: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;

1514: and rbk_chr.id = p_rbk_chr_id;
1515:
1516: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1517: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1518: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1519: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1520: --Bug# : 11.5.9 Rebooks - currency can not be modified
1521:
1522:

Line 1519: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

1515:
1516: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1517: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1518: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1519: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1520: --Bug# : 11.5.9 Rebooks - currency can not be modified
1521:
1522:
1523: l_rbk_cpy Varchar2(1) default 'N';

Line 1761: from okl_k_headers khr,

1757: --Bug#2727161 : 11.5.9 Rebooks - product can not be modified
1758: -- cursor to get product of the original contract
1759: Cursor ger_orig_pdt_csr(p_rbk_chr_id IN NUMBER) is
1760: Select khr.pdt_id
1761: from okl_k_headers khr,
1762: okc_k_headers_b rbk_chr
1763: where khr.id = rbk_chr.orig_system_id1
1764: and rbk_chr.id = p_rbk_chr_id;
1765:

Line 1766: l_orig_pdt_id okl_k_headers.pdt_id%TYPE;

1762: okc_k_headers_b rbk_chr
1763: where khr.id = rbk_chr.orig_system_id1
1764: and rbk_chr.id = p_rbk_chr_id;
1765:
1766: l_orig_pdt_id okl_k_headers.pdt_id%TYPE;
1767: --Bug#2727161 : 11.5.9 product - currency can not be modified
1768:
1769: l_rbk_cpy Varchar2(1) default 'N';
1770:

Line 1778: from okl_k_headers khr,

1774: Cursor l_curr_pdt_csr (p_chr_id in number) is
1775: select khr.pdt_id,
1776: chrb.scs_code,
1777: chrb.orig_system_source_code
1778: from okl_k_headers khr,
1779: okc_k_headers_b chrb
1780: where khr.id = chrb.id
1781: and chrb.id = p_chr_id;
1782:

Line 2272: from okl_k_headers_full_v khr

2268: --cursor to get pdt of original contract
2269: Cursor get_pdt_csr(orig_chr_id in number) is
2270: Select khr.pdt_id,
2271: khr.start_date
2272: from okl_k_headers_full_v khr
2273: where id = orig_chr_id;
2274:
2275: l_pdt_id okl_k_headers_full_v.pdt_id%TYPE;
2276: l_Start_date date;

Line 2275: l_pdt_id okl_k_headers_full_v.pdt_id%TYPE;

2271: khr.start_date
2272: from okl_k_headers_full_v khr
2273: where id = orig_chr_id;
2274:
2275: l_pdt_id okl_k_headers_full_v.pdt_id%TYPE;
2276: l_Start_date date;
2277: l_is_orig_pdt_old Varchar2(1) default 'N';
2278: l_no_data_found Boolean;
2279: l_pdtv_rec Okl_SetupProducts_Pub.pdtv_rec_type;

Line 2402: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

2398: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2399: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;
2400: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;
2401:
2402: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
2403: l_interest_calculation_basis VARCHAR2(30);
2404: l_revenue_recognition_method VARCHAR2(30);
2405: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
2406: x_rulv_tbl rulv_tbl_type;

Line 2889: from OKL_K_HEADERS_V

2885: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2886:
2887: cursor l_khrv_csr(l_id IN NUMBER) is
2888: select 'x'
2889: from OKL_K_HEADERS_V
2890: where id = l_id;
2891: l_dummy_var VARCHAR2(1) := '?';
2892:
2893: l_modfn_mode Varchar2(1);

Line 2964: FROM okl_k_headers khr

2960: khr.term_duration,
2961: khr.pdt_id,
2962: --bug# 3180583
2963: khr.multi_gaap_yn
2964: FROM okl_k_headers khr
2965: WHERE khr.id = chrid;
2966:
2967: l_orig_khr_rec get_orig_khr_csr%ROWTYPE;
2968:

Line 3047: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

3043: --Bug# 3180583
3044: l_multigaap_yn varchar2(1) default Null;
3045:
3046: -- Bug 4722839
3047: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
3048: l_interest_calculation_basis VARCHAR2(30);
3049: l_revenue_recognition_method VARCHAR2(30);
3050: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
3051: x_rulv_tbl rulv_tbl_type;

Line 10732: okl_k_headers c,

10728: --Bug# 2857899
10729: nvl(b.template_yn,'N') template_yn
10730: from okc_statuses_b a,
10731: okc_k_headers_b b,
10732: okl_k_headers c,
10733: OKC_STATUSES_TL cst
10734: where b.id = c.id
10735: and b.id = chrId
10736: and a.CODE = b.STS_CODE

Line 10802: from OKL_K_HEADERS KHR,

10798: --------------------------------------------------------
10799: l_prog_num OKC_K_HEADERS_B.CONTRACT_NUMBER%type := null;
10800: Cursor prog_num_csr ( p_chr_id IN NUMBER) IS
10801: select prog.contract_number
10802: from OKL_K_HEADERS KHR,
10803: OKC_K_HEADERS_B PROG
10804: where PROG.ID = KHR.KHR_ID
10805: and khr.id = p_chr_id;
10806:

Line 10811: l_investor_flag okl_k_headers.SECURITIZED_CODE%type := null;

10807: -------------------------------------------------------
10808: --Bug# 3455354 : 11.5.10 CHANGE SYNDICATION FLAG ON CONTRACT HEADER
10809: -- get investor flag for common header
10810: --------------------------------------------------------
10811: l_investor_flag okl_k_headers.SECURITIZED_CODE%type := null;
10812: Cursor investor_csr ( p_chr_id IN NUMBER) IS
10813: select SECURITIZED_CODE
10814: from okl_k_headers khr
10815: where khr.id = p_chr_id;

Line 10814: from okl_k_headers khr

10810: --------------------------------------------------------
10811: l_investor_flag okl_k_headers.SECURITIZED_CODE%type := null;
10812: Cursor investor_csr ( p_chr_id IN NUMBER) IS
10813: select SECURITIZED_CODE
10814: from okl_k_headers khr
10815: where khr.id = p_chr_id;
10816:
10817: ---------------------------------------------------------------------------
10818: -- FUNCTION get_syndicate_flag