DBA Data[Home] [Help]

PACKAGE: APPS.FUN_SECURITY

Source


1 PACKAGE FUN_SECURITY AS
2 /* $Header: FUNSECAS.pls 120.3 2004/11/10 05:48:29 panaraya noship $*/
3 
4 
5 
6 --------------------------------------
7 --------------------------------------
8 -- declaration of procedures
9 --------------------------------------
10 --------------------------------------
11 
12 
13 /*-----------------------------------------------------
14  * PROCEDURE create_assign
15  * ----------------------------------------------------
16  * Create grants for the specified person to the
17  * specified organization.
18  * ---------------------------------------------------*/
19  PROCEDURE create_assign (
20    p_api_version	IN		NUMBER,
21    p_init_msg_list	IN		VARCHAR2  default null,
22    p_commit		IN		VARCHAR2,
23    x_return_status	OUT NOCOPY	VARCHAR2,
24    x_msg_count		OUT NOCOPY	NUMBER,
25    x_msg_data		OUT NOCOPY	VARCHAR2,
26    p_org_id		IN		NUMBER DEFAULT NULL,
27    p_person_id		IN		NUMBER,
28    p_create_all		IN		VARCHAR2,
29    p_create_contact	IN		VARCHAR2 default null,
30    p_enabled_flag	IN		VARCHAR2 default null
31    );
32 
33 /*-----------------------------------------------------
34  * PROCEDURE update_assign
35  * ----------------------------------------------------
36  * Updates grants for the specified person to the
37  * specified organization.
38  * ---------------------------------------------------*/
39 
40  PROCEDURE update_assign (
41    p_api_version	IN		NUMBER,
42    p_init_msg_list	IN		VARCHAR2  default null,
43    p_commit		IN		VARCHAR2,
44    x_return_status	OUT NOCOPY	VARCHAR2,
45    x_msg_count		OUT NOCOPY	NUMBER,
46    x_msg_data		OUT NOCOPY	VARCHAR2,
47    p_org_id		IN		NUMBER,
48    p_person_id		IN		NUMBER,
49    p_status		IN		VARCHAR2
50    );
51 
52 
53 /*-----------------------------------------------------
54  * FUNCTION is_access_allow
55  * ----------------------------------------------------
56  * Checks whether an FND grant on intercompany objects
57  * exists for the person.
58  * ---------------------------------------------------*/
59 
60  FUNCTION is_access_allow (
61    p_person_id		IN		NUMBER,
62    p_org_id		IN		NUMBER
63    ) RETURN VARCHAR2;
64 
65 
66 /*-----------------------------------------------------
67  * FUNCTION is_access_valid
68  * ----------------------------------------------------
69  * Checks whether an FND grant on intercompany objects
70  * is valid or not.
71  * ---------------------------------------------------*/
72 
73  FUNCTION is_access_valid (
74    p_person_id		IN		NUMBER,
75    p_org_id		IN		NUMBER
76    ) RETURN VARCHAR2;
77 
78 END FUN_SECURITY;