1 PACKAGE gms_security_extn AS
2 /* $Header: gmsseexs.pls 120.3 2006/08/24 13:05:35 smaroju ship $ */
3 /*#
4 * This extension enables users to override the default award security or to add additional award security
5 * criteria by implementing customized award security business rules.
6 * @rep:scope public
7 * @rep:product GMS
8 * @rep:lifecycle active
9 * @rep:displayname Award Security Client Extension
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY GMS_AWARD
12 * @rep:doccd 120gmsug.pdf See the Oracle Oracle Grants Accounting User's Guide
13 */
14 /*#
15 * This procedure implements the award security extension.
16 * @param X_award_id Identifier of the award or identifier of the award template
17 * @rep:paraminfo {@rep:required}
18 * @param X_person_id Identifier of the person
19 * @rep:paraminfo {@rep:required}
20 * @param X_calling_module Module in which the award security extension is called.Grants
21 * Accounting sets this value for each module in which it calls the security extension
22 * @rep:paraminfo {@rep:required}
23 * @param X_event Identifier of the type of query level to check.It can take following
24 * specific rules: ALLOW_QUERY, ALLOW_UPDATE
25 * @rep:paraminfo {@rep:required}
26 * @param X_value Specifies the result of the event: Y indicates event is
27 * allowed in the calling module for this person for the specific award. N indicates event
28 * is disallowed in the calling module for this person for the specific award
29 * @rep:paraminfo {@rep:required}
30 * @rep:scope public
31 * @rep:lifecycle active
32 * @rep:displayname Check Award Access
33 * @rep:compatibility S
34 */
35
36 PROCEDURE check_award_access ( X_award_id IN NUMBER
37 , X_person_id IN NUMBER
38 , X_calling_module IN VARCHAR2
39 , X_event IN VARCHAR2
40 , X_value OUT NOCOPY VARCHAR2 );
41 pragma RESTRICT_REFERENCES ( check_award_access, WNDS, WNPS );
42
43 END gms_security_extn;