31:
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:
34: select merge_reason_code into l_merge_reason_code
35: from HZ_MERGE_BATCH
36: where batch_id = p_batch_id;
37:
38: IF l_merge_reason_code = 'DUPLICATE' THEN
39: -- ***************************************************************************
148:
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150:
151: select merge_reason_code into l_merge_reason_code
152: from HZ_MERGE_BATCH
153: where batch_id = p_batch_id;
154:
155: IF l_merge_reason_code = 'DUPLICATE' THEN
156: -- ***************************************************************************