APPS.BIS_INDICATOR_REGION_UI_PVT dependencies on BISFV_TARGET_LEVELS

Line 1756: cursor bisfv_target_levels_cur(p_tarid in pls_integer) is

1752: ORDER BY name;
1753:
1754: -- mdamle 01/15/2001 - Use Dim6 and Dim7
1755: -- added short_names and additional levels
1756: cursor bisfv_target_levels_cur(p_tarid in pls_integer) is
1757: SELECT TARGET_LEVEL_ID,
1758: TARGET_LEVEL_NAME,
1759: -- mdamle 01/15/2001 - Use Dim6 and Dim7
1760: -- ORG_LEVEL_ID,

Line 1784: FROM BISFV_TARGET_LEVELS

1780: DIMENSION6_LEVEL_NAME,
1781: DIMENSION7_LEVEL_ID,
1782: DIMENSION7_LEVEL_SHORT_NAME,
1783: DIMENSION7_LEVEL_NAME
1784: FROM BISFV_TARGET_LEVELS
1785: WHERE TARGET_LEVEL_ID = p_tarid;
1786:
1787: l_button_str varchar2(32000);
1788: l_button_tbl BIS_UTILITIES_PVT.HTML_Button_Tbl_Type;

Line 2249: for c_recs in bisfv_target_levels_cur(v_ind_level_id) loop

2245: l_text := substr (p_selections_tbl(i),l_loc + 1);
2246: if v_ind_level_id is NULL then
2247: v_ind_level_id := TO_NUMBER(l_value);
2248: end if;
2249: for c_recs in bisfv_target_levels_cur(v_ind_level_id) loop
2250: l_dim1_lbl := c_recs.Dimension1_Level_Name;
2251: l_dim2_lbl := c_recs.Dimension2_Level_Name;
2252: l_dim3_lbl := c_recs.Dimension3_Level_Name;
2253: l_dim4_lbl := c_recs.Dimension4_Level_Name;

Line 2670: for c_recs in bisfv_target_levels_cur(v_ind_level_id) loop

2666: l_string1 := '';
2667:
2668:
2669:
2670: for c_recs in bisfv_target_levels_cur(v_ind_level_id) loop
2671:
2672: -- *************************************************************
2673: -- Start painting the dimension levels poplists
2674: -- If no dimension level for this ind level, put a hidden value

Line 3526: cursor bisfv_target_levels_cur(p_tarid in pls_integer) is

3522: FROM BISBV_BUSINESS_PLANS
3523: ORDER BY name;
3524:
3525: -- mdamle 01/15/2001 - Use Dim6 and Dim7
3526: cursor bisfv_target_levels_cur(p_tarid in pls_integer) is
3527: SELECT TARGET_LEVEL_ID,
3528: TARGET_LEVEL_NAME,
3529: -- mdamle 01/15/2001 - Use Dim6 and Dim7
3530: -- ORG_LEVEL_ID,

Line 3554: FROM BISFV_TARGET_LEVELS

3550: DIMENSION6_LEVEL_NAME,
3551: DIMENSION7_LEVEL_ID,
3552: DIMENSION7_LEVEL_SHORT_NAME,
3553: DIMENSION7_LEVEL_NAME
3554: FROM BISFV_TARGET_LEVELS
3555: WHERE TARGET_LEVEL_ID = p_tarid;
3556:
3557: l_append_string VARCHAR2(1000);
3558: l_swan_enabled BOOLEAN;

Line 4247: for c_recs in bisfv_target_levels_cur(l_indlevel_id) LOOP

4243: -- Table containing the dimension names,boxes
4244:
4245:
4246:
4247: for c_recs in bisfv_target_levels_cur(l_indlevel_id) LOOP
4248:
4249: -- ******************************
4250: -- Dimension0 for Organization
4251:

Line 5246: from bisfv_target_levels tl

5242: || decode(DIMENSION3_LEVEL_NAME, '', '', ' - ' || DIMENSION3_LEVEL_NAME) || decode(DIMENSION4_LEVEL_NAME, '', '', ' - ' || DIMENSION4_LEVEL_NAME)
5243: || decode(DIMENSION5_LEVEL_NAME, '', '', ' - ' || DIMENSION5_LEVEL_NAME) || decode(DIMENSION6_LEVEL_NAME, '', '', ' - ' || DIMENSION6_LEVEL_NAME)
5244: || decode(DIMENSION7_LEVEL_NAME, '', '', ' - ' || DIMENSION7_LEVEL_NAME) || ')'
5245: into l_perf_meas_name
5246: from bisfv_target_levels tl
5247: Where tl.target_level_id = p_target_level_id;
5248: exception
5249: when others then
5250: l_perf_meas_name := '';