eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_UIOA_PVT dependencies on CZ_INTL_TEXTS

Line 1058: ELSIF p_sequence_name='CZ_INTL_TEXTS_S' THEN

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

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

1058: ELSIF p_sequence_name='CZ_INTL_TEXTS_S' THEN
1059: IF g_currentIntlText 1060: g_currentIntlText := g_currentIntlText+1;
1061: ELSE
1062: SELECT CZ_INTL_TEXTS_S.nextval INTO g_currIntlTextSeqVal FROM dual;
1063: g_currentIntlText := g_currIntlTextSeqVal;
1064: END IF;
1065: RETURN g_currentIntlText;
1066: ELSE

Line 1939: -- copy CZ_INTL_TEXTS record

1935: RETURN l_ui_action_id;
1936: END get_UI_Action_Id;
1937:
1938: --
1939: -- copy CZ_INTL_TEXTS record
1940: --
1941: FUNCTION copy_Intl_Text(p_intl_text_id IN NUMBER,
1942: p_target_ui_def_id IN NUMBER,
1943: p_page_id IN NUMBER,

Line 1956: SELECT seeded_flag INTO l_seeded_flag FROM CZ_INTL_TEXTS

1952:
1953: IF p_intl_text_id IS NULL OR p_intl_text_id=0 THEN
1954: RETURN p_intl_text_id;
1955: ELSE
1956: SELECT seeded_flag INTO l_seeded_flag FROM CZ_INTL_TEXTS
1957: WHERE intl_text_id=p_intl_text_id;
1958: END IF;
1959:
1960: IF l_seeded_flag='0' OR l_seeded_flag IS NULL THEN

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

1961: IF p_target_ui_def_id IS NOT NULL AND p_target_ui_def_id<>0 THEN
1962: SELECT NVL(devl_project_id,0) INTO l_model_id FROM CZ_UI_DEFS
1963: WHERE ui_def_id=p_target_ui_def_id;
1964: END IF;
1965: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
1966:
1967: INSERT INTO CZ_INTL_TEXTS
1968: (INTL_TEXT_ID,
1969: TEXT_STR,

Line 1967: INSERT INTO CZ_INTL_TEXTS

1963: WHERE ui_def_id=p_target_ui_def_id;
1964: END IF;
1965: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
1966:
1967: INSERT INTO CZ_INTL_TEXTS
1968: (INTL_TEXT_ID,
1969: TEXT_STR,
1970: DELETED_FLAG,
1971: SEEDED_FLAG,

Line 1986: FROM CZ_INTL_TEXTS

1982: p_target_ui_def_id,
1983: l_model_id,
1984: p_page_id,
1985: p_element_id
1986: FROM CZ_INTL_TEXTS
1987: WHERE intl_text_id=p_intl_text_id;
1988:
1989: SELECT persistent_intl_text_id INTO l_persistent_intl_text_id
1990: FROM CZ_INTL_TEXTS

Line 1990: FROM CZ_INTL_TEXTS

1986: FROM CZ_INTL_TEXTS
1987: WHERE intl_text_id=p_intl_text_id;
1988:
1989: SELECT persistent_intl_text_id INTO l_persistent_intl_text_id
1990: FROM CZ_INTL_TEXTS
1991: WHERE INTL_TEXT_ID = l_ui_intl_text_id;
1992:
1993: RETURN l_persistent_intl_text_id;
1994:

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

5869: AND deleted_flag=G_NO_FLAG)
5870: LOOP
5871: l_persistent_intl_text_id_tmp := null;
5872: IF l_new_intl_text_id IS NULL THEN
5873: l_new_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
5874: END IF;
5875: INSERT INTO CZ_LOCALIZED_TEXTS
5876: (
5877: LOCALE_ID

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

6158: AND deleted_flag=G_NO_FLAG)
6159: LOOP
6160: IF l_new_intl_text_id IS NULL THEN
6161: l_persistent_intl_text_id_tmp := null;
6162: l_new_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
6163: END IF;
6164: INSERT INTO CZ_LOCALIZED_TEXTS
6165: (
6166: LOCALE_ID

Line 6805: FROM CZ_INTL_TEXTS

6801: END IF;
6802: END LOOP;
6803:
6804: FOR i in (SELECT intl_text_id, ui_page_element_id
6805: FROM CZ_INTL_TEXTS
6806: WHERE model_id = g_UI_Context.devl_project_id
6807: AND ui_def_id = g_UI_Context.ui_def_id
6808: AND ui_page_id = l_src_page_id
6809: AND deleted_flag = G_NO_FLAG)

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

9492: END IF;
9493: IF find_CX_On_UI_Page(p_ui_node.page_id, p_node.ps_node_id, i.data_value) = G_NO_FLAG THEN
9494:
9495: l_element_id := get_Element_Id();
9496: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
9497: INSERT INTO CZ_INTL_TEXTS
9498: (INTL_TEXT_ID,
9499: TEXT_STR,
9500: DELETED_FLAG,

Line 9497: INSERT INTO CZ_INTL_TEXTS

9493: IF find_CX_On_UI_Page(p_ui_node.page_id, p_node.ps_node_id, i.data_value) = G_NO_FLAG THEN
9494:
9495: l_element_id := get_Element_Id();
9496: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
9497: INSERT INTO CZ_INTL_TEXTS
9498: (INTL_TEXT_ID,
9499: TEXT_STR,
9500: DELETED_FLAG,
9501: SEEDED_FLAG,

Line 9519: FROM CZ_INTL_TEXTS

9515: l_element_id
9516: );
9517:
9518: SELECT persistent_intl_text_id INTO l_persistent_intl_text_id
9519: FROM CZ_INTL_TEXTS
9520: WHERE INTL_TEXT_ID = l_ui_intl_text_id;
9521:
9522: g_cx_names_tbl(TO_NUMBER(l_element_id)) := l_persistent_intl_text_id;
9523:

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

9673:
9674: IF find_CX_On_UI_Page(p_ui_node.page_id, p_node.ps_node_id, i.data_value) = G_NO_FLAG THEN
9675:
9676: l_element_id := get_Element_Id();
9677: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
9678: INSERT INTO CZ_INTL_TEXTS
9679: (INTL_TEXT_ID,
9680: TEXT_STR,
9681: DELETED_FLAG,

Line 9678: INSERT INTO CZ_INTL_TEXTS

9674: IF find_CX_On_UI_Page(p_ui_node.page_id, p_node.ps_node_id, i.data_value) = G_NO_FLAG THEN
9675:
9676: l_element_id := get_Element_Id();
9677: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
9678: INSERT INTO CZ_INTL_TEXTS
9679: (INTL_TEXT_ID,
9680: TEXT_STR,
9681: DELETED_FLAG,
9682: SEEDED_FLAG,

Line 9699: FROM CZ_INTL_TEXTS

9695: l_element_id
9696: );
9697:
9698: SELECT persistent_intl_text_id INTO l_persistent_intl_text_id
9699: FROM CZ_INTL_TEXTS
9700: WHERE INTL_TEXT_ID = l_ui_intl_text_id;
9701:
9702: g_cx_names_tbl(TO_NUMBER(l_element_id)) := l_persistent_intl_text_id;
9703:

Line 9855: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;

9851: -- records in table CZ_UI_PAGE_ELEMENTS
9852: --
9853: PROCEDURE handle_CXs_For_nonUINodes IS
9854:
9855: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
9856: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9857: l_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9858: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9859: l_persistent_intl_text_id NUMBER;

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

9893: LOOP
9894: IF find_CX_On_UI_Page(parent_ui_node.page_id, option_node.ps_node_id, i.data_value) = G_NO_FLAG THEN
9895: l_element_id := get_Element_Id();
9896:
9897: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
9898: INSERT INTO CZ_INTL_TEXTS
9899: (INTL_TEXT_ID,
9900: TEXT_STR,
9901: DELETED_FLAG,

Line 9898: INSERT INTO CZ_INTL_TEXTS

9894: IF find_CX_On_UI_Page(parent_ui_node.page_id, option_node.ps_node_id, i.data_value) = G_NO_FLAG THEN
9895: l_element_id := get_Element_Id();
9896:
9897: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
9898: INSERT INTO CZ_INTL_TEXTS
9899: (INTL_TEXT_ID,
9900: TEXT_STR,
9901: DELETED_FLAG,
9902: SEEDED_FLAG,

Line 9920: FROM CZ_INTL_TEXTS

9916: l_element_id
9917: );
9918:
9919: SELECT persistent_intl_text_id INTO l_persistent_intl_text_id
9920: FROM CZ_INTL_TEXTS
9921: WHERE INTL_TEXT_ID = l_ui_intl_text_id;
9922:
9923: g_cx_names_tbl(TO_NUMBER(l_element_id)) := l_persistent_intl_text_id;
9924: g_ref_cx_paths_tbl(TO_NUMBER(l_element_id)) := get_Model_Path(parent_ui_node)||

Line 10066: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;

10062: -- records in table CZ_UI_PAGE_ELEMENTS
10063: --
10064: PROCEDURE handle_CXs IS
10065:
10066: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
10067: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10068: l_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10069: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10070: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

Line 13190: l_caption CZ_INTL_TEXTS.text_str%TYPE;

13186: l_page_id CZ_UI_PAGES.page_id%TYPE;
13187: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
13188: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
13189: l_caption_text_id NUMBER;
13190: l_caption CZ_INTL_TEXTS.text_str%TYPE;
13191:
13192: BEGIN
13193:
13194: --

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

13198:
13199:
13200: l_caption := G_UMPERS||G_CAPTION_RULE_TOKENNAME||' ('||TO_CHAR(l_split_seq_nbr)||')';
13201:
13202: l_caption_text_id := allocateId('CZ_INTL_TEXTS_S');
13203:
13204: l_element_id := get_Element_Id();
13205: l_page_id := allocateId('CZ_UI_PAGES_S');
13206:

Line 13207: INSERT INTO CZ_INTL_TEXTS

13203:
13204: l_element_id := get_Element_Id();
13205: l_page_id := allocateId('CZ_UI_PAGES_S');
13206:
13207: INSERT INTO CZ_INTL_TEXTS
13208: (
13209: INTL_TEXT_ID
13210: ,TEXT_STR
13211: ,DELETED_FLAG