DBA Data[Home] [Help]

APPS.BSC_PMF_UI_WRAPPER dependencies on BSC_SYS_IMAGES_MAP_TL

Line 6282: FROM bsc_sys_images_map_TL

6278: --check if the image is owned by current NLS session
6279:
6280: SELECT COUNT(0)
6281: INTO l_count
6282: FROM bsc_sys_images_map_TL
6283: WHERE source_type =BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6284: AND source_code = p_tab_id
6285: AND type = BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6286: AND image_id = p_image_id

Line 6477: FROM bsc_sys_images_map_tl

6473: ,x_msg_data OUT NOCOPY VARCHAR2
6474: )IS
6475: CURSOR c_tab_logo IS
6476: SELECT image_id
6477: FROM bsc_sys_images_map_tl
6478: WHERE source_type = BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6479: AND source_code = p_tab_id;
6480:
6481: l_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;

Line 6481: l_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;

6477: FROM bsc_sys_images_map_tl
6478: WHERE source_type = BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6479: AND source_code = p_tab_id;
6480:
6481: l_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
6482:
6483: BEGIN
6484: SAVEPOINT DeleteTabLogo;
6485: FND_MSG_PUB.INITIALIZE;

Line 6492: DELETE FROM bsc_sys_images_map_tl

6488: IF(p_tab_id IS NOT NULL) THEN
6489: FOR cd IN c_tab_logo LOOP
6490: l_image_id := cd.image_id;
6491: END LOOP;
6492: DELETE FROM bsc_sys_images_map_tl
6493: WHERE image_id =l_image_id;
6494:
6495: DELETE FROM bsc_sys_images
6496: WHERE image_id =l_image_id;