APPS.IGIRRGPP dependencies on IGI_RPI_UPDATE_LINES

Line 149: lv_updated_price igi_rpi_update_lines.updated_price%TYPE;

145: AND set_of_books_id =
146: ( select set_of_books_id from ar_system_parameters )
147: ;
148:
149: lv_updated_price igi_rpi_update_lines.updated_price%TYPE;
150: lv_select_flag igi_rpi_update_lines.select_flag%TYPE;
151: lv_mesg VARCHAR2(200);
152: BEGIN
153:

Line 150: lv_select_flag igi_rpi_update_lines.select_flag%TYPE;

146: ( select set_of_books_id from ar_system_parameters )
147: ;
148:
149: lv_updated_price igi_rpi_update_lines.updated_price%TYPE;
150: lv_select_flag igi_rpi_update_lines.select_flag%TYPE;
151: lv_mesg VARCHAR2(200);
152: BEGIN
153:
154: /*

Line 209: insert into igi_rpi_update_lines

205: END IF;
206:
207: IF ((lv_updated_price is not NULL) AND (lv_updated_price >= 0)) THEN
208: /* Added ORG_ID in the insert statement*/
209: insert into igi_rpi_update_lines
210: ( run_id, item_id, price, effective_date,
211: revised_price, revised_effective_date,
212: updated_price, select_flag,
213: creation_date, created_by, last_update_date,

Line 271: insert into igi_rpi_update_lines

267: IF ((lv_updated_price is not NULL) AND (lv_updated_price >= 0)) THEN
268:
269: /*R12 uptake Added ORG_ID for MOAC Impact Bug No 5905216*/
270:
271: insert into igi_rpi_update_lines
272: (run_id, standing_charge_id, line_item_id, item_id, price, effective_date,
273: revised_price, revised_effective_date,
274: updated_price, select_flag,
275: creation_date, created_by, last_update_date, last_updated_by,

Line 333: insert into igi_rpi_update_lines

329: IF ((lv_updated_price is not NULL) AND (lv_updated_price >= 0)) THEN
330:
331: /*R12 Uptake Added ORG_ID for MOAC Impact bug No 5905216*/
332:
333: insert into igi_rpi_update_lines
334: (run_id, standing_charge_id, line_item_id, item_id, price, effective_date,
335: revised_price, revised_effective_date,
336: updated_price, select_flag,
337: creation_date, created_by, last_update_date, last_updated_by,

Line 372: FROM igi_rpi_update_lines_all /*MOAC Impact Bug No 5905216*/

368: previous_price,
369: previous_effective_date,
370: last_updated_by,
371: last_update_login
372: FROM igi_rpi_update_lines_all /*MOAC Impact Bug No 5905216*/
373: WHERE run_id = cp_run_id
374: and UPPER(select_flag) = UPPER('y') ;
375:
376: CURSOR c_ruh IS