APPS.FND_OAM_METALINK_DOC_ASSOC_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,
    X_ANCHOR in VARCHAR2) is
  begin

    begin
      fnd_oam_metalink_doc_assoc_pkg.UPDATE_ROW(
        X_DOC_ID => X_DOC_ID,
        X_CATEGORY_KEY => X_CATEGORY_KEY,
        X_CATEGORY_TYPE  => X_CATEGORY_TYPE,
        X_CREATED_BY => X_CREATED_BY,
        X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
        X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN,
        X_ANCHOR => X_ANCHOR);

Line: 26

       fnd_oam_metalink_doc_assoc_pkg.INSERT_ROW(
         X_DOC_ID => X_DOC_ID,
         X_CATEGORY_KEY => X_CATEGORY_KEY,
         X_CATEGORY_TYPE  => X_CATEGORY_TYPE,
         X_CREATED_BY => X_CREATED_BY,
         X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
         X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN,
         X_ANCHOR => X_ANCHOR);

Line: 44

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

      db_id varchar2(40);

Line: 56

    select doc_id into db_id from FND_OAM_METALINK_DOC_ASSOC
       where doc_id = X_DOC_ID
          and category_key = X_CATEGORY_KEY
          and category_type = X_CATEGORY_TYPE ;

Line: 61

    update FND_OAM_METALINK_DOC_ASSOC SET
        doc_id = X_DOC_ID,
        category_key  = X_CATEGORY_KEY,
        category_TYPE  = X_CATEGORY_TYPE,
        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,
        anchor = X_ANCHOR
      where doc_id = X_DOC_ID
            and category_key = X_CATEGORY_KEY
            and category_type = X_CATEGORY_TYPE ;

Line: 75

end UPDATE_ROW;

Line: 77

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

  begin
    insert into FND_OAM_METALINK_DOC_ASSOC (
      doc_id,
      category_key,
      category_type,
      created_by,
      creation_date,
      last_update_date,
      last_updated_by,
      last_update_login,
      anchor
    ) values (
      X_DOC_ID,
      X_CATEGORY_KEY,
      X_CATEGORY_TYPE,
      X_CREATED_BY,
      sysdate,
      sysdate,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN,
      X_ANCHOR);

Line: 108

end INSERT_ROW;