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_MEASURE_PUB dependencies on BIS_MEASURE_PUB

Line 1: PACKAGE BODY BIS_MEASURE_PUB AS

1: PACKAGE BODY BIS_MEASURE_PUB AS
2: /* $Header: BISPMEAB.pls 120.0 2005/06/01 17:02:39 appldev noship $ */
3: --
4: /*
5: REM +=======================================================================+

Line 32: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_MEASURE_PUB';

28: REM | 27-JUL-2004 sawu Propagated p_owner to PVT apis for create/update|
29: REM +=======================================================================+
30: */
31: --
32: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_MEASURE_PUB';
33:
34:
35: -- creates one Measure, with the dimensions sequenced in the order
36: -- they are passed in

Line 40: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

36: -- they are passed in
37: Procedure Create_Measure
38: ( p_api_version IN NUMBER
39: , p_commit IN VARCHAR2 := FND_API.G_FALSE
40: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
41: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
42: , x_return_status OUT NOCOPY VARCHAR2
43: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
44: )

Line 46: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

42: , x_return_status OUT NOCOPY VARCHAR2
43: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
44: )
45: IS
46: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
47: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
48: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
49: BEGIN
50:

Line 47: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

43: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
44: )
45: IS
46: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
47: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
48: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
49: BEGIN
50:
51: if (BIS_UTILITIES_PUB.Value_Missing

Line 130: , x_Measure_tbl OUT NOCOPY BIS_MEASURE_PUB.Measure_Tbl_Type

126: -- FALSE
127: Procedure Retrieve_Measures
128: ( p_api_version IN NUMBER
129: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
130: , x_Measure_tbl OUT NOCOPY BIS_MEASURE_PUB.Measure_Tbl_Type
131: , x_return_status OUT NOCOPY VARCHAR2
132: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
133: )
134: IS

Line 135: l_Measure_Rec BIS_Measure_PUB.Measure_Rec_Type;

131: , x_return_status OUT NOCOPY VARCHAR2
132: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
133: )
134: IS
135: l_Measure_Rec BIS_Measure_PUB.Measure_Rec_Type;
136: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
137: BEGIN
138:
139: BIS_Measure_PVT.Retrieve_Measures

Line 171: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

167: -- Gets Information for One Performance Measure
168: -- If information about the dimension are not required, set all_info to FALSE.
169: Procedure Retrieve_Measure
170: ( p_api_version IN NUMBER
171: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
172: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
173: , x_Measure_Rec IN OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
174: , x_return_status OUT NOCOPY VARCHAR2
175: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 173: , x_Measure_Rec IN OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

169: Procedure Retrieve_Measure
170: ( p_api_version IN NUMBER
171: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
172: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
173: , x_Measure_Rec IN OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
174: , x_return_status OUT NOCOPY VARCHAR2
175: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
176: )
177: IS

Line 179: l_Measure_Rec BIS_Measure_PUB.Measure_Rec_Type;

175: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
176: )
177: IS
178:
179: l_Measure_Rec BIS_Measure_PUB.Measure_Rec_Type;
180: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
181:
182: BEGIN
183: l_measure_rec := p_measure_rec;

Line 241: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

237: -- 2) no users have selected to see actuals for the Measure
238: Procedure Update_Measure
239: ( p_api_version IN NUMBER
240: , p_commit IN VARCHAR2 := FND_API.G_FALSE
241: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
242: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
243: , x_return_status OUT NOCOPY VARCHAR2
244: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
245: )

Line 247: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

243: , x_return_status OUT NOCOPY VARCHAR2
244: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
245: )
246: IS
247: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
248: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
249: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
250: BEGIN
251:

Line 248: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

244: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
245: )
246: IS
247: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
248: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
249: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
250: BEGIN
251:
252: l_measure_rec := p_measure_rec;

Line 323: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

319: -- 3) no users have selected to see actuals for the Measure
320: Procedure Delete_Measure
321: ( p_api_version IN NUMBER
322: , p_commit IN VARCHAR2 := FND_API.G_FALSE
323: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
324: , x_return_status OUT NOCOPY VARCHAR2
325: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
326: )
327: IS

Line 328: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

324: , x_return_status OUT NOCOPY VARCHAR2
325: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
326: )
327: IS
328: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
329: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
330: BEGIN
331:
332: l_Measure_Rec := p_Measure_rec;

Line 383: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

379: --
380: -- Validates measure
381: PROCEDURE Validate_Measure
382: ( p_api_version IN NUMBER
383: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
384: , x_return_status OUT NOCOPY VARCHAR2
385: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
386: )
387: IS

Line 388: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

384: , x_return_status OUT NOCOPY VARCHAR2
385: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
386: )
387: IS
388: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
389: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
390: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
391: BEGIN
392: l_Measure_Rec := p_Measure_Rec;

Line 389: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

385: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
386: )
387: IS
388: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
389: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
390: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
391: BEGIN
392: l_Measure_Rec := p_Measure_Rec;
393: --changed to call Measure_Value_ID_Conversion

Line 448: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

444: END Validate_Measure;
445: --
446: Procedure Retrieve_Measure_Dimensions
447: ( p_api_version IN NUMBER
448: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
449: , x_dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type
450: , x_return_status OUT NOCOPY VARCHAR2
451: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
452: )

Line 454: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

450: , x_return_status OUT NOCOPY VARCHAR2
451: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
452: )
453: IS
454: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
455: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
456: BEGIN
457:
458: l_measure_rec := p_measure_rec;

Line 511: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

507: Procedure Translate_Measure
508: ( p_api_version IN NUMBER
509: , p_commit IN VARCHAR2 := FND_API.G_FALSE
510: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
511: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
512: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
513: , x_return_status OUT NOCOPY VARCHAR2
514: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
515: )

Line 517: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

513: , x_return_status OUT NOCOPY VARCHAR2
514: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
515: )
516: IS
517: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
518: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
519: l_return_status VARCHAR2(10);
520: l_return_msg VARCHAR2(32000);
521: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 518: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

514: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
515: )
516: IS
517: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
518: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
519: l_return_status VARCHAR2(10);
520: l_return_msg VARCHAR2(32000);
521: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
522: BEGIN

Line 594: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

590: Procedure Load_Measure
591: ( p_api_version IN NUMBER
592: , p_commit IN VARCHAR2 := FND_API.G_FALSE
593: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
594: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
595: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
596: , x_return_status OUT NOCOPY VARCHAR2
597: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
598: )

Line 600: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

596: , x_return_status OUT NOCOPY VARCHAR2
597: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
598: )
599: IS
600: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
601: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
602: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
603: BEGIN
604:

Line 601: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

597: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
598: )
599: IS
600: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
601: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
602: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
603: BEGIN
604:
605: l_measure_rec := p_measure_rec;

Line 705: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

701: Procedure Load_Measure
702: ( p_api_version IN NUMBER
703: , p_commit IN VARCHAR2 := FND_API.G_FALSE
704: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
705: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
706: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
707: , p_Org_Dimension_Short_Name IN VARCHAR2
708: , p_Time_Dimension_Short_Name IN VARCHAR2
709: , x_return_status OUT NOCOPY VARCHAR2

Line 713: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

709: , x_return_status OUT NOCOPY VARCHAR2
710: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
711: )
712: IS
713: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
714: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
715: l_Org_Dimension_ID NUMBER;
716: l_Time_Dimension_ID NUMBER;
717: l_msg VARCHAR2(3000);

Line 714: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

710: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
711: )
712: IS
713: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
714: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
715: l_Org_Dimension_ID NUMBER;
716: l_Time_Dimension_ID NUMBER;
717: l_msg VARCHAR2(3000);
718: l_return_status VARCHAR2(10);

Line 934: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

930: -- mdamle 09/25/2003 - Sync up measures for all installed languages
931: Procedure Translate_Measure_By_lang
932: ( p_api_version IN NUMBER
933: , p_commit IN VARCHAR2 := FND_API.G_FALSE
934: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
935: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
936: , p_lang IN VARCHAR2
937: , p_source_lang IN VARCHAR2
938: , x_return_status OUT NOCOPY VARCHAR2

Line 984: END BIS_MEASURE_PUB;

980: RETURN BIS_MEASURE_PVT.GET_CUSTOMIZED_ENABLED (p_indicator_id => p_indicator_id);
981:
982: END GET_CUSTOMIZED_ENABLED;
983:
984: END BIS_MEASURE_PUB;