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

422: l_orig_sys_reference_rec.owner_table_name := 'HZ_ORG_CONTACTS';
423: l_orig_sys_reference_rec.owner_table_id := p_org_contact_rec.org_contact_id;
424: l_orig_sys_reference_rec.created_by_module := p_org_contact_rec.created_by_module;
425:
426: hz_orig_system_ref_pub.create_orig_system_reference(
427: FND_API.G_FALSE,
428: l_orig_sys_reference_rec,
429: x_return_status,
430: l_msg_count,

Line 804: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

800: l_msg_count NUMBER;
801: l_msg_data VARCHAR2(2000);
802: l_dummy VARCHAR2(1);
803: l_debug_prefix VARCHAR2(30);
804: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
805: l_object_version_number NUMBER; -- Added: Bug#6411541
806: BEGIN
807:
808: -- Debug info.

Line 943: hz_orig_system_ref_pub.create_orig_system_reference(

939: -- Created by module should not be null
940: l_orig_sys_reference_rec.created_by_module := p_org_contact_role_rec.created_by_module;
941: -- End changes made by Neeraj
942:
943: hz_orig_system_ref_pub.create_orig_system_reference(
944: FND_API.G_FALSE,
945: l_orig_sys_reference_rec,
946: x_return_status,
947: l_msg_count,

Line 1404: hz_orig_system_ref_pub.get_owner_table_id

1400: and p_org_contact_rec.orig_system <>fnd_api.g_miss_char)
1401: and (p_org_contact_rec.orig_system_reference is not null
1402: and p_org_contact_rec.orig_system_reference <>fnd_api.g_miss_char)
1403: and (p_org_contact_rec.org_contact_id = FND_API.G_MISS_NUM or p_org_contact_rec.org_contact_id is null) THEN
1404: hz_orig_system_ref_pub.get_owner_table_id
1405: (p_orig_system => p_org_contact_rec.orig_system,
1406: p_orig_system_reference => p_org_contact_rec.orig_system_reference,
1407: p_owner_table_name => 'HZ_ORG_CONTACTS',
1408: x_owner_table_id => l_org_contact_rec.org_contact_id,

Line 1833: hz_orig_system_ref_pub.get_owner_table_id

1829: and p_org_contact_role_rec.orig_system <>fnd_api.g_miss_char)
1830: and (p_org_contact_role_rec.orig_system_reference is not null
1831: and p_org_contact_role_rec.orig_system_reference <>fnd_api.g_miss_char)
1832: 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
1833: hz_orig_system_ref_pub.get_owner_table_id
1834: (p_orig_system => p_org_contact_role_rec.orig_system,
1835: p_orig_system_reference => p_org_contact_role_rec.orig_system_reference,
1836: p_owner_table_name => 'HZ_ORG_CONTACT_ROLES',
1837: x_owner_table_id => l_org_contact_role_rec.org_contact_role_id,