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

Line 105: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type

101: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_MEASURE_PVT';
102: --
103:
104: PROCEDURE Update_Measure_Rec_Total -- 2664898
105: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type
106: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type
107: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
108: );
109:

Line 106: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type

102: --
103:
104: PROCEDURE Update_Measure_Rec_Total -- 2664898
105: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type
106: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type
107: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
108: );
109:
110: PROCEDURE UpdateMeasureRecNoDim -- 2664898

Line 107: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

103:
104: PROCEDURE Update_Measure_Rec_Total -- 2664898
105: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type
106: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type
107: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
108: );
109:
110: PROCEDURE UpdateMeasureRecNoDim -- 2664898
111: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

Line 111: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

107: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
108: );
109:
110: PROCEDURE UpdateMeasureRecNoDim -- 2664898
111: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
112: , p_Measure_Rec1 IN BIS_MEASURE_PUB.Measure_Rec_Type
113: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
114: );
115:

Line 112: , p_Measure_Rec1 IN BIS_MEASURE_PUB.Measure_Rec_Type

108: );
109:
110: PROCEDURE UpdateMeasureRecNoDim -- 2664898
111: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
112: , p_Measure_Rec1 IN BIS_MEASURE_PUB.Measure_Rec_Type
113: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
114: );
115:
116: PROCEDURE Update_Measure_Rec_Dims -- 2664898

Line 113: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

109:
110: PROCEDURE UpdateMeasureRecNoDim -- 2664898
111: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
112: , p_Measure_Rec1 IN BIS_MEASURE_PUB.Measure_Rec_Type
113: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
114: );
115:
116: PROCEDURE Update_Measure_Rec_Dims -- 2664898
117: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type

Line 117: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type

113: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
114: );
115:
116: PROCEDURE Update_Measure_Rec_Dims -- 2664898
117: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type
118: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type
119: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
120: );
121:

Line 118: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type

114: );
115:
116: PROCEDURE Update_Measure_Rec_Dims -- 2664898
117: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type
118: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type
119: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
120: );
121:
122: PROCEDURE GetOriginalDimensions -- 3922308

Line 119: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

115:
116: PROCEDURE Update_Measure_Rec_Dims -- 2664898
117: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type
118: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type
119: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
120: );
121:
122: PROCEDURE GetOriginalDimensions -- 3922308
123: ( p_Measure_Rec_Orig IN BIS_MEASURE_PUB.Measure_Rec_Type

Line 123: ( p_Measure_Rec_Orig IN BIS_MEASURE_PUB.Measure_Rec_Type

119: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
120: );
121:
122: PROCEDURE GetOriginalDimensions -- 3922308
123: ( p_Measure_Rec_Orig IN BIS_MEASURE_PUB.Measure_Rec_Type
124: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
125: , x_Measure_Rec_Overlap OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
126: );
127:

Line 124: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

120: );
121:
122: PROCEDURE GetOriginalDimensions -- 3922308
123: ( p_Measure_Rec_Orig IN BIS_MEASURE_PUB.Measure_Rec_Type
124: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
125: , x_Measure_Rec_Overlap OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
126: );
127:
128: FUNCTION get_dimension_ID -- 2664898

Line 125: , x_Measure_Rec_Overlap OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

121:
122: PROCEDURE GetOriginalDimensions -- 3922308
123: ( p_Measure_Rec_Orig IN BIS_MEASURE_PUB.Measure_Rec_Type
124: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
125: , x_Measure_Rec_Overlap OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
126: );
127:
128: FUNCTION get_dimension_ID -- 2664898
129: ( p_dim_id IN NUMBER )

Line 133: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

129: ( p_dim_id IN NUMBER )
130: RETURN NUMBER;
131:
132: PROCEDURE ArrangeDimensions -- Added for 2784713
133: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
134: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
135: );
136:
137: FUNCTION return_value_if_not_missing -- 2784713

Line 134: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

130: RETURN NUMBER;
131:
132: PROCEDURE ArrangeDimensions -- Added for 2784713
133: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
134: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
135: );
136:
137: FUNCTION return_value_if_not_missing -- 2784713
138: ( p_number IN NUMBER )

Line 155: p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE

151: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
152: ) RETURN boolean;
153:
154: FUNCTION isCompareColumnMappedAlready(
155: p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
156: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
157: ) RETURN boolean;
158:
159: -- mdamle 07/18/2003 - Check if measure is being mapped to a source

Line 162: p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE

158:
159: -- mdamle 07/18/2003 - Check if measure is being mapped to a source
160: -- that's already mapped to another measure.
161: FUNCTION isSourceColumnMappedAlready(
162: p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
163: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
164: ) RETURN boolean;
165:
166:

Line 171: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

167: -- rpenneru 12/27/2004 for enh#4080204
168: PROCEDURE Load_Measure_Extension
169: ( p_api_version IN NUMBER
170: , p_commit IN VARCHAR2 := FND_API.G_FALSE
171: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
172: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
173: , x_return_status OUT NOCOPY VARCHAR2
174: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
175: );

Line 179: ( p_measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

175: );
176:
177:
178: FUNCTION Get_Measure_Id_From_Short_Name
179: ( p_measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
180: ) RETURN NUMBER
181: IS
182: -- mdamle 08/01/2003 - Chk for duplicate name after trimming
183: -- mdamle 08/04/2003 - Added case insensitive check

Line 208: ( p_measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

204:
205: END Get_Measure_Id_From_Short_Name;
206: -- Fix for 2309894 starts here
207: FUNCTION Get_Measure_Id_From_Name
208: ( p_measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
209: ) RETURN NUMBER
210: IS
211: -- mdamle 07/18/2003 - Changed like to =
212: -- Values may have % sign in them

Line 243: p_Measure_Rec_Orig IN BIS_MEASURE_PUB.Measure_Rec_Type

239:
240: -- ankgoel: bug#3922308
241: -- Retrieves the original set of dimensions and populates the new measure rec
242: PROCEDURE GetOriginalDimensions (
243: p_Measure_Rec_Orig IN BIS_MEASURE_PUB.Measure_Rec_Type
244: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
245: , x_Measure_Rec_Overlap OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
246: )
247: IS

Line 244: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

240: -- ankgoel: bug#3922308
241: -- Retrieves the original set of dimensions and populates the new measure rec
242: PROCEDURE GetOriginalDimensions (
243: p_Measure_Rec_Orig IN BIS_MEASURE_PUB.Measure_Rec_Type
244: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
245: , x_Measure_Rec_Overlap OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
246: )
247: IS
248: BEGIN

Line 245: , x_Measure_Rec_Overlap OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

241: -- Retrieves the original set of dimensions and populates the new measure rec
242: PROCEDURE GetOriginalDimensions (
243: p_Measure_Rec_Orig IN BIS_MEASURE_PUB.Measure_Rec_Type
244: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
245: , x_Measure_Rec_Overlap OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
246: )
247: IS
248: BEGIN
249: x_Measure_Rec_Overlap := p_Measure_Rec;

Line 379: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

375:
376: end Create_Indicator_Dimension;
377:
378: PROCEDURE Create_Indicator_Dimensions
379: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
380: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
381: , x_return_status OUT NOCOPY VARCHAR2
382: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
383: )

Line 514: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

510: --Overload Create_Indicator_Dimensions so that old data model ldts can be uploaded using
511: --The latest lct file. The lct file can indirectly call this overloaded procedure
512: --by passing in Org and Time also
513: PROCEDURE Create_Indicator_Dimensions
514: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
515: , p_Org_Dimension_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
516: , p_Time_Dimension_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
517: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
518: , x_return_status OUT NOCOPY VARCHAR2

Line 747: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

743:
744: END Create_Indicator_Dimensions;
745:
746: PROCEDURE SetNULL
747: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
748: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
749: )
750: IS
751: BEGIN

Line 748: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

744: END Create_Indicator_Dimensions;
745:
746: PROCEDURE SetNULL
747: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
748: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
749: )
750: IS
751: BEGIN
752:

Line 850: --, p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

846: --Procedure Create_Measure
847: --( p_api_version IN NUMBER
848: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
849: --, p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
850: --, p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
851: --, x_return_status OUT NOCOPY VARCHAR2
852: --, x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
853: --)
854: --IS

Line 888: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

884: Procedure Create_Measure
885: ( p_api_version IN NUMBER
886: , p_commit IN VARCHAR2 := FND_API.G_FALSE
887: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
888: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
889: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
890: , x_return_status OUT NOCOPY VARCHAR2
891: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
892: )

Line 898: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

894: l_error_count number;
895: l_user_id number;
896: l_login_id number;
897: l_id number;
898: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
899: l_application_rec BIS_APPLICATION_PVT.Application_rec_type;
900: l_measure_id NUMBER;
901: l_own_appl VARCHAR2(100) := FND_API.G_FALSE ; --2465354
902: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 1194: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

1190: Procedure Create_Measure
1191: ( p_api_version IN NUMBER
1192: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1193: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1194: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
1195: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
1196: , p_Org_Dimension_ID IN NUMBER
1197: , p_Time_Dimension_ID IN NUMBER
1198: , x_return_status OUT NOCOPY VARCHAR2

Line 1206: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

1202: l_error_count number;
1203: l_user_id number;
1204: l_login_id number;
1205: l_id number;
1206: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
1207: l_application_rec BIS_APPLICATION_PVT.Application_rec_type;
1208: l_measure_id NUMBER;
1209: l_own_appl VARCHAR2(100) := FND_API.G_FALSE ; --2465354
1210: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 1485: , x_Measure_tbl OUT NOCOPY BIS_MEASURE_PUB.Measure_Tbl_Type

1481: -- FALSE
1482: Procedure Retrieve_Measures
1483: ( p_api_version IN NUMBER
1484: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
1485: , x_Measure_tbl OUT NOCOPY BIS_MEASURE_PUB.Measure_Tbl_Type
1486: , x_return_status OUT NOCOPY VARCHAR2
1487: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1488: )
1489: IS

Line 1491: l_measure_rec BIS_Measure_PUB.Measure_Rec_Type;

1487: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1488: )
1489: IS
1490:
1491: l_measure_rec BIS_Measure_PUB.Measure_Rec_Type;
1492: l_dimension_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type;
1493: l_Measure_Rec_p BIS_Measure_PUB.Measure_Rec_Type;
1494:
1495: cursor cr_all_measures is

Line 1493: l_Measure_Rec_p BIS_Measure_PUB.Measure_Rec_Type;

1489: IS
1490:
1491: l_measure_rec BIS_Measure_PUB.Measure_Rec_Type;
1492: l_dimension_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type;
1493: l_Measure_Rec_p BIS_Measure_PUB.Measure_Rec_Type;
1494:
1495: cursor cr_all_measures is
1496: select measure_id, measure_short_name, measure_name
1497: from bisbv_performance_measures

Line 1561: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

1557: -- Gets Information for One Performance Measure
1558: -- If information about the dimension are not required, set all_info to FALSE.
1559: Procedure Retrieve_Measure
1560: ( p_api_version IN NUMBER
1561: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
1562: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
1563: , x_Measure_Rec IN OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
1564: , x_return_status OUT NOCOPY VARCHAR2
1565: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 1563: , x_Measure_Rec IN OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

1559: Procedure Retrieve_Measure
1560: ( p_api_version IN NUMBER
1561: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
1562: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
1563: , x_Measure_Rec IN OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
1564: , x_return_status OUT NOCOPY VARCHAR2
1565: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1566: )
1567: IS

Line 1926: FUNCTION Dimension_Count(p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type)

1922: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1923:
1924: end Update_Indicator_Dimension;
1925:
1926: FUNCTION Dimension_Count(p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type)
1927: return NUMBER
1928: IS
1929: l_count NUMBER := 2;
1930: BEGIN

Line 1969: (p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

1965:
1966: --OverLoad Dimension Count so that when loader tries to update a measure
1967: --with an old ldt file, it will not fail
1968: FUNCTION Dimension_Count
1969: (p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
1970: ,p_Org_Dimension_Id IN NUMBER
1971: ,p_Time_Dimension_Id IN NUMBER
1972: )
1973: return NUMBER

Line 2072: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

2068: return l_count;
2069: END Dimension_Count;
2070:
2071: PROCEDURE UpdateMeasureRec -- Changed for 2784713
2072: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2073: , p_Measure_Rec1 IN BIS_MEASURE_PUB.Measure_Rec_Type
2074: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2075: )
2076: IS

Line 2073: , p_Measure_Rec1 IN BIS_MEASURE_PUB.Measure_Rec_Type

2069: END Dimension_Count;
2070:
2071: PROCEDURE UpdateMeasureRec -- Changed for 2784713
2072: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2073: , p_Measure_Rec1 IN BIS_MEASURE_PUB.Measure_Rec_Type
2074: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2075: )
2076: IS
2077:

Line 2074: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

2070:
2071: PROCEDURE UpdateMeasureRec -- Changed for 2784713
2072: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2073: , p_Measure_Rec1 IN BIS_MEASURE_PUB.Measure_Rec_Type
2074: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2075: )
2076: IS
2077:
2078: BEGIN

Line 2178: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

2174: END UpdateMeasureRec;
2175:
2176:
2177: PROCEDURE ArrangeDimensions -- Added for 2784713
2178: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2179: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2180: ) IS
2181:
2182: i NUMBER;

Line 2179: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

2175:
2176:
2177: PROCEDURE ArrangeDimensions -- Added for 2784713
2178: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2179: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2180: ) IS
2181:
2182: i NUMBER;
2183: j NUMBER;

Line 2277: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type

2273: END;
2274:
2275:
2276: PROCEDURE Update_Measure_Rec_Total -- 2664898
2277: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type
2278: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type
2279: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2280: )
2281: IS

Line 2278: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type

2274:
2275:
2276: PROCEDURE Update_Measure_Rec_Total -- 2664898
2277: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type
2278: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type
2279: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2280: )
2281: IS
2282:

Line 2279: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

2275:
2276: PROCEDURE Update_Measure_Rec_Total -- 2664898
2277: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type
2278: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type
2279: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2280: )
2281: IS
2282:
2283: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

Line 2283: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

2279: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2280: )
2281: IS
2282:
2283: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
2284:
2285: BEGIN
2286:
2287: UpdateMeasureRecNoDim

Line 2308: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

2304: --
2305: --Overload UpdateMeasureRec if loader is trying to Update
2306: -- Measure from old ldt allow update only of Measure Name and Description
2307: PROCEDURE UpdateMeasureRecNoDim
2308: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2309: , p_Measure_Rec1 IN BIS_MEASURE_PUB.Measure_Rec_Type
2310: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2311: )
2312: IS

Line 2309: , p_Measure_Rec1 IN BIS_MEASURE_PUB.Measure_Rec_Type

2305: --Overload UpdateMeasureRec if loader is trying to Update
2306: -- Measure from old ldt allow update only of Measure Name and Description
2307: PROCEDURE UpdateMeasureRecNoDim
2308: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2309: , p_Measure_Rec1 IN BIS_MEASURE_PUB.Measure_Rec_Type
2310: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2311: )
2312: IS
2313: l_ret VARCHAR2(32000);

Line 2310: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

2306: -- Measure from old ldt allow update only of Measure Name and Description
2307: PROCEDURE UpdateMeasureRecNoDim
2308: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2309: , p_Measure_Rec1 IN BIS_MEASURE_PUB.Measure_Rec_Type
2310: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2311: )
2312: IS
2313: l_ret VARCHAR2(32000);
2314: l_dim_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type;

Line 2394: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type

2390:
2391: -- Updating the dimensions of the measures too...
2392: -- This is for P1 bug reported by BIL team bug 2664898
2393: PROCEDURE Update_Measure_Rec_Dims
2394: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type
2395: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type
2396: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2397: )
2398: IS

Line 2395: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type

2391: -- Updating the dimensions of the measures too...
2392: -- This is for P1 bug reported by BIL team bug 2664898
2393: PROCEDURE Update_Measure_Rec_Dims
2394: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type
2395: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type
2396: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2397: )
2398: IS
2399: BEGIN

Line 2396: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type

2392: -- This is for P1 bug reported by BIL team bug 2664898
2393: PROCEDURE Update_Measure_Rec_Dims
2394: ( p_Measure_Rec_orig IN BIS_MEASURE_PUB.Measure_Rec_Type
2395: , p_Measure_Rec_new IN BIS_MEASURE_PUB.Measure_Rec_Type
2396: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2397: )
2398: IS
2399: BEGIN
2400:

Line 2462: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

2458: Procedure Update_Measure
2459: ( p_api_version IN NUMBER
2460: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2461: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2462: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2463: , x_return_status OUT NOCOPY VARCHAR2
2464: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2465: )
2466: IS

Line 2507: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

2503: Procedure Update_Measure -- Changed for 2784713
2504: ( p_api_version IN NUMBER
2505: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2506: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2507: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2508: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
2509: , x_return_status OUT NOCOPY VARCHAR2
2510: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2511: )

Line 2515: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

2511: )
2512: IS
2513: l_user_id number;
2514: l_login_id number;
2515: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
2516: l_Measure_Rec1 BIS_MEASURE_PUB.Measure_Rec_Type;
2517: l_Measure_Rec_Orig BIS_MEASURE_PUB.Measure_Rec_Type;
2518: l_Measure_Rec_Overlap BIS_MEASURE_PUB.Measure_Rec_Type;
2519: l_count NUMBER := 0;

Line 2516: l_Measure_Rec1 BIS_MEASURE_PUB.Measure_Rec_Type;

2512: IS
2513: l_user_id number;
2514: l_login_id number;
2515: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
2516: l_Measure_Rec1 BIS_MEASURE_PUB.Measure_Rec_Type;
2517: l_Measure_Rec_Orig BIS_MEASURE_PUB.Measure_Rec_Type;
2518: l_Measure_Rec_Overlap BIS_MEASURE_PUB.Measure_Rec_Type;
2519: l_count NUMBER := 0;
2520: l_Measure_Id NUMBER;

Line 2517: l_Measure_Rec_Orig BIS_MEASURE_PUB.Measure_Rec_Type;

2513: l_user_id number;
2514: l_login_id number;
2515: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
2516: l_Measure_Rec1 BIS_MEASURE_PUB.Measure_Rec_Type;
2517: l_Measure_Rec_Orig BIS_MEASURE_PUB.Measure_Rec_Type;
2518: l_Measure_Rec_Overlap BIS_MEASURE_PUB.Measure_Rec_Type;
2519: l_count NUMBER := 0;
2520: l_Measure_Id NUMBER;
2521: l_application_rec BIS_APPLICATION_PVT.Application_rec_type; --2465354

Line 2518: l_Measure_Rec_Overlap BIS_MEASURE_PUB.Measure_Rec_Type;

2514: l_login_id number;
2515: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
2516: l_Measure_Rec1 BIS_MEASURE_PUB.Measure_Rec_Type;
2517: l_Measure_Rec_Orig BIS_MEASURE_PUB.Measure_Rec_Type;
2518: l_Measure_Rec_Overlap BIS_MEASURE_PUB.Measure_Rec_Type;
2519: l_count NUMBER := 0;
2520: l_Measure_Id NUMBER;
2521: l_application_rec BIS_APPLICATION_PVT.Application_rec_type; --2465354
2522: l_own_appl VARCHAR2(100) := FND_API.G_FALSE ; --2465354

Line 2812: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

2808: Procedure Update_Measure
2809: ( p_api_version IN NUMBER
2810: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2811: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2812: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2813: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
2814: , p_Org_Dimension_ID IN NUMBER
2815: , p_Time_Dimension_ID IN NUMBER
2816: , x_return_status OUT NOCOPY VARCHAR2

Line 2822: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

2818: )
2819: IS
2820: l_user_id number;
2821: l_login_id number;
2822: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
2823: l_Measure_Rec_Orig BIS_MEASURE_PUB.Measure_Rec_Type;
2824: l_count NUMBER := 0;
2825: l_Measure_Id NUMBER;
2826: l_application_rec BIS_APPLICATION_PVT.Application_rec_type; --2465354

Line 2823: l_Measure_Rec_Orig BIS_MEASURE_PUB.Measure_Rec_Type;

2819: IS
2820: l_user_id number;
2821: l_login_id number;
2822: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
2823: l_Measure_Rec_Orig BIS_MEASURE_PUB.Measure_Rec_Type;
2824: l_count NUMBER := 0;
2825: l_Measure_Id NUMBER;
2826: l_application_rec BIS_APPLICATION_PVT.Application_rec_type; --2465354
2827: l_own_appl VARCHAR2(100) := FND_API.G_FALSE ; --2465354

Line 3046: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

3042: --
3043: Procedure Delete_Measure
3044: ( p_api_version IN NUMBER
3045: , p_commit IN VARCHAR2 := FND_API.G_FALSE
3046: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
3047: , x_return_status OUT NOCOPY VARCHAR2
3048: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3049: )
3050: IS

Line 3148: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

3144: Procedure Translate_Measure
3145: ( p_api_version IN NUMBER
3146: , p_commit IN VARCHAR2 := FND_API.G_FALSE
3147: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3148: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
3149: , x_return_status OUT NOCOPY VARCHAR2
3150: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3151: )
3152: IS

Line 3187: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

3183: Procedure Translate_Measure
3184: ( p_api_version IN NUMBER
3185: , p_commit IN VARCHAR2 := FND_API.G_FALSE
3186: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3187: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
3188: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
3189: , x_return_status OUT NOCOPY VARCHAR2
3190: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3191: )

Line 3197: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;

3193: l_user_id NUMBER;
3194: l_login_id NUMBER;
3195: l_count NUMBER := 0;
3196: --l_Measure_Id NUMBER;
3197: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
3198: l_Measure_Rec_Orig BIS_MEASURE_PUB.Measure_Rec_Type;
3199: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3200:
3201: BEGIN

Line 3198: l_Measure_Rec_Orig BIS_MEASURE_PUB.Measure_Rec_Type;

3194: l_login_id NUMBER;
3195: l_count NUMBER := 0;
3196: --l_Measure_Id NUMBER;
3197: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
3198: l_Measure_Rec_Orig BIS_MEASURE_PUB.Measure_Rec_Type;
3199: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3200:
3201: BEGIN
3202:

Line 3302: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

3298: -- Validates measure
3299: PROCEDURE Validate_Measure
3300: ( p_api_version IN NUMBER
3301: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3302: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
3303: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
3304: , x_return_status OUT NOCOPY VARCHAR2
3305: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3306: )

Line 3710: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type

3706: --
3707: -- Value - ID conversion
3708: PROCEDURE Value_ID_Conversion
3709: ( p_api_version IN NUMBER
3710: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
3711: , x_Measure_Rec IN OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
3712: , x_return_status OUT NOCOPY VARCHAR2
3713: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3714: )

Line 3711: , x_Measure_Rec IN OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type

3707: -- Value - ID conversion
3708: PROCEDURE Value_ID_Conversion
3709: ( p_api_version IN NUMBER
3710: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
3711: , x_Measure_Rec IN OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
3712: , x_return_status OUT NOCOPY VARCHAR2
3713: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3714: )
3715: IS

Line 4016: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type

4012:
4013: --new procedure to to value id conversion only for measure
4014: PROCEDURE Measure_Value_ID_Conversion
4015: ( p_api_version IN NUMBER
4016: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
4017: , x_Measure_Rec OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
4018: , x_return_status OUT NOCOPY VARCHAR2
4019: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4020: )

Line 4017: , x_Measure_Rec OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type

4013: --new procedure to to value id conversion only for measure
4014: PROCEDURE Measure_Value_ID_Conversion
4015: ( p_api_version IN NUMBER
4016: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
4017: , x_Measure_Rec OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
4018: , x_return_status OUT NOCOPY VARCHAR2
4019: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4020: )
4021: IS

Line 4085: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type

4081:
4082: --new procedure to to value id conversion only for dimension
4083: PROCEDURE Dimension_Value_ID_Conversion
4084: ( p_api_version IN NUMBER
4085: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
4086: , x_Measure_Rec IN OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
4087: , x_return_status OUT NOCOPY VARCHAR2
4088: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4089: )

Line 4086: , x_Measure_Rec IN OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type

4082: --new procedure to to value id conversion only for dimension
4083: PROCEDURE Dimension_Value_ID_Conversion
4084: ( p_api_version IN NUMBER
4085: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
4086: , x_Measure_Rec IN OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
4087: , x_return_status OUT NOCOPY VARCHAR2
4088: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4089: )
4090: IS

Line 4365: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

4361:
4362:
4363: Procedure Retrieve_Measure_Dimensions
4364: ( p_api_version IN NUMBER
4365: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4366: , x_dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type
4367: , x_return_status OUT NOCOPY VARCHAR2
4368: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4369: )

Line 4453: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

4449: --
4450: --
4451: PROCEDURE Retrieve_Last_Update_Date
4452: ( p_api_version IN NUMBER
4453: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4454: , x_last_update_date OUT NOCOPY DATE
4455: , x_return_status OUT NOCOPY VARCHAR2
4456: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4457: )

Line 4515: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

4511: --
4512: --
4513: PROCEDURE Lock_Record
4514: ( p_api_version IN NUMBER
4515: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4516: , p_timestamp IN VARCHAR := NULL
4517: , x_return_status OUT NOCOPY VARCHAR2
4518: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4519: )

Line 4524: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

4520: IS
4521: --
4522: l_form_date DATE;
4523: l_last_update_date DATE;
4524: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
4525: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4526: --
4527: BEGIN
4528: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4583: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

4579: --
4580: PROCEDURE Create_Application_Measure
4581: ( p_api_version IN NUMBER
4582: , p_commit IN VARCHAR2 := FND_API.G_FALSE
4583: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4584: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
4585: , p_owning_application IN VARCHAR2
4586: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
4587: , x_return_status OUT NOCOPY VARCHAR2

Line 4653: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type

4649: --
4650: --
4651: PROCEDURE Retrieve_Application_Measures
4652: ( p_api_version IN NUMBER
4653: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
4654: , p_all_info IN VARCHAR2
4655: , x_owning_Application_rec OUT NOCOPY BIS_Application_PVT.Application_Rec_Type
4656: , x_Application_tbl OUT NOCOPY BIS_Application_PVT.Application_Tbl_Type
4657: , x_return_status OUT NOCOPY VARCHAR2

Line 4714: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

4710: --
4711: PROCEDURE Update_Application_Measure
4712: ( p_api_version IN NUMBER
4713: , p_commit IN VARCHAR2 := FND_API.G_FALSE
4714: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4715: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
4716: , p_owning_application IN VARCHAR2
4717: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
4718: , x_return_status OUT NOCOPY VARCHAR2

Line 4768: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

4764: --
4765: PROCEDURE Delete_Application_Measure
4766: ( p_api_version IN NUMBER
4767: , p_commit IN VARCHAR2 := FND_API.G_FALSE
4768: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4769: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
4770: , x_return_status OUT NOCOPY VARCHAR2
4771: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4772: )

Line 4818: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

4814: --
4815: PROCEDURE Delete_Application_Measures
4816: ( p_api_version IN NUMBER
4817: , p_commit IN VARCHAR2 := FND_API.G_FALSE
4818: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4819: , x_return_status OUT NOCOPY VARCHAR2
4820: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4821: )
4822: IS

Line 4874: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

4870: end Delete_Application_Measures;
4871: --
4872: PROCEDURE Lock_Record
4873: ( p_api_version IN NUMBER
4874: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4875: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
4876: , p_timestamp IN VARCHAR := NULL
4877: , x_return_status OUT NOCOPY VARCHAR2
4878: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 4923: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type

4919: end Lock_Record;
4920: --
4921: PROCEDURE Retrieve_Last_Update_Date
4922: ( p_api_version IN NUMBER
4923: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4924: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
4925: , x_last_update_date OUT NOCOPY DATE
4926: , x_return_status OUT NOCOPY VARCHAR2
4927: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 4972: ( p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE

4968: end Retrieve_Last_Update_Date;
4969: --
4970:
4971: FUNCTION IS_OLD_DATA_MODEL
4972: ( p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
4973: ,p_Org_Dimension_Id IN NUMBER
4974: ,p_Time_Dimension_Id IN NUMBER
4975: )
4976: RETURN BOOLEAN

Line 5160: p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE

5156:
5157: -- mdamle 07/18/2003 - Check if measure is being mapped to a source
5158: -- that's already mapped to another measure.
5159: FUNCTION isSourceColumnMappedAlready(
5160: p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
5161: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
5162: ) RETURN boolean IS
5163: l_result boolean := false;
5164: l_region_code Ak_Region_Items.REGION_CODE%TYPE;

Line 5191: p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE

5187: END isSourceColumnMappedAlready;
5188:
5189: --sawu: bug#3859267: need to validate compare-to column
5190: FUNCTION isCompareColumnMappedAlready(
5191: p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
5192: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
5193: ) RETURN boolean IS
5194: l_result boolean := false;
5195: l_region_code Ak_Region_Items.REGION_CODE%TYPE;

Line 5224: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

5220: -- mdamle 09/25/2003 - Sync up measures for all installed languages
5221: Procedure Translate_Measure_by_lang
5222: ( p_api_version IN NUMBER
5223: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5224: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
5225: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
5226: , p_lang IN VARCHAR2
5227: , p_source_lang IN VARCHAR2
5228: , x_return_status OUT NOCOPY VARCHAR2

Line 5353: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

5349:
5350: PROCEDURE Load_Measure_Extension
5351: ( p_api_version IN NUMBER
5352: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5353: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
5354: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
5355: , x_return_status OUT NOCOPY VARCHAR2
5356: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
5357: )