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_WEIGHTED_MEASURE_PUB dependencies on BIS_WEIGHTED_MEASURE_WEIGHTS

Line 62: bis_weighted_measure_weights weights

58: weights.weight_id
59: BULK COLLECT INTO
60: l_Weight_Ids
61: FROM
62: bis_weighted_measure_weights weights
63: WHERE
64: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(p_Param_Ids AS FND_TABLE_OF_NUMBER)));
65: ELSE
66: SELECT

Line 71: bis_weighted_measure_weights weights

67: weights.weight_id
68: BULK COLLECT INTO
69: l_Weight_Ids
70: FROM
71: bis_weighted_measure_weights weights
72: WHERE
73: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(p_Param_Ids AS FND_TABLE_OF_NUMBER))) AND
74: dependent_measure_id = p_dependent_measure_id;
75: END IF;

Line 85: bis_weighted_measure_weights

81: weight_id = l_Weight_Ids(i);
82:
83: FORALL i in 1..l_Weight_Ids.COUNT
84: DELETE FROM
85: bis_weighted_measure_weights
86: WHERE
87: weight_id = l_Weight_Ids(i);
88: END IF;
89:

Line 172: bis_weighted_measure_weights weights

168: weights.weight_id
169: BULK COLLECT INTO
170: l_Weight_Ids
171: FROM
172: bis_weighted_measure_weights weights
173: WHERE
174: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER)));
175:
176: Delete_Bulk_Weights_Scores (

Line 1245: FROM BIS_WEIGHTED_MEASURE_WEIGHTS

1241:
1242: -- Cursor to get the Weights associated to the Parameter
1243: CURSOR c_Weights IS
1244: SELECT WEIGHT_ID
1245: FROM BIS_WEIGHTED_MEASURE_WEIGHTS
1246: WHERE WEIGHTED_PARAMETER_ID = p_Bis_WM_Rec.weighted_parameter_id;
1247: BEGIN
1248: SAVEPOINT Delete_WM_Parameter_pub;
1249: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1311: ------- APIs for table BIS_WEIGHTED_MEASURE_WEIGHTS

1307: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1308: raise;
1309: END Delete_WM_Parameter;
1310:
1311: ------- APIs for table BIS_WEIGHTED_MEASURE_WEIGHTS
1312:
1313: /*******************************************************************
1314: *******************************************************************/
1315: PROCEDURE Create_WM_Weight(

Line 1350: SELECT BIS_WEIGHTED_MEASURE_WEIGHTS_S.NEXTVAL

1346:
1347:
1348: -- Set the weighted_definition_id
1349: IF p_Bis_WM_Rec.weight_id IS NULL THEN
1350: SELECT BIS_WEIGHTED_MEASURE_WEIGHTS_S.NEXTVAL
1351: INTO l_Bis_WM_Rec.weight_id
1352: FROM DUAL;
1353: END IF;
1354:

Line 1656: FROM BIS_WEIGHTED_MEASURE_WEIGHTS

1652: l_Bis_WM_Rec :=p_Bis_WM_Rec;
1653:
1654: SELECT COUNT(1)
1655: INTO l_count
1656: FROM BIS_WEIGHTED_MEASURE_WEIGHTS
1657: WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id;
1658: IF l_count = 0 THEN
1659: FND_MESSAGE.SET_NAME('BIS','BIS_WM_INVALIDE_WEIGHT_ID');
1660: FND_MESSAGE.SET_TOKEN('WEIGHT_ID', p_Bis_WM_Rec.weight_id);

Line 2463: ------- APIs for table BIS_WEIGHTED_MEASURE_WEIGHTS

2459: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2460: raise;
2461: END Delete_WM_Parameter;
2462:
2463: ------- APIs for table BIS_WEIGHTED_MEASURE_WEIGHTS
2464:
2465: /*******************************************************************
2466: *******************************************************************/
2467: PROCEDURE Create_WM_Weight(

Line 2796: ,BIS_WEIGHTED_MEASURE_WEIGHTS C

2792: CURSOR c_weights_by_dep_measure IS
2793: SELECT COUNT(C.WEIGHT_ID) C1
2794: FROM BIS_WEIGHTED_MEASURE_DEFNS A
2795: ,BIS_WEIGHTED_MEASURE_PARAMS B
2796: ,BIS_WEIGHTED_MEASURE_WEIGHTS C
2797: WHERE A.weighted_measure_id = p_weighted_measure_id
2798: AND A.weighted_definition_id = B.weighted_definition_id
2799: AND B.weighted_parameter_id = C.weighted_parameter_id
2800: AND C.DEPENDENT_MEASURE_ID = p_dependent_measure_Id

Line 2808: ,BIS_WEIGHTED_MEASURE_WEIGHTS C

2804: CURSOR c_weights0_by_dep_measure IS
2805: SELECT COUNT(WEIGHT_ID) C1
2806: FROM BIS_WEIGHTED_MEASURE_DEFNS A
2807: ,BIS_WEIGHTED_MEASURE_PARAMS B
2808: ,BIS_WEIGHTED_MEASURE_WEIGHTS C
2809: WHERE A.weighted_measure_id = p_weighted_measure_id
2810: AND A.weighted_definition_id = B.weighted_definition_id
2811: AND B.weighted_parameter_id = C.weighted_parameter_id
2812: AND C.DEPENDENT_MEASURE_ID = p_dependent_measure_Id

Line 2820: ,BIS_WEIGHTED_MEASURE_WEIGHTS C

2816: CURSOR c_weights IS
2817: SELECT COUNT(WEIGHT_ID) C1
2818: FROM BIS_WEIGHTED_MEASURE_DEFNS A
2819: ,BIS_WEIGHTED_MEASURE_PARAMS B
2820: ,BIS_WEIGHTED_MEASURE_WEIGHTS C
2821: WHERE A.weighted_measure_id = p_weighted_measure_id
2822: AND A.weighted_definition_id = B.weighted_definition_id
2823: AND B.weighted_parameter_id = C.weighted_parameter_id
2824: AND C.WEIGHT <> 0 ;

Line 2831: ,BIS_WEIGHTED_MEASURE_WEIGHTS C

2827: CURSOR c_weights0 IS
2828: SELECT COUNT(WEIGHT_ID) C1
2829: FROM BIS_WEIGHTED_MEASURE_DEFNS A
2830: ,BIS_WEIGHTED_MEASURE_PARAMS B
2831: ,BIS_WEIGHTED_MEASURE_WEIGHTS C
2832: WHERE A.weighted_measure_id = p_weighted_measure_id
2833: AND A.weighted_definition_id = B.weighted_definition_id
2834: AND B.weighted_parameter_id = C.weighted_parameter_id
2835: AND C.WEIGHT = 0 ;

Line 3233: bis_weighted_measure_weights weights

3229: MINUS
3230: SELECT
3231: weights.weighted_parameter_id
3232: FROM
3233: bis_weighted_measure_weights weights
3234: WHERE
3235: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND
3236: weights.dependent_measure_id = p_dependent_measure_id);
3237:

Line 3243: bis_weighted_measure_weights weights

3239: weights.weighted_parameter_id
3240: BULK COLLECT INTO
3241: l_Update_Param_Ids
3242: FROM
3243: bis_weighted_measure_weights weights
3244: WHERE
3245: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND
3246: weights.dependent_measure_id = p_dependent_measure_id;
3247:

Line 3251: UPDATE bis_weighted_measure_weights SET

3247:
3248: IF l_Update_Param_Ids.COUNT > 0 THEN
3249: IF p_Weight IS NOT NULL THEN
3250: FORALL i in 1..l_Update_Param_Ids.COUNT
3251: UPDATE bis_weighted_measure_weights SET
3252: weight = p_weight
3253: ,last_update_date = SYSDATE
3254: ,last_updated_by = l_User_Id
3255: ,last_update_login = l_Login_Id

Line 3276: INSERT INTO bis_weighted_measure_weights(

3272: END IF;
3273:
3274: IF p_Weight IS NOT NULL AND l_Insert_Param_Ids.COUNT > 0 THEN
3275: FORALL i in 1..l_Insert_Param_Ids.COUNT
3276: INSERT INTO bis_weighted_measure_weights(
3277: weight_id
3278: ,weighted_parameter_id
3279: ,dependent_measure_id
3280: ,weight

Line 3287: bis_weighted_measure_weights_s.nextval

3283: ,last_update_date
3284: ,last_updated_by
3285: ,last_update_login
3286: ) VALUES (
3287: bis_weighted_measure_weights_s.nextval
3288: ,l_Insert_Param_Ids(i)
3289: ,p_dependent_measure_id
3290: ,p_weight
3291: ,SYSDATE

Line 3550: bis_weighted_measure_weights weights

3546: weights.weight_id
3547: BULK COLLECT INTO
3548: l_Weight_Ids
3549: FROM
3550: bis_weighted_measure_weights weights
3551: WHERE
3552: weights.dependent_measure_id = p_dependent_measure_id AND
3553: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER)));
3554:

Line 3714: bis_weighted_measure_weights w

3710: INTO
3711: l_Default_Weight
3712: FROM
3713: bis_weighted_measure_params p,
3714: bis_weighted_measure_weights w
3715: WHERE
3716: p.weighted_parameter_id = w.weighted_parameter_id AND
3717: p.time_level_value_id = 'DEFAULT' AND
3718: p.filter_level_value_id = 'DEFAULT' AND

Line 3724: INSERT INTO bis_weighted_measure_weights(

3720: w.dependent_measure_id = p_dependent_measure_id;
3721:
3722:
3723: FORALL i IN 1..l_Param_Ids.COUNT
3724: INSERT INTO bis_weighted_measure_weights(
3725: weight_id
3726: , weighted_parameter_id
3727: , dependent_measure_id
3728: , weight

Line 3735: bis_weighted_measure_weights_s.nextval

3731: , last_update_date
3732: , last_updated_by
3733: , last_update_login
3734: ) VALUES (
3735: bis_weighted_measure_weights_s.nextval
3736: , l_Param_Ids(i)
3737: , p_dependent_measure_id
3738: , l_Default_Weight
3739: , SYSDATE

Line 3751: bis_weighted_measure_weights weights

3747: weights.weight_id
3748: BULK COLLECT INTO
3749: l_Weight_Ids
3750: FROM
3751: bis_weighted_measure_weights weights
3752: WHERE
3753: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND
3754: weights.dependent_measure_id = p_dependent_measure_id;
3755:

Line 3951: bis_weighted_measure_weights b

3947: INTO
3948: x_Param_Count
3949: FROM
3950: bis_weighted_measure_scores a,
3951: bis_weighted_measure_weights b
3952: WHERE
3953: a.weight_id = b.weight_id AND
3954: b.weighted_parameter_id in (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND
3955: b.dependent_measure_id = p_dependent_measure_id;