DBA Data[Home] [Help]

APPS.IGS_AS_GEN_003 dependencies on IGS_PS_VER_ALL

Line 167: P_PROGRAM_TYPE IN IGS_PS_VER_ALL.course_type%TYPE ) RETURN VARCHAR2 ;

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 ,
171: P_COURSE_CD IN igs_en_stdnt_ps_att.course_cd%TYPE ,

Line 177: P_PROGRAM_CD IGS_PS_VER_ALL.COURSE_CD%TYPE ) RETURN VARCHAR2 ;

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 ,
181: P_program_cd igs_ps_ver_all.course_type%type ,

Line 181: P_program_cd igs_ps_ver_all.course_type%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:
185: PROCEDURE get_current_term (