Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Example of function to use with DBMS_REPCAT.ADD_DELETE_RESOLUTION

Re: Example of function to use with DBMS_REPCAT.ADD_DELETE_RESOLUTION

From: Edzard <edzard_at_volcanomail.com>
Date: 16 Apr 2002 08:37:17 -0700
Message-ID: <5d75e934.0204160737.4d0459d4@posting.google.com> 





"cf" <news_at_sitinfo.com> wrote in message news:<3cbaa766$0$204$4d4eb98e_at_read.news.fr.uu.net>...

> Hi,
> 
> I seek an example of user function to use with
> DBMS_REPCAT.ADD_DELETE_RESOLUTION
> 
> Thanks in advance
> 
> Christophe

-- rep4.sql:




-- Main install-script for adding replication conflict resolution.
-- Needed for tables that are subject to delete cascade constraints.




SET ECHO ON



SPOOL rep4


/*



--The following procedures need to be executed by the replication
administrator.


CONNECT repadmin_at_varprod.no.jotankers.com
PAUSE



@rep4a


PAUSE



@rep4b


PAUSE



CONNECT repadmin_at_varprod.nl.jotankers.com
PAUSE



@rep4a


PAUSE



@rep4b


PAUSE



--Before you can define any conflict resolution methods, quiesce the 
--master group that contains the table to which you want to apply the 
--conflict resolution method.





BEGIN



   DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY (

      gname => 'QMS_MG');


END;



/



PAUSE



*/



@rep4c


PAUSE



@rep4d


PAUSE




--After replication support has been regenerated, resume replication
--activity by using the RESUME_MASTER_ACTIVITY procedure API.



BEGIN



   DBMS_REPCAT.RESUME_MASTER_ACTIVITY (



      gname => 'QMS_MG');


END;



/




PAUSE










create or replace package joresolve


is


/* Edzard, 23 august 2001



    Needed a dummy function for  replication conflict resolution
*/


  FUNCTION REJTANK_REASONS_delete (


      rejt_ves_dept_nr in number, rejt_report_date in date,
rejt_report_nr in number, rejt_seq_nr in number, rejt_cat_id in
number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION CARGO_QUALITIES_delete (


      qual_ves_dept_nr in number, qual_report_date in date,
qual_report_nr in number, qual_seq_nr in number, qual_cat_id in
number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION PERS_OPERATION_delete (


      oper_ves_dept_nr in number, oper_report_date in date,
oper_report_nr in number, oper_seq_nr in number, oper_cat_id in
number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION PERS_INJTYPE_delete (


      injtype_ves_dept_nr in number, injtype_report_date in date,
injtype_report_nr in number, injtype_seq_nr in number, injtype_cat_id
in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION PERS_INJURPART_delete (


      injpart_ves_dept_nr in number, injpart_report_date in date,
injpart_report_nr in number, injpart_seq_nr in number, injpart_cat_id
in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION PERS_ACCTYPE_delete (


      acctype_ves_dept_nr in number, acctype_report_date in date,
acctype_report_nr in number, acctype_seq_nr in number, acctype_cat_id
in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION ENVIR_POLLTYPE_delete (


      polltype_ves_dept_nr in number, polltype_report_date in date,
polltype_report_nr in number, polltype_seq_nr in number,
polltype_cat_id in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION POLL_PRODUCT_delete (


      prod_ves_dept_nr in number, prod_report_date in date,
prod_report_nr in number, prod_seq_nr in number, prod_cat_id in
number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION CUST_REMARK_delete (


      remark_vesdept_nr in number, remark_report_date in date,
remark_report_nr in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION REMARK_CATEGORY_delete (


      remark_vesdept_nr in number, remark_report_date in date,
remark_report_nr in number, cat_id in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION REJECT_TANKS_delete (


      rejtank_ves_dept_nr in number, rejtank_report_date in date,
rejtank_report_nr in number, rejtank_seq_nr in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION FINANCIAL_INFO_delete (


      fin_vesdept_nr in number, fin_report_date in date, fin_report_nr
in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION POLLUTION_delete (


      poll_ves_dept_nr in number, poll_report_date in date,
poll_report_nr in number, poll_seq_nr in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION INC_THIRDPAR_DAMAG_delete (


      party_ves_dept_nr in number, party_report_date in date,
party_report_nr in number, party_cat_id in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION NON_CONFORMANCE_delete (


      nonconf_vesdept_nr in number, nonconf_report_date in date,
nonconf_report_nr in number, nonconf_cat_id in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION INC_JOBFACT_delete (


      jobfact_ves_dept_nr in number, jobfact_report_date in date,
jobfact_report_nr in number, jobfact_priority in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION INSPECTIONS_delete (


      inspec_vesdept_nr in number, inspec_report_date in date,
inspec_report_nr in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION INJUR_PERSON_delete (


      person_ves_dept_nr in number, person_report_date in date,
person_report_nr in number, person_seq_nr in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION IMPROVEMENTS_delete (


      impr_vesdept_nr in number, impr_report_date in date,
impr_report_nr in number, impr_cat_id in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION INC_HUMFACT_delete (


      humfact_ves_dept_nr in number, humfact_report_date in date,
humfact_report_nr in number, humfact_priority in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION INC_HUMACT_delete (


      humact_ves_dept_nr in number, humact_report_date in date,
humact_report_nr in number, humact_priority in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION INC_EQUIP_DAMAG_delete (


      equip_ves_dept_nr in number, equip_report_date in date,
equip_report_nr in number, equip_cat_id in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION INC_CONDITIONS_delete (


      cond_ves_dept_nr in number, cond_report_date in date,
cond_report_nr in number, cond_priority in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION CARGO_INCIDENT_delete (


      cargo_ves_dept_nr in number, cargo_report_date in date,
cargo_report_nr in number, cargo_seq_nr in number,


      kc IN OUT BOOLEAN) RETURN BOOLEAN;
  FUNCTION QMS_PASS_delete (

      employee_nr in number,
      kc IN OUT BOOLEAN) RETURN BOOLEAN;


END;



/



SHOW ERROR







CREATE OR REPLACE PACKAGE BODY joresolve
IS


/* Edzard, 23 august 2001



    Needed a dummy function for  replication conflict resolution
*/


  FUNCTION REJTANK_REASONS_delete (


      rejt_ves_dept_nr in number, rejt_report_date in date,
rejt_report_nr in number, rejt_seq_nr in number, rejt_cat_id in
number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION CARGO_QUALITIES_delete (


      qual_ves_dept_nr in number, qual_report_date in date,
qual_report_nr in number, qual_seq_nr in number, qual_cat_id in
number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION PERS_OPERATION_delete (


      oper_ves_dept_nr in number, oper_report_date in date,
oper_report_nr in number, oper_seq_nr in number, oper_cat_id in
number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION PERS_INJTYPE_delete (


      injtype_ves_dept_nr in number, injtype_report_date in date,
injtype_report_nr in number, injtype_seq_nr in number, injtype_cat_id
in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION PERS_INJURPART_delete (


      injpart_ves_dept_nr in number, injpart_report_date in date,
injpart_report_nr in number, injpart_seq_nr in number, injpart_cat_id
in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION PERS_ACCTYPE_delete (


      acctype_ves_dept_nr in number, acctype_report_date in date,
acctype_report_nr in number, acctype_seq_nr in number, acctype_cat_id
in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION ENVIR_POLLTYPE_delete (


      polltype_ves_dept_nr in number, polltype_report_date in date,
polltype_report_nr in number, polltype_seq_nr in number,
polltype_cat_id in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION POLL_PRODUCT_delete (


      prod_ves_dept_nr in number, prod_report_date in date,
prod_report_nr in number, prod_seq_nr in number, prod_cat_id in
number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION CUST_REMARK_delete (


      remark_vesdept_nr in number, remark_report_date in date,
remark_report_nr in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION REMARK_CATEGORY_delete (


      remark_vesdept_nr in number, remark_report_date in date,
remark_report_nr in number, cat_id in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION REJECT_TANKS_delete (


      rejtank_ves_dept_nr in number, rejtank_report_date in date,
rejtank_report_nr in number, rejtank_seq_nr in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION FINANCIAL_INFO_delete (


      fin_vesdept_nr in number, fin_report_date in date, fin_report_nr
in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION POLLUTION_delete (


      poll_ves_dept_nr in number, poll_report_date in date,
poll_report_nr in number, poll_seq_nr in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION INC_THIRDPAR_DAMAG_delete (


      party_ves_dept_nr in number, party_report_date in date,
party_report_nr in number, party_cat_id in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION NON_CONFORMANCE_delete (


      nonconf_vesdept_nr in number, nonconf_report_date in date,
nonconf_report_nr in number, nonconf_cat_id in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION INC_JOBFACT_delete (


      jobfact_ves_dept_nr in number, jobfact_report_date in date,
jobfact_report_nr in number, jobfact_priority in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION INSPECTIONS_delete (


      inspec_vesdept_nr in number, inspec_report_date in date,
inspec_report_nr in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION INJUR_PERSON_delete (


      person_ves_dept_nr in number, person_report_date in date,
person_report_nr in number, person_seq_nr in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION INCIDENTS_delete (


      inc_ves_dept_nr in number, inc_report_date in date,
inc_report_nr in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION IMPROVEMENTS_delete (


      impr_vesdept_nr in number, impr_report_date in date,
impr_report_nr in number, impr_cat_id in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION INC_HUMFACT_delete (


      humfact_ves_dept_nr in number, humfact_report_date in date,
humfact_report_nr in number, humfact_priority in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION INC_HUMACT_delete (


      humact_ves_dept_nr in number, humact_report_date in date,
humact_report_nr in number, humact_priority in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION INC_EQUIP_DAMAG_delete (


      equip_ves_dept_nr in number, equip_report_date in date,
equip_report_nr in number, equip_cat_id in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION INC_CONDITIONS_delete (


      cond_ves_dept_nr in number, cond_report_date in date,
cond_report_nr in number, cond_priority in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION CARGO_INCIDENT_delete (


      cargo_ves_dept_nr in number, cargo_report_date in date,
cargo_report_nr in number, cargo_seq_nr in number,

      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



  FUNCTION QMS_PASS_delete (

      employee_nr in number,
      kc IN OUT BOOLEAN) RETURN BOOLEAN
      IS




  BEGIN



    RETURN TRUE;



  END;



END;



/



SHOW ERROR







BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'REJTANK_REASONS',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'REJTANK_REASONS',


sequence_no => 1,


parameter_column_name =>


'REJT_VES_DEPT_NR,REJT_REPORT_DATE,REJT_REPORT_NR,REJT_SEQ_NR,REJT_CAT_ID',

function_name => 'repadmin.joresolve.REJTANK_REASONS_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'CARGO_QUALITIES',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'CARGO_QUALITIES',


sequence_no => 1,


parameter_column_name =>


'QUAL_VES_DEPT_NR,QUAL_REPORT_DATE,QUAL_REPORT_NR,QUAL_SEQ_NR,QUAL_CAT_ID',

function_name => 'repadmin.joresolve.CARGO_QUALITIES_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'PERS_OPERATION',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'PERS_OPERATION',


sequence_no => 1,


parameter_column_name =>


'OPER_VES_DEPT_NR,OPER_REPORT_DATE,OPER_REPORT_NR,OPER_SEQ_NR,OPER_CAT_ID',

function_name => 'repadmin.joresolve.PERS_OPERATION_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'PERS_INJTYPE',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'PERS_INJTYPE',


sequence_no => 1,


parameter_column_name =>


'INJTYPE_VES_DEPT_NR,INJTYPE_REPORT_DATE,INJTYPE_REPORT_NR,INJTYPE_SEQ_NR,INJTYPE_CAT_ID',

function_name => 'repadmin.joresolve.PERS_INJTYPE_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'PERS_INJURPART',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'PERS_INJURPART',


sequence_no => 1,


parameter_column_name =>


'INJPART_VES_DEPT_NR,INJPART_REPORT_DATE,INJPART_REPORT_NR,INJPART_SEQ_NR,INJPART_CAT_ID',

function_name => 'repadmin.joresolve.PERS_INJURPART_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'PERS_ACCTYPE',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'PERS_ACCTYPE',


sequence_no => 1,


parameter_column_name =>


'ACCTYPE_VES_DEPT_NR,ACCTYPE_REPORT_DATE,ACCTYPE_REPORT_NR,ACCTYPE_SEQ_NR,ACCTYPE_CAT_ID',

function_name => 'repadmin.joresolve.PERS_ACCTYPE_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'ENVIR_POLLTYPE',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'ENVIR_POLLTYPE',


sequence_no => 1,


parameter_column_name =>


'POLLTYPE_VES_DEPT_NR,POLLTYPE_REPORT_DATE,POLLTYPE_REPORT_NR,POLLTYPE_SEQ_NR,POLLTYPE_CAT_ID',

function_name => 'repadmin.joresolve.ENVIR_POLLTYPE_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'POLL_PRODUCT',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'POLL_PRODUCT',


sequence_no => 1,


parameter_column_name =>


'PROD_VES_DEPT_NR,PROD_REPORT_DATE,PROD_REPORT_NR,PROD_SEQ_NR,PROD_CAT_ID',

function_name => 'repadmin.joresolve.POLL_PRODUCT_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'CUST_REMARK',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'CUST_REMARK',


sequence_no => 1,


parameter_column_name =>


'REMARK_VESDEPT_NR,REMARK_REPORT_DATE,REMARK_REPORT_NR',

function_name => 'repadmin.joresolve.CUST_REMARK_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'REMARK_CATEGORY',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'REMARK_CATEGORY',


sequence_no => 1,


parameter_column_name =>


'REMARK_VESDEPT_NR,REMARK_REPORT_DATE,REMARK_REPORT_NR,CAT_ID',

function_name => 'repadmin.joresolve.REMARK_CATEGORY_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'REJECT_TANKS',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'REJECT_TANKS',


sequence_no => 1,


parameter_column_name =>


'REJTANK_VES_DEPT_NR,REJTANK_REPORT_DATE,REJTANK_REPORT_NR,REJTANK_SEQ_NR',

function_name => 'repadmin.joresolve.REJECT_TANKS_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'FINANCIAL_INFO',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'FINANCIAL_INFO',


sequence_no => 1,


parameter_column_name =>


'FIN_VESDEPT_NR,FIN_REPORT_DATE,FIN_REPORT_NR',

function_name => 'repadmin.joresolve.FINANCIAL_INFO_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'POLLUTION',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'POLLUTION',


sequence_no => 1,


parameter_column_name =>


'POLL_VES_DEPT_NR,POLL_REPORT_DATE,POLL_REPORT_NR,POLL_SEQ_NR',

function_name => 'repadmin.joresolve.POLLUTION_delete');
END;



/






BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INC_THIRDPAR_DAMAG',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INC_THIRDPAR_DAMAG',


sequence_no => 1,


parameter_column_name =>


'PARTY_VES_DEPT_NR,PARTY_REPORT_DATE,PARTY_REPORT_NR,PARTY_CAT_ID',

function_name => 'repadmin.joresolve.INC_THIRDPAR_DAMAG_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'NON_CONFORMANCE',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'NON_CONFORMANCE',


sequence_no => 1,


parameter_column_name =>


'NONCONF_VESDEPT_NR,NONCONF_REPORT_DATE,NONCONF_REPORT_NR,NONCONF_CAT_ID',

function_name => 'repadmin.joresolve.NON_CONFORMANCE_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INC_JOBFACT',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INC_JOBFACT',


sequence_no => 1,


parameter_column_name =>


'JOBFACT_VES_DEPT_NR,JOBFACT_REPORT_DATE,JOBFACT_REPORT_NR,JOBFACT_PRIORITY',

function_name => 'repadmin.joresolve.INC_JOBFACT_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INSPECTIONS',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INSPECTIONS',


sequence_no => 1,


parameter_column_name =>


'INSPEC_VESDEPT_NR,INSPEC_REPORT_DATE,INSPEC_REPORT_NR',

function_name => 'repadmin.joresolve.INSPECTIONS_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INJUR_PERSON',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INJUR_PERSON',


sequence_no => 1,


parameter_column_name =>


'PERSON_VES_DEPT_NR,PERSON_REPORT_DATE,PERSON_REPORT_NR,PERSON_SEQ_NR',

function_name => 'repadmin.joresolve.INJUR_PERSON_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INCIDENTS',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INCIDENTS',


sequence_no => 1,


parameter_column_name =>


'INC_VES_DEPT_NR,INC_REPORT_DATE,INC_REPORT_NR',

function_name => 'repadmin.joresolve.INCIDENTS_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'IMPROVEMENTS',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'IMPROVEMENTS',


sequence_no => 1,


parameter_column_name =>


'IMPR_VESDEPT_NR,IMPR_REPORT_DATE,IMPR_REPORT_NR,IMPR_CAT_ID',

function_name => 'repadmin.joresolve.IMPROVEMENTS_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INC_HUMFACT',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INC_HUMFACT',


sequence_no => 1,


parameter_column_name =>


'HUMFACT_VES_DEPT_NR,HUMFACT_REPORT_DATE,HUMFACT_REPORT_NR,HUMFACT_PRIORITY',

function_name => 'repadmin.joresolve.INC_HUMFACT_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INC_HUMACT',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INC_HUMACT',


sequence_no => 1,


parameter_column_name =>


'HUMACT_VES_DEPT_NR,HUMACT_REPORT_DATE,HUMACT_REPORT_NR,HUMACT_PRIORITY',

function_name => 'repadmin.joresolve.INC_HUMACT_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INC_EQUIP_DAMAG',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INC_EQUIP_DAMAG',


sequence_no => 1,


parameter_column_name =>


'EQUIP_VES_DEPT_NR,EQUIP_REPORT_DATE,EQUIP_REPORT_NR,EQUIP_CAT_ID',

function_name => 'repadmin.joresolve.INC_EQUIP_DAMAG_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INC_CONDITIONS',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'INC_CONDITIONS',


sequence_no => 1,


parameter_column_name =>


'COND_VES_DEPT_NR,COND_REPORT_DATE,COND_REPORT_NR,COND_PRIORITY',

function_name => 'repadmin.joresolve.INC_CONDITIONS_delete');
END;



/




BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'CARGO_INCIDENT',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'CARGO_INCIDENT',


sequence_no => 1,


parameter_column_name =>


'CARGO_VES_DEPT_NR,CARGO_REPORT_DATE,CARGO_REPORT_NR,CARGO_SEQ_NR',

function_name => 'repadmin.joresolve.CARGO_INCIDENT_delete');
END;



/






BEGIN



DBMS_REPCAT.DROP_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'QMS_PASS',


sequence_no => 1);


END;



/




BEGIN



DBMS_REPCAT.ADD_DELETE_RESOLUTION (



sname => 'QMS',


oname => 'QMS_PASS',


sequence_no => 1,


parameter_column_name => 'EMPLOYEE_NR',


function_name => 'repadmin.joresolve.QMS_PASS_delete');
END;



/









BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'REJTANK_REASONS',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'CARGO_QUALITIES',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'PERS_OPERATION',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'PERS_INJTYPE',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'PERS_INJURPART',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'PERS_ACCTYPE',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'ENVIR_POLLTYPE',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'POLL_PRODUCT',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'CUST_REMARK',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'REMARK_CATEGORY',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'REJECT_TANKS',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'FINANCIAL_INFO',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'POLLUTION',


type => 'TABLE',


min_communication => TRUE);


END;



/






BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'INC_THIRDPAR_DAMAG',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'NON_CONFORMANCE',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'INC_JOBFACT',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'INSPECTIONS',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'INJUR_PERSON',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'INCIDENTS',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'IMPROVEMENTS',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'INC_HUMFACT',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'INC_HUMACT',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'INC_EQUIP_DAMAG',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'INC_CONDITIONS',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'CARGO_INCIDENT',


type => 'TABLE',


min_communication => TRUE);


END;



/




BEGIN



DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

sname => 'QMS',


oname => 'QMS_PASS',


type => 'TABLE',


min_communication => TRUE);


END;



/





Received on Tue Apr 16 2002 - 10:37:17 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US