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
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: --
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)
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,
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,
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
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: --
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)
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,
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
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
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: --
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)
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,
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
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
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: --
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)
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,
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
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
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: --
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)
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,
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,
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
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: --
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)
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,
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