APPS.AMS_IMP_CONFIG_COMPONENTS_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_CONFIG_COMPONENT_ID in NUMBER,
  X_IMPORT_TYPE in VARCHAR2,
  X_COMPONENT_TYPE in VARCHAR2,
  X_IMPORT_MODULE in VARCHAR2,
  X_COMPONENT_NAME in VARCHAR2,
  X_ACCESS_ALLOWED in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  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_CONFIG_COMPONENTS (
    CREATION_DATE,
    IMPORT_TYPE,
    COMPONENT_TYPE,
    IMPORT_MODULE,
    COMPONENT_NAME,
    ACCESS_ALLOWED,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE,
    CONFIG_COMPONENT_ID,
    LAST_UPDATED_BY,
    OBJECT_VERSION_NUMBER)
    values
    (
    X_CREATION_DATE,
    X_IMPORT_TYPE,
    X_COMPONENT_TYPE,
    X_IMPORT_MODULE,
    X_COMPONENT_NAME,
    X_ACCESS_ALLOWED,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_LAST_UPDATE_DATE,
    X_CONFIG_COMPONENT_ID,
    X_LAST_UPDATED_BY,
    X_OBJECT_VERSION_NUMBER);

Line: 51

end INSERT_ROW;

Line: 62

  cursor c1 is select
      IMPORT_TYPE,
      COMPONENT_TYPE,
      IMPORT_MODULE,
      COMPONENT_NAME,
      ACCESS_ALLOWED,
      OBJECT_VERSION_NUMBER,
      CONFIG_COMPONENT_ID
    from AMS_IMP_CONFIG_COMPONENTS
    where CONFIG_COMPONENT_ID = X_CONFIG_COMPONENT_ID
    for update of CONFIG_COMPONENT_ID nowait;

Line: 92

procedure UPDATE_ROW (
  X_CONFIG_COMPONENT_ID in NUMBER,
  X_IMPORT_TYPE in VARCHAR2,
  X_COMPONENT_TYPE in VARCHAR2,
  X_IMPORT_MODULE in VARCHAR2,
  X_COMPONENT_NAME in VARCHAR2,
  X_ACCESS_ALLOWED in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AMS_IMP_CONFIG_COMPONENTS set
    IMPORT_TYPE = X_IMPORT_TYPE,
    COMPONENT_TYPE = X_COMPONENT_TYPE,
    IMPORT_MODULE = X_IMPORT_MODULE,
    COMPONENT_NAME = X_COMPONENT_NAME,
    ACCESS_ALLOWED = X_ACCESS_ALLOWED,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where CONFIG_COMPONENT_ID = X_CONFIG_COMPONENT_ID;

Line: 120

end UPDATE_ROW;

Line: 122

procedure DELETE_ROW (
  X_CONFIG_COMPONENT_ID in NUMBER
) is
begin
  delete from AMS_IMP_CONFIG_COMPONENTS
  where CONFIG_COMPONENT_ID = X_CONFIG_COMPONENT_ID;

Line: 133

end DELETE_ROW;

Line: 145

  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: 157

  select 'x'
  from   AMS_IMP_CONFIG_COMPONENTS
  where  CONFIG_COMPONENT_ID = X_CONFIG_COMPONENT_ID;

Line: 162

  select AMS_IMP_CONFIG_COMPONENTS_S.nextval
  from dual;

Line: 184

                 AMS_IMP_CONFIG_COMPONENTS_PKG.INSERT_ROW (
                        X_ROWID            => l_row_id,
                        X_CONFIG_COMPONENT_ID => X_CONFIG_COMPONENT_ID,
                        X_IMPORT_TYPE      => X_IMPORT_TYPE,
                        X_COMPONENT_TYPE   => X_COMPONENT_TYPE,
                        X_IMPORT_MODULE    => X_IMPORT_MODULE,
                        X_COMPONENT_NAME   => X_COMPONENT_NAME,
                        X_ACCESS_ALLOWED   => X_ACCESS_ALLOWED,
                        X_OBJECT_VERSION_NUMBER => l_obj_verno,
                        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 => 0);

Line: 202

                 AMS_IMP_CONFIG_COMPONENTS_PKG.UPDATE_ROW (
                        X_CONFIG_COMPONENT_ID => X_CONFIG_COMPONENT_ID,
                        X_IMPORT_TYPE      => X_IMPORT_TYPE,
                        X_COMPONENT_TYPE   => X_COMPONENT_TYPE,
                        X_IMPORT_MODULE    => X_IMPORT_MODULE,
                        X_COMPONENT_NAME   => X_COMPONENT_NAME,
                        X_ACCESS_ALLOWED   => X_ACCESS_ALLOWED,
                        X_OBJECT_VERSION_NUMBER => l_obj_verno,
                        X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE, -- sysdate,
                        X_LAST_UPDATED_BY  => l_user_id,
                        X_LAST_UPDATE_LOGIN => 1);