APPS.AMS_IMP_COL_MAPPING_PKG SQL Statements

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

Line: 7

procedure INSERT_ROW (
  X_ROWID in OUT NOCOPY VARCHAR2,
  X_COL_MAPPING_ID in NUMBER,
  X_TABLE_NAME in VARCHAR2,
  X_COLUMN_NAME in VARCHAR2,
  X_MEANING in VARCHAR2,
  X_REQUIRED_FLAG in VARCHAR2,
  X_TARGET_TABLE_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
begin
  insert into AMS_IMP_COL_MAPPING (
    TABLE_NAME,
    COLUMN_NAME,
    MEANING,
    REQUIRED_FLAG,
    TARGET_TABLE_NAME,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    COL_MAPPING_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY
  )
   values
  (
    X_TABLE_NAME,
    X_COLUMN_NAME,
    X_MEANING,
    X_REQUIRED_FLAG,
    X_TARGET_TABLE_NAME,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_COL_MAPPING_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY
  );

Line: 50

end INSERT_ROW;

Line: 60

  cursor c1 is select
      TABLE_NAME,
      COLUMN_NAME,
      MEANING,
      REQUIRED_FLAG,
      TARGET_TABLE_NAME,
      COL_MAPPING_ID
    from AMS_IMP_COL_MAPPING
    where COL_MAPPING_ID = X_COL_MAPPING_ID
    for update of COL_MAPPING_ID nowait;

Line: 89

procedure UPDATE_ROW (
  X_COL_MAPPING_ID in NUMBER,
  X_TABLE_NAME in VARCHAR2,
  X_COLUMN_NAME in VARCHAR2,
  X_MEANING in VARCHAR2,
  X_REQUIRED_FLAG in VARCHAR2,
  X_TARGET_TABLE_NAME in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AMS_IMP_COL_MAPPING set
    TABLE_NAME = X_TABLE_NAME,
    COLUMN_NAME = X_COLUMN_NAME,
    MEANING = X_MEANING,
    REQUIRED_FLAG = X_REQUIRED_FLAG,
    TARGET_TABLE_NAME = X_TARGET_TABLE_NAME,
    COL_MAPPING_ID = X_COL_MAPPING_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where COL_MAPPING_ID = X_COL_MAPPING_ID;

Line: 116

end UPDATE_ROW;

Line: 118

procedure DELETE_ROW (
  X_COL_MAPPING_ID in NUMBER
) is
begin
  delete from AMS_IMP_COL_MAPPING
  where COL_MAPPING_ID = X_COL_MAPPING_ID;

Line: 129

end DELETE_ROW;

Line: 141

  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
  ) IS

l_user_id number := 0;

Line: 153

  select 'x'
  from   AMS_IMP_COL_MAPPING
  where  COL_MAPPING_ID = X_COL_MAPPING_ID;

Line: 158

  select AMS_IMP_COL_MAPPING_s.nextval
  from dual;

Line: 178

                 AMS_IMP_COL_MAPPING_PKG.INSERT_ROW (
  			X_ROWID            => l_row_id,
  			X_COL_MAPPING_ID   => X_COL_MAPPING_ID,
  			X_TABLE_NAME       => X_TABLE_NAME,
  			X_COLUMN_NAME      => X_COLUMN_NAME,
  			X_MEANING          => X_MEANING,
  			X_REQUIRED_FLAG    => X_REQUIRED_FLAG,
  			X_TARGET_TABLE_NAME  => X_TARGET_TABLE_NAME,
  			X_CREATION_DATE    => X_CREATION_DATE , -- sysdate,
  			X_CREATED_BY       => l_user_id,
  			X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE, -- sysdate,
  			X_LAST_UPDATED_BY  => l_user_id,
  			X_LAST_UPDATE_LOGIN => 1);

Line: 196

                        AMS_IMP_COL_MAPPING_PKG.UPDATE_ROW (
  			X_COL_MAPPING_ID     => X_COL_MAPPING_ID,
  			X_TABLE_NAME         => X_TABLE_NAME,
  			X_COLUMN_NAME        => X_COLUMN_NAME,
  			X_MEANING            => X_MEANING ,
  			X_REQUIRED_FLAG      => X_REQUIRED_FLAG,
  			X_TARGET_TABLE_NAME  => X_TARGET_TABLE_NAME,
  			X_LAST_UPDATE_DATE   => X_LAST_UPDATE_DATE, -- sysdate,
  			X_LAST_UPDATED_BY    => l_user_id,
  			X_LAST_UPDATE_LOGIN  => 1
			);