APPS.XDO_CONFIG_KEYS_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
          P_VALUE_ID in NUMBER,
          P_VALUE_KEY in RAW,
          P_CREATION_DATE in DATE,
          P_CREATED_BY in NUMBER,
          P_LAST_UPDATE_DATE in DATE,
          P_LAST_UPDATED_BY in NUMBER,
          P_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  insert into XDO_CONFIG_KEYS (
           VALUE_ID,
           VALUE_KEY,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_LOGIN
  ) values (
          P_VALUE_ID,
          P_VALUE_KEY,
          P_CREATION_DATE,
          P_CREATED_BY,
          P_LAST_UPDATE_DATE,
          P_LAST_UPDATED_BY,
          P_LAST_UPDATE_LOGIN
  );

Line: 31

end INSERT_ROW;

Line: 35

procedure UPDATE_ROW (
          P_VALUE_ID in NUMBER,
          P_VALUE_KEY in RAW,
          P_LAST_UPDATE_DATE in DATE,
          P_LAST_UPDATED_BY in NUMBER,
          P_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update XDO_CONFIG_KEYS
     set VALUE_KEY = P_VALUE_KEY,
         LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
         LAST_UPDATED_BY = P_LAST_UPDATED_BY,
         LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where VALUE_ID = P_VALUE_ID;

Line: 54

end UPDATE_ROW;

Line: 57

procedure DELETE_ROW (
          P_VALUE_ID in NUMBER
) is
begin

  delete from XDO_CONFIG_KEYS
   where VALUE_ID = P_VALUE_ID;

Line: 69

end DELETE_ROW;

Line: 76

          P_LAST_UPDATE_DATE in DATE,
          P_LAST_UPDATED_BY in NUMBER,
          P_LAST_UPDATE_LOGIN in NUMBER
) is

begin

  begin

     UPDATE_ROW (
          P_VALUE_ID,
          P_VALUE_KEY,
          P_LAST_UPDATE_DATE,
          P_LAST_UPDATED_BY,
          P_LAST_UPDATE_LOGIN
     );

Line: 95

      INSERT_ROW (
          P_VALUE_ID,
          P_VALUE_KEY,
          P_LAST_UPDATE_DATE,
          P_LAST_UPDATED_BY,
          P_LAST_UPDATE_DATE,
          P_LAST_UPDATED_BY,
          P_LAST_UPDATE_LOGIN
      );