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 FA_BOOKS

Line 308: l_query := l_query || 'EXISTS ( SELECT 1 FROM OKC_K_ITEMS_V ITEM, FA_BOOKS FB ';

304: l_asset_row := l_asset_row + 1;
305: l_asset_query_present := 'T';
306: l_query := l_query || l_clause || ' ';
307: IF (l_asset_row = 1) THEN -- First Asset Criteria
308: l_query := l_query || 'EXISTS ( SELECT 1 FROM OKC_K_ITEMS_V ITEM, FA_BOOKS FB ';
309: l_query := l_query || 'WHERE ITEM.JTOT_OBJECT1_CODE = '||''''||'OKX_ASSET'||'''';
310: l_query := l_query || ' AND ITEM.DNZ_CHR_ID = CON.ID ';
311: l_query := l_query || ' AND LINE.ID = ITEM.CLE_ID ';
312: l_query := l_query || ' AND ITEM.OBJECT1_ID1 = FB.ASSET_ID AND';

Line 335: -- go to FA_BOOKS

331: l_query := l_query || ' FB.'||l_criteria_code|| ' ' || upper(rbk_rec.operand) || ' ' || l_fmt_criteria1;
332: --insert into dd_dummy values (6,l_query);
333: END IF;
334:
335: -- go to FA_BOOKS
336: -- Add criteria from OKL_TXD_ASSETS_V and OKL_TXL_ASSETS_V
337: --
338: END IF;
339: ELSIF (l_criteria_code = 'ASSET_CATEGORY_ID') THEN

Line 1359: p_book_type_code IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,

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,
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,

Line 1360: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,

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,
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 ,

Line 1361: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%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,
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

Line 1362: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%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,
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

Line 1363: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,

1359: p_book_type_code IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,
1360: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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';

Line 1364: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE ,

1360: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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';

Line 2359: p_book_type_code IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,

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,
2360: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 2360: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%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,
2360: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 2361: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%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,
2360: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 2362: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,

2358: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
2359: p_book_type_code IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,
2360: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 2363: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,

2359: p_book_type_code IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,
2360: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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

Line 2364: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,

2360: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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

Line 4523: l_book_type_code FA_BOOKS.BOOK_TYPE_CODE%TYPE := NULL;

4519: l_in_service_date DATE := NULL;
4520: l_life_in_months NUMBER := NULL;
4521: l_basic_rate NUMBER := NULL;
4522: l_adjusted_rate NUMBER := NULL;
4523: l_book_type_code FA_BOOKS.BOOK_TYPE_CODE%TYPE := NULL;
4524:
4525: l_contract_id NUMBER;
4526: l_line_count NUMBER := 0;
4527: l_prev_contract_id NUMBER;

Line 4863: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,

4859: x_return_status OUT NOCOPY VARCHAR2,
4860: x_msg_count OUT NOCOPY NUMBER,
4861: x_msg_data OUT NOCOPY VARCHAR2,
4862: p_rbk_tbl IN rbk_tbl_type,
4863: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 4864: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,

4860: x_msg_count OUT NOCOPY NUMBER,
4861: x_msg_data OUT NOCOPY VARCHAR2,
4862: p_rbk_tbl IN rbk_tbl_type,
4863: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 4865: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,

4861: x_msg_data OUT NOCOPY VARCHAR2,
4862: p_rbk_tbl IN rbk_tbl_type,
4863: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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

Line 4866: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,

4862: p_rbk_tbl IN rbk_tbl_type,
4863: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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

Line 4867: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,

4863: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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';

Line 5046: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,

5042: x_return_status OUT NOCOPY VARCHAR2,
5043: x_msg_count OUT NOCOPY NUMBER,
5044: x_msg_data OUT NOCOPY VARCHAR2,
5045: p_rbk_tbl IN rbk_tbl_type,
5046: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5047: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,

5043: x_msg_count OUT NOCOPY NUMBER,
5044: x_msg_data OUT NOCOPY VARCHAR2,
5045: p_rbk_tbl IN rbk_tbl_type,
5046: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5048: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,

5044: x_msg_data OUT NOCOPY VARCHAR2,
5045: p_rbk_tbl IN rbk_tbl_type,
5046: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5049: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,

5045: p_rbk_tbl IN rbk_tbl_type,
5046: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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

Line 5050: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,

5046: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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

Line 5244: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,

5240: x_return_status OUT NOCOPY VARCHAR2,
5241: x_msg_count OUT NOCOPY NUMBER,
5242: x_msg_data OUT NOCOPY VARCHAR2,
5243: p_rbk_tbl IN rbk_tbl_type,
5244: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5245: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,

5241: x_msg_count OUT NOCOPY NUMBER,
5242: x_msg_data OUT NOCOPY VARCHAR2,
5243: p_rbk_tbl IN rbk_tbl_type,
5244: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5246: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,

5242: x_msg_data OUT NOCOPY VARCHAR2,
5243: p_rbk_tbl IN rbk_tbl_type,
5244: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5247: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,

5243: p_rbk_tbl IN rbk_tbl_type,
5244: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5248: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,

5244: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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

Line 5443: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,

5439: x_return_status OUT NOCOPY VARCHAR2,
5440: x_msg_count OUT NOCOPY NUMBER,
5441: x_msg_data OUT NOCOPY VARCHAR2,
5442: p_rbk_tbl IN rbk_tbl_type,
5443: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5444: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,

5440: x_msg_count OUT NOCOPY NUMBER,
5441: x_msg_data OUT NOCOPY VARCHAR2,
5442: p_rbk_tbl IN rbk_tbl_type,
5443: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5445: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,

5441: x_msg_data OUT NOCOPY VARCHAR2,
5442: p_rbk_tbl IN rbk_tbl_type,
5443: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5446: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,

5442: p_rbk_tbl IN rbk_tbl_type,
5443: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5447: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,

5443: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5689: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,

5685: x_return_status OUT NOCOPY VARCHAR2,
5686: x_msg_count OUT NOCOPY NUMBER,
5687: x_msg_data OUT NOCOPY VARCHAR2,
5688: p_rbk_tbl IN rbk_tbl_type,
5689: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%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,

Line 5690: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,

5686: x_msg_count OUT NOCOPY NUMBER,
5687: x_msg_data OUT NOCOPY VARCHAR2,
5688: p_rbk_tbl IN rbk_tbl_type,
5689: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%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,

Line 5691: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,

5687: x_msg_data OUT NOCOPY VARCHAR2,
5688: p_rbk_tbl IN rbk_tbl_type,
5689: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%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,

Line 5692: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,

5688: p_rbk_tbl IN rbk_tbl_type,
5689: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%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,

Line 5693: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,

5689: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%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,