DBA Data[Home] [Help]

APPS.IGI_IAC_CREATE_ASSETS dependencies on IGI_IAC_COMMON_UTILS

Line 23: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)

19: l_amount_old number := p_amount;
20: --l_path varchar2(150) := g_path||'do_round';
21: begin
22: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
23: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
24: THEN
25: p_amount := l_amount;
26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

Line 26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');

22: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
23: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
24: THEN
25: p_amount := l_amount;
26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
28: ELSE
29: p_amount := round( l_amount, 2);
30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');

Line 30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');

26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
28: ELSE
29: p_amount := round( l_amount, 2);
30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
31: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
32: END IF;
33: exception when others then
34: p_amount := l_amount_old;

Line 315: IF igi_iac_common_utils.get_period_info_for_date(p_book_type_code,

311: l_user_id := fnd_global.user_id;
312:
313: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','starting get assets');
314: -- get the period counter from the :books.revaluation_date
315: IF igi_iac_common_utils.get_period_info_for_date(p_book_type_code,
316: p_revaluation_date,
317: l_get_record_from_date) THEN
318:
319: l_get_counter_from_date:=l_get_record_from_date.period_counter;

Line 360: IF IGI_IAC_COMMON_UTILS.Get_Period_Info_For_Counter(p_book_type_code,

356: INTO l_reval_period_counter;
357: IF c_get_last_reval_period_count%FOUND THEN
358: CLOSE c_get_last_reval_period_count;
359: -- then get the period_name using get_period_for_counter
360: IF IGI_IAC_COMMON_UTILS.Get_Period_Info_For_Counter(p_book_type_code,
361: l_reval_period_counter,
362: l_get_reval_period) THEN
363: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets',
364: 'asset getting price index for last reval period');

Line 367: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,

363: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets',
364: 'asset getting price index for last reval period');
365: l_reval_period_name := l_get_reval_period.period_name;
366: -- then get the price index using get_price_index_value
367: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,
368: l_asset_id(l_loop_count),
369: l_reval_period_name,
370: l_reval_price_inxed_value)
371: THEN null;

Line 384: IF IGI_IAC_COMMON_UTILS.Get_Period_Info_For_Date(p_book_type_code,

380: INTO l_date_placed_in_service;
381: IF c_get_date_place_in_service%FOUND THEN
382: CLOSE c_get_date_place_in_service;
383: -- get the period_name using get_period_for_date
384: IF IGI_IAC_COMMON_UTILS.Get_Period_Info_For_Date(p_book_type_code,
385: l_date_placed_in_service,
386: l_get_reval_period) THEN
387: l_reval_period_name := l_get_reval_period.period_name;
388: -- then get the price index using get_price_index_value

Line 391: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,

387: l_reval_period_name := l_get_reval_period.period_name;
388: -- then get the price index using get_price_index_value
389: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get index for date placed
390: in service');
391: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,
392: l_asset_id(l_loop_count),
393: l_reval_period_name,
394: l_reval_price_inxed_value)
395: THEN null;

Line 405: IF IGI_IAC_COMMON_UTILS.Get_Open_Period_Info(p_book_type_code,

401: END IF; -- fetch c_get_laset_reval_period_count
402: -- now get the latest closed period number
403: -- first get the open period
404: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get last closed period');
405: IF IGI_IAC_COMMON_UTILS.Get_Open_Period_Info(p_book_type_code,
406: l_get_open_period)THEN
407: null;
408: END IF;
409: -- Then get the period_name for the closed period

Line 410: IF IGI_IAC_COMMON_UTILS.Get_Period_Info_For_Counter(p_book_type_code,

406: l_get_open_period)THEN
407: null;
408: END IF;
409: -- Then get the period_name for the closed period
410: IF IGI_IAC_COMMON_UTILS.Get_Period_Info_For_Counter(p_book_type_code,
411: l_get_open_period.period_counter-1,
412: l_get_closed_period) THEN
413: l_lastest_closed_per_name:=l_get_closed_period.period_name;
414: END IF;

Line 417: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,

413: l_lastest_closed_per_name:=l_get_closed_period.period_name;
414: END IF;
415: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get price index for last closed period');
416: -- then get the proce index for the latest closed period using coomon utils
417: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,
418: l_asset_id(l_loop_count),
419: l_lastest_closed_per_name,
420: l_last_closed_index_value) THEN
421: -- calculate the reval_rate by dividing the last_closed_index_value

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

433: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','calculate new cost');
434: l_new_cost:=((l_cost_tbl(l_loop_count)+l_adjusted_cost)*l_reval_factor);
435: do_round(l_new_cost,p_book_type_code);
436: -- Now round hte new cost
437: l_cost := igi_iac_common_utils.iac_round(l_new_cost,p_book_type_code) ;
438: ELSE -- reval_type = 'P'
439: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','getting adjusted cost for P asset');
440: get_adjusted_cost(l_asset_id(l_loop_count),
441: l_get_counter_from_date,