APPS.IGI_IAC_REBASE_PKG dependencies on IGI_IAC_PRICE_INDEXES

Line 28: Cursor c_get_price_index(p_price_index_name igi_iac_price_indexes.price_index_name%type) is

24:
25: /* Cursors Definition */
26: /* Cursor to obtain the price_index_id for the given price_index_name */
27:
28: Cursor c_get_price_index(p_price_index_name igi_iac_price_indexes.price_index_name%type) is
29: Select price_index_id from igi_iac_price_indexes where
30: price_index_name = p_price_index_name;
31:
32:

Line 29: Select price_index_id from igi_iac_price_indexes where

25: /* Cursors Definition */
26: /* Cursor to obtain the price_index_id for the given price_index_name */
27:
28: Cursor c_get_price_index(p_price_index_name igi_iac_price_indexes.price_index_name%type) is
29: Select price_index_id from igi_iac_price_indexes where
30: price_index_name = p_price_index_name;
31:
32:
33: /* Cursor to obtain cal_price_index_link_id */

Line 35: Cursor c_get_link_id (p_price_index_id igi_iac_price_indexes.price_index_id%type) is

31:
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:

Line 89: l_price_index_id igi_iac_price_indexes.price_index_id%type;

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;
93: