DBA Data[Home] [Help]

APPS.CZ_UIOA_PVT dependencies on CZ_UI_TEMPLATE_ELEMENTS

Line 5718: INSERT INTO CZ_UI_TEMPLATE_ELEMENTS

5714: IF l_cached_elems_tbl.COUNT > 0 THEN
5715: FOR i IN l_cached_elems_tbl.First..l_cached_elems_tbl.Last
5716: LOOP
5717:
5718: INSERT INTO CZ_UI_TEMPLATE_ELEMENTS
5719: (
5720: TEMPLATE_ID
5721: ,UI_DEF_ID
5722: ,ELEMENT_TYPE

Line 5736: FROM CZ_UI_TEMPLATE_ELEMENTS

5732: ,l_cached_elems_tbl(i)
5733: ,l_cached_elems_tbl(i)
5734: ,G_NO_FLAG
5735: ,G_NO_FLAG
5736: FROM CZ_UI_TEMPLATE_ELEMENTS
5737: WHERE template_id=p_source_template_id AND
5738: ui_def_id=p_source_ui_def_id AND
5739: element_id=l_cached_source_elems_tbl(i) AND
5740: deleted_flag=G_NO_FLAG;

Line 5970: INSERT INTO CZ_UI_TEMPLATE_ELEMENTS

5966:
5967: IF l_cached_elems_tbl.COUNT > 0 THEN
5968: FOR i IN l_cached_elems_tbl.FIRST..l_cached_elems_tbl.LAST
5969: LOOP
5970: INSERT INTO CZ_UI_TEMPLATE_ELEMENTS
5971: (
5972: TEMPLATE_ID
5973: ,UI_DEF_ID
5974: ,ELEMENT_TYPE

Line 5988: FROM CZ_UI_TEMPLATE_ELEMENTS

5984: ,l_cached_elems_tbl(i)
5985: ,l_cached_elems_tbl(i)
5986: ,G_NO_FLAG
5987: ,G_NO_FLAG
5988: FROM CZ_UI_TEMPLATE_ELEMENTS
5989: WHERE template_id=p_source_template_id AND
5990: ui_def_id=p_source_ui_def_id AND
5991: element_id=l_cached_source_elems_tbl(i) AND
5992: deleted_flag=G_NO_FLAG;

Line 16910: UPDATE CZ_UI_TEMPLATE_ELEMENTS

16906: ui_action_id=l_persistent_id AND
16907: seeded_flag=G_NO_FLAG;
16908:
16909: IF p_template_id IS NOT NULL THEN
16910: UPDATE CZ_UI_TEMPLATE_ELEMENTS
16911: SET deleted_flag=G_YES_FLAG
16912: WHERE template_id=p_template_id AND
16913: ui_def_id=p_template_ui_def_id AND
16914: element_id=l_persistent_id AND

Line 16932: UPDATE CZ_UI_TEMPLATE_ELEMENTS

16928: AND ui_def_id = p_ui_def_id
16929: AND seeded_flag = G_NO_FLAG;
16930:
16931: IF p_template_id IS NOT NULL THEN
16932: UPDATE CZ_UI_TEMPLATE_ELEMENTS
16933: SET deleted_flag=G_YES_FLAG
16934: WHERE template_id=p_template_id AND
16935: ui_def_id=p_template_ui_def_id AND
16936: element_id=l_persistent_id AND

Line 16955: UPDATE CZ_UI_TEMPLATE_ELEMENTS

16951: ui_def_id=p_ui_def_id AND
16952: seeded_flag=G_NO_FLAG;
16953:
16954: IF p_template_id IS NOT NULL THEN
16955: UPDATE CZ_UI_TEMPLATE_ELEMENTS
16956: SET deleted_flag=G_YES_FLAG
16957: WHERE template_id=p_template_id AND
16958: ui_def_id=p_template_ui_def_id AND
16959: element_id=l_persistent_id AND

Line 18250: UPDATE CZ_UI_TEMPLATE_ELEMENTS

18246:
18247: DELETE FROM CZ_UI_REF_TEMPLATES
18248: WHERE template_ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
18249:
18250: UPDATE CZ_UI_TEMPLATE_ELEMENTS
18251: SET deleted_flag=G_YES_FLAG
18252: WHERE template_id=p_template_ui_def_id AND
18253: deleted_flag=G_NO_FLAG;
18254: