23: l_industry VARCHAR2(30);
24:
25: BEGIN
26:
27: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
28: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_BUDGET_PK';
29: EXECUTE IMMEDIATE l_stmt;
30: END IF;
31:
51: l_status VARCHAR2(30);
52: l_industry VARCHAR2(30);
53:
54: BEGIN
55: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
56: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_BUDGET_FSTG';
57: EXECUTE IMMEDIATE l_stmt;
58: END IF;
59: END;
467: edw_log.put_line('Inserted ' || nvl(SQL%ROWCOUNT,0) || ' records into primary key table' );
468: edw_log.put_line('date passed in '||to_char (p_conversion_date));
469: end if;
470:
471: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
472:
473: l_stmt := 'ANALYZE TABLE ' || l_fii_schema || '.FII_PA_BUDGET_PK COMPUTE STATISTICS';
474: EXECUTE IMMEDIATE l_stmt;
475: