DBA Data[Home] [Help]

APPS.ICX_ON_CABO dependencies on AK_OBJECT_ATTRIBUTES

Line 182: TYPE T_COLUMN_NAME IS TABLE OF AK_OBJECT_ATTRIBUTES.COLUMN_NAME%TYPE;

178: l_submit VARCHAR2(240);
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:

Line 190: COLUMN_NAME AK_OBJECT_ATTRIBUTES.COLUMN_NAME%TYPE,

186:
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: );

Line 210: AK_OBJECT_ATTRIBUTES d,

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
213: where a.REGION_APPLICATION_ID = p_region_appl_id
214: and a.REGION_CODE = p_region_code