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 1481: CURSOR c_start_period_counter(c_fiscal_year FA_DEPRN_PERIODS.fiscal_year%TYPE) IS

1477: AND period_counter BETWEEN c_start_counter AND c_current_counter;
1478:
1479: /* Cursor to select the start period number for a given fiscal year */
1480:
1481: CURSOR c_start_period_counter(c_fiscal_year FA_DEPRN_PERIODS.fiscal_year%TYPE) IS
1482: SELECT (number_per_fiscal_year*c_fiscal_year)+1
1483: FROM fa_calendar_types
1484: WHERE calendar_type=(SELECT deprn_calendar
1485: FROM fa_book_controls

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

1501: AND asset_id=l_asset_hdr_rec.asset_id;
1502:
1503: /* Cursor to select the reval reserve backlog,op acct backlog and gen fund per for the dist */
1504:
1505: CURSOR c_backlog_data(c_current_period_Counter fa_deprn_periods.period_counter%TYPE) IS
1506: SELECT sum(nvl(iadb.reval_reserve_backlog,0)) reval_reserve_backlog,
1507: sum(nvl(iadb.operating_acct_backlog,0)) operating_acct_backlog,
1508: sum(nvl(iadb.general_fund_per,0)) general_fund_per
1509: FROM igi_iac_det_balances iadb,fa_distribution_history fdh

Line 1572: l_current_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;

1568: l_prd_rec_prior IGI_IAC_TYPES.prd_rec;
1569:
1570: l_prev_data c_prev_data%ROWTYPE;
1571: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;
1572: l_current_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;
1573: l_start_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;
1574:
1575: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1576: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;

Line 1573: l_start_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;

1569:
1570: l_prev_data c_prev_data%ROWTYPE;
1571: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;
1572: l_current_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;
1573: l_start_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;
1574:
1575: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1576: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1577: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%TYPE;

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

2111:
2112: /* Cursor to find period counter from which the reclass is valid
2113: Needed only in case of prior period transfers
2114:
2115: CURSOR c_prior_period_counter(c_trx_date in FA_DEPRN_PERIODS.period_open_date%type) IS
2116: SELECT period_counter
2117: FROM fa_deprn_periods
2118: WHERE c_trx_date between period_open_date and period_close_date
2119: AND book_type_code=p_asset_hdr_rec.book_type_code; */

Line 2117: FROM fa_deprn_periods

2113: Needed only in case of prior period transfers
2114:
2115: CURSOR c_prior_period_counter(c_trx_date in FA_DEPRN_PERIODS.period_open_date%type) IS
2116: SELECT period_counter
2117: FROM fa_deprn_periods
2118: WHERE c_trx_date between period_open_date and period_close_date
2119: AND book_type_code=p_asset_hdr_rec.book_type_code; */
2120:
2121: /* Cursor to find the total number of units for the asset itself ( active) */

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

2157: AND period_counter between c_start_counter and c_current_counter;
2158:
2159: /* Cursor to select the start period number for a given fiscal year */
2160:
2161: CURSOR c_start_period_counter(c_fiscal_year FA_DEPRN_PERIODS.fiscal_year%type) IS
2162: SELECT (number_per_fiscal_year*c_fiscal_year)+1
2163: FROM fa_calendar_types
2164: WHERE calendar_type=(select deprn_calendar from fa_book_controls
2165: where book_type_code=l_asset_hdr_rec.book_type_code);

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

2180: AND asset_id=l_asset_hdr_rec.asset_id;
2181:
2182: /* Cursor to select the reval reserve backlog,op acct backlog and gen fund per for the dist */
2183:
2184: CURSOR c_backlog_data(c_current_period_Counter fa_deprn_periods.period_counter%type) IS
2185: SELECT sum(nvl(iadb.reval_reserve_backlog,0)) reval_reserve_backlog,
2186: sum(nvl(iadb.operating_acct_backlog,0)) operating_acct_backlog,
2187: sum(nvl(iadb.general_fund_per,0)) general_fund_per
2188: FROM igi_iac_det_balances iadb,fa_distribution_history fdh

Line 2250: l_current_period_counter FA_DEPRN_PERIODS.period_counter%type;

2246: l_prd_rec_prior IGI_IAC_TYPES.prd_rec;
2247:
2248: l_prev_data c_prev_data%rowtype;
2249: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;
2250: l_current_period_counter FA_DEPRN_PERIODS.period_counter%type;
2251: l_start_period_counter FA_DEPRN_PERIODS.period_counter%type;
2252:
2253: l_asset_num FA_ADDITIONS.asset_number%type;
2254: l_units FA_DISTRIBUTION_HISTORY.units_assigned%type;

Line 2251: l_start_period_counter FA_DEPRN_PERIODS.period_counter%type;

2247:
2248: l_prev_data c_prev_data%rowtype;
2249: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;
2250: l_current_period_counter FA_DEPRN_PERIODS.period_counter%type;
2251: l_start_period_counter FA_DEPRN_PERIODS.period_counter%type;
2252:
2253: l_asset_num FA_ADDITIONS.asset_number%type;
2254: l_units FA_DISTRIBUTION_HISTORY.units_assigned%type;
2255: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;