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 134: l_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

130: return boolean is
131:
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

Line 164: from igi_iac_transaction_headers

160: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+Getting the latest adjustment id');
161: begin
162: select adjustment_id
163: into l_max_adjustment_id
164: from igi_iac_transaction_headers
165: where adjustment_id_out is null
166: and book_type_code = fp_reval_params.reval_asset_params.book_type_code
167: and asset_id = fp_reval_params.reval_asset_params.asset_id
168: ;

Line 386: transaction_sub_type igi_iac_transaction_headers.TRANSACTION_SUB_TYPE%TYPE;

382: return boolean is
383:
384: l_fp_det_balances igi_iac_det_balances%ROWTYPE;
385: l_success boolean ;
386: transaction_sub_type igi_iac_transaction_headers.TRANSACTION_SUB_TYPE%TYPE;
387: period_counter number;
388:
389: cursor c_prev_bal (period_counter number) is
390: select bal.*

Line 404: FROM igi_iac_transaction_headers th, igi_iac_det_balances db

400: SELECT 1
401: FROM dual
402: WHERE EXISTS(
403: SELECT 1
404: FROM igi_iac_transaction_headers th, igi_iac_det_balances db
405: WHERE th.transaction_sub_type = 'IMPLEMENTATION'
406: AND th.adjustment_id = db.adjustment_id
407: AND db.book_type_code = p_book_type_code
408: AND db.period_counter = p_period_counter

Line 492: from igi_iac_transaction_headers

488: period_counter := fp_period_counter;
489:
490: select TRANSACTION_SUB_TYPE
491: into transaction_sub_type
492: from igi_iac_transaction_headers
493: where ADJUSTMENT_ID = fp_adjustment_id;
494:
495: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Checking if the previous adjustment was Implementation');
496:

Line 917: FROM igi_iac_transaction_headers

913: RETURN BOOLEAN IS
914:
915: CURSOR c_get_prev_adjustment IS
916: SELECT max(adjustment_id)
917: FROM igi_iac_transaction_headers
918: WHERE book_type_code = p_book_type_code
919: AND asset_id = p_asset_id
920: AND adjustment_id < p_adjustment_id
921: AND adjustment_status NOT IN ('PREVIEW','OBSOLETE');

Line 969: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

965: AND iifd.asset_id = p_asset_id
966: AND nvl(iifd.active_flag,'Y') = 'N';
967:
968: -- local variables
969: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
970: l_rowid varchar2(40);
971: l_path varchar2(150);
972: l_iac_inactive_dists_ytd number;
973: l_fa_inactive_dists_ytd number;

Line 1185: l_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

1181: and iifd.adjustment_id = cp_adjustment_id
1182: and iifd.distribution_id = cp_distribution_id;
1183:
1184: l_rowid varchar2(40);
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;

Line 1362: from igi_iac_transaction_headers

1358: if not fp_second_set then
1359: begin
1360: select nvl(max(adjustment_id),-1)
1361: into l_prev_adj_id
1362: from igi_iac_transaction_headers
1363: where asset_id = fp_reval_params.reval_asset_params.asset_id
1364: and book_type_code = fp_reval_params.reval_asset_params.book_type_code
1365: and adjustment_status in ( 'RUN','COMPLETE')
1366: and adjustment_id < l_adjustment_id

Line 1899: from igi_iac_transaction_headers

1895: function update_reval_rates ( fp_adjustment_id in number )
1896: return boolean is
1897: cursor c_txns is
1898: select asset_id, book_type_code
1899: from igi_iac_transaction_headers
1900: where adjustment_id = fp_adjustment_id
1901: ;
1902: l_path varchar2(150);
1903: begin

Line 2106: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE

2102:
2103: function allow_transfer_to_gl
2104: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2105: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE
2106: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2107: )
2108: return boolean is
2109: cursor c_check is
2110: select 'x'

Line 2129: from igi_iac_transaction_headers

2125: if l_can_update then
2126: update igi_iac_adjustments
2127: set transfer_to_gl_flag = 'Y'
2128: where adjustment_id in ( select adjustment_id
2129: from igi_iac_transaction_headers
2130: where mass_reference_id = fp_reval_id
2131: and book_type_code = fp_book_type_code
2132: and asset_id = fp_asset_id
2133: )

Line 2172: from igi_iac_transaction_headers

2168: if l_can_update then
2169: update igi_iac_adjustments
2170: set event_id = fp_event_id
2171: where adjustment_id in ( select adjustment_id
2172: from igi_iac_transaction_headers
2173: where mass_reference_id = fp_reval_id
2174: and book_type_code = fp_book_type_code
2175: )
2176: and book_type_code = fp_book_type_code

Line 2185: update igi_iac_transaction_headers

2181: else
2182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_adjustments');
2183: end if;
2184:
2185: update igi_iac_transaction_headers
2186: set event_id = fp_event_id
2187: where mass_reference_id = fp_reval_id
2188: and book_type_code = fp_book_type_code;
2189:

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

2187: where mass_reference_id = fp_reval_id
2188: and book_type_code = fp_book_type_code;
2189:
2190: if sql%found then
2191: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_transaction_headers');
2192: else
2193: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_transaction_headers');
2194: end if;
2195: end if;

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

2189:
2190: if sql%found then
2191: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_transaction_headers');
2192: else
2193: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_transaction_headers');
2194: end if;
2195: end if;
2196: return true;
2197: end;

Line 2202: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE

2198: --Added for SLA uptake. This function will update tables with event_id.
2199:
2200: function adjustment_status_to_run
2201: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2202: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2203: )
2204: return boolean is
2205: begin
2206: update igi_iac_transaction_headers

Line 2206: update igi_iac_transaction_headers

2202: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2203: )
2204: return boolean is
2205: begin
2206: update igi_iac_transaction_headers
2207: set adjustment_status = 'RUN'
2208: where mass_Reference_id = fp_reval_id
2209: and transaction_type_code = 'REVALUATION'
2210: and asset_id = fp_asset_id

Line 2222: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE

2218: end;
2219:
2220: function adjustment_status_to_obsolete
2221: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2222: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2223: )
2224: return boolean is
2225: begin
2226: update igi_iac_transaction_headers

Line 2226: update igi_iac_transaction_headers

2222: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2223: )
2224: return boolean is
2225: begin
2226: update igi_iac_transaction_headers
2227: set adjustment_status = 'OBSOLETE'
2228: where mass_Reference_id = fp_reval_id
2229: and transaction_type_code = 'REVALUATION'
2230: and asset_id = fp_asset_id

Line 2242: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE

2238: end;
2239:
2240: function update_balances
2241: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2242: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2243: , fp_period_counter in IGI_IAC_TRANSACTION_HEADERS.PERIOD_COUNTER%TYPE
2244: , fp_book_type_code in IGI_IAC_TRANSACTION_HEADERS.BOOK_TYPE_CODE%TYPE
2245: )
2246: return boolean is

Line 2243: , fp_period_counter in IGI_IAC_TRANSACTION_HEADERS.PERIOD_COUNTER%TYPE

2239:
2240: function update_balances
2241: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2242: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2243: , fp_period_counter in IGI_IAC_TRANSACTION_HEADERS.PERIOD_COUNTER%TYPE
2244: , fp_book_type_code in IGI_IAC_TRANSACTION_HEADERS.BOOK_TYPE_CODE%TYPE
2245: )
2246: return boolean is
2247:

Line 2244: , fp_book_type_code in IGI_IAC_TRANSACTION_HEADERS.BOOK_TYPE_CODE%TYPE

2240: function update_balances
2241: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2242: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2243: , fp_period_counter in IGI_IAC_TRANSACTION_HEADERS.PERIOD_COUNTER%TYPE
2244: , fp_book_type_code in IGI_IAC_TRANSACTION_HEADERS.BOOK_TYPE_CODE%TYPE
2245: )
2246: return boolean is
2247:
2248: l_bal_net_book_value IGI_IAC_ASSET_BALANCES.NET_BOOK_VALUE%TYPE;

Line 2299: from igi_iac_transaction_headers

2295: where asset_id = fp_asset_id
2296: and book_type_code = fp_book_type_code
2297: and period_counter = fp_period_counter
2298: and adjustment_id in ( select adjustment_id
2299: from igi_iac_transaction_headers
2300: where asset_id = fp_asset_id
2301: and period_counter = fp_period_counter
2302: and transaction_type_code = 'REVALUATION'
2303: and mass_reference_id = fp_reval_id