APPS.IGS_AD_IMP_007 dependencies on IGS_PE_ALT_PERS_ID

Line 1909: FROM igs_pe_alt_pers_id pi

1905: AND i.status = '1';
1906:
1907: CURSOR check_dur_cur(api_rec api%ROWTYPE) IS
1908: SELECT ROWID,pi.*
1909: FROM igs_pe_alt_pers_id pi
1910: WHERE pe_person_id = api_rec.person_id
1911: AND api_person_id = api_rec.alternate_id
1912: AND UPPER(person_id_type) = UPPER(api_rec.person_id_type)
1913: AND TRUNC(start_dt) = TRUNC(api_rec.start_dt);

Line 1999: p_desc_flex_name =>'IGS_PE_ALT_PERS_ID_FLEX' ) THEN

1995: p_attribute17 =>p_api_rec.attribute17 ,
1996: p_attribute18 =>p_api_rec.attribute18 ,
1997: p_attribute19 =>p_api_rec.attribute19 ,
1998: p_attribute20 =>p_api_rec.attribute20 ,
1999: p_desc_flex_name =>'IGS_PE_ALT_PERS_ID_FLEX' ) THEN
2000:
2001: l_error_code:='E255';
2002: RAISE NO_DATA_FOUND;
2003: END IF;

Line 2123: igs_pe_alt_pers_id_pkg.insert_row(

2119: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2120: END IF;
2121:
2122: SAVEPOINT before_api_insert;
2123: igs_pe_alt_pers_id_pkg.insert_row(
2124: X_ROWID =>l_rowid,
2125: X_PE_PERSON_ID =>p_api_rec.person_id,
2126: X_API_PERSON_ID =>p_api_rec.alternate_id,
2127: X_PERSON_ID_TYPE =>p_api_rec.person_id_type,

Line 2244: FROM igs_pe_alt_pers_id pe, igs_ad_interface_all ii

2240: match_ind = cst_mi_val_19
2241: WHERE mi.interface_run_id = l_interface_run_id
2242: AND mi.status = cst_stat_val_2
2243: AND EXISTS ( SELECT '1'
2244: FROM igs_pe_alt_pers_id pe, igs_ad_interface_all ii
2245: WHERE ii.interface_run_id = l_interface_run_id
2246: AND ii.interface_id = mi.interface_id
2247: AND ii.person_id = pe.pe_person_id
2248: AND UPPER(pe.api_person_id) = UPPER(mi.alternate_id)

Line 2282: FROM igs_pe_alt_pers_id pe, igs_ad_interface_all ii

2278: WHERE mi.interface_run_id = l_interface_run_id
2279: AND mi.match_ind IS NULL
2280: AND mi.status = cst_stat_val_2
2281: AND EXISTS ( SELECT '1'
2282: FROM igs_pe_alt_pers_id pe, igs_ad_interface_all ii
2283: WHERE ii.interface_run_id = l_interface_run_id
2284: AND ii.interface_id = mi.interface_id
2285: AND ii.person_id = pe.pe_person_id
2286: AND UPPER(pe.api_person_id) = UPPER(mi.alternate_id)

Line 2323: FROM igs_pe_alt_pers_id pe, igs_ad_interface_all ii

2319: WHERE mi.interface_run_id = l_interface_run_id
2320: AND mi.match_ind IS NULL
2321: AND mi.status = cst_stat_val_2
2322: AND EXISTS (SELECT '1'
2323: FROM igs_pe_alt_pers_id pe, igs_ad_interface_all ii
2324: WHERE mi.interface_run_id = l_interface_run_id
2325: AND ii.interface_id = mi.interface_id
2326: AND ii.person_id = pe.pe_person_id
2327: AND UPPER(pe.api_person_id) = UPPER(mi.alternate_id)

Line 2395: igs_pe_alt_pers_id_pkg.update_row(

2391: IF api_rec.match_ind = '21' THEN
2392: BEGIN
2393: SAVEPOINT before_api_update;
2394:
2395: igs_pe_alt_pers_id_pkg.update_row(
2396: x_rowid =>check_dur_rec.rowid,
2397: x_pe_person_id =>check_dur_rec.pe_person_id,
2398: x_api_person_id =>check_dur_rec.api_person_id,
2399: x_person_id_type =>NVL(api_rec.person_id_type,check_dur_rec.person_id_type),

Line 2487: igs_pe_alt_pers_id_pkg.update_row(

2483: ELSIF l_rule = 'I' THEN
2484: BEGIN
2485: SAVEPOINT before_api_update;
2486:
2487: igs_pe_alt_pers_id_pkg.update_row(
2488: x_rowid =>check_dur_rec.rowid,
2489: x_pe_person_id =>check_dur_rec.pe_person_id,
2490: x_api_person_id =>check_dur_rec.api_person_id,
2491: x_person_id_type =>NVL(api_rec.person_id_type,check_dur_rec.person_id_type),