126: from fnd_tables t, fnd_application a
127: where table_name = p_table_name
128: and t.application_id = a.application_id;
129: l_dummy number;
130: -- Local variables to use the fnd_installation.get_app_info
131: lv_status VARCHAR2(5);
132: lv_industry VARCHAR2(5);
133: lv_schema VARCHAR2(30);
134: lv_return BOOLEAN;
150: if (l_find_appl_short_name%notfound) then
151: close l_find_appl_short_name;
152: return FALSE;
153: else
154: lv_return := fnd_installation.get_app_info(l_temp,lv_status,lv_industry,lv_schema);
155: end if;
156: close l_find_appl_short_name;
157: open l_check_all_column_csr(lv_schema);
158: fetch l_check_all_column_csr into l_dummy;
200: from fnd_tables t, fnd_application a
201: where table_name = p_table_name
202: and t.application_id = a.application_id;
203: l_dummy number;
204: -- Local variables to use the fnd_installation.get_app_info
205: lv_status VARCHAR2(5);
206: lv_industry VARCHAR2(5);
207: lv_schema VARCHAR2(30);
208: lv_return BOOLEAN;
213: if (l_find_appl_short_name%notfound) then
214: close l_find_appl_short_name;
215: return FALSE;
216: else
217: lv_return := fnd_installation.get_app_info(l_temp,lv_status,lv_industry,lv_schema);
218: end if;
219: close l_find_appl_short_name;
220: open l_check_table_csr(lv_schema);
221: fetch l_check_table_csr into l_dummy;