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

Line 161: FROM ahl_visits_b

157:
158: -- Cursor to get the visit Number from visit_id
159: CURSOR get_visit_number(c_visit_id IN NUMBER) IS
160: SELECT visit_number
161: FROM ahl_visits_b
162: WHERE visit_id = c_visit_id;
163:
164: -- Cursor to get all the flight schedule records whose status is 'Created'
165: Cursor get_flight_schedule_rows(c_status IN VARCHAR2)

Line 270: FROM AHL_VISITS_B

266: --Cursor to find if the visit is in planning status and not firmed and not locked
267: Cursor can_cancel_visit(c_visit_id IN NUMBER)
268: IS
269: SELECT 'X'
270: FROM AHL_VISITS_B
271: WHERE VISIT_ID = c_visit_id
272: AND STATUS_CODE = 'PLANNING'
273: AND NVL(FIRMED_FLAG,'N') <> 'Y'
274: AND NVL(LOCKED_FLAG,'N') <> 'Y';

Line 280: FROM AHL_VISITS_B

276: -- Cursor to get visit type of a visit
277: Cursor get_visit_type_code(c_visit_id IN NUMBER)
278: IS
279: SELECT visit_type_code
280: FROM AHL_VISITS_B
281: WHERE VISIT_ID = c_visit_id;
282:
283: BEGIN
284:

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 1515: FROM ahl_visits_b

1511:
1512: -- Cursor to find the visit numbers from visit_ids
1513: CURSOR get_visit_number(c_visit_id IN NUMBER) IS
1514: SELECT visit_number
1515: FROM ahl_visits_b
1516: WHERE visit_id = c_visit_id;
1517:
1518: -- Cursor to get all the flight schedule records whose status is 'Updated'
1519: Cursor get_flight_schedule_rows(c_status IN VARCHAR2)

Line 1622: FROM AHL_VISITS_B

1618: -- Cursor to get all the associated visits for the passed flight schedule
1619: Cursor get_assoc_visits(c_flight_schedule_id IN NUMBER)
1620: IS
1621: SELECT visit_id, organization_id, locked_flag, firmed_flag, status_code, start_date_time, close_date_time,AUTO_VISIT_TYPE_FLAG
1622: FROM AHL_VISITS_B
1623: WHERE UNIT_SCHEDULE_ID = C_FLIGHT_SCHEDULE_ID
1624: AND status_code NOT IN ('DELETED','CANCELLED')
1625: ORDER BY visit_id asc; --added this condition by tchimira for bug 13828335
1626:

Line 1631: FROM AHL_VISITS_B

1627: -- Cursor to get visit end time
1628: Cursor get_visit_end_time(c_visit_id IN NUMBER)
1629: IS
1630: SELECT close_date_time
1631: FROM AHL_VISITS_B
1632: WHERE VISIT_ID = c_visit_id;
1633:
1634: -- Cursor to get preceeding flight schedule details
1635: Cursor get_pre_fs_det(c_unit_schedule_id IN NUMBER)

Line 1646: FROM AHL_VISITS_B

1642: -- Cursor to get visit type of a visit
1643: Cursor get_visit_type_code(c_visit_id IN NUMBER)
1644: IS
1645: SELECT visit_type_code
1646: FROM AHL_VISITS_B
1647: WHERE VISIT_ID = c_visit_id;
1648:
1649: -- Cursor to get visit start time
1650: Cursor get_visit_start_time(c_visit_id IN NUMBER)

Line 1653: FROM AHL_VISITS_B

1649: -- Cursor to get visit start time
1650: Cursor get_visit_start_time(c_visit_id IN NUMBER)
1651: IS
1652: SELECT start_date_time
1653: FROM AHL_VISITS_B
1654: WHERE VISIT_ID = c_visit_id;
1655:
1656: -- To find visit related information
1657: CURSOR c_Visit(c_visit_id IN NUMBER) IS

Line 1667: FROM ahl_visit_types_b vtyp, ahl_visits_b visit, ahl_unit_config_headers unit, ahl_mc_headers_b mc

1663: --To get visit type duration of a given visit
1664: --Modified the below cursor by tchimira as a fix for issue 1 in the bug 13777327 on 01-Mar-2012
1665: CURSOR c_Visit_type_dur(c_visit_id IN NUMBER) IS
1666: SELECT vtyp.estimated_duration
1667: FROM ahl_visit_types_b vtyp, ahl_visits_b visit, ahl_unit_config_headers unit, ahl_mc_headers_b mc
1668: WHERE visit.visit_id = c_visit_id
1669: AND vtyp.visit_type_code = visit.visit_type_code
1670: AND unit.csi_item_instance_id = visit.item_instance_id
1671: AND unit.master_config_id = mc.mc_header_id

Line 1680: FROM AHL_VISITS_B

1676: -- if all the conditions match, then the visit can be updated or cancelled
1677: Cursor can_cancel_visit(c_visit_id IN NUMBER)
1678: IS
1679: SELECT 'X'
1680: FROM AHL_VISITS_B
1681: WHERE VISIT_ID = c_visit_id
1682: AND STATUS_CODE = 'PLANNING'
1683: AND NVL(FIRMED_FLAG,'N') <> 'Y'
1684: AND NVL(LOCKED_FLAG,'N') <> 'Y';

Line 4151: FROM ahl_visits_b

4147:
4148: -- Cursor to get the visit Number from visit_id
4149: CURSOR get_visit_number(c_visit_id IN NUMBER) IS
4150: SELECT visit_number
4151: FROM ahl_visits_b
4152: WHERE visit_id = c_visit_id;
4153:
4154: --Added cursor to get flight details for loggin :: PRAKKUM :: 01/08/2012
4155: Cursor get_flight_details (c_us_id IN NUMBER)

Line 4411: FROM ahl_visits_b

4407:
4408: -- Cursor to get the visit Number from visit_id
4409: CURSOR get_visit_number(c_visit_id IN NUMBER) IS
4410: SELECT visit_number
4411: FROM ahl_visits_b
4412: WHERE visit_id = c_visit_id;
4413:
4414: --Added cursor to get flight details for loggin :: PRAKKUM :: 01/08/2012
4415: Cursor get_flight_details (c_us_id IN NUMBER)

Line 4667: FROM ahl_visits_b

4663:
4664: -- Cursor to get the visit Number from visit_id
4665: CURSOR get_visit_number(c_visit_id IN NUMBER) IS
4666: SELECT visit_number
4667: FROM ahl_visits_b
4668: WHERE visit_id = c_visit_id;
4669:
4670: -- Bug 14336467 :: PRAKKUM :: 12/07/2012
4671: -- Cursor to get visit type duration

Line 5849: FROM AHL_VISITS_B

5845: --Cursor to find if the visit is in planning status and not firmed and not locked
5846: Cursor can_cancel_visit(c_visit_id IN NUMBER)
5847: IS
5848: SELECT 'X'
5849: FROM AHL_VISITS_B
5850: WHERE VISIT_ID = c_visit_id
5851: AND STATUS_CODE = 'PLANNING'
5852: AND NVL(FIRMED_FLAG,'N') <> 'Y'
5853: AND NVL(LOCKED_FLAG,'N') <> 'Y';

Line 5965: FROM ahl_visits_b

5961:
5962: --Cursor to get visit details
5963: CURSOR get_visit_details(c_visit_id IN NUMBER) IS
5964: SELECT visit_number, auto_visit_type_flag auto_flag
5965: FROM ahl_visits_b
5966: WHERE visit_id = c_visit_id;
5967: vst_details_rec get_visit_details%ROWTYPE;
5968:
5969:

Line 5988: UPDATE ahl_visits_b

5984: 'p_visit_id --@> '||p_visit_id||
5985: 'p_unit_schedule_id --@> '||p_unit_schedule_id);
5986: END IF;
5987:
5988: UPDATE ahl_visits_b
5989: SET UNIT_SCHEDULE_ID = null,
5990: OBJECT_VERSION_NUMBER = object_version_number + 1,
5991: LAST_UPDATE_DATE = SYSDATE,
5992: LAST_UPDATED_BY = Fnd_Global.USER_ID,