APPS.CZ_PUBL_SYNC_CRASH dependencies on CZ_PS_NODES

Line 540: n_source_model_id cz_ps_nodes.ps_node_id%type;

536: lServerName CZ_SERVERS.local_name%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:

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 582: 'cz_ps_nodes p ' ||

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 ' ||
586: 'and pb.persistent_node_id = p.persistent_node_id ' ||

Line 766: ' FROM cz_ps_nodes' || lLinkName || ' r, cz_item_masters l' ;

762: ' FROM cz_properties' || lLinkName || ' r, cz_item_masters l' ;
763:
764: EXECUTE IMMEDIATE
765: 'SELECT greatest (max(l.ps_node_id),max(r.ps_node_id)) INTO ' || ps_node_val ||
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' ;

Line 773: EXECUTE IMMEDIATE 'DROP SEQUENCE cz_ps_nodes_s';

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

Line 784: EXECUTE IMMEDIATE 'CREATE SEQUENCE cz_ps_nodes_s START WITH '|| ps_node_val+incr_val ||

780: EXECUTE IMMEDIATE 'CREATE SEQUENCE cz_item_masters_s START WITH '|| item_val+incr_val ||
781: ' INCREMENT BY '|| incr_val || ' NOCACHE';
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 ||