APPS.BSC_PORTLET_GRAPH dependencies on BSC_KPI_GRAPHS

Line 1288: FROM bsc_kpi_graphs k,

1284:
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

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 1348: -- exists in bsc_kpi_graphs and the record with given p_img_id

1344: --
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

Line 1373: FROM bsc_kpi_graphs k,

1369: l_h NUMBER := 250;
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

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 1404: UPDATE bsc_kpi_graphs

1400:
1401: ------------------------------------------------
1402: -- graph key is different, need to update record
1403: ------------------------------------------------
1404: UPDATE bsc_kpi_graphs
1405: SET
1406: GRAPH_KEY = p_graph_key,
1407: LAST_UPDATE_DATE = SYSDATE,
1408: LAST_UPDATED_BY = p_user_id

Line 1415: l_errmesg := 'Error updating bsc_kpi_graphs. RESPONSIBILITY_ID=' || p_resp_id || ', INDICATOR=' || p_kpi_id ;

1411: INDICATOR = p_kpi_id;
1412:
1413:
1414: IF SQL%ROWCOUNT = 0 THEN
1415: l_errmesg := 'Error updating bsc_kpi_graphs. RESPONSIBILITY_ID=' || p_resp_id || ', INDICATOR=' || p_kpi_id ;
1416: RAISE update_err;
1417: END IF;
1418:
1419:

Line 1431: l_errmesg := 'Error updating bsc_kpi_graphs. RESPONSIBILITY_ID=' || p_resp_id || ', INDICATOR=' || p_kpi_id ;

1427: IMAGE_ID = p_img_id;
1428:
1429:
1430: IF SQL%ROWCOUNT = 0 THEN
1431: l_errmesg := 'Error updating bsc_kpi_graphs. RESPONSIBILITY_ID=' || p_resp_id || ', INDICATOR=' || p_kpi_id ;
1432: RAISE update_err;
1433: END IF;
1434:
1435:

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 1465: INSERT INTO bsc_kpi_graphs(

1461: RAISE insert_err;
1462: END IF;
1463:
1464:
1465: INSERT INTO bsc_kpi_graphs(
1466: RESPONSIBILITY_ID, INDICATOR, GRAPH_KEY, IMAGE_ID,
1467: CREATION_DATE, CREATED_BY,
1468: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
1469: VALUES(

Line 1475: l_errmesg := 'Error inserting into bsc_kpi_graphs. RESPONSIBILITY_ID='|| p_resp_id || ', INDICATOR=' || p_kpi_id || ', GRAPH_KEY=' ||

1471: SYSDATE, p_user_id,
1472: SYSDATE, p_user_id, p_user_id);
1473:
1474: IF SQL%ROWCOUNT = 0 THEN
1475: l_errmesg := 'Error inserting into bsc_kpi_graphs. RESPONSIBILITY_ID='|| p_resp_id || ', INDICATOR=' || p_kpi_id || ', GRAPH_KEY=' ||
1476: p_graph_key || ', IMAGE_ID' || p_img_id;
1477: RAISE insert_err;
1478: END IF;
1479: