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 698: -- Get all the FA books (corp and tax) that asset belongs to

694: AND a.lse_id = b.id
695: AND b.lty_code = 'FREE_FORM1'
696: AND a.sts_code = cp_sts_code;
697:
698: -- Get all the FA books (corp and tax) that asset belongs to
699: CURSOR l_fabooks_csr(cp_asset_number IN VARCHAR2, cp_sysdate IN DATE) IS
700: SELECT fb.book_type_code, fb.asset_id, fb.contract_id --SECHAWLA 02-Jan-08 6720667 : Added contract_id
701: FROM fa_books fb, fa_additions_b fab, fa_book_controls fbc
702: WHERE fb.asset_id = fab.asset_id

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

697:
698: -- Get all the FA books (corp and tax) that asset belongs to
699: CURSOR l_fabooks_csr(cp_asset_number IN VARCHAR2, cp_sysdate IN DATE) IS
700: SELECT fb.book_type_code, fb.asset_id, fb.contract_id --SECHAWLA 02-Jan-08 6720667 : Added contract_id
701: FROM fa_books fb, fa_additions_b fab, fa_book_controls fbc
702: WHERE fb.asset_id = fab.asset_id
703: AND fb.book_type_code = fbc.book_type_code
704: AND nvl(fbc.date_ineffective,cp_sysdate+1) > cp_sysdate
705: AND fb.transaction_header_id_out IS NULL

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

8102: AND LSE.LTY_CODE = 'FIXED_ASSET';
8103:
8104: l_cim_asset_id c_cim_asset_id%ROWTYPE;
8105:
8106: CURSOR c_get_fa_books( p_book_type_code FA_BOOKS.BOOK_TYPE_CODE%TYPE,
8107: p_asset_id FA_BOOKS.ASSET_ID%TYPE) IS
8108: SELECT DEPRN_METHOD_CODE,
8109: LIFE_IN_MONTHS,
8110: COST,

Line 8107: p_asset_id FA_BOOKS.ASSET_ID%TYPE) IS

8103:
8104: l_cim_asset_id c_cim_asset_id%ROWTYPE;
8105:
8106: CURSOR c_get_fa_books( p_book_type_code FA_BOOKS.BOOK_TYPE_CODE%TYPE,
8107: p_asset_id FA_BOOKS.ASSET_ID%TYPE) IS
8108: SELECT DEPRN_METHOD_CODE,
8109: LIFE_IN_MONTHS,
8110: COST,
8111: SALVAGE_VALUE

Line 8112: FROM FA_BOOKS

8108: SELECT DEPRN_METHOD_CODE,
8109: LIFE_IN_MONTHS,
8110: COST,
8111: SALVAGE_VALUE
8112: FROM FA_BOOKS
8113: WHERE ASSET_ID = p_asset_id
8114: AND BOOK_TYPE_CODE = p_book_type_code ;
8115:
8116: l_get_fa_books c_get_fa_books%ROWTYPE;

Line 8116: l_get_fa_books c_get_fa_books%ROWTYPE;

8112: FROM FA_BOOKS
8113: WHERE ASSET_ID = p_asset_id
8114: AND BOOK_TYPE_CODE = p_book_type_code ;
8115:
8116: l_get_fa_books c_get_fa_books%ROWTYPE;
8117:
8118: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;
8119: l_max_books NUMBER;
8120:

Line 8390: 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);

8386: END IF;
8387:
8388: IF (l_counter > 1) THEN
8389: IF (is_debug_statement_on) THEN
8390: 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);
8391: END IF;
8392:
8393: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8394: FETCH c_get_fa_books INTO l_get_fa_books;

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

8389: IF (is_debug_statement_on) THEN
8390: 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);
8391: END IF;
8392:
8393: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8394: FETCH c_get_fa_books INTO l_get_fa_books;
8395: IF c_get_fa_books%NOTFOUND THEN
8396: IF (is_debug_statement_on) THEN
8397: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'No Data Found in Cursor c_get_fa_books');

Line 8394: FETCH c_get_fa_books INTO l_get_fa_books;

8390: 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);
8391: END IF;
8392:
8393: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8394: FETCH c_get_fa_books INTO l_get_fa_books;
8395: IF c_get_fa_books%NOTFOUND THEN
8396: IF (is_debug_statement_on) THEN
8397: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'No Data Found in Cursor c_get_fa_books');
8398: END IF;

Line 8395: IF c_get_fa_books%NOTFOUND THEN

8391: END IF;
8392:
8393: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8394: FETCH c_get_fa_books INTO l_get_fa_books;
8395: IF c_get_fa_books%NOTFOUND THEN
8396: IF (is_debug_statement_on) THEN
8397: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'No Data Found in Cursor c_get_fa_books');
8398: END IF;
8399: CLOSE c_get_fa_books;

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

8393: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
8394: FETCH c_get_fa_books INTO l_get_fa_books;
8395: IF c_get_fa_books%NOTFOUND THEN
8396: IF (is_debug_statement_on) THEN
8397: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'No Data Found in Cursor c_get_fa_books');
8398: END IF;
8399: CLOSE c_get_fa_books;
8400: ELSE
8401: l_txdv_rec.OBJECT_VERSION_NUMBER := 1;

Line 8399: CLOSE c_get_fa_books;

8395: IF c_get_fa_books%NOTFOUND THEN
8396: IF (is_debug_statement_on) THEN
8397: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'No Data Found in Cursor c_get_fa_books');
8398: END IF;
8399: CLOSE c_get_fa_books;
8400: ELSE
8401: l_txdv_rec.OBJECT_VERSION_NUMBER := 1;
8402: l_txdv_rec.TAL_ID := x_talv_rec.ID;
8403: l_txdv_rec.LINE_DETAIL_NUMBER := l_line_detail_number;

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

8404: l_txdv_rec.ASSET_NUMBER := l_talv_rec.asset_number;
8405:
8406: l_txdv_rec.QUANTITY := l_model_line_rec.number_of_items;
8407:
8408: l_txdv_rec.COST := l_get_fa_books.COST;
8409:
8410: l_txdv_rec.TAX_BOOK := l_asset_hdr_rec.book_type_code;
8411:
8412: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;

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

8408: l_txdv_rec.COST := l_get_fa_books.COST;
8409:
8410: l_txdv_rec.TAX_BOOK := l_asset_hdr_rec.book_type_code;
8411:
8412: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;
8413:
8414: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
8415:
8416: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;

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

8410: l_txdv_rec.TAX_BOOK := l_asset_hdr_rec.book_type_code;
8411:
8412: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;
8413:
8414: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
8415:
8416: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;
8417:
8418: CLOSE c_get_fa_books;

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

8412: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;
8413:
8414: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
8415:
8416: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;
8417:
8418: CLOSE c_get_fa_books;
8419:
8420: IF (is_debug_statement_on) THEN

Line 8418: CLOSE c_get_fa_books;

8414: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
8415:
8416: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;
8417:
8418: CLOSE c_get_fa_books;
8419:
8420: IF (is_debug_statement_on) THEN
8421: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_TXD_ASSETS_PUB.create_txd_asset_def');
8422: END IF;

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

8698: AND LSE.LTY_CODE = 'FIXED_ASSET';
8699:
8700: l_cim_asset_id c_cim_asset_id%ROWTYPE;
8701:
8702: CURSOR c_get_fa_books( p_book_type_code FA_BOOKS.BOOK_TYPE_CODE%TYPE,
8703: p_asset_id FA_BOOKS.ASSET_ID%TYPE) IS
8704: SELECT DEPRN_METHOD_CODE,
8705: LIFE_IN_MONTHS,
8706: COST,

Line 8703: p_asset_id FA_BOOKS.ASSET_ID%TYPE) IS

8699:
8700: l_cim_asset_id c_cim_asset_id%ROWTYPE;
8701:
8702: CURSOR c_get_fa_books( p_book_type_code FA_BOOKS.BOOK_TYPE_CODE%TYPE,
8703: p_asset_id FA_BOOKS.ASSET_ID%TYPE) IS
8704: SELECT DEPRN_METHOD_CODE,
8705: LIFE_IN_MONTHS,
8706: COST,
8707: SALVAGE_VALUE

Line 8708: FROM FA_BOOKS

8704: SELECT DEPRN_METHOD_CODE,
8705: LIFE_IN_MONTHS,
8706: COST,
8707: SALVAGE_VALUE
8708: FROM FA_BOOKS
8709: WHERE ASSET_ID = p_asset_id
8710: AND BOOK_TYPE_CODE = p_book_type_code ;
8711:
8712: l_get_fa_books c_get_fa_books%ROWTYPE;

Line 8712: l_get_fa_books c_get_fa_books%ROWTYPE;

8708: FROM FA_BOOKS
8709: WHERE ASSET_ID = p_asset_id
8710: AND BOOK_TYPE_CODE = p_book_type_code ;
8711:
8712: l_get_fa_books c_get_fa_books%ROWTYPE;
8713:
8714: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;
8715: l_max_books NUMBER;
8716:

Line 9024: 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);

9020: END IF;
9021:
9022: IF (l_counter > 1) THEN
9023: IF (is_debug_statement_on) THEN
9024: 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);
9025: END IF;
9026: okl_debug_pub.logmessage('AKP:Before open c_get_fa_books');
9027: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
9028: FETCH c_get_fa_books INTO l_get_fa_books;

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

9022: IF (l_counter > 1) THEN
9023: IF (is_debug_statement_on) THEN
9024: 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);
9025: END IF;
9026: okl_debug_pub.logmessage('AKP:Before open c_get_fa_books');
9027: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
9028: FETCH c_get_fa_books INTO l_get_fa_books;
9029: okl_debug_pub.logmessage('AKP:After fetch c_get_fa_books');
9030: IF c_get_fa_books%NOTFOUND THEN

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

9023: IF (is_debug_statement_on) THEN
9024: 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);
9025: END IF;
9026: okl_debug_pub.logmessage('AKP:Before open c_get_fa_books');
9027: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
9028: FETCH c_get_fa_books INTO l_get_fa_books;
9029: okl_debug_pub.logmessage('AKP:After fetch c_get_fa_books');
9030: IF c_get_fa_books%NOTFOUND THEN
9031: CLOSE c_get_fa_books;

Line 9028: FETCH c_get_fa_books INTO l_get_fa_books;

9024: 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);
9025: END IF;
9026: okl_debug_pub.logmessage('AKP:Before open c_get_fa_books');
9027: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
9028: FETCH c_get_fa_books INTO l_get_fa_books;
9029: okl_debug_pub.logmessage('AKP:After fetch c_get_fa_books');
9030: IF c_get_fa_books%NOTFOUND THEN
9031: CLOSE c_get_fa_books;
9032: ELSE

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

9025: END IF;
9026: okl_debug_pub.logmessage('AKP:Before open c_get_fa_books');
9027: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
9028: FETCH c_get_fa_books INTO l_get_fa_books;
9029: okl_debug_pub.logmessage('AKP:After fetch c_get_fa_books');
9030: IF c_get_fa_books%NOTFOUND THEN
9031: CLOSE c_get_fa_books;
9032: ELSE
9033: l_txdv_rec.OBJECT_VERSION_NUMBER := 1;

Line 9030: IF c_get_fa_books%NOTFOUND THEN

9026: okl_debug_pub.logmessage('AKP:Before open c_get_fa_books');
9027: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
9028: FETCH c_get_fa_books INTO l_get_fa_books;
9029: okl_debug_pub.logmessage('AKP:After fetch c_get_fa_books');
9030: IF c_get_fa_books%NOTFOUND THEN
9031: CLOSE c_get_fa_books;
9032: ELSE
9033: l_txdv_rec.OBJECT_VERSION_NUMBER := 1;
9034: l_txdv_rec.TAL_ID := x_talv_rec.ID;

Line 9031: CLOSE c_get_fa_books;

9027: OPEN c_get_fa_books(l_asset_hdr_rec.book_type_code, l_asset_id);
9028: FETCH c_get_fa_books INTO l_get_fa_books;
9029: okl_debug_pub.logmessage('AKP:After fetch c_get_fa_books');
9030: IF c_get_fa_books%NOTFOUND THEN
9031: CLOSE c_get_fa_books;
9032: ELSE
9033: l_txdv_rec.OBJECT_VERSION_NUMBER := 1;
9034: l_txdv_rec.TAL_ID := x_talv_rec.ID;
9035: l_txdv_rec.LINE_DETAIL_NUMBER := l_line_detail_number;

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

9036: l_txdv_rec.ASSET_NUMBER := l_talv_rec.asset_number;
9037:
9038: l_txdv_rec.QUANTITY := l_model_line_rec.number_of_items;
9039:
9040: l_txdv_rec.COST := l_get_fa_books.COST;
9041:
9042: l_txdv_rec.TAX_BOOK := l_asset_hdr_rec.book_type_code;
9043:
9044: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;

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

9040: l_txdv_rec.COST := l_get_fa_books.COST;
9041:
9042: l_txdv_rec.TAX_BOOK := l_asset_hdr_rec.book_type_code;
9043:
9044: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;
9045:
9046: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
9047:
9048: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;

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

9042: l_txdv_rec.TAX_BOOK := l_asset_hdr_rec.book_type_code;
9043:
9044: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;
9045:
9046: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
9047:
9048: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;
9049:
9050: CLOSE c_get_fa_books;

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

9044: l_txdv_rec.LIFE_IN_MONTHS_TAX := l_get_fa_books.LIFE_IN_MONTHS;
9045:
9046: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
9047:
9048: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;
9049:
9050: CLOSE c_get_fa_books;
9051:
9052: IF (is_debug_statement_on) THEN

Line 9050: CLOSE c_get_fa_books;

9046: l_txdv_rec.DEPRN_METHOD_TAX := l_get_fa_books.DEPRN_METHOD_CODE;
9047:
9048: l_txdv_rec.SALVAGE_VALUE := l_get_fa_books.SALVAGE_VALUE;
9049:
9050: CLOSE c_get_fa_books;
9051:
9052: IF (is_debug_statement_on) THEN
9053: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_TXD_ASSETS_PUB.create_txd_asset_def');
9054: END IF;