APPS.BSC_COPY_INDICATOR_PUB dependencies on BSC_KPIS_TL

Line 2311: bsc_kpis_tl

2307: SELECT
2308: distinct source_lang
2309: ,name
2310: FROM
2311: bsc_kpis_tl
2312: WHERE indicator = p_Target_Indicator;
2313:
2314:
2315: l_Count NUMBER := 0;

Line 2316: l_source_lang bsc_kpis_tl.source_lang%TYPE;

2312: WHERE indicator = p_Target_Indicator;
2313:
2314:
2315: l_Count NUMBER := 0;
2316: l_source_lang bsc_kpis_tl.source_lang%TYPE;
2317: l_name bsc_kpis_tl.name%TYPE;
2318: l_new_name bsc_kpis_tl.name%TYPE;
2319: BEGIN
2320:

Line 2317: l_name bsc_kpis_tl.name%TYPE;

2313:
2314:
2315: l_Count NUMBER := 0;
2316: l_source_lang bsc_kpis_tl.source_lang%TYPE;
2317: l_name bsc_kpis_tl.name%TYPE;
2318: l_new_name bsc_kpis_tl.name%TYPE;
2319: BEGIN
2320:
2321: FND_MSG_PUB.Initialize;

Line 2318: l_new_name bsc_kpis_tl.name%TYPE;

2314:
2315: l_Count NUMBER := 0;
2316: l_source_lang bsc_kpis_tl.source_lang%TYPE;
2317: l_name bsc_kpis_tl.name%TYPE;
2318: l_new_name bsc_kpis_tl.name%TYPE;
2319: BEGIN
2320:
2321: FND_MSG_PUB.Initialize;
2322: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2342: ,p_Table_Name => 'BSC_KPIS_TL'

2338: IF p_Name IS NULL THEN
2339: l_new_name := BSC_UTILITY.get_Next_Name(
2340: p_Name => cd.Name
2341: ,p_Max_Count => 150
2342: ,p_Table_Name => 'BSC_KPIS_TL'
2343: ,p_Column_Name => 'NAME'
2344: ,p_Character => ' '
2345: );
2346: END IF;

Line 2348: bsc_kpis_tl

2344: ,p_Character => ' '
2345: );
2346: END IF;
2347: UPDATE
2348: bsc_kpis_tl
2349: SET
2350: name = l_new_name
2351: WHERE
2352: indicator = p_Target_Indicator AND

Line 2356: bsc_kpis_tl

2352: indicator = p_Target_Indicator AND
2353: source_lang = cd.source_lang;
2354: IF p_Description IS NOT NULL THEN
2355: UPDATE
2356: bsc_kpis_tl
2357: SET
2358: help = p_Description
2359: WHERE
2360: indicator = p_Target_Indicator AND