APPS.ASG_PUB_SEQUENCE_PKG SQL Statements

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

Line: 32

   Select client_number
   from ASG_USER
   where upper(user_name) = upper(v_clientid);

Line: 89

    v_statement := 'select nvl(max(' || x_primary_key ||
               '), '|| x_client_number ||
                  ') from '|| x_table_name ||
                  ' where MOD(' || x_primary_key || ',' || v_max_users ||
                     ') = '|| x_client_number;

Line: 125

        SELECT client_number
        FROM   ASG_USER
        WHERE  client_number > StartNum
        ORDER BY client_number;

Line: 130

        SELECT client_number
        FROM ASG_USER
        WHERE client_number =  StartNum;

Line: 134

        SELECT  MAX(Client_Number)
        FROM    ASG_USER;

Line: 215

procedure insert_row (
   x_SEQUENCE_ID in VARCHAR2,
  x_SEQUENCE_NAME in VARCHAR2,
  x_PUBLICATION_ID in VARCHAR2,
  x_B_SCHEMA in VARCHAR2,
  x_B_TABLE in VARCHAR2,
  x_B_COLUMN in VARCHAR2,
  x_MOBILE_VALUE in VARCHAR2,
  x_ENABLED    in VARCHAR2,
  x_STATUS     in VARCHAR2,
  x_CURRENT_RELEASE_VERSION in NUMBER,
  x_LAST_RELEASE_VERSION in NUMBER,
  x_CREATION_DATE in DATE,
  x_CREATED_BY in NUMBER,
  x_LAST_UPDATE_DATE in DATE,
  x_LAST_UPDATED_BY in NUMBER )
 is

   l_b_schema varchar2(30);

Line: 237

     select oracle_username into l_b_schema
       from fnd_oracle_userid
      where oracle_id = X_B_SCHEMA;

Line: 244

   insert into ASG_PUB_SEQUENCE (
    SEQUENCE_ID,
    SEQUENCE_NAME,
    PUBLICATION_ID,
    B_SCHEMA,
    B_TABLE,
    B_COLUMN,
    MOBILE_VALUE,
    ENABLED,
    STATUS,
    CURRENT_RELEASE_VERSION,
    LAST_RELEASE_VERSION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY
  ) values (
    decode(x_SEQUENCE_ID,FND_API.G_MISS_CHAR, NULL, x_SEQUENCE_ID),
    decode(x_SEQUENCE_NAME,FND_API.G_MISS_CHAR, NULL, x_SEQUENCE_NAME),
    decode(x_PUBLICATION_ID,FND_API.G_MISS_CHAR,NULL, x_PUBLICATION_ID),
    decode(l_B_SCHEMA,FND_API.G_MISS_CHAR, NULL, l_B_SCHEMA),
    decode(x_B_TABLE,FND_API.G_MISS_CHAR, NULL, x_B_TABLE),
    decode(x_B_COLUMN,FND_API.G_MISS_CHAR, NULL,x_B_COLUMN),
    decode(x_MOBILE_VALUE,FND_API.G_MISS_CHAR, NULL, x_MOBILE_VALUE),
    decode(x_ENABLED,FND_API.G_MISS_CHAR, NULL, x_ENABLED),
    'N',
    decode(x_CURRENT_RELEASE_VERSION,FND_API.G_MISS_NUM, NULL,
            x_CURRENT_RELEASE_VERSION),
    0,
    decode(x_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_CREATION_DATE),
    decode(x_CREATED_BY,FND_API.G_MISS_NUM, NULL, x_CREATED_BY),
    decode(x_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL,
                  x_LAST_UPDATE_DATE),
    decode(x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
  );

Line: 280

END INSERT_ROW;

Line: 282

procedure update_row (
   x_SEQUENCE_ID in VARCHAR2,
  x_SEQUENCE_NAME in VARCHAR2,
  x_PUBLICATION_ID in VARCHAR2,
  x_B_SCHEMA in VARCHAR2,
  x_B_TABLE in VARCHAR2,
  x_B_COLUMN in VARCHAR2,
  x_MOBILE_VALUE in VARCHAR2,
  x_ENABLED    in VARCHAR2,
  x_STATUS     in VARCHAR2,
  x_CURRENT_RELEASE_VERSION in NUMBER,
  x_LAST_RELEASE_VERSION in NUMBER,
  x_CREATION_DATE in DATE,
  x_CREATED_BY in NUMBER,
  x_LAST_UPDATE_DATE in DATE,
  x_LAST_UPDATED_BY in NUMBER )
 is

  l_b_schema varchar2(30);

Line: 305

     select oracle_username into l_b_schema
       from fnd_oracle_userid
      where oracle_id = X_B_SCHEMA;

Line: 313

   update asg_pub_sequence set
     sequence_id = x_sequence_id,
     sequence_name = x_sequence_name,
     publication_id = x_publication_id,
     b_schema = l_b_schema,
     b_table = x_b_table,
     b_column = x_b_column,
     mobile_value = x_mobile_value,
     enabled = x_enabled,
--     status = x_status,
     current_release_version = x_current_release_version,
--     last_release_version = x_last_release_version,
--     CREATION_DATE = x_CREATION_DATE,
--     created_by = x_created_by,
     last_update_date = x_last_update_date,
     last_updated_by = x_last_updated_by
    where sequence_id = X_SEQUENCE_ID;

Line: 334

END UPDATE_ROW;

Line: 350

  x_LAST_UPDATE_DATE in DATE,
  x_LAST_UPDATED_BY in NUMBER,
  p_owner in VARCHAR2) IS

  l_user_id  number := 0;

Line: 362

   asg_pub_sequence_pkg.UPDATE_ROW (
    x_SEQUENCE_ID => x_SEQUENCE_ID,
    x_SEQUENCE_NAME => x_SEQUENCE_NAME,
    x_PUBLICATION_ID => x_PUBLICATION_ID,
    x_B_SCHEMA => x_B_SCHEMA,
    x_B_TABLE => x_B_TABLE,
    x_B_COLUMN => x_B_COLUMN,
    x_MOBILE_VALUE => x_MOBILE_VALUE,
    x_ENABLED => x_ENABLED,
    x_STATUS => x_STATUS,
    x_CURRENT_RELEASE_VERSION => x_CURRENT_RELEASE_VERSION,
    x_LAST_RELEASE_VERSIOn => x_LAST_RELEASE_VERSION,
    x_CREATION_DATE    => x_CREATION_DATE,
    x_CREATED_BY => x_CREATED_BY,
    x_LAST_UPDATE_DATE => sysdate,
    x_LAST_UPDATED_BY => l_USER_ID);

Line: 381

     asg_pub_sequence_pkg.insert_row (
    x_SEQUENCE_ID => x_SEQUENCE_ID,
    x_SEQUENCE_NAME => x_SEQUENCE_NAME,
    x_PUBLICATION_ID => x_PUBLICATION_ID,
    x_B_SCHEMA => x_B_SCHEMA,
    x_B_TABLE => x_B_TABLE,
    x_B_COLUMN => x_B_COLUMN,
    x_MOBILE_VALUE => x_MOBILE_VALUE,
    x_ENABLED => x_ENABLED,
    x_STATUS => x_STATUS,
    x_CURRENT_RELEASE_VERSION => x_CURRENT_RELEASE_VERSION,
    x_LAST_RELEASE_VERSIOn => x_LAST_RELEASE_VERSION,
    x_CREATION_DATE    => sysdate,
    x_CREATED_BY => l_user_id,
    x_LAST_UPDATE_DATE => sysdate,
    x_LAST_UPDATED_BY => l_USER_ID);