APPS.POA_DBI_NEG_F_C dependencies on FND_INSTALLATION

Line 16: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN

12: l_status VARCHAR2(30);
13: l_industry VARCHAR2(30);
14: l_stmt VARCHAR2(4000);
15: BEGIN
16: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
17: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_F';
18: EXECUTE immediate l_stmt;
19:
20: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_INC';

Line 129: IF (fnd_installation.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN

125: l_batch_size := 10000;
126: END IF;
127:
128: bis_collection_utilities.log('Truncate Currency Conversion table: '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
129: IF (fnd_installation.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
130: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_INC';
131: EXECUTE IMMEDIATE l_stmt;
132: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_RATES';
133: EXECUTE IMMEDIATE l_stmt;

Line 241: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN

237: END IF;
238: COMMIT;
239: dbms_application_info.set_action('stats incremental');
240:
241: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
242: fnd_stats.gather_table_stats(ownname => l_poa_schema, tabname => 'POA_DBI_NEG_INC') ;
243: END IF;
244:
245: INSERT /*+ APPEND */ INTO poa_dbi_neg_rates

Line 288: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN

284: COMMIT;
285:
286: dbms_application_info.set_action('stats rates');
287:
288: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
289: fnd_stats.gather_table_stats(ownname => l_poa_schema,
290: tabname => 'POA_DBI_NEG_RATES') ;
291: END IF;
292: