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_DATA_GROUPS_PKG SQL Statements

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

Line: 30


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    X_ORG_ID in NUMBER default NULL
  ) AS

/******************************************************
Created By : nigupta
Date Created By : 11-MAY-2000
Purpose : To Set Column Values
Know limitations, enhancements or remarks : None
Change History
Who             When            What


(reverse chronological order - newest change first)
********************************************************/

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     igs_pe_data_groups_all
      WHERE    rowid = x_rowid;

Line: 61


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

Line: 63


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

Line: 78


    IF (p_action = 'UPDATE') THEN
      new_references.creation_date := old_references.creation_date;

Line: 85


    new_references.last_update_date := x_last_update_date;

Line: 86


    new_references.last_updated_by := x_last_updated_by;

Line: 87


    new_references.last_update_login := x_last_update_login;

Line: 186


      SELECT   rowid
      FROM     igs_pe_data_groups_all
      WHERE    data_group_id = UPPER(X_data_group_id);

Line: 220


      SELECT   rowid
      FROM     igs_pe_data_groups_all
      WHERE    data_group = x_data_group
      and      ((l_rowid is null) or (rowid <> l_rowid));

Line: 245


   SELECT  closed_ind
   FROM    igs_pe_data_groups_all
   WHERE   data_group_id = cp_data_group;

Line: 276


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    X_ORG_ID in NUMBER default NULL
  ) AS

/******************************************************
Created By : nigupta
Date Created By : 11-MAY-2000
Purpose : To check Before DML
Know limitations, enhancements or remarks : None
Change History
Who             When            What


(reverse chronological order - newest change first)
 asbala          18-JUL-03        2885709, made l_rowid := null at the end of before_dml
********************************************************/

  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_data_group_id,
      x_data_group,
      x_description,
      x_lvl,
      x_lvl_description,
      x_closed_ind,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login ,
      x_org_id
    );

Line: 314


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      Null;

Line: 325


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

Line: 330


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
         -- Call all the procedures related to Before Insert.
      IF Get_PK_For_Validation (
                new_references.data_group_id)  THEN
               Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

Line: 340


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Constraints;

Line: 368


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      Null;

Line: 371


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

Line: 380


 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_DATA_GROUP_ID IN OUT NOCOPY NUMBER,
       x_DATA_GROUP IN VARCHAR2,
       x_DESCRIPTION IN VARCHAR2,
       x_LVL IN VARCHAR2,
       x_LVL_DESCRIPTION IN VARCHAR2,
       x_CLOSED_IND IN VARCHAR2,
      X_MODE in VARCHAR2 default 'R'  ,
       X_ORG_ID in NUMBER
  ) AS

/******************************************************
Created By : nigupta
Date Created By : 11-MAY-2000
Purpose : To insert row
Know limitations, enhancements or remarks : None
Change History
Who             When            What


(reverse chronological order - newest chanfe first)
********************************************************/

    cursor C is select ROWID from igs_pe_data_groups_all
             where                 DATA_GROUP_ID= X_DATA_GROUP_ID
;

Line: 407


     X_LAST_UPDATE_DATE DATE ;

Line: 408


     X_LAST_UPDATED_BY NUMBER ;

Line: 409


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 411


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 413


        X_LAST_UPDATED_BY := 1;

Line: 414


        X_LAST_UPDATE_LOGIN := 0;

Line: 416


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 417


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 420


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 421


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 430


Select IGS_PE_DATA_GROUPS_S.NEXTVAL into X_DATA_GROUP_ID From Dual;

Line: 433


                p_action=>'INSERT',
                x_rowid=>X_ROWID,
               x_data_group_id=>X_DATA_GROUP_ID,
               x_data_group=>X_DATA_GROUP,
               x_description=>X_DESCRIPTION,
               x_lvl=>X_LVL,
               x_lvl_description=>X_LVL_DESCRIPTION,
               x_closed_ind=>X_CLOSED_IND,
               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,
               x_org_id=>igs_ge_gen_003.get_org_id
);

Line: 448


     insert into igs_pe_data_groups_all (
                DATA_GROUP_ID
                ,DATA_GROUP
                ,DESCRIPTION
                ,LVL
                ,LVL_DESCRIPTION
                ,CLOSED_IND
                ,CREATION_DATE
                ,CREATED_BY
                ,LAST_UPDATE_DATE
                ,LAST_UPDATED_BY
                ,LAST_UPDATE_LOGIN,
                 ORG_ID
        ) values  (
                NEW_REFERENCES.DATA_GROUP_ID
                ,NEW_REFERENCES.DATA_GROUP
                ,NEW_REFERENCES.DESCRIPTION
                ,NEW_REFERENCES.LVL
                ,NEW_REFERENCES.LVL_DESCRIPTION
                ,NEW_REFERENCES.CLOSED_IND
                ,X_LAST_UPDATE_DATE
                ,X_LAST_UPDATED_BY
                ,X_LAST_UPDATE_DATE
                ,X_LAST_UPDATED_BY
                ,X_LAST_UPDATE_LOGIN,
              NEW_REFERENCES.ORG_ID
);

Line: 483


                p_action => 'INSERT' ,
                x_rowid => X_ROWID );

Line: 485


end INSERT_ROW;

Line: 510


   cursor c1 is select
      DATA_GROUP
,      DESCRIPTION
,      LVL
,      LVL_DESCRIPTION
,      CLOSED_IND
    from igs_pe_data_groups_all
    where ROWID = X_ROWID
    for update nowait;

Line: 524


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

Line: 546


 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_DATA_GROUP_ID IN NUMBER,
       x_DATA_GROUP IN VARCHAR2,
       x_DESCRIPTION IN VARCHAR2,
       x_LVL IN VARCHAR2,
       x_LVL_DESCRIPTION IN VARCHAR2,
       x_CLOSED_IND IN VARCHAR2,
      X_MODE in VARCHAR2 default 'R'
  ) AS

/******************************************************
Created By : nigupta
Date Created By : 11-MAY-2000
Purpose : To Update Row
Know limitations, enhancements or remarks : None
Change History
Who             When            What


(reverse chronological order - newest change first)
********************************************************/

     X_LAST_UPDATE_DATE DATE ;

Line: 570


     X_LAST_UPDATED_BY NUMBER ;

Line: 571


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 573


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 575


        X_LAST_UPDATED_BY := 1;

Line: 576


        X_LAST_UPDATE_LOGIN := 0;

Line: 578


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 579


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 582


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 583


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 592


                p_action=>'UPDATE',
                x_rowid=>X_ROWID,
               x_data_group_id=>X_DATA_GROUP_ID,
               x_data_group=>X_DATA_GROUP,
               x_description=>X_DESCRIPTION,
               x_lvl=>X_LVL,
               x_lvl_description=>X_LVL_DESCRIPTION,
               x_closed_ind=>X_CLOSED_IND,
               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: 606


   update igs_pe_data_groups_all set
      DATA_GROUP =  NEW_REFERENCES.DATA_GROUP,
      DESCRIPTION =  NEW_REFERENCES.DESCRIPTION,
      LVL =  NEW_REFERENCES.LVL,
      LVL_DESCRIPTION =  NEW_REFERENCES.LVL_DESCRIPTION,
      CLOSED_IND =  NEW_REFERENCES.CLOSED_IND,
        LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
        LAST_UPDATED_BY = X_LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
          where ROWID = X_ROWID;

Line: 621


        p_action => 'UPDATE' ,
        x_rowid => X_ROWID
        );

Line: 624


end UPDATE_ROW;

Line: 650


    cursor c1 is select ROWID from igs_pe_data_groups_all
             where     DATA_GROUP_ID= X_DATA_GROUP_ID
;

Line: 658


    INSERT_ROW (
      X_ROWID,
       X_DATA_GROUP_ID,
       X_DATA_GROUP,
       X_DESCRIPTION,
       X_LVL,
       X_LVL_DESCRIPTION,
       X_CLOSED_IND,
      X_MODE,
      x_org_id
 );

Line: 672


UPDATE_ROW (
      X_ROWID,
       X_DATA_GROUP_ID,
       X_DATA_GROUP,
       X_DESCRIPTION,
       X_LVL,
       X_LVL_DESCRIPTION,
       X_CLOSED_IND,
      X_MODE
);