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_K_LINES

Line 36: ID OKL_K_LINES_V.ID%TYPE

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:

Line 219: l_query := l_query || ' OKL_K_LINES_FULL_V LINE ';

215:
216: l_asset_query_present := 'F'; -- Checks the presence of Asset Related Criteria
217:
218: l_query := 'SELECT CON.ID, CON.CONTRACT_NUMBER, LINE.ID, CON.SHORT_DESCRIPTION FROM OKL_K_HEADERS_FULL_V CON, ';
219: l_query := l_query || ' OKL_K_LINES_FULL_V LINE ';
220:
221: --insert into dd_dummy values (1,l_query);
222:
223: FOR rbk_rec IN mass_rbk_csr(p_request_name)

Line 1276: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE

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;

Line 1284: FROM okl_k_lines_full_v

1280: l_api_version NUMBER := 1.0;
1281:
1282: CURSOR oec_csr (p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
1283: SELECT oec
1284: FROM okl_k_lines_full_v
1285: WHERE id = p_top_line_id;
1286:
1287: l_oec NUMBER;
1288: l_residual_ptg NUMBER;

Line 1393: FROM OKL_K_LINES_FULL_V

1389:
1390: CURSOR addl_line_csr (p_fa_line_id NUMBER) IS
1391: SELECT oec,
1392: name
1393: FROM OKL_K_LINES_FULL_V
1394: WHERE id = (SELECT cle_id
1395: FROM okl_k_lines_full_v
1396: WHERE id = p_fa_line_id);
1397:

Line 1395: FROM okl_k_lines_full_v

1391: SELECT oec,
1392: name
1393: FROM OKL_K_LINES_FULL_V
1394: WHERE id = (SELECT cle_id
1395: FROM okl_k_lines_full_v
1396: WHERE id = p_fa_line_id);
1397:
1398: CURSOR unit_csr (p_fa_line_id NUMBER) IS
1399: SELECT number_of_items

Line 1425: l_name OKL_K_LINES_FULL_V.NAME%TYPE;

1421:
1422: l_try_id NUMBER;
1423: l_fa_line_id NUMBER;
1424:
1425: l_name OKL_K_LINES_FULL_V.NAME%TYPE;
1426: l_oec OKL_K_LINES_FULL_V.OEC%TYPE;
1427: l_no_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;
1428: l_corp_book OKX_AST_BKS_V.ID2%TYPE;
1429:

Line 1426: l_oec OKL_K_LINES_FULL_V.OEC%TYPE;

1422: l_try_id NUMBER;
1423: l_fa_line_id NUMBER;
1424:
1425: l_name OKL_K_LINES_FULL_V.NAME%TYPE;
1426: l_oec OKL_K_LINES_FULL_V.OEC%TYPE;
1427: l_no_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;
1428: l_corp_book OKX_AST_BKS_V.ID2%TYPE;
1429:
1430: l_tax_count NUMBER;

Line 2365: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%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
2369: l_api_name VARCHAR2(35) := 'rebook_contract';

Line 2424: okl_k_lines kle

2420: CURSOR l_chk_con_csr (chrid NUMBER) IS
2421: SELECT COUNT (*)
2422: FROM (SELECT COUNT(*)
2423: FROM okc_k_lines_b cleb,
2424: okl_k_lines kle
2425: WHERE kle.id = cleb.id
2426: AND cleb.chr_id = chrid
2427: --ndani - 27-Mar-2013 - Bug# 16552978 - Start
2428: AND cleb.dnz_chr_id = chrid

Line 2439: okl_k_lines kle

2435: -- cursor : to check whether Contract is having re-lease assets
2436: CURSOR l_con_rel_csr (chrid NUMBER) IS
2437: SELECT DISTINCT NVL(kle.re_lease_yn,'N')
2438: FROM okc_k_lines_b cleb,
2439: okl_k_lines kle
2440: WHERE kle.id = cleb.id
2441: AND cleb.chr_id = chrid
2442: --ndani - 27-Mar-2013 - Bug# 16552978 - Start
2443: AND cleb.dnz_chr_id = chrid

Line 2450: l_con_rel_flag okl_k_lines.re_lease_yn%TYPE;

2446: --ndani - 27-Mar-2013 - Bug# 16552978 - End
2447:
2448:
2449: l_chk_contract_count NUMBER := 0;
2450: l_con_rel_flag okl_k_lines.re_lease_yn%TYPE;
2451: l_acct_trans_type VARCHAR2 (256);
2452: l_acc_call_rel_flag VARCHAR2 (1) := 'N';
2453:
2454: --Bug# 16526329 , End

Line 5008: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%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';
5012: l_proc_name VARCHAR2(35) := 'APPLY_MASS_REBOOK';

Line 5191: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%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
5195: l_api_name VARCHAR2(35) := 'apply_mass_rebook';

Line 5389: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%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
5393: ) IS

Line 5588: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%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,
5592: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE

Line 5834: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%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,