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

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

Line: 34


    x_last_update_date IN DATE,
    x_last_updated_by IN NUMBER,
    x_last_update_login IN NUMBER,
  x_attribute_category  IN VARCHAR2,
  x_attribute1          IN VARCHAR2,
  x_attribute2          IN VARCHAR2,
  x_attribute3          IN VARCHAR2,
  x_attribute4          IN VARCHAR2,
  x_attribute5          IN VARCHAR2,
  x_attribute6          IN VARCHAR2,
  x_attribute7          IN VARCHAR2,
  x_attribute8          IN VARCHAR2,
  x_attribute9          IN VARCHAR2,
  x_attribute10         IN VARCHAR2,
  x_attribute11         IN VARCHAR2,
  x_attribute12         IN VARCHAR2,
  x_attribute13         IN VARCHAR2,
  x_attribute14         IN VARCHAR2,
  x_attribute15         IN VARCHAR2,
  x_attribute16         IN VARCHAR2,
  x_attribute17         IN VARCHAR2,
  x_attribute18         IN VARCHAR2,
  x_attribute19         IN VARCHAR2,
  x_attribute20         IN VARCHAR2,
  x_region_cd           IN VARCHAR2
  ) as
    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_PE_ALT_PERS_ID
      WHERE    rowid = x_rowid;

Line: 70


    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 80


    IF p_action = 'DELETE' THEN
      RETURN;

Line: 113


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

Line: 120


    new_references.last_update_date := x_last_update_date;

Line: 121


    new_references.last_updated_by := x_last_updated_by;

Line: 122


    new_references.last_update_login := x_last_update_login;

Line: 125


  PROCEDURE BeforeRowInsertUpdate1(
    p_inserting IN BOOLEAN,
    p_updating IN BOOLEAN,
    p_deleting IN BOOLEAN
    ) as
  ------------------------------------------------------------------------------------------
  --Created by  : pkpatel
  --Date created: 06-JUN-2002
  --
  --Purpose:
  --Known limitations/enhancements and/or remarks:
  --
  --Change History:
  --Who         When            What
  --pkpatel    8-JUN-2002       Bug No: 2402077
  --                            Removed the call to igs_as_val_suaap.genp_val_sdtt_sess('IGS_PE_ALT_PERS_ID') and
  --                            all unnecessary check so that the date validation procedures can be called properly.
  --askapoor   31-JAN-2005      Bug No: 3882788
  --                            Removed end_dt < sysdate and added check start_dt = end_dt
  --pkpatel    16-JUL-2005      Bug 4327807 (Person SS Enhancement)
  --                            Validate Format Mask
  ----------------------------------------------------------------------------------------------
	v_message_name  varchar2(30);

Line: 150


	SELECT birth_date
	FROM   igs_pe_person_base_v
	WHERE  person_id = cp_person_id;

Line: 155


	SELECT format_mask
	FROM   igs_pe_person_id_typ
	WHERE  person_id_type = cp_person_id_type;

Line: 164


   IF p_inserting THEN
     OPEN format_mask_cur(new_references.person_id_type);

Line: 181


   IF p_inserting OR p_updating THEN

		-- Validate that if end date is specified, then start date is also specified.
		-- As part of the bug 1956374 changed the following call from IGS_EN_VAL_API.enrp_val_api_end_dt
			IF IGS_EN_VAL_PAL.enrp_val_api_end_dt (
			 		new_references.start_dt,
				 	new_references.end_dt,
			 		v_message_name) = FALSE THEN
				  Fnd_Message.Set_Name('IGS', v_message_name);

Line: 228


  END BeforeRowInsertUpdate1;

Line: 230


  PROCEDURE AfterRowInsertUpdate2(
    p_inserting IN BOOLEAN,
    p_updating IN BOOLEAN,
    p_deleting IN BOOLEAN
    ) as
  ------------------------------------------------------------------------------------------
  --Created by  : pkpatel
  --Date created: 06-JUN-2002
  --
  --Purpose:
  --
  --Known limitations/enhancements and/or remarks:
  --
  --Change History:
  --Who         When            What
  --pkpatel     8-JUN-2002      Bug No: 2402077
  --                            Added the call igs_en_val_api.val_overlap_api so that there would be only one ACTIVE
  --                            alternate person id exist for a person ID type for a person
  --                            Added the call igs_en_val_api.val_ssn_overlap_api so that there would be only one ACTIVE
  --                            alternate person id exist for Social Security Number for a person
  --ssaleem     17-Sep-2004     Bug 3787210 -- added Closed Ind igs_pe_person_id_typ table
  --gmaheswa    29-Sep-2004     BUG 3787210 removed Closed indicator check for the Alternate Person Id type while end date overlap check.

  ----------------------------------------------------------------------------------------------
	v_message_name varchar2(30);

Line: 259


	SELECT 	'x'
  	FROM	IGS_PE_PERSON_ID_TYP		pit
  	WHERE	pit.person_id_type 	= cp_person_id_type AND
    		pit.s_person_id_type 	= cst_pay_adv_no AND
		pit.closed_ind = 'N';

Line: 266


	 SELECT	pit.s_person_id_type
	 FROM	igs_pe_person_id_typ pit
	 WHERE	pit.person_id_type 	= cp_person_id_type;

Line: 274


	IF p_inserting OR p_updating THEN

	  OPEN sys_pit_cur(new_references.person_id_type);

Line: 315


  END AfterRowInsertUpdate2;

Line: 317


  PROCEDURE BeforeInsert IS
  ------------------------------------------------------------------------------------------
  --Created by  : pkpatel
  --Date created: 06-JUN-2002
  --
  --Purpose: Bug No: 2402077. Modified to show the message to which person the Alternate Person ID
  --         is associate, whenever the uniqueness is violated for a Person ID Type with unique indicator
  --         checked.
  --Known limitations/enhancements and/or remarks:
  --
  --Change History:
  --Who         When            What
  --pkpatel     13-JAN-2003     Bug 2397876
  --                            Remove the FOR UPDATE NOWAIT
  --pkpatel     3-APR-2003      Bug No: 2859277
  --                            Closed the cursor cptu for cursor%NOTFOUND condition
  --ssawhney    7-sep-2004      Bug No: 3832912
  --                            introduced date check in the uniqueness cursor, cptu. uniqueness of alt id to be checked only for
  --                            active records, for all alt id types other than PAY_ADV_NO, not sure why though, checked no team uses this
  --                            s-alt-persid.
  --askapoor   31-JAN-2005      Bug No: 3882788
  --                            Included condition start_dt <> end_dt or end_dt is null
  --                            Removed condition start_dt < end_dt and end_dt > start_dt
  ----------------------------------------------------------------------------------------------
    CURSOR pt IS
    SELECT unique_ind
    FROM   igs_pe_person_id_typ
    WHERE  person_id_type = new_references.person_id_type AND
           closed_ind = 'N';

Line: 348


    SELECT hz.party_number
    FROM  igs_pe_alt_pers_id alt, hz_parties hz
    WHERE alt.person_id_type = new_references.person_id_type
    AND   alt.api_person_id = new_references.api_person_id
    AND   alt.pe_person_id <> new_references.pe_person_id
    AND   (alt.start_dt <> alt.end_dt OR alt.end_dt IS NULL)
    AND   alt.pe_person_id = hz.party_id;

Line: 379


  END beforeinsert;

Line: 423


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

Line: 434


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

Line: 459


      SELECT   rowid
      FROM     IGS_PE_ALT_PERS_ID
      WHERE    pe_person_id = x_pe_person_id
      AND      api_person_id = x_api_person_id
      AND      person_id_type = x_person_id_type
      AND      trunc(start_dt) = trunc(x_start_dt)
      FOR UPDATE NOWAIT;

Line: 483


      SELECT   rowid
      FROM     IGS_PE_ALT_PERS_ID
      WHERE    pe_person_id = x_person_id ;

Line: 533


  x_last_update_date    IN DATE,
  x_last_updated_by     IN NUMBER,
  x_last_update_login   IN NUMBER
  ) as
  BEGIN
    Set_Column_Values (
      p_action,
      x_rowid,
      x_pe_person_id,
      x_api_person_id,
      x_api_person_id_uf,
      x_person_id_type,
      x_start_dt,
      x_end_dt,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login ,
   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_region_cd
    );

Line: 575


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

Line: 596


      BeforeInsert;

Line: 598


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

Line: 609


 ELSIF (p_action = 'DELETE') THEN NULL;

Line: 613


 ELSIF (p_action = 'VALIDATE_INSERT') THEN

	  BeforeRowInsertUpdate1(
      	    p_inserting => TRUE,
            p_updating  => FALSE,
            p_deleting  => FALSE
			);

Line: 633


      BeforeInsert;

Line: 634


 ELSIF (p_action = 'VALIDATE_UPDATE') THEN

       BeforeRowInsertUpdate1(
      	    p_inserting => FALSE,
            p_updating  => TRUE,
            p_deleting  => FALSE
			);

Line: 645


  ELSIF (p_action = 'VALIDATE_DELETE') THEN
      NULL;

Line: 656


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

Line: 663


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

Line: 670


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to After Delete.
      NULL;

Line: 676


procedure INSERT_ROW (
  X_ROWID         in out NOCOPY VARCHAR2,
  X_PE_PERSON_ID  in NUMBER,
  X_API_PERSON_ID in VARCHAR2,
  X_API_PERSON_ID_UF IN VARCHAR2,
  X_PERSON_ID_TYPE in VARCHAR2,
  X_START_DT       in DATE,
  X_END_DT         in DATE,
  x_attribute_category  IN VARCHAR2,
  x_attribute1          IN VARCHAR2,
  x_attribute2          IN VARCHAR2,
  x_attribute3          IN VARCHAR2,
  x_attribute4          IN VARCHAR2,
  x_attribute5          IN VARCHAR2,
  x_attribute6          IN VARCHAR2,
  x_attribute7          IN VARCHAR2,
  x_attribute8          IN VARCHAR2,
  x_attribute9          IN VARCHAR2,
  x_attribute10         IN VARCHAR2,
  x_attribute11         IN VARCHAR2,
  x_attribute12         IN VARCHAR2,
  x_attribute13         IN VARCHAR2,
  x_attribute14         IN VARCHAR2,
  x_attribute15         IN VARCHAR2,
  x_attribute16         IN VARCHAR2,
  x_attribute17         IN VARCHAR2,
  x_attribute18         IN VARCHAR2,
  x_attribute19         IN VARCHAR2,
  x_attribute20         IN VARCHAR2,
  x_region_cd           IN VARCHAR2,
  X_MODE                IN VARCHAR2
  ) as
    cursor C is select ROWID from IGS_PE_ALT_PERS_ID
      where PE_PERSON_ID = X_PE_PERSON_ID
      and API_PERSON_ID = X_API_PERSON_ID
      and PERSON_ID_TYPE = X_PERSON_ID_TYPE
      and start_dt       = x_start_dt;

Line: 713


    X_LAST_UPDATE_DATE DATE;

Line: 714


    X_LAST_UPDATED_BY NUMBER;

Line: 715


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 719


    X_PROGRAM_UPDATE_DATE DATE;

Line: 721


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 723


    X_LAST_UPDATED_BY := 1;

Line: 724


    X_LAST_UPDATE_LOGIN := 0;

Line: 726


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 727


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 730


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 731


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 741


     X_PROGRAM_UPDATE_DATE := NULL;

Line: 743


     X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 751


 p_action=>'INSERT',
 x_rowid=>X_ROWID,
 x_api_person_id=>X_API_PERSON_ID,
 x_api_person_id_uf=>X_API_PERSON_ID_UF,
 x_end_dt=>X_END_DT,
 x_pe_person_id=>X_PE_PERSON_ID,
 x_person_id_type=>X_PERSON_ID_TYPE,
 x_start_dt=>X_START_DT,
 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_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_region_cd          => X_region_cd
   );

Line: 790


 insert into IGS_PE_ALT_PERS_ID (
    PE_PERSON_ID,
    API_PERSON_ID,
    API_PERSON_ID_UF,
    PERSON_ID_TYPE,
    START_DT,
    END_DT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE ,
   ATTRIBUTE_CATEGORY,
   ATTRIBUTE1  ,
   ATTRIBUTE2  ,
   ATTRIBUTE3  ,
   ATTRIBUTE4  ,
   ATTRIBUTE5  ,
   ATTRIBUTE6  ,
   ATTRIBUTE7  ,
   ATTRIBUTE8  ,
   ATTRIBUTE9  ,
   ATTRIBUTE10 ,
   ATTRIBUTE11 ,
   ATTRIBUTE12 ,
   ATTRIBUTE13 ,
   ATTRIBUTE14 ,
   ATTRIBUTE15 ,
   ATTRIBUTE16 ,
   ATTRIBUTE17 ,
   ATTRIBUTE18 ,
   ATTRIBUTE19 ,
   ATTRIBUTE20 ,
   REGION_CD
  ) values (
    NEW_REFERENCES.PE_PERSON_ID,
    NEW_REFERENCES.API_PERSON_ID,
    NEW_REFERENCES.API_PERSON_ID_UF,
    NEW_REFERENCES.PERSON_ID_TYPE,
    NEW_REFERENCES.START_DT,
    NEW_REFERENCES.END_DT,
    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,
    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.REGION_CD
  )RETURNING ROWID INTO X_ROWID;

Line: 880


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

Line: 896


end INSERT_ROW;

Line: 929


  cursor c1 is select
      API_PERSON_ID_UF,
      START_DT,
      END_DT,
   ATTRIBUTE_CATEGORY,
   ATTRIBUTE1  ,
   ATTRIBUTE2  ,
   ATTRIBUTE3  ,
   ATTRIBUTE4  ,
   ATTRIBUTE5  ,
   ATTRIBUTE6  ,
   ATTRIBUTE7  ,
   ATTRIBUTE8  ,
   ATTRIBUTE9  ,
   ATTRIBUTE10 ,
   ATTRIBUTE11 ,
   ATTRIBUTE12 ,
   ATTRIBUTE13 ,
   ATTRIBUTE14 ,
   ATTRIBUTE15 ,
   ATTRIBUTE16 ,
   ATTRIBUTE17 ,
   ATTRIBUTE18 ,
   ATTRIBUTE19 ,
   ATTRIBUTE20 ,
   REGION_CD
    from IGS_PE_ALT_PERS_ID
    where ROWID = X_ROWID
    for update nowait;

Line: 963


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

Line: 1008


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_PE_PERSON_ID in NUMBER,
  X_API_PERSON_ID in VARCHAR2,
  X_API_PERSON_ID_UF IN VARCHAR2,
  X_PERSON_ID_TYPE in VARCHAR2,
  X_START_DT in DATE,
  X_END_DT in DATE,
  X_ATTRIBUTE_CATEGORY  in      VARCHAR2,
  X_ATTRIBUTE1          in      VARCHAR2,
  X_ATTRIBUTE2          in      VARCHAR2,
  X_ATTRIBUTE3          in      VARCHAR2,
  X_ATTRIBUTE4          in      VARCHAR2,
  X_ATTRIBUTE5          in      VARCHAR2,
  X_ATTRIBUTE6          in      VARCHAR2,
  X_ATTRIBUTE7          in      VARCHAR2,
  X_ATTRIBUTE8          in      VARCHAR2,
  X_ATTRIBUTE9          in      VARCHAR2,
  X_ATTRIBUTE10         in      VARCHAR2,
  X_ATTRIBUTE11         in      VARCHAR2,
  X_ATTRIBUTE12         in      VARCHAR2,
  X_ATTRIBUTE13         in      VARCHAR2,
  X_ATTRIBUTE14         in      VARCHAR2,
  X_ATTRIBUTE15         in      VARCHAR2,
  X_ATTRIBUTE16         in      VARCHAR2,
  X_ATTRIBUTE17         in      VARCHAR2,
  X_ATTRIBUTE18         in      VARCHAR2,
  X_ATTRIBUTE19         in      VARCHAR2,
  X_ATTRIBUTE20         in      VARCHAR2,
  x_region_cd           IN      VARCHAR2,
  X_MODE in VARCHAR2
  ) as
    X_LAST_UPDATE_DATE DATE;

Line: 1041


    X_LAST_UPDATED_BY NUMBER;

Line: 1042


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 1046


    X_PROGRAM_UPDATE_DATE DATE;

Line: 1048


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 1050


    X_LAST_UPDATED_BY := 1;

Line: 1051


    X_LAST_UPDATE_LOGIN := 0;

Line: 1053


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1054


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 1057


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 1058


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 1067


 p_action=>'UPDATE',
 x_rowid=>X_ROWID,
 x_api_person_id=>X_API_PERSON_ID,
 x_api_person_id_uf=>X_API_PERSON_ID_UF,
 x_end_dt=>X_END_DT,
 x_pe_person_id=>X_PE_PERSON_ID,
 x_person_id_type=>X_PERSON_ID_TYPE,
 x_start_dt=>X_START_DT,
 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_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_region_cd          => X_REGION_CD

 );

Line: 1113


     X_PROGRAM_UPDATE_DATE :=
                  OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 1116


     X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 1122


 update IGS_PE_ALT_PERS_ID set
    API_PERSON_ID_UF = NEW_REFERENCES.API_PERSON_ID_UF,
    START_DT = NEW_REFERENCES.START_DT,
    END_DT = NEW_REFERENCES.END_DT,
    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,
    REGION_CD   = NEW_REFERENCES.REGION_CD,
    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: 1169


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

Line: 1185


end UPDATE_ROW;

Line: 1218


  cursor c1 is select rowid from IGS_PE_ALT_PERS_ID
     where PE_PERSON_ID = X_PE_PERSON_ID
     and API_PERSON_ID = X_API_PERSON_ID
     and PERSON_ID_TYPE = X_PERSON_ID_TYPE
     and start_dt       = x_start_dt
  ;

Line: 1229


    INSERT_ROW (
     X_ROWID,
     X_PE_PERSON_ID,
     X_API_PERSON_ID,
     X_API_PERSON_ID_UF,
     X_PERSON_ID_TYPE,
     X_START_DT,
     X_END_DT,
    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_REGION_CD,
     X_MODE);

Line: 1263


  UPDATE_ROW (
   X_ROWID,
   X_PE_PERSON_ID,
   X_API_PERSON_ID,
   X_API_PERSON_ID_UF,
   X_PERSON_ID_TYPE,
   X_START_DT,
   X_END_DT,
    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_REGION_CD,
    X_MODE);

Line: 1295


procedure DELETE_ROW (
  X_ROWID in VARCHAR2,
  x_mode IN VARCHAR2
) as
begin
 Before_DML(
  p_action => 'DELETE',
  x_rowid => X_ROWID
  );

Line: 1307


 delete from IGS_PE_ALT_PERS_ID
  where ROWID = X_ROWID;

Line: 1320


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

Line: 1323


end DELETE_ROW;