PACKAGE BODY: APPS.FA_SECURITY2

Source

1 PACKAGE BODY fa_security2 as
2 /* $Header: faxsec2b.pls 120.5 2005/07/25 09:59:50 yyoon noship $ */
3 
4 /* =============================================================================
5 
6         Name: 		build_predicate
7 
8         Description: 	Using static predicate on the odd synonym FA_BOOK_CONTROLS_SEC
9 
10         Parameters:	obj_schema	VARCHAR2
11 			obj_name	VARCHAR2
12 ============================================================================= */
13 FUNCTION build_predicate ( obj_schema VARCHAR2,
14                            obj_name VARCHAR2,
15                            p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type default null)
16 RETURN VARCHAR2 IS
17 
18 l_predicate VARCHAR2(5000)   := '';
19 
20 BEGIN
21 
22       -- if the list hasn't already been initialized then set_fa_context
23       -- wasn't called from the initialization profile and security by book
24       -- is not activated, so use no predicate
25 
26       IF (G_predicate_init = FALSE) then
27          G_predicate := '';
28          G_predicate_init   := TRUE;
29       END IF;
30 
31       l_predicate := G_predicate ;
32 
33       return l_predicate;
34 
35 END build_predicate;
36 
37 END fa_security2;