1 PACKAGE pa_security_extn AUTHID CURRENT_USER AS
2 /* $Header: PAPSECXS.pls 120.6.12010000.2 2009/03/04 07:32:45 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
47 /* Added for Bug 8234670 */
48
49 /*#
50 * This API is used to allow customization of project accessibility on the project search pages.
51 * @param x_mode Mode in which the function is called.
52 * @rep:paraminfo {@rep:required}
53 * @param x_project_id Identifier of the project.
54 * @rep:paraminfo {@rep:required}
55 * @param x_person_id Identifier of the person.
56 * @rep:paraminfo {@rep:required}
57 * @rep:scope public
58 * @rep:lifecycle active
59 * @rep:displayname Custom Project Access.
60 * @rep:compatibility S
61 */
62
63
64 FUNCTION custom_project_access ( X_mode IN VARCHAR2
65 , X_project_id IN NUMBER
66 , X_person_id IN NUMBER) RETURN VARCHAR2;
67
68 END pa_security_extn;
[Home] [Help]