APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_UI_REF_TEMPLATES

Line 6068: INSERT INTO CZ_UI_REF_TEMPLATES

6064:
6065:
6066: -- Create Template Refs
6067:
6068: INSERT INTO CZ_UI_REF_TEMPLATES
6069: (
6070: TEMPLATE_ID
6071: ,REF_TEMPLATE_ID
6072: ,DELETED_FLAG

Line 6088: FROM CZ_UI_REF_TEMPLATES

6084: ,REF_TEMPLATE_UI_DEF_ID
6085: ,'0'
6086: ,REF_TEMPL_SEEDED_FLAG
6087: ,REF_COUNT
6088: FROM CZ_UI_REF_TEMPLATES
6089: WHERE template_id=p_template_id AND
6090: template_ui_def_id=0 AND
6091: deleted_flag='0';
6092:

Line 7050: FROM cz_ui_ref_templates

7046:
7047: BEGIN
7048: SELECT template_id, template_ui_def_id
7049: BULK COLLECT INTO l_ref_template_tbl, l_ref_templ_ui_tbl
7050: FROM cz_ui_ref_templates
7051: WHERE cz_ui_ref_templates.deleted_flag = '0'
7052: AND cz_ui_ref_templates.ref_template_id = p_uct_id
7053: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;
7054: EXCEPTION

Line 7051: WHERE cz_ui_ref_templates.deleted_flag = '0'

7047: BEGIN
7048: SELECT template_id, template_ui_def_id
7049: BULK COLLECT INTO l_ref_template_tbl, l_ref_templ_ui_tbl
7050: FROM cz_ui_ref_templates
7051: WHERE cz_ui_ref_templates.deleted_flag = '0'
7052: AND cz_ui_ref_templates.ref_template_id = p_uct_id
7053: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;
7054: EXCEPTION
7055: WHEN NO_DATA_FOUND THEN

Line 7052: AND cz_ui_ref_templates.ref_template_id = p_uct_id

7048: SELECT template_id, template_ui_def_id
7049: BULK COLLECT INTO l_ref_template_tbl, l_ref_templ_ui_tbl
7050: FROM cz_ui_ref_templates
7051: WHERE cz_ui_ref_templates.deleted_flag = '0'
7052: AND cz_ui_ref_templates.ref_template_id = p_uct_id
7053: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;
7054: EXCEPTION
7055: WHEN NO_DATA_FOUND THEN
7056: NULL;

Line 7053: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;

7049: BULK COLLECT INTO l_ref_template_tbl, l_ref_templ_ui_tbl
7050: FROM cz_ui_ref_templates
7051: WHERE cz_ui_ref_templates.deleted_flag = '0'
7052: AND cz_ui_ref_templates.ref_template_id = p_uct_id
7053: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;
7054: EXCEPTION
7055: WHEN NO_DATA_FOUND THEN
7056: NULL;
7057: END;

Line 8234: --Bug#13770170: Adding missing check for cz_ui_ref_templates

8230: FND_MESSAGE.SET_TOKEN('UINAME', l_ui_name_tbl(i));
8231: FND_MSG_PUB.ADD;
8232: END LOOP;
8233: END IF;
8234: --Bug#13770170: Adding missing check for cz_ui_ref_templates
8235:
8236: BEGIN
8237: SELECT template_id, template_ui_def_id
8238: BULK COLLECT INTO l_ref_template_tbl, l_ref_templ_ui_tbl

Line 8239: FROM cz_ui_ref_templates

8235:
8236: BEGIN
8237: SELECT template_id, template_ui_def_id
8238: BULK COLLECT INTO l_ref_template_tbl, l_ref_templ_ui_tbl
8239: FROM cz_ui_ref_templates
8240: WHERE cz_ui_ref_templates.deleted_flag = '0'
8241: AND cz_ui_ref_templates.ref_template_id = l_uct_ref(modelId)
8242: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;
8243:

Line 8240: WHERE cz_ui_ref_templates.deleted_flag = '0'

8236: BEGIN
8237: SELECT template_id, template_ui_def_id
8238: BULK COLLECT INTO l_ref_template_tbl, l_ref_templ_ui_tbl
8239: FROM cz_ui_ref_templates
8240: WHERE cz_ui_ref_templates.deleted_flag = '0'
8241: AND cz_ui_ref_templates.ref_template_id = l_uct_ref(modelId)
8242: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;
8243:
8244: EXCEPTION

Line 8241: AND cz_ui_ref_templates.ref_template_id = l_uct_ref(modelId)

8237: SELECT template_id, template_ui_def_id
8238: BULK COLLECT INTO l_ref_template_tbl, l_ref_templ_ui_tbl
8239: FROM cz_ui_ref_templates
8240: WHERE cz_ui_ref_templates.deleted_flag = '0'
8241: AND cz_ui_ref_templates.ref_template_id = l_uct_ref(modelId)
8242: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;
8243:
8244: EXCEPTION
8245: WHEN NO_DATA_FOUND THEN

Line 8242: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;

8238: BULK COLLECT INTO l_ref_template_tbl, l_ref_templ_ui_tbl
8239: FROM cz_ui_ref_templates
8240: WHERE cz_ui_ref_templates.deleted_flag = '0'
8241: AND cz_ui_ref_templates.ref_template_id = l_uct_ref(modelId)
8242: AND cz_ui_ref_templates.ref_template_ui_def_id = 0;
8243:
8244: EXCEPTION
8245: WHEN NO_DATA_FOUND THEN
8246: NULL;