APPS.IGI_IAC_REBASE_PKG dependencies on IGI_IAC_CAL_PRICE_INDEXES

Line 36: Select cal_price_index_link_id from igi_iac_cal_price_indexes where

32:
33: /* Cursor to obtain cal_price_index_link_id */
34:
35: Cursor c_get_link_id (p_price_index_id igi_iac_price_indexes.price_index_id%type) is
36: Select cal_price_index_link_id from igi_iac_cal_price_indexes where
37: calendar_type = calendar and
38: price_index_id = p_price_index_id;
39:
40:

Line 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

39:
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 */

Line 50: p_calendar igi_iac_cal_price_indexes.calendar_type%type,

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
54: where fcp.start_date = iciv.date_from and

Line 67: /* Cursor for getting the rows in IGI_IAC_CAL_PRICE_INDEXES for updation using TBH */

63: iciv.date_from = fcp.start_date and
64: iciv.date_to = fcp.end_date and
65: cal_price_index_link_id = p_link_id;*/
66:
67: /* Cursor for getting the rows in IGI_IAC_CAL_PRICE_INDEXES for updation using TBH */
68:
69: Cursor c_get_cal_price_indexes(p_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%type) is
70: Select icpi.rowid , icpi.* from igi_iac_cal_price_indexes icpi
71: where icpi.cal_price_index_link_id = p_link_id;

Line 69: Cursor c_get_cal_price_indexes(p_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%type) is

65: cal_price_index_link_id = p_link_id;*/
66:
67: /* Cursor for getting the rows in IGI_IAC_CAL_PRICE_INDEXES for updation using TBH */
68:
69: Cursor c_get_cal_price_indexes(p_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%type) is
70: Select icpi.rowid , icpi.* from igi_iac_cal_price_indexes icpi
71: where icpi.cal_price_index_link_id = p_link_id;
72:
73:

Line 70: Select icpi.rowid , icpi.* from igi_iac_cal_price_indexes icpi

66:
67: /* Cursor for getting the rows in IGI_IAC_CAL_PRICE_INDEXES for updation using TBH */
68:
69: Cursor c_get_cal_price_indexes(p_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%type) is
70: Select icpi.rowid , icpi.* from igi_iac_cal_price_indexes icpi
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 */

Line 88: l_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%type;

84: from fnd_currencies curr, gl_sets_of_books sob
85: where curr.currency_code = sob.currency_code
86: and sob.set_of_books_id = p_sob_id;
87:
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;

Line 90: l_calendar igi_iac_cal_price_indexes.calendar_type%type;

86: and sob.set_of_books_id = p_sob_id;
87:
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:

Line 236: /*Update the igi_iac_cal_price_indexes table to record the rebase period name and price_index details */

232: open c_get_cal_price_indexes(l_link_id);
233: fetch c_get_cal_price_indexes into l_cal_price_indexes_rec;
234: close c_get_cal_price_indexes;
235:
236: /*Update the igi_iac_cal_price_indexes table to record the rebase period name and price_index details */
237: igi_iac_cal_price_indexes_pkg.update_row (
238: x_mode => 'R',
239: x_rowid => l_cal_price_indexes_rec.rowid,
240: x_cal_price_index_link_id => l_cal_price_indexes_rec.cal_price_index_link_id,

Line 237: igi_iac_cal_price_indexes_pkg.update_row (

233: fetch c_get_cal_price_indexes into l_cal_price_indexes_rec;
234: close c_get_cal_price_indexes;
235:
236: /*Update the igi_iac_cal_price_indexes table to record the rebase period name and price_index details */
237: igi_iac_cal_price_indexes_pkg.update_row (
238: x_mode => 'R',
239: x_rowid => l_cal_price_indexes_rec.rowid,
240: x_cal_price_index_link_id => l_cal_price_indexes_rec.cal_price_index_link_id,
241: x_price_index_id => l_cal_price_indexes_rec.price_index_id,