APPS.IGS_PE_PERSON_PKG dependencies on IGS_PE_HZ_PARTIES

Line 268: FROM igs_pe_hz_parties

264: lv_rowid cur_rowid%ROWTYPE;
265:
266: CURSOR chk_igs_pe_hz_party(cp_person_id hz_parties.party_id%TYPE) is
267: SELECT rowid
268: FROM igs_pe_hz_parties
269: WHERE party_id = cp_person_id;
270:
271: pehz_rowid varchar2(25);
272:

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

275: FETCH cur_rowid INTO lv_rowid;
276: IF (cur_rowid%FOUND) THEN
277: CLOSE cur_rowid;
278:
279: -- check if the person exits in teh IGS_PE_HZ_PARTIES
280: OPEN chk_igs_pe_hz_party(x_person_id);
281: FETCH chk_igs_pe_hz_party INTO pehz_rowid;
282:
283: -- if the person does not exist tehn insert with the minimum required data

Line 288: IGS_PE_HZ_PARTIES_PKG.INSERT_ROW(

284: IF (chk_igs_pe_hz_party%NOTFOUND) THEN
285:
286: pehz_rowid := null;
287:
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 731: IGS_PE_HZ_PARTIES_PKG.INSERT_ROW(

727: -- Code to resolve Design issue for bug#1700178 (tray,18-04-2001)
728: -- removed that code SSAWHNEY : 2225917
729: -- If party creation is successful, create records in OSS
730:
731: IGS_PE_HZ_PARTIES_PKG.INSERT_ROW(
732: X_ROWID => l_rowid,
733: X_PARTY_ID => X_PERSON_ID,
734: X_DECEASED_IND => new_references.deceased_ind,
735: X_ARCHIVE_EXCLUSION_IND => new_references.archive_exclusion_ind,

Line 932: FROM IGS_PE_HZ_PARTIES pehz

928: tlinfo c1%ROWTYPE;
929:
930: CURSOR c2 IS
931: SELECT pehz.ROWID, pehz.*
932: FROM IGS_PE_HZ_PARTIES pehz
933: WHERE party_id = x_person_id;
934:
935: tlinfo2 c2%ROWTYPE;
936: l_tmp_var1 VARCHAR2(2000);

Line 1042: IGS_PE_HZ_PARTIES_PKG.UPDATE_ROW(

1038: FETCH c2 INTO tlinfo2;
1039:
1040: IF c2%FOUND THEN
1041:
1042: IGS_PE_HZ_PARTIES_PKG.UPDATE_ROW(
1043: X_ROWID => tlinfo2.ROWID,
1044: X_PARTY_ID => X_PERSON_ID,
1045: X_DECEASED_IND => new_references.deceased_ind,
1046: X_ARCHIVE_EXCLUSION_IND => new_references.archive_exclusion_ind,