APPS.AME_HELP_API SQL Statements

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

Line: 14

     select ROWID
     from AME_HELP
     where context = X_CONTEXT;

Line: 29

procedure INSERT_ROW (
 X_CONTEXT                         in VARCHAR2,
 X_FILE_NAME                       in VARCHAR2)
 is

begin
  insert into AME_HELP
  (
   CONTEXT,
   FILE_NAME
  ) values (
   X_CONTEXT,
   X_FILE_NAME
  );

Line: 44

end INSERT_ROW;

Line: 46

procedure UPDATE_ROW (
   X_HELP_ROWID                       in VARCHAR2,
   X_FILE_NAME                        in VARCHAR2)
 is
begin
  update AME_HELP set
    FILE_NAME  = X_FILE_NAME
   where ROWID = X_HELP_ROWID;

Line: 55

end UPDATE_ROW;

Line: 57

procedure DELETE_ROW (
  X_CONTEXT   in VARCHAR2,
  X_FILE_NAME in VARCHAR2
) is
begin
  delete from AME_HELP
  where CONTEXT   = X_CONTEXT
    and FILE_NAME = X_FILE_NAME;

Line: 70

end DELETE_ROW;

Line: 79

  X_LAST_UPDATE_DATE DATE;

Line: 80

  X_LAST_UPDATED_BY NUMBER;

Line: 81

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 89

      INSERT_ROW (
       X_CONTEXT,
       X_FILE_NAME);

Line: 93

       UPDATE_ROW (
       X_HELP_ROWID,
       X_FILE_NAME
       );