[Home] [Help]
343: )
344: IS
345:
346: -- table declaration
347: TYPE obj_attr_tbl_type IS TABLE OF OE_DEF_AK_ATTR_EXT_V%ROWTYPE
348: INDEX BY BINARY_INTEGER;
349:
350: l_obj_attr_tbl obj_attr_tbl_type;
351:
1205: is
1206: SELECT DEFAULTING_API_PKG,
1207: DEFAULTING_API_PROC,NVL(DATA_TYPE,'CHAR'),
1208: COLUMN_NAME
1209: FROM OE_DEF_AK_ATTR_EXT_V
1210: WHERE DATABASE_OBJECT_NAME = p_database_object_name
1211: AND attribute_application_id = p_application_id
1212: AND attribute_code = p_attribute_code;
1213: CURSOR APP is
1414: /* =========== Code appended for the bug 3081991 =========== */
1415:
1416: select ada.data_type
1417: into l_src_data_type
1418: from OE_DEF_AK_ATTR_EXT_V ada
1419: where ada.DATABASE_OBJECT_NAME = p_database_object_name
1420: and ada.ATTRIBUTE_APPLICATION_ID = p_application_id
1421: and ada.ATTRIBUTE_CODE = l_elem_attribute_code;
1422:
1705: is
1706: SELECT DEFAULTING_API_PKG,
1707: DEFAULTING_API_PROC,NVL(DATA_TYPE,'CHAR'),
1708: COLUMN_NAME
1709: FROM OE_DEF_AK_ATTR_EXT_V
1710: WHERE DATABASE_OBJECT_NAME = p_database_object_name
1711: AND attribute_application_id = p_application_id
1712: AND attribute_code = p_attribute_code;
1713: CURSOR APP is
2120: )
2121: IS
2122:
2123: -- table declaration
2124: TYPE obj_attr_tbl_type IS TABLE OF OE_DEF_AK_ATTR_EXT_V%ROWTYPE
2125: INDEX BY BINARY_INTEGER;
2126:
2127: TYPE foreign_keys_tbl_type IS TABLE OF OE_DEF_AK_FKEYS_V%ROWTYPE
2128: INDEX BY BINARY_INTEGER;
3425: )
3426: IS
3427:
3428: -- Table declarations
3429: TYPE obj_attr_tbl_type IS TABLE OF OE_DEF_AK_ATTR_EXT_V%ROWTYPE
3430: INDEX BY BINARY_INTEGER;
3431: l_data_attr_tbl obj_attr_tbl_type;
3432:
3433: -- variable declarations