APPS.IGS_EN_SPA_LGCY_PUB dependencies on IGS_PS_VER

Line 579: p_course_type IN igs_ps_ver_all.course_type%TYPE,

575: END validate_sca_db_cons;
576:
577: FUNCTION validate_sca(p_person_id IN igs_pe_person.person_id%TYPE,
578: p_course_att_status IN igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
579: p_course_type IN igs_ps_ver_all.course_type%TYPE,
580: p_career_flag IN VARCHAR2,
581: p_sca_re_rec IN SCA_RE_REC_TYPE)
582: RETURN BOOLEAN AS
583: /*----------------------------------------------------------------------------

Line 900: l_course_type igs_ps_ver_all.course_type%TYPE;

896:
897: --local variable to hold derived values.
898: l_career_flag VARCHAR2(1);
899: l_person_id igs_pe_person.person_id%TYPE;
900: l_course_type igs_ps_ver_all.course_type%TYPE;
901: l_coo_id igs_ps_ofr_opt_all.coo_id%TYPE;
902: l_course_att_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;
903: l_igs_pr_class_std_id igs_en_stdnt_ps_att_all.igs_pr_class_std_id%TYPE;
904: l_catalog_cal_type igs_en_stdnt_ps_att_all.catalog_cal_type%TYPE;