APPS.IGS_EN_SPA_LGCY_PUB dependencies on IGS_PE_PERSON

Line 482: FUNCTION validate_sca_db_cons(p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,

478: END IF;
479: END validate_parameters;
480:
481:
482: FUNCTION validate_sca_db_cons(p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,
483: p_sca_re_rec IN SCA_RE_REC_TYPE)
484: RETURN VARCHAR2 AS
485: /*----------------------------------------------------------------------------
486: || Created By : kkillams

Line 577: FUNCTION validate_sca(p_person_id IN igs_pe_person.person_id%TYPE,

573: RETURN l_result_flag;
574: END IF;
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)

Line 730: FUNCTION validate_re_db_cons(p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,

726: END IF;
727: RETURN l_validation_success;
728: END validate_sca;
729:
730: FUNCTION validate_re_db_cons(p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,
731: p_sca_re_rec IN SCA_RE_REC_TYPE)
732: RETURN VARCHAR2 AS
733: /*----------------------------------------------------------------------------
734: || Created By : kkillams

Line 783: FUNCTION validate_re (p_person_id IN igs_pe_person.person_id%TYPE,

779: END IF;
780: END IF;
781: RETURN l_result_flag;
782: END validate_re_db_cons;
783: FUNCTION validate_re (p_person_id IN igs_pe_person.person_id%TYPE,
784: p_sca_re_rec IN SCA_RE_REC_TYPE)
785: RETURN BOOLEAN AS
786: /*----------------------------------------------------------------------------
787: || Created By : kkillams

Line 899: l_person_id igs_pe_person.person_id%TYPE;

895: l_err_flag VARCHAR2(1);
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;