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: 595


      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: 658


    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: 726


    SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currentUINode FROM dual;

Line: 729


    SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;

Line: 732


    SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;

Line: 735


    SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;

Line: 738


    SELECT CZ_UI_ACTIONS_S.nextval INTO g_currentUIAction FROM dual;

Line: 756


    g_ui_def_nodes_tbl.DELETE;

Line: 757


    g_ui_pages_counter_tbl.DELETE;

Line: 758


    g_root_persist_id_tbl.DELETE;

Line: 759


    g_local_ui_context.DELETE;

Line: 760


    g_check_boundaries_tbl.DELETE;

Line: 761


    g_locked_templates_id_tbl.DELETE;

Line: 762


    g_elements_to_move.DELETE;

Line: 763


    g_dom_elements_to_move.DELETE;

Line: 764


    g_tgt_pg_to_src_pg_map.DELETE;

Line: 942


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

Line: 1022


        SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currUISeqVal FROM dual;

Line: 1030


        SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currPageRefSeqVal FROM dual;

Line: 1038


        SELECT CZ_UI_PAGES_S.nextval INTO g_currPageSeqVal FROM dual;

Line: 1046


        SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currPageSetSeqVal FROM dual;

Line: 1054


        SELECT CZ_UI_ACTIONS_S.nextval INTO g_currUIActionSeqVal FROM dual;

Line: 1062


        SELECT CZ_INTL_TEXTS_S.nextval INTO g_currIntlTextSeqVal FROM dual;

Line: 1067


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

Line: 1084


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

Line: 1092


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

Line: 1113


    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: 1125


  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: 1132


  END mark_UI_Page_As_Deleted;

Line: 1140


    UPDATE CZ_UI_DEFS
       SET ui_status=p_ui_status
     WHERE ui_def_id=p_ui_def_id;

Line: 1152


    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: 1162


      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: 1167


    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: 1181


        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: 1193


      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: 1199


      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: 1207


      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: 1213


      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: 1221


      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: 1226


      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: 1448


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

Line: 1478


    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: 1486


        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: 1533


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

Line: 1551


      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: 1579


        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: 1605


    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: 1634


    SELECT component_id, model_id, ps_node_type INTO l_reference_id, l_model_id, l_ps_node_type
      FROM cz_model_ref_expls
     WHERE model_ref_expl_id = p_expl_id
       AND deleted_flag = G_NO_FLAG;

Line: 1655


      FOR i in (SELECT model_ref_expl_id, child_model_expl_id, model_id
                  FROM cz_model_ref_expls
            START WITH model_ref_expl_Id = p_expl_id
            CONNECT BY PRIOR child_model_expl_id = model_ref_expl_Id
                   AND deleted_flag = G_NO_FLAG)
      LOOP
        l_node := get_Model_Node_By_Persist_Id(p_persistent_node_id, i.model_id);

Line: 1682


                             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: 1702


          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: 1712


      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: 1735


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

Line: 1773


          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: 1780


          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: 1808


    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: 1823


    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: 1839


    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: 1856


    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: 1864


        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: 1871


          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: 1899


        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: 1905


          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: 1911


            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: 1928


    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: 1956


      SELECT seeded_flag INTO l_seeded_flag FROM CZ_INTL_TEXTS
      WHERE intl_text_id=p_intl_text_id;

Line: 1962


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

Line: 1967


      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: 1989


      SELECT persistent_intl_text_id INTO l_persistent_intl_text_id
      FROM CZ_INTL_TEXTS
      WHERE INTL_TEXT_ID = l_ui_intl_text_id;

Line: 2006


    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: 2032


    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: 2056


    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: 2134


      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: 2312


      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: 2323


    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: 2357


    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: 2384


    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: 2423


         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: 2427


         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: 2431


         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: 2449


    SELECT parent_id INTO l_parent_id FROM CZ_PS_NODES
    WHERE ps_node_id=p_ps_node_id;

Line: 2457


      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: 2475


      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: 2575


    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: 2591


    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: 2606


    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: 2623


    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: 2654


      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: 2671


    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: 2700


    l_ui_page_set_node.deleted_flag  := G_NO_FLAG;

Line: 3031


    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: 3049


    l_mark_flag             CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;

Line: 3053


     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: 3068


        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: 3072


          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: 3079


          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: 3125


    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: 3132


    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: 3139


    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: 3144


    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: 3162


         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: 3170


           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: 3230


    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: 3238


    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: 3257


         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: 3265


           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: 3285


    l_undeleted_exist    BOOLEAN;

Line: 3292


      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: 3304


    l_undeleted_exist := FALSE;

Line: 3305


    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: 3323


         i.deleted_flag=G_NO_FLAG THEN
        RETURN G_CX_VALID;

Line: 3330


      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: 3364


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

Line: 3369


           i.deleted_flag=G_NO_FLAG THEN
          RETURN G_CX_VALID;

Line: 3376


    IF l_undeleted_exist=FALSE THEN
      RETURN G_CX_MUST_BE_DELETED;

Line: 3394


      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: 3401


        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: 3406


           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: 3414


      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: 3449


    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: 3455


    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: 3534


    g_model_nodes_tbl.DELETE;

Line: 3535


    g_ui_page_elements_tbl.DELETE;

Line: 3536


    g_ps_node_persist_id_tbl.DELETE;

Line: 3537


    g_ui_pages_tbl.DELETE;

Line: 3538


    g_ui_page_refs_tbl.DELETE;

Line: 3539


    g_ui_refs_tbl.DELETE;

Line: 3540


    g_ui_page_sets_tbl.DELETE;

Line: 3541


    g_ref_expls_tbl.DELETE;

Line: 3542


    g_ui_action_ids_tbl.DELETE;

Line: 3554


    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: 3563


    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: 3575


    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: 3589


    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: 3605


    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: 3613


    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: 3621


    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: 3629


    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: 4328


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

Line: 4332


    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: 4340


    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: 4412


             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: 4434


             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: 4630


            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: 4653


    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: 4672


      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: 4680


          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: 4934


        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: 5333


    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: 5352


    SELECT name INTO l_ui_name FROM CZ_UI_DEFS
    WHERE ui_def_id=p_ui_def_id;

Line: 5397


      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: 5421


             UPDATE CZ_RULES
                SET component_id = p_new_component_id,
                    model_ref_expl_id = p_new_expl_node_id
              WHERE rule_id = x_rule_id;

Line: 5433


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

Line: 5446


            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: 5499


      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: 5539


    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: 5548


    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 or the root
      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: 5572


          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: 5620


    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: 5684


      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: 5704


              SELECT persistent_node_id, pagebase_expl_node_id
                INTO l_base_persistent_node_id, l_base_expl_node_id
                FROM CZ_UI_PAGES
               WHERE ui_def_Id = p_target_ui_def_id
                 AND page_Id = p_target_ui_page_id;

Line: 5720


          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
--Processing page ER 9656558
          ,PROCESSING_PAGE_ENABLED_FLAG
          )
          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
          ,i.PROCESSING_PAGE_ENABLED_FLAG
          );

Line: 5835


            SELECT persistent_rule_id INTO l_persistent_rule_id
            FROM cz_rules
            WHERE rule_id = l_new_rule_id;

Line: 5867


              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
                l_persistent_intl_text_id_tmp := null;

Line: 5875


                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
                ) RETURNING PERSISTENT_INTL_TEXT_ID INTO l_persistent_intl_text_id_tmp;

Line: 5958


        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: 6025


      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: 6034


          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
--Processing page ER 9656558
       		,PROCESSING_PAGE_ENABLED_FLAG
          )
          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
          ,i.PROCESSING_PAGE_ENABLED_FLAG
          );

Line: 6123


            SELECT persistent_rule_id INTO l_persistent_rule_id
            FROM cz_rules
            WHERE rule_id = l_new_rule_id;

Line: 6156


              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_persistent_intl_text_id_tmp := null;

Line: 6164


                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
                ) RETURNING PERSISTENT_INTL_TEXT_ID INTO l_persistent_intl_text_id_tmp;

Line: 6228


        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: 6368


            SELECT persistent_rule_id INTO l_persistent_rule_id
            FROM cz_rules
            WHERE rule_id = l_new_refenabledCondnId;

Line: 6398


            SELECT persistent_rule_id INTO l_persistent_rule_id
            FROM cz_rules
            WHERE rule_id = l_new_refdisplayCondnId;

Line: 6437


  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: 6447


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

Line: 6451


  END insert_before;

Line: 6453


  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: 6515


      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: 6541

      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: 6572

        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: 6591

        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: 6607

    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: 6628

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

Line: 6631

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

Line: 6637

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

Line: 6639

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

Line: 6657

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

Line: 6662

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

Line: 6666

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

Line: 6670

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

Line: 6673

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

Line: 6677

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

Line: 6680

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

Line: 6702

  END insert_node;

Line: 6758

  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: 6770

  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: 6775

  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: 6785

  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: 6796

      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: 6804

  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: 6813

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

Line: 6818

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

Line: 6933

      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: 6961

      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: 7137

              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: 7291

        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: 7313

        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: 7375

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

Line: 7378

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

Line: 7384

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

Line: 7386

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

Line: 7404

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

Line: 7409

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

Line: 7413

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

Line: 7417

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

Line: 7420

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

Line: 7424

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

Line: 7427

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

Line: 7522

      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: 7791

              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: 8380

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

Line: 8484

        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: 8519

        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_base_persistent_node_id => p_base_persistent_node_id,
                                                        p_base_expl_id         => p_base_expl_id,
                                                        p_persistent_node_id   => i.target_persistent_node_id,
                                                        p_ui_node_expl_id      => i.target_expl_node_id);

Line: 8532

            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: 8614

                 SELECT persistent_node_id, model_ref_expl_id INTO l_persistent_node_id, l_expl_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: 8683

    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: 8757

      l_attr_tbl.DELETE;

Line: 8865

          l_attr_tbl.DELETE;

Line: 8902

            l_attr_tbl.DELETE;

Line: 8934

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

Line: 9049

    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: 9059

      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: 9067

    SELECT TEMPLATE_TOKEN INTO G_CAPTION_RULE_TOKENNAME FROM CZ_RULES
    WHERE rule_id=G_DEFAULT_CAPTION_RULE_ID;

Line: 9171

    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: 9178

      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: 9193

    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: 9340

    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: 9362

    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: 9416

    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: 9420

    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: 9467

    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: 9497

        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: 9518

        SELECT persistent_intl_text_id INTO l_persistent_intl_text_id
        FROM CZ_INTL_TEXTS
        WHERE INTL_TEXT_ID = l_ui_intl_text_id;

Line: 9531

        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: 9539

       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: 9580

         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: 9637

    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: 9678

          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: 9698

          SELECT persistent_intl_text_id INTO l_persistent_intl_text_id
          FROM CZ_INTL_TEXTS
          WHERE INTL_TEXT_ID = l_ui_intl_text_id;

Line: 9712

          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: 9753

         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: 9805

         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: 9816

         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: 9820

         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: 9862

     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: 9898

             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: 9919

            SELECT persistent_intl_text_id INTO l_persistent_intl_text_id
            FROM CZ_INTL_TEXTS
            WHERE INTL_TEXT_ID = l_ui_intl_text_id;

Line: 9933

            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: 9974

            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: 10042

    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: 10076

     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: 10087

     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: 10117

           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: 10138

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

    l_ui_node                 CZ_UI_PAGE_ELEMENTS%ROWTYPE;

Line: 10154

      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: 10175

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

Line: 10177

      l_ui_node.seq_nbr := p_insert_index;

Line: 10179

    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: 10193

    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: 10238

    l_ui_node.deleted_flag                := G_MARK_TO_ADD;

Line: 10240

    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: 10250

    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: 10319

    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: 10332

    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: 10353

    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: 10392

    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: 10437

    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: 10475

    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: 10519

     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: 10530

    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: 10576

      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: 10582

      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: 10643

        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: 10654

          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: 10664

        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: 10673

        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: 10680

        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: 10687

            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: 10717

      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: 10734

          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: 10743

            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: 10766

          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: 10851

        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: 10930

    l_page_node.deleted_flag          := G_MARK_TO_ADD;

Line: 10932

    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: 10988

    l_page_ui_node.deleted_flag                := G_MARK_TO_ADD;

Line: 10993

    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: 11051

      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: 11080

   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: 11098

         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: 11107

         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: 11121

      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: 11190

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

    l_ui_node                 CZ_UI_PAGE_ELEMENTS%ROWTYPE;

Line: 11212

      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: 11227

    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: 11239

      l_max_prev_seq_nbr := p_insert_index-1;

Line: 11244

    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: 11264

    l_ui_node.deleted_flag                := G_MARK_TO_ADD;

Line: 11266

    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: 11274

    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: 11382

    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: 11395

    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: 11420

    l_ui_node.deleted_flag                    := G_MARK_TO_ADD;

Line: 11422

    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: 11437

         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: 11444

         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: 11453

         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: 11475

    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: 11514

      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: 11521

        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: 11541

    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: 11592

    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: 11605

         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: 11610

         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: 11619

        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: 11626

        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: 11637

      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: 11685

  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: 11698

       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: 11734

       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: 11748

      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: 11771

      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: 11783

        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: 11801

  END delete_UI_Element;

Line: 11815

        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: 11821

        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: 11832

        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: 11846

  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: 11850

    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: 11863

           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: 11875

         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: 11882

         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: 11893

  END delete_Related_Buttons;

Line: 11898

  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: 11914

      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: 11922

       delete_Related_Buttons(p_ui_node);

Line: 11927

       mark_UI_Page_As_Deleted(p_ui_node.page_id, p_ui_node.ui_def_id);

Line: 11936

      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: 11961

          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: 11973

        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: 11980

        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: 11987

      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: 11994

  END delete_UI_Container;

Line: 11996

  PROCEDURE handle_Deleted_Nodes(p_ui_def_id IN NUMBER) IS

    l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;

Line: 12003

    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: 12012

    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: 12021

  END handle_Deleted_Nodes;

Line: 12026

  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: 12043

    delete_UI_Container(p_ui_node);

Line: 12045

  END delete_UI_Page;

Line: 12050

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

Line: 12053

  END delete_UI_Region;

Line: 12066

    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: 12073

      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: 12082

          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: 12098

      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: 12109

        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: 12117

      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: 12160

      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: 12165

      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: 12174

        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: 12181

        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: 12196

          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: 12208

          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: 12214

          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: 12244

      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: 12247

      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: 12281

    l_mark_flag              CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;

Line: 12286

    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: 12290

      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: 12300

     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: 12322

        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: 12336

      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: 12384

        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: 12425

      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: 12442

      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: 12464

      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: 12499

      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: 12531

    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 AND
           page_Id = p_ui_node.page_id;  --vsingava IM-ER

Line: 12571

         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: 12577

         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: 12604

      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: 12635

      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: 12666

      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: 12683

     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: 12690

   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: 12696

    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: 12703

      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: 12746

      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: 12758

        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: 12795

      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: 12801

      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: 12821

      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: 12845

                            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: 12870

              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: 12892

                                            p_insert_index      => p_insert_index);

Line: 12907

                                               p_insert_index      => p_insert_index);

Line: 12926

      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: 12955

                    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: 13039

           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: 13044

                 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: 13058

                     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: 13081

                     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: 13087

                     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: 13095

                      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: 13142

                      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: 13207

   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: 13230

   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: 13296

    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: 13306

    l_ui_node.deleted_flag := G_MARK_TO_ADD;

Line: 13308

    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: 13347

    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: 13353

    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: 13367

    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: 13434

    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: 13484

      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: 13491

        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: 13498

      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: 13514

        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: 13534

    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: 13560

    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: 13605

      l_nested_rgn_elements_tbl.DELETE;

Line: 13607

      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: 13644

          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: 13689

          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: 13768

    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: 13780

      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: 13787

        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: 13797

    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: 13842

      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: 13862

       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: 13869

          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: 13878

     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: 13893

    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: 13922

       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: 13937

            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: 13949

    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: 13956

      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: 13985

    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: 14014

        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: 14036

    l_delete_in_model BOOLEAN;

Line: 14054

    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: 14067

          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: 14076

      l_delete_in_model := TRUE;

Line: 14077

      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: 14105

            delete_UI_Page(i);

Line: 14112

            delete_UI_Region(i);

Line: 14118

            delete_UI_Element(i, p_suppress_refresh_flag, l_delete_in_model);

Line: 14123

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

Line: 14134

  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: 14167

          delete_UI_Page(l_current_ui_node);

Line: 14174

          delete_UI_Region(l_current_ui_node);

Line: 14180

          delete_UI_Element(l_current_ui_node, p_suppress_refresh_flag);

Line: 14186

      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: 14193

  END delete_UI_Nodes;

Line: 14207

    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: 14212

      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: 14221

      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: 14280

    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: 14293

            delete_UI_Region(l_ui_node);

Line: 14299

            delete_UI_Element(l_ui_node,p_suppress_refresh_flag, TRUE);

Line: 14397

    l_element_id_tbl.DELETE;

Line: 14398

    l_page_id_tbl.DELETE;

Line: 14399

    l_suppress_refresh_flag_tbl.DELETE;

Line: 14404

    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: 14456

    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: 14484

    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: 14499

          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: 14505

            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: 14513

          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: 14519

            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: 14538

       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: 14547

         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: 14556

    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: 14568

        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: 14574

        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: 14578

        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: 14593

    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: 14636

         SELECT persistent_node_id, model_ref_expl_id
           INTO l_id_pair.persistent_node_id, l_id_pair.expl_node_id
           FROM cz_ui_page_elements
           WHERE ui_def_Id = p_ui_def_id
             AND page_Id = p_page_id
            AND element_Id = l_element_with_AMN;

Line: 14685

    FOR i IN(SELECT page_id,pagebase_expl_node_id, jrad_doc FROM CZ_UI_PAGES  --vsingava IM-ER
             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

      l_xml_doc := l_null_xml_doc;

Line: 14692

      FOR k IN(SELECT *
                 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_instance_list_amn.persistent_node_id := NULL;

Line: 14741

                                 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: 14771

          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: 14786

        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: 14808

            x_insert_index := i.seq_nbr + 1;

Line: 14820

        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: 14832

            x_insert_index := i.seq_nbr + 1;

Line: 14845

        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: 14857

            x_insert_index := i.seq_nbr;

Line: 14874

        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: 14894

            x_insert_index := -1;

Line: 14906

        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: 14917

            x_insert_index := -1;

Line: 14939

    l_insert_index                NUMBER;

Line: 14957

                           l_insert_index,
                           l_parent_node_found,
                           l_atleast_one_parent_found);

Line: 14965

                          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: 14997

                          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: 15020

      l_insert_index                NUMBER;

Line: 15030

    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: 15048

              delete_UI_Region(i);

Line: 15061

              delete_UI_Element(i, l_suppress_refresh_flag, TRUE);

Line: 15078

      l_insert_index                NUMBER;

Line: 15105

        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: 15118

      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: 15166

                             l_insert_index,
                             l_parent_node_found,
                             l_atleast_one_parent_found);

Line: 15175

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

Line: 15178

              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: 15189

                  l_insert_index  := l_max_prev_seq_nbr + 1;

Line: 15192

            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: 15206

            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: 15213

            l_diff := l_insert_index - i.seq_nbr;

Line: 15215

            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: 15226

            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: 15235

            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: 15248

            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: 15262

            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: 15283

              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: 15304

              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: 15333

      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: 15366

      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: 15397

          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: 15404

          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: 15434

          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: 15445

          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: 15476

      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: 15567

            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: 15595

      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: 15646

            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: 15662

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

Line: 15683

                      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: 15699

                    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: 15792

    FOR t IN (SELECT ps_node_id,persistent_node_id as psnode_persistent_node_id,ps_node_type,component_id
                FROM CZ_PS_NODES psnode
               START WITH 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) OR
                         psnode.ui_timestamp_changetype > NVL(g_UI_Context.ui_timestamp_refresh, g_UI_Context.creation_date)  )
                CONNECT BY PRIOR ps_node_id=parent_id AND deleted_flag='0'
               )
    LOOP

        SELECT MIN(model_ref_expl_id) INTO l_expl_id FROM CZ_MODEL_REF_EXPLS
         WHERE model_id=g_UI_Context.devl_project_id AND deleted_flag='0' AND
              ((t.ps_node_type NOT IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) AND component_id=t.component_id) OR
              (t.ps_node_type IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) AND referring_node_id=t.ps_node_id));

Line: 15810

        FOR upgel IN(SELECT b.*,a.pagebase_expl_node_id,a.jrad_doc FROM CZ_UI_PAGES a,CZ_UI_PAGE_ELEMENTS b
                      WHERE a.ui_def_id=g_UI_Context.ui_def_id AND b.ui_def_id=g_UI_Context.ui_def_id AND
                            a.deleted_flag IN(G_MARK_TO_ADD, G_MARK_TO_REFRESH, G_NO_FLAG) AND
                            a.page_id=b.page_id AND
                            b.persistent_node_id = t.psnode_persistent_node_id)
        LOOP

          UPDATE CZ_UI_PAGE_ELEMENTS
             SET model_ref_expl_id=l_expl_id
           WHERE ui_def_id=g_UI_Context.ui_def_id AND
                 page_id=upgel.page_id AND
                 persistent_node_id=t.psnode_persistent_node_id AND
                 model_ref_expl_id<>l_expl_id;

Line: 15824

          UPDATE CZ_UI_PAGES
             SET pagebase_expl_node_id=l_expl_id
           WHERE ui_def_id=g_UI_Context.ui_def_id AND
                 page_id=upgel.page_id AND
                 persistent_node_id=t.psnode_persistent_node_id AND
                 pagebase_expl_node_id<>l_expl_id;

Line: 15831

          UPDATE CZ_UI_PAGE_SETS
             SET pagebase_expl_node_id=l_expl_id
           WHERE ui_def_id=g_UI_Context.ui_def_id AND
                 persistent_node_id=t.psnode_persistent_node_id AND
                 pagebase_expl_node_id<>l_expl_id;

Line: 15837

          UPDATE CZ_UI_PAGE_REFS
             SET target_expl_node_id=l_expl_id
           WHERE ui_def_id=g_UI_Context.ui_def_id AND
                 target_persistent_node_id=t.psnode_persistent_node_id AND
                 target_expl_node_id<>l_expl_id;

Line: 15843

          UPDATE CZ_UI_ACTIONS
             SET target_expl_node_id=l_expl_id
           WHERE ui_def_id=g_UI_Context.ui_def_id AND
                 target_persistent_node_id=t.psnode_persistent_node_id AND
                 target_expl_node_id<>l_expl_id;

Line: 15849

          IF upgel.deleted_flag=G_NO_FLAG THEN
             UPDATE CZ_UI_PAGES
                SET deleted_flag=G_MARK_TO_REFRESH
              WHERE ui_def_id=g_UI_Context.ui_def_id AND
                    page_id=upgel.page_id AND
                    deleted_flag=G_NO_FLAG;

Line: 15869

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

Line: 15909

    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: 15924

    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: 15948

      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: 15966

    handle_Deleted_Nodes(g_UI_Context.ui_def_id);

Line: 16023

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

    l_deleted_nodes_tbl     varchar2_tbl_type;

Line: 16033

    l_deleted_nodes_exist      BOOLEAN := FALSE;

Line: 16039

    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: 16067

          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: 16072

               l_deleted_nodes_exist := TRUE;

Line: 16089

    IF l_deleted_nodes_exist THEN

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

Line: 16096

      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: 16102

        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: 16108

  END delete_UIXML_Elements;

Line: 16113

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

    l_subtree_doc           xmldom.DOMDocument;

Line: 16142

          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: 16154

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

Line: 16159

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

Line: 16163

      jdr_docbuilder.deleteDocument(p_jrad_doc);

Line: 16166

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

Line: 16173

                          p_hmode   => G_DELETE_PAGE);

Line: 16175

  END delete_UIXML_Page;

Line: 16194

    l_delete_node           BOOLEAN := FALSE;

Line: 16199

    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: 16212

           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: 16236

      l_delete_node     := FALSE;

Line: 16253

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

Line: 16266

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

Line: 16271

          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: 16279

          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: 16289

    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: 16308

    g_page_elements_tbl.DELETE;

Line: 16361

      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: 16404

       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: 16420

       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: 16424

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

Line: 16447

      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: 16486

  g_dom_elements_tbl.DELETE;

Line: 16488

    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: 16522

    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: 16550

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

Line: 16615

      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: 16706

    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: 16809

      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: 16821

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

Line: 16856

    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: 16870

        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: 16903

      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: 16918

    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: 16941

      SELECT name INTO l_name
      FROM cz_ui_defs
      WHERE ui_def_id = p_ui_def_id;

Line: 16951

      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: 16963

      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: 16968

      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: 16996

          SELECT persistent_node_id, name, page_Id INTO l_target_persistent_node_id, l_name, l_page_Id
          FROM   cz_ui_pages
          WHERE  ui_def_id = p_element.target_page_ui_def_id AND
                 page_id = p_element.target_page_id AND deleted_flag <> '1';

Line: 17006

            DEBUG('Removing PIR ' || p_element.NAME || ' because target page is deleted.');

Line: 17133

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

Line: 17150

    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
      l_ui_def_map(i.ref_ui_def_id) := i.ref_ui_def_id;

Line: 17174

      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 = '0'
                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='0'))
      LOOP
        EXIT WHEN l_flag = 0;

Line: 17187

        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='0')
        LOOP
          EXIT WHEN l_flag <> 1;

Line: 17197

          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: 17239

    UPDATE cz_ui_defs
    SET UI_TIMESTAMP_REFRESH = SYSDATE
    WHERE ui_def_id = p_ui_def_id;

Line: 17298

      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: 17319

          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: 17326

            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: 17354

    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: 17449

      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: 17453

      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: 17515

    INSERT INTO CZ_DB_LOGS( LOGTIME , CALLER, MESSAGE )
	VALUES ( SYSDATE , p_caller , p_message );

Line: 17526

 PROCEDURE delete_Invalid_UI_Elements(p_ui_def_id IN NUMBER) IS

  BEGIN

      FOR uiDefCur IN (SELECT ref_ui_def_id FROM (SELECT DISTINCT ref_ui_def_id
            FROM CZ_UI_REFS
            START WITH ui_def_id = p_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 PRIOR deleted_flag = G_NO_FLAG
            UNION SELECT ui_def_id  FROM CZ_UI_DEFS uiDef WHERE uiDef.ui_def_id = p_ui_def_id  AND uiDef.ui_style = G_OA_STYLE_UI AND deleted_flag = G_NO_FLAG )

                    )
    LOOP


    -- Verify for cz_ui_pages.pagebase_expl_node_id
      FOR uiPages IN (SELECT uipg.page_id,uipg.pagebase_expl_node_id FROM CZ_UI_PAGES uipg
                         WHERE deleted_flag = G_NO_FLAG AND ui_def_id = uiDefCur.ref_ui_def_id
                           AND uipg.pagebase_expl_node_id IS NOT NULL
                           AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
                                           WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = uipg.pagebase_expl_node_id
                                          )
                      )
      LOOP

	        log_message( 'UI_REFRESH' , 'UPDATE  deleted_flag of CZ_UI_PAGES where pagebase_expl_node_id : ' || uiPages.pagebase_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);

Line: 17552

		UPDATE CZ_UI_PAGES
		SET deleted_flag = G_YES_FLAG
		WHERE pagebase_expl_node_id = uiPages.pagebase_expl_node_id
		AND page_id = uiPages.page_id
		AND ui_def_id = uiDefCur.ref_ui_def_id;

Line: 17561

      FOR pageRefs IN (SELECT pgref.page_ref_id,pgref.target_expl_node_id FROM CZ_UI_PAGE_REFS pgref
                         WHERE pgref.deleted_flag = G_NO_FLAG AND pgref.ui_def_id = uiDefCur.ref_ui_def_id
                           AND pgref.target_expl_node_id IS NOT NULL
                           AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
                                           WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = pgref.target_expl_node_id
                                          )
                      )
      LOOP

       log_message( 'UI_REFRESH' , 'UPDATE  deleted_flag of CZ_UI_PAGE_REFS where target_expl_node_id : ' || pageRefs.target_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);

Line: 17572

		UPDATE CZ_UI_PAGE_REFS
		SET deleted_flag = G_YES_FLAG
		WHERE target_expl_node_id = pageRefs.target_expl_node_id
		AND page_ref_id = pageRefs.page_ref_id
		AND ui_def_id = uiDefCur.ref_ui_def_id;

Line: 17581

      FOR pageSets IN (SELECT pgset.page_set_id,pgset.pagebase_expl_node_id FROM CZ_UI_PAGE_SETS pgset
                         WHERE pgset.deleted_flag = G_NO_FLAG AND pgset.ui_def_id = uiDefCur.ref_ui_def_id
                           AND pgset.pagebase_expl_node_id IS NOT NULL
                           AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
                                           WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = pgset.pagebase_expl_node_id
                                          )
                      )
      LOOP

		log_message( 'UI_REFRESH' , 'UPDATE  deleted_flag of CZ_UI_PAGE_SETS where pagebase_expl_node_id : ' || pageSets.pagebase_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);

Line: 17592

		UPDATE CZ_UI_PAGE_SETS
		SET deleted_flag = G_YES_FLAG
		WHERE pagebase_expl_node_id = pageSets.pagebase_expl_node_id
		AND page_set_id = pageSets.page_set_id
		AND ui_def_id = uiDefCur.ref_ui_def_id;

Line: 17600

      FOR uiPges IN (SELECT  element_id,model_ref_expl_id FROM CZ_UI_PAGE_ELEMENTS pge
                         WHERE pge.deleted_flag = G_NO_FLAG AND pge.ui_def_id = uiDefCur.ref_ui_def_id
                           AND pge.model_ref_expl_id IS NOT NULL
                           AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
                                           WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = pge.model_ref_expl_id
                                          )
                      )
      LOOP

		log_message( 'UI_REFRESH' , 'UPDATE  deleted_flag of CZ_UI_PAGE_ELEMENTS where model_ref_expl_id : ' || uiPges.model_ref_expl_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);

Line: 17611

		UPDATE CZ_UI_PAGE_ELEMENTS
		SET deleted_flag = G_YES_FLAG
		WHERE model_ref_expl_id = uiPges.model_ref_expl_id
		AND element_id = uiPges.element_id
		AND ui_def_id = uiDefCur.ref_ui_def_id;

Line: 17621

      FOR uiActs IN (SELECT uiact.ui_action_id,uiact.target_expl_node_id FROM CZ_UI_ACTIONS uiact
                         WHERE uiact.deleted_flag = G_NO_FLAG AND uiact.ui_def_id = uiDefCur.ref_ui_def_id
                           AND uiact.target_expl_node_id IS NOT NULL
                           AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
                                           WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = uiact.target_expl_node_id
                                          )
                      )
      LOOP


		log_message( 'UI_REFRESH' , 'UPDATE  deleted_flag of CZ_UI_ACTIONS where target_expl_node_id : ' || uiActs.target_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);

Line: 17633

		UPDATE CZ_UI_ACTIONS
		SET deleted_flag = G_YES_FLAG
		WHERE target_expl_node_id = uiActs.target_expl_node_id
		AND ui_action_id = uiActs.ui_action_id
		AND ui_def_id = uiDefCur.ref_ui_def_id;

Line: 17642

END delete_Invalid_UI_Elements;

Line: 17683

      delete_Invalid_UI_Elements(p_ui_def_id);

Line: 17738

  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: 17753

          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: 17760

              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: 17775

            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: 17782

              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: 17798

            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: 17805

              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: 17818

  END delete_User_Attr_For_Node;

Line: 17871

        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: 17875

        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: 17916

       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: 17932

       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: 18011

  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: 18027

    delete_User_Attr_For_Node(p_xml_node,p_ui_def_id,
                              p_template_id, p_template_ui_def_id);

Line: 18040

      delete_User_Attr_For_Node(l_child_xml_node,p_ui_def_id,
                                p_template_id, p_template_ui_def_id);

Line: 18043

      delete_User_Attributes(l_child_xml_node,p_ui_def_id,
                             p_template_id, p_template_ui_def_id);

Line: 18048

  END delete_User_Attributes;

Line: 18123

    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: 18139

        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: 18141

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

Line: 18156

    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: 18167

        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: 18175

          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: 18190

        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: 18211

          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: 18363

    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: 18385

        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: 18484

          SELECT persistent_node_id, model_ref_expl_id
            INTO l_amn_persistent_node_id, l_amn_expl_node_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 = l_amn_parent_element_id;

Line: 18529

        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: 18553

       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: 18594

           SELECT persistent_node_id, model_ref_expl_id
             INTO l_base_persistent_node_id, l_base_expl_node_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 = l_amn_parent_element_id;

Line: 18604

       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: 18620

       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: 18720

  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: 18754

    g_ui_def_nodes_tbl.DELETE;

Line: 18760

    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: 18777

    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: 18784

    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: 18787

    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: 18799

        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: 18805

          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: 18819

          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: 18831

      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: 18837

      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: 18841

      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: 18849

      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: 18856

      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: 18864

      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: 18895

    delete_User_Attributes(l_xml_node, p_ui_def_id);

Line: 18897

    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: 18907

      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: 18930

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

Line: 18932

  END delete_UI_Subtree;

Line: 18940

  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: 18961

    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: 18979

    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: 18988

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

Line: 18990

  END delete_UI_Page;

Line: 18996

  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: 19018

    g_ui_def_nodes_tbl.DELETE;

Line: 19025

    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: 19032

      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: 19046

      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: 19056

    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: 19075

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

Line: 19077

  END delete_UI_Page_Ref;

Line: 19086

  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: 19105

    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: 19115

    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: 19139

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

Line: 19142

    jdr_docbuilder.deleteDocument(l_jrad_doc);

Line: 19149

    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: 19153

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

Line: 19156

    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: 19171

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

Line: 19172

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

Line: 19173

  END delete_Local_Template;

Line: 19179

  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: 19209

    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: 19244

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

Line: 19246

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

Line: 19255

    delete_User_Attributes(l_xml_node, p_template_ui_def_id,
                           p_template_id, p_template_ui_def_id);

Line: 19280

    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: 19304

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

Line: 19305

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

Line: 19311

  END delete_Local_Template_Elem;

Line: 19356

    g_handled_attr_id_tbl.DELETE;

Line: 19361

    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: 19366

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

Line: 19374

      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: 19469

    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: 19475

    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: 19537

    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: 19545

    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: 19682

    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: 19690

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

Line: 19696

    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: 19709

    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: 19727

      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: 19878

    g_handled_attr_id_tbl.DELETE;

Line: 19882

    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: 19890

    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: 19998

    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: 20002

    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: 20005

    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: 20039

      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: 20057

        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: 20122

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

Line: 20165

    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: 20225

    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: 20269

    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: 20398

      jdr_docbuilder.deleteDocument(p_source_jrad_doc);

Line: 20402

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

Line: 20457

    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: 20461

    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: 20578

    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: 20676

    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: 20679

    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: 20894

    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: 20979

    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: 20982

    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: 21130

    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: 21235

      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: 21238

      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: 21273

        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: 21288

      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: 21295

        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: 21304

      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: 21312

        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: 21317

        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: 21324

      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: 21336

          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: 21361

          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: 21516

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

Line: 21555

    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: 21560

    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: 21633

    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: 21646

          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: 21649

          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: 21665

  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: 21699

    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: 21711

      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: 21721

      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: 21728

      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: 21734

      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: 21760

            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: 21766

           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: 21771

            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: 21823

    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: 21827

    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: 21839

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

Line: 21840

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

Line: 21842

  END update_UI_Reference;

Line: 21931

    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;