APPS.CZ_UIOA_PVT dependencies on CZ_UI_CONT_TYPE_TEMPLS

Line 1994: FOR h IN(SELECT * FROM CZ_UI_CONT_TYPE_TEMPLS

1990: l_template_ui_def_id := g_UI_Context.ui_def_id;
1991: ELSE
1992: l_template_ui_def_id := G_GLOBAL_TEMPLATES_UI_DEF_ID;
1993: END IF;
1994: FOR h IN(SELECT * FROM CZ_UI_CONT_TYPE_TEMPLS
1995: WHERE ui_def_id = p_master_template_id AND
1996: content_type=p_content_type AND
1997: deleted_flag=G_NO_FLAG)
1998: LOOP

Line 2000: INSERT INTO CZ_UI_CONT_TYPE_TEMPLS

1996: content_type=p_content_type AND
1997: deleted_flag=G_NO_FLAG)
1998: LOOP
1999: BEGIN
2000: INSERT INTO CZ_UI_CONT_TYPE_TEMPLS
2001: (ui_def_id,
2002: content_type,
2003: template_id,
2004: master_template_flag,

Line 2261: FOR k IN(SELECT * FROM CZ_UI_CONT_TYPE_TEMPLS

2257: END LOOP;
2258:
2259: END IF;
2260:
2261: FOR k IN(SELECT * FROM CZ_UI_CONT_TYPE_TEMPLS
2262: WHERE ui_def_id = g_UI_Context.from_master_template_id AND
2263: deleted_flag = G_NO_FLAG)
2264: LOOP
2265:

Line 2296: FROM CZ_UI_CONT_TYPE_TEMPLS

2292:
2293: END LOOP;
2294:
2295: SELECT template_id INTO g_DRILLDOWN_TEMPLATE_ID
2296: FROM CZ_UI_CONT_TYPE_TEMPLS
2297: WHERE ui_def_id=g_UI_Context.from_master_template_id AND
2298: content_type=2151 AND deleted_flag=G_NO_FLAG;
2299:
2300: -- close XML parser