DBA Data[Home] [Help]

APPS.BIS_PORTLET_PMREGION dependencies on ICX_PORTLET

Line 5: ICX_PORTLET_CUSTOMIZATIONS -- This will be available for anyone to use

1: package body BIS_PORTLET_PMREGION as
2: /* $Header: BISPPMRB.pls 120.2 2005/11/11 04:45:16 visuri noship $ */
3:
4: /* Customization tables
5: ICX_PORTLET_CUSTOMIZATIONS -- This will be available for anyone to use
6: REFERENCE_PATH NOT NULL VARCHAR2(1000)
7: PLUG_ID NUMBER -- Not use in this portlet
8: APPLICATION_ID NUMBER
9: RESPONSIBILITY_ID NUMBER

Line 338: if icx_portlet.validateSession then

334: --meastmon 09/10/2001 plug_id is not encrypted.
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 := '';

Line 772: -- IF icx_portlet.validateSession THEN

768: -- l_owner_user_id PLS_INTEGER;
769: -- l_session_id NUMBER;
770: BEGIN
771:
772: -- IF icx_portlet.validateSession THEN
773: BEGIN
774: select PLUG_ID
775: into l_plug_id
776: from ICX_PORTLET_CUSTOMIZATIONS

Line 776: from ICX_PORTLET_CUSTOMIZATIONS

772: -- IF icx_portlet.validateSession THEN
773: BEGIN
774: select PLUG_ID
775: into l_plug_id
776: from ICX_PORTLET_CUSTOMIZATIONS
777: where REFERENCE_PATH = p_reference_path;
778: EXCEPTION
779: when no_data_found then
780: l_plug_id := -1;

Line 794: FROM ICX_PORTLET_CUSTOMIZATIONS

790: WHERE PLUG_ID = l_plug_id;
791:
792:
793: DELETE
794: FROM ICX_PORTLET_CUSTOMIZATIONS
795: WHERE REFERENCE_PATH = p_reference_path;
796: END IF;
797: -- END IF; -- icx_portlet.validateSession
798:

Line 797: -- END IF; -- icx_portlet.validateSession

793: DELETE
794: FROM ICX_PORTLET_CUSTOMIZATIONS
795: WHERE REFERENCE_PATH = p_reference_path;
796: END IF;
797: -- END IF; -- icx_portlet.validateSession
798:
799: EXCEPTION
800: WHEN OTHERS THEN
801: htp.p(SQLERRM);

Line 855: if icx_portlet.validateSession then

851: l_tar_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
852:
853: begin
854:
855: if icx_portlet.validateSession then
856: -- mdamle 01/15/2001 - Modified routine to use getLOVSQL for EDW
857:
858: -- (1) Call a function to plug the the ' on both sides of the search string
859: l_search_str := bis_lov_pub.concat_string(p_search_str);

Line 964: end if; -- icx_portlet.validateSession

960: p_sqlcount => l_sqlcount,
961: p_coldata => l_col_object,
962: Z => Z);
963: END IF;
964: end if; -- icx_portlet.validateSession
965:
966: end dim_level_values_query;*/
967:
968: PROCEDURE display(

Line 1373: if icx_portlet.validateSession then

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
1377: --l_sql := REPLACE(p_sql,c_asterisk,c_percent);

Line 1604: if icx_portlet.validateSession then

1600: l_button_tbl BIS_UTILITIES_PVT.HTML_Button_Tbl_Type;
1601:
1602:
1603: begin
1604: if icx_portlet.validateSession then
1605: --meastmon 09/10/2001 plug_id is not encrypted.
1606: --l_plug_id := icx_call.decrypt2(Z);
1607: l_plug_id := Z;
1608:

Line 2217: if icx_portlet.validateSession then

2213: --meastmon 09/10/2001 plug_id is not encrypted.
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 := ' ';

Line 3932: if icx_portlet.validateSession then

3928: --meastmon 09/10/2001 plug_id is not encrypted.
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

Line 4029: UPDATE icx_portlet_customizations

4025:
4026: -- 2418741 owa_util.redirect_url(p_back_url);
4027:
4028: IF (p_reference_path IS NOT NULL) THEN
4029: UPDATE icx_portlet_customizations
4030: SET caching_key = TO_CHAR(NVL(caching_key, 0) + 1)
4031: WHERE reference_path = p_reference_path;
4032: COMMIT;
4033: END IF;

Line 4215: if icx_portlet.validateSession then

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 := '';
4219:

Line 5714: FROM ICX_PORTLET_CUSTOMIZATIONS

5710: l_ref_path VARCHAR2(100);
5711:
5712: CURSOR c_ipc IS
5713: SELECT REFERENCE_PATH
5714: FROM ICX_PORTLET_CUSTOMIZATIONS
5715: WHERE PLUG_ID = p_plug_id;
5716:
5717: BEGIN
5718:

Line 6136: IF icx_portlet.validateSession THEN

6132: ,x_error_Tbl => x_error_Tbl
6133: );
6134:
6135: -- in order to set the last_updated_by correctly
6136: IF icx_portlet.validateSession THEN
6137: NULL;
6138: END IF;
6139:
6140: