APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_UI_CONT_TYPE_TEMPLS

Line 6328: INSERT INTO CZ_UI_CONT_TYPE_TEMPLS(

6324: END IF;
6325:
6326: -- Create ui content type templates for this newly copied ui def
6327:
6328: INSERT INTO CZ_UI_CONT_TYPE_TEMPLS(
6329: UI_DEF_ID
6330: ,CONTENT_TYPE
6331: ,TEMPLATE_ID
6332: ,DELETED_FLAG

Line 6347: FROM CZ_UI_CONT_TYPE_TEMPLS

6343: ,MASTER_TEMPLATE_FLAG
6344: ,'0'
6345: ,TEMPLATE_UI_DEF_ID
6346: ,WRAP_TEMPLATE_FLAG
6347: FROM CZ_UI_CONT_TYPE_TEMPLS
6348: WHERE ui_def_id = p_ui_def_id;
6349:
6350: -- Create ui images for this newly copied ui def
6351: INSERT INTO CZ_UI_IMAGES

Line 7013: FROM cz_ui_cont_type_templs

7009: FROM cz_ui_defs ui
7010: WHERE deleted_flag = '0'
7011: AND ui_def_id IN
7012: (SELECT ui_def_id
7013: FROM cz_ui_cont_type_templs
7014: WHERE cz_ui_cont_type_templs.template_id = p_uct_id
7015: AND cz_ui_cont_type_templs.template_ui_def_id = 0
7016: AND cz_ui_cont_type_templs.deleted_flag = '0'
7017: UNION ALL

Line 7014: WHERE cz_ui_cont_type_templs.template_id = p_uct_id

7010: WHERE deleted_flag = '0'
7011: AND ui_def_id IN
7012: (SELECT ui_def_id
7013: FROM cz_ui_cont_type_templs
7014: WHERE cz_ui_cont_type_templs.template_id = p_uct_id
7015: AND cz_ui_cont_type_templs.template_ui_def_id = 0
7016: AND cz_ui_cont_type_templs.deleted_flag = '0'
7017: UNION ALL
7018: SELECT ui_def_id

Line 7015: AND cz_ui_cont_type_templs.template_ui_def_id = 0

7011: AND ui_def_id IN
7012: (SELECT ui_def_id
7013: FROM cz_ui_cont_type_templs
7014: WHERE cz_ui_cont_type_templs.template_id = p_uct_id
7015: AND cz_ui_cont_type_templs.template_ui_def_id = 0
7016: AND cz_ui_cont_type_templs.deleted_flag = '0'
7017: UNION ALL
7018: SELECT ui_def_id
7019: FROM cz_ui_page_elements

Line 7016: AND cz_ui_cont_type_templs.deleted_flag = '0'

7012: (SELECT ui_def_id
7013: FROM cz_ui_cont_type_templs
7014: WHERE cz_ui_cont_type_templs.template_id = p_uct_id
7015: AND cz_ui_cont_type_templs.template_ui_def_id = 0
7016: AND cz_ui_cont_type_templs.deleted_flag = '0'
7017: UNION ALL
7018: SELECT ui_def_id
7019: FROM cz_ui_page_elements
7020: WHERE cz_ui_page_elements.ctrl_template_id = p_uct_id

Line 8210: FROM cz_ui_cont_type_templs

8206: COLLECT
8207: INTO l_ui_name_tbl
8208: FROM cz_ui_defs
8209: WHERE cz_ui_defs.ui_def_id IN (SELECT ui_def_id
8210: FROM cz_ui_cont_type_templs
8211: WHERE cz_ui_cont_type_templs.template_id = l_uct_ref(modelId)
8212: AND cz_ui_cont_type_templs.deleted_flag = '0'
8213: AND cz_ui_cont_type_templs.seeded_flag <> '1'
8214: UNION ALL --Bug#13770170: Added Missing Check for cz_ui_page_elements

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

8207: INTO l_ui_name_tbl
8208: FROM cz_ui_defs
8209: WHERE cz_ui_defs.ui_def_id IN (SELECT ui_def_id
8210: FROM cz_ui_cont_type_templs
8211: WHERE cz_ui_cont_type_templs.template_id = l_uct_ref(modelId)
8212: AND cz_ui_cont_type_templs.deleted_flag = '0'
8213: AND cz_ui_cont_type_templs.seeded_flag <> '1'
8214: UNION ALL --Bug#13770170: Added Missing Check for cz_ui_page_elements
8215: SELECT ui_def_id

Line 8212: AND cz_ui_cont_type_templs.deleted_flag = '0'

8208: FROM cz_ui_defs
8209: WHERE cz_ui_defs.ui_def_id IN (SELECT ui_def_id
8210: FROM cz_ui_cont_type_templs
8211: WHERE cz_ui_cont_type_templs.template_id = l_uct_ref(modelId)
8212: AND cz_ui_cont_type_templs.deleted_flag = '0'
8213: AND cz_ui_cont_type_templs.seeded_flag <> '1'
8214: UNION ALL --Bug#13770170: Added Missing Check for cz_ui_page_elements
8215: SELECT ui_def_id
8216: FROM cz_ui_page_elements

Line 8213: AND cz_ui_cont_type_templs.seeded_flag <> '1'

8209: WHERE cz_ui_defs.ui_def_id IN (SELECT ui_def_id
8210: FROM cz_ui_cont_type_templs
8211: WHERE cz_ui_cont_type_templs.template_id = l_uct_ref(modelId)
8212: AND cz_ui_cont_type_templs.deleted_flag = '0'
8213: AND cz_ui_cont_type_templs.seeded_flag <> '1'
8214: UNION ALL --Bug#13770170: Added Missing Check for cz_ui_page_elements
8215: SELECT ui_def_id
8216: FROM cz_ui_page_elements
8217: WHERE cz_ui_page_elements.ctrl_template_id = l_uct_ref(modelId)