[Home] [Help]
32: subtype rulv_rec_type IS OKL_RULE_PUB.rulv_rec_type;
33: subtype rulv_tbl_type IS OKL_RULE_PUB.rulv_tbl_type;
34:
35: /*TYPE kle_rec_type IS RECORD (
36: ID OKL_K_LINES_V.ID%TYPE
37: );
38:
39: TYPE kle_tbl_type IS TABLE OF kle_rec_type INDEX BY BINARY_INTEGER; */
40:
1272: x_return_status OUT NOCOPY VARCHAR2,
1273: x_msg_count OUT NOCOPY NUMBER,
1274: x_msg_data OUT NOCOPY VARCHAR2,
1275: p_kle_tbl IN kle_tbl_type,
1276: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE
1277: ) IS
1278: l_api_name VARCHAR2(35) := 'update_residual_value';
1279: l_proc_name VARCHAR2(35) := 'UPDATE_RESIDUAL_VALUE';
1280: l_api_version NUMBER := 1.0;
2361: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
2362: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
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';
5004: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
5005: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
5006: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
5007: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5008: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5009: p_strm_lalevl_tbl IN strm_lalevl_tbl_type
5010: ) IS
5011: l_api_name VARCHAR2(35) := 'apply_mass_rebook';
5012: l_proc_name VARCHAR2(35) := 'APPLY_MASS_REBOOK';
5187: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
5188: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
5189: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
5190: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5191: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5192: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5193: x_stream_trx_tbl OUT NOCOPY strm_trx_tbl_type
5194: ) IS
5195: l_api_name VARCHAR2(35) := 'apply_mass_rebook';
5385: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
5386: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%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
5584: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
5585: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
5586: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
5587: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5588: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5589: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5590: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5591: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5592: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5830: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
5831: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
5832: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
5833: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%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,