eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGIRRPS dependencies on IGI_RPI_LINE_DETAILS

Line 301: from igi_rpi_line_details

297: AND sc.status = CHARGE_STATUS
298: ;
299: CURSOR c_lines ( cp_standing_charge_id in number) IS
300: select rowid row_id, start_date
301: from igi_rpi_line_details
302: where standing_charge_id = cp_standing_charge_id
303: and start_date is not null
304: ;
305: lv_update_sc C_UpdateStandingCharges%ROWTYPE;

Line 412: UPDATE igi_rpi_line_details

408: -- bug 3199481, end block
409: return ;
410: END IF;
411:
412: UPDATE igi_rpi_line_details
413: SET start_date = ld_new_ld_date
414: WHERE rowid = l_lines.row_id
415: ;
416:

Line 512: from igi_rpi_line_details_all

508: charge_item_number,
509: item_id,
510: price,
511: current_effective_date
512: from igi_rpi_line_details_all
513: where standing_charge_id = cp_sc_id
514: ;
515:
516: BEGIN

Line 737: update igi_rpi_line_details_all

733: x_previous_price => line_rec.PRICE,
734: x_previous_effective_date => line_rec.CURRENT_EFFECTIVE_DATE
735:
736: );
737: update igi_rpi_line_details_all
738: set previous_price = price,
739: previous_effective_date = current_effective_date,
740: price = revised_price,
741: current_effective_date = revised_effective_date,