APPS.OPI_DBI_WMS_RTP_F_C dependencies on FND_INSTALLATION

Line 15: IF (FND_INSTALLATION.GET_APP_INFO('OPI', l_status, l_industry, l_opi_schema)) THEN

11: l_industry VARCHAR2(30);
12:
13: l_stmt VARCHAR2(4000);
14: BEGIN
15: IF (FND_INSTALLATION.GET_APP_INFO('OPI', l_status, l_industry, l_opi_schema)) THEN
16: l_stmt := 'TRUNCATE TABLE ' || l_opi_schema || '.OPI_DBI_WMS_RTP_F';
17: EXECUTE IMMEDIATE l_stmt;
18: g_init := true;
19: populate_rtp_fact (errbuf, retcode);

Line 96: if (not(fnd_installation.get_app_info('OPI', l_status, l_industry, l_opi_schema))) then

92: l_glob_date := To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS');
93: d_glob_date := bis_common_parameters.get_global_start_date;
94:
95: DBMS_APPLICATION_INFO.SET_ACTION('rates');
96: if (not(fnd_installation.get_app_info('OPI', l_status, l_industry, l_opi_schema))) then
97: bis_collection_utilities.log('Error getting app info '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
98: RAISE_APPLICATION_ERROR (-20000, 'Error in GET_APP_INFO: ' || errbuf);
99: end if;
100: l_stmt := 'TRUNCATE TABLE ' || l_opi_schema || '.OPI_DBI_WMS_UOM_RATES';