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.BIS_WEIGHTED_MEASURE_PUB dependencies on FND_API

Line 79: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

75:
76: /*
77: -- This is tempporal whil it is tested
78: PROCEDURE Delete_Cascade_WM_Parameters(
79: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
80: ,p_weighted_definition_id IN NUMBER
81: ,x_return_status OUT NOCOPY VARCHAR2
82: ,x_msg_count OUT NOCOPY NUMBER
83: ,x_msg_data OUT NOCOPY VARCHAR2

Line 90: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

86:
87: ------- APIs for tables BIS_WEIGHTED_MEASURE_DEPENDS
88:
89: PROCEDURE Create_WM_Dependency(
90: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
91: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
92: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
93: ,x_return_status OUT NOCOPY VARCHAR2
94: ,x_msg_count OUT NOCOPY NUMBER

Line 99: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

95: ,x_msg_data OUT NOCOPY VARCHAR2
96: );
97:
98: PROCEDURE Retrieve_WM_Dependency(
99: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
100: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
101: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
102: ,x_return_status OUT NOCOPY VARCHAR2
103: ,x_msg_count OUT NOCOPY NUMBER

Line 108: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

104: ,x_msg_data OUT NOCOPY VARCHAR2
105: );
106:
107: PROCEDURE Update_WM_Dependency(
108: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
109: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
110: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
111: ,x_return_status OUT NOCOPY VARCHAR2
112: ,x_msg_count OUT NOCOPY NUMBER

Line 117: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

113: ,x_msg_data OUT NOCOPY VARCHAR2
114: );
115:
116: PROCEDURE Delete_WM_Dependency(
117: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
118: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
119: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
120: ,x_return_status OUT NOCOPY VARCHAR2
121: ,x_msg_count OUT NOCOPY NUMBER

Line 128: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

124:
125: ------- APIs for table BIS_WEIGHTED_MEASURE_DEFNS
126:
127: PROCEDURE Create_WM_Definition(
128: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
129: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
130: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
131: ,x_return_status OUT NOCOPY VARCHAR2
132: ,x_msg_count OUT NOCOPY NUMBER

Line 137: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

133: ,x_msg_data OUT NOCOPY VARCHAR2
134: );
135:
136: PROCEDURE Retrieve_WM_Definition(
137: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
138: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
139: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
140: ,x_return_status OUT NOCOPY VARCHAR2
141: ,x_msg_count OUT NOCOPY NUMBER

Line 146: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

142: ,x_msg_data OUT NOCOPY VARCHAR2
143: );
144:
145: PROCEDURE Update_WM_Definition(
146: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
147: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
148: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
149: ,x_return_status OUT NOCOPY VARCHAR2
150: ,x_msg_count OUT NOCOPY NUMBER

Line 155: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

151: ,x_msg_data OUT NOCOPY VARCHAR2
152: );
153:
154: PROCEDURE Delete_WM_Definition(
155: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
156: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
157: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
158: ,x_return_status OUT NOCOPY VARCHAR2
159: ,x_msg_count OUT NOCOPY NUMBER

Line 166: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

162:
163: ------- APIs for table BIS_WEIGHTED_MEASURE_PARAMS
164:
165: PROCEDURE Create_WM_Parameter(
166: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
167: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
168: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
169: ,x_return_status OUT NOCOPY VARCHAR2
170: ,x_msg_count OUT NOCOPY NUMBER

Line 175: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

171: ,x_msg_data OUT NOCOPY VARCHAR2
172: );
173:
174: PROCEDURE Retrieve_WM_Parameter(
175: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
176: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
177: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
178: ,x_return_status OUT NOCOPY VARCHAR2
179: ,x_msg_count OUT NOCOPY NUMBER

Line 184: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

180: ,x_msg_data OUT NOCOPY VARCHAR2
181: );
182:
183: PROCEDURE Update_WM_Parameter(
184: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
185: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
186: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
187: ,x_return_status OUT NOCOPY VARCHAR2
188: ,x_msg_count OUT NOCOPY NUMBER

Line 193: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

189: ,x_msg_data OUT NOCOPY VARCHAR2
190: );
191:
192: PROCEDURE Delete_WM_Parameter(
193: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
194: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
195: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
196: ,x_return_status OUT NOCOPY VARCHAR2
197: ,x_msg_count OUT NOCOPY NUMBER

Line 204: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

200:
201: ------- APIs for table BIS_WEIGHTED_MEASURE_WEIGHTS
202:
203: PROCEDURE Create_WM_Weight(
204: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
205: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
206: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
207: ,x_return_status OUT NOCOPY VARCHAR2
208: ,x_msg_count OUT NOCOPY NUMBER

Line 213: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

209: ,x_msg_data OUT NOCOPY VARCHAR2
210: );
211:
212: PROCEDURE Retrieve_WM_Weight(
213: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
214: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
215: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
216: ,x_return_status OUT NOCOPY VARCHAR2
217: ,x_msg_count OUT NOCOPY NUMBER

Line 222: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

218: ,x_msg_data OUT NOCOPY VARCHAR2
219: );
220:
221: PROCEDURE Update_WM_Weight(
222: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
223: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
224: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
225: ,x_return_status OUT NOCOPY VARCHAR2
226: ,x_msg_count OUT NOCOPY NUMBER

Line 231: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

227: ,x_msg_data OUT NOCOPY VARCHAR2
228: );
229:
230: PROCEDURE Delete_WM_Weight(
231: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
232: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
233: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
234: ,x_return_status OUT NOCOPY VARCHAR2
235: ,x_msg_count OUT NOCOPY NUMBER

Line 241: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

237: );
238:
239: ------- APIs for table BIS_WEIGHTED_MEASURE_SCORES
240: PROCEDURE Create_WM_Score(
241: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
242: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
243: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
244: ,x_return_status OUT NOCOPY VARCHAR2
245: ,x_msg_count OUT NOCOPY NUMBER

Line 250: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

246: ,x_msg_data OUT NOCOPY VARCHAR2
247: );
248:
249: PROCEDURE Retrieve_WM_Score(
250: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
251: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
252: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
253: ,x_return_status OUT NOCOPY VARCHAR2
254: ,x_msg_count OUT NOCOPY NUMBER

Line 259: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

255: ,x_msg_data OUT NOCOPY VARCHAR2
256: );
257:
258: PROCEDURE Update_WM_Score(
259: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
260: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
261: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
262: ,x_return_status OUT NOCOPY VARCHAR2
263: ,x_msg_count OUT NOCOPY NUMBER

Line 268: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

264: ,x_msg_data OUT NOCOPY VARCHAR2
265: );
266:
267: PROCEDURE Delete_WM_Score(
268: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
269: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
270: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
271: ,x_return_status OUT NOCOPY VARCHAR2
272: ,x_msg_count OUT NOCOPY NUMBER

Line 283: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

279: ***************************************************************************/
280: ------- APIs for table BIS_WEIGHTED_MEASURE_DEFNS
281:
282: PROCEDURE Create_WM_Definition(
283: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
284: ,p_weighted_definition_id IN NUMBER
285: ,p_weighted_measure_id IN NUMBER
286: ,p_viewby_dimension_sn IN VARCHAR2
287: ,p_viewby_dim_level_sn IN VARCHAR2

Line 313: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

309: ,x_msg_data OUT NOCOPY VARCHAR2
310: );
311:
312: PROCEDURE Update_WM_Definition(
313: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
314: ,p_weighted_definition_id IN NUMBER
315: ,p_weighted_measure_id IN NUMBER
316: ,p_viewby_dimension_sn IN VARCHAR2
317: ,p_viewby_dim_level_sn IN VARCHAR2

Line 328: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

324: ,x_msg_data OUT NOCOPY VARCHAR2
325: );
326:
327: PROCEDURE Delete_WM_Definition(
328: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
329: ,p_weighted_definition_id IN NUMBER
330: ,x_return_status OUT NOCOPY VARCHAR2
331: ,x_msg_count OUT NOCOPY NUMBER
332: ,x_msg_data OUT NOCOPY VARCHAR2

Line 336: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

332: ,x_msg_data OUT NOCOPY VARCHAR2
333: );
334:
335: PROCEDURE Create_WM_Dependency(
336: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
337: ,p_weighted_measure_id IN NUMBER
338: ,p_dependent_measure_id IN NUMBER
339: ,x_return_status OUT NOCOPY VARCHAR2
340: ,x_msg_count OUT NOCOPY NUMBER

Line 345: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

341: ,x_msg_data OUT NOCOPY VARCHAR2
342: );
343:
344: PROCEDURE Delete_WM_Dependency(
345: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
346: ,p_weighted_measure_id IN NUMBER
347: ,p_dependent_measure_id IN NUMBER
348: ,x_return_status OUT NOCOPY VARCHAR2
349: ,x_msg_count OUT NOCOPY NUMBER

Line 354: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

350: ,x_msg_data OUT NOCOPY VARCHAR2
351: );
352:
353: PROCEDURE Create_WM_Parameter(
354: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
355: ,p_weighted_parameter_id IN NUMBER
356: ,p_weighted_definition_id IN NUMBER
357: ,p_time_level_value_id IN VARCHAR2
358: ,p_filter_level_value_id IN VARCHAR2

Line 366: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

362: ,x_msg_data OUT NOCOPY VARCHAR2
363: );
364:
365: PROCEDURE Delete_WM_Parameter(
366: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
367: ,p_weighted_parameter_id IN NUMBER
368: ,x_return_status OUT NOCOPY VARCHAR2
369: ,x_msg_count OUT NOCOPY NUMBER
370: ,x_msg_data OUT NOCOPY VARCHAR2

Line 374: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

370: ,x_msg_data OUT NOCOPY VARCHAR2
371: );
372:
373: PROCEDURE Create_WM_Weight(
374: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
375: ,P_weight_id IN NUMBER
376: ,p_weighted_parameter_id IN NUMBER
377: ,p_dependent_measure_id IN NUMBER
378: ,p_weight IN NUMBER

Line 386: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

382: ,x_msg_data OUT NOCOPY VARCHAR2
383: );
384:
385: PROCEDURE Update_WM_Weight(
386: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
387: ,p_weight_id IN NUMBER
388: ,p_weight IN NUMBER
389: ,x_return_status OUT NOCOPY VARCHAR2
390: ,x_msg_count OUT NOCOPY NUMBER

Line 395: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

391: ,x_msg_data OUT NOCOPY VARCHAR2
392: );
393:
394: PROCEDURE Delete_WM_Weight(
395: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
396: ,p_weight_id IN NUMBER
397: ,x_return_status OUT NOCOPY VARCHAR2
398: ,x_msg_count OUT NOCOPY NUMBER
399: ,x_msg_data OUT NOCOPY VARCHAR2

Line 403: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

399: ,x_msg_data OUT NOCOPY VARCHAR2
400: );
401:
402: PROCEDURE Create_WM_Score(
403: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
404: ,p_weight_id IN NUMBER
405: ,p_low_range IN NUMBER
406: ,p_high_range IN NUMBER
407: ,p_score IN NUMBER

Line 414: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

410: ,x_msg_data OUT NOCOPY VARCHAR2
411: );
412:
413: PROCEDURE Delete_WM_Score(
414: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
415: ,p_weight_id IN NUMBER
416: ,x_return_status OUT NOCOPY VARCHAR2
417: ,x_msg_count OUT NOCOPY NUMBER
418: ,x_msg_data OUT NOCOPY VARCHAR2

Line 450: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

446: ,p_dependent_measure_Id IN NUMBER
447: ) RETURN VARCHAR;
448:
449: PROCEDURE Delete_Weighted_Measure_data(
450: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
451: ,p_weighted_measure_id IN NUMBER
452: ,x_return_status OUT NOCOPY VARCHAR2
453: ,x_msg_count OUT NOCOPY NUMBER
454: ,x_msg_data OUT NOCOPY VARCHAR2

Line 458: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

454: ,x_msg_data OUT NOCOPY VARCHAR2
455: );
456:
457: PROCEDURE Create_Weighted_Measure_data(
458: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
459: ,p_weighted_measure_id IN NUMBER
460: ,p_dependent_measure_ids IN VARCHAR2
461: ,p_viewby_dimension_short_name IN VARCHAR2
462: ,p_viewby_dim_level_short_name IN VARCHAR2

Line 473: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

469: ,x_msg_data OUT NOCOPY VARCHAR2
470: );
471:
472: PROCEDURE Set_Weight_Data(
473: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
474: ,p_weighted_measure_id NUMBER
475: ,p_dependent_measure_id NUMBER
476: ,p_weight NUMBER
477: ,x_return_status OUT NOCOPY VARCHAR2

Line 483: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

479: ,x_msg_data OUT NOCOPY VARCHAR2
480: );
481:
482: Procedure Set_Weights_Data(
483: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
484: ,p_weighted_measure_id IN NUMBER
485: ,p_depend_measure_short_names IN FND_TABLE_OF_VARCHAR2_30
486: ,p_weights IN FND_TABLE_OF_NUMBER
487: ,x_return_status OUT NOCOPY VARCHAR2

Line 498: p_commit IN VARCHAR2 := FND_API.G_FALSE

494: p_dep_kpi_id IN BIS_INDICATORS.INDICATOR_ID%TYPE
495: ) RETURN AK_REGION_ITEMS_VL.ATTRIBUTE7%TYPE;
496:
497: PROCEDURE Update_WM_Last_Update_Info(
498: p_commit IN VARCHAR2 := FND_API.G_FALSE
499: ,p_Weighted_Measure_Id IN NUMBER
500: ,x_return_status OUT NOCOPY VARCHAR2
501: ,x_msg_count OUT NOCOPY NUMBER
502: ,x_msg_data OUT NOCOPY VARCHAR2

Line 506: p_commit IN VARCHAR2 := FND_API.G_FALSE

502: ,x_msg_data OUT NOCOPY VARCHAR2
503: );
504:
505: PROCEDURE Save_Mass_Update_Values(
506: p_commit IN VARCHAR2 := FND_API.G_FALSE
507: ,p_weighted_measure_id IN NUMBER
508: ,p_dependent_measure_id IN NUMBER
509: ,p_Time_Level IN VARCHAR2
510: ,p_Filter_Level IN VARCHAR2