eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_TI_COMP dependencies on IGS_AD_ACAD_HISTORY_V

Line 120: FROM igs_ad_acad_history_v

116: CURSOR cur_trans ( p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ) IS
117: SELECT DISTINCT institution_code,
118: degree_attempted,
119: degree_earned
120: FROM igs_ad_acad_history_v
121: WHERE person_id = p_person_id
122: AND transcript_required = 'Y'
123: AND status = 'A' ;
124:

Line 127: CURSOR cur_trans_final ( p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,

123: AND status = 'A' ;
124:
125:
126: -- Get all the transacript details for each application of the Person where the status is FINAL.
127: CURSOR cur_trans_final ( p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
128: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
129: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
130: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
131: SELECT DISTINCT 1

Line 128: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,

124:
125:
126: -- Get all the transacript details for each application of the Person where the status is FINAL.
127: CURSOR cur_trans_final ( p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
128: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
129: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
130: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
131: SELECT DISTINCT 1
132: FROM igs_ad_acad_history_v a

Line 129: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,

125:
126: -- Get all the transacript details for each application of the Person where the status is FINAL.
127: CURSOR cur_trans_final ( p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
128: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
129: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
130: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
131: SELECT DISTINCT 1
132: FROM igs_ad_acad_history_v a
133: WHERE person_id= p_person_id

Line 130: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS

126: -- Get all the transacript details for each application of the Person where the status is FINAL.
127: CURSOR cur_trans_final ( p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
128: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
129: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
130: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
131: SELECT DISTINCT 1
132: FROM igs_ad_acad_history_v a
133: WHERE person_id= p_person_id
134: AND institution_code = p_institution_code

Line 132: FROM igs_ad_acad_history_v a

128: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
129: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
130: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
131: SELECT DISTINCT 1
132: FROM igs_ad_acad_history_v a
133: WHERE person_id= p_person_id
134: AND institution_code = p_institution_code
135: AND NVL(degree_attempted,NVL(p_degree_attempted,'*')) = NVL(p_degree_attempted,'*')
136: AND NVL(degree_earned,NVL(p_degree_earned,'*')) = NVL(p_degree_earned,'*')

Line 146: CURSOR cur_trans_partial(p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,

142: AND c.transcript_status = 'FINAL'
143: AND c.transcript_type ='OFFICIAL');
144:
145: -- Get all the transacript details for each application of the Person where the status is PARTIAL or FINALL.
146: CURSOR cur_trans_partial(p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
147: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
148: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
149: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
150: SELECT DISTINCT 1

Line 147: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,

143: AND c.transcript_type ='OFFICIAL');
144:
145: -- Get all the transacript details for each application of the Person where the status is PARTIAL or FINALL.
146: CURSOR cur_trans_partial(p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
147: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
148: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
149: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
150: SELECT DISTINCT 1
151: FROM igs_ad_acad_history_v a

Line 148: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,

144:
145: -- Get all the transacript details for each application of the Person where the status is PARTIAL or FINALL.
146: CURSOR cur_trans_partial(p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
147: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
148: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
149: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
150: SELECT DISTINCT 1
151: FROM igs_ad_acad_history_v a
152: WHERE person_id = p_person_id

Line 149: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS

145: -- Get all the transacript details for each application of the Person where the status is PARTIAL or FINALL.
146: CURSOR cur_trans_partial(p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
147: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
148: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
149: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
150: SELECT DISTINCT 1
151: FROM igs_ad_acad_history_v a
152: WHERE person_id = p_person_id
153: AND institution_code= p_institution_code

Line 151: FROM igs_ad_acad_history_v a

147: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
148: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
149: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
150: SELECT DISTINCT 1
151: FROM igs_ad_acad_history_v a
152: WHERE person_id = p_person_id
153: AND institution_code= p_institution_code
154: AND NVL(degree_attempted,NVL(p_degree_attempted,'*')) = NVL(p_degree_attempted,'*')
155: AND NVL(degree_earned,NVL(p_degree_earned,'*')) = NVL(p_degree_earned,'*')

Line 165: CURSOR cur_trans_final_unofficial ( p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,

161: AND c.transcript_status IN ('FINAL','PARTIAL')
162: AND c.transcript_type ='OFFICIAL');
163:
164: -- Get all the transacript details for each application of the Person where the status is FINAL and type UNOFFICIAL.
165: CURSOR cur_trans_final_unofficial ( p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
166: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
167: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
168: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
169: SELECT DISTINCT 1

Line 166: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,

162: AND c.transcript_type ='OFFICIAL');
163:
164: -- Get all the transacript details for each application of the Person where the status is FINAL and type UNOFFICIAL.
165: CURSOR cur_trans_final_unofficial ( p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
166: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
167: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
168: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
169: SELECT DISTINCT 1
170: FROM igs_ad_acad_history_v a

Line 167: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,

163:
164: -- Get all the transacript details for each application of the Person where the status is FINAL and type UNOFFICIAL.
165: CURSOR cur_trans_final_unofficial ( p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
166: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
167: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
168: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
169: SELECT DISTINCT 1
170: FROM igs_ad_acad_history_v a
171: WHERE person_id = p_person_id

Line 168: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS

164: -- Get all the transacript details for each application of the Person where the status is FINAL and type UNOFFICIAL.
165: CURSOR cur_trans_final_unofficial ( p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
166: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
167: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
168: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
169: SELECT DISTINCT 1
170: FROM igs_ad_acad_history_v a
171: WHERE person_id = p_person_id
172: AND institution_code= p_institution_code

Line 170: FROM igs_ad_acad_history_v a

166: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
167: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
168: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
169: SELECT DISTINCT 1
170: FROM igs_ad_acad_history_v a
171: WHERE person_id = p_person_id
172: AND institution_code= p_institution_code
173: AND NVL(degree_attempted,NVL(p_degree_attempted,'*')) = NVL(p_degree_attempted,'*')
174: AND NVL(degree_earned,NVL(p_degree_earned,'*')) = NVL(p_degree_earned,'*')

Line 184: CURSOR cur_trans_partial_unofficial(p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,

180: AND c.transcript_status = 'FINAL'
181: AND c.transcript_type ='UNOFFICIAL');
182:
183: -- Get all the transacript details for each application of the Person where the status is PARTIAL or FINALL and type UNOFFICIAL.
184: CURSOR cur_trans_partial_unofficial(p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
185: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
186: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
187: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
188: SELECT DISTINCT 1

Line 185: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,

181: AND c.transcript_type ='UNOFFICIAL');
182:
183: -- Get all the transacript details for each application of the Person where the status is PARTIAL or FINALL and type UNOFFICIAL.
184: CURSOR cur_trans_partial_unofficial(p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
185: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
186: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
187: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
188: SELECT DISTINCT 1
189: FROM igs_ad_acad_history_v a

Line 186: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,

182:
183: -- Get all the transacript details for each application of the Person where the status is PARTIAL or FINALL and type UNOFFICIAL.
184: CURSOR cur_trans_partial_unofficial(p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
185: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
186: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
187: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
188: SELECT DISTINCT 1
189: FROM igs_ad_acad_history_v a
190: WHERE person_id = p_person_id

Line 187: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS

183: -- Get all the transacript details for each application of the Person where the status is PARTIAL or FINALL and type UNOFFICIAL.
184: CURSOR cur_trans_partial_unofficial(p_person_id IN igs_ad_acad_history_v.person_id%TYPE ,
185: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
186: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
187: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
188: SELECT DISTINCT 1
189: FROM igs_ad_acad_history_v a
190: WHERE person_id = p_person_id
191: AND institution_code= p_institution_code

Line 189: FROM igs_ad_acad_history_v a

185: p_institution_code IN igs_ad_acad_history_v.institution_code%TYPE,
186: p_degree_attempted IN igs_ad_acad_history_v.degree_attempted%TYPE,
187: p_degree_earned IN igs_ad_acad_history_v.degree_earned%TYPE ) IS
188: SELECT DISTINCT 1
189: FROM igs_ad_acad_history_v a
190: WHERE person_id = p_person_id
191: AND institution_code= p_institution_code
192: AND NVL(degree_attempted,NVL(p_degree_attempted,'*')) = NVL(p_degree_attempted,'*')
193: AND NVL(degree_earned,NVL(p_degree_earned,'*')) = NVL(p_degree_earned,'*')