[Home] [Help]
PACKAGE: APPS.IGS_AS_EXM_SES_VN_SP_PKG
Source
1 package IGS_AS_EXM_SES_VN_SP_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSDI13S.pls 115.4 2002/11/28 23:13:40 nsidana ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_PERSON_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_VENUE_CD in VARCHAR2,
13 X_ESE_ID in NUMBER,
14 X_EXAM_SUPERVISOR_TYPE in VARCHAR2,
15 X_OVERRIDE_START_TIME in DATE,
16 X_OVERRIDE_END_TIME in DATE,
17 X_MODE in VARCHAR2 default 'R'
18 );
19 procedure LOCK_ROW (
20 X_ROWID in VARCHAR2,
21 X_PERSON_ID in NUMBER,
22 X_EXAM_CAL_TYPE in VARCHAR2,
23 X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
24 X_DT_ALIAS in VARCHAR2,
25 X_DAI_SEQUENCE_NUMBER in NUMBER,
26 X_START_TIME in DATE,
27 X_END_TIME in DATE,
28 X_VENUE_CD in VARCHAR2,
29 X_ESE_ID in NUMBER,
30 X_EXAM_SUPERVISOR_TYPE in VARCHAR2,
31 X_OVERRIDE_START_TIME in DATE,
32 X_OVERRIDE_END_TIME in DATE
33 );
34 procedure UPDATE_ROW (
35 X_ROWID in VARCHAR2,
36 X_PERSON_ID in NUMBER,
37 X_EXAM_CAL_TYPE in VARCHAR2,
38 X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
39 X_DT_ALIAS in VARCHAR2,
40 X_DAI_SEQUENCE_NUMBER in NUMBER,
41 X_START_TIME in DATE,
42 X_END_TIME in DATE,
43 X_VENUE_CD in VARCHAR2,
44 X_ESE_ID in NUMBER,
45 X_EXAM_SUPERVISOR_TYPE in VARCHAR2,
46 X_OVERRIDE_START_TIME in DATE,
47 X_OVERRIDE_END_TIME in DATE,
48 X_MODE in VARCHAR2 default 'R'
49 );
50 procedure ADD_ROW (
51 X_ROWID in out NOCOPY VARCHAR2,
52 X_PERSON_ID in NUMBER,
53 X_EXAM_CAL_TYPE in VARCHAR2,
54 X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
55 X_DT_ALIAS in VARCHAR2,
56 X_DAI_SEQUENCE_NUMBER in NUMBER,
57 X_START_TIME in DATE,
58 X_END_TIME in DATE,
59 X_VENUE_CD in VARCHAR2,
60 X_ESE_ID in NUMBER,
61 X_EXAM_SUPERVISOR_TYPE in VARCHAR2,
62 X_OVERRIDE_START_TIME in DATE,
63 X_OVERRIDE_END_TIME in DATE,
64 X_MODE in VARCHAR2 default 'R'
65 );
66 procedure DELETE_ROW (
67 X_ROWID in VARCHAR2
68 );
69
70 FUNCTION Get_PK_For_Validation (
71 x_person_id IN NUMBER,
72 x_exam_cal_type IN VARCHAR2,
73 x_exam_ci_sequence_number IN NUMBER,
74 x_dt_alias IN VARCHAR2,
75 x_dai_sequence_number IN NUMBER,
76 x_venue_cd IN VARCHAR2,
77 x_start_time IN DATE,
78 x_end_time IN DATE
79 ) RETURN BOOLEAN ;
80
81
82 PROCEDURE GET_FK_IGS_AS_EXM_SPRVSRTYP (
83 x_exam_supervisor_type IN VARCHAR2
84 );
85
86 PROCEDURE GET_FK_IGS_AS_EXM_SUPRVISOR (
87 x_person_id IN NUMBER
88 );
89
90 PROCEDURE GET_UFK_IGS_AS_EXAM_SESSION (
91 x_ese_id IN NUMBER
92 );
93
94
95
96
97 PROCEDURE Check_Constraints (
98
99
100
101
102 Column_Name IN VARCHAR2 DEFAULT NULL,
103
104
105
106
107 Column_Value IN VARCHAR2 DEFAULT NULL
108
109
110
111
112 );
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132 PROCEDURE Before_DML (
133
134
135
136
137 p_action IN VARCHAR2,
138
139
140
141
142 x_rowid IN VARCHAR2 DEFAULT NULL,
143
144
145
146
147 x_person_id IN NUMBER DEFAULT NULL,
148
149
150
151
152 x_exam_cal_type IN VARCHAR2 DEFAULT NULL,
153
154
155
156
157 x_exam_ci_sequence_number IN NUMBER DEFAULT NULL,
158
159
160
161
162 x_dt_alias IN VARCHAR2 DEFAULT NULL,
163
164
165
166
167 x_dai_sequence_number IN NUMBER DEFAULT NULL,
168
169
170
171
172 x_start_time IN DATE DEFAULT NULL,
173
174
175
176
177 x_end_time IN DATE DEFAULT NULL,
178
179
180
181
182 x_ese_id IN NUMBER DEFAULT NULL,
183
184
185
186
187 x_venue_cd IN VARCHAR2 DEFAULT NULL,
188
189
190
191
192 x_exam_supervisor_type IN VARCHAR2 DEFAULT NULL,
193
194
195
196
197 x_override_start_time IN DATE DEFAULT NULL,
198
199
200
201
202 x_override_end_time IN DATE DEFAULT NULL,
203
204
205
206
207 x_creation_date IN DATE DEFAULT NULL,
208
209
210
211
212 x_created_by IN NUMBER DEFAULT NULL,
213
214
215
216
217 x_last_update_date IN DATE DEFAULT NULL,
218
219
220
221
222 x_last_updated_by IN NUMBER DEFAULT NULL,
223
224
225
226
227 x_last_update_login IN NUMBER DEFAULT NULL
228
229
230
231
232 ) ;
233
234
235
236
237
238
239
240
241
242
243
244
245 end IGS_AS_EXM_SES_VN_SP_PKG;