[Home] [Help]
130:
131: THEN null;
132: END;
133:
134: PROCEDURE insert_exceptions(p_revaluation_id IN igi_iac_revaluations.revaluation_id%TYPE,
135: p_asset_id IN igi_iac_reval_asset_rules.asset_id%TYPE,
136: p_category_id IN igi_iac_reval_categories.category_id%TYPE,
137: p_book_type_code IN igi_iac_revaluations.book_type_code%TYPE,
138: p_exception_type IN VARCHAR2
133:
134: PROCEDURE insert_exceptions(p_revaluation_id IN igi_iac_revaluations.revaluation_id%TYPE,
135: p_asset_id IN igi_iac_reval_asset_rules.asset_id%TYPE,
136: p_category_id IN igi_iac_reval_categories.category_id%TYPE,
137: p_book_type_code IN igi_iac_revaluations.book_type_code%TYPE,
138: p_exception_type IN VARCHAR2
139: )
140:
141: IS
211: l_quiet BOOLEAN;
212: l_period_counter NUMBER;
213: l_get_open_period igi_iac_types.prd_rec;
214: l_get_reval_period igi_iac_types.prd_rec;
215: l_book igi_iac_revaluations.book_type_code%TYPE;
216: l_get_record_from_date igi_iac_types.prd_rec;
217: l_get_counter_from_date NUMBER;
218: l_date_placed_in_service DATE;
219: l_get_closed_period igi_iac_types.prd_rec;
251: OR NVL(cb.allow_prof_reval_flag, 'N')='Y');
252:
253: CURSOR c_get_assets(p_cat_id IN fa_additions.asset_category_id%TYPE,
254: p_period_counter IN NUMBER,
255: p_revaluation_id IN igi_iac_revaluations.revaluation_id%TYPE,
256: p_allow_indexed IN igi_iac_category_books.allow_indexed_reval_flag%TYPE,
257: p_allow_prof IN igi_iac_category_books.allow_prof_reval_flag%TYPE
258: ) IS
259: SELECT a.asset_id,
267: AND b.transaction_header_id_out IS NULL
268: AND b.date_placed_in_service <= p_revaluation_date
269: AND NOT EXISTS(SELECT 'X'
270: FROM igi_iac_revaluation_rates rr,
271: igi_iac_revaluations r
272: WHERE r.revaluation_id = rr.revaluation_id
273: AND rr.asset_id = a.asset_id
274: AND r.book_type_code = rr.book_type_code
275: AND r.book_type_code = p_book_type_code