1 PACKAGE BODY igs_uc_prospective_pkg AS
2 /* $Header: IGSXI23B.pls 115.4 2002/11/29 04:51:15 nsidana noship $ */
3
4 PROCEDURE set_column_values (
5 p_action IN VARCHAR2,
6 x_rowid IN VARCHAR2 ,
7 x_prospective_id IN NUMBER ,
8 x_app_no IN NUMBER ,
9 x_datetimestamp IN DATE ,
10 x_check_digit IN NUMBER ,
11 x_name_change_date IN DATE ,
12 x_title IN VARCHAR2 ,
13 x_forenames IN VARCHAR2 ,
14 x_surname IN VARCHAR2 ,
15 x_index_surname IN VARCHAR2 ,
16 x_cancelled IN VARCHAR2 ,
17 x_withdrawn IN VARCHAR2 ,
18 x_status IN VARCHAR2 ,
19 x_birth_date IN DATE ,
20 x_sex IN VARCHAR2 ,
21 x_creation_date IN DATE ,
22 x_created_by IN NUMBER ,
23 x_last_update_date IN DATE ,
24 x_last_updated_by IN NUMBER ,
25 x_last_update_login IN NUMBER
26 ) AS
27
28 BEGIN
29 NULL;
30 END set_column_values;
31
32
33 PROCEDURE check_uniqueness AS
34 BEGIN
35 NULL;
36 END check_uniqueness;
37
38
39 FUNCTION get_pk_for_validation (
40 x_prospective_id IN NUMBER
41 ) RETURN BOOLEAN AS
42 BEGIN
43 NULL;
44 END get_pk_for_validation;
45
46
47 FUNCTION get_uk_for_validation (
48 x_app_no IN NUMBER
49 ) RETURN BOOLEAN AS
50 BEGIN
51 NULL;
52 END get_uk_for_validation ;
53
54
55 PROCEDURE before_dml (
56 p_action IN VARCHAR2,
57 x_rowid IN VARCHAR2 ,
58 x_prospective_id IN NUMBER ,
59 x_app_no IN NUMBER ,
60 x_datetimestamp IN DATE ,
61 x_check_digit IN NUMBER ,
62 x_name_change_date IN DATE ,
63 x_title IN VARCHAR2 ,
64 x_forenames IN VARCHAR2 ,
65 x_surname IN VARCHAR2 ,
66 x_index_surname IN VARCHAR2 ,
67 x_cancelled IN VARCHAR2 ,
68 x_withdrawn IN VARCHAR2 ,
69 x_status IN VARCHAR2 ,
70 x_birth_date IN DATE ,
71 x_sex IN VARCHAR2 ,
72 x_creation_date IN DATE ,
73 x_created_by IN NUMBER ,
74 x_last_update_date IN DATE ,
75 x_last_updated_by IN NUMBER ,
76 x_last_update_login IN NUMBER
77 ) AS
78 BEGIN
79 NULL;
80 END before_dml;
81
82
83 PROCEDURE insert_row (
84 x_rowid IN OUT NOCOPY VARCHAR2,
85 x_prospective_id IN OUT NOCOPY NUMBER,
86 x_app_no IN NUMBER,
87 x_datetimestamp IN DATE,
88 x_check_digit IN NUMBER,
89 x_name_change_date IN DATE,
90 x_title IN VARCHAR2,
91 x_forenames IN VARCHAR2,
92 x_surname IN VARCHAR2,
93 x_index_surname IN VARCHAR2,
94 x_cancelled IN VARCHAR2,
95 x_withdrawn IN VARCHAR2,
96 x_status IN VARCHAR2,
97 x_birth_date IN DATE,
98 x_sex IN VARCHAR2,
99 x_mode IN VARCHAR2
100 ) AS
101 BEGIN
102 NULL;
103 END insert_row;
104
105
106 PROCEDURE lock_row (
107 x_rowid IN VARCHAR2,
108 x_prospective_id IN NUMBER,
109 x_app_no IN NUMBER,
110 x_datetimestamp IN DATE,
111 x_check_digit IN NUMBER,
112 x_name_change_date IN DATE,
113 x_title IN VARCHAR2,
114 x_forenames IN VARCHAR2,
115 x_surname IN VARCHAR2,
116 x_index_surname IN VARCHAR2,
117 x_cancelled IN VARCHAR2,
118 x_withdrawn IN VARCHAR2,
119 x_status IN VARCHAR2,
120 x_birth_date IN DATE,
121 x_sex IN VARCHAR2
122 ) AS
123 BEGIN
124 NULL;
125 END lock_row;
126
127
128 PROCEDURE update_row (
129 x_rowid IN VARCHAR2,
130 x_prospective_id IN NUMBER,
131 x_app_no IN NUMBER,
132 x_datetimestamp IN DATE,
133 x_check_digit IN NUMBER,
134 x_name_change_date IN DATE,
135 x_title IN VARCHAR2,
136 x_forenames IN VARCHAR2,
137 x_surname IN VARCHAR2,
138 x_index_surname IN VARCHAR2,
139 x_cancelled IN VARCHAR2,
140 x_withdrawn IN VARCHAR2,
141 x_status IN VARCHAR2,
142 x_birth_date IN DATE,
143 x_sex IN VARCHAR2,
144 x_mode IN VARCHAR2
145 ) AS
146 BEGIN
147 NULL;
148 END update_row;
149
150
151 PROCEDURE add_row (
152 x_rowid IN OUT NOCOPY VARCHAR2,
153 x_prospective_id IN OUT NOCOPY NUMBER,
154 x_app_no IN NUMBER,
155 x_datetimestamp IN DATE,
156 x_check_digit IN NUMBER,
157 x_name_change_date IN DATE,
158 x_title IN VARCHAR2,
159 x_forenames IN VARCHAR2,
160 x_surname IN VARCHAR2,
161 x_index_surname IN VARCHAR2,
162 x_cancelled IN VARCHAR2,
163 x_withdrawn IN VARCHAR2,
164 x_status IN VARCHAR2,
165 x_birth_date IN DATE,
166 x_sex IN VARCHAR2,
167 x_mode IN VARCHAR2
168 ) AS
169 BEGIN
170 NULL;
171 END add_row;
172
173
174 PROCEDURE delete_row (
175 x_rowid IN VARCHAR2
176 ) AS
177 BEGIN
178 NULL;
179 END delete_row;
180
181
182 END igs_uc_prospective_pkg;