DBA Data[Home] [Help]

APPS.BSC_MIGRATION dependencies on BIS_DIMENSION_PUB

Line 2706: h_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

2702: h_invalid_dim_level VARCHAR2(50);
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:

Line 6290: h_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

6286: WHERE sbsc_d.short_name = spmf_d.short_name AND
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);

Line 6317: BIS_DIMENSION_PUB.Delete_Dimension(

6313:
6314: FOR i IN 1..h_num_ids LOOP
6315: h_bis_dimension_rec.dimension_id := h_arr_ids(i);
6316:
6317: BIS_DIMENSION_PUB.Delete_Dimension(
6318: p_commit => FND_API.G_FALSE
6319: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
6320: ,p_Dimension_Rec => h_bis_dimension_rec
6321: ,x_return_status => h_return_status

Line 7292: h_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

7288:
7289: h_pmf VARCHAR2(3) := 'PMF';
7290: h_count NUMBER;
7291:
7292: h_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
7293: h_dimension_short_name VARCHAR2(2000);
7294: h_dimension_name VARCHAR2(2000);
7295: h_description VARCHAR2(2000);
7296: h_hide VARCHAR2(10);

Line 7353: BIS_DIMENSION_PUB.Create_Dimension(

7349: where short_name = h_dimension_short_name;
7350:
7351: IF h_count = 0 THEN
7352: -- Dimension does not exists, create it
7353: BIS_DIMENSION_PUB.Create_Dimension(
7354: p_api_version => 1.0
7355: , p_commit => FND_API.G_FALSE
7356: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7357: , p_Dimension_Rec => h_dimension_rec

Line 7368: BIS_DIMENSION_PUB.Update_Dimension(

7364: BSC_APPS.Write_Line_Log('Error creating dimension: '||h_error_tbl(1).Error_Description, BSC_APPS.OUTPUT_FILE);
7365: END IF;
7366: ELSE
7367: -- Dimension exists, update it
7368: BIS_DIMENSION_PUB.Update_Dimension(
7369: p_api_version => 1.0
7370: , p_commit => FND_API.G_FALSE
7371: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7372: , p_Dimension_Rec => h_dimension_rec

Line 7834: h_dimension_rec_in BIS_DIMENSION_PUB.Dimension_Rec_Type;

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

Line 7835: h_dimension_rec_out BIS_DIMENSION_PUB.Dimension_Rec_Type;

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

Line 7842: BIS_DIMENSION_PUB.Retrieve_Dimension(

7838:
7839: h_dimension_rec_in.dimension_short_name := p_dimension_short_name;
7840: h_api_version := 1.0;
7841:
7842: BIS_DIMENSION_PUB.Retrieve_Dimension(
7843: p_api_version => h_api_version
7844: ,p_Dimension_Rec => h_dimension_rec_in
7845: ,x_Dimension_Rec => h_dimension_rec_out
7846: ,x_return_status => x_return_status