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_MODEL_PUBLICATIONS

Line 199: UPDATE cz_model_publications

195: -- xERROR BOOLEAN := FALSE;
196: --TYPE tPublicationIds IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
197: --lPublicationIds tPublicationIds;
198: BEGIN
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

Line 204: WHERE publication_id in (SELECT publication_id from 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
208: WHERE publication_id in (SELECT publication_id from cz_model_publications

Line 208: WHERE publication_id in (SELECT publication_id from cz_model_publications

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
212: WHERE publication_id in (SELECT publication_id from cz_model_publications

Line 212: WHERE publication_id in (SELECT publication_id from cz_model_publications

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
216: WHERE server_id = p_target_server_id;

Line 238: UPDATE cz_model_publications

234: --TYPE tPublicationIds IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
235: --lPublicationIds tPublicationIds;
236:
237: BEGIN
238: UPDATE cz_model_publications
239: SET deleted_flag = '1'
240: WHERE server_id = p_target_server_id
241: and model_last_updated > p_date;
242:

Line 244: WHERE publication_id in (SELECT publication_id from cz_model_publications

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:
248: DELETE FROM cz_publication_usages

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

Line 254: 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:
258: DELETE FROM cz_pb_model_exports

Line 286: 'UPDATE cz_model_publications' || p_link_name ||

282: END IF;
283: */
284:
285: EXECUTE IMMEDIATE
286: 'UPDATE cz_model_publications' || 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

Line 344: v_publication_id CZ_MODEL_PUBLICATIONS.publication_id%type;

340: v_deleted_pub_tbl t_publ_tbl;
341: v_deleted_remote_pub_tbl t_publ_tbl;
342: v_pub_tbl t_publ_tbl;
343: v_remote_pub_tbl t_publ_tbl;
344: v_publication_id CZ_MODEL_PUBLICATIONS.publication_id%type;
345:
346: BEGIN
347:
348: SELECT fndnam_link_name, server_local_id INTO lLinkName, lServerName FROM CZ_SERVERS

Line 358: ' from cz_model_publications' || lLinkName ||

354:
355: /*
356: EXECUTE IMMEDIATE
357: ' SELECT publication_id BULK COLLECT INTO ' || v_deleted_pub_tbl ||
358: ' from cz_model_publications' || lLinkName ||
359: ' where deleted_flag = ''1''';
360:
361: IF (v_deleted_pub_tbl.COUNT > 0) THEN
362: FOR i IN v_deleted_pub_tbl.FIRST..v_deleted_pub_tbl.LAST

Line 372: from cz_model_publications

368:
369: -- delete publications in source for which the target publication has been deleted
370: SELECT publication_id, remote_publication_id
371: BULK COLLECT INTO v_deleted_pub_tbl, v_deleted_remote_pub_tbl
372: from cz_model_publications
373: where deleted_flag = '1';
374:
375: IF (v_deleted_pub_tbl.COUNT > 0) THEN
376: FOR i IN v_deleted_pub_tbl.FIRST..v_deleted_pub_tbl.LAST

Line 385: from cz_model_publications

381:
382: -- delete publications in target for which the source publication has been deleted
383: SELECT publication_id
384: BULK COLLECT INTO v_pub_tbl
385: from cz_model_publications
386: where deleted_flag = '0';
387:
388: IF (v_pub_tbl.COUNT > 0) THEN
389: FOR i IN v_pub_tbl.FIRST..v_pub_tbl.LAST

Line 393: ' from cz_model_publications' || lLinkName ||

389: FOR i IN v_pub_tbl.FIRST..v_pub_tbl.LAST
390: LOOP
391: EXECUTE IMMEDIATE
392: ' SELECT publication_id INTO ' || v_publication_id ||
393: ' from cz_model_publications' || lLinkName ||
394: ' where remote_publication_id = :1 and deleted_flag = ''1'''
395: USING v_pub_tbl(i);
396:
397: IF (v_publication_id <> NULL) THEN

Line 543: lPublicationId cz_model_publications.publication_id%type;

539:
540: n_source_model_id cz_ps_nodes.ps_node_id%type;
541: n_source_ui_def_id cz_ui_nodes.ui_def_id%type;
542: lCount NUMBER;
543: lPublicationId cz_model_publications.publication_id%type;
544:
545: publications_cur REF_CURSOR;
546: TYPE t_publ_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
547: v_pub_tbl t_publ_tbl;

Line 560: 'SELECT count(*) from cz_model_publications' || lLinkName || ' where source_model_id is null'

556: END IF;
557:
558: -- insert into publication tables
559: EXECUTE IMMEDIATE
560: 'SELECT count(*) from cz_model_publications' || lLinkName || ' where source_model_id is null'
561: INTO lCount;
562: x_count := lCount;
563:
564: if (lCount > 0) then

Line 566: OPEN publications_cur FOR ' SELECT publication_id FROM cz_model_publications'||lLinkName ||

562: x_count := lCount;
563:
564: if (lCount > 0) then
565: begin
566: OPEN publications_cur FOR ' SELECT publication_id FROM cz_model_publications'||lLinkName ||
567: ' WHERE deleted_flag = ''0'' ';
568: LOOP
569: lPublicationId := NULL;
570: FETCH publications_cur INTO lPublicationId;

Line 581: ' from cz_model_publications' || lLinkName || ' pb, cz_ps_nodes' || lLinkName || ' ps, ' ||

577: END IF;
578:
579: -- resolve source_model_id
580: EXECUTE IMMEDIATE 'select pb.model_id into ' || n_source_model_id ||
581: ' from cz_model_publications' || lLinkName || ' pb, cz_ps_nodes' || lLinkName || ' ps, ' ||
582: 'cz_ps_nodes p ' ||
583: 'where pb.model_id = ps.ps_node_id ' ||
584: 'and pb.persistent_node_id = ps.persistent_node_id ' ||
585: 'and pb_source_model_id is null ' ||

Line 598: 'from cz_model_publications' || lLinkName || ' pb, cz_ui_nodes' || lLinkName || ' ui, ' ||

594: END;
595: -- resolve source_ui_def_id
596: BEGIN
597: EXECUTE IMMEDIATE 'select pb.ui_def_id into ' || n_source_ui_def_id || ' ' ||
598: 'from cz_model_publications' || lLinkName || ' pb, cz_ui_nodes' || lLinkName || ' ui, ' ||
599: 'cz_ui_nodes u ' ||
600: 'where pb.ui_def_id = ui.ui_def_id ' ||
601: 'and pb.source_ui_def_id is null ' ||
602: 'and ui.persistent_node_id = u.persistent_ui_node_id ' ||

Line 619: SELECT CZ_MODEL_PUBLICATIONS_S.NEXTVAL into lPublicationId from dual;

615: cz_utils.log_report(pkg_name, 'CREATE_PUBLICATION_DATA', null, ERRBUF, fnd_log.LEVEL_ERROR);
616: END;
617:
618: -- insert
619: SELECT CZ_MODEL_PUBLICATIONS_S.NEXTVAL into lPublicationId from dual;
620: EXECUTE IMMEDIATE
621: ' INSERT INTO cz_model_publications (PUBLICATION_ID ' ||
622: ' ,MODEL_ID ' ||
623: ' ,SERVER_ID ' ||

Line 621: ' INSERT INTO cz_model_publications (PUBLICATION_ID ' ||

617:
618: -- insert
619: SELECT CZ_MODEL_PUBLICATIONS_S.NEXTVAL into lPublicationId from dual;
620: EXECUTE IMMEDIATE
621: ' INSERT INTO cz_model_publications (PUBLICATION_ID ' ||
622: ' ,MODEL_ID ' ||
623: ' ,SERVER_ID ' ||
624: ' ,ORGANIZATION_ID ' ||
625: ' ,TOP_ITEM_ID ' ||

Line 668: ' FROM CZ_MODEL_PUBLICATIONS' || lLinkName || ' remote ' ||

664: ' ,CREATED_BY ' ||
665: ' ,LAST_UPDATED_BY ' ||
666: ' ,''S'' ' ||
667: ' ,PUBLICATION_ID ' ||
668: ' FROM CZ_MODEL_PUBLICATIONS' || lLinkName || ' remote ' ||
669: ' WHERE cz_model_publications.remote_publication_id = remote.publication_id ' ||
670: ' AND cz_model_publications.deleted_flag = ''1'' )';
671:
672: -- insert into other publication request tables

Line 669: ' WHERE cz_model_publications.remote_publication_id = remote.publication_id ' ||

665: ' ,LAST_UPDATED_BY ' ||
666: ' ,''S'' ' ||
667: ' ,PUBLICATION_ID ' ||
668: ' FROM CZ_MODEL_PUBLICATIONS' || lLinkName || ' remote ' ||
669: ' WHERE cz_model_publications.remote_publication_id = remote.publication_id ' ||
670: ' AND cz_model_publications.deleted_flag = ''1'' )';
671:
672: -- insert into other publication request tables
673: EXECUTE IMMEDIATE

Line 670: ' AND cz_model_publications.deleted_flag = ''1'' )';

666: ' ,''S'' ' ||
667: ' ,PUBLICATION_ID ' ||
668: ' FROM CZ_MODEL_PUBLICATIONS' || lLinkName || ' remote ' ||
669: ' WHERE cz_model_publications.remote_publication_id = remote.publication_id ' ||
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 ' ||

Line 694: ' update cz_model_publications'||lLinkName || ' t ' ||

690: END IF;
691:
692: -- Update remote_publication_id on target
693: EXECUTE IMMEDIATE
694: ' update cz_model_publications'||lLinkName || ' t ' ||
695: ' set remote_publication_id = (select publication_id from cz_model_publications' ||
696: ' where remote_publication_id = t.publication_id' ||
697: ' and deleted_flag = ''0'')' ||
698: ' and deleted_flag = ''0'' ';

Line 695: ' set remote_publication_id = (select publication_id from cz_model_publications' ||

691:
692: -- Update remote_publication_id on target
693: EXECUTE IMMEDIATE
694: ' update cz_model_publications'||lLinkName || ' t ' ||
695: ' set remote_publication_id = (select publication_id from cz_model_publications' ||
696: ' where remote_publication_id = t.publication_id' ||
697: ' and deleted_flag = ''0'')' ||
698: ' and deleted_flag = ''0'' ';
699:

Line 810: v_publication_id CZ_MODEL_PUBLICATIONS.publication_id%type;

806: IS
807: TYPE t_publ_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
808: v_pub_tbl t_publ_tbl;
809: v_remote_pub_tbl t_publ_tbl;
810: v_publication_id CZ_MODEL_PUBLICATIONS.publication_id%type;
811:
812: lLinkName CZ_SERVERS.fndnam_link_name%type;
813: x_run_id CZ_XFR_RUN_INFOS.run_id%type;
814: x_status CZ_MODEL_PUBLICATIONS.export_status%type;

Line 814: x_status CZ_MODEL_PUBLICATIONS.export_status%type;

810: v_publication_id CZ_MODEL_PUBLICATIONS.publication_id%type;
811:
812: lLinkName CZ_SERVERS.fndnam_link_name%type;
813: x_run_id CZ_XFR_RUN_INFOS.run_id%type;
814: x_status CZ_MODEL_PUBLICATIONS.export_status%type;
815:
816: ok_count NUMBER := 0;
817: err_count NUMBER := 0;
818: lStartDate DATE := sysdate;

Line 831: from cz_model_publications

827: END IF;
828:
829: SELECT publication_id, remote_publication_id
830: BULK COLLECT INTO v_pub_tbl, v_remote_pub_tbl
831: from cz_model_publications
832: where deleted_flag = '0';
833:
834: IF (v_pub_tbl.COUNT > 0) THEN
835: FOR i IN v_pub_tbl.FIRST..v_pub_tbl.LAST

Line 837: UPDATE CZ_MODEL_PUBLICATIONS SET export_status = PUBLICATION_PENDING

833:
834: IF (v_pub_tbl.COUNT > 0) THEN
835: FOR i IN v_pub_tbl.FIRST..v_pub_tbl.LAST
836: LOOP
837: UPDATE CZ_MODEL_PUBLICATIONS SET export_status = PUBLICATION_PENDING
838: WHERE export_status = PUBLICATION_OK
839: AND deleted_flag = '0';
840:
841: x_status := NULL;