APPS.HZ_PARTY_SITE_V2PUB dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 228: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

224: -- Bug 2197181: Added l_loc_actual_content_source to denormalize actual_content_source into
225: -- hz_party_sites from hz_locations.
226:
227: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;
228: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
229: l_msg_count NUMBER;
230: l_msg_data VARCHAR2(2000);
231: l_country_code hz_parties.country%type;--4742586
232:

Line 516: hz_orig_system_ref_pub.create_orig_system_reference(

512: l_orig_sys_reference_rec.owner_table_name := 'HZ_PARTY_SITES';
513: l_orig_sys_reference_rec.owner_table_id := p_party_site_rec.party_site_id;
514: l_orig_sys_reference_rec.created_by_module := p_party_site_rec.created_by_module;
515:
516: hz_orig_system_ref_pub.create_orig_system_reference(
517: FND_API.G_FALSE,
518: l_orig_sys_reference_rec,
519: x_return_status,
520: l_msg_count,

Line 2041: hz_orig_system_ref_pub.get_owner_table_id

2037: and p_party_site_rec.orig_system <>fnd_api.g_miss_char)
2038: and (p_party_site_rec.orig_system_reference is not null
2039: and p_party_site_rec.orig_system_reference <>fnd_api.g_miss_char)
2040: and (p_party_site_rec.party_site_id = FND_API.G_MISS_NUM or p_party_site_rec.party_site_id is null) THEN
2041: hz_orig_system_ref_pub.get_owner_table_id
2042: (p_orig_system => p_party_site_rec.orig_system,
2043: p_orig_system_reference => p_party_site_rec.orig_system_reference,
2044: p_owner_table_name => 'HZ_PARTY_SITES',
2045: x_owner_table_id => l_party_site_rec.party_site_id,