APPS.IGS_GR_GRD_LGCY_PUB dependencies on IGS_PS_AWARD_PKG

Line 652: -- Foreign key validation with the table IGS_PS_AWARD_PKG Columns award_course_cd, award_crs_version_number and Award_Cd

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
655: p_lgcy_grd_rec.AWARD_CD IS NOT NULL AND
656: NOT IGS_PS_AWARD_PKG.Get_PK_For_Validation(X_COURSE_CD => p_lgcy_grd_rec.AWARD_PROGRAM_CD ,

Line 656: NOT IGS_PS_AWARD_PKG.Get_PK_For_Validation(X_COURSE_CD => p_lgcy_grd_rec.AWARD_PROGRAM_CD ,

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
655: p_lgcy_grd_rec.AWARD_CD IS NOT NULL AND
656: NOT IGS_PS_AWARD_PKG.Get_PK_For_Validation(X_COURSE_CD => p_lgcy_grd_rec.AWARD_PROGRAM_CD ,
657: X_VERSION_NUMBER => p_lgcy_grd_rec.AWARD_PROG_VERSION_NUMBER ,
658: X_AWARD_CD => p_lgcy_grd_rec.AWARD_CD )
659: THEN
660: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_AWDDET_FK_NOT_EXISTS');

Line 664: -- End of Foreign key validation with the table IGS_PS_AWARD_PKG Columns award_course_cd, award_crs_version_number and Award_Cd

660: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_AWDDET_FK_NOT_EXISTS');
661: FND_MSG_PUB.ADD;
662: l_return_value := 'E';--Continue
663: END IF;
664: -- End of Foreign key validation with the table IGS_PS_AWARD_PKG Columns award_course_cd, award_crs_version_number and Award_Cd
665:
666: --Foreign key validation with the table IGS_GR_CRMN_ROUND_PKG column grd_cal_type and grd_ci_sequence_number
667: IF NOT IGS_GR_CRMN_ROUND_PKG.Get_PK_For_Validation(
668: X_GRD_CAL_TYPE => p_cal_type ,

Line 709: --Foreign key validation with the table IGS_PS_AWARD_PKG column sur_for_course_cd, sur_for_crs_version_number and sur_for_award_cd

705: END IF;
706: --End of Foreign key validation with the table IGS_EN_STDNT_PS_ATT_PKG column person_id and course_cd
707:
708:
709: --Foreign key validation with the table IGS_PS_AWARD_PKG column sur_for_course_cd, sur_for_crs_version_number and sur_for_award_cd
710: IF p_lgcy_grd_rec.sur_for_program_cd IS NOT NULL AND
711: p_lgcy_grd_rec.sur_for_prog_version_number IS NOT NULL AND
712: p_lgcy_grd_rec.sur_for_award_cd IS NOT NULL AND
713: NOT IGS_PS_AWARD_PKG.Get_PK_For_Validation (X_COURSE_CD => p_lgcy_grd_rec.sur_for_program_cd ,

Line 713: NOT IGS_PS_AWARD_PKG.Get_PK_For_Validation (X_COURSE_CD => p_lgcy_grd_rec.sur_for_program_cd ,

709: --Foreign key validation with the table IGS_PS_AWARD_PKG column sur_for_course_cd, sur_for_crs_version_number and sur_for_award_cd
710: IF p_lgcy_grd_rec.sur_for_program_cd IS NOT NULL AND
711: p_lgcy_grd_rec.sur_for_prog_version_number IS NOT NULL AND
712: p_lgcy_grd_rec.sur_for_award_cd IS NOT NULL AND
713: NOT IGS_PS_AWARD_PKG.Get_PK_For_Validation (X_COURSE_CD => p_lgcy_grd_rec.sur_for_program_cd ,
714: X_VERSION_NUMBER => p_lgcy_grd_rec.sur_for_prog_version_number ,
715: X_AWARD_CD => p_lgcy_grd_rec.sur_for_award_cd)
716: THEN
717: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_SURCRSCD_FK_NOT_EXISTS');

Line 721: --End of Foreign key validation with the table IGS_PS_AWARD_PKG column sur_for_course_cd, sur_for_crs_version_number and sur_for_award_cd

717: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_SURCRSCD_FK_NOT_EXISTS');
718: FND_MSG_PUB.ADD;
719: l_return_value := 'E';--Continue
720: END IF;
721: --End of Foreign key validation with the table IGS_PS_AWARD_PKG column sur_for_course_cd, sur_for_crs_version_number and sur_for_award_cd
722:
723: IF p_lgcy_grd_rec.CONVOCATION_MEMBERSHIP_IND NOT IN('Y','N') THEN
724: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_CONV_MEM_IND_Y_N');
725: FND_MSG_PUB.ADD;