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.IGIRRGPP dependencies on IGI_RPI_LINE_DETAILS

Line 64: FROM igi_rpi_line_details lines

60: pp_created_by created_by,
61: pp_last_update_date last_update_date,
62: pp_last_updated_by last_updated_by,
63: pp_last_update_login last_update_login
64: FROM igi_rpi_line_details lines
65: WHERE exists ( select item_id
66: from igi_rpi_items items
67: where item_code >= pp_item_code_from
68: AND item_code <= pp_item_code_to

Line 107: FROM igi_rpi_line_details lines

103: pp_created_by created_by,
104: pp_last_update_date last_update_date,
105: pp_last_updated_by last_updated_by,
106: pp_last_update_login last_update_login
107: FROM igi_rpi_line_details lines
108: WHERE exists ( select item_id
109: from igi_rpi_items items
110: where item_code >= pp_item_code_from
111: AND item_code <= pp_item_code_to

Line 390: CURSOR c_charge_item_number(p_standing_charge_id igi_rpi_line_details.standing_charge_id%TYPE,

386: org_id
387: FROM igi_rpi_update_hdr_all /*MOAC Impact Bug No 5905216*/
388: WHERE run_id = pp_run_id ;
389:
390: CURSOR c_charge_item_number(p_standing_charge_id igi_rpi_line_details.standing_charge_id%TYPE,
391: p_line_item_id igi_rpi_line_details.line_item_id%TYPE) IS
392: SELECT charge_item_number
393: FROM igi_rpi_line_details
394: WHERE line_item_id = p_line_item_id

Line 391: p_line_item_id igi_rpi_line_details.line_item_id%TYPE) IS

387: FROM igi_rpi_update_hdr_all /*MOAC Impact Bug No 5905216*/
388: WHERE run_id = pp_run_id ;
389:
390: CURSOR c_charge_item_number(p_standing_charge_id igi_rpi_line_details.standing_charge_id%TYPE,
391: p_line_item_id igi_rpi_line_details.line_item_id%TYPE) IS
392: SELECT charge_item_number
393: FROM igi_rpi_line_details
394: WHERE line_item_id = p_line_item_id
395: AND standing_charge_id = p_standing_charge_id;

Line 393: FROM igi_rpi_line_details

389:
390: CURSOR c_charge_item_number(p_standing_charge_id igi_rpi_line_details.standing_charge_id%TYPE,
391: p_line_item_id igi_rpi_line_details.line_item_id%TYPE) IS
392: SELECT charge_item_number
393: FROM igi_rpi_line_details
394: WHERE line_item_id = p_line_item_id
395: AND standing_charge_id = p_standing_charge_id;
396:
397: -- l_org_id VARCHAR2(15); /*MOAC Impact Bug No 5905216*/

Line 400: l_charge_item_number igi_rpi_line_details.charge_item_number%TYPE;

396:
397: -- l_org_id VARCHAR2(15); /*MOAC Impact Bug No 5905216*/
398: l_org_id NUMBER;
399: l_rowid VARCHAR2(25) := NULL;
400: l_charge_item_number igi_rpi_line_details.charge_item_number%TYPE;
401:
402: BEGIN
403:
404: --WriteToLogFile('Start of Processing of records for Update');

Line 516: update igi_rpi_line_details

512: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg11',
513: 'Updating revised price of Standing Charge Line Item');
514: END IF;
515: -- bug 3199481, end block
516: update igi_rpi_line_details
517: set revised_price = l_rul.updated_price,
518: revised_effective_date = l_ruh.effective_date,
519: last_update_date = sysdate,
520: last_updated_by = l_rul.last_updated_by,