APPS.IGI_IAC_RECLASS_PKG dependencies on IGI_IAC_REVALUATIONS

Line 2959: FROM igi_iac_revaluations rev,

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

Line 3002: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;

2998: l_fa_asset_info igi_iac_types.iac_reval_fa_asset_info_tab;
2999: l_reval_params igi_iac_types.iac_reval_params;
3000: l_reval_asset igi_iac_types.iac_reval_input_asset;
3001: l_reval_asset_out igi_iac_types.iac_reval_output_asset;
3002: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;
3003: l_user_id NUMBER;
3004: l_login_id NUMBER;
3005: l_current_reval_factor igi_iac_asset_balances.current_reval_factor%TYPE;
3006: l_cumulative_reval_factor igi_iac_asset_balances.cumulative_reval_factor%TYPE;

Line 3343: /* SELECT igi_iac_revaluations_s.nextval

3339: END IF;
3340:
3341: IF (l_idx2 = l_idx1) THEN
3342: /* Last revaluation - Insert records into revaluation tables*/
3343: /* SELECT igi_iac_revaluations_s.nextval
3344: INTO l_revaluation_id
3345: FROM DUAL;
3346: Debug(0,'Last Revaluation - Inseting into igi_iac_revaluations');
3347: Debug(0,'Revaluation Id :'||to_char(l_revaluation_id));

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

3342: /* Last revaluation - Insert records into revaluation tables*/
3343: /* SELECT igi_iac_revaluations_s.nextval
3344: INTO l_revaluation_id
3345: FROM DUAL;
3346: Debug(0,'Last Revaluation - Inseting into igi_iac_revaluations');
3347: Debug(0,'Revaluation Id :'||to_char(l_revaluation_id));
3348:
3349:
3350:

Line 3351: INSERT INTO igi_iac_revaluations

3347: Debug(0,'Revaluation Id :'||to_char(l_revaluation_id));
3348:
3349:
3350:
3351: INSERT INTO igi_iac_revaluations
3352: (revaluation_id,
3353: book_type_code,
3354: revaluation_date,
3355: revaluation_period,

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

3414: /* Last revaluation - Insert records into revaluation tables*/
3415:
3416: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
3417: p_full_path => l_path_name,
3418: p_string => ' Last Revaluation - Inserting into igi_iac_revaluations');
3419:
3420:
3421: l_rowid := NULL;
3422: l_revaluation_id := NULL;

Line 3424: igi_iac_revaluations_pkg.insert_row

3420:
3421: l_rowid := NULL;
3422: l_revaluation_id := NULL;
3423:
3424: igi_iac_revaluations_pkg.insert_row
3425: (l_rowid,
3426: l_revaluation_id,
3427: p_book_type_code,
3428: sysdate,