APPS.IGS_HE_SPA_LGCY_PUB dependencies on IGS_PS_FLD_OF_STUDY_PKG

Line 249: IF NOT igs_ps_fld_of_study_pkg.Get_Pk_For_Validation ( x_field_of_study => p_hesa_spa_stats_rec.subj_qualaim1) THEN

245: END IF;
246: END IF;
247: -- Check whether the Subject Qualification Aim 1 exists
248: IF p_hesa_spa_stats_rec.subj_qualaim1 IS NOT NULL THEN
249: IF NOT igs_ps_fld_of_study_pkg.Get_Pk_For_Validation ( x_field_of_study => p_hesa_spa_stats_rec.subj_qualaim1) THEN
250: FND_MESSAGE.SET_NAME('IGS','IGS_HE_SUBQ1_FS_INVALID');
251: FND_MSG_PUB.ADD;
252: l_db_val_failed := TRUE;
253: END IF;

Line 258: IF NOT igs_ps_fld_of_study_pkg.Get_Pk_For_Validation ( x_field_of_study => p_hesa_spa_stats_rec.subj_qualaim2) THEN

254: END IF;
255:
256: -- Check whether the Subject Qualification Aim 2 exists
257: IF p_hesa_spa_stats_rec.subj_qualaim2 IS NOT NULL THEN
258: IF NOT igs_ps_fld_of_study_pkg.Get_Pk_For_Validation ( x_field_of_study => p_hesa_spa_stats_rec.subj_qualaim2) THEN
259: FND_MESSAGE.SET_NAME('IGS','IGS_HE_SUBQ2_FS_INVALID');
260: FND_MSG_PUB.ADD;
261: l_db_val_failed := TRUE;
262: END IF;

Line 266: IF NOT igs_ps_fld_of_study_pkg.Get_Pk_For_Validation ( x_field_of_study => p_hesa_spa_stats_rec.subj_qualaim3) THEN

262: END IF;
263: END IF;
264: -- Check whether the Subject Qualification Aim 3 exists
265: IF p_hesa_spa_stats_rec.subj_qualaim3 IS NOT NULL THEN
266: IF NOT igs_ps_fld_of_study_pkg.Get_Pk_For_Validation ( x_field_of_study => p_hesa_spa_stats_rec.subj_qualaim3) THEN
267: FND_MESSAGE.SET_NAME('IGS','IGS_HE_SUBQ3_FS_INVALID');
268: FND_MSG_PUB.ADD;
269: l_db_val_failed := TRUE;
270: END IF;