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_STREAM_GENERATOR_PVT dependencies on OKC_K_HEADERS_B

Line 27: G_ORG_ID OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;

23: and sts.code = kle.sts_code
24: and sts.ste_code not in ('HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
25: );
26:
27: G_ORG_ID OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
28: G_CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
29: G_DIFF_LOOKUP_CODE FND_LOOKUPS.LOOKUP_CODE%TYPE;
30: G_PRECISION NUMBER;
31: G_ROUNDING_RULE OKL_SYS_ACCT_OPTS.AEL_ROUNDING_RULE%TYPE;

Line 28: G_CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;

24: and sts.ste_code not in ('HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
25: );
26:
27: G_ORG_ID OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
28: G_CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
29: G_DIFF_LOOKUP_CODE FND_LOOKUPS.LOOKUP_CODE%TYPE;
30: G_PRECISION NUMBER;
31: G_ROUNDING_RULE OKL_SYS_ACCT_OPTS.AEL_ROUNDING_RULE%TYPE;
32:

Line 780: FROM okc_k_headers_b chr_so,

776: sll.rule_information10 advance_arrears,
777: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
778: TO_NUMBER(sll.rule_information7) stub_days,
779: TO_NUMBER(sll.rule_information8) stub_amount
780: FROM okc_k_headers_b chr_so,
781: okc_k_lines_b cle,
782: okl_k_lines kle,
783: okc_line_styles_b lse,
784: okc_rules_b sll,

Line 813: FROM okc_k_headers_b chr_so,

809: SELECT DISTINCT
810: to_char(cle.id) kleId,
811: kle.amount fee_amount,
812: cle.start_date fee_start_date
813: FROM okc_k_headers_b chr_so,
814: okc_k_lines_b cle,
815: okl_k_lines kle,
816: okc_line_styles_b lse
817: WHERE chr_so.id = p_khr_id

Line 854: FROM okc_k_headers_b chr,

850: chr.start_date,
851: khr.deal_type,
852: khr.term_duration,
853: NVL(khr.generate_accrual_yn, 'Y')
854: FROM okc_k_headers_b chr,
855: okl_k_headers khr
856: WHERE khr.id = p_khr_id
857: AND chr.id = khr.id;
858:

Line 3960: FROM okc_k_headers_b chr,

3956: khr.deal_type,
3957: khr.term_duration,
3958: khr.pre_tax_irr,
3959: NVL(khr.generate_accrual_yn, 'Y')
3960: FROM okc_k_headers_b chr,
3961: okl_k_headers khr
3962: WHERE khr.id = p_khr_id
3963: AND chr.id = khr.id;
3964:

Line 4833: FROM okc_k_headers_b chr,

4829: chr.start_date,
4830: khr.deal_type,
4831: khr.term_duration,
4832: NVL(khr.generate_accrual_yn, 'Y')
4833: FROM okc_k_headers_b chr,
4834: okl_k_headers khr
4835: WHERE khr.id = p_khr_id
4836: AND chr.id = khr.id;
4837:

Line 5224: FROM okc_k_headers_b chr,

5220: chr.start_date,
5221: khr.deal_type,
5222: khr.term_duration,
5223: NVL(khr.generate_accrual_yn, 'Y')
5224: FROM okc_k_headers_b chr,
5225: okl_k_headers khr
5226: WHERE khr.id = p_khr_id
5227: AND chr.id = khr.id;
5228:

Line 5932: l_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;

5928: AND sty.stream_type_purpose = 'RENT';
5929:
5930: l_prog_name CONSTANT VARCHAR2(100) := G_PKG_NAME||'.'||'gen_rental_accr_streams';
5931: l_sum_of_rents NUMBER := 0;
5932: l_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
5933: l_day_convention_month VARCHAR2(30);
5934: l_day_convention_year VARCHAR2(30);
5935: l_end_date DATE;
5936: l_total_days NUMBER;

Line 6206: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;

6202: l_api_name CONSTANT VARCHAR2(30) := 'COPY_ACCRUAL_STREAMS_ISG';
6203: l_strm_index NUMBER;
6204: l_sel_index NUMBER;
6205: l_prev_stm_id OKL_STREAMS.ID%TYPE;
6206: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
6207: l_new_stm_cle_id OKC_K_LINES_B.ID%TYPE;
6208:
6209: -- Declare records/table types
6210: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

Line 6276: CURSOR c_streams (cp_chr_id OKC_K_HEADERS_B.ID%TYPE

6272: -- Modified by bkatraga for bug 5704245. Added bind condition for purpose_code
6273: -- Cursor to get Current Streams and elements for a particular line of a contract
6274: -- Added ISG generated stream type purposes so that these streams will not be
6275: -- copied over during mass/online rebook. Streams will be regenerated by ISG
6276: CURSOR c_streams (cp_chr_id OKC_K_HEADERS_B.ID%TYPE
6277: , cp_cle_id OKC_K_LINES_B.ID%TYPE
6278: , cp_date_terminated DATE
6279: , cp_purpose_code okl_streams.purpose_code%TYPE) IS
6280: SELECT STM.ID STREAM_ID

Line 6337: FROM okc_k_headers_b CHR,

6333:
6334: --Cursor to check whether it is a partial termination mass rebook transaction
6335: CURSOR l_chk_mass_rbk_csr IS
6336: SELECT '!'
6337: FROM okc_k_headers_b CHR,
6338: okl_trx_contracts ktrx,
6339: okl_trx_contracts trx
6340: WHERE CHR.ID = p_chr_id
6341: AND ktrx.KHR_ID = chr.id

Line 6360: CURSOR c_get_orig_line_id (cp_rbk_chr_id IN okc_k_headers_b.id%type

6356:
6357: -- Get Line ID in rebook copy that was copied from LINE the original contract
6358: -- cp_rbk_chr_id is the rebook copy contract
6359: -- cp_ole_id is original contract line ID
6360: CURSOR c_get_orig_line_id (cp_rbk_chr_id IN okc_k_headers_b.id%type
6361: , cp_ole_id IN OKC_K_LINES_B.ID%TYPE) is
6362: SELECT cle.id new_cle_id
6363: FROM okc_k_lines_b cle
6364: ,okc_k_lines_b ole

Line 6424: FROM okc_k_headers_b CHR,

6420:
6421: CURSOR chk_curr_terminated_line(p_kle_id IN OKC_K_LINES_B.ID%TYPE)
6422: IS
6423: SELECT 'Y'
6424: FROM okc_k_headers_b CHR,
6425: okl_trx_contracts ktrx,
6426: okl_trx_contracts trx,
6427: okl_txl_quote_lines_b txl
6428: WHERE CHR.ID = p_chr_id

Line 6449: FROM okc_k_headers_b CHR,

6445:
6446: UNION
6447:
6448: SELECT 'Y'
6449: FROM okc_k_headers_b CHR,
6450: okl_trx_contracts ktrx,
6451: okl_trx_contracts trx,
6452: okl_txl_quote_lines_b txl
6453: , OKC_K_ITEMS LNK_ITM

Line 6971: ,okc_k_headers_b chr

6967: IS
6968: SELECT cle.orig_system_id1 orig_kle_id
6969: ,chr.orig_system_id1 orig_khr_id
6970: FROM okc_k_lines_b cle
6971: ,okc_k_headers_b chr
6972: WHERE cle.id = p_kle_id
6973: AND cle.dnz_chr_id = chr.id
6974: AND cle.orig_system_id1 IS NOT NULL;
6975:

Line 8020: FROM okc_k_headers_b chr,

8016: khr.deal_type,
8017: khr.term_duration,
8018: NVL(khr.generate_accrual_yn, 'Y'),
8019: nvl(rpar.base_rate, 10) base_rate
8020: FROM okc_k_headers_b chr,
8021: okl_k_headers khr,
8022: OKL_K_RATE_PARAMS rpar
8023: WHERE khr.id = p_khr_id
8024: AND chr.id = khr.id

Line 8454: ,okc_k_headers_b chr

8450: CURSOR is_prospective_rbk_csr(p_khr_id NUMBER)
8451: IS
8452: SELECT amort_inc_adj_rev_dt_yn rbk_prospectively
8453: FROM okl_sys_acct_opts_all sysop
8454: ,okc_k_headers_b chr
8455: WHERE sysop.org_id = chr.authoring_org_id;
8456:
8457: l_rebook_date DATE;
8458: l_prb_orig_khr_id NUMBER;

Line 10393: FROM okc_k_headers_b chr,

10389: chr.start_date,
10390: khr.deal_type,
10391: khr.term_duration,
10392: NVL(khr.generate_accrual_yn, 'Y')
10393: FROM okc_k_headers_b chr,
10394: okl_k_headers khr
10395: WHERE khr.id = p_khr_id
10396: AND chr.id = khr.id;
10397:

Line 13425: FROM okc_k_headers_b chr,

13421:
13422: CURSOR c_hdr IS
13423: SELECT nvl(khr.implicit_interest_rate, 0),
13424: khr.deal_type
13425: FROM okc_k_headers_b chr,
13426: okl_k_headers khr
13427: WHERE khr.id = p_khr_id
13428: AND chr.id = khr.id;
13429:

Line 13824: FROM okc_k_headers_b chr,

13820: chr.end_date,
13821: khr.deal_type,
13822: khr.term_duration,
13823: NVL(khr.generate_accrual_yn, 'Y')
13824: FROM okc_k_headers_b chr,
13825: okl_k_headers khr
13826: WHERE khr.id = p_khr_id
13827: AND chr.id = khr.id;
13828:

Line 14098: FROM okc_k_headers_b chr

14094: l_inflow c_inflows%rowtype;
14095:
14096: CURSOR c_hdr IS
14097: SELECT chr.currency_code
14098: FROM okc_k_headers_b chr
14099: WHERE chr.id = p_khr_id;
14100:
14101: l_curreny_code okc_k_headers_all_b.currency_code%type;
14102:

Line 14696: FROM okc_k_headers_b chr

14692: l_api_name CONSTANT VARCHAR2(61) := 'generate_streams_for_IA';
14693:
14694: CURSOR c_hdr IS
14695: SELECT chr.currency_code
14696: FROM okc_k_headers_b chr
14697: WHERE chr.id = p_khr_id;
14698:
14699: l_currency_code okc_k_headers_all_b.currency_code%type;
14700: l_purpose_code VARCHAR2(10) := '-99';