1 PACKAGE igs_ad_appl_eval_pkg AS
2 /* $Header: IGSAIA4S.pls 120.0 2005/06/01 22:08:02 appldev noship $ */
3
4 g_dns_ind VARCHAR2(1) := 'N';
5
6 PROCEDURE insert_row (
7 x_rowid IN OUT NOCOPY VARCHAR2,
8 x_appl_eval_id IN OUT NOCOPY NUMBER,
9 x_person_id IN NUMBER,
10 x_admission_appl_number IN NUMBER,
11 x_nominated_course_cd IN VARCHAR2,
12 x_sequence_number IN NUMBER,
13 x_evaluator_id IN NUMBER,
14 x_assign_type IN VARCHAR2,
15 x_assign_date IN DATE,
16 x_evaluation_date IN DATE,
17 x_rating_type_id IN NUMBER,
18 x_rating_values_id IN NUMBER,
19 x_rating_notes IN VARCHAR2,
20 x_mode IN VARCHAR2 default 'R',
21 x_evaluation_sequence IN NUMBER DEFAULT NULL,
22 x_rating_scale_id IN NUMBER DEFAULT NULL,
23 x_closed_ind IN VARCHAR2
24 );
25
26 PROCEDURE lock_row (
27 x_rowid IN VARCHAR2,
28 x_appl_eval_id IN NUMBER,
29 x_person_id IN NUMBER,
30 x_admission_appl_number IN NUMBER,
31 x_nominated_course_cd IN VARCHAR2,
32 x_sequence_number IN NUMBER,
33 x_evaluator_id IN NUMBER,
34 x_assign_type IN VARCHAR2,
35 x_assign_date IN DATE,
36 x_evaluation_date IN DATE,
37 x_rating_type_id IN NUMBER,
38 x_rating_values_id IN NUMBER,
39 x_rating_notes IN VARCHAR2,
40 x_evaluation_sequence IN NUMBER DEFAULT NULL,
41 x_rating_scale_id IN NUMBER DEFAULT NULL,
42 x_closed_ind IN VARCHAR2
43 );
44
45 PROCEDURE update_row (
46 x_rowid IN VARCHAR2,
47 x_appl_eval_id IN NUMBER,
48 x_person_id IN NUMBER,
49 x_admission_appl_number IN NUMBER,
50 x_nominated_course_cd IN VARCHAR2,
51 x_sequence_number IN NUMBER,
52 x_evaluator_id IN NUMBER,
53 x_assign_type IN VARCHAR2,
54 x_assign_date IN DATE,
55 x_evaluation_date IN DATE,
56 x_rating_type_id IN NUMBER,
57 x_rating_values_id IN NUMBER,
58 x_rating_notes IN VARCHAR2,
59 x_mode IN VARCHAR2 default 'R',
60 x_evaluation_sequence IN NUMBER DEFAULT NULL,
61 x_rating_scale_id IN NUMBER DEFAULT NULL,
62 x_closed_ind IN VARCHAR2
63 );
64
65 PROCEDURE add_row (
66 x_rowid IN OUT NOCOPY VARCHAR2,
67 x_appl_eval_id IN OUT NOCOPY NUMBER,
68 x_person_id IN NUMBER,
69 x_admission_appl_number IN NUMBER,
70 x_nominated_course_cd IN VARCHAR2,
71 x_sequence_number IN NUMBER,
72 x_evaluator_id IN NUMBER,
73 x_assign_type IN VARCHAR2,
74 x_assign_date IN DATE,
75 x_evaluation_date IN DATE,
76 x_rating_type_id IN NUMBER,
77 x_rating_values_id IN NUMBER,
78 x_rating_notes IN VARCHAR2,
79 x_mode IN VARCHAR2 default 'R',
80 x_evaluation_sequence IN NUMBER DEFAULT NULL,
81 x_rating_scale_id IN NUMBER DEFAULT NULL,
82 x_closed_ind IN VARCHAR2
83 ) ;
84
85 PROCEDURE delete_row (
86 x_rowid in VARCHAR2,
87 x_mode IN VARCHAR2 DEFAULT 'R'
88 ) ;
89 FUNCTION Get_PK_For_Validation (
90 x_appl_eval_id IN NUMBER,
91 x_closed_ind IN VARCHAR2 DEFAULT NULL
92 ) RETURN BOOLEAN ;
93
94 PROCEDURE Get_FK_Igs_Ad_Rs_Values (
95 x_rating_values_id IN NUMBER
96 );
97
98 PROCEDURE Get_FK_Igs_Ad_Code_Classes (
99 x_code_id IN NUMBER
100 );
101
102 PROCEDURE Get_FK_Igs_Ad_Ps_Appl_Inst (
103 x_person_id IN NUMBER,
104 x_admission_appl_number IN NUMBER,
105 x_nominated_course_cd IN VARCHAR2,
106 x_sequence_number IN NUMBER
107 );
108
109 PROCEDURE Get_FK_Igs_Pe_Person (
110 x_person_id IN NUMBER
111 );
112 PROCEDURE Get_FK_Igs_Ad_Rating_Scales(
113 x_rating_scale_id IN NUMBER
114 );
115
116 PROCEDURE Check_Constraints (
117 Column_Name IN VARCHAR2 DEFAULT NULL,
118 Column_Value IN VARCHAR2 DEFAULT NULL ) ;
119
120 PROCEDURE Before_DML (
121 p_action IN VARCHAR2,
122 x_rowid IN VARCHAR2 DEFAULT NULL,
123 x_appl_eval_id IN NUMBER DEFAULT NULL,
124 x_person_id IN NUMBER DEFAULT NULL,
125 x_admission_appl_number IN NUMBER DEFAULT NULL,
126 x_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
127 x_sequence_number IN NUMBER DEFAULT NULL,
128 x_evaluator_id IN NUMBER DEFAULT NULL,
129 x_assign_type IN VARCHAR2 DEFAULT NULL,
130 x_assign_date IN DATE DEFAULT NULL,
131 x_evaluation_date IN DATE DEFAULT NULL,
132 x_rating_type_id IN NUMBER DEFAULT NULL,
133 x_rating_values_id IN NUMBER DEFAULT NULL,
134 x_rating_notes IN VARCHAR2 DEFAULT NULL,
135 x_creation_date IN DATE DEFAULT NULL,
136 x_created_by IN NUMBER DEFAULT NULL,
137 x_last_update_date IN DATE DEFAULT NULL,
138 x_last_updated_by IN NUMBER DEFAULT NULL,
139 x_last_update_login IN NUMBER DEFAULT NULL,
140 x_evaluation_sequence IN NUMBER DEFAULT NULL,
141 x_rating_scale_id IN NUMBER DEFAULT NULL,
142 x_closed_ind IN VARCHAR2 DEFAULT NULL
143 );
144
145 PROCEDURE After_DML (
146 p_action IN VARCHAR2,
147 x_rowid IN VARCHAR2
148 );
149 PROCEDURE wf_evaluator_validation (
150 x_person_id IN NUMBER,
151 x_admission_appl_number IN NUMBER,
152 x_nominated_course_cd IN VARCHAR2,
153 x_sequence_number IN NUMBER,
154 x_eval_seq IN NUMBER
155 );
156
157 procedure Notification_On_Delete(
158 x_person_id IN NUMBER,
159 x_admission_appl_number IN NUMBER,
160 x_NOMINATED_COURSE_CD IN VARCHAR2,
161 x_SEQUENCE_NUMBER IN NUMBER,
162 x_eval_seq IN NUMBER
163 );
164
165 function find_prev_seq_number(
166 x_person_id IN NUMBER,
167 x_admission_appl_number IN NUMBER,
168 x_NOMINATED_COURSE_CD IN VARCHAR2,
169 x_SEQUENCE_NUMBER IN NUMBER,
170 x_eval_seq IN NUMBER
171 ) RETURN NUMBER;
172
173 FUNCTION find_next_eval (
174 x_person_id IN NUMBER,
175 x_admission_appl_number IN NUMBER,
176 x_NOMINATED_COURSE_CD IN VARCHAR2,
177 x_SEQUENCE_NUMBER IN NUMBER,
178 x_eval_seq IN NUMBER
179 ) RETURN NUMBER;
180
181 END igs_ad_appl_eval_pkg;