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 34: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,

30: p_event in out NOCOPY WF_EVENT_T) return varchar2;
31:
32:
33: FUNCTION Calc_Ratstat(
34: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
35: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
36: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
37: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
38: p_faculty_id IN igs_ad_appl_eval.evaluator_id%TYPE,

Line 35: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

31:
32:
33: FUNCTION Calc_Ratstat(
34: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
35: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
36: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
37: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
38: p_faculty_id IN igs_ad_appl_eval.evaluator_id%TYPE,
39: p_roletype IN VARCHAR2 DEFAULT NULL,

Line 36: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

32:
33: FUNCTION Calc_Ratstat(
34: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
35: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
36: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
37: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
38: p_faculty_id IN igs_ad_appl_eval.evaluator_id%TYPE,
39: p_roletype IN VARCHAR2 DEFAULT NULL,
40: p_eval_type IN VARCHAR2,

Line 37: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,

33: FUNCTION Calc_Ratstat(
34: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
35: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
36: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
37: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
38: p_faculty_id IN igs_ad_appl_eval.evaluator_id%TYPE,
39: p_roletype IN VARCHAR2 DEFAULT NULL,
40: p_eval_type IN VARCHAR2,
41: p_eval_seq_number IN NUMBER)

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

46: PROCEDURE set_dns_ind (x_do_not_send_notif IN VARCHAR2);
47:
48: --this function will return the value of the next sequence number that has to be assigned to new evaluator who is added manually
49: -- rghosh (bug#2871426 - Evaluator entry and assignment)
50: FUNCTION set_eval_sequence (p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
51: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
52: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
53: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
54: p_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,

Line 51: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

47:
48: --this function will return the value of the next sequence number that has to be assigned to new evaluator who is added manually
49: -- rghosh (bug#2871426 - Evaluator entry and assignment)
50: FUNCTION set_eval_sequence (p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
51: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
52: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
53: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
54: p_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,
55: p_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,

Line 52: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

48: --this function will return the value of the next sequence number that has to be assigned to new evaluator who is added manually
49: -- rghosh (bug#2871426 - Evaluator entry and assignment)
50: FUNCTION set_eval_sequence (p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
51: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
52: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
53: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
54: p_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,
55: p_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,
56: p_rating_scale_id igs_ad_appl_eval.rating_scale_id%TYPE )

Line 53: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

49: -- rghosh (bug#2871426 - Evaluator entry and assignment)
50: FUNCTION set_eval_sequence (p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
51: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
52: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
53: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
54: p_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,
55: p_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,
56: p_rating_scale_id igs_ad_appl_eval.rating_scale_id%TYPE )
57: RETURN NUMBER;