APPS.CZ_MODEL_MIGRATION_PVT dependencies on CZ_SERVERS

Line 863: FROM cz_servers

859:
860: --get the current value for converted flag
861: SELECT converted_target_flag
862: INTO l_converted_target_flag
863: FROM cz_servers
864: WHERE local_name = 'LOCAL';
865:
866: IF l_converted_target_flag = '1' THEN
867: RAISE ALREADY_MIGRATED_EXCEPTION;

Line 871: update cz_servers

867: RAISE ALREADY_MIGRATED_EXCEPTION;
868: END IF;
869:
870: --update the target server flag
871: update cz_servers
872: set converted_target_flag = '1' where
873: LOCAL_NAME = 'LOCAL';
874:
875: --update the source server flag

Line 878: update cz_servers

874:
875: --update the source server flag
876: --this will ensure that this server will be presented as a
877: --migration target my target_open_for function.
878: update cz_servers
879: set source_server_flag = '0' where
880: source_server_flag = '1';
881: --create a pseudo record for all the target publications
882: SELECT cz_model_publications_s.NEXTVAL, publication_id

Line 1015: FROM cz_servers

1011:
1012: --get the local server id of the instance name
1013: SELECT server_local_id
1014: INTO l_server_id
1015: FROM cz_servers
1016: WHERE UPPER (local_name) = UPPER (r_instance_name);
1017:
1018:
1019: obselete_exists := '0';

Line 1119: 'SELECT NVL(source_server_flag,''0''), local_name FROM cz_servers@' || p_link_name || ' ' ||

1115: RETURN target_not_open;
1116: END IF;
1117:
1118: l_sql_str :=
1119: 'SELECT NVL(source_server_flag,''0''), local_name FROM cz_servers@' || p_link_name || ' ' ||
1120: 'WHERE source_server_flag = ''1'' ';
1121:
1122: EXECUTE IMMEDIATE l_sql_str
1123: INTO l_source_server_flag, target_instance_for_pub;

Line 1130: FROM cz_servers

1126: IF (p_migration_or_publishing = MODE_PUBLICATION) THEN
1127:
1128: SELECT instance_name
1129: INTO local_instance_name
1130: FROM cz_servers
1131: WHERE local_name = 'LOCAL';
1132:
1133: IF (local_instance_name=target_instance_for_pub) THEN
1134: RETURN target_open;

Line 1177: FROM cz_servers@'||p_link_name || ' where converted_target_flag = ''1''

1173: END IF;
1174:
1175: -- check if publishable, this query will using the link on the remote machine
1176: OPEN gl_ref_cursor FOR 'SELECT converted_target_flag
1177: FROM cz_servers@'||p_link_name || ' where converted_target_flag = ''1''
1178: and local_name = ''LOCAL'' ';
1179: LOOP
1180: FETCH gl_ref_cursor INTO r_converted_target_flag;
1181: IF (r_converted_target_flag = TARGET_SERVER_PUBLISH_NOTALLOW) THEN

Line 1228: FROM cz_servers

1224: -- collect the link name of the publishing target
1225: SELECT fndnam_link_name, instance_name
1226: BULK COLLECT
1227: INTO l_link_name_tbl, l_instance_name_tbl
1228: FROM cz_servers
1229: WHERE local_name <> 'LOCAL' AND FNDNAM_LINK_NAME IS NOT NULL ;
1230:
1231: -- for each of the link_names collected, check if the
1232: -- remote target is still publishable