APPS.IGIRRGPP dependencies on IGI_RPI_ITEMS

Line 66: from igi_rpi_items items

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
69: AND items.item_id = lines.item_id
70: )

Line 79: from igi_rpi_items items

75: and set_of_books_id = ( select set_of_books_id from ar_system_parameters )
76: )
77: AND exists
78: ( select 'x'
79: from igi_rpi_items items
80: where decode(sign(trunc(nvl(lines.revised_effective_date, (pp_update_effective_date + 1)))
81: - trunc(pp_update_effective_date)),1, lines.price, lines.revised_price)
82: = decode(sign(trunc(nvl(items.revised_price_eff_date, (pp_update_effective_date + 1)))
83: - trunc(pp_update_effective_date)),1, items.price, items.revised_price)

Line 109: from igi_rpi_items items

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
112: AND items.item_id = lines.item_id
113: )

Line 142: FROM igi_rpi_items

138: pp_created_by created_by,
139: pp_last_update_date last_update_date,
140: pp_last_updated_by last_updated_by,
141: pp_last_update_login last_update_login
142: FROM igi_rpi_items
143: where item_code >= pp_item_code_from
144: AND item_code <= pp_item_code_to
145: AND set_of_books_id =
146: ( select set_of_books_id from ar_system_parameters )

Line 463: update igi_rpi_items

459: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg8',
460: 'Updating revised price of Charge Item');
461: END IF;
462: -- bug 3199481, end block
463: update igi_rpi_items
464: set revised_price = l_rul.updated_price,
465: revised_price_eff_date = l_ruh.effective_date,
466: last_update_date = sysdate,
467: last_updated_by = l_rul.last_updated_by,

Line 496: update igi_rpi_items

492: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg10',
493: 'Updating revised price of Charge Item');
494: END IF;
495: -- bug 3199481, end block
496: update igi_rpi_items
497: set price = l_rul.revised_price,
498: price_effective_date = l_rul.revised_effective_date,
499: revised_price = l_rul.updated_price,
500: revised_price_eff_date = l_ruh.effective_date,