eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_PORTLET_PMREGION dependencies on BIS_PORTLET_PMREGION

Line 1: package body BIS_PORTLET_PMREGION as

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

Line 195: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_PORTLET_PMREGION';

191:
192: --===========================================================
193: -- end of private functions/procedures declarations.
194: --============================================================
195: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_PORTLET_PMREGION';
196: c_NULL CONSTANT pls_integer := -9999;
197: c_key_menu CONSTANT VARCHAR2(30):= 'pMeasureDefinition=';
198: c_key_target_level CONSTANT VARCHAR2(50):= 'pTargetLevelShortName';
199: c_key_plan CONSTANT VARCHAR2(50):= 'pPlanShortName';

Line 452: ||'BIS_PORTLET_PMREGION.lov_data?p_startnum='||

448: -- Replace the % sign in the sql string with an asterisk
449: -- because it tends to dissappear from the URL string
450: --l_sql := REPLACE(p_sql,c_percent,c_asterisk);
451: l_datalink := owa_util.get_owa_service_path
452: ||'BIS_PORTLET_PMREGION.lov_data?p_startnum='||
453: p_startnum||c_amp||
454: 'p_rowcount='||p_rowcount||c_amp||
455: 'p_totalavailable='||l_totalcount||c_amp||
456: --'p_sql='||REPLACE(l_sql,' ',c_plus)||

Line 862: l_procname := 'bis_portlet_pmregion.dim_level_values_query';

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);
860:
861: -- (2)Set the procedure name
862: l_procname := 'bis_portlet_pmregion.dim_level_values_query';
863:
864: -- (3)Build two SQL queries, one for the statement and the other for
865: -- the row count
866:

Line 1856: htp.formOpen('bis_portlet_pmregion.showDimensions','POST','','','NAME="showDimensions"');

1852: }');
1853:
1854: htp.p('');
1855:
1856: htp.formOpen('bis_portlet_pmregion.showDimensions','POST','','','NAME="showDimensions"');
1857: htp.formHidden('Z',Z);
1858: htp.formHidden('p_back_url',p_back_url);
1859: htp.formHidden('p_reference_path', p_reference_path);
1860: htp.formHidden('p_indlevel');

Line 2629: var url = "bis_portlet_pmregion.editDimensions?U=" + escape(cval) + "'

2625: var c_access = cval.substr(cval.length-1, 1);
2626: if (c_access == "N" ) {
2627: alert("'||l_un_auth||'.");
2628: } else {
2629: var url = "bis_portlet_pmregion.editDimensions?U=" + escape(cval) + "'
2630: ||c_amp||'" + "Z=" + "'||Z||'";
2631: open_new_browser(url,600,450);
2632: }
2633: }

Line 2731: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim0_lbl)||'");

2727: ||c_asterisk||'" + dim_lvl_id;
2728: var c_jsfuncname = "getdim0";
2729: document.dimensions.dim0.selectedIndex = 0;
2730: //modified for bug#2318543
2731: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim0_lbl)||'");
2732: }
2733: }');
2734: -- else {
2735: -- '||l_clear||'

Line 2762: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim1_lbl)||'");

2758: document.dimensions.dim1.selectedIndex = 0;
2759: // alert("dim1 query (user_id, ind, dim lvl, dim0 lvl, dim0 id, g_var): "+c_qry);
2760:
2761: //modified for bug#2318543
2762: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim1_lbl)||'");
2763: }
2764: }');
2765:
2766:

Line 2783: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim2_lbl)||'");

2779:
2780: var c_jsfuncname = "getdim2";
2781: document.dimensions.dim2.selectedIndex = 0;
2782: //modified for bug#2318543
2783: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim2_lbl)||'");
2784: }
2785: }');
2786:
2787:

Line 2805: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim3_lbl)||'");

2801: var c_jsfuncname = "getdim3";
2802: document.dimensions.dim3.selectedIndex = 0;
2803:
2804: //modified for bug#2318543
2805: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim3_lbl)||'");
2806: }
2807: }');
2808:
2809:

Line 2826: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim4_lbl)||'");

2822:
2823: var c_jsfuncname = "getdim4";
2824: document.dimensions.dim4.selectedIndex = 0;
2825: //modified for bug#2318543
2826: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim4_lbl)||'");
2827: }
2828: }');
2829:
2830:

Line 2847: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim5_lbl)||'");

2843:
2844: var c_jsfuncname = "getdim5";
2845: document.dimensions.dim5.selectedIndex = 0;
2846: //modified for bug#2318543
2847: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim5_lbl)||'");
2848: }
2849: }');
2850:
2851: -- mdamle 01/15/2001 - Use Dim6 and Dim7

Line 2867: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim6_lbl)||'");

2863:
2864: var c_jsfuncname = "getdim6";
2865: document.dimensions.dim6.selectedIndex = 0;
2866: //modified for bug#2318543
2867: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim6_lbl)||'");
2868: }
2869: }');
2870:
2871: htp.p('function setdim7() {

Line 2886: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim7_lbl)||'");

2882:
2883: var c_jsfuncname = "getdim7";
2884: document.dimensions.dim7.selectedIndex = 0;
2885: //modified for bug#2318543
2886: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim7_lbl)||'");
2887: }
2888: }');
2889:
2890:

Line 2899: htp.formOpen('bis_portlet_pmregion.strDimensions'

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');
2902:
2903: -- Create hidden values to grab selected labels into

Line 2949: htp.formOpen('bis_portlet_pmregion.showDimensions'

2945: -- **********
2946: -- Open a form for indicator levels
2947:
2948: htp.p('');
2949: htp.formOpen('bis_portlet_pmregion.showDimensions'
2950: ,'POST','','','NAME="indicators"');
2951:
2952: -- Create hidden values to grab selected labels into
2953: for i in 1 .. c_counter LOOP

Line 3830: htp.formOpen('bis_portlet_pmregion.setIndicators'

3826: --meastmon 06/20/2001. Added valign attribute
3827: htp.p('');
3828:
3829: htp.p('');
3830: htp.formOpen('bis_portlet_pmregion.setIndicators'
3831: ,'POST','','','NAME="actionback"');
3832:
3833: for i in p_selections_tbl.FIRST .. p_selections_tbl.COUNT loop
3834: htp.formHidden('p_selections_tbl',p_selections_tbl(i));

Line 4720: getLOV(''bis_portlet_pmregion.dim_level_values_query''

4716: var c_qry = "'||l_user_id||c_asterisk||'" + ind + "'
4717: ||c_asterisk||'" + dim_lvl_id;
4718: var c_jsfuncname = "getdim0";
4719: document.editDimensions.dim0.selectedIndex = 0;
4720: getLOV(''bis_portlet_pmregion.dim_level_values_query''
4721: ,c_qry,c_jsfuncname,'||Z||');
4722: }
4723: }');
4724: -- else {

Line 4748: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||');

4744: '||l_sobString||'
4745:
4746: var c_jsfuncname = "getdim1";
4747: document.editDimensions.dim1.selectedIndex = 0;
4748: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||');
4749: }
4750: }');
4751:
4752:

Line 4766: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||');

4762: '||l_sobString||'
4763:
4764: var c_jsfuncname = "getdim2";
4765: document.editDimensions.dim2.selectedIndex = 0;
4766: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||');
4767: }
4768: }');
4769:
4770:

Line 4784: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||');

4780: '||l_sobString||'
4781:
4782: var c_jsfuncname = "getdim3";
4783: document.editDimensions.dim3.selectedIndex = 0;
4784: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||');
4785: }
4786: }');
4787:
4788:

Line 4802: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||');

4798: '||l_sobString||'
4799:
4800: var c_jsfuncname = "getdim4";
4801: document.editDimensions.dim4.selectedIndex = 0;
4802: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||');
4803: }
4804: }');
4805:
4806:

Line 4820: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||');

4816: '||l_sobString||'
4817:
4818: var c_jsfuncname = "getdim5";
4819: document.editDimensions.dim5.selectedIndex = 0;
4820: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||');
4821: }
4822: }');
4823:
4824:

Line 4839: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||');

4835: '||l_sobString||'
4836:
4837: var c_jsfuncname = "getdim6";
4838: document.editDimensions.dim6.selectedIndex = 0;
4839: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||');
4840: }
4841: }');
4842:
4843:

Line 4858: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||');

4854: '||l_sobString||'
4855:
4856: var c_jsfuncname = "getdim7";
4857: document.editDimensions.dim7.selectedIndex = 0;
4858: getLOV(''bis_portlet_pmregion.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||');
4859: }
4860: }');
4861:
4862:

Line 7745: END BIS_PORTLET_PMREGION;

7741: END free_clob;
7742:
7743: --==========================================================================+
7744:
7745: END BIS_PORTLET_PMREGION;