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_UIOA_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16


  G_DEFAULT_PRICE_UPDATE        CONSTANT INTEGER   := 1;

Line: 90


  G_CX_MUST_BE_DELETED          CONSTANT VARCHAR2(1) :='D';

Line: 98


  G_MARK_TO_DELETE              CONSTANT VARCHAR2(1)   := '3';

Line: 119


  G_DELETE_PAGE                   CONSTANT INTEGER     := 1;

Line: 120


  G_DELETE_ELEMENTS               CONSTANT INTEGER     := 2;

Line: 129


  G_DELETE_MODE                   CONSTANT VARCHAR2(1) := '0';

Line: 190


  G_ITEM_SELECTION_TABLE          CONSTANT NUMBER := 6013;

Line: 203


  G_SELECTION_STATUS_INDICATOR    CONSTANT NUMBER := 6026;

Line: 589


      SELECT seeded_flag INTO l_seeded_flag FROM CZ_UI_TEMPLATES
       WHERE template_id=p_template_id AND ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;

Line: 652


    FOR i IN(SELECT DISTINCT template_id, detailed_type_id
               FROM CZ_UITEMPLS_FOR_PSNODES_V
              WHERE devl_project_id=p_model_id AND
                    ui_def_id=p_ui_def_id AND
                    template_ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID AND
                    deleted_flag = G_NO_FLAG)
    LOOP
      IF is_Used_By_Reference(i.detailed_type_id, i.template_id)=FALSE AND
         NOT(g_locked_templates_id_tbl.EXISTS(i.template_id)) THEN

        BEGIN
          --
          -- lock current UI Template
          --
          lock_UI_Template( i.template_id, G_GLOBAL_TEMPLATES_UI_DEF_ID, l_needs_to_be_unlocked);

Line: 720


    SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currentUINode FROM dual;

Line: 723


    SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;

Line: 726


    SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;

Line: 729


    SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;

Line: 732


    SELECT CZ_UI_ACTIONS_S.nextval INTO g_currentUIAction FROM dual;

Line: 750


    g_ui_def_nodes_tbl.DELETE;

Line: 751


    g_ui_pages_counter_tbl.DELETE;

Line: 752


    g_root_persist_id_tbl.DELETE;

Line: 753


    g_local_ui_context.DELETE;

Line: 754


    g_check_boundaries_tbl.DELETE;

Line: 755


    g_locked_templates_id_tbl.DELETE;

Line: 756


    g_elements_to_move.DELETE;

Line: 757


    g_dom_elements_to_move.DELETE;

Line: 758


    g_tgt_pg_to_src_pg_map.DELETE;

Line: 936


    SELECT increment_by INTO l_seq_increment
    FROM all_sequences
    WHERE sequence_owner=p_sequence_owner AND
          sequence_name=p_sequence_name;

Line: 1016


        SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currUISeqVal FROM dual;

Line: 1024


        SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currPageRefSeqVal FROM dual;

Line: 1032


        SELECT CZ_UI_PAGES_S.nextval INTO g_currPageSeqVal FROM dual;

Line: 1040


        SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currPageSetSeqVal FROM dual;

Line: 1048


        SELECT CZ_UI_ACTIONS_S.nextval INTO g_currUIActionSeqVal FROM dual;

Line: 1056


        SELECT CZ_INTL_TEXTS_S.nextval INTO g_currIntlTextSeqVal FROM dual;

Line: 1061


      EXECUTE IMMEDIATE 'SELECT ' || p_sequence_name || '.NEXTVAL FROM dual' INTO l_id;

Line: 1078


      SELECT * INTO g_local_ui_context(p_ui_def_id) FROM CZ_UI_DEFS
      WHERE ui_def_id=p_ui_def_id;

Line: 1086


      SELECT * INTO g_local_ui_context(p_ui_def_id)
        FROM CZ_UI_DEFS
       WHERE ui_def_id=p_ui_def_id;

Line: 1107


    UPDATE CZ_UI_PAGES
       SET deleted_flag = DECODE(deleted_flag,G_MARK_TO_ADD,
           G_MARK_TO_ADD,G_MARK_TO_REFRESH),
           page_rev_nbr=page_rev_nbr+1
     WHERE page_id=p_page_id AND
           ui_def_id=p_ui_def_id AND
           deleted_flag IN(G_NO_FLAG, G_MARK_TO_ADD,G_MARK_TO_REFRESH);

Line: 1119


  PROCEDURE mark_UI_Page_As_Deleted(p_page_id   IN NUMBER,
                                    p_ui_def_id IN NUMBER) IS
  BEGIN
    UPDATE CZ_UI_PAGES
       SET deleted_flag = G_MARK_TO_DELETE
     WHERE page_id=p_page_id AND
           ui_def_id=p_ui_def_id;

Line: 1126


  END mark_UI_Page_As_Deleted;

Line: 1134


    UPDATE CZ_UI_DEFS
       SET ui_status=p_ui_status
     WHERE ui_def_id=p_ui_def_id;

Line: 1146


    IF p_hmode = G_DELETE_PAGE THEN

      UPDATE CZ_UI_PAGES
         SET page_rev_nbr = page_rev_nbr + 1,
             deleted_flag = G_YES_FLAG
       WHERE page_id = p_page_id AND
             ui_def_id = g_UI_Context.ui_def_id;

Line: 1156


      UPDATE CZ_UI_PAGE_ELEMENTS
         SET deleted_flag=G_YES_FLAG
       WHERE ui_def_id= g_UI_Context.ui_def_id AND
             page_id=p_page_id;

Line: 1161


    ELSIF p_hmode = G_DELETE_ELEMENTS THEN
      --
      -- mark elements as already deleted
      --
      UPDATE CZ_UI_PAGE_ELEMENTS
         SET deleted_flag=G_YES_FLAG
       WHERE ui_def_id= g_UI_Context.ui_def_id AND
             page_id=p_page_id AND
             deleted_flag IN(G_MARK_TO_DELETE);

Line: 1175


        UPDATE CZ_UI_PAGES
           SET page_rev_nbr = page_rev_nbr + 1
         WHERE page_id = p_page_id AND
               ui_def_id =  g_UI_Context.ui_def_id;

Line: 1187


      UPDATE CZ_UI_PAGES
         SET page_rev_nbr = page_rev_nbr+1,
             deleted_flag = G_NO_FLAG
       WHERE page_id = p_page_id AND ui_def_id = g_UI_Context.ui_def_id AND
             deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH);

Line: 1193


      UPDATE CZ_UI_PAGE_ELEMENTS
         SET deleted_flag = G_NO_FLAG
       WHERE ui_def_id = g_UI_Context.ui_def_id AND
             page_id = p_page_id AND
             deleted_flag NOT IN(G_NO_FLAG,G_YES_FLAG,G_LIMBO_FLAG);

Line: 1201


      UPDATE CZ_UI_PAGES
         SET page_rev_nbr = 1,
             deleted_flag = G_NO_FLAG
       WHERE page_id = p_page_id AND ui_def_id =  g_UI_Context.ui_def_id AND
             deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH);

Line: 1207


      UPDATE CZ_UI_PAGE_ELEMENTS
         SET deleted_flag = G_NO_FLAG
       WHERE ui_def_id =  g_UI_Context.ui_def_id AND
             page_id = p_page_id AND
             deleted_flag NOT IN(G_NO_FLAG,G_YES_FLAG,G_LIMBO_FLAG);

Line: 1215


      UPDATE CZ_UI_PAGES
         SET deleted_flag = G_NO_FLAG
       WHERE page_id = p_page_id AND ui_def_id =  g_UI_Context.ui_def_id AND
             deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE);

Line: 1220


      UPDATE CZ_UI_PAGE_ELEMENTS
         SET deleted_flag = G_NO_FLAG
       WHERE ui_def_id =  g_UI_Context.ui_def_id AND
             page_id = p_page_id AND
             deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE);

Line: 1442


    SELECT COUNT(page_id)
      INTO l_page_counter
      FROM CZ_UI_PAGES
     WHERE ui_def_id = g_UI_Context.ui_def_id;

Line: 1472


    SELECT COUNT(*) INTO l_counter FROM CZ_UI_PAGES
    WHERE ui_def_id=g_UI_Context.ui_def_id AND jrad_doc=l_jrad_doc;

Line: 1480


        SELECT COUNT(*) INTO l_counter FROM CZ_UI_PAGES
        WHERE ui_def_id=g_UI_Context.ui_def_id AND jrad_doc=l_jrad_doc;

Line: 1527


      SELECT * INTO g_ui_def_nodes_tbl(p_ui_def_id)
        FROM CZ_UI_DEFS
       WHERE ui_def_id = p_ui_def_id;

Line: 1545


      SELECT DISTINCT *
        INTO g_model_nodes_tbl(p_ps_node_id)
        FROM CZ_UITEMPLS_FOR_PSNODES_V
       WHERE ps_node_id = p_ps_node_id AND
             ui_def_id=g_UI_Context.from_master_template_id AND
             deleted_flag = G_NO_FLAG;

Line: 1573


        SELECT persistent_node_id
          INTO g_root_persist_id_tbl(g_UI_Context.devl_project_id)
          FROM CZ_PS_NODES
         WHERE devl_project_id=g_UI_Context.devl_project_id AND
               parent_id IS NULL AND
               deleted_flag=G_NO_FLAG;

Line: 1599


    SELECT DISTINCT *
      INTO l_node
      FROM CZ_UITEMPLS_FOR_PSNODES_V
     WHERE devl_project_id = p_model_id AND
           persistent_node_id = p_persistent_node_id AND
           ui_def_id=g_UI_Context.from_master_template_id AND
           deleted_flag = G_NO_FLAG;

Line: 1626


                             x_non_deleted_child_nodes_tbl  OUT NOCOPY model_nodes_tbl_type,
                             p_include_deleted_nodes IN VARCHAR2 DEFAULT G_NO_FLAG) IS

    l_current_model_node   CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

Line: 1646


          IF l_current_model_node.deleted_flag = G_NO_FLAG THEN
            x_non_deleted_child_nodes_tbl(x_non_deleted_child_nodes_tbl.COUNT+1) := l_current_model_node;

Line: 1656


      FOR i IN (SELECT DISTINCT *
                  FROM CZ_UITEMPLS_FOR_PSNODES_V
                 WHERE ui_def_id=g_UI_Context.from_master_template_id AND
                       parent_id = p_ps_node_id AND
                       (ui_omit = G_NO_FLAG OR p_show_all_nodes = G_YES_FLAG) AND
                       (p_include_deleted_nodes = G_YES_FLAG OR deleted_flag = G_NO_FLAG)
                 ORDER BY tree_seq)
      LOOP
        IF i.deleted_flag = G_NO_FLAG AND i.detailed_type_id=G_UNDEFINED_DATA_TYPE THEN
           g_WRONG_PS_NODE_ID := i.ps_node_id;

Line: 1679


        IF i.deleted_flag = G_NO_FLAG THEN
          x_non_deleted_child_nodes_tbl(x_non_deleted_child_nodes_tbl.COUNT+1) := i;

Line: 1717


          SELECT MIN(model_ref_expl_id)
            INTO l_model_ref_expl_id
            FROM CZ_MODEL_REF_EXPLS a
           WHERE model_id = p_model_id AND
                 referring_node_id = p_ps_node_id AND
                 deleted_flag = G_NO_FLAG;

Line: 1724


          SELECT MIN(model_ref_expl_id)
            INTO l_model_ref_expl_id
            FROM CZ_MODEL_REF_EXPLS
           WHERE model_id = p_model_id AND
                 component_id = p_component_id AND
                 referring_node_id IS NULL AND
                 deleted_flag = G_NO_FLAG;

Line: 1752


    SELECT * INTO l_page_node
      FROM CZ_UI_PAGES
     WHERE page_id=p_page_id AND
           ui_def_id=g_UI_Context.ui_def_id;

Line: 1767


    SELECT *
      INTO l_ui_node
      FROM CZ_UI_PAGE_ELEMENTS
     WHERE ui_def_id = g_UI_Context.ui_def_id AND
           page_id=p_page_id AND
           element_id = p_element_id;

Line: 1783


    SELECT *
      INTO l_page_set_node
      FROM CZ_UI_PAGE_SETS
     WHERE page_set_id = p_page_set_id AND
           ui_def_id=g_UI_Context.ui_def_id;

Line: 1800


    SELECT COUNT(element_id)+1 INTO l_counter FROM CZ_UI_PAGE_ELEMENTS
    WHERE ui_def_id=g_UI_Context.ui_def_id AND
          page_id=p_page_id AND
          ctrl_template_id=p_template_id AND
          deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE);

Line: 1808


        SELECT template_name||' - '||TO_CHAR(l_counter)
          INTO l_ui_node_name
          FROM CZ_UI_TEMPLATES
          WHERE template_id=p_template_id AND
                ui_def_id=g_UI_Context.ui_def_id;

Line: 1815


          SELECT template_name||' - '||TO_CHAR(l_counter)
            INTO l_ui_node_name
            FROM CZ_UI_TEMPLATES
           WHERE template_id=p_template_id AND
                ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;

Line: 1844


        SELECT jrad_doc INTO g_template_jrad_name_tbl(p_template_id)
          FROM CZ_UI_TEMPLATES
         WHERE template_id=p_template_id AND
               ui_def_id=p_template_ui_def_id;

Line: 1850


          SELECT jrad_doc INTO g_template_jrad_name_tbl(p_template_id)
            FROM CZ_UI_TEMPLATES
           WHERE  template_id=p_template_id AND
                  ui_def_id=g_UI_Context.ui_def_id;

Line: 1856


            SELECT jrad_doc INTO g_template_jrad_name_tbl(p_template_id)
              FROM CZ_UI_TEMPLATES
             WHERE template_id=p_template_id AND
                   ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;

Line: 1873


    SELECT ui_action_id
      INTO l_ui_action_id
      FROM CZ_UI_ACTIONS
     WHERE ui_def_id = p_ui_node.ui_def_id AND
           source_page_id=p_ui_node.page_id AND
           element_id = p_ui_node.element_id AND
           deleted_flag=G_NO_FLAG;

Line: 1900


      SELECT seeded_flag INTO l_seeded_flag FROM CZ_INTL_TEXTS
      WHERE intl_text_id=p_intl_text_id;

Line: 1906


       SELECT NVL(devl_project_id,0) INTO l_model_id FROM CZ_UI_DEFS
       WHERE ui_def_id=p_target_ui_def_id;

Line: 1911


      INSERT INTO CZ_INTL_TEXTS
           (INTL_TEXT_ID,
            TEXT_STR,
            DELETED_FLAG,
            SEEDED_FLAG,
            UI_DEF_ID,
            MODEL_ID,
            UI_PAGE_ID,
            UI_PAGE_ELEMENT_ID
            )
      SELECT
           l_ui_intl_text_id,
           text_str,
           G_NO_FLAG,
           G_NO_FLAG,
           p_target_ui_def_id,
           l_model_id,
           p_page_id,
           p_element_id
      FROM CZ_INTL_TEXTS
      WHERE intl_text_id=p_intl_text_id;

Line: 1944


    INSERT INTO CZ_UI_IMAGES
      (UI_DEF_ID
       ,MASTER_TEMPLATE_FLAG
       ,IMAGE_USAGE_CODE
       ,IMAGE_FILE
       ,DELETED_FLAG
       ,SEEDED_FLAG
       ,ENTITY_CODE,
       LAST_UPDATE_LOGIN)
    SELECT
       p_ui_def_id
       ,G_NO_FLAG
       ,IMAGE_USAGE_CODE
       ,IMAGE_FILE
       ,DELETED_FLAG
       ,G_NO_FLAG
       ,ENTITY_CODE
       ,-UID
     FROM CZ_UI_IMAGES a
     WHERE ui_def_id=p_master_template_id
           AND deleted_flag=G_NO_FLAG AND
           NOT EXISTS(SELECT NULL FROM CZ_UI_IMAGES
                      WHERE ui_def_id=p_ui_def_id AND
                            IMAGE_USAGE_CODE=a.IMAGE_USAGE_CODE AND
                            ENTITY_CODE=a.ENTITY_CODE AND deleted_flag=G_NO_FLAG);

Line: 1970


    UPDATE CZ_UI_IMAGES a
       SET IMAGE_FILE=(SELECT IMAGE_FILE FROM CZ_UI_IMAGES
                       WHERE  ui_def_id=p_master_template_id AND
                            IMAGE_USAGE_CODE=a.IMAGE_USAGE_CODE AND
                            ENTITY_CODE=a.ENTITY_CODE AND deleted_flag=G_NO_FLAG )
    WHERE ui_def_id=p_ui_def_id AND deleted_flag=G_NO_FLAG;

Line: 1994


    FOR h IN(SELECT * FROM CZ_UI_CONT_TYPE_TEMPLS
             WHERE ui_def_id = p_master_template_id AND
                   content_type=p_content_type AND
                   deleted_flag=G_NO_FLAG)
    LOOP
      BEGIN
        INSERT INTO CZ_UI_CONT_TYPE_TEMPLS
                (ui_def_id,
                 content_type,
                 template_id,
                 master_template_flag,
                 seeded_flag,
                 template_ui_def_id,
                 deleted_flag)
        VALUES(
                 p_ui_def_id,
                 h.content_type,
                 h.template_id,
                 G_NO_FLAG,
                 G_NO_FLAG,
                 l_template_ui_def_id,
                 G_NO_FLAG);

Line: 2072


      INSERT INTO CZ_UI_TEMPLATES
      (TEMPLATE_ID,
       UI_DEF_ID,
       TEMPLATE_NAME,
       TEMPLATE_TYPE,
       TEMPLATE_DESC,
       PARENT_CONTAINER_TYPE,
       JRAD_DOC,
       BUTTON_BAR_TEMPLATE_ID,
       MESSAGE_TYPE,
       MAIN_MESSAGE_ID,
       TITLE_ID,
       SEEDED_FLAG,
       LAYOUT_UI_STYLE,
       ROOT_REGION_TYPE,
       ROOT_ELEMENT_SIGNATURE_ID,
       BUTTON_BAR_TEMPL_UIDEF_ID,
       TEMPLATE_USAGE,
       AMN_USAGE,
       DELETED_FLAG)
       SELECT
        template_id,
        g_UI_Context.ui_def_id,
        TEMPLATE_NAME,
        TEMPLATE_TYPE,
        TEMPLATE_DESC,
        PARENT_CONTAINER_TYPE,
        l_jrad_doc,
        BUTTON_BAR_TEMPLATE_ID,
        MESSAGE_TYPE,
        MAIN_MESSAGE_ID,
        TITLE_ID,
        G_NO_FLAG,
        LAYOUT_UI_STYLE,
        ROOT_REGION_TYPE,
        ROOT_ELEMENT_SIGNATURE_ID,
        BUTTON_BAR_TEMPL_UIDEF_ID,
        TEMPLATE_USAGE,
        AMN_USAGE,
        G_NO_FLAG
       FROM CZ_UI_TEMPLATES
       WHERE template_id=p_template_id AND ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;

Line: 2250


      FOR m IN(SELECT DISTINCT detailed_type_id
               FROM CZ_UITEMPLS_FOR_PSNODES_V
               WHERE devl_project_id=g_UI_Context.devl_project_id AND
                     ui_def_id=g_UI_Context.from_master_template_id AND
                     deleted_flag=G_NO_FLAG AND ui_omit=G_NO_FLAG)
      LOOP
        l_detailed_type_id_tbl(m.detailed_type_id) := m.detailed_type_id;

Line: 2261


    FOR k IN(SELECT * FROM CZ_UI_CONT_TYPE_TEMPLS
             WHERE ui_def_id = g_UI_Context.from_master_template_id AND
                   deleted_flag = G_NO_FLAG)
    LOOP

      IF k.content_type = G_PAGE_STATUS_CONTENT_TYPE THEN
         g_PAGE_STATUS_TEMPLATE_ID := k.template_id;

Line: 2295


    SELECT template_id INTO g_DRILLDOWN_TEMPLATE_ID
      FROM CZ_UI_CONT_TYPE_TEMPLS
     WHERE ui_def_id=g_UI_Context.from_master_template_id AND
           content_type=2151 AND deleted_flag=G_NO_FLAG;

Line: 2322


    SELECT *
      INTO l_page_ref_node
      FROM CZ_UI_PAGE_REFS a
     WHERE ui_def_id = p_ui_node.ui_def_id AND
           (target_page_id,page_set_id) IN
           (SELECT page_id,NVL(page_set_id,a.page_set_id) FROM CZ_UI_PAGES
            WHERE page_id=p_ui_node.page_id AND ui_def_id=p_ui_node.ui_def_id AND
            deleted_flag NOT IN(G_YES_FLAG)) AND
           deleted_flag = G_NO_FLAG;

Line: 2361


         SELECT MIN(node_depth) INTO l_node_depth FROM CZ_UI_PAGE_REFS
         WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
                AND deleted_flag=G_NO_FLAG;

Line: 2365


         SELECT MIN(SEQ_NBR) INTO l_seq_nbr FROM CZ_UI_PAGE_REFS
         WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
                AND node_depth=l_node_depth AND deleted_flag=G_NO_FLAG;

Line: 2369


         SELECT DISTINCT target_persistent_node_id INTO l_persistent_node_id
         FROM CZ_UI_PAGE_REFS
         WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
               AND seq_nbr=l_seq_nbr AND
               target_persistent_node_id NOT IN
              (SELECT  ref_persistent_node_id FROM CZ_UI_REFS WHERE
                ui_def_id=g_UI_Context.ui_def_id AND deleted_flag=G_NO_FLAG) AND
               rownum<2;

Line: 2387


    SELECT parent_id INTO l_parent_id FROM CZ_PS_NODES
    WHERE ps_node_id=p_ps_node_id;

Line: 2395


      FOR i IN(SELECT persistent_node_id, parent_id FROM CZ_PS_NODES
               START WITH ps_node_id=p_ps_node_id AND deleted_flag=G_NO_FLAG
               CONNECT BY PRIOR parent_id=ps_node_id AND
               PRIOR deleted_flag=G_NO_FLAG AND deleted_flag=G_NO_FLAG)
      LOOP
        IF l_model_path IS NULL THEN
          l_model_path:=TO_CHAR(i.persistent_node_id);

Line: 2413


      FOR i IN(SELECT ps_node_id,persistent_node_id, parent_id FROM CZ_PS_NODES
               START WITH ps_node_id=p_ps_node_id AND deleted_flag=G_NO_FLAG
               CONNECT BY PRIOR parent_id=ps_node_id AND
               PRIOR deleted_flag=G_NO_FLAG AND deleted_flag=G_NO_FLAG)
      LOOP
        IF i.ps_node_id = l_ps_node.ps_node_id THEN
          EXIT;

Line: 2513


    SELECT COUNT(*)
      INTO l_page_counter
      FROM CZ_UI_PAGE_SETS
     WHERE ui_def_id = g_UI_Context.ui_def_id AND
           deleted_flag=G_NO_FLAG;

Line: 2529


    SELECT NVL(MAX(seq_nbr),0)
      INTO l_seq_nbr
      FROM CZ_UI_PAGE_ELEMENTS
     WHERE ui_def_id=g_UI_Context.ui_def_id AND
           parent_element_id=p_parent_element_id AND
           deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 2544


    SELECT NVL(MAX(split_seq_nbr),0)
      INTO l_split_seq_nbr
      FROM CZ_UI_PAGES
     WHERE ui_def_id=g_UI_Context.ui_def_id AND
           persistent_node_id IN
          (SELECT persistent_node_id FROM CZ_UI_PAGES
            WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=p_page_id);

Line: 2561


    SELECT COUNT(element_id)
      INTO l_counter
      FROM CZ_UI_PAGE_ELEMENTS
     WHERE ui_def_id=p_page_node.ui_def_id AND
           page_id=p_page_node.page_id AND ctrl_template_id IS NOT NULL AND
           deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 2592


      SELECT COUNT(page_set_id)+1 INTO l_page_set_counter FROM CZ_UI_PAGE_SETS
      WHERE ui_def_id=p_ui_def_id AND page_set_type=p_page_set_type AND
            deleted_flag=G_NO_FLAG;

Line: 2609


    INSERT INTO CZ_UI_PAGE_SETS
        (ui_def_id,
         page_set_id,
         page_set_type,
         NAME,
         suppress_refresh_flag,
         train_jrad_doc,
         persistent_node_id,
         pagebase_expl_node_id,
         deleted_flag)
    VALUES
        (p_ui_def_id,
         x_page_set_id,
         p_page_set_type,
         l_page_set_name,
         g_suppress_refresh_flag,
         NULL,
         p_persistent_node_id,
         p_model_ref_expl_id,
         G_NO_FLAG);

Line: 2638


    l_ui_page_set_node.deleted_flag  := G_NO_FLAG;

Line: 2969


    SELECT 'x' INTO l_ui_ref_exists
      FROM  CZ_UI_REFS
     WHERE ui_def_id=p_ui_node.ui_def_id AND
           ref_persistent_node_id=p_ui_node.persistent_node_id AND
           deleted_flag=G_NO_FLAG AND rownum<2;

Line: 2987


    l_mark_flag             CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;

Line: 2991


     FOR i IN(SELECT page_id,element_id,parent_element_id,suppress_refresh_flag
                FROM CZ_UI_PAGE_ELEMENTS
               WHERE ui_def_id=p_ui_node.ui_def_id AND
                     persistent_node_id=p_ui_node.persistent_node_id AND
                     element_type IN(G_UI_NONBOMADDINST_NODE_TYPE,G_UI_BOMADDINST_NODE_TYPE) AND
                     deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE, G_LIMBO_FLAG))
    LOOP
      IF i.suppress_refresh_flag=G_YES_FLAG THEN
          UPDATE CZ_UI_PAGE_ELEMENTS
             SET deleted_flag=G_MARK_TO_DEASSOCIATE,
                 persistent_node_id=0
           WHERE ui_def_id=p_ui_node.ui_def_id AND
                page_id=i.page_id AND
                element_id=i.element_id;

Line: 3006


        SELECT suppress_refresh_flag INTO l_suppress_refresh_flag FROM CZ_UI_PAGE_ELEMENTS
        WHERE ui_def_id=p_ui_node.ui_def_id AND page_id=i.page_id AND
              element_id=i.parent_element_id;

Line: 3010


          UPDATE CZ_UI_PAGE_ELEMENTS
             SET deleted_flag=G_MARK_TO_DEASSOCIATE,
                 persistent_node_id=0
           WHERE ui_def_id=p_ui_node.ui_def_id AND
                page_id=i.page_id AND
                element_id=i.element_id;

Line: 3017


          UPDATE CZ_UI_PAGE_ELEMENTS
             SET deleted_flag=G_MARK_TO_DELETE
           WHERE ui_def_id=p_ui_node.ui_def_id AND
                 page_id=i.page_id AND
                 element_id=i.element_id;

Line: 3063


    SELECT MIN(page_ref_id)
      INTO l_parent_page_ref_id
      FROM CZ_UI_PAGE_REFS
     WHERE ui_def_id=p_ui_node.ui_def_id AND
           target_persistent_node_id=p_ui_node.parent_persistent_node_id AND
           deleted_flag=G_NO_FLAG;

Line: 3070


    SELECT page_set_id,page_ref_type
      INTO l_parent_page_set_id,l_page_ref_type FROM CZ_UI_PAGE_REFS
    WHERE ui_def_id=p_ui_node.ui_def_id AND page_ref_id=l_parent_page_ref_id;

Line: 3077


    UPDATE CZ_UI_PAGE_REFS
       SET parent_page_ref_id = l_parent_page_ref_id
     WHERE ui_def_id=p_ui_node.ui_def_id AND
           page_ref_id=l_child_page_ref_id;

Line: 3082


    UPDATE CZ_UI_PAGE_REFS
       SET page_set_id = l_parent_page_set_id
     WHERE ui_def_id=p_ui_node.ui_def_id AND
           target_page_id IN
           (SELECT target_page_id FROM CZ_UI_PAGE_REFS
            START WITH ui_def_id=p_ui_node.ui_def_id AND
                       page_ref_id=l_child_page_ref_id
            CONNECT BY PRIOR page_ref_id=parent_page_ref_id AND
                    ui_def_id=p_ui_node.ui_def_id AND
                    page_set_id=l_child_page_set_id AND
                    PRIOR page_set_id=l_child_page_set_id AND
                    PRIOR ui_def_id=p_ui_node.ui_def_id AND
                    deleted_flag=G_NO_FLAG AND PRIOR deleted_flag=G_NO_FLAG)
     RETURNING target_persistent_node_id BULK COLLECT INTO l_changed_target_ids_tbl;

Line: 3100


         UPDATE CZ_UI_PAGES
            SET page_set_id=l_parent_page_set_id
          WHERE persistent_node_id=l_changed_target_ids_tbl(x) AND
                ui_def_id=p_ui_node.ui_def_id;

Line: 3108


           UPDATE CZ_UI_PAGE_REFS
              SET target_path=l_target_path
            WHERE ui_def_id=p_ui_node.ui_def_id AND
                  page_set_id=l_parent_page_set_id AND
                  target_persistent_node_id=l_changed_target_ids_tbl(x) AND
                  target_path<>l_target_path;

Line: 3168


    UPDATE CZ_UI_PAGE_REFS
       SET target_path='.',
           parent_page_ref_id=NULL,
           node_depth=1,
           seq_nbr=1
     WHERE ui_def_id=p_ui_node.ui_def_id AND
           page_ref_id=l_initial_page_ref_id;

Line: 3176


    UPDATE CZ_UI_PAGE_REFS
       SET page_set_id = l_page_set_id
     WHERE ui_def_id=p_ui_node.ui_def_id AND
           target_persistent_node_id IN
                (SELECT target_persistent_node_id FROM CZ_UI_PAGE_REFS
                 START WITH ui_def_id=p_ui_node.ui_def_id AND
                            page_ref_id=l_initial_page_ref_id
                 CONNECT BY PRIOR page_ref_id=parent_page_ref_id AND
                    ui_def_id=p_ui_node.ui_def_id AND
                    page_set_id=l_initial_page_set_id AND
                    PRIOR page_set_id=l_initial_page_set_id AND
                    PRIOR ui_def_id=p_ui_node.ui_def_id AND
                    deleted_flag=G_NO_FLAG AND PRIOR deleted_flag=G_NO_FLAG)
     RETURNING target_page_id,target_persistent_node_id
     BULK COLLECT INTO l_target_page_ids_tbl,l_changed_target_ids_tbl;

Line: 3195


         UPDATE CZ_UI_PAGES
            SET page_set_id=l_page_set_id
          WHERE page_id=l_target_page_ids_tbl(j) AND
                ui_def_id=p_ui_node.ui_def_id;

Line: 3203


           UPDATE CZ_UI_PAGE_REFS
              SET target_path=l_target_path
            WHERE ui_def_id=p_ui_node.ui_def_id AND
                  page_set_id=l_page_set_id AND
                  target_persistent_node_id=l_changed_target_ids_tbl(j) AND
                  target_path<>l_target_path;

Line: 3223


    l_undeleted_exist    BOOLEAN;

Line: 3230


      SELECT cx_command_name
        INTO l_ui_cx_command_name
        FROM CZ_UI_ACTIONS
       WHERE ui_def_id=p_ui_node.ui_def_id AND
             element_id=p_ui_node.element_id AND
             cx_command_name IS NOT NULL  AND-- fix for bug 3923033
             deleted_flag=G_NO_FLAG;

Line: 3242


    l_undeleted_exist := FALSE;

Line: 3243


    FOR i IN(SELECT a.deleted_flag, a.invalid_flag, a.disabled_flag ,
                     a.INSTANTIATION_SCOPE, b.data_value, a.name
             FROM CZ_RULES a, CZ_EXPRESSION_NODES b
             WHERE a.devl_project_id=l_model_node.devl_project_id AND
                   a.component_id=l_model_node.ps_node_id AND
                   a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
                   a.deleted_flag=G_NO_FLAG AND
                   b.rule_id=a.rule_id AND
                   b.deleted_flag=G_NO_FLAG AND
                   b.argument_signature_id=G_EVENT_ON_COMMAND_SIGID AND
                   data_value=l_ui_cx_command_name)
    LOOP

      IF i.deleted_flag=G_NO_FLAG THEN
         l_undeleted_exist := TRUE;

Line: 3261


         i.deleted_flag=G_NO_FLAG THEN
        RETURN G_CX_VALID;

Line: 3268


      FOR i IN(SELECT a.name, a.deleted_flag, a.invalid_flag, a.disabled_flag,
                      a.INSTANTIATION_SCOPE, b.data_value
             FROM CZ_RULES a, CZ_EXPRESSION_NODES b
             WHERE a.devl_project_id=l_model_node.devl_project_id AND
                   a.component_id IN
               (SELECT ps_node_id FROM CZ_PS_NODES
                WHERE devl_project_id IN
                (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS
                START WITH model_id=l_model_node.devl_project_id AND
                           referring_node_id=l_model_node.ps_node_id
                CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND
                         deleted_flag='0' AND PRIOR deleted_flag='0') AND
                deleted_flag='0') AND
                   a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
                   b.rule_id=a.rule_id AND
                   b.deleted_flag=G_NO_FLAG AND
                   b.argument_signature_id=G_EVENT_ON_COMMAND_SIGID AND
                   data_value IS NOT NULL)
      LOOP

        IF l_model_node.instantiable_flag NOT IN(G_MANDATORY_INST_TYPE) AND
           i.INSTANTIATION_SCOPE=1 AND i.disabled_flag=G_NO_FLAG THEN

          add_Error_Message(p_message_name => 'CZ_CX_IS_IN_WRONG_SCOPE',
                            p_token_name1  => 'EVENT_NAME',
                            p_token_value1 => i.data_value,
                            p_token_name2  => 'RULE_NAME',
                            p_token_value2 => i.name,
                            p_fatal_error  => FALSE);

Line: 3302


        IF i.deleted_flag=G_NO_FLAG THEN
           l_undeleted_exist := TRUE;

Line: 3307


           i.deleted_flag=G_NO_FLAG THEN
          RETURN G_CX_VALID;

Line: 3314


    IF l_undeleted_exist=FALSE THEN
      RETURN G_CX_MUST_BE_DELETED;

Line: 3332


      UPDATE CZ_UI_PAGE_ELEMENTS
         SET model_ref_expl_id=p_expl_id
       WHERE ui_def_id=p_ui_node.ui_def_id AND
             page_id=p_ui_node.page_id AND
             element_id=p_ui_node.element_id;

Line: 3339


        UPDATE CZ_UI_PAGES
           SET pagebase_expl_node_id=p_expl_id
         WHERE page_id=p_ui_node.page_id AND
               ui_def_id=p_ui_node.ui_def_id;

Line: 3344


           UPDATE CZ_UI_PAGE_SETS
              SET pagebase_expl_node_id=p_expl_id
            WHERE ui_def_id=g_UI_Context.ui_def_id
                  AND persistent_node_id=p_ui_node.persistent_node_id
                  AND deleted_flag=G_NO_FLAG;

Line: 3352


      UPDATE CZ_UI_PAGE_REFS
         SET target_expl_node_id=p_expl_id
       WHERE ui_def_id=p_ui_node.ui_def_id AND
             target_persistent_node_id=p_node.persistent_node_id;

Line: 3387


    SELECT COUNT(*)+1 INTO l_counter FROM CZ_UI_PAGE_ELEMENTS
    WHERE ui_def_id=p_ui_node.ui_def_id AND
           page_id=p_ui_node.page_id AND
           element_signature_id=p_model_node.root_element_signature_id AND
           deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE, G_LIMBO_FLAG);

Line: 3393


    UPDATE CZ_UI_PAGE_ELEMENTS
       SET ctrl_template_id=p_model_node.template_id,
           element_signature_id=p_model_node.root_element_signature_id,
           deleted_flag=DECODE(deleted_flag,G_MARK_TO_ADD,G_MARK_TO_ADD,G_MARK_TO_REFRESH),
           name=p_model_node.template_name||' - '||l_counter
     WHERE ui_def_id=p_ui_node.ui_def_id AND
           page_id=p_ui_node.page_id AND
           element_id=p_ui_node.element_id;

Line: 3472


    g_model_nodes_tbl.DELETE;

Line: 3473


    g_ui_page_elements_tbl.DELETE;

Line: 3474


    g_ps_node_persist_id_tbl.DELETE;

Line: 3475


    g_ui_pages_tbl.DELETE;

Line: 3476


    g_ui_page_refs_tbl.DELETE;

Line: 3477


    g_ui_refs_tbl.DELETE;

Line: 3478


    g_ui_page_sets_tbl.DELETE;

Line: 3479


    g_ref_expls_tbl.DELETE;

Line: 3480


    g_ui_action_ids_tbl.DELETE;

Line: 3492


    FOR i IN (SELECT DISTINCT *
                FROM CZ_UITEMPLS_FOR_PSNODES_V
                WHERE ui_def_id=g_UI_Context.from_master_template_id AND
                      devl_project_id = g_UI_Context.devl_project_id)
    LOOP
      g_model_nodes_tbl(i.ps_node_id) := i;

Line: 3501


    FOR i IN(SELECT model_ref_expl_id,referring_node_id,component_id
               FROM CZ_MODEL_REF_EXPLS
              WHERE model_id=g_UI_Context.devl_project_id AND
                    deleted_flag=G_NO_FLAG)
    LOOP
      IF i.referring_node_id IS NOT NULL THEN
        g_ref_expls_tbl(i.referring_node_id) := i.model_ref_expl_id;

Line: 3513


    FOR i IN (SELECT *
                FROM CZ_UI_PAGES
               WHERE ui_def_id = g_UI_Context.ui_def_id AND
                     deleted_flag = G_NO_FLAG)
    LOOP
      g_ui_pages_tbl(i.page_id) := i;

Line: 3527


    FOR i IN (SELECT *
                FROM CZ_UI_PAGE_ELEMENTS
               WHERE ui_def_id = g_UI_Context.ui_def_id AND
                     deleted_flag = G_NO_FLAG)
    LOOP
      BEGIN
        g_ui_page_elements_tbl(TO_NUMBER(i.element_id)) := i;

Line: 3543


    FOR i IN (SELECT *
                FROM CZ_UI_PAGE_REFS
               WHERE ui_def_id = g_UI_Context.ui_def_id AND
                     deleted_flag = G_NO_FLAG)
    LOOP
      g_ui_page_refs_tbl(i.page_ref_id) := i;

Line: 3551


    FOR i IN (SELECT *
                FROM CZ_UI_PAGE_SETS
               WHERE ui_def_id = g_UI_Context.ui_def_id AND
                     deleted_flag = G_NO_FLAG)
    LOOP
      g_ui_page_sets_tbl(i.page_set_id) := i;

Line: 3559


    FOR i IN (SELECT ref_persistent_node_id
                FROM CZ_UI_REFS
               WHERE ui_def_id = g_UI_Context.ui_def_id AND
                     deleted_flag = G_NO_FLAG)
    LOOP
      g_ui_refs_tbl(i.ref_persistent_node_id) := i.ref_persistent_node_id;

Line: 3567


    FOR i IN (SELECT element_id, ui_action_id
                FROM CZ_UI_ACTIONS
               WHERE ui_def_id = g_UI_Context.ui_def_id AND
                     deleted_flag = G_NO_FLAG)
    LOOP
      BEGIN
        g_ui_action_ids_tbl(TO_NUMBER(i.element_id)) := i.ui_action_id;

Line: 4203


    SELECT template_id,template_name INTO l_template_id,l_template_name FROM CZ_UI_TEMPLATES
     WHERE ui_def_id=p_ui_node.ctrl_template_ui_def_id AND
           jrad_doc=l_extend_attr_value AND deleted_flag=G_NO_FLAG;

Line: 4207


    SELECT NVL(max(seq_nbr),0)+1 INTO l_seq_nbr FROM CZ_UI_PAGE_ELEMENTS
     WHERE ui_def_id=p_ui_node.ui_def_id AND
           page_id=p_ui_node.page_id AND
           parent_element_id=p_ui_node.element_id AND
           deleted_flag NOT IN(G_LIMBO_FLAG,G_MARK_TO_DELETE,G_YES_FLAG);

Line: 4215


    INSERT INTO CZ_UI_PAGE_ELEMENTS
      (
      UI_DEF_ID
      ,PAGE_ID
      ,PERSISTENT_NODE_ID
      ,ELEMENT_ID
      ,PARENT_PERSISTENT_NODE_ID
      ,REGION_PERSISTENT_NODE_ID
      ,PAGEBASE_PERSISTENT_NODE_ID
      ,CTRL_TEMPLATE_ID
      ,BASE_PAGE_FLAG
      ,INSTANTIABLE_FLAG
      ,SEQ_NBR
      ,DELETED_FLAG
      ,CTRL_TEMPLATE_UI_DEF_ID
      ,MODEL_REF_EXPL_ID
      ,SUPPRESS_REFRESH_FLAG
      ,PARENT_ELEMENT_ID
      ,ELEMENT_TYPE
      ,NAME
      ,ELEMENT_SIGNATURE_ID
      ,TARGET_PAGE_UI_DEF_ID
      ,TARGET_PAGE_ID
      )
    VALUES
      (
      p_ui_node.ui_def_id
      ,p_ui_node.page_id
      ,NULL
      ,l_element_id
      ,p_ui_node.parent_persistent_node_id
      ,p_ui_node.region_persistent_node_id
      ,p_ui_node.pagebase_persistent_node_id
      ,l_template_id
      ,'0'
      ,'0'
      ,l_seq_nbr
      ,G_NO_FLAG
      ,p_ui_node.ctrl_template_ui_def_id
      ,NULL
      ,'0'
      ,p_ui_node.element_id
      ,NULL
      ,l_template_name
      ,6011
      ,NULL
      ,NULL
      );

Line: 4287


             SELECT * INTO l_ui_element FROM CZ_UI_PAGE_ELEMENTS
              WHERE ui_def_id=p_ui_def_id AND page_id=p_ui_page_id AND
                    element_id=l_id_attr_value;

Line: 4309


             SELECT * INTO l_ui_element FROM CZ_UI_PAGE_ELEMENTS
              WHERE ui_def_id=p_ui_def_id AND page_id=p_ui_page_id AND
                    element_id=l_id_attr_value;

Line: 4505


            SELECT template_id, seeded_flag
              INTO l_ref_template_id, l_seeded_flag
              FROM CZ_UI_TEMPLATES
             WHERE ui_def_id=p_template_ui_def_id AND
                   jrad_doc=l_extends_attribute AND
                   deleted_flag=G_NO_FLAG;

Line: 4528


    FOR k IN(SELECT ref_template_id FROM CZ_UI_REF_TEMPLATES
              WHERE template_id=p_template_id AND
                    template_ui_def_id=p_template_ui_def_id AND
                    deleted_flag=G_NO_FLAG)
    LOOP
      IF NOT(l_ref_tmpls_tbl.EXISTS(k.ref_template_id)) THEN
        DELETE FROM CZ_UI_REF_TEMPLATES
         WHERE template_id=p_template_id AND
               template_ui_def_id=p_template_ui_def_id AND
               ref_template_id=k.ref_template_id;

Line: 4547


      UPDATE CZ_UI_REF_TEMPLATES
         SET ref_count = l_ref_tmpls_tbl(l_template_id)
       WHERE template_id=p_template_id AND
             template_ui_def_id=p_template_ui_def_id AND
             ref_template_id=l_template_id AND
             deleted_flag=G_NO_FLAG;

Line: 4555


          INSERT INTO CZ_UI_REF_TEMPLATES
          (
          TEMPLATE_ID
          ,REF_TEMPLATE_ID
          ,DELETED_FLAG
          ,TEMPLATE_UI_DEF_ID
          ,REF_TEMPLATE_UI_DEF_ID
          ,SEEDED_FLAG
          ,REF_TEMPL_SEEDED_FLAG
          ,REF_COUNT
          )
          VALUES
          (
           p_template_id
          ,l_template_id
          ,G_NO_FLAG
          ,p_template_ui_def_id
          ,p_template_ui_def_id
          ,G_NO_FLAG
          ,l_ref_tmpl_seeded_flag(l_template_id)
          ,l_ref_tmpls_tbl(l_template_id)
          );

Line: 4809


        SELECT COUNT(element_id) INTO p_counter
        FROM CZ_UI_PAGE_ELEMENTS
        WHERE ui_def_id=g_UI_Context.ui_def_id
        AND page_id=p_ui_page_id AND
        deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 5208


    SELECT jrad_doc,name INTO l_page_jrad_doc,l_page_name FROM CZ_UI_PAGES
    WHERE ui_def_id=p_ui_def_id AND page_id=p_page_id;

Line: 5227


    SELECT name INTO l_ui_name FROM CZ_UI_DEFS
    WHERE ui_def_id=p_ui_def_id;

Line: 5270


      FOR k IN(SELECT rule_id,rule_type,seeded_flag,devl_project_id FROM CZ_RULES
               WHERE persistent_rule_id = p_rule_id AND DECODE(NVL(ui_def_id,0),0,l_source_ui_def_id,ui_def_id)=l_source_ui_def_id
                     AND deleted_flag=G_NO_FLAG)
      LOOP
        l_run_id := 0; l_cp_rule_run_id := 0;

Line: 5297


          SELECT COUNT(*) INTO l_failure_flag FROM CZ_DB_LOGS WHERE run_id=l_cp_rule_run_id;

Line: 5310


            SELECT name INTO l_element_path FROM CZ_UI_PAGES
            WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id;

Line: 5355


    SELECT persistent_node_id,pagebase_expl_node_id
      INTO l_pagebase_persistent_node_id, l_pagebase_expl_id
      FROM CZ_UI_PAGES
     WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=p_page_id;

Line: 5365


      SELECT ps_node_id,ps_node_type,component_id
        INTO l_ps_node_id, l_ps_node_type, l_component_id  FROM CZ_PS_NODES
       WHERE devl_project_id=p_model_id AND
             persistent_node_id=p_persistent_node_id;

Line: 5401


    SELECT model_ref_expl_id INTO l_model_ref_expl_id
      FROM CZ_MODEL_REF_EXPLS
     WHERE model_ref_expl_id=p_ui_node_expl_id;

Line: 5409


    FOR i IN(SELECT model_ref_expl_id,parent_expl_node_id,ps_node_type,
                    component_id,referring_node_id
               FROM CZ_MODEL_REF_EXPLS
              START WITH model_ref_expl_id=p_ui_node_expl_id
              CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND
                               deleted_flag='0')
    LOOP
      -- go up until the nearest reference
      IF (i.ps_node_type IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) OR i.parent_expl_node_id IS NULL) THEN

        -- get ps node data for AMN of UI node
        SELECT ps_node_id,ps_node_type,component_id
          INTO l_ps_node_id, l_ps_node_type,l_component_id
          FROM CZ_PS_NODES
         WHERE devl_project_id=i.component_id AND
               persistent_node_id=p_persistent_node_id AND
               deleted_flag=G_NO_FLAG;

Line: 5429


          SELECT model_ref_expl_id INTO l_expl_id FROM
            (SELECT model_ref_expl_id,referring_node_id,component_id FROM CZ_MODEL_REF_EXPLS
              START WITH model_ref_expl_id=i.model_ref_expl_id
            CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag='0') a
          WHERE (l_ps_node_type IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) AND a.referring_node_id=l_ps_node_id) OR
                (l_ps_node_type NOT IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) AND a.component_id=l_component_id);

Line: 5497


      FOR i IN(SELECT * FROM CZ_UI_ACTIONS
                WHERE ui_def_id=p_source_ui_def_id AND
                ui_action_id=l_id AND
                NVL(source_page_id,0)=NVL(p_source_ui_page_id,0)
                AND seeded_flag=G_NO_FLAG)
      LOOP

          l_new_action_id := allocateId('CZ_UI_ACTIONS_S');

Line: 5514


          INSERT INTO CZ_UI_ACTIONS
          (
          UI_ACTION_ID
          ,UI_DEF_ID
          ,SOURCE_PAGE_ID
          ,CONTEXT_COMPONENT_ID
          ,ELEMENT_ID
          ,RENDER_CONDITION_ID
          ,UI_ACTION_TYPE
          ,TARGET_UI_DEF_ID
          ,TARGET_PERSISTENT_NODE_ID
          ,TARGET_NODE_PATH
          ,TARGET_PAGE_SET_ID
          ,TARGET_PAGE_ID
          ,TARGET_URL
          ,FRAME_NAME
          ,TARGET_ANCHOR
          ,DELETED_FLAG
          ,SEEDED_FLAG
          ,CX_COMMAND_NAME
          ,WINDOW_PARAMETERS
          ,TARGET_WINDOW_TYPE
          ,TARGET_WINDOW_NAME
          ,TARGET_EXPL_NODE_ID
          ,URL_PROPERTY_ID
          ,PROC_PAGE_TEMPL_UI_DEF_ID
          ,PAGE_TITLE_TEXT_ID
          ,MAIN_MESSAGE_TEXT_ID
          ,PROCESSING_CAPTION_TEXT_ID
          ,PROCESSING_PAGE_TEMPL_ID
          )
          VALUES(
          l_new_action_id
          ,p_target_ui_def_id
          ,p_target_ui_page_id
          ,i.CONTEXT_COMPONENT_ID
          ,p_new_element_id
          ,i.RENDER_CONDITION_ID
          ,i.UI_ACTION_TYPE
          ,i.TARGET_UI_DEF_ID
          ,i.TARGET_PERSISTENT_NODE_ID
          ,l_new_target_node_path
          ,i.TARGET_PAGE_SET_ID
          ,i.TARGET_PAGE_ID
          ,i.TARGET_URL
          ,i.FRAME_NAME
          ,i.TARGET_ANCHOR
          ,i.DELETED_FLAG
          ,'0'
          ,i.CX_COMMAND_NAME
          ,i.WINDOW_PARAMETERS
          ,i.TARGET_WINDOW_TYPE
          ,i.TARGET_WINDOW_NAME
          ,i.TARGET_EXPL_NODE_ID
          ,i.URL_PROPERTY_ID
          ,i.PROC_PAGE_TEMPL_UI_DEF_ID
          ,i.PAGE_TITLE_TEXT_ID
          ,i.MAIN_MESSAGE_TEXT_ID
          ,i.PROCESSING_CAPTION_TEXT_ID
          ,i.PROCESSING_PAGE_TEMPL_ID
          );

Line: 5632


              FOR k IN(SELECT * FROM CZ_LOCALIZED_TEXTS
                       WHERE intl_text_id=l_id AND seeded_flag=G_NO_FLAG
                              AND deleted_flag=G_NO_FLAG)
              LOOP
                IF l_new_intl_text_id IS NULL THEN
                  l_new_intl_text_id := allocateId('CZ_INTL_TEXTS_S');

Line: 5639


                INSERT INTO CZ_LOCALIZED_TEXTS
                (
                LOCALE_ID
                ,LOCALIZED_STR
                ,INTL_TEXT_ID
                ,DELETED_FLAG
                ,EFF_FROM
                ,EFF_TO
                ,SECURITY_MASK
                ,EFF_MASK
                ,CHECKOUT_USER
                ,ORIG_SYS_REF
                ,LANGUAGE
                ,SOURCE_LANG
                ,UI_DEF_ID
                ,MODEL_ID
                ,SEEDED_FLAG
                ,UI_PAGE_ID
                ,UI_PAGE_ELEMENT_ID
                )
                VALUES(
                k.LOCALE_ID
                ,k.LOCALIZED_STR
                ,l_new_intl_text_id
                ,k.DELETED_FLAG
                ,k.EFF_FROM
                ,k.EFF_TO
                ,k.SECURITY_MASK
                ,k.EFF_MASK
                ,k.CHECKOUT_USER
                ,k.ORIG_SYS_REF
                ,k.LANGUAGE
                ,k.SOURCE_LANG
                ,p_target_ui_def_id
                ,l_ui_def_node.devl_project_id
                ,'0'
                ,p_target_ui_page_id
                ,p_new_element_id
                );

Line: 5718


        INSERT INTO CZ_UI_TEMPLATE_ELEMENTS
        (
        TEMPLATE_ID
        ,UI_DEF_ID
        ,ELEMENT_TYPE
        ,ELEMENT_ID
        ,PERSISTENT_ELEMENT_ID
        ,DELETED_FLAG
        ,SEEDED_FLAG
        )
        SELECT
         p_target_template_id
        ,p_target_ui_def_id
        ,ELEMENT_TYPE
        ,l_cached_elems_tbl(i)
        ,l_cached_elems_tbl(i)
        ,G_NO_FLAG
        ,G_NO_FLAG
        FROM CZ_UI_TEMPLATE_ELEMENTS
        WHERE template_id=p_source_template_id AND
              ui_def_id=p_source_ui_def_id AND
              element_id=l_cached_source_elems_tbl(i) AND
              deleted_flag=G_NO_FLAG;

Line: 5782


      FOR i IN(SELECT * FROM CZ_UI_ACTIONS
                WHERE ui_action_id=l_id AND
                      ui_def_id=p_source_ui_def_id AND
                      source_page_id=0 AND
                      seeded_flag=G_NO_FLAG)
      LOOP

          l_new_action_id := allocateId('CZ_UI_ACTIONS_S');

Line: 5791


          INSERT INTO CZ_UI_ACTIONS
          (
          UI_ACTION_ID
          ,UI_DEF_ID
          ,SOURCE_PAGE_ID
          ,CONTEXT_COMPONENT_ID
          ,ELEMENT_ID
          ,RENDER_CONDITION_ID
          ,UI_ACTION_TYPE
          ,TARGET_UI_DEF_ID
          ,TARGET_PERSISTENT_NODE_ID
          ,TARGET_NODE_PATH
          ,TARGET_PAGE_SET_ID
          ,TARGET_PAGE_ID
          ,TARGET_URL
          ,FRAME_NAME
          ,TARGET_ANCHOR
          ,DELETED_FLAG
          ,SEEDED_FLAG
          ,CX_COMMAND_NAME
          ,WINDOW_PARAMETERS
          ,TARGET_WINDOW_TYPE
          ,TARGET_WINDOW_NAME
          ,TARGET_EXPL_NODE_ID
          ,URL_PROPERTY_ID
          ,PROC_PAGE_TEMPL_UI_DEF_ID
          ,PAGE_TITLE_TEXT_ID
          ,MAIN_MESSAGE_TEXT_ID
          ,PROCESSING_CAPTION_TEXT_ID
          ,PROCESSING_PAGE_TEMPL_ID
          )
          VALUES(
          l_new_action_id
          ,p_target_ui_def_id
          ,0
          ,i.CONTEXT_COMPONENT_ID
          ,p_new_element_id
          ,i.RENDER_CONDITION_ID
          ,i.UI_ACTION_TYPE
          ,i.TARGET_UI_DEF_ID
          ,i.TARGET_PERSISTENT_NODE_ID
          ,i.TARGET_NODE_PATH
          ,i.TARGET_PAGE_SET_ID
          ,i.TARGET_PAGE_ID
          ,i.TARGET_URL
          ,i.FRAME_NAME
          ,i.TARGET_ANCHOR
          ,i.DELETED_FLAG
          ,'0'
          ,i.CX_COMMAND_NAME
          ,i.WINDOW_PARAMETERS
          ,i.TARGET_WINDOW_TYPE
          ,i.TARGET_WINDOW_NAME
          ,i.TARGET_EXPL_NODE_ID
          ,i.URL_PROPERTY_ID
          ,i.PROC_PAGE_TEMPL_UI_DEF_ID
          ,i.PAGE_TITLE_TEXT_ID
          ,i.MAIN_MESSAGE_TEXT_ID
          ,i.PROCESSING_CAPTION_TEXT_ID
          ,i.PROCESSING_PAGE_TEMPL_ID
          );

Line: 5903


              FOR k IN(SELECT * FROM CZ_LOCALIZED_TEXTS
                       WHERE intl_text_id=l_id AND seeded_flag=G_NO_FLAG
                              AND deleted_flag=G_NO_FLAG)
              LOOP
                IF l_new_intl_text_id IS NULL THEN
                  l_new_intl_text_id := allocateId('CZ_INTL_TEXTS_S');

Line: 5910


                INSERT INTO CZ_LOCALIZED_TEXTS
                (
                LOCALE_ID
                ,LOCALIZED_STR
                ,INTL_TEXT_ID
                ,DELETED_FLAG
                ,EFF_FROM
                ,EFF_TO
                ,SECURITY_MASK
                ,EFF_MASK
                ,CHECKOUT_USER
                ,ORIG_SYS_REF
                ,LANGUAGE
                ,SOURCE_LANG
                ,UI_DEF_ID
                ,MODEL_ID
                ,SEEDED_FLAG
                ,UI_PAGE_ID
                ,UI_PAGE_ELEMENT_ID
                )
                VALUES(
                k.LOCALE_ID
                ,k.LOCALIZED_STR
                ,l_new_intl_text_id
                ,k.DELETED_FLAG
                ,k.EFF_FROM
                ,k.EFF_TO
                ,k.SECURITY_MASK
                ,k.EFF_MASK
                ,k.CHECKOUT_USER
                ,k.ORIG_SYS_REF
                ,k.LANGUAGE
                ,k.SOURCE_LANG
                ,p_target_ui_def_id
                ,NVL(k.model_id,0)
                ,'0'
                ,0
                ,p_new_element_id
                );

Line: 5970


        INSERT INTO CZ_UI_TEMPLATE_ELEMENTS
        (
        TEMPLATE_ID
        ,UI_DEF_ID
        ,ELEMENT_TYPE
        ,ELEMENT_ID
        ,PERSISTENT_ELEMENT_ID
        ,DELETED_FLAG
        ,SEEDED_FLAG
        )
        SELECT
         p_target_template_id
        ,p_target_ui_def_id
        ,ELEMENT_TYPE
        ,l_cached_elems_tbl(i)
        ,l_cached_elems_tbl(i)
        ,G_NO_FLAG
        ,G_NO_FLAG
        FROM CZ_UI_TEMPLATE_ELEMENTS
        WHERE template_id=p_source_template_id AND
              ui_def_id=p_source_ui_def_id AND
              element_id=l_cached_source_elems_tbl(i) AND
              deleted_flag=G_NO_FLAG;

Line: 6168


  FUNCTION insert_before(p_parent_xml_node  IN xmldom.DOMNode,
                         p_new_xml_node     IN xmldom.DOMNode,
             p_ref_xml_node     IN xmldom.DOMNode)
    RETURN xmldom.DOMNode IS
  l_new_xml_node xmldom.DOMNode;

Line: 6178


    l_new_xml_node := xmldom.insertBefore(p_parent_xml_node, p_new_xml_node, p_ref_xml_node);

Line: 6182


  END insert_before;

Line: 6184


  FUNCTION insert_node(p_ui_node             IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
                       p_new_xml_node        IN xmldom.DOMNode,
                       p_parent_xml_node     IN xmldom.DOMNode)
   RETURN xmldom.DOMNode IS

  l_node                  CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

Line: 6246


      SELECT element_id, ctrl_template_id INTO l_prev_element_id, l_prev_element_template_id
      FROM CZ_UI_PAGE_ELEMENTS
      WHERE ui_def_id=p_ui_node.ui_def_id AND
            page_id = p_ui_node.page_id AND
            parent_element_id = p_ui_node.parent_element_id AND
            deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG) AND
            seq_nbr = (SELECT max(seq_nbr)
                       FROM CZ_UI_PAGE_ELEMENTS
                       WHERE ui_def_id=p_ui_node.ui_def_id AND
                             page_id = p_ui_node.page_id AND
                             parent_element_id = p_ui_node.parent_element_id AND
                             seq_nbr


Line: 6272

      SELECT element_id, ctrl_template_id INTO l_next_element_id, l_next_element_template_id
      FROM CZ_UI_PAGE_ELEMENTS
      WHERE ui_def_id=p_ui_node.ui_def_id AND
            page_id = p_ui_node.page_id AND
            parent_element_id = p_ui_node.parent_element_id AND
            deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG, G_MARK_TO_DELETE) AND
            seq_nbr = ( SELECT min(seq_nbr)
                        FROM CZ_UI_PAGE_ELEMENTS
                        WHERE ui_def_id=p_ui_node.ui_def_id AND
                              page_id = p_ui_node.page_id AND
                              parent_element_id = p_ui_node.parent_element_id AND
                              seq_nbr>p_ui_node.seq_nbr AND
                              deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG, G_MARK_TO_DELETE, G_MARK_TO_ADD, G_MARK_TO_MOVE) AND
                              NOT (element_type = G_UI_DRILLDOWN_NODE_TYPE AND
                                   ctrl_template_id IS NULL) AND
                              NOT (element_signature_id IS NULL AND ctrl_template_id IS NULL))
            AND rownum < 2;

Line: 6303

        SELECT layout_ui_style INTO l_prev_elt_lyt_ui_style
      FROM CZ_UI_TEMPLATES
      WHERE template_id = l_prev_element_template_id
      AND ui_def_id = 0
    AND deleted_flag = G_NO_FLAG;

Line: 6322

        SELECT layout_ui_style INTO l_next_elt_lyt_ui_style
      FROM CZ_UI_TEMPLATES
      WHERE template_id = l_next_element_template_id
      AND ui_def_id = 0
    AND deleted_flag = G_NO_FLAG;

Line: 6338

    SELECT layout_ui_style INTO l_lyt_ui_style
  FROM CZ_UI_TEMPLATES
  WHERE template_id = p_ui_node.ctrl_template_id
    AND ui_def_id = 0
    AND deleted_flag = G_NO_FLAG;

Line: 6359

        l_new_xml_root_node := insert_before(l_prev_node_parent_ui_cnt, l_new_xml_root_node, l_next_node);

Line: 6362

          l_new_xml_root_node := insert_before(l_next_node_parent_ui_cnt, l_new_xml_root_node, l_next_node);

Line: 6368

            l_xml_table_node := insert_before(l_prev_node_parent_ui_cnt, l_xml_table_node, l_next_node);

Line: 6370

            l_xml_table_node := insert_before(l_next_node_parent_ui_cnt, l_xml_table_node, l_next_node);

Line: 6388

              l_xml_table_node := insert_before(l_grand_parent, l_xml_table_node, l_next_sibling_of_parent);

Line: 6393

            l_next_node := xmldom.insertBefore(l_grand_parent, l_new_xml_root_node, l_next_node);

Line: 6397

            l_new_xml_root_node := insert_before(l_grand_parent, l_new_xml_root_node, l_next_sibling_of_parent);

Line: 6401

          l_new_xml_root_node := insert_before(l_prev_node_parent_ui_cnt, l_new_xml_root_node, l_next_node);

Line: 6404

          l_new_xml_root_node := insert_before(l_next_node_parent_ui_cnt, l_new_xml_root_node, l_next_node);

Line: 6408

          l_new_xml_root_node := insert_before(l_grand_parent, l_new_xml_root_node, l_next_sibling_of_parent);

Line: 6411

          l_new_xml_root_node := insert_before(l_grand_parent, l_new_xml_root_node, l_next_node_parent);

Line: 6433

  END insert_node;

Line: 6489

  SELECT jrad_doc INTO l_jrad_doc
    FROM CZ_UI_PAGES
    WHERE ui_def_id= g_UI_Context.ui_def_id AND
          page_id=l_src_page_id;

Line: 6501

  SELECT ps_node_id INTO l_component_id
    FROM CZ_PS_NODES
   WHERE devl_project_id = g_UI_Context.devl_project_id
     AND persistent_node_Id = p_ui_node.pagebase_persistent_node_id;

Line: 6506

  SELECT ps_node_id INTO l_old_component_id
    FROM CZ_PS_NODES
   WHERE devl_project_id = g_UI_Context.devl_project_id
     AND persistent_node_id = (SELECT persistent_node_id
                                 FROM CZ_UI_PAGES
                                WHERE ui_def_id = g_UI_Context.ui_Def_id
                                  AND page_id = l_src_page_id);

Line: 6516

  FOR i in (SELECT rule_id, ui_page_element_id
              FROM CZ_RULES
             WHERE devl_project_id = g_UI_Context.devl_project_id
               AND ui_def_id = g_UI_Context.ui_def_id
               AND ui_page_id = l_src_page_id
               AND component_id = l_old_component_id
               AND deleted_flag = G_NO_FLAG)
  LOOP
    DEBUG('asp: Found rule ' || i.rule_id || ', for element ' || i.ui_page_element_Id);

Line: 6527

      UPDATE CZ_RULES
         SET component_id = l_component_id,
             ui_page_id = p_ui_node.page_id
       WHERE devl_project_id = g_UI_Context.devl_project_id
         AND rule_id = i.rule_id;

Line: 6535

  FOR i in (SELECT intl_text_id, ui_page_element_id
              FROM CZ_INTL_TEXTS
             WHERE model_id = g_UI_Context.devl_project_id
               AND ui_def_id = g_UI_Context.ui_def_id
               AND ui_page_id = l_src_page_id
               AND deleted_flag = G_NO_FLAG)
  LOOP
    IF l_element_ids_tbl.EXISTS(i.ui_page_element_id) THEN
      DEBUG('asp: Updating intl_text ' || i.intl_text_id || ' for element_id ' || i.ui_page_element_id);

Line: 6544

      UPDATE CZ_LOCALIZED_TEXTS
         SET ui_page_id = p_ui_node.page_id
       WHERE intl_text_id = i.intl_text_id;

Line: 6549

  l_xml_node_to_move := insert_node(p_ui_node, l_xml_node_to_move, p_parent_xml_node);

Line: 6663

      SELECT element_id, ctrl_template_id INTO l_prev_element_id, l_prev_element_template_id
      FROM CZ_UI_PAGE_ELEMENTS
      WHERE ui_def_id=p_ui_node.ui_def_id AND
            page_id = p_ui_node.page_id AND
            parent_element_id = p_ui_node.parent_element_id AND
            deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG) AND
--jonatara:bug fix7307460
     	    NOT (element_type = G_UI_DRILLDOWN_NODE_TYPE AND ctrl_template_id IS NULL) AND
     	    NOT (element_signature_id IS NULL AND ctrl_template_id IS NULL ) AND
            seq_nbr = (SELECT max(seq_nbr)
                       FROM CZ_UI_PAGE_ELEMENTS
                       WHERE ui_def_id=p_ui_node.ui_def_id AND
                             page_id = p_ui_node.page_id AND
                             parent_element_id = p_ui_node.parent_element_id AND
                             seq_nbr

Line: 6691

      SELECT element_id, ctrl_template_id INTO l_next_element_id, l_next_element_template_id
      FROM CZ_UI_PAGE_ELEMENTS
      WHERE ui_def_id=p_ui_node.ui_def_id AND
            page_id = p_ui_node.page_id AND
            parent_element_id = p_ui_node.parent_element_id AND
            deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG, G_MARK_TO_DELETE) AND
--jonatara:bug fix7307460
	    NOT (element_type = G_UI_DRILLDOWN_NODE_TYPE AND ctrl_template_id IS NULL) AND
	    NOT (element_signature_id IS NULL AND ctrl_template_id IS NULL) AND
            seq_nbr = ( SELECT min(seq_nbr)
                        FROM CZ_UI_PAGE_ELEMENTS
                        WHERE ui_def_id=p_ui_node.ui_def_id AND
                              page_id = p_ui_node.page_id AND
                              parent_element_id = p_ui_node.parent_element_id AND
                              seq_nbr>p_ui_node.seq_nbr AND
                              deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG, G_MARK_TO_DELETE, G_MARK_TO_ADD, G_MARK_TO_MOVE) AND
                              NOT (element_type = G_UI_DRILLDOWN_NODE_TYPE AND
                                   ctrl_template_id IS NULL) AND
                              NOT (element_signature_id IS NULL AND ctrl_template_id IS NULL))
            AND rownum < 2;

Line: 6855

              SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES
              WHERE page_id=p_ui_node.page_id AND ui_def_id=p_ui_node.ui_def_id;

Line: 7009

        SELECT layout_ui_style INTO l_prev_elt_lyt_ui_style
      FROM CZ_UI_TEMPLATES
      WHERE template_id = l_prev_element_template_id
      AND ui_def_id = 0
    AND deleted_flag = G_NO_FLAG;

Line: 7031

        SELECT layout_ui_style INTO l_next_elt_lyt_ui_style
        FROM CZ_UI_TEMPLATES
        WHERE template_id = l_next_element_template_id
        AND ui_def_id = 0
        AND deleted_flag = G_NO_FLAG;

Line: 7093

        l_new_xml_root_node := insert_before(l_prev_node_parent_ui_cnt, l_new_xml_root_node, l_next_node);

Line: 7096

          l_new_xml_root_node := insert_before(l_next_node_parent_ui_cnt, l_new_xml_root_node, l_next_node);

Line: 7102

            l_xml_table_node := insert_before(l_prev_node_parent_ui_cnt, l_xml_table_node, l_next_node);

Line: 7104

            l_xml_table_node := insert_before(l_next_node_parent_ui_cnt, l_xml_table_node, l_next_node);

Line: 7122

              l_xml_table_node := insert_before(l_grand_parent, l_xml_table_node, l_next_sibling_of_parent);

Line: 7127

            l_next_node := xmldom.insertBefore(l_grand_parent, l_new_xml_root_node, l_next_node);

Line: 7131

            l_new_xml_root_node := insert_before(l_grand_parent, l_new_xml_root_node, l_next_sibling_of_parent);

Line: 7135

          l_new_xml_root_node := insert_before(l_prev_node_parent_ui_cnt, l_new_xml_root_node, l_next_node);

Line: 7138

          l_new_xml_root_node := insert_before(l_next_node_parent_ui_cnt, l_new_xml_root_node, l_next_node);

Line: 7142

          l_new_xml_root_node := insert_before(l_grand_parent, l_new_xml_root_node, l_next_sibling_of_parent);

Line: 7145

          l_new_xml_root_node := insert_before(l_grand_parent, l_new_xml_root_node, l_next_node_parent);

Line: 7239

      SELECT element_id INTO l_prev_element_id
        FROM CZ_UI_PAGE_ELEMENTS
       WHERE ui_def_id=p_ui_node.ui_def_id AND
             parent_persistent_node_id=p_ui_node.parent_persistent_node_id AND
             seq_nbr=p_ui_node.seq_nbr-1 AND
             deleted_flag<>G_YES_FLAG;

Line: 7502

              SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES
              WHERE page_id=p_ui_node.page_id AND ui_def_id=p_ui_node.ui_def_id;

Line: 8091

      g_dom_elements_tbl.DELETE(TO_NUMBER(p_ui_node.element_id));

Line: 8137

        SELECT model_ref_expl_id INTO l_ui_node_expl_id FROM CZ_UI_PAGE_ELEMENTS
         WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=p_ui_page_id AND element_id=p_ui_element_id;

Line: 8170

        FOR i IN(SELECT target_persistent_node_id,target_expl_node_id FROM CZ_UI_ACTIONS
                 WHERE ui_def_id=g_UI_Context.ui_def_id AND
                       source_page_id=p_ui_page_id AND
                       element_id=p_ui_element_id AND
                       target_node_path IS NOT NULL AND
                       deleted_flag=G_NO_FLAG)
        LOOP
          l_new_model_path := get_Runtime_Relative_Path(p_model_id             => g_UI_Context.devl_project_id,
                                                        p_persistent_node_id   => i.target_persistent_node_id,
                                                        p_page_id              => p_ui_page_id,
                                                        p_ui_node_expl_id      => i.target_expl_node_id);

Line: 8183

            UPDATE CZ_UI_ACTIONS
               SET target_node_path=l_new_model_path
             WHERE ui_def_id=g_UI_Context.ui_def_id AND
                   source_page_id=p_ui_page_id AND
                   element_id=p_ui_element_id AND
                   target_node_path<>l_new_model_path;

Line: 8225

             SELECT persistent_node_id INTO l_persistent_node_id FROM CZ_UI_PAGE_ELEMENTS
             WHERE ui_def_id=g_UI_Context.ui_def_id AND
                   page_id=p_page_id AND
                   element_id=l_element_id;

Line: 8309

      l_attr_tbl.DELETE;

Line: 8417

          l_attr_tbl.DELETE;

Line: 8454

            l_attr_tbl.DELETE;

Line: 8486

    SELECT ISO_LANGUAGE||'-'||
           ISO_TERRITORY
      INTO l_lang
      FROM FND_LANGUAGES_VL
     WHERE language_code=USERENV('LANG');

Line: 8589

    SELECT root_element_signature_id
      INTO g_DRILLDOWN_ELEM_SIGNATURE_ID
      FROM CZ_UI_TEMPLATES
     WHERE template_id=g_DRILLDOWN_TEMPLATE_ID AND
           ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID AND
           deleted_flag=G_NO_FLAG;

Line: 8599

      SELECT root_element_signature_id
        INTO g_DRILLDOWN_B_SIGNATURE_ID
        FROM CZ_UI_TEMPLATES
       WHERE ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID AND
             template_id=G_DRILLDOWN_BUTTON_TEMPLATE_ID AND
             deleted_flag=G_NO_FLAG;

Line: 8607

    SELECT TEMPLATE_TOKEN INTO G_CAPTION_RULE_TOKENNAME FROM CZ_RULES
    WHERE rule_id=G_DEFAULT_CAPTION_RULE_ID;

Line: 8711

    SELECT COUNT(ui_def_id) + 1
      INTO g_UI_Context.tree_seq
      FROM CZ_UI_DEFS
     WHERE component_id = p_model_id AND
           deleted_flag = G_NO_FLAG;

Line: 8718

      SELECT NAME || ' User Interface (' || TO_CHAR(g_UI_Context.tree_seq) || ')'
        INTO g_UI_Context.NAME
        FROM CZ_DEVL_PROJECTS
       WHERE devl_project_id = p_model_id;

Line: 8733

    INSERT INTO CZ_UI_DEFS
      (UI_DEF_ID,
       DESC_TEXT,
       NAME,
       DEVL_PROJECT_ID,
       COMPONENT_ID,
       TREE_SEQ,
       UI_STYLE,
       GEN_VERSION,
       TREENODE_DISPLAY_SOURCE,
       GEN_HEADER,
       LOOK_AND_FEEL,
       CONTROLS_PER_SCREEN,
       PRIMARY_NAVIGATION,
       PERSISTENT_UI_DEF_ID,
       MODEL_TIMESTAMP,
       UI_STATUS,
       PAGE_SET_ID,
       START_PAGE_ID,
       ERR_RUN_ID,
       START_URL,
       PAGE_LAYOUT,
       PRICE_UPDATE,
       SEEDED_FLAG,
       MASTER_TEMPLATE_FLAG,
       PRICE_DISPLAY,
       FROM_MASTER_TEMPLATE_ID,
       PAGIN_MAXCONTROLS,
       PAGIN_NONINST,
       PAGIN_NONINST_REFCOMP,
       CONTROL_LAYOUT,
       PAGIN_DRILLDOWNCTRL,
       OUTER_TEMPLATE_USAGE,
       PAGIN_BOMOC,
       BOMUI_LAYOUT,
       BOMQTYINPUTCTRLS,
       CTRLTEMPLUSE_BOM,
       CTRLTEMPLUSE_NONBOM,
       NONBOM_UILAYOUT,
       CTRLTEMPLUSE_COMMON,
       CTRLTEMPLUSE_REQDMSG,
       CTRLTEMPLUSE_OPTMSG,
       MENU_CAPTION_RULE_ID,
       PAGE_CAPTION_RULE_ID,
       PRESERVE_MODEL_HIERARCHY,
       EMPTY_UI_FLAG,
       SHOW_TRAIN,
       PAGINATION_SLOT,
       DRILLDOWN_CONTROL_TEXT_ID,
       DRILLDOWN_IMAGE_URL,
       ROWS_PER_TABLE,
       CTRLTEMPLATEUSE_BUTTONBAR,
       CTRLTEMPLATEUSE_UTILITYPAGE,
       OPTION_SORT_SELECT_FIRST,
       OPTION_SORT_ORDER,
       OPTION_SORT_METHOD,
       SHOW_ALL_NODES_FLAG,
       PAGE_STATUS_TEMPLATE_USAGE,
       suppress_refresh_flag,
       DELETED_FLAG,
       UI_TIMESTAMP_REFRESH,
       DRILLDOWN_TX_TYPE,
       CONTENT_LAST_UPDATE_DATE,
       DISABLE_AUTOOVERRIDE_FLAG
      )
      SELECT g_UI_Context.ui_def_id,
             g_UI_Context.desc_text,
             g_UI_Context.NAME,
             g_UI_Context.devl_project_id,
             g_UI_Context.component_id,
             g_UI_Context.tree_seq,
             g_UI_Context.ui_style,
             G_GEN_VERSION,
             TREENODE_DISPLAY_SOURCE,
             G_GEN_HEADER,
             LOOK_AND_FEEL,
             CONTROLS_PER_SCREEN,
             PRIMARY_NAVIGATION,
             g_UI_Context.persistent_ui_def_id,
             g_UI_Context.model_timestamp,
             g_UI_Context.ui_status,
             g_UI_Context.page_set_id,
             g_UI_Context.start_page_id,
             g_UI_Context.err_run_id,
             g_UI_Context.start_url,
             g_UI_Context.page_layout,
             G_DEFAULT_PRICE_UPDATE,
             '0',
             '0',
             G_DEFAULT_PRICE_DISPLAY,
             g_UI_Context.from_master_template_id,
             PAGIN_MAXCONTROLS,
             PAGIN_NONINST,
             PAGIN_NONINST_REFCOMP,
             CONTROL_LAYOUT,
             PAGIN_DRILLDOWNCTRL,
             OUTER_TEMPLATE_USAGE,
             PAGIN_BOMOC,
             BOMUI_LAYOUT,
             BOMQTYINPUTCTRLS,
             CTRLTEMPLUSE_BOM,
             CTRLTEMPLUSE_NONBOM,
             NONBOM_UILAYOUT,
             CTRLTEMPLUSE_COMMON,
             CTRLTEMPLUSE_REQDMSG,
             CTRLTEMPLUSE_OPTMSG,
             MENU_CAPTION_RULE_ID,
             PAGE_CAPTION_RULE_ID,
             PRESERVE_MODEL_HIERARCHY,
             NVL(p_create_empty_ui, G_NO_FLAG),
             SHOW_TRAIN,
             PAGINATION_SLOT,
             DRILLDOWN_CONTROL_TEXT_ID,
             DRILLDOWN_IMAGE_URL,
             ROWS_PER_TABLE,
             CTRLTEMPLATEUSE_BUTTONBAR,
             CTRLTEMPLATEUSE_UTILITYPAGE,
             OPTION_SORT_SELECT_FIRST,
             OPTION_SORT_ORDER,
             OPTION_SORT_METHOD,
             p_show_all_nodes,
             PAGE_STATUS_TEMPLATE_USAGE,
             g_UI_Context.suppress_refresh_flag,
             DELETED_FLAG,
             SYSDATE,
             DRILLDOWN_TX_TYPE,
             CONTENT_LAST_UPDATE_DATE,
             DISABLE_AUTOOVERRIDE_FLAG
    FROM CZ_UI_DEFS
    WHERE ui_def_id = g_UI_Context.from_master_template_id;

Line: 8880

    UPDATE CZ_UI_DEFS
       SET start_page_id=g_UI_Context.start_page_id,
           page_set_id=g_UI_Context.page_set_id
     WHERE ui_def_id=g_UI_Context.ui_def_id;

Line: 8902

    SELECT *
      INTO l_target_ui_def_node
      FROM CZ_UI_DEFS
     WHERE ui_def_id = (SELECT MAX(ui_def_id)
                          FROM CZ_UI_DEFS
                         WHERE devl_project_id = p_reference_id AND
                               ui_status IN (G_PROCESSED_UI_STATUS,G_NEW_UI_STATUS) AND
                               deleted_flag = G_NO_FLAG);

Line: 8956

    SELECT persistent_node_id INTO l_page_persistent_node_id
    FROM CZ_UI_PAGES
    WHERE page_id=p_page_id AND ui_def_id=g_UI_Context.ui_def_id;

Line: 8960

    FOR i IN (SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
              WHERE ui_def_id=g_UI_Context.ui_def_id AND
                    page_id IN(SELECT page_id FROM CZ_UI_PAGES
                    WHERE ui_def_id=g_UI_Context.ui_def_id AND
                    persistent_node_id=l_page_persistent_node_id AND deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE)) AND
                    element_type=G_UI_CX_BUTTON_NODE_TYPE AND
                    persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
                    WHERE ps_node_id=p_component_id)
                    AND deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE))
   LOOP
     FOR k IN(SELECT ui_action_id FROM CZ_UI_ACTIONS
              WHERE ui_def_id=g_UI_Context.ui_def_id AND element_id=i.element_id AND
                    cx_command_name=p_command_name AND deleted_flag=G_NO_FLAG)
     LOOP
       RETURN i.element_id;

Line: 9007

    FOR i IN(SELECT DISTINCT b.data_value, b.expr_node_id, a.INSTANTIATION_SCOPE, a.name
             FROM CZ_RULES a, CZ_EXPRESSION_NODES b
             WHERE a.devl_project_id=p_node.devl_project_id AND
                   a.component_id=p_node.ps_node_id AND
                   a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
                   a.deleted_flag=G_NO_FLAG AND
                   a.disabled_flag=G_NO_FLAG AND
                   a.invalid_flag=G_NO_FLAG AND
                   b.rule_id=a.rule_id AND
                   b.deleted_flag=G_NO_FLAG AND
                   b.argument_signature_id=G_EVENT_ON_COMMAND_SIGID AND
                   data_value IS NOT NULL)
    LOOP
      -- do not create a CX for instantiable reference with
      -- instantiation_scope= INSTANCE
      IF p_node.ps_node_type=G_REFERENCE_TYPE AND
         p_node.instantiable_flag NOT IN(G_MANDATORY_INST_TYPE) AND
         i.INSTANTIATION_SCOPE=1 THEN
         add_Error_Message(p_message_name => 'CZ_CX_IS_IN_WRONG_SCOPE',
                            p_token_name1  => 'EVENT_NAME',
                            p_token_value1 => i.data_value,
                            p_token_name2  => 'RULE_NAME',
                            p_token_value2 => i.name,
                            p_fatal_error  => FALSE);

Line: 9037

        INSERT INTO CZ_INTL_TEXTS
           (INTL_TEXT_ID,
            TEXT_STR,
            DELETED_FLAG,
            SEEDED_FLAG,
            UI_DEF_ID,
            MODEL_ID,
            UI_PAGE_ID,
            UI_PAGE_ELEMENT_ID
            )
        VALUES
           (l_ui_intl_text_id,
            i.data_value,
            G_NO_FLAG,
            G_NO_FLAG,
            g_UI_Context.ui_def_id,
            g_UI_Context.devl_project_id,
            p_ui_node.page_id,
            l_element_id
           );

Line: 9066

        SELECT COUNT(element_id)+1 INTO l_counter FROM CZ_UI_PAGE_ELEMENTS
        WHERE ui_def_id=g_UI_Context.ui_def_id AND
              page_id=p_ui_node.page_id AND
              ctrl_template_id=G_DRILLDOWN_BUTTON_TEMPLATE_ID AND
             deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 9074

       INSERT INTO CZ_UI_PAGE_ELEMENTS
         (ui_def_id,
         persistent_node_id,
         parent_persistent_node_id,
         region_persistent_node_id,
         pagebase_persistent_node_id,
         page_id,
         base_page_flag,
         seq_nbr,
         ctrl_template_id,
         ctrl_template_ui_def_id,
         element_id,
         parent_element_id,
         element_type,
         instantiable_flag,
         model_ref_expl_id,
         element_signature_id,
         name,
         deleted_flag)
       VALUES
        (p_ui_node.ui_def_id,
         p_node.persistent_node_id,
         p_node.parent_persistent_node_id,
         p_ui_node.region_persistent_node_id,
         p_ui_node.pagebase_persistent_node_id,
         p_ui_node.page_id,
         NULL,
         p_ui_node.seq_nbr+1,
         G_DRILLDOWN_BUTTON_TEMPLATE_ID,
         G_GLOBAL_TEMPLATES_UI_DEF_ID,
         l_element_id,
         l_parent_element_id,
         G_UI_CX_BUTTON_NODE_TYPE,
         NULL,
         p_ui_node.model_ref_expl_id,
         g_DRILLDOWN_B_SIGNATURE_ID,
         l_name,
         G_MARK_TO_ADD);

Line: 9115

         INSERT INTO CZ_UI_ACTIONS
         (
         ui_action_id
         ,ui_def_id
         ,source_page_id
         ,context_component_id
         ,element_id
         ,render_condition_id
         ,ui_action_type
         ,target_ui_def_id
         ,target_persistent_node_id
         ,target_node_path
         ,target_page_set_id
         ,target_page_id
         ,target_url
         ,frame_name
         ,target_anchor
         ,seeded_flag
         ,cx_command_name
         ,window_parameters
         ,target_window_type
         ,target_window_name
         ,target_expl_node_id
         ,deleted_flag
         )
         VALUES
         (
         l_ui_action_id
         ,p_ui_node.ui_def_id
         ,p_ui_node.page_id
         ,p_node.persistent_node_id
         ,l_element_id
         ,NULL
         ,G_CX_BUTTON_ACTION_TYPE
         ,NULL
         ,NULL
         ,NULL
         ,NULL
         ,NULL
         ,NULL
         ,NULL
         ,NULL
         ,'0'
         ,i.data_value
         ,NULL
         ,NULL
         ,NULL
         ,NULL
         ,G_NO_FLAG
         );

Line: 9172

    FOR i IN(SELECT a.model_ref_expl_id, b.data_value, a.component_id, b.expr_node_id, a.name, a.INSTANTIATION_SCOPE
             FROM CZ_RULES a, CZ_EXPRESSION_NODES b
             WHERE a.devl_project_id=p_node.devl_project_id AND
                   a.component_id IN
               (SELECT ps_node_id FROM CZ_PS_NODES
                WHERE devl_project_id IN
                (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS
                START WITH model_id=p_node.devl_project_id AND
                           referring_node_id=p_node.ps_node_id AND
                           deleted_flag='0'
                CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND
                         deleted_flag='0' AND PRIOR deleted_flag='0') AND
                deleted_flag='0') AND
                   a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
                   a.deleted_flag=G_NO_FLAG AND
                   a.disabled_flag=G_NO_FLAG AND
                   a.invalid_flag=G_NO_FLAG AND
                   b.rule_id=a.rule_id AND
                   b.deleted_flag=G_NO_FLAG AND
                   b.argument_signature_id=G_EVENT_ON_COMMAND_SIGID AND
                   data_value IS NOT NULL)
      LOOP

        -- do not create a CX for instantiable reference with
        -- instantiation_scope= INSTANCE
        IF p_node.ps_node_type=G_REFERENCE_TYPE AND
           p_node.instantiable_flag NOT IN(G_MANDATORY_INST_TYPE) AND
           i.INSTANTIATION_SCOPE=1 THEN
          add_Error_Message(p_message_name => 'CZ_CX_IS_IN_WRONG_SCOPE',
                            p_token_name1  => 'EVENT_NAME',
                            p_token_value1 => i.data_value,
                            p_token_name2  => 'RULE_NAME',
                            p_token_value2 => i.name,
                            p_fatal_error  => FALSE);

Line: 9213

          INSERT INTO CZ_INTL_TEXTS
           (INTL_TEXT_ID,
            TEXT_STR,
            DELETED_FLAG,
            SEEDED_FLAG,
            UI_DEF_ID,
            MODEL_ID,
            UI_PAGE_ID,
            UI_PAGE_ELEMENT_ID)
          VALUES
           (l_ui_intl_text_id,
            i.data_value,
            G_NO_FLAG,
            G_NO_FLAG,
            g_UI_Context.ui_def_id,
            g_UI_Context.devl_project_id,
            p_ui_node.page_id,
            l_element_id
           );

Line: 9242

          INSERT INTO CZ_UI_PAGE_ELEMENTS
         (ui_def_id,
         persistent_node_id,
         parent_persistent_node_id,
         region_persistent_node_id,
         pagebase_persistent_node_id,
         page_id,
         base_page_flag,
         seq_nbr,
         ctrl_template_id,
         ctrl_template_ui_def_id,
         element_id,
         parent_element_id,
         element_type,
         instantiable_flag,
         model_ref_expl_id,
         element_signature_id,
         name,
         deleted_flag)
       VALUES
        (p_ui_node.ui_def_id,
         p_node.persistent_node_id,
         p_node.parent_persistent_node_id,
         p_ui_node.region_persistent_node_id,
         p_ui_node.pagebase_persistent_node_id,
         p_ui_node.page_id,
         NULL,
         p_ui_node.seq_nbr+1,
         G_DRILLDOWN_BUTTON_TEMPLATE_ID,
         G_GLOBAL_TEMPLATES_UI_DEF_ID,
         l_element_id,
         l_parent_element_id,
         G_UI_CX_BUTTON_NODE_TYPE,
         NULL,
         p_ui_node.model_ref_expl_id,
         g_DRILLDOWN_B_SIGNATURE_ID,
         'Button - '||i.data_value,
         G_MARK_TO_ADD);

Line: 9283

         INSERT INTO CZ_UI_ACTIONS
         (
         ui_action_id
         ,ui_def_id
         ,source_page_id
         ,context_component_id
         ,element_id
         ,render_condition_id
         ,ui_action_type
         ,target_ui_def_id
         ,target_persistent_node_id
         ,target_node_path
         ,target_page_set_id
         ,target_page_id
         ,target_url
         ,frame_name
         ,target_anchor
         ,seeded_flag
         ,cx_command_name
         ,window_parameters
         ,target_window_type
         ,target_window_name
         ,target_expl_node_id
         ,deleted_flag
         )
         VALUES
         (
         l_ui_action_id
         ,p_ui_node.ui_def_id
         ,p_ui_node.page_id
         ,p_node.persistent_node_id
         ,l_element_id
         ,NULL
         ,G_CX_BUTTON_ACTION_TYPE
         ,NULL
         ,NULL
         ,NULL
         ,NULL
         ,NULL
         ,NULL
         ,NULL
         ,NULL
         ,'0'
         ,i.data_value
         ,NULL
         ,NULL
         ,NULL
         ,NULL
         ,G_NO_FLAG
         );

Line: 9335

         FOR k IN(SELECT component_id, ps_node_type FROM CZ_MODEL_REF_EXPLS
                   START WITH model_ref_expl_id=i.model_ref_expl_id
                  CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag='0')
         LOOP
           IF k.ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE THEN
             l_ref_model_id := k.component_id;

Line: 9346

         SELECT persistent_node_id INTO l_persistent_id FROM CZ_PS_NODES
          WHERE devl_project_id=l_ref_model_id AND ps_node_id=i.component_id;

Line: 9350

         SELECT model_ref_expl_id, persistent_node_id INTO l_pb_model_ref_expl_id, l_pb_persistent_node_id  FROM CZ_UI_PAGE_ELEMENTS
          WHERE ui_def_id=p_ui_node.ui_def_id AND page_id=p_ui_node.page_id AND
                element_id=p_ui_node.parent_element_id;

Line: 9392

     FOR option_node IN(SELECT ps_node_id,persistent_node_id,
                               parent_persistent_node_id FROM CZ_UITEMPLS_FOR_PSNODES_V a
                         WHERE devl_project_id=g_UI_Context.devl_project_id AND
                               ui_def_id=g_UI_Context.from_master_template_id AND
                               ps_node_type IN(G_OPTION_TYPE, G_BOM_STANDART_ITEM_TYPE) AND
                               ui_omit=G_NO_FLAG AND deleted_flag=G_NO_FLAG AND
                               EXISTS(SELECT NULL FROM CZ_RULES
                                       WHERE devl_project_id=g_UI_Context.devl_project_id AND
                                             component_id=a.ps_node_id AND
                                             disabled_flag=G_NO_FLAG AND
                                             deleted_flag=G_NO_FLAG))
     LOOP
       FOR parent_ui_node IN(SELECT *
                               FROM CZ_UI_PAGE_ELEMENTS
                              WHERE ui_def_id=g_UI_Context.ui_def_id AND
                                    persistent_node_id=option_node.parent_persistent_node_id AND
                                    deleted_flag NOT IN(G_YES_FLAG, G_MARK_TO_DELETE, G_LIMBO_FLAG))
       LOOP

         FOR i IN(SELECT DISTINCT b.data_value, b.expr_node_id, a.INSTANTIATION_SCOPE, a.NAME
                    FROM CZ_RULES a, CZ_EXPRESSION_NODES b
                   WHERE a.devl_project_id=g_UI_Context.devl_project_id AND
                         a.component_id=option_node.ps_node_id AND
                         a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
                         a.deleted_flag=G_NO_FLAG AND
                         a.disabled_flag=G_NO_FLAG AND
                         a.invalid_flag=G_NO_FLAG AND
                         b.rule_id=a.rule_id AND
                         b.deleted_flag=G_NO_FLAG AND
                         b.argument_signature_id=G_EVENT_ON_COMMAND_SIGID AND
                         b.data_value IS NOT NULL)
         LOOP
           IF find_CX_On_UI_Page(parent_ui_node.page_id, option_node.ps_node_id, i.data_value) = G_NO_FLAG THEN
             l_element_id := get_Element_Id();

Line: 9428

             INSERT INTO CZ_INTL_TEXTS
              (INTL_TEXT_ID,
               TEXT_STR,
               DELETED_FLAG,
               SEEDED_FLAG,
               UI_DEF_ID,
               MODEL_ID,
               UI_PAGE_ID,
               UI_PAGE_ELEMENT_ID
              )
             VALUES
             (l_ui_intl_text_id,
              i.data_value,
              G_NO_FLAG,
              G_NO_FLAG,
              g_UI_Context.ui_def_id,
              g_UI_Context.devl_project_id,
              parent_ui_node.page_id,
              l_element_id
             );

Line: 9459

            INSERT INTO CZ_UI_PAGE_ELEMENTS
             (ui_def_id,
             persistent_node_id,
             parent_persistent_node_id,
             region_persistent_node_id,
             pagebase_persistent_node_id,
             page_id,
             base_page_flag,
             seq_nbr,
             ctrl_template_id,
             ctrl_template_ui_def_id,
             element_id,
             parent_element_id,
             element_type,
             instantiable_flag,
             model_ref_expl_id,
             element_signature_id,
             NAME,
             deleted_flag)
            VALUES
             (g_UI_Context.ui_def_id,
             option_node.persistent_node_id,
             option_node.parent_persistent_node_id,
             parent_ui_node.region_persistent_node_id,
             parent_ui_node.pagebase_persistent_node_id,
             parent_ui_node.page_id,
             NULL,
             parent_ui_node.seq_nbr+1,
             G_DRILLDOWN_BUTTON_TEMPLATE_ID,
             G_GLOBAL_TEMPLATES_UI_DEF_ID,
             l_element_id,
             l_parent_element_id,
             G_UI_CX_BUTTON_NODE_TYPE,
             NULL,
             parent_ui_node.model_ref_expl_id,
             g_DRILLDOWN_B_SIGNATURE_ID,
             G_DRILLDOWN_TEMPLATE_NAME||' - '||l_element_id,
             G_MARK_TO_ADD);

Line: 9500

            INSERT INTO CZ_UI_ACTIONS
            (
             ui_action_id
             ,ui_def_id
             ,source_page_id
             ,context_component_id
             ,element_id
             ,render_condition_id
             ,ui_action_type
             ,target_ui_def_id
             ,target_persistent_node_id
             ,target_node_path
             ,target_page_set_id
             ,target_page_id
             ,target_url
             ,frame_name
             ,target_anchor
             ,seeded_flag
             ,cx_command_name
             ,window_parameters
             ,target_window_type
             ,target_window_name
             ,target_expl_node_id
             ,deleted_flag
             )
             VALUES
             (
             l_ui_action_id
             ,g_UI_Context.ui_def_id
             ,parent_ui_node.page_id
             ,option_node.persistent_node_id
             ,l_element_id
             ,NULL
             ,G_CX_BUTTON_ACTION_TYPE
            ,NULL
             ,NULL
             ,NULL
             ,NULL
             ,NULL
             ,NULL
             ,NULL
             ,NULL
             ,'0'
             ,i.data_value
             ,NULL
             ,NULL
             ,NULL
             ,NULL
             ,G_NO_FLAG
             );

Line: 9568

    SELECT '1' INTO l_dummy
    FROM DUAL
    WHERE '1' IN (SELECT suppress_refresh_flag
                  FROM cz_ui_page_elements
                  START WITH ui_def_Id = p_page_element.ui_def_id
                  AND page_id = p_page_element.page_id
                  AND element_id = p_page_element.element_id
                  CONNECT BY PRIOR parent_element_id IS NOT NULL
                  AND prior suppress_refresh_flag = G_NO_FLAG
                  AND ui_def_Id = p_page_element.ui_def_id
                  AND page_id = p_page_element.page_id
                  AND prior parent_element_id = element_id);

Line: 9602

     FOR i in (SELECT DISTINCT page_id
               FROM cz_ui_page_elements
               WHERE ui_def_Id = g_UI_Context.ui_def_id
               AND element_type = G_UI_CX_BUTTON_NODE_TYPE
               AND deleted_flag = G_NO_FLAG)
     LOOP
       --DEBUG('asp: Marking page ' || i.page_id || ', ' || g_UI_Context.ui_def_id || ' for refresh ');

Line: 9613

     FOR i in (SELECT b.data_value, b.expr_node_id, a.INSTANTIATION_SCOPE, a.NAME,
                 (SELECT persistent_node_id
                  FROM CZ_PS_NODES
                  WHERE devl_project_id = g_UI_Context.devl_project_id
                  AND ps_node_id = a.component_id) persistent_node_Id
               FROM CZ_RULES a, CZ_EXPRESSION_NODES b
               WHERE a.devl_project_id=g_UI_Context.devl_project_id AND
                     a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
                     b.rule_id=a.rule_id AND
                     b.argument_signature_id=G_EVENT_ON_COMMAND_SIGID AND
                     b.data_value IS NOT NULL AND
                     b.last_update_date > g_UI_Context.UI_TIMESTAMP_REFRESH)
     LOOP
       BEGIN

         SELECT e.element_id INTO l_element_id
         FROM CZ_UI_PAGE_ELEMENTS e
         WHERE ui_def_id = g_UI_Context.ui_def_id AND
               persistent_node_id = i.persistent_node_id AND
               element_type = G_UI_CX_BUTTON_NODE_TYPE AND
               deleted_flag NOT IN (G_YES_FLAG, G_MARK_TO_DELETE) AND
               EXISTS (SELECT NULL FROM CZ_UI_ACTIONS a
                       WHERE a.ui_def_id = e.ui_def_id AND
                             a.source_page_id = e.page_id AND
                             a.element_id = e.element_id AND
                             a.deleted_flag NOT IN (G_YES_FLAG, G_MARK_TO_DELETE) AND
                             a.cx_command_name = i.data_value);

Line: 9643

           FOR j in (SELECT *
                     FROM CZ_UI_PAGE_ELEMENTS e
                     WHERE ui_def_id = g_UI_Context.ui_def_id AND
                           persistent_node_id = i.persistent_node_id AND
                           deleted_flag NOT IN (G_YES_FLAG, G_MARK_TO_DELETE))
          LOOP
            IF NOT disabled_for_refresh(j) THEN
              l_ps_node := get_Model_Node_By_Persist_id(i.persistent_node_id, g_UI_Context.devl_project_id);

Line: 9664

                             p_insert_index         IN NUMBER DEFAULT -1)
    RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS

    l_ui_node                 CZ_UI_PAGE_ELEMENTS%ROWTYPE;

Line: 9680

      SELECT G_YES_FLAG INTO l_node_exists_in_ui FROM dual
      WHERE EXISTS(SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
      WHERE ui_def_id=g_UI_Context.ui_def_id AND
            page_id=p_parent_ui_node.page_id AND
            parent_element_id=p_parent_ui_node.element_id AND
            persistent_node_id=p_node.persistent_node_id AND
            element_type IS NULL AND deleted_flag=G_NO_FLAG);

Line: 9701

    IF p_insert_index > 0 THEN
      l_max_prev_seq_nbr := p_insert_index-1;

Line: 9703

      l_ui_node.seq_nbr := p_insert_index;

Line: 9705

    SELECT NVL(MAX(seq_nbr),0) INTO l_max_prev_seq_nbr  FROM CZ_UI_PAGE_ELEMENTS
    START WITH ui_def_id=g_UI_Context.ui_def_id AND
               page_id=p_parent_ui_node.page_id AND
               element_id=p_parent_ui_node.element_id AND
               deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE)
    CONNECT BY PRIOR ui_def_id=g_UI_Context.ui_def_id AND
       ui_def_id=g_UI_Context.ui_def_id AND PRIOR page_id= p_parent_ui_node.page_id
        AND page_id=p_parent_ui_node.page_id AND PRIOR element_id=parent_element_id AND
        PRIOR deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE) AND
        deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 9719

    UPDATE CZ_UI_PAGE_ELEMENTS
       SET seq_nbr=seq_nbr+1
     WHERE ui_def_id=g_UI_Context.ui_def_id AND
           page_id=p_parent_ui_node.page_id AND
           seq_nbr>l_max_prev_seq_nbr AND
           deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 9764

    l_ui_node.deleted_flag                := G_MARK_TO_ADD;

Line: 9766

    SELECT COUNT(element_id)+1 INTO l_counter FROM CZ_UI_PAGE_ELEMENTS
    WHERE ui_def_id=g_UI_Context.ui_def_id AND
          page_id=l_ui_node.page_id AND
          ctrl_template_id=l_ui_node.ctrl_template_id AND
          deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 9776

    INSERT INTO CZ_UI_PAGE_ELEMENTS
      (ui_def_id,
       persistent_node_id,
       parent_persistent_node_id,
       region_persistent_node_id,
       pagebase_persistent_node_id,
       page_id,
       seq_nbr,
       ctrl_template_id,
       element_id,
       parent_element_id,
       element_type,
       instantiable_flag,
       ctrl_template_ui_def_id,
       model_ref_expl_id,
       element_signature_id,
       name,
       deleted_flag)
    VALUES
      (l_ui_node.ui_def_id,
       l_ui_node.persistent_node_id,
       l_ui_node.parent_persistent_node_id,
       l_ui_node.region_persistent_node_id,
       l_ui_node.pagebase_persistent_node_id,
       l_ui_node.page_id,
       l_ui_node.seq_nbr,
       l_ui_node.ctrl_template_id,
       l_ui_node.element_id,
       l_ui_node.parent_element_id,
       l_ui_node.element_type,
       l_ui_node.instantiable_flag,
       l_ui_node.ctrl_template_ui_def_id,
       l_ui_node.model_ref_expl_id,
       l_ui_node.element_signature_id,
       l_ui_node.name,
       l_ui_node.deleted_flag);

Line: 9845

    SELECT NVL(MAX(seq_nbr),0) INTO l_max_prev_seq_nbr  FROM CZ_UI_PAGE_ELEMENTS
    START WITH ui_def_id=g_UI_Context.ui_def_id AND
               page_id=p_parent_ui_node.page_id AND
               element_id=p_parent_ui_node.element_id AND
               deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE)
    CONNECT BY PRIOR ui_def_id=g_UI_Context.ui_def_id AND
       ui_def_id=g_UI_Context.ui_def_id AND PRIOR page_id= p_parent_ui_node.page_id
        AND page_id=p_parent_ui_node.page_id AND PRIOR element_id=parent_element_id AND
        PRIOR deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE) AND
        deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 9858

    UPDATE CZ_UI_PAGE_ELEMENTS
       SET seq_nbr=seq_nbr+1
     WHERE ui_def_id=g_UI_Context.ui_def_id AND
           page_id=p_parent_ui_node.page_id AND
           seq_nbr>l_max_prev_seq_nbr AND
           deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 9879

    INSERT INTO CZ_UI_PAGE_ELEMENTS
              (ui_def_id,
               persistent_node_id,
               parent_persistent_node_id,
               region_persistent_node_id,
               pagebase_persistent_node_id,
               page_id,
               seq_nbr,
               ctrl_template_id,
               element_id,
               parent_element_id,
               element_type,
               instantiable_flag,
               ctrl_template_ui_def_id,
               model_ref_expl_id,
               element_signature_id,
               name,
               deleted_flag)
       VALUES
              (p_ui_node.ui_def_id,
               p_ui_node.persistent_node_id,
               p_ui_node.parent_persistent_node_id,
               p_parent_ui_node.region_persistent_node_id,
               p_parent_ui_node.pagebase_persistent_node_id,
               p_parent_ui_node.page_id,
               l_seq_nbr,
               p_node.template_id,
               l_element_id,
               p_parent_ui_node.element_id,
               l_element_type,
               p_ui_node.instantiable_flag,
               p_node.template_ui_def_id,
               p_ui_node.model_ref_expl_id,
               p_node.root_element_signature_id,
               l_ui_node_name,
               G_MARK_DO_NOT_REFRESH);

Line: 9918

    UPDATE CZ_UI_PAGE_ELEMENTS
       SET deleted_flag=G_MARK_TO_DELETE
     WHERE ui_def_id = p_parent_ui_node.ui_def_id AND
           persistent_node_id=p_ui_node.persistent_node_id AND
           element_type=G_UI_PAGEDRILLDOWN_NODE_TYPE AND
           deleted_flag=G_NO_FLAG;

Line: 9963

    INSERT INTO CZ_UI_PAGE_ELEMENTS
      (ui_def_id,
       persistent_node_id,
       parent_persistent_node_id,
       region_persistent_node_id,
       pagebase_persistent_node_id,
       page_id,
       seq_nbr,
       ctrl_template_id,
       element_id,
       parent_element_id,
       element_type,
       instantiable_flag,
       ctrl_template_ui_def_id,
       model_ref_expl_id,
       name,
       element_signature_id,
       deleted_flag)
    VALUES
      (p_parent_ui_node.ui_def_id,
       p_ui_node.persistent_node_id,
       p_ui_node.parent_persistent_node_id,
       p_parent_ui_node.region_persistent_node_id,
       p_parent_ui_node.pagebase_persistent_node_id,
       p_parent_ui_node.page_id,
       l_seq_nbr,
       g_DRILLDOWN_TEMPLATE_ID,
       l_element_id,
       p_parent_ui_node.element_id,
       G_UI_PAGEDRILLDOWN_NODE_TYPE,
       NULL,
       G_GLOBAL_TEMPLATES_UI_DEF_ID,
       NULL,
       l_ui_node_name,
       g_DRILLDOWN_ELEM_SIGNATURE_ID,
       G_MARK_TO_ADD);

Line: 10001

    INSERT INTO CZ_UI_ACTIONS
      (ui_action_id,
       ui_def_id,
       source_page_id,
       context_component_id,
       element_id,
       ui_action_type,
       target_ui_def_id,
       target_persistent_node_id,
       target_node_path,
       target_page_set_id,
       target_page_id,
       target_expl_node_id,
       seeded_flag,
       deleted_flag)
    VALUES
      (l_ui_action_id,
       p_parent_ui_node.ui_def_id,
       p_parent_ui_node.page_id,
       p_parent_ui_node.region_persistent_node_id,
       l_element_id,
       G_ACTION_CONFIGURE_SUBCOMP,
       NULL,
       p_ui_node.persistent_node_id,
       TO_CHAR(p_ui_node.persistent_node_id),
       p_page_set_id,
       p_ui_node.page_id,
       p_ui_node.model_ref_expl_id,
       G_NO_FLAG,
       G_NO_FLAG);

Line: 10044

   SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES
   WHERE ps_node_id=p_ps_node_id AND deleted_flag=G_NO_FLAG;

Line: 10051

    FOR i IN (SELECT DISTINCT ps_node_type,reference_id FROM CZ_PS_NODES
              WHERE parent_id=p_ps_node_id AND
                    deleted_flag=G_NO_FLAG AND ui_omit=G_NO_FLAG AND
                    (ps_node_type IN(G_BOM_MODEL_TYPE,G_BOM_OPTION_CLASS_TYPE,G_BOM_STANDART_ITEM_TYPE) OR
                     ps_node_type=G_REFERENCE_TYPE))
    LOOP
      IF i.ps_node_type=G_REFERENCE_TYPE THEN
         SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES
         WHERE ps_node_id=i.reference_id;

Line: 10097

      UPDATE CZ_UI_PAGE_ELEMENTS
         SET seq_nbr=seq_nbr+1
       WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=p_page_id AND
             deleted_flag NOT IN(G_YES_FLAG, G_LIMBO_FLAG);

Line: 10103

      INSERT INTO CZ_UI_PAGE_ELEMENTS
      (ui_def_id,
       persistent_node_id,
       parent_persistent_node_id,
       region_persistent_node_id,
       pagebase_persistent_node_id,
       page_id,
       seq_nbr,
       ctrl_template_id,
       element_id,
       parent_element_id,
       element_type,
       instantiable_flag,
       ctrl_template_ui_def_id,
       model_ref_expl_id,
       element_signature_id,
       name,
       deleted_flag)
      VALUES
      (g_UI_Context.ui_def_id,
       p_node.persistent_node_id,
       p_node.parent_persistent_node_id,
       p_node.persistent_node_id,
       p_pagebase_persistent_node_id,
       p_page_id,
       1,
       p_node.template_id,
       l_bom_element_id,
       p_parent_element_id,
       G_UI_BOMADDINST_NODE_TYPE,
       p_node.instantiable_flag,
       p_node.template_ui_def_id,
       p_pagebase_expl_node_id,
       p_node.root_element_signature_id,
       l_ui_node_name,
       G_MARK_TO_ADD);

Line: 10164

        SELECT MIN(page_id)
          INTO x_page_id
          FROM CZ_UI_PAGES
         WHERE ui_def_id = g_UI_Context.ui_def_id AND
               persistent_node_id = p_parent_persistent_node_id AND
               NVL(split_seq_nbr,1)=1 AND
               deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,G_MARK_TO_REFRESH);

Line: 10175

          SELECT page_set_id INTO x_page_set_id
            FROM CZ_UI_PAGES
           WHERE page_id=x_page_id AND
                 ui_def_id = g_UI_Context.ui_def_id;

Line: 10185

        SELECT page_set_id INTO x_page_set_id
          FROM CZ_UI_PAGES
         WHERE page_id=p_parent_page_id AND
               ui_def_id = g_UI_Context.ui_def_id;

Line: 10194

        SELECT MIN(page_ref_id)
          INTO x_parent_page_ref_id
          FROM CZ_UI_PAGE_REFS
         WHERE ui_def_id = g_UI_Context.ui_def_id AND
               NVL(page_set_id,-1)=NVL(x_page_set_id,-1) AND
               target_page_id=x_page_id AND deleted_flag=G_NO_FLAG;

Line: 10201

        SELECT node_depth,page_ref_type INTO x_parent_node_depth,  x_parent_page_set_type
          FROM CZ_UI_PAGE_REFS
         WHERE ui_def_id = g_UI_Context.ui_def_id AND
               page_ref_id=x_parent_page_ref_id;

Line: 10208

            SELECT page_set_type INTO x_parent_page_set_type FROM CZ_UI_PAGE_SETS
            WHERE ui_def_id = g_UI_Context.ui_def_id AND page_set_id=x_page_set_id;

Line: 10238

      SELECT COUNT(*)+1 INTO l_seq_nbr
        FROM CZ_UI_PAGE_REFS
       WHERE ui_def_id=g_UI_Context.ui_def_id AND
             page_set_id = p_page_set_id AND
             parent_page_ref_id=p_parent_page_ref_id AND
             deleted_flag=G_NO_FLAG;

Line: 10255

          FOR j in (SELECT persistent_node_id
                    FROM CZ_PS_NODES
                    WHERE devl_project_id = g_UI_Context.devl_project_id
                    AND parent_id = p_node.parent_id
                    AND tree_seq = p_node.tree_seq-i
                    AND deleted_flag = G_NO_FLAG)
          LOOP
          --DEBUG('asp: predecessor persistent_node_id = ' || l_predecessor_persistent_id);

Line: 10264

            SELECT NVL(max(seq_nbr), 0) INTO l_seq_nbr
            FROM CZ_UI_PAGE_REFS
            WHERE ui_def_id = g_UI_Context.ui_def_id
            AND page_set_id = p_page_set_id
            AND parent_page_ref_id = p_parent_page_ref_id
            AND target_persistent_node_id = j.persistent_node_id
            AND deleted_flag = G_NO_FLAG;

Line: 10287

          SELECT NVL(count(*), 0) + 1 INTO l_seq_nbr
          FROM CZ_UI_PAGE_REFS
          WHERE ui_def_id = g_UI_Context.ui_def_Id
          AND page_set_id = p_page_set_id
          AND parent_page_ref_id = p_parent_page_ref_id
          AND deleted_flag = G_NO_FLAG;

Line: 10372

        SELECT persistent_node_id INTO l_parent_page_persistent_id
        FROM CZ_UI_PAGES
        WHERE ui_Def_id = g_UI_Context.ui_def_id
        AND   page_id = l_parent_page_id;

Line: 10451

    l_page_node.deleted_flag          := G_MARK_TO_ADD;

Line: 10453

    INSERT INTO CZ_UI_PAGES
      (page_id,
       ui_def_id,
       NAME,
       persistent_node_id,
       jrad_doc,
       page_set_id,
       split_seq_nbr,
       caption_source,
       pagebase_path,
       pagebase_expl_node_id,
       page_rev_nbr,
       seeded_flag,
       page_status_template_id,
       page_status_templ_uidef_id,
       caption_rule_id,
       deleted_flag)
    VALUES
      (l_page_node.page_id ,
       l_page_node.ui_def_id,
       l_page_node.NAME,
       l_page_node.persistent_node_id,
       l_page_node.jrad_doc,
       l_page_node.page_set_id,
       l_page_node.split_seq_nbr,
       l_page_node.caption_source,
       l_page_node.pagebase_path,
       l_page_node.pagebase_expl_node_id,
       1,
       l_page_node.seeded_flag,
       g_PAGE_STATUS_TEMPLATE_ID,
       G_GLOBAL_TEMPLATES_UI_DEF_ID,
       NULL,
       l_page_node.deleted_flag);

Line: 10509

    l_page_ui_node.deleted_flag                := G_MARK_TO_ADD;

Line: 10514

    INSERT INTO CZ_UI_PAGE_ELEMENTS
      (ui_def_id,
       persistent_node_id,
       parent_persistent_node_id,
       region_persistent_node_id,
       pagebase_persistent_node_id,
       page_id,
       seq_nbr,
       ctrl_template_id,
       element_id,
       parent_element_id,
       element_type,
       instantiable_flag,
       ctrl_template_ui_def_id,
       model_ref_expl_id,
       base_page_flag,
       element_signature_id,
       name,
       deleted_flag)
    VALUES
      (l_page_ui_node.ui_def_id,
       l_page_ui_node.persistent_node_id,
       l_page_ui_node.parent_persistent_node_id,
       l_page_ui_node.region_persistent_node_id,
       l_page_ui_node.pagebase_persistent_node_id,
       l_page_ui_node.page_id,
       l_page_ui_node.seq_nbr,
       l_page_ui_node.ctrl_template_id,
       l_page_ui_node.element_id,
       l_page_ui_node.parent_element_id,
       l_page_ui_node.element_type,
       l_page_ui_node.instantiable_flag,
       l_page_ui_node.ctrl_template_ui_def_id,
       l_page_ui_node.model_ref_expl_id,
       l_page_ui_node.base_page_flag,
       6004,
       l_page_ui_node.name,
       l_page_ui_node.deleted_flag);

Line: 10572

      FOR i IN(SELECT *
                 FROM CZ_UI_PAGE_ELEMENTS
                WHERE ui_def_id=l_page_ui_node.ui_def_id AND
                      page_id=l_last_page_id AND
                      persistent_node_id=l_page_ui_node.parent_persistent_node_id AND
                      element_type IN(G_UI_PAGE_NODE_TYPE,G_UI_REGION_NODE_TYPE) AND
                      deleted_flag IN(G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH))
      LOOP
        IF NVL(i.suppress_refresh_flag, G_NO_FLAG) = G_NO_FLAG THEN
          IF l_is_inst_node THEN
             add_Instance_Controls(p_ui_node          => l_page_ui_node,
                                   p_parent_ui_node   => i,
                                   p_node             => p_node);

Line: 10601

   FOR m IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS
            WHERE ui_def_id=g_UI_Context.ui_def_id AND
                  page_set_id=l_page_set_id AND
                  NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG)
   LOOP

     /******** attach new UI Page to Page Set *********************/
     BEGIN

       --
       -- create a new record for this UI page in CZ_UI_PAGE_REFS
       --
       l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');

Line: 10619

         SELECT COUNT(*)+1 INTO l_seq_nbr
         FROM CZ_UI_PAGE_REFS WHERE ui_def_id=g_UI_Context.ui_def_id AND
              deleted_flag=G_NO_FLAG;

Line: 10628

         UPDATE CZ_UI_PAGE_REFS
         SET seq_nbr = seq_nbr + 1
         WHERE ui_def_id = g_UI_Context.ui_def_id
         AND page_set_id = l_page_set_id
         AND parent_page_ref_id = l_parent_page_ref_id
         AND seq_nbr >= l_seq_nbr
         AND deleted_flag = G_NO_FLAG;

Line: 10642

      INSERT INTO CZ_UI_PAGE_REFS
      (ui_def_id,
       page_set_id,
       page_ref_id,
       parent_page_ref_id,
       seq_nbr,
       node_depth,
       condition_id,
       NAME,
       caption_source,
       target_persistent_node_id,
       target_path,
       target_ui_def_id,
       target_page_set_id,
       target_page_id,
       modified_flags,
       path_to_prev_page,
       path_to_next_page,
       page_ref_type,
       target_expl_node_id,
       caption_rule_id,
       deleted_flag)
       VALUES
      (g_UI_Context.ui_def_id,
       l_page_set_id,
       l_page_ref_id,
       l_parent_page_ref_id,
       l_seq_nbr,
       l_node_depth,
       NULL,
       p_node.name,
       G_DEFAULT_CAPTION_RULE_ID,
       p_node.persistent_node_id,
       l_ref_pagebase_path,
       NULL,
       NULL,
       l_page_ui_node.page_id,
       0,
       NULL,
       NULL,
       l_page_set_type,
       l_page_node.pagebase_expl_node_id,
       NULL,
       G_NO_FLAG);

Line: 10711

                            p_insert_index         IN NUMBER DEFAULT -1)
    RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS

    l_ui_node                 CZ_UI_PAGE_ELEMENTS%ROWTYPE;

Line: 10733

      SELECT page_id INTO l_page_id FROM CZ_UI_PAGES
       WHERE ui_def_id=g_UI_CONTEXT.ui_def_id AND persistent_node_id=p_node.persistent_node_id AND
             deleted_flag NOT IN (G_YES_FLAG,G_MARK_TO_DELETE, G_LIMBO_FLAG) AND rownum<2;

Line: 10748

    IF p_insert_index = -1 THEN
      SELECT NVL(MAX(seq_nbr),0) INTO l_max_prev_seq_nbr  FROM CZ_UI_PAGE_ELEMENTS
      START WITH ui_def_id=g_UI_Context.ui_def_id AND
                 page_id=p_parent_ui_node.page_id AND
                 element_id=p_parent_ui_node.element_id AND
                 deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE)
      CONNECT BY PRIOR ui_def_id=g_UI_Context.ui_def_id AND
         ui_def_id=g_UI_Context.ui_def_id AND PRIOR page_id= p_parent_ui_node.page_id
          AND page_id=p_parent_ui_node.page_id AND PRIOR element_id=parent_element_id AND
          PRIOR deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE) AND
          deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 10760

      l_max_prev_seq_nbr := p_insert_index-1;

Line: 10765

    UPDATE CZ_UI_PAGE_ELEMENTS
       SET seq_nbr=seq_nbr+1
     WHERE ui_def_id=g_UI_Context.ui_def_id AND
           page_id=p_parent_ui_node.page_id AND
           seq_nbr>l_max_prev_seq_nbr AND
           deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 10785

    l_ui_node.deleted_flag                := G_MARK_TO_ADD;

Line: 10787

    SELECT COUNT(element_id)+1 INTO l_counter FROM CZ_UI_PAGE_ELEMENTS
    WHERE ui_def_id=g_UI_Context.ui_def_id AND
          page_id=l_ui_node.page_id AND
          ctrl_template_id=l_ui_node.ctrl_template_id AND
          deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 10795

    INSERT INTO CZ_UI_PAGE_ELEMENTS
      (ui_def_id,
       persistent_node_id,
       parent_persistent_node_id,
       region_persistent_node_id,
       pagebase_persistent_node_id,
       page_id,
       seq_nbr,
       ctrl_template_id,
       element_id,
       parent_element_id,
       element_type,
       instantiable_flag,
       ctrl_template_ui_def_id,
       model_ref_expl_id,
       element_signature_id,
       name,
       deleted_flag)
    VALUES
      (l_ui_node.ui_def_id,
       l_ui_node.persistent_node_id,
       l_ui_node.parent_persistent_node_id,
       l_ui_node.region_persistent_node_id,
       l_ui_node.pagebase_persistent_node_id,
       l_ui_node.page_id,
       l_ui_node.seq_nbr,
       l_ui_node.ctrl_template_id,
       l_ui_node.element_id,
       l_ui_node.parent_element_id,
       l_ui_node.element_type,
       l_ui_node.instantiable_flag,
       l_ui_node.ctrl_template_ui_def_id,
       l_ui_node.model_ref_expl_id,
       l_ui_node.element_signature_id,
       l_ui_node.name,
       l_ui_node.deleted_flag);

Line: 10903

    SELECT NVL(MAX(seq_nbr),0) INTO l_max_prev_seq_nbr  FROM CZ_UI_PAGE_ELEMENTS
    START WITH ui_def_id=g_UI_Context.ui_def_id AND
               page_id=p_parent_ui_node.page_id AND
               element_id=p_parent_ui_node.element_id AND
               deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE)
    CONNECT BY PRIOR ui_def_id=g_UI_Context.ui_def_id AND
       ui_def_id=g_UI_Context.ui_def_id AND PRIOR page_id= p_parent_ui_node.page_id
        AND page_id=p_parent_ui_node.page_id AND PRIOR element_id=parent_element_id AND
        PRIOR deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE) AND
        deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 10916

    UPDATE CZ_UI_PAGE_ELEMENTS
       SET seq_nbr=seq_nbr+1
     WHERE ui_def_id=g_UI_Context.ui_def_id AND
           page_id=p_parent_ui_node.page_id AND
           seq_nbr>l_max_prev_seq_nbr AND
           deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 10941

    l_ui_node.deleted_flag                    := G_MARK_TO_ADD;

Line: 10943

    SELECT COUNT(element_id)+1 INTO l_counter FROM CZ_UI_PAGE_ELEMENTS
    WHERE ui_def_id=g_UI_Context.ui_def_id AND
          page_id=l_ui_node.page_id AND
          ctrl_template_id=l_ui_node.ctrl_template_id AND
          deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 10958

         SELECT NVL(MAX(seq_nbr),0) INTO l_max_seq_nbr
         FROM CZ_UI_PAGE_ELEMENTS
         WHERE ui_def_id=l_ui_node.ui_def_id
         AND parent_element_id=l_ui_node.parent_element_id
         AND deleted_flag IN(G_NO_FLAG,G_MARK_TO_REFRESH,G_MARK_TO_ADD)
         AND element_type IN(G_UI_BOMADDINST_NODE_TYPE);

Line: 10965

         SELECT persistent_node_id INTO l_persistent_node_id
           FROM CZ_UI_PAGE_ELEMENTS
          WHERE ui_def_id=l_ui_node.ui_def_id AND
                parent_element_id=l_ui_node.parent_element_id AND
                seq_nbr=l_max_seq_nbr AND
                ROWNUM<2;

Line: 10974

         SELECT ps_node_type INTO l_ps_node_type
           FROM CZ_PS_NODES
          WHERE devl_project_id=p_node.reference_id AND
                parent_id IS NULL AND
                deleted_flag=G_NO_FLAG;

Line: 10996

    INSERT INTO CZ_UI_PAGE_ELEMENTS
      (ui_def_id,
       persistent_node_id,
       parent_persistent_node_id,
       region_persistent_node_id,
       pagebase_persistent_node_id,
       page_id,
       seq_nbr,
       ctrl_template_id,
       element_id,
       parent_element_id,
       element_type,
       instantiable_flag,
       ctrl_template_ui_def_id,
       model_ref_expl_id,
       element_signature_id,
       name,
       deleted_flag)
    VALUES
      (l_ui_node.ui_def_id,
       l_ui_node.persistent_node_id,
       l_ui_node.parent_persistent_node_id,
       l_ui_node.region_persistent_node_id,
       l_ui_node.pagebase_persistent_node_id,
       l_ui_node.page_id,
       l_ui_node.seq_nbr,
       l_ui_node.ctrl_template_id,
       l_ui_node.element_id,
       l_ui_node.parent_element_id,
       l_ui_node.element_type,
       l_ui_node.instantiable_flag,
       l_ui_node.ctrl_template_ui_def_id,
       l_ui_node.model_ref_expl_id,
       l_ui_node.element_signature_id,
       l_ui_node.name,
       l_ui_node.deleted_flag);

Line: 11035

      UPDATE CZ_UI_REFS
         SET deleted_flag=G_NO_FLAG
       WHERE
         ui_def_id = l_ui_node.ui_def_id AND
         ref_persistent_node_id = l_ui_node.persistent_node_id;

Line: 11042

        INSERT INTO CZ_UI_REFS
        (ui_def_id,
         ref_ui_def_id,
         ref_persistent_node_id,
         model_ref_expl_id,
         deleted_flag)
        VALUES
        (l_ui_node.ui_def_id,
         l_target_ui_def_node.ui_def_id,
         l_ui_node.persistent_node_id,
         l_ui_node.model_ref_expl_id,
         G_NO_FLAG);

Line: 11062

    INSERT INTO CZ_UI_ACTIONS
      (ui_action_id,
       ui_def_id,
       source_page_id,
       context_component_id,
       element_id,
       ui_action_type,
       target_ui_def_id,
       target_persistent_node_id,
       target_node_path,
       target_page_set_id,
       target_page_id,
       target_expl_node_id,
       seeded_flag,
       deleted_flag)
    VALUES
      (l_ui_action_id,
       l_ui_node.ui_def_id,
       l_ui_node.page_id,
       l_ui_node.region_persistent_node_id,
       l_ui_node.element_id,
       G_ACTION_CONFIGURE_SUBCOMP,
       l_target_ui_def_node.ui_def_id,
       p_node.persistent_node_id,
       TO_CHAR(p_node.persistent_node_id),
       l_target_ui_def_node.page_set_id,
       l_target_ui_def_node.start_page_id,
       l_ui_node.model_ref_expl_id,
       G_NO_FLAG,
       G_NO_FLAG);

Line: 11113

    FOR m IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS
              WHERE ui_def_id=g_UI_Context.ui_def_id AND
                    page_set_id=l_page_ref_node.page_set_id AND
                    NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG)
    LOOP

      --
      -- create a new record for this UI page in CZ_UI_PAGE_REFS
      --
      l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');

Line: 11126

         SELECT MIN(page_id) INTO l_target_ui_def_node.start_page_id
           FROM CZ_UI_PAGES
          WHERE ui_def_id=l_target_ui_def_node.ui_def_id AND
                deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,G_MARK_TO_REFRESH);

Line: 11131

         SELECT MIN(page_set_id) INTO l_target_ui_def_node.page_set_id
           FROM CZ_UI_PAGE_SETS
          WHERE ui_def_id=l_target_ui_def_node.ui_def_id AND deleted_flag=G_NO_FLAG;

Line: 11140

        SELECT COUNT(*)+1 INTO l_seq_nbr
        FROM CZ_UI_PAGE_REFS WHERE ui_def_id=g_UI_Context.ui_def_id AND
             deleted_flag=G_NO_FLAG;

Line: 11147

        UPDATE CZ_UI_PAGE_REFS
        SET seq_nbr = seq_nbr + 1
        WHERE ui_def_id = g_UI_Context.ui_def_id
        AND page_set_id = l_page_ref_node.page_set_id
        AND parent_page_ref_id = l_page_ref_node.page_ref_id
        AND seq_nbr >= l_seq_nbr
        AND deleted_flag = G_NO_FLAG;

Line: 11158

      INSERT INTO CZ_UI_PAGE_REFS
      (ui_def_id,
       page_set_id,
       page_ref_id,
       parent_page_ref_id,
       seq_nbr,
       node_depth,
       NAME,
       caption_source,
       target_persistent_node_id,
       target_path,
       target_ui_def_id,
       target_page_set_id,
       target_page_id,
       modified_flags,
       page_ref_type,
       target_expl_node_id,
       caption_rule_id,
       deleted_flag)
       VALUES
      (l_ui_node.ui_def_id,
       l_page_ref_node.page_set_id,
       l_page_ref_id,
       l_page_ref_node.page_ref_id,
       l_seq_nbr,
       l_page_ref_node.node_depth+1,
       p_node.NAME,
       G_DEFAULT_CAPTION_RULE_ID,
       p_node.persistent_node_id,
       l_target_path,
       l_target_ui_def_node.ui_def_id, --NULL, -- request from Alok -- old code l_target_ui_def_node.ui_def_id,
       l_target_ui_def_node.page_set_id, --NULL, -- request from Alok -- old code l_target_ui_def_node.page_set_id,
       l_target_ui_def_node.start_page_id, --NULL, -- request from Alok -- old code l_target_ui_def_node.start_page_id,
       0,
       l_page_ref_node.page_ref_type,
       l_ui_node.model_ref_expl_id,
       NULL,
       G_NO_FLAG);

Line: 11206

  PROCEDURE delete_UI_Element(p_ui_node               IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
                              p_suppress_refresh_flag IN CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE DEFAULT NULL,
                              p_delete_in_model       IN BOOLEAN DEFAULT NULL) IS

    l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;

Line: 11219

       FOR i IN (SELECT persistent_node_id,region_persistent_node_id,suppress_refresh_flag
                 FROM CZ_UI_PAGE_ELEMENTS
                 START WITH ui_def_id = p_ui_node.ui_def_id AND
                          deleted_flag IN
                          (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH,
                           G_MARK_TO_DELETE) AND element_id = p_ui_node.element_id
                 CONNECT BY PRIOR parent_element_id = element_id AND
                         deleted_flag IN
                         (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH,
                          G_MARK_TO_DELETE) AND
                         PRIOR deleted_flag IN
                          (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH,
                           G_MARK_TO_DELETE))
        LOOP
          IF i.persistent_node_id=i.region_persistent_node_id THEN
             l_suppress_refresh_flag := i.suppress_refresh_flag;

Line: 11255

       UPDATE CZ_UI_PAGE_ELEMENTS
          SET deleted_flag = G_MARK_TO_DELETE
        WHERE ui_def_id = p_ui_node.ui_def_id AND
              element_id IN
              (SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
               START WITH ui_def_id=p_ui_node.ui_def_id AND element_id=p_ui_node.element_id
               CONNECT BY PRIOR ui_def_id=p_ui_node.ui_def_id AND ui_def_id=p_ui_node.ui_def_id AND
               PRIOR element_id=parent_element_id AND
                     deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH,G_MARK_TO_DELETE) AND
               PRIOR deleted_flag IN(G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH,G_MARK_TO_DELETE));

Line: 11269

      IF p_delete_in_model THEN
         --
         -- deassociate UI element from model node
         --
         UPDATE CZ_UI_PAGE_ELEMENTS
            SET deleted_flag = G_MARK_TO_DEASSOCIATE,
                persistent_node_id = 0
          WHERE ui_def_id = p_ui_node.ui_def_id AND
                element_id IN
                (SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
                 START WITH ui_def_id=p_ui_node.ui_def_id AND element_id=p_ui_node.element_id
                 CONNECT BY PRIOR ui_def_id=p_ui_node.ui_def_id AND
                  PRIOR element_id=parent_element_id AND
                        deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH,G_MARK_TO_DELETE) AND
                  PRIOR deleted_flag IN(G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH,G_MARK_TO_DELETE));

Line: 11292

      UPDATE CZ_UI_PAGE_REFS
         SET deleted_flag = G_YES_FLAG
       WHERE ui_def_id=p_ui_node.ui_def_id AND
             target_persistent_node_id=p_ui_node.persistent_node_id AND
             deleted_flag=G_NO_FLAG AND
             target_page_id NOT IN(SELECT page_id FROM CZ_UI_PAGES
             WHERE ui_def_id=g_UI_Context.ui_def_id);

Line: 11304

        UPDATE CZ_UI_REFS
           SET deleted_flag = G_YES_FLAG
         WHERE ui_def_id=p_ui_node.ui_def_id AND
               ref_persistent_node_id=p_ui_node.persistent_node_id AND
               deleted_flag=G_NO_FLAG AND NOT EXISTS
               (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
                WHERE ui_def_id=p_ui_node.ui_def_id AND
                      persistent_node_id=p_ui_node.persistent_node_id AND
                      deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,G_MARK_TO_REFRESH));

Line: 11322

  END delete_UI_Element;

Line: 11336

        SELECT MIN(page_ref_id) INTO l_page_ref_id
          FROM CZ_UI_PAGE_REFS
         WHERE ui_def_id=p_ui_node.ui_def_id AND
               target_page_id=p_ui_node.page_id AND
               deleted_flag=G_NO_FLAG;

Line: 11342

        UPDATE CZ_UI_PAGE_REFS
           SET deleted_flag = G_YES_FLAG
         WHERE ui_def_id=p_ui_node.ui_def_id AND
               page_ref_id=l_page_ref_id
            RETURNING parent_page_ref_id,page_set_id,seq_nbr
                 INTO l_parent_page_ref_id,l_page_set_id,l_seq_nbr;

Line: 11353

        UPDATE CZ_UI_PAGE_REFS
           SET seq_nbr = seq_nbr - 1
         WHERE ui_def_id=p_ui_node.ui_def_id AND
               page_set_id=l_page_set_id AND
               parent_page_ref_id = l_parent_page_ref_id AND
               seq_nbr > l_seq_nbr AND
               deleted_flag=G_NO_FLAG;

Line: 11367

  PROCEDURE delete_Related_Buttons(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
    l_suppress_refresh_flag     CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;

Line: 11371

    FOR i IN(SELECT element_id,parent_element_id,page_id,suppress_refresh_flag
               FROM CZ_UI_PAGE_ELEMENTS a
              WHERE ui_def_id=p_ui_node.ui_def_id AND
                    persistent_node_id=p_ui_node.persistent_node_id AND
                    element_type IN(G_UI_BOMADDINST_NODE_TYPE,
                                    G_UI_NONBOMADDINST_NODE_TYPE,
                                    G_UI_PAGEDRILLDOWN_NODE_TYPE) AND
                    deleted_flag NOT IN(G_YES_FLAG, G_LIMBO_FLAG))
    LOOP

       IF i.parent_element_id IS NOT NULL THEN
         BEGIN
           l_suppress_refresh_flag := G_NO_FLAG;

Line: 11384

           SELECT NVL(suppress_refresh_flag,G_NO_FLAG) INTO l_suppress_refresh_flag
             FROM CZ_UI_PAGE_ELEMENTS
            WHERE ui_def_id  = p_ui_node.ui_def_id AND
                  page_id = i.page_id AND
                  element_id=i.parent_element_id;

Line: 11396

         UPDATE CZ_UI_PAGE_ELEMENTS
            SET deleted_flag = G_MARK_TO_DEASSOCIATE,
                persistent_node_id=0
          WHERE ui_def_id  = p_ui_node.ui_def_id AND
                page_id = i.page_id AND
                element_id = i.element_id;

Line: 11403

         UPDATE CZ_UI_PAGE_ELEMENTS
            SET deleted_flag = G_MARK_TO_DELETE
          WHERE ui_def_id  = p_ui_node.ui_def_id AND
                page_id = i.page_id AND
                element_id = i.element_id;

Line: 11414

  END delete_Related_Buttons;

Line: 11419

  PROCEDURE delete_UI_Container(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
      TYPE number_tbl_type        IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line: 11435

      SELECT element_id, parent_element_id, persistent_node_id,page_id, NVL(suppress_refresh_flag,G_NO_FLAG)
        BULK COLLECT INTO l_element_id_tbl, l_parent_element_id_tbl, l_persistent_node_id_tbl,
                         l_page_id_tbl, l_suppress_refresh_flag_tbl
        FROM CZ_UI_PAGE_ELEMENTS
       WHERE ui_def_id=p_ui_node.ui_def_id AND
             page_id=p_ui_node.page_id AND
             deleted_flag NOT IN(G_YES_FLAG);

Line: 11443

       delete_Related_Buttons(p_ui_node);

Line: 11448

       mark_UI_Page_As_Deleted(p_ui_node.page_id, p_ui_node.ui_def_id);

Line: 11457

      SELECT element_id,persistent_node_id,page_id, suppress_refresh_flag
        BULK COLLECT INTO  l_element_id_tbl, l_persistent_node_id_tbl,
                           l_page_id_tbl, l_suppress_refresh_flag_tbl
        FROM CZ_UI_PAGE_ELEMENTS
       START WITH ui_def_id=p_ui_node.ui_def_id AND
                  page_id=p_ui_node.page_id AND
                  element_id=p_ui_node.element_id
       CONNECT BY PRIOR element_id=parent_element_id AND
                        ui_def_id=p_ui_node.ui_def_id AND PRIOR
                        ui_def_id=p_ui_node.ui_def_id;

Line: 11482

          SELECT NVL(suppress_refresh_flag,G_NO_FLAG) INTO l_suppress_refresh_flag
            FROM CZ_UI_PAGE_ELEMENTS
           WHERE ui_def_id  = p_ui_node.ui_def_id AND
                 page_id = p_ui_node.page_id AND
                 element_id=l_parent_element_id_tbl(i);

Line: 11494

        UPDATE CZ_UI_PAGE_ELEMENTS
           SET deleted_flag = G_MARK_TO_DEASSOCIATE,
               persistent_node_id=0
         WHERE ui_def_id  = p_ui_node.ui_def_id AND
               page_id = p_ui_node.page_id AND
               element_id = l_element_id_tbl(i);

Line: 11501

        UPDATE CZ_UI_PAGE_ELEMENTS
           SET deleted_flag = G_MARK_TO_DELETE
         WHERE ui_def_id  = p_ui_node.ui_def_id AND
               page_id = p_ui_node.page_id AND
               element_id = l_element_id_tbl(i);

Line: 11508

      UPDATE CZ_UI_ACTIONS
         SET deleted_flag=G_YES_FLAG
       WHERE ui_def_id=p_ui_node.ui_def_id AND
             source_page_id=p_ui_node.page_id AND
             element_id=l_element_id_tbl(i);

Line: 11515

  END delete_UI_Container;

Line: 11517

  PROCEDURE handle_Deleted_Nodes(p_ui_def_id IN NUMBER) IS

    l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;

Line: 11524

    UPDATE CZ_UI_PAGE_REFS uiref
      SET deleted_flag=G_YES_FLAG
    WHERE ui_def_id=p_ui_def_id AND target_ui_def_id IS NOT NULL AND
           NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a
           WHERE a.devl_project_id=(SELECT b.devl_project_id FROM CZ_UI_DEFS b
           WHERE b.ui_def_id=p_ui_def_id) AND
           persistent_node_id=uiref.target_persistent_node_id AND deleted_flag=G_NO_FLAG)
           AND deleted_flag=G_NO_FLAG;

Line: 11533

    UPDATE CZ_UI_REFS uiref
       SET deleted_flag=G_YES_FLAG
     WHERE ui_def_id=p_ui_def_id AND
           NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a
           WHERE a.devl_project_id=(SELECT b.devl_project_id FROM CZ_UI_DEFS b
           WHERE b.ui_def_id=p_ui_def_id) AND
           persistent_node_id=uiref.ref_persistent_node_id AND deleted_flag=G_NO_FLAG)
           AND deleted_flag=G_NO_FLAG;

Line: 11542

  END handle_Deleted_Nodes;

Line: 11547

  PROCEDURE delete_UI_Page(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS

    l_page_set_id               CZ_UI_PAGE_SETS.page_set_id%TYPE;

Line: 11564

    delete_UI_Container(p_ui_node);

Line: 11566

  END delete_UI_Page;

Line: 11571

  PROCEDURE delete_UI_Region(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
  BEGIN
    delete_UI_Container(p_ui_node);

Line: 11574

  END delete_UI_Region;

Line: 11587

    SELECT page_set_id,pagebase_path INTO l_page_set_id,l_old_page_path_from_root FROM CZ_UI_PAGES
    WHERE page_id=p_page_id AND ui_def_id=g_UI_Context.ui_def_id;

Line: 11594

      UPDATE CZ_UI_PAGES
         SET pagebase_path=l_page_path_from_root,
             deleted_flag=DECODE(deleted_flag,G_MARK_TO_ADD,G_MARK_TO_ADD,G_MARK_TO_REFRESH)
       WHERE page_id=p_page_id AND
             ui_def_id=g_UI_Context.ui_def_id AND
             deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 11603

          UPDATE CZ_UI_PAGE_REFS
            SET target_path=l_target_path
          WHERE ui_def_id=g_UI_Context.ui_def_id AND
                target_page_id=p_page_id;

Line: 11619

      FOR i in (SELECT page_set_id, page_ref_id
                FROM CZ_UI_PAGE_REFS
                WHERE ui_def_id = g_UI_Context.ui_def_id
                AND target_ui_def_id IS NOT NULL
                AND target_page_id IS NOT NULL
                AND target_persistent_node_id = p_node.persistent_node_id
                AND deleted_flag = G_NO_FLAG)

      LOOP
        l_target_path := get_Page_Path(p_node.ps_node_id, i.page_set_id);

Line: 11630

        UPDATE CZ_UI_PAGE_REFS
          SET target_path=l_target_path
        WHERE ui_def_id=g_UI_Context.ui_def_id
        AND page_set_id = i.page_set_id
        AND page_ref_id = i.page_ref_id;

Line: 11638

      FOR i in (SELECT page_id
                FROM CZ_UI_PAGES
                WHERE ui_def_id = g_UI_Context.ui_def_id
                AND persistent_node_id = p_node.persistent_node_id
                AND deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG))
      LOOP
        replace_page_ref_target_path(p_node, i.page_id);

Line: 11681

      SELECT suppress_refresh_flag INTO l_page_set_suppress_flag FROM CZ_UI_PAGE_SETS
      WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id;

Line: 11686

      SELECT page_ref_type, node_depth
        INTO l_page_ref_type, l_node_depth
        FROM CZ_UI_PAGE_REFS
       WHERE ui_def_id=g_UI_Context.ui_def_id AND
             page_ref_id=p_page_ref_id AND
             deleted_flag=G_NO_FLAG;

Line: 11695

        SELECT MIN(page_ref_id)
          INTO x_new_parent_page_ref_id
          FROM CZ_UI_PAGE_REFS
         WHERE ui_def_id=g_UI_Context.ui_def_id AND
               target_persistent_node_id=p_node.parent_persistent_node_id AND
               deleted_flag=G_NO_FLAG;

Line: 11702

        SELECT node_depth
          INTO l_new_parent_node_depth
          FROM CZ_UI_PAGE_REFS
         WHERE ui_def_id=g_UI_Context.ui_def_id AND
               page_ref_id=x_new_parent_page_ref_id;

Line: 11717

          UPDATE CZ_UI_PAGE_REFS
             SET deleted_flag=G_YES_FLAG
           WHERE ui_def_id=g_UI_Context.ui_def_id AND
                 page_ref_id=p_page_ref_id AND
                 deleted_flag=G_NO_FLAG;

Line: 11729

          UPDATE CZ_UI_PAGE_REFS
             SET parent_page_ref_id = x_new_parent_page_ref_id,
                 seq_nbr = p_node.tree_seq
           WHERE ui_def_id=g_UI_Context.ui_def_id AND
                 page_ref_id=p_page_ref_id;

Line: 11735

          UPDATE CZ_UI_PAGE_REFS
             SET node_depth = node_depth + (l_new_parent_node_depth-l_node_depth) + 1
           WHERE (ui_def_id,page_ref_id) IN
                (SELECT ui_def_id,page_ref_id FROM CZ_UI_PAGE_REFS
                 START WITH ui_def_id=g_UI_Context.ui_def_id AND page_ref_id=p_page_ref_id
                 CONNECT BY PRIOR page_ref_id=parent_page_ref_id AND
                 ui_def_id=g_UI_Context.ui_def_id AND PRIOR ui_def_id=g_UI_Context.ui_def_id AND
                 deleted_flag=G_NO_FLAG AND PRIOR deleted_flag=G_NO_FLAG);

Line: 11765

      SELECT page_set_id INTO l_page_set_id FROM CZ_UI_PAGES
       WHERE page_id=p_ui_node.page_id AND ui_def_id=g_UI_Context.ui_def_id;

Line: 11768

      SELECT page_ref_id, parent_page_ref_id
        INTO l_page_ref_id, x_new_parent_page_ref_id
        FROM CZ_UI_PAGE_REFS
       WHERE ui_def_id=g_UI_Context.ui_def_id AND
             page_set_id = l_page_set_id AND
             target_page_id = p_ui_node.page_id AND
             deleted_flag=G_NO_FLAG AND
             rownum < 2;

Line: 11802

    l_mark_flag              CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;

Line: 11807

    SELECT page_set_id INTO l_page_set_id FROM CZ_UI_PAGES
    WHERE page_id=p_ui_node.page_id AND ui_def_id=g_UI_Context.ui_def_id;

Line: 11811

      SELECT suppress_refresh_flag INTO l_page_set_suppress_flag FROM CZ_UI_PAGE_SETS
      WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=l_page_set_id;

Line: 11821

     FOR i IN(SELECT page_id,element_id,parent_element_id,suppress_refresh_flag FROM CZ_UI_PAGE_ELEMENTS
              WHERE ui_def_id=p_ui_node.ui_def_id AND
                    persistent_node_id=p_ui_node.parent_persistent_node_id AND
                            ((region_persistent_node_id=persistent_node_id OR
                                   pagebase_persistent_node_id=persistent_node_id) AND
                                   ctrl_template_id IN( G_CONTAINER_TEMPLATE_ID
                                                        ,G_NSTD_CONTAINER_TEMPLATE_ID
                                                        ,G_2COLS_CONTAINER_TEMPLATE_ID
                                                        ,G_3COLS_CONTAINER_TEMPLATE_ID)) AND
                                   deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE))
    LOOP
      IF i.suppress_refresh_flag=G_YES_FLAG THEN
        UPDATE CZ_UI_PAGE_ELEMENTS
           SET deleted_flag=G_MARK_TO_DEASSOCIATE,
               persistent_node_id=0
         WHERE ui_def_id=p_ui_node.ui_def_id AND
               page_id=i.page_id AND
               persistent_node_id=p_ui_node.persistent_node_id AND
               element_type IN(G_UI_NONBOMADDINST_NODE_TYPE,
                               G_UI_BOMADDINST_NODE_TYPE,
                               G_UI_PAGEDRILLDOWN_NODE_TYPE);

Line: 11843

        UPDATE CZ_UI_PAGE_ELEMENTS
           SET deleted_flag=G_MARK_TO_DELETE
         WHERE ui_def_id=p_ui_node.ui_def_id AND
               page_id=i.page_id AND
               persistent_node_id=p_ui_node.persistent_node_id AND
               element_type IN(G_UI_NONBOMADDINST_NODE_TYPE,
                               G_UI_BOMADDINST_NODE_TYPE,
                               G_UI_PAGEDRILLDOWN_NODE_TYPE);

Line: 11857

      FOR parent_ui_node IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS
                            WHERE ui_def_id=g_UI_Context.ui_def_id AND
                                  persistent_node_id=p_node.parent_persistent_node_id AND
                                  ((region_persistent_node_id=persistent_node_id OR
                                   pagebase_persistent_node_id=persistent_node_id) AND
                                   ctrl_template_id IN( G_CONTAINER_TEMPLATE_ID
                                                        ,G_NSTD_CONTAINER_TEMPLATE_ID
                                                        ,G_2COLS_CONTAINER_TEMPLATE_ID
                                                        ,G_3COLS_CONTAINER_TEMPLATE_ID)) AND
                                   deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE))
      LOOP
        IF NVL(parent_ui_node.suppress_refresh_flag, G_NO_FLAG) = G_NO_FLAG THEN
          IF p_ui_node.instantiable_flag IN(G_OPTIONAL_INST_TYPE,G_MINMAX_INST_TYPE) THEN
            --
            -- add new Instance Management COntrol to the parent UI Page
            --
            add_Instance_Controls(p_ui_node          => p_ui_node,
                                  p_parent_ui_node   => parent_ui_node,
                                  p_node             => p_node);

Line: 11905

        FOR parent_ui_node IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS
                              WHERE ui_def_id=g_UI_Context.ui_def_id AND
                                  persistent_node_id=p_node.parent_persistent_node_id AND
                                  (region_persistent_node_id=persistent_node_id OR
                                   pagebase_persistent_node_id=persistent_node_id) AND
                                   ctrl_template_id IN( G_CONTAINER_TEMPLATE_ID
                                                        ,G_NSTD_CONTAINER_TEMPLATE_ID
                                                        ,G_2COLS_CONTAINER_TEMPLATE_ID
                                                        ,G_3COLS_CONTAINER_TEMPLATE_ID) AND
                                   deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE))
        LOOP
          IF NVL(parent_ui_node.suppress_refresh_flag, G_NO_FLAG) = G_NO_FLAG THEN
            create_Drilldown_Button(p_parent_ui_node => parent_ui_node,
                                    p_ui_node        => p_ui_node,
                                    p_page_set_id    => l_page_set_id);

Line: 11946

      FOR n IN(SELECT ui_def_id,page_id,element_id FROM CZ_UI_PAGE_ELEMENTS a
                WHERE ui_def_id=p_ui_node.ui_def_id AND
                      persistent_node_id=p_ui_node.persistent_node_id AND
                      element_type IN(G_UI_NONBOMADDINST_NODE_TYPE,G_UI_BOMADDINST_NODE_TYPE) AND
                      deleted_flag=G_NO_FLAG AND NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG AND
                      EXISTS(SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
                              WHERE ui_def_id=p_ui_node.ui_def_id AND
                                    page_id=a.page_id AND
                                    element_id=a.parent_element_id AND
                                    NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG)
               )
     LOOP

      l_ui_node_name := get_UI_Node_Name(p_page_id       => n.page_id,
                                         p_template_id   => p_node.template_id,
                                         p_template_name => p_node.template_name);

Line: 11963

      UPDATE CZ_UI_PAGE_ELEMENTS a
      SET ctrl_template_id =  p_node.template_id,
          ctrl_template_ui_def_id = p_node.template_ui_def_id,
          instantiable_flag = p_node.instantiable_flag,
          name=l_ui_node_name,
          deleted_flag=G_MARK_TO_REFRESH
      WHERE ui_def_id=n.ui_def_id AND
            page_id=n.page_id AND
            element_id=n.element_id;

Line: 11985

      FOR parent_ui_node IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS a
                              WHERE ui_def_id=g_UI_Context.ui_def_id AND
                                  persistent_node_id=p_node.parent_persistent_node_id AND
                                  (region_persistent_node_id=persistent_node_id OR
                                   pagebase_persistent_node_id=persistent_node_id) AND
                                   deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE) AND
                                   NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG AND
                                   ctrl_template_id IN( G_CONTAINER_TEMPLATE_ID
                                                        ,G_NSTD_CONTAINER_TEMPLATE_ID
                                                        ,G_2COLS_CONTAINER_TEMPLATE_ID
                                                        ,G_3COLS_CONTAINER_TEMPLATE_ID) AND
                                   NOT EXISTS(SELECT NULL FROM CZ_UI_PAGE_ELEMENTS b
                                               WHERE b.ui_def_id=g_UI_Context.ui_def_id AND
                                                     b.page_id=a.page_id AND
                                                     b.region_persistent_node_id=a.region_persistent_node_id AND
                                                     b.persistent_node_id=p_ui_node.persistent_node_id AND
                                                     b.element_type IN(G_UI_NONBOMADDINST_NODE_TYPE,G_UI_BOMADDINST_NODE_TYPE) AND
                                                     b.deleted_flag NOT IN(G_MARK_TO_DELETE,G_YES_FLAG))
                           )
      LOOP
        --
        -- add new Instance Management Control to the parent UI Page
        --
        add_Instance_Controls(p_ui_node          => p_ui_node,
                              p_parent_ui_node   => parent_ui_node,
                              p_node             => p_node);

Line: 12020

      FOR parent_ui_node IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS
                            WHERE ui_def_id=g_UI_Context.ui_def_id AND
                                  persistent_node_id=p_node.parent_persistent_node_id AND
                                  ((region_persistent_node_id=persistent_node_id OR
                                   pagebase_persistent_node_id=persistent_node_id) AND
                                   ctrl_template_id IN( G_CONTAINER_TEMPLATE_ID
                                                        ,G_NSTD_CONTAINER_TEMPLATE_ID
                                                        ,G_2COLS_CONTAINER_TEMPLATE_ID
                                                        ,G_3COLS_CONTAINER_TEMPLATE_ID)) AND
                                   deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE))
      LOOP
        IF NVL(parent_ui_node.suppress_refresh_flag, G_NO_FLAG) = G_NO_FLAG THEN
          --
          -- add new Instance Management COntrol to the parent UI Page
          --
          add_Instance_Controls(p_ui_node          => p_ui_node,
                                p_parent_ui_node   => parent_ui_node,
                                p_node             => p_node);

Line: 12052

    UPDATE CZ_UI_PAGE_ELEMENTS
       SET instantiable_flag = p_node.instantiable_flag,
           parent_persistent_node_id=p_node.parent_persistent_node_id
     WHERE ui_def_id = p_ui_node.ui_def_id AND
           persistent_node_id = p_ui_node.persistent_node_id;

Line: 12091

         SELECT ps_node_type INTO l_ps_node_type
           FROM CZ_PS_NODES
          WHERE devl_project_id=p_node.reference_id AND
                parent_id IS NULL AND
                deleted_flag=G_NO_FLAG;

Line: 12097

         FOR i IN(SELECT persistent_node_id FROM CZ_UI_PAGE_ELEMENTS
                   WHERE ui_def_id=p_ui_node.ui_def_id
                         AND parent_element_id=p_ui_node.parent_element_id
                         AND persistent_node_id<>p_ui_node.persistent_node_id AND
                         deleted_flag IN(G_NO_FLAG,G_MARK_TO_REFRESH,G_MARK_TO_ADD))
         LOOP
           l_ps_node := get_Model_Node_By_Persist_Id(i.persistent_node_id,g_UI_COntext.devl_project_id);

Line: 12124

      UPDATE CZ_UI_PAGE_ELEMENTS
      SET ctrl_template_id = l_template_id,
          ctrl_template_ui_def_id = l_template_ui_def_id,
          element_type = G_UI_DRILLDOWN_NODE_TYPE,
          instantiable_flag = p_node.instantiable_flag,
          name=l_ui_node_name,
          deleted_flag=G_MARK_TO_REFRESH
      WHERE ui_def_id=p_ui_node.ui_def_id AND
            persistent_node_id=p_ui_node.persistent_node_id AND
            element_type IN(G_UI_NONBOMADDINST_NODE_TYPE,G_UI_BOMADDINST_NODE_TYPE) AND
            deleted_flag=G_NO_FLAG AND
            NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG;

Line: 12155

      UPDATE CZ_UI_PAGE_ELEMENTS
      SET ctrl_template_id = p_node.template_id,
          ctrl_template_ui_def_id = p_node.template_ui_def_id,
          instantiable_flag = p_node.instantiable_flag,
          name=l_ui_node_name,
          deleted_flag=G_MARK_TO_REFRESH
      WHERE ui_def_id=p_ui_node.ui_def_id AND
            persistent_node_id=p_ui_node.persistent_node_id AND
            element_type IN(G_UI_NONBOMADDINST_NODE_TYPE,G_UI_BOMADDINST_NODE_TYPE) AND
            deleted_flag=G_NO_FLAG AND
            NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG;

Line: 12186

      UPDATE CZ_UI_PAGE_ELEMENTS
      SET ctrl_template_id = p_node.template_id,
          ctrl_template_ui_def_id = p_node.template_ui_def_id,
          instantiable_flag = p_node.instantiable_flag,
          element_type = G_UI_NONBOMADDINST_NODE_TYPE,
          name=l_ui_node_name,
          deleted_flag=DECODE(NVL(ctrl_template_id,-1),-1,G_MARK_TO_ADD,G_MARK_TO_REFRESH)
      WHERE ui_def_id=p_ui_node.ui_def_id AND
            page_id=p_ui_node.page_id AND
            element_id=p_ui_node.element_id AND
            NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG;

Line: 12203

     UPDATE CZ_UI_PAGES
        SET deleted_flag=G_MARK_TO_REFRESH,
            page_rev_nbr = page_rev_nbr + 1
      WHERE ui_def_id=p_ui_node.ui_def_id AND
            page_id=p_ui_node.page_id;

Line: 12210

   UPDATE CZ_UI_PAGE_ELEMENTS
      SET instantiable_flag = p_node.instantiable_flag
    WHERE ui_def_id = p_ui_node.ui_def_id AND
          persistent_node_id = p_ui_node.persistent_node_id AND
          instantiable_flag <> p_node.instantiable_flag;

Line: 12216

    FOR i IN(SELECT page_set_id
               FROM CZ_UI_PAGE_REFS
              WHERE ui_def_id=g_UI_Context.ui_def_id AND
                    target_persistent_node_id=p_ui_node.persistent_node_id AND
                    deleted_flag=G_NO_FLAG)
    LOOP
      l_target_path := get_Page_Path(p_node.ps_node_id, i.page_set_id);

Line: 12223

      UPDATE CZ_UI_PAGE_REFS
         SET target_path=l_target_path
       WHERE ui_def_id=g_UI_Context.ui_def_id AND
             target_persistent_node_id=p_ui_node.persistent_node_id AND
             deleted_flag=G_NO_FLAG AND
              target_path<>l_target_path;

Line: 12266

      UPDATE CZ_UI_PAGE_ELEMENTS
      SET ctrl_template_id = l_template_id,
          ctrl_template_ui_def_id = l_template_ui_def_id,
          instantiable_flag = l_instantiable_flag,
          name=l_ui_node_name,
          deleted_flag=G_MARK_TO_REFRESH
      WHERE ui_def_id=p_ui_node.ui_def_id AND
            persistent_node_id=p_ui_node.persistent_node_id AND
            deleted_flag=G_NO_FLAG AND
            NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG;

Line: 12278

        UPDATE CZ_UI_PAGES
           SET deleted_flag=G_MARK_TO_REFRESH,
              page_rev_nbr = page_rev_nbr + 1
         WHERE ui_def_id=p_ui_node.ui_def_id AND
               page_id=p_ui_node.page_id;

Line: 12315

      UPDATE CZ_UI_PAGE_ELEMENTS
         SET deleted_flag=G_MARK_TO_DELETE
       WHERE ui_def_id=p_ui_node.ui_def_id AND
             page_id=p_ui_node.page_id AND
             element_id=p_ui_node.element_id;

Line: 12321

      UPDATE CZ_UI_PAGE_ELEMENTS
         SET page_id = l_page_ui_node.page_id,
             pagebase_persistent_node_id = l_page_ui_node.persistent_node_id,
             deleted_flag=G_MARK_TO_ADD
       WHERE (ui_def_id,page_id,element_id) IN
             (SELECT ui_def_id,page_id,element_id FROM
              CZ_UI_PAGE_ELEMENTS
              START WITH ui_def_id=p_ui_node.ui_def_id AND
                         page_id=p_ui_node.page_id AND
                         element_id=p_ui_node.element_id
              CONNECT BY
                         PRIOR ui_def_id=p_ui_node.ui_def_id AND
                         PRIOR page_id=p_ui_node.page_id AND
                         PRIOR element_id=parent_element_id AND
                         PRIOR deleted_flag <> G_YES_FLAG AND
                         ui_def_id=p_ui_node.ui_def_id AND
                         page_id=p_ui_node.page_id AND
                         deleted_flag <> G_YES_FLAG)
              AND element_id <> p_ui_node.element_id;

Line: 12341

      UPDATE CZ_UI_PAGE_ELEMENTS
         SET parent_element_id=l_page_ui_node.element_id
       WHERE ui_def_id=p_ui_node.ui_def_id AND
             page_id=l_page_ui_node.page_id AND
             parent_element_id=p_ui_node.element_id;

Line: 12368

                            p_insert_index          IN NUMBER DEFAULT -1,
                            p_model_node            IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
                            p_suppress_refresh_flag IN VARCHAR2,
                            x_new_ui_pages_tbl      IN OUT NOCOPY ui_page_elements_tbl_type,
                            x_new_ui_node           OUT NOCOPY CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS

    l_old_page_id   NUMBER;

Line: 12393

              SELECT page_id INTO l_old_page_id FROM CZ_UI_PAGES
              WHERE ui_def_id=g_UI_Context.ui_def_id AND
                    persistent_node_id=p_model_node.persistent_node_id AND
                    deleted_flag IN(G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH) AND
                    rownum<2;

Line: 12415

                                            p_insert_index      => p_insert_index);

Line: 12429

                                               p_insert_index      => p_insert_index);

Line: 12448

      SELECT * FROM CZ_UI_PAGE_ELEMENTS
       WHERE ui_def_id=p_ui_node.ui_def_id AND
             parent_element_id=p_ui_node.element_id AND
             persistent_node_id=p_model_node.persistent_node_id AND
             element_type=G_UI_BOMADDINST_NODE_TYPE AND
             deleted_flag NOT IN(G_YES_FLAG);

Line: 12477

                    IF l_under_root_ui_node.deleted_flag <> G_LIMBO_FLAG AND
                       l_under_root_ui_node.ctrl_template_id IS NOT NULL AND
                       l_under_root_ui_node.ctrl_template_id <> p_model_node.template_id AND
                       NVL(l_under_root_ui_node.suppress_refresh_flag, G_NO_FLAG)=G_NO_FLAG THEN

                       replace_Template_Id(p_ui_node     => l_under_root_ui_node,
                                           p_model_node  => p_model_node);

Line: 12561

           SELECT layout_ui_style INTO l_ui_layout_ui_style
                 FROM CZ_UI_TEMPLATES
                 WHERE template_id=p_ui_node.ctrl_template_id AND
                       ui_def_id=p_ui_node.ctrl_template_ui_def_id;

Line: 12566

                 SELECT layout_ui_style INTO l_model_layout_ui_style
                 FROM CZ_UI_TEMPLATES
                 WHERE template_id=p_model_node.template_id AND
                       ui_def_id=p_model_node.template_ui_def_id;

Line: 12580

                     SELECT NVL(MAX(seq_nbr),0)+1 INTO l_max_seq_nbr FROM CZ_UI_PAGE_ELEMENTS
                     WHERE ui_def_id=g_UI_Context.ui_def_id AND
                           page_id=p_ui_node.page_id AND
                           parent_element_id IS NOT NULL AND
                           (ctrl_template_id,ctrl_template_ui_def_id) IN
                           (SELECT ctrl_template_id,ctrl_template_ui_def_id FROM
                            CZ_UI_TEMPLATES WHERE deleted_flag=G_NO_FLAG AND
                            layout_ui_style=l_ui_layout_ui_style);

Line: 12603

                     UPDATE CZ_UI_PAGE_ELEMENTS
                        SET deleted_flag=G_MARK_TO_DELETE
                      WHERE ui_def_id=g_UI_Context.ui_def_id AND
                            page_id=p_ui_node.page_id AND
                            element_id=p_ui_node.element_id;

Line: 12609

                     UPDATE CZ_UI_PAGES
                        SET deleted_flag=G_MARK_TO_REFRESH,
                            page_rev_nbr=page_rev_nbr+1
                      WHERE page_id=p_ui_node.page_id AND
                            ui_def_id=g_UI_Context.ui_def_id;

Line: 12617

                      INSERT INTO CZ_UI_PAGE_ELEMENTS
                      (
                     UI_DEF_ID
                     ,PAGE_ID
                     ,PERSISTENT_NODE_ID
                     ,ELEMENT_ID
                     ,PARENT_PERSISTENT_NODE_ID
                     ,REGION_PERSISTENT_NODE_ID
                     ,PAGEBASE_PERSISTENT_NODE_ID
                     ,CTRL_TEMPLATE_ID
                     ,BASE_PAGE_FLAG
                     ,INSTANTIABLE_FLAG
                     ,SEQ_NBR
                     ,DELETED_FLAG
                     ,CTRL_TEMPLATE_UI_DEF_ID
                     ,MODEL_REF_EXPL_ID
                     ,PARENT_ELEMENT_ID
                     ,ELEMENT_TYPE
                     ,NAME
                     ,ELEMENT_SIGNATURE_ID
                     ,SUPPRESS_REFRESH_FLAG
                      )
                      SELECT
                     UI_DEF_ID
                     ,PAGE_ID
                     ,PERSISTENT_NODE_ID
                     ,l_feature_element_id
                     ,PARENT_PERSISTENT_NODE_ID
                     ,REGION_PERSISTENT_NODE_ID
                     ,PAGEBASE_PERSISTENT_NODE_ID
                     ,p_model_node.template_id
                     ,BASE_PAGE_FLAG
                     ,INSTANTIABLE_FLAG
                     ,l_max_seq_nbr
                     ,G_MARK_TO_ADD
                     ,p_model_node.template_ui_def_id
                     ,MODEL_REF_EXPL_ID
                     ,PARENT_ELEMENT_ID
                     ,ELEMENT_TYPE
                     ,NAME
                     ,ELEMENT_SIGNATURE_ID
                     ,SUPPRESS_REFRESH_FLAG
                      FROM CZ_UI_PAGE_ELEMENTS
                      WHERE ui_def_id=g_UI_Context.ui_def_id AND
                            page_id=p_ui_node.page_id AND
                            element_id=p_ui_node.element_id;

Line: 12664

                      UPDATE CZ_UI_PAGE_ELEMENTS
                         SET parent_element_id=l_feature_element_id
                       WHERE ui_def_id=g_UI_Context.ui_def_id AND
                             page_id=p_ui_node.page_id AND
                             parent_element_id=p_ui_node.element_id;

Line: 12723

   INSERT INTO CZ_INTL_TEXTS
   (
   INTL_TEXT_ID
   ,TEXT_STR
   ,DELETED_FLAG
   ,SEEDED_FLAG
   ,UI_DEF_ID
   ,MODEL_ID
   ,UI_PAGE_ID
   ,UI_PAGE_ELEMENT_ID
    )
   VALUES
   (
   l_caption_text_id
   ,l_caption
   ,G_NO_FLAG
   ,G_NO_FLAG
   ,g_UI_Context.ui_def_id
   ,g_UI_Context.devl_project_id
   ,l_page_id
   ,NULL
    );

Line: 12746

   INSERT INTO CZ_UI_PAGES
      (page_id,
       ui_def_id,
       NAME,
       persistent_node_id,
       jrad_doc,
       page_set_id,
       split_seq_nbr,
       caption_source,
       caption_text_id,
       PERSISTENT_CAPTION_TEXT_ID,
       pagebase_path,
       pagebase_expl_node_id,
       page_rev_nbr,
       seeded_flag,
       DESC_TEXT,
       PAGE_STATUS_TEMPLATE_ID,
       PAGE_STATUS_TEMPL_UIDEF_ID,
       CAPTION_RULE_ID,
       OUTER_TEMPLATE_USAGE,
       OUTER_PAGE_TEMPLATE_ID,
       OUTER_PAGE_TEMPL_UIDEF_ID,
       DISPLAY_CONDITION_ID,
       DISPLAY_CONDITION_COMP,
       DISPLAY_CONDITION_VALUE,
       ENABLED_CONDITION_ID,
       ENABLED_CONDITION_COMP,
       ENABLED_CONDITION_VALUE,
       EMPTY_PAGE_FLAG,
       SUPPRESS_REFRESH_FLAG,
       deleted_flag)
   SELECT
       l_page_id,
       ui_def_id,
       name||' ('||TO_CHAR(l_split_seq_nbr)||')',
       persistent_node_id,
       jrad_doc||'_'||TO_CHAR(l_split_seq_nbr),
       page_set_id,
       l_split_seq_nbr,
       caption_source,
       l_caption_text_id,
       l_caption_text_id,
       pagebase_path,
       pagebase_expl_node_id,
       1,
       seeded_flag,
       DESC_TEXT,
       PAGE_STATUS_TEMPLATE_ID,
       PAGE_STATUS_TEMPL_UIDEF_ID,
       CAPTION_RULE_ID,
       OUTER_TEMPLATE_USAGE,
       OUTER_PAGE_TEMPLATE_ID,
       OUTER_PAGE_TEMPL_UIDEF_ID,
       DISPLAY_CONDITION_ID,
       DISPLAY_CONDITION_COMP,
       DISPLAY_CONDITION_VALUE,
       ENABLED_CONDITION_ID,
       ENABLED_CONDITION_COMP,
       ENABLED_CONDITION_VALUE,
       EMPTY_PAGE_FLAG,
       SUPPRESS_REFRESH_FLAG,
       G_MARK_TO_ADD
   FROM CZ_UI_PAGES
   WHERE ui_def_id=g_UI_Context.ui_def_id AND
         page_id=p_page_id;

Line: 12812

    SELECT * INTO l_ui_node
    FROM CZ_UI_PAGE_ELEMENTS
    WHERE ui_def_id=g_UI_Context.ui_def_id AND
          page_id=p_page_id AND
          parent_element_id IS NULL AND
          deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,G_MARK_TO_REFRESH);

Line: 12822

    l_ui_node.deleted_flag := G_MARK_TO_ADD;

Line: 12824

    INSERT INTO CZ_UI_PAGE_ELEMENTS
      (ui_def_id,
       persistent_node_id,
       parent_persistent_node_id,
       region_persistent_node_id,
       pagebase_persistent_node_id,
       page_id,
       seq_nbr,
       ctrl_template_id,
       element_id,
       parent_element_id,
       element_type,
       instantiable_flag,
       ctrl_template_ui_def_id,
       model_ref_expl_id,
       base_page_flag,
       element_signature_id,
       name,
       deleted_flag)
   VALUES
       (l_ui_node.ui_def_id,
       l_ui_node.persistent_node_id,
       l_ui_node.parent_persistent_node_id,
       l_ui_node.region_persistent_node_id,
       l_ui_node.pagebase_persistent_node_id,
       l_ui_node.page_id,
       l_ui_node.seq_nbr,
       l_ui_node.ctrl_template_id,
       l_ui_node.element_id,
       l_ui_node.parent_element_id,
       l_ui_node.element_type,
       l_ui_node.instantiable_flag,
       l_ui_node.ctrl_template_ui_def_id,
       l_ui_node.model_ref_expl_id,
       l_ui_node.base_page_flag,
       l_ui_node.element_signature_id,
       l_ui_node.name,
       l_ui_node.deleted_flag);

Line: 12863

    SELECT NVL(MAX(seq_nbr),0) INTO l_seq_nbr
    FROM CZ_UI_PAGE_REFS
    WHERE ui_def_id=g_UI_Context.ui_def_id AND
          target_persistent_node_id=l_ui_node.persistent_node_id AND
          deleted_flag=G_NO_FLAG;

Line: 12869

    UPDATE CZ_UI_PAGE_REFS
       SET seq_nbr=seq_nbr+1
     WHERE ui_def_id=g_UI_Context.ui_def_id AND
           parent_page_ref_id = (SELECT parent_page_ref_id
                                 FROM CZ_UI_PAGE_REFS
                                 WHERE ui_def_id=g_UI_Context.ui_def_id AND
                                       target_page_id=p_page_id AND
                                       deleted_flag=G_NO_FLAG) AND
           seq_nbr > l_seq_nbr AND
           deleted_flag=G_NO_FLAG;

Line: 12883

    INSERT INTO CZ_UI_PAGE_REFS
      (ui_def_id,
       page_set_id,
       page_ref_id,
       parent_page_ref_id,
       seq_nbr,
       node_depth,
       condition_id,
       NAME,
       caption_source,
       caption_text_id,
       target_persistent_node_id,
       target_path,
       target_ui_def_id,
       target_page_set_id,
       target_page_id,
       modified_flags,
       path_to_prev_page,
       path_to_next_page,
       page_ref_type,
       target_expl_node_id,
       deleted_flag)
    SELECT
       ui_def_id,
       page_set_id,
       l_page_ref_id,
       parent_page_ref_id,
       l_seq_nbr,
       node_depth,
       condition_id,
       NAME||' ('||TO_CHAR(l_split_seq_nbr)||')',
       caption_source,
       l_caption_text_id,
       target_persistent_node_id,
       target_path,
       target_ui_def_id,
       target_page_set_id,
       l_page_id,
       modified_flags,
       NULL,
       path_to_next_page,
       page_ref_type,
       target_expl_node_id,
       deleted_flag
    FROM CZ_UI_PAGE_REFS
    WHERE ui_def_id=g_UI_Context.ui_def_id AND
          target_page_id=p_page_id AND
          deleted_flag=G_NO_FLAG;

Line: 12950

    FOR k IN(SELECT page_id,TO_NUMBER(element_id) AS element_id,
             TO_NUMBER(parent_element_id) AS parent_element_id,seq_nbr
             FROM CZ_UI_PAGE_ELEMENTS
             WHERE ui_def_id = p_ui_page_node.ui_def_id AND
                   page_id = p_ui_page_node.page_id AND
                   parent_element_id IS NOT NULL AND
                   element_type <> G_UI_REGION_NODE_TYPE AND
                   ctrl_template_id IS NOT NULL
                   AND deleted_flag IN(G_MARK_TO_ADD,G_MARK_DO_NOT_REFRESH)
          ORDER BY  seq_nbr)
    LOOP
      --
      -- increase counter of nodes on the page ( initial l_counter must be 0 )
      --
      l_counter:=l_counter+1;

Line: 13000

      UPDATE CZ_UI_PAGE_ELEMENTS
         SET page_id = p_elements_tbl(l_current_element_id).page_id
       WHERE ui_def_id =  p_ui_page_node.ui_def_id AND
             page_id = p_ui_page_node.page_id AND
             element_id = TO_CHAR(l_current_element_id);

Line: 13007

        UPDATE CZ_UI_PAGE_ELEMENTS
           SET parent_element_id = p_parent_elements_tbl(l_current_element_id)
         WHERE ui_def_id =  p_ui_page_node.ui_def_id AND
               page_id = p_ui_page_node.page_id AND
               element_id = TO_CHAR(l_current_element_id);

Line: 13014

      UPDATE CZ_UI_ACTIONS
         SET source_page_id=p_elements_tbl(l_current_element_id).page_id
       WHERE ui_def_id=p_ui_page_node.ui_def_id AND
             source_page_id= p_ui_page_node.page_id AND
             element_id=TO_CHAR(l_current_element_id);

Line: 13030

        UPDATE CZ_UI_PAGE_ELEMENTS
           SET parent_element_id = p_parent_elements_tbl(l_current_element_id)
         WHERE ui_def_id =  p_ui_page_node.ui_def_id AND
               page_id = p_elements_tbl(l_current_element_id).page_id  AND
               element_id = TO_CHAR(l_current_element_id);

Line: 13050

    FOR i IN(SELECT DISTINCT parent_element_id FROM CZ_UI_PAGE_ELEMENTS a
             WHERE ui_def_id =  p_ui_def_id AND
                   page_id = p_new_page_id AND
                   parent_element_id IS NOT NULL AND
               NOT EXISTS(SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
               WHERE  ui_def_id =  p_ui_def_id AND
                      page_id = p_new_page_id AND
                      element_id=a.parent_element_id))
      LOOP
        x_nested_page_elements_tbl(x_nested_page_elements_tbl.COUNT+1) := i.parent_element_id;

Line: 13076

    FOR i IN(SELECT element_id,parent_element_id,element_type FROM CZ_UI_PAGE_ELEMENTS
             START WITH ui_def_id =  p_ui_def_id AND
                        page_id= p_page_id AND
                        element_id=p_element_id
             CONNECT BY PRIOR  ui_def_id =  p_ui_def_id AND
                               ui_def_id =  p_ui_def_id AND
                     PRIOR page_id= p_page_id AND page_id= p_page_id AND
                     PRIOR parent_element_id=element_id)
    LOOP
      l_num_element_id := TO_NUMBER(i.element_id);

Line: 13121

      l_nested_rgn_elements_tbl.DELETE;

Line: 13123

      SELECT element_id INTO l_page_root_element_id FROM CZ_UI_PAGE_ELEMENTS
      WHERE ui_def_id=p_ui_def_id AND
            page_id=l_new_page_id AND
            parent_element_id IS NULL AND
            deleted_flag NOT IN(G_YES_FLAG, G_MARK_TO_DELETE);

Line: 13160

          INSERT INTO CZ_UI_PAGE_ELEMENTS
             (UI_DEF_ID
             ,PAGE_ID
             ,PERSISTENT_NODE_ID
             ,ELEMENT_ID
             ,PARENT_ELEMENT_ID
             ,PARENT_PERSISTENT_NODE_ID
             ,REGION_PERSISTENT_NODE_ID
             ,PAGEBASE_PERSISTENT_NODE_ID
             ,CTRL_TEMPLATE_ID
             ,BASE_PAGE_FLAG
             ,INSTANTIABLE_FLAG
             ,SEQ_NBR
             ,DELETED_FLAG
             ,CTRL_TEMPLATE_UI_DEF_ID
             ,MODEL_REF_EXPL_ID
             ,ELEMENT_TYPE
             ,NAME
             ,ELEMENT_SIGNATURE_ID
             ,SUPPRESS_REFRESH_FLAG)
           SELECT
              UI_DEF_ID
             ,l_new_page_id
             ,PERSISTENT_NODE_ID
             ,l_new_element_id
             ,l_new_parent_element_id
             ,PARENT_PERSISTENT_NODE_ID
             ,REGION_PERSISTENT_NODE_ID
             ,pagebase_persistent_node_id
             ,CTRL_TEMPLATE_ID
             ,BASE_PAGE_FLAG
             ,INSTANTIABLE_FLAG
             ,SEQ_NBR
             ,DELETED_FLAG
             ,CTRL_TEMPLATE_UI_DEF_ID
             ,MODEL_REF_EXPL_ID
             ,ELEMENT_TYPE
             ,NAME
             ,ELEMENT_SIGNATURE_ID
             ,SUPPRESS_REFRESH_FLAG
           FROM CZ_UI_PAGE_ELEMENTS
           WHERE ui_def_id=p_ui_def_id AND
                 page_id=p_page_id AND
                 element_id=TO_CHAR(l_old_element_id);

Line: 13205

          UPDATE CZ_UI_PAGE_ELEMENTS
             SET parent_element_id=l_new_element_id
           WHERE ui_def_id=p_ui_def_id AND
                 page_id=l_new_page_id AND
                 parent_element_id=TO_CHAR(l_old_element_id);

Line: 13284

    FOR i IN (SELECT *
                FROM CZ_UI_PAGE_ELEMENTS
               WHERE ui_def_id = g_UI_Context.ui_def_id AND
                     parent_element_id IS NULL AND
                     persistent_node_id=pagebase_persistent_node_id AND
                     NVL(suppress_refresh_flag, G_NO_FLAG) = G_NO_FLAG AND
                     deleted_flag IN (G_MARK_TO_ADD))
    LOOP
      split_Page(i, l_max_controls_per_page);

Line: 13296

      SELECT COUNT(*) INTO l_num_if_roots FROM CZ_UI_PAGE_REFS
      WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL
            AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
            WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
            deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG;

Line: 13303

        SELECT target_persistent_node_id,page_set_id,page_ref_type
          INTO l_target_persistent_node_id,l_page_set_id,l_page_set_type
          FROM CZ_UI_PAGE_REFS
          WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL
               AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
               WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
               deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG AND rownum<2;

Line: 13313

    INSERT INTO CZ_UI_PAGE_REFS
      (ui_def_id,
       page_set_id,
       page_ref_id,
       parent_page_ref_id,
       seq_nbr,
       node_depth,
       condition_id,
       NAME,
       caption_source,
       target_persistent_node_id,
       target_path,
       target_ui_def_id,
       target_page_set_id,
       target_page_id,
       modified_flags,
       path_to_prev_page,
       path_to_next_page,
       page_ref_type,
       target_expl_node_id,
       caption_rule_id,
       deleted_flag)
    VALUES
      (g_UI_Context.ui_def_id,
       l_page_set_id,
       l_page_ref_id,
       NULL,
       0,
       0,
       NULL,
       'Root',
       G_DEFAULT_CAPTION_RULE_ID,
        l_target_persistent_node_id,
       NULL,
       NULL,
       NULL,
       NULL,
       0,
       NULL,
       NULL,
       l_page_set_type,
       NULL,
       NULL,
       G_NO_FLAG);

Line: 13358

      UPDATE CZ_UI_PAGE_REFS
         SET parent_page_ref_id=l_page_ref_id
         WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL AND
            target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
            WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
            deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG;

Line: 13378

       FOR i IN(SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
                WHERE ui_def_id=g_UI_Context.ui_def_id AND
                      page_id=p_page_id AND
                      parent_element_id=p_element_id AND
                      deleted_flag=G_NO_FLAG ORDER BY seq_nbr)
       LOOP
          l_counter := l_counter + 1;

Line: 13385

          UPDATE CZ_UI_PAGE_ELEMENTS
             SET seq_nbr = l_counter
           WHERE ui_def_id=g_UI_Context.ui_def_id AND
                 element_id=i.element_id;

Line: 13394

     FOR i IN(SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
              WHERE ui_def_id=g_UI_Context.ui_def_id AND
                    page_id=p_page_id AND
                    parent_element_id IS NULL AND
                    deleted_flag=G_NO_FLAG ORDER BY seq_nbr)
     LOOP
       set_UI_Order_(i.element_id);

Line: 13409

    FOR i IN(SELECT page_id FROM CZ_UI_PAGES a
             WHERE ui_def_id=g_UI_Context.ui_def_id AND
                   page_set_id IN
                   (SELECT page_set_id FROM CZ_UI_PAGE_SETS
                    WHERE ui_def_id=g_UI_Context.ui_def_id AND
                          page_set_id=a.page_set_id AND
                          page_set_type=G_SINGLE_PAGE AND
                          deleted_flag=G_NO_FLAG) AND
                    NVL(suppress_refresh_flag, G_NO_FLAG)=G_NO_FLAG AND
                   deleted_flag=G_NO_FLAG)
    LOOP
      set_UI_Page_Elements_Order(i.page_id);

Line: 13438

       FOR i IN(SELECT page_ref_id,target_page_id,empty_page_flag,
                        NVL(modified_flags,0) AS modified_flags FROM CZ_UI_PAGE_REFS
                WHERE ui_def_id=g_UI_Context.ui_def_id AND
                      parent_page_ref_id=p_page_ref_id AND
                      target_page_id IN
                      (SELECT page_id FROM CZ_UI_PAGES
                       WHERE ui_def_id=g_UI_Context.ui_def_id AND
                             deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,
                             G_MARK_TO_REFRESH))
                      AND
                      deleted_flag=G_NO_FLAG ORDER BY seq_nbr)
       LOOP
          l_counter := l_counter + 1;

Line: 13453

            UPDATE CZ_UI_PAGE_REFS
               SET seq_nbr = l_counter
             WHERE ui_def_id=g_UI_Context.ui_def_id AND
                   page_ref_id=i.page_ref_id;

Line: 13465

    FOR n IN(SELECT page_set_id
               FROM CZ_UI_PAGE_SETS
              WHERE ui_def_id=g_UI_Context.ui_def_id AND
                    page_set_type IN(G_PAGE_FLOW,G_SUBTABS) AND
                    deleted_flag=G_NO_FLAG)
    LOOP
      l_counter := 0;

Line: 13472

      FOR m IN(SELECT page_ref_id,seq_nbr,target_page_id,empty_page_flag,
                      NVL(modified_flags,0) AS MODIFIED_FLAGS FROM CZ_UI_PAGE_REFS
               WHERE ui_def_id=g_UI_Context.ui_def_id AND
                     parent_page_ref_id IS NULL AND
                     page_set_id=n.page_set_id AND
                     target_page_id IN
                     (SELECT page_id FROM CZ_UI_PAGES
                      WHERE ui_def_id=g_UI_Context.ui_def_id AND
                            page_set_id=n.page_set_id AND
                            deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH,
                            G_NO_FLAG)) AND
                     deleted_flag=G_NO_FLAG ORDER BY seq_nbr)
      LOOP
        -- Find the first unmodifid page ref. This is basically the first page ref
        -- generated by UiGen. Once we have this, we recursively set the seq_nbrs
        -- by traversing the page_refs structure in depth first order.
        IF m.MODIFIED_FLAGS = 0 THEN
          IF l_counter=0 THEN
            l_page_ref_id := m.page_ref_id;

Line: 13501

    FOR n IN(SELECT page_set_id,persistent_node_id,pagebase_expl_node_id
               FROM CZ_UI_PAGE_SETS
              WHERE ui_def_id=g_UI_Context.ui_def_id AND
                    deleted_flag=G_NO_FLAG)
    LOOP

      FOR m IN(SELECT page_ref_id,seq_nbr,target_page_id,empty_page_flag,
                      target_persistent_node_id, target_expl_node_id
               FROM CZ_UI_PAGE_REFS
               WHERE ui_def_id=g_UI_Context.ui_def_id AND
                     parent_page_ref_id IS NULL AND
                     page_set_id=n.page_set_id AND
                     target_page_id IN
                     (SELECT page_id FROM CZ_UI_PAGES
                      WHERE ui_def_id=g_UI_Context.ui_def_id AND
                            page_set_id=n.page_set_id AND
                            deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH,
                            G_NO_FLAG)) AND
                     deleted_flag=G_NO_FLAG)
      LOOP

        l_target_path := CZ_DEVELOPER_UTILS_PVT.runtime_relative_path(p_base_expl_id => n.pagebase_expl_node_id,
                                                     p_base_pers_id => n.persistent_node_id,
                                                     p_node_expl_id => m.target_expl_node_id,
                                                     p_node_pers_id => m.target_persistent_node_id);

Line: 13530

        UPDATE CZ_UI_PAGE_REFS
           SET target_path=l_target_path
         WHERE ui_def_id=g_UI_Context.ui_def_id AND
               page_set_id=n.page_set_id AND
               target_persistent_node_id=m.target_persistent_node_id AND
               target_path<>l_target_path AND
               deleted_flag=G_NO_FLAG;

Line: 13552

    l_delete_in_model BOOLEAN;

Line: 13570

    FOR i IN (SELECT *
                FROM CZ_UI_PAGE_ELEMENTS
               WHERE ui_def_id = p_parent_ui_node.ui_def_id AND
                     page_id=p_parent_ui_node.page_id AND
                     parent_element_id=p_parent_ui_node.element_id AND
                     deleted_flag IN (G_NO_FLAG,
                                      G_MARK_TO_ADD,
                                      G_MARK_TO_REFRESH,
                                      G_MARK_TO_DELETE))
    LOOP
      IF  i.element_type=G_UI_CX_BUTTON_NODE_TYPE THEN
        BEGIN
          l_ps_node_type := NULL;

Line: 13583

          SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES
          WHERE devl_project_id=g_UI_Context.devl_project_id AND
                persistent_node_id=i.persistent_node_id;

Line: 13592

      l_delete_in_model := TRUE;

Line: 13593

      FOR h IN(SELECT NULL FROM CZ_PS_NODES
               WHERE devl_project_id=g_UI_Context.devl_project_id AND
                     persistent_node_id=i.persistent_node_id AND
                     deleted_flag=G_NO_FLAG)
      LOOP
        l_delete_in_model := FALSE;

Line: 13621

            delete_UI_Page(i);

Line: 13628

            delete_UI_Region(i);

Line: 13634

            delete_UI_Element(i, p_suppress_refresh_flag, l_delete_in_model);

Line: 13639

      IF i.deleted_flag=G_MARK_TO_DELETE THEN
         p_child_nodes_tbl.DELETE(i.persistent_node_id);

Line: 13650

  PROCEDURE delete_UI_Nodes
  (
  p_nodes_tbl             OUT NOCOPY model_nodes_tbl_type,
  px_ui_nodes_tbl         IN OUT NOCOPY ui_page_elements_tbl_type,
  p_suppress_refresh_flag IN VARCHAR2
  ) IS

    l_current_ui_index  NUMBER;

Line: 13683

          delete_UI_Page(l_current_ui_node);

Line: 13690

          delete_UI_Region(l_current_ui_node);

Line: 13696

          delete_UI_Element(l_current_ui_node, p_suppress_refresh_flag);

Line: 13702

      IF l_current_ui_node.deleted_flag=G_MARK_TO_DELETE THEN
        px_ui_nodes_tbl.DELETE(l_current_ui_node.persistent_node_id);

Line: 13709

  END delete_UI_Nodes;

Line: 13723

    SELECT persistent_node_id,split_seq_nbr
      INTO l_page_persistent_node_id, px_page_split_seq_nbr FROM CZ_UI_PAGES
     WHERE page_id=p_parent_ui_node.page_id AND ui_def_id=g_UI_Context.ui_def_id;

Line: 13728

      SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual
      WHERE EXISTS
      (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
       WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id IN(SELECT page_id FROM CZ_UI_PAGES
                      WHERE ui_def_id=g_UI_Context.ui_def_id AND persistent_node_id=l_page_persistent_node_id AND
                      split_seq_nbr>1 AND deleted_flag NOT IN(G_YES_FLAG)) AND
                      persistent_node_id=p_current_model_node.persistent_node_id AND
                      deleted_flag NOT IN(G_YES_FLAG));

Line: 13737

      SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual
      WHERE EXISTS
      (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
       WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id IN(SELECT page_id FROM CZ_UI_PAGES
                      WHERE ui_def_id=g_UI_Context.ui_def_id AND persistent_node_id=l_page_persistent_node_id AND
                      split_seq_nbr<>px_page_split_seq_nbr AND deleted_flag NOT IN(G_YES_FLAG)) AND
                      persistent_node_id=p_current_model_node.persistent_node_id AND
                      deleted_flag NOT IN(G_YES_FLAG));

Line: 13796

    IF l_ps_node.deleted_flag=G_YES_FLAG OR l_ps_node.ps_node_id IS NULL OR
       l_ps_node.ui_omit=G_YES_FLAG THEN
         IF l_ui_node.pagebase_persistent_node_id=l_ui_node.persistent_node_id THEN -- UI page
            --
            -- delete UI page or deassociate UI page from model nodes
            --
            delete_UI_Page(l_ui_node);

Line: 13809

            delete_UI_Region(l_ui_node);

Line: 13815

            delete_UI_Element(l_ui_node,p_suppress_refresh_flag, TRUE);

Line: 13913

    l_element_id_tbl.DELETE;

Line: 13914

    l_page_id_tbl.DELETE;

Line: 13915

    l_suppress_refresh_flag_tbl.DELETE;

Line: 13920

    SELECT element_id, page_id, suppress_refresh_flag
    BULK COLLECT INTO l_element_id_tbl, l_page_id_tbl, l_suppress_refresh_flag_tbl
    FROM CZ_UI_PAGE_ELEMENTS
    WHERE ui_def_id = g_UI_Context.ui_def_id AND
          page_id=p_page_id AND
          parent_element_id = l_ui_node.element_id AND
          deleted_flag IN(G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH) AND
          (element_type IN(G_UI_PAGE_NODE_TYPE,G_UI_REGION_NODE_TYPE));

Line: 13972

    SELECT G_YES_FLAG INTO l_flag
      FROM CZ_UI_PAGE_ELEMENTS
     WHERE ui_def_id=g_UI_Context.ui_def_id AND
           page_id=p_page_id AND
           parent_element_id IS NOT NULL AND
           deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE) AND
           rownum<2;

Line: 14000

    FOR i IN(SELECT page_ref_id,
                    target_page_id,target_persistent_node_id,
                    NVL(empty_page_flag,G_NO_FLAG) AS empty_page_flag FROM CZ_UI_PAGE_REFS
             WHERE ui_def_id=g_UI_Context.ui_def_id AND deleted_flag=G_NO_FLAG AND
                   target_page_id IN(SELECT page_id FROM CZ_UI_PAGES
                   WHERE ui_def_id=g_UI_Context.ui_def_id AND
                         NVL(suppress_refresh_flag, G_NO_FLAG)=G_NO_FLAG AND
                         deleted_flag IN(G_NO_FLAG,G_MARK_TO_REFRESH,G_MARK_TO_ADD) ))
     LOOP

       -- check page - is it empty or no ?
       l_empty_page := is_Empty_Page(i.target_page_id);

Line: 14015

          UPDATE CZ_UI_PAGE_REFS
             SET empty_page_flag=G_YES_FLAG
           WHERE ui_def_id=g_UI_Context.ui_def_id AND
                 page_ref_id=i.page_ref_id AND NVL(modified_flags,0)=0;

Line: 14021

            UPDATE CZ_UI_PAGES
               SET empty_page_flag=G_YES_FLAG
             WHERE page_id=i.target_page_id AND
                   ui_def_id=g_UI_Context.ui_def_id;

Line: 14029

          UPDATE CZ_UI_PAGE_REFS
             SET empty_page_flag=G_NO_FLAG
           WHERE ui_def_id=g_UI_Context.ui_def_id AND
                 page_ref_id=i.page_ref_id AND NVL(modified_flags,0)=0;

Line: 14035

            UPDATE CZ_UI_PAGES
               SET empty_page_flag=G_NO_FLAG
             WHERE page_id=i.target_page_id AND
                   ui_def_id=g_UI_Context.ui_def_id;

Line: 14054

       FOR i IN(SELECT page_ref_id FROM CZ_UI_PAGE_REFS a
                WHERE ui_def_id=g_UI_Context.ui_def_id AND
                      parent_page_ref_id=p_page_ref_id AND
                      EXISTS
                      (SELECT NULL FROM CZ_UI_PAGES
                       WHERE page_id=a.target_page_id AND ui_def_id=g_UI_Context.ui_def_id) AND
                      deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH,G_NO_FLAG) ORDER BY seq_nbr)
       LOOP
         l_counter := l_counter + 1;

Line: 14063

         UPDATE CZ_UI_PAGE_REFS
            SET seq_nbr = l_counter
          WHERE ui_def_id=g_UI_Context.ui_def_id AND
                page_ref_id=i.page_ref_id;

Line: 14072

    FOR i IN(SELECT page_ref_id,target_page_id,target_persistent_node_id FROM CZ_UI_PAGE_REFS
             WHERE ui_def_id=g_UI_Context.ui_def_id AND
                   page_set_id=p_page_set_id AND
                   parent_page_ref_id IS NULL AND
                   deleted_flag=G_NO_FLAG)
    LOOP
      SELECT NVL(split_seq_nbr,1) INTO l_split_seq_nbr
      FROM CZ_UI_PAGES
      WHERE page_id=i.target_page_id AND
            ui_def_id=g_UI_Context.ui_def_id;

Line: 14084

        UPDATE CZ_UI_PAGE_REFS
           SET seq_nbr = l_split_seq_nbr
         WHERE ui_def_id=g_UI_Context.ui_def_id AND
               page_ref_id=i.page_ref_id;

Line: 14090

        UPDATE CZ_UI_PAGE_REFS
           SET seq_nbr = 1
         WHERE ui_def_id=g_UI_Context.ui_def_id AND
               page_ref_id=i.page_ref_id;

Line: 14094

        SELECT MAX(split_seq_nbr) INTO l_counter FROM CZ_UI_PAGES
        WHERE ui_def_id=g_UI_Context.ui_def_id AND
              persistent_node_id=i.target_persistent_node_id AND
              deleted_flag IN (G_MARK_TO_ADD,G_MARK_TO_REFRESH,G_NO_FLAG);

Line: 14109

    FOR i IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS
             WHERE ui_def_id=g_UI_Context.ui_def_id AND
                   page_set_type=G_SINGLE_LEVEL_MENU AND
                   deleted_flag=G_NO_FLAG)
    LOOP
      set_SLMenu_Order(i.page_set_id);

Line: 14122

    FOR i IN(SELECT page_id,pagebase_expl_node_id FROM CZ_UI_PAGES
             WHERE ui_def_id=g_UI_Context.ui_def_id AND
                   deleted_flag NOT IN(G_LIMBO_FLAG,G_MARK_TO_DELETE,G_YES_FLAG))
    LOOP
      FOR k IN(SELECT element_id,persistent_node_id,model_ref_expl_id,name
                 FROM CZ_UI_PAGE_ELEMENTS
                WHERE ui_def_id=g_UI_Context.ui_def_id AND
                      page_id=i.page_id AND
                      deleted_flag NOT IN(G_LIMBO_FLAG,G_MARK_TO_DELETE,G_YES_FLAG))
      LOOP
        BEGIN
          l_node_is_reachable :=CZ_DEVELOPER_UTILS_PVT.in_boundary(i.pagebase_expl_node_id,
                                                                   k.model_ref_expl_id,
                                                                   k.persistent_node_id);

Line: 14162

                                 x_insert_index OUT NOCOPY NUMBER,
                                 x_refresh_enabled_parent_found OUT NOCOPY BOOLEAN,
                                 x_atleast_one_parent_found OUT NOCOPY BOOLEAN) IS

      l_parent_ps_node          CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

Line: 14192

          IF p_ord_siblings(i).deleted_flag = G_NO_FLAG AND p_ord_siblings(i).creation_date < g_UI_Context.ui_timestamp_refresh THEN
            l_successor := p_ord_siblings(i);

Line: 14207

        FOR i IN (SELECT *
                  FROM CZ_UI_PAGE_ELEMENTS pe1
                  WHERE ui_def_Id = g_UI_Context.ui_def_id
                  AND region_persistent_node_id = l_parent_ps_node.persistent_node_id
                  AND persistent_node_id = l_pred_persistent_node_id
                  AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH)
                  AND parent_element_id IS NOT NULL
                  AND EXISTS ( SELECT 1
                               FROM CZ_UI_PAGE_ELEMENTS pe2
                               WHERE ui_def_Id = g_UI_Context.ui_def_id
                               AND pe2.page_id = pe1.page_id
                               AND pe2.parent_element_id = pe1.parent_element_id
                               AND pe2.persistent_node_id = l_succ_persistent_node_id
                               AND pe2.seq_nbr = pe1.seq_nbr + 1
                               AND deleted_flag = G_NO_FLAG
                 ))
        LOOP

          DEBUG('asp:Found parent with both siblings ' || i.parent_element_id);

Line: 14229

            x_insert_index := i.seq_nbr + 1;

Line: 14241

        FOR i IN (SELECT *
                  FROM CZ_UI_PAGE_ELEMENTS pe1
                  WHERE ui_def_Id = g_UI_Context.ui_def_id
                  AND region_persistent_node_id = l_parent_ps_node.persistent_node_id
                  AND persistent_node_id = l_pred_persistent_node_id
                  AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH)
                  AND parent_element_id IS NOT NULL)
        LOOP
          DEBUG('asp:Found parent with predecessor ' || i.parent_element_id || ' page_id ' || i.page_id);

Line: 14253

            x_insert_index := i.seq_nbr + 1;

Line: 14266

        FOR i IN (SELECT *
                  FROM CZ_UI_PAGE_ELEMENTS pe1
                  WHERE ui_def_Id = g_UI_Context.ui_def_id
                  AND region_persistent_node_id = l_parent_ps_node.persistent_node_id
                  AND persistent_node_id = l_succ_persistent_node_id
                  AND deleted_flag = G_NO_FLAG
                  AND parent_element_id IS NOT NULL)
        LOOP
          DEBUG('asp:Found parent with successor ' || i.parent_element_id || ' i.seq_nbr = ' || i.seq_nbr);

Line: 14278

            x_insert_index := i.seq_nbr;

Line: 14295

        FOR i IN (SELECT parent_element_id, page_id, count(parent_element_id) max_count
                  FROM CZ_UI_PAGE_ELEMENTS pe
                  WHERE ui_def_Id = g_UI_Context.ui_def_id
                  AND parent_persistent_node_id = l_parent_ps_node.persistent_node_id
                  AND pagebase_persistent_node_id <> persistent_node_id
                  AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH)
                  AND parent_element_id IS NOT NULL
                  AND NOT (p_ps_node.ps_node_type <> G_BOM_OPTION_CLASS_TYPE
                           AND ((SELECT NVL(ps_node_type,G_UNDEFINED_DATA_TYPE)
                               FROM CZ_PS_NODES
                               WHERE devl_project_id = p_ps_node.devl_project_id
                                 AND persistent_node_id = pe.persistent_node_id) = G_BOM_OPTION_CLASS_TYPE))
                  GROUP BY parent_element_id, page_id
                  ORDER BY count(parent_element_id) DESC)
        LOOP
          DEBUG('asp:Found parent with max siblings ' || i.parent_element_id || ', page_id ' || i.page_id);

Line: 14315

            x_insert_index := -1;

Line: 14327

        FOR j IN (SELECT *
                  FROM CZ_UI_PAGE_ELEMENTS
                  WHERE ui_def_id = g_UI_Context.ui_def_id AND
                  persistent_node_Id = l_parent_ps_node.persistent_node_id AND
                  deleted_flag IN(G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH) AND
                  element_type IN(G_UI_PAGE_NODE_TYPE,G_UI_REGION_NODE_TYPE))
        LOOP
          DEBUG('asp:Found parent with no siblings ' || j.element_id);

Line: 14338

            x_insert_index := -1;

Line: 14360

    l_insert_index                NUMBER;

Line: 14378

                           l_insert_index,
                           l_parent_node_found,
                           l_atleast_one_parent_found);

Line: 14386

                          p_insert_index          => l_insert_index,
                          p_model_node            => p_ps_node,
                          p_suppress_refresh_flag => G_NO_FLAG,
                          x_new_ui_pages_tbl      => l_next_level_ui_pages_tbl,
                          x_new_ui_node           => x_ui_node);

Line: 14418

                          p_insert_index          => -1,
                          p_model_node            => p_ps_node,
                          p_suppress_refresh_flag => G_NO_FLAG,
                          x_new_ui_pages_tbl      => l_next_level_ui_pages_tbl,
                          x_new_ui_node           => x_ui_node);

Line: 14441

      l_insert_index                NUMBER;

Line: 14451

    FOR i IN (SELECT *
                FROM CZ_UI_PAGE_ELEMENTS pe
                WHERE ui_def_Id = g_UI_Context.ui_def_id
                AND persistent_node_id = p_ps_node.persistent_node_id
                AND deleted_flag = G_NO_FLAG)
      LOOP
        IF i.pagebase_persistent_node_id=i.persistent_node_id THEN -- UI page
              --
              -- delete UI page or deassociate UI page from model nodes
              --
              delete_UI_Page(i);

Line: 14469

              delete_UI_Region(i);

Line: 14482

              delete_UI_Element(i, l_suppress_refresh_flag, TRUE);

Line: 14499

      l_insert_index                NUMBER;

Line: 14526

        FOR i in (SELECT *
                  FROM CZ_UI_PAGE_REFS
                  WHERE ui_def_id = g_UI_Context.ui_def_id
                  AND page_set_id = g_UI_Context.page_set_id
                  AND target_ui_def_id IS NOT NULL
                  AND target_persistent_node_id = p_ps_node.persistent_node_id)
        LOOP
          move_page_ref(i.page_set_id, i.page_ref_id, p_ps_node, l_parent_page_ref_id);

Line: 14539

      FOR i IN (SELECT *
                FROM CZ_UI_PAGE_ELEMENTS pe
                WHERE ui_def_Id = g_UI_Context.ui_def_id
                AND persistent_node_id = p_ps_node.persistent_node_id
                AND region_persistent_node_id <> l_parent_ps_node.persistent_node_id
                AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_DELETE))
      LOOP

        l_model_ref_expl_id := get_Expl_Id(p_model_id     => p_ps_node.devl_project_id,
                                           p_ps_node_id   => p_ps_node.ps_node_id,
                                           p_component_id => p_ps_node.component_id,
                                           p_ps_node_type => p_ps_node.ps_node_type);

Line: 14587

                             l_insert_index,
                             l_parent_node_found,
                             l_atleast_one_parent_found);

Line: 14596

            IF l_insert_index > 0 THEN
              l_max_prev_seq_nbr := l_insert_index-1;

Line: 14599

              SELECT NVL(MAX(seq_nbr),0) INTO l_max_prev_seq_nbr FROM CZ_UI_PAGE_ELEMENTS
              START WITH ui_def_id=g_UI_Context.ui_def_id AND
                     page_id=l_parent_ui_node.page_id AND
                     element_id=l_parent_ui_node.element_id AND
                     deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG)
              CONNECT BY PRIOR ui_def_id=g_UI_Context.ui_def_id AND
                  ui_def_id=g_UI_Context.ui_def_id AND PRIOR page_id= l_parent_ui_node.page_id AND
                  page_id=l_parent_ui_node.page_id AND PRIOR element_id=parent_element_id AND
                  PRIOR deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG) AND
                  deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG);

Line: 14610

                  l_insert_index  := l_max_prev_seq_nbr + 1;

Line: 14613

            SELECT NVL(MAX(seq_nbr),0), NVL(COUNT(seq_nbr), 0) INTO l_max_src_seq_nbr, l_count  FROM CZ_UI_PAGE_ELEMENTS
            START WITH ui_def_id=g_UI_Context.ui_def_id AND
                       page_id=i.page_id AND
                       element_id=i.element_id AND
                       deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG)
            CONNECT BY PRIOR ui_def_id=g_UI_Context.ui_def_id AND
                    ui_def_id=g_UI_Context.ui_def_id AND PRIOR page_id= i.page_id
                    AND page_id=i.page_id AND PRIOR element_id=parent_element_id AND
                    PRIOR deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG) AND
                    deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG);

Line: 14627

            UPDATE CZ_UI_PAGE_ELEMENTS
            SET seq_nbr=seq_nbr+l_src_range
            WHERE ui_def_id=g_UI_Context.ui_def_id AND
                  page_id=l_parent_ui_node.page_id AND
                  seq_nbr>l_max_prev_seq_nbr AND
                  deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG);

Line: 14634

            l_diff := l_insert_index - i.seq_nbr;

Line: 14636

            UPDATE CZ_UI_PAGE_ELEMENTS
            SET seq_nbr=seq_nbr + l_diff,
                page_id=l_parent_ui_node.page_id,
                pagebase_persistent_node_id=l_parent_ui_node.pagebase_persistent_node_id,
                deleted_flag=DECODE(deleted_flag, G_MARK_TO_DELETE, G_NO_FLAG, deleted_flag)
            WHERE ui_def_id=g_UI_Context.ui_def_id AND
                  page_id=i.page_id AND
                  seq_nbr >= i.seq_nbr AND
                  seq_nbr <= l_max_src_seq_nbr AND
                  deleted_flag NOT IN(G_YES_FLAG, G_LIMBO_FLAG);

Line: 14647

            IF i.deleted_flag <> G_MARK_TO_DELETE THEN
              UPDATE CZ_UI_PAGE_ELEMENTS
              SET seq_nbr=seq_nbr - l_count
              WHERE ui_def_id=g_UI_Context.ui_def_id AND
                    page_id=i.page_id AND
                    seq_nbr > l_max_src_seq_nbr AND
                    deleted_flag NOT IN(G_YES_FLAG, G_LIMBO_FLAG);

Line: 14656

            UPDATE CZ_UI_PAGE_ELEMENTS
            SET parent_element_id = l_parent_ui_node.element_id,
                parent_persistent_node_id = l_parent_ps_node.persistent_node_id,
                region_persistent_node_id = l_parent_ui_node.persistent_node_id,
                deleted_flag = G_MARK_TO_MOVE
            WHERE ui_def_id = i.ui_def_id AND
                 page_Id = l_parent_ui_node.page_Id AND
                 element_id = i.element_id;

Line: 14669

            UPDATE CZ_UI_PAGES
              SET page_rev_nbr=page_rev_nbr+1
              WHERE page_id=i.page_id AND ui_def_id=i.ui_def_id;

Line: 14683

            SELECT pagebase_expl_node_id INTO l_pagebase_expl_node_id
              FROM CZ_UI_PAGES
             WHERE ui_def_id=g_UI_Context.ui_def_id
               AND page_id = i.page_id
               AND deleted_flag NOT IN(G_LIMBO_FLAG,G_MARK_TO_DELETE,G_YES_FLAG);

Line: 14704

              UPDATE CZ_UI_PAGE_ELEMENTS
                 SET deleted_flag = G_MARK_TO_DEASSOCIATE,
                     persistent_node_id = 0
               WHERE ui_def_id = i.ui_def_id
                 AND page_id = i.page_id
                 AND element_id IN
                    (SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
                     START WITH ui_def_id=i.ui_def_id
                     AND page_id=i.page_id
                     AND element_id=i.element_id
                     CONNECT BY PRIOR ui_def_id=i.ui_def_id AND
                     page_id = i.page_id AND
                     PRIOR element_id=parent_element_id AND
                        deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH,G_MARK_TO_MOVE));

Line: 14725

              UPDATE CZ_UI_PAGE_ELEMENTS
                 SET deleted_flag = G_MARK_TO_REFRESH
               WHERE ui_def_id = i.ui_def_id
                 AND page_id = i.page_id
                 AND element_id = i.element_id
                 AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_REFRESH);

Line: 14754

      FOR i IN (SELECT *
                FROM CZ_UI_PAGE_ELEMENTS pe
                WHERE ui_def_Id = g_UI_Context.ui_def_id
                AND persistent_node_id = p_ps_node.persistent_node_id
                AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_MOVE))
      LOOP


        -- This piece of code determines if the model_ref_expl_id of this page_element is
        -- different from the current explosion_id of the PS Node. If information is then
        -- used later to fix the explosion_ids
        IF x_model_ref_expl_id_changed <> G_YES_FLAG THEN
          IF i.model_ref_expl_id <> l_model_ref_expl_id THEN
            x_model_ref_expl_id_changed := G_YES_FLAG;

Line: 14787

      SELECT element_id into l_element_id FROM CZ_UI_PAGE_ELEMENTS
                    WHERE ui_def_id=g_UI_Context.ui_def_id
            AND persistent_node_id=p_ps_node.persistent_node_id
            AND deleted_flag=G_NO_FLAG and rownum < 2;

Line: 14818

          SELECT min(seq_nbr), count(*) INTO l_old_seq_nbr, l_count
          FROM CZ_UI_PAGE_REFS
          WHERE ui_def_id = g_UI_Context.ui_def_id
          AND page_set_id = l_page_set_id
          AND target_persistent_node_id = p_ps_node.persistent_node_id
          AND deleted_flag = G_NO_FLAG;

Line: 14825

          SELECT * INTO l_page_ref
          FROM CZ_UI_PAGE_REFS
          WHERE ui_def_id = g_UI_Context.ui_def_id
          AND page_set_id = l_page_set_id
          AND target_persistent_node_id = p_ps_node.persistent_node_id
          AND deleted_flag = G_NO_FLAG
          AND seq_nbr = l_old_seq_nbr
          AND rownum < 2;

Line: 14855

          UPDATE CZ_UI_PAGE_REFS
          SET seq_nbr = seq_nbr - l_count
          WHERE ui_def_id = g_UI_Context.ui_def_id
          AND page_set_id = l_page_set_id
          AND parent_page_ref_id = l_page_ref.parent_page_ref_id
          AND target_persistent_node_id <> p_ps_node.persistent_node_id
          AND deleted_flag = G_NO_FLAG
          AND seq_nbr between l_range_min and l_range_max;

Line: 14866

          UPDATE CZ_UI_PAGE_REFS
          SET seq_nbr = seq_nbr + l_diff
          WHERE ui_def_id = g_UI_Context.ui_def_id
          AND page_set_id = l_page_set_id
          AND parent_page_ref_id = l_page_ref.parent_page_ref_id
          AND target_persistent_node_id = p_ps_node.persistent_node_id
          AND deleted_flag = G_NO_FLAG;

Line: 14897

      FOR i in (SELECT *
                  FROM CZ_UI_PAGE_ELEMENTS
                 WHERE ui_def_id = g_UI_Context.ui_def_id
                   AND persistent_node_id = p_ps_node.persistent_node_id
                   AND deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG))
      LOOP

        IF x_model_ref_expl_changed <> G_YES_FLAG THEN
          IF i.model_ref_expl_id <> l_model_ref_expl_id THEN
            x_model_ref_expl_changed := G_YES_FLAG;

Line: 14988

            AND p_ps_node.deleted_flag = G_NO_FLAG THEN
            -- We need to add UI for this if not already present
            IF NOT ui_node_exits( p_ps_node ) THEN
              add_ui_for_node(p_ps_node, p_ord_siblings, p_ps_node_index, l_new_ui_node);

Line: 15016

      IF p_ps_node.deleted_flag = G_NO_FLAG AND NOT ( l_added_ui OR l_removed_ui ) THEN

        IF NVL(p_ps_node.UI_TIMESTAMP_MOVE, g_UI_Context.UI_TIMESTAMP_REFRESH) > g_UI_Context.UI_TIMESTAMP_REFRESH THEN
          propogate_ps_node_move( p_ps_node, p_ord_siblings, p_ps_node_index, l_model_ref_expl_changed1 );

Line: 15067

            SELECT element_id, page_Id INTO l_bom_table_id, l_page_id
              FROM cz_ui_page_elements
             WHERE ui_def_Id = g_UI_Context.ui_def_id
               AND persistent_node_id = p_ps_node.persistent_node_id
               AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_REFRESH)
               AND element_type = G_UI_BOMADDINST_NODE_TYPE
               AND rownum < 2;

Line: 15083

          IF l_ps_node.deleted_flag = G_NO_FLAG THEN
            l_ps_node_index := l_ps_node_index + 1;

Line: 15104

                      UPDATE CZ_UI_PAGE_ELEMENTS
                         SET deleted_flag=G_MARK_TO_DELETE
                       WHERE ui_def_id=g_UI_Context.ui_def_id
                         AND page_id = l_page_id
                         AND element_Id = l_bom_table_id;

Line: 15120

                    FOR m IN(SELECT page_id, pagebase_expl_node_id FROM CZ_UI_PAGES
                              WHERE ui_def_id=g_UI_Context.ui_def_id AND
                                    deleted_flag IN(G_NO_FLAG, G_MARK_TO_REFRESH)  AND
                                    persistent_node_id = p_ps_node.persistent_node_id)
                    LOOP
                      SELECT element_id, suppress_refresh_flag
                        INTO l_bom_parent_element, l_suppress_refresh_flag
                        FROM CZ_UI_PAGE_ELEMENTS
                       WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=m.page_id AND
                             parent_element_id IS NULL AND persistent_node_id=p_ps_node.persistent_node_id AND
                             pagebase_persistent_node_id=region_persistent_node_id AND
                             pagebase_persistent_node_id=p_ps_node.persistent_node_id AND
                             deleted_flag=G_NO_FLAG;

Line: 15201

    FOR upg IN(SELECT page_id,pagebase_expl_node_id,persistent_node_id FROM CZ_UI_PAGES
                WHERE ui_def_id=g_UI_Context.ui_def_id AND
                      deleted_flag IN(G_MARK_TO_ADD, G_MARK_TO_REFRESH, G_NO_FLAG))
    LOOP
      FOR upgel IN(SELECT element_id,
                          model_ref_expl_id,persistent_node_id FROM CZ_UI_PAGE_ELEMENTS
                    WHERE ui_def_id=g_UI_Context.ui_def_id AND
                          page_id=upg.page_id AND
                          persistent_node_id IN
                          (SELECT psnode.persistent_node_id FROM CZ_PS_NODES psnode
                            WHERE psnode.devl_project_id IN
                                 (SELECT refexpl.component_id FROM CZ_MODEL_REF_EXPLS refexpl
                                   WHERE refexpl.model_id=g_UI_Context.devl_project_id AND
                                         refexpl.ps_node_type=G_REFERENCE_TYPE AND refexpl.deleted_flag='0') AND
                                 psnode.deleted_flag='0'
                                 AND psnode.ui_timestamp_move > NVL(g_UI_Context.ui_timestamp_refresh, g_UI_Context.creation_date)
                          )
                  )
      LOOP
        UPDATE CZ_UI_PAGES
           SET deleted_flag=G_MARK_TO_REFRESH
         WHERE ui_def_id=g_UI_Context.ui_def_id AND
               page_id=upg.page_id AND deleted_flag='0';

Line: 15245

    FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES a
             WHERE devl_project_id=g_UI_Context.devl_project_id AND
                   ps_node_type IN(258,259,436,437) AND
                   deleted_flag=G_YES_FLAG AND EXISTS(SELECT NULL
                   FROM CZ_UI_PAGE_ELEMENTS WHERE ui_def_id=g_UI_Context.ui_def_id AND
                   persistent_node_id=a.persistent_node_id AND deleted_flag=G_NO_FLAG))
    LOOP
      UPDATE CZ_PS_NODES
         SET deleted_flag=G_YES_FLAG
       WHERE ps_node_id IN
       (SELECT ps_node_id FROM CZ_PS_NODES
        START WITH ps_node_id=i.ps_node_id
        CONNECT BY PRIOR ps_node_id=parent_id);

Line: 15260

    FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES a
             WHERE devl_project_id=g_UI_Context.devl_project_id AND
                   ps_node_type IN(258,259,436,437) AND  ui_omit=G_YES_FLAG AND
                   deleted_flag=G_NO_FLAG AND EXISTS(SELECT NULL
                   FROM CZ_UI_PAGE_ELEMENTS WHERE ui_def_id=g_UI_Context.ui_def_id AND
                   persistent_node_id=a.persistent_node_id AND deleted_flag=G_NO_FLAG))
    LOOP
      UPDATE CZ_PS_NODES
         SET deleted_flag=G_YES_FLAG
       WHERE ps_node_id IN
       (SELECT ps_node_id FROM CZ_PS_NODES
        START WITH ps_node_id=i.ps_node_id
        CONNECT BY PRIOR ps_node_id=parent_id);

Line: 15284

      FOR i IN (SELECT ui_def_id, element_id,page_id, suppress_refresh_flag
                  FROM CZ_UI_PAGE_ELEMENTS
                  WHERE ui_def_id = g_UI_Context.ui_def_id AND
                        parent_element_id IS NULL AND
                        deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH))
      LOOP

        refresh_UI_Subtree(p_element_id            => i.element_id,
                           p_page_id               => i.page_id,
                           p_suppress_refresh_flag => i.suppress_refresh_flag);

Line: 15302

    handle_Deleted_Nodes(g_UI_Context.ui_def_id);

Line: 15359

  PROCEDURE delete_UIXML_Elements(p_page_id   IN NUMBER,
                                  p_xml_doc      xmldom.DOMDocument) IS

    l_deleted_nodes_tbl     varchar2_tbl_type;

Line: 15369

    l_deleted_nodes_exist      BOOLEAN := FALSE;

Line: 15375

    FOR i IN(SELECT element_id,deleted_flag FROM CZ_UI_PAGE_ELEMENTS
             WHERE ui_def_id= g_UI_Context.ui_def_id AND
                   page_id=p_page_id AND
                   deleted_flag IN(G_MARK_TO_DELETE,G_MARK_TO_DEASSOCIATE))
    LOOP
      BEGIN
        l_deleted_nodes_tbl(i.element_id) := i.deleted_flag;

Line: 15403

          IF l_deleted_nodes_tbl.EXISTS(l_element_id) THEN

             IF l_deleted_nodes_tbl(l_element_id)=G_MARK_TO_DELETE THEN
               l_parent_node:=xmldom.getParentNode(l_node);

Line: 15408

               l_deleted_nodes_exist := TRUE;

Line: 15425

    IF l_deleted_nodes_exist THEN

      refresh_UI_Node_Marks(p_page_id => p_page_id,
                            p_hmode   => G_DELETE_ELEMENTS);

Line: 15432

      UPDATE CZ_UI_PAGE_ELEMENTS
         SET deleted_flag=G_NO_FLAG
       WHERE ui_def_id=g_UI_Context.ui_def_id AND
             page_id=p_page_id AND
             deleted_flag=G_MARK_TO_DEASSOCIATE;

Line: 15438

        UPDATE CZ_UI_PAGES
           SET page_rev_nbr=page_rev_nbr+1
         WHERE page_id=p_page_id AND
               ui_def_id=g_UI_Context.ui_def_id;

Line: 15444

  END delete_UIXML_Elements;

Line: 15449

  PROCEDURE delete_UIXML_Page(p_page_id   IN NUMBER,
                              p_jrad_doc  IN VARCHAR2) IS

    l_subtree_doc           xmldom.DOMDocument;

Line: 15478

          UPDATE CZ_UI_PAGE_ELEMENTS
             SET deleted_flag=G_MARK_TO_DELETE
           WHERE ui_def_id=g_UI_Context.ui_def_id AND
                 page_id=p_page_id AND
                 deleted_flag NOT IN(G_MARK_TO_DELETE,G_YES_FLAG);

Line: 15490

      delete_UIXML_Elements(p_page_id   => p_page_id,
                            p_xml_doc   => l_subtree_doc);

Line: 15495

        DEBUG('delete_UIXML_Page() : '||SQLERRM);

Line: 15499

      jdr_docbuilder.deleteDocument(p_jrad_doc);

Line: 15502

        DEBUG('delete_UIXML_Page() : '||SQLERRM);

Line: 15509

                          p_hmode   => G_DELETE_PAGE);

Line: 15511

  END delete_UIXML_Page;

Line: 15530

    l_delete_node           BOOLEAN := FALSE;

Line: 15535

    FOR i IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS
             WHERE ui_def_id=g_UI_Context.ui_def_id AND
                   page_id=p_ui_page_id AND
                   element_type=G_UI_CX_BUTTON_NODE_TYPE AND
                   deleted_flag IN(G_NO_FLAG, G_MARK_TO_REFRESH))
    LOOP
       l_element_id := TO_NUMBER(i.element_id);

Line: 15548

           SELECT NVL(suppress_refresh_flag,G_NO_FLAG) INTO l_suppress_refresh_flag
             FROM CZ_UI_PAGE_ELEMENTS
            WHERE ui_def_id=g_UI_Context.ui_def_id AND
                  page_id=p_ui_page_id AND
                  element_id=i.parent_element_id;

Line: 15572

      l_delete_node     := FALSE;

Line: 15589

          ELSIF l_cx_elements_tbl(l_element_id) IN (G_CX_MUST_BE_DELETED) THEN
             l_delete_node := TRUE;

Line: 15602

      IF l_delete_node THEN
        IF l_deassociate_cx THEN
          set_Attribute(l_node, G_USER_ATTRIBUTE1_NAME, 'model_path=*');

Line: 15607

          UPDATE CZ_UI_PAGE_ELEMENTS
             SET persistent_node_id=0
           WHERE ui_def_id=g_UI_Context.ui_def_id AND
                 page_id=p_ui_page_id AND
                 element_id=l_attribute_value;

Line: 15615

          UPDATE CZ_UI_PAGE_ELEMENTS
             SET deleted_flag=G_YES_FLAG
           WHERE ui_def_id=g_UI_Context.ui_def_id AND
                 page_id=p_ui_page_id AND
                 element_id=l_attribute_value;

Line: 15625

    UPDATE CZ_UI_PAGES
       SET page_rev_nbr=page_rev_nbr+1
    WHERE ui_def_id=g_UI_Context.ui_def_id AND
          page_id=p_ui_page_id;

Line: 15644

    g_page_elements_tbl.DELETE;

Line: 15697

      FOR i IN (SELECT *
                  FROM CZ_UI_PAGE_ELEMENTS a
                 WHERE ui_def_id =  g_UI_Context.ui_def_id AND
                       page_id = p_page_id AND
                       parent_element_id = p_ui_node.element_id
                       -- parent_persistent_node_id = p_ui_node.persistent_node_id
                 ORDER BY seq_nbr)
      LOOP
        IF i.deleted_flag IN(G_MARK_TO_ADD,G_MARK_DO_NOT_REFRESH) THEN
          IF p_ui_node.element_type IN(G_UI_PAGE_NODE_TYPE,G_UI_REGION_NODE_TYPE) AND
             NOT(NVL(p_ui_node.instantiable_flag, G_MANDATORY_INST_TYPE) IN(G_OPTIONAL_INST_TYPE,G_MINMAX_INST_TYPE) AND
                 p_ui_node.element_type=G_UI_REGION_NODE_TYPE) THEN

            IF i.element_type=G_UI_REGION_NODE_TYPE THEN -- this a region

              --
              -- create new JRAD region
              --
              l_new_xml_node := create_UIXML_Region(p_ui_node         => i,
                                                    p_parent_xml_node => p_parent_xml_node);

Line: 15740

       ELSIF i.deleted_flag IN(G_MARK_TO_REFRESH) THEN

          l_xml_node_to_replace := find_XML_Node_By_Attribute(p_subtree_doc     => l_subtree_doc ,
                                                              p_attribute_name  => G_ID_ATTRIBUTE,
                                                              p_attribute_value => i.element_id);

Line: 15756

       ELSIF i.deleted_flag = G_MARK_TO_MOVE THEN
         l_new_xml_node := move_XML_Node(p_ui_node         => i,
                                         p_parent_xml_node => p_parent_xml_node);

Line: 15760

       ELSIF i.deleted_flag IN(G_YES_FLAG, G_LIMBO_FLAG) THEN
         NULL; -- do not refresh deleted UI nodes

Line: 15783

      FOR i IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS
                WHERE ui_def_id=p_page_ui_node.ui_def_id
                      AND parent_element_id=p_page_ui_node.element_id
                      AND persistent_node_id=p_page_ui_node.persistent_node_id
                      AND (element_type IS NULL OR element_type <> G_UI_CX_BUTTON_NODE_TYPE)
                      AND deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH))
      LOOP
        IF i.deleted_flag=G_MARK_TO_REFRESH THEN
          BEGIN
            l_xml_node_to_replace := find_XML_Node_By_Attribute(p_subtree_doc     => l_subtree_doc,
                                                                p_attribute_name  => G_ID_ATTRIBUTE,
                                                                p_attribute_value => i.element_id);

Line: 15822

  g_dom_elements_tbl.DELETE;

Line: 15824

    SELECT *
      INTO l_page_ui_node
      FROM CZ_UI_PAGE_ELEMENTS
     WHERE ui_def_id =  g_UI_Context.ui_def_id AND
           page_id = p_page_id AND
           parent_element_id IS NULL AND
           -- element_type=G_UI_PAGE_NODE_TYPE AND
           deleted_flag IN(G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH);

Line: 15858

    SELECT jrad_doc INTO l_jrad_doc
      FROM CZ_UI_PAGES
     WHERE ui_def_id= g_UI_Context.ui_def_id AND
           page_id=p_page_id;

Line: 15886

    delete_UIXML_Elements(p_page_id   => p_page_id,
                          p_xml_doc   => l_subtree_doc);

Line: 15951

      FOR i IN (SELECT *
                  FROM CZ_UI_PAGE_ELEMENTS
                 WHERE ui_def_id =  g_UI_Context.ui_def_id AND
                       page_id = p_page_id AND
                       parent_element_id = p_element_id AND
                       ctrl_template_id IS NOT NULL AND
                       deleted_flag IN(G_MARK_TO_ADD,G_MARK_DO_NOT_REFRESH,G_MARK_TO_MOVE)
                 ORDER BY seq_nbr)
      LOOP
        IF i.deleted_Flag = G_MARK_TO_MOVE THEN
          l_new_xml_node := move_XML_Node(p_ui_node         => i,
                                          p_parent_xml_node => p_parent_xml_node);

Line: 16042

    SELECT *
      INTO l_page_ui_node
      FROM CZ_UI_PAGE_ELEMENTS
     WHERE ui_def_id =  g_UI_Context.ui_def_id AND
           page_id = p_page_id AND
           persistent_node_id = pagebase_persistent_node_id AND
           parent_element_id IS NULL AND
           element_type=G_UI_PAGE_NODE_TYPE AND
           deleted_flag = G_MARK_TO_ADD;

Line: 16145

      SELECT COUNT(element_id) INTO g_Num_Elements_On_Page
      FROM CZ_UI_PAGE_ELEMENTS
      WHERE ui_def_id=g_UI_Context.ui_def_id AND
            page_id=p_page_id AND
            (element_type IS NULL OR ctrl_template_id IS NOT NULL) AND
            deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 16157

    IF p_page_status = G_MARK_TO_DELETE THEN
      delete_UIXML_Page(p_page_id, p_page_jrad_doc);

Line: 16192

    FOR i IN (SELECT page_id, jrad_doc, deleted_flag
                FROM CZ_UI_PAGES
               WHERE ui_def_id = g_UI_Context.ui_def_id AND
                     deleted_flag <> G_YES_FLAG)
    LOOP
      IF i.deleted_flag IN(G_MARK_TO_DELETE,G_MARK_TO_ADD,
                           G_MARK_TO_REFRESH,G_MARK_TO_DEASSOCIATE) THEN
        --
        -- handle the current JRAD page
        --
        handle_JRAD_Page(p_page_id       => i.page_id,
                         p_page_jrad_doc => i.jrad_doc,
                         p_page_status   => i.deleted_flag);

Line: 16206

        FOR n IN(SELECT G_YES_FLAG FROM CZ_UI_PAGE_ELEMENTS
                 WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=i.page_id AND
                       element_type=G_UI_CX_BUTTON_NODE_TYPE AND
                       deleted_flag=G_NO_FLAG AND rownum<2)
        LOOP
          --
          -- handle the current JRAD page
          --
          handle_JRAD_Page(p_page_id       => i.page_id,
                           p_page_jrad_doc => i.jrad_doc,
                           p_page_status   => G_MARK_TO_REFRESH);

Line: 16239

      SELECT instantiable_flag INTO l_instantiable_flag
      FROM cz_ps_nodes
      WHERE devl_project_id = (SELECT devl_project_id FROM cz_ui_defs
                               WHERE ui_def_id = p_ui_def_id) AND
                                     persistent_node_id = p_node_persistent_id;

Line: 16254

    SELECT NVL(name, to_char(page_id)) INTO l_name
    FROM cz_ui_pages
    WHERE ui_def_id = p_ui_def_id AND page_id = p_page_id;

Line: 16277

      SELECT name INTO l_name
      FROM cz_ui_defs
      WHERE ui_def_id = p_ui_def_id;

Line: 16287

      SELECT name INTO l_name
      FROM cz_devl_projects
      WHERE devl_project_id = (SELECT devl_project_id FROM cz_ui_defs
                               WHERE ui_def_id = p_ui_def_id);

Line: 16299

      UPDATE CZ_UI_PAGE_ELEMENTS
         SET target_page_ui_def_id = NULL, target_page_id = NULL
       WHERE ui_def_id = p_ui_def_id AND
             page_id = p_page_id AND element_id = p_element_id;

Line: 16304

      UPDATE CZ_UI_PAGES
         SET page_rev_nbr = page_rev_nbr + 1
       WHERE ui_def_id = p_ui_def_id AND page_id = p_page_id;

Line: 16314

    FOR i IN (SELECT page_id, element_id, target_page_ui_def_id, target_page_id,
                     model_ref_expl_id, persistent_node_id, name
              FROM CZ_UI_PAGE_ELEMENTS
              WHERE ui_def_id = g_UI_Context.ui_def_id AND
                    element_signature_id = G_PAGE_INCL_REGION_SIGNATURE AND
                    target_page_ui_def_id IS NOT NULL AND target_page_id IS NOT NULL AND
                    deleted_flag = G_NO_FLAG)
    LOOP
      -- target page exists ?
      l_target_persistent_node_id := NULL;

Line: 16325

        SELECT persistent_node_id INTO l_target_persistent_node_id
        FROM   cz_ui_pages
        WHERE  ui_def_id = i.target_page_ui_def_id AND
               page_id = i.target_page_id AND deleted_flag = G_NO_FLAG;

Line: 16344

        SELECT  pagebase_expl_node_id INTO l_pagebase_expl_id
        FROM   cz_ui_pages
        WHERE  ui_def_id = g_UI_Context.ui_def_id AND
               page_id = i.page_id;

Line: 16375

    FOR i IN (SELECT a.deleted_flag AS page_deleted_flag, a.page_id AS page_id,
                     a.name AS name, a.persistent_node_id AS target_persistent_node_id,
                     b.ui_def_id AS ref_ui_def_id, b.page_id AS ref_page_id,
                     b.name AS ref_element_name, b.element_id AS ref_element_id,
                     b.persistent_node_id as persistent_node_id,
                     b.model_ref_expl_id as expl_node_id
              FROM CZ_UI_PAGES a, CZ_UI_PAGE_ELEMENTS b
              WHERE a.ui_def_id = g_UI_Context.ui_def_id AND
                    b.element_signature_id = G_PAGE_INCL_REGION_SIGNATURE AND
                    b.deleted_flag = G_NO_FLAG AND
                    a.ui_def_id = b.target_page_ui_def_id AND
                    a.page_id = b.target_page_id)
    LOOP
      IF i.page_deleted_flag = G_YES_FLAG THEN
        remove_target_page(i.ref_ui_def_id, i.ref_page_id, i.ref_element_id);

Line: 16405

        SELECT pagebase_expl_node_id INTO l_pagebase_expl_id
        FROM   cz_ui_pages
        WHERE  ui_def_id = i.ref_ui_def_id AND
               page_id = i.ref_page_id;

Line: 16447

      FOR i IN (SELECT page_id, jrad_doc, pagebase_expl_node_id, persistent_node_id
                FROM CZ_UI_PAGES pg
                WHERE ui_def_id = l_ui_def_id AND deleted_flag = G_NO_FLAG
                AND   EXISTS (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
                              WHERE ui_def_id = pg.ui_def_id AND page_id = pg.page_id AND
                                    element_signature_id = G_PAGE_INCL_REGION_SIGNATURE AND
                                    target_page_ui_def_id IS NOT NULL AND
                                    target_page_id IS NOT NULL AND deleted_flag=G_NO_FLAG))
      LOOP
        EXIT WHEN l_flag = 0;

Line: 16459

        FOR j IN (SELECT * FROM CZ_UI_PAGE_ELEMENTS
                  WHERE ui_def_id = l_ui_def_id AND page_id = i.page_id AND
                        element_signature_id = G_PAGE_INCL_REGION_SIGNATURE AND
                        deleted_flag=G_NO_FLAG)
        LOOP
          EXIT WHEN l_flag <> 1;

Line: 16477

              UPDATE CZ_UI_PAGES
	         SET page_rev_nbr = page_rev_nbr + 1
               WHERE ui_def_id = l_ui_def_id AND page_id = i.page_id;

Line: 16482

              UPDATE cz_ui_defs
              SET ui_status = 'NEED_REFRESH'
              WHERE ui_def_id = l_ui_def_id;

Line: 16527

    UPDATE cz_ui_defs
    SET UI_TIMESTAMP_REFRESH = SYSDATE
    WHERE ui_def_id = p_ui_def_id;

Line: 16586

      FOR i IN(SELECT * FROM CZ_MODEL_REF_EXPLS
               WHERE model_id=g_UI_Context.devl_project_id AND
                     ps_node_type=G_REFERENCE_TYPE AND deleted_flag='0')
      LOOP
        BEGIN
          SELECT NVL(MAX(ui_def_id),0) INTO l_ui_def_id
            FROM CZ_UI_DEFS
           WHERE devl_project_id=i.component_id AND
                 ui_style=G_OA_STYLE_UI AND
                 deleted_flag='0';

Line: 16607

          SELECT persistent_node_id INTO l_ref_persistent_node_id
            FROM CZ_PS_NODES
           WHERE devl_project_id=g_UI_Context.devl_project_id AND
                 ps_node_id=i.referring_node_id AND
                 deleted_flag=G_NO_FLAG;

Line: 16614

            INSERT INTO CZ_UI_REFS
             (ui_def_id,
              ref_ui_def_id,
              ref_persistent_node_id,
              model_ref_expl_id,
              deleted_flag)
             VALUES
             (g_UI_Context.ui_def_id,
              l_ui_def_id,
              l_ref_persistent_node_id,
              i.model_ref_expl_id,
              G_NO_FLAG);

Line: 16642

    FOR i IN (SELECT DISTINCT ref_ui_def_id
                FROM CZ_UI_REFS
               WHERE ui_def_id = p_ui_def_id AND
                     deleted_flag = G_NO_FLAG)
    LOOP
      --
      -- construct UIs of referenced models
      --
      handle_UIs(i.ref_ui_def_id, p_handling_mode);

Line: 16737

      UPDATE CZ_UI_DEFS
      SET suppress_refresh_flag = G_NO_FLAG
      WHERE ui_def_id = x_ui_def_id and deleted_flag = G_NO_FLAG;

Line: 16741

      UPDATE CZ_UI_DEFS
      SET suppress_refresh_flag = G_NO_FLAG
      WHERE ui_def_Id IN (
         SELECT ref_ui_def_Id
         FROM CZ_UI_REFS
         START WITH ui_def_id = x_ui_def_id
         AND deleted_flag = G_NO_FLAG
         CONNECT BY PRIOR ref_ui_def_id = ui_def_id AND deleted_flag = G_NO_FLAG)
      AND deleted_flag = G_NO_FLAG;

Line: 16888

  PROCEDURE delete_User_Attr_For_Node(p_xml_node           xmldom.DOMNode,
                                      p_ui_def_id          NUMBER,
                                      p_template_id        NUMBER DEFAULT NULL,
                                      p_template_ui_def_id NUMBER DEFAULT NULL) IS

    l_user_attribute_value VARCHAR2(4000);

Line: 16903

          UPDATE CZ_UI_ACTIONS
             SET deleted_flag=G_YES_FLAG
           WHERE ui_def_id=p_ui_def_id AND
                 ui_action_id=l_persistent_id AND
                 seeded_flag=G_NO_FLAG;

Line: 16910

              UPDATE CZ_UI_TEMPLATE_ELEMENTS
                 SET deleted_flag=G_YES_FLAG
               WHERE template_id=p_template_id AND
                     ui_def_id=p_template_ui_def_id AND
                     element_id=l_persistent_id AND
                     element_type IN(552) AND
                     seeded_flag=G_NO_FLAG AND
                     deleted_flag=G_NO_FLAG;

Line: 16925

            UPDATE CZ_RULES
               SET deleted_flag = G_YES_FLAG
             WHERE persistent_rule_id = l_persistent_id
               AND ui_def_id = p_ui_def_id
               AND seeded_flag = G_NO_FLAG;

Line: 16932

              UPDATE CZ_UI_TEMPLATE_ELEMENTS
                 SET deleted_flag=G_YES_FLAG
               WHERE template_id=p_template_id AND
                     ui_def_id=p_template_ui_def_id AND
                     element_id=l_persistent_id AND
                     element_type IN(33,34) AND
                     seeded_flag=G_NO_FLAG AND
                     deleted_flag=G_NO_FLAG;

Line: 16948

            UPDATE CZ_LOCALIZED_TEXTS
               SET deleted_flag=G_YES_FLAG
             WHERE persistent_intl_text_id=l_persistent_id AND
                   ui_def_id=p_ui_def_id AND
                   seeded_flag=G_NO_FLAG;

Line: 16955

              UPDATE CZ_UI_TEMPLATE_ELEMENTS
                 SET deleted_flag=G_YES_FLAG
               WHERE template_id=p_template_id AND
                     ui_def_id=p_template_ui_def_id AND
                     element_id=l_persistent_id AND
                     element_type IN(8) AND
                     seeded_flag=G_NO_FLAG AND
                     deleted_flag=G_NO_FLAG;

Line: 16968

  END delete_User_Attr_For_Node;

Line: 17021

        SELECT * INTO l_ui_node FROM CZ_UI_PAGE_ELEMENTS
         WHERE ui_def_id=p_target_ui_def_id AND
               page_id=p_target_ui_page_id AND
               element_id=l_new_element_id;

Line: 17025

        SELECT model_ref_expl_id INTO l_model_ref_expl_id FROM CZ_UI_PAGE_ELEMENTS
        WHERE ui_def_id=l_ui_node.ui_def_id AND page_id=l_ui_node.page_id AND
             parent_element_id IS NULL AND deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 17066

       SELECT COUNT(*)+1 INTO l_num_copy FROM CZ_UI_PAGE_ELEMENTS
       WHERE ui_def_id=p_target_ui_def_id AND page_id=p_target_ui_page_id AND
             name like l_name||'%' AND deleted_flag=G_NO_FLAG;

Line: 17082

       UPDATE CZ_UI_PAGE_ELEMENTS
          SET name=l_name
        WHERE ui_def_id=p_target_ui_def_id AND page_id=p_target_ui_page_id AND
              element_id = l_new_element_id;

Line: 17161

  PROCEDURE delete_User_Attributes(p_xml_node  xmldom.DOMNode,
                                   p_ui_def_id NUMBER,
                                   p_template_id        NUMBER DEFAULT NULL,
                                   p_template_ui_def_id NUMBER DEFAULT NULL) IS


    l_child_nodes_tbl xmldom.DOMNodeList;

Line: 17177

    delete_User_Attr_For_Node(p_xml_node,p_ui_def_id,
                              p_template_id, p_template_ui_def_id);

Line: 17190

      delete_User_Attr_For_Node(l_child_xml_node,p_ui_def_id,
                                p_template_id, p_template_ui_def_id);

Line: 17193

      delete_User_Attributes(l_child_xml_node,p_ui_def_id,
                             p_template_id, p_template_ui_def_id);

Line: 17198

  END delete_User_Attributes;

Line: 17273

    UPDATE CZ_UI_PAGE_ELEMENTS
       SET target_page_ui_def_id=NULL,
           target_page_id=NULL
     WHERE ui_def_id=p_ui_def_id AND
           page_id=p_page_id AND
           element_signature_id = G_PAGE_INCL_REGION_SIGNATURE AND
           deleted_flag='0' AND target_page_ui_def_id IS NOT NULL AND
           target_page_id IS NOT NULL AND
           target_page_ui_def_id NOT IN (SELECT ref_ui_def_id FROM CZ_UI_REFS WHERE ui_def_id=p_ui_def_id AND
           deleted_flag='0')
    RETURNING element_id,name,target_page_id,target_page_ui_def_id
    BULK COLLECT INTO l_element_id_tbl,l_name_tbl,l_target_page_id_tbl,l_target_page_ui_def_id_tbl;

Line: 17289

        SELECT name INTO l_page_name FROM CZ_UI_PAGES
        WHERE page_id=l_target_page_id_tbl(i) AND ui_def_id=l_target_page_ui_def_id_tbl(i);

Line: 17291

        SELECT name INTO l_ui_name FROM CZ_UI_DEFS WHERE ui_def_id=l_target_page_ui_def_id_tbl(i);

Line: 17306

    FOR i IN (SELECT page_id, element_id, target_page_ui_def_id, target_page_id,
                     model_ref_expl_id, persistent_node_id, name
              FROM CZ_UI_PAGE_ELEMENTS
              WHERE ui_def_id = p_ui_def_id AND page_id=p_page_id AND
                    element_signature_id = G_PAGE_INCL_REGION_SIGNATURE AND
                    target_page_ui_def_id IS NOT NULL AND target_page_id IS NOT NULL AND
                    deleted_flag = '0')
    LOOP
      -- target page exists?
      l_target_persistent_node_id := NULL;

Line: 17317

        SELECT persistent_node_id INTO l_target_persistent_node_id
        FROM   cz_ui_pages
        WHERE  ui_def_id = i.target_page_ui_def_id AND
               page_id = i.target_page_id AND deleted_flag <> '1';

Line: 17325

          UPDATE CZ_UI_PAGE_ELEMENTS
          SET    target_page_ui_def_id = NULL, target_page_id = NULL
          WHERE  ui_def_id = p_ui_def_id AND
                 page_id = i.page_id AND element_id = i.element_id;

Line: 17340

        SELECT pagebase_expl_node_id INTO l_pagebase_expl_id
        FROM   cz_ui_pages
        WHERE  ui_def_id = p_ui_def_id AND
               page_id = i.page_id;

Line: 17361

          UPDATE CZ_UI_PAGE_ELEMENTS
          SET    target_page_ui_def_id = NULL, target_page_id = NULL
          WHERE  ui_def_id = p_ui_def_id AND
                 page_id = i.page_id AND element_id = i.element_id;

Line: 17504

    FOR i IN(SELECT parent_element_id FROM CZ_UI_PAGE_ELEMENTS
             WHERE ui_def_id=p_source_ui_def_id AND
                   page_id=p_source_ui_page_id AND
                   element_id=l_current_element_id)
    LOOP
      l_ui_page_elements_exists := TRUE;

Line: 17526

        INSERT INTO CZ_UI_PAGE_ELEMENTS
        (ui_def_id,
         persistent_node_id,
         parent_persistent_node_id,
         region_persistent_node_id,
         pagebase_persistent_node_id,
         page_id,
         seq_nbr,
         ctrl_template_id,
         element_id,
         parent_element_id,
         element_type,
         instantiable_flag,
         ctrl_template_ui_def_id,
         model_ref_expl_id,
         element_signature_id,
         name,
         suppress_refresh_flag,
         deleted_flag,
         target_page_ui_def_id,
         target_page_id)
         SELECT
           p_target_ui_def_id,
         persistent_node_id,
         parent_persistent_node_id,
         region_persistent_node_id,
         p_pagebase_persistent_node_id,
         p_target_ui_page_id,
           seq_nbr,
         ctrl_template_id,
            l_new_element_id,
            l_parent_element_id,
         element_type,
         instantiable_flag,
         ctrl_template_ui_def_id,
         model_ref_expl_id,
         element_signature_id,
         name,
         suppress_refresh_flag,
         deleted_flag,
         target_page_ui_def_id,
         target_page_id
        FROM CZ_UI_PAGE_ELEMENTS
        WHERE ui_def_id=p_source_ui_def_id AND
              page_id=p_source_ui_page_id AND
              element_id=l_current_element_id;

Line: 17637

        SELECT * INTO l_ui_node FROM CZ_UI_PAGE_ELEMENTS
         WHERE ui_def_id=p_target_ui_def_id AND
               page_id=p_target_ui_page_id AND
               element_id=l_new_element_id;

Line: 17642

        SELECT model_ref_expl_id INTO l_model_ref_expl_id FROM CZ_UI_PAGE_ELEMENTS
        WHERE ui_def_id=p_target_ui_def_id AND page_id=p_target_ui_page_id AND
             parent_element_id IS NULL AND deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE);

Line: 17665

       SELECT COUNT(element_id) INTO l_view_counter
       FROM CZ_UI_PAGE_ELEMENTS
       WHERE ui_def_id=p_target_ui_def_id AND page_id=p_target_ui_page_id AND
       deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);

Line: 17701

       SELECT COUNT(*)+1 INTO l_num_copy FROM CZ_UI_PAGE_ELEMENTS
       WHERE ui_def_id=p_target_ui_def_id AND page_id=p_target_ui_page_id AND
             name like l_name||'%' AND deleted_flag=G_NO_FLAG;

Line: 17717

       UPDATE CZ_UI_PAGE_ELEMENTS
          SET name=l_name
        WHERE ui_def_id=p_target_ui_def_id AND page_id=p_target_ui_page_id AND
              element_id = l_new_element_id;

Line: 17814

  PROCEDURE delete_UI_Subtree(p_ui_def_id      IN NUMBER,
                              p_ui_page_id     IN NUMBER,
                              p_element_id     IN VARCHAR2,
                              p_delete_xml     IN VARCHAR2,
                              x_return_status  OUT NOCOPY VARCHAR2,
                              x_msg_count      OUT NOCOPY NUMBER,
                              x_msg_data       OUT NOCOPY VARCHAR2) IS

   l_xmldoc                   xmldom.DOMDocument;

Line: 17848

    g_ui_def_nodes_tbl.DELETE;

Line: 17854

    UPDATE CZ_UI_PAGE_ELEMENTS
       SET deleted_flag=G_LIMBO_FLAG
     WHERE (ui_def_id,page_id,element_id) IN
     (SELECT ui_def_id,page_id,element_id FROM CZ_UI_PAGE_ELEMENTS
      START WITH ui_def_id=p_ui_def_id AND page_id=p_ui_page_id AND element_id=p_element_id
      CONNECT BY PRIOR ui_def_id=p_ui_def_id AND
                       PRIOR page_id=p_ui_page_id AND page_id=p_ui_page_id AND
                       PRIOR element_id=parent_element_id AND
                       PRIOR ui_def_id=p_ui_def_id AND ui_def_id=p_ui_def_id AND
                       PRIOR deleted_flag=G_NO_FLAG AND deleted_flag=G_NO_FLAG)
    RETURNING element_id
    BULK COLLECT INTO l_element_id_tbl;

Line: 17871

    SELECT parent_element_id
     INTO l_parent_element_id
     FROM CZ_UI_PAGE_ELEMENTS
    WHERE ui_def_id=p_ui_def_id AND
          page_id=p_ui_page_id AND
          element_id=p_element_id;

Line: 17878

    SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES
    WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id;

Line: 17881

    IF  l_parent_element_id IS NULL OR p_element_id=G_NO_FLAG THEN  -- this is UI page ( and it should be deleted )

      FOR i IN(SELECT page_ref_id,page_ref_type,page_set_id,condition_id,caption_text_id,caption_rule_id
                 FROM CZ_UI_PAGE_REFS
                WHERE ui_def_id=p_ui_def_id AND target_page_id=p_ui_page_id AND deleted_flag=G_NO_FLAG)
      LOOP

        UPDATE CZ_LOCALIZED_TEXTS
           SET deleted_flag=G_YES_FLAG
         WHERE persistent_intl_text_id=i.caption_text_id AND
               ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;

Line: 17893

        UPDATE CZ_RULES
           SET deleted_flag=G_YES_FLAG
         WHERE persistent_rule_id IN(i.condition_id,i.caption_rule_id) AND
               ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;

Line: 17899

          UPDATE CZ_UI_PAGE_REFS
             SET deleted_flag=G_YES_FLAG
           WHERE ui_def_id=p_ui_def_id
                 AND deleted_flag=G_NO_FLAG
                 AND (ui_def_id,page_ref_id,page_set_id) IN
                 (SELECT a.ui_def_id,a.page_ref_id,a.page_set_id FROM CZ_UI_PAGE_REFS a
                   START WITH a.ui_def_id=p_ui_def_id AND
                              a.page_ref_id=i.page_ref_id
                   CONNECT BY PRIOR a.page_ref_id=a.parent_page_ref_id AND
                                    a.deleted_flag='0' AND a.ui_def_id=p_ui_def_id AND
                              PRIOR a.ui_def_id=p_ui_def_id AND
                                    a.page_set_id=i.page_set_id AND
                              PRIOR a.page_set_id=i.page_set_id);

Line: 17913

          UPDATE CZ_UI_PAGE_REFS
             SET deleted_flag=G_YES_FLAG
           WHERE ui_def_id=p_ui_def_id AND page_ref_id=i.page_ref_id;

Line: 17925

      UPDATE CZ_UI_PAGES
         SET deleted_flag=G_YES_FLAG
       WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG
      RETURNING caption_text_id,caption_rule_id,display_condition_id,enabled_condition_id
      INTO l_caption_text_id,l_caption_rule_id,l_display_condition_id,l_enabled_condition_id;

Line: 17931

      UPDATE CZ_LOCALIZED_TEXTS
         SET deleted_flag=G_YES_FLAG
       WHERE intl_text_id=l_caption_text_id AND ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;

Line: 17935

      UPDATE CZ_RULES
         SET deleted_flag=G_YES_FLAG
       WHERE rule_id IN(l_display_condition_id,l_caption_rule_id,l_enabled_condition_id)
         AND seeded_flag=G_NO_FLAG;

Line: 17943

      UPDATE CZ_UI_ACTIONS
         SET deleted_flag=G_YES_FLAG
       WHERE ui_def_id=p_ui_def_id AND
             source_page_id=p_ui_page_id AND
             element_id=l_element_id_tbl(i) AND deleted_flag=G_NO_FLAG AND seeded_flag=G_NO_FLAG;

Line: 17950

      UPDATE CZ_RULES
         SET deleted_flag=G_YES_FLAG
       WHERE ui_def_id=p_ui_def_id AND
             ui_page_id=p_ui_page_id AND
             ui_page_element_id=l_element_id_tbl(i) AND
             deleted_flag=G_NO_FLAG AND seeded_flag=G_NO_FLAG;

Line: 17958

      UPDATE CZ_LOCALIZED_TEXTS
         SET deleted_flag=G_YES_FLAG
       WHERE ui_def_id=p_ui_def_id AND
             ui_page_id=p_ui_page_id AND
             ui_page_element_id=l_element_id_tbl(i) AND
             deleted_flag=G_NO_FLAG AND seeded_flag=G_NO_FLAG;

Line: 17989

    delete_User_Attributes(l_xml_node, p_ui_def_id);

Line: 17991

    IF p_delete_xml=G_YES_FLAG THEN
      IF l_parent_element_id IS NULL OR p_element_id=G_NO_FLAG THEN
        jdr_docbuilder.deleteDocument(l_jrad_doc);

Line: 18001

      UPDATE CZ_UI_PAGES
         SET page_rev_nbr=page_rev_nbr+1
       WHERE ui_def_id=p_ui_def_id AND
             page_id=p_ui_page_id;

Line: 18024

      fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'delete_UI_Subtree', x_msg_data);

Line: 18026

  END delete_UI_Subtree;

Line: 18034

  PROCEDURE delete_UI_Page(p_ui_def_id      IN NUMBER,         -- ui_def_id of UI
                            p_ui_page_id    IN NUMBER,        -- page_id of
                                                                -- UI page which needs
                                                                -- to be deleted.
                            x_return_status  OUT NOCOPY VARCHAR2,-- status string
                            x_msg_count      OUT NOCOPY NUMBER,  -- number of error messages
                            x_msg_data       OUT NOCOPY VARCHAR2 -- string which contains error messages
                            ) IS

    l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;

Line: 18055

    FOR i IN(SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
              WHERE ui_def_id=p_ui_def_id AND page_id=p_ui_page_id AND
                    parent_element_id IS NULL AND deleted_flag=G_NO_FLAG)
    LOOP
      --
      -- delete UI elements of this UI page starting with
      -- the root element
      --
      delete_UI_Subtree(p_ui_def_id      => p_ui_def_id,
                        p_ui_page_id     => p_ui_page_id,
                        p_element_id     => i.element_id,
                        p_delete_xml     => G_YES_FLAG,
                        x_return_status  => x_return_status,
                        x_msg_count      => x_msg_count,
                        x_msg_data       => x_msg_data);

Line: 18073

    UPDATE cz_ui_page_elements
    SET target_page_ui_def_id = NULL, target_page_id = NULL
    WHERE target_page_ui_def_id = p_ui_def_id AND target_page_id = p_ui_page_id AND
          deleted_flag = '0' AND element_signature_id = G_PAGE_INCL_REGION_SIGNATURE;

Line: 18082

      fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'delete_UI_Page', x_msg_data);

Line: 18084

  END delete_UI_Page;

Line: 18090

  PROCEDURE delete_UI_Page_Ref(p_ui_def_id      IN NUMBER,          -- ui_def_id of UI
                                p_page_ref_id   IN NUMBER,          -- page_ref_id of
                                                                    -- Menu/Page Flow link which needs
                                                                    -- to be deleted.
                                x_return_status  OUT NOCOPY VARCHAR2,-- status string
                                x_msg_count      OUT NOCOPY NUMBER,  -- number of error messages
                                x_msg_data       OUT NOCOPY VARCHAR2 -- string which contains error messages
                                ) IS

   l_parent_page_ref_id   CZ_UI_PAGE_REFS.parent_page_ref_id%TYPE;

Line: 18112

    g_ui_def_nodes_tbl.DELETE;

Line: 18119

    SELECT page_set_id, page_ref_type
      INTO l_page_set_id, l_page_ref_type
      FROM CZ_UI_PAGE_REFS
     WHERE ui_def_id=p_ui_def_id AND page_ref_id=p_page_ref_id
           AND deleted_flag=G_NO_FLAG;

Line: 18126

      UPDATE CZ_UI_PAGE_REFS
         SET deleted_flag=G_YES_FLAG
       WHERE ui_def_id=p_ui_def_id
             AND deleted_flag=G_NO_FLAG
             AND (ui_def_id,page_ref_id,page_set_id) IN
             (SELECT a.ui_def_id,a.page_ref_id,a.page_set_id FROM CZ_UI_PAGE_REFS a
             START WITH a.ui_def_id=p_ui_def_id AND
             a.page_ref_id=p_page_ref_id
             CONNECT BY PRIOR a.page_ref_id=a.parent_page_ref_id AND
             a.deleted_flag='0' AND a.ui_def_id=p_ui_def_id AND
             PRIOR a.ui_def_id=p_ui_def_id AND
             a.page_set_id=l_page_set_id AND
             PRIOR a.page_set_id=l_page_set_id);

Line: 18140

      UPDATE CZ_UI_PAGE_REFS
         SET deleted_flag=G_YES_FLAG
       WHERE ui_def_id=p_ui_def_id
             AND page_ref_id=p_page_ref_id;

Line: 18150

    UPDATE CZ_UI_PAGES a
       SET page_set_id=NULL
     WHERE ui_def_id=p_ui_def_id AND page_set_id IS NOT NULL AND
           NOT EXISTS(SELECT NULL FROM CZ_UI_PAGE_REFS b
           WHERE b.ui_def_id=p_ui_def_id AND target_page_id=a.page_id AND
           deleted_flag='0');

Line: 18169

      fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'delete_UI_Page_Ref', x_msg_data);

Line: 18171

  END delete_UI_Page_Ref;

Line: 18180

  PROCEDURE delete_Local_Template(p_template_ui_def_id  IN NUMBER,     -- ui_def_id of UI
                                  p_template_id         IN NUMBER,     -- template_id of
                                                                       -- Local UI Template which needs
                                                                       -- to be deleted.
                                  x_return_status  OUT NOCOPY VARCHAR2,-- status string
                                  x_msg_count      OUT NOCOPY NUMBER,  -- number of error messages
                                  x_msg_data       OUT NOCOPY VARCHAR2 -- string which contains error messages
                                  ) IS

   l_xmldoc                   xmldom.DOMDocument;

Line: 18199

    FOR i IN(SELECT 'x' FROM CZ_MODEL_PUBLICATIONS
             WHERE object_id=p_template_id AND object_type='UIT' AND
                   deleted_flag='0' AND rownum<2)
    LOOP
      RETURN;

Line: 18209

    SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES
    WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;

Line: 18233

    delete_User_Attributes(xmldom.makeNode(l_xmldoc),p_template_ui_def_id,
                           p_template_id, p_template_ui_def_id);

Line: 18236

    jdr_docbuilder.deleteDocument(l_jrad_doc);

Line: 18243

    DELETE FROM CZ_UI_TEMPLATES
    WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id
          AND seeded_flag=G_NO_FLAG;

Line: 18247

    DELETE FROM CZ_UI_REF_TEMPLATES
    WHERE template_ui_def_id=p_template_ui_def_id AND template_id=p_template_id;

Line: 18250

    UPDATE CZ_UI_TEMPLATE_ELEMENTS
       SET deleted_flag=G_YES_FLAG
     WHERE template_id=p_template_ui_def_id AND
           deleted_flag=G_NO_FLAG;

Line: 18265

      fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'delete_Local_Template', x_msg_data);

Line: 18266

      DEBUG('delete_Local_Template() : '||x_msg_data);

Line: 18267

  END delete_Local_Template;

Line: 18273

  PROCEDURE delete_Local_Template_Elem(p_template_ui_def_id  IN NUMBER, -- ui_def_id of UI
                                       p_template_id         IN NUMBER,        -- template_id of
                                       p_element_id          IN VARCHAR2,        -- element_id of Element to delete
                                       x_return_status  OUT NOCOPY VARCHAR2,-- status string
                                       x_msg_count      OUT NOCOPY NUMBER,  -- number of error messages
                                       x_msg_data       OUT NOCOPY VARCHAR2 -- string which contains error messages
                                       ) IS

    l_xmldoc                   xmldom.DOMDocument;

Line: 18303

    SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES
    WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;

Line: 18338

        fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'delete_Local_Template_Elem', 'Element with element_id="'||
        p_element_id||'" does exist.');

Line: 18340

        DEBUG('delete_Local_Template_Elem() : '||'Element with element_id="'||
        p_element_id||'" does exist.');

Line: 18349

    delete_User_Attributes(l_xml_node, p_template_ui_def_id,
                           p_template_id, p_template_ui_def_id);

Line: 18374

    UPDATE CZ_UI_TEMPLATES
       SET template_rev_nbr=NVL(template_rev_nbr,0)+1
     WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;

Line: 18398

      fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'delete_Local_Template_Elem', x_msg_data);

Line: 18399

      DEBUG('delete_Local_Template_Elem() : '||x_msg_data);

Line: 18405

  END delete_Local_Template_Elem;

Line: 18453

    g_handled_attr_id_tbl.DELETE;

Line: 18460

    SELECT jrad_doc
      INTO l_source_jrad_doc FROM CZ_UI_PAGES
    WHERE page_id=p_source_ui_page_id AND
          ui_def_id=p_source_ui_def_id;

Line: 18468

    SELECT jrad_doc,persistent_node_id
      INTO l_target_jrad_doc, l_pagebase_persistent_node_id
      FROM CZ_UI_PAGES
     WHERE  page_id=p_target_ui_page_id AND
            ui_def_id=p_target_ui_def_id;

Line: 18525

      SELECT element_id INTO l_amn_parent_element_id
        FROM CZ_UI_PAGE_ELEMENTS
       WHERE ui_def_id=p_target_ui_def_id AND
             page_id=p_target_ui_page_id AND
             element_id=p_target_parent_element_id;

Line: 18610

    UPDATE CZ_UI_PAGES
       SET page_rev_nbr=page_rev_nbr+1,
           empty_page_flag = G_NO_FLAG
     WHERE page_id=p_target_ui_page_id AND
           ui_def_id=p_target_ui_def_id;

Line: 18616

       UPDATE CZ_UI_PAGE_REFS
          SET empty_page_flag = G_NO_FLAG
        WHERE target_page_id=p_target_ui_page_id AND
              ui_def_id=p_target_ui_def_id AND
              deleted_flag = G_NO_FLAG AND
              empty_page_flag = G_YES_FLAG;

Line: 18684

    g_handled_attr_id_tbl.DELETE;

Line: 18688

    SELECT element_id INTO l_source_element_id
      FROM CZ_UI_PAGE_ELEMENTS
     WHERE ui_def_id=p_source_ui_def_id AND page_id=p_source_ui_page_id AND
           parent_element_id IS NULL AND deleted_flag=G_NO_FLAG;

Line: 18696

    SELECT jrad_doc,persistent_node_id
      INTO l_source_jrad_doc,l_persistent_node_id
      FROM CZ_UI_PAGES
     WHERE ui_def_id=p_source_ui_def_id AND
           page_id=p_source_ui_page_id;

Line: 18702

    SELECT COUNT(*) INTO l_copy_nbr FROM CZ_UI_PAGES
    WHERE ui_def_id=p_target_ui_def_id AND
          persistent_node_id=l_persistent_node_id;

Line: 18713

    FOR i IN(SELECT * FROM CZ_UI_PAGES
             WHERE ui_def_id=p_source_ui_def_id AND
                   page_id=p_source_ui_page_id)
    LOOP

      x_new_ui_page_id := allocateId('CZ_UI_PAGES_S');

Line: 18731

      INSERT INTO CZ_UI_PAGES
      (
      PAGE_ID
      ,UI_DEF_ID
      ,PERSISTENT_NODE_ID
      ,JRAD_DOC
      ,PAGEBASE_PATH
      ,PAGE_SET_ID
      ,SPLIT_SEQ_NBR
      ,CAPTION_SOURCE
      ,CAPTION_TEXT_ID
      ,PERSISTENT_CAPTION_TEXT_ID
      ,PROPERTY_ID
      ,DELETED_FLAG
      ,SEEDED_FLAG
      ,PAGEBASE_EXPL_NODE_ID
      ,suppress_refresh_flag
      ,PAGE_REV_NBR
      ,NAME
      ,DESC_TEXT
      ,PAGE_STATUS_TEMPLATE_ID
      ,PAGE_STATUS_TEMPL_UIDEF_ID
      ,CAPTION_RULE_ID
      ,PAGE_STATUS_TEMPLATE_USAGE
      ,OUTER_TEMPLATE_USAGE
      ,OUTER_PAGE_TEMPLATE_ID
      ,OUTER_PAGE_TEMPL_UIDEF_ID
      ,DISPLAY_CONDITION_ID
      ,DISPLAY_CONDITION_COMP
      ,DISPLAY_CONDITION_VALUE
      ,ENABLED_CONDITION_ID
      ,ENABLED_CONDITION_COMP
      ,ENABLED_CONDITION_VALUE
      )
      VALUES
      (
      x_new_ui_page_id
      ,p_target_ui_def_id
      ,i.PERSISTENT_NODE_ID
      ,l_target_jrad_doc
      ,i.PAGEBASE_PATH
      ,NULL
      ,1
      ,i.CAPTION_SOURCE
      ,l_caption_text_id
      ,i.PERSISTENT_CAPTION_TEXT_ID
      ,i.PROPERTY_ID
      ,i.DELETED_FLAG
      ,i.SEEDED_FLAG
      ,i.PAGEBASE_EXPL_NODE_ID
      ,i.suppress_refresh_flag
      ,0
      ,i.NAME||'_'||TO_CHAR(l_copy_nbr)
      ,i.DESC_TEXT
      ,i.PAGE_STATUS_TEMPLATE_ID
      ,i.PAGE_STATUS_TEMPL_UIDEF_ID
      ,l_caption_rule_id
      ,i.PAGE_STATUS_TEMPLATE_USAGE
      ,i.OUTER_TEMPLATE_USAGE
      ,i.OUTER_PAGE_TEMPLATE_ID
      ,i.OUTER_PAGE_TEMPL_UIDEF_ID
      ,l_display_condition_id
      ,i.DISPLAY_CONDITION_COMP
      ,i.DISPLAY_CONDITION_VALUE
      ,l_enabled_condition_id
      ,i.ENABLED_CONDITION_COMP
      ,i.ENABLED_CONDITION_VALUE
      );

Line: 18911

    SELECT page_set_id,node_depth INTO l_target_page_set_id,l_target_node_depth
    FROM CZ_UI_PAGE_REFS
    WHERE ui_def_id=p_target_ui_def_id AND page_ref_id=p_target_parent_page_ref_id;

Line: 18915

    SELECT NVL(MAX(seq_nbr),0) INTO l_target_max_seq_nbr FROM CZ_UI_PAGE_REFS
    WHERE ui_def_id=p_target_ui_def_id AND deleted_flag=G_NO_FLAG;

Line: 18918

    SELECT page_ref_id,parent_page_ref_id,node_depth,seq_nbr
    BULK COLLECT INTO l_page_ref_id_tbl,l_parent_page_ref_id_tbl,l_node_depth_tbl,l_seq_nbr_tbl
    FROM CZ_UI_PAGE_REFS
    START WITH ui_def_id=p_source_ui_def_id AND page_ref_id=p_source_page_ref_id
    CONNECT BY PRIOR ui_def_id=p_source_ui_def_id AND
               ui_def_id=p_source_ui_def_id AND
               PRIOR page_ref_id=parent_page_ref_id AND
               PRIOR deleted_flag=G_NO_FLAG AND deleted_flag=G_NO_FLAG;

Line: 18952

      FOR i IN(SELECT * FROM CZ_UI_PAGE_REFS
               WHERE ui_def_id=p_source_ui_def_id AND
                     page_ref_id=l_current_page_ref_id AND
                     deleted_flag=G_NO_FLAG)
      LOOP

        l_seq_nbr := l_target_max_seq_nbr + i.SEQ_NBR;

Line: 18970

        INSERT INTO CZ_UI_PAGE_REFS
      (
      PAGE_SET_ID
      ,UI_DEF_ID
      ,PAGE_REF_ID
      ,PARENT_PAGE_REF_ID
      ,SEQ_NBR
      ,NODE_DEPTH
      ,PAGE_REF_TYPE
      ,CONDITION_ID
      ,NAME
      ,CAPTION_SOURCE
      ,CAPTION_TEXT_ID
      ,PERSISTENT_CAPTION_TEXT_ID
      ,PROPERTY_ID
      ,TARGET_PERSISTENT_NODE_ID
      ,TARGET_PATH
      ,TARGET_UI_DEF_ID
      ,TARGET_PAGE_SET_ID
      ,TARGET_PAGE_ID
      ,MODIFIED_FLAGS
      ,PATH_TO_PREV_PAGE
      ,PATH_TO_NEXT_PAGE
      ,DELETED_FLAG
      ,CAPTION_RULE_ID
      ,TARGET_EXPL_NODE_ID
      )
       VALUES
      (
      l_target_page_set_id
      ,p_target_ui_def_id
      ,l_new_page_ref_id
      ,l_new_parent_page_ref_id
      ,l_seq_nbr
      ,l_node_depth
      ,i.PAGE_REF_TYPE
      ,l_condition_id
      ,i.NAME
      ,i.CAPTION_SOURCE
      ,l_caption_text_id
      ,i.PERSISTENT_CAPTION_TEXT_ID
      ,i.PROPERTY_ID
      ,i.TARGET_PERSISTENT_NODE_ID
      ,i.TARGET_PATH
      ,i.TARGET_UI_DEF_ID
      ,i.TARGET_PAGE_SET_ID
      ,i.TARGET_PAGE_ID
      ,i.MODIFIED_FLAGS
      ,i.PATH_TO_PREV_PAGE
      ,i.PATH_TO_NEXT_PAGE
      ,i.DELETED_FLAG
      ,l_caption_rule_id
      ,i.TARGET_EXPL_NODE_ID
      );

Line: 19035

      fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'delete_UI_Subtree', x_msg_data);

Line: 19078

    SELECT jrad_doc INTO l_source_jrad_doc FROM CZ_UI_TEMPLATES
    WHERE ui_def_id=p_source_ui_def_id AND template_id=p_source_template_id;

Line: 19138

    INSERT INTO CZ_UI_TEMPLATES
              (TEMPLATE_ID,
               UI_DEF_ID,
               TEMPLATE_NAME,
               TEMPLATE_TYPE,
               TEMPLATE_DESC,
               PARENT_CONTAINER_TYPE,
               JRAD_DOC,
               BUTTON_BAR_TEMPLATE_ID,
               MESSAGE_TYPE,
               MAIN_MESSAGE_ID,
               TITLE_ID,
               SEEDED_FLAG,
               LAYOUT_UI_STYLE,
               ROOT_REGION_TYPE,
               ROOT_ELEMENT_SIGNATURE_ID,
               TEMPLATE_REV_NBR,
               TEMPLATE_USAGE,
               AMN_USAGE,
               DELETED_FLAG)
     SELECT
               x_new_template_id ,
               p_target_ui_def_id,
               TEMPLATE_NAME,
               TEMPLATE_TYPE,
               TEMPLATE_DESC,
               PARENT_CONTAINER_TYPE,
               l_target_jrad_doc,
               BUTTON_BAR_TEMPLATE_ID,
               MESSAGE_TYPE,
               MAIN_MESSAGE_ID,
               TITLE_ID,
               G_NO_FLAG,
               LAYOUT_UI_STYLE,
               ROOT_REGION_TYPE,
               ROOT_ELEMENT_SIGNATURE_ID,
               TEMPLATE_REV_NBR,
               TEMPLATE_USAGE,
               AMN_USAGE,
               G_NO_FLAG
      FROM CZ_UI_TEMPLATES
     WHERE ui_def_id=p_source_ui_def_id AND
           template_id=p_source_template_id;

Line: 19182

    INSERT INTO CZ_UI_REF_TEMPLATES
      (
      TEMPLATE_ID
      ,REF_TEMPLATE_ID
      ,DELETED_FLAG
      ,TEMPLATE_UI_DEF_ID
      ,REF_TEMPLATE_UI_DEF_ID
      )
    SELECT
      x_new_template_id
      ,REF_TEMPLATE_ID
      ,DELETED_FLAG
      ,p_target_ui_def_id
      ,REF_TEMPLATE_UI_DEF_ID
    FROM CZ_UI_REF_TEMPLATES
    WHERE template_id=p_source_template_id AND
          template_ui_def_id=p_source_ui_def_id AND
          deleted_flag=G_NO_FLAG;

Line: 19341

    SELECT jrad_doc INTO l_source_jrad_doc FROM CZ_UI_TEMPLATES
    WHERE ui_def_id=p_source_ui_def_id AND
          template_id=p_source_template_id;

Line: 19345

    SELECT jrad_doc INTO l_target_jrad_doc FROM CZ_UI_TEMPLATES
    WHERE ui_def_id=p_target_ui_def_id AND
          template_id=p_target_template_id;

Line: 19462

    UPDATE CZ_UI_TEMPLATES
       SET template_rev_nbr=NVL(template_rev_nbr,0)+1
     WHERE ui_def_id=p_target_ui_def_id AND template_id=p_target_template_id;

Line: 19560

    SELECT jrad_doc INTO l_template_jrad_doc FROM CZ_UI_TEMPLATES
    WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;

Line: 19563

    SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES a
    WHERE ui_def_id=p_ui_def_id AND page_id=p_ui_page_id;

Line: 19778

    UPDATE CZ_UI_PAGES
       SET page_rev_nbr=page_rev_nbr+1
     WHERE ui_def_id=p_ui_def_id AND
           page_id=p_ui_page_id;

Line: 19863

    SELECT jrad_doc INTO l_template_jrad_doc FROM CZ_UI_TEMPLATES
    WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;

Line: 19866

    SELECT jrad_doc INTO l_target_template_jrad_doc FROM CZ_UI_TEMPLATES
    WHERE ui_def_id=p_target_template_ui_def_id AND template_id=p_target_template_id;

Line: 20014

    UPDATE CZ_UI_TEMPLATES
       SET template_rev_nbr=template_rev_nbr+1
     WHERE template_id=p_target_template_id AND
           ui_def_id=p_target_template_ui_def_id;

Line: 20119

      SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES
      WHERE template_id=p_ui_page_id AND ui_def_id=p_ui_def_id;

Line: 20122

      SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES
      WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id;

Line: 20157

        UPDATE CZ_UI_PAGE_ELEMENTS
           SET deleted_flag=G_YES_FLAG
         WHERE ui_def_id=p_ui_def_id AND page_id=p_ui_page_id AND
               element_id=p_element_id;

Line: 20172

      SELECT template_id, jrad_doc, root_element_signature_id
        INTO l_ref_template_id, l_template_jrad_doc, l_root_element_signature_id
        FROM CZ_UI_TEMPLATES
      WHERE ui_def_id=p_ui_def_id AND jrad_doc=l_extends_attribute AND
            deleted_flag=G_NO_FLAG;

Line: 20179

        SELECT template_id, jrad_doc, root_element_signature_id
          INTO l_ref_template_id, l_template_jrad_doc, l_root_element_signature_id FROM CZ_UI_TEMPLATES
        WHERE ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID AND
              jrad_doc=l_extends_attribute AND
              deleted_flag=G_NO_FLAG;

Line: 20188

      SELECT ref_count
        INTO l_ref_count
        FROM CZ_UI_REF_TEMPLATES
      WHERE template_id=p_ui_page_id AND
            ref_template_id=l_ref_template_id AND
            deleted_flag=G_NO_FLAG;

Line: 20196

        DELETE FROM CZ_UI_REF_TEMPLATES
         WHERE template_id=p_ui_page_id AND
               ref_template_id=l_ref_template_id AND
               deleted_flag=G_NO_FLAG;

Line: 20201

        UPDATE CZ_UI_REF_TEMPLATES
           SET ref_count = ref_count-1
         WHERE template_id=p_ui_page_id AND
               ref_template_id=l_ref_template_id AND
               deleted_flag=G_NO_FLAG;

Line: 20208

      FOR reft IN (SELECT * FROM CZ_UI_REF_TEMPLATES
                    WHERE template_id=l_ref_template_id AND
                          deleted_flag=G_NO_FLAG)
      LOOP

        SELECT NVL(MAX(ref_count),0) INTO l_target_ref_count FROM CZ_UI_REF_TEMPLATES
         WHERE template_id=p_ui_page_id AND
               ref_template_id=reft.ref_template_id AND
               deleted_flag=G_NO_FLAG;

Line: 20220

          INSERT INTO CZ_UI_REF_TEMPLATES
          (
          TEMPLATE_ID
          ,REF_TEMPLATE_ID
          ,DELETED_FLAG
          ,TEMPLATE_UI_DEF_ID
          ,REF_TEMPLATE_UI_DEF_ID
          ,SEEDED_FLAG
          ,REF_TEMPL_SEEDED_FLAG
          ,REF_COUNT
          )
          VALUES
          (
           p_ui_page_id
          ,reft.ref_template_id
          ,G_NO_FLAG
          ,p_ui_def_id
          ,reft.REF_TEMPLATE_UI_DEF_ID
          ,G_NO_FLAG
          ,reft.REF_TEMPL_SEEDED_FLAG
          ,reft.ref_count
          );

Line: 20245

          UPDATE CZ_UI_REF_TEMPLATES
             SET ref_count=ref_count+l_target_ref_count
           WHERE template_id=p_ui_page_id AND
                 ref_template_id=reft.ref_template_id AND
                 deleted_flag=G_NO_FLAG;

Line: 20400

    l_out_xml_node := insert_before(l_parent_xml_node,l_new_xml_root_node,l_prev_xml_node);

Line: 20439

    UPDATE CZ_UI_TEMPLATES
       SET TEMPLATE_REV_NBR=TEMPLATE_REV_NBR+1
     WHERE ui_def_id=p_ui_def_id AND
           template_id=p_ui_page_id;

Line: 20444

    UPDATE CZ_UI_PAGES
       SET page_rev_nbr=page_rev_nbr+1
     WHERE ui_def_id=p_ui_def_id AND
           page_id=p_ui_page_id;

Line: 20517

    FOR i IN(SELECT rule_id,ui_page_id,ui_page_element_id,rule_type FROM CZ_RULES a
              WHERE ui_def_id=p_ui_def_id AND
                    deleted_flag=G_NO_FLAG AND disabled_flag=G_NO_FLAG)
    LOOP

      BEGIN

        IF i.ui_page_element_id IS NOT NULL AND i.ui_page_element_id<>'0' THEN
          SELECT element_id INTO l_element_id FROM CZ_UI_PAGE_ELEMENTS
           WHERE ui_def_id=p_ui_def_id AND page_id=i.ui_page_id AND
                 element_id=i.ui_page_element_id AND deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE);

Line: 20530

          SELECT element_id INTO l_element_id FROM CZ_UI_PAGE_ELEMENTS
           WHERE ui_def_id=p_ui_def_id AND page_id=i.ui_page_id AND
                 parent_element_id IS NULL AND deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE) AND rownum<2;

Line: 20533

          SELECT page_id INTO l_page_id FROM CZ_UI_PAGES
           WHERE page_id=i.ui_page_id AND ui_def_id=p_ui_def_id AND deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE);

Line: 20549

  PROCEDURE update_UI_Reference
  (
   p_ui_def_id              IN NUMBER,
   p_ref_persistent_node_id IN NUMBER,
   p_new_target_ui_def_id   IN NUMBER,
   x_return_status          OUT NOCOPY VARCHAR2,-- status string
   x_msg_count              OUT NOCOPY NUMBER,  -- number of error messages
   x_msg_data               OUT NOCOPY VARCHAR2 -- string which contains error messages
  ) IS

    l_target_primary_navigation  CZ_UI_DEFS.primary_navigation%TYPE;

Line: 20583

    SELECT primary_navigation, page_set_id
      INTO l_target_primary_navigation, l_target_page_set_id
      FROM CZ_UI_DEFS
     WHERE ui_def_id=p_new_target_ui_def_id;

Line: 20595

      UPDATE CZ_UI_PAGE_REFS
         SET deleted_flag=G_YES_FLAG
       WHERE ui_def_id=p_ui_def_id AND
             target_persistent_node_id=p_ref_persistent_node_id AND
             deleted_flag=G_NO_FLAG;

Line: 20605

      SELECT ps_node_id,parent_id,name
        INTO l_ref_ps_node_id,l_ref_parent_id,l_reference_name
        FROM CZ_PS_NODES
       WHERE devl_project_id=g_UI_Context.devl_project_id AND
             persistent_node_id=p_ref_persistent_node_id AND
             deleted_flag=G_NO_FLAG;

Line: 20612

      SELECT persistent_node_id
        INTO l_ref_parent_persist_node_id
        FROM CZ_PS_NODES
       WHERE ps_node_id=l_ref_parent_id AND
             deleted_flag=G_NO_FLAG;

Line: 20618

      FOR i IN(SELECT page_ref_id,node_depth,page_set_id,page_ref_type, seq_nbr
                 FROM CZ_UI_PAGE_REFS
                WHERE ui_def_id=p_ui_def_id AND
                      target_persistent_node_id=l_ref_parent_persist_node_id AND
                      page_ref_type=G_MODEL_TREE_MENU AND
                      deleted_flag=G_NO_FLAG)
      LOOP
	-- skip this block for Root record in split pages case to avoid data corruption
 	IF (i.node_depth <> 0 AND i.seq_nbr <> 0) THEN
          --
          -- update target_ui_def_id and target_page_set_id
          --
          UPDATE CZ_UI_PAGE_REFS
             SET target_ui_def_id=p_new_target_ui_def_id,
                 target_page_set_id=l_target_page_set_id
           WHERE ui_def_id=p_ui_def_id AND
                 parent_page_ref_id=i.page_ref_id AND
                 target_persistent_node_id=p_ref_persistent_node_id AND
                 deleted_flag=G_NO_FLAG;

Line: 20644

            SELECT NVL(MAX(seq_nbr),0)+1 INTO l_seq_nbr
              FROM CZ_UI_PAGE_REFS
             WHERE ui_def_id=p_ui_def_id AND
                   parent_page_ref_id=i.page_ref_id AND
                   deleted_flag=G_NO_FLAG;

Line: 20650

           SELECT MIN(model_ref_expl_id) INTO l_expl_node_id FROM CZ_MODEL_REF_EXPLS
            WHERE model_id=g_UI_Context.devl_project_id AND
                  referring_node_id=p_ref_persistent_node_id AND
                  deleted_flag=G_NO_FLAG;

Line: 20655

            INSERT INTO CZ_UI_PAGE_REFS
              (ui_def_id,
               page_set_id,
               page_ref_id,
               parent_page_ref_id,
               seq_nbr,
               node_depth,
               condition_id,
               NAME,
               caption_source,
               target_persistent_node_id,
               target_path,
               target_ui_def_id,
               target_page_set_id,
               target_page_id,
               modified_flags,
               path_to_prev_page,
               path_to_next_page,
               page_ref_type,
               target_expl_node_id,
               caption_rule_id,
               deleted_flag)
             VALUES
               (p_ui_def_id,
               i.page_set_id,
               l_page_ref_id,
               i.page_ref_id,
               l_seq_nbr,
               i.node_depth+1,
               NULL,
               l_reference_name,
               G_DEFAULT_CAPTION_RULE_ID,
               p_ref_persistent_node_id,
               l_ref_pagebase_path,
               p_new_target_ui_def_id,
               l_target_page_set_id,
               NULL,
               0,
               NULL,
               NULL,
               i.page_ref_type,
               l_expl_node_id,
               NULL,
               G_NO_FLAG);

Line: 20707

    SELECT ref_ui_def_id INTO l_old_child_ui_def_id
    FROM cz_ui_refs
    WHERE ui_def_id = p_ui_def_id AND ref_persistent_node_id = p_ref_persistent_node_id;

Line: 20711

    UPDATE cz_ui_page_elements
    SET target_page_ui_def_id = NULL, target_page_id = NULL
    WHERE deleted_flag = '0' AND target_page_ui_def_id = l_old_child_ui_def_id AND
          target_page_id IN (SELECT page_id FROM cz_ui_pages
                             WHERE ui_def_id = l_old_child_ui_def_id AND deleted_flag = '0') AND
          element_signature_id = G_PAGE_INCL_REGION_SIGNATURE;

Line: 20723

      fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'update_UI_Reference', x_msg_data);

Line: 20724

      DEBUG('update_UI_Reference() : '||x_msg_data);

Line: 20726

  END update_UI_Reference;

Line: 20815

    SELECT template_name
      INTO G_DRILLDOWN_TEMPLATE_NAME
      FROM CZ_UI_TEMPLATES
     WHERE template_id=G_DRILLDOWN_BUTTON_TEMPLATE_ID AND
           ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;