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_TRANSACTION_HEADERS

Line 111: l_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

107: return boolean is
108:
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

Line 141: from igi_iac_transaction_headers

137: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+Getting the latest adjustment id');
138: begin
139: select adjustment_id
140: into l_max_adjustment_id
141: from igi_iac_transaction_headers
142: where adjustment_id_out is null
143: and book_type_code = fp_reval_params.reval_asset_params.book_type_code
144: and asset_id = fp_reval_params.reval_asset_params.asset_id
145: ;

Line 363: transaction_sub_type igi_iac_transaction_headers.TRANSACTION_SUB_TYPE%TYPE;

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:
366: cursor c_prev_bal (period_counter number) is
367: select bal.*

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 469: from igi_iac_transaction_headers

465: period_counter := fp_period_counter;
466:
467: select TRANSACTION_SUB_TYPE
468: into transaction_sub_type
469: from igi_iac_transaction_headers
470: where ADJUSTMENT_ID = fp_adjustment_id;
471:
472: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Checking if the previous adjustment was Implementation');
473:

Line 894: FROM igi_iac_transaction_headers

890: RETURN BOOLEAN IS
891:
892: CURSOR c_get_prev_adjustment IS
893: SELECT max(adjustment_id)
894: FROM igi_iac_transaction_headers
895: WHERE book_type_code = p_book_type_code
896: AND asset_id = p_asset_id
897: AND adjustment_id < p_adjustment_id
898: AND adjustment_status NOT IN ('PREVIEW','OBSOLETE');

Line 946: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

942: AND iifd.asset_id = p_asset_id
943: AND nvl(iifd.active_flag,'Y') = 'N';
944:
945: -- local variables
946: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
947: l_rowid varchar2(40);
948: l_path varchar2(150);
949: l_iac_inactive_dists_ytd number;
950: l_fa_inactive_dists_ytd number;

Line 1169: l_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

1165: and iifd.adjustment_id = cp_adjustment_id
1166: and iifd.distribution_id = cp_distribution_id;
1167:
1168: l_rowid varchar2(40);
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;

Line 1346: from igi_iac_transaction_headers

1342: if not fp_second_set then
1343: begin
1344: select nvl(max(adjustment_id),-1)
1345: into l_prev_adj_id
1346: from igi_iac_transaction_headers
1347: where asset_id = fp_reval_params.reval_asset_params.asset_id
1348: and book_type_code = fp_reval_params.reval_asset_params.book_type_code
1349: and adjustment_status in ( 'RUN','COMPLETE')
1350: and adjustment_id < l_adjustment_id

Line 1852: from igi_iac_transaction_headers

1848: function update_reval_rates ( fp_adjustment_id in number )
1849: return boolean is
1850: cursor c_txns is
1851: select asset_id, book_type_code
1852: from igi_iac_transaction_headers
1853: where adjustment_id = fp_adjustment_id
1854: ;
1855: l_path varchar2(150);
1856: begin

Line 2059: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE

2055:
2056: function allow_transfer_to_gl
2057: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2058: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE
2059: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2060: )
2061: return boolean is
2062: cursor c_check is
2063: select 'x'

Line 2082: from igi_iac_transaction_headers

2078: if l_can_update then
2079: update igi_iac_adjustments
2080: set transfer_to_gl_flag = 'Y'
2081: where adjustment_id in ( select adjustment_id
2082: from igi_iac_transaction_headers
2083: where mass_reference_id = fp_reval_id
2084: and book_type_code = fp_book_type_code
2085: and asset_id = fp_asset_id
2086: )

Line 2125: from igi_iac_transaction_headers

2121: if l_can_update then
2122: update igi_iac_adjustments
2123: set event_id = fp_event_id
2124: where adjustment_id in ( select adjustment_id
2125: from igi_iac_transaction_headers
2126: where mass_reference_id = fp_reval_id
2127: and book_type_code = fp_book_type_code
2128: )
2129: and book_type_code = fp_book_type_code

Line 2138: update igi_iac_transaction_headers

2134: else
2135: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_adjustments');
2136: end if;
2137:
2138: update igi_iac_transaction_headers
2139: set event_id = fp_event_id
2140: where mass_reference_id = fp_reval_id
2141: and book_type_code = fp_book_type_code;
2142:

Line 2144: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_transaction_headers');

2140: where mass_reference_id = fp_reval_id
2141: and book_type_code = fp_book_type_code;
2142:
2143: if sql%found then
2144: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_transaction_headers');
2145: else
2146: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_transaction_headers');
2147: end if;
2148: end if;

Line 2146: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_transaction_headers');

2142:
2143: if sql%found then
2144: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_transaction_headers');
2145: else
2146: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_transaction_headers');
2147: end if;
2148: end if;
2149: return true;
2150: end;

Line 2155: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE

2151: --Added for SLA uptake. This function will update tables with event_id.
2152:
2153: function adjustment_status_to_run
2154: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2155: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2156: )
2157: return boolean is
2158: begin
2159: update igi_iac_transaction_headers

Line 2159: update igi_iac_transaction_headers

2155: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2156: )
2157: return boolean is
2158: begin
2159: update igi_iac_transaction_headers
2160: set adjustment_status = 'RUN'
2161: where mass_Reference_id = fp_reval_id
2162: and transaction_type_code = 'REVALUATION'
2163: and asset_id = fp_asset_id

Line 2175: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE

2171: end;
2172:
2173: function adjustment_status_to_obsolete
2174: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2175: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2176: )
2177: return boolean is
2178: begin
2179: update igi_iac_transaction_headers

Line 2179: update igi_iac_transaction_headers

2175: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2176: )
2177: return boolean is
2178: begin
2179: update igi_iac_transaction_headers
2180: set adjustment_status = 'OBSOLETE'
2181: where mass_Reference_id = fp_reval_id
2182: and transaction_type_code = 'REVALUATION'
2183: and asset_id = fp_asset_id

Line 2195: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE

2191: end;
2192:
2193: function update_balances
2194: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2195: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2196: , fp_period_counter in IGI_IAC_TRANSACTION_HEADERS.PERIOD_COUNTER%TYPE
2197: , fp_book_type_code in IGI_IAC_TRANSACTION_HEADERS.BOOK_TYPE_CODE%TYPE
2198: )
2199: return boolean is

Line 2196: , fp_period_counter in IGI_IAC_TRANSACTION_HEADERS.PERIOD_COUNTER%TYPE

2192:
2193: function update_balances
2194: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2195: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2196: , fp_period_counter in IGI_IAC_TRANSACTION_HEADERS.PERIOD_COUNTER%TYPE
2197: , fp_book_type_code in IGI_IAC_TRANSACTION_HEADERS.BOOK_TYPE_CODE%TYPE
2198: )
2199: return boolean is
2200:

Line 2197: , fp_book_type_code in IGI_IAC_TRANSACTION_HEADERS.BOOK_TYPE_CODE%TYPE

2193: function update_balances
2194: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2195: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2196: , fp_period_counter in IGI_IAC_TRANSACTION_HEADERS.PERIOD_COUNTER%TYPE
2197: , fp_book_type_code in IGI_IAC_TRANSACTION_HEADERS.BOOK_TYPE_CODE%TYPE
2198: )
2199: return boolean is
2200:
2201: l_bal_net_book_value IGI_IAC_ASSET_BALANCES.NET_BOOK_VALUE%TYPE;

Line 2252: from igi_iac_transaction_headers

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
2252: from igi_iac_transaction_headers
2253: where asset_id = fp_asset_id
2254: and period_counter = fp_period_counter
2255: and transaction_type_code = 'REVALUATION'
2256: and mass_reference_id = fp_reval_id