APPS.AMS_CPAG_QUERY_USAGES_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out VARCHAR2,
  X_QUERY_USAGE_ID in NUMBER,
  X_QUERY_USED_BY_TYPE in VARCHAR2,
  X_QUERY_USED_BY_ID in NUMBER,
  X_QUERY_ID 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,
  X_OBJECT_VERSION_NUMBER in NUMBER
) is
  cursor C is select ROWID from AMS_CPAG_QUERY_USAGES
    where QUERY_USAGE_ID = X_QUERY_USAGE_ID
    ;

Line: 20

  insert into AMS_CPAG_QUERY_USAGES (
    QUERY_USAGE_ID,
    QUERY_USED_BY_TYPE,
    QUERY_USED_BY_ID,
    QUERY_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER
  ) values (
    X_QUERY_USAGE_ID,
    X_QUERY_USED_BY_TYPE,
    X_QUERY_USED_BY_ID,
    X_QUERY_ID,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_OBJECT_VERSION_NUMBER
  );

Line: 52

end INSERT_ROW;

Line: 61

  cursor c is select
     OBJECT_VERSION_NUMBER
     ,QUERY_USED_BY_TYPE
     ,QUERY_USED_BY_ID
     ,QUERY_ID
    from AMS_CPAG_QUERY_USAGES
    where QUERY_USAGE_ID = X_QUERY_USAGE_ID
    for update of QUERY_USAGE_ID nowait;

Line: 76

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 98

procedure UPDATE_ROW (
  X_QUERY_USAGE_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_QUERY_USED_BY_TYPE in VARCHAR2,
  X_QUERY_USED_BY_ID in NUMBER,
  X_QUERY_ID in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AMS_CPAG_QUERY_USAGES set
    OBJECT_VERSION_NUMBER  = X_OBJECT_VERSION_NUMBER,
    QUERY_USED_BY_TYPE     = X_QUERY_USED_BY_TYPE,
    QUERY_USED_BY_ID       = X_QUERY_USED_BY_ID,
    QUERY_ID               = X_QUERY_ID,
    LAST_UPDATE_DATE       = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY        = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN      = X_LAST_UPDATE_LOGIN
  where QUERY_USAGE_ID     = X_QUERY_USAGE_ID;

Line: 122

end UPDATE_ROW;

Line: 124

procedure DELETE_ROW (
  X_QUERY_USAGE_ID in NUMBER
) is
begin
  delete from AMS_CPAG_QUERY_USAGES
  where QUERY_USAGE_ID = X_QUERY_USAGE_ID;

Line: 135

end DELETE_ROW;

Line: 151

  select object_version_number
  from   AMS_CPAG_QUERY_USAGES
  where  query_usage_id =  X_QUERY_USAGE_ID;

Line: 156

  select 'x'
  from   AMS_CPAG_QUERY_USAGES
  where  QUERY_USAGE_ID = X_QUERY_USAGE_ID;

Line: 174

    AMS_CPAG_QUERY_USAGES_PKG.INSERT_ROW(
       X_ROWID				         =>    l_row_id,
       X_QUERY_USAGE_ID          =>    X_QUERY_USAGE_ID,
       X_QUERY_USED_BY_TYPE      =>    X_QUERY_USED_BY_TYPE,
       X_QUERY_USED_BY_ID        =>    X_QUERY_USED_BY_ID,
       X_QUERY_ID                =>    X_QUERY_ID,
       X_CREATION_DATE           =>    SYSDATE,
       X_CREATED_BY              =>    l_user_id,
       X_LAST_UPDATE_DATE        =>    SYSDATE,
       X_LAST_UPDATED_BY         =>    l_user_id,
       X_LAST_UPDATE_LOGIN       =>    0,
       X_OBJECT_VERSION_NUMBER   =>    l_obj_verno
    );

Line: 192

   AMS_CPAG_QUERY_USAGES_PKG.UPDATE_ROW(
       X_QUERY_USAGE_ID          =>    X_QUERY_USAGE_ID,
       X_QUERY_USED_BY_TYPE      =>    X_QUERY_USED_BY_TYPE,
       X_QUERY_USED_BY_ID        =>    X_QUERY_USED_BY_ID,
       X_QUERY_ID                =>    X_QUERY_ID,
       X_LAST_UPDATE_DATE        =>    SYSDATE,
       X_LAST_UPDATED_BY         =>    l_user_id,
       X_LAST_UPDATE_LOGIN       =>    0,
       X_OBJECT_VERSION_NUMBER   =>    l_obj_verno + 1
   );