DBA Data[Home] [Help]

APPS.IGS_AD_IMP_002 dependencies on IGS_PE_HZ_PARTIES_PKG

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