284: FETCH chk_igs_pe_hz_party INTO pehz_rowid;
285: -- if the person does not exist tehn insert with the minimum required data
286: IF (chk_igs_pe_hz_party%NOTFOUND) THEN
287: pehz_rowid := null;
288: IGS_PE_HZ_PARTIES_PKG.INSERT_ROW(
289: X_ROWID => pehz_rowid,
290: X_PARTY_ID => X_PERSON_ID,
291: X_DECEASED_IND => NULL,
292: X_ARCHIVE_EXCLUSION_IND => NULL,
673: v_person_rec.party_rec.PARTY_ID := X_PERSON_ID;
674: v_person_rec.party_rec.PARTY_number := X_PERSON_number;
675:
676:
677: IGS_PE_HZ_PARTIES_PKG.INSERT_ROW(
678: X_ROWID => l_rowid,
679: X_PARTY_ID => X_PERSON_ID,
680: X_DECEASED_IND => new_references.deceased_ind,
681: X_ARCHIVE_EXCLUSION_IND => new_references.archive_exclusion_ind,
982:
983: IF X_RETURN_STATUS NOT IN ('E','U') THEN
984: OPEN c2;
985: FETCH c2 INTO tlinfo2;
986: IGS_PE_HZ_PARTIES_PKG.ADD_ROW(
987: X_ROWID => tlinfo2.ROWID,
988: X_PARTY_ID => X_PERSON_ID,
989: X_DECEASED_IND => new_references.deceased_ind,
990: X_ARCHIVE_EXCLUSION_IND => new_references.archive_exclusion_ind,