DBA Data[Home] [Help]

APPS.FII_AP_INV_LINES_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 553: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN

549:
550:
551: /* need to analyze the temp table */
552:
553: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
554: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_fii_schema,
555: TABNAME => 'FII_AP_TMP_LINE_PK') ;
556: END IF;
557:

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

1058: AND xah.ae_header_id=xal.ae_header_id
1059: AND xah.ledger_id=aid.set_of_books_id '||l_er_stmt;
1060: --**
1061:
1062: /* IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
1063: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_fii_schema,
1064: TABNAME => 'FII_TMP_PK') ;
1065: END IF; */
1066:

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

1082:
1083: edw_log.debug_line( 'NO OF ROWS CHANGED '||
1084: to_char(p_count));
1085:
1086: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
1087: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_fii_schema,
1088: TABNAME => 'FII_AP_TMP_LINE_PK') ;
1089: END IF;
1090: --**