APPS.CZ_MIGRATE dependencies on CZ_UI_DEFS

Line 532: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS

528:
529: EXECUTE IMMEDIATE
530: 'begin DBMS_APPLICATION_INFO.SET_MODULE@'||dbLinkName||'(:1, :2); end;' USING 'PUBLISH_MODEL',TO_CHAR(x_run_id) ;
531:
532: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS
533: WHERE deleted_flag='0' AND ui_style IN(G_OA_UIMT_STYLE,G_OA_UI_STYLE))
534: LOOP
535: import_jrad_docs (p_ui_def_id => i.ui_def_id,
536: p_link_name => dbLinkName,

Line 1790: (66, 'SEQUENCES', '0', 'CZ_UI_DEFS_S', 'CZ_UI_DEFS', 'UI_DEF_ID', '20');

1786:
1787: INSERT INTO cz_xfr_tables
1788: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1789: VALUES
1790: (66, 'SEQUENCES', '0', 'CZ_UI_DEFS_S', 'CZ_UI_DEFS', 'UI_DEF_ID', '20');
1791:
1792: INSERT INTO cz_xfr_tables
1793: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1794: VALUES

Line 2130: FROM cz_ui_defs

2126: WHERE cz_ui_templates.deleted_flag = '0'
2127: AND cz_ui_templates.seeded_flag = '0'
2128: AND cz_ui_templates.ui_def_id = 0
2129: OR cz_ui_templates.ui_def_id IN (SELECT ui_def_id
2130: FROM cz_ui_defs
2131: WHERE cz_ui_defs.deleted_flag = '0');
2132:
2133: IF (l_ui_def_id_tbl.COUNT > 0) THEN
2134: FOR I IN l_ui_def_id_tbl.FIRST..l_ui_def_id_tbl.LAST

Line 2131: WHERE cz_ui_defs.deleted_flag = '0');

2127: AND cz_ui_templates.seeded_flag = '0'
2128: AND cz_ui_templates.ui_def_id = 0
2129: OR cz_ui_templates.ui_def_id IN (SELECT ui_def_id
2130: FROM cz_ui_defs
2131: WHERE cz_ui_defs.deleted_flag = '0');
2132:
2133: IF (l_ui_def_id_tbl.COUNT > 0) THEN
2134: FOR I IN l_ui_def_id_tbl.FIRST..l_ui_def_id_tbl.LAST
2135: LOOP