APPS.IGS_EN_LGCY_PRC dependencies on IGS_EN_SPI_RCOND_INTS

Line 3562: SELECT * from IGS_EN_SPI_RCOND_INTS

3558: p_deletion_flag IN BOOLEAN
3559: ) AS
3560:
3561: CURSOR c_en_spi_rcond IS
3562: SELECT * from IGS_EN_SPI_RCOND_INTS
3563: WHERE import_status IN ('U','R')
3564: AND batch_id = p_batch_id
3565: FOR UPDATE NOWAIT;
3566:

Line 3646: DELETE FROM IGS_EN_SPI_RCOND_INTS

3642: p_int_table_id => l_en_spi_rcond_cur_rec.LGCY_EN_SPI_RCONS_INT_ID
3643: );
3644:
3645: -- delete the interface record
3646: DELETE FROM IGS_EN_SPI_RCOND_INTS
3647: WHERE LGCY_EN_SPI_RCONS_INT_ID = l_en_spi_rcond_cur_rec.LGCY_EN_SPI_RCONS_INT_ID ;
3648: ELSE
3649: l_last_updated_by := get_last_updated_by;
3650: l_last_update_date := get_last_update_date;

Line 3656: UPDATE IGS_EN_SPI_RCOND_INTS

3652: l_request_id := get_request_id;
3653: l_program_application_id := get_program_application_id;
3654: l_program_id := get_program_id;
3655: l_program_update_date := get_program_update_date;
3656: UPDATE IGS_EN_SPI_RCOND_INTS
3657: SET import_status = DECODE(l_return_status,
3658: 'S','I',
3659: 'U','E',
3660: 'W','W',