APPS.FND_ORACLE_USER_PKG SQL Statements

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

Line: 45

    update fnd_oracle_userid set
      last_update_date = sysdate,
      last_updated_by = owner_id,
      last_update_login = 0,
      description = nvl(x_description, description),
      enabled_flag = x_enabled_flag,
       read_only_flag = x_read_only_flag
    where oracle_username = upper(x_oracle_username);

Line: 88

	x_last_update_date => null);

Line: 101

  x_last_update_date			in	VARCHAR2) IS

  owner_id number := 0;

Line: 106

  f_ludate  date;    -- entity update date in file

Line: 108

  db_ludate date;    -- entity update date in db

Line: 116

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 119

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
     into db_luby, db_ludate
     from fnd_oracle_userid
    where oracle_username = x_oracle_username;

Line: 139

      update fnd_oracle_userid set
        last_update_date = f_ludate,
        last_updated_by = f_luby,
        last_update_login = 0,
        description = nvl(x_description, description),
        enabled_flag = x_enabled_flag,
        read_only_flag = x_read_only_flag,
        encrypted_oracle_password = enc_pwd
      where oracle_username = x_oracle_username;