DBA Data[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;