59: l_schema varchar2(400);
60: l_prod_no VARCHAR2(30);
61: Begin
62: l_prod_no :='BIS';
63: if FND_INSTALLATION.GET_APP_INFO(l_prod_no,l_dummy1, l_dummy2,l_schema) = false then
64: edw_log.put_line('FND_INSTALLATION.GET_APP_INFO returned with error');
65: return null;
66: end if;
67: return l_schema;
60: l_prod_no VARCHAR2(30);
61: Begin
62: l_prod_no :='BIS';
63: if FND_INSTALLATION.GET_APP_INFO(l_prod_no,l_dummy1, l_dummy2,l_schema) = false then
64: edw_log.put_line('FND_INSTALLATION.GET_APP_INFO returned with error');
65: return null;
66: end if;
67: return l_schema;
68: Exception when others then