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

Line 357: , fp_det_balances out NOCOPY igi_iac_det_balances%ROWTYPE

353: , fp_asset_id in number
354: , fp_book_type_code in varchar2
355: , fp_period_counter in number
356: , fp_transaction_sub_type in varchar2
357: , fp_det_balances out NOCOPY igi_iac_det_balances%ROWTYPE
358: )
359: return boolean is
360:
361: l_fp_det_balances igi_iac_det_balances%ROWTYPE;

Line 361: l_fp_det_balances igi_iac_det_balances%ROWTYPE;

357: , fp_det_balances out NOCOPY igi_iac_det_balances%ROWTYPE
358: )
359: return boolean is
360:
361: l_fp_det_balances igi_iac_det_balances%ROWTYPE;
362: l_success boolean ;
363: transaction_sub_type igi_iac_transaction_headers.TRANSACTION_SUB_TYPE%TYPE;
364: period_counter number;
365:

Line 368: from igi_iac_det_balances bal

364: period_counter number;
365:
366: cursor c_prev_bal (period_counter number) is
367: select bal.*
368: from igi_iac_det_balances bal
369: where bal.adjustment_id = fp_adjustment_id
370: and bal.distribution_id = fp_distribution_id
371: and bal.asset_id = fp_asset_id
372: and bal.period_counter <= period_counter

Line 381: FROM igi_iac_transaction_headers th, igi_iac_det_balances db

377: SELECT 1
378: FROM dual
379: WHERE EXISTS(
380: SELECT 1
381: FROM igi_iac_transaction_headers th, igi_iac_det_balances db
382: WHERE th.transaction_sub_type = 'IMPLEMENTATION'
383: AND th.adjustment_id = db.adjustment_id
384: AND db.book_type_code = p_book_type_code
385: AND db.period_counter = p_period_counter

Line 406: from igi_iac_det_Balances

402: )
403: return boolean is
404: cursor c_exists is
405: select distinct 'x'
406: from igi_iac_det_Balances
407: where asset_id = p_asset_id
408: and distribution_id = p_distribution_id
409: and book_type_code = p_book_type_code
410: ;

Line 508: l_book_type_code igi_iac_det_balances.book_type_code%TYPE;

504: end;
505:
506: procedure round_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances )
507: is
508: l_book_type_code igi_iac_det_balances.book_type_code%TYPE;
509: l_fp_det_balances igi_iac_types.iac_det_balances;
510: l_path varchar2(150);
511:
512: procedure Do_Rounding ( pp_amount in out NOCOPY number ) is

Line 558: l_book_type_code igi_iac_det_balances.book_type_code%TYPE;

554:
555: procedure round_fa_figures ( fp_fa_hist in out NOCOPY IGI_IAC_TYPES.fa_hist_asset_info
556: , fp_det_balances in IGI_IAC_TYPES.iac_det_balances )
557: is
558: l_book_type_code igi_iac_det_balances.book_type_code%TYPE;
559: l_fp_fa_hist igi_iac_types.fa_hist_asset_info;
560: l_path varchar2(150);
561:
562: procedure Do_Rounding ( pp_amount in out NOCOPY number ) is

Line 806: IGI_IAC_DET_BALANCES_PKG.insert_row (

802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
803:
804:
805:
806: IGI_IAC_DET_BALANCES_PKG.insert_row (
807: x_rowid => l_rowid,
808: x_adjustment_id => l_det_balances.adjustment_id,
809: x_asset_id => l_det_balances.asset_id,
810: x_distribution_id => l_det_balances.distribution_id,

Line 884: FUNCTION forward_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,

880: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
881: return false;
882: end;
883:
884: FUNCTION forward_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
885: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
886: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
887: p_period_counter igi_iac_det_balances.period_counter%TYPE,
888: p_iac_inactive_dists_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,

Line 885: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,

881: return false;
882: end;
883:
884: FUNCTION forward_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
885: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
886: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
887: p_period_counter igi_iac_det_balances.period_counter%TYPE,
888: p_iac_inactive_dists_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
889: p_fa_inactive_dists_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE)

Line 886: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,

882: end;
883:
884: FUNCTION forward_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
885: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
886: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
887: p_period_counter igi_iac_det_balances.period_counter%TYPE,
888: p_iac_inactive_dists_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
889: p_fa_inactive_dists_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE)
890: RETURN BOOLEAN IS

Line 887: p_period_counter igi_iac_det_balances.period_counter%TYPE,

883:
884: FUNCTION forward_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
885: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
886: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
887: p_period_counter igi_iac_det_balances.period_counter%TYPE,
888: p_iac_inactive_dists_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
889: p_fa_inactive_dists_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE)
890: RETURN BOOLEAN IS
891:

Line 888: p_iac_inactive_dists_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,

884: FUNCTION forward_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
885: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
886: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
887: p_period_counter igi_iac_det_balances.period_counter%TYPE,
888: p_iac_inactive_dists_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
889: p_fa_inactive_dists_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE)
890: RETURN BOOLEAN IS
891:
892: CURSOR c_get_prev_adjustment IS

Line 901: CURSOR c_get_iac_inactive_dists(cp_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS

897: AND adjustment_id < p_adjustment_id
898: AND adjustment_status NOT IN ('PREVIEW','OBSOLETE');
899:
900: -- cursor to retrieve the inactive distributions that will be rolled forward
901: CURSOR c_get_iac_inactive_dists(cp_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
902: SELECT iidb.adjustment_id,
903: iidb.distribution_id,
904: iidb.adjustment_cost,
905: iidb.net_book_value,

Line 924: FROM igi_iac_det_balances iidb

920: iidb.active_flag,
921: iidb.last_reval_date,
922: iidb.current_reval_factor,
923: iidb.cumulative_reval_factor
924: FROM igi_iac_det_balances iidb
925: WHERE iidb.adjustment_id = cp_adjustment_id
926: AND iidb.asset_id = p_asset_id
927: AND iidb.book_type_code = p_book_type_code
928: AND nvl(iidb.active_flag,'Y') = 'N';

Line 968: -- insert into igi_iac_det_balances with reinstatement adjustment_id

964: RETURN TRUE;
965: END IF;
966:
967: FOR l_iac_inactive_dist IN c_get_iac_inactive_dists(l_prev_adjustment_id) LOOP
968: -- insert into igi_iac_det_balances with reinstatement adjustment_id
969: l_rowid := NULL;
970: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
971: x_rowid => l_rowid,
972: x_adjustment_id => p_adjustment_id,

Line 970: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

966:
967: FOR l_iac_inactive_dist IN c_get_iac_inactive_dists(l_prev_adjustment_id) LOOP
968: -- insert into igi_iac_det_balances with reinstatement adjustment_id
969: l_rowid := NULL;
970: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
971: x_rowid => l_rowid,
972: x_adjustment_id => p_adjustment_id,
973: x_asset_id => p_asset_id,
974: x_book_type_code => p_book_type_code,

Line 1029: FUNCTION Create_Inactive_Det_Balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,

1025: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1026: return false;
1027: END forward_inactive_det_balances;
1028:
1029: FUNCTION Create_Inactive_Det_Balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
1030: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
1031: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
1032: p_period_counter igi_iac_det_balances.period_counter%TYPE,
1033: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,

Line 1030: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,

1026: return false;
1027: END forward_inactive_det_balances;
1028:
1029: FUNCTION Create_Inactive_Det_Balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
1030: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
1031: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
1032: p_period_counter igi_iac_det_balances.period_counter%TYPE,
1033: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
1034: p_asset_fa_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE,

Line 1031: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,

1027: END forward_inactive_det_balances;
1028:
1029: FUNCTION Create_Inactive_Det_Balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
1030: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
1031: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
1032: p_period_counter igi_iac_det_balances.period_counter%TYPE,
1033: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
1034: p_asset_fa_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE,
1035: p_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab,

Line 1032: p_period_counter igi_iac_det_balances.period_counter%TYPE,

1028:
1029: FUNCTION Create_Inactive_Det_Balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
1030: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
1031: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
1032: p_period_counter igi_iac_det_balances.period_counter%TYPE,
1033: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
1034: p_asset_fa_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE,
1035: p_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab,
1036: p_YTD_prorate_dists_idx binary_integer)

Line 1033: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,

1029: FUNCTION Create_Inactive_Det_Balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
1030: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
1031: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
1032: p_period_counter igi_iac_det_balances.period_counter%TYPE,
1033: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
1034: p_asset_fa_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE,
1035: p_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab,
1036: p_YTD_prorate_dists_idx binary_integer)
1037: RETURN BOOLEAN IS

Line 1070: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_det_balances');

1066: , x_book => p_book_type_code) then
1067: RETURN FALSE;
1068: END IF;
1069:
1070: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_det_balances');
1071: l_rowid := NULL;
1072: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
1073: x_rowid => l_rowid,
1074: x_adjustment_id => p_adjustment_id,

Line 1072: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

1068: END IF;
1069:
1070: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_det_balances');
1071: l_rowid := NULL;
1072: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
1073: x_rowid => l_rowid,
1074: x_adjustment_id => p_adjustment_id,
1075: x_asset_id => p_asset_id,
1076: x_book_type_code => p_book_type_code,

Line 1445: l_deprn_ytd_total := l_deprn_ytd_total - l_iac_inactive_dists_ytd; /* YTD for igi_iac_det_balances */

1441: l_fa_inactive_dists_ytd) THEN
1442: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+forward inactive detail balances Failed');
1443: return false;
1444: ELSE
1445: l_deprn_ytd_total := l_deprn_ytd_total - l_iac_inactive_dists_ytd; /* YTD for igi_iac_det_balances */
1446: l_total_fa.ytd_deprn := l_total_fa.ytd_deprn - l_fa_inactive_dists_ytd; /* YTD for igi_iac_fa_deprn */
1447: END IF;
1448:
1449: IF (fp_reval_params.reval_control.transaction_type_code = 'REVALUATION' AND

Line 1521: from igi_iac_det_balances

1517:
1518: begin
1519: select nvl(operating_acct_ytd,0)
1520: into l_operatg_ytd_bal
1521: from igi_iac_det_balances
1522: where asset_id = fp_reval_params.reval_asset_params.asset_id
1523: and distribution_id = l_prorate_dists_tab( idx ).distribution_id
1524: and book_type_code = fp_reval_params.reval_asset_params.book_type_code
1525: and adjustment_id = l_prev_adj_id

Line 1569: l_dist_deprn_ytd := l_deprn_ytd_total * l_ytd_factor; /* YTD proration for igi_iac_det_balances */

1565: l_db.current_reval_factor := l_reval_factor_curr;
1566: l_db.cumulative_reval_factor := l_reval_factor_cumm;
1567: l_db.active_flag := l_prorate_dists_tab ( idx ).active_flag;
1568:
1569: l_dist_deprn_ytd := l_deprn_ytd_total * l_ytd_factor; /* YTD proration for igi_iac_det_balances */
1570:
1571: if not igi_iac_common_utils.iac_round ( x_amount => l_dist_deprn_ytd
1572: , x_book => fp_reval_params.reval_asset_params.book_type_code ) then
1573: return false;

Line 1622: l_dist_deprn_ytd := l_deprn_ytd_total * l_ytd_factor; /* YTD for igi_iac_det_balances */

1618: l_db.current_reval_factor := l_reval_factor_curr;
1619: l_db.cumulative_reval_factor := l_reval_factor_cumm;
1620: l_db.active_flag := l_prorate_dists_tab ( idx ).active_flag;
1621:
1622: l_dist_deprn_ytd := l_deprn_ytd_total * l_ytd_factor; /* YTD for igi_iac_det_balances */
1623:
1624: verify_det_balances ( fp_det_balances => l_db
1625: , fp_prev_cum_factor => l_prev_factor_cumm
1626: , fp_curr_cum_factor => l_reval_factor_cumm

Line 2247: from igi_iac_det_balances

2243: ,nvl(sum(deprn_period),0) deprn_amount
2244: ,nvl(sum(deprn_reserve),0) deprn_reserve
2245: ,nvl(sum(deprn_reserve_backlog),0) backlog_deprn_reserve
2246: ,nvl(sum(nvl(reval_reserve_gen_fund,0)),0) general_fund
2247: from igi_iac_det_balances
2248: where asset_id = fp_asset_id
2249: and book_type_code = fp_book_type_code
2250: and period_counter = fp_period_counter
2251: and adjustment_id in ( select adjustment_id

Line 2291: -- 2. Get the sum from igi_iac_det_balances

2287: for l_bal in c_asset_bal loop
2288: l_cumm_reval_factor := l_bal.cumulative_reval_factor;
2289: end loop;
2290:
2291: -- 2. Get the sum from igi_iac_det_balances
2292: for l_det in c_asset_det loop
2293: -- 3. add (1) and (2) to get the final result.
2294: l_bal_net_book_value := l_bal_net_book_value + l_det.net_book_value;
2295: l_bal_adjusted_cost := l_bal_adjusted_cost + l_det.adjusted_cost;