DBA Data[Home] [Help]

APPS.BSC_DIMENSION_SETS_PUB dependencies on BSC_DIMENSION_SETS_PVT

Line 141: BSC_DIMENSION_SETS_PVT.Create_Dim_Group_In_Dset( p_commit

137: -- PAJOHRI added if condition.
138: -- if group_id is null, than don't insert into BSC_KPI_DIM_GROUPS
139: IF ((l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id IS NOT NULL) AND
140: (BSC_DIMENSION_SETS_PUB.Is_Valid_Dimension(l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id))) THEN
141: BSC_DIMENSION_SETS_PVT.Create_Dim_Group_In_Dset( p_commit
142: ,l_Dim_Set_Rec
143: ,x_return_status
144: ,x_msg_count
145: ,x_msg_data);

Line 321: BSC_DIMENSION_SETS_PVT.Retrieve_Dim_Group_In_Dset( p_commit

317: ) is
318:
319: begin
320: x_return_status := FND_API.G_RET_STS_SUCCESS;
321: BSC_DIMENSION_SETS_PVT.Retrieve_Dim_Group_In_Dset( p_commit
322: ,p_Dim_Set_Rec
323: ,x_Dim_Set_Rec
324: ,x_return_status
325: ,x_msg_count

Line 408: BSC_DIMENSION_SETS_PVT.Update_Dim_Group_In_Dset( p_commit

404: ) is
405: l_count NUMBER := 0;
406: begin
407: x_return_status := FND_API.G_RET_STS_SUCCESS;
408: BSC_DIMENSION_SETS_PVT.Update_Dim_Group_In_Dset( p_commit
409: ,p_Dim_Set_Rec
410: ,x_return_status
411: ,x_msg_count
412: ,x_msg_data);

Line 594: BSC_DIMENSION_SETS_PVT.Delete_Dim_Group_In_Dset( p_commit --BSC_KPI_DIM_GROUPS

590: FOR cd IN c_group_id LOOP
591: l_group_id := cd.dim_group_id;
592: l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id := l_group_id;
593:
594: BSC_DIMENSION_SETS_PVT.Delete_Dim_Group_In_Dset( p_commit --BSC_KPI_DIM_GROUPS
595: ,l_Dim_Set_Rec
596: ,x_return_status
597: ,x_msg_count
598: ,x_msg_data);

Line 623: BSC_DIMENSION_SETS_PVT.Delete_Dim_Group_In_Dset( p_commit --BSC_KPI_DIM_GROUPS

619: END LOOP;
620: END LOOP;
621: ELSE
622: l_group_id := l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id;
623: BSC_DIMENSION_SETS_PVT.Delete_Dim_Group_In_Dset( p_commit --BSC_KPI_DIM_GROUPS
624: ,l_Dim_Set_Rec
625: ,x_return_status
626: ,x_msg_count
627: ,x_msg_data);

Line 799: BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl( p_commit

795: ) is
796:
797: begin
798: x_return_status := FND_API.G_RET_STS_SUCCESS;
799: BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl( p_commit
800: ,p_Dim_Set_Rec
801: ,x_return_status
802: ,x_msg_count
803: ,x_msg_data);

Line 858: BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl( p_commit

854: ) is
855:
856: begin
857: x_return_status := FND_API.G_RET_STS_SUCCESS;
858: BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl( p_commit
859: ,p_Dim_Set_Rec
860: ,x_Dim_Set_Rec
861: ,x_return_status
862: ,x_msg_count

Line 916: BSC_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl( p_commit

912: ) is
913:
914: begin
915: x_return_status := FND_API.G_RET_STS_SUCCESS;
916: BSC_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl( p_commit
917: ,p_Dim_Set_Rec
918: ,x_return_status
919: ,x_msg_count
920: ,x_msg_data);

Line 976: BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl( p_commit

972: l_count number;
973:
974: begin
975: x_return_status := FND_API.G_RET_STS_SUCCESS;
976: BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl( p_commit
977: ,p_Dim_Set_Rec
978: ,x_return_status
979: ,x_msg_count
980: ,x_msg_data);

Line 1105: BSC_DIMENSION_SETS_PVT.Create_Dim_Level_Properties( p_commit

1101: l_Dim_Set_Rec(i).Bsc_Dset_Target_Level := l_Dim_Set_Rec(1).Bsc_Dset_Target_Level;
1102: end if;
1103:
1104: -- Call private version of the procedure.
1105: BSC_DIMENSION_SETS_PVT.Create_Dim_Level_Properties( p_commit
1106: ,l_Dim_Set_Rec(i)
1107: ,x_return_status
1108: ,x_msg_count
1109: ,x_msg_data);

Line 1167: BSC_DIMENSION_SETS_PVT.Retrieve_Dim_Level_Properties( p_commit

1163: ) is
1164:
1165: begin
1166: x_return_status := FND_API.G_RET_STS_SUCCESS;
1167: BSC_DIMENSION_SETS_PVT.Retrieve_Dim_Level_Properties( p_commit
1168: ,p_Dim_Set_Rec
1169: ,x_Dim_Set_Rec
1170: ,x_return_status
1171: ,x_msg_count

Line 1226: BSC_DIMENSION_SETS_PVT.Update_Dim_Level_Properties( p_commit

1222: ) is
1223:
1224: begin
1225: x_return_status := FND_API.G_RET_STS_SUCCESS;
1226: BSC_DIMENSION_SETS_PVT.Update_Dim_Level_Properties( p_commit
1227: ,p_Dim_Set_Rec
1228: ,x_return_status
1229: ,x_msg_count
1230: ,x_msg_data);

Line 1335: BSC_DIMENSION_SETS_PVT.Delete_Dim_Level_Properties( p_commit

1331: l_Dim_Set_Rec(i).Bsc_Source_Language := l_Dim_Set_Rec(1).Bsc_Source_Language;
1332: end if;
1333:
1334: -- Call private version of the procedure.
1335: BSC_DIMENSION_SETS_PVT.Delete_Dim_Level_Properties( p_commit
1336: ,l_Dim_Set_Rec(i)
1337: ,x_return_status
1338: ,x_msg_count
1339: ,x_msg_data);

Line 1603: BSC_DIMENSION_SETS_PVT.Create_Dim_Levels

1599: IF (p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
1600: -- Call private version of the procedure.
1601: --DBMS_OUTPUT.PUT_LINE(' Step 0');
1602:
1603: BSC_DIMENSION_SETS_PVT.Create_Dim_Levels
1604: (
1605: p_commit => p_commit
1606: , p_Dim_Set_Rec => p_Dim_Set_Rec
1607: , x_return_status => x_return_status

Line 1676: BSC_DIMENSION_SETS_PVT.Create_Dim_Levels

1672: l_Dim_Set_Rec.Bsc_Dset_Parent_Level_Rel := NULL;
1673: l_Dim_Set_Rec.Bsc_Dset_Parent_Level_Rel2 := NULL;
1674: l_Dim_Set_Rec.Bsc_Dset_Table_Relation := NULL;
1675: -- Call private version of the procedure.
1676: BSC_DIMENSION_SETS_PVT.Create_Dim_Levels
1677: (
1678: p_commit => p_commit
1679: , p_Dim_Set_Rec => l_Dim_Set_Rec
1680: , x_return_status => x_return_status

Line 1894: BSC_DIMENSION_SETS_PVT.Retrieve_Dim_Levels( p_commit

1890: ) is
1891:
1892: begin
1893: x_return_status := FND_API.G_RET_STS_SUCCESS;
1894: BSC_DIMENSION_SETS_PVT.Retrieve_Dim_Levels( p_commit
1895: ,p_Dim_Set_Rec
1896: ,x_Dim_Set_Rec
1897: ,x_return_status
1898: ,x_msg_count

Line 1954: BSC_DIMENSION_SETS_PVT.Update_Dim_Levels( p_commit

1950: l_count NUMBER;
1951: begin
1952: FND_MSG_PUB.Initialize;
1953: x_return_status := FND_API.G_RET_STS_SUCCESS;
1954: BSC_DIMENSION_SETS_PVT.Update_Dim_Levels( p_commit
1955: ,p_Dim_Set_Rec
1956: ,x_return_status
1957: ,x_msg_count
1958: ,x_msg_data);

Line 2129: BSC_DIMENSION_SETS_PVT.Delete_Dim_Levels( p_commit

2125: l_Dim_Set_Rec(i).Bsc_Source_Language := l_Dim_Set_Rec(1).Bsc_Source_Language;
2126: END IF;
2127:
2128: -- Call private version of the procedure.
2129: BSC_DIMENSION_SETS_PVT.Delete_Dim_Levels( p_commit
2130: ,l_Dim_Set_Rec(i)
2131: ,x_return_status
2132: ,x_msg_count
2133: ,x_msg_data);

Line 2138: BSC_DIMENSION_SETS_PVT.Delete_Dim_Levels( p_commit

2134:
2135: END LOOP;
2136: ELSE
2137: -- Call private version of the procedure.
2138: BSC_DIMENSION_SETS_PVT.Delete_Dim_Levels( p_commit
2139: ,p_Dim_Set_Rec
2140: ,x_return_status
2141: ,x_msg_count
2142: ,x_msg_data);

Line 2205: BSC_DIMENSION_SETS_PVT.Update_Kpi_Analysis_Options_B( p_commit

2201: ,x_msg_data OUT NOCOPY varchar2
2202: ) is
2203: begin
2204: x_return_status := FND_API.G_RET_STS_SUCCESS;
2205: BSC_DIMENSION_SETS_PVT.Update_Kpi_Analysis_Options_B( p_commit
2206: ,p_Dim_Set_Rec
2207: ,x_return_status
2208: ,x_msg_count
2209: ,x_msg_data);