eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_UIOA_PVT dependencies on CZ_UI_REF_TEMPLATES

Line 4486: l_seeded_flag CZ_UI_REF_TEMPLATES.ref_templ_seeded_flag%TYPE;

4482: l_extends_attribute VARCHAR2(2000);
4483: l_ref_tmpls_tbl number_tbl_type;
4484: l_ref_tmpl_seeded_flag varchar_tbl_type;
4485: l_ref_template_id NUMBER;
4486: l_seeded_flag CZ_UI_REF_TEMPLATES.ref_templ_seeded_flag%TYPE;
4487: l_template_id CZ_UI_REF_TEMPLATES.template_id%TYPE;
4488: l_length NUMBER;
4489:
4490: BEGIN

Line 4487: l_template_id CZ_UI_REF_TEMPLATES.template_id%TYPE;

4483: l_ref_tmpls_tbl number_tbl_type;
4484: l_ref_tmpl_seeded_flag varchar_tbl_type;
4485: l_ref_template_id NUMBER;
4486: l_seeded_flag CZ_UI_REF_TEMPLATES.ref_templ_seeded_flag%TYPE;
4487: l_template_id CZ_UI_REF_TEMPLATES.template_id%TYPE;
4488: l_length NUMBER;
4489:
4490: BEGIN
4491:

Line 4528: FOR k IN(SELECT ref_template_id FROM CZ_UI_REF_TEMPLATES

4524:
4525: END LOOP;
4526: END IF;
4527:
4528: FOR k IN(SELECT ref_template_id FROM CZ_UI_REF_TEMPLATES
4529: WHERE template_id=p_template_id AND
4530: template_ui_def_id=p_template_ui_def_id AND
4531: deleted_flag=G_NO_FLAG)
4532: LOOP

Line 4534: DELETE FROM CZ_UI_REF_TEMPLATES

4530: template_ui_def_id=p_template_ui_def_id AND
4531: deleted_flag=G_NO_FLAG)
4532: LOOP
4533: IF NOT(l_ref_tmpls_tbl.EXISTS(k.ref_template_id)) THEN
4534: DELETE FROM CZ_UI_REF_TEMPLATES
4535: WHERE template_id=p_template_id AND
4536: template_ui_def_id=p_template_ui_def_id AND
4537: ref_template_id=k.ref_template_id;
4538: END IF;

Line 4547: UPDATE CZ_UI_REF_TEMPLATES

4543: IF l_template_id IS NULL THEN
4544: EXIT;
4545: END IF;
4546:
4547: UPDATE CZ_UI_REF_TEMPLATES
4548: SET ref_count = l_ref_tmpls_tbl(l_template_id)
4549: WHERE template_id=p_template_id AND
4550: template_ui_def_id=p_template_ui_def_id AND
4551: ref_template_id=l_template_id AND

Line 4555: INSERT INTO CZ_UI_REF_TEMPLATES

4551: ref_template_id=l_template_id AND
4552: deleted_flag=G_NO_FLAG;
4553:
4554: IF SQL%ROWCOUNT=0 THEN
4555: INSERT INTO CZ_UI_REF_TEMPLATES
4556: (
4557: TEMPLATE_ID
4558: ,REF_TEMPLATE_ID
4559: ,DELETED_FLAG

Line 18247: DELETE FROM CZ_UI_REF_TEMPLATES

18243: DELETE FROM CZ_UI_TEMPLATES
18244: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id
18245: AND seeded_flag=G_NO_FLAG;
18246:
18247: DELETE FROM CZ_UI_REF_TEMPLATES
18248: WHERE template_ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
18249:
18250: UPDATE CZ_UI_TEMPLATE_ELEMENTS
18251: SET deleted_flag=G_YES_FLAG

Line 19182: INSERT INTO CZ_UI_REF_TEMPLATES

19178: FROM CZ_UI_TEMPLATES
19179: WHERE ui_def_id=p_source_ui_def_id AND
19180: template_id=p_source_template_id;
19181:
19182: INSERT INTO CZ_UI_REF_TEMPLATES
19183: (
19184: TEMPLATE_ID
19185: ,REF_TEMPLATE_ID
19186: ,DELETED_FLAG

Line 19196: FROM CZ_UI_REF_TEMPLATES

19192: ,REF_TEMPLATE_ID
19193: ,DELETED_FLAG
19194: ,p_target_ui_def_id
19195: ,REF_TEMPLATE_UI_DEF_ID
19196: FROM CZ_UI_REF_TEMPLATES
19197: WHERE template_id=p_source_template_id AND
19198: template_ui_def_id=p_source_ui_def_id AND
19199: deleted_flag=G_NO_FLAG;
19200:

Line 20190: FROM CZ_UI_REF_TEMPLATES

20186:
20187: IF p_ui_def_id = 0 THEN
20188: SELECT ref_count
20189: INTO l_ref_count
20190: FROM CZ_UI_REF_TEMPLATES
20191: WHERE template_id=p_ui_page_id AND
20192: ref_template_id=l_ref_template_id AND
20193: deleted_flag=G_NO_FLAG;
20194:

Line 20196: DELETE FROM CZ_UI_REF_TEMPLATES

20192: ref_template_id=l_ref_template_id AND
20193: deleted_flag=G_NO_FLAG;
20194:
20195: IF l_ref_count=1 THEN
20196: DELETE FROM CZ_UI_REF_TEMPLATES
20197: WHERE template_id=p_ui_page_id AND
20198: ref_template_id=l_ref_template_id AND
20199: deleted_flag=G_NO_FLAG;
20200: ELSIF l_ref_count>1 THEN

Line 20201: UPDATE CZ_UI_REF_TEMPLATES

20197: WHERE template_id=p_ui_page_id AND
20198: ref_template_id=l_ref_template_id AND
20199: deleted_flag=G_NO_FLAG;
20200: ELSIF l_ref_count>1 THEN
20201: UPDATE CZ_UI_REF_TEMPLATES
20202: SET ref_count = ref_count-1
20203: WHERE template_id=p_ui_page_id AND
20204: ref_template_id=l_ref_template_id AND
20205: deleted_flag=G_NO_FLAG;

Line 20208: FOR reft IN (SELECT * FROM CZ_UI_REF_TEMPLATES

20204: ref_template_id=l_ref_template_id AND
20205: deleted_flag=G_NO_FLAG;
20206: END IF;
20207:
20208: FOR reft IN (SELECT * FROM CZ_UI_REF_TEMPLATES
20209: WHERE template_id=l_ref_template_id AND
20210: deleted_flag=G_NO_FLAG)
20211: LOOP
20212:

Line 20213: SELECT NVL(MAX(ref_count),0) INTO l_target_ref_count FROM CZ_UI_REF_TEMPLATES

20209: WHERE template_id=l_ref_template_id AND
20210: deleted_flag=G_NO_FLAG)
20211: LOOP
20212:
20213: SELECT NVL(MAX(ref_count),0) INTO l_target_ref_count FROM CZ_UI_REF_TEMPLATES
20214: WHERE template_id=p_ui_page_id AND
20215: ref_template_id=reft.ref_template_id AND
20216: deleted_flag=G_NO_FLAG;
20217:

Line 20220: INSERT INTO CZ_UI_REF_TEMPLATES

20216: deleted_flag=G_NO_FLAG;
20217:
20218: IF l_target_ref_count=0 THEN
20219:
20220: INSERT INTO CZ_UI_REF_TEMPLATES
20221: (
20222: TEMPLATE_ID
20223: ,REF_TEMPLATE_ID
20224: ,DELETED_FLAG

Line 20245: UPDATE CZ_UI_REF_TEMPLATES

20241: );
20242:
20243: ELSE
20244:
20245: UPDATE CZ_UI_REF_TEMPLATES
20246: SET ref_count=ref_count+l_target_ref_count
20247: WHERE template_id=p_ui_page_id AND
20248: ref_template_id=reft.ref_template_id AND
20249: deleted_flag=G_NO_FLAG;