APPS.CZ_PUBL_SYNC_CRASH dependencies on CZ_PUBLICATION_USAGES

Line 207: DELETE FROM cz_publication_usages

203: DELETE FROM cz_pb_client_apps
204: WHERE publication_id in (SELECT publication_id from cz_model_publications
205: where server_id = p_target_server_id);
206:
207: DELETE FROM cz_publication_usages
208: WHERE publication_id in (SELECT publication_id from cz_model_publications
209: where server_id = p_target_server_id);
210:
211: DELETE FROM cz_pb_languages

Line 248: DELETE FROM cz_publication_usages

244: WHERE publication_id in (SELECT publication_id from cz_model_publications
245: where server_id = p_target_server_id
246: and model_last_updated > p_date);
247:
248: DELETE FROM cz_publication_usages
249: WHERE publication_id in (SELECT publication_id from cz_model_publications
250: where server_id = p_target_server_id
251: and model_last_updated > p_date);
252:

Line 296: ' DELETE FROM cz_publication_usages' || p_link_name ||

292: ' WHERE publication_id = :1'
293: USING p_publication_id;
294:
295: EXECUTE IMMEDIATE
296: ' DELETE FROM cz_publication_usages' || p_link_name ||
297: ' WHERE publication_id = :1'
298: USING p_publication_id;
299:
300: EXECUTE IMMEDIATE

Line 457: FROM CZ_PUBLICATION_USAGES

453: FROM CZ_PB_LANGUAGES
454: WHERE publication_id = publicationId;
455:
456: SELECT usage_id BULK COLLECT INTO lPublUsages
457: FROM CZ_PUBLICATION_USAGES
458: WHERE publication_id = publicationId;
459:
460: SELECT fnd_application_id BULK COLLECT INTO lPublApps
461: FROM CZ_PB_CLIENT_APPS

Line 466: EXECUTE IMMEDIATE 'Begin SELECT usage_id bulk collect INTO rPublUsages FROM CZ_PUBLICATION_USAGES' || linkName || ' WHERE publication_id = publicationId; End;';

462: WHERE publication_id = publicationId;
463:
464: EXECUTE IMMEDIATE 'Begin SELECT language bulk collect INTO rPublishedLanguages FROM CZ_PB_LANGUAGES' || linkName || ' WHERE publication_id = publicationId; End;';
465:
466: EXECUTE IMMEDIATE 'Begin SELECT usage_id bulk collect INTO rPublUsages FROM CZ_PUBLICATION_USAGES' || linkName || ' WHERE publication_id = publicationId; End;';
467:
468: EXECUTE IMMEDIATE 'Begin SELECT fnd_application_id bulk collect INTO rPublApps FROM CZ_PB_CLIENT_APPS' || linkName || ' WHERE publication_id = publicationId; End;';
469:
470: IF (lPublishedLanguages.COUNT > 0) THEN

Line 683: ' INSERT INTO CZ_PUBLICATION_USAGES( PUBLICATION_ID, USAGE_ID) ' ||

679: ' (SELECT v_pub_tbl(i),FND_APPLICATION_ID, APPLICATION_SHORT_NAME, NOTES FROM CZ_PB_CLIENT_APPS'|| lLinkName || 'r ' ||
680: ' WHERE r.publication_id = lPublicationId';
681:
682: EXECUTE IMMEDIATE
683: ' INSERT INTO CZ_PUBLICATION_USAGES( PUBLICATION_ID, USAGE_ID) ' ||
684: ' VALUES (SELECT v_pub_tbl(i),usage_id FROM Z_PUBLICATION_USAGES'|| lLinkName || 'r ' ||
685: ' WHERE r.publication_id = lPublicationId';
686:
687: END LOOP;