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

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

Line: 41


    x_last_update_date IN DATE  ,
    x_last_updated_by IN NUMBER  ,
    x_last_update_login IN NUMBER ,
    x_closed_ind IN VARCHAR2
  ) AS

  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  sraj		17-MAY-2000	Two columns have been added to this table.
  (reverse chronological order - newest change first)
  ***************************************************************/

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

Line: 71


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

Line: 73


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

Line: 91


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

Line: 98


    new_references.last_update_date := x_last_update_date;

Line: 99


    new_references.last_updated_by := x_last_updated_by;

Line: 100


    new_references.last_update_login := x_last_update_login;

Line: 104


  PROCEDURE BeforeRowInsertUpdate1(
    p_inserting IN BOOLEAN ,
    p_updating IN BOOLEAN ,
    p_deleting IN BOOLEAN
    ) AS

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


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

v_message_name  varchar2(30);

Line: 136


  END BeforeRowInsertUpdate1;

Line: 246


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

Line: 258


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

Line: 279


						If the childs are present then the person_id_type can not be deleted since the child alternate person I can only
						be end dated. Hence no need to lock the records.
(reverse chronological order - newest change first)
********************************************************/
       --Cursor to check the existence of parent
      CURSOR cur_rowid IS
      SELECT   rowid
      FROM     IGS_PE_PERSON_ID_TYP
      WHERE    person_id_type = x_person_id_type;

Line: 319


      SELECT   rowid
      FROM     IGS_PE_PERSON_ID_TYP
      WHERE    person_id_type = x_person_id_type AND
               CLOSED_IND = 'N';

Line: 357


      SELECT   rowid
      FROM     IGS_PE_PERSON_ID_TYP
      WHERE    institution_cd = x_institution_cd ;

Line: 406


    x_last_update_date IN DATE  ,
    x_last_updated_by IN NUMBER  ,
    x_last_update_login IN NUMBER
  ) AS
  /*************************************************************
  Created By : sraj
  Date Created By : 17-MAY-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  sraj		17-MAY-2000	Two columns have been added to this table.
  (reverse chronological order - newest change first)
  ***************************************************************/

  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_person_id_type,
      x_description,
      x_s_person_id_type,
      x_institution_cd,
      x_preferred_ind,
      x_unique_ind,
      x_format_mask,
      x_region_ind,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_closed_ind
    );

Line: 442


     IF (p_action = 'INSERT') THEN
       -- Call all the procedures related to Before Insert.
     BeforeRowInsertUpdate1 ( p_inserting => TRUE,
                              p_updating => FALSE ,
    p_deleting => FALSE);

Line: 457


 ELSIF (p_action = 'UPDATE') THEN
       -- Call all the procedures related to Before Update.
       BeforeRowInsertUpdate1 ( p_updating => TRUE,
                                p_inserting => FALSE ,
                                p_deleting => FALSE);

Line: 465


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

Line: 475


 ELSIF (p_action = 'VALIDATE_UPDATE') THEN
       Check_Constraints; -- if procedure present

Line: 500


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

Line: 503


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

Line: 509


 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_PERSON_ID_TYPE IN VARCHAR2,
       x_DESCRIPTION IN VARCHAR2,
       x_S_PERSON_ID_TYPE IN VARCHAR2,
       x_INSTITUTION_CD IN VARCHAR2,
       x_PREFERRED_IND IN VARCHAR2,
       x_UNIQUE_IND IN VARCHAR2,
       X_FORMAT_MASK IN VARCHAR2 ,
       X_REGION_IND IN  VARCHAR2,
      X_MODE in VARCHAR2,
      X_CLOSED_IND IN VARCHAR2
  ) AS
  /*************************************************************
  Created By : sraj
  Date Created By : 17-MAY-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  sraj		17-MAY-2000	Two columns have been added to this table.
  (reverse chronological order - newest change first)
  ***************************************************************/

    cursor C is select ROWID from IGS_PE_PERSON_ID_TYP
             where                 PERSON_ID_TYPE= X_PERSON_ID_TYPE
;

Line: 536


     X_LAST_UPDATE_DATE DATE ;

Line: 537


     X_LAST_UPDATED_BY NUMBER ;

Line: 538


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 540


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 542


        X_LAST_UPDATED_BY := 1;

Line: 543


        X_LAST_UPDATE_LOGIN := 0;

Line: 545


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 546


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 549


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 550


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 559


 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_person_id_type=>X_PERSON_ID_TYPE,
 	       x_description=>X_DESCRIPTION,
 	       x_s_person_id_type=>X_S_PERSON_ID_TYPE,
 	       x_institution_cd=>X_INSTITUTION_CD,
 	       x_preferred_ind=>X_PREFERRED_IND,
 	       x_unique_ind=>X_UNIQUE_IND,
	       x_format_mask=>X_format_mask,
               x_region_ind => X_REGION_IND,
               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: 576


     insert into IGS_PE_PERSON_ID_TYP (
		PERSON_ID_TYPE
		,DESCRIPTION
		,S_PERSON_ID_TYPE
		,INSTITUTION_CD
		,PREFERRED_IND
		,UNIQUE_IND
		,FORMAT_MASK
          ,REGION_IND
	        ,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
		,CLOSED_IND
        ) values  (
	        NEW_REFERENCES.PERSON_ID_TYPE
	        ,NEW_REFERENCES.DESCRIPTION
	        ,NEW_REFERENCES.S_PERSON_ID_TYPE
	        ,NEW_REFERENCES.INSTITUTION_CD
	        ,NEW_REFERENCES.PREFERRED_IND
	        ,NEW_REFERENCES.UNIQUE_IND
	        ,NEW_REFERENCES.FORMAT_MASK
             ,NEW_REFERENCES.REGION_IND
	        ,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_LOGIN
		,NEW_REFERENCES.CLOSED_IND
);

Line: 615


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

Line: 617


end INSERT_ROW;

Line: 640


   cursor c1 is select
      DESCRIPTION
,      S_PERSON_ID_TYPE
,      INSTITUTION_CD
,      PREFERRED_IND
,      UNIQUE_IND
,      FORMAT_MASK
,     REGION_IND
    from IGS_PE_PERSON_ID_TYP
    where ROWID = X_ROWID
    for update nowait;

Line: 656


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

Line: 696


 PROCEDURE UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_PERSON_ID_TYPE IN VARCHAR2,
       x_DESCRIPTION IN VARCHAR2,
       x_S_PERSON_ID_TYPE IN VARCHAR2,
       x_INSTITUTION_CD IN VARCHAR2,
       x_PREFERRED_IND IN VARCHAR2,
       x_UNIQUE_IND IN VARCHAR2,
      X_FORMAT_MASK IN VARCHAR2 ,
       X_REGION_IND IN  VARCHAR2,
      X_MODE in VARCHAR2,
      X_CLOSED_IND IN VARCHAR2
  ) AS
  /*************************************************************
  Created By : sraj
  Date Created By : 17-MAY-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  sraj		17-MAY-2000	Two columns have been added to this table.
  (reverse chronological order - newest change first)
  ***************************************************************/

     X_LAST_UPDATE_DATE DATE ;

Line: 721


     X_LAST_UPDATED_BY NUMBER ;

Line: 722


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 724


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 726


        X_LAST_UPDATED_BY := 1;

Line: 727


        X_LAST_UPDATE_LOGIN := 0;

Line: 729


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 730


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 733


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 734


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 743


 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_person_id_type=>X_PERSON_ID_TYPE,
 	       x_description=>X_DESCRIPTION,
 	       x_s_person_id_type=>X_S_PERSON_ID_TYPE,
 	       x_institution_cd=>X_INSTITUTION_CD,
 	       x_preferred_ind=>X_PREFERRED_IND,
 	       x_unique_ind=>X_UNIQUE_IND,
	       x_format_mask=>X_FORMAT_MASK,
               x_region_ind => X_REGION_IND,
               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: 760


   update IGS_PE_PERSON_ID_TYP set
      DESCRIPTION =  NEW_REFERENCES.DESCRIPTION,
      S_PERSON_ID_TYPE =  NEW_REFERENCES.S_PERSON_ID_TYPE,
      INSTITUTION_CD =  NEW_REFERENCES.INSTITUTION_CD,
      PREFERRED_IND =  NEW_REFERENCES.PREFERRED_IND,
      UNIQUE_IND =  NEW_REFERENCES.UNIQUE_IND,
      FORMAT_MASK = NEW_REFERENCES.FORMAT_MASK,
      REGION_IND =  NEW_REFERENCES.REGION_IND,
	LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
	LAST_UPDATED_BY = X_LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
        CLOSED_IND = NEW_REFERENCES.CLOSED_IND
	  where ROWID = X_ROWID;

Line: 778


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

Line: 781


end UPDATE_ROW;

Line: 807


    cursor c1 is select ROWID from IGS_PE_PERSON_ID_TYP
             where     PERSON_ID_TYPE= X_PERSON_ID_TYPE
;

Line: 815


    INSERT_ROW (
      X_ROWID,
       X_PERSON_ID_TYPE,
       X_DESCRIPTION,
       X_S_PERSON_ID_TYPE,
       X_INSTITUTION_CD,
       X_PREFERRED_IND,
       X_UNIQUE_IND,
       X_FORMAT_MASK,
       X_REGION_IND,
      X_MODE,
      X_CLOSED_IND);

Line: 830


UPDATE_ROW (
      X_ROWID,
       X_PERSON_ID_TYPE,
       X_DESCRIPTION,
       X_S_PERSON_ID_TYPE,
       X_INSTITUTION_CD,
       X_PREFERRED_IND,
       X_UNIQUE_IND,
       X_FORMAT_MASK,
       X_REGION_IND ,
      X_MODE,
      X_CLOSED_IND);