APPS.BIS_VG_UTIL dependencies on BIS_VG_TYPES

Line 53: , x_View_Table OUT bis_vg_types.View_Text_Table_Type

49: -- creates a table of varchars from a single VARCHAR2 such that
50: -- each LENGTH(row) <= 250
51: PROCEDURE create_Text_Table
52: ( p_String IN VARCHAR2
53: , x_View_Table OUT bis_vg_types.View_Text_Table_Type
54: , x_return_status OUT VARCHAR2
55: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
56: );
57: --

Line 79: ( p_start_pointer IN BIS_VG_TYPES.view_character_pointer_type

75: --
76: --returns TRUE if p_start_pointer = p_end_pointer else returns FALSE
77:
78: FUNCTION equal_pointers
79: ( p_start_pointer IN BIS_VG_TYPES.view_character_pointer_type
80: , p_end_pointer IN BIS_VG_TYPES.view_character_pointer_type
81: , x_return_status OUT VARCHAR2
82: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
83: )

Line 80: , p_end_pointer IN BIS_VG_TYPES.view_character_pointer_type

76: --returns TRUE if p_start_pointer = p_end_pointer else returns FALSE
77:
78: FUNCTION equal_pointers
79: ( p_start_pointer IN BIS_VG_TYPES.view_character_pointer_type
80: , p_end_pointer IN BIS_VG_TYPES.view_character_pointer_type
81: , x_return_status OUT VARCHAR2
82: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
83: )
84: RETURN BOOLEAN;

Line 90: ( p_view_table IN bis_vg_types.View_Text_Table_Type

86: -- returns the string between p_start and p_end
87: -- end is not included
88:
89: FUNCTION get_string
90: ( p_view_table IN bis_vg_types.View_Text_Table_Type
91: , p_start_pointer IN bis_vg_types.View_Character_Pointer_Type
92: , p_end_pointer IN bis_vg_types.View_Character_Pointer_Type
93: , x_return_status OUT VARCHAR2
94: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 91: , p_start_pointer IN bis_vg_types.View_Character_Pointer_Type

87: -- end is not included
88:
89: FUNCTION get_string
90: ( p_view_table IN bis_vg_types.View_Text_Table_Type
91: , p_start_pointer IN bis_vg_types.View_Character_Pointer_Type
92: , p_end_pointer IN bis_vg_types.View_Character_Pointer_Type
93: , x_return_status OUT VARCHAR2
94: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
95: )

Line 92: , p_end_pointer IN bis_vg_types.View_Character_Pointer_Type

88:
89: FUNCTION get_string
90: ( p_view_table IN bis_vg_types.View_Text_Table_Type
91: , p_start_pointer IN bis_vg_types.View_Character_Pointer_Type
92: , p_end_pointer IN bis_vg_types.View_Character_Pointer_Type
93: , x_return_status OUT VARCHAR2
94: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
95: )
96: RETURN VARCHAR2;

Line 100: ( p_view_table IN bis_vg_types.View_Text_Table_Type

96: RETURN VARCHAR2;
97:
98: -- returns the charater pointed to by the p_pointer
99: FUNCTION get_char
100: ( p_view_table IN bis_vg_types.View_Text_Table_Type
101: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
102: , x_return_status OUT VARCHAR2
103: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
104: )

Line 101: , p_pointer IN bis_vg_types.View_Character_Pointer_Type

97:
98: -- returns the charater pointed to by the p_pointer
99: FUNCTION get_char
100: ( p_view_table IN bis_vg_types.View_Text_Table_Type
101: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
102: , x_return_status OUT VARCHAR2
103: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
104: )
105: RETURN VARCHAR2;

Line 109: ( p_view_table IN bis_vg_types.View_Text_Table_Type

105: RETURN VARCHAR2;
106:
107: -- increments pointer by one
108: FUNCTION increment_pointer
109: ( p_view_table IN bis_vg_types.View_Text_Table_Type
110: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
111: , x_return_status OUT VARCHAR2
112: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
113: )

Line 110: , p_pointer IN bis_vg_types.View_Character_Pointer_Type

106:
107: -- increments pointer by one
108: FUNCTION increment_pointer
109: ( p_view_table IN bis_vg_types.View_Text_Table_Type
110: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
111: , x_return_status OUT VARCHAR2
112: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
113: )
114: RETURN bis_vg_types.view_character_pointer_type;

Line 114: RETURN bis_vg_types.view_character_pointer_type;

110: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
111: , x_return_status OUT VARCHAR2
112: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
113: )
114: RETURN bis_vg_types.view_character_pointer_type;
115:
116: -- concatenates p_View_Table_A with p_View_Table_B
117: PROCEDURE concatenate_Tables
118: ( p_View_Table_A IN BIS_VG_TYPES.View_Text_Table_Type

Line 118: ( p_View_Table_A IN BIS_VG_TYPES.View_Text_Table_Type

114: RETURN bis_vg_types.view_character_pointer_type;
115:
116: -- concatenates p_View_Table_A with p_View_Table_B
117: PROCEDURE concatenate_Tables
118: ( p_View_Table_A IN BIS_VG_TYPES.View_Text_Table_Type
119: , p_View_Table_B IN BIS_VG_TYPES.View_Text_Table_Type
120: , x_View_Table OUT BIS_VG_TYPES.View_Text_Table_Type
121: , x_return_status OUT VARCHAR2
122: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 119: , p_View_Table_B IN BIS_VG_TYPES.View_Text_Table_Type

115:
116: -- concatenates p_View_Table_A with p_View_Table_B
117: PROCEDURE concatenate_Tables
118: ( p_View_Table_A IN BIS_VG_TYPES.View_Text_Table_Type
119: , p_View_Table_B IN BIS_VG_TYPES.View_Text_Table_Type
120: , x_View_Table OUT BIS_VG_TYPES.View_Text_Table_Type
121: , x_return_status OUT VARCHAR2
122: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
123: );

Line 120: , x_View_Table OUT BIS_VG_TYPES.View_Text_Table_Type

116: -- concatenates p_View_Table_A with p_View_Table_B
117: PROCEDURE concatenate_Tables
118: ( p_View_Table_A IN BIS_VG_TYPES.View_Text_Table_Type
119: , p_View_Table_B IN BIS_VG_TYPES.View_Text_Table_Type
120: , x_View_Table OUT BIS_VG_TYPES.View_Text_Table_Type
121: , x_return_status OUT VARCHAR2
122: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
123: );
124: -- concatenates p_View_Table_A with p_View_Table_B Flex_Column_Comment

Line 126: ( p_View_Table_A IN BIS_VG_TYPES.Flex_Column_Comment_Table_Type

122: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
123: );
124: -- concatenates p_View_Table_A with p_View_Table_B Flex_Column_Comment
125: PROCEDURE concatenate_Tables
126: ( p_View_Table_A IN BIS_VG_TYPES.Flex_Column_Comment_Table_Type
127: , p_View_Table_B IN BIS_VG_TYPES.Flex_Column_Comment_Table_Type
128: , x_View_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
129: , x_return_status OUT VARCHAR2
130: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 127: , p_View_Table_B IN BIS_VG_TYPES.Flex_Column_Comment_Table_Type

123: );
124: -- concatenates p_View_Table_A with p_View_Table_B Flex_Column_Comment
125: PROCEDURE concatenate_Tables
126: ( p_View_Table_A IN BIS_VG_TYPES.Flex_Column_Comment_Table_Type
127: , p_View_Table_B IN BIS_VG_TYPES.Flex_Column_Comment_Table_Type
128: , x_View_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
129: , x_return_status OUT VARCHAR2
130: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
131: );

Line 128: , x_View_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type

124: -- concatenates p_View_Table_A with p_View_Table_B Flex_Column_Comment
125: PROCEDURE concatenate_Tables
126: ( p_View_Table_A IN BIS_VG_TYPES.Flex_Column_Comment_Table_Type
127: , p_View_Table_B IN BIS_VG_TYPES.Flex_Column_Comment_Table_Type
128: , x_View_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
129: , x_return_status OUT VARCHAR2
130: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
131: );
132: -- copies the part between the pointers into a table

Line 137: ( p_View_Table_A IN BIS_VG_TYPES.View_Text_Table_Type

133: -- character pointed to by start is copied
134: -- character pointed to by end is not copied
135:
136: PROCEDURE copy_part_of_table
137: ( p_View_Table_A IN BIS_VG_TYPES.View_Text_Table_Type
138: , p_start_pointer IN BIS_VG_TYPES.view_character_pointer_type
139: , p_end_pointer IN BIS_VG_TYPES.view_character_pointer_type
140: , x_View_Table OUT BIS_VG_TYPES.View_Text_Table_Type
141: , x_return_status OUT VARCHAR2

Line 138: , p_start_pointer IN BIS_VG_TYPES.view_character_pointer_type

134: -- character pointed to by end is not copied
135:
136: PROCEDURE copy_part_of_table
137: ( p_View_Table_A IN BIS_VG_TYPES.View_Text_Table_Type
138: , p_start_pointer IN BIS_VG_TYPES.view_character_pointer_type
139: , p_end_pointer IN BIS_VG_TYPES.view_character_pointer_type
140: , x_View_Table OUT BIS_VG_TYPES.View_Text_Table_Type
141: , x_return_status OUT VARCHAR2
142: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 139: , p_end_pointer IN BIS_VG_TYPES.view_character_pointer_type

135:
136: PROCEDURE copy_part_of_table
137: ( p_View_Table_A IN BIS_VG_TYPES.View_Text_Table_Type
138: , p_start_pointer IN BIS_VG_TYPES.view_character_pointer_type
139: , p_end_pointer IN BIS_VG_TYPES.view_character_pointer_type
140: , x_View_Table OUT BIS_VG_TYPES.View_Text_Table_Type
141: , x_return_status OUT VARCHAR2
142: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
143: );

Line 140: , x_View_Table OUT BIS_VG_TYPES.View_Text_Table_Type

136: PROCEDURE copy_part_of_table
137: ( p_View_Table_A IN BIS_VG_TYPES.View_Text_Table_Type
138: , p_start_pointer IN BIS_VG_TYPES.view_character_pointer_type
139: , p_end_pointer IN BIS_VG_TYPES.view_character_pointer_type
140: , x_View_Table OUT BIS_VG_TYPES.View_Text_Table_Type
141: , x_return_status OUT VARCHAR2
142: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
143: );
144:

Line 146: ( p_View_Text_Table IN BIS_VG_TYPES.View_Text_Table_Type

142: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
143: );
144:
145: PROCEDURE print_View_Text
146: ( p_View_Text_Table IN BIS_VG_TYPES.View_Text_Table_Type
147: , x_return_status OUT VARCHAR2
148: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
149: );
150:

Line 152: ( p_pointer IN BIS_VG_TYPES.View_character_pointer_type

148: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
149: );
150:
151: PROCEDURE print_View_pointer
152: ( p_pointer IN BIS_VG_TYPES.View_character_pointer_type
153: , x_return_status OUT VARCHAR2
154: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
155: );
156:

Line 159: ( p_View_Text_Table IN BIS_VG_TYPES.view_text_table_type

155: );
156:
157: -- position the pointer before trailing characters
158: FUNCTION position_before_characters
159: ( p_View_Text_Table IN BIS_VG_TYPES.view_text_table_type
160: , p_str IN VARCHAR2
161: , p_pointer IN bis_vg_types.view_character_pointer_type
162: , x_return_status OUT VARCHAR2
163: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 161: , p_pointer IN bis_vg_types.view_character_pointer_type

157: -- position the pointer before trailing characters
158: FUNCTION position_before_characters
159: ( p_View_Text_Table IN BIS_VG_TYPES.view_text_table_type
160: , p_str IN VARCHAR2
161: , p_pointer IN bis_vg_types.view_character_pointer_type
162: , x_return_status OUT VARCHAR2
163: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
164: )
165: RETURN bis_vg_types.view_character_pointer_type;

Line 165: RETURN bis_vg_types.view_character_pointer_type;

161: , p_pointer IN bis_vg_types.view_character_pointer_type
162: , x_return_status OUT VARCHAR2
163: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
164: )
165: RETURN bis_vg_types.view_character_pointer_type;
166:
167: -- position the pointer before trailing characters
168: FUNCTION position_before_characters
169: ( p_View_Text_Table IN BIS_VG_TYPES.view_text_table_type

Line 169: ( p_View_Text_Table IN BIS_VG_TYPES.view_text_table_type

165: RETURN bis_vg_types.view_character_pointer_type;
166:
167: -- position the pointer before trailing characters
168: FUNCTION position_before_characters
169: ( p_View_Text_Table IN BIS_VG_TYPES.view_text_table_type
170: , p_str IN VARCHAR2
171: , x_return_status OUT VARCHAR2
172: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
173: )

Line 174: RETURN bis_vg_types.view_character_pointer_type;

170: , p_str IN VARCHAR2
171: , x_return_status OUT VARCHAR2
172: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
173: )
174: RETURN bis_vg_types.view_character_pointer_type;
175:
176: -- decrements pointer by one
177: FUNCTION decrement_pointer
178: ( p_view_table IN bis_vg_types.View_Text_Table_Type

Line 178: ( p_view_table IN bis_vg_types.View_Text_Table_Type

174: RETURN bis_vg_types.view_character_pointer_type;
175:
176: -- decrements pointer by one
177: FUNCTION decrement_pointer
178: ( p_view_table IN bis_vg_types.View_Text_Table_Type
179: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
180: , x_return_status OUT VARCHAR2
181: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
182: )

Line 179: , p_pointer IN bis_vg_types.View_Character_Pointer_Type

175:
176: -- decrements pointer by one
177: FUNCTION decrement_pointer
178: ( p_view_table IN bis_vg_types.View_Text_Table_Type
179: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
180: , x_return_status OUT VARCHAR2
181: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
182: )
183: RETURN bis_vg_types.view_character_pointer_type;

Line 183: RETURN bis_vg_types.view_character_pointer_type;

179: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
180: , x_return_status OUT VARCHAR2
181: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
182: )
183: RETURN bis_vg_types.view_character_pointer_type;
184:
185: -- return TRUE if pointer is a null
186: FUNCTION null_pointer
187: (p_pointer IN bis_vg_types.view_character_pointer_type

Line 187: (p_pointer IN bis_vg_types.view_character_pointer_type

183: RETURN bis_vg_types.view_character_pointer_type;
184:
185: -- return TRUE if pointer is a null
186: FUNCTION null_pointer
187: (p_pointer IN bis_vg_types.view_character_pointer_type
188: , x_return_status OUT VARCHAR2
189: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
190: )
191: RETURN BOOLEAN;

Line 195: ( p_view_table IN bis_vg_types.View_Text_Table_Type

191: RETURN BOOLEAN;
192:
193: -- returns the row pointed to by the pointer
194: FUNCTION get_row
195: ( p_view_table IN bis_vg_types.View_Text_Table_Type
196: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
197: , x_return_status OUT VARCHAR2
198: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
199: )

Line 196: , p_pointer IN bis_vg_types.View_Character_Pointer_Type

192:
193: -- returns the row pointed to by the pointer
194: FUNCTION get_row
195: ( p_view_table IN bis_vg_types.View_Text_Table_Type
196: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
197: , x_return_status OUT VARCHAR2
198: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
199: )
200: RETURN bis_vg_types.view_text_table_rec_type;

Line 200: RETURN bis_vg_types.view_text_table_rec_type;

196: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
197: , x_return_status OUT VARCHAR2
198: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
199: )
200: RETURN bis_vg_types.view_text_table_rec_type;
201:
202: -- increments the pointer to next row
203: FUNCTION increment_pointer_by_row
204: ( p_view_table IN bis_vg_types.View_Text_Table_Type

Line 204: ( p_view_table IN bis_vg_types.View_Text_Table_Type

200: RETURN bis_vg_types.view_text_table_rec_type;
201:
202: -- increments the pointer to next row
203: FUNCTION increment_pointer_by_row
204: ( p_view_table IN bis_vg_types.View_Text_Table_Type
205: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
206: , x_return_status OUT VARCHAR2
207: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
208: )

Line 205: , p_pointer IN bis_vg_types.View_Character_Pointer_Type

201:
202: -- increments the pointer to next row
203: FUNCTION increment_pointer_by_row
204: ( p_view_table IN bis_vg_types.View_Text_Table_Type
205: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
206: , x_return_status OUT VARCHAR2
207: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
208: )
209: RETURN bis_vg_types.view_character_pointer_type;

Line 209: RETURN bis_vg_types.view_character_pointer_type;

205: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
206: , x_return_status OUT VARCHAR2
207: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
208: )
209: RETURN bis_vg_types.view_character_pointer_type;
210:
211: -- this function returns the generated view name for the original view name
212: FUNCTION get_generated_view_name
213: (p_view_name IN VARCHAR2