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_CATCHUP_PKG dependencies on IGI_IAC_DET_BALANCES

Line 501: l_detail_balance igi_iac_det_balances%ROWTYPE;

497: l_chart_of_accts_id NUMBER(15) ;
498: l_currency_code VARCHAR2(15) ;
499: l_precision VARCHAR2(1) ;
500: l_idx NUMBER;
501: l_detail_balance igi_iac_det_balances%ROWTYPE;
502: l_distribution_amount NUMBER;
503: l_dist_period_amount NUMBER;
504: l_last_catchup_prd_rec igi_iac_types.prd_rec;
505: l_last_reval_prd_rec igi_iac_types.prd_rec;

Line 507: l_reval_reserve_net igi_iac_det_balances.reval_reserve_net%TYPE;

503: l_dist_period_amount NUMBER;
504: l_last_catchup_prd_rec igi_iac_types.prd_rec;
505: l_last_reval_prd_rec igi_iac_types.prd_rec;
506: l_deprn_ytd NUMBER;
507: l_reval_reserve_net igi_iac_det_balances.reval_reserve_net%TYPE;
508: l_reval_general_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
509: l_general_fund_acc igi_iac_det_balances.general_fund_acc%TYPE;
510: l_fa_deprn_acc NUMBER;
511: l_fa_deprn_catchup_amount NUMBER;

Line 508: l_reval_general_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;

504: l_last_catchup_prd_rec igi_iac_types.prd_rec;
505: l_last_reval_prd_rec igi_iac_types.prd_rec;
506: l_deprn_ytd NUMBER;
507: l_reval_reserve_net igi_iac_det_balances.reval_reserve_net%TYPE;
508: l_reval_general_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
509: l_general_fund_acc igi_iac_det_balances.general_fund_acc%TYPE;
510: l_fa_deprn_acc NUMBER;
511: l_fa_deprn_catchup_amount NUMBER;
512: l_iac_fa_deprn_rec igi_iac_fa_deprn%ROWTYPE;

Line 509: l_general_fund_acc igi_iac_det_balances.general_fund_acc%TYPE;

505: l_last_reval_prd_rec igi_iac_types.prd_rec;
506: l_deprn_ytd NUMBER;
507: l_reval_reserve_net igi_iac_det_balances.reval_reserve_net%TYPE;
508: l_reval_general_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
509: l_general_fund_acc igi_iac_det_balances.general_fund_acc%TYPE;
510: l_fa_deprn_acc NUMBER;
511: l_fa_deprn_catchup_amount NUMBER;
512: l_iac_fa_deprn_rec igi_iac_fa_deprn%ROWTYPE;
513: l_last_deprn_catchup_period NUMBER;

Line 550: FROM igi_iac_det_balances

546: AND adjustment_id_out is NULL;
547:
548: CURSOR c_get_detail_balances(p_adjustment_id NUMBER,p_distribution_id NUMBER) IS
549: SELECT *
550: FROM igi_iac_det_balances
551: WHERE book_type_code = p_asset_balance.book_type_code
552: AND asset_id = p_asset_balance.asset_id
553: AND adjustment_id = p_adjustment_id
554: AND distribution_id = p_distribution_id;

Line 558: FROM igi_iac_det_balances

554: AND distribution_id = p_distribution_id;
555:
556: CURSOR c_get_inactive_dists(p_adjustment_id NUMBER) IS
557: SELECT *
558: FROM igi_iac_det_balances
559: WHERE adjustment_id = p_adjustment_id
560: AND book_type_code = p_asset_balance.book_type_code
561: AND asset_id = p_asset_balance.asset_id
562: AND nvl(active_flag,'Y') = 'N';

Line 990: igi_iac_det_balances_pkg.insert_row(

986: p_full_path => l_path_name,
987: p_string => ' Distribution Id :'||to_char(l_inactive_dist.distribution_id));
988:
989: l_rowid := NULL;
990: igi_iac_det_balances_pkg.insert_row(
991: X_rowid => l_rowid ,
992: X_adjustment_id => l_adjustment_id ,
993: X_asset_id => l_inactive_dist.asset_id ,
994: X_distribution_id => l_inactive_dist.distribution_id ,

Line 1019: END LOOP; /* inactive distributions of igi_iac_det_balances */

1015: X_cumulative_reval_factor => l_inactive_dist.cumulative_reval_factor ,
1016: X_active_flag => l_inactive_dist.active_flag ) ;
1017:
1018: l_iac_inactive_dists_YTD := l_iac_inactive_dists_YTD + l_inactive_dist.deprn_ytd;
1019: END LOOP; /* inactive distributions of igi_iac_det_balances */
1020:
1021: FOR l_iac_fa_inactive_dist IN c_get_iac_fa_inactive_dists(l_transaction.adjustment_id) LOOP
1022: l_rowid := NULL;
1023: igi_iac_fa_deprn_pkg.insert_row(

Line 1286: p_string => ' Inserting into igi_iac_det_balances ');

1282: END IF;
1283:
1284: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1285: p_full_path => l_path_name,
1286: p_string => ' Inserting into igi_iac_det_balances ');
1287: l_rowid := NULL;
1288: igi_iac_det_balances_pkg.insert_row(
1289: X_rowid => l_rowid ,
1290: X_adjustment_id => l_adjustment_id ,

Line 1288: igi_iac_det_balances_pkg.insert_row(

1284: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1285: p_full_path => l_path_name,
1286: p_string => ' Inserting into igi_iac_det_balances ');
1287: l_rowid := NULL;
1288: igi_iac_det_balances_pkg.insert_row(
1289: X_rowid => l_rowid ,
1290: X_adjustment_id => l_adjustment_id ,
1291: X_asset_id => l_detail_balance.asset_id ,
1292: X_distribution_id => l_detail_balance.distribution_id ,