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 58: ( fp_reval_exceptions in out NOCOPY IGI_IAC_TYPES.iac_reval_exception_line

54: Raise;
55: end;
56:
57: function create_exceptions
58: ( fp_reval_exceptions in out NOCOPY IGI_IAC_TYPES.iac_reval_exception_line
59: , fp_revaluation_id in NUMBER
60: )
61: return boolean is
62:

Line 66: l_fp_reval_exceptions IGI_IAC_TYPES.iac_reval_exception_line;

62:
63: l_Category_id number;
64: l_login_id number ;
65: l_user_id number ;
66: l_fp_reval_exceptions IGI_IAC_TYPES.iac_reval_exception_line;
67: l_path varchar2(150) ;
68: begin
69: l_login_id := fnd_global.login_id;
70: l_user_id := fnd_global.user_id;

Line 128: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params

124: return FALSE;
125: end;
126:
127: function create_txn_headers
128: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
129: , fp_second_set in boolean )
130: return boolean is
131:
132: l_rowid rowid;

Line 136: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;

132: l_rowid rowid;
133: l_max_adjustment_id number;
134: l_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
135: l_reval_type_flag varchar2(1);
136: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;
137: l_path varchar2(150) ;
138: begin
139: l_max_adjustment_id := -1;
140: l_path := g_path||'create_txn_headers';

Line 222: , pp_reval_output_asset in IGI_IAC_TYPES.iac_reval_output_asset

218: end;
219:
220:
221: procedure create_balance (pp_period_counter in number
222: , pp_reval_output_asset in IGI_IAC_TYPES.iac_reval_output_asset
223: ) is
224:
225: l_exists boolean;
226: l_rowid varchar2(40);

Line 326: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params

322: return true;
323: end;
324:
325: function create_asset_balances
326: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
327: , fp_second_set in boolean )
328: return boolean is
329: l_rowid rowid;
330: l_processed boolean;

Line 335: l_fp_reval_params igi_iac_types.iac_reval_params;

331:
332: l_prev_cumm_rate number;
333: l_curr_cumm_rate number;
334: l_period_counter number;
335: l_fp_reval_params igi_iac_types.iac_reval_params;
336:
337: l_path varchar2(150);
338: begin
339:

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

525: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
526: return false;
527: end;
528:
529: procedure round_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances )
530: is
531: l_book_type_code igi_iac_det_balances.book_type_code%TYPE;
532: l_fp_det_balances igi_iac_types.iac_det_balances;
533: l_path varchar2(150);

Line 532: l_fp_det_balances igi_iac_types.iac_det_balances;

528:
529: procedure round_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances )
530: is
531: l_book_type_code igi_iac_det_balances.book_type_code%TYPE;
532: l_fp_det_balances igi_iac_types.iac_det_balances;
533: l_path varchar2(150);
534:
535: procedure Do_Rounding ( pp_amount in out NOCOPY number ) is
536: begin

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

574: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
575: Raise;
576: end;
577:
578: procedure round_fa_figures ( fp_fa_hist in out NOCOPY IGI_IAC_TYPES.fa_hist_asset_info
579: , fp_det_balances in IGI_IAC_TYPES.iac_det_balances )
580: is
581: l_book_type_code igi_iac_det_balances.book_type_code%TYPE;
582: l_fp_fa_hist igi_iac_types.fa_hist_asset_info;

Line 579: , fp_det_balances in IGI_IAC_TYPES.iac_det_balances )

575: Raise;
576: end;
577:
578: procedure round_fa_figures ( fp_fa_hist in out NOCOPY IGI_IAC_TYPES.fa_hist_asset_info
579: , fp_det_balances in IGI_IAC_TYPES.iac_det_balances )
580: is
581: l_book_type_code igi_iac_det_balances.book_type_code%TYPE;
582: l_fp_fa_hist igi_iac_types.fa_hist_asset_info;
583: l_path varchar2(150);

Line 582: l_fp_fa_hist igi_iac_types.fa_hist_asset_info;

578: procedure round_fa_figures ( fp_fa_hist in out NOCOPY IGI_IAC_TYPES.fa_hist_asset_info
579: , fp_det_balances in IGI_IAC_TYPES.iac_det_balances )
580: is
581: l_book_type_code igi_iac_det_balances.book_type_code%TYPE;
582: l_fp_fa_hist igi_iac_types.fa_hist_asset_info;
583: l_path varchar2(150);
584:
585: procedure Do_Rounding ( pp_amount in out NOCOPY number ) is
586: l_path varchar2(150);

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

614: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
615: Raise;
616: end;
617:
618: procedure verify_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
619: , fp_prev_cum_factor in number
620: , fp_curr_cum_factor in number
621: ) is
622:

Line 623: l_fp_det_balances igi_iac_types.iac_det_balances;

619: , fp_prev_cum_factor in number
620: , fp_curr_cum_factor in number
621: ) is
622:
623: l_fp_det_balances igi_iac_types.iac_det_balances;
624: l_path varchar2(150);
625: procedure initialize ( pp_amount in out NOCOPY number ) is
626: begin
627: pp_amount := 0;

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

656: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
657: Raise;
658: end;
659:
660: procedure add_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
661: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances
662: )
663: is
664: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;

Line 661: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances

657: Raise;
658: end;
659:
660: procedure add_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
661: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances
662: )
663: is
664: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;
665: l_path varchar2(150);

Line 664: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;

660: procedure add_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
661: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances
662: )
663: is
664: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;
665: l_path varchar2(150);
666: begin
667: l_path := g_path||'add_det_balances';
668: -- for NOCOPY

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

713: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
714: Raise;
715: end;
716:
717: procedure remaining_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
718: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances
719: )
720: is
721: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;

Line 718: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances

714: Raise;
715: end;
716:
717: procedure remaining_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
718: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances
719: )
720: is
721: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;
722: l_path varchar2(150);

Line 721: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;

717: procedure remaining_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
718: , fp_det_delta in IGI_IAC_TYPES.iac_det_balances
719: )
720: is
721: l_fp_det_balances IGI_IAC_TYPES.iac_det_balances;
722: l_path varchar2(150);
723: begin
724: l_path := g_path||'remaining_det_balances';
725: -- for NOCOPY.

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

761: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
762: Raise;
763: end;
764:
765: procedure display_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances )
766: is
767: l_path varchar2(150);
768: begin
769: l_path := g_path||'display_det_balances';

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

787: return;
788: end;
789:
790:
791: function create_det_balances_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances )
792: return boolean is
793: l_det_balances IGI_IAC_TYPES.iac_det_balances;
794: l_rowid varchar2(300);
795: l_path varchar2(150);

Line 793: l_det_balances IGI_IAC_TYPES.iac_det_balances;

789:
790:
791: function create_det_balances_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances )
792: return boolean is
793: l_det_balances IGI_IAC_TYPES.iac_det_balances;
794: l_rowid varchar2(300);
795: l_path varchar2(150);
796: begin
797: l_det_balances := fp_det_balances;

Line 864: function create_fa_figures_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances

860: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
861: return false;
862: end;
863:
864: function create_fa_figures_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances
865: , fp_fa_balances in IGI_IAC_TYPES.fa_hist_asset_info
866: )
867: return boolean is
868: l_det_balances IGI_IAC_TYPES.iac_det_balances;

Line 865: , fp_fa_balances in IGI_IAC_TYPES.fa_hist_asset_info

861: return false;
862: end;
863:
864: function create_fa_figures_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances
865: , fp_fa_balances in IGI_IAC_TYPES.fa_hist_asset_info
866: )
867: return boolean is
868: l_det_balances IGI_IAC_TYPES.iac_det_balances;
869: l_fa_balances IGI_IAC_TYPES.fa_hist_asset_info;

Line 868: l_det_balances IGI_IAC_TYPES.iac_det_balances;

864: function create_fa_figures_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances
865: , fp_fa_balances in IGI_IAC_TYPES.fa_hist_asset_info
866: )
867: return boolean is
868: l_det_balances IGI_IAC_TYPES.iac_det_balances;
869: l_fa_balances IGI_IAC_TYPES.fa_hist_asset_info;
870: l_rowid varchar2(300);
871: l_path varchar2(150);
872: begin

Line 869: l_fa_balances IGI_IAC_TYPES.fa_hist_asset_info;

865: , fp_fa_balances in IGI_IAC_TYPES.fa_hist_asset_info
866: )
867: return boolean is
868: l_det_balances IGI_IAC_TYPES.iac_det_balances;
869: l_fa_balances IGI_IAC_TYPES.fa_hist_asset_info;
870: l_rowid varchar2(300);
871: l_path varchar2(150);
872: begin
873: l_det_balances := fp_det_balances;

Line 1058: p_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab,

1054: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
1055: p_period_counter igi_iac_det_balances.period_counter%TYPE,
1056: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
1057: p_asset_fa_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE,
1058: p_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab,
1059: p_YTD_prorate_dists_idx binary_integer)
1060: RETURN BOOLEAN IS
1061:
1062: l_rowid varchar2(40);

Line 1064: l_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab;

1060: RETURN BOOLEAN IS
1061:
1062: l_rowid varchar2(40);
1063: l_path varchar2(150);
1064: l_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab;
1065: l_YTD_prorate_dists_idx binary_integer;
1066: idx_YTD binary_integer;
1067: l_dist_iac_ytd number;
1068: l_dist_fa_ytd number;

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

1140: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1141: return false;
1142: END Create_Inactive_Det_Balances;
1143:
1144: function create_det_balances ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
1145: , fp_second_set in boolean
1146: )
1147: return boolean is
1148:

Line 1189: l_prorate_dists_tab igi_iac_types.prorate_dists_tab;

1185: l_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
1186: l_reval_factor_curr number;
1187: l_reval_factor_cumm number;
1188: l_prev_factor_cumm number;
1189: l_prorate_dists_tab igi_iac_types.prorate_dists_tab;
1190: l_prorate_dists_idx binary_integer;
1191:
1192: l_processed boolean;
1193: idx binary_integer;

Line 1208: l_db IGI_IAC_TYPES.iac_det_balances;

1204: l_deprn_ytd number;
1205: l_old_deprn_ytd number;
1206: l_old_gen_fund number;
1207:
1208: l_db IGI_IAC_TYPES.iac_det_balances;
1209: l_db_fa IGI_IAC_TYPES.fa_hist_asset_info;
1210:
1211: l_prev_db IGI_IAC_TYPES.iac_det_balances;
1212: l_remaining IGI_IAC_TYPES.iac_det_balances;

Line 1209: l_db_fa IGI_IAC_TYPES.fa_hist_asset_info;

1205: l_old_deprn_ytd number;
1206: l_old_gen_fund number;
1207:
1208: l_db IGI_IAC_TYPES.iac_det_balances;
1209: l_db_fa IGI_IAC_TYPES.fa_hist_asset_info;
1210:
1211: l_prev_db IGI_IAC_TYPES.iac_det_balances;
1212: l_remaining IGI_IAC_TYPES.iac_det_balances;
1213: l_remaining_fa IGI_IAC_TYPES.fa_hist_asset_info;

Line 1211: l_prev_db IGI_IAC_TYPES.iac_det_balances;

1207:
1208: l_db IGI_IAC_TYPES.iac_det_balances;
1209: l_db_fa IGI_IAC_TYPES.fa_hist_asset_info;
1210:
1211: l_prev_db IGI_IAC_TYPES.iac_det_balances;
1212: l_remaining IGI_IAC_TYPES.iac_det_balances;
1213: l_remaining_fa IGI_IAC_TYPES.fa_hist_asset_info;
1214: l_total IGI_IAC_TYPES.iac_det_balances;
1215: l_total_fa IGI_IAC_TYPES.fa_hist_asset_info;

Line 1212: l_remaining IGI_IAC_TYPES.iac_det_balances;

1208: l_db IGI_IAC_TYPES.iac_det_balances;
1209: l_db_fa IGI_IAC_TYPES.fa_hist_asset_info;
1210:
1211: l_prev_db IGI_IAC_TYPES.iac_det_balances;
1212: l_remaining IGI_IAC_TYPES.iac_det_balances;
1213: l_remaining_fa IGI_IAC_TYPES.fa_hist_asset_info;
1214: l_total IGI_IAC_TYPES.iac_det_balances;
1215: l_total_fa IGI_IAC_TYPES.fa_hist_asset_info;
1216:

Line 1213: l_remaining_fa IGI_IAC_TYPES.fa_hist_asset_info;

1209: l_db_fa IGI_IAC_TYPES.fa_hist_asset_info;
1210:
1211: l_prev_db IGI_IAC_TYPES.iac_det_balances;
1212: l_remaining IGI_IAC_TYPES.iac_det_balances;
1213: l_remaining_fa IGI_IAC_TYPES.fa_hist_asset_info;
1214: l_total IGI_IAC_TYPES.iac_det_balances;
1215: l_total_fa IGI_IAC_TYPES.fa_hist_asset_info;
1216:
1217: /*

Line 1214: l_total IGI_IAC_TYPES.iac_det_balances;

1210:
1211: l_prev_db IGI_IAC_TYPES.iac_det_balances;
1212: l_remaining IGI_IAC_TYPES.iac_det_balances;
1213: l_remaining_fa IGI_IAC_TYPES.fa_hist_asset_info;
1214: l_total IGI_IAC_TYPES.iac_det_balances;
1215: l_total_fa IGI_IAC_TYPES.fa_hist_asset_info;
1216:
1217: /*
1218: Note : l_asset_level_calc is an important structure

Line 1215: l_total_fa IGI_IAC_TYPES.fa_hist_asset_info;

1211: l_prev_db IGI_IAC_TYPES.iac_det_balances;
1212: l_remaining IGI_IAC_TYPES.iac_det_balances;
1213: l_remaining_fa IGI_IAC_TYPES.fa_hist_asset_info;
1214: l_total IGI_IAC_TYPES.iac_det_balances;
1215: l_total_fa IGI_IAC_TYPES.fa_hist_asset_info;
1216:
1217: /*
1218: Note : l_asset_level_calc is an important structure
1219: -- If this is catchup, it needs to use the reval output asset information.

Line 1223: l_asset_level_calc IGI_IAC_TYPES.iac_reval_output_asset;

1219: -- If this is catchup, it needs to use the reval output asset information.
1220: -- if this is reval, it needs to use the reval mvmt asset information
1221: -- if this is reclass, it needs to use reval output asset information.
1222: */
1223: l_asset_level_calc IGI_IAC_TYPES.iac_reval_output_asset;
1224: l_factor number;
1225: l_ytd_factor number;
1226:
1227: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;

Line 1227: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;

1223: l_asset_level_calc IGI_IAC_TYPES.iac_reval_output_asset;
1224: l_factor number;
1225: l_ytd_factor number;
1226:
1227: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;
1228:
1229: /* YTD Revaluation proration */
1230: l_deprn_ytd_total number;
1231: l_remaining_deprn_ytd number;

Line 1235: l_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab;

1231: l_remaining_deprn_ytd number;
1232: l_dist_deprn_ytd number;
1233: l_iac_inactive_dists_ytd number;
1234: l_fa_inactive_dists_ytd number;
1235: l_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab;
1236: l_YTD_prorate_dists_idx binary_integer;
1237: idx_YTD binary_integer;
1238:
1239: l_path varchar2(150);

Line 1796: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params

1792: return false;
1793: end;
1794:
1795: function create_reval_rates
1796: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
1797: , fp_second_set in boolean )
1798: return boolean is
1799: l_reval_rates igi_iac_revaluation_rates%ROWTYPE;
1800: l_adjustment_id igi_iac_revaluation_rates.adjustment_id%TYPE;

Line 1801: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;

1797: , fp_second_set in boolean )
1798: return boolean is
1799: l_reval_rates igi_iac_revaluation_rates%ROWTYPE;
1800: l_adjustment_id igi_iac_revaluation_rates.adjustment_id%TYPE;
1801: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;
1802: l_path varchar2(150);
1803: begin
1804: l_path := g_path||'create_reval_rates';
1805: -- for NOCOPY

Line 1940: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params

1936: return false;
1937: end;
1938:
1939: function crud_iac_tables
1940: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
1941: , fp_second_set in boolean )
1942: return boolean is
1943:
1944: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;

Line 1944: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;

1940: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
1941: , fp_second_set in boolean )
1942: return boolean is
1943:
1944: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;
1945: l_path varchar2(150);
1946: begin
1947: l_path := g_path||'crud_iac_tables';
1948: -- for NOCOPY.

Line 2028: set status = IGI_IAC_TYPES.gc_previewed_status

2024: return boolean is
2025: pragma autonomous_transaction;
2026: begin
2027: update igi_iac_revaluations
2028: set status = IGI_IAC_TYPES.gc_previewed_status
2029: where revaluation_id = fp_reval_id
2030: ;
2031: if sql%found then
2032: do_commit;

Line 2046: set status = IGI_IAC_TYPES.gc_failedpre_status

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

Line 2066: set status = IGI_IAC_TYPES.gc_completed_status,

2062: pragma autonomous_transaction;
2063: begin
2064: if p_event_id is not null then
2065: update igi_iac_revaluations
2066: set status = IGI_IAC_TYPES.gc_completed_status,
2067: event_id = p_event_id
2068: where revaluation_id = fp_reval_id
2069: and event_id is null;
2070: else

Line 2072: set status = IGI_IAC_TYPES.gc_completed_status

2068: where revaluation_id = fp_reval_id
2069: and event_id is null;
2070: else
2071: update igi_iac_revaluations
2072: set status = IGI_IAC_TYPES.gc_completed_status
2073: where revaluation_id = fp_reval_id;
2074: end if;
2075:
2076: if sql%found then

Line 2091: set status = IGI_IAC_TYPES.gc_failedrun_status

2087: return boolean is
2088: pragma autonomous_transaction;
2089: begin
2090: update igi_iac_revaluations
2091: set status = IGI_IAC_TYPES.gc_failedrun_status
2092: where revaluation_id = fp_reval_id
2093: ;
2094: if sql%found then
2095: do_commit;

Line 2259: l_output igi_iac_types.iac_reval_output_asset;

2255: l_bal_general_fund IGI_IAC_ASSET_BALANCES.general_fund%TYPE;
2256: l_cumm_reval_factor IGI_IAC_ASSET_BALANCES.cumulative_reval_factor%TYPE;
2257: l_reval_factor IGI_IAC_ASSET_BALANCES.current_reval_factor%TYPE;
2258: l_reval_date date;
2259: l_output igi_iac_types.iac_reval_output_asset;
2260:
2261: cursor c_asset_bal is
2262: select
2263: nvl(net_book_value,0) net_book_value