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 326: l_super_user := AHL_UA_FLIGHT_SCHEDULES_PVT.is_super_user;

322:
323: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_flight_schedule_csr, l_bind_value_tbl, l_search_Query);
324:
325: i := 0;
326: l_super_user := AHL_UA_FLIGHT_SCHEDULES_PVT.is_super_user;
327:
328: --OPEN l_flight_schedule_csr FOR l_search_Query;
329: LOOP
330: --Get search results

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

413: x_flight_schedules_tbl(i).ATTRIBUTE14 := l_flight_schedule_rec.ATTRIBUTE14;
414: x_flight_schedules_tbl(i).ATTRIBUTE15 := l_flight_schedule_rec.ATTRIBUTE15;
415:
416: -- Find if record can be updated and deleted.
417: x_flight_schedules_tbl(i).is_delete_allowed := AHL_UA_FLIGHT_SCHEDULES_PVT.is_delete_allowed(
418: p_unit_schedule_id => x_flight_schedules_tbl(i).unit_schedule_id,
419: p_is_super_user => l_super_user
420: );
421: x_flight_schedules_tbl(i).is_update_allowed := AHL_UA_FLIGHT_SCHEDULES_PVT.is_update_allowed(

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

417: x_flight_schedules_tbl(i).is_delete_allowed := AHL_UA_FLIGHT_SCHEDULES_PVT.is_delete_allowed(
418: p_unit_schedule_id => x_flight_schedules_tbl(i).unit_schedule_id,
419: p_is_super_user => l_super_user
420: );
421: x_flight_schedules_tbl(i).is_update_allowed := AHL_UA_FLIGHT_SCHEDULES_PVT.is_update_allowed(
422: p_unit_schedule_id => x_flight_schedules_tbl(i).unit_schedule_id,
423: p_is_super_user => l_super_user
424: );
425: END LOOP;

Line 460: -- Public wrapper for AHL_UA_FLIGHT_SCHEDULES_PVT.process_flight_schedules

456:
457:
458:
459: --------------------------------------------------------------------------------
460: -- Public wrapper for AHL_UA_FLIGHT_SCHEDULES_PVT.process_flight_schedules
461: ------------------------------------------------------------------------------------------
462:
463: PROCEDURE Process_Flight_Schedules
464: (

Line 477: p_x_flight_schedules_tbl IN OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE

473: x_return_status OUT NOCOPY VARCHAR2,
474: x_msg_count OUT NOCOPY NUMBER,
475: x_msg_data OUT NOCOPY VARCHAR2,
476: -- procedure params
477: p_x_flight_schedules_tbl IN OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
478: )
479: IS
480: l_api_name CONSTANT VARCHAR2(30) := 'Process_Flight_Schedules';
481: l_api_version CONSTANT NUMBER := 1.0;

Line 678: AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules(

674: 'Before calling the private API.....'
675: );
676: END IF;
677:
678: AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules(
679: p_api_version => p_api_version,
680: p_init_msg_list => p_init_msg_list,
681: p_commit => p_commit,
682: p_validation_level => p_validation_level,

Line 804: l_x_flight_schedules_tbl AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE;

800: x_msg_data OUT NOCOPY VARCHAR2
801: )
802: IS
803: i NUMBER;
804: l_x_flight_schedules_tbl AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE;
805: l_api_name CONSTANT VARCHAR2(30) := 'handle_flight_schedules';
806: BEGIN
807:
808: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 871: 'Calling AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules..'

867: fnd_log.string
868: (
869: fnd_log.level_statement,
870: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
871: 'Calling AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules..'
872: );
873: END IF;
874:
875: AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules(

Line 875: AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules(

871: 'Calling AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules..'
872: );
873: END IF;
874:
875: AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules(
876: p_api_version => 1.0,
877: p_init_msg_list => FND_API.G_FALSE,
878: p_commit => FND_API.G_FALSE,
879: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

889: fnd_log.string
890: (
891: fnd_log.level_statement,
892: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
893: 'After calling AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules....'
894: );
895: END IF;
896:
897: -- Check Error Message stack.

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

900: fnd_log.string
901: (
902: fnd_log.level_error,
903: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
904: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
905: );
906: END IF;
907: RAISE FND_API.G_EXC_ERROR;
908: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

910: fnd_log.string
911: (
912: fnd_log.level_error,
913: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
914: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'
915: );
916: END IF;
917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
918: END IF;

Line 996: l_x_succ_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;

992: IS
993: l_x_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
994: l_x_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
995: l_is_conflict VARCHAR2(1);
996: l_x_succ_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;
997: i NUMBER;
998: j NUMBER;
999: l_api_name CONSTANT VARCHAR2(30) := 'auto_create_transit_visit';
1000: l_api_version CONSTANT NUMBER := 1.0;

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

1060: fnd_log.string
1061: (
1062: fnd_log.level_error,
1063: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1064: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
1065: );
1066: END IF;
1067: RAISE FND_API.G_EXC_ERROR;
1068: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

1070: fnd_log.string
1071: (
1072: fnd_log.level_error,
1073: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1074: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'
1075: );
1076: END IF;
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END IF;

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

1097: fnd_log.string
1098: (
1099: fnd_log.level_error,
1100: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1101: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
1102: );
1103: END IF;
1104: RAISE FND_API.G_EXC_ERROR;
1105: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

1107: fnd_log.string
1108: (
1109: fnd_log.level_error,
1110: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1111: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'
1112: );
1113: END IF;
1114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1115: END IF;