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_RUNTIME dependencies on CZ_UI_PAGE_ELEM_TBL

Line 996: l_ui_pages_tbl0 SYSTEM.CZ_UI_PAGE_ELEM_TBL := SYSTEM.CZ_UI_PAGE_ELEM_TBL(SYSTEM.CZ_UI_PAGE_ELEM_REC(NULL,NULL,NULL));

992: p_order_by_template IN NUMBER,
993: x_ui_page_tbl OUT NOCOPY SYSTEM.cz_tgt_ui_page_tbl) IS
994:
995: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
996: l_ui_pages_tbl0 SYSTEM.CZ_UI_PAGE_ELEM_TBL := SYSTEM.CZ_UI_PAGE_ELEM_TBL(SYSTEM.CZ_UI_PAGE_ELEM_REC(NULL,NULL,NULL));
997: l_ui_pages_tbl1 SYSTEM.CZ_UI_PAGE_ELEM_TBL := SYSTEM.CZ_UI_PAGE_ELEM_TBL(SYSTEM.CZ_UI_PAGE_ELEM_REC(NULL,NULL,NULL));
998:
999: l_hash_map number_tbl_type;
1000: l_root_model_id NUMBER;

Line 997: l_ui_pages_tbl1 SYSTEM.CZ_UI_PAGE_ELEM_TBL := SYSTEM.CZ_UI_PAGE_ELEM_TBL(SYSTEM.CZ_UI_PAGE_ELEM_REC(NULL,NULL,NULL));

993: x_ui_page_tbl OUT NOCOPY SYSTEM.cz_tgt_ui_page_tbl) IS
994:
995: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
996: l_ui_pages_tbl0 SYSTEM.CZ_UI_PAGE_ELEM_TBL := SYSTEM.CZ_UI_PAGE_ELEM_TBL(SYSTEM.CZ_UI_PAGE_ELEM_REC(NULL,NULL,NULL));
997: l_ui_pages_tbl1 SYSTEM.CZ_UI_PAGE_ELEM_TBL := SYSTEM.CZ_UI_PAGE_ELEM_TBL(SYSTEM.CZ_UI_PAGE_ELEM_REC(NULL,NULL,NULL));
998:
999: l_hash_map number_tbl_type;
1000: l_root_model_id NUMBER;
1001: l_tbl_counter NUMBER;

Line 1054: (SELECT /+ CARDINALITY (UITPAGES 1) / uitpages.page_id,uitpages.ui_def_id,uitpages.element_id FROM TABLE(CAST(l_ui_pages_tbl0 AS SYSTEM.CZ_UI_PAGE_ELEM_TBL)) UITPAGES)

1050: FROM
1051: CZ_UI_PAGES uipages,
1052: (SELECT els.ui_def_id,els.page_id,els.element_id,level as PAGE_LEVEL FROM CZ_UI_PAGE_ELEMENTS els
1053: START WITH (els.page_id,els.ui_def_id,els.element_id) IN
1054: (SELECT /*+ CARDINALITY (UITPAGES 1) */ uitpages.page_id,uitpages.ui_def_id,uitpages.element_id FROM TABLE(CAST(l_ui_pages_tbl0 AS SYSTEM.CZ_UI_PAGE_ELEM_TBL)) UITPAGES)
1055: CONNECT BY els.element_signature_id=6073 AND
1056: els.target_page_ui_def_id= PRIOR els.ui_def_id AND
1057: els.target_page_id= PRIOR els.page_id AND deleted_flag='0' AND PRIOR deleted_flag='0') uiels
1058: WHERE uipages.page_id=uiels.page_id AND uipages.ui_def_id=uiels.ui_def_id

Line 1083: (SELECT /+ CARDINALITY(UITPAGES1 1) / uitpages1.page_id,uitpages1.ui_def_id,uitpages1.element_id FROM TABLE(CAST(l_ui_pages_tbl1 AS SYSTEM.CZ_UI_PAGE_ELEM_TBL)) UITPAGES1)

1079: FROM
1080: CZ_UI_PAGES uipages,
1081: (SELECT els.ui_def_id,els.page_id,els.element_id,level as PAGE_LEVEL FROM CZ_UI_PAGE_ELEMENTS els
1082: START WITH (els.page_id,els.ui_def_id,els.element_id) IN
1083: (SELECT /*+ CARDINALITY(UITPAGES1 1) */ uitpages1.page_id,uitpages1.ui_def_id,uitpages1.element_id FROM TABLE(CAST(l_ui_pages_tbl1 AS SYSTEM.CZ_UI_PAGE_ELEM_TBL)) UITPAGES1)
1084: CONNECT BY els.element_signature_id=6073 AND
1085: els.target_page_ui_def_id= PRIOR els.ui_def_id AND
1086: els.target_page_id= PRIOR els.page_id AND deleted_flag='0' AND PRIOR deleted_flag='0') uiels
1087: WHERE uipages.page_id=uiels.page_id AND uipages.ui_def_id=uiels.ui_def_id

Line 1142: (SELECT uitpages.page_id,uitpages.ui_def_id,uitpages.element_id FROM TABLE(CAST(l_ui_pages_tbl0 AS SYSTEM.CZ_UI_PAGE_ELEM_TBL)) uitpages)

1138: FROM
1139: CZ_UI_PAGES uipages,
1140: (SELECT els.ui_def_id,els.page_id,els.element_id,level as PAGE_LEVEL FROM CZ_UI_PAGE_ELEMENTS els
1141: START WITH (els.page_id,els.ui_def_id,els.element_id) IN
1142: (SELECT uitpages.page_id,uitpages.ui_def_id,uitpages.element_id FROM TABLE(CAST(l_ui_pages_tbl0 AS SYSTEM.CZ_UI_PAGE_ELEM_TBL)) uitpages)
1143: CONNECT BY els.element_signature_id=6073 AND
1144: els.target_page_ui_def_id= PRIOR els.ui_def_id AND
1145: els.target_page_id= PRIOR els.page_id AND deleted_flag='0' AND PRIOR deleted_flag='0') uiels
1146: WHERE uipages.page_id=uiels.page_id AND uipages.ui_def_id=uiels.ui_def_id

Line 1171: (SELECT uitpages1.page_id,uitpages1.ui_def_id,uitpages1.element_id FROM TABLE(CAST(l_ui_pages_tbl1 AS SYSTEM.CZ_UI_PAGE_ELEM_TBL)) uitpages1)

1167: FROM
1168: CZ_UI_PAGES uipages,
1169: (SELECT els.ui_def_id,els.page_id,els.element_id,level as PAGE_LEVEL FROM CZ_UI_PAGE_ELEMENTS els
1170: START WITH (els.page_id,els.ui_def_id,els.element_id) IN
1171: (SELECT uitpages1.page_id,uitpages1.ui_def_id,uitpages1.element_id FROM TABLE(CAST(l_ui_pages_tbl1 AS SYSTEM.CZ_UI_PAGE_ELEM_TBL)) uitpages1)
1172: CONNECT BY els.element_signature_id=6073 AND
1173: els.target_page_ui_def_id= PRIOR els.ui_def_id AND
1174: els.target_page_id= PRIOR els.page_id AND deleted_flag='0' AND PRIOR deleted_flag='0') uiels
1175: WHERE uipages.page_id=uiels.page_id AND uipages.ui_def_id=uiels.ui_def_id )