APPS.IGI_IAC_DEPRN_PKG dependencies on IGI_IAC_CAL_IDX_VALUES

Line 45: FROM igi_iac_cal_idx_values

41:
42: /* Cursor for getting the last period from Inflation Accounting */
43: CURSOR c_iac_max_date(p_cal_price_index_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%TYPE) IS
44: SELECT max(date_to)
45: FROM igi_iac_cal_idx_values
46: WHERE cal_price_index_link_id = p_cal_price_index_link_id;
47:
48: /* Cursor for getting the Price Index value defined for the last period defined in IAC */
49: CURSOR c_current_price_index(p_max_date_to date ,

Line 52: FROM igi_iac_cal_idx_values

48: /* Cursor for getting the Price Index value defined for the last period defined in IAC */
49: CURSOR c_current_price_index(p_max_date_to date ,
50: p_cal_price_index_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%TYPE) IS
51: SELECT current_price_index_value
52: FROM igi_iac_cal_idx_values
53: WHERE trunc(date_to) = trunc(p_max_date_to)
54: AND cal_price_index_link_id = p_cal_price_index_link_id ;
55:
56: /* Cursor to get all periods from FA which are greater than the last period defined in IAC */

Line 70: l_curr_price_idx_value igi_iac_cal_idx_values.current_price_index_value%TYPE;

66:
67: l_fa_max_date date;
68: l_iac_max_date date;
69: l_rowid varchar2(25);
70: l_curr_price_idx_value igi_iac_cal_idx_values.current_price_index_value%TYPE;
71: l_path VARCHAR2(100);
72: BEGIN
73: l_path := g_path||'Synchronize_Calendars';
74: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Start of Synchronizing IAC Calendars');

Line 100: igi_iac_cal_idx_values_pkg.insert_row(

96: l_get_cal_price_indexes.cal_price_index_link_id) LOOP
97:
98: l_rowid := NULL;
99:
100: igi_iac_cal_idx_values_pkg.insert_row(
101: X_rowid => l_rowid ,
102: X_cal_price_index_link_id => l_get_cal_price_indexes.cal_price_index_link_id,
103: X_date_from => l_get_fa_period.start_date ,
104: X_date_to => l_get_fa_period.end_date ,