APPS.AD_RELEASES_PVT SQL Statements

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

Line: 22

    select release_id
    into p_release_id
    from ad_releases
    where major_version = p_major_version
    and minor_version = p_minor_version
    and tape_version = p_tape_version;

Line: 63

  update ad_releases
  set end_date_active = p_start_dt - 1 / (24*60*60)
  where release_id in (select release_id
                       from ad_releases
                       where major_version = p_major_version
                       and minor_version = p_minor_version
                       and sysdate between start_date_active and
                                           nvl(end_date_active, sysdate+1));

Line: 72

  select ad_releases_s.nextval
  into v_release_id
  from dual;

Line: 76

  insert into ad_releases
  (
    RELEASE_ID,
    MAJOR_VERSION,
    MINOR_VERSION,
    TAPE_VERSION,
    ROW_SOURCE_COMMENTS,
    ARU_RELEASE_NAME,
    BASE_RELEASE_FLAG,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY
  )
  values
  (
    v_release_id   ,
    p_major_version,
    p_minor_version,
    p_tape_version ,
    p_row_src_comments,
    'R12',               /* @@ Be sure to update this in future apps releases */
    UPPER(p_base_rel_flag),
    p_start_dt,
    p_end_dt,
    sysdate,
    p_created_by_user_id,
    sysdate,
    p_created_by_user_id
  );