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.

[Home] [Help]

APPS.AHL_UA_FLIGHT_SCHEDULES_PVT dependencies on AHL_UNIT_SCHEDULES

Line 113: FROM AHL_UNIT_SCHEDULES

109: -- Cursor for checking for the validity of the flight schedule
110: CURSOR get_cur_us_csr(p_unit_schedule_id IN NUMBER, p_object_version_number IN NUMBER)
111: IS
112: SELECT 'X'
113: FROM AHL_UNIT_SCHEDULES
114: WHERE unit_schedule_id = p_unit_schedule_id
115: AND object_version_number = p_object_version_number;
116:
117: -- Define all local variables here.

Line 651: FROM AHL_UNIT_SCHEDULES

647:
648: -- Cursor for getting a Unit Schedule record.
649: CURSOR get_current_us_csr(p_unit_shcedule_id IN NUMBER) IS
650: SELECT *
651: FROM AHL_UNIT_SCHEDULES
652: WHERE unit_schedule_id = p_unit_shcedule_id;
653:
654: l_current_us_rec get_current_us_csr%ROWTYPE;
655:

Line 1077: FROM AHL_UNIT_SCHEDULES

1073: IS
1074: -- Cursor for getting a Unit Schedule record.
1075: CURSOR get_current_us_csr(p_unit_shcedule_id IN NUMBER) IS
1076: SELECT *
1077: FROM AHL_UNIT_SCHEDULES
1078: WHERE unit_schedule_id = p_unit_shcedule_id;
1079:
1080: -- Define all local variables here.
1081: l_api_name CONSTANT VARCHAR2(30) := 'validate_update';

Line 1340: FROM AHL_UNIT_SCHEDULES_V

1336:
1337: --Cursor for getting the preceeding event of an Unit Schedule.
1338: CURSOR get_preceeding_us_csr(p_unit_schedule_id IN NUMBER) IS
1339: /*SELECT unit_schedule_id, actual_departure_time, actual_arrival_time
1340: FROM AHL_UNIT_SCHEDULES_V
1341: WHERE unit_schedule_id = (
1342: SELECT preceding_us_id
1343: FROM AHL_UNIT_SCHEDULES_V
1344: WHERE unit_schedule_id = p_unit_schedule_id

Line 1343: FROM AHL_UNIT_SCHEDULES_V

1339: /*SELECT unit_schedule_id, actual_departure_time, actual_arrival_time
1340: FROM AHL_UNIT_SCHEDULES_V
1341: WHERE unit_schedule_id = (
1342: SELECT preceding_us_id
1343: FROM AHL_UNIT_SCHEDULES_V
1344: WHERE unit_schedule_id = p_unit_schedule_id
1345: );*/
1346: --Priyan changed the query due to performance issues
1347: --Refer Bug # 4916339

Line 1353: AHL_UNIT_SCHEDULES

1349: UNIT_SCHEDULE_ID,
1350: ACTUAL_DEPARTURE_TIME,
1351: ACTUAL_ARRIVAL_TIME
1352: FROM
1353: AHL_UNIT_SCHEDULES
1354: WHERE
1355: UNIT_SCHEDULE_ID = (
1356: SELECT PRECEDING_US_ID
1357: FROM AHL_UNIT_SCHEDULES

Line 1357: FROM AHL_UNIT_SCHEDULES

1353: AHL_UNIT_SCHEDULES
1354: WHERE
1355: UNIT_SCHEDULE_ID = (
1356: SELECT PRECEDING_US_ID
1357: FROM AHL_UNIT_SCHEDULES
1358: WHERE UNIT_SCHEDULE_ID = p_unit_schedule_id
1359: );
1360:
1361: l_preceeding_us_rec get_preceeding_us_csr%ROWTYPE;

Line 1366: FROM AHL_UNIT_SCHEDULES

1362:
1363: --Cursor for getting the preceeding event of an Unit Schedule in create mode.
1364: CURSOR get_pre_us_uc_csr(p_uc_header_id IN NUMBER, p_est_arrival_date IN DATE) IS
1365: SELECT unit_schedule_id, actual_departure_time, actual_arrival_time
1366: FROM AHL_UNIT_SCHEDULES
1367: WHERE unit_config_header_id = p_uc_header_id AND
1368: Est_arrival_time < p_est_arrival_date;
1369:
1370: CURSOR get_curr_act_dates_csr(p_unit_schedule_id IN NUMBER) IS

Line 1372: FROM AHL_UNIT_SCHEDULES

1368: Est_arrival_time < p_est_arrival_date;
1369:
1370: CURSOR get_curr_act_dates_csr(p_unit_schedule_id IN NUMBER) IS
1371: SELECT actual_departure_time, actual_arrival_time
1372: FROM AHL_UNIT_SCHEDULES
1373: WHERE unit_schedule_id = p_unit_schedule_id;
1374: l_curr_act_dates_rec get_curr_act_dates_csr%ROWTYPE;
1375:
1376: -- Cursor for finding overlaps in flight schedules.If this is used then above cursor is not required

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

1373: WHERE unit_schedule_id = p_unit_schedule_id;
1374: l_curr_act_dates_rec get_curr_act_dates_csr%ROWTYPE;
1375:
1376: -- Cursor for finding overlaps in flight schedules.If this is used then above cursor is not required
1377: -- Using AHL_UNIT_SCHEDULES_V instead of AHL_UNIT_SCHEDULES because of restriction in access.
1378: CURSOR get_cur_us_det_csr(p_unit_schedule_id IN NUMBER)
1379: IS
1380: SELECT unit_config_header_id,
1381: EST_DEPARTURE_TIME,

Line 1385: FROM AHL_UNIT_SCHEDULES

1381: EST_DEPARTURE_TIME,
1382: EST_ARRIVAL_TIME,
1383: ACTUAL_DEPARTURE_TIME,
1384: ACTUAL_ARRIVAL_TIME
1385: FROM AHL_UNIT_SCHEDULES
1386: WHERE unit_schedule_id = p_unit_schedule_id;
1387:
1388: /* MANESING::Auto Visit Forecasting Project, 17-Oct-2011, added following cursor
1389: * Cursor for validating whether space id belongs to the given department

Line 1464: FROM AHL_UNIT_SCHEDULES

1460:
1461: ELSE
1462: --Check for duplicate records.
1463: SELECT count(unit_schedule_id) INTO l_us_dup_count
1464: FROM AHL_UNIT_SCHEDULES
1465: WHERE UNIT_CONFIG_HEADER_ID = p_x_flight_schedule_rec.UNIT_CONFIG_HEADER_ID
1466: AND FLIGHT_NUMBER = p_x_flight_schedule_rec.FLIGHT_NUMBER
1467: AND SEGMENT = p_x_flight_schedule_rec.SEGMENT
1468: AND EST_ARRIVAL_TIME = p_x_flight_schedule_rec.EST_ARRIVAL_TIME

Line 1646: FROM AHL_UNIT_SCHEDULES

1642:
1643: -- code to verify if estimated times are updated to a value less than
1644: -- some other flight's estimated arrival time of the same unit whose Actuals are already entered.
1645: SELECT count(unit_schedule_id) into l_est_violation_count
1646: FROM AHL_UNIT_SCHEDULES
1647: WHERE est_arrival_time > p_x_flight_schedule_rec.EST_ARRIVAL_TIME AND
1648: unit_config_header_id = p_x_flight_schedule_rec.unit_config_header_id
1649: AND (
1650: actual_departure_time is not null OR actual_arrival_time is not null

Line 1757: FROM AHL_UNIT_SCHEDULES

1753: SELECT unit_schedule_id,
1754: est_departure_time,
1755: est_arrival_time,
1756: preceding_us_id
1757: FROM AHL_UNIT_SCHEDULES
1758: WHERE unit_schedule_id = c_unit_schedule_id;
1759:
1760: -- Cursor to get visit details for the given flight schedule
1761: CURSOR get_visit_for_flight_sch_csr (c_unit_schedule_id NUMBER) IS

Line 1779: FROM AHL_UNIT_SCHEDULES

1775: CURSOR get_succ_flight_sch_csr (c_unit_schedule_id NUMBER) IS
1776: SELECT unit_schedule_id,
1777: est_departure_time,
1778: est_arrival_time
1779: FROM AHL_UNIT_SCHEDULES
1780: WHERE preceding_us_id = c_unit_schedule_id;
1781:
1782: -- Cursor to check if the given visit contains any planned MRs
1783: CURSOR chk_planned_mrs_csr (c_visit_id NUMBER) IS

Line 1937: FROM AHL_UNIT_SCHEDULES

1933: --Cursor for finding previous unit schedule id.
1934: CURSOR get_pre_us_id_act(p_unit_config_header_id IN NUMBER)
1935: IS
1936: SELECT unit_schedule_id, nvl(actual_arrival_time, est_arrival_time) "ARRIVAL_TIME"
1937: FROM AHL_UNIT_SCHEDULES
1938: WHERE unit_config_header_id = p_unit_config_header_id
1939: ORDER BY nvl(actual_arrival_time, est_arrival_time) DESC;
1940:
1941: --Cursor for finding previous unit schedule id.

Line 1945: FROM AHL_UNIT_SCHEDULES

1941: --Cursor for finding previous unit schedule id.
1942: CURSOR get_pre_us_id_est(p_unit_config_header_id IN NUMBER)
1943: IS
1944: SELECT unit_schedule_id, est_arrival_time "ARRIVAL_TIME"
1945: FROM AHL_UNIT_SCHEDULES
1946: WHERE unit_config_header_id = p_unit_config_header_id
1947: ORDER BY est_arrival_time DESC;
1948:
1949: -- Define all local variables here.

Line 2015: UPDATE AHL_UNIT_SCHEDULES

2011:
2012: --Update the table.
2013: FOR j IN 1..l_pre_us_tbl.COUNT
2014: LOOP
2015: UPDATE AHL_UNIT_SCHEDULES
2016: SET preceding_us_id = l_pre_us_tbl(j).preceding_us_id
2017: WHERE unit_schedule_id = l_pre_us_tbl(j).unit_schedule_id;
2018: END LOOP;
2019:

Line 2403: INSERT INTO AHL_UNIT_SCHEDULES

2399: );
2400: END IF;
2401:
2402: -- Insert the record
2403: INSERT INTO AHL_UNIT_SCHEDULES
2404: (
2405: UNIT_SCHEDULE_ID,
2406: FLIGHT_NUMBER,
2407: SEGMENT,

Line 2449: AHL_UNIT_SCHEDULES_S.NEXTVAL,

2445: ATTRIBUTE14,
2446: ATTRIBUTE15
2447: ) VALUES
2448: (
2449: AHL_UNIT_SCHEDULES_S.NEXTVAL,
2450: p_x_flight_schedules_tbl(i).FLIGHT_NUMBER,
2451: p_x_flight_schedules_tbl(i).SEGMENT,
2452: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID,
2453: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_ID,

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

2488: p_x_flight_schedules_tbl(i).ATTRIBUTE13,
2489: p_x_flight_schedules_tbl(i).ATTRIBUTE14,
2490: p_x_flight_schedules_tbl(i).ATTRIBUTE15
2491: );
2492: SELECT AHL_UNIT_SCHEDULES_S.CURRVAL INTO p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID FROM DUAL ;
2493: END IF;
2494:
2495: -- Check if overlaps are occurring. If there is any overlap, show warning.
2496: l_overlap_us_count := 0;

Line 2500: FROM AHL_UNIT_SCHEDULES

2496: l_overlap_us_count := 0;
2497: 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
2498: THEN
2499: SELECT count(unit_schedule_id) INTO l_overlap_us_count
2500: FROM AHL_UNIT_SCHEDULES
2501: WHERE unit_config_header_id = p_x_flight_schedules_tbl(i).unit_config_header_id
2502: AND (
2503: (
2504: (p_x_flight_schedules_tbl(i).actual_departure_time between ACTUAL_DEPARTURE_TIME and ACTUAL_ARRIVAL_TIME)

Line 2515: FROM AHL_UNIT_SCHEDULES

2511: AND unit_schedule_id <> p_x_flight_schedules_tbl(i).unit_schedule_id;
2512: 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
2513: THEN
2514: SELECT count(unit_schedule_id) INTO l_overlap_us_count
2515: FROM AHL_UNIT_SCHEDULES
2516: WHERE unit_config_header_id = p_x_flight_schedules_tbl(i).unit_config_header_id
2517: /*AND (
2518: (
2519: (p_x_flight_schedules_tbl(i).est_departure_time between EST_DEPARTURE_TIME and EST_ARRIVAL_TIME)

Line 2584: FROM AHL_UNIT_SCHEDULES

2580: arrival_dept_id,
2581: est_departure_time,
2582: est_arrival_time,
2583: autovisit_process_status
2584: FROM AHL_UNIT_SCHEDULES
2585: WHERE unit_schedule_id = p_unit_schedule_id;
2586:
2587: l_old_flight_rec old_flight_rec_csr%ROWTYPE;
2588: l_visit_sync_rec visit_sync_rec_type;

Line 2864: UPDATE AHL_UNIT_SCHEDULES SET

2860: l_autovisit_process_status := l_old_flight_rec.autovisit_process_status;
2861: END IF;
2862:
2863: -- Update the record
2864: UPDATE AHL_UNIT_SCHEDULES SET
2865: UNIT_SCHEDULE_ID = p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID,
2866: FLIGHT_NUMBER = p_x_flight_schedules_tbl(i).FLIGHT_NUMBER,
2867: SEGMENT = p_x_flight_schedules_tbl(i).SEGMENT,
2868: DEPARTURE_DEPT_ID = p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID,

Line 3013: FROM AHL_UNIT_SCHEDULES

3009: l_overlap_us_count := 0;
3010: 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
3011: THEN
3012: SELECT count(unit_schedule_id) INTO l_overlap_us_count
3013: FROM AHL_UNIT_SCHEDULES
3014: WHERE unit_config_header_id = p_x_flight_schedules_tbl(i).unit_config_header_id
3015: AND (
3016: (
3017: (p_x_flight_schedules_tbl(i).actual_departure_time between ACTUAL_DEPARTURE_TIME and ACTUAL_ARRIVAL_TIME)

Line 3028: FROM AHL_UNIT_SCHEDULES

3024: AND unit_schedule_id <> p_x_flight_schedules_tbl(i).unit_schedule_id;
3025: 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
3026: THEN
3027: SELECT count(unit_schedule_id) INTO l_overlap_us_count
3028: FROM AHL_UNIT_SCHEDULES
3029: WHERE unit_config_header_id = p_x_flight_schedules_tbl(i).unit_config_header_id
3030: /*AND (
3031: (
3032: (p_x_flight_schedules_tbl(i).est_departure_time between EST_DEPARTURE_TIME and EST_ARRIVAL_TIME)

Line 3087: FROM ahl_unit_schedules

3083: -- Cursor for fetching synchronization rule for a given flight.
3084: CURSOR c_get_sync_rule(c_unit_sch_id IN NUMBER)
3085: IS
3086: SELECT visit_reschedule_mode
3087: FROM ahl_unit_schedules
3088: WHERE unit_schedule_id = c_unit_sch_id;
3089:
3090: l_sync_rule VARCHAR2(30);
3091: -- Bug # 9075539 -- end

Line 3292: DELETE FROM AHL_UNIT_SCHEDULES

3288:
3289: END IF;
3290: -- Bug # 9075539 -- end
3291:
3292: DELETE FROM AHL_UNIT_SCHEDULES
3293: WHERE unit_schedule_id = p_x_flight_schedules_tbl(i).unit_schedule_id
3294: AND object_version_number= p_x_flight_schedules_tbl(i).object_version_number;
3295:
3296: -- If the record does not exist, then, abort API.

Line 3496: FROM AHL_UNIT_SCHEDULES

3492: p_unit_config_id number
3493: )
3494: IS
3495: SELECT 'X'
3496: FROM AHL_UNIT_SCHEDULES
3497: WHERE unit_schedule_id = p_unit_schedule_id
3498: AND unit_config_header_id = nvl(p_unit_config_id, unit_config_header_id);
3499:
3500: BEGIN

Line 3640: FROM AHL_UNIT_SCHEDULES

3636: --Cursor for checking if actuals are entered for the current unit schedule record.
3637: CURSOR get_curr_actuals_csr(p_unit_schedule_id IN NUMBER)
3638: IS
3639: SELECT actual_departure_time, actual_arrival_time
3640: FROM AHL_UNIT_SCHEDULES
3641: WHERE unit_schedule_id = p_unit_schedule_id;
3642: l_curr_acutals_rec get_curr_actuals_csr%ROWTYPE;
3643:
3644: --l_is_super_user VARCHAR2(1);

Line 3704: FROM AHL_UNIT_SCHEDULES

3700:
3701: --Cursor for getting the succeeding event of an Unit Schedule.
3702: CURSOR get_succeeding_us_csr(p_unit_schedule_id IN NUMBER) IS
3703: SELECT actual_departure_time, actual_arrival_time
3704: FROM AHL_UNIT_SCHEDULES
3705: WHERE preceding_us_id = p_unit_schedule_id;
3706:
3707: l_api_name CONSTANT VARCHAR2(30) := 'is_update_allowed';
3708: l_succeeding_us_rec get_succeeding_us_csr%ROWTYPE;