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.ARH_CONT_PKG dependencies on FND_API

Line 49: res_date := FND_API.G_MISS_DATE;

45: res_date date;
46: BEGIN
47: IF p_switch = 'NULL_GMISS' THEN
48: IF p_date IS NULL THEN
49: res_date := FND_API.G_MISS_DATE;
50: ELSE
51: res_date := p_date;
52: END IF;
53: ELSIF p_switch = 'GMISS_NULL' THEN

Line 54: IF p_date = FND_API.G_MISS_DATE THEN

50: ELSE
51: res_date := p_date;
52: END IF;
53: ELSIF p_switch = 'GMISS_NULL' THEN
54: IF p_date = FND_API.G_MISS_DATE THEN
55: res_date := NULL;
56: ELSE
57: res_date := p_date;
58: END IF;

Line 74: return FND_API.G_MISS_CHAR;

70: res_char varchar2(2000);
71: BEGIN
72: IF p_switch = 'NULL_GMISS' THEN
73: IF p_char IS NULL THEN
74: return FND_API.G_MISS_CHAR;
75: ELSE
76: return p_char;
77: END IF;
78: ELSIF p_switch = 'GMISS_NULL' THEN

Line 79: IF p_char = FND_API.G_MISS_CHAR THEN

75: ELSE
76: return p_char;
77: END IF;
78: ELSIF p_switch = 'GMISS_NULL' THEN
79: IF p_char = FND_API.G_MISS_CHAR THEN
80: return NULL;
81: ELSE
82: return p_char;
83: END IF;

Line 97: return FND_API.G_MISS_NUM;

93: IS
94: BEGIN
95: IF p_switch = 'NULL_GMISS' THEN
96: IF p_num IS NULL THEN
97: return FND_API.G_MISS_NUM;
98: ELSE
99: return p_num;
100: END IF;
101: ELSIF p_switch = 'GMISS_NULL' THEN

Line 102: IF p_num = FND_API.G_MISS_NUM THEN

98: ELSE
99: return p_num;
100: END IF;
101: ELSIF p_switch = 'GMISS_NULL' THEN
102: IF p_num = FND_API.G_MISS_NUM THEN
103: return NULL;
104: ELSE
105: return p_num;
106: END IF;

Line 216: x_return_status := FND_API.G_RET_STS_ERROR;

212: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
213: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
214: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
215: FND_MSG_PUB.ADD;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: ELSE
218: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
219: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
220: THEN

Line 224: x_return_status := FND_API.G_RET_STS_ERROR;

220: THEN
221: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
222: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
223: FND_MSG_PUB.ADD;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: END IF;
226: END IF;
227: END;
228:

Line 254: x_return_status := FND_API.G_RET_STS_ERROR;

250: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
251: FND_MESSAGE.SET_TOKEN('RECORD','HZ_ORG_CONTACTS');
252: FND_MESSAGE.SET_TOKEN('ID',p_org_contact_id);
253: FND_MSG_PUB.ADD;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: END IF;
256: CLOSE cu_org_contact_update;
257: EXCEPTION
258: WHEN OTHERS THEN

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

261: END IF;
262: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
263: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
264: FND_MSG_PUB.ADD;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: END;
267:
268:
269: PROCEDURE check_unique_contact_name (

Line 677: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

673: x_msg_data => x_msg_data );
674:
675: IF x_msg_count > 1 THEN
676: FOR i IN 1..x_msg_count LOOP
677: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
678: tmp_var1 := tmp_var1 || ' '|| tmp_var;
679: END LOOP;
680: x_msg_data := tmp_var1;
681: END IF;

Line 683: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

679: END LOOP;
680: x_msg_data := tmp_var1;
681: END IF;
682:
683: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
684: return;
685: END IF;
686:
687: x_contact_party_id := i_subject_party_id;

Line 772: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

768: x_msg_data => x_msg_data );
769:
770: IF x_msg_count > 1 THEN
771: FOR i IN 1..x_msg_count LOOP
772: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
773: tmp_var1 := tmp_var1 || ' '|| tmp_var;
774: END LOOP;
775: x_msg_data := tmp_var1;
776: END IF;

Line 778: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

774: END LOOP;
775: x_msg_data := tmp_var1;
776: END IF;
777:
778: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
779: return;
780: END IF;
781:
782: x_org_contact_id := i_org_contact_id;

Line 794: AND (X_Mail_Stop <> FND_API.G_MISS_CHAR))

790: -- This fix has to be removed if V2 hz_party_contact_v2pub.org_contact_rec_type is
791: -- changed to support the attribute MAIL_STOP
792: --
793: IF ( (X_Mail_Stop IS NOT NULL)
794: AND (X_Mail_Stop <> FND_API.G_MISS_CHAR))
795: THEN
796: update_mail_stop
797: ( p_org_contact_id => x_org_contact_id,
798: p_mail_stop => X_Mail_Stop,

Line 804: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

800: x_msg_data => x_msg_data);
801:
802: IF x_msg_count > 1 THEN
803: FOR i IN 1..x_msg_count LOOP
804: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
805: tmp_var1 := tmp_var1 || ' '|| tmp_var;
806: END LOOP;
807: x_msg_data := tmp_var1;
808: END IF;

Line 810: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

806: END LOOP;
807: x_msg_data := tmp_var1;
808: END IF;
809:
810: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
811: return;
812: END IF;
813:
814: END IF;

Line 893: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

889: x_contact_point_id := i_contact_point_id;
890:
891: IF x_msg_count > 1 THEN
892: FOR i IN 1..x_msg_count LOOP
893: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
894: tmp_var1 := tmp_var1 || ' '|| tmp_var;
895: END LOOP;
896: x_msg_data := tmp_var1;
897: END IF;

Line 899: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

895: END LOOP;
896: x_msg_data := tmp_var1;
897: END IF;
898:
899: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
900: return;
901: END IF;
902:
903: END IF;

Line 957: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

953: );
954:
955: IF x_msg_count > 1 THEN
956: FOR i IN 1..x_msg_count LOOP
957: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
958: tmp_var1 := tmp_var1 || ' '|| tmp_var;
959: END LOOP;
960: x_msg_data := tmp_var1;
961: END IF;

Line 963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

959: END LOOP;
960: x_msg_data := tmp_var1;
961: END IF;
962:
963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
964: return;
965: END IF;
966:
967: IF x_return_status = 'S' and x_orig_system_reference is not null THEN

Line 1362: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1358: x_msg_data => x_msg_data );
1359:
1360: IF x_msg_count > 1 THEN
1361: FOR i IN 1..x_msg_count LOOP
1362: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1363: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1364: END LOOP;
1365: x_msg_data := tmp_var1;
1366: END IF;

Line 1368: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1364: END LOOP;
1365: x_msg_data := tmp_var1;
1366: END IF;
1367:
1368: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1369: return;
1370: END IF;
1371:
1372: END IF;

Line 1385: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1381: );
1382:
1383: IF x_msg_count > 1 THEN
1384: FOR i IN 1..x_msg_count LOOP
1385: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1386: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1387: END LOOP;
1388: x_msg_data := tmp_var1;
1389: END IF;

Line 1391: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1387: END LOOP;
1388: x_msg_data := tmp_var1;
1389: END IF;
1390:
1391: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1392: return;
1393: END IF;
1394:
1395:

Line 1418: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1414: x_msg_data => x_msg_data );
1415:
1416: IF x_msg_count > 1 THEN
1417: FOR i IN 1..x_msg_count LOOP
1418: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1419: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1420: END LOOP;
1421: x_msg_data := tmp_var1;
1422: END IF;

Line 1424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1420: END LOOP;
1421: x_msg_data := tmp_var1;
1422: END IF;
1423:
1424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1425: return;
1426: END IF;
1427:
1428: END IF;

Line 1446: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1442: x_msg_data => x_msg_data );
1443:
1444: IF x_msg_count > 1 THEN
1445: FOR i IN 1..x_msg_count LOOP
1446: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1447: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1448: END LOOP;
1449: x_msg_data := tmp_var1;
1450: END IF;

Line 1452: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1448: END LOOP;
1449: x_msg_data := tmp_var1;
1450: END IF;
1451:
1452: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1453: return;
1454: END IF;
1455: END IF;
1456:

Line 1472: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1468: x_msg_data => x_msg_data );
1469:
1470: IF x_msg_count > 1 THEN
1471: FOR i IN 1..x_msg_count LOOP
1472: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1473: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1474: END LOOP;
1475: x_msg_data := tmp_var1;
1476: END IF;

Line 1478: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1474: END LOOP;
1475: x_msg_data := tmp_var1;
1476: END IF;
1477:
1478: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1479: return;
1480: END IF;
1481:
1482: END IF;

Line 1484: IF X_org_cont_Last_Update_Date = FND_API.G_MISS_DATE

1480: END IF;
1481:
1482: END IF;
1483:
1484: IF X_org_cont_Last_Update_Date = FND_API.G_MISS_DATE
1485: OR
1486: X_org_cont_Last_Update_Date IS NULL
1487: THEN
1488: ocon_rec.party_rel_rec.party_rec.party_id := NULL;

Line 1494: l_rel_last_update_date <> FND_API.G_MISS_DATE

1490: ocon_rec.party_rel_rec.party_rec.party_id := l_party_id;
1491: END IF;
1492:
1493: IF l_rel_last_update_date IS NOT NULL AND
1494: l_rel_last_update_date <> FND_API.G_MISS_DATE
1495: THEN
1496: ocon_rec.party_rel_rec.relationship_id := l_rel_id;
1497: ELSE
1498: ocon_rec.party_rel_rec.relationship_id := NULL;

Line 1513: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1509: );
1510:
1511: IF x_msg_count > 1 THEN
1512: FOR i IN 1..x_msg_count LOOP
1513: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1514: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1515: END LOOP;
1516: x_msg_data := tmp_var1;
1517: END IF;

Line 1519: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1515: END LOOP;
1516: x_msg_data := tmp_var1;
1517: END IF;
1518:
1519: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1520: return;
1521: END IF;
1522:
1523:

Line 1531: AND (X_Mail_Stop <> FND_API.G_MISS_CHAR)

1527: -- This fix has to be removed if V2 hz_party_contact_v2pub.org_contact_rec_type is
1528: -- changed to support the attribute MAIL_STOP
1529: --
1530: IF (X_Mail_Stop IS NOT NULL)
1531: AND (X_Mail_Stop <> FND_API.G_MISS_CHAR)
1532: THEN
1533: update_mail_stop
1534: ( p_org_contact_id => x_org_contact_id,
1535: p_mail_stop => X_Mail_Stop,

Line 1541: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1537: x_msg_data => x_msg_data);
1538:
1539: IF x_msg_count > 1 THEN
1540: FOR i IN 1..x_msg_count LOOP
1541: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1542: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1543: END LOOP;
1544: x_msg_data := tmp_var1;
1545: END IF;

Line 1547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1543: END LOOP;
1544: x_msg_data := tmp_var1;
1545: END IF;
1546:
1547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1548: return;
1549: END IF;
1550:
1551: END IF;

Line 1634: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1630: x_msg_data => x_msg_data );
1631:
1632: IF x_msg_count > 1 THEN
1633: FOR i IN 1..x_msg_count LOOP
1634: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1635: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1636: END LOOP;
1637: x_msg_data := tmp_var1;
1638: END IF;

Line 1640: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1636: END LOOP;
1637: x_msg_data := tmp_var1;
1638: END IF;
1639:
1640: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1641: return;
1642: END IF;
1643: END IF;
1644:

Line 1665: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1661: );
1662:
1663: IF x_msg_count > 1 THEN
1664: FOR i IN 1..x_msg_count LOOP
1665: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1666: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1667: END LOOP;
1668: x_msg_data := tmp_var1;
1669: END IF;

Line 1671: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1667: END LOOP;
1668: x_msg_data := tmp_var1;
1669: END IF;
1670:
1671: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1672: return;
1673: END IF;
1674:
1675: select last_update_date,

Line 1709: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1705:
1706:
1707: IF x_msg_count > 1 THEN
1708: FOR i IN 1..x_msg_count LOOP
1709: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1710: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1711: END LOOP;
1712: x_msg_data := tmp_var1;
1713: END IF;

Line 1715: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1711: END LOOP;
1712: x_msg_data := tmp_var1;
1713: END IF;
1714:
1715: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1716: return;
1717: END IF;
1718:
1719: x_contact_point_id := i_contact_point_id;

Line 1750: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1746: x_msg_data => x_msg_data );
1747:
1748: IF x_msg_count > 1 THEN
1749: FOR i IN 1..x_msg_count LOOP
1750: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1751: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1752: END LOOP;
1753: x_msg_data := tmp_var1;
1754: END IF;

Line 1756: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1752: END LOOP;
1753: x_msg_data := tmp_var1;
1754: END IF;
1755:
1756: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1757: return;
1758: END IF;
1759: END IF;
1760:

Line 1771: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1767: );
1768:
1769: IF x_msg_count > 1 THEN
1770: FOR i IN 1..x_msg_count LOOP
1771: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1772: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1773: END LOOP;
1774: x_msg_data := tmp_var1;
1775: END IF;

Line 1777: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1773: END LOOP;
1774: x_msg_data := tmp_var1;
1775: END IF;
1776:
1777: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1778: return;
1779: END IF;
1780:
1781: select cust_account_role_id

Line 1885: IF NVL(l_ocon_rec.contact_number,fnd_api.g_miss_char)

1881: RAISE NO_DATA_FOUND;
1882: END IF;
1883: CLOSE c;
1884:
1885: IF NVL(l_ocon_rec.contact_number,fnd_api.g_miss_char)
1886: <> NVL(p_ocon_rec.contact_number,fnd_api.g_miss_char) THEN
1887: x_update_required := 'Y';
1888: ELSIF
1889: NVL(l_ocon_rec.title ,fnd_api.g_miss_char)

Line 1886: <> NVL(p_ocon_rec.contact_number,fnd_api.g_miss_char) THEN

1882: END IF;
1883: CLOSE c;
1884:
1885: IF NVL(l_ocon_rec.contact_number,fnd_api.g_miss_char)
1886: <> NVL(p_ocon_rec.contact_number,fnd_api.g_miss_char) THEN
1887: x_update_required := 'Y';
1888: ELSIF
1889: NVL(l_ocon_rec.title ,fnd_api.g_miss_char)
1890: <> NVL(p_ocon_rec.title ,fnd_api.g_miss_char) THEN

Line 1889: NVL(l_ocon_rec.title ,fnd_api.g_miss_char)

1885: IF NVL(l_ocon_rec.contact_number,fnd_api.g_miss_char)
1886: <> NVL(p_ocon_rec.contact_number,fnd_api.g_miss_char) THEN
1887: x_update_required := 'Y';
1888: ELSIF
1889: NVL(l_ocon_rec.title ,fnd_api.g_miss_char)
1890: <> NVL(p_ocon_rec.title ,fnd_api.g_miss_char) THEN
1891: x_update_required := 'Y';
1892: ELSIF
1893: NVL(l_ocon_rec.job_title ,fnd_api.g_miss_char)

Line 1890: <> NVL(p_ocon_rec.title ,fnd_api.g_miss_char) THEN

1886: <> NVL(p_ocon_rec.contact_number,fnd_api.g_miss_char) THEN
1887: x_update_required := 'Y';
1888: ELSIF
1889: NVL(l_ocon_rec.title ,fnd_api.g_miss_char)
1890: <> NVL(p_ocon_rec.title ,fnd_api.g_miss_char) THEN
1891: x_update_required := 'Y';
1892: ELSIF
1893: NVL(l_ocon_rec.job_title ,fnd_api.g_miss_char)
1894: <> NVL(p_ocon_rec.job_title ,fnd_api.g_miss_char) THEN

Line 1893: NVL(l_ocon_rec.job_title ,fnd_api.g_miss_char)

1889: NVL(l_ocon_rec.title ,fnd_api.g_miss_char)
1890: <> NVL(p_ocon_rec.title ,fnd_api.g_miss_char) THEN
1891: x_update_required := 'Y';
1892: ELSIF
1893: NVL(l_ocon_rec.job_title ,fnd_api.g_miss_char)
1894: <> NVL(p_ocon_rec.job_title ,fnd_api.g_miss_char) THEN
1895: x_update_required := 'Y';
1896: ELSIF
1897: NVL(l_ocon_rec.job_title_code,fnd_api.g_miss_char)

Line 1894: <> NVL(p_ocon_rec.job_title ,fnd_api.g_miss_char) THEN

1890: <> NVL(p_ocon_rec.title ,fnd_api.g_miss_char) THEN
1891: x_update_required := 'Y';
1892: ELSIF
1893: NVL(l_ocon_rec.job_title ,fnd_api.g_miss_char)
1894: <> NVL(p_ocon_rec.job_title ,fnd_api.g_miss_char) THEN
1895: x_update_required := 'Y';
1896: ELSIF
1897: NVL(l_ocon_rec.job_title_code,fnd_api.g_miss_char)
1898: <> NVL(p_ocon_rec.job_title_code,fnd_api.g_miss_char) THEN

Line 1897: NVL(l_ocon_rec.job_title_code,fnd_api.g_miss_char)

1893: NVL(l_ocon_rec.job_title ,fnd_api.g_miss_char)
1894: <> NVL(p_ocon_rec.job_title ,fnd_api.g_miss_char) THEN
1895: x_update_required := 'Y';
1896: ELSIF
1897: NVL(l_ocon_rec.job_title_code,fnd_api.g_miss_char)
1898: <> NVL(p_ocon_rec.job_title_code,fnd_api.g_miss_char) THEN
1899: x_update_required := 'Y';
1900: ELSIF
1901: NVL(l_ocon_rec.party_site_id ,fnd_api.g_miss_num)

Line 1898: <> NVL(p_ocon_rec.job_title_code,fnd_api.g_miss_char) THEN

1894: <> NVL(p_ocon_rec.job_title ,fnd_api.g_miss_char) THEN
1895: x_update_required := 'Y';
1896: ELSIF
1897: NVL(l_ocon_rec.job_title_code,fnd_api.g_miss_char)
1898: <> NVL(p_ocon_rec.job_title_code,fnd_api.g_miss_char) THEN
1899: x_update_required := 'Y';
1900: ELSIF
1901: NVL(l_ocon_rec.party_site_id ,fnd_api.g_miss_num)
1902: <> NVL(p_ocon_rec.party_site_id ,fnd_api.g_miss_num) THEN

Line 1901: NVL(l_ocon_rec.party_site_id ,fnd_api.g_miss_num)

1897: NVL(l_ocon_rec.job_title_code,fnd_api.g_miss_char)
1898: <> NVL(p_ocon_rec.job_title_code,fnd_api.g_miss_char) THEN
1899: x_update_required := 'Y';
1900: ELSIF
1901: NVL(l_ocon_rec.party_site_id ,fnd_api.g_miss_num)
1902: <> NVL(p_ocon_rec.party_site_id ,fnd_api.g_miss_num) THEN
1903: x_update_required := 'Y';
1904: ELSIF
1905: NVL(l_ocon_rec.orig_system_reference,fnd_api.g_miss_char)

Line 1902: <> NVL(p_ocon_rec.party_site_id ,fnd_api.g_miss_num) THEN

1898: <> NVL(p_ocon_rec.job_title_code,fnd_api.g_miss_char) THEN
1899: x_update_required := 'Y';
1900: ELSIF
1901: NVL(l_ocon_rec.party_site_id ,fnd_api.g_miss_num)
1902: <> NVL(p_ocon_rec.party_site_id ,fnd_api.g_miss_num) THEN
1903: x_update_required := 'Y';
1904: ELSIF
1905: NVL(l_ocon_rec.orig_system_reference,fnd_api.g_miss_char)
1906: <> NVL(p_ocon_rec.orig_system_reference,fnd_api.g_miss_char) THEN

Line 1905: NVL(l_ocon_rec.orig_system_reference,fnd_api.g_miss_char)

1901: NVL(l_ocon_rec.party_site_id ,fnd_api.g_miss_num)
1902: <> NVL(p_ocon_rec.party_site_id ,fnd_api.g_miss_num) THEN
1903: x_update_required := 'Y';
1904: ELSIF
1905: NVL(l_ocon_rec.orig_system_reference,fnd_api.g_miss_char)
1906: <> NVL(p_ocon_rec.orig_system_reference,fnd_api.g_miss_char) THEN
1907: x_update_required := 'Y';
1908: ELSIF
1909: NVL(l_ocon_rec.attribute_category ,fnd_api.g_miss_char)

Line 1906: <> NVL(p_ocon_rec.orig_system_reference,fnd_api.g_miss_char) THEN

1902: <> NVL(p_ocon_rec.party_site_id ,fnd_api.g_miss_num) THEN
1903: x_update_required := 'Y';
1904: ELSIF
1905: NVL(l_ocon_rec.orig_system_reference,fnd_api.g_miss_char)
1906: <> NVL(p_ocon_rec.orig_system_reference,fnd_api.g_miss_char) THEN
1907: x_update_required := 'Y';
1908: ELSIF
1909: NVL(l_ocon_rec.attribute_category ,fnd_api.g_miss_char)
1910: <> NVL(p_ocon_rec.attribute_category ,fnd_api.g_miss_char) THEN

Line 1909: NVL(l_ocon_rec.attribute_category ,fnd_api.g_miss_char)

1905: NVL(l_ocon_rec.orig_system_reference,fnd_api.g_miss_char)
1906: <> NVL(p_ocon_rec.orig_system_reference,fnd_api.g_miss_char) THEN
1907: x_update_required := 'Y';
1908: ELSIF
1909: NVL(l_ocon_rec.attribute_category ,fnd_api.g_miss_char)
1910: <> NVL(p_ocon_rec.attribute_category ,fnd_api.g_miss_char) THEN
1911: x_update_required := 'Y';
1912: ELSIF
1913: NVL(l_ocon_rec.attribute1 ,fnd_api.g_miss_char)

Line 1910: <> NVL(p_ocon_rec.attribute_category ,fnd_api.g_miss_char) THEN

1906: <> NVL(p_ocon_rec.orig_system_reference,fnd_api.g_miss_char) THEN
1907: x_update_required := 'Y';
1908: ELSIF
1909: NVL(l_ocon_rec.attribute_category ,fnd_api.g_miss_char)
1910: <> NVL(p_ocon_rec.attribute_category ,fnd_api.g_miss_char) THEN
1911: x_update_required := 'Y';
1912: ELSIF
1913: NVL(l_ocon_rec.attribute1 ,fnd_api.g_miss_char)
1914: <> NVL(p_ocon_rec.attribute1 ,fnd_api.g_miss_char) THEN

Line 1913: NVL(l_ocon_rec.attribute1 ,fnd_api.g_miss_char)

1909: NVL(l_ocon_rec.attribute_category ,fnd_api.g_miss_char)
1910: <> NVL(p_ocon_rec.attribute_category ,fnd_api.g_miss_char) THEN
1911: x_update_required := 'Y';
1912: ELSIF
1913: NVL(l_ocon_rec.attribute1 ,fnd_api.g_miss_char)
1914: <> NVL(p_ocon_rec.attribute1 ,fnd_api.g_miss_char) THEN
1915: x_update_required := 'Y';
1916: ELSIF
1917: NVL(l_ocon_rec.attribute2 ,fnd_api.g_miss_char)

Line 1914: <> NVL(p_ocon_rec.attribute1 ,fnd_api.g_miss_char) THEN

1910: <> NVL(p_ocon_rec.attribute_category ,fnd_api.g_miss_char) THEN
1911: x_update_required := 'Y';
1912: ELSIF
1913: NVL(l_ocon_rec.attribute1 ,fnd_api.g_miss_char)
1914: <> NVL(p_ocon_rec.attribute1 ,fnd_api.g_miss_char) THEN
1915: x_update_required := 'Y';
1916: ELSIF
1917: NVL(l_ocon_rec.attribute2 ,fnd_api.g_miss_char)
1918: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1917: NVL(l_ocon_rec.attribute2 ,fnd_api.g_miss_char)

1913: NVL(l_ocon_rec.attribute1 ,fnd_api.g_miss_char)
1914: <> NVL(p_ocon_rec.attribute1 ,fnd_api.g_miss_char) THEN
1915: x_update_required := 'Y';
1916: ELSIF
1917: NVL(l_ocon_rec.attribute2 ,fnd_api.g_miss_char)
1918: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1919: x_update_required := 'Y';
1920: ELSIF
1921: NVL(l_ocon_rec.attribute3 ,fnd_api.g_miss_char)

Line 1918: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1914: <> NVL(p_ocon_rec.attribute1 ,fnd_api.g_miss_char) THEN
1915: x_update_required := 'Y';
1916: ELSIF
1917: NVL(l_ocon_rec.attribute2 ,fnd_api.g_miss_char)
1918: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1919: x_update_required := 'Y';
1920: ELSIF
1921: NVL(l_ocon_rec.attribute3 ,fnd_api.g_miss_char)
1922: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1921: NVL(l_ocon_rec.attribute3 ,fnd_api.g_miss_char)

1917: NVL(l_ocon_rec.attribute2 ,fnd_api.g_miss_char)
1918: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1919: x_update_required := 'Y';
1920: ELSIF
1921: NVL(l_ocon_rec.attribute3 ,fnd_api.g_miss_char)
1922: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1923: x_update_required := 'Y';
1924: ELSIF
1925: NVL(l_ocon_rec.attribute4 ,fnd_api.g_miss_char)

Line 1922: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1918: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1919: x_update_required := 'Y';
1920: ELSIF
1921: NVL(l_ocon_rec.attribute3 ,fnd_api.g_miss_char)
1922: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1923: x_update_required := 'Y';
1924: ELSIF
1925: NVL(l_ocon_rec.attribute4 ,fnd_api.g_miss_char)
1926: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1925: NVL(l_ocon_rec.attribute4 ,fnd_api.g_miss_char)

1921: NVL(l_ocon_rec.attribute3 ,fnd_api.g_miss_char)
1922: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1923: x_update_required := 'Y';
1924: ELSIF
1925: NVL(l_ocon_rec.attribute4 ,fnd_api.g_miss_char)
1926: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1927: x_update_required := 'Y';
1928: ELSIF
1929: NVL(l_ocon_rec.attribute5 ,fnd_api.g_miss_char)

Line 1926: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1922: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1923: x_update_required := 'Y';
1924: ELSIF
1925: NVL(l_ocon_rec.attribute4 ,fnd_api.g_miss_char)
1926: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1927: x_update_required := 'Y';
1928: ELSIF
1929: NVL(l_ocon_rec.attribute5 ,fnd_api.g_miss_char)
1930: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1929: NVL(l_ocon_rec.attribute5 ,fnd_api.g_miss_char)

1925: NVL(l_ocon_rec.attribute4 ,fnd_api.g_miss_char)
1926: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1927: x_update_required := 'Y';
1928: ELSIF
1929: NVL(l_ocon_rec.attribute5 ,fnd_api.g_miss_char)
1930: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1931: x_update_required := 'Y';
1932: ELSIF
1933: NVL(l_ocon_rec.attribute6 ,fnd_api.g_miss_char)

Line 1930: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1926: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1927: x_update_required := 'Y';
1928: ELSIF
1929: NVL(l_ocon_rec.attribute5 ,fnd_api.g_miss_char)
1930: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1931: x_update_required := 'Y';
1932: ELSIF
1933: NVL(l_ocon_rec.attribute6 ,fnd_api.g_miss_char)
1934: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1933: NVL(l_ocon_rec.attribute6 ,fnd_api.g_miss_char)

1929: NVL(l_ocon_rec.attribute5 ,fnd_api.g_miss_char)
1930: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1931: x_update_required := 'Y';
1932: ELSIF
1933: NVL(l_ocon_rec.attribute6 ,fnd_api.g_miss_char)
1934: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1935: x_update_required := 'Y';
1936: ELSIF
1937: NVL(l_ocon_rec.attribute7 ,fnd_api.g_miss_char)

Line 1934: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1930: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1931: x_update_required := 'Y';
1932: ELSIF
1933: NVL(l_ocon_rec.attribute6 ,fnd_api.g_miss_char)
1934: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1935: x_update_required := 'Y';
1936: ELSIF
1937: NVL(l_ocon_rec.attribute7 ,fnd_api.g_miss_char)
1938: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1937: NVL(l_ocon_rec.attribute7 ,fnd_api.g_miss_char)

1933: NVL(l_ocon_rec.attribute6 ,fnd_api.g_miss_char)
1934: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1935: x_update_required := 'Y';
1936: ELSIF
1937: NVL(l_ocon_rec.attribute7 ,fnd_api.g_miss_char)
1938: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1939: x_update_required := 'Y';
1940: ELSIF
1941: NVL(l_ocon_rec.attribute8 ,fnd_api.g_miss_char)

Line 1938: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1934: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1935: x_update_required := 'Y';
1936: ELSIF
1937: NVL(l_ocon_rec.attribute7 ,fnd_api.g_miss_char)
1938: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1939: x_update_required := 'Y';
1940: ELSIF
1941: NVL(l_ocon_rec.attribute8 ,fnd_api.g_miss_char)
1942: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1941: NVL(l_ocon_rec.attribute8 ,fnd_api.g_miss_char)

1937: NVL(l_ocon_rec.attribute7 ,fnd_api.g_miss_char)
1938: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1939: x_update_required := 'Y';
1940: ELSIF
1941: NVL(l_ocon_rec.attribute8 ,fnd_api.g_miss_char)
1942: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1943: x_update_required := 'Y';
1944: ELSIF
1945: NVL(l_ocon_rec.attribute9 ,fnd_api.g_miss_char)

Line 1942: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1938: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1939: x_update_required := 'Y';
1940: ELSIF
1941: NVL(l_ocon_rec.attribute8 ,fnd_api.g_miss_char)
1942: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1943: x_update_required := 'Y';
1944: ELSIF
1945: NVL(l_ocon_rec.attribute9 ,fnd_api.g_miss_char)
1946: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1945: NVL(l_ocon_rec.attribute9 ,fnd_api.g_miss_char)

1941: NVL(l_ocon_rec.attribute8 ,fnd_api.g_miss_char)
1942: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1943: x_update_required := 'Y';
1944: ELSIF
1945: NVL(l_ocon_rec.attribute9 ,fnd_api.g_miss_char)
1946: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1947: x_update_required := 'Y';
1948: ELSIF
1949: NVL(l_ocon_rec.attribute10 ,fnd_api.g_miss_char)

Line 1946: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1942: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1943: x_update_required := 'Y';
1944: ELSIF
1945: NVL(l_ocon_rec.attribute9 ,fnd_api.g_miss_char)
1946: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1947: x_update_required := 'Y';
1948: ELSIF
1949: NVL(l_ocon_rec.attribute10 ,fnd_api.g_miss_char)
1950: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1949: NVL(l_ocon_rec.attribute10 ,fnd_api.g_miss_char)

1945: NVL(l_ocon_rec.attribute9 ,fnd_api.g_miss_char)
1946: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1947: x_update_required := 'Y';
1948: ELSIF
1949: NVL(l_ocon_rec.attribute10 ,fnd_api.g_miss_char)
1950: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1951: x_update_required := 'Y';
1952: ELSIF
1953: NVL(l_ocon_rec.attribute11 ,fnd_api.g_miss_char)

Line 1950: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1946: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1947: x_update_required := 'Y';
1948: ELSIF
1949: NVL(l_ocon_rec.attribute10 ,fnd_api.g_miss_char)
1950: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1951: x_update_required := 'Y';
1952: ELSIF
1953: NVL(l_ocon_rec.attribute11 ,fnd_api.g_miss_char)
1954: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1953: NVL(l_ocon_rec.attribute11 ,fnd_api.g_miss_char)

1949: NVL(l_ocon_rec.attribute10 ,fnd_api.g_miss_char)
1950: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1951: x_update_required := 'Y';
1952: ELSIF
1953: NVL(l_ocon_rec.attribute11 ,fnd_api.g_miss_char)
1954: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1955: x_update_required := 'Y';
1956: ELSIF
1957: NVL(l_ocon_rec.attribute12 ,fnd_api.g_miss_char)

Line 1954: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1950: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1951: x_update_required := 'Y';
1952: ELSIF
1953: NVL(l_ocon_rec.attribute11 ,fnd_api.g_miss_char)
1954: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1955: x_update_required := 'Y';
1956: ELSIF
1957: NVL(l_ocon_rec.attribute12 ,fnd_api.g_miss_char)
1958: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1957: NVL(l_ocon_rec.attribute12 ,fnd_api.g_miss_char)

1953: NVL(l_ocon_rec.attribute11 ,fnd_api.g_miss_char)
1954: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1955: x_update_required := 'Y';
1956: ELSIF
1957: NVL(l_ocon_rec.attribute12 ,fnd_api.g_miss_char)
1958: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1959: x_update_required := 'Y';
1960: ELSIF
1961: NVL(l_ocon_rec.attribute13 ,fnd_api.g_miss_char)

Line 1958: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1954: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1955: x_update_required := 'Y';
1956: ELSIF
1957: NVL(l_ocon_rec.attribute12 ,fnd_api.g_miss_char)
1958: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1959: x_update_required := 'Y';
1960: ELSIF
1961: NVL(l_ocon_rec.attribute13 ,fnd_api.g_miss_char)
1962: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1961: NVL(l_ocon_rec.attribute13 ,fnd_api.g_miss_char)

1957: NVL(l_ocon_rec.attribute12 ,fnd_api.g_miss_char)
1958: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1959: x_update_required := 'Y';
1960: ELSIF
1961: NVL(l_ocon_rec.attribute13 ,fnd_api.g_miss_char)
1962: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1963: x_update_required := 'Y';
1964: ELSIF
1965: NVL(l_ocon_rec.attribute14 ,fnd_api.g_miss_char)

Line 1962: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1958: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1959: x_update_required := 'Y';
1960: ELSIF
1961: NVL(l_ocon_rec.attribute13 ,fnd_api.g_miss_char)
1962: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1963: x_update_required := 'Y';
1964: ELSIF
1965: NVL(l_ocon_rec.attribute14 ,fnd_api.g_miss_char)
1966: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1965: NVL(l_ocon_rec.attribute14 ,fnd_api.g_miss_char)

1961: NVL(l_ocon_rec.attribute13 ,fnd_api.g_miss_char)
1962: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1963: x_update_required := 'Y';
1964: ELSIF
1965: NVL(l_ocon_rec.attribute14 ,fnd_api.g_miss_char)
1966: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1967: x_update_required := 'Y';
1968: ELSIF
1969: NVL(l_ocon_rec.attribute15 ,fnd_api.g_miss_char)

Line 1966: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1962: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1963: x_update_required := 'Y';
1964: ELSIF
1965: NVL(l_ocon_rec.attribute14 ,fnd_api.g_miss_char)
1966: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1967: x_update_required := 'Y';
1968: ELSIF
1969: NVL(l_ocon_rec.attribute15 ,fnd_api.g_miss_char)
1970: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1969: NVL(l_ocon_rec.attribute15 ,fnd_api.g_miss_char)

1965: NVL(l_ocon_rec.attribute14 ,fnd_api.g_miss_char)
1966: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1967: x_update_required := 'Y';
1968: ELSIF
1969: NVL(l_ocon_rec.attribute15 ,fnd_api.g_miss_char)
1970: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1971: x_update_required := 'Y';
1972: ELSIF
1973: NVL(l_ocon_rec.attribute16 ,fnd_api.g_miss_char)

Line 1970: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1966: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1967: x_update_required := 'Y';
1968: ELSIF
1969: NVL(l_ocon_rec.attribute15 ,fnd_api.g_miss_char)
1970: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1971: x_update_required := 'Y';
1972: ELSIF
1973: NVL(l_ocon_rec.attribute16 ,fnd_api.g_miss_char)
1974: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1973: NVL(l_ocon_rec.attribute16 ,fnd_api.g_miss_char)

1969: NVL(l_ocon_rec.attribute15 ,fnd_api.g_miss_char)
1970: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1971: x_update_required := 'Y';
1972: ELSIF
1973: NVL(l_ocon_rec.attribute16 ,fnd_api.g_miss_char)
1974: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1975: x_update_required := 'Y';
1976: ELSIF
1977: NVL(l_ocon_rec.attribute17 ,fnd_api.g_miss_char)

Line 1974: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1970: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1971: x_update_required := 'Y';
1972: ELSIF
1973: NVL(l_ocon_rec.attribute16 ,fnd_api.g_miss_char)
1974: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1975: x_update_required := 'Y';
1976: ELSIF
1977: NVL(l_ocon_rec.attribute17 ,fnd_api.g_miss_char)
1978: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1977: NVL(l_ocon_rec.attribute17 ,fnd_api.g_miss_char)

1973: NVL(l_ocon_rec.attribute16 ,fnd_api.g_miss_char)
1974: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1975: x_update_required := 'Y';
1976: ELSIF
1977: NVL(l_ocon_rec.attribute17 ,fnd_api.g_miss_char)
1978: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1979: x_update_required := 'Y';
1980: ELSIF
1981: NVL(l_ocon_rec.attribute18 ,fnd_api.g_miss_char)

Line 1978: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1974: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1975: x_update_required := 'Y';
1976: ELSIF
1977: NVL(l_ocon_rec.attribute17 ,fnd_api.g_miss_char)
1978: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1979: x_update_required := 'Y';
1980: ELSIF
1981: NVL(l_ocon_rec.attribute18 ,fnd_api.g_miss_char)
1982: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1981: NVL(l_ocon_rec.attribute18 ,fnd_api.g_miss_char)

1977: NVL(l_ocon_rec.attribute17 ,fnd_api.g_miss_char)
1978: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1979: x_update_required := 'Y';
1980: ELSIF
1981: NVL(l_ocon_rec.attribute18 ,fnd_api.g_miss_char)
1982: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1983: x_update_required := 'Y';
1984: ELSIF
1985: NVL(l_ocon_rec.attribute19 ,fnd_api.g_miss_char)

Line 1982: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1978: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1979: x_update_required := 'Y';
1980: ELSIF
1981: NVL(l_ocon_rec.attribute18 ,fnd_api.g_miss_char)
1982: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1983: x_update_required := 'Y';
1984: ELSIF
1985: NVL(l_ocon_rec.attribute19 ,fnd_api.g_miss_char)
1986: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1985: NVL(l_ocon_rec.attribute19 ,fnd_api.g_miss_char)

1981: NVL(l_ocon_rec.attribute18 ,fnd_api.g_miss_char)
1982: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1983: x_update_required := 'Y';
1984: ELSIF
1985: NVL(l_ocon_rec.attribute19 ,fnd_api.g_miss_char)
1986: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1987: x_update_required := 'Y';
1988: ELSIF
1989: NVL(l_ocon_rec.attribute20 ,fnd_api.g_miss_char)

Line 1986: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1982: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1983: x_update_required := 'Y';
1984: ELSIF
1985: NVL(l_ocon_rec.attribute19 ,fnd_api.g_miss_char)
1986: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1987: x_update_required := 'Y';
1988: ELSIF
1989: NVL(l_ocon_rec.attribute20 ,fnd_api.g_miss_char)
1990: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

Line 1989: NVL(l_ocon_rec.attribute20 ,fnd_api.g_miss_char)

1985: NVL(l_ocon_rec.attribute19 ,fnd_api.g_miss_char)
1986: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1987: x_update_required := 'Y';
1988: ELSIF
1989: NVL(l_ocon_rec.attribute20 ,fnd_api.g_miss_char)
1990: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1991: x_update_required := 'Y';
1992: END IF;
1993: END IF;

Line 1990: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN

1986: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1987: x_update_required := 'Y';
1988: ELSIF
1989: NVL(l_ocon_rec.attribute20 ,fnd_api.g_miss_char)
1990: <> NVL(p_ocon_rec.attribute2 ,fnd_api.g_miss_char) THEN
1991: x_update_required := 'Y';
1992: END IF;
1993: END IF;
1994: EXCEPTION