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

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

Line: 21


    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

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

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

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

Line: 50


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

Line: 52


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

Line: 68


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

Line: 75


    new_references.last_update_date := x_last_update_date;

Line: 76


    new_references.last_updated_by := x_last_updated_by;

Line: 77


    new_references.last_update_login := x_last_update_login;

Line: 124


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

Line: 135


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

Line: 158


      SELECT   rowid
      FROM     IGS_PE_INCOME_TAX_ALL
      WHERE    tax_id = x_tax_id
      FOR UPDATE NOWAIT;

Line: 194


      SELECT   rowid
      FROM     IGS_PE_INCOME_TAX_ALL
      WHERE    person_id = x_person_id ;

Line: 233


      SELECT   rowid
      FROM     igs_pe_income_tax_all
      WHERE    person_id = x_person_id
      AND     ((cp_type_code is null and cp_type_code_id is not null and NVL(type_code_id,-1) = cp_type_code_id)
      OR      (cp_type_code is not null and cp_type_code_id is null and NVL(type_code,' ') = cp_type_code))
      AND      ((l_rowid is null) or (rowid <> l_rowid))
      ;

Line: 299


    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
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_tax_id,
      x_person_id,
      x_tax_info,
      x_type_code,
      x_type_code_id,
      x_start_date,
      x_end_date,
      x_org_id,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 334


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

Line: 346


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

Line: 352


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

Line: 355


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

Line: 365


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;

Line: 368


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;

Line: 395


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

Line: 398


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

Line: 401


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

Line: 408


 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_TAX_ID IN OUT NOCOPY NUMBER,
       x_PERSON_ID IN NUMBER,
       x_TAX_INFO IN VARCHAR2,
       x_TYPE_CODE IN VARCHAR2,
       x_TYPE_CODE_ID IN NUMBER,
       x_START_DATE IN DATE,
       x_END_DATE IN DATE,
       X_ORG_ID in NUMBER,
      X_MODE in VARCHAR2 default 'R'
  ) AS
  /*************************************************************
  Created By :srachako
  Date Created By :11-MAY-2000
  Purpose :For Inserting Values
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

    cursor C is select ROWID from IGS_PE_INCOME_TAX_ALL
             where                 TAX_ID= X_TAX_ID
;

Line: 434


     X_LAST_UPDATE_DATE DATE ;

Line: 435


     X_LAST_UPDATED_BY NUMBER ;

Line: 436


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 440


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 442


        X_LAST_UPDATED_BY := 1;

Line: 443


        X_LAST_UPDATE_LOGIN := 0;

Line: 445


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 446


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 449


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 450


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 458


       SELECT IGS_PE_INCOME_TAX_S.NEXTVAL
       	    INTO X_TAX_ID
       	   FROM Dual;

Line: 471


 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_tax_id=>X_TAX_ID,
 	       x_person_id=>X_PERSON_ID,
 	       x_tax_info=>X_TAX_INFO,
 	       x_type_code=>l_TYPE_CODE,
	       x_type_code_id=>l_TYPE_CODE_ID,
 	       x_start_date=>X_START_DATE,
 	       x_end_date=>X_END_DATE,
               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: 491


 insert into IGS_PE_INCOME_TAX_ALL (
		TAX_ID
		,PERSON_ID
		,TAX_INFO
		,TYPE_CODE
		,TYPE_CODE_ID
		,START_DATE
		,END_DATE
                ,ORG_ID
                ,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
        ) values  (
	         NEW_REFERENCES.TAX_ID
	        ,NEW_REFERENCES.PERSON_ID
	        ,NEW_REFERENCES.TAX_INFO
	        ,NEW_REFERENCES.TYPE_CODE
	        ,NEW_REFERENCES.TYPE_CODE_ID
	        ,NEW_REFERENCES.START_DATE
	        ,NEW_REFERENCES.END_DATE
                ,NEW_REFERENCES.ORG_ID
	        ,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_LOGIN
);

Line: 534


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

Line: 549


end INSERT_ROW;

Line: 572


   cursor c1 is select
      PERSON_ID
,      TAX_INFO
,      TYPE_CODE
,      TYPE_CODE_ID
,      START_DATE
,      END_DATE
    from IGS_PE_INCOME_TAX_ALL
    where ROWID = X_ROWID
    for update nowait;

Line: 589


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

Line: 626


 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_TAX_ID IN NUMBER,
       x_PERSON_ID IN NUMBER,
       x_TAX_INFO IN VARCHAR2,
       x_TYPE_CODE IN VARCHAR2,
       x_TYPE_CODE_ID IN NUMBER,
       x_START_DATE IN DATE,
       x_END_DATE IN DATE,
      X_MODE in VARCHAR2 default 'R'
  ) AS
  /*************************************************************
  Created By :srachako
  Date Created By :11-MAY-2000
  Purpose :For Updation of Row
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

     X_LAST_UPDATE_DATE DATE ;

Line: 649


     X_LAST_UPDATED_BY NUMBER ;

Line: 650


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 654


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 656


        X_LAST_UPDATED_BY := 1;

Line: 657


        X_LAST_UPDATE_LOGIN := 0;

Line: 659


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 660


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 663


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 664


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 682


 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_tax_id=>X_TAX_ID,
 	       x_person_id=>X_PERSON_ID,
 	       x_tax_info=>X_TAX_INFO,
 	       x_type_code=>l_TYPE_CODE,
	       x_type_code_id=>l_TYPE_CODE_ID,
 	       x_start_date=>X_START_DATE,
 	       x_end_date=>X_END_DATE,
	       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: 699


 update IGS_PE_INCOME_TAX_ALL set
      PERSON_ID =  NEW_REFERENCES.PERSON_ID,
      TAX_INFO =  NEW_REFERENCES.TAX_INFO,
      TYPE_CODE =  NEW_REFERENCES.TYPE_CODE,
      TYPE_CODE_ID =  NEW_REFERENCES.TYPE_CODE_ID,
      START_DATE =  NEW_REFERENCES.START_DATE,
      END_DATE =  NEW_REFERENCES.END_DATE,
	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: 722


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

Line: 738


end UPDATE_ROW;

Line: 754


  Purpose :for Insertion of Values
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

    cursor c1 is select ROWID from IGS_PE_INCOME_TAX_ALL
             where     TAX_ID= X_TAX_ID
;

Line: 773


    INSERT_ROW (
       X_ROWID,
       X_TAX_ID,
       X_PERSON_ID,
       X_TAX_INFO,
       X_TYPE_CODE,
       X_TYPE_CODE_ID,
       X_START_DATE,
       X_END_DATE,
       X_ORG_ID,
      X_MODE );

Line: 787


UPDATE_ROW (
      X_ROWID,
       X_TAX_ID,
       X_PERSON_ID,
       X_TAX_INFO,
       X_TYPE_CODE,
       X_TYPE_CODE_ID,
       X_START_DATE,
       X_END_DATE,
      X_MODE );

Line: 798


procedure DELETE_ROW (
  X_ROWID in VARCHAR2,
  x_mode IN VARCHAR2
) AS
  /*************************************************************
  Created By :srachako
  Date Created By :11-MAY-2000
  Purpose :for Deletion of Rows
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

begin
Before_DML (
p_action => 'DELETE',
x_rowid => X_ROWID
);

Line: 821


 delete from IGS_PE_INCOME_TAX_ALL
 where ROWID = X_ROWID;

Line: 834


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

Line: 837


end DELETE_ROW;