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 4663: l_book_type_code FA_BOOKS.BOOK_TYPE_CODE%TYPE := NULL;

4659: l_in_service_date DATE := NULL;
4660: l_life_in_months NUMBER := NULL;
4661: l_basic_rate NUMBER := NULL;
4662: l_adjusted_rate NUMBER := NULL;
4663: l_book_type_code FA_BOOKS.BOOK_TYPE_CODE%TYPE := NULL;
4664:
4665: l_contract_id NUMBER;
4666: l_line_count NUMBER := 0;
4667: l_prev_contract_id NUMBER;

Line 5003: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,

4999: x_return_status OUT NOCOPY VARCHAR2,
5000: x_msg_count OUT NOCOPY NUMBER,
5001: x_msg_data OUT NOCOPY VARCHAR2,
5002: p_rbk_tbl IN rbk_tbl_type,
5003: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5004: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,

5000: x_msg_count OUT NOCOPY NUMBER,
5001: x_msg_data OUT NOCOPY VARCHAR2,
5002: p_rbk_tbl IN rbk_tbl_type,
5003: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5005: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,

5001: x_msg_data OUT NOCOPY VARCHAR2,
5002: p_rbk_tbl IN rbk_tbl_type,
5003: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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

Line 5006: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,

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

Line 5007: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,

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

Line 5186: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,

5182: x_return_status OUT NOCOPY VARCHAR2,
5183: x_msg_count OUT NOCOPY NUMBER,
5184: x_msg_data OUT NOCOPY VARCHAR2,
5185: p_rbk_tbl IN rbk_tbl_type,
5186: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5187: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,

5183: x_msg_count OUT NOCOPY NUMBER,
5184: x_msg_data OUT NOCOPY VARCHAR2,
5185: p_rbk_tbl IN rbk_tbl_type,
5186: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5188: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,

5184: x_msg_data OUT NOCOPY VARCHAR2,
5185: p_rbk_tbl IN rbk_tbl_type,
5186: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5189: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,

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

Line 5190: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,

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

Line 5384: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,

5380: x_return_status OUT NOCOPY VARCHAR2,
5381: x_msg_count OUT NOCOPY NUMBER,
5382: x_msg_data OUT NOCOPY VARCHAR2,
5383: p_rbk_tbl IN rbk_tbl_type,
5384: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5385: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,

5381: x_msg_count OUT NOCOPY NUMBER,
5382: x_msg_data OUT NOCOPY VARCHAR2,
5383: p_rbk_tbl IN rbk_tbl_type,
5384: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5386: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,

5382: x_msg_data OUT NOCOPY VARCHAR2,
5383: p_rbk_tbl IN rbk_tbl_type,
5384: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5387: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,

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

Line 5388: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,

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

Line 5583: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,

5579: x_return_status OUT NOCOPY VARCHAR2,
5580: x_msg_count OUT NOCOPY NUMBER,
5581: x_msg_data OUT NOCOPY VARCHAR2,
5582: p_rbk_tbl IN rbk_tbl_type,
5583: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5584: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,

5580: x_msg_count OUT NOCOPY NUMBER,
5581: x_msg_data OUT NOCOPY VARCHAR2,
5582: p_rbk_tbl IN rbk_tbl_type,
5583: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5585: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,

5581: x_msg_data OUT NOCOPY VARCHAR2,
5582: p_rbk_tbl IN rbk_tbl_type,
5583: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
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,

Line 5586: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,

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

Line 5587: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,

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

Line 5829: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,

5825: x_return_status OUT NOCOPY VARCHAR2,
5826: x_msg_count OUT NOCOPY NUMBER,
5827: x_msg_data OUT NOCOPY VARCHAR2,
5828: p_rbk_tbl IN rbk_tbl_type,
5829: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%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,

Line 5830: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,

5826: x_msg_count OUT NOCOPY NUMBER,
5827: x_msg_data OUT NOCOPY VARCHAR2,
5828: p_rbk_tbl IN rbk_tbl_type,
5829: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%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,

Line 5831: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,

5827: x_msg_data OUT NOCOPY VARCHAR2,
5828: p_rbk_tbl IN rbk_tbl_type,
5829: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%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,

Line 5832: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,

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

Line 5833: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,

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