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_INDICATOR_REGION_UI_PVT dependencies on BIS_UTILITIES_PUB

Line 349: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ; --2684911

345: x_msg_data => l_msg_data);
346:
347: l_time_dimension_name := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id, NULL);
348: l_total_time_level_name := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_TL(l_time_dimension_name, p_target_level_id, NULL);
349: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ; --2684911
350:
351: OPEN c_source;
352: FETCH c_source INTO l_source;
353: CLOSE c_source;

Line 370: IF l_source = 'OLTP' AND l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG THEN --2684911

366: l_sql := l_sql||
367: ' WHERE TRUNC(SYSDATE) BETWEEN '||
368: ' NVL(start_date, TRUNC(SYSDATE)) and NVL(end_date, TRUNC(SYSDATE))';
369:
370: IF l_source = 'OLTP' AND l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG THEN --2684911
371: -- For OLTP we need an additional condition on organization id
372: -- if the time level is not one of HR
373: OPEN c_org_dimension_index;
374: FETCH c_org_dimension_index INTO l_org_dimension_index, l_org_dimension_level_id;

Line 395: IF (l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN --2684911

391: -- In this case we need to filter out NOCOPY codes 0 and -1 which are special codes in EDW dimension tables
392: l_sql := l_sql||
393: ' AND '||l_id_name||' NOT IN (''-1'', ''0'')';
394:
395: IF (l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN --2684911
396: OPEN c_org_dimension_index;
397: FETCH c_org_dimension_index INTO l_org_dimension_index, l_org_dimension_level_id;
398: CLOSE c_org_dimension_index;
399:

Line 548: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ; --2684911

544: OPEN c_source;
545: FETCH c_source INTO l_source;
546: CLOSE c_source;
547:
548: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ; --2684911
549:
550: -- For total time level there is only one record in the dimension view
551: -- which is the one we want.
552:

Line 562: l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG THEN --2684911

558: -- In this case we get the end date of the current period and look for
559: -- the period containing the next day
560:
561: IF l_source = 'OLTP' AND
562: l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG THEN --2684911
563: -- For OLTP we need an additional condition on organization id
564: -- if the time level is not one of HR
565: OPEN c_org_dimension_index;
566: FETCH c_org_dimension_index INTO l_org_dimension_index, l_org_dimension_level_id;

Line 606: IF (l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN --2684911

602: IF l_source = 'EDW' THEN
603: -- In this case we need to filter out NOCOPY codes 0 and -1 which are special codes in EDW dimension tables
604: l_sql := l_sql||
605: ' AND '||l_id_name||' NOT IN (''-1'', ''0'')';
606: IF (l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN --2684911
607:
608: OPEN c_org_dimension_index;
609: FETCH c_org_dimension_index INTO l_org_dimension_index, l_org_dimension_level_id;
610: CLOSE c_org_dimension_index;

Line 732: '&SortInfo='||BIS_UTILITIES_PUB.encode('SortyaxisAsc')||

728: '?dbc='||FND_WEB_CONFIG.DATABASE_ID||
729: '&sessionid='||icx_call.encrypt3(p_session_id)||
730: '&RegionCode='||
731: '&FunctionName='||
732: '&SortInfo='||BIS_UTILITIES_PUB.encode('SortyaxisAsc')||
733: '&pageSource='||BIS_UTILITIES_PUB.encode('PMRegion')||
734: '&Measure='||BIS_UTILITIES_PUB.encode(l_measure)||
735: '&PlanId='||p_plan_id;
736:

Line 733: '&pageSource='||BIS_UTILITIES_PUB.encode('PMRegion')||

729: '&sessionid='||icx_call.encrypt3(p_session_id)||
730: '&RegionCode='||
731: '&FunctionName='||
732: '&SortInfo='||BIS_UTILITIES_PUB.encode('SortyaxisAsc')||
733: '&pageSource='||BIS_UTILITIES_PUB.encode('PMRegion')||
734: '&Measure='||BIS_UTILITIES_PUB.encode(l_measure)||
735: '&PlanId='||p_plan_id;
736:
737: FOR l_i IN 1..7 LOOP

Line 734: '&Measure='||BIS_UTILITIES_PUB.encode(l_measure)||

730: '&RegionCode='||
731: '&FunctionName='||
732: '&SortInfo='||BIS_UTILITIES_PUB.encode('SortyaxisAsc')||
733: '&pageSource='||BIS_UTILITIES_PUB.encode('PMRegion')||
734: '&Measure='||BIS_UTILITIES_PUB.encode(l_measure)||
735: '&PlanId='||p_plan_id;
736:
737: FOR l_i IN 1..7 LOOP
738: l_dim_level := NULL;

Line 750: '&Dim'||l_i||'Level='||BIS_UTILITIES_PUB.encode(l_dim_level);

746: CLOSE c_dim_level_value;
747:
748: IF l_dim_level IS NOT NULL THEN
749: l_dim_levels := l_dim_levels||
750: '&Dim'||l_i||'Level='||BIS_UTILITIES_PUB.encode(l_dim_level);
751:
752: IF l_i = p_time_dimension_index THEN
753: -- get next period value id
754: getNextPeriodInfo(p_ind_selection_id,

Line 763: '&Dim'||l_i||'LevelValue='||BIS_UTILITIES_PUB.encode(l_next_period_id);

759: l_next_period_id,
760: l_next_period_name);
761: IF l_next_period_id IS NOT NULL THEN
762: l_dim_level_values := l_dim_level_values||
763: '&Dim'||l_i||'LevelValue='||BIS_UTILITIES_PUB.encode(l_next_period_id);
764: ELSE
765: l_dim_level_values := l_dim_level_values||
766: '&Dim'||l_i||'LevelValue=';
767: END IF;

Line 771: '&Dim'||l_i||'LevelValue='||BIS_UTILITIES_PUB.encode(l_dim_level_value);

767: END IF;
768:
769: ELSE
770: l_dim_level_values := l_dim_level_values||
771: '&Dim'||l_i||'LevelValue='||BIS_UTILITIES_PUB.encode(l_dim_level_value);
772: END IF;
773: ELSE
774: l_dim_levels := l_dim_levels||
775: '&Dim'||l_i||'Level=';

Line 1195: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1191: l_selections_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
1192: l_temp_tbl no_duplicates_tbl_Type;
1193: l_unique BOOLEAN;
1194: l_cnt pls_integer;
1195: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1196:
1197: -- Fix for ADA buttons
1198: l_button_str varchar2(32000);
1199: l_button_tbl BIS_UTILITIES_PVT.HTML_Button_Tbl_Type;

Line 1741: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1737:
1738: d0 varchar2(32000);
1739: d1 varchar2(32000);
1740: l_link varchar2(32000);
1741: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1742: l_clear VARCHAR2(32000);
1743: l_sobString VARCHAR2(32000);
1744: l_elements BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
1745:

Line 1744: l_elements BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;

1740: l_link varchar2(32000);
1741: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1742: l_clear VARCHAR2(32000);
1743: l_sobString VARCHAR2(32000);
1744: l_elements BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
1745:
1746: -- Grab the incoming indicator level id into a local var for use later
1747: v_ind_level_id pls_integer := p_ind_level_id;
1748:

Line 2289: l_string := l_string ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim0_lbl)||'");';

2285: l_string := l_string ||' var c_qry = "'||l_user_id||c_asterisk||'" + ind + "'||c_asterisk||'" + dim_lvl_id;';
2286: l_string := l_string ||' var c_jsfuncname = "getdim0";';
2287: l_string := l_string ||' document.DefaultFormName.dim0.selectedIndex = 0;';
2288: --l_string := l_string ||'//modified for bug#2318543';
2289: l_string := l_string ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim0_lbl)||'");';
2290: l_string := l_string ||' }';
2291: l_string := l_string ||' }';
2292:
2293: SetSetOfBookVar

Line 2316: l_string := l_string ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim1_lbl)||'");';

2312: l_string := l_string ||' var c_jsfuncname = "getdim1";';
2313: l_string := l_string ||' document.DefaultFormName.dim1.selectedIndex = 0;';
2314:
2315: --l_string := l_string ||' //modified for bug#2318543';
2316: l_string := l_string ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim1_lbl)||'");';
2317: l_string := l_string ||' }';
2318: l_string := l_string ||' }';
2319: l_string := l_string ||'function setdim2() {';
2320: --l_string := l_string ||'// alert("setdim2");';

Line 2333: l_string := l_string ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim2_lbl)||'");';

2329: l_string := l_string ||' '||l_sobString||'';
2330:
2331: l_string := l_string ||' var c_jsfuncname = "getdim2";';
2332: l_string := l_string ||' document.DefaultFormName.dim2.selectedIndex = 0;';
2333: l_string := l_string ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim2_lbl)||'");';
2334: l_string := l_string ||' }';
2335: l_string := l_string ||' }';
2336:
2337:

Line 2353: l_string := l_string ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim3_lbl)||'");';

2349: l_string := l_string ||' '||l_sobString||'';
2350:
2351: l_string := l_string ||' var c_jsfuncname = "getdim3";';
2352: l_string := l_string ||' document.DefaultFormName.dim3.selectedIndex = 0;';
2353: l_string := l_string ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim3_lbl)||'");';
2354: l_string := l_string ||' }';
2355: l_string := l_string ||' }';
2356:
2357:

Line 2373: l_string := l_string ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim4_lbl)||'");';

2369: l_string := l_string ||' '||l_sobString||'';
2370:
2371: l_string := l_string ||' var c_jsfuncname = "getdim4";';
2372: l_string := l_string ||' document.DefaultFormName.dim4.selectedIndex = 0;';
2373: l_string := l_string ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim4_lbl)||'");';
2374: l_string := l_string ||' }';
2375: l_string := l_string ||' }';
2376:
2377: WF_NOTIFICATION.WriteToClob(l_str_object,l_string);

Line 2395: l_string1 := l_string1 ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim5_lbl)||'");';

2391: l_string1 := l_string1 ||' '||l_sobString||'';
2392:
2393: l_string1 := l_string1 ||' var c_jsfuncname = "getdim5";';
2394: l_string1 := l_string1 ||' document.DefaultFormName.dim5.selectedIndex = 0;';
2395: l_string1 := l_string1 ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim5_lbl)||'");';
2396: l_string1 := l_string1 ||' }';
2397: l_string1 := l_string1 ||' }';
2398:
2399: -- mdamle 01/15/2001 - Use Dim6 and Dim7

Line 2414: l_string1 := l_string1 ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim6_lbl)||'");';

2410: l_string1 := l_string1 ||' '||l_sobString||'';
2411:
2412: l_string1 := l_string1 ||' var c_jsfuncname = "getdim6";';
2413: l_string1 := l_string1 ||' document.DefaultFormName.dim6.selectedIndex = 0;';
2414: l_string1 := l_string1 ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim6_lbl)||'");';
2415: l_string1 := l_string1 ||' }';
2416: l_string1 := l_string1 ||' }';
2417:
2418: l_string1 := l_string1 ||'function setdim7() {';

Line 2432: l_string1 := l_string1 ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim7_lbl)||'");';

2428: l_string1 := l_string1 ||' '||l_sobString||'';
2429:
2430: l_string1 := l_string1 ||' var c_jsfuncname = "getdim7";';
2431: l_string1 := l_string1 ||' document.DefaultFormName.dim7.selectedIndex = 0;';
2432: l_string1 := l_string1 ||' getLOV(''bis_intermediate_lov_pvt.dim_level_values_query'',c_qry,c_jsfuncname,'||Z||',"'||bis_utilities_pub.encode(l_dim7_lbl)||'");';
2433: l_string1 := l_string1 ||' }';
2434: l_string1 := l_string1 ||' }';
2435:
2436:

Line 3501: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

3497: l_Org_Level_Value_ID number;
3498: l_Org_Level_Short_Name varchar2(240);
3499: l_Org_Level_Name bis_levels_tl.name%TYPE;
3500:
3501: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3502: l_clear VARCHAR2(32000);
3503: l_sobString VARCHAR2(32000);
3504: l_sob_level_id NUMBER;
3505: l_org_level_id NUMBER;

Line 3506: l_elements BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;

3502: l_clear VARCHAR2(32000);
3503: l_sobString VARCHAR2(32000);
3504: l_sob_level_id NUMBER;
3505: l_org_level_id NUMBER;
3506: l_elements BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
3507:
3508: -- meastmon 06/20/2001
3509: -- Fix for ADA buttons
3510: l_button_str varchar2(32000);

Line 4962: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

4958:
4959: l_plan varchar2(32000);
4960: l_length pls_integer;
4961: l_display_label varchar2(32000);
4962: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4963: l_return_status varchar2(32000);
4964: l_indicator_region_values BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;
4965: l_plan_idnum pls_integer;
4966:

Line 5140: , p_elementTable IN BIS_UTILITIES_PUB.BIS_VARCHAR_TBL

5136: end removeDuplicates;
5137:
5138: PROCEDURE clearSelect(
5139: p_formName IN VARCHAR2
5140: , p_elementTable IN BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
5141: , x_clearString OUT NOCOPY VARCHAR2
5142: )
5143: IS
5144: l_clear VARCHAR2(32000);

Line 7234: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type; -- 2164190 sashaik

7230: l_act_in BIS_ACTUAL_PUB.Actual_rec_type; -- 2164190 sashaik
7231: l_act_out BIS_ACTUAL_PUB.Actual_rec_type; -- 2164190 sashaik
7232: l_msg_count NUMBER; -- 2164190 sashaik
7233: l_msg_data VARCHAR2(32000); -- 2164190 sashaik
7234: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type; -- 2164190 sashaik
7235: l_return_status VARCHAR2(300); -- 2164190 sashaik
7236:
7237: BEGIN
7238: