APPS.BIS_MEASURE_PVT dependencies on BIS_INDICATORS_TL

Line 903: l_Mapped_measure bis_indicators_tl.NAME%TYPE;

899: l_application_rec BIS_APPLICATION_PVT.Application_rec_type;
900: l_measure_id NUMBER;
901: l_own_appl VARCHAR2(100) := FND_API.G_FALSE ; --2465354
902: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
903: l_Mapped_measure bis_indicators_tl.NAME%TYPE;
904: l_Return_Status VARCHAR2(2000);
905:
906: BEGIN
907:

Line 1083: insert into bis_INDICATORS_TL (

1079: , l_Measure_Rec.Last_Updated_By
1080: , l_Measure_Rec.Last_Update_Login
1081: );
1082:
1083: insert into bis_INDICATORS_TL (
1084: INDICATOR_ID,
1085: LANGUAGE,
1086: NAME,
1087: DESCRIPTION,

Line 1111: from bis_INDICATORS_TL T

1107: from FND_LANGUAGES L
1108: where L.INSTALLED_FLAG in ('I', 'B')
1109: and not exists
1110: (select NULL
1111: from bis_INDICATORS_TL T
1112: where T.indicator_ID = l_id
1113: and T.LANGUAGE = L.LANGUAGE_CODE);
1114:
1115: l_measure_rec.Measure_id := l_id;

Line 1381: insert into bis_INDICATORS_TL (

1377: , l_login_id
1378: );
1379: */
1380: --Code commented as a fix for 2167619 ends here
1381: insert into bis_INDICATORS_TL (
1382: INDICATOR_ID,
1383: LANGUAGE,
1384: NAME,
1385: DESCRIPTION,

Line 1409: from bis_INDICATORS_TL T

1405: from FND_LANGUAGES L
1406: where L.INSTALLED_FLAG in ('I', 'B')
1407: and not exists
1408: (select NULL
1409: from bis_INDICATORS_TL T
1410: where T.indicator_ID = l_id
1411: and T.LANGUAGE = L.LANGUAGE_CODE);
1412:
1413: l_measure_rec.Measure_id := l_id;

Line 2524: l_Mapped_measure bis_indicators_tl.NAME%TYPE;

2520: l_Measure_Id NUMBER;
2521: l_application_rec BIS_APPLICATION_PVT.Application_rec_type; --2465354
2522: l_own_appl VARCHAR2(100) := FND_API.G_FALSE ; --2465354
2523: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2524: l_Mapped_measure bis_indicators_tl.NAME%TYPE;
2525: l_Return_Status VARCHAR2(2000);
2526:
2527: BEGIN
2528: -- l_measure_rec := p_measure_rec;

Line 3107: delete from bis_indicators_tl

3103: delete from bis_indicator_dimensions
3104: where indicator_id = p_Measure_Rec.Measure_Id;
3105: end if;
3106:
3107: delete from bis_indicators_tl
3108: where indicator_id = p_Measure_Rec.Measure_Id;
3109:
3110: delete from bis_indicators
3111: where indicator_id = p_Measure_Rec.Measure_Id;

Line 3257: Update bis_INDICATORS_TL

3253:
3254: l_login_id := fnd_global.LOGIN_ID;
3255: --
3256:
3257: Update bis_INDICATORS_TL
3258: set
3259: NAME = l_Measure_Rec.Measure_Name
3260: , DESCRIPTION = l_Measure_Rec.description
3261: , LAST_UPDATE_DATE = l_Measure_Rec.Last_Update_Date

Line 5097: UPDATE bis_indicators_tl SET last_updated_by = 1 , created_by = 1

5093:
5094: UPDATE bis_indicators SET last_updated_by = 1 , created_by = 1
5095: WHERE current of c_updt1;
5096:
5097: UPDATE bis_indicators_tl SET last_updated_by = 1 , created_by = 1
5098: WHERE indicator_id = i.indicator_id;
5099:
5100: UPDATE bis_indicator_dimensions SET last_updated_by = 1 , created_by = 1
5101: WHERE indicator_id = i.indicator_id;

Line 5245: Update bis_INDICATORS_TL

5241: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
5242:
5243: l_login_id := fnd_global.LOGIN_ID;
5244:
5245: Update bis_INDICATORS_TL
5246: set
5247: NAME = p_Measure_Rec.Measure_Name
5248: , DESCRIPTION = p_Measure_Rec.description
5249: , LAST_UPDATED_BY = l_user_id