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_TRANSFERS_PKG dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 501: FUNCTION Calc_Asset_Amounts(p_adjustment_id IN igi_iac_transaction_headers.adjustment_id%TYPE,

497:
498: -- ===============================================================================
499: -- FUNCTION Calc_Asset_Amounts: Calculate the asset level amounts for the asset
500: -- ===============================================================================
501: FUNCTION Calc_Asset_Amounts(p_adjustment_id IN igi_iac_transaction_headers.adjustment_id%TYPE,
502: p_asset_id IN igi_iac_transaction_headers.asset_id%TYPE,
503: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,
504: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
505: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,

Line 502: p_asset_id IN igi_iac_transaction_headers.asset_id%TYPE,

498: -- ===============================================================================
499: -- FUNCTION Calc_Asset_Amounts: Calculate the asset level amounts for the asset
500: -- ===============================================================================
501: FUNCTION Calc_Asset_Amounts(p_adjustment_id IN igi_iac_transaction_headers.adjustment_id%TYPE,
502: p_asset_id IN igi_iac_transaction_headers.asset_id%TYPE,
503: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,
504: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
505: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
506: p_hist_cost IN fa_books.cost%TYPE,

Line 503: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,

499: -- FUNCTION Calc_Asset_Amounts: Calculate the asset level amounts for the asset
500: -- ===============================================================================
501: FUNCTION Calc_Asset_Amounts(p_adjustment_id IN igi_iac_transaction_headers.adjustment_id%TYPE,
502: p_asset_id IN igi_iac_transaction_headers.asset_id%TYPE,
503: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,
504: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
505: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
506: p_hist_cost IN fa_books.cost%TYPE,
507: p_salvage_value IN fa_books.salvage_value%TYPE,

Line 504: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,

500: -- ===============================================================================
501: FUNCTION Calc_Asset_Amounts(p_adjustment_id IN igi_iac_transaction_headers.adjustment_id%TYPE,
502: p_asset_id IN igi_iac_transaction_headers.asset_id%TYPE,
503: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,
504: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
505: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
506: p_hist_cost IN fa_books.cost%TYPE,
507: p_salvage_value IN fa_books.salvage_value%TYPE,
508: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,

Line 505: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,

501: FUNCTION Calc_Asset_Amounts(p_adjustment_id IN igi_iac_transaction_headers.adjustment_id%TYPE,
502: p_asset_id IN igi_iac_transaction_headers.asset_id%TYPE,
503: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,
504: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
505: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
506: p_hist_cost IN fa_books.cost%TYPE,
507: p_salvage_value IN fa_books.salvage_value%TYPE,
508: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,
509: p_asset_units IN fa_distribution_history.units_assigned%TYPE,

Line 508: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,

504: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
505: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
506: p_hist_cost IN fa_books.cost%TYPE,
507: p_salvage_value IN fa_books.salvage_value%TYPE,
508: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,
509: p_asset_units IN fa_distribution_history.units_assigned%TYPE,
510: p_transfer_units IN fa_distribution_history.units_assigned%TYPE,
511: l_asset_rec OUT NOCOPY asset_rec_type,
512: l_iac_fa_dep_rec OUT NOCOPY iac_fa_deprn_rec_type

Line 551: CURSOR c_backlog_data(cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE)

547:
548: -- Calculate the reval reserve backlog,op acct backlog, gen fund per and YTD deprn
549: -- for the adjustment
550: -- (for asset level amounts)
551: CURSOR c_backlog_data(cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE)
552: IS
553: SELECT nvl(sum(iadb.reval_reserve_backlog), 0) reval_reserve_backlog,
554: nvl(sum(iadb.operating_acct_backlog), 0) operating_acct_backlog,
555: nvl(sum(iadb.general_fund_per), 0) general_fund_per,

Line 562: CURSOR c_iac_fa_deprn(cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE)

558: WHERE iadb.adjustment_id = cp_adjustment_id
559: AND iadb.active_flag IS NULL;
560:
561: -- Calculate the iac fa depreciation data for an adjustment
562: CURSOR c_iac_fa_deprn(cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE)
563: IS
564: SELECT nvl(sum(iadb.deprn_period), 0) deprn_period,
565: nvl(sum(iadb.deprn_reserve), 0) deprn_reserve,
566: nvl(sum(iadb.deprn_ytd), 0) deprn_ytd

Line 589: igi_iac_transaction_headers ith

585: )
586: IS
587: SELECT nvl(sum(decode(aj.dr_cr_flag, 'CR', 1, -1) *AJ.Amount), 0) op_expense_amt
588: FROM igi_iac_adjustments aj,
589: igi_iac_transaction_headers ith
590: WHERE aj.asset_id = cp_asset_id
591: AND aj.book_type_code = cp_book_type_code
592: AND aj.period_counter BETWEEN cp_tfr_prd_counter AND cp_cur_prd_counter
593: AND aj.adjustment_type = 'OP EXPENSE'

Line 777: CURSOR c_inactive_dist(c_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%TYPE)

773: p_curr_prd_cntr IN igi_iac_det_balances.period_counter%TYPE
774: )
775: IS
776: -- Select all inactive distributions created by the previous transaction (keep)
777: CURSOR c_inactive_dist(c_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%TYPE)
778: IS
779: SELECT *
780: FROM igi_iac_det_balances
781: WHERE adjustment_id=c_adjustment_id

Line 787: CURSOR c_fa_inactive_dist(cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE)

783: AND asset_id = p_asset_id
784: AND active_flag='N';
785:
786: -- get fa inactive rows for a distribution (keep)
787: CURSOR c_fa_inactive_dist(cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE)
788: IS
789: SELECT *
790: FROM igi_iac_fa_deprn
791: WHERE adjustment_id = cp_adjustment_id

Line 1014: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;

1010: act_cnt NUMBER ;
1011: inact_cnt NUMBER ;
1012: l_return_value BOOLEAN;
1013:
1014: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
1015: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1016: l_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1017: l_current_period_counter fa_deprn_periods.period_counter%TYPE;
1018: l_start_period_counter fa_deprn_periods.period_counter%TYPE;

Line 1015: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

1011: inact_cnt NUMBER ;
1012: l_return_value BOOLEAN;
1013:
1014: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
1015: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1016: l_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1017: l_current_period_counter fa_deprn_periods.period_counter%TYPE;
1018: l_start_period_counter fa_deprn_periods.period_counter%TYPE;
1019: l_prior_period_counter fa_deprn_periods.period_counter%TYPE;

Line 1016: l_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

1012: l_return_value BOOLEAN;
1013:
1014: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
1015: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1016: l_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1017: l_current_period_counter fa_deprn_periods.period_counter%TYPE;
1018: l_start_period_counter fa_deprn_periods.period_counter%TYPE;
1019: l_prior_period_counter fa_deprn_periods.period_counter%TYPE;
1020: l_prd_rec igi_iac_types.prd_rec;

Line 1057: l_transaction_header_id IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type;

1053: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
1054: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
1055: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
1056:
1057: l_transaction_header_id IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type;
1058: l_transaction_type_code IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type;
1059: l_mass_reference_id IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type;
1060: l_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1061: l_prev_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;

Line 1058: l_transaction_type_code IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type;

1054: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
1055: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
1056:
1057: l_transaction_header_id IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type;
1058: l_transaction_type_code IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type;
1059: l_mass_reference_id IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type;
1060: l_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1061: l_prev_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1062: l_adjustment_status IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type;

Line 1059: l_mass_reference_id IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type;

1055: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
1056:
1057: l_transaction_header_id IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type;
1058: l_transaction_type_code IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type;
1059: l_mass_reference_id IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type;
1060: l_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1061: l_prev_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1062: l_adjustment_status IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type;
1063:

Line 1060: l_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;

1056:
1057: l_transaction_header_id IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type;
1058: l_transaction_type_code IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type;
1059: l_mass_reference_id IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type;
1060: l_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1061: l_prev_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1062: l_adjustment_status IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type;
1063:
1064: l_reval_reserve_sum igi_iac_det_balances.reval_reserve_cost%TYPE ;

Line 1061: l_prev_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;

1057: l_transaction_header_id IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type;
1058: l_transaction_type_code IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type;
1059: l_mass_reference_id IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type;
1060: l_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1061: l_prev_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1062: l_adjustment_status IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type;
1063:
1064: l_reval_reserve_sum igi_iac_det_balances.reval_reserve_cost%TYPE ;
1065: l_general_fund_sum igi_iac_det_balances.general_fund_acc%TYPE ;

Line 1062: l_adjustment_status IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type;

1058: l_transaction_type_code IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type;
1059: l_mass_reference_id IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type;
1060: l_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1061: l_prev_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1062: l_adjustment_status IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type;
1063:
1064: l_reval_reserve_sum igi_iac_det_balances.reval_reserve_cost%TYPE ;
1065: l_general_fund_sum igi_iac_det_balances.general_fund_acc%TYPE ;
1066: l_Backlog_deprn_reserve_sum igi_iac_det_balances.deprn_reserve_backlog%TYPE ;

Line 1272: -- create a new row in igi_iac_transaction_headers with transaction type code

1268: ELSE
1269: g_prior_period:= FALSE;
1270: END IF;
1271:
1272: -- create a new row in igi_iac_transaction_headers with transaction type code
1273: -- TRANSFERS
1274: -- initailise the new adjustment id
1275: l_adj_id := null;
1276:

Line 2319: -- update the previous active row for the asset in igi_iac_transaction_headers

2315: );
2316: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Data Inserted in Asset balances');
2317: END IF;
2318:
2319: -- update the previous active row for the asset in igi_iac_transaction_headers
2320: -- in order to make it inactive by setting adjustment_id_out= adjustment_id of
2321: -- the active row in igi_iac_transaction_headers
2322: IGI_IAC_TRANS_HEADERS_PKG.Update_Row(
2323: x_prev_adjustment_id => l_adj_id_out,

Line 2321: -- the active row in igi_iac_transaction_headers

2317: END IF;
2318:
2319: -- update the previous active row for the asset in igi_iac_transaction_headers
2320: -- in order to make it inactive by setting adjustment_id_out= adjustment_id of
2321: -- the active row in igi_iac_transaction_headers
2322: IGI_IAC_TRANS_HEADERS_PKG.Update_Row(
2323: x_prev_adjustment_id => l_adj_id_out,
2324: x_adjustment_id => l_adj_id
2325: );

Line 2507: FROM igi_iac_transaction_headers

2503: /* Cursor to select data from transaction headers which need to be rolled back */
2504:
2505: CURSOR c_trans_headers IS
2506: SELECT *
2507: FROM igi_iac_transaction_headers
2508: WHERE book_type_code=p_book_type_code
2509: AND period_counter=p_period_counter
2510: AND transaction_type_code='TRANSFER';
2511:

Line 2523: CURSOR c_prev_data(c_adjustment_id igi_iac_transaction_headers.adjustment_id%type) IS

2519: AND adjustment_id = cp_adjustment_id;
2520:
2521: /* Cursor to select the previous data */
2522:
2523: CURSOR c_prev_data(c_adjustment_id igi_iac_transaction_headers.adjustment_id%type) IS
2524: SELECT *
2525: FROM igi_iac_transaction_headers
2526: WHERE adjustment_id_out=c_adjustment_id;
2527:

Line 2525: FROM igi_iac_transaction_headers

2521: /* Cursor to select the previous data */
2522:
2523: CURSOR c_prev_data(c_adjustment_id igi_iac_transaction_headers.adjustment_id%type) IS
2524: SELECT *
2525: FROM igi_iac_transaction_headers
2526: WHERE adjustment_id_out=c_adjustment_id;
2527:
2528: /* Cursor to find the amounts that need to be transferred to the new dist
2529: created by transfer */

Line 2564: l_prev_adjustment igi_iac_transaction_headers%ROWTYPE;

2560: l_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2561: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2562: l_prior_period_counter IGI_IAC_DET_BALANCES.period_counter%type;
2563: l_current_period_counter IGI_IAC_DET_BALANCES.period_counter%type;
2564: l_prev_adjustment igi_iac_transaction_headers%ROWTYPE;
2565:
2566: l_path varchar2(150);
2567: BEGIN
2568: