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_AVF_OPER_VSTS_PVT dependencies on STANDARD

Line 110: -- Standard IN Parameters :

106: -- Type : Private
107: -- Function : Procedure to create visit based on operational params
108: -- Parameters :
109: --
110: -- Standard IN Parameters :
111: -- p_api_version IN NUMBER Required
112: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
114: --

Line 115: -- Standard OUT Parameters :

111: -- p_api_version IN NUMBER Required
112: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
114: --
115: -- Standard OUT Parameters :
116: -- x_return_status OUT VARCHAR2 Required
117: -- x_msg_count OUT NUMBER Required
118: -- x_msg_data OUT VARCHAR2 Required
119: --------------------------------------------------------------------------------------------------------------------

Line 131: -- Standard in/out parameters

127: x_msg_data OUT NOCOPY VARCHAR2)IS
128:
129: -- Local Variables
130:
131: -- Standard in/out parameters
132: l_api_name VARCHAR2(30) := 'CREATE_OPER_VISIT';
133: l_api_version NUMBER := 1.0;
134: l_debug_key CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
135: l_msg_count NUMBER;

Line 294: -- Standard start of API savepoint

290: 'At the start of PLSQL procedure'
291: );
292: END IF;
293:
294: -- Standard start of API savepoint
295: SAVEPOINT Create_Oper_Visit_pvt;
296:
297: -- Initialize message list if p_init_msg_list is set to TRUE
298:

Line 306: -- Standard call to check for call compatibility.

302:
303: -- Initialize API return status to success
304: x_return_status := FND_API.G_RET_STS_SUCCESS;
305:
306: -- Standard call to check for call compatibility.
307: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
308: p_api_version,
309: l_api_name,G_PKG_NAME)
310: THEN

Line 1209: -- Standard check of p_commit.

1205: END LOOP;
1206:
1207: ---------------------------End of Body-------------------------------------
1208: -- END of API body.
1209: -- Standard check of p_commit.
1210:
1211: IF Fnd_Api.To_Boolean (p_commit) THEN
1212: COMMIT WORK;
1213: END IF;

Line 1451: -- Standard IN Parameters :

1447: -- Type : Private
1448: -- Function : Procedure to Update visit based on operational params
1449: -- Parameters :
1450: --
1451: -- Standard IN Parameters :
1452: -- p_api_version IN NUMBER Required
1453: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1454: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1455: --

Line 1456: -- Standard OUT Parameters :

1452: -- p_api_version IN NUMBER Required
1453: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1454: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1455: --
1456: -- Standard OUT Parameters :
1457: -- x_return_status OUT VARCHAR2 Required
1458: -- x_msg_count OUT NUMBER Required
1459: -- x_msg_data OUT VARCHAR2 Required
1460: --------------------------------------------------------------------------------------------------------------------

Line 1472: -- Standard in/out parameters

1468: x_msg_data OUT NOCOPY VARCHAR2)IS
1469:
1470: -- Local Variables
1471:
1472: -- Standard in/out parameters
1473: l_api_name VARCHAR2(30) := 'Update_Oper_Visit';
1474: l_api_version NUMBER := 1.0;
1475: l_debug_key CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
1476: l_msg_count NUMBER;

Line 1705: -- Standard start of API savepoint

1701: 'At the start of PLSQL procedure'
1702: );
1703: END IF;
1704:
1705: -- Standard start of API savepoint
1706: SAVEPOINT Update_Oper_Visit_pvt;
1707:
1708: -- Initialize message list if p_init_msg_list is set to TRUE
1709:

Line 1717: -- Standard call to check for call compatibility.

1713:
1714: -- Initialize API return status to success
1715: x_return_status := FND_API.G_RET_STS_SUCCESS;
1716:
1717: -- Standard call to check for call compatibility.
1718: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1719: p_api_version,
1720: l_api_name,G_PKG_NAME)
1721: THEN

Line 4053: -- Standard check of p_commit.

4049: WHERE UNIT_SCHEDULE_ID = flight_schedule_rec.UNIT_SCHEDULE_ID;
4050: END LOOP;
4051:
4052: -- END of API body.
4053: -- Standard check of p_commit.
4054: IF Fnd_Api.To_Boolean (p_commit) THEN
4055: COMMIT WORK;
4056: END IF;
4057:

Line 4115: -- Standard OUT Parameters :

4111: -- Create_Departure_visit Parameters
4112: -- p_oper_param_rec IN oper_param_rec_type Required
4113: -- p_flight_schedule_rec IN flight_schedule_rec_type Required
4114: --
4115: -- Standard OUT Parameters :
4116: -- x_return_status OUT VARCHAR2 Required
4117: -- x_msg_count OUT NUMBER Required
4118: -- x_msg_data OUT VARCHAR2 Required
4119: --

Line 4375: -- Standard OUT Parameters :

4371: -- Create_Arrival_visit Parameters
4372: -- p_oper_param_rec IN oper_param_rec_type Required
4373: -- p_flight_schedule_rec IN flight_schedule_rec_type Required
4374: --
4375: -- Standard OUT Parameters :
4376: -- x_return_status OUT VARCHAR2 Required
4377: -- x_msg_count OUT NUMBER Required
4378: -- x_msg_data OUT VARCHAR2 Required
4379: ----------------------------------------------------------------------------------------

Line 4634: -- Standard OUT Parameters :

4630: -- Create_Downtime_visit Parameters
4631: -- p_oper_param_rec IN oper_param_rec_type Required
4632: -- p_flight_schedule_rec IN flight_schedule_rec_type Required
4633: --
4634: -- Standard OUT Parameters :
4635: -- x_return_status OUT VARCHAR2 Required
4636: -- x_msg_count OUT NUMBER Required
4637: -- x_msg_data OUT VARCHAR2 Required
4638: --

Line 5062: -- Standard start of API savepoint

5058: l_msg_index_out NUMBER;
5059:
5060: BEGIN
5061:
5062: -- Standard start of API savepoint
5063: SAVEPOINT Process_Operational_visits;
5064:
5065: -- 1. Initialize error message stack by default
5066: FND_MSG_PUB.Initialize;

Line 5068: -- Standard call to check for call compatibility

5064:
5065: -- 1. Initialize error message stack by default
5066: FND_MSG_PUB.Initialize;
5067:
5068: -- Standard call to check for call compatibility
5069: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
5070: retcode := 2;
5071: errbuf := FND_MSG_PUB.Get;
5072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5334: -- Standard check of p_commit

5330: RETURN;
5331: END IF;
5332: END IF;
5333:
5334: -- Standard check of p_commit
5335: IF FND_API.TO_BOOLEAN(p_commit) THEN
5336: COMMIT WORK;
5337: END IF;
5338:

Line 5490: -- Standard check of p_commit

5486: RETURN;
5487: END IF;
5488: END IF;
5489:
5490: -- Standard check of p_commit
5491: IF FND_API.TO_BOOLEAN(p_commit) THEN
5492: COMMIT WORK;
5493: END IF;
5494:

Line 5645: -- Standard check of p_commit

5641: RETURN;
5642: END IF;
5643: END IF;
5644:
5645: -- Standard check of p_commit
5646: IF FND_API.TO_BOOLEAN(p_commit) THEN
5647: COMMIT WORK;
5648: END IF;
5649:

Line 5800: -- Standard check of p_commit

5796: RETURN;
5797: END IF;
5798: END IF;
5799:
5800: -- Standard check of p_commit
5801: IF FND_API.TO_BOOLEAN(p_commit) THEN
5802: COMMIT WORK;
5803: END IF;
5804:

Line 5860: -- Standard start of API savepoint

5856: IF (l_log_procedure >= l_log_current_level) THEN
5857: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
5858: END IF;
5859:
5860: -- Standard start of API savepoint
5861: SAVEPOINT Load_Can_Cancel_Visit;
5862:
5863: -- initialize procedure return status to success
5864: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5976: -- Standard start of API savepoint

5972: IF (l_log_procedure >= l_log_current_level) THEN
5973: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
5974: END IF;
5975:
5976: -- Standard start of API savepoint
5977: SAVEPOINT Disconnect_Flight_Visit;
5978:
5979: -- initialize procedure return status to success
5980: x_return_status := FND_API.G_RET_STS_SUCCESS;