APPS.IGS_EN_SPI_RCOND_LGCY_PUB dependencies on IGS_EN_SPI_RCONDS

Line 93: IF igs_en_spi_rconds_pkg.get_pk_for_validation (

89: l_ret_val := 'E';
90: END IF;
91:
92: -- Check whether the student intermission return condition already exists
93: IF igs_en_spi_rconds_pkg.get_pk_for_validation (
94: x_person_id => p_person_id,
95: x_course_cd => p_intm_rcond_rec.program_cd,
96: x_start_dt => p_intm_rcond_rec.start_dt,
97: x_logical_delete_date => to_date('31-12-4712','DD-MM-YYYY'),

Line 276: INSERT INTO igs_en_spi_rconds (

272: l_last_update_login := -1;
273: END IF;
274:
275: -- insert the student intermission return cond record
276: INSERT INTO igs_en_spi_rconds (
277: person_id,
278: course_cd,
279: start_dt,
280: logical_delete_date,