APPS.AMS_CPAG_QUERIES_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_ID in NUMBER,
  X_QUERY_TEXT in VARCHAR2,
  X_UPLOAD_DATE in DATE,
  X_EXPIRATION_DATE in DATE,
  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_QUERIES
    where QUERY_ID = X_QUERY_ID
    ;

Line: 20

  insert into AMS_CPAG_QUERIES (
    QUERY_ID,
    QUERY_TEXT,
    UPLOAD_DATE,
    EXPIRATION_DATE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER
  ) values (
    X_QUERY_ID,
    X_QUERY_TEXT,
    X_UPLOAD_DATE,
    X_EXPIRATION_DATE,
    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_TEXT
     ,UPLOAD_DATE
     ,EXPIRATION_DATE
    from AMS_CPAG_QUERIES
    where QUERY_ID = X_QUERY_ID
    for update of QUERY_ID nowait;

Line: 76

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

Line: 98

procedure UPDATE_ROW (
  X_QUERY_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_QUERY_TEXT in VARCHAR2,
  X_UPLOAD_DATE in DATE,
  X_EXPIRATION_DATE in DATE,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AMS_CPAG_QUERIES set
    OBJECT_VERSION_NUMBER  = X_OBJECT_VERSION_NUMBER,
    QUERY_TEXT             = X_QUERY_TEXT,
    UPLOAD_DATE            = X_UPLOAD_DATE,
    EXPIRATION_DATE        = X_EXPIRATION_DATE,
    LAST_UPDATE_DATE       = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY        = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN      = X_LAST_UPDATE_LOGIN
  where QUERY_ID           = X_QUERY_ID;

Line: 122

end UPDATE_ROW;

Line: 124

procedure DELETE_ROW (
  X_QUERY_ID in NUMBER
) is
begin
  delete from AMS_CPAG_QUERIES
  where QUERY_ID = X_QUERY_ID;

Line: 135

end DELETE_ROW;

Line: 151

  select object_version_number
  from   AMS_CPAG_QUERIES
  where  query_id =  X_QUERY_ID;

Line: 156

  select 'x'
  from   AMS_CPAG_QUERIES
  where  QUERY_ID = X_QUERY_ID;

Line: 174

    AMS_CPAG_QUERIES_PKG.INSERT_ROW(
       X_ROWID				         =>    l_row_id,
       X_QUERY_ID				      =>    X_QUERY_ID,
       X_QUERY_TEXT  		      =>    X_QUERY_TEXT,
       X_UPLOAD_DATE             =>    X_UPLOAD_DATE,
       X_EXPIRATION_DATE         =>    X_EXPIRATION_DATE,
       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_QUERIES_PKG.UPDATE_ROW(
       X_QUERY_ID                =>    X_QUERY_ID,
       X_QUERY_TEXT              =>    X_QUERY_TEXT,
       X_UPLOAD_DATE             =>    X_UPLOAD_DATE,
       X_EXPIRATION_DATE         =>    X_EXPIRATION_DATE,
       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
   );