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_PUB dependencies on FND_API

Line 90: p_commit IN varchar2 := FND_API.G_FALSE

86: -- Procedure to Create all pertaining information for a given Dimension Level.
87: -- Though all procedures in this package may be called individually, this
88: -- procedure is the entry point to populate all meta data for dimension levels.
89: procedure Create_Dim_Level(
90: p_commit IN varchar2 := FND_API.G_FALSE
91: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
92: ,x_return_status OUT NOCOPY varchar2
93: ,x_msg_count OUT NOCOPY number
94: ,x_msg_data OUT NOCOPY varchar2

Line 98: p_commit IN varchar2 := FND_API.G_FALSE

94: ,x_msg_data OUT NOCOPY varchar2
95: );
96:
97: procedure Retrieve_Dim_Level(
98: p_commit IN varchar2 := FND_API.G_FALSE
99: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
100: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
101: ,x_return_status OUT NOCOPY varchar2
102: ,x_msg_count OUT NOCOPY number

Line 106: p_commit IN varchar2 := FND_API.G_FALSE

102: ,x_msg_count OUT NOCOPY number
103: ,x_msg_data OUT NOCOPY varchar2
104: );
105: procedure Create_Dim_Level(
106: p_commit IN varchar2 := FND_API.G_FALSE
107: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
108: ,p_create_tables IN BOOLEAN
109: ,x_return_status OUT NOCOPY varchar2
110: ,x_msg_count OUT NOCOPY number

Line 115: p_commit IN varchar2 := FND_API.G_FALSE

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

Line 126: p_commit IN varchar2 := FND_API.G_FALSE

122: -- Procedure to Delete all pertaining information for a given Dimension Level.
123: -- Though all procedures in this package may be called individually, this
124: -- procedure is the entry point to delete all meta data for dimension levels.
125: procedure Delete_Dim_Level(
126: p_commit IN varchar2 := FND_API.G_FALSE
127: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
128: ,x_return_status OUT NOCOPY varchar2
129: ,x_msg_count OUT NOCOPY number
130: ,x_msg_data OUT NOCOPY varchar2

Line 135: p_commit IN varchar2 := FND_API.G_FALSE

131: );
132:
133: -- Procedure to Populate the necessary meta data in BSC for a dimension level.
134: procedure Create_Bsc_Dim_Levels_Md(
135: p_commit IN varchar2 := FND_API.G_FALSE
136: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
137: ,x_return_status OUT NOCOPY varchar2
138: ,x_msg_count OUT NOCOPY number
139: ,x_msg_data OUT NOCOPY varchar2

Line 143: p_commit IN varchar2 := FND_API.G_FALSE

139: ,x_msg_data OUT NOCOPY varchar2
140: );
141:
142: procedure Retrieve_Bsc_Dim_Levels_Md(
143: p_commit IN varchar2 := FND_API.G_FALSE
144: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
145: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
146: ,x_return_status OUT NOCOPY varchar2
147: ,x_msg_count OUT NOCOPY number

Line 152: p_commit IN varchar2 := FND_API.G_FALSE

148: ,x_msg_data OUT NOCOPY varchar2
149: );
150:
151: procedure Update_Bsc_Dim_Levels_Md(
152: p_commit IN varchar2 := FND_API.G_FALSE
153: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
154: ,x_return_status OUT NOCOPY varchar2
155: ,x_msg_count OUT NOCOPY number
156: ,x_msg_data OUT NOCOPY varchar2

Line 161: p_commit IN varchar2 := FND_API.G_FALSE

157: );
158:
159: -- Procedure to Delete the necessary meta data in BSC for a dimension level.
160: procedure Delete_Bsc_Dim_Levels_Md(
161: p_commit IN varchar2 := FND_API.G_FALSE
162: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
163: ,x_return_status OUT NOCOPY varchar2
164: ,x_msg_count OUT NOCOPY number
165: ,x_msg_data OUT NOCOPY varchar2

Line 171: p_commit IN varchar2 := FND_API.G_FALSE

167:
168: -- Procedure to Populate information on the columns for the dimension level
169: -- view or table.
170: procedure Create_Bsc_Sys_Dim_Lvl_Cols(
171: p_commit IN varchar2 := FND_API.G_FALSE
172: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
173: ,x_return_status OUT NOCOPY varchar2
174: ,x_msg_count OUT NOCOPY number
175: ,x_msg_data OUT NOCOPY varchar2

Line 179: p_commit IN varchar2 := FND_API.G_FALSE

175: ,x_msg_data OUT NOCOPY varchar2
176: );
177:
178: procedure Retrieve_Bsc_Sys_Dim_Lvl_Cols(
179: p_commit IN varchar2 := FND_API.G_FALSE
180: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
181: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
182: ,x_return_status OUT NOCOPY varchar2
183: ,x_msg_count OUT NOCOPY number

Line 188: p_commit IN varchar2 := FND_API.G_FALSE

184: ,x_msg_data OUT NOCOPY varchar2
185: );
186:
187: procedure Update_Bsc_Sys_Dim_Lvl_Cols(
188: p_commit IN varchar2 := FND_API.G_FALSE
189: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
190: ,x_return_status OUT NOCOPY varchar2
191: ,x_msg_count OUT NOCOPY number
192: ,x_msg_data OUT NOCOPY varchar2

Line 198: p_commit IN varchar2 := FND_API.G_FALSE

194:
195: -- Procedure to Delete information on the columns for the dimension level
196: -- view or table.
197: procedure Delete_Bsc_Sys_Dim_Lvl_Cols(
198: p_commit IN varchar2 := FND_API.G_FALSE
199: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
200: ,x_return_status OUT NOCOPY varchar2
201: ,x_msg_count OUT NOCOPY number
202: ,x_msg_data OUT NOCOPY varchar2

Line 211: p_commit IN varchar2 := FND_API.G_FALSE

207: **********************************************************************************/
208:
209: -- Thi procedure is the entry point to create Dimension Level Relationships
210: PROCEDURE Create_Dim_Level_Relation(
211: p_commit IN varchar2 := FND_API.G_FALSE
212: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
213: ,x_return_status OUT NOCOPY varchar2
214: ,x_msg_count OUT NOCOPY number
215: ,x_msg_data OUT NOCOPY varchar2

Line 219: p_commit IN varchar2 := FND_API.G_FALSE

215: ,x_msg_data OUT NOCOPY varchar2
216: );
217: ----------
218: PROCEDURE Delete_Dim_Level_Relation(
219: p_commit IN varchar2 := FND_API.G_FALSE
220: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
221: ,x_return_status OUT NOCOPY varchar2
222: ,x_msg_count OUT NOCOPY number
223: ,x_msg_data OUT NOCOPY varchar2

Line 227: p_commit IN varchar2 := FND_API.G_FALSE

223: ,x_msg_data OUT NOCOPY varchar2
224: );
225: -----------
226: FUNCTION Is_Valid_Relationship(
227: p_commit IN varchar2 := FND_API.G_FALSE
228: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
229: ,x_return_status OUT NOCOPY varchar2
230: ,x_msg_count OUT NOCOPY number
231: ,x_msg_data OUT NOCOPY varchar2

Line 235: p_commit IN varchar2 := FND_API.G_FALSE

231: ,x_msg_data OUT NOCOPY varchar2
232: ) RETURN BOOLEAN;
233: -----------
234: PROCEDURE is_dependent(
235: p_commit IN varchar2 := FND_API.G_FALSE
236: ,p_child_dim_level_short_name IN varchar2
237: ,p_parent_dim_level_short_name IN varchar2
238: ,x_return_value OUT NOCOPY varchar2
239: ,x_return_status OUT NOCOPY varchar2 /* return FND_API.G_FALSE or FND_API.G_TRUE */

Line 239: ,x_return_status OUT NOCOPY varchar2 /* return FND_API.G_FALSE or FND_API.G_TRUE */

235: p_commit IN varchar2 := FND_API.G_FALSE
236: ,p_child_dim_level_short_name IN varchar2
237: ,p_parent_dim_level_short_name IN varchar2
238: ,x_return_value OUT NOCOPY varchar2
239: ,x_return_status OUT NOCOPY varchar2 /* return FND_API.G_FALSE or FND_API.G_TRUE */
240: ,x_msg_count OUT NOCOPY number
241: ,x_msg_data OUT NOCOPY varchar2
242: );
243:

Line 245: p_commit IN varchar2 := FND_API.G_FALSE

241: ,x_msg_data OUT NOCOPY varchar2
242: );
243:
244: PROCEDURE get_parent_dimension_levels(
245: p_commit IN varchar2 := FND_API.G_FALSE
246: ,p_child_dim_level_short_name IN varchar2
247: ,p_parent_dim_level_short_names OUT NOCOPY varchar2
248: ,x_return_status OUT NOCOPY varchar2 /* return FND_API.G_FALSE or FND_API.G_TRUE */
249: ,x_msg_count OUT NOCOPY number

Line 248: ,x_return_status OUT NOCOPY varchar2 /* return FND_API.G_FALSE or FND_API.G_TRUE */

244: PROCEDURE get_parent_dimension_levels(
245: p_commit IN varchar2 := FND_API.G_FALSE
246: ,p_child_dim_level_short_name IN varchar2
247: ,p_parent_dim_level_short_names OUT NOCOPY varchar2
248: ,x_return_status OUT NOCOPY varchar2 /* return FND_API.G_FALSE or FND_API.G_TRUE */
249: ,x_msg_count OUT NOCOPY number
250: ,x_msg_data OUT NOCOPY varchar2
251: );
252:

Line 254: p_commit IN varchar2 := FND_API.G_FALSE

250: ,x_msg_data OUT NOCOPY varchar2
251: );
252:
253: PROCEDURE get_child_dimension_levels(
254: p_commit IN varchar2 := FND_API.G_FALSE
255: ,p_parent_dim_level_short_name IN varchar2
256: ,p_child_dim_level_short_names OUT NOCOPY varchar2
257: ,x_return_status OUT NOCOPY varchar2 /* return FND_API.G_FALSE or FND_API.G_TRUE */
258: ,x_msg_count OUT NOCOPY number

Line 257: ,x_return_status OUT NOCOPY varchar2 /* return FND_API.G_FALSE or FND_API.G_TRUE */

253: PROCEDURE get_child_dimension_levels(
254: p_commit IN varchar2 := FND_API.G_FALSE
255: ,p_parent_dim_level_short_name IN varchar2
256: ,p_child_dim_level_short_names OUT NOCOPY varchar2
257: ,x_return_status OUT NOCOPY varchar2 /* return FND_API.G_FALSE or FND_API.G_TRUE */
258: ,x_msg_count OUT NOCOPY number
259: ,x_msg_data OUT NOCOPY varchar2
260: );
261:

Line 267: -- Values returned wouid be in x_return_status (FND_API.G_FALSE or FND_API.G_TRUE)

263: -- is_Child_Parent :
264: -- Check to see if the passed Dim Level Ids form a Parent child relationship.
265: --
266: -- Added by ADRAO for Enh#2901823
267: -- Values returned wouid be in x_return_status (FND_API.G_FALSE or FND_API.G_TRUE)
268: --------------------------------------------------------------------------------------
269: -----------
270: FUNCTION is_Child_Parent
271: (

Line 300: p_Commit IN VARCHAR2 := FND_API.G_FALSE

296: );
297: /*********************************************************************************
298: **********************************************************************************/
299: PROCEDURE Translate_Dimension_Level (
300: p_Commit IN VARCHAR2 := FND_API.G_FALSE
301: ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
302: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
303: ,x_return_status OUT NOCOPY VARCHAR2
304: ,x_msg_count OUT NOCOPY NUMBER

Line 310: p_commit IN VARCHAR2 := FND_API.G_FALSE

306: );
307: --
308: --
309: PROCEDURE load_dimension_level(
310: p_commit IN VARCHAR2 := FND_API.G_FALSE
311: ,p_dim_level_rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
312: ,x_return_status OUT NOCOPY VARCHAR2
313: ,x_msg_count OUT NOCOPY NUMBER
314: ,x_msg_data OUT NOCOPY VARCHAR2

Line 320: p_commit IN VARCHAR2 := FND_API.G_FALSE

316: --
317:
318: PROCEDURE Trans_DimObj_By_Given_Lang
319: (
320: p_commit IN VARCHAR2 := FND_API.G_FALSE
321: , p_dim_level_rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
322: , x_return_status OUT NOCOPY VARCHAR2
323: , x_msg_count OUT NOCOPY NUMBER
324: , x_msg_data OUT NOCOPY VARCHAR2