APPS.IGS_AD_IMP_002 dependencies on IGS_PE_ALT_PERS_ID

Line 1803: p_desc_flex_name =>'IGS_PE_ALT_PERS_ID_FLEX' ) THEN

1799: p_attribute17 =>p_api_rec.attribute17 ,
1800: p_attribute18 =>p_api_rec.attribute18 ,
1801: p_attribute19 =>p_api_rec.attribute19 ,
1802: p_attribute20 =>p_api_rec.attribute20 ,
1803: p_desc_flex_name =>'IGS_PE_ALT_PERS_ID_FLEX' ) THEN
1804:
1805: p_error_code:='E255';
1806: RAISE NO_DATA_FOUND;
1807: END IF;

Line 1949: FROM IGS_PE_ALT_PERS_ID

1945: lnDupExist := 0;
1946: ELSE
1947: SELECT COUNT(*)
1948: INTO lnDupExist
1949: FROM IGS_PE_ALT_PERS_ID
1950: WHERE PE_PERSON_ID = P_PERSON_ID
1951: AND API_PERSON_ID = P_API_REC.ALTERNATE_ID
1952: AND PERSON_ID_TYPE = P_API_REC.PERSON_ID_TYPE
1953: AND TRUNC(START_DT) = l_start_dt;

Line 1961: Igs_Pe_Alt_Pers_Id_Pkg.insert_row(

1957:
1958: BEGIN
1959: SAVEPOINT before_insert;
1960:
1961: Igs_Pe_Alt_Pers_Id_Pkg.insert_row(
1962: X_ROWID => l_rowid,
1963: X_PE_PERSON_ID => P_PERSON_ID,
1964: X_API_PERSON_ID => p_api_rec.ALTERNATE_ID,
1965: X_PERSON_ID_TYPE => p_api_rec.PERSON_ID_TYPE,

Line 2043: CURSOR c_null_hdlg_alt_pers_cur(cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,

2039: END;
2040: ELSE
2041:
2042: DECLARE
2043: CURSOR c_null_hdlg_alt_pers_cur(cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
2044: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
2045: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE,
2046: cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE)IS
2047: SELECT api.rowid,api.*

Line 2044: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,

2040: ELSE
2041:
2042: DECLARE
2043: CURSOR c_null_hdlg_alt_pers_cur(cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
2044: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
2045: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE,
2046: cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE)IS
2047: SELECT api.rowid,api.*
2048: FROM igs_pe_alt_pers_id api

Line 2045: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE,

2041:
2042: DECLARE
2043: CURSOR c_null_hdlg_alt_pers_cur(cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
2044: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
2045: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE,
2046: cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE)IS
2047: SELECT api.rowid,api.*
2048: FROM igs_pe_alt_pers_id api
2049: WHERE pe_person_id = cp_person_id

Line 2046: cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE)IS

2042: DECLARE
2043: CURSOR c_null_hdlg_alt_pers_cur(cp_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
2044: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
2045: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE,
2046: cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE)IS
2047: SELECT api.rowid,api.*
2048: FROM igs_pe_alt_pers_id api
2049: WHERE pe_person_id = cp_person_id
2050: AND api_person_id = cp_api_person_id

Line 2048: FROM igs_pe_alt_pers_id api

2044: cp_person_id_type igs_pe_alt_pers_id.person_id_type%TYPE,
2045: cp_start_dt igs_pe_alt_pers_id.start_dt%TYPE,
2046: cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE)IS
2047: SELECT api.rowid,api.*
2048: FROM igs_pe_alt_pers_id api
2049: WHERE pe_person_id = cp_person_id
2050: AND api_person_id = cp_api_person_id
2051: AND person_id_type = cp_person_id_type
2052: AND TRUNC(start_dt) = cp_start_dt;

Line 2063: igs_pe_alt_pers_id_pkg.update_row(

2059: p_person_id);
2060: FETCH c_null_hdlg_alt_pers_cur INTO c_null_hdlg_alt_pers_cur_rec;
2061: CLOSE c_null_hdlg_alt_pers_cur;
2062:
2063: igs_pe_alt_pers_id_pkg.update_row(
2064: x_rowid =>c_null_hdlg_alt_pers_cur_rec.rowid,
2065: x_pe_person_id =>c_null_hdlg_alt_pers_cur_rec.pe_person_id,
2066: x_api_person_id =>c_null_hdlg_alt_pers_cur_rec.api_person_id,
2067: x_person_id_type => c_null_hdlg_alt_pers_cur_rec.person_id_type,