1 PACKAGE pa_security_extn AS
2 /* $Header: PAPSECXS.pls 120.6 2007/08/21 11:04:15 rthumma ship $ */
3 /*#
4 * This extension is used to implement project security.
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname Project Security Extension
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PA_PROJECT
11 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
12 */
13
14 /*#
15 * This procedure is used to specify business rules to determine project access.
16 * @param x_project_id Identifier of the project or project template
17 * @rep:paraminfo {@rep:required}
18 * @param x_person_id Identifier of the person
19 * @rep:paraminfo {@rep:required}
20 * @param x_cross_project_user Flag indicating whether the user is a cross project user
21 * @rep:paraminfo {@rep:required}
22 * @param x_calling_module Module from which the project security extension is called. OracleProjects sets this value for each
23 * module in which it calls the security extension.
24 * @rep:paraminfo {@rep:required}
25 * @param x_event Type of access being queried. For example, ALLOW_QUERY, ALLOW_UPDATE, or VIEW_LABOR_ COSTS.
26 * @rep:paraminfo {@rep:required}
27 * @param x_value Result of the query (Y or N)
28 * @rep:paraminfo {@rep:required}
29 * @param x_cross_project_view Flag indicating if the user has cross project view access
30 * @rep:paraminfo {@rep:required}
31 * @rep:scope public
32 * @rep:lifecycle active
33 * @rep:displayname Project Security
34 * @rep:compatibility S
35 */
36
37 PROCEDURE check_project_access ( X_project_id IN NUMBER
38 , X_person_id IN NUMBER
39 , X_cross_project_user IN VARCHAR2
40 , X_calling_module IN VARCHAR2
41 , X_event IN VARCHAR2
42 , X_value OUT NOCOPY VARCHAR2
43 , X_cross_project_view IN VARCHAR2 := 'Y' );
44 pragma RESTRICT_REFERENCES ( check_project_access, WNDS, WNPS );
45
46 END pa_security_extn;