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.OKC_CNL_PVT dependencies on FND_APPLICATION

Line 1668: -- Description : Checks if application id exists in fnd_application

1664: ---------------------------------------------------------------------------
1665: -- Start of comments
1666: --
1667: -- Procedure Name : Validate_Application_id
1668: -- Description : Checks if application id exists in fnd_application
1669: -- Business Rules :
1670: -- Parameters :
1671: -- Version : 1.0
1672: -- End of comments

Line 1680: from fnd_application

1676: x_return_status OUT NOCOPY VARCHAR2,
1677: p_cnlv_rec IN cnlv_rec_type) IS
1678: Cursor application_id_cur(p_application_id IN NUMBER) IS
1679: select '1'
1680: from fnd_application
1681: where application_id = p_application_id;
1682: l_dummy VARCHAR2(1) := '?';
1683: BEGIN
1684: -- initialize return status

Line 1688: --Check if application id exists in the fnd_application or not

1684: -- initialize return status
1685: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1686:
1687: IF p_cnlv_rec.application_id IS NOT NULL THEN
1688: --Check if application id exists in the fnd_application or not
1689: OPEN application_id_cur(p_cnlv_rec.application_id);
1690: FETCH application_id_cur INTO l_dummy;
1691: CLOSE application_id_cur ;
1692: IF l_dummy = '?' THEN