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.

SYSTEM.AD_APPS_PRIVATE dependencies on DBMS_OUTPUT

Line 714: -- dbms_output.put_line('Dropping view '||to_schema||'.'||view_name);

710: ' +++ 711: --
712: -- Try dropping the view
713: begin
714: -- dbms_output.put_line('Dropping view '||to_schema||'.'||view_name);
715: drop_object(to_schema, view_name, 'VIEW');
716: exception
717: when others then
718: raise;

Line 2766: -- dbms_output.put_line('Add: '||sel_level||' '||sel_type||' '||sel_name);

2762: if sel_level > max_level then
2763: max_level := sel_level;
2764: end if;
2765:
2766: -- dbms_output.put_line('Add: '||sel_level||' '||sel_type||' '||sel_name);
2767: end if;
2768:
2769: end loop;
2770: -- end loop to get first-level dependencies

Line 2840: -- dbms_output.put_line('Add: '||sel_level||' '||sel_type||' '||sel_name);

2836: max_level := sel_level;
2837: end if;
2838: any_added := TRUE;
2839:
2840: -- dbms_output.put_line('Add: '||sel_level||' '||sel_type||' '||sel_name);
2841:
2842: end if;
2843: -- end if added object
2844:

Line 2845: -- dbms_output.put_line('FYI: '||sel_level||' '||sel_type||' '||sel_name);

2841:
2842: end if;
2843: -- end if added object
2844:
2845: -- dbms_output.put_line('FYI: '||sel_level||' '||sel_type||' '||sel_name);
2846: end if;
2847:
2848: end loop;
2849: -- end loop to fetch dependent objects for one object at this level

Line 2868: -- dbms_output.put_line('Fin: '||obj_levels(i)||' '||

2864:
2865: -- Debugging output: list all dependent objects and their dependency levels
2866:
2867: -- for i in 1..num_objs loop
2868: -- dbms_output.put_line('Fin: '||obj_levels(i)||' '||
2869: -- obj_types(i)||' '||obj_names(i));
2870: -- end loop;
2871:
2872: -- compile objects by dependency order in dest schema

Line 2906: -- dbms_output.put_line('('||obj_levels(i)||') '||statement);

2902: end if;
2903:
2904: -- execute compilation statement
2905:
2906: -- dbms_output.put_line('('||obj_levels(i)||') '||statement);
2907:
2908: begin
2909: ad_apps_private.do_apps_ddl(recompile_schema, statement);
2910: exception

Line 2979: -- initialize dbms_output with large buffer size (200,000)

2975: procedure show_exception_list
2976: is
2977: i number;
2978: begin
2979: -- initialize dbms_output with large buffer size (200,000)
2980: -- default is 20,000 min is 2,000 max is 1,000,000
2981:
2982: dbms_output.enable(200000);
2983:

Line 2982: dbms_output.enable(200000);

2978: begin
2979: -- initialize dbms_output with large buffer size (200,000)
2980: -- default is 20,000 min is 2,000 max is 1,000,000
2981:
2982: dbms_output.enable(200000);
2983:
2984: -- load exception list, if not already loaded
2985:
2986: load_exception_list;

Line 2990: dbms_output.put_line('-');

2986: load_exception_list;
2987:
2988: -- display settings
2989:
2990: dbms_output.put_line('-');
2991: dbms_output.put_line(list_count ||' entries in exception list.');
2992: dbms_output.put_line('-');
2993:
2994: i := 1;

Line 2991: dbms_output.put_line(list_count ||' entries in exception list.');

2987:
2988: -- display settings
2989:
2990: dbms_output.put_line('-');
2991: dbms_output.put_line(list_count ||' entries in exception list.');
2992: dbms_output.put_line('-');
2993:
2994: i := 1;
2995: while i <= list_count loop

Line 2992: dbms_output.put_line('-');

2988: -- display settings
2989:
2990: dbms_output.put_line('-');
2991: dbms_output.put_line(list_count ||' entries in exception list.');
2992: dbms_output.put_line('-');
2993:
2994: i := 1;
2995: while i <= list_count loop
2996: dbms_output.put_line('['||i||'] Product Short Name: '||

Line 2996: dbms_output.put_line('['||i||'] Product Short Name: '||

2992: dbms_output.put_line('-');
2993:
2994: i := 1;
2995: while i <= list_count loop
2996: dbms_output.put_line('['||i||'] Product Short Name: '||
2997: prod_short_name(i));
2998: dbms_output.put_line('['||i||'] Base Schema Name : '||
2999: base_name(i));
3000: dbms_output.put_line('['||i||'] Base Schema Type : '||

Line 2998: dbms_output.put_line('['||i||'] Base Schema Name : '||

2994: i := 1;
2995: while i <= list_count loop
2996: dbms_output.put_line('['||i||'] Product Short Name: '||
2997: prod_short_name(i));
2998: dbms_output.put_line('['||i||'] Base Schema Name : '||
2999: base_name(i));
3000: dbms_output.put_line('['||i||'] Base Schema Type : '||
3001: base_type(i));
3002: dbms_output.put_line('['||i||'] Exception Type : '||

Line 3000: dbms_output.put_line('['||i||'] Base Schema Type : '||

2996: dbms_output.put_line('['||i||'] Product Short Name: '||
2997: prod_short_name(i));
2998: dbms_output.put_line('['||i||'] Base Schema Name : '||
2999: base_name(i));
3000: dbms_output.put_line('['||i||'] Base Schema Type : '||
3001: base_type(i));
3002: dbms_output.put_line('['||i||'] Exception Type : '||
3003: exception_type(i));
3004: dbms_output.put_line('['||i||'] Trigger Obj Schema: '||

Line 3002: dbms_output.put_line('['||i||'] Exception Type : '||

2998: dbms_output.put_line('['||i||'] Base Schema Name : '||
2999: base_name(i));
3000: dbms_output.put_line('['||i||'] Base Schema Type : '||
3001: base_type(i));
3002: dbms_output.put_line('['||i||'] Exception Type : '||
3003: exception_type(i));
3004: dbms_output.put_line('['||i||'] Trigger Obj Schema: '||
3005: trigger_obj_schema(i));
3006: dbms_output.put_line('['||i||'] Trigger Obj Type : '||

Line 3004: dbms_output.put_line('['||i||'] Trigger Obj Schema: '||

3000: dbms_output.put_line('['||i||'] Base Schema Type : '||
3001: base_type(i));
3002: dbms_output.put_line('['||i||'] Exception Type : '||
3003: exception_type(i));
3004: dbms_output.put_line('['||i||'] Trigger Obj Schema: '||
3005: trigger_obj_schema(i));
3006: dbms_output.put_line('['||i||'] Trigger Obj Type : '||
3007: trigger_obj_type(i));
3008: dbms_output.put_line('['||i||'] Trigger Obj Name : '||

Line 3006: dbms_output.put_line('['||i||'] Trigger Obj Type : '||

3002: dbms_output.put_line('['||i||'] Exception Type : '||
3003: exception_type(i));
3004: dbms_output.put_line('['||i||'] Trigger Obj Schema: '||
3005: trigger_obj_schema(i));
3006: dbms_output.put_line('['||i||'] Trigger Obj Type : '||
3007: trigger_obj_type(i));
3008: dbms_output.put_line('['||i||'] Trigger Obj Name : '||
3009: trigger_obj_name(i));
3010: dbms_output.put_line('['||i||'] APPS Schema Name : '||

Line 3008: dbms_output.put_line('['||i||'] Trigger Obj Name : '||

3004: dbms_output.put_line('['||i||'] Trigger Obj Schema: '||
3005: trigger_obj_schema(i));
3006: dbms_output.put_line('['||i||'] Trigger Obj Type : '||
3007: trigger_obj_type(i));
3008: dbms_output.put_line('['||i||'] Trigger Obj Name : '||
3009: trigger_obj_name(i));
3010: dbms_output.put_line('['||i||'] APPS Schema Name : '||
3011: apps_name(i));
3012: dbms_output.put_line('['||i||'] APPS Schema Type : '||

Line 3010: dbms_output.put_line('['||i||'] APPS Schema Name : '||

3006: dbms_output.put_line('['||i||'] Trigger Obj Type : '||
3007: trigger_obj_type(i));
3008: dbms_output.put_line('['||i||'] Trigger Obj Name : '||
3009: trigger_obj_name(i));
3010: dbms_output.put_line('['||i||'] APPS Schema Name : '||
3011: apps_name(i));
3012: dbms_output.put_line('['||i||'] APPS Schema Type : '||
3013: apps_type(i));
3014: dbms_output.put_line('['||i||'] Points to Schema : '||

Line 3012: dbms_output.put_line('['||i||'] APPS Schema Type : '||

3008: dbms_output.put_line('['||i||'] Trigger Obj Name : '||
3009: trigger_obj_name(i));
3010: dbms_output.put_line('['||i||'] APPS Schema Name : '||
3011: apps_name(i));
3012: dbms_output.put_line('['||i||'] APPS Schema Type : '||
3013: apps_type(i));
3014: dbms_output.put_line('['||i||'] Points to Schema : '||
3015: points_to_schema(i));
3016: dbms_output.put_line('['||i||'] Points to Obj Name: '||

Line 3014: dbms_output.put_line('['||i||'] Points to Schema : '||

3010: dbms_output.put_line('['||i||'] APPS Schema Name : '||
3011: apps_name(i));
3012: dbms_output.put_line('['||i||'] APPS Schema Type : '||
3013: apps_type(i));
3014: dbms_output.put_line('['||i||'] Points to Schema : '||
3015: points_to_schema(i));
3016: dbms_output.put_line('['||i||'] Points to Obj Name: '||
3017: points_to_name(i));
3018: dbms_output.put_line('['||i||']');

Line 3016: dbms_output.put_line('['||i||'] Points to Obj Name: '||

3012: dbms_output.put_line('['||i||'] APPS Schema Type : '||
3013: apps_type(i));
3014: dbms_output.put_line('['||i||'] Points to Schema : '||
3015: points_to_schema(i));
3016: dbms_output.put_line('['||i||'] Points to Obj Name: '||
3017: points_to_name(i));
3018: dbms_output.put_line('['||i||']');
3019: i := i + 1;
3020: end loop;

Line 3018: dbms_output.put_line('['||i||']');

3014: dbms_output.put_line('['||i||'] Points to Schema : '||
3015: points_to_schema(i));
3016: dbms_output.put_line('['||i||'] Points to Obj Name: '||
3017: points_to_name(i));
3018: dbms_output.put_line('['||i||']');
3019: i := i + 1;
3020: end loop;
3021:
3022: dbms_output.put_line('-');

Line 3022: dbms_output.put_line('-');

3018: dbms_output.put_line('['||i||']');
3019: i := i + 1;
3020: end loop;
3021:
3022: dbms_output.put_line('-');
3023:
3024: exception
3025: when others then
3026: ad_apps_private.error_buf := 'show_exception_list: '||