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_AM_LEASE_TRMNT_PVT dependencies on FA_BOOKS

Line 582: -- Get all the FA books (corp and tax) that asset belongs to

578: AND a.lse_id = b.id
579: AND b.lty_code = 'FREE_FORM1'
580: AND a.sts_code = cp_sts_code;
581:
582: -- Get all the FA books (corp and tax) that asset belongs to
583: CURSOR l_fabooks_csr(cp_asset_number IN VARCHAR2, cp_sysdate IN DATE) IS
584: SELECT fb.book_type_code, fb.asset_id, fb.contract_id --SECHAWLA 02-Jan-08 6720667 : Added contract_id
585: FROM fa_books fb, fa_additions_b fab, fa_book_controls fbc
586: WHERE fb.asset_id = fab.asset_id

Line 585: FROM fa_books fb, fa_additions_b fab, fa_book_controls fbc

581:
582: -- Get all the FA books (corp and tax) that asset belongs to
583: CURSOR l_fabooks_csr(cp_asset_number IN VARCHAR2, cp_sysdate IN DATE) IS
584: SELECT fb.book_type_code, fb.asset_id, fb.contract_id --SECHAWLA 02-Jan-08 6720667 : Added contract_id
585: FROM fa_books fb, fa_additions_b fab, fa_book_controls fbc
586: WHERE fb.asset_id = fab.asset_id
587: AND fb.book_type_code = fbc.book_type_code
588: AND nvl(fbc.date_ineffective,cp_sysdate+1) > cp_sysdate
589: AND fb.transaction_header_id_out IS NULL

Line 7907: CURSOR c_get_fa_books( p_book_type_code FA_BOOKS.BOOK_TYPE_CODE%TYPE,

7903: AND LSE.LTY_CODE = 'FIXED_ASSET';
7904:
7905: l_cim_asset_id c_cim_asset_id%ROWTYPE;
7906:
7907: CURSOR c_get_fa_books( p_book_type_code FA_BOOKS.BOOK_TYPE_CODE%TYPE,
7908: p_asset_id FA_BOOKS.ASSET_ID%TYPE) IS
7909: SELECT DEPRN_METHOD_CODE,
7910: LIFE_IN_MONTHS,
7911: COST,

Line 7908: p_asset_id FA_BOOKS.ASSET_ID%TYPE) IS

7904:
7905: l_cim_asset_id c_cim_asset_id%ROWTYPE;
7906:
7907: CURSOR c_get_fa_books( p_book_type_code FA_BOOKS.BOOK_TYPE_CODE%TYPE,
7908: p_asset_id FA_BOOKS.ASSET_ID%TYPE) IS
7909: SELECT DEPRN_METHOD_CODE,
7910: LIFE_IN_MONTHS,
7911: COST,
7912: SALVAGE_VALUE

Line 7913: FROM FA_BOOKS

7909: SELECT DEPRN_METHOD_CODE,
7910: LIFE_IN_MONTHS,
7911: COST,
7912: SALVAGE_VALUE
7913: FROM FA_BOOKS
7914: WHERE ASSET_ID = p_asset_id
7915: AND BOOK_TYPE_CODE = p_book_type_code ;
7916:
7917: l_get_fa_books c_get_fa_books%ROWTYPE;

Line 7917: l_get_fa_books c_get_fa_books%ROWTYPE;

7913: FROM FA_BOOKS
7914: WHERE ASSET_ID = p_asset_id
7915: AND BOOK_TYPE_CODE = p_book_type_code ;
7916:
7917: l_get_fa_books c_get_fa_books%ROWTYPE;
7918:
7919: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;
7920: l_max_books NUMBER;
7921:

Line 8191: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Before opening c_get_fa_books l_asset_hdr_rec.book_type_code = '||l_asset_hdr_rec.book_type_code);

8187: END IF;
8188:
8189: IF (l_counter > 1) THEN
8190: IF (is_debug_statement_on) THEN
8191: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Before opening c_get_fa_books l_asset_hdr_rec.book_type_code = '||l_asset_hdr_rec.book_type_code);
8192: END IF;
8193:
8194: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8195: FETCH c_get_fa_books INTO l_get_fa_books;

Line 8194: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);

8190: IF (is_debug_statement_on) THEN
8191: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Before opening c_get_fa_books l_asset_hdr_rec.book_type_code = '||l_asset_hdr_rec.book_type_code);
8192: END IF;
8193:
8194: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8195: FETCH c_get_fa_books INTO l_get_fa_books;
8196: IF c_get_fa_books%NOTFOUND THEN
8197: IF (is_debug_statement_on) THEN
8198: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'No Data Found in Cursor c_get_fa_books');

Line 8195: FETCH c_get_fa_books INTO l_get_fa_books;

8191: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Before opening c_get_fa_books l_asset_hdr_rec.book_type_code = '||l_asset_hdr_rec.book_type_code);
8192: END IF;
8193:
8194: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8195: FETCH c_get_fa_books INTO l_get_fa_books;
8196: IF c_get_fa_books%NOTFOUND THEN
8197: IF (is_debug_statement_on) THEN
8198: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'No Data Found in Cursor c_get_fa_books');
8199: END IF;

Line 8196: IF c_get_fa_books%NOTFOUND THEN

8192: END IF;
8193:
8194: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8195: FETCH c_get_fa_books INTO l_get_fa_books;
8196: IF c_get_fa_books%NOTFOUND THEN
8197: IF (is_debug_statement_on) THEN
8198: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'No Data Found in Cursor c_get_fa_books');
8199: END IF;
8200: CLOSE c_get_fa_books;

Line 8198: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'No Data Found in Cursor c_get_fa_books');

8194: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8195: FETCH c_get_fa_books INTO l_get_fa_books;
8196: IF c_get_fa_books%NOTFOUND THEN
8197: IF (is_debug_statement_on) THEN
8198: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'No Data Found in Cursor c_get_fa_books');
8199: END IF;
8200: CLOSE c_get_fa_books;
8201: ELSE
8202: l_txdv_rec.OBJECT_VERSION_NUMBER := 1;

Line 8200: CLOSE c_get_fa_books;

8196: IF c_get_fa_books%NOTFOUND THEN
8197: IF (is_debug_statement_on) THEN
8198: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'No Data Found in Cursor c_get_fa_books');
8199: END IF;
8200: CLOSE c_get_fa_books;
8201: ELSE
8202: l_txdv_rec.OBJECT_VERSION_NUMBER := 1;
8203: l_txdv_rec.TAL_ID := x_talv_rec.ID;
8204: l_txdv_rec.LINE_DETAIL_NUMBER := l_line_detail_number;

Line 8209: l_txdv_rec.COST := l_get_fa_books.COST;

8205: l_txdv_rec.ASSET_NUMBER := l_talv_rec.asset_number;
8206:
8207: l_txdv_rec.QUANTITY := l_model_line_rec.number_of_items;
8208:
8209: l_txdv_rec.COST := l_get_fa_books.COST;
8210:
8211: l_txdv_rec.TAX_BOOK := l_asset_hdr_rec.book_type_code;
8212:
8213: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;

Line 8213: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;

8209: l_txdv_rec.COST := l_get_fa_books.COST;
8210:
8211: l_txdv_rec.TAX_BOOK := l_asset_hdr_rec.book_type_code;
8212:
8213: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;
8214:
8215: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
8216:
8217: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;

Line 8215: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;

8211: l_txdv_rec.TAX_BOOK := l_asset_hdr_rec.book_type_code;
8212:
8213: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;
8214:
8215: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
8216:
8217: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;
8218:
8219: CLOSE c_get_fa_books;

Line 8217: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;

8213: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;
8214:
8215: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
8216:
8217: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;
8218:
8219: CLOSE c_get_fa_books;
8220:
8221: IF (is_debug_statement_on) THEN

Line 8219: CLOSE c_get_fa_books;

8215: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
8216:
8217: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;
8218:
8219: CLOSE c_get_fa_books;
8220:
8221: IF (is_debug_statement_on) THEN
8222: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_TXD_ASSETS_PUB.create_txd_asset_def');
8223: END IF;

Line 8503: CURSOR c_get_fa_books( p_book_type_code FA_BOOKS.BOOK_TYPE_CODE%TYPE,

8499: AND LSE.LTY_CODE = 'FIXED_ASSET';
8500:
8501: l_cim_asset_id c_cim_asset_id%ROWTYPE;
8502:
8503: CURSOR c_get_fa_books( p_book_type_code FA_BOOKS.BOOK_TYPE_CODE%TYPE,
8504: p_asset_id FA_BOOKS.ASSET_ID%TYPE) IS
8505: SELECT DEPRN_METHOD_CODE,
8506: LIFE_IN_MONTHS,
8507: COST,

Line 8504: p_asset_id FA_BOOKS.ASSET_ID%TYPE) IS

8500:
8501: l_cim_asset_id c_cim_asset_id%ROWTYPE;
8502:
8503: CURSOR c_get_fa_books( p_book_type_code FA_BOOKS.BOOK_TYPE_CODE%TYPE,
8504: p_asset_id FA_BOOKS.ASSET_ID%TYPE) IS
8505: SELECT DEPRN_METHOD_CODE,
8506: LIFE_IN_MONTHS,
8507: COST,
8508: SALVAGE_VALUE

Line 8509: FROM FA_BOOKS

8505: SELECT DEPRN_METHOD_CODE,
8506: LIFE_IN_MONTHS,
8507: COST,
8508: SALVAGE_VALUE
8509: FROM FA_BOOKS
8510: WHERE ASSET_ID = p_asset_id
8511: AND BOOK_TYPE_CODE = p_book_type_code ;
8512:
8513: l_get_fa_books c_get_fa_books%ROWTYPE;

Line 8513: l_get_fa_books c_get_fa_books%ROWTYPE;

8509: FROM FA_BOOKS
8510: WHERE ASSET_ID = p_asset_id
8511: AND BOOK_TYPE_CODE = p_book_type_code ;
8512:
8513: l_get_fa_books c_get_fa_books%ROWTYPE;
8514:
8515: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;
8516: l_max_books NUMBER;
8517:

Line 8825: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Before opening c_get_fa_books l_asset_hdr_rec.book_type_code = '||l_asset_hdr_rec.book_type_code);

8821: END IF;
8822:
8823: IF (l_counter > 1) THEN
8824: IF (is_debug_statement_on) THEN
8825: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Before opening c_get_fa_books l_asset_hdr_rec.book_type_code = '||l_asset_hdr_rec.book_type_code);
8826: END IF;
8827: okl_debug_pub.logmessage('AKP:Before open c_get_fa_books');
8828: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8829: FETCH c_get_fa_books INTO l_get_fa_books;

Line 8827: okl_debug_pub.logmessage('AKP:Before open c_get_fa_books');

8823: IF (l_counter > 1) THEN
8824: IF (is_debug_statement_on) THEN
8825: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Before opening c_get_fa_books l_asset_hdr_rec.book_type_code = '||l_asset_hdr_rec.book_type_code);
8826: END IF;
8827: okl_debug_pub.logmessage('AKP:Before open c_get_fa_books');
8828: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8829: FETCH c_get_fa_books INTO l_get_fa_books;
8830: okl_debug_pub.logmessage('AKP:After fetch c_get_fa_books');
8831: IF c_get_fa_books%NOTFOUND THEN

Line 8828: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);

8824: IF (is_debug_statement_on) THEN
8825: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Before opening c_get_fa_books l_asset_hdr_rec.book_type_code = '||l_asset_hdr_rec.book_type_code);
8826: END IF;
8827: okl_debug_pub.logmessage('AKP:Before open c_get_fa_books');
8828: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8829: FETCH c_get_fa_books INTO l_get_fa_books;
8830: okl_debug_pub.logmessage('AKP:After fetch c_get_fa_books');
8831: IF c_get_fa_books%NOTFOUND THEN
8832: CLOSE c_get_fa_books;

Line 8829: FETCH c_get_fa_books INTO l_get_fa_books;

8825: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Before opening c_get_fa_books l_asset_hdr_rec.book_type_code = '||l_asset_hdr_rec.book_type_code);
8826: END IF;
8827: okl_debug_pub.logmessage('AKP:Before open c_get_fa_books');
8828: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8829: FETCH c_get_fa_books INTO l_get_fa_books;
8830: okl_debug_pub.logmessage('AKP:After fetch c_get_fa_books');
8831: IF c_get_fa_books%NOTFOUND THEN
8832: CLOSE c_get_fa_books;
8833: ELSE

Line 8830: okl_debug_pub.logmessage('AKP:After fetch c_get_fa_books');

8826: END IF;
8827: okl_debug_pub.logmessage('AKP:Before open c_get_fa_books');
8828: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8829: FETCH c_get_fa_books INTO l_get_fa_books;
8830: okl_debug_pub.logmessage('AKP:After fetch c_get_fa_books');
8831: IF c_get_fa_books%NOTFOUND THEN
8832: CLOSE c_get_fa_books;
8833: ELSE
8834: l_txdv_rec.OBJECT_VERSION_NUMBER := 1;

Line 8831: IF c_get_fa_books%NOTFOUND THEN

8827: okl_debug_pub.logmessage('AKP:Before open c_get_fa_books');
8828: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8829: FETCH c_get_fa_books INTO l_get_fa_books;
8830: okl_debug_pub.logmessage('AKP:After fetch c_get_fa_books');
8831: IF c_get_fa_books%NOTFOUND THEN
8832: CLOSE c_get_fa_books;
8833: ELSE
8834: l_txdv_rec.OBJECT_VERSION_NUMBER := 1;
8835: l_txdv_rec.TAL_ID := x_talv_rec.ID;

Line 8832: CLOSE c_get_fa_books;

8828: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8829: FETCH c_get_fa_books INTO l_get_fa_books;
8830: okl_debug_pub.logmessage('AKP:After fetch c_get_fa_books');
8831: IF c_get_fa_books%NOTFOUND THEN
8832: CLOSE c_get_fa_books;
8833: ELSE
8834: l_txdv_rec.OBJECT_VERSION_NUMBER := 1;
8835: l_txdv_rec.TAL_ID := x_talv_rec.ID;
8836: l_txdv_rec.LINE_DETAIL_NUMBER := l_line_detail_number;

Line 8841: l_txdv_rec.COST := l_get_fa_books.COST;

8837: l_txdv_rec.ASSET_NUMBER := l_talv_rec.asset_number;
8838:
8839: l_txdv_rec.QUANTITY := l_model_line_rec.number_of_items;
8840:
8841: l_txdv_rec.COST := l_get_fa_books.COST;
8842:
8843: l_txdv_rec.TAX_BOOK := l_asset_hdr_rec.book_type_code;
8844:
8845: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;

Line 8845: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;

8841: l_txdv_rec.COST := l_get_fa_books.COST;
8842:
8843: l_txdv_rec.TAX_BOOK := l_asset_hdr_rec.book_type_code;
8844:
8845: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;
8846:
8847: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
8848:
8849: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;

Line 8847: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;

8843: l_txdv_rec.TAX_BOOK := l_asset_hdr_rec.book_type_code;
8844:
8845: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;
8846:
8847: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
8848:
8849: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;
8850:
8851: CLOSE c_get_fa_books;

Line 8849: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;

8845: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;
8846:
8847: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
8848:
8849: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;
8850:
8851: CLOSE c_get_fa_books;
8852:
8853: IF (is_debug_statement_on) THEN

Line 8851: CLOSE c_get_fa_books;

8847: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
8848:
8849: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;
8850:
8851: CLOSE c_get_fa_books;
8852:
8853: IF (is_debug_statement_on) THEN
8854: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_TXD_ASSETS_PUB.create_txd_asset_def');
8855: END IF;