eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_PERSID_GROUP_PKG SQL Statements

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

Line: 103


    x_last_update_date IN DATE DEFAULT NULL,

    x_last_updated_by IN NUMBER DEFAULT NULL,

    x_last_update_login IN NUMBER DEFAULT NULL

  ) AS



    CURSOR cur_old_ref_values IS

      SELECT   *

      FROM     IGS_PE_PERSID_GROUP_ALL

      WHERE    rowid = x_rowid;

Line: 139


    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN

      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 197


    IF (p_action = 'UPDATE') THEN

      new_references.creation_date := old_references.creation_date;

Line: 211


    new_references.last_update_date := x_last_update_date;

Line: 213


    new_references.last_updated_by := x_last_updated_by;

Line: 215


    new_references.last_update_login := x_last_update_login;

Line: 307


     Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 327


      SELECT   rowid

      FROM     IGS_PE_PERSID_GROUP_ALL

      WHERE    group_id = x_group_id;

Line: 373


      SELECT   rowid
      FROM     igs_pe_persid_group_all
      WHERE   group_cd = x_group_cd  AND
       ((l_rowid is null) or (rowid <> l_rowid))    ;

Line: 399


   SELECT  closed_ind
   FROM    igs_pe_persid_group_all
   WHERE   group_id = cp_group_id;

Line: 431


      SELECT   rowid

      FROM     IGS_PE_PERSID_GROUP_ALL

      WHERE    creator_person_id = x_person_id ;

Line: 520


    x_last_update_date IN DATE DEFAULT NULL,

    x_last_updated_by IN NUMBER DEFAULT NULL,

    x_last_update_login IN NUMBER DEFAULT NULL

  ) AS
CURSOR is_creator_deceased IS SELECT deceased_ind FROM igs_pe_hz_parties WHERE party_id = x_creator_person_id;

Line: 528


CURSOR is_creator_too_young IS SELECT date_of_birth FROM HZ_PERSON_PROFILES where party_id = x_creator_person_id AND effective_end_date IS NULL;

Line: 585


      x_last_update_date,

      x_last_updated_by,

      x_last_update_login

    );

Line: 594


 IF (p_action in ('INSERT','UPDATE')) THEN
  OPEN is_creator_deceased; FETCH is_creator_deceased INTO l_deceased_ind; CLOSE is_creator_deceased;

Line: 608


 IF (p_action = 'INSERT') THEN
       -- Call all the procedures related to Before Insert.
   IF  Get_PK_For_Validation (
     new_references.group_id ) THEN
     Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 619


 ELSIF (p_action = 'UPDATE') THEN
 -- Call all the procedures related to Before Update.
   check_uniqueness;

Line: 624


 ELSIF (p_action = 'VALIDATE_INSERT') THEN
   IF  Get_PK_For_Validation (
     new_references.group_id ) THEN
     Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 632


 ELSIF (p_action = 'VALIDATE_UPDATE') THEN
   check_uniqueness;

Line: 657


    IF (p_action = 'INSERT') THEN

      -- Call all the procedures related to After Insert.

      Null;

Line: 663


    ELSIF (p_action = 'UPDATE') THEN

      -- Call all the procedures related to After Update.

      Null;

Line: 674


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_GROUP_ID in NUMBER,
  X_GROUP_CD in VARCHAR2,
  X_CREATOR_PERSON_ID in NUMBER,
  X_DESCRIPTION in VARCHAR2,
  X_CREATE_DT in DATE,
  X_CLOSED_IND in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  X_FILE_NAME           in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE_CATEGORY  in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE1          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE2          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE3          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE4          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE5          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE6          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE7          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE8          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE9          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE10         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE11         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE12         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE13         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE14         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE15         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE16         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE17         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE18         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE19         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE20         in      VARCHAR2 DEFAULT NULL,
  X_ORG_ID in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_PE_PERSID_GROUP_ALL
      where GROUP_ID = X_GROUP_ID;

Line: 710


    X_LAST_UPDATE_DATE DATE;

Line: 711


    X_LAST_UPDATED_BY NUMBER;

Line: 712


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 720


    X_PROGRAM_UPDATE_DATE DATE;

Line: 723


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 725


    X_LAST_UPDATED_BY := 1;

Line: 726


    X_LAST_UPDATE_LOGIN := 0;

Line: 728


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 729


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 732


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 733


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 753


     X_PROGRAM_UPDATE_DATE := NULL;

Line: 757


     X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 768


  p_action=>'INSERT',

  x_rowid=>X_ROWID,

  x_closed_ind=> NVL(X_CLOSED_IND,'N'),

  x_comments=>X_COMMENTS,

  x_create_dt=>X_CREATE_DT,

  x_creator_person_id=>X_CREATOR_PERSON_ID,

  x_description=>X_DESCRIPTION,

  x_group_cd=>X_GROUP_CD,

  x_group_id=>X_GROUP_ID,

  x_file_name          => X_FILE_NAME,
  x_attribute_category => X_ATTRIBUTE_CATEGORY,
  x_attribute1         => X_ATTRIBUTE1,
  x_attribute2         => X_ATTRIBUTE2,
  x_attribute3         => X_ATTRIBUTE3,
  x_attribute4         => X_ATTRIBUTE4,
  x_attribute5         => X_ATTRIBUTE5,
  x_attribute6         => X_ATTRIBUTE6,
  x_attribute7         => X_ATTRIBUTE7,
  x_attribute8         => X_ATTRIBUTE8,
  x_attribute9         => X_ATTRIBUTE9,
  x_attribute10        => X_ATTRIBUTE10,
  x_attribute11        => X_ATTRIBUTE11,
  x_attribute12        => X_ATTRIBUTE12,
  x_attribute13        => X_ATTRIBUTE13,
  x_attribute14        => X_ATTRIBUTE14,
  x_attribute15        => X_ATTRIBUTE15,
  x_attribute16        => X_ATTRIBUTE16,
  x_attribute17        => X_ATTRIBUTE17,
  x_attribute18        => X_ATTRIBUTE18,
  x_attribute19        => X_ATTRIBUTE19,
  x_attribute20        => X_ATTRIBUTE20,


  x_org_id => igs_ge_gen_003.get_org_id,

  x_creation_date=>X_LAST_UPDATE_DATE,

  x_created_by=>X_LAST_UPDATED_BY,

  x_last_update_date=>X_LAST_UPDATE_DATE,

  x_last_updated_by=>X_LAST_UPDATED_BY,

  x_last_update_login=>X_LAST_UPDATE_LOGIN

  );

Line: 823


  insert into IGS_PE_PERSID_GROUP_ALL (
    GROUP_ID,
    GROUP_CD,
    CREATOR_PERSON_ID,
    DESCRIPTION,
    CREATE_DT,
    CLOSED_IND,
    COMMENTS,
    FILE_NAME,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1  ,
    ATTRIBUTE2  ,
    ATTRIBUTE3  ,
    ATTRIBUTE4  ,
    ATTRIBUTE5  ,
    ATTRIBUTE6  ,
    ATTRIBUTE7  ,
    ATTRIBUTE8  ,
    ATTRIBUTE9  ,
    ATTRIBUTE10 ,
    ATTRIBUTE11 ,
    ATTRIBUTE12 ,
    ATTRIBUTE13 ,
    ATTRIBUTE14 ,
    ATTRIBUTE15 ,
    ATTRIBUTE16 ,
    ATTRIBUTE17 ,
    ATTRIBUTE18 ,
    ATTRIBUTE19 ,
    ATTRIBUTE20 ,
    ORG_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,

    REQUEST_ID,

    PROGRAM_ID,

    PROGRAM_APPLICATION_ID,

    PROGRAM_UPDATE_DATE

  ) values (
    NEW_REFERENCES.GROUP_ID,
    NEW_REFERENCES.GROUP_CD,
    NEW_REFERENCES.CREATOR_PERSON_ID,
    NEW_REFERENCES.DESCRIPTION,
    NEW_REFERENCES.CREATE_DT,
    NEW_REFERENCES.CLOSED_IND,
    NEW_REFERENCES.COMMENTS,
    NEW_REFERENCES.FILE_NAME,
    NEW_REFERENCES.ATTRIBUTE_CATEGORY,
    NEW_REFERENCES.ATTRIBUTE1  ,
    NEW_REFERENCES.ATTRIBUTE2  ,
    NEW_REFERENCES.ATTRIBUTE3  ,
    NEW_REFERENCES.ATTRIBUTE4  ,
    NEW_REFERENCES.ATTRIBUTE5  ,
    NEW_REFERENCES.ATTRIBUTE6  ,
    NEW_REFERENCES.ATTRIBUTE7  ,
    NEW_REFERENCES.ATTRIBUTE8  ,
    NEW_REFERENCES.ATTRIBUTE9  ,
    NEW_REFERENCES.ATTRIBUTE10 ,
    NEW_REFERENCES.ATTRIBUTE11 ,
    NEW_REFERENCES.ATTRIBUTE12 ,
    NEW_REFERENCES.ATTRIBUTE13 ,
    NEW_REFERENCES.ATTRIBUTE14 ,
    NEW_REFERENCES.ATTRIBUTE15 ,
    NEW_REFERENCES.ATTRIBUTE16 ,
    NEW_REFERENCES.ATTRIBUTE17 ,
    NEW_REFERENCES.ATTRIBUTE18 ,
    NEW_REFERENCES.ATTRIBUTE19 ,
    NEW_REFERENCES.ATTRIBUTE20 ,
    NEW_REFERENCES.ORG_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,

    X_REQUEST_ID,

    X_PROGRAM_ID,

    X_PROGRAM_APPLICATION_ID,

    X_PROGRAM_UPDATE_DATE
  );

Line: 923


  p_action => 'INSERT',

  x_rowid => X_ROWID

  );

Line: 928


end INSERT_ROW;

Line: 963


  cursor c1 is select
      GROUP_CD,
      CREATOR_PERSON_ID,
      DESCRIPTION,
      CREATE_DT,
      CLOSED_IND,
      COMMENTS,
      FILE_NAME,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20
    from IGS_PE_PERSID_GROUP_ALL
    where ROWID = X_ROWID
    for update nowait;

Line: 1001


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

Line: 1049


procedure UPDATE_ROW (

  X_ROWID in VARCHAR2,
  X_GROUP_ID in NUMBER,
  X_GROUP_CD in VARCHAR2,
  X_CREATOR_PERSON_ID in NUMBER,
  X_DESCRIPTION in VARCHAR2,
  X_CREATE_DT in DATE,
  X_CLOSED_IND in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  X_FILE_NAME           in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE_CATEGORY  in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE1          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE2          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE3          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE4          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE5          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE6          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE7          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE8          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE9          in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE10         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE11         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE12         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE13         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE14         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE15         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE16         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE17         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE18         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE19         in      VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE20         in      VARCHAR2 DEFAULT NULL,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 1084


    X_LAST_UPDATED_BY NUMBER;

Line: 1085


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 1093


    X_PROGRAM_UPDATE_DATE DATE;

Line: 1095


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 1097


    X_LAST_UPDATED_BY := 1;

Line: 1098


    X_LAST_UPDATE_LOGIN := 0;

Line: 1100


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1101


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 1104


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 1105


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 1116


  p_action=>'UPDATE',

  x_rowid=>X_ROWID,

  x_closed_ind=>X_CLOSED_IND,

  x_comments=>X_COMMENTS,

  x_create_dt=>X_CREATE_DT,

  x_creator_person_id=>X_CREATOR_PERSON_ID,

  x_description=>X_DESCRIPTION,

  x_group_cd=>X_GROUP_CD,

  x_group_id=>X_GROUP_ID,

  x_file_name          => X_FILE_NAME,

  x_attribute_category => X_ATTRIBUTE_CATEGORY,
  x_attribute1         => X_ATTRIBUTE1,
  x_attribute2         => X_ATTRIBUTE2,
  x_attribute3         => X_ATTRIBUTE3,
  x_attribute4         => X_ATTRIBUTE4,
  x_attribute5         => X_ATTRIBUTE5,
  x_attribute6         => X_ATTRIBUTE6,
  x_attribute7         => X_ATTRIBUTE7,
  x_attribute8         => X_ATTRIBUTE8,
  x_attribute9         => X_ATTRIBUTE9,
  x_attribute10        => X_ATTRIBUTE10,
  x_attribute11        => X_ATTRIBUTE11,
  x_attribute12        => X_ATTRIBUTE12,
  x_attribute13        => X_ATTRIBUTE13,
  x_attribute14        => X_ATTRIBUTE14,
  x_attribute15        => X_ATTRIBUTE15,
  x_attribute16        => X_ATTRIBUTE16,
  x_attribute17        => X_ATTRIBUTE17,
  x_attribute18        => X_ATTRIBUTE18,
  x_attribute19        => X_ATTRIBUTE19,
  x_attribute20        => X_ATTRIBUTE20,


  x_creation_date=>X_LAST_UPDATE_DATE,

  x_created_by=>X_LAST_UPDATED_BY,

  x_last_update_date=>X_LAST_UPDATE_DATE,

  x_last_updated_by=>X_LAST_UPDATED_BY,

  x_last_update_login=>X_LAST_UPDATE_LOGIN

  );

Line: 1189


     X_PROGRAM_UPDATE_DATE :=

                  OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 1195


     X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 1202


  update IGS_PE_PERSID_GROUP_ALL set
    GROUP_CD = NEW_REFERENCES.GROUP_CD,
    CREATOR_PERSON_ID = NEW_REFERENCES.CREATOR_PERSON_ID,
    DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
    CREATE_DT = NEW_REFERENCES.CREATE_DT,
    CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
    COMMENTS = NEW_REFERENCES.COMMENTS,
    FILE_NAME = NEW_REFERENCES.FILE_NAME,
    ATTRIBUTE_CATEGORY = NEW_REFERENCES.ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = NEW_REFERENCES.ATTRIBUTE1,
    ATTRIBUTE2 = NEW_REFERENCES.ATTRIBUTE2,
    ATTRIBUTE3 = NEW_REFERENCES.ATTRIBUTE3,
    ATTRIBUTE4 = NEW_REFERENCES.ATTRIBUTE4,
    ATTRIBUTE5 = NEW_REFERENCES.ATTRIBUTE5,
    ATTRIBUTE6 = NEW_REFERENCES.ATTRIBUTE6,
    ATTRIBUTE7 = NEW_REFERENCES.ATTRIBUTE7,
    ATTRIBUTE8 = NEW_REFERENCES.ATTRIBUTE8,
    ATTRIBUTE9 = NEW_REFERENCES.ATTRIBUTE9,
    ATTRIBUTE10 = NEW_REFERENCES.ATTRIBUTE10,
    ATTRIBUTE11 = NEW_REFERENCES.ATTRIBUTE11,
    ATTRIBUTE12 = NEW_REFERENCES.ATTRIBUTE12,
    ATTRIBUTE13 = NEW_REFERENCES.ATTRIBUTE13,
    ATTRIBUTE14 = NEW_REFERENCES.ATTRIBUTE14,
    ATTRIBUTE15 = NEW_REFERENCES.ATTRIBUTE15,
    ATTRIBUTE16 = NEW_REFERENCES.ATTRIBUTE16,
    ATTRIBUTE17 = NEW_REFERENCES.ATTRIBUTE17,
    ATTRIBUTE18 = NEW_REFERENCES.ATTRIBUTE18,
    ATTRIBUTE19 = NEW_REFERENCES.ATTRIBUTE19,
    ATTRIBUTE20 = NEW_REFERENCES.ATTRIBUTE20,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

    REQUEST_ID = X_REQUEST_ID,

    PROGRAM_ID = X_PROGRAM_ID,

    PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,

    PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE

  where ROWID = X_ROWID
  ;

Line: 1251


  p_action => 'UPDATE',

  x_rowid => X_ROWID

  );

Line: 1256


end UPDATE_ROW;

Line: 1292


  cursor c1 is select rowid from IGS_PE_PERSID_GROUP_ALL
     where GROUP_ID = X_GROUP_ID
  ;

Line: 1301


    INSERT_ROW (
     X_ROWID,
     X_GROUP_ID,
     X_GROUP_CD,
     X_CREATOR_PERSON_ID,
     X_DESCRIPTION,
     X_CREATE_DT,
     X_CLOSED_IND,
     X_COMMENTS,
    X_FILE_NAME,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_ATTRIBUTE16,
    X_ATTRIBUTE17,
    X_ATTRIBUTE18,
    X_ATTRIBUTE19,
    X_ATTRIBUTE20,
     x_org_id,
     X_MODE);

Line: 1337


  UPDATE_ROW (

   X_ROWID,
   X_GROUP_ID,
   X_GROUP_CD,
   X_CREATOR_PERSON_ID,
   X_DESCRIPTION,
   X_CREATE_DT,
   X_CLOSED_IND,
   X_COMMENTS,
    X_FILE_NAME,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_ATTRIBUTE16,
    X_ATTRIBUTE17,
    X_ATTRIBUTE18,
    X_ATTRIBUTE19,
    X_ATTRIBUTE20,
   X_MODE);