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.

SYS.DBMS_REPCAT dependencies on DBMS_UTILITY

Line 627: dblink_table IN dbms_utility.dblink_array,

623: -- exist at the masterdef site with a status of VALID
624: ---------------------------------------------------------------------------
625: PROCEDURE alter_master_propagation(gname IN VARCHAR2,
626: master IN VARCHAR2,
627: dblink_table IN dbms_utility.dblink_array,
628: propagation_mode IN VARCHAR2 :=
629: 'ASYNCHRONOUS',
630: comment IN VARCHAR2 := '');
631:

Line 928: master_table IN dbms_utility.dblink_array,

924: master_list IN VARCHAR2 := NULL,
925: ddl_text IN VARCHAR2);
926:
927: PROCEDURE execute_DDL(gname IN VARCHAR2,
928: master_table IN dbms_utility.dblink_array,
929: ddl_text IN VARCHAR2);
930: -- Executes the DDL provided in ddl_text. The DDL is applied at the given
931: -- set of masters. master_list is a comma-separated list of masters.
932: -- master_table is a PL/SL table of masters. If NULL, it means all masters

Line 1190: column_table IN dbms_utility.lname_array,

1186: send IN BOOLEAN := TRUE);
1187:
1188: PROCEDURE send_old_values(sname IN VARCHAR2,
1189: oname IN VARCHAR2,
1190: column_table IN dbms_utility.lname_array,
1191: operation IN VARCHAR2 := 'UPDATE',
1192: send IN BOOLEAN := TRUE);
1193:
1194: -- Determine whether or not to send old column values for

Line 1248: column_table IN dbms_utility.lname_array,

1244: compare IN BOOLEAN := TRUE);
1245:
1246: PROCEDURE compare_old_values(sname IN VARCHAR2,
1247: oname IN VARCHAR2,
1248: column_table IN dbms_utility.lname_array,
1249: operation IN VARCHAR2 := 'UPDATE',
1250: compare IN BOOLEAN := TRUE);
1251:
1252: -- Determine whether or not to compare old column values for deletes or

Line 1291: column_table IN dbms_utility.name_array);

1287: column_list IN VARCHAR2);
1288:
1289: PROCEDURE set_columns(sname IN VARCHAR2,
1290: oname IN VARCHAR2,
1291: column_table IN dbms_utility.name_array);
1292:
1293: PROCEDURE set_columns(sname IN VARCHAR2,
1294: oname IN VARCHAR2,
1295: column_table IN dbms_utility.lname_array);

Line 1295: column_table IN dbms_utility.lname_array);

1291: column_table IN dbms_utility.name_array);
1292:
1293: PROCEDURE set_columns(sname IN VARCHAR2,
1294: oname IN VARCHAR2,
1295: column_table IN dbms_utility.lname_array);
1296:
1297: -- If oname exists in the replicated object group as a table using
1298: -- column-level replication, record the set of columns to be used as the
1299: -- "primary key" for replication purposes. Unlike true primary keys, these

Line 1387: error_msg_table OUT dbms_utility.uncl_array,

1383: check_genflags IN BOOLEAN := FALSE,
1384: check_valid_objs IN BOOLEAN := FALSE,
1385: check_links_sched IN BOOLEAN := FALSE,
1386: check_links IN BOOLEAN := FALSE,
1387: error_msg_table OUT dbms_utility.uncl_array,
1388: error_num_table OUT dbms_utility.number_array)
1389: RETURN BINARY_INTEGER;
1390: -- Validate the configuration of the specified object group.
1391: -- This procedure should be called from the master definition site

Line 1388: error_num_table OUT dbms_utility.number_array)

1384: check_valid_objs IN BOOLEAN := FALSE,
1385: check_links_sched IN BOOLEAN := FALSE,
1386: check_links IN BOOLEAN := FALSE,
1387: error_msg_table OUT dbms_utility.uncl_array,
1388: error_num_table OUT dbms_utility.number_array)
1389: RETURN BINARY_INTEGER;
1390: -- Validate the configuration of the specified object group.
1391: -- This procedure should be called from the master definition site
1392: -- when check_genflags and check_valide_objs are set to TRUE.

Line 1521: master_table IN dbms_utility.dblink_array);

1517: PROCEDURE remove_master_databases(gname IN VARCHAR2,
1518: master_list IN VARCHAR2);
1519:
1520: PROCEDURE remove_master_databases(gname IN VARCHAR2,
1521: master_table IN dbms_utility.dblink_array);
1522: -- To handle the case where several masters are inaccessible and must be
1523: -- removed at one time, we provide a procedure that deletes a set of
1524: -- masters. Master_list is a comma-separated list of masters.
1525: -- Remove_master_databases does not require any removed database to be

Line 1536: -- If master_table is a PL/SQL table of type dbms_utility.dblink_array -

1532: --
1533: -- remove C, E from RepGroup G at A, B, D
1534: -- remove_master_databases(`G', `C,E');
1535: --
1536: -- If master_table is a PL/SQL table of type dbms_utility.dblink_array -
1537: -- master_table(1) := `C';
1538: -- master_table(2) := `E';
1539: -- remove_master_databases(`G', master_table);
1540: --

Line 1556: result OUT dbms_utility.dblink_array);

1552: -- commfailure: if any remaining master is not accessible.
1553: ---------------------------------------------------------------------------
1554: PROCEDURE comma_to_table(list IN VARCHAR2,
1555: len OUT BINARY_INTEGER,
1556: result OUT dbms_utility.dblink_array);
1557: -- convert a comma-separated list to a PL/SQL table
1558: -- the table is 1-based, increasing, dense, and terminated by a NULL
1559: -- the dbms_utility.comma_to_table procedure cannot handle dblinks
1560: ---------------------------------------------------------------------------

Line 1559: -- the dbms_utility.comma_to_table procedure cannot handle dblinks

1555: len OUT BINARY_INTEGER,
1556: result OUT dbms_utility.dblink_array);
1557: -- convert a comma-separated list to a PL/SQL table
1558: -- the table is 1-based, increasing, dense, and terminated by a NULL
1559: -- the dbms_utility.comma_to_table procedure cannot handle dblinks
1560: ---------------------------------------------------------------------------
1561: PROCEDURE repcat_import_check(gname IN VARCHAR2,
1562: master IN BOOLEAN,
1563: gowner IN VARCHAR2 := 'PUBLIC');

Line 1616: master_table IN dbms_utility.dblink_array);

1612:
1613: ---------------------------------------------------------------------------
1614: PROCEDURE specify_new_masters(
1615: gname IN VARCHAR2,
1616: master_table IN dbms_utility.dblink_array);
1617: ---------------------------------------------------------------------------
1618: -- Please see the comment in the above overloaded version.
1619: --
1620: -- master_table is the set of masters that will be instantiated.

Line 1629: available_master_table IN dbms_utility.dblink_array,

1625:
1626: ---------------------------------------------------------------------------
1627: PROCEDURE add_new_masters(
1628: export_required IN BOOLEAN,
1629: available_master_table IN dbms_utility.dblink_array,
1630: masterdef_flashback_scn OUT NUMBER,
1631: extension_id OUT RAW,
1632: break_trans_to_masterdef IN BOOLEAN := FALSE,
1633: break_trans_to_new_masters IN BOOLEAN := FALSE,

Line 2616: IN dbms_utility.lname_array,

2612: column_group IN VARCHAR2,
2613: sequence_no IN NUMBER,
2614: method IN VARCHAR2,
2615: parameter_column_name
2616: IN dbms_utility.lname_array,
2617: priority_group IN VARCHAR2 := NULL,
2618: function_name IN VARCHAR2 := NULL,
2619: comment IN VARCHAR2 := NULL);
2620:

Line 2717: IN dbms_utility.lname_array,

2713: constraint_name IN VARCHAR2,
2714: sequence_no IN NUMBER,
2715: method IN VARCHAR2,
2716: parameter_column_name
2717: IN dbms_utility.lname_array,
2718: function_name IN VARCHAR2 := NULL,
2719: comment IN VARCHAR2 := NULL);
2720:
2721: PROCEDURE add_unique_resolution(sname IN VARCHAR2,

Line 2912: gnames IN DBMS_UTILITY.NAME_ARRAY,

2908: -- sname: the name of the schema containing the table
2909: -- oname: the name of the table with the column group to be renamed
2910: ---------------------------------------------------------------------------
2911: PROCEDURE streams_migration (
2912: gnames IN DBMS_UTILITY.NAME_ARRAY,
2913: file_location IN VARCHAR2,
2914: filename IN VARCHAR2);
2915: -- This procedure is called at the masterdef site to generate a script
2916: -- that can be run at all the master sites in the repgroup to migrate

Line 2920: -- It is a PL/SQL index-by table of type DBMS_UTILITY.NAME_ARRAY,

2916: -- that can be run at all the master sites in the repgroup to migrate
2917: -- repgroup from a repcat environment to the Streams environment.
2918: -- Input Parameters:
2919: -- gnames: A list of repgroup to be migrated from repcat to Streams env.
2920: -- It is a PL/SQL index-by table of type DBMS_UTILITY.NAME_ARRAY,
2921: -- the index must be 1-based, increasing, dense, and need not
2922: -- be terminated by a NULL. The repgroups listed in gnames
2923: -- must have exactly the same masters.
2924: -- file_location: location of the generated script

Line 2946: indices OUT dbms_utility.number_array);

2942: PROCEDURE order_user_objects(owners IN dbms_repcat.varchar2s,
2943: objects IN dbms_repcat.varchar2s,
2944: types IN dbms_repcat.varchar2s,
2945: len IN BINARY_INTEGER,
2946: indices OUT dbms_utility.number_array);
2947:
2948: PROCEDURE order_user_objects(owners IN VARCHAR2,
2949: objects IN VARCHAR2,
2950: types IN VARCHAR2,

Line 2952: indices OUT dbms_utility.number_array);

2948: PROCEDURE order_user_objects(owners IN VARCHAR2,
2949: objects IN VARCHAR2,
2950: types IN VARCHAR2,
2951: len IN BINARY_INTEGER,
2952: indices OUT dbms_utility.number_array);
2953:
2954: PROCEDURE begin_flavor_definition(
2955: gname IN VARCHAR2,
2956: fname IN VARCHAR2);