1218: END IF;
1219:
1220:
1221: -- added for Bug 7538658 start
1222: IF (FND_RELEASE.MAJOR_VERSION = 12 AND FND_RELEASE.minor_version >= 1 AND FND_RELEASE.POINT_VERSION >= 1 )
1223: OR (FND_RELEASE.MAJOR_VERSION > 12) THEN
1224:
1225: OPEN get_user_id_csr;
1226: FETCH get_user_id_csr INTO l_user_id;
1219:
1220:
1221: -- added for Bug 7538658 start
1222: IF (FND_RELEASE.MAJOR_VERSION = 12 AND FND_RELEASE.minor_version >= 1 AND FND_RELEASE.POINT_VERSION >= 1 )
1223: OR (FND_RELEASE.MAJOR_VERSION > 12) THEN
1224:
1225: OPEN get_user_id_csr;
1226: FETCH get_user_id_csr INTO l_user_id;
1227: CLOSE get_user_id_csr;
1417: x_noti_rec => l_noti_rec);
1418:
1419:
1420: -- added for Bug 7538658 start
1421: IF (FND_RELEASE.MAJOR_VERSION = 12 AND FND_RELEASE.minor_version >= 1 AND FND_RELEASE.POINT_VERSION >= 1 )
1422: OR (FND_RELEASE.MAJOR_VERSION > 12) THEN
1423:
1424: OPEN get_user_id_csr ;
1425: FETCH get_user_id_csr INTO l_user_id;
1418:
1419:
1420: -- added for Bug 7538658 start
1421: IF (FND_RELEASE.MAJOR_VERSION = 12 AND FND_RELEASE.minor_version >= 1 AND FND_RELEASE.POINT_VERSION >= 1 )
1422: OR (FND_RELEASE.MAJOR_VERSION > 12) THEN
1423:
1424: OPEN get_user_id_csr ;
1425: FETCH get_user_id_csr INTO l_user_id;
1426: CLOSE get_user_id_csr ;
1630: p_itemkey => l_item_key,
1631: x_noti_rec => l_noti_rec);
1632:
1633: -- added for Bug 7538658 start
1634: IF (FND_RELEASE.MAJOR_VERSION = 12 AND FND_RELEASE.minor_version >= 1 AND FND_RELEASE.POINT_VERSION >= 1 )
1635: OR (FND_RELEASE.MAJOR_VERSION > 12) THEN
1636:
1637: OPEN get_user_id_csr;
1638: FETCH get_user_id_csr INTO l_user_id;
1631: x_noti_rec => l_noti_rec);
1632:
1633: -- added for Bug 7538658 start
1634: IF (FND_RELEASE.MAJOR_VERSION = 12 AND FND_RELEASE.minor_version >= 1 AND FND_RELEASE.POINT_VERSION >= 1 )
1635: OR (FND_RELEASE.MAJOR_VERSION > 12) THEN
1636:
1637: OPEN get_user_id_csr;
1638: FETCH get_user_id_csr INTO l_user_id;
1639: CLOSE get_user_id_csr;
1844: x_noti_rec => l_noti_rec);
1845:
1846:
1847: -- added for Bug 7538658 start
1848: IF (FND_RELEASE.MAJOR_VERSION = 12 AND FND_RELEASE.minor_version >= 1 AND FND_RELEASE.POINT_VERSION >= 1 )
1849: OR (FND_RELEASE.MAJOR_VERSION > 12) THEN
1850:
1851: OPEN get_user_id_csr;
1852: FETCH get_user_id_csr INTO l_user_id;
1845:
1846:
1847: -- added for Bug 7538658 start
1848: IF (FND_RELEASE.MAJOR_VERSION = 12 AND FND_RELEASE.minor_version >= 1 AND FND_RELEASE.POINT_VERSION >= 1 )
1849: OR (FND_RELEASE.MAJOR_VERSION > 12) THEN
1850:
1851: OPEN get_user_id_csr;
1852: FETCH get_user_id_csr INTO l_user_id;
1853: CLOSE get_user_id_csr;
2030: x_noti_rec => l_noti_rec);
2031:
2032:
2033: -- added for Bug 7538658 start
2034: IF (FND_RELEASE.MAJOR_VERSION = 12 AND FND_RELEASE.minor_version >= 1 AND FND_RELEASE.POINT_VERSION >= 1 )
2035: OR (FND_RELEASE.MAJOR_VERSION > 12) THEN
2036:
2037: OPEN get_user_id_csr;
2038: FETCH get_user_id_csr INTO l_user_id;
2031:
2032:
2033: -- added for Bug 7538658 start
2034: IF (FND_RELEASE.MAJOR_VERSION = 12 AND FND_RELEASE.minor_version >= 1 AND FND_RELEASE.POINT_VERSION >= 1 )
2035: OR (FND_RELEASE.MAJOR_VERSION > 12) THEN
2036:
2037: OPEN get_user_id_csr;
2038: FETCH get_user_id_csr INTO l_user_id;
2039: CLOSE get_user_id_csr;