APPS.IGS_PE_IDENTIFY_DUPS SQL Statements

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

Line: 17

  ||                                  REPLACE single quote with double quotes to form proper SELECT clause when any of the
  ||                                  parameter value contains an Apostrophe in procedure form_dup_whereclause
  ||  pkpatel         10-JUN-2003     Bug 2940810
  ||                                  PKM SQL Bind issue(Modified literal to Bind variables)
  ||                                  Stubbed the find_duplicates procedures
  ||  gmaheswa        8-OCT-2003      Bug 3146324
  ||                                  Match Criteria Sets Enhancement
  ||  (reverse chronological order - newest change first)
  */

  PROCEDURE find_dup_main(
    ERRBUF OUT NOCOPY VARCHAR2,
    RETCODE OUT NOCOPY VARCHAR2,
    x_match_set_id IN NUMBER,
    x_report_requested IN VARCHAR2)
  IS
  BEGIN
    NULL;

Line: 119

    x_select_clause IN OUT NOCOPY VARCHAR2

    )
  IS
  /*
  ||  Created By : prabhat.patel
  ||  Created On : 09-OCT-2002
  ||  Purpose : Handles the Unique Constraint logic defined for the columns.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  ssawhney        25-jun-2003     3005910 - Devry MCS issue, making ADDRESS and PERSONIDGROUP changes
  ||                                  Addr_type and person_id_type to be appended with relevant fields
  ||                                  in Partial Match, for Drop if null=N, addr_type not to be appended for Addr_line1 and country
  ||  pkpatel         10-OCT-2002     Bug NO: 2593455
  ||                                  REPLACE single quote with double quotes to form proper SELECT clause when any of the
  ||                                  parameter value contains an Apostrophe
  ||                                  Added the code for data element ALTERNATE_ID
  ||  pkpatel         10-JUN-2003     Bug 2940810
  ||                                  PKM SQL Bind issue(Modified literal to Bind variables)
  ||  pkpatel         21-AUG-2003     Bug 3103195 (Removed Address line 1 from ANDing with other address element for partial match.
  ||                                  Added DISTINCT clause for selecting the person id)
  ||  asbala          23-SEP-2003     Bug 3130316, Duplicate Person Matching Performance Improvements
  ||  gmaheswa        1-OCT-2003      Bug 3146324, Match Criteria Sets Enhancement
  ||  asbala          28-nov-2003     Removed data element 'SURNAME_5_CHAR'
  ||  gmaheswa	      24-jan-2005     Bug: 3882788 Added the start_dt <> end_dt or end_dt is null check for person_id_type
  ||  (reverse chronological order - newest change first)
  */

    l_surname			igs_pe_dup_matches_ppa_v.surname%TYPE;

Line: 170

   l_SelectClause   VARCHAR2(2000);

Line: 204

   fnd_dsql.add_text('SELECT DISTINCT person_id FROM '|| x_view_name||' WHERE  UPPER(surname) = ');

Line: 470

    l_SelectClause := 'PARTIAL_MATCH';

Line: 472

    l_SelectClause := fnd_dsql.get_text(FALSE);

Line: 779

    l_SelectClause := fnd_dsql.get_text(FALSE);

Line: 781

    l_SelectClause := l_default_sql_text;

Line: 787

  x_select_clause := l_SelectClause;

Line: 821

      /* Delete from igs_ad_near_match_int all old occurances */
        DECLARE
        CURSOR tbh_cur IS
        SELECT ROWID
        FROM  igs_ad_imp_near_mtch_all
        WHERE interface_relations_id = P_REL_DUP_REC.INTERFACE_RELATIONS_ID;

Line: 833

        Igs_Ad_Imp_Near_Mtch_Pkg.delete_row(tbh_rec.ROWID);

Line: 840

      fnd_dsql.add_text('SELECT person_id FROM igs_pe_person_base_v WHERE UPPER(first_name) =UPPER(');

Line: 886

                   IGS_AD_IMP_NEAR_MTCH_PKG.INSERT_ROW(
                               X_ROWID                => l_rowid ,
                               X_ORG_ID               => NULL,
                               X_NEAR_MTCH_ID         => l_near_mtch_ind ,
                               X_INTERFACE_ID         => P_REL_DUP_REC.INTERFACE_ID,
                               X_PERSON_ID            => l_person_id,
                               X_MATCH_IND            => 'P',
                               X_ACTION               => null,
                               X_ADDR_TYPE            => null,
                               X_PERSON_ID_TYPE       => Null,
                               X_MATCH_SET_ID         => P_REL_DUP_REC.match_set_id,
                               X_MODE                 => 'I',
                               X_PARTY_SITE_ID        => null,
                               X_INTERFACE_RELATIONS_ID =>P_REL_DUP_REC.INTERFACE_RELATIONS_ID);