1 PACKAGE igs_uc_app_stats_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSXI07S.pls 115.7 2003/06/11 10:29:26 smaddali noship $ */
3 PROCEDURE insert_row (
4 x_rowid IN OUT NOCOPY VARCHAR2,
5 x_app_stat_id IN OUT NOCOPY NUMBER,
6 x_app_id IN NUMBER,
7 x_app_no IN NUMBER,
8 x_starh_ethnic IN NUMBER,
9 x_starh_social_class IN VARCHAR2,
10 x_starh_pocc_edu_chg_dt IN DATE,
11 x_starh_pocc IN VARCHAR2,
12 x_starh_pocc_text IN VARCHAR2,
13 x_starh_last_edu_inst IN NUMBER,
14 x_starh_edu_leave_date IN NUMBER,
15 x_starh_lea IN NUMBER,
16 x_starx_ethnic IN NUMBER,
17 x_starx_pocc_edu_chg IN DATE,
18 x_starx_pocc IN VARCHAR2,
19 x_starx_pocc_text IN VARCHAR2,
20 x_sent_to_hesa IN VARCHAR2,
21 x_mode IN VARCHAR2 DEFAULT 'R',
22 -- Added following 3 Columns as part of UCCR002 Build. Bug NO: 2278817 by rbezawad
23 x_starh_socio_economic IN NUMBER DEFAULT NULL,
24 x_starx_socio_economic IN NUMBER DEFAULT NULL,
25 x_starx_occ_background IN VARCHAR2 DEFAULT NULL,
26 -- Added following Columns as part of UCFD102Build. Bug NO: 2643048 by bayadav
27 x_ivstarh_dependants IN NUMBER DEFAULT NULL,
28 x_ivstarh_married IN VARCHAR2 DEFAULT NULL,
29 x_ivstarx_religion IN NUMBER DEFAULT NULL,
30 x_ivstarx_dependants IN NUMBER DEFAULT NULL,
31 x_ivstarx_married IN VARCHAR2 DEFAULT NULL
32 );
33
34 PROCEDURE lock_row (
35 x_rowid IN VARCHAR2,
36 x_app_stat_id IN NUMBER,
37 x_app_id IN NUMBER,
38 x_app_no IN NUMBER,
39 x_starh_ethnic IN NUMBER,
40 x_starh_social_class IN VARCHAR2,
41 x_starh_pocc_edu_chg_dt IN DATE,
42 x_starh_pocc IN VARCHAR2,
43 x_starh_pocc_text IN VARCHAR2,
44 x_starh_last_edu_inst IN NUMBER,
45 x_starh_edu_leave_date IN NUMBER,
46 x_starh_lea IN NUMBER,
47 x_starx_ethnic IN NUMBER,
48 x_starx_pocc_edu_chg IN DATE,
49 x_starx_pocc IN VARCHAR2,
50 x_starx_pocc_text IN VARCHAR2,
51 x_sent_to_hesa IN VARCHAR2,
52 -- Added following 3 Columns as part of UCCR002 Build. Bug NO: 2278817 by rbezawad
53 x_starh_socio_economic IN NUMBER DEFAULT NULL,
54 x_starx_socio_economic IN NUMBER DEFAULT NULL,
55 x_starx_occ_background IN VARCHAR2 DEFAULT NULL,
56 -- Added following Columns as part of UCFD102Build. Bug NO: 2643048 by bayadav
57 x_ivstarh_dependants IN NUMBER DEFAULT NULL,
58 x_ivstarh_married IN VARCHAR2 DEFAULT NULL,
59 x_ivstarx_religion IN NUMBER DEFAULT NULL,
60 x_ivstarx_dependants IN NUMBER DEFAULT NULL,
61 x_ivstarx_married IN VARCHAR2 DEFAULT NULL
62 );
63
64 PROCEDURE update_row (
65 x_rowid IN VARCHAR2,
66 x_app_stat_id IN NUMBER,
67 x_app_id IN NUMBER,
68 x_app_no IN NUMBER,
69 x_starh_ethnic IN NUMBER,
70 x_starh_social_class IN VARCHAR2,
71 x_starh_pocc_edu_chg_dt IN DATE,
72 x_starh_pocc IN VARCHAR2,
73 x_starh_pocc_text IN VARCHAR2,
74 x_starh_last_edu_inst IN NUMBER,
75 x_starh_edu_leave_date IN NUMBER,
76 x_starh_lea IN NUMBER,
77 x_starx_ethnic IN NUMBER,
78 x_starx_pocc_edu_chg IN DATE,
79 x_starx_pocc IN VARCHAR2,
80 x_starx_pocc_text IN VARCHAR2,
81 x_sent_to_hesa IN VARCHAR2,
82 x_mode IN VARCHAR2 DEFAULT 'R',
83 -- Added following 3 Columns as part of UCCR002 Build. Bug NO: 2278817 by rbezawad
84 x_starh_socio_economic IN NUMBER DEFAULT NULL,
85 x_starx_socio_economic IN NUMBER DEFAULT NULL,
86 x_starx_occ_background IN VARCHAR2 DEFAULT NULL,
87 -- Added following Columns as part of UCFD102Build. Bug NO: 2643048 by bayadav
88 x_ivstarh_dependants IN NUMBER DEFAULT NULL,
89 x_ivstarh_married IN VARCHAR2 DEFAULT NULL,
90 x_ivstarx_religion IN NUMBER DEFAULT NULL,
91 x_ivstarx_dependants IN NUMBER DEFAULT NULL,
92 x_ivstarx_married IN VARCHAR2 DEFAULT NULL
93 );
94
95 PROCEDURE add_row (
96 x_rowid IN OUT NOCOPY VARCHAR2,
97 x_app_stat_id IN OUT NOCOPY NUMBER,
98 x_app_id IN NUMBER,
99 x_app_no IN NUMBER,
100 x_starh_ethnic IN NUMBER,
101 x_starh_social_class IN VARCHAR2,
102 x_starh_pocc_edu_chg_dt IN DATE,
103 x_starh_pocc IN VARCHAR2,
104 x_starh_pocc_text IN VARCHAR2,
105 x_starh_last_edu_inst IN NUMBER,
106 x_starh_edu_leave_date IN NUMBER,
107 x_starh_lea IN NUMBER,
108 x_starx_ethnic IN NUMBER,
109 x_starx_pocc_edu_chg IN DATE,
110 x_starx_pocc IN VARCHAR2,
111 x_starx_pocc_text IN VARCHAR2,
112 x_sent_to_hesa IN VARCHAR2,
113 x_mode IN VARCHAR2 DEFAULT 'R',
114 -- Added following 3 Columns as part of UCCR002 Build. Bug NO: 2278817 by rbezawad
115 x_starh_socio_economic IN NUMBER DEFAULT NULL,
116 x_starx_socio_economic IN NUMBER DEFAULT NULL,
117 x_starx_occ_background IN VARCHAR2 DEFAULT NULL,
118 -- Added following Columns as part of UCFD102Build. Bug NO: 2643048 by bayadav
119 x_ivstarh_dependants IN NUMBER DEFAULT NULL,
120 x_ivstarh_married IN VARCHAR2 DEFAULT NULL,
121 x_ivstarx_religion IN NUMBER DEFAULT NULL,
122 x_ivstarx_dependants IN NUMBER DEFAULT NULL,
123 x_ivstarx_married IN VARCHAR2 DEFAULT NULL
124 );
125
126 PROCEDURE delete_row (
127 x_rowid IN VARCHAR2
128 );
129
130 FUNCTION get_pk_for_validation (
131 x_app_stat_id IN NUMBER
132 ) RETURN BOOLEAN;
133
134 FUNCTION get_uk_for_validation (
135 x_app_no IN NUMBER
136 ) RETURN BOOLEAN;
137
138 PROCEDURE get_fk_igs_uc_applicants (
139 x_app_id IN NUMBER
140 );
141
142 PROCEDURE before_dml (
143 p_action IN VARCHAR2,
144 x_rowid IN VARCHAR2 DEFAULT NULL,
145 x_app_stat_id IN NUMBER DEFAULT NULL,
146 x_app_id IN NUMBER DEFAULT NULL,
147 x_app_no IN NUMBER DEFAULT NULL,
148 x_starh_ethnic IN NUMBER DEFAULT NULL,
149 x_starh_social_class IN VARCHAR2 DEFAULT NULL,
150 x_starh_pocc_edu_chg_dt IN DATE DEFAULT NULL,
151 x_starh_pocc IN VARCHAR2 DEFAULT NULL,
152 x_starh_pocc_text IN VARCHAR2 DEFAULT NULL,
153 x_starh_last_edu_inst IN NUMBER DEFAULT NULL,
154 x_starh_edu_leave_date IN NUMBER DEFAULT NULL,
155 x_starh_lea IN NUMBER DEFAULT NULL,
156 x_starx_ethnic IN NUMBER DEFAULT NULL,
157 x_starx_pocc_edu_chg IN DATE DEFAULT NULL,
158 x_starx_pocc IN VARCHAR2 DEFAULT NULL,
159 x_starx_pocc_text IN VARCHAR2 DEFAULT NULL,
160 x_sent_to_hesa IN VARCHAR2 DEFAULT NULL,
161 x_creation_date IN DATE DEFAULT NULL,
162 x_created_by IN NUMBER DEFAULT NULL,
163 x_last_update_date IN DATE DEFAULT NULL,
164 x_last_updated_by IN NUMBER DEFAULT NULL,
165 x_last_update_login IN NUMBER DEFAULT NULL,
166 -- Added following 3 Columns as part of UCCR002 Build. Bug NO: 2278817 by rbezawad
167 x_starh_socio_economic IN NUMBER DEFAULT NULL,
168 x_starx_socio_economic IN NUMBER DEFAULT NULL,
169 x_starx_occ_background IN VARCHAR2 DEFAULT NULL,
170 -- Added following Columns as part of UCFD102Build. Bug NO: 2643048 by bayadav
171 x_ivstarh_dependants IN NUMBER DEFAULT NULL,
172 x_ivstarh_married IN VARCHAR2 DEFAULT NULL,
173 x_ivstarx_religion IN NUMBER DEFAULT NULL,
174 x_ivstarx_dependants IN NUMBER DEFAULT NULL,
175 x_ivstarx_married IN VARCHAR2 DEFAULT NULL
176 );
177
178 END igs_uc_app_stats_pkg;