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 571: FUNCTION Calc_Asset_Amounts(p_adjustment_id IN igi_iac_transaction_headers.adjustment_id%TYPE,

567:
568: -- ===============================================================================
569: -- FUNCTION Calc_Asset_Amounts: Calculate the asset level amounts for the asset
570: -- ===============================================================================
571: FUNCTION Calc_Asset_Amounts(p_adjustment_id IN igi_iac_transaction_headers.adjustment_id%TYPE,
572: p_asset_id IN igi_iac_transaction_headers.asset_id%TYPE,
573: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,
574: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
575: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,

Line 572: p_asset_id IN igi_iac_transaction_headers.asset_id%TYPE,

568: -- ===============================================================================
569: -- FUNCTION Calc_Asset_Amounts: Calculate the asset level amounts for the asset
570: -- ===============================================================================
571: FUNCTION Calc_Asset_Amounts(p_adjustment_id IN igi_iac_transaction_headers.adjustment_id%TYPE,
572: p_asset_id IN igi_iac_transaction_headers.asset_id%TYPE,
573: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,
574: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
575: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
576: p_hist_cost IN fa_books.cost%TYPE,

Line 573: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,

569: -- FUNCTION Calc_Asset_Amounts: Calculate the asset level amounts for the asset
570: -- ===============================================================================
571: FUNCTION Calc_Asset_Amounts(p_adjustment_id IN igi_iac_transaction_headers.adjustment_id%TYPE,
572: p_asset_id IN igi_iac_transaction_headers.asset_id%TYPE,
573: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,
574: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
575: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
576: p_hist_cost IN fa_books.cost%TYPE,
577: p_salvage_value IN fa_books.salvage_value%TYPE,

Line 574: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,

570: -- ===============================================================================
571: FUNCTION Calc_Asset_Amounts(p_adjustment_id IN igi_iac_transaction_headers.adjustment_id%TYPE,
572: p_asset_id IN igi_iac_transaction_headers.asset_id%TYPE,
573: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,
574: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
575: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
576: p_hist_cost IN fa_books.cost%TYPE,
577: p_salvage_value IN fa_books.salvage_value%TYPE,
578: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,

Line 575: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,

571: FUNCTION Calc_Asset_Amounts(p_adjustment_id IN igi_iac_transaction_headers.adjustment_id%TYPE,
572: p_asset_id IN igi_iac_transaction_headers.asset_id%TYPE,
573: p_book_type_code IN igi_iac_transaction_headers.book_type_code%TYPE,
574: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
575: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
576: p_hist_cost IN fa_books.cost%TYPE,
577: p_salvage_value IN fa_books.salvage_value%TYPE,
578: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,
579: p_asset_units IN fa_distribution_history.units_assigned%TYPE,

Line 578: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,

574: p_curr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
575: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
576: p_hist_cost IN fa_books.cost%TYPE,
577: p_salvage_value IN fa_books.salvage_value%TYPE,
578: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,
579: p_asset_units IN fa_distribution_history.units_assigned%TYPE,
580: p_transfer_units IN fa_distribution_history.units_assigned%TYPE,
581: l_asset_rec OUT NOCOPY asset_rec_type,
582: l_iac_fa_dep_rec OUT NOCOPY iac_fa_deprn_rec_type

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

617:
618: -- Calculate the reval reserve backlog,op acct backlog, gen fund per and YTD deprn
619: -- for the adjustment
620: -- (for asset level amounts)
621: CURSOR c_backlog_data(cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE)
622: IS
623: SELECT nvl(sum(iadb.reval_reserve_backlog), 0) reval_reserve_backlog,
624: nvl(sum(iadb.operating_acct_backlog), 0) operating_acct_backlog,
625: nvl(sum(iadb.general_fund_per), 0) general_fund_per,

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

628: WHERE iadb.adjustment_id = cp_adjustment_id
629: AND iadb.active_flag IS NULL;
630:
631: -- Calculate the iac fa depreciation data for an adjustment
632: CURSOR c_iac_fa_deprn(cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE)
633: IS
634: SELECT nvl(sum(iadb.deprn_period), 0) deprn_period,
635: nvl(sum(iadb.deprn_reserve), 0) deprn_reserve,
636: nvl(sum(iadb.deprn_ytd), 0) deprn_ytd

Line 659: igi_iac_transaction_headers ith

655: )
656: IS
657: SELECT nvl(sum(decode(aj.dr_cr_flag, 'CR', 1, -1) *AJ.Amount), 0) op_expense_amt
658: FROM igi_iac_adjustments aj,
659: igi_iac_transaction_headers ith
660: WHERE aj.asset_id = cp_asset_id
661: AND aj.book_type_code = cp_book_type_code
662: AND aj.period_counter BETWEEN cp_tfr_prd_counter AND cp_cur_prd_counter
663: AND aj.adjustment_type = 'OP EXPENSE'

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

864: p_curr_prd_cntr IN igi_iac_det_balances.period_counter%TYPE
865: )
866: IS
867: -- Select all inactive distributions created by the previous transaction (keep)
868: CURSOR c_inactive_dist(c_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%TYPE)
869: IS
870: SELECT *
871: FROM igi_iac_det_balances
872: WHERE adjustment_id=c_adjustment_id

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

874: AND asset_id = p_asset_id
875: AND active_flag='N';
876:
877: -- get fa inactive rows for a distribution (keep)
878: CURSOR c_fa_inactive_dist(cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE)
879: IS
880: SELECT *
881: FROM igi_iac_fa_deprn
882: WHERE adjustment_id = cp_adjustment_id

Line 1105: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;

1101: act_cnt NUMBER ;
1102: inact_cnt NUMBER ;
1103: l_return_value BOOLEAN;
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;

Line 1106: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

1102: inact_cnt NUMBER ;
1103: l_return_value BOOLEAN;
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;

Line 1107: l_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

1103: l_return_value BOOLEAN;
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;

Line 1148: l_transaction_header_id IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type;

1144: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
1145: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
1146: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
1147:
1148: l_transaction_header_id IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type;
1149: l_transaction_type_code IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type;
1150: l_mass_reference_id IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type;
1151: l_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1152: l_prev_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;

Line 1149: l_transaction_type_code IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type;

1145: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
1146: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
1147:
1148: l_transaction_header_id IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type;
1149: l_transaction_type_code IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type;
1150: l_mass_reference_id IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type;
1151: l_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1152: l_prev_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1153: l_adjustment_status IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type;

Line 1150: l_mass_reference_id IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type;

1146: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
1147:
1148: l_transaction_header_id IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type;
1149: l_transaction_type_code IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type;
1150: l_mass_reference_id IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type;
1151: l_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1152: l_prev_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1153: l_adjustment_status IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type;
1154:

Line 1151: l_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;

1147:
1148: l_transaction_header_id IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type;
1149: l_transaction_type_code IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type;
1150: l_mass_reference_id IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type;
1151: l_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1152: l_prev_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1153: l_adjustment_status IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type;
1154:
1155: l_reval_reserve_sum igi_iac_det_balances.reval_reserve_cost%TYPE ;

Line 1152: l_prev_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;

1148: l_transaction_header_id IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type;
1149: l_transaction_type_code IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type;
1150: l_mass_reference_id IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type;
1151: l_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1152: l_prev_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1153: l_adjustment_status IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type;
1154:
1155: l_reval_reserve_sum igi_iac_det_balances.reval_reserve_cost%TYPE ;
1156: l_general_fund_sum igi_iac_det_balances.general_fund_acc%TYPE ;

Line 1153: l_adjustment_status IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type;

1149: l_transaction_type_code IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type;
1150: l_mass_reference_id IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type;
1151: l_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1152: l_prev_adjustment_id IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type;
1153: l_adjustment_status IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type;
1154:
1155: l_reval_reserve_sum igi_iac_det_balances.reval_reserve_cost%TYPE ;
1156: l_general_fund_sum igi_iac_det_balances.general_fund_acc%TYPE ;
1157: l_Backlog_deprn_reserve_sum igi_iac_det_balances.deprn_reserve_backlog%TYPE ;

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

1372: ELSE
1373: g_prior_period:= FALSE;
1374: END IF;
1375:
1376: -- create a new row in igi_iac_transaction_headers with transaction type code
1377: -- TRANSFERS
1378: -- initailise the new adjustment id
1379: l_adj_id := null;
1380:

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

2554: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Data Inserted in Asset balances');
2555: END IF;
2556: END IF;
2557:
2558: -- update the previous active row for the asset in igi_iac_transaction_headers
2559: -- in order to make it inactive by setting adjustment_id_out= adjustment_id of
2560: -- the active row in igi_iac_transaction_headers
2561: IGI_IAC_TRANS_HEADERS_PKG.Update_Row(
2562: x_prev_adjustment_id => l_adj_id_out,

Line 2560: -- the active row in igi_iac_transaction_headers

2556: END IF;
2557:
2558: -- update the previous active row for the asset in igi_iac_transaction_headers
2559: -- in order to make it inactive by setting adjustment_id_out= adjustment_id of
2560: -- the active row in igi_iac_transaction_headers
2561: IGI_IAC_TRANS_HEADERS_PKG.Update_Row(
2562: x_prev_adjustment_id => l_adj_id_out,
2563: x_adjustment_id => l_adj_id
2564: );

Line 2746: FROM igi_iac_transaction_headers

2742: /* Cursor to select data from transaction headers which need to be rolled back */
2743:
2744: CURSOR c_trans_headers IS
2745: SELECT *
2746: FROM igi_iac_transaction_headers
2747: WHERE book_type_code=p_book_type_code
2748: AND period_counter=p_period_counter
2749: AND transaction_type_code='TRANSFER';
2750:

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

2758: AND adjustment_id = cp_adjustment_id;
2759:
2760: /* Cursor to select the previous data */
2761:
2762: CURSOR c_prev_data(c_adjustment_id igi_iac_transaction_headers.adjustment_id%type) IS
2763: SELECT *
2764: FROM igi_iac_transaction_headers
2765: WHERE adjustment_id_out=c_adjustment_id;
2766:

Line 2764: FROM igi_iac_transaction_headers

2760: /* Cursor to select the previous data */
2761:
2762: CURSOR c_prev_data(c_adjustment_id igi_iac_transaction_headers.adjustment_id%type) IS
2763: SELECT *
2764: FROM igi_iac_transaction_headers
2765: WHERE adjustment_id_out=c_adjustment_id;
2766:
2767: /* Cursor to find the amounts that need to be transferred to the new dist
2768: created by transfer */

Line 2803: l_prev_adjustment igi_iac_transaction_headers%ROWTYPE;

2799: l_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2800: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2801: l_prior_period_counter IGI_IAC_DET_BALANCES.period_counter%type;
2802: l_current_period_counter IGI_IAC_DET_BALANCES.period_counter%type;
2803: l_prev_adjustment igi_iac_transaction_headers%ROWTYPE;
2804:
2805: l_path varchar2(150);
2806: BEGIN
2807: