DBA Data[Home] [Help]

APPS.AHL_UA_FLIGHT_SCHEDULES_PUB dependencies on STANDARD

Line 116: -- Standard IN Parameters :

112: -- Type : Private
113: -- Function : API to retrieve flight schedule details for the given search criteria.
114: -- Pre-reqs :
115: --
116: -- Standard IN Parameters :
117: -- p_api_version IN NUMBER Required
118: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
119: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
120: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL

Line 124: -- Standard OUT Parameters :

120: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
121: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
122: -- p_module_type IN VARCHAR2 Required, default NULL
123:
124: -- Standard OUT Parameters :
125: -- x_return_status OUT VARCHAR2 Required
126: -- x_msg_count OUT NUMBER Required
127: -- x_msg_data OUT VARCHAR2 Required
128: --

Line 140: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE

136: -- End of Comments --
137: /*#
138: * Use this procedure to retrieve flight schedule details for the given search criteria.
139: * @param p_api_version API Version Number.
140: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
141: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
142: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
143: * @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
144: * @param p_module_type For Internal use only, should always be NULL, default value NULL

Line 141: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE

137: /*#
138: * Use this procedure to retrieve flight schedule details for the given search criteria.
139: * @param p_api_version API Version Number.
140: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
141: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
142: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
143: * @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
144: * @param p_module_type For Internal use only, should always be NULL, default value NULL
145: * @param x_return_status API Return status. Standard API parameter

Line 142: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL

138: * Use this procedure to retrieve flight schedule details for the given search criteria.
139: * @param p_api_version API Version Number.
140: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
141: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
142: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
143: * @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
144: * @param p_module_type For Internal use only, should always be NULL, default value NULL
145: * @param x_return_status API Return status. Standard API parameter
146: * @param x_msg_count API Return message count, if any. Standard API parameter

Line 145: * @param x_return_status API Return status. Standard API parameter

141: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
142: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
143: * @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
144: * @param p_module_type For Internal use only, should always be NULL, default value NULL
145: * @param x_return_status API Return status. Standard API parameter
146: * @param x_msg_count API Return message count, if any. Standard API parameter
147: * @param x_msg_data API Return message data, if any. Standard API parameter
148: * @param p_flight_search_rec Search criteria record of type FLIGHT_SEARCH_REC_TYPE
149: * @param x_flight_schedules_tbl Flight schedules details table of type AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE

Line 146: * @param x_msg_count API Return message count, if any. Standard API parameter

142: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
143: * @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
144: * @param p_module_type For Internal use only, should always be NULL, default value NULL
145: * @param x_return_status API Return status. Standard API parameter
146: * @param x_msg_count API Return message count, if any. Standard API parameter
147: * @param x_msg_data API Return message data, if any. Standard API parameter
148: * @param p_flight_search_rec Search criteria record of type FLIGHT_SEARCH_REC_TYPE
149: * @param x_flight_schedules_tbl Flight schedules details table of type AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
150: * @rep:scope private

Line 147: * @param x_msg_data API Return message data, if any. Standard API parameter

143: * @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
144: * @param p_module_type For Internal use only, should always be NULL, default value NULL
145: * @param x_return_status API Return status. Standard API parameter
146: * @param x_msg_count API Return message count, if any. Standard API parameter
147: * @param x_msg_data API Return message data, if any. Standard API parameter
148: * @param p_flight_search_rec Search criteria record of type FLIGHT_SEARCH_REC_TYPE
149: * @param x_flight_schedules_tbl Flight schedules details table of type AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
150: * @rep:scope private
151: * @rep:lifecycle active

Line 156: -- standard IN params

152: * @rep:displayname Get Flight Schedule Details
153: */
154: PROCEDURE Get_Flight_Schedule_Details
155: (
156: -- standard IN params
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
159: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
160: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 163: -- standard OUT params

159: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
160: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
161: p_default IN VARCHAR2 :=FND_API.G_FALSE,
162: p_module_type IN VARCHAR2 :=NULL,
163: -- standard OUT params
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: -- procedure params

Line 179: -- Standard IN Parameters :

175: -- Type : Private
176: -- Function : API to retrieve flight schedule details for the given search criteria.
177: -- Pre-reqs :
178: --
179: -- Standard IN Parameters :
180: -- p_api_version IN NUMBER Required
181: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
182: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
183: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL

Line 187: -- Standard OUT Parameters :

183: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
184: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
185: -- p_module_type IN VARCHAR2 Required, default NULL
186:
187: -- Standard OUT Parameters :
188: -- x_return_status OUT VARCHAR2 Required
189: -- x_msg_count OUT NUMBER Required
190: -- x_msg_data OUT VARCHAR2 Required
191: --

Line 202: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE

198: -- End of Comments --
199: /*#
200: * Use this procedure to create, update and delete flight schedules.
201: * @param p_api_version API Version Number.
202: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
203: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
204: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
205: * @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
206: * @param p_module_type For Internal use only, should always be NULL, default value NULL

Line 203: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE

199: /*#
200: * Use this procedure to create, update and delete flight schedules.
201: * @param p_api_version API Version Number.
202: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
203: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
204: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
205: * @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
206: * @param p_module_type For Internal use only, should always be NULL, default value NULL
207: * @param x_return_status API Return status. Standard API parameter

Line 204: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL

200: * Use this procedure to create, update and delete flight schedules.
201: * @param p_api_version API Version Number.
202: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
203: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
204: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
205: * @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
206: * @param p_module_type For Internal use only, should always be NULL, default value NULL
207: * @param x_return_status API Return status. Standard API parameter
208: * @param x_msg_count API Return message count, if any. Standard API parameter

Line 207: * @param x_return_status API Return status. Standard API parameter

203: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
204: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
205: * @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
206: * @param p_module_type For Internal use only, should always be NULL, default value NULL
207: * @param x_return_status API Return status. Standard API parameter
208: * @param x_msg_count API Return message count, if any. Standard API parameter
209: * @param x_msg_data API Return message data, if any. Standard API parameter
210: * @param p_x_flight_schedules_tbl Flight schedules table of type AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
211: * @rep:scope public

Line 208: * @param x_msg_count API Return message count, if any. Standard API parameter

204: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
205: * @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
206: * @param p_module_type For Internal use only, should always be NULL, default value NULL
207: * @param x_return_status API Return status. Standard API parameter
208: * @param x_msg_count API Return message count, if any. Standard API parameter
209: * @param x_msg_data API Return message data, if any. Standard API parameter
210: * @param p_x_flight_schedules_tbl Flight schedules table of type AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
211: * @rep:scope public
212: * @rep:lifecycle active

Line 209: * @param x_msg_data API Return message data, if any. Standard API parameter

205: * @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
206: * @param p_module_type For Internal use only, should always be NULL, default value NULL
207: * @param x_return_status API Return status. Standard API parameter
208: * @param x_msg_count API Return message count, if any. Standard API parameter
209: * @param x_msg_data API Return message data, if any. Standard API parameter
210: * @param p_x_flight_schedules_tbl Flight schedules table of type AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
211: * @rep:scope public
212: * @rep:lifecycle active
213: * @rep:displayname Process Flight Schedules

Line 217: -- standard IN params

213: * @rep:displayname Process Flight Schedules
214: */
215: PROCEDURE Process_Flight_Schedules
216: (
217: -- standard IN params
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
220: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
221: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 224: -- standard OUT params

220: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
221: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
222: p_default IN VARCHAR2 :=FND_API.G_FALSE,
223: p_module_type IN VARCHAR2 :=NULL,
224: -- standard OUT params
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: -- procedure params

Line 239: -- Standard IN Parameters :

235: -- Type : Private
236: -- Function : API to retrieve flight schedule details for the given search criteria.
237: -- Pre-reqs :
238: --
239: -- Standard IN Parameters :
240: -- p_api_version IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
242: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
243: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL

Line 247: -- Standard OUT Parameters :

243: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
244: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
245: -- p_module_type IN VARCHAR2 Required, default NULL
246:
247: -- Standard OUT Parameters :
248: -- x_return_status OUT VARCHAR2 Required
249: -- x_msg_count OUT NUMBER Required
250: -- x_msg_data OUT VARCHAR2 Required
251: --

Line 262: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE

258: -- End of Comments --
259: /*#
260: * 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.
261: * @param p_api_version API Version Number.
262: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
263: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
264: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
265: * @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
266: * @param p_module_type For Internal use only, should always be NULL, default value NULL

Line 263: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE

259: /*#
260: * 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.
261: * @param p_api_version API Version Number.
262: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
263: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
264: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
265: * @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
266: * @param p_module_type For Internal use only, should always be NULL, default value NULL
267: * @param x_return_status API Return status. Standard API parameter

Line 264: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL

260: * 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.
261: * @param p_api_version API Version Number.
262: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
263: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
264: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
265: * @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
266: * @param p_module_type For Internal use only, should always be NULL, default value NULL
267: * @param x_return_status API Return status. Standard API parameter
268: * @param x_msg_count API Return message count, if any. Standard API parameter

Line 267: * @param x_return_status API Return status. Standard API parameter

263: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
264: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
265: * @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
266: * @param p_module_type For Internal use only, should always be NULL, default value NULL
267: * @param x_return_status API Return status. Standard API parameter
268: * @param x_msg_count API Return message count, if any. Standard API parameter
269: * @param x_msg_data API Return message data, if any. Standard API parameter
270: * @param p_x_flight_visit_sch_tbl Flight and Visit schedules table of type FLIGHT_VISIT_SCH_TBL_TYPE
271: * @rep:scope public

Line 268: * @param x_msg_count API Return message count, if any. Standard API parameter

264: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
265: * @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
266: * @param p_module_type For Internal use only, should always be NULL, default value NULL
267: * @param x_return_status API Return status. Standard API parameter
268: * @param x_msg_count API Return message count, if any. Standard API parameter
269: * @param x_msg_data API Return message data, if any. Standard API parameter
270: * @param p_x_flight_visit_sch_tbl Flight and Visit schedules table of type FLIGHT_VISIT_SCH_TBL_TYPE
271: * @rep:scope public
272: * @rep:lifecycle active

Line 269: * @param x_msg_data API Return message data, if any. Standard API parameter

265: * @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
266: * @param p_module_type For Internal use only, should always be NULL, default value NULL
267: * @param x_return_status API Return status. Standard API parameter
268: * @param x_msg_count API Return message count, if any. Standard API parameter
269: * @param x_msg_data API Return message data, if any. Standard API parameter
270: * @param p_x_flight_visit_sch_tbl Flight and Visit schedules table of type FLIGHT_VISIT_SCH_TBL_TYPE
271: * @rep:scope public
272: * @rep:lifecycle active
273: * @rep:displayname Process Flight and Visit Schedules

Line 277: -- standard IN params

273: * @rep:displayname Process Flight and Visit Schedules
274: */
275: PROCEDURE Process_FlightVisit_Sch
276: (
277: -- standard IN params
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
280: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
281: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 284: -- standard OUT params

280: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
281: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
282: p_default IN VARCHAR2 :=FND_API.G_FALSE,
283: p_module_type IN VARCHAR2 :=NULL,
284: -- standard OUT params
285: x_return_status OUT NOCOPY VARCHAR2,
286: x_msg_count OUT NOCOPY NUMBER,
287: x_msg_data OUT NOCOPY VARCHAR2,
288: -- procedure params