1 package IGS_AS_STD_EXM_INSTN_PKG AS
2 /* $Header: IGSDI09S.pls 120.0 2005/07/05 11:52:13 appldev noship $ */
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_EXAM_CAL_TYPE in VARCHAR2,
9 X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
10 X_DT_ALIAS in VARCHAR2,
11 X_DAI_SEQUENCE_NUMBER in NUMBER,
12 X_START_TIME in DATE,
13 X_END_TIME in DATE,
14 X_VENUE_CD in VARCHAR2,
15 X_PERSON_ID in NUMBER,
16 X_COURSE_CD in VARCHAR2,
17 X_UNIT_CD in VARCHAR2,
18 X_CAL_TYPE in VARCHAR2,
19 X_CI_SEQUENCE_NUMBER in NUMBER,
20 X_CREATION_DT in DATE,
21 X_SEAT_NUMBER in NUMBER,
22 X_TIMESLOT in DATE,
23 X_TIMESLOT_DURATION in DATE,
24 X_ESE_ID in NUMBER,
25 X_ATTENDANCE_IND in VARCHAR2,
26 X_MODE in VARCHAR2 default 'R',
27 X_UOO_ID in NUMBER,
28 X_STD_EXM_INSTN_ID in out NOCOPY NUMBER
29 );
30 procedure LOCK_ROW (
31 X_ROWID in VARCHAR2,
32 X_ASS_ID in NUMBER,
33 X_EXAM_CAL_TYPE in VARCHAR2,
34 X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
35 X_DT_ALIAS in VARCHAR2,
36 X_DAI_SEQUENCE_NUMBER in NUMBER,
37 X_START_TIME in DATE,
38 X_END_TIME in DATE,
39 X_VENUE_CD in VARCHAR2,
40 X_PERSON_ID in NUMBER,
41 X_COURSE_CD in VARCHAR2,
42 X_UNIT_CD in VARCHAR2,
43 X_CAL_TYPE in VARCHAR2,
44 X_CI_SEQUENCE_NUMBER in NUMBER,
45 X_CREATION_DT in DATE,
46 X_SEAT_NUMBER in NUMBER,
47 X_TIMESLOT in DATE,
48 X_TIMESLOT_DURATION in DATE,
49 X_ESE_ID in NUMBER,
50 X_ATTENDANCE_IND in VARCHAR2,
51 X_UOO_ID in NUMBER,
52 X_STD_EXM_INSTN_ID in NUMBER
53 );
54 procedure UPDATE_ROW (
55 X_ROWID in VARCHAR2,
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_PERSON_ID in NUMBER,
65 X_COURSE_CD in VARCHAR2,
66 X_UNIT_CD in VARCHAR2,
67 X_CAL_TYPE in VARCHAR2,
68 X_CI_SEQUENCE_NUMBER in NUMBER,
69 X_CREATION_DT in DATE,
70 X_SEAT_NUMBER in NUMBER,
71 X_TIMESLOT in DATE,
72 X_TIMESLOT_DURATION in DATE,
73 X_ESE_ID in NUMBER,
74 X_ATTENDANCE_IND in VARCHAR2,
75 X_MODE in VARCHAR2 default 'R',
76 X_UOO_ID in NUMBER,
77 X_STD_EXM_INSTN_ID in NUMBER
78 );
79 procedure ADD_ROW (
80 X_ROWID in out NOCOPY VARCHAR2,
81 X_ORG_ID in NUMBER,
82 X_ASS_ID in NUMBER,
83 X_EXAM_CAL_TYPE in VARCHAR2,
84 X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
85 X_DT_ALIAS in VARCHAR2,
86 X_DAI_SEQUENCE_NUMBER in NUMBER,
87 X_START_TIME in DATE,
88 X_END_TIME in DATE,
89 X_VENUE_CD in VARCHAR2,
90 X_PERSON_ID in NUMBER,
91 X_COURSE_CD in VARCHAR2,
92 X_UNIT_CD in VARCHAR2,
93 X_CAL_TYPE in VARCHAR2,
94 X_CI_SEQUENCE_NUMBER in NUMBER,
95 X_CREATION_DT in DATE,
96 X_SEAT_NUMBER in NUMBER,
97 X_TIMESLOT in DATE,
98 X_TIMESLOT_DURATION in DATE,
99 X_ESE_ID in NUMBER,
100 X_ATTENDANCE_IND in VARCHAR2,
101 X_MODE in VARCHAR2 default 'R',
102 X_UOO_ID in NUMBER,
103 X_STD_EXM_INSTN_ID in out NOCOPY NUMBER
104 );
105 procedure DELETE_ROW (
106 X_ROWID in VARCHAR2,
107 x_mode IN VARCHAR2 DEFAULT 'R');
108
109
110 FUNCTION Get_PK_For_Validation (
111 x_std_exm_instn_id in NUMBER
112 ) RETURN BOOLEAN;
113
114 FUNCTION Get_UK_For_Validation (
115 x_ass_id IN NUMBER,
116 x_exam_cal_type IN VARCHAR2,
117 x_exam_ci_sequence_number IN NUMBER,
118 x_dt_alias IN VARCHAR2,
119 x_dai_sequence_number IN NUMBER,
120 x_start_time IN DATE,
121 x_end_time IN DATE,
122 x_venue_cd IN VARCHAR2,
123 x_person_id IN NUMBER,
124 x_course_cd IN VARCHAR2,
125 x_creation_dt IN DATE,
126 x_uoo_id in NUMBER
127 ) RETURN BOOLEAN;
128
129 PROCEDURE GET_FK_IGS_AS_EXAM_INSTANCE (
130 x_ass_id IN NUMBER,
131 x_exam_cal_type IN VARCHAR2,
132 x_exam_ci_sequence_number IN NUMBER,
133 x_dt_alias IN VARCHAR2,
134 x_dai_sequence_number IN NUMBER,
135 x_start_time IN DATE,
136 x_end_time IN DATE,
137 x_venue_cd IN VARCHAR2
138 );
139
140 PROCEDURE GET_UFK_IGS_AS_EXAM_SESSION (
141 x_ese_id IN NUMBER
142 );
143
144 PROCEDURE GET_FK_IGS_AS_SU_ATMPT_ITM (
145 x_course_cd IN VARCHAR2,
146 x_person_id IN NUMBER,
147 x_ass_id IN NUMBER,
148 x_creation_dt IN DATE,
149 x_uoo_id in NUMBER
150 );
151 PROCEDURE Check_Constraints (
152 Column_Name IN VARCHAR2 DEFAULT NULL,
153 Column_Value IN VARCHAR2 DEFAULT NULL
154 );
155
156 PROCEDURE Before_DML (
157 p_action IN VARCHAR2,
158 x_rowid IN VARCHAR2 DEFAULT NULL,
159 x_org_id IN NUMBER DEFAULT NULL,
160 x_seat_number IN NUMBER DEFAULT NULL,
161 x_timeslot IN DATE DEFAULT NULL,
162 x_timeslot_duration IN DATE DEFAULT NULL,
163 x_ass_id IN NUMBER DEFAULT NULL,
164 x_exam_cal_type IN VARCHAR2 DEFAULT NULL,
165 x_exam_ci_sequence_number IN NUMBER DEFAULT NULL,
166 x_dt_alias IN VARCHAR2 DEFAULT NULL,
167 x_dai_sequence_number IN NUMBER DEFAULT NULL,
168 x_start_time IN DATE DEFAULT NULL,
169 x_end_time IN DATE DEFAULT NULL,
170 x_ese_id IN NUMBER DEFAULT NULL,
171 x_venue_cd IN VARCHAR2 DEFAULT NULL,
172 x_person_id IN NUMBER DEFAULT NULL,
173 x_course_cd IN VARCHAR2 DEFAULT NULL,
174 x_unit_cd IN VARCHAR2 DEFAULT NULL,
175 x_cal_type IN VARCHAR2 DEFAULT NULL,
176 x_ci_sequence_number IN NUMBER DEFAULT NULL,
177 x_creation_dt IN DATE DEFAULT NULL,
178 x_attendance_ind IN VARCHAR2 DEFAULT NULL,
179 x_creation_date IN DATE DEFAULT NULL,
180 x_created_by IN NUMBER DEFAULT NULL,
181 x_last_update_date IN DATE DEFAULT NULL,
182 x_last_updated_by IN NUMBER DEFAULT NULL,
183 x_last_update_login IN NUMBER DEFAULT NULL,
184 x_uoo_id in NUMBER DEFAULT NULL,
185 x_std_exm_instn_id in NUMBER DEFAULT NULL
186 ) ;
187
188
189 end IGS_AS_STD_EXM_INSTN_PKG;