1 PACKAGE igs_uc_app_addreses_pkg AS
2 /* $Header: IGSXI50S.pls 120.1 2006/08/21 03:37:05 jbaber noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_app_no IN NUMBER,
7 x_address_area IN VARCHAR2,
8 x_address1 IN VARCHAR2,
9 x_address2 IN VARCHAR2,
10 x_address3 IN VARCHAR2,
11 x_address4 IN VARCHAR2,
12 x_post_code IN VARCHAR2,
13 x_mail_sort IN VARCHAR2,
14 x_telephone IN VARCHAR2,
15 x_fax IN VARCHAR2,
16 x_email IN VARCHAR2,
17 x_home_address1 IN VARCHAR2,
18 x_home_address2 IN VARCHAR2,
19 x_home_address3 IN VARCHAR2,
20 x_home_address4 IN VARCHAR2,
21 x_home_postcode IN VARCHAR2,
22 x_home_phone IN VARCHAR2,
23 x_home_fax IN VARCHAR2,
24 x_home_email IN VARCHAR2,
25 x_sent_to_oss_flag IN VARCHAR2,
26 x_ad_batch_id IN NUMBER,
27 x_ad_interface_id IN NUMBER,
28 x_mobile IN VARCHAR2 DEFAULT NULL,
29 x_country_code IN VARCHAR2 DEFAULT NULL,
30 x_home_country_code IN VARCHAR2 DEFAULT NULL,
31 x_mode IN VARCHAR2 DEFAULT 'R'
32 );
33
34 PROCEDURE lock_row (
35 x_rowid IN VARCHAR2,
36 x_app_no IN NUMBER,
37 x_address_area IN VARCHAR2,
38 x_address1 IN VARCHAR2,
39 x_address2 IN VARCHAR2,
40 x_address3 IN VARCHAR2,
41 x_address4 IN VARCHAR2,
42 x_post_code IN VARCHAR2,
43 x_mail_sort IN VARCHAR2,
44 x_telephone IN VARCHAR2,
45 x_fax IN VARCHAR2,
46 x_email IN VARCHAR2,
47 x_home_address1 IN VARCHAR2,
48 x_home_address2 IN VARCHAR2,
49 x_home_address3 IN VARCHAR2,
50 x_home_address4 IN VARCHAR2,
51 x_home_postcode IN VARCHAR2,
52 x_home_phone IN VARCHAR2,
53 x_home_fax IN VARCHAR2,
54 x_home_email IN VARCHAR2,
55 x_sent_to_oss_flag IN VARCHAR2,
56 x_ad_batch_id IN NUMBER,
57 x_ad_interface_id IN NUMBER,
58 x_mobile IN VARCHAR2 DEFAULT NULL,
59 x_country_code IN VARCHAR2 DEFAULT NULL,
60 x_home_country_code IN VARCHAR2 DEFAULT NULL
61 );
62
63 PROCEDURE update_row (
64 x_rowid IN VARCHAR2,
65 x_app_no IN NUMBER,
66 x_address_area IN VARCHAR2,
67 x_address1 IN VARCHAR2,
68 x_address2 IN VARCHAR2,
69 x_address3 IN VARCHAR2,
70 x_address4 IN VARCHAR2,
71 x_post_code IN VARCHAR2,
72 x_mail_sort IN VARCHAR2,
73 x_telephone IN VARCHAR2,
74 x_fax IN VARCHAR2,
75 x_email IN VARCHAR2,
76 x_home_address1 IN VARCHAR2,
77 x_home_address2 IN VARCHAR2,
78 x_home_address3 IN VARCHAR2,
79 x_home_address4 IN VARCHAR2,
80 x_home_postcode IN VARCHAR2,
81 x_home_phone IN VARCHAR2,
82 x_home_fax IN VARCHAR2,
83 x_home_email IN VARCHAR2,
84 x_sent_to_oss_flag IN VARCHAR2,
85 x_ad_batch_id IN NUMBER,
86 x_ad_interface_id IN NUMBER,
87 x_mobile IN VARCHAR2 DEFAULT NULL,
88 x_country_code IN VARCHAR2 DEFAULT NULL,
89 x_home_country_code IN VARCHAR2 DEFAULT NULL,
90 x_mode IN VARCHAR2 DEFAULT 'R'
91 );
92
93 PROCEDURE add_row (
94 x_rowid IN OUT NOCOPY VARCHAR2,
95 x_app_no IN NUMBER,
96 x_address_area IN VARCHAR2,
97 x_address1 IN VARCHAR2,
98 x_address2 IN VARCHAR2,
99 x_address3 IN VARCHAR2,
100 x_address4 IN VARCHAR2,
101 x_post_code IN VARCHAR2,
102 x_mail_sort IN VARCHAR2,
103 x_telephone IN VARCHAR2,
104 x_fax IN VARCHAR2,
105 x_email IN VARCHAR2,
106 x_home_address1 IN VARCHAR2,
107 x_home_address2 IN VARCHAR2,
108 x_home_address3 IN VARCHAR2,
109 x_home_address4 IN VARCHAR2,
110 x_home_postcode IN VARCHAR2,
111 x_home_phone IN VARCHAR2,
112 x_home_fax IN VARCHAR2,
113 x_home_email IN VARCHAR2,
114 x_sent_to_oss_flag IN VARCHAR2,
115 x_ad_batch_id IN NUMBER,
116 x_ad_interface_id IN NUMBER,
117 x_mobile IN VARCHAR2 DEFAULT NULL,
118 x_country_code IN VARCHAR2 DEFAULT NULL,
119 x_home_country_code IN VARCHAR2 DEFAULT NULL,
120 x_mode IN VARCHAR2 DEFAULT 'R'
121 );
122
123 PROCEDURE delete_row (
124 x_rowid IN VARCHAR2
125 );
126
127 FUNCTION get_uk_for_validation (
128 x_app_no IN NUMBER
129 ) RETURN BOOLEAN;
130
131 PROCEDURE get_ufk_igs_uc_applicants (
132 x_app_no IN NUMBER
133 );
134
135 PROCEDURE before_dml (
136 p_action IN VARCHAR2,
137 x_rowid IN VARCHAR2 DEFAULT NULL,
138 x_app_no IN NUMBER DEFAULT NULL,
139 x_address_area IN VARCHAR2 DEFAULT NULL,
140 x_address1 IN VARCHAR2 DEFAULT NULL,
141 x_address2 IN VARCHAR2 DEFAULT NULL,
142 x_address3 IN VARCHAR2 DEFAULT NULL,
143 x_address4 IN VARCHAR2 DEFAULT NULL,
144 x_post_code IN VARCHAR2 DEFAULT NULL,
145 x_mail_sort IN VARCHAR2 DEFAULT NULL,
146 x_telephone IN VARCHAR2 DEFAULT NULL,
147 x_fax IN VARCHAR2 DEFAULT NULL,
148 x_email IN VARCHAR2 DEFAULT NULL,
149 x_home_address1 IN VARCHAR2 DEFAULT NULL,
150 x_home_address2 IN VARCHAR2 DEFAULT NULL,
151 x_home_address3 IN VARCHAR2 DEFAULT NULL,
152 x_home_address4 IN VARCHAR2 DEFAULT NULL,
153 x_home_postcode IN VARCHAR2 DEFAULT NULL,
154 x_home_phone IN VARCHAR2 DEFAULT NULL,
155 x_home_fax IN VARCHAR2 DEFAULT NULL,
156 x_home_email IN VARCHAR2 DEFAULT NULL,
157 x_sent_to_oss_flag IN VARCHAR2 DEFAULT NULL,
158 x_ad_batch_id IN NUMBER DEFAULT NULL,
159 x_ad_interface_id IN NUMBER DEFAULT NULL,
160 x_mobile IN VARCHAR2 DEFAULT NULL,
161 x_country_code IN VARCHAR2 DEFAULT NULL,
162 x_home_country_code IN VARCHAR2 DEFAULT NULL,
163 x_creation_date IN DATE DEFAULT NULL,
164 x_created_by IN NUMBER DEFAULT NULL,
165 x_last_update_date IN DATE DEFAULT NULL,
166 x_last_updated_by IN NUMBER DEFAULT NULL,
167 x_last_update_login IN NUMBER DEFAULT NULL
168 );
169
170 END igs_uc_app_addreses_pkg;