APPS.BIS_TARGET_LEVEL_PVT dependencies on BIS_TARGET_LEVELS_TL

Line 843: insert into bis_TARGET_LEVELS_TL (

839: , l_login_id
840: , l_target_level_rec.Source
841: );
842:
843: insert into bis_TARGET_LEVELS_TL (
844: TARGET_LEVEL_ID,
845: LANGUAGE,
846: NAME,
847: DESCRIPTION,

Line 873: from bis_TARGET_LEVELS_TL T

869: from FND_LANGUAGES L
870: where L.INSTALLED_FLAG in ('I', 'B')
871: and not exists
872: (select NULL
873: from bis_TARGET_LEVELS_TL T
874: where T.TARGET_LEVEL_ID = l_id
875: and T.LANGUAGE = L.LANGUAGE_CODE);
876:
877: if (p_commit = FND_API.G_TRUE) then

Line 2299: Update BIS_TARGET_LEVELS_TL

2295:
2296: l_login_id := fnd_global.LOGIN_ID;
2297: --
2298:
2299: Update BIS_TARGET_LEVELS_TL
2300: set
2301: NAME = l_Target_Level_Rec.Target_Level_Name
2302: , DESCRIPTION = l_Target_Level_Rec.description
2303: , UNIT_OF_MEASURE = l_Target_Level_Rec.Unit_Of_Measure

Line 2389: delete from bis_TARGET_LEVELS_TL

2385:
2386: delete from bis_TARGET_LEVELS
2387: where TARGET_LEVEL_ID = p_Target_Level_Rec.Target_Level_Id;
2388:
2389: delete from bis_TARGET_LEVELS_TL
2390: where TARGET_LEVEL_ID = p_Target_Level_Rec.Target_Level_Id;
2391:
2392: BIS_MEASURE_SECURITY_PVT.Delete_Measure_Security( p_api_version
2393: , p_commit

Line 4237: -- bis_target_levels, bis_target_levels_tl

4233: END Retrieve_TL_From_DimLvlShNms;
4234: --------------------------------
4235:
4236: -- Given a target level short name update the
4237: -- bis_target_levels, bis_target_levels_tl
4238: -- for last_updated_by , created_by as 1
4239: PROCEDURE updt_tl_attributes(p_tl_short_name IN VARCHAR2
4240: ,p_tl_new_short_name IN VARCHAR2
4241: ,x_return_status OUT NOCOPY VARCHAR2) AS

Line 4265: UPDATE bis_target_levels_tl SET last_updated_by = 1 , created_by = 1

4261: UPDATE bis_target_levels SET last_updated_by = 1 , created_by = 1
4262: WHERE current of c_updt1;
4263: END IF;
4264:
4265: UPDATE bis_target_levels_tl SET last_updated_by = 1 , created_by = 1
4266: WHERE target_level_id = i.target_level_id;
4267:
4268: END LOOP;
4269: