[Home] [Help]
2703: h_invalid_kpi NUMBER;
2704:
2705: --Fix bug#4226188 : need these new variables
2706: h_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
2707: h_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2708: h_return_status VARCHAR2(1);
2709: h_dgrp_dim VARCHAR2(50);
2710:
2711: BEGIN
6217: spmf_dl.created_by NOT IN (p1, p2,p3,p4);
6218:
6219: h_level_id NUMBER;
6220: h_bis_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
6221: h_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
6222: h_return_status VARCHAR2(1);
6223: h_msg_count NUMBER;
6224: h_msg_data VARCHAR2(2000);
6225:
6287: spmf_d.created_by NOT IN (p1, p2,p3,p4);
6288:
6289: h_dimension_id NUMBER;
6290: h_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
6291: h_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
6292: h_return_status VARCHAR2(1);
6293: h_msg_count NUMBER;
6294: h_msg_data VARCHAR2(2000);
6295:
6364: si.created_by NOT IN (p1, p2, p3,p4);
6365:
6366: h_indicator_id NUMBER;
6367: h_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
6368: h_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
6369: h_return_status VARCHAR2(1);
6370: h_msg_count NUMBER;
6371: h_msg_data VARCHAR2(2000);
6372:
7296: h_hide VARCHAR2(10);
7297: h_application_id NUMBER;
7298: h_return_status VARCHAR2(2000);
7299: h_error_msg VARCHAR2(2000);
7300: h_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
7301:
7302:
7303: BEGIN
7304: -- Enh#4697749
7423: h_primary_dim VARCHAR2(2000);
7424:
7425: h_return_status VARCHAR2(2000);
7426: h_error_msg VARCHAR2(2000);
7427: h_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
7428:
7429: h_level_source VARCHAR2(2000);
7430: h_create_level BOOLEAN;
7431:
7629: h_func_area_short_name VARCHAR2(2000);
7630:
7631: h_return_status VARCHAR2(2000);
7632: h_error_msg VARCHAR2(2000);
7633: h_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
7634:
7635: -- Enh#4697749 new variables
7636: h_region_code VARCHAR2(200);
7637:
7782: BIS_MEASURE_PUB.Create_Measure(
7783: p_api_version => 1.0
7784: , p_commit => FND_API.G_FALSE
7785: , p_Measure_Rec => h_measure_rec
7786: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
7787: , x_return_status => h_return_status
7788: , x_error_Tbl => h_error_tbl
7789: );
7790: commit;
7798: BIS_MEASURE_PUB.Update_Measure(
7799: p_api_version => 1.0
7800: , p_commit => FND_API.G_FALSE
7801: , p_Measure_Rec => h_measure_rec
7802: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
7803: , x_return_status => h_return_status
7804: , x_error_Tbl => h_error_tbl
7805: );
7806: commit;
7832: e_error EXCEPTION;
7833: h_api_version NUMBER;
7834: h_dimension_rec_in BIS_DIMENSION_PUB.Dimension_Rec_Type;
7835: h_dimension_rec_out BIS_DIMENSION_PUB.Dimension_Rec_Type;
7836: h_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
7837: BEGIN
7838:
7839: h_dimension_rec_in.dimension_short_name := p_dimension_short_name;
7840: h_api_version := 1.0;
7895: e_error EXCEPTION;
7896: h_api_version NUMBER;
7897: h_dimension_level_rec_in BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
7898: h_dimension_level_rec_out BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
7899: h_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
7900: BEGIN
7901:
7902: h_dimension_level_rec_in.dimension_level_short_name := p_dimension_level_short_name;
7903: h_api_version := 1.0;
7987: h_api_version NUMBER;
7988: h_all_info VARCHAR2(80);
7989: h_measure_rec_in BIS_MEASURE_PUB.Measure_Rec_Type;
7990: h_measure_rec_out BIS_MEASURE_PUB.Measure_Rec_Type;
7991: h_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
7992:
7993: BEGIN
7994:
7995: h_measure_rec_in.measure_short_name := p_measure_short_name;