DBA Data[Home] [Help]

APPS.BSC_PORTLET_GRAPH dependencies on ICX_SEC

Line 71: IF icx_sec.validatePlugSession(p_plug_id,p_session_id) THEN

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

Line 73: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',p_session_id);

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

Line 169: END IF; -- icx_sec.validatePlugSession

165:
166:
167:
168: END IF; -- p_delete = 'Y'
169: END IF; -- icx_sec.validatePlugSession
170:
171: EXCEPTION
172: WHEN OTHERS THEN
173: ROLLBACK;

Line 514: IF icx_sec.validatePlugSession(p_plug_id,p_session_id) THEN

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:

Line 520: END IF; -- icx_sec.validatePlugSession

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('' || '');
520: END IF; -- icx_sec.validatePlugSession
521:
522: EXCEPTION
523:
524: WHEN OTHERS THEN

Line 912: IF icx_sec.validatePlugSession(p_plug_id,p_session_id) THEN

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

Line 914: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',p_session_id);

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;

Line 932: END IF; -- icx_sec.validatePlugSession(p_plug_id,p_session_id)

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:

Line 1112: IF icx_sec.validatePlugSession(l_plug_id, l_session_id) THEN

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;

Line 1113: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',l_session_id);

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:

Line 1155: END IF; -- icx_sec.validatePlugSession(l_plug_id, l_session_id)

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:

Line 1205: IF icx_sec.validatePlugSession(l_plug_id, l_session_id) THEN

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,

Line 1207: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_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:

Line 1219: END IF; -- icx_sec.validatePlugSession

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: