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 40: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

36: -- Though all procedures in this package may be called individually, this
37: -- procedure is the entry point to populate all meta data for dimension levels.
38: procedure Create_Dim_Level(
39: p_commit IN varchar2 := FND_API.G_FALSE
40: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
41: ,x_return_status OUT NOCOPY varchar2
42: ,x_msg_count OUT NOCOPY number
43: ,x_msg_data OUT NOCOPY varchar2
44: );

Line 48: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

44: );
45:
46: procedure Retrieve_Dim_Level(
47: p_commit IN varchar2 := FND_API.G_FALSE
48: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
49: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
50: ,x_return_status OUT NOCOPY varchar2
51: ,x_msg_count OUT NOCOPY number
52: ,x_msg_data OUT NOCOPY varchar2

Line 49: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

45:
46: procedure Retrieve_Dim_Level(
47: p_commit IN varchar2 := FND_API.G_FALSE
48: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
49: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
50: ,x_return_status OUT NOCOPY varchar2
51: ,x_msg_count OUT NOCOPY number
52: ,x_msg_data OUT NOCOPY varchar2
53: );

Line 57: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

53: );
54:
55: procedure Update_Dim_Level(
56: p_commit IN varchar2 := FND_API.G_FALSE
57: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
58: ,x_return_status OUT NOCOPY varchar2
59: ,x_msg_count OUT NOCOPY number
60: ,x_msg_data OUT NOCOPY varchar2
61: );

Line 68: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

64: -- Though all procedures in this package may be called individually, this
65: -- procedure is the entry point to delete all meta data for dimension levels.
66: procedure Delete_Dim_Level(
67: p_commit IN varchar2 := FND_API.G_FALSE
68: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
69: ,x_return_status OUT NOCOPY varchar2
70: ,x_msg_count OUT NOCOPY number
71: ,x_msg_data OUT NOCOPY varchar2
72: );

Line 77: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

73:
74: -- Procedure to Populate the necessary meta data in BSC for a dimension level.
75: procedure Create_Bsc_Dim_Levels_Md(
76: p_commit IN varchar2 := FND_API.G_FALSE
77: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
78: ,x_return_status OUT NOCOPY varchar2
79: ,x_msg_count OUT NOCOPY number
80: ,x_msg_data OUT NOCOPY varchar2
81: );

Line 85: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

81: );
82:
83: procedure Retrieve_Bsc_Dim_Levels_Md(
84: p_commit IN varchar2 := FND_API.G_FALSE
85: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
86: ,x_Dim_Level_Rec IN OUT NOCOPY 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

Line 86: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

82:
83: procedure Retrieve_Bsc_Dim_Levels_Md(
84: p_commit IN varchar2 := FND_API.G_FALSE
85: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
86: ,x_Dim_Level_Rec IN OUT NOCOPY 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: );

Line 94: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

90: );
91:
92: procedure Update_Bsc_Dim_Levels_Md(
93: p_commit IN varchar2 := FND_API.G_FALSE
94: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
95: ,x_return_status OUT NOCOPY varchar2
96: ,x_msg_count OUT NOCOPY number
97: ,x_msg_data OUT NOCOPY varchar2
98: );

Line 103: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

99:
100: -- Procedure to Delete the necessary meta data in BSC for a dimension level.
101: procedure Delete_Bsc_Dim_Levels_Md(
102: p_commit IN varchar2 := FND_API.G_FALSE
103: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
104: ,x_return_status OUT NOCOPY varchar2
105: ,x_msg_count OUT NOCOPY number
106: ,x_msg_data OUT NOCOPY varchar2
107: );

Line 113: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

109: -- Procedure to Populate information on the columns for the dimension level
110: -- view or table.
111: procedure Create_Bsc_Sys_Dim_Lvl_Cols(
112: p_commit IN varchar2 := FND_API.G_FALSE
113: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
114: ,x_return_status OUT NOCOPY varchar2
115: ,x_msg_count OUT NOCOPY number
116: ,x_msg_data OUT NOCOPY varchar2
117: );

Line 121: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

117: );
118:
119: procedure Retrieve_Bsc_Sys_Dim_Lvl_Cols(
120: p_commit IN varchar2 := FND_API.G_FALSE
121: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
122: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
123: ,x_return_status OUT NOCOPY varchar2
124: ,x_msg_count OUT NOCOPY number
125: ,x_msg_data OUT NOCOPY varchar2

Line 122: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

118:
119: procedure Retrieve_Bsc_Sys_Dim_Lvl_Cols(
120: p_commit IN varchar2 := FND_API.G_FALSE
121: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
122: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
123: ,x_return_status OUT NOCOPY varchar2
124: ,x_msg_count OUT NOCOPY number
125: ,x_msg_data OUT NOCOPY varchar2
126: );

Line 130: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

126: );
127:
128: procedure Update_Bsc_Sys_Dim_Lvl_Cols(
129: p_commit IN varchar2 := FND_API.G_FALSE
130: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
131: ,x_return_status OUT NOCOPY varchar2
132: ,x_msg_count OUT NOCOPY number
133: ,x_msg_data OUT NOCOPY varchar2
134: );

Line 140: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

136: -- Procedure to Delete information on the columns for the dimension level
137: -- view or table.
138: procedure Delete_Bsc_Sys_Dim_Lvl_Cols(
139: p_commit IN varchar2 := FND_API.G_FALSE
140: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
141: ,x_return_status OUT NOCOPY varchar2
142: ,x_msg_count OUT NOCOPY number
143: ,x_msg_data OUT NOCOPY varchar2
144: );

Line 190: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

186: **********************************************************************************/
187: ---------
188: PROCEDURE Create_Dim_Level_Relation(
189: p_commit IN varchar2 := FND_API.G_FALSE
190: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
191: ,x_return_status OUT NOCOPY varchar2
192: ,x_msg_count OUT NOCOPY number
193: ,x_msg_data OUT NOCOPY varchar2
194: );

Line 198: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

194: );
195: ----------
196: PROCEDURE Delete_Dim_Level_Relation(
197: p_commit IN varchar2 := FND_API.G_FALSE
198: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
199: ,x_return_status OUT NOCOPY varchar2
200: ,x_msg_count OUT NOCOPY number
201: ,x_msg_data OUT NOCOPY varchar2
202: );

Line 225: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

221: ) RETURN number;
222: ----------
223: PROCEDURE Create_BSC_Dim_Level_View (
224: p_commit IN varchar2 := FND_API.G_FALSE
225: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
226: ,x_return_status OUT NOCOPY varchar2
227: ,x_msg_count OUT NOCOPY number
228: ,x_msg_data OUT NOCOPY varchar2
229: );

Line 234: p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

230:
231: ----------
232: procedure Retrieve_Relationship
233: (
234: p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
235: , x_Dim_Level_Rec OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
236: , x_return_status OUT NOCOPY VARCHAR2
237: , x_msg_count OUT NOCOPY NUMBER
238: , x_msg_data OUT NOCOPY VARCHAR2

Line 235: , x_Dim_Level_Rec OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

231: ----------
232: procedure Retrieve_Relationship
233: (
234: p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
235: , x_Dim_Level_Rec OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
236: , x_return_status OUT NOCOPY VARCHAR2
237: , x_msg_count OUT NOCOPY NUMBER
238: , x_msg_data OUT NOCOPY VARCHAR2
239: );

Line 257: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

253:
254: PROCEDURE Translate_Dimension_Level (
255: p_Commit IN VARCHAR2 := FND_API.G_FALSE
256: ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
257: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
258: ,x_return_status OUT NOCOPY VARCHAR2
259: ,x_msg_count OUT NOCOPY NUMBER
260: ,x_msg_data OUT NOCOPY VARCHAR2
261: );

Line 266: , p_dim_level_rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

262: --
263:
264: procedure Trans_DimObj_By_Given_Lang
265: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
266: , p_dim_level_rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
267: , x_return_status OUT NOCOPY VARCHAR2
268: , x_msg_count OUT NOCOPY NUMBER
269: , x_msg_data OUT NOCOPY VARCHAR2
270: );