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

Line 67: x_hz_parties_ovn IN NUMBER,

63: X_primary_contact_id IN NUMBER ,--DEFAULT NULL,
64: X_personal_income IN NUMBER ,--DEFAULT NULL,
65: X_head_of_household_flag IN VARCHAR2 ,--DEFAULT NULL,
66: X_content_source_number IN VARCHAR2 ,--DEFAULT NULL,
67: x_hz_parties_ovn IN NUMBER,
68: X_ATTRIBUTE_CATEGORY IN VARCHAR2,-- DEFAULT NULL,
69: X_ATTRIBUTE1 IN VARCHAR2 ,-- DEFAULT NULL,
70: X_ATTRIBUTE2 IN VARCHAR2 ,--DEFAULT NULL,
71: X_ATTRIBUTE3 IN VARCHAR2 ,--DEFAULT NULL,

Line 182: new_references.object_version_number :=X_HZ_PARTIES_OVN;

178: new_references.primary_contact_id :=X_PRIMARY_CONTACT_ID;
179: new_references.personal_income :=X_PERSONAL_INCOME;
180: new_references.head_of_household_flag :=X_HEAD_OF_HOUSEHOLD_FLAG;
181: new_references.content_source_number :=X_CONTENT_SOURCE_NUMBER;
182: new_references.object_version_number :=X_HZ_PARTIES_OVN;
183: new_references.ATTRIBUTE_CATEGORY :=X_ATTRIBUTE_CATEGORY;
184: new_references.ATTRIBUTE1 :=X_ATTRIBUTE1;
185: new_references.ATTRIBUTE2 :=X_ATTRIBUTE2;
186: new_references.ATTRIBUTE3 :=X_ATTRIBUTE3;

Line 274: x_hz_parties_ovn IN NUMBER,

270: X_primary_contact_id IN NUMBER,-- DEFAULT NULL,
271: X_personal_income IN NUMBER,-- DEFAULT NULL,
272: X_head_of_household_flag IN VARCHAR2,-- DEFAULT NULL,
273: X_content_source_number IN VARCHAR2,-- DEFAULT NULL,
274: x_hz_parties_ovn IN NUMBER,
275: X_ATTRIBUTE_CATEGORY IN VARCHAR2,-- DEFAULT NULL,
276: X_ATTRIBUTE1 IN VARCHAR2,-- DEFAULT NULL,
277: X_ATTRIBUTE2 IN VARCHAR2,-- DEFAULT NULL,
278: X_ATTRIBUTE3 IN VARCHAR2,-- DEFAULT NULL,

Line 372: x_hz_parties_ovn,

368: X_primary_contact_id ,
369: X_personal_income ,
370: X_head_of_household_flag,
371: X_content_source_number ,
372: x_hz_parties_ovn,
373: X_ATTRIBUTE_CATEGORY ,
374: X_ATTRIBUTE1 ,
375: X_ATTRIBUTE2 ,
376: X_ATTRIBUTE3 ,

Line 474: x_hz_parties_ovn IN OUT NOCOPY NUMBER,

470: X_primary_contact_id IN NUMBER ,
471: X_personal_income IN NUMBER ,
472: X_head_of_household_flag IN VARCHAR2 ,
473: X_content_source_number IN VARCHAR2 ,
474: x_hz_parties_ovn IN OUT NOCOPY NUMBER,
475: X_ATTRIBUTE_CATEGORY IN VARCHAR2 ,
476: X_ATTRIBUTE1 IN VARCHAR2 ,
477: X_ATTRIBUTE2 IN VARCHAR2 ,
478: X_ATTRIBUTE3 IN VARCHAR2 ,

Line 594: x_hz_parties_ovn =>X_HZ_PARTIES_OVN,

590: X_primary_contact_id =>X_PRIMARY_CONTACT_ID,
591: X_personal_income =>X_PERSONAL_INCOME,
592: X_head_of_household_flag =>X_HEAD_OF_HOUSEHOLD_FLAG,
593: X_content_source_number =>X_CONTENT_SOURCE_NUMBER,
594: x_hz_parties_ovn =>X_HZ_PARTIES_OVN,
595: X_ATTRIBUTE_CATEGORY =>X_ATTRIBUTE_CATEGORY,
596: X_ATTRIBUTE1 =>X_ATTRIBUTE1,
597: X_ATTRIBUTE2 =>X_ATTRIBUTE2,
598: X_ATTRIBUTE3 =>X_ATTRIBUTE3,

Line 674: p_party_object_version_number => x_hz_parties_ovn,

670: NVL(old_references.marital_status_effective_date,l_default_date) <> NVL(new_references.marital_status_effective_date,l_default_date) OR
671: NVL(old_references.place_of_birth,l_default_value) <> NVL(new_references.place_of_birth,l_default_value)) THEN
672:
673: Hz_Party_v2Pub.update_person(
674: p_party_object_version_number => x_hz_parties_ovn,
675: P_PERSON_REC => LV_PERSON_REC_TYPE,
676: X_PROFILE_ID => Z_PROFILE_ID,
677: X_RETURN_STATUS => Z_RETURN_STATUS,
678: X_MSG_COUNT =>Z_MSG_COUNT,

Line 788: x_hz_parties_ovn IN OUT NOCOPY NUMBER,

784: X_primary_contact_id IN NUMBER ,
785: X_personal_income IN NUMBER ,
786: X_head_of_household_flag IN VARCHAR2 ,
787: X_content_source_number IN VARCHAR2 ,
788: x_hz_parties_ovn IN OUT NOCOPY NUMBER,
789: X_ATTRIBUTE_CATEGORY IN VARCHAR2 ,
790: X_ATTRIBUTE1 IN VARCHAR2 ,
791: X_ATTRIBUTE2 IN VARCHAR2 ,
792: X_ATTRIBUTE3 IN VARCHAR2 ,

Line 879: hz_parties hp

875: LV_PARTY_REC_TYPE Hz_Party_V2Pub.PARTY_REC_TYPE;
876: CURSOR party_cur IS
877: SELECT hp.last_update_date , xx.effective_start_date
878: FROM hz_person_profiles xx ,
879: hz_parties hp
880: WHERE xx.party_id = X_person_id AND
881: hp.party_id = xx.party_id AND
882: TRUNC(SYSDATE) BETWEEN TRUNC(xx.effective_start_date) AND
883: NVL(xx.effective_end_date, TO_DATE('12/31/4712','MM/DD/YYYY'));

Line 927: x_hz_parties_ovn => X_HZ_PARTIES_OVN,

923: X_primary_contact_id =>X_PRIMARY_CONTACT_ID,
924: X_personal_income =>X_PERSONAL_INCOME,
925: X_head_of_household_flag =>X_HEAD_OF_HOUSEHOLD_FLAG,
926: X_content_source_number =>X_CONTENT_SOURCE_NUMBER,
927: x_hz_parties_ovn => X_HZ_PARTIES_OVN,
928: X_ATTRIBUTE_CATEGORY =>X_ATTRIBUTE_CATEGORY,
929: X_ATTRIBUTE1 =>X_ATTRIBUTE1,
930: X_ATTRIBUTE2 =>X_ATTRIBUTE2,
931: X_ATTRIBUTE3 =>X_ATTRIBUTE3,

Line 1006: p_party_object_version_number => x_hz_parties_ovn ,

1002: NVL(old_references.marital_status_effective_date,l_default_date) <> NVL(new_references.marital_status_effective_date,l_default_date) OR
1003: NVL(old_references.place_of_birth,l_default_value) <> NVL(new_references.place_of_birth,l_default_value)) THEN
1004:
1005: Hz_Party_V2Pub.update_person(
1006: p_party_object_version_number => x_hz_parties_ovn ,
1007: P_PERSON_REC => LV_PERSON_REC_TYPE,
1008: X_PROFILE_ID => Z_PROFILE_ID,
1009: X_RETURN_STATUS => Z_RETURN_STATUS,
1010: X_MSG_COUNT =>Z_MSG_COUNT,