APPS.IGS_GR_GRD_LGCY_PUB dependencies on IGS_PS_AWD_PKG

Line 643: -- Foreign key validation with the table IGS_PS_AWD_PKG Column Award_Cd

639: RETURN l_return_value;
640: END IF;
641: -- End of Check for Unique key check
642:
643: -- Foreign key validation with the table IGS_PS_AWD_PKG Column Award_Cd
644: IF NOT IGS_PS_AWD_PKG.Get_PK_For_Validation(X_AWARD_CD => p_lgcy_grd_rec.award_cd)
645: THEN
646: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_AWDCD_FK_NOT_EXISTS');
647: FND_MSG_PUB.ADD;

Line 644: IF NOT IGS_PS_AWD_PKG.Get_PK_For_Validation(X_AWARD_CD => p_lgcy_grd_rec.award_cd)

640: END IF;
641: -- End of Check for Unique key check
642:
643: -- Foreign key validation with the table IGS_PS_AWD_PKG Column Award_Cd
644: IF NOT IGS_PS_AWD_PKG.Get_PK_For_Validation(X_AWARD_CD => p_lgcy_grd_rec.award_cd)
645: THEN
646: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_AWDCD_FK_NOT_EXISTS');
647: FND_MSG_PUB.ADD;
648: l_return_value := 'E'; --Continue

Line 650: -- End of Foreign key validation with the table IGS_PS_AWD_PKG Column Award_Cd

646: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_AWDCD_FK_NOT_EXISTS');
647: FND_MSG_PUB.ADD;
648: l_return_value := 'E'; --Continue
649: END IF;
650: -- End of Foreign key validation with the table IGS_PS_AWD_PKG Column Award_Cd
651:
652: -- Foreign key validation with the table IGS_PS_AWARD_PKG Columns award_course_cd, award_crs_version_number and Award_Cd
653: IF p_lgcy_grd_rec.AWARD_PROGRAM_CD IS NOT NULL AND
654: p_lgcy_grd_rec.AWARD_PROG_VERSION_NUMBER IS NOT NULL AND