[Home] [Help]
2430: l_rowid ROWID := NULL;
2431: l_debug_prefix VARCHAR2(30) := '';
2432:
2433: -- Bug 4239442 : Added cursor and variables
2434: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
2435: l_orig_system HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM%TYPE;
2436: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE%TYPE;
2437: l_created_by_module HZ_ORIG_SYS_REFERENCES.CREATED_BY_MODULE%TYPE;
2438: l_exists VARCHAR2(1);
2519: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2520: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'DQM Sync Mode '||l_orig_sys_reference_rec.dqm_sync_mode,
2521: p_msg_level=>fnd_log.level_statement);
2522: END IF;
2523: hz_orig_system_ref_pub.create_orig_system_reference(
2524: FND_API.G_FALSE,
2525: l_orig_sys_reference_rec,
2526: l_return_status,
2527: l_msg_count,
2780: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2781: l_context VARCHAR2(1);
2782:
2783: l_debug_prefix VARCHAR2(30);
2784: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
2785:
2786: l_msg_count number;
2787: l_msg_data varchar2(2000);
2788: l_created_by_module varchar2(150);
2836: and l_party_rec.orig_system <>fnd_api.g_miss_char)
2837: and (l_party_rec.orig_system_reference is not null
2838: and l_party_rec.orig_system_reference <>fnd_api.g_miss_char)
2839: and (l_party_rec.party_id = FND_API.G_MISS_NUM or l_party_rec.party_id is null) THEN
2840: hz_orig_system_ref_pub.get_owner_table_id
2841: (p_orig_system => l_party_rec.orig_system,
2842: p_orig_system_reference => l_party_rec.orig_system_reference,
2843: p_owner_table_name => 'HZ_PARTIES',
2844: x_owner_table_id => l_party_rec.party_id,
3283: l_orig_sys_reference_rec.owner_table_name := 'HZ_PARTIES';
3284: l_orig_sys_reference_rec.owner_table_id := l_party_rec.party_id;
3285: l_orig_sys_reference_rec.created_by_module := l_created_by_module;
3286:
3287: hz_orig_system_ref_pub.create_orig_system_reference(
3288: FND_API.G_FALSE,
3289: l_orig_sys_reference_rec,
3290: l_return_status,
3291: l_msg_count,
5353: and (l_person_rec.party_rec.orig_system_reference is not null
5354: and l_person_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
5355: and (l_person_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_person_rec.party_rec.party_id is null) THEN
5356:
5357: hz_orig_system_ref_pub.get_owner_table_id
5358: (p_orig_system => l_person_rec.party_rec.orig_system,
5359: p_orig_system_reference => l_person_rec.party_rec.orig_system_reference,
5360: p_owner_table_name => 'HZ_PARTIES',
5361: x_owner_table_id => l_person_rec.party_rec.party_id,
5977: and (l_group_rec.party_rec.orig_system_reference is not null
5978: and l_group_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
5979: and (l_group_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_group_rec.party_rec.party_id is null) THEN
5980:
5981: hz_orig_system_ref_pub.get_owner_table_id
5982: (p_orig_system => l_group_rec.party_rec.orig_system,
5983: p_orig_system_reference => l_group_rec.party_rec.orig_system_reference,
5984: p_owner_table_name => 'HZ_PARTIES',
5985: x_owner_table_id => l_group_rec.party_rec.party_id,
6728: and (l_organization_rec.party_rec.orig_system_reference is not null
6729: and l_organization_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
6730: and (l_organization_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_organization_rec.party_rec.party_id is null) THEN
6731:
6732: hz_orig_system_ref_pub.get_owner_table_id
6733: (p_orig_system => l_organization_rec.party_rec.orig_system,
6734: p_orig_system_reference => l_organization_rec.party_rec.orig_system_reference,
6735: p_owner_table_name => 'HZ_PARTIES',
6736: x_owner_table_id => l_organization_rec.party_rec.party_id,