21: --
22: -- Data Types: Records
23: --
24: TYPE Business_Plan_Rec_Type IS RECORD
25: ( Business_Plan_ID NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
26: , Business_Plan_Short_Name VARCHAR2(30) := BIS_UTILITIES_PUB.G_NULL_CHAR
27: , Business_Plan_Name VARCHAR2(80) := BIS_UTILITIES_PUB.G_NULL_CHAR
28: , Description VARCHAR2(240) := BIS_UTILITIES_PUB.G_NULL_CHAR
29: , Version_number NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
22: -- Data Types: Records
23: --
24: TYPE Business_Plan_Rec_Type IS RECORD
25: ( Business_Plan_ID NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
26: , Business_Plan_Short_Name VARCHAR2(30) := BIS_UTILITIES_PUB.G_NULL_CHAR
27: , Business_Plan_Name VARCHAR2(80) := BIS_UTILITIES_PUB.G_NULL_CHAR
28: , Description VARCHAR2(240) := BIS_UTILITIES_PUB.G_NULL_CHAR
29: , Version_number NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
30: , Current_Plan_Flag VARCHAR2(1) := BIS_UTILITIES_PUB.G_NULL_CHAR
23: --
24: TYPE Business_Plan_Rec_Type IS RECORD
25: ( Business_Plan_ID NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
26: , Business_Plan_Short_Name VARCHAR2(30) := BIS_UTILITIES_PUB.G_NULL_CHAR
27: , Business_Plan_Name VARCHAR2(80) := BIS_UTILITIES_PUB.G_NULL_CHAR
28: , Description VARCHAR2(240) := BIS_UTILITIES_PUB.G_NULL_CHAR
29: , Version_number NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
30: , Current_Plan_Flag VARCHAR2(1) := BIS_UTILITIES_PUB.G_NULL_CHAR
31: );
24: TYPE Business_Plan_Rec_Type IS RECORD
25: ( Business_Plan_ID NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
26: , Business_Plan_Short_Name VARCHAR2(30) := BIS_UTILITIES_PUB.G_NULL_CHAR
27: , Business_Plan_Name VARCHAR2(80) := BIS_UTILITIES_PUB.G_NULL_CHAR
28: , Description VARCHAR2(240) := BIS_UTILITIES_PUB.G_NULL_CHAR
29: , Version_number NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
30: , Current_Plan_Flag VARCHAR2(1) := BIS_UTILITIES_PUB.G_NULL_CHAR
31: );
32: --
25: ( Business_Plan_ID NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
26: , Business_Plan_Short_Name VARCHAR2(30) := BIS_UTILITIES_PUB.G_NULL_CHAR
27: , Business_Plan_Name VARCHAR2(80) := BIS_UTILITIES_PUB.G_NULL_CHAR
28: , Description VARCHAR2(240) := BIS_UTILITIES_PUB.G_NULL_CHAR
29: , Version_number NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
30: , Current_Plan_Flag VARCHAR2(1) := BIS_UTILITIES_PUB.G_NULL_CHAR
31: );
32: --
33: -- Data Types: Tables
26: , Business_Plan_Short_Name VARCHAR2(30) := BIS_UTILITIES_PUB.G_NULL_CHAR
27: , Business_Plan_Name VARCHAR2(80) := BIS_UTILITIES_PUB.G_NULL_CHAR
28: , Description VARCHAR2(240) := BIS_UTILITIES_PUB.G_NULL_CHAR
29: , Version_number NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
30: , Current_Plan_Flag VARCHAR2(1) := BIS_UTILITIES_PUB.G_NULL_CHAR
31: );
32: --
33: -- Data Types: Tables
34: --
39: Procedure Retrieve_Business_Plans
40: ( p_api_version IN NUMBER
41: , x_Business_Plan_Tbl OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Tbl_Type
42: , x_return_status OUT NOCOPY VARCHAR2
43: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
44: );
45: --
46: Procedure Retrieve_Business_Plan
47: ( p_api_version IN NUMBER
47: ( p_api_version IN NUMBER
48: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
49: , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
50: , x_return_status OUT NOCOPY VARCHAR2
51: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
52: );
53: --
54: Procedure Translate_Business_Plan
55: ( p_api_version IN NUMBER
55: ( p_api_version IN NUMBER
56: , p_commit IN VARCHAR2 := FND_API.G_FALSE
57: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
58: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
59: , p_OWNER IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
60: , x_return_status OUT NOCOPY VARCHAR2
61: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
62: );
63: --
57: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
58: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
59: , p_OWNER IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
60: , x_return_status OUT NOCOPY VARCHAR2
61: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
62: );
63: --
64: Procedure Load_Business_Plan
65: ( p_api_version IN NUMBER
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_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
69: , p_OWNER IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
70: , x_return_status OUT NOCOPY VARCHAR2
71: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
72: );
73: --
67: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
68: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
69: , p_OWNER IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
70: , x_return_status OUT NOCOPY VARCHAR2
71: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
72: );
73: --
74: END BIS_BUSINESS_PLAN_PUB;