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_PVT dependencies on AHL_UNIT_SCHEDULES

Line 97: FROM AHL_UNIT_SCHEDULES

93: -- Cursor for checking for the validity of the flight schedule
94: CURSOR get_cur_us_csr(p_unit_schedule_id IN NUMBER, p_object_version_number IN NUMBER)
95: IS
96: SELECT 'X'
97: FROM AHL_UNIT_SCHEDULES
98: WHERE unit_schedule_id = p_unit_schedule_id
99: AND object_version_number = p_object_version_number;
100:
101: -- Define all local variables here.

Line 523: FROM AHL_UNIT_SCHEDULES

519:
520: -- Cursor for getting a Unit Schedule record.
521: CURSOR get_current_us_csr(p_unit_shcedule_id IN NUMBER) IS
522: SELECT *
523: FROM AHL_UNIT_SCHEDULES
524: WHERE unit_schedule_id = p_unit_shcedule_id;
525:
526: l_current_us_rec get_current_us_csr%ROWTYPE;
527:

Line 927: FROM AHL_UNIT_SCHEDULES

923: IS
924: -- Cursor for getting a Unit Schedule record.
925: CURSOR get_current_us_csr(p_unit_shcedule_id IN NUMBER) IS
926: SELECT *
927: FROM AHL_UNIT_SCHEDULES
928: WHERE unit_schedule_id = p_unit_shcedule_id;
929:
930: -- Define all local variables here.
931: l_api_name CONSTANT VARCHAR2(30) := 'validate_update';

Line 1190: FROM AHL_UNIT_SCHEDULES_V

1186:
1187: --Cursor for getting the preceeding event of an Unit Schedule.
1188: CURSOR get_preceeding_us_csr(p_unit_schedule_id IN NUMBER) IS
1189: /*SELECT unit_schedule_id, actual_departure_time, actual_arrival_time
1190: FROM AHL_UNIT_SCHEDULES_V
1191: WHERE unit_schedule_id = (
1192: SELECT preceding_us_id
1193: FROM AHL_UNIT_SCHEDULES_V
1194: WHERE unit_schedule_id = p_unit_schedule_id

Line 1193: FROM AHL_UNIT_SCHEDULES_V

1189: /*SELECT unit_schedule_id, actual_departure_time, actual_arrival_time
1190: FROM AHL_UNIT_SCHEDULES_V
1191: WHERE unit_schedule_id = (
1192: SELECT preceding_us_id
1193: FROM AHL_UNIT_SCHEDULES_V
1194: WHERE unit_schedule_id = p_unit_schedule_id
1195: );*/
1196: --Priyan changed the query due to performance issues
1197: --Refer Bug # 4916339

Line 1203: AHL_UNIT_SCHEDULES

1199: UNIT_SCHEDULE_ID,
1200: ACTUAL_DEPARTURE_TIME,
1201: ACTUAL_ARRIVAL_TIME
1202: FROM
1203: AHL_UNIT_SCHEDULES
1204: WHERE
1205: UNIT_SCHEDULE_ID = (
1206: SELECT PRECEDING_US_ID
1207: FROM AHL_UNIT_SCHEDULES

Line 1207: FROM AHL_UNIT_SCHEDULES

1203: AHL_UNIT_SCHEDULES
1204: WHERE
1205: UNIT_SCHEDULE_ID = (
1206: SELECT PRECEDING_US_ID
1207: FROM AHL_UNIT_SCHEDULES
1208: WHERE UNIT_SCHEDULE_ID = p_unit_schedule_id
1209: );
1210:
1211: l_preceeding_us_rec get_preceeding_us_csr%ROWTYPE;

Line 1216: FROM AHL_UNIT_SCHEDULES

1212:
1213: --Cursor for getting the preceeding event of an Unit Schedule in create mode.
1214: CURSOR get_pre_us_uc_csr(p_uc_header_id IN NUMBER, p_est_arrival_date IN DATE) IS
1215: SELECT unit_schedule_id, actual_departure_time, actual_arrival_time
1216: FROM AHL_UNIT_SCHEDULES
1217: WHERE unit_config_header_id = p_uc_header_id AND
1218: Est_arrival_time < p_est_arrival_date;
1219:
1220: CURSOR get_curr_act_dates_csr(p_unit_schedule_id IN NUMBER) IS

Line 1222: FROM AHL_UNIT_SCHEDULES

1218: Est_arrival_time < p_est_arrival_date;
1219:
1220: CURSOR get_curr_act_dates_csr(p_unit_schedule_id IN NUMBER) IS
1221: SELECT actual_departure_time, actual_arrival_time
1222: FROM AHL_UNIT_SCHEDULES
1223: WHERE unit_schedule_id = p_unit_schedule_id;
1224: l_curr_act_dates_rec get_curr_act_dates_csr%ROWTYPE;
1225:
1226: -- Cursor for finding overlaps in flight schedules.If this is used then above cursor is not required

Line 1227: -- Using AHL_UNIT_SCHEDULES_V instead of AHL_UNIT_SCHEDULES because of restriction in access.

1223: WHERE unit_schedule_id = p_unit_schedule_id;
1224: l_curr_act_dates_rec get_curr_act_dates_csr%ROWTYPE;
1225:
1226: -- Cursor for finding overlaps in flight schedules.If this is used then above cursor is not required
1227: -- Using AHL_UNIT_SCHEDULES_V instead of AHL_UNIT_SCHEDULES because of restriction in access.
1228: CURSOR get_cur_us_det_csr(p_unit_schedule_id IN NUMBER)
1229: IS
1230: SELECT unit_config_header_id,
1231: EST_DEPARTURE_TIME,

Line 1235: FROM AHL_UNIT_SCHEDULES

1231: EST_DEPARTURE_TIME,
1232: EST_ARRIVAL_TIME,
1233: ACTUAL_DEPARTURE_TIME,
1234: ACTUAL_ARRIVAL_TIME
1235: FROM AHL_UNIT_SCHEDULES
1236: WHERE unit_schedule_id = p_unit_schedule_id;
1237:
1238:
1239: -- Define all local variables here.

Line 1299: FROM AHL_UNIT_SCHEDULES

1295:
1296: ELSE
1297: --Check for duplicate records.
1298: SELECT count(unit_schedule_id) INTO l_us_dup_count
1299: FROM AHL_UNIT_SCHEDULES
1300: WHERE UNIT_CONFIG_HEADER_ID = p_x_flight_schedule_rec.UNIT_CONFIG_HEADER_ID
1301: AND FLIGHT_NUMBER = p_x_flight_schedule_rec.FLIGHT_NUMBER
1302: AND SEGMENT = p_x_flight_schedule_rec.SEGMENT
1303: AND EST_ARRIVAL_TIME = p_x_flight_schedule_rec.EST_ARRIVAL_TIME

Line 1481: FROM AHL_UNIT_SCHEDULES

1477:
1478: -- code to verify if estimated times are updated to a value less than
1479: -- some other flight's estimated arrival time of the same unit whose Actuals are already entered.
1480: SELECT count(unit_schedule_id) into l_est_violation_count
1481: FROM AHL_UNIT_SCHEDULES
1482: WHERE est_arrival_time > p_x_flight_schedule_rec.EST_ARRIVAL_TIME AND
1483: unit_config_header_id = p_x_flight_schedule_rec.unit_config_header_id
1484: AND (
1485: actual_departure_time is not null OR actual_arrival_time is not null

Line 1530: FROM AHL_UNIT_SCHEDULES

1526: --Cursor for finding previous unit schedule id.
1527: CURSOR get_pre_us_id_act(p_unit_config_header_id IN NUMBER)
1528: IS
1529: SELECT unit_schedule_id, nvl(actual_arrival_time, est_arrival_time) "ARRIVAL_TIME"
1530: FROM AHL_UNIT_SCHEDULES
1531: WHERE unit_config_header_id = p_unit_config_header_id
1532: ORDER BY nvl(actual_arrival_time, est_arrival_time) DESC;
1533:
1534: --Cursor for finding previous unit schedule id.

Line 1538: FROM AHL_UNIT_SCHEDULES

1534: --Cursor for finding previous unit schedule id.
1535: CURSOR get_pre_us_id_est(p_unit_config_header_id IN NUMBER)
1536: IS
1537: SELECT unit_schedule_id, est_arrival_time "ARRIVAL_TIME"
1538: FROM AHL_UNIT_SCHEDULES
1539: WHERE unit_config_header_id = p_unit_config_header_id
1540: ORDER BY est_arrival_time DESC;
1541:
1542: -- Define all local variables here.

Line 1608: UPDATE AHL_UNIT_SCHEDULES

1604:
1605: --Update the table.
1606: FOR j IN 1..l_pre_us_tbl.COUNT
1607: LOOP
1608: UPDATE AHL_UNIT_SCHEDULES
1609: SET preceding_us_id = l_pre_us_tbl(j).preceding_us_id
1610: WHERE unit_schedule_id = l_pre_us_tbl(j).unit_schedule_id;
1611: END LOOP;
1612:

Line 1966: INSERT INTO AHL_UNIT_SCHEDULES

1962: );
1963: END IF;
1964:
1965: -- Insert the record
1966: INSERT INTO AHL_UNIT_SCHEDULES
1967: (
1968: UNIT_SCHEDULE_ID,
1969: FLIGHT_NUMBER,
1970: SEGMENT,

Line 2006: AHL_UNIT_SCHEDULES_S.NEXTVAL,

2002: ATTRIBUTE14,
2003: ATTRIBUTE15
2004: ) VALUES
2005: (
2006: AHL_UNIT_SCHEDULES_S.NEXTVAL,
2007: p_x_flight_schedules_tbl(i).FLIGHT_NUMBER,
2008: p_x_flight_schedules_tbl(i).SEGMENT,
2009: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID,
2010: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_ID,

Line 2043: SELECT AHL_UNIT_SCHEDULES_S.CURRVAL INTO p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID FROM DUAL ;

2039: p_x_flight_schedules_tbl(i).ATTRIBUTE13,
2040: p_x_flight_schedules_tbl(i).ATTRIBUTE14,
2041: p_x_flight_schedules_tbl(i).ATTRIBUTE15
2042: );
2043: SELECT AHL_UNIT_SCHEDULES_S.CURRVAL INTO p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID FROM DUAL ;
2044: END IF;
2045:
2046: -- Check if overlaps are occurring. If there is any overlap, show warning.
2047: l_overlap_us_count := 0;

Line 2051: FROM AHL_UNIT_SCHEDULES

2047: l_overlap_us_count := 0;
2048: IF p_x_flight_schedules_tbl(i).actual_departure_time IS NOT NULL AND p_x_flight_schedules_tbl(i).actual_arrival_time IS NOT NULL
2049: THEN
2050: SELECT count(unit_schedule_id) INTO l_overlap_us_count
2051: FROM AHL_UNIT_SCHEDULES
2052: WHERE unit_config_header_id = p_x_flight_schedules_tbl(i).unit_config_header_id
2053: AND (
2054: (
2055: (p_x_flight_schedules_tbl(i).actual_departure_time between ACTUAL_DEPARTURE_TIME and ACTUAL_ARRIVAL_TIME)

Line 2066: FROM AHL_UNIT_SCHEDULES

2062: AND unit_schedule_id <> p_x_flight_schedules_tbl(i).unit_schedule_id;
2063: ELSIF p_x_flight_schedules_tbl(i).est_departure_time IS NOT NULL AND p_x_flight_schedules_tbl(i).est_arrival_time IS NOT NULL
2064: THEN
2065: SELECT count(unit_schedule_id) INTO l_overlap_us_count
2066: FROM AHL_UNIT_SCHEDULES
2067: WHERE unit_config_header_id = p_x_flight_schedules_tbl(i).unit_config_header_id
2068: /*AND (
2069: (
2070: (p_x_flight_schedules_tbl(i).est_departure_time between EST_DEPARTURE_TIME and EST_ARRIVAL_TIME)

Line 2128: FROM AHL_UNIT_SCHEDULES

2124: -- Cursor for getting old flight schedule details.
2125: CURSOR old_flight_rec_csr(p_unit_schedule_id IN NUMBER)
2126: IS
2127: SELECT est_arrival_time, arrival_org_id, arrival_dept_id
2128: FROM AHL_UNIT_SCHEDULES
2129: WHERE unit_schedule_id = p_unit_schedule_id;
2130:
2131: l_old_flight_rec old_flight_rec_csr%ROWTYPE;
2132: l_visit_sync_rec visit_sync_rec_type;

Line 2359: UPDATE AHL_UNIT_SCHEDULES SET

2355: OPEN old_flight_rec_csr(p_x_flight_schedules_tbl(i).unit_schedule_id);
2356: FETCH old_flight_rec_csr INTO l_old_flight_rec;
2357:
2358: -- Update the record
2359: UPDATE AHL_UNIT_SCHEDULES SET
2360: UNIT_SCHEDULE_ID = p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID,
2361: FLIGHT_NUMBER = p_x_flight_schedules_tbl(i).FLIGHT_NUMBER,
2362: SEGMENT = p_x_flight_schedules_tbl(i).SEGMENT,
2363: DEPARTURE_DEPT_ID = p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID,

Line 2502: FROM AHL_UNIT_SCHEDULES

2498: l_overlap_us_count := 0;
2499: IF p_x_flight_schedules_tbl(i).actual_departure_time IS NOT NULL AND p_x_flight_schedules_tbl(i).actual_arrival_time IS NOT NULL
2500: THEN
2501: SELECT count(unit_schedule_id) INTO l_overlap_us_count
2502: FROM AHL_UNIT_SCHEDULES
2503: WHERE unit_config_header_id = p_x_flight_schedules_tbl(i).unit_config_header_id
2504: AND (
2505: (
2506: (p_x_flight_schedules_tbl(i).actual_departure_time between ACTUAL_DEPARTURE_TIME and ACTUAL_ARRIVAL_TIME)

Line 2517: FROM AHL_UNIT_SCHEDULES

2513: AND unit_schedule_id <> p_x_flight_schedules_tbl(i).unit_schedule_id;
2514: ELSIF p_x_flight_schedules_tbl(i).est_departure_time IS NOT NULL AND p_x_flight_schedules_tbl(i).est_arrival_time IS NOT NULL
2515: THEN
2516: SELECT count(unit_schedule_id) INTO l_overlap_us_count
2517: FROM AHL_UNIT_SCHEDULES
2518: WHERE unit_config_header_id = p_x_flight_schedules_tbl(i).unit_config_header_id
2519: /*AND (
2520: (
2521: (p_x_flight_schedules_tbl(i).est_departure_time between EST_DEPARTURE_TIME and EST_ARRIVAL_TIME)

Line 2728: DELETE FROM AHL_UNIT_SCHEDULES

2724: );
2725: END IF;
2726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2727: END IF;
2728: DELETE FROM AHL_UNIT_SCHEDULES
2729: WHERE unit_schedule_id = p_x_flight_schedules_tbl(i).unit_schedule_id
2730: AND object_version_number= p_x_flight_schedules_tbl(i).object_version_number;
2731:
2732: -- If the record does not exist, then, abort API.

Line 2906: FROM AHL_UNIT_SCHEDULES

2902: p_unit_config_id number
2903: )
2904: IS
2905: SELECT 'X'
2906: FROM AHL_UNIT_SCHEDULES
2907: WHERE unit_schedule_id = p_unit_schedule_id
2908: AND unit_config_header_id = nvl(p_unit_config_id, unit_config_header_id);
2909:
2910: BEGIN

Line 3050: FROM AHL_UNIT_SCHEDULES

3046: --Cursor for checking if actuals are entered for the current unit schedule record.
3047: CURSOR get_curr_actuals_csr(p_unit_schedule_id IN NUMBER)
3048: IS
3049: SELECT actual_departure_time, actual_arrival_time
3050: FROM AHL_UNIT_SCHEDULES
3051: WHERE unit_schedule_id = p_unit_schedule_id;
3052: l_curr_acutals_rec get_curr_actuals_csr%ROWTYPE;
3053:
3054: --l_is_super_user VARCHAR2(1);

Line 3114: FROM AHL_UNIT_SCHEDULES

3110:
3111: --Cursor for getting the succeeding event of an Unit Schedule.
3112: CURSOR get_succeeding_us_csr(p_unit_schedule_id IN NUMBER) IS
3113: SELECT actual_departure_time, actual_arrival_time
3114: FROM AHL_UNIT_SCHEDULES
3115: WHERE preceding_us_id = p_unit_schedule_id;
3116:
3117: l_api_name CONSTANT VARCHAR2(30) := 'is_update_allowed';
3118: l_succeeding_us_rec get_succeeding_us_csr%ROWTYPE;