DBA Data[Home] [Help]

APPS.FII_PA_BUDGET_F_C dependencies on FND_INSTALLATION

Line 27: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN

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:

Line 55: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN

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;

Line 471: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN

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: