DBA Data[Home] [Help]

APPS.POA_DBI_PO_DIST_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_POD_F';
17: EXECUTE IMMEDIATE l_stmt;
18:
19: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_INC';

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

141: l_batch_size := 10000;
142: END if;
143:
144: bis_collection_utilities.log('Truncate INC table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
145: IF (NOT(FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema))) THEN
146: bis_collection_utilities.log('Error getting app info '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
147: RAISE_APPLICATION_ERROR (-20000, 'Error in GET_APP_INFO: ' || errbuf);
148: END IF;
149: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_INC';