APPS.IGI_IAC_REBASE_PKG dependencies on IGI_IAC_CAL_IDX_VALUES

Line 44: Select iciv.*,iciv.rowid from igi_iac_cal_idx_values iciv where

40:
41: /* Cursor to obtain the current_price_index_values for all the periods of the calendar */
42:
43: Cursor c_get_curr_price_ind_val(p_cal_price_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%type) is
44: Select iciv.*,iciv.rowid from igi_iac_cal_idx_values iciv where
45: cal_price_index_link_id = p_cal_price_link_id;
46:
47: /* Cursor to obtain current price index value for the rebasing period */
48:

Line 49: Cursor c_get_rebase_period(p_link_id igi_iac_cal_idx_values.cal_price_index_link_id%type,

45: cal_price_index_link_id = p_cal_price_link_id;
46:
47: /* Cursor to obtain current price index value for the rebasing period */
48:
49: Cursor c_get_rebase_period(p_link_id igi_iac_cal_idx_values.cal_price_index_link_id%type,
50: p_calendar igi_iac_cal_price_indexes.calendar_type%type,
51: p_period fa_calendar_periods.period_name%type) is
52: Select iciv.current_price_index_value from
53: igi_iac_cal_idx_values iciv ,fa_calendar_periods fcp

Line 53: igi_iac_cal_idx_values iciv ,fa_calendar_periods fcp

49: Cursor c_get_rebase_period(p_link_id igi_iac_cal_idx_values.cal_price_index_link_id%type,
50: p_calendar igi_iac_cal_price_indexes.calendar_type%type,
51: p_period fa_calendar_periods.period_name%type) is
52: Select iciv.current_price_index_value from
53: igi_iac_cal_idx_values iciv ,fa_calendar_periods fcp
54: where fcp.start_date = iciv.date_from and
55: fcp.end_date = iciv.date_to and
56: fcp.calendar_type = p_calendar and
57: fcp.period_name = p_period and

Line 60: /* Select iciv.current_price_index_value from igi_iac_cal_idx_values iciv , fa_calendar_periods fcp where

56: fcp.calendar_type = p_calendar and
57: fcp.period_name = p_period and
58: iciv.cal_price_index_link_id = p_link_id;
59:
60: /* Select iciv.current_price_index_value from igi_iac_cal_idx_values iciv , fa_calendar_periods fcp where
61: fcp.calendar_type = calendar and
62: fcp.period_name = period_name and
63: iciv.date_from = fcp.start_date and
64: iciv.date_to = fcp.end_date and

Line 75: Cursor c_get_period_name(l_date_from igi_iac_cal_idx_values.date_from%type,

71: where icpi.cal_price_index_link_id = p_link_id;
72:
73:
74: /* Cursor to get the period name - for display in the log file only */
75: Cursor c_get_period_name(l_date_from igi_iac_cal_idx_values.date_from%type,
76: l_date_to igi_iac_cal_idx_values.date_to%type) is
77: Select fap.period_name from fa_calendar_periods fap
78: where start_date =l_date_from and end_date = l_date_to and
79: calendar_type= calendar;

Line 76: l_date_to igi_iac_cal_idx_values.date_to%type) is

72:
73:
74: /* Cursor to get the period name - for display in the log file only */
75: Cursor c_get_period_name(l_date_from igi_iac_cal_idx_values.date_from%type,
76: l_date_to igi_iac_cal_idx_values.date_to%type) is
77: Select fap.period_name from fa_calendar_periods fap
78: where start_date =l_date_from and end_date = l_date_to and
79: calendar_type= calendar;
80:

Line 92: l_default_index_val igi_iac_cal_idx_values.current_price_index_value%type default 9999.99;

88: l_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%type;
89: l_price_index_id igi_iac_price_indexes.price_index_id%type;
90: l_calendar igi_iac_cal_price_indexes.calendar_type%type;
91: l_period fa_calendar_periods.period_name%type;
92: l_default_index_val igi_iac_cal_idx_values.current_price_index_value%type default 9999.99;
93:
94:
95:
96: /* This stores the current price index value of the period which is passed as the parameter to this concurrent process */

Line 97: l_factor_price_index igi_iac_cal_idx_values.current_price_index_value%type;

93:
94:
95:
96: /* This stores the current price index value of the period which is passed as the parameter to this concurrent process */
97: l_factor_price_index igi_iac_cal_idx_values.current_price_index_value%type;
98:
99: /* This stores the current price index value for each period */
100: l_current_price_idx_rec c_get_curr_price_ind_val%rowtype;
101: l_new_curr_price_idx_val igi_iac_cal_idx_values.current_price_index_value%type;

Line 101: l_new_curr_price_idx_val igi_iac_cal_idx_values.current_price_index_value%type;

97: l_factor_price_index igi_iac_cal_idx_values.current_price_index_value%type;
98:
99: /* This stores the current price index value for each period */
100: l_current_price_idx_rec c_get_curr_price_ind_val%rowtype;
101: l_new_curr_price_idx_val igi_iac_cal_idx_values.current_price_index_value%type;
102: l_period_name_rec c_get_period_name%rowtype;
103:
104:
105: l_cal_price_indexes_rec c_get_cal_price_indexes%rowtype;

Line 143: /* Check whether periods of the given calendar are linked to the price index in the igi_iac_cal_idx_values tables */

139: fetch c_get_link_id into l_link_id;
140: close c_get_link_id;
141:
142: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase',' link id' ||l_link_id);
143: /* Check whether periods of the given calendar are linked to the price index in the igi_iac_cal_idx_values tables */
144: open c_get_curr_price_ind_val(l_link_id);
145: fetch c_get_curr_price_ind_val into l_current_price_idx_rec;
146: IF (c_get_curr_price_ind_val%NOTFOUND) THEN
147: raise IGI_IAC_INDEX_PERIOD_NOT_FOUND;

Line 216: /* call to update the igi_iac_cal_idx_values using the TBH */

212: l_new_curr_price_idx_val := round(l_new_curr_price_idx_val,l_precision);
213:
214:
215:
216: /* call to update the igi_iac_cal_idx_values using the TBH */
217:
218: igi_iac_cal_idx_values_pkg.update_row (
219: x_mode => 'R',
220: x_rowid => l_current_price_idx_rec.rowid,

Line 218: igi_iac_cal_idx_values_pkg.update_row (

214:
215:
216: /* call to update the igi_iac_cal_idx_values using the TBH */
217:
218: igi_iac_cal_idx_values_pkg.update_row (
219: x_mode => 'R',
220: x_rowid => l_current_price_idx_rec.rowid,
221: x_cal_price_index_link_id => l_current_price_idx_rec.cal_price_index_link_id,
222: x_date_from => l_current_price_idx_rec.date_from,