APPS.IGS_AD_SS_PERSON_PKG dependencies on IGS_PE_HZ_PARTIES

Line 274: FROM igs_pe_hz_parties

270: WHERE p.party_id = x_person_id;
271: lv_rowid cur_rowid%ROWTYPE;
272: CURSOR chk_igs_pe_hz_party is
273: SELECT rowid
274: FROM igs_pe_hz_parties
275: WHERE party_id = x_person_id;
276: pehz_rowid varchar2(25);
277: BEGIN
278: OPEN cur_rowid;

Line 282: -- check if the person exits in teh IGS_PE_HZ_PARTIES

278: OPEN cur_rowid;
279: FETCH cur_rowid INTO lv_rowid;
280: IF (cur_rowid%FOUND) THEN
281: CLOSE cur_rowid;
282: -- check if the person exits in teh IGS_PE_HZ_PARTIES
283: OPEN chk_igs_pe_hz_party;
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

Line 288: IGS_PE_HZ_PARTIES_PKG.INSERT_ROW(

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,

Line 677: IGS_PE_HZ_PARTIES_PKG.INSERT_ROW(

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,

Line 884: FROM IGS_PE_HZ_PARTIES pehz

880: tlinfo c1%ROWTYPE;
881:
882: CURSOR c2 IS
883: SELECT pehz.ROWID, pehz.*
884: FROM IGS_PE_HZ_PARTIES pehz
885: WHERE party_id = x_person_id;
886: tlinfo2 c2%ROWTYPE;
887:
888: tmp_var1 VARCHAR2(2000);

Line 986: IGS_PE_HZ_PARTIES_PKG.ADD_ROW(

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,