1 PACKAGE FND_GENERIC_POLICY AUTHID CURRENT_USER AS
2 /* $Header: AFSCGPLS.pls 115.1 2003/08/01 21:43:31 tmorrow noship $ */
3
4
5 /*
6 ** FND_GENERIC_POLICY.GET_PREDICATE-
7 **
8 ** Returns the data security predicate for a given synonym.
9 ** In order to use this function as the data security policy function,
10 ** the name of the synonym or view object that this is attached to
11 ** needs to be exactly the same as the function name that will be
12 ** used to get the data security predicate. And that function needs
13 ** to have its object_id properly set in the FND_FORM_FUNCTIONS table.
14 **
15 ** In other words this routine will do the following when attached as a
16 ** policy function to the synonym MY_FUNC_NAME:
17 ** - Look up the object out of FND_FORM_FUNCTIONS for function
18 ** MY_FUNC_NAME. That object must be the underlying object
19 ** behind the synonym.
20 ** - Call FND_DATA_SECURITY.GET_SECURITY_PREDICATE to get a security
21 ** predicate ("Where clause") that restricts the rows to the ones
22 ** that are accessible for that object, that function, for the current
23 ** user.
24 **
25 ** This routine should never need to be called directly by apps code.
26 ** Rather its name is passed to the add_policy() routine when vpd
27 ** policies are created, so that it will be called back by the
28 ** database upon access to the synonym or view.
29 */
30 FUNCTION GET_PREDICATE( p_schema IN VARCHAR2,
31 p_object IN VARCHAR2)
32 RETURN VARCHAR2;
33
34 END FND_GENERIC_POLICY;