1 PACKAGE BIS_BUSINESS_PLAN_PUB AS
2 /* $Header: BISPBPS.pls 120.0 2005/06/01 15:25:37 appldev 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 | BISPBPS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Public 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 +=======================================================================+
20 */
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
30 , Current_Plan_Flag VARCHAR2(1) := BIS_UTILITIES_PUB.G_NULL_CHAR
31 );
32 --
33 -- Data Types: Tables
34 --
35 TYPE Business_Plan_Tbl_Type IS TABLE OF Business_Plan_Rec_Type
36 INDEX BY BINARY_INTEGER;
37 --
38 --
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
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
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 --
64 Procedure Load_Business_Plan
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 --
74 END BIS_BUSINESS_PLAN_PUB;