335: --l_plug_id := icx_call.decrypt2(Z);
336: l_plug_id := Z;
337:
338: if icx_portlet.validateSession then
339: --if ICX_SEC.validatePlugSession(l_plug_id) then
340: if instr(owa_util.get_cgi_env('HTTP_USER_AGENT'),'MSIE') > 0
341: then
342: l_history := '';
343: else
781: END;
782:
783: IF l_plug_id > 0 THEN
784:
785: -- l_session_id := icx_sec.g_session_id;
786: -- l_current_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
787: delete_all_demo_rows(l_plug_id);
788: DELETE
789: FROM BIS_USER_IND_SELECTIONS
782:
783: IF l_plug_id > 0 THEN
784:
785: -- l_session_id := icx_sec.g_session_id;
786: -- l_current_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
787: delete_all_demo_rows(l_plug_id);
788: DELETE
789: FROM BIS_USER_IND_SELECTIONS
790: WHERE PLUG_ID = l_plug_id;
1368: --meastmon 09/10/2001 plug_id is not encrypted.
1369: --l_plug_id := icx_call.decrypt2(Z);
1370: l_plug_id := Z;
1371:
1372: --if ICX_SEC.validatePlugSession(l_plug_id) then
1373: if icx_portlet.validateSession then
1374:
1375: -- prepare SQl modified for enh#3559231
1376: -- Replace the asterisk with the percent sign
1605: --meastmon 09/10/2001 plug_id is not encrypted.
1606: --l_plug_id := icx_call.decrypt2(Z);
1607: l_plug_id := Z;
1608:
1609: l_session_id := icx_sec.g_session_id;
1610: l_current_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
1611: l_nbsp := '&'||'nbsp;';
1612: l_initialize := ' ';
1613:
1606: --l_plug_id := icx_call.decrypt2(Z);
1607: l_plug_id := Z;
1608:
1609: l_session_id := icx_sec.g_session_id;
1610: l_current_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
1611: l_nbsp := '&'||'nbsp;';
1612: l_initialize := ' ';
1613:
1614: if instr(owa_util.get_cgi_env('HTTP_USER_AGENT'),'MSIE') > 0 then
2214: --l_plug_id := icx_call.decrypt2(Z);
2215: l_plug_id := Z;
2216:
2217: if icx_portlet.validateSession then
2218: l_session_id := icx_sec.g_session_id;
2219: l_current_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
2220:
2221: l_initialize := ' ';
2222: l_blank := '';
2215: l_plug_id := Z;
2216:
2217: if icx_portlet.validateSession then
2218: l_session_id := icx_sec.g_session_id;
2219: l_current_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
2220:
2221: l_initialize := ' ';
2222: l_blank := '';
2223:
3929: --l_plug_id := icx_call.decrypt2(Z);
3930: l_plug_id := Z;
3931:
3932: if icx_portlet.validateSession then
3933: l_session_id := icx_sec.g_session_id;
3934: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
3935:
3936: -- Deleting the old rows of this userid and plugid from the selections table
3937: BIS_INDICATOR_REGION_PUB.Delete_User_Ind_Selections(
3930: l_plug_id := Z;
3931:
3932: if icx_portlet.validateSession then
3933: l_session_id := icx_sec.g_session_id;
3934: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
3935:
3936: -- Deleting the old rows of this userid and plugid from the selections table
3937: BIS_INDICATOR_REGION_PUB.Delete_User_Ind_Selections(
3938: p_api_version => 1.0,
4210: --meastmon 09/10/2001 plug_id is not encrypted.
4211: --l_plug_id := icx_call.decrypt2(Z);
4212: l_plug_id := Z;
4213:
4214: --if ICX_SEC.validatePlugSession(l_plug_id) then
4215: if icx_portlet.validateSession then
4216: l_session_id := icx_sec.g_session_id;
4217: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
4218: l_blank := '';
4212: l_plug_id := Z;
4213:
4214: --if ICX_SEC.validatePlugSession(l_plug_id) then
4215: if icx_portlet.validateSession then
4216: l_session_id := icx_sec.g_session_id;
4217: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
4218: l_blank := '';
4219:
4220:
4213:
4214: --if ICX_SEC.validatePlugSession(l_plug_id) then
4215: if icx_portlet.validateSession then
4216: l_session_id := icx_sec.g_session_id;
4217: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
4218: l_blank := '';
4219:
4220:
4221: -- Replace the plus signs from the string
7556: l_html_clob CLOB := NULL;
7557:
7558:
7559: BEGIN
7560: l_session_id := icx_sec.g_session_id;
7561: l_login_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
7562:
7563: IF ( BIS_PMF_PORTLET_UTIL.has_demo_rows(p_plug_id) ) THEN
7564:
7557:
7558:
7559: BEGIN
7560: l_session_id := icx_sec.g_session_id;
7561: l_login_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
7562:
7563: IF ( BIS_PMF_PORTLET_UTIL.has_demo_rows(p_plug_id) ) THEN
7564:
7565: display_demo_portlet(