99: -- Pre-reqs :
100: --
101: -- Standard IN Parameters :
102: -- p_api_version IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
106: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
107: -- p_module_type IN VARCHAR2 Required, default NULL
100: --
101: -- Standard IN Parameters :
102: -- p_api_version IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
106: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
107: -- p_module_type IN VARCHAR2 Required, default NULL
108:
101: -- Standard IN Parameters :
102: -- p_api_version IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
106: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
107: -- p_module_type IN VARCHAR2 Required, default NULL
108:
109: -- Standard OUT Parameters :
102: -- p_api_version IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
106: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
107: -- p_module_type IN VARCHAR2 Required, default NULL
108:
109: -- Standard OUT Parameters :
110: -- x_return_status OUT VARCHAR2 Required
121: -- End of Comments --
122: /*#
123: * Use this procedure to retrieve flight schedule details for the given search criteria.
124: * @param p_api_version API Version Number.
125: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
126: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
127: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
128: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
129: * @param p_module_type For Internal use only, should always be NULL, default value NULL
122: /*#
123: * Use this procedure to retrieve flight schedule details for the given search criteria.
124: * @param p_api_version API Version Number.
125: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
126: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
127: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
128: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
129: * @param p_module_type For Internal use only, should always be NULL, default value NULL
130: * @param x_return_status API Return status. Standard API parameter
123: * Use this procedure to retrieve flight schedule details for the given search criteria.
124: * @param p_api_version API Version Number.
125: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
126: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
127: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
128: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
129: * @param p_module_type For Internal use only, should always be NULL, default value NULL
130: * @param x_return_status API Return status. Standard API parameter
131: * @param x_msg_count API Return message count, if any. Standard API parameter
124: * @param p_api_version API Version Number.
125: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
126: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
127: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
128: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
129: * @param p_module_type For Internal use only, should always be NULL, default value NULL
130: * @param x_return_status API Return status. Standard API parameter
131: * @param x_msg_count API Return message count, if any. Standard API parameter
132: * @param x_msg_data API Return message data, if any. Standard API parameter
139: PROCEDURE Get_Flight_Schedule_Details
140: (
141: -- standard IN params
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
144: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
145: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
146: p_default IN VARCHAR2 :=FND_API.G_FALSE,
147: p_module_type IN VARCHAR2 :=NULL,
140: (
141: -- standard IN params
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
144: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
145: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
146: p_default IN VARCHAR2 :=FND_API.G_FALSE,
147: p_module_type IN VARCHAR2 :=NULL,
148: -- standard OUT params
141: -- standard IN params
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
144: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
145: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
146: p_default IN VARCHAR2 :=FND_API.G_FALSE,
147: p_module_type IN VARCHAR2 :=NULL,
148: -- standard OUT params
149: x_return_status OUT NOCOPY VARCHAR2,
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
144: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
145: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
146: p_default IN VARCHAR2 :=FND_API.G_FALSE,
147: p_module_type IN VARCHAR2 :=NULL,
148: -- standard OUT params
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
162: -- Pre-reqs :
163: --
164: -- Standard IN Parameters :
165: -- p_api_version IN NUMBER Required
166: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
167: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
168: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
169: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
170: -- p_module_type IN VARCHAR2 Required, default NULL
163: --
164: -- Standard IN Parameters :
165: -- p_api_version IN NUMBER Required
166: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
167: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
168: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
169: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
170: -- p_module_type IN VARCHAR2 Required, default NULL
171:
164: -- Standard IN Parameters :
165: -- p_api_version IN NUMBER Required
166: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
167: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
168: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
169: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
170: -- p_module_type IN VARCHAR2 Required, default NULL
171:
172: -- Standard OUT Parameters :
165: -- p_api_version IN NUMBER Required
166: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
167: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
168: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
169: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
170: -- p_module_type IN VARCHAR2 Required, default NULL
171:
172: -- Standard OUT Parameters :
173: -- x_return_status OUT VARCHAR2 Required
183: -- End of Comments --
184: /*#
185: * Use this procedure to create, update and delete flight schedules.
186: * @param p_api_version API Version Number.
187: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
188: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
189: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
190: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
191: * @param p_module_type For Internal use only, should always be NULL, default value NULL
184: /*#
185: * Use this procedure to create, update and delete flight schedules.
186: * @param p_api_version API Version Number.
187: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
188: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
189: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
190: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
191: * @param p_module_type For Internal use only, should always be NULL, default value NULL
192: * @param x_return_status API Return status. Standard API parameter
185: * Use this procedure to create, update and delete flight schedules.
186: * @param p_api_version API Version Number.
187: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
188: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
189: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
190: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
191: * @param p_module_type For Internal use only, should always be NULL, default value NULL
192: * @param x_return_status API Return status. Standard API parameter
193: * @param x_msg_count API Return message count, if any. Standard API parameter
186: * @param p_api_version API Version Number.
187: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
188: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
189: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
190: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
191: * @param p_module_type For Internal use only, should always be NULL, default value NULL
192: * @param x_return_status API Return status. Standard API parameter
193: * @param x_msg_count API Return message count, if any. Standard API parameter
194: * @param x_msg_data API Return message data, if any. Standard API parameter
200: PROCEDURE Process_Flight_Schedules
201: (
202: -- standard IN params
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
205: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
206: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
207: p_default IN VARCHAR2 :=FND_API.G_FALSE,
208: p_module_type IN VARCHAR2 :=NULL,
201: (
202: -- standard IN params
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
205: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
206: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
207: p_default IN VARCHAR2 :=FND_API.G_FALSE,
208: p_module_type IN VARCHAR2 :=NULL,
209: -- standard OUT params
202: -- standard IN params
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
205: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
206: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
207: p_default IN VARCHAR2 :=FND_API.G_FALSE,
208: p_module_type IN VARCHAR2 :=NULL,
209: -- standard OUT params
210: x_return_status OUT NOCOPY VARCHAR2,
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
205: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
206: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
207: p_default IN VARCHAR2 :=FND_API.G_FALSE,
208: p_module_type IN VARCHAR2 :=NULL,
209: -- standard OUT params
210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
222: -- Pre-reqs :
223: --
224: -- Standard IN Parameters :
225: -- p_api_version IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
227: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
229: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
230: -- p_module_type IN VARCHAR2 Required, default NULL
223: --
224: -- Standard IN Parameters :
225: -- p_api_version IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
227: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
229: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
230: -- p_module_type IN VARCHAR2 Required, default NULL
231:
224: -- Standard IN Parameters :
225: -- p_api_version IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
227: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
229: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
230: -- p_module_type IN VARCHAR2 Required, default NULL
231:
232: -- Standard OUT Parameters :
225: -- p_api_version IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
227: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
229: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
230: -- p_module_type IN VARCHAR2 Required, default NULL
231:
232: -- Standard OUT Parameters :
233: -- x_return_status OUT VARCHAR2 Required
243: -- End of Comments --
244: /*#
245: * Use this procedure to create flight schedules with following transit visits, using parameters from the created flight schedules. It can also be used to update and delete flight schedules.
246: * @param p_api_version API Version Number.
247: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
248: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
249: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
250: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
251: * @param p_module_type For Internal use only, should always be NULL, default value NULL
244: /*#
245: * Use this procedure to create flight schedules with following transit visits, using parameters from the created flight schedules. It can also be used to update and delete flight schedules.
246: * @param p_api_version API Version Number.
247: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
248: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
249: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
250: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
251: * @param p_module_type For Internal use only, should always be NULL, default value NULL
252: * @param x_return_status API Return status. Standard API parameter
245: * Use this procedure to create flight schedules with following transit visits, using parameters from the created flight schedules. It can also be used to update and delete flight schedules.
246: * @param p_api_version API Version Number.
247: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
248: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
249: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
250: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
251: * @param p_module_type For Internal use only, should always be NULL, default value NULL
252: * @param x_return_status API Return status. Standard API parameter
253: * @param x_msg_count API Return message count, if any. Standard API parameter
246: * @param p_api_version API Version Number.
247: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
248: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
249: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
250: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
251: * @param p_module_type For Internal use only, should always be NULL, default value NULL
252: * @param x_return_status API Return status. Standard API parameter
253: * @param x_msg_count API Return message count, if any. Standard API parameter
254: * @param x_msg_data API Return message data, if any. Standard API parameter
260: PROCEDURE Process_FlightVisit_Sch
261: (
262: -- standard IN params
263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
265: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
266: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
267: p_default IN VARCHAR2 :=FND_API.G_FALSE,
268: p_module_type IN VARCHAR2 :=NULL,
261: (
262: -- standard IN params
263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
265: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
266: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
267: p_default IN VARCHAR2 :=FND_API.G_FALSE,
268: p_module_type IN VARCHAR2 :=NULL,
269: -- standard OUT params
262: -- standard IN params
263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
265: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
266: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
267: p_default IN VARCHAR2 :=FND_API.G_FALSE,
268: p_module_type IN VARCHAR2 :=NULL,
269: -- standard OUT params
270: x_return_status OUT NOCOPY VARCHAR2,
263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
265: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
266: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
267: p_default IN VARCHAR2 :=FND_API.G_FALSE,
268: p_module_type IN VARCHAR2 :=NULL,
269: -- standard OUT params
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,