APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on IGS_PE_ALT_PERS_ID

Line 860: PROCEDURE create_ssn(cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,

856: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score 1' || SQLERRM);
857: app_exception.raise_exception;
858: END calculate_match_score;
859:
860: PROCEDURE create_ssn(cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
861: cp_original_ssn_txt VARCHAR2
862: )
863: AS
864:

Line 876: IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW (

872: */
873:
874: l_rowid ROWID;
875: BEGIN
876: IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW (
877: X_ROWID => l_rowid,
878: X_PE_PERSON_ID => cp_person_id,
879: X_API_PERSON_ID => cp_original_ssn_txt,
880: X_PERSON_ID_TYPE => 'SSN',

Line 944: FROM igs_pe_alt_pers_id

940:
941: -- cursor to get the ssn no of a person
942: CURSOR ssn_cur(cp_person_id number) IS
943: SELECT api_person_id,api_person_id_uf, end_dt
944: FROM igs_pe_alt_pers_id
945: WHERE pe_person_id=cp_person_id
946: AND person_id_type like 'SSN'
947: AND SYSDATE < = NVL(end_dt,SYSDATE);
948:

Line 3932: TYPE ssntab IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;

3928: */
3929: -- table definition
3930: TYPE RecTab IS TABLE OF VARCHAR2(30);
3931: TYPE PersonIdTab IS TABLE OF hz_parties.party_id%TYPE;
3932: TYPE ssntab IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
3933: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;
3934: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
3935: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
3936: TYPE citytab IS TABLE OF hz_parties.city%TYPE;

Line 4058: FROM igs_pe_alt_pers_id apii, igs_pe_person_id_typ pit

4054: hz.email_address email_address,
4055: hp.date_of_birth date_of_birth,
4056: hp.gender gender
4057: FROM ( SELECT apii.pe_person_id, apii.api_person_id_uf
4058: FROM igs_pe_alt_pers_id apii, igs_pe_person_id_typ pit
4059: WHERE apii.person_id_type = pit.person_id_type
4060: AND pit.s_person_id_type = 'SSN'
4061: AND SYSDATE BETWEEN apii.start_dt AND NVL (apii.end_dt, SYSDATE)) api,
4062: hz_parties hz,