[Home] [Help]
PACKAGE: APPS.IGS_PE_VISAPASS_PUB
Source
1 PACKAGE IGS_PE_VISAPASS_PUB AS
2 /* $Header: IGSPE16S.pls 120.1 2005/09/30 04:25:50 appldev noship $ */
3
4 /******************************************************************************
5 || Created By : ssaleem
6 || Created On : 01-Sep-2004
7 || Purpose : This public API is used to update and insert records to
8 || Visa, Passport and Visit Histry tables in IGS
9 ||
10 || Known limitations, enhancements or remarks :
11 || Change History :
12 || Who When What
13 || (reverse chronological order - newest change first)
14 ******************************************************************************/
15
16 --------------------------------------
17 -- declaration of record type
18 --------------------------------------
19
20 TYPE visa_rec_type IS RECORD(
21 visa_id igs_pe_visa.visa_id%TYPE,
22 person_id igs_pe_visa.person_id%TYPE,
23 visa_type igs_pe_visa.visa_type%TYPE,
24 visa_number igs_pe_visa.visa_number%TYPE,
25 visa_issue_date igs_pe_visa.visa_issue_date%TYPE,
26 visa_expiry_date igs_pe_visa.visa_expiry_date%TYPE,
27 visa_issuing_post igs_pe_visa.visa_issuing_post%TYPE,
28 passport_id igs_pe_visa.passport_id%TYPE,
29 agent_org_unit_cd igs_pe_visa.agent_org_unit_cd%TYPE,
30 agent_person_id igs_pe_visa.agent_person_id%TYPE,
31 agent_contact_name igs_pe_visa.agent_contact_name%TYPE,
32 attribute_category igs_pe_visa.attribute_category%TYPE,
33 attribute1 igs_pe_visa.attribute1%TYPE,
34 attribute2 igs_pe_visa.attribute2%TYPE,
35 attribute3 igs_pe_visa.attribute3%TYPE,
36 attribute4 igs_pe_visa.attribute4%TYPE,
37 attribute5 igs_pe_visa.attribute5%TYPE,
38 attribute6 igs_pe_visa.attribute6%TYPE,
39 attribute7 igs_pe_visa.attribute7%TYPE,
40 attribute8 igs_pe_visa.attribute8%TYPE,
41 attribute9 igs_pe_visa.attribute9%TYPE,
42 attribute10 igs_pe_visa.attribute10%TYPE,
43 attribute11 igs_pe_visa.attribute11%TYPE,
44 attribute12 igs_pe_visa.attribute12%TYPE,
45 attribute13 igs_pe_visa.attribute13%TYPE,
46 attribute14 igs_pe_visa.attribute14%TYPE,
47 attribute15 igs_pe_visa.attribute15%TYPE,
48 attribute16 igs_pe_visa.attribute16%TYPE,
49 attribute17 igs_pe_visa.attribute17%TYPE,
50 attribute18 igs_pe_visa.attribute18%TYPE,
51 attribute19 igs_pe_visa.attribute19%TYPE,
52 attribute20 igs_pe_visa.attribute20%TYPE,
53 visa_issuing_country igs_pe_visa.visa_issuing_country%TYPE
54 );
55
56 TYPE visit_hstry_rec_type IS RECORD(
57 port_of_entry igs_pe_visit_histry.port_of_entry%TYPE,
58 cntry_entry_form_num igs_pe_visit_histry.cntry_entry_form_num%TYPE,
59 visa_id igs_pe_visit_histry.visa_id%TYPE,
60 visit_start_date igs_pe_visit_histry.visit_start_date%TYPE,
61 visit_end_date igs_pe_visit_histry.visit_end_date%TYPE,
62 remarks igs_pe_visit_histry.remarks%TYPE
63 );
64
65 TYPE passport_rec_type IS RECORD(
66 passport_id igs_pe_passport.passport_id%TYPE,
67 person_id igs_pe_passport.person_id%TYPE,
68 passport_number igs_pe_passport.passport_number%TYPE,
69 passport_expiry_date igs_pe_passport.passport_expiry_date%TYPE,
70 passport_cntry_code igs_pe_passport.passport_cntry_code%TYPE
71 );
72
73
74 -- Start of comments
75 -- API name : Create_Visa
76 -- Type : Public
77 -- Function :
78 -- Pre-reqs : None.
79 -- Parameters :
80 -- IN : p_api_version IN NUMBER Required
81 -- p_init_msg_list IN VARCHAR2 Optional
82 -- Default = FND_API.G_FALSE
83 -- p_commit IN VARCHAR2 Optional
84 -- Default = FND_API.G_FALSE
85 -- Default = FND_API.G_VALID_LEVEL_FULL
86 -- p_visa_rec IN visa_rec_type
87 --
88 --
89 -- OUT : x_return_status OUT VARCHAR2(1)
90 -- x_msg_count OUT NUMBER
91 -- x_msg_data OUT VARCHAR2(2000)
92 -- x_visa_id OUT NUMBER
93 --
94 --
95 --
96 -- Version : Current version x.x
97 -- Changed....
98 -- previous version y.y
99 -- Changed....
100 -- .
101 -- .
102 -- Initial version 1.0
103 --
104 -- Notes :
105 --
106 -- End of comments
107
108 PROCEDURE Create_Visa
109 ( p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
111 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_visa_rec IN visa_rec_type,
116 x_visa_id OUT NOCOPY NUMBER
117 );
118
119
120 -- Start of comments
121 -- API name : Update_Visa
122 -- Type : Public
123 -- Function :
124 -- Pre-reqs : None.
125 -- Parameters :
126 -- IN : p_api_version IN NUMBER Required
127 -- p_init_msg_list IN VARCHAR2 Optional
128 -- Default = FND_API.G_FALSE
129 -- p_commit IN VARCHAR2 Optional
130 -- Default = FND_API.G_FALSE
131 -- Default = FND_API.G_VALID_LEVEL_FULL
132 -- p_visa_rec IN visa_rec_type
133 --
134 --
135 -- OUT : x_return_status OUT VARCHAR2(1)
136 -- x_msg_count OUT NUMBER
137 -- x_msg_data OUT VARCHAR2(2000)
138 --
139 --
140 --
141 -- Version : Current version x.x
142 -- Changed....
143 -- previous version y.y
144 -- Changed....
145 -- .
146 -- .
147 -- Initial version 1.0
148 --
149 -- Notes :
150 --
151 -- End of comments
152
153 PROCEDURE Update_Visa
154 ( p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
156 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_visa_rec IN visa_rec_type
161 );
162
163
164
165
166 -- Start of comments
167 -- API name : Create_VisitHistry
168 -- Type : Public
169 -- Function :
170 -- Pre-reqs : None.
171 -- Parameters :
172 -- IN : p_api_version IN NUMBER Required
173 -- p_init_msg_list IN VARCHAR2 Optional
174 -- Default = FND_API.G_FALSE
175 -- p_commit IN VARCHAR2 Optional
176 -- Default = FND_API.G_FALSE
177 -- Default = FND_API.G_VALID_LEVEL_FULL
178 -- p_visit_hstry_rec IN visit_hstry_rec_type
179 --
180 --
181 -- OUT : x_return_status OUT VARCHAR2(1)
182 -- x_msg_count OUT NUMBER
183 -- x_msg_data OUT VARCHAR2(2000)
184 --
185 --
186 --
187 --
188 -- Version : Current version x.x
189 -- Changed....
190 -- previous version y.y
191 -- Changed....
192 -- .
193 -- .
194 -- Initial version 1.0
195 --
196 -- Notes :
197 --
198 -- End of comments
199
200 PROCEDURE Create_VisitHistry
201 ( p_api_version IN NUMBER,
202 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
203 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_visit_hstry_rec IN visit_hstry_rec_type
208 );
209
210
211 -- Start of comments
212 -- API name : Update_VisitHistry
213 -- Type : Public
214 -- Function :
215 -- Pre-reqs : None.
216 -- Parameters :
217 -- IN : p_api_version IN NUMBER Required
218 -- p_init_msg_list IN VARCHAR2 Optional
219 -- Default = FND_API.G_FALSE
220 -- p_commit IN VARCHAR2 Optional
221 -- Default = FND_API.G_FALSE
222 -- Default = FND_API.G_VALID_LEVEL_FULL
223 -- p_visit_hstry_rec IN visit_hstry_rec_type
224 --
225 --
226 -- OUT : x_return_status OUT VARCHAR2(1)
227 -- x_msg_count OUT NUMBER
228 -- x_msg_data OUT VARCHAR2(2000)
229 --
230 --
231 --
232 -- Version : Current version x.x
233 -- Changed....
234 -- previous version y.y
235 -- Changed....
236 -- .
237 -- .
238 -- Initial version 1.0
239 --
240 -- Notes :
241 --
242 -- End of comments
243
244 PROCEDURE Update_VisitHistry
245 ( p_api_version IN NUMBER,
246 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
247 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
248 x_return_status OUT NOCOPY VARCHAR2,
249 x_msg_count OUT NOCOPY NUMBER,
250 x_msg_data OUT NOCOPY VARCHAR2,
251 p_visit_hstry_rec IN visit_hstry_rec_type
252 );
253
254
255 -- Start of comments
256 -- API name : Create_Passport
257 -- Type : Public
258 -- Function :
259 -- Pre-reqs : None.
260 -- Parameters :
261 -- IN : p_api_version IN NUMBER Required
262 -- p_init_msg_list IN VARCHAR2 Optional
263 -- Default = FND_API.G_FALSE
264 -- p_commit IN VARCHAR2 Optional
265 -- Default = FND_API.G_FALSE
266 -- Default = FND_API.G_VALID_LEVEL_FULL
267 -- p_passport_rec IN passport_rec_type
268 --
269 --
270 -- OUT : x_return_status OUT VARCHAR2(1)
271 -- x_msg_count OUT NUMBER
272 -- x_msg_data OUT VARCHAR2(2000)
273 -- x_passport_id OUT NUMBER
274 --
275 --
276 --
277 -- Version : Current version x.x
278 -- Changed....
279 -- previous version y.y
280 -- Changed....
281 -- .
282 -- .
283 -- Initial version 1.0
284 --
285 -- Notes :
286 --
287 -- End of comments
288
289 PROCEDURE Create_Passport
290 ( p_api_version IN NUMBER,
291 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
292 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
293 x_return_status OUT NOCOPY VARCHAR2,
294 x_msg_count OUT NOCOPY NUMBER,
295 x_msg_data OUT NOCOPY VARCHAR2,
296 p_passport_rec IN passport_rec_type,
297 x_passport_id OUT NOCOPY NUMBER
298 );
299
300
301 -- Start of comments
302 -- API name : Update_Passport
303 -- Type : Public
304 -- Function :
305 -- Pre-reqs : None.
306 -- Parameters :
307 -- IN : p_api_version IN NUMBER Required
308 -- p_init_msg_list IN VARCHAR2 Optional
309 -- Default = FND_API.G_FALSE
310 -- p_commit IN VARCHAR2 Optional
311 -- Default = FND_API.G_FALSE
312 -- Default = FND_API.G_VALID_LEVEL_FULL
313 -- p_passport_rec IN passport_rec_type
314 --
315 --
316 -- OUT : x_return_status OUT VARCHAR2(1)
317 -- x_msg_count OUT NUMBER
318 -- x_msg_data OUT VARCHAR2(2000)
319 --
320 --
321 --
322 -- Version : Current version x.x
323 -- Changed....
324 -- previous version y.y
325 -- Changed....
326 -- .
327 -- .
328 -- Initial version 1.0
329 --
330 -- Notes :
331 --
332 -- End of comments
333
334 PROCEDURE Update_Passport
335 ( p_api_version IN NUMBER,
336 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
337 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
338 x_return_status OUT NOCOPY VARCHAR2,
339 x_msg_count OUT NOCOPY NUMBER,
340 x_msg_data OUT NOCOPY VARCHAR2,
341 p_passport_rec IN passport_rec_type
342 );
343
344 END IGS_PE_VISAPASS_PUB;