[Home] [Help]
419: l_totalpossible||c_amp||
420: 'p_totalavailable='||l_totalcount||c_amp||
421: --modified for bug#2318543
422: -- 'p_titlename='||REPLACE(l_titlename,' ',c_plus)||c_amp||
423: 'p_titlename='||bis_utilities_pub.encode(l_titlename)
424: ||c_amp||
425: 'p_startnum='||p_startnum||c_amp||
426: 'p_rowcount='||p_rowcount||c_amp||
427: 'p_search_str='||l_search_str;
430: -- frame src url does not understand plsql tables
431: for i in p_coldata.FIRST .. p_coldata.COUNT loop
432: --modified for bug#2318543
433: -- l_head := l_head||c_amp||'p_head='||REPLACE(p_coldata(i).header,' ',c_plus);
434: l_head := l_head||c_amp||'p_head='||bis_utilities_pub.encode(p_coldata(i).header);
435: l_value := l_value||c_amp||'p_value='||p_coldata(i).value;
436: l_link := l_link||c_amp||'p_link='||p_coldata(i).link;
437: l_disp := l_disp||c_amp||'p_disp='||p_coldata(i).display;
438: end loop;
1592: l_selections_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
1593: l_temp_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
1594: l_unique BOOLEAN;
1595: l_cnt pls_integer;
1596: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1597: -- meastmon 06/20/2001
1598: -- Fix for ADA buttons
1599: l_button_str VARCHAR2(32000);
1600: l_button_tbl BIS_UTILITIES_PVT.HTML_Button_Tbl_Type;
2146: l_Org_Level_Short_Name VARCHAR2(240);
2147: l_Org_Level_Name bis_levels_tl.name%TYPE;
2148:
2149: l_link VARCHAR2(32000);
2150: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2151: l_clear VARCHAR2(32000);
2152: l_sobString VARCHAR2(32000);
2153: l_elements BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
2154:
2149: l_link VARCHAR2(32000);
2150: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2151: l_clear VARCHAR2(32000);
2152: l_sobString VARCHAR2(32000);
2153: l_elements BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
2154:
2155: -- Grab the incoming indicator level id into a local var for use later
2156: v_ind_level_id PLS_INTEGER := p_ind_level_id;
2157:
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||'
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:
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:
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:
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:
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
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() {
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:
3917:
3918: l_plan varchar2(32000);
3919: l_length pls_integer;
3920: l_display_label varchar2(32000);
3921: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3922: l_return_status varchar2(32000);
3923: l_indicator_region_values BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;
3924: l_plan_idnum pls_integer;
3925:
4033: END IF;
4034:
4035: owa_util.redirect_url(p_back_url);
4036:
4037: -- owa_util.redirect_url(bis_utilities_pub.encode(p_back_url)); -- 2418741
4038:
4039:
4040: end if; -- icx_validate_session
4041:
4152: l_Org_Level_Value_ID number;
4153: l_Org_Level_Short_Name varchar2(240);
4154: l_Org_Level_Name bis_levels_tl.name%TYPE;
4155:
4156: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4157: l_clear VARCHAR2(32000);
4158: l_sobString VARCHAR2(32000);
4159: l_sob_level_id NUMBER;
4160: l_org_level_id NUMBER;
4157: l_clear VARCHAR2(32000);
4158: l_sobString VARCHAR2(32000);
4159: l_sob_level_id NUMBER;
4160: l_org_level_id NUMBER;
4161: l_elements BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
4162:
4163: -- meastmon 06/20/2001
4164: -- Fix for ADA buttons
4165: l_button_str varchar2(32000);
5798: --==========================================================================
5799: FUNCTION getTargetLevelId(
5800: p_parameters IN VARCHAR2
5801: ,x_return_status OUT NOCOPY VARCHAR2
5802: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
5803: ) RETURN NUMBER
5804: IS
5805: l_level_short_name VARCHAR2(80);
5806: l_target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
5826: , x_error_Tbl => x_error_tbl
5827: );
5828: -- bug#2210756
5829:
5830: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_level_rec.TARGET_LEVEL_ID) = FND_API.G_TRUE) THEN
5831:
5832: RETURN NULL;
5833: END IF;
5834:
5857: -- 11-DEC-2001 juwang Created.
5858: --==========================================================================
5859: FUNCTION getDefaultPlanId(
5860: x_return_status OUT NOCOPY VARCHAR2
5861: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
5862: ) RETURN NUMBER
5863: IS
5864: l_plan_id NUMBER := c_NULL;
5865:
5915: FUNCTION getPlanId(
5916: p_parameters IN VARCHAR2
5917: ,p_default_plan_id IN NUMBER
5918: ,x_return_status OUT NOCOPY VARCHAR2
5919: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
5920: ) RETURN NUMBER
5921: IS
5922:
5923: l_business_plan_rec BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;
5996: ,p_user_id IN NUMBER
5997: ,p_user_fname IN VARCHAR2
5998: ,p_default_plan_id IN NUMBER
5999: ,x_return_status OUT NOCOPY VARCHAR2
6000: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
6001: )
6002: IS
6003:
6004: l_plan_id NUMBER;
6092: p_reference_path IN VARCHAR2
6093: ,p_plug_id IN NUMBER
6094: ,p_user_id IN NUMBER
6095: ,x_return_status OUT NOCOPY VARCHAR2
6096: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
6097: )
6098: IS
6099: l_menu_name VARCHAR2(30);
6100: l_parameters VARCHAR2(2000);
7102: l_act_in BIS_ACTUAL_PUB.Actual_rec_type; -- 2164190 sashaik
7103: l_act_out BIS_ACTUAL_PUB.Actual_rec_type; -- 2164190 sashaik
7104: l_msg_count NUMBER; -- 2164190 sashaik
7105: l_msg_data VARCHAR2(32000); -- 2164190 sashaik
7106: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type; -- 2164190 sashaik
7107: l_return_status VARCHAR2(300); -- 2164190 sashaik
7108:
7109: BEGIN
7110:
7549: l_session_id NUMBER;
7550: l_login_user_id integer;
7551: l_owner_user_id integer;
7552: l_return_status VARCHAR2(2000);
7553: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
7554:
7555: l_html_buffer VARCHAR2(32000) := NULL;
7556: l_html_clob CLOB := NULL;
7557: