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

Line 2338: FUNCTION append_perd_exp_tbl(p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,

2334: -- Parameters : Standard Parameters with p_khr_id and p_csm_perd_exp_tbl
2335: -- Version :
2336: -- End of Commnets
2337: -------------------------------------------------------------------------------------------------
2338: FUNCTION append_perd_exp_tbl(p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
2339: p_csm_perd_exp_tbl IN OUT NOCOPY OKL_CREATE_STREAMS_PUB.csm_periodic_expenses_tbl_type)
2340: RETURN VARCHAR2 IS
2341: l_csm_perd_exp_tbl OKL_CREATE_STREAMS_PUB.csm_periodic_expenses_tbl_type := p_csm_perd_exp_tbl;
2342: m_csm_perd_exp_tbl OKL_CREATE_STREAMS_PUB.csm_periodic_expenses_tbl_type;

Line 2348: ld_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

2344: lx_csm_perd_exp_tbl OKL_CREATE_STREAMS_PUB.csm_periodic_expenses_tbl_type;
2345: i NUMBER := 0;
2346: m NUMBER := 0;
2347: n NUMBER := 0;
2348: ld_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
2349: g_process_error EXCEPTION;
2350: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
2351: -- Cursor to get the Start of the contract
2352: -- To compare the date Start of the table of Records

Line 2353: CURSOR c_start_date_khr_csr(p_khr_id OKC_K_HEADERS_B.ID%TYPE)

2349: g_process_error EXCEPTION;
2350: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
2351: -- Cursor to get the Start of the contract
2352: -- To compare the date Start of the table of Records
2353: CURSOR c_start_date_khr_csr(p_khr_id OKC_K_HEADERS_B.ID%TYPE)
2354: IS
2355: SELECT start_date
2356: FROM okc_k_headers_b
2357: WHERE id = p_khr_id;

Line 2356: FROM okc_k_headers_b

2352: -- To compare the date Start of the table of Records
2353: CURSOR c_start_date_khr_csr(p_khr_id OKC_K_HEADERS_B.ID%TYPE)
2354: IS
2355: SELECT start_date
2356: FROM okc_k_headers_b
2357: WHERE id = p_khr_id;
2358: -- Since We are now Dealing with fee lines
2359: -- So we look for Fee lines in the Table of Records
2360: CURSOR c_fee_line_csr(p_khr_id OKC_K_HEADERS_B.ID%TYPE)

Line 2360: CURSOR c_fee_line_csr(p_khr_id OKC_K_HEADERS_B.ID%TYPE)

2356: FROM okc_k_headers_b
2357: WHERE id = p_khr_id;
2358: -- Since We are now Dealing with fee lines
2359: -- So we look for Fee lines in the Table of Records
2360: CURSOR c_fee_line_csr(p_khr_id OKC_K_HEADERS_B.ID%TYPE)
2361: IS
2362: SELECT cle.id id
2363: FROM okc_k_lines_b cle,
2364: okc_line_styles_b lse

Line 2644: FROM okc_k_headers_b chr,

2640: chr.start_date,
2641: khr.deal_type,
2642: khr.term_duration,
2643: NVL(khr.generate_accrual_yn, 'Y')
2644: FROM okc_k_headers_b chr,
2645: okl_k_headers khr
2646: WHERE khr.id = p_chr_id
2647: AND chr.id = khr.id;
2648:

Line 6353: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;

6349: -- Else input contract is returned as output
6350: PROCEDURE retrive_orig_hdr_id(p_chr_id IN VARCHAR2
6351: , x_chr_id OUT NOCOPY VARCHAR2
6352: ) IS
6353: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
6354: cursor c_online_rbk_csr(cp_chr_id in okc_k_headers_b.id%TYPE) is
6355: select ORIG_SYSTEM_ID1
6356: from okc_k_headers_b
6357: where id=cp_chr_id

Line 6354: cursor c_online_rbk_csr(cp_chr_id in okc_k_headers_b.id%TYPE) is

6350: PROCEDURE retrive_orig_hdr_id(p_chr_id IN VARCHAR2
6351: , x_chr_id OUT NOCOPY VARCHAR2
6352: ) IS
6353: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
6354: cursor c_online_rbk_csr(cp_chr_id in okc_k_headers_b.id%TYPE) is
6355: select ORIG_SYSTEM_ID1
6356: from okc_k_headers_b
6357: where id=cp_chr_id
6358: and trim(ORIG_SYSTEM_SOURCE_CODE)='OKL_REBOOK';

Line 6356: from okc_k_headers_b

6352: ) IS
6353: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
6354: cursor c_online_rbk_csr(cp_chr_id in okc_k_headers_b.id%TYPE) is
6355: select ORIG_SYSTEM_ID1
6356: from okc_k_headers_b
6357: where id=cp_chr_id
6358: and trim(ORIG_SYSTEM_SOURCE_CODE)='OKL_REBOOK';
6359:
6360: begin

Line 6406: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE; -- smadhava - Bug# 6149951

6402: l_prev_stm_id OKL_STREAMS.ID%TYPE;
6403:
6404: -- vdamerla Forward Ported Bug6149951 starts
6405:
6406: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE; -- smadhava - Bug# 6149951
6407: l_new_stm_cle_id OKC_K_LINES_B.ID%TYPE; -- smadhava - Bug# 6149951
6408:
6409: -- vdamerla Forward Ported Bug6149951 ends
6410:

Line 6418: CURSOR c_lnk_fin_rol_trm_fee (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

6414: l_selv_tbl okl_streams_pub.selv_tbl_type;
6415: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6416: -- vdamerla Forward Port
6417: -- Cursor to get fees linked to a terminated Asset
6418: CURSOR c_lnk_fin_rol_trm_fee (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6419: SELECT LNK_CLE.ID LNK_ID
6420: , FEE_CLE.ID FEE_ID
6421: , LNK_CLE.DATE_TERMINATED
6422: FROM OKC_K_LINES_B LNK_CLE

Line 6441: CURSOR c_tmt_asset_loan (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

6437: --AND FEE_KLE.FEE_TYPE IN (G_FEE_FINANCED,G_FEE_ROLLOVER);
6438:
6439:
6440: -- Cursor to get Terminated Asset lines of a LOAN contract
6441: CURSOR c_tmt_asset_loan (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6442: SELECT CLE.ID LINE_ID
6443: , CLE.DATE_TERMINATED
6444: FROM OKL_K_HEADERS KHR
6445: , OKC_K_LINES_B CLE

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

6463: -- Modified the cursor by vdamerla for bug 6344223
6464: -- Added ISG generated stream type purposes so that these streams will not be
6465: -- copied over during mass/online rebook. Streams will be regenerated by ISG
6466:
6467: CURSOR c_streams (cp_chr_id OKC_K_HEADERS_B.ID%TYPE
6468: , cp_cle_id OKC_K_LINES_B.ID%TYPE
6469: , cp_date_terminated DATE
6470: , cp_trx_number okl_streams.transaction_number%TYPE) IS
6471: SELECT STM.ID STREAM_ID

Line 6521: FROM okc_k_headers_b CHR,

6517: --Added by vdamerla for bug 6082209
6518: --Cursor to check whether it is a partial termination mass rebook transaction
6519: CURSOR l_chk_mass_rbk_csr IS
6520: SELECT '!'
6521: FROM okc_k_headers_b CHR,
6522: okl_trx_contracts ktrx,
6523: okl_trx_contracts trx
6524: WHERE CHR.ID = p_chr_id
6525: AND ktrx.KHR_ID = chr.id

Line 6568: CURSOR c_streams1 (cp_chr_id OKC_K_HEADERS_B.ID%TYPE

6564: --Also streams related to Investor and Interest Calc Prog should not be copied over as these streams are not historized
6565: --Modified the cursor by vdamerla for bug 6344223
6566: --Added ISG generated stream type purposes so that these streams will not be
6567: --copied over during mass/online rebook. Streams will be regenerated by ISG
6568: CURSOR c_streams1 (cp_chr_id OKC_K_HEADERS_B.ID%TYPE
6569: ,cp_trx_number okl_streams.transaction_number%TYPE) IS
6570: SELECT STM.ID STREAM_ID
6571: , STM.STY_ID
6572: , STM.SGN_CODE

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

6610: --smadhava - Bug# 6149951 - Added - Start
6611: -- Get Line ID in rebook copy that was copied from LINE the original contract
6612: -- cp_rbk_chr_id is the rebook copy contract
6613: -- cp_ole_id is original contract line ID
6614: CURSOR c_get_orig_line_id (cp_rbk_chr_id IN okc_k_headers_b.id%type
6615: , cp_ole_id IN OKC_K_LINES_B.ID%TYPE) is
6616: SELECT cle.id new_cle_id
6617: FROM okc_k_lines_b cle
6618: ,okc_k_lines_b ole

Line 6665: FROM okc_k_headers_b CHR,

6661: FROM OKL_SYSTEM_PARAMS_ALL;
6662:
6663: CURSOR chk_curr_terminated_line(p_kle_id IN OKC_K_LINES_B.ID%TYPE) IS
6664: SELECT 'Y'
6665: FROM okc_k_headers_b CHR,
6666: okl_trx_contracts ktrx,
6667: okl_trx_contracts trx,
6668: okl_txl_quote_lines_b txl
6669: WHERE CHR.ID = p_chr_id

Line 8043: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

8039: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
8040: x_return_status OUT NOCOPY VARCHAR2,
8041: x_msg_count OUT NOCOPY NUMBER,
8042: x_msg_data OUT NOCOPY VARCHAR2,
8043: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
8044: p_deal_type IN VARCHAR2,
8045: p_stream_types_tbl IN okl_create_streams_pub.csm_stream_types_tbl_type,
8046: x_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type) AS
8047: l_api_name VARCHAR2(256) := 'CHECK_FOR_MD_STRMS';

Line 8211: CURSOR c_is_loan_khr(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

8207: AND cle.id = kle.id
8208: AND kle.subsidy_id = sub.id;
8209:
8210: -- srsreeni - Bug#5699923 - Added - Start
8211: CURSOR c_is_loan_khr(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8212: SELECT 'Y'
8213: FROM OKL_K_HEADERS
8214: WHERE ID = p_chr_id
8215: AND DEAL_TYPE = 'LOAN';

Line 17454: ln_org_id okc_k_headers_b.authoring_org_id%TYPE;

17450: lv_fed_only VARCHAR2(3) := 'N';
17451: ln_value NUMBER := 0;
17452: lv_fed_only_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := NULL;
17453: lv_mg_tax_yn VARCHAR2(3) := 'N';
17454: ln_org_id okc_k_headers_b.authoring_org_id%TYPE;
17455: lv_currency_code okc_k_headers_b.currency_code%TYPE;
17456: l_rnd_basis_percent NUMBER;
17457: l_level_type NUMBER;
17458: l_strm_name VARCHAR2(200);

Line 17455: lv_currency_code okc_k_headers_b.currency_code%TYPE;

17451: ln_value NUMBER := 0;
17452: lv_fed_only_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := NULL;
17453: lv_mg_tax_yn VARCHAR2(3) := 'N';
17454: ln_org_id okc_k_headers_b.authoring_org_id%TYPE;
17455: lv_currency_code okc_k_headers_b.currency_code%TYPE;
17456: l_rnd_basis_percent NUMBER;
17457: l_level_type NUMBER;
17458: l_strm_name VARCHAR2(200);
17459: ln_fin_yn NUMBER := 0;

Line 17529: -- from okc_k_headers_b

17525: AND lse.lty_code = 'FEE'
17526: AND cle.id = kle.id
17527: AND kle.fee_type in ('ROLLOVER', 'FINANCED'));
17528: -- get the currency_code and Authoring_org_id
17529: -- from okc_k_headers_b
17530: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
17531: IS
17532: SELECT authoring_org_id,
17533: currency_code

Line 17530: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)

17526: AND cle.id = kle.id
17527: AND kle.fee_type in ('ROLLOVER', 'FINANCED'));
17528: -- get the currency_code and Authoring_org_id
17529: -- from okc_k_headers_b
17530: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
17531: IS
17532: SELECT authoring_org_id,
17533: currency_code
17534: FROM okc_k_headers_b

Line 17534: FROM okc_k_headers_b

17530: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
17531: IS
17532: SELECT authoring_org_id,
17533: currency_code
17534: FROM okc_k_headers_b
17535: WHERE id = p_chr_id;
17536: -- get the Lease Contract Header info
17537: CURSOR l_hdr_csr_lease(chrId NUMBER)
17538: IS

Line 17832: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;

17828: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
17829: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
17830:
17831: -- Start fix for bug 6858487
17832: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
17833: l_orig_cle_id OKC_K_LINES_B.ID%TYPE;
17834:
17835: -- Get Line ID in rebook copy that was copied from LINE the original contract
17836: -- cp_rbk_chr_id is the rebook copy contract

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

17834:
17835: -- Get Line ID in rebook copy that was copied from LINE the original contract
17836: -- cp_rbk_chr_id is the rebook copy contract
17837: -- cp_ole_id is original contract line ID
17838: CURSOR c_get_orig_line_id (cp_rbk_chr_id IN okc_k_headers_b.id%type
17839: , cp_ole_id IN OKC_K_LINES_B.ID%TYPE) is
17840: SELECT --cle.id new_cle_id
17841: cle.orig_system_id1
17842: FROM okc_k_lines_b cle

Line 20351: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,

20347: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
20348: x_return_status OUT NOCOPY VARCHAR2,
20349: x_msg_count OUT NOCOPY NUMBER,
20350: x_msg_data OUT NOCOPY VARCHAR2,
20351: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
20352: p_generation_ctx_code IN VARCHAR2,
20353: x_trx_number OUT NOCOPY NUMBER,
20354: x_trx_status OUT NOCOPY VARCHAR2
20355: ) AS

Line 20779: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,

20775: p_init_msg_list IN VARCHAR2,
20776: x_return_status OUT NOCOPY VARCHAR2,
20777: x_msg_count OUT NOCOPY NUMBER,
20778: x_msg_data OUT NOCOPY VARCHAR2,
20779: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
20780: p_paym_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type)
20781: IS
20782: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_PAYMENTS';
20783: G_APP_NAME VARCHAR2(30) := 'OKL';

Line 20872: ,(SELECT end_date FROM okc_k_headers_b WHERE id = rgp.dnz_chr_id ) --Bug#5441811

20868: -- Bug 5362566: Start
20869: OKL_LA_PAYMENTS_PVT.get_display_end_date(
20870: sll.RULE_INFORMATION2, sll.RULE_INFORMATION7, sll.OBJECT1_ID1, sll.RULE_INFORMATION3,
20871: okl_la_payments_pvt.get_start_day( sll.id,sll.dnz_chr_id,sll.rgp_id,sll.object2_id1,sll.RULE_INFORMATION2)
20872: ,(SELECT end_date FROM okc_k_headers_b WHERE id = rgp.dnz_chr_id ) --Bug#5441811
20873: )
20874: END_DATE,
20875: -- Bug 5362566: End
20876: -- Start of BAKUCHIB modification bug#3121708

Line 20897: CURSOR c_valid_khr_csr(p_khr_id OKC_K_HEADERS_B.ID%TYPE)

20893: --Added by kthiruva for Bug 5130703
20894: AND slh.JTOT_OBJECT1_CODE = 'OKL_STRMTYP'
20895: ORDER BY FND_DATE.canonical_to_date(sll.rule_information2);
20896:
20897: CURSOR c_valid_khr_csr(p_khr_id OKC_K_HEADERS_B.ID%TYPE)
20898: IS
20899: SELECT 1
20900: FROM DUAL
20901: WHERE EXISTS (SELECT 1

Line 20902: FROM okc_k_headers_b

20898: IS
20899: SELECT 1
20900: FROM DUAL
20901: WHERE EXISTS (SELECT 1
20902: FROM okc_k_headers_b
20903: WHERE id = p_khr_id);
20904: TYPE sll_date_rec_type IS RECORD (
20905: start_date okc_rules_b.last_update_date%TYPE := okl_api.G_MISS_DATE,
20906: end_date okc_rules_b.last_update_date%TYPE := okl_api.G_MISS_DATE);

Line 21404: FROM okc_k_headers_b chr_rv,

21400: IS
21401: SELECT kle_rv.id asset_line_id,
21402: kle_rv.oec oec,
21403: cle_so.START_DATE
21404: FROM okc_k_headers_b chr_rv,
21405: okc_line_styles_b lse_rv,
21406: okl_k_lines kle_rv,
21407: okc_k_lines_b cle_rv,
21408: okc_rules_b rul_rv,

Line 21527: FROM okc_k_headers_b chr_rv,

21523: SELECT kle_rv.id asset_line_id,
21524: kle_rv.oec oec,
21525: kle_rv.residual_percentage residual_percent,
21526: cle_so.start_date
21527: FROM okc_k_headers_b chr_rv,
21528: okc_line_styles_b lse_rv,
21529: okl_k_lines kle_rv,
21530: okc_k_lines_b cle_rv,
21531: okc_rules_b rul_rv,

Line 21660: From okc_K_headers_b chr

21656:
21657: Cursor khr_type_csr IS
21658: Select SCS_CODE,
21659: START_DATE
21660: From okc_K_headers_b chr
21661: Where chr.id = p_khr_id;
21662:
21663: khr_type_rec khr_type_csr%ROWTYPE;
21664:

Line 21742: From okc_K_headers_b chr

21738:
21739: Cursor khr_type_csr IS
21740: Select SCS_CODE,
21741: START_DATE
21742: From okc_K_headers_b chr
21743: Where chr.id = p_khr_id;
21744:
21745: khr_type_rec khr_type_csr%ROWTYPE;
21746:

Line 21809: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

21805: -------------------------------------------------------------------------------------------------
21806: PROCEDURE extract_params_so(
21807: p_api_version IN NUMBER,
21808: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
21809: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
21810: p_cle_id IN OKC_K_LINES_B.ID%TYPE,
21811: x_return_status OUT NOCOPY VARCHAR2,
21812: x_msg_count OUT NOCOPY NUMBER,
21813: x_msg_data OUT NOCOPY VARCHAR2,

Line 21830: ld_last_start_date okc_k_headers_b.start_date%TYPE;

21826: lv_fed_only VARCHAR2(3) := 'N';
21827: ln_value NUMBER := 0;
21828: -- Start of BAKUCHIB modification bug#3121708
21829: ln_diff_days NUMBER := 0;
21830: ld_last_start_date okc_k_headers_b.start_date%TYPE;
21831: ld_last_end_date okc_k_headers_b.start_date%TYPE;
21832: ld_chr_end_date okc_k_headers_b.end_date%TYPE;
21833: -- End of BAKUCHIB modification bug#3121708
21834: lv_fed_only_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := NULL;

Line 21831: ld_last_end_date okc_k_headers_b.start_date%TYPE;

21827: ln_value NUMBER := 0;
21828: -- Start of BAKUCHIB modification bug#3121708
21829: ln_diff_days NUMBER := 0;
21830: ld_last_start_date okc_k_headers_b.start_date%TYPE;
21831: ld_last_end_date okc_k_headers_b.start_date%TYPE;
21832: ld_chr_end_date okc_k_headers_b.end_date%TYPE;
21833: -- End of BAKUCHIB modification bug#3121708
21834: lv_fed_only_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := NULL;
21835: ln_org_id okc_k_headers_b.authoring_org_id%TYPE;

Line 21832: ld_chr_end_date okc_k_headers_b.end_date%TYPE;

21828: -- Start of BAKUCHIB modification bug#3121708
21829: ln_diff_days NUMBER := 0;
21830: ld_last_start_date okc_k_headers_b.start_date%TYPE;
21831: ld_last_end_date okc_k_headers_b.start_date%TYPE;
21832: ld_chr_end_date okc_k_headers_b.end_date%TYPE;
21833: -- End of BAKUCHIB modification bug#3121708
21834: lv_fed_only_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := NULL;
21835: ln_org_id okc_k_headers_b.authoring_org_id%TYPE;
21836: lv_currency_code okc_k_headers_b.currency_code%TYPE;

Line 21835: ln_org_id okc_k_headers_b.authoring_org_id%TYPE;

21831: ld_last_end_date okc_k_headers_b.start_date%TYPE;
21832: ld_chr_end_date okc_k_headers_b.end_date%TYPE;
21833: -- End of BAKUCHIB modification bug#3121708
21834: lv_fed_only_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := NULL;
21835: ln_org_id okc_k_headers_b.authoring_org_id%TYPE;
21836: lv_currency_code okc_k_headers_b.currency_code%TYPE;
21837: l_rnd_basis_percent NUMBER;
21838: l_level_type NUMBER;
21839: l_strm_name VARCHAR2(200);

Line 21836: lv_currency_code okc_k_headers_b.currency_code%TYPE;

21832: ld_chr_end_date okc_k_headers_b.end_date%TYPE;
21833: -- End of BAKUCHIB modification bug#3121708
21834: lv_fed_only_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := NULL;
21835: ln_org_id okc_k_headers_b.authoring_org_id%TYPE;
21836: lv_currency_code okc_k_headers_b.currency_code%TYPE;
21837: l_rnd_basis_percent NUMBER;
21838: l_level_type NUMBER;
21839: l_strm_name VARCHAR2(200);
21840: ln_fin_yn NUMBER := 0;

Line 22147: -- from okc_k_headers_b

22143: AND lse.lty_code = 'FEE'
22144: AND cle.id = kle.id
22145: AND kle.fee_type in ('ROLLOVER', 'FINANCED'));
22146: -- get the currency_code and Authoring_org_id
22147: -- from okc_k_headers_b
22148: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
22149: IS
22150: SELECT authoring_org_id,
22151: currency_code

Line 22148: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)

22144: AND cle.id = kle.id
22145: AND kle.fee_type in ('ROLLOVER', 'FINANCED'));
22146: -- get the currency_code and Authoring_org_id
22147: -- from okc_k_headers_b
22148: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
22149: IS
22150: SELECT authoring_org_id,
22151: currency_code
22152: FROM okc_k_headers_b

Line 22152: FROM okc_k_headers_b

22148: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
22149: IS
22150: SELECT authoring_org_id,
22151: currency_code
22152: FROM okc_k_headers_b
22153: WHERE id = p_chr_id;
22154: -- Get Capitalized fees amount for a contract
22155: CURSOR get_cap_fee_amt(p_chr_id okc_k_headers_b.id%TYPE)
22156: IS

Line 22155: CURSOR get_cap_fee_amt(p_chr_id okc_k_headers_b.id%TYPE)

22151: currency_code
22152: FROM okc_k_headers_b
22153: WHERE id = p_chr_id;
22154: -- Get Capitalized fees amount for a contract
22155: CURSOR get_cap_fee_amt(p_chr_id okc_k_headers_b.id%TYPE)
22156: IS
22157: SELECT NVL(kle.amount, 0) total_cap_fee
22158: FROM okl_k_lines kle,
22159: okc_k_lines_b cle,

Line 22175: CURSOR c_diff_days_csr(p_chr_id okc_k_headers_b.id%TYPE,

22171:
22172: -- Start of BAKUCHIB modification bug#3121708
22173: -- Get diff in days between contract end_date
22174: -- and max payment leve(LASLL) end_date
22175: CURSOR c_diff_days_csr(p_chr_id okc_k_headers_b.id%TYPE,
22176: p_cle_id okc_k_lines_b.id%TYPE,
22177: p_slh_id okc_rule_groups_b.id%TYPE)
22178: IS
22179: SELECT chrv.end_date chr_end_date,

Line 22188: okc_k_headers_b chrv

22184: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1))) pay_end_date
22185: FROM okc_rules_b sll,
22186: okc_rules_b slh,
22187: okc_rule_groups_b rgp,
22188: okc_k_headers_b chrv
22189: WHERE rgp.dnz_chr_id = p_chr_id
22190: AND rgp.cle_id = p_cle_id
22191: AND slh.id = p_slh_id
22192: AND rgp.rgd_code = 'LALEVL'