APPS.AME_FIELD_HELP_API SQL Statements

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

Line: 17

     select ROWID
     from AME_FIELD_HELP
     where FIELD_NAME    = X_FIELD_NAME
      and PROCEDURE_NAME = X_PROCEDURE_NAME
      and PACKAGE_NAME   = X_PACKAGE_NAME;

Line: 36

procedure INSERT_ROW (
 X_FIELD_NAME                      in VARCHAR2,
 X_PROCEDURE_NAME                  in VARCHAR2,
 X_PACKAGE_NAME                    in VARCHAR2,
 X_HELP_TEXT                       in VARCHAR2)
 is

begin
  insert into AME_FIELD_HELP
  (
   FIELD_NAME,
   PROCEDURE_NAME,
   PACKAGE_NAME,
   HELP_TEXT
  ) values (
   X_FIELD_NAME,
   X_PROCEDURE_NAME,
   X_PACKAGE_NAME,
   X_HELP_TEXT
  );

Line: 57

end INSERT_ROW;

Line: 59

procedure UPDATE_ROW (
        X_FIELD_HELP_ROWID                in VARCHAR2,
        X_HELP_TEXT                       in VARCHAR2)
 is
begin
  update AME_FIELD_HELP set
    HELP_TEXT            = X_HELP_TEXT
   where ROWID           = X_FIELD_HELP_ROWID;

Line: 67

end UPDATE_ROW;

Line: 69

procedure DELETE_ROW (
  X_FIELD_NAME      in VARCHAR2,
  X_PROCEDURE_NAME  in VARCHAR2,
  X_PACKAGE_NAME    in VARCHAR2
) is
begin
  delete from AME_FIELD_HELP
  where FIELD_NAME     = X_FIELD_NAME
      and PROCEDURE_NAME = X_PROCEDURE_NAME
      and PACKAGE_NAME   = X_PACKAGE_NAME;

Line: 83

end DELETE_ROW;

Line: 94

  X_LAST_UPDATE_DATE DATE;

Line: 95

  X_LAST_UPDATED_BY NUMBER;

Line: 96

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 106

      INSERT_ROW (
        X_FIELD_NAME,
        X_PROCEDURE_NAME,
        X_PACKAGE_NAME,
        X_HELP_TEXT);

Line: 112

      UPDATE_ROW (
        X_FIELD_HELP_ROWID,
        X_HELP_TEXT);