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 926: -- dbms_output.put_line('Dropping view '||to_schema||'.'||view_name);

922: ' +++ 923: --
924: -- Try dropping the view
925: begin
926: -- dbms_output.put_line('Dropping view '||to_schema||'.'||view_name);
927: drop_object(to_schema, view_name, 'VIEW');
928: exception
929: when others then
930: raise;

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

3042: if sel_level > max_level then
3043: max_level := sel_level;
3044: end if;
3045:
3046: -- dbms_output.put_line('Add: '||sel_level||' '||sel_type||' '||sel_name);
3047: end if;
3048:
3049: end loop;
3050: -- end loop to get first-level dependencies

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

3116: max_level := sel_level;
3117: end if;
3118: any_added := TRUE;
3119:
3120: -- dbms_output.put_line('Add: '||sel_level||' '||sel_type||' '||sel_name);
3121:
3122: end if;
3123: -- end if added object
3124:

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

3121:
3122: end if;
3123: -- end if added object
3124:
3125: -- dbms_output.put_line('FYI: '||sel_level||' '||sel_type||' '||sel_name);
3126: end if;
3127:
3128: end loop;
3129: -- end loop to fetch dependent objects for one object at this level

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

3144:
3145: -- Debugging output: list all dependent objects and their dependency levels
3146:
3147: -- for i in 1..num_objs loop
3148: -- dbms_output.put_line('Fin: '||obj_levels(i)||' '||
3149: -- obj_types(i)||' '||obj_names(i));
3150: -- end loop;
3151:
3152: -- compile objects by dependency order in dest schema

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

3182: end if;
3183:
3184: -- execute compilation statement
3185:
3186: -- dbms_output.put_line('('||obj_levels(i)||') '||statement);
3187:
3188: begin
3189: ad_apps_private.do_apps_ddl(recompile_schema, statement);
3190: exception

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

3255: procedure show_exception_list
3256: is
3257: i number;
3258: begin
3259: -- initialize dbms_output with large buffer size (200,000)
3260: -- default is 20,000 min is 2,000 max is 1,000,000
3261:
3262: dbms_output.enable(200000);
3263:

Line 3262: dbms_output.enable(200000);

3258: begin
3259: -- initialize dbms_output with large buffer size (200,000)
3260: -- default is 20,000 min is 2,000 max is 1,000,000
3261:
3262: dbms_output.enable(200000);
3263:
3264: -- load exception list, if not already loaded
3265:
3266: load_exception_list;

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

3266: load_exception_list;
3267:
3268: -- display settings
3269:
3270: dbms_output.put_line('-');
3271: dbms_output.put_line(list_count ||' entries in exception list.');
3272: dbms_output.put_line('-');
3273:
3274: i := 1;

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

3267:
3268: -- display settings
3269:
3270: dbms_output.put_line('-');
3271: dbms_output.put_line(list_count ||' entries in exception list.');
3272: dbms_output.put_line('-');
3273:
3274: i := 1;
3275: while i <= list_count loop

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

3268: -- display settings
3269:
3270: dbms_output.put_line('-');
3271: dbms_output.put_line(list_count ||' entries in exception list.');
3272: dbms_output.put_line('-');
3273:
3274: i := 1;
3275: while i <= list_count loop
3276: dbms_output.put_line('['||i||'] Product Short Name: '||

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

3272: dbms_output.put_line('-');
3273:
3274: i := 1;
3275: while i <= list_count loop
3276: dbms_output.put_line('['||i||'] Product Short Name: '||
3277: prod_short_name(i));
3278: dbms_output.put_line('['||i||'] Base Schema Name : '||
3279: base_name(i));
3280: dbms_output.put_line('['||i||'] Base Schema Type : '||

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

3274: i := 1;
3275: while i <= list_count loop
3276: dbms_output.put_line('['||i||'] Product Short Name: '||
3277: prod_short_name(i));
3278: dbms_output.put_line('['||i||'] Base Schema Name : '||
3279: base_name(i));
3280: dbms_output.put_line('['||i||'] Base Schema Type : '||
3281: base_type(i));
3282: dbms_output.put_line('['||i||'] Exception Type : '||

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

3276: dbms_output.put_line('['||i||'] Product Short Name: '||
3277: prod_short_name(i));
3278: dbms_output.put_line('['||i||'] Base Schema Name : '||
3279: base_name(i));
3280: dbms_output.put_line('['||i||'] Base Schema Type : '||
3281: base_type(i));
3282: dbms_output.put_line('['||i||'] Exception Type : '||
3283: exception_type(i));
3284: dbms_output.put_line('['||i||'] Trigger Obj Schema: '||

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

3278: dbms_output.put_line('['||i||'] Base Schema Name : '||
3279: base_name(i));
3280: dbms_output.put_line('['||i||'] Base Schema Type : '||
3281: base_type(i));
3282: dbms_output.put_line('['||i||'] Exception Type : '||
3283: exception_type(i));
3284: dbms_output.put_line('['||i||'] Trigger Obj Schema: '||
3285: trigger_obj_schema(i));
3286: dbms_output.put_line('['||i||'] Trigger Obj Type : '||

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

3280: dbms_output.put_line('['||i||'] Base Schema Type : '||
3281: base_type(i));
3282: dbms_output.put_line('['||i||'] Exception Type : '||
3283: exception_type(i));
3284: dbms_output.put_line('['||i||'] Trigger Obj Schema: '||
3285: trigger_obj_schema(i));
3286: dbms_output.put_line('['||i||'] Trigger Obj Type : '||
3287: trigger_obj_type(i));
3288: dbms_output.put_line('['||i||'] Trigger Obj Name : '||

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

3282: dbms_output.put_line('['||i||'] Exception Type : '||
3283: exception_type(i));
3284: dbms_output.put_line('['||i||'] Trigger Obj Schema: '||
3285: trigger_obj_schema(i));
3286: dbms_output.put_line('['||i||'] Trigger Obj Type : '||
3287: trigger_obj_type(i));
3288: dbms_output.put_line('['||i||'] Trigger Obj Name : '||
3289: trigger_obj_name(i));
3290: dbms_output.put_line('['||i||'] APPS Schema Name : '||

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

3284: dbms_output.put_line('['||i||'] Trigger Obj Schema: '||
3285: trigger_obj_schema(i));
3286: dbms_output.put_line('['||i||'] Trigger Obj Type : '||
3287: trigger_obj_type(i));
3288: dbms_output.put_line('['||i||'] Trigger Obj Name : '||
3289: trigger_obj_name(i));
3290: dbms_output.put_line('['||i||'] APPS Schema Name : '||
3291: apps_name(i));
3292: dbms_output.put_line('['||i||'] APPS Schema Type : '||

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

3286: dbms_output.put_line('['||i||'] Trigger Obj Type : '||
3287: trigger_obj_type(i));
3288: dbms_output.put_line('['||i||'] Trigger Obj Name : '||
3289: trigger_obj_name(i));
3290: dbms_output.put_line('['||i||'] APPS Schema Name : '||
3291: apps_name(i));
3292: dbms_output.put_line('['||i||'] APPS Schema Type : '||
3293: apps_type(i));
3294: dbms_output.put_line('['||i||'] Points to Schema : '||

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

3288: dbms_output.put_line('['||i||'] Trigger Obj Name : '||
3289: trigger_obj_name(i));
3290: dbms_output.put_line('['||i||'] APPS Schema Name : '||
3291: apps_name(i));
3292: dbms_output.put_line('['||i||'] APPS Schema Type : '||
3293: apps_type(i));
3294: dbms_output.put_line('['||i||'] Points to Schema : '||
3295: points_to_schema(i));
3296: dbms_output.put_line('['||i||'] Points to Obj Name: '||

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

3290: dbms_output.put_line('['||i||'] APPS Schema Name : '||
3291: apps_name(i));
3292: dbms_output.put_line('['||i||'] APPS Schema Type : '||
3293: apps_type(i));
3294: dbms_output.put_line('['||i||'] Points to Schema : '||
3295: points_to_schema(i));
3296: dbms_output.put_line('['||i||'] Points to Obj Name: '||
3297: points_to_name(i));
3298: dbms_output.put_line('['||i||']');

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

3292: dbms_output.put_line('['||i||'] APPS Schema Type : '||
3293: apps_type(i));
3294: dbms_output.put_line('['||i||'] Points to Schema : '||
3295: points_to_schema(i));
3296: dbms_output.put_line('['||i||'] Points to Obj Name: '||
3297: points_to_name(i));
3298: dbms_output.put_line('['||i||']');
3299: i := i + 1;
3300: end loop;

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

3294: dbms_output.put_line('['||i||'] Points to Schema : '||
3295: points_to_schema(i));
3296: dbms_output.put_line('['||i||'] Points to Obj Name: '||
3297: points_to_name(i));
3298: dbms_output.put_line('['||i||']');
3299: i := i + 1;
3300: end loop;
3301:
3302: dbms_output.put_line('-');

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

3298: dbms_output.put_line('['||i||']');
3299: i := i + 1;
3300: end loop;
3301:
3302: dbms_output.put_line('-');
3303:
3304: exception
3305: when others then
3306: ad_apps_private.error_buf := 'show_exception_list: '||

Line 4239: -- dbms_output.put_line('statement : <'||c_statement||'>');

4235: dbms_sql.bind_variable(c,'edition_name',p_edition_name,30);
4236: dbms_sql.bind_variable(c,'schema_name',schema_name,30);
4237: dbms_sql.bind_variable(c,'object_type',object_type,30);
4238: dbms_sql.bind_variable(c,'object_name',p_object_name,30);
4239: -- dbms_output.put_line('statement : <'||c_statement||'>');
4240: log_message('done with binding');
4241: dbms_sql.define_column(c,1,l_cnt);
4242: rows_processed := dbms_sql.execute(c);
4243: log_message('done with execute');