APPS.BIS_TARGET_LEVEL_PVT dependencies on BIS_LEVELS

Line 41: TYPE lvl_tbl_type IS TABLE OF bis_levels.short_name%TYPE -- Defn added for 2486702

37: */
38: --
39: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_TARGET_LEVEL_PVT';
40:
41: TYPE lvl_tbl_type IS TABLE OF bis_levels.short_name%TYPE -- Defn added for 2486702
42: INDEX BY BINARY_INTEGER;
43:
44: TYPE dim_tbl_type IS TABLE OF NUMBER -- Defn added for 2486702
45: INDEX BY BINARY_INTEGER;

Line 3770: FROM bis_levels_vl

3766: l_dim7_level_name VARCHAR2(32000);
3767:
3768: CURSOR c_dim_lvl(p_dim_level_short_name in varchar2) IS
3769: SELECT level_id , name
3770: FROM bis_levels_vl
3771: WHERE short_name=p_dim_level_short_name;
3772:
3773: BEGIN
3774:

Line 4298: l_level_short_nm bis_levels.short_name%TYPE;

4294: l_measure_rec BIS_MEASURE_PUB.MEASURE_REC_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

Line 4457: l_lvl_short_name bis_levels.short_name%TYPE := NULL;

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;
4461: -- l_error_msg VARCHAR2(1000);

Line 4569: FROM bis_levels

4565: BEGIN
4566:
4567: SELECT dimension_id
4568: INTO l_dim_id
4569: FROM bis_levels
4570: WHERE short_name = p_level_shtnm;
4571:
4572: RETURN l_dim_id;
4573:

Line 4845: FROM BIS_LEVELS L,

4841: BEGIN
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;