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_TARGET_PUB dependencies on BIS_TARGET_PUB

Line 1: PACKAGE BODY BIS_TARGET_PUB AS

1: PACKAGE BODY BIS_TARGET_PUB AS
2: /* $Header: BISPTARB.pls 115.29 2003/01/27 13:34:00 mahrao ship $ */
3: --
4: /*
5: REM dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=plb \

Line 37: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

33: -- one target level
34: PROCEDURE Create_Target
35: ( p_api_version IN NUMBER
36: , p_commit IN VARCHAR2 := FND_API.G_FALSE
37: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
38: , x_return_status OUT NOCOPY VARCHAR2
39: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
40: )
41: IS

Line 43: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;

39: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
40: )
41: IS
42: --
43: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
44: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
45: --
46: BEGIN
47: -- do value - id conversions

Line 69: htp.p('BIS_TARGET_PUB.Create_Target:G_EXC_ERROR'); htp.para;

65: EXCEPTION
66: WHEN FND_API.G_EXC_ERROR THEN
67: x_return_status := FND_API.G_RET_STS_ERROR;
68: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
69: htp.p('BIS_TARGET_PUB.Create_Target:G_EXC_ERROR'); htp.para;
70: END IF;
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 74: htp.p('BIS_TARGET_PUB.Create_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;

70: END IF;
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
74: htp.p('BIS_TARGET_PUB.Create_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
75: END IF;
76: WHEN OTHERS THEN
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78: l_error_tbl := x_error_Tbl;

Line 86: htp.p('BIS_TARGET_PUB.Create_Target:OTHERS'); htp.para;

82: , p_error_description => SQLERRM
83: , x_error_table => x_error_Tbl
84: );
85: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
86: htp.p('BIS_TARGET_PUB.Create_Target:OTHERS'); htp.para;
87: END IF;
88: --
89: END Create_Target;
90: --

Line 99: , x_Target_Tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_Type

95: PROCEDURE Retrieve_Targets
96: ( p_api_version IN NUMBER
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: IS

Line 107: l_target_tbl BIS_TARGET_PUB.Target_Tbl_Type;

103: IS
104: --
105: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
106: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
107: l_target_tbl BIS_TARGET_PUB.Target_Tbl_Type;
108: --
109: BEGIN
110: -- do value - id conversions
111: BIS_TARGET_LEVEL_PVT.Value_ID_Conversion

Line 149: htp.p('BIS_TARGET_PUB.Retrieve_Targets:G_EXC_ERROR'); htp.para;

145: EXCEPTION
146: WHEN FND_API.G_EXC_ERROR THEN
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
149: htp.p('BIS_TARGET_PUB.Retrieve_Targets:G_EXC_ERROR'); htp.para;
150: END IF;
151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 154: htp.p('BIS_TARGET_PUB.Retrieve_Targets:G_EXC_UNEXPECTED_ERROR'); htp.para;

150: END IF;
151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
154: htp.p('BIS_TARGET_PUB.Retrieve_Targets:G_EXC_UNEXPECTED_ERROR'); htp.para;
155: END IF;
156: WHEN OTHERS THEN
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: l_error_tbl := x_error_Tbl;

Line 166: htp.p('BIS_TARGET_PUB.Retrieve_Targets:OTHERS'); htp.para;

162: , p_error_description => SQLERRM
163: , x_error_table => x_error_Tbl
164: );
165: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
166: htp.p('BIS_TARGET_PUB.Retrieve_Targets:OTHERS'); htp.para;
167: END IF;
168: --
169: END Retrieve_Targets;
170: --

Line 177: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

173: -- If information about dimension values are not required, set all_info
174: -- to FALSE.
175: PROCEDURE Retrieve_Target
176: ( p_api_version IN NUMBER
177: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
178: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
179: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
180: , x_return_status OUT NOCOPY VARCHAR2
181: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 179: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

175: PROCEDURE Retrieve_Target
176: ( p_api_version IN NUMBER
177: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
178: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
179: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
180: , x_return_status OUT NOCOPY VARCHAR2
181: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
182: )
183: IS

Line 185: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;

181: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
182: )
183: IS
184: --
185: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
186: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
187: l_Target_Rec_p BIS_TARGET_PUB.Target_Rec_Type;
188: --
189: BEGIN

Line 187: l_Target_Rec_p BIS_TARGET_PUB.Target_Rec_Type;

183: IS
184: --
185: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
186: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
187: l_Target_Rec_p BIS_TARGET_PUB.Target_Rec_Type;
188: --
189: BEGIN
190: -- do value - id conversions
191: BIS_TARGET_PVT.Value_ID_Conversion

Line 233: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_ERROR'); htp.para;

229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
233: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_ERROR'); htp.para;
234: END IF;
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 238: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;

234: END IF;
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
238: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
239: END IF;
240: WHEN OTHERS THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: l_error_tbl := x_error_Tbl;

Line 250: htp.p('BIS_TARGET_PUB.Retrieve_Target:OTHERS'); htp.para;

246: , p_error_description => SQLERRM
247: , x_error_table => x_error_Tbl
248: );
249: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
250: htp.p('BIS_TARGET_PUB.Retrieve_Target:OTHERS'); htp.para;
251: END IF;
252: --
253: END Retrieve_Target;
254: --

Line 260: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

256: -- one target level
257: PROCEDURE Update_Target
258: ( p_api_version IN NUMBER
259: , p_commit IN VARCHAR2 := FND_API.G_FALSE
260: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
261: , x_return_status OUT NOCOPY VARCHAR2
262: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
263: )
264: IS

Line 266: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;

262: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
263: )
264: IS
265: --
266: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
267: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
268: --
269: BEGIN
270: -- do value - id conversions

Line 293: htp.p('BIS_TARGET_PUB.Update_Target:G_EXC_ERROR'); htp.para;

289: EXCEPTION
290: WHEN FND_API.G_EXC_ERROR THEN
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
293: htp.p('BIS_TARGET_PUB.Update_Target:G_EXC_ERROR'); htp.para;
294: END IF;
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 298: htp.p('BIS_TARGET_PUB.Update_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;

294: END IF;
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
298: htp.p('BIS_TARGET_PUB.Update_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
299: END IF;
300: WHEN OTHERS THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: l_error_tbl := x_error_Tbl;

Line 310: htp.p('BIS_TARGET_PUB.Update_Target:OTHERS'); htp.para;

306: , p_error_description => SQLERRM
307: , x_error_table => x_error_Tbl
308: );
309: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
310: htp.p('BIS_TARGET_PUB.Update_Target:OTHERS'); htp.para;
311: END IF;
312: --
313: END Update_Target;
314: --

Line 320: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

316: -- one target level
317: PROCEDURE Delete_Target
318: ( p_api_version IN NUMBER
319: , p_commit IN VARCHAR2 := FND_API.G_FALSE
320: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
321: , x_return_status OUT NOCOPY VARCHAR2
322: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
323: )
324: IS

Line 326: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;

322: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
323: )
324: IS
325: --
326: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
327: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
328: --
329: BEGIN
330: -- do value - id conversions

Line 352: htp.p('BIS_TARGET_PUB.Delete_Target:G_EXC_ERROR'); htp.para;

348: EXCEPTION
349: WHEN FND_API.G_EXC_ERROR THEN
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
352: htp.p('BIS_TARGET_PUB.Delete_Target:G_EXC_ERROR'); htp.para;
353: END IF;
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 357: htp.p('BIS_TARGET_PUB.Delete_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;

353: END IF;
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
357: htp.p('BIS_TARGET_PUB.Delete_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
358: END IF;
359: WHEN OTHERS THEN
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: l_error_tbl := x_error_Tbl;

Line 369: htp.p('BIS_TARGET_PUB.Delete_Target:OTHERS'); htp.para;

365: , p_error_description => SQLERRM
366: , x_error_table => x_error_Tbl
367: );
368: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
369: htp.p('BIS_TARGET_PUB.Delete_Target:OTHERS'); htp.para;
370: END IF;
371: --
372: END Delete_Target;
373: --

Line 377: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

373: --
374: -- Validates target record
375: PROCEDURE Validate_Target
376: ( p_api_version IN NUMBER
377: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
378: , x_return_status OUT NOCOPY VARCHAR2
379: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
380: )
381: IS

Line 383: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;

379: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
380: )
381: IS
382: --
383: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
384: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
385: --
386: BEGIN
387: -- dbms_output.put_line('> Validate_Target');

Line 409: htp.p('BIS_TARGET_PUB.Validate_Target:G_EXC_ERROR'); htp.para;

405: EXCEPTION
406: WHEN FND_API.G_EXC_ERROR THEN
407: x_return_status:= FND_API.G_RET_STS_ERROR;
408: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
409: htp.p('BIS_TARGET_PUB.Validate_Target:G_EXC_ERROR'); htp.para;
410: END IF;
411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
412: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
413: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 414: htp.p('BIS_TARGET_PUB.Validate_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;

410: END IF;
411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
412: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
413: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
414: htp.p('BIS_TARGET_PUB.Validate_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
415: END IF;
416: WHEN OTHERS THEN
417: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
418: l_error_tbl := x_error_Tbl;

Line 426: htp.p('BIS_TARGET_PUB.Validate_Target:OTHERS'); htp.para;

422: , p_error_description => SQLERRM
423: , x_error_table => x_error_Tbl
424: );
425: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
426: htp.p('BIS_TARGET_PUB.Validate_Target:OTHERS'); htp.para;
427: END IF;
428: END Validate_Target;
429: --
430:

Line 436: , p_Target_Rec IN BIS_TARGET_PUB.TARGET_REC_TYPE

432: -- and the Measure Short Name
433: PROCEDURE Retrieve_Target_From_ShNms
434: ( p_api_version IN NUMBER
435: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
436: , p_Target_Rec IN BIS_TARGET_PUB.TARGET_REC_TYPE
437: , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
438: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.TARGET_REC_TYPE
439: , x_return_status OUT NOCOPY VARCHAR2
440: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 438: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.TARGET_REC_TYPE

434: ( p_api_version IN NUMBER
435: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
436: , p_Target_Rec IN BIS_TARGET_PUB.TARGET_REC_TYPE
437: , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
438: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.TARGET_REC_TYPE
439: , x_return_status OUT NOCOPY VARCHAR2
440: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
441: )
442: IS

Line 460: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_ERROR'); htp.para;

456: EXCEPTION
457: WHEN FND_API.G_EXC_ERROR THEN
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
460: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_ERROR'); htp.para;
461: END IF;
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 465: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;

461: END IF;
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
465: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
466: END IF;
467: WHEN OTHERS THEN
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: l_error_tbl := x_error_Tbl;

Line 478: END BIS_TARGET_PUB;

474: , x_error_table => x_error_Tbl
475: );
476: END Retrieve_Target_From_ShNms;
477: --
478: END BIS_TARGET_PUB;