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_SESSION_PKG

Source


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