APPS.AP_VENDOR_PUB_PKG dependencies on HZ_PARTIES

Line 2365: FROM hz_parties

2361: x_valid := TRUE;
2362:
2363: SELECT party_id
2364: INTO l_dummy
2365: FROM hz_parties
2366: WHERE party_id = p_party_id;
2367:
2368:
2369: EXCEPTION

Line 2710: sync with Party Site Name of hz_parties and ap_supplier_sites

2706: END Check_org_id_name_site_code;
2707:
2708: /* udhenuko bug 7013954 added procedure
2709: This procedure is used to check if the org_id or operating_unit is in
2710: sync with Party Site Name of hz_parties and ap_supplier_sites
2711: for Supplier Site Contact Interface table*/
2712: PROCEDURE Check_org_id_party_site_name
2713: (p_org_id IN NUMBER,
2714: p_org_name IN VARCHAR2,

Line 2924: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE

2920: x_msg_count OUT NOCOPY NUMBER,
2921: x_msg_data OUT NOCOPY VARCHAR2,
2922: p_vendor_rec IN r_vendor_rec_type,
2923: x_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE,
2924: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE
2925: )
2926: IS
2927:
2928:

Line 3235: --bug6050423.Pass null value to jgzz_fiscal_code in hz_parties for

3231: l_org_rec.organization_name := l_vendor_rec.vendor_name;
3232: l_org_rec.organization_name_phonetic :=
3233: l_vendor_rec.vendor_name_alt;
3234:
3235: --bug6050423.Pass null value to jgzz_fiscal_code in hz_parties for
3236: --individual contractors and employees.
3237: --taxpayer id of individual contractors is stored only in ap_suppliers.
3238: --bug6691916.commented the below if clause and added the one below that.
3239: --as per analysis,only organization lookup code of type individual

Line 11622: l_rel_rec.subject_table_name := 'HZ_PARTIES';

11618:
11619: l_rel_rec.end_date := l_vendor_contact_rec.inactive_date;
11620: l_rel_rec.subject_id := l_per_party_id;
11621: l_rel_rec.subject_type := 'PERSON';
11622: l_rel_rec.subject_table_name := 'HZ_PARTIES';
11623: l_rel_rec.object_id := l_org_party_id;
11624: l_rel_rec.object_type := 'ORGANIZATION';
11625: l_rel_rec.object_table_name := 'HZ_PARTIES';
11626: l_rel_rec.relationship_code := 'CONTACT_OF';

Line 11625: l_rel_rec.object_table_name := 'HZ_PARTIES';

11621: l_rel_rec.subject_type := 'PERSON';
11622: l_rel_rec.subject_table_name := 'HZ_PARTIES';
11623: l_rel_rec.object_id := l_org_party_id;
11624: l_rel_rec.object_type := 'ORGANIZATION';
11625: l_rel_rec.object_table_name := 'HZ_PARTIES';
11626: l_rel_rec.relationship_code := 'CONTACT_OF';
11627: l_rel_rec.relationship_type := 'CONTACT';
11628: l_rel_rec.start_date := sysdate;
11629: l_rel_rec.created_by_module := 'AP_SUPPLIERS_API';

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

11724: l_org_contact_valid <> 'F' AND
11725: l_party_site_valid <> 'F' THEN -- create contact points
11726:
11727: --populate contact point record
11728: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
11729: l_contact_point_rec.owner_table_id := l_vendor_contact_rec.rel_party_id;
11730: l_contact_point_rec.created_by_module := 'AP_SUPPLIERS_API';
11731: l_contact_point_rec.application_id := 200;
11732: