APPS.BIS_FN_SAVE_FIELDS_PKG SQL Statements

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

Line: 16

procedure INSERT_ROW (
  X_ROWID in out VARCHAR2,
  X_FUNCTION_ID in NUMBER,
  X_FIELD in VARCHAR2,
  X_ATTRIBUTE_CODE 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
  cursor C is select ROWID from BIS_FN_SAVE_FIELDS
    where FUNCTION_ID = X_FUNCTION_ID
    and FIELD = X_FIELD
    ;

Line: 32

  insert into BIS_FN_SAVE_FIELDS (
    FIELD,
    FUNCTION_ID,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ATTRIBUTE_CODE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE
  ) values
(
    X_FIELD,
    X_FUNCTION_ID,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_ATTRIBUTE_CODE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE
);

Line: 60

end INSERT_ROW;

Line: 67

  cursor c1 is select
      ATTRIBUTE_CODE
    from BIS_FN_SAVE_FIELDS
    where FUNCTION_ID = X_FUNCTION_ID
    and FIELD = X_FIELD
    for update of FUNCTION_ID nowait;

Line: 86

procedure UPDATE_ROW (
  X_FUNCTION_ID in NUMBER,
  X_FIELD in VARCHAR2,
  X_ATTRIBUTE_CODE in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update BIS_FN_SAVE_FIELDS set
    ATTRIBUTE_CODE = X_ATTRIBUTE_CODE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where FUNCTION_ID = X_FUNCTION_ID
  and FIELD = X_FIELD;

Line: 106

end UPDATE_ROW;

Line: 108

procedure DELETE_ROW (
  X_FUNCTION_ID in NUMBER,
  X_FIELD in VARCHAR2
) is
begin
  delete from BIS_FN_SAVE_FIELDS
  where FUNCTION_ID = X_FUNCTION_ID
  and FIELD = X_FIELD;

Line: 121

end DELETE_ROW;