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

Line 2048: FROM hz_parties

2044: l_parameter_list_t wf_parameter_list_t;
2045:
2046: CURSOR person_dtls_cur(cp_person_id NUMBER) IS
2047: SELECT party_number
2048: FROM hz_parties
2049: WHERE party_id = cp_person_id;
2050:
2051: l_person_num hz_parties.party_number%TYPE;
2052:

Line 2051: l_person_num hz_parties.party_number%TYPE;

2047: SELECT party_number
2048: FROM hz_parties
2049: WHERE party_id = cp_person_id;
2050:
2051: l_person_num hz_parties.party_number%TYPE;
2052:
2053: CURSOR get_fa_rec_verif_stat (pn_base_id NUMBER) IS
2054: SELECT fed_verif_status
2055: FROM igf_ap_fa_base_rec_all

Line 2181: FROM hz_parties

2177: l_parameter_list_t wf_parameter_list_t;
2178:
2179: CURSOR person_dtls_cur(cp_person_id NUMBER) IS
2180: SELECT party_number
2181: FROM hz_parties
2182: WHERE party_id = cp_person_id;
2183:
2184: l_person_num hz_parties.party_number%TYPE;
2185:

Line 2184: l_person_num hz_parties.party_number%TYPE;

2180: SELECT party_number
2181: FROM hz_parties
2182: WHERE party_id = cp_person_id;
2183:
2184: l_person_num hz_parties.party_number%TYPE;
2185:
2186: BEGIN
2187:
2188: l_seq_val := 'DATACHNG'|| TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'); -- for unique identification

Line 2326: CURSOR cur_chk_email_addr (cp_person_id hz_parties.party_id%TYPE)

2322: || (reverse chronological order - newest change first)
2323: */
2324:
2325:
2326: CURSOR cur_chk_email_addr (cp_person_id hz_parties.party_id%TYPE)
2327: IS
2328: SELECT 'Y' is_email_exists, email_address
2329: FROM hz_parties
2330: WHERE party_id = cp_person_id

Line 2329: FROM hz_parties

2325:
2326: CURSOR cur_chk_email_addr (cp_person_id hz_parties.party_id%TYPE)
2327: IS
2328: SELECT 'Y' is_email_exists, email_address
2329: FROM hz_parties
2330: WHERE party_id = cp_person_id
2331: AND email_address IS NOT NULL;
2332:
2333: l_chk_email cur_chk_email_addr%ROWTYPE;

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

2370: CLOSE cur_chk_email_addr;
2371:
2372: -- initialize rec variables
2373: p_contact_points_rec.contact_point_type := 'EMAIL';
2374: p_contact_points_rec.owner_table_name := 'HZ_PARTIES';
2375: p_contact_points_rec.owner_table_id := p_person_id;
2376: p_contact_points_rec.content_source_type := 'USER_ENTERED';
2377: p_contact_points_rec.created_by_module := 'IGF';
2378: p_email_rec.email_format := 'MAILHTML';

Line 2499: FROM hz_parties

2495: city,
2496: postal_code,
2497: state,
2498: email_address
2499: FROM hz_parties
2500: WHERE party_id = ln_person_id;
2501:
2502: hzparties_rec hzparties_cur%ROWTYPE;
2503:

Line 2531: ln_person_number hz_parties.party_number%TYPE;

2527: AND lookup_code = cp_lkup_cd
2528: AND enabled_flag = 'Y';
2529:
2530:
2531: ln_person_number hz_parties.party_number%TYPE;
2532: ln_person_id igf_ap_fa_base_rec.person_id%TYPE;
2533: lv_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
2534: alt_person_id_rec alt_person_id_cur%ROWTYPE;
2535: ln_msg_count NUMBER;

Line 2751: FROM hz_parties p

2747:
2748: CURSOR cur_per_det (p_party_id NUMBER, p_party_type VARCHAR2) IS
2749: SELECT p.party_number person_number,
2750: p.person_first_name given_names
2751: FROM hz_parties p
2752: WHERE p.party_id = p_party_id
2753: AND p.party_type = p_party_type;
2754:
2755:

Line 3338: ln_person_number hz_parties.party_number%TYPE;

3334: AND enabled_flag = 'Y';
3335:
3336:
3337: l_pers_id_typ VARCHAR2(30) ;
3338: ln_person_number hz_parties.party_number%TYPE;
3339: lv_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
3340: ln_msg_count NUMBER;
3341: lv_msg_data VARCHAR2(2000);
3342: lv_return_status VARCHAR2(1);

Line 3431: x_hz_parties_ovn => l_object_version_number,

3427: x_EMAIL_ADDR => g_isir_intrface_rec.s_email_address_txt,
3428: x_LEVEL_OF_QUAL_ID => NULL,
3429: x_MILITARY_SERVICE_REG => NULL,
3430: x_VETERAN => NULL,
3431: x_hz_parties_ovn => l_object_version_number,
3432: x_ATTRIBUTE_CATEGORY => NULL,
3433: x_ATTRIBUTE1 => NULL,
3434: x_ATTRIBUTE2 => NULL,
3435: x_ATTRIBUTE3 => NULL,

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

4391: */
4392:
4393: -- table definition
4394: TYPE RecTab IS TABLE OF VARCHAR2(30);
4395: TYPE PersonIdTab IS TABLE OF hz_parties.party_id%TYPE;
4396: TYPE ssntab IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
4397: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;
4398: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
4399: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;

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

4393: -- table definition
4394: TYPE RecTab IS TABLE OF VARCHAR2(30);
4395: TYPE PersonIdTab IS TABLE OF hz_parties.party_id%TYPE;
4396: TYPE ssntab IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
4397: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;
4398: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
4399: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
4400: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
4401: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;

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

4394: TYPE RecTab IS TABLE OF VARCHAR2(30);
4395: TYPE PersonIdTab IS TABLE OF hz_parties.party_id%TYPE;
4396: TYPE ssntab IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
4397: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;
4398: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
4399: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
4400: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
4401: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;
4402: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;

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

4395: TYPE PersonIdTab IS TABLE OF hz_parties.party_id%TYPE;
4396: TYPE ssntab IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
4397: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;
4398: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
4399: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
4400: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
4401: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;
4402: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;
4403: TYPE dobtab IS TABLE OF hz_person_profiles.date_of_birth%TYPE;

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

4396: TYPE ssntab IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
4397: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;
4398: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
4399: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
4400: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
4401: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;
4402: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;
4403: TYPE dobtab IS TABLE OF hz_person_profiles.date_of_birth%TYPE;
4404: TYPE gendertab IS TABLE OF hz_person_profiles.gender%TYPE;

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

4397: TYPE firstnametab IS TABLE OF hz_parties.person_first_name%TYPE;
4398: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
4399: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
4400: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
4401: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;
4402: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;
4403: TYPE dobtab IS TABLE OF hz_person_profiles.date_of_birth%TYPE;
4404: TYPE gendertab IS TABLE OF hz_person_profiles.gender%TYPE;
4405: TYPE totmatchscoretab IS TABLE OF NUMBER;

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

4398: TYPE lastnametab IS TABLE OF hz_parties.person_last_name%TYPE;
4399: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
4400: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
4401: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;
4402: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;
4403: TYPE dobtab IS TABLE OF hz_person_profiles.date_of_birth%TYPE;
4404: TYPE gendertab IS TABLE OF hz_person_profiles.gender%TYPE;
4405: TYPE totmatchscoretab IS TABLE OF NUMBER;
4406:

Line 4516: hz_parties hz,

4512: FROM igs_pe_alt_pers_id apii, igs_pe_person_id_typ pit
4513: WHERE apii.person_id_type = pit.person_id_type
4514: AND pit.s_person_id_type = 'SSN'
4515: AND SYSDATE BETWEEN apii.start_dt AND NVL (apii.end_dt, SYSDATE)) api,
4516: hz_parties hz,
4517: hz_person_profiles hp
4518: WHERE hz.party_id = api.pe_person_id(+)
4519: AND hz.party_id = hp.party_id
4520: AND hp.effective_end_date IS NULL

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

4529:
4530: UNION
4531: --Source of SSN from HRMS
4532: SELECT 'HRM' rec_type,
4533: ppf.party_id person_id, -- party id maps to HZ_parties.party_id
4534: remove_spl_chr(ppf.national_identifier) prsn_ssn,
4535: hz.person_first_name firstname,
4536: hz.person_last_name lastname,
4537: hz.address1 address,

Line 4546: hz_parties hz,

4542: hp.gender gender
4543: FROM per_all_people_f ppf,
4544: per_business_groups_perf pbg,
4545: per_person_types ppt,
4546: hz_parties hz,
4547: hz_person_profiles hp
4548: WHERE IGS_EN_GEN_001.Check_HRMS_Installed = 'Y'
4549: AND pbg.legislation_code = 'US'
4550: AND ppt.system_person_type = 'EMP'

Line 6770: FROM hz_parties

6766:
6767:
6768: CURSOR person_cur (ln_person_id igf_ap_fa_base_rec.person_id%TYPE) IS
6769: SELECT party_number person_number
6770: FROM hz_parties
6771: WHERE party_id = ln_person_id;
6772:
6773: -- Get the privious Active ISIR id for the base id.
6774: CURSOR cur_old_active_isir(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS