DBA Data[Home] [Help]

APPS.CZ_MODELOPERATIONS_PUB dependencies on CZ_ORAAPPS_INTEGRATE

Line 742: IF CZ_ORAAPPS_INTEGRATE.isLinkAlive(l_db_link)=CZ_ORAAPPS_INTEGRATE.LINK_WORKS THEN

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;

Line 743: l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_db_link);

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;

Line 926: IF CZ_ORAAPPS_INTEGRATE.isLinkAlive(l_db_link)=CZ_ORAAPPS_INTEGRATE.LINK_WORKS THEN

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;

Line 927: l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_db_link);

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;