DBA Data[Home] [Help]

APPS.CZ_MODELOPERATIONS_PUB dependencies on CZ_ORAAPPS_INTEGRATE

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

740: -- in this case try to recreate views based on remote tables if
741: -- db link is alive
742: --
743: IF l_Exist='N' THEN
744: IF CZ_ORAAPPS_INTEGRATE.isLinkAlive(l_db_link)=CZ_ORAAPPS_INTEGRATE.LINK_WORKS THEN
745: -- 10011026 create_exv_views procedure is expecting local name as opposed to dblink name
746: -- l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_db_link);
747: l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_local_name);
748: IF l_err<>'0' THEN

Line 746: -- l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_db_link);

742: --
743: IF l_Exist='N' THEN
744: IF CZ_ORAAPPS_INTEGRATE.isLinkAlive(l_db_link)=CZ_ORAAPPS_INTEGRATE.LINK_WORKS THEN
745: -- 10011026 create_exv_views procedure is expecting local name as opposed to dblink name
746: -- l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_db_link);
747: l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_local_name);
748: IF l_err<>'0' THEN
749: -- not all EXV views have been recreated --
750: RAISE WRONG_EXV_VIEWS;

Line 747: l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_local_name);

743: IF l_Exist='N' THEN
744: IF CZ_ORAAPPS_INTEGRATE.isLinkAlive(l_db_link)=CZ_ORAAPPS_INTEGRATE.LINK_WORKS THEN
745: -- 10011026 create_exv_views procedure is expecting local name as opposed to dblink name
746: -- l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_db_link);
747: l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_local_name);
748: IF l_err<>'0' THEN
749: -- not all EXV views have been recreated --
750: RAISE WRONG_EXV_VIEWS;
751: END IF;

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

926: -- in this case try to recreate views based on remote tables if
927: -- db link is alive
928: --
929: IF l_Exist='N' THEN
930: IF CZ_ORAAPPS_INTEGRATE.isLinkAlive(l_db_link)=CZ_ORAAPPS_INTEGRATE.LINK_WORKS THEN
931: l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_db_link);
932: IF l_err<>'0' THEN
933: -- not all EXV views have been recreated --
934: RAISE WRONG_EXV_VIEWS;

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

927: -- db link is alive
928: --
929: IF l_Exist='N' THEN
930: IF CZ_ORAAPPS_INTEGRATE.isLinkAlive(l_db_link)=CZ_ORAAPPS_INTEGRATE.LINK_WORKS THEN
931: l_err:=CZ_ORAAPPS_INTEGRATE.create_exv_views(l_db_link);
932: IF l_err<>'0' THEN
933: -- not all EXV views have been recreated --
934: RAISE WRONG_EXV_VIEWS;
935: END IF;