APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGE_SETS_S

Line 729: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;

725:
726: SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;
727: g_currPageSeqVal := g_currentPage;
728:
729: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;
730: g_currPageSetSeqVal := g_currentPageSet;
731:
732: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currentUIAction FROM dual;
733: g_currUIActionSeqVal := g_currentUIAction;

Line 1036: ELSIF p_sequence_name='CZ_UI_PAGE_SETS_S' THEN

1032: SELECT CZ_UI_PAGES_S.nextval INTO g_currPageSeqVal FROM dual;
1033: g_currentPage := g_currPageSeqVal;
1034: END IF;
1035: RETURN g_currentPage;
1036: ELSIF p_sequence_name='CZ_UI_PAGE_SETS_S' THEN
1037: IF g_currentPageSet 1038: g_currentPageSet := g_currentPageSet+1;
1039: ELSE
1040: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currPageSetSeqVal FROM dual;

Line 1040: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currPageSetSeqVal FROM dual;

1036: ELSIF p_sequence_name='CZ_UI_PAGE_SETS_S' THEN
1037: IF g_currentPageSet 1038: g_currentPageSet := g_currentPageSet+1;
1039: ELSE
1040: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currPageSetSeqVal FROM dual;
1041: g_currentPageSet := g_currPageSetSeqVal;
1042: END IF;
1043: RETURN g_currentPageSet;
1044: ELSIF p_sequence_name='CZ_UI_ACTIONS_S' THEN

Line 2607: x_page_set_id := allocateId('CZ_UI_PAGE_SETS_S');

2603: l_page_set_counter := get_Page_Set_Counter() + 1;
2604: l_page_set_name := 'Page Set - ' || TO_CHAR(l_page_set_counter);
2605: END IF;
2606:
2607: x_page_set_id := allocateId('CZ_UI_PAGE_SETS_S');
2608:
2609: INSERT INTO CZ_UI_PAGE_SETS
2610: (ui_def_id,
2611: page_set_id,

Line 11673: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;

11669:
11670: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
11671: l_new_parent_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
11672: l_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
11673: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;
11674:
11675: BEGIN
11676:
11677: x_new_parent_page_ref_id := NULL;

Line 11801: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;

11797: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11798: l_parent_ref_persist_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;
11799: l_new_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11800: l_curr_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11801: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;
11802: l_mark_flag CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;
11803: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
11804:
11805: BEGIN

Line 20812: g_PageSetINCREMENT := get_Seq_Inc('CZ_UI_PAGE_SETS_S', 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);
20814:
20815: SELECT template_name
20816: INTO G_DRILLDOWN_TEMPLATE_NAME