162: -- anilk, 22-Apr-2003, Bug# 2829262
163: p_uoo_id IN NUMBER );
164:
165: FUNCTION getStdntCareerPrograms(
166: P_PERSON_ID IN IGS_EN_STDNT_PS_ATT.person_id%TYPE ,
167: P_PROGRAM_TYPE IN IGS_PS_VER_ALL.course_type%TYPE ) RETURN VARCHAR2 ;
168:
169: FUNCTION getStdntCareerProgsBetween(
170: P_PERSON_ID IN igs_en_stdnt_ps_att.person_id%TYPE ,
166: P_PERSON_ID IN IGS_EN_STDNT_PS_ATT.person_id%TYPE ,
167: P_PROGRAM_TYPE IN IGS_PS_VER_ALL.course_type%TYPE ) RETURN VARCHAR2 ;
168:
169: FUNCTION getStdntCareerProgsBetween(
170: P_PERSON_ID IN igs_en_stdnt_ps_att.person_id%TYPE ,
171: P_COURSE_CD IN igs_en_stdnt_ps_att.course_cd%TYPE ,
172: P_TERM_START_DATE IN DATE ,
173: P_TERM_END_DATE IN DATE ) RETURN VARCHAR2 ;
174:
167: P_PROGRAM_TYPE IN IGS_PS_VER_ALL.course_type%TYPE ) RETURN VARCHAR2 ;
168:
169: FUNCTION getStdntCareerProgsBetween(
170: P_PERSON_ID IN igs_en_stdnt_ps_att.person_id%TYPE ,
171: P_COURSE_CD IN igs_en_stdnt_ps_att.course_cd%TYPE ,
172: P_TERM_START_DATE IN DATE ,
173: P_TERM_END_DATE IN DATE ) RETURN VARCHAR2 ;
174:
175: FUNCTION getStdntPrograms(
172: P_TERM_START_DATE IN DATE ,
173: P_TERM_END_DATE IN DATE ) RETURN VARCHAR2 ;
174:
175: FUNCTION getStdntPrograms(
176: P_PERSON_ID IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE ,
177: P_PROGRAM_CD IGS_PS_VER_ALL.COURSE_CD%TYPE ) RETURN VARCHAR2 ;
178:
179: FUNCTION getStdntProgsBetween(
180: P_PERSON_ID igs_en_stdnt_ps_att.person_id%type ,
176: P_PERSON_ID IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE ,
177: P_PROGRAM_CD IGS_PS_VER_ALL.COURSE_CD%TYPE ) RETURN VARCHAR2 ;
178:
179: FUNCTION getStdntProgsBetween(
180: P_PERSON_ID igs_en_stdnt_ps_att.person_id%type ,
181: P_program_cd igs_ps_ver_all.course_type%type ,
182: p_term_start_date DATE ,
183: p_term_end_date DATE ) RETURN VARCHAR2 ;
184: