APPS.POA_DBI_RCV_TXN_F_C dependencies on FND_INSTALLATION

Line 15: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN

11: l_industry VARCHAR2(30);
12:
13: l_stmt VARCHAR2(4000);
14: BEGIN
15: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
16: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_F';
17: EXECUTE IMMEDIATE l_stmt;
18:
19: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_INC';

Line 139: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN

135: l_batch_size := 10000;
136: END if;
137:
138: bis_collection_utilities.log('Truncate INC table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
139: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
140: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_INC';
141: EXECUTE IMMEDIATE l_stmt;
142:
143: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_RATES';

Line 242: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN

238: COMMIT;
239:
240: DBMS_APPLICATION_INFO.SET_ACTION('stats incremental');
241:
242: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
243: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
244: TABNAME => 'POA_DBI_RTX_INC') ;
245: END IF;
246:

Line 290: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN

286:
287: commit;
288: DBMS_APPLICATION_INFO.SET_ACTION('stats rates');
289:
290: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
291: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
292: TABNAME => 'POA_DBI_RTX_RATES') ;
293: END IF;
294: