DBA Data[Home] [Help]

APPS.IGIRRGPP dependencies on IGI_RPI_UPDATE_HDR

Line 387: FROM igi_rpi_update_hdr_all /*MOAC Impact Bug No 5905216*/

383: amount,
384: percentage_amount,
385: status,
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

Line 424: update igi_rpi_update_hdr

420: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg2',
421: 'Updating status of Update Header to ERROR');
422: END IF;
423: -- bug 3199481, end block
424: update igi_rpi_update_hdr
425: set status = 'ERROR'
426: where rowid = l_ruh.row_id ;
427:
428: FOR l_rul IN c_rul ( l_ruh.run_id ) LOOP

Line 563: update igi_rpi_update_hdr

559: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg13',
560: 'Updating status of Update Header to COMPLETED');
561: END IF;
562: -- bug 3199481, end block
563: update igi_rpi_update_hdr
564: set status = 'COMPLETED'
565: where run_id = l_ruh.run_id ;
566:
567: END LOOP;