67: AND k.INDICATOR = bt.INDICATOR;
68:
69: BEGIN
70:
71: IF icx_sec.validatePlugSession(p_plug_id,p_session_id) THEN
72:
73: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',p_session_id);
74:
75: IF p_delete = 'Y' THEN
69: BEGIN
70:
71: IF icx_sec.validatePlugSession(p_plug_id,p_session_id) THEN
72:
73: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',p_session_id);
74:
75: IF p_delete = 'Y' THEN
76: --------------------------------------------
77: -- should clean up bsc_user_kpigraph_plugs
165:
166:
167:
168: END IF; -- p_delete = 'Y'
169: END IF; -- icx_sec.validatePlugSession
170:
171: EXCEPTION
172: WHEN OTHERS THEN
173: ROLLBACK;
510:
511: BEGIN
512:
513:
514: IF icx_sec.validatePlugSession(p_plug_id,p_session_id) THEN
515:
516: l_kpi_url:= bsc_portlet_util.get_bsc_url(p_session_id,
517: p_plug_id, 'BscInit.jsp', NULL, FALSE);
518:
516: l_kpi_url:= bsc_portlet_util.get_bsc_url(p_session_id,
517: p_plug_id, 'BscInit.jsp', NULL, FALSE);
518:
519: htp.p('
908: AND k.INDICATOR = bt.INDICATOR;
909:
910: BEGIN
911:
912: IF icx_sec.validatePlugSession(p_plug_id,p_session_id) THEN
913:
914: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',p_session_id);
915: --------------------------------------------
916: -- find the record in BSC_USER_KPIGRAPH_PLUGS
910: BEGIN
911:
912: IF icx_sec.validatePlugSession(p_plug_id,p_session_id) THEN
913:
914: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',p_session_id);
915: --------------------------------------------
916: -- find the record in BSC_USER_KPIGRAPH_PLUGS
917: --------------------------------------------
918: OPEN c_kg_p;
928:
929: END IF; --c_kg_p%FOUND
930:
931:
932: END IF; -- icx_sec.validatePlugSession(p_plug_id,p_session_id)
933:
934: END get_customized_data_private;
935:
936:
1108: bsc_portlet_util.decrypt_plug_info(p_cookie_value,
1109: p_encrypted_plug_id, l_session_id, l_plug_id);
1110:
1111: p_has_access := 0;
1112: IF icx_sec.validatePlugSession(l_plug_id, l_session_id) THEN
1113: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',l_session_id);
1114:
1115: OPEN c_kg_p;
1116: FETCH c_kg_p INTO p_resp_id, p_kpi_id, p_display_name;
1109: p_encrypted_plug_id, l_session_id, l_plug_id);
1110:
1111: p_has_access := 0;
1112: IF icx_sec.validatePlugSession(l_plug_id, l_session_id) THEN
1113: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',l_session_id);
1114:
1115: OPEN c_kg_p;
1116: FETCH c_kg_p INTO p_resp_id, p_kpi_id, p_display_name;
1117:
1151: END IF; -- c_kg_p%FOUND
1152:
1153: ELSE -- session expires
1154: RETURN bsc_portlet_util.CODE_RET_SESSION_EXP;
1155: END IF; -- icx_sec.validatePlugSession(l_plug_id, l_session_id)
1156:
1157: END get_customization;
1158:
1159:
1201: bsc_portlet_util.decrypt_plug_info(p_cookie_value,
1202: p_encrypted_plug_id, l_session_id, l_plug_id);
1203:
1204:
1205: IF icx_sec.validatePlugSession(l_plug_id, l_session_id) THEN
1206:
1207: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
1208: l_errmsg := bsc_portlet_graph.set_customized_data_private(l_user_id,
1209: l_plug_id, p_resp_id, p_kpi_id,
1203:
1204:
1205: IF icx_sec.validatePlugSession(l_plug_id, l_session_id) THEN
1206:
1207: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
1208: l_errmsg := bsc_portlet_graph.set_customized_data_private(l_user_id,
1209: l_plug_id, p_resp_id, p_kpi_id,
1210: l_user_id, l_user_id, p_portlet_name, p_o_ret_status);
1211:
1215:
1216: RAISE session_expire_err;
1217:
1218:
1219: END IF; -- icx_sec.validatePlugSession
1220:
1221: -- icx_plug_utilities.gotoMainMenu;
1222: -- htp.p(l_errmsg);
1223: