1 PACKAGE PA_CLIENT_EXTN_PROJ_STATUS AS
2 /* $Header: PAXPCECS.pls 120.3 2006/07/24 11:52:06 dthakker noship $ */
3 /*#
4 * The Project verification extension contains procedures that enable you to define rules to determine whether
5 * a project can change its project status, and to determine whether to call Workflow for a project status change.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname Project Verification
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_PROJECT
12 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
13 */
14
15 l_pkg_name VARCHAR2(30) := 'PA_CLIENT_EXTN_PROJ_STATUS'; -- Do not modify this
16
17 /*#
18 * This API is used to define requirements a project must satisfy to
19 * change from one project status to another.
20 * @param x_calling_module The module that called the extension
21 * @rep:paraminfo {@rep:required}
22 * @param x_project_id Identifier of the project
23 * @rep:paraminfo {@rep:required}
24 * @param x_old_proj_status_code The current project status code
25 * @rep:paraminfo {@rep:required}
26 * @param x_new_proj_status_code The new project status code
27 * @rep:paraminfo {@rep:required}
28 * @param x_project_type The project type of the project
29 * @rep:paraminfo {@rep:required}
30 * @param x_project_start_date The project start date
31 * @rep:paraminfo {@rep:required}
32 * @param x_project_end_date The project end date
33 * @rep:paraminfo {@rep:required}
34 * @param x_public_sector_flag Public sector indicator
35 * @rep:paraminfo {@rep:required}
36 * @param x_attribute_category Descriptive flexfield context
37 * @rep:paraminfo {@rep:required}
38 * @param x_attribute1 Descriptive flexfield segments
39 * @rep:paraminfo {@rep:required}
40 * @param x_attribute2 Descriptive flexfield segments
41 * @rep:paraminfo {@rep:required}
42 * @param x_attribute3 Descriptive flexfield segments
43 * @rep:paraminfo {@rep:required}
44 * @param x_attribute4 Descriptive flexfield segments
45 * @rep:paraminfo {@rep:required}
46 * @param x_attribute5 Descriptive flexfield segments
47 * @rep:paraminfo {@rep:required}
48 * @param x_attribute6 Descriptive flexfield segments
49 * @rep:paraminfo {@rep:required}
50 * @param x_attribute7 Descriptive flexfield segments
51 * @rep:paraminfo {@rep:required}
52 * @param x_attribute8 Descriptive flexfield segments
53 * @rep:paraminfo {@rep:required}
54 * @param x_attribute9 Descriptive flexfield segments
55 * @rep:paraminfo {@rep:required}
56 * @param x_attribute10 Descriptive flexfield segments
57 * @rep:paraminfo {@rep:required}
58 * @param x_pm_product_code The project management product code
59 * @rep:paraminfo {@rep:required}
60 * @param x_err_code Error handling code
61 * @rep:paraminfo {@rep:required}
62 * @param x_warnings_only_flag Warning flag
63 * @rep:paraminfo {@rep:required}
64 * @rep:scope public
65 * @rep:lifecycle active
66 * @rep:displayname Verify project status change
67 * @rep:compatibility S
68 */
69
70 Procedure verify_project_status_change
71 (x_calling_module IN VARCHAR2
72 ,X_project_id IN NUMBER
73 ,X_old_proj_status_code IN VARCHAR2
74 ,X_new_proj_status_code IN VARCHAR2
75 ,X_project_type IN VARCHAR2
76 ,X_project_start_date IN DATE
77 ,X_project_end_date IN DATE
78 ,X_public_sector_flag IN VARCHAR2
79 ,X_attribute_category IN VARCHAR2
80 ,X_attribute1 IN VARCHAR2
81 ,X_attribute2 IN VARCHAR2
82 ,X_attribute3 IN VARCHAR2
83 ,X_attribute4 IN VARCHAR2
84 ,X_attribute5 IN VARCHAR2
85 ,X_attribute6 IN VARCHAR2
86 ,X_attribute7 IN VARCHAR2
87 ,X_attribute8 IN VARCHAR2
88 ,X_attribute9 IN VARCHAR2
89 ,X_attribute10 IN VARCHAR2
90 ,x_pm_product_code IN VARCHAR2
91 ,x_err_code OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
92 ,x_warnings_only_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
93
94 /*#
95 * You can use this procedure to override the settings in the project status record and the project type
96 * that determine whether Workflow is called for a status change.
97 * @param x_project_status_code The current project status code
98 * @rep:paraminfo {@rep:required}
99 * @param x_project_type The project type of the project
100 * @rep:paraminfo {@rep:required}
101 * @param x_project_id Identifier of the project
102 * @rep:paraminfo {@rep:required}
103 * @param x_wf_enabled_flag Flag indicating whether Workflow is enabled for the
104 * status change. Value is either Y or N.
105 * @rep:paraminfo {@rep:required}
106 * @param x_err_code Error handling code
107 * @rep:paraminfo {@rep:required}
108 * @param x_status_type The project status type
109 * @rep:paraminfo {@rep:required}
110 * @rep:scope public
111 * @rep:lifecycle active
112 * @rep:displayname Check workflow enabled
113 * @rep:compatibility S
114 */
115
116 Procedure Check_wf_enabled
117 (x_project_status_code IN VARCHAR2,
118 x_project_type IN VARCHAR2,
119 x_project_id IN NUMBER,
120 x_wf_enabled_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
121 x_err_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
122 x_status_type IN VARCHAR2 DEFAULT 'PROJECT' );
123
124 END PA_CLIENT_EXTN_PROJ_STATUS;