APPS.FEM_IMPEXP_AM_LOOKUP_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_OBJECT_TYPE_CODE in VARCHAR2,
  X_AM_NAME in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from FEM_IMPEXP_AM_LOOKUP
    where OBJECT_TYPE_CODE = X_OBJECT_TYPE_CODE
    ;

Line: 17

  insert into FEM_IMPEXP_AM_LOOKUP(
    OBJECT_TYPE_CODE,
    AM_NAME,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
  ) values
  (
    X_OBJECT_TYPE_CODE,
    X_AM_NAME,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN
  );

Line: 44

end INSERT_ROW;

Line: 46

procedure UPDATE_ROW (
  X_OBJECT_TYPE_CODE in VARCHAR2,
  X_AM_NAME in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update FEM_IMPEXP_AM_LOOKUP set
    AM_NAME = X_AM_NAME,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where OBJECT_TYPE_CODE = X_OBJECT_TYPE_CODE;

Line: 64

end UPDATE_ROW;

Line: 66

procedure DELETE_ROW (
  X_OBJECT_TYPE_CODE in VARCHAR2
) is
begin
  delete from FEM_IMPEXP_AM_LOOKUP
  where OBJECT_TYPE_CODE = X_OBJECT_TYPE_CODE;

Line: 77

end DELETE_ROW;

Line: 83

  X_LAST_UPDATE_DATE in VARCHAR2,
  X_CUSTOM_MODE in VARCHAR2) is

        row_id varchar2(64);

Line: 88

        f_ludate  date;    -- entity update date in file

Line: 90

        db_ludate date;    -- entity update date in db

Line: 101

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

Line: 103

          select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from FEM_IMPEXP_AM_LOOKUP
          where OBJECT_TYPE_CODE = X_OBJECT_TYPE_CODE;

Line: 117

            FEM_IMPEXP_AM_LOOKUP_PKG.UPDATE_ROW(
		  X_OBJECT_TYPE_CODE => X_OBJECT_TYPE_CODE,
		  X_AM_NAME => X_AM_NAME,
		  X_LAST_UPDATE_DATE => f_ludate,
                  X_LAST_UPDATED_BY => f_luby,
                  X_LAST_UPDATE_LOGIN => 0);

Line: 127

            FEM_IMPEXP_AM_LOOKUP_PKG.Insert_Row(
              X_ROWID => row_id,
              X_OBJECT_TYPE_CODE => X_OBJECT_TYPE_CODE,
              X_AM_NAME => X_AM_NAME,
              X_CREATION_DATE => f_ludate,
              X_CREATED_BY => f_luby,
              X_LAST_UPDATE_DATE => f_ludate,
              X_LAST_UPDATED_BY => f_luby,
              X_LAST_UPDATE_LOGIN => 0);