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_TARGET_LEVEL_PVT dependencies on BIS_TARGET_LEVELS

Line 304: from bis_target_levels

300: ) RETURN NUMBER
301: IS
302: cursor short_name_cursor IS
303: select target_level_id
304: from bis_target_levels
305: where short_name like p_tl_rec.target_level_short_name;
306: l_dummy number := NULL;
307: BEGIN
308:

Line 328: from bis_target_levels

324: IS
325: --changed cursor
326: cursor dimlevel_cursor(p_tl_curs_rec BIS_Target_Level_PUB.Target_Level_Rec_Type) IS
327: select target_level_id
328: from bis_target_levels
329: where NVL(INDICATOR_ID, -1) = NVL(p_tl_curs_rec.Measure_Id, -1)
330: AND (p_tl_curs_rec.Org_Level_Id IS NULL OR NVL(ORG_LEVEL_ID, -1) = NVL(p_tl_curs_rec.Org_Level_Id, -1))
331: AND (p_tl_curs_rec.Time_Level_Id IS NULL OR NVL(TIME_LEVEL_ID, -1) = NVL(p_tl_curs_rec.Time_Level_Id, -1))
332: AND NVL(DIMENSION1_LEVEL_ID, -1) = NVL(p_tl_curs_rec.Dimension1_Level_Id, -1)

Line 783: select bis_target_levels_s.NEXTVAL into l_id from dual;

779: END IF;
780:
781:
782:
783: select bis_target_levels_s.NEXTVAL into l_id from dual;
784: --
785:
786: insert into bis_TARGET_LEVELS (
787: TARGET_LEVEL_ID,

Line 786: insert into bis_TARGET_LEVELS (

782:
783: select bis_target_levels_s.NEXTVAL into l_id from dual;
784: --
785:
786: insert into bis_TARGET_LEVELS (
787: TARGET_LEVEL_ID,
788: INDICATOR_ID,
789: SHORT_NAME,
790: ORG_LEVEL_ID,

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 933: from bis_target_levels

929: BEGIN
930:
931: x_return_status := FND_API.G_RET_STS_SUCCESS;
932: select count(1) into x_count
933: from bis_target_levels
934: where indicator_id = p_Measure_Rec.Measure_id;
935:
936: --commented RAISE
937: EXCEPTION

Line 1308: FROM BIS_TARGET_LEVELS

1304: , l_target_level_rec.DIMENSION4_LEVEL_ID
1305: , l_target_level_rec.DIMENSION5_LEVEL_ID
1306: , l_target_level_rec.DIMENSION6_LEVEL_ID
1307: , l_target_level_rec.DIMENSION7_LEVEL_ID
1308: FROM BIS_TARGET_LEVELS
1309: WHERE TARGET_LEVEL_ID = p_Target_Level_rec.Target_Level_ID;
1310: -- end of 2528450
1311: else -- p_all_info = true and p_Target_Level_Rec.is_wf_info_needed = true
1312: select TARGET_LEVEL_ID

Line 1575: FROM BIS_TARGET_LEVELS

1571: , DIMENSION4_LEVEL_ID
1572: , DIMENSION5_LEVEL_ID
1573: , DIMENSION6_LEVEL_ID
1574: , DIMENSION7_LEVEL_ID
1575: FROM BIS_TARGET_LEVELS
1576: WHERE short_name IN (';
1577:
1578: IF (p_target_level_tbl.COUNT <= 10) THEN
1579: x_is_bind := TRUE;

Line 2100: UPDATE BIS_TARGET_LEVELS

2096: ------------------
2097: */
2098:
2099:
2100: UPDATE BIS_TARGET_LEVELS
2101: set
2102: INDICATOR_ID = l_Target_Level_Rec.Measure_ID
2103: , SHORT_NAME = l_Target_Level_Rec.Target_Level_Short_Name
2104: , ORG_LEVEL_ID = l_Target_Level_Rec.org_Level_ID

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 2386: delete from bis_TARGET_LEVELS

2382:
2383: RAISE FND_API.G_EXC_ERROR;
2384: end if;
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;

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 3183: FROM BIS_TARGET_LEVELS

3179: = FND_API.G_TRUE
3180: ) THEN
3181: SELECT NVL(LAST_UPDATE_DATE, CREATION_DATE)
3182: INTO x_last_update_date
3183: FROM BIS_TARGET_LEVELS
3184: WHERE TARGET_LEVEL_ID = p_Target_Level_Rec.Target_Level_ID;
3185: END IF;
3186:
3187: --

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 4244: FROM bis_target_levels

4240: ,p_tl_new_short_name IN VARCHAR2
4241: ,x_return_status OUT NOCOPY VARCHAR2) AS
4242: CURSOR c_updt1 IS
4243: SELECT target_level_id , last_updated_by , created_by
4244: FROM bis_target_levels
4245: WHERE short_name = p_tl_short_name FOR UPDATE OF last_updated_by , created_by;
4246:
4247: l_pm_count NUMBER := 0;
4248:

Line 4258: UPDATE bis_target_levels SET last_updated_by = 1 , created_by = 1, short_name = p_tl_new_short_name

4254:
4255: l_pm_count := l_pm_count + 1;
4256:
4257: IF p_tl_new_short_name IS NOT NULL THEN
4258: UPDATE bis_target_levels SET last_updated_by = 1 , created_by = 1, short_name = p_tl_new_short_name
4259: WHERE current of c_updt1;
4260: ELSE
4261: UPDATE bis_target_levels SET last_updated_by = 1 , created_by = 1
4262: WHERE current of c_updt1;

Line 4261: UPDATE bis_target_levels SET last_updated_by = 1 , created_by = 1

4257: IF p_tl_new_short_name IS NOT NULL THEN
4258: UPDATE bis_target_levels SET last_updated_by = 1 , created_by = 1, short_name = p_tl_new_short_name
4259: WHERE current of c_updt1;
4260: ELSE
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

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: