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 459: l_detail_balance igi_iac_det_balances%ROWTYPE;

455: l_chart_of_accts_id NUMBER(15) ;
456: l_currency_code VARCHAR2(15) ;
457: l_precision VARCHAR2(1) ;
458: l_idx NUMBER;
459: l_detail_balance igi_iac_det_balances%ROWTYPE;
460: l_distribution_amount NUMBER;
461: l_dist_period_amount NUMBER;
462: l_last_catchup_prd_rec igi_iac_types.prd_rec;
463: l_last_reval_prd_rec igi_iac_types.prd_rec;

Line 465: l_reval_reserve_net igi_iac_det_balances.reval_reserve_net%TYPE;

461: l_dist_period_amount NUMBER;
462: l_last_catchup_prd_rec igi_iac_types.prd_rec;
463: l_last_reval_prd_rec igi_iac_types.prd_rec;
464: l_deprn_ytd NUMBER;
465: l_reval_reserve_net igi_iac_det_balances.reval_reserve_net%TYPE;
466: l_reval_general_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
467: l_general_fund_acc igi_iac_det_balances.general_fund_acc%TYPE;
468: l_fa_deprn_acc NUMBER;
469: l_fa_deprn_catchup_amount NUMBER;

Line 466: l_reval_general_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;

462: l_last_catchup_prd_rec igi_iac_types.prd_rec;
463: l_last_reval_prd_rec igi_iac_types.prd_rec;
464: l_deprn_ytd NUMBER;
465: l_reval_reserve_net igi_iac_det_balances.reval_reserve_net%TYPE;
466: l_reval_general_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
467: l_general_fund_acc igi_iac_det_balances.general_fund_acc%TYPE;
468: l_fa_deprn_acc NUMBER;
469: l_fa_deprn_catchup_amount NUMBER;
470: l_iac_fa_deprn_rec igi_iac_fa_deprn%ROWTYPE;

Line 467: l_general_fund_acc igi_iac_det_balances.general_fund_acc%TYPE;

463: l_last_reval_prd_rec igi_iac_types.prd_rec;
464: l_deprn_ytd NUMBER;
465: l_reval_reserve_net igi_iac_det_balances.reval_reserve_net%TYPE;
466: l_reval_general_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
467: l_general_fund_acc igi_iac_det_balances.general_fund_acc%TYPE;
468: l_fa_deprn_acc NUMBER;
469: l_fa_deprn_catchup_amount NUMBER;
470: l_iac_fa_deprn_rec igi_iac_fa_deprn%ROWTYPE;
471: l_last_deprn_catchup_period NUMBER;

Line 508: FROM igi_iac_det_balances

504: AND adjustment_id_out is NULL;
505:
506: CURSOR c_get_detail_balances(p_adjustment_id NUMBER,p_distribution_id NUMBER) IS
507: SELECT *
508: FROM igi_iac_det_balances
509: WHERE book_type_code = p_asset_balance.book_type_code
510: AND asset_id = p_asset_balance.asset_id
511: AND adjustment_id = p_adjustment_id
512: AND distribution_id = p_distribution_id;

Line 516: FROM igi_iac_det_balances

512: AND distribution_id = p_distribution_id;
513:
514: CURSOR c_get_inactive_dists(p_adjustment_id NUMBER) IS
515: SELECT *
516: FROM igi_iac_det_balances
517: WHERE adjustment_id = p_adjustment_id
518: AND book_type_code = p_asset_balance.book_type_code
519: AND asset_id = p_asset_balance.asset_id
520: AND nvl(active_flag,'Y') = 'N';

Line 919: igi_iac_det_balances_pkg.insert_row(

915: p_full_path => l_path_name,
916: p_string => ' Distribution Id :'||to_char(l_inactive_dist.distribution_id));
917:
918: l_rowid := NULL;
919: igi_iac_det_balances_pkg.insert_row(
920: X_rowid => l_rowid ,
921: X_adjustment_id => l_adjustment_id ,
922: X_asset_id => l_inactive_dist.asset_id ,
923: X_distribution_id => l_inactive_dist.distribution_id ,

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

944: X_cumulative_reval_factor => l_inactive_dist.cumulative_reval_factor ,
945: X_active_flag => l_inactive_dist.active_flag ) ;
946:
947: l_iac_inactive_dists_YTD := l_iac_inactive_dists_YTD + l_inactive_dist.deprn_ytd;
948: END LOOP; /* inactive distributions of igi_iac_det_balances */
949:
950: FOR l_iac_fa_inactive_dist IN c_get_iac_fa_inactive_dists(l_transaction.adjustment_id) LOOP
951: l_rowid := NULL;
952: igi_iac_fa_deprn_pkg.insert_row(

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

1203: END IF;
1204:
1205: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1206: p_full_path => l_path_name,
1207: p_string => ' Inserting into igi_iac_det_balances ');
1208: l_rowid := NULL;
1209: igi_iac_det_balances_pkg.insert_row(
1210: X_rowid => l_rowid ,
1211: X_adjustment_id => l_adjustment_id ,

Line 1209: igi_iac_det_balances_pkg.insert_row(

1205: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1206: p_full_path => l_path_name,
1207: p_string => ' Inserting into igi_iac_det_balances ');
1208: l_rowid := NULL;
1209: igi_iac_det_balances_pkg.insert_row(
1210: X_rowid => l_rowid ,
1211: X_adjustment_id => l_adjustment_id ,
1212: X_asset_id => l_detail_balance.asset_id ,
1213: X_distribution_id => l_detail_balance.distribution_id ,