APPS.BIS_INDICATOR_REGION_UI_PVT dependencies on BIS_LEVELS

Line 298: FROM bis_levels

294: WHERE ind_selection_id = p_ind_selection_id;
295:
296: CURSOR c_org_level_name (org_level_id NUMBER) IS
297: SELECT short_name
298: FROM bis_levels
299: WHERE level_id = org_level_id;
300:
301:
302: l_source VARCHAR2(30);

Line 313: l_description bis_levels_tl.description%TYPE;

309: l_id VARCHAR2(250);
310: l_value VARCHAR2(2500);
311: l_select_stmt VARCHAR2(2000);
312: l_sql_result INTEGER := 0;
313: l_description bis_levels_tl.description%TYPE;
314: l_return_status VARCHAR2(240);
315: l_id_name VARCHAR(2000);
316: l_value_name VARCHAR(2000);
317: l_msg_count NUMBER;

Line 489: FROM bis_levels

485: WHERE ind_selection_id = p_ind_selection_id;
486:
487: CURSOR c_org_level_name (org_level_id NUMBER) IS
488: SELECT short_name
489: FROM bis_levels
490: WHERE level_id = org_level_id;
491:
492: l_source VARCHAR2(30);
493: l_time_dimension_name VARCHAR2(500);

Line 503: l_description bis_levels_tl.description%TYPE;

499: l_id VARCHAR2(250);
500: l_value VARCHAR2(2500);
501: l_select_stmt VARCHAR2(2000);
502: l_sql_result INTEGER := 0;
503: l_description bis_levels_tl.description%TYPE;
504: l_return_status VARCHAR2(240);
505: l_id_name VARCHAR(2000);
506: l_value_name VARCHAR(2000);
507: l_msg_count NUMBER;

Line 681: FROM bis_levels

677: t.target_level_id = p_target_level_id;
678:
679: CURSOR c_dim_level(dimension_index NUMBER) IS
680: SELECT short_name
681: FROM bis_levels
682: WHERE level_id = (
683: SELECT decode(dimension_index,
684: 1, dimension1_level_id,
685: 2, dimension2_level_id,

Line 1736: l_Org_Level_Name bis_levels_tl.name%TYPE;

1732:
1733: l_Org_Level_Value_ID varchar2(80); -- number;
1734:
1735: l_Org_Level_Short_Name varchar2(240);
1736: l_Org_Level_Name bis_levels_tl.name%TYPE;
1737:
1738: d0 varchar2(32000);
1739: d1 varchar2(32000);
1740: l_link varchar2(32000);

Line 3499: l_Org_Level_Name bis_levels_tl.name%TYPE;

3495: --
3496: l_Org_Seq_Num number;
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);

Line 3660: FROM BIS_LEVELS

3656: -- Set the set of books id for GL dimension levels
3657: --
3658: SELECT level_id
3659: INTO l_sob_level_id
3660: FROM BIS_LEVELS
3661: WHERE SHORT_NAME = 'SET OF BOOKS';
3662:
3663: -- mdamle 01/15/2001 - Use Dim6 and Dim7
3664: l_org_level_id := getOrgLevelID(l_indlevel_id);

Line 5393: FROM bisbv_target_levels tlv, bis_levels blv

5389:
5390: CURSOR cur_notimelvl (p_tarid IN PLS_INTEGER)
5391: IS
5392: SELECT tlv.target_level_id
5393: FROM bisbv_target_levels tlv, bis_levels blv
5394: WHERE tlv.target_level_id = p_tarid
5395: AND (
5396: tlv.dimension1_level_id = blv.level_id
5397: OR tlv.dimension2_level_id = blv.level_id

Line 7460: FROM bis_levels

7456:
7457:
7458: SELECT short_name
7459: INTO level_short_name
7460: FROM bis_levels
7461: WHERE level_id = l_time_dimension_level_id;
7462:
7463: isRollingLevel := bis_utilities_pvt.Is_Rolling_Period_Level(level_short_name);
7464: