APPS.CZ_MODEL_MIGRATION_PVT dependencies on CZ_SERVERS

Line 839: FROM cz_servers

835:
836: --get the current value for converted flag
837: SELECT converted_target_flag
838: INTO l_converted_target_flag
839: FROM cz_servers
840: WHERE local_name = 'LOCAL';
841:
842: IF l_converted_target_flag = '1' THEN
843: RAISE ALREADY_MIGRATED_EXCEPTION;

Line 847: update cz_servers

843: RAISE ALREADY_MIGRATED_EXCEPTION;
844: END IF;
845:
846: --update the target server flag
847: update cz_servers
848: set converted_target_flag = '1' where
849: LOCAL_NAME = 'LOCAL';
850:
851: --update the source server flag

Line 854: update cz_servers

850:
851: --update the source server flag
852: --this will ensure that this server will be presented as a
853: --migration target my target_open_for function.
854: update cz_servers
855: set source_server_flag = '0' where
856: source_server_flag = '1';
857: --create a pseudo record for all the target publications
858: SELECT cz_model_publications_s.NEXTVAL, publication_id

Line 991: FROM cz_servers

987:
988: --get the local server id of the instance name
989: SELECT server_local_id
990: INTO l_server_id
991: FROM cz_servers
992: WHERE UPPER (local_name) = UPPER (r_instance_name);
993:
994:
995: obselete_exists := '0';

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

1091: RETURN target_not_open;
1092: END IF;
1093:
1094: l_sql_str :=
1095: 'SELECT NVL(source_server_flag,''0''), local_name FROM cz_servers@' || p_link_name || ' ' ||
1096: 'WHERE source_server_flag = ''1'' ';
1097:
1098: EXECUTE IMMEDIATE l_sql_str
1099: INTO l_source_server_flag, target_instance_for_pub;

Line 1106: FROM cz_servers

1102: IF (p_migration_or_publishing = MODE_PUBLICATION) THEN
1103:
1104: SELECT instance_name
1105: INTO local_instance_name
1106: FROM cz_servers
1107: WHERE local_name = 'LOCAL';
1108:
1109: IF (local_instance_name=target_instance_for_pub) THEN
1110: RETURN target_open;

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

1149: END IF;
1150:
1151: -- check if publishable, this query will using the link on the remote machine
1152: OPEN gl_ref_cursor FOR 'SELECT converted_target_flag
1153: FROM cz_servers@'||p_link_name || ' where converted_target_flag = ''1''
1154: and local_name = ''LOCAL'' ';
1155: LOOP
1156: FETCH gl_ref_cursor INTO r_converted_target_flag;
1157: IF (r_converted_target_flag = TARGET_SERVER_PUBLISH_NOTALLOW) THEN

Line 1204: FROM cz_servers

1200: -- collect the link name of the publishing target
1201: SELECT fndnam_link_name, instance_name
1202: BULK COLLECT
1203: INTO l_link_name_tbl, l_instance_name_tbl
1204: FROM cz_servers
1205: WHERE local_name <> 'LOCAL' AND FNDNAM_LINK_NAME IS NOT NULL ;
1206:
1207: -- for each of the link_names collected, check if the
1208: -- remote target is still publishable