APPS.IGI_IAC_TRANSFERS_PKG dependencies on FA_DEPRN_PERIODS

Line 1007: CURSOR c_prior_period_counter(c_trx_date IN FA_DEPRN_PERIODS.period_open_date%TYPE)

1003: AND transaction_header_id_out=p_trans_rec.transaction_header_id;
1004:
1005: -- Find period counter of transfer period in case of prior period transfer
1006: -- (keep)
1007: CURSOR c_prior_period_counter(c_trx_date IN FA_DEPRN_PERIODS.period_open_date%TYPE)
1008: IS
1009: SELECT period_counter
1010: FROM fa_deprn_periods
1011: WHERE c_trx_date BETWEEN period_open_date AND period_close_date

Line 1010: FROM fa_deprn_periods

1006: -- (keep)
1007: CURSOR c_prior_period_counter(c_trx_date IN FA_DEPRN_PERIODS.period_open_date%TYPE)
1008: IS
1009: SELECT period_counter
1010: FROM fa_deprn_periods
1011: WHERE c_trx_date BETWEEN period_open_date AND period_close_date
1012: AND book_type_code=p_asset_hdr_rec.book_type_code;
1013:
1014: -- find the total number of units for the asset itself ( active) (keep)

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

1028: AND book_type_code=p_asset_hdr_rec.book_type_code
1029: AND transaction_header_id_in=p_trans_rec.transaction_header_id;
1030:
1031: -- select the start period number for a given fiscal year (keep)
1032: CURSOR c_start_period_counter(c_fiscal_year FA_DEPRN_PERIODS.fiscal_year%TYPE)
1033: IS
1034: SELECT (number_per_fiscal_year*c_fiscal_year)+1
1035: FROM fa_calendar_types
1036: WHERE calendar_type=(SELECT deprn_calendar

Line 1108: l_current_period_counter fa_deprn_periods.period_counter%TYPE;

1104:
1105: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
1106: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1107: l_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1108: l_current_period_counter fa_deprn_periods.period_counter%TYPE;
1109: l_start_period_counter fa_deprn_periods.period_counter%TYPE;
1110: l_prior_period_counter fa_deprn_periods.period_counter%TYPE;
1111: l_prd_rec igi_iac_types.prd_rec;
1112: l_prd_rec_prior igi_iac_types.prd_rec;

Line 1109: l_start_period_counter fa_deprn_periods.period_counter%TYPE;

1105: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
1106: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1107: l_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1108: l_current_period_counter fa_deprn_periods.period_counter%TYPE;
1109: l_start_period_counter fa_deprn_periods.period_counter%TYPE;
1110: l_prior_period_counter fa_deprn_periods.period_counter%TYPE;
1111: l_prd_rec igi_iac_types.prd_rec;
1112: l_prd_rec_prior igi_iac_types.prd_rec;
1113: l_all_dist c_all_dist%ROWTYPE;

Line 1110: l_prior_period_counter fa_deprn_periods.period_counter%TYPE;

1106: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1107: l_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1108: l_current_period_counter fa_deprn_periods.period_counter%TYPE;
1109: l_start_period_counter fa_deprn_periods.period_counter%TYPE;
1110: l_prior_period_counter fa_deprn_periods.period_counter%TYPE;
1111: l_prd_rec igi_iac_types.prd_rec;
1112: l_prd_rec_prior igi_iac_types.prd_rec;
1113: l_all_dist c_all_dist%ROWTYPE;
1114: l_iac_dist c_iac_dist%ROWTYPE;