DBA Data[Home] [Help]

APPS.BIS_TARGET_PVT dependencies on BIS_UTILITIES_PUB

Line 88: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

84: , p_commit IN VARCHAR2 := FND_API.G_FALSE
85: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
86: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
87: , x_return_status OUT NOCOPY VARCHAR2
88: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
89: );
90: --
91: --
92: -- retrieve information for all targets of the given target level

Line 101: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

97: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
98: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
99: , x_Target_Tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_Type
100: , x_return_status OUT NOCOPY VARCHAR2
101: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
102: );
103: --
104: --
105: -- retrieve information for one target

Line 114: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

110: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
111: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
112: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
113: , x_return_status OUT NOCOPY VARCHAR2
114: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
115: );
116: --
117: --
118: -- retrieves the owners for one target

Line 127: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

123: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
124: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
125: , x_Target_Owners_Rec OUT NOCOPY BIS_TARGET_PUB.Target_Owners_Rec_Type
126: , x_return_status OUT NOCOPY VARCHAR2
127: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
128: );
129: --
130: --
131: -- Modifies one target for a specific set of dimension values for

Line 140: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

136: , p_commit IN VARCHAR2 := FND_API.G_FALSE
137: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
138: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
139: , x_return_status OUT NOCOPY VARCHAR2
140: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
141: );
142: --
143: --
144: -- Deletes one target for a specific set of dimension values for

Line 151: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

147: ( p_api_version IN NUMBER
148: , p_commit IN VARCHAR2 := FND_API.G_FALSE
149: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
150: , x_return_status OUT NOCOPY VARCHAR2
151: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
152: );
153: --
154: --
155: -- Validates target record

Line 162: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

158: , p_is_dbimeasure IN NUMBER := 0 --added by gbhaloti #3148615
159: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
161: , x_return_status OUT NOCOPY VARCHAR2
162: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
163: );
164: --
165: --
166: -- Value - ID conversion

Line 172: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

168: ( p_api_version IN NUMBER
169: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
170: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
171: , x_return_status OUT NOCOPY VARCHAR2
172: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
173: );
174: --
175: --
176: PROCEDURE Retrieve_Last_Update_Date

Line 181: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

177: ( p_api_version IN NUMBER
178: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
179: , x_last_update_date OUT NOCOPY DATE
180: , x_return_status OUT NOCOPY VARCHAR2
181: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
182: );
183:
184:
185: PROCEDURE GetID

Line 190: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

186: ( p_api_version IN NUMBER
187: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
188: , x_Target_Rec OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
189: , x_return_status OUT NOCOPY VARCHAR2
190: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
191: );
192:
193: --
194: --

Line 201: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

197: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
198: , p_timestamp IN VARCHAR := NULL
199: , x_result OUT NOCOPY VARCHAR2
200: , x_return_status OUT NOCOPY VARCHAR2
201: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
202: );
203: --
204: --
205: PROCEDURE Retrieve_Measure_Dim_Values

Line 214: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

210: , p_User_Name IN VARCHAR2 := NULL
211: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
212: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
213: , x_return_status OUT NOCOPY VARCHAR2
214: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
215: );
216: --
217: --
218: PROCEDURE GetQueryStatement

Line 281: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

277: , p_Target_Rec IN BIS_Target_PUB.Target_Rec_Type
278: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
279: , x_dimension_level_number OUT NOCOPY NUMBER
280: , x_return_status OUT NOCOPY VARCHAR2
281: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
282: );
283:
284: -- Retrieves the time level for the given target level
285: --

Line 303: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

299: , p_Target_Rec IN BIS_Target_PUB.Target_Rec_Type
300: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
301: , x_dimension_level_number OUT NOCOPY NUMBER
302: , x_return_status OUT NOCOPY VARCHAR2
303: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
304: );
305:
306: -- New Procedure to return TargetLevel and Target given the DimensionLevel ShortNames in any sequence
307: -- and the Measure Short Name

Line 315: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

311: , p_Target_Rec IN BIS_TARGET_PUB.TARGET_REC_TYPE
312: , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
313: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.TARGET_REC_TYPE
314: , x_return_status OUT NOCOPY VARCHAR2
315: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
316: ) ;
317: --
318: --
319: END BIS_TARGET_PVT;