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 512: hz_orig_system_ref_pub.create_orig_system_reference(

508: l_orig_sys_reference_rec.owner_table_name := 'HZ_PARTY_SITES';
509: l_orig_sys_reference_rec.owner_table_id := p_party_site_rec.party_site_id;
510: l_orig_sys_reference_rec.created_by_module := p_party_site_rec.created_by_module;
511:
512: hz_orig_system_ref_pub.create_orig_system_reference(
513: FND_API.G_FALSE,
514: l_orig_sys_reference_rec,
515: x_return_status,
516: l_msg_count,

Line 2034: hz_orig_system_ref_pub.get_owner_table_id

2030: and p_party_site_rec.orig_system <>fnd_api.g_miss_char)
2031: and (p_party_site_rec.orig_system_reference is not null
2032: and p_party_site_rec.orig_system_reference <>fnd_api.g_miss_char)
2033: and (p_party_site_rec.party_site_id = FND_API.G_MISS_NUM or p_party_site_rec.party_site_id is null) THEN
2034: hz_orig_system_ref_pub.get_owner_table_id
2035: (p_orig_system => p_party_site_rec.orig_system,
2036: p_orig_system_reference => p_party_site_rec.orig_system_reference,
2037: p_owner_table_name => 'HZ_PARTY_SITES',
2038: x_owner_table_id => l_party_site_rec.party_site_id,