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_CNH_PVT dependencies on FND_APPLICATION

Line 1262: -- Description : Checks id application id exists in fnd_application

1258: ---------------------------------------------------------------------------
1259: -- Start of comments
1260: --
1261: -- Procedure Name : Validate_Application_id
1262: -- Description : Checks id application id exists in fnd_application
1263: -- Business Rules :
1264: -- Parameters :
1265: -- Version : 1.0
1266: -- End of comments

Line 1274: from fnd_application

1270: x_return_status OUT NOCOPY VARCHAR2,
1271: p_cnhv_rec IN cnhv_rec_type) IS
1272: Cursor application_id_cur(p_application_id IN NUMBER) IS
1273: select '1'
1274: from fnd_application
1275: where application_id = p_application_id;
1276: l_dummy VARCHAR2(1) := '?';
1277: BEGIN
1278: -- initialize return status

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

1278: -- initialize return status
1279: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1280:
1281: IF p_cnhv_rec.application_id IS NOT NULL THEN
1282: --Check if application id exists in the fnd_application or not
1283: OPEN application_id_cur(p_cnhv_rec.application_id);
1284: FETCH application_id_cur INTO l_dummy;
1285: CLOSE application_id_cur ;
1286: IF l_dummy = '?' THEN