APPS.BSC_PORTLET_GRAPH dependencies on BSC_SYS_IMAGES

Line 1289: bsc_sys_images bsi

1285:
1286: CURSOR c_kg IS
1287: SELECT bsi.FILE_BODY
1288: FROM bsc_kpi_graphs k,
1289: bsc_sys_images bsi
1290: WHERE
1291: k.RESPONSIBILITY_ID = p_resp_id AND
1292: k.INDICATOR = p_kpi_id AND
1293: k.GRAPH_KEY = p_graph_key AND

Line 1303: -- row exists in bsc_sys_images and bsc_kpi_graphs

1299: FETCH c_kg INTO p_fbody;
1300:
1301: IF c_kg%FOUND THEN
1302: ---------------------------------------------------
1303: -- row exists in bsc_sys_images and bsc_kpi_graphs
1304: ---------------------------------------------------
1305: CLOSE c_kg;
1306: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;
1307: l_errmesg := bsc_portlet_util.MSGTXT_SUCCESS;

Line 1349: -- exists in bsc_sys_images.

1345: -- PURPOSE
1346: -- This fucntion makes sure
1347: -- 1. The record by the given p_resp_id, p_kpi_id, p_graph_key
1348: -- exists in bsc_kpi_graphs and the record with given p_img_id
1349: -- exists in bsc_sys_images.
1350: -- PARAMETERS
1351: --
1352: -- HISTORY
1353: -- 08-MAR-2001 juwang Created.

Line 1374: bsc_sys_images bsi

1370:
1371: CURSOR c_kg IS
1372: SELECT k.IMAGE_ID, k.GRAPH_KEY
1373: FROM bsc_kpi_graphs k,
1374: bsc_sys_images bsi
1375: WHERE
1376: k.RESPONSIBILITY_ID = p_resp_id AND
1377: k.INDICATOR = p_kpi_id AND
1378: k.IMAGE_ID = bsi.IMAGE_ID;

Line 1387: -- row exists in bsc_sys_images and bsc_kpi_graphs

1383: FETCH c_kg INTO p_img_id, l_gkey;
1384:
1385: IF c_kg%FOUND THEN
1386: ---------------------------------------------------
1387: -- row exists in bsc_sys_images and bsc_kpi_graphs
1388: ---------------------------------------------------
1389:
1390: IF l_gkey = p_graph_key THEN
1391: ------------------------------------------------

Line 1420: UPDATE bsc_sys_images

1416: RAISE update_err;
1417: END IF;
1418:
1419:
1420: UPDATE bsc_sys_images
1421: SET
1422: FILE_NAME = p_graph_key,
1423: DESCRIPTION = p_graph_key,
1424: LAST_UPDATE_DATE = SYSDATE,

Line 1438: -- Record does not exist both in bsc_kpi_graphs and bsc_sys_images

1434:
1435:
1436: ELSE
1437: ---------------------------------------------------
1438: -- Record does not exist both in bsc_kpi_graphs and bsc_sys_images
1439: ---------------------------------------------------
1440: /*
1441: SELECT bsc_sys_image_id_s.NEXTVAL
1442: INTO l_sq_img_id

Line 1445: INSERT INTO bsc_sys_images(

1441: SELECT bsc_sys_image_id_s.NEXTVAL
1442: INTO l_sq_img_id
1443: FROM dual;
1444: */
1445: INSERT INTO bsc_sys_images(
1446: IMAGE_ID, FILE_NAME, DESCRIPTION, FILE_BODY, WIDTH, HEIGHT,
1447: CREATION_DATE, CREATED_BY,
1448: LAST_UPDATE_DATE, LAST_UPDATED_BY,
1449: LAST_UPDATE_LOGIN)

Line 1459: l_errmesg := 'Error inserting into bsc_sys_images. FILE_NAME=' ||

1455: p_user_id)
1456: RETURNING IMAGE_ID INTO p_img_id;
1457:
1458: IF SQL%ROWCOUNT = 0 THEN
1459: l_errmesg := 'Error inserting into bsc_sys_images. FILE_NAME=' ||
1460: p_graph_key;
1461: RAISE insert_err;
1462: END IF;
1463: