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_PB_SYNC dependencies on CZ_MODEL_PUBLICATIONS

Line 13: OBJECT_TYPE_PROJECT CONSTANT cz_model_publications.object_type%TYPE := 'PRJ';

9: m_err_message VARCHAR2(2000);
10:
11: SRC_SERVER_FLAG cz_servers.source_server_flag%TYPE := '1';
12:
13: OBJECT_TYPE_PROJECT CONSTANT cz_model_publications.object_type%TYPE := 'PRJ';
14: OBJECT_TYPE_UITEMPL CONSTANT cz_model_publications.object_type%TYPE := 'UIT';
15: GLOBAL_UI_DEF_PUB CONSTANT NUMBER := 1;
16: GLOBAL_UI_DEF_SRC CONSTANT NUMBER := 0;
17:

Line 14: OBJECT_TYPE_UITEMPL CONSTANT cz_model_publications.object_type%TYPE := 'UIT';

10:
11: SRC_SERVER_FLAG cz_servers.source_server_flag%TYPE := '1';
12:
13: OBJECT_TYPE_PROJECT CONSTANT cz_model_publications.object_type%TYPE := 'PRJ';
14: OBJECT_TYPE_UITEMPL CONSTANT cz_model_publications.object_type%TYPE := 'UIT';
15: GLOBAL_UI_DEF_PUB CONSTANT NUMBER := 1;
16: GLOBAL_UI_DEF_SRC CONSTANT NUMBER := 0;
17:
18: ---------------------------------------

Line 203: FROM cz_model_publications'||p_link_name||' t

199: v_tgt_server_id cz_servers.server_local_id%TYPE := 0;
200:
201: BEGIN
202: OPEN gl_ref_cursor FOR 'SELECT distinct server_id
203: FROM cz_model_publications'||p_link_name||' t
204: WHERE t.source_target_flag = ''T''
205: AND t.deleted_flag = ''0'' ';
206: LOOP
207: FETCH gl_ref_cursor INTO v_tgt_server_id;

Line 242: FROM cz_model_publications

238: ----check not required
239: IF (v_tgt_pb_server_id <> 0) THEN
240: SELECT 1
241: INTO v_src_server_count
242: FROM cz_model_publications
243: WHERE cz_model_publications.server_id = v_tgt_pb_server_id
244: AND cz_model_publications.deleted_flag = '0'
245: AND ROWNUM < 2;
246: END IF;

Line 243: WHERE cz_model_publications.server_id = v_tgt_pb_server_id

239: IF (v_tgt_pb_server_id <> 0) THEN
240: SELECT 1
241: INTO v_src_server_count
242: FROM cz_model_publications
243: WHERE cz_model_publications.server_id = v_tgt_pb_server_id
244: AND cz_model_publications.deleted_flag = '0'
245: AND ROWNUM < 2;
246: END IF;
247:

Line 244: AND cz_model_publications.deleted_flag = '0'

240: SELECT 1
241: INTO v_src_server_count
242: FROM cz_model_publications
243: WHERE cz_model_publications.server_id = v_tgt_pb_server_id
244: AND cz_model_publications.deleted_flag = '0'
245: AND ROWNUM < 2;
246: END IF;
247:
248: IF (v_src_server_count <> 1) THEN

Line 274: OPEN gl_ref_cursor FOR 'SELECT COUNT(*) FROM cz_model_publications'||p_link_name||' t

270: v_validate_flag BOOLEAN := TRUE;
271:
272: BEGIN
273: ----compare model persistent ids on of source and target models
274: OPEN gl_ref_cursor FOR 'SELECT COUNT(*) FROM cz_model_publications'||p_link_name||' t
275: WHERE t.deleted_flag = ''0''
276: AND t.model_persistent_id IN (SELECT model_persistent_id
277: FROM cz_model_publications x
278: WHERE x.deleted_flag = ''0''

Line 277: FROM cz_model_publications x

273: ----compare model persistent ids on of source and target models
274: OPEN gl_ref_cursor FOR 'SELECT COUNT(*) FROM cz_model_publications'||p_link_name||' t
275: WHERE t.deleted_flag = ''0''
276: AND t.model_persistent_id IN (SELECT model_persistent_id
277: FROM cz_model_publications x
278: WHERE x.deleted_flag = ''0''
279: AND x.source_target_flag = ''S'')';
280: LOOP
281: FETCH gl_ref_cursor INTO v_validate_model_count;

Line 310: OPEN gl_ref_cursor FOR 'SELECT COUNT(*) FROM cz_model_publications'||p_link_name||' t

306:
307: BEGIN
308:
309: ----verify that the remote publication ids on the source exist on the target
310: OPEN gl_ref_cursor FOR 'SELECT COUNT(*) FROM cz_model_publications'||p_link_name||' t
311: WHERE t.deleted_flag = ''0''
312: AND t.export_status = ''OK''
313: AND t.source_target_flag = ''T''
314: AND t.publication_id IN (SELECT remote_publication_id

Line 315: FROM cz_model_publications x

311: WHERE t.deleted_flag = ''0''
312: AND t.export_status = ''OK''
313: AND t.source_target_flag = ''T''
314: AND t.publication_id IN (SELECT remote_publication_id
315: FROM cz_model_publications x
316: WHERE x.export_status = ''OK''
317: AND x.deleted_flag = ''0'')';
318: LOOP
319: FETCH gl_ref_cursor INTO v_rem_pb_count;

Line 390: PROCEDURE clear_source_pb_record(p_publication_id IN cz_model_publications.publication_id%TYPE)

386: END has_to_be_synced;
387:
388: ----------------------------------------------------
389: ---procedure that deletes the publication (on the source instance) record pointing to the cloned database
390: PROCEDURE clear_source_pb_record(p_publication_id IN cz_model_publications.publication_id%TYPE)
391: IS
392:
393: BEGIN
394: UPDATE cz_model_publications

Line 394: UPDATE cz_model_publications

390: PROCEDURE clear_source_pb_record(p_publication_id IN cz_model_publications.publication_id%TYPE)
391: IS
392:
393: BEGIN
394: UPDATE cz_model_publications
395: SET deleted_flag = '1'
396: WHERE publication_id = p_publication_id;
397:
398: /* DELETE FROM cz_model_publications

Line 398: /* DELETE FROM cz_model_publications

394: UPDATE cz_model_publications
395: SET deleted_flag = '1'
396: WHERE publication_id = p_publication_id;
397:
398: /* DELETE FROM cz_model_publications
399: WHERE publication_id = p_publication_id; */
400: EXCEPTION
401: WHEN OTHERS THEN
402: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_DEL_PB_REC_ERR', 'PUBID', p_publication_id, 'SQLERRM', SQLERRM);

Line 409: PROCEDURE clear_pb_clients(p_publication_id IN cz_model_publications.publication_id%TYPE)

405: END clear_source_pb_record;
406:
407: ----------------------------------------------------
408: ---procedure that deletes data from cz_pb_client_apps for a given publication
409: PROCEDURE clear_pb_clients(p_publication_id IN cz_model_publications.publication_id%TYPE)
410: IS
411:
412: BEGIN
413: DELETE FROM cz_pb_client_apps

Line 424: PROCEDURE clear_pb_lang(p_publication_id IN cz_model_publications.publication_id%TYPE)

420: END clear_pb_clients;
421:
422: -----------------------------------------------------
423: ---procedure that deletes data from cz_pb_languages for a given publication
424: PROCEDURE clear_pb_lang(p_publication_id IN cz_model_publications.publication_id%TYPE)
425: IS
426:
427: BEGIN
428: DELETE FROM cz_pb_languages

Line 439: PROCEDURE clear_pb_usages(p_publication_id IN cz_model_publications.publication_id%TYPE)

435: END clear_pb_lang;
436:
437: -----------------------------------------------------
438: ---procedure that deletes data from cz_pb_client_apps for a given publication
439: PROCEDURE clear_pb_usages(p_publication_id IN cz_model_publications.publication_id%TYPE)
440: IS
441:
442: BEGIN
443: DELETE FROM cz_publication_usages

Line 474: 'UPDATE cz_model_publications'||p_link_name||' t SET t.server_id = '||p_target_server_id||' WHERE t.deleted_flag = ''0'' ';

470: IS
471:
472: BEGIN
473: EXECUTE IMMEDIATE
474: 'UPDATE cz_model_publications'||p_link_name||' t SET t.server_id = '||p_target_server_id||' WHERE t.deleted_flag = ''0'' ';
475: EXCEPTION
476: WHEN OTHERS THEN
477: RAISE;
478: END update_tgt_server_id;

Line 484: PROCEDURE get_local_ids(p_publication_id IN cz_model_publications.publication_id%TYPE,

480: ------------------------------------------------------
481: --jhanda
482: -- procedure that returns the product_id and organisation_id in the target corresponding
483: -- to the product_id and organisation_id in the source for a given source publication
484: PROCEDURE get_local_ids(p_publication_id IN cz_model_publications.publication_id%TYPE,
485: p_sync_tgt_link_name IN cz_servers.fndnam_link_name%TYPE,
486: p_import_link_name IN cz_servers.fndnam_link_name%TYPE,
487: p_item_id IN OUT NOCOPY cz_item_masters.item_id%TYPE,
488: p_org_id IN OUT NOCOPY cz_model_publications.organization_id%TYPE,

Line 488: p_org_id IN OUT NOCOPY cz_model_publications.organization_id%TYPE,

484: PROCEDURE get_local_ids(p_publication_id IN cz_model_publications.publication_id%TYPE,
485: p_sync_tgt_link_name IN cz_servers.fndnam_link_name%TYPE,
486: p_import_link_name IN cz_servers.fndnam_link_name%TYPE,
487: p_item_id IN OUT NOCOPY cz_item_masters.item_id%TYPE,
488: p_org_id IN OUT NOCOPY cz_model_publications.organization_id%TYPE,
489: p_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
490: )
491: IS
492: l_concatenated_segments MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;

Line 489: p_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE

485: p_sync_tgt_link_name IN cz_servers.fndnam_link_name%TYPE,
486: p_import_link_name IN cz_servers.fndnam_link_name%TYPE,
487: p_item_id IN OUT NOCOPY cz_item_masters.item_id%TYPE,
488: p_org_id IN OUT NOCOPY cz_model_publications.organization_id%TYPE,
489: p_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
490: )
491: IS
492: l_concatenated_segments MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;
493: l_remote_item_cursor ref_cursor;

Line 495: l_org_id cz_model_publications.organization_id%TYPE;

491: IS
492: l_concatenated_segments MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;
493: l_remote_item_cursor ref_cursor;
494: c_local_item_id ref_cursor;
495: l_org_id cz_model_publications.organization_id%TYPE;
496:
497: BEGIN
498:
499:

Line 604: PROCEDURE create_src_publication(p_publication_id IN cz_model_publications.publication_id%TYPE,

600:
601: ------------------------------------------------------
602: ------procedure that creates a single publication record on the source for a
603: ------target publication. This proc is called from create_src_pb_records.
604: PROCEDURE create_src_publication(p_publication_id IN cz_model_publications.publication_id%TYPE,
605: p_link_name IN cz_servers.fndnam_link_name%TYPE,
606: p_tgt_server_id IN cz_servers.server_local_id%TYPE,
607: p_src_object_id IN cz_model_publications.object_id%TYPE,
608: -- p_src_object_type IN cz_model_publications.object_type%TYPE,

Line 607: p_src_object_id IN cz_model_publications.object_id%TYPE,

603: ------target publication. This proc is called from create_src_pb_records.
604: PROCEDURE create_src_publication(p_publication_id IN cz_model_publications.publication_id%TYPE,
605: p_link_name IN cz_servers.fndnam_link_name%TYPE,
606: p_tgt_server_id IN cz_servers.server_local_id%TYPE,
607: p_src_object_id IN cz_model_publications.object_id%TYPE,
608: -- p_src_object_type IN cz_model_publications.object_type%TYPE,
609: p_src_ui_def_id IN cz_model_publications.ui_def_id%TYPE)
610: IS
611: l_new_pb_id cz_model_publications.publication_id%TYPE;

Line 608: -- p_src_object_type IN cz_model_publications.object_type%TYPE,

604: PROCEDURE create_src_publication(p_publication_id IN cz_model_publications.publication_id%TYPE,
605: p_link_name IN cz_servers.fndnam_link_name%TYPE,
606: p_tgt_server_id IN cz_servers.server_local_id%TYPE,
607: p_src_object_id IN cz_model_publications.object_id%TYPE,
608: -- p_src_object_type IN cz_model_publications.object_type%TYPE,
609: p_src_ui_def_id IN cz_model_publications.ui_def_id%TYPE)
610: IS
611: l_new_pb_id cz_model_publications.publication_id%TYPE;
612: l_ui_def_id VARCHAR2(100);

Line 609: p_src_ui_def_id IN cz_model_publications.ui_def_id%TYPE)

605: p_link_name IN cz_servers.fndnam_link_name%TYPE,
606: p_tgt_server_id IN cz_servers.server_local_id%TYPE,
607: p_src_object_id IN cz_model_publications.object_id%TYPE,
608: -- p_src_object_type IN cz_model_publications.object_type%TYPE,
609: p_src_ui_def_id IN cz_model_publications.ui_def_id%TYPE)
610: IS
611: l_new_pb_id cz_model_publications.publication_id%TYPE;
612: l_ui_def_id VARCHAR2(100);
613: pub_cursor ref_cursor;

Line 611: l_new_pb_id cz_model_publications.publication_id%TYPE;

607: p_src_object_id IN cz_model_publications.object_id%TYPE,
608: -- p_src_object_type IN cz_model_publications.object_type%TYPE,
609: p_src_ui_def_id IN cz_model_publications.ui_def_id%TYPE)
610: IS
611: l_new_pb_id cz_model_publications.publication_id%TYPE;
612: l_ui_def_id VARCHAR2(100);
613: pub_cursor ref_cursor;
614: l_pub_cursor cz_model_publications%rowtype;
615: v_item_id cz_item_masters.item_id%TYPE;

Line 614: l_pub_cursor cz_model_publications%rowtype;

610: IS
611: l_new_pb_id cz_model_publications.publication_id%TYPE;
612: l_ui_def_id VARCHAR2(100);
613: pub_cursor ref_cursor;
614: l_pub_cursor cz_model_publications%rowtype;
615: v_item_id cz_item_masters.item_id%TYPE;
616: v_org_id cz_model_publications.organization_id%TYPE;
617: v_product_key cz_model_publications.product_key%TYPE;
618:

Line 616: v_org_id cz_model_publications.organization_id%TYPE;

612: l_ui_def_id VARCHAR2(100);
613: pub_cursor ref_cursor;
614: l_pub_cursor cz_model_publications%rowtype;
615: v_item_id cz_item_masters.item_id%TYPE;
616: v_org_id cz_model_publications.organization_id%TYPE;
617: v_product_key cz_model_publications.product_key%TYPE;
618:
619: linkName cz_servers.fndnam_link_name%TYPE;
620:

Line 617: v_product_key cz_model_publications.product_key%TYPE;

613: pub_cursor ref_cursor;
614: l_pub_cursor cz_model_publications%rowtype;
615: v_item_id cz_item_masters.item_id%TYPE;
616: v_org_id cz_model_publications.organization_id%TYPE;
617: v_product_key cz_model_publications.product_key%TYPE;
618:
619: linkName cz_servers.fndnam_link_name%TYPE;
620:
621: BEGIN

Line 623: SELECT cz_model_publications_s.nextval

619: linkName cz_servers.fndnam_link_name%TYPE;
620:
621: BEGIN
622: ----get new publication id
623: SELECT cz_model_publications_s.nextval
624: INTO l_new_pb_id
625: FROM dual;
626:
627: IF (p_src_ui_def_id IS NULL) THEN

Line 646: ' FROM cz_model_publications'||p_link_name||' t ' ||

642:
643: -- model_id, source_model_id, source_ui_def_id are null
644: OPEN pub_cursor for
645: ' SELECT *'||
646: ' FROM cz_model_publications'||p_link_name||' t ' ||
647: ' WHERE t.publication_id = '||p_publication_id ;
648:
649: LOOP
650: FETCH pub_cursor

Line 660: INSERT INTO cz_model_publications(

656: IF p_link_name <> NVL (linkName, 'NULL') THEN -- Bug9679808
657: get_local_ids(l_pub_cursor.PUBLICATION_ID,p_link_name,linkName ,v_item_id,v_org_id,v_product_key);
658: END IF;
659:
660: INSERT INTO cz_model_publications(
661: PUBLICATION_ID
662: ,OBJECT_ID
663: ,OBJECT_TYPE
664: ,SERVER_ID

Line 741: 'UPDATE cz_model_publications'||p_link_name||' t ' ||

737: CLOSE pub_cursor;
738:
739: ----update remote publication id on the clone instance
740: EXECUTE IMMEDIATE
741: 'UPDATE cz_model_publications'||p_link_name||' t ' ||
742: ' SET t.remote_publication_id = '||l_new_pb_id||
743: ' WHERE t.publication_id = '||p_publication_id ;
744:
745: ----insert into cz_pb_client_apps

Line 784: PROCEDURE delete_tgt_publication(p_publication_id IN cz_model_publications.publication_id%TYPE,

780:
781: --------------------------------------------------------
782: ----procedure that deletes a publication record on the target
783: ----instance
784: PROCEDURE delete_tgt_publication(p_publication_id IN cz_model_publications.publication_id%TYPE,
785: p_link_name IN cz_servers.fndnam_link_name%TYPE)
786: IS
787:
788: BEGIN

Line 790: 'delete from cz_model_publications'||p_link_name||' t' ||

786: IS
787:
788: BEGIN
789: EXECUTE IMMEDIATE
790: 'delete from cz_model_publications'||p_link_name||' t' ||
791: ' where t.publication_id = '||p_publication_id ;
792: EXCEPTION
793: WHEN OTHERS THEN
794: RAISE;

Line 819: PROCEDURE clear_publication_data(p_target_server_id IN cz_model_publications.server_id%TYPE)

815: WHEN OTHERS THEN
816: RAISE;
817: END;
818: -------------------------------------------------------
819: PROCEDURE clear_publication_data(p_target_server_id IN cz_model_publications.server_id%TYPE)
820: IS
821:
822: l_src_pub_tbl t_ref;
823:

Line 829: FROM cz_model_publications

825: SELECT publication_id
826: BULK
827: COLLECT
828: INTO l_src_pub_tbl
829: FROM cz_model_publications
830: WHERE server_id = p_target_server_id ;
831:
832: IF (l_src_pub_tbl.COUNT > 0) THEN
833: FOR I IN l_src_pub_tbl.FIRST..l_src_pub_tbl.LAST

Line 862: TYPE object_type_tbl_type IS TABLE OF cz_model_publications.object_type%TYPE

858: ----on the clone
859: PROCEDURE create_src_pb_records(p_tgt_server_id IN cz_servers.server_local_id%TYPE)
860: IS
861:
862: TYPE object_type_tbl_type IS TABLE OF cz_model_publications.object_type%TYPE
863: INDEX BY BINARY_INTEGER;
864:
865: l_ref_cursor REF_CURSOR;
866: l_model_cursor REF_CURSOR;

Line 870: l_publication_id cz_model_publications.publication_id%TYPE;

866: l_model_cursor REF_CURSOR;
867: l_templ_cursor REF_CURSOR;
868: l_ui_cursor REF_CURSOR;
869:
870: l_publication_id cz_model_publications.publication_id%TYPE;
871: l_src_pb_id cz_model_publications.publication_id%TYPE;
872: l_rem_pb_id cz_model_publications.publication_id%TYPE;
873: l_src_object_id cz_model_publications.object_id%TYPE;
874: l_tgt_object_id cz_model_publications.object_id%TYPE;

Line 871: l_src_pb_id cz_model_publications.publication_id%TYPE;

867: l_templ_cursor REF_CURSOR;
868: l_ui_cursor REF_CURSOR;
869:
870: l_publication_id cz_model_publications.publication_id%TYPE;
871: l_src_pb_id cz_model_publications.publication_id%TYPE;
872: l_rem_pb_id cz_model_publications.publication_id%TYPE;
873: l_src_object_id cz_model_publications.object_id%TYPE;
874: l_tgt_object_id cz_model_publications.object_id%TYPE;
875: l_src_object_type cz_model_publications.object_type%TYPE;

Line 872: l_rem_pb_id cz_model_publications.publication_id%TYPE;

868: l_ui_cursor REF_CURSOR;
869:
870: l_publication_id cz_model_publications.publication_id%TYPE;
871: l_src_pb_id cz_model_publications.publication_id%TYPE;
872: l_rem_pb_id cz_model_publications.publication_id%TYPE;
873: l_src_object_id cz_model_publications.object_id%TYPE;
874: l_tgt_object_id cz_model_publications.object_id%TYPE;
875: l_src_object_type cz_model_publications.object_type%TYPE;
876: l_tgt_object_type cz_model_publications.object_type%TYPE;

Line 873: l_src_object_id cz_model_publications.object_id%TYPE;

869:
870: l_publication_id cz_model_publications.publication_id%TYPE;
871: l_src_pb_id cz_model_publications.publication_id%TYPE;
872: l_rem_pb_id cz_model_publications.publication_id%TYPE;
873: l_src_object_id cz_model_publications.object_id%TYPE;
874: l_tgt_object_id cz_model_publications.object_id%TYPE;
875: l_src_object_type cz_model_publications.object_type%TYPE;
876: l_tgt_object_type cz_model_publications.object_type%TYPE;
877: l_src_model_id cz_model_publications.model_id%TYPE;

Line 874: l_tgt_object_id cz_model_publications.object_id%TYPE;

870: l_publication_id cz_model_publications.publication_id%TYPE;
871: l_src_pb_id cz_model_publications.publication_id%TYPE;
872: l_rem_pb_id cz_model_publications.publication_id%TYPE;
873: l_src_object_id cz_model_publications.object_id%TYPE;
874: l_tgt_object_id cz_model_publications.object_id%TYPE;
875: l_src_object_type cz_model_publications.object_type%TYPE;
876: l_tgt_object_type cz_model_publications.object_type%TYPE;
877: l_src_model_id cz_model_publications.model_id%TYPE;
878: l_src_ui_def_id cz_model_publications.ui_def_id%TYPE;

Line 875: l_src_object_type cz_model_publications.object_type%TYPE;

871: l_src_pb_id cz_model_publications.publication_id%TYPE;
872: l_rem_pb_id cz_model_publications.publication_id%TYPE;
873: l_src_object_id cz_model_publications.object_id%TYPE;
874: l_tgt_object_id cz_model_publications.object_id%TYPE;
875: l_src_object_type cz_model_publications.object_type%TYPE;
876: l_tgt_object_type cz_model_publications.object_type%TYPE;
877: l_src_model_id cz_model_publications.model_id%TYPE;
878: l_src_ui_def_id cz_model_publications.ui_def_id%TYPE;
879: l_src_object_name cz_devl_projects.name%TYPE;

Line 876: l_tgt_object_type cz_model_publications.object_type%TYPE;

872: l_rem_pb_id cz_model_publications.publication_id%TYPE;
873: l_src_object_id cz_model_publications.object_id%TYPE;
874: l_tgt_object_id cz_model_publications.object_id%TYPE;
875: l_src_object_type cz_model_publications.object_type%TYPE;
876: l_tgt_object_type cz_model_publications.object_type%TYPE;
877: l_src_model_id cz_model_publications.model_id%TYPE;
878: l_src_ui_def_id cz_model_publications.ui_def_id%TYPE;
879: l_src_object_name cz_devl_projects.name%TYPE;
880: l_tgt_object_name cz_devl_projects.name%TYPE;

Line 877: l_src_model_id cz_model_publications.model_id%TYPE;

873: l_src_object_id cz_model_publications.object_id%TYPE;
874: l_tgt_object_id cz_model_publications.object_id%TYPE;
875: l_src_object_type cz_model_publications.object_type%TYPE;
876: l_tgt_object_type cz_model_publications.object_type%TYPE;
877: l_src_model_id cz_model_publications.model_id%TYPE;
878: l_src_ui_def_id cz_model_publications.ui_def_id%TYPE;
879: l_src_object_name cz_devl_projects.name%TYPE;
880: l_tgt_object_name cz_devl_projects.name%TYPE;
881:

Line 878: l_src_ui_def_id cz_model_publications.ui_def_id%TYPE;

874: l_tgt_object_id cz_model_publications.object_id%TYPE;
875: l_src_object_type cz_model_publications.object_type%TYPE;
876: l_tgt_object_type cz_model_publications.object_type%TYPE;
877: l_src_model_id cz_model_publications.model_id%TYPE;
878: l_src_ui_def_id cz_model_publications.ui_def_id%TYPE;
879: l_src_object_name cz_devl_projects.name%TYPE;
880: l_tgt_object_name cz_devl_projects.name%TYPE;
881:
882: l_link_name cz_servers.fndnam_link_name%TYPE;

Line 924: FROM cz_model_publications'||l_link_name||' t

920: object_id,
921: object_type,
922: source_model_id,
923: source_ui_def_id
924: FROM cz_model_publications'||l_link_name||' t
925: WHERE t.deleted_flag = ''0''
926: AND t.source_target_flag = ''T''
927: AND t.export_status = ''OK'' ';
928: LOOP

Line 988: FROM cz_model_publications

984: l_src_ui_def_id := 0;
985: BEGIN
986: SELECT publication_id,object_id,object_type,ui_def_id
987: INTO l_src_pb_id,l_src_object_id,l_src_object_type,l_src_ui_def_id
988: FROM cz_model_publications
989: WHERE cz_model_publications.publication_id = l_tgt_rem_pub_tbl(i);
990: EXCEPTION
991: WHEN NO_DATA_FOUND THEN
992: ----delete tgt_publication

Line 989: WHERE cz_model_publications.publication_id = l_tgt_rem_pub_tbl(i);

985: BEGIN
986: SELECT publication_id,object_id,object_type,ui_def_id
987: INTO l_src_pb_id,l_src_object_id,l_src_object_type,l_src_ui_def_id
988: FROM cz_model_publications
989: WHERE cz_model_publications.publication_id = l_tgt_rem_pub_tbl(i);
990: EXCEPTION
991: WHEN NO_DATA_FOUND THEN
992: ----delete tgt_publication
993: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_DEL_TGT_PB',

Line 1632: UPDATE cz_model_publications set deleted_flag = '1';

1628:
1629: IF (UPPER(p_decomm_flag) = 'YES') THEN
1630: modify_target_server(v_link_name,l_hostname,l_instance_name,l_instance_name);
1631: ELSE
1632: UPDATE cz_model_publications set deleted_flag = '1';
1633: COMMIT;
1634: END IF;
1635: END LOOP;
1636: END IF;