PACKAGE: APPS.BIS_VG_SECURITY

Source

1 PACKAGE BIS_VG_SECURITY AUTHID CURRENT_USER AS
2 /* $Header: BISTSECS.pls 115.7 2002/03/27 08:18:50 pkm ship     $ */
3 
4 --  Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA
5 --  All rights reserved.
6 --
7 --  FILENAME
8 --
9 --      BISTSECS.pls
10 --
11 --  DESCRIPTION
12 --
13 --      specification of security package
14 --
15 --  NOTES
16 --
17 --  HISTORY
18 --
19 --  23-JUL-98 Created
20 --  10-DEC-01 Edited by DBOWLES Added db driver comment
21 --
22 --
23 --
24 --============================================================================
25 --PROCEDURE : parse_SEC_select
26 --  PARAMETERS:
27 --  1. p_View_Select_Table  table of varchars to hold select
28 --  2. p_pointer     	    pointer to the lookup column in select table
29 --  3. x_tbl 		    name of security column
30 --  4. x_app	  	    the application to use for security
31 --  5. x_pointer	    pointer to the character after the delimiter
32 -- 			    (select table)
33 --  6. x_return_status      error or normal
34 --  7. x_error_Tbl          table of error messages
35 ----
36 --  COMMENT   : Call this procedure to add a particular lookup select
37 --              information to a view.
38 --EXCEPTION : None
39 --  ==========================================================================
40 PROCEDURE parse_SEC_select
41 ( p_View_Select_Table 	IN  BIS_VG_TYPES.View_Text_Table_Type
42 , p_pointer    	IN  BIS_VG_TYPES.View_Character_Pointer_Type
43 , x_tbl      		OUT VARCHAR2
44 , x_app      		OUT VARCHAR2
45 , x_pointer    	OUT BIS_VG_TYPES.View_Character_Pointer_Type
46 , x_return_status       OUT VARCHAR2
47 , x_error_Tbl           OUT BIS_VG_UTIL.Error_Tbl_Type
48 );
49 
50 /* ============================================================================
51    PROCEDURE : add_Security_Info
52      PARAMETERS:
53      1. p_View_Select_Table  table of varchars to hold SELECT clause of view
54      2. p_From_Pointer       pointer to the corresponding from clause
55      3. x_Select_Table       table of varchars to hold additional columns
56      4. x_security_pointer   pointer at end of security
57      5. x_return_status    error or normal
58      6. x_error_Tbl        table of error messages
59 
60    COMMENT   : Call this procedure to add a security information to a view.
61    EXCEPTION : None
62   ===========================================================================*/
63 PROCEDURE add_Security_Info
64 ( p_View_Select_Table IN  BIS_VG_TYPES.View_Text_Table_Type
65 , p_security_pointer  IN  BIS_VG_TYPES.view_character_pointer_type
66 , x_Select_Table      OUT BIS_VG_TYPES.view_text_table_type
67 , x_security_pointer  OUT  BIS_VG_TYPES.view_character_pointer_type
68 , x_return_status       OUT VARCHAR2
69 , x_error_Tbl           OUT BIS_VG_UTIL.Error_Tbl_Type
70 );
71 --
72 /*============================================================================
73   EXCEPTIONS
74   ===========================================================================*/
75 --  MALFORMED_SECURITY_TAG EXCEPTION;
76   SECURITY_COL_EXP_MSG CONSTANT VARCHAR2(50):= 'BIS_VG_MALFORMED_SECURITY_TAG';
77   SECURITY_FUN_EXP_MSG CONSTANT VARCHAR2(50):= 'BIS_VG_UNDEFINED_SECURITY_TAG';
78 END BIS_VG_SECURITY;