APPS.IGI_IAC_RECLASS_PKG dependencies on IGI_IAC_REVAL_ASSET_RULES

Line 2993: igi_iac_reval_asset_rules rul

2989:
2990: CURSOR c_prof_occ_reval_periods is
2991: SELECT revaluation_type,revaluation_period,revaluation_factor,new_cost,current_cost
2992: FROM igi_iac_revaluations rev,
2993: igi_iac_reval_asset_rules rul
2994: WHERE rev.revaluation_id = rul.revaluation_id
2995: AND rev.book_type_code = l_asset_hdr_rec.BOOK_TYPE_CODE
2996: AND rev.book_type_code = rul.book_type_code
2997: AND rul.revaluation_type in ('O','P')

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

3408: l_login_id,
3409: l_user_id,
3410: sysdate);
3411:
3412: Debug(0,'Inserting into igi_iac_reval_asset_rules');
3413: INSERT INTO igi_iac_reval_asset_rules
3414: (revaluation_id,
3415: book_type_code,
3416: category_id,

Line 3413: INSERT INTO igi_iac_reval_asset_rules

3409: l_user_id,
3410: sysdate);
3411:
3412: Debug(0,'Inserting into igi_iac_reval_asset_rules');
3413: INSERT INTO igi_iac_reval_asset_rules
3414: (revaluation_id,
3415: book_type_code,
3416: category_id,
3417: asset_id,

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

3471: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
3472:
3473: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
3474: p_full_path => l_path_name,
3475: p_string => ' Inserting into igi_iac_reval_asset_rules');
3476:
3477: l_rowid := NULL;
3478: igi_iac_reval_asset_rules_pkg.insert_row
3479: (l_rowid,

Line 3478: igi_iac_reval_asset_rules_pkg.insert_row

3474: p_full_path => l_path_name,
3475: p_string => ' Inserting into igi_iac_reval_asset_rules');
3476:
3477: l_rowid := NULL;
3478: igi_iac_reval_asset_rules_pkg.insert_row
3479: (l_rowid,
3480: l_revaluation_id,
3481: l_reval_asset_params(l_idx1).book_type_code,
3482: l_reval_asset_params(l_idx1).category_id,