APPS.BIS_PORTLET_PMREGION dependencies on BIS_USER_IND_SELECTIONS

Line 14: BIS_USER_IND_SELECTIONS

10: SECURITY_GROUP_ID NUMBER
11: CACHING_KEY VARCHAR2(550)
12: TITLE VARCHAR2(1000)
13:
14: BIS_USER_IND_SELECTIONS
15: */
16: --===========================================================
17: -- 12-DEC-01 juwang modified for showing pre-seeded portlet
18: --===========================================================

Line 789: FROM BIS_USER_IND_SELECTIONS

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;
791:
792:
793: DELETE

Line 1067: FROM bis_user_ind_selections a

1063: ,a.plan_id
1064: ,c.increase_in_measure --1850860
1065: ,c.comparison_source --2157402
1066: ,c.indicator_id --2174470
1067: FROM bis_user_ind_selections a
1068: ,bis_indicators c --1850860
1069: ,bisbv_target_levels d --1850860
1070: WHERE a.plug_id = p_plug_id -- most selective first
1071: AND a.user_id = l_user_id

Line 1655: -- bis_user_ind_selections table.

1651: );
1652:
1653:
1654: -- Get all the previously selected Indicator levels from
1655: -- bis_user_ind_selections table.
1656: BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
1657: ( p_api_version => 1.0
1658: , p_user_id => l_user_id
1659: , p_all_info => FND_API.G_TRUE

Line 2897: -- display labels and dimlvl valss into the BIS_USER_IND_SELECTIONS table

2893:
2894: -- ***************
2895: htp.p('');
2896: -- Dummy form to send selected labels to a procedure that inserts the
2897: -- display labels and dimlvl valss into the BIS_USER_IND_SELECTIONS table
2898:
2899: htp.formOpen('bis_portlet_pmregion.strDimensions'
2900: ,'POST','','','NAME="strDimensions"');
2901: htp.formHidden('W');

Line 5987: -- 2. save the parsed parameters into bis_user_ind_selections

5983: --
5984: -- PURPOSE
5985: -- Tasks include
5986: -- 1. parse p_parameters
5987: -- 2. save the parsed parameters into bis_user_ind_selections
5988: -- PARAMETERS
5989: --
5990: -- HISTORY
5991: -- 11-DEC-2001 juwang Created.

Line 6084: -- 3. save the parsed parameters into bis_user_ind_selections

6080: -- PURPOSE
6081: -- Tasks include
6082: -- 1. See if this portlet is pre-seeded
6083: -- 2. If it is pre-seeded portlet, parse p_parameters
6084: -- 3. save the parsed parameters into bis_user_ind_selections
6085: -- PARAMETERS
6086: --
6087: -- HISTORY
6088: -- 11-DEC-2001 juwang Created.

Line 6204: bis_user_ind_selections bu

6200: , bu.DIMENSION7_LEVEL_VALUE
6201: , bp.SHORT_NAME
6202: , bu.LABEL
6203: FROM
6204: bis_user_ind_selections bu
6205: , bis_target_levels bt
6206: , BISBV_BUSINESS_PLANS bp
6207: WHERE
6208: bu.IND_SELECTION_ID = p_ind_sel