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.OZF_PARTY_MERGE_PVT dependencies on HZ_MERGE_BATCH

Line 64: from HZ_MERGE_BATCH

60:
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:
63: select merge_reason_code into l_merge_reason_code
64: from HZ_MERGE_BATCH
65: where batch_id = p_batch_id;
66:
67: -- ***************************************************************************
68: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 143: from HZ_MERGE_BATCH

139:
140: x_return_status := FND_API.G_RET_STS_SUCCESS;
141:
142: select merge_reason_code into l_merge_reason_code
143: from HZ_MERGE_BATCH
144: where batch_id = p_batch_id;
145:
146: -- ***************************************************************************
147: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 212: from HZ_MERGE_BATCH

208:
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210:
211: select merge_reason_code into l_merge_reason_code
212: from HZ_MERGE_BATCH
213: where batch_id = p_batch_id;
214:
215: -- ***************************************************************************
216: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 282: from HZ_MERGE_BATCH

278:
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280:
281: select merge_reason_code into l_merge_reason_code
282: from HZ_MERGE_BATCH
283: where batch_id = p_batch_id;
284:
285: -- ***************************************************************************
286: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 352: from HZ_MERGE_BATCH

348:
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: select merge_reason_code into l_merge_reason_code
352: from HZ_MERGE_BATCH
353: where batch_id = p_batch_id;
354:
355: -- ***************************************************************************
356: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 421: from HZ_MERGE_BATCH

417:
418: x_return_status := FND_API.G_RET_STS_SUCCESS;
419:
420: select merge_reason_code into l_merge_reason_code
421: from HZ_MERGE_BATCH
422: where batch_id = p_batch_id;
423:
424: -- ***************************************************************************
425: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 491: from HZ_MERGE_BATCH

487:
488: x_return_status := FND_API.G_RET_STS_SUCCESS;
489:
490: select merge_reason_code into l_merge_reason_code
491: from HZ_MERGE_BATCH
492: where batch_id = p_batch_id;
493:
494: -- ***************************************************************************
495: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 553: from HZ_MERGE_BATCH

549:
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551:
552: select merge_reason_code into l_merge_reason_code
553: from HZ_MERGE_BATCH
554: where batch_id = p_batch_id;
555:
556: -- ***************************************************************************
557: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 635: FROM HZ_MERGE_BATCH

631:
632: x_return_status := FND_API.G_RET_STS_SUCCESS;
633:
634: SELECT merge_reason_code INTO l_merge_reason_code
635: FROM HZ_MERGE_BATCH
636: WHERE batch_id = p_batch_id;
637:
638: IF l_merge_reason_code = 'DUPLICATE' THEN
639: -- ***************************************************************************

Line 753: from HZ_MERGE_BATCH

749:
750: x_return_status := FND_API.G_RET_STS_SUCCESS;
751:
752: select merge_reason_code into l_merge_reason_code
753: from HZ_MERGE_BATCH
754: where batch_id = p_batch_id;
755:
756: -- ***************************************************************************
757: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 822: FROM HZ_MERGE_BATCH

818:
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
820:
821: SELECT merge_reason_code INTO l_merge_reason_code
822: FROM HZ_MERGE_BATCH
823: WHERE batch_id = p_batch_id;
824:
825: -- ***************************************************************************
826: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 891: FROM HZ_MERGE_BATCH

887:
888: x_return_status := FND_API.G_RET_STS_SUCCESS;
889:
890: SELECT merge_reason_code INTO l_merge_reason_code
891: FROM HZ_MERGE_BATCH
892: WHERE batch_id = p_batch_id;
893:
894: -- ***************************************************************************
895: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 957: FROM HZ_MERGE_BATCH

953:
954: x_return_status := FND_API.G_RET_STS_SUCCESS;
955:
956: SELECT merge_reason_code INTO l_merge_reason_code
957: FROM HZ_MERGE_BATCH
958: WHERE batch_id = p_batch_id;
959:
960: -- ***************************************************************************
961: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1026: FROM HZ_MERGE_BATCH

1022:
1023: x_return_status := FND_API.G_RET_STS_SUCCESS;
1024:
1025: SELECT merge_reason_code INTO l_merge_reason_code
1026: FROM HZ_MERGE_BATCH
1027: WHERE batch_id = p_batch_id;
1028:
1029: -- ***************************************************************************
1030: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1095: FROM HZ_MERGE_BATCH

1091:
1092: x_return_status := FND_API.G_RET_STS_SUCCESS;
1093:
1094: SELECT merge_reason_code INTO l_merge_reason_code
1095: FROM HZ_MERGE_BATCH
1096: WHERE batch_id = p_batch_id;
1097:
1098: -- ***************************************************************************
1099: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1164: FROM HZ_MERGE_BATCH

1160:
1161: x_return_status := FND_API.G_RET_STS_SUCCESS;
1162:
1163: SELECT merge_reason_code INTO l_merge_reason_code
1164: FROM HZ_MERGE_BATCH
1165: WHERE batch_id = p_batch_id;
1166:
1167: -- ***************************************************************************
1168: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1234: FROM HZ_MERGE_BATCH

1230:
1231: x_return_status := FND_API.G_RET_STS_SUCCESS;
1232:
1233: SELECT merge_reason_code INTO l_merge_reason_code
1234: FROM HZ_MERGE_BATCH
1235: WHERE batch_id = p_batch_id;
1236:
1237: -- ***************************************************************************
1238: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1304: FROM HZ_MERGE_BATCH

1300:
1301: x_return_status := FND_API.G_RET_STS_SUCCESS;
1302:
1303: SELECT merge_reason_code INTO l_merge_reason_code
1304: FROM HZ_MERGE_BATCH
1305: WHERE batch_id = p_batch_id;
1306:
1307: -- ***************************************************************************
1308: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1373: FROM HZ_MERGE_BATCH

1369:
1370: x_return_status := FND_API.G_RET_STS_SUCCESS;
1371:
1372: SELECT merge_reason_code INTO l_merge_reason_code
1373: FROM HZ_MERGE_BATCH
1374: WHERE batch_id = p_batch_id;
1375:
1376: -- ***************************************************************************
1377: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1443: FROM HZ_MERGE_BATCH

1439:
1440: x_return_status := FND_API.G_RET_STS_SUCCESS;
1441:
1442: SELECT merge_reason_code INTO l_merge_reason_code
1443: FROM HZ_MERGE_BATCH
1444: WHERE batch_id = p_batch_id;
1445:
1446: -- ***************************************************************************
1447: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1512: FROM HZ_MERGE_BATCH

1508:
1509: x_return_status := FND_API.G_RET_STS_SUCCESS;
1510:
1511: SELECT merge_reason_code INTO l_merge_reason_code
1512: FROM HZ_MERGE_BATCH
1513: WHERE batch_id = p_batch_id;
1514:
1515: -- ***************************************************************************
1516: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1581: FROM HZ_MERGE_BATCH

1577:
1578: x_return_status := FND_API.G_RET_STS_SUCCESS;
1579:
1580: SELECT merge_reason_code INTO l_merge_reason_code
1581: FROM HZ_MERGE_BATCH
1582: WHERE batch_id = p_batch_id;
1583:
1584: -- ***************************************************************************
1585: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1650: FROM HZ_MERGE_BATCH

1646:
1647: x_return_status := FND_API.G_RET_STS_SUCCESS;
1648:
1649: SELECT merge_reason_code INTO l_merge_reason_code
1650: FROM HZ_MERGE_BATCH
1651: WHERE batch_id = p_batch_id;
1652:
1653: -- ***************************************************************************
1654: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1719: FROM HZ_MERGE_BATCH

1715:
1716: x_return_status := FND_API.G_RET_STS_SUCCESS;
1717:
1718: SELECT merge_reason_code INTO l_merge_reason_code
1719: FROM HZ_MERGE_BATCH
1720: WHERE batch_id = p_batch_id;
1721:
1722: -- ***************************************************************************
1723: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1788: FROM HZ_MERGE_BATCH

1784:
1785: x_return_status := FND_API.G_RET_STS_SUCCESS;
1786:
1787: SELECT merge_reason_code INTO l_merge_reason_code
1788: FROM HZ_MERGE_BATCH
1789: WHERE batch_id = p_batch_id;
1790:
1791: -- ***************************************************************************
1792: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1857: FROM HZ_MERGE_BATCH

1853:
1854: x_return_status := FND_API.G_RET_STS_SUCCESS;
1855:
1856: SELECT merge_reason_code INTO l_merge_reason_code
1857: FROM HZ_MERGE_BATCH
1858: WHERE batch_id = p_batch_id;
1859:
1860: -- ***************************************************************************
1861: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1926: FROM HZ_MERGE_BATCH

1922:
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924:
1925: SELECT merge_reason_code INTO l_merge_reason_code
1926: FROM HZ_MERGE_BATCH
1927: WHERE batch_id = p_batch_id;
1928:
1929: -- ***************************************************************************
1930: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 1995: FROM HZ_MERGE_BATCH

1991:
1992: x_return_status := FND_API.G_RET_STS_SUCCESS;
1993:
1994: SELECT merge_reason_code INTO l_merge_reason_code
1995: FROM HZ_MERGE_BATCH
1996: WHERE batch_id = p_batch_id;
1997:
1998: -- ***************************************************************************
1999: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 2064: FROM HZ_MERGE_BATCH

2060:
2061: x_return_status := FND_API.G_RET_STS_SUCCESS;
2062:
2063: SELECT merge_reason_code INTO l_merge_reason_code
2064: FROM HZ_MERGE_BATCH
2065: WHERE batch_id = p_batch_id;
2066:
2067: -- ***************************************************************************
2068: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 2134: FROM HZ_MERGE_BATCH

2130:
2131: x_return_status := FND_API.G_RET_STS_SUCCESS;
2132:
2133: SELECT merge_reason_code INTO l_merge_reason_code
2134: FROM HZ_MERGE_BATCH
2135: WHERE batch_id = p_batch_id;
2136:
2137: -- ***************************************************************************
2138: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 2204: FROM HZ_MERGE_BATCH

2200:
2201: x_return_status := FND_API.G_RET_STS_SUCCESS;
2202:
2203: SELECT merge_reason_code INTO l_merge_reason_code
2204: FROM HZ_MERGE_BATCH
2205: WHERE batch_id = p_batch_id;
2206:
2207: -- ***************************************************************************
2208: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 2274: FROM HZ_MERGE_BATCH

2270:
2271: x_return_status := FND_API.G_RET_STS_SUCCESS;
2272:
2273: SELECT merge_reason_code INTO l_merge_reason_code
2274: FROM HZ_MERGE_BATCH
2275: WHERE batch_id = p_batch_id;
2276:
2277: -- ***************************************************************************
2278: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 2343: FROM HZ_MERGE_BATCH

2339:
2340: x_return_status := FND_API.G_RET_STS_SUCCESS;
2341:
2342: SELECT merge_reason_code INTO l_merge_reason_code
2343: FROM HZ_MERGE_BATCH
2344: WHERE batch_id = p_batch_id;
2345:
2346: -- ***************************************************************************
2347: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 2411: FROM HZ_MERGE_BATCH

2407:
2408: x_return_status := FND_API.G_RET_STS_SUCCESS;
2409:
2410: SELECT merge_reason_code INTO l_merge_reason_code
2411: FROM HZ_MERGE_BATCH
2412: WHERE batch_id = p_batch_id;
2413:
2414: -- ***************************************************************************
2415: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 2480: FROM HZ_MERGE_BATCH

2476:
2477: x_return_status := FND_API.G_RET_STS_SUCCESS;
2478:
2479: SELECT merge_reason_code INTO l_merge_reason_code
2480: FROM HZ_MERGE_BATCH
2481: WHERE batch_id = p_batch_id;
2482:
2483: -- ***************************************************************************
2484: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 2549: FROM HZ_MERGE_BATCH

2545:
2546: x_return_status := FND_API.G_RET_STS_SUCCESS;
2547:
2548: SELECT merge_reason_code INTO l_merge_reason_code
2549: FROM HZ_MERGE_BATCH
2550: WHERE batch_id = p_batch_id;
2551:
2552: -- ***************************************************************************
2553: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 2618: FROM HZ_MERGE_BATCH

2614:
2615: x_return_status := FND_API.G_RET_STS_SUCCESS;
2616:
2617: SELECT merge_reason_code INTO l_merge_reason_code
2618: FROM HZ_MERGE_BATCH
2619: WHERE batch_id = p_batch_id;
2620:
2621: -- ***************************************************************************
2622: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 2684: FROM HZ_MERGE_BATCH

2680:
2681: x_return_status := FND_API.G_RET_STS_SUCCESS;
2682:
2683: SELECT merge_reason_code INTO l_merge_reason_code
2684: FROM HZ_MERGE_BATCH
2685: WHERE batch_id = p_batch_id;
2686:
2687: -- ***************************************************************************
2688: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 2751: from HZ_MERGE_BATCH

2747:
2748: x_return_status := FND_API.G_RET_STS_SUCCESS;
2749:
2750: select merge_reason_code into l_merge_reason_code
2751: from HZ_MERGE_BATCH
2752: where batch_id = p_batch_id;
2753:
2754: -- ***************************************************************************
2755: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing

Line 2818: FROM HZ_MERGE_BATCH

2814:
2815: x_return_status := FND_API.G_RET_STS_SUCCESS;
2816:
2817: SELECT merge_reason_code INTO l_merge_reason_code
2818: FROM HZ_MERGE_BATCH
2819: WHERE batch_id = p_batch_id;
2820:
2821: -- ***************************************************************************
2822: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing