APPS.CZ_UIOA_PVT dependencies on CZ_UI_CONT_TYPE_TEMPLS

Line 2056: FOR h IN(SELECT * FROM CZ_UI_CONT_TYPE_TEMPLS

2052: l_template_ui_def_id := g_UI_Context.ui_def_id;
2053: ELSE
2054: l_template_ui_def_id := G_GLOBAL_TEMPLATES_UI_DEF_ID;
2055: END IF;
2056: FOR h IN(SELECT * FROM CZ_UI_CONT_TYPE_TEMPLS
2057: WHERE ui_def_id = p_master_template_id AND
2058: content_type=p_content_type AND
2059: deleted_flag=G_NO_FLAG)
2060: LOOP

Line 2062: INSERT INTO CZ_UI_CONT_TYPE_TEMPLS

2058: content_type=p_content_type AND
2059: deleted_flag=G_NO_FLAG)
2060: LOOP
2061: BEGIN
2062: INSERT INTO CZ_UI_CONT_TYPE_TEMPLS
2063: (ui_def_id,
2064: content_type,
2065: template_id,
2066: master_template_flag,

Line 2323: FOR k IN(SELECT * FROM CZ_UI_CONT_TYPE_TEMPLS

2319: END LOOP;
2320:
2321: END IF;
2322:
2323: FOR k IN(SELECT * FROM CZ_UI_CONT_TYPE_TEMPLS
2324: WHERE ui_def_id = g_UI_Context.from_master_template_id AND
2325: deleted_flag = G_NO_FLAG)
2326: LOOP
2327:

Line 2358: FROM CZ_UI_CONT_TYPE_TEMPLS

2354:
2355: END LOOP;
2356:
2357: SELECT template_id INTO g_DRILLDOWN_TEMPLATE_ID
2358: FROM CZ_UI_CONT_TYPE_TEMPLS
2359: WHERE ui_def_id=g_UI_Context.from_master_template_id AND
2360: content_type=2151 AND deleted_flag=G_NO_FLAG;
2361:
2362: -- close XML parser