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_MASS_REBOOK_PVT dependencies on OKC_K_HEADERS_V

Line 1356: p_khr_id IN OKC_K_HEADERS_V.ID%TYPE,

1352: x_msg_count OUT NOCOPY NUMBER,
1353: x_msg_data OUT NOCOPY VARCHAR2,
1354: p_request_name IN VARCHAR2,
1355: p_online_yn IN VARCHAR2,
1356: p_khr_id IN OKC_K_HEADERS_V.ID%TYPE,
1357: p_kle_tbl IN kle_tbl_type,
1358: p_line_count IN NUMBER,
1359: p_book_type_code IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,
1360: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,

Line 1679: p_khr_id IN OKC_K_HEADERS_V.ID%TYPE,

1675: PROCEDURE update_slh_sll(
1676: x_return_status OUT NOCOPY VARCHAR2,
1677: x_msg_count OUT NOCOPY NUMBER,
1678: x_msg_data OUT NOCOPY VARCHAR2,
1679: p_khr_id IN OKC_K_HEADERS_V.ID%TYPE,
1680: p_kle_tbl IN kle_tbl_type,
1681: p_strm_lalevl_tbl IN strm_lalevl_tbl_type
1682: ) IS
1683:

Line 1688: CURSOR rgp_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

1684: l_api_name VARCHAR2(35) := 'update_slh_sll';
1685: l_proc_name VARCHAR2(35) := 'UPDATE_SLH_SLL';
1686: l_api_version NUMBER := 1.0;
1687:
1688: CURSOR rgp_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1689: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1690: SELECT ID
1691: FROM okc_rule_groups_v
1692: WHERE dnz_chr_id = p_chr_id

Line 1704: CURSOR sll_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

1700: WHERE object1_id1 = p_stream_id
1701: AND rgp_id = p_rgp_id
1702: AND rule_information_category = 'LASLH';
1703:
1704: CURSOR sll_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1705: p_slh_id OKC_RULES_V.ID%TYPE,
1706: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE) IS
1707: SELECT id
1708: FROM okc_rules_v

Line 2003: p_khr_id IN OKC_K_HEADERS_V.ID%TYPE,

1999: PROCEDURE update_ppd_amount(
2000: x_return_status OUT NOCOPY VARCHAR2,
2001: x_msg_count OUT NOCOPY NUMBER,
2002: x_msg_data OUT NOCOPY VARCHAR2,
2003: p_khr_id IN OKC_K_HEADERS_V.ID%TYPE,
2004: p_kle_tbl IN kle_tbl_type,
2005: p_strm_lalevl_tbl IN strm_lalevl_tbl_type
2006: ) IS
2007:

Line 2012: CURSOR rgp_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

2008: l_api_name VARCHAR2(35) := 'update_ppd_amount';
2009: l_proc_name VARCHAR2(35) := 'UPDATE_PPD_AMOUNT';
2010: l_api_version NUMBER := 1.0;
2011:
2012: CURSOR rgp_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2013: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2014: SELECT ID
2015: FROM okc_rule_groups_v
2016: WHERE dnz_chr_id = p_chr_id

Line 2028: CURSOR sll_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

2024: WHERE object1_id1 = p_stream_id
2025: AND rgp_id = p_rgp_id
2026: AND rule_information_category = 'LASLH';
2027:
2028: CURSOR sll_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2029: p_slh_id OKC_RULES_V.ID%TYPE,
2030: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE) IS
2031: SELECT id
2032: FROM okc_rules_v

Line 2355: p_khr_id IN OKC_K_HEADERS_V.ID%TYPE,

2351: x_return_status OUT NOCOPY VARCHAR2,
2352: x_msg_count OUT NOCOPY NUMBER,
2353: x_msg_data OUT NOCOPY VARCHAR2,
2354: p_online_yn IN VARCHAR2,
2355: p_khr_id IN OKC_K_HEADERS_V.ID%TYPE,
2356: p_kle_tbl IN kle_tbl_type,
2357: p_line_count IN NUMBER,
2358: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
2359: p_book_type_code IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,

Line 2401: CURSOR con_sts_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

2397:
2398: l_c_no varchar2(100);
2399: l_sts varchar2(100);
2400:
2401: CURSOR con_sts_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2402: SELECT sts.ste_code
2403: FROM okc_statuses_b sts,
2404: okc_k_headers_b hdr
2405: WHERE hdr.sts_code = sts.code

Line 3051: p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

3047: l_proc_name VARCHAR2(35) := 'UPDATE_MASS_RBK_CONTRACT';
3048: l_api_version NUMBER := 1.0;
3049:
3050: CURSOR rbk_csr (p_request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE,
3051: p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3052: SELECT id
3053: FROM okl_rbk_selected_contract
3054: WHERE khr_id = p_chr_id
3055: AND request_name = p_request_name;

Line 3178: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

3174: PROCEDURE update_trx_asset(
3175: x_return_status OUT NOCOPY VARCHAR2,
3176: x_msg_count OUT NOCOPY NUMBER,
3177: x_msg_data OUT NOCOPY VARCHAR2,
3178: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
3179: p_status IN VARCHAR2
3180: ) IS
3181: --Bug# 3521126 :
3182: /*--modified cursor to change only status of current transaction--

Line 3183: --CURSOR trx_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

3179: p_status IN VARCHAR2
3180: ) IS
3181: --Bug# 3521126 :
3182: /*--modified cursor to change only status of current transaction--
3183: --CURSOR trx_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3184: --SELECT txl.tas_id
3185: --FROM okl_txl_assets_v txl
3186: --WHERE txl.dnz_khr_id = p_chr_id
3187: --AND EXISTS (SELECT 'Y'

Line 3192: CURSOR trx_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

3188: --FROM okl_trx_assets_v trx
3189: --WHERE trx.id = txl.tas_id
3190: --AND trx.tsu_code = 'ENTERED');
3191: ---------------------------------------------------------------*/
3192: CURSOR trx_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3193: SELECT trx.id
3194: FROM okl_trx_assets trx,
3195: okl_trx_types_tl ttyp,
3196: okl_txl_assets_b txl

Line 3233: PROCEDURE process_securitization_stream(p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

3229:
3230: END update_trx_asset;
3231:
3232: -- Bug# 4398936
3233: PROCEDURE process_securitization_stream(p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
3234: p_rbk_trx_id IN NUMBER,
3235: x_return_status OUT NOCOPY VARCHAR2,
3236: x_msg_count OUT NOCOPY NUMBER,
3237: x_msg_data OUT NOCOPY VARCHAR2)

Line 3268: CURSOR disb_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

3264:
3265:
3266: --Bug 6740000 ssdeshpa start
3267: --Changed Stream Type Subclass to 'INVESTOR_DISBURSEMENT'
3268: CURSOR disb_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3269: SELECT strm.id
3270: FROM okl_streams strm,
3271: okl_strm_type_v TYPE
3272: WHERE TYPE.id = strm.sty_id

Line 3278: CURSOR accu_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

3274: AND strm.khr_id = p_chr_id
3275: AND strm.say_code = 'CURR';
3276: --Bug 6740000 ssdeshpa End
3277:
3278: CURSOR accu_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3279: SELECT strm.id
3280: FROM okl_streams strm,
3281: okl_strm_type_v TYPE
3282: WHERE TYPE.id = strm.sty_id

Line 3624: CURSOR check_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

3620: l_api_name VARCHAR2(35) := 'mass_rebook_activate';
3621: l_proc_name VARCHAR2(35) := 'MASS_REBOOK_ACTIVATE';
3622: l_api_version NUMBER := 1.0;
3623:
3624: CURSOR check_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3625: SELECT DISTINCT
3626: A.REQUEST_NAME,
3627: A.KHR_ID,
3628: A.TRANSACTION_ID,

Line 4379: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE

4375: p_init_msg_list IN VARCHAR2,
4376: x_return_status OUT NOCOPY VARCHAR2,
4377: x_msg_count OUT NOCOPY NUMBER,
4378: x_msg_data OUT NOCOPY VARCHAR2,
4379: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE
4380: ) IS
4381:
4382: l_api_name VARCHAR2(35) := 'mass_rebook_after_yield';
4383: l_proc_name VARCHAR2(35) := 'MASS_REBOOK_AFTER_YIELD';

Line 4386: CURSOR check_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

4382: l_api_name VARCHAR2(35) := 'mass_rebook_after_yield';
4383: l_proc_name VARCHAR2(35) := 'MASS_REBOOK_AFTER_YIELD';
4384: l_api_version NUMBER := 1.0;
4385:
4386: CURSOR check_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4387: SELECT DISTINCT
4388: REQUEST_NAME,
4389: KHR_ID,
4390: TRANSACTION_ID,

Line 4537: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE

4533: PROCEDURE cancel_transaction(
4534: x_return_status OUT NOCOPY VARCHAR2,
4535: x_msg_count OUT NOCOPY NUMBER,
4536: x_msg_data OUT NOCOPY VARCHAR2,
4537: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE
4538: ) IS
4539:
4540: l_proc_name VARCHAR2(35) := 'CANCEL_TRANSACTION';
4541: l_api_name VARCHAR2(35) := 'CANCEL_TRANSACTION';

Line 4543: CURSOR trx_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

4539:
4540: l_proc_name VARCHAR2(35) := 'CANCEL_TRANSACTION';
4541: l_api_name VARCHAR2(35) := 'CANCEL_TRANSACTION';
4542:
4543: CURSOR trx_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4544: SELECT DISTINCT
4545: REQUEST_NAME,
4546: KHR_ID,
4547: TRANSACTION_ID

Line 6076: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

6072: p_init_msg_list IN VARCHAR2,
6073: x_return_status OUT NOCOPY VARCHAR2,
6074: x_msg_count OUT NOCOPY NUMBER,
6075: x_msg_data OUT NOCOPY VARCHAR2,
6076: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
6077: p_kle_tbl IN kle_tbl_type,
6078: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
6079: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
6080: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,