[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';
4864: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
4865: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
4866: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
4867: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
4868: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
4869: p_strm_lalevl_tbl IN strm_lalevl_tbl_type
4870: ) IS
4871: l_api_name VARCHAR2(35) := 'apply_mass_rebook';
4872: l_proc_name VARCHAR2(35) := 'APPLY_MASS_REBOOK';
5047: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
5048: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
5049: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
5050: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5051: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5052: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5053: x_stream_trx_tbl OUT NOCOPY strm_trx_tbl_type
5054: ) IS
5055: l_api_name VARCHAR2(35) := 'apply_mass_rebook';
5245: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
5246: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%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
5444: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
5445: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
5446: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
5447: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5448: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5449: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5450: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5451: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5452: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5690: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
5691: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
5692: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
5693: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%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,