654: end if;
655: --bug 4569674
656: l_merge_yn := null;
657:
658: ZX_MERGE_LOC_CHECK_PKG.CHECK_GNR(l_from_location_id,
659: l_to_location_id,
660: FND_API.G_FALSE,
661: l_merge_yn,
662: x_return_status,
1094:
1095: --bug 4569674
1096: l_merge_yn := null;
1097:
1098: ZX_MERGE_LOC_CHECK_PKG.CHECK_GNR(l_from_location_id,
1099: l_to_location_id,
1100: FND_API.G_FALSE,
1101: l_merge_yn,
1102: x_return_status,
2512: FROM hz_party_sites
2513: WHERE party_site_id = l_master_site;
2514:
2515:
2516: ZX_MERGE_LOC_CHECK_PKG.CHECK_GNR(l_from_location_id,
2517: l_to_location_id,
2518: FND_API.G_FALSE,
2519: l_merge_yn,
2520: l_return_status,
2651: SELECT location_id into l_to_location_id
2652: FROM hz_party_sites
2653: WHERE party_site_id = l_master_site;
2654:
2655: ZX_MERGE_LOC_CHECK_PKG.CHECK_GNR(l_from_location_id,
2656: l_to_location_id,
2657: FND_API.G_FALSE,
2658: l_merge_yn,
2659: l_return_status,