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.

[Home] [Help]

APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on HZ_PARTIES

Line 97: l_chk_email hz_parties.email_address%TYPE;

93: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
94: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
95: l_return_status VARCHAR2(25);
96: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
97: l_chk_email hz_parties.email_address%TYPE;
98:
99: CURSOR c_chk_email_addr (cp_person_id hz_parties.party_id%TYPE)
100: IS
101: SELECT email_address

Line 99: CURSOR c_chk_email_addr (cp_person_id hz_parties.party_id%TYPE)

95: l_return_status VARCHAR2(25);
96: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
97: l_chk_email hz_parties.email_address%TYPE;
98:
99: CURSOR c_chk_email_addr (cp_person_id hz_parties.party_id%TYPE)
100: IS
101: SELECT email_address
102: FROM hz_parties
103: WHERE party_id = cp_person_id

Line 102: FROM hz_parties

98:
99: CURSOR c_chk_email_addr (cp_person_id hz_parties.party_id%TYPE)
100: IS
101: SELECT email_address
102: FROM hz_parties
103: WHERE party_id = cp_person_id
104: AND email_address IS NOT NULL;
105:
106: BEGIN

Line 116: p_contact_points_rec.owner_table_name := 'HZ_PARTIES';

112: FETCH c_chk_email_addr INTO l_chk_email;
113: CLOSE c_chk_email_addr;
114:
115: p_contact_points_rec.contact_point_type := 'EMAIL';
116: p_contact_points_rec.owner_table_name := 'HZ_PARTIES';
117: p_contact_points_rec.owner_table_id := p_person_id;
118: p_contact_points_rec.content_source_type := 'USER_ENTERED';
119: p_contact_points_rec.created_by_module := 'IGF';
120: p_email_rec.email_format := 'MAILHTML';

Line 190: p_contact_points_rec.owner_table_name := 'HZ_PARTIES';

186: BEGIN
187:
188: IF g_cur_data.r_s_email_address IS NOT NULL THEN
189: p_contact_points_rec.contact_point_type := 'EMAIL';
190: p_contact_points_rec.owner_table_name := 'HZ_PARTIES';
191: p_contact_points_rec.owner_table_id := p_person_id;
192: p_contact_points_rec.content_source_type := 'USER_ENTERED';
193: p_contact_points_rec.created_by_module := 'IGF';
194: p_email_rec.email_format := 'MAILHTML';

Line 1591: ln_person_number hz_parties.party_number%TYPE;

1587: ln_msg_count NUMBER;
1588: lv_msg_data VARCHAR2(2000);
1589: lv_return_status VARCHAR2(1);
1590: lv_row_id VARCHAR2(30);
1591: ln_person_number hz_parties.party_number%TYPE;
1592: retcode NUMBER;
1593: errbuf VARCHAR2(300);
1594: l_object_version_number NUMBER;
1595: BEGIN

Line 1648: x_HZ_PARTIES_OVN => l_object_version_number,

1644: x_EMAIL_ADDR => cur_css_interface_rec.r_s_email_address,
1645: x_LEVEL_OF_QUAL_ID => NULL,
1646: x_MILITARY_SERVICE_REG => NULL,
1647: x_VETERAN => NULL,
1648: x_HZ_PARTIES_OVN => l_object_version_number,
1649: x_ATTRIBUTE_CATEGORY => NULL,
1650: x_ATTRIBUTE1 => NULL,
1651: x_ATTRIBUTE2 => NULL,
1652: x_ATTRIBUTE3 => NULL,

Line 3931: TYPE PersonIdTab IS TABLE OF hz_parties.party_id%TYPE;

3927: || (reverse chronological order - newest change first)
3928: */
3929: -- table definition
3930: TYPE RecTab IS TABLE OF VARCHAR2(30);
3931: TYPE PersonIdTab IS TABLE OF hz_parties.party_id%TYPE;
3932: TYPE ssntab IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
3933: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;
3934: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
3935: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;

Line 3933: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;

3929: -- table definition
3930: TYPE RecTab IS TABLE OF VARCHAR2(30);
3931: TYPE PersonIdTab IS TABLE OF hz_parties.party_id%TYPE;
3932: TYPE ssntab IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
3933: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;
3934: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
3935: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
3936: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
3937: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;

Line 3934: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;

3930: TYPE RecTab IS TABLE OF VARCHAR2(30);
3931: TYPE PersonIdTab IS TABLE OF hz_parties.party_id%TYPE;
3932: TYPE ssntab IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
3933: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;
3934: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
3935: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
3936: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
3937: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;
3938: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;

Line 3935: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;

3931: TYPE PersonIdTab IS TABLE OF hz_parties.party_id%TYPE;
3932: TYPE ssntab IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
3933: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;
3934: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
3935: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
3936: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
3937: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;
3938: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;
3939: TYPE dobtab IS TABLE OF hz_person_profiles.date_of_birth%TYPE;

Line 3936: TYPE citytab IS TABLE OF hz_parties.city%TYPE;

3932: TYPE ssntab IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
3933: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;
3934: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
3935: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
3936: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
3937: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;
3938: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;
3939: TYPE dobtab IS TABLE OF hz_person_profiles.date_of_birth%TYPE;
3940: TYPE gendertab IS TABLE OF hz_person_profiles.gender%TYPE;

Line 3937: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;

3933: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;
3934: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
3935: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
3936: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
3937: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;
3938: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;
3939: TYPE dobtab IS TABLE OF hz_person_profiles.date_of_birth%TYPE;
3940: TYPE gendertab IS TABLE OF hz_person_profiles.gender%TYPE;
3941: TYPE totmatchscoretab IS TABLE OF NUMBER;

Line 3938: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;

3934: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
3935: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
3936: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
3937: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;
3938: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;
3939: TYPE dobtab IS TABLE OF hz_person_profiles.date_of_birth%TYPE;
3940: TYPE gendertab IS TABLE OF hz_person_profiles.gender%TYPE;
3941: TYPE totmatchscoretab IS TABLE OF NUMBER;
3942:

Line 4062: hz_parties hz,

4058: FROM igs_pe_alt_pers_id apii, igs_pe_person_id_typ pit
4059: WHERE apii.person_id_type = pit.person_id_type
4060: AND pit.s_person_id_type = 'SSN'
4061: AND SYSDATE BETWEEN apii.start_dt AND NVL (apii.end_dt, SYSDATE)) api,
4062: hz_parties hz,
4063: hz_person_profiles hp
4064: WHERE hz.party_id = api.pe_person_id(+)
4065: AND hz.party_id = hp.party_id
4066: AND hp.effective_end_date IS NULL

Line 4079: ppf.party_id person_id, -- party id maps to HZ_parties.party_id

4075:
4076: UNION
4077: --Source of SSN from HRMS
4078: SELECT 'HRM' rec_type,
4079: ppf.party_id person_id, -- party id maps to HZ_parties.party_id
4080: remove_spl_chr(ppf.national_identifier) prsn_ssn,
4081: hz.person_first_name firstname,
4082: hz.person_last_name lastname,
4083: hz.address1 address,

Line 4092: hz_parties hz,

4088: hp.gender gender
4089: FROM per_all_people_f ppf,
4090: per_business_groups_perf pbg,
4091: per_person_types ppt,
4092: hz_parties hz,
4093: hz_person_profiles hp
4094: WHERE IGS_EN_GEN_001.Check_HRMS_Installed = 'Y'
4095: AND pbg.legislation_code = 'US'
4096: AND ppt.system_person_type = 'EMP'