[Home] [Help]
PACKAGE: APPS.BIS_BUSINESS_PLAN_PVT
Source
1 PACKAGE BIS_BUSINESS_PLAN_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVBPS.pls 115.4 2004/02/13 08:22:34 ankgoel noship $ */
3 /*
4 REM +=======================================================================+
5 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BISVBPS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Private API for managing business plans for the
13 REM | Key Performance Framework.
14 REM |
15 REM | NOTES |
16 REM | |
17 REM | HISTORY |
18 REM | 14-JUL-1999 irchen Creation |
19 REM | 13-FEB-2004 ankgoel bug #3436033. Used the base tables for |
20 REM | "Value_ID_Conversion" & "Retrieve_Business_Plan"|
21 REM +=======================================================================+
22 */
23 --
24 --
25 Procedure Retrieve_Business_Plans
26 ( p_api_version IN NUMBER
27 , x_Business_Plan_Tbl OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Tbl_Type
28 , x_return_status OUT NOCOPY VARCHAR2
29 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
30 );
31 --
32 Procedure Retrieve_Business_Plan
33 ( p_api_version IN NUMBER
34 , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
35 , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
36 , x_return_status OUT NOCOPY VARCHAR2
37 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
38 );
39 --
40 Procedure Create_Business_Plan
41 ( p_api_version IN NUMBER
42 , p_commit IN VARCHAR2 := FND_API.G_FALSE
43 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
44 , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
45 , x_return_status OUT NOCOPY VARCHAR2
46 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
47 );
48 --
49 Procedure Create_Business_Plan
50 ( p_api_version IN NUMBER
51 , p_commit IN VARCHAR2 := FND_API.G_FALSE
52 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
53 , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
54 , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
55 , x_return_status OUT NOCOPY VARCHAR2
56 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
57 );
58 --
59 Procedure Update_Business_Plan
60 ( p_api_version IN NUMBER
61 , p_commit IN VARCHAR2 := FND_API.G_FALSE
62 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
63 , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
64 , x_return_status OUT NOCOPY VARCHAR2
65 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
66 );
67 --
68 Procedure Update_Business_Plan
69 ( p_api_version IN NUMBER
70 , p_commit IN VARCHAR2 := FND_API.G_FALSE
71 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
72 , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
73 , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
74 , x_return_status OUT NOCOPY VARCHAR2
75 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
76 );
77 --
78 Procedure Translate_Business_Plan
79 ( p_api_version IN NUMBER
80 , p_commit IN VARCHAR2 := FND_API.G_FALSE
81 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
82 , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
83 , x_return_status OUT NOCOPY VARCHAR2
84 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
85 );
86 --
87 Procedure Translate_Business_Plan
88 ( p_api_version IN NUMBER
89 , p_commit IN VARCHAR2 := FND_API.G_FALSE
90 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
91 , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
92 , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
93 , x_return_status OUT NOCOPY VARCHAR2
94 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
95 );
96 --
97 -- Value - ID conversion
98 PROCEDURE Value_ID_Conversion
99 ( p_api_version IN NUMBER
100 , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
101 , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
102 , x_return_status OUT NOCOPY VARCHAR2
103 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
104 );
105 --
106 PROCEDURE Value_ID_Conversion
107 ( p_api_version IN NUMBER
108 , p_Business_Plan_Short_Name IN VARCHAR2
109 , p_Business_Plan_Name IN VARCHAR2
110 , x_Business_Plan_ID OUT NOCOPY NUMBER
111 , x_return_status OUT NOCOPY VARCHAR2
112 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
113 );
114 --
115 PROCEDURE Validate_Business_Plan
116 ( p_api_version IN NUMBER
117 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
118 , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
119 , x_return_status OUT NOCOPY VARCHAR2
120 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
121 );
122 --
123 END BIS_BUSINESS_PLAN_PVT;