DBA Data[Home] [Help]

APPS.HZ_PARTY_MERGE dependencies on HZ_MERGE_UTIL

Line 888: HZ_MERGE_UTIL.get_reln_party_id(l_from_rel_id);

884: FETCH c_batch_relationships INTO l_from_rel_id, l_to_rel_id;
885: EXIT WHEN c_batch_relationships%NOTFOUND;
886:
887: l_from_rel_party_id :=
888: HZ_MERGE_UTIL.get_reln_party_id(l_from_rel_id);
889: l_to_rel_party_id :=
890: HZ_MERGE_UTIL.get_reln_party_id(l_to_rel_id);
891:
892: IF l_from_rel_party_id IS NOT NULL AND

Line 890: HZ_MERGE_UTIL.get_reln_party_id(l_to_rel_id);

886:
887: l_from_rel_party_id :=
888: HZ_MERGE_UTIL.get_reln_party_id(l_from_rel_id);
889: l_to_rel_party_id :=
890: HZ_MERGE_UTIL.get_reln_party_id(l_to_rel_id);
891:
892: IF l_from_rel_party_id IS NOT NULL AND
893: l_to_rel_party_id IS NOT NULL AND
894: l_from_rel_party_id<>l_to_rel_party_id THEN

Line 2282: rec_query := 'SELECT hz_merge_util.get_party_reln_description(relationship_id) FROM HZ_RELATIONSHIPS'

2278: -- Counstruct dynamic SQL query to fetch description
2279: --4500011
2280:
2281: IF (p_entity_name = 'HZ_PARTY_RELATIONSHIPS') THEN
2282: rec_query := 'SELECT hz_merge_util.get_party_reln_description(relationship_id) FROM HZ_RELATIONSHIPS'
2283: || ' WHERE RELATIONSHIP_ID = '|| ':pk'
2284: || ' AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES'' AND directional_flag = ''F''';
2285:
2286: ELSE

Line 2951: l_from_rec_desc :=hz_merge_util.get_party_site_description(l_merge_to_entity_id);

2947: l_proc_name := 'HZ_MERGE_PKG.party_site_merge';
2948: g_cur_merge_dict_id := 0;
2949: g_num_sub_entities :=-1;
2950:
2951: l_from_rec_desc :=hz_merge_util.get_party_site_description(l_merge_to_entity_id);
2952:
2953: -- Execute the merge procedure for the entity
2954: exec_merge(
2955: p_entity_name => 'HZ_PARTY_SITES',

Line 3068: l_from_rec_desc := hz_merge_util.get_party_reln_description(l_merge_to_entity_id);

3064: p_batch_id => p_batch_id,
3065: p_batch_party_id=> l_batch_party_id,
3066: x_return_status => l_return_status);
3067:
3068: l_from_rec_desc := hz_merge_util.get_party_reln_description(l_merge_to_entity_id);
3069:
3070: -- Check if the merge procedure returned an error
3071: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3072: -- Write to log file