DBA Data[Home] [Help]

APPS.AK_OBJECT_PVT dependencies on USER_TAB_COLUMNS

Line 109: from USER_TAB_COLUMNS a

105: p_column_name IN VARCHAR2
106: ) return BOOLEAN is
107: cursor l_check_user_column_csr is
108: select 1
109: from USER_TAB_COLUMNS a
110: where a.table_name = p_table_name
111: and a.column_name = p_column_name;
112: cursor l_check_fnd_column_csr is
113: select 1

Line 128: from user_tab_columns col

124: and a.column_name = p_column_name
125: and a.owner = oracle_schema
126: union
127: select 1
128: from user_tab_columns col
129: where col.table_name = p_table_name
130: and col.column_name = p_column_name;
131: cursor l_find_appl_short_name is
132: select a.application_short_name

Line 144: -- Check USER_TAB_COLUMNS

140: lv_schema VARCHAR2(30);
141: lv_return BOOLEAN;
142: l_temp VARCHAR2(50);
143: begin
144: -- Check USER_TAB_COLUMNS
145: open l_check_user_column_csr;
146: fetch l_check_user_column_csr into l_dummy;
147: if (l_check_user_column_csr%notfound) then
148: close l_check_user_column_csr;