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.IGI_IAC_RECLASS_PKG dependencies on IGI_IAC_ASSET_BALANCES

Line 231: CURSOR c_asset_revalued(c_asset_id IGI_IAC_ASSET_BALANCES.asset_id%type) IS

227:
228: -- cursor for to check asset type
229: /* Cursor to find out NOCOPY if the asset is revalued atleast once */
230:
231: CURSOR c_asset_revalued(c_asset_id IGI_IAC_ASSET_BALANCES.asset_id%type) IS
232: SELECT 'X'
233: FROM igi_iac_asset_balances
234: WHERE asset_id=l_asset_hdr_rec.asset_id
235: AND book_type_code = l_asset_hdr_rec.book_type_code;

Line 233: FROM igi_iac_asset_balances

229: /* Cursor to find out NOCOPY if the asset is revalued atleast once */
230:
231: CURSOR c_asset_revalued(c_asset_id IGI_IAC_ASSET_BALANCES.asset_id%type) IS
232: SELECT 'X'
233: FROM igi_iac_asset_balances
234: WHERE asset_id=l_asset_hdr_rec.asset_id
235: AND book_type_code = l_asset_hdr_rec.book_type_code;
236:
237: l_asset_revalued c_asset_revalued%rowtype;

Line 1398: CURSOR c_amounts(c_period_counter IN IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS

1394:
1395: /* Cursor to find the amounts that need to be transferres to the new dist
1396: created by reclass */
1397:
1398: CURSOR c_amounts(c_period_counter IN IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1399: SELECT *
1400: FROM igi_iac_asset_balances
1401: WHERE asset_id=l_asset_hdr_rec.asset_id
1402: AND book_type_code=l_asset_hdr_rec.book_type_code

Line 1400: FROM igi_iac_asset_balances

1396: created by reclass */
1397:
1398: CURSOR c_amounts(c_period_counter IN IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1399: SELECT *
1400: FROM igi_iac_asset_balances
1401: WHERE asset_id=l_asset_hdr_rec.asset_id
1402: AND book_type_code=l_asset_hdr_rec.book_type_code
1403: AND period_counter=(SELECT max(period_counter)
1404: FROM igi_iac_asset_balances

Line 1404: FROM igi_iac_asset_balances

1400: FROM igi_iac_asset_balances
1401: WHERE asset_id=l_asset_hdr_rec.asset_id
1402: AND book_type_code=l_asset_hdr_rec.book_type_code
1403: AND period_counter=(SELECT max(period_counter)
1404: FROM igi_iac_asset_balances
1405: WHERE asset_id=l_asset_hdr_rec.asset_id
1406: AND book_type_code=l_asset_hdr_rec.book_type_code);
1407:
1408: /* Cursor to find the total number of units for the asset itself ( active) */

Line 1428: CURSOR c_ytd_deprn(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE

1424: AND transaction_header_id_in=l_trans_rec.transaction_header_id;
1425:
1426: /* Cursor for ytd deprn */
1427:
1428: CURSOR c_ytd_deprn(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE
1429: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1430: SELECT nvl(sum(deprn_amount),0) deprn_amount
1431: FROM igi_iac_asset_balances
1432: WHERE book_type_code=l_asset_hdr_rec.book_type_code

Line 1429: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS

1425:
1426: /* Cursor for ytd deprn */
1427:
1428: CURSOR c_ytd_deprn(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE
1429: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1430: SELECT nvl(sum(deprn_amount),0) deprn_amount
1431: FROM igi_iac_asset_balances
1432: WHERE book_type_code=l_asset_hdr_rec.book_type_code
1433: AND asset_id=l_asset_hdr_rec.asset_id

Line 1431: FROM igi_iac_asset_balances

1427:
1428: CURSOR c_ytd_deprn(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE
1429: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1430: SELECT nvl(sum(deprn_amount),0) deprn_amount
1431: FROM igi_iac_asset_balances
1432: WHERE book_type_code=l_asset_hdr_rec.book_type_code
1433: AND asset_id=l_asset_hdr_rec.asset_id
1434: AND period_counter between c_start_counter and c_current_counter;
1435:

Line 1438: CURSOR c_op_acct_ytd(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE

1434: AND period_counter between c_start_counter and c_current_counter;
1435:
1436: /* Cursor for operating account ytd */
1437:
1438: CURSOR c_op_acct_ytd(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE
1439: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1440: SELECT nvl(sum(operating_acct),0) operating_acct
1441: FROM igi_iac_asset_balances
1442: WHERE book_type_code=l_asset_hdr_rec.book_type_code

Line 1439: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS

1435:
1436: /* Cursor for operating account ytd */
1437:
1438: CURSOR c_op_acct_ytd(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE
1439: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1440: SELECT nvl(sum(operating_acct),0) operating_acct
1441: FROM igi_iac_asset_balances
1442: WHERE book_type_code=l_asset_hdr_rec.book_type_code
1443: AND asset_id=l_asset_hdr_rec.asset_id

Line 1441: FROM igi_iac_asset_balances

1437:
1438: CURSOR c_op_acct_ytd(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE
1439: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1440: SELECT nvl(sum(operating_acct),0) operating_acct
1441: FROM igi_iac_asset_balances
1442: WHERE book_type_code=l_asset_hdr_rec.book_type_code
1443: AND asset_id=l_asset_hdr_rec.asset_id
1444: AND period_counter BETWEEN c_start_counter AND c_current_counter;
1445:

Line 1882: igi_iac_asset_balances_pkg.update_row(

1878:
1879: /* Update the asset balanaces to zero in case new category has no indexed revalutions */
1880:
1881: IF NOT (ALLOW_INDEX_REVAL_FLAG) THEN
1882: igi_iac_asset_balances_pkg.update_row(
1883: X_asset_id => l_asset_hdr_rec.asset_id,
1884: X_book_type_code => l_asset_hdr_rec.book_type_code,
1885: X_period_counter => l_current_period_counter ,
1886: X_net_book_value => 0,

Line 2068: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type) IS

2064:
2065: /* Cursor to find the amounts that need to be transferres to the new dist
2066: created by reclass */
2067:
2068: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2069: SELECT *
2070: FROM igi_iac_asset_balances
2071: WHERE asset_id=l_asset_hdr_rec.asset_id
2072: AND book_type_code=l_asset_hdr_rec.book_type_code

Line 2070: FROM igi_iac_asset_balances

2066: created by reclass */
2067:
2068: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2069: SELECT *
2070: FROM igi_iac_asset_balances
2071: WHERE asset_id=l_asset_hdr_rec.asset_id
2072: AND book_type_code=l_asset_hdr_rec.book_type_code
2073: AND period_counter=(select max(period_counter)
2074: from igi_iac_asset_balances

Line 2074: from igi_iac_asset_balances

2070: FROM igi_iac_asset_balances
2071: WHERE asset_id=l_asset_hdr_rec.asset_id
2072: AND book_type_code=l_asset_hdr_rec.book_type_code
2073: AND period_counter=(select max(period_counter)
2074: from igi_iac_asset_balances
2075: WHERE asset_id=l_asset_hdr_rec.asset_id
2076: AND book_type_code=l_asset_hdr_rec.book_type_code)
2077: ;
2078:

Line 2108: CURSOR c_ytd_deprn(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%type

2104: AND transaction_header_id_in=l_trans_rec.transaction_header_id;
2105:
2106: /* Cursor for ytd deprn */
2107:
2108: CURSOR c_ytd_deprn(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%type
2109: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2110: SELECT nvl(sum(deprn_amount),0) deprn_amount
2111: FROM igi_iac_asset_balances
2112: WHERE book_type_code=l_asset_hdr_rec.book_type_code

Line 2109: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%type) IS

2105:
2106: /* Cursor for ytd deprn */
2107:
2108: CURSOR c_ytd_deprn(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%type
2109: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2110: SELECT nvl(sum(deprn_amount),0) deprn_amount
2111: FROM igi_iac_asset_balances
2112: WHERE book_type_code=l_asset_hdr_rec.book_type_code
2113: AND asset_id=l_asset_hdr_rec.asset_id

Line 2111: FROM igi_iac_asset_balances

2107:
2108: CURSOR c_ytd_deprn(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%type
2109: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2110: SELECT nvl(sum(deprn_amount),0) deprn_amount
2111: FROM igi_iac_asset_balances
2112: WHERE book_type_code=l_asset_hdr_rec.book_type_code
2113: AND asset_id=l_asset_hdr_rec.asset_id
2114: AND period_counter between c_start_counter and c_current_counter;
2115:

Line 2118: CURSOR c_op_acct_ytd(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%type

2114: AND period_counter between c_start_counter and c_current_counter;
2115:
2116: /* Cursor for operating account ytd */
2117:
2118: CURSOR c_op_acct_ytd(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%type
2119: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2120: SELECT nvl(sum(operating_acct),0) operating_acct
2121: FROM igi_iac_asset_balances
2122: WHERE book_type_code=l_asset_hdr_rec.book_type_code

Line 2119: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%type) IS

2115:
2116: /* Cursor for operating account ytd */
2117:
2118: CURSOR c_op_acct_ytd(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%type
2119: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2120: SELECT nvl(sum(operating_acct),0) operating_acct
2121: FROM igi_iac_asset_balances
2122: WHERE book_type_code=l_asset_hdr_rec.book_type_code
2123: AND asset_id=l_asset_hdr_rec.asset_id

Line 2121: FROM igi_iac_asset_balances

2117:
2118: CURSOR c_op_acct_ytd(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%type
2119: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2120: SELECT nvl(sum(operating_acct),0) operating_acct
2121: FROM igi_iac_asset_balances
2122: WHERE book_type_code=l_asset_hdr_rec.book_type_code
2123: AND asset_id=l_asset_hdr_rec.asset_id
2124: AND period_counter between c_start_counter and c_current_counter;
2125:

Line 2745: igi_iac_asset_balances_pkg.update_row(

2741:
2742: /* Update the asset balanaces to zero in case new category is has no prof and indexed revalutions */
2743:
2744: IF NOT (ALLOW_INDEX_REVAL_FLAG OR ALLOW_PROF_REVAL_FLAG) THEN
2745: igi_iac_asset_balances_pkg.update_row(
2746: X_asset_id => l_asset_hdr_rec.asset_id,
2747: X_book_type_code => l_asset_hdr_rec.book_type_code,
2748: X_period_counter => l_current_period_counter ,
2749: X_net_book_value => 0,

Line 3005: l_current_reval_factor igi_iac_asset_balances.current_reval_factor%TYPE;

3001: l_reval_asset_out igi_iac_types.iac_reval_output_asset;
3002: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;
3003: l_user_id NUMBER;
3004: l_login_id NUMBER;
3005: l_current_reval_factor igi_iac_asset_balances.current_reval_factor%TYPE;
3006: l_cumulative_reval_factor igi_iac_asset_balances.cumulative_reval_factor%TYPE;
3007: l_last_reval_period igi_iac_asset_balances.period_counter%TYPE;
3008: l_prof_occ_reval_periods c_prof_occ_reval_periods%ROWTYPE;
3009: l_rowid VARCHAR2(25);

Line 3006: l_cumulative_reval_factor igi_iac_asset_balances.cumulative_reval_factor%TYPE;

3002: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;
3003: l_user_id NUMBER;
3004: l_login_id NUMBER;
3005: l_current_reval_factor igi_iac_asset_balances.current_reval_factor%TYPE;
3006: l_cumulative_reval_factor igi_iac_asset_balances.cumulative_reval_factor%TYPE;
3007: l_last_reval_period igi_iac_asset_balances.period_counter%TYPE;
3008: l_prof_occ_reval_periods c_prof_occ_reval_periods%ROWTYPE;
3009: l_rowid VARCHAR2(25);
3010: /* Bug 2961656 vgadde 08-Jul-2003 Start(1) */

Line 3007: l_last_reval_period igi_iac_asset_balances.period_counter%TYPE;

3003: l_user_id NUMBER;
3004: l_login_id NUMBER;
3005: l_current_reval_factor igi_iac_asset_balances.current_reval_factor%TYPE;
3006: l_cumulative_reval_factor igi_iac_asset_balances.cumulative_reval_factor%TYPE;
3007: l_last_reval_period igi_iac_asset_balances.period_counter%TYPE;
3008: l_prof_occ_reval_periods c_prof_occ_reval_periods%ROWTYPE;
3009: l_rowid VARCHAR2(25);
3010: /* Bug 2961656 vgadde 08-Jul-2003 Start(1) */
3011: l_fa_deprn_amount_py NUMBER;