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 FA_DEPRN_PERIODS

Line 1448: CURSOR c_start_period_counter(c_fiscal_year FA_DEPRN_PERIODS.fiscal_year%TYPE) IS

1444: AND period_counter BETWEEN c_start_counter AND c_current_counter;
1445:
1446: /* Cursor to select the start period number for a given fiscal year */
1447:
1448: CURSOR c_start_period_counter(c_fiscal_year FA_DEPRN_PERIODS.fiscal_year%TYPE) IS
1449: SELECT (number_per_fiscal_year*c_fiscal_year)+1
1450: FROM fa_calendar_types
1451: WHERE calendar_type=(SELECT deprn_calendar
1452: FROM fa_book_controls

Line 1472: CURSOR c_backlog_data(c_current_period_Counter fa_deprn_periods.period_counter%TYPE) IS

1468: AND asset_id=l_asset_hdr_rec.asset_id;
1469:
1470: /* Cursor to select the reval reserve backlog,op acct backlog and gen fund per for the dist */
1471:
1472: CURSOR c_backlog_data(c_current_period_Counter fa_deprn_periods.period_counter%TYPE) IS
1473: SELECT sum(nvl(iadb.reval_reserve_backlog,0)) reval_reserve_backlog,
1474: sum(nvl(iadb.operating_acct_backlog,0)) operating_acct_backlog,
1475: sum(nvl(iadb.general_fund_per,0)) general_fund_per
1476: FROM igi_iac_det_balances iadb,fa_distribution_history fdh

Line 1539: l_current_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;

1535: l_prd_rec_prior IGI_IAC_TYPES.prd_rec;
1536:
1537: l_prev_data c_prev_data%ROWTYPE;
1538: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;
1539: l_current_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;
1540: l_start_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;
1541:
1542: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1543: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;

Line 1540: l_start_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;

1536:
1537: l_prev_data c_prev_data%ROWTYPE;
1538: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;
1539: l_current_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;
1540: l_start_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;
1541:
1542: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1543: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1544: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%TYPE;

Line 2082: CURSOR c_prior_period_counter(c_trx_date in FA_DEPRN_PERIODS.period_open_date%type) IS

2078:
2079: /* Cursor to find period counter from which the reclass is valid
2080: Needed only in case of prior period transfers
2081:
2082: CURSOR c_prior_period_counter(c_trx_date in FA_DEPRN_PERIODS.period_open_date%type) IS
2083: SELECT period_counter
2084: FROM fa_deprn_periods
2085: WHERE c_trx_date between period_open_date and period_close_date
2086: AND book_type_code=p_asset_hdr_rec.book_type_code; */

Line 2084: FROM fa_deprn_periods

2080: Needed only in case of prior period transfers
2081:
2082: CURSOR c_prior_period_counter(c_trx_date in FA_DEPRN_PERIODS.period_open_date%type) IS
2083: SELECT period_counter
2084: FROM fa_deprn_periods
2085: WHERE c_trx_date between period_open_date and period_close_date
2086: AND book_type_code=p_asset_hdr_rec.book_type_code; */
2087:
2088: /* Cursor to find the total number of units for the asset itself ( active) */

Line 2128: CURSOR c_start_period_counter(c_fiscal_year FA_DEPRN_PERIODS.fiscal_year%type) IS

2124: AND period_counter between c_start_counter and c_current_counter;
2125:
2126: /* Cursor to select the start period number for a given fiscal year */
2127:
2128: CURSOR c_start_period_counter(c_fiscal_year FA_DEPRN_PERIODS.fiscal_year%type) IS
2129: SELECT (number_per_fiscal_year*c_fiscal_year)+1
2130: FROM fa_calendar_types
2131: WHERE calendar_type=(select deprn_calendar from fa_book_controls
2132: where book_type_code=l_asset_hdr_rec.book_type_code);

Line 2151: CURSOR c_backlog_data(c_current_period_Counter fa_deprn_periods.period_counter%type) IS

2147: AND asset_id=l_asset_hdr_rec.asset_id;
2148:
2149: /* Cursor to select the reval reserve backlog,op acct backlog and gen fund per for the dist */
2150:
2151: CURSOR c_backlog_data(c_current_period_Counter fa_deprn_periods.period_counter%type) IS
2152: SELECT sum(nvl(iadb.reval_reserve_backlog,0)) reval_reserve_backlog,
2153: sum(nvl(iadb.operating_acct_backlog,0)) operating_acct_backlog,
2154: sum(nvl(iadb.general_fund_per,0)) general_fund_per
2155: FROM igi_iac_det_balances iadb,fa_distribution_history fdh

Line 2217: l_current_period_counter FA_DEPRN_PERIODS.period_counter%type;

2213: l_prd_rec_prior IGI_IAC_TYPES.prd_rec;
2214:
2215: l_prev_data c_prev_data%rowtype;
2216: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;
2217: l_current_period_counter FA_DEPRN_PERIODS.period_counter%type;
2218: l_start_period_counter FA_DEPRN_PERIODS.period_counter%type;
2219:
2220: l_asset_num FA_ADDITIONS.asset_number%type;
2221: l_units FA_DISTRIBUTION_HISTORY.units_assigned%type;

Line 2218: l_start_period_counter FA_DEPRN_PERIODS.period_counter%type;

2214:
2215: l_prev_data c_prev_data%rowtype;
2216: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;
2217: l_current_period_counter FA_DEPRN_PERIODS.period_counter%type;
2218: l_start_period_counter FA_DEPRN_PERIODS.period_counter%type;
2219:
2220: l_asset_num FA_ADDITIONS.asset_number%type;
2221: l_units FA_DISTRIBUTION_HISTORY.units_assigned%type;
2222: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;