APPS.CZ_PUBL_SYNC_CRASH dependencies on CZ_PB_MODEL_EXPORTS

Line 215: DELETE FROM cz_pb_model_exports

211: DELETE FROM cz_pb_languages
212: WHERE publication_id in (SELECT publication_id from cz_model_publications
213: where server_id = p_target_server_id);
214:
215: DELETE FROM cz_pb_model_exports
216: WHERE server_id = p_target_server_id;
217: COMMIT;
218: EXCEPTION
219: WHEN OTHERS THEN

Line 258: DELETE FROM cz_pb_model_exports

254: WHERE publication_id in (SELECT publication_id from cz_model_publications
255: where server_id = p_target_server_id
256: and model_last_updated > p_date);
257:
258: DELETE FROM cz_pb_model_exports
259: WHERE server_id = p_target_server_id;
260: COMMIT;
261: EXCEPTION
262: WHEN OTHERS THEN

Line 306: ' DELETE FROM cz_pb_model_exports' || p_link_name ||

302: ' WHERE publication_id publication_id = :1'
303: USING p_publication_id;
304:
305: EXECUTE IMMEDIATE
306: ' DELETE FROM cz_pb_model_exports' || p_link_name ||
307: ' WHERE server_id = :1'
308: USING p_target_server_id;
309:
310: COMMIT;

Line 417: ' DELETE FROM CZ_PB_MODEL_EXPORTS' || lLinkName ||

413: ' WHERE hostname = ' || lHostName ||
414: ' AND instance_name = ' || lSid;
415:
416: EXECUTE IMMEDIATE
417: ' DELETE FROM CZ_PB_MODEL_EXPORTS' || lLinkName ||
418: ' WHERE server_id = :1 AND last_update_date = :2'
419: USING lTargetServerId, p_date;
420:
421: COMMIT;