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_CONCURRENT dependencies on IGI_IAC_REVAL_ASSET_RULES

Line 146: from igi_iac_reval_asset_rules ac, fa_additions fadd

142: , cp_book_type_code in varchar2
143: , cp_category_id in number
144: ) is
145: select ac.asset_id, ac.revaluation_type, ac.revaluation_factor, fadd.asset_number
146: from igi_iac_reval_asset_rules ac, fa_additions fadd
147: where ac.revaluation_id = cp_revaluation_id
148: and ac.book_type_code = cp_book_type_code
149: and ac.category_id = cp_category_id
150: and ac.asset_id = fadd.asset_id

Line 165: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.ASSET_ID%TYPE

161: l_failure_ct number ;
162: l_path varchar2(100) ;
163:
164: -- bulk changes
165: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.ASSET_ID%TYPE
166: INDEX BY BINARY_INTEGER;
167: TYPE reval_type_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES. REVALUATION_TYPE%TYPE
168: INDEX BY BINARY_INTEGER;
169: TYPE reval_factor_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.REVALUATION_FACTOR%TYPE

Line 167: TYPE reval_type_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES. REVALUATION_TYPE%TYPE

163:
164: -- bulk changes
165: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.ASSET_ID%TYPE
166: INDEX BY BINARY_INTEGER;
167: TYPE reval_type_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES. REVALUATION_TYPE%TYPE
168: INDEX BY BINARY_INTEGER;
169: TYPE reval_factor_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.REVALUATION_FACTOR%TYPE
170: INDEX BY BINARY_INTEGER;
171: TYPE asset_no_tbl_type IS TABLE OF FA_ADDITIONS.ASSET_NUMBER%TYPE

Line 169: TYPE reval_factor_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.REVALUATION_FACTOR%TYPE

165: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.ASSET_ID%TYPE
166: INDEX BY BINARY_INTEGER;
167: TYPE reval_type_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES. REVALUATION_TYPE%TYPE
168: INDEX BY BINARY_INTEGER;
169: TYPE reval_factor_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.REVALUATION_FACTOR%TYPE
170: INDEX BY BINARY_INTEGER;
171: TYPE asset_no_tbl_type IS TABLE OF FA_ADDITIONS.ASSET_NUMBER%TYPE
172: INDEX BY BINARY_INTEGER;
173:

Line 414: from igi_iac_reval_asset_rules r, fa_additions fadd

410: , cp_book_type_code in varchar2
411: , cp_category_id in number
412: ) is
413: select r.asset_id, r.revaluation_type, r.revaluation_factor, fadd.asset_number
414: from igi_iac_reval_asset_rules r, fa_additions fadd
415: where r.revaluation_id = cp_revaluation_id
416: and r.book_type_code = cp_book_type_code
417: and r.category_id = cp_category_id
418: and nvl(r.selected_for_reval_flag,'X') = 'Y'

Line 439: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.ASSET_ID%TYPE

435: l_reval_exceptions IGI_IAC_TYPES.iac_reval_exceptions;
436: l_reval_exceptions_idx IGI_IAC_TYPES.iac_reval_exceptions_idx ;
437:
438: /* Bulk Fetch */
439: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.ASSET_ID%TYPE
440: INDEX BY BINARY_INTEGER;
441: TYPE reval_type_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES. REVALUATION_TYPE%TYPE
442: INDEX BY BINARY_INTEGER;
443: TYPE reval_factor_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.REVALUATION_FACTOR%TYPE

Line 441: TYPE reval_type_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES. REVALUATION_TYPE%TYPE

437:
438: /* Bulk Fetch */
439: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.ASSET_ID%TYPE
440: INDEX BY BINARY_INTEGER;
441: TYPE reval_type_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES. REVALUATION_TYPE%TYPE
442: INDEX BY BINARY_INTEGER;
443: TYPE reval_factor_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.REVALUATION_FACTOR%TYPE
444: INDEX BY BINARY_INTEGER;
445: TYPE asset_no_tbl_type IS TABLE OF FA_ADDITIONS.ASSET_NUMBER%TYPE

Line 443: TYPE reval_factor_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.REVALUATION_FACTOR%TYPE

439: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.ASSET_ID%TYPE
440: INDEX BY BINARY_INTEGER;
441: TYPE reval_type_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES. REVALUATION_TYPE%TYPE
442: INDEX BY BINARY_INTEGER;
443: TYPE reval_factor_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.REVALUATION_FACTOR%TYPE
444: INDEX BY BINARY_INTEGER;
445: TYPE asset_no_tbl_type IS TABLE OF FA_ADDITIONS.ASSET_NUMBER%TYPE
446: INDEX BY BINARY_INTEGER;
447:

Line 620: from igi_iac_reval_asset_rules

616: and transaction_type_code = 'REVALUATION'
617: and period_counter = cp_period_counter
618: and mass_reference_id = fp_revaluation_id
619: and exists ( select 'x'
620: from igi_iac_reval_asset_rules
621: where asset_id = t.asset_id
622: and book_type_code = t.book_type_code
623: and revaluation_id = t.mass_reference_id
624: and nvl(allow_prof_update,'X') = 'Y'