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_EXM_INS_SPVSR_PKG

Source


1 package IGS_AS_EXM_INS_SPVSR_PKG AUTHID CURRENT_USER AS
2  /* $Header: IGSDI11S.pls 115.3 2002/11/28 23:13:02 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_PERSON_ID in NUMBER,
6   X_ASS_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_EXAM_SUPERVISOR_TYPE in VARCHAR2,
16   X_OVERRIDE_START_TIME in DATE,
17   X_OVERRIDE_END_TIME in DATE,
18   X_MODE in VARCHAR2 default 'R'
19   );
20 procedure LOCK_ROW (
21   X_ROWID in VARCHAR2,
22   X_PERSON_ID in NUMBER,
23   X_ASS_ID in NUMBER,
24   X_EXAM_CAL_TYPE in VARCHAR2,
25   X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
26   X_DT_ALIAS in VARCHAR2,
27   X_DAI_SEQUENCE_NUMBER in NUMBER,
28   X_START_TIME in DATE,
29   X_END_TIME in DATE,
30   X_VENUE_CD in VARCHAR2,
31   X_ESE_ID in NUMBER,
32   X_EXAM_SUPERVISOR_TYPE in VARCHAR2,
33   X_OVERRIDE_START_TIME in DATE,
34   X_OVERRIDE_END_TIME in DATE
35 );
36 procedure UPDATE_ROW (
37   X_ROWID in VARCHAR2,
38   X_PERSON_ID in NUMBER,
39   X_ASS_ID in NUMBER,
40   X_EXAM_CAL_TYPE in VARCHAR2,
41   X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
42   X_DT_ALIAS in VARCHAR2,
43   X_DAI_SEQUENCE_NUMBER in NUMBER,
44   X_START_TIME in DATE,
45   X_END_TIME in DATE,
46   X_VENUE_CD in VARCHAR2,
47   X_ESE_ID in NUMBER,
48   X_EXAM_SUPERVISOR_TYPE in VARCHAR2,
49   X_OVERRIDE_START_TIME in DATE,
50   X_OVERRIDE_END_TIME in DATE,
51   X_MODE in VARCHAR2 default 'R'
52   );
53 procedure ADD_ROW (
54   X_ROWID in out NOCOPY VARCHAR2,
55   X_PERSON_ID in NUMBER,
56   X_ASS_ID in NUMBER,
57   X_EXAM_CAL_TYPE in VARCHAR2,
58   X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
59   X_DT_ALIAS in VARCHAR2,
60   X_DAI_SEQUENCE_NUMBER in NUMBER,
61   X_START_TIME in DATE,
62   X_END_TIME in DATE,
63   X_VENUE_CD in VARCHAR2,
64   X_ESE_ID in NUMBER,
65   X_EXAM_SUPERVISOR_TYPE in VARCHAR2,
66   X_OVERRIDE_START_TIME in DATE,
67   X_OVERRIDE_END_TIME in DATE,
68   X_MODE in VARCHAR2 default 'R'
69   );
70 procedure DELETE_ROW (
71   X_ROWID in VARCHAR2
72   );
73 FUNCTION Get_PK_For_Validation (
74     x_person_id IN NUMBER,
75     x_ass_id IN NUMBER,
76     x_exam_cal_type IN VARCHAR2,
77     x_exam_ci_sequence_number IN NUMBER,
78     x_dt_alias IN VARCHAR2,
79     x_dai_sequence_number IN NUMBER,
80     x_start_time IN DATE,
81     x_end_time IN DATE,
82     x_venue_cd IN VARCHAR2
83     )RETURN BOOLEAN;
84   PROCEDURE GET_FK_IGS_AS_EXAM_INSTANCE (
85     x_ass_id IN NUMBER,
86     x_exam_cal_type IN VARCHAR2,
87     x_exam_ci_sequence_number IN NUMBER,
88     x_dt_alias IN VARCHAR2,
89     x_dai_sequence_number IN NUMBER,
90     x_start_time IN DATE,
91     x_end_time IN DATE,
92     x_venue_cd IN VARCHAR2
93     );
94   PROCEDURE GET_UFK_IGS_AS_EXAM_SESSION (
95     x_ese_id IN NUMBER
96     );
97   PROCEDURE GET_FK_IGS_AS_EXM_SPRVSRTYP (
98     x_exam_supervisor_type IN VARCHAR2
99     );
100   PROCEDURE GET_FK_IGS_AS_EXM_SUPRVISOR (
101     x_person_id IN NUMBER
102     );
103 
104 
105 
106 
107 	PROCEDURE Check_Constraints (
108 
109 
110 
111 
112 	Column_Name	IN	VARCHAR2	DEFAULT NULL,
113 
114 
115 
116 
117 	Column_Value 	IN	VARCHAR2	DEFAULT NULL
118 
119 
120 
121 
122 	);
123 
124 
125 
126 
127 PROCEDURE Before_DML (
128 
129 
130 
131 
132     p_action IN VARCHAR2,
133 
134 
135 
136 
137     x_rowid IN  VARCHAR2 DEFAULT NULL,
138 
139 
140 
141 
142     x_person_id IN NUMBER DEFAULT NULL,
143 
144 
145 
146 
147     x_ass_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 end IGS_AS_EXM_INS_SPVSR_PKG;