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
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
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;