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 268: FROM ahl_unit_effectivities_b

264:
265: -- Retrieve the UE created by the SR, and update the necessary information...
266: SELECT unit_effectivity_id, unit_effectivity_id, object_version_number
267: INTO l_unit_effectivity_id, p_x_nonroutine_rec.unit_effectivity_id, p_x_nonroutine_rec.ue_object_version_number
268: FROM ahl_unit_effectivities_b
269: WHERE object_type = 'SR' and
270: cs_incident_id = p_x_nonroutine_rec.incident_id;
271:
272: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)

Line 303: UPDATE ahl_unit_effectivities_b

299: );
300: END IF;
301:
302: -- Update the UE record with the NR specific information
303: UPDATE ahl_unit_effectivities_b
304: SET log_series_code = p_x_nonroutine_rec.log_series_code,
305: log_series_number = p_x_nonroutine_rec.log_series_number,
306: flight_number = p_x_nonroutine_rec.flight_number,
307: -- clear_station_org_id = p_x_nonroutine_rec.clear_station_org_id,

Line 563: FROM ahl_unit_effectivities_b

559: c_incident_id number
560: )
561: IS
562: SELECT unit_effectivity_id, object_version_number
563: FROM ahl_unit_effectivities_b
564: WHERE object_type = 'SR' and
565: cs_incident_id = c_incident_id and
566: nvl(status_code, 'X') <> 'DEFERRED';
567:

Line 775: FROM ahl_unit_effectivities_b

771: IF (p_x_nonroutine_rec.unit_effectivity_id IS NOT NULL AND p_x_nonroutine_rec.unit_effectivity_id <> FND_API.G_MISS_NUM)
772: THEN
773: SELECT object_version_number
774: INTO p_x_nonroutine_rec.ue_object_version_number
775: FROM ahl_unit_effectivities_b
776: WHERE unit_effectivity_id = p_x_nonroutine_rec.unit_effectivity_id;
777: ELSE
778: OPEN get_ue_details (p_x_nonroutine_rec.incident_id);
779: FETCH get_ue_details INTO p_x_nonroutine_rec.unit_effectivity_id, p_x_nonroutine_rec.ue_object_version_number;

Line 817: UPDATE ahl_unit_effectivities_b

813: END IF;
814:
815: -- Update the UE record with the NR specific information
816: -- Note: Log Series, Number cannot be modified once created...
817: UPDATE ahl_unit_effectivities_b
818: SET log_series_code = p_x_nonroutine_rec.log_series_code,
819: log_series_number = p_x_nonroutine_rec.log_series_number,
820: flight_number = p_x_nonroutine_rec.flight_number,
821: -- clear_station_org_id = p_x_nonroutine_rec.clear_station_org_id,

Line 839: UPDATE ahl_unit_effectivities_b

835: );
836: END IF;
837:
838: -- Update the UE record with the MEL/CDL Qualification specific information
839: UPDATE ahl_unit_effectivities_b
840: SET mel_cdl_type_code = p_x_nonroutine_rec.mel_cdl_type_code,
841: position_path_id = p_x_nonroutine_rec.position_path_id,
842: ata_code = p_x_nonroutine_rec.ata_code
843: WHERE unit_effectivity_id = l_unit_effectivity_id;

Line 1200: from ahl_unit_effectivities_b

1196: is
1197: select unit_effectivity_id, object_version_number, status_code,
1198: cs_incident_id, mel_cdl_type_code, csi_item_instance_id,
1199: unit_config_header_id, log_series_code, log_series_number
1200: from ahl_unit_effectivities_b
1201: where unit_effectivity_id = p_ue_id
1202: and object_type = 'SR'
1203: and (status_code IS NULL or status_code = 'INIT_DUE')
1204: for update of object_version_number;

Line 1254: from AHL_UNIT_EFFECTIVITIES_B UE, CS_INCIDENTS_ALL_B CS,

1250: p_unit_config_header_id IN NUMBER)
1251: --p_cs_incident_id IN NUMBER)
1252: is
1253: select count(ue.cs_incident_id)
1254: from AHL_UNIT_EFFECTIVITIES_B UE, CS_INCIDENTS_ALL_B CS,
1255: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1256: AHL_MEL_CDL_ATA_SEQUENCES SEQ
1257: where SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1258: AND UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID

Line 1877: FROM ahl_unit_effectivities_b

1873: CURSOR get_ue_details
1874: IS
1875: SELECT ahl_util_uc_pkg.get_uc_header_id(csi_item_instance_id),
1876: mel_cdl_type_code
1877: FROM ahl_unit_effectivities_b
1878: WHERE unit_effectivity_id = p_unit_effectivity_id;
1879:
1880: l_unit_config_id number;
1881: l_mel_cdl_type_code varchar2(30);

Line 2098: FROM ahl_unit_effectivities_b

2094: p_unit_effectivity_id number
2095: )
2096: IS
2097: SELECT log_series_code, log_series_number, position_path_id, mel_cdl_type_code, ata_code
2098: FROM ahl_unit_effectivities_b
2099: WHERE unit_effectivity_id = p_unit_effectivity_id;
2100:
2101: l_ue_detail_rec get_ue_details%rowtype;
2102:

Line 2111: FROM ahl_unit_effectivities_b

2107: */
2108: CURSOR check_lognum_unique
2109: IS
2110: SELECT 'x'
2111: FROM ahl_unit_effectivities_b
2112: WHERE log_series_number = p_x_nonroutine_rec.log_series_number and
2113: log_series_code = p_x_nonroutine_rec.log_series_code and
2114: unit_effectivity_id <> nvl(p_unit_effectivity_id, unit_effectivity_id) and
2115: nvl(status_code, 'X') <> 'DEFERRED';

Line 2612: FROM ahl_unit_effectivities_b

2608: ahl_util_uc_pkg.get_unit_name(csi_item_instance_id) unit_config_name,
2609: mel_cdl_type_code,
2610: position_path_id,
2611: ata_code
2612: FROM ahl_unit_effectivities_b
2613: WHERE unit_effectivity_id = p_unit_effectivity_id;
2614:
2615: l_ue_details_rec get_ue_details%rowtype;
2616:

Line 2786: UPDATE ahl_unit_effectivities_b

2782: END IF;
2783:
2784: IF x_ata_sequence_id IS NOT NULL
2785: THEN
2786: UPDATE ahl_unit_effectivities_b
2787: SET ata_code = l_ata_for_position
2788: WHERE unit_effectivity_id = p_unit_effectivity_id;
2789: END IF;
2790: END IF;

Line 3233: from ahl_unit_effectivities_b UE, cs_incidents_all_b cs

3229: -- get ue details for SR created.
3230: cursor get_ue_detls(p_cs_incident_id IN NUMBER)
3231: is
3232: select cs.object_version_number, ue.unit_effectivity_id
3233: from ahl_unit_effectivities_b UE, cs_incidents_all_b cs
3234: where ue.cs_incident_id = cs.incident_id
3235: and cs.incident_id = p_cs_incident_id;
3236:
3237: -- get default incident type.

Line 3294: FROM ahl_unit_effectivities_b

3290:
3291: -- get new UE for the incident ID deferred.
3292: CURSOR get_new_ue_csr (p_cs_incident_id IN NUMBER) IS
3293: SELECT unit_effectivity_id
3294: FROM ahl_unit_effectivities_b
3295: WHERE cs_incident_id = p_cs_incident_id
3296: AND status_code IS NULL;
3297:
3298: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;