APPS.JTF_FM_REQUEST_GRP dependencies on JTF_FM_TEST_REQUESTS

Line 2497: SELECT DISTINCT COUNT(REQUEST_ID) INTO l_req_count FROM JTF_FM_TEST_REQUESTS

2493:
2494: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name,
2495: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
2496:
2497: SELECT DISTINCT COUNT(REQUEST_ID) INTO l_req_count FROM JTF_FM_TEST_REQUESTS
2498: WHERE REQUEST_ID = p_request_id ;
2499:
2500: BEGIN
2501:

Line 2563: SELECT DISTINCT COUNT(REQUEST_ID) INTO l_req_count FROM JTF_FM_TEST_REQUESTS

2559: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
2560:
2561: JTF_FM_UTL_V.PRINT_MESSAGE(' THE REQUEST_ID IS ' || p_request_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_ATTACH_FILE_ID');
2562:
2563: SELECT DISTINCT COUNT(REQUEST_ID) INTO l_req_count FROM JTF_FM_TEST_REQUESTS
2564: WHERE REQUEST_ID = p_request_id ;
2565: BEGIN
2566: IF l_req_count > 0
2567: THEN

Line 2733: SELECT DISTINCT COUNT(REQUEST_ID) INTO l_req_count FROM JTF_FM_TEST_REQUESTS

2729: -- Initialize API return status to success
2730: x_return_status := FND_API.G_RET_STS_SUCCESS;
2731:
2732:
2733: SELECT DISTINCT COUNT(REQUEST_ID) INTO l_req_count FROM JTF_FM_TEST_REQUESTS
2734: WHERE REQUEST_ID = p_request_id ;
2735:
2736: BEGIN
2737: IF l_req_count > 0 THEN

Line 3054: DELETE FROM JTF_FM_TEST_REQUESTS WHERE REQUEST_ID = p_request_id;

3050: END IF;
3051:
3052: end if;
3053:
3054: DELETE FROM JTF_FM_TEST_REQUESTS WHERE REQUEST_ID = p_request_id;
3055:
3056: JTF_FM_UTL_V.PRINT_MESSAGE('End GET_OCM_ITEM_DETAILS',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3057:
3058: