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_ARP

Line 35: CURSOR c_common_no_eval(cp_review_profile_id igs_ad_appl_arp.appl_rev_profile_id%TYPE,

31: l_rating_exists VARCHAR2(1);
32: l_appl_revprof_revgr_id igs_ad_apl_rprf_rgr.appl_revprof_revgr_id%TYPE;
33:
34:
35: CURSOR c_common_no_eval(cp_review_profile_id igs_ad_appl_arp.appl_rev_profile_id%TYPE,
36: cp_appl_revprof_revgr_id igs_ad_appl_arp.appl_revprof_revgr_id%TYPE) IS
37: SELECT apl.person_id,
38: apl.admission_appl_number,
39: apl.nominated_course_cd,

Line 36: cp_appl_revprof_revgr_id igs_ad_appl_arp.appl_revprof_revgr_id%TYPE) IS

32: l_appl_revprof_revgr_id igs_ad_apl_rprf_rgr.appl_revprof_revgr_id%TYPE;
33:
34:
35: CURSOR c_common_no_eval(cp_review_profile_id igs_ad_appl_arp.appl_rev_profile_id%TYPE,
36: cp_appl_revprof_revgr_id igs_ad_appl_arp.appl_revprof_revgr_id%TYPE) IS
37: SELECT apl.person_id,
38: apl.admission_appl_number,
39: apl.nominated_course_cd,
40: apl.sequence_number,

Line 44: igs_ad_appl_arp arp

40: apl.sequence_number,
41: arp.appl_rev_profile_id,
42: arp.appl_revprof_revgr_id
43: FROM igs_ad_ps_appl_inst_all apl,
44: igs_ad_appl_arp arp
45: WHERE apl.person_id = arp.person_id
46: AND apl.admission_appl_number = arp.admission_appl_number
47: AND apl.nominated_course_cd = arp.nominated_course_cd
48: AND apl.sequence_number = arp.sequence_number

Line 61: CURSOR c_common_no_eval_prf(cp_review_profile_id igs_ad_appl_arp.appl_rev_profile_id%TYPE,

57: AND aev.admission_appl_number = apl.admission_appl_number
58: AND aev.nominated_course_cd = apl.nominated_course_cd
59: AND aev.sequence_number = apl.sequence_number );
60:
61: CURSOR c_common_no_eval_prf(cp_review_profile_id igs_ad_appl_arp.appl_rev_profile_id%TYPE,
62: cp_appl_revprof_revgr_id igs_ad_appl_arp.appl_revprof_revgr_id%TYPE) IS
63: SELECT apl.person_id,
64: apl.admission_appl_number,
65: apl.nominated_course_cd,

Line 62: cp_appl_revprof_revgr_id igs_ad_appl_arp.appl_revprof_revgr_id%TYPE) IS

58: AND aev.nominated_course_cd = apl.nominated_course_cd
59: AND aev.sequence_number = apl.sequence_number );
60:
61: CURSOR c_common_no_eval_prf(cp_review_profile_id igs_ad_appl_arp.appl_rev_profile_id%TYPE,
62: cp_appl_revprof_revgr_id igs_ad_appl_arp.appl_revprof_revgr_id%TYPE) IS
63: SELECT apl.person_id,
64: apl.admission_appl_number,
65: apl.nominated_course_cd,
66: apl.sequence_number,

Line 70: igs_ad_appl_arp arp

66: apl.sequence_number,
67: arp.appl_rev_profile_id,
68: arp.appl_revprof_revgr_id
69: FROM igs_ad_ps_appl_inst_all apl,
70: igs_ad_appl_arp arp
71: WHERE apl.person_id = arp.person_id
72: AND apl.admission_appl_number = arp.admission_appl_number
73: AND apl.nominated_course_cd = arp.nominated_course_cd
74: AND apl.sequence_number = arp.sequence_number

Line 88: CURSOR c_common_no_eval_grp(cp_review_profile_id igs_ad_appl_arp.appl_rev_profile_id%TYPE,

84: AND aev.nominated_course_cd = apl.nominated_course_cd
85: AND aev.sequence_number = apl.sequence_number )
86: AND arp.appl_rev_profile_id = cp_review_profile_id;
87:
88: CURSOR c_common_no_eval_grp(cp_review_profile_id igs_ad_appl_arp.appl_rev_profile_id%TYPE,
89: cp_appl_revprof_revgr_id igs_ad_appl_arp.appl_revprof_revgr_id%TYPE) IS
90: SELECT apl.person_id,
91: apl.admission_appl_number,
92: apl.nominated_course_cd,

Line 89: cp_appl_revprof_revgr_id igs_ad_appl_arp.appl_revprof_revgr_id%TYPE) IS

85: AND aev.sequence_number = apl.sequence_number )
86: AND arp.appl_rev_profile_id = cp_review_profile_id;
87:
88: CURSOR c_common_no_eval_grp(cp_review_profile_id igs_ad_appl_arp.appl_rev_profile_id%TYPE,
89: cp_appl_revprof_revgr_id igs_ad_appl_arp.appl_revprof_revgr_id%TYPE) IS
90: SELECT apl.person_id,
91: apl.admission_appl_number,
92: apl.nominated_course_cd,
93: apl.sequence_number,

Line 97: igs_ad_appl_arp arp

93: apl.sequence_number,
94: arp.appl_rev_profile_id,
95: arp.appl_revprof_revgr_id
96: FROM igs_ad_ps_appl_inst_all apl,
97: igs_ad_appl_arp arp
98: WHERE apl.person_id = arp.person_id
99: AND apl.admission_appl_number = arp.admission_appl_number
100: AND apl.nominated_course_cd = arp.nominated_course_cd
101: AND apl.sequence_number = arp.sequence_number

Line 843: CURSOR eval_type_cur( cp_person_id igs_ad_appl_arp.person_id%TYPE,

839: p_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,
840: p_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,
841: p_rating_scale_id igs_ad_appl_eval.rating_scale_id%TYPE ) RETURN NUMBER IS
842:
843: CURSOR eval_type_cur( cp_person_id igs_ad_appl_arp.person_id%TYPE,
844: cp_admission_appl_number igs_ad_appl_arp.admission_appl_number%TYPE,
845: cp_nominated_course_cd igs_ad_appl_arp.nominated_course_cd%TYPE,
846: cp_sequence_number igs_ad_appl_arp.sequence_number%TYPE) IS
847: SELECT

Line 844: cp_admission_appl_number igs_ad_appl_arp.admission_appl_number%TYPE,

840: p_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,
841: p_rating_scale_id igs_ad_appl_eval.rating_scale_id%TYPE ) RETURN NUMBER IS
842:
843: CURSOR eval_type_cur( cp_person_id igs_ad_appl_arp.person_id%TYPE,
844: cp_admission_appl_number igs_ad_appl_arp.admission_appl_number%TYPE,
845: cp_nominated_course_cd igs_ad_appl_arp.nominated_course_cd%TYPE,
846: cp_sequence_number igs_ad_appl_arp.sequence_number%TYPE) IS
847: SELECT
848: distinct sequential_concurrent_ind

Line 845: cp_nominated_course_cd igs_ad_appl_arp.nominated_course_cd%TYPE,

841: p_rating_scale_id igs_ad_appl_eval.rating_scale_id%TYPE ) RETURN NUMBER IS
842:
843: CURSOR eval_type_cur( cp_person_id igs_ad_appl_arp.person_id%TYPE,
844: cp_admission_appl_number igs_ad_appl_arp.admission_appl_number%TYPE,
845: cp_nominated_course_cd igs_ad_appl_arp.nominated_course_cd%TYPE,
846: cp_sequence_number igs_ad_appl_arp.sequence_number%TYPE) IS
847: SELECT
848: distinct sequential_concurrent_ind
849: FROM

Line 846: cp_sequence_number igs_ad_appl_arp.sequence_number%TYPE) IS

842:
843: CURSOR eval_type_cur( cp_person_id igs_ad_appl_arp.person_id%TYPE,
844: cp_admission_appl_number igs_ad_appl_arp.admission_appl_number%TYPE,
845: cp_nominated_course_cd igs_ad_appl_arp.nominated_course_cd%TYPE,
846: cp_sequence_number igs_ad_appl_arp.sequence_number%TYPE) IS
847: SELECT
848: distinct sequential_concurrent_ind
849: FROM
850: igs_ad_apl_rev_prf_all

Line 853: from igs_ad_appl_arp

849: FROM
850: igs_ad_apl_rev_prf_all
851: WHERE
852: appl_rev_profile_id = (select appl_rev_profile_id
853: from igs_ad_appl_arp
854: where person_id = cp_person_id
855: and admission_appl_number = cp_admission_appl_number
856: and nominated_course_cd = cp_nominated_course_cd
857: and sequence_number = cp_sequence_number);

Line 890: l_exist_arp_id igs_ad_appl_arp_v.appl_rev_profile_id%TYPE;

886: AND evaluator_id = cp_evaluator_id;
887:
888: l_next_seq c_next_seq%ROWTYPE;
889: l_exist_eval_type igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;
890: l_exist_arp_id igs_ad_appl_arp_v.appl_rev_profile_id%TYPE;
891: l_count igs_ad_appl_eval.evaluation_sequence%TYPE;
892: l_max_evaluation_sequence igs_ad_appl_eval.evaluation_sequence%TYPE;
893: l_chk_rating_val_null VARCHAR2(1);
894: