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

Line 168: FROM AHL_UNIT_SCHEDULES

164: -- Cursor to get all the flight schedule records whose status is 'Created'
165: Cursor get_flight_schedule_rows(c_status IN VARCHAR2)
166: IS
167: SELECT *
168: FROM AHL_UNIT_SCHEDULES
169: WHERE AUTOVISIT_PROCESS_STATUS = c_status;
170:
171: --Get the count of rows matching with the UC and org of the flight schedule and enabled_flag as Y
172: Cursor get_non_null_org_count (c_uc_id IN NUMBER, c_org_id IN NUMBER)

Line 211: FROM AHL_UNIT_SCHEDULES prev_fs, AHL_UNIT_SCHEDULES succ_fs

207: -- Get the ground time (in number of hours) between two flight schedules
208: Cursor get_ground_time (c_prev_fs_id IN NUMBER, c_succ_fs_id IN NUMBER)
209: IS
210: SELECT to_number((succ_fs.EST_DEPARTURE_TIME - prev_fs.EST_ARRIVAL_TIME)*24*60)
211: FROM AHL_UNIT_SCHEDULES prev_fs, AHL_UNIT_SCHEDULES succ_fs
212: WHERE prev_fs.UNIT_SCHEDULE_ID = c_prev_fs_id
213: AND succ_fs.UNIT_SCHEDULE_ID = c_succ_fs_id;
214: l_ground_time NUMBER;
215:

Line 245: SELECT UNIT_SCHEDULE_ID, EST_DEPARTURE_TIME FROM AHL_UNIT_SCHEDULES

241:
242: --curosr that checks if there is any succeeding flight for this flight schedule
243: Cursor get_succeeding_us_det (c_fs_id IN NUMBER)
244: IS
245: SELECT UNIT_SCHEDULE_ID, EST_DEPARTURE_TIME FROM AHL_UNIT_SCHEDULES
246: WHERE preceding_us_id = c_fs_id;
247: l_succeeding_us_id NUMBER;
248: l_succ_dep_time DATE;
249:

Line 262: FROM AHL_UNIT_SCHEDULES

258: -- Cursor to get preceeding flight schedule details
259: Cursor get_pre_fs_det(c_unit_schedule_id IN NUMBER)
260: IS
261: SELECT *
262: FROM AHL_UNIT_SCHEDULES
263: WHERE UNIT_SCHEDULE_ID = c_unit_schedule_id;
264: pre_fs_det_rec get_pre_fs_det%ROWTYPE;
265:
266: --Cursor to find if the visit is in planning status and not firmed and not locked

Line 1198: UPDATE AHL_UNIT_SCHEDULES

1194: END IF;-- IF (l_can_cancel_visit IS NOT NULL) AND (l_can_cancel_visit2 IS NOT NULL) THEN
1195: END IF; -- if there is any succeeding event
1196:
1197: --Update the Flight Schedule auto create status to 'R'
1198: UPDATE AHL_UNIT_SCHEDULES
1199: set AUTOVISIT_PROCESS_STATUS = 'R',
1200: OBJECT_VERSION_NUMBER = object_version_number + 1,
1201: LAST_UPDATE_DATE = SYSDATE,
1202: LAST_UPDATED_BY = Fnd_Global.USER_ID,

Line 1279: FROM ahl_visits_b visit, ahl_unit_schedules flight

1275: -- To find out if there is any visit associated to the passed flight schedule
1276: -- Cursor to find our departure visit
1277: CURSOR c_is_visit_departure (c_fs_id IN NUMBER) IS
1278: SELECT visit.visit_type_code, visit.visit_id
1279: FROM ahl_visits_b visit, ahl_unit_schedules flight
1280: WHERE visit.unit_schedule_id = flight.unit_schedule_id
1281: AND visit.organization_id = flight.departure_org_id
1282: AND flight.unit_schedule_id = p_fs_id
1283: AND visit.status_code NOT IN ('DELETED','CANCELLED')

Line 1291: FROM ahl_visits_b visit, ahl_unit_schedules flight

1287: -- To find out if there is any visit associated to the passed flight schedule
1288: -- Cursor to find downtime visit at departure org
1289: CURSOR c_is_visit_downtime (c_fs_id IN NUMBER) IS
1290: SELECT visit.visit_type_code, visit.visit_id
1291: FROM ahl_visits_b visit, ahl_unit_schedules flight
1292: WHERE visit.unit_schedule_id = flight.preceding_us_id
1293: AND flight.unit_schedule_id = c_fs_id
1294: AND visit.organization_id = flight.departure_org_id
1295: AND visit.status_code NOT IN ('DELETED','CANCELLED')

Line 1304: FROM ahl_visits_b visit, ahl_unit_schedules flight

1300: -- To find out if there is any visit associated to the passed flight schedule
1301: -- Cursor to find visit at arrival org
1302: CURSOR c_is_visit_arrival_or_dwntm (c_fs_id IN NUMBER) IS
1303: SELECT visit.visit_type_code, visit.visit_id,visit.AUTO_VISIT_TYPE_FLAG
1304: FROM ahl_visits_b visit, ahl_unit_schedules flight
1305: WHERE visit.unit_schedule_id = flight.unit_schedule_id
1306: and visit.organization_id = flight.arrival_org_id
1307: and flight.unit_schedule_id = p_fs_id
1308: AND visit.status_code NOT IN ('DELETED','CANCELLED')

Line 1315: FROM ahl_visits_b visit, ahl_unit_schedules flight, ahl_unit_schedules succ_flight

1311:
1312: -- Cursor to find visit at arrival org if AUTO_VISIT_TYPE_FLAG for the visit is null
1313: CURSOR c_is_visit_arr_or_dwntm_old (c_fs_id IN NUMBER) IS
1314: SELECT succ_flight.est_departure_time, visit.close_date_time, visit.visit_type_code, visit.visit_id
1315: FROM ahl_visits_b visit, ahl_unit_schedules flight, ahl_unit_schedules succ_flight
1316: WHERE visit.unit_schedule_id = flight.unit_schedule_id
1317: and visit.organization_id = flight.arrival_org_id
1318: and succ_flight.preceding_us_id(+) = flight.unit_schedule_id
1319: and flight.unit_schedule_id = p_fs_id

Line 1327: FROM ahl_visits_b visit, ahl_unit_schedules flight, ahl_unit_schedules pre_flight

1323: -- Cursor to find if there is any arrival visit associated to the preceeding flight
1324: Cursor c_get_arr_vst_of_prec_flt (c_fs_id IN NUMBER)
1325: IS
1326: SELECT visit.visit_id
1327: FROM ahl_visits_b visit, ahl_unit_schedules flight, ahl_unit_schedules pre_flight
1328: WHERE visit.unit_schedule_id = pre_flight.unit_schedule_id
1329: AND flight.unit_schedule_id = c_fs_id
1330: AND flight.preceding_us_id = pre_flight.unit_schedule_id
1331: AND visit.organization_id = flight.departure_org_id

Line 1341: FROM ahl_visits_b visit, ahl_unit_schedules flight, ahl_unit_schedules succ_flight

1337: -- Cursor to find if there is any departure visit associated to the succeeding flight
1338: Cursor c_get_dep_vst_of_succ_flt (c_fs_id IN NUMBER)
1339: IS
1340: SELECT visit.visit_id
1341: FROM ahl_visits_b visit, ahl_unit_schedules flight, ahl_unit_schedules succ_flight
1342: WHERE visit.unit_schedule_id = succ_flight.unit_schedule_id
1343: and visit.organization_id = flight.arrival_org_id
1344: and succ_flight.preceding_us_id = flight.unit_schedule_id
1345: and flight.unit_schedule_id = p_fs_id

Line 1522: FROM AHL_UNIT_SCHEDULES

1518: -- Cursor to get all the flight schedule records whose status is 'Updated'
1519: Cursor get_flight_schedule_rows(c_status IN VARCHAR2)
1520: IS
1521: SELECT *
1522: FROM AHL_UNIT_SCHEDULES
1523: WHERE AUTOVISIT_PROCESS_STATUS = c_status;
1524:
1525: --Get the count of rows matching with the UC and org of the flight schedule and enabled_flag as Y
1526: Cursor get_non_null_org_count (c_uc_id IN NUMBER, c_org_id IN NUMBER)

Line 1565: FROM AHL_UNIT_SCHEDULES prev_fs, AHL_UNIT_SCHEDULES succ_fs

1561: -- Get the ground time (in number of hours) between two flight schedules
1562: Cursor get_ground_time (c_prev_fs_id IN NUMBER, c_succ_fs_id IN NUMBER)
1563: IS
1564: SELECT to_number((succ_fs.EST_DEPARTURE_TIME - prev_fs.EST_ARRIVAL_TIME)*24*60)
1565: FROM AHL_UNIT_SCHEDULES prev_fs, AHL_UNIT_SCHEDULES succ_fs
1566: WHERE prev_fs.UNIT_SCHEDULE_ID = c_prev_fs_id
1567: AND succ_fs.UNIT_SCHEDULE_ID = c_succ_fs_id;
1568: l_ground_time NUMBER;
1569:

Line 1599: SELECT UNIT_SCHEDULE_ID, EST_DEPARTURE_TIME FROM AHL_UNIT_SCHEDULES

1595:
1596: --curosr that checks if there is any succeeding flight for this flight schedule
1597: Cursor get_succeeding_us_det (c_fs_id IN NUMBER)
1598: IS
1599: SELECT UNIT_SCHEDULE_ID, EST_DEPARTURE_TIME FROM AHL_UNIT_SCHEDULES
1600: WHERE preceding_us_id = c_fs_id;
1601: l_succeeding_us_id NUMBER;
1602: l_succ_dep_time DATE;
1603:

Line 1615: FROM AHL_UNIT_SCHEDULES

1611:
1612: Cursor get_fs_arr_time (c_fs_id IN NUMBER)
1613: IS
1614: SELECT EST_ARRIVAL_TIME
1615: FROM AHL_UNIT_SCHEDULES
1616: WHERE UNIT_SCHEDULE_ID = c_fs_id;
1617:
1618: -- Cursor to get all the associated visits for the passed flight schedule
1619: Cursor get_assoc_visits(c_flight_schedule_id IN NUMBER)

Line 1638: FROM AHL_UNIT_SCHEDULES

1634: -- Cursor to get preceeding flight schedule details
1635: Cursor get_pre_fs_det(c_unit_schedule_id IN NUMBER)
1636: IS
1637: SELECT *
1638: FROM AHL_UNIT_SCHEDULES
1639: WHERE UNIT_SCHEDULE_ID = c_unit_schedule_id;
1640: pre_fs_det_rec get_pre_fs_det%ROWTYPE;
1641:
1642: -- Cursor to get visit type of a visit

Line 4043: UPDATE AHL_UNIT_SCHEDULES

4039: END IF; -- IF (l_can_cancel_visit IS NOT NULL) AND (l_can_cancel_visit2 IS NOT NULL) THEN
4040: END IF; --IF ( l_succeeding_us_id IS NULL )
4041:
4042: --Update the Flight Schedule auto create status to 'R'
4043: UPDATE AHL_UNIT_SCHEDULES
4044: set AUTOVISIT_PROCESS_STATUS = 'R',
4045: OBJECT_VERSION_NUMBER = object_version_number + 1,
4046: LAST_UPDATE_DATE = SYSDATE,
4047: LAST_UPDATED_BY = Fnd_Global.USER_ID,

Line 4158: FROM ahl_unit_schedules

4154: --Added cursor to get flight details for loggin :: PRAKKUM :: 01/08/2012
4155: Cursor get_flight_details (c_us_id IN NUMBER)
4156: IS
4157: SELECT flight_number
4158: FROM ahl_unit_schedules
4159: WHERE unit_schedule_id = c_us_id;
4160: flt_dets_rec get_flight_details%RowType;
4161:
4162: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Departure_visit';

Line 4418: FROM ahl_unit_schedules

4414: --Added cursor to get flight details for loggin :: PRAKKUM :: 01/08/2012
4415: Cursor get_flight_details (c_us_id IN NUMBER)
4416: IS
4417: SELECT flight_number
4418: FROM ahl_unit_schedules
4419: WHERE unit_schedule_id = c_us_id;
4420: flt_dets_rec get_flight_details%RowType;
4421:
4422: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Arrival_visit';

Line 4654: SELECT UNIT_SCHEDULE_ID, EST_DEPARTURE_TIME FROM AHL_UNIT_SCHEDULES

4650:
4651: --cursor that checks if there is any succeeding flight for this flight schedule
4652: Cursor get_succeeding_us_det (c_fs_id IN NUMBER)
4653: IS
4654: SELECT UNIT_SCHEDULE_ID, EST_DEPARTURE_TIME FROM AHL_UNIT_SCHEDULES
4655: WHERE preceding_us_id = c_fs_id;
4656:
4657: Cursor is_org_in_current_OU (c_org_id IN NUMBER)
4658: IS

Line 4683: FROM ahl_unit_schedules

4679: --Added cursor to get flight details for loggin :: PRAKKUM :: 01/08/2012
4680: Cursor get_flight_details (c_us_id IN NUMBER)
4681: IS
4682: SELECT flight_number
4683: FROM ahl_unit_schedules
4684: WHERE unit_schedule_id = c_us_id;
4685: flt_dets_rec get_flight_details%RowType;
4686:
4687: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Downtime_visit';