APPS.IGS_GR_GRD_LGCY_PUB dependencies on IGS_PS_AWD

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

Line 768: CURSOR c_awd_type(p_award_cd igs_ps_awd.award_cd%TYPE) IS

764: --Initialize API return status to true
765: l_return_value BOOLEAN := FND_API.TO_BOOLEAN(FND_API.G_TRUE);
766:
767: --Cursor to fetch the award type
768: CURSOR c_awd_type(p_award_cd igs_ps_awd.award_cd%TYPE) IS
769: SELECT S_AWARD_TYPE
770: FROM igs_ps_awd
771: WHERE award_cd = p_award_cd;
772:

Line 770: FROM igs_ps_awd

766:
767: --Cursor to fetch the award type
768: CURSOR c_awd_type(p_award_cd igs_ps_awd.award_cd%TYPE) IS
769: SELECT S_AWARD_TYPE
770: FROM igs_ps_awd
771: WHERE award_cd = p_award_cd;
772:
773: CURSOR c_gst IS
774: SELECT gst.s_graduand_status

Line 814: l_s_award_type igs_ps_awd.S_AWARD_TYPE%TYPE;

810: FROM IGS_GR_STAT
811: WHERE GRADUAND_STATUS = p_lgcy_grd_rec.graduand_status;
812:
813:
814: l_s_award_type igs_ps_awd.S_AWARD_TYPE%TYPE;
815: v_gst_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE;
816: v_gas_s_graduand_appr_status IGS_GR_APRV_STAT.s_graduand_appr_status%TYPE;
817: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
818: v_sca_crs_rqrmnt_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;