DBA Data[Home] [Help]

APPS.JTF_UM_BUSINESS_USER_PVT dependencies on HZ_PARTIES

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

152: END IF;
153: --l_party_rel_rec.party_rec.total_num_of_orders := 0;
154: l_party_rel_rec.subject_id := p_um_person_rec.party_id;
155: l_party_rel_rec.subject_type := 'PERSON';
156: l_party_rel_rec.subject_table_name := 'HZ_PARTIES';
157: l_party_rel_rec.relationship_type := 'EMPLOYMENT';
158: l_party_rel_rec.relationship_code := 'EMPLOYEE_OF';
159: l_party_rel_rec.start_date := nvl(p_um_person_rec.start_Date_active, sysdate);
160: l_party_rel_rec.object_id := p_um_organization_rec.org_party_id;

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

158: l_party_rel_rec.relationship_code := 'EMPLOYEE_OF';
159: l_party_rel_rec.start_date := nvl(p_um_person_rec.start_Date_active, sysdate);
160: l_party_rel_rec.object_id := p_um_organization_rec.org_party_id;
161: l_party_rel_rec.object_type := 'ORGANIZATION';
162: l_party_rel_rec.object_table_name := 'HZ_PARTIES';
163: l_party_rel_rec.created_by_module := G_CREATED_BY_MODULE;
164: l_party_rel_rec.application_id := 690;
165: l_org_contact_rec.party_rel_rec := l_party_rel_rec;
166: l_org_contact_rec.created_by_module := G_CREATED_BY_MODULE;

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

222: --for i in c_user_id(upper(p_um_person_rec.user_name)) loop
223: -- p_um_person_rec.user_id := i.user_id;
224: --end loop;
225: l_contact_point_rec.status := 'A';
226: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
227: l_contact_point_rec.owner_table_id := l_party_id;
228: l_contact_point_rec.primary_flag := 'Y';
229: l_contact_point_rec.created_by_module := G_CREATED_BY_MODULE;
230: l_contact_point_rec.application_id := 690;

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

267: -- call Hz_contact_preference api to populate the
268: -- preference to recieve marketing/promotion mails
269: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE,
270: p_message => 'invoking HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference for creating preference of receiving email preference:'||l_privacy_preference);
271: l_contact_preference_rec.contact_level_table := 'HZ_PARTIES';
272: -- populate contact level id with l_party_id which is the relationship_id
273: l_contact_preference_rec.contact_level_table_id := l_party_id;
274: l_contact_preference_rec.contact_type := 'EMAIL';
275: l_contact_preference_rec.requested_by := 'PARTY';

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

451: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: end if;
454: l_contact_point_rec.status := 'A';
455: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
456: l_contact_point_rec.owner_table_id := P_um_organization_Rec.org_party_id;
457: l_contact_point_rec.primary_flag := 'Y';
458: l_contact_point_rec.created_by_module := G_CREATED_BY_MODULE;
459: l_contact_point_rec.application_id := 690;

Line 532: select party_id, party_name, party_number from hz_parties where party_name = x_org_rec.organization_name;

528: x_org_rec IN out NOCOPY JTF_UM_REGISTER_USER_PVT.Organization_Rec_type,
529: p_search_value IN varchar2,
530: p_use_name IN boolean ) return boolean is
531: cursor c_party_name IS
532: select party_id, party_name, party_number from hz_parties where party_name = x_org_rec.organization_name;
533: cursor c_party_num IS
534: select party_id, party_name, party_number from hz_parties where party_number = x_org_rec.organization_number;
535: l_party_rec c_party_name%rowtype;
536: ret_val boolean := false;

Line 534: select party_id, party_name, party_number from hz_parties where party_number = x_org_rec.organization_number;

530: p_use_name IN boolean ) return boolean is
531: cursor c_party_name IS
532: select party_id, party_name, party_number from hz_parties where party_name = x_org_rec.organization_name;
533: cursor c_party_num IS
534: select party_id, party_name, party_number from hz_parties where party_number = x_org_rec.organization_number;
535: l_party_rec c_party_name%rowtype;
536: ret_val boolean := false;
537: begin
538: if ( p_use_name ) then