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 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 243: tlinfo2 pe_hz_parties_cur%ROWTYPE;

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;
243: tlinfo2 pe_hz_parties_cur%ROWTYPE;
244: l_rowid VARCHAR2(25);
245: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;
246: l_person_number VARCHAR2(30);
247: l_PrefPersonIDType IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;

Line 454: x_hz_parties_ovn => l_object_version_number,

450: X_EMAIL_ADDR=> NULL,
451: X_LEVEL_OF_QUAL_ID => p_person_rec.level_of_qual_id,
452: X_MILITARY_SERVICE_REG=>NVL(p_person_rec.MILITARY_SERVICE_REG,'N'),
453: X_VETERAN=> NVL(p_person_rec.veteran,'VETERAN_NOT'), -- ssawhney 2203778, lookup_code
454: x_hz_parties_ovn => l_object_version_number,
455: X_attribute_CATEGORY => p_person_rec.attribute_category,
456: X_attribute1 => p_person_rec.attribute1,
457: X_attribute2 => p_person_rec.attribute2,
458: X_attribute3 => p_person_rec.attribute3,

Line 486: OPEN pe_hz_parties_cur(l_person_id);

482: X_attribute24 => p_person_rec.attribute24
483: );
484:
485: IF p_person_rec.birth_city IS NOT NULL OR p_person_rec.birth_country IS NOT NULL OR p_person_rec.felony_convicted_flag IS NOT NULL THEN
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(

Line 487: FETCH pe_hz_parties_cur INTO tlinfo2;

483: );
484:
485: IF p_person_rec.birth_city IS NOT NULL OR p_person_rec.birth_country IS NOT NULL OR p_person_rec.felony_convicted_flag IS NOT NULL THEN
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,

Line 489: IF pe_hz_parties_cur%FOUND THEN

485: IF p_person_rec.birth_city IS NOT NULL OR p_person_rec.birth_country IS NOT NULL OR p_person_rec.felony_convicted_flag IS NOT NULL THEN
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,

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 526: CLOSE pe_hz_parties_cur;

522: X_felony_convicted_flag => p_person_rec.felony_convicted_flag,
523: X_MODE => 'R'
524: );
525: END IF;
526: CLOSE pe_hz_parties_cur;
527: END IF;
528:
529: IF (l_Return_Status IN ('E','U') ) THEN
530: ROLLBACK TO BEFORE_INSERT;

Line 570: IF pe_hz_parties_cur%ISOPEN THEN

566:
567: EXCEPTION WHEN OTHERS THEN
568: -- Person creation failed
569: ROLLBACK TO BEFORE_INSERT;
570: IF pe_hz_parties_cur%ISOPEN THEN
571: CLOSE pe_hz_parties_cur;
572: END IF;
573:
574: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

Line 571: CLOSE pe_hz_parties_cur;

567: EXCEPTION WHEN OTHERS THEN
568: -- Person creation failed
569: ROLLBACK TO BEFORE_INSERT;
570: IF pe_hz_parties_cur%ISOPEN THEN
571: CLOSE pe_hz_parties_cur;
572: END IF;
573:
574: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
575:

Line 747: x_hz_parties_ovn => l_object_version_number,

743: X_PRIMARY_CONTACT_ID => NULL,
744: X_PERSONAL_INCOME => NULL,
745: X_HEAD_OF_HOUSEHOLD_FLAG => NULL,
746: X_CONTENT_SOURCE_NUMBER => NULL,
747: x_hz_parties_ovn => l_object_version_number,
748: X_attribute_category => stat_rec.attribute_category,
749: X_attribute1 => stat_rec.attribute1 ,
750: X_attribute2 => stat_rec.attribute2 ,
751: X_attribute3 => stat_rec.attribute3 ,

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 1142: hz_parties p,

1138: p.object_version_number,
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

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 1170: CURSOR hz_parties_cur(cp_person_id 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
1172: FROM hz_parties
1173: WHERE party_id = cp_person_id;
1174:

Line 1172: FROM hz_parties

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
1172: FROM hz_parties
1173: WHERE party_id = cp_person_id;
1174:
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;

Line 1177: tlinfo2 pe_hz_parties_cur%ROWTYPE;

1173: WHERE party_id = cp_person_id;
1174:
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;

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 1324: OPEN hz_parties_cur(p_person_id);

1320: l_pref_altid := NULL;
1321: END IF;
1322:
1323:
1324: OPEN hz_parties_cur(p_person_id);
1325: FETCH hz_parties_cur INTO l_last_update_date, l_rowid;
1326: IF hz_parties_cur%NOTFOUND THEN
1327: IF l_enable_log = 'Y' THEN
1328: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E019','IGS_AD_INTERFACE_ALL');

Line 1325: FETCH hz_parties_cur INTO l_last_update_date, l_rowid;

1321: END IF;
1322:
1323:
1324: OPEN hz_parties_cur(p_person_id);
1325: FETCH hz_parties_cur INTO l_last_update_date, l_rowid;
1326: IF hz_parties_cur%NOTFOUND THEN
1327: IF l_enable_log = 'Y' THEN
1328: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E019','IGS_AD_INTERFACE_ALL');
1329: END IF;

Line 1326: IF hz_parties_cur%NOTFOUND THEN

1322:
1323:
1324: OPEN hz_parties_cur(p_person_id);
1325: FETCH hz_parties_cur INTO l_last_update_date, l_rowid;
1326: IF hz_parties_cur%NOTFOUND THEN
1327: IF l_enable_log = 'Y' THEN
1328: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E019','IGS_AD_INTERFACE_ALL');
1329: END IF;
1330:

Line 1335: CLOSE hz_parties_cur;

1331: UPDATE IGS_AD_INTERFACE_ALL
1332: SET ERROR_CODE = 'E019',
1333: STATUS = '3'
1334: WHERE INTERFACE_ID = P_Person_Rec.Interface_Id;
1335: CLOSE hz_parties_cur;
1336:
1337: RETURN;
1338: END IF;
1339: CLOSE hz_parties_cur;

Line 1339: CLOSE hz_parties_cur;

1335: CLOSE hz_parties_cur;
1336:
1337: RETURN;
1338: END IF;
1339: CLOSE hz_parties_cur;
1340:
1341: -- Validate the OSS extensible attributes
1342: validate_oss_ext_attr(p_person_rec,P_PERSON_ID,l_oss_ext_attr_val);
1343:

Line 1410: x_hz_parties_ovn => c_null_hdlg_per_rec.object_version_number,

1406: X_EMAIL_ADDR=> c_null_hdlg_per_rec.email_addr,
1407: X_LEVEL_OF_QUAL_ID => NVL(p_person_rec.level_of_qual_id,c_null_hdlg_per_rec.level_of_qual_id),
1408: X_MILITARY_SERVICE_REG=> NVL( p_person_rec.military_service_reg,c_null_hdlg_per_rec.military_service_reg),
1409: X_VETERAN=> NVL(p_person_rec.veteran,'VETERAN_NOT'), --ssawhney 2203778 lookup_code
1410: x_hz_parties_ovn => c_null_hdlg_per_rec.object_version_number,
1411: X_attribute_CATEGORY => NVL( p_person_rec.attribute_category,c_null_hdlg_per_rec.attribute_category),
1412: X_attribute1 => NVL(p_person_rec.attribute1,c_null_hdlg_per_rec.attribute1),
1413: X_attribute2 => NVL(p_person_rec.attribute2,c_null_hdlg_per_rec.attribute2),
1414: X_attribute3 => NVL(p_person_rec.attribute3,c_null_hdlg_per_rec.attribute3),

Line 1444: OPEN pe_hz_parties_cur(p_person_id);

1440: IF p_person_rec.level_of_qual_id IS NOT NULL OR p_person_rec.proof_of_ins IS NOT NULL OR p_person_rec.proof_of_immu IS NOT NULL OR
1441: p_person_rec.military_service_reg IS NOT NULL OR p_person_rec.veteran IS NOT NULL OR p_person_rec.birth_city IS NOT NULL OR
1442: p_person_rec.birth_country IS NOT NULL OR p_person_rec.felony_convicted_flag IS NOT NULL THEN
1443:
1444: OPEN pe_hz_parties_cur(p_person_id);
1445: FETCH pe_hz_parties_cur INTO tlinfo2;
1446: CLOSE pe_hz_parties_cur;
1447:
1448: IF p_person_rec.felony_convicted_flag = FND_API.G_MISS_CHAR THEN

Line 1445: FETCH pe_hz_parties_cur INTO tlinfo2;

1441: p_person_rec.military_service_reg IS NOT NULL OR p_person_rec.veteran IS NOT NULL OR p_person_rec.birth_city IS NOT NULL OR
1442: p_person_rec.birth_country IS NOT NULL OR p_person_rec.felony_convicted_flag IS NOT NULL THEN
1443:
1444: OPEN pe_hz_parties_cur(p_person_id);
1445: FETCH pe_hz_parties_cur INTO tlinfo2;
1446: CLOSE pe_hz_parties_cur;
1447:
1448: IF p_person_rec.felony_convicted_flag = FND_API.G_MISS_CHAR THEN
1449: l_felony_convicted_flag := NULL;

Line 1446: CLOSE pe_hz_parties_cur;

1442: p_person_rec.birth_country IS NOT NULL OR p_person_rec.felony_convicted_flag IS NOT NULL THEN
1443:
1444: OPEN pe_hz_parties_cur(p_person_id);
1445: FETCH pe_hz_parties_cur INTO tlinfo2;
1446: CLOSE pe_hz_parties_cur;
1447:
1448: IF p_person_rec.felony_convicted_flag = FND_API.G_MISS_CHAR THEN
1449: l_felony_convicted_flag := NULL;
1450: ELSE

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 1496: IF pe_hz_parties_cur%ISOPEN THEN

1492: WHEN OTHERS THEN
1493:
1494: ROLLBACK TO BEFORE_UPDATE;
1495:
1496: IF pe_hz_parties_cur%ISOPEN THEN
1497: CLOSE pe_hz_parties_cur;
1498: END IF;
1499: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
1500:

Line 1497: CLOSE pe_hz_parties_cur;

1493:
1494: ROLLBACK TO BEFORE_UPDATE;
1495:
1496: IF pe_hz_parties_cur%ISOPEN THEN
1497: CLOSE pe_hz_parties_cur;
1498: END IF;
1499: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
1500:
1501: IF l_message_name = 'IGS_PE_UNIQUE_PID' THEN

Line 3064: hz_parties p,

3060: pd.level_of_qual level_of_qual_id,
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 (+)

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 3090: FROM hz_parties p,

3086: --Cursor for record level Review
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

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 (+)