DBA Data[Home] [Help]

APPS.CZ_UIOA_PVT dependencies on CZ_INTL_TEXTS

Line 1052: ELSIF p_sequence_name='CZ_INTL_TEXTS_S' THEN

1048: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currUIActionSeqVal FROM dual;
1049: g_currentUIAction := g_currUIActionSeqVal;
1050: END IF;
1051: RETURN g_currentUIAction;
1052: ELSIF p_sequence_name='CZ_INTL_TEXTS_S' THEN
1053: IF g_currentIntlText 1054: g_currentIntlText := g_currentIntlText+1;
1055: ELSE
1056: SELECT CZ_INTL_TEXTS_S.nextval INTO g_currIntlTextSeqVal FROM dual;

Line 1056: SELECT CZ_INTL_TEXTS_S.nextval INTO g_currIntlTextSeqVal FROM dual;

1052: ELSIF p_sequence_name='CZ_INTL_TEXTS_S' THEN
1053: IF g_currentIntlText 1054: g_currentIntlText := g_currentIntlText+1;
1055: ELSE
1056: SELECT CZ_INTL_TEXTS_S.nextval INTO g_currIntlTextSeqVal FROM dual;
1057: g_currentIntlText := g_currIntlTextSeqVal;
1058: END IF;
1059: RETURN g_currentIntlText;
1060: ELSE

Line 1884: -- copy CZ_INTL_TEXTS record

1880: RETURN l_ui_action_id;
1881: END get_UI_Action_Id;
1882:
1883: --
1884: -- copy CZ_INTL_TEXTS record
1885: --
1886: FUNCTION copy_Intl_Text(p_intl_text_id IN NUMBER,
1887: p_target_ui_def_id IN NUMBER,
1888: p_page_id IN NUMBER,

Line 1900: SELECT seeded_flag INTO l_seeded_flag FROM CZ_INTL_TEXTS

1896:
1897: IF p_intl_text_id IS NULL OR p_intl_text_id=0 THEN
1898: RETURN p_intl_text_id;
1899: ELSE
1900: SELECT seeded_flag INTO l_seeded_flag FROM CZ_INTL_TEXTS
1901: WHERE intl_text_id=p_intl_text_id;
1902: END IF;
1903:
1904: IF l_seeded_flag='0' OR l_seeded_flag IS NULL THEN

Line 1909: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');

1905: IF p_target_ui_def_id IS NOT NULL AND p_target_ui_def_id<>0 THEN
1906: SELECT NVL(devl_project_id,0) INTO l_model_id FROM CZ_UI_DEFS
1907: WHERE ui_def_id=p_target_ui_def_id;
1908: END IF;
1909: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
1910:
1911: INSERT INTO CZ_INTL_TEXTS
1912: (INTL_TEXT_ID,
1913: TEXT_STR,

Line 1911: INSERT INTO CZ_INTL_TEXTS

1907: WHERE ui_def_id=p_target_ui_def_id;
1908: END IF;
1909: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
1910:
1911: INSERT INTO CZ_INTL_TEXTS
1912: (INTL_TEXT_ID,
1913: TEXT_STR,
1914: DELETED_FLAG,
1915: SEEDED_FLAG,

Line 1930: FROM CZ_INTL_TEXTS

1926: p_target_ui_def_id,
1927: l_model_id,
1928: p_page_id,
1929: p_element_id
1930: FROM CZ_INTL_TEXTS
1931: WHERE intl_text_id=p_intl_text_id;
1932: RETURN l_ui_intl_text_id;
1933: ELSE
1934: RETURN p_intl_text_id;

Line 5637: l_new_intl_text_id := allocateId('CZ_INTL_TEXTS_S');

5633: WHERE intl_text_id=l_id AND seeded_flag=G_NO_FLAG
5634: AND deleted_flag=G_NO_FLAG)
5635: LOOP
5636: IF l_new_intl_text_id IS NULL THEN
5637: l_new_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
5638: END IF;
5639: INSERT INTO CZ_LOCALIZED_TEXTS
5640: (
5641: LOCALE_ID

Line 5908: l_new_intl_text_id := allocateId('CZ_INTL_TEXTS_S');

5904: WHERE intl_text_id=l_id AND seeded_flag=G_NO_FLAG
5905: AND deleted_flag=G_NO_FLAG)
5906: LOOP
5907: IF l_new_intl_text_id IS NULL THEN
5908: l_new_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
5909: END IF;
5910: INSERT INTO CZ_LOCALIZED_TEXTS
5911: (
5912: LOCALE_ID

Line 6536: FROM CZ_INTL_TEXTS

6532: END IF;
6533: END LOOP;
6534:
6535: FOR i in (SELECT intl_text_id, ui_page_element_id
6536: FROM CZ_INTL_TEXTS
6537: WHERE model_id = g_UI_Context.devl_project_id
6538: AND ui_def_id = g_UI_Context.ui_def_id
6539: AND ui_page_id = l_src_page_id
6540: AND deleted_flag = G_NO_FLAG)

Line 9036: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');

9032: END IF;
9033: IF find_CX_On_UI_Page(p_ui_node.page_id, p_node.ps_node_id, i.data_value) = G_NO_FLAG THEN
9034:
9035: l_element_id := get_Element_Id();
9036: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
9037: INSERT INTO CZ_INTL_TEXTS
9038: (INTL_TEXT_ID,
9039: TEXT_STR,
9040: DELETED_FLAG,

Line 9037: INSERT INTO CZ_INTL_TEXTS

9033: IF find_CX_On_UI_Page(p_ui_node.page_id, p_node.ps_node_id, i.data_value) = G_NO_FLAG THEN
9034:
9035: l_element_id := get_Element_Id();
9036: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
9037: INSERT INTO CZ_INTL_TEXTS
9038: (INTL_TEXT_ID,
9039: TEXT_STR,
9040: DELETED_FLAG,
9041: SEEDED_FLAG,

Line 9212: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');

9208:
9209: IF find_CX_On_UI_Page(p_ui_node.page_id, p_node.ps_node_id, i.data_value) = G_NO_FLAG THEN
9210:
9211: l_element_id := get_Element_Id();
9212: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
9213: INSERT INTO CZ_INTL_TEXTS
9214: (INTL_TEXT_ID,
9215: TEXT_STR,
9216: DELETED_FLAG,

Line 9213: INSERT INTO CZ_INTL_TEXTS

9209: IF find_CX_On_UI_Page(p_ui_node.page_id, p_node.ps_node_id, i.data_value) = G_NO_FLAG THEN
9210:
9211: l_element_id := get_Element_Id();
9212: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
9213: INSERT INTO CZ_INTL_TEXTS
9214: (INTL_TEXT_ID,
9215: TEXT_STR,
9216: DELETED_FLAG,
9217: SEEDED_FLAG,

Line 9385: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;

9381: -- records in table CZ_UI_PAGE_ELEMENTS
9382: --
9383: PROCEDURE handle_CXs_For_nonUINodes IS
9384:
9385: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
9386: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9387: l_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9388: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9389:

Line 9427: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');

9423: LOOP
9424: IF find_CX_On_UI_Page(parent_ui_node.page_id, option_node.ps_node_id, i.data_value) = G_NO_FLAG THEN
9425: l_element_id := get_Element_Id();
9426:
9427: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
9428: INSERT INTO CZ_INTL_TEXTS
9429: (INTL_TEXT_ID,
9430: TEXT_STR,
9431: DELETED_FLAG,

Line 9428: INSERT INTO CZ_INTL_TEXTS

9424: IF find_CX_On_UI_Page(parent_ui_node.page_id, option_node.ps_node_id, i.data_value) = G_NO_FLAG THEN
9425: l_element_id := get_Element_Id();
9426:
9427: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
9428: INSERT INTO CZ_INTL_TEXTS
9429: (INTL_TEXT_ID,
9430: TEXT_STR,
9431: DELETED_FLAG,
9432: SEEDED_FLAG,

Line 9592: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;

9588: -- records in table CZ_UI_PAGE_ELEMENTS
9589: --
9590: PROCEDURE handle_CXs IS
9591:
9592: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
9593: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9594: l_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9595: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9596: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

Line 12706: l_caption CZ_INTL_TEXTS.text_str%TYPE;

12702: l_page_id CZ_UI_PAGES.page_id%TYPE;
12703: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12704: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
12705: l_caption_text_id NUMBER;
12706: l_caption CZ_INTL_TEXTS.text_str%TYPE;
12707:
12708: BEGIN
12709:
12710: --

Line 12718: l_caption_text_id := allocateId('CZ_INTL_TEXTS_S');

12714:
12715:
12716: l_caption := G_UMPERS||G_CAPTION_RULE_TOKENNAME||' ('||TO_CHAR(l_split_seq_nbr)||')';
12717:
12718: l_caption_text_id := allocateId('CZ_INTL_TEXTS_S');
12719:
12720: l_element_id := get_Element_Id();
12721: l_page_id := allocateId('CZ_UI_PAGES_S');
12722:

Line 12723: INSERT INTO CZ_INTL_TEXTS

12719:
12720: l_element_id := get_Element_Id();
12721: l_page_id := allocateId('CZ_UI_PAGES_S');
12722:
12723: INSERT INTO CZ_INTL_TEXTS
12724: (
12725: INTL_TEXT_ID
12726: ,TEXT_STR
12727: ,DELETED_FLAG