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_PE_PERSON_PKG dependencies on HZ_PARTIES

Line 50: x_hz_parties_ovn IN NUMBER,

46: x_email_addr IN VARCHAR2,
47: x_level_of_qual_id IN NUMBER,
48: x_military_service_reg IN VARCHAR2,
49: x_veteran IN VARCHAR2,
50: x_hz_parties_ovn IN NUMBER,
51: x_status IN VARCHAR2,
52: x_attribute_category IN VARCHAR2,
53: x_attribute1 IN VARCHAR2,
54: x_attribute2 IN VARCHAR2,

Line 184: new_references.object_version_number := x_hz_parties_ovn;

180: new_references.email_addr := x_email_addr;
181: new_references.level_of_qual_id := x_level_of_qual_id;
182: new_references.military_service_reg := x_military_service_reg;
183: new_references.veteran := x_veteran;
184: new_references.object_version_number := x_hz_parties_ovn;
185: new_references.status := x_status;
186: new_references.attribute_category := x_attribute_category;
187: new_references.attribute1 := x_attribute1;
188: new_references.attribute2 := x_attribute2;

Line 259: CURSOR cur_rowid(cp_person_id hz_parties.party_id%TYPE) IS

255: sraj 2000/05/05 the table structure has been changed
256: mmkumar 18-Jul-2005 added a new parameter x_oss_org_unit_cd for party_number impact
257: (reverse chronological order - newest change first)
258: ***************************************************************/
259: CURSOR cur_rowid(cp_person_id hz_parties.party_id%TYPE) IS
260: SELECT rowid
261: FROM hz_parties
262: WHERE party_id = cp_person_id;
263:

Line 261: FROM hz_parties

257: (reverse chronological order - newest change first)
258: ***************************************************************/
259: CURSOR cur_rowid(cp_person_id hz_parties.party_id%TYPE) IS
260: SELECT rowid
261: FROM hz_parties
262: WHERE party_id = cp_person_id;
263:
264: lv_rowid cur_rowid%ROWTYPE;
265:

Line 266: CURSOR chk_igs_pe_hz_party(cp_person_id hz_parties.party_id%TYPE) is

262: WHERE party_id = cp_person_id;
263:
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:

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 364: x_hz_parties_ovn IN NUMBER,

360: x_email_addr IN VARCHAR2,
361: x_level_of_qual_id IN NUMBER,
362: x_military_service_reg IN VARCHAR2,
363: x_veteran IN VARCHAR2,
364: x_hz_parties_ovn IN NUMBER,
365: x_status IN VARCHAR2,
366: x_attribute_category IN VARCHAR2,
367: x_attribute1 IN VARCHAR2,
368: x_attribute2 IN VARCHAR2,

Line 437: x_hz_parties_ovn,

433: x_email_addr,
434: x_level_of_qual_id,
435: x_military_service_reg,
436: x_veteran,
437: x_hz_parties_ovn,
438: x_status,
439: x_attribute_category,
440: x_attribute1,
441: x_attribute2,

Line 549: x_HZ_PARTIES_OVN IN OUT NOCOPY NUMBER,

545: x_EMAIL_ADDR IN VARCHAR2,
546: x_LEVEL_OF_QUAL_ID IN NUMBER,
547: x_MILITARY_SERVICE_REG IN VARCHAR2,
548: x_VETERAN IN VARCHAR2,
549: x_HZ_PARTIES_OVN IN OUT NOCOPY NUMBER,
550: x_ATTRIBUTE_CATEGORY IN VARCHAR2,
551: x_ATTRIBUTE1 IN VARCHAR2,
552: x_ATTRIBUTE2 IN VARCHAR2,
553: x_ATTRIBUTE3 IN VARCHAR2,

Line 602: CURSOR c_pe_rowid (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS

598: ln_type_instance_id IGS_PE_TYP_INSTANCES.TYPE_INSTANCE_ID%TYPE;
599: x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;
600: lv_Person_Type_Code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
601:
602: CURSOR c_pe_rowid (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
603: SELECT ROWID
604: FROM HZ_PARTIES
605: WHERE party_id = cp_person_id ;
606:

Line 604: FROM HZ_PARTIES

600: lv_Person_Type_Code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
601:
602: CURSOR c_pe_rowid (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
603: SELECT ROWID
604: FROM HZ_PARTIES
605: WHERE party_id = cp_person_id ;
606:
607: -- AND party_number = cp_person_number; -- ssawhney 2203778 this is not required, party no is the primary key.
608:

Line 625: l_person_number hz_parties.party_number%TYPE ;

621:
622: -- Cursor to check if automatic customer numbering is ON/OFF. (tray,18-04-2001)
623: -- removed from OSS, SWCR008 : 2225917 : ssawhney
624:
625: l_person_number hz_parties.party_number%TYPE ;
626: -- new parameter, this is the out NOCOPY parameter from hz_cust_account pub
627: -- ssawhney 2203778. HZ F api doesnt return the out NOCOPY parameter person_number
628: -- if its already passed. Bug with HZ F
629: BEGIN

Line 661: x_hz_parties_ovn =>x_HZ_PARTIES_OVN,

657: x_email_addr=>X_EMAIL_ADDR,
658: x_level_of_qual_id =>X_LEVEL_OF_QUAL_ID,
659: x_military_service_reg=>X_MILITARY_SERVICE_REG,
660: x_veteran=>X_VETERAN,
661: x_hz_parties_ovn =>x_HZ_PARTIES_OVN,
662: x_status => x_status,
663: x_attribute_category=>X_ATTRIBUTE_CATEGORY,
664: x_attribute1=>X_ATTRIBUTE1,
665: x_attribute2=>X_ATTRIBUTE2,

Line 724: x_HZ_PARTIES_OVN := 1;

720:
721:
722: v_person_rec.party_rec.PARTY_ID := X_PERSON_ID;
723: v_person_rec.party_rec.PARTY_number := X_PERSON_number;
724: x_HZ_PARTIES_OVN := 1;
725:
726:
727: -- Code to resolve Design issue for bug#1700178 (tray,18-04-2001)
728: -- removed that code SSAWHNEY : 2225917

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 874: x_HZ_PARTIES_OVN IN OUT NOCOPY NUMBER,

870: x_EMAIL_ADDR IN VARCHAR2,
871: x_LEVEL_OF_QUAL_ID IN NUMBER,
872: x_MILITARY_SERVICE_REG IN VARCHAR2,
873: x_VETERAN IN VARCHAR2,
874: x_HZ_PARTIES_OVN IN OUT NOCOPY NUMBER,
875: x_ATTRIBUTE_CATEGORY IN VARCHAR2,
876: x_ATTRIBUTE1 IN VARCHAR2,
877: x_ATTRIBUTE2 IN VARCHAR2,
878: x_ATTRIBUTE3 IN VARCHAR2,

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 969: x_hz_parties_ovn =>x_HZ_PARTIES_OVN,

965: x_email_addr=>X_EMAIL_ADDR,
966: x_level_of_qual_id =>X_LEVEL_OF_QUAL_ID,
967: x_military_service_reg=>X_MILITARY_SERVICE_REG,
968: x_veteran=>X_VETERAN,
969: x_hz_parties_ovn =>x_HZ_PARTIES_OVN,
970: x_status => x_status,
971: x_attribute_category=>NVL(X_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR),
972: x_attribute1=>NVL(X_ATTRIBUTE1,FND_API.G_MISS_CHAR),
973: x_attribute2=>NVL(X_ATTRIBUTE2,FND_API.G_MISS_CHAR),

Line 1015: p_party_object_version_number => x_hz_parties_ovn,

1011: v_person_rec.gender := NVL(x_sex,FND_API.G_MISS_CHAR);
1012:
1013:
1014: HZ_PARTY_V2PUB.UPDATE_PERSON (
1015: p_party_object_version_number => x_hz_parties_ovn,
1016: p_person_rec => v_person_rec,
1017: x_profile_id => x_profile_id,
1018: x_return_status =>x_return_status,
1019: x_msg_count => x_msg_count,

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,