DBA Data[Home] [Help]

APPS.IGS_EN_STDNT_PS_INTM_PKG dependencies on IGS_EN_SPI_RCONDS_PKG

Line 248: igs_en_spi_rconds_pkg.update_row( x_rowid => c_spi_rconds_rec.rowid,

244: -- when the intermission record is being logically deleted, all the child return conditions
245: -- should also be logically deleted.
246: FOR c_spi_rconds_rec IN c_spi_rconds(old_references.person_id, old_references.course_cd,
247: old_references.start_dt, old_references.logical_delete_date) LOOP
248: igs_en_spi_rconds_pkg.update_row( x_rowid => c_spi_rconds_rec.rowid,
249: x_person_id => c_spi_rconds_rec.person_id,
250: x_course_cd => c_spi_rconds_rec.course_cd,
251: x_start_dt => c_spi_rconds_rec.start_dt,
252: x_logical_delete_date => new_references.logical_delete_date,

Line 479: IGS_EN_SPI_RCONDS_PKG.get_fk_igs_en_stdnt_ps_intm(

475: || Who When What
476: || (reverse chronological order - newest change first)
477: */
478: BEGIN
479: IGS_EN_SPI_RCONDS_PKG.get_fk_igs_en_stdnt_ps_intm(
480: old_references.person_id,
481: old_references.course_cd,
482: old_references.start_dt,
483: old_references.logical_delete_date