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_PMF_DEFINER_WRAPPER_PVT dependencies on BISFV_TARGET_LEVELS

Line 1503: FROM bis_indicator_dimensions x, bisfv_target_levels y,

1499: y.dimension4_level_id, y.dimension4_level_short_name, y.dimension4_level_name,
1500: y.dimension5_level_id, y.dimension5_level_short_name, y.dimension5_level_name,
1501: y.dimension6_level_id, y.dimension6_level_short_name, y.dimension6_level_name,
1502: y.dimension7_level_id, y.dimension7_level_short_name, y.dimension7_level_name
1503: FROM bis_indicator_dimensions x, bisfv_target_levels y,
1504: bis_dimensions z
1505: WHERE y.target_level_id=p_target_level_id AND
1506: y.measure_id = x.indicator_id AND
1507: x.dimension_id = z.dimension_id AND

Line 1512: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;

1508: z.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL);
1509: l_sequence_no NUMBER;
1510: l_dim_level_id VARCHAR2(100);
1511: l_dimension1_level_id NUMBER;
1512: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
1513: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
1514: l_dimension2_level_id NUMBER;
1515: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1516: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;

Line 1513: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;

1509: l_sequence_no NUMBER;
1510: l_dim_level_id VARCHAR2(100);
1511: l_dimension1_level_id NUMBER;
1512: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
1513: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
1514: l_dimension2_level_id NUMBER;
1515: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1516: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1517: l_dimension3_level_id NUMBER;

Line 1515: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;

1511: l_dimension1_level_id NUMBER;
1512: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
1513: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
1514: l_dimension2_level_id NUMBER;
1515: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1516: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1517: l_dimension3_level_id NUMBER;
1518: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1519: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;

Line 1516: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;

1512: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
1513: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
1514: l_dimension2_level_id NUMBER;
1515: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1516: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1517: l_dimension3_level_id NUMBER;
1518: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1519: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1520: l_dimension4_level_id NUMBER;

Line 1518: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;

1514: l_dimension2_level_id NUMBER;
1515: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1516: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1517: l_dimension3_level_id NUMBER;
1518: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1519: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1520: l_dimension4_level_id NUMBER;
1521: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1522: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;

Line 1519: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;

1515: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1516: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1517: l_dimension3_level_id NUMBER;
1518: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1519: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1520: l_dimension4_level_id NUMBER;
1521: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1522: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1523: l_dimension5_level_id NUMBER;

Line 1521: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;

1517: l_dimension3_level_id NUMBER;
1518: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1519: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1520: l_dimension4_level_id NUMBER;
1521: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1522: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1523: l_dimension5_level_id NUMBER;
1524: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1525: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;

Line 1522: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;

1518: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1519: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1520: l_dimension4_level_id NUMBER;
1521: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1522: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1523: l_dimension5_level_id NUMBER;
1524: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1525: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1526: l_dimension6_level_id NUMBER;

Line 1524: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;

1520: l_dimension4_level_id NUMBER;
1521: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1522: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1523: l_dimension5_level_id NUMBER;
1524: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1525: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1526: l_dimension6_level_id NUMBER;
1527: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1528: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;

Line 1525: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;

1521: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1522: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1523: l_dimension5_level_id NUMBER;
1524: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1525: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1526: l_dimension6_level_id NUMBER;
1527: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1528: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1529: l_dimension7_level_id NUMBER;

Line 1527: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;

1523: l_dimension5_level_id NUMBER;
1524: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1525: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1526: l_dimension6_level_id NUMBER;
1527: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1528: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1529: l_dimension7_level_id NUMBER;
1530: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1531: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;

Line 1528: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;

1524: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1525: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1526: l_dimension6_level_id NUMBER;
1527: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1528: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1529: l_dimension7_level_id NUMBER;
1530: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1531: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
1532: l_error_Tbl_p BIS_UTILITIES_PUB.ERROR_TBL_TYPE;

Line 1530: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;

1526: l_dimension6_level_id NUMBER;
1527: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1528: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1529: l_dimension7_level_id NUMBER;
1530: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1531: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
1532: l_error_Tbl_p BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
1533:
1534: BEGIN

Line 1531: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;

1527: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1528: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1529: l_dimension7_level_id NUMBER;
1530: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1531: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
1532: l_error_Tbl_p BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
1533:
1534: BEGIN
1535: IF (p_performance_measure_id <> FND_API.G_MISS_NUM AND

Line 1682: FROM bis_indicator_dimensions x, bisfv_target_levels y,

1678: y.dimension4_level_id, y.dimension4_level_short_name, y.dimension4_level_name,
1679: y.dimension5_level_id, y.dimension5_level_short_name, y.dimension5_level_name,
1680: y.dimension6_level_id, y.dimension6_level_short_name, y.dimension6_level_name,
1681: y.dimension7_level_id, y.dimension7_level_short_name, y.dimension7_level_name
1682: FROM bis_indicator_dimensions x, bisfv_target_levels y,
1683: bis_dimensions z
1684: WHERE y.target_level_id=p_target_level_id AND
1685: y.measure_id = x.indicator_id AND
1686: x.dimension_id = z.dimension_id AND

Line 1691: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;

1687: z.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL);
1688: l_sequence_no NUMBER;
1689: l_dim_level_id VARCHAR2(100);
1690: l_dimension1_level_id NUMBER;
1691: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
1692: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
1693: l_dimension2_level_id NUMBER;
1694: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1695: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;

Line 1692: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;

1688: l_sequence_no NUMBER;
1689: l_dim_level_id VARCHAR2(100);
1690: l_dimension1_level_id NUMBER;
1691: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
1692: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
1693: l_dimension2_level_id NUMBER;
1694: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1695: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1696: l_dimension3_level_id NUMBER;

Line 1694: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;

1690: l_dimension1_level_id NUMBER;
1691: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
1692: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
1693: l_dimension2_level_id NUMBER;
1694: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1695: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1696: l_dimension3_level_id NUMBER;
1697: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1698: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;

Line 1695: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;

1691: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
1692: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
1693: l_dimension2_level_id NUMBER;
1694: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1695: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1696: l_dimension3_level_id NUMBER;
1697: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1698: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1699: l_dimension4_level_id NUMBER;

Line 1697: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;

1693: l_dimension2_level_id NUMBER;
1694: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1695: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1696: l_dimension3_level_id NUMBER;
1697: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1698: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1699: l_dimension4_level_id NUMBER;
1700: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1701: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;

Line 1698: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;

1694: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1695: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1696: l_dimension3_level_id NUMBER;
1697: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1698: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1699: l_dimension4_level_id NUMBER;
1700: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1701: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1702: l_dimension5_level_id NUMBER;

Line 1700: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;

1696: l_dimension3_level_id NUMBER;
1697: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1698: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1699: l_dimension4_level_id NUMBER;
1700: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1701: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1702: l_dimension5_level_id NUMBER;
1703: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1704: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;

Line 1701: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;

1697: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1698: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1699: l_dimension4_level_id NUMBER;
1700: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1701: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1702: l_dimension5_level_id NUMBER;
1703: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1704: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1705: l_dimension6_level_id NUMBER;

Line 1703: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;

1699: l_dimension4_level_id NUMBER;
1700: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1701: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1702: l_dimension5_level_id NUMBER;
1703: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1704: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1705: l_dimension6_level_id NUMBER;
1706: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1707: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;

Line 1704: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;

1700: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1701: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1702: l_dimension5_level_id NUMBER;
1703: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1704: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1705: l_dimension6_level_id NUMBER;
1706: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1707: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1708: l_dimension7_level_id NUMBER;

Line 1706: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;

1702: l_dimension5_level_id NUMBER;
1703: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1704: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1705: l_dimension6_level_id NUMBER;
1706: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1707: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1708: l_dimension7_level_id NUMBER;
1709: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1710: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;

Line 1707: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;

1703: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1704: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1705: l_dimension6_level_id NUMBER;
1706: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1707: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1708: l_dimension7_level_id NUMBER;
1709: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1710: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
1711:

Line 1709: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;

1705: l_dimension6_level_id NUMBER;
1706: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1707: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1708: l_dimension7_level_id NUMBER;
1709: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1710: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
1711:
1712: BEGIN
1713: IF (p_performance_measure_id <> FND_API.G_MISS_NUM) THEN

Line 1710: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;

1706: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1707: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1708: l_dimension7_level_id NUMBER;
1709: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1710: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
1711:
1712: BEGIN
1713: IF (p_performance_measure_id <> FND_API.G_MISS_NUM) THEN
1714: OPEN c_perf_dim;

Line 1829: FROM bis_indicator_dimensions x, bisfv_target_levels y,

1825: y.dimension4_level_id, y.dimension4_level_short_name, y.dimension4_level_name,
1826: y.dimension5_level_id, y.dimension5_level_short_name, y.dimension5_level_name,
1827: y.dimension6_level_id, y.dimension6_level_short_name, y.dimension6_level_name,
1828: y.dimension7_level_id, y.dimension7_level_short_name, y.dimension7_level_name
1829: FROM bis_indicator_dimensions x, bisfv_target_levels y,
1830: bis_dimensions z
1831: WHERE y.target_level_id=p_target_level_id AND
1832: y.measure_id = x.indicator_id AND
1833: x.dimension_id = z.dimension_id AND

Line 1838: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;

1834: z.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL);
1835: l_sequence_no NUMBER;
1836: l_dim_level_id VARCHAR2(100);
1837: l_dimension1_level_id NUMBER;
1838: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
1839: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
1840: l_dimension2_level_id NUMBER;
1841: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1842: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;

Line 1839: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;

1835: l_sequence_no NUMBER;
1836: l_dim_level_id VARCHAR2(100);
1837: l_dimension1_level_id NUMBER;
1838: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
1839: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
1840: l_dimension2_level_id NUMBER;
1841: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1842: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1843: l_dimension3_level_id NUMBER;

Line 1841: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;

1837: l_dimension1_level_id NUMBER;
1838: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
1839: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
1840: l_dimension2_level_id NUMBER;
1841: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1842: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1843: l_dimension3_level_id NUMBER;
1844: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1845: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;

Line 1842: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;

1838: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
1839: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
1840: l_dimension2_level_id NUMBER;
1841: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1842: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1843: l_dimension3_level_id NUMBER;
1844: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1845: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1846: l_dimension4_level_id NUMBER;

Line 1844: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;

1840: l_dimension2_level_id NUMBER;
1841: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1842: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1843: l_dimension3_level_id NUMBER;
1844: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1845: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1846: l_dimension4_level_id NUMBER;
1847: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1848: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;

Line 1845: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;

1841: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
1842: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
1843: l_dimension3_level_id NUMBER;
1844: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1845: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1846: l_dimension4_level_id NUMBER;
1847: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1848: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1849: l_dimension5_level_id NUMBER;

Line 1847: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;

1843: l_dimension3_level_id NUMBER;
1844: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1845: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1846: l_dimension4_level_id NUMBER;
1847: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1848: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1849: l_dimension5_level_id NUMBER;
1850: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1851: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;

Line 1848: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;

1844: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
1845: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
1846: l_dimension4_level_id NUMBER;
1847: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1848: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1849: l_dimension5_level_id NUMBER;
1850: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1851: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1852: l_dimension6_level_id NUMBER;

Line 1850: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;

1846: l_dimension4_level_id NUMBER;
1847: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1848: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1849: l_dimension5_level_id NUMBER;
1850: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1851: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1852: l_dimension6_level_id NUMBER;
1853: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1854: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;

Line 1851: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;

1847: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
1848: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
1849: l_dimension5_level_id NUMBER;
1850: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1851: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1852: l_dimension6_level_id NUMBER;
1853: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1854: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1855: l_dimension7_level_id NUMBER;

Line 1853: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;

1849: l_dimension5_level_id NUMBER;
1850: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1851: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1852: l_dimension6_level_id NUMBER;
1853: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1854: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1855: l_dimension7_level_id NUMBER;
1856: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1857: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;

Line 1854: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;

1850: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
1851: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
1852: l_dimension6_level_id NUMBER;
1853: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1854: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1855: l_dimension7_level_id NUMBER;
1856: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1857: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
1858: l_error_Tbl_p BIS_UTILITIES_PUB.ERROR_TBL_TYPE;

Line 1856: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;

1852: l_dimension6_level_id NUMBER;
1853: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1854: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1855: l_dimension7_level_id NUMBER;
1856: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1857: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
1858: l_error_Tbl_p BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
1859:
1860: BEGIN

Line 1857: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;

1853: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
1854: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1855: l_dimension7_level_id NUMBER;
1856: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1857: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
1858: l_error_Tbl_p BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
1859:
1860: BEGIN
1861: IF (p_performance_measure_id <> FND_API.G_MISS_NUM

Line 2010: FROM bis_indicator_dimensions x, bisfv_target_levels y,

2006: y.dimension4_level_id, y.dimension4_level_short_name, y.dimension4_level_name,
2007: y.dimension5_level_id, y.dimension5_level_short_name, y.dimension5_level_name,
2008: y.dimension6_level_id, y.dimension6_level_short_name, y.dimension6_level_name,
2009: y.dimension7_level_id, y.dimension7_level_short_name, y.dimension7_level_name
2010: FROM bis_indicator_dimensions x, bisfv_target_levels y,
2011: bis_dimensions z
2012: WHERE y.target_level_id=p_target_level_id AND
2013: y.measure_id = x.indicator_id AND
2014: x.dimension_id = z.dimension_id AND

Line 2019: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;

2015: z.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL);
2016: l_sequence_no NUMBER;
2017: l_dim_level_id VARCHAR2(100);
2018: l_dimension1_level_id NUMBER;
2019: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
2020: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
2021: l_dimension2_level_id NUMBER;
2022: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
2023: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;

Line 2020: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;

2016: l_sequence_no NUMBER;
2017: l_dim_level_id VARCHAR2(100);
2018: l_dimension1_level_id NUMBER;
2019: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
2020: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
2021: l_dimension2_level_id NUMBER;
2022: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
2023: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
2024: l_dimension3_level_id NUMBER;

Line 2022: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;

2018: l_dimension1_level_id NUMBER;
2019: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
2020: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
2021: l_dimension2_level_id NUMBER;
2022: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
2023: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
2024: l_dimension3_level_id NUMBER;
2025: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
2026: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;

Line 2023: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;

2019: l_dimension1_level_short_name BISFV_TARGET_LEVELS.dimension1_level_short_name%TYPE;
2020: l_dimension1_level_name BISFV_TARGET_LEVELS.dimension1_level_name%TYPE;
2021: l_dimension2_level_id NUMBER;
2022: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
2023: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
2024: l_dimension3_level_id NUMBER;
2025: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
2026: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
2027: l_dimension4_level_id NUMBER;

Line 2025: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;

2021: l_dimension2_level_id NUMBER;
2022: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
2023: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
2024: l_dimension3_level_id NUMBER;
2025: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
2026: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
2027: l_dimension4_level_id NUMBER;
2028: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
2029: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;

Line 2026: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;

2022: l_dimension2_level_short_name BISFV_TARGET_LEVELS.dimension2_level_short_name%TYPE;
2023: l_dimension2_level_name BISFV_TARGET_LEVELS.dimension2_level_name%TYPE;
2024: l_dimension3_level_id NUMBER;
2025: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
2026: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
2027: l_dimension4_level_id NUMBER;
2028: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
2029: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
2030: l_dimension5_level_id NUMBER;

Line 2028: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;

2024: l_dimension3_level_id NUMBER;
2025: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
2026: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
2027: l_dimension4_level_id NUMBER;
2028: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
2029: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
2030: l_dimension5_level_id NUMBER;
2031: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
2032: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;

Line 2029: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;

2025: l_dimension3_level_short_name BISFV_TARGET_LEVELS.dimension3_level_short_name%TYPE;
2026: l_dimension3_level_name BISFV_TARGET_LEVELS.dimension3_level_name%TYPE;
2027: l_dimension4_level_id NUMBER;
2028: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
2029: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
2030: l_dimension5_level_id NUMBER;
2031: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
2032: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
2033: l_dimension6_level_id NUMBER;

Line 2031: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;

2027: l_dimension4_level_id NUMBER;
2028: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
2029: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
2030: l_dimension5_level_id NUMBER;
2031: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
2032: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
2033: l_dimension6_level_id NUMBER;
2034: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
2035: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;

Line 2032: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;

2028: l_dimension4_level_short_name BISFV_TARGET_LEVELS.dimension4_level_short_name%TYPE;
2029: l_dimension4_level_name BISFV_TARGET_LEVELS.dimension4_level_name%TYPE;
2030: l_dimension5_level_id NUMBER;
2031: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
2032: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
2033: l_dimension6_level_id NUMBER;
2034: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
2035: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
2036: l_dimension7_level_id NUMBER;

Line 2034: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;

2030: l_dimension5_level_id NUMBER;
2031: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
2032: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
2033: l_dimension6_level_id NUMBER;
2034: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
2035: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
2036: l_dimension7_level_id NUMBER;
2037: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
2038: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;

Line 2035: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;

2031: l_dimension5_level_short_name BISFV_TARGET_LEVELS.dimension5_level_short_name%TYPE;
2032: l_dimension5_level_name BISFV_TARGET_LEVELS.dimension5_level_name%TYPE;
2033: l_dimension6_level_id NUMBER;
2034: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
2035: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
2036: l_dimension7_level_id NUMBER;
2037: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
2038: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
2039:

Line 2037: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;

2033: l_dimension6_level_id NUMBER;
2034: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
2035: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
2036: l_dimension7_level_id NUMBER;
2037: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
2038: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
2039:
2040: BEGIN
2041: IF (p_performance_measure_id <> FND_API.G_MISS_NUM) THEN

Line 2038: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;

2034: l_dimension6_level_short_name BISFV_TARGET_LEVELS.dimension6_level_short_name%TYPE;
2035: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
2036: l_dimension7_level_id NUMBER;
2037: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
2038: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
2039:
2040: BEGIN
2041: IF (p_performance_measure_id <> FND_API.G_MISS_NUM) THEN
2042: OPEN c_perf_dim;

Line 2978: select target_level_id from bisfv_target_levels where measure_id = p_measure_id

2974: l_dummy NUMBER;
2975: l_has_auth NUMBER;
2976:
2977: cursor cr_tar_auth is
2978: select target_level_id from bisfv_target_levels where measure_id = p_measure_id
2979: and target_level_id in (select distinct ir.target_level_id from bis_indicator_resps ir
2980: , fnd_user_resp_groups ur
2981: , bisbv_target_levels il
2982: where ur.user_id = p_user_id