PACKAGE: APPS.AMW_SECURITY_PUB

Source

1 PACKAGE AMW_SECURITY_PUB as
2 /*$Header: amwpsecs.pls 120.1 2006/01/06 07:05:19 appldev noship $*/
3 
4   PROCEDURE grant_role_guid
5   (
6    p_api_version           IN  NUMBER,
7    p_role_name             IN  VARCHAR2,
8    p_object_name           IN  VARCHAR2,
9    p_instance_type         IN  VARCHAR2,
10    p_instance_set_id       IN  NUMBER,
11    p_instance_pk1_value    IN  VARCHAR2,
12    p_instance_pk2_value    IN  VARCHAR2,
13    p_instance_pk3_value    IN  VARCHAR2,
14    p_instance_pk4_value    IN  VARCHAR2,
15    p_instance_pk5_value    IN  VARCHAR2,
16    p_party_id              IN  NUMBER,
17    p_start_date            IN  DATE,
18    p_end_date              IN  DATE,
19    x_return_status         OUT NOCOPY VARCHAR2,
20    x_errorcode             OUT NOCOPY NUMBER,
21    x_grant_guid            OUT NOCOPY RAW,
22    p_check_for_existing    IN VARCHAR2 := FND_API.G_TRUE
23   );
24 
25     PROCEDURE grant_role_guid
26   (
27    p_api_version           IN  NUMBER,
28    p_role_name             IN  VARCHAR2,
29    p_object_name           IN  VARCHAR2,
30    p_instance_type         IN  VARCHAR2,
31    p_object_key            IN  NUMBER,
32    p_party_id              IN  NUMBER,
33    p_start_date            IN  DATE,
34    p_end_date              IN  DATE,
35    x_return_status         OUT NOCOPY VARCHAR2,
36    x_errorcode             OUT NOCOPY NUMBER,
37    x_grant_guid            OUT NOCOPY RAW
38   );
39 
40     PROCEDURE revoke_grant
41   (
42    p_api_version    IN  NUMBER,
43    p_grant_guid     IN  VARCHAR2,
44    x_return_status  OUT NOCOPY VARCHAR2,
45    x_errorcode      OUT NOCOPY NUMBER
46   );
47 
48     PROCEDURE set_grant_date
49   (
50    p_api_version    IN  NUMBER,
51    p_grant_guid     IN  VARCHAR2,
52    p_start_date     IN  DATE,
53    p_end_date       IN  DATE,
54    x_return_status  OUT NOCOPY VARCHAR2
55   );
56 
57 
58   PROCEDURE get_security_predicate(
59     p_api_version      IN  NUMBER,
60     p_function         IN  VARCHAR2,
61     p_object_name      IN  VARCHAR2,
62     p_grant_instance_type  IN  VARCHAR2,/* SET, INSTANCE*/
63     p_user_name        IN  VARCHAR2,
64     /* stmnt_type: 'OTHER', 'VPD'=VPD, 'EXISTS'= for checking existence. */
65     p_statement_type   IN  VARCHAR2,
66     x_predicate        out NOCOPY varchar2,
67     x_return_status    out NOCOPY varchar2,
68     p_table_alias      IN  VARCHAR2 DEFAULT NULL
69   );
70 
71 end AMW_SECURITY_PUB;