DBA Data[Home] [Help]

APPS.POA_EDW_PO_DIST_F_C dependencies on FND_INSTALLATION

Line 28: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN

24: l_industry VARCHAR2(30);
25:
26: BEGIN
27:
28: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
29: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_EDW_PO_DIST_INC';
30: EXECUTE IMMEDIATE l_stmt;
31: END IF;
32:

Line 625: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN

621: end loop;
622: close v_changed_rows;
623:
624: COMMIT;
625: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
626: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema, TABNAME => 'POA_EDW_PO_DIST_INC') ;
627: END IF;
628:
629: RETURN(l_seq_id);