APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGS_PE_ALT_PERS_ID

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

1641: igs_ge_msg_stack.add;
1642: app_exception.raise_exception;
1643: END insert_nslds_data_rec;
1644:
1645: PROCEDURE create_ssn(cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
1646: cp_original_ssn_txt VARCHAR2
1647: )
1648: IS
1649:

Line 1662: IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW (

1658:
1659: lv_rowid ROWID;
1660: BEGIN
1661:
1662: IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW (
1663: X_ROWID => lv_rowid,
1664: X_PE_PERSON_ID => cp_person_id,
1665: X_API_PERSON_ID => cp_original_ssn_txt,
1666: X_PERSON_ID_TYPE => 'SSN',

Line 1714: FROM igs_pe_alt_pers_id

1710:
1711: -- cursor to get the ssn no of a person
1712: CURSOR ssn_cur(cp_person_id number) IS
1713: SELECT api_person_id,api_person_id_uf, end_dt
1714: FROM igs_pe_alt_pers_id
1715: WHERE pe_person_id=cp_person_id
1716: AND person_id_type like 'SSN'
1717: AND SYSDATE < = NVL(end_dt,SYSDATE);
1718:

Line 2506: CURSOR alt_person_id_cur (ln_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,

2502: hzparties_rec hzparties_cur%ROWTYPE;
2503:
2504:
2505:
2506: CURSOR alt_person_id_cur (ln_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
2507: ln_person_id igf_ap_fa_base_rec.person_id%TYPE) IS
2508: SELECT rowid row_id,
2509: altp.*
2510: FROM igs_pe_alt_pers_id altp

Line 2510: FROM igs_pe_alt_pers_id altp

2506: CURSOR alt_person_id_cur (ln_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
2507: ln_person_id igf_ap_fa_base_rec.person_id%TYPE) IS
2508: SELECT rowid row_id,
2509: altp.*
2510: FROM igs_pe_alt_pers_id altp
2511: WHERE altp.pe_person_id = ln_person_id
2512: AND altp.api_person_id = ln_api_person_id
2513: AND SYSDATE BETWEEN altp.start_dt and NVL(altp.end_dt, SYSDATE);
2514:

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

4392:
4393: -- table definition
4394: TYPE RecTab IS TABLE OF VARCHAR2(30);
4395: TYPE PersonIdTab IS TABLE OF hz_parties.party_id%TYPE;
4396: TYPE ssntab IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
4397: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;
4398: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
4399: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
4400: TYPE citytab IS TABLE OF hz_parties.city%TYPE;

Line 4512: FROM igs_pe_alt_pers_id apii, igs_pe_person_id_typ pit

4508: hz.email_address email_address,
4509: hp.date_of_birth date_of_birth,
4510: hp.gender gender
4511: FROM ( SELECT apii.pe_person_id, apii.api_person_id_uf
4512: FROM igs_pe_alt_pers_id apii, igs_pe_person_id_typ pit
4513: WHERE apii.person_id_type = pit.person_id_type
4514: AND pit.s_person_id_type = 'SSN'
4515: AND SYSDATE BETWEEN apii.start_dt AND NVL (apii.end_dt, SYSDATE)) api,
4516: hz_parties hz,

Line 8433: FROM igs_pe_alt_pers_id

8429: ) IS
8430: SELECT api_person_id,
8431: api_person_id_uf,
8432: end_dt
8433: FROM igs_pe_alt_pers_id
8434: WHERE pe_person_id = cp_person_id
8435: AND person_id_type LIKE 'SSN'
8436: AND SYSDATE BETWEEN start_dt AND NVL(end_dt,SYSDATE);
8437: l_ssn c_ssn%ROWTYPE;