APPS.JTF_FM_REQUEST_GRP dependencies on IBC_CITEMS_V

Line 2505: SELECT ATTACH_FID INTO file_id FROM ibc_citems_v

2501:
2502: -- If this is a test request...
2503: IF l_req_count > 0 THEN
2504:
2505: SELECT ATTACH_FID INTO file_id FROM ibc_citems_v
2506: WHERE CITEM_ID = p_content_id
2507: and LANGUAGE = USERENV('LANG')
2508: and rownum=1;
2509:

Line 2513: SELECT ATTACH_FID INTO file_id FROM ibc_citems_v

2509:
2510: ELSE
2511:
2512: -- First get the approved CITEM_VER_ID for the given content ID.
2513: SELECT ATTACH_FID INTO file_id FROM ibc_citems_v
2514: WHERE CITEM_ID = p_content_id
2515: and item_status = 'APPROVED'
2516: and LANGUAGE = USERENV('LANG')
2517: and rownum=1;

Line 2570: SELECT CITEM_VER_ID INTO l_cItemVersionId FROM IBC_CITEMS_V

2566: IF l_req_count > 0
2567: THEN
2568: JTF_FM_UTL_V.PRINT_MESSAGE(' THE COUNT IS ' || l_req_count, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_ATTACH_FILE_ID');
2569:
2570: SELECT CITEM_VER_ID INTO l_cItemVersionId FROM IBC_CITEMS_V
2571: WHERE CITEM_ID = TO_NUMBER(p_content_id)
2572: and LANGUAGE = USERENV('LANG');
2573:
2574:

Line 2577: SELECT CITEM_VER_ID INTO l_cItemVersionId FROM IBC_CITEMS_V

2573:
2574:
2575: ELSE
2576:
2577: SELECT CITEM_VER_ID INTO l_cItemVersionId FROM IBC_CITEMS_V
2578: WHERE CITEM_ID = TO_NUMBER(p_content_id) and item_status = 'APPROVED'
2579: and LANGUAGE = USERENV('LANG');
2580:
2581: END IF;

Line 2776: FROM IBC_CITEMS_V

2772: -- The following gets the max version regardless of any status;
2773: -- item_status or version_status
2774:
2775: SELECT MAX(CITEM_VER_ID) INTO x_item_version_id
2776: FROM IBC_CITEMS_V
2777: WHERE CITEM_ID = TO_NUMBER(p_content_id)
2778: AND LANGUAGE = USERENV('LANG') ;
2779:
2780: END IF;