1 PACKAGE BODY igs_ss_test_conf_pkg AS
2 /* $Header: IGSAIC3B.pls 115.6 2003/01/10 14:58:42 nshee ship $ */
3
4 l_rowid VARCHAR2(25);
5
6 PROCEDURE set_column_values (
7 p_action IN VARCHAR2,
8 x_rowid IN VARCHAR2 DEFAULT NULL,
9 x_test_config_id IN NUMBER DEFAULT NULL,
10 x_source_type_id IN NUMBER DEFAULT NULL,
11 x_admission_test_type IN VARCHAR2 DEFAULT NULL,
12 x_inactive IN VARCHAR2 DEFAULT NULL,
13 x_creation_date IN DATE DEFAULT NULL,
14 x_created_by IN NUMBER DEFAULT NULL,
15 x_last_update_date IN DATE DEFAULT NULL,
16 x_last_updated_by IN NUMBER DEFAULT NULL,
17 x_last_update_login IN NUMBER DEFAULT NULL
18 ) AS
19 /*
20 || Created By : ssomani
21 || Created On : 18-DEC-2000
22 || Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
23 || Purpose : Initialises the Old and New references for the columns of the table.
24 || Known limitations, enhancements or remarks :
25 || Change History :
26 || Who When What
27 || (reverse chronological order - newest change first)
28 */
29
30
31
32 BEGIN
33
34 NULL;
35
36 END set_column_values;
37
38
39 PROCEDURE check_uniqueness AS
40 /*
41 || Created By : ssomani
42 || Created On : 18-DEC-2000
43 || Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
44 || Purpose : Handles the Unique Constraint logic defined for the columns.
45 || Known limitations, enhancements or remarks :
46 || Change History :
47 || Who When What
48 || (reverse chronological order - newest change first)
49 */
50 BEGIN
51
52 NULL;
53
54 END check_uniqueness;
55
56
57 FUNCTION get_pk_for_validation (
58 x_test_config_id IN NUMBER
59 ) RETURN BOOLEAN AS
60 /*
61 || Created By : ssomani
62 || Created On : 18-DEC-2000
63 || Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
64 || Purpose : Validates the Primary Key of the table.
65 || Known limitations, enhancements or remarks :
66 || Change History :
67 || Who When What
68 || (reverse chronological order - newest change first)
69 */
70
71
72 BEGIN
73
74 NULL;
75
76 END get_pk_for_validation;
77
78
79 FUNCTION get_uk_for_validation (
80 x_source_type_id IN NUMBER,
81 x_admission_test_type IN VARCHAR2
82 ) RETURN BOOLEAN AS
83 /*
84 || Created By : ssomani
85 || Created On : 18-DEC-2000
86 || Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
87 || Purpose : Validates the Unique Keys of the table.
88 || Known limitations, enhancements or remarks :
89 || Change History :
90 || Who When What
91 || (reverse chronological order - newest change first)
92 */
93
94 BEGIN
95
96 NULL;
97
98 END get_uk_for_validation ;
99
100
101 PROCEDURE before_dml (
102 p_action IN VARCHAR2,
103 x_rowid IN VARCHAR2 DEFAULT NULL,
104 x_test_config_id IN NUMBER DEFAULT NULL,
105 x_source_type_id IN NUMBER DEFAULT NULL,
106 x_admission_test_type IN VARCHAR2 DEFAULT NULL,
107 x_inactive IN VARCHAR2 DEFAULT NULL,
108 x_creation_date IN DATE DEFAULT NULL,
109 x_created_by IN NUMBER DEFAULT NULL,
110 x_last_update_date IN DATE DEFAULT NULL,
111 x_last_updated_by IN NUMBER DEFAULT NULL,
112 x_last_update_login IN NUMBER DEFAULT NULL
113 ) AS
114 /*
115 || Created By : ssomani
116 || Created On : 18-DEC-2000
117 || Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
118 || Purpose : Initialises the columns, Checks Constraints, Calls the
119 || Trigger Handlers for the table, before any DML operation.
120 || Known limitations, enhancements or remarks :
121 || Change History :
122 || Who When What
123 || (reverse chronological order - newest change first)
124 */
125 BEGIN
126
127 NULL;
128
129 END before_dml;
130
131
132 PROCEDURE insert_row (
133 x_rowid IN OUT NOCOPY VARCHAR2,
134 x_test_config_id IN OUT NOCOPY NUMBER,
135 x_source_type_id IN NUMBER,
136 x_admission_test_type IN VARCHAR2,
137 x_inactive IN VARCHAR2,
138 x_mode IN VARCHAR2 DEFAULT 'R'
139 ) AS
140 /*
141 || Created By : ssomani
142 || Created On : 18-DEC-2000
143 || Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
144 || Purpose : Handles the INSERT DML logic for the table.
145 || Known limitations, enhancements or remarks :
146 || Change History :
147 || Who When What
148 || (reverse chronological order - newest change first)
149 */
150
151
152 BEGIN
153
154 NULL;
155 END insert_row;
156
157
158 PROCEDURE lock_row (
159 x_rowid IN VARCHAR2,
160 x_test_config_id IN NUMBER,
161 x_source_type_id IN NUMBER,
162 x_admission_test_type IN VARCHAR2,
163 x_inactive IN VARCHAR2
164 ) AS
165 /*
166 || Created By : ssomani
167 || Created On : 18-DEC-2000
168 || Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
169 || Purpose : Handles the LOCK mechanism for the table.
170 || Known limitations, enhancements or remarks :
171 || Change History :
172 || Who When What
173 || (reverse chronological order - newest change first)
174 */
175
176 BEGIN
177
178 NULL;
179 END lock_row;
180
181
182 PROCEDURE update_row (
183 x_rowid IN VARCHAR2,
184 x_test_config_id IN NUMBER,
185 x_source_type_id IN NUMBER,
186 x_admission_test_type IN VARCHAR2,
187 x_inactive IN VARCHAR2,
188 x_mode IN VARCHAR2 DEFAULT 'R'
189 ) AS
190 /*
191 || Created By : ssomani
192 || Created On : 18-DEC-2000
193 || Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
194 || Purpose : Handles the UPDATE DML logic for the table.
195 || Known limitations, enhancements or remarks :
196 || Change History :
197 || Who When What
198 || (reverse chronological order - newest change first)
199 */
200
201
202 BEGIN
203
204 NULL;
205 END update_row;
206
207
208 PROCEDURE add_row (
209 x_rowid IN OUT NOCOPY VARCHAR2,
210 x_test_config_id IN OUT NOCOPY NUMBER,
211 x_source_type_id IN NUMBER,
212 x_admission_test_type IN VARCHAR2,
213 x_inactive IN VARCHAR2,
214 x_mode IN VARCHAR2 DEFAULT 'R'
215 ) AS
216 /*
217 || Created By : ssomani
218 || Created On : 18-DEC-2000
219 || Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
220 || Purpose : Adds a row if there is no existing row, otherwise updates existing row in the table.
221 || Known limitations, enhancements or remarks :
222 || Change History :
223 || Who When What
224 || (reverse chronological order - newest change first)
225 */
226
227 BEGIN
228
229 NULL;
230 END add_row;
231
232
233 PROCEDURE delete_row (
234 x_rowid IN VARCHAR2
235 ) AS
236 /*
237 || Created By : ssomani
238 || Created On : 18-DEC-2000
239 || Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
240 || Purpose : Handles the DELETE DML logic for the table.
241 || Known limitations, enhancements or remarks :
242 || Change History :
243 || Who When What
244 || (reverse chronological order - newest change first)
245 */
246 BEGIN
247
248 NULL;
249 END delete_row;
250
251
252 END igs_ss_test_conf_pkg;