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 AHL_UA_FLIGHT_SCHEDULES_PVT

Line 24: x_flight_schedules_tbl OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE

20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2,
22: -- procedure params
23: p_flight_search_rec IN FLIGHT_SEARCH_REC_TYPE,
24: x_flight_schedules_tbl OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
25: )
26: IS
27:
28: l_api_name CONSTANT VARCHAR2(30) := 'SEARCH_FLIGHT_SCHEDULES';

Line 38: l_flight_schedule_rec AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULE_REC_TYPE;

34: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
35: l_bind_index NUMBER;
36: l_super_user VARCHAR2(1);
37: l_unit_schedule_id NUMBER;
38: l_flight_schedule_rec AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULE_REC_TYPE;
39: BEGIN
40:
41: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
42: fnd_log.string

Line 331: l_super_user := AHL_UA_FLIGHT_SCHEDULES_PVT.is_super_user;

327:
328: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_flight_schedule_csr, l_bind_value_tbl, l_search_Query);
329:
330: i := 0;
331: l_super_user := AHL_UA_FLIGHT_SCHEDULES_PVT.is_super_user;
332:
333: --OPEN l_flight_schedule_csr FOR l_search_Query;
334: LOOP
335: --Get search results

Line 432: x_flight_schedules_tbl(i).is_delete_allowed := AHL_UA_FLIGHT_SCHEDULES_PVT.is_delete_allowed(

428: x_flight_schedules_tbl(i).ATTRIBUTE14 := l_flight_schedule_rec.ATTRIBUTE14;
429: x_flight_schedules_tbl(i).ATTRIBUTE15 := l_flight_schedule_rec.ATTRIBUTE15;
430:
431: -- Find if record can be updated and deleted.
432: x_flight_schedules_tbl(i).is_delete_allowed := AHL_UA_FLIGHT_SCHEDULES_PVT.is_delete_allowed(
433: p_unit_schedule_id => x_flight_schedules_tbl(i).unit_schedule_id,
434: p_is_super_user => l_super_user
435: );
436: x_flight_schedules_tbl(i).is_update_allowed := AHL_UA_FLIGHT_SCHEDULES_PVT.is_update_allowed(

Line 436: x_flight_schedules_tbl(i).is_update_allowed := AHL_UA_FLIGHT_SCHEDULES_PVT.is_update_allowed(

432: x_flight_schedules_tbl(i).is_delete_allowed := AHL_UA_FLIGHT_SCHEDULES_PVT.is_delete_allowed(
433: p_unit_schedule_id => x_flight_schedules_tbl(i).unit_schedule_id,
434: p_is_super_user => l_super_user
435: );
436: x_flight_schedules_tbl(i).is_update_allowed := AHL_UA_FLIGHT_SCHEDULES_PVT.is_update_allowed(
437: p_unit_schedule_id => x_flight_schedules_tbl(i).unit_schedule_id,
438: p_is_super_user => l_super_user
439: );
440: END LOOP;

Line 475: -- Public wrapper for AHL_UA_FLIGHT_SCHEDULES_PVT.process_flight_schedules

471:
472:
473:
474: --------------------------------------------------------------------------------
475: -- Public wrapper for AHL_UA_FLIGHT_SCHEDULES_PVT.process_flight_schedules
476: ------------------------------------------------------------------------------------------
477:
478: PROCEDURE Process_Flight_Schedules
479: (

Line 492: p_x_flight_schedules_tbl IN OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE

488: x_return_status OUT NOCOPY VARCHAR2,
489: x_msg_count OUT NOCOPY NUMBER,
490: x_msg_data OUT NOCOPY VARCHAR2,
491: -- procedure params
492: p_x_flight_schedules_tbl IN OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
493: )
494: IS
495: l_api_name CONSTANT VARCHAR2(30) := 'Process_Flight_Schedules';
496: l_api_version CONSTANT NUMBER := 1.0;

Line 693: AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules(

689: 'Before calling the private API.....'
690: );
691: END IF;
692:
693: AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules(
694: p_api_version => p_api_version,
695: p_init_msg_list => p_init_msg_list,
696: p_commit => p_commit,
697: p_validation_level => p_validation_level,

Line 819: l_x_flight_schedules_tbl AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE;

815: x_msg_data OUT NOCOPY VARCHAR2
816: )
817: IS
818: i NUMBER;
819: l_x_flight_schedules_tbl AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE;
820: l_api_name CONSTANT VARCHAR2(30) := 'handle_flight_schedules';
821: BEGIN
822:
823: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 894: 'Calling AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules..'

890: fnd_log.string
891: (
892: fnd_log.level_statement,
893: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
894: 'Calling AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules..'
895: );
896: END IF;
897:
898: AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules(

Line 898: AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules(

894: 'Calling AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules..'
895: );
896: END IF;
897:
898: AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules(
899: p_api_version => 1.0,
900: p_init_msg_list => FND_API.G_FALSE,
901: p_commit => FND_API.G_FALSE,
902: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 916: 'After calling AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules....'

912: fnd_log.string
913: (
914: fnd_log.level_statement,
915: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
916: 'After calling AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules....'
917: );
918: END IF;
919:
920: -- Check Error Message stack.

Line 927: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'

923: fnd_log.string
924: (
925: fnd_log.level_error,
926: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
927: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
928: );
929: END IF;
930: RAISE FND_API.G_EXC_ERROR;
931: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 937: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'

933: fnd_log.string
934: (
935: fnd_log.level_error,
936: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
937: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'
938: );
939: END IF;
940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
941: END IF;

Line 1027: l_x_succ_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;

1023: IS
1024: l_x_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
1025: l_x_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
1026: l_is_conflict VARCHAR2(1);
1027: l_x_succ_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;
1028: i NUMBER;
1029: j NUMBER;
1030: l_api_name CONSTANT VARCHAR2(30) := 'auto_create_transit_visit';
1031: l_api_version CONSTANT NUMBER := 1.0;

Line 1095: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'

1091: fnd_log.string
1092: (
1093: fnd_log.level_error,
1094: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1095: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
1096: );
1097: END IF;
1098: RAISE FND_API.G_EXC_ERROR;
1099: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1105: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'

1101: fnd_log.string
1102: (
1103: fnd_log.level_error,
1104: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1105: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'
1106: );
1107: END IF;
1108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1109: END IF;

Line 1132: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'

1128: fnd_log.string
1129: (
1130: fnd_log.level_error,
1131: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1132: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
1133: );
1134: END IF;
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1142: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'

1138: fnd_log.string
1139: (
1140: fnd_log.level_error,
1141: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1142: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'
1143: );
1144: END IF;
1145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1146: END IF;