eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_PARTY_MERGE_PVT dependencies on HZ_MERGE_BATCH

Line 28: from HZ_MERGE_BATCH

24:
25: x_return_status := FND_API.G_RET_STS_SUCCESS;
26:
27: select merge_reason_code into l_merge_reason_code
28: from HZ_MERGE_BATCH
29: where batch_id = p_batch_id;
30:
31: IF l_merge_reason_code = 'DUPLICATE' THEN
32: -- ***************************************************************************

Line 156: from HZ_MERGE_BATCH

152:
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154:
155: select merge_reason_code into l_merge_reason_code
156: from HZ_MERGE_BATCH
157: where batch_id = p_batch_id;
158:
159: IF l_merge_reason_code = 'DUPLICATE' THEN
160: -- ***************************************************************************

Line 290: from HZ_MERGE_BATCH

286:
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288:
289: select merge_reason_code into l_merge_reason_code
290: from HZ_MERGE_BATCH
291: where batch_id = p_batch_id;
292:
293: IF l_merge_reason_code = 'DUPLICATE' THEN
294: -- ***************************************************************************

Line 398: from HZ_MERGE_BATCH

394:
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: select merge_reason_code into l_merge_reason_code
398: from HZ_MERGE_BATCH
399: where batch_id = p_batch_id;
400:
401: IF l_merge_reason_code = 'DUPLICATE' THEN
402: -- ***************************************************************************

Line 506: from HZ_MERGE_BATCH

502:
503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504:
505: select merge_reason_code into l_merge_reason_code
506: from HZ_MERGE_BATCH
507: where batch_id = p_batch_id;
508:
509: IF l_merge_reason_code = 'DUPLICATE' THEN
510: -- ***************************************************************************

Line 614: from HZ_MERGE_BATCH

610:
611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612:
613: select merge_reason_code into l_merge_reason_code
614: from HZ_MERGE_BATCH
615: where batch_id = p_batch_id;
616:
617: IF l_merge_reason_code = 'DUPLICATE' THEN
618: -- ***************************************************************************

Line 722: from HZ_MERGE_BATCH

718:
719: x_return_status := FND_API.G_RET_STS_SUCCESS;
720:
721: select merge_reason_code into l_merge_reason_code
722: from HZ_MERGE_BATCH
723: where batch_id = p_batch_id;
724:
725: IF l_merge_reason_code = 'DUPLICATE' THEN
726: -- ***************************************************************************

Line 831: from HZ_MERGE_BATCH

827:
828: x_return_status := FND_API.G_RET_STS_SUCCESS;
829:
830: select merge_reason_code into l_merge_reason_code
831: from HZ_MERGE_BATCH
832: where batch_id = p_batch_id;
833:
834: -- ***************************************************************************
835: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 900: from HZ_MERGE_BATCH

896:
897: x_return_status := FND_API.G_RET_STS_SUCCESS;
898:
899: select merge_reason_code into l_merge_reason_code
900: from HZ_MERGE_BATCH
901: where batch_id = p_batch_id;
902:
903: -- ***************************************************************************
904: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 969: from HZ_MERGE_BATCH

965:
966: x_return_status := FND_API.G_RET_STS_SUCCESS;
967:
968: select merge_reason_code into l_merge_reason_code
969: from HZ_MERGE_BATCH
970: where batch_id = p_batch_id;
971:
972: -- ***************************************************************************
973: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1065: from HZ_MERGE_BATCH

1061:
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063:
1064: select merge_reason_code into l_merge_reason_code
1065: from HZ_MERGE_BATCH
1066: where batch_id = p_batch_id;
1067:
1068: -- ***************************************************************************
1069: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1145: from HZ_MERGE_BATCH

1141:
1142: x_return_status := FND_API.G_RET_STS_SUCCESS;
1143:
1144: select merge_reason_code into l_merge_reason_code
1145: from HZ_MERGE_BATCH
1146: where batch_id = p_batch_id;
1147:
1148: -- ***************************************************************************
1149: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1215: from HZ_MERGE_BATCH

1211:
1212: x_return_status := FND_API.G_RET_STS_SUCCESS;
1213:
1214: select merge_reason_code into l_merge_reason_code
1215: from HZ_MERGE_BATCH
1216: where batch_id = p_batch_id;
1217:
1218: -- ***************************************************************************
1219: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1286: from HZ_MERGE_BATCH

1282:
1283: x_return_status := FND_API.G_RET_STS_SUCCESS;
1284:
1285: select merge_reason_code into l_merge_reason_code
1286: from HZ_MERGE_BATCH
1287: where batch_id = p_batch_id;
1288:
1289: -- ***************************************************************************
1290: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1357: from HZ_MERGE_BATCH

1353:
1354: x_return_status := FND_API.G_RET_STS_SUCCESS;
1355:
1356: select merge_reason_code into l_merge_reason_code
1357: from HZ_MERGE_BATCH
1358: where batch_id = p_batch_id;
1359:
1360: -- ***************************************************************************
1361: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1427: from HZ_MERGE_BATCH

1423:
1424: x_return_status := FND_API.G_RET_STS_SUCCESS;
1425:
1426: select merge_reason_code into l_merge_reason_code
1427: from HZ_MERGE_BATCH
1428: where batch_id = p_batch_id;
1429:
1430: -- ***************************************************************************
1431: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1498: from HZ_MERGE_BATCH

1494:
1495: x_return_status := FND_API.G_RET_STS_SUCCESS;
1496:
1497: select merge_reason_code into l_merge_reason_code
1498: from HZ_MERGE_BATCH
1499: where batch_id = p_batch_id;
1500:
1501: -- ***************************************************************************
1502: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1561: from HZ_MERGE_BATCH

1557:
1558: x_return_status := FND_API.G_RET_STS_SUCCESS;
1559:
1560: select merge_reason_code into l_merge_reason_code
1561: from HZ_MERGE_BATCH
1562: where batch_id = p_batch_id;
1563:
1564: -- ***************************************************************************
1565: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1629: from HZ_MERGE_BATCH

1625:
1626: x_return_status := FND_API.G_RET_STS_SUCCESS;
1627:
1628: select merge_reason_code into l_merge_reason_code
1629: from HZ_MERGE_BATCH
1630: where batch_id = p_batch_id;
1631:
1632: -- ***************************************************************************
1633: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1695: from HZ_MERGE_BATCH

1691:
1692: x_return_status := FND_API.G_RET_STS_SUCCESS;
1693:
1694: select merge_reason_code into l_merge_reason_code
1695: from HZ_MERGE_BATCH
1696: where batch_id = p_batch_id;
1697:
1698: -- ***************************************************************************
1699: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1762: from HZ_MERGE_BATCH

1758:
1759: x_return_status := FND_API.G_RET_STS_SUCCESS;
1760:
1761: select merge_reason_code into l_merge_reason_code
1762: from HZ_MERGE_BATCH
1763: where batch_id = p_batch_id;
1764:
1765: IF l_merge_reason_code = 'DUPLICATE' THEN
1766: -- ***************************************************************************

Line 1867: from HZ_MERGE_BATCH

1863:
1864: x_return_status := FND_API.G_RET_STS_SUCCESS;
1865:
1866: select merge_reason_code into l_merge_reason_code
1867: from HZ_MERGE_BATCH
1868: where batch_id = p_batch_id;
1869:
1870: IF l_merge_reason_code = 'DUPLICATE' THEN
1871: -- ***************************************************************************

Line 1972: from HZ_MERGE_BATCH

1968:
1969: x_return_status := FND_API.G_RET_STS_SUCCESS;
1970:
1971: select merge_reason_code into l_merge_reason_code
1972: from HZ_MERGE_BATCH
1973: where batch_id = p_batch_id;
1974:
1975: IF l_merge_reason_code = 'DUPLICATE' THEN
1976: -- ***************************************************************************

Line 2077: from HZ_MERGE_BATCH

2073:
2074: x_return_status := FND_API.G_RET_STS_SUCCESS;
2075:
2076: select merge_reason_code into l_merge_reason_code
2077: from HZ_MERGE_BATCH
2078: where batch_id = p_batch_id;
2079:
2080: IF l_merge_reason_code = 'DUPLICATE' THEN
2081: -- ***************************************************************************

Line 2196: FROM HZ_MERGE_BATCH

2192:
2193: x_return_status := FND_API.G_RET_STS_SUCCESS;
2194:
2195: SELECT merge_reason_code INTO l_merge_reason_code
2196: FROM HZ_MERGE_BATCH
2197: WHERE batch_id = p_batch_id;
2198:
2199: IF l_merge_reason_code = 'DUPLICATE' THEN
2200: -- ***************************************************************************

Line 2320: from HZ_MERGE_BATCH

2316:
2317: x_return_status := FND_API.G_RET_STS_SUCCESS;
2318:
2319: select merge_reason_code into l_merge_reason_code
2320: from HZ_MERGE_BATCH
2321: where batch_id = p_batch_id;
2322:
2323: IF l_merge_reason_code = 'DUPLICATE' THEN
2324: --***************************************************************************

Line 2431: from HZ_MERGE_BATCH

2427:
2428: x_return_status := FND_API.G_RET_STS_SUCCESS;
2429:
2430: select merge_reason_code into l_merge_reason_code
2431: from HZ_MERGE_BATCH
2432: where batch_id = p_batch_id;
2433:
2434: IF l_merge_reason_code = 'DUPLICATE' THEN
2435: --***************************************************************************

Line 2543: from HZ_MERGE_BATCH

2539:
2540: x_return_status := FND_API.G_RET_STS_SUCCESS;
2541:
2542: select merge_reason_code into l_merge_reason_code
2543: from HZ_MERGE_BATCH
2544: where batch_id = p_batch_id;
2545:
2546: IF l_merge_reason_code = 'DUPLICATE' THEN
2547: --***************************************************************************

Line 2672: from HZ_MERGE_BATCH

2668:
2669: x_return_status := FND_API.G_RET_STS_SUCCESS;
2670:
2671: select merge_reason_code into l_merge_reason_code
2672: from HZ_MERGE_BATCH
2673: where batch_id = p_batch_id;
2674:
2675: IF l_merge_reason_code = 'DUPLICATE' THEN
2676: --***************************************************************************

Line 2805: from HZ_MERGE_BATCH

2801:
2802: x_return_status := FND_API.G_RET_STS_SUCCESS;
2803:
2804: select merge_reason_code into l_merge_reason_code
2805: from HZ_MERGE_BATCH
2806: where batch_id = p_batch_id;
2807:
2808: IF l_merge_reason_code = 'DUPLICATE' THEN
2809: --***************************************************************************

Line 2932: from HZ_MERGE_BATCH

2928:
2929: x_return_status := FND_API.G_RET_STS_SUCCESS;
2930:
2931: select merge_reason_code into l_merge_reason_code
2932: from HZ_MERGE_BATCH
2933: where batch_id = p_batch_id;
2934:
2935: IF l_merge_reason_code = 'DUPLICATE' THEN
2936: --***************************************************************************

Line 3043: from HZ_MERGE_BATCH

3039:
3040: x_return_status := FND_API.G_RET_STS_SUCCESS;
3041:
3042: select merge_reason_code into l_merge_reason_code
3043: from HZ_MERGE_BATCH
3044: where batch_id = p_batch_id;
3045:
3046: IF l_merge_reason_code = 'DUPLICATE' THEN
3047: --***************************************************************************