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 2927: p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

2923: l_proc_name VARCHAR2(35) := 'UPDATE_MASS_RBK_CONTRACT';
2924: l_api_version NUMBER := 1.0;
2925:
2926: CURSOR rbk_csr (p_request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE,
2927: p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2928: SELECT id
2929: FROM okl_rbk_selected_contract
2930: WHERE khr_id = p_chr_id
2931: AND request_name = p_request_name;

Line 3054: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

3050: PROCEDURE update_trx_asset(
3051: x_return_status OUT NOCOPY VARCHAR2,
3052: x_msg_count OUT NOCOPY NUMBER,
3053: x_msg_data OUT NOCOPY VARCHAR2,
3054: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
3055: p_status IN VARCHAR2
3056: ) IS
3057: --Bug# 3521126 :
3058: /*--modified cursor to change only status of current transaction--

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

3055: p_status IN VARCHAR2
3056: ) IS
3057: --Bug# 3521126 :
3058: /*--modified cursor to change only status of current transaction--
3059: --CURSOR trx_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3060: --SELECT txl.tas_id
3061: --FROM okl_txl_assets_v txl
3062: --WHERE txl.dnz_khr_id = p_chr_id
3063: --AND EXISTS (SELECT 'Y'

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

3064: --FROM okl_trx_assets_v trx
3065: --WHERE trx.id = txl.tas_id
3066: --AND trx.tsu_code = 'ENTERED');
3067: ---------------------------------------------------------------*/
3068: CURSOR trx_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3069: SELECT trx.id
3070: FROM okl_trx_assets trx,
3071: okl_trx_types_tl ttyp,
3072: okl_txl_assets_b txl

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

3105:
3106: END update_trx_asset;
3107:
3108: -- Bug# 4398936
3109: PROCEDURE process_securitization_stream(p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
3110: p_rbk_trx_id IN NUMBER,
3111: x_return_status OUT NOCOPY VARCHAR2,
3112: x_msg_count OUT NOCOPY NUMBER,
3113: x_msg_data OUT NOCOPY VARCHAR2)

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

3140:
3141:
3142: --Bug 6740000 ssdeshpa start
3143: --Changed Stream Type Subclass to 'INVESTOR_DISBURSEMENT'
3144: CURSOR disb_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3145: SELECT strm.id
3146: FROM okl_streams strm,
3147: okl_strm_type_v TYPE
3148: WHERE TYPE.id = strm.sty_id

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

3150: AND strm.khr_id = p_chr_id
3151: AND strm.say_code = 'CURR';
3152: --Bug 6740000 ssdeshpa End
3153:
3154: CURSOR accu_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3155: SELECT strm.id
3156: FROM okl_streams strm,
3157: okl_strm_type_v TYPE
3158: WHERE TYPE.id = strm.sty_id

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

3496: l_api_name VARCHAR2(35) := 'mass_rebook_activate';
3497: l_proc_name VARCHAR2(35) := 'MASS_REBOOK_ACTIVATE';
3498: l_api_version NUMBER := 1.0;
3499:
3500: CURSOR check_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3501: SELECT DISTINCT
3502: A.REQUEST_NAME,
3503: A.KHR_ID,
3504: A.TRANSACTION_ID,

Line 4239: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE

4235: p_init_msg_list IN VARCHAR2,
4236: x_return_status OUT NOCOPY VARCHAR2,
4237: x_msg_count OUT NOCOPY NUMBER,
4238: x_msg_data OUT NOCOPY VARCHAR2,
4239: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE
4240: ) IS
4241:
4242: l_api_name VARCHAR2(35) := 'mass_rebook_after_yield';
4243: l_proc_name VARCHAR2(35) := 'MASS_REBOOK_AFTER_YIELD';

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

4242: l_api_name VARCHAR2(35) := 'mass_rebook_after_yield';
4243: l_proc_name VARCHAR2(35) := 'MASS_REBOOK_AFTER_YIELD';
4244: l_api_version NUMBER := 1.0;
4245:
4246: CURSOR check_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4247: SELECT DISTINCT
4248: REQUEST_NAME,
4249: KHR_ID,
4250: TRANSACTION_ID,

Line 4397: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE

4393: PROCEDURE cancel_transaction(
4394: x_return_status OUT NOCOPY VARCHAR2,
4395: x_msg_count OUT NOCOPY NUMBER,
4396: x_msg_data OUT NOCOPY VARCHAR2,
4397: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE
4398: ) IS
4399:
4400: l_proc_name VARCHAR2(35) := 'CANCEL_TRANSACTION';
4401: l_api_name VARCHAR2(35) := 'CANCEL_TRANSACTION';

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

4399:
4400: l_proc_name VARCHAR2(35) := 'CANCEL_TRANSACTION';
4401: l_api_name VARCHAR2(35) := 'CANCEL_TRANSACTION';
4402:
4403: CURSOR trx_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4404: SELECT DISTINCT
4405: REQUEST_NAME,
4406: KHR_ID,
4407: TRANSACTION_ID

Line 5936: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

5932: p_init_msg_list IN VARCHAR2,
5933: x_return_status OUT NOCOPY VARCHAR2,
5934: x_msg_count OUT NOCOPY NUMBER,
5935: x_msg_data OUT NOCOPY VARCHAR2,
5936: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
5937: p_kle_tbl IN kle_tbl_type,
5938: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5939: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5940: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,