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.BSC_PMF_UI_WRAPPER dependencies on BSC_SYS_IMAGES

Line 6259: l_next_image_id BSC_SYS_IMAGES.image_id%TYPE;

6255: ,x_msg_count OUT NOCOPY NUMBER
6256: ,x_msg_data OUT NOCOPY VARCHAR2
6257: ) IS
6258: l_count NUMBER;
6259: l_next_image_id BSC_SYS_IMAGES.image_id%TYPE;
6260: BEGIN
6261: SAVEPOINT AddOrUpdateTabLogo;
6262: FND_MSG_PUB.INITIALIZE;
6263: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6268: FROM bsc_sys_images bsi,

6264:
6265:
6266: SELECT COUNT(0)
6267: INTO l_count
6268: FROM bsc_sys_images bsi,
6269: bsc_sys_images_map_vl bsim
6270: WHERE bsim.source_type =BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6271: AND bsim.source_code = p_tab_id
6272: AND bsim.type = BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE

Line 6269: bsc_sys_images_map_vl bsim

6265:
6266: SELECT COUNT(0)
6267: INTO l_count
6268: FROM bsc_sys_images bsi,
6269: bsc_sys_images_map_vl bsim
6270: WHERE bsim.source_type =BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6271: AND bsim.source_code = p_tab_id
6272: AND bsim.type = BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6273: AND bsim.image_id = p_image_id

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 6294: UPDATE BSC_SYS_IMAGES

6290: --image owned by this NLS session, just simply update the same image
6291: x_image_id := p_image_id;
6292:
6293: BEGIN
6294: UPDATE BSC_SYS_IMAGES
6295: SET FILE_NAME = p_file_name,
6296: DESCRIPTION = p_description,
6297: WIDTH = p_width,
6298: HEIGHT = p_height,

Line 6309: x_msg_data := 'Update to BSC_SYS_IMAGES failed' || SQLERRM;

6305: EXCEPTION
6306: WHEN OTHERS THEN
6307: ROLLBACK TO AddOrUpdateTabLogo;
6308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6309: x_msg_data := 'Update to BSC_SYS_IMAGES failed' || SQLERRM;
6310: RETURN;
6311: END;
6312:
6313: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW

Line 6313: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW

6309: x_msg_data := 'Update to BSC_SYS_IMAGES failed' || SQLERRM;
6310: RETURN;
6311: END;
6312:
6313: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW
6314: (
6315: X_SOURCE_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6316: ,X_SOURCE_CODE => p_tab_id
6317: ,X_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE

Line 6335: BSC_SYS_IMAGES_PKG.INSERT_ROW

6331:
6332: x_image_id := l_next_image_id;
6333:
6334: BEGIN
6335: BSC_SYS_IMAGES_PKG.INSERT_ROW
6336: (
6337: X_IMAGE_ID => l_next_image_id
6338: ,X_FILE_NAME => p_file_name
6339: ,X_DESCRIPTION => p_description

Line 6352: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;

6348: EXCEPTION
6349: WHEN OTHERS THEN
6350: ROLLBACK TO AddOrUpdateTabLogo;
6351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6352: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
6353: RETURN;
6354: END;
6355:
6356: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW

Line 6356: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW

6352: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
6353: RETURN;
6354: END;
6355:
6356: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW
6357: (
6358: X_SOURCE_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6359: ,X_SOURCE_CODE => p_tab_id
6360: ,X_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE

Line 6423: BSC_SYS_IMAGES_PKG.INSERT_ROW

6419:
6420: x_image_id := l_next_image_id;
6421:
6422: BEGIN
6423: BSC_SYS_IMAGES_PKG.INSERT_ROW
6424: (
6425: X_IMAGE_ID => l_next_image_id
6426: ,X_FILE_NAME => p_file_name
6427: ,X_DESCRIPTION => p_description

Line 6439: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;

6435:
6436: EXCEPTION
6437: WHEN OTHERS THEN
6438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6439: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
6440: RAISE;
6441: END;
6442:
6443: BSC_SYS_IMAGES_MAP_PKG.INSERT_ROW

Line 6443: BSC_SYS_IMAGES_MAP_PKG.INSERT_ROW

6439: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
6440: RAISE;
6441: END;
6442:
6443: BSC_SYS_IMAGES_MAP_PKG.INSERT_ROW
6444: (
6445: X_ROWID => l_str
6446: ,X_SOURCE_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6447: ,X_SOURCE_CODE => p_obj_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;

Line 6495: DELETE FROM bsc_sys_images

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;
6497: END IF;
6498:
6499: EXCEPTION