1 PACKAGE igs_ad_assign_eval_ai_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSADB4S.pls 115.10 2003/06/06 22:27:42 tmajumde noship $ */
3
4 PROCEDURE Assign_Eval_To_Appl_Inst(
5 Errbuf OUT NOCOPY VARCHAR2,
6 Retcode OUT NOCOPY NUMBER,
7 p_review_profile_id IN NUMBER DEFAULT NULL,
8 p_review_group_code IN NUMBER DEFAULT NULL,
9 p_unassigned_appl IN VARCHAR2 DEFAULT NULL,
10 p_org_id IN NUMBER
11 );
12
13 PROCEDURE Assign_Eval_To_Ai(
14 Errbuf OUT NOCOPY VARCHAR2,
15 Retcode OUT NOCOPY NUMBER,
16 p_appl_rev_profile_id IN NUMBER,
17 p_appl_revprof_revgr_id IN NUMBER,
18 p_person_id IN NUMBER,
19 p_admission_appl_number IN NUMBER,
20 p_nominated_course_cd IN VARCHAR2,
21 p_sequence_number IN NUMBER );
22
23 PROCEDURE Wf_Inform_Evaluator_Appl
24 ( p_evaluator_id IN NUMBER,
25 p_evaluator_name IN VARCHAR2,
26 p_evaluator_full_name IN VARCHAR2
27 );
28
29 FUNCTION rule_function (p_subscription in RAW,
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,
39 p_roletype IN VARCHAR2 DEFAULT NULL,
40 p_eval_type IN VARCHAR2,
41 p_eval_seq_number IN NUMBER)
42 RETURN VARCHAR2;
43
44 -- this procedure will set the package variable g_dns_ind according to the value of the checkbox do not send notification in ratings forms(IGSAD090)
45 -- rghosh (bug # 2871426 - Evaluator entry and assignment
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,
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;
58
59 END igs_ad_assign_eval_ai_pkg ;