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_PS_APPL_INST_ALL

Line 43: FROM igs_ad_ps_appl_inst_all apl,

39: apl.nominated_course_cd,
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

Line 69: FROM igs_ad_ps_appl_inst_all apl,

65: apl.nominated_course_cd,
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

Line 96: FROM igs_ad_ps_appl_inst_all apl,

92: apl.nominated_course_cd,
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

Line 651: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,

647:
648: /*************************************/
649:
650: Function Calc_Ratstat(
651: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
652: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
653: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
654: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
655: p_faculty_id IN igs_ad_appl_eval.evaluator_id%TYPE,

Line 652: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

648: /*************************************/
649:
650: Function Calc_Ratstat(
651: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
652: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
653: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
654: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
655: p_faculty_id IN igs_ad_appl_eval.evaluator_id%TYPE,
656: p_roletype IN VARCHAR2,

Line 653: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

649:
650: Function Calc_Ratstat(
651: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
652: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
653: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
654: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
655: p_faculty_id IN igs_ad_appl_eval.evaluator_id%TYPE,
656: p_roletype IN VARCHAR2,
657: p_eval_type IN VARCHAR2,

Line 654: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,

650: Function Calc_Ratstat(
651: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
652: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
653: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
654: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
655: p_faculty_id IN igs_ad_appl_eval.evaluator_id%TYPE,
656: p_roletype IN VARCHAR2,
657: p_eval_type IN VARCHAR2,
658: p_eval_seq_number IN NUMBER)

Line 835: FUNCTION set_eval_sequence (p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

831: END set_dns_ind;
832:
833: --this function will return the value of the next sequence number that has to be assigned to new evaluator who is added manually
834: -- rghosh (bug#2871426 - Evaluator entry and assignment)
835: FUNCTION set_eval_sequence (p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
836: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
837: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
838: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
839: p_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,

Line 836: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

832:
833: --this function will return the value of the next sequence number that has to be assigned to new evaluator who is added manually
834: -- rghosh (bug#2871426 - Evaluator entry and assignment)
835: FUNCTION set_eval_sequence (p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
836: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
837: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
838: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%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,

Line 837: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

833: --this function will return the value of the next sequence number that has to be assigned to new evaluator who is added manually
834: -- rghosh (bug#2871426 - Evaluator entry and assignment)
835: FUNCTION set_eval_sequence (p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
836: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
837: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
838: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%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

Line 838: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

834: -- rghosh (bug#2871426 - Evaluator entry and assignment)
835: FUNCTION set_eval_sequence (p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
836: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
837: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
838: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%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: