DBA Data[Home] [Help]

APPS.AK_OBJECT_PVT dependencies on FND_INSTALLATION

Line 137: -- Local variables to use the fnd_installation.get_app_info

133: from fnd_tables t, fnd_application a
134: where table_name = p_table_name
135: and t.application_id = a.application_id;
136: l_dummy number;
137: -- Local variables to use the fnd_installation.get_app_info
138: lv_status VARCHAR2(5);
139: lv_industry VARCHAR2(5);
140: lv_schema VARCHAR2(30);
141: lv_return BOOLEAN;

Line 161: lv_return := fnd_installation.get_app_info(l_temp,lv_status,lv_industry,lv_schema);

157: if (l_find_appl_short_name%notfound) then
158: close l_find_appl_short_name;
159: return FALSE;
160: else
161: lv_return := fnd_installation.get_app_info(l_temp,lv_status,lv_industry,lv_schema);
162: end if;
163: close l_find_appl_short_name;
164: open l_check_all_column_csr(lv_schema);
165: fetch l_check_all_column_csr into l_dummy;

Line 211: -- Local variables to use the fnd_installation.get_app_info

207: from fnd_tables t, fnd_application a
208: where table_name = p_table_name
209: and t.application_id = a.application_id;
210: l_dummy number;
211: -- Local variables to use the fnd_installation.get_app_info
212: lv_status VARCHAR2(5);
213: lv_industry VARCHAR2(5);
214: lv_schema VARCHAR2(30);
215: lv_return BOOLEAN;

Line 224: lv_return := fnd_installation.get_app_info(l_temp,lv_status,lv_industry,lv_schema);

220: if (l_find_appl_short_name%notfound) then
221: close l_find_appl_short_name;
222: return FALSE;
223: else
224: lv_return := fnd_installation.get_app_info(l_temp,lv_status,lv_industry,lv_schema);
225: end if;
226: close l_find_appl_short_name;
227: open l_check_table_csr(lv_schema);
228: fetch l_check_table_csr into l_dummy;