APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_UI_CONT_TYPE_TEMPLS

Line 6299: INSERT INTO CZ_UI_CONT_TYPE_TEMPLS(

6295: END IF;
6296:
6297: -- Create ui content type templates for this newly copied ui def
6298:
6299: INSERT INTO CZ_UI_CONT_TYPE_TEMPLS(
6300: UI_DEF_ID
6301: ,CONTENT_TYPE
6302: ,TEMPLATE_ID
6303: ,DELETED_FLAG

Line 6318: FROM CZ_UI_CONT_TYPE_TEMPLS

6314: ,MASTER_TEMPLATE_FLAG
6315: ,'0'
6316: ,TEMPLATE_UI_DEF_ID
6317: ,WRAP_TEMPLATE_FLAG
6318: FROM CZ_UI_CONT_TYPE_TEMPLS
6319: WHERE ui_def_id = p_ui_def_id;
6320:
6321: -- Create ui images for this newly copied ui def
6322: INSERT INTO CZ_UI_IMAGES

Line 6984: FROM cz_ui_cont_type_templs

6980: FROM cz_ui_defs ui
6981: WHERE deleted_flag = '0'
6982: AND ui_def_id IN
6983: (SELECT ui_def_id
6984: FROM cz_ui_cont_type_templs
6985: WHERE cz_ui_cont_type_templs.template_id = p_uct_id
6986: AND cz_ui_cont_type_templs.template_ui_def_id = 0
6987: AND cz_ui_cont_type_templs.deleted_flag = '0'
6988: UNION ALL

Line 6985: WHERE cz_ui_cont_type_templs.template_id = p_uct_id

6981: WHERE deleted_flag = '0'
6982: AND ui_def_id IN
6983: (SELECT ui_def_id
6984: FROM cz_ui_cont_type_templs
6985: WHERE cz_ui_cont_type_templs.template_id = p_uct_id
6986: AND cz_ui_cont_type_templs.template_ui_def_id = 0
6987: AND cz_ui_cont_type_templs.deleted_flag = '0'
6988: UNION ALL
6989: SELECT ui_def_id

Line 6986: AND cz_ui_cont_type_templs.template_ui_def_id = 0

6982: AND ui_def_id IN
6983: (SELECT ui_def_id
6984: FROM cz_ui_cont_type_templs
6985: WHERE cz_ui_cont_type_templs.template_id = p_uct_id
6986: AND cz_ui_cont_type_templs.template_ui_def_id = 0
6987: AND cz_ui_cont_type_templs.deleted_flag = '0'
6988: UNION ALL
6989: SELECT ui_def_id
6990: FROM cz_ui_page_elements

Line 6987: AND cz_ui_cont_type_templs.deleted_flag = '0'

6983: (SELECT ui_def_id
6984: FROM cz_ui_cont_type_templs
6985: WHERE cz_ui_cont_type_templs.template_id = p_uct_id
6986: AND cz_ui_cont_type_templs.template_ui_def_id = 0
6987: AND cz_ui_cont_type_templs.deleted_flag = '0'
6988: UNION ALL
6989: SELECT ui_def_id
6990: FROM cz_ui_page_elements
6991: WHERE cz_ui_page_elements.ctrl_template_id = p_uct_id

Line 8149: FROM cz_ui_cont_type_templs

8145: COLLECT
8146: INTO l_ui_name_tbl
8147: FROM cz_ui_defs
8148: WHERE cz_ui_defs.ui_def_id IN (SELECT ui_def_id
8149: FROM cz_ui_cont_type_templs
8150: WHERE cz_ui_cont_type_templs.template_id = l_uct_ref(modelId)
8151: AND cz_ui_cont_type_templs.deleted_flag = '0'
8152: AND cz_ui_cont_type_templs.seeded_flag <> '1')
8153: AND cz_ui_defs.deleted_flag = '0';

Line 8150: WHERE cz_ui_cont_type_templs.template_id = l_uct_ref(modelId)

8146: INTO l_ui_name_tbl
8147: FROM cz_ui_defs
8148: WHERE cz_ui_defs.ui_def_id IN (SELECT ui_def_id
8149: FROM cz_ui_cont_type_templs
8150: WHERE cz_ui_cont_type_templs.template_id = l_uct_ref(modelId)
8151: AND cz_ui_cont_type_templs.deleted_flag = '0'
8152: AND cz_ui_cont_type_templs.seeded_flag <> '1')
8153: AND cz_ui_defs.deleted_flag = '0';
8154:

Line 8151: AND cz_ui_cont_type_templs.deleted_flag = '0'

8147: FROM cz_ui_defs
8148: WHERE cz_ui_defs.ui_def_id IN (SELECT ui_def_id
8149: FROM cz_ui_cont_type_templs
8150: WHERE cz_ui_cont_type_templs.template_id = l_uct_ref(modelId)
8151: AND cz_ui_cont_type_templs.deleted_flag = '0'
8152: AND cz_ui_cont_type_templs.seeded_flag <> '1')
8153: AND cz_ui_defs.deleted_flag = '0';
8154:
8155: IF (l_ui_name_tbl.count > 0 ) THEN

Line 8152: AND cz_ui_cont_type_templs.seeded_flag <> '1')

8148: WHERE cz_ui_defs.ui_def_id IN (SELECT ui_def_id
8149: FROM cz_ui_cont_type_templs
8150: WHERE cz_ui_cont_type_templs.template_id = l_uct_ref(modelId)
8151: AND cz_ui_cont_type_templs.deleted_flag = '0'
8152: AND cz_ui_cont_type_templs.seeded_flag <> '1')
8153: AND cz_ui_defs.deleted_flag = '0';
8154:
8155: IF (l_ui_name_tbl.count > 0 ) THEN
8156: x_return_status := FND_API.G_RET_STS_ERROR;