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

Line 512: -- Description : Checks if application_id exists in fnd_application

508: END validate_seeded_flag;
509:
510: -- Start of comments
511: -- Procedure Name : validate_application_id
512: -- Description : Checks if application_id exists in fnd_application
513: -- Version : 1.0
514: -- End of comments
515:
516: PROCEDURE validate_application_id(

Line 521: from fnd_application

517: x_return_status OUT NOCOPY VARCHAR2,
518: p_oatv_rec IN oatv_rec_type) IS
519: Cursor application_id_cur(p_application_id IN NUMBER) IS
520: select '1'
521: from fnd_application
522: where application_id = p_application_id;
523: l_dummy VARCHAR2(1) := '?';
524: BEGIN
525: -- initialize return status

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

525: -- initialize return status
526: x_return_status := OKC_API.G_RET_STS_SUCCESS;
527:
528: IF p_oatv_rec.application_id IS NOT NULL THEN
529: --Check if application id exists in the fnd_application or not
530: OPEN application_id_cur(p_oatv_rec.application_id);
531: FETCH application_id_cur INTO l_dummy;
532: CLOSE application_id_cur ;
533: IF l_dummy = '?' THEN