738: -- in this case try to recreate views based on remote tables if
739: -- db link is alive
740: --
741: IF l_Exist='N' THEN
742: IF CZ_ORAAPPS_INTEGRATE.isLinkAlive(l_db_link)=CZ_ORAAPPS_INTEGRATE.LINK_WORKS THEN
743: l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_db_link);
744: IF l_err<>'0' THEN
745: -- not all EXV views have been recreated --
746: RAISE WRONG_EXV_VIEWS;
739: -- db link is alive
740: --
741: IF l_Exist='N' THEN
742: IF CZ_ORAAPPS_INTEGRATE.isLinkAlive(l_db_link)=CZ_ORAAPPS_INTEGRATE.LINK_WORKS THEN
743: l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_db_link);
744: IF l_err<>'0' THEN
745: -- not all EXV views have been recreated --
746: RAISE WRONG_EXV_VIEWS;
747: END IF;
922: -- in this case try to recreate views based on remote tables if
923: -- db link is alive
924: --
925: IF l_Exist='N' THEN
926: IF CZ_ORAAPPS_INTEGRATE.isLinkAlive(l_db_link)=CZ_ORAAPPS_INTEGRATE.LINK_WORKS THEN
927: l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_db_link);
928: IF l_err<>'0' THEN
929: -- not all EXV views have been recreated --
930: RAISE WRONG_EXV_VIEWS;
923: -- db link is alive
924: --
925: IF l_Exist='N' THEN
926: IF CZ_ORAAPPS_INTEGRATE.isLinkAlive(l_db_link)=CZ_ORAAPPS_INTEGRATE.LINK_WORKS THEN
927: l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_db_link);
928: IF l_err<>'0' THEN
929: -- not all EXV views have been recreated --
930: RAISE WRONG_EXV_VIEWS;
931: END IF;