1 PACKAGE BIS_VG_TYPES AUTHID CURRENT_USER AS
2 /* $Header: BISTTYPS.pls 115.20 2002/03/27 08:18:53 pkm ship $ */
3
4 --- Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA
5 --- All rights reserved.
6 ---
7 --- FILENAME
8 ---
9 --- BISTTYPS.pls
10 ---
11 --- DESCRIPTION
12 ---
13 --- specification of global types file
14 ---
15 --- NOTES
16 ---
17 --- HISTORY
18 ---
19 --- 23-JUL-98 Created
20 --- 30-OCT-2000 Set MESSAGE_APPLICATION constant to FND
21 --- 03-NOV-2000 Walid Nasrallah: Added new type Flexfield_Column_Table_Type
22 --- for Apps Integrator API
23 --- 12-FEB-2001 Walid Nasrallah: Added new field APPLICATION_NAME to
24 --- Flexfield_Column_Rec_Type
25 --- 05-APR-2001 Walid Nasrallah: Added new field SEGMENT_DATATYPE to
26 --- Flexfield_Column_Rec_Type
27 --- 06-APR-2001 Don Bowles: Added new types Flex_Column_Comment_Rec_Type and
28 --- Flex_Column_Comment_Table_Type. This record type
29 --- and table type is used is used to hold Flex info
30 --- that read when adding comments to the generated
31 --- view columns derived from flex.
32 --- 10-DEC-01 Edited by DBOWLES Added db driver comment
33 ---
34 --- GLOBAL TYPES
35 ---
36
37 --
38 TYPE Flexfield_Column_Rec_Type IS
39 RECORD
40 ( STRUCTURE_NUM NUMBER(15)
41 , STRUCTURE_NAME VARCHAR2(60)
42 , APPLICATION_COLUMN_NAME VARCHAR2(60)
43 , SEGMENT_NAME VARCHAR2(60)
44 , SEGMENT_DATATYPE VARCHAR2(2) --- added April 5, 2001
45 , ID_FLEX_CODE VARCHAR2(60)
46 , FLEX_FIELD_TYPE VARCHAR2(2)
47 , FLEX_FIELD_NAME VARCHAR2(100)
48 , APPLICATION_NAME VARCHAR2(20) --- added Feb 12, 2001
49 );
50
51 TYPE Flexfield_Column_Table_Type
52 IS
53 TABLE of Flexfield_Column_Rec_Type
54 ;
55 --- INDEX BY BINARY_INTEGER;
56 --- --- (USED NESTED TABLE TYPE TO ALLOW NULL DEFAULT)
57
58 SUBTYPE App_Short_Name_Type IS
59 fnd_application.application_short_name%TYPE;
60 --
61 SUBTYPE App_ID_Type IS
62 fnd_application.application_id%TYPE;
63 --
64 SUBTYPE Key_Flex_Code_Type IS
65 fnd_id_flexs.id_flex_code%TYPE;
66 --
67 SUBTYPE Desc_Flex_Name_Type IS
68 fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE;
69 --
70 SUBTYPE Lookup_Code_Type IS
71 fnd_lookups.lookup_code%TYPE;
72 --
73 SUBTYPE View_Name_Type IS
74 user_views.view_name%TYPE;
75 --
76 g_dummy_Var VARCHAR2(256);
77 SUBTYPE View_Text_Table_Rec_Type IS
78 g_dummy_Var%TYPE;
79 --
80 TYPE View_Text_Table_Type IS
81 TABLE of View_Text_Table_Rec_Type
82 INDEX BY BINARY_INTEGER;
83 --
84 TYPE View_Table_Rec_Type IS
85 RECORD
86 ( Application_ID app_id_type
87 , app_short_name app_short_name_type
88 , View_Name view_name_type
89 , text_length user_views.text_length%TYPE
90 );
91 --
92 TYPE View_Table_Type IS
93 TABLE OF View_Table_Rec_Type
94 INDEX BY BINARY_INTEGER;
95 --
96 TYPE Application_Table_Type IS
97 TABLE OF fnd_product_installations.application_id%TYPE
98 INDEX BY BINARY_INTEGER;
99 --
100 TYPE View_Character_Pointer_Type IS
101 RECORD
102 ( row_num NUMBER
103 , col_num NUMBER
104 );
105 --
106 TYPE Flex_Column_Comment_Rec_Type IS
107 RECORD
108 (column_name View_Text_Table_Rec_Type
109 ,flex_type VARCHAR2(25)
110 ,column_comments VARCHAR2(255)
111 );
112 --
113 TYPE Flex_Column_Comment_Table_Type IS
114 TABLE OF Flex_Column_Comment_Rec_Type
115 INDEX BY BINARY_INTEGER;
116 ---
117 --- application to be used while retrieving the messages from fnd_new_messages
118 ---
119 MESSAGE_APPLICATION CONSTANT VARCHAR2(10) := 'FND';
120
121 ---============================================================================
122 --- IMPORTANT NOTE
123 --- The following mode is ONLY for test purposes only
124 --- It should not be used by anybody except for testing
125 ---=============================================================================
126
127 SUBTYPE View_Generator_Mode_Type IS NUMBER;
128
129 -- mode for release, also default
130 production_mode CONSTANT view_generator_mode_type := 1;
131 -- mode where view will be generated
132 test_view_gen_mode CONSTANT view_generator_mode_type := 2;
133 -- mode where views will not be generated
134 test_no_view_gen_mode CONSTANT view_generator_mode_type := 3;
135 -- mode when running the view generator from sqlplus
136 sqlplus_production_mode CONSTANT view_generator_mode_type := 4;
137 -- mode for the generator to just remove tags from the input view
138 -- This is used typically to generate the views in seed11 where all the
139 -- flesfields are no defined and we want to just have the static columns
140 remove_tags_mode CONSTANT view_generator_mode_type := 5;
141 -- In this mode, the generator uses a passed parameter for the name
142 -- of the generated view
143 edw_verify_mode CONSTANT view_generator_mode_type := 7;
144 --
145 END BIS_VG_TYPES;