APPS.AMS_IMP_LIST_IMPORT_TYPES_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_IMPORT_TYPE_ID in NUMBER,
  X_IMPORT_TYPE in VARCHAR2,
  X_VIEW_NAME in VARCHAR2,
  X_B2B_FLAG in VARCHAR2,
  X_CONCURRENT_PROGRAM in VARCHAR2,
  X_WORKBOOK_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_LIST_IMPORT_TYPES (
    IMPORT_TYPE_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    IMPORT_TYPE,
    VIEW_NAME,
    B2B_FLAG,
    CONCURRENT_PROGRAM,
    WORKBOOK_NAME
  )
    values
  (
    X_IMPORT_TYPE_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_IMPORT_TYPE,
    X_VIEW_NAME,
    X_B2B_FLAG,
    X_CONCURRENT_PROGRAM,
    X_WORKBOOK_NAME
   );

Line: 50

end INSERT_ROW;

Line: 60

  cursor c1 is select
      import_type_id,
      IMPORT_TYPE,
      VIEW_NAME,
      B2B_FLAG,
      CONCURRENT_PROGRAM,
      WORKBOOK_NAME
    from AMS_IMP_LIST_IMPORT_TYPES
    where IMPORT_TYPE_ID = X_IMPORT_TYPE_ID
    for update of IMPORT_TYPE_ID nowait;

Line: 94

procedure UPDATE_ROW (
  X_IMPORT_TYPE_ID in NUMBER,
  X_IMPORT_TYPE in VARCHAR2,
  X_VIEW_NAME in VARCHAR2,
  X_B2B_FLAG in VARCHAR2,
  X_CONCURRENT_PROGRAM in VARCHAR2,
  X_WORKBOOK_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_LIST_IMPORT_TYPES set
    IMPORT_TYPE = X_IMPORT_TYPE,
    VIEW_NAME = X_VIEW_NAME,
    B2B_FLAG = X_B2B_FLAG,
    CONCURRENT_PROGRAM = X_CONCURRENT_PROGRAM,
    WORKBOOK_NAME = X_WORKBOOK_NAME,
    IMPORT_TYPE_ID = X_IMPORT_TYPE_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where IMPORT_TYPE_ID = X_IMPORT_TYPE_ID;

Line: 121

end UPDATE_ROW;

Line: 123

procedure DELETE_ROW (
  X_IMPORT_TYPE_ID in NUMBER
) is
begin
  delete from AMS_IMP_LIST_IMPORT_TYPES
  where IMPORT_TYPE_ID = X_IMPORT_TYPE_ID;

Line: 134

end DELETE_ROW;

Line: 146

  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_list_import_types
  where  IMPORT_TYPE_ID = X_IMPORT_TYPE_ID;

Line: 162

  select ams_imp_list_import_types_s.nextval
  from dual;

Line: 182

                 AMS_IMP_LIST_IMPORT_TYPES_PKG.INSERT_ROW (
			  X_ROWID => l_row_id,
  			  X_IMPORT_TYPE_ID => X_IMPORT_TYPE_ID,
  			  X_IMPORT_TYPE => X_IMPORT_TYPE,
  			  X_VIEW_NAME => X_VIEW_NAME,
  			  X_B2B_FLAG => X_B2B_FLAG,
  			  X_CONCURRENT_PROGRAM => X_CONCURRENT_PROGRAM,
  			  X_WORKBOOK_NAME => X_WORKBOOK_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: 199

                       AMS_IMP_LIST_IMPORT_TYPES_PKG.UPDATE_ROW (
                          X_IMPORT_TYPE_ID => X_IMPORT_TYPE_ID,
                          X_IMPORT_TYPE => X_IMPORT_TYPE,
                          X_VIEW_NAME => X_VIEW_NAME,
                          X_B2B_FLAG => X_B2B_FLAG,
                          X_CONCURRENT_PROGRAM => X_CONCURRENT_PROGRAM,
                          X_WORKBOOK_NAME => X_WORKBOOK_NAME,
                          X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE, -- sysdate,
                          X_LAST_UPDATED_BY => l_user_id,
                          X_LAST_UPDATE_LOGIN => 1);