APPS.HZ_PARTY_CONTACT_V2PUB dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 177: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

173: l_debug_prefix VARCHAR2(30);
174: l_org_status VARCHAR2(1);
175: l_object_id NUMBER;
176: l_person_pre_name HZ_PARTIES.PERSON_PRE_NAME_ADJUNCT%TYPE := NULL;
177: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
178:
179: CURSOR c_rel IS
180: SELECT BACKWARD_REL_CODE
181: FROM HZ_RELATIONSHIP_TYPES

Line 431: hz_orig_system_ref_pub.create_orig_system_reference(

427: l_orig_sys_reference_rec.owner_table_name := 'HZ_ORG_CONTACTS';
428: l_orig_sys_reference_rec.owner_table_id := p_org_contact_rec.org_contact_id;
429: l_orig_sys_reference_rec.created_by_module := p_org_contact_rec.created_by_module;
430:
431: hz_orig_system_ref_pub.create_orig_system_reference(
432: FND_API.G_FALSE,
433: l_orig_sys_reference_rec,
434: x_return_status,
435: l_msg_count,

Line 809: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

805: l_msg_count NUMBER;
806: l_msg_data VARCHAR2(2000);
807: l_dummy VARCHAR2(1);
808: l_debug_prefix VARCHAR2(30);
809: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
810: l_object_version_number NUMBER; -- Added: Bug#6411541
811: BEGIN
812:
813: -- Debug info.

Line 948: hz_orig_system_ref_pub.create_orig_system_reference(

944: -- Created by module should not be null
945: l_orig_sys_reference_rec.created_by_module := p_org_contact_role_rec.created_by_module;
946: -- End changes made by Neeraj
947:
948: hz_orig_system_ref_pub.create_orig_system_reference(
949: FND_API.G_FALSE,
950: l_orig_sys_reference_rec,
951: x_return_status,
952: l_msg_count,

Line 1412: hz_orig_system_ref_pub.get_owner_table_id

1408: and p_org_contact_rec.orig_system <>fnd_api.g_miss_char)
1409: and (p_org_contact_rec.orig_system_reference is not null
1410: and p_org_contact_rec.orig_system_reference <>fnd_api.g_miss_char)
1411: and (p_org_contact_rec.org_contact_id = FND_API.G_MISS_NUM or p_org_contact_rec.org_contact_id is null) THEN
1412: hz_orig_system_ref_pub.get_owner_table_id
1413: (p_orig_system => p_org_contact_rec.orig_system,
1414: p_orig_system_reference => p_org_contact_rec.orig_system_reference,
1415: p_owner_table_name => 'HZ_ORG_CONTACTS',
1416: x_owner_table_id => l_org_contact_rec.org_contact_id,

Line 1841: hz_orig_system_ref_pub.get_owner_table_id

1837: and p_org_contact_role_rec.orig_system <>fnd_api.g_miss_char)
1838: and (p_org_contact_role_rec.orig_system_reference is not null
1839: and p_org_contact_role_rec.orig_system_reference <>fnd_api.g_miss_char)
1840: and (p_org_contact_role_rec.org_contact_role_id = FND_API.G_MISS_NUM or p_org_contact_role_rec.org_contact_role_id is null) THEN
1841: hz_orig_system_ref_pub.get_owner_table_id
1842: (p_orig_system => p_org_contact_role_rec.orig_system,
1843: p_orig_system_reference => p_org_contact_role_rec.orig_system_reference,
1844: p_owner_table_name => 'HZ_ORG_CONTACT_ROLES',
1845: x_owner_table_id => l_org_contact_role_rec.org_contact_role_id,