DBA Data[Home] [Help]

APPS.IGI_IAC_CREATE_ASSETS dependencies on IGI_IAC_COMMON_UTILS

Line 292: IF igi_iac_common_utils.get_period_info_for_date(p_book_type_code,

288: l_user_id := fnd_global.user_id;
289:
290: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','starting get assets');
291: -- get the period counter from the :books.revaluation_date
292: IF igi_iac_common_utils.get_period_info_for_date(p_book_type_code,
293: p_revaluation_date,
294: l_get_record_from_date) THEN
295:
296: l_get_counter_from_date:=l_get_record_from_date.period_counter;

Line 337: IF IGI_IAC_COMMON_UTILS.Get_Period_Info_For_Counter(p_book_type_code,

333: INTO l_reval_period_counter;
334: IF c_get_last_reval_period_count%FOUND THEN
335: CLOSE c_get_last_reval_period_count;
336: -- then get the period_name using get_period_for_counter
337: IF IGI_IAC_COMMON_UTILS.Get_Period_Info_For_Counter(p_book_type_code,
338: l_reval_period_counter,
339: l_get_reval_period) THEN
340: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets',
341: 'asset getting price index for last reval period');

Line 344: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,

340: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets',
341: 'asset getting price index for last reval period');
342: l_reval_period_name := l_get_reval_period.period_name;
343: -- then get the price index using get_price_index_value
344: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,
345: l_asset_id(l_loop_count),
346: l_reval_period_name,
347: l_reval_price_inxed_value)
348: THEN null;

Line 361: IF IGI_IAC_COMMON_UTILS.Get_Period_Info_For_Date(p_book_type_code,

357: INTO l_date_placed_in_service;
358: IF c_get_date_place_in_service%FOUND THEN
359: CLOSE c_get_date_place_in_service;
360: -- get the period_name using get_period_for_date
361: IF IGI_IAC_COMMON_UTILS.Get_Period_Info_For_Date(p_book_type_code,
362: l_date_placed_in_service,
363: l_get_reval_period) THEN
364: l_reval_period_name := l_get_reval_period.period_name;
365: -- then get the price index using get_price_index_value

Line 368: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,

364: l_reval_period_name := l_get_reval_period.period_name;
365: -- then get the price index using get_price_index_value
366: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get index for date placed
367: in service');
368: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,
369: l_asset_id(l_loop_count),
370: l_reval_period_name,
371: l_reval_price_inxed_value)
372: THEN null;

Line 382: IF IGI_IAC_COMMON_UTILS.Get_Open_Period_Info(p_book_type_code,

378: END IF; -- fetch c_get_laset_reval_period_count
379: -- now get the latest closed period number
380: -- first get the open period
381: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get last closed period');
382: IF IGI_IAC_COMMON_UTILS.Get_Open_Period_Info(p_book_type_code,
383: l_get_open_period)THEN
384: null;
385: END IF;
386: -- Then get the period_name for the closed period

Line 387: IF IGI_IAC_COMMON_UTILS.Get_Period_Info_For_Counter(p_book_type_code,

383: l_get_open_period)THEN
384: null;
385: END IF;
386: -- Then get the period_name for the closed period
387: IF IGI_IAC_COMMON_UTILS.Get_Period_Info_For_Counter(p_book_type_code,
388: l_get_open_period.period_counter-1,
389: l_get_closed_period) THEN
390: l_lastest_closed_per_name:=l_get_closed_period.period_name;
391: END IF;

Line 394: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,

390: l_lastest_closed_per_name:=l_get_closed_period.period_name;
391: END IF;
392: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get price index for last closed period');
393: -- then get the proce index for the latest closed period using coomon utils
394: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,
395: l_asset_id(l_loop_count),
396: l_lastest_closed_per_name,
397: l_last_closed_index_value) THEN
398: -- calculate the reval_rate by dividing the last_closed_index_value

Line 413: l_cost := igi_iac_common_utils.iac_round(l_new_cost,p_book_type_code) ;

409: -- Now calculate the new cost
410: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','calculate new cost');
411: l_new_cost:=((l_cost_tbl(l_loop_count)+l_adjusted_cost)*l_reval_factor);
412: -- Now round hte new cost
413: l_cost := igi_iac_common_utils.iac_round(l_new_cost,p_book_type_code) ;
414: ELSE -- reval_type = 'P'
415: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','getting adjusted cost for P asset');
416: get_adjusted_cost(l_asset_id(l_loop_count),
417: l_get_counter_from_date,