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_LANGUAGES

Line 211: DELETE FROM cz_pb_languages

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

Line 253: DELETE FROM cz_pb_languages

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:
253: DELETE FROM cz_pb_languages
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:

Line 301: ' DELETE FROM cz_pb_languages' || p_link_name ||

297: ' WHERE publication_id = :1'
298: USING p_publication_id;
299:
300: EXECUTE IMMEDIATE
301: ' DELETE FROM cz_pb_languages' || p_link_name ||
302: ' WHERE publication_id publication_id = :1'
303: USING p_publication_id;
304:
305: EXECUTE IMMEDIATE

Line 438: TYPE tPublLangs IS TABLE OF cz_pb_languages.language%type INDEX BY BINARY_INTEGER;

434: FUNCTION checkApplicabilityParameters(publicationId IN NUMBER,
435: linkName IN VARCHAR2)
436: RETURN boolean
437: IS
438: TYPE tPublLangs IS TABLE OF cz_pb_languages.language%type INDEX BY BINARY_INTEGER;
439: lPublishedLanguages tPublLangs ;
440: rPublishedLanguages tPublLangs ;
441: TYPE tPublIds IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
442: lPublUsages tPublIds;

Line 453: FROM CZ_PB_LANGUAGES

449:
450: BEGIN
451:
452: SELECT language BULK COLLECT INTO lPublishedLanguages
453: FROM CZ_PB_LANGUAGES
454: WHERE publication_id = publicationId;
455:
456: SELECT usage_id BULK COLLECT INTO lPublUsages
457: FROM CZ_PUBLICATION_USAGES

Line 464: EXECUTE IMMEDIATE 'Begin SELECT language bulk collect INTO rPublishedLanguages FROM CZ_PB_LANGUAGES' || linkName || ' WHERE publication_id = publicationId; End;';

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

Line 674: ' INSERT INTO CZ_PB_LANGUAGES( PUBLICATION_ID, LANGUAGE) VALUES (SELECT v_pub_tbl(i),language FROM CZ_PB_LANGUAGES'|| lLinkName || 'r ' ||

670: ' AND cz_model_publications.deleted_flag = ''1'' )';
671:
672: -- insert into other publication request tables
673: EXECUTE IMMEDIATE
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 ' ||