eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_GR_GRD_LGCY_PUB dependencies on IGS_GR_STAT

Line 687: --Foreign key validation with the table IGS_GR_STAT_PKG column graduand_status

683: l_return_value := 'E';--Continue
684: END IF;
685: --7End of Foreign key validation with the table IGS_GR_APRV_STAT_PKG column graduand_appr_status
686:
687: --Foreign key validation with the table IGS_GR_STAT_PKG column graduand_status
688: IF NOT IGS_GR_STAT_PKG.Get_PK_For_Validation(X_GRADUAND_STATUS => p_lgcy_grd_rec.GRADUAND_STATUS)
689: THEN
690: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_GRDSTAT_FK_NOT_EXISTS');
691: FND_MSG_PUB.ADD;

Line 688: IF NOT IGS_GR_STAT_PKG.Get_PK_For_Validation(X_GRADUAND_STATUS => p_lgcy_grd_rec.GRADUAND_STATUS)

684: END IF;
685: --7End of Foreign key validation with the table IGS_GR_APRV_STAT_PKG column graduand_appr_status
686:
687: --Foreign key validation with the table IGS_GR_STAT_PKG column graduand_status
688: IF NOT IGS_GR_STAT_PKG.Get_PK_For_Validation(X_GRADUAND_STATUS => p_lgcy_grd_rec.GRADUAND_STATUS)
689: THEN
690: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_GRDSTAT_FK_NOT_EXISTS');
691: FND_MSG_PUB.ADD;
692: l_return_value := 'E';--Continue

Line 694: --End of Foreign key validation with the table IGS_GR_STAT_PKG column graduand_status

690: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_GRDSTAT_FK_NOT_EXISTS');
691: FND_MSG_PUB.ADD;
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

Line 775: FROM IGS_GR_STAT gst

771: WHERE award_cd = p_award_cd;
772:
773: CURSOR c_gst IS
774: SELECT gst.s_graduand_status
775: FROM IGS_GR_STAT gst
776: WHERE gst.graduand_status = p_lgcy_grd_rec.graduand_status;
777:
778: CURSOR c_gas IS
779: SELECT gas.s_graduand_appr_status

Line 810: FROM IGS_GR_STAT

806: sca.version_number = p_lgcy_grd_rec.sur_for_prog_version_number;
807:
808: CURSOR c_stu_grad_status IS
809: SELECT S_GRADUAND_STATUS
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;

Line 815: v_gst_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE;

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

Line 830: l_stu_grad_status igs_gr_stat.s_graduand_status%TYPE;

826:
827: l_start_dt DATE;
828: l_end_dt DATE;
829: l_message fnd_new_messages.message_name%TYPE;
830: l_stu_grad_status igs_gr_stat.s_graduand_status%TYPE;
831:
832:
833: BEGIN
834: --1 to 7 Validates GRADUAND required details.