APPS.BIS_TARGET_LEVEL_PVT dependencies on BIS_DIMENSIONS

Line 4299: l_dim_short_nm bis_dimensions.short_name%TYPE;

4295: l_measure_rec_p BIS_MEASURE_PUB.MEASURE_REC_TYPE;
4296: l_return_status VARCHAR2(100);
4297: l_return_msg VARCHAR2(3000);
4298: l_level_short_nm bis_levels.short_name%TYPE;
4299: l_dim_short_nm bis_dimensions.short_name%TYPE;
4300: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4301:
4302: BEGIN
4303:

Line 4456: l_dim_short_name bis_dimensions.short_name%TYPE := NULL;

4452: i NUMBER;
4453: j NUMBER;
4454: l_dim_id NUMBER;
4455: l_match BOOLEAN;
4456: l_dim_short_name bis_dimensions.short_name%TYPE := NULL;
4457: l_lvl_short_name bis_levels.short_name%TYPE := NULL;
4458: l_exists NUMBER := NULL;
4459: l_dim_present BOOLEAN;
4460: l_lvl_present BOOLEAN;

Line 4528: FROM bis_dimensions

4524: IF (l_match = FALSE) THEN
4525:
4526: SELECT short_name
4527: INTO l_dim_short_name
4528: FROM bis_dimensions
4529: WHERE dimension_id = p_dim_tbl_type(i);
4530:
4531: /* -- 2515991
4532: l_error_msg := 'In the definition of Summary Level '

Line 4727: l_dim_short_name bis_dimensions.short_name%TYPE;

4723:
4724: i NUMBER;
4725: j NUMBER;
4726: l_num_dims NUMBER;
4727: l_dim_short_name bis_dimensions.short_name%TYPE;
4728:
4729: BEGIN
4730:
4731: l_num_dims := p_dim_tbl_type.COUNT;

Line 4743: FROM BIS_DIMENSIONS

4739: IF ( p_dim_tbl_type(i) = p_dim_tbl_type(j) ) THEN
4740:
4741: SELECT short_name
4742: INTO l_dim_short_name
4743: FROM BIS_DIMENSIONS
4744: WHERE dimension_id = p_dim_tbl_type(i);
4745:
4746: -- BIS_UTILITIES_PUB.put_line(p_text =>'The dimension ' || nvl(l_dim_short_name, ' ') || ' is not unique. ' ); -- 2515991
4747:

Line 4790: l_dim_short_name bis_dimensions.short_name%TYPE;

4786: i NUMBER;
4787: j NUMBER;
4788: l_num_levels NUMBER;
4789: l_count NUMBER;
4790: l_dim_short_name bis_dimensions.short_name%TYPE;
4791:
4792: BEGIN
4793:
4794: l_num_levels := p_lvl_tbl_type.COUNT;

Line 4839: l_dim_short_name bis_dimensions.short_name%TYPE;

4835: FUNCTION IS_ORG_OR_TIME_LEVEL -- Function added for 2486702
4836: (p_lvl_short_name IN VARCHAR2)
4837: RETURN BOOLEAN IS
4838:
4839: l_dim_short_name bis_dimensions.short_name%TYPE;
4840:
4841: BEGIN
4842:
4843: SELECT D.short_name

Line 4846: BIS_DIMENSIONS D

4842:
4843: SELECT D.short_name
4844: INTO l_dim_short_name
4845: FROM BIS_LEVELS L,
4846: BIS_DIMENSIONS D
4847: WHERE
4848: L.short_name = p_lvl_short_name
4849: AND L.dimension_id = D.dimension_id;
4850: