APPS.CZ_PUBL_SYNC_CRASH dependencies on CZ_UI_NODES

Line 541: n_source_ui_def_id cz_ui_nodes.ui_def_id%type;

537: lLinkName CZ_SERVERS.fndnam_link_name%type;
538: x_server_f BOOLEAN := FALSE;
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;

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 599: 'cz_ui_nodes u ' ||

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 ' ||
603: 'and u.parent_id is null ' ||

Line 770: ' FROM cz_ui_nodes' || lLinkName || ' r, cz_item_masters l' ;

766: ' FROM cz_ps_nodes' || lLinkName || ' r, cz_item_masters l' ;
767:
768: EXECUTE IMMEDIATE
769: 'SELECT greatest (max(l.ui_node_id),max(r.ui_node_id)) INTO ' || ui_node_val ||
770: ' FROM cz_ui_nodes' || lLinkName || ' r, cz_item_masters l' ;
771:
772: /* drop sequences */
773: EXECUTE IMMEDIATE 'DROP SEQUENCE cz_ps_nodes_s';
774: EXECUTE IMMEDIATE 'DROP SEQUENCE cz_ui_nodes_s';

Line 774: EXECUTE IMMEDIATE 'DROP SEQUENCE cz_ui_nodes_s';

770: ' FROM cz_ui_nodes' || lLinkName || ' r, cz_item_masters l' ;
771:
772: /* drop sequences */
773: EXECUTE IMMEDIATE 'DROP SEQUENCE cz_ps_nodes_s';
774: EXECUTE IMMEDIATE 'DROP SEQUENCE cz_ui_nodes_s';
775: EXECUTE IMMEDIATE 'DROP SEQUENCE cz_item_masters_s';
776: EXECUTE IMMEDIATE 'DROP SEQUENCE cz_item_types_s';
777: EXECUTE IMMEDIATE 'DROP SEQUENCE cz_properties_s';
778:

Line 786: EXECUTE IMMEDIATE 'CREATE SEQUENCE cz_ui_nodes_s START WITH '|| ui_node_val+incr_val ||

782: EXECUTE IMMEDIATE 'CREATE SEQUENCE cz_item_types_s START WITH '|| item_type_val+incr_val ||
783: ' INCREMENT BY '|| incr_val || ' NOCACHE';
784: EXECUTE IMMEDIATE 'CREATE SEQUENCE cz_ps_nodes_s START WITH '|| ps_node_val+incr_val ||
785: ' INCREMENT BY '|| incr_val || ' NOCACHE';
786: EXECUTE IMMEDIATE 'CREATE SEQUENCE cz_ui_nodes_s START WITH '|| ui_node_val+incr_val ||
787: ' INCREMENT BY '|| incr_val || ' NOCACHE';
788: EXECUTE IMMEDIATE 'CREATE SEQUENCE cz_properties_s START WITH '|| property_val+incr_val ||
789: ' INCREMENT BY '|| incr_val || ' NOCACHE';
790: EXCEPTION