[Home] [Help]
20:
21: CURSOR l_cur IS
22: SELECT code_assignment_id
23: FROM hz_code_assignments
24: WHERE owner_table_name = 'HZ_PARTIES'
25: AND owner_table_id = p_party_id
26: AND class_category = p_category
27: AND class_code = p_code
28: AND status = 'A'
38: RETURN;
39: END IF;
40: CLOSE l_cur;
41:
42: l_code_assignment_rec.owner_table_name := 'HZ_PARTIES';
43: l_code_assignment_rec.owner_table_id := p_party_id;
44: l_code_assignment_rec.class_category := p_category;
45: l_code_assignment_rec.class_code := p_code;
46: l_code_assignment_rec.primary_flag := p_primary_flag;
211: SELECT 1
212: FROM hz_contact_points
213: WHERE owner_table_id = p_partyid
214: AND upper(email_address) = upper(p_emailaddress)
215: AND owner_table_name = 'HZ_PARTIES'
216: AND status = 'A'
217: AND contact_point_type = 'EMAIL';
218:
219: l_number NUMBER;
233: l_email_rec.email_format := 'MAILTEXT';
234: l_email_rec.email_address := p_emailaddress;
235: l_contact_points_rec.contact_point_type := 'EMAIL';
236: l_contact_points_rec.status := 'A';
237: l_contact_points_rec.owner_table_name := 'HZ_PARTIES';
238: l_contact_points_rec.owner_table_id := p_partyId;
239: l_contact_points_rec.created_by_module := 'POS_SUPPLIER_MGMT';
240:
241: hz_contact_point_v2pub.create_contact_point
377: l_party_id number;
378: BEGIN
379: select distinct hz2.party_id
380: into l_party_id
381: from fnd_user f, hz_parties hz1, hz_parties hz2,
382: hz_relationships hzr1, hz_code_assignments hca
383: where f.person_party_id = hz1.party_id
384: and f.user_name = p_username
385: and hzr1.object_id = hz2.party_id
388: and hzr1.relationship_code = 'EMPLOYEE_OF'
389: and hzr1.start_date <= sysdate
390: and hzr1.end_date >= sysdate
391: and hca.owner_table_id = hz2.party_id
392: and hca.owner_table_name = 'HZ_PARTIES'
393: and hca.class_category = 'POS_PARTICIPANT_TYPE'
394: and hca.class_code = 'ENTERPRISE';
395:
396: return l_party_id;
532: -- caller passes in a supplier username or internal user name
533: FUNCTION get_job_title_for_user (p_user_id IN NUMBER )
534: RETURN VARCHAR2
535: IS
536: l_job_title HZ_PARTIES.PERSON_TITLE%TYPE;
537: BEGIN
538: SELECT hp.person_title
539: INTO l_job_title
540: FROM hz_parties hp, fnd_user fu
536: l_job_title HZ_PARTIES.PERSON_TITLE%TYPE;
537: BEGIN
538: SELECT hp.person_title
539: INTO l_job_title
540: FROM hz_parties hp, fnd_user fu
541: WHERE hp.party_id = fu.person_party_id
542: AND fu.user_id = p_user_id;
543:
544: return l_job_title;