DBA Data[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;