APPS.IGI_IAC_RECLASS_PKG dependencies on IGI_IAC_REVAL_ASSET_RULES

Line 2960: igi_iac_reval_asset_rules rul

2956:
2957: CURSOR c_prof_occ_reval_periods is
2958: SELECT revaluation_type,revaluation_period,revaluation_factor,new_cost,current_cost
2959: FROM igi_iac_revaluations rev,
2960: igi_iac_reval_asset_rules rul
2961: WHERE rev.revaluation_id = rul.revaluation_id
2962: AND rev.book_type_code = l_asset_hdr_rec.BOOK_TYPE_CODE
2963: AND rev.book_type_code = rul.book_type_code
2964: AND rul.revaluation_type in ('O','P')

Line 3379: Debug(0,'Inserting into igi_iac_reval_asset_rules');

3375: l_login_id,
3376: l_user_id,
3377: sysdate);
3378:
3379: Debug(0,'Inserting into igi_iac_reval_asset_rules');
3380: INSERT INTO igi_iac_reval_asset_rules
3381: (revaluation_id,
3382: book_type_code,
3383: category_id,

Line 3380: INSERT INTO igi_iac_reval_asset_rules

3376: l_user_id,
3377: sysdate);
3378:
3379: Debug(0,'Inserting into igi_iac_reval_asset_rules');
3380: INSERT INTO igi_iac_reval_asset_rules
3381: (revaluation_id,
3382: book_type_code,
3383: category_id,
3384: asset_id,

Line 3442: p_string => ' Inserting into igi_iac_reval_asset_rules');

3438: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
3439:
3440: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
3441: p_full_path => l_path_name,
3442: p_string => ' Inserting into igi_iac_reval_asset_rules');
3443:
3444: l_rowid := NULL;
3445: igi_iac_reval_asset_rules_pkg.insert_row
3446: (l_rowid,

Line 3445: igi_iac_reval_asset_rules_pkg.insert_row

3441: p_full_path => l_path_name,
3442: p_string => ' Inserting into igi_iac_reval_asset_rules');
3443:
3444: l_rowid := NULL;
3445: igi_iac_reval_asset_rules_pkg.insert_row
3446: (l_rowid,
3447: l_revaluation_id,
3448: l_reval_asset_params(l_idx1).book_type_code,
3449: l_reval_asset_params(l_idx1).category_id,