DBA Data[Home] [Help]

APPS.BSC_MIGRATION dependencies on BIS_DIMENSION_LEVEL_PUB

Line 6220: h_bis_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

6216: WHERE sbsc_dl.short_name = spmf_dl.short_name AND
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);

Line 6247: BIS_DIMENSION_LEVEL_PUB.Delete_Dimension_Level (

6243:
6244: FOR i IN 1..h_num_ids LOOP
6245: h_bis_dim_level_rec.dimension_level_id := h_arr_ids(i);
6246:
6247: BIS_DIMENSION_LEVEL_PUB.Delete_Dimension_Level (
6248: p_commit => FND_API.G_FALSE
6249: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
6250: ,p_Dimension_Level_Rec => h_bis_dim_level_rec
6251: ,x_return_status => h_return_status

Line 7402: h_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

7398:
7399: h_pmf VARCHAR2(3) := 'PMF';
7400: h_count NUMBER;
7401:
7402: h_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
7403:
7404: h_dimension_level_short_name VARCHAR2(2000);
7405: h_dimension_short_name VARCHAR2(2000);
7406: h_dimension_name VARCHAR2(2000);

Line 7544: BIS_DIMENSION_LEVEL_PUB.Create_Dimension_Level(

7540: where short_name = h_dimension_level_short_name;
7541:
7542: IF h_count = 0 THEN
7543: -- Dimension level does not exists, create it
7544: BIS_DIMENSION_LEVEL_PUB.Create_Dimension_Level(
7545: p_api_version => 1.0
7546: , p_commit => FND_API.G_FALSE
7547: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7548: , p_Dimension_Level_Rec => h_dimension_level_rec

Line 7560: BIS_DIMENSION_LEVEL_PUB.Update_Dimension_Level(

7556: BSC_APPS.OUTPUT_FILE);
7557: END IF;
7558: ELSE
7559: -- Dimension level exists, update it
7560: BIS_DIMENSION_LEVEL_PUB.Update_Dimension_Level(
7561: p_api_version => 1.0
7562: , p_commit => FND_API.G_FALSE
7563: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7564: , p_Dimension_Level_Rec => h_dimension_level_rec

Line 7897: h_dimension_level_rec_in BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

7893: , x_error_msg OUT NOCOPY VARCHAR2
7894: ) IS
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:

Line 7898: h_dimension_level_rec_out BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

7894: ) IS
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;

Line 7905: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level(

7901:
7902: h_dimension_level_rec_in.dimension_level_short_name := p_dimension_level_short_name;
7903: h_api_version := 1.0;
7904:
7905: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level(
7906: p_api_version => h_api_version
7907: ,p_Dimension_Level_Rec => h_dimension_level_rec_in
7908: ,x_Dimension_Level_Rec => h_dimension_level_rec_out
7909: ,x_return_status => x_return_status