30: ---------------------- BIS_WEIGHTED_MEASURE_DEPENDENCIES
31: weighted_measure_id BIS_WEIGHTED_MEASURE_DEPENDS.weighted_measure_id%TYPE
32: ,dependent_measure_id BIS_WEIGHTED_MEASURE_DEPENDS.dependent_measure_id%TYPE
33: ------------------------ BIS_WEIGHTED_MEASURE_DEFINITIONS
34: ,weighted_definition_id BIS_WEIGHTED_MEASURE_DEFNS.weighted_definition_id%TYPE
35: --weighted_measure_id BIS_WEIGHTED_MEASURE_DEPENDS.weighted_measure_id%TYPE
36: ,viewby_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dimension_short_name%TYPE
37: ,viewby_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dim_level_short_name%TYPE
38: ,filter_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dimension_short_name%TYPE
32: ,dependent_measure_id BIS_WEIGHTED_MEASURE_DEPENDS.dependent_measure_id%TYPE
33: ------------------------ BIS_WEIGHTED_MEASURE_DEFINITIONS
34: ,weighted_definition_id BIS_WEIGHTED_MEASURE_DEFNS.weighted_definition_id%TYPE
35: --weighted_measure_id BIS_WEIGHTED_MEASURE_DEPENDS.weighted_measure_id%TYPE
36: ,viewby_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dimension_short_name%TYPE
37: ,viewby_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dim_level_short_name%TYPE
38: ,filter_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dimension_short_name%TYPE
39: ,filter_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dim_level_short_name%TYPE
40: ,time_dimension_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dimension_short_name%TYPE
33: ------------------------ BIS_WEIGHTED_MEASURE_DEFINITIONS
34: ,weighted_definition_id BIS_WEIGHTED_MEASURE_DEFNS.weighted_definition_id%TYPE
35: --weighted_measure_id BIS_WEIGHTED_MEASURE_DEPENDS.weighted_measure_id%TYPE
36: ,viewby_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dimension_short_name%TYPE
37: ,viewby_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dim_level_short_name%TYPE
38: ,filter_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dimension_short_name%TYPE
39: ,filter_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dim_level_short_name%TYPE
40: ,time_dimension_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dimension_short_name%TYPE
41: ,time_dim_level_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dim_level_short_name%TYPE
34: ,weighted_definition_id BIS_WEIGHTED_MEASURE_DEFNS.weighted_definition_id%TYPE
35: --weighted_measure_id BIS_WEIGHTED_MEASURE_DEPENDS.weighted_measure_id%TYPE
36: ,viewby_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dimension_short_name%TYPE
37: ,viewby_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dim_level_short_name%TYPE
38: ,filter_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dimension_short_name%TYPE
39: ,filter_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dim_level_short_name%TYPE
40: ,time_dimension_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dimension_short_name%TYPE
41: ,time_dim_level_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dim_level_short_name%TYPE
42: ---------------------------- BIS_WEIGHTED_MEASURE_PARAMETERS
35: --weighted_measure_id BIS_WEIGHTED_MEASURE_DEPENDS.weighted_measure_id%TYPE
36: ,viewby_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dimension_short_name%TYPE
37: ,viewby_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dim_level_short_name%TYPE
38: ,filter_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dimension_short_name%TYPE
39: ,filter_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dim_level_short_name%TYPE
40: ,time_dimension_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dimension_short_name%TYPE
41: ,time_dim_level_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dim_level_short_name%TYPE
42: ---------------------------- BIS_WEIGHTED_MEASURE_PARAMETERS
43: ,weighted_parameter_id BIS_WEIGHTED_MEASURE_PARAMS.weighted_parameter_id%TYPE
36: ,viewby_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dimension_short_name%TYPE
37: ,viewby_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dim_level_short_name%TYPE
38: ,filter_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dimension_short_name%TYPE
39: ,filter_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dim_level_short_name%TYPE
40: ,time_dimension_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dimension_short_name%TYPE
41: ,time_dim_level_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dim_level_short_name%TYPE
42: ---------------------------- BIS_WEIGHTED_MEASURE_PARAMETERS
43: ,weighted_parameter_id BIS_WEIGHTED_MEASURE_PARAMS.weighted_parameter_id%TYPE
44: --,weighted_definition_id BIS_WEIGHTED_MEASURE_DEFNS.weighted_definition_id%TYPE
37: ,viewby_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dim_level_short_name%TYPE
38: ,filter_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dimension_short_name%TYPE
39: ,filter_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dim_level_short_name%TYPE
40: ,time_dimension_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dimension_short_name%TYPE
41: ,time_dim_level_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dim_level_short_name%TYPE
42: ---------------------------- BIS_WEIGHTED_MEASURE_PARAMETERS
43: ,weighted_parameter_id BIS_WEIGHTED_MEASURE_PARAMS.weighted_parameter_id%TYPE
44: --,weighted_definition_id BIS_WEIGHTED_MEASURE_DEFNS.weighted_definition_id%TYPE
45: ,time_level_value_id BIS_WEIGHTED_MEASURE_PARAMS.time_level_value_id%TYPE
40: ,time_dimension_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dimension_short_name%TYPE
41: ,time_dim_level_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dim_level_short_name%TYPE
42: ---------------------------- BIS_WEIGHTED_MEASURE_PARAMETERS
43: ,weighted_parameter_id BIS_WEIGHTED_MEASURE_PARAMS.weighted_parameter_id%TYPE
44: --,weighted_definition_id BIS_WEIGHTED_MEASURE_DEFNS.weighted_definition_id%TYPE
45: ,time_level_value_id BIS_WEIGHTED_MEASURE_PARAMS.time_level_value_id%TYPE
46: ,filter_level_value_id BIS_WEIGHTED_MEASURE_PARAMS.filter_level_value_id%TYPE
47: ----------------------------- BIS_WEIGHTED_MEASURE_WEIGHTS
48: ,weight_id bis_weighted_measure_weights.weight_id%TYPE
121: ,x_msg_count OUT NOCOPY NUMBER
122: ,x_msg_data OUT NOCOPY VARCHAR2
123: );
124:
125: ------- APIs for table BIS_WEIGHTED_MEASURE_DEFNS
126:
127: PROCEDURE Create_WM_Definition(
128: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
129: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
276:
277: ********* WRAPPER APIS FOR RECORD APIS *****************
278:
279: ***************************************************************************/
280: ------- APIs for table BIS_WEIGHTED_MEASURE_DEFNS
281:
282: PROCEDURE Create_WM_Definition(
283: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
284: ,p_weighted_definition_id IN NUMBER