DBA Data[Home] [Help]

APPS.OKL_PARTY_MERGE_PUB dependencies on HZ_MERGE_BATCH

Line 783: from hz_merge_batch

779: x_return_status := FND_API.G_RET_STS_SUCCESS;
780:
781: select merge_reason_code
782: into l_merge_reason_code
783: from hz_merge_batch
784: where batch_id = p_batch_id;
785:
786: if l_merge_reason_code = 'DUPLICATE' then
787: -- if reason code is duplicate then allow the party merge to happen without

Line 869: from hz_merge_batch

865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867: select merge_reason_code
868: into l_merge_reason_code
869: from hz_merge_batch
870: where batch_id = p_batch_id;
871:
872: if l_merge_reason_code = 'DUPLICATE' then
873: -- if reason code is duplicate then allow the party merge to happen without

Line 954: from hz_merge_batch

950: x_return_status := FND_API.G_RET_STS_SUCCESS;
951:
952: select merge_reason_code
953: into l_merge_reason_code
954: from hz_merge_batch
955: where batch_id = p_batch_id;
956:
957: if l_merge_reason_code = 'DUPLICATE' then
958: -- if reason code is duplicate then allow the party merge to happen without

Line 1039: from hz_merge_batch

1035: x_return_status := FND_API.G_RET_STS_SUCCESS;
1036:
1037: select merge_reason_code
1038: into l_merge_reason_code
1039: from hz_merge_batch
1040: where batch_id = p_batch_id;
1041:
1042: if l_merge_reason_code = 'DUPLICATE' then
1043: -- if reason code is duplicate then allow the party merge to happen without

Line 1117: from hz_merge_batch

1113: x_return_status := FND_API.G_RET_STS_SUCCESS;
1114:
1115: select merge_reason_code
1116: into l_merge_reason_code
1117: from hz_merge_batch
1118: where batch_id = p_batch_id;
1119:
1120: if l_merge_reason_code = 'DUPLICATE' then
1121: -- if reason code is duplicate then allow the party merge to happen without

Line 1201: FROM hz_merge_batch

1197: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198:
1199: SELECT merge_reason_code
1200: INTO l_merge_reason_code
1201: FROM hz_merge_batch
1202: WHERE batch_id = p_batch_id;
1203:
1204: IF l_merge_reason_code = 'DUPLICATE' then
1205: -- if reason code is duplicate then allow the party merge to happen

Line 1279: FROM hz_merge_batch

1275: x_return_status := FND_API.G_RET_STS_SUCCESS;
1276:
1277: SELECT merge_reason_code
1278: INTO l_merge_reason_code
1279: FROM hz_merge_batch
1280: WHERE batch_id = p_batch_id;
1281:
1282: IF l_merge_reason_code = 'DUPLICATE' then
1283: -- if reason code is duplicate then allow the party merge to happen

Line 1445: from hz_merge_batch

1441: x_return_status := FND_API.G_RET_STS_SUCCESS;
1442:
1443: select merge_reason_code
1444: into l_merge_reason_code
1445: from hz_merge_batch
1446: where batch_id = p_batch_id;
1447:
1448: if l_merge_reason_code = 'DUPLICATE' then
1449: -- if reason code is duplicate then allow the party merge to happen without

Line 1536: from hz_merge_batch

1532: arp_message.set_line('OKL_PARTY_MERGE_PUB.ITI_OBJECT_ID1_NEW()+');
1533: x_return_status := FND_API.G_RET_STS_SUCCESS;
1534:
1535: select merge_reason_code into l_merge_reason_code
1536: from hz_merge_batch
1537: where batch_id = p_batch_id;
1538:
1539: if l_merge_reason_code = 'DUPLICATE' then
1540: -- if reason code is duplicate then allow the party merge to happen without

Line 1665: from hz_merge_batch

1661: x_return_status := FND_API.G_RET_STS_SUCCESS;
1662:
1663: select merge_reason_code
1664: into l_merge_reason_code
1665: from hz_merge_batch
1666: where batch_id = p_batch_id;
1667:
1668: if l_merge_reason_code = 'DUPLICATE' then
1669: -- if reason code is duplicate then allow the party merge to happen without

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: -- if reason code is duplicate then allow the party merge to happen without

Line 1870: from hz_merge_batch

1866: arp_message.set_line('OKL_PARTY_MERGE_PUB.LOP_PARTY_MERGE()+');
1867: x_return_status := FND_API.G_RET_STS_SUCCESS;
1868:
1869: select merge_reason_code into l_merge_reason_code
1870: from hz_merge_batch
1871: where batch_id = p_batch_id;
1872:
1873: if l_merge_reason_code = 'DUPLICATE'
1874: then

Line 1989: from hz_merge_batch

1985: arp_message.set_line('OKL_PARTY_MERGE_PUB.LOP_USAGE_LOCATION()+');
1986: x_return_status := FND_API.G_RET_STS_SUCCESS;
1987:
1988: select merge_reason_code into l_merge_reason_code
1989: from hz_merge_batch
1990: where batch_id = p_batch_id;
1991:
1992: if l_merge_reason_code = 'DUPLICATE'
1993: then

Line 2089: from hz_merge_batch

2085: x_return_status := FND_API.G_RET_STS_SUCCESS;
2086:
2087: select merge_reason_code
2088: into l_merge_reason_code
2089: from hz_merge_batch
2090: where batch_id = p_batch_id;
2091:
2092: if l_merge_reason_code = 'DUPLICATE' then
2093: --if reason code is duplicate then allow the party merge to happen without

Line 2196: from hz_merge_batch

2192: x_return_status := FND_API.G_RET_STS_SUCCESS;
2193:
2194: select merge_reason_code
2195: 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: -- if reason code is duplicate then allow the party merge to happen without

Line 2306: from hz_merge_batch

2302: x_return_status := FND_API.G_RET_STS_SUCCESS;
2303:
2304: select merge_reason_code
2305: into l_merge_reason_code
2306: from hz_merge_batch
2307: where batch_id = p_batch_id;
2308:
2309: if l_merge_reason_code = 'DUPLICATE' then
2310: -- if reason code is duplicate then allow the party merge to happen without

Line 2415: from hz_merge_batch

2411: x_return_status := FND_API.G_RET_STS_SUCCESS;
2412:
2413: select merge_reason_code
2414: into l_merge_reason_code
2415: from hz_merge_batch
2416: where batch_id = p_batch_id;
2417:
2418: if l_merge_reason_code = 'DUPLICATE' then
2419: -- if reason code is duplicate then allow the party merge to happen without

Line 2524: from hz_merge_batch

2520: x_return_status := FND_API.G_RET_STS_SUCCESS;
2521:
2522: select merge_reason_code
2523: into l_merge_reason_code
2524: from hz_merge_batch
2525: where batch_id = p_batch_id;
2526:
2527: if l_merge_reason_code = 'DUPLICATE' then
2528: -- if reason code is duplicate then allow the party merge to happen without

Line 2624: from hz_merge_batch

2620: x_return_status := FND_API.G_RET_STS_SUCCESS;
2621:
2622: select merge_reason_code
2623: into l_merge_reason_code
2624: from hz_merge_batch
2625: where batch_id = p_batch_id;
2626:
2627: if l_merge_reason_code = 'DUPLICATE' then
2628: -- if reason code is duplicate then allow the party merge to happen without

Line 2720: from hz_merge_batch

2716: x_return_status := FND_API.G_RET_STS_SUCCESS;
2717:
2718: select merge_reason_code
2719: into l_merge_reason_code
2720: from hz_merge_batch
2721: where batch_id = p_batch_id;
2722:
2723: if l_merge_reason_code = 'DUPLICATE' then
2724: -- if reason code is duplicate then allow the party merge to happen without

Line 2816: from hz_merge_batch

2812: x_return_status := FND_API.G_RET_STS_SUCCESS;
2813:
2814: select merge_reason_code
2815: into l_merge_reason_code
2816: from hz_merge_batch
2817: where batch_id = p_batch_id;
2818:
2819: if l_merge_reason_code = 'DUPLICATE' then
2820: -- if reason code is duplicate then allow the party merge to happen without

Line 3024: from hz_merge_batch

3020: RAISE okl_api.g_exception_error;
3021: END IF;
3022:
3023: select merge_reason_code into l_merge_reason_code
3024: from hz_merge_batch
3025: where batch_id = p_batch_id;
3026:
3027: if l_merge_reason_code = 'DUPLICATE' then
3028: -- if reason code is duplicate then allow the party merge to happen without

Line 3327: from hz_merge_batch

3323:
3324: x_return_status := FND_API.G_RET_STS_SUCCESS;
3325:
3326: select merge_reason_code into l_merge_reason_code
3327: from hz_merge_batch
3328: where batch_id = p_batch_id;
3329:
3330: if l_merge_reason_code = 'DUPLICATE' then
3331: -- if reason code is duplicate then allow the party merge to happen without

Line 5885: from hz_merge_batch

5881: x_return_status := FND_API.G_RET_STS_SUCCESS;
5882:
5883: select merge_reason_code
5884: into l_merge_reason_code
5885: from hz_merge_batch
5886: where batch_id = p_batch_id;
5887:
5888: if l_merge_reason_code = 'DUPLICATE' then
5889: -- if reason code is duplicate then allow the party merge to happen without

Line 5984: from hz_merge_batch

5980: x_return_status := FND_API.G_RET_STS_SUCCESS;
5981:
5982: select merge_reason_code
5983: into l_merge_reason_code
5984: from hz_merge_batch
5985: where batch_id = p_batch_id;
5986:
5987: if l_merge_reason_code = 'DUPLICATE' then
5988: -- if reason code is duplicate then allow the party merge to happen without

Line 6083: from hz_merge_batch

6079: x_return_status := FND_API.G_RET_STS_SUCCESS;
6080:
6081: select merge_reason_code
6082: into l_merge_reason_code
6083: from hz_merge_batch
6084: where batch_id = p_batch_id;
6085:
6086: if l_merge_reason_code = 'DUPLICATE' then
6087: -- if reason code is duplicate then allow the party merge to happen without

Line 6181: from hz_merge_batch

6177: arp_message.set_line('OKL_PARTY_MERGE_PUB.RUL_PARTY_SITE_MERGE()+');
6178: x_return_status := FND_API.G_RET_STS_SUCCESS;
6179:
6180: select merge_reason_code into l_merge_reason_code
6181: from hz_merge_batch
6182: where batch_id = p_batch_id;
6183:
6184: if l_merge_reason_code = 'DUPLICATE' then
6185: -- if reason code is duplicate then allow the party merge to happen without