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_UTILITIES_PVT dependencies on BIS_LEVELS

Line 3195: FROM bis_levels

3191: IS
3192: ------------------------
3193: CURSOR c_dim_id IS
3194: SELECT source
3195: FROM bis_levels
3196: WHERE level_id = p_DimLevelId
3197: ;
3198:
3199: CURSOR c_dim_name IS

Line 3201: FROM bis_levels

3197: ;
3198:
3199: CURSOR c_dim_name IS
3200: SELECT source
3201: FROM bis_levels
3202: WHERE short_name = p_DimLevelName
3203: ;
3204: ---------------------------
3205: l_source VARCHAR2(32000);

Line 3241: FROM bis_levels

3237: IS
3238: ------------------------
3239: CURSOR c_dim_id IS
3240: SELECT source
3241: FROM bis_levels
3242: WHERE level_id = p_DimLevelId
3243: ;
3244:
3245: CURSOR c_dim_name IS

Line 3247: FROM bis_levels

3243: ;
3244:
3245: CURSOR c_dim_name IS
3246: SELECT source
3247: FROM bis_levels
3248: WHERE short_name = p_DimLevelShortName
3249: ;
3250: ---------------------------
3251: l_source VARCHAR2(32000);

Line 3284: FROM bis_levels

3280: IS
3281: ------------------------
3282: CURSOR c_dim_id IS
3283: SELECT source
3284: FROM bis_levels
3285: WHERE level_id = p_DimLevelId
3286: ;
3287:
3288: CURSOR c_dim_name IS

Line 3290: FROM bis_levels

3286: ;
3287:
3288: CURSOR c_dim_name IS
3289: SELECT source
3290: FROM bis_levels
3291: WHERE short_name = p_DimLevelName
3292: ;
3293: ---------------------------
3294: l_source VARCHAR2(32000);

Line 3330: FROM bis_levels

3326: RETURN VARCHAR2
3327: IS
3328: CURSOR c_dim_id IS
3329: SELECT source
3330: FROM bis_levels
3331: WHERE level_id = p_DimLevelId;
3332:
3333: CURSOR c_dim_name IS
3334: SELECT source

Line 3335: FROM bis_levels

3331: WHERE level_id = p_DimLevelId;
3332:
3333: CURSOR c_dim_name IS
3334: SELECT source
3335: FROM bis_levels
3336: WHERE short_name = p_DimLevelName;
3337:
3338: l_source VARCHAR2(32000);
3339: l_dim_name VARCHAR2(80);

Line 3510: FROM bis_levels BL,

3506: begin
3507:
3508: SELECT BL.short_name -- 2735844
3509: INTO l_level_short_name
3510: FROM bis_levels BL,
3511: bis_target_levels BTL
3512: WHERE BTL.short_name = l_tgt_lvl_short_name
3513: AND
3514: ( BL.level_id = BTL.dimension1_level_id

Line 3528: (select dimension_id from bis_levels where short_name = l_level_short_name);

3524:
3525: select short_name
3526: into l_dim_short_name
3527: from bis_dimensions where dimension_id in
3528: (select dimension_id from bis_levels where short_name = l_level_short_name);
3529:
3530:
3531: exception
3532: when others then

Line 3604: FROM bis_levels

3600: IS
3601:
3602: CURSOR c_dim_name IS
3603: SELECT source
3604: FROM bis_levels
3605: WHERE short_name = p_dim_Level_short_name
3606: ;
3607:
3608: l_dimlevel_cut VARCHAR2(2000);

Line 3677: FROM bis_levels

3673: IS
3674: ------------------------
3675: CURSOR c_dim_id IS
3676: SELECT source
3677: FROM bis_levels
3678: WHERE level_id = p_DimLevelId
3679: ;
3680:
3681: CURSOR c_dim_name IS

Line 3683: FROM bis_levels

3679: ;
3680:
3681: CURSOR c_dim_name IS
3682: SELECT source
3683: FROM bis_levels
3684: WHERE short_name = p_DimLevelName
3685: ;
3686: ---------------------------
3687: l_total_name VARCHAR2(2000);

Line 3807: FROM BIS_LEVELS

3803: BEGIN
3804:
3805: SELECT SHORT_NAME
3806: INTO l_time_level_short_name
3807: FROM BIS_LEVELS
3808: WHERE LEVEL_ID = p_dim_level_id;
3809:
3810: RETURN l_time_level_short_name;
3811:

Line 4206: CURSOR c_dim_lvl_sn( cp_lvl_values_view IN VARCHAR2) IS SELECT short_name FROM bis_levels WHERE

4202: l_star VARCHAR2(2) := '*';
4203: l_star1 NUMBER := -9999;
4204:
4205: --2684911
4206: CURSOR c_dim_lvl_sn( cp_lvl_values_view IN VARCHAR2) IS SELECT short_name FROM bis_levels WHERE
4207: level_values_view_name = cp_lvl_values_view ;
4208: l_short_name bis_levels.short_name%TYPE;
4209: l_time_lvl_dep_on_org NUMBER(3);
4210: l_is_dep_on_org BOOLEAN := FALSE;

Line 4208: l_short_name bis_levels.short_name%TYPE;

4204:
4205: --2684911
4206: CURSOR c_dim_lvl_sn( cp_lvl_values_view IN VARCHAR2) IS SELECT short_name FROM bis_levels WHERE
4207: level_values_view_name = cp_lvl_values_view ;
4208: l_short_name bis_levels.short_name%TYPE;
4209: l_time_lvl_dep_on_org NUMBER(3);
4210: l_is_dep_on_org BOOLEAN := FALSE;
4211:
4212: TYPE tcursor IS REF CURSOR;

Line 4333: CURSOR c_dim_lvl_sn( cp_lvl_values_view IN VARCHAR2) IS SELECT short_name FROM bis_levels WHERE

4329:
4330: l_star1 NUMBER := -9999;
4331:
4332: --2684911
4333: CURSOR c_dim_lvl_sn( cp_lvl_values_view IN VARCHAR2) IS SELECT short_name FROM bis_levels WHERE
4334: level_values_view_name = cp_lvl_values_view ;
4335: l_short_name bis_levels.short_name%TYPE;
4336: l_time_lvl_dep_on_org NUMBER(3);
4337: l_is_dep_on_org BOOLEAN := FALSE;

Line 4335: l_short_name bis_levels.short_name%TYPE;

4331:
4332: --2684911
4333: CURSOR c_dim_lvl_sn( cp_lvl_values_view IN VARCHAR2) IS SELECT short_name FROM bis_levels WHERE
4334: level_values_view_name = cp_lvl_values_view ;
4335: l_short_name bis_levels.short_name%TYPE;
4336: l_time_lvl_dep_on_org NUMBER(3);
4337: l_is_dep_on_org BOOLEAN := FALSE;
4338:
4339:

Line 4527: CURSOR c_dim_lvl_sn( cp_lvl_values_view IN VARCHAR2) IS SELECT short_name FROM bis_levels WHERE

4523:
4524: l_star1 NUMBER := -9999;
4525:
4526: --2684911
4527: CURSOR c_dim_lvl_sn( cp_lvl_values_view IN VARCHAR2) IS SELECT short_name FROM bis_levels WHERE
4528: level_values_view_name = cp_lvl_values_view ;
4529: l_short_name bis_levels.short_name%TYPE;
4530: l_time_lvl_dep_on_org NUMBER(3);
4531: l_is_dep_on_org BOOLEAN := FALSE;

Line 4529: l_short_name bis_levels.short_name%TYPE;

4525:
4526: --2684911
4527: CURSOR c_dim_lvl_sn( cp_lvl_values_view IN VARCHAR2) IS SELECT short_name FROM bis_levels WHERE
4528: level_values_view_name = cp_lvl_values_view ;
4529: l_short_name bis_levels.short_name%TYPE;
4530: l_time_lvl_dep_on_org NUMBER(3);
4531: l_is_dep_on_org BOOLEAN := FALSE;
4532:
4533: TYPE tcursor IS REF CURSOR;

Line 4671: CURSOR c_dim_lvl_sn( cp_lvl_values_view IN VARCHAR2) IS SELECT short_name FROM bis_levels WHERE

4667: TYPE tcursor IS REF CURSOR;
4668: l_cursor tcursor;
4669:
4670: --2684911
4671: CURSOR c_dim_lvl_sn( cp_lvl_values_view IN VARCHAR2) IS SELECT short_name FROM bis_levels WHERE
4672: level_values_view_name = cp_lvl_values_view ;
4673: l_short_name bis_levels.short_name%TYPE;
4674: l_time_lvl_dep_on_org NUMBER(3);
4675: l_is_dep_on_org BOOLEAN := FALSE;

Line 4673: l_short_name bis_levels.short_name%TYPE;

4669:
4670: --2684911
4671: CURSOR c_dim_lvl_sn( cp_lvl_values_view IN VARCHAR2) IS SELECT short_name FROM bis_levels WHERE
4672: level_values_view_name = cp_lvl_values_view ;
4673: l_short_name bis_levels.short_name%TYPE;
4674: l_time_lvl_dep_on_org NUMBER(3);
4675: l_is_dep_on_org BOOLEAN := FALSE;
4676:
4677: l_dim_lvl_view_name VARCHAR2(32000) := NULL;

Line 4971: FROM bis_levels

4967: BEGIN
4968:
4969: SELECT level_id
4970: INTO l_level_id
4971: FROM bis_levels
4972: WHERE short_name = p_level_short_name
4973: AND source = 'OLTP'
4974: AND level_values_view_name IS NULL;
4975:

Line 4991: l_temp_level bis_levels.short_name%TYPE; -- VARCHAR2(15);

4987: ( p_level_short_name IN VARCHAR2
4988: , p_end_date IN DATE
4989: ) RETURN DATE IS
4990:
4991: l_temp_level bis_levels.short_name%TYPE; -- VARCHAR2(15);
4992: l_start_date DATE;
4993: l_dynamic_sql_str VARCHAR2(4000);
4994:
4995: BEGIN