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_SIMULATION_VIEW_PUB dependencies on BSC_SYS_IMAGES

Line 258: BSC_SYS_IMAGES_PKG.INSERT_ROW

254:
255: x_image_id := l_next_image_id;
256:
257: BEGIN
258: BSC_SYS_IMAGES_PKG.INSERT_ROW
259: (
260: X_IMAGE_ID => l_next_image_id
261: ,X_FILE_NAME => p_file_name
262: ,X_DESCRIPTION => p_description

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

270:
271: EXCEPTION
272: WHEN OTHERS THEN
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
275: RAISE;
276: END;
277:
278: BSC_SYS_IMAGES_MAP_PKG.INSERT_ROW

Line 278: BSC_SYS_IMAGES_MAP_PKG.INSERT_ROW

274: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
275: RAISE;
276: END;
277:
278: BSC_SYS_IMAGES_MAP_PKG.INSERT_ROW
279: (
280: X_ROWID => l_str
281: ,X_SOURCE_TYPE => BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
282: ,X_SOURCE_CODE => p_obj_id

Line 303: We will continue to use the tables BSC_SYS_IMAGES and

299:
300: /*********************************************************
301: Procedure : Add_Or_Update_Tab_View_Bg
302: Description : This proceudres update or add a new canvas image to the simulation tree.
303: We will continue to use the tables BSC_SYS_IMAGES and
304: BSC_SYS_IMAGE_MAPS_TL table for storing the simulation tree background
305: images.
306: Source_Type column in BSC_SYS_IMAGE_MAPS_TL will be set to 2 for indicators
307:

Line 327: l_next_image_id BSC_SYS_IMAGES.image_id%TYPE;

323: ,x_msg_count OUT NOCOPY NUMBER
324: ,x_msg_data OUT NOCOPY VARCHAR2
325: ) IS
326: l_count NUMBER;
327: l_next_image_id BSC_SYS_IMAGES.image_id%TYPE;
328: BEGIN
329: SAVEPOINT AddOrUpdateSimTreeBg;
330: FND_MSG_PUB.INITIALIZE;
331: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 336: FROM bsc_sys_images bsi,

332:
333:
334: SELECT COUNT(0)
335: INTO l_count
336: FROM bsc_sys_images bsi,
337: bsc_sys_images_map_vl bsim
338: WHERE bsim.source_type =BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
339: AND bsim.source_code = p_obj_id
340: AND bsim.type = BSC_SIMULATION_VIEW_PUB.c_TYPE

Line 337: bsc_sys_images_map_vl bsim

333:
334: SELECT COUNT(0)
335: INTO l_count
336: FROM bsc_sys_images bsi,
337: bsc_sys_images_map_vl bsim
338: WHERE bsim.source_type =BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
339: AND bsim.source_code = p_obj_id
340: AND bsim.type = BSC_SIMULATION_VIEW_PUB.c_TYPE
341: AND bsim.image_id = p_image_id

Line 350: FROM bsc_sys_images_map_TL

346: --check if the image is owned by current NLS session
347:
348: SELECT COUNT(0)
349: INTO l_count
350: FROM bsc_sys_images_map_TL
351: WHERE source_type =BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
352: AND source_code = p_obj_id
353: AND type = BSC_SIMULATION_VIEW_PUB.c_TYPE
354: AND image_id = p_image_id

Line 362: UPDATE BSC_SYS_IMAGES

358: --image owned by this NLS session, just simply update the same image
359: x_image_id := p_image_id;
360:
361: BEGIN
362: UPDATE BSC_SYS_IMAGES
363: SET FILE_NAME = p_file_name,
364: DESCRIPTION = p_description,
365: WIDTH = p_width,
366: HEIGHT = p_height,

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

373: EXCEPTION
374: WHEN OTHERS THEN
375: ROLLBACK TO AddOrUpdateSimTreeBg;
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: x_msg_data := 'Update to BSC_SYS_IMAGES failed' || SQLERRM;
378: RETURN;
379: END;
380:
381: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW

Line 381: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW

377: x_msg_data := 'Update to BSC_SYS_IMAGES failed' || SQLERRM;
378: RETURN;
379: END;
380:
381: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW
382: (
383: X_SOURCE_TYPE => BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
384: ,X_SOURCE_CODE => p_obj_id
385: ,X_TYPE => BSC_SIMULATION_VIEW_PUB.c_TYPE

Line 403: BSC_SYS_IMAGES_PKG.INSERT_ROW

399:
400: x_image_id := l_next_image_id;
401:
402: BEGIN
403: BSC_SYS_IMAGES_PKG.INSERT_ROW
404: (
405: X_IMAGE_ID => l_next_image_id
406: ,X_FILE_NAME => p_file_name
407: ,X_DESCRIPTION => p_description

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

416: EXCEPTION
417: WHEN OTHERS THEN
418: ROLLBACK TO AddOrUpdateSimTreeBg;
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
421: RETURN;
422: END;
423:
424: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW

Line 424: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW

420: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
421: RETURN;
422: END;
423:
424: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW
425: (
426: X_SOURCE_TYPE => BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
427: ,X_SOURCE_CODE => p_obj_id
428: ,X_TYPE => BSC_SIMULATION_VIEW_PUB.c_TYPE

Line 1216: --BSC_SYS_IMAGES

1212: FND_MSG_PUB.INITIALIZE;
1213: x_return_status := FND_API.G_RET_STS_SUCCESS;
1214:
1215: --We need to copy the source indicator data from the following tables
1216: --BSC_SYS_IMAGES
1217: --BSC_SYS_IMAGES_MAP_TL
1218: --BSC_KPI_TREE_NODES
1219: --BSC_TAB_VIEW_LABELS_B/TL
1220:

Line 1217: --BSC_SYS_IMAGES_MAP_TL

1213: x_return_status := FND_API.G_RET_STS_SUCCESS;
1214:
1215: --We need to copy the source indicator data from the following tables
1216: --BSC_SYS_IMAGES
1217: --BSC_SYS_IMAGES_MAP_TL
1218: --BSC_KPI_TREE_NODES
1219: --BSC_TAB_VIEW_LABELS_B/TL
1220:
1221: --First validate if both the indicators are valid or not