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 496: From okl_k_headers khr,

492: chr.scs_code,
493: khr.term_duration,
494: chr.start_date,
495: chr.end_date
496: From okl_k_headers khr,
497: okc_k_headers_b chr
498: Where khr.id = chr.id
499: And chr.id = p_chr_id;
500:

Line 503: l_term_duration okl_k_headers.term_duration%TYPE;

499: And chr.id = p_chr_id;
500:
501: l_sts_code okc_k_headers_b.sts_code%TYPE;
502: l_scs_code okc_k_headers_b.scs_code%TYPE;
503: l_term_duration okl_k_headers.term_duration%TYPE;
504: l_start_date okc_k_headers_b.start_date%TYPE;
505: l_end_date okc_k_headers_b.end_date%TYPE;
506:
507:

Line 542: okl_k_headers khr

538: Cursor pdt_dts_csr(p_chr_id IN NUMBER) IS
539: Select pdt.from_date,
540: pdt.to_date
541: From okl_products pdt,
542: okl_k_headers khr
543: where pdt.id = khr.pdt_id
544: and khr.id = p_chr_id;
545:
546: -- Bug# 9115610 - Added cursor to get product effective dates

Line 578: from okl_k_headers orig_k,

574: Cursor orig_date_csr(rbk_chr_id IN NUMBER) is
575: Select orig.start_date,
576: orig.end_date,
577: orig_k.term_duration
578: from okl_k_headers orig_k,
579: okc_k_headers_b orig,
580: okc_k_headers_b rbk
581: where orig_k.id = orig.id
582: and orig.id = rbk.orig_system_id1

Line 587: l_orig_term_duration okl_k_headers.term_duration%TYPE;

583: and rbk.id = rbk_chr_id;
584:
585: l_orig_start_date okc_k_headers_b.start_date%TYPE;
586: l_orig_end_date okc_k_headers_b.end_date%TYPE;
587: l_orig_term_duration okl_k_headers.term_duration%TYPE;
588:
589:
590: Begin
591:

Line 1543: from okl_k_headers_full_v khr,

1539: Select khr.currency_code,
1540: khr.currency_conversion_type,
1541: khr.currency_conversion_date,
1542: khr.currency_conversion_rate
1543: from okl_k_headers_full_v khr,
1544: okc_k_headers_b rbk_chr
1545: where khr.id = rbk_chr.orig_system_id1
1546: and rbk_chr.id = p_rbk_chr_id;
1547:

Line 1548: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;

1544: okc_k_headers_b rbk_chr
1545: where khr.id = rbk_chr.orig_system_id1
1546: and rbk_chr.id = p_rbk_chr_id;
1547:
1548: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1549: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1550: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1551: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1552: --Bug# : 11.5.9 Rebooks - currency can not be modified

Line 1549: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;

1545: where khr.id = rbk_chr.orig_system_id1
1546: and rbk_chr.id = p_rbk_chr_id;
1547:
1548: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1549: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1550: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1551: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1552: --Bug# : 11.5.9 Rebooks - currency can not be modified
1553:

Line 1550: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;

1546: and rbk_chr.id = p_rbk_chr_id;
1547:
1548: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1549: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1550: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1551: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1552: --Bug# : 11.5.9 Rebooks - currency can not be modified
1553:
1554:

Line 1551: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

1547:
1548: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1549: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1550: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1551: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1552: --Bug# : 11.5.9 Rebooks - currency can not be modified
1553:
1554:
1555: l_rbk_cpy Varchar2(1) default 'N';

Line 1793: from okl_k_headers khr,

1789: --Bug#2727161 : 11.5.9 Rebooks - product can not be modified
1790: -- cursor to get product of the original contract
1791: Cursor ger_orig_pdt_csr(p_rbk_chr_id IN NUMBER) is
1792: Select khr.pdt_id
1793: from okl_k_headers khr,
1794: okc_k_headers_b rbk_chr
1795: where khr.id = rbk_chr.orig_system_id1
1796: and rbk_chr.id = p_rbk_chr_id;
1797:

Line 1798: l_orig_pdt_id okl_k_headers.pdt_id%TYPE;

1794: okc_k_headers_b rbk_chr
1795: where khr.id = rbk_chr.orig_system_id1
1796: and rbk_chr.id = p_rbk_chr_id;
1797:
1798: l_orig_pdt_id okl_k_headers.pdt_id%TYPE;
1799: --Bug#2727161 : 11.5.9 product - currency can not be modified
1800:
1801: l_rbk_cpy Varchar2(1) default 'N';
1802:

Line 1810: from okl_k_headers khr,

1806: Cursor l_curr_pdt_csr (p_chr_id in number) is
1807: select khr.pdt_id,
1808: chrb.scs_code,
1809: chrb.orig_system_source_code
1810: from okl_k_headers khr,
1811: okc_k_headers_b chrb
1812: where khr.id = chrb.id
1813: and chrb.id = p_chr_id;
1814:

Line 2339: from okl_k_headers_full_v khr

2335: --cursor to get pdt of original contract
2336: Cursor get_pdt_csr(orig_chr_id in number) is
2337: Select khr.pdt_id,
2338: khr.start_date
2339: from okl_k_headers_full_v khr
2340: where id = orig_chr_id;
2341:
2342: l_pdt_id okl_k_headers_full_v.pdt_id%TYPE;
2343: l_Start_date date;

Line 2342: l_pdt_id okl_k_headers_full_v.pdt_id%TYPE;

2338: khr.start_date
2339: from okl_k_headers_full_v khr
2340: where id = orig_chr_id;
2341:
2342: l_pdt_id okl_k_headers_full_v.pdt_id%TYPE;
2343: l_Start_date date;
2344: l_is_orig_pdt_old Varchar2(1) default 'N';
2345: l_no_data_found Boolean;
2346: l_pdtv_rec Okl_SetupProducts_Pub.pdtv_rec_type;

Line 2469: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

2465: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2466: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;
2467: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;
2468:
2469: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
2470: l_interest_calculation_basis VARCHAR2(30);
2471: l_revenue_recognition_method VARCHAR2(30);
2472: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
2473: x_rulv_tbl rulv_tbl_type;

Line 2968: from OKL_K_HEADERS_V

2964: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2965:
2966: cursor l_khrv_csr(l_id IN NUMBER) is
2967: select 'x'
2968: from OKL_K_HEADERS_V
2969: where id = l_id;
2970: l_dummy_var VARCHAR2(1) := '?';
2971:
2972: l_modfn_mode Varchar2(1);

Line 3043: FROM okl_k_headers khr

3039: khr.term_duration,
3040: khr.pdt_id,
3041: --bug# 3180583
3042: khr.multi_gaap_yn
3043: FROM okl_k_headers khr
3044: WHERE khr.id = chrid;
3045:
3046: l_orig_khr_rec get_orig_khr_csr%ROWTYPE;
3047:

Line 3126: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

3122: --Bug# 3180583
3123: l_multigaap_yn varchar2(1) default Null;
3124:
3125: -- Bug 4722839
3126: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
3127: l_interest_calculation_basis VARCHAR2(30);
3128: l_revenue_recognition_method VARCHAR2(30);
3129: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
3130: x_rulv_tbl rulv_tbl_type;

Line 10834: okl_k_headers c,

10830: --Bug# 2857899
10831: nvl(b.template_yn,'N') template_yn
10832: from okc_statuses_b a,
10833: okc_k_headers_b b,
10834: okl_k_headers c,
10835: OKC_STATUSES_TL cst
10836: where b.id = c.id
10837: and b.id = chrId
10838: and a.CODE = b.STS_CODE

Line 10904: from OKL_K_HEADERS KHR,

10900: --------------------------------------------------------
10901: l_prog_num OKC_K_HEADERS_B.CONTRACT_NUMBER%type := null;
10902: Cursor prog_num_csr ( p_chr_id IN NUMBER) IS
10903: select prog.contract_number
10904: from OKL_K_HEADERS KHR,
10905: OKC_K_HEADERS_B PROG
10906: where PROG.ID = KHR.KHR_ID
10907: and khr.id = p_chr_id;
10908:

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

10909: -------------------------------------------------------
10910: --Bug# 3455354 : 11.5.10 CHANGE SYNDICATION FLAG ON CONTRACT HEADER
10911: -- get investor flag for common header
10912: --------------------------------------------------------
10913: l_investor_flag okl_k_headers.SECURITIZED_CODE%type := null;
10914: Cursor investor_csr ( p_chr_id IN NUMBER) IS
10915: select SECURITIZED_CODE
10916: from okl_k_headers khr
10917: where khr.id = p_chr_id;

Line 10916: from okl_k_headers khr

10912: --------------------------------------------------------
10913: l_investor_flag okl_k_headers.SECURITIZED_CODE%type := null;
10914: Cursor investor_csr ( p_chr_id IN NUMBER) IS
10915: select SECURITIZED_CODE
10916: from okl_k_headers khr
10917: where khr.id = p_chr_id;
10918:
10919: ---------------------------------------------------------------------------
10920: -- FUNCTION get_syndicate_flag