APPS.PER_HRTCA_MERGE dependencies on HZ_PARTIES

Line 619: -- Cursor to select existing email address from hz_parties

615: p_email_address in per_all_people_f.email_address%type) is
616: --
617: l_proc varchar2(80) := g_package||'create_update_contact_point';
618: --
619: -- Cursor to select existing email address from hz_parties
620: CURSOR c1 IS
621: SELECT email_address, last_update_date,contact_point_id,status
622: FROM hz_contact_points hcp
623: WHERE hcp.contact_point_type = 'EMAIL'

Line 624: and hcp.owner_table_name = 'HZ_PARTIES'

620: CURSOR c1 IS
621: SELECT email_address, last_update_date,contact_point_id,status
622: FROM hz_contact_points hcp
623: WHERE hcp.contact_point_type = 'EMAIL'
624: and hcp.owner_table_name = 'HZ_PARTIES'
625: and hcp.owner_table_id = p_party_id
626: order by last_update_date desc,contact_point_id desc;
627:
628:

Line 745: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';

741: --
742: hr_utility.set_location(l_proc,50);
743: --
744: l_contact_point_rec.contact_point_type := 'EMAIL';
745: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
746: l_contact_point_rec.owner_table_id := p_party_id;
747: l_contact_point_rec.status := 'A';
748: l_contact_point_rec.primary_flag := 'Y';
749: l_email_rec.email_address := p_email_address;

Line 916: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';

912: --
913: hr_utility.set_location(l_proc,120);
914: --
915: l_contact_point_rec.contact_point_type := 'EMAIL';
916: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
917: l_contact_point_rec.owner_table_id := p_party_id;
918: l_contact_point_rec.status := 'A';
919: l_contact_point_rec.primary_flag := 'Y';
920: l_email_rec.email_address := p_email_address;

Line 2500: update hz_parties

2496: -- Bug fix 4227635 starts here--
2497: -- Updated orig_system_reference to party id when the
2498: -- link is broken between the TCA and HR.
2499:
2500: update hz_parties
2501: set orig_system_reference = p_rec.party_id
2502: where party_id = p_rec.party_id
2503: and substr(orig_system_reference,1,4) = 'PER:';
2504:

Line 3145: from hz_parties

3141: -- Get the latest person record
3142: --
3143: select max(last_update_date)
3144: into l_party_last_update_date
3145: from hz_parties
3146: where party_id = p_rec.party_id;
3147: --
3148: --Added for bug 2648797
3149: --Get the object version number

Line 3153: from hz_parties

3149: --Get the object version number
3150:
3151: select max(object_version_number)
3152: into l_party_object_version_number
3153: from hz_parties
3154: where party_id = p_rec.party_id;
3155: --
3156: -- Call TCA API and update the person.
3157: --

Line 3208: update hz_parties

3204: -- and then assigned that party to an HR person.
3205: -- This will prevent any future updates to the TCA data unless the update
3206: -- comes from HR.
3207: --
3208: update hz_parties
3209: set orig_system_reference = 'PER:'||p_rec.person_id
3210: where party_id = p_rec.party_id
3211: and substr(orig_system_reference,1,4) <> 'PER:';
3212: --

Line 5923: where owner_table_name = 'HZ_PARTIES'

5919: and ppf.effective_end_date = hr_api.g_eot
5920: and ppf.party_id is not null
5921: and not exists(select null
5922: from hz_contact_points
5923: where owner_table_name = 'HZ_PARTIES'
5924: and owner_table_id = ppf.party_id
5925: and email_address = nvl(ppf.email_address,'NULL'));
5926: --
5927: l_person c_person%rowtype;

Line 6299: where owner_table_name = 'HZ_PARTIES'

6295: and ppf.effective_end_date = hr_api.g_eot
6296: and ppf.party_id is not null
6297: and not exists(select /*+ no_unnest */ null
6298: from hz_contact_points
6299: where owner_table_name = 'HZ_PARTIES'
6300: and owner_table_id = ppf.party_id
6301: and upper(email_address) = ppf.email_address); -- fix for bug 12933615
6302: --
6303: l_person c_person%rowtype;