APPS.IGS_GR_GRD_LGCY_PUB dependencies on IGS_EN_STDNT_PS_ATT

Line 696: --Foreign key validation with the table IGS_EN_STDNT_PS_ATT_PKG column person_id and course_cd

692: l_return_value := 'E';--Continue
693: END IF;
694: --End of Foreign key validation with the table IGS_GR_STAT_PKG column graduand_status
695:
696: --Foreign key validation with the table IGS_EN_STDNT_PS_ATT_PKG column person_id and course_cd
697: IF p_person_id IS NOT NULL AND
698: p_lgcy_grd_rec.program_cd IS NOT NULL AND
699: NOT IGS_EN_STDNT_PS_ATT_PKG.Get_PK_For_Validation(X_PERSON_ID => p_person_id,
700: X_COURSE_CD => p_lgcy_grd_rec.program_cd)

Line 699: NOT IGS_EN_STDNT_PS_ATT_PKG.Get_PK_For_Validation(X_PERSON_ID => p_person_id,

695:
696: --Foreign key validation with the table IGS_EN_STDNT_PS_ATT_PKG column person_id and course_cd
697: IF p_person_id IS NOT NULL AND
698: p_lgcy_grd_rec.program_cd IS NOT NULL AND
699: NOT IGS_EN_STDNT_PS_ATT_PKG.Get_PK_For_Validation(X_PERSON_ID => p_person_id,
700: X_COURSE_CD => p_lgcy_grd_rec.program_cd)
701: THEN
702: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_STPRATPT_FK_NOT_EXISTS');
703: FND_MSG_PUB.ADD;

Line 706: --End of Foreign key validation with the table IGS_EN_STDNT_PS_ATT_PKG column person_id and course_cd

702: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_STPRATPT_FK_NOT_EXISTS');
703: FND_MSG_PUB.ADD;
704: l_return_value := 'E';--Continue
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

Line 786: FROM IGS_EN_STDNT_PS_ATT sca

782:
783: CURSOR c_sca IS
784: SELECT sca.version_number,
785: sca.course_rqrmnt_complete_ind
786: FROM IGS_EN_STDNT_PS_ATT sca
787: WHERE sca.person_id = P_person_id AND
788: sca.course_cd = p_lgcy_grd_rec.program_cd;
789:
790: CURSOR c_scaae

Line 791: (cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS

787: WHERE sca.person_id = P_person_id AND
788: sca.course_cd = p_lgcy_grd_rec.program_cd;
789:
790: CURSOR c_scaae
791: (cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
792: SELECT 'x'
793: FROM IGS_PS_STDNT_APV_ALT scaae
794: WHERE scaae.person_id = p_person_id AND
795: scaae.course_cd = p_lgcy_grd_rec.program_cd AND

Line 803: FROM IGS_EN_STDNT_PS_ATT sca

799: scaae.rqrmnts_complete_ind = 'Y';
800:
801: CURSOR c_sur_sca IS
802: SELECT 'x'
803: FROM IGS_EN_STDNT_PS_ATT sca
804: WHERE sca.person_id = p_person_id AND
805: sca.course_cd = p_lgcy_grd_rec.sur_for_program_cd AND
806: sca.version_number = p_lgcy_grd_rec.sur_for_prog_version_number;
807:

Line 817: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

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;
819: v_scaae_exists VARCHAR2(1);
820: v_sca_exists CHAR(1);
821:

Line 818: v_sca_crs_rqrmnt_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;

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;
819: v_scaae_exists VARCHAR2(1);
820: v_sca_exists CHAR(1);
821:
822: cst_attending CONSTANT IGS_GR_GRADUAND.s_graduand_type%TYPE := 'ATTENDING';