APPS.IGI_IAC_CREATE_ASSETS dependencies on IGI_IAC_REVALUATIONS

Line 111: PROCEDURE insert_exceptions(p_revaluation_id IN igi_iac_revaluations.revaluation_id%TYPE,

107:
108: THEN null;
109: END;
110:
111: PROCEDURE insert_exceptions(p_revaluation_id IN igi_iac_revaluations.revaluation_id%TYPE,
112: p_asset_id IN igi_iac_reval_asset_rules.asset_id%TYPE,
113: p_category_id IN igi_iac_reval_categories.category_id%TYPE,
114: p_book_type_code IN igi_iac_revaluations.book_type_code%TYPE,
115: p_exception_type IN VARCHAR2

Line 114: p_book_type_code IN igi_iac_revaluations.book_type_code%TYPE,

110:
111: PROCEDURE insert_exceptions(p_revaluation_id IN igi_iac_revaluations.revaluation_id%TYPE,
112: p_asset_id IN igi_iac_reval_asset_rules.asset_id%TYPE,
113: p_category_id IN igi_iac_reval_categories.category_id%TYPE,
114: p_book_type_code IN igi_iac_revaluations.book_type_code%TYPE,
115: p_exception_type IN VARCHAR2
116: )
117:
118: IS

Line 192: l_book igi_iac_revaluations.book_type_code%TYPE;

188: l_quiet BOOLEAN;
189: l_period_counter NUMBER;
190: l_get_open_period igi_iac_types.prd_rec;
191: l_get_reval_period igi_iac_types.prd_rec;
192: l_book igi_iac_revaluations.book_type_code%TYPE;
193: l_get_record_from_date igi_iac_types.prd_rec;
194: l_get_counter_from_date NUMBER;
195: l_date_placed_in_service DATE;
196: l_get_closed_period igi_iac_types.prd_rec;

Line 232: p_revaluation_id IN igi_iac_revaluations.revaluation_id%TYPE,

228: OR NVL(cb.allow_prof_reval_flag, 'N')='Y');
229:
230: CURSOR c_get_assets(p_cat_id IN fa_additions.asset_category_id%TYPE,
231: p_period_counter IN NUMBER,
232: p_revaluation_id IN igi_iac_revaluations.revaluation_id%TYPE,
233: p_allow_indexed IN igi_iac_category_books.allow_indexed_reval_flag%TYPE,
234: p_allow_prof IN igi_iac_category_books.allow_prof_reval_flag%TYPE
235: ) IS
236: SELECT a.asset_id,

Line 248: igi_iac_revaluations r

244: AND b.transaction_header_id_out IS NULL
245: AND b.date_placed_in_service <= p_revaluation_date
246: AND NOT EXISTS(SELECT 'X'
247: FROM igi_iac_revaluation_rates rr,
248: igi_iac_revaluations r
249: WHERE r.revaluation_id = rr.revaluation_id
250: AND rr.asset_id = a.asset_id
251: AND r.book_type_code = rr.book_type_code
252: AND r.book_type_code = p_book_type_code