APPS.AD_FEATURE_VERS_PKG SQL Statements

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

Line: 61

  select rcs_version
  into l_curr_rcs_version
  from ad_feature_versions
  where feature_name = p_feature_name
  for update;

Line: 74

    update ad_feature_versions
    set filename = l_actual_filename,
        rcs_version = l_actual_rcs_version
    where filename = p_feature_name;

Line: 85

    update ad_feature_versions
    set current_db_version = p_db_version,
        last_update_date = sysdate
    where feature_name = p_feature_name
    and p_db_version > current_db_version;

Line: 113

    update ad_feature_versions
    set rcs_version = l_actual_rcs_version,
        last_update_date = sysdate
    where feature_name = p_feature_name;

Line: 121

    update ad_feature_versions
    set current_db_version = p_db_version,
        last_update_date = sysdate
    where feature_name = p_feature_name
    and p_db_version > current_db_version;

Line: 132

  insert into ad_feature_versions
  (
    feature_name, current_db_version, enabled_flag,
    filename, rcs_version,
    creation_date,last_update_date
  )
  values
  (
    p_feature_name, p_db_version, p_enabled_flag,
    l_actual_filename, l_actual_rcs_version,
    sysdate, sysdate
  );