APPS.IGI_IAC_RECLASS_PKG dependencies on IGI_IAC_REVALUATIONS

Line 2992: FROM igi_iac_revaluations rev,

2988: WHERE book_type_code = p_book_type_code;
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

Line 3035: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;

3031: l_fa_asset_info igi_iac_types.iac_reval_fa_asset_info_tab;
3032: l_reval_params igi_iac_types.iac_reval_params;
3033: l_reval_asset igi_iac_types.iac_reval_input_asset;
3034: l_reval_asset_out igi_iac_types.iac_reval_output_asset;
3035: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;
3036: l_user_id NUMBER;
3037: l_login_id NUMBER;
3038: l_current_reval_factor igi_iac_asset_balances.current_reval_factor%TYPE;
3039: l_cumulative_reval_factor igi_iac_asset_balances.cumulative_reval_factor%TYPE;

Line 3376: /* SELECT igi_iac_revaluations_s.nextval

3372: END IF;
3373:
3374: IF (l_idx2 = l_idx1) THEN
3375: /* Last revaluation - Insert records into revaluation tables*/
3376: /* SELECT igi_iac_revaluations_s.nextval
3377: INTO l_revaluation_id
3378: FROM DUAL;
3379: Debug(0,'Last Revaluation - Inseting into igi_iac_revaluations');
3380: Debug(0,'Revaluation Id :'||to_char(l_revaluation_id));

Line 3379: Debug(0,'Last Revaluation - Inseting into igi_iac_revaluations');

3375: /* Last revaluation - Insert records into revaluation tables*/
3376: /* SELECT igi_iac_revaluations_s.nextval
3377: INTO l_revaluation_id
3378: FROM DUAL;
3379: Debug(0,'Last Revaluation - Inseting into igi_iac_revaluations');
3380: Debug(0,'Revaluation Id :'||to_char(l_revaluation_id));
3381:
3382:
3383:

Line 3384: INSERT INTO igi_iac_revaluations

3380: Debug(0,'Revaluation Id :'||to_char(l_revaluation_id));
3381:
3382:
3383:
3384: INSERT INTO igi_iac_revaluations
3385: (revaluation_id,
3386: book_type_code,
3387: revaluation_date,
3388: revaluation_period,

Line 3451: p_string => ' Last Revaluation - Inserting into igi_iac_revaluations');

3447: /* Last revaluation - Insert records into revaluation tables*/
3448:
3449: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
3450: p_full_path => l_path_name,
3451: p_string => ' Last Revaluation - Inserting into igi_iac_revaluations');
3452:
3453:
3454: l_rowid := NULL;
3455: l_revaluation_id := NULL;

Line 3457: igi_iac_revaluations_pkg.insert_row

3453:
3454: l_rowid := NULL;
3455: l_revaluation_id := NULL;
3456:
3457: igi_iac_revaluations_pkg.insert_row
3458: (l_rowid,
3459: l_revaluation_id,
3460: p_book_type_code,
3461: sysdate,