DBA Data[Home] [Help]

APPS.IGS_AD_IMP_007 dependencies on IGS_PE_ALT_PERS_ID_PKG

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 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),