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_UMP_NONROUTINES_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 298: FROM ahl_unit_effectivities_b

294:
295: -- Retrieve the UE created by the SR, and update the necessary information...
296: SELECT unit_effectivity_id, unit_effectivity_id, object_version_number
297: INTO l_unit_effectivity_id, p_x_nonroutine_rec.unit_effectivity_id, p_x_nonroutine_rec.ue_object_version_number
298: FROM ahl_unit_effectivities_b
299: WHERE object_type = 'SR' and
300: cs_incident_id = p_x_nonroutine_rec.incident_id;
301:
302: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)

Line 333: UPDATE ahl_unit_effectivities_b

329: );
330: END IF;
331:
332: -- Update the UE record with the NR specific information
333: UPDATE ahl_unit_effectivities_b
334: SET log_series_code = p_x_nonroutine_rec.log_series_code,
335: log_series_number = p_x_nonroutine_rec.log_series_number,
336: flight_number = p_x_nonroutine_rec.flight_number,
337: -- clear_station_org_id = p_x_nonroutine_rec.clear_station_org_id,

Line 620: FROM ahl_unit_effectivities_b

616: c_incident_id number
617: )
618: IS
619: SELECT unit_effectivity_id, object_version_number
620: FROM ahl_unit_effectivities_b
621: WHERE object_type = 'SR' and
622: cs_incident_id = c_incident_id and
623: nvl(status_code, 'X') <> 'DEFERRED';
624:

Line 854: FROM ahl_unit_effectivities_b

850: IF (p_x_nonroutine_rec.unit_effectivity_id IS NOT NULL AND p_x_nonroutine_rec.unit_effectivity_id <> FND_API.G_MISS_NUM)
851: THEN
852: SELECT object_version_number
853: INTO p_x_nonroutine_rec.ue_object_version_number
854: FROM ahl_unit_effectivities_b
855: WHERE unit_effectivity_id = p_x_nonroutine_rec.unit_effectivity_id;
856: ELSE
857: OPEN get_ue_details (p_x_nonroutine_rec.incident_id);
858: FETCH get_ue_details INTO p_x_nonroutine_rec.unit_effectivity_id, p_x_nonroutine_rec.ue_object_version_number;

Line 896: UPDATE ahl_unit_effectivities_b

892: END IF;
893:
894: -- Update the UE record with the NR specific information
895: -- Note: Log Series, Number cannot be modified once created...
896: UPDATE ahl_unit_effectivities_b
897: SET log_series_code = p_x_nonroutine_rec.log_series_code,
898: log_series_number = p_x_nonroutine_rec.log_series_number,
899: flight_number = p_x_nonroutine_rec.flight_number,
900: -- clear_station_org_id = p_x_nonroutine_rec.clear_station_org_id,

Line 920: UPDATE ahl_unit_effectivities_b

916: );
917: END IF;
918:
919: -- Update the UE record with the MEL/CDL Qualification specific information
920: UPDATE ahl_unit_effectivities_b
921: SET mel_cdl_type_code = p_x_nonroutine_rec.mel_cdl_type_code,
922: position_path_id = p_x_nonroutine_rec.position_path_id,
923: ata_code = p_x_nonroutine_rec.ata_code
924: WHERE unit_effectivity_id = l_unit_effectivity_id;

Line 1283: from ahl_unit_effectivities_b

1279: is
1280: select unit_effectivity_id, object_version_number, status_code,
1281: cs_incident_id, mel_cdl_type_code, csi_item_instance_id,
1282: unit_config_header_id, log_series_code, log_series_number
1283: from ahl_unit_effectivities_b
1284: where unit_effectivity_id = p_ue_id
1285: and object_type = 'SR'
1286: and (status_code IS NULL or status_code = 'INIT_DUE')
1287: for update of object_version_number;

Line 1337: from AHL_UNIT_EFFECTIVITIES_B UE, CS_INCIDENTS_ALL_B CS,

1333: p_unit_config_header_id IN NUMBER)
1334: --p_cs_incident_id IN NUMBER)
1335: is
1336: select count(ue.cs_incident_id)
1337: from AHL_UNIT_EFFECTIVITIES_B UE, CS_INCIDENTS_ALL_B CS,
1338: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1339: AHL_MEL_CDL_ATA_SEQUENCES SEQ
1340: where SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1341: AND UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID

Line 1965: FROM ahl_unit_effectivities_b

1961: CURSOR get_ue_details
1962: IS
1963: SELECT ahl_util_uc_pkg.get_uc_header_id(csi_item_instance_id),
1964: mel_cdl_type_code
1965: FROM ahl_unit_effectivities_b
1966: WHERE unit_effectivity_id = p_unit_effectivity_id;
1967:
1968: l_unit_config_id number;
1969: l_mel_cdl_type_code varchar2(30);

Line 2191: FROM ahl_unit_effectivities_b

2187: p_unit_effectivity_id number
2188: )
2189: IS
2190: SELECT log_series_code, log_series_number, position_path_id, mel_cdl_type_code, ata_code
2191: FROM ahl_unit_effectivities_b
2192: WHERE unit_effectivity_id = p_unit_effectivity_id;
2193:
2194: l_ue_detail_rec get_ue_details%rowtype;
2195:

Line 2204: FROM ahl_unit_effectivities_b

2200: */
2201: CURSOR check_lognum_unique
2202: IS
2203: SELECT 'x'
2204: FROM ahl_unit_effectivities_b
2205: WHERE log_series_number = p_x_nonroutine_rec.log_series_number and
2206: log_series_code = p_x_nonroutine_rec.log_series_code and
2207: unit_effectivity_id <> nvl(p_unit_effectivity_id, unit_effectivity_id) and
2208: unit_config_header_id = nvl(p_x_nonroutine_rec.unit_config_header_id, unit_config_header_id ) and --pdoki added for ER 9204858

Line 2706: FROM ahl_unit_effectivities_b

2702: ahl_util_uc_pkg.get_unit_name(csi_item_instance_id) unit_config_name,
2703: mel_cdl_type_code,
2704: position_path_id,
2705: ata_code
2706: FROM ahl_unit_effectivities_b
2707: WHERE unit_effectivity_id = p_unit_effectivity_id;
2708:
2709: l_ue_details_rec get_ue_details%rowtype;
2710:

Line 2880: UPDATE ahl_unit_effectivities_b

2876: END IF;
2877:
2878: IF x_ata_sequence_id IS NOT NULL
2879: THEN
2880: UPDATE ahl_unit_effectivities_b
2881: SET ata_code = l_ata_for_position
2882: WHERE unit_effectivity_id = p_unit_effectivity_id;
2883: END IF;
2884: END IF;

Line 3391: from ahl_unit_effectivities_b UE, cs_incidents_all_b cs

3387: -- get ue details for SR created.
3388: cursor get_ue_detls(p_cs_incident_id IN NUMBER)
3389: is
3390: select cs.object_version_number, ue.unit_effectivity_id
3391: from ahl_unit_effectivities_b UE, cs_incidents_all_b cs
3392: where ue.cs_incident_id = cs.incident_id
3393: and cs.incident_id = p_cs_incident_id;
3394:
3395: -- get default incident type.

Line 3468: FROM ahl_unit_effectivities_b

3464:
3465: -- get new UE for the incident ID deferred.
3466: CURSOR get_new_ue_csr (p_cs_incident_id IN NUMBER) IS
3467: SELECT unit_effectivity_id
3468: FROM ahl_unit_effectivities_b
3469: WHERE cs_incident_id = p_cs_incident_id
3470: AND status_code IS NULL;
3471:
3472: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;