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_ASSIGN_EVAL_AI_PKG dependencies on IGS_AD_APPL_EVAL_S

Line 331: CURSOR c_igs_ad_appl_eval_s

327: WHERE arr.appl_rev_profile_id = cp_appl_rev_profile_id;
328:
329: arp_rate_scale_rec c_arp_rate_scale%ROWTYPE;
330:
331: CURSOR c_igs_ad_appl_eval_s
332: IS
333: SELECT Igs_ad_appl_eval_s.nextval
334: FROM DUAL;
335:

Line 333: SELECT Igs_ad_appl_eval_s.nextval

329: arp_rate_scale_rec c_arp_rate_scale%ROWTYPE;
330:
331: CURSOR c_igs_ad_appl_eval_s
332: IS
333: SELECT Igs_ad_appl_eval_s.nextval
334: FROM DUAL;
335:
336: -- Cursor fetching the review_profile_name for the corresponding review profile id (rghosh bug#2871426)
337: CURSOR c_appl_rev_profile (cp_appl_rev_profile_id igs_ad_apl_rev_prf.appl_rev_profile_id%TYPE) IS

Line 349: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE ) IS

345: -- Cursor to get the existing evaluators (rghosh bug #2986802)
346: CURSOR c_existing_evaluators (cp_person_id igs_ad_appl_eval.person_id%TYPE,
347: cp_admission_appl_number igs_ad_appl_eval.admission_appl_number%TYPE,
348: cp_nominated_course_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
349: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE ) IS
350: SELECT *
351: FROM igs_ad_appl_eval_v
352: WHERE person_id = cp_person_id
353: AND admission_appl_number = cp_admission_appl_number

Line 363: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE) IS

359: -- Cursor to fetch the next evaluation sequence that is available for that particular application instance (rghosh bug #2986802)
360: CURSOR c_max_evaluation_sequence(cp_person_id igs_ad_appl_eval.person_id%TYPE,
361: cp_admission_appl_number igs_ad_appl_eval.admission_appl_number%TYPE,
362: cp_nominated_course_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
363: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE) IS
364: SELECT (max(evaluation_sequence))
365: FROM igs_ad_appl_eval
366: WHERE person_id = cp_person_id
367: AND admission_appl_number = cp_admission_appl_number

Line 391: l_igs_ad_appl_eval_s NUMBER;

387: l_evaluators_exists VARCHAR2(1);
388: l_matching_ind VARCHAR2(1);
389:
390: lv_rowid VARCHAR2(25);
391: l_igs_ad_appl_eval_s NUMBER;
392: l_sequence_number NUMBER:= 0;
393: i NUMBER:= 0;
394: l_exists VARCHAR2(1);
395: l_list_count BINARY_INTEGER := 0 ;

Line 479: OPEN c_igs_ad_appl_eval_s;

475: FETCH c_arp_rate_scale INTO arp_rate_scale_rec;
476: EXIT WHEN c_arp_rate_scale%NOTFOUND;
477:
478: -- Get the next sequence value for table igs_ad_appl_eval.
479: OPEN c_igs_ad_appl_eval_s;
480: FETCH c_igs_ad_appl_eval_s INTO l_igs_ad_appl_eval_s;
481: CLOSE c_igs_ad_appl_eval_s;
482: l_rating_exists := 'Y';
483: Igs_ad_appl_eval_pkg.insert_row(

Line 480: FETCH c_igs_ad_appl_eval_s INTO l_igs_ad_appl_eval_s;

476: EXIT WHEN c_arp_rate_scale%NOTFOUND;
477:
478: -- Get the next sequence value for table igs_ad_appl_eval.
479: OPEN c_igs_ad_appl_eval_s;
480: FETCH c_igs_ad_appl_eval_s INTO l_igs_ad_appl_eval_s;
481: CLOSE c_igs_ad_appl_eval_s;
482: l_rating_exists := 'Y';
483: Igs_ad_appl_eval_pkg.insert_row(
484: x_rowid => lv_rowid,

Line 481: CLOSE c_igs_ad_appl_eval_s;

477:
478: -- Get the next sequence value for table igs_ad_appl_eval.
479: OPEN c_igs_ad_appl_eval_s;
480: FETCH c_igs_ad_appl_eval_s INTO l_igs_ad_appl_eval_s;
481: CLOSE c_igs_ad_appl_eval_s;
482: l_rating_exists := 'Y';
483: Igs_ad_appl_eval_pkg.insert_row(
484: x_rowid => lv_rowid,
485: x_appl_eval_id => l_igs_ad_appl_eval_s,

Line 485: x_appl_eval_id => l_igs_ad_appl_eval_s,

481: CLOSE c_igs_ad_appl_eval_s;
482: l_rating_exists := 'Y';
483: Igs_ad_appl_eval_pkg.insert_row(
484: x_rowid => lv_rowid,
485: x_appl_eval_id => l_igs_ad_appl_eval_s,
486: x_person_id => p_person_id,
487: x_admission_appl_number => p_admission_appl_number,
488: x_nominated_course_cd => p_nominated_course_cd,
489: x_sequence_number=> p_sequence_number,

Line 863: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE) IS

859: CURSOR c_max_evaluation_sequence(
860: cp_person_id igs_ad_appl_eval.person_id%TYPE,
861: cp_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
862: cp_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
863: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE) IS
864: SELECT
865: (max(evaluation_sequence)+1)
866: FROM
867: igs_ad_appl_eval

Line 878: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE,

874: CURSOR c_next_seq (
875: cp_person_id igs_ad_appl_eval.person_id%TYPE,
876: cp_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
877: cp_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
878: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE,
879: cp_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE) IS
880: SELECT *
881: FROM igs_ad_appl_eval
882: WHERE person_id = cp_person_id