APPS.IGI_IAC_CREATE_ASSETS dependencies on IGI_IAC_REVAL_ASSET_RULES

Line 135: p_asset_id IN igi_iac_reval_asset_rules.asset_id%TYPE,

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
139: )

Line 204: l_reval_factor igi_iac_reval_asset_rules.revaluation_factor%TYPE:= 1;

200: )
201: IS
202:
203: l_reval_period_counter NUMBER;
204: l_reval_factor igi_iac_reval_asset_rules.revaluation_factor%TYPE:= 1;
205: l_user_id NUMBER ;
206: l_login_id NUMBER := fnd_global.login_id;
207: l_reval_period_name VARCHAR(100);
208: l_lastest_closed_per_name VARCHAR2(300);

Line 221: l_new_cost igi_iac_reval_asset_rules.new_cost%TYPE;

217: l_get_counter_from_date NUMBER;
218: l_date_placed_in_service DATE;
219: l_get_closed_period igi_iac_types.prd_rec;
220: l_line varchar2(300);
221: l_new_cost igi_iac_reval_asset_rules.new_cost%TYPE;
222: l_current_cost igi_iac_reval_asset_rules.new_cost%TYPE;
223: l_cost BOOLEAN;
224: l_adjusted_cost NUMBER;
225:

Line 222: l_current_cost igi_iac_reval_asset_rules.new_cost%TYPE;

218: l_date_placed_in_service DATE;
219: l_get_closed_period igi_iac_types.prd_rec;
220: l_line varchar2(300);
221: l_new_cost igi_iac_reval_asset_rules.new_cost%TYPE;
222: l_current_cost igi_iac_reval_asset_rules.new_cost%TYPE;
223: l_cost BOOLEAN;
224: l_adjusted_cost NUMBER;
225:
226: TYPE asset_id_tbl_type IS TABLE OF FA_ADDITIONS.ASSET_ID%TYPE

Line 282: FROM igi_iac_reval_asset_rules ar

278: AND rr.reval_type = 'O'
279: AND p_allow_indexed = 'Y'
280: AND p_allow_prof = 'N')
281: AND NOT EXISTS(SELECT 'X'
282: FROM igi_iac_reval_asset_rules ar
283: WHERE a.asset_id = ar.asset_id
284: AND ar. revaluation_id = p_revaluation_id)
285: AND NOT EXISTS(SELECT 'X'
286: FROM fa_transaction_headers t,

Line 461: -- insert into igi_iac_reval_asset_rules

457: 'PERIOD_INDEX'
458: );
459: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','insert_exceptions called');
460: ELSE -- l_last_closed_index_value not equal to 9999.99
461: -- insert into igi_iac_reval_asset_rules
462: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','inserting into igi_iac_reval_asset_rules');
463: IF (r_get_categories.reval_type = 'P' ) OR
464: (r_get_categories.allow_prof_reval_flag = 'N' AND
465: r_get_categories.allow_indexed_reval_flag = 'Y' AND

Line 462: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','inserting into igi_iac_reval_asset_rules');

458: );
459: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','insert_exceptions called');
460: ELSE -- l_last_closed_index_value not equal to 9999.99
461: -- insert into igi_iac_reval_asset_rules
462: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','inserting into igi_iac_reval_asset_rules');
463: IF (r_get_categories.reval_type = 'P' ) OR
464: (r_get_categories.allow_prof_reval_flag = 'N' AND
465: r_get_categories.allow_indexed_reval_flag = 'Y' AND
466: l_reval_factor<>1) OR

Line 470: INSERT INTO igi_iac_reval_asset_rules

466: l_reval_factor<>1) OR
467: (r_get_categories.allow_prof_reval_flag = 'Y' AND
468: r_get_categories.allow_indexed_reval_flag = 'Y')THEN
469:
470: INSERT INTO igi_iac_reval_asset_rules
471: (REVALUATION_ID,
472: BOOK_TYPE_CODE,
473: CATEGORY_ID,
474: ASSET_ID,