APPS.BIS_DIMENSION_LEVEL_PVT dependencies on BIS_LEVELS_TL

Line 1423: insert into bis_LEVELS_TL (

1419: , p_drill_to_form_function
1420: , p_hide
1421: );
1422:
1423: insert into bis_LEVELS_TL (
1424: LEVEL_ID,
1425: LANGUAGE,
1426: NAME,
1427: DESCRIPTION,

Line 1453: from BIS_LEVELS_TL TL

1449: where L.INSTALLED_FLAG in ('I', 'B')
1450: and DL.SHORT_NAME = p_level_short_name
1451: and not exists
1452: (select 'EXIST'
1453: from BIS_LEVELS_TL TL
1454: , BIS_LEVELS T
1455: where T.level_ID = TL.level_id
1456: and T.SHORT_NAME = p_level_short_name
1457: and TL.LANGUAGE = L.LANGUAGE_CODE);

Line 1772: Update bis_levels_TL

1768: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1769: l_login_id := fnd_global.LOGIN_ID;
1770: --
1771: l_Dimension_Level_Rec.Last_Update_Date := NVL(p_Dimension_Level_Rec.Last_Update_Date, SYSDATE);
1772: Update bis_levels_TL
1773: set
1774: NAME = l_Dimension_Level_Rec.Dimension_Level_Name
1775: , DESCRIPTION = l_Dimension_Level_Rec.description
1776: , LAST_UPDATE_DATE = l_Dimension_Level_Rec.Last_Update_Date

Line 2058: DELETE FROM bis_levels_tl

2054: IF(l_dim_level_id IS NOT NULL) THEN
2055: DELETE FROM bis_levels
2056: WHERE level_id = l_dim_level_id;
2057:
2058: DELETE FROM bis_levels_tl
2059: WHERE level_id = l_dim_level_id;
2060: END IF;
2061: IF (p_commit = FND_API.G_TRUE) THEN
2062: COMMIT;

Line 2118: UPDATE BIS_LEVELS_TL

2114: INTO l_dim_level_id
2115: FROM BIS_LEVELS
2116: WHERE SHORT_NAME = p_Dimension_Level_Rec.Dimension_Level_Short_Name;
2117:
2118: UPDATE BIS_LEVELS_TL
2119: SET NAME = p_Dimension_Level_Rec.Dimension_Level_Name
2120: , DESCRIPTION = p_Dimension_Level_Rec.Description
2121: , SOURCE_LANG = p_Dimension_Level_Rec.Source_Lang
2122: , LAST_UPDATED_BY = l_user_id