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_TYPES

Line 35: ( fp_reval_exceptions in out NOCOPY IGI_IAC_TYPES.iac_reval_exception_line

31: end if;
32: end;
33:
34: function create_exceptions
35: ( fp_reval_exceptions in out NOCOPY IGI_IAC_TYPES.iac_reval_exception_line
36: , fp_revaluation_id in NUMBER
37: )
38: return boolean is
39:

Line 43: l_fp_reval_exceptions IGI_IAC_TYPES.iac_reval_exception_line;

39:
40: l_Category_id number;
41: l_login_id number ;
42: l_user_id number ;
43: l_fp_reval_exceptions IGI_IAC_TYPES.iac_reval_exception_line;
44: l_path varchar2(150) ;
45: begin
46: l_login_id := fnd_global.login_id;
47: l_user_id := fnd_global.user_id;

Line 105: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params

101: return FALSE;
102: end;
103:
104: function create_txn_headers
105: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
106: , fp_second_set in boolean )
107: return boolean is
108:
109: l_rowid rowid;

Line 113: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;

109: l_rowid rowid;
110: l_max_adjustment_id number;
111: l_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
112: l_reval_type_flag varchar2(1);
113: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;
114: l_path varchar2(150) ;
115: begin
116: l_max_adjustment_id := -1;
117: l_path := g_path||'create_txn_headers';

Line 199: , pp_reval_output_asset in IGI_IAC_TYPES.iac_reval_output_asset

195: end;
196:
197:
198: procedure create_balance (pp_period_counter in number
199: , pp_reval_output_asset in IGI_IAC_TYPES.iac_reval_output_asset
200: ) is
201:
202: l_exists boolean;
203: l_rowid varchar2(40);

Line 303: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params

299: return true;
300: end;
301:
302: function create_asset_balances
303: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
304: , fp_second_set in boolean )
305: return boolean is
306: l_rowid rowid;
307: l_processed boolean;

Line 312: l_fp_reval_params igi_iac_types.iac_reval_params;

308:
309: l_prev_cumm_rate number;
310: l_curr_cumm_rate number;
311: l_period_counter number;
312: l_fp_reval_params igi_iac_types.iac_reval_params;
313:
314: l_path varchar2(150);
315: begin
316:

Line 506: procedure round_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances )

502: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
503: return false;
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);

Line 509: l_fp_det_balances igi_iac_types.iac_det_balances;

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
513: begin

Line 555: procedure round_fa_figures ( fp_fa_hist in out NOCOPY IGI_IAC_TYPES.fa_hist_asset_info

551: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
552: Raise;
553: end;
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;

Line 556: , fp_det_balances in IGI_IAC_TYPES.iac_det_balances )

552: Raise;
553: end;
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);

Line 559: l_fp_fa_hist igi_iac_types.fa_hist_asset_info;

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
563: l_path varchar2(150);

Line 595: procedure verify_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances

591: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
592: Raise;
593: end;
594:
595: procedure verify_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
596: , fp_prev_cum_factor in number
597: , fp_curr_cum_factor in number
598: ) is
599:

Line 600: l_fp_det_balances igi_iac_types.iac_det_balances;

596: , fp_prev_cum_factor in number
597: , fp_curr_cum_factor in number
598: ) is
599:
600: l_fp_det_balances igi_iac_types.iac_det_balances;
601: l_path varchar2(150);
602: procedure initialize ( pp_amount in out NOCOPY number ) is
603: begin
604: pp_amount := 0;

Line 637: procedure add_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances

633: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
634: Raise;
635: end;
636:
637: procedure add_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
638: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances
639: )
640: is
641: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;

Line 638: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances

634: Raise;
635: end;
636:
637: procedure add_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
638: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances
639: )
640: is
641: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;
642: l_path varchar2(150);

Line 641: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;

637: procedure add_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
638: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances
639: )
640: is
641: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;
642: l_path varchar2(150);
643: begin
644: l_path := g_path||'add_det_balances';
645: -- for NOCOPY

Line 694: procedure remaining_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances

690: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
691: Raise;
692: end;
693:
694: procedure remaining_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
695: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances
696: )
697: is
698: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;

Line 695: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances

691: Raise;
692: end;
693:
694: procedure remaining_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
695: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances
696: )
697: is
698: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;
699: l_path varchar2(150);

Line 698: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;

694: procedure remaining_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
695: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances
696: )
697: is
698: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;
699: l_path varchar2(150);
700: begin
701: l_path := g_path||'remaining_det_balances';
702: -- for NOCOPY.

Line 742: procedure display_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances )

738: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
739: Raise;
740: end;
741:
742: procedure display_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances )
743: is
744: l_path varchar2(150);
745: begin
746: l_path := g_path||'display_det_balances';

Line 768: function create_det_balances_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances )

764: return;
765: end;
766:
767:
768: function create_det_balances_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances )
769: return boolean is
770: l_det_balances IGI_IAC_TYPES.iac_det_balances;
771: l_rowid varchar2(300);
772: l_path varchar2(150);

Line 770: l_det_balances IGI_IAC_TYPES.iac_det_balances;

766:
767:
768: function create_det_balances_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances )
769: return boolean is
770: l_det_balances IGI_IAC_TYPES.iac_det_balances;
771: l_rowid varchar2(300);
772: l_path varchar2(150);
773: begin
774: l_det_balances := fp_det_balances;

Line 841: function create_fa_figures_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances

837: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
838: return false;
839: end;
840:
841: function create_fa_figures_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances
842: , fp_fa_balances in IGI_IAC_TYPES.fa_hist_asset_info
843: )
844: return boolean is
845: l_det_balances IGI_IAC_TYPES.iac_det_balances;

Line 842: , fp_fa_balances in IGI_IAC_TYPES.fa_hist_asset_info

838: return false;
839: end;
840:
841: function create_fa_figures_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances
842: , fp_fa_balances in IGI_IAC_TYPES.fa_hist_asset_info
843: )
844: return boolean is
845: l_det_balances IGI_IAC_TYPES.iac_det_balances;
846: l_fa_balances IGI_IAC_TYPES.fa_hist_asset_info;

Line 845: l_det_balances IGI_IAC_TYPES.iac_det_balances;

841: function create_fa_figures_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances
842: , fp_fa_balances in IGI_IAC_TYPES.fa_hist_asset_info
843: )
844: return boolean is
845: l_det_balances IGI_IAC_TYPES.iac_det_balances;
846: l_fa_balances IGI_IAC_TYPES.fa_hist_asset_info;
847: l_rowid varchar2(300);
848: l_path varchar2(150);
849: begin

Line 846: l_fa_balances IGI_IAC_TYPES.fa_hist_asset_info;

842: , fp_fa_balances in IGI_IAC_TYPES.fa_hist_asset_info
843: )
844: return boolean is
845: l_det_balances IGI_IAC_TYPES.iac_det_balances;
846: l_fa_balances IGI_IAC_TYPES.fa_hist_asset_info;
847: l_rowid varchar2(300);
848: l_path varchar2(150);
849: begin
850: l_det_balances := fp_det_balances;

Line 1035: p_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab,

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
1038:
1039: l_rowid varchar2(40);

Line 1041: l_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab;

1037: RETURN BOOLEAN IS
1038:
1039: l_rowid varchar2(40);
1040: l_path varchar2(150);
1041: l_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab;
1042: l_YTD_prorate_dists_idx binary_integer;
1043: idx_YTD binary_integer;
1044: l_dist_iac_ytd number;
1045: l_dist_fa_ytd number;

Line 1128: function create_det_balances ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params

1124: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1125: return false;
1126: END Create_Inactive_Det_Balances;
1127:
1128: function create_det_balances ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
1129: , fp_second_set in boolean
1130: )
1131: return boolean is
1132:

Line 1173: l_prorate_dists_tab igi_iac_types.prorate_dists_tab;

1169: l_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
1170: l_reval_factor_curr number;
1171: l_reval_factor_cumm number;
1172: l_prev_factor_cumm number;
1173: l_prorate_dists_tab igi_iac_types.prorate_dists_tab;
1174: l_prorate_dists_idx binary_integer;
1175:
1176: l_processed boolean;
1177: idx binary_integer;

Line 1192: l_db IGI_IAC_TYPES.iac_det_balances;

1188: l_deprn_ytd number;
1189: l_old_deprn_ytd number;
1190: l_old_gen_fund number;
1191:
1192: l_db IGI_IAC_TYPES.iac_det_balances;
1193: l_db_fa IGI_IAC_TYPES.fa_hist_asset_info;
1194:
1195: l_prev_db IGI_IAC_TYPES.iac_det_balances;
1196: l_remaining IGI_IAC_TYPES.iac_det_balances;

Line 1193: l_db_fa IGI_IAC_TYPES.fa_hist_asset_info;

1189: l_old_deprn_ytd number;
1190: l_old_gen_fund number;
1191:
1192: l_db IGI_IAC_TYPES.iac_det_balances;
1193: l_db_fa IGI_IAC_TYPES.fa_hist_asset_info;
1194:
1195: l_prev_db IGI_IAC_TYPES.iac_det_balances;
1196: l_remaining IGI_IAC_TYPES.iac_det_balances;
1197: l_remaining_fa IGI_IAC_TYPES.fa_hist_asset_info;

Line 1195: l_prev_db IGI_IAC_TYPES.iac_det_balances;

1191:
1192: l_db IGI_IAC_TYPES.iac_det_balances;
1193: l_db_fa IGI_IAC_TYPES.fa_hist_asset_info;
1194:
1195: l_prev_db IGI_IAC_TYPES.iac_det_balances;
1196: l_remaining IGI_IAC_TYPES.iac_det_balances;
1197: l_remaining_fa IGI_IAC_TYPES.fa_hist_asset_info;
1198: l_total IGI_IAC_TYPES.iac_det_balances;
1199: l_total_fa IGI_IAC_TYPES.fa_hist_asset_info;

Line 1196: l_remaining IGI_IAC_TYPES.iac_det_balances;

1192: l_db IGI_IAC_TYPES.iac_det_balances;
1193: l_db_fa IGI_IAC_TYPES.fa_hist_asset_info;
1194:
1195: l_prev_db IGI_IAC_TYPES.iac_det_balances;
1196: l_remaining IGI_IAC_TYPES.iac_det_balances;
1197: l_remaining_fa IGI_IAC_TYPES.fa_hist_asset_info;
1198: l_total IGI_IAC_TYPES.iac_det_balances;
1199: l_total_fa IGI_IAC_TYPES.fa_hist_asset_info;
1200:

Line 1197: l_remaining_fa IGI_IAC_TYPES.fa_hist_asset_info;

1193: l_db_fa IGI_IAC_TYPES.fa_hist_asset_info;
1194:
1195: l_prev_db IGI_IAC_TYPES.iac_det_balances;
1196: l_remaining IGI_IAC_TYPES.iac_det_balances;
1197: l_remaining_fa IGI_IAC_TYPES.fa_hist_asset_info;
1198: l_total IGI_IAC_TYPES.iac_det_balances;
1199: l_total_fa IGI_IAC_TYPES.fa_hist_asset_info;
1200:
1201: /*

Line 1198: l_total IGI_IAC_TYPES.iac_det_balances;

1194:
1195: l_prev_db IGI_IAC_TYPES.iac_det_balances;
1196: l_remaining IGI_IAC_TYPES.iac_det_balances;
1197: l_remaining_fa IGI_IAC_TYPES.fa_hist_asset_info;
1198: l_total IGI_IAC_TYPES.iac_det_balances;
1199: l_total_fa IGI_IAC_TYPES.fa_hist_asset_info;
1200:
1201: /*
1202: Note : l_asset_level_calc is an important structure

Line 1199: l_total_fa IGI_IAC_TYPES.fa_hist_asset_info;

1195: l_prev_db IGI_IAC_TYPES.iac_det_balances;
1196: l_remaining IGI_IAC_TYPES.iac_det_balances;
1197: l_remaining_fa IGI_IAC_TYPES.fa_hist_asset_info;
1198: l_total IGI_IAC_TYPES.iac_det_balances;
1199: l_total_fa IGI_IAC_TYPES.fa_hist_asset_info;
1200:
1201: /*
1202: Note : l_asset_level_calc is an important structure
1203: -- If this is catchup, it needs to use the reval output asset information.

Line 1207: l_asset_level_calc IGI_IAC_TYPES.iac_reval_output_asset;

1203: -- If this is catchup, it needs to use the reval output asset information.
1204: -- if this is reval, it needs to use the reval mvmt asset information
1205: -- if this is reclass, it needs to use reval output asset information.
1206: */
1207: l_asset_level_calc IGI_IAC_TYPES.iac_reval_output_asset;
1208: l_factor number;
1209: l_ytd_factor number;
1210:
1211: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;

Line 1211: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;

1207: l_asset_level_calc IGI_IAC_TYPES.iac_reval_output_asset;
1208: l_factor number;
1209: l_ytd_factor number;
1210:
1211: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;
1212:
1213: /* YTD Revaluation proration */
1214: l_deprn_ytd_total number;
1215: l_remaining_deprn_ytd number;

Line 1219: l_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab;

1215: l_remaining_deprn_ytd number;
1216: l_dist_deprn_ytd number;
1217: l_iac_inactive_dists_ytd number;
1218: l_fa_inactive_dists_ytd number;
1219: l_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab;
1220: l_YTD_prorate_dists_idx binary_integer;
1221: idx_YTD binary_integer;
1222:
1223: l_path varchar2(150);

Line 1749: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params

1745: return false;
1746: end;
1747:
1748: function create_reval_rates
1749: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
1750: , fp_second_set in boolean )
1751: return boolean is
1752: l_reval_rates igi_iac_revaluation_rates%ROWTYPE;
1753: l_adjustment_id igi_iac_revaluation_rates.adjustment_id%TYPE;

Line 1754: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;

1750: , fp_second_set in boolean )
1751: return boolean is
1752: l_reval_rates igi_iac_revaluation_rates%ROWTYPE;
1753: l_adjustment_id igi_iac_revaluation_rates.adjustment_id%TYPE;
1754: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;
1755: l_path varchar2(150);
1756: begin
1757: l_path := g_path||'create_reval_rates';
1758: -- for NOCOPY

Line 1893: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params

1889: return false;
1890: end;
1891:
1892: function crud_iac_tables
1893: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
1894: , fp_second_set in boolean )
1895: return boolean is
1896:
1897: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;

Line 1897: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;

1893: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
1894: , fp_second_set in boolean )
1895: return boolean is
1896:
1897: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;
1898: l_path varchar2(150);
1899: begin
1900: l_path := g_path||'crud_iac_tables';
1901: -- for NOCOPY.

Line 1981: set status = IGI_IAC_TYPES.gc_previewed_status

1977: return boolean is
1978: pragma autonomous_transaction;
1979: begin
1980: update igi_iac_revaluations
1981: set status = IGI_IAC_TYPES.gc_previewed_status
1982: where revaluation_id = fp_reval_id
1983: ;
1984: if sql%found then
1985: do_commit;

Line 1999: set status = IGI_IAC_TYPES.gc_failedpre_status

1995: return boolean is
1996: pragma autonomous_transaction;
1997: begin
1998: update igi_iac_revaluations
1999: set status = IGI_IAC_TYPES.gc_failedpre_status
2000: where revaluation_id = fp_reval_id
2001: ;
2002: if sql%found then
2003: do_commit;

Line 2019: set status = IGI_IAC_TYPES.gc_completed_status,

2015: pragma autonomous_transaction;
2016: begin
2017: if p_event_id is not null then
2018: update igi_iac_revaluations
2019: set status = IGI_IAC_TYPES.gc_completed_status,
2020: event_id = p_event_id
2021: where revaluation_id = fp_reval_id
2022: and event_id is null;
2023: else

Line 2025: set status = IGI_IAC_TYPES.gc_completed_status

2021: where revaluation_id = fp_reval_id
2022: and event_id is null;
2023: else
2024: update igi_iac_revaluations
2025: set status = IGI_IAC_TYPES.gc_completed_status
2026: where revaluation_id = fp_reval_id;
2027: end if;
2028:
2029: if sql%found then

Line 2044: set status = IGI_IAC_TYPES.gc_failedrun_status

2040: return boolean is
2041: pragma autonomous_transaction;
2042: begin
2043: update igi_iac_revaluations
2044: set status = IGI_IAC_TYPES.gc_failedrun_status
2045: where revaluation_id = fp_reval_id
2046: ;
2047: if sql%found then
2048: do_commit;

Line 2212: l_output igi_iac_types.iac_reval_output_asset;

2208: l_bal_general_fund IGI_IAC_ASSET_BALANCES.general_fund%TYPE;
2209: l_cumm_reval_factor IGI_IAC_ASSET_BALANCES.cumulative_reval_factor%TYPE;
2210: l_reval_factor IGI_IAC_ASSET_BALANCES.current_reval_factor%TYPE;
2211: l_reval_date date;
2212: l_output igi_iac_types.iac_reval_output_asset;
2213:
2214: cursor c_asset_bal is
2215: select
2216: nvl(net_book_value,0) net_book_value