eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UA_FLIGHT_SCHEDULES_PUB dependencies on STANDARD

Line 101: -- Standard IN Parameters :

97: -- Type : Private
98: -- Function : API to retrieve flight schedule details for the given search criteria.
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

Line 109: -- Standard OUT Parameters :

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
111: -- x_msg_count OUT NUMBER Required
112: -- x_msg_data OUT VARCHAR2 Required
113: --

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

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

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

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

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

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

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

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
133: * @param p_flight_search_rec Search criteria record of type FLIGHT_SEARCH_REC_TYPE
134: * @param x_flight_schedules_tbl Flight schedules details table of type AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE

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

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
133: * @param p_flight_search_rec Search criteria record of type FLIGHT_SEARCH_REC_TYPE
134: * @param x_flight_schedules_tbl Flight schedules details table of type AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
135: * @rep:scope private

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

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
133: * @param p_flight_search_rec Search criteria record of type FLIGHT_SEARCH_REC_TYPE
134: * @param x_flight_schedules_tbl Flight schedules details table of type AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
135: * @rep:scope private
136: * @rep:lifecycle active

Line 141: -- standard IN params

137: * @rep:displayname Get Flight Schedule Details
138: */
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,

Line 148: -- standard OUT params

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,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: -- procedure params

Line 164: -- Standard IN Parameters :

160: -- Type : Private
161: -- Function : API to retrieve flight schedule details for the given search criteria.
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

Line 172: -- Standard OUT Parameters :

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
174: -- x_msg_count OUT NUMBER Required
175: -- x_msg_data OUT VARCHAR2 Required
176: --

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

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

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

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

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

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

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

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
195: * @param p_x_flight_schedules_tbl Flight schedules table of type AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
196: * @rep:scope public

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

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
195: * @param p_x_flight_schedules_tbl Flight schedules table of type AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
196: * @rep:scope public
197: * @rep:lifecycle active

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

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
195: * @param p_x_flight_schedules_tbl Flight schedules table of type AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
196: * @rep:scope public
197: * @rep:lifecycle active
198: * @rep:displayname Process Flight Schedules

Line 202: -- standard IN params

198: * @rep:displayname Process Flight Schedules
199: */
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,

Line 209: -- standard OUT params

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,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: -- procedure params

Line 224: -- Standard IN Parameters :

220: -- Type : Private
221: -- Function : API to retrieve flight schedule details for the given search criteria.
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

Line 232: -- Standard OUT Parameters :

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
234: -- x_msg_count OUT NUMBER Required
235: -- x_msg_data OUT VARCHAR2 Required
236: --

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

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

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

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

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

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

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

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
255: * @param p_x_flight_visit_sch_tbl Flight and Visit schedules table of type FLIGHT_VISIT_SCH_TBL_TYPE
256: * @rep:scope public

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

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
255: * @param p_x_flight_visit_sch_tbl Flight and Visit schedules table of type FLIGHT_VISIT_SCH_TBL_TYPE
256: * @rep:scope public
257: * @rep:lifecycle active

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

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
255: * @param p_x_flight_visit_sch_tbl Flight and Visit schedules table of type FLIGHT_VISIT_SCH_TBL_TYPE
256: * @rep:scope public
257: * @rep:lifecycle active
258: * @rep:displayname Process Flight and Visit Schedules

Line 262: -- standard IN params

258: * @rep:displayname Process Flight and Visit Schedules
259: */
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,

Line 269: -- standard OUT params

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,
272: x_msg_data OUT NOCOPY VARCHAR2,
273: -- procedure params