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_APL_REV_PRF

Line 120: CURSOR c_appl_rev_profile (cp_appl_rev_profile_id igs_ad_apl_rev_prf.appl_rev_profile_id%TYPE) IS

116: l_common_no_eval_prf_rec c_common_no_eval_prf%ROWTYPE;
117: l_common_no_eval_grp_rec c_common_no_eval_grp%ROWTYPE;
118:
119:
120: CURSOR c_appl_rev_profile (cp_appl_rev_profile_id igs_ad_apl_rev_prf.appl_rev_profile_id%TYPE) IS
121: SELECT review_profile_name
122: FROM igs_ad_apl_rev_prf
123: WHERE appl_rev_profile_id = cp_appl_rev_profile_id;
124:

Line 122: FROM igs_ad_apl_rev_prf

118:
119:
120: CURSOR c_appl_rev_profile (cp_appl_rev_profile_id igs_ad_apl_rev_prf.appl_rev_profile_id%TYPE) IS
121: SELECT review_profile_name
122: FROM igs_ad_apl_rev_prf
123: WHERE appl_rev_profile_id = cp_appl_rev_profile_id;
124:
125: l_review_profile_name igs_ad_apl_rev_prf.review_profile_name%TYPE;
126:

Line 125: l_review_profile_name igs_ad_apl_rev_prf.review_profile_name%TYPE;

121: SELECT review_profile_name
122: FROM igs_ad_apl_rev_prf
123: WHERE appl_rev_profile_id = cp_appl_rev_profile_id;
124:
125: l_review_profile_name igs_ad_apl_rev_prf.review_profile_name%TYPE;
126:
127: CURSOR c_appl_rev_group (cp_review_group_code igs_ad_apl_rprf_rgr.revprof_revgr_cd%TYPE) IS
128: SELECT revprof_revgr_cd
129: FROM igs_ad_apl_rprf_rgr

Line 317: CURSOR c_seq_conc_ind (cp_appl_rev_profile_id igs_ad_apl_rev_prf_all.APPL_REV_PROFILE_ID%TYPE) IS

313: ORDER BY evaluation_sequence;
314:
315: l_appl_rev_prof_evaluator_rec c_appl_rev_prof_evaluator%ROWTYPE;
316:
317: CURSOR c_seq_conc_ind (cp_appl_rev_profile_id igs_ad_apl_rev_prf_all.APPL_REV_PROFILE_ID%TYPE) IS
318: SELECT sequential_concurrent_ind
319: FROM igs_ad_apl_rev_prf_all
320: WHERE APPL_REV_PROFILE_ID = cp_appl_rev_profile_id;
321:

Line 319: FROM igs_ad_apl_rev_prf_all

315: l_appl_rev_prof_evaluator_rec c_appl_rev_prof_evaluator%ROWTYPE;
316:
317: CURSOR c_seq_conc_ind (cp_appl_rev_profile_id igs_ad_apl_rev_prf_all.APPL_REV_PROFILE_ID%TYPE) IS
318: SELECT sequential_concurrent_ind
319: FROM igs_ad_apl_rev_prf_all
320: WHERE APPL_REV_PROFILE_ID = cp_appl_rev_profile_id;
321:
322: l_seq_conc_ind igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;
323:

Line 322: l_seq_conc_ind igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;

318: SELECT sequential_concurrent_ind
319: FROM igs_ad_apl_rev_prf_all
320: WHERE APPL_REV_PROFILE_ID = cp_appl_rev_profile_id;
321:
322: l_seq_conc_ind igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;
323:
324: CURSOR c_arp_rate_scale(cp_appl_rev_profile_id number) IS
325: SELECT *
326: FROM igs_ad_apl_rvpf_rsl arr

Line 337: CURSOR c_appl_rev_profile (cp_appl_rev_profile_id igs_ad_apl_rev_prf.appl_rev_profile_id%TYPE) 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
338: SELECT review_profile_name
339: FROM igs_ad_apl_rev_prf
340: WHERE appl_rev_profile_id = cp_appl_rev_profile_id;
341:

Line 339: FROM igs_ad_apl_rev_prf

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
338: SELECT review_profile_name
339: FROM igs_ad_apl_rev_prf
340: WHERE appl_rev_profile_id = cp_appl_rev_profile_id;
341:
342: l_review_profile_name igs_ad_apl_rev_prf.review_profile_name%TYPE;
343:

Line 342: l_review_profile_name igs_ad_apl_rev_prf.review_profile_name%TYPE;

338: SELECT review_profile_name
339: FROM igs_ad_apl_rev_prf
340: WHERE appl_rev_profile_id = cp_appl_rev_profile_id;
341:
342: l_review_profile_name igs_ad_apl_rev_prf.review_profile_name%TYPE;
343:
344:
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,

Line 850: igs_ad_apl_rev_prf_all

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

Line 889: l_exist_eval_type igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;

885: AND sequence_number = cp_seq_number
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);