APPS.AHL_UNIT_EFFECTIVITIES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 3

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_UNIT_EFFECTIVITY_ID in out NOCOPY NUMBER,
  X_MANUALLY_PLANNED_FLAG in VARCHAR2,
  X_LOG_SERIES_CODE in VARCHAR2,
  X_LOG_SERIES_NUMBER in NUMBER,
  X_FLIGHT_NUMBER in VARCHAR2,
  X_MEL_CDL_TYPE_CODE in VARCHAR2,
  X_POSITION_PATH_ID in NUMBER,
  X_ATA_CODE in VARCHAR2,
  --X_CLEAR_STATION_ORG_ID in NUMBER,
  --X_CLEAR_STATION_DEPT_ID in NUMBER,
  X_UNIT_CONFIG_HEADER_ID in NUMBER,
  X_QA_COLLECTION_ID in NUMBER,
  X_CS_INCIDENT_ID in NUMBER,
  X_OBJECT_TYPE in VARCHAR2,
  X_APPLICATION_USG_CODE in VARCHAR2,
  X_COUNTER_ID in NUMBER,
  X_EARLIEST_DUE_DATE in DATE,
  X_LATEST_DUE_DATE in DATE,
  X_FORECAST_SEQUENCE in NUMBER,
  X_REPETITIVE_MR_FLAG in VARCHAR2,
  X_TOLERANCE_FLAG in VARCHAR2,
  X_MESSAGE_CODE in VARCHAR2,
  X_DATE_RUN in DATE,
  X_PRECEDING_UE_ID in NUMBER,
  X_SET_DUE_DATE in DATE,
  X_ACCOMPLISHED_DATE in DATE,
  X_SERVICE_LINE_ID in NUMBER,
  X_PROGRAM_MR_HEADER_ID in NUMBER,
  X_CANCEL_REASON_CODE in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_CSI_ITEM_INSTANCE_ID in NUMBER,
  X_MR_HEADER_ID in NUMBER,
  X_MR_EFFECTIVITY_ID in NUMBER,
  X_MR_INTERVAL_ID in NUMBER,
  X_STATUS_CODE in VARCHAR2,
  X_DUE_DATE in DATE,
  X_DUE_COUNTER_VALUE in NUMBER,
  X_DEFER_FROM_UE_ID in NUMBER,
  X_ORIG_DEFERRAL_UE_ID in NUMBER,
  X_REMARKS in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from AHL_UNIT_EFFECTIVITIES_B
    where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID
    ;

Line: 71

  insert into AHL_UNIT_EFFECTIVITIES_B (
    MANUALLY_PLANNED_FLAG,
    LOG_SERIES_CODE,
    LOG_SERIES_NUMBER,
    FLIGHT_NUMBER,
    MEL_CDL_TYPE_CODE,
    POSITION_PATH_ID,
    ATA_CODE,
    --CLEAR_STATION_ORG_ID,
    --CLEAR_STATION_DEPT_ID,
    UNIT_CONFIG_HEADER_ID,
    QA_COLLECTION_ID,
    CS_INCIDENT_ID,
    OBJECT_TYPE,
    APPLICATION_USG_CODE,
    COUNTER_ID,
    EARLIEST_DUE_DATE,
    LATEST_DUE_DATE,
    FORECAST_SEQUENCE,
    REPETITIVE_MR_FLAG,
    TOLERANCE_FLAG,
    MESSAGE_CODE,
    DATE_RUN,
    PRECEDING_UE_ID,
    SET_DUE_DATE,
    ACCOMPLISHED_DATE,
    SERVICE_LINE_ID,
    PROGRAM_MR_HEADER_ID,
    CANCEL_REASON_CODE,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    UNIT_EFFECTIVITY_ID,
    OBJECT_VERSION_NUMBER,
    CSI_ITEM_INSTANCE_ID,
    MR_HEADER_ID,
    MR_EFFECTIVITY_ID,
    MR_INTERVAL_ID,
    STATUS_CODE,
    DUE_DATE,
    DUE_COUNTER_VALUE,
    DEFER_FROM_UE_ID,
    ORIG_DEFERRAL_UE_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_MANUALLY_PLANNED_FLAG,
    X_LOG_SERIES_CODE,
    X_LOG_SERIES_NUMBER,
    X_FLIGHT_NUMBER,
    X_MEL_CDL_TYPE_CODE,
    X_POSITION_PATH_ID,
    X_ATA_CODE,
    --X_CLEAR_STATION_ORG_ID,
    --X_CLEAR_STATION_DEPT_ID,
    X_UNIT_CONFIG_HEADER_ID,
    X_QA_COLLECTION_ID,
    X_CS_INCIDENT_ID,
    X_OBJECT_TYPE,
    X_APPLICATION_USG_CODE,
    X_COUNTER_ID,
    X_EARLIEST_DUE_DATE,
    X_LATEST_DUE_DATE,
    X_FORECAST_SEQUENCE,
    X_REPETITIVE_MR_FLAG,
    X_TOLERANCE_FLAG,
    X_MESSAGE_CODE,
    X_DATE_RUN,
    X_PRECEDING_UE_ID,
    X_SET_DUE_DATE,
    X_ACCOMPLISHED_DATE,
    X_SERVICE_LINE_ID,
    X_PROGRAM_MR_HEADER_ID,
    X_CANCEL_REASON_CODE,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    AHL_UNIT_EFFECTIVITIES_B_S.NEXTVAL,
    X_OBJECT_VERSION_NUMBER,
    X_CSI_ITEM_INSTANCE_ID,
    X_MR_HEADER_ID,
    X_MR_EFFECTIVITY_ID,
    X_MR_INTERVAL_ID,
    X_STATUS_CODE,
    X_DUE_DATE,
    X_DUE_COUNTER_VALUE,
    X_DEFER_FROM_UE_ID,
    X_ORIG_DEFERRAL_UE_ID,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  ) RETURNING UNIT_EFFECTIVITY_ID INTO X_UNIT_EFFECTIVITY_ID;

Line: 195

  insert into AHL_UNIT_EFFECTIVITIES_TL (
    UNIT_EFFECTIVITY_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    REMARKS,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_UNIT_EFFECTIVITY_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_REMARKS,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AHL_UNIT_EFFECTIVITIES_TL T
    where T.UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 231

end INSERT_ROW;

Line: 291

  cursor c is select
      MANUALLY_PLANNED_FLAG,
      LOG_SERIES_CODE,
      LOG_SERIES_NUMBER,
      FLIGHT_NUMBER,
      MEL_CDL_TYPE_CODE,
      POSITION_PATH_ID,
      ATA_CODE,
      --CLEAR_STATION_ORG_ID,
      --CLEAR_STATION_DEPT_ID,
      UNIT_CONFIG_HEADER_ID,
      QA_COLLECTION_ID,
      CS_INCIDENT_ID,
      OBJECT_TYPE,
      APPLICATION_USG_CODE,
      COUNTER_ID,
      EARLIEST_DUE_DATE,
      LATEST_DUE_DATE,
      FORECAST_SEQUENCE,
      REPETITIVE_MR_FLAG,
      TOLERANCE_FLAG,
      MESSAGE_CODE,
      DATE_RUN,
      PRECEDING_UE_ID,
      SET_DUE_DATE,
      ACCOMPLISHED_DATE,
      SERVICE_LINE_ID,
      PROGRAM_MR_HEADER_ID,
      CANCEL_REASON_CODE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      OBJECT_VERSION_NUMBER,
      CSI_ITEM_INSTANCE_ID,
      MR_HEADER_ID,
      MR_EFFECTIVITY_ID,
      MR_INTERVAL_ID,
      STATUS_CODE,
      DUE_DATE,
      DUE_COUNTER_VALUE,
      DEFER_FROM_UE_ID,
      ORIG_DEFERRAL_UE_ID
    from AHL_UNIT_EFFECTIVITIES_B
    where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID
    for update of UNIT_EFFECTIVITY_ID nowait;

Line: 351

  cursor c1 is select
      REMARKS,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AHL_UNIT_EFFECTIVITIES_TL
    where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of UNIT_EFFECTIVITY_ID nowait;

Line: 363

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 495

procedure UPDATE_ROW (
  X_UNIT_EFFECTIVITY_ID in NUMBER,
  X_MANUALLY_PLANNED_FLAG in VARCHAR2,
  X_LOG_SERIES_CODE in VARCHAR2,
  X_LOG_SERIES_NUMBER in NUMBER,
  X_FLIGHT_NUMBER in VARCHAR2,
  X_MEL_CDL_TYPE_CODE in VARCHAR2,
  X_POSITION_PATH_ID in NUMBER,
  X_ATA_CODE in VARCHAR2,
  --X_CLEAR_STATION_ORG_ID in NUMBER,
  --X_CLEAR_STATION_DEPT_ID in NUMBER,
  X_UNIT_CONFIG_HEADER_ID in NUMBER,
  X_QA_COLLECTION_ID in NUMBER,
  X_CS_INCIDENT_ID in NUMBER,
  X_OBJECT_TYPE in VARCHAR2,
  X_APPLICATION_USG_CODE in VARCHAR2,
  X_COUNTER_ID in NUMBER,
  X_EARLIEST_DUE_DATE in DATE,
  X_LATEST_DUE_DATE in DATE,
  X_FORECAST_SEQUENCE in NUMBER,
  X_REPETITIVE_MR_FLAG in VARCHAR2,
  X_TOLERANCE_FLAG in VARCHAR2,
  X_MESSAGE_CODE in VARCHAR2,
  X_DATE_RUN in DATE,
  X_PRECEDING_UE_ID in NUMBER,
  X_SET_DUE_DATE in DATE,
  X_ACCOMPLISHED_DATE in DATE,
  X_SERVICE_LINE_ID in NUMBER,
  X_PROGRAM_MR_HEADER_ID in NUMBER,
  X_CANCEL_REASON_CODE in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_CSI_ITEM_INSTANCE_ID in NUMBER,
  X_MR_HEADER_ID in NUMBER,
  X_MR_EFFECTIVITY_ID in NUMBER,
  X_MR_INTERVAL_ID in NUMBER,
  X_STATUS_CODE in VARCHAR2,
  X_DUE_DATE in DATE,
  X_DUE_COUNTER_VALUE in NUMBER,
  X_DEFER_FROM_UE_ID in NUMBER,
  X_ORIG_DEFERRAL_UE_ID in NUMBER,
  X_REMARKS in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AHL_UNIT_EFFECTIVITIES_B set
    MANUALLY_PLANNED_FLAG = X_MANUALLY_PLANNED_FLAG,
    LOG_SERIES_CODE = X_LOG_SERIES_CODE,
    LOG_SERIES_NUMBER = X_LOG_SERIES_NUMBER,
    FLIGHT_NUMBER = X_FLIGHT_NUMBER,
    MEL_CDL_TYPE_CODE = X_MEL_CDL_TYPE_CODE,
    POSITION_PATH_ID = X_POSITION_PATH_ID,
    ATA_CODE = X_ATA_CODE,
    --CLEAR_STATION_ORG_ID = X_CLEAR_STATION_ORG_ID,
    --CLEAR_STATION_DEPT_ID = X_CLEAR_STATION_DEPT_ID,
    UNIT_CONFIG_HEADER_ID = X_UNIT_CONFIG_HEADER_ID,
    QA_COLLECTION_ID = X_QA_COLLECTION_ID,
    CS_INCIDENT_ID = X_CS_INCIDENT_ID,
    OBJECT_TYPE = X_OBJECT_TYPE,
    APPLICATION_USG_CODE = X_APPLICATION_USG_CODE,
    COUNTER_ID = X_COUNTER_ID,
    EARLIEST_DUE_DATE = X_EARLIEST_DUE_DATE,
    LATEST_DUE_DATE = X_LATEST_DUE_DATE,
    FORECAST_SEQUENCE = X_FORECAST_SEQUENCE,
    REPETITIVE_MR_FLAG = X_REPETITIVE_MR_FLAG,
    TOLERANCE_FLAG = X_TOLERANCE_FLAG,
    MESSAGE_CODE = X_MESSAGE_CODE,
    DATE_RUN = X_DATE_RUN,
    PRECEDING_UE_ID = X_PRECEDING_UE_ID,
    SET_DUE_DATE = X_SET_DUE_DATE,
    ACCOMPLISHED_DATE = X_ACCOMPLISHED_DATE,
    SERVICE_LINE_ID = X_SERVICE_LINE_ID,
    PROGRAM_MR_HEADER_ID = X_PROGRAM_MR_HEADER_ID,
    CANCEL_REASON_CODE = X_CANCEL_REASON_CODE,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    CSI_ITEM_INSTANCE_ID = X_CSI_ITEM_INSTANCE_ID,
    MR_HEADER_ID = X_MR_HEADER_ID,
    MR_EFFECTIVITY_ID = X_MR_EFFECTIVITY_ID,
    MR_INTERVAL_ID = X_MR_INTERVAL_ID,
    STATUS_CODE = X_STATUS_CODE,
    DUE_DATE = X_DUE_DATE,
    DUE_COUNTER_VALUE = X_DUE_COUNTER_VALUE,
    DEFER_FROM_UE_ID = X_DEFER_FROM_UE_ID,
    ORIG_DEFERRAL_UE_ID = X_ORIG_DEFERRAL_UE_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID;

Line: 621

  update AHL_UNIT_EFFECTIVITIES_TL set
    REMARKS = X_REMARKS,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 633

end UPDATE_ROW;

Line: 635

procedure DELETE_ROW (
  X_UNIT_EFFECTIVITY_ID in NUMBER
) is
begin
  delete from AHL_UNIT_EFFECTIVITIES_TL
  where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID;

Line: 646

  delete from AHL_UNIT_EFFECTIVITIES_B
  where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID;

Line: 652

end DELETE_ROW;

Line: 657

  delete from AHL_UNIT_EFFECTIVITIES_TL T
  where not exists
    (select NULL
    from AHL_UNIT_EFFECTIVITIES_B B
    where B.UNIT_EFFECTIVITY_ID = T.UNIT_EFFECTIVITY_ID
    );

Line: 664

  update AHL_UNIT_EFFECTIVITIES_TL T set (
      REMARKS
    ) = (select
      B.REMARKS
    from AHL_UNIT_EFFECTIVITIES_TL B
    where B.UNIT_EFFECTIVITY_ID = T.UNIT_EFFECTIVITY_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.UNIT_EFFECTIVITY_ID,
      T.LANGUAGE
  ) in (select
      SUBT.UNIT_EFFECTIVITY_ID,
      SUBT.LANGUAGE
    from AHL_UNIT_EFFECTIVITIES_TL SUBB, AHL_UNIT_EFFECTIVITIES_TL SUBT
    where SUBB.UNIT_EFFECTIVITY_ID = SUBT.UNIT_EFFECTIVITY_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.REMARKS <> SUBT.REMARKS
      or (SUBB.REMARKS is null and SUBT.REMARKS is not null)
      or (SUBB.REMARKS is not null and SUBT.REMARKS is null)
  ));

Line: 685

  insert into AHL_UNIT_EFFECTIVITIES_TL (
    UNIT_EFFECTIVITY_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    REMARKS,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.UNIT_EFFECTIVITY_ID,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.REMARKS,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from AHL_UNIT_EFFECTIVITIES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from AHL_UNIT_EFFECTIVITIES_TL T
    where T.UNIT_EFFECTIVITY_ID = B.UNIT_EFFECTIVITY_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);