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.UMX_REGISTER_USER_PVT dependencies on HZ_PARTIES

Line 13: --l_person_party_id hz_parties.party_id%type;

9: Procedure CreatePersonPartyInternal (p_event in out NOCOPY WF_EVENT_T,
10: p_person_party_id out NOCOPY varchar2)
11: IS
12:
13: --l_person_party_id hz_parties.party_id%type;
14: l_first_name hz_parties.person_first_name%type;
15: l_last_name hz_parties.person_last_name%type;
16: l_middle_name hz_parties.person_middle_name%type;
17: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;

Line 14: l_first_name hz_parties.person_first_name%type;

10: p_person_party_id out NOCOPY varchar2)
11: IS
12:
13: --l_person_party_id hz_parties.party_id%type;
14: l_first_name hz_parties.person_first_name%type;
15: l_last_name hz_parties.person_last_name%type;
16: l_middle_name hz_parties.person_middle_name%type;
17: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
18: l_person_name_suffix hz_parties.person_name_suffix%type;

Line 15: l_last_name hz_parties.person_last_name%type;

11: IS
12:
13: --l_person_party_id hz_parties.party_id%type;
14: l_first_name hz_parties.person_first_name%type;
15: l_last_name hz_parties.person_last_name%type;
16: l_middle_name hz_parties.person_middle_name%type;
17: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
18: l_person_name_suffix hz_parties.person_name_suffix%type;
19:

Line 16: l_middle_name hz_parties.person_middle_name%type;

12:
13: --l_person_party_id hz_parties.party_id%type;
14: l_first_name hz_parties.person_first_name%type;
15: l_last_name hz_parties.person_last_name%type;
16: l_middle_name hz_parties.person_middle_name%type;
17: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
18: l_person_name_suffix hz_parties.person_name_suffix%type;
19:
20: l_party_number hz_parties.party_number%type;

Line 17: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;

13: --l_person_party_id hz_parties.party_id%type;
14: l_first_name hz_parties.person_first_name%type;
15: l_last_name hz_parties.person_last_name%type;
16: l_middle_name hz_parties.person_middle_name%type;
17: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
18: l_person_name_suffix hz_parties.person_name_suffix%type;
19:
20: l_party_number hz_parties.party_number%type;
21: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;

Line 18: l_person_name_suffix hz_parties.person_name_suffix%type;

14: l_first_name hz_parties.person_first_name%type;
15: l_last_name hz_parties.person_last_name%type;
16: l_middle_name hz_parties.person_middle_name%type;
17: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
18: l_person_name_suffix hz_parties.person_name_suffix%type;
19:
20: l_party_number hz_parties.party_number%type;
21: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
22: l_profile_id NUMBER;

Line 20: l_party_number hz_parties.party_number%type;

16: l_middle_name hz_parties.person_middle_name%type;
17: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
18: l_person_name_suffix hz_parties.person_name_suffix%type;
19:
20: l_party_number hz_parties.party_number%type;
21: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
22: l_profile_id NUMBER;
23:
24:

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

135:
136: --populate the record
137:
138: l_contact_point_rec.status := 'A';
139: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
140: l_contact_point_rec.owner_table_id := p_contact_party_id;
141: l_contact_point_rec.primary_flag := 'Y';
142: l_contact_point_rec.created_by_module := G_CREATED_BY_MODULE;
143: l_contact_point_rec.application_id := 0;

Line 272: l_party_rel_rec.subject_table_name := 'HZ_PARTIES';

268: l_org_party_id := p_event.getvalueforparameter ('ORGANIZATION_PARTY_ID');
269:
270: l_party_rel_rec.subject_id := p_person_party_id;
271: l_party_rel_rec.subject_type := 'PERSON';
272: l_party_rel_rec.subject_table_name := 'HZ_PARTIES';
273: l_party_rel_rec.relationship_type := 'EMPLOYMENT';
274: l_party_rel_rec.relationship_code := 'EMPLOYEE_OF';
275: l_party_rel_rec.start_date := sysdate; -- change later
276: l_party_rel_rec.object_id := l_org_party_id;

Line 278: l_party_rel_rec.object_table_name := 'HZ_PARTIES';

274: l_party_rel_rec.relationship_code := 'EMPLOYEE_OF';
275: l_party_rel_rec.start_date := sysdate; -- change later
276: l_party_rel_rec.object_id := l_org_party_id;
277: l_party_rel_rec.object_type := 'ORGANIZATION';
278: l_party_rel_rec.object_table_name := 'HZ_PARTIES';
279: l_party_rel_rec.created_by_module := G_CREATED_BY_MODULE;
280: l_party_rel_rec.application_id := 0;
281: l_org_contact_rec.party_rel_rec := l_party_rel_rec;
282: l_org_contact_rec.created_by_module := G_CREATED_BY_MODULE;

Line 356: l_contact_preference_rec.contact_level_table := 'HZ_PARTIES';

352: else
353: l_contact_preference_rec.preference_code := 'DO_NOT';
354: end if;
355:
356: l_contact_preference_rec.contact_level_table := 'HZ_PARTIES';
357: l_contact_preference_rec.contact_level_table_id := p_person_party_id;
358: l_contact_preference_rec.contact_type := 'EMAIL';
359: l_contact_preference_rec.requested_by := 'INTERNAL';
360: l_contact_preference_rec.created_by_module := G_CREATED_BY_MODULE;

Line 436: -- p_person_party_id - The party ID of the person defined in hz_parties table

432: -- Get the email address from the party relationship.
433: -- If email is still missing, then return null
434: --
435: -- IN
436: -- p_person_party_id - The party ID of the person defined in hz_parties table
437: -- OUT
438: -- x_email_address - Email address of the person
439:
440: Procedure Get_Party_Email_Address (p_person_party_id in hz_parties.party_id%type,

Line 440: Procedure Get_Party_Email_Address (p_person_party_id in hz_parties.party_id%type,

436: -- p_person_party_id - The party ID of the person defined in hz_parties table
437: -- OUT
438: -- x_email_address - Email address of the person
439:
440: Procedure Get_Party_Email_Address (p_person_party_id in hz_parties.party_id%type,
441: x_email_address out NOCOPY hz_parties.email_address%type) is
442:
443: cursor get_email_from_person_party (p_person_party_id in hz_parties.party_id%type) is
444: select email_address

Line 441: x_email_address out NOCOPY hz_parties.email_address%type) is

437: -- OUT
438: -- x_email_address - Email address of the person
439:
440: Procedure Get_Party_Email_Address (p_person_party_id in hz_parties.party_id%type,
441: x_email_address out NOCOPY hz_parties.email_address%type) is
442:
443: cursor get_email_from_person_party (p_person_party_id in hz_parties.party_id%type) is
444: select email_address
445: from hz_parties

Line 443: cursor get_email_from_person_party (p_person_party_id in hz_parties.party_id%type) is

439:
440: Procedure Get_Party_Email_Address (p_person_party_id in hz_parties.party_id%type,
441: x_email_address out NOCOPY hz_parties.email_address%type) is
442:
443: cursor get_email_from_person_party (p_person_party_id in hz_parties.party_id%type) is
444: select email_address
445: from hz_parties
446: where party_id = p_person_party_id;
447:

Line 445: from hz_parties

441: x_email_address out NOCOPY hz_parties.email_address%type) is
442:
443: cursor get_email_from_person_party (p_person_party_id in hz_parties.party_id%type) is
444: select email_address
445: from hz_parties
446: where party_id = p_person_party_id;
447:
448: cursor get_email_from_party_rel (p_person_party_id in hz_parties.party_id%type) is
449: select hzp_rel.email_address

Line 448: cursor get_email_from_party_rel (p_person_party_id in hz_parties.party_id%type) is

444: select email_address
445: from hz_parties
446: where party_id = p_person_party_id;
447:
448: cursor get_email_from_party_rel (p_person_party_id in hz_parties.party_id%type) is
449: select hzp_rel.email_address
450: from hz_parties hzp_rel, hz_relationships hzr
451: where hzr.subject_id = p_person_party_id
452: and hzr.party_id = hzp_rel.party_id

Line 450: from hz_parties hzp_rel, hz_relationships hzr

446: where party_id = p_person_party_id;
447:
448: cursor get_email_from_party_rel (p_person_party_id in hz_parties.party_id%type) is
449: select hzp_rel.email_address
450: from hz_parties hzp_rel, hz_relationships hzr
451: where hzr.subject_id = p_person_party_id
452: and hzr.party_id = hzp_rel.party_id
453: and hzp_rel.email_address is not null;
454:

Line 482: FUNCTION GET_PERSON_EMAIL_ADDRESS (p_person_party_id in hz_parties.party_id%type) return varchar2 is

478: end if;
479:
480: end Get_Party_Email_Address;
481:
482: FUNCTION GET_PERSON_EMAIL_ADDRESS (p_person_party_id in hz_parties.party_id%type) return varchar2 is
483:
484: l_email_address hz_parties.email_address%type;
485: begin
486:

Line 484: l_email_address hz_parties.email_address%type;

480: end Get_Party_Email_Address;
481:
482: FUNCTION GET_PERSON_EMAIL_ADDRESS (p_person_party_id in hz_parties.party_id%type) return varchar2 is
483:
484: l_email_address hz_parties.email_address%type;
485: begin
486:
487: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
488: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,