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

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

Line: 17


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

  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  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_AD_INTERFACE_CTL
  WHERE    rowid = x_rowid;

Line: 46


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

Line: 48


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

Line: 68


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

Line: 76


    new_references.last_update_date := x_last_update_date;

Line: 77


    new_references.last_updated_by := x_last_updated_by;

Line: 78


    new_references.last_update_login := x_last_update_login;

Line: 138


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

Line: 149


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

Line: 172


    SELECT   rowid
    FROM     IGS_AD_INTERFACE_CTL
    WHERE    interface_run_id = x_interface_run_id
    FOR UPDATE NOWAIT;

Line: 210


      SELECT   rowid
      FROM     IGS_AD_INTERFACE_CTL
      WHERE    source_type_id = x_source_type_id ;

Line: 247


      SELECT   rowid
      FROM     IGS_AD_INTERFACE_CTL
      WHERE    match_set_id = x_match_set_id ;

Line: 278


    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER
  ) 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_interface_run_id,
      x_source_type_id,
      x_batch_id,
      x_match_set_id,
      x_status,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 310


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

Line: 321


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

Line: 326


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

Line: 329


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

Line: 338


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Constraints;

Line: 340


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;

Line: 365


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

Line: 368


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

Line: 371


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

Line: 378


  procedure INSERT_ROW (
    X_ROWID in out NOCOPY VARCHAR2,
    x_INTERFACE_RUN_ID IN OUT NOCOPY  NUMBER,
    x_SOURCE_TYPE_ID IN NUMBER,
    x_BATCH_ID IN NUMBER,
    x_MATCH_SET_ID IN NUMBER,
    x_STATUS IN VARCHAR2,
    X_MODE in VARCHAR2
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  rrengara        4-OCT-2002      Passed null to admission category, calendar instance, person type and funnel status for the Build 2604395
  (reverse chronological order - newest change first)
  ***************************************************************/

    cursor C is select ROWID from IGS_AD_INTERFACE_CTL
             where                 INTERFACE_RUN_ID= X_INTERFACE_RUN_ID;

Line: 401


     X_LAST_UPDATE_DATE DATE ;

Line: 402


     X_LAST_UPDATED_BY NUMBER ;

Line: 403


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 407


     X_PROGRAM_UPDATE_DATE DATE;

Line: 409


    X_LAST_UPDATE_DATE := SYSDATE;

Line: 411


      X_LAST_UPDATED_BY := 1;

Line: 412


      X_LAST_UPDATE_LOGIN := 0;

Line: 414


      X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 415


      if X_LAST_UPDATED_BY is NULL then
        X_LAST_UPDATED_BY := -1;

Line: 418


      X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 419


      if X_LAST_UPDATE_LOGIN is NULL then
        X_LAST_UPDATE_LOGIN := -1;

Line: 429


         X_PROGRAM_UPDATE_DATE := NULL;

Line: 431


         X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 441


      p_action=>'INSERT',
      x_rowid=>X_ROWID,
      x_interface_run_id=>X_INTERFACE_RUN_ID,
      x_source_type_id=>X_SOURCE_TYPE_ID,
      x_batch_id=>X_BATCH_ID,
      x_match_set_id=>X_MATCH_SET_ID,
      x_status=>X_STATUS,
      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: 455


      INSERT INTO IGS_AD_INTERFACE_CTL (
        INTERFACE_RUN_ID
        ,SOURCE_TYPE_ID
        ,BATCH_ID
        ,MATCH_SET_ID
        ,STATUS
        ,CREATION_DATE
        ,CREATED_BY
        ,LAST_UPDATE_DATE
        ,LAST_UPDATED_BY
        ,LAST_UPDATE_LOGIN
        ,REQUEST_ID
        ,PROGRAM_ID
        ,PROGRAM_APPLICATION_ID
        ,PROGRAM_UPDATE_DATE
    ) values  (
         IGS_AD_INTERFACE_CTL_S.NEXTVAL
        ,NEW_REFERENCES.SOURCE_TYPE_ID
        ,NEW_REFERENCES.BATCH_ID
        ,NEW_REFERENCES.MATCH_SET_ID
        ,NEW_REFERENCES.STATUS
        ,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
  )RETURNING INTERFACE_RUN_ID INTO X_INTERFACE_RUN_ID;

Line: 496


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

Line: 498


    end INSERT_ROW;

Line: 519


   CURSOR c1 IS SELECT
      SOURCE_TYPE_ID,
      BATCH_ID,
      MATCH_SET_ID,
      STATUS
   FROM IGS_AD_INTERFACE_CTL
   WHERE ROWID = X_ROWID
   for update nowait;

Line: 534


       FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 559


  Procedure UPDATE_ROW (
    X_ROWID in  VARCHAR2,
    x_INTERFACE_RUN_ID IN NUMBER,
    x_SOURCE_TYPE_ID IN NUMBER,
    x_BATCH_ID IN NUMBER,
    x_MATCH_SET_ID IN NUMBER,
    x_STATUS IN VARCHAR2,
    X_MODE in VARCHAR2
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
   rrengara        4-OCT-2002      Passed null to admission category, calendar instance, person type and funnel status for the Build 2604395
  (reverse chronological order - newest change first)
  ***************************************************************/

     X_LAST_UPDATE_DATE DATE ;

Line: 580


     X_LAST_UPDATED_BY NUMBER ;

Line: 581


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 585


     X_PROGRAM_UPDATE_DATE DATE;

Line: 587


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 589


        X_LAST_UPDATED_BY := 1;

Line: 590


        X_LAST_UPDATE_LOGIN := 0;

Line: 592


        X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 593


        if X_LAST_UPDATED_BY is NULL then
           X_LAST_UPDATED_BY := -1;

Line: 596


        X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 597


        if X_LAST_UPDATE_LOGIN is NULL then
           X_LAST_UPDATE_LOGIN := -1;

Line: 607


      p_action=>'UPDATE',
      x_rowid=>X_ROWID,
      x_interface_run_id=>X_INTERFACE_RUN_ID,
      x_source_type_id=>X_SOURCE_TYPE_ID,
      x_batch_id=>X_BATCH_ID,
      x_match_set_id=>X_MATCH_SET_ID,
      x_status=>X_STATUS,
      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: 629


          X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 631


          X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 635


   update IGS_AD_INTERFACE_CTL set
      SOURCE_TYPE_ID =  NEW_REFERENCES.SOURCE_TYPE_ID,
      BATCH_ID =  NEW_REFERENCES.BATCH_ID,
      MATCH_SET_ID =  NEW_REFERENCES.MATCH_SET_ID,
      STATUS =  NEW_REFERENCES.STATUS,
      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 = PROGRAM_APPLICATION_ID,
      PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
    where ROWID = X_ROWID;

Line: 654


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

Line: 657


  end UPDATE_ROW;

Line: 679


    cursor c1 is select ROWID from IGS_AD_INTERFACE_CTL
             where     INTERFACE_RUN_ID= X_INTERFACE_RUN_ID;

Line: 687


      INSERT_ROW (
         X_ROWID,
         X_INTERFACE_RUN_ID,
         X_SOURCE_TYPE_ID,
         X_BATCH_ID,
         X_MATCH_SET_ID,
         X_STATUS,
         X_MODE );

Line: 699


      UPDATE_ROW (
         X_ROWID,
         X_INTERFACE_RUN_ID,
         X_SOURCE_TYPE_ID,
         X_BATCH_ID,
         X_MATCH_SET_ID,
         X_STATUS,
         X_MODE );

Line: 710


  procedure DELETE_ROW (
    X_ROWID in VARCHAR2
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  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: 729


  delete from IGS_AD_INTERFACE_CTL
  where ROWID = X_ROWID;

Line: 736


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

Line: 740


end DELETE_ROW;