DBA Data[Home] [Help]

APPS.BIS_MEASURE_PVT dependencies on FND_API

Line 20: REM | 30-JAN-03 sugopal FND_API.G_MISS_xxx should not be used in |

16: REM | |
17: REM | HISTORY |
18: REM | 28-NOV-98 irchen Creation
19: REM | 16-JAN-2002 rchandra added new procedure for updating ownership of the given performance measure
20: REM | 30-JAN-03 sugopal FND_API.G_MISS_xxx should not be used in |
21: REM | initialization or declaration (bug#2774644) |
22: REM | 25-SEP-2003 mdamle Bug#3160325 - Sync up measures for all installed |
23: REM | languages |
24: REM | 29-SEP-2003 adrao Bug#3160325 - Sync up measures for all installed |

Line 41: --, p_commit IN VARCHAR2 := FND_API.G_FALSE

37: -- they are passed in
38: --- redundant because of defaults in next overloaded signature
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

Line 42: --, p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

38: --- redundant because of defaults in next overloaded signature
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: --);

Line 52: , p_commit IN VARCHAR2 := FND_API.G_FALSE

48: ---- creates one Measure for the given owner,
49: -- with the dimensions sequenced in the order they are passed in
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

Line 53: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

49: -- with the dimensions sequenced in the order they are passed in
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

Line 66: , p_commit IN VARCHAR2 := FND_API.G_FALSE

62: --The latest lct file. The lct file can call Load_Measure which calls this
63: --by passing in Org and Time dimension short_names also
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

Line 67: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

63: --by passing in Org and Time dimension short_names also
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

Line 81: , p_all_info IN VARCHAR2 := FND_API.G_TRUE

77: -- If information about the dimensions are not required, set all_info to
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: );

Line 93: , p_all_info IN VARCHAR2 := FND_API.G_TRUE

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
97: );

Line 106: , p_commit IN VARCHAR2 := FND_API.G_FALSE

102: -- 1) no Measure levels or targets exist
103: -- 2) no users have selected to see actuals for the Measure
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

Line 107: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

103: -- 2) no users have selected to see actuals for the Measure
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: );

Line 118: , p_commit IN VARCHAR2 := FND_API.G_FALSE

114: -- 1) no Measure levels or targets exist
115: -- 2) no users have selected to see actuals for the Measure
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

Line 119: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

115: -- 2) no users have selected to see actuals for the Measure
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

Line 132: , p_commit IN VARCHAR2 := FND_API.G_FALSE

128: --The latest lct file. The lct file can call Load_Measure which calls this
129: --by passing in Org and Time dimension short_names also
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

Line 133: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

129: --by passing in Org and Time dimension short_names also
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

Line 150: , p_commit IN VARCHAR2 := FND_API.G_FALSE

146: -- 2) the Measure access has not been granted to a resonsibility
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: );

Line 159: , p_commit IN VARCHAR2 := FND_API.G_FALSE

155: --
156: --
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

Line 160: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

156: --
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: );

Line 168: , p_commit IN VARCHAR2 := FND_API.G_FALSE

164: );
165: --
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

Line 169: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

165: --
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

Line 179: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

175: --
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

Line 247: , p_commit IN VARCHAR2 := FND_API.G_FALSE

243: --
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

Line 270: , p_commit IN VARCHAR2 := FND_API.G_FALSE

266: --
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

Line 282: , p_commit IN VARCHAR2 := FND_API.G_FALSE

278: --
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

Line 291: , p_commit IN VARCHAR2 := FND_API.G_FALSE

287: );
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: );

Line 369: , p_commit IN VARCHAR2 := FND_API.G_FALSE

365:
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

Line 387: p_commit IN VARCHAR2 := FND_API.G_FALSE,

383: RETURN VARCHAR2;
384:
385: --Procedure to update the obsolete flag of an indicator
386: PROCEDURE Update_Measure_Obsolete_Flag(
387: p_commit IN VARCHAR2 := FND_API.G_FALSE,
388: p_measure_short_name IN VARCHAR2,
389: p_obsolete IN VARCHAR2,
390: x_return_status OUT nocopy VARCHAR2,
391: x_Msg_Count OUT NOCOPY NUMBER,