[Home] [Help]
PACKAGE: APPS.BIS_VG_COMPILE
Source
1 PACKAGE bis_vg_compile AUTHID CURRENT_USER AS
2 /* $Header: BISTCMPS.pls 120.4 2006/06/15 16:40:47 dbowles ship $ */
3
4 -- Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA
5 -- All rights reserved.
6 --
7 -- FILENAME
8 --
9 -- BISTWRTB.pls
10 --
11 -- DESCRIPTION
12 --
13 -- body of package which writes the business views
14 --
15 -- NOTES
16 --
17 -- HISTORY
18 --
19 -- 21-AUG-98 ANSINGHA created
20 -- 19-MAR-99 Edited by WNASRALL@US for exception handling
21 -- 06-APR-01 Edited by DBOWLES. Added 2 new parameter to write_View.
22 -- Both parameters are of type
23 -- bis_vg_types.Flex_Column_Comment_Table_Type
24 -- 10-DEC-01 Edited by DBOWLES Added db driver comment
25 --
26 -- ============================================================================
27 expected_overflow_error exception;
28 numeric_or_value_error exception;
29 pragma exception_init(numeric_or_value_error, -6502);
30
31
32 PROCEDURE write_View -- PUBLIC PROCEDURE
33 ( p_mode IN NUMBER
34 , p_View_Name IN VARCHAR2
35 , p_View_Create_Text_Table IN bis_vg_types.View_Text_Table_Type
36 , p_View_Select_Text_Table IN bis_vg_types.view_text_table_type
37 , p_View_Column_Comment_Table IN bis_vg_types.Flex_Column_Comment_Table_Type
38 , x_View_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
39 ---, x_return_status OUT VARCHAR2
40 , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
41 );
42
43 END BIS_VG_COMPILE;