DBA Data[Home] [Help]

APPS.IGS_AD_IMP_NEAR_MTCH_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,
    x_party_site_id IN NUMBER DEFAULT NULL ,
    X_INTERFACE_RELATIONS_ID IN NUMBER DEFAULT NULL
  ) AS

  /*************************************************************
  Created By : amuthu
  Date Created On : 15-May-2000
  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_IMP_NEAR_MTCH_ALL
      WHERE    rowid = x_rowid;
Line: 52

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

      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 71

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

    new_references.last_update_date := x_last_update_date;
Line: 79

    new_references.last_updated_by := x_last_updated_by;
Line: 80

    new_references.last_update_login := x_last_update_login;
Line: 145

      Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
Line: 156

      Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
Line: 167

      Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
Line: 178

      Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
Line: 189

      Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
Line: 212

      SELECT   rowid
      FROM     igs_ad_imp_near_mtch_all
      WHERE    near_mtch_id = x_near_mtch_id
      FOR UPDATE NOWAIT;
Line: 248

      SELECT   rowid
      FROM     igs_ad_imp_near_mtch_all
      WHERE    interface_id = x_interface_id ;
Line: 285

      SELECT   rowid
      FROM     igs_ad_imp_near_mtch_all
      WHERE    addr_type = x_addr_type ;
Line: 322

      SELECT   rowid
      FROM     igs_ad_imp_near_mtch_all
      WHERE    match_set_id = x_match_set_id ;
Line: 359

      SELECT   rowid
      FROM     igs_ad_imp_near_mtch_all
      WHERE    person_id = x_person_id ;
Line: 394

    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_party_site_id IN NUMBER DEFAULT NULL,
    X_INTERFACE_RELATIONS_ID IN NUMBER DEFAULT NULL
  ) AS
  /*************************************************************
  Created By : amuthu
  Date Created On : 15-May-2000
  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_org_id,
      x_near_mtch_id,
      x_interface_id,
      x_person_id,
      x_match_ind,
      x_action,
      x_addr_type,
      x_person_id_type,
      x_match_set_id,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_party_site_id,
      x_interface_relations_id

    );
Line: 435

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      IF Get_Pk_For_Validation(new_references.near_mtch_id)  THEN
        Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
Line: 444

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

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

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

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Constraints;
Line: 463

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;
Line: 488

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

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

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

  procedure INSERT_ROW (
    X_ROWID in out NOCOPY VARCHAR2,
    X_ORG_ID in NUMBER,
    x_NEAR_MTCH_ID IN OUT NOCOPY NUMBER,
    x_INTERFACE_ID IN NUMBER,
    x_PERSON_ID IN NUMBER,
    x_MATCH_IND IN VARCHAR2,
    x_ACTION IN VARCHAR2,
    x_ADDR_TYPE IN VARCHAR2,
    x_PERSON_ID_TYPE IN VARCHAR2,
    x_MATCH_SET_ID IN NUMBER,
    X_MODE in VARCHAR2 default 'R',
    X_PARTY_SITE_ID IN NUMBER ,
    X_INTERFACE_RELATIONS_ID IN NUMBER
  ) AS
  /*************************************************************
  Created By : amuthu
  Date Created On : 15-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  sbaliga        12-feb-2002      Modified call to before_dml by assigning
                                  igs_ge_gen_003.get_org_id to x_org_id as part of
                                  SWCR006 build.

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

    cursor C is select ROWID from IGS_AD_IMP_NEAR_MTCH_ALL
              where NEAR_MTCH_ID= X_NEAR_MTCH_ID;
Line: 532

    X_LAST_UPDATE_DATE DATE ;
Line: 533

    X_LAST_UPDATED_BY NUMBER ;
Line: 534

    X_LAST_UPDATE_LOGIN NUMBER ;
Line: 538

    X_PROGRAM_UPDATE_DATE DATE;
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: 560

        X_PROGRAM_UPDATE_DATE := NULL;
Line: 562

        X_PROGRAM_UPDATE_DATE := SYSDATE;
Line: 572

      p_action=>'INSERT',
      x_org_id=>igs_ge_gen_003.get_org_id,
      x_rowid=>X_ROWID,
      x_near_mtch_id=>X_NEAR_MTCH_ID,
      x_interface_id=>X_INTERFACE_ID,
      x_person_id=>X_PERSON_ID,
      x_match_ind=>X_MATCH_IND,
      x_action=>X_ACTION,
      x_addr_type=>X_ADDR_TYPE,
      x_person_id_type=>X_PERSON_ID_TYPE,
      x_match_set_id=>X_MATCH_SET_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,
      x_party_site_id => X_PARTY_SITE_ID,
      x_interface_relations_id => X_INTERFACE_RELATIONS_ID);
Line: 591

    insert into IGS_AD_IMP_NEAR_MTCH_ALL (
      NEAR_MTCH_ID
      ,INTERFACE_ID
      ,PERSON_ID
      ,ORG_ID
      ,MATCH_IND
      ,ACTION
      ,ADDR_TYPE
      ,PERSON_ID_TYPE
      ,MATCH_SET_ID
      ,CREATION_DATE
      ,CREATED_BY
      ,LAST_UPDATE_DATE
      ,LAST_UPDATED_BY
      ,LAST_UPDATE_LOGIN
      ,REQUEST_ID
      ,PROGRAM_ID
      ,PROGRAM_APPLICATION_ID
      ,PROGRAM_UPDATE_DATE
      ,PARTY_SITE_ID
      ,INTERFACE_RELATIONS_ID

    ) values  (
      IGS_AD_IMP_NEAR_MTCH_S.NEXTVAL
      ,NEW_REFERENCES.INTERFACE_ID
      ,NEW_REFERENCES.PERSON_ID
      ,NEW_REFERENCES.ORG_ID
      ,NEW_REFERENCES.MATCH_IND
      ,NEW_REFERENCES.ACTION
      ,NEW_REFERENCES.ADDR_TYPE
      ,NEW_REFERENCES.PERSON_ID_TYPE
      ,NEW_REFERENCES.MATCH_SET_ID
      ,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.PARTY_SITE_ID
      ,NEW_REFERENCES.INTERFACE_RELATIONS_ID )RETURNING NEAR_MTCH_ID INTO X_NEAR_MTCH_ID;
Line: 644

      p_action => 'INSERT' ,
      x_rowid => X_ROWID );
Line: 647

  end INSERT_ROW;
Line: 673

    cursor c1 is select
      INTERFACE_ID,
      PERSON_ID,
      MATCH_IND,
      ACTION,
      ADDR_TYPE,
      PERSON_ID_TYPE,
      MATCH_SET_ID,
      PARTY_SITE_ID,
      INTERFACE_RELATIONS_ID
    from IGS_AD_IMP_NEAR_MTCH_ALL
    where ROWID = X_ROWID
    for update nowait;
Line: 692

      fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
Line: 722

 Procedure UPDATE_ROW (
   X_ROWID in  VARCHAR2,
   x_NEAR_MTCH_ID IN NUMBER,
   x_INTERFACE_ID IN NUMBER,
   x_PERSON_ID IN NUMBER,
   x_MATCH_IND IN VARCHAR2,
   x_ACTION IN VARCHAR2,
   x_ADDR_TYPE IN VARCHAR2,
   x_PERSON_ID_TYPE IN VARCHAR2,
   x_MATCH_SET_ID IN NUMBER,
   X_MODE in VARCHAR2 default 'R',
   X_PARTY_SITE_ID IN NUMBER  ,
   X_INTERFACE_RELATIONS_ID IN NUMBER
  ) AS
  /*************************************************************
  Created By : amuthu
  Date Created On : 15-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

    X_LAST_UPDATE_DATE DATE ;
Line: 748

    X_LAST_UPDATED_BY NUMBER ;
Line: 749

    X_LAST_UPDATE_LOGIN NUMBER ;
Line: 753

    X_PROGRAM_UPDATE_DATE DATE;
Line: 755

    X_LAST_UPDATE_DATE := SYSDATE;
Line: 757

      X_LAST_UPDATED_BY := 1;
Line: 758

      X_LAST_UPDATE_LOGIN := 0;
Line: 760

      X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 761

      if X_LAST_UPDATED_BY is NULL then
        X_LAST_UPDATED_BY := -1;
Line: 764

      X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 765

      if X_LAST_UPDATE_LOGIN is NULL then
        X_LAST_UPDATE_LOGIN := -1;
Line: 775

      p_action=>'UPDATE',
      x_rowid=>X_ROWID,
      x_near_mtch_id=>X_NEAR_MTCH_ID,
      x_interface_id=>X_INTERFACE_ID,
      x_person_id=>X_PERSON_ID,
      x_match_ind=>X_MATCH_IND,
      x_action=>X_ACTION,
      x_addr_type=>X_ADDR_TYPE,
      x_person_id_type=>X_PERSON_ID_TYPE,
      x_match_set_id=>X_MATCH_SET_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,
      x_party_site_id => X_PARTY_SITE_ID,
      x_interface_relations_id => X_INTERFACE_RELATIONS_ID);
Line: 801

        X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;
Line: 803

        X_PROGRAM_UPDATE_DATE := SYSDATE;
Line: 807

    update IGS_AD_IMP_NEAR_MTCH_ALL set
      INTERFACE_ID =  NEW_REFERENCES.INTERFACE_ID,
      PERSON_ID =  NEW_REFERENCES.PERSON_ID,
      MATCH_IND =  NEW_REFERENCES.MATCH_IND,
      ACTION =  NEW_REFERENCES.ACTION,
      ADDR_TYPE =  NEW_REFERENCES.ADDR_TYPE,
      PERSON_ID_TYPE =  NEW_REFERENCES.PERSON_ID_TYPE,
      MATCH_SET_ID =  NEW_REFERENCES.MATCH_SET_ID,
      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,
      PARTY_SITE_ID = X_PARTY_SITE_ID,
      INTERFACE_RELATIONS_ID = X_INTERFACE_RELATIONS_ID
    where ROWID = X_ROWID;
Line: 831

      p_action => 'UPDATE' ,
      x_rowid => X_ROWID
      );
Line: 834

  end UPDATE_ROW;
Line: 863

    cursor c1 is select ROWID from IGS_AD_IMP_NEAR_MTCH_ALL
      where NEAR_MTCH_ID= X_NEAR_MTCH_ID;
Line: 870

      INSERT_ROW (
	X_ROWID,
	X_ORG_ID,
	X_NEAR_MTCH_ID,
	X_INTERFACE_ID,
	X_PERSON_ID,
	X_MATCH_IND,
	X_ACTION,
	X_ADDR_TYPE,
	X_PERSON_ID_TYPE,
	X_MATCH_SET_ID,
	X_MODE,
	X_PARTY_SITE_ID ,
        X_INTERFACE_RELATIONS_ID);
Line: 887

    UPDATE_ROW (
      X_ROWID,
      X_NEAR_MTCH_ID,
      X_INTERFACE_ID,
      X_PERSON_ID,
      X_MATCH_IND,
      X_ACTION,
      X_ADDR_TYPE,
      X_PERSON_ID_TYPE,
      X_MATCH_SET_ID,
      X_MODE,
      X_PARTY_SITE_ID,
      X_INTERFACE_RELATIONS_ID );
Line: 904

  procedure DELETE_ROW (
    X_ROWID in VARCHAR2
  ) AS
  /*************************************************************
  Created By : amuthu
  Date Created On : 15-May-2000
  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: 924

    delete from IGS_AD_IMP_NEAR_MTCH_ALL
    where ROWID = X_ROWID;
Line: 931

      p_action => 'DELETE',
      x_rowid => X_ROWID
    );
Line: 935

  end DELETE_ROW;