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.
PACKAGE: APPS.IGS_AS_EXAM_INSTANCE_PKG

Source


1 package IGS_AS_EXAM_INSTANCE_PKG AUTHID CURRENT_USER AS
2  /* $Header: IGSDI04S.pls 115.4 2002/11/28 23:11:18 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ASS_ID in NUMBER,
6   X_ORG_ID in NUMBER,
7   X_EXAM_CAL_TYPE in VARCHAR2,
8   X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
9   X_DT_ALIAS in VARCHAR2,
10   X_DAI_SEQUENCE_NUMBER in NUMBER,
11   X_START_TIME in DATE,
12   X_END_TIME in DATE,
13   X_VENUE_CD in VARCHAR2,
14   X_ESE_ID in NUMBER,
15   X_COLLECT_PERSON_ID in NUMBER,
16   X_SPECIAL_SESSION_IND in VARCHAR2,
17   X_OVERRIDE_START_TIME in DATE,
18   X_OVERRIDE_END_TIME in DATE,
19   X_SPECIAL_ANNOUNCEMENTS in VARCHAR2,
20   X_SPECIAL_INSTRUCTIONS in VARCHAR2,
21   X_WORKED_SCRIPT_INSTRUCTIONS in VARCHAR2,
22   X_COMMENTS in VARCHAR2,
23   X_MODE in VARCHAR2 default 'R'
24   );
25 procedure LOCK_ROW (
26   X_ROWID in VARCHAR2,
27   X_ASS_ID in NUMBER,
28   X_EXAM_CAL_TYPE in VARCHAR2,
29   X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
30   X_DT_ALIAS in VARCHAR2,
31   X_DAI_SEQUENCE_NUMBER in NUMBER,
32   X_START_TIME in DATE,
33   X_END_TIME in DATE,
34   X_VENUE_CD in VARCHAR2,
35   X_ESE_ID in NUMBER,
36   X_COLLECT_PERSON_ID in NUMBER,
37   X_SPECIAL_SESSION_IND in VARCHAR2,
38   X_OVERRIDE_START_TIME in DATE,
39   X_OVERRIDE_END_TIME in DATE,
40   X_SPECIAL_ANNOUNCEMENTS in VARCHAR2,
41   X_SPECIAL_INSTRUCTIONS in VARCHAR2,
42   X_WORKED_SCRIPT_INSTRUCTIONS in VARCHAR2,
43   X_COMMENTS in VARCHAR2
44 );
45 procedure UPDATE_ROW (
46   X_ROWID in VARCHAR2,
47   X_ASS_ID in NUMBER,
48   X_EXAM_CAL_TYPE in VARCHAR2,
49   X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
50   X_DT_ALIAS in VARCHAR2,
51   X_DAI_SEQUENCE_NUMBER in NUMBER,
52   X_START_TIME in DATE,
53   X_END_TIME in DATE,
54   X_VENUE_CD in VARCHAR2,
55   X_ESE_ID in NUMBER,
56   X_COLLECT_PERSON_ID in NUMBER,
57   X_SPECIAL_SESSION_IND in VARCHAR2,
58   X_OVERRIDE_START_TIME in DATE,
59   X_OVERRIDE_END_TIME in DATE,
60   X_SPECIAL_ANNOUNCEMENTS in VARCHAR2,
61   X_SPECIAL_INSTRUCTIONS in VARCHAR2,
62   X_WORKED_SCRIPT_INSTRUCTIONS in VARCHAR2,
63   X_COMMENTS in VARCHAR2,
64   X_MODE in VARCHAR2 default 'R'
65   );
66 procedure ADD_ROW (
67   X_ROWID in out NOCOPY VARCHAR2,
68   X_ASS_ID in NUMBER,
69   X_ORG_ID in NUMBER,
70   X_EXAM_CAL_TYPE in VARCHAR2,
71   X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
72   X_DT_ALIAS in VARCHAR2,
73   X_DAI_SEQUENCE_NUMBER in NUMBER,
74   X_START_TIME in DATE,
75   X_END_TIME in DATE,
76   X_VENUE_CD in VARCHAR2,
77   X_ESE_ID in NUMBER,
78   X_COLLECT_PERSON_ID in NUMBER,
79   X_SPECIAL_SESSION_IND in VARCHAR2,
80   X_OVERRIDE_START_TIME in DATE,
81   X_OVERRIDE_END_TIME in DATE,
82   X_SPECIAL_ANNOUNCEMENTS in VARCHAR2,
83   X_SPECIAL_INSTRUCTIONS in VARCHAR2,
84   X_WORKED_SCRIPT_INSTRUCTIONS in VARCHAR2,
85   X_COMMENTS in VARCHAR2,
86   X_MODE in VARCHAR2 default 'R'
87   );
88 procedure DELETE_ROW (
89   X_ROWID in VARCHAR2
90 );
91 
92 
93 
94 
95 
96 FUNCTION Get_PK_For_Validation (
97     x_ass_id IN NUMBER,
98     x_exam_cal_type IN VARCHAR2,
99     x_exam_ci_sequence_number IN NUMBER,
100     x_dt_alias IN VARCHAR2,
101     x_dai_sequence_number IN NUMBER,
102     x_start_time IN DATE,
103     x_end_time IN DATE,
104     x_venue_cd IN VARCHAR2
105     )RETURN BOOLEAN;
106 
107 
108 
109 
110 
111   PROCEDURE GET_FK_IGS_AS_ASSESSMNT_ITM (
112     x_ass_id IN NUMBER
113     );
114   PROCEDURE GET_FK_IGS_AS_EXAM_SESSION (
115     x_exam_cal_type IN VARCHAR2,
116     x_exam_ci_sequence_number IN NUMBER,
117     x_dt_alias IN VARCHAR2,
118     x_dai_sequence_number IN NUMBER,
119     x_start_time IN DATE,
120     x_end_time IN DATE
121     );
122   PROCEDURE GET_UFK_IGS_AS_EXAM_SESSION (
123     x_ese_id IN NUMBER
124     );
125   PROCEDURE GET_FK_IGS_PE_PERSON (
126     x_person_id IN NUMBER
127     );
128   PROCEDURE GET_FK_IGS_GR_VENUE (
129     x_venue_cd IN VARCHAR2
130     );
131 
132 
133 
134 
135 
136 
137 
138 
139 
140 	PROCEDURE Check_Constraints (
141 
142 
143 
144 
145 	Column_Name	IN	VARCHAR2	DEFAULT NULL,
146 
147 
148 
149 
150 	Column_Value 	IN	VARCHAR2	DEFAULT NULL
151 
152 
153 
154 
155 	);
156 
157 
158 
159 
160 PROCEDURE Before_DML (
161 
162 
163 
164 
165     p_action IN VARCHAR2,
166 
167 
168 
169 
170     x_rowid IN  VARCHAR2 DEFAULT NULL,
171 
172 
173    x_org_id IN NUMBER DEFAULT NULL,
174 
175     x_ass_id IN NUMBER DEFAULT NULL,
176 
177 
178 
179 
180     x_exam_cal_type IN VARCHAR2 DEFAULT NULL,
181 
182 
183 
184 
185     x_exam_ci_sequence_number IN NUMBER DEFAULT NULL,
186 
187 
188 
189 
190     x_dt_alias IN VARCHAR2 DEFAULT NULL,
191 
192 
193 
194 
195     x_dai_sequence_number IN NUMBER DEFAULT NULL,
196 
197 
198 
199 
200     x_start_time IN DATE DEFAULT NULL,
201 
202 
203 
204 
205     x_end_time IN DATE DEFAULT NULL,
206 
207 
208 
209 
210     x_ese_id IN NUMBER DEFAULT NULL,
211 
212 
213 
214 
215     x_venue_cd IN VARCHAR2 DEFAULT NULL,
216 
217 
218 
219 
220     x_collect_person_id IN NUMBER DEFAULT NULL,
221 
222 
223 
224 
225     x_special_session_ind IN VARCHAR2 DEFAULT NULL,
226 
227 
228 
229 
230     x_override_start_time IN DATE DEFAULT NULL,
231 
232 
233 
234 
235     x_override_end_time IN DATE DEFAULT NULL,
236 
237 
238 
239 
240     x_special_announcements IN VARCHAR2 DEFAULT NULL,
241 
242 
243 
244 
245     x_special_instructions IN VARCHAR2 DEFAULT NULL,
246 
247 
248 
249 
250     x_worked_script_instructions IN VARCHAR2 DEFAULT NULL,
251 
252 
253 
254 
255     x_comments IN VARCHAR2 DEFAULT NULL,
256 
257 
258 
259 
260     x_creation_date IN DATE DEFAULT NULL,
261 
262 
263 
264 
265     x_created_by IN NUMBER DEFAULT NULL,
266 
267 
268 
269 
270     x_last_update_date IN DATE DEFAULT NULL,
271 
272 
273 
274 
275     x_last_updated_by IN NUMBER DEFAULT NULL,
276 
277 
278 
279 
280     x_last_update_login IN NUMBER DEFAULT NULL
281 
282 
283 
284   ) ;
285 
286 
287 
288 end IGS_AS_EXAM_INSTANCE_PKG;