DBA Data[Home] [Help]

APPS.ICX_ON_CABO dependencies on AK_ATTRIBUTES

Line 183: TYPE T_DATA_TYPE IS TABLE OF AK_ATTRIBUTES.DATA_TYPE%TYPE;

179:
180: --begin additions for bulk fetch change from 1574527 mputman
181: --collections for bulk fetch
182: TYPE T_COLUMN_NAME IS TABLE OF AK_OBJECT_ATTRIBUTES.COLUMN_NAME%TYPE;
183: TYPE T_DATA_TYPE IS TABLE OF AK_ATTRIBUTES.DATA_TYPE%TYPE;
184: TYPE T_ATTRIBUTE_LABEL_LONG IS TABLE OF AK_REGION_ITEMS_VL.ATTRIBUTE_LABEL_LONG%TYPE;
185: TYPE T_ICX_CUSTOM_CALL IS TABLE OF AK_REGION_ITEMS.ICX_CUSTOM_CALL%TYPE;
186:
187: --record defining plsql table to replace cursor in loop

Line 191: DATA_TYPE AK_ATTRIBUTES.DATA_TYPE%TYPE,

187: --record defining plsql table to replace cursor in loop
188: TYPE t_attr_rec IS RECORD
189: (
190: COLUMN_NAME AK_OBJECT_ATTRIBUTES.COLUMN_NAME%TYPE,
191: DATA_TYPE AK_ATTRIBUTES.DATA_TYPE%TYPE,
192: ATTRIBUTE_LABEL_LONG AK_REGION_ITEMS_VL.ATTRIBUTE_LABEL_LONG%TYPE,
193: ICX_CUSTOM_CALL AK_REGION_ITEMS.ICX_CUSTOM_CALL%TYPE
194: );
195: --definition of table replacing cursor in loop

Line 208: from AK_ATTRIBUTES b,

204: -- end additions from bulk fetch 1574527 mputman
205:
206: cursor FindAttributes is
207: select d.COLUMN_NAME,b.DATA_TYPE,a.ATTRIBUTE_LABEL_LONG,e.ICX_CUSTOM_CALL
208: from AK_ATTRIBUTES b,
209: AK_REGIONS c,
210: AK_OBJECT_ATTRIBUTES d,
211: AK_REGION_ITEMS e,
212: AK_REGION_ITEMS_VL a