DBA Data[Home] [Help]

APPS.CZ_UIOA_PVT dependencies on CZ_UI_TEMPLATE_ELEMENTS

Line 5958: INSERT INTO CZ_UI_TEMPLATE_ELEMENTS

5954: IF l_cached_elems_tbl.COUNT > 0 THEN
5955: FOR i IN l_cached_elems_tbl.First..l_cached_elems_tbl.Last
5956: LOOP
5957:
5958: INSERT INTO CZ_UI_TEMPLATE_ELEMENTS
5959: (
5960: TEMPLATE_ID
5961: ,UI_DEF_ID
5962: ,ELEMENT_TYPE

Line 5976: FROM CZ_UI_TEMPLATE_ELEMENTS

5972: ,l_cached_elems_tbl(i)
5973: ,l_cached_elems_tbl(i)
5974: ,G_NO_FLAG
5975: ,G_NO_FLAG
5976: FROM CZ_UI_TEMPLATE_ELEMENTS
5977: WHERE template_id=p_source_template_id AND
5978: ui_def_id=p_source_ui_def_id AND
5979: element_id=l_cached_source_elems_tbl(i) AND
5980: deleted_flag=G_NO_FLAG;

Line 6228: INSERT INTO CZ_UI_TEMPLATE_ELEMENTS

6224:
6225: IF l_cached_elems_tbl.COUNT > 0 THEN
6226: FOR i IN l_cached_elems_tbl.FIRST..l_cached_elems_tbl.LAST
6227: LOOP
6228: INSERT INTO CZ_UI_TEMPLATE_ELEMENTS
6229: (
6230: TEMPLATE_ID
6231: ,UI_DEF_ID
6232: ,ELEMENT_TYPE

Line 6246: FROM CZ_UI_TEMPLATE_ELEMENTS

6242: ,l_cached_elems_tbl(i)
6243: ,l_cached_elems_tbl(i)
6244: ,G_NO_FLAG
6245: ,G_NO_FLAG
6246: FROM CZ_UI_TEMPLATE_ELEMENTS
6247: WHERE template_id=p_source_template_id AND
6248: ui_def_id=p_source_ui_def_id AND
6249: element_id=l_cached_source_elems_tbl(i) AND
6250: deleted_flag=G_NO_FLAG;

Line 17760: UPDATE CZ_UI_TEMPLATE_ELEMENTS

17756: ui_action_id=l_persistent_id AND
17757: seeded_flag=G_NO_FLAG;
17758:
17759: IF p_template_id IS NOT NULL THEN
17760: UPDATE CZ_UI_TEMPLATE_ELEMENTS
17761: SET deleted_flag=G_YES_FLAG
17762: WHERE template_id=p_template_id AND
17763: ui_def_id=p_template_ui_def_id AND
17764: element_id=l_persistent_id AND

Line 17782: UPDATE CZ_UI_TEMPLATE_ELEMENTS

17778: AND ui_def_id = p_ui_def_id
17779: AND seeded_flag = G_NO_FLAG;
17780:
17781: IF p_template_id IS NOT NULL THEN
17782: UPDATE CZ_UI_TEMPLATE_ELEMENTS
17783: SET deleted_flag=G_YES_FLAG
17784: WHERE template_id=p_template_id AND
17785: ui_def_id=p_template_ui_def_id AND
17786: element_id=l_persistent_id AND

Line 17805: UPDATE CZ_UI_TEMPLATE_ELEMENTS

17801: ui_def_id=p_ui_def_id AND
17802: seeded_flag=G_NO_FLAG;
17803:
17804: IF p_template_id IS NOT NULL THEN
17805: UPDATE CZ_UI_TEMPLATE_ELEMENTS
17806: SET deleted_flag=G_YES_FLAG
17807: WHERE template_id=p_template_id AND
17808: ui_def_id=p_template_ui_def_id AND
17809: element_id=l_persistent_id AND

Line 19156: UPDATE CZ_UI_TEMPLATE_ELEMENTS

19152:
19153: DELETE FROM CZ_UI_REF_TEMPLATES
19154: WHERE template_ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
19155:
19156: UPDATE CZ_UI_TEMPLATE_ELEMENTS
19157: SET deleted_flag=G_YES_FLAG
19158: WHERE template_id=p_template_ui_def_id AND
19159: deleted_flag=G_NO_FLAG;
19160: