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_MEASURE_PVT dependencies on BIS_INDICATORS

Line 186: from bis_indicators

182: -- mdamle 08/01/2003 - Chk for duplicate name after trimming
183: -- mdamle 08/04/2003 - Added case insensitive check
184: cursor short_name_cursor IS
185: select indicator_id
186: from bis_indicators
187: where short_name = p_measure_rec.Measure_Short_name;
188: l_dummy number;
189: BEGIN
190:

Line 217: from bis_indicators_vl

213: -- mdamle 08/01/2003 - Chk for duplicate name after trimming
214: -- mdamle 08/04/2003 - Added case insensitive check
215: cursor name_cursor IS
216: select indicator_id
217: from bis_indicators_vl
218: where name = p_measure_rec.Measure_name;
219:
220: l_dummy number;
221: BEGIN

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 1035: select bis_indicators_s.NextVal into l_id from dual;

1031: l_Measure_Rec.Last_Update_Date := sysdate;
1032: END IF;
1033:
1034: --
1035: select bis_indicators_s.NextVal into l_id from dual;
1036: --dbms_output.put_line('function shortname:::'||l_measure_rec.function_short_name);
1037:
1038:
1039: insert into bis_indicators(

Line 1039: insert into bis_indicators(

1035: select bis_indicators_s.NextVal into l_id from dual;
1036: --dbms_output.put_line('function shortname:::'||l_measure_rec.function_short_name);
1037:
1038:
1039: insert into bis_indicators(
1040: INDICATOR_ID
1041: , SHORT_NAME
1042: , UOM_CLASS
1043: , ACTUAL_DATA_SOURCE_TYPE

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 1312: select bis_indicators_s.NextVal into l_id from dual;

1308: l_Measure_Rec.Last_Update_Date := sysdate;
1309: END IF;
1310:
1311: --
1312: select bis_indicators_s.NextVal into l_id from dual;
1313:
1314:
1315: --Code commented as a fix for 2167619 starts here
1316: insert into bis_indicators(

Line 1316: insert into bis_indicators(

1312: select bis_indicators_s.NextVal into l_id from dual;
1313:
1314:
1315: --Code commented as a fix for 2167619 starts here
1316: insert into bis_indicators(
1317: INDICATOR_ID
1318: , SHORT_NAME
1319: , UOM_CLASS
1320: , ACTUAL_DATA_SOURCE_TYPE

Line 1359: insert into bis_indicators(

1355: , l_Measure_Rec.Last_Updated_By
1356: , l_Measure_Rec.Last_Update_Login
1357: );
1358: /*
1359: insert into bis_indicators(
1360: INDICATOR_ID
1361: , SHORT_NAME
1362: , UOM_CLASS
1363: , CREATION_DATE

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 2696: Update bis_indicators

2692: IF (l_Measure_Rec.Last_Update_Date IS NULL) THEN
2693: l_Measure_Rec.Last_Update_Date := SYSDATE;
2694: END IF;
2695:
2696: Update bis_indicators
2697: set
2698: SHORT_NAME = l_Measure_Rec.Measure_Short_Name
2699: , UOM_Class = l_Measure_Rec.Unit_Of_Measure_Class
2700: , ACTUAL_DATA_SOURCE_TYPE = l_Measure_Rec.Actual_Data_Source_Type

Line 2946: Update bis_indicators

2942: IF (l_Measure_Rec.Last_Update_Date IS NULL) THEN
2943: l_Measure_Rec.Last_Update_Date := SYSDATE;
2944: END IF;
2945:
2946: Update bis_indicators
2947: set
2948: SHORT_NAME = l_Measure_Rec.Measure_Short_Name
2949: , UOM_Class = l_Measure_Rec.Unit_Of_Measure_Class -- Fix for 2167619 starts here
2950: , ACTUAL_DATA_SOURCE_TYPE = l_Measure_Rec.Actual_Data_Source_Type

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 3110: delete from bis_indicators

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;
3112:
3113: if (p_commit = FND_API.G_TRUE) then
3114: commit;

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 4470: FROM bis_indicators

4466: = FND_API.G_TRUE
4467: ) THEN
4468: SELECT NVL(LAST_UPDATE_DATE, CREATION_DATE)
4469: INTO x_last_update_date
4470: FROM bis_indicators
4471: WHERE INDICATOR_ID = p_Measure_Rec.Measure_ID;
4472: END IF;
4473: --
4474:

Line 5079: FROM bis_indicators

5075: PROCEDURE updt_pm_owner(p_pm_short_name IN VARCHAR2
5076: ,x_return_status OUT NOCOPY VARCHAR2) AS
5077: CURSOR c_updt1 IS
5078: SELECT indicator_id
5079: FROM bis_indicators
5080: WHERE short_name = p_pm_short_name FOR UPDATE OF last_updated_by , created_by;
5081:
5082: l_pm_count NUMBER := 0;
5083:

Line 5094: UPDATE bis_indicators SET last_updated_by = 1 , created_by = 1

5090:
5091: l_pm_count := l_pm_count + 1;
5092:
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;

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

Line 5301: l_bis_custom_enabled_usr BIS_INDICATORS.enabled%TYPE;

5297: OR responsibility_id = fnd_global.RESP_ID
5298: OR application_id = fnd_global.RESP_APPL_ID
5299: OR org_id = fnd_global.ORG_ID
5300: OR site_id = 0) ;
5301: l_bis_custom_enabled_usr BIS_INDICATORS.enabled%TYPE;
5302: l_bis_custom_enabled_resp BIS_INDICATORS.enabled%TYPE;
5303: l_bis_custom_enabled_appl BIS_INDICATORS.enabled%TYPE;
5304: l_bis_custom_enabled_org BIS_INDICATORS.enabled%TYPE;
5305: l_bis_custom_enabled_site BIS_INDICATORS.enabled%TYPE;

Line 5302: l_bis_custom_enabled_resp BIS_INDICATORS.enabled%TYPE;

5298: OR application_id = fnd_global.RESP_APPL_ID
5299: OR org_id = fnd_global.ORG_ID
5300: OR site_id = 0) ;
5301: l_bis_custom_enabled_usr BIS_INDICATORS.enabled%TYPE;
5302: l_bis_custom_enabled_resp BIS_INDICATORS.enabled%TYPE;
5303: l_bis_custom_enabled_appl BIS_INDICATORS.enabled%TYPE;
5304: l_bis_custom_enabled_org BIS_INDICATORS.enabled%TYPE;
5305: l_bis_custom_enabled_site BIS_INDICATORS.enabled%TYPE;
5306: BEGIN

Line 5303: l_bis_custom_enabled_appl BIS_INDICATORS.enabled%TYPE;

5299: OR org_id = fnd_global.ORG_ID
5300: OR site_id = 0) ;
5301: l_bis_custom_enabled_usr BIS_INDICATORS.enabled%TYPE;
5302: l_bis_custom_enabled_resp BIS_INDICATORS.enabled%TYPE;
5303: l_bis_custom_enabled_appl BIS_INDICATORS.enabled%TYPE;
5304: l_bis_custom_enabled_org BIS_INDICATORS.enabled%TYPE;
5305: l_bis_custom_enabled_site BIS_INDICATORS.enabled%TYPE;
5306: BEGIN
5307: IF (c_cust%ISOPEN) THEN

Line 5304: l_bis_custom_enabled_org BIS_INDICATORS.enabled%TYPE;

5300: OR site_id = 0) ;
5301: l_bis_custom_enabled_usr BIS_INDICATORS.enabled%TYPE;
5302: l_bis_custom_enabled_resp BIS_INDICATORS.enabled%TYPE;
5303: l_bis_custom_enabled_appl BIS_INDICATORS.enabled%TYPE;
5304: l_bis_custom_enabled_org BIS_INDICATORS.enabled%TYPE;
5305: l_bis_custom_enabled_site BIS_INDICATORS.enabled%TYPE;
5306: BEGIN
5307: IF (c_cust%ISOPEN) THEN
5308: CLOSE c_cust;

Line 5305: l_bis_custom_enabled_site BIS_INDICATORS.enabled%TYPE;

5301: l_bis_custom_enabled_usr BIS_INDICATORS.enabled%TYPE;
5302: l_bis_custom_enabled_resp BIS_INDICATORS.enabled%TYPE;
5303: l_bis_custom_enabled_appl BIS_INDICATORS.enabled%TYPE;
5304: l_bis_custom_enabled_org BIS_INDICATORS.enabled%TYPE;
5305: l_bis_custom_enabled_site BIS_INDICATORS.enabled%TYPE;
5306: BEGIN
5307: IF (c_cust%ISOPEN) THEN
5308: CLOSE c_cust;
5309: END IF;

Line 5470: UPDATE bis_indicators

5466: FND_MSG_PUB.ADD;
5467: RAISE FND_API.G_EXC_ERROR;
5468: END IF;
5469:
5470: UPDATE bis_indicators
5471: SET
5472: obsolete = p_obsolete ,
5473: last_update_date = SYSDATE,
5474: last_updated_by = FND_GLOBAL.USER_ID ,