APPS.BIS_WEIGHTED_MEASURE_PUB dependencies on BIS_WEIGHTED_MEASURE_DEFNS

Line 597: ------- APIs for table BIS_WEIGHTED_MEASURE_DEFNS

593: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
594: raise;
595: END Delete_WM_Dependency;
596:
597: ------- APIs for table BIS_WEIGHTED_MEASURE_DEFNS
598:
599: /*******************************************************************
600: *******************************************************************/
601:

Line 633: SELECT BIS_WEIGHTED_MEASURE_DEFNS_S.NEXTVAL

629: -- l_Bis_WM_Rec.time_dim_level_short_name
630:
631: -- Set the weighted_definition_id
632: IF l_Bis_WM_Rec.weighted_definition_id IS NULL THEN
633: SELECT BIS_WEIGHTED_MEASURE_DEFNS_S.NEXTVAL
634: INTO l_Bis_WM_Rec.weighted_definition_id
635: FROM DUAL;
636: END IF;
637:

Line 1017: FROM BIS_WEIGHTED_MEASURE_DEFNS

1013: -- filter_level_value_id
1014:
1015: SELECT COUNT(1)
1016: INTO l_count
1017: FROM BIS_WEIGHTED_MEASURE_DEFNS
1018: WHERE WEIGHTED_DEFINITION_ID = p_Bis_WM_Rec.weighted_definition_id;
1019: IF l_count = 0 THEN
1020: FND_MESSAGE.SET_NAME('BIS','BIS_WM_INVALIDE_DEF');
1021: FND_MESSAGE.SET_TOKEN('DEF', p_Bis_WM_Rec.weighted_measure_id);

Line 2794: FROM BIS_WEIGHTED_MEASURE_DEFNS A

2790: ) RETURN VARCHAR IS
2791: -- Cursor to count Weights <> 0 associated to a Dependent Measure
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

Line 2806: FROM BIS_WEIGHTED_MEASURE_DEFNS A

2802:
2803: -- Cursor to count Weights associated to a Dependent Measure
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

Line 2818: FROM BIS_WEIGHTED_MEASURE_DEFNS A

2814:
2815: -- Cursor to count the Weights <> 0 associated to Weighted Measure
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

Line 2829: FROM BIS_WEIGHTED_MEASURE_DEFNS A

2825:
2826: -- Cursor to count the Weights <> 0 associated to Weighted Measure
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

Line 2906: FROM BIS_WEIGHTED_MEASURE_DEFNS

2902:
2903: -- Cursor to get the Weighted Parameters associated to the Weighted Definition
2904: CURSOR c_WM_Definitions IS
2905: SELECT WEIGHTED_DEFINITION_ID
2906: FROM BIS_WEIGHTED_MEASURE_DEFNS
2907: WHERE WEIGHTED_MEASURE_ID = p_weighted_measure_id;
2908:
2909: -- Cursor to get the Weighted Parameters associated to the Weighted Definition
2910: CURSOR c_WM_Dependent IS

Line 3020: FROM BIS_WEIGHTED_MEASURE_DEFNS

3016:
3017: -- Check if the Weighted Measure metada already exist
3018: SELECT COUNT(1)
3019: INTO l_count
3020: FROM BIS_WEIGHTED_MEASURE_DEFNS
3021: WHERE WEIGHTED_MEASURE_ID = p_weighted_measure_id;
3022:
3023: -- Pending to check if the Creation_By will be added to the API
3024: l_Bis_WM_Rec.Created_By := 1;

Line 3208: bis_weighted_measure_defns defns

3204: defns.weighted_definition_id
3205: BULK COLLECT INTO
3206: l_Definition_Ids
3207: FROM
3208: bis_weighted_measure_defns defns
3209: WHERE
3210: defns.weighted_measure_id = p_weighted_measure_id;
3211:
3212: IF l_Definition_Ids.COUNT > 0 THEN

Line 3837: bis_weighted_measure_defns defns

3833: defns.weighted_definition_id
3834: INTO
3835: l_Weighted_Definition_Id
3836: FROM
3837: bis_weighted_measure_defns defns
3838: WHERE
3839: defns.weighted_measure_id = p_weighted_measure_id AND
3840: defns.time_dimension_short_name || '+' || defns.time_dim_level_short_name = p_Time_Level;
3841:

Line 3929: bis_weighted_measure_defns defns,

3925: BULK COLLECT INTO
3926: l_Param_Ids
3927: FROM
3928: bis_weighted_measure_params params,
3929: bis_weighted_measure_defns defns,
3930: (SELECT
3931: a.column_value filter_level_value_id,
3932: b.column_value time_level_value_id
3933: FROM