DBA Data[Home] [Help]

APPS.IGS_RE_THE_LGCY_PUB dependencies on IGS_RE_THESIS_RESULT_PKG

Line 156: IF NOT IGS_RE_THESIS_RESULT_PKG.Get_PK_For_Validation (

152: END IF;
153:
154: -- FK check in the Thesis Result table
155: IF p_the_dtls_rec.final_thesis_result_cd IS NOT NULL THEN
156: IF NOT IGS_RE_THESIS_RESULT_PKG.Get_PK_For_Validation (
157: p_the_dtls_rec.final_thesis_result_cd ) THEN
158: FND_MESSAGE.SET_NAME ('IGS', 'IGS_RE_RESULT_CD_INVALID_VAL');
159: FND_MSG_PUB.ADD;
160: l_ret_status := 'E';

Line 358: IF NOT igs_re_thesis_result_pkg.get_pk_for_validation (

354: END IF;
355:
356: --FK check to the table igs_re_thesis_result for the field thesis_result_cd
357: IF p_the_dtls_rec.thesis_result_cd IS NOT NULL THEN
358: IF NOT igs_re_thesis_result_pkg.get_pk_for_validation (
359: p_the_dtls_rec.thesis_result_cd ) THEN
360: FND_MESSAGE.SET_NAME ('IGS', 'IGS_RE_THE_RES_CD_INV');
361: FND_MSG_PUB.ADD;
362: l_ret_status := 'E';