DBA Data[Home] [Help]

APPS.FII_AP_INV_ON_HOLD_F_C dependencies on FND_INSTALLATION

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

22: l_status VARCHAR2(30);
23: l_industry VARCHAR2(30);
24:
25: BEGIN
26: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
27: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.'||table_name;
28: EXECUTE IMMEDIATE l_stmt;
29: END IF;
30: edw_log.put_line(' ');

Line 546: /*IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN

542: AND NVL(aps.hold_flag, ''N'') = ''Y''
543: AND aps.last_update_date BETWEEN :g_push_date_range1 and :g_push_date_range2'||l_er_stmt;
544: --**
545:
546: /*IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
547: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_fii_schema,
548: TABNAME => 'FII_TMP_PK') ;
549: END IF; */
550: