DBA Data[Home] [Help]

APPS.ICX_CAT_BUILD_CTX_SQL_PVT dependencies on DBMS_SQL

Line 65: l_attribute_id_tbl DBMS_SQL.NUMBER_TABLE;

61: ORDER BY attribute_id;
62:
63: ----- Start of declaring columns selected in the cursor -----
64:
65: l_attribute_id_tbl DBMS_SQL.NUMBER_TABLE;
66: l_key_tbl DBMS_SQL.VARCHAR2_TABLE;
67: l_type_tbl DBMS_SQL.NUMBER_TABLE;
68: l_section_tag_tbl DBMS_SQL.NUMBER_TABLE;
69: l_stored_in_table_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 66: l_key_tbl DBMS_SQL.VARCHAR2_TABLE;

62:
63: ----- Start of declaring columns selected in the cursor -----
64:
65: l_attribute_id_tbl DBMS_SQL.NUMBER_TABLE;
66: l_key_tbl DBMS_SQL.VARCHAR2_TABLE;
67: l_type_tbl DBMS_SQL.NUMBER_TABLE;
68: l_section_tag_tbl DBMS_SQL.NUMBER_TABLE;
69: l_stored_in_table_tbl DBMS_SQL.VARCHAR2_TABLE;
70: l_stored_in_column_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 67: l_type_tbl DBMS_SQL.NUMBER_TABLE;

63: ----- Start of declaring columns selected in the cursor -----
64:
65: l_attribute_id_tbl DBMS_SQL.NUMBER_TABLE;
66: l_key_tbl DBMS_SQL.VARCHAR2_TABLE;
67: l_type_tbl DBMS_SQL.NUMBER_TABLE;
68: l_section_tag_tbl DBMS_SQL.NUMBER_TABLE;
69: l_stored_in_table_tbl DBMS_SQL.VARCHAR2_TABLE;
70: l_stored_in_column_tbl DBMS_SQL.VARCHAR2_TABLE;
71:

Line 68: l_section_tag_tbl DBMS_SQL.NUMBER_TABLE;

64:
65: l_attribute_id_tbl DBMS_SQL.NUMBER_TABLE;
66: l_key_tbl DBMS_SQL.VARCHAR2_TABLE;
67: l_type_tbl DBMS_SQL.NUMBER_TABLE;
68: l_section_tag_tbl DBMS_SQL.NUMBER_TABLE;
69: l_stored_in_table_tbl DBMS_SQL.VARCHAR2_TABLE;
70: l_stored_in_column_tbl DBMS_SQL.VARCHAR2_TABLE;
71:
72: ------ End of declaring columns selected in the cursor ------

Line 69: l_stored_in_table_tbl DBMS_SQL.VARCHAR2_TABLE;

65: l_attribute_id_tbl DBMS_SQL.NUMBER_TABLE;
66: l_key_tbl DBMS_SQL.VARCHAR2_TABLE;
67: l_type_tbl DBMS_SQL.NUMBER_TABLE;
68: l_section_tag_tbl DBMS_SQL.NUMBER_TABLE;
69: l_stored_in_table_tbl DBMS_SQL.VARCHAR2_TABLE;
70: l_stored_in_column_tbl DBMS_SQL.VARCHAR2_TABLE;
71:
72: ------ End of declaring columns selected in the cursor ------
73:

Line 70: l_stored_in_column_tbl DBMS_SQL.VARCHAR2_TABLE;

66: l_key_tbl DBMS_SQL.VARCHAR2_TABLE;
67: l_type_tbl DBMS_SQL.NUMBER_TABLE;
68: l_section_tag_tbl DBMS_SQL.NUMBER_TABLE;
69: l_stored_in_table_tbl DBMS_SQL.VARCHAR2_TABLE;
70: l_stored_in_column_tbl DBMS_SQL.VARCHAR2_TABLE;
71:
72: ------ End of declaring columns selected in the cursor ------
73:
74: l_api_name CONSTANT VARCHAR2(30) := 'buildMetadataInfo';