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;
82: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_PDIST2';
83: EXECUTE IMMEDIATE l_stmt;
84: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_SPERF';
463: item.IORG_Purchaseable_Flag;
464:
465: p_count := sql%rowcount;
466:
467: insert into POA_PORTAL_PDIST1 (
468: SUM_PURCHASES,
469: SUM_LEAKAGE,
470: SUM_NON_CONTRACT,
471: SUM_CONTRACT,