APPS.BSC_PMF_UI_WRAPPER dependencies on BSC_DIMENSION_LEVELS_PUB

Line 3912: v_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

3908: I INTEGER ;
3909:
3910: v_array_Dim_Levels t_of_Bsc_Dim_Level_Rec;
3911:
3912: v_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
3913: v_Bsc_Pmf_Dim_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type;
3914: v_commit varchar(5) := FND_API.G_FALSE;
3915:
3916: v_Dim_Level_Id number;

Line 4015: if BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship(v_commit, v_Dim_Level_Rec, x_return_status, x_msg_count, x_msg_data) then

4011: end if;
4012: --DBMS_OUTPUT.PUT_LINE('Update_RelationShip v_Dim_Level_Rec.Bsc_Parent_Level_Id = ' || v_Dim_Level_Rec.Bsc_Parent_Level_Id);
4013:
4014: -- Evaluate if the relation is valid --
4015: if BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship(v_commit, v_Dim_Level_Rec, x_return_status, x_msg_count, x_msg_data) then
4016: -- Set the Relation into the array --
4017: v_array_Dim_Levels(v_Dim_Level_Rec.Bsc_Parent_Level_Id):= v_Dim_Level_Rec;
4018: else
4019: v_Temp := false;

Line 4041: BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level_Relation(v_commit, v_Dim_Level_Rec

4037: if v_array_Dim_Levels.EXISTS(v_Dim_Level_Rec.Bsc_Parent_Level_Id) = false then
4038:
4039: --DBMS_OUTPUT.PUT_LINE('Update_RelationShip Delete_Dim_Level_Relation ' || v_Dim_Level_Rec.Bsc_Parent_Level_Id);
4040:
4041: BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level_Relation(v_commit, v_Dim_Level_Rec
4042: ,x_return_status, x_msg_count, x_msg_data);
4043: BSC_MULTI_USER_PVT. Apply_Multi_User_Env('DIM_LEVEL', v_Dim_Level_Rec.Bsc_Level_Id
4044: , null, null, null, 'LCK', null, x_return_status, x_msg_count ,x_msg_data);
4045: else

Line 4062: BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level_Relation(v_commit, v_Dim_Level_Rec

4058: v_Dim_Level_Rec := v_array_Dim_Levels(v_aux);
4059: if v_Dim_Level_Rec.Bsc_Flag = -999 then /* Flag for Update */
4060: --DBMS_OUTPUT.PUT_LINE('Update_RelationShip Delete ' || v_Dim_Level_Rec.Bsc_Parent_Level_Id );
4061:
4062: BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level_Relation(v_commit, v_Dim_Level_Rec
4063: ,x_return_status, x_msg_count, x_msg_data);
4064: end if;
4065: --DBMS_OUTPUT.PUT_LINE('Update_RelationShip Insert ' || v_Dim_Level_Rec.Bsc_Parent_Level_Id );
4066:

Line 4067: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation(v_commit, v_Dim_Level_Rec

4063: ,x_return_status, x_msg_count, x_msg_data);
4064: end if;
4065: --DBMS_OUTPUT.PUT_LINE('Update_RelationShip Insert ' || v_Dim_Level_Rec.Bsc_Parent_Level_Id );
4066:
4067: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation(v_commit, v_Dim_Level_Rec
4068: ,x_return_status, x_msg_count, x_msg_data);
4069:
4070: EXIT WHEN (v_aux = v_array_Dim_Levels.LAST);
4071: v_aux := v_array_Dim_Levels.NEXT(v_aux);

Line 4172: v_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

4168: ,p_RELATION_COL IN VARCHAR2
4169:
4170: ) is
4171:
4172: v_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
4173: x_return_status varchar2(3000);
4174: x_msg_count number;
4175: x_msg_data varchar2(3000);
4176: v_count number;

Line 4205: BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level_Relation(FND_API.G_FALSE, v_Dim_Level_Rec

4201:
4202: if v_count <> 0 then
4203: --DBMS_OUTPUT.PUT_LINE(' Create_PMF_Relationship Deleting Relation ');
4204:
4205: BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level_Relation(FND_API.G_FALSE, v_Dim_Level_Rec
4206: ,x_return_status, x_msg_count, x_msg_data);
4207: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
4208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4209: END IF;

Line 4211: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation(FND_API.G_FALSE, v_Dim_Level_Rec

4207: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
4208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4209: END IF;
4210: end if;
4211: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation(FND_API.G_FALSE, v_Dim_Level_Rec
4212: ,x_return_status, x_msg_count, x_msg_data);
4213: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
4214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4215: END IF;