eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_PUBL_SYNC_CRASH dependencies on CZ_PB_CLIENT_APPS

Line 203: DELETE FROM cz_pb_client_apps

199: UPDATE cz_model_publications
200: SET deleted_flag = '1'
201: WHERE server_id = p_target_server_id;
202:
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

Line 243: DELETE FROM cz_pb_client_apps

239: SET deleted_flag = '1'
240: WHERE server_id = p_target_server_id
241: and model_last_updated > p_date;
242:
243: DELETE FROM cz_pb_client_apps
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:

Line 291: ' DELETE FROM cz_pb_client_apps' || p_link_name ||

287: ' SET deleted_flag = ''1'' WHERE publication_id = :1 AND last_update_date > :2'
288: USING p_publication_id, p_date;
289:
290: EXECUTE IMMEDIATE
291: ' DELETE FROM cz_pb_client_apps' || p_link_name ||
292: ' WHERE publication_id = :1'
293: USING p_publication_id;
294:
295: EXECUTE IMMEDIATE

Line 461: FROM CZ_PB_CLIENT_APPS

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
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:

Line 468: EXECUTE IMMEDIATE 'Begin SELECT fnd_application_id bulk collect INTO rPublApps FROM CZ_PB_CLIENT_APPS' || linkName || ' WHERE publication_id = publicationId; End;';

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
471: FOR I IN lPublishedLanguages.FIRST..lPublishedLanguages.LAST
472: LOOP

Line 678: ' INSERT INTO CZ_PB_CLIENT_APPS( PUBLICATION_ID, FND_APPLICATION_ID, APPLICATION_SHORT_NAME, NOTES) VALUES ' ||

674: ' INSERT INTO CZ_PB_LANGUAGES( PUBLICATION_ID, LANGUAGE) VALUES (SELECT v_pub_tbl(i),language FROM CZ_PB_LANGUAGES'|| lLinkName || 'r ' ||
675: ' WHERE r.publication_id = lPublicationId';
676:
677: EXECUTE IMMEDIATE
678: ' INSERT INTO CZ_PB_CLIENT_APPS( PUBLICATION_ID, FND_APPLICATION_ID, APPLICATION_SHORT_NAME, NOTES) VALUES ' ||
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

Line 679: ' (SELECT v_pub_tbl(i),FND_APPLICATION_ID, APPLICATION_SHORT_NAME, NOTES FROM CZ_PB_CLIENT_APPS'|| lLinkName || 'r ' ||

675: ' WHERE r.publication_id = lPublicationId';
676:
677: EXECUTE IMMEDIATE
678: ' INSERT INTO CZ_PB_CLIENT_APPS( PUBLICATION_ID, FND_APPLICATION_ID, APPLICATION_SHORT_NAME, NOTES) VALUES ' ||
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) ' ||