DBA Data[Home] [Help]

APPS.BIS_MEASURE_PVT dependencies on BIS_MEASURE_PUB

Line 43: --, p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

39: -- Procedure Create_Measure
40: --( p_api_version IN NUMBER
41: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
42: --, p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
43: --, p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
44: --, x_return_status OUT NOCOPY VARCHAR2
45: --, x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
46: --);
47: ----

Line 54: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

50: Procedure Create_Measure
51: ( p_api_version IN NUMBER
52: , p_commit IN VARCHAR2 := FND_API.G_FALSE
53: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
54: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
55: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
56: , x_return_status OUT NOCOPY VARCHAR2
57: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
58: );

Line 68: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

64: Procedure Create_Measure
65: ( p_api_version IN NUMBER
66: , p_commit IN VARCHAR2 := FND_API.G_FALSE
67: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
68: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
69: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
70: , p_Org_Dimension_ID IN NUMBER
71: , p_Time_Dimension_ID IN NUMBER
72: , x_return_status OUT NOCOPY VARCHAR2

Line 82: , x_Measure_tbl OUT NOCOPY BIS_MEASURE_PUB.Measure_Tbl_Type

78: -- FALSE
79: Procedure Retrieve_Measures
80: ( p_api_version IN NUMBER
81: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
82: , x_Measure_tbl OUT NOCOPY BIS_MEASURE_PUB.Measure_Tbl_Type
83: , x_return_status OUT NOCOPY VARCHAR2
84: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
85: );
86: --

Line 92: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

88: -- Gets Information for One Performance Measure
89: -- If information about the dimension are not required, set all_info to FALSE.
90: Procedure Retrieve_Measure
91: ( p_api_version IN NUMBER
92: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
93: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
94: , x_Measure_Rec IN OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
95: , x_return_status OUT NOCOPY VARCHAR2
96: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 94: , x_Measure_Rec IN OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

90: Procedure Retrieve_Measure
91: ( p_api_version IN NUMBER
92: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
93: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
94: , x_Measure_Rec IN OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
95: , x_return_status OUT NOCOPY VARCHAR2
96: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
97: );
98: --

Line 108: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

104: Procedure Update_Measure
105: ( p_api_version IN NUMBER
106: , p_commit IN VARCHAR2 := FND_API.G_FALSE
107: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
108: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
109: , x_return_status OUT NOCOPY VARCHAR2
110: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
111: );
112: --

Line 120: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

116: Procedure Update_Measure
117: ( p_api_version IN NUMBER
118: , p_commit IN VARCHAR2 := FND_API.G_FALSE
119: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
120: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
121: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
122: , x_return_status OUT NOCOPY VARCHAR2
123: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
124: );

Line 134: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

130: Procedure Update_Measure
131: ( p_api_version IN NUMBER
132: , p_commit IN VARCHAR2 := FND_API.G_FALSE
133: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
134: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
135: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
136: , p_Org_Dimension_ID IN NUMBER
137: , p_Time_Dimension_ID IN NUMBER
138: , x_return_status OUT NOCOPY VARCHAR2

Line 151: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

147: -- 3) no users have selected to see actuals for the Measure
148: Procedure Delete_Measure
149: ( p_api_version IN NUMBER
150: , p_commit IN VARCHAR2 := FND_API.G_FALSE
151: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
152: , x_return_status OUT NOCOPY VARCHAR2
153: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
154: );
155: --

Line 161: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

157: Procedure Translate_Measure
158: ( p_api_version IN NUMBER
159: , p_commit IN VARCHAR2 := FND_API.G_FALSE
160: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
161: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
162: , x_return_status OUT NOCOPY VARCHAR2
163: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
164: );
165: --

Line 170: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

166: Procedure Translate_Measure
167: ( p_api_version IN NUMBER
168: , p_commit IN VARCHAR2 := FND_API.G_FALSE
169: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
170: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
171: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
172: , x_return_status OUT NOCOPY VARCHAR2
173: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
174: );

Line 180: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

176: -- Validates measure
177: PROCEDURE Validate_Measure
178: ( p_api_version IN NUMBER
179: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
181: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
182: , x_return_status OUT NOCOPY VARCHAR2
183: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
184: );

Line 189: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type

185: --
186: -- Value - ID conversion
187: PROCEDURE Value_ID_Conversion
188: ( p_api_version IN NUMBER
189: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
190: , x_Measure_Rec IN OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
191: , x_return_status OUT NOCOPY VARCHAR2
192: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
193: );

Line 190: , x_Measure_Rec IN OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type

186: -- Value - ID conversion
187: PROCEDURE Value_ID_Conversion
188: ( p_api_version IN NUMBER
189: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
190: , x_Measure_Rec IN OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
191: , x_return_status OUT NOCOPY VARCHAR2
192: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
193: );
194: --

Line 206: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type

202: );
203: --
204: PROCEDURE Measure_Value_ID_Conversion
205: ( p_api_version IN NUMBER
206: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
207: , x_Measure_Rec OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
208: , x_return_status OUT NOCOPY VARCHAR2
209: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
210: );

Line 207: , x_Measure_Rec OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type

203: --
204: PROCEDURE Measure_Value_ID_Conversion
205: ( p_api_version IN NUMBER
206: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
207: , x_Measure_Rec OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
208: , x_return_status OUT NOCOPY VARCHAR2
209: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
210: );
211: --

Line 214: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type

210: );
211: --
212: PROCEDURE Dimension_Value_ID_Conversion
213: ( p_api_version IN NUMBER
214: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
215: , x_Measure_Rec IN OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
216: , x_return_status OUT NOCOPY VARCHAR2
217: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
218: );

Line 215: , x_Measure_Rec IN OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type

211: --
212: PROCEDURE Dimension_Value_ID_Conversion
213: ( p_api_version IN NUMBER
214: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
215: , x_Measure_Rec IN OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
216: , x_return_status OUT NOCOPY VARCHAR2
217: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
218: );
219: --

Line 222: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

218: );
219: --
220: Procedure Retrieve_Measure_Dimensions
221: ( p_api_version IN NUMBER
222: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
223: , x_dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type
224: , x_return_status OUT NOCOPY VARCHAR2
225: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
226: );

Line 230: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type

226: );
227: --
228: PROCEDURE Lock_Record
229: ( p_api_version IN NUMBER
230: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
231: , p_timestamp IN VARCHAR := NULL
232: , x_return_status OUT NOCOPY VARCHAR2
233: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
234: );

Line 238: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

234: );
235: --
236: PROCEDURE Retrieve_Last_Update_Date
237: ( p_api_version IN NUMBER
238: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
239: , x_last_update_date OUT NOCOPY DATE
240: , x_return_status OUT NOCOPY VARCHAR2
241: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
242: );

Line 248: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

244: -- creates one Measure, with the dimensions sequenced in the order
245: PROCEDURE Create_Application_Measure
246: ( p_api_version IN NUMBER
247: , p_commit IN VARCHAR2 := FND_API.G_FALSE
248: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
249: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
250: , p_owning_application IN VARCHAR2
251: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
252: , x_return_status OUT NOCOPY VARCHAR2

Line 259: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type

255: --
256: --
257: PROCEDURE Retrieve_Application_Measures
258: ( p_api_version IN NUMBER
259: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
260: , p_all_info IN VARCHAR2
261: , x_owning_application_rec OUT NOCOPY BIS_Application_PVT.Application_Rec_Type
262: , x_Application_tbl OUT NOCOPY BIS_Application_PVT.Application_Tbl_Type
263: , x_return_status OUT NOCOPY VARCHAR2

Line 271: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

267: --
268: PROCEDURE Update_Application_Measure
269: ( p_api_version IN NUMBER
270: , p_commit IN VARCHAR2 := FND_API.G_FALSE
271: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
272: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
273: , p_owning_application IN VARCHAR2
274: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
275: , x_return_status OUT NOCOPY VARCHAR2

Line 283: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

279: --
280: PROCEDURE Delete_Application_Measure
281: ( p_api_version IN NUMBER
282: , p_commit IN VARCHAR2 := FND_API.G_FALSE
283: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
284: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
285: , x_return_status OUT NOCOPY VARCHAR2
286: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
287: );

Line 292: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

288: --
289: PROCEDURE Delete_Application_Measures
290: ( p_api_version IN NUMBER
291: , p_commit IN VARCHAR2 := FND_API.G_FALSE
292: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
293: , x_return_status OUT NOCOPY VARCHAR2
294: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
295: );
296: --

Line 299: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

295: );
296: --
297: PROCEDURE Lock_Record
298: ( p_api_version IN NUMBER
299: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
300: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
301: , p_timestamp IN VARCHAR := NULL
302: , x_return_status OUT NOCOPY VARCHAR2
303: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 308: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

304: );
305: --
306: PROCEDURE Retrieve_Last_Update_Date
307: ( p_api_version IN NUMBER
308: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
309: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
310: , x_last_update_date OUT NOCOPY DATE
311: , x_return_status OUT NOCOPY VARCHAR2
312: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 325: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

321: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
322: );
323: --
324: PROCEDURE Create_Indicator_Dimensions
325: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
326: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
327: , x_return_status OUT NOCOPY VARCHAR2
328: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
329: );

Line 335: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

331: --Overload Create_Indicator_Dimensions so that old data model ldts can be uploaded using
332: --The latest lct file. The lct file can indirectly call this overloaded procedure
333: --by passing in Org and Time also
334: PROCEDURE Create_Indicator_Dimensions
335: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
336: , p_Org_Dimension_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
337: , p_Time_Dimension_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
338: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
339: , x_return_status OUT NOCOPY VARCHAR2

Line 345: (p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE

341: );
342:
343: --added new function to determine whether the data model is new or old while loading measures
344: FUNCTION IS_OLD_DATA_MODEL
345: (p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
346: ,p_Org_Dimension_Id IN NUMBER
347: ,p_Time_Dimension_Id IN NUMBER
348: )
349: RETURN BOOLEAN;

Line 354: (p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

350:
351: --OverLoad Dimension Count so that when loader tries to update a measure
352: --with an old ldt file, it will not fail
353: FUNCTION Dimension_Count
354: (p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
355: ,p_Org_Dimension_Id IN NUMBER
356: ,p_Time_Dimension_Id IN NUMBER
357: )
358: return NUMBER;

Line 370: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

366: -- mdamle 09/25/2003 - Sync up measures for all installed languages
367: Procedure Translate_Measure_by_lang
368: ( p_api_version IN NUMBER
369: , p_commit IN VARCHAR2 := FND_API.G_FALSE
370: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
371: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
372: , p_lang IN VARCHAR2
373: , p_source_lang IN VARCHAR2
374: , x_return_status OUT NOCOPY VARCHAR2

Line 396: ( p_measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

392: x_msg_data OUT nocopy VARCHAR2
393: );
394:
395: FUNCTION Get_Measure_Id_From_Short_Name
396: ( p_measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
397: ) RETURN NUMBER;
398:
399: END BIS_MEASURE_PVT;
400: