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 OKL_RBK_SELECTED_CONTRACT

Line 457: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE DEFAULT SYSDATE,

453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,
456: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
457: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE DEFAULT SYSDATE,
458: x_mstv_tbl OUT NOCOPY mstv_tbl_type,
459: x_rbk_count OUT NOCOPY NUMBER
460: ) IS
461:

Line 480: FROM okl_rbk_selected_contract

476: get_contract_failed EXCEPTION;
477:
478: CURSOR req_csr (p_request_name OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE) IS
479: SELECT 'Y'
480: FROM okl_rbk_selected_contract
481: WHERE request_name = p_request_name;
482:
483: BEGIN
484: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 859: -- and populates OKL_RBK_SELECTED_CONTRACT table with selected contracts.

855: ------------------------------------------------------------------------------
856: -- PROCEDURE build_and_get_contracts
857: -- Overloaded process to accept transaction date from page
858: -- This proecdure inserts selection criteria to OKL_MASS_RBK_CRITERIA table
859: -- and populates OKL_RBK_SELECTED_CONTRACT table with selected contracts.
860: -- Calls:
861: -- Called by:
862: ------------------------------------------------------------------------------
863:

Line 871: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,

867: x_return_status OUT NOCOPY VARCHAR2,
868: x_msg_count OUT NOCOPY NUMBER,
869: x_msg_data OUT NOCOPY VARCHAR2,
870: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
871: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
872: p_mrbv_tbl IN mrbv_tbl_type,
873: x_mstv_tbl OUT NOCOPY mstv_tbl_type,
874: x_rbk_count OUT NOCOPY NUMBER
875: ) IS

Line 1009: -- and populates OKL_RBK_SELECTED_CONTRACT table with selected contracts.

1005:
1006: ------------------------------------------------------------------------------
1007: -- PROCEDURE build_and_get_contracts
1008: -- This proecdure inserts selection criteria to OKL_MASS_RBK_CRITERIA table
1009: -- and populates OKL_RBK_SELECTED_CONTRACT table with selected contracts.
1010: -- Calls:
1011: -- Called by:
1012: ------------------------------------------------------------------------------
1013:

Line 1155: -- FUNCTION get_rec from OKL_RBK_SELECTED_CONTRACT

1151:
1152: END build_and_get_contracts;
1153:
1154: ---------------------------------------------------------------------------
1155: -- FUNCTION get_rec from OKL_RBK_SELECTED_CONTRACT
1156: ---------------------------------------------------------------------------
1157: FUNCTION get_rec (
1158: p_request_name IN VARCHAR2,
1159: p_chr_id IN NUMBER,

Line 1190: FROM okl_rbk_selected_contract

1186: ,attribute12
1187: ,attribute13
1188: ,attribute14
1189: ,attribute15
1190: FROM okl_rbk_selected_contract
1191: WHERE request_name = p_request_name
1192: AND khr_id = p_chr_id
1193: AND NVL(status, 'NEW') IN ('NEW', 'ERROR');
1194:

Line 1365: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE DEFAULT SYSDATE

1361: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
1362: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
1363: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
1364: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE ,
1365: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE DEFAULT SYSDATE
1366: ) IS
1367: l_api_name VARCHAR2(35) := 'populate_asset_change';
1368: l_proc_name VARCHAR2(35) := 'POPULATE_ASSET_CHANGE';
1369: l_api_version NUMBER := 1.0;

Line 2367: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE DEFAULT SYSDATE

2363: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
2364: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
2365: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
2366: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
2367: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE DEFAULT SYSDATE
2368: ) IS
2369: l_api_name VARCHAR2(35) := 'rebook_contract';
2370: l_proc_name VARCHAR2(35) := 'REBOOK_CONTRACT';
2371: l_api_version NUMBER := 1.0;

Line 2408: l_request_name okl_rbk_selected_contract.request_name%TYPE;

2404: okc_k_headers_b hdr
2405: WHERE hdr.sts_code = sts.code
2406: AND hdr.id = p_chr_id;
2407:
2408: l_request_name okl_rbk_selected_contract.request_name%TYPE;
2409: rebook_contract_failed EXCEPTION;
2410:
2411: l_transaction_date DATE;
2412: x_ignore_flag VARCHAR2(1);

Line 3050: CURSOR rbk_csr (p_request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE,

3046: l_api_name VARCHAR2(35) := 'update_mass_rbk_contract';
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

Line 3053: FROM okl_rbk_selected_contract

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;
3056:
3057: l_mstv_upd_tbl mstv_tbl_type;

Line 3633: FROM okl_rbk_selected_contract A,

3629: --Bug# 4107330
3630: A.TRANSACTION_DATE,
3631: B.MULTI_GAAP_YN, -- MGAAP 7263041
3632: C.REPORTING_PDT_ID -- MGAAP 7263041
3633: FROM okl_rbk_selected_contract A,
3634: okl_k_headers B,
3635: okl_products C
3636: WHERE A.khr_id = p_chr_id
3637: AND NVL(A.status,'NEW') = 'UNDER REVISION'

Line 3654: l_rbk_id okl_rbk_selected_contract.id%TYPE;

3650: select tcn_type
3651: from okl_trx_contracts
3652: where id = p_trx_id;
3653:
3654: l_rbk_id okl_rbk_selected_contract.id%TYPE;
3655: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
3656: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
3657:
3658: -- MGAAP start 7263041

Line 3655: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;

3651: from okl_trx_contracts
3652: where id = p_trx_id;
3653:
3654: l_rbk_id okl_rbk_selected_contract.id%TYPE;
3655: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
3656: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
3657:
3658: -- MGAAP start 7263041
3659: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;

Line 3656: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;

3652: where id = p_trx_id;
3653:
3654: l_rbk_id okl_rbk_selected_contract.id%TYPE;
3655: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
3656: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
3657:
3658: -- MGAAP start 7263041
3659: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;
3660: l_reporting_pdt_id okl_products.reporting_pdt_id%TYPE;

Line 3664: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;

3660: l_reporting_pdt_id okl_products.reporting_pdt_id%TYPE;
3661: -- MGAAP end 7263041
3662:
3663: --Bug# 4107330
3664: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;
3665: l_request_name okl_rbk_selected_contract.request_name%TYPE;
3666:
3667: l_parent_tcn_type okl_trx_contracts.tcn_type%TYPE;
3668: l_mstv_tbl mstv_tbl_type;

Line 3665: l_request_name okl_rbk_selected_contract.request_name%TYPE;

3661: -- MGAAP end 7263041
3662:
3663: --Bug# 4107330
3664: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;
3665: l_request_name okl_rbk_selected_contract.request_name%TYPE;
3666:
3667: l_parent_tcn_type okl_trx_contracts.tcn_type%TYPE;
3668: l_mstv_tbl mstv_tbl_type;
3669: x_mstv_tbl mstv_tbl_type;

Line 4393: FROM okl_rbk_selected_contract

4389: KHR_ID,
4390: TRANSACTION_ID,
4391: --Bug# 4107330
4392: TRANSACTION_DATE
4393: FROM okl_rbk_selected_contract
4394: WHERE khr_id = p_chr_id
4395: AND NVL(status,'NEW') = 'UNDER REVISION';
4396: --AND NVL(status,'NEW') <> 'PROCESSED';
4397:

Line 4398: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;

4394: WHERE khr_id = p_chr_id
4395: AND NVL(status,'NEW') = 'UNDER REVISION';
4396: --AND NVL(status,'NEW') <> 'PROCESSED';
4397:
4398: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
4399: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
4400: --Bug# 4107330
4401: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;
4402: l_request_name okl_rbk_selected_contract.request_name%TYPE;

Line 4399: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;

4395: AND NVL(status,'NEW') = 'UNDER REVISION';
4396: --AND NVL(status,'NEW') <> 'PROCESSED';
4397:
4398: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
4399: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
4400: --Bug# 4107330
4401: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;
4402: l_request_name okl_rbk_selected_contract.request_name%TYPE;
4403:

Line 4401: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;

4397:
4398: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
4399: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
4400: --Bug# 4107330
4401: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;
4402: l_request_name okl_rbk_selected_contract.request_name%TYPE;
4403:
4404: after_yield_failed EXCEPTION;
4405: not_to_process EXCEPTION;

Line 4402: l_request_name okl_rbk_selected_contract.request_name%TYPE;

4398: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
4399: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
4400: --Bug# 4107330
4401: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;
4402: l_request_name okl_rbk_selected_contract.request_name%TYPE;
4403:
4404: after_yield_failed EXCEPTION;
4405: not_to_process EXCEPTION;
4406:

Line 4548: FROM okl_rbk_selected_contract

4544: SELECT DISTINCT
4545: REQUEST_NAME,
4546: KHR_ID,
4547: TRANSACTION_ID
4548: FROM okl_rbk_selected_contract
4549: WHERE khr_id = p_chr_id
4550: AND NVL(status,'NEW') <> 'PROCESSED';
4551:
4552: l_mstv_tbl mstv_tbl_type;

Line 4677: l_transaction_date OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE;

4673:
4674: l_kle_tbl kle_tbl_type;
4675: l_strm_lalevl_tbl strm_lalevl_tbl_type;
4676:
4677: l_transaction_date OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE;
4678:
4679: CURSOR rbk_set_csr (p_req_name VARCHAR2) IS
4680: SELECT criteria_code,
4681: criteria_value1,

Line 4699: FROM okl_rbk_selected_contract rbk

4695: rbk.contract_description,
4696: rbk.kle_id,
4697: rbk.transaction_date,
4698: khr.object_version_number
4699: FROM okl_rbk_selected_contract rbk
4700: , okl_k_headers khr
4701: WHERE
4702: rbk.request_name = p_req_name
4703: AND rbk.selected_flag = 'Y'

Line 5391: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,

5387: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
5388: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5389: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5390: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5391: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
5392: x_stream_trx_tbl OUT NOCOPY strm_trx_tbl_type
5393: ) IS
5394: l_api_name VARCHAR2(35) := 'apply_mass_rebook';
5395: l_proc_name VARCHAR2(35) := 'APPLY_MASS_REBOOK';

Line 5838: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,

5834: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5835: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5836: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5837: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5838: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
5839: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5840: ) IS
5841:
5842: l_api_name VARCHAR2(35) := 'apply_mass_rebook';