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_RATINGS_PUB dependencies on IGS_AD_APPL_EVAL

Line 225: l_person_id igs_ad_appl_eval.person_id%TYPE,

221:
222: (reverse chronological order - newest change first)
223: ***************************************************************/
224: CURSOR dup_eval_cur(
225: l_person_id igs_ad_appl_eval.person_id%TYPE,
226: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
227: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
228: l_seq_number igs_ad_appl_eval.sequence_number%TYPE)
229: IS

Line 226: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,

222: (reverse chronological order - newest change first)
223: ***************************************************************/
224: CURSOR dup_eval_cur(
225: l_person_id igs_ad_appl_eval.person_id%TYPE,
226: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
227: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
228: l_seq_number igs_ad_appl_eval.sequence_number%TYPE)
229: IS
230: SELECT count(*), rating_type_id, rating_scale_id,evaluator_id

Line 227: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,

223: ***************************************************************/
224: CURSOR dup_eval_cur(
225: l_person_id igs_ad_appl_eval.person_id%TYPE,
226: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
227: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
228: l_seq_number igs_ad_appl_eval.sequence_number%TYPE)
229: IS
230: SELECT count(*), rating_type_id, rating_scale_id,evaluator_id
231: FROM igs_ad_appl_eval

Line 228: l_seq_number igs_ad_appl_eval.sequence_number%TYPE)

224: CURSOR dup_eval_cur(
225: l_person_id igs_ad_appl_eval.person_id%TYPE,
226: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
227: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
228: l_seq_number igs_ad_appl_eval.sequence_number%TYPE)
229: IS
230: SELECT count(*), rating_type_id, rating_scale_id,evaluator_id
231: FROM igs_ad_appl_eval
232: WHERE person_id = l_person_id

Line 231: FROM igs_ad_appl_eval

227: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
228: l_seq_number igs_ad_appl_eval.sequence_number%TYPE)
229: IS
230: SELECT count(*), rating_type_id, rating_scale_id,evaluator_id
231: FROM igs_ad_appl_eval
232: WHERE person_id = l_person_id
233: AND admission_appl_number = l_adm_apl_num
234: AND nominated_course_cd = l_nom_crs_cd
235: AND sequence_number = l_seq_number

Line 241: l_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,

237: HAVING count(*) > 1;
238:
239: /* Cursor to get the Evaluator records which are duplicates */
240: CURSOR del_dup_eval_cur(
241: l_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,
242: l_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,
243: l_person_id igs_ad_appl_eval.person_id%TYPE,
244: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
245: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,

Line 242: l_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,

238:
239: /* Cursor to get the Evaluator records which are duplicates */
240: CURSOR del_dup_eval_cur(
241: l_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,
242: l_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,
243: l_person_id igs_ad_appl_eval.person_id%TYPE,
244: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
245: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
246: l_seq_number igs_ad_appl_eval.sequence_number%TYPE)

Line 243: l_person_id igs_ad_appl_eval.person_id%TYPE,

239: /* Cursor to get the Evaluator records which are duplicates */
240: CURSOR del_dup_eval_cur(
241: l_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,
242: l_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,
243: l_person_id igs_ad_appl_eval.person_id%TYPE,
244: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
245: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
246: l_seq_number igs_ad_appl_eval.sequence_number%TYPE)
247: IS

Line 244: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,

240: CURSOR del_dup_eval_cur(
241: l_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,
242: l_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,
243: l_person_id igs_ad_appl_eval.person_id%TYPE,
244: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
245: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
246: l_seq_number igs_ad_appl_eval.sequence_number%TYPE)
247: IS
248: SELECT rowid

Line 245: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,

241: l_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,
242: l_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,
243: l_person_id igs_ad_appl_eval.person_id%TYPE,
244: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
245: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
246: l_seq_number igs_ad_appl_eval.sequence_number%TYPE)
247: IS
248: SELECT rowid
249: FROM igs_ad_appl_eval

Line 246: l_seq_number igs_ad_appl_eval.sequence_number%TYPE)

242: l_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,
243: l_person_id igs_ad_appl_eval.person_id%TYPE,
244: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
245: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
246: l_seq_number igs_ad_appl_eval.sequence_number%TYPE)
247: IS
248: SELECT rowid
249: FROM igs_ad_appl_eval
250: WHERE rating_type_id = l_rating_type_id

Line 249: FROM igs_ad_appl_eval

245: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
246: l_seq_number igs_ad_appl_eval.sequence_number%TYPE)
247: IS
248: SELECT rowid
249: FROM igs_ad_appl_eval
250: WHERE rating_type_id = l_rating_type_id
251: AND evaluator_id = l_evaluator_id
252: AND person_id = l_person_id
253: AND admission_appl_number = l_adm_apl_num

Line 258: FROM igs_ad_appl_eval

254: AND nominated_course_cd = l_nom_crs_cd
255: AND sequence_number = l_seq_number
256: AND rowid <>
257: (SELECT max(rowid)
258: FROM igs_ad_appl_eval
259: WHERE rating_type_id = l_rating_type_id
260: AND evaluator_id = l_evaluator_id
261: AND person_id = l_person_id
262: AND admission_appl_number = l_adm_apl_num

Line 269: l_person_id igs_ad_appl_eval.person_id%TYPE,

265: );
266:
267:
268: CURSOR c_get_current_eval(
269: l_person_id igs_ad_appl_eval.person_id%TYPE,
270: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
271: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
272: l_seq_num igs_ad_appl_eval.sequence_number%TYPE
273: ) IS

Line 270: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,

266:
267:
268: CURSOR c_get_current_eval(
269: l_person_id igs_ad_appl_eval.person_id%TYPE,
270: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
271: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
272: l_seq_num igs_ad_appl_eval.sequence_number%TYPE
273: ) IS
274: SELECT 'X'

Line 271: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,

267:
268: CURSOR c_get_current_eval(
269: l_person_id igs_ad_appl_eval.person_id%TYPE,
270: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
271: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
272: l_seq_num igs_ad_appl_eval.sequence_number%TYPE
273: ) IS
274: SELECT 'X'
275: FROM igs_ad_appl_eval

Line 272: l_seq_num igs_ad_appl_eval.sequence_number%TYPE

268: CURSOR c_get_current_eval(
269: l_person_id igs_ad_appl_eval.person_id%TYPE,
270: l_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
271: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
272: l_seq_num igs_ad_appl_eval.sequence_number%TYPE
273: ) IS
274: SELECT 'X'
275: FROM igs_ad_appl_eval
276: WHERE person_id = l_person_id

Line 275: FROM igs_ad_appl_eval

271: l_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
272: l_seq_num igs_ad_appl_eval.sequence_number%TYPE
273: ) IS
274: SELECT 'X'
275: FROM igs_ad_appl_eval
276: WHERE person_id = l_person_id
277: AND admission_appl_number = l_adm_apl_num
278: AND nominated_course_cd = l_nom_crs_cd
279: AND sequence_number = l_seq_num ;

Line 310: l_person_id igs_ad_appl_eval_v.person_id%TYPE,

306: AND nominated_course_cd = l_nom_crs_cd
307: AND sequence_number = l_seq_num ;
308:
309: CURSOR get_rating_cur(
310: l_person_id igs_ad_appl_eval_v.person_id%TYPE,
311: l_adm_apl_num igs_ad_appl_eval_v.admission_appl_number%TYPE,
312: l_nom_crs_cd igs_ad_appl_eval_v.nominated_course_cd%TYPE,
313: l_seq_num igs_ad_appl_eval_v.sequence_number%TYPE
314: ) IS

Line 311: l_adm_apl_num igs_ad_appl_eval_v.admission_appl_number%TYPE,

307: AND sequence_number = l_seq_num ;
308:
309: CURSOR get_rating_cur(
310: l_person_id igs_ad_appl_eval_v.person_id%TYPE,
311: l_adm_apl_num igs_ad_appl_eval_v.admission_appl_number%TYPE,
312: l_nom_crs_cd igs_ad_appl_eval_v.nominated_course_cd%TYPE,
313: l_seq_num igs_ad_appl_eval_v.sequence_number%TYPE
314: ) IS
315: SELECT rating

Line 312: l_nom_crs_cd igs_ad_appl_eval_v.nominated_course_cd%TYPE,

308:
309: CURSOR get_rating_cur(
310: l_person_id igs_ad_appl_eval_v.person_id%TYPE,
311: l_adm_apl_num igs_ad_appl_eval_v.admission_appl_number%TYPE,
312: l_nom_crs_cd igs_ad_appl_eval_v.nominated_course_cd%TYPE,
313: l_seq_num igs_ad_appl_eval_v.sequence_number%TYPE
314: ) IS
315: SELECT rating
316: FROM igs_ad_appl_eval_v

Line 313: l_seq_num igs_ad_appl_eval_v.sequence_number%TYPE

309: CURSOR get_rating_cur(
310: l_person_id igs_ad_appl_eval_v.person_id%TYPE,
311: l_adm_apl_num igs_ad_appl_eval_v.admission_appl_number%TYPE,
312: l_nom_crs_cd igs_ad_appl_eval_v.nominated_course_cd%TYPE,
313: l_seq_num igs_ad_appl_eval_v.sequence_number%TYPE
314: ) IS
315: SELECT rating
316: FROM igs_ad_appl_eval_v
317: WHERE person_id = l_person_id

Line 316: FROM igs_ad_appl_eval_v

312: l_nom_crs_cd igs_ad_appl_eval_v.nominated_course_cd%TYPE,
313: l_seq_num igs_ad_appl_eval_v.sequence_number%TYPE
314: ) IS
315: SELECT rating
316: FROM igs_ad_appl_eval_v
317: WHERE person_id = l_person_id
318: AND admission_appl_number = l_adm_apl_num
319: AND nominated_course_cd = l_nom_crs_cd
320: AND sequence_number = l_seq_num

Line 341: l_rating igs_ad_appl_eval_v.rating%TYPE;

337: AND sequence_number = l_seq_number
338: AND doc.adm_doc_status = apl.adm_doc_status;
339:
340: l_adm_doc igs_ad_ps_appl_inst.adm_doc_status%TYPE;
341: l_rating igs_ad_appl_eval_v.rating%TYPE;
342: l_exist_arp igs_ad_appl_arp_v%ROWTYPE;
343: l_modif_eval_type igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;
344: l_exist_eval_type igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;
345: l_get_current_eval VARCHAR2(1);

Line 538: igs_ad_appl_eval_pkg.delete_row(del_dup_rec.rowid);

534: p_ADMISSION_APPL_NUMBER,
535: p_nominated_program_cd,
536: p_SEQUENCE_NUMBER)
537: LOOP
538: igs_ad_appl_eval_pkg.delete_row(del_dup_rec.rowid);
539: END LOOP;
540: END LOOP;
541:
542: EXCEPTION