[Home] [Help]
722: --
723: PROCEDURE Initialize_Sequences IS
724: BEGIN
725:
726: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currentUINode FROM dual;
727: g_currUISeqVal := g_currentUINode;
728:
729: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;
730: g_currPageRefSeqVal := g_currentPageRef;
1014: --
1015: FUNCTION allocateId(p_sequence_name IN VARCHAR2) RETURN NUMBER IS
1016: l_id NUMBER;
1017: BEGIN
1018: IF p_sequence_name='CZ_UI_PAGE_ELEMENTS_S' THEN
1019: IF g_currentUINode
1021: ELSE
1022: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currUISeqVal FROM dual;
1018: IF p_sequence_name='CZ_UI_PAGE_ELEMENTS_S' THEN
1019: IF g_currentUINode
1021: ELSE
1022: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currUISeqVal FROM dual;
1023: g_currentUINode := g_currUISeqVal;
1024: END IF;
1025: RETURN g_currentUINode;
1026: ELSIF p_sequence_name='CZ_UI_PAGE_REFS_S' THEN
1100: -- return new element_id
1101: --
1102: FUNCTION get_Element_Id RETURN VARCHAR2 IS
1103: BEGIN
1104: RETURN TO_CHAR(allocateId('CZ_UI_PAGE_ELEMENTS_S'));
1105: END get_Element_Id;
1106:
1107: --
1108: -- mark UI page as deleted
3044: --
3045: PROCEDURE remove_Instance_Controls(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3046:
3047: l_changed_pages_tbl number_tbl_type;
3048: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
3049: l_mark_flag CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;
3050:
3051: BEGIN
3052:
10408: p_page_set_id IN NUMBER) IS
10409:
10410: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10411: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10412: l_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
10413: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10414:
10415: BEGIN
10416:
11344: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
11345: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
11346: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11347: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
11348: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
11349: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
11350: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11351: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
11352: l_counter NUMBER;
11682: --
11683: -- delete UI element recursively
11684: --
11685: PROCEDURE delete_UI_Element(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11686: p_suppress_refresh_flag IN CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE DEFAULT NULL,
11687: p_delete_in_model IN BOOLEAN DEFAULT NULL) IS
11688:
11689: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11690: l_del_flag BOOLEAN := FALSE;
11685: PROCEDURE delete_UI_Element(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11686: p_suppress_refresh_flag IN CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE DEFAULT NULL,
11687: p_delete_in_model IN BOOLEAN DEFAULT NULL) IS
11688:
11689: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11690: l_del_flag BOOLEAN := FALSE;
11691: BEGIN
11692:
11693: --
11843: NULL;
11844: END remove_UI_Page_Ref;
11845:
11846: PROCEDURE delete_Related_Buttons(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
11847: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11848: BEGIN
11849:
11850: FOR i IN(SELECT element_id,parent_element_id,page_id,suppress_refresh_flag
11851: FROM CZ_UI_PAGE_ELEMENTS a
11901: l_parent_element_id_tbl varchar_tbl_type;
11902: l_persistent_node_id_tbl number_tbl_type;
11903: l_suppress_refresh_flag_tbl varchar_tbl_type;
11904: l_page_id_tbl number_tbl_type;
11905: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11906:
11907: BEGIN
11908:
11909: --
11994: END delete_UI_Container;
11995:
11996: PROCEDURE handle_Deleted_Nodes(p_ui_def_id IN NUMBER) IS
11997:
11998: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11999:
12000: BEGIN
12001:
12002: -- delete UI References
14253:
14254: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14255: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14256: l_new_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14257: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
14258: l_current_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14259: l_seq_nbr NUMBER;
14260: l_max_split_nbr NUMBER;
14261: l_page_split_seq_nbr NUMBER;
14936: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14937: l_temp_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14938: l_next_level_ui_pages_tbl ui_page_elements_tbl_type;
14939: l_insert_index NUMBER;
14940: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
14941: l_parent_node_found BOOLEAN;
14942: l_atleast_one_parent_found BOOLEAN;
14943: l_nodes_tbl model_nodes_tbl_type;
14944: l_seq_nodes_tbl ui_page_el_int_tbl_type; -- fix for bug 6837809 : skudryav 28-Mar-2008
15017: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
15018:
15019: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
15020: l_insert_index NUMBER;
15021: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
15022: l_parent_node_found BOOLEAN;
15023:
15024: BEGIN
15025:
15075: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
15076:
15077: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
15078: l_insert_index NUMBER;
15079: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
15080: l_parent_node_found BOOLEAN;
15081: l_diff NUMBER;
15082: l_max_prev_seq_nbr NUMBER;
15083: l_max_src_seq_nbr NUMBER;
15528: l_bom_table_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
15529: l_page_id NUMBER;
15530:
15531: l_bom_parent_element CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
15532: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
15533:
15534: BEGIN
15535:
15536: l_added_ui := FALSE;
16192: l_suppress_refresh_tbl varchar_tbl_type;
16193: l_suppress_el_flag_tbl varchar_tbl_type;
16194: l_delete_node BOOLEAN := FALSE;
16195: l_deassociate_cx BOOLEAN := FALSE;
16196: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
16197:
16198: BEGIN
16199: FOR i IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS
16200: WHERE ui_def_id=g_UI_Context.ui_def_id AND
21921: STATUS => l_status,
21922: INDUSTRY => l_industry,
21923: ORACLE_SCHEMA => l_oracle_schema);
21924:
21925: g_UINodeINCREMENT := get_Seq_Inc('CZ_UI_PAGE_ELEMENTS_S', l_oracle_schema);
21926: g_PageRefINCREMENT := get_Seq_Inc('CZ_UI_PAGE_REFS_S', l_oracle_schema);
21927: g_PageINCREMENT := get_Seq_Inc('CZ_UI_PAGES_S', l_oracle_schema);
21928: g_PageSetINCREMENT := get_Seq_Inc('CZ_UI_PAGE_SETS_S', l_oracle_schema);
21929: g_UIActionINCREMENT := get_Seq_Inc('CZ_UI_ACTIONS_S', l_oracle_schema);