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 BIS_UTILITIES_PVT

Line 1487: y.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source);

1483: SELECT x.sequence_no
1484: FROM bis_indicator_dimensions x, bis_dimensions y
1485: WHERE x.indicator_id = p_performance_measure_id AND
1486: y.dimension_id = x.dimension_id AND
1487: y.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source);
1488: CURSOR c_perf_dim IS
1489: SELECT x.sequence_no
1490: FROM bis_indicator_dimensions x, bis_dimensions y
1491: WHERE x.indicator_id = p_performance_measure_id AND

Line 1493: y.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL);

1489: SELECT x.sequence_no
1490: FROM bis_indicator_dimensions x, bis_dimensions y
1491: WHERE x.indicator_id = p_performance_measure_id AND
1492: y.dimension_id = x.dimension_id AND
1493: y.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL);
1494: CURSOR c_dim IS
1495: SELECT x.sequence_no ,
1496: y.dimension1_level_id, y.dimension1_level_short_name, y.dimension1_level_name,
1497: y.dimension2_level_id, y.dimension2_level_short_name, y.dimension2_level_name,

Line 1508: z.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL);

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
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;

Line 1610: BIS_UTILITIES_PVT.Add_Error_Message

1606: CLOSE c_dim;
1607: END IF;
1608: x_return_status := FND_API.G_RET_STS_ERROR;
1609: l_error_Tbl_p := x_error_Tbl;
1610: BIS_UTILITIES_PVT.Add_Error_Message
1611: ( p_error_table => l_error_Tbl_p
1612: , p_error_msg_id => SQLCODE
1613: , p_error_description => SQLERRM
1614: , x_error_table => x_error_Tbl

Line 1628: BIS_UTILITIES_PVT.Add_Error_Message

1624: CLOSE c_dim;
1625: END IF;
1626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1627: l_error_Tbl_p := x_error_Tbl;
1628: BIS_UTILITIES_PVT.Add_Error_Message
1629: ( p_error_table => l_error_Tbl_p
1630: , p_error_msg_id => SQLCODE
1631: , p_error_description => SQLERRM
1632: , x_error_table => x_error_Tbl

Line 1646: BIS_UTILITIES_PVT.Add_Error_Message

1642: CLOSE c_dim;
1643: END IF;
1644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1645: l_error_Tbl_p := x_error_Tbl;
1646: BIS_UTILITIES_PVT.Add_Error_Message
1647: ( p_error_table => l_error_Tbl_p
1648: , p_error_msg_id => SQLCODE
1649: , p_error_description => SQLERRM
1650: , x_error_table => x_error_Tbl

Line 1672: y.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL);

1668: SELECT x.sequence_no
1669: FROM bis_indicator_dimensions x, bis_dimensions y
1670: WHERE x.indicator_id = p_performance_measure_id AND
1671: y.dimension_id = x.dimension_id AND
1672: y.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL);
1673: CURSOR c_dim IS
1674: SELECT x.sequence_no ,
1675: y.dimension1_level_id, y.dimension1_level_short_name, y.dimension1_level_name,
1676: y.dimension2_level_id, y.dimension2_level_short_name, y.dimension2_level_name,

Line 1687: z.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL);

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
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;

Line 1813: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_SRC(p_source);

1809: SELECT x.sequence_no
1810: FROM bis_indicator_dimensions x, bis_dimensions y
1811: WHERE x.indicator_id = p_performance_measure_id AND
1812: y.dimension_id = x.dimension_id AND
1813: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_SRC(p_source);
1814: CURSOR c_perf_dim IS
1815: SELECT x.sequence_no
1816: FROM bis_indicator_dimensions x, bis_dimensions y
1817: WHERE x.indicator_id = p_performance_measure_id AND

Line 1819: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL);

1815: SELECT x.sequence_no
1816: FROM bis_indicator_dimensions x, bis_dimensions y
1817: WHERE x.indicator_id = p_performance_measure_id AND
1818: y.dimension_id = x.dimension_id AND
1819: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL);
1820: CURSOR c_dim IS
1821: SELECT x.sequence_no ,
1822: y.dimension1_level_id, y.dimension1_level_short_name, y.dimension1_level_name,
1823: y.dimension2_level_id, y.dimension2_level_short_name, y.dimension2_level_name,

Line 1834: z.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL);

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
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;

Line 1936: BIS_UTILITIES_PVT.Add_Error_Message

1932: CLOSE c_dim;
1933: END IF;
1934: x_return_status := FND_API.G_RET_STS_ERROR;
1935: l_error_Tbl_p := x_error_Tbl;
1936: BIS_UTILITIES_PVT.Add_Error_Message
1937: ( p_error_table => l_error_Tbl_p
1938: , p_error_msg_id => SQLCODE
1939: , p_error_description => SQLERRM
1940: , x_error_table => x_error_Tbl

Line 1954: BIS_UTILITIES_PVT.Add_Error_Message

1950: CLOSE c_dim;
1951: END IF;
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: l_error_Tbl_p := x_error_Tbl;
1954: BIS_UTILITIES_PVT.Add_Error_Message
1955: ( p_error_table => l_error_Tbl_p
1956: , p_error_msg_id => SQLCODE
1957: , p_error_description => SQLERRM
1958: , x_error_table => x_error_Tbl

Line 1972: BIS_UTILITIES_PVT.Add_Error_Message

1968: CLOSE c_dim;
1969: END IF;
1970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1971: l_error_Tbl_p := x_error_Tbl;
1972: BIS_UTILITIES_PVT.Add_Error_Message
1973: ( p_error_table => l_error_Tbl_p
1974: , p_error_msg_id => SQLCODE
1975: , p_error_description => SQLERRM
1976: , x_error_table => x_error_Tbl

Line 2000: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL);

1996: SELECT x.sequence_no
1997: FROM bis_indicator_dimensions x, bis_dimensions y
1998: WHERE x.indicator_id = p_performance_measure_id AND
1999: y.dimension_id = x.dimension_id AND
2000: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL);
2001: CURSOR c_dim IS
2002: SELECT x.sequence_no ,
2003: y.dimension1_level_id, y.dimension1_level_short_name, y.dimension1_level_name,
2004: y.dimension2_level_id, y.dimension2_level_short_name, y.dimension2_level_name,

Line 2015: z.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL);

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
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;

Line 2595: l_measure_security_rec.target_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.target_level_id);

2591: --Check if the user has access to set the target . IF not throw him/her/it back to the
2592: --Reports Page
2593: l_dlc_sec := 'N';
2594: FOR c_rec IN c_resp LOOP
2595: l_measure_security_rec.target_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.target_level_id);
2596: l_measure_security_rec.responsibility_id := c_rec.responsibility_id;
2597: /* This does not seem to work.
2598: BIS_MEASURE_SECURITY_PUB.VALIDATE_MEASURE_SECURITY
2599: (p_api_version => 1.0

Line 2622: x_measure_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_Rec.measure_name);

2618: FND_MESSAGE.SET_NAME('BIS', 'BIS_NO_SECURITY_ACCESS');
2619: FND_MSG_PUB.ADD;
2620: RAISE FND_API.G_EXC_ERROR;
2621: END IF;
2622: x_measure_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_Rec.measure_name);
2623: x_measure_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.measure_id);
2624: x_target_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.target_level_id);
2625: x_dim1_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_name);
2626: x_dim2_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_name);

Line 2623: x_measure_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.measure_id);

2619: FND_MSG_PUB.ADD;
2620: RAISE FND_API.G_EXC_ERROR;
2621: END IF;
2622: x_measure_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_Rec.measure_name);
2623: x_measure_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.measure_id);
2624: x_target_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.target_level_id);
2625: x_dim1_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_name);
2626: x_dim2_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_name);
2627: x_dim3_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_name);

Line 2624: x_target_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.target_level_id);

2620: RAISE FND_API.G_EXC_ERROR;
2621: END IF;
2622: x_measure_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_Rec.measure_name);
2623: x_measure_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.measure_id);
2624: x_target_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.target_level_id);
2625: x_dim1_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_name);
2626: x_dim2_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_name);
2627: x_dim3_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_name);
2628: x_dim4_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_name);

Line 2625: x_dim1_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_name);

2621: END IF;
2622: x_measure_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_Rec.measure_name);
2623: x_measure_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.measure_id);
2624: x_target_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.target_level_id);
2625: x_dim1_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_name);
2626: x_dim2_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_name);
2627: x_dim3_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_name);
2628: x_dim4_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_name);
2629: x_dim5_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_name);

Line 2626: x_dim2_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_name);

2622: x_measure_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_Rec.measure_name);
2623: x_measure_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.measure_id);
2624: x_target_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.target_level_id);
2625: x_dim1_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_name);
2626: x_dim2_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_name);
2627: x_dim3_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_name);
2628: x_dim4_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_name);
2629: x_dim5_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_name);
2630: x_dim6_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_name);

Line 2627: x_dim3_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_name);

2623: x_measure_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.measure_id);
2624: x_target_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.target_level_id);
2625: x_dim1_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_name);
2626: x_dim2_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_name);
2627: x_dim3_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_name);
2628: x_dim4_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_name);
2629: x_dim5_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_name);
2630: x_dim6_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_name);
2631: x_dim7_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_name);

Line 2628: x_dim4_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_name);

2624: x_target_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.target_level_id);
2625: x_dim1_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_name);
2626: x_dim2_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_name);
2627: x_dim3_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_name);
2628: x_dim4_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_name);
2629: x_dim5_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_name);
2630: x_dim6_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_name);
2631: x_dim7_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_name);
2632: x_dim1_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension1_level_id);

Line 2629: x_dim5_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_name);

2625: x_dim1_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_name);
2626: x_dim2_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_name);
2627: x_dim3_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_name);
2628: x_dim4_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_name);
2629: x_dim5_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_name);
2630: x_dim6_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_name);
2631: x_dim7_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_name);
2632: x_dim1_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension1_level_id);
2633: x_dim2_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension2_level_id);

Line 2630: x_dim6_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_name);

2626: x_dim2_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_name);
2627: x_dim3_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_name);
2628: x_dim4_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_name);
2629: x_dim5_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_name);
2630: x_dim6_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_name);
2631: x_dim7_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_name);
2632: x_dim1_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension1_level_id);
2633: x_dim2_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension2_level_id);
2634: x_dim3_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension3_level_id);

Line 2631: x_dim7_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_name);

2627: x_dim3_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_name);
2628: x_dim4_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_name);
2629: x_dim5_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_name);
2630: x_dim6_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_name);
2631: x_dim7_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_name);
2632: x_dim1_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension1_level_id);
2633: x_dim2_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension2_level_id);
2634: x_dim3_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension3_level_id);
2635: x_dim4_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension4_level_id);

Line 2632: x_dim1_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension1_level_id);

2628: x_dim4_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_name);
2629: x_dim5_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_name);
2630: x_dim6_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_name);
2631: x_dim7_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_name);
2632: x_dim1_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension1_level_id);
2633: x_dim2_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension2_level_id);
2634: x_dim3_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension3_level_id);
2635: x_dim4_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension4_level_id);
2636: x_dim5_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension5_level_id);

Line 2633: x_dim2_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension2_level_id);

2629: x_dim5_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_name);
2630: x_dim6_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_name);
2631: x_dim7_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_name);
2632: x_dim1_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension1_level_id);
2633: x_dim2_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension2_level_id);
2634: x_dim3_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension3_level_id);
2635: x_dim4_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension4_level_id);
2636: x_dim5_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension5_level_id);
2637: x_dim6_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension6_level_id);

Line 2634: x_dim3_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension3_level_id);

2630: x_dim6_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_name);
2631: x_dim7_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_name);
2632: x_dim1_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension1_level_id);
2633: x_dim2_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension2_level_id);
2634: x_dim3_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension3_level_id);
2635: x_dim4_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension4_level_id);
2636: x_dim5_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension5_level_id);
2637: x_dim6_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension6_level_id);
2638: x_dim7_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension7_level_id);

Line 2635: x_dim4_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension4_level_id);

2631: x_dim7_level_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_name);
2632: x_dim1_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension1_level_id);
2633: x_dim2_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension2_level_id);
2634: x_dim3_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension3_level_id);
2635: x_dim4_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension4_level_id);
2636: x_dim5_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension5_level_id);
2637: x_dim6_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension6_level_id);
2638: x_dim7_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension7_level_id);
2639: x_dim1_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_name);

Line 2636: x_dim5_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension5_level_id);

2632: x_dim1_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension1_level_id);
2633: x_dim2_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension2_level_id);
2634: x_dim3_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension3_level_id);
2635: x_dim4_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension4_level_id);
2636: x_dim5_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension5_level_id);
2637: x_dim6_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension6_level_id);
2638: x_dim7_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension7_level_id);
2639: x_dim1_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_name);
2640: x_dim2_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_name);

Line 2637: x_dim6_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension6_level_id);

2633: x_dim2_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension2_level_id);
2634: x_dim3_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension3_level_id);
2635: x_dim4_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension4_level_id);
2636: x_dim5_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension5_level_id);
2637: x_dim6_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension6_level_id);
2638: x_dim7_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension7_level_id);
2639: x_dim1_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_name);
2640: x_dim2_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_name);
2641: x_dim3_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_name);

Line 2638: x_dim7_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension7_level_id);

2634: x_dim3_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension3_level_id);
2635: x_dim4_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension4_level_id);
2636: x_dim5_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension5_level_id);
2637: x_dim6_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension6_level_id);
2638: x_dim7_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension7_level_id);
2639: x_dim1_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_name);
2640: x_dim2_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_name);
2641: x_dim3_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_name);
2642: x_dim4_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_name);

Line 2639: x_dim1_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_name);

2635: x_dim4_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension4_level_id);
2636: x_dim5_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension5_level_id);
2637: x_dim6_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension6_level_id);
2638: x_dim7_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension7_level_id);
2639: x_dim1_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_name);
2640: x_dim2_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_name);
2641: x_dim3_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_name);
2642: x_dim4_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_name);
2643: x_dim5_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_name);

Line 2640: x_dim2_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_name);

2636: x_dim5_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension5_level_id);
2637: x_dim6_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension6_level_id);
2638: x_dim7_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension7_level_id);
2639: x_dim1_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_name);
2640: x_dim2_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_name);
2641: x_dim3_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_name);
2642: x_dim4_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_name);
2643: x_dim5_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_name);
2644: x_dim6_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_name);

Line 2641: x_dim3_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_name);

2637: x_dim6_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension6_level_id);
2638: x_dim7_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension7_level_id);
2639: x_dim1_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_name);
2640: x_dim2_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_name);
2641: x_dim3_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_name);
2642: x_dim4_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_name);
2643: x_dim5_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_name);
2644: x_dim6_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_name);
2645: x_dim7_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_name);

Line 2642: x_dim4_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_name);

2638: x_dim7_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.dimension7_level_id);
2639: x_dim1_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_name);
2640: x_dim2_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_name);
2641: x_dim3_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_name);
2642: x_dim4_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_name);
2643: x_dim5_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_name);
2644: x_dim6_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_name);
2645: x_dim7_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_name);
2646: x_dim1_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_short_name);

Line 2643: x_dim5_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_name);

2639: x_dim1_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_name);
2640: x_dim2_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_name);
2641: x_dim3_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_name);
2642: x_dim4_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_name);
2643: x_dim5_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_name);
2644: x_dim6_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_name);
2645: x_dim7_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_name);
2646: x_dim1_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_short_name);
2647: x_dim2_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_short_name);

Line 2644: x_dim6_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_name);

2640: x_dim2_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_name);
2641: x_dim3_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_name);
2642: x_dim4_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_name);
2643: x_dim5_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_name);
2644: x_dim6_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_name);
2645: x_dim7_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_name);
2646: x_dim1_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_short_name);
2647: x_dim2_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_short_name);
2648: x_dim3_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_short_name);

Line 2645: x_dim7_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_name);

2641: x_dim3_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_name);
2642: x_dim4_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_name);
2643: x_dim5_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_name);
2644: x_dim6_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_name);
2645: x_dim7_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_name);
2646: x_dim1_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_short_name);
2647: x_dim2_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_short_name);
2648: x_dim3_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_short_name);
2649: x_dim4_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_short_name);

Line 2646: x_dim1_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_short_name);

2642: x_dim4_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_name);
2643: x_dim5_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_name);
2644: x_dim6_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_name);
2645: x_dim7_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_name);
2646: x_dim1_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_short_name);
2647: x_dim2_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_short_name);
2648: x_dim3_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_short_name);
2649: x_dim4_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_short_name);
2650: x_dim5_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_short_name);

Line 2647: x_dim2_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_short_name);

2643: x_dim5_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_name);
2644: x_dim6_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_name);
2645: x_dim7_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_name);
2646: x_dim1_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_short_name);
2647: x_dim2_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_short_name);
2648: x_dim3_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_short_name);
2649: x_dim4_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_short_name);
2650: x_dim5_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_short_name);
2651: x_dim6_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_short_name);

Line 2648: x_dim3_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_short_name);

2644: x_dim6_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_name);
2645: x_dim7_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_name);
2646: x_dim1_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_short_name);
2647: x_dim2_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_short_name);
2648: x_dim3_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_short_name);
2649: x_dim4_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_short_name);
2650: x_dim5_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_short_name);
2651: x_dim6_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_short_name);
2652: x_dim7_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_short_name);

Line 2649: x_dim4_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_short_name);

2645: x_dim7_level_value_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_name);
2646: x_dim1_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_short_name);
2647: x_dim2_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_short_name);
2648: x_dim3_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_short_name);
2649: x_dim4_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_short_name);
2650: x_dim5_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_short_name);
2651: x_dim6_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_short_name);
2652: x_dim7_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_short_name);
2653: x_target_value := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target);

Line 2650: x_dim5_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_short_name);

2646: x_dim1_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension1_level_short_name);
2647: x_dim2_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_short_name);
2648: x_dim3_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_short_name);
2649: x_dim4_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_short_name);
2650: x_dim5_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_short_name);
2651: x_dim6_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_short_name);
2652: x_dim7_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_short_name);
2653: x_target_value := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target);
2654: x_target_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target_id);

Line 2651: x_dim6_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_short_name);

2647: x_dim2_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension2_level_short_name);
2648: x_dim3_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_short_name);
2649: x_dim4_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_short_name);
2650: x_dim5_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_short_name);
2651: x_dim6_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_short_name);
2652: x_dim7_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_short_name);
2653: x_target_value := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target);
2654: x_target_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target_id);
2655: --x_target_id := l_target_rec.target_id;

Line 2652: x_dim7_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_short_name);

2648: x_dim3_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension3_level_short_name);
2649: x_dim4_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_short_name);
2650: x_dim5_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_short_name);
2651: x_dim6_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_short_name);
2652: x_dim7_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_short_name);
2653: x_target_value := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target);
2654: x_target_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target_id);
2655: --x_target_id := l_target_rec.target_id;
2656: --added this for UOM

Line 2653: x_target_value := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target);

2649: x_dim4_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension4_level_short_name);
2650: x_dim5_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_short_name);
2651: x_dim6_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_short_name);
2652: x_dim7_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_short_name);
2653: x_target_value := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target);
2654: x_target_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target_id);
2655: --x_target_id := l_target_rec.target_id;
2656: --added this for UOM
2657: x_unit_of_measure := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.Unit_of_Measure);

Line 2654: x_target_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target_id);

2650: x_dim5_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension5_level_short_name);
2651: x_dim6_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension6_level_short_name);
2652: x_dim7_level_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.dimension7_level_short_name);
2653: x_target_value := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target);
2654: x_target_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target_id);
2655: --x_target_id := l_target_rec.target_id;
2656: --added this for UOM
2657: x_unit_of_measure := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.Unit_of_Measure);
2658: IF (x_target_id = 0) THEN

Line 2657: x_unit_of_measure := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.Unit_of_Measure);

2653: x_target_value := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target);
2654: x_target_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.target_id);
2655: --x_target_id := l_target_rec.target_id;
2656: --added this for UOM
2657: x_unit_of_measure := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.Unit_of_Measure);
2658: IF (x_target_id = 0) THEN
2659: x_target_id := null;
2660: END IF;
2661: x_range1_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_low);

Line 2661: x_range1_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_low);

2657: x_unit_of_measure := BIS_UTILITIES_PVT.checkmisschar(l_target_level_rec.Unit_of_Measure);
2658: IF (x_target_id = 0) THEN
2659: x_target_id := null;
2660: END IF;
2661: x_range1_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_low);
2662: x_range2_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_low);
2663: x_range3_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_low);
2664: x_range1_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_high);
2665: x_range2_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_high);

Line 2662: x_range2_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_low);

2658: IF (x_target_id = 0) THEN
2659: x_target_id := null;
2660: END IF;
2661: x_range1_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_low);
2662: x_range2_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_low);
2663: x_range3_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_low);
2664: x_range1_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_high);
2665: x_range2_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_high);
2666: x_range3_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_high);

Line 2663: x_range3_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_low);

2659: x_target_id := null;
2660: END IF;
2661: x_range1_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_low);
2662: x_range2_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_low);
2663: x_range3_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_low);
2664: x_range1_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_high);
2665: x_range2_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_high);
2666: x_range3_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_high);
2667: x_plan_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.plan_name);

Line 2664: x_range1_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_high);

2660: END IF;
2661: x_range1_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_low);
2662: x_range2_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_low);
2663: x_range3_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_low);
2664: x_range1_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_high);
2665: x_range2_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_high);
2666: x_range3_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_high);
2667: x_plan_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.plan_name);
2668: x_notify_resp1_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp1_id);

Line 2665: x_range2_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_high);

2661: x_range1_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_low);
2662: x_range2_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_low);
2663: x_range3_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_low);
2664: x_range1_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_high);
2665: x_range2_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_high);
2666: x_range3_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_high);
2667: x_plan_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.plan_name);
2668: x_notify_resp1_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp1_id);
2669: x_notify_resp2_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp2_id);

Line 2666: x_range3_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_high);

2662: x_range2_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_low);
2663: x_range3_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_low);
2664: x_range1_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_high);
2665: x_range2_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_high);
2666: x_range3_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_high);
2667: x_plan_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.plan_name);
2668: x_notify_resp1_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp1_id);
2669: x_notify_resp2_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp2_id);
2670: x_notify_resp3_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp3_id);

Line 2667: x_plan_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.plan_name);

2663: x_range3_low := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_low);
2664: x_range1_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_high);
2665: x_range2_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_high);
2666: x_range3_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_high);
2667: x_plan_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.plan_name);
2668: x_notify_resp1_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp1_id);
2669: x_notify_resp2_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp2_id);
2670: x_notify_resp3_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp3_id);
2671: x_notify_resp1_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_short_name);

Line 2668: x_notify_resp1_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp1_id);

2664: x_range1_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range1_high);
2665: x_range2_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_high);
2666: x_range3_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_high);
2667: x_plan_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.plan_name);
2668: x_notify_resp1_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp1_id);
2669: x_notify_resp2_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp2_id);
2670: x_notify_resp3_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp3_id);
2671: x_notify_resp1_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_short_name);
2672: x_notify_resp2_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_short_name);

Line 2669: x_notify_resp2_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp2_id);

2665: x_range2_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range2_high);
2666: x_range3_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_high);
2667: x_plan_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.plan_name);
2668: x_notify_resp1_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp1_id);
2669: x_notify_resp2_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp2_id);
2670: x_notify_resp3_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp3_id);
2671: x_notify_resp1_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_short_name);
2672: x_notify_resp2_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_short_name);
2673: x_notify_resp3_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_short_name);

Line 2670: x_notify_resp3_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp3_id);

2666: x_range3_high := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.range3_high);
2667: x_plan_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.plan_name);
2668: x_notify_resp1_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp1_id);
2669: x_notify_resp2_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp2_id);
2670: x_notify_resp3_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp3_id);
2671: x_notify_resp1_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_short_name);
2672: x_notify_resp2_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_short_name);
2673: x_notify_resp3_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_short_name);
2674: x_notify_resp1_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_name);

Line 2671: x_notify_resp1_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_short_name);

2667: x_plan_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.plan_name);
2668: x_notify_resp1_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp1_id);
2669: x_notify_resp2_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp2_id);
2670: x_notify_resp3_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp3_id);
2671: x_notify_resp1_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_short_name);
2672: x_notify_resp2_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_short_name);
2673: x_notify_resp3_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_short_name);
2674: x_notify_resp1_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_name);
2675: x_notify_resp2_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_name);

Line 2672: x_notify_resp2_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_short_name);

2668: x_notify_resp1_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp1_id);
2669: x_notify_resp2_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp2_id);
2670: x_notify_resp3_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp3_id);
2671: x_notify_resp1_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_short_name);
2672: x_notify_resp2_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_short_name);
2673: x_notify_resp3_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_short_name);
2674: x_notify_resp1_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_name);
2675: x_notify_resp2_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_name);
2676: x_notify_resp3_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_name);

Line 2673: x_notify_resp3_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_short_name);

2669: x_notify_resp2_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp2_id);
2670: x_notify_resp3_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp3_id);
2671: x_notify_resp1_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_short_name);
2672: x_notify_resp2_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_short_name);
2673: x_notify_resp3_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_short_name);
2674: x_notify_resp1_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_name);
2675: x_notify_resp2_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_name);
2676: x_notify_resp3_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_name);
2677:

Line 2674: x_notify_resp1_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_name);

2670: x_notify_resp3_id := BIS_UTILITIES_PVT.checkmissnum(l_target_rec.notify_resp3_id);
2671: x_notify_resp1_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_short_name);
2672: x_notify_resp2_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_short_name);
2673: x_notify_resp3_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_short_name);
2674: x_notify_resp1_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_name);
2675: x_notify_resp2_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_name);
2676: x_notify_resp3_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_name);
2677:
2678: x_dim1_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_id);

Line 2675: x_notify_resp2_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_name);

2671: x_notify_resp1_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_short_name);
2672: x_notify_resp2_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_short_name);
2673: x_notify_resp3_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_short_name);
2674: x_notify_resp1_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_name);
2675: x_notify_resp2_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_name);
2676: x_notify_resp3_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_name);
2677:
2678: x_dim1_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_id);
2679: x_dim2_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_id);

Line 2676: x_notify_resp3_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_name);

2672: x_notify_resp2_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_short_name);
2673: x_notify_resp3_short_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_short_name);
2674: x_notify_resp1_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_name);
2675: x_notify_resp2_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_name);
2676: x_notify_resp3_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_name);
2677:
2678: x_dim1_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_id);
2679: x_dim2_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_id);
2680: x_dim3_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_id);

Line 2678: x_dim1_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_id);

2674: x_notify_resp1_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp1_name);
2675: x_notify_resp2_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_name);
2676: x_notify_resp3_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_name);
2677:
2678: x_dim1_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_id);
2679: x_dim2_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_id);
2680: x_dim3_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_id);
2681: x_dim4_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_id);
2682: x_dim5_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_id);

Line 2679: x_dim2_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_id);

2675: x_notify_resp2_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp2_name);
2676: x_notify_resp3_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_name);
2677:
2678: x_dim1_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_id);
2679: x_dim2_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_id);
2680: x_dim3_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_id);
2681: x_dim4_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_id);
2682: x_dim5_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_id);
2683: x_dim6_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_id);

Line 2680: x_dim3_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_id);

2676: x_notify_resp3_name := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.notify_resp3_name);
2677:
2678: x_dim1_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_id);
2679: x_dim2_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_id);
2680: x_dim3_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_id);
2681: x_dim4_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_id);
2682: x_dim5_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_id);
2683: x_dim6_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_id);
2684: x_dim7_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_id);

Line 2681: x_dim4_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_id);

2677:
2678: x_dim1_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_id);
2679: x_dim2_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_id);
2680: x_dim3_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_id);
2681: x_dim4_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_id);
2682: x_dim5_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_id);
2683: x_dim6_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_id);
2684: x_dim7_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_id);
2685: BEGIN

Line 2682: x_dim5_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_id);

2678: x_dim1_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim1_level_value_id);
2679: x_dim2_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_id);
2680: x_dim3_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_id);
2681: x_dim4_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_id);
2682: x_dim5_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_id);
2683: x_dim6_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_id);
2684: x_dim7_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_id);
2685: BEGIN
2686: SELECT name INTO x_plan_name

Line 2683: x_dim6_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_id);

2679: x_dim2_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim2_level_value_id);
2680: x_dim3_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_id);
2681: x_dim4_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_id);
2682: x_dim5_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_id);
2683: x_dim6_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_id);
2684: x_dim7_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_id);
2685: BEGIN
2686: SELECT name INTO x_plan_name
2687: FROM BIS_BUSINESS_PLANS_VL

Line 2684: x_dim7_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_id);

2680: x_dim3_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim3_level_value_id);
2681: x_dim4_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim4_level_value_id);
2682: x_dim5_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim5_level_value_id);
2683: x_dim6_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim6_level_value_id);
2684: x_dim7_level_value_id := BIS_UTILITIES_PVT.checkmisschar(l_target_rec.dim7_level_value_id);
2685: BEGIN
2686: SELECT name INTO x_plan_name
2687: FROM BIS_BUSINESS_PLANS_VL
2688: WHERE PLAN_ID=p_plan_id;

Line 2693: l_parameter_set_rec.performance_measure_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.measure_id);

2689: END;
2690: --Check if the alert is already scheduled . This will be used to determine whether to show the
2691: -- Alert button
2692: l_parameter_set_Rec.registration_id:=null;
2693: l_parameter_set_rec.performance_measure_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.measure_id);
2694: l_parameter_Set_rec.target_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_Rec.target_level_id);
2695: l_parameter_set_rec.plan_id := p_plan_id;
2696: l_parameter_set_rec.parameter1_value := p_dim1_level_value_id;
2697: l_parameter_set_rec.parameter2_value := p_dim2_level_value_id;

Line 2694: l_parameter_Set_rec.target_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_Rec.target_level_id);

2690: --Check if the alert is already scheduled . This will be used to determine whether to show the
2691: -- Alert button
2692: l_parameter_set_Rec.registration_id:=null;
2693: l_parameter_set_rec.performance_measure_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.measure_id);
2694: l_parameter_Set_rec.target_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_Rec.target_level_id);
2695: l_parameter_set_rec.plan_id := p_plan_id;
2696: l_parameter_set_rec.parameter1_value := p_dim1_level_value_id;
2697: l_parameter_set_rec.parameter2_value := p_dim2_level_value_id;
2698: l_parameter_set_rec.parameter3_value := p_dim3_level_value_id;