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 4611: l_seeded_flag CZ_UI_REF_TEMPLATES.ref_templ_seeded_flag%TYPE;

4607: l_extends_attribute VARCHAR2(2000);
4608: l_ref_tmpls_tbl number_tbl_type;
4609: l_ref_tmpl_seeded_flag varchar_tbl_type;
4610: l_ref_template_id NUMBER;
4611: l_seeded_flag CZ_UI_REF_TEMPLATES.ref_templ_seeded_flag%TYPE;
4612: l_template_id CZ_UI_REF_TEMPLATES.template_id%TYPE;
4613: l_length NUMBER;
4614:
4615: BEGIN

Line 4612: l_template_id CZ_UI_REF_TEMPLATES.template_id%TYPE;

4608: l_ref_tmpls_tbl number_tbl_type;
4609: l_ref_tmpl_seeded_flag varchar_tbl_type;
4610: l_ref_template_id NUMBER;
4611: l_seeded_flag CZ_UI_REF_TEMPLATES.ref_templ_seeded_flag%TYPE;
4612: l_template_id CZ_UI_REF_TEMPLATES.template_id%TYPE;
4613: l_length NUMBER;
4614:
4615: BEGIN
4616:

Line 4653: FOR k IN(SELECT ref_template_id FROM CZ_UI_REF_TEMPLATES

4649:
4650: END LOOP;
4651: END IF;
4652:
4653: FOR k IN(SELECT ref_template_id FROM CZ_UI_REF_TEMPLATES
4654: WHERE template_id=p_template_id AND
4655: template_ui_def_id=p_template_ui_def_id AND
4656: deleted_flag=G_NO_FLAG)
4657: LOOP

Line 4659: DELETE FROM CZ_UI_REF_TEMPLATES

4655: template_ui_def_id=p_template_ui_def_id AND
4656: deleted_flag=G_NO_FLAG)
4657: LOOP
4658: IF NOT(l_ref_tmpls_tbl.EXISTS(k.ref_template_id)) THEN
4659: DELETE FROM CZ_UI_REF_TEMPLATES
4660: WHERE template_id=p_template_id AND
4661: template_ui_def_id=p_template_ui_def_id AND
4662: ref_template_id=k.ref_template_id;
4663: END IF;

Line 4672: UPDATE CZ_UI_REF_TEMPLATES

4668: IF l_template_id IS NULL THEN
4669: EXIT;
4670: END IF;
4671:
4672: UPDATE CZ_UI_REF_TEMPLATES
4673: SET ref_count = l_ref_tmpls_tbl(l_template_id)
4674: WHERE template_id=p_template_id AND
4675: template_ui_def_id=p_template_ui_def_id AND
4676: ref_template_id=l_template_id AND

Line 4680: INSERT INTO CZ_UI_REF_TEMPLATES

4676: ref_template_id=l_template_id AND
4677: deleted_flag=G_NO_FLAG;
4678:
4679: IF SQL%ROWCOUNT=0 THEN
4680: INSERT INTO CZ_UI_REF_TEMPLATES
4681: (
4682: TEMPLATE_ID
4683: ,REF_TEMPLATE_ID
4684: ,DELETED_FLAG

Line 19153: DELETE FROM CZ_UI_REF_TEMPLATES

19149: DELETE FROM CZ_UI_TEMPLATES
19150: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id
19151: AND seeded_flag=G_NO_FLAG;
19152:
19153: DELETE FROM CZ_UI_REF_TEMPLATES
19154: WHERE template_ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
19155:
19156: UPDATE CZ_UI_TEMPLATE_ELEMENTS
19157: SET deleted_flag=G_YES_FLAG

Line 20269: INSERT INTO CZ_UI_REF_TEMPLATES

20265: FROM CZ_UI_TEMPLATES
20266: WHERE ui_def_id=p_source_ui_def_id AND
20267: template_id=p_source_template_id;
20268:
20269: INSERT INTO CZ_UI_REF_TEMPLATES
20270: (
20271: TEMPLATE_ID
20272: ,REF_TEMPLATE_ID
20273: ,DELETED_FLAG

Line 20283: FROM CZ_UI_REF_TEMPLATES

20279: ,REF_TEMPLATE_ID
20280: ,DELETED_FLAG
20281: ,p_target_ui_def_id
20282: ,REF_TEMPLATE_UI_DEF_ID
20283: FROM CZ_UI_REF_TEMPLATES
20284: WHERE template_id=p_source_template_id AND
20285: template_ui_def_id=p_source_ui_def_id AND
20286: deleted_flag=G_NO_FLAG;
20287:

Line 21306: FROM CZ_UI_REF_TEMPLATES

21302:
21303: IF p_ui_def_id = 0 THEN
21304: SELECT ref_count
21305: INTO l_ref_count
21306: FROM CZ_UI_REF_TEMPLATES
21307: WHERE template_id=p_ui_page_id AND
21308: ref_template_id=l_ref_template_id AND
21309: deleted_flag=G_NO_FLAG;
21310:

Line 21312: DELETE FROM CZ_UI_REF_TEMPLATES

21308: ref_template_id=l_ref_template_id AND
21309: deleted_flag=G_NO_FLAG;
21310:
21311: IF l_ref_count=1 THEN
21312: DELETE FROM CZ_UI_REF_TEMPLATES
21313: WHERE template_id=p_ui_page_id AND
21314: ref_template_id=l_ref_template_id AND
21315: deleted_flag=G_NO_FLAG;
21316: ELSIF l_ref_count>1 THEN

Line 21317: UPDATE CZ_UI_REF_TEMPLATES

21313: WHERE template_id=p_ui_page_id AND
21314: ref_template_id=l_ref_template_id AND
21315: deleted_flag=G_NO_FLAG;
21316: ELSIF l_ref_count>1 THEN
21317: UPDATE CZ_UI_REF_TEMPLATES
21318: SET ref_count = ref_count-1
21319: WHERE template_id=p_ui_page_id AND
21320: ref_template_id=l_ref_template_id AND
21321: deleted_flag=G_NO_FLAG;

Line 21324: FOR reft IN (SELECT * FROM CZ_UI_REF_TEMPLATES

21320: ref_template_id=l_ref_template_id AND
21321: deleted_flag=G_NO_FLAG;
21322: END IF;
21323:
21324: FOR reft IN (SELECT * FROM CZ_UI_REF_TEMPLATES
21325: WHERE template_id=l_ref_template_id AND
21326: deleted_flag=G_NO_FLAG)
21327: LOOP
21328:

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

21325: WHERE template_id=l_ref_template_id AND
21326: deleted_flag=G_NO_FLAG)
21327: LOOP
21328:
21329: SELECT NVL(MAX(ref_count),0) INTO l_target_ref_count FROM CZ_UI_REF_TEMPLATES
21330: WHERE template_id=p_ui_page_id AND
21331: ref_template_id=reft.ref_template_id AND
21332: deleted_flag=G_NO_FLAG;
21333:

Line 21336: INSERT INTO CZ_UI_REF_TEMPLATES

21332: deleted_flag=G_NO_FLAG;
21333:
21334: IF l_target_ref_count=0 THEN
21335:
21336: INSERT INTO CZ_UI_REF_TEMPLATES
21337: (
21338: TEMPLATE_ID
21339: ,REF_TEMPLATE_ID
21340: ,DELETED_FLAG

Line 21361: UPDATE CZ_UI_REF_TEMPLATES

21357: );
21358:
21359: ELSE
21360:
21361: UPDATE CZ_UI_REF_TEMPLATES
21362: SET ref_count=ref_count+l_target_ref_count
21363: WHERE template_id=p_ui_page_id AND
21364: ref_template_id=reft.ref_template_id AND
21365: deleted_flag=G_NO_FLAG;