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 254: CURSOR c_asset_revalued(c_asset_id IGI_IAC_ASSET_BALANCES.asset_id%type) IS

250:
251: -- cursor for to check asset type
252: /* Cursor to find out NOCOPY if the asset is revalued atleast once */
253:
254: CURSOR c_asset_revalued(c_asset_id IGI_IAC_ASSET_BALANCES.asset_id%type) IS
255: SELECT 'X'
256: FROM igi_iac_asset_balances
257: WHERE asset_id=l_asset_hdr_rec.asset_id
258: AND book_type_code = l_asset_hdr_rec.book_type_code;

Line 256: FROM igi_iac_asset_balances

252: /* Cursor to find out NOCOPY if the asset is revalued atleast once */
253:
254: CURSOR c_asset_revalued(c_asset_id IGI_IAC_ASSET_BALANCES.asset_id%type) IS
255: SELECT 'X'
256: FROM igi_iac_asset_balances
257: WHERE asset_id=l_asset_hdr_rec.asset_id
258: AND book_type_code = l_asset_hdr_rec.book_type_code;
259:
260: l_asset_revalued c_asset_revalued%rowtype;

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

1427:
1428: /* Cursor to find the amounts that need to be transferres to the new dist
1429: created by reclass */
1430:
1431: CURSOR c_amounts(c_period_counter IN IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1432: SELECT *
1433: FROM igi_iac_asset_balances
1434: WHERE asset_id=l_asset_hdr_rec.asset_id
1435: AND book_type_code=l_asset_hdr_rec.book_type_code

Line 1433: FROM igi_iac_asset_balances

1429: created by reclass */
1430:
1431: CURSOR c_amounts(c_period_counter IN IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1432: SELECT *
1433: FROM igi_iac_asset_balances
1434: WHERE asset_id=l_asset_hdr_rec.asset_id
1435: AND book_type_code=l_asset_hdr_rec.book_type_code
1436: AND period_counter=(SELECT max(period_counter)
1437: FROM igi_iac_asset_balances

Line 1437: FROM igi_iac_asset_balances

1433: FROM igi_iac_asset_balances
1434: WHERE asset_id=l_asset_hdr_rec.asset_id
1435: AND book_type_code=l_asset_hdr_rec.book_type_code
1436: AND period_counter=(SELECT max(period_counter)
1437: FROM igi_iac_asset_balances
1438: WHERE asset_id=l_asset_hdr_rec.asset_id
1439: AND book_type_code=l_asset_hdr_rec.book_type_code);
1440:
1441: /* Cursor to find the total number of units for the asset itself ( active) */

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

1457: AND transaction_header_id_in=l_trans_rec.transaction_header_id;
1458:
1459: /* Cursor for ytd deprn */
1460:
1461: CURSOR c_ytd_deprn(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE
1462: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1463: SELECT nvl(sum(deprn_amount),0) deprn_amount
1464: FROM igi_iac_asset_balances
1465: WHERE book_type_code=l_asset_hdr_rec.book_type_code

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

1458:
1459: /* Cursor for ytd deprn */
1460:
1461: CURSOR c_ytd_deprn(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE
1462: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1463: SELECT nvl(sum(deprn_amount),0) deprn_amount
1464: FROM igi_iac_asset_balances
1465: WHERE book_type_code=l_asset_hdr_rec.book_type_code
1466: AND asset_id=l_asset_hdr_rec.asset_id

Line 1464: FROM igi_iac_asset_balances

1460:
1461: CURSOR c_ytd_deprn(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE
1462: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1463: SELECT nvl(sum(deprn_amount),0) deprn_amount
1464: FROM igi_iac_asset_balances
1465: WHERE book_type_code=l_asset_hdr_rec.book_type_code
1466: AND asset_id=l_asset_hdr_rec.asset_id
1467: AND period_counter between c_start_counter and c_current_counter;
1468:

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

1467: AND period_counter between c_start_counter and c_current_counter;
1468:
1469: /* Cursor for operating account ytd */
1470:
1471: CURSOR c_op_acct_ytd(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE
1472: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1473: SELECT nvl(sum(operating_acct),0) operating_acct
1474: FROM igi_iac_asset_balances
1475: WHERE book_type_code=l_asset_hdr_rec.book_type_code

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

1468:
1469: /* Cursor for operating account ytd */
1470:
1471: CURSOR c_op_acct_ytd(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE
1472: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1473: SELECT nvl(sum(operating_acct),0) operating_acct
1474: FROM igi_iac_asset_balances
1475: WHERE book_type_code=l_asset_hdr_rec.book_type_code
1476: AND asset_id=l_asset_hdr_rec.asset_id

Line 1474: FROM igi_iac_asset_balances

1470:
1471: CURSOR c_op_acct_ytd(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE
1472: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%TYPE) IS
1473: SELECT nvl(sum(operating_acct),0) operating_acct
1474: FROM igi_iac_asset_balances
1475: WHERE book_type_code=l_asset_hdr_rec.book_type_code
1476: AND asset_id=l_asset_hdr_rec.asset_id
1477: AND period_counter BETWEEN c_start_counter AND c_current_counter;
1478:

Line 1915: igi_iac_asset_balances_pkg.update_row(

1911:
1912: /* Update the asset balanaces to zero in case new category has no indexed revalutions */
1913:
1914: IF NOT (ALLOW_INDEX_REVAL_FLAG) THEN
1915: igi_iac_asset_balances_pkg.update_row(
1916: X_asset_id => l_asset_hdr_rec.asset_id,
1917: X_book_type_code => l_asset_hdr_rec.book_type_code,
1918: X_period_counter => l_current_period_counter ,
1919: X_net_book_value => 0,

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

2097:
2098: /* Cursor to find the amounts that need to be transferres to the new dist
2099: created by reclass */
2100:
2101: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2102: SELECT *
2103: FROM igi_iac_asset_balances
2104: WHERE asset_id=l_asset_hdr_rec.asset_id
2105: AND book_type_code=l_asset_hdr_rec.book_type_code

Line 2103: FROM igi_iac_asset_balances

2099: created by reclass */
2100:
2101: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2102: SELECT *
2103: FROM igi_iac_asset_balances
2104: WHERE asset_id=l_asset_hdr_rec.asset_id
2105: AND book_type_code=l_asset_hdr_rec.book_type_code
2106: AND period_counter=(select max(period_counter)
2107: from igi_iac_asset_balances

Line 2107: from igi_iac_asset_balances

2103: FROM igi_iac_asset_balances
2104: WHERE asset_id=l_asset_hdr_rec.asset_id
2105: AND book_type_code=l_asset_hdr_rec.book_type_code
2106: AND period_counter=(select max(period_counter)
2107: from igi_iac_asset_balances
2108: WHERE asset_id=l_asset_hdr_rec.asset_id
2109: AND book_type_code=l_asset_hdr_rec.book_type_code)
2110: ;
2111:

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

2137: AND transaction_header_id_in=l_trans_rec.transaction_header_id;
2138:
2139: /* Cursor for ytd deprn */
2140:
2141: CURSOR c_ytd_deprn(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%type
2142: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2143: SELECT nvl(sum(deprn_amount),0) deprn_amount
2144: FROM igi_iac_asset_balances
2145: WHERE book_type_code=l_asset_hdr_rec.book_type_code

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

2138:
2139: /* Cursor for ytd deprn */
2140:
2141: CURSOR c_ytd_deprn(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%type
2142: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2143: SELECT nvl(sum(deprn_amount),0) deprn_amount
2144: FROM igi_iac_asset_balances
2145: WHERE book_type_code=l_asset_hdr_rec.book_type_code
2146: AND asset_id=l_asset_hdr_rec.asset_id

Line 2144: FROM igi_iac_asset_balances

2140:
2141: CURSOR c_ytd_deprn(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%type
2142: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2143: SELECT nvl(sum(deprn_amount),0) deprn_amount
2144: FROM igi_iac_asset_balances
2145: WHERE book_type_code=l_asset_hdr_rec.book_type_code
2146: AND asset_id=l_asset_hdr_rec.asset_id
2147: AND period_counter between c_start_counter and c_current_counter;
2148:

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

2147: AND period_counter between c_start_counter and c_current_counter;
2148:
2149: /* Cursor for operating account ytd */
2150:
2151: CURSOR c_op_acct_ytd(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%type
2152: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2153: SELECT nvl(sum(operating_acct),0) operating_acct
2154: FROM igi_iac_asset_balances
2155: WHERE book_type_code=l_asset_hdr_rec.book_type_code

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

2148:
2149: /* Cursor for operating account ytd */
2150:
2151: CURSOR c_op_acct_ytd(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%type
2152: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2153: SELECT nvl(sum(operating_acct),0) operating_acct
2154: FROM igi_iac_asset_balances
2155: WHERE book_type_code=l_asset_hdr_rec.book_type_code
2156: AND asset_id=l_asset_hdr_rec.asset_id

Line 2154: FROM igi_iac_asset_balances

2150:
2151: CURSOR c_op_acct_ytd(c_start_counter IGI_IAC_ASSET_BALANCES.period_counter%type
2152: ,c_current_counter IGI_IAC_ASSET_BALANCES.period_counter%type) IS
2153: SELECT nvl(sum(operating_acct),0) operating_acct
2154: FROM igi_iac_asset_balances
2155: WHERE book_type_code=l_asset_hdr_rec.book_type_code
2156: AND asset_id=l_asset_hdr_rec.asset_id
2157: AND period_counter between c_start_counter and c_current_counter;
2158:

Line 2778: igi_iac_asset_balances_pkg.update_row(

2774:
2775: /* Update the asset balanaces to zero in case new category is has no prof and indexed revalutions */
2776:
2777: IF NOT (ALLOW_INDEX_REVAL_FLAG OR ALLOW_PROF_REVAL_FLAG) THEN
2778: igi_iac_asset_balances_pkg.update_row(
2779: X_asset_id => l_asset_hdr_rec.asset_id,
2780: X_book_type_code => l_asset_hdr_rec.book_type_code,
2781: X_period_counter => l_current_period_counter ,
2782: X_net_book_value => 0,

Line 3038: l_current_reval_factor igi_iac_asset_balances.current_reval_factor%TYPE;

3034: l_reval_asset_out igi_iac_types.iac_reval_output_asset;
3035: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;
3036: l_user_id NUMBER;
3037: l_login_id NUMBER;
3038: l_current_reval_factor igi_iac_asset_balances.current_reval_factor%TYPE;
3039: l_cumulative_reval_factor igi_iac_asset_balances.cumulative_reval_factor%TYPE;
3040: l_last_reval_period igi_iac_asset_balances.period_counter%TYPE;
3041: l_prof_occ_reval_periods c_prof_occ_reval_periods%ROWTYPE;
3042: l_rowid VARCHAR2(25);

Line 3039: l_cumulative_reval_factor igi_iac_asset_balances.cumulative_reval_factor%TYPE;

3035: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;
3036: l_user_id NUMBER;
3037: l_login_id NUMBER;
3038: l_current_reval_factor igi_iac_asset_balances.current_reval_factor%TYPE;
3039: l_cumulative_reval_factor igi_iac_asset_balances.cumulative_reval_factor%TYPE;
3040: l_last_reval_period igi_iac_asset_balances.period_counter%TYPE;
3041: l_prof_occ_reval_periods c_prof_occ_reval_periods%ROWTYPE;
3042: l_rowid VARCHAR2(25);
3043: /* Bug 2961656 vgadde 08-Jul-2003 Start(1) */

Line 3040: l_last_reval_period igi_iac_asset_balances.period_counter%TYPE;

3036: l_user_id NUMBER;
3037: l_login_id NUMBER;
3038: l_current_reval_factor igi_iac_asset_balances.current_reval_factor%TYPE;
3039: l_cumulative_reval_factor igi_iac_asset_balances.cumulative_reval_factor%TYPE;
3040: l_last_reval_period igi_iac_asset_balances.period_counter%TYPE;
3041: l_prof_occ_reval_periods c_prof_occ_reval_periods%ROWTYPE;
3042: l_rowid VARCHAR2(25);
3043: /* Bug 2961656 vgadde 08-Jul-2003 Start(1) */
3044: l_fa_deprn_amount_py NUMBER;