APPS.HZ_PARTY_V2PUB dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 2388: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

2384: l_rowid ROWID := NULL;
2385: l_debug_prefix VARCHAR2(30) := '';
2386:
2387: -- Bug 4239442 : Added cursor and variables
2388: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
2389: l_orig_system HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM%TYPE;
2390: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE%TYPE;
2391: l_created_by_module HZ_ORIG_SYS_REFERENCES.CREATED_BY_MODULE%TYPE;
2392: l_exists VARCHAR2(1);

Line 2472: hz_orig_system_ref_pub.create_orig_system_reference(

2468: l_orig_sys_reference_rec.owner_table_name := 'HZ_PARTIES';
2469: l_orig_sys_reference_rec.owner_table_id := p_party_id;
2470: l_orig_sys_reference_rec.created_by_module := nvl(l_created_by_module, 'TCA_V2_API');
2471:
2472: hz_orig_system_ref_pub.create_orig_system_reference(
2473: FND_API.G_FALSE,
2474: l_orig_sys_reference_rec,
2475: l_return_status,
2476: l_msg_count,

Line 2733: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

2729: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2730: l_context VARCHAR2(1);
2731:
2732: l_debug_prefix VARCHAR2(30);
2733: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
2734:
2735: l_msg_count number;
2736: l_msg_data varchar2(2000);
2737: l_created_by_module varchar2(150);

Line 2789: hz_orig_system_ref_pub.get_owner_table_id

2785: and l_party_rec.orig_system <>fnd_api.g_miss_char)
2786: and (l_party_rec.orig_system_reference is not null
2787: and l_party_rec.orig_system_reference <>fnd_api.g_miss_char)
2788: and (l_party_rec.party_id = FND_API.G_MISS_NUM or l_party_rec.party_id is null) THEN
2789: hz_orig_system_ref_pub.get_owner_table_id
2790: (p_orig_system => l_party_rec.orig_system,
2791: p_orig_system_reference => l_party_rec.orig_system_reference,
2792: p_owner_table_name => 'HZ_PARTIES',
2793: x_owner_table_id => l_party_rec.party_id,

Line 3236: hz_orig_system_ref_pub.create_orig_system_reference(

3232: l_orig_sys_reference_rec.owner_table_name := 'HZ_PARTIES';
3233: l_orig_sys_reference_rec.owner_table_id := l_party_rec.party_id;
3234: l_orig_sys_reference_rec.created_by_module := l_created_by_module;
3235:
3236: hz_orig_system_ref_pub.create_orig_system_reference(
3237: FND_API.G_FALSE,
3238: l_orig_sys_reference_rec,
3239: l_return_status,
3240: l_msg_count,

Line 5286: hz_orig_system_ref_pub.get_owner_table_id

5282: and (l_person_rec.party_rec.orig_system_reference is not null
5283: and l_person_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
5284: and (l_person_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_person_rec.party_rec.party_id is null) THEN
5285:
5286: hz_orig_system_ref_pub.get_owner_table_id
5287: (p_orig_system => l_person_rec.party_rec.orig_system,
5288: p_orig_system_reference => l_person_rec.party_rec.orig_system_reference,
5289: p_owner_table_name => 'HZ_PARTIES',
5290: x_owner_table_id => l_person_rec.party_rec.party_id,

Line 5910: hz_orig_system_ref_pub.get_owner_table_id

5906: and (l_group_rec.party_rec.orig_system_reference is not null
5907: and l_group_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
5908: and (l_group_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_group_rec.party_rec.party_id is null) THEN
5909:
5910: hz_orig_system_ref_pub.get_owner_table_id
5911: (p_orig_system => l_group_rec.party_rec.orig_system,
5912: p_orig_system_reference => l_group_rec.party_rec.orig_system_reference,
5913: p_owner_table_name => 'HZ_PARTIES',
5914: x_owner_table_id => l_group_rec.party_rec.party_id,

Line 6651: hz_orig_system_ref_pub.get_owner_table_id

6647: and (l_organization_rec.party_rec.orig_system_reference is not null
6648: and l_organization_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
6649: and (l_organization_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_organization_rec.party_rec.party_id is null) THEN
6650:
6651: hz_orig_system_ref_pub.get_owner_table_id
6652: (p_orig_system => l_organization_rec.party_rec.orig_system,
6653: p_orig_system_reference => l_organization_rec.party_rec.orig_system_reference,
6654: p_owner_table_name => 'HZ_PARTIES',
6655: x_owner_table_id => l_organization_rec.party_rec.party_id,