APPS.FND_OAM_DOC_CATEGORY_PKG SQL Statements

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

Line: 8

    X_LAST_UPDATED_BY  in  NUMBER,
    X_LAST_UPDATE_LOGIN	in NUMBER) is
  begin
     begin
      fnd_oam_doc_category_pkg.UPDATE_ROW(
       X_CATEGORY_KEY => X_CATEGORY_KEY,
       X_CATEGORY_TYPE  => X_CATEGORY_TYPE,
       X_CATEGORY_NAME => X_CATEGORY_NAME,
       X_CREATED_BY => X_CREATED_BY,
       X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
       X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN);

Line: 23

       fnd_oam_doc_category_pkg.INSERT_ROW(
          X_CATEGORY_KEY => X_CATEGORY_KEY,
          X_CATEGORY_TYPE  => X_CATEGORY_TYPE,
          X_CATEGORY_NAME => X_CATEGORY_NAME,
          X_CREATED_BY => X_CREATED_BY,
          X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
          X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN);

Line: 38

procedure UPDATE_ROW(
    X_CATEGORY_KEY    in   VARCHAR2,
    X_CATEGORY_TYPE     in   VARCHAR2,
    X_CATEGORY_NAME  in  VARCHAR2,
    X_CREATED_BY    in  NUMBER,
    X_LAST_UPDATED_BY  in  NUMBER,
    X_LAST_UPDATE_LOGIN	in NUMBER) is

    db_key varchar2(40);

Line: 49

    select category_key into db_key from FND_OAM_DOC_CATEGORY
       where category_key = X_CATEGORY_KEY
             and category_type = X_CATEGORY_TYPE ;

Line: 53

    update FND_OAM_DOC_CATEGORY SET
        category_key = X_CATEGORY_KEY,
        category_type  = X_CATEGORY_TYPE ,
        category_name = X_CATEGORY_NAME,
        created_by = X_CREATED_BY,
        creation_date = sysdate,
        last_update_date = sysdate,
        last_updated_by = X_LAST_UPDATED_BY,
        last_update_login = X_LAST_UPDATE_LOGIN
      where category_key = X_CATEGORY_KEY and category_type = X_CATEGORY_TYPE ;

Line: 64

end UPDATE_ROW;

Line: 66

procedure INSERT_ROW(
    X_CATEGORY_KEY    in   VARCHAR2,
    X_CATEGORY_TYPE     in   VARCHAR2,
    X_CATEGORY_NAME  in  VARCHAR2,
    X_CREATED_BY    in  NUMBER,
    X_LAST_UPDATED_BY  in  NUMBER,
    X_LAST_UPDATE_LOGIN	in NUMBER) is

  begin
    insert into FND_OAM_DOC_CATEGORY(
      category_key,
      category_type,
      category_name,
      created_by,
      creation_date,
      last_update_date,
      last_updated_by,
      last_update_login
    ) values (
      X_CATEGORY_KEY,
      X_CATEGORY_TYPE,
      X_CATEGORY_NAME,
      X_CREATED_BY,
      sysdate,
      sysdate,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN);

Line: 94

end INSERT_ROW;