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 2926: CURSOR rbk_csr (p_request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE,

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

Line 2929: FROM okl_rbk_selected_contract

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;
2932:
2933: l_mstv_upd_tbl mstv_tbl_type;

Line 3509: FROM okl_rbk_selected_contract A,

3505: --Bug# 4107330
3506: A.TRANSACTION_DATE,
3507: B.MULTI_GAAP_YN, -- MGAAP 7263041
3508: C.REPORTING_PDT_ID -- MGAAP 7263041
3509: FROM okl_rbk_selected_contract A,
3510: okl_k_headers B,
3511: okl_products C
3512: WHERE A.khr_id = p_chr_id
3513: AND NVL(A.status,'NEW') = 'UNDER REVISION'

Line 3530: l_rbk_id okl_rbk_selected_contract.id%TYPE;

3526: select tcn_type
3527: from okl_trx_contracts
3528: where id = p_trx_id;
3529:
3530: l_rbk_id okl_rbk_selected_contract.id%TYPE;
3531: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
3532: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
3533:
3534: -- MGAAP start 7263041

Line 3531: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;

3527: from okl_trx_contracts
3528: where id = p_trx_id;
3529:
3530: l_rbk_id okl_rbk_selected_contract.id%TYPE;
3531: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
3532: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
3533:
3534: -- MGAAP start 7263041
3535: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;

Line 3532: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;

3528: where id = p_trx_id;
3529:
3530: l_rbk_id okl_rbk_selected_contract.id%TYPE;
3531: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
3532: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
3533:
3534: -- MGAAP start 7263041
3535: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;
3536: l_reporting_pdt_id okl_products.reporting_pdt_id%TYPE;

Line 3540: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;

3536: l_reporting_pdt_id okl_products.reporting_pdt_id%TYPE;
3537: -- MGAAP end 7263041
3538:
3539: --Bug# 4107330
3540: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;
3541: l_request_name okl_rbk_selected_contract.request_name%TYPE;
3542:
3543: l_parent_tcn_type okl_trx_contracts.tcn_type%TYPE;
3544: l_mstv_tbl mstv_tbl_type;

Line 3541: l_request_name okl_rbk_selected_contract.request_name%TYPE;

3537: -- MGAAP end 7263041
3538:
3539: --Bug# 4107330
3540: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;
3541: l_request_name okl_rbk_selected_contract.request_name%TYPE;
3542:
3543: l_parent_tcn_type okl_trx_contracts.tcn_type%TYPE;
3544: l_mstv_tbl mstv_tbl_type;
3545: x_mstv_tbl mstv_tbl_type;

Line 4253: FROM okl_rbk_selected_contract

4249: KHR_ID,
4250: TRANSACTION_ID,
4251: --Bug# 4107330
4252: TRANSACTION_DATE
4253: FROM okl_rbk_selected_contract
4254: WHERE khr_id = p_chr_id
4255: AND NVL(status,'NEW') = 'UNDER REVISION';
4256: --AND NVL(status,'NEW') <> 'PROCESSED';
4257:

Line 4258: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;

4254: WHERE khr_id = p_chr_id
4255: AND NVL(status,'NEW') = 'UNDER REVISION';
4256: --AND NVL(status,'NEW') <> 'PROCESSED';
4257:
4258: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
4259: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
4260: --Bug# 4107330
4261: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;
4262: l_request_name okl_rbk_selected_contract.request_name%TYPE;

Line 4259: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;

4255: AND NVL(status,'NEW') = 'UNDER REVISION';
4256: --AND NVL(status,'NEW') <> 'PROCESSED';
4257:
4258: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
4259: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
4260: --Bug# 4107330
4261: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;
4262: l_request_name okl_rbk_selected_contract.request_name%TYPE;
4263:

Line 4261: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;

4257:
4258: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
4259: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
4260: --Bug# 4107330
4261: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;
4262: l_request_name okl_rbk_selected_contract.request_name%TYPE;
4263:
4264: after_yield_failed EXCEPTION;
4265: not_to_process EXCEPTION;

Line 4262: l_request_name okl_rbk_selected_contract.request_name%TYPE;

4258: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
4259: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
4260: --Bug# 4107330
4261: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;
4262: l_request_name okl_rbk_selected_contract.request_name%TYPE;
4263:
4264: after_yield_failed EXCEPTION;
4265: not_to_process EXCEPTION;
4266:

Line 4408: FROM okl_rbk_selected_contract

4404: SELECT DISTINCT
4405: REQUEST_NAME,
4406: KHR_ID,
4407: TRANSACTION_ID
4408: FROM okl_rbk_selected_contract
4409: WHERE khr_id = p_chr_id
4410: AND NVL(status,'NEW') <> 'PROCESSED';
4411:
4412: l_mstv_tbl mstv_tbl_type;

Line 4537: l_transaction_date OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE;

4533:
4534: l_kle_tbl kle_tbl_type;
4535: l_strm_lalevl_tbl strm_lalevl_tbl_type;
4536:
4537: l_transaction_date OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE;
4538:
4539: CURSOR rbk_set_csr (p_req_name VARCHAR2) IS
4540: SELECT criteria_code,
4541: criteria_value1,

Line 4559: FROM okl_rbk_selected_contract rbk

4555: rbk.contract_description,
4556: rbk.kle_id,
4557: rbk.transaction_date,
4558: khr.object_version_number
4559: FROM okl_rbk_selected_contract rbk
4560: , okl_k_headers khr
4561: WHERE
4562: rbk.request_name = p_req_name
4563: AND rbk.selected_flag = 'Y'

Line 5251: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,

5247: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
5248: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5249: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5250: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5251: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
5252: x_stream_trx_tbl OUT NOCOPY strm_trx_tbl_type
5253: ) IS
5254: l_api_name VARCHAR2(35) := 'apply_mass_rebook';
5255: l_proc_name VARCHAR2(35) := 'APPLY_MASS_REBOOK';

Line 5698: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,

5694: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5695: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5696: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5697: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5698: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
5699: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5700: ) IS
5701:
5702: l_api_name VARCHAR2(35) := 'apply_mass_rebook';