1 package PJI_PERF_RPTG_PUB as
2 /*$Header: PJIPRFPS.pls 120.1 2006/07/27 13:35:16 ajdas noship $*/
3 /*#
4 * This package contains the public APIs for project performance reporting.
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname Project Performance Reporting API
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PA_PROJECT
11 * @rep:category BUSINESS_ENTITY PA_PERF_REPORTING
12 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
13 */
14
15
16 --Package constant used for package version validation
17 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
18
19
20 /*#
21 * This procedure creates resource rollup lines in the PJI_FP_XBS_ACCUM_F table for the
22 * RBS, for the workplans, financial plans, and actual transactions supplied when the
23 * API is called. These lines have their header entries in the PJI_ROLLUP_LEVEL_STATUS
24 * table for the corresponding PROJECT_ID, PLAN_VERSION_ID, WBS_VERSION_ID, RBS_VERSION_ID,
25 * and detail entries in PJI_FP_XBS_ACCUM_F. These lines are created only when the first
26 * user navigates to the Resource Summary, Resource, and Task Analysis pages..
27 * @param p_api_version_number API standard version number
28 * @param p_commit API standard (default = 'F') indicates if transcation will be commited
29 * @param p_init_msg_list API standard (default = 'F') indicates if message stack will be initialized
30 * @param x_msg_count API standard Return count of error messages
31 * @rep:paraminfo {@rep:required}
32 * @param x_msg_data API standard Return error message
33 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
34 * @param x_return_status API standard Return of the API success/failure/unexpected error)
35 * @rep:paraminfo {@rep:precision 1} {@rep:required}
36 * @param p_project_id Identifier of the project for which resource rollups need to be created
37 * @rep:paraminfo {@rep:required}
38 * @param p_plan_version_id_tbl Table of plan version identifiers for creating the resource rollups
39 * @rep:paraminfo {@rep:required}
40 * @param p_rbs_version_id_tbl Table of resource breakdown structure version identifiers for
41 * which resource rollups need to be created
42 * @rep:paraminfo {@rep:required}
43 * @param p_prg_rollup_flag Flag indicating whether to create resource rollups for the linked projects.
44 * The valid values are Y or N (default.) Pass Y only if you want to create the resource rollups for
45 * the linked projects.
46 * @rep:paraminfo {@rep:required}
47 * @rep:scope public
48 * @rep:lifecycle active
49 * @rep:displayname Create Resource Rollup
50 * @rep:compatibility S
51 */
52
53 PROCEDURE Create_resource_rollup
54 ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
55 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
56 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
57 ,x_msg_count OUT NOCOPY NUMBER
58 ,x_msg_data OUT NOCOPY VARCHAR2
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,p_project_id IN NUMBER
61 ,p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
62 ,p_rbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
63 ,p_prg_rollup_flag IN VARCHAR2 :='N'
64 );
65
66
67 /*#
68 * This API deletes the resource summary information from the PJI_FP_XBS_ACCUM_F table
69 * for a list of workplans, financial plans, and actual transactions. The API also
70 * deletes the resource summary header information from the PJI_ROLLUP_LEVEL_STATUS
71 * table for the corresponding PROJECT_ID ,PLAN_VERSION_ID and RBS_VERSION_ID.
72 * @param p_api_version_number API standard version number
73 * @param p_commit API standard (default = 'F') indicates if transcation will be commited
74 * @param p_init_msg_list API standard (default = 'F') indicates if message stack will be initialized
75 * @param x_msg_count API standard Return count of error messages
76 * @rep:paraminfo {@rep:required}
77 * @param x_msg_data API standard Return error message
78 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
79 * @param x_return_status API standard Return of the API success/failure/unexpected error)
80 * @rep:paraminfo {@rep:precision 1} {@rep:required}
81 * @param p_project_id Identifier of the project for which resource rollups need to be deleted
82 * @rep:paraminfo {@rep:required}
83 * @param p_plan_version_id_tbl Table of plan version identifiers for deleting the resource rollups.
84 * To delete actuals, pass -1 as the value for the plan version identifier.
85 * @rep:paraminfo {@rep:required}
86 * @param p_rbs_version_id_tbl Table of resource breakdown structure version identifiers for
87 * which resource rollups need to be deleted
88 * @rep:paraminfo {@rep:required}
89 * @rep:scope public
90 * @rep:lifecycle active
91 * @rep:displayname Delete Resource Rollup
92 * @rep:compatibility S
93 */
94
95 PROCEDURE Delete_resource_rollup
96 ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
97 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
98 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
99 ,x_msg_count OUT NOCOPY NUMBER
100 ,x_msg_data OUT NOCOPY VARCHAR2
101 ,x_return_status OUT NOCOPY VARCHAR2
102 ,p_project_id IN NUMBER
103 ,p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
104 ,p_rbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
105 );
106
107
108 end PJI_PERF_RPTG_PUB;