APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_UI_REF_TEMPLATES

Line 6039: INSERT INTO CZ_UI_REF_TEMPLATES

6035:
6036:
6037: -- Create Template Refs
6038:
6039: INSERT INTO CZ_UI_REF_TEMPLATES
6040: (
6041: TEMPLATE_ID
6042: ,REF_TEMPLATE_ID
6043: ,DELETED_FLAG

Line 6059: FROM CZ_UI_REF_TEMPLATES

6055: ,REF_TEMPLATE_UI_DEF_ID
6056: ,'0'
6057: ,REF_TEMPL_SEEDED_FLAG
6058: ,REF_COUNT
6059: FROM CZ_UI_REF_TEMPLATES
6060: WHERE template_id=p_template_id AND
6061: template_ui_def_id=0 AND
6062: deleted_flag='0';
6063:

Line 7021: FROM cz_ui_ref_templates

7017:
7018: BEGIN
7019: SELECT template_id, template_ui_def_id
7020: BULK COLLECT INTO l_ref_template_tbl, l_ref_templ_ui_tbl
7021: FROM cz_ui_ref_templates
7022: WHERE cz_ui_ref_templates.deleted_flag = '0'
7023: AND cz_ui_ref_templates.ref_template_id = p_uct_id
7024: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;
7025: EXCEPTION

Line 7022: WHERE cz_ui_ref_templates.deleted_flag = '0'

7018: BEGIN
7019: SELECT template_id, template_ui_def_id
7020: BULK COLLECT INTO l_ref_template_tbl, l_ref_templ_ui_tbl
7021: FROM cz_ui_ref_templates
7022: WHERE cz_ui_ref_templates.deleted_flag = '0'
7023: AND cz_ui_ref_templates.ref_template_id = p_uct_id
7024: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;
7025: EXCEPTION
7026: WHEN NO_DATA_FOUND THEN

Line 7023: AND cz_ui_ref_templates.ref_template_id = p_uct_id

7019: SELECT template_id, template_ui_def_id
7020: BULK COLLECT INTO l_ref_template_tbl, l_ref_templ_ui_tbl
7021: FROM cz_ui_ref_templates
7022: WHERE cz_ui_ref_templates.deleted_flag = '0'
7023: AND cz_ui_ref_templates.ref_template_id = p_uct_id
7024: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;
7025: EXCEPTION
7026: WHEN NO_DATA_FOUND THEN
7027: NULL;

Line 7024: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;

7020: BULK COLLECT INTO l_ref_template_tbl, l_ref_templ_ui_tbl
7021: FROM cz_ui_ref_templates
7022: WHERE cz_ui_ref_templates.deleted_flag = '0'
7023: AND cz_ui_ref_templates.ref_template_id = p_uct_id
7024: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;
7025: EXCEPTION
7026: WHEN NO_DATA_FOUND THEN
7027: NULL;
7028: END;