eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_002 dependencies on IGS_PE_HZ_PARTIES

Line 236: CURSOR pe_hz_parties_cur(cp_person_id igs_pe_hz_parties.party_id%TYPE) IS

232: SELECT PERSON_ID_TYPE
233: FROM IGS_PE_PERSON_ID_TYP
234: WHERE PREFERRED_IND ='Y';
235:
236: CURSOR pe_hz_parties_cur(cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
237: SELECT pehz.ROWID, pehz.*
238: FROM IGS_PE_HZ_PARTIES pehz
239: WHERE party_id = cp_person_id;
240:

Line 238: FROM IGS_PE_HZ_PARTIES pehz

234: WHERE PREFERRED_IND ='Y';
235:
236: CURSOR pe_hz_parties_cur(cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
237: SELECT pehz.ROWID, pehz.*
238: FROM IGS_PE_HZ_PARTIES pehz
239: WHERE party_id = cp_person_id;
240:
241: l_pref_altid_type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
242: l_pref_altid p_person_rec.PREF_ALTERNATE_ID%TYPE;

Line 490: IGS_PE_HZ_PARTIES_PKG.UPDATE_ROW(

486: OPEN pe_hz_parties_cur(l_person_id);
487: FETCH pe_hz_parties_cur INTO tlinfo2;
488:
489: IF pe_hz_parties_cur%FOUND THEN
490: IGS_PE_HZ_PARTIES_PKG.UPDATE_ROW(
491: X_ROWID => tlinfo2.ROWID,
492: X_PARTY_ID => tlinfo2.party_id,
493: X_DECEASED_IND => tlinfo2.deceased_ind,
494: X_ARCHIVE_EXCLUSION_IND => tlinfo2.archive_exclusion_ind,

Line 1044: || mmkumar 19-JUL-2005 passed NULL for x_oss_org_unit_cd in add_row call to igs_pe_hz_parties_pkg,

1040: || Added commit after the processing each person record.
1041: || vrathi 25-jun-2003 Bug No:3019813
1042: || Added check to set error code and status if the person already exists in HR
1043: || asbala 12-APR-2004 3313276: Use lookup_type HZ_GENDER to validate Gender
1044: || mmkumar 19-JUL-2005 passed NULL for x_oss_org_unit_cd in add_row call to igs_pe_hz_parties_pkg,
1045: || (reverse chronological order - newest change first)
1046: */
1047:
1048: l_miss_person_rec HZ_PARTY_V2PUB.person_rec_TYPE;

Line 1143: igs_pe_hz_parties pd,

1139: p.status,
1140: pd.felony_convicted_flag
1141: FROM
1142: hz_parties p,
1143: igs_pe_hz_parties pd,
1144: hz_person_profiles pp,
1145: igs_pe_person_id_type_v pit
1146: WHERE p.party_id = cp_person_id
1147: AND p.party_id = pit.pe_person_id (+)

Line 1165: CURSOR pe_hz_parties_cur(cp_person_id igs_pe_hz_parties.party_id%TYPE) IS

1161: SELECT PERSON_ID_TYPE
1162: FROM IGS_PE_PERSON_ID_TYP
1163: WHERE PREFERRED_IND ='Y';
1164:
1165: CURSOR pe_hz_parties_cur(cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
1166: SELECT pehz.ROWID, pehz.*
1167: FROM IGS_PE_HZ_PARTIES pehz
1168: WHERE party_id = cp_person_id;
1169:

Line 1167: FROM IGS_PE_HZ_PARTIES pehz

1163: WHERE PREFERRED_IND ='Y';
1164:
1165: CURSOR pe_hz_parties_cur(cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
1166: SELECT pehz.ROWID, pehz.*
1167: FROM IGS_PE_HZ_PARTIES pehz
1168: WHERE party_id = cp_person_id;
1169:
1170: CURSOR hz_parties_cur(cp_person_id hz_parties.party_id%TYPE)IS
1171: SELECT last_update_date, ROWID

Line 1179: lv_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;

1175: l_pref_altid_type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
1176: l_pref_altid p_person_rec.PREF_ALTERNATE_ID%TYPE;
1177: tlinfo2 pe_hz_parties_cur%ROWTYPE;
1178: c_null_hdlg_per_rec c_null_hdlg_per_cur%ROWTYPE;
1179: lv_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
1180:
1181: l_location_Id NUMBER;
1182: l_rowid VARCHAR2(25);
1183: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;

Line 1454: IGS_PE_HZ_PARTIES_PKG.ADD_ROW(

1450: ELSE
1451: l_felony_convicted_flag := NVL(p_person_rec.felony_convicted_flag,tlinfo2.felony_convicted_flag);
1452: END IF;
1453:
1454: IGS_PE_HZ_PARTIES_PKG.ADD_ROW(
1455: X_ROWID => tlinfo2.ROWID,
1456: X_PARTY_ID => p_person_id,
1457: X_DECEASED_IND => tlinfo2.deceased_ind,
1458: X_ARCHIVE_EXCLUSION_IND => tlinfo2.archive_exclusion_ind,

Line 3065: igs_pe_hz_parties pd,

3061: pp.gender sex,
3062: pp.date_of_birth birth_dt
3063: FROM
3064: hz_parties p,
3065: igs_pe_hz_parties pd,
3066: hz_person_profiles pp
3067: WHERE p.party_id = cp_person_id
3068: AND p.party_id = pd.party_id (+)
3069: AND p.party_id = pp.party_id

Line 3091: igs_pe_hz_parties pd,

3087: CURSOR discrepancy_exist_cur(cp_person_id igs_pe_person.person_id%TYPE,
3088: c_person_rec person_cur%ROWTYPE) IS
3089: SELECT 'X'
3090: FROM hz_parties p,
3091: igs_pe_hz_parties pd,
3092: hz_person_profiles pp,
3093: igs_pe_person_id_type_v pit
3094: WHERE p.party_id = cp_person_id
3095: AND p.party_id = pit.pe_person_id (+)