[Home] [Help]
PACKAGE: APPS.IGS_AS_ASSESSMNT_ITM_PKG
Source
1 package IGS_AS_ASSESSMNT_ITM_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSDI38S.pls 115.8 2003/02/24 11:57:14 anilk ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_ORG_ID in NUMBER,
7 X_ASS_ID in NUMBER,
8 X_ASSESSMENT_TYPE in VARCHAR2,
9 X_DESCRIPTION in VARCHAR2,
10 X_EXAM_SHORT_PAPER_NAME in VARCHAR2,
11 X_EXAM_PAPER_NAME in VARCHAR2,
12 X_EXAM_WORKING_TIME in DATE,
13 X_EXAM_PERUSAL_TIME in DATE,
14 X_EXAM_SCHEDULED_IND in VARCHAR2,
15 X_EXAM_SUPERVISOR_INSTRCTN in VARCHAR2,
16 X_EXAM_ANNOUNCEMENTS in VARCHAR2,
17 X_EXAM_ALLOWABLE_INSTRCTN in VARCHAR2,
18 X_EXAM_NON_ALLOWED_INSTRCTN in VARCHAR2,
19 X_EXAM_SUPPLIED_INSTRCTN in VARCHAR2,
20 X_EXAM_CONSTRAINTS in VARCHAR2,
21 X_QUESTION_OR_TITLE in VARCHAR2,
22 X_ASS_LENGTH_OR_DURATION in VARCHAR2,
23 X_COMMENTS in VARCHAR2,
24 x_ATTRIBUTE_CATEGORY IN VARCHAR2 ,
25 x_ATTRIBUTE1 IN VARCHAR2 ,
26 x_ATTRIBUTE2 IN VARCHAR2 ,
27 x_ATTRIBUTE3 IN VARCHAR2 ,
28 x_ATTRIBUTE4 IN VARCHAR2 ,
29 x_ATTRIBUTE5 IN VARCHAR2 ,
30 x_ATTRIBUTE6 IN VARCHAR2 ,
31 x_ATTRIBUTE7 IN VARCHAR2 ,
32 x_ATTRIBUTE8 IN VARCHAR2 ,
33 x_ATTRIBUTE9 IN VARCHAR2 ,
34 x_ATTRIBUTE10 IN VARCHAR2 ,
35 x_ATTRIBUTE11 IN VARCHAR2 ,
36 x_ATTRIBUTE12 IN VARCHAR2 ,
37 x_ATTRIBUTE13 IN VARCHAR2 ,
38 x_ATTRIBUTE14 IN VARCHAR2 ,
39 x_ATTRIBUTE15 IN VARCHAR2 ,
40 x_ATTRIBUTE16 IN VARCHAR2 ,
41 x_ATTRIBUTE17 IN VARCHAR2 ,
42 x_ATTRIBUTE18 IN VARCHAR2 ,
43 x_ATTRIBUTE19 IN VARCHAR2 ,
44 x_ATTRIBUTE20 IN VARCHAR2 ,
45 X_MODE in VARCHAR2 default 'R' ,
46 -- anilk, bug#2784198
47 x_closed_ind IN VARCHAR2 DEFAULT NULL
48 );
49 procedure LOCK_ROW (
50 X_ROWID in VARCHAR2,
51 X_ASS_ID in NUMBER,
52 X_ASSESSMENT_TYPE in VARCHAR2,
53 X_DESCRIPTION in VARCHAR2,
54 X_EXAM_SHORT_PAPER_NAME in VARCHAR2,
55 X_EXAM_PAPER_NAME in VARCHAR2,
56 X_EXAM_WORKING_TIME in DATE,
57 X_EXAM_PERUSAL_TIME in DATE,
58 X_EXAM_SCHEDULED_IND in VARCHAR2,
59 X_EXAM_SUPERVISOR_INSTRCTN in VARCHAR2,
60 X_EXAM_ANNOUNCEMENTS in VARCHAR2,
61 X_EXAM_ALLOWABLE_INSTRCTN in VARCHAR2,
62 X_EXAM_NON_ALLOWED_INSTRCTN in VARCHAR2,
63 X_EXAM_SUPPLIED_INSTRCTN in VARCHAR2,
64 X_EXAM_CONSTRAINTS in VARCHAR2,
65 X_QUESTION_OR_TITLE in VARCHAR2,
66 X_ASS_LENGTH_OR_DURATION in VARCHAR2,
67 X_COMMENTS in VARCHAR2,
68 x_ATTRIBUTE_CATEGORY IN VARCHAR2 ,
69 x_ATTRIBUTE1 IN VARCHAR2 ,
70 x_ATTRIBUTE2 IN VARCHAR2 ,
71 x_ATTRIBUTE3 IN VARCHAR2 ,
72 x_ATTRIBUTE4 IN VARCHAR2 ,
73 x_ATTRIBUTE5 IN VARCHAR2 ,
74 x_ATTRIBUTE6 IN VARCHAR2 ,
75 x_ATTRIBUTE7 IN VARCHAR2 ,
76 x_ATTRIBUTE8 IN VARCHAR2 ,
77 x_ATTRIBUTE9 IN VARCHAR2 ,
78 x_ATTRIBUTE10 IN VARCHAR2 ,
79 x_ATTRIBUTE11 IN VARCHAR2 ,
80 x_ATTRIBUTE12 IN VARCHAR2 ,
81 x_ATTRIBUTE13 IN VARCHAR2 ,
82 x_ATTRIBUTE14 IN VARCHAR2 ,
83 x_ATTRIBUTE15 IN VARCHAR2 ,
84 x_ATTRIBUTE16 IN VARCHAR2 ,
85 x_ATTRIBUTE17 IN VARCHAR2 ,
86 x_ATTRIBUTE18 IN VARCHAR2 ,
87 x_ATTRIBUTE19 IN VARCHAR2 ,
88 x_ATTRIBUTE20 IN VARCHAR2 ,
89 -- anilk, bug#2784198
90 x_closed_ind IN VARCHAR2
91 );
92 procedure UPDATE_ROW (
93 X_ROWID in VARCHAR2,
94 X_ASS_ID in NUMBER,
95 X_ASSESSMENT_TYPE in VARCHAR2,
96 X_DESCRIPTION in VARCHAR2,
97 X_EXAM_SHORT_PAPER_NAME in VARCHAR2,
98 X_EXAM_PAPER_NAME in VARCHAR2,
99 X_EXAM_WORKING_TIME in DATE,
100 X_EXAM_PERUSAL_TIME in DATE,
101 X_EXAM_SCHEDULED_IND in VARCHAR2,
102 X_EXAM_SUPERVISOR_INSTRCTN in VARCHAR2,
103 X_EXAM_ANNOUNCEMENTS in VARCHAR2,
104 X_EXAM_ALLOWABLE_INSTRCTN in VARCHAR2,
105 X_EXAM_NON_ALLOWED_INSTRCTN in VARCHAR2,
106 X_EXAM_SUPPLIED_INSTRCTN in VARCHAR2,
107 X_EXAM_CONSTRAINTS in VARCHAR2,
108 X_QUESTION_OR_TITLE in VARCHAR2,
109 X_ASS_LENGTH_OR_DURATION in VARCHAR2,
110 X_COMMENTS in VARCHAR2,
111 x_ATTRIBUTE_CATEGORY IN VARCHAR2 ,
112 x_ATTRIBUTE1 IN VARCHAR2 ,
113 x_ATTRIBUTE2 IN VARCHAR2 ,
114 x_ATTRIBUTE3 IN VARCHAR2 ,
115 x_ATTRIBUTE4 IN VARCHAR2 ,
116 x_ATTRIBUTE5 IN VARCHAR2 ,
117 x_ATTRIBUTE6 IN VARCHAR2 ,
118 x_ATTRIBUTE7 IN VARCHAR2 ,
119 x_ATTRIBUTE8 IN VARCHAR2 ,
120 x_ATTRIBUTE9 IN VARCHAR2 ,
121 x_ATTRIBUTE10 IN VARCHAR2 ,
122 x_ATTRIBUTE11 IN VARCHAR2 ,
123 x_ATTRIBUTE12 IN VARCHAR2 ,
124 x_ATTRIBUTE13 IN VARCHAR2 ,
125 x_ATTRIBUTE14 IN VARCHAR2 ,
126 x_ATTRIBUTE15 IN VARCHAR2 ,
127 x_ATTRIBUTE16 IN VARCHAR2 ,
128 x_ATTRIBUTE17 IN VARCHAR2 ,
129 x_ATTRIBUTE18 IN VARCHAR2 ,
130 x_ATTRIBUTE19 IN VARCHAR2 ,
131 x_ATTRIBUTE20 IN VARCHAR2 ,
132 X_MODE in VARCHAR2 default 'R' ,
133 -- anilk, bug#2784198
134 x_closed_ind IN VARCHAR2 DEFAULT NULL
135 );
136 procedure ADD_ROW (
137 X_ROWID in out NOCOPY VARCHAR2,
138 X_ORG_ID in NUMBER,
139 X_ASS_ID in NUMBER,
140 X_ASSESSMENT_TYPE in VARCHAR2,
141 X_DESCRIPTION in VARCHAR2,
142 X_EXAM_SHORT_PAPER_NAME in VARCHAR2,
143 X_EXAM_PAPER_NAME in VARCHAR2,
144 X_EXAM_WORKING_TIME in DATE,
145 X_EXAM_PERUSAL_TIME in DATE,
146 X_EXAM_SCHEDULED_IND in VARCHAR2,
147 X_EXAM_SUPERVISOR_INSTRCTN in VARCHAR2,
148 X_EXAM_ANNOUNCEMENTS in VARCHAR2,
149 X_EXAM_ALLOWABLE_INSTRCTN in VARCHAR2,
150 X_EXAM_NON_ALLOWED_INSTRCTN in VARCHAR2,
151 X_EXAM_SUPPLIED_INSTRCTN in VARCHAR2,
152 X_EXAM_CONSTRAINTS in VARCHAR2,
153 X_QUESTION_OR_TITLE in VARCHAR2,
154 X_ASS_LENGTH_OR_DURATION in VARCHAR2,
155 X_COMMENTS in VARCHAR2,
156 x_ATTRIBUTE_CATEGORY IN VARCHAR2 ,
157 x_ATTRIBUTE1 IN VARCHAR2 ,
158 x_ATTRIBUTE2 IN VARCHAR2 ,
159 x_ATTRIBUTE3 IN VARCHAR2 ,
160 x_ATTRIBUTE4 IN VARCHAR2 ,
161 x_ATTRIBUTE5 IN VARCHAR2 ,
162 x_ATTRIBUTE6 IN VARCHAR2 ,
163 x_ATTRIBUTE7 IN VARCHAR2 ,
164 x_ATTRIBUTE8 IN VARCHAR2 ,
165 x_ATTRIBUTE9 IN VARCHAR2 ,
166 x_ATTRIBUTE10 IN VARCHAR2 ,
167 x_ATTRIBUTE11 IN VARCHAR2 ,
168 x_ATTRIBUTE12 IN VARCHAR2 ,
169 x_ATTRIBUTE13 IN VARCHAR2 ,
170 x_ATTRIBUTE14 IN VARCHAR2 ,
171 x_ATTRIBUTE15 IN VARCHAR2 ,
172 x_ATTRIBUTE16 IN VARCHAR2 ,
173 x_ATTRIBUTE17 IN VARCHAR2 ,
174 x_ATTRIBUTE18 IN VARCHAR2 ,
175 x_ATTRIBUTE19 IN VARCHAR2 ,
176 x_ATTRIBUTE20 IN VARCHAR2 ,
177 X_MODE in VARCHAR2 default 'R' ,
178 -- anilk, bug#2784198
179 x_closed_ind IN VARCHAR2 DEFAULT NULL
180 );
181
182 FUNCTION Get_PK_For_Validation (
183 x_ass_id IN NUMBER
184 ) RETURN BOOLEAN;
185
186 PROCEDURE GET_FK_IGS_AS_ASSESSMNT_TYP (
187 x_assessment_type IN VARCHAR2
188 );
189
190 PROCEDURE Check_Constraints (
191 Column_Name IN VARCHAR2 DEFAULT NULL,
192 Column_Value IN VARCHAR2 DEFAULT NULL
193 );
194
195 PROCEDURE Before_DML (
196 p_action IN VARCHAR2,
197 x_rowid IN VARCHAR2 DEFAULT NULL,
198 x_org_id IN NUMBER DEFAULT NULL,
199 x_ass_id IN NUMBER DEFAULT NULL,
200 x_assessment_type IN VARCHAR2 DEFAULT NULL,
201 x_description IN VARCHAR2 DEFAULT NULL,
202 x_exam_scheduled_ind IN VARCHAR2 DEFAULT NULL,
203 x_exam_working_time IN DATE DEFAULT NULL,
204 x_exam_announcements IN VARCHAR2 DEFAULT NULL,
205 x_exam_short_paper_name IN VARCHAR2 DEFAULT NULL,
206 x_exam_paper_name IN VARCHAR2 DEFAULT NULL,
207 x_exam_perusal_time IN DATE DEFAULT NULL,
208 x_exam_supervisor_instrctn IN VARCHAR2 DEFAULT NULL,
209 x_exam_allowable_instrctn IN VARCHAR2 DEFAULT NULL,
210 x_exam_non_allowed_instrctn IN VARCHAR2 DEFAULT NULL,
211 x_exam_supplied_instrctn IN VARCHAR2 DEFAULT NULL,
212 x_question_or_title IN VARCHAR2 DEFAULT NULL,
213 x_ass_length_or_duration IN VARCHAR2 DEFAULT NULL,
214 x_comments IN VARCHAR2 DEFAULT NULL,
215 x_exam_constraints IN VARCHAR2 DEFAULT NULL,
216 x_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
217 x_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
218 x_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
219 x_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
220 x_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
221 x_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
222 x_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
223 x_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
224 x_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
225 x_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
226 x_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
227 x_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
228 x_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
229 x_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
230 x_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
231 x_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
232 x_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
233 x_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
234 x_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
235 x_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
236 x_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL ,
237 x_creation_date IN DATE DEFAULT NULL,
238 x_created_by IN NUMBER DEFAULT NULL,
239 x_last_update_date IN DATE DEFAULT NULL,
240 x_last_updated_by IN NUMBER DEFAULT NULL,
241 x_last_update_login IN NUMBER DEFAULT NULL,
242 -- anilk, bug#2784198
243 x_closed_ind IN VARCHAR2 DEFAULT NULL
244 );
245
246 end IGS_AS_ASSESSMNT_ITM_PKG;