[Home] [Help]
716: --
717: PROCEDURE Initialize_Sequences IS
718: BEGIN
719:
720: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currentUINode FROM dual;
721: g_currUISeqVal := g_currentUINode;
722:
723: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;
724: g_currPageRefSeqVal := g_currentPageRef;
1008: --
1009: FUNCTION allocateId(p_sequence_name IN VARCHAR2) RETURN NUMBER IS
1010: l_id NUMBER;
1011: BEGIN
1012: IF p_sequence_name='CZ_UI_PAGE_ELEMENTS_S' THEN
1013: IF g_currentUINode
1015: ELSE
1016: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currUISeqVal FROM dual;
1012: IF p_sequence_name='CZ_UI_PAGE_ELEMENTS_S' THEN
1013: IF g_currentUINode
1015: ELSE
1016: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currUISeqVal FROM dual;
1017: g_currentUINode := g_currUISeqVal;
1018: END IF;
1019: RETURN g_currentUINode;
1020: ELSIF p_sequence_name='CZ_UI_PAGE_REFS_S' THEN
1094: -- return new element_id
1095: --
1096: FUNCTION get_Element_Id RETURN VARCHAR2 IS
1097: BEGIN
1098: RETURN TO_CHAR(allocateId('CZ_UI_PAGE_ELEMENTS_S'));
1099: END get_Element_Id;
1100:
1101: --
1102: -- mark UI page as deleted
2982: --
2983: PROCEDURE remove_Instance_Controls(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
2984:
2985: l_changed_pages_tbl number_tbl_type;
2986: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
2987: l_mark_flag CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;
2988:
2989: BEGIN
2990:
9934: p_page_set_id IN NUMBER) IS
9935:
9936: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9937: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9938: l_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
9939: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
9940:
9941: BEGIN
9942:
10865: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
10866: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
10867: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10868: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10869: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
10870: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
10871: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
10872: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
10873: l_counter NUMBER;
11203: --
11204: -- delete UI element recursively
11205: --
11206: PROCEDURE delete_UI_Element(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11207: p_suppress_refresh_flag IN CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE DEFAULT NULL,
11208: p_delete_in_model IN BOOLEAN DEFAULT NULL) IS
11209:
11210: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11211: l_del_flag BOOLEAN := FALSE;
11206: PROCEDURE delete_UI_Element(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11207: p_suppress_refresh_flag IN CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE DEFAULT NULL,
11208: p_delete_in_model IN BOOLEAN DEFAULT NULL) IS
11209:
11210: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11211: l_del_flag BOOLEAN := FALSE;
11212: BEGIN
11213:
11214: --
11364: NULL;
11365: END remove_UI_Page_Ref;
11366:
11367: PROCEDURE delete_Related_Buttons(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
11368: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11369: BEGIN
11370:
11371: FOR i IN(SELECT element_id,parent_element_id,page_id,suppress_refresh_flag
11372: FROM CZ_UI_PAGE_ELEMENTS a
11422: l_parent_element_id_tbl varchar_tbl_type;
11423: l_persistent_node_id_tbl number_tbl_type;
11424: l_suppress_refresh_flag_tbl varchar_tbl_type;
11425: l_page_id_tbl number_tbl_type;
11426: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11427:
11428: BEGIN
11429:
11430: --
11515: END delete_UI_Container;
11516:
11517: PROCEDURE handle_Deleted_Nodes(p_ui_def_id IN NUMBER) IS
11518:
11519: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11520:
11521: BEGIN
11522:
11523: -- delete UI References
13769:
13770: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
13771: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
13772: l_new_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
13773: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
13774: l_current_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
13775: l_seq_nbr NUMBER;
13776: l_max_split_nbr NUMBER;
13777: l_page_split_seq_nbr NUMBER;
14357: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14358: l_temp_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14359: l_next_level_ui_pages_tbl ui_page_elements_tbl_type;
14360: l_insert_index NUMBER;
14361: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
14362: l_parent_node_found BOOLEAN;
14363: l_atleast_one_parent_found BOOLEAN;
14364: l_nodes_tbl model_nodes_tbl_type;
14365: l_seq_nodes_tbl ui_page_el_int_tbl_type; -- fix for bug 6837809 : skudryav 28-Mar-2008
14438: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14439:
14440: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14441: l_insert_index NUMBER;
14442: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
14443: l_parent_node_found BOOLEAN;
14444:
14445: BEGIN
14446:
14496: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14497:
14498: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14499: l_insert_index NUMBER;
14500: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
14501: l_parent_node_found BOOLEAN;
14502: l_diff NUMBER;
14503: l_max_prev_seq_nbr NUMBER;
14504: l_max_src_seq_nbr NUMBER;
14949: l_bom_table_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
14950: l_page_id NUMBER;
14951:
14952: l_bom_parent_element CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
14953: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
14954:
14955: BEGIN
14956:
14957: l_added_ui := FALSE;
15528: l_suppress_refresh_tbl varchar_tbl_type;
15529: l_suppress_el_flag_tbl varchar_tbl_type;
15530: l_delete_node BOOLEAN := FALSE;
15531: l_deassociate_cx BOOLEAN := FALSE;
15532: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
15533:
15534: BEGIN
15535: FOR i IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS
15536: WHERE ui_def_id=g_UI_Context.ui_def_id AND
20805: STATUS => l_status,
20806: INDUSTRY => l_industry,
20807: ORACLE_SCHEMA => l_oracle_schema);
20808:
20809: g_UINodeINCREMENT := get_Seq_Inc('CZ_UI_PAGE_ELEMENTS_S', l_oracle_schema);
20810: g_PageRefINCREMENT := get_Seq_Inc('CZ_UI_PAGE_REFS_S', l_oracle_schema);
20811: g_PageINCREMENT := get_Seq_Inc('CZ_UI_PAGES_S', l_oracle_schema);
20812: g_PageSetINCREMENT := get_Seq_Inc('CZ_UI_PAGE_SETS_S', l_oracle_schema);
20813: g_UIActionINCREMENT := get_Seq_Inc('CZ_UI_ACTIONS_S', l_oracle_schema);