APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGE_SETS_S

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

731:
732: SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;
733: g_currPageSeqVal := g_currentPage;
734:
735: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;
736: g_currPageSetSeqVal := g_currentPageSet;
737:
738: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currentUIAction FROM dual;
739: g_currUIActionSeqVal := g_currentUIAction;

Line 1042: ELSIF p_sequence_name='CZ_UI_PAGE_SETS_S' THEN

1038: SELECT CZ_UI_PAGES_S.nextval INTO g_currPageSeqVal FROM dual;
1039: g_currentPage := g_currPageSeqVal;
1040: END IF;
1041: RETURN g_currentPage;
1042: ELSIF p_sequence_name='CZ_UI_PAGE_SETS_S' THEN
1043: IF g_currentPageSet 1044: g_currentPageSet := g_currentPageSet+1;
1045: ELSE
1046: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currPageSetSeqVal FROM dual;

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

1042: ELSIF p_sequence_name='CZ_UI_PAGE_SETS_S' THEN
1043: IF g_currentPageSet 1044: g_currentPageSet := g_currentPageSet+1;
1045: ELSE
1046: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currPageSetSeqVal FROM dual;
1047: g_currentPageSet := g_currPageSetSeqVal;
1048: END IF;
1049: RETURN g_currentPageSet;
1050: ELSIF p_sequence_name='CZ_UI_ACTIONS_S' THEN

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

2665: l_page_set_counter := get_Page_Set_Counter() + 1;
2666: l_page_set_name := 'Page Set - ' || TO_CHAR(l_page_set_counter);
2667: END IF;
2668:
2669: x_page_set_id := allocateId('CZ_UI_PAGE_SETS_S');
2670:
2671: INSERT INTO CZ_UI_PAGE_SETS
2672: (ui_def_id,
2673: page_set_id,

Line 12152: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;

12148:
12149: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
12150: l_new_parent_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
12151: l_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
12152: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;
12153:
12154: BEGIN
12155:
12156: x_new_parent_page_ref_id := NULL;

Line 12280: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;

12276: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12277: l_parent_ref_persist_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;
12278: l_new_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12279: l_curr_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12280: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;
12281: l_mark_flag CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;
12282: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
12283:
12284: BEGIN

Line 21928: g_PageSetINCREMENT := get_Seq_Inc('CZ_UI_PAGE_SETS_S', 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);
21930:
21931: SELECT template_name
21932: INTO G_DRILLDOWN_TEMPLATE_NAME