eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_DIMENSION_LEVELS_PVT dependencies on BSC_DIMENSION_LEVELS_PUB

Line 86: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

82: -- Stubbed for Bug#3739872
83:
84: procedure Create_Dim_Level(
85: p_commit IN varchar2 := FND_API.G_FALSE
86: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
87: ,x_return_status OUT NOCOPY varchar2
88: ,x_msg_count OUT NOCOPY number
89: ,x_msg_data OUT NOCOPY varchar2
90: ) is

Line 114: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

110: ************************************************************************************/
111:
112: procedure Retrieve_Dim_Level(
113: p_commit IN varchar2 := FND_API.G_FALSE
114: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
115: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
116: ,x_return_status OUT NOCOPY varchar2
117: ,x_msg_count OUT NOCOPY number
118: ,x_msg_data OUT NOCOPY varchar2

Line 115: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

111:
112: procedure Retrieve_Dim_Level(
113: p_commit IN varchar2 := FND_API.G_FALSE
114: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
115: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
116: ,x_return_status OUT NOCOPY varchar2
117: ,x_msg_count OUT NOCOPY number
118: ,x_msg_data OUT NOCOPY varchar2
119: ) is

Line 183: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

179: ************************************************************************************/
180:
181: procedure Update_Dim_Level(
182: p_commit IN varchar2 := FND_API.G_FALSE
183: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
184: ,x_return_status OUT NOCOPY varchar2
185: ,x_msg_count OUT NOCOPY number
186: ,x_msg_data OUT NOCOPY varchar2
187: ) is

Line 251: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

247: ************************************************************************************/
248:
249: procedure Delete_Dim_Level(
250: p_commit IN varchar2 := FND_API.G_FALSE
251: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
252: ,x_return_status OUT NOCOPY varchar2
253: ,x_msg_count OUT NOCOPY number
254: ,x_msg_data OUT NOCOPY varchar2
255: ) is

Line 261: l_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

257: l_sql varchar2(1000);
258:
259: l_count number;
260: l_view_name varchar2(100);
261: l_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
262: CURSOR c_drop_tabs IS
263: SELECT LEVEL_TABLE_NAME,
264: LEVEL_VIEW_NAME,
265: NVL(SOURCE, 'BSC') SOURCE

Line 435: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

431: --: This procedure is part of the Dimension API.
432:
433: procedure Create_Bsc_Dim_Levels_Md(
434: p_commit IN varchar2 := FND_API.G_FALSE
435: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
436: ,x_return_status OUT NOCOPY varchar2
437: ,x_msg_count OUT NOCOPY number
438: ,x_msg_data OUT NOCOPY varchar2
439: ) is

Line 441: l_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

437: ,x_msg_count OUT NOCOPY number
438: ,x_msg_data OUT NOCOPY varchar2
439: ) is
440:
441: l_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
442: l_count number;
443: l_level_view_name VARCHAR2(30);
444: begin
445: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 601: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

597: ************************************************************************************/
598:
599: procedure Retrieve_Bsc_Dim_Levels_Md(
600: p_commit IN varchar2 := FND_API.G_FALSE
601: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
602: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
603: ,x_return_status OUT NOCOPY varchar2
604: ,x_msg_count OUT NOCOPY number
605: ,x_msg_data OUT NOCOPY varchar2

Line 602: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

598:
599: procedure Retrieve_Bsc_Dim_Levels_Md(
600: p_commit IN varchar2 := FND_API.G_FALSE
601: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
602: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
603: ,x_return_status OUT NOCOPY varchar2
604: ,x_msg_count OUT NOCOPY number
605: ,x_msg_data OUT NOCOPY varchar2
606: ) is

Line 711: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

707: ************************************************************************************/
708:
709: procedure Update_Bsc_Dim_Levels_Md(
710: p_commit IN varchar2 := FND_API.G_FALSE
711: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
712: ,x_return_status OUT NOCOPY varchar2
713: ,x_msg_count OUT NOCOPY number
714: ,x_msg_data OUT NOCOPY varchar2
715: ) is

Line 717: l_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

713: ,x_msg_count OUT NOCOPY number
714: ,x_msg_data OUT NOCOPY varchar2
715: ) is
716:
717: l_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
718: l_level_view_name VARCHAR2(30);
719: l_count number;
720:
721: begin

Line 906: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

902: ************************************************************************************/
903:
904: procedure Delete_Bsc_Dim_Levels_Md(
905: p_commit IN varchar2 := FND_API.G_FALSE
906: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
907: ,x_return_status OUT NOCOPY varchar2
908: ,x_msg_count OUT NOCOPY number
909: ,x_msg_data OUT NOCOPY varchar2
910: ) is

Line 989: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

985: --: This procedure is part of the Dimension API.
986:
987: procedure Create_Bsc_Sys_Dim_Lvl_Cols(
988: p_commit IN varchar2 := FND_API.G_FALSE
989: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
990: ,x_return_status OUT NOCOPY varchar2
991: ,x_msg_count OUT NOCOPY number
992: ,x_msg_data OUT NOCOPY varchar2
993: ) is

Line 1085: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

1081: ************************************************************************************/
1082:
1083: procedure Retrieve_Bsc_Sys_Dim_Lvl_Cols(
1084: p_commit IN varchar2 := FND_API.G_FALSE
1085: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
1086: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
1087: ,x_return_status OUT NOCOPY varchar2
1088: ,x_msg_count OUT NOCOPY number
1089: ,x_msg_data OUT NOCOPY varchar2

Line 1086: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

1082:
1083: procedure Retrieve_Bsc_Sys_Dim_Lvl_Cols(
1084: p_commit IN varchar2 := FND_API.G_FALSE
1085: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
1086: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
1087: ,x_return_status OUT NOCOPY varchar2
1088: ,x_msg_count OUT NOCOPY number
1089: ,x_msg_data OUT NOCOPY varchar2
1090: ) is

Line 1150: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

1146: ************************************************************************************/
1147:
1148: procedure Update_Bsc_Sys_Dim_Lvl_Cols(
1149: p_commit IN varchar2 := FND_API.G_FALSE
1150: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
1151: ,x_return_status OUT NOCOPY varchar2
1152: ,x_msg_count OUT NOCOPY number
1153: ,x_msg_data OUT NOCOPY varchar2
1154: ) is

Line 1156: l_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

1152: ,x_msg_count OUT NOCOPY number
1153: ,x_msg_data OUT NOCOPY varchar2
1154: ) is
1155:
1156: l_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
1157:
1158: l_count number;
1159:
1160: begin

Line 1248: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

1244: ************************************************************************************/
1245:
1246: procedure Delete_Bsc_Sys_Dim_Lvl_Cols(
1247: p_commit IN varchar2 := FND_API.G_FALSE
1248: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
1249: ,x_return_status OUT NOCOPY varchar2
1250: ,x_msg_count OUT NOCOPY number
1251: ,x_msg_data OUT NOCOPY varchar2
1252: ) is

Line 1760: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

1756: Create_Dim_Level_Relation
1757: ---------------------------------------------------------------------------------------*/
1758: PROCEDURE Create_Dim_Level_Relation(
1759: p_commit IN varchar2 := FND_API.G_FALSE
1760: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
1761: ,x_return_status OUT NOCOPY varchar2
1762: ,x_msg_count OUT NOCOPY number
1763: ,x_msg_data OUT NOCOPY varchar2
1764: ) IS

Line 1960: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

1956: p_Dim_Level_Rec.Bsc_Parent_Level_Id
1957: ---------------------------------------------------------------------------------------*/
1958: PROCEDURE Delete_Dim_Level_Relation(
1959: p_commit IN varchar2 := FND_API.G_FALSE
1960: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
1961: ,x_return_status OUT NOCOPY varchar2
1962: ,x_msg_count OUT NOCOPY number
1963: ,x_msg_data OUT NOCOPY varchar2
1964: ) IS

Line 2155: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

2151: Create_BSC_Dim_Level_View
2152: ---------------------------------------------------------------------------------------*/
2153: PROCEDURE Create_BSC_Dim_Level_View (
2154: p_commit IN varchar2 := FND_API.G_FALSE
2155: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
2156: ,x_return_status OUT NOCOPY varchar2
2157: ,x_msg_count OUT NOCOPY number
2158: ,x_msg_data OUT NOCOPY varchar2
2159: )IS

Line 2226: p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

2222:
2223:
2224: procedure Retrieve_Relationship
2225: (
2226: p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
2227: , x_Dim_Level_Rec OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
2228: , x_return_status OUT NOCOPY VARCHAR2
2229: , x_msg_count OUT NOCOPY NUMBER
2230: , x_msg_data OUT NOCOPY VARCHAR2

Line 2227: , x_Dim_Level_Rec OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

2223:
2224: procedure Retrieve_Relationship
2225: (
2226: p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
2227: , x_Dim_Level_Rec OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
2228: , x_return_status OUT NOCOPY VARCHAR2
2229: , x_msg_count OUT NOCOPY NUMBER
2230: , x_msg_data OUT NOCOPY VARCHAR2
2231: ) IS

Line 2621: p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

2617:
2618: --================================================================================================
2619: --
2620: PROCEDURE Retr_Updated_Bsc_Dim_Levels(
2621: p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
2622: ,x_Dim_Level_Rec OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
2623: ,x_return_status OUT NOCOPY VARCHAR2
2624: ,x_msg_count OUT NOCOPY NUMBER
2625: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2622: ,x_Dim_Level_Rec OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

2618: --================================================================================================
2619: --
2620: PROCEDURE Retr_Updated_Bsc_Dim_Levels(
2621: p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
2622: ,x_Dim_Level_Rec OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
2623: ,x_return_status OUT NOCOPY VARCHAR2
2624: ,x_msg_count OUT NOCOPY NUMBER
2625: ,x_msg_data OUT NOCOPY VARCHAR2
2626: ) IS

Line 2708: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

2704: --
2705: PROCEDURE Translate_Dimension_Level (
2706: p_Commit IN VARCHAR2 := FND_API.G_FALSE
2707: ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
2708: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
2709: ,x_return_status OUT NOCOPY VARCHAR2
2710: ,x_msg_count OUT NOCOPY NUMBER
2711: ,x_msg_data OUT NOCOPY VARCHAR2
2712: )

Line 2714: l_Dim_Level_Rec_In BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

2710: ,x_msg_count OUT NOCOPY NUMBER
2711: ,x_msg_data OUT NOCOPY VARCHAR2
2712: )
2713: IS
2714: l_Dim_Level_Rec_In BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
2715: l_Dim_Level_Rec_Out BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
2716:
2717: BEGIN
2718:

Line 2715: l_Dim_Level_Rec_Out BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

2711: ,x_msg_data OUT NOCOPY VARCHAR2
2712: )
2713: IS
2714: l_Dim_Level_Rec_In BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
2715: l_Dim_Level_Rec_Out BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
2716:
2717: BEGIN
2718:
2719: SAVEPOINT TranslateBSCDimLevPVT;

Line 2788: , p_dim_level_rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

2784: *************************************************************************************/
2785:
2786: procedure Trans_DimObj_By_Given_Lang
2787: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
2788: , p_dim_level_rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
2789: , x_return_status OUT NOCOPY VARCHAR2
2790: , x_msg_count OUT NOCOPY NUMBER
2791: , x_msg_data OUT NOCOPY VARCHAR2
2792: )