APPS.BSC_DIM_LEVEL_FILTERS_PUB dependencies on BSC_DEFAULT_KEY_ITEM_PUB

Line 83: l_dim_val := BSC_DEFAULT_KEY_ITEM_PUB.get_table_column_value(cd.level_view_name, 'NAME', 'CODE=' || cd.dim_level_value);

79: l_found := FND_API.G_TRUE;
80: END IF;
81: END LOOP;
82: IF(l_found=FND_API.G_FALSE)THEN
83: l_dim_val := BSC_DEFAULT_KEY_ITEM_PUB.get_table_column_value(cd.level_view_name, 'NAME', 'CODE=' || cd.dim_level_value);
84: FND_MESSAGE.SET_NAME('BSC','BSC_LIST_SECURITY_ERROR');
85: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_dim_val, TRUE);
86: FND_MSG_PUB.ADD;
87: RAISE FND_API.G_EXC_ERROR;

Line 1449: l_key_name := BSC_DEFAULT_KEY_ITEM_PUB.get_table_column_value(cd.level_view_name, 'NAME', 'CODE=' || cd.default_key_value);

1445:
1446:
1447: IF (l_mismatch = 1) THEN
1448:
1449: l_key_name := BSC_DEFAULT_KEY_ITEM_PUB.get_table_column_value(cd.level_view_name, 'NAME', 'CODE=' || cd.default_key_value);
1450:
1451:
1452: IF (p_mismatch_key_items IS NULL) THEN
1453: p_mismatch_key_items := l_key_name;

Line 1640: l_key_name := BSC_DEFAULT_KEY_ITEM_PUB.get_table_column_value(

1636: CLOSE ref_cur;
1637:
1638:
1639: IF (l_mismatch_found AND l_pa_level_view IS NOT NULL) THEN
1640: l_key_name := BSC_DEFAULT_KEY_ITEM_PUB.get_table_column_value(
1641: p_table_name => l_pa_level_view
1642: ,p_column_name => 'NAME'
1643: ,p_where_cond => ' CODE = ' || cd.default_key_value
1644: );

Line 1850: l_key_name := BSC_DEFAULT_KEY_ITEM_PUB.get_table_column_value(

1846: END LOOP;
1847:
1848: IF (l_mismatch_found ) THEN
1849:
1850: l_key_name := BSC_DEFAULT_KEY_ITEM_PUB.get_table_column_value(
1851: p_table_name => l_ch_level_view
1852: ,p_column_name => 'NAME'
1853: ,p_where_cond => ' CODE = ' || cd.default_key_value
1854: );