DBA Data[Home] [Help]

APPS.IGS_AS_GEN_003 dependencies on IGS_EN_STDNT_PS_ATT

Line 166: P_PERSON_ID IN IGS_EN_STDNT_PS_ATT.person_id%TYPE ,

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 ,

Line 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:

Line 171: P_COURSE_CD IN igs_en_stdnt_ps_att.course_cd%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:
175: FUNCTION getStdntPrograms(

Line 176: P_PERSON_ID IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE ,

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 ,

Line 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: