73: BEGIN
74:
75: IF (p_type = 1) THEN
76:
77: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
78: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_PDIST';
79: EXECUTE IMMEDIATE l_stmt;
80: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_PDIST1';
81: EXECUTE IMMEDIATE l_stmt;
95:
96: END IF;
97:
98: IF (p_type = 2) THEN
99: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry,
100: l_poa_schema)) THEN
101: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||
102: '.POA_PORTAL_FII_SUMMARY';
103: EXECUTE IMMEDIATE l_stmt;