APPS.FND_OAM_METALINK_DOCS_PKG SQL Statements

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

Line: 6

    X_DOC_LAST_UPDATE_DATE  in  DATE,
    X_CREATED_BY    in  NUMBER,
    X_LAST_UPDATED_BY  in  NUMBER,
    X_LAST_UPDATE_LOGIN	in NUMBER,
    X_UPDATE_SUMMARY in CLOB) is
  begin

   begin


     fnd_oam_metalink_docs_pkg.UPDATE_ROW(
       X_DOC_ID => X_DOC_ID,
       X_TITLE  => X_TITLE,
       X_DOC_LAST_UPDATE_DATE => X_DOC_LAST_UPDATE_DATE,
       X_CREATED_BY => X_CREATED_BY,
       X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
       X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN,
       X_UPDATE_SUMMARY => X_UPDATE_SUMMARY);

Line: 28

       fnd_oam_metalink_docs_pkg.INSERT_ROW(
         X_DOC_ID => X_DOC_ID,
         X_TITLE  => X_TITLE,
         X_DOC_LAST_UPDATE_DATE => X_DOC_LAST_UPDATE_DATE,
         X_CREATED_BY => X_CREATED_BY,
         X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
         X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN,
         X_UPDATE_SUMMARY => X_UPDATE_SUMMARY);

Line: 43

procedure UPDATE_ROW(
    X_DOC_ID    in   VARCHAR2,
    X_TITLE     in   VARCHAR2,
    X_DOC_LAST_UPDATE_DATE  in  DATE,
    X_CREATED_BY    in  NUMBER,
    X_LAST_UPDATED_BY  in  NUMBER,
    X_LAST_UPDATE_LOGIN	in NUMBER,
    X_UPDATE_SUMMARY in CLOB) is

    db_id varchar2(40);

Line: 55

    select doc_id into db_id from FND_OAM_METALINK_DOCS
       where doc_id = X_DOC_ID;

Line: 58

    update FND_OAM_METALINK_DOCS SET
        doc_id = X_DOC_ID,
        title  = X_TITLE,
        doc_last_update_date = X_DOC_LAST_UPDATE_DATE,
        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,
        update_summary = X_UPDATE_SUMMARY,
        doc_last_update_detected_date = sysdate
        where doc_id = X_DOC_ID and doc_last_update_date < X_DOC_LAST_UPDATE_DATE;

Line: 71

end UPDATE_ROW;

Line: 73

procedure INSERT_ROW(
    X_DOC_ID    in   VARCHAR2,
    X_TITLE     in   VARCHAR2,
    X_DOC_LAST_UPDATE_DATE  in  DATE,
    X_CREATED_BY    in  NUMBER,
    X_LAST_UPDATED_BY  in  NUMBER,
    X_LAST_UPDATE_LOGIN	in NUMBER,
    X_UPDATE_SUMMARY in CLOB) is

  begin
    insert into FND_OAM_METALINK_DOCS (
      doc_id,
      title,
      doc_last_update_date,
      created_by,
      creation_date,
      last_update_date,
      last_updated_by,
      last_update_login,
      update_summary,
      doc_last_update_detected_date
    ) values (
      X_DOC_ID,
      X_TITLE,
      X_DOC_LAST_UPDATE_DATE,
      X_CREATED_BY,
      sysdate,
      sysdate,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN,
      X_UPDATE_SUMMARY,
      sysdate);

Line: 106

end INSERT_ROW;